**Abfragezeit: 0.42 ms**
```
SELECT `data`

  FROM `tvojd_session`

  WHERE `session_id` = '619ghnr4lu38nchq1g1skeu8c4'
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_session const PRIMARY PRIMARY 602 const 1
**Profil (Profile)**
Error
The 'SHOW PROFILES' feature is disabled; you need MySQL built with 'enable-profiling' to have it working SQL=SHOW PROFILES
**Aufrufstapel (Call Stack)**
JROOT/libraries/joomla/session/storage/database.php:46
JROOT/libraries/joomla/session/session.php:658
JROOT/libraries/joomla/session/session.php:596
JROOT/libraries/cms/application/cms.php:662
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:322
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 0.48 ms** **Nach letzter Abfrage: 0.79 ms**
```
DELETE 

  FROM `tvojd_session`

  WHERE `time` < '1571180773'
```
**Erklären**
**„EXPLAIN“ unmöglich für Abfrage: DELETE FROM `tvojd_session` WHERE `time` < '1571180773'**
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/cms/application/cms.php:679
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:322
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 0.43 ms** **Nach letzter Abfrage: 0.27 ms**
```
SELECT `session_id`

  FROM `tvojd_session`

  WHERE `session_id` = '619ghnr4lu38nchq1g1skeu8c4' 
  LIMIT 0, 1
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_session const PRIMARY PRIMARY 602 const 1 Using index
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/cms/application/cms.php:175
JROOT/libraries/cms/application/cms.php:688
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:322
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 0.52 ms** **Nach letzter Abfrage: 0.21 ms**
```
INSERT INTO `tvojd_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('619ghnr4lu38nchq1g1skeu8c4', 0, '1571181673')
```
**Erklären**
**„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `tvojd_session` (`session_id`, `client_id`, `time`) VALUES ('619ghnr4lu38nchq1g1skeu8c4', 0, '1571181673')**
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/cms/application/cms.php:207
JROOT/libraries/cms/application/cms.php:688
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:322
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 0.89 ms** **Nach letzter Abfrage: 0.89 ms**
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM tvojd_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_users'
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/application/site.php:557
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 0.79 ms** **Nach letzter Abfrage: 0.60 ms**
```
SELECT b.id

  FROM tvojd_usergroups AS a

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

  WHERE a.id = 9
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a const PRIMARY PRIMARY 4 const 1
1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 3 Using where
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/joomla/access/access.php:336
JROOT/libraries/joomla/access/access.php:405
JROOT/libraries/joomla/user/user.php:428
JROOT/libraries/cms/plugin/helper.php:298
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:562
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**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: 0.27 ms**
```
SELECT id, rules

  FROM `tvojd_viewlevels`
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_viewlevels ALL NULL **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL 4
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/joomla/access/access.php:422
JROOT/libraries/joomla/user/user.php:428
JROOT/libraries/cms/plugin/helper.php:298
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:562
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 2.29 ms** **Nach letzter Abfrage: 0.26 ms**
```
SELECT folder AS type, element AS name, params

  FROM tvojd_extensions

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

  ORDER BY ordering
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_extensions ref extension extension 62 const 63 Using where; **filesort wurde genutzt**
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/cms/plugin/helper.php:312
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:562
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 0.48 ms** **Nach letzter Abfrage: 1.21 ms**
```
SELECT *

  FROM tvojd_languages

  WHERE published=1

  ORDER BY ordering ASC
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_languages ALL NULL **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL 4 Using where; **filesort wurde genutzt**
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/joomla/language/helper.php:166
JROOT/plugins/system/languagefilter/languagefilter.php:67
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/site.php:562
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 0.69 ms** **Nach letzter Abfrage: 0.26 ms**
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM tvojd_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_languages'
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/plugins/system/languagefilter/languagefilter.php:69
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/site.php:562
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**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.28 ms**
```
SELECT COUNT(*)

  FROM `tvojd_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_menu ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 63 Using where
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:32
JROOT/plugins/system/languagefilter/languagefilter.php:71
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/site.php:562
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**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: 33.58 ms**
**Doppelte Abfragen**: #36 #71
```
SHOW TABLES
```
**Erklären**
**„EXPLAIN“ unmöglich für Abfrage: SHOW TABLES**
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/plugins/system/jdownloads/jdownloads.php:30
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:577
JROOT/libraries/cms/application/site.php:636
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 0.75 ms** **Nach letzter Abfrage: 0.53 ms**
```
SELECT file_id 
  from tvojd_jdownloads_files 
  WHERE published = 1 
  AND use_timeframe = 1 
  AND publish_to != '0000-00-00 00:00:00' 
  AND publish_to <= '2019-10-16 01:21:13'
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_jdownloads_files ALL NULL **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL 225 Using where
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/plugins/system/jdownloads/jdownloads.php:59
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:577
JROOT/libraries/cms/application/site.php:636
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 1.39 ms** **Nach letzter Abfrage: 0.13 ms**
```
SELECT file_id 
  from tvojd_jdownloads_files 
  WHERE published = 0 
  AND use_timeframe = 1 
  AND publish_from != '0000-00-00 00:00:00' 
  AND publish_from <= '2019-10-16 01:21:13'
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_jdownloads_files ALL NULL **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL 225 Using where
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/plugins/system/jdownloads/jdownloads.php:67
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:577
JROOT/libraries/cms/application/site.php:636
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**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.32 ms**
```
SELECT * 
  FROM tvojd_extensions 
  WHERE element='mailster' 
  AND folder='system'
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_extensions ref element_clientid,element_folder_clientid element_clientid 302 const 1 Using where
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/administrator/components/com_mailster/mailster/app/PluginUtils.php:176
JROOT/plugins/system/mailster/mailster.php:56
JROOT/plugins/system/mailster/mailster.php:71
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:577
JROOT/libraries/cms/application/site.php:636
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**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: 18.56 ms**
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM tvojd_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_mailster'
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:42
JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:136
JROOT/administrator/components/com_mailster/mailster/app/Log.php:211
JROOT/administrator/components/com_mailster/mailster/app/Log.php:195
JROOT/administrator/components/com_mailster/mailster/app/Log.php:52
JROOT/administrator/components/com_mailster/mailster/app/Log.php:128
JROOT/plugins/system/mailster/mailster.php:89
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:577
JROOT/libraries/cms/application/site.php:636
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 0.63 ms** **Nach letzter Abfrage: 0.29 ms**
**Doppelte Abfragen**: #30 #31 #32
```
SELECT extension_id AS "id", element AS "option", params, enabled

  FROM tvojd_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_mailster'
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/administrator/components/com_mailster/mailster/app/Application.php:46
JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:44
JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:136
JROOT/administrator/components/com_mailster/mailster/app/Log.php:211
JROOT/administrator/components/com_mailster/mailster/app/Log.php:195
JROOT/administrator/components/com_mailster/mailster/app/Log.php:52
JROOT/administrator/components/com_mailster/mailster/app/Log.php:128
JROOT/plugins/system/mailster/mailster.php:89
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:577
JROOT/libraries/cms/application/site.php:636
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 1.29 ms** **Nach letzter Abfrage: 0.40 ms**
**Doppelte Abfragen**: #19 #20 #21
```
SHOW FULL COLUMNS 
  FROM tvojd_users 
  WHERE 1
