Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1732180499,
                "last": 1732180499,
                "now": 1732180499
            },
            "token": "0DDB6mANlADMwYN7paScsGodkmL66P34"
        },
        "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: 120.39 ms / 120.39 ms Speicher: 0.199 MB / 0.43 MB Application: afterLoad

Zeit: 246.56 ms / 366.95 ms Speicher: 3.396 MB / 3.83 MB Application: afterInitialise

Zeit: 172.40 ms / 539.35 ms Speicher: 0.926 MB / 4.75 MB Application: afterRoute

Zeit: 1.15 ms / 540.50 ms Speicher: 0.020 MB / 4.78 MB Application: beforeRenderComponent com_tags

Zeit: 97.34 ms / 637.84 ms Speicher: 0.905 MB / 5.68 MB Application: Start JAccess::getAssetRules Old (1)

Zeit: 4.69 ms / 642.53 ms Speicher: 0.045 MB / 5.73 MB Application: Finish JAccess::getAssetRules Old (1)

Zeit: 0.04 ms / 642.58 ms Speicher: 0.000 MB / 5.72 MB Application: Start JAccess::getAssetRules Old (1)

Zeit: 0.33 ms / 642.90 ms Speicher: 0.037 MB / 5.76 MB Application: Finish JAccess::getAssetRules Old (1)

Zeit: 44.19 ms / 687.10 ms Speicher: 0.300 MB / 6.06 MB Application: Start JAccess::preload(components)

Zeit: 3.44 ms / 690.53 ms Speicher: 0.369 MB / 6.43 MB Application: Finish JAccess::preload(components)

Zeit: 11.06 ms / 701.59 ms Speicher: 0.074 MB / 6.50 MB Application: afterRenderComponent com_tags

Zeit: 10.54 ms / 712.13 ms Speicher: 0.039 MB / 6.54 MB Application: afterDispatch

Zeit: 545.82 ms / 1257.95 ms Speicher: 3.070 MB / 9.61 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Zeit: 6.76 ms / 1264.71 ms Speicher: 0.038 MB / 9.65 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Zeit: 0.55 ms / 1265.26 ms Speicher: 0.000 MB / 9.64 MB Application: beforeRenderModule mod_amazonproductsearch (suche01)

Zeit: 12.36 ms / 1277.62 ms Speicher: 0.111 MB / 9.75 MB Application: afterRenderModule mod_amazonproductsearch (suche01)

Zeit: 10.47 ms / 1288.08 ms Speicher: 0.099 MB / 9.85 MB Application: beforeRenderModule mod_tags_similar (aside-schlagworte)

Zeit: 3.50 ms / 1291.58 ms Speicher: 0.042 MB / 9.89 MB Application: afterRenderModule mod_tags_similar (aside-schlagworte)

Zeit: 176.75 ms / 1468.34 ms Speicher: 0.720 MB / 10.61 MB Application: afterRender

Datenbankabfragen gesamt: 31.57 ms

Speichernutzung

Datenbankabfragen

39 ausgeführte Abfragen 31.57 ms

7 Duplikate gefunden!

3 Duplikate: #19 #25 #26

2 Duplikate: #23 #24

2 Duplikate: #35 #37

Abfragezeit: 0.33 ms Abfragespeichernutzung: 0.017 MB Speichernutzung vor Abfrage: 0.934 MB Zeilen zurückgegeben: 0

SELECT `data`

  FROM `jos_session`

  WHERE `session_id` = '2n5g85kerd8fc99sdomietsme6'

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_session	const	PRIMARY	PRIMARY	766	const	1

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.01 ms
Checking query cache for query	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.02 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Waiting for query cache lock	0.01 ms
Updating status	0.02 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.00 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Der selbe Aufruf in der Zeile darunter.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::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.26 ms Nach letzter Abfrage: 7.38 ms Abfragespeichernutzung: 0.008 MB Speichernutzung vor Abfrage: 1.001 MB

DELETE 

  FROM `jos_session`

  WHERE `time` < '1732177799'

Erklären

„EXPLAIN“ unmöglich für Abfrage: DELETE FROM `jos_session` WHERE `time` < '1732177799'

Profil (Profile)

Status	Duration
Starting	0.02 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.00 ms
Init for update	0.05 ms
Updating	0.02 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.02 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::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.29 ms Nach letzter Abfrage: 0.14 ms Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 1.012 MB Zeilen zurückgegeben: 0

SELECT `session_id`

  FROM `jos_session`

  WHERE `session_id` = '2n5g85kerd8fc99sdomietsme6' 
  LIMIT 1

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.02 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.00 ms
Waiting for query cache lock	0.02 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	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.00 ms
Updating status	0.00 ms
Waiting for query cache lock	0.00 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::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.43 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 1.027 MB

