TSG Salach

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

Akzeptieren

Weitere Informationen

Joomla!-Debug-Konsole

Sitzung

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

Profil zum Laufzeitverhalten

Zeit

Speicher

Zeit: 7.80 ms / 7.80 ms Speicher: 0.408 MB / 0.75 MB Application: afterLoad

Zeit: 113.36 ms / 121.16 ms Speicher: 2.169 MB / 2.92 MB Application: afterInitialise

Zeit: 5.21 ms / 126.36 ms Speicher: 0.192 MB / 3.11 MB Application: afterRoute

Zeit: 14.81 ms / 141.17 ms Speicher: 0.077 MB / 3.19 MB Application: beforeRenderComponent com_jcalpro

Zeit: 0.78 ms / 141.95 ms Speicher: 0.031 MB / 3.22 MB Application: onJCalProStart

Zeit: 5.16 ms / 147.11 ms Speicher: 0.152 MB / 3.37 MB Application: onJCalProTaskDisplayStart

Zeit: 0.15 ms / 147.26 ms Speicher: 0.001 MB / 3.37 MB Application: onJCalProTaskDisplayEnd

Zeit: 9.32 ms / 156.58 ms Speicher: 0.271 MB / 3.65 MB Application: Before Access::preloadComponents (all components)

Zeit: 3.60 ms / 160.18 ms Speicher: 0.068 MB / 3.71 MB Application: After Access::preloadComponents (all components)

Zeit: 0.05 ms / 160.23 ms Speicher: -0.003 MB / 3.71 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Zeit: 0.63 ms / 160.86 ms Speicher: 0.016 MB / 3.73 MB Application: After Access::getAssetRules (id:1 name:root.1)

Zeit: 83.66 ms / 244.52 ms Speicher: 0.426 MB / 4.15 MB Application: onJCalProViewDisplayStart

Zeit: 6.13 ms / 250.65 ms Speicher: 0.002 MB / 4.15 MB Application: onJCalProViewDisplayEnd

Zeit: 0.03 ms / 250.68 ms Speicher: 0.001 MB / 4.16 MB Application: onJCalProViewLoadTemplateStart (tpl=, layout=)

Zeit: 0.34 ms / 251.02 ms Speicher: 0.017 MB / 4.17 MB Application: onJCalProViewLoadTemplateStart (tpl=top, layout=)

Zeit: 0.15 ms / 251.17 ms Speicher: 0.001 MB / 4.17 MB Application: onJCalProViewLoadTemplateEnd (tpl=top, layout=month)

Zeit: 0.02 ms / 251.19 ms Speicher: 0.001 MB / 4.17 MB Application: onJCalProViewLoadTemplateStart (tpl=categories, layout=)

Zeit: 0.82 ms / 252.01 ms Speicher: 0.019 MB / 4.19 MB Application: onJCalProViewLoadTemplateStart (tpl=toolbar, layout=)

Zeit: 6.13 ms / 258.14 ms Speicher: 0.173 MB / 4.37 MB Application: onJCalProEventsModelConstructStart

Zeit: 0.07 ms / 258.20 ms Speicher: 0.001 MB / 4.37 MB Application: onJCalProEventsModelConstructEnd

Zeit: 0.03 ms / 258.23 ms Speicher: 0.001 MB / 4.37 MB Application: onJCalProEventsModelGetCategoriesStart

Zeit: 67.43 ms / 325.66 ms Speicher: 0.711 MB / 5.08 MB Application: onJCalProEventsModelGetCategoriesEnd

Zeit: 0.07 ms / 325.73 ms Speicher: -0.006 MB / 5.07 MB Application: Before Access::preloadPermissions (com_jcalpro)

Zeit: 2.81 ms / 328.54 ms Speicher: 0.065 MB / 5.14 MB Application: After Access::preloadPermissions (com_jcalpro)

Zeit: 0.04 ms / 328.58 ms Speicher: -0.002 MB / 5.14 MB Application: Before Access::getAssetRules (id:500 name:com_jcalpro.category.140)

Zeit: 0.09 ms / 328.67 ms Speicher: 0.010 MB / 5.15 MB Application: After Access::getAssetRules (id:500 name:com_jcalpro.category.140)

Zeit: 0.04 ms / 328.71 ms Speicher: 0.000 MB / 5.15 MB Application: Before Access::getAssetRules (id:513 name:com_jcalpro.category.141)

Zeit: 0.08 ms / 328.79 ms Speicher: 0.010 MB / 5.16 MB Application: After Access::getAssetRules (id:513 name:com_jcalpro.category.141)

Zeit: 0.03 ms / 328.82 ms Speicher: 0.000 MB / 5.16 MB Application: Before Access::getAssetRules (id:525 name:com_jcalpro.category.143)

Zeit: 0.02 ms / 328.84 ms Speicher: 0.002 MB / 5.16 MB Application: After Access::getAssetRules (id:525 name:com_jcalpro.category.143)

Zeit: 0.03 ms / 328.87 ms Speicher: 0.000 MB / 5.16 MB Application: Before Access::getAssetRules (id:526 name:com_jcalpro.category.144)

Zeit: 0.02 ms / 328.89 ms Speicher: 0.002 MB / 5.16 MB Application: After Access::getAssetRules (id:526 name:com_jcalpro.category.144)

Zeit: 0.02 ms / 328.91 ms Speicher: 0.000 MB / 5.16 MB Application: Before Access::getAssetRules (id:527 name:com_jcalpro.category.145)

Zeit: 0.02 ms / 328.93 ms Speicher: 0.004 MB / 5.17 MB Application: After Access::getAssetRules (id:527 name:com_jcalpro.category.145)

Zeit: 0.02 ms / 328.96 ms Speicher: 0.001 MB / 5.17 MB Application: Before Access::getAssetRules (id:528 name:com_jcalpro.category.146)

Zeit: 0.02 ms / 328.97 ms Speicher: 0.002 MB / 5.17 MB Application: After Access::getAssetRules (id:528 name:com_jcalpro.category.146)

Zeit: 0.02 ms / 329.00 ms Speicher: 0.000 MB / 5.17 MB Application: Before Access::getAssetRules (id:529 name:com_jcalpro.category.147)

Zeit: 0.02 ms / 329.02 ms Speicher: 0.002 MB / 5.17 MB Application: After Access::getAssetRules (id:529 name:com_jcalpro.category.147)

Zeit: 0.02 ms / 329.04 ms Speicher: 0.000 MB / 5.17 MB Application: Before Access::getAssetRules (id:530 name:com_jcalpro.category.148)

Zeit: 0.08 ms / 329.11 ms Speicher: 0.010 MB / 5.18 MB Application: After Access::getAssetRules (id:530 name:com_jcalpro.category.148)

Zeit: 0.03 ms / 329.14 ms Speicher: 0.001 MB / 5.18 MB Application: Before Access::getAssetRules (id:531 name:com_jcalpro.category.149)

Zeit: 0.02 ms / 329.16 ms Speicher: 0.002 MB / 5.18 MB Application: After Access::getAssetRules (id:531 name:com_jcalpro.category.149)

Zeit: 0.02 ms / 329.18 ms Speicher: 0.000 MB / 5.18 MB Application: Before Access::getAssetRules (id:532 name:com_jcalpro.category.150)

Zeit: 0.02 ms / 329.20 ms Speicher: 0.002 MB / 5.18 MB Application: After Access::getAssetRules (id:532 name:com_jcalpro.category.150)

Zeit: 0.02 ms / 329.22 ms Speicher: 0.000 MB / 5.18 MB Application: Before Access::getAssetRules (id:533 name:com_jcalpro.category.151)

Zeit: 0.02 ms / 329.24 ms Speicher: 0.002 MB / 5.19 MB Application: After Access::getAssetRules (id:533 name:com_jcalpro.category.151)

Zeit: 0.02 ms / 329.26 ms Speicher: 0.000 MB / 5.19 MB Application: Before Access::getAssetRules (id:534 name:com_jcalpro.category.152)

Zeit: 0.02 ms / 329.28 ms Speicher: 0.002 MB / 5.19 MB Application: After Access::getAssetRules (id:534 name:com_jcalpro.category.152)

Zeit: 0.02 ms / 329.30 ms Speicher: 0.000 MB / 5.19 MB Application: Before Access::getAssetRules (id:535 name:com_jcalpro.category.153)

Zeit: 0.02 ms / 329.32 ms Speicher: 0.002 MB / 5.19 MB Application: After Access::getAssetRules (id:535 name:com_jcalpro.category.153)

Zeit: 0.02 ms / 329.34 ms Speicher: 0.001 MB / 5.19 MB Application: Before Access::getAssetRules (id:536 name:com_jcalpro.category.154)

Zeit: 0.02 ms / 329.36 ms Speicher: 0.002 MB / 5.19 MB Application: After Access::getAssetRules (id:536 name:com_jcalpro.category.154)

Zeit: 0.02 ms / 329.38 ms Speicher: 0.000 MB / 5.19 MB Application: Before Access::getAssetRules (id:537 name:com_jcalpro.category.155)

Zeit: 0.02 ms / 329.40 ms Speicher: 0.002 MB / 5.19 MB Application: After Access::getAssetRules (id:537 name:com_jcalpro.category.155)

Zeit: 0.02 ms / 329.42 ms Speicher: 0.000 MB / 5.19 MB Application: Before Access::getAssetRules (id:638 name:com_jcalpro.category.171)

Zeit: 0.02 ms / 329.44 ms Speicher: 0.002 MB / 5.20 MB Application: After Access::getAssetRules (id:638 name:com_jcalpro.category.171)

Zeit: 65.96 ms / 395.40 ms Speicher: 0.705 MB / 5.90 MB Application: onJCalProEventsModelConstructStart

Zeit: 0.09 ms / 395.49 ms Speicher: 0.001 MB / 5.90 MB Application: onJCalProEventsModelConstructEnd

Zeit: 3.99 ms / 399.48 ms Speicher: 0.028 MB / 5.93 MB Application: onJCalProViewLoadTemplateStart (tpl=toolbar_button, layout=)

Zeit: 0.38 ms / 399.86 ms Speicher: 0.001 MB / 5.93 MB Application: onJCalProViewLoadTemplateEnd (tpl=toolbar_button, layout=month)

Zeit: 0.03 ms / 399.89 ms Speicher: 0.001 MB / 5.93 MB Application: onJCalProViewLoadTemplateStart (tpl=toolbar_button, layout=)

Zeit: 0.26 ms / 400.15 ms Speicher: 0.001 MB / 5.93 MB Application: onJCalProViewLoadTemplateEnd (tpl=toolbar_button, layout=month)

Zeit: 0.02 ms / 400.17 ms Speicher: 0.001 MB / 5.94 MB Application: onJCalProViewLoadTemplateStart (tpl=toolbar_button, layout=)

Zeit: 0.24 ms / 400.42 ms Speicher: 0.001 MB / 5.94 MB Application: onJCalProViewLoadTemplateEnd (tpl=toolbar_button, layout=month)

Zeit: 0.02 ms / 400.43 ms Speicher: 0.001 MB / 5.94 MB Application: onJCalProViewLoadTemplateStart (tpl=toolbar_button, layout=)

Zeit: 0.24 ms / 400.68 ms Speicher: 0.012 MB / 5.95 MB Application: onJCalProViewLoadTemplateEnd (tpl=toolbar_button, layout=month)

Zeit: 0.20 ms / 400.88 ms Speicher: -0.006 MB / 5.94 MB Application: onJCalProViewLoadTemplateEnd (tpl=toolbar, layout=month)

Zeit: 36.08 ms / 436.96 ms Speicher: 0.324 MB / 6.27 MB Application: onJCalProViewLoadTemplateEnd (tpl=categories, layout=month)

Zeit: 0.03 ms / 436.99 ms Speicher: 0.001 MB / 6.27 MB Application: onJCalProViewLoadTemplateStart (tpl=bottom, layout=)

Zeit: 0.20 ms / 437.19 ms Speicher: 0.002 MB / 6.27 MB Application: onJCalProViewLoadTemplateStart (tpl=search_form, layout=)

Zeit: 0.14 ms / 437.34 ms Speicher: 0.001 MB / 6.27 MB Application: onJCalProViewLoadTemplateEnd (tpl=search_form, layout=month)

Zeit: 0.02 ms / 437.36 ms Speicher: 0.001 MB / 6.27 MB Application: onJCalProViewLoadTemplateStart (tpl=debug, layout=)

Zeit: 0.27 ms / 437.62 ms Speicher: 0.001 MB / 6.27 MB Application: onJCalProViewLoadTemplateEnd (tpl=debug, layout=month)

Zeit: 0.02 ms / 437.64 ms Speicher: -0.015 MB / 6.26 MB Application: onJCalProViewLoadTemplateEnd (tpl=bottom, layout=month)

Zeit: 0.01 ms / 437.65 ms Speicher: 0.001 MB / 6.26 MB Application: onJCalProViewLoadTemplateEnd (tpl=, layout=month)

Zeit: 0.02 ms / 437.67 ms Speicher: 0.000 MB / 6.26 MB Application: onJCalProEnd

Zeit: 0.02 ms / 437.69 ms Speicher: -0.000 MB / 6.26 MB Application: afterRenderComponent com_jcalpro

Zeit: 2.65 ms / 440.34 ms Speicher: 0.010 MB / 6.27 MB Application: afterDispatch

Zeit: 3.66 ms / 444.00 ms Speicher: 0.251 MB / 6.52 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Zeit: 0.09 ms / 444.09 ms Speicher: 0.007 MB / 6.52 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Zeit: 5.81 ms / 449.90 ms Speicher: 0.066 MB / 6.59 MB Application: beforeRenderModule mod_whosonline (Anzahl von Gästen)

Zeit: 2.35 ms / 452.25 ms Speicher: 0.016 MB / 6.61 MB Application: afterRenderModule mod_whosonline (Anzahl von Gästen)

Zeit: 0.09 ms / 452.34 ms Speicher: 0.001 MB / 6.61 MB Application: beforeRenderModule mod_menu (Informationen)

Zeit: 1.96 ms / 454.30 ms Speicher: 0.029 MB / 6.64 MB Application: afterRenderModule mod_menu (Informationen)

Zeit: 0.05 ms / 454.35 ms Speicher: -0.002 MB / 6.63 MB Application: beforeRenderModule mod_custom (Logo)

Zeit: 0.79 ms / 455.14 ms Speicher: 0.006 MB / 6.64 MB Application: afterRenderModule mod_custom (Logo)

Zeit: 0.13 ms / 455.28 ms Speicher: 0.003 MB / 6.64 MB Application: beforeRenderModule mod_menu (Inhalt)

Zeit: 0.39 ms / 455.67 ms Speicher: 0.011 MB / 6.65 MB Application: afterRenderModule mod_menu (Inhalt)

Zeit: 0.04 ms / 455.71 ms Speicher: -0.009 MB / 6.65 MB Application: beforeRenderModule mod_custom (Kontaktinfos)

Zeit: 0.38 ms / 456.09 ms Speicher: 0.003 MB / 6.65 MB Application: afterRenderModule mod_custom (Kontaktinfos)

Zeit: 2.31 ms / 458.40 ms Speicher: 0.032 MB / 6.68 MB Application: beforeRenderModule mod_custom (Logo)

Zeit: 0.42 ms / 458.82 ms Speicher: 0.003 MB / 6.68 MB Application: afterRenderModule mod_custom (Logo)

Zeit: 0.30 ms / 459.12 ms Speicher: 0.003 MB / 6.69 MB Application: beforeRenderModule mod_menu (Hauptnavigation)

Zeit: 8.17 ms / 467.29 ms Speicher: 0.393 MB / 7.08 MB Application: afterRenderModule mod_menu (Hauptnavigation)

Zeit: 5.63 ms / 472.92 ms Speicher: 0.069 MB / 7.15 MB Application: beforeRenderModule mod_custom (Logo Mobile)

Zeit: 0.39 ms / 473.32 ms Speicher: 0.003 MB / 7.15 MB Application: afterRenderModule mod_custom (Logo Mobile)

Zeit: 0.44 ms / 473.76 ms Speicher: 0.001 MB / 7.15 MB Application: beforeRenderModule mod_breadcrumbs (Kindertraining)

Zeit: 1.12 ms / 474.88 ms Speicher: 0.009 MB / 7.16 MB Application: afterRenderModule mod_breadcrumbs (Kindertraining)

Zeit: 2.31 ms / 477.19 ms Speicher: -0.001 MB / 7.16 MB Application: beforeRenderModule mod_custom (Copyright)

Zeit: 0.39 ms / 477.58 ms Speicher: 0.003 MB / 7.16 MB Application: afterRenderModule mod_custom (Copyright)

Zeit: 0.29 ms / 477.87 ms Speicher: 0.003 MB / 7.17 MB Application: beforeRenderModule mod_menu (Mobile Navigation)

Zeit: 11.91 ms / 489.78 ms Speicher: 0.232 MB / 7.40 MB Application: afterRenderModule mod_menu (Mobile Navigation)

Zeit: 6.77 ms / 496.55 ms Speicher: 0.067 MB / 7.47 MB Application: afterRender

Datenbankabfragen gesamt: 285.47 ms

Speichernutzung

Datenbankabfragen

191 ausgeführte Abfragen 285.47 ms

148 Duplikate gefunden!

2 Duplikate: #8 #9

2 Duplikate: #14 #16

3 Duplikate: #25 #76 #125

3 Duplikate: #26 #77 #126

3 Duplikate: #27 #78 #127

3 Duplikate: #29 #79 #128

3 Duplikate: #30 #80 #129

3 Duplikate: #31 #81 #130

3 Duplikate: #32 #82 #131

3 Duplikate: #33 #83 #132

3 Duplikate: #34 #84 #133

3 Duplikate: #35 #85 #134

3 Duplikate: #36 #86 #135

3 Duplikate: #37 #87 #136

3 Duplikate: #38 #88 #137

3 Duplikate: #39 #89 #138

3 Duplikate: #40 #90 #139

3 Duplikate: #41 #91 #140

3 Duplikate: #42 #92 #141

3 Duplikate: #43 #93 #142

3 Duplikate: #44 #94 #143

3 Duplikate: #45 #95 #144

3 Duplikate: #46 #96 #145

3 Duplikate: #47 #97 #146

3 Duplikate: #48 #98 #147

3 Duplikate: #49 #99 #148

3 Duplikate: #50 #100 #149

3 Duplikate: #51 #101 #150

3 Duplikate: #52 #102 #151

3 Duplikate: #53 #103 #152

3 Duplikate: #54 #104 #153

3 Duplikate: #55 #105 #154

3 Duplikate: #56 #106 #155

3 Duplikate: #57 #107 #156

3 Duplikate: #58 #108 #157

3 Duplikate: #59 #109 #158

3 Duplikate: #60 #110 #159

3 Duplikate: #61 #111 #160

3 Duplikate: #62 #112 #161

3 Duplikate: #63 #113 #162

3 Duplikate: #64 #114 #163

3 Duplikate: #65 #115 #164

3 Duplikate: #66 #116 #165

3 Duplikate: #67 #117 #166

3 Duplikate: #68 #118 #167

3 Duplikate: #69 #119 #168

3 Duplikate: #70 #120 #169

3 Duplikate: #71 #121 #170

3 Duplikate: #72 #122 #171

3 Duplikate: #73 #75 #124

Abfragezeit: 1.24 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 1.031 MB Zeilen zurückgegeben: 0

SELECT `data`

  FROM `jos_session`

  WHERE `session_id` = X'6562623535386135326539633865663064366539336361323838653638323334'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Derselbe Aufruf in der Zeile darunter.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Abfragezeit: 1.09 ms Nach letzter Abfrage: 0.80 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 1.045 MB Zeilen zurückgegeben: 0

SELECT `session_id`

  FROM `jos_session`

  WHERE `session_id` = X'6562623535386135326539633865663064366539336361323838653638323334' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Abfragezeit: 7.67 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 1.050 MB

INSERT INTO `jos_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6562623535386135326539633865663064366539336361323838653638323334', 1, 1680062945, 0, '', 0)

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Abfragezeit: 3.19 ms Nach letzter Abfrage: 1.20 ms Abfragespeichernutzung: 0.087 MB Speichernutzung vor Abfrage: 1.082 MB Zeilen zurückgegeben: 46

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

  FROM `jos_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_extensions	NULL	ref	extension	extension	82	const	46	1.00	Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

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: 1.15 ms Nach letzter Abfrage: 1.40 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.162 MB Zeilen zurückgegeben: 6

SELECT id, rules

  FROM `jos_viewlevels`

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

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

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

Abfragezeit: 1.26 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.175 MB Zeilen zurückgegeben: 2

SELECT b.id

  FROM jos_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

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: 4.57 ms Nach letzter Abfrage: 0.33 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 1.196 MB Zeilen zurückgegeben: 133

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

  FROM jos_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_extensions	NULL	ref	extension	extension	82	const	187	0.60	Using index condition; Using where; filesort wurde genutzt

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

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: 1.22 ms Nach letzter Abfrage: 14.56 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 1.891 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #9

SELECT template

  FROM jos_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_client_id,idx_client_id_home	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	8	12.50	Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__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:667
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.33 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 1.899 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #8

SELECT template

  FROM jos_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_client_id,idx_client_id_home	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	8	12.50	Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__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:667
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.19 ms Nach letzter Abfrage: 1.78 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.001 MB Zeilen zurückgegeben: 2

SELECT extension, file, type

  FROM jos_rokcommon_configs

  ORDER BY priority

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_rokcommon_configs	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2	100.00	filesort wurde genutzt

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:131
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
7	plgSystemRokCommon->__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:667
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: 4.27 ms Nach letzter Abfrage: 9.33 ms Abfragespeichernutzung: 0.176 MB Speichernutzung vor Abfrage: 2.204 MB Zeilen zurückgegeben: 123

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

  LEFT JOIN jos_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	201	10.00	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	usr_web3771_2.m.component_id	1	100.00	Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Derselbe Aufruf in der Zeile darunter.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/dropfiles/dropfiles.php:37
8	PlgSystemDropfiles->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:668
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.90 ms Nach letzter Abfrage: 2.67 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 2.733 MB Zeilen zurückgegeben: 18

SHOW FULL COLUMNS 
  FROM `jos_extensions`

Explain

„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `jos_extensions`

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
11	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
10	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:328
9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
8	plgSystemRokSprocket->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:668
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.13 ms Nach letzter Abfrage: 0.73 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.762 MB Zeilen zurückgegeben: 1

SELECT `extension_id`

  FROM `jos_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:47
8	plgSystemRokSprocket->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:668
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.17 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.768 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #16

SELECT *

  FROM jos_extensions

  WHERE `extension_id` = '10024'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_extensions	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
8	plgSystemRokSprocket->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:668
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.08 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.772 MB Zeilen zurückgegeben: 1

SELECT `extension_id`

  FROM `jos_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:70
8	plgSystemRokSprocket->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:668
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.11 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.778 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #14

SELECT *

  FROM jos_extensions

  WHERE `extension_id` = '10024'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_extensions	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
8	plgSystemRokSprocket->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:668
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.52 ms Nach letzter Abfrage: 36.76 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.134 MB Zeilen zurückgegeben: 1

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

  FROM `jos_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Derselbe Aufruf in der Zeile darunter.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 8.17 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 3.125 MB

UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"4c5fc092ec9ae21da8fb0d91db7bdd63\"}'

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	jos_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.35 ms Nach letzter Abfrage: 1.07 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 3.176 MB Zeilen zurückgegeben: 2

SELECT *

  FROM jos_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

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

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

Abfragezeit: 1.62 ms Nach letzter Abfrage: 0.36 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 3.185 MB Zeilen zurückgegeben: 6

SELECT id, home, template, s.params

  FROM jos_template_styles as s

  LEFT JOIN jos_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	8	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	usr_web3771_2.e.element	1	75.00	Using index condition; Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

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

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

Abfragezeit: 1.43 ms Nach letzter Abfrage: 10.06 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 3.497 MB Zeilen zurückgegeben: 1

SELECT `extension_id`,`name`,`enabled`,`params`

  FROM jos_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_jcalpro'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:170
17	Alledia\Framework\Joomla\Extension\Generic->getDataFromDatabase()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:140
16	Alledia\Framework\Joomla\Extension\Generic->__construct()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Licensed.php:62
15	Alledia\Framework\Joomla\Extension\Licensed->__construct()	JROOT/libraries/allediaframework/Framework/Factory.php:62
14	Alledia\Framework\Factory::getExtension()	JROOT/administrator/components/com_jcalpro/libraries/views/baseview.php:110
13	JCalProView->__construct()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:89
12	Joomla\CMS\MVC\Factory\LegacyFactory->createView()	JROOT/libraries/src/MVC/Controller/BaseController.php:590
11	Joomla\CMS\MVC\Controller\BaseController->createView()	JROOT/libraries/src/MVC/Controller/BaseController.php:833
10	Joomla\CMS\MVC\Controller\BaseController->getView()	JROOT/libraries/src/MVC/Controller/BaseController.php:613
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jcalpro/controller.php:253
8	JCalProController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jcalpro/jcalpro.php:36
6	require_once JROOT/components/com_jcalpro/jcalpro.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.26 ms Nach letzter Abfrage: 2.77 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.634 MB Zeilen zurückgegeben: 0

SELECT id, type

  FROM jos_jcalpro_forms

  WHERE `default` = 1 
  AND published = 1

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_jcalpro/models/categories.php:303
12	JcalproModelCategories->getForms()	JROOT/components/com_jcalpro/models/categories.php:202
11	JcalproModelCategories->getItems()	JROOT/components/com_jcalpro/views/categories/view.html.php:62
10	JCalProViewCategories->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jcalpro/controller.php:253
8	JCalProController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jcalpro/jcalpro.php:36
6	require_once JROOT/components/com_jcalpro/jcalpro.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 3.27 ms Nach letzter Abfrage: 0.35 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 3.650 MB Zeilen zurückgegeben: 47

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `jos_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_cinstaller','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dropeditor','com_dropfiles','com_droppics','com_droptables','com_fields','com_finder','com_installer','com_jcalpro','com_joomlaupdate','com_languages','com_login','com_mailto','com_matukio','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_pwtacl','com_redirect','com_roksprocket','com_rstbox','com_search','com_tags','com_templates','com_users','com_visforms','com_wrapper')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	47	100.00	Using index condition

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
21	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
20	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
19	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
18	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
17	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_categories/models/categories.php:223
16	CategoriesModelCategories->getListQuery()	JROOT/components/com_jcalpro/models/categories.php:148
15	JcalproModelCategories->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/administrator/components/com_jcalpro/libraries/models/basemodellist.php:231
13	JcalproListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_jcalpro/models/categories.php:215
11	JcalproModelCategories->getItems()	JROOT/components/com_jcalpro/views/categories/view.html.php:62
10	JCalProViewCategories->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jcalpro/controller.php:253
8	JCalProController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jcalpro/jcalpro.php:36
6	require_once JROOT/components/com_jcalpro/jcalpro.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 3.69 ms Nach letzter Abfrage: 1.00 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 3.727 MB Zeilen zurückgegeben: 16

SELECT a.id, a.title, a.alias, a.note, a.published, a.access, a.checked_out, a.checked_out_time, a.created_user_id, a.path, a.parent_id, a.level, a.lft, a.rgt, a.language,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,a.params,a.metadata,a.description

  FROM jos_categories AS a

  LEFT JOIN `jos_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN jos_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN jos_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_user_id

  WHERE a.extension = 'com_jcalpro' 
  AND a.access IN (1,1,5) 
  AND a.published = 1

  GROUP BY a.id,
				a.title,
				a.alias,
				a.note,
				a.published,
				a.access,
				a.checked_out,
				a.checked_out_time,
				a.created_user_id,
				a.path,
				a.parent_id,
				a.level,
				a.lft,
				a.rgt,
				a.language,
				l.title,
				l.image,
				uc.name,
				ag.title,
				ua.name,a.id

  ORDER BY a.lft ASC 
  LIMIT 0, 100

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	range	cat_idx,idx_access	cat_idx	207	NULL	17	100.00	Using index condition; Using temporary; filesort wurde genutzt
1	SIMPLE	l	NULL	ALL	idx_langcode	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	usr_web3771_2.a.checked_out	1	100.00	Using where
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	usr_web3771_2.a.access	1	100.00	NULL
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	usr_web3771_2.a.created_user_id	1	100.00	Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_jcalpro/models/categories.php:215
11	JcalproModelCategories->getItems()	JROOT/components/com_jcalpro/views/categories/view.html.php:62
10	JCalProViewCategories->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jcalpro/controller.php:253
8	JCalProController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jcalpro/jcalpro.php:36
6	require_once JROOT/components/com_jcalpro/jcalpro.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.31 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.765 MB Zeilen zurückgegeben: 0

Doppelte Abfragen: #76 #125

SELECT COUNT(Event.id)

  FROM jos_jcalpro_events AS Event

  LEFT JOIN jos_jcalpro_event_categories AS Xref 
  ON Xref.event_id = Event.id 
  AND Xref.category_id = 140

  WHERE Xref.category_id = 140 
  AND Event.published = 1 
  AND Event.approved = 1 
  AND (Event.private = 0 OR (Event.private = 1 
  AND Event.created_by = 0)) 
  AND Event.start_date >= '2023-03-28 22:00:00'

  GROUP BY Xref.category_id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	Xref	NULL	ref	PRIMARY	PRIMARY	4	const	1	100.00	Using where; Using index
1	SIMPLE	Event	NULL	eq_ref	PRIMARY,published,approved	PRIMARY	4	usr_web3771_2.Xref.event_id	1	5.00	Using where