BABYLON in Berlin - BIFF: SHORTS BLOCK 4

Berlin Independent Film Festival SHORTS BLOCK 4

Last Apartment Berlin [Letzte Wohnung Berlin], D 2022, R: Markus Bräutigam, 23 Min, OV

Obsession, D 2022, R: Moira Sophia Grohé, 18:30 Min, OV

Into The Light [Ins Helle], D 2022, R: Dennis Schigiol, 15:15 Min, OmeU Kamakiri, FR 2022, R: Masato Riesser, 10:26 Min, OV

Illusion, D 2022, R: Sihan Chen, 7:09 Min, OV

TITEL

DATUM

Um unsere Webseite für Sie optimal zu gestalten und fortlaufend verbessern zu können, verwenden wir Cookies. Durch die weitere Nutzung der Webseite stimmen Sie der Verwendung von Cookies zu. Weitere Informationen zu Cookies erhalten Sie in unserer Datenschutzerklärung.

Datenschutzerklärung

Annehmen Ablehnen

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1679877560,
                "last": 1679877560,
                "now": 1679877560
            }
        },
        "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: 14.91 ms / 14.91 ms Speicher: 1.813 MB / 2.18 MB Application: afterLoad

Zeit: 137.44 ms / 152.35 ms Speicher: 7.480 MB / 9.66 MB Application: afterInitialise

Zeit: 49.06 ms / 201.42 ms Speicher: 3.943 MB / 13.61 MB Application: afterRoute

Zeit: 0.46 ms / 201.87 ms Speicher: 0.031 MB / 13.64 MB Application: beforeRenderComponent com_content

Zeit: 1.81 ms / 203.68 ms Speicher: 0.238 MB / 13.87 MB Application: Before Access::preloadComponents (all components)

Zeit: 0.76 ms / 204.44 ms Speicher: 0.063 MB / 13.94 MB Application: After Access::preloadComponents (all components)

Zeit: 0.02 ms / 204.46 ms Speicher: -0.004 MB / 13.93 MB Application: Before Access::preloadPermissions (com_content)

Zeit: 7.71 ms / 212.17 ms Speicher: 4.358 MB / 18.29 MB Application: After Access::preloadPermissions (com_content)

Zeit: 0.12 ms / 212.29 ms Speicher: -0.253 MB / 18.04 MB Application: Before Access::getAssetRules (id:9142 name:com_content.article.5396)

Zeit: 0.50 ms / 212.79 ms Speicher: 0.035 MB / 18.07 MB Application: After Access::getAssetRules (id:9142 name:com_content.article.5396)

Zeit: 36.44 ms / 249.22 ms Speicher: 2.453 MB / 20.53 MB Application: afterRenderComponent com_content

Zeit: 0.86 ms / 250.09 ms Speicher: 0.097 MB / 20.62 MB Application: afterDispatch

Zeit: 32.70 ms / 282.79 ms Speicher: 3.460 MB / 24.08 MB Application: beforeRenderModule mod_finder (smart suche)

Zeit: 6.59 ms / 289.38 ms Speicher: 0.399 MB / 24.48 MB Application: afterRenderModule mod_finder (smart suche)

Zeit: 0.17 ms / 289.55 ms Speicher: -0.020 MB / 24.46 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Zeit: 0.03 ms / 289.58 ms Speicher: 0.007 MB / 24.47 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Zeit: 7.49 ms / 297.08 ms Speicher: 1.025 MB / 25.49 MB Application: beforeRenderModule mod_responsive_grid_for_articles (Festival Grid )

Zeit: 15.19 ms / 312.26 ms Speicher: 1.741 MB / 27.23 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Zeit: 0.02 ms / 312.28 ms Speicher: 0.002 MB / 27.24 MB Application: After Access::getAssetRules (id:8 name:com_content)

Zeit: 10.20 ms / 322.48 ms Speicher: -0.037 MB / 27.20 MB Application: afterRenderModule mod_responsive_grid_for_articles (Festival Grid )

Zeit: 5.99 ms / 328.47 ms Speicher: 0.286 MB / 27.48 MB Application: beforeRenderModule mod_hd-bgselector (Events Background)

Zeit: 0.30 ms / 328.78 ms Speicher: 0.011 MB / 27.50 MB Application: afterRenderModule mod_hd-bgselector (Events Background)

Zeit: 42.11 ms / 370.89 ms Speicher: 3.447 MB / 30.94 MB Application: afterRender

Datenbankabfragen gesamt: 135.52 ms

Speichernutzung

Datenbankabfragen

45 ausgeführte Abfragen 135.52 ms

6 Duplikate gefunden!

2 Duplikate: #10 #11

2 Duplikate: #15 #17

2 Duplikate: #30 #34

Abfragezeit: 0.18 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.897 MB Zeilen zurückgegeben: 0

SELECT `data`

  FROM `jos_session`

  WHERE `session_id` = X'3537346333313436313837333936613530663565336234623832663937643738'

Erklären

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

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.00 ms
executing	0.01 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

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

[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: 0.70 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.055 MB Zeilen zurückgegeben: 0

SELECT `session_id`

  FROM `jos_session`

  WHERE `session_id` = X'3537346333313436313837333936613530663565336234623832663937643738' 
  LIMIT 1

Erklären

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

Profil (Profile)

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 71.09 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 4.061 MB

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

Erklären

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

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
update	0.05 ms
Waiting for query cache lock	0.00 ms
update	0.00 ms
end	0.00 ms
query end	70.73 ms
closing tables	0.03 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 0.72 ms Nach letzter Abfrage: 3.60 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 4.279 MB Zeilen zurückgegeben: 47

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

  FROM `jos_extensions`

  WHERE `type` = 'component' 
  AND `state` = 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,enabled	extension	82	const	47	Using index condition; Using where

Profil (Profile)

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.27 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Der selbe Aufruf in der Zeile darunter.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

[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: 2.69 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.489 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.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

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

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

Abfragezeit: 0.40 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.501 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	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	Using where; Using index

Profil (Profile)

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 1.78 ms Nach letzter Abfrage: 0.83 ms Abfragespeichernutzung: 0.056 MB Speichernutzung vor Abfrage: 4.570 MB Zeilen zurückgegeben: 200

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

  FROM jos_extensions

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

  ORDER BY ordering

Erklären

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

Profil (Profile)

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.79 ms
Sending data	0.64 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Der selbe Aufruf in der Zeile darunter.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 0.19 ms Nach letzter Abfrage: 11.97 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 6.540 MB Zeilen zurückgegeben: 1

SELECT `value`

  FROM `jos_admintools_storage`

  WHERE `key` = 'cparams'

Erklären

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

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:122
12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:37
11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:49
10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:409
9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:892
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:645
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 0.18 ms Nach letzter Abfrage: 0.80 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 6.658 MB Zeilen zurückgegeben: 0

SELECT *

  FROM `jos_admintools_wafexceptions`

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

Erklären

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

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:729
10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:640
9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:901
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:645
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 0.22 ms Nach letzter Abfrage: 5.78 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.399 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #11

SELECT template

  FROM jos_template_styles as s

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

Erklären

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

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:645
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 0.20 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 7.406 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #10

SELECT template

  FROM jos_template_styles as s

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

Erklären

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

Profil (Profile)

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:645
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 0.19 ms Nach letzter Abfrage: 2.01 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 7.638 MB Zeilen zurückgegeben: 2

SELECT extension, file, type

  FROM jos_rokcommon_configs

  ORDER BY priority

Erklären

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

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.01 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:131
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:645
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 0.72 ms Nach letzter Abfrage: 11.47 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 9.111 MB Zeilen zurückgegeben: 18

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.02 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.08 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.04 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
11	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
10	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:646
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 0.24 ms Nach letzter Abfrage: 0.38 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 9.170 MB Zeilen zurückgegeben: 1

SELECT `extension_id`

  FROM `jos_extensions`

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

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

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:47
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:646
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 0.19 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 9.176 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #17

SELECT *

  FROM jos_extensions

  WHERE `extension_id` = '10112'

Erklären

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

Profil (Profile)

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:646
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 0.17 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 9.180 MB Zeilen zurückgegeben: 1

SELECT `extension_id`

  FROM `jos_extensions`

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

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

Profil (Profile)

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:70
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:646
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

[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: 0.05 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 9.188 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #15

SELECT *

  FROM jos_extensions

  WHERE `extension_id` = '10112'

Erklären

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

Profil (Profile)

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:646
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 0.15 ms Nach letzter Abfrage: 9.67 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 9.565 MB Zeilen zurückgegeben: 1

SELECT count(1)

  FROM `jos_session`

  WHERE `session_id` = '' 
  AND client_id = 1 
  AND guest = 0

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/arktypography/arktypography.php:53
8	plgSystemARKtypography->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:646
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 0.84 ms Nach letzter Abfrage: 1.95 ms Abfragespeichernutzung: 0.123 MB Speichernutzung vor Abfrage: 9.846 MB Zeilen zurückgegeben: 62

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	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	192	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	db00108073.m.component_id	1	Using where

Profil (Profile)

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.00 ms
Sorting result	0.37 ms
Sending data	0.27 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Der selbe Aufruf in der Zeile darunter.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:395
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:511
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1119
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 0.24 ms Nach letzter Abfrage: 10.35 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 11.306 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
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Der selbe Aufruf in der Zeile darunter.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/arktypography/arktypography.php:115
8	plgSystemARKtypography->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1168
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 16.66 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 11.299 MB

UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"98f5c4d497e2fa73009900d09b2c852f\"}'

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

Erklären

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

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.03 ms
Updating	0.03 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	16.39 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/arktypography/arktypography.php:115
8	plgSystemARKtypography->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1168
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 0.44 ms Nach letzter Abfrage: 1.99 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 11.479 MB Zeilen zurückgegeben: 1

SELECT params

  FROM `jos_extensions`

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

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

Profil (Profile)

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/arktypography/arktypography.php:127
8	plgSystemARKtypography->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1168
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 0.49 ms Nach letzter Abfrage: 0.30 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 11.486 MB Zeilen zurückgegeben: 30

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,enabled	extension	82	const	6	Using index condition; Using where
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	db00108073.e.element	2	Using index condition; Using where

Profil (Profile)

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/gantry5/gantry5.php:195
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1168
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

[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: 15.12 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 13.433 MB Zeilen zurückgegeben: 30

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 = 'g5_helium'

  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,idx_client_id,idx_client_id_home	PRIMARY	4	NULL	35	Using where

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry5/classes/Gantry/Joomla/StyleHelper.php:46
14	Gantry\Joomla\StyleHelper::loadStyles()	JROOT/libraries/gantry5/classes/Gantry/Framework/Assignments.php:50
13	Gantry\Framework\Assignments->loadAssignments()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:303
12	Gantry\Component\Assignments\AbstractAssignments->init()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:104
11	Gantry\Component\Assignments\AbstractAssignments->scores()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:91
10	Gantry\Component\Assignments\AbstractAssignments->select()	JROOT/plugins/system/gantry5/gantry5.php:246
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1168
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 0.22 ms Nach letzter Abfrage: 1.07 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 13.619 MB Zeilen zurückgegeben: 1

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	3	Using where; filesort wurde genutzt

Profil (Profile)

Status	Duration
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sorting result	0.02 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

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

[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: 1.99 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 13.879 MB Zeilen zurückgegeben: 47

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

  FROM `jos_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_admintools','com_ajax','com_akeeba','com_arkeditor','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_fields','com_finder','com_gallery_wd','com_gantry5','com_imagerecycle','com_installer','com_jch_optimize','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_newsletter2go','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_roksprocket','com_search','com_sitemapfaster','com_tags','com_templates','com_users','com_wrapper')

Erklären

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

Profil (Profile)

Status	Duration
starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.04 ms
optimizing	0.01 ms
statistics	0.13 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.32 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 4.50 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.626 MB Speichernutzung vor Abfrage: 13.934 MB Zeilen zurückgegeben: 5165

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

  FROM `jos_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

Erklären

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

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	4.29 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

[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: 4.36 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 18.113 MB Zeilen zurückgegeben: 31

SHOW FULL COLUMNS 
  FROM `jos_content`

Erklären

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

Profil (Profile)

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.26 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.08 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 7.35 ms Nach letzter Abfrage: 1.89 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 18.332 MB

UPDATE jos_content

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

  WHERE `id` = '5396'

Erklären

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

Profil (Profile)

Status	Duration
starting	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.00 ms
After table lock	0.00 ms
init	0.03 ms
Updating	0.04 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.08 ms
query end	6.99 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 0.54 ms Nach letzter Abfrage: 1.52 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 18.454 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #34

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM jos_content AS a

  INNER JOIN jos_categories AS c 
  on c.id = a.catid

  LEFT JOIN jos_users AS u 
  on u.id = a.created_by

  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN jos_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 5396 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-27 00:39:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-27 00:39:21') 
  AND (a.state = 1 OR a.state =2)

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid,publish_up,publish_down	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	0	unique row not found
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found

Profil (Profile)

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 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.00 ms
After table lock	0.01 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

[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: 2.11 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 18.662 MB Zeilen zurückgegeben: 4

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 `s`

  INNER JOIN `jos_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.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 s.id = 85

  ORDER BY c.lft

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	74	Using index condition; Using where

Profil (Profile)

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
22	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
21	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
20	ContentRouter->getCategorySegment()	Der selbe Aufruf in der Zeile darunter.
19	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
18	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
17	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
16	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
15	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 1.18 ms Nach letzter Abfrage: 0.62 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 18.720 MB Zeilen zurückgegeben: 2

SELECT `m`.`tag_id`,`t`.*

  FROM `jos_contentitem_tag_map` AS m 

  INNER JOIN `jos_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 5396 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	26	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	db00108073.t.id	171	Using index condition; Using where

Profil (Profile)

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.89 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 1.07 ms Nach letzter Abfrage: 9.64 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 19.729 MB Zeilen zurückgegeben: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM jos_fields AS a

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

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

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

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

  LEFT JOIN jos_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `jos_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (85,0,26,21)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	db00108073.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	db00108073.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	db00108073.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	db00108073.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	db00108073.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	db00108073.a.id	1	Using where; Using index; Distinct

Profil (Profile)

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.00 ms
Creating tmp table	0.46 ms
Copying to tmp table	0.03 ms
Sorting result	0.01 ms
Sending data	0.03 ms
end	0.01 ms
removing tmp table	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

[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: 3.12 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 20.087 MB Zeilen zurückgegeben: 1

Doppelte Abfragen: #30

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM jos_content AS a

  INNER JOIN jos_categories AS c 
  on c.id = a.catid

  LEFT JOIN jos_users AS u 
  on u.id = a.created_by

  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN jos_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 5396 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-27 00:39:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-27 00:39:21') 
  AND (a.state = 1 OR a.state =2)

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid,publish_up,publish_down	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	0	unique row not found
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found

Profil (Profile)

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
14	ContentModelArticle->getItem()	JROOT/plugins/content/bb_prowin_tickets/bb_prowin_tickets.php:194
13	PlgContentBb_prowin_tickets->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 1.37 ms Nach letzter Abfrage: 36.73 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 24.039 MB Zeilen zurückgegeben: 13

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 <= '2023-03-27 00:39:21') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-27 00:39:21') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 125 OR mm.menuid <= 0)

  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	published	1	const	78	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,enabled	element_clientid	403	db00108073.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	db00108073.m.id	1	Using where; Using index

Profil (Profile)

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.00 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.00 ms
After table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.00 ms
Sorting result	0.27 ms
Sending data	0.67 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
50	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
49	JDatabaseDriver->loadObjectList()	Der selbe Aufruf in der Zeile darunter.
48	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
47	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
46	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
45	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
44	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:233
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/51/517452f0d13f04f60e06b9e7513b2f8d08fa6686491d0885e1d342f47f65d318.php:32
41	__TwigTemplate_af994d4cb9a8bd0ac174a249e40117dfb234563930566be99b75505a097d4391->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/g5_helium/twig/36/36a5294bfc511419f53948555673795b5ca78e7b0b00a7b98a907a63a2955993.php:62
39	__TwigTemplate_7a0f7bee8cdcb9025ee274ee34b0b07fa6f7447791c5db4bb6a32e2cf5507ca9->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/g5_helium/twig/51/517452f0d13f04f60e06b9e7513b2f8d08fa6686491d0885e1d342f47f65d318.php:24
36	__TwigTemplate_af994d4cb9a8bd0ac174a249e40117dfb234563930566be99b75505a097d4391->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/g5_helium/twig/18/1895c12562b1f4d015443856ff688221906dc05699099d76223efd1f3f5c5a80.php:42
33	__TwigTemplate_1e279137107d58263f15586f9fb5294ec164531e0f9449c5a2c8b8520e988e4f->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:363
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:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/ca/caf9a82b9e1fc3411cd403b106e051eca8d187d5e0f5db7b2851b6fa7ebdd401.php:36
19	__TwigTemplate_e7b8022874c89800a7dfe881717b4d10d320caae5822e64e580c362aa35ee6b1->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/g5_helium/twig/3e/3e69af3a69e044fb09e268fb98a757b375eba0b21d9160a9d89a4b26ef1d21bc.php:24
16	__TwigTemplate_a946746b220038452718e74d23a946b950368f0f99038d8a505517cf2103c56a->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/g5_helium/twig/45/459d4ac807fb1688b522757aad84cf841b83b8a292295dbcb444331bb032f64e.php:24
13	__TwigTemplate_c2237b0b6e4b85fd146be088807d0a64056f55aac5abf8977495dfa4f7b22b78->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:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_helium/index.php:23
7	require JROOT/templates/g5_helium/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 0.25 ms Nach letzter Abfrage: 1.46 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 24.146 MB Zeilen zurückgegeben: 5

SELECT `name`,`element`

  FROM `jos_extensions`

  WHERE `type` = 'plugin' 
  AND `folder` = 'finder' 
  AND `enabled` = 1

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_extensions	ref	extension,folder,enabled	folder	58	const	5	Using where

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
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
50	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
49	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_finder/helpers/language.php:126
48	FinderHelperLanguage::loadPluginLanguage()	JROOT/modules/mod_finder/mod_finder.php:51
47	include JROOT/modules/mod_finder/mod_finder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/51/517452f0d13f04f60e06b9e7513b2f8d08fa6686491d0885e1d342f47f65d318.php:32
41	__TwigTemplate_af994d4cb9a8bd0ac174a249e40117dfb234563930566be99b75505a097d4391->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/g5_helium/twig/36/36a5294bfc511419f53948555673795b5ca78e7b0b00a7b98a907a63a2955993.php:62
39	__TwigTemplate_7a0f7bee8cdcb9025ee274ee34b0b07fa6f7447791c5db4bb6a32e2cf5507ca9->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/g5_helium/twig/51/517452f0d13f04f60e06b9e7513b2f8d08fa6686491d0885e1d342f47f65d318.php:24
36	__TwigTemplate_af994d4cb9a8bd0ac174a249e40117dfb234563930566be99b75505a097d4391->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/g5_helium/twig/18/1895c12562b1f4d015443856ff688221906dc05699099d76223efd1f3f5c5a80.php:42
33	__TwigTemplate_1e279137107d58263f15586f9fb5294ec164531e0f9449c5a2c8b8520e988e4f->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:363
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:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/ca/caf9a82b9e1fc3411cd403b106e051eca8d187d5e0f5db7b2851b6fa7ebdd401.php:36
19	__TwigTemplate_e7b8022874c89800a7dfe881717b4d10d320caae5822e64e580c362aa35ee6b1->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/g5_helium/twig/3e/3e69af3a69e044fb09e268fb98a757b375eba0b21d9160a9d89a4b26ef1d21bc.php:24
16	__TwigTemplate_a946746b220038452718e74d23a946b950368f0f99038d8a505517cf2103c56a->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/g5_helium/twig/45/459d4ac807fb1688b522757aad84cf841b83b8a292295dbcb444331bb032f64e.php:24
13	__TwigTemplate_c2237b0b6e4b85fd146be088807d0a64056f55aac5abf8977495dfa4f7b22b78->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:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_helium/index.php:23
7	require JROOT/templates/g5_helium/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 0.21 ms Nach letzter Abfrage: 2.29 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 24.330 MB Zeilen zurückgegeben: 1

SELECT f.data, f.params

  FROM `jos_finder_filters` AS f

  WHERE f.filter_id = 1

Erklären

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

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
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
52	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
51	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:498
50	FinderIndexerQuery->processStaticTaxonomy()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:214
49	FinderIndexerQuery->__construct()	JROOT/modules/mod_finder/helper.php:84
48	ModFinderHelper::getQuery()	JROOT/modules/mod_finder/mod_finder.php:54
47	include JROOT/modules/mod_finder/mod_finder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/51/517452f0d13f04f60e06b9e7513b2f8d08fa6686491d0885e1d342f47f65d318.php:32
41	__TwigTemplate_af994d4cb9a8bd0ac174a249e40117dfb234563930566be99b75505a097d4391->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/g5_helium/twig/36/36a5294bfc511419f53948555673795b5ca78e7b0b00a7b98a907a63a2955993.php:62
39	__TwigTemplate_7a0f7bee8cdcb9025ee274ee34b0b07fa6f7447791c5db4bb6a32e2cf5507ca9->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/g5_helium/twig/51/517452f0d13f04f60e06b9e7513b2f8d08fa6686491d0885e1d342f47f65d318.php:24
36	__TwigTemplate_af994d4cb9a8bd0ac174a249e40117dfb234563930566be99b75505a097d4391->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/g5_helium/twig/18/1895c12562b1f4d015443856ff688221906dc05699099d76223efd1f3f5c5a80.php:42
33	__TwigTemplate_1e279137107d58263f15586f9fb5294ec164531e0f9449c5a2c8b8520e988e4f->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:363
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:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/ca/caf9a82b9e1fc3411cd403b106e051eca8d187d5e0f5db7b2851b6fa7ebdd401.php:36
19	__TwigTemplate_e7b8022874c89800a7dfe881717b4d10d320caae5822e64e580c362aa35ee6b1->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/g5_helium/twig/3e/3e69af3a69e044fb09e268fb98a757b375eba0b21d9160a9d89a4b26ef1d21bc.php:24
16	__TwigTemplate_a946746b220038452718e74d23a946b950368f0f99038d8a505517cf2103c56a->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/g5_helium/twig/45/459d4ac807fb1688b522757aad84cf841b83b8a292295dbcb444331bb032f64e.php:24
13	__TwigTemplate_c2237b0b6e4b85fd146be088807d0a64056f55aac5abf8977495dfa4f7b22b78->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:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_helium/index.php:23
7	require JROOT/templates/g5_helium/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 0.50 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.047 MB Speichernutzung vor Abfrage: 24.363 MB Zeilen zurückgegeben: 90

SELECT t1.id, t1.title, t2.title AS branch

  FROM `jos_finder_taxonomy` AS t1

  INNER JOIN `jos_finder_taxonomy` AS t2 
  ON t2.id = t1.parent_id

  WHERE t1.state = 1 
  AND t1.access IN (1,1,5) 
  AND t1.id IN (472,476,280,619,593,587,475,489,396,419,492,532,431,375,449,557,618,540,504,570,571,552,594,441,457,408,285,691,484,518,551,568,398,466,289,455,481,549,430,550,615,488,345,507,480,592,541,410,302,583,369,554,385,519,386,465,388,393,474,569,447,548,384,689,381,353,690,349,470,351,468,506,486,546,545,590,614,350,428,283,482,687,562,371,616,397,495,586,525,561) 
  AND t2.state = 1 
  AND t2.access IN (1,1,5)

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t1	ref	PRIMARY,parent_id,state,access,idx_parent_published	state	1	const	137	Using index condition; Using where
1	SIMPLE	t2	eq_ref	PRIMARY,state,access	PRIMARY	4	db00108073.t1.parent_id	1	Using where

Profil (Profile)

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
52	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
51	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:553
50	FinderIndexerQuery->processStaticTaxonomy()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:214
49	FinderIndexerQuery->__construct()	JROOT/modules/mod_finder/helper.php:84
48	ModFinderHelper::getQuery()	JROOT/modules/mod_finder/mod_finder.php:54
47	include JROOT/modules/mod_finder/mod_finder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/51/517452f0d13f04f60e06b9e7513b2f8d08fa6686491d0885e1d342f47f65d318.php:32
41	__TwigTemplate_af994d4cb9a8bd0ac174a249e40117dfb234563930566be99b75505a097d4391->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/g5_helium/twig/36/36a5294bfc511419f53948555673795b5ca78e7b0b00a7b98a907a63a2955993.php:62
39	__TwigTemplate_7a0f7bee8cdcb9025ee274ee34b0b07fa6f7447791c5db4bb6a32e2cf5507ca9->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/g5_helium/twig/51/517452f0d13f04f60e06b9e7513b2f8d08fa6686491d0885e1d342f47f65d318.php:24
36	__TwigTemplate_af994d4cb9a8bd0ac174a249e40117dfb234563930566be99b75505a097d4391->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/g5_helium/twig/18/1895c12562b1f4d015443856ff688221906dc05699099d76223efd1f3f5c5a80.php:42
33	__TwigTemplate_1e279137107d58263f15586f9fb5294ec164531e0f9449c5a2c8b8520e988e4f->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:363
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:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/ca/caf9a82b9e1fc3411cd403b106e051eca8d187d5e0f5db7b2851b6fa7ebdd401.php:36
19	__TwigTemplate_e7b8022874c89800a7dfe881717b4d10d320caae5822e64e580c362aa35ee6b1->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/g5_helium/twig/3e/3e69af3a69e044fb09e268fb98a757b375eba0b21d9160a9d89a4b26ef1d21bc.php:24
16	__TwigTemplate_a946746b220038452718e74d23a946b950368f0f99038d8a505517cf2103c56a->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/g5_helium/twig/45/459d4ac807fb1688b522757aad84cf841b83b8a292295dbcb444331bb032f64e.php:24
13	__TwigTemplate_c2237b0b6e4b85fd146be088807d0a64056f55aac5abf8977495dfa4f7b22b78->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:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_helium/index.php:23
7	require JROOT/templates/g5_helium/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 0.25 ms Nach letzter Abfrage: 0.42 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 24.429 MB Zeilen zurückgegeben: 4

SELECT `title`

  FROM `jos_finder_taxonomy`

  WHERE `parent_id` = 1 
  AND `state` = 1 
  AND `access` IN (1,1,5)

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_finder_taxonomy	ref	parent_id,state,access,idx_parent_published	parent_id	4	const	4	Using where

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
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
53	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
52	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_finder/helpers/indexer/taxonomy.php:258
51	FinderIndexerTaxonomy::getBranchTitles()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:750
50	FinderIndexerQuery->processString()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:236
49	FinderIndexerQuery->__construct()	JROOT/modules/mod_finder/helper.php:84
48	ModFinderHelper::getQuery()	JROOT/modules/mod_finder/mod_finder.php:54
47	include JROOT/modules/mod_finder/mod_finder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/51/517452f0d13f04f60e06b9e7513b2f8d08fa6686491d0885e1d342f47f65d318.php:32
41	__TwigTemplate_af994d4cb9a8bd0ac174a249e40117dfb234563930566be99b75505a097d4391->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/g5_helium/twig/36/36a5294bfc511419f53948555673795b5ca78e7b0b00a7b98a907a63a2955993.php:62
39	__TwigTemplate_7a0f7bee8cdcb9025ee274ee34b0b07fa6f7447791c5db4bb6a32e2cf5507ca9->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/g5_helium/twig/51/517452f0d13f04f60e06b9e7513b2f8d08fa6686491d0885e1d342f47f65d318.php:24
36	__TwigTemplate_af994d4cb9a8bd0ac174a249e40117dfb234563930566be99b75505a097d4391->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/g5_helium/twig/18/1895c12562b1f4d015443856ff688221906dc05699099d76223efd1f3f5c5a80.php:42
33	__TwigTemplate_1e279137107d58263f15586f9fb5294ec164531e0f9449c5a2c8b8520e988e4f->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:363
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:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/ca/caf9a82b9e1fc3411cd403b106e051eca8d187d5e0f5db7b2851b6fa7ebdd401.php:36
19	__TwigTemplate_e7b8022874c89800a7dfe881717b4d10d320caae5822e64e580c362aa35ee6b1->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/g5_helium/twig/3e/3e69af3a69e044fb09e268fb98a757b375eba0b21d9160a9d89a4b26ef1d21bc.php:24
16	__TwigTemplate_a946746b220038452718e74d23a946b950368f0f99038d8a505517cf2103c56a->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/g5_helium/twig/45/459d4ac807fb1688b522757aad84cf841b83b8a292295dbcb444331bb032f64e.php:24
13	__TwigTemplate_c2237b0b6e4b85fd146be088807d0a64056f55aac5abf8977495dfa4f7b22b78->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:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_helium/index.php:23
7	require JROOT/templates/g5_helium/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 0.17 ms Nach letzter Abfrage: 4.14 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 24.819 MB Zeilen zurückgegeben: 2

SELECT a.menutype

  FROM jos_menu_types AS a

  WHERE a.client_id = 0

Erklären

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

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
42	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
41	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_menus/helpers/menus.php:154
40	MenusHelper::getMenuTypes()	JROOT/libraries/gantry5/classes/Gantry/Framework/Menu.php:71
39	Gantry\Framework\Menu->getMenus()	JROOT/libraries/gantry5/classes/Gantry/Component/Menu/AbstractMenu.php:115
38	Gantry\Component\Menu\AbstractMenu->instance()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
37	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/a3/a30faa37f1ad6bb3e571aefa6d0cd3ac317b843ad5b895d12a08bcaaeafead7a.php:20
36	__TwigTemplate_283cc55cc5be5d22059188d2c4d52f4454f1077a61ac5f615410ff1de7ec1743->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/g5_helium/twig/70/70a860c22bee6dfcec2325dd5a7a55b6e2ca9eae74f92fffc88bc27c81bdf3ba.php:60
33	__TwigTemplate_c54e5e08d767b484e053b9e0b4c63deeeb52336121e3ca0dbe7f0ee945e3ab9e->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:363
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:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/ca/caf9a82b9e1fc3411cd403b106e051eca8d187d5e0f5db7b2851b6fa7ebdd401.php:36
19	__TwigTemplate_e7b8022874c89800a7dfe881717b4d10d320caae5822e64e580c362aa35ee6b1->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/g5_helium/twig/3e/3e69af3a69e044fb09e268fb98a757b375eba0b21d9160a9d89a4b26ef1d21bc.php:24
16	__TwigTemplate_a946746b220038452718e74d23a946b950368f0f99038d8a505517cf2103c56a->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/g5_helium/twig/45/459d4ac807fb1688b522757aad84cf841b83b8a292295dbcb444331bb032f64e.php:24
13	__TwigTemplate_c2237b0b6e4b85fd146be088807d0a64056f55aac5abf8977495dfa4f7b22b78->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:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_helium/index.php:23
7	require JROOT/templates/g5_helium/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 8.48 ms Nach letzter Abfrage: 8.13 ms Abfragespeichernutzung: 0.572 MB Speichernutzung vor Abfrage: 25.960 MB Zeilen zurückgegeben: 101

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,(
SELECT COUNT(i.`id`)

  FROM `jos_content` AS `i`

  WHERE i.`catid` = c.id 
  AND i.state = 1) AS numitems

  FROM `jos_categories` AS `s`

  INNER JOIN `jos_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.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 s.id = 26

  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	filesort wurde genutzt
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	353	Using where
2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid	idx_catid	4	db00108073.c.id	23	Using index condition; Using where

Profil (Profile)

Status	Duration
executing	0.00 ms
Sending data	0.06 ms
executing	0.00 ms
Sending data	0.07 ms
executing	0.00 ms
Sending data	0.05 ms
executing	0.00 ms
Sending data	0.07 ms
executing	0.00 ms
Sending data	0.05 ms
executing	0.00 ms
Sending data	0.05 ms
executing	0.00 ms
Sending data	0.03 ms
executing	0.00 ms
Sending data	0.14 ms
executing	0.00 ms
Sending data	0.07 ms
executing	0.00 ms
Sending data	0.03 ms
executing	0.00 ms
Sending data	0.06 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
executing	0.00 ms
Sending data	0.09 ms
executing	0.00 ms
Sending data	0.08 ms
executing	0.00 ms
Sending data	0.05 ms
executing	0.00 ms
Sending data	0.03 ms
executing	0.00 ms
Sending data	0.09 ms
executing	0.00 ms
Sending data	0.07 ms
executing	0.00 ms
Sending data	0.04 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
Sending data	0.13 ms
executing	0.00 ms
Sending data	0.07 ms
executing	0.00 ms
Sending data	0.09 ms
executing	0.00 ms
Sending data	0.03 ms
executing	0.00 ms
Sending data	0.03 ms
executing	0.00 ms
Sending data	0.05 ms
executing	0.00 ms
Sending data	0.13 ms
executing	0.00 ms
Sending data	0.05 ms
executing	0.00 ms
Sending data	0.03 ms
executing	0.00 ms
Sending data	0.10 ms
executing	0.00 ms
Sending data	0.05 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
Sending data	0.06 ms
executing	0.00 ms
Sending data	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
executing	0.00 ms
Sending data	0.03 ms
executing	0.00 ms
Sending data	0.03 ms
executing	0.00 ms
Sending data	0.05 ms
executing	0.00 ms
Sending data	0.07 ms
executing	0.00 ms
Sending data	0.13 ms
executing	0.00 ms
Sending data	0.13 ms
executing	0.00 ms
Sending data	0.17 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
removing tmp table	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
56	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
55	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
54	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
53	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/categories.php:115
52	ContentModelCategories->getItems()	JROOT/modules/mod_responsive_grid_for_articles/helper.php:163
51	ResponsiveGridForArticlesHelper::getList()	JROOT/modules/mod_responsive_grid_for_articles/mod_responsive_grid_for_articles.php:622
50	include JROOT/modules/mod_responsive_grid_for_articles/mod_responsive_grid_for_articles.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
49	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
48	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
47	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
46	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
45	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/51/517452f0d13f04f60e06b9e7513b2f8d08fa6686491d0885e1d342f47f65d318.php:32
44	__TwigTemplate_af994d4cb9a8bd0ac174a249e40117dfb234563930566be99b75505a097d4391->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
43	Twig_Template->displayBlock()	JROOT/cache/gantry5/g5_helium/twig/36/36a5294bfc511419f53948555673795b5ca78e7b0b00a7b98a907a63a2955993.php:62
42	__TwigTemplate_7a0f7bee8cdcb9025ee274ee34b0b07fa6f7447791c5db4bb6a32e2cf5507ca9->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/g5_helium/twig/51/517452f0d13f04f60e06b9e7513b2f8d08fa6686491d0885e1d342f47f65d318.php:24
39	__TwigTemplate_af994d4cb9a8bd0ac174a249e40117dfb234563930566be99b75505a097d4391->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/g5_helium/twig/18/1895c12562b1f4d015443856ff688221906dc05699099d76223efd1f3f5c5a80.php:42
36	__TwigTemplate_1e279137107d58263f15586f9fb5294ec164531e0f9449c5a2c8b8520e988e4f->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:363
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:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/ca/caf9a82b9e1fc3411cd403b106e051eca8d187d5e0f5db7b2851b6fa7ebdd401.php:36
19	__TwigTemplate_e7b8022874c89800a7dfe881717b4d10d320caae5822e64e580c362aa35ee6b1->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/g5_helium/twig/3e/3e69af3a69e044fb09e268fb98a757b375eba0b21d9160a9d89a4b26ef1d21bc.php:24
16	__TwigTemplate_a946746b220038452718e74d23a946b950368f0f99038d8a505517cf2103c56a->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/g5_helium/twig/45/459d4ac807fb1688b522757aad84cf841b83b8a292295dbcb444331bb032f64e.php:24
13	__TwigTemplate_c2237b0b6e4b85fd146be088807d0a64056f55aac5abf8977495dfa4f7b22b78->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:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_helium/index.php:23
7	require JROOT/templates/g5_helium/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 0.75 ms Nach letzter Abfrage: 1.96 ms Abfragespeichernutzung: 0.049 MB Speichernutzung vor Abfrage: 27.118 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.02 ms
checking permissions	0.01 ms
Opening tables	0.22 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Filling schema table	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.07 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
59	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
58	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
57	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
56	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
55	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_tags/tables/tag.php:29
54	TagsTableTag->__construct()	JROOT/libraries/src/Table/Table.php:312
53	Joomla\CMS\Table\Table::getInstance()	JROOT/modules/mod_responsive_grid_for_articles/helper.php:31
52	ResponsiveGridForArticlesHelper::getTagTreeArray()	JROOT/modules/mod_responsive_grid_for_articles/helper.php:196
51	ResponsiveGridForArticlesHelper::getList()	JROOT/modules/mod_responsive_grid_for_articles/mod_responsive_grid_for_articles.php:622
50	include JROOT/modules/mod_responsive_grid_for_articles/mod_responsive_grid_for_articles.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
49	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
48	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
47	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
46	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
45	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/51/517452f0d13f04f60e06b9e7513b2f8d08fa6686491d0885e1d342f47f65d318.php:32
44	__TwigTemplate_af994d4cb9a8bd0ac174a249e40117dfb234563930566be99b75505a097d4391->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
43	Twig_Template->displayBlock()	JROOT/cache/gantry5/g5_helium/twig/36/36a5294bfc511419f53948555673795b5ca78e7b0b00a7b98a907a63a2955993.php:62
42	__TwigTemplate_7a0f7bee8cdcb9025ee274ee34b0b07fa6f7447791c5db4bb6a32e2cf5507ca9->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/g5_helium/twig/51/517452f0d13f04f60e06b9e7513b2f8d08fa6686491d0885e1d342f47f65d318.php:24
39	__TwigTemplate_af994d4cb9a8bd0ac174a249e40117dfb234563930566be99b75505a097d4391->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/g5_helium/twig/18/1895c12562b1f4d015443856ff688221906dc05699099d76223efd1f3f5c5a80.php:42
36	__TwigTemplate_1e279137107d58263f15586f9fb5294ec164531e0f9449c5a2c8b8520e988e4f->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:363
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:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/ca/caf9a82b9e1fc3411cd403b106e051eca8d187d5e0f5db7b2851b6fa7ebdd401.php:36
19	__TwigTemplate_e7b8022874c89800a7dfe881717b4d10d320caae5822e64e580c362aa35ee6b1->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/g5_helium/twig/3e/3e69af3a69e044fb09e268fb98a757b375eba0b21d9160a9d89a4b26ef1d21bc.php:24
16	__TwigTemplate_a946746b220038452718e74d23a946b950368f0f99038d8a505517cf2103c56a->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/g5_helium/twig/45/459d4ac807fb1688b522757aad84cf841b83b8a292295dbcb444331bb032f64e.php:24
13	__TwigTemplate_c2237b0b6e4b85fd146be088807d0a64056f55aac5abf8977495dfa4f7b22b78->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:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_helium/index.php:23
7	require JROOT/templates/g5_helium/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 0.20 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 27.176 MB Zeilen zurückgegeben: 1

SELECT id, parent_id, level, lft, rgt

  FROM jos_tags

  WHERE id = 8 
  LIMIT 1

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.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
56	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
55	JDatabaseDriver->loadObject()	JROOT/libraries/src/Table/Nested.php:1612
54	Joomla\CMS\Table\Nested->_getNode()	JROOT/libraries/src/Table/Nested.php:200
53	Joomla\CMS\Table\Nested->isLeaf()	JROOT/modules/mod_responsive_grid_for_articles/helper.php:33
52	ResponsiveGridForArticlesHelper::getTagTreeArray()	JROOT/modules/mod_responsive_grid_for_articles/helper.php:196
51	ResponsiveGridForArticlesHelper::getList()	JROOT/modules/mod_responsive_grid_for_articles/mod_responsive_grid_for_articles.php:622
50	include JROOT/modules/mod_responsive_grid_for_articles/mod_responsive_grid_for_articles.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
49	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
48	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
47	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
46	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
45	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/51/517452f0d13f04f60e06b9e7513b2f8d08fa6686491d0885e1d342f47f65d318.php:32
44	__TwigTemplate_af994d4cb9a8bd0ac174a249e40117dfb234563930566be99b75505a097d4391->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
43	Twig_Template->displayBlock()	JROOT/cache/gantry5/g5_helium/twig/36/36a5294bfc511419f53948555673795b5ca78e7b0b00a7b98a907a63a2955993.php:62
42	__TwigTemplate_7a0f7bee8cdcb9025ee274ee34b0b07fa6f7447791c5db4bb6a32e2cf5507ca9->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/g5_helium/twig/51/517452f0d13f04f60e06b9e7513b2f8d08fa6686491d0885e1d342f47f65d318.php:24
39	__TwigTemplate_af994d4cb9a8bd0ac174a249e40117dfb234563930566be99b75505a097d4391->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/g5_helium/twig/18/1895c12562b1f4d015443856ff688221906dc05699099d76223efd1f3f5c5a80.php:42
36	__TwigTemplate_1e279137107d58263f15586f9fb5294ec164531e0f9449c5a2c8b8520e988e4f->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:363
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:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/ca/caf9a82b9e1fc3411cd403b106e051eca8d187d5e0f5db7b2851b6fa7ebdd401.php:36
19	__TwigTemplate_e7b8022874c89800a7dfe881717b4d10d320caae5822e64e580c362aa35ee6b1->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/g5_helium/twig/3e/3e69af3a69e044fb09e268fb98a757b375eba0b21d9160a9d89a4b26ef1d21bc.php:24
16	__TwigTemplate_a946746b220038452718e74d23a946b950368f0f99038d8a505517cf2103c56a->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/g5_helium/twig/45/459d4ac807fb1688b522757aad84cf841b83b8a292295dbcb444331bb032f64e.php:24
13	__TwigTemplate_c2237b0b6e4b85fd146be088807d0a64056f55aac5abf8977495dfa4f7b22b78->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:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_helium/index.php:23
7	require JROOT/templates/g5_helium/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 9.56 ms Nach letzter Abfrage: 0.53 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 27.237 MB Zeilen zurückgegeben: 0

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias, c.rgt as cat_order,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published

  FROM jos_content AS a

  LEFT JOIN jos_categories AS c 
  ON c.id = a.catid

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

  LEFT JOIN jos_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN jos_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER 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

  INNER JOIN jos_contentitem_tag_map AS m 
  ON m.content_item_id = a.id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
  AND a.featured = 0 
  AND m.tag_id IN (8) 
  AND a.catid IN (26,38,47,48,49,57,58,59,61,63,64,66,67,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,86,85,87,92,93,94,95,96,97,99,100,101,102,103,105,106,107,108,109,110,111,112,113,114,115,117,118,122,123,124,125,126,127,130,131,132,134,137,138,139,143,144,146,148,149,153,172,174,175,180,183,186,188,190,191,193,194,198,200,201,203,206,208,209,211,214,221,222,225,228,229) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-03-27 00:39:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-03-27 00:39:21')

  GROUP BY a.id

  ORDER BY a.created DESC 
  LIMIT 4

Erklären

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	m	ref	idx_tag_type	idx_tag_type	4	const	983	Using index; Using temporary; filesort wurde genutzt
1	PRIMARY	a	eq_ref	PRIMARY,idx_access,idx_catid,idx_featured_catid,publish_up,publish_down	PRIMARY	4	db00108073.m.content_item_id	1	Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	db00108073.a.created_by	1	Using where
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	db00108073.a.modified_by	1	Using where
1	PRIMARY	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	db00108073.a.catid	1	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	db00108073.c.parent_id	1	Using where
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	db00108073.a.id	1	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	db00108073.c.id	66	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	66	Using index condition; Using temporary; filesort wurde genutzt
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	353	Using where; Using index

Profil (Profile)

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After table lock	0.01 ms
init	0.09 ms
optimizing	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.07 ms
statistics	0.79 ms
preparing	0.04 ms
executing	0.01 ms
Creating tmp table	0.40 ms
Copying to tmp table	0.05 ms
executing	0.00 ms
Creating tmp table	0.01 ms
Copying to tmp table	2.67 ms
Sorting result	0.02 ms
Sending data	0.02 ms
removing tmp table	0.00 ms
Sending data	4.80 ms
Sorting result	0.02 ms
Sending data	0.04 ms
end	0.00 ms
removing tmp table	0.07 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
removing tmp table	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
53	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
52	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_responsive_grid_for_articles/helper.php:638
51	ResponsiveGridForArticlesHelper::getList()	JROOT/modules/mod_responsive_grid_for_articles/mod_responsive_grid_for_articles.php:622
50	include JROOT/modules/mod_responsive_grid_for_articles/mod_responsive_grid_for_articles.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
49	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
48	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:195
47	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:234
46	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
45	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/51/517452f0d13f04f60e06b9e7513b2f8d08fa6686491d0885e1d342f47f65d318.php:32
44	__TwigTemplate_af994d4cb9a8bd0ac174a249e40117dfb234563930566be99b75505a097d4391->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
43	Twig_Template->displayBlock()	JROOT/cache/gantry5/g5_helium/twig/36/36a5294bfc511419f53948555673795b5ca78e7b0b00a7b98a907a63a2955993.php:62
42	__TwigTemplate_7a0f7bee8cdcb9025ee274ee34b0b07fa6f7447791c5db4bb6a32e2cf5507ca9->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/g5_helium/twig/51/517452f0d13f04f60e06b9e7513b2f8d08fa6686491d0885e1d342f47f65d318.php:24
39	__TwigTemplate_af994d4cb9a8bd0ac174a249e40117dfb234563930566be99b75505a097d4391->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/g5_helium/twig/18/1895c12562b1f4d015443856ff688221906dc05699099d76223efd1f3f5c5a80.php:42
36	__TwigTemplate_1e279137107d58263f15586f9fb5294ec164531e0f9449c5a2c8b8520e988e4f->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:363
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:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_helium/twig/ca/caf9a82b9e1fc3411cd403b106e051eca8d187d5e0f5db7b2851b6fa7ebdd401.php:36
19	__TwigTemplate_e7b8022874c89800a7dfe881717b4d10d320caae5822e64e580c362aa35ee6b1->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/g5_helium/twig/3e/3e69af3a69e044fb09e268fb98a757b375eba0b21d9160a9d89a4b26ef1d21bc.php:24
16	__TwigTemplate_a946746b220038452718e74d23a946b950368f0f99038d8a505517cf2103c56a->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/g5_helium/twig/45/459d4ac807fb1688b522757aad84cf841b83b8a292295dbcb444331bb032f64e.php:24
13	__TwigTemplate_c2237b0b6e4b85fd146be088807d0a64056f55aac5abf8977495dfa4f7b22b78->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:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_helium/index.php:23
7	require JROOT/templates/g5_helium/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1076
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

Abfragezeit: 0.30 ms Nach letzter Abfrage: 44.13 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 30.665 MB Zeilen zurückgegeben: 132

SELECT * 
  FROM jos_acymailing_config

Erklären

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

Profil (Profile)

Status	Duration
starting	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.00 ms
After table lock	0.00 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.10 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.00 ms
updating status	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:481
13	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:438
11	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:822
10	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:22
9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:22
8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:146
7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1096
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:57

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

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

SELECT-Tabellen:

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `jos_assets`

```
2 × SELECT * 
  FROM jos_extensions
```

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

2 × SELECT template 
  FROM jos_template_styles as s

2 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM jos_content AS a 
  INNER JOIN jos_categories AS c 
  on c.id = a.catid 
  LEFT JOIN jos_users AS u 
  on u.id = a.created_by 
  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN jos_content_rating AS v 
  ON a.id = v.content_id

2 × SELECT `extension_id` 
  FROM `jos_extensions`

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 `s` 
  INNER JOIN `jos_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `jos_contentitem_tag_map` AS m  
  INNER JOIN `jos_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM jos_fields AS a 
  LEFT JOIN `jos_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN jos_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN jos_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN jos_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `jos_fields_categories` AS fc 
  ON fc.field_id = a.id

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

1 × SELECT `name`,`element` 
  FROM `jos_extensions`

1 × SELECT `data` 
  FROM `jos_session`

1 × SELECT f.data, f.params 
  FROM `jos_finder_filters` AS f

1 × SELECT `title` 
  FROM `jos_finder_taxonomy`

1 × SELECT a.menutype 
  FROM jos_menu_types 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,( SELECT COUNT(i.`id`) 
  FROM `jos_content` AS `i`

1 × SELECT id, parent_id, level, lft, rgt 
  FROM jos_tags

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias, c.rgt as cat_order,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM jos_content AS a 
  LEFT JOIN jos_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN jos_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN jos_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN jos_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN jos_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER 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 t1.id, t1.title, t2.title AS branch 
  FROM `jos_finder_taxonomy` AS t1 
  INNER JOIN `jos_finder_taxonomy` AS t2 
  ON t2.id = t1.parent_id

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

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

1 × SELECT `session_id` 
  FROM `jos_session`

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 params 
  FROM `jos_extensions`

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 count(1) 
  FROM `jos_session`

1 × SELECT extension, file, type 
  FROM jos_rokcommon_configs

1 × SELECT * 
  FROM `jos_admintools_wafexceptions`

1 × SELECT `value` 
  FROM `jos_admintools_storage`

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

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 id, rules 
  FROM `jos_viewlevels

1 × SELECT * 
  FROM jos_acymailing_confi

Andere Tabellen:

1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3537346333313436313837333936613530663565336234623832663937643738', 1, 1679877560, 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `jos_extensions

1 × UPDATE `jos_extensions` 
  SET `params` = '{\"mediaversion\":\"98f5c4d497e2fa73009900d09b2c852f\"}'

1 × SHOW FULL COLUMNS 
  FROM `jos_content

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

1 × SHOW FULL COLUMNS 
  FROM `jos_tags