```
**Erklären**
**„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM tvojd_users WHERE 1**
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:163
JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:77
JROOT/plugins/system/mailster/mailster.php:160
JROOT/plugins/system/mailster/mailster.php:91
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:577
JROOT/libraries/cms/application/site.php:636
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 1.83 ms** **Nach letzter Abfrage: 0.09 ms**
**Doppelte Abfragen**: #18 #20 #21
```
SHOW FULL COLUMNS 
  FROM tvojd_users 
  WHERE 1
```
**Erklären**
**„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM tvojd_users WHERE 1**
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:174
JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:77
JROOT/plugins/system/mailster/mailster.php:160
JROOT/plugins/system/mailster/mailster.php:91
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:577
JROOT/libraries/cms/application/site.php:636
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 1.84 ms** **Nach letzter Abfrage: 0.40 ms**
**Doppelte Abfragen**: #18 #19 #21
```
SHOW FULL COLUMNS 
  FROM tvojd_users 
  WHERE 1
```
**Erklären**
**„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM tvojd_users WHERE 1**
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:163
JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:78
JROOT/plugins/system/mailster/mailster.php:160
JROOT/plugins/system/mailster/mailster.php:91
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:577
JROOT/libraries/cms/application/site.php:636
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 1.78 ms** **Nach letzter Abfrage: 0.14 ms**
**Doppelte Abfragen**: #18 #19 #20
```
SHOW FULL COLUMNS 
  FROM tvojd_users 
  WHERE 1
```
**Erklären**
**„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM tvojd_users WHERE 1**
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:174
JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:78
JROOT/plugins/system/mailster/mailster.php:160
JROOT/plugins/system/mailster/mailster.php:91
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:577
JROOT/libraries/cms/application/site.php:636
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 1.02 ms** **Nach letzter Abfrage: 0.21 ms**
**Doppelte Abfragen**: #23
```
SHOW FULL COLUMNS 
  FROM tvojd_usergroups 
  WHERE 1
