{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1611601407,
                "last": 1611601407,
                "now": 1611601407
            },
            "token": "wft4RRKyC2uj2OxxYo1aZlp6bFD2SVSt"
        },
        "registry": {
            "plg_system_eprivacy": true,
            "plg_system_eprivacy_non_eu": true
        },
        "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

11 ausgeführte Abfragen 5.07 ms

1. Abfragezeit: 0.34 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 3.840 MB Zeilen zurückgegeben: 0

   SELECT `data`
   
     FROM `jos_session`
   
     WHERE `session_id` = X'71336462636d387267646563393938393632696f746e61757132'

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jos_session	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

   Profil (Profile)

   Status	Duration
   starting	0.03 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   logging slow query	0.02 ms
   cleaning up	0.01 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   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:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::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.21 ms Nach letzter Abfrage: 9.76 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 3.998 MB Zeilen zurückgegeben: 0

   SELECT `session_id`
   
     FROM `jos_session`
   
     WHERE `session_id` = X'71336462636d387267646563393938393632696f746e61757132' 
     LIMIT 1

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jos_session	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

   Profil (Profile)

   Status	Duration
   starting	0.02 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   logging slow query	0.03 ms
   cleaning up	0.01 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::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.46 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 4.003 MB

   INSERT INTO `jos_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'71336462636d387267646563393938393632696f746e61757132', 1, 1611601407, 0, '', 0)

   Erklären

   „EXPLAIN“ unmöglich für Abfrage: INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'71336462636d387267646563393938393632696f746e61757132', 1, 1611601407, 0, '', 0)

   Profil (Profile)

   Status	Duration
   starting	0.02 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.01 ms
   update	0.08 ms
   end	0.01 ms
   query end	0.24 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   logging slow query	0.02 ms
   cleaning up	0.01 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

4. Abfragezeit: 0.25 ms Nach letzter Abfrage: 58.65 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 4.554 MB Zeilen zurückgegeben: 4

   SELECT id, rules
   
     FROM `jos_viewlevels`

   Erklären

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

   Profil (Profile)

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   logging slow query	0.03 ms
   cleaning up	0.01 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->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.23 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 4.566 MB Zeilen zurückgegeben: 1

   SELECT b.id
   
     FROM jos_usergroups AS a
   
     LEFT JOIN jos_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	filtered	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	10	20.00	Using where; Using index

   Profil (Profile)

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.02 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   logging slow query	0.02 ms
   cleaning up	0.01 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->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.37 ms Nach letzter Abfrage: 128.63 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 6.304 MB Zeilen zurückgegeben: 5

   SELECT `setting_id`,`meta_key`,`meta_value`
   
     FROM `jos_ess_settings`
   
     WHERE `setting_id`=1

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jos_ess_settings	ALL	setting_id	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	4	75.00	Using where

   Profil (Profile)

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.01 ms
   executing	0.02 ms
   Sending data	0.04 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   logging slow query	0.03 ms
   cleaning up	0.01 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   14	JDatabaseDriver->loadAssocList()	JROOT/libraries/ess/base/SimpleSocialMediaStreamMeta.php:543
   13	SimpleSocialMediaStreamMeta->getMetaData()	JROOT/libraries/ess/SimpleSocialMediaStream.php:165
   12	SimpleSocialMediaStream->defineServices()	JROOT/libraries/ess/SimpleSocialMediaStream.php:67
   11	SimpleSocialMediaStream->__construct()	JROOT/libraries/ess/SimpleSocialMediaStream.php:52
   10	SimpleSocialMediaStream::instance()	JROOT/libraries/ess/SimpleSocialMediaStream.php:197
   9	simpleSocialMediaStream()	JROOT/plugins/system/simplesocialstreamnotifications/simplesocialstreamnotifications.php:40
   8	PlgSystemSimplesocialstreamnotifications->init()	JROOT/plugins/system/simplesocialstreamnotifications/simplesocialstreamnotifications.php:29
   7	PlgSystemSimplesocialstreamnotifications->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Abfragezeit: 0.32 ms Nach letzter Abfrage: 69.14 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 6.976 MB Zeilen zurückgegeben: 1

   SELECT `enabled`
   
     FROM `jos_extensions`
   
     WHERE `element` = 'com_akeeba' 
     AND `type` = 'component'

   Erklären

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

   Profil (Profile)

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.07 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   logging slow query	0.05 ms
   cleaning up	0.01 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:36
   7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Abfragezeit: 0.66 ms Nach letzter Abfrage: 50.52 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 7.397 MB

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

   Erklären

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jos_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

   Profil (Profile)

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.02 ms
   System lock	0.07 ms
   updating	0.05 ms
   end	0.01 ms
   query end	0.35 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   logging slow query	0.02 ms
   cleaning up	0.00 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:47
   8	plgSystemK2->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->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.32 ms Nach letzter Abfrage: 114.86 ms Abfragespeichernutzung: 0.008 MB Speichernutzung vor Abfrage: 8.746 MB Zeilen zurückgegeben: 1

   SELECT `extension_id`,`name`,`enabled`,`params`
   
     FROM jos_extensions
   
     WHERE `type` = 'component' 
     AND `element` = 'com_osdownloads'

   Erklären

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

   Profil (Profile)

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   logging slow query	0.02 ms
   cleaning up	0.01 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
   15	JDatabaseDriver->loadObject()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:152
   14	Alledia\Framework\Joomla\Extension\Generic->getDataFromDatabase()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:122
   13	Alledia\Framework\Joomla\Extension\Generic->__construct()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Licensed.php:51
   12	Alledia\Framework\Joomla\Extension\Licensed->__construct()	JROOT/libraries/allediaframework/Framework/Factory.php:38
   11	Alledia\Framework\Factory::getExtension()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Helper.php:148
   10	Alledia\Framework\Joomla\Extension\Helper::getExtensionForElement()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Helper.php:109
   9	Alledia\Framework\Joomla\Extension\Helper::loadLibrary()	JROOT/administrator/components/com_osdownloads/include.php:35
   8	require_once JROOT/administrator/components/com_osdownloads/include.php	JROOT/components/com_osdownloads/router.php:17
   7	require_once JROOT/components/com_osdownloads/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
   6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
   5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->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: 1.21 ms Nach letzter Abfrage: 232.72 ms Abfragespeichernutzung: 0.011 MB Speichernutzung vor Abfrage: 10.521 MB Zeilen zurückgegeben: 0

    SELECT DISTINCT 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, g.note as group_note
    
      FROM jos_fields AS a
    
      LEFT JOIN `jos_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN jos_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN jos_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN jos_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN jos_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_users.reset_request' 
      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	filtered	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; filesort wurde genutzt
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	DB1267483.a.language	1	100.00	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	DB1267483.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	DB1267483.a.access	1	100.00	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	DB1267483.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	DB1267483.a.group_id	1	100.00	Using where

    Profil (Profile)

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.12 ms
    preparing	0.03 ms
    Creating tmp table	0.05 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.49 ms
    Creating sort index	0.02 ms
    end	0.01 ms
    removing tmp table	0.08 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    logging slow query	0.02 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    19	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:286
    18	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
    17	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:321
    14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/reset.php:110
    13	UsersModelReset->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:242
    12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/reset.php:35
    11	UsersModelReset->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/reset/view.html.php:55
    9	UsersViewReset->display()	JROOT/components/com_users/controller.php:139
    8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
    6	require_once JROOT/components/com_users/users.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Abfragezeit: 0.71 ms Nach letzter Abfrage: 115.71 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 11.088 MB Zeilen zurückgegeben: 7

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM jos_modules AS m
    
      LEFT JOIN jos_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN jos_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 <= '2021-01-25 19:03:28') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-25 19:03:28') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 498 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Erklären

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	33	100.00	Using index condition; Using where; filesort wurde genutzt
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	DB1267483.m.id	1	100.00	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	DB1267483.m.module,const	1	100.00	Using index condition; Using where

    Profil (Profile)

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.07 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.28 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.03 ms
    cleaning up	0.01 ms

    Aufrufstapel (Call Stack)

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	Der selbe Aufruf in der Zeile darunter.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
    8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/ffuw_beez3/index.php:18
    7	require JROOT/templates/ffuw_beez3/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung

SELECT-Tabellen:

1. 1 × SELECT `data` 
     FROM `jos_session`

2. 1 × SELECT `session_id` 
     FROM `jos_session`

3. 1 × SELECT id, rules 
     FROM `jos_viewlevels

4. 1 × SELECT b.id 
     FROM jos_usergroups AS a 
     LEFT JOIN jos_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt

5. 1 × SELECT `setting_id`,`meta_key`,`meta_value` 
     FROM `jos_ess_settings`

6. 1 × SELECT `enabled` 
     FROM `jos_extensions`

7. 1 × SELECT `extension_id`,`name`,`enabled`,`params` 
     FROM jos_extensions

8. 1 × SELECT DISTINCT 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, g.note as group_note 
     FROM jos_fields AS a 
     LEFT JOIN `jos_languages` AS l 
     ON l.lang_code = a.language 
     LEFT JOIN jos_users AS uc 
     ON uc.id=a.checked_out 
     LEFT JOIN jos_viewlevels AS ag 
     ON ag.id = a.access 
     LEFT JOIN jos_users AS ua 
     ON ua.id = a.created_user_id 
     LEFT JOIN jos_fields_groups AS g 
     ON g.id = a.group_id

9. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
     FROM jos_modules AS m 
     LEFT JOIN jos_modules_menu AS mm 
     ON mm.moduleid = m.id 
     LEFT JOIN jos_extensions AS e 
     ON e.element = m.module 
     AND e.client_id = m.client_id

Andere Tabellen:

1. 1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  (X'71336462636d387267646563393938393632696f746e61757132', 1, 1611601407, 0, '', 0

2. 1 × UPDATE `jos_extensions` 
     SET `params` = '{\"mediaversion\":\"9d73cf881089608b10d22efbced1813a\"}'