Tabelle: Europameisterschaft 2020

Platz	Mannschaft	W	D	L	Pts	Results	+/-	LASTGAMES
1	(1)	Italien	3	3	0	0	9	7:0	7
2	(2)	Wales	3	1	1	1	4	3:2	1
3	(3)	Schweiz	3	1	1	1	4	4:5	-1
4	(4)	Türkei	3	0	0	3	0	1:8	-7

Platz	Mannschaft	W	D	L	Results	+/-	LASTGAMES
1	(1)	Belgien	3	3	0	9	7:1	6
2	(2)	Dänemark	3	1	2	3	5:4	1
3	(3)	Finnland	3	1	2	3	1:3	-2
4	(4)	Rußland	3	1	2	3	2:7	-5

Platz	Mannschaft	W	D	L	Results	+/-	LASTGAMES
1	(1)	Niederlande	3	3	0	9	8:2	6
2	(2)	Österreich	3	2	1	6	4:3	1
3	(3)	Ukraine	3	1	2	3	4:5	-1
4	(4)	Nordmazedonien	3	0	3	0	2:8	-6

Platz	Mannschaft	W	D	L	Pts	Results	+/-	LASTGAMES
1	(1)	England	3	2	1	0	7	2:0	2
2	(2)	Kroatien	3	1	1	1	4	4:3	1
3	(3)	Tschechien	3	1	1	1	4	3:2	1
4	(4)	Schottland	3	0	1	2	1	1:5	-4

Platz	Mannschaft	W	D	L	Pts	Results	+/-	LASTGAMES
1	(1)	Schweden	3	2	1	0	7	4:2	2
2	(2)	Spanien	3	1	2	0	5	6:1	5
3	(3)	Slowakei	3	1	0	2	3	2:7	-5
4	(4)	Polen	3	0	1	2	1	4:6	-2

Platz	Mannschaft	W	D	L	Pts	Results	+/-	LASTGAMES
1	(1)	Frankreich	3	1	2	0	5	4:3	1
2	(2)	Deutschland	3	1	1	1	4	6:5	1
3	(3)	Portugal	3	1	1	1	4	7:6	1
4	(4)	Ungarn	3	0	2	1	2	3:6	-3

Platz	Mannschaft	W	D	L	Pts	Results	+/-	LASTGAMES
1	(1)	Italien	2	2	0	0	6	4:0	4
2	(3)	Schweiz	1	1	0	0	3	3:1	2
3	(2)	Wales	1	0	1	0	1	1:1	0
4	(4)	Türkei	2	0	0	2	0	0:5	-5

Platz	Mannschaft	W	D	L	Results	+/-	LASTGAMES
1	(1)	Belgien	1	1	0	3	3:0	3
2	(2)	Dänemark	2	0	2	0	1:3	-2
3	(4)	Rußland	1	0	1	0	1:4	-3
4	(3)	Finnland	2	0	2	0	0:3	-3

Platz	Mannschaft	W	D	L	Results	+/-	LASTGAMES
1	(1)	Niederlande	2	2	0	6	5:2	3
2	(2)	Österreich	1	1	0	3	3:1	2
3	(3)	Ukraine	2	1	1	3	2:2	0
4	(4)	Nordmazedonien	1	0	1	0	0:3	-3

Platz	Mannschaft	W	D	L	Pts	Results	+/-	LASTGAMES
1	(1)	England	2	1	1	0	4	1:0	1
2	(2)	Kroatien	2	1	1	0	4	4:2	2
3	(3)	Tschechien	1	0	0	1	0	0:1	-1
4	(4)	Schottland	1	0	0	1	0	0:2	-2

Platz	Mannschaft	W	D	L	Pts	Results	+/-	LASTGAMES
1	(1)	Schweden	2	2	0	0	6	4:2	2
2	(2)	Spanien	2	0	2	0	2	1:1	0
3	(4)	Polen	1	0	0	1	0	1:2	-1
4	(3)	Slowakei	1	0	0	1	0	0:5	-5

