Männer 3 Kreisliga B

Training

Kontakt: Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!

Spielplan

	Wann		Halle	Heim		Gast	Ergebnis
So	19. Sep.	12:50Uhr 19.09. 12:50	Wehle-Sporthalle (7055)7055	SG Dunn/Schram 3Dunn/Schr. 3	-	HK Ostd/Geisl 3HKOG 3	32	:	28
So	26. Sep.	13:00Uhr 26.09. 13:00	Sporthalle Realschule (7005)7005	HK Ostd/Geisl 3HKOG 3	-	TV Streichen 2Streichen 2	29	:	24
Sa	9. Okt.	19:30Uhr 09.10. 19:30	Doppelsporthalle 1 (7023)7023	HSG Rottweil 3Rottweil 3	-	HK Ostd/Geisl 3HKOG 3	27	:	46
So	17. Okt.	17:00Uhr 17.10. 17:00	Marquardt-Halle (7060)7060	HSG Riet-Weil 3Riet-Weil 3	-	HK Ostd/Geisl 3HKOG 3	21	:	36
So	24. Okt.	17:00Uhr 24.10. 17:00	Kreissporthalle (7003)7003	HK Ostd/Geisl 3HKOG 3	-	HSG Baar 4HSG Baar 4	32	:	24
Sa	13. Nov.	18:00Uhr 13.11. 18:00	Schloßparkhalle (7014)7014	HK Ostd/Geisl 3HKOG 3	-	HSG Frid/Mühl 3Frid/Mühl 3	36	:	26
Sa	20. Nov.	17:15Uhr 20.11. 17:15	Raichberghalle (7022)7022	TV Onstmett. 2Onstmett. 2	-	HK Ostd/Geisl 3HKOG 3	27	:	33
Sa	27. Nov.	18:00Uhr 27.11. 18:00	Schloßparkhalle (7014)7014	HK Ostd/Geisl 3HKOG 3	-	HC FritBalNeu 2	31	:	15
Sa	15. Jan.	16:00Uhr 15.01. 16:00	Schloßparkhalle (7014)7014	HK Ostd/Geisl 3HKOG 3	-	SG Dunn/Schram 3Dunn/Schr. 3	26	:	17
So	23. Jan.	14:45Uhr 23.01. 14:45	Längenfeldhalle (7004)7004	TV Streichen 2Streichen 2	-	HK Ostd/Geisl 3HKOG 3	22	:	28
Sa	12. Feb.	18:00Uhr 12.02. 18:00	Kreissporthalle (7003)7003	HK Ostd/Geisl 3HKOG 3	-	HSG Riet-Weil 3Riet-Weil 3	25	:	19
Sa	12. Mär.	18:00Uhr 12.03. 18:00	Schloßparkhalle (7014)7014	HK Ostd/Geisl 3HKOG 3	-	HSG Rottweil 3Rottweil 3	33	:	19
Sa	19. Mär.	14:00Uhr 19.03. 14:00	Sepp-Hipp-Halle (7011)7011	HSG Frid/Mühl 3Frid/Mühl 3	-	HK Ostd/Geisl 3HKOG 3	32	:	33
Sa	26. Mär.	16:00Uhr 26.03. 16:00	Schloßparkhalle (7014)7014	HK Ostd/Geisl 3HKOG 3	-	TV Onstmett. 2Onstmett. 2	30	:	18
Do	31. Mär.	20:30Uhr 31.03. 20:30	Hohenlupfen-Sporthalle (7040)7040	HSG Baar 4HSG Baar 4	-	HK Ostd/Geisl 3HKOG 3	18	:	26
So	3. Apr.	13:00Uhr 03.04. 13:00	Leintalhalle (7054)7054	HC FritBalNeu 2	-	HK Ostd/Geisl 3HKOG 3	22	:	25
Sa	9. Apr.	15:30Uhr 09.04. 15:30	Schloßparkhalle (7014)7014	HK Ostd/Geisl 3HKOG 3	-	TV Aixheim 3Aixheim 3	33	:	29
Sa	14. Mai.	17:00Uhr 14.05. 17:00	Sporthalle (7001)7001	TV Aixheim 3Aixheim 3	-	HK Ostd/Geisl 3HKOG 3	26	:	37

Aktualisiert: 23.05.22 | Liga: Kreisliga B (M-KLB)

Tabelle

Platz	Mannschaft	Spiele	S	U	N	Tore			Diff	Punkte
1	HK Ostdorf/Geislingen 3HK Ostd/Geisl 3	18	17	0	1	567	:	418	149	34	:	2
2	TV Aixheim 3TV Aixheim 3	17	12	1	4	524	:	463	61	25	:	9
3	HSG Baar 4HSG Baar 4	18	9	4	5	489	:	435	54	22	:	14
4	SG Dunningen/Schramberg 3SG Dunn/Schram 3	17	10	1	6	411	:	384	27	21	:	13
5	HSG Rottweil 3HSG Rottweil 3	18	9	2	7	496	:	498	-2	20	:	16
6	TV 1905 Streichen 2TV Streichen 2	18	9	1	8	422	:	417	5	19	:	17
7	HSG Fridingen/Mühlheim 3HSG Frid/Mühl 3	18	9	0	9	480	:	488	-8	18	:	18
8	TV Onstmettingen 2TV Onstmett. 2	18	5	0	13	444	:	457	-13	10	:	26
9	HC Frittlingen-Balgheim-Neufra 2	18	2	1	15	378	:	522	-144	5	:	31
10	HSG Rietheim-Weilheim 3HSG Riet-Weil 3	18	1	2	15	440	:	569	-129	4	:	32

Aktualisiert: 23.05.22 | Liga: Kreisliga B (M-KLB)

Für eventuell aktuellere Informationen:
www.hvw-online.org

Wir nutzen Cookies auf unserer Website. Einige von ihnen sind essenziell für den Betrieb der Seite, während andere uns helfen, diese Website und die Nutzererfahrung zu verbessern (Tracking Cookies). Sie können selbst entscheiden, ob Sie die Cookies zulassen möchten. Bitte beachten Sie, dass bei einer Ablehnung womöglich nicht mehr alle Funktionalitäten der Seite zur Verfügung stehen.

Akzeptieren Ablehnen

Joomla!-Debug-Konsole

Sitzung

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

Profil zum Laufzeitverhalten

Speichernutzung

Datenbankabfragen

21 ausgeführte Abfragen 43.41 ms

4 Duplikate gefunden!

2 Duplikate: #17 #18

2 Duplikate: #19 #20

Abfragezeit: 0.14 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.478 MB Zeilen zurückgegeben: 0

SELECT `data`

  FROM `hkog_session`

  WHERE `session_id` = X'3237373738636661376437643231333036323433353131646565316632303361'

Explain

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

Profil (Profile)

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

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

SELECT `session_id`

  FROM `hkog_session`

  WHERE `session_id` = X'3237373738636661376437643231333036323433353131646565316632303361' 
  LIMIT 1

Explain

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

Profil (Profile)

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

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.21 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 4.799 MB

INSERT INTO `hkog_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'3237373738636661376437643231333036323433353131646565316632303361', 1, 1653290450, 0, '', 0)

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php: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.13 ms Nach letzter Abfrage: 1.16 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 5.190 MB Zeilen zurückgegeben: 5

SELECT id, rules

  FROM `hkog_viewlevels`

Explain

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

Profil (Profile)

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

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: 0.23 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 5.202 MB Zeilen zurückgegeben: 2

SELECT b.id

  FROM hkog_usergroups AS a

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

  WHERE a.id = 9

Explain

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.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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: 0.43 ms Nach letzter Abfrage: 5.15 ms Abfragespeichernutzung: 0.053 MB Speichernutzung vor Abfrage: 6.809 MB Zeilen zurückgegeben: 39

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM hkog_menu AS m

  LEFT JOIN hkog_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language,published,parent_id	idx_client_id_parent_id_alias_language	1	const	62	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	d01e9191.m.component_id	1	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Derselbe Aufruf in der Zeile darunter.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.23 ms Nach letzter Abfrage: 2.01 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 7.630 MB

UPDATE `hkog_extensions`

  SET `params` = '{\"mediaversion\":\"1f53e843c4805b7807fc21c9f4cd1880\"}'

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

Explain

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

Profil (Profile)

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

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: 0.20 ms Nach letzter Abfrage: 0.33 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 7.959 MB Zeilen zurückgegeben: 1

SELECT *

  FROM hkog_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.26 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 7.971 MB Zeilen zurückgegeben: 4

SELECT id, home, template, s.params

  FROM hkog_template_styles as s

  LEFT JOIN hkog_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	6	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	d01e9191.s.template,const	1	Using index condition; Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.24 ms Nach letzter Abfrage: 1.35 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 8.663 MB Zeilen zurückgegeben: 1

SELECT *, t1.teamkey AS teamkey

  FROM hkog_hb_team AS t1

  LEFT JOIN `hkog_hb_team_picture` AS t2 
  ON t1.teamkey=t2.teamkey 
  AND `season` = '2021-2022'

  WHERE t1.teamkey='M-3'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	const	teamkey	teamkey	32	const	1
1	SIMPLE	t2	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_hbmanager/models/team.php:85
14	HBmanagerModelTeam->setTeam()	JROOT/components/com_hbmanager/models/team.php:23
13	HBmanagerModelTeam->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
12	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
11	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
10	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
9	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hbmanager/hbmanager.php:15
6	require_once JROOT/components/com_hbmanager/hbmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 12.62 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.110 MB Speichernutzung vor Abfrage: 8.676 MB Zeilen zurückgegeben: 1669

SELECT dateTime

  FROM `hkog_hb_updatelog`

  WHERE `teamkey` = 'M-3' 
  AND `schedule` = 1

  ORDER BY dateTime DESC

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_hbmanager/models/team.php:119
15	HBmanagerModelTeam->getUpdate()	JROOT/components/com_hbmanager/models/team.php:91
14	HBmanagerModelTeam->setTeam()	JROOT/components/com_hbmanager/models/team.php:23
13	HBmanagerModelTeam->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
12	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
11	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
10	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
9	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hbmanager/hbmanager.php:15
6	require_once JROOT/components/com_hbmanager/hbmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 12.61 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.118 MB Speichernutzung vor Abfrage: 8.684 MB Zeilen zurückgegeben: 1820

SELECT dateTime

  FROM `hkog_hb_updatelog`

  WHERE `teamkey` = 'M-3' 
  AND `standings` = 1

  ORDER BY dateTime DESC

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_hbmanager/models/team.php:119
15	HBmanagerModelTeam->getUpdate()	JROOT/components/com_hbmanager/models/team.php:92
14	HBmanagerModelTeam->setTeam()	JROOT/components/com_hbmanager/models/team.php:23
13	HBmanagerModelTeam->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
12	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
11	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
10	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
9	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hbmanager/hbmanager.php:15
6	require_once JROOT/components/com_hbmanager/hbmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 10.76 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.110 MB Speichernutzung vor Abfrage: 8.693 MB Zeilen zurückgegeben: 1700

SELECT dateTime

  FROM `hkog_hb_updatelog`

  WHERE `teamkey` = 'M-3' 
  AND `standingsDetails` = 1

  ORDER BY dateTime DESC

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_hbmanager/models/team.php:119
15	HBmanagerModelTeam->getUpdate()	JROOT/components/com_hbmanager/models/team.php:93
14	HBmanagerModelTeam->setTeam()	JROOT/components/com_hbmanager/models/team.php:23
13	HBmanagerModelTeam->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
12	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
11	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
10	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
9	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hbmanager/hbmanager.php:15
6	require_once JROOT/components/com_hbmanager/hbmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.32 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 8.701 MB Zeilen zurückgegeben: 1

SELECT `path`

  FROM `hkog_menu`

  WHERE `link` = 'index.php?option=com_hbmanager&view=gamereports' 
  AND `params` REGEXP '{"teamkey":[^}]*"M-3"[^}]*}'

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_hbmanager/models/team.php:447
15	HBmanagerModelTeam->getReportMenuLink()	JROOT/components/com_hbmanager/models/team.php:96
14	HBmanagerModelTeam->setTeam()	JROOT/components/com_hbmanager/models/team.php:23
13	HBmanagerModelTeam->__construct()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:213
12	Joomla\CMS\MVC\Model\BaseDatabaseModel::getInstance()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:45
11	Joomla\CMS\MVC\Factory\LegacyFactory->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:559
10	Joomla\CMS\MVC\Controller\BaseController->createModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:728
9	Joomla\CMS\MVC\Controller\BaseController->getModel()	JROOT/libraries/src/MVC/Controller/BaseController.php:616
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hbmanager/hbmanager.php:15
6	require_once JROOT/components/com_hbmanager/hbmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.24 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 8.709 MB Zeilen zurückgegeben: 0

SELECT *, DATE_FORMAT(start, '%H:%i') as start,DATE_FORMAT(end, '%H:%i') as end

  FROM `hkog_hb_training`

  LEFT JOIN hkog_hb_gym USING (gymId)

  WHERE `teamkey` = 'M-3'

  ORDER BY FIELD(`day`, 'MO', 'Di', 'Mi', 'Do', 'Fr', 'Sa', 'So')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hkog_hb_training	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	Using where; filesort wurde genutzt
1	SIMPLE	hkog_hb_gym	eq_ref	PRIMARY	PRIMARY	4	d01e9191.hkog_hb_training.gymId	1	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_hbmanager/models/team.php:169
11	HBmanagerModelTeam->getTraining()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_hbmanager/views/team/view.html.php:28
9	HbManagerViewTeam->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hbmanager/hbmanager.php:15
6	require_once JROOT/components/com_hbmanager/hbmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.35 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 8.716 MB Zeilen zurückgegeben: 0

SELECT `alias`, `coachID`, `teamkey`, `rank`, `id`, `name`, `telephone`, `image`, `email_to`, `mobile`, `params`

  FROM `hkog_hb_team_coach`

  LEFT JOIN hkog_contact_details USING (alias)

  WHERE teamkey = 'M-3' 
  AND season = '2021-2022'

  ORDER BY IF(ISNULL(`rank`),1,0),`rank` DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hkog_hb_team_coach	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	34	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	hkog_contact_details	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	267	Using where; Using join buffer (flat, BNL join)

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_hbmanager/models/team.php:187
11	HBmanagerModelTeam->getCoaches()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_hbmanager/views/team/view.html.php:30
9	HbManagerViewTeam->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hbmanager/hbmanager.php:15
6	require_once JROOT/components/com_hbmanager/hbmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.71 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.055 MB Speichernutzung vor Abfrage: 8.727 MB Zeilen zurückgegeben: 18

Doppelte Abfragen: #18

SELECT *, IF(`home` = 'HK Ostd/Geisl 3',1,0) as homegame, (
  CASE WHEN `pointsHome` > `pointsAway` THEN 1 WHEN `pointsHome` < `pointsAway` THEN 2 WHEN (`pointsHome` = `pointsAway`) 
  AND`pointsHome` IS NOT NULL THEN 0 ELSE NULL END ) AS `result`,
				homenames.teamname_long AS home_long, homenames.teamname_short AS home_short, homenames.teamname_abbr AS home_abbr,
				awaynames.teamname_long AS away_long, awaynames.teamname_short AS away_short, awaynames.teamname_abbr AS away_abbr 

  FROM `hkog_hb_game`

  LEFT JOIN `hkog_hb_gamereport` USING (`gameIdHvw`, `season`)

  LEFT JOIN `hkog_hb_gym` USING (`gymId`)

  LEFT JOIN `hkog_hb_clubteams` AS homenames 
  ON `home`=`homenames`.`teamname_short`

  LEFT JOIN `hkog_hb_clubteams` AS awaynames 
  ON `away`=`awaynames`.`teamname_short`

  WHERE `teamkey` = 'M-3' 
  AND `season` = '2021-2022' 
  AND (`home` = 'HK Ostd/Geisl 3' OR `away` = 'HK Ostd/Geisl 3')

  ORDER BY `dateTime`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hkog_hb_game	ref	PRIMARY	PRIMARY	32	const	683	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	hkog_hb_gamereport	eq_ref	season	season	37	d01e9191.hkog_hb_game.season,d01e9191.hkog_hb_game.gameIdHvw	1
1	SIMPLE	hkog_hb_gym	eq_ref	PRIMARY	PRIMARY	4	d01e9191.hkog_hb_game.gymId	1	Using where
1	SIMPLE	homenames	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	64	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	awaynames	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	64	Using where; Using join buffer (incremental, BNL join)

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_hbmanager/models/team.php:267
11	HBmanagerModelTeam->getSchedule()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_hbmanager/views/team/view.html.php:32
9	HbManagerViewTeam->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hbmanager/hbmanager.php:15
6	require_once JROOT/components/com_hbmanager/hbmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.68 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.053 MB Speichernutzung vor Abfrage: 8.806 MB Zeilen zurückgegeben: 18

Doppelte Abfragen: #17

SELECT *, IF(`home` = 'HK Ostd/Geisl 3',1,0) as homegame, (
  CASE WHEN `pointsHome` > `pointsAway` THEN 1 WHEN `pointsHome` < `pointsAway` THEN 2 WHEN (`pointsHome` = `pointsAway`) 
  AND`pointsHome` IS NOT NULL THEN 0 ELSE NULL END ) AS `result`,
				homenames.teamname_long AS home_long, homenames.teamname_short AS home_short, homenames.teamname_abbr AS home_abbr,
				awaynames.teamname_long AS away_long, awaynames.teamname_short AS away_short, awaynames.teamname_abbr AS away_abbr 

  FROM `hkog_hb_game`

  LEFT JOIN `hkog_hb_gamereport` USING (`gameIdHvw`, `season`)

  LEFT JOIN `hkog_hb_gym` USING (`gymId`)

  LEFT JOIN `hkog_hb_clubteams` AS homenames 
  ON `home`=`homenames`.`teamname_short`

  LEFT JOIN `hkog_hb_clubteams` AS awaynames 
  ON `away`=`awaynames`.`teamname_short`

  WHERE `teamkey` = 'M-3' 
  AND `season` = '2021-2022' 
  AND (`home` = 'HK Ostd/Geisl 3' OR `away` = 'HK Ostd/Geisl 3')

  ORDER BY `dateTime`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hkog_hb_game	ref	PRIMARY	PRIMARY	32	const	683	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	hkog_hb_gamereport	eq_ref	season	season	37	d01e9191.hkog_hb_game.season,d01e9191.hkog_hb_game.gameIdHvw	1
1	SIMPLE	hkog_hb_gym	eq_ref	PRIMARY	PRIMARY	4	d01e9191.hkog_hb_game.gymId	1	Using where
1	SIMPLE	homenames	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	64	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	awaynames	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	64	Using where; Using join buffer (incremental, BNL join)

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1811
12	JDatabaseDriver->loadRowList()	JROOT/components/com_hbmanager/models/team.php:271
11	HBmanagerModelTeam->getSchedule()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_hbmanager/views/team/view.html.php:32
9	HbManagerViewTeam->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hbmanager/hbmanager.php:15
6	require_once JROOT/components/com_hbmanager/hbmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.36 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 8.811 MB Zeilen zurückgegeben: 10

Doppelte Abfragen: #20

SELECT *

  FROM `hkog_hb_standings`

  LEFT JOIN `hkog_hb_clubteams` 
  ON `team`=`teamname_long`

  WHERE `teamkey` = 'M-3' 
  AND `season` = '2021-2022'

  ORDER BY `rank`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hkog_hb_standings	ref	PRIMARY	PRIMARY	64	const,const	10	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	hkog_hb_clubteams	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	64	Using where; Using join buffer (flat, BNL join)

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_hbmanager/models/team.php:399
12	HBmanagerModelTeam->getStandingsStandard()	JROOT/components/com_hbmanager/models/team.php:382
11	HBmanagerModelTeam->getStandings()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_hbmanager/views/team/view.html.php:34
9	HbManagerViewTeam->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hbmanager/hbmanager.php:15
6	require_once JROOT/components/com_hbmanager/hbmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.29 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 8.836 MB Zeilen zurückgegeben: 10

Doppelte Abfragen: #19

SELECT *

  FROM `hkog_hb_standings`

  LEFT JOIN `hkog_hb_clubteams` 
  ON `team`=`teamname_long`

  WHERE `teamkey` = 'M-3' 
  AND `season` = '2021-2022'

  ORDER BY `rank`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hkog_hb_standings	ref	PRIMARY	PRIMARY	64	const,const	10	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	hkog_hb_clubteams	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	64	Using where; Using join buffer (flat, BNL join)

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1811
13	JDatabaseDriver->loadRowList()	JROOT/components/com_hbmanager/models/team.php:401
12	HBmanagerModelTeam->getStandingsStandard()	JROOT/components/com_hbmanager/models/team.php:382
11	HBmanagerModelTeam->getStandings()	JROOT/libraries/src/MVC/View/HtmlView.php:425
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_hbmanager/views/team/view.html.php:34
9	HbManagerViewTeam->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_hbmanager/hbmanager.php:15
6	require_once JROOT/components/com_hbmanager/hbmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.31 ms Nach letzter Abfrage: 3.89 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 10.196 MB Zeilen zurückgegeben: 3

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

  FROM hkog_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2022-05-23 07:20:50') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-05-23 07:20:50') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 177 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Derselbe Aufruf in der Zeile darunter.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/hkogtemplate/index.php:25
7	require JROOT/templates/hkogtemplate/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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]

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

SELECT-Tabellen:

3 × SELECT dateTime 
  FROM `hkog_hb_updatelog`

2 × SELECT *, IF(`home` = 'HK Ostd/Geisl 3',1,0) as homegame, (
  CASE WHEN `pointsHome` > `pointsAway` THEN 1 WHEN `pointsHome` < `pointsAway` THEN 2 WHEN (`pointsHome` = `pointsAway`) 
  AND`pointsHome` IS NOT NULL THEN 0 ELSE NULL END ) AS `result`,
     homenames.teamname_long AS home_long, homenames.teamname_short AS home_short, homenames.teamname_abbr AS home_abbr,
     awaynames.teamname_long AS away_long, awaynames.teamname_short AS away_short, awaynames.teamname_abbr AS away_abbr  
  FROM `hkog_hb_game` 
  LEFT JOIN `hkog_hb_gamereport` USING (`gameIdHvw`, `season`) 
  LEFT JOIN `hkog_hb_gym` USING (`gymId`) 
  LEFT JOIN `hkog_hb_clubteams` AS homenames 
  ON `home`=`homenames`.`teamname_short` 
  LEFT JOIN `hkog_hb_clubteams` AS awaynames 
  ON `away`=`awaynames`.`teamname_short`

2 × SELECT * 
  FROM `hkog_hb_standings` 
  LEFT JOIN `hkog_hb_clubteams` 
  ON `team`=`teamname_long`

1 × SELECT `data` 
  FROM `hkog_session`

1 × SELECT `session_id` 
  FROM `hkog_session`

1 × SELECT id, rules 
  FROM `hkog_viewlevels

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

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM hkog_menu AS m 
  LEFT JOIN hkog_extensions AS e 
  ON m.component_id = e.extension_id

```
1 × SELECT * 
  FROM hkog_languages
```

1 × SELECT id, home, template, s.params 
  FROM hkog_template_styles as s 
  LEFT JOIN hkog_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT *, t1.teamkey AS teamkey 
  FROM hkog_hb_team AS t1 
  LEFT JOIN `hkog_hb_team_picture` AS t2 
  ON t1.teamkey=t2.teamkey 
  AND `season` = '2021-2022'

```
1 × SELECT `path` 
  FROM `hkog_menu`
```

1 × SELECT *, DATE_FORMAT(start, '%H:%i') as start,DATE_FORMAT(end, '%H:%i') as end 
  FROM `hkog_hb_training` 
  LEFT JOIN hkog_hb_gym USING (gymId)

1 × SELECT `alias`, `coachID`, `teamkey`, `rank`, `id`, `name`, `telephone`, `image`, `email_to`, `mobile`, `params` 
  FROM `hkog_hb_team_coach` 
  LEFT JOIN hkog_contact_details USING (alias)

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

Andere Tabellen:

1 × INSERT INTO `hkog_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3237373738636661376437643231333036323433353131646565316632303361', 1, 1653290450, 0, '', 0

1 × UPDATE `hkog_extensions` 
  SET `params` = '{\"mediaversion\":\"1f53e843c4805b7807fc21c9f4cd1880\"}'

Männer 3 Kreisliga B

Training

Spielplan

Tabelle

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

21 ausgeführte Abfragen 43.41 ms

4 Duplikate gefunden!

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

SELECT-Tabellen:

Andere Tabellen: