Home

Ausschreibung 07.21

Ausschreibung komplett WM-Qualifikation 2021

Neu Ausschreibung WMQ2021

WEC HP klein

Der W.E.C., ein weiteres Highlight für unsere Region.
Lange hatten wir davon geträumt und darüber gesprochen, aber nun steht sie fest, die Kooperation unserer beider Agilityhallen in Form eines gemeinsamen Wintercups ist nun besiegelt. Der Westerwälder-Eifel Cup ist geboren. Damit möchten wir für unsere Hundesportler einen interessanten Cup mit internationalen und nationalen Richtern bieten.

Jedes Turnier-Wochenende ist ein eigenständiges Turnier, der Cup muss nicht vollständig gelaufen werden um daran teilzunehmen. Die Meldungen laufen wie gewohnt über webmelden. Um eine einfachere Kommunikation zu haben, werden wir auch eine eigene FB-Gruppe für den Wintercup erstellen. Darüber werden auch die aktuellen Ranglisten veröffentlicht.

Es wird eine Punktrangliste für jede Größenklasse erstellt, jeder A-Lauf und Jumping ergibt Punkte. Der Punkteschlüssel ist für alle Leistungsklassen gleich. Aus der Gesamtrangliste über die vier Etappen werden die Sieger heraus ermittelt.
Für Small und Medium werden die Plätze 1-6 und bei den Large die Plätze 1-8 prämiert.
In die Wertung fließt jeder A-Lauf und jeder Jumping ein, für A1 und A2 wird ein gemeinsamer JOpen (Spiel) angeboten, für die A3 einen J3. Somit kämpfen die verschiedenen Leistungsklassen jeweils in der Kategorie Small, Medium und Large gegeneinander in einer gemeinsamen Rangliste. Sollten Teams in der Zwischenzeit aufsteigen bleiben die Punkte erhalten, es geht einfach nur um die tatsächliche erbrachte Leistung und hat nichts mit Leistungsklassen zu tun.Es kommen nur Läufe mit bis zu einem V5 in die Wertung (Vorzüglich bis max. 5,99 Gesamtfehler). Durch Spreizung bei der Punktevergabe für die Plätze 1 – 3 soll die „Siegfähigkeit“ stärker belohnt werden. Bei Punktegleichheit nach dem letzten Lauf entscheidet zunächst der direkte Vergleich aus den Punkten der A-Läufe. Bringt auch dies noch keine Entscheidung kann ein kleines Stechen mit einem „Golden Slalom“ den Sieger entscheiden.

Wir freuen uns auf euch

Punkte

Bedingt durch den zweiten Lockdown müssen wir leider unsere beiden Turniere im November absagen.

Wir hoffen das es im Dezember wieder weitergeht, warten wir es ab.

Bleibt gesund und passt auf euch auf.

Abgesagt

Nun ist es soweit, der Agilitypark schließt vorübergehend seine Türen.

Nachdem wir die WM-Qualifikationen absagen mussten, hatten wir noch keine Ahnung von den weiteren

Ausmaßen und hatten gehofft das Training noch eine Weile aufrecht zu erhalten.

Leider steht die Welt nun still und nichts geht mehr, alles wird runtergefahren, jegliche sozialen Kontakte sollen erstmal

auf Eis gelegt werden. Es werden Verbote von Freizeit und Sport ausgesprochen, somit ist auch die Schließung

unumgänglich und wir stellen ab morgen 16.03.2020 das Training ein. Es wurden von Fristen von Mitte April bis Mitte Juni

geschrieben, was nun wirklich eintrifft wird sich zeigen, ändern können wir es sowieso nicht. Jeden Tag kommt eine neue

Hiobsbotschaft. Da wir mit der Situation momentan überfordert sind, brauchen wir etwas Zeit, um Lösungen zu finden.

Wir wünschen euch alles Gute in dieser schweren Zeit, bitte bleibt gesund und munter.

Alex & Kriszta

Seite 4 von 7

Keine Termine

Workshop Steppach 2025 (AF38)
3. Jun 2025 - 5. Jun 2025

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1732175077,
                "last": 1732175077,
                "now": 1732175077
            },
            "token": "dbbFNpJx17Sye3eQXg74j8ycV8SmOBRL"
        },
        "registry": {
            "jevents": {
                "moduleid106": {
                    "shownEventIds": [],
                    "page": 0,
                    "firstEventDate": false
                }
            },
            "published_fv_ses": "0"
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profil zum Laufzeitverhalten

Speichernutzung

Datenbankabfragen

26 ausgeführte Abfragen 35.15 ms

Abfragezeit: 1.39 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 1.248 MB Zeilen zurückgegeben: 0

SELECT `data`

  FROM `agip_session`

  WHERE `session_id` = X'756f30376430736f65326c6632356e64716b3265727632687332'

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 0.83 ms Nach letzter Abfrage: 0.55 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 1.267 MB Zeilen zurückgegeben: 0

SELECT `session_id`

  FROM `agip_session`

  WHERE `session_id` = X'756f30376430736f65326c6632356e64716b3265727632687332' 
  LIMIT 1

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 0.95 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 1.274 MB

INSERT INTO `agip_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'756f30376430736f65326c6632356e64716b3265727632687332', 1, 1732175077, 0, '', 0)

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 1.21 ms Nach letzter Abfrage: 2.06 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.447 MB Zeilen zurückgegeben: 5

SELECT id, rules

  FROM `agip_viewlevels`

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 1.22 ms Nach letzter Abfrage: 0.32 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.462 MB Zeilen zurückgegeben: 2

SELECT b.id

  FROM agip_usergroups AS a

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

  WHERE a.id = 9

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 1.33 ms Nach letzter Abfrage: 38.35 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 4.661 MB

UPDATE `agip_extensions`

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

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

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 1.68 ms Nach letzter Abfrage: 27.89 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 5.299 MB Zeilen zurückgegeben: 41

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `agip_assets`

  WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyjoomlabackup','com_fields','com_finder','com_installer','com_jce','com_jevents','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mijoftp','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_profiles','com_redirect','com_search','com_seminarman','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_xcloner-backupandrestore')

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_jevents/libraries/helper.php:1120
14	JEVHelper::isAdminUser()	JROOT/components/com_jevents/libraries/helper.php:1078
13	JEVHelper::getAid()	JROOT/components/com_jevents/libraries/datamodel.php:49
12	JEventsDataModel->__construct()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:94
11	DefaultModLatestView->__construct()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:52
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.53 ms Nach letzter Abfrage: 2.16 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 5.520 MB Zeilen zurückgegeben: 18

SHOW FULL COLUMNS 
  FROM `agip_jev_users`

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
20	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:75
19	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:1543
18	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1398
17	JEVHelper::isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:61
16	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1205
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32
11	GeraintModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.52 ms Nach letzter Abfrage: 0.98 ms Abfragespeichernutzung: 0.045 MB Speichernutzung vor Abfrage: 5.608 MB Zeilen zurückgegeben: 4

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 `agip_categories` AS `c`

  WHERE (c.extension='com_jevents' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1

  ORDER BY c.lft

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ALL	cat_idx,idx_access	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	23	Using where; filesort wurde genutzt

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
21	Joomla\CMS\Categories\Categories->_load()	JROOT/components/com_jevents/helpers/category.php:53
20	JEventsCategories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:401
18	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1019
17	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
16	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1205
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32
11	GeraintModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.93 ms Nach letzter Abfrage: 0.34 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 5.660 MB Zeilen zurückgegeben: 3

SELECT c.id

  FROM agip_categories AS c

  WHERE c.access   IN (1,1,5)
 
  AND c.published = 1
  
  AND c.language in ('de-DE','*')
 
  AND c.extension = 'com_jevents'
 

  ORDER BY c.lft asc

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	range	cat_idx,idx_access,idx_language	cat_idx	207	NULL	4	Using index condition; Using where; filesort wurde genutzt

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
19	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:514
18	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1019
17	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
16	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:1205
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32
11	GeraintModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.87 ms Nach letzter Abfrage: 0.45 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 5.695 MB Zeilen zurückgegeben: 1

SELECT c.id

  FROM agip_categories AS c

  WHERE c.access   IN (1,1,5)
 
  AND c.published = 1
  
  AND c.language in ('de-DE','*')
 
  AND c.extension = 'com_jevents'
 
  AND ((c.lft>=27 
  AND c.rgt<=28 ))

  ORDER BY c.lft asc

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	range\|filter	cat_idx,idx_access,idx_left_right,idx_language	cat_idx\|idx_left_right	207\|4	NULL	4 (39%)	Using index condition; Using where; filesort wurde genutzt; Using rowid filter

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
15	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:514
14	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/dbmodel.php:1248
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32
11	GeraintModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 3.02 ms Nach letzter Abfrage: 0.25 ms Abfragespeichernutzung: 0.054 MB Speichernutzung vor Abfrage: 5.733 MB Zeilen zurückgegeben: 0

SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created 
 , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
 , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
 , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
 , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
 
  FROM agip_jevents_repetition as rpt
 
  INNER JOIN agip_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN agip_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN agip_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN agip_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,15)
 
  AND rpt.endrepeat >= '2024-11-21 08:44:37' 
  AND rpt.startrepeat <= '2025-06-09 23:59:59'
 
  AND (rpt.startrepeat >= '2024-11-21 00:00:00' OR  det.multiday=1) 
  AND ev.state=1
 
  AND ev.access  IN (1,1,5)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1,5)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
						
						
  ORDER BY rpt.startrepeat ASC 
  LIMIT 9

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rpt	range	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	endrepeat	5	NULL	1	Using index condition; Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	HTO01FLQBWWG_3.rpt.eventid	1	Using where
1	SIMPLE	icsf	eq_ref	PRIMARY,stateidx	PRIMARY	4	HTO01FLQBWWG_3.ev.icsid	1	Using where
1	SIMPLE	det	eq_ref	PRIMARY,multiday	PRIMARY	4	HTO01FLQBWWG_3.rpt.eventdetail_id	1	Using where
1	SIMPLE	rr	ref	eventid	eventid	4	HTO01FLQBWWG_3.rpt.eventid	1

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2933
15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1727
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32
11	GeraintModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.64 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.054 MB Speichernutzung vor Abfrage: 5.758 MB Zeilen zurückgegeben: 0

SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created 
 , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
 , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
 , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
 , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
 
  FROM agip_jevents_repetition as rpt
 
  INNER JOIN agip_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN agip_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN agip_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN agip_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,15)
 
  AND rpt.endrepeat >= '2024-11-21 00:00:00' 
  AND rpt.startrepeat <= '2024-11-21 08:44:37'
 
  AND (rpt.startrepeat >= '2024-11-21 00:00:00' OR  det.multiday=1) 
  AND ev.state=1
 
  AND ev.access  IN (1,1,5)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1,5)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
							
							
  ORDER BY rpt.startrepeat desc 
  LIMIT 9

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rpt	range	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	endrepeat	5	NULL	1	Using index condition; Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	HTO01FLQBWWG_3.rpt.eventid	1	Using where
1	SIMPLE	icsf	eq_ref	PRIMARY,stateidx	PRIMARY	4	HTO01FLQBWWG_3.ev.icsid	1	Using where
1	SIMPLE	det	eq_ref	PRIMARY,multiday	PRIMARY	4	HTO01FLQBWWG_3.rpt.eventdetail_id	1	Using where
1	SIMPLE	rr	ref	eventid	eventid	4	HTO01FLQBWWG_3.rpt.eventid	1

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2933
15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1770
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32
11	GeraintModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.67 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.054 MB Speichernutzung vor Abfrage: 5.783 MB Zeilen zurückgegeben: 0

SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created 
 , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
 , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
 , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
 , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
 
  FROM agip_jevents_repetition as rpt
 
  INNER JOIN agip_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN agip_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN agip_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN agip_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,15)
 
  AND rpt.endrepeat >= '2024-11-21 00:00:00' 
  AND rpt.startrepeat <= '2024-11-21 08:44:37'
 
  AND (rpt.startrepeat <= '2024-11-21 00:00:00'OR  det.multiday=1) 
  AND ev.state=1
 
  AND ev.access  IN (1,1,5)  
  AND icsf.state=1 
 
  AND icsf.access  IN (1,1,5)
 
  GROUP BY rpt.startrepeat , rpt.rp_id
							
							
  ORDER BY rpt.startrepeat asc 
  LIMIT 9

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rpt	range	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	endrepeat	5	NULL	1	Using index condition; Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	HTO01FLQBWWG_3.rpt.eventid	1	Using where
1	SIMPLE	icsf	eq_ref	PRIMARY,stateidx	PRIMARY	4	HTO01FLQBWWG_3.ev.icsid	1	Using where
1	SIMPLE	det	eq_ref	PRIMARY,multiday	PRIMARY	4	HTO01FLQBWWG_3.rpt.eventdetail_id	1	Using where
1	SIMPLE	rr	ref	eventid	eventid	4	HTO01FLQBWWG_3.rpt.eventid	1

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2933
15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1812
13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/geraint/latest.php:32
11	GeraintModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 2.58 ms Nach letzter Abfrage: 2.10 ms Abfragespeichernutzung: 0.048 MB Speichernutzung vor Abfrage: 5.847 MB Zeilen zurückgegeben: 1

SELECT DISTINCT i.*, 
  CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, rel.catid as cat 
  FROM agip_seminarman_courses AS i 
  LEFT JOIN agip_seminarman_cats_course_relations AS rel 
  ON rel.courseid = i.id 
  WHERE i.state = 1 
  AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-11-21 07:44:37') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-21 07:44:37') 
  AND (CONCAT_WS(' ', i.start_date, i.start_time)) >= '2024-11-20 23:00:00' 
  AND TIME_TO_SEC(TIMEDIFF(CONCAT_WS(' ', i.start_date, i.start_time), '2024-11-20 23:00:00')) <= 31622400 
  GROUP BY i.id 
  ORDER BY i.start_date 
  LIMIT 10

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	index	NULL	PRIMARY	4	NULL	51	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	rel	ref	itemid	itemid	4	HTO01FLQBWWG_3.i.id	1	Using index

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_seminarman_schedule/helper.php:115
11	require JROOT/modules/mod_seminarman_schedule/helper.php	JROOT/modules/mod_seminarman_schedule/mod_seminarman_schedule.php:30
10	include JROOT/modules/mod_seminarman_schedule/mod_seminarman_schedule.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.93 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 5.881 MB Zeilen zurückgegeben: 1

SELECT SUM(b.attendees) 
  FROM agip_seminarman_application AS b 
  WHERE b.published = 1 
  AND b.course_id = 67 
  AND b.status > -1 
  AND b.status < 3

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/modules/mod_seminarman_schedule/helper.php:143
11	require JROOT/modules/mod_seminarman_schedule/helper.php	JROOT/modules/mod_seminarman_schedule/mod_seminarman_schedule.php:30
10	include JROOT/modules/mod_seminarman_schedule/mod_seminarman_schedule.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.44 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 5.902 MB Zeilen zurückgegeben: 0

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

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_seminarman_schedule/helper.php:153
11	require JROOT/modules/mod_seminarman_schedule/helper.php	JROOT/modules/mod_seminarman_schedule/mod_seminarman_schedule.php:30
10	include JROOT/modules/mod_seminarman_schedule/mod_seminarman_schedule.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.91 ms Nach letzter Abfrage: 0.50 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 6.006 MB Zeilen zurückgegeben: 1

SELECT 
  CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END AS slug,i.alt_url

  FROM agip_seminarman_courses AS i

  WHERE i.id = 67

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/components/com_seminarman/classes/helper.php:1627
12	SMANFunctions::getCourseRoute()	JROOT/modules/mod_seminarman_schedule/tmpl/default.php:78
11	require JROOT/modules/mod_seminarman_schedule/tmpl/default.php	JROOT/modules/mod_seminarman_schedule/mod_seminarman_schedule.php:36
10	include JROOT/modules/mod_seminarman_schedule/mod_seminarman_schedule.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.43 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 6.027 MB Zeilen zurückgegeben: 0

SELECT *

  FROM agip_menu

  WHERE `link` like "index.php?option=com_seminarman&view=courses%" 
  AND client_id=0 
  AND published=1 
  AND (language="*" or language = "de-DE") 
  AND access IN(1,1,5)

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	agip_menu	ALL	idx_client_id_parent_id_alias_language,idx_language	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	103	Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_seminarman/classes/helper.php:1651
12	SMANFunctions::getCourseRoute()	JROOT/modules/mod_seminarman_schedule/tmpl/default.php:78
11	require JROOT/modules/mod_seminarman_schedule/tmpl/default.php	JROOT/modules/mod_seminarman_schedule/mod_seminarman_schedule.php:36
10	include JROOT/modules/mod_seminarman_schedule/mod_seminarman_schedule.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.05 ms Nach letzter Abfrage: 0.55 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 6.047 MB Zeilen zurückgegeben: 1

SELECT *

  FROM agip_menu

  WHERE `link` like "index.php?option=com_seminarman&view=category%" 
  AND client_id=0 
  AND published=1 
  AND (language="*" or language = "de-DE") 
  AND access IN(1,1,5)

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	agip_menu	ALL	idx_client_id_parent_id_alias_language,idx_language	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	103	Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_seminarman/classes/helper.php:1664
12	SMANFunctions::getCourseRoute()	JROOT/modules/mod_seminarman_schedule/tmpl/default.php:78
11	require JROOT/modules/mod_seminarman_schedule/tmpl/default.php	JROOT/modules/mod_seminarman_schedule/mod_seminarman_schedule.php:36
10	include JROOT/modules/mod_seminarman_schedule/mod_seminarman_schedule.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.01 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 6.072 MB Zeilen zurückgegeben: 0

SELECT *

  FROM agip_menu

  WHERE `link` like "index.php?option=com_seminarman&view=tags%" 
  AND client_id=0 
  AND published=1 
  AND (language="*" or language = "de-DE") 
  AND access IN(1,1,5)

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	agip_menu	ALL	idx_client_id_parent_id_alias_language,idx_language	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	103	Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_seminarman/classes/helper.php:1677
12	SMANFunctions::getCourseRoute()	JROOT/modules/mod_seminarman_schedule/tmpl/default.php:78
11	require JROOT/modules/mod_seminarman_schedule/tmpl/default.php	JROOT/modules/mod_seminarman_schedule/mod_seminarman_schedule.php:36
10	include JROOT/modules/mod_seminarman_schedule/mod_seminarman_schedule.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.11 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 6.092 MB Zeilen zurückgegeben: 0

SELECT *

  FROM agip_menu

  WHERE `link` like "index.php?option=com_seminarman&view=tutors%" 
  AND client_id=0 
  AND published=1 
  AND (language="*" or language = "de-DE") 
  AND access IN(1,1,5)

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	agip_menu	ALL	idx_client_id_parent_id_alias_language,idx_language	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	103	Using where

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_seminarman/classes/helper.php:1690
12	SMANFunctions::getCourseRoute()	JROOT/modules/mod_seminarman_schedule/tmpl/default.php:78
11	require JROOT/modules/mod_seminarman_schedule/tmpl/default.php	JROOT/modules/mod_seminarman_schedule/mod_seminarman_schedule.php:36
10	include JROOT/modules/mod_seminarman_schedule/mod_seminarman_schedule.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT DISTINCT c.id

  FROM agip_seminarman_categories AS c

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

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

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
13	JDatabaseDriver->loadColumn()	JROOT/components/com_seminarman/classes/helper.php:1717
12	SMANFunctions::getCourseRoute()	JROOT/modules/mod_seminarman_schedule/tmpl/default.php:78
11	require JROOT/modules/mod_seminarman_schedule/tmpl/default.php	JROOT/modules/mod_seminarman_schedule/mod_seminarman_schedule.php:36
10	include JROOT/modules/mod_seminarman_schedule/mod_seminarman_schedule.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT parent_id

  FROM agip_seminarman_categories

  WHERE id = 5

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_seminarman/classes/categories.php:67
14	seminarman_cats->buildParentCats()	JROOT/components/com_seminarman/classes/categories.php:35
13	seminarman_cats->__construct()	JROOT/components/com_seminarman/classes/helper.php:1720
12	SMANFunctions::getCourseRoute()	JROOT/modules/mod_seminarman_schedule/tmpl/default.php:78
11	require JROOT/modules/mod_seminarman_schedule/tmpl/default.php	JROOT/modules/mod_seminarman_schedule/mod_seminarman_schedule.php:36
10	include JROOT/modules/mod_seminarman_schedule/mod_seminarman_schedule.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM agip_seminarman_categories

  WHERE id =5 
  AND published = 1

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_seminarman/classes/categories.php:54
14	seminarman_cats->getParentCats()	JROOT/components/com_seminarman/classes/categories.php:36
13	seminarman_cats->__construct()	JROOT/components/com_seminarman/classes/helper.php:1720
12	SMANFunctions::getCourseRoute()	JROOT/modules/mod_seminarman_schedule/tmpl/default.php:78
11	require JROOT/modules/mod_seminarman_schedule/tmpl/default.php	JROOT/modules/mod_seminarman_schedule/mod_seminarman_schedule.php:36
10	include JROOT/modules/mod_seminarman_schedule/mod_seminarman_schedule.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.84 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 6.185 MB Zeilen zurückgegeben: 1

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

  FROM `agip_seminarman_categories` AS c

  WHERE c.id = 5

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_seminarman/classes/helper.php:1739
12	SMANFunctions::getCourseRoute()	JROOT/modules/mod_seminarman_schedule/tmpl/default.php:78
11	require JROOT/modules/mod_seminarman_schedule/tmpl/default.php	JROOT/modules/mod_seminarman_schedule/mod_seminarman_schedule.php:36
10	include JROOT/modules/mod_seminarman_schedule/mod_seminarman_schedule.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT-Tabellen:

```
4 × SELECT * 
  FROM agip_menu
```

3 × SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created   , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup  , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn  , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup  , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn  
  FROM agip_jevents_repetition as rpt  
  INNER JOIN agip_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id  
  INNER JOIN agip_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid   
  INNER JOIN agip_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id  
  LEFT JOIN agip_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid

2 × SELECT c.id 
  FROM agip_categories AS c

1 × SELECT `data` 
  FROM `agip_session`

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

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

1 × SELECT parent_id 
  FROM agip_seminarman_categories

1 × SELECT DISTINCT c.id 
  FROM agip_seminarman_categories AS c 
  LEFT JOIN agip_seminarman_cats_course_relations AS rel 
  ON (rel.catid = c.id)

1 × SELECT 
  CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END AS slug,i.alt_url 
  FROM agip_seminarman_courses AS i

1 × SELECT DISTINCT i.*, 
  CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, rel.catid as cat 
  FROM agip_seminarman_courses AS i 
  LEFT JOIN agip_seminarman_cats_course_relations AS rel 
  ON rel.courseid = i.id

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

1 × SELECT `session_id` 
  FROM `agip_session`

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 `agip_categories` AS `c`

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `agip_assets`

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

1 × SELECT id, rules 
  FROM `agip_viewlevels

1 × SELECT 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS slug 
  FROM `agip_seminarman_categories` AS c

Andere Tabellen:

1 × INSERT INTO `agip_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'756f30376430736f65326c6632356e64716b3265727632687332', 1, 1732175077, 0, '', 0

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

1 × SHOW FULL COLUMNS 
  FROM `agip_jev_users

2. Rally Obedience Turnier

WM-Qualifikationen 2021

W.E.C. Wintercup

Turnierabsage November

Das Licht geht aus

Unsere Partner

Anmeldung

Unsere nächsten Turniere

Unsere nächsten Seminare

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

26 ausgeführte Abfragen 35.15 ms

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

SELECT-Tabellen:

Andere Tabellen:

Protokollnachrichten

0 Nachrichten protokolliert