Platz	Mannschaft	W	D	L	Pts	Results	+/-	LASTGAMES
1	(1)	Frankreich	1	1	0	0	3	1:0	1
2	(2)	Deutschland	1	0	1	0	1	2:2	0
3	(3)	Portugal	2	0	1	1	1	4:6	-2
4	(4)	Ungarn	2	0	1	1	1	1:4	-3

Platz	Mannschaft	W	D	L	Pts	Results	+/-	LASTGAMES
1	(1)	Italien	1	1	0	0	3	3:0	3
2	(2)	Wales	2	1	0	1	3	2:1	1
3	(3)	Schweiz	2	0	1	1	1	1:4	-3
4	(4)	Türkei	1	0	0	1	0	1:3	-2

Platz	Mannschaft	W	D	L	Results	+/-	LASTGAMES
1	(1)	Belgien	2	2	0	6	4:1	3
2	(2)	Dänemark	1	1	0	3	4:1	3
3	(3)	Finnland	1	1	0	3	1:0	1
4	(4)	Rußland	2	1	1	3	1:3	-2

Platz	Mannschaft	W	D	L	Results	+/-	LASTGAMES
1	(1)	Niederlande	1	1	0	3	3:0	3
2	(2)	Österreich	2	1	1	3	1:2	-1
3	(3)	Ukraine	1	0	1	0	2:3	-1
4	(4)	Nordmazedonien	2	0	2	0	2:5	-3

Platz	Mannschaft	W	D	L	Pts	Results	+/-	LASTGAMES
1	(3)	Tschechien	2	1	1	0	4	3:1	2
2	(1)	England	1	1	0	0	3	1:0	1
3	(4)	Schottland	2	0	1	1	1	1:3	-2
4	(2)	Kroatien	1	0	0	1	0	0:1	-1

Platz	Mannschaft	W	D	L	Pts	Results	+/-	LASTGAMES
1	(2)	Spanien	1	1	0	0	3	5:0	5
2	(3)	Slowakei	2	1	0	1	3	2:2	0
3	(1)	Schweden	1	0	1	0	1	0:0	0
4	(4)	Polen	2	0	1	1	1	3:4	-1

Platz	Mannschaft	W	D	L	Pts	Results	+/-	LASTGAMES
1	(2)	Deutschland	2	1	0	1	3	4:3	1
2	(3)	Portugal	1	1	0	0	3	3:0	3
3	(1)	Frankreich	2	0	2	0	2	3:3	0
4	(4)	Ungarn	1	0	1	0	1	2:2	0

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1638330740,
                "last": 1638330740,
                "now": 1638330740
            },
            "token": "pMRO4zYRDFM1cQJvr3i0dQ0G5EmiqLmy"
        },
        "registry": {
            "plg_system_eprivacygeoip_cache": {
                "cc": "US",
                "abbr": "USA",
                "name": "United States"
            },
            "com_sportsmanagement": {
                "pid": "0"
            },
            "base_url": "https://esv-knittelfeld.at/"
        },
        "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
        }
    },
    "__easycalccheckplus": {
        "redirectUrl": null,
        "eccLoaded": null
    }
}

Profil zum Laufzeitverhalten

Zeit

Speicher

Zeit: 16.44 ms / 16.44 ms Speicher: 0.404 MB / 0.74 MB Application: afterLoad

Zeit: 77.58 ms / 94.01 ms Speicher: 1.554 MB / 2.30 MB Application: afterInitialise

Zeit: 28.01 ms / 122.02 ms Speicher: 0.336 MB / 2.63 MB Application: afterRoute

Zeit: 0.95 ms / 122.97 ms Speicher: 0.048 MB / 2.68 MB Application: beforeRenderComponent com_sportsmanagement

Zeit: 862.52 ms / 985.49 ms Speicher: 5.380 MB / 8.06 MB Application: afterRenderComponent com_sportsmanagement

Zeit: 5.66 ms / 991.15 ms Speicher: 0.027 MB / 8.09 MB Application: afterDispatch

Zeit: 16.70 ms / 1007.85 ms Speicher: 0.152 MB / 8.24 MB Application: beforeRenderModule mod_s5_box (S5 Box)

Zeit: 0.68 ms / 1008.53 ms Speicher: 0.025 MB / 8.26 MB Application: beforeRenderModule mod_s5_register (S5 Register)

Zeit: 16.92 ms / 1025.45 ms Speicher: 0.208 MB / 8.47 MB Application: Before Access::preloadComponents (all components)

Zeit: 0.93 ms / 1026.38 ms Speicher: 0.051 MB / 8.52 MB Application: After Access::preloadComponents (all components)

Zeit: 0.03 ms / 1026.40 ms Speicher: -0.002 MB / 8.52 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Zeit: 0.51 ms / 1026.91 ms Speicher: 0.008 MB / 8.53 MB Application: After Access::getAssetRules (id:1 name:root.1)

Zeit: 0.80 ms / 1027.71 ms Speicher: -0.018 MB / 8.51 MB Application: afterRenderModule mod_s5_register (S5 Register)

Zeit: 0.03 ms / 1027.74 ms Speicher: -0.006 MB / 8.51 MB Application: beforeRenderModule mod_eprivacy (mod_eprivacy)

Zeit: 2.57 ms / 1030.31 ms Speicher: 0.034 MB / 8.54 MB Application: afterRenderModule mod_eprivacy (mod_eprivacy)

Zeit: 0.42 ms / 1030.73 ms Speicher: -0.014 MB / 8.53 MB Application: afterRenderModule mod_s5_box (S5 Box)

Zeit: 0.04 ms / 1030.76 ms Speicher: -0.005 MB / 8.52 MB Application: beforeRenderModule mod_menu (Bottom Menu)

Zeit: 3.19 ms / 1033.95 ms Speicher: 0.025 MB / 8.55 MB Application: afterRenderModule mod_menu (Bottom Menu)

Zeit: 0.07 ms / 1034.02 ms Speicher: 0.011 MB / 8.56 MB Application: beforeRenderModule mod_jdownloads_latest (jDownloads Latest)

Zeit: 28.92 ms / 1062.95 ms Speicher: 0.179 MB / 8.74 MB Application: Before Access::preloadPermissions (com_jdownloads)

Zeit: 0.58 ms / 1063.53 ms Speicher: 0.056 MB / 8.79 MB Application: After Access::preloadPermissions (com_jdownloads)

Zeit: 0.02 ms / 1063.55 ms Speicher: -0.002 MB / 8.79 MB Application: Before Access::getAssetRules (id:290 name:com_jdownloads.download.56)

Zeit: 0.08 ms / 1063.64 ms Speicher: 0.008 MB / 8.80 MB Application: After Access::getAssetRules (id:290 name:com_jdownloads.download.56)

Zeit: 1.07 ms / 1064.70 ms Speicher: 0.036 MB / 8.83 MB Application: Before Access::getAssetRules (id:286 name:com_jdownloads.download.55)

Zeit: 0.07 ms / 1064.77 ms Speicher: 0.008 MB / 8.84 MB Application: After Access::getAssetRules (id:286 name:com_jdownloads.download.55)

Zeit: 0.56 ms / 1065.33 ms Speicher: 0.033 MB / 8.87 MB Application: Before Access::getAssetRules (id:277 name:com_jdownloads.download.54)

Zeit: 0.02 ms / 1065.35 ms Speicher: 0.002 MB / 8.88 MB Application: After Access::getAssetRules (id:277 name:com_jdownloads.download.54)

Zeit: 0.50 ms / 1065.86 ms Speicher: 0.029 MB / 8.90 MB Application: Before Access::getAssetRules (id:269 name:com_jdownloads.download.49)

Zeit: 0.02 ms / 1065.88 ms Speicher: 0.002 MB / 8.91 MB Application: After Access::getAssetRules (id:269 name:com_jdownloads.download.49)

Zeit: 0.52 ms / 1066.40 ms Speicher: 0.033 MB / 8.94 MB Application: Before Access::getAssetRules (id:263 name:com_jdownloads.download.48)

Zeit: 0.02 ms / 1066.42 ms Speicher: 0.002 MB / 8.94 MB Application: After Access::getAssetRules (id:263 name:com_jdownloads.download.48)

Zeit: 0.52 ms / 1066.94 ms Speicher: 0.034 MB / 8.98 MB Application: Before Access::getAssetRules (id:261 name:com_jdownloads.download.47)

Zeit: 0.02 ms / 1066.96 ms Speicher: 0.002 MB / 8.98 MB Application: After Access::getAssetRules (id:261 name:com_jdownloads.download.47)

Zeit: 2.97 ms / 1069.94 ms Speicher: 0.001 MB / 8.98 MB Application: afterRenderModule mod_jdownloads_latest (jDownloads Latest)

Zeit: 0.12 ms / 1070.06 ms Speicher: -0.276 MB / 8.70 MB Application: beforeRenderModule mod_whosonline (Wer ist Online)

Zeit: 12.93 ms / 1082.98 ms Speicher: 0.056 MB / 8.76 MB Application: afterRenderModule mod_whosonline (Wer ist Online)

Zeit: 0.09 ms / 1083.08 ms Speicher: -0.002 MB / 8.76 MB Application: beforeRenderModule mod_sportsmanagement_clubicons (JSM - Modul Vereins Icons (Kopie))

Zeit: 57.50 ms / 1140.58 ms Speicher: 0.265 MB / 9.02 MB Application: afterRenderModule mod_sportsmanagement_clubicons (JSM - Modul Vereins Icons (Kopie))

Zeit: 0.16 ms / 1140.73 ms Speicher: -0.248 MB / 8.77 MB Application: beforeRenderModule mod_sportsmanagement_ajax_top_navigation_menu (Ligen Top Navigation)

Zeit: 16.05 ms / 1156.79 ms Speicher: 0.243 MB / 9.02 MB Application: afterRenderModule mod_sportsmanagement_ajax_top_navigation_menu (Ligen Top Navigation)

Zeit: 0.10 ms / 1156.88 ms Speicher: -0.124 MB / 8.89 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Zeit: 2.67 ms / 1159.56 ms Speicher: 0.074 MB / 8.97 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Zeit: 0.07 ms / 1159.63 ms Speicher: -0.004 MB / 8.96 MB Application: beforeRenderModule mod_custom (ESV-LOGO)

Zeit: 1.51 ms / 1161.14 ms Speicher: 0.007 MB / 8.97 MB Application: afterRenderModule mod_custom (ESV-LOGO)

Zeit: 41.70 ms / 1202.84 ms Speicher: 1.241 MB / 10.21 MB Application: afterRender

Datenbankabfragen gesamt: 23.17 ms

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

Profil (Profile)

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init for update	0.01 ms
Update	0.09 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	8.80 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 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:856
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:414
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.09 ms Nach letzter Abfrage: 3.04 ms Abfragespeichernutzung: 0.072 MB Speichernutzung vor Abfrage: 1.069 MB Zeilen zurückgegeben: 45

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `z2o57_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z2o57_extensions	ref	extension	extension	82	const	46	Using index condition; Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Derselbe Aufruf in der Zeile darunter.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
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.33 ms Nach letzter Abfrage: 2.50 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.128 MB Zeilen zurückgegeben: 3

SELECT id, rules

  FROM `z2o57_viewlevels`

Explain

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

Profil (Profile)

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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.37 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.139 MB Zeilen zurückgegeben: 1

SELECT b.id

  FROM z2o57_usergroups AS a

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

  WHERE a.id = 1

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	1	Using where; Using index

Profil (Profile)

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.45 ms
Reset for next command	0.01 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: 1.46 ms Nach letzter Abfrage: 0.39 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 1.161 MB Zeilen zurückgegeben: 118

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM z2o57_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Derselbe Aufruf in der Zeile darunter.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
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.64 ms Nach letzter Abfrage: 22.49 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 1.984 MB Zeilen zurückgegeben: 1

SELECT `value`

  FROM `z2o57_admintools_storage`

  WHERE `key` = 'cparams'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z2o57_admintools_storage	const	PRIMARY	PRIMARY	402	const	1

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:122
12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:37
11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:49
10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:409
9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:892
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:695
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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.40 ms Nach letzter Abfrage: 0.38 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.995 MB Zeilen zurückgegeben: 0

SELECT *

  FROM `z2o57_admintools_wafexceptions`

  WHERE NOT(`option` LIKE 'com_%')

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:729
10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:640
9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:901
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:695
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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.78 ms Nach letzter Abfrage: 9.54 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 2.143 MB Zeilen zurückgegeben: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `z2o57_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	z2o57_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
16	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Derselbe Aufruf in der Zeile darunter.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
13	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
12	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
11	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jqueryeasy/jqueryeasy.php:35
7	plgSystemJqueryeasy->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:695
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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.50 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 2.136 MB

UPDATE `z2o57_extensions`

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

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

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
12	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
11	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jqueryeasy/jqueryeasy.php:35
7	plgSystemJqueryeasy->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:695
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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.64 ms Nach letzter Abfrage: 7.72 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.261 MB Zeilen zurückgegeben: 0

SELECT `source`,`keepurlparams`

  FROM `z2o57_admintools_redirects`

  WHERE ((`dest` = 'component/sportsmanagement/ranking/0/0/5084:europameisterschaft-2020/0/132343:finale/0/0/0/0.html') OR (`dest` = 'component/sportsmanagement/ranking/0/0/5084:europameisterschaft-2020/0/132343:finale/0/0/0/0.html') OR ('component/sportsmanagement/ranking/0/0/5084:europameisterschaft-2020/0/132343:finale/0/0/0/0.html' LIKE `dest`)) 
  AND `published` = '1'

  ORDER BY `ordering` DESC 
  LIMIT 1

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
11	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:91
10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:696
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
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.98 ms Nach letzter Abfrage: 5.83 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 2.335 MB Zeilen zurückgegeben: 5

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 z2o57_menu AS m

  LEFT JOIN z2o57_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	idx_client_id_parent_id_alias_language	1	const	39	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	siga_esv.m.component_id	1	Using where

Profil (Profile)

Status	Duration
Starting	0.16 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	1.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	3.56 ms
Reset for next command	0.02 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:445
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:561
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:1169
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: 1.23 ms Nach letzter Abfrage: 13.36 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 2.550 MB Zeilen zurückgegeben: 212

SHOW TABLES

Explain

„EXPLAIN“ unmöglich für Abfrage: SHOW TABLES

Profil (Profile)

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
checking permissions	0.80 ms
Executing	0.00 ms
Sending data	0.10 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.01 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.03 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:220
8	plgSystemjdownloads->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1218
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.41 ms Nach letzter Abfrage: 3.05 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 2.604 MB Zeilen zurückgegeben: 2

SELECT *

  FROM z2o57_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
12	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
11	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/components/com_k2/helpers/utilities.php:243
10	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:235
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:438
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1218
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.62 ms Nach letzter Abfrage: 0.89 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 2.621 MB Zeilen zurückgegeben: 5

SELECT id, home, template, s.params

  FROM z2o57_template_styles as s

  LEFT JOIN z2o57_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	8	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	siga_esv.s.template,const	1	Using index condition; Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
19	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
18	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
17	Joomla\CMS\HTML\HTMLHelper::script()	Derselbe Aufruf in der Zeile darunter.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
13	JHtmlJquery::framework()	Derselbe Aufruf in der Zeile darunter.
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_k2/helpers/html.php:259
9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:438
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1218
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: 3.34 ms Nach letzter Abfrage: 48.17 ms Abfragespeichernutzung: 0.082 MB Speichernutzung vor Abfrage: 4.425 MB Zeilen zurückgegeben: 24

