Internet-Einrichtung

Nachricht

EU e-Privacy Directive

This website uses cookies to manage authentication, navigation, and other functions. By using our website, you agree that we can place these types of cookies on your device.

View e-Privacy Directive Documents

View GDPR Documents

You have declined cookies. This decision can be reversed.

Unser Angebot zum Start in die digitale Welt des Internets.

Internet Erst oder Neu-Einrichtung für 35,00€ + *Anfahrt

Enthalten sind folgende Leistungen:

Verkabelung von Router zu Telefondose (TAE), zu einem Computer oder Notebook (LAN) und einem Telefon.

Alternativ wird der Computer, Notebook oder Tablet via WLAN und das Telefon per DECT (Funkverbindung) eingerichtet.

Einrichten der Internetverbindung im Router mit ihren Zugangsdaten.
Einrichtung einer Telefonnummer und Zuweisung eines Telefons (Analog/ISDN/DECT) im Router.
Einrichtung der LAN oder WLAN-Verbindung auf einem Computer, Notebook oder Tablet.

Vorraussetzungen:

Bitte stellen sie vor Buchung des Angebotes sicher das:

sie die Zugangsdaten erhalten haben.
ihnen der Schaltungstermin bekannt ist.
die Leitung entstört ist.
sie die nötige bzw. gewünschte Hardware (Geräte) vor Ort haben!

Alternativ können sie die Hardware über uns erwerben.

Sollten beim Termin die Vorraussetzungen nicht erfüllt sein, wird die Anfahrtspauschale auch ohne das verrichten des Auftrages fällig!

*Anfahrt: Bis 5km (Stadtgebiet Aachen) 15,00€ Anfahrtspauschale. Ab 5km + (Kreis Aachen) auf Anfrage.

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713557839,
                "last": 1713557839,
                "now": 1713557839
            },
            "token": "r0vQTjEqsRVtskrMn6Zs9z6Q9P7VTrxz"
        },
        "registry": {
            "plg_system_eprivacygeoip_cache": {
                "cc": "US",
                "abbr": "USA",
                "name": "United States"
            },
            "plg_system_eprivacy_non_eu": false
        },
        "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
        },
        "com_mailto": {
            "links": {
                "531e171113297e0e9e4737532668cc9b723e4f37": {
                    "link": "https://bitec-media.de/index.php/dienstleistungen/6-internet-einrichtung",
                    "expiry": 1713557839
                }
            }
        }
    }
}

Profil zum Laufzeitverhalten

Zeit

Speicher

Zeit: 22.99 ms / 22.99 ms Speicher: 0.517 MB / 0.90 MB Application: afterLoad

Zeit: 53.75 ms / 76.74 ms Speicher: 0.977 MB / 1.88 MB Application: afterInitialise

Zeit: 22.98 ms / 99.73 ms Speicher: 0.346 MB / 2.22 MB Application: afterRoute

Zeit: 3.13 ms / 102.86 ms Speicher: 0.042 MB / 2.27 MB Application: beforeRenderComponent com_content

Zeit: 6.69 ms / 109.55 ms Speicher: 0.055 MB / 2.32 MB Application: Before Access::preloadComponents (all components)

Zeit: 1.20 ms / 110.76 ms Speicher: 0.050 MB / 2.37 MB Application: After Access::preloadComponents (all components)

Zeit: 0.04 ms / 110.79 ms Speicher: -0.003 MB / 2.37 MB Application: Before Access::preloadPermissions (com_content)

Zeit: 0.68 ms / 111.47 ms Speicher: 0.025 MB / 2.39 MB Application: After Access::preloadPermissions (com_content)

Zeit: 0.03 ms / 111.50 ms Speicher: -0.000 MB / 2.39 MB Application: Before Access::getAssetRules (id:89 name:com_content.article.6)

Zeit: 0.91 ms / 112.41 ms Speicher: 0.010 MB / 2.40 MB Application: After Access::getAssetRules (id:89 name:com_content.article.6)

Zeit: 51.48 ms / 163.89 ms Speicher: 0.452 MB / 2.85 MB Application: afterRenderComponent com_content

Zeit: 2.57 ms / 166.46 ms Speicher: 0.005 MB / 2.86 MB Application: afterDispatch

Zeit: 17.03 ms / 183.49 ms Speicher: 0.081 MB / 2.94 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Zeit: 0.07 ms / 183.55 ms Speicher: 0.007 MB / 2.95 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Zeit: 0.11 ms / 183.66 ms Speicher: 0.004 MB / 2.95 MB Application: beforeRenderModule mod_tags_popular (Popular Tags)

Zeit: 3.43 ms / 187.09 ms Speicher: 0.021 MB / 2.97 MB Application: afterRenderModule mod_tags_popular (Popular Tags)

Zeit: 0.16 ms / 187.25 ms Speicher: 0.019 MB / 2.99 MB Application: beforeRenderModule mod_menu (Dienstleistungen)

Zeit: 3.57 ms / 190.82 ms Speicher: 0.020 MB / 3.01 MB Application: afterRenderModule mod_menu (Dienstleistungen)

Zeit: 0.23 ms / 191.05 ms Speicher: -0.017 MB / 2.99 MB Application: beforeRenderModule mod_articles_category (Seitenmenü)

Zeit: 2.28 ms / 193.32 ms Speicher: 0.074 MB / 3.07 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Zeit: 0.03 ms / 193.35 ms Speicher: 0.002 MB / 3.07 MB Application: After Access::getAssetRules (id:8 name:com_content)

Zeit: 1.48 ms / 194.83 ms Speicher: -0.031 MB / 3.04 MB Application: afterRenderModule mod_articles_category (Seitenmenü)

Zeit: 0.12 ms / 194.95 ms Speicher: 0.007 MB / 3.05 MB Application: beforeRenderModule mod_menu (Benutzer Menü)

Zeit: 0.62 ms / 195.57 ms Speicher: 0.004 MB / 3.05 MB Application: afterRenderModule mod_menu (Benutzer Menü)

Zeit: 0.16 ms / 195.73 ms Speicher: -0.021 MB / 3.03 MB Application: beforeRenderModule mod_breadcrumbs (Navigation)

Zeit: 2.05 ms / 197.78 ms Speicher: 0.010 MB / 3.04 MB Application: afterRenderModule mod_breadcrumbs (Navigation)

Zeit: 0.23 ms / 198.01 ms Speicher: 0.017 MB / 3.06 MB Application: beforeRenderModule mod_menu (Hauptmenü)

Zeit: 4.88 ms / 202.89 ms Speicher: 0.047 MB / 3.10 MB Application: afterRenderModule mod_menu (Hauptmenü)

Zeit: 0.26 ms / 203.15 ms Speicher: -0.000 MB / 3.10 MB Application: beforeRenderModule mod_search (Suche...)

Zeit: 3.75 ms / 206.90 ms Speicher: 0.018 MB / 3.12 MB Application: afterRenderModule mod_search (Suche...)

Zeit: 2.75 ms / 209.65 ms Speicher: 0.001 MB / 3.12 MB Application: afterRender

Datenbankabfragen gesamt: 23.06 ms

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

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

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

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

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

Profil (Profile)

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.02 ms
update	0.20 ms
Waiting for query cache lock	0.01 ms
update	0.01 ms
end	0.01 ms
query end	0.91 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

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

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

Abfragezeit: 0.94 ms Nach letzter Abfrage: 3.61 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 1.384 MB Zeilen zurückgegeben: 34

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

  FROM `jos_extensions`

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

Explain

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

Profil (Profile)

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

Call Stack

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

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

Abfragezeit: 0.35 ms Nach letzter Abfrage: 2.96 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.413 MB Zeilen zurückgegeben: 5

SELECT id, rules

  FROM `jos_viewlevels`

Explain

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.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 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.03 ms
cleaning up	0.01 ms

Call Stack

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

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

Abfragezeit: 0.50 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.425 MB Zeilen zurückgegeben: 2

SELECT b.id

  FROM jos_usergroups AS a

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

  WHERE a.id = 9

Explain

id	select_type	table	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.04 ms
checking permissions	0.01 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 opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.03 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.03 ms
cleaning up	0.01 ms

Call Stack

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

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

Abfragezeit: 1.22 ms Nach letzter Abfrage: 0.55 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 1.449 MB Zeilen zurückgegeben: 85

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

  FROM jos_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos_extensions	ref	extension	extension	82	const	100	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 opening tables	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.60 ms
Sending data	0.21 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

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

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

Abfragezeit: 1.22 ms Nach letzter Abfrage: 23.67 ms Abfragespeichernutzung: 0.048 MB Speichernutzung vor Abfrage: 1.908 MB Zeilen zurückgegeben: 16

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM jos_menu AS m

  LEFT JOIN jos_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	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	18	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	mkrings_db1.m.component_id	1	Using where

Profil (Profile)

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.06 ms
executing	0.01 ms
Sorting result	0.22 ms
Sending data	0.18 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Derselbe Aufruf in der Zeile darunter.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
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:533
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:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.74 ms Nach letzter Abfrage: 13.50 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 2.117 MB Zeilen zurückgegeben: 0

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

  ORDER BY c.lft

Explain

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.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.06 ms
optimizing	0.05 ms
statistics	0.09 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
12	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
11	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:350
10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.34 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.122 MB Zeilen zurückgegeben: 1

SELECT `alias`,`catid`

  FROM `jos_content`

  WHERE `id` = 6

Explain

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

Profil (Profile)

Status	Duration
starting	0.03 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 opening tables	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/components/com_content/helpers/legacyrouter.php:366
10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.44 ms Nach letzter Abfrage: 0.70 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 2.146 MB Zeilen zurückgegeben: 1

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

  FROM `jos_extensions`

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

Explain

id	select_type	table	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.03 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 opening tables	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 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.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
19	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
18	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Derselbe Aufruf in der Zeile darunter.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
15	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
14	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
13	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/eprivacy/eprivacy.php:391
9	plgSystemePrivacy->_exitEarly()	JROOT/plugins/system/eprivacy/eprivacy.php:64
8	plgSystemePrivacy->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:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.29 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 2.139 MB

UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"19ccaebcb39ee8f70a20f85e09cf76c0\"}'

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

Explain

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

Profil (Profile)

Status	Duration
starting	0.03 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 opening tables	0.01 ms
init	0.07 ms
updating	0.08 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.02 ms
query end	0.89 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/eprivacy/eprivacy.php:391
9	plgSystemePrivacy->_exitEarly()	JROOT/plugins/system/eprivacy/eprivacy.php:64
8	plgSystemePrivacy->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:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.50 ms Nach letzter Abfrage: 2.20 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 2.239 MB Zeilen zurückgegeben: 1

SELECT *

  FROM jos_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Call Stack

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

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

Abfragezeit: 0.52 ms Nach letzter Abfrage: 0.46 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 2.257 MB Zeilen zurückgegeben: 2

SELECT id, home, template, s.params

  FROM jos_template_styles as s

  LEFT JOIN jos_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	2
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	mkrings_db1.s.template,const	1	Using index condition; Using where

Profil (Profile)

Status	Duration
starting	0.05 ms
checking permissions	0.01 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 opening tables	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

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

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

Abfragezeit: 0.94 ms Nach letzter Abfrage: 7.86 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 2.324 MB Zeilen zurückgegeben: 34

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

  FROM `jos_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

Explain

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

Profil (Profile)

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

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:457
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:702
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.53 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 2.368 MB Zeilen zurückgegeben: 21

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

  FROM `jos_assets`

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

Explain

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	98	Using where

Profil (Profile)

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

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:457
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:702
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.51 ms Nach letzter Abfrage: 1.68 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 2.407 MB Zeilen zurückgegeben: 31

SHOW FULL COLUMNS 
  FROM `jos_content`

Explain

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

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:261
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
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:328
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:702
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.37 ms Nach letzter Abfrage: 4.70 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 2.521 MB

UPDATE jos_content

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

  WHERE `id` = '6'

Explain

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

Profil (Profile)

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.06 ms
updating	0.12 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.01 ms
query end	0.94 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
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:702
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.97 ms Nach letzter Abfrage: 2.32 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 2.567 MB Zeilen zurückgegeben: 1

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 = 6 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 20:17:19') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 20:17:19') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
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.14 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
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.07 ms
optimizing	0.05 ms
statistics	0.21 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
13	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.83 ms Nach letzter Abfrage: 2.79 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 2.602 MB Zeilen zurückgegeben: 2

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

  FROM `jos_categories` AS `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 = 10

  ORDER BY c.lft

Explain

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	filesort wurde genutzt
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	13	Using where

Profil (Profile)

Status	Duration
starting	0.10 ms
checking permissions	0.01 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 opening tables	0.01 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.04 ms
executing	0.01 ms
Sorting result	0.12 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
21	ContentRouter->getCategorySegment()	Derselbe Aufruf in der Zeile darunter.
20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.56 ms Nach letzter Abfrage: 1.07 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 2.629 MB Zeilen zurückgegeben: 0

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` = 6 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	mkrings_db1.m.tag_id	1	Using where

Profil (Profile)

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.03 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.05 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.60 ms Nach letzter Abfrage: 4.76 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 2.735 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 (10,0)) 
  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

Explain

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

Profil (Profile)

Status	Duration
starting	0.12 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
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.07 ms
optimizing	0.05 ms
statistics	0.16 ms
preparing	0.09 ms
executing	0.01 ms
Copying to tmp table	0.48 ms
Copying to tmp table	0.08 ms
Sorting result	0.03 ms
Sending data	0.05 ms
end	0.01 ms
removing tmp table	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.75 ms Nach letzter Abfrage: 2.24 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 2.777 MB Zeilen zurückgegeben: 2

SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug

  FROM jos_content AS a

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

  WHERE a.catid = 10 
  AND a.state = 1 
  AND a.access IN (1,1,5)  
  AND (a.state = 1 OR a.state = -1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-04-19 20:17:19') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-04-19 20:17:19')

  ORDER BY  
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END DESC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	3	Using where; filesort wurde genutzt
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1

Profil (Profile)

Status	Duration
starting	0.13 ms
checking permissions	0.01 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 opening tables	0.01 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.08 ms
preparing	0.05 ms
executing	0.01 ms
Sorting result	0.08 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/pagenavigation/pagenavigation.php:161
14	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.25 ms Nach letzter Abfrage: 35.90 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 2.905 MB Zeilen zurückgegeben: 7

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

  FROM jos_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-19 20:17:19') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-19 20:17:19') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 110 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

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

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Derselbe Aufruf in der Zeile darunter.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/protostar/index.php:91
7	require JROOT/templates/protostar/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.35 ms Nach letzter Abfrage: 9.52 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.002 MB Zeilen zurückgegeben: 0

SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params

  FROM `jos_contentitem_tag_map` AS `m`

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

  INNER JOIN `jos_ucm_content` AS `c` 
  ON `m`.`core_content_id` = `c`.`core_content_id`

  WHERE `t`.`access` IN (1,1,5) 
  AND `t`.`published` = 1  
  AND `m`.`type_alias` = `c`.`core_type_alias` 
  AND `c`.`core_state` = 1 
  AND (`c`.`core_access` IN (1,1,5) OR `c`.`core_access` = 0) 
  AND (`c`.`core_publish_up` = '0000-00-00 00:00:00' OR `c`.`core_publish_up` <= '2024-04-19 20:17:19') 
  AND (`c`.`core_publish_down` = '0000-00-00 00:00:00' OR  `c`.`core_publish_down` >= '2024-04-19 20:17:19')

  GROUP BY `tag_id`,`title`,`access`,`alias`

  ORDER BY `count` DESC 
  LIMIT 10

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type,idx_core_content_id	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	Using temporary; filesort wurde genutzt
1	SIMPLE	c	eq_ref	PRIMARY,tag_idx,idx_access,idx_content_type	PRIMARY	4	mkrings_db1.m.core_content_id	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	mkrings_db1.m.tag_id	1	Using where

Profil (Profile)

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

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_tags_popular/helper.php:134
14	ModTagsPopularHelper::getList()	Derselbe Aufruf in der Zeile darunter.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:596
11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_tags_popular/mod_tags_popular.php:22
10	include JROOT/modules/mod_tags_popular/mod_tags_popular.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.12 ms Nach letzter Abfrage: 6.87 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 3.067 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 c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  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, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  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

  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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid IN (0,12) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 20:17:19') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 20:17:19')

  ORDER BY a.title ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_state	1	const	7	Using where; filesort wurde genutzt
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	mkrings_db1.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	mkrings_db1.a.modified_by	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	mkrings_db1.a.catid	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	mkrings_db1.c.parent_id	1	Using where

Profil (Profile)

Status	Duration
starting	0.18 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
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.09 ms
optimizing	0.07 ms
statistics	0.15 ms
preparing	0.07 ms
executing	0.01 ms
Sorting result	0.15 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
15	ContentModelArticles->getItems()	JROOT/modules/mod_articles_category/helper.php:224
14	ModArticlesCategoryHelper::getList()	Derselbe Aufruf in der Zeile darunter.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:566
11	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_articles_category/mod_articles_category.php:61
10	include JROOT/modules/mod_articles_category/mod_articles_category.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT-Tabellen:

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

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

2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `jos_categories` AS `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 `data` 
  FROM `jos_session`

1 × SELECT MAX(`tag_id`) AS tag_id, COUNT(*) AS count,MAX(t.title) AS title,MAX(`t`.`access`) AS access,MAX(`t`.`alias`) AS alias,MAX(`t`.`params`) AS params 
  FROM `jos_contentitem_tag_map` AS `m` 
  INNER JOIN `jos_tags` AS `t` 
  ON `tag_id` = t.id 
  INNER JOIN `jos_ucm_content` AS `c` 
  ON `m`.`core_content_id` = `c`.`core_content_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 a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM jos_content AS a 
  LEFT JOIN jos_categories AS cc 
  ON cc.id = a.catid

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`.`tag_id`,`t`.* 
  FROM `jos_contentitem_tag_map` AS m  
  INNER JOIN `jos_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

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

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

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 `session_id` 
  FROM `jos_session`

1 × SELECT `alias`,`catid` 
  FROM `jos_content`

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 `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 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 c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  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, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  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 
  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

Andere Tabellen:

1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'30737362346f7137756d73656a76686563697161347575367572', 1, 1713557839, 0, '', 0

1 × UPDATE `jos_extensions` 
  SET `params` = '{\"mediaversion\":\"19ccaebcb39ee8f70a20f85e09cf76c0\"}'

1 × SHOW FULL COLUMNS 
  FROM `jos_content

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

Nachricht

EU e-Privacy Directive