Die Wohnung

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1714291260,
                "last": 1714291260,
                "now": 1714291260
            },
            "token": "JorYF6T3Zf5wuiLMrt8goVWeqwmB1rl5"
        },
        "registry": {
            "com_installer": {
                "message": "",
                "extension_message": ""
            }
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "de-AT"
        }
    }
}

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

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

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysql->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: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

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

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

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
update	0.12 ms
end	0.01 ms
query end	0.06 ms
closing tables	0.03 ms
freeing items	0.02 ms
cleaning up	0.01 ms

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hxzkr_extensions	NULL	ref	extension	extension	62	const	36	1.00	Using where

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

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

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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where; Using index

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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hxzkr_extensions	NULL	ref	extension	extension	62	const	94	0.60	Using index condition; Using where; filesort wurde genutzt

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

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

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
7	PlgSystemLanguageFilter->__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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hxzkr_extensions	NULL	ref	extension	extension	62	const	6	1.00	Using where

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
7	PlgSystemLanguageFilter->__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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	29	3.33	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	usrdb_ferxsmqv.m.component_id	1	100.00	Using where

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.21 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.05 ms
Sorting result	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.51 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.04 ms

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hxzkr_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	NULL

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

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Derselbe Aufruf in der Zeile darunter.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
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:1129
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	hxzkr_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.08 ms
updating	0.12 ms
end	0.02 ms
query end	0.08 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysql->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:1129
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	62	const	5	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	152	usrdb_ferxsmqv.e.element	1	66.67	Using index condition; Using where

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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hxzkr_assets	NULL	ALL	idx_asset_name	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	126	29.37	Using where

Status	Duration
starting	0.20 ms
checking permissions	0.02 ms
Opening tables	0.21 ms
init	0.09 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.17 ms
preparing	0.06 ms
executing	0.01 ms
Sending data	0.37 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.03 ms

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
14	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:78
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	hxzkr_assets	NULL	ALL	idx_asset_name,idx_parent_id	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	126	25.00	Using where

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

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
19	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
14	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:78
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY,idx_state,idx_catid,idx_language	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	v	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

Status	Duration
starting	0.24 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.68 ms
init	0.15 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.19 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.06 ms
freeing items	0.06 ms
cleaning up	0.03 ms

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	usrdb_ferxsmqv.m.tag_id	1	100.00	Using where

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

„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `hxzkr_updates` (`update_site_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`data`,`detailsurl`,`infourl`,`extra_query`) VALUES ('1','Joomla','','joomla','file','','0','3.10.12','','https://update.joomla.org/core/extension.xml','','')

Profil (Profile)

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
update	0.09 ms
end	0.01 ms
query end	0.06 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1421
11	JDatabaseDriver->insertObject()	JROOT/libraries/src/Table/Table.php:805
10	Joomla\CMS\Table\Table->store()	JROOT/libraries/src/Updater/Updater.php:169
9	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
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]

Abfragezeit: 0.32 ms Nach letzter Abfrage: 0.12 ms

UPDATE `hxzkr_update_sites`

  SET `last_check_timestamp` = '1714291260'

  WHERE `update_site_id` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	hxzkr_update_sites	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.04 ms
updating	0.06 ms
end	0.01 ms
query end	0.04 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Updater/Updater.php:440
10	Joomla\CMS\Updater\Updater->updateLastCheckTimestamp()	JROOT/libraries/src/Updater/Updater.php:174
9	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
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]

Abfragezeit: 5.31 ms Nach letzter Abfrage: 1.89 ms

SELECT u.*,`e`.`manifest_cache`

  FROM `hxzkr_updates` AS `u`

  LEFT JOIN `hxzkr_extensions` AS `e` 
  ON `e`.`extension_id` = `u`.`extension_id`

  WHERE `u`.`extension_id` != '0' 
  AND `u`.`extension_id` = '700'

  ORDER BY `u`.`name` asc 
  LIMIT 20

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	u	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1696	9.00	Using where; filesort wurde genutzt
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	usrdb_ferxsmqv.u.extension_id	1	100.00	NULL

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
11	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_installer/models/update.php:217
10	InstallerModelUpdate->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
9	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/plugins/system/updatenotification/updatenotification.php:136
8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
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]

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

SELECT-Tabellen:

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `hxzkr_assets`

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `hxzkr_extensions`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM hxzkr_modules AS m 
  LEFT JOIN hxzkr_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN hxzkr_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` 
  FROM `hxzkr_content` AS `c` 
  INNER JOIN `hxzkr_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item' 
  INNER JOIN `hxzkr_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `hxzkr_content` AS `c2` 
  ON a2.id = c2.`id` 
  INNER JOIN `hxzkr_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `hxzkr_menu` AS `c` 
  INNER JOIN `hxzkr_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `hxzkr_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `hxzkr_menu` AS `c2` 
  ON a2.id = c2.`id`

1 × SELECT language,id 
  FROM `hxzkr_menu`

1 × SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query 
  FROM `hxzkr_update_sites` AS `a` 
  INNER JOIN hxzkr_update_sites_extensions AS b 
  ON a.update_site_id = b.update_site_id

1 × SELECT `name` 
  FROM `hxzkr_update_sites`

```
1 × SELECT * 
  FROM hxzkr_updates
```

1 × SELECT u.*,`e`.`manifest_cache` 
  FROM `hxzkr_updates` AS `u` 
  LEFT JOIN `hxzkr_extensions` AS `e` 
  ON `e`.`extension_id` = `u`.`extension_id`

1 × SELECT `extension_id` 
  FROM `hxzkr_extensions`

1 × SELECT `update_id` 
  FROM `hxzkr_updates`

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 hxzkr_fields AS a 
  LEFT JOIN `hxzkr_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN hxzkr_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN hxzkr_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN hxzkr_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN hxzkr_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `hxzkr_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT DISTINCT update_site_id 
  FROM hxzkr_updates

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `hxzkr_contentitem_tag_map` AS m  
  INNER JOIN `hxzkr_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM hxzkr_extensions

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

1 × SELECT id, rules 
  FROM `hxzkr_viewlevels

1 × SELECT `session_id` 
  FROM `hxzkr_session`

```
1 × SELECT * 
  FROM hxzkr_languages
```

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `hxzkr_extensions`

1 × SELECT `data` 
  FROM `hxzkr_session`

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM hxzkr_content AS a 
  INNER JOIN hxzkr_categories AS c 
  on c.id = a.catid 
  LEFT JOIN hxzkr_users AS u 
  on u.id = a.created_by 
  LEFT JOIN hxzkr_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN hxzkr_content_rating AS v 
  ON a.id = v.content_id

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

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 hxzkr_menu AS m 
  LEFT JOIN hxzkr_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `hxzkr_categories` AS `s` 
  INNER JOIN `hxzkr_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('de-AT','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

Andere Tabellen:

1 × SHOW FULL COLUMNS 
  FROM `hxzkr_updates

1 × SHOW FULL COLUMNS 
  FROM `hxzkr_extensions

1 × INSERT INTO `hxzkr_updates` (`update_site_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`data`,`detailsurl`,`infourl`,`extra_query`) 
  VALUES  ('1','Joomla','','joomla','file','','0','3.10.12','','https://update.joomla.org/core/extension.xml','',''

1 × UPDATE `hxzkr_update_sites` 
  SET `last_check_timestamp` = '1714291260'

1 × UPDATE `hxzkr_update_sites` 
  SET `enabled` = '1'

1 × UPDATE `hxzkr_update_sites` 
  SET `enabled` = '0'

1 × UPDATE `hxzkr_extensions` 
  SET `params` = '{\"mediaversion\":\"8588fb1af349c28a9370d27ca41365f8\"}'

1 × LOCK TABLES `hxzkr_extensions` WRIT

1 × UPDATE `hxzkr_extensions` 
  SET `params` = '{\"lastrun\":1714291260}'

```
1 × UNLOCK TABLE
```

1 × INSERT INTO `hxzkr_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('pn7g7mbgt12biq5ihkc4vvl0f6', 1, 1714291260, 0, '', 0

Die Wohnung

Doppelzimmer:
Ein gemütliches Doppelbett für süße Träume steht hier für Sie bereit. Dazu gehört eine kleine Kommode und ein antiker Stuhl.

Dreibettzimmer:
Dieses Zimmer beinhaltet ein Stockbett und ein Einzelbett. Außerdem finden Sie hier einen kleinen Schreibplatz vor. Eine Kommode sorgt für Unterbringung Ihrer Wäsche.

Die Küche:
Hier handelt es sich um eine vollständige Küche mit Backofen und Ceranfeld, einer Spüle, Geschirrspüler, einem Kühlschrank, Kochgeschirr, Besteck und Service.

Badezimmer:
Mit WC, Waschbecken, Spiegel und Dusche fehlt es hier an nichts, was man für die tägliche Hygiene braucht.

Verbindungsflur:
In diesem Verteilerraum finden Sie eine Garderobe und einen großen Schrank zur Aufbewahrung ihrer Kleindung und Jacken.

Bilder zu den einzelnen Räumen finden sie in der Rubrik Fotos.

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

39 ausgeführte Abfragen 56.53 ms

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

SELECT-Tabellen:

Andere Tabellen:

Status	Duration
starting	0.25 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.10 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.20 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.15 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.03 ms

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context,idx_language	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	21	usrdb_ferxsmqv.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	usrdb_ferxsmqv.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	usrdb_ferxsmqv.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	usrdb_ferxsmqv.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	usrdb_ferxsmqv.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	usrdb_ferxsmqv.a.id	1	100.00	Using where; Using index; Distinct

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	9	3.70	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	usrdb_ferxsmqv.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	usrdb_ferxsmqv.m.id	1	40.00	Using where; Using index

Status	Duration
starting	0.23 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.31 ms
init	0.09 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.17 ms
preparing	0.05 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.24 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.05 ms
freeing items	0.07 ms
cleaning up	0.03 ms

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:548
9	JDatabaseDriverMysqli->lockTable()	JROOT/plugins/system/updatenotification/updatenotification.php:78
8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
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

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:923
9	JDatabaseDriverMysqli->unlockTables()	JROOT/plugins/system/updatenotification/updatenotification.php:103
8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
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

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Updater/UpdateAdapter.php:160
13	Joomla\CMS\Updater\UpdateAdapter->toggleUpdateSite()	JROOT/libraries/src/Updater/UpdateAdapter.php:245
12	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232
11	Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate()	JROOT/libraries/src/Updater/Updater.php:278
10	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:159
9	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
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

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
11	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Updater/Updater.php:367
10	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:159
9	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
8	PlgSystemUpdatenotification->onAfterRender()	Derselbe Aufruf in der Zeile darunter.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
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 Wohnung

Doppelzimmer:Ein gemütliches Doppelbett für süße Träume steht hier für Sie bereit. Dazu gehört eine kleine Kommode und ein antiker Stuhl.

Dreibettzimmer:Dieses Zimmer beinhaltet ein Stockbett und ein Einzelbett. Außerdem finden Sie hier einen kleinen Schreibplatz vor. Eine Kommode sorgt für Unterbringung Ihrer Wäsche.

Die Küche:Hier handelt es sich um eine vollständige Küche mit Backofen und Ceranfeld, einer Spüle, Geschirrspüler, einem Kühlschrank, Kochgeschirr, Besteck und Service.

Badezimmer:Mit WC, Waschbecken, Spiegel und Dusche fehlt es hier an nichts, was man für die tägliche Hygiene braucht.

Verbindungsflur:In diesem Verteilerraum finden Sie eine Garderobe und einen großen Schrank zur Aufbewahrung ihrer Kleindung und Jacken.

Bilder zu den einzelnen Räumen finden sie in der Rubrik Fotos.

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

39 ausgeführte Abfragen 56.53 ms

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

SELECT-Tabellen:

Andere Tabellen:

Doppelzimmer:
Ein gemütliches Doppelbett für süße Träume steht hier für Sie bereit. Dazu gehört eine kleine Kommode und ein antiker Stuhl.

Dreibettzimmer:
Dieses Zimmer beinhaltet ein Stockbett und ein Einzelbett. Außerdem finden Sie hier einen kleinen Schreibplatz vor. Eine Kommode sorgt für Unterbringung Ihrer Wäsche.

Die Küche:
Hier handelt es sich um eine vollständige Küche mit Backofen und Ceranfeld, einer Spüle, Geschirrspüler, einem Kühlschrank, Kochgeschirr, Besteck und Service.

Badezimmer:
Mit WC, Waschbecken, Spiegel und Dusche fehlt es hier an nichts, was man für die tägliche Hygiene braucht.

Verbindungsflur:
In diesem Verteilerraum finden Sie eine Garderobe und einen großen Schrank zur Aufbewahrung ihrer Kleindung und Jacken.