**sensor gesteuerte Zwangslüftung

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1610829473,
                "last": 1610829473,
                "now": 1610829473
            },
            "token": "7uvdrLf0goRfIzuX5fmS9Xnu6glbcHmh"
        },
        "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"
        }
    }
}

Profil zum Laufzeitverhalten

Zeit

Speicher

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

**Zeit**: 359.66 ms / 449.99 ms **Speicher**: 6.889 MB / 8.89 MB Application: afterInitialise

**Zeit**: 112.74 ms / 562.73 ms **Speicher**: 1.394 MB / 10.29 MB Application: afterRoute

**Zeit**: 3.87 ms / 566.59 ms **Speicher**: 0.011 MB / 10.30 MB Application: beforeRenderComponent com_tags

**Zeit**: 197.65 ms / 764.24 ms **Speicher**: 4.085 MB / 14.38 MB Application: Before Access::preloadComponents (all components)

**Zeit**: 1.76 ms / 766.00 ms **Speicher**: 0.068 MB / 14.45 MB Application: After Access::preloadComponents (all components)

**Zeit**: 0.05 ms / 766.04 ms **Speicher**: 0.000 MB / 14.45 MB Application: Before Access::getAssetRules (id:226 name:com_tags)

**Zeit**: 2.54 ms / 768.58 ms **Speicher**: 0.026 MB / 14.47 MB Application: After Access::getAssetRules (id:226 name:com_tags)

**Zeit**: 3.72 ms / 772.31 ms **Speicher**: 0.131 MB / 14.61 MB Application: afterRenderComponent com_tags

**Zeit**: 9.65 ms / 781.95 ms **Speicher**: 0.099 MB / 14.70 MB Application: afterDispatch

**Zeit**: 78.80 ms / 860.75 ms **Speicher**: 0.563 MB / 15.27 MB Application: beforeRenderModule mod_banners (20% BAFA-INVEST Zuschuß)

**Zeit**: 22.13 ms / 882.88 ms **Speicher**: 0.142 MB / 15.41 MB Application: afterRenderModule mod_banners (20% BAFA-INVEST Zuschuß)

**Zeit**: 1.36 ms / 884.24 ms **Speicher**: 0.039 MB / 15.45 MB Application: beforeRenderModule mod_login (Anmeldung)

**Zeit**: 21.35 ms / 905.59 ms **Speicher**: 0.045 MB / 15.49 MB Application: afterRenderModule mod_login (Anmeldung)

**Zeit**: 3.40 ms / 908.99 ms **Speicher**: 0.023 MB / 15.52 MB Application: beforeRenderModule mod_footer (Lüftung und Klima)

**Zeit**: 6.03 ms / 915.03 ms **Speicher**: 0.010 MB / 15.53 MB Application: afterRenderModule mod_footer (Lüftung und Klima)

**Zeit**: 4.71 ms / 919.74 ms **Speicher**: 0.003 MB / 15.53 MB Application: beforeRenderModule mod_custom (Docs)

**Zeit**: 12.34 ms / 932.09 ms **Speicher**: 0.031 MB / 15.56 MB Application: afterRenderModule mod_custom (Docs)

**Zeit**: 4.68 ms / 936.76 ms **Speicher**: 0.006 MB / 15.56 MB Application: beforeRenderModule mod_articles_latest (Neueste Nachrichten)

**Zeit**: 8.80 ms / 945.56 ms **Speicher**: 0.130 MB / 15.69 MB Application: Before Access::getAssetRules (id:8 name:com_content)

**Zeit**: 0.07 ms / 945.64 ms **Speicher**: 0.007 MB / 15.70 MB Application: After Access::getAssetRules (id:8 name:com_content)

**Zeit**: 12.57 ms / 958.21 ms **Speicher**: 0.090 MB / 15.79 MB Application: afterRenderModule mod_articles_latest (Neueste Nachrichten)

**Zeit**: 1.56 ms / 959.76 ms **Speicher**: 0.000 MB / 15.70 MB Application: beforeRenderModule mod_imageshow (Tageszeitliche Klimaveränderungen mit Drytec-Technologie zur Trocknung nutzen)

**Zeit**: 86.51 ms / 1046.27 ms **Speicher**: 0.730 MB / 16.43 MB Application: afterRenderModule mod_imageshow (Tageszeitliche Klimaveränderungen mit Drytec-Technologie zur Trocknung nutzen)

