Alle Leistungsklassen - Workshop Steppach 2025

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1731556596,
                "last": 1731556596,
                "now": 1731556596
            },
            "token": "W2CkglEGQ8zJkwcZsuaqSHcy4uyXY4aD"
        },
        "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
        },
        "com_mailto": {
            "links": {
                "9f3266a2a8c6f473e1eda6b1ff91b8745869c829": {
                    "link": "https://agilitypark.eu/index.php/kurse-und-training/kalender/5-alle-leistungsklassen/67-workshop-steppach2025",
                    "expiry": 1731556596
                }
            }
        }
    },
    "__seminarman": {
        "hit": [
            "67"
        ]
    }
}

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	agip_session	const	PRIMARY	PRIMARY	194	const	1

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

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

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

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

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init for update	0.02 ms
Update	0.04 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.09 ms
Writing to binlog	0.02 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 0.99 ms Nach letzter Abfrage: 2.17 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.449 MB Zeilen zurückgegeben: 5

SELECT id, rules

  FROM `agip_viewlevels`

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.09 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 1.03 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.463 MB Zeilen zurückgegeben: 2

SELECT b.id

  FROM agip_usergroups AS a

  LEFT JOIN agip_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 1.06 ms Nach letzter Abfrage: 233.24 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 4.665 MB

UPDATE `agip_extensions`

  SET `params` = '{\"mediaversion\":\"e03940f5ac87ff59e6f898f91f77655e\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.08 ms
checking permissions	0.03 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init for update	0.05 ms
Updating	0.04 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.08 ms
Writing to binlog	0.01 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 5.40 ms Nach letzter Abfrage: 173.84 ms Abfragespeichernutzung: 0.051 MB Speichernutzung vor Abfrage: 5.079 MB Zeilen zurückgegeben: 1

SELECT i.*,(i.plus / (i.plus + i.minus) ) * 100 AS votes,c.access AS cataccess,c.id AS catid,c.published AS catpublished,c.title AS categorytitle,u.name AS author,CONCAT_WS(' ', emp.salutation, emp.other_title, emp.firstname, emp.lastname) AS tutor,emp.published AS tutor_published,gr.title AS cgroup,lev.title AS level,
  CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug

  FROM agip_seminarman_courses AS i

  LEFT JOIN agip_seminarman_cats_course_relations AS rel 
  ON rel.courseid = i.id

  LEFT JOIN agip_seminarman_atgroup AS gr 
  ON gr.id = i.id_group

  LEFT JOIN agip_seminarman_experience_level AS lev 
  ON lev.id = i.id_experience_level

  LEFT JOIN agip_seminarman_tutor AS emp 
  ON emp.id = i.tutor_id

  LEFT JOIN agip_seminarman_categories AS c 
  ON c.id = rel.catid

  LEFT JOIN agip_users AS u 
  ON u.id = i.created_by

  WHERE i.id = 67 
  AND i.state >= 1 
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-11-14 03:56:36' ) 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-14 03:56:36' OR i.state = 2 )

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	rel	ref	itemid	itemid	4	const	1	Using index
1	SIMPLE	gr	eq_ref	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	lev	eq_ref	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	emp	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	HTO01FLQBWWG_3.rel.catid	1	Using where
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where

Profil (Profile)

Status	Duration
Starting	0.14 ms
checking permissions	0.03 ms
Opening tables	0.70 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.07 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
init	0.07 ms
Optimizing	0.03 ms
Statistics	0.13 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	0.08 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_seminarman/models/courses.php:223
14	SeminarmanModelCourses->_loadCourse()	JROOT/components/com_seminarman/models/courses.php:78
13	SeminarmanModelCourses->getCourse()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_seminarman/views/courses/view.html.php:62
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.86 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 5.117 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #11 #16

SELECT c.id,c.title,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM agip_seminarman_categories AS c

  LEFT JOIN agip_seminarman_cats_course_relations AS rel 
  ON rel.catid = c.id

  WHERE rel.courseid = 67 
  AND c.published = 1

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rel	ref	PRIMARY,catid,itemid	itemid	4	const	1	Using index
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	HTO01FLQBWWG_3.rel.catid	1	Using where

Profil (Profile)

Status	Duration
Starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_seminarman/models/courses.php:259
14	SeminarmanModelCourses->getCategories()	JROOT/components/com_seminarman/models/courses.php:82
13	SeminarmanModelCourses->getCourse()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_seminarman/views/courses/view.html.php:62
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.62 ms Nach letzter Abfrage: 1.88 ms Abfragespeichernutzung: 0.048 MB Speichernutzung vor Abfrage: 5.146 MB Zeilen zurückgegeben: 59

SHOW FULL COLUMNS 
  FROM `agip_seminarman_courses`

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.08 ms
checking permissions	0.04 ms
closing tables	0.04 ms
Opening tables	0.21 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
checking permissions	0.10 ms
closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.02 ms
Removing tmp table	0.07 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_seminarman/tables/seminarman_courses.php:28
16	seminarman_courses->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_seminarman/models/courses.php:353
14	SeminarmanModelCourses->hit()	JROOT/components/com_seminarman/models/courses.php:137
13	SeminarmanModelCourses->getCourse()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_seminarman/views/courses/view.html.php:62
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.70 ms Nach letzter Abfrage: 0.62 ms Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 5.281 MB

UPDATE agip_seminarman_courses

  SET `hits` = (`hits` + 1)

  WHERE `id` = '67'

Erklären

„EXPLAIN“ unmöglich für Abfrage: UPDATE agip_seminarman_courses SET `hits` = (`hits` + 1) WHERE `id` = '67'

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init for update	0.04 ms
Updating	0.05 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.09 ms
Writing to binlog	0.02 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
15	Joomla\CMS\Table\Table->hit()	JROOT/components/com_seminarman/models/courses.php:354
14	SeminarmanModelCourses->hit()	JROOT/components/com_seminarman/models/courses.php:137
13	SeminarmanModelCourses->getCourse()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_seminarman/views/courses/view.html.php:62
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.88 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 5.296 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #8 #16

SELECT c.id,c.title,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM agip_seminarman_categories AS c

  LEFT JOIN agip_seminarman_cats_course_relations AS rel 
  ON rel.catid = c.id

  WHERE rel.courseid = 67 
  AND c.published = 1

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rel	ref	PRIMARY,catid,itemid	itemid	4	const	1	Using index
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	HTO01FLQBWWG_3.rel.catid	1	Using where

Profil (Profile)

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_seminarman/models/courses.php:259
13	SeminarmanModelCourses->getCategories()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_seminarman/views/courses/view.html.php:66
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.10 ms Nach letzter Abfrage: 0.85 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 5.320 MB Zeilen zurückgegeben: 0

SELECT DISTINCT t.name, 
  CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug

  FROM agip_seminarman_tags AS t

  LEFT JOIN agip_seminarman_tags_course_relations AS i 
  ON i.tid = t.id

  WHERE i.courseid = 67 
  AND t.published = 1

  ORDER BY t.name

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref	PRIMARY,tid,itemid	itemid	4	const	1	Using index; Using temporary; filesort wurde genutzt
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	HTO01FLQBWWG_3.i.tid	1	Using where

Profil (Profile)

Status	Duration
Starting	0.16 ms
checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.02 ms
Removing tmp table	0.02 ms
Creating sort index	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_seminarman/classes/helper.php:1608
13	SMANFunctions::getCourseTags()	JROOT/components/com_seminarman/classes/helper.php:1027
12	SMANFunctions::setCourse()	JROOT/components/com_seminarman/views/courses/view.html.php:67
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.28 ms Nach letzter Abfrage: 23.74 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 5.468 MB Zeilen zurückgegeben: 1

SELECT SUM(b.attendees)

  FROM agip_seminarman_application AS b

  WHERE b.published = 1 
  AND b.course_id = 67 
  AND (( b.status > -1 
  AND b.status < 3 ) OR ( b.status = 5 ))

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.42 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_seminarman/classes/helper.php:1379
13	SMANFunctions::setCourseStatus()	JROOT/components/com_seminarman/classes/helper.php:1049
12	SMANFunctions::setCourse()	JROOT/components/com_seminarman/views/courses/view.html.php:67
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.45 ms Nach letzter Abfrage: 2.02 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 5.494 MB Zeilen zurückgegeben: 0

SELECT *

  FROM agip_seminarman_sessions

  WHERE published = 1 
  AND courseid = 67

  ORDER BY session_date, start_time, ordering

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	agip_seminarman_sessions	ref	courseid	courseid	5	const,const	1	Using where; filesort wurde genutzt

Profil (Profile)

Status	Duration
Starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.23 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.09 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_seminarman/classes/helper.php:1290
12	SMANFunctions::setCourse()	JROOT/components/com_seminarman/views/courses/view.html.php:67
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.85 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 5.515 MB Zeilen zurückgegeben: 0

SELECT DISTINCT t.name,
  CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug

  FROM agip_seminarman_tags AS t

  LEFT JOIN agip_seminarman_tags_course_relations AS i 
  ON i.tid = t.id

  WHERE i.courseid = 67 
  AND t.published = 1

  ORDER BY t.name

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref	PRIMARY,tid,itemid	itemid	4	const	1	Using index; Using temporary; filesort wurde genutzt
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	HTO01FLQBWWG_3.i.tid	1	Using where

Profil (Profile)

Status	Duration
Starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.02 ms
Removing tmp table	0.02 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_seminarman/models/courses.php:242
13	SeminarmanModelCourses->getTags()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_seminarman/views/courses/view.html.php:78
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.79 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 5.536 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #8 #11

SELECT c.id,c.title,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM agip_seminarman_categories AS c

  LEFT JOIN agip_seminarman_cats_course_relations AS rel 
  ON rel.catid = c.id

  WHERE rel.courseid = 67 
  AND c.published = 1

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rel	ref	PRIMARY,catid,itemid	itemid	4	const	1	Using index
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	HTO01FLQBWWG_3.rel.catid	1	Using where

Profil (Profile)

Status	Duration
Starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_seminarman/models/courses.php:259
13	SeminarmanModelCourses->getCategories()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_seminarman/views/courses/view.html.php:81
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.23 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 5.559 MB Zeilen zurückgegeben: 1

SELECT COUNT(id) AS favs

  FROM `agip_seminarman_favourites`

  WHERE courseid = 67

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	agip_seminarman_favourites	ref	itemid	itemid	4	const	1	Using index

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.23 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_seminarman/models/courses.php:678
13	SeminarmanModelCourses->getFavourites()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_seminarman/views/courses/view.html.php:84
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.83 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 5.581 MB Zeilen zurückgegeben: 1

SELECT COUNT(id) AS fav

  FROM `agip_seminarman_favourites`

  WHERE courseid = 67 
  AND userid= 0

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	agip_seminarman_favourites	ref	itemid,userid	itemid	4	const	1	Using where; Using index

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_seminarman/models/courses.php:694
13	SeminarmanModelCourses->getFavoured()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_seminarman/views/courses/view.html.php:85
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.34 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 5.603 MB Zeilen zurückgegeben: 0

SELECT DISTINCT rel.fileid,f.filename,f.altname

  FROM `agip_seminarman_files` AS f

  LEFT JOIN agip_seminarman_files_course_relations AS rel 
  ON rel.fileid = f.id

  WHERE rel.courseid = 67

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rel	ref	PRIMARY,fileid,itemid	itemid	4	const	1	Using index; Using temporary
1	SIMPLE	f	eq_ref	PRIMARY	PRIMARY	4	HTO01FLQBWWG_3.rel.fileid	1

Profil (Profile)

Status	Duration
Starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.35 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Creating tmp table	0.03 ms
Executing	0.01 ms
Sending data	0.08 ms
Removing tmp table	0.02 ms
Sending data	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_seminarman/models/courses.php:710
13	SeminarmanModelCourses->getFiles()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_seminarman/views/courses/view.html.php:88
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.95 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 5.624 MB Zeilen zurückgegeben: 1

SELECT parent_id

  FROM agip_seminarman_categories

  WHERE id = 5

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	agip_seminarman_categories	const	PRIMARY	PRIMARY	4	const	1

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/components/com_seminarman/classes/categories.php:67
13	seminarman_cats->buildParentCats()	JROOT/components/com_seminarman/classes/categories.php:35
12	seminarman_cats->__construct()	JROOT/components/com_seminarman/views/courses/view.html.php:95
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.20 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 5.645 MB Zeilen zurückgegeben: 1

SELECT id, title, 
  CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as categoryslug

  FROM agip_seminarman_categories

  WHERE id =5 
  AND published = 1

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	agip_seminarman_categories	const	PRIMARY	PRIMARY	4	const	1

Profil (Profile)

Status	Duration
Starting	0.11 ms
checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.03 ms
table lock	0.04 ms
init	0.07 ms
Optimizing	0.06 ms
Statistics	0.07 ms
Preparing	0.04 ms
Unlocking tables	0.04 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_seminarman/classes/categories.php:54
13	seminarman_cats->getParentCats()	JROOT/components/com_seminarman/classes/categories.php:36
12	seminarman_cats->__construct()	JROOT/components/com_seminarman/views/courses/view.html.php:95
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.79 ms Nach letzter Abfrage: 5.09 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 5.800 MB Zeilen zurückgegeben: 26

SELECT f.*,v.value

  FROM `agip_seminarman_fields` AS f

  LEFT JOIN `agip_seminarman_fields_values` AS v 
  ON f.id = v.field_id 
  AND v.applicationid = 0

  WHERE f.published=1 
  AND f.visible=1

  ORDER BY f.ordering

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.11 ms
checking permissions	0.04 ms
Opening tables	0.52 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.15 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
13	JDatabaseDriver->loadAssocList()	JROOT/components/com_seminarman/models/courses.php:840
12	SeminarmanModelCourses->getEditableCustomfields()	JROOT/components/com_seminarman/views/courses/view.html.php:199
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.60 ms Nach letzter Abfrage: 2.17 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 5.885 MB Zeilen zurückgegeben: 1

SELECT CONCAT_WS(' ', emp.salutation, emp.other_title, emp.firstname, emp.lastname) AS tutor_display,emp.published AS tutor_published

  FROM agip_seminarman_tutor AS emp

  WHERE emp.id = 24

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	emp	const	PRIMARY	PRIMARY	4	const	1

Profil (Profile)

Status	Duration
Starting	0.14 ms
checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.04 ms
table lock	0.04 ms
init	0.07 ms
Optimizing	0.05 ms
Statistics	0.09 ms
Preparing	0.04 ms
Unlocking tables	0.04 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.05 ms
End of update loop	0.04 ms
Query end	0.03 ms
Commit	0.04 ms
closing tables	0.04 ms
Unlocking tables	0.04 ms
closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.06 ms
Reset for next command	0.04 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/components/com_seminarman/views/courses/view.html.php:225
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.93 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 5.905 MB Zeilen zurückgegeben: 1

SELECT CONCAT_WS(' ', emp.salutation, emp.other_title, emp.firstname, emp.lastname) AS tutor_display,emp.published AS tutor_published

  FROM agip_seminarman_tutor AS emp

  WHERE emp.id = 2

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	emp	const	PRIMARY	PRIMARY	4	const	1

Profil (Profile)

Status	Duration
Starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/components/com_seminarman/views/courses/view.html.php:225
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.84 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 5.924 MB Zeilen zurückgegeben: 1

SELECT CONCAT_WS(' ', emp.salutation, emp.other_title, emp.firstname, emp.lastname) AS tutor_display,emp.published AS tutor_published

  FROM agip_seminarman_tutor AS emp

  WHERE emp.id = 27

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	emp	const	PRIMARY	PRIMARY	4	const	1

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/components/com_seminarman/views/courses/view.html.php:225
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.84 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 5.943 MB Zeilen zurückgegeben: 1

SELECT CONCAT_WS(' ', emp.salutation, emp.other_title, emp.firstname, emp.lastname) AS tutor_display,emp.published AS tutor_published

  FROM agip_seminarman_tutor AS emp

  WHERE emp.id = 22

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	emp	const	PRIMARY	PRIMARY	4	const	1

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/components/com_seminarman/views/courses/view.html.php:225
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.78 ms Nach letzter Abfrage: 14.44 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 6.253 MB Zeilen zurückgegeben: 7

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM agip_modules AS m

  LEFT JOIN agip_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN agip_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-14 03:56:36') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-14 03:56:36') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 109 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.44 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.17 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	Derselbe Aufruf in der Zeile darunter.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
18	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
17	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:37
16	Joomla\CMS\Helper\ModuleHelper::getModule()	JROOT/components/com_seminarman/views/courses/tmpl/default_loadappform.php:24
15	include JROOT/components/com_seminarman/views/courses/tmpl/default_loadappform.php	JROOT/components/com_seminarman/views/courses/tmpl/default.php:442
14	include JROOT/components/com_seminarman/views/courses/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_seminarman/views/courses/view.html.php:252
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.06 ms Nach letzter Abfrage: 10.11 ms Abfragespeichernutzung: 0.053 MB Speichernutzung vor Abfrage: 6.363 MB Zeilen zurückgegeben: 1

SELECT *

  FROM agip_seminarman_courses

  WHERE id = 67

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	agip_seminarman_courses	const	PRIMARY	PRIMARY	4	const	1

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.11 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_seminarman/helpers/seminarman.php:1464
18	JHTMLSeminarman::get_price_view()	JROOT/components/com_seminarman/views/courses/tmpl/default_applicationform.php:9
17	include JROOT/components/com_seminarman/views/courses/tmpl/default_applicationform.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_seminarman/views/courses/tmpl/default_loadappform.php:31
15	include JROOT/components/com_seminarman/views/courses/tmpl/default_loadappform.php	JROOT/components/com_seminarman/views/courses/tmpl/default.php:442
14	include JROOT/components/com_seminarman/views/courses/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_seminarman/views/courses/view.html.php:252
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.19 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 6.410 MB Zeilen zurückgegeben: 1

SELECT *

  FROM agip_seminarman_pricegroups

  WHERE gid=2

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.25 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.10 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
20	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_seminarman/helpers/seminarman.php:1540
19	JHTMLSeminarman::_get_price_display()	JROOT/administrator/components/com_seminarman/helpers/seminarman.php:1509
18	JHTMLSeminarman::get_price_view()	JROOT/components/com_seminarman/views/courses/tmpl/default_applicationform.php:9
17	include JROOT/components/com_seminarman/views/courses/tmpl/default_applicationform.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_seminarman/views/courses/tmpl/default_loadappform.php:31
15	include JROOT/components/com_seminarman/views/courses/tmpl/default_loadappform.php	JROOT/components/com_seminarman/views/courses/tmpl/default.php:442
14	include JROOT/components/com_seminarman/views/courses/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_seminarman/views/courses/view.html.php:252
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.79 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 6.440 MB Zeilen zurückgegeben: 1

SELECT *

  FROM agip_seminarman_pricegroups

  WHERE gid=3

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.03 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.04 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
20	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_seminarman/helpers/seminarman.php:1540
19	JHTMLSeminarman::_get_price_display()	JROOT/administrator/components/com_seminarman/helpers/seminarman.php:1509
18	JHTMLSeminarman::get_price_view()	JROOT/components/com_seminarman/views/courses/tmpl/default_applicationform.php:9
17	include JROOT/components/com_seminarman/views/courses/tmpl/default_applicationform.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_seminarman/views/courses/tmpl/default_loadappform.php:31
15	include JROOT/components/com_seminarman/views/courses/tmpl/default_loadappform.php	JROOT/components/com_seminarman/views/courses/tmpl/default.php:442
14	include JROOT/components/com_seminarman/views/courses/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_seminarman/views/courses/view.html.php:252
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.74 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 6.470 MB Zeilen zurückgegeben: 1

SELECT *

  FROM agip_seminarman_pricegroups

  WHERE gid=4

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.03 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
20	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_seminarman/helpers/seminarman.php:1540
19	JHTMLSeminarman::_get_price_display()	JROOT/administrator/components/com_seminarman/helpers/seminarman.php:1509
18	JHTMLSeminarman::get_price_view()	JROOT/components/com_seminarman/views/courses/tmpl/default_applicationform.php:9
17	include JROOT/components/com_seminarman/views/courses/tmpl/default_applicationform.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_seminarman/views/courses/tmpl/default_loadappform.php:31
15	include JROOT/components/com_seminarman/views/courses/tmpl/default_loadappform.php	JROOT/components/com_seminarman/views/courses/tmpl/default.php:442
14	include JROOT/components/com_seminarman/views/courses/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_seminarman/views/courses/view.html.php:252
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.72 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 6.501 MB Zeilen zurückgegeben: 1

SELECT *

  FROM agip_seminarman_pricegroups

  WHERE gid=5

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.03 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
20	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_seminarman/helpers/seminarman.php:1540
19	JHTMLSeminarman::_get_price_display()	JROOT/administrator/components/com_seminarman/helpers/seminarman.php:1509
18	JHTMLSeminarman::get_price_view()	JROOT/components/com_seminarman/views/courses/tmpl/default_applicationform.php:9
17	include JROOT/components/com_seminarman/views/courses/tmpl/default_applicationform.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_seminarman/views/courses/tmpl/default_loadappform.php:31
15	include JROOT/components/com_seminarman/views/courses/tmpl/default_loadappform.php	JROOT/components/com_seminarman/views/courses/tmpl/default.php:442
14	include JROOT/components/com_seminarman/views/courses/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_seminarman/views/courses/view.html.php:252
11	SeminarmanViewCourses->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:232
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT-Tabellen:

4 × SELECT * 
  FROM agip_seminarman_pricegroups

4 × SELECT CONCAT_WS(' ', emp.salutation, emp.other_title, emp.firstname, emp.lastname) AS tutor_display,emp.published AS tutor_published 
  FROM agip_seminarman_tutor AS emp

3 × SELECT c.id,c.title,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM agip_seminarman_categories AS c 
  LEFT JOIN agip_seminarman_cats_course_relations AS rel 
  ON rel.catid = c.id

1 × SELECT COUNT(id) AS fav 
  FROM `agip_seminarman_favourites`

1 × SELECT * 
  FROM agip_seminarman_courses

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

1 × SELECT f.*,v.value 
  FROM `agip_seminarman_fields` AS f 
  LEFT JOIN `agip_seminarman_fields_values` AS v 
  ON f.id = v.field_id 
  AND v.applicationid = 0

1 × SELECT id, title, 
  CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as categoryslug 
  FROM agip_seminarman_categories

1 × SELECT parent_id 
  FROM agip_seminarman_categories

1 × SELECT DISTINCT rel.fileid,f.filename,f.altname 
  FROM `agip_seminarman_files` AS f 
  LEFT JOIN agip_seminarman_files_course_relations AS rel 
  ON rel.fileid = f.id

1 × SELECT `data` 
  FROM `agip_session`

1 × SELECT `session_id` 
  FROM `agip_session`

1 × SELECT DISTINCT t.name,
  CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug 
  FROM agip_seminarman_tags AS t 
  LEFT JOIN agip_seminarman_tags_course_relations AS i 
  ON i.tid = t.id

1 × SELECT * 
  FROM agip_seminarman_sessions

1 × SELECT SUM(b.attendees) 
  FROM agip_seminarman_application AS b

1 × SELECT DISTINCT t.name, 
  CASE WHEN CHAR_LENGTH(t.alias) THEN CONCAT_WS(':', t.id, t.alias) ELSE t.id END as slug 
  FROM agip_seminarman_tags AS t 
  LEFT JOIN agip_seminarman_tags_course_relations AS i 
  ON i.tid = t.id

1 × SELECT i.*,(i.plus / (i.plus + i.minus) ) * 100 AS votes,c.access AS cataccess,c.id AS catid,c.published AS catpublished,c.title AS categorytitle,u.name AS author,CONCAT_WS(' ', emp.salutation, emp.other_title, emp.firstname, emp.lastname) AS tutor,emp.published AS tutor_published,gr.title AS cgroup,lev.title AS level,
  CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as categoryslug 
  FROM agip_seminarman_courses AS i 
  LEFT JOIN agip_seminarman_cats_course_relations AS rel 
  ON rel.courseid = i.id 
  LEFT JOIN agip_seminarman_atgroup AS gr 
  ON gr.id = i.id_group 
  LEFT JOIN agip_seminarman_experience_level AS lev 
  ON lev.id = i.id_experience_level 
  LEFT JOIN agip_seminarman_tutor AS emp 
  ON emp.id = i.tutor_id 
  LEFT JOIN agip_seminarman_categories AS c 
  ON c.id = rel.catid 
  LEFT JOIN agip_users AS u 
  ON u.id = i.created_by

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

1 × SELECT id, rules 
  FROM `agip_viewlevels

1 × SELECT COUNT(id) AS favs 
  FROM `agip_seminarman_favourites`

Andere Tabellen:

1 × INSERT INTO `agip_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'323475376565756f6d32393833756a346f6e61376b6237756336', 1, 1731556596, 0, '', 0

1 × UPDATE `agip_extensions` 
  SET `params` = '{\"mediaversion\":\"e03940f5ac87ff59e6f898f91f77655e\"}'

1 × SHOW FULL COLUMNS 
  FROM `agip_seminarman_courses

1 × UPDATE agip_seminarman_courses 
  SET `hits` = (`hits` + 1)

Einzelpreis
Buchungspreis*	300,00 EUR
Teilnehmerdaten
Anrede*
Titel
Vorname*
Nachname*
E-Mail Adresse*
E-Mail Adresse bestätigen*
Rechnungsadresse
Firma/Organisation
Strasse*
PLZ*
Ort*
Land*
Telefon*

Hundedaten
Hundename*
Rasse*
Größe*
Leistungsklasse*
Haftpflichtversicherung?*
Tollwutimpfung?*
Persönliches
Beruf
Geburtstag
Homepage
	* notwendige Angaben

Workshop Steppach 2025

Workshop Steppach 2025

Beschreibung

Diesen Kurs buchen: Workshop Steppach 2025

Wenn Sie bereits registriert sind, bitte hier direkt einloggen

Einzelpreis

Teilnehmerdaten

Rechnungsadresse

Hundedaten

Persönliches

Kategorie

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

32 ausgeführte Abfragen 39.39 ms

3 Duplikate gefunden!

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

SELECT-Tabellen:

Andere Tabellen:

Protokollnachrichten

0 Nachrichten protokolliert