INSERT INTO `jos_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('2n5g85kerd8fc99sdomietsme6', 0, 1, '1732180499', 0, '')

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
Init for update	0.01 ms
Update	0.04 ms
Waiting for query cache lock	0.00 ms
Update	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.20 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Abfragezeit: 0.11 ms Nach letzter Abfrage: 10.56 ms Abfragespeichernutzung: 0.012 MB Speichernutzung vor Abfrage: 1.084 MB Zeilen zurückgegeben: 35

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

  FROM `jos_extensions`

  WHERE `type` = 'component'

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_extensions	ref	extension	extension	82	const	35	Using index condition

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.01 ms
Checking privileges on cached	0.00 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	Der selbe Aufruf in der Zeile darunter.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.11 ms Nach letzter Abfrage: 5.04 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 1.149 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

Erklären

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	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	9	Using where; Using index

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.01 ms
Checking privileges on cached	0.01 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.10 ms Nach letzter Abfrage: 1.91 ms Abfragespeichernutzung: 0.013 MB Speichernutzung vor Abfrage: 1.170 MB Zeilen zurückgegeben: 5

SELECT id, rules

  FROM `jos_viewlevels`

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.00 ms
Checking privileges on cached	0.01 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.11 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 1.189 MB Zeilen zurückgegeben: 69

SELECT folder AS type, element AS name, params

  FROM jos_extensions

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

  ORDER BY ordering

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.01 ms
Checking privileges on cached	0.00 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.11 ms Nach letzter Abfrage: 61.43 ms Abfragespeichernutzung: 0.013 MB Speichernutzung vor Abfrage: 1.917 MB Zeilen zurückgegeben: 2

SELECT *

  FROM jos_languages

  WHERE published=1

  ORDER BY ordering ASC

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.00 ms
Checking privileges on cached	0.00 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
8	JLanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:97
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.09 ms Nach letzter Abfrage: 1.28 ms Abfragespeichernutzung: 0.013 MB Speichernutzung vor Abfrage: 1.941 MB Zeilen zurückgegeben: 2

SELECT element

  FROM jos_extensions

  WHERE type = 'language' 
  AND client_id = 0 
  AND enabled = 1

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.00 ms
Checking privileges on cached	0.00 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:90
8	JLanguageMultilang::getSiteLangs()	JROOT/plugins/system/languagefilter/languagefilter.php:108
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.93 ms Nach letzter Abfrage: 34.02 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 2.187 MB Zeilen zurückgegeben: 170

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

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	277	Using where; filesort wurde genutzt
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	fanshop17.m.component_id	1	Using where

Profil (Profile)

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Waiting for query cache lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.40 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.07 ms
Waiting for query cache lock	0.01 ms
Creating sort index	0.11 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.12 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.12 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.13 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.12 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.11 ms
Waiting for query cache lock	0.00 ms
Creating sort index	0.10 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.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
19	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
18	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
17	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
16	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
15	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
14	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
13	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
12	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
11	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
10	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
9	PlgSystemLanguageFilter->onAfterInitialise()	Der selbe Aufruf in der Zeile darunter.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.65 ms Nach letzter Abfrage: 32.55 ms Abfragespeichernutzung: 0.016 MB Speichernutzung vor Abfrage: 3.927 MB Zeilen zurückgegeben: 8

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

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	8	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	10	Using where; Using join buffer (flat, BNL join)

Profil (Profile)

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	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
Waiting for query cache lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.13 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.00 ms
Waiting for query cache lock	0.00 ms
Updating status	0.02 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
11	JApplicationSite->getTemplate()	JROOT/plugins/system/gantry5/gantry5.php:100
10	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
9	plgSystemGantry5->onAfterRoute()	Der selbe Aufruf in der Zeile darunter.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.53 ms Nach letzter Abfrage: 97.14 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 4.457 MB Zeilen zurückgegeben: 1

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

  FROM `jos_extensions`

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

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.04 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
Waiting for query cache lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.05 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.03 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
23	JDatabaseDriver->loadObject()	Der selbe Aufruf in der Zeile darunter.
22	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
21	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
20	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
19	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
18	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
17	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
16	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
15	JFactory::getDocument()	JROOT/libraries/gantry5/classes/Gantry/Framework/Theme.php:116
14	Gantry\Framework\Theme->init()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:67
13	Gantry\Component\Theme\AbstractTheme->__construct()	JROOT/templates/rt_ambrosia/includes/theme.php:28
12	plgSystemGantry5->{closure}()	JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:113
11	Pimple\Container->offsetGet()	JROOT/plugins/system/gantry5/gantry5.php:139
10	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
9	plgSystemGantry5->onAfterRoute()	Der selbe Aufruf in der Zeile darunter.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 0.64 ms Nach letzter Abfrage: 0.31 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 4.470 MB

UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"6663ef83773c9d57a911bcbb7bb2569f\"}'

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

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
Init for update	0.05 ms
Updating	0.05 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.12 ms
Query end	0.00 ms
Commit	0.26 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
19	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
18	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
17	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
16	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
15	JFactory::getDocument()	JROOT/libraries/gantry5/classes/Gantry/Framework/Theme.php:116
14	Gantry\Framework\Theme->init()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:67
13	Gantry\Component\Theme\AbstractTheme->__construct()	JROOT/templates/rt_ambrosia/includes/theme.php:28
12	plgSystemGantry5->{closure}()	JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:113
11	Pimple\Container->offsetGet()	JROOT/plugins/system/gantry5/gantry5.php:139
10	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
9	plgSystemGantry5->onAfterRoute()	Der selbe Aufruf in der Zeile darunter.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.12 ms Nach letzter Abfrage: 38.78 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.678 MB Zeilen zurückgegeben: 3

SELECT s.id, s.template, s.home, s.title AS long_title, s.params

  FROM jos_template_styles AS s

  WHERE s.client_id = 0 
  AND s.template = 'rt_ambrosia'

  ORDER BY s.id

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_template	idx_template	202	const	3	Using index condition; Using where

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.01 ms
Checking privileges on cached	0.00 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.02 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry5/classes/Gantry/Joomla/StyleHelper.php:46
15	Gantry\Joomla\StyleHelper::loadStyles()	JROOT/libraries/gantry5/classes/Gantry/Framework/Assignments.php:50
14	Gantry\Framework\Assignments->loadAssignments()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:299
13	Gantry\Component\Assignments\AbstractAssignments->init()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:101
12	Gantry\Component\Assignments\AbstractAssignments->scores()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:88
11	Gantry\Component\Assignments\AbstractAssignments->select()	JROOT/plugins/system/gantry5/gantry5.php:151
10	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
9	plgSystemGantry5->onAfterRoute()	Der selbe Aufruf in der Zeile darunter.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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: 44.23 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 5.015 MB Zeilen zurückgegeben: 13

SELECT *

  FROM `jos_content_types`

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.45 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Waiting for query cache lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.28 ms
Waiting for query cache lock	0.01 ms
Sending data	0.04 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.00 ms
Waiting for query cache lock	0.00 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.00 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/cms/helper/tags.php:775
17	JHelperTags::getTypes()	JROOT/libraries/cms/helper/tags.php:609
16	JHelperTags->getTagItemsQuery()	JROOT/components/com_tags/models/tag.php:148
15	TagsModelTag->getListQuery()	JROOT/libraries/legacy/model/list.php:129
14	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:183
13	JModelList->getItems()	JROOT/components/com_tags/models/tag.php:86
12	TagsModelTag->getItems()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:51
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.21 ms Nach letzter Abfrage: 0.30 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 5.041 MB Zeilen zurückgegeben: 1

SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
  CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
  CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email

  FROM jos_contentitem_tag_map AS m

  INNER JOIN jos_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2024-11-21 09:15:00')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2024-11-21 09:15:00')

  INNER JOIN jos_content_types AS ct 
  ON ct.type_alias = m.type_alias

  INNER JOIN jos_categories AS tc 
  ON tc.id = c.core_catid 
  AND tc.published = 1

  LEFT JOIN jos_users AS ua 
  ON ua.id = c.core_created_user_id

  WHERE m.tag_id IN (6) 
  AND m.type_alias IN ('com_content.article','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category') 
  AND c.core_access IN (0,1,5)

  GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, name, author_email

  ORDER BY MAX(`c`.`core_title`) ASC 
  LIMIT 20

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_tag_type,idx_core_content_id	idx_tag_type	4	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	c	eq_ref	PRIMARY,tag_idx,idx_access,idx_content_type	PRIMARY	4	fanshop17.m.core_content_id	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	fanshop17.c.core_created_user_id	1	Using where
1	SIMPLE	tc	eq_ref	PRIMARY	PRIMARY	4	fanshop17.c.core_catid	1	Using where
1	SIMPLE	ct	ref	idx_alias	idx_alias	402	fanshop17.m.type_alias	1	Using where

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.20 ms
Checking permissions	0.01 ms
Opening tables	1.14 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.03 ms
Init	0.10 ms
Waiting for query cache lock	0.01 ms
Init	0.00 ms
Storing result in query cache	0.15 ms
Optimizing	0.05 ms
Statistics	0.11 ms
Preparing	0.04 ms
Creating tmp table	0.11 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.81 ms
Creating sort index	0.07 ms
Removing tmp table	0.17 ms
Creating sort index	0.01 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.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
13	JModelList->getItems()	JROOT/components/com_tags/models/tag.php:86
12	TagsModelTag->getItems()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:51
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.01 ms Nach letzter Abfrage: 5.35 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.146 MB Zeilen zurückgegeben: 30

SHOW FULL COLUMNS 
  FROM `jos_tags`

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.20 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.02 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.34 ms
After opening tables	0.01 ms
Checking permissions	0.10 ms
Closing tables	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.00 ms
Closing tables	0.00 ms
Removing tmp table	0.09 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
15	JTable->__construct()	JROOT/administrator/components/com_tags/tables/tag.php:28
14	TagsTableTag->__construct()	JROOT/libraries/joomla/table/table.php:308
13	JTable::getInstance()	JROOT/components/com_tags/models/tag.php:271
12	TagsModelTag->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:52
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.39 ms Nach letzter Abfrage: 8.95 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 5.279 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #25 #26

SELECT *

  FROM jos_tags

  WHERE `id` = '6'

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_tags	const	PRIMARY	PRIMARY	4	const	1

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.02 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
Waiting for query cache lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 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.00 ms
Waiting for query cache lock	0.00 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.06 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
13	JTable->load()	JROOT/components/com_tags/models/tag.php:280
12	TagsModelTag->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:52
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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: 2.90 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 5.334 MB Zeilen zurückgegeben: 1

SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
  CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
  CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email

  FROM jos_contentitem_tag_map AS m

  INNER JOIN jos_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2024-11-21 09:15:00')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2024-11-21 09:15:00')

  INNER JOIN jos_content_types AS ct 
  ON ct.type_alias = m.type_alias

  INNER JOIN jos_categories AS tc 
  ON tc.id = c.core_catid 
  AND tc.published = 1

  LEFT JOIN jos_users AS ua 
  ON ua.id = c.core_created_user_id

  WHERE m.tag_id IN (6) 
  AND m.type_alias IN ('com_content.article','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category') 
  AND c.core_access IN (0,1,5)

  GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, name, author_email

  ORDER BY MAX(`c`.`core_title`) ASC

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_tag_type,idx_core_content_id	idx_tag_type	4	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	c	eq_ref	PRIMARY,tag_idx,idx_access,idx_content_type	PRIMARY	4	fanshop17.m.core_content_id	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	fanshop17.c.core_created_user_id	1	Using where
1	SIMPLE	tc	eq_ref	PRIMARY	PRIMARY	4	fanshop17.c.core_catid	1	Using where
1	SIMPLE	ct	ref	idx_alias	idx_alias	402	fanshop17.m.type_alias	1	Using where

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.15 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.00 ms
Waiting for query cache lock	0.02 ms
Init	0.07 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Storing result in query cache	0.03 ms
Optimizing	0.04 ms
Statistics	0.06 ms
Preparing	0.05 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.36 ms
Creating sort index	0.05 ms
Removing tmp table	0.14 ms
Creating sort index	0.01 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.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/legacy/model/legacy.php:350
14	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:278
13	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:228
12	JModelList->getPagination()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:55
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.89 ms Nach letzter Abfrage: 40.59 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 5.601 MB Zeilen zurückgegeben: 8

SHOW FULL COLUMNS 
  FROM `jos_assets`

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.21 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.02 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.27 ms
After opening tables	0.01 ms
Checking permissions	0.05 ms
Closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.04 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.09 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
26	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
25	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
24	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
23	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
22	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
21	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
20	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
19	JUser->authorise()	JROOT/plugins/system/sourcerer/src/Params.php:42
18	RegularLabs\Sourcerer\Params::get()	JROOT/plugins/system/sourcerer/src/Helper.php:28
17	RegularLabs\Sourcerer\Helper->onContentPrepare()	Der selbe Aufruf in der Zeile darunter.
16	call_user_func_array()	JROOT/plugins/system/sourcerer/src/Plugin.php:110
15	RegularLabs\Sourcerer\Plugin->run()	JROOT/plugins/system/sourcerer/src/Plugin.php:64
14	RegularLabs\Sourcerer\Plugin->onContentPrepare()	Der selbe Aufruf in der Zeile darunter.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT/components/com_tags/views/tag/view.html.php:99
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.10 ms Nach letzter Abfrage: 0.28 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 5.657 MB Zeilen zurückgegeben: 1

SELECT *

  FROM jos_assets

  WHERE `id` = '1'

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_assets	const	PRIMARY	PRIMARY	4	const	1

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.01 ms
Checking privileges on cached	0.00 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
23	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
22	JTable->load()	JROOT/libraries/joomla/access/access.php:697
21	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
20	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
19	JUser->authorise()	JROOT/plugins/system/sourcerer/src/Params.php:42
18	RegularLabs\Sourcerer\Params::get()	JROOT/plugins/system/sourcerer/src/Helper.php:28
17	RegularLabs\Sourcerer\Helper->onContentPrepare()	Der selbe Aufruf in der Zeile darunter.
16	call_user_func_array()	JROOT/plugins/system/sourcerer/src/Plugin.php:110
15	RegularLabs\Sourcerer\Plugin->run()	JROOT/plugins/system/sourcerer/src/Plugin.php:64
14	RegularLabs\Sourcerer\Plugin->onContentPrepare()	Der selbe Aufruf in der Zeile darunter.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT/components/com_tags/views/tag/view.html.php:99
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.10 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 5.683 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #24

SELECT a.rules

  FROM jos_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.01 ms
Checking privileges on cached	0.00 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
21	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
20	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
19	JUser->authorise()	JROOT/plugins/system/sourcerer/src/Params.php:42
18	RegularLabs\Sourcerer\Params::get()	JROOT/plugins/system/sourcerer/src/Helper.php:28
17	RegularLabs\Sourcerer\Helper->onContentPrepare()	Der selbe Aufruf in der Zeile darunter.
16	call_user_func_array()	JROOT/plugins/system/sourcerer/src/Plugin.php:110
15	RegularLabs\Sourcerer\Plugin->run()	JROOT/plugins/system/sourcerer/src/Plugin.php:64
14	RegularLabs\Sourcerer\Plugin->onContentPrepare()	Der selbe Aufruf in der Zeile darunter.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT/components/com_tags/views/tag/view.html.php:99
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.10 ms Nach letzter Abfrage: 4.63 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 5.723 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #23

SELECT a.rules

  FROM jos_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.00 ms
Checking privileges on cached	0.00 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
22	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
21	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:176
20	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
19	JUser->authorise()	JROOT/plugins/system/sourcerer/src/Params.php:42
18	RegularLabs\Sourcerer\Params::get()	JROOT/plugins/system/sourcerer/src/Helper.php:28
17	RegularLabs\Sourcerer\Helper->onContentPrepare()	Der selbe Aufruf in der Zeile darunter.
16	call_user_func_array()	JROOT/plugins/system/sourcerer/src/Plugin.php:110
15	RegularLabs\Sourcerer\Plugin->run()	JROOT/plugins/system/sourcerer/src/Plugin.php:64
14	RegularLabs\Sourcerer\Plugin->onContentPrepare()	Der selbe Aufruf in der Zeile darunter.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT/components/com_tags/views/tag/view.html.php:99
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.11 ms Nach letzter Abfrage: 8.05 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 5.810 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #19 #26

SELECT *

  FROM jos_tags

  WHERE `id` = '6'

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_tags	const	PRIMARY	PRIMARY	4	const	1

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.01 ms
Checking privileges on cached	0.00 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
16	JTable->load()	JROOT/components/com_tags/models/tag.php:280
15	TagsModelTag->getItem()	JROOT/plugins/system/customcanonical/customcanonical.php:145
14	plgSystemCustomCanonical->onContentPrepare()	Der selbe Aufruf in der Zeile darunter.
13	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
11	JEventDispatcher->trigger()	JROOT/components/com_tags/views/tag/view.html.php:99
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.10 ms Nach letzter Abfrage: 4.75 ms Abfragespeichernutzung: 0.018 MB Speichernutzung vor Abfrage: 5.879 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #19 #25

SELECT *

  FROM jos_tags

  WHERE `id` = '6'

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_tags	const	PRIMARY	PRIMARY	4	const	1

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.00 ms
Checking privileges on cached	0.00 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
12	JTable->load()	JROOT/components/com_tags/models/tag.php:325
11	TagsModelTag->hit()	JROOT/components/com_tags/views/tag/view.html.php:184
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.65 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.016 MB Speichernutzung vor Abfrage: 5.895 MB

UPDATE jos_tags

  SET `hits` = (`hits` + 1)

  WHERE `id` = '6'

Erklären

„EXPLAIN“ unmöglich für Abfrage: UPDATE jos_tags SET `hits` = (`hits` + 1) WHERE `id` = '6'

Profil (Profile)

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
Init for update	0.04 ms
Updating	0.06 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.10 ms
Query end	0.00 ms
Commit	0.28 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1228
12	JTable->hit()	JROOT/components/com_tags/models/tag.php:326
11	TagsModelTag->hit()	JROOT/components/com_tags/views/tag/view.html.php:184
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.11 ms Nach letzter Abfrage: 30.56 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 6.060 MB Zeilen zurückgegeben: 35

SELECT element

  FROM jos_extensions

  WHERE type = 'component' 
  AND enabled = '1'

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.01 ms
Checking privileges on cached	0.00 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
20	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
19	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
18	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
17	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
16	JUser->authorise()	JROOT/components/com_tags/views/tag/tmpl/default_items.php:22
15	include JROOT/components/com_tags/views/tag/tmpl/default_items.php	JROOT/libraries/legacy/view/legacy.php:677
14	JViewLegacy->loadTemplate()	JROOT/components/com_tags/views/tag/tmpl/default.php:51
13	include JROOT/components/com_tags/views/tag/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
11	JViewLegacy->display()	JROOT/components/com_tags/views/tag/view.html.php:188
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.10 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 6.094 MB Zeilen zurückgegeben: 35

SELECT a.name, a.rules

  FROM jos_assets AS a

  WHERE (a.name IN ('com_admin','com_ajax','com_amazonws','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_gantry','com_gantry5','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_roksprocket','com_search','com_tags','com_templates','com_users','com_wrapper') OR a.name = 'root.1')

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
Init	0.00 ms
Checking query cache for query	0.01 ms
Checking privileges on cached	0.00 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
20	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
19	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
18	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
17	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
16	JUser->authorise()	JROOT/components/com_tags/views/tag/tmpl/default_items.php:22
15	include JROOT/components/com_tags/views/tag/tmpl/default_items.php	JROOT/libraries/legacy/view/legacy.php:677
14	JViewLegacy->loadTemplate()	JROOT/components/com_tags/views/tag/tmpl/default.php:51
13	include JROOT/components/com_tags/views/tag/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
11	JViewLegacy->display()	JROOT/components/com_tags/views/tag/view.html.php:188
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.11 ms Nach letzter Abfrage: 12.81 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 6.493 MB Zeilen zurückgegeben: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM jos_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM jos_categories AS cat JOIN jos_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN jos_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('de-DE','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=2

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; filesort wurde genutzt
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	8	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	fanshop17.c.id	2	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	Using index condition; Using temporary; filesort wurde genutzt
2	DERIVED	cat	index	PRIMARY,idx_left_right	idx_left_right	8	NULL	8	Using where; Using index; Using join buffer (flat, BNL join)

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.01 ms
Checking privileges on cached	0.00 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
19	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
18	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
17	ContentHelperRoute::getArticleRoute()	JROOT/components/com_tags/helpers/route.php:55
16	TagsHelperRoute::getItemRoute()	JROOT/components/com_tags/views/tag/tmpl/default_items.php:83
15	include JROOT/components/com_tags/views/tag/tmpl/default_items.php	JROOT/libraries/legacy/view/legacy.php:677
14	JViewLegacy->loadTemplate()	JROOT/components/com_tags/views/tag/tmpl/default.php:51
13	include JROOT/components/com_tags/views/tag/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
11	JViewLegacy->display()	JROOT/components/com_tags/views/tag/view.html.php:188
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.10 ms Nach letzter Abfrage: 3.02 ms Abfragespeichernutzung: 0.013 MB Speichernutzung vor Abfrage: 6.507 MB Zeilen zurückgegeben: 1

SELECT language,id

  FROM `jos_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
Init	0.00 ms
Checking query cache for query	0.01 ms
Checking privileges on cached	0.00 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:121
9	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:697
8	PlgSystemLanguageFilter->onAfterDispatch()	Der selbe Aufruf in der Zeile darunter.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.68 ms Nach letzter Abfrage: 25.42 ms Abfragespeichernutzung: 0.018 MB Speichernutzung vor Abfrage: 6.617 MB Zeilen zurückgegeben: 8

SELECT s.id, e.extension_id, s.template AS name, s.title, 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 
  AND e.state = 0

  ORDER BY s.id

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	index	idx_template	PRIMARY	4	NULL	10	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	fanshop17.s.template,const	1	Using index condition; Using where

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	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
Waiting for query cache lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.16 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.00 ms
Waiting for query cache lock	0.00 ms
Updating status	0.02 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.01 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry5/classes/Gantry/Admin/ThemeList.php:142
12	Gantry\Admin\ThemeList::loadStyles()	JROOT/libraries/gantry5/classes/Gantry/Admin/ThemeList.php:70
11	Gantry\Admin\ThemeList::getStyles()	JROOT/libraries/gantry5/classes/Gantry/Framework/Outlines.php:75
10	Gantry\Framework\Outlines->load()	JROOT/libraries/gantry5/classes/Gantry/Framework/Base/Gantry.php:256
9	Gantry\Framework\Gantry::Gantry\Framework\Base\{closure}()	JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:109
8	Pimple\Container->offsetGet()	JROOT/templates/rt_ambrosia/index.php:20
7	require JROOT/templates/rt_ambrosia/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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.89 ms Nach letzter Abfrage: 13.63 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 6.745 MB Zeilen zurückgegeben: 17

SHOW FULL COLUMNS 
  FROM `jos_extensions`

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.31 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.05 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
Checking permissions	0.08 ms
Closing tables	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.00 ms
Closing tables	0.00 ms
Removing tmp table	0.12 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
15	JTable->__construct()	JROOT/libraries/joomla/table/extension.php:31
14	JTableExtension->__construct()	JROOT/libraries/joomla/table/table.php:308
13	JTable::getInstance()	JROOT/libraries/gantry5/classes/Gantry/Framework/ThemeInstaller.php:56
12	Gantry\Framework\ThemeInstaller->loadExtension()	JROOT/libraries/gantry5/classes/Gantry/Framework/ThemeInstaller.php:33
11	Gantry\Framework\ThemeInstaller->__construct()	JROOT/libraries/gantry5/classes/Gantry/Framework/Outlines.php:77
10	Gantry\Framework\Outlines->load()	JROOT/libraries/gantry5/classes/Gantry/Framework/Base/Gantry.php:256
9	Gantry\Framework\Gantry::Gantry\Framework\Base\{closure}()	JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:109
8	Pimple\Container->offsetGet()	JROOT/templates/rt_ambrosia/index.php:20
7	require JROOT/templates/rt_ambrosia/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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.51 ms Nach letzter Abfrage: 0.36 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 6.812 MB Zeilen zurückgegeben: 1

SELECT *

  FROM jos_extensions

  WHERE `type` = 'template' 
  AND `element` = 'rt_ambrosia' 
  AND `client_id` = '0'

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	const,const	1	Using index condition; Using where

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.03 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
Waiting for query cache lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.05 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
Waiting for query cache lock	0.00 ms
Updating status	0.01 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.06 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
13	JTable->load()	JROOT/libraries/gantry5/classes/Gantry/Framework/ThemeInstaller.php:57
12	Gantry\Framework\ThemeInstaller->loadExtension()	JROOT/libraries/gantry5/classes/Gantry/Framework/ThemeInstaller.php:33
11	Gantry\Framework\ThemeInstaller->__construct()	JROOT/libraries/gantry5/classes/Gantry/Framework/Outlines.php:77
10	Gantry\Framework\Outlines->load()	JROOT/libraries/gantry5/classes/Gantry/Framework/Base/Gantry.php:256
9	Gantry\Framework\Gantry::Gantry\Framework\Base\{closure}()	JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:109
8	Pimple\Container->offsetGet()	JROOT/templates/rt_ambrosia/index.php:20
7	require JROOT/templates/rt_ambrosia/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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.66 ms Nach letzter Abfrage: 459.20 ms Abfragespeichernutzung: 0.062 MB Speichernutzung vor Abfrage: 8.785 MB Zeilen zurückgegeben: 11

Doppelte Abfragen: #37

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

  FROM jos_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-21 09:15:00') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-21 09:15:00') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 OR mm.menuid <= 0) 
  AND m.language IN ('de-DE','*')

  ORDER BY m.position, m.ordering

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.03 ms
Waiting for query cache lock	0.00 ms
Init	0.01 ms
Checking query cache for query	0.17 ms
Checking permissions	0.01 ms
Opening tables	0.42 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
Waiting for query cache lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.51 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.00 ms
Waiting for query cache lock	0.00 ms
Updating status	0.02 ms
Waiting for query cache lock	0.00 ms
Updating status	0.00 ms
Storing result in query cache	0.00 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
51	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
50	JDatabaseDriver->loadObjectList()	Der selbe Aufruf in der Zeile darunter.
49	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
48	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
47	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
46	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
45	JModuleHelper::getModules()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:233
44	Gantry\Framework\Platform->displayModules()	Der selbe Aufruf in der Zeile darunter.
43	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:674
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/rt_ambrosia/twig/19/1934d1dd081863a859742bccf70e0360b3b21d575f912f0cedfd51dc4dde7e2a.php:32
41	__TwigTemplate_a8eb3446f79d25b337a5fc0a02a0c27065465a1302631ee9de6a90629295ab8d->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/rt_ambrosia/twig/2b/2ba11faf0e795c2aa2ad2fefcfd9651f610d708606b7bde4130f7fd873225341.php:62
39	__TwigTemplate_627f55d93101a7303b1a50e6bff3dcd1d9ff538083c1ebc5de05ecb0fc608d33->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
37	Twig_Template->display()	JROOT/cache/gantry5/rt_ambrosia/twig/19/1934d1dd081863a859742bccf70e0360b3b21d575f912f0cedfd51dc4dde7e2a.php:24
36	__TwigTemplate_a8eb3446f79d25b337a5fc0a02a0c27065465a1302631ee9de6a90629295ab8d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
34	Twig_Template->display()	JROOT/cache/gantry5/rt_ambrosia/twig/21/21ab98c34af7416e699a1277765a1ae0a8bc72340571e839bbb7602b662c49b9.php:42
33	__TwigTemplate_c34aae925c9e5e9981488cd1c27c079e10a0ea458b4fa9eaa071e9c68a00f08b->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:362
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:672
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/rt_ambrosia/twig/b6/b60d6b7ebc26d3e90c4a5994322b0038d76cf3726b2f574db23e04396ef7ad39.php:36
19	__TwigTemplate_34927826214d78ddf27eb22bea8362e1d8464c3b71ad42460ce8044fb4c720fd->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
17	Twig_Template->display()	JROOT/cache/gantry5/rt_ambrosia/twig/f6/f67b75db59779b5aa496a69a48ba92aa05fe398c4bad266321c8c3f2fdd6d36c.php:24
16	__TwigTemplate_568fe86c367584ffd90dda7b6346bde863377523d784408a601c314b0d0d8dcd->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
14	Twig_Template->display()	JROOT/cache/gantry5/rt_ambrosia/twig/60/6092165b9a125cf3fe5a2ccbfedaa81cfa43449a57e615b33ac4781d70436ce4.php:24
13	__TwigTemplate_56eef109733d8091a859e0ccc0c41ddb9195ee944c93a8f0b0ebdc344e108696->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:362
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_ambrosia/index.php:25
7	require JROOT/templates/rt_ambrosia/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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.11 ms Nach letzter Abfrage: 18.32 ms Abfragespeichernutzung: 0.053 MB Speichernutzung vor Abfrage: 8.964 MB Zeilen zurückgegeben: 7

SELECT a.menutype

  FROM jos_menu_types AS a

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index	NULL	idx_menutype	98	NULL	7	Using index

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.01 ms
Init	0.00 ms
Checking query cache for query	0.01 ms
Checking privileges on cached	0.01 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
43	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
42	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_menus/helpers/menus.php:131
41	MenusHelper::getMenuTypes()	JROOT/libraries/gantry5/classes/Gantry/Framework/Menu.php:71
40	Gantry\Framework\Menu->getMenus()	JROOT/libraries/gantry5/classes/Gantry/Component/Menu/AbstractMenu.php:115
39	Gantry\Component\Menu\AbstractMenu->instance()	Der selbe Aufruf in der Zeile darunter.
38	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:674
37	Twig_Template->getAttribute()	JROOT/cache/gantry5/rt_ambrosia/twig/86/8608668ef4c9be7c55b2178e4be57654d21350307fea3c30cdd82573a4a15801.php:20
36	__TwigTemplate_ce5dcbb4bfa9b4fb90ae030582060bcdb0a17479f09119810b4cda42c0c1fc16->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
34	Twig_Template->display()	JROOT/cache/gantry5/rt_ambrosia/twig/5b/5bbb4874b9b5aded2ffb44f3d113afcbd194b0828d9d0acc86eb94d3f4ba9ef6.php:60
33	__TwigTemplate_98aa1c36556ef72d094082d8eda70e10274d63acb6a0a777c5992fbf94c16506->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:362
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:672
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/rt_ambrosia/twig/b6/b60d6b7ebc26d3e90c4a5994322b0038d76cf3726b2f574db23e04396ef7ad39.php:36
19	__TwigTemplate_34927826214d78ddf27eb22bea8362e1d8464c3b71ad42460ce8044fb4c720fd->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
17	Twig_Template->display()	JROOT/cache/gantry5/rt_ambrosia/twig/f6/f67b75db59779b5aa496a69a48ba92aa05fe398c4bad266321c8c3f2fdd6d36c.php:24
16	__TwigTemplate_568fe86c367584ffd90dda7b6346bde863377523d784408a601c314b0d0d8dcd->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
14	Twig_Template->display()	JROOT/cache/gantry5/rt_ambrosia/twig/60/6092165b9a125cf3fe5a2ccbfedaa81cfa43449a57e615b33ac4781d70436ce4.php:24
13	__TwigTemplate_56eef109733d8091a859e0ccc0c41ddb9195ee944c93a8f0b0ebdc344e108696->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:362
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_ambrosia/index.php:25
7	require JROOT/templates/rt_ambrosia/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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.16 ms Nach letzter Abfrage: 61.77 ms Abfragespeichernutzung: 0.066 MB Speichernutzung vor Abfrage: 9.773 MB Zeilen zurückgegeben: 11

Doppelte Abfragen: #35

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

  FROM jos_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-11-21 09:15:00') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-21 09:15:00') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 OR mm.menuid <= 0) 
  AND m.language IN ('de-DE','*')

  ORDER BY m.position, m.ordering

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.02 ms
Waiting for query cache lock	0.01 ms
Init	0.00 ms
Checking query cache for query	0.01 ms
Checking privileges on cached	0.00 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.02 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
54	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
53	JDatabaseDriver->loadObjectList()	Der selbe Aufruf in der Zeile darunter.
52	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
51	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
50	JModuleHelper::getModuleList()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:276
49	Gantry\Framework\Platform->getModuleList()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:269
48	Gantry\Framework\Platform->getModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:183
47	Gantry\Framework\Platform->displayModule()	Der selbe Aufruf in der Zeile darunter.
46	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:674
45	Twig_Template->getAttribute()	JROOT/cache/gantry5/rt_ambrosia/twig/71/710a80518c5e34994b34b6288ce28c233a1e4917a033158def8cac373a95272d.php:32
44	__TwigTemplate_b99a9ad07d7d76bac4589a001fd426b0866ede45a017cd24e90cd620076d9d54->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
43	Twig_Template->displayBlock()	JROOT/cache/gantry5/rt_ambrosia/twig/2b/2ba11faf0e795c2aa2ad2fefcfd9651f610d708606b7bde4130f7fd873225341.php:62
42	__TwigTemplate_627f55d93101a7303b1a50e6bff3dcd1d9ff538083c1ebc5de05ecb0fc608d33->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
41	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
40	Twig_Template->display()	JROOT/cache/gantry5/rt_ambrosia/twig/71/710a80518c5e34994b34b6288ce28c233a1e4917a033158def8cac373a95272d.php:24
39	__TwigTemplate_b99a9ad07d7d76bac4589a001fd426b0866ede45a017cd24e90cd620076d9d54->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
37	Twig_Template->display()	JROOT/cache/gantry5/rt_ambrosia/twig/21/21ab98c34af7416e699a1277765a1ae0a8bc72340571e839bbb7602b662c49b9.php:42
36	__TwigTemplate_c34aae925c9e5e9981488cd1c27c079e10a0ea458b4fa9eaa071e9c68a00f08b->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
34	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
33	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:362
32	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
31	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
30	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
29	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
28	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
27	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:672
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/rt_ambrosia/twig/b6/b60d6b7ebc26d3e90c4a5994322b0038d76cf3726b2f574db23e04396ef7ad39.php:36
19	__TwigTemplate_34927826214d78ddf27eb22bea8362e1d8464c3b71ad42460ce8044fb4c720fd->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
17	Twig_Template->display()	JROOT/cache/gantry5/rt_ambrosia/twig/f6/f67b75db59779b5aa496a69a48ba92aa05fe398c4bad266321c8c3f2fdd6d36c.php:24
16	__TwigTemplate_568fe86c367584ffd90dda7b6346bde863377523d784408a601c314b0d0d8dcd->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
14	Twig_Template->display()	JROOT/cache/gantry5/rt_ambrosia/twig/60/6092165b9a125cf3fe5a2ccbfedaa81cfa43449a57e615b33ac4781d70436ce4.php:24
13	__TwigTemplate_56eef109733d8091a859e0ccc0c41ddb9195ee944c93a8f0b0ebdc344e108696->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:362
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/rt_ambrosia/index.php:25
7	require JROOT/templates/rt_ambrosia/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Abfragezeit: 6.19 ms Nach letzter Abfrage: 141.49 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 10.422 MB Zeilen zurückgegeben: 6

SHOW FULL COLUMNS 
  FROM `jos_template_styles`

Erklären

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

Profil (Profile)

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.28 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.05 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
Checking permissions	0.06 ms
Closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.05 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.10 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
19	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
18	JTable->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
17	TemplatesTableStyle->__construct()	JROOT/libraries/joomla/table/table.php:308
16	JTable::getInstance()	JROOT/plugins/system/gantry/gantry.php:194
15	plgSystemGantry->getTable()	JROOT/plugins/system/gantry/gantry.php:165
14	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
13	plgSystemGantry->onBeforeCompileHead()	Der selbe Aufruf in der Zeile darunter.
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
10	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
9	JApplicationBase->triggerEvent()	JROOT/libraries/joomla/document/renderer/html/head.php:58
8	JDocumentRendererHtmlHead->fetchHead()	JROOT/libraries/joomla/document/renderer/html/head.php:34
7	JDocumentRendererHtmlHead->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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.17 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 10.465 MB Zeilen zurückgegeben: 1

SELECT *

  FROM jos_template_styles

  WHERE `id` = '17'

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_template_styles	const	PRIMARY	PRIMARY	4	const	1

Profil (Profile)

Status	Duration
Starting	0.01 ms
Waiting for query cache lock	0.00 ms
Init	0.00 ms
Checking query cache for query	0.01 ms
Checking privileges on cached	0.00 ms
Checking permissions	0.01 ms
Sending cached result to clien	0.01 ms
Updating status	0.00 ms
Reset for next command	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
15	JTable->load()	JROOT/plugins/system/gantry/gantry.php:168
14	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
13	plgSystemGantry->onBeforeCompileHead()	Der selbe Aufruf in der Zeile darunter.
12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
10	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
9	JApplicationBase->triggerEvent()	JROOT/libraries/joomla/document/renderer/html/head.php:58
8	JDocumentRendererHtmlHead->fetchHead()	JROOT/libraries/joomla/document/renderer/html/head.php:34
7	JDocumentRendererHtmlHead->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT-Tabellen:

```
3 × SELECT * 
  FROM jos_tags
```

2 × SELECT a.rules 
  FROM jos_assets AS a

2 × SELECT element 
  FROM jos_extensions

2 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM jos_modules AS m 
  LEFT JOIN jos_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN jos_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

2 × SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
  CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
  CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email 
  FROM jos_contentitem_tag_map AS m 
  INNER JOIN jos_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2024-11-21 09:15:00')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2024-11-21 09:15:00') 
  INNER JOIN jos_content_types AS ct 
  ON ct.type_alias = m.type_alias 
  INNER JOIN jos_categories AS tc 
  ON tc.id = c.core_catid 
  AND tc.published = 1 
  LEFT JOIN jos_users AS ua 
  ON ua.id = c.core_created_user_id

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

1 × SELECT a.name, a.rules 
  FROM jos_assets AS a

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM jos_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM jos_categories AS cat JOIN jos_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT s.id, e.extension_id, s.template AS name, s.title, 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

1 × SELECT * 
  FROM jos_template_styles

1 × SELECT a.menutype 
  FROM jos_menu_types AS

```
1 × SELECT * 
  FROM jos_extensions
```
```
1 × SELECT * 
  FROM jos_assets
```

1 × SELECT language,id 
  FROM `jos_menu`

1 × SELECT * 
  FROM `jos_content_types

1 × SELECT id, rules 
  FROM `jos_viewlevels

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

1 × SELECT `session_id` 
  FROM `jos_session`

1 × SELECT folder AS type, element AS name, params 
  FROM jos_extensions

```
1 × SELECT * 
  FROM jos_languages
```

1 × SELECT s.id, s.template, s.home, s.title AS long_title, s.params 
  FROM jos_template_styles AS s

1 × 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

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

1 × SELECT `data` 
  FROM `jos_session`

Andere Tabellen:

1 × UPDATE jos_tags 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `jos_extensions

1 × SHOW FULL COLUMNS 
  FROM `jos_template_styles

1 × SHOW FULL COLUMNS 
  FROM `jos_assets

1 × SHOW FULL COLUMNS 
  FROM `jos_tags

1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('2n5g85kerd8fc99sdomietsme6', 0, 1, '1732180499', 0, ''

1 × UPDATE `jos_extensions` 
  SET `params` = '{\"mediaversion\":\"6663ef83773c9d57a911bcbb7bb2569f\"}'

```
1 × DELETE  
  FROM `jos_session`
```

Fanartikel WM 2018

Fanartikel-Vereine 2. Liga

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

39 ausgeführte Abfragen 31.57 ms

7 Duplikate gefunden!

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

SELECT-Tabellen:

Andere Tabellen: