** Klärschlamm Trocknung Systembeschreibung

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1611410211,
                "last": 1611410211,
                "now": 1611410211
            },
            "token": "GKBZUrYsRl8hxTVFjVaMHpcVGUncyRT6"
        },
        "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
        },
        "jsn_mobilize_profile": {
            "profile_id": "1",
            "profile_title": "Demo profile",
            "profile_description": "This is demo profile of JSN Mobilize",
            "profile_state": "1",
            "profile_minify": "",
            "profile_optimize_images": "0",
            "ordering": "0",
            "support_id": "26",
            "os_id": "11"
        },
        "com_mailto": {
            "links": {
                "9c7d152b00635568ab7d9713297913abe1487609": {
                    "link": "http:\/\/absolutfeuchteregler.de\/solare-klaerschlamm-trocknung\/klaerschlammentwaesserung-unser-ganzheitlicher-ansatz",
                    "expiry": 1611410212
                },
                "aeae79e97a05c5416e4cec7e681b79cbf14ad912": {
                    "link": "http:\/\/absolutfeuchteregler.de\/home\/die-richtige-loesung-fuer-sie",
                    "expiry": 1611410212
                }
            }
        }
    }
}

Profil zum Laufzeitverhalten

Zeit

Speicher

**Zeit**: 95.18 ms / 95.18 ms **Speicher**: 1.638 MB / 2.00 MB Application: afterLoad

**Zeit**: 438.68 ms / 533.87 ms **Speicher**: 6.890 MB / 8.89 MB Application: afterInitialise

**Zeit**: 133.61 ms / 667.47 ms **Speicher**: 1.404 MB / 10.30 MB Application: afterRoute

**Zeit**: 3.76 ms / 671.24 ms **Speicher**: 0.014 MB / 10.31 MB Application: beforeRenderComponent com_content

**Zeit**: 28.65 ms / 699.88 ms **Speicher**: 0.556 MB / 10.87 MB Application: Before Access::preloadComponents (all components)

**Zeit**: 3.27 ms / 703.16 ms **Speicher**: 0.068 MB / 10.94 MB Application: After Access::preloadComponents (all components)

**Zeit**: 0.05 ms / 703.20 ms **Speicher**: 0.000 MB / 10.93 MB Application: Before Access::getAssetRules (id:8 name:com_content)

**Zeit**: 3.35 ms / 706.55 ms **Speicher**: 0.026 MB / 10.96 MB Application: After Access::getAssetRules (id:8 name:com_content)

**Zeit**: 181.02 ms / 887.57 ms **Speicher**: 3.505 MB / 14.46 MB Application: afterRenderComponent com_content

**Zeit**: 6.65 ms / 894.22 ms **Speicher**: 0.007 MB / 14.47 MB Application: afterDispatch

**Zeit**: 104.74 ms / 998.96 ms **Speicher**: 0.628 MB / 15.10 MB Application: beforeRenderModule mod_login (Anmeldung)

**Zeit**: 27.52 ms / 1026.48 ms **Speicher**: 0.149 MB / 15.25 MB Application: afterRenderModule mod_login (Anmeldung)

**Zeit**: 12.44 ms / 1038.92 ms **Speicher**: 0.018 MB / 15.27 MB Application: beforeRenderModule mod_imageshow (Tageszeitliche Klimaveränderungen mit Drytec-Technologie zur Trocknung nutzen)

**Zeit**: 76.51 ms / 1115.43 ms **Speicher**: 0.793 MB / 16.06 MB Application: afterRenderModule mod_imageshow (Tageszeitliche Klimaveränderungen mit Drytec-Technologie zur Trocknung nutzen)

**Zeit**: 5.14 ms / 1120.57 ms **Speicher**: 0.031 MB / 16.09 MB Application: beforeRenderModule mod_search (Suchen)

**Zeit**: 11.75 ms / 1132.32 ms **Speicher**: 0.027 MB / 16.12 MB Application: afterRenderModule mod_search (Suchen)

**Zeit**: 6.34 ms / 1138.65 ms **Speicher**: 0.001 MB / 16.12 MB Application: beforeRenderModule mod_menu (Main Menu (Icons / Rich Text))

**Zeit**: 71.20 ms / 1209.86 ms **Speicher**: 0.542 MB / 16.66 MB Application: afterRenderModule mod_menu (Main Menu (Icons / Rich Text))

**Zeit**: 66.29 ms / 1276.14 ms **Speicher**: 0.000 MB / 16.50 MB Application: afterRender

**Datenbankabfragen gesamt: 60.86 ms**

Speichernutzung

Datenbankabfragen

78 ausgeführte Abfragen 60.86 ms

21 Duplikate gefunden!

**3 Duplikate**: #6 #10 #59

**2 Duplikate**: #12 #16

**2 Duplikate**: #13 #17

**2 Duplikate**: #14 #18

**3 Duplikate**: #32 #35 #41

**3 Duplikate**: #43 #50 #58

**2 Duplikate**: #46 #57

**2 Duplikate**: #52 #53

**2 Duplikate**: #75 #76

**Abfragezeit: 0.55 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 3.667 MB** **Zeilen zurückgegeben: 0**

SELECT `data`

  FROM `ry2xb_session`

  WHERE `session_id` = 'hijhhohb8el1mqdljt0da9k6p3'

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ry2xb_session	const	PRIMARY	PRIMARY	766	const	1	100.00	NULL

**Profil (Profile)**

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
logging slow query	0.07 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
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:755
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
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.86 ms** **Nach letzter Abfrage: 7.94 ms** **Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 3.769 MB** **Zeilen zurückgegeben: 0**

SELECT `session_id`

  FROM `ry2xb_session`

  WHERE `session_id` = 'hijhhohb8el1mqdljt0da9k6p3' 
  LIMIT 1

**Erklären**

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

**Profil (Profile)**

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.05 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
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.93 ms** **Nach letzter Abfrage: 0.27 ms** **Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 3.774 MB**

INSERT INTO `ry2xb_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('hijhhohb8el1mqdljt0da9k6p3', 1, '1611410211', 0, '', 0)

**Erklären**

**„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `ry2xb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('hijhhohb8el1mqdljt0da9k6p3', 1, '1611410211', 0, '', 0)**

**Profil (Profile)**

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
update	0.10 ms
end	0.01 ms
query end	0.60 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	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:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:343
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.42 ms** **Nach letzter Abfrage: 41.78 ms** **Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 4.382 MB** **Zeilen zurückgegeben: 3**

SELECT id, rules

  FROM `ry2xb_viewlevels`

**Erklären**

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

**Profil (Profile)**

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	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.02 ms
logging slow query	0.07 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
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:606
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Abfragezeit: 0.41 ms** **Nach letzter Abfrage: 0.25 ms** **Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 4.394 MB** **Zeilen zurückgegeben: 1**

SELECT b.id

  FROM ry2xb_usergroups AS a

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

  WHERE a.id = 1

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	8	25.00	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.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 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.02 ms
logging slow query	0.05 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
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:606
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Abfragezeit: 2.43 ms** **Nach letzter Abfrage: 66.05 ms** **Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 5.820 MB** **Zeilen zurückgegeben: 165**

**Doppelte Abfragen**: #10 #59

SHOW TABLES

**Erklären**

**„EXPLAIN“ unmöglich für Abfrage: SHOW TABLES**

**Profil (Profile)**

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
checking permissions	1.43 ms
Sending data	0.16 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.03 ms
closing tables	0.01 ms
freeing items	0.05 ms
logging slow query	0.07 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:487
9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:68
8	JSNConfigHelper::get()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:98
7	plgSystemJsnpoweradmin->__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:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
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.30 ms** **Nach letzter Abfrage: 0.20 ms** **Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 5.846 MB** **Zeilen zurückgegeben: 22**

SELECT name,value

  FROM ry2xb_jsn_poweradmin_config

  WHERE 1

**Erklären**

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

**Profil (Profile)**

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.04 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:81
8	JSNConfigHelper::get()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:98
7	plgSystemJsnpoweradmin->__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:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
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.46 ms** **Nach letzter Abfrage: 10.19 ms** **Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 5.945 MB** **Zeilen zurückgegeben: 1**

SELECT COUNT(*)

  FROM ry2xb_extensions

  WHERE element="jsnadminbar"

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ry2xb_extensions	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	100.00	Using where; Using index

**Profil (Profile)**

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.10 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.03 ms
logging slow query	0.06 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:799
8	plgSystemJsnpoweradmin->_removeAdminBarPlugin()	JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:104
7	plgSystemJsnpoweradmin->__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:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
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.37 ms** **Nach letzter Abfrage: 99.02 ms** **Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 7.131 MB** **Zeilen zurückgegeben: 1**

SELECT `enabled`

  FROM `ry2xb_extensions`

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

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ry2xb_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

**Profil (Profile)**

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.02 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:74
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
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:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Abfragezeit: 1.43 ms** **Nach letzter Abfrage: 85.46 ms** **Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 8.089 MB** **Zeilen zurückgegeben: 165**

**Doppelte Abfragen**: #6 #59

SHOW TABLES

**Erklären**

**„EXPLAIN“ unmöglich für Abfrage: SHOW TABLES**

**Profil (Profile)**

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
checking permissions	0.91 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.02 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.08 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:487
10	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:68
9	JSNConfigHelper::get()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:85
8	PlgSystemJSNMobilize->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:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
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: 0.17 ms** **Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 8.116 MB** **Zeilen zurückgegeben: 3**

SELECT name,value

  FROM ry2xb_jsn_mobilize_config

  WHERE 1

**Erklären**

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

**Profil (Profile)**

Status	Duration
starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 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.02 ms
logging slow query	0.04 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:81
9	JSNConfigHelper::get()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:85
8	PlgSystemJSNMobilize->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:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
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.39 ms** **Nach letzter Abfrage: 4.03 ms** **Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 8.275 MB** **Zeilen zurückgegeben: 1**

**Doppelte Abfragen**: #16

SELECT *

  FROM ry2xb_jsn_mobilize_os

  WHERE os_type = 'other'

**Erklären**

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

**Profil (Profile)**

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	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.02 ms
freeing items	0.03 ms
logging slow query	0.06 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:438
10	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:86
9	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:115
8	PlgSystemJSNMobilize->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:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
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.34 ms** **Nach letzter Abfrage: 0.07 ms** **Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 8.283 MB** **Zeilen zurückgegeben: 1**

**Doppelte Abfragen**: #17

SELECT *

  FROM ry2xb_jsn_mobilize_profiles AS p

  INNER JOIN ry2xb_jsn_mobilize_os_support AS s 
  ON s.profile_id = p.profile_id

  WHERE s.os_id = '11' 
  AND p.profile_state = 1

  ORDER BY p.ordering 
  LIMIT 1

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	s	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	8	100.00	Using where; Using join buffer (Block Nested Loop)

**Profil (Profile)**

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.51 ms
Creating sort index	0.06 ms
end	0.01 ms
removing tmp table	0.38 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.05 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
11	JDatabaseDriver->loadObject()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:504
10	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:86
9	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:115
8	PlgSystemJSNMobilize->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:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
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: 0.08 ms** **Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 8.289 MB** **Zeilen zurückgegeben: 22**

**Doppelte Abfragen**: #18

SELECT *

  FROM ry2xb_jsn_mobilize_design

  WHERE profile_id = '1'

**Erklären**

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

**Profil (Profile)**

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.27 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
logging slow query	0.04 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:511
10	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:86
9	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:115
8	PlgSystemJSNMobilize->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:623
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Abfragezeit: 1.31 ms** **Nach letzter Abfrage: 79.07 ms** **Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 9.455 MB**

UPDATE `ry2xb_extensions`

  SET `params` = '{\"mediaversion\":\"66841ba8f29c326f7544d450e59ec5c7\"}'

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

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ry2xb_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

**Profil (Profile)**

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.08 ms
updating	0.07 ms
end	0.01 ms
query end	0.65 ms
closing tables	0.02 ms
freeing items	0.02 ms
logging slow query	0.04 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/jsnpoweradmin/jsnpoweradmin.php:330
8	plgSystemJsnpoweradmin->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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
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.84 ms** **Nach letzter Abfrage: 39.26 ms** **Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 9.917 MB** **Zeilen zurückgegeben: 1**

**Doppelte Abfragen**: #12

SELECT *

  FROM ry2xb_jsn_mobilize_os

  WHERE os_type = 'other'

**Erklären**

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

**Profil (Profile)**

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.36 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.06 ms
cleaning up	0.02 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:438
10	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:86
9	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:209
8	PlgSystemJSNMobilize->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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
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.84 ms** **Nach letzter Abfrage: 0.10 ms** **Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 9.926 MB** **Zeilen zurückgegeben: 1**

**Doppelte Abfragen**: #13

SELECT *

  FROM ry2xb_jsn_mobilize_profiles AS p

  INNER JOIN ry2xb_jsn_mobilize_os_support AS s 
  ON s.profile_id = p.profile_id

  WHERE s.os_id = '11' 
  AND p.profile_state = 1

  ORDER BY p.ordering 
  LIMIT 1

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	p	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	s	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	8	100.00	Using where; Using join buffer (Block Nested Loop)

**Profil (Profile)**

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.36 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.62 ms
Creating sort index	0.07 ms
end	0.01 ms
removing tmp table	0.21 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.05 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
11	JDatabaseDriver->loadObject()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:504
10	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:86
9	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:209
8	PlgSystemJSNMobilize->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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
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.67 ms** **Nach letzter Abfrage: 0.15 ms** **Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 9.933 MB** **Zeilen zurückgegeben: 22**

**Doppelte Abfragen**: #14

SELECT *

  FROM ry2xb_jsn_mobilize_design

  WHERE profile_id = '1'

**Erklären**

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

**Profil (Profile)**

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.24 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.18 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:511
10	JSNMobilizeTemplateHelper::getOSSupport()	JROOT/templates/jsn_mobilize/helpers/mobilize.php:86
9	JSNMobilizeTemplateHelper::getConfig()	JROOT/plugins/system/jsnmobilize/jsnmobilize.php:209
8	PlgSystemJSNMobilize->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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
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.59 ms** **Nach letzter Abfrage: 4.44 ms** **Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 10.008 MB** **Zeilen zurückgegeben: 1**

SELECT element,views,context,types,params

  FROM ry2xb_ark_editor_inline_views

  WHERE element = 'com_content' 
  LIMIT 1

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ry2xb_ark_editor_inline_views	ref	PRIMARY	PRIMARY	152	const	1	100.00	Using where

**Profil (Profile)**

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.13 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.02 ms
freeing items	0.03 ms
logging slow query	0.06 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
9	JDatabaseDriver->loadObject()	JROOT/plugins/system/inlinecontent/inlinecontent.php:102
8	PlgSystemInlineContent->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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
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.46 ms** **Nach letzter Abfrage: 0.12 ms** **Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 10.016 MB** **Zeilen zurückgegeben: 0**

SELECT types

  FROM ry2xb_ark_editor_inline_views

  WHERE `parent` = 'com_content'

**Erklären**

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

**Profil (Profile)**

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.06 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/inlinecontent/inlinecontent.php:120
8	PlgSystemInlineContent->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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
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: 0.43 ms** **Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 10.021 MB** **Zeilen zurückgegeben: 1**

SELECT params

  FROM ry2xb_extensions

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

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ry2xb_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

**Profil (Profile)**

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.17 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.17 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.05 ms
logging slow query	0.07 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/arkbootstrap/arkbootstrap.php:55
8	plgSystemArKBootstrap->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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
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.58 ms** **Nach letzter Abfrage: 2.29 ms** **Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 10.027 MB** **Zeilen zurückgegeben: 1**

SELECT manifest_cache

  FROM ry2xb_extensions

  WHERE element LIKE 'jsn_epic_pro'

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ry2xb_extensions	range	element_clientid,element_folder_clientid	element_clientid	402	NULL	6	100.00	Using index condition

**Profil (Profile)**

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.06 ms
cleaning up	0.02 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
13	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:122
12	JSNTplHelper::getManifestCache()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:217
11	JSNTplHelper::getTemplateVersion()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:35
10	jsn_template_framework_class_loader()	*Der selbe Aufruf in der Zeile darunter.*
9	spl_autoload_call()	JROOT/plugins/system/jsntplframework/jsntplframework.php:187
8	PlgSystemJSNTPLFramework->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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
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: 19.83 ms** **Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 10.294 MB** **Zeilen zurückgegeben: 1**

SELECT COUNT(*)

  FROM ry2xb_extensions

  WHERE type = 'component' 
  AND element = 'com_sh404sef'

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ry2xb_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

**Profil (Profile)**

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 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.03 ms
logging slow query	0.07 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
11	JDatabaseDriver->loadResult()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:1166
10	JSNTplUtils->checkSH404SEF()	JROOT/plugins/system/jsntplframework/includes/core/jsntplframework.php:36
9	JSNTPLFramework::initial()	JROOT/plugins/system/jsntplframework/jsntplframework.php:191
8	PlgSystemJSNTPLFramework->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:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Abfragezeit: 2.89 ms** **Nach letzter Abfrage: 34.48 ms** **Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 10.873 MB** **Zeilen zurückgegeben: 42**

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

  FROM `ry2xb_assets`

  WHERE `name` IN ('root.1','com_admin','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_fields','com_finder','com_imageshow','com_installer','com_joomlaupdate','com_k2','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mobilize','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_poweradmin','com_redirect','com_search','com_spupgrade','com_tags','com_templates','com_uniform','com_users','com_weblinks','com_wrapper','com_xmap')

**Erklären**

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

**Profil (Profile)**

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.12 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.34 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	1.65 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.06 ms
cleaning up	0.02 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:113
15	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:44
14	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:54
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	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:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Abfragezeit: 3.73 ms** **Nach letzter Abfrage: 9.11 ms** **Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 11.017 MB** **Zeilen zurückgegeben: 2**

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,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM ry2xb_content AS a

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

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

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

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

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

  WHERE a.featured = 1 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-23 13:56:52') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-23 13:56:52')

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

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_catid,idx_featured_catid	idx_featured_catid	1	const	3	100.00	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	DB3079243.a.created_by	1	100.00	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	DB3079243.a.modified_by	1	100.00	Using where
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	DB3079243.a.catid	1	100.00	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	DB3079243.c.parent_id	1	100.00	Using where
1	SIMPLE	v	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)

**Profil (Profile)**

Status	Duration
starting	0.32 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
Opening tables	0.05 ms
init	0.18 ms
System lock	0.02 ms
optimizing	0.05 ms
statistics	0.52 ms
preparing	0.08 ms
Creating tmp table	0.18 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	1.53 ms
Creating sort index	0.15 ms
end	0.01 ms
removing tmp table	0.28 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
logging slow query	0.08 ms
cleaning up	0.02 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:559
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
13	ContentModelFeatured->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:55
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	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:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.32 ms** **Nach letzter Abfrage: 5.25 ms** **Abfragespeichernutzung: 0.008 MB Speichernutzung vor Abfrage: 11.197 MB** **Zeilen zurückgegeben: 9**

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

  FROM `ry2xb_contentitem_tag_map` AS m 

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

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

**Erklären**

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

**Profil (Profile)**

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.10 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.55 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.06 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
13	ContentModelFeatured->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:55
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	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:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.41 ms** **Abfragespeichernutzung: 0.008 MB Speichernutzung vor Abfrage: 11.250 MB** **Zeilen zurückgegeben: 6**

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

  FROM `ry2xb_contentitem_tag_map` AS m 

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

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

**Erklären**

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

**Profil (Profile)**

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.59 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.03 ms
logging slow query	0.07 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:689
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:125
13	ContentModelFeatured->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:55
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	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:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.07 ms** **Nach letzter Abfrage: 3.89 ms** **Abfragespeichernutzung: 0.008 MB Speichernutzung vor Abfrage: 11.344 MB** **Zeilen zurückgegeben: 1**

SELECT COUNT(*)

  FROM ry2xb_content AS a

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

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

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

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

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

  WHERE a.featured = 1 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-23 13:56:52') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-23 13:56:52')

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_catid,idx_featured_catid	idx_featured_catid	1	const	3	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	DB3079243.a.created_by	1	100.00	Using where; Using index
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	DB3079243.a.modified_by	1	100.00	Using where; Using index
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	DB3079243.a.catid	1	100.00	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	DB3079243.c.parent_id	1	100.00	Using where; Using index
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	DB3079243.a.id	1	100.00	Using where; Using index

**Profil (Profile)**

Status	Duration
starting	0.15 ms
checking permissions	0.02 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
Opening tables	0.05 ms
init	0.08 ms
System lock	0.02 ms
optimizing	0.06 ms
statistics	0.18 ms
preparing	0.07 ms
executing	0.02 ms
Sending data	0.16 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.04 ms
logging slow query	0.07 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
16	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
14	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
13	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
12	JViewLegacy->get()	JROOT/components/com_content/views/featured/view.html.php:56
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	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:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.39 ms** **Nach letzter Abfrage: 40.74 ms** **Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 11.858 MB** **Zeilen zurückgegeben: 3**

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

  INNER JOIN `ry2xb_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) 
  AND c.published = 1 
  AND s.id = 51

  ORDER BY c.lft

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	filesort wurde genutzt
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	84	58.33	Using where

**Profil (Profile)**

Status	Duration
starting	0.16 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.11 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.25 ms
preparing	0.05 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.06 ms
Creating sort index	0.43 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
logging slow query	0.43 ms
cleaning up	0.02 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:312
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
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:479
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/featured/view.html.php:98
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	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:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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: 1.92 ms** **Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 11.972 MB** **Zeilen zurückgegeben: 0**

SELECT 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 ry2xb_fields AS a

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

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

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

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

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

  LEFT JOIN `ry2xb_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 (51,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  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	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; filesort wurde genutzt
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	DB3079243.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	DB3079243.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	DB3079243.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	DB3079243.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	DB3079243.a.group_id	1	100.00	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	DB3079243.a.id	1	100.00	Using where; Using index

**Profil (Profile)**

Status	Duration
starting	0.23 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.09 ms
init	0.15 ms
System lock	0.02 ms
optimizing	0.06 ms
statistics	0.20 ms
preparing	0.06 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.05 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.03 ms
logging slow query	0.09 ms
cleaning up	0.02 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
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:479
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/featured/view.html.php:98
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	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:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.45 ms** **Nach letzter Abfrage: 14.48 ms** **Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 12.326 MB** **Zeilen zurückgegeben: 3**

SELECT `name`, `value`

  FROM `ry2xb_jsn_imageshow_config`

  WHERE `name` IN ('show_quick_icons', 'enable_update_checking', 'number_of_images_on_loading')

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ry2xb_jsn_imageshow_config	range	name	name	767	NULL	3	100.00	Using where

**Profil (Profile)**

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.05 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_imageshow/classes/jsn_is_parameter.php:81
17	JSNISParameter->getParameters()	JROOT/administrator/components/com_imageshow/imageshow.defines.php:27
16	require_once JROOT/administrator/components/com_imageshow/imageshow.defines.php	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:16
15	include_once JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php	JROOT/plugins/content/imageshow/imageshow.php:28
14	plgContentImageShow->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/featured/view.html.php:98
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	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:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.99 ms** **Nach letzter Abfrage: 15.94 ms** **Abfragespeichernutzung: 0.008 MB Speichernutzung vor Abfrage: 12.586 MB** **Zeilen zurückgegeben: 1**

**Doppelte Abfragen**: #35 #41

SELECT *

  FROM ry2xb_extensions

  WHERE element='com_imageshow' 
  AND type='component'

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ry2xb_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

**Profil (Profile)**

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.40 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.09 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310
15	JSNISUtils->getComponentInfo()	JROOT/plugins/content/imageshow/imageshow.php:45
14	plgContentImageShow->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/featured/view.html.php:98
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	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:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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: 2.03 ms** **Abfragespeichernutzung: 0.011 MB Speichernutzung vor Abfrage: 12.668 MB** **Zeilen zurückgegeben: 3**

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

  INNER JOIN `ry2xb_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) 
  AND c.published = 1 
  AND s.id = 48

  ORDER BY c.lft

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	filesort wurde genutzt
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	84	58.33	Using where

**Profil (Profile)**

Status	Duration
starting	0.18 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.11 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.18 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.41 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
logging slow query	0.12 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:312
20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
19	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
18	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
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:479
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/featured/view.html.php:98
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	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:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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: 0.26 ms** **Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 12.682 MB** **Zeilen zurückgegeben: 0**

SELECT 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 ry2xb_fields AS a

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

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

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

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

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

  LEFT JOIN `ry2xb_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 (48,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  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	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; filesort wurde genutzt
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	DB3079243.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	DB3079243.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	DB3079243.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	DB3079243.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	DB3079243.a.group_id	1	100.00	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	DB3079243.a.id	1	100.00	Using where; Using index

**Profil (Profile)**

Status	Duration
starting	0.23 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
Opening tables	0.07 ms
init	0.14 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.14 ms
preparing	0.06 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.06 ms
Creating sort index	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.04 ms
logging slow query	0.09 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
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:479
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/featured/view.html.php:98
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	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:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
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.69 ms** **Nach letzter Abfrage: 1.30 ms** **Abfragespeichernutzung: 0.008 MB Speichernutzung vor Abfrage: 12.693 MB** **Zeilen zurückgegeben: 1**

**Doppelte Abfragen**: #32 #41

SELECT *

  FROM ry2xb_extensions

  WHERE element='com_imageshow' 
  AND type='component'

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ry2xb_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

**Profil (Profile)**

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.15 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.10 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.09 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
16	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310
15	JSNISUtils->getComponentInfo()	JROOT/plugins/content/imageshow/imageshow.php:45
14	plgContentImageShow->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/featured/view.html.php:98
11	ContentViewFeatured->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:663
9	Joomla\CMS\MVC\Controller\BaseController->display()	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:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Abfragezeit: 3.95 ms** **Nach letzter Abfrage: 96.92 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 14.879 MB** **Zeilen zurückgegeben: 14**

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

  FROM ry2xb_modules AS m

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

  LEFT JOIN ry2xb_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 <= '2021-01-23 13:56:52') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-23 13:56:52') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 1659 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

**Erklären**

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

**Profil (Profile)**

Status	Duration
starting	0.18 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.09 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.15 ms
preparing	0.09 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	3.01 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
logging slow query	0.09 ms
cleaning up	0.02 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:467
13	JModuleHelper::getModuleList()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:410
12	JModuleHelper::load()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:89
11	JModuleHelper::getModules()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:168
10	JSNTplUtils->countModules()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:498
9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_epic_pro/index.php:18
7	require JROOT/templates/jsn_epic_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.70 ms** **Nach letzter Abfrage: 46.49 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 15.070 MB** **Zeilen zurückgegeben: 0**

SELECT m.id

  FROM ry2xb_modules AS m

  INNER JOIN ry2xb_modules_menu AS mm 
  ON mm.moduleid = m.id

  WHERE m.client_id = 0 
  AND m.published = 1 
  AND m.module LIKE 'mod_k2_%' 
  AND (mm.menuid < 0 
  AND mm.menuid = -1659) 
  AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-
  left", "promo", "promo-right", "content-top", "content-top-below", "
  left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "content-bottom-below", "user5", "user6", "user7", "footer", "bottom", "background", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	88	100.00	Using where
1	SIMPLE	mm	eq_ref	PRIMARY	PRIMARY	8	DB3079243.m.id,const	1	100.00	Using index

**Profil (Profile)**

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.20 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.03 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:720
13	JSNTplUtils->checkExt()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:761
12	JSNTplUtils->checkK2()	JROOT/templates/jsn_epic_pro/template_custom.php:46
11	include_once JROOT/templates/jsn_epic_pro/template_custom.php	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:1003
10	JSNTplTemplateHelper->_prepareHead()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:742
9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_epic_pro/index.php:18
7	require JROOT/templates/jsn_epic_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.65 ms** **Nach letzter Abfrage: 0.18 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 15.079 MB** **Zeilen zurückgegeben: 0**

SELECT m.id

  FROM ry2xb_modules AS m

  INNER JOIN ry2xb_modules_menu AS mm 
  ON mm.moduleid = m.id

  WHERE m.client_id = 0 
  AND m.published = 1 
  AND m.module LIKE 'mod_k2_%' 
  AND (mm.menuid = 1659 OR mm.menuid = 0 OR (mm.menuid < 0 
  AND mm.menuid != -1659)) 
  AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-
  left", "promo", "promo-right", "content-top", "content-top-below", "
  left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "content-bottom-below", "user5", "user6", "user7", "footer", "bottom", "background", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")

  GROUP BY m.id

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	88	100.00	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	DB3079243.m.id	2	100.00	Using where; Using index

**Profil (Profile)**

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.23 ms
Creating sort index	0.02 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.03 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:741
13	JSNTplUtils->checkExt()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:761
12	JSNTplUtils->checkK2()	JROOT/templates/jsn_epic_pro/template_custom.php:46
11	include_once JROOT/templates/jsn_epic_pro/template_custom.php	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:1003
10	JSNTplTemplateHelper->_prepareHead()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:742
9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_epic_pro/index.php:18
7	require JROOT/templates/jsn_epic_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.55 ms** **Nach letzter Abfrage: 0.15 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 15.086 MB** **Zeilen zurückgegeben: 0**

SELECT m.id

  FROM ry2xb_modules AS m

  INNER JOIN ry2xb_modules_menu AS mm 
  ON mm.moduleid = m.id

  WHERE m.client_id = 0 
  AND m.published = 1 
  AND m.module LIKE 'mod_virtuemart_%' 
  AND (mm.menuid < 0 
  AND mm.menuid = -1659) 
  AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-
  left", "promo", "promo-right", "content-top", "content-top-below", "
  left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "content-bottom-below", "user5", "user6", "user7", "footer", "bottom", "background", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	88	100.00	Using where
1	SIMPLE	mm	eq_ref	PRIMARY	PRIMARY	8	DB3079243.m.id,const	1	100.00	Using index

**Profil (Profile)**

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.03 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:720
13	JSNTplUtils->checkExt()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:770
12	JSNTplUtils->checkVM()	JROOT/templates/jsn_epic_pro/template_custom.php:51
11	include_once JROOT/templates/jsn_epic_pro/template_custom.php	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:1003
10	JSNTplTemplateHelper->_prepareHead()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:742
9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_epic_pro/index.php:18
7	require JROOT/templates/jsn_epic_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.99 ms** **Nach letzter Abfrage: 0.08 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 15.094 MB** **Zeilen zurückgegeben: 0**

SELECT m.id

  FROM ry2xb_modules AS m

  INNER JOIN ry2xb_modules_menu AS mm 
  ON mm.moduleid = m.id

  WHERE m.client_id = 0 
  AND m.published = 1 
  AND m.module LIKE 'mod_virtuemart_%' 
  AND (mm.menuid = 1659 OR mm.menuid = 0 OR (mm.menuid < 0 
  AND mm.menuid != -1659)) 
  AND m.position IN ("topbar", "logo", "top", "mainmenu", "toolbar", "promo-
  left", "promo", "promo-right", "content-top", "content-top-below", "
  left", "right", "innerleft", "innerright", "breadcrumbs", "user-top", "user1", "user2", "mainbody-top", "mainbody-bottom", "user3", "user4", "user-bottom", "banner", "content-bottom", "content-bottom-below", "user5", "user6", "user7", "footer", "bottom", "background", "debug", "stick-lefttop", "stick-leftmiddle", "stick-leftbottom", "stick-righttop", "stick-rightmiddle", "stick-rightbottom")

  GROUP BY m.id

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	88	100.00	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	DB3079243.m.id	2	100.00	Using where; Using index

**Profil (Profile)**

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.09 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.11 ms
preparing	0.05 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.26 ms
Creating sort index	0.02 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.06 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:741
13	JSNTplUtils->checkExt()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:770
12	JSNTplUtils->checkVM()	JROOT/templates/jsn_epic_pro/template_custom.php:51
11	include_once JROOT/templates/jsn_epic_pro/template_custom.php	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:1003
10	JSNTplTemplateHelper->_prepareHead()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:742
9	JSNTplTemplateHelper->_prepare()	JROOT/plugins/system/jsntplframework/libraries/joomlashine/template/helper.php:141
8	JSNTplTemplateHelper::prepare()	JROOT/templates/jsn_epic_pro/index.php:18
7	require JROOT/templates/jsn_epic_pro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.62 ms** **Nach letzter Abfrage: 84.09 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 15.309 MB** **Zeilen zurückgegeben: 1**

**Doppelte Abfragen**: #32 #35

SELECT *

  FROM ry2xb_extensions

  WHERE element='com_imageshow' 
  AND type='component'

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ry2xb_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

**Profil (Profile)**

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
logging slow query	0.06 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310
13	JSNISUtils->getComponentInfo()	JROOT/modules/mod_imageshow/helper.php:24
12	modImageShowHelper::render()	JROOT/templates/jsn_epic_pro/html/mod_imageshow/default.php:13
11	require JROOT/templates/jsn_epic_pro/html/mod_imageshow/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

**Abfragezeit: 0.33 ms** **Nach letzter Abfrage: 1.04 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 15.319 MB** **Zeilen zurückgegeben: 0**

SELECT c.introtext, c.fulltext
				   
  FROM ry2xb_imageshow_showlist sl
				   
  INNER JOIN ry2xb_content c 
  ON sl.alter_autid = c.id
				   
  WHERE sl.showlist_id=4

**Erklären**

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

**Profil (Profile)**

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.03 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_imageshow/classes/jsn_is_show.php:85
13	JSNISShow->getArticleAuth()	JROOT/modules/mod_imageshow/helper.php:42
12	modImageShowHelper::render()	JROOT/templates/jsn_epic_pro/html/mod_imageshow/default.php:13
11	require JROOT/templates/jsn_epic_pro/html/mod_imageshow/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.69 ms** **Nach letzter Abfrage: 0.04 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 15.326 MB** **Zeilen zurückgegeben: 1**

**Doppelte Abfragen**: #50 #58

SELECT * 
  FROM ry2xb_imageshow_showlist 
  WHERE  published = 1 
  AND  showlist_id = 4

**Erklären**

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

**Profil (Profile)**

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.05 ms
cleaning up	0.04 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showlist.php:99
13	JSNISShowlist->getShowListByID()	JROOT/modules/mod_imageshow/helper.php:43
12	modImageShowHelper::render()	JROOT/templates/jsn_epic_pro/html/mod_imageshow/default.php:13
11	require JROOT/templates/jsn_epic_pro/html/mod_imageshow/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.37 ms** **Nach letzter Abfrage: 0.07 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 15.337 MB** **Zeilen zurückgegeben: 1**

SELECT * 
  FROM ry2xb_imageshow_showcase 
  WHERE  published = 1 
  AND  showcase_id = 2

**Erklären**

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

**Profil (Profile)**

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.05 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcase.php:155
13	JSNISShowcase->getShowCaseByID()	JROOT/modules/mod_imageshow/helper.php:44
12	modImageShowHelper::render()	JROOT/templates/jsn_epic_pro/html/mod_imageshow/default.php:13
11	require JROOT/templates/jsn_epic_pro/html/mod_imageshow/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.43 ms** **Nach letzter Abfrage: 2.29 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 15.381 MB** **Zeilen zurückgegeben: 1**

SELECT * 
  FROM ry2xb_imageshow_theme_profile 
  WHERE showcase_id =2

**Erklären**

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

**Profil (Profile)**

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 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.03 ms
logging slow query	0.06 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:341
13	JSNISShowcaseTheme->getThemeProfile()	JROOT/modules/mod_imageshow/helper.php:62
12	modImageShowHelper::render()	JROOT/templates/jsn_epic_pro/html/mod_imageshow/default.php:13
11	require JROOT/templates/jsn_epic_pro/html/mod_imageshow/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.61 ms** **Nach letzter Abfrage: 0.08 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 15.390 MB** **Zeilen zurückgegeben: 5**

**Doppelte Abfragen**: #57

SELECT
						image_id, image_title, image_alt_text,
						image_small, image_big, image_medium,
						image_description, image_link,
						image_extid, album_extid, image_size, custom_data, exif_data,
						image_size, sync, ordering				
				   
  FROM ry2xb_imageshow_images
				   
  WHERE showlist_id =4
				   
  ORDER BY ordering ASC

**Erklären**

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

**Profil (Profile)**

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.15 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
logging slow query	0.07 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_imageshow/classes/jsn_is_images.php:47
13	JSNISImages->getImagesByShowlistID()	JROOT/modules/mod_imageshow/helper.php:89
12	modImageShowHelper::render()	JROOT/templates/jsn_epic_pro/html/mod_imageshow/default.php:13
11	require JROOT/templates/jsn_epic_pro/html/mod_imageshow/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.38 ms** **Nach letzter Abfrage: 0.07 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 15.408 MB** **Zeilen zurückgegeben: 1**

SELECT *
			   
  FROM ry2xb_extensions
			   
  WHERE folder = 'jsnimageshow'
			   
  AND element='themeclassic'

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ry2xb_extensions	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	100.00	Using index condition; Using where

**Profil (Profile)**

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 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.02 ms
logging slow query	0.05 ms
cleaning up	0.01 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_showcasetheme.php:293
13	JSNISShowcaseTheme->getThemeInfo()	JROOT/modules/mod_imageshow/helper.php:137
12	modImageShowHelper::render()	JROOT/templates/jsn_epic_pro/html/mod_imageshow/default.php:13
11	require JROOT/templates/jsn_epic_pro/html/mod_imageshow/default.php	JROOT/modules/mod_imageshow/mod_imageshow.php:21
10	include JROOT/modules/mod_imageshow/mod_imageshow.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
9	JModuleHelper::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:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
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.29 ms** **Nach letzter Abfrage: 14.27 ms** **Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 15.657 MB** **Zeilen zurückgegeben: 1**
```
SELECT * 
  FROM ry2xb_ima
```

Keller feucht - richtig lüften = Keller trocknen bzw. Keller trockenlegen

Lüftung und Klima

Anmeldung

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

78 ausgeführte Abfragen 60.86 ms

21 Duplikate gefunden!

Keller feucht - richtig lüften = Keller trocknen bzw. Keller trockenlegen

Lüftung und Klima

Anmeldung

**Joomla!-Debug-Konsole**

**Sitzung**

**Profil zum Laufzeitverhalten**

**Zeit**

**Speicher**

**Speichernutzung**

**Datenbankabfragen**

**78 ausgeführte Abfragen** 60.86 ms

**21 Duplikate gefunden!**

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

78 ausgeführte Abfragen 60.86 ms

21 Duplikate gefunden!