Joomla!-Debug-Konsole

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

54 ausgeführte Abfragen 415.55 ms

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

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

   Erklären

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

   Profil (Profile)

   Status	Duration
   Starting	0.13 ms
   checking permissions	0.04 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.13 ms
   Updating	0.28 ms
   End of update loop	0.03 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.08 ms
   closing tables	0.03 ms
   Query end	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
   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: 10.14 ms Nach letzter Abfrage: 1.72 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 0.737 MB Zeilen zurückgegeben: 0

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

   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.10 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.03 ms
   init	0.05 ms
   Optimizing	0.04 ms
   Statistics	0.10 ms
   Preparing	0.03 ms
   Executing	0.03 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 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
   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: 19.93 ms Nach letzter Abfrage: 3.81 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 0.755 MB Zeilen zurückgegeben: 0

   SELECT `session_id`
   
     FROM `dof0p_session`
   
     WHERE `session_id` = 'pcf1vuncb2dh0s75g1pq7p6em6' 
     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.11 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.03 ms
   init	0.05 ms
   Optimizing	0.04 ms
   Statistics	0.11 ms
   Preparing	0.03 ms
   Executing	0.03 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 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
   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.99 ms Nach letzter Abfrage: 0.47 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 0.762 MB

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

   Erklären

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

   Profil (Profile)

   Status	Duration
   Starting	0.16 ms
   checking permissions	0.03 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.05 ms
   Update	0.17 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.07 ms
   closing tables	0.03 ms
   Query end	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
   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: 2.04 ms Nach letzter Abfrage: 30.79 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 0.788 MB Zeilen zurückgegeben: 42

   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	35	Using index condition

   Profil (Profile)

   Status	Duration
   Starting	0.13 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.06 ms
   Optimizing	0.04 ms
   Statistics	0.16 ms
   Preparing	0.06 ms
   Executing	0.02 ms
   Sending data	0.81 ms
   End of update loop	0.03 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	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
   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: 12.22 ms Nach letzter Abfrage: 31.53 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 0.833 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.13 ms
   checking permissions	0.03 ms
   Opening tables	0.05 ms
   After opening tables	0.03 ms
   System lock	0.02 ms
   table lock	0.03 ms
   init	0.05 ms
   Optimizing	0.04 ms
   Statistics	0.04 ms
   Preparing	0.05 ms
   Executing	0.02 ms
   Sending data	0.08 ms
   End of update loop	0.03 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.03 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.04 ms
   Reset for next command	0.21 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.90 ms Nach letzter Abfrage: 0.36 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 0.847 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.07 ms
   checking permissions	0.04 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.03 ms
   Optimizing	0.13 ms
   Statistics	0.09 ms
   Preparing	0.02 ms
   Unlocking tables	0.01 ms
   Preparing	0.04 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
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.02 ms
   Query end	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
   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: 11.68 ms Nach letzter Abfrage: 1.30 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 0.932 MB Zeilen zurückgegeben: 97

   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	245	Using where; filesort wurde genutzt

   Profil (Profile)

   Status	Duration
   Starting	0.11 ms
   checking permissions	0.03 ms
   Opening tables	0.13 ms
   After opening tables	0.03 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.07 ms
   Optimizing	0.06 ms
   Statistics	0.14 ms
   Preparing	0.05 ms
   Sorting result	0.03 ms
   Executing	0.02 ms
   Sending data	0.03 ms
   Creating sort index	1.84 ms
   End of update loop	0.03 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.01 ms
   closing tables	0.02 ms
   Query end	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: 6.52 ms Nach letzter Abfrage: 263.24 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 1.361 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.10 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.04 ms
   Optimizing	0.07 ms
   Statistics	0.05 ms
   Preparing	0.04 ms
   Executing	0.02 ms
   Sending data	0.07 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.01 ms
   closing tables	0.02 ms
   Query end	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
   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.88 ms Nach letzter Abfrage: 0.37 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 1.371 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.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.06 ms
    Optimizing	0.05 ms
    Statistics	0.06 ms
    Preparing	0.05 ms
    Executing	0.02 ms
    Sending data	0.08 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	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
    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: 56.55 ms Nach letzter Abfrage: 108.20 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.518 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.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.03 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.10 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	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
    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.53 ms Nach letzter Abfrage: 244.65 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 1.861 MB Zeilen zurückgegeben: 127
    Doppelte Abfragen: #21  #53

    SHOW TABLES

    Erklären

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

    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.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.02 ms
    Filling schema table	0.02 ms
    checking permissions	0.58 ms
    Executing	0.03 ms
    Sending data	0.10 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Removing tmp table	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 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
    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: 1.06 ms Nach letzter Abfrage: 90.87 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 1.885 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 <= '2024-11-21 07:26:42'

    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.13 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.06 ms
    Optimizing	0.05 ms
    Statistics	0.12 ms
    Preparing	0.06 ms
    Executing	0.02 ms
    Sending data	0.09 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 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
    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.84 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 1.892 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 <= '2024-11-21 07:26:42'

    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.06 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.06 ms
    Optimizing	0.04 ms
    Statistics	0.07 ms
    Preparing	0.05 ms
    Executing	0.02 ms
    Sending data	0.06 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	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
    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: 7.39 ms Nach letzter Abfrage: 29.03 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 1.886 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.09 ms
    checking permissions	0.02 ms
    closing tables	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.81 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.03 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Filling schema table	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    checking permissions	5.27 ms
    closing tables	0.04 ms
    checking permissions	0.02 ms
    Executing	0.01 ms
    Sending data	0.09 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.01 ms
    Removing tmp table	0.31 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 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: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: 5.69 ms Nach letzter Abfrage: 47.72 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.931 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.09 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.06 ms
    Optimizing	0.04 ms
    Statistics	0.20 ms
    Preparing	0.07 ms
    Executing	0.02 ms
    Sending data	0.07 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	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
    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: 6.57 ms Nach letzter Abfrage: 0.48 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 1.942 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.07 ms
    checking permissions	0.02 ms
    Opening tables	0.03 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.07 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.04 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 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
    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.97 ms Nach letzter Abfrage: 0.50 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.949 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.10 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.03 ms
    Optimizing	0.04 ms
    Statistics	0.20 ms
    Preparing	0.05 ms
    Executing	0.02 ms
    Sending data	0.08 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 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
    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.78 ms Nach letzter Abfrage: 0.41 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 1.957 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.05 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.02 ms
    Executing	0.02 ms
    Sending data	0.04 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	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/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: 12.62 ms Nach letzter Abfrage: 3684.85 ms Abfragespeichernutzung: 0.206 MB Speichernutzung vor Abfrage: 2.220 MB Zeilen zurückgegeben: 144

    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.14 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.04 ms
    init	0.05 ms
    Optimizing	0.05 ms
    Statistics	0.14 ms
    Preparing	0.07 ms
    Sorting result	0.03 ms
    Executing	0.02 ms
    Sending data	0.04 ms
    Creating sort index	6.82 ms
    End of update loop	0.05 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	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
    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: 25.45 ms Nach letzter Abfrage: 178.73 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 3.004 MB Zeilen zurückgegeben: 127
    Doppelte Abfragen: #12  #53

    SHOW TABLES

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.03 ms
    Opening tables	0.07 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.04 ms
    Executing	0.02 ms
    Filling schema table	0.02 ms
    checking permissions	0.64 ms
    Executing	0.02 ms
    Sending data	0.10 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Removing tmp table	0.03 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	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/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: 1.09 ms Nach letzter Abfrage: 1.80 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 3.032 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.08 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.04 ms
    Optimizing	0.05 ms
    Statistics	0.28 ms
    Preparing	0.07 ms
    Executing	0.02 ms
    Sending data	0.09 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 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
    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.87 ms Nach letzter Abfrage: 0.55 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 3.025 MB

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

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.04 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init for update	0.19 ms
    Updating	0.12 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.04 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.04 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: 15.05 ms Nach letzter Abfrage: 2.89 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 3.064 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.07 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.03 ms
    Statistics	0.07 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.02 ms
    Executing	0.02 ms
    Sending data	0.04 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 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
    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: 1.43 ms Nach letzter Abfrage: 1.00 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.079 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.12 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.05 ms
    init	0.05 ms
    Optimizing	0.06 ms
    Statistics	0.17 ms
    Preparing	0.08 ms
    Executing	0.02 ms
    Sending data	0.31 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 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: 7.76 ms Nach letzter Abfrage: 39.29 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 3.138 MB Zeilen zurückgegeben: 42

    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_jnews','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	43	Using index condition

    Profil (Profile)

    Status	Duration
    Starting	0.14 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.08 ms
    Optimizing	0.04 ms
    Statistics	0.20 ms
    Preparing	0.05 ms
    Executing	0.02 ms
    Sending data	1.05 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 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
    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: 15.29 ms Nach letzter Abfrage: 4.67 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 3.206 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.07 ms
    checking permissions	0.02 ms
    closing tables	0.01 ms
    checking permissions	0.02 ms
    Opening tables	0.74 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.02 ms
    Filling schema table	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    checking permissions	0.23 ms
    closing tables	0.03 ms
    checking permissions	0.02 ms
    Executing	0.02 ms
    Sending data	0.11 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Removing tmp table	0.27 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	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
    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: 12.63 ms Nach letzter Abfrage: 6.67 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 3.341 MB Zeilen zurückgegeben: 1

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

    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.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.06 ms
    Optimizing	0.03 ms
    Statistics	0.09 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.06 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 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
    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.92 ms Nach letzter Abfrage: 0.59 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 3.351 MB

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

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init for update	0.08 ms
    Updating	0.28 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.04 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.02 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: 14.64 ms Nach letzter Abfrage: 5.11 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 3.377 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 = 606 
      AND c.published > 0 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-21 06:26:46') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-21 06:26:46') 
      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.21 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.03 ms
    init	0.11 ms
    Optimizing	0.10 ms
    Statistics	0.27 ms
    Preparing	0.03 ms
    Unlocking tables	0.02 ms
    Preparing	0.04 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
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.04 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/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: 20.45 ms Nach letzter Abfrage: 7.01 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 3.428 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=20
    
      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.21 ms
    checking permissions	0.05 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.10 ms
    Optimizing	0.07 ms
    Statistics	0.21 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.05 ms
    Sorting result	0.05 ms
    Executing	0.02 ms
    Sending data	0.04 ms
    Creating sort index	0.18 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.04 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/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: 3.41 ms Nach letzter Abfrage: 1.60 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 3.463 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` = 606 
      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.13 ms
    checking permissions	0.03 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.06 ms
    Statistics	0.08 ms
    Preparing	0.02 ms
    Executing	0.05 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 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
    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: 8.79 ms Nach letzter Abfrage: 24.06 ms Abfragespeichernutzung: 0.042 MB Speichernutzung vor Abfrage: 3.596 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 (20,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	const	PRIMARY	PRIMARY	4	const	1
    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.27 ms
    checking permissions	0.03 ms
    Opening tables	0.13 ms
    After opening tables	0.03 ms
    System lock	0.03 ms
    table lock	0.03 ms
    init	0.12 ms
    Optimizing	0.10 ms
    Statistics	0.23 ms
    Preparing	0.12 ms
    Sorting result	0.05 ms
    Executing	0.03 ms
    Sending data	0.05 ms
    Creating sort index	0.11 ms
    End of update loop	0.03 ms
    Query end	0.03 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Query end	0.02 ms
    Starting cleanup	0.02 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
    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: 14.50 ms Nach letzter Abfrage: 274.86 ms Abfragespeichernutzung: 0.152 MB Speichernutzung vor Abfrage: 4.133 MB Zeilen zurückgegeben: 171

    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 <= '2024-11-21 06:26:46') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-21 06:26:46') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 477 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	ref	PRIMARY,published,newsfeeds	published	6	const,const	48	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.20 ms
    checking permissions	0.03 ms
    Opening tables	0.06 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.09 ms
    Optimizing	0.09 ms
    Statistics	0.15 ms
    Preparing	0.11 ms
    Sorting result	0.04 ms
    Executing	0.02 ms
    Sending data	0.03 ms
    Creating sort index	4.58 ms
    End of update loop	0.05 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.03 ms
    Reset for next command	0.05 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-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
    11	Warp\Joomla\Helper\WidgetsHelper->count()	JROOT/templates/jp-school/layouts/theme.config.php:28
    10	include JROOT/templates/jp-school/layouts/theme.config.php	JROOT/templates/jp-school/layouts/theme.php:10
    9	include JROOT/templates/jp-school/layouts/theme.php	JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-school/index.php:16
    7	require JROOT/templates/jp-school/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: 6.40 ms Nach letzter Abfrage: 86.05 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 4.427 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.21 ms
    checking permissions	0.02 ms
    Opening tables	0.05 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.19 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.06 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    Creating sort index	0.23 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.03 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
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    18	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    17	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    16	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:68
    15	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28
    14	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-school/layouts/theme.config.php:74
    10	include JROOT/templates/jp-school/layouts/theme.config.php	JROOT/templates/jp-school/layouts/theme.php:10
    9	include JROOT/templates/jp-school/layouts/theme.php	JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-school/index.php:16
    7	require JROOT/templates/jp-school/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.68 ms Nach letzter Abfrage: 0.90 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 4.451 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	921	Using where

    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.02 ms
    table lock	0.02 ms
    init	0.04 ms
    Optimizing	0.04 ms
    Statistics	0.13 ms
    Preparing	0.05 ms
    Executing	0.02 ms
    Sending data	0.88 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:357
    21	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:224
    20	JAccess::preload()	JROOT/libraries/joomla/access/access.php:538
    19	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
    18	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    17	JUser->authorise()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:56
    16	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:68
    15	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28
    14	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-school/layouts/theme.config.php:74
    10	include JROOT/templates/jp-school/layouts/theme.config.php	JROOT/templates/jp-school/layouts/theme.php:10
    9	include JROOT/templates/jp-school/layouts/theme.php	JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-school/index.php:16
    7	require JROOT/templates/jp-school/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.42 ms Nach letzter Abfrage: 0.99 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 4.483 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.17 ms
    checking permissions	0.02 ms
    Opening tables	0.06 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.09 ms
    Optimizing	0.06 ms
    Statistics	0.24 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.06 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    Creating sort index	0.23 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    18	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    17	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    16	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:68
    15	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28
    14	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-school/layouts/theme.config.php:74
    10	include JROOT/templates/jp-school/layouts/theme.config.php	JROOT/templates/jp-school/layouts/theme.php:10
    9	include JROOT/templates/jp-school/layouts/theme.php	JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-school/index.php:16
    7	require JROOT/templates/jp-school/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: 1.20 ms Nach letzter Abfrage: 1.07 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 4.509 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.14 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.07 ms
    Optimizing	0.05 ms
    Statistics	0.15 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.04 ms
    Creating sort index	0.21 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	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
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    18	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    17	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    16	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:68
    15	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28
    14	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-school/layouts/theme.config.php:74
    10	include JROOT/templates/jp-school/layouts/theme.config.php	JROOT/templates/jp-school/layouts/theme.php:10
    9	include JROOT/templates/jp-school/layouts/theme.php	JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-school/index.php:16
    7	require JROOT/templates/jp-school/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: 3.46 ms Nach letzter Abfrage: 0.84 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 4.530 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.16 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.07 ms
    Optimizing	0.05 ms
    Statistics	0.15 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.05 ms
    Creating sort index	0.28 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	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
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    18	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    17	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    16	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:68
    15	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28
    14	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-school/layouts/theme.config.php:74
    10	include JROOT/templates/jp-school/layouts/theme.config.php	JROOT/templates/jp-school/layouts/theme.php:10
    9	include JROOT/templates/jp-school/layouts/theme.php	JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-school/index.php:16
    7	require JROOT/templates/jp-school/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: 4.33 ms Nach letzter Abfrage: 1.02 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 4.552 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.18 ms
    checking permissions	0.04 ms
    Opening tables	0.04 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.19 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.06 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    Creating sort index	0.23 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.04 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    18	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    17	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    16	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:68
    15	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28
    14	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-school/layouts/theme.config.php:74
    10	include JROOT/templates/jp-school/layouts/theme.config.php	JROOT/templates/jp-school/layouts/theme.php:10
    9	include JROOT/templates/jp-school/layouts/theme.php	JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-school/index.php:16
    7	require JROOT/templates/jp-school/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.39 ms Nach letzter Abfrage: 0.93 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 4.575 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.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.08 ms
    Optimizing	0.06 ms
    Statistics	0.19 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.06 ms
    Sorting result	0.04 ms
    Executing	0.02 ms
    Sending data	0.04 ms
    Creating sort index	0.28 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	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
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    18	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    17	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    16	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:68
    15	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28
    14	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-school/layouts/theme.config.php:74
    10	include JROOT/templates/jp-school/layouts/theme.config.php	JROOT/templates/jp-school/layouts/theme.php:10
    9	include JROOT/templates/jp-school/layouts/theme.php	JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-school/index.php:16
    7	require JROOT/templates/jp-school/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: 9.33 ms Nach letzter Abfrage: 5.14 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 4.624 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #54

    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	Using temporary; 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.17 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.13 ms
    Optimizing	0.06 ms
    Statistics	0.10 ms
    Preparing	0.08 ms
    Creating tmp table	0.08 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.64 ms
    Creating sort index	0.07 ms
    Removing tmp table	0.18 ms
    Creating sort index	0.03 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	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
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    22	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
    21	JModelList->getItems()	JROOT/components/com_dpcalendar/models/profile.php:38
    20	DPCalendarModelProfile->getItems()	JROOT/plugins/system/dpcalendar/dpcalendar.php:235
    19	PlgSystemDpcalendar->fetchCalendars()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/plugin.php:509
    18	DPCalendarPlugin->onCalendarsFetch()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/components/com_dpcalendar/models/calendar.php:100
    15	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:28
    14	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-school/layouts/theme.config.php:74
    10	include JROOT/templates/jp-school/layouts/theme.config.php	JROOT/templates/jp-school/layouts/theme.php:10
    9	include JROOT/templates/jp-school/layouts/theme.php	JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-school/index.php:16
    7	require JROOT/templates/jp-school/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: 4.50 ms Nach letzter Abfrage: 3.06 ms Abfragespeichernutzung: 0.045 MB Speichernutzung vor Abfrage: 4.644 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.10 ms
    checking permissions	0.02 ms
    closing tables	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.66 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.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.02 ms
    checking permissions	0.30 ms
    closing tables	0.02 ms
    checking permissions	0.02 ms
    Executing	0.01 ms
    Sending data	0.12 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.25 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    20	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    19	JTable->__construct()	JROOT/administrator/components/com_dpcalendar/tables/event.php:19
    18	DPCalendarTableEvent->__construct()	JROOT/components/com_dpcalendar/models/events.php:570
    17	DPCalendarModelEvents->_getList()	JROOT/libraries/legacy/model/list.php:186
    16	JModelList->getItems()	JROOT/components/com_dpcalendar/models/events.php:137
    15	DPCalendarModelEvents->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:71
    14	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-school/layouts/theme.config.php:74
    10	include JROOT/templates/jp-school/layouts/theme.config.php	JROOT/templates/jp-school/layouts/theme.php:10
    9	include JROOT/templates/jp-school/layouts/theme.php	JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-school/index.php:16
    7	require JROOT/templates/jp-school/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: 3.86 ms Nach letzter Abfrage: 0.77 ms Abfragespeichernutzung: 0.053 MB Speichernutzung vor Abfrage: 4.742 MB Zeilen zurückgegeben: 8

    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 <= '2024-11-21 06:26:46') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-21 06:26:46') 
      AND (a.start_date  >= '2024-11-21 06:15:00') 
      AND a.language in ('de-DE','*')
    
      GROUP BY a.id
    
      ORDER BY a.start_date asc 
      LIMIT 8

    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	10	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.20 ms
    checking permissions	0.02 ms
    Opening tables	0.08 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.15 ms
    Optimizing	0.10 ms
    Statistics	0.30 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.19 ms
    Creating tmp table	0.15 ms
    Sorting for group	0.06 ms
    Sorting result	0.05 ms
    Executing	0.02 ms
    Sending data	0.05 ms
    Creating sort index	1.45 ms
    Creating sort index	0.16 ms
    Removing tmp table	0.23 ms
    Creating sort index	0.03 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Removing tmp table	0.02 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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    18	JDatabaseDriver->loadObjectList()	JROOT/components/com_dpcalendar/models/events.php:573
    17	DPCalendarModelEvents->_getList()	JROOT/libraries/legacy/model/list.php:186
    16	JModelList->getItems()	JROOT/components/com_dpcalendar/models/events.php:137
    15	DPCalendarModelEvents->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:71
    14	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-school/layouts/theme.config.php:74
    10	include JROOT/templates/jp-school/layouts/theme.config.php	JROOT/templates/jp-school/layouts/theme.php:10
    9	include JROOT/templates/jp-school/layouts/theme.php	JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-school/index.php:16
    7	require JROOT/templates/jp-school/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: 14.39 ms Nach letzter Abfrage: 10.00 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 4.931 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=877
    
      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.19 ms
    checking permissions	0.02 ms
    Opening tables	0.07 ms
    After opening tables	0.02 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.02 ms
    Executing	0.05 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	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
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    25	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    24	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    23	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/router.php:86
    22	DPCalendarRouter->build()	JROOT/libraries/cms/router/site.php:519
    21	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    20	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    19	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    18	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    17	JRoute::_()	JROOT/components/com_dpcalendar/helpers/route.php:61
    16	DPCalendarHelperRoute::getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php:107
    15	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73
    14	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-school/layouts/theme.config.php:74
    10	include JROOT/templates/jp-school/layouts/theme.config.php	JROOT/templates/jp-school/layouts/theme.php:10
    9	include JROOT/templates/jp-school/layouts/theme.php	JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-school/index.php:16
    7	require JROOT/templates/jp-school/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: 3.09 ms Nach letzter Abfrage: 2.82 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 4.951 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=878
    
      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.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.09 ms
    Optimizing	0.06 ms
    Statistics	0.08 ms
    Preparing	0.02 ms
    Executing	0.04 ms
    End of update loop	0.03 ms
    Query end	0.01 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	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
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    25	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    24	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    23	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/router.php:86
    22	DPCalendarRouter->build()	JROOT/libraries/cms/router/site.php:519
    21	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    20	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    19	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    18	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    17	JRoute::_()	JROOT/components/com_dpcalendar/helpers/route.php:61
    16	DPCalendarHelperRoute::getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php:107
    15	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73
    14	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-school/layouts/theme.config.php:74
    10	include JROOT/templates/jp-school/layouts/theme.config.php	JROOT/templates/jp-school/layouts/theme.php:10
    9	include JROOT/templates/jp-school/layouts/theme.php	JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-school/index.php:16
    7	require JROOT/templates/jp-school/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: 5.84 ms Nach letzter Abfrage: 2.59 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 4.973 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=888
    
      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.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.09 ms
    Optimizing	0.06 ms
    Statistics	0.07 ms
    Preparing	0.02 ms
    Executing	0.04 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	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
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    25	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    24	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    23	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/router.php:86
    22	DPCalendarRouter->build()	JROOT/libraries/cms/router/site.php:519
    21	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    20	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    19	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    18	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    17	JRoute::_()	JROOT/components/com_dpcalendar/helpers/route.php:61
    16	DPCalendarHelperRoute::getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php:107
    15	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73
    14	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-school/layouts/theme.config.php:74
    10	include JROOT/templates/jp-school/layouts/theme.config.php	JROOT/templates/jp-school/layouts/theme.php:10
    9	include JROOT/templates/jp-school/layouts/theme.php	JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-school/index.php:16
    7	require JROOT/templates/jp-school/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: 3.02 ms Nach letzter Abfrage: 2.69 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 4.993 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=879
    
      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.17 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.09 ms
    Optimizing	0.06 ms
    Statistics	0.09 ms
    Preparing	0.02 ms
    Executing	0.04 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	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
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    25	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    24	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    23	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/router.php:86
    22	DPCalendarRouter->build()	JROOT/libraries/cms/router/site.php:519
    21	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    20	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    19	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    18	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    17	JRoute::_()	JROOT/components/com_dpcalendar/helpers/route.php:61
    16	DPCalendarHelperRoute::getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php:107
    15	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73
    14	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-school/layouts/theme.config.php:74
    10	include JROOT/templates/jp-school/layouts/theme.config.php	JROOT/templates/jp-school/layouts/theme.php:10
    9	include JROOT/templates/jp-school/layouts/theme.php	JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-school/index.php:16
    7	require JROOT/templates/jp-school/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: 5.07 ms Nach letzter Abfrage: 2.62 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 5.013 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=880
    
      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.19 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.09 ms
    Optimizing	0.06 ms
    Statistics	0.07 ms
    Preparing	0.02 ms
    Executing	0.04 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	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
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    25	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    24	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    23	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/router.php:86
    22	DPCalendarRouter->build()	JROOT/libraries/cms/router/site.php:519
    21	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    20	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    19	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    18	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    17	JRoute::_()	JROOT/components/com_dpcalendar/helpers/route.php:61
    16	DPCalendarHelperRoute::getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php:107
    15	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73
    14	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-school/layouts/theme.config.php:74
    10	include JROOT/templates/jp-school/layouts/theme.config.php	JROOT/templates/jp-school/layouts/theme.php:10
    9	include JROOT/templates/jp-school/layouts/theme.php	JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-school/index.php:16
    7	require JROOT/templates/jp-school/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: 1.36 ms Nach letzter Abfrage: 1.12 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 5.033 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=882
    
      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.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.09 ms
    Optimizing	0.06 ms
    Statistics	0.08 ms
    Preparing	0.02 ms
    Executing	0.05 ms
    End of update loop	0.04 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	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
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    25	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    24	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    23	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/router.php:86
    22	DPCalendarRouter->build()	JROOT/libraries/cms/router/site.php:519
    21	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    20	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    19	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    18	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    17	JRoute::_()	JROOT/components/com_dpcalendar/helpers/route.php:61
    16	DPCalendarHelperRoute::getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php:107
    15	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73
    14	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-school/layouts/theme.config.php:74
    10	include JROOT/templates/jp-school/layouts/theme.config.php	JROOT/templates/jp-school/layouts/theme.php:10
    9	include JROOT/templates/jp-school/layouts/theme.php	JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-school/index.php:16
    7	require JROOT/templates/jp-school/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: 5.67 ms Nach letzter Abfrage: 2.49 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 5.055 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=883
    
      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.17 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.08 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.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	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
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    25	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    24	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    23	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/router.php:86
    22	DPCalendarRouter->build()	JROOT/libraries/cms/router/site.php:519
    21	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    20	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    19	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    18	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    17	JRoute::_()	JROOT/components/com_dpcalendar/helpers/route.php:61
    16	DPCalendarHelperRoute::getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php:107
    15	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73
    14	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-school/layouts/theme.config.php:74
    10	include JROOT/templates/jp-school/layouts/theme.config.php	JROOT/templates/jp-school/layouts/theme.php:10
    9	include JROOT/templates/jp-school/layouts/theme.php	JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-school/index.php:16
    7	require JROOT/templates/jp-school/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: 3.15 ms Nach letzter Abfrage: 2.63 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 5.075 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=884
    
      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.19 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.09 ms
    Optimizing	0.06 ms
    Statistics	0.09 ms
    Preparing	0.02 ms
    Executing	0.05 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	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
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    25	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    24	JCategories->get()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:43
    23	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/router.php:86
    22	DPCalendarRouter->build()	JROOT/libraries/cms/router/site.php:519
    21	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    20	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    19	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    18	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    17	JRoute::_()	JROOT/components/com_dpcalendar/helpers/route.php:61
    16	DPCalendarHelperRoute::getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php:107
    15	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/vertical-1.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:73
    14	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/cms/module/helper.php:198
    13	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    12	JDocumentRendererHtmlModule->render()	JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-school/layouts/theme.config.php:74
    10	include JROOT/templates/jp-school/layouts/theme.config.php	JROOT/templates/jp-school/layouts/theme.php:10
    9	include JROOT/templates/jp-school/layouts/theme.php	JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-school/index.php:16
    7	require JROOT/templates/jp-school/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: 16.86 ms Nach letzter Abfrage: 793.00 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 5.824 MB Zeilen zurückgegeben: 127
    Doppelte Abfragen: #12  #21

    SHOW TABLES

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.03 ms
    Opening tables	0.07 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.04 ms
    Statistics	0.04 ms
    Preparing	0.05 ms
    Executing	0.02 ms
    Filling schema table	0.02 ms
    checking permissions	0.69 ms
    Executing	0.02 ms
    Sending data	0.09 ms
    End of update loop	0.02 ms
    Query end	0.03 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.01 ms
    Query end	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:1530
    9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:497
    8	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:253
    7	plgSystemjdownloads->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
    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: 2.57 ms Nach letzter Abfrage: 5.58 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 5.876 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #42

    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	Using temporary; 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.24 ms
    checking permissions	0.07 ms
    Opening tables	0.07 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.15 ms
    Optimizing	0.07 ms
    Statistics	0.10 ms
    Preparing	0.12 ms
    Creating tmp table	0.09 ms
    Sorting result	0.05 ms
    Executing	0.02 ms
    Sending data	0.64 ms
    Creating sort index	0.08 ms
    Removing tmp table	0.22 ms
    Creating sort index	0.03 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.01 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.04 ms
    Updating status	0.03 ms
    Reset for next command	0.03 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    21	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
    20	JModelList->getItems()	JROOT/components/com_dpcalendar/models/profile.php:38
    19	DPCalendarModelProfile->getItems()	JROOT/plugins/system/dpcalendar/dpcalendar.php:235
    18	PlgSystemDpcalendar->fetchCalendars()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/plugin.php:509
    17	DPCalendarPlugin->onCalendarsFetch()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/administrator/components/com_dpcalendar/helpers/dpcalendar.php:77
    14	DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/router.php:86
    13	DPCalendarRouter->build()	JROOT/libraries/cms/router/site.php:519
    12	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:489
    11	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:282
    10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
    7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
    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]

    ---