**Zeit**: 4.28 ms / 1050.55 ms **Speicher**: 0.031 MB / 16.46 MB Application: beforeRenderModule mod_search (Suchen)

**Zeit**: 9.23 ms / 1059.78 ms **Speicher**: 0.027 MB / 16.48 MB Application: afterRenderModule mod_search (Suchen)

**Zeit**: 4.96 ms / 1064.74 ms **Speicher**: 0.001 MB / 16.49 MB Application: beforeRenderModule mod_menu (Main Menu (Icons / Rich Text))

**Zeit**: 57.05 ms / 1121.79 ms **Speicher**: 0.584 MB / 17.07 MB Application: afterRenderModule mod_menu (Main Menu (Icons / Rich Text))

**Zeit**: 66.39 ms / 1188.18 ms **Speicher**: 0.000 MB / 16.91 MB Application: afterRender

**Datenbankabfragen gesamt: 72.92 ms**

Speichernutzung

Datenbankabfragen

86 ausgeführte Abfragen 72.92 ms

24 Duplikate gefunden!

**3 Duplikate**: #6 #10 #67

**2 Duplikate**: #12 #16

**2 Duplikate**: #13 #17

**2 Duplikate**: #14 #18

**2 Duplikate**: #26 #35

**4 Duplikate**: #31 #34 #46 #49

**3 Duplikate**: #51 #58 #66

**2 Duplikate**: #54 #65

**2 Duplikate**: #60 #61

**2 Duplikate**: #83 #84

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

SELECT `data`

  FROM `ry2xb_session`

  WHERE `session_id` = 'f9ljkj6sp9sirn5osnsvi9n7iv'

**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.05 ms
checking permissions	0.01 ms
Opening tables	0.04 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.04 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.32 ms** **Nach letzter Abfrage: 10.97 ms** **Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 3.769 MB** **Zeilen zurückgegeben: 0**

SELECT `session_id`

  FROM `ry2xb_session`

  WHERE `session_id` = 'f9ljkj6sp9sirn5osnsvi9n7iv' 
  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.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 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
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.68 ms** **Nach letzter Abfrage: 0.25 ms** **Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 3.774 MB**

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

**Erklären**

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

**Profil (Profile)**

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
update	0.11 ms
end	0.01 ms
query end	0.38 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.61 ms** **Nach letzter Abfrage: 33.63 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.30 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.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.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: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.37 ms** **Nach letzter Abfrage: 0.14 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.04 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 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.03 ms
logging slow query	0.03 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: 1.53 ms** **Nach letzter Abfrage: 52.05 ms** **Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 5.819 MB** **Zeilen zurückgegeben: 165**

**Doppelte Abfragen**: #10 #67

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.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
checking permissions	1.08 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	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: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.29 ms** **Nach letzter Abfrage: 0.10 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.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 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.02 ms
logging slow query	0.05 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.61 ms** **Nach letzter Abfrage: 6.08 ms** **Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 5.944 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.03 ms
checking permissions	0.24 ms
Opening tables	0.04 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 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.03 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: 1.36 ms** **Nach letzter Abfrage: 79.01 ms** **Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 7.130 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.02 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.04 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.63 ms** **Nach letzter Abfrage: 63.52 ms** **Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 8.088 MB** **Zeilen zurückgegeben: 165**

**Doppelte Abfragen**: #6 #67

SHOW TABLES

**Erklären**

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

**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.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
checking permissions	1.16 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.05 ms
cleaning up	0.02 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.26 ms** **Nach letzter Abfrage: 0.10 ms** **Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 8.115 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.01 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.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.03 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.32 ms** **Nach letzter Abfrage: 3.19 ms** **Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 8.274 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.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.01 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.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: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: 0.98 ms** **Nach letzter Abfrage: 0.08 ms** **Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 8.282 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.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.40 ms
Creating sort index	0.04 ms
end	0.01 ms
removing tmp table	0.18 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
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: 1.60 ms** **Nach letzter Abfrage: 0.08 ms** **Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 8.288 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.02 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.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.19 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
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.20 ms** **Nach letzter Abfrage: 73.05 ms** **Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 9.454 MB**

UPDATE `ry2xb_extensions`

  SET `params` = '{\"mediaversion\":\"4089b33b64c0b1b65306b88527d6272f\"}'

  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.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.09 ms
updating	0.09 ms
end	0.01 ms
query end	0.73 ms
closing tables	0.02 ms
freeing items	0.03 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.34 ms** **Nach letzter Abfrage: 35.44 ms** **Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 9.912 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.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.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.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: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: 0.95 ms** **Nach letzter Abfrage: 0.07 ms** **Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 9.922 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.04 ms
checking permissions	0.02 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.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.39 ms
Creating sort index	0.04 ms
end	0.01 ms
removing tmp table	0.17 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
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.35 ms** **Nach letzter Abfrage: 0.06 ms** **Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 9.928 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.02 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.11 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.04 ms
logging slow query	0.03 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.25 ms** **Nach letzter Abfrage: 3.28 ms** **Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 10.003 MB** **Zeilen zurückgegeben: 0**

SELECT element,views,context,types,params

  FROM ry2xb_ark_editor_inline_views

  WHERE element = 'com_tags' 
  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.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.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.03 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.35 ms** **Nach letzter Abfrage: 0.19 ms** **Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 10.009 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.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
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: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.27 ms** **Nach letzter Abfrage: 1.68 ms** **Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 10.016 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.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.03 ms
cleaning up	0.01 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.40 ms** **Nach letzter Abfrage: 14.75 ms** **Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 10.282 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.01 ms
statistics	0.08 ms
preparing	0.02 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.02 ms
logging slow query	0.03 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: 1.84 ms** **Nach letzter Abfrage: 28.40 ms** **Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 10.793 MB** **Zeilen zurückgegeben: 17**

SELECT *

  FROM `ry2xb_content_types`

**Erklären**

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

**Profil (Profile)**

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	1.47 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.12 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Helper/TagsHelper.php:794
17	Joomla\CMS\Helper\TagsHelper::getTypes()	JROOT/libraries/src/Helper/TagsHelper.php:628
16	Joomla\CMS\Helper\TagsHelper->getTagItemsQuery()	JROOT/components/com_tags/models/tag.php:149
15	TagsModelTag->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_tags/models/tag.php:86
12	TagsModelTag->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:93
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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: 9.28 ms** **Nach letzter Abfrage: 0.12 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 10.804 MB** **Zeilen zurückgegeben: 2**

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

  FROM ry2xb_contentitem_tag_map AS m

  INNER JOIN ry2xb_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2021-01-16 20:37:53')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2021-01-16 20:37:53')

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

  LEFT JOIN ry2xb_categories AS tc 
  ON tc.id = c.core_catid

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

  WHERE m.tag_id IN (24) 
  AND (c.core_catid = 0 OR tc.published = 1) 
  AND m.type_alias IN ('com_content.article','com_weblinks.weblink','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_weblinks.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category','com_modules.custom','com_modules.custom') 
  AND c.core_access IN (0,1)

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

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

**Erklären**

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

**Profil (Profile)**

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

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_tags/models/tag.php:86
12	TagsModelTag->getItems()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:93
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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.73 ms** **Nach letzter Abfrage: 10.47 ms** **Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 11.096 MB** **Zeilen zurückgegeben: 30**

SHOW FULL COLUMNS 
  FROM `ry2xb_tags`

**Erklären**

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

**Profil (Profile)**

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.46 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.05 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.18 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_tags/tables/tag.php:29
14	TagsTableTag->__construct()	JROOT/libraries/src/Table/Table.php:312
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_tags/models/tag.php:272
12	TagsModelTag->getItem()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:94
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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.36 ms** **Nach letzter Abfrage: 12.66 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 11.203 MB** **Zeilen zurückgegeben: 1**

**Doppelte Abfragen**: #35

SELECT *

  FROM ry2xb_tags

  WHERE `id` = '24'

**Erklären**

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

**Profil (Profile)**

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.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/libraries/src/Table/Table.php:731
13	Joomla\CMS\Table\Table->load()	JROOT/components/com_tags/models/tag.php:281
12	TagsModelTag->getItem()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:94
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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.59 ms** **Nach letzter Abfrage: 2.45 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 11.305 MB** **Zeilen zurückgegeben: 2**

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

  FROM ry2xb_contentitem_tag_map AS m

  INNER JOIN ry2xb_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2021-01-16 20:37:53')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2021-01-16 20:37:53')

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

  LEFT JOIN ry2xb_categories AS tc 
  ON tc.id = c.core_catid

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

  WHERE m.tag_id IN (24) 
  AND (c.core_catid = 0 OR tc.published = 1) 
  AND m.type_alias IN ('com_content.article','com_weblinks.weblink','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_weblinks.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category','com_modules.custom','com_modules.custom') 
  AND c.core_access IN (0,1)

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

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

**Erklären**

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

**Profil (Profile)**

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

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:348
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:97
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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: 2.23 ms** **Nach letzter Abfrage: 44.86 ms** **Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 11.967 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 = 41

  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.78 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.23 ms
optimizing	0.02 ms
statistics	0.17 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.23 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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:312
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_tags/views/tag/view.html.php:141
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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.64 ms** **Nach letzter Abfrage: 2.00 ms** **Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 12.017 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 (41,0,51)) 
  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.08 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.08 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.03 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.02 ms
logging slow query	0.03 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/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_tags/views/tag/view.html.php:141
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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.35 ms** **Nach letzter Abfrage: 13.42 ms** **Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 12.372 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.07 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
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.03 ms
cleaning up	0.00 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_imageshow/classes/jsn_is_parameter.php:81
16	JSNISParameter->getParameters()	JROOT/administrator/components/com_imageshow/imageshow.defines.php:27
15	require_once JROOT/administrator/components/com_imageshow/imageshow.defines.php	JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:16
14	include_once JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php	JROOT/plugins/content/imageshow/imageshow.php:28
13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_tags/views/tag/view.html.php:141
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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.33 ms** **Nach letzter Abfrage: 13.85 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 12.695 MB** **Zeilen zurückgegeben: 1**

**Doppelte Abfragen**: #34 #46 #49

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.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.03 ms
cleaning up	0.00 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310
14	JSNISUtils->getComponentInfo()	JROOT/plugins/content/imageshow/imageshow.php:45
13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_tags/views/tag/view.html.php:141
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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.71 ms** **Nach letzter Abfrage: 2.14 ms** **Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 12.707 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.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.13 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.19 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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:312
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_tags/views/tag/view.html.php:141
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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: 0.19 ms** **Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 12.726 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.07 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.00 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:479
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_tags/views/tag/view.html.php:141
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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.27 ms** **Nach letzter Abfrage: 1.17 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 12.738 MB** **Zeilen zurückgegeben: 1**

**Doppelte Abfragen**: #31 #46 #49

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.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.02 ms
cleaning up	0.00 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310
14	JSNISUtils->getComponentInfo()	JROOT/plugins/content/imageshow/imageshow.php:45
13	plgContentImageShow->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_tags/views/tag/view.html.php:141
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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.27 ms** **Nach letzter Abfrage: 9.72 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 13.509 MB** **Zeilen zurückgegeben: 1**

**Doppelte Abfragen**: #26

SELECT *

  FROM ry2xb_tags

  WHERE `id` = '24'

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ry2xb_tags	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.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
12	Joomla\CMS\Table\Table->load()	JROOT/components/com_tags/models/tag.php:336
11	TagsModelTag->hit()	JROOT/components/com_tags/views/tag/view.html.php:236
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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.61 ms** **Nach letzter Abfrage: 0.19 ms** **Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 13.516 MB**

UPDATE ry2xb_tags

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

  WHERE `id` = '24'

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ry2xb_tags	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

**Profil (Profile)**

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.03 ms
updating	0.09 ms
end	0.01 ms
query end	0.33 ms
closing tables	0.01 ms
freeing items	0.01 ms
logging slow query	0.02 ms
cleaning up	0.00 ms

**Aufrufstapel (Call Stack)**

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1242
12	Joomla\CMS\Table\Table->hit()	JROOT/components/com_tags/models/tag.php:337
11	TagsModelTag->hit()	JROOT/components/com_tags/views/tag/view.html.php:236
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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.40 ms** **Nach letzter Abfrage: 41.18 ms** **Abfragespeichernutzung: 0.011 MB Speichernutzung vor Abfrage: 14.388 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.37 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.13 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.60 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
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_tags/views/tag/tmpl/default_items.php:20
15	include JROOT/components/com_tags/views/tag/tmpl/default_items.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
14	JViewLegacy->loadTemplate()	JROOT/components/com_tags/views/tag/tmpl/default.php:50
13	include JROOT/components/com_tags/views/tag/tmpl/default.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:663
12	JViewLegacy->loadTemplate()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:211
11	JViewLegacy->display()	JROOT/components/com_tags/views/tag/view.html.php:240
10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.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.53 ms** **Nach letzter Abfrage: 27.69 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 15.049 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-16 20:37:53') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-16 20:37:53') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 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.09 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	2.93 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: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.39 ms** **Nach letzter Abfrage: 34.23 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 15.218 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 = 0) 
  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	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	NULL	Impossible 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.06 ms
System lock	0.01 ms
optimizing	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 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.14 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 15.227 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 OR mm.menuid = 0 OR (mm.menuid < 0 
  AND mm.menuid != 0)) 
  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.08 ms
preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.23 ms
Creating sort index	0.01 ms
end	0.00 ms
removing tmp table	0.01 ms
end	0.00 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
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.37 ms** **Nach letzter Abfrage: 0.17 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 15.234 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 = 0) 
  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	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	NULL	Impossible WHERE

**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.06 ms
System lock	0.01 ms
optimizing	0.02 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: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.68 ms** **Nach letzter Abfrage: 0.08 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 15.242 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 OR mm.menuid = 0 OR (mm.menuid < 0 
  AND mm.menuid != 0)) 
  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.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.07 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.00 ms
Sending data	0.21 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: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: 1.96 ms** **Nach letzter Abfrage: 33.55 ms** **Abfragespeichernutzung: 0.007 MB Speichernutzung vor Abfrage: 15.323 MB** **Zeilen zurückgegeben: 0**

SELECT *

  FROM ry2xb_banners

  WHERE '2021-01-16 20:37:53' >= 'reset' 
  AND `reset` != '0000-00-00 00:00:00' 
  AND `reset`!= NULL 
  AND (`checked_out` = 0 OR `checked_out` = 0)

**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

**Profil (Profile)**

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	1.57 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.02 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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
14	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
13	include JROOT/modules/mod_banners/mod_banners.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
12	JModuleHelper::renderModule()	*Der selbe Aufruf in der Zeile darunter.*
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:643
9	JModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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: 2.73 ms** **Nach letzter Abfrage: 3.76 ms** **Abfragespeichernutzung: 0.009 MB Speichernutzung vor Abfrage: 15.387 MB** **Zeilen zurückgegeben: 0**

SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions

  FROM ry2xb_banners as a

  LEFT JOIN ry2xb_banner_clients AS cl 
  ON cl.id = a.cid

  WHERE a.state=1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-16 20:37:53') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-16 20:37:53') 
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
  AND ((a.own_prefix=1  
  AND a.metakey_prefix=SUBSTRING('Feuchteregler',1,LENGTH( a.metakey_prefix))  OR a.own_prefix=0  
  AND cl.own_prefix=1  
  AND cl.metakey_prefix=SUBSTRING('Feuchteregler',1,LENGTH(cl.metakey_prefix))  OR a.own_prefix=0  
  AND cl.own_prefix=0  
  AND 1) 
  AND (a.metakey REGEXP '[[:<:]]Feuchteregler[[:>:]]') OR (a.own_prefix=1  
  AND a.metakey_prefix=SUBSTRING('luftfeuchte Regeln',1,LENGTH( a.metakey_prefix))  OR a.own_prefix=0  
  AND cl.own_prefix=1  
  AND cl.metakey_prefix=SUBSTRING('luftfeuchte Regeln',1,LENGTH(cl.metakey_prefix))  OR a.own_prefix=0  
  AND cl.own_prefix=0  
  AND 1) 
  AND (a.metakey REGEXP '[[:<:]]luftfeuchte Regeln[[:>:]]') OR (a.own_prefix=1  
  AND a.metakey_prefix=SUBSTRING('Keller feucht',1,LENGTH( a.metakey_prefix))  OR a.own_prefix=0  
  AND cl.own_prefix=1  
  AND cl.metakey_prefix=SUBSTRING('Keller feucht',1,LENGTH(cl.metakey_prefix))  OR a.own_prefix=0  
  AND cl.own_prefix=0  
  AND 1) 
  AND (a.metakey REGEXP '[[:<:]]Keller feucht[[:>:]]') OR (a.own_prefix=1  
  AND a.metakey_prefix=SUBSTRING('Klärschlamm Solar trocknen',1,LENGTH( a.metakey_prefix))  OR a.own_prefix=0  
  AND cl.own_prefix=1  
  AND cl.metakey_prefix=SUBSTRING('Klärschlamm Solar trocknen',1,LENGTH(cl.metakey_prefix))  OR a.own_prefix=0  
  AND cl.own_prefix=0  
  AND 1) 
  AND (a.metakey REGEXP '[[:<:]]Klärschlamm Solar trocknen[[:>:]]') OR (a.own_prefix=1  
  AND a.metakey_prefix=SUBSTRING('solare Klärschlammtrocknung',1,LENGTH( a.metakey_prefix))  OR a.own_prefix=0  
  AND cl.own_prefix=1  
  AND cl.metakey_prefix=SUBSTRING('solare Klärschlammtrocknung',1,LENGTH(cl.metakey_prefix))  OR a.own_prefix=0  
  AND cl.own_prefix=0  
  AND 1) 
  AND (a.metakey REGEXP '[[:<:]]solare Klärschlammtrocknung[[:>:]]') OR (a.own_prefix=1  
  AND a.metakey_prefix=SUBSTRING('Klärschlamm',1,LENGTH( a.metakey_prefix))  OR a.own_prefix=0  
  AND cl.own_prefix=1  
  AND cl.metakey_prefix=SUBSTRING('Klärschlamm',1,LENGTH(cl.metakey_prefix))  OR a.own_prefix=0  
  AND cl.own_prefix=0  
  AND 1) 
  AND (a.metakey REGEXP '[[:<:]]Klärschlamm[[:>:]]') OR (a.own_prefix=1  
  AND a.metakey_prefix=SUBSTRING('Klärschlamm entwässern',1,LENGTH( a.metakey_prefix))  OR a.own_prefix=0  
  AND cl.own_prefix=1  
  AND cl.metakey_prefix=SUBSTRING('Klärschlamm entwässern',1,LENGTH(cl.metakey_prefix))  OR a.own_prefix=0  
  AND cl.own_prefix=0  
  AND 1) 
  AND (a.metakey REGEXP '[[:<:]]Klärschlamm entwässern[[:>:]]') OR (a.own_prefix=1  
  AND a.metakey_prefix=SUBSTRING('',1,LENGTH( a.metakey_prefix))  OR a.own_prefix=0  
  AND cl.own_prefix=1  
  AND cl.metakey_prefix=SUBSTRING('',1,LENGTH(cl.metakey_prefix))  OR a.own_prefix=0  
  AND cl.own_prefix=0  
  AND 1) 
  AND (a.metakey REGEXP '[[:<:]][[:>:]]'))

  ORDER BY a.sticky DESC,a.ordering 
  LIMIT 4

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_own_prefix	idx_state	1	const	1	100.00	Using where; filesort wurde genutzt
1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	DB3079243.a.cid	1	100.00	Using where

**Profil (Profile)**

Status	Duration
starting	0.28 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.63 ms
init	0.43 ms
System lock	0.01 ms
optimizing	0.83 ms
statistics	0.17 ms
preparing	0.14 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
logging slow query	0.04 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/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:205
15	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
14	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
13	include JROOT/modules/mod_banners/mod_banners.php	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:195
12	JModuleHelper::renderModule()	*Der selbe Aufruf in der Zeile darunter.*
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplmodulehelper.php:643
9	JModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
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.74 ms** **Nach letzter Abfrage: 49.09 ms** **Abfragespeichernutzung: 0.011 MB Speichernutzung vor Abfrage: 15.553 MB** **Zeilen zurückgegeben: 0**

sensor gesteuerte Zwangslüftung

Grundlagen der Effektivität der solaren Trocknung System DRYTEC

Keller trocknen, Keller trockenlegen, Keller feucht, richtig lüften

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

86 ausgeführte Abfragen 72.92 ms

24 Duplikate gefunden!

sensor gesteuerte Zwangslüftung

Grundlagen der Effektivität der solaren Trocknung System DRYTEC

Keller trocknen, Keller trockenlegen, Keller feucht, richtig lüften

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**

**86 ausgeführte Abfragen** 72.92 ms

**24 Duplikate gefunden!**

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

86 ausgeführte Abfragen 72.92 ms

24 Duplikate gefunden!