WBT/Online-Schulungen - Sensibilisierung Unternehmenssicherheit

Wie funktioniert das hier?

1Buchen Sie einen Kurs.

2Sie erhalten eine Buchungsbestätigung und Ihre Zugangsdaten bei Onlinekursen.

3Nach Erhalt der Zahlung wird der Kurs freigeschaltet

Falls Sie immer noch Probleme haben, so senden Sie uns bitte ein E-Mail an seminare [ @ ] fr8solutions.com. Danke!

Wann erreichen Sie uns?

Mon-Fri 8:30 - 17:00

Telefon: 089 124138 540
E-Mail: seminare [@] fr8solutions.com

FR8 solutions GmbH, Ihr führender Anbieter im Bereich Luftsicherheitsschulungen Wir freuen uns auf Ihren Anruf!

So können Sie uns erreichen:

Tel: 089 124138 540
Email: seminare@fr8solutions.com

FR8 solutions GmbH
Industriestr. 39, 82194 Gröbenzell
(bei München)

In Google Maps öffnen

AnfrageInhouse

Startseite
WBT/Online
tabellarisch

Donnerstag Mai 26th, 2022

Sensibilisierung Unternehmenssicherheit

Beginn:: 1. Jan 2022
Ende:: 31. Dez 2030
Kurs-Nr.:: WBT-SU

Preis:: 24,50 EUR pro Platz (zzgl. MwSt.)
Ort:: ONLINE

Diesen Kurs buchen

Beschreibung

Sensibilisierung Unternehmenssicherheit

Diese Schulung führen Sie online an Ihrem PC durch. Die Zugangsdaten erhalten Sie von uns.

Das ist keine Schulung nach Vorgaben des LBA. Die Schulung soll vielmehr die Anforderungen aus dem Anhang zur DVO (EU) 2019/103 Nr. 26 und 28 ff. erfüllen, der alle Beteiligten der sicheren Lieferkette (Luftsicherheit) verpflichtet eine "Sicherheitskultur" im Unternehmen aufzubauen und die Mitarbeiter regelmäßig zu sensibilisieren. Regelmäßig ist nicht definiert, ist aber in Anlehnung an andere Schulungen mit mindestens jährlich zu interpretieren. Weitere Informationen zum Thema "Sicherheitskultur" finden Sie hier Sicherheitskultur Basics

Für wen ist diese Schulung gedacht?

Diese Schulung soll ein allgemeines Sicherheitsbewusstsein bei allen Mitarbeitern schaffen. Es werden Hintergründe erläutert und allgemeine Tipps gegeben, die jeder anwenden kann. Einige Informationen werden dem ein oder anderen bekannt sein. Für andere ist es Neuland. Sinn ist das Bewusstsein (erneut) zu schärfen.
Diese Schulung hat nicht den Zweck Spezialwissen aus der IT oder Sabotageabwehr zu vermitteln. Die Unternehmen haben hier i.d.R. hervorragende Spezialisten, die wissen, was zu tun ist. Es geht hier vielmehr darum den Faktor „Mensch“ als Gefahren- oder Fehlerquelle zu identifizieren und die Mitarbeiter diesbezüglich zu sensibilisieren.

Mitarbeiter im Bereich der sicheren LIeferkette regelmäßig zu

Beteiligte der sicheren Lieferkette sind z.B.:

bekannter Versender (bV)
reglementierter Beauftragter (regB)
Dienstleister für bV oder regB
zugelassenen Transporteur (zT)
reglementierte Lieferanten (Cateringunternehmen von Bordvorräten oder Flughafenlieferungen)
bekannte Lieferanten (Zulieferer des Cateringunternehmens)

Seminarinhalte:
Sicherheitskultur im Unternehmen, Sensibilisierung Mitarbeiter, Förderung der Sicherheitskultur, Insider, Radikalisierung, Industriespionage, Sabotage, Cyberkriminalität, Diebstahl, Korruption, Terroranschläge.

Dauer: ca. 30 Min inkl. Lernerfolgskontrolle

Jeder Teilnehmer erhält ein Teilnahmezertifikat.

Anfragen an: seminare@fr8solutions.com.

Sie möchten mehrere Teilnehmer auf einmal anmelden? Laden Sie zusätzlich unsere Vorlage herunter und senden bitte die Liste im Excel-Format. an: seminare@fr8solutions.com.

Der im Buchungsformular angezeigte Preis ist pro Teilnehmer bis zur Preisstaffel für 5 Teilnehmer. Darüber gilt folgende Preisstaffel:

24,50 € / pro Teilnehmer (bis 5 TN)
22,50 € / pro Teilnehmer (bis 10 TN)
20,00 € / pro Teilnehmer (bis 25 TN)
17,50 € / pro Teilnehmer (bis 50 TN)
15,00 € / pro Teilnehmer (bis 100 TN)
12,50 € / pro Teilnehmer (bis 150 TN)
10,00 € / pro Teilnehmer (bis 200 TN)
über 200 Teilnehmer - bitte Angebot anfordern

Bitte geben Sie im Buchungsformular im Feld "Kommentare" an, für wie viele Teilnehmer Sie eine Buchung wünschen.

Diesen Kurs buchen: Sensibilisierung Unternehmenssicherheit

Einzelpreis
Buchungspreis*	Netto: 24,50 EUR, Brutto inkl. MwSt.: 29,16 EUR
Teilnehmerdaten
Anrede*
Titel
Vorname*
Nachname*
E-Mail Adresse*
E-Mail Adresse bestätigen*
Rechnungsadresse
Firma*
Strasse*
PLZ*
Ort*
Land*
Telefon*
	Ich akzeptiere die Allgemeinen Geschäftsbedingungen *
Kommentare / E-Mail Bestätigung
Geburtsdatum*
Ihr Text:
Wie haben Sie von uns erfahren?
Über:	IHK VeranstaltungGoogleEmpfehlungSonstiges
	* notwendige Angaben

Kategorie

TOP

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1653531582,
                "last": 1653531582,
                "now": 1653531582
            },
            "token": "vNCQ3ug5fybDnMTIETljlRke841Xdyqq"
        },
        "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
        }
    },
    "__seminarman": {
        "hit": [
            "1045"
        ]
    }
}

Profil zum Laufzeitverhalten

Speichernutzung

Datenbankabfragen

38 ausgeführte Abfragen 17.57 ms

10 Duplikate gefunden!

3 Duplikate: #8 #12 #18

3 Duplikate: #14 #15 #16

2 Duplikate: #20 #21

2 Duplikate: #22 #23

Abfragezeit: 0.30 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.398 MB Zeilen zurückgegeben: 0

SELECT `data`

  FROM `feb2016_session`

  WHERE `session_id` = 'teeu3p1dtjp8htmslt4v5mip6v'

Explain

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

Profil (Profile)

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

Call Stack

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

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

Abfragezeit: 0.20 ms Nach letzter Abfrage: 0.36 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.624 MB Zeilen zurückgegeben: 0

SELECT `session_id`

  FROM `feb2016_session`

  WHERE `session_id` = 'teeu3p1dtjp8htmslt4v5mip6v' 
  LIMIT 1

Explain

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

Profil (Profile)

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

Call Stack

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

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

Abfragezeit: 0.87 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 4.630 MB

INSERT INTO `feb2016_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('teeu3p1dtjp8htmslt4v5mip6v', 1, 1653531582, 0, '', 0)

Explain

„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `feb2016_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('teeu3p1dtjp8htmslt4v5mip6v', 1, 1653531582, 0, '', 0)

Profil (Profile)

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

Call Stack

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

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

Abfragezeit: 0.35 ms Nach letzter Abfrage: 1.50 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 5.143 MB Zeilen zurückgegeben: 5

SELECT id, rules

  FROM `feb2016_viewlevels`

Explain

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

Profil (Profile)

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

Call Stack

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

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

Abfragezeit: 0.38 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 5.155 MB Zeilen zurückgegeben: 1

SELECT b.id

  FROM feb2016_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profil (Profile)

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

Call Stack

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

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

Abfragezeit: 0.90 ms Nach letzter Abfrage: 14.59 ms Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 9.490 MB

UPDATE `feb2016_extensions`

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

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

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
21	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
20	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
19	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
18	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
17	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/HTML/HTMLHelper.php:731
16	Joomla\CMS\HTML\HTMLHelper::script()	Derselbe Aufruf in der Zeile darunter.
15	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
14	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
13	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
12	JHtmlJquery::framework()	Derselbe Aufruf in der Zeile darunter.
11	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
10	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
9	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/jquery/jquery.php:22
8	plgSystemJquery->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.05 ms Nach letzter Abfrage: 3.91 ms Abfragespeichernutzung: 0.060 MB Speichernutzung vor Abfrage: 11.690 MB Zeilen zurückgegeben: 3

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 feb2016_seminarman_courses AS i 
  LEFT JOIN feb2016_seminarman_cats_course_relations AS rel 
  ON rel.courseid = i.id 
  LEFT JOIN feb2016_seminarman_atgroup AS gr 
  ON gr.id = i.id_group 
  LEFT JOIN feb2016_seminarman_experience_level AS lev 
  ON lev.id = i.id_experience_level 
  LEFT JOIN feb2016_seminarman_tutor AS emp 
  ON emp.id = i.tutor_id 
  LEFT JOIN feb2016_seminarman_categories AS c 
  ON c.id = rel.catid 
  LEFT JOIN feb2016_users AS u 
  ON u.id = i.created_by 
  WHERE i.id = 1045 
  AND i.state >= 1 
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2022-05-26 02:19:42' ) 
  AND (CONCAT_WS(' ', i.finish_date, i.finish_time) = '0000-00-00 00:00:00' OR CONCAT_WS(' ', i.finish_date, i.finish_time) >= '2022-05-26 02:19:42' OR i.state = 2)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	rel	NULL	ref	itemid	itemid	4	const	6	100.00	NULL
1	SIMPLE	gr	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	lev	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	emp	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	db260256_15.rel.catid	1	100.00	Using where
1	SIMPLE	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
15	JDatabaseDriver->loadObject()	JROOT/components/com_seminarman/models/courses.php:210
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.34 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.715 MB Zeilen zurückgegeben: 3

Doppelte Abfragen: #12 #18

SELECT DISTINCT c.id, c.title, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM feb2016_seminarman_categories AS c 
  LEFT JOIN feb2016_seminarman_cats_course_relations AS rel 
  ON rel.catid = c.id 
  WHERE rel.courseid = 1045 
  AND c.published = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rel	NULL	ref	PRIMARY,catid,itemid	itemid	4	const	6	100.00	Using where; Using temporary
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	db260256_15.rel.catid	1	10.00	Using index condition; Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_seminarman/models/courses.php:242
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.21 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.726 MB Zeilen zurückgegeben: 1

SELECT name 
  FROM feb2016_users 
  WHERE id = 793

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/components/com_seminarman/models/courses.php:113
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.88 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 11.738 MB Zeilen zurückgegeben: 58

SHOW FULL COLUMNS 
  FROM `feb2016_seminarman_courses`

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_seminarman/tables/seminarman_courses.php:28
16	seminarman_courses->seminarman_courses()	JROOT/libraries/src/Table/Table.php:312
15	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_seminarman/models/courses.php:325
14	SeminarmanModelCourses->hit()	JROOT/components/com_seminarman/models/courses.php:131
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.24 ms Nach letzter Abfrage: 0.28 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 11.813 MB

UPDATE feb2016_seminarman_courses

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

  WHERE `id` = '1045'

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
15	Joomla\CMS\Table\Table->hit()	JROOT/components/com_seminarman/models/courses.php:326
14	SeminarmanModelCourses->hit()	JROOT/components/com_seminarman/models/courses.php:131
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.32 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.818 MB Zeilen zurückgegeben: 3

Doppelte Abfragen: #8 #18

SELECT DISTINCT c.id, c.title, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM feb2016_seminarman_categories AS c 
  LEFT JOIN feb2016_seminarman_cats_course_relations AS rel 
  ON rel.catid = c.id 
  WHERE rel.courseid = 1045 
  AND c.published = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rel	NULL	ref	PRIMARY,catid,itemid	itemid	4	const	6	100.00	Using where; Using temporary
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	db260256_15.rel.catid	1	10.00	Using index condition; Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_seminarman/models/courses.php:242
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.49 ms Nach letzter Abfrage: 0.25 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.827 MB Zeilen zurückgegeben: 6

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	NULL	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	28	10.00	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	i	NULL	eq_ref	PRIMARY,tid,itemid	PRIMARY	8	db260256_15.t.id,const	1	100.00	Using index; Distinct

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_seminarman/classes/helper.php:1568
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.23 ms Nach letzter Abfrage: 0.37 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.850 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #15 #16

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

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/components/com_seminarman/classes/helper.php:1384
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.10 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.857 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #14 #16

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

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/components/com_seminarman/classes/helper.php:1386
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.09 ms Nach letzter Abfrage: 0.02 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.864 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #14 #15

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

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/components/com_seminarman/classes/helper.php:1388
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.27 ms Nach letzter Abfrage: 0.34 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.876 MB Zeilen zurückgegeben: 0

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

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_seminarman/classes/helper.php:1287
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.30 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.884 MB Zeilen zurückgegeben: 3

Doppelte Abfragen: #8 #12

SELECT DISTINCT c.id, c.title, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM feb2016_seminarman_categories AS c 
  LEFT JOIN feb2016_seminarman_cats_course_relations AS rel 
  ON rel.catid = c.id 
  WHERE rel.courseid = 1045 
  AND c.published = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	rel	NULL	ref	PRIMARY,catid,itemid	itemid	4	const	6	100.00	Using where; Using temporary
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	db260256_15.rel.catid	1	10.00	Using index condition; Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_seminarman/models/courses.php:242
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.36 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.893 MB Zeilen zurückgegeben: 0

SELECT DISTINCT rel.fileid, f.filename, f.altname 
  FROM feb2016_seminarman_files AS f 
  LEFT JOIN feb2016_seminarman_files_course_relations AS rel 
  ON rel.fileid = f.id 
  WHERE rel.courseid = 1045

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_seminarman/models/courses.php:625
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.19 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.900 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #21

SELECT parent_id 
  FROM feb2016_seminarman_categories 
  WHERE id = 44

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/components/com_seminarman/classes/categories.php:68
13	seminarman_cats->buildParentCats()	JROOT/components/com_seminarman/classes/categories.php: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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.18 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.907 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #20

SELECT parent_id 
  FROM feb2016_seminarman_categories 
  WHERE id = 44

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/components/com_seminarman/classes/categories.php:70
13	seminarman_cats->buildParentCats()	JROOT/components/com_seminarman/classes/categories.php: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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.18 ms Nach letzter Abfrage: 0.02 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.914 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #23

SELECT parent_id 
  FROM feb2016_seminarman_categories 
  WHERE id = 2

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/components/com_seminarman/classes/categories.php:68
14	seminarman_cats->buildParentCats()	JROOT/components/com_seminarman/classes/categories.php:70
13	seminarman_cats->buildParentCats()	JROOT/components/com_seminarman/classes/categories.php: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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.18 ms Nach letzter Abfrage: 0.02 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.921 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #22

SELECT parent_id 
  FROM feb2016_seminarman_categories 
  WHERE id = 2

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/components/com_seminarman/classes/categories.php:70
14	seminarman_cats->buildParentCats()	JROOT/components/com_seminarman/classes/categories.php:70
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.19 ms Nach letzter Abfrage: 0.02 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 11.928 MB Zeilen zurückgegeben: 0

SELECT parent_id 
  FROM feb2016_seminarman_categories 
  WHERE id = 0

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
16	JDatabaseDriver->loadResult()	JROOT/components/com_seminarman/classes/categories.php:68
15	seminarman_cats->buildParentCats()	JROOT/components/com_seminarman/classes/categories.php:70
14	seminarman_cats->buildParentCats()	JROOT/components/com_seminarman/classes/categories.php:70
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.21 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.937 MB Zeilen zurückgegeben: 1

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

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
14	JDatabaseDriver->loadObject()	JROOT/components/com_seminarman/classes/categories.php:52
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.20 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 11.944 MB Zeilen zurückgegeben: 1

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

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
14	JDatabaseDriver->loadObject()	JROOT/components/com_seminarman/classes/categories.php:52
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.71 ms Nach letzter Abfrage: 2.14 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 12.321 MB Zeilen zurückgegeben: 0

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `feb2016_categories` AS `s`

  INNER JOIN `feb2016_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 44

  ORDER BY c.lft

Explain

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

Profil (Profile)

Status	Duration
starting	0.20 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.12 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
28	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
27	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
26	ContentRouter->getCategorySegment()	Derselbe Aufruf in der Zeile darunter.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
18	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
17	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/jw_disqus/jw_disqus.php:185
16	plgContentJw_disqus->renderDisqus()	JROOT/plugins/content/jw_disqus/jw_disqus.php:41
15	plgContentJw_disqus->onPrepareContent()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_seminarman/views/courses/view.html.php:185
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.53 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 12.326 MB Zeilen zurückgegeben: 14

SELECT f.*, v.value 
  FROM `feb2016_seminarman_fields` AS f 
  LEFT JOIN `feb2016_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

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
13	JDatabaseDriver->loadAssocList()	JROOT/components/com_seminarman/models/courses.php:725
12	SeminarmanModelCourses->getEditableCustomfields()	JROOT/components/com_seminarman/views/courses/view.html.php:189
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.23 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.352 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 feb2016_seminarman_tutor AS emp 
  WHERE emp.id = 8

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
12	JDatabaseDriver->loadAssoc()	JROOT/components/com_seminarman/views/courses/view.html.php:210
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.70 ms Nach letzter Abfrage: 1.58 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 12.737 MB Zeilen zurückgegeben: 12

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

  FROM feb2016_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2022-05-26 02:19:42') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-05-26 02:19:42') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 454 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	121	1.60	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	db260256_15.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	db260256_15.m.id	4	40.00	Using where; Using index

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
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:432
18	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
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:422
14	include JROOT/components/com_seminarman/views/courses/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
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:237
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.33 ms Nach letzter Abfrage: 0.28 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 13.077 MB Zeilen zurückgegeben: 1

SELECT *

  FROM feb2016_seminarman_courses

  WHERE id = 1045

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_seminarman/helpers/seminarman.php:1391
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:697
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:422
14	include JROOT/components/com_seminarman/views/courses/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
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:237
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.26 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 13.103 MB Zeilen zurückgegeben: 1

SELECT *

  FROM feb2016_seminarman_pricegroups

  WHERE gid=2

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
20	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_seminarman/helpers/seminarman.php:1467
19	JHTMLSeminarman::_get_price_display()	JROOT/administrator/components/com_seminarman/helpers/seminarman.php:1436
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:697
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:422
14	include JROOT/components/com_seminarman/views/courses/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
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:237
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.20 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 13.120 MB Zeilen zurückgegeben: 1

SELECT *

  FROM feb2016_seminarman_pricegroups

  WHERE gid=3

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
20	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_seminarman/helpers/seminarman.php:1467
19	JHTMLSeminarman::_get_price_display()	JROOT/administrator/components/com_seminarman/helpers/seminarman.php:1436
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:697
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:422
14	include JROOT/components/com_seminarman/views/courses/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
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:237
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.22 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 13.132 MB Zeilen zurückgegeben: 1

SELECT *

  FROM feb2016_seminarman_pricegroups

  WHERE gid=4

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
20	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_seminarman/helpers/seminarman.php:1467
19	JHTMLSeminarman::_get_price_display()	JROOT/administrator/components/com_seminarman/helpers/seminarman.php:1436
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:697
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:422
14	include JROOT/components/com_seminarman/views/courses/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
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:237
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.20 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 13.143 MB Zeilen zurückgegeben: 1

SELECT *

  FROM feb2016_seminarman_pricegroups

  WHERE gid=5

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
20	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_seminarman/helpers/seminarman.php:1467
19	JHTMLSeminarman::_get_price_display()	JROOT/administrator/components/com_seminarman/helpers/seminarman.php:1436
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:697
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:422
14	include JROOT/components/com_seminarman/views/courses/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
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:237
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:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_seminarman/controller.php:39
8	SeminarmanController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_seminarman/seminarman.php:180
6	require_once JROOT/components/com_seminarman/seminarman.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.30 ms Nach letzter Abfrage: 5.71 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 13.900 MB Zeilen zurückgegeben: 1

SELECT *

  FROM `feb2016_extensions`

  WHERE `element` = 'com_gsd' 
  AND `type` = 'component'

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
19	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/nrframework/NRFramework/Extension.php:124
18	NRFramework\Extension::get()	JROOT/plugins/system/nrframework/NRFramework/Extension.php:176
17	NRFramework\Extension::isEnabled()	JROOT/plugins/system/nrframework/NRFramework/Extension.php:159
16	NRFramework\Extension::componentIsEnabled()	JROOT/plugins/system/gsd/gsd.php:484
15	plgSystemGSD->setup()	JROOT/plugins/system/gsd/gsd.php:527
14	plgSystemGSD->getHelper()	JROOT/plugins/system/gsd/gsd.php:65
13	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.47 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 13.916 MB Zeilen zurückgegeben: 2

SHOW FULL COLUMNS 
  FROM `feb2016_gsd_config`

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
19	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_gsd/tables/config.php:26
18	GSDTableConfig->__construct()	JROOT/libraries/src/Table/Table.php:312
17	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_gsd/GSD/Helper.php:412
16	GSD\Helper::getParams()	JROOT/plugins/system/gsd/gsd.php:496
15	plgSystemGSD->setup()	JROOT/plugins/system/gsd/gsd.php:527
14	plgSystemGSD->getHelper()	JROOT/plugins/system/gsd/gsd.php:65
13	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.20 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 13.932 MB Zeilen zurückgegeben: 0

SELECT *

  FROM feb2016_gsd_config

  WHERE `name` = 'config'

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
17	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_gsd/GSD/Helper.php:413
16	GSD\Helper::getParams()	JROOT/plugins/system/gsd/gsd.php:496
15	plgSystemGSD->setup()	JROOT/plugins/system/gsd/gsd.php:527
14	plgSystemGSD->getHelper()	JROOT/plugins/system/gsd/gsd.php:65
13	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT-Tabellen:

5 × SELECT parent_id 
  FROM feb2016_seminarman_categories

4 × SELECT * 
  FROM feb2016_seminarman_pricegroups

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

3 × SELECT SUM(b.attendees) 
  FROM feb2016_seminarman_application AS b

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

1 × SELECT `data` 
  FROM `feb2016_session`

1 × SELECT * 
  FROM `feb2016_extensions`

1 × SELECT * 
  FROM feb2016_seminarman_courses

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

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

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

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

1 × SELECT DISTINCT rel.fileid, f.filename, f.altname 
  FROM feb2016_seminarman_files AS f 
  LEFT JOIN feb2016_seminarman_files_course_relations AS rel 
  ON rel.fileid = f.id

1 × SELECT `session_id` 
  FROM `feb2016_session`

1 × SELECT * 
  FROM feb2016_seminarman_sessions

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 feb2016_seminarman_tags AS t 
  LEFT JOIN feb2016_seminarman_tags_course_relations AS i 
  ON i.tid = t.id

```
1 × SELECT name 
  FROM feb2016_users
```

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 feb2016_seminarman_courses AS i 
  LEFT JOIN feb2016_seminarman_cats_course_relations AS rel 
  ON rel.courseid = i.id 
  LEFT JOIN feb2016_seminarman_atgroup AS gr 
  ON gr.id = i.id_group 
  LEFT JOIN feb2016_seminarman_experience_level AS lev 
  ON lev.id = i.id_experience_level 
  LEFT JOIN feb2016_seminarman_tutor AS emp 
  ON emp.id = i.tutor_id 
  LEFT JOIN feb2016_seminarman_categories AS c 
  ON c.id = rel.catid 
  LEFT JOIN feb2016_users AS u 
  ON u.id = i.created_by

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

1 × SELECT id, rules 
  FROM `feb2016_viewlevels

1 × SELECT * 
  FROM feb2016_gsd_config

Andere Tabellen:

1 × INSERT INTO `feb2016_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('teeu3p1dtjp8htmslt4v5mip6v', 1, 1653531582, 0, '', 0

1 × UPDATE `feb2016_extensions` 
  SET `params` = '{\"mediaversion\":\"ad64b703224409ee29537fa551be5262\"}'

1 × SHOW FULL COLUMNS 
  FROM `feb2016_seminarman_courses

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

1 × SHOW FULL COLUMNS 
  FROM `feb2016_gsd_config

Wie funktioniert das hier?

Wann erreichen Sie uns?

Passwort vergessen?

Sensibilisierung Unternehmenssicherheit

Beschreibung

Sensibilisierung Unternehmenssicherheit

Diese Schulung führen Sie online an Ihrem PC durch. Die Zugangsdaten erhalten Sie von uns.

Diesen Kurs buchen: Sensibilisierung Unternehmenssicherheit

Einzelpreis

Teilnehmerdaten

Rechnungsadresse

Kommentare / E-Mail Bestätigung

Wie haben Sie von uns erfahren?

Kategorie

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

38 ausgeführte Abfragen 17.57 ms

10 Duplikate gefunden!

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

SELECT-Tabellen:

Andere Tabellen:

Wie funktioniert das hier?

Wann erreichen Sie uns?

Loggen Sie sich ein um zusätzliche Informationen zu erhalten

Passwort vergessen?

Sensibilisierung Unternehmenssicherheit

Beschreibung

Sensibilisierung Unternehmenssicherheit

Diese Schulung führen Sie online an Ihrem PC durch. Die Zugangsdaten erhalten Sie von uns.

Diesen Kurs buchen: Sensibilisierung Unternehmenssicherheit

Einzelpreis

Teilnehmerdaten

Rechnungsadresse

Kommentare / E-Mail Bestätigung

Wie haben Sie von uns erfahren?

Kategorie

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

38 ausgeführte Abfragen 17.57 ms

10 Duplikate gefunden!

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

SELECT-Tabellen:

Andere Tabellen: