Tabelle: Serie A 2020/21

Platz	Mannschaft	G	U	V	Tore	+/-	Pkt.	Letzte Spiele
1	(1)	Inter	38	28	7	3	89:35	54	91
2	(4)	AC Milan	38	24	7	7	74:41	33	79
3	(2)	Atalanta	38	23	9	6	90:47	43	78
4	(5)	Juventus	38	23	9	6	77:38	39	78
5	(3)	SSC Napoli	38	24	5	9	86:41	45	77
6	(6)	Lazio Roma	38	21	5	12	61:55	6	68
7	(7)	AS Roma	38	18	8	12	68:58	10	62
8	(8)	Sassuolo Calcio	38	17	11	10	64:56	8	62
9	(9)	Sampdoria	38	15	7	16	52:54	-2	52
10	(10)	Hellas Verona	38	11	12	15	46:48	-2	45
11	(14)	Genoa CFC	38	10	12	16	47:58	-11	42
12	(11)	Bologna FC	38	10	11	17	51:65	-14	41
13	(13)	ACF Fiorentina	38	9	13	16	47:59	-12	40
14	(12)	Udinese Calcio	38	10	10	18	42:58	-16	40
15	(15)	Spezia Calcio	38	9	12	17	52:72	-20	39
16	(16)	Cagliari Calcio	38	9	10	19	43:59	-16	37
17	(17)	Torino FC	38	7	16	15	50:69	-19	37
18	(18)	Benevento Calcio	38	7	12	19	40:75	-35	33
19	(19)	FC Crotone	38	6	5	27	45:92	-47	23
20	(20)	Parma Calcio 1913	38	3	11	24	39:83	-44	20

Platz	Mannschaft	G	U	V	Tore	+/-	Pkt.	Letzte Spiele
1	(1)	Inter	19	17	1	1	53:18	35	52
2	(5)	Juventus	19	14	2	3	40:18	22	44
3	(7)	AS Roma	19	13	4	2	42:18	24	43
4	(6)	Lazio Roma	19	13	3	3	36:23	13	42
5	(3)	SSC Napoli	19	12	4	3	50:20	30	40
6	(2)	Atalanta	19	12	3	4	49:24	25	39
7	(4)	AC Milan	19	8	6	5	31:24	7	30
8	(9)	Sampdoria	19	9	3	7	32:26	6	30
9	(8)	Sassuolo Calcio	19	7	8	4	31:27	4	29
10	(11)	Bologna FC	19	7	5	7	33:33	0	26
11	(13)	ACF Fiorentina	19	6	6	7	25:25	0	24
12	(10)	Hellas Verona	19	6	6	7	23:23	0	24
13	(14)	Genoa CFC	19	5	7	7	29:30	-1	22
14	(15)	Spezia Calcio	19	5	7	7	28:33	-5	22
15	(16)	Cagliari Calcio	19	5	4	10	22:32	-10	19
16	(12)	Udinese Calcio	19	5	4	10	14:19	-5	19
17	(17)	Torino FC	19	3	9	7	25:36	-11	18
18	(19)	FC Crotone	19	5	2	12	23:35	-12	17
19	(18)	Benevento Calcio	19	2	7	10	19:39	-20	13
20	(20)	Parma Calcio 1913	19	2	5	12	16:39	-23	11

Platz	Mannschaft	G	U	V	Tore	+/-	Pkt.	Letzte Spiele
1	(4)	AC Milan	19	16	1	2	43:17	26	49
2	(1)	Inter	19	11	6	2	36:17	19	39
3	(2)	Atalanta	19	11	6	2	41:23	18	39
4	(3)	SSC Napoli	19	12	1	6	36:21	15	37
5	(5)	Juventus	19	9	7	3	37:20	17	34
6	(8)	Sassuolo Calcio	19	10	3	6	33:29	4	33
7	(6)	Lazio Roma	19	8	2	9	25:32	-7	26
8	(9)	Sampdoria	19	6	4	9	20:28	-8	22
9	(10)	Hellas Verona	19	5	6	8	23:25	-2	21
10	(12)	Udinese Calcio	19	5	6	8	28:39	-11	21
11	(18)	Benevento Calcio	19	5	5	9	21:36	-15	20
12	(14)	Genoa CFC	19	5	5	9	18:28	-10	20
13	(17)	Torino FC	19	4	7	8	25:33	-8	19
14	(7)	AS Roma	19	5	4	10	26:40	-14	19
15	(16)	Cagliari Calcio	19	4	6	9	21:27	-6	18
16	(15)	Spezia Calcio	19	4	5	10	24:39	-15	17
17	(13)	ACF Fiorentina	19	3	7	9	22:34	-12	16
18	(11)	Bologna FC	19	3	6	10	18:32	-14	15
19	(20)	Parma Calcio 1913	19	1	6	12	23:44	-21	9
20	(19)	FC Crotone	19	1	3	15	22:57	-35	6

Platz	Mannschaft	G	U	V	Tore	+/-	Pkt.	Letzte Spiele
1	(4)	AC Milan	19	13	4	2	39:22	17	43
2	(1)	Inter	19	12	5	2	45:23	22	41
3	(5)	Juventus	19	11	6	2	39:19	20	39
4	(7)	AS Roma	19	11	4	4	41:32	9	37
5	(2)	Atalanta	19	10	6	3	44:23	21	36
6	(6)	Lazio Roma	19	10	4	5	32:26	6	34
7	(3)	SSC Napoli	19	11	1	7	42:21	21	34
8	(8)	Sassuolo Calcio	19	8	6	5	32:29	3	30
9	(10)	Hellas Verona	19	8	6	5	25:18	7	30
10	(9)	Sampdoria	19	8	2	9	30:29	1	26
11	(18)	Benevento Calcio	19	6	4	9	23:36	-13	22
12	(13)	ACF Fiorentina	19	5	6	8	20:30	-10	21
13	(11)	Bologna FC	19	5	5	9	24:33	-9	20
14	(12)	Udinese Calcio	19	4	6	9	20:28	-8	18
15	(15)	Spezia Calcio	19	4	6	9	26:36	-10	18
16	(14)	Genoa CFC	19	4	6	9	19:30	-11	18
17	(16)	Cagliari Calcio	19	3	5	11	23:37	-14	14
18	(17)	Torino FC	19	2	8	9	28:37	-9	14
19	(20)	Parma Calcio 1913	19	2	7	10	14:36	-22	13
20	(19)	FC Crotone	19	3	3	13	22:43	-21	12

Platz	Mannschaft	G	U	V	Tore	+/-	Pkt.	Letzte Spiele
1	(1)	Inter	19	16	2	1	44:12	32	50
2	(3)	SSC Napoli	19	13	4	2	44:20	24	43
3	(2)	Atalanta	19	13	3	3	46:24	22	42
4	(5)	Juventus	19	12	3	4	38:19	19	39
5	(4)	AC Milan	19	11	3	5	35:19	16	36
6	(6)	Lazio Roma	19	11	1	7	29:29	0	34
7	(8)	Sassuolo Calcio	19	9	5	5	32:27	5	32
8	(9)	Sampdoria	19	7	5	7	22:25	-3	26
9	(7)	AS Roma	19	7	4	8	27:26	1	25
10	(14)	Genoa CFC	19	6	6	7	28:28	0	24
11	(17)	Torino FC	19	5	8	6	22:32	-10	23
12	(16)	Cagliari Calcio	19	6	5	8	20:22	-2	23
13	(12)	Udinese Calcio	19	6	4	9	22:30	-8	22
14	(11)	Bologna FC	19	5	6	8	27:32	-5	21
15	(15)	Spezia Calcio	19	5	6	8	26:36	-10	21
16	(13)	ACF Fiorentina	19	4	7	8	27:29	-2	19
17	(10)	Hellas Verona	19	3	6	10	21:30	-9	15
18	(18)	Benevento Calcio	19	1	8	10	17:39	-22	11
19	(19)	FC Crotone	19	3	2	14	23:49	-26	11
20	(20)	Parma Calcio 1913	19	1	4	14	25:47	-22	7

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1638328383,
                "last": 1638328383,
                "now": 1638328383
            },
            "token": "sfdwQHheceXDvIwBGoEILSIiI301mOTg"
        },
        "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: 44.52 ms / 44.52 ms Speicher: 0.539 MB / 0.88 MB Application: afterLoad

Zeit: 1039.35 ms / 1083.87 ms Speicher: 2.083 MB / 2.96 MB Application: afterInitialise

Zeit: 85.94 ms / 1169.81 ms Speicher: 0.411 MB / 3.37 MB Application: afterRoute

Zeit: 1.28 ms / 1171.09 ms Speicher: 0.048 MB / 3.42 MB Application: beforeRenderComponent com_sportsmanagement

Zeit: 3397.59 ms / 4568.68 ms Speicher: 6.090 MB / 9.51 MB Application: afterRenderComponent com_sportsmanagement

Zeit: 6.94 ms / 4575.62 ms Speicher: 0.028 MB / 9.54 MB Application: afterDispatch

Zeit: 54.40 ms / 4630.02 ms Speicher: 0.218 MB / 9.76 MB Application: beforeRenderModule mod_s5_box (S5 Box)

Zeit: 1.89 ms / 4631.91 ms Speicher: 0.025 MB / 9.78 MB Application: beforeRenderModule mod_s5_register (S5 Register)

Zeit: 53.69 ms / 4685.60 ms Speicher: 0.216 MB / 10.00 MB Application: Before Access::preloadComponents (all components)

Zeit: 1.20 ms / 4686.80 ms Speicher: 0.051 MB / 10.05 MB Application: After Access::preloadComponents (all components)

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

Zeit: 1.48 ms / 4688.32 ms Speicher: 0.008 MB / 10.05 MB Application: After Access::getAssetRules (id:1 name:root.1)

Zeit: 7.05 ms / 4695.37 ms Speicher: 0.045 MB / 10.10 MB Application: afterRenderModule mod_s5_register (S5 Register)

Zeit: 0.05 ms / 4695.42 ms Speicher: -0.006 MB / 10.09 MB Application: beforeRenderModule mod_eprivacy (mod_eprivacy)

Zeit: 3.93 ms / 4699.35 ms Speicher: 0.035 MB / 10.13 MB Application: afterRenderModule mod_eprivacy (mod_eprivacy)

Zeit: 0.55 ms / 4699.90 ms Speicher: -0.014 MB / 10.11 MB Application: afterRenderModule mod_s5_box (S5 Box)

Zeit: 0.05 ms / 4699.95 ms Speicher: -0.005 MB / 10.11 MB Application: beforeRenderModule mod_menu (Bottom Menu)

Zeit: 7.32 ms / 4707.27 ms Speicher: 0.025 MB / 10.13 MB Application: afterRenderModule mod_menu (Bottom Menu)

Zeit: 0.11 ms / 4707.38 ms Speicher: 0.011 MB / 10.14 MB Application: beforeRenderModule mod_jdownloads_latest (jDownloads Latest)

Zeit: 70.53 ms / 4777.91 ms Speicher: 0.242 MB / 10.39 MB Application: Before Access::preloadPermissions (com_jdownloads)

Zeit: 0.86 ms / 4778.78 ms Speicher: 0.056 MB / 10.44 MB Application: After Access::preloadPermissions (com_jdownloads)

Zeit: 0.03 ms / 4778.81 ms Speicher: -0.002 MB / 10.44 MB Application: Before Access::getAssetRules (id:290 name:com_jdownloads.download.56)

Zeit: 0.13 ms / 4778.94 ms Speicher: 0.008 MB / 10.45 MB Application: After Access::getAssetRules (id:290 name:com_jdownloads.download.56)

Zeit: 5.88 ms / 4784.81 ms Speicher: 0.036 MB / 10.48 MB Application: Before Access::getAssetRules (id:286 name:com_jdownloads.download.55)

Zeit: 0.12 ms / 4784.93 ms Speicher: 0.008 MB / 10.49 MB Application: After Access::getAssetRules (id:286 name:com_jdownloads.download.55)

Zeit: 0.69 ms / 4785.63 ms Speicher: 0.033 MB / 10.53 MB Application: Before Access::getAssetRules (id:277 name:com_jdownloads.download.54)

Zeit: 0.03 ms / 4785.66 ms Speicher: 0.002 MB / 10.53 MB Application: After Access::getAssetRules (id:277 name:com_jdownloads.download.54)

Zeit: 0.65 ms / 4786.31 ms Speicher: 0.029 MB / 10.56 MB Application: Before Access::getAssetRules (id:269 name:com_jdownloads.download.49)

Zeit: 0.03 ms / 4786.33 ms Speicher: 0.002 MB / 10.56 MB Application: After Access::getAssetRules (id:269 name:com_jdownloads.download.49)

Zeit: 0.68 ms / 4787.01 ms Speicher: 0.033 MB / 10.59 MB Application: Before Access::getAssetRules (id:263 name:com_jdownloads.download.48)

Zeit: 0.03 ms / 4787.04 ms Speicher: 0.002 MB / 10.59 MB Application: After Access::getAssetRules (id:263 name:com_jdownloads.download.48)

Zeit: 0.67 ms / 4787.71 ms Speicher: 0.034 MB / 10.63 MB Application: Before Access::getAssetRules (id:261 name:com_jdownloads.download.47)

Zeit: 0.03 ms / 4787.74 ms Speicher: 0.002 MB / 10.63 MB Application: After Access::getAssetRules (id:261 name:com_jdownloads.download.47)

Zeit: 5.49 ms / 4793.23 ms Speicher: 0.001 MB / 10.63 MB Application: afterRenderModule mod_jdownloads_latest (jDownloads Latest)

Zeit: 0.19 ms / 4793.41 ms Speicher: -0.276 MB / 10.35 MB Application: beforeRenderModule mod_whosonline (Wer ist Online)

Zeit: 15.34 ms / 4808.75 ms Speicher: 0.056 MB / 10.41 MB Application: afterRenderModule mod_whosonline (Wer ist Online)

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

Zeit: 82.06 ms / 4890.89 ms Speicher: 0.217 MB / 10.62 MB Application: afterRenderModule mod_sportsmanagement_clubicons (JSM - Modul Vereins Icons (Kopie))

Zeit: 0.15 ms / 4891.04 ms Speicher: -0.208 MB / 10.42 MB Application: beforeRenderModule mod_sportsmanagement_ajax_top_navigation_menu (Ligen Top Navigation)

Zeit: 29.31 ms / 4920.35 ms Speicher: 0.291 MB / 10.71 MB Application: afterRenderModule mod_sportsmanagement_ajax_top_navigation_menu (Ligen Top Navigation)

Zeit: 0.15 ms / 4920.50 ms Speicher: -0.168 MB / 10.54 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Zeit: 5.87 ms / 4926.37 ms Speicher: 0.012 MB / 10.55 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Zeit: 0.13 ms / 4926.50 ms Speicher: -0.004 MB / 10.55 MB Application: beforeRenderModule mod_custom (ESV-LOGO)

Zeit: 2.41 ms / 4928.91 ms Speicher: 0.008 MB / 10.55 MB Application: afterRenderModule mod_custom (ESV-LOGO)

Zeit: 77.33 ms / 5006.25 ms Speicher: 1.648 MB / 12.20 MB Application: afterRender

Datenbankabfragen gesamt: 266.24 ms

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

#	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: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

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

Profil (Profile)

Status	Duration
Starting	0.07 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 for update	0.03 ms
Update	0.12 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	254.27 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: 0.82 ms Nach letzter Abfrage: 19.96 ms Abfragespeichernutzung: 0.072 MB Speichernutzung vor Abfrage: 1.403 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.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.03 ms
Executing	0.01 ms
Sending data	0.42 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 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.31 ms Nach letzter Abfrage: 8.55 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.462 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.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 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.38 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.474 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.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 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.58 ms Nach letzter Abfrage: 2.83 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 1.495 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.07 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.06 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.13 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
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.31 ms Nach letzter Abfrage: 545.31 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 2.455 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.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.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 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.00 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: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.38 ms Nach letzter Abfrage: 4.94 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.465 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.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.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.11 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 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.47 ms Nach letzter Abfrage: 64.85 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 2.743 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.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.02 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.05 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
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.35 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 2.735 MB

UPDATE `z2o57_extensions`

  SET `params` = '{\"mediaversion\":\"32e3a0a2d59576fd39b8517c7a9fe20a\"}'

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

Explain

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

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.07 ms
Updating	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.02 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.05 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/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.46 ms Nach letzter Abfrage: 41.48 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.862 MB Zeilen zurückgegeben: 0

SELECT `source`,`keepurlparams`

  FROM `z2o57_admintools_redirects`

  WHERE ((`dest` = 'component/sportsmanagement/ranking/0/0/4954:serie-a-2020-21/0/128980:38-spieltag/0/0/0/0.html') OR (`dest` = 'component/sportsmanagement/ranking/0/0/4954:serie-a-2020-21/0/128980:38-spieltag/0/0/0/0.html') OR ('component/sportsmanagement/ranking/0/0/4954:serie-a-2020-21/0/128980:38-spieltag/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.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.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.09 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 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.14 ms Nach letzter Abfrage: 53.32 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 3.000 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.09 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.06 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.59 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.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 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.38 ms Nach letzter Abfrage: 44.55 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 3.289 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.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
checking permissions	0.84 ms
Executing	0.01 ms
Sending data	0.12 ms
End of update loop	0.09 ms
Query end	0.02 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.02 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.44 ms Nach letzter Abfrage: 9.11 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.343 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.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.03 ms
Optimizing	0.01 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.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 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.63 ms Nach letzter Abfrage: 4.73 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 3.360 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.07 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.12 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.15 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.00 ms
Freeing items	0.01 ms
Updating status	0.01 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: 2.17 ms Nach letzter Abfrage: 188.62 ms Abfragespeichernutzung: 0.078 MB Speichernutzung vor Abfrage: 5.292 MB Zeilen zurückgegeben: 20

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 = 4954

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	18
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.30 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.13 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	1.17 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.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 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'7037656361666463647674736c7473636a6c71676d6d64717468', 1, 1638328383,

Ligen Top Navigation

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

1028 ausgeführte Abfragen 266.24 ms

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

SELECT-Tabellen:

Andere Tabellen: