Veranstaltungen

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1701298066,
                "last": 1701298066,
                "now": 1701298066
            },
            "token": "q6HT0qAOPii7DMFTsCRZaiAbVucgwwu5"
        },
        "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
        },
        "audacity-3038605607abdcce9459dfb0c856b94a-name": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-logo-type": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-logo-custom-image": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-demostyle-type": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-accent-color1": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-accent-color2": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-pagesurround-background": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-mainbody-overlay": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-top-textcolor": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-top-background": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-header-textcolor": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-header-background": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-header-type": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-showcase-textcolor": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-showcase-background": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-utility-textcolor": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-utility-background": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-feature-textcolor": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-feature-background": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-maintop-textcolor": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-maintop-background": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-expandedtop-textcolor": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-expandedtop-background": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-expandedbottom-textcolor": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-expandedbottom-background": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-mainbottom-textcolor": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-mainbottom-background": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-extension-textcolor": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-extension-background": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-bottom-textcolor": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-bottom-background": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-footer-textcolor": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-footer-background": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-copyright-textcolor": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-copyright-background": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-font-family": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-font-size-is": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-menu-type": null,
        "audacity-3038605607abdcce9459dfb0c856b94a-layout-mode": null
    }
}

Zeit

Speicher

27 ausgeführte Abfragen 11.74 ms

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

   SELECT `data`
   
     FROM `qcwru_session`
   
     WHERE `session_id` = X'3131643563353262656533656531646462666430613163613865396666303665'

   Explain

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

   Profil (Profile)

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

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Derselbe Aufruf in der Zeile darunter.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

2. Abfragezeit: 0.10 ms Nach letzter Abfrage: 1.05 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.261 MB Zeilen zurückgegeben: 0

   SELECT `session_id`
   
     FROM `qcwru_session`
   
     WHERE `session_id` = X'3131643563353262656533656531646462666430613163613865396666303665' 
     LIMIT 1

   Explain

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

   Profil (Profile)

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	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: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.19 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 4.266 MB

   INSERT INTO `qcwru_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3131643563353262656533656531646462666430613163613865396666303665', 1, 1701298066, 0, '', 0)

   Explain

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

   Profil (Profile)

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   update	0.08 ms
   Waiting for query cache lock	0.00 ms
   update	0.00 ms
   end	0.00 ms
   query end	0.03 ms
   closing tables	0.00 ms
   freeing items	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: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: 0.49 ms Nach letzter Abfrage: 2.07 ms Abfragespeichernutzung: 0.056 MB Speichernutzung vor Abfrage: 4.516 MB Zeilen zurückgegeben: 47

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

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	qcwru_extensions	NULL	ref	extension	extension	82	const	47	1.00	Using where

   Profil (Profile)

   Status	Duration
   starting	0.04 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.28 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.00 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: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: 0.13 ms Nach letzter Abfrage: 1.88 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.730 MB Zeilen zurückgegeben: 5

   SELECT id, rules
   
     FROM `qcwru_viewlevels`

   Explain

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

   Profil (Profile)

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.02 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	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: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: 0.18 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.742 MB Zeilen zurückgegeben: 2

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

   Explain

   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

   Profil (Profile)

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.02 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	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: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]

   ---

7. Abfragezeit: 0.96 ms Nach letzter Abfrage: 0.64 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 4.810 MB Zeilen zurückgegeben: 135

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM qcwru_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	qcwru_extensions	NULL	ref	extension	extension	82	const	175	0.60	Using index condition; Using where; filesort wurde genutzt

   Profil (Profile)

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.02 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.01 ms
   Sorting result	0.01 ms
   executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	0.76 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	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:351
   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:356
   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]

   ---

8. Abfragezeit: 0.82 ms Nach letzter Abfrage: 18.77 ms Abfragespeichernutzung: 0.064 MB Speichernutzung vor Abfrage: 6.773 MB Zeilen zurückgegeben: 26

   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 qcwru_menu AS m
   
     LEFT JOIN qcwru_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	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	52	3.33	Using index condition; Using where; filesort wurde genutzt
   1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	usr_web522_2.m.component_id	1	100.00	Using where

   Profil (Profile)

   Status	Duration
   starting	0.11 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.05 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.07 ms
   preparing	0.02 ms
   Sorting result	0.01 ms
   executing	0.00 ms
   Sending data	0.02 ms
   Creating sort index	0.32 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 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:78
   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:142
   11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
   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:65
   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:533
   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:1141
   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: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]

   ---

9. Abfragezeit: 0.40 ms Nach letzter Abfrage: 8.02 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 7.590 MB Zeilen zurückgegeben: 1

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

   Explain

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

   Profil (Profile)

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

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   15	JDatabaseDriverMysqli->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: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]

   ---

10. Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 7.581 MB

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

    Explain

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

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.04 ms
    updating	0.05 ms
    end	0.00 ms
    Waiting for query cache lock	0.00 ms
    end	0.01 ms
    query end	0.04 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    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]

    ---

11. Abfragezeit: 0.22 ms Nach letzter Abfrage: 1.84 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 7.751 MB Zeilen zurückgegeben: 1

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

    Explain

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

    Profil (Profile)

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	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: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]

    ---

12. Abfragezeit: 0.32 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 7.764 MB Zeilen zurückgegeben: 2
    Doppelte Abfragen: #27

    SELECT id, home, template, s.params
    
      FROM qcwru_template_styles as s
    
      LEFT JOIN qcwru_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	3	1.67	Using index condition; Using where
    1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	usr_web522_2.e.element	1	66.67	Using index condition; Using where

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	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: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]

    ---

13. Abfragezeit: 0.49 ms Nach letzter Abfrage: 13.53 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 9.412 MB Zeilen zurückgegeben: 66

    SELECT `keyname`,`value`
    
      FROM qcwru_jem_config

    Explain

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

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    11	JDatabaseDriver->loadAssocList()	JROOT/components/com_jem/classes/config.class.php:108
    10	JemConfig->loadData()	JROOT/components/com_jem/classes/config.class.php:65
    9	JemConfig->__construct()	JROOT/components/com_jem/classes/config.class.php:49
    8	JemConfig::getInstance()	JROOT/components/com_jem/helpers/helper.php:81
    7	JemHelper::addFileLogger()	JROOT/components/com_jem/jem.php:32
    6	require_once JROOT/components/com_jem/jem.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: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]

    ---

14. Abfragezeit: 0.56 ms Nach letzter Abfrage: 6.60 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 9.908 MB Zeilen zurückgegeben: 2

    SELECT DISTINCT c.id 
      FROM qcwru_jem_categories AS c 
      WHERE c.published = 1 
      AND c.parent_id = 1 
      AND c.access IN (1,1,5)

    Explain

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

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:367
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_jem/models/categories.php:186
    13	JEMModelCategories->getTotal()	JROOT/components/com_jem/models/categories.php:466
    12	JEMModelCategories->getPagination()	JROOT/components/com_jem/models/categories.php:128
    11	JEMModelCategories->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jem/views/categories/view.html.php:33
    9	JemViewCategories->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:45
    6	require_once JROOT/components/com_jem/jem.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: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]

    ---

15. Abfragezeit: 0.80 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 9.916 MB Zeilen zurückgegeben: 2

    SELECT c.*, 
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS slug, ( SELECT COUNT(DISTINCT i.id) 
      FROM qcwru_jem_events AS i 
      LEFT JOIN qcwru_jem_cats_event_relations AS rel 
      ON rel.itemid = i.id 
      LEFT JOIN qcwru_jem_categories AS cc 
      ON cc.id = rel.catid 
      WHERE cc.published = 1 
      AND cc.parent_id = 1 
      AND cc.access IN (1,1,5) 
      AND i.access IN (1,1,5) 
      AND ((i.published = 1)) 
      AND c.id = cc.id 
      GROUP BY cc.id) AS assignedevents 
      FROM qcwru_jem_categories AS c 
      WHERE c.published = 1 
      AND c.parent_id=1 
      AND c.access IN (1,1,5) 
      GROUP BY c.id  
      ORDER BY c.lft ASC 
      LIMIT 0, 4

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	c	NULL	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	4	25.00	Using where; filesort wurde genutzt
    2	DEPENDENT SUBQUERY	i	NULL	ref	PRIMARY,idx_access,idx_pubstate	idx_pubstate	1	const	1	99.22	Using where; Using temporary; filesort wurde genutzt
    2	DEPENDENT SUBQUERY	cc	NULL	eq_ref	PRIMARY	PRIMARY	4	func	1	25.00	Using where
    2	DEPENDENT SUBQUERY	rel	NULL	eq_ref	category event relation,catid,itemid	category event relation	8	usr_web522_2.cc.id,usr_web522_2.i.id	1	100.00	Using where; Using index

    Profil (Profile)

    Status	Duration
    starting	0.09 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.27 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.01 ms
    Creating tmp table	0.04 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.03 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.02 ms
    executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    removing tmp table	0.00 ms
    query end	0.00 ms
    removing tmp table	0.00 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.01 ms
    removing tmp table	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_jem/models/categories.php:129
    11	JEMModelCategories->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jem/views/categories/view.html.php:33
    9	JemViewCategories->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:45
    6	require_once JROOT/components/com_jem/jem.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: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]

    ---

16. Abfragezeit: 0.37 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 9.926 MB Zeilen zurückgegeben: 0

    SELECT c.*, 
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS slug, ( SELECT COUNT(DISTINCT i.id) 
      FROM qcwru_jem_events AS i 
      LEFT JOIN qcwru_jem_cats_event_relations AS rel 
      ON rel.itemid = i.id 
      LEFT JOIN qcwru_jem_categories AS cc 
      ON cc.id = rel.catid 
      WHERE cc.published = 1 
      AND cc.parent_id = 3 
      AND cc.access IN (1,1,5) 
      AND i.access IN (1,1,5) 
      AND ((i.published = 1)) 
      AND c.id = cc.id 
      GROUP BY cc.id) AS assignedevents 
      FROM qcwru_jem_categories AS c 
      WHERE c.published = 1 
      AND c.parent_id=3 
      AND c.access IN (1,1,5) 
      GROUP BY c.id  
      ORDER BY c.lft ASC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	c	NULL	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	4	25.00	Using where; filesort wurde genutzt
    2	DEPENDENT SUBQUERY	i	NULL	ref	PRIMARY,idx_access,idx_pubstate	idx_pubstate	1	const	1	99.22	Using where; Using temporary; filesort wurde genutzt
    2	DEPENDENT SUBQUERY	cc	NULL	eq_ref	PRIMARY	PRIMARY	4	func	1	25.00	Using where
    2	DEPENDENT SUBQUERY	rel	NULL	eq_ref	category event relation,catid,itemid	category event relation	8	usr_web522_2.cc.id,usr_web522_2.i.id	1	100.00	Using where; Using index

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jem/models/categories.php:141
    11	JEMModelCategories->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jem/views/categories/view.html.php:33
    9	JemViewCategories->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:45
    6	require_once JROOT/components/com_jem/jem.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: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]

    ---

17. Abfragezeit: 0.49 ms Nach letzter Abfrage: 14.35 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 10.913 MB Zeilen zurückgegeben: 0

    SELECT id, link 
      from qcwru_menu 
      WHERE link LIKE 'index.php?option=com_jdownloads&view=category%' 
      AND published = 1

    Explain

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

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    15	JDatabaseDriver->loadAssocList()	JROOT/plugins/content/jdownloads/jdownloads.php:57
    14	require_once JROOT/plugins/content/jdownloads/jdownloads.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
    13	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    12	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_jem/models/categories.php:153
    11	JEMModelCategories->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jem/views/categories/view.html.php:33
    9	JemViewCategories->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:45
    6	require_once JROOT/components/com_jem/jem.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: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]

    ---

18. Abfragezeit: 0.26 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 10.921 MB Zeilen zurückgegeben: 0

    SELECT id, link 
      from qcwru_menu 
      WHERE link LIKE 'index.php?option=com_jdownloads&view=category&catid%' 
      AND published = 1 
      AND access IN (1,1,5)

    Explain

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

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    16	JDatabaseDriver->loadAssocList()	JROOT/components/com_jdownloads/helpers/jdownloads.php:441
    15	JDHelper::getAllJDCategoryMenuIDs()	JROOT/plugins/content/jdownloads/jdownloads.php:70
    14	require_once JROOT/plugins/content/jdownloads/jdownloads.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
    13	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    12	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_jem/models/categories.php:153
    11	JEMModelCategories->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jem/views/categories/view.html.php:33
    9	JemViewCategories->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:45
    6	require_once JROOT/components/com_jem/jem.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: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]

    ---

19. Abfragezeit: 1.45 ms Nach letzter Abfrage: 9.80 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 11.449 MB Zeilen zurückgegeben: 0

    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM qcwru_fields AS a
    
      LEFT JOIN `qcwru_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN qcwru_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN qcwru_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN qcwru_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN qcwru_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_jem.categories' 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explain

    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_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	28	usr_web522_2.a.language	1	100.00	Using where
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	usr_web522_2.a.checked_out	1	100.00	Using where
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	usr_web522_2.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	usr_web522_2.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	usr_web522_2.a.group_id	1	100.00	Using where

    Profil (Profile)

    Status	Duration
    starting	0.14 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.71 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.03 ms
    Creating tmp table	0.04 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.14 ms
    Creating sort index	0.02 ms
    end	0.00 ms
    query end	0.01 ms
    removing tmp table	0.03 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
    15	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jem/models/categories.php:154
    11	JEMModelCategories->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jem/views/categories/view.html.php:33
    9	JemViewCategories->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:45
    6	require_once JROOT/components/com_jem/jem.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: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]

    ---

20. Abfragezeit: 0.40 ms Nach letzter Abfrage: 5.43 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.937 MB Zeilen zurückgegeben: 1

    SELECT id, parent_id, catname, 
      CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug
    
      FROM qcwru_jem_categories
    
      WHERE id = 3 
      AND published = 1 
      AND access IN (1,1,5)

    Explain

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

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/components/com_jem/classes/categories.class.php:476
    13	JEMCategories->getPath()	JROOT/components/com_jem/helpers/route.php:89
    12	JEMHelperRoute::getCategoryRoute()	JROOT/components/com_jem/models/categories.php:166
    11	JEMModelCategories->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jem/views/categories/view.html.php:33
    9	JemViewCategories->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:45
    6	require_once JROOT/components/com_jem/jem.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: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]

    ---

21. Abfragezeit: 0.16 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.945 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #24

    SELECT id, parent_id, catname, 
      CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug
    
      FROM qcwru_jem_categories
    
      WHERE id = 1 
      AND published = 1 
      AND access IN (1,1,5)

    Explain

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

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/components/com_jem/classes/categories.class.php:476
    13	JEMCategories->getPath()	JROOT/components/com_jem/helpers/route.php:89
    12	JEMHelperRoute::getCategoryRoute()	JROOT/components/com_jem/models/categories.php:166
    11	JEMModelCategories->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jem/views/categories/view.html.php:33
    9	JemViewCategories->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:45
    6	require_once JROOT/components/com_jem/jem.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: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]

    ---

22. Abfragezeit: 0.49 ms Nach letzter Abfrage: 0.44 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 11.951 MB Zeilen zurückgegeben: 0

    SELECT c.*, 
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS slug, ( SELECT COUNT(DISTINCT i.id) 
      FROM qcwru_jem_events AS i 
      LEFT JOIN qcwru_jem_cats_event_relations AS rel 
      ON rel.itemid = i.id 
      LEFT JOIN qcwru_jem_categories AS cc 
      ON cc.id = rel.catid 
      WHERE cc.published = 1 
      AND cc.parent_id = 4 
      AND cc.access IN (1,1,5) 
      AND i.access IN (1,1,5) 
      AND ((i.published = 1)) 
      AND c.id = cc.id 
      GROUP BY cc.id) AS assignedevents 
      FROM qcwru_jem_categories AS c 
      WHERE c.published = 1 
      AND c.parent_id=4 
      AND c.access IN (1,1,5) 
      GROUP BY c.id  
      ORDER BY c.lft ASC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	c	NULL	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	4	25.00	Using where; filesort wurde genutzt
    2	DEPENDENT SUBQUERY	i	NULL	ref	PRIMARY,idx_access,idx_pubstate	idx_pubstate	1	const	1	99.22	Using where; Using temporary; filesort wurde genutzt
    2	DEPENDENT SUBQUERY	cc	NULL	eq_ref	PRIMARY	PRIMARY	4	func	1	25.00	Using where
    2	DEPENDENT SUBQUERY	rel	NULL	eq_ref	category event relation,catid,itemid	category event relation	8	usr_web522_2.cc.id,usr_web522_2.i.id	1	100.00	Using where; Using index

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jem/models/categories.php:141
    11	JEMModelCategories->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jem/views/categories/view.html.php:33
    9	JemViewCategories->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:45
    6	require_once JROOT/components/com_jem/jem.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: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]

    ---

23. Abfragezeit: 0.14 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.962 MB Zeilen zurückgegeben: 1

    SELECT id, parent_id, catname, 
      CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug
    
      FROM qcwru_jem_categories
    
      WHERE id = 4 
      AND published = 1 
      AND access IN (1,1,5)

    Explain

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

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/components/com_jem/classes/categories.class.php:476
    13	JEMCategories->getPath()	JROOT/components/com_jem/helpers/route.php:89
    12	JEMHelperRoute::getCategoryRoute()	JROOT/components/com_jem/models/categories.php:166
    11	JEMModelCategories->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jem/views/categories/view.html.php:33
    9	JemViewCategories->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:45
    6	require_once JROOT/components/com_jem/jem.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: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]

    ---

24. Abfragezeit: 0.12 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.970 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #21

    SELECT id, parent_id, catname, 
      CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug
    
      FROM qcwru_jem_categories
    
      WHERE id = 1 
      AND published = 1 
      AND access IN (1,1,5)

    Explain

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

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/components/com_jem/classes/categories.class.php:476
    13	JEMCategories->getPath()	JROOT/components/com_jem/helpers/route.php:89
    12	JEMHelperRoute::getCategoryRoute()	JROOT/components/com_jem/models/categories.php:166
    11	JEMModelCategories->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jem/views/categories/view.html.php:33
    9	JemViewCategories->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:45
    6	require_once JROOT/components/com_jem/jem.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: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]

    ---

25. Abfragezeit: 0.82 ms Nach letzter Abfrage: 6.15 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.279 MB Zeilen zurückgegeben: 0

    SELECT DISTINCT a.id, a.dates, a.enddates, a.times, a.endtimes, a.title, a.locid, a.created, l.venue, l.city, l.state, l.url, a.recurrence_type, a.recurrence_first_id, a.published, 
      CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
      CASE WHEN CHAR_LENGTH(l.alias) THEN CONCAT_WS(':', a.locid, l.alias) ELSE a.locid END as venueslug 
      FROM qcwru_jem_events AS a 
      LEFT JOIN qcwru_jem_venues AS l 
      ON l.id = a.locid 
      LEFT JOIN qcwru_jem_cats_event_relations AS rel 
      ON rel.itemid = a.id 
      LEFT JOIN qcwru_jem_categories AS c 
      ON c.id = 3 
      WHERE a.published = 1 
      AND rel.catid = 3 
      AND c.access IN (1,1,5) 
      AND a.access IN (1,1,5) 
      ORDER BY a.dates, a.times 
      LIMIT 0, 3

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using temporary; filesort wurde genutzt
    1	SIMPLE	a	NULL	ref	PRIMARY,idx_access,idx_pubstate	idx_pubstate	1	const	1	99.22	Using index condition; Using where
    1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	usr_web522_2.a.locid	1	100.00	NULL
    1	SIMPLE	rel	NULL	eq_ref	category event relation,catid,itemid	category event relation	8	const,usr_web522_2.a.id	1	100.00	Using where; Using index; Distinct

    Profil (Profile)

    Status	Duration
    starting	0.13 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.19 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.02 ms
    Creating tmp table	0.04 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    11	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_jem/models/categories.php:206
    10	JEMModelCategories->getEventdata()	JROOT/components/com_jem/views/categories/view.html.php:91
    9	JemViewCategories->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:45
    6	require_once JROOT/components/com_jem/jem.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: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]

    ---

26. Abfragezeit: 0.38 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.286 MB Zeilen zurückgegeben: 0

    SELECT DISTINCT a.id, a.dates, a.enddates, a.times, a.endtimes, a.title, a.locid, a.created, l.venue, l.city, l.state, l.url, a.recurrence_type, a.recurrence_first_id, a.published, 
      CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
      CASE WHEN CHAR_LENGTH(l.alias) THEN CONCAT_WS(':', a.locid, l.alias) ELSE a.locid END as venueslug 
      FROM qcwru_jem_events AS a 
      LEFT JOIN qcwru_jem_venues AS l 
      ON l.id = a.locid 
      LEFT JOIN qcwru_jem_cats_event_relations AS rel 
      ON rel.itemid = a.id 
      LEFT JOIN qcwru_jem_categories AS c 
      ON c.id = 4 
      WHERE a.published = 1 
      AND rel.catid = 4 
      AND c.access IN (1,1,5) 
      AND a.access IN (1,1,5) 
      ORDER BY a.dates, a.times 
      LIMIT 0, 3

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using temporary; filesort wurde genutzt
    1	SIMPLE	a	NULL	ref	PRIMARY,idx_access,idx_pubstate	idx_pubstate	1	const	1	99.22	Using index condition; Using where
    1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	usr_web522_2.a.locid	1	100.00	NULL
    1	SIMPLE	rel	NULL	eq_ref	category event relation,catid,itemid	category event relation	8	const,usr_web522_2.a.id	1	100.00	Using where; Using index; Distinct

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    11	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_jem/models/categories.php:206
    10	JEMModelCategories->getEventdata()	JROOT/components/com_jem/views/categories/view.html.php:91
    9	JemViewCategories->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:45
    6	require_once JROOT/components/com_jem/jem.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: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]

    ---

27. Abfragezeit: 0.55 ms Nach letzter Abfrage: 21.87 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 14.853 MB Zeilen zurückgegeben: 2
    Doppelte Abfragen: #12

    SELECT id, home, template, s.params
    
      FROM qcwru_template_styles as s
    
      LEFT JOIN qcwru_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	3	1.67	Using index condition; Using where
    1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	usr_web522_2.e.element	1	66.67	Using index condition; Using where

    Profil (Profile)

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 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.11 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
    16	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/gantrytemplate.class.php:590
    15	GantryTemplate::getTemplateParams()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69
    14	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
    13	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
    12	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
    11	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
    10	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
    9	include JROOT/libraries/gantry/gantry.php	JROOT/templates/rt_audacity/lib/gantry/gantry.php:21
    8	require_once JROOT/templates/rt_audacity/lib/gantry/gantry.php	JROOT/templates/rt_audacity/component.php:15
    7	require JROOT/templates/rt_audacity/component.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    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:231
    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]

    ---

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

SELECT-Tabellen:

1. 4 × SELECT id, parent_id, catname, 
     CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug 
     FROM qcwru_jem_categories

2. 3 × SELECT c.*, 
     CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS slug, ( SELECT COUNT(DISTINCT i.id) 
     FROM qcwru_jem_events AS i 
     LEFT JOIN qcwru_jem_cats_event_relations AS rel 
     ON rel.itemid = i.id 
     LEFT JOIN qcwru_jem_categories AS cc 
     ON cc.id = rel.catid

3. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
     FROM `qcwru_extensions`

4. 2 × SELECT id, home, template, s.params 
     FROM qcwru_template_styles as s 
     LEFT JOIN qcwru_extensions as e 
     ON e.element=s.template 
     AND e.type='template' 
     AND e.client_id=s.client_id

5. 2 × SELECT id, link 
     from qcwru_menu

6. 1 × SELECT `data` 
     FROM `qcwru_session`

7. 1 × SELECT `session_id` 
     FROM `qcwru_session`

8. 1 × SELECT id, rules 
     FROM `qcwru_viewlevels

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

10. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM qcwru_extensions

11. 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 qcwru_menu AS m 
      LEFT JOIN qcwru_extensions AS e 
      ON m.component_id = e.extension_id

12. 1 × SELECT * 
      FROM qcwru_languages

13. 1 × SELECT `keyname`,`value` 
      FROM qcwru_jem_confi

14. 1 × SELECT DISTINCT c.id 
      FROM qcwru_jem_categories AS c

15. 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 qcwru_fields AS a 
      LEFT JOIN `qcwru_languages` AS l 
      ON l.lang_code = a.language 
      LEFT JOIN qcwru_users AS uc 
      ON uc.id=a.checked_out 
      LEFT JOIN qcwru_viewlevels AS ag 
      ON ag.id = a.access 
      LEFT JOIN qcwru_users AS ua 
      ON ua.id = a.created_user_id 
      LEFT JOIN qcwru_fields_groups AS g 
      ON g.id = a.group_id

16. 1 × SELECT DISTINCT a.id, a.dates, a.enddates, a.times, a.endtimes, a.title, a.locid, a.created, l.venue, l.city, l.state, l.url, a.recurrence_type, a.recurrence_first_id, a.published, 
      CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
      CASE WHEN CHAR_LENGTH(l.alias) THEN CONCAT_WS(':', a.locid, l.alias) ELSE a.locid END as venueslug 
      FROM qcwru_jem_events AS a 
      LEFT JOIN qcwru_jem_venues AS l 
      ON l.id = a.locid 
      LEFT JOIN qcwru_jem_cats_event_relations AS rel 
      ON rel.itemid = a.id 
      LEFT JOIN qcwru_jem_categories AS c 
      ON c.id = 3

17. 1 × SELECT DISTINCT a.id, a.dates, a.enddates, a.times, a.endtimes, a.title, a.locid, a.created, l.venue, l.city, l.state, l.url, a.recurrence_type, a.recurrence_first_id, a.published, 
      CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
      CASE WHEN CHAR_LENGTH(l.alias) THEN CONCAT_WS(':', a.locid, l.alias) ELSE a.locid END as venueslug 
      FROM qcwru_jem_events AS a 
      LEFT JOIN qcwru_jem_venues AS l 
      ON l.id = a.locid 
      LEFT JOIN qcwru_jem_cats_event_relations AS rel 
      ON rel.itemid = a.id 
      LEFT JOIN qcwru_jem_categories AS c 
      ON c.id = 4

Andere Tabellen:

1. 1 × INSERT INTO `qcwru_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  (X'3131643563353262656533656531646462666430613163613865396666303665', 1, 1701298066, 0, '', 0

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