SELECT tl.id AS projectteamid,tl.division_id,tl.standard_playground,tl.admin,tl.start_points,tl.points_finally,tl.neg_points_finally,tl.matches_finally,tl.won_finally,tl.draws_finally,tl.lost_finally,tl.homegoals_finally,tl.guestgoals_finally,tl.diffgoals_finally,tl.info,tl.reason,tl.team_id as project_team_team_id,tl.checked_out,tl.checked_out_time,tl.is_in_score,tl.picture AS projectteam_picture,IF((ISNULL(tl.picture) OR (tl.picture="")),(IF((ISNULL(t.picture) OR (t.picture="")), c.logo_small , t.picture)) , t.picture) as picture,tl.project_id,t.picture as team_picture,t.id,t.name,t.short_name,t.middle_name,t.notes,t.club_id,u.username,u.email,st.team_id,c.email as club_email,c.phone as club_phone,c.fax as club_fax,c.logo_small,c.logo_middle,c.logo_big,c.country,c.website,c.new_club_id,c.facebook,c.twitter,d.name AS division_name,d.shortname AS division_shortname,d.parent_id AS parent_division_id,plg.name AS playground_name,plg.short_name AS playground_short_name, c.trikot_home, c.trikot_away,CONCAT_WS(':',p.id,p.alias) AS project_slug,CONCAT_WS(':',t.id,t.alias) AS team_slug,CONCAT_WS(':',tl.id,t.alias) AS projectteam_slug,CONCAT_WS(':',d.id,d.alias) AS division_slug,CONCAT_WS(':',c.id,c.alias) AS club_slug,t.name as team_name,t.short_name,t.middle_name,t.club_id,t.website AS team_www,t.picture as team_picture,c.name as club_name,c.address as club_address,c.zipcode as club_zipcode,c.state as club_state,c.location as club_location,c.unique_id,c.country as club_country,c.website AS club_www

  FROM z2o57_sportsmanagement_project_team AS tl 

  LEFT JOIN  z2o57_sportsmanagement_season_team_id st 
  ON st.id = tl.team_id 

  LEFT JOIN  z2o57_sportsmanagement_team t 
  ON st.team_id = t.id 

  LEFT JOIN  z2o57_users u 
  ON tl.admin=u.id 

  LEFT JOIN  z2o57_sportsmanagement_club c 
  ON t.club_id = c.id 

  LEFT JOIN  z2o57_sportsmanagement_division d 
  ON d.id = tl.division_id 

  LEFT JOIN  z2o57_sportsmanagement_playground plg 
  ON plg.id = tl.standard_playground 

  LEFT JOIN  z2o57_sportsmanagement_project AS p 
  ON p.id = tl.project_id 

  WHERE tl.project_id = 5084

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tl	ref	combi,project_id	project_id	4	const	21
1	SIMPLE	st	eq_ref	PRIMARY	PRIMARY	4	siga_esv.tl.team_id	1
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	siga_esv.st.team_id	1	Using where
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	siga_esv.tl.admin	1
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	siga_esv.t.club_id	1	Using where
1	SIMPLE	d	eq_ref	PRIMARY	PRIMARY	4	siga_esv.tl.division_id	1	Using where
1	SIMPLE	plg	eq_ref	PRIMARY	PRIMARY	4	siga_esv.tl.standard_playground	1	Using where
1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/components/com_sportsmanagement/models/project.php:929
8	sportsmanagementModelProject::_getTeams()	JROOT/components/com_sportsmanagement/models/project.php:870
7	sportsmanagementModelProject::getTeams()	JROOT/components/com_sportsmanagement/sportsmanagement.php:281
6	require_once JROOT/components/com_sportsmanagement/sportsmanagement.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]

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

SELECT-Tabellen:

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `z2o57_extensions`

1 × SELECT `session_id` 
  FROM `z2o57_session`

1 × SELECT id, rules 
  FROM `z2o57_viewlevels

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM z2o57_extensions

1 × SELECT `value` 
  FROM `z2o57_admintools_storage`

1 × SELECT * 
  FROM `z2o57_admintools_wafexceptions`

1 × SELECT `source`,`keepurlparams` 
  FROM `z2o57_admintools_redirects`

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 z2o57_menu AS m 
  LEFT JOIN z2o57_extensions AS e 
  ON m.component_id = e.extension_id

```
1 × SELECT * 
  FROM z2o57_languages
```

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

1 × SELECT tl.id AS projectteamid,tl.division_id,tl.standard_playground,tl.admin,tl.start_points,tl.points_finally,tl.neg_points_finally,tl.matches_finally,tl.won_finally,tl.draws_finally,tl.lost_finally,tl.homegoals_finally,tl.guestgoals_finally,tl.diffgoals_finally,tl.info,tl.reason,tl.team_id as project_team_team_id,tl.checked_out,tl.checked_out_time,tl.is_in_score,tl.picture AS projectteam_picture,IF((ISNULL(tl.picture) OR (tl.picture="")),(IF((ISNULL(t.picture) OR (t.picture="")), c.logo_small , t.picture)) , t.picture) as picture,tl.project_id,t.picture as team_picture,t.id,t.name,t.short_name,t.middle_name,t.notes,t.club_id,u.username,u.email,st.team_id,c.email as club_email,c.phone as club_phone,c.fax as club_fax,c.logo_small,c.logo_middle,c.logo_big,c.country,c.website,c.new_club_id,c.facebook,c.twitter,d.name AS division_name,d.shortname AS division_shortname,d.parent_id AS parent_division_id,plg.name AS playground_name,plg.short_name AS playground_short_name, c.trikot_home, c.trikot_away,CONCAT_WS(':',p.id,p.alias) AS project_slug,CONCAT_WS(':',t.id,t.alias) AS team_slug,CONCAT_WS(':',tl.id,t.alias) AS projectteam_slug,CONCAT_WS(':',d.id,d.alias) AS division_slug,CONCAT_WS(':',c.id,c.alias) AS club_slug,t.name as team_name,t.short_name,t.middle_name,t.club_id,t.website AS team_www,t.picture as team_picture,c.name as club_name,c.address as club_address,c.zipcode as club_zipcode,c.state as club_state,c.location as club_location,c.unique_id,c.country as club_country,c.website AS club_www 
  FROM z2o57_sportsmanagement_project_team AS tl  
  LEFT JOIN  z2o57_sportsmanagement_season_team_id st 
  ON st.id = tl.team_id  
  LEFT JOIN  z2o57_sportsmanagement_team t 
  ON st.team_id = t.id  
  LEFT JOIN  z2o57_users u 
  ON tl.admin=u.id  
  LEFT JOIN  z2o57_sportsmanagement_club c 
  ON t.club_id = c.id  
  LEFT JOIN  z2o57_sportsmanagement_division d 
  ON d.id = tl.division_id  
  LEFT JOIN  z2o57_sportsmanagement_playground plg 
  ON plg.id = tl.standard_playground  
  LEFT JOIN  z2o57_sportsmanagement_project AS p 
  ON p.id = tl.project_id

Andere Tabellen:

1 × INSERT INTO `z2o57_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'63396c65346e35696a656f756c6e3670306e38756a33666d7474', 1, 1638330740, 0, '', 0

1 × UPDATE `z2o57_extensions` 
  SET `params` = '{\"mediaversion\":\"c834bf5b5b5220b71adad03160592b5b\"}'

```
1 × SHOW TABLE
```

Ligen Top Navigation

Fußball

JSM - Modul Vereins Icons (Kopie)

Wer ist Online

jDownloads Latest

S5 Register

mod_eprivacy

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

1191 ausgeführte Abfragen 23.17 ms

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

SELECT-Tabellen:

Andere Tabellen: