{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1653529020,
                "last": 1653529020,
                "now": 1653529020
            },
            "token": "5Pm3siebesw9RS45VWB0w8EbWkhZjmkD"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Zeit

Speicher

100 ausgeführte Abfragen 80.06 ms

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

   SELECT `data`
   
     FROM `feb2016_session`
   
     WHERE `session_id` = '4s19holm85pegu8afnuskmmgtu'

   Explain

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

   Profil (Profile)

   Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

   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.22 ms Nach letzter Abfrage: 0.41 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.623 MB Zeilen zurückgegeben: 0

   SELECT `session_id`
   
     FROM `feb2016_session`
   
     WHERE `session_id` = '4s19holm85pegu8afnuskmmgtu' 
     LIMIT 1

   Explain

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

   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
   executing	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.04 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: 1.29 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 4.629 MB

   INSERT INTO `feb2016_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('4s19holm85pegu8afnuskmmgtu', 1, 1653529020, 0, '', 0)

   Explain

   „EXPLAIN“ unmöglich für Abfrage: INSERT INTO `feb2016_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('4s19holm85pegu8afnuskmmgtu', 1, 1653529020, 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.01 ms
   update	0.05 ms
   Waiting for query cache lock	0.01 ms
   update	0.01 ms
   end	0.01 ms
   query end	1.01 ms
   closing tables	0.03 ms
   freeing items	0.05 ms
   cleaning up	0.02 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.46 ms Nach letzter Abfrage: 1.60 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 5.142 MB Zeilen zurückgegeben: 5

   SELECT id, rules
   
     FROM `feb2016_viewlevels`

   Explain

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

   Profil (Profile)

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.17 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.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.04 ms
   logging slow query	0.04 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.47 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 5.155 MB Zeilen zurückgegeben: 1

   SELECT b.id
   
     FROM feb2016_usergroups AS a
   
     LEFT JOIN feb2016_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.01 ms
   checking permissions	0.01 ms
   Opening tables	0.12 ms
   init	0.03 ms
   System lock	0.02 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.01 ms
   executing	0.01 ms
   Sending data	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.04 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: 1.50 ms Nach letzter Abfrage: 14.94 ms Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 9.489 MB

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

   Explain

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

   Profil (Profile)

   Status	Duration
   starting	0.07 ms
   checking permissions	0.01 ms
   Opening tables	0.09 ms
   init	0.02 ms
   System lock	0.07 ms
   updating	0.06 ms
   end	0.01 ms
   Waiting for query cache lock	0.01 ms
   end	0.01 ms
   query end	0.87 ms
   closing tables	0.03 ms
   freeing items	0.06 ms
   cleaning up	0.02 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   22	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   21	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   20	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   19	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   18	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   17	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/HTML/HTMLHelper.php:731
   16	Joomla\CMS\HTML\HTMLHelper::script()	Derselbe Aufruf in der Zeile darunter.
   15	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
   14	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
   13	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
   12	JHtmlJquery::framework()	Derselbe Aufruf in der Zeile darunter.
   11	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
   10	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
   9	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/jquery/jquery.php:22
   8	plgSystemJquery->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]

   ---

7. Abfragezeit: 0.53 ms Nach letzter Abfrage: 4.47 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.050 MB Zeilen zurückgegeben: 1

   SELECT c.*, 
     CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
     FROM feb2016_seminarman_categories AS c 
     WHERE c.id = 44 
     AND c.published = 1

   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

   Profil (Profile)

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

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
   13	JDatabaseDriver->loadObject()	JROOT/components/com_seminarman/models/category.php:281
   12	SeminarmanModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
   11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_seminarman/views/category/view.html.php:50
   10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
   9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
   8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
   6	require_once JROOT/components/com_seminarman/seminarman.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]

   ---

