Hobbyfotograf aus Leidenschaft

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

6 ausgeführte Abfragen 7.31 ms

1. Abfragezeit: 1.25 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.043 MB Zeilen zurückgegeben: 0

   SELECT `data`
   
     FROM `sandtaucher_session`
   
     WHERE `session_id` = X'7373726f35726a6e61666964353770306737346d65706b6c626f'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	sandtaucher_session	const	PRIMARY	PRIMARY	194	const	1

   Profil (Profile)

   Status	Duration
   starting	0.30 ms
   checking permissions	0.04 ms
   Opening tables	0.14 ms
   After opening tables	0.05 ms
   System lock	0.03 ms
   Table lock	0.03 ms
   init	0.06 ms
   optimizing	0.05 ms
   statistics	0.08 ms
   preparing	0.03 ms
   executing	0.04 ms
   end	0.03 ms
   query end	0.03 ms
   closing tables	0.03 ms
   Unlocking tables	0.04 ms
   freeing items	0.03 ms
   updating status	0.06 ms
   cleaning up	0.03 ms

   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()	Derselbe 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:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   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:386
   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.85 ms Nach letzter Abfrage: 4.57 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.148 MB Zeilen zurückgegeben: 0

   SELECT `session_id`
   
     FROM `sandtaucher_session`
   
     WHERE `session_id` = X'7373726f35726a6e61666964353770306737346d65706b6c626f' 
     LIMIT 1

   Explain

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

   Profil (Profile)

   Status	Duration
   starting	0.07 ms
   checking permissions	0.03 ms
   Opening tables	0.04 ms
   After opening tables	0.05 ms
   System lock	0.03 ms
   Table lock	0.03 ms
   init	0.04 ms
   optimizing	0.04 ms
   statistics	0.06 ms
   preparing	0.03 ms
   executing	0.07 ms
   end	0.03 ms
   query end	0.03 ms
   closing tables	0.03 ms
   Unlocking tables	0.05 ms
   freeing items	0.03 ms
   updating status	0.06 ms
   cleaning up	0.05 ms

   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:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   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:386
   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: 1.07 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 4.153 MB

   INSERT INTO `sandtaucher_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'7373726f35726a6e61666964353770306737346d65706b6c626f', 1, 1660506053, 0, '', 0)

   Explain

   „EXPLAIN“ unmöglich für Abfrage: INSERT INTO `sandtaucher_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'7373726f35726a6e61666964353770306737346d65706b6c626f', 1, 1660506053, 0, '', 0)

   Profil (Profile)

   Status	Duration
   starting	0.07 ms
   checking permissions	0.03 ms
   Opening tables	0.06 ms
   After opening tables	0.03 ms
   System lock	0.05 ms
   Table lock	0.03 ms
   init	0.04 ms
   update	0.34 ms
   end	0.03 ms
   query end	0.03 ms
   closing tables	0.03 ms
   Unlocking tables	0.10 ms
   freeing items	0.03 ms
   updating status	0.06 ms
   cleaning up	0.03 ms

   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:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   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:386
   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: 1.29 ms Nach letzter Abfrage: 19.94 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.746 MB Zeilen zurückgegeben: 4

   SELECT id, rules
   
     FROM `sandtaucher_viewlevels`

   Explain

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

   Profil (Profile)

   Status	Duration
   starting	0.12 ms
   checking permissions	0.04 ms
   Opening tables	0.28 ms
   After opening tables	0.05 ms
   System lock	0.03 ms
   Table lock	0.05 ms
   init	0.05 ms
   optimizing	0.04 ms
   statistics	0.04 ms
   preparing	0.05 ms
   executing	0.03 ms
   Sending data	0.11 ms
   end	0.03 ms
   query end	0.03 ms
   closing tables	0.03 ms
   Unlocking tables	0.03 ms
   freeing items	0.03 ms
   updating status	0.06 ms
   cleaning up	0.03 ms

   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:318
   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:225
   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: 1.31 ms Nach letzter Abfrage: 0.26 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.758 MB Zeilen zurückgegeben: 2

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

   Explain

   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	3	Using where

   Profil (Profile)

   Status	Duration
   starting	0.09 ms
   checking permissions	0.03 ms
   checking permissions	0.03 ms
   Opening tables	0.11 ms
   After opening tables	0.06 ms
   System lock	0.03 ms
   Table lock	0.03 ms
   init	0.05 ms
   optimizing	0.05 ms
   statistics	0.15 ms
   preparing	0.03 ms
   Unlocking tables	0.06 ms
   executing	0.04 ms
   Sending data	0.15 ms
   end	0.05 ms
   query end	0.03 ms
   closing tables	0.03 ms
   Unlocking tables	0.03 ms
   freeing items	0.03 ms
   updating status	0.06 ms
   cleaning up	0.04 ms

   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:318
   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:225
   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: 1.55 ms Nach letzter Abfrage: 86.38 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 6.947 MB

   UPDATE `sandtaucher_extensions`
   
     SET `params` = '{\"mediaversion\":\"785e488a97d8f95175a0c32c7ddecbf9\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

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

   Profil (Profile)

   Status	Duration
   starting	0.18 ms
   checking permissions	0.04 ms
   Opening tables	0.11 ms
   After opening tables	0.05 ms
   System lock	0.03 ms
   Table lock	0.03 ms
   init	0.47 ms
   updating	0.18 ms
   end	0.06 ms
   query end	0.03 ms
   closing tables	0.03 ms
   Unlocking tables	0.06 ms
   freeing items	0.03 ms
   updating status	0.06 ms
   cleaning up	0.03 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   15	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   14	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   11	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Cache/Cache.php:518
   10	Joomla\CMS\Cache\Cache::getWorkarounds()	JROOT/libraries/src/Cache/Controller/PageController.php:105
   9	Joomla\CMS\Cache\Controller\PageController->get()	JROOT/plugins/system/cache/cache.php:123
   8	PlgSystemCache->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:668
   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:225
   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 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung

SELECT-Tabellen:

1. 1 × SELECT `data` 
     FROM `sandtaucher_session`

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

3. 1 × SELECT id, rules 
     FROM `sandtaucher_viewlevels

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

Andere Tabellen:

1. 1 × INSERT INTO `sandtaucher_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  (X'7373726f35726a6e61666964353770306737346d65706b6c626f', 1, 1660506053, 0, '', 0

2. 1 × UPDATE `sandtaucher_extensions` 
     SET `params` = '{\"mediaversion\":\"785e488a97d8f95175a0c32c7ddecbf9\"}'