```
**Erklären**
**„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM tvojd_usergroups WHERE 1**
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:163
JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:79
JROOT/plugins/system/mailster/mailster.php:160
JROOT/plugins/system/mailster/mailster.php:91
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:577
JROOT/libraries/cms/application/site.php:636
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 1.05 ms** **Nach letzter Abfrage: 0.10 ms**
**Doppelte Abfragen**: #22
```
SHOW FULL COLUMNS 
  FROM tvojd_usergroups 
  WHERE 1
```
**Erklären**
**„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM tvojd_usergroups WHERE 1**
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:174
JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:79
JROOT/plugins/system/mailster/mailster.php:160
JROOT/plugins/system/mailster/mailster.php:91
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:577
JROOT/libraries/cms/application/site.php:636
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 1.32 ms** **Nach letzter Abfrage: 0.26 ms**
**Doppelte Abfragen**: #25 #26 #27
```
SHOW FULL COLUMNS 
  FROM tvojd_mailster_users 
  WHERE 1
```
**Erklären**
**„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM tvojd_mailster_users WHERE 1**
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:163
JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:80
JROOT/plugins/system/mailster/mailster.php:160
JROOT/plugins/system/mailster/mailster.php:91
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:577
JROOT/libraries/cms/application/site.php:636
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 1.05 ms** **Nach letzter Abfrage: 0.14 ms**
**Doppelte Abfragen**: #24 #26 #27
```
SHOW FULL COLUMNS 
  FROM tvojd_mailster_users 
  WHERE 1
```
**Erklären**
**„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM tvojd_mailster_users WHERE 1**
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:174
JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:80
JROOT/plugins/system/mailster/mailster.php:160
JROOT/plugins/system/mailster/mailster.php:91
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:577
JROOT/libraries/cms/application/site.php:636
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 1.00 ms** **Nach letzter Abfrage: 0.26 ms**
**Doppelte Abfragen**: #24 #25 #27
```
SHOW FULL COLUMNS 
  FROM tvojd_mailster_users 
  WHERE 1
```
**Erklären**
**„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM tvojd_mailster_users WHERE 1**
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:163
JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:81
JROOT/plugins/system/mailster/mailster.php:160
JROOT/plugins/system/mailster/mailster.php:91
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:577
JROOT/libraries/cms/application/site.php:636
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 1.98 ms** **Nach letzter Abfrage: 0.14 ms**
**Doppelte Abfragen**: #24 #25 #26
```
SHOW FULL COLUMNS 
  FROM tvojd_mailster_users 
  WHERE 1
```
**Erklären**
**„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM tvojd_mailster_users WHERE 1**
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:174
JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:81
JROOT/plugins/system/mailster/mailster.php:160
JROOT/plugins/system/mailster/mailster.php:91
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:577
JROOT/libraries/cms/application/site.php:636
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 1.15 ms** **Nach letzter Abfrage: 0.26 ms**
**Doppelte Abfragen**: #29
```
SHOW FULL COLUMNS 
  FROM tvojd_mailster_groups 
  WHERE 1
```
**Erklären**
**„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM tvojd_mailster_groups WHERE 1**
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:163
JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:82
JROOT/plugins/system/mailster/mailster.php:160
JROOT/plugins/system/mailster/mailster.php:91
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:577
JROOT/libraries/cms/application/site.php:636
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 1.11 ms** **Nach letzter Abfrage: 0.13 ms**
**Doppelte Abfragen**: #28
```
SHOW FULL COLUMNS 
  FROM tvojd_mailster_groups 
  WHERE 1
```
**Erklären**
**„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM tvojd_mailster_groups WHERE 1**
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:174
JROOT/administrator/components/com_mailster/mailster/utils/DBUtils.php:82
JROOT/plugins/system/mailster/mailster.php:160
JROOT/plugins/system/mailster/mailster.php:91
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:577
JROOT/libraries/cms/application/site.php:636
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**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: 0.38 ms**
**Doppelte Abfragen**: #17 #31 #32
```
SELECT extension_id AS "id", element AS "option", params, enabled

  FROM tvojd_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_mailster'
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/administrator/components/com_mailster/mailster/app/Application.php:46
JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:44
JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:136
JROOT/administrator/components/com_mailster/mailster/app/Log.php:211
JROOT/administrator/components/com_mailster/mailster/app/Log.php:195
JROOT/administrator/components/com_mailster/mailster/app/Log.php:52
JROOT/administrator/components/com_mailster/mailster/app/Log.php:128
JROOT/plugins/system/mailster/mailster.php:265
JROOT/plugins/system/mailster/mailster.php:93
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:577
JROOT/libraries/cms/application/site.php:636
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 0.41 ms** **Nach letzter Abfrage: 0.40 ms**
**Doppelte Abfragen**: #17 #30 #32
```
SELECT extension_id AS "id", element AS "option", params, enabled

  FROM tvojd_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_mailster'
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/administrator/components/com_mailster/mailster/app/Application.php:46
JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:44
JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:136
JROOT/administrator/components/com_mailster/mailster/app/Log.php:211
JROOT/administrator/components/com_mailster/mailster/app/Log.php:195
JROOT/administrator/components/com_mailster/mailster/app/Log.php:52
JROOT/administrator/components/com_mailster/mailster/app/Log.php:128
JROOT/plugins/system/mailster/mailster.php:277
JROOT/plugins/system/mailster/mailster.php:116
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:577
JROOT/libraries/cms/application/site.php:636
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 0.49 ms** **Nach letzter Abfrage: 0.46 ms**
**Doppelte Abfragen**: #17 #30 #31
```
SELECT extension_id AS "id", element AS "option", params, enabled

  FROM tvojd_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_mailster'
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/administrator/components/com_mailster/mailster/app/Application.php:46
JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:44
JROOT/administrator/components/com_mailster/mailster/conf/Configuration.php:136
JROOT/administrator/components/com_mailster/mailster/app/Log.php:211
JROOT/administrator/components/com_mailster/mailster/app/Log.php:195
JROOT/administrator/components/com_mailster/mailster/app/Log.php:52
JROOT/administrator/components/com_mailster/mailster/app/Log.php:128
JROOT/plugins/system/mailster/mailster.php:289
JROOT/plugins/system/mailster/mailster.php:172
JROOT/plugins/system/mailster/mailster.php:140
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:577
JROOT/libraries/cms/application/site.php:636
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 0.30 ms** **Nach letzter Abfrage: 0.74 ms**
```
SELECT count(*)

  FROM `tvojd_cwgears_schedule`
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE NULL NULL NULL **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL NULL Select tables optimized away
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/plugins/system/cwgears/cwgears.php:74
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:577
JROOT/libraries/cms/application/site.php:636
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 0.53 ms** **Nach letzter Abfrage: 0.22 ms**
```
SELECT count(*)

  FROM `tvojd_cwgears_schedule`

  WHERE time + '86400'<'1571181673'
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE NULL NULL NULL **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL NULL Impossible WHERE noticed after reading const tables
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/plugins/system/cwgears/cwgears.php:96
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:577
JROOT/libraries/cms/application/site.php:636
JROOT/libraries/cms/application/site.php:196
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tvojd_session	const	PRIMARY	PRIMARY	602	const	1

Error
The 'SHOW PROFILES' feature is disabled; you need MySQL built with 'enable-profiling' to have it working SQL=SHOW PROFILES

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tvojd_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	Using where

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tvojd_extensions	ref	extension	extension	62	const	63	Using where; filesort wurde genutzt

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tvojd_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tvojd_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	63	Using where

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tvojd_extensions	ref	element_clientid,element_folder_clientid	element_clientid	302	const	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tvojd_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tvojd_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tvojd_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tvojd_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tvojd_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	Select tables optimized away

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

**Abfragezeit: 3.93 ms** **Nach letzter Abfrage: 16.56 ms**

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

  FROM tvojd_menu AS m

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

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

  ORDER BY m.lft

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	1	Using where; filesort wurde genutzt
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	HTO01FLYNJYV_2.m.component_id	1

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

JROOT/libraries/cms/menu/site.php:47

JROOT/libraries/cms/menu/menu.php:64

JROOT/libraries/cms/menu/menu.php:118

JROOT/libraries/cms/application/cms.php:347

JROOT/libraries/cms/application/site.php:266

JROOT/libraries/cms/router/site.php:218

JROOT/libraries/cms/router/router.php:408

JROOT/libraries/cms/router/router.php:192

JROOT/libraries/cms/router/site.php:90

JROOT/libraries/cms/application/cms.php:1012

JROOT/libraries/cms/application/site.php:736

JROOT/libraries/cms/application/site.php:218

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

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

**Abfragezeit: 1.54 ms** **Nach letzter Abfrage: 10.16 ms**
**Doppelte Abfragen**: #12 #71
```
SHOW TABLES
```
**Erklären**
**„EXPLAIN“ unmöglich für Abfrage: SHOW TABLES**
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/plugins/system/jdownloads/jdownloads.php:252
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1021
JROOT/libraries/cms/application/site.php:736
JROOT/libraries/cms/application/site.php:218
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 0.80 ms** **Nach letzter Abfrage: 0.67 ms**
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM tvojd_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 Using where
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/library/helper.php:156
JROOT/libraries/cms/library/helper.php:47
JROOT/libraries/cms/library/helper.php:90
JROOT/libraries/cms/version/version.php:179
JROOT/libraries/joomla/factory.php:734
JROOT/libraries/joomla/factory.php:215
JROOT/plugins/system/cwgears/cwgears.php:123
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1021
JROOT/libraries/cms/application/site.php:736
JROOT/libraries/cms/application/site.php:218
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 1.67 ms** **Nach letzter Abfrage: 0.48 ms**
```
UPDATE `tvojd_extensions`

  SET `params` = '{\"mediaversion\":\"97a768e3d9e40de4a8e14d5f08229c46\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
**Erklären**
**„EXPLAIN“ unmöglich für Abfrage: UPDATE `tvojd_extensions` SET `params` = '{\"mediaversion\":\"97a768e3d9e40de4a8e14d5f08229c46\"}' WHERE `type` = 'library' AND `element` = 'joomla'**
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/cms/library/helper.php:119
JROOT/libraries/cms/version/version.php:230
JROOT/libraries/cms/version/version.php:189
JROOT/libraries/joomla/factory.php:734
JROOT/libraries/joomla/factory.php:215
JROOT/plugins/system/cwgears/cwgears.php:123
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1021
JROOT/libraries/cms/application/site.php:736
JROOT/libraries/cms/application/site.php:218
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 0.58 ms** **Nach letzter Abfrage: 0.76 ms**
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM tvojd_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_coalawebcontact'
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/plugins/system/cwmailcheck/cwmailcheck.php:86
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1021
JROOT/libraries/cms/application/site.php:736
JROOT/libraries/cms/application/site.php:218
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**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: 1.06 ms**
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM tvojd_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_content'
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_extensions ref element_clientid,element_folder_clientid,extension extension 364 const,const 1 Using where
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/components/com_content/router.php:37
JROOT/libraries/cms/router/site.php:463
JROOT/libraries/cms/router/site.php:426
JROOT/libraries/cms/router/router.php:231
JROOT/libraries/cms/router/site.php:106
JROOT/libraries/joomla/application/route.php:63
JROOT/plugins/system/sef/sef.php:49
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1021
JROOT/libraries/cms/application/site.php:736
JROOT/libraries/cms/application/site.php:218
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tvojd_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tvojd_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tvojd_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using where

**Abfragezeit: 0.73 ms** **Nach letzter Abfrage: 1.07 ms**

SELECT id, home, template, s.params

  FROM tvojd_template_styles as s

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

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

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	8	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	HTO01FLYNJYV_2.s.template,const	1	Using where

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

JROOT/libraries/cms/application/site.php:473

JROOT/libraries/cms/application/site.php:152

JROOT/libraries/cms/application/site.php:224

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

[**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: 17.36 ms**
```
SELECT a.rules

  FROM tvojd_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a const PRIMARY PRIMARY 4 const 1
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/joomla/access/access.php:250
JROOT/libraries/joomla/user/user.php:364
JROOT/components/com_content/models/article.php:55
JROOT/libraries/legacy/model/legacy.php:415
JROOT/components/com_content/models/article.php:75
JROOT/libraries/legacy/view/legacy.php:398
JROOT/components/com_content/views/article/view.html.php:44
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

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

**Abfragezeit: 0.78 ms** **Nach letzter Abfrage: 0.40 ms**

SELECT b.rules

  FROM tvojd_assets AS a

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

  WHERE (a.name = 'com_content')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	Using temporary; filesort wurde genutzt
1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	9	Using where

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

JROOT/libraries/joomla/access/access.php:250

JROOT/libraries/joomla/access/access.php:110

JROOT/libraries/joomla/user/user.php:373

JROOT/components/com_content/models/article.php:55

JROOT/libraries/legacy/model/legacy.php:415

JROOT/components/com_content/models/article.php:75

JROOT/libraries/legacy/view/legacy.php:398

JROOT/components/com_content/views/article/view.html.php:44

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:224

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

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

**Abfragezeit: 4.28 ms** **Nach letzter Abfrage: 0.64 ms**

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

  FROM tvojd_content AS a

  LEFT JOIN tvojd_categories AS c 
  on c.id = a.catid

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

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

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

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM tvojd_categories AS cat JOIN tvojd_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.language in ('de-DE','*') 
  AND a.id = 14 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-10-15 23:21:13') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-10-15 23:21:13') 
  AND (a.state = 1 OR a.state =2)

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	v	system	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	0	const row not found
1	PRIMARY	a	const	PRIMARY,idx_state,idx_language	PRIMARY	4	const	1
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	<derived2>	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	36
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	152		10	Using where; Using temporary; filesort wurde genutzt
2	DERIVED	cat	range	idx_left_right	idx_left_right	4	NULL	92	Range checked for each record (index map: 0x20)

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

JROOT/components/com_content/models/article.php:158

JROOT/libraries/legacy/view/legacy.php:398

JROOT/components/com_content/views/article/view.html.php:44

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:224

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

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

