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

14 ausgeführte Abfragen 28.35 ms

1. Abfragezeit: 0.74 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 3.878 MB Zeilen zurückgegeben: 0

   SELECT `session_id`
   
     FROM `oehxn_session`
   
     WHERE `session_id` = X'3730333733313938613431316433643465653035363661616336383032623031' 
     LIMIT 1

   Explain

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

   Profil (Profile)

   Status	Duration
   starting	0.11 ms
   checking permissions	0.01 ms
   Opening tables	0.20 ms
   System lock	0.02 ms
   init	0.02 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   preparing	0.01 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.05 ms
   freeing items	0.04 ms
   logging slow query	0.01 ms
   cleaning up	0.00 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: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]

   ---

2. Abfragezeit: 4.13 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 3.884 MB

   INSERT INTO `oehxn_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3730333733313938613431316433643465653035363661616336383032623031', 1, 1620696634, 0, '', 0)

   Explain

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

   Profil (Profile)

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   System lock	0.01 ms
   init	0.01 ms
   update	0.09 ms
   end	0.01 ms
   query end	3.80 ms
   closing tables	0.03 ms
   freeing items	0.04 ms
   logging slow query	0.01 ms
   cleaning up	0.00 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: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: 1.51 ms Nach letzter Abfrage: 2.15 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 4.098 MB Zeilen zurückgegeben: 41

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `oehxn_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	oehxn_extensions	ref	extension	extension	82	const	41	Using where

   Profil (Profile)

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

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Derselbe Aufruf in der Zeile darunter.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
   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]

   ---

4. Abfragezeit: 0.60 ms Nach letzter Abfrage: 1.87 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.354 MB Zeilen zurückgegeben: 4

   SELECT id, rules
   
     FROM `oehxn_viewlevels`

   Explain

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

   Profil (Profile)

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.24 ms
   System lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.01 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.04 ms
   logging slow query	0.01 ms
   cleaning up	0.00 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: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: 1.94 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.365 MB Zeilen zurückgegeben: 2

   SELECT b.id
   
     FROM oehxn_usergroups AS a
   
     LEFT JOIN oehxn_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; Using index

   Profil (Profile)

   Status	Duration
   starting	0.08 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	1.47 ms
   System lock	0.02 ms
   init	0.02 ms
   optimizing	0.02 ms
   statistics	0.07 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.05 ms
   logging slow query	0.01 ms
   cleaning up	0.00 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: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.92 ms Nach letzter Abfrage: 0.60 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 4.434 MB Zeilen zurückgegeben: 80

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM oehxn_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	oehxn_extensions	ref	extension	extension	82	const	106	Using where; filesort wurde genutzt

   Profil (Profile)

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

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Derselbe Aufruf in der Zeile darunter.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
   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]

   ---

7. Abfragezeit: 1.24 ms Nach letzter Abfrage: 13.80 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 6.109 MB Zeilen zurückgegeben: 12

   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 oehxn_menu AS m
   
     LEFT JOIN oehxn_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

   Explain

   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	32	Using where; filesort wurde genutzt
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	db469136980.m.component_id	1

   Profil (Profile)

   Status	Duration
   starting	0.14 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.26 ms
   System lock	0.02 ms
   init	0.04 ms
   optimizing	0.02 ms
   statistics	0.05 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sorting result	0.21 ms
   Sending data	0.12 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.03 ms
   freeing items	0.06 ms
   logging slow query	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Derselbe Aufruf in der Zeile darunter.
   16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
   13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
   11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
   10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
   9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
   8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
   7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
   6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
   5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
   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]

   ---

8. Abfragezeit: 0.63 ms Nach letzter Abfrage: 6.36 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 6.751 MB Zeilen zurückgegeben: 1

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

   Explain

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

   Profil (Profile)

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

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
   18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
   17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Derselbe Aufruf in der Zeile darunter.
   16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
   14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
   13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
   12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
   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/oziojquery/oziojquery.php:57
   8	plgSystemOziojquery->onAfterRoute()	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:1122
   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]

   ---

9. Abfragezeit: 4.01 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 6.745 MB

   UPDATE `oehxn_extensions`
   
     SET `params` = '{\"mediaversion\":\"83b87b18597b082664380ee6b97bd054\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

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

   Profil (Profile)

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   System lock	0.01 ms
   init	0.06 ms
   Updating	0.07 ms
   end	0.01 ms
   query end	3.63 ms
   closing tables	0.03 ms
   freeing items	0.04 ms
   logging slow query	0.02 ms
   cleaning up	0.01 ms

   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/oziojquery/oziojquery.php:57
   8	plgSystemOziojquery->onAfterRoute()	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:1122
   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: 0.68 ms Nach letzter Abfrage: 1.73 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 6.932 MB Zeilen zurückgegeben: 1

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

    Explain

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

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
    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.56 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 6.941 MB Zeilen zurückgegeben: 4

    SELECT id, home, template, s.params
    
      FROM oehxn_template_styles as s
    
      LEFT JOIN oehxn_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

    Explain

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

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
    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]

    ---

12. Abfragezeit: 9.10 ms Nach letzter Abfrage: 132.55 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 7.995 MB Zeilen zurückgegeben: 6

    SELECT
        p.*,
    	p.user_id AS _user_id,
        u.name AS _user_name,
        
      CASE WHEN (SELECT filename 
      FROM oehxn_fwg_files AS f 
      WHERE f.project_id = p.id 
      AND selected = 1 
      LIMIT 1) IS NOT NULL THEN (SELECT filename 
      FROM oehxn_fwg_files AS f 
      WHERE f.project_id = p.id 
      AND selected = 1 
      LIMIT 1) ELSE (SELECT filename 
      FROM oehxn_fwg_files AS f 
      WHERE f.project_id = p.id 
      ORDER BY ordering 
      LIMIT 1) END AS filename,
    	(SELECT COUNT(*) 
      FROM oehxn_fwg_projects AS pp 
      WHERE pp.parent = p.id 
      AND pp.published = 1) AS _subfolders
    
      FROM
        oehxn_fwg_projects AS p
        
      LEFT JOIN oehxn_users AS u 
      ON (u.id = p.user_id)
        
      LEFT JOIN oehxn_usergroups AS pg 
      ON (pg.id = p.gid)
    
      WHERE p.published = 1 
      AND p.parent = 0 
      AND (p.gid = 0 OR p.gid IS NULL)
    
      ORDER BY p.ordering 
      LIMIT 0, 20

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	p	ALL	published,gid	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	6	Using where; filesort wurde genutzt
    1	PRIMARY	u	eq_ref	PRIMARY	PRIMARY	4	db469136980.p.user_id	1
    1	PRIMARY	pg	eq_ref	PRIMARY	PRIMARY	4	db469136980.p.gid	1	Using index
    5	DEPENDENT SUBQUERY	pp	ALL	published	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	6	Using where
    4	DEPENDENT SUBQUERY	f	ref	project_id	project_id	4	db469136980.p.id	19	Using where; filesort wurde genutzt
    3	DEPENDENT SUBQUERY	f	ref	project_id	project_id	4	db469136980.p.id	19	Using where
    2	DEPENDENT SUBQUERY	f	ref	project_id	project_id	4	db469136980.p.id	19	Using where

    Profil (Profile)

    Status	Duration
    starting	0.25 ms
    checking permissions	0.01 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.57 ms
    System lock	0.02 ms
    init	0.08 ms
    optimizing	0.02 ms
    statistics	2.00 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sorting result	0.84 ms
    Sending data	0.07 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	3.12 ms
    optimizing	0.04 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.11 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.04 ms
    executing	0.01 ms
    Sending data	0.88 ms
    executing	0.01 ms
    Sorting result	0.06 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    executing	0.01 ms
    Sending data	0.03 ms
    executing	0.00 ms
    Sorting result	0.04 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sorting result	0.02 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    executing	0.00 ms
    Sorting result	0.04 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    executing	0.00 ms
    Sending data	0.03 ms
    executing	0.00 ms
    Sorting result	0.03 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.05 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_fwgallery/models/galleries.php:116
    11	fwGalleryModelGalleries->getList()	JROOT/components/com_fwgallery/views/galleries/view.html.php:18
    10	fwGalleryViewGalleries->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fwgallery/controller.php:19
    8	fwGalleryController->galleries()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:19
    6	require_once JROOT/components/com_fwgallery/fwgallery.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]

    ---

13. Abfragezeit: 0.40 ms Nach letzter Abfrage: 6.13 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 8.152 MB Zeilen zurückgegeben: 1

    SELECT
    	COUNT(*)
    
      FROM
    	oehxn_fwg_projects AS p
    	
      LEFT JOIN oehxn_usergroups AS pg 
      ON (pg.id = p.gid)
    
      WHERE p.published = 1 
      AND p.parent = 0 
      AND (p.gid = 0 OR p.gid IS NULL)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	p	ALL	published,gid	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	6	Using where
    1	SIMPLE	pg	eq_ref	PRIMARY	PRIMARY	4	db469136980.p.gid	1	Using index

    Profil (Profile)

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 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.03 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    13	JDatabaseDriver->loadResult()	JROOT/components/com_fwgallery/models/galleries.php:128
    12	fwGalleryModelGalleries->getQty()	JROOT/components/com_fwgallery/models/galleries.php:134
    11	fwGalleryModelGalleries->getPagination()	JROOT/components/com_fwgallery/views/galleries/view.html.php:19
    10	fwGalleryViewGalleries->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_fwgallery/controller.php:19
    8	fwGalleryController->galleries()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:19
    6	require_once JROOT/components/com_fwgallery/fwgallery.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]

    ---

14. Abfragezeit: 1.88 ms Nach letzter Abfrage: 244.28 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 8.659 MB Zeilen zurückgegeben: 2

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM oehxn_modules AS m
    
      LEFT JOIN oehxn_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN oehxn_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-05-11 01:30:34') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-05-11 01:30:34') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 116 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	range	PRIMARY,published,newsfeeds	published	5	NULL	5	Using where; filesort wurde genutzt
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	db469136980.m.module,const	1	Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	db469136980.m.id	3	Using where; Using index

    Profil (Profile)

    Status	Duration
    starting	0.18 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.85 ms
    System lock	0.02 ms
    init	0.07 ms
    optimizing	0.03 ms
    statistics	0.08 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sorting result	0.11 ms
    Sending data	0.10 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.07 ms
    logging slow query	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	Derselbe 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:581
    8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/beez3/index.php:18
    7	require JROOT/templates/beez3/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    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]

    ---

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

SELECT-Tabellen:

1. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
     FROM `oehxn_extensions`

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

3. 1 × SELECT id, rules 
     FROM `oehxn_viewlevels

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

5. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
     FROM oehxn_extensions

6. 1 × 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 oehxn_menu AS m 
     LEFT JOIN oehxn_extensions AS e 
     ON m.component_id = e.extension_id

7. 1 × SELECT * 
     FROM oehxn_languages

8. 1 × SELECT id, home, template, s.params 
     FROM oehxn_template_styles as s 
     LEFT JOIN oehxn_extensions as e 
     ON e.element=s.template 
     AND e.type='template' 
     AND e.client_id=s.client_id

9. 1 × SELECT
        p.*,
     p.user_id AS _user_id,
        u.name AS _user_name,
        
     CASE WHEN (SELECT filename 
     FROM oehxn_fwg_files AS f

10. 1 × SELECT
      COUNT(*)
     
      FROM
      oehxn_fwg_projects AS p
      
      LEFT JOIN oehxn_usergroups AS pg 
      ON (pg.id = p.gid)

11. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM oehxn_modules AS m 
      LEFT JOIN oehxn_modules_menu AS mm 
      ON mm.moduleid = m.id 
      LEFT JOIN oehxn_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id

Andere Tabellen:

1. 1 × INSERT INTO `oehxn_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  (X'3730333733313938613431316433643465653035363661616336383032623031', 1, 1620696634, 0, '', 0

2. 1 × UPDATE `oehxn_extensions` 
     SET `params` = '{\"mediaversion\":\"83b87b18597b082664380ee6b97bd054\"}'