Workshop Steppach 2025

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1732184267,
                "last": 1732184267,
                "now": 1732184267
            },
            "token": "9bHPGc7lWcBZujBqsL8vq3ol1kmgtt1j"
        },
        "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 6.36 ms

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

   SELECT `data`
   
     FROM `agip_session`
   
     WHERE `session_id` = X'6472337075746631736e71333461753834316d75343533696133'

   Erklären

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

   Profil (Profile)

   Status	Duration
   Starting	0.07 ms
   checking permissions	0.05 ms
   Opening tables	0.26 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   Opening tables	0.02 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.03 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   init	0.02 ms
   Optimizing	0.02 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
   Commit	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.02 ms
   Reset for next command	0.02 ms

   Aufrufstapel (Call Stack)

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

   SELECT `session_id`
   
     FROM `agip_session`
   
     WHERE `session_id` = X'6472337075746631736e71333461753834316d75343533696133' 
     LIMIT 1

   Erklären

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

   Profil (Profile)

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.06 ms
   Preparing	0.02 ms
   Executing	0.02 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.02 ms
   Reset for next command	0.02 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   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: 0.79 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 1.276 MB

   INSERT INTO `agip_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'6472337075746631736e71333461753834316d75343533696133', 1, 1732184267, 0, '', 0)

   Erklären

   „EXPLAIN“ unmöglich für Abfrage: INSERT INTO `agip_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6472337075746631736e71333461753834316d75343533696133', 1, 1732184267, 0, '', 0)

   Profil (Profile)

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.02 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.02 ms
   Update	0.05 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.08 ms
   Writing to binlog	0.02 ms
   Commit	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.02 ms
   Reset for next command	0.02 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   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.12 ms Nach letzter Abfrage: 2.09 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.449 MB Zeilen zurückgegeben: 5

   SELECT id, rules
   
     FROM `agip_viewlevels`

   Erklären

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

   Profil (Profile)

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.02 ms
   Opening tables	0.22 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   Opening tables	0.02 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.04 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.02 ms
   Preparing	0.02 ms
   Executing	0.02 ms
   Sending data	0.08 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.02 ms
   Reset for next command	0.02 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   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.14 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.463 MB Zeilen zurückgegeben: 2

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

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

   Profil (Profile)

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.02 ms
   Opening tables	0.21 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.03 ms
   Opening tables	0.02 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.03 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.10 ms
   Preparing	0.02 ms
   Unlocking tables	0.02 ms
   Preparing	0.02 ms
   Executing	0.02 ms
   Sending data	0.03 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.02 ms
   Reset for next command	0.02 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/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.37 ms Nach letzter Abfrage: 32.03 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 4.665 MB

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

   Erklären

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

   Profil (Profile)

   Status	Duration
   Starting	0.07 ms
   checking permissions	0.02 ms
   Opening tables	0.25 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.02 ms
   Opening tables	0.02 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   table lock	0.04 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   init for update	0.05 ms
   Updating	0.04 ms
   End of update loop	0.02 ms
   Query end	0.02 ms
   Commit	0.10 ms
   Writing to binlog	0.02 ms
   Commit	0.02 ms
   closing tables	0.02 ms
   Unlocking tables	0.02 ms
   closing tables	0.02 ms
   Starting cleanup	0.02 ms
   Freeing items	0.02 ms
   Updating status	0.03 ms
   Reset for next command	0.02 ms

   Aufrufstapel (Call Stack)

   #	Aufrufer	Datei und Zeilennummer
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
   4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
   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: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 `agip_session`

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

3. 1 × SELECT id, rules 
     FROM `agip_viewlevels

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

Andere Tabellen:

1. 1 × INSERT INTO `agip_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  (X'6472337075746631736e71333461753834316d75343533696133', 1, 1732184267, 0, '', 0

2. 1 × UPDATE `agip_extensions` 
     SET `params` = '{\"mediaversion\":\"b676fa7fa7860bc3e00e91aa659f7c76\"}'

0 Nachrichten protokolliert