**Abfragezeit: 4.75 ms** **Nach letzter Abfrage: 1.38 ms**

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 tvojd_categories as c

  LEFT JOIN tvojd_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

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

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

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

  ORDER BY c.lft

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; filesort wurde genutzt
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	92	Using where
1	PRIMARY	<derived2>	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	36	Using where; Not exists
2	DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	152		10	Using where; Using temporary; filesort wurde genutzt
2	DERIVED	cat	range	idx_left_right	idx_left_right	4	NULL	92	Range checked for each record (index map: 0x20)

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

JROOT/libraries/legacy/categories/categories.php:288

JROOT/libraries/legacy/categories/categories.php:181

JROOT/components/com_content/helpers/route.php:41

JROOT/components/com_content/views/article/view.html.php:72

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:224

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

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

**Abfragezeit: 0.63 ms** **Nach letzter Abfrage: 1.72 ms**
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM tvojd_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_tags'
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/libraries/cms/helper/tags.php:389
JROOT/components/com_content/views/article/view.html.php:155
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 1.65 ms** **Nach letzter Abfrage: 0.36 ms**
```
SELECT `m`.`tag_id`,`t`.*

  FROM `tvojd_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 14 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t ref PRIMARY,tag_idx,idx_access tag_idx 1 const 7 Using where
1 SIMPLE m ref idx_tag_type,idx_tag idx_tag_type 4 HTO01FLYNJYV_2.t.id 11 Using where
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/cms/helper/tags.php:409
JROOT/components/com_content/views/article/view.html.php:155
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 0.54 ms** **Nach letzter Abfrage: 12.75 ms**
```
SELECT `type_id`,`type_alias`

  FROM `tvojd_content_types`

  WHERE `type_alias` IN ('com_fieldsandfilters.allextensions','com_content.article')
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_content_types range idx_alias idx_alias 767 NULL 2 Using where
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/administrator/components/com_fieldsandfilters/helpers/extensions/extensions.php:61
JROOT/administrator/components/com_fieldsandfilters/helpers/extensions/extensions.php:200
JROOT/administrator/components/com_fieldsandfilters/helpers/extensions/extensions.php:102
JROOT/plugins/fieldsandfiltersextensions/content/content.php:577
JROOT/plugins/fieldsandfiltersextensions/content/content.php:520
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/plugins/system/fieldsandfilters/fieldsandfilters.php:180
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/components/com_content/views/article/view.html.php:163
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 0.99 ms** **Nach letzter Abfrage: 0.84 ms**
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM tvojd_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_fieldsandfilters'
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_extensions ref element_clientid,element_folder_clientid,extension element_folder_clientid 302 const 1 Using where
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/administrator/components/com_fieldsandfilters/helpers/extensions/helper.php:93
JROOT/plugins/fieldsandfiltersextensions/content/content.php:591
JROOT/plugins/fieldsandfiltersextensions/content/content.php:520
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/plugins/system/fieldsandfilters/fieldsandfilters.php:180
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/components/com_content/views/article/view.html.php:163
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 0.44 ms** **Nach letzter Abfrage: 0.49 ms**
```
SELECT *,`id` AS `field_id`,`name` AS `field_name`,`alias` AS `field_alias`,`type` AS `field_type`

  FROM `tvojd_fieldsandfilters_fields`

  WHERE `state` IN (1) 
  AND `content_type_id` IN(1) 
  AND `mode` IN (-6,-7)

  ORDER BY `ordering` ASC
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_fieldsandfilters_fields ref state,content_type_id,mode state 1 const 9 Using where; **filesort wurde genutzt**
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/kextensions/buffer/buffer.php:284
JROOT/libraries/kextensions/buffer/values.php:56
JROOT/libraries/kextensions/buffer/buffer.php:318
JROOT/administrator/components/com_fieldsandfilters/helpers/fields/fields.php:125
JROOT/libraries/kextensions/buffer/core.php:401
JROOT/libraries/kextensions/buffer/core.php:482
JROOT/plugins/fieldsandfiltersextensions/content/content.php:595
JROOT/plugins/fieldsandfiltersextensions/content/content.php:595
JROOT/plugins/fieldsandfiltersextensions/content/content.php:520
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/plugins/system/fieldsandfilters/fieldsandfilters.php:180
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/components/com_content/views/article/view.html.php:163
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 0.51 ms** **Nach letzter Abfrage: 0.60 ms**
```
SELECT *

  FROM `tvojd_fieldsandfilters_elements`

  WHERE `state` IN (1) 
  AND `content_type_id` IN(1) 
  AND `item_id` IN (14)

  ORDER BY `ordering` ASC
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_fieldsandfilters_elements ref item_id,content_type_id,state item_id 4 const 1 Using where; **filesort wurde genutzt**
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/kextensions/buffer/buffer.php:284
JROOT/libraries/kextensions/buffer/values.php:56
JROOT/libraries/kextensions/buffer/buffer.php:318
JROOT/administrator/components/com_fieldsandfilters/helpers/elements/elements.php:104
JROOT/libraries/kextensions/buffer/core.php:401
JROOT/libraries/kextensions/buffer/core.php:482
JROOT/plugins/fieldsandfiltersextensions/content/content.php:606
JROOT/plugins/fieldsandfiltersextensions/content/content.php:606
JROOT/plugins/fieldsandfiltersextensions/content/content.php:520
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/plugins/system/fieldsandfilters/fieldsandfilters.php:180
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/components/com_content/views/article/view.html.php:163
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 0.89 ms** **Nach letzter Abfrage: 7.30 ms**
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM tvojd_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_attachments'
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_extensions ref element_clientid,element_folder_clientid,extension element_clientid 302 const 1 Using where
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/joomla/cache/controller/callback.php:158
JROOT/libraries/cms/component/helper.php:396
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:91
JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:138
JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:723
JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:693
JROOT/plugins/content/attachments/attachments.php:263
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/components/com_content/views/article/view.html.php:166
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 0.51 ms** **Nach letzter Abfrage: 0.38 ms**
```
SELECT created_by, catid

  FROM tvojd_content

  WHERE id = 14
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_content const PRIMARY PRIMARY 4 const 1
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:777
JROOT/plugins/content/attachments/attachments.php:263
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/components/com_content/views/article/view.html.php:166
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tvojd_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ref	PRIMARY,tag_idx,idx_access	tag_idx	1	const	7	Using where
1	SIMPLE	m	ref	idx_tag_type,idx_tag	idx_tag_type	4	HTO01FLYNJYV_2.t.id	11	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tvojd_content_types	range	idx_alias	idx_alias	767	NULL	2	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tvojd_extensions	ref	element_clientid,element_folder_clientid,extension	element_folder_clientid	302	const	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tvojd_fieldsandfilters_fields	ref	state,content_type_id,mode	state	1	const	9	Using where; filesort wurde genutzt

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tvojd_fieldsandfilters_elements	ref	item_id,content_type_id,state	item_id	4	const	1	Using where; filesort wurde genutzt

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tvojd_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where

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

**Abfragezeit: 2.89 ms** **Nach letzter Abfrage: 3.53 ms**

SELECT b.rules

  FROM tvojd_assets AS a

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

  WHERE (a.name = 'com_content.article.14')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	Using temporary; filesort wurde genutzt
1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	13	Using where

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

JROOT/libraries/joomla/access/access.php:250

JROOT/libraries/joomla/access/access.php:110

JROOT/libraries/joomla/user/user.php:373

JROOT/administrator/components/com_attachments/permissions.php:125

JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:852

JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:846

JROOT/plugins/content/attachments/attachments.php:269

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/components/com_content/views/article/view.html.php:166

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:224

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

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

**Abfragezeit: 2.77 ms** **Nach letzter Abfrage: 14.19 ms**

SELECT b.rules

  FROM tvojd_assets AS a

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

  WHERE (a.name = 'com_attachments')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	Using temporary; filesort wurde genutzt
1	SIMPLE	b	ALL	idx_lft_rgt	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	364

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

JROOT/libraries/joomla/access/access.php:250

JROOT/libraries/joomla/access/access.php:110

JROOT/libraries/joomla/user/user.php:373

JROOT/components/com_attachments/models/attachments.php:405

JROOT/components/com_attachments/models/attachments.php:514

JROOT/components/com_attachments/controllers/attachments.php:98

JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:895

JROOT/plugins/content/attachments/attachments.php:269

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/components/com_content/views/article/view.html.php:166

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:224

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

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

**Abfragezeit: 1.49 ms** **Nach letzter Abfrage: 10.63 ms**
```
SHOW FULL COLUMNS 
  FROM `tvojd_assets`
```
**Erklären**
**„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `tvojd_assets`**
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/joomla/table/table.php:229
JROOT/libraries/joomla/table/table.php:150
JROOT/libraries/joomla/table/asset.php:63
JROOT/libraries/joomla/table/table.php:294
JROOT/libraries/joomla/access/access.php:102
JROOT/libraries/joomla/user/user.php:373
JROOT/components/com_attachments/models/attachments.php:429
JROOT/components/com_attachments/models/attachments.php:514
JROOT/components/com_attachments/controllers/attachments.php:98
JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:895
JROOT/plugins/content/attachments/attachments.php:269
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/components/com_content/views/article/view.html.php:166
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 0.43 ms** **Nach letzter Abfrage: 7.39 ms**
```
SELECT id

  FROM tvojd_assets

  WHERE parent_id = 0
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_assets ref idx_parent_id idx_parent_id 4 const 1
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/joomla/table/nested.php:1227
JROOT/libraries/joomla/access/access.php:103
JROOT/libraries/joomla/user/user.php:373
JROOT/components/com_attachments/models/attachments.php:429
JROOT/components/com_attachments/models/attachments.php:514
JROOT/components/com_attachments/controllers/attachments.php:98
JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:895
JROOT/plugins/content/attachments/attachments.php:269
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/components/com_content/views/article/view.html.php:166
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 1.32 ms** **Nach letzter Abfrage: 0.20 ms**
```
SELECT b.rules

  FROM tvojd_assets AS a

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

  WHERE (a.id = 1)

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a const PRIMARY PRIMARY 4 const 1 Using temporary; **filesort wurde genutzt**
1 SIMPLE b range idx_lft_rgt idx_lft_rgt 4 NULL 3 Using where
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/joomla/access/access.php:250
JROOT/libraries/joomla/access/access.php:110
JROOT/libraries/joomla/user/user.php:373
JROOT/components/com_attachments/models/attachments.php:429
JROOT/components/com_attachments/models/attachments.php:514
JROOT/components/com_attachments/controllers/attachments.php:98
JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:895
JROOT/plugins/content/attachments/attachments.php:269
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/components/com_content/views/article/view.html.php:166
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tvojd_assets	ref	idx_parent_id	idx_parent_id	4	const	1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	Using temporary; filesort wurde genutzt
1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	3	Using where

**Abfragezeit: 1.40 ms** **Nach letzter Abfrage: 0.36 ms**

SELECT a.*, u.name as creator_name

  FROM tvojd_attachments AS a

  LEFT JOIN tvojd_users AS u 
  ON u.id = a.created_by

  WHERE a.parent_id=14 
  AND a.state = 1 
  AND a.parent_type='com_content' 
  AND a.parent_entity='article' 
  AND a.access IN (1,5)

  ORDER BY description

**Erklären**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	108	Using where; filesort wurde genutzt
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	HTO01FLYNJYV_2.a.created_by	1

**Profil (Profile)**

**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**

**Aufrufstapel (Call Stack)**

JROOT/components/com_attachments/models/attachments.php:436

JROOT/components/com_attachments/models/attachments.php:514

JROOT/components/com_attachments/controllers/attachments.php:98

JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:895

JROOT/plugins/content/attachments/attachments.php:269

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/components/com_content/views/article/view.html.php:166

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_content/controller.php:79

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_content/content.php:16

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:224

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

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

**Abfragezeit: 1.65 ms** **Nach letzter Abfrage: 10.70 ms**
```
SHOW FULL COLUMNS 
  FROM `tvojd_content`
```
**Erklären**
**„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `tvojd_content`**
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/joomla/table/table.php:229
JROOT/libraries/joomla/table/table.php:150
JROOT/libraries/legacy/table/content.php:31
JROOT/libraries/joomla/table/table.php:294
JROOT/components/com_content/models/article.php:263
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**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: 15.42 ms**
```
SELECT *

  FROM tvojd_content

  WHERE `id` = '14'
```
**Erklären**
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tvojd_content const PRIMARY PRIMARY 4 const 1
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/joomla/table/table.php:705
JROOT/components/com_content/models/article.php:264
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 0.94 ms** **Nach letzter Abfrage: 0.47 ms**
```
UPDATE tvojd_content

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

  WHERE `id` = '14'
```
**Erklären**
**„EXPLAIN“ unmöglich für Abfrage: UPDATE tvojd_content SET `hits` = (`hits` + 1) WHERE `id` = '14'**
**Profil (Profile)**
**Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**
**Aufrufstapel (Call Stack)**
JROOT/libraries/joomla/table/table.php:1215
JROOT/components/com_content/models/article.php:265
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/legacy/controller/legacy.php:685
JROOT/components/com_content/controller.php:79
JROOT/libraries/legacy/controller/legacy.php:722
JROOT/components/com_content/content.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:178
JROOT/libraries/cms/application/site.php:224
JROOT/libraries/cms/application/cms.php:245
JROOT/index.php:40
[**Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen**]
**Abfragezeit: 1.23 ms** **Nach letzter Abfrage: 8.73 ms**

Kontakt

Joomla!-Debug-Konsole

Sitzung

__default

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

72 ausgeführte Abfragen 81.8 ms

23 Dublikate gefunden!

Kontakt

**Joomla!-Debug-Konsole**

**Sitzung**

__default

**Profil zum Laufzeitverhalten**

**Zeit**

**Speicher**

**Speichernutzung**

**Datenbankabfragen**

**72 ausgeführte Abfragen** 81.8 ms

**23 Dublikate gefunden!**

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

72 ausgeführte Abfragen 81.8 ms

23 Dublikate gefunden!