Home

Durch die beiden Richter Daniel Walz und Tamás Tráj konnte man schon erahnen wohin die Reise geht und auf was man sich einstellen durfte, beide haben uns mit sensationellen Parcours verwöhnt. Aus verschiedenen Ländern waren viele Top Teams angereist und haben sich den Herausforderungen gestellt. Es gab viele flinke Teams, tolle Skills mit jeder Menge Action und konnten so viele sensationelle Läufe bestaunen. Auch durch die beiden Sprecher Andi & Andi wurde die Spannung hochgezogen und haben uns super durch die Tage geleitet. Ein großes Dankeschön geht an alle internen und externen Helfer, ohne euch wäre dies so nicht möglich gewesen. Ein ganz großes Dankeschön geht auch an unsere Sponsoren European Pet Pharmacy, Belcando, Galican, Dustys Dog Design und Authentic Dog, ohne solche Unterstützungen sind Veranstaltung wie diese kaum machbar.

Ein neues Event ist geboren und wir freuen uns schon jetzt auf die 2. Edition des EPP Cup.

*** Save the date International Agility EPP Cup 2023 ***

27.-29.10.2023 Judges Tamás Tráj & Daniel Walz

#europeanpetpharmacy

#dustysdogdesign

#authenticdog

#galicanagility

#belcando

EPP22L

EPP22M

EPP22S

Am 15.-17.7.2022 fand die Junior WM Agility (JOAWC) in Finnland statt.

Der ATS Mendig ist stolz auf seine beiden Mädels.

Weltmeister U 19 Large
Leni Hoffmann mit Lucy

Weltmeister U 12 Large
Sun Zenner mit Limit

0A3B7FCC A61B 4ED9 AF1E 30CB61306A60

C094FE77 6B40 4E96 85BC B5827825EB27

Seite 1 von 7

Keine Termine

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

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1732174208,
                "last": 1732174208,
                "now": 1732174208
            },
            "token": "aycQnA0bTPT3vzRJd1D6dP17m6w089wT"
        },
        "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 38.52 ms

Abfragezeit: 1.44 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 1.247 MB Zeilen zurückgegeben: 0

SELECT `data`

  FROM `agip_session`

  WHERE `session_id` = X'3275306a703131663866357136386b35376164656576346a6134'

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.07 ms
checking permissions	0.02 ms
Opening tables	0.25 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.08 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.84 ms Nach letzter Abfrage: 1.80 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 1.265 MB Zeilen zurückgegeben: 0

SELECT `session_id`

  FROM `agip_session`

  WHERE `session_id` = X'3275306a703131663866357136386b35376164656576346a6134' 
  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.03 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: 1.06 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 1.272 MB

INSERT INTO `agip_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'3275306a703131663866357136386b35376164656576346a6134', 1, 1732174208, 0, '', 0)

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init for update	0.03 ms
Update	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
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.43 ms Nach letzter Abfrage: 9.91 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.445 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.27 ms
After opening tables	0.02 ms
System lock	0.03 ms
table lock	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
init	0.03 ms
Optimizing	0.04 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.03 ms
Sending data	0.10 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.03 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.74 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.460 MB Zeilen zurückgegeben: 2

SELECT b.id

  FROM agip_usergroups AS a

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

  WHERE a.id = 9

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.34 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.03 ms
System lock	0.03 ms
table lock	0.04 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
init	0.04 ms
Optimizing	0.03 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.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 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.93 ms Nach letzter Abfrage: 81.32 ms Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 4.660 MB

UPDATE `agip_extensions`

  SET `params` = '{\"mediaversion\":\"014ccad7d8d26441940319d6b924f33e\"}'

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

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.06 ms
checking permissions	0.03 ms
Opening tables	0.31 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.04 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.04 ms
table lock	0.02 ms
Unlocking tables	0.03 ms
closing tables	0.04 ms
init for update	0.08 ms
Updating	0.20 ms
End of update loop	0.02 ms
Query end	0.03 ms
Commit	0.04 ms
Writing to binlog	0.02 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.04 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.42 ms Nach letzter Abfrage: 80.75 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 5.301 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.05 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.03 ms
Sending data	0.17 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.62 ms Nach letzter Abfrage: 8.12 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 5.522 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.15 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.23 ms
After opening tables	0.02 ms
checking permissions	0.07 ms
closing tables	0.02 ms
Executing	0.02 ms
Sending data	0.04 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.02 ms
Removing tmp table	0.10 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.43 ms Nach letzter Abfrage: 6.61 ms Abfragespeichernutzung: 0.045 MB Speichernutzung vor Abfrage: 5.609 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.07 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.05 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.02 ms
Creating sort index	0.13 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.04 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: 1.00 ms Nach letzter Abfrage: 0.34 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 5.662 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.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.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.02 ms
Creating sort index	0.10 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
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: 1.11 ms Nach letzter Abfrage: 3.38 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 5.697 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.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.05 ms
Preparing	0.04 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.04 ms Nach letzter Abfrage: 0.54 ms Abfragespeichernutzung: 0.054 MB Speichernutzung vor Abfrage: 5.735 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:30:08' 
  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.07 ms
After opening tables	0.04 ms
System lock	0.03 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.11 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.08 ms
Preparing	0.04 ms
Creating tmp table	0.07 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	0.34 ms
Creating sort index	0.07 ms
Removing tmp table	0.08 ms
Creating sort index	0.03 ms
End of update loop	0.03 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.62 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.054 MB Speichernutzung vor Abfrage: 5.760 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:30:08'
 
  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.08 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.06 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.04 ms
Creating tmp table	0.06 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.37 ms
Creating sort index	0.04 ms
Removing tmp table	0.07 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.04 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.40 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.054 MB Speichernutzung vor Abfrage: 5.785 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:30:08'
 
  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.09 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.05 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Creating tmp table	0.07 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.25 ms
Creating sort index	0.03 ms
Removing tmp table	0.05 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.03 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
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.27 ms Nach letzter Abfrage: 2.75 ms Abfragespeichernutzung: 0.048 MB Speichernutzung vor Abfrage: 5.848 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:30:08') 
  AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-21 07:30:08') 
  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.07 ms
checking permissions	0.02 ms
Opening tables	0.43 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
Opening tables	0.04 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.06 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.03 ms
Creating tmp table	0.06 ms
Sorting for group	0.02 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.03 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.71 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 5.883 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.24 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.03 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.03 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.48 ms
End of update loop	0.02 ms
Query end	0.03 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: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.67 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 5.904 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.04 ms
checking permissions	0.02 ms
Opening tables	0.32 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.04 ms
Preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.07 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: 1.23 ms Nach letzter Abfrage: 5.14 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 6.007 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.03 ms
Preparing	0.03 ms
Executing	0.03 ms
Sending data	0.04 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.04 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.04 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.86 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 6.028 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.05 ms
checking permissions	0.03 ms
Opening tables	0.28 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
Opening tables	0.04 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.04 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.18 ms
End of update loop	0.02 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 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.32 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 6.048 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.03 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.13 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 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.29 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 6.073 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.03 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.04 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.03 ms
Sending data	0.13 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.03 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: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.00 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 6.093 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.03 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.19 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: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.67 ms Nach letzter Abfrage: 0.45 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 6.117 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.21 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.03 ms
closing tables	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.04 ms
Creating tmp table	0.03 ms
Executing	0.02 ms
Sending data	0.11 ms
Removing tmp table	0.02 ms
Sending data	0.02 ms
End of update loop	0.03 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.04 ms
Reset for next command	0.03 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: 1.07 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 6.142 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.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.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	0.03 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: 1.22 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 6.165 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.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.04 ms
Preparing	0.02 ms
Unlocking tables	0.03 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	0.04 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
closing tables	0.05 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.05 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: 1.12 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 6.186 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.04 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.04 ms
table lock	0.03 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.02 ms
Unlocking tables	0.04 ms
Preparing	0.03 ms
Executing	0.03 ms
Sending data	0.03 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.04 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: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'3275306a703131663866357136386b35376164656576346a6134', 1, 1732174208, 0, '', 0

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

1 × SHOW FULL COLUMNS 
  FROM `agip_jev_users

Workshop Steppach 2025

WM-Qualifikationen 2024 Listen, Ergebnisse & Parcours

Weltmeister Team Medium 2022

International Agility EPP Cup

Junior Open Agility World Championship 2022

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 38.52 ms

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

SELECT-Tabellen:

Andere Tabellen:

Protokollnachrichten

0 Nachrichten protokolliert