{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1642502487,
                "last": 1642502487,
                "now": 1642502487
            },
            "token": "aQScmDgAIBa9fsu57yb8V9Rl3syZ2kZ9"
        },
        "registry": {
            "com_jem": {
                "categorycal": {
                    "catid213": 3
                },
                "category": {
                    "3:213": {
                        "limitstart": 0
                    }
                }
            }
        },
        "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
        },
        "com_mailto": {
            "links": {
                "88e51bc46ec195b7f0458cb772bd0ebf8c095273": {
                    "link": "http:\/\/www.hellas-emmerich.de\/index.php\/wettkampfsport\/termine\/category\/3-wettkampf",
                    "expiry": 1642502488
                }
            }
        }
    }
}

Zeit

Speicher

47 ausgeführte Abfragen 13.48 ms

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

   SELECT `data`
   
     FROM `ssvh_session`
   
     WHERE `session_id` = '2462dee86c4f5b1e2ec752e81df6354d'

   Explain

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

   Profil (Profile)

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 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.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   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

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

   ---

2. Abfragezeit: 0.12 ms Nach letzter Abfrage: 2.36 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 5.442 MB Zeilen zurückgegeben: 0

   SELECT `session_id`
   
     FROM `ssvh_session`
   
     WHERE `session_id` = '2462dee86c4f5b1e2ec752e81df6354d' 
     LIMIT 1

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ssvh_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.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

3. Abfragezeit: 0.27 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 5.447 MB

   INSERT INTO `ssvh_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('2462dee86c4f5b1e2ec752e81df6354d', 1, 1642502487, 0, '', 0)

   Explain

   „EXPLAIN“ unmöglich für Abfrage: INSERT INTO `ssvh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('2462dee86c4f5b1e2ec752e81df6354d', 1, 1642502487, 0, '', 0)

   Profil (Profile)

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

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

4. Abfragezeit: 0.15 ms Nach letzter Abfrage: 13.49 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 6.024 MB Zeilen zurückgegeben: 6

   SELECT id, rules
   
     FROM `ssvh_viewlevels`

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ssvh_viewlevels	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	6	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.01 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

5. Abfragezeit: 0.21 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 6.037 MB Zeilen zurückgegeben: 1

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

   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	1	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.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.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

6. Abfragezeit: 0.34 ms Nach letzter Abfrage: 31.42 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 7.848 MB Zeilen zurückgegeben: 1

   SELECT `enabled`
   
     FROM `ssvh_extensions`
   
     WHERE `element` = 'com_akeeba' 
     AND `type` = 'component'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ssvh_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

   Profil (Profile)

   Status	Duration
   starting	0.04 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.14 ms
   preparing	0.01 ms
   executing	0.01 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:36
   7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
   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

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

   ---

7. Abfragezeit: 0.32 ms Nach letzter Abfrage: 68.90 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 11.638 MB Zeilen zurückgegeben: 1

   SELECT COUNT(*)
   
     FROM ssvh_extensions
   
     WHERE type = 'component' 
     AND element = 'com_sh404sef'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ssvh_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

   Profil (Profile)

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

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   13	JDatabaseDriver->loadResult()	JROOT/plugins/system/sunfw/includes/utils.php:81
   12	SunFwUtils::checkSH404SEF()	JROOT/plugins/system/sunfw/includes/overwrite/overwrite.php:84
   11	SunFwOverwrite::initialize()	JROOT/plugins/system/sunfw/includes/site.php:114
   10	SunFwSite->__construct()	JROOT/plugins/system/sunfw/includes/site.php:234
   9	SunFwSite::getInstance()	JROOT/plugins/system/sunfw/sunfw.php:383
   8	PlgSystemSunFw->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Abfragezeit: 0.29 ms Nach letzter Abfrage: 2.65 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 11.656 MB

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

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	UPDATE	ssvh_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.01 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.14 ms
   updating	0.05 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   15	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   14	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   11	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/sunfw/includes/site.php:120
   10	SunFwSite->__construct()	JROOT/plugins/system/sunfw/includes/site.php:234
   9	SunFwSite::getInstance()	JROOT/plugins/system/sunfw/sunfw.php:383
   8	PlgSystemSunFw->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Abfragezeit: 0.24 ms Nach letzter Abfrage: 3.73 ms Abfragespeichernutzung: 0.069 MB Speichernutzung vor Abfrage: 11.904 MB Zeilen zurückgegeben: 1

   SELECT ss.*
   
     FROM ssvh_sunfw_styles AS ss
   
     INNER JOIN ssvh_template_styles AS ts 
     ON ts.id = ss.style_id
   
     WHERE ts.id = 14

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ss	NULL	system	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	NULL
   1	SIMPLE	ts	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	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.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.06 ms
   end	0.01 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
   12	JDatabaseDriver->loadObject()	JROOT/plugins/system/sunfw/includes/helper.php:253
   11	SunFwHelper::getSunFwStyle()	JROOT/plugins/system/sunfw/includes/site.php:133
   10	SunFwSite->__construct()	JROOT/plugins/system/sunfw/includes/site.php:234
   9	SunFwSite::getInstance()	JROOT/plugins/system/sunfw/sunfw.php:383
   8	PlgSystemSunFw->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Abfragezeit: 0.58 ms Nach letzter Abfrage: 37.66 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 18.195 MB Zeilen zurückgegeben: 1

    SELECT *
    
      FROM ssvh_jem_settings
    
      WHERE id = 1

    Explain

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

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.29 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 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.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    9	JDatabaseDriver->loadObject()	JROOT/components/com_jem/helpers/helper.php:39
    8	JemHelper::config()	JROOT/components/com_jem/helpers/helper.php:111
    7	JemHelper::cleanup()	JROOT/components/com_jem/jem.php:31
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Abfragezeit: 0.13 ms Nach letzter Abfrage: 11.61 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 18.296 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #14  #15  #18  #29  #33  #34  #35  #36  #37  #38  #39  #40

    SELECT globalattribs
    
      FROM ssvh_jem_settings
    
      WHERE id = 1

    Explain

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

    Profil (Profile)

    Status	Duration
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 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.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    11	JDatabaseDriver->loadResult()	JROOT/components/com_jem/helpers/helper.php:67
    10	JemHelper::globalattribs()	JROOT/components/com_jem/views/category/view.html.php:134
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Abfragezeit: 0.12 ms Nach letzter Abfrage: 8.02 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 18.383 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #13

    SELECT css
    
      FROM ssvh_jem_settings
    
      WHERE id = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ssvh_jem_settings	NULL	system	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	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.01 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.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    12	JDatabaseDriver->loadResult()	JROOT/components/com_jem/helpers/helper.php:93
    11	JemHelper::retrieveCss()	JROOT/components/com_jem/helpers/helper.php:1107
    10	JemHelper::loadCss()	JROOT/components/com_jem/views/category/view.html.php:149
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.36 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 18.391 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #12

    SELECT css
    
      FROM ssvh_jem_settings
    
      WHERE id = 1

    Explain

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

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 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.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    12	JDatabaseDriver->loadResult()	JROOT/components/com_jem/helpers/helper.php:93
    11	JemHelper::retrieveCss()	JROOT/components/com_jem/helpers/helper.php:1191
    10	JemHelper::loadCustomCss()	JROOT/components/com_jem/views/category/view.html.php:150
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 18.402 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #11  #15  #18  #29  #33  #34  #35  #36  #37  #38  #39  #40

    SELECT globalattribs
    
      FROM ssvh_jem_settings
    
      WHERE id = 1

    Explain

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

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 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.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    18	JDatabaseDriver->loadResult()	JROOT/components/com_jem/helpers/helper.php:67
    17	JemHelper::globalattribs()	JROOT/components/com_jem/models/eventslist.php:216
    16	JemModelEventslist->getListQuery()	JROOT/components/com_jem/models/category.php:261
    15	JemModelCategory->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_jem/models/eventslist.php:457
    12	JemModelEventslist->getItems()	JROOT/components/com_jem/models/category.php:181
    11	JemModelCategory->getItems()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421
    10	JViewLegacy->get()	JROOT/components/com_jem/views/category/view.html.php:161
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 18.423 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #11  #14  #18  #29  #33  #34  #35  #36  #37  #38  #39  #40

    SELECT globalattribs
    
      FROM ssvh_jem_settings
    
      WHERE id = 1

    Explain

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

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 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.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    19	JDatabaseDriver->loadResult()	JROOT/components/com_jem/helpers/helper.php:67
    18	JemHelper::globalattribs()	JROOT/components/com_jem/models/eventslist.php:541
    17	JemModelEventslist->getCategories()	JROOT/components/com_jem/models/eventslist.php:370
    16	JemModelEventslist->getListQuery()	JROOT/components/com_jem/models/category.php:261
    15	JemModelCategory->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_jem/models/eventslist.php:457
    12	JemModelEventslist->getItems()	JROOT/components/com_jem/models/category.php:181
    11	JemModelCategory->getItems()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421
    10	JViewLegacy->get()	JROOT/components/com_jem/views/category/view.html.php:161
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Abfragezeit: 0.86 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 18.440 MB Zeilen zurückgegeben: 25

    SELECT DISTINCT c.id,c.catname,c.access,c.checked_out AS cchecked_out,c.color, 
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,a.id AS multi
    
      FROM ssvh_jem_categories as c
    
      LEFT JOIN ssvh_jem_cats_event_relations AS rel 
      ON rel.catid = c.id
    
      LEFT JOIN ssvh_jem_events AS a 
      ON a.id = rel.itemid
    
      WHERE c.published = 1 
      AND (c.access IN (1,1)) 
      AND c.id = 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
    1	SIMPLE	rel	NULL	ref	category event relation,catid	category event relation	4	const	24	100.00	Using index
    1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	4	90716m70415_1.rel.itemid	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
    Opening tables	0.45 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.01 ms
    Creating tmp table	0.03 ms
    executing	0.00 ms
    Sending data	0.10 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    18	JDatabaseDriver->loadColumn()	JROOT/components/com_jem/models/eventslist.php:661
    17	JemModelEventslist->getCategories()	JROOT/components/com_jem/models/eventslist.php:370
    16	JemModelEventslist->getListQuery()	JROOT/components/com_jem/models/category.php:261
    15	JemModelCategory->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_jem/models/eventslist.php:457
    12	JemModelEventslist->getItems()	JROOT/components/com_jem/models/category.php:181
    11	JemModelCategory->getItems()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421
    10	JViewLegacy->get()	JROOT/components/com_jem/views/category/view.html.php:161
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Abfragezeit: 0.95 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.042 MB Speichernutzung vor Abfrage: 18.439 MB Zeilen zurückgegeben: 1

    SELECT a.access,a.alias,a.attribs,a.author_ip,a.checked_out,a.checked_out_time,a.contactid,a.created,a.created_by,a.created_by_alias,a.custom1,a.custom2,a.custom3,a.custom4,a.custom5,a.custom6,a.custom7,a.custom8,a.custom9,a.custom10,a.dates,a.datimage,a.enddates,a.endtimes,a.featured,a.fulltext,a.hits,a.id,a.introtext,a.language,a.locid,a.maxplaces,a.metadata,a.meta_keywords,a.meta_description,a.modified,a.modified_by,a.published,a.registra,a.times,a.title,a.unregistra,a.waitinglist,DAYOFMONTH(a.dates) AS created_day, YEAR(a.dates) AS created_year, MONTH(a.dates) AS created_month,a.recurrence_byday,a.recurrence_counter,a.recurrence_first_id,a.recurrence_limit,a.recurrence_limit_date,a.recurrence_number, a.recurrence_type,a.version,l.alias AS l_alias,l.author_ip AS l_authorip,l.checked_out AS l_checked_out,l.checked_out_time AS l_checked_out_time,l.city,l.country,l.created AS l_created,l.created_by AS l_createdby,l.custom1 AS l_custom1,l.custom2 AS l_custom2,l.custom3 AS l_custom3,l.custom4 AS l_custom4,l.custom5 AS l_custom5,l.custom6 AS l_custom6,l.custom7 AS l_custom7,l.custom8 AS l_custom8,l.custom9 AS l_custom9,l.custom10 AS l_custom10,l.id AS l_id,l.latitude,l.locdescription,l.locimage,l.longitude,l.map,l.meta_description,l.meta_keywords,l.modified AS l_modified,l.modified_by AS l_modified_by,l.ordering,l.postalCode,l.publish_up,l.publish_down,l.published AS l_published,l.state,l.street,l.url,l.venue,l.version AS l_version,ct.name AS countryname, 
      CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
      CASE WHEN CHAR_LENGTH(l.alias) != 0 THEN CONCAT_WS(':', a.locid, l.alias) ELSE a.locid END as venueslug
    
      FROM ssvh_jem_events as a
    
      LEFT JOIN ssvh_jem_venues AS l 
      ON l.id = a.locid
    
      LEFT JOIN ssvh_jem_countries AS ct 
      ON ct.iso2 = l.country
    
      LEFT JOIN ssvh_jem_cats_event_relations AS rel 
      ON rel.itemid = a.id
    
      LEFT JOIN ssvh_jem_categories AS c 
      ON c.id = rel.catid
    
      WHERE a.access IN (1,1) 
      AND a.published = 1 
      AND a.dates IS NOT NULL 
      AND c.id  IN (3)
    
      ORDER BY a.dates ASC,a.times ASC 
      LIMIT 10

    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 index; filesort wurde genutzt
    1	SIMPLE	a	NULL	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	32	3.12	Using where
    1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	90716m70415_1.a.locid	1	100.00	NULL
    1	SIMPLE	rel	NULL	eq_ref	category event relation,catid,itemid	category event relation	8	const,90716m70415_1.a.id	1	100.00	Using where; Using index
    1	SIMPLE	ct	NULL	ref	iso2	iso2	8	90716m70415_1.l.country	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.16 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
    Opening tables	0.29 ms
    init	0.10 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.06 ms
    Creating sort index	0.12 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_jem/models/eventslist.php:457
    12	JemModelEventslist->getItems()	JROOT/components/com_jem/models/category.php:181
    11	JemModelCategory->getItems()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421
    10	JViewLegacy->get()	JROOT/components/com_jem/views/category/view.html.php:161
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Abfragezeit: 0.13 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 18.463 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #11  #14  #15  #29  #33  #34  #35  #36  #37  #38  #39  #40

    SELECT globalattribs
    
      FROM ssvh_jem_settings
    
      WHERE id = 1

    Explain

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

    Profil (Profile)

    Status	Duration
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 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.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    15	JDatabaseDriver->loadResult()	JROOT/components/com_jem/helpers/helper.php:67
    14	JemHelper::globalattribs()	JROOT/components/com_jem/models/eventslist.php:541
    13	JemModelEventslist->getCategories()	JROOT/components/com_jem/models/eventslist.php:506
    12	JemModelEventslist->getItems()	JROOT/components/com_jem/models/category.php:181
    11	JemModelCategory->getItems()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421
    10	JViewLegacy->get()	JROOT/components/com_jem/views/category/view.html.php:161
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Abfragezeit: 0.22 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 18.478 MB Zeilen zurückgegeben: 1

    SELECT DISTINCT c.id,c.catname,c.access,c.checked_out AS cchecked_out,c.color, 
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,a.id AS multi
    
      FROM ssvh_jem_categories as c
    
      LEFT JOIN ssvh_jem_cats_event_relations AS rel 
      ON rel.catid = c.id
    
      LEFT JOIN ssvh_jem_events AS a 
      ON a.id = rel.itemid
    
      WHERE rel.itemid =28 
      AND c.published = 1 
      AND (c.access IN (1,1)) 
      AND c.id = 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	NULL
    1	SIMPLE	rel	NULL	const	category event relation,catid,itemid	category event relation	8	const,const	1	100.00	Using index
    1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index

    Profil (Profile)

    Status	Duration
    starting	0.06 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 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.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jem/models/eventslist.php:665
    13	JemModelEventslist->getCategories()	JROOT/components/com_jem/models/eventslist.php:506
    12	JemModelEventslist->getItems()	JROOT/components/com_jem/models/category.php:181
    11	JemModelCategory->getItems()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421
    10	JViewLegacy->get()	JROOT/components/com_jem/views/category/view.html.php:161
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Abfragezeit: 0.26 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 18.477 MB Zeilen zurückgegeben: 0

    SELECT COUNT(id) as total, SUM(waiting) as waitinglist, event  
      FROM ssvh_jem_register  
      WHERE event IN (28) 
      GROUP BY event

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	NULL	no matching row in const table

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jem/helpers/helper.php:790
    13	JemHelper::getAttendeesNumbers()	JROOT/components/com_jem/models/eventslist.php:515
    12	JemModelEventslist->getItems()	JROOT/components/com_jem/models/category.php:181
    11	JemModelCategory->getItems()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421
    10	JViewLegacy->get()	JROOT/components/com_jem/views/category/view.html.php:161
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Abfragezeit: 0.36 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 18.486 MB Zeilen zurückgegeben: 0

    SELECT gr.id 
      FROM ssvh_jem_groups AS gr 
      LEFT JOIN ssvh_jem_groupmembers AS g 
      ON g.group_id = gr.id 
      WHERE g.member = 0 
      AND g.member NOT LIKE 0

    Explain

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

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    14	JDatabaseDriver->loadColumn()	JROOT/components/com_jem/classes/categories.class.php:174
    13	JEMCategories->_load()	JROOT/components/com_jem/classes/categories.class.php:113
    12	JEMCategories->get()	JROOT/components/com_jem/models/category.php:216
    11	JemModelCategory->getCategory()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421
    10	JViewLegacy->get()	JROOT/components/com_jem/views/category/view.html.php:162
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22. Abfragezeit: 1.40 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 18.496 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,COUNT(i.id) AS numitems
    
      FROM ssvh_jem_categories as c
    
      LEFT JOIN ssvh_jem_cats_event_relations AS rel 
      ON rel.catid = c.id
    
      LEFT JOIN ssvh_jem_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      LEFT JOIN  (SELECT cat.id as id 
      FROM ssvh_jem_categories AS cat JOIN ssvh_jem_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.published != 1 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      LEFT JOIN ssvh_jem_events AS i 
      ON rel.itemid = i.id 
      AND i.published IN (1)
    
      WHERE c.published = 1 
      AND (c.access IN (1,1)) 
      AND s.id=3 
      AND badcats.id is null
    
      GROUP BY c.id
    
      ORDER BY c.lft

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	s	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using temporary; filesort wurde genutzt
    1	PRIMARY	c	NULL	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	5	20.00	Using where
    1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	90716m70415_1.c.id	2	100.00	Using where; Not exists; Using index
    1	PRIMARY	rel	NULL	ref	category event relation,catid	category event relation	4	90716m70415_1.c.id	11	100.00	Using where; Using index
    1	PRIMARY	i	NULL	eq_ref	PRIMARY	PRIMARY	4	90716m70415_1.rel.itemid	1	100.00	Using where
    2	DERIVED	parent	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	5	80.00	Using where; Using temporary; filesort wurde genutzt
    2	DERIVED	cat	NULL	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	5	20.00	Using where; Using join buffer (Block Nested Loop)

    Profil (Profile)

    Status	Duration
    starting	0.09 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.17 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    Creating tmp table	0.01 ms
    Sorting result	0.02 ms
    statistics	0.06 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    executing	0.00 ms
    Sending data	0.03 ms
    Creating sort index	0.63 ms
    Creating sort index	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.03 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jem/classes/categories.class.php:249
    13	JEMCategories->_load()	JROOT/components/com_jem/classes/categories.class.php:113
    12	JEMCategories->get()	JROOT/components/com_jem/models/category.php:216
    11	JemModelCategory->getCategory()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421
    10	JViewLegacy->get()	JROOT/components/com_jem/views/category/view.html.php:162
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. Abfragezeit: 0.82 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 18.513 MB Zeilen zurückgegeben: 45

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `ssvh_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_aimysitemap','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_fields','com_finder','com_installer','com_jce','com_jem','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nova','com_phocadownload','com_phocagallery','com_phocaguestbook','com_pjinstaller','com_pjmvi','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_widgetkit','com_wrapper')

    Explain

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

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/components/com_jem/models/category.php:225
    11	JemModelCategory->getCategory()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421
    10	JViewLegacy->get()	JROOT/components/com_jem/views/category/view.html.php:162
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Abfragezeit: 0.30 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 18.573 MB Zeilen zurückgegeben: 2

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `ssvh_assets`
    
      WHERE `name` LIKE 'com_jem.%' OR `name` = 'com_jem' OR `parent_id` = 0

    Explain

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

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/components/com_jem/models/category.php:225
    11	JemModelCategory->getCategory()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421
    10	JViewLegacy->get()	JROOT/components/com_jem/views/category/view.html.php:162
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Abfragezeit: 0.37 ms Nach letzter Abfrage: 3.90 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 18.613 MB Zeilen zurückgegeben: 8

    SHOW FULL COLUMNS 
      FROM `ssvh_assets`

    Explain

    „EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `ssvh_assets`

    Profil (Profile)

    Status	Duration
    starting	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.11 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.01 ms
    checking permissions	0.02 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
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.02 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    17	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Asset.php:61
    16	Joomla\CMS\Table\Asset->__construct()	JROOT/libraries/src/Access/Access.php:783
    15	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/components/com_jem/models/category.php:225
    11	JemModelCategory->getCategory()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421
    10	JViewLegacy->get()	JROOT/components/com_jem/views/category/view.html.php:162
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Abfragezeit: 0.13 ms Nach letzter Abfrage: 0.96 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 18.639 MB Zeilen zurückgegeben: 0

    SELECT *
    
      FROM ssvh_assets
    
      WHERE `name` = 'com_jem.category.3'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	NULL	no matching row in const table

    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.02 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.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    17	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    16	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
    15	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/components/com_jem/models/category.php:225
    11	JemModelCategory->getCategory()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421
    10	JViewLegacy->get()	JROOT/components/com_jem/views/category/view.html.php:162
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Abfragezeit: 0.33 ms Nach letzter Abfrage: 1.21 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 18.664 MB Zeilen zurückgegeben: 1

    SELECT COUNT(*)
    
      FROM ssvh_jem_events as a
    
      LEFT JOIN ssvh_jem_venues AS l 
      ON l.id = a.locid
    
      LEFT JOIN ssvh_jem_countries AS ct 
      ON ct.iso2 = l.country
    
      LEFT JOIN ssvh_jem_cats_event_relations AS rel 
      ON rel.itemid = a.id
    
      LEFT JOIN ssvh_jem_categories AS c 
      ON c.id = rel.catid
    
      WHERE a.access IN (1,1) 
      AND a.published = 1 
      AND a.dates IS NOT NULL 
      AND c.id  IN (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 index
    1	SIMPLE	a	NULL	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	32	3.12	Using where
    1	SIMPLE	l	NULL	eq_ref	PRIMARY	PRIMARY	4	90716m70415_1.a.locid	1	100.00	NULL
    1	SIMPLE	rel	NULL	eq_ref	category event relation,catid,itemid	category event relation	8	const,90716m70415_1.a.id	1	100.00	Using where; Using index
    1	SIMPLE	ct	NULL	ref	iso2	iso2	8	90716m70415_1.l.country	1	100.00	Using index

    Profil (Profile)

    Status	Duration
    starting	0.04 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.01 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    14	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
    13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
    12	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
    11	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:421
    10	JViewLegacy->get()	JROOT/components/com_jem/views/category/view.html.php:165
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Abfragezeit: 0.14 ms Nach letzter Abfrage: 3.92 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 18.678 MB Zeilen zurückgegeben: 1

    SELECT parent_id 
      FROM ssvh_jem_categories 
      WHERE id = 3

    Explain

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

    Profil (Profile)

    Status	Duration
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 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.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    12	JDatabaseDriver->loadResult()	JROOT/components/com_jem/classes/categories.class.php:486
    11	JEMCategories::buildParentCats()	JROOT/components/com_jem/classes/categories.class.php:558
    10	JEMCategories->getParentlist()	JROOT/components/com_jem/views/category/view.html.php:233
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. Abfragezeit: 0.12 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 18.686 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #11  #14  #15  #18  #33  #34  #35  #36  #37  #38  #39  #40

    SELECT globalattribs
    
      FROM ssvh_jem_settings
    
      WHERE id = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ssvh_jem_settings	NULL	system	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	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.01 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.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    12	JDatabaseDriver->loadResult()	JROOT/components/com_jem/helpers/helper.php:67
    11	JemHelper::globalattribs()	JROOT/components/com_jem/helpers/route.php:74
    10	JEMHelperRoute::getCategoryRoute()	JROOT/components/com_jem/views/category/view.html.php:261
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Abfragezeit: 0.15 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 18.699 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 ssvh_jem_categories
    
      WHERE id = 3 
      AND published = 1

    Explain

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

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    12	JDatabaseDriver->loadObject()	JROOT/components/com_jem/classes/categories.class.php:453
    11	JEMCategories->getPath()	JROOT/components/com_jem/helpers/route.php:89
    10	JEMHelperRoute::getCategoryRoute()	JROOT/components/com_jem/views/category/view.html.php:261
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Abfragezeit: 0.14 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 18.706 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 ssvh_jem_categories
    
      WHERE id = 1 
      AND published = 1

    Explain

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

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 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.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    12	JDatabaseDriver->loadObject()	JROOT/components/com_jem/classes/categories.class.php:453
    11	JEMCategories->getPath()	JROOT/components/com_jem/helpers/route.php:89
    10	JEMHelperRoute::getCategoryRoute()	JROOT/components/com_jem/views/category/view.html.php:261
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Abfragezeit: 0.12 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 18.704 MB Zeilen zurückgegeben: 0

    SELECT gr.id 
      FROM ssvh_jem_groups AS gr 
      LEFT JOIN ssvh_jem_groupmembers AS g 
      ON g.group_id = gr.id 
      WHERE g.member = 0 
      AND `gr`.`addevent` = 1  
      AND g.member NOT LIKE 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	NULL	Impossible 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.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    11	JDatabaseDriver->loadColumn()	JROOT/components/com_jem/classes/user.class.php:130
    10	JEMUser::ismaintainer()	JROOT/components/com_jem/views/category/view.html.php:281
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Abfragezeit: 0.12 ms Nach letzter Abfrage: 1.55 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 18.745 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #11  #14  #15  #18  #29  #34  #35  #36  #37  #38  #39  #40

    SELECT globalattribs
    
      FROM ssvh_jem_settings
    
      WHERE id = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ssvh_jem_settings	NULL	system	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	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.01 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.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    15	JDatabaseDriver->loadResult()	JROOT/components/com_jem/helpers/helper.php:67
    14	JemHelper::globalattribs()	JROOT/components/com_jem/classes/output.class.php:115
    13	JEMOutput::archivebutton()	JROOT/components/com_jem/views/category/tmpl/default.php:17
    12	include JROOT/components/com_jem/views/category/tmpl/default.php	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:693
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:226
    10	JViewLegacy->display()	JROOT/components/com_jem/views/category/view.html.php:330
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 18.753 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #11  #14  #15  #18  #29  #33  #35  #36  #37  #38  #39  #40

    SELECT globalattribs
    
      FROM ssvh_jem_settings
    
      WHERE id = 1

    Explain

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

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 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.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    15	JDatabaseDriver->loadResult()	JROOT/components/com_jem/helpers/helper.php:67
    14	JemHelper::globalattribs()	JROOT/components/com_jem/classes/output.class.php:336
    13	JEMOutput::mailbutton()	JROOT/components/com_jem/views/category/tmpl/default.php:18
    12	include JROOT/components/com_jem/views/category/tmpl/default.php	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:693
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:226
    10	JViewLegacy->display()	JROOT/components/com_jem/views/category/view.html.php:330
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. Abfragezeit: 0.12 ms Nach letzter Abfrage: 2.67 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 18.776 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #11  #14  #15  #18  #29  #33  #34  #36  #37  #38  #39  #40

    SELECT globalattribs
    
      FROM ssvh_jem_settings
    
      WHERE id = 1

    Explain

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

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 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.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    15	JDatabaseDriver->loadResult()	JROOT/components/com_jem/helpers/helper.php:67
    14	JemHelper::globalattribs()	JROOT/components/com_jem/classes/output.class.php:290
    13	JEMOutput::printbutton()	JROOT/components/com_jem/views/category/tmpl/default.php:19
    12	include JROOT/components/com_jem/views/category/tmpl/default.php	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:693
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:226
    10	JViewLegacy->display()	JROOT/components/com_jem/views/category/view.html.php:330
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. Abfragezeit: 0.11 ms Nach letzter Abfrage: 1.99 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 18.814 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #11  #14  #15  #18  #29  #33  #34  #35  #37  #38  #39  #40

    SELECT globalattribs
    
      FROM ssvh_jem_settings
    
      WHERE id = 1

    Explain

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

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 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.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    18	JDatabaseDriver->loadResult()	JROOT/components/com_jem/helpers/helper.php:67
    17	JemHelper::globalattribs()	JROOT/components/com_jem/classes/output.class.php:846
    16	JEMOutput::formatDateTime()	JROOT/components/com_jem/classes/output.class.php:976
    15	JEMOutput::formatShortDateTime()	JROOT/components/com_jem/common/views/tmpl/default_events_table.php:126
    14	include JROOT/components/com_jem/common/views/tmpl/default_events_table.php	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:693
    13	JViewLegacy->loadTemplate()	JROOT/components/com_jem/views/category/tmpl/default.php:82
    12	include JROOT/components/com_jem/views/category/tmpl/default.php	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:693
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:226
    10	JViewLegacy->display()	JROOT/components/com_jem/views/category/view.html.php:330
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

37. Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 18.824 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #11  #14  #15  #18  #29  #33  #34  #35  #36  #38  #39  #40

    SELECT globalattribs
    
      FROM ssvh_jem_settings
    
      WHERE id = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ssvh_jem_settings	NULL	system	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	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.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.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    17	JDatabaseDriver->loadResult()	JROOT/components/com_jem/helpers/helper.php:67
    16	JemHelper::globalattribs()	JROOT/components/com_jem/classes/output.class.php:981
    15	JEMOutput::formatSchemaOrgDateTime()	JROOT/components/com_jem/common/views/tmpl/default_events_table.php:128
    14	include JROOT/components/com_jem/common/views/tmpl/default_events_table.php	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:693
    13	JViewLegacy->loadTemplate()	JROOT/components/com_jem/views/category/tmpl/default.php:82
    12	include JROOT/components/com_jem/views/category/tmpl/default.php	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:693
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:226
    10	JViewLegacy->display()	JROOT/components/com_jem/views/category/view.html.php:330
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

38. Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 18.833 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #11  #14  #15  #18  #29  #33  #34  #35  #36  #37  #39  #40

    SELECT globalattribs
    
      FROM ssvh_jem_settings
    
      WHERE id = 1

    Explain

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

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 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.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    17	JDatabaseDriver->loadResult()	JROOT/components/com_jem/helpers/helper.php:67
    16	JemHelper::globalattribs()	JROOT/components/com_jem/helpers/route.php:111
    15	JEMHelperRoute::getEventRoute()	JROOT/components/com_jem/common/views/tmpl/default_events_table.php:134
    14	include JROOT/components/com_jem/common/views/tmpl/default_events_table.php	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:693
    13	JViewLegacy->loadTemplate()	JROOT/components/com_jem/views/category/tmpl/default.php:82
    12	include JROOT/components/com_jem/views/category/tmpl/default.php	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:693
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:226
    10	JViewLegacy->display()	JROOT/components/com_jem/views/category/view.html.php:330
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

39. Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 18.843 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #11  #14  #15  #18  #29  #33  #34  #35  #36  #37  #38  #40

    SELECT globalattribs
    
      FROM ssvh_jem_settings
    
      WHERE id = 1

    Explain

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

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 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.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    17	JDatabaseDriver->loadResult()	JROOT/components/com_jem/helpers/helper.php:67
    16	JemHelper::globalattribs()	JROOT/components/com_jem/classes/output.class.php:691
    15	JEMOutput::recurrenceicon()	JROOT/components/com_jem/common/views/tmpl/default_events_table.php:135
    14	include JROOT/components/com_jem/common/views/tmpl/default_events_table.php	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:693
    13	JViewLegacy->loadTemplate()	JROOT/components/com_jem/views/category/tmpl/default.php:82
    12	include JROOT/components/com_jem/views/category/tmpl/default.php	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:693
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:226
    10	JViewLegacy->display()	JROOT/components/com_jem/views/category/view.html.php:330
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

40. Abfragezeit: 0.11 ms Nach letzter Abfrage: 1.00 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 18.839 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #11  #14  #15  #18  #29  #33  #34  #35  #36  #37  #38  #39

    SELECT globalattribs
    
      FROM ssvh_jem_settings
    
      WHERE id = 1

    Explain

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

    Profil (Profile)

    Status	Duration
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 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.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    15	JDatabaseDriver->loadResult()	JROOT/components/com_jem/helpers/helper.php:67
    14	JemHelper::globalattribs()	JROOT/components/com_jem/classes/output.class.php:378
    13	JEMOutput::icalbutton()	JROOT/components/com_jem/views/category/tmpl/default.php:98
    12	include JROOT/components/com_jem/views/category/tmpl/default.php	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:693
    11	JViewLegacy->loadTemplate()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/legacy/view/legacy.php:226
    10	JViewLegacy->display()	JROOT/components/com_jem/views/category/view.html.php:330
    9	JemViewCategory->display()	JROOT/components/com_jem/controller.php:101
    8	JEMController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jem/jem.php:41
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

41. Abfragezeit: 0.25 ms Nach letzter Abfrage: 1.67 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 18.829 MB Zeilen zurückgegeben: 1

    SELECT params 
      FROM ssvh_extensions AS e 
      WHERE e.element='com_widgetkit'

    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	element_clientid	402	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.01 ms
    optimizing	0.01 ms
    statistics	0.11 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_widgetkit/helpers/system.php:278
    13	SystemWidgetkitHelper->_getParams()	JROOT/administrator/components/com_widgetkit/helpers/system.php:54
    12	SystemWidgetkitHelper->__construct()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129
    11	Widgetkit->loadHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76
    10	Widgetkit->getHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137
    9	Widgetkit->offsetGet()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
    8	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
    7	plgSystemWidgetkit_System->onAfterDispatch()	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/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

42. Abfragezeit: 0.15 ms Nach letzter Abfrage: 0.33 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 18.838 MB Zeilen zurückgegeben: 1

    SELECT id,template 
      FROM ssvh_template_styles 
      WHERE client_id=0 
      AND home=1

    Explain

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

    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.01 ms
    optimizing	0.01 ms
    statistics	0.01 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.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    10	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/helpers/system.php:78
    9	SystemWidgetkitHelper->init()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
    8	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
    7	plgSystemWidgetkit_System->onAfterDispatch()	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/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

43. Abfragezeit: 0.31 ms Nach letzter Abfrage: 36.53 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 22.459 MB Zeilen zurückgegeben: 1

    SELECT params
    
      FROM ssvh_extensions
    
      WHERE type = 'template' 
      AND element = 'jsn_escape2_pro'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ssvh_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

    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.01 ms
    optimizing	0.01 ms
    statistics	0.15 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    14	JDatabaseDriver->loadResult()	JROOT/plugins/system/sunfw/includes/helper.php:1407
    13	SunFwHelper::getTemplateParams()	JROOT/plugins/system/sunfw/includes/site/helper.php:525
    12	SunFwSiteHelper->_autoLoadCustomCssFile()	JROOT/plugins/system/sunfw/includes/site/helper.php:455
    11	SunFwSiteHelper->_prepareHead()	JROOT/plugins/system/sunfw/includes/site/helper.php:240
    10	SunFwSiteHelper->_prepare()	JROOT/plugins/system/sunfw/includes/site/helper.php:105
    9	SunFwSiteHelper::prepare()	JROOT/plugins/system/sunfw/includes/site.php:263
    8	SunFwSite->render()	JROOT/templates/jsn_escape2_pro/index.php:20
    7	require JROOT/templates/jsn_escape2_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

44. Abfragezeit: 0.28 ms Nach letzter Abfrage: 0.88 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 22.472 MB Zeilen zurückgegeben: 1

    SELECT manifest_cache
    
      FROM ssvh_extensions
    
      WHERE type = 'template' 
      AND element = 'jsn_escape2_pro'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ssvh_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    12	JDatabaseDriver->loadResult()	JROOT/plugins/system/sunfw/includes/helper.php:77
    11	SunFwHelper::getManifestCache()	JROOT/plugins/system/sunfw/includes/site/pages/index.php:29
    10	include JROOT/plugins/system/sunfw/includes/site/pages/index.php	JROOT/plugins/system/sunfw/includes/site.php:459
    9	SunFwSite->renderLayout()	JROOT/plugins/system/sunfw/includes/site.php:274
    8	SunFwSite->render()	JROOT/templates/jsn_escape2_pro/index.php:20
    7	require JROOT/templates/jsn_escape2_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

45. Abfragezeit: 0.45 ms Nach letzter Abfrage: 10.83 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 22.715 MB Zeilen zurückgegeben: 0

    SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params, m.access
    
      FROM ssvh_modules AS m
    
      LEFT JOIN ssvh_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN ssvh_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2022-01-18 10:41:28') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-01-18 10:41:28') 
      AND m.id=296 
      AND m.client_id= 0 
      AND m.access IN (1, 1) 
      AND (mm.menuid = 213 OR mm.menuid <= 0)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	NULL	no matching row in const table

    Profil (Profile)

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.20 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.05 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.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    24	JDatabaseDriver->loadObject()	JROOT/plugins/system/sunfw/includes/module.php:62
    23	SunFwModule::render()	JROOT/plugins/system/sunfw/includes/site/components/items/joomla-module.php:49
    22	include JROOT/plugins/system/sunfw/includes/site/components/items/joomla-module.php	JROOT/plugins/system/sunfw/includes/site.php:502
    21	SunFwSite->renderComponent()	JROOT/plugins/system/sunfw/includes/site.php:554
    20	SunFwSite::renderItem()	JROOT/plugins/system/sunfw/includes/site/components/column.php:25
    19	include JROOT/plugins/system/sunfw/includes/site/components/column.php	JROOT/plugins/system/sunfw/includes/site.php:502
    18	SunFwSite->renderComponent()	JROOT/plugins/system/sunfw/includes/site.php:539
    17	SunFwSite::renderColumn()	JROOT/plugins/system/sunfw/includes/site/components/row.php:36
    16	include JROOT/plugins/system/sunfw/includes/site/components/row.php	JROOT/plugins/system/sunfw/includes/site.php:502
    15	SunFwSite->renderComponent()	JROOT/plugins/system/sunfw/includes/site.php:527
    14	SunFwSite::renderRow()	JROOT/plugins/system/sunfw/includes/site/components/section.php:26
    13	include JROOT/plugins/system/sunfw/includes/site/components/section.php	JROOT/plugins/system/sunfw/includes/site.php:502
    12	SunFwSite->renderComponent()	JROOT/plugins/system/sunfw/includes/site.php:515
    11	SunFwSite::renderSection()	JROOT/plugins/system/sunfw/includes/site/pages/index.php:193
    10	include JROOT/plugins/system/sunfw/includes/site/pages/index.php	JROOT/plugins/system/sunfw/includes/site.php:459
    9	SunFwSite->renderLayout()	JROOT/plugins/system/sunfw/includes/site.php:274
    8	SunFwSite->render()	JROOT/templates/jsn_escape2_pro/index.php:20
    7	require JROOT/templates/jsn_escape2_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

46. Abfragezeit: 0.78 ms Nach letzter Abfrage: 1.44 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 22.720 MB Zeilen zurückgegeben: 7

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM ssvh_modules AS m
    
      LEFT JOIN ssvh_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN ssvh_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2022-01-18 10:41:28') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-01-18 10:41:28') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 213 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ref	PRIMARY,published,newsfeeds	published	1	const	39	0.85	Using index condition; Using where; filesort wurde genutzt
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	90716m70415_1.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	90716m70415_1.m.id	2	40.00	Using where; Using index

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    26	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/cms/module/helper.php:495
    25	JModuleHelper::getModuleList()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/cms/module/helper.php:434
    24	JModuleHelper::load()	JROOT/plugins/system/sunfw/includes/overwrite/j3x/libraries/cms/module/helper.php:88
    23	JModuleHelper::getModules()	JROOT/plugins/system/sunfw/includes/site/components/items/module-position.php:37
    22	include JROOT/plugins/system/sunfw/includes/site/components/items/module-position.php	JROOT/plugins/system/sunfw/includes/site.php:502
    21	SunFwSite->renderComponent()	JROOT/plugins/system/sunfw/includes/site.php:554
    20	SunFwSite::renderItem()	JROOT/plugins/system/sunfw/includes/site/components/column.php:25
    19	include JROOT/plugins/system/sunfw/includes/site/components/column.php	JROOT/plugins/system/sunfw/includes/site.php:502
    18	SunFwSite->renderComponent()	JROOT/plugins/system/sunfw/includes/site.php:539
    17	SunFwSite::renderColumn()	JROOT/plugins/system/sunfw/includes/site/components/row.php:36
    16	include JROOT/plugins/system/sunfw/includes/site/components/row.php	JROOT/plugins/system/sunfw/includes/site.php:502
    15	SunFwSite->renderComponent()	JROOT/plugins/system/sunfw/includes/site.php:527
    14	SunFwSite::renderRow()	JROOT/plugins/system/sunfw/includes/site/components/section.php:26
    13	include JROOT/plugins/system/sunfw/includes/site/components/section.php	JROOT/plugins/system/sunfw/includes/site.php:502
    12	SunFwSite->renderComponent()	JROOT/plugins/system/sunfw/includes/site.php:515
    11	SunFwSite::renderSection()	JROOT/plugins/system/sunfw/includes/site/pages/index.php:193
    10	include JROOT/plugins/system/sunfw/includes/site/pages/index.php	JROOT/plugins/system/sunfw/includes/site.php:459
    9	SunFwSite->renderLayout()	JROOT/plugins/system/sunfw/includes/site.php:274
    8	SunFwSite->render()	JROOT/templates/jsn_escape2_pro/index.php:20
    7	require JROOT/templates/jsn_escape2_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

47. Abfragezeit: 0.28 ms Nach letzter Abfrage: 9.17 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 22.677 MB Zeilen zurückgegeben: 1

    SELECT params
    
      FROM ssvh_extensions
    
      WHERE type = 'plugin' 
      AND element = 'sunfw' 
      AND folder = 'system'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ssvh_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_folder_clientid	804	const,const	2	10.00	Using where

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    13	JDatabaseDriver->loadResult()	JROOT/plugins/system/sunfw/includes/helper.php:1105
    12	SunFwHelper::getExtensionParams()	JROOT/plugins/system/sunfw/includes/site.php:621
    11	SunFwSite::renderBrandingLink()	JROOT/plugins/system/sunfw/includes/site/pages/index.php:264
    10	include JROOT/plugins/system/sunfw/includes/site/pages/index.php	JROOT/plugins/system/sunfw/includes/site.php:459
    9	SunFwSite->renderLayout()	JROOT/plugins/system/sunfw/includes/site.php:274
    8	SunFwSite->render()	JROOT/templates/jsn_escape2_pro/index.php:20
    7	require JROOT/templates/jsn_escape2_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---