Tabelle: Serie B 2020/21

Platz	Mannschaft	G	U	V	Tore	+/-	Pkt.	Letzte Spiele
1	(1)	Empoli FC	38	19	16	3	68:35	33	73
2	(2)	US Salernitana 1919	38	19	12	7	46:34	12	69
3	(3)	AC Monza	38	17	13	8	51:33	18	64
4	(4)	US Lecce	38	16	14	8	68:47	21	62
5	(5)	AC Venezia	38	15	14	9	53:39	14	59
6	(6)	AS Cittadella	38	15	12	11	48:35	13	57
7	(7)	Brescia Calcio	38	15	11	12	61:53	8	56
8	(8)	Chievo Verona	38	14	14	10	50:37	13	56
9	(9)	SPAL 2013 Ferrara	38	14	14	10	44:42	2	56
10	(12)	Frosinone Calcio	38	12	14	12	38:42	-4	50
11	(10)	Reggina 1914	38	12	14	12	42:45	-3	50
12	(14)	Lanerossi Vicenza Virtus	38	11	15	12	48:53	-5	48
13	(11)	US Cremonese	38	12	12	14	46:44	2	48
14	(13)	AC Pisa	38	11	15	12	54:59	-5	48
15	(16)	Pordenone Calcio	38	10	15	13	40:39	1	45
16	(15)	Ascoli Calcio	38	11	11	16	37:48	-11	44
17	(17)	Cosenza Calcio	38	6	17	15	29:47	-18	35
18	(18)	AC Reggiana 1919	38	9	7	22	31:57	-26	34
19	(19)	Pescara Calcio	38	7	11	20	29:60	-31	32
20	(20)	Virtus Entella	38	4	11	23	30:64	-34	23

Platz	Mannschaft	G	U	V	Tore	+/-	Pkt.	Letzte Spiele
1	(1)	Empoli FC	19	11	8	0	38:15	23	41
2	(2)	US Salernitana 1919	19	11	6	2	26:13	13	39
3	(8)	Chievo Verona	19	10	5	4	29:14	15	35
4	(6)	AS Cittadella	19	9	7	3	25:14	11	34
5	(3)	AC Monza	19	9	6	4	27:16	11	33
6	(5)	AC Venezia	19	10	3	6	28:19	9	33
7	(7)	Brescia Calcio	19	9	5	5	36:27	9	32
8	(13)	AC Pisa	19	7	10	2	26:19	7	31
9	(9)	SPAL 2013 Ferrara	19	8	6	5	25:19	6	30
10	(15)	Ascoli Calcio	19	8	5	6	18:19	-1	29
11	(10)	Reggina 1914	19	8	4	7	20:22	-2	28
12	(4)	US Lecce	19	6	9	4	36:28	8	27
13	(11)	US Cremonese	19	7	6	6	27:22	5	27
14	(16)	Pordenone Calcio	19	5	10	4	27:19	8	25
15	(14)	Lanerossi Vicenza Virtus	19	5	9	5	22:24	-2	24
16	(18)	AC Reggiana 1919	19	6	5	8	19:23	-4	23
17	(12)	Frosinone Calcio	19	4	9	6	16:21	-5	21
18	(17)	Cosenza Calcio	19	3	9	7	15:20	-5	18
19	(19)	Pescara Calcio	19	4	5	10	18:29	-11	17
20	(20)	Virtus Entella	19	3	4	12	17:35	-18	13

Platz	Mannschaft	G	U	V	Tore	+/-	Pkt.	Letzte Spiele
1	(4)	US Lecce	19	10	5	4	32:19	13	35
2	(1)	Empoli FC	19	8	8	3	30:20	10	32
3	(3)	AC Monza	19	8	7	4	24:17	7	31
4	(2)	US Salernitana 1919	19	8	6	5	20:21	-1	30
5	(12)	Frosinone Calcio	19	8	5	6	22:21	1	29
6	(5)	AC Venezia	19	5	11	3	25:20	5	26
7	(9)	SPAL 2013 Ferrara	19	6	8	5	19:23	-4	26
8	(7)	Brescia Calcio	19	6	6	7	25:26	-1	24
9	(14)	Lanerossi Vicenza Virtus	19	6	6	7	26:29	-3	24
10	(6)	AS Cittadella	19	6	5	8	23:21	2	23
11	(10)	Reggina 1914	19	4	10	5	22:23	-1	22
12	(8)	Chievo Verona	19	4	9	6	21:23	-2	21
13	(11)	US Cremonese	19	5	6	8	19:22	-3	21
14	(16)	Pordenone Calcio	19	5	5	9	13:20	-7	20
15	(13)	AC Pisa	19	4	5	10	28:40	-12	17
16	(17)	Cosenza Calcio	19	3	8	8	14:27	-13	17
17	(15)	Ascoli Calcio	19	3	6	10	19:29	-10	15
18	(19)	Pescara Calcio	19	3	6	10	11:31	-20	15
19	(18)	AC Reggiana 1919	19	3	2	14	12:34	-22	11
20	(20)	Virtus Entella	19	1	7	11	13:29	-16	10

Platz	Mannschaft	G	U	V	Tore	+/-	Pkt.	Letzte Spiele
1	(1)	Empoli FC	19	10	8	1	36:16	20	38
2	(3)	AC Monza	19	9	7	3	28:14	14	34
3	(2)	US Salernitana 1919	19	10	4	5	24:23	1	34
4	(6)	AS Cittadella	19	10	3	6	31:17	14	33
5	(9)	SPAL 2013 Ferrara	19	9	6	4	26:17	9	33
6	(8)	Chievo Verona	19	8	8	3	25:16	9	32
7	(4)	US Lecce	19	7	9	3	34:24	10	30
8	(16)	Pordenone Calcio	19	6	10	3	22:15	7	28
9	(12)	Frosinone Calcio	19	7	7	5	18:17	1	28
10	(5)	AC Venezia	19	7	7	5	22:18	4	28
11	(13)	AC Pisa	19	5	9	5	25:31	-6	24
12	(14)	Lanerossi Vicenza Virtus	19	4	9	6	25:27	-2	21
13	(7)	Brescia Calcio	19	5	6	8	26:30	-4	21
14	(11)	US Cremonese	19	4	7	8	18:24	-6	19
15	(10)	Reggina 1914	19	4	6	9	17:26	-9	18
16	(18)	AC Reggiana 1919	19	5	3	11	17:32	-15	18
17	(17)	Cosenza Calcio	19	2	11	6	13:16	-3	17
18	(20)	Virtus Entella	19	4	5	10	17:32	-15	17
19	(19)	Pescara Calcio	19	4	4	11	15:32	-17	16
20	(15)	Ascoli Calcio	19	3	5	11	15:27	-12	14

Platz	Mannschaft	G	U	V	Tore	+/-	Pkt.	Letzte Spiele
1	(2)	US Salernitana 1919	19	9	8	2	22:11	11	35
2	(1)	Empoli FC	19	9	8	2	32:19	13	35
3	(7)	Brescia Calcio	19	10	5	4	35:23	12	35
4	(4)	US Lecce	19	9	5	5	34:23	11	32
5	(10)	Reggina 1914	19	8	8	3	25:19	6	32
6	(5)	AC Venezia	19	8	7	4	31:21	10	31
7	(15)	Ascoli Calcio	19	8	6	5	22:21	1	30
8	(3)	AC Monza	19	8	6	5	23:19	4	30
9	(11)	US Cremonese	19	8	5	6	28:20	8	29
10	(14)	Lanerossi Vicenza Virtus	19	7	6	6	23:26	-3	27
11	(6)	AS Cittadella	19	5	9	5	17:18	-1	24
12	(8)	Chievo Verona	19	6	6	7	25:21	4	24
13	(13)	AC Pisa	19	6	6	7	29:28	1	24
14	(9)	SPAL 2013 Ferrara	19	5	8	6	18:25	-7	23
15	(12)	Frosinone Calcio	19	5	7	7	20:25	-5	22
16	(17)	Cosenza Calcio	19	4	6	9	16:31	-15	18
17	(16)	Pordenone Calcio	19	4	5	10	18:24	-6	17
18	(19)	Pescara Calcio	19	3	7	9	14:28	-14	16
19	(18)	AC Reggiana 1919	19	4	4	11	14:25	-11	16
20	(20)	Virtus Entella	19	0	6	13	13:32	-19	6

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1638327070,
                "last": 1638327070,
                "now": 1638327070
            },
            "token": "mIptqJUvMG14vc5tGYIDZNLhanhTQ51h"
        },
        "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: 13.84 ms / 13.84 ms Speicher: 0.404 MB / 0.74 MB Application: afterLoad

Zeit: 90.31 ms / 104.15 ms Speicher: 1.554 MB / 2.30 MB Application: afterInitialise

Zeit: 24.15 ms / 128.30 ms Speicher: 0.336 MB / 2.63 MB Application: afterRoute

Zeit: 1.02 ms / 129.32 ms Speicher: 0.048 MB / 2.68 MB Application: beforeRenderComponent com_sportsmanagement

Zeit: 2624.79 ms / 2754.11 ms Speicher: 5.894 MB / 8.57 MB Application: afterRenderComponent com_sportsmanagement

Zeit: 5.73 ms / 2759.84 ms Speicher: 0.028 MB / 8.60 MB Application: afterDispatch

Zeit: 21.92 ms / 2781.76 ms Speicher: 0.152 MB / 8.75 MB Application: beforeRenderModule mod_s5_box (S5 Box)

Zeit: 0.99 ms / 2782.75 ms Speicher: 0.025 MB / 8.78 MB Application: beforeRenderModule mod_s5_register (S5 Register)

Zeit: 17.95 ms / 2800.70 ms Speicher: 0.212 MB / 8.99 MB Application: Before Access::preloadComponents (all components)

Zeit: 1.07 ms / 2801.77 ms Speicher: 0.051 MB / 9.04 MB Application: After Access::preloadComponents (all components)

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

Zeit: 0.50 ms / 2802.31 ms Speicher: 0.008 MB / 9.05 MB Application: After Access::getAssetRules (id:1 name:root.1)

Zeit: 0.90 ms / 2803.21 ms Speicher: -0.018 MB / 9.03 MB Application: afterRenderModule mod_s5_register (S5 Register)

Zeit: 0.03 ms / 2803.25 ms Speicher: -0.006 MB / 9.03 MB Application: beforeRenderModule mod_eprivacy (mod_eprivacy)

Zeit: 2.77 ms / 2806.02 ms Speicher: 0.034 MB / 9.06 MB Application: afterRenderModule mod_eprivacy (mod_eprivacy)

Zeit: 0.43 ms / 2806.45 ms Speicher: -0.014 MB / 9.05 MB Application: afterRenderModule mod_s5_box (S5 Box)

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

Zeit: 4.95 ms / 2811.43 ms Speicher: 0.025 MB / 9.06 MB Application: afterRenderModule mod_menu (Bottom Menu)

Zeit: 0.10 ms / 2811.54 ms Speicher: 0.011 MB / 9.08 MB Application: beforeRenderModule mod_jdownloads_latest (jDownloads Latest)

Zeit: 33.85 ms / 2845.39 ms Speicher: 0.179 MB / 9.25 MB Application: Before Access::preloadPermissions (com_jdownloads)

Zeit: 0.79 ms / 2846.18 ms Speicher: 0.056 MB / 9.31 MB Application: After Access::preloadPermissions (com_jdownloads)

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

Zeit: 0.11 ms / 2846.33 ms Speicher: 0.008 MB / 9.32 MB Application: After Access::getAssetRules (id:290 name:com_jdownloads.download.56)

Zeit: 1.39 ms / 2847.72 ms Speicher: 0.036 MB / 9.35 MB Application: Before Access::getAssetRules (id:286 name:com_jdownloads.download.55)

Zeit: 0.15 ms / 2847.87 ms Speicher: 0.008 MB / 9.36 MB Application: After Access::getAssetRules (id:286 name:com_jdownloads.download.55)

Zeit: 0.75 ms / 2848.61 ms Speicher: 0.033 MB / 9.39 MB Application: Before Access::getAssetRules (id:277 name:com_jdownloads.download.54)

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

Zeit: 0.72 ms / 2849.36 ms Speicher: 0.029 MB / 9.42 MB Application: Before Access::getAssetRules (id:269 name:com_jdownloads.download.49)

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

Zeit: 0.75 ms / 2850.15 ms Speicher: 0.033 MB / 9.46 MB Application: Before Access::getAssetRules (id:263 name:com_jdownloads.download.48)

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

Zeit: 0.76 ms / 2850.94 ms Speicher: 0.034 MB / 9.49 MB Application: Before Access::getAssetRules (id:261 name:com_jdownloads.download.47)

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

Zeit: 5.32 ms / 2856.29 ms Speicher: 0.001 MB / 9.50 MB Application: afterRenderModule mod_jdownloads_latest (jDownloads Latest)

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

Zeit: 12.34 ms / 2868.82 ms Speicher: 0.056 MB / 9.28 MB Application: afterRenderModule mod_whosonline (Wer ist Online)

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

Zeit: 73.27 ms / 2942.19 ms Speicher: 0.217 MB / 9.49 MB Application: afterRenderModule mod_sportsmanagement_clubicons (JSM - Modul Vereins Icons (Kopie))

Zeit: 0.16 ms / 2942.35 ms Speicher: -0.209 MB / 9.28 MB Application: beforeRenderModule mod_sportsmanagement_ajax_top_navigation_menu (Ligen Top Navigation)

Zeit: 21.45 ms / 2963.80 ms Speicher: 0.302 MB / 9.59 MB Application: afterRenderModule mod_sportsmanagement_ajax_top_navigation_menu (Ligen Top Navigation)

Zeit: 0.12 ms / 2963.92 ms Speicher: -0.121 MB / 9.47 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Zeit: 3.61 ms / 2967.53 ms Speicher: 0.012 MB / 9.48 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Zeit: 0.11 ms / 2967.64 ms Speicher: -0.004 MB / 9.47 MB Application: beforeRenderModule mod_custom (ESV-LOGO)

Zeit: 1.96 ms / 2969.60 ms Speicher: 0.007 MB / 9.48 MB Application: afterRenderModule mod_custom (ESV-LOGO)

Zeit: 67.37 ms / 3036.97 ms Speicher: 1.663 MB / 11.14 MB Application: afterRender

Datenbankabfragen gesamt: 22.94 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'346d6c6234386a75366a6162617336377461347469736c6a3736', 1, 1638327070, 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.01 ms
table lock	0.01 ms
init for update	0.02 ms
Update	0.08 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	7.94 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.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php: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.80 ms Nach letzter Abfrage: 2.25 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.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.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.01 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
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.27 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.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.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

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

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

Abfragezeit: 0.41 ms Nach letzter Abfrage: 0.12 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.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.07 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.06 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.31 ms Nach letzter Abfrage: 0.30 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 1.160 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.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.92 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.06 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 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.50 ms Nach letzter Abfrage: 25.97 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.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.01 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.12 ms
Preparing	0.02 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.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
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.32 ms Nach letzter Abfrage: 0.42 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.04 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.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 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
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.00 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.57 ms Nach letzter Abfrage: 10.55 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.08 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.11 ms
Preparing	0.03 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.01 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
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: 3.64 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 2.136 MB

UPDATE `z2o57_extensions`

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

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

Explain

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

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.11 ms
Updating	0.07 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	3.22 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.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.52 ms Nach letzter Abfrage: 7.61 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/5074:serie-b-2020-21/0/132136:38-spieltag/0/0/0/0.html') OR (`dest` = 'component/sportsmanagement/ranking/0/0/5074:serie-b-2020-21/0/132136:38-spieltag/0/0/0/0.html') OR ('component/sportsmanagement/ranking/0/0/5074:serie-b-2020-21/0/132136: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.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.03 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.06 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: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.61 ms Nach letzter Abfrage: 6.84 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.12 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.92 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.05 ms
Freeing items	0.01 ms
Updating status	0.02 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.09 ms Nach letzter Abfrage: 10.33 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.05 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.02 ms
Preparing	0.02 ms
Executing	0.00 ms
Filling schema table	0.01 ms
checking permissions	0.68 ms
Executing	0.00 ms
Sending data	0.09 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.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.40 ms Nach letzter Abfrage: 2.74 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.01 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.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.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.52 ms Nach letzter Abfrage: 0.77 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.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.12 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.02 ms
Starting cleanup	0.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: 2.32 ms Nach letzter Abfrage: 52.63 ms Abfragespeichernutzung: 0.078 MB Speichernutzung vor Abfrage: 4.425 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 = 5074

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.37 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.16 ms
Optimizing	0.05 ms
Statistics	0.14 ms
Preparing	0.08 ms
Executing	0.01 ms
Sending data	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.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 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()	JRO

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

1050 ausgeführte Abfragen 22.94 ms