Joomla!-Debug-Konsole

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1753113572,
                "last": 1753113572,
                "now": 1753113572
            },
            "token": "AvJDVWcCMIFbKyhslwIk7QKBmwYwnbdJ"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Zeit

Speicher

57 ausgeführte Abfragen 233.54 ms

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

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

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

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   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.73 ms Nach letzter Abfrage: 2.81 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 0.748 MB Zeilen zurückgegeben: 0

   SELECT `session_id`
   
     FROM `dof0p_session`
   
     WHERE `session_id` = 'd8fjclgrqercab5g73d71qusf3' 
     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.03 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.04 ms
   table lock	0.03 ms
   init	0.04 ms
   Optimizing	0.03 ms
   Statistics	0.05 ms
   Preparing	0.04 ms
   Executing	0.03 ms
   End of update loop	0.02 ms
   Query end	0.03 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.37 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 0.754 MB

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

   Erklären

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

   Profil (Profile)

   Status	Duration
   Starting	0.09 ms
   checking permissions	0.05 ms
   Opening tables	0.02 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init for update	0.03 ms
   Update	0.15 ms
   End of update loop	0.02 ms
   Query end	0.01 ms
   closing tables	0.02 ms
   Unlocking tables	0.08 ms
   closing tables	0.03 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.05 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.48 ms Nach letzter Abfrage: 4.65 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 0.782 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.12 ms
   checking permissions	0.02 ms
   Opening tables	0.05 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   table lock	0.02 ms
   init	0.04 ms
   Optimizing	0.03 ms
   Statistics	0.11 ms
   Preparing	0.06 ms
   Executing	0.02 ms
   Sending data	0.55 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
   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.99 ms Nach letzter Abfrage: 5.63 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 0.828 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.09 ms
   checking permissions	0.02 ms
   Opening tables	0.12 ms
   After opening tables	0.03 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.07 ms
   Optimizing	0.02 ms
   Statistics	0.03 ms
   Preparing	0.02 ms
   Executing	0.02 ms
   Sending data	0.14 ms
   End of update loop	0.03 ms
   Query end	0.02 ms
   closing tables	0.03 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Query end	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.04 ms
   Reset for next command	0.02 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.96 ms Nach letzter Abfrage: 0.31 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 0.842 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.09 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.03 ms
   init	0.03 ms
   Optimizing	0.03 ms
   Statistics	0.17 ms
   Preparing	0.02 ms
   Unlocking tables	0.01 ms
   Preparing	0.07 ms
   Executing	0.02 ms
   Sending data	0.06 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.01 ms
   Query end	0.02 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.01 ms
   Updating status	0.03 ms
   Reset for next command	0.02 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/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.24 ms Nach letzter Abfrage: 0.88 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 0.865 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.06 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.04 ms
   Optimizing	0.06 ms
   Statistics	0.14 ms
   Preparing	0.04 ms
   Sorting result	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   Creating sort index	1.32 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.04 ms
   Reset for next command	0.02 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:327
   8	JPluginHelper::{closure}()	JROOT/libraries/joomla/cache/controller/callback.php:169
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/plugin/helper.php:332
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

8. Abfragezeit: 1.00 ms Nach letzter Abfrage: 55.56 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 1.355 MB Zeilen zurückgegeben: 1
   Doppelte Abfragen: #9

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

   Erklären

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

   Profil (Profile)

   Status	Duration
   Starting	0.15 ms
   checking permissions	0.02 ms
   Opening tables	0.07 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   table lock	0.03 ms
   init	0.07 ms
   Optimizing	0.05 ms
   Statistics	0.06 ms
   Preparing	0.04 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.02 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
   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.69 ms Nach letzter Abfrage: 0.26 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 1.366 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.03 ms
   Optimizing	0.06 ms
   Statistics	0.05 ms
   Preparing	0.04 ms
   Executing	0.03 ms
   Sending data	0.08 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.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.01 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.86 ms Nach letzter Abfrage: 18.60 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.513 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.11 ms
    checking permissions	0.02 ms
    Opening tables	0.06 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Sorting result	0.02 ms
    Executing	0.02 ms
    Sending data	0.02 ms
    Creating sort index	0.08 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
    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.73 ms Nach letzter Abfrage: 50.62 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 1.856 MB Zeilen zurückgegeben: 127
    Doppelte Abfragen: #20  #56

    SHOW TABLES

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.02 ms
    Opening tables	0.06 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Filling schema table	0.03 ms
    checking permissions	0.82 ms
    Executing	0.02 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.03 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: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: 1.06 ms Nach letzter Abfrage: 1.18 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 1.880 MB Zeilen zurückgegeben: 0

    SELECT file_id 
      from dof0p_jdownloads_files 
      WHERE published = 1 
      AND use_timeframe = 1 
      AND publish_to != '0000-00-00 00:00:00' 
      AND publish_to <= '2025-07-21 17:59:32'

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

    Aufrufstapel (Call Stack)

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

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

    ---

13. Abfragezeit: 0.72 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 1.886 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 <= '2025-07-21 17:59:32'

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.03 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.05 ms
    Statistics	0.05 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    End of update loop	0.05 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.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.01 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.53 ms Nach letzter Abfrage: 1.42 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 1.881 MB Zeilen zurückgegeben: 18

    SHOW FULL COLUMNS 
      FROM `dof0p_extensions`

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.05 ms
    closing tables	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.53 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.11 ms
    closing tables	0.02 ms
    checking permissions	0.01 ms
    Executing	0.01 ms
    Sending data	0.08 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.13 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.01 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.76 ms Nach letzter Abfrage: 3.73 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.926 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.06 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.18 ms
    Preparing	0.04 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.04 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.71 ms Nach letzter Abfrage: 0.51 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 1.935 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.04 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.04 ms
    Optimizing	0.03 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.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.03 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.01 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.69 ms Nach letzter Abfrage: 0.39 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.943 MB Zeilen zurückgegeben: 1

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

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.12 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    End of update loop	0.06 ms
    Query end	0.03 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.01 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.63 ms Nach letzter Abfrage: 0.42 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.04 ms
    Preparing	0.05 ms
    Unlocking tables	0.02 ms
    Preparing	0.02 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.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.01 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.74 ms Nach letzter Abfrage: 653.59 ms Abfragespeichernutzung: 0.196 MB Speichernutzung vor Abfrage: 2.214 MB Zeilen zurückgegeben: 139

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

    SHOW TABLES

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.02 ms
    Opening tables	0.06 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.03 ms
    Filling schema table	0.02 ms
    checking permissions	0.55 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
    Removing tmp table	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.01 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: 0.81 ms Nach letzter Abfrage: 1.66 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 2.930 MB Zeilen zurückgegeben: 1

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

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.05 ms
    Optimizing	0.03 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.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.67 ms Nach letzter Abfrage: 0.59 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 2.923 MB

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

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init for update	0.13 ms
    Updating	0.13 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.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 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.68 ms Nach letzter Abfrage: 3.05 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 3.024 MB Zeilen zurückgegeben: 1

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

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.04 ms
    Opening tables	0.06 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.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.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 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: 0.91 ms Nach letzter Abfrage: 0.83 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.039 MB Zeilen zurückgegeben: 6

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

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.06 ms
    Statistics	0.09 ms
    Preparing	0.05 ms
    Executing	0.01 ms
    Sending data	0.20 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.02 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 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.58 ms Nach letzter Abfrage: 14.80 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 3.135 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.12 ms
    checking permissions	0.02 ms
    Opening tables	0.08 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.08 ms
    Optimizing	0.03 ms
    Statistics	0.14 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	0.72 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.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
    18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
    17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
    16	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
    15	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    14	JUser->authorise()	JROOT/components/com_content/models/category.php:142
    13	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:434
    12	JModelLegacy->getState()	JROOT/libraries/legacy/view/category.php:115
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->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]

    ---

26. Abfragezeit: 1.45 ms Nach letzter Abfrage: 0.46 ms Abfragespeichernutzung: 0.166 MB Speichernutzung vor Abfrage: 3.194 MB Zeilen zurückgegeben: 756

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `dof0p_assets`
    
      WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' 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	965	Using where

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:357
    18	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:224
    17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:538
    16	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
    15	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    14	JUser->authorise()	JROOT/components/com_content/models/category.php:142
    13	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:434
    12	JModelLegacy->getState()	JROOT/libraries/legacy/view/category.php:115
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->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]

    ---

27. Abfragezeit: 3.32 ms Nach letzter Abfrage: 9.60 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 3.868 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,COUNT(i.`id`) AS numitems
    
      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)
    
      LEFT JOIN `dof0p_content` AS i 
      ON i.`catid` = c.id 
      AND i.state = 1
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.published = 1 
      AND s.id=24
    
      GROUP BY 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
    
      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	Using temporary; filesort wurde genutzt
    1	SIMPLE	c	ALL	cat_idx,idx_left_right	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	32	Using where
    1	SIMPLE	i	ref|filter	idx_state,idx_catid	idx_catid|idx_state	4|1	web688_2016_db.c.id	37 (82%)	Using where; Using rowid filter

    Profil (Profile)

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

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    14	JCategories->get()	JROOT/components/com_content/models/category.php:355
    13	ContentModelCategory->getCategory()	JROOT/libraries/legacy/view/legacy.php:422
    12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:121
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->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]

    ---

28. Abfragezeit: 2.55 ms Nach letzter Abfrage: 3.72 ms Abfragespeichernutzung: 0.042 MB Speichernutzung vor Abfrage: 3.903 MB Zeilen zurückgegeben: 1

    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 = 24 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-07-21 15:59:33') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-21 15:59:33')
    
      ORDER BY  c.lft,   
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
      LIMIT 9

    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.43 ms
    checking permissions	0.03 ms
    Opening tables	0.27 ms
    After opening tables	0.04 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.17 ms
    Optimizing	0.11 ms
    Statistics	0.28 ms
    Preparing	0.04 ms
    Unlocking tables	0.03 ms
    Preparing	0.08 ms
    Sorting result	0.04 ms
    Executing	0.02 ms
    Sending data	0.06 ms
    Creating sort index	0.43 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.06 ms
    Query end	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.06 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/legacy/model/legacy.php:307
    16	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
    15	JModelList->getItems()	JROOT/components/com_content/models/articles.php:536
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:422
    12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:143
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->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]

    ---

29. Abfragezeit: 0.93 ms Nach letzter Abfrage: 2.51 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 3.958 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` = 759 
      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.07 ms
    checking permissions	0.02 ms
    Opening tables	0.14 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.06 ms
    Optimizing	0.06 ms
    Statistics	0.14 ms
    Preparing	0.02 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.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
    15	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:422
    12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:143
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->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.06 ms Nach letzter Abfrage: 1.52 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 3.972 MB Zeilen zurückgegeben: 1

    SELECT 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 = 24 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-07-21 15:59:33') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-21 15:59:33')

    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

    Profil (Profile)

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.06 ms
    Optimizing	0.10 ms
    Statistics	0.19 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.07 ms
    Executing	0.02 ms
    Sending data	0.10 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.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:1720
    17	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:334
    16	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:281
    15	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:231
    14	JModelList->getPagination()	JROOT/components/com_content/models/category.php:265
    13	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:422
    12	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:143
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->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: 0.67 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 3.982 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.category' 
      AND `m`.`content_item_id` = 24 
      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.03 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.06 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.03 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
    12	JHelperTags->getItemTags()	JROOT/libraries/legacy/view/category.php:225
    11	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
    10	ContentViewCategory->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.56 ms Nach letzter Abfrage: 12.42 ms Abfragespeichernutzung: 0.042 MB Speichernutzung vor Abfrage: 4.037 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=24
    
      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.25 ms
    checking permissions	0.03 ms
    Opening tables	0.08 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.10 ms
    Optimizing	0.07 ms
    Statistics	0.22 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.05 ms
    Sorting result	0.03 ms
    Executing	0.02 ms
    Sending data	0.05 ms
    Creating sort index	0.17 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.06 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    18	JCategories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
    17	FieldsModelFields->getListQuery()	JROOT/libraries/legacy/model/list.php:132
    16	JModelList->_getListQuery()	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/category/view.html.php:108
    10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

33. Abfragezeit: 1.81 ms Nach letzter Abfrage: 0.61 ms Abfragespeichernutzung: 0.042 MB Speichernutzung vor Abfrage: 4.065 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 (24,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.23 ms
    checking permissions	0.03 ms
    Opening tables	0.24 ms
    After opening tables	0.03 ms
    System lock	0.03 ms
    table lock	0.04 ms
    init	0.10 ms
    Optimizing	0.08 ms
    Statistics	0.28 ms
    Preparing	0.10 ms
    Sorting result	0.06 ms
    Executing	0.02 ms
    Sending data	0.05 ms
    Creating sort index	0.10 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Query end	0.03 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
    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/category/view.html.php:108
    10	ContentViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:671
    9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
    8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
    7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:389
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

34. Abfragezeit: 4.08 ms Nach letzter Abfrage: 96.83 ms Abfragespeichernutzung: 0.189 MB Speichernutzung vor Abfrage: 4.685 MB Zeilen zurückgegeben: 179

    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 <= '2025-07-21 15:59:33') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-07-21 15:59:33') 
      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.17 ms
    checking permissions	0.02 ms
    Opening tables	0.11 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.08 ms
    Optimizing	0.08 ms
    Statistics	0.13 ms
    Preparing	0.08 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	2.93 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.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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:169
    16	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
    15	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
    14	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    13	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
    12	JDocumentHtml->countModules()	JROOT/templates/jp-school/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
    11	Warp\Joomla\Helper\WidgetsHelper->count()	JROOT/templates/jp-school/layouts/theme.config.php:28
    10	include JROOT/templates/jp-school/layouts/theme.config.php	JROOT/templates/jp-school/layouts/theme.php:10
    9	include JROOT/templates/jp-school/layouts/theme.php	JROOT/templates/jp-school/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-school/index.php:16
    7	require JROOT/templates/jp-school/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

35. Abfragezeit: 1.29 ms Nach letzter Abfrage: 114.62 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 5.218 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.21 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.03 ms
    table lock	0.03 ms
    init	0.09 ms
    Optimizing	0.06 ms
    Statistics	0.16 ms
    Preparing	0.03 ms
    Unlocking tables	0.02 ms
    Preparing	0.06 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.05 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.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]

    ---

36. Abfragezeit: 130.35 ms Nach letzter Abfrage: 0.48 ms Abfragespeichernutzung: 2.332 MB Speichernutzung vor Abfrage: 5.249 MB Zeilen zurückgegeben: 299

    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 <= '2025-07-21 15:59:33') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-21 15:59:33') 
      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 <= '2025-07-21 15:59:33') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-21 15:59:33') 
      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	293	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	609	Using where; Using join buffer (flat, BNL join)

    Profil (Profile)

    Status	Duration
    Starting	0.20 ms
    checking permissions	0.02 ms
    Opening tables	0.17 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.15 ms
    Optimizing	0.09 ms
    Statistics	0.21 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.08 ms
    Creating tmp table	0.21 ms
    Sorting result	0.09 ms
    Executing	0.02 ms
    Sending data	117.59 ms
    Creating sort index	8.93 ms
    Removing tmp table	0.80 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.05 ms
    Query end	0.03 ms
    Starting cleanup	0.01 ms
    Freeing items	0.06 ms
    Updating status	0.04 ms
    Reset for next command	0.03 ms

    Aufrufstapel (Call Stack)

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

    ---

37. Abfragezeit: 0.80 ms Nach letzter Abfrage: 26.45 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 8.365 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 (758,757,756,755,754,753,752,750,748,747,746,743,744,742,741,739,737,735,736,734,733,732,731,730,729,727,728,726,724,723,720,721,722,718,715,689,713,706,710,709,705,698,697,696,692,686,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.20 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.08 ms
    Optimizing	0.05 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.02 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
    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]

    ---

38. Abfragezeit: 6.86 ms Nach letzter Abfrage: 763.11 ms Abfragespeichernutzung: 0.547 MB Speichernutzung vor Abfrage: 9.478 MB Zeilen zurückgegeben: 306

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

    Profil (Profile)

    Status	Duration
    Starting	0.15 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.09 ms
    Optimizing	0.05 ms
    Statistics	0.21 ms
    Preparing	0.06 ms
    Executing	0.02 ms
    Sending data	5.78 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Updating status	0.04 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]

    ---

39. Abfragezeit: 1.54 ms Nach letzter Abfrage: 1581.99 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 5.988 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.23 ms
    checking permissions	0.02 ms
    Opening tables	0.08 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.03 ms
    init	0.17 ms
    Optimizing	0.08 ms
    Statistics	0.19 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.08 ms
    Creating sort index	0.17 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]

    ---

40. Abfragezeit: 1.21 ms Nach letzter Abfrage: 0.73 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 6.012 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	965	Using where

    Profil (Profile)

    Status	Duration
    Starting	0.05 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.04 ms
    Optimizing	0.05 ms
    Statistics	0.09 ms
    Preparing	0.04 ms
    Executing	0.02 ms
    Sending data	0.51 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.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
    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]

    ---

41. Abfragezeit: 1.13 ms Nach letzter Abfrage: 0.99 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 6.043 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.12 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.07 ms
    Optimizing	0.05 ms
    Statistics	0.16 ms
    Preparing	0.04 ms
    Unlocking tables	0.02 ms
    Preparing	0.05 ms
    Sorting result	0.02 ms
    Executing	0.01 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.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
    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.05 ms Nach letzter Abfrage: 1.19 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 6.069 MB Zeilen zurückgegeben: 2

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

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.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.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.02 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
    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: 0.96 ms Nach letzter Abfrage: 0.99 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 6.090 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.10 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.07 ms
    Optimizing	0.04 ms
    Statistics	0.11 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.14 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.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.01 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: 0.95 ms Nach letzter Abfrage: 0.89 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 6.112 MB Zeilen zurückgegeben: 2

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

    Erklären

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

    Profil (Profile)

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

    ---

45. Abfragezeit: 1.13 ms Nach letzter Abfrage: 0.89 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 6.133 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.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.23 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.15 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.01 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]

    ---

46. Abfragezeit: 2.03 ms Nach letzter Abfrage: 5.47 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 6.182 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #57

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

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.17 ms
    checking permissions	0.02 ms
    Opening tables	0.12 ms
    After opening tables	0.04 ms
    System lock	0.02 ms
    table lock	0.04 ms
    init	0.13 ms
    Optimizing	0.06 ms
    Statistics	0.11 ms
    Preparing	0.10 ms
    Creating tmp table	0.06 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.56 ms
    Creating sort index	0.06 ms
    Removing tmp table	0.12 ms
    Creating sort index	0.02 ms
    End of update loop	0.01 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.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.01 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]

    ---

47. Abfragezeit: 1.82 ms Nach letzter Abfrage: 3.09 ms Abfragespeichernutzung: 0.045 MB Speichernutzung vor Abfrage: 6.200 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.07 ms
    checking permissions	0.02 ms
    closing tables	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.50 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.04 ms
    Opening tables	0.08 ms
    After opening tables	0.02 ms
    checking permissions	0.29 ms
    closing tables	0.04 ms
    checking permissions	0.03 ms
    Executing	0.01 ms
    Sending data	0.11 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.13 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.04 ms
    Reset for next command	0.01 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]

    ---

48. Abfragezeit: 2.72 ms Nach letzter Abfrage: 0.75 ms Abfragespeichernutzung: 0.044 MB Speichernutzung vor Abfrage: 6.299 MB Zeilen zurückgegeben: 0

    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 <= '2025-07-21 15:59:33') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-21 15:59:33') 
      AND (a.start_date  >= '2025-07-21 15:45:00') 
      AND a.language in ('de-DE','*')
    
      GROUP BY a.id
    
      ORDER BY a.start_date asc 
      LIMIT 15

    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	1	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.16 ms
    checking permissions	0.02 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.07 ms
    Statistics	0.32 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.09 ms
    Creating tmp table	0.10 ms
    Sorting for group	0.09 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    Creating sort index	0.68 ms
    Creating sort index	0.06 ms
    Removing tmp table	0.18 ms
    Creating sort index	0.03 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.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.03 ms
    Removing tmp table	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
    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]

    ---

49. Abfragezeit: 1.19 ms Nach letzter Abfrage: 90.25 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 6.340 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.23 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.07 ms
    Optimizing	0.05 ms
    Statistics	0.14 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    Creating sort index	0.12 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
    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]

    ---

50. Abfragezeit: 16.11 ms Nach letzter Abfrage: 0.58 ms Abfragespeichernutzung: 0.146 MB Speichernutzung vor Abfrage: 6.366 MB Zeilen zurückgegeben: 83

    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 <= '2025-07-21 15:59:33') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-21 15:59:33') 
      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 <= '2025-07-21 15:59:33') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-21 15:59:33') 
      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	88	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	609	Using where; Using join buffer (flat, BNL join)

    Profil (Profile)

    Status	Duration
    Starting	0.28 ms
    checking permissions	0.03 ms
    Opening tables	0.17 ms
    After opening tables	0.03 ms
    System lock	0.03 ms
    table lock	0.03 ms
    init	0.20 ms
    Optimizing	0.13 ms
    Statistics	0.31 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.09 ms
    Creating tmp table	0.16 ms
    Sorting result	0.07 ms
    Executing	0.02 ms
    Sending data	12.29 ms
    Creating sort index	1.38 ms
    Removing tmp table	0.25 ms
    Creating sort index	0.04 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Removing tmp table	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.05 ms
    Query end	0.05 ms
    Starting cleanup	0.02 ms
    Freeing items	0.06 ms
    Updating status	0.05 ms
    Reset for next command	0.03 ms

    Aufrufstapel (Call Stack)

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

    ---

51. Abfragezeit: 0.83 ms Nach letzter Abfrage: 1.44 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 6.734 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 (740,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.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.06 ms
    Optimizing	0.04 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.03 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.12 ms
    Starting cleanup	0.02 ms
    Freeing items	0.01 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

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

    ---

52. Abfragezeit: 3.23 ms Nach letzter Abfrage: 128.41 ms Abfragespeichernutzung: 0.126 MB Speichernutzung vor Abfrage: 7.007 MB Zeilen zurückgegeben: 83

    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_order	137	const	89	Using index condition; Using where

    Profil (Profile)

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

    ---

53. Abfragezeit: 4.15 ms Nach letzter Abfrage: 143.14 ms Abfragespeichernutzung: 0.108 MB Speichernutzung vor Abfrage: 6.544 MB Zeilen zurückgegeben: 11

    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 (31) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-07-21 15:59:33') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-07-21 15:59:33')
    
      ORDER BY a.ordering ASC 
      LIMIT 20

    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	index_merge	idx_access,idx_state,idx_catid	idx_catid,idx_state	4,1	NULL	63	Using intersect(idx_catid,idx_state); 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.44 ms
    checking permissions	0.03 ms
    Opening tables	0.11 ms
    After opening tables	0.03 ms
    System lock	0.03 ms
    table lock	0.03 ms
    init	0.20 ms
    Optimizing	0.12 ms
    Statistics	0.29 ms
    Preparing	0.03 ms
    Unlocking tables	0.02 ms
    Preparing	0.11 ms
    Sorting result	0.05 ms
    Executing	0.02 ms
    Sending data	0.06 ms
    Creating sort index	2.15 ms
    End of update loop	0.03 ms
    Query end	0.03 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.03 ms
    Query end	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.03 ms
    Updating status	0.05 ms
    Reset for next command	0.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]

    ---

54. Abfragezeit: 1.27 ms Nach letzter Abfrage: 2.59 ms Abfragespeichernutzung: 0.048 MB Speichernutzung vor Abfrage: 6.884 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=31
    
      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.17 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.08 ms
    Optimizing	0.06 ms
    Statistics	0.17 ms
    Preparing	0.02 ms
    Unlocking tables	0.02 ms
    Preparing	0.05 ms
    Sorting result	0.03 ms
    Executing	0.02 ms
    Sending data	0.04 ms
    Creating sort index	0.15 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.02 ms
    Query end	0.02 ms
    Starting cleanup	0.03 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
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    27	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    26	JCategories->get()	JROOT/components/com_content/router.php:72
    25	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:117
    24	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
    23	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
    22	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
    21	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
    20	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    19	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    18	JRoute::_()	JROOT/modules/mod_articles_category/helper.php:264
    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]

    ---

55. Abfragezeit: 1.41 ms Nach letzter Abfrage: 2.15 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 6.907 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 (24,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.20 ms
    checking permissions	0.03 ms
    Opening tables	0.11 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.10 ms
    Optimizing	0.08 ms
    Statistics	0.17 ms
    Preparing	0.09 ms
    Sorting result	0.04 ms
    Executing	0.02 ms
    Sending data	0.05 ms
    Creating sort index	0.07 ms
    End of update loop	0.03 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    Unlocking tables	0.02 ms
    closing tables	0.04 ms
    Query end	0.03 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
    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]

    ---

56. Abfragezeit: 1.61 ms Nach letzter Abfrage: 233.36 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 7.375 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.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.03 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Filling schema table	0.02 ms
    checking permissions	0.63 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.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.06 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]

    ---

57. Abfragezeit: 2.12 ms Nach letzter Abfrage: 4.55 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 7.470 MB Zeilen zurückgegeben: 0
    Doppelte Abfragen: #46

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

    Erklären

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

    Profil (Profile)

    Status	Duration
    Starting	0.17 ms
    checking permissions	0.03 ms
    Opening tables	0.06 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    table lock	0.02 ms
    init	0.11 ms
    Optimizing	0.07 ms
    Statistics	0.07 ms
    Preparing	0.08 ms
    Creating tmp table	0.07 ms
    Sorting result	0.03 ms
    Executing	0.02 ms
    Sending data	0.66 ms
    Creating sort index	0.09 ms
    Removing tmp table	0.17 ms
    Creating sort index	0.06 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.02 ms
    Query end	0.02 ms
    closing tables	0.02 ms
    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.01 ms
    Freeing items	0.02 ms
    Updating status	0.03 ms
    Reset for next command	0.02 ms

    Aufrufstapel (Call Stack)

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

    ---