8. Abfragezeit: 2.64 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.243 MB Speichernutzung vor Abfrage: 11.067 MB Zeilen zurückgegeben: 15

   SELECT i.*, (i.plus / (i.plus + i.minus) ) * 100 AS votes, CONCAT_WS(" ", emp.firstname, emp.lastname) as tutor, 
     CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, gr.title AS cgroup, lev.title AS level
   
     FROM feb2016_seminarman_courses AS i
   
     LEFT JOIN feb2016_seminarman_favourites AS f 
     ON f.courseid = i.id
   
     LEFT JOIN feb2016_seminarman_tags_course_relations AS t 
     ON t.courseid = i.id
   
     LEFT JOIN feb2016_seminarman_cats_course_relations AS rel 
     ON rel.courseid = i.id
   
     LEFT JOIN feb2016_seminarman_tutor AS emp 
     ON emp.id = i.tutor_id
   
     LEFT JOIN feb2016_seminarman_atgroup AS gr 
     ON gr.id = i.id_group
   
     LEFT JOIN feb2016_seminarman_experience_level AS lev 
     ON lev.id = i.id_experience_level
   
     LEFT JOIN feb2016_seminarman_categories AS c 
     ON c.id = rel.catid
   
     WHERE i.state = 1 
     AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-05-26 01:37:00' ) 
     AND ( CONCAT_WS(' ', i.finish_date, i.finish_time) = '0000-00-00 00:00:00' OR CONCAT_WS(' ', i.finish_date, i.finish_time) >= '2022-05-26 01:37:00' ) 
     AND rel.catid = 44
   
     GROUP BY i.id
   
     ORDER BY i.start_date ASC, i.start_time, i.title 
     LIMIT 30

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	f	NULL	system	itemid	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	0	0.00	const row not found
   1	SIMPLE	rel	NULL	ref	PRIMARY,catid,itemid	PRIMARY	4	const	17	100.00	Using where; Using index; Using temporary; filesort wurde genutzt
   1	SIMPLE	i	NULL	eq_ref	PRIMARY	PRIMARY	4	db260256_15.rel.courseid	1	5.00	Using where
   1	SIMPLE	emp	NULL	eq_ref	PRIMARY	PRIMARY	4	db260256_15.i.tutor_id	1	100.00	Using where
   1	SIMPLE	gr	NULL	eq_ref	PRIMARY	PRIMARY	4	db260256_15.i.id_group	1	100.00	NULL
   1	SIMPLE	lev	NULL	eq_ref	PRIMARY	PRIMARY	4	db260256_15.i.id_experience_level	1	100.00	NULL
   1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
   1	SIMPLE	t	NULL	ref	itemid	itemid	4	db260256_15.rel.courseid	5	100.00	Using index

   Profil (Profile)

   Status	Duration
   starting	0.21 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
   checking permissions	0.01 ms
   Opening tables	0.44 ms
   init	0.08 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.09 ms
   preparing	0.02 ms
   Creating tmp table	0.05 ms
   Sorting result	0.01 ms
   executing	0.01 ms
   Sending data	0.80 ms
   Creating sort index	0.59 ms
   end	0.01 ms
   query end	0.01 ms
   removing tmp table	0.04 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.04 ms
   cleaning up	0.02 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
   13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_seminarman/models/category.php:106
   12	SeminarmanModelCategory->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
   11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_seminarman/views/category/view.html.php:51
   10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
   9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
   8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
   6	require_once JROOT/components/com_seminarman/seminarman.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]

   ---

9. Abfragezeit: 0.72 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 11.275 MB Zeilen zurückgegeben: 0

   SELECT i.*, (i.plus / (i.plus + i.minus) ) * 100 AS votes, CONCAT_WS(" ", emp.firstname, emp.lastname) as tutor, 
     CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, gr.title AS cgroup, lev.title AS level
   
     FROM feb2016_seminarman_courses AS i
   
     LEFT JOIN feb2016_seminarman_favourites AS f 
     ON f.courseid = i.id
   
     LEFT JOIN feb2016_seminarman_tags_course_relations AS t 
     ON t.courseid = i.id
   
     LEFT JOIN feb2016_seminarman_cats_course_relations AS rel 
     ON rel.courseid = i.id
   
     LEFT JOIN feb2016_seminarman_tutor AS emp 
     ON emp.id = i.tutor_id
   
     LEFT JOIN feb2016_seminarman_atgroup AS gr 
     ON gr.id = i.id_group
   
     LEFT JOIN feb2016_seminarman_experience_level AS lev 
     ON lev.id = i.id_experience_level
   
     LEFT JOIN feb2016_seminarman_categories AS c 
     ON c.id = rel.catid
   
     WHERE i.state = 2 
     AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-05-26 01:37:00' ) 
     AND rel.catid = 44
   
     GROUP BY i.id
   
     ORDER BY i.start_date ASC, i.start_time, i.title 
     LIMIT 20

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	f	NULL	system	itemid	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	0	0.00	const row not found
   1	SIMPLE	rel	NULL	ref	PRIMARY,catid,itemid	PRIMARY	4	const	17	100.00	Using where; Using index; Using temporary; filesort wurde genutzt
   1	SIMPLE	i	NULL	eq_ref	PRIMARY	PRIMARY	4	db260256_15.rel.courseid	1	5.00	Using where
   1	SIMPLE	emp	NULL	eq_ref	PRIMARY	PRIMARY	4	db260256_15.i.tutor_id	1	100.00	Using where
   1	SIMPLE	gr	NULL	eq_ref	PRIMARY	PRIMARY	4	db260256_15.i.id_group	1	100.00	NULL
   1	SIMPLE	lev	NULL	eq_ref	PRIMARY	PRIMARY	4	db260256_15.i.id_experience_level	1	100.00	NULL
   1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
   1	SIMPLE	t	NULL	ref	itemid	itemid	4	db260256_15.rel.courseid	5	100.00	Using index

   Profil (Profile)

   Status	Duration
   starting	0.07 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
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.05 ms
   System lock	0.01 ms
   optimizing	0.01 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.19 ms
   Creating sort index	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   removing tmp table	0.02 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.04 ms
   cleaning up	0.02 ms

   Call Stack

   #	Aufrufer	Datei und Zeilennummer
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
   13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_seminarman/models/category.php:143
   12	SeminarmanModelCategory->getArchive()	JROOT/libraries/src/MVC/View/HtmlView.php:425
   11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_seminarman/views/category/view.html.php:52
   10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
   9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
   8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
   6	require_once JROOT/components/com_seminarman/seminarman.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]

   ---

10. Abfragezeit: 1.13 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.089 MB Speichernutzung vor Abfrage: 11.276 MB Zeilen zurückgegeben: 5

    SELECT DISTINCT i.*, gr.title AS cgroup, lev.title AS level, i.id AS slug 
      FROM feb2016_seminarman_templates AS i  
      LEFT JOIN feb2016_seminarman_cats_template_relations AS rel 
      ON rel.templateid = i.id 
      LEFT JOIN feb2016_seminarman_atgroup AS gr 
      ON gr.id = i.id_group 
      LEFT JOIN feb2016_seminarman_experience_level AS lev 
      ON lev.id = i.id_experience_level 
      WHERE i.state=1 
      AND rel.catid=44 
      ORDER BY i.start_date ASC, i.title 
      LIMIT 0, 20

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	rel	NULL	ref	PRIMARY,catid,itemid	PRIMARY	4	const	19	100.00	Using where; Using index; Using temporary; filesort wurde genutzt
    1	SIMPLE	i	NULL	eq_ref	PRIMARY	PRIMARY	4	db260256_15.rel.templateid	1	10.00	Using where
    1	SIMPLE	gr	NULL	eq_ref	PRIMARY	PRIMARY	4	db260256_15.i.id_group	1	100.00	NULL
    1	SIMPLE	lev	NULL	eq_ref	PRIMARY	PRIMARY	4	db260256_15.i.id_experience_level	1	100.00	NULL

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.16 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    Creating tmp table	0.04 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.32 ms
    Creating sort index	0.28 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.02 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_seminarman/models/category.php:365
    12	SeminarmanModelCategory->getLstOfProspects()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_seminarman/views/category/view.html.php:53
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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.21 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 11.344 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #12

    SELECT parent_id 
      FROM feb2016_seminarman_categories 
      WHERE id = 44

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	feb2016_seminarman_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.01 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    13	JDatabaseDriver->loadResult()	JROOT/components/com_seminarman/classes/categories.php:68
    12	seminarman_cats->buildParentCats()	JROOT/components/com_seminarman/classes/categories.php:35
    11	seminarman_cats->__construct()	JROOT/components/com_seminarman/views/category/view.html.php:59
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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.26 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 11.350 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #11

    SELECT parent_id 
      FROM feb2016_seminarman_categories 
      WHERE id = 44

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	feb2016_seminarman_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.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    13	JDatabaseDriver->loadResult()	JROOT/components/com_seminarman/classes/categories.php:70
    12	seminarman_cats->buildParentCats()	JROOT/components/com_seminarman/classes/categories.php:35
    11	seminarman_cats->__construct()	JROOT/components/com_seminarman/views/category/view.html.php:59
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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.21 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.357 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #14

    SELECT parent_id 
      FROM feb2016_seminarman_categories 
      WHERE id = 2

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	feb2016_seminarman_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.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    14	JDatabaseDriver->loadResult()	JROOT/components/com_seminarman/classes/categories.php:68
    13	seminarman_cats->buildParentCats()	JROOT/components/com_seminarman/classes/categories.php:70
    12	seminarman_cats->buildParentCats()	JROOT/components/com_seminarman/classes/categories.php:35
    11	seminarman_cats->__construct()	JROOT/components/com_seminarman/views/category/view.html.php:59
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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.19 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.364 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #13

    SELECT parent_id 
      FROM feb2016_seminarman_categories 
      WHERE id = 2

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	feb2016_seminarman_categories	NULL	const	PRIMARY	PRIMARY	4	const	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.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    14	JDatabaseDriver->loadResult()	JROOT/components/com_seminarman/classes/categories.php:70
    13	seminarman_cats->buildParentCats()	JROOT/components/com_seminarman/classes/categories.php:70
    12	seminarman_cats->buildParentCats()	JROOT/components/com_seminarman/classes/categories.php:35
    11	seminarman_cats->__construct()	JROOT/components/com_seminarman/views/category/view.html.php:59
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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.16 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.371 MB Zeilen zurückgegeben: 0

    SELECT parent_id 
      FROM feb2016_seminarman_categories 
      WHERE id = 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.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.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    15	JDatabaseDriver->loadResult()	JROOT/components/com_seminarman/classes/categories.php:68
    14	seminarman_cats->buildParentCats()	JROOT/components/com_seminarman/classes/categories.php:70
    13	seminarman_cats->buildParentCats()	JROOT/components/com_seminarman/classes/categories.php:70
    12	seminarman_cats->buildParentCats()	JROOT/components/com_seminarman/classes/categories.php:35
    11	seminarman_cats->__construct()	JROOT/components/com_seminarman/views/category/view.html.php:59
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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.22 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 11.378 MB Zeilen zurückgegeben: 1

    SELECT id, title, 
      CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as categoryslug 
      FROM feb2016_seminarman_categories 
      WHERE id =2 
      AND published = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	feb2016_seminarman_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.01 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    13	JDatabaseDriver->loadObject()	JROOT/components/com_seminarman/classes/categories.php:52
    12	seminarman_cats->getParentCats()	JROOT/components/com_seminarman/classes/categories.php:36
    11	seminarman_cats->__construct()	JROOT/components/com_seminarman/views/category/view.html.php:59
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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.40 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.387 MB Zeilen zurückgegeben: 1

    SELECT id, title, 
      CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as categoryslug 
      FROM feb2016_seminarman_categories 
      WHERE id =44 
      AND published = 1

    Explain

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

    Profil (Profile)

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

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    13	JDatabaseDriver->loadObject()	JROOT/components/com_seminarman/classes/categories.php:52
    12	seminarman_cats->getParentCats()	JROOT/components/com_seminarman/classes/categories.php:36
    11	seminarman_cats->__construct()	JROOT/components/com_seminarman/views/category/view.html.php:59
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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.72 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.396 MB Zeilen zurückgegeben: 0

    SELECT c.*, 
      CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug, ( SELECT COUNT( DISTINCT i.id ) 
      FROM feb2016_seminarman_courses AS i 
      LEFT JOIN feb2016_seminarman_cats_course_relations AS rel 
      ON rel.courseid = i.id 
      LEFT JOIN feb2016_seminarman_categories AS cc 
      ON cc.id = rel.catid 
      WHERE cc.published = 1 
      AND cc.parent_id = 44 
      AND c.id = cc.id 
      AND i.state = 1 
      AND ( publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-05-26 01:37:00' ) 
      AND ( CONCAT_WS(' ', i.finish_date, i.finish_time) = '0000-00-00 00:00:00' OR CONCAT_WS(' ', i.finish_date, i.finish_time) >= '2022-05-26 01:37:00' ) 
      GROUP BY cc.id) AS assignedseminarmans 
      FROM feb2016_seminarman_categories AS c 
      WHERE c.published = 1 
      AND c.parent_id = 44 
      ORDER BY ordering ASC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	c	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	52	1.92	Using where; filesort wurde genutzt
    2	DEPENDENT SUBQUERY	cc	NULL	eq_ref	PRIMARY	PRIMARY	4	db260256_15.c.id	1	5.00	Using index condition; Using where
    2	DEPENDENT SUBQUERY	rel	NULL	ref	PRIMARY,catid,itemid	PRIMARY	4	db260256_15.cc.id	33	100.00	Using where; Using index
    2	DEPENDENT SUBQUERY	i	NULL	eq_ref	PRIMARY	PRIMARY	4	db260256_15.rel.courseid	1	5.00	Using where

    Profil (Profile)

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.11 ms
    init	0.08 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Sorting result	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.05 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.04 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.06 ms
    logging slow query	0.04 ms
    cleaning up	0.02 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_seminarman/models/category.php:224
    12	SeminarmanModelCategory->getChilds()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_seminarman/views/category/view.html.php:61
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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.69 ms Nach letzter Abfrage: 1.06 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.027 MB Zeilen zurückgegeben: 3

    SELECT DISTINCT t.name, 
      CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug 
      FROM feb2016_seminarman_tags AS t 
      LEFT JOIN feb2016_seminarman_tags_course_relations AS i 
      ON i.tid = t.id 
      WHERE i.courseid = 767 
      AND t.published = 1 
      ORDER BY t.name

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i	NULL	ref	PRIMARY,tid,itemid	itemid	4	const	3	100.00	Using where; Using temporary; filesort wurde genutzt
    1	SIMPLE	t	NULL	eq_ref	PRIMARY	PRIMARY	4	db260256_15.i.tid	1	10.00	Using where

    Profil (Profile)

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.11 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    Creating tmp table	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.07 ms
    Creating sort index	0.02 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.05 ms
    cleaning up	0.02 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_seminarman/classes/helper.php:1568
    12	SMANFunctions::getCourseTags()	JROOT/components/com_seminarman/classes/helper.php:1027
    11	SMANFunctions::setCourse()	JROOT/components/com_seminarman/views/category/view.html.php:93
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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: 1.27 ms Nach letzter Abfrage: 0.47 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.053 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #21  #22

    SELECT SUM(b.attendees) 
      FROM feb2016_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 767 
      AND (( b.status > -1 
      AND b.status < 3 ) OR ( b.status = 5 ))

    Explain

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

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.94 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    logging slow query	0.04 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/components/com_seminarman/classes/helper.php:1384
    12	SMANFunctions::setCourseStatus()	JROOT/components/com_seminarman/classes/helper.php:1049
    11	SMANFunctions::setCourse()	JROOT/components/com_seminarman/views/category/view.html.php:93
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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: 1.10 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.059 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #20  #22

    SELECT SUM(b.attendees) 
      FROM feb2016_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 767 
      AND (( b.status > -1 
      AND b.status < 3 ) OR ( b.status = 5 ))

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	b	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2648	0.20	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.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.87 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    logging slow query	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    13	JDatabaseDriver->loadResult()	JROOT/components/com_seminarman/classes/helper.php:1386
    12	SMANFunctions::setCourseStatus()	JROOT/components/com_seminarman/classes/helper.php:1049
    11	SMANFunctions::setCourse()	JROOT/components/com_seminarman/views/category/view.html.php:93
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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.11 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.066 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #20  #21

    SELECT SUM(b.attendees) 
      FROM feb2016_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 767 
      AND (( b.status > -1 
      AND b.status < 3 ) OR ( b.status = 5 ))

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	b	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2648	0.20	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.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.89 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    logging slow query	0.02 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/components/com_seminarman/classes/helper.php:1388
    12	SMANFunctions::setCourseStatus()	JROOT/components/com_seminarman/classes/helper.php:1049
    11	SMANFunctions::setCourse()	JROOT/components/com_seminarman/views/category/view.html.php:93
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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.33 ms Nach letzter Abfrage: 0.36 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.075 MB Zeilen zurückgegeben: 0

    SELECT * 
      FROM feb2016_seminarman_sessions 
      WHERE published = 1 
      AND courseid = 767 
      ORDER BY session_date, start_time, ordering

    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.08 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_seminarman/classes/helper.php:1287
    11	SMANFunctions::setCourse()	JROOT/components/com_seminarman/views/category/view.html.php:93
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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.38 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.081 MB Zeilen zurückgegeben: 3

    SELECT DISTINCT t.name, 
      CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug 
      FROM feb2016_seminarman_tags AS t 
      LEFT JOIN feb2016_seminarman_tags_course_relations AS i 
      ON i.tid = t.id 
      WHERE i.courseid = 768 
      AND t.published = 1 
      ORDER BY t.name

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i	NULL	ref	PRIMARY,tid,itemid	itemid	4	const	3	100.00	Using where; Using temporary; filesort wurde genutzt
    1	SIMPLE	t	NULL	eq_ref	PRIMARY	PRIMARY	4	db260256_15.i.tid	1	10.00	Using where

    Profil (Profile)

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.03 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    Creating tmp table	0.01 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.01 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.04 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_seminarman/classes/helper.php:1568
    12	SMANFunctions::getCourseTags()	JROOT/components/com_seminarman/classes/helper.php:1027
    11	SMANFunctions::setCourse()	JROOT/components/com_seminarman/views/category/view.html.php:93
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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: 1.15 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.097 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #26  #27

    SELECT SUM(b.attendees) 
      FROM feb2016_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 768 
      AND (( b.status > -1 
      AND b.status < 3 ) OR ( b.status = 5 ))

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	b	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2648	0.20	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.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.92 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    logging slow query	0.02 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/components/com_seminarman/classes/helper.php:1384
    12	SMANFunctions::setCourseStatus()	JROOT/components/com_seminarman/classes/helper.php:1049
    11	SMANFunctions::setCourse()	JROOT/components/com_seminarman/views/category/view.html.php:93
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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: 1.16 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.104 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #25  #27

    SELECT SUM(b.attendees) 
      FROM feb2016_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 768 
      AND (( b.status > -1 
      AND b.status < 3 ) OR ( b.status = 5 ))

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	b	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2648	0.20	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.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.89 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    logging slow query	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    13	JDatabaseDriver->loadResult()	JROOT/components/com_seminarman/classes/helper.php:1386
    12	SMANFunctions::setCourseStatus()	JROOT/components/com_seminarman/classes/helper.php:1049
    11	SMANFunctions::setCourse()	JROOT/components/com_seminarman/views/category/view.html.php:93
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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: 1.10 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.110 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #25  #26

    SELECT SUM(b.attendees) 
      FROM feb2016_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 768 
      AND (( b.status > -1 
      AND b.status < 3 ) OR ( b.status = 5 ))

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	b	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2648	0.20	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.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.88 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    logging slow query	0.02 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/components/com_seminarman/classes/helper.php:1388
    12	SMANFunctions::setCourseStatus()	JROOT/components/com_seminarman/classes/helper.php:1049
    11	SMANFunctions::setCourse()	JROOT/components/com_seminarman/views/category/view.html.php:93
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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.22 ms Nach letzter Abfrage: 0.26 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.118 MB Zeilen zurückgegeben: 0

    SELECT * 
      FROM feb2016_seminarman_sessions 
      WHERE published = 1 
      AND courseid = 768 
      ORDER BY session_date, start_time, ordering

    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.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_seminarman/classes/helper.php:1287
    11	SMANFunctions::setCourse()	JROOT/components/com_seminarman/views/category/view.html.php:93
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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.33 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.124 MB Zeilen zurückgegeben: 3

    SELECT DISTINCT t.name, 
      CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug 
      FROM feb2016_seminarman_tags AS t 
      LEFT JOIN feb2016_seminarman_tags_course_relations AS i 
      ON i.tid = t.id 
      WHERE i.courseid = 765 
      AND t.published = 1 
      ORDER BY t.name

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i	NULL	ref	PRIMARY,tid,itemid	itemid	4	const	3	100.00	Using where; Using temporary; filesort wurde genutzt
    1	SIMPLE	t	NULL	eq_ref	PRIMARY	PRIMARY	4	db260256_15.i.tid	1	10.00	Using where

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 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.03 ms
    preparing	0.01 ms
    Creating tmp table	0.01 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.01 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.04 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_seminarman/classes/helper.php:1568
    12	SMANFunctions::getCourseTags()	JROOT/components/com_seminarman/classes/helper.php:1027
    11	SMANFunctions::setCourse()	JROOT/components/com_seminarman/views/category/view.html.php:93
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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: 1.12 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.140 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #31  #32

    SELECT SUM(b.attendees) 
      FROM feb2016_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 765 
      AND (( b.status > -1 
      AND b.status < 3 ) OR ( b.status = 5 ))

    Explain

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

    Profil (Profile)

    Status	Duration
    starting	0.02 ms
    checking permissions	0.02 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.01 ms
    Sending data	0.88 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    logging slow query	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    13	JDatabaseDriver->loadResult()	JROOT/components/com_seminarman/classes/helper.php:1384
    12	SMANFunctions::setCourseStatus()	JROOT/components/com_seminarman/classes/helper.php:1049
    11	SMANFunctions::setCourse()	JROOT/components/com_seminarman/views/category/view.html.php:93
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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: 1.10 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.147 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #30  #32

    SELECT SUM(b.attendees) 
      FROM feb2016_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 765 
      AND (( b.status > -1 
      AND b.status < 3 ) OR ( b.status = 5 ))

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	b	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2648	0.20	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.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.88 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    logging slow query	0.02 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/components/com_seminarman/classes/helper.php:1386
    12	SMANFunctions::setCourseStatus()	JROOT/components/com_seminarman/classes/helper.php:1049
    11	SMANFunctions::setCourse()	JROOT/components/com_seminarman/views/category/view.html.php:93
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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: 1.09 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.154 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #30  #31

    SELECT SUM(b.attendees) 
      FROM feb2016_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 765 
      AND (( b.status > -1 
      AND b.status < 3 ) OR ( b.status = 5 ))

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	b	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2648	0.20	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.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.88 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    logging slow query	0.02 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/components/com_seminarman/classes/helper.php:1388
    12	SMANFunctions::setCourseStatus()	JROOT/components/com_seminarman/classes/helper.php:1049
    11	SMANFunctions::setCourse()	JROOT/components/com_seminarman/views/category/view.html.php:93
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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.24 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 12.168 MB Zeilen zurückgegeben: 0

    SELECT * 
      FROM feb2016_seminarman_sessions 
      WHERE published = 1 
      AND courseid = 765 
      ORDER BY session_date, start_time, ordering

    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.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_seminarman/classes/helper.php:1287
    11	SMANFunctions::setCourse()	JROOT/components/com_seminarman/views/category/view.html.php:93
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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.34 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.175 MB Zeilen zurückgegeben: 3

    SELECT DISTINCT t.name, 
      CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug 
      FROM feb2016_seminarman_tags AS t 
      LEFT JOIN feb2016_seminarman_tags_course_relations AS i 
      ON i.tid = t.id 
      WHERE i.courseid = 766 
      AND t.published = 1 
      ORDER BY t.name

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	i	NULL	ref	PRIMARY,tid,itemid	itemid	4	const	3	100.00	Using where; Using temporary; filesort wurde genutzt
    1	SIMPLE	t	NULL	eq_ref	PRIMARY	PRIMARY	4	db260256_15.i.tid	1	10.00	Using where

    Profil (Profile)

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 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.03 ms
    preparing	0.01 ms
    Creating tmp table	0.01 ms
    Sorting result	0.01 ms
    executing	0.02 ms
    Sending data	0.03 ms
    Creating sort index	0.01 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.04 ms
    cleaning up	0.01 ms

    Call Stack

    #	Aufrufer	Datei und Zeilennummer
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_seminarman/classes/helper.php:1568
    12	SMANFunctions::getCourseTags()	JROOT/components/com_seminarman/classes/helper.php:1027
    11	SMANFunctions::setCourse()	JROOT/components/com_seminarman/views/category/view.html.php:93
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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: 1.18 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.191 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #36  #37

    SELECT SUM(b.attendees) 
      FROM feb2016_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 766 
      AND (( b.status > -1 
      AND b.status < 3 ) OR ( b.status = 5 ))

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	b	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2648	0.20	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.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.90 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    logging slow query	0.02 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/components/com_seminarman/classes/helper.php:1384
    12	SMANFunctions::setCourseStatus()	JROOT/components/com_seminarman/classes/helper.php:1049
    11	SMANFunctions::setCourse()	JROOT/components/com_seminarman/views/category/view.html.php:93
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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: 1.15 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.198 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #35  #37

    SELECT SUM(b.attendees) 
      FROM feb2016_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 766 
      AND (( b.status > -1 
      AND b.status < 3 ) OR ( b.status = 5 ))

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	b	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2648	0.20	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.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.88 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    logging slow query	0.03 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/components/com_seminarman/classes/helper.php:1386
    12	SMANFunctions::setCourseStatus()	JROOT/components/com_seminarman/classes/helper.php:1049
    11	SMANFunctions::setCourse()	JROOT/components/com_seminarman/views/category/view.html.php:93
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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: 1.09 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.205 MB Zeilen zurückgegeben: 1
    Doppelte Abfragen: #35  #36

    SELECT SUM(b.attendees) 
      FROM feb2016_seminarman_application AS b 
      WHERE b.published = 1 
      AND b.course_id = 766 
      AND (( b.status > -1 
      AND b.status < 3 ) OR ( b.status = 5 ))

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	b	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2648	0.20	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.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.89 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    logging slow query	0.02 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/components/com_seminarman/classes/helper.php:1388
    12	SMANFunctions::setCourseStatus()	JROOT/components/com_seminarman/classes/helper.php:1049
    11	SMANFunctions::setCourse()	JROOT/components/com_seminarman/views/category/view.html.php:93
    10	SeminarmanViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:37
    8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
    6	require_once JROOT/components/com_seminarman/seminarman.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.22 ms Nach letzter Abfrage: 0.39 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.213 MB Zeilen zurückgegeben: 0