Joomla!-Debug-Konsole

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

62 ausgeführte Abfragen 205.63 ms

1. Abfragezeit: 1.13 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 0.730 MB Zeilen zurückgegeben: 0

   SELECT `data`
   
     FROM `dof0p_session`
   
     WHERE `session_id` = '810st0htvl9b881e50bvibu5r7'

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

   Aufrufstapel (Call Stack)

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

   ---

2. Abfragezeit: 0.74 ms Nach letzter Abfrage: 2.92 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 0.749 MB Zeilen zurückgegeben: 0

   SELECT `session_id`
   
     FROM `dof0p_session`
   
     WHERE `session_id` = '810st0htvl9b881e50bvibu5r7' 
     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.06 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   After opening tables	0.03 ms
   System lock	0.04 ms
   table lock	0.05 ms
   init	0.03 ms
   Optimizing	0.04 ms
   Statistics	0.05 ms
   Preparing	0.04 ms
   Executing	0.04 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.01 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
   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]

   ---

3. Abfragezeit: 0.75 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 0.755 MB

   INSERT INTO `dof0p_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('810st0htvl9b881e50bvibu5r7', 1, '1731567094', 0, '', 0)

   Erklären

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

   Profil (Profile)

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

   Aufrufstapel (Call Stack)

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

   ---

4. Abfragezeit: 1.44 ms Nach letzter Abfrage: 5.00 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 0.783 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.07 ms
   checking permissions	0.02 ms
   Opening tables	0.05 ms
   After opening tables	0.02 ms
   System lock	0.05 ms
   table lock	0.03 ms
   init	0.05 ms
   Optimizing	0.03 ms
   Statistics	0.15 ms
   Preparing	0.04 ms
   Executing	0.01 ms
   Sending data	0.48 ms
   End of update loop	0.04 ms
   Query end	0.02 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.03 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/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]

   ---

5. Abfragezeit: 0.70 ms Nach letzter Abfrage: 6.40 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 0.829 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.07 ms
   checking permissions	0.02 ms
   Opening tables	0.05 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   table lock	0.03 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.02 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.07 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.06 ms
   Starting cleanup	0.02 ms
   Freeing items	0.01 ms
   Updating status	0.03 ms
   Reset for next command	0.02 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1061
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

6. Abfragezeit: 0.86 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 0.843 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.02 ms
   Opening tables	0.04 ms
   After opening tables	0.04 ms
   System lock	0.02 ms
   table lock	0.01 ms
   init	0.05 ms
   Optimizing	0.04 ms
   Statistics	0.14 ms
   Preparing	0.02 ms
   Unlocking tables	0.01 ms
   Preparing	0.03 ms
   Executing	0.02 ms
   Sending data	0.04 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   Commit	0.02 ms
   Query end	0.01 ms
   closing tables	0.03 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.03 ms
   Freeing items	0.02 ms
   Updating status	0.08 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/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]

   ---

7. Abfragezeit: 2.13 ms Nach letzter Abfrage: 1.01 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 0.866 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.07 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   table lock	0.03 ms
   init	0.04 ms
   Optimizing	0.07 ms
   Statistics	0.12 ms
   Preparing	0.03 ms
   Sorting result	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Creating sort index	1.26 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.03 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/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]

   ---

8. Abfragezeit: 1.04 ms Nach letzter Abfrage: 54.71 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 1.356 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.17 ms
   checking permissions	0.03 ms
   Opening tables	0.06 ms
   After opening tables	0.02 ms
   System lock	0.03 ms
   table lock	0.03 ms
   init	0.06 ms
   Optimizing	0.05 ms
   Statistics	0.06 ms
   Preparing	0.04 ms
   Executing	0.01 ms
   Sending data	0.10 ms
   End of update loop	0.02 ms
   Query end	0.01 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.02 ms
   Updating status	0.04 ms
   Reset for next command	0.02 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
   12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
   11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
   10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
   9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
   7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:271
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:683
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

9. Abfragezeit: 0.66 ms Nach letzter Abfrage: 0.28 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 1.367 MB Zeilen zurückgegeben: 1
   Doppelte Abfragen: #8

   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.06 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.05 ms
   Optimizing	0.04 ms
   Statistics	0.04 ms
   Preparing	0.08 ms
   Executing	0.02 ms
   Sending data	0.06 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.01 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
   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]

   ---

10. Abfragezeit: 0.96 ms Nach letzter Abfrage: 16.77 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.514 MB Zeilen zurückgegeben: 2

    SELECT extension, file, type
    
      FROM dof0p_rokcommon_configs
    
      ORDER BY priority

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.12 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.04 ms
    init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.15 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.09 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 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.03 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]

    ---

11. Abfragezeit: 1.82 ms Nach letzter Abfrage: 51.02 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 1.857 MB Zeilen zurückgegeben: 127
    Doppelte Abfragen: #20  #61

    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.21 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.05 ms
    Executing	0.02 ms
    Filling schema table	0.01 ms
    checking permissions	0.71 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
    Removing tmp table	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.03 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

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

    ---

12. Abfragezeit: 0.88 ms Nach letzter Abfrage: 1.36 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 1.881 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-14 07:51:35'

    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.11 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.02 ms
    init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.11 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.08 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.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
    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]

    ---

13. Abfragezeit: 0.63 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 1.887 MB Zeilen zurückgegeben: 0

    SELECT file_id 
      from dof0p_jdownloads_files 
      WHERE published = 0 
      AND use_timeframe = 1 
      AND publish_from != '0000-00-00 00:00:00' 
      AND publish_from <= '2024-11-14 07:51:35'

    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.04 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.05 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.01 ms
    Query end	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
    9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jdownloads/jdownloads.php:114
    8	plgSystemjdownloads->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:684
    4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
    3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

14. Abfragezeit: 1.76 ms Nach letzter Abfrage: 1.27 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 1.882 MB Zeilen zurückgegeben: 18

    SHOW FULL COLUMNS 
      FROM `dof0p_extensions`

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.02 ms
    closing tables	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.71 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Filling schema table	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    checking permissions	0.13 ms
    closing tables	0.02 ms
    checking permissions	0.03 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.01 ms
    Removing tmp table	0.18 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 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
    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]

    ---

15. Abfragezeit: 0.87 ms Nach letzter Abfrage: 3.29 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.927 MB Zeilen zurückgegeben: 1

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

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.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.17 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.06 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.05 ms
    Starting cleanup	0.02 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.03 ms

    Aufrufstapel (Call Stack)

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

    ---

16. Abfragezeit: 0.60 ms Nach letzter Abfrage: 0.32 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 1.936 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #18

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

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.06 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.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
    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]

    ---

17. Abfragezeit: 0.65 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.944 MB Zeilen zurückgegeben: 1

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

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.11 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	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.01 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.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]

    ---

18. Abfragezeit: 0.57 ms Nach letzter Abfrage: 0.25 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 1.952 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #16

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

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 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: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]

    ---

19. Abfragezeit: 5.36 ms Nach letzter Abfrage: 887.40 ms Abfragespeichernutzung: 0.206 MB Speichernutzung vor Abfrage: 2.215 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.18 ms
    checking permissions	0.03 ms
    Opening tables	0.07 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.06 ms
    Optimizing	0.04 ms
    Statistics	0.12 ms
    Preparing	0.05 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	4.30 ms
    End of update loop	0.04 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.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
    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]

    ---

20. Abfragezeit: 1.52 ms Nach letzter Abfrage: 46.49 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 2.999 MB Zeilen zurückgegeben: 127
    Doppelte Abfragen: #11  #61

    SHOW TABLES

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.13 ms
    checking permissions	0.02 ms
    Opening tables	0.09 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.07 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Filling schema table	0.02 ms
    checking permissions	0.55 ms
    Executing	0.02 ms
    Sending data	0.07 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 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.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.09 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: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]

    ---

21. Abfragezeit: 1.08 ms Nach letzter Abfrage: 1.38 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 3.027 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.13 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.05 ms
    Optimizing	0.05 ms
    Statistics	0.27 ms
    Preparing	0.06 ms
    Executing	0.02 ms
    Sending data	0.10 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.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
    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]

    ---

22. Abfragezeit: 0.98 ms Nach letzter Abfrage: 0.42 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 3.021 MB

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

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.05 ms
    init for update	0.20 ms
    Updating	0.20 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.04 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
    9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
    8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
    7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
    6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:1023
    4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

23. Abfragezeit: 0.71 ms Nach letzter Abfrage: 2.98 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 3.060 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.11 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.05 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.04 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
    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]

    ---

24. Abfragezeit: 1.12 ms Nach letzter Abfrage: 0.59 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.075 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.11 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.04 ms
    Statistics	0.14 ms
    Preparing	0.06 ms
    Executing	0.02 ms
    Sending data	0.18 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    closing tables	0.04 ms
    Unlocking tables	0.12 ms
    closing tables	0.06 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
    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]

    ---

25. Abfragezeit: 1.85 ms Nach letzter Abfrage: 13.63 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 3.134 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.20 ms
    checking permissions	0.02 ms
    Opening tables	0.06 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.09 ms
    Optimizing	0.04 ms
    Statistics	0.17 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.80 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.05 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

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

    ---

26. Abfragezeit: 2.03 ms Nach letzter Abfrage: 4.56 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 3.202 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.08 ms
    checking permissions	0.02 ms
    closing tables	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.58 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Filling schema table	0.02 ms
    Opening tables	0.22 ms
    After opening tables	0.02 ms
    checking permissions	0.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.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.16 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 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
    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]

    ---

27. Abfragezeit: 0.96 ms Nach letzter Abfrage: 6.98 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 3.338 MB Zeilen zurückgegeben: 1

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

    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.12 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.03 ms
    init	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.18 ms
    Preparing	0.03 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    End of update loop	0.02 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.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]

    ---

28. Abfragezeit: 0.66 ms Nach letzter Abfrage: 0.32 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 3.347 MB

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

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init for update	0.06 ms
    Updating	0.17 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 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.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]

    ---

29. Abfragezeit: 1.54 ms Nach letzter Abfrage: 4.80 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 3.373 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 = 711 
      AND c.published > 0 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-14 06:51:36') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-14 06:51:36') 
      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.33 ms
    checking permissions	0.03 ms
    Opening tables	0.14 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.08 ms
    Optimizing	0.11 ms
    Statistics	0.28 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.08 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.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]

    ---

30. Abfragezeit: 1.47 ms Nach letzter Abfrage: 6.71 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 3.424 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=23
    
      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.24 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.14 ms
    Optimizing	0.07 ms
    Statistics	0.17 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.16 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.03 ms
    Updating status	0.07 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    20	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    19	JCategories->get()	JROOT/components/com_content/router.php:72
    18	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:117
    17	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
    16	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
    15	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
    14	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
    13	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    12	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    11	JRoute::_()	JROOT/components/com_content/views/article/view.html.php:71
    10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

31. Abfragezeit: 0.72 ms Nach letzter Abfrage: 1.09 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 3.447 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` = 711 
      AND `t`.`published` = 1 
      AND t.access IN (1,1)

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.02 ms
    Opening tables	0.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.07 ms
    Preparing	0.02 ms
    Executing	0.03 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 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
    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]

    ---

32. Abfragezeit: 1.60 ms Nach letzter Abfrage: 13.86 ms Abfragespeichernutzung: 0.041 MB Speichernutzung vor Abfrage: 3.574 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 (23,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.14 ms
    After opening tables	0.03 ms
    System lock	0.03 ms
    table lock	0.03 ms
    init	0.13 ms
    Optimizing	0.10 ms
    Statistics	0.18 ms
    Preparing	0.08 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.08 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.02 ms
    Freeing items	0.03 ms
    Updating status	0.08 ms
    Reset for next command	0.03 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]

    ---

33. Abfragezeit: 4.23 ms Nach letzter Abfrage: 122.99 ms Abfragespeichernutzung: 0.189 MB Speichernutzung vor Abfrage: 4.130 MB Zeilen zurückgegeben: 178

    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-14 06:51:36') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-14 06:51:36') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 101 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.23 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.03 ms
    init	0.10 ms
    Optimizing	0.07 ms
    Statistics	0.16 ms
    Preparing	0.12 ms
    Sorting result	0.04 ms
    Executing	0.02 ms
    Sending data	0.03 ms
    Creating sort index	2.92 ms
    End of update loop	0.03 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.04 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:169
    16	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
    15	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
    14	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    13	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
    12	JDocumentHtml->countModules()	JROOT/templates/jp-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]

    ---

34. Abfragezeit: 1.37 ms Nach letzter Abfrage: 207.13 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 4.729 MB Zeilen zurückgegeben: 3

    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=13
    
      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.23 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.10 ms
    Optimizing	0.06 ms
    Statistics	0.18 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.15 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.03 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 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/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/Filter.php:134
    23	RokSprocket_Provider_Joomla_Filter->category()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstractJoomlaPlatformFilter.php:120
    22	RokSprocket_Provider_AbstractJoomlaPlatformFilter->process()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:46
    21	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    20	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    19	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    18	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    17	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    16	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    15	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    14	include JROOT/modules/mod_roksprocket/mod_roksprocket.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]

    ---

35. Abfragezeit: 107.01 ms Nach letzter Abfrage: 0.59 ms Abfragespeichernutzung: 2.133 MB Speichernutzung vor Abfrage: 4.760 MB Zeilen zurückgegeben: 275

    SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title
    
      FROM dof0p_content as a
    
      LEFT JOIN dof0p_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN dof0p_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN dof0p_users AS um 
      ON um.id = a.modified_by
    
      LEFT JOIN dof0p_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT JOIN dof0p_viewlevels AS vl 
      ON a.access = vl.id
    
      LEFT JOIN dof0p_languages AS l 
      ON a.language = l.lang_code
    
      LEFT JOIN dof0p_contentitem_tag_map AS ct 
      ON ct.content_item_id = a.id
    
      LEFT JOIN dof0p_tags AS t 
      ON t.id = ct.tag_id
    
      LEFT 
      OUTER JOIN (select rsi.provider_id, rsi.
      order 
      from dof0p_roksprocket_items as rsi 
      where module_id = 275) rsi 
      on a.id = rsi.provider_id
    
      WHERE ((a.access IN(1,1) 
      AND (a.state = 1 or a.state = 2) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-14 06:51:36') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-14 06:51:36') 
      AND (a.state != -2)) 
      AND a.id IN (321)) OR ((a.access IN(1,1) 
      AND (a.state = 1 or a.state = 2) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-14 06:51:36') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-14 06:51:36') 
      AND (a.state != -2)) 
      AND a.catid IN (13,32))
    
      GROUP BY id
    
      ORDER BY rsi.
      order

    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; Using temporary; filesort wurde genutzt
    1	SIMPLE	ct	system	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	0	Const row not found
    1	SIMPLE	a	index_merge	PRIMARY,idx_access,idx_state,idx_catid	PRIMARY,idx_catid	4,4	NULL	271	Using sort_union(PRIMARY,idx_catid); Using where
    1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	web688_2016_db.a.catid	1	Using where
    1	SIMPLE	vl	eq_ref	PRIMARY	PRIMARY	4	web688_2016_db.a.access	1
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	web688_2016_db.a.created_by	1	Using where
    1	SIMPLE	um	eq_ref	PRIMARY	PRIMARY	4	web688_2016_db.a.modified_by	1	Using where
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	web688_2016_db.a.language	1	Using where
    1	SIMPLE	rsi	ALL	idx_module,idx_module_order	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	578	Using where; Using join buffer (flat, BNL join)

    Profil (Profile)

    Status	Duration
    Starting	0.22 ms
    checking permissions	0.03 ms
    Opening tables	0.18 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.15 ms
    Optimizing	0.09 ms
    Statistics	0.49 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.10 ms
    Creating tmp table	0.20 ms
    Sorting result	0.13 ms
    Executing	0.02 ms
    Sending data	96.09 ms
    Creating sort index	7.67 ms
    Removing tmp table	0.91 ms
    Creating sort index	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
    Removing tmp table	0.01 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.03 ms
    Query end	0.03 ms
    Starting cleanup	0.01 ms
    Freeing items	0.04 ms
    Updating status	0.04 ms
    Reset for next command	0.06 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    22	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:58
    21	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    20	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    19	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    18	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    17	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    16	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    15	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    14	include JROOT/modules/mod_roksprocket/mod_roksprocket.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.21 ms Nach letzter Abfrage: 47.29 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 7.612 MB Zeilen zurückgegeben: 0

    SELECT ct.content_item_id as article_id, t.title as tag
    
      FROM dof0p_contentitem_tag_map as ct
    
      LEFT JOIN dof0p_tags AS t 
      ON t.id = ct.tag_id
    
      WHERE ct.content_item_id in (713,706,710,709,707,708,705,703,704,702,701,698,697,696,695,694,692,693,690,689,686,684,683,682,681,680,643,642,665,657,663,647,645,659,660,662,666,667,670,671,672,673,678,679,640,639,638,636,637,635,633,631,632,630,629,628,627,626,625,624,623,622,621,620,619,618,617,616,614,613,612,611,610,607,605,603,601,600,599,598,597,596,595,594,591,590,587,586,582,579,576,575,574,573,571,570,569,568,567,566,564,561,559,558,557,556,555,554,552,551,550,549,546,545,540,538,537,536,532,530,526,520,519,516,515,514,513,511,508,506,505,504,502,501,499,497,493,492,491,490,487,486,485,484,482,481,480,479,477,474,473,471,470,468,465,462,461,458,457,456,454,453,452,451,450,449,448,447,446,444,443,441,440,439,438,437,436,431,430,426,425,424,423,422,421,419,418,417,416,414,412,411,410,409,408,407,406,404,402,399,397,394,391,384,383,382,381,377,376,372,371,369,366,365,360,353,351,349,347,346,344,343,342,340,339,338,337,336,334,333,332,331,329,328,326,325,324,323,322,321,320,318,313,312,311,309,307,306,305,304,303,297,296,295,290,285,284,283,282,277,276,271,269,268,257,256,245,242,238,236,227,215,214,212,197)

    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.34 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.12 ms
    Optimizing	0.08 ms
    Statistics	0.09 ms
    Preparing	0.02 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.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.03 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
    24	JDatabaseDriver->loadAssocList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/TagMerge.php:26
    23	RokSprocket_Provider_Joomla_TagMerge->populateTags()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla.php:159
    22	RokSprocket_Provider_Joomla->populateTags()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:62
    21	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    20	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    19	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    18	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    17	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    16	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    15	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    14	include JROOT/modules/mod_roksprocket/mod_roksprocket.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: 5.52 ms Nach letzter Abfrage: 844.73 ms Abfragespeichernutzung: 0.499 MB Speichernutzung vor Abfrage: 8.567 MB Zeilen zurückgegeben: 279

    SELECT i.provider_id as id, i.
      order, i.params
    
      FROM dof0p_roksprocket_items as i
    
      WHERE i.module_id = '275' 
      AND i.provider = 'joomla'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module	137	const	242	Using index condition; 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.05 ms
    Optimizing	0.04 ms
    Statistics	0.29 ms
    Preparing	0.07 ms
    Executing	0.02 ms
    Sending data	4.42 ms
    End of update loop	0.04 ms
    Query end	0.03 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/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:139
    22	RokSprocket_Provider_AbstarctJoomlaBasedProvider->mapPerItemData()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:64
    21	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    20	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    19	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    18	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    17	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    16	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    15	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    14	include JROOT/modules/mod_roksprocket/mod_roksprocket.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.51 ms Nach letzter Abfrage: 1834.28 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 5.371 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.28 ms
    checking permissions	0.03 ms
    Opening tables	0.07 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.10 ms
    Optimizing	0.06 ms
    Statistics	0.18 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.10 ms
    Sorting result	0.04 ms
    Executing	0.02 ms
    Sending data	0.05 ms
    Creating sort index	0.19 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 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: 1.37 ms Nach letzter Abfrage: 0.80 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 5.396 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	919	Using where

    Profil (Profile)

    Status	Duration
    Starting	0.07 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	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.11 ms
    Preparing	0.04 ms
    Executing	0.03 ms
    Sending data	0.56 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.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

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

    ---

40. Abfragezeit: 1.27 ms Nach letzter Abfrage: 1.00 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 5.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=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.14 ms
    checking permissions	0.05 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.05 ms
    Statistics	0.15 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.05 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.19 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.03 ms
    Updating status	0.04 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.17 ms Nach letzter Abfrage: 1.18 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 5.456 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.15 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.09 ms
    Optimizing	0.08 ms
    Statistics	0.16 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    Creating sort index	0.16 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.01 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: 1.28 ms Nach letzter Abfrage: 0.97 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 5.477 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.20 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.05 ms
    Statistics	0.13 ms
    Preparing	0.03 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.16 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.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
    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]

    ---

43. Abfragezeit: 1.10 ms Nach letzter Abfrage: 0.93 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 5.498 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.13 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.06 ms
    Optimizing	0.04 ms
    Statistics	0.12 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Sorting result	0.03 ms
    Executing	0.02 ms
    Sending data	0.03 ms
    Creating sort index	0.14 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.05 ms
    Reset for next command	0.04 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]

    ---

44. Abfragezeit: 1.18 ms Nach letzter Abfrage: 0.96 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 5.519 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.12 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.06 ms
    Optimizing	0.04 ms
    Statistics	0.13 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Sorting result	0.03 ms
    Executing	0.02 ms
    Sending data	0.04 ms
    Creating sort index	0.23 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.03 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.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]

    ---

45. Abfragezeit: 2.19 ms Nach letzter Abfrage: 6.99 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 5.569 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #62

    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.20 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.11 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.52 ms
    Creating sort index	0.13 ms
    Removing tmp table	0.21 ms
    Creating sort index	0.03 ms
    End of update loop	0.04 ms
    Query end	0.02 ms
    Commit	0.02 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.03 ms
    Updating status	0.05 ms
    Reset for next command	0.03 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]

    ---

46. Abfragezeit: 2.14 ms Nach letzter Abfrage: 3.45 ms Abfragespeichernutzung: 0.045 MB Speichernutzung vor Abfrage: 5.587 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.12 ms
    checking permissions	0.03 ms
    closing tables	0.01 ms
    checking permissions	0.02 ms
    Opening tables	0.61 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Filling schema table	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    checking permissions	0.26 ms
    closing tables	0.02 ms
    checking permissions	0.02 ms
    Executing	0.01 ms
    Sending data	0.11 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.10 ms
    Removing tmp table	0.22 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 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]

    ---

47. Abfragezeit: 3.79 ms Nach letzter Abfrage: 0.65 ms Abfragespeichernutzung: 0.053 MB Speichernutzung vor Abfrage: 5.685 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-14 06:51:36') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-14 06:51:36') 
      AND (a.start_date  >= '2024-11-14 06:45: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.17 ms
    checking permissions	0.02 ms
    Opening tables	0.08 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.14 ms
    Optimizing	0.08 ms
    Statistics	0.33 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.16 ms
    Creating tmp table	0.18 ms
    Sorting for group	0.05 ms
    Sorting result	0.05 ms
    Executing	0.02 ms
    Sending data	0.05 ms
    Creating sort index	1.42 ms
    Creating sort index	0.16 ms
    Removing tmp table	0.24 ms
    Creating sort index	0.04 ms
    End of update loop	0.04 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.03 ms
    Query end	0.03 ms
    Starting cleanup	0.01 ms
    Freeing items	0.04 ms
    Removing tmp table	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.05 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

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

    ---

48. Abfragezeit: 1.01 ms Nach letzter Abfrage: 10.18 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 5.811 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=876
    
      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.22 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.03 ms
    table lock	0.03 ms
    init	0.10 ms
    Optimizing	0.06 ms
    Statistics	0.08 ms
    Preparing	0.02 ms
    Executing	0.04 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.04 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: 0.84 ms Nach letzter Abfrage: 2.21 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 5.831 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.18 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.07 ms
    Optimizing	0.05 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Executing	0.04 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 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
    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: 0.74 ms Nach letzter Abfrage: 2.01 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 5.853 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.14 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.05 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Executing	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 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: 0.79 ms Nach letzter Abfrage: 1.88 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 5.873 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.19 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.09 ms
    Optimizing	0.05 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Executing	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.04 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: 1.02 ms Nach letzter Abfrage: 2.48 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 5.893 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.21 ms
    checking permissions	0.06 ms
    Opening tables	0.06 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.03 ms
    init	0.08 ms
    Optimizing	0.06 ms
    Statistics	0.09 ms
    Preparing	0.03 ms
    Executing	0.04 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	0.04 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: 0.86 ms Nach letzter Abfrage: 0.83 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 5.913 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.12 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.07 ms
    Optimizing	0.06 ms
    Statistics	0.12 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.04 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]

    ---

54. Abfragezeit: 0.89 ms Nach letzter Abfrage: 2.34 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 5.934 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.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	0.10 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.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
    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]

    ---

55. Abfragezeit: 0.72 ms Nach letzter Abfrage: 2.33 ms Abfragespeichernutzung: 0.046 MB Speichernutzung vor Abfrage: 5.955 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.11 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.06 ms
    Optimizing	0.04 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Executing	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 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
    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]

    ---

56. Abfragezeit: 12.78 ms Nach letzter Abfrage: 107.99 ms Abfragespeichernutzung: 0.141 MB Speichernutzung vor Abfrage: 6.010 MB Zeilen zurückgegeben: 82

    SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title
    
      FROM dof0p_content as a
    
      LEFT JOIN dof0p_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN dof0p_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN dof0p_users AS um 
      ON um.id = a.modified_by
    
      LEFT JOIN dof0p_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT JOIN dof0p_viewlevels AS vl 
      ON a.access = vl.id
    
      LEFT JOIN dof0p_languages AS l 
      ON a.language = l.lang_code
    
      LEFT JOIN dof0p_contentitem_tag_map AS ct 
      ON ct.content_item_id = a.id
    
      LEFT JOIN dof0p_tags AS t 
      ON t.id = ct.tag_id
    
      LEFT 
      OUTER JOIN (select rsi.provider_id, rsi.
      order 
      from dof0p_roksprocket_items as rsi 
      where module_id = 276) rsi 
      on a.id = rsi.provider_id
    
      WHERE ((a.access IN(1,1) 
      AND (a.state = 1 or a.state = 2) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-14 06:51:36') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-14 06:51:36') 
      AND (a.state != -2)) 
      AND a.id IN (524,565)) OR ((a.access IN(1,1) 
      AND (a.state = 1 or a.state = 2) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-14 06:51:36') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-14 06:51:36') 
      AND (a.state != -2)) 
      AND a.catid IN (23))
    
      GROUP BY id
    
      ORDER BY rsi.
      order

    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; Using temporary; filesort wurde genutzt
    1	SIMPLE	ct	system	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	0	Const row not found
    1	SIMPLE	a	index_merge	PRIMARY,idx_access,idx_state,idx_catid	PRIMARY,idx_catid	4,4	NULL	83	Using sort_union(PRIMARY,idx_catid); Using where
    1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	web688_2016_db.a.catid	1	Using where
    1	SIMPLE	vl	eq_ref	PRIMARY	PRIMARY	4	web688_2016_db.a.access	1
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	web688_2016_db.a.created_by	1	Using where
    1	SIMPLE	um	eq_ref	PRIMARY	PRIMARY	4	web688_2016_db.a.modified_by	1	Using where
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	web688_2016_db.a.language	1	Using where
    1	SIMPLE	rsi	ALL	idx_module,idx_module_order	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	578	Using where; Using join buffer (flat, BNL join)

    Profil (Profile)

    Status	Duration
    Starting	0.32 ms
    checking permissions	0.03 ms
    Opening tables	0.17 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.19 ms
    Optimizing	0.10 ms
    Statistics	0.27 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.07 ms
    Creating tmp table	0.09 ms
    Sorting result	0.10 ms
    Executing	0.02 ms
    Sending data	9.26 ms
    Creating sort index	1.28 ms
    Removing tmp table	0.23 ms
    Creating sort index	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
    Removing tmp table	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.04 ms
    Query end	0.12 ms
    Starting cleanup	0.02 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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    22	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:58
    21	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    20	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    19	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    18	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    17	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    16	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    15	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    14	include JROOT/modules/mod_roksprocket/mod_roksprocket.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]

    ---

57. Abfragezeit: 0.80 ms Nach letzter Abfrage: 1.29 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 6.373 MB Zeilen zurückgegeben: 0

    SELECT ct.content_item_id as article_id, t.title as tag
    
      FROM dof0p_contentitem_tag_map as ct
    
      LEFT JOIN dof0p_tags AS t 
      ON t.id = ct.tag_id
    
      WHERE ct.content_item_id in (711,700,691,687,688,675,668,674,669,658,634,608,592,584,583,580,578,572,565,543,544,529,524,518,510,509,507,496,495,494,489,488,478,476,475,469,467,466,445,433,420,415,413,405,403,401,400,396,393,364,359,350,345,341,335,330,310,308,302,301,300,299,298,293,292,291,289,288,286,280,279,278,275,274,273,267,266,265,264,243,211,173)

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.15 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.08 ms
    Optimizing	0.07 ms
    Statistics	0.07 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.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
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
    24	JDatabaseDriver->loadAssocList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/TagMerge.php:26
    23	RokSprocket_Provider_Joomla_TagMerge->populateTags()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla.php:159
    22	RokSprocket_Provider_Joomla->populateTags()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:62
    21	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    20	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    19	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    18	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    17	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    16	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    15	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    14	include JROOT/modules/mod_roksprocket/mod_roksprocket.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]

    ---

58. Abfragezeit: 2.02 ms Nach letzter Abfrage: 177.09 ms Abfragespeichernutzung: 0.119 MB Speichernutzung vor Abfrage: 6.642 MB Zeilen zurückgegeben: 79

    SELECT i.provider_id as id, i.
      order, i.params
    
      FROM dof0p_roksprocket_items as i
    
      WHERE i.module_id = '276' 
      AND i.provider = 'joomla'

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	i	ref	idx_module,idx_module_order	idx_module	137	const	84	Using index condition; Using where

    Profil (Profile)

    Status	Duration
    Starting	0.13 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.14 ms
    Preparing	0.05 ms
    Executing	0.01 ms
    Sending data	1.19 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.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
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    23	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:139
    22	RokSprocket_Provider_AbstarctJoomlaBasedProvider->mapPerItemData()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:64
    21	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    20	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    19	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    18	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    17	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    16	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    15	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    14	include JROOT/modules/mod_roksprocket/mod_roksprocket.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]

    ---

59. Abfragezeit: 1.58 ms Nach letzter Abfrage: 234.48 ms Abfragespeichernutzung: 0.059 MB Speichernutzung vor Abfrage: 6.187 MB Zeilen zurückgegeben: 4

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM dof0p_content AS a
    
      LEFT JOIN dof0p_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN dof0p_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN dof0p_users AS uam 
      ON uam.id = a.modified_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.access IN (1,1) 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (32) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-14 06:51:36') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-14 06:51:36')
    
      ORDER BY a.ordering ASC

    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	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	5	Using where; filesort wurde genutzt
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	web688_2016_db.a.created_by	1	Using where
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	web688_2016_db.a.modified_by	1	Using where
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where

    Profil (Profile)

    Status	Duration
    Starting	0.25 ms
    checking permissions	0.02 ms
    Opening tables	0.08 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.11 ms
    Optimizing	0.07 ms
    Statistics	0.18 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.05 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    Creating sort index	0.35 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
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    20	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
    19	JModelList->getItems()	JROOT/components/com_content/models/articles.php:536
    18	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:228
    17	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:169
    16	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:550
    15	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    14	include JROOT/modules/mod_articles_category/mod_articles_category.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]

    ---

60. Abfragezeit: 1.11 ms Nach letzter Abfrage: 4.28 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 6.330 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 = 'mod_articles_category.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (23,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.16 ms
    checking permissions	0.02 ms
    Opening tables	0.08 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.08 ms
    Optimizing	0.07 ms
    Statistics	0.13 ms
    Preparing	0.07 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.06 ms
    End of update loop	0.02 ms
    Query end	0.02 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
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    27	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
    26	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
    25	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
    24	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
    23	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    22	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    21	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    20	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:233
    19	JHtml::call()	JROOT/libraries/cms/html/html.php:105
    18	JHtml::_()	JROOT/modules/mod_articles_category/helper.php:308
    17	ModArticlesCategoryHelper::getList()	JROOT/libraries/joomla/cache/controller/callback.php:169
    16	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:550
    15	JModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
    14	include JROOT/modules/mod_articles_category/mod_articles_category.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]

    ---

61. Abfragezeit: 1.76 ms Nach letzter Abfrage: 336.12 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 7.016 MB Zeilen zurückgegeben: 127
    Doppelte Abfragen: #11  #20

    SHOW TABLES

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.11 ms
    checking permissions	0.03 ms
    Opening tables	0.07 ms
    After opening tables	0.02 ms
    System lock	0.07 ms
    table lock	0.02 ms
    init	0.02 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.05 ms
    Executing	0.02 ms
    Filling schema table	0.02 ms
    checking permissions	0.66 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.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.01 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.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]

    ---

62. Abfragezeit: 2.60 ms Nach letzter Abfrage: 5.23 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 7.107 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #45

    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.03 ms
    Opening tables	0.07 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.18 ms
    Optimizing	0.08 ms
    Statistics	0.09 ms
    Preparing	0.12 ms
    Creating tmp table	0.09 ms
    Sorting result	0.04 ms
    Executing	0.02 ms
    Sending data	0.82 ms
    Creating sort index	0.08 ms
    Removing tmp table	0.19 ms
    Creating sort index	0.03 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.01 ms
    Removing tmp table	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.02 ms
    Freeing items	0.03 ms
    Updating status	0.04 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/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]

    ---