Hi,

iam not able as a user to edit an article item even he has the right user group.
If someone is able to help me, i will mail the login and the site.

Thanks

Hi. Open the system debugger to see exactly which SQL query fails and what file is generating it.

Hi,

here is the debug content:
i changed the domain name to xxx
i send you the login too, maybe you can have a look at it...


xxx
1064Oops, you've encountered an error
It appears the page you were looking for doesn't exist. Sorry about that.
Startseite | Contact Webmaster
Joomla!-Debug-Konsole
Sitzung
__default
__jreviews
__wf
__findCount
Profil zum Laufzeitverhalten
Zeit
Speicher
Zeit: 0.0 ms / 0.0 ms Speicher: 1.200 MB / 1.20 MB Application: afterLoad
Zeit: 120.1 ms / 120.1 ms Speicher: 7.984 MB / 9.18 MB Application: RB-Framework-Before-Load
Zeit: 5.5 ms / 125.6 ms Speicher: 0.257 MB / 9.44 MB Application: RB-Framework-After-Load
Zeit: 70.1 ms / 195.7 ms Speicher: 6.795 MB / 16.24 MB Application: payplans-XiFramework-Before-Load
Zeit: 3.3 ms / 199.0 ms Speicher: 0.523 MB / 16.76 MB Application: payplans-XiFramework-After-Load
Zeit: 0.6 ms / 199.6 ms Speicher: 0.002 MB / 16.76 MB Application: payplans-Frontend-Before-Autoload
Zeit: 3.2 ms / 202.8 ms Speicher: 0.068 MB / 16.83 MB Application: payplans-Frontend-After-Autoload
Zeit: 0.5 ms / 203.3 ms Speicher: 0.019 MB / 16.85 MB Application: PayPlans-Backend-Before-autoload
Zeit: 0.6 ms / 203.9 ms Speicher: 0.010 MB / 16.86 MB Application: PayPlans-Backend-After-autoload
Zeit: 124.4 ms / 328.3 ms Speicher: 6.922 MB / 23.78 MB Application: PayPlans-onAfterInitialise-Before-Execute
Zeit: 23.4 ms / 351.7 ms Speicher: 1.869 MB / 25.65 MB Application: Payplans-App-Before-Load-Apps
Zeit: 39.1 ms / 390.8 ms Speicher: 2.826 MB / 28.48 MB Application: Payplans-App-After-Load-Apps
Zeit: 2.3 ms / 393.1 ms Speicher: 0.220 MB / 28.69 MB Application: PayPlans-onAfterInitialise-After-Execute
Zeit: 59.7 ms / 452.8 ms Speicher: 2.342 MB / 31.04 MB Application: afterInitialise
Zeit: 60.5 ms / 513.3 ms Speicher: 3.215 MB / 34.25 MB Application: PayPlans-onAfterRoute-Before-Execute
Zeit: 55.7 ms / 568.9 ms Speicher: 3.211 MB / 37.46 MB Application: PayPlans-onAfterRoute-After-Execute
Zeit: 1.2 ms / 570.1 ms Speicher: 0.000 MB / 37.46 MB Application: afterRoute

Datenbankabfragen gesamt: 76.5 ms
Speichernutzung
49.73 MB (52,148,800 Bytes)
Datenbankabfragen
109 ausgeführte Abfragen 76.5 ms

38 Dublikate gefunden!
2 Dublikate: #5 #6
2 Dublikate: #7 #14
2 Dublikate: #21 #22
2 Dublikate: #23 #24
2 Dublikate: #25 #26
2 Dublikate: #27 #28
2 Dublikate: #30 #31
3 Dublikate: #33 #103 #105
6 Dublikate: #35 #36 #37 #38 #98 #102
2 Dublikate: #57 #58
3 Dublikate: #67 #68 #69
2 Dublikate: #73 #74
2 Dublikate: #75 #76
2 Dublikate: #77 #78
2 Dublikate: #79 #80
2 Dublikate: #81 #82

Abfragezeit: 1.26 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 3.911 MB Zeilen zurückgegeben: 1

SELECT `data`

FROM `nbd3r_session`

WHERE `session_id` = '9rp3goaojijnm8t39rkmk5iqe5'

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_session const PRIMARY PRIMARY 602 const 1
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
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.20 ms Nach letzter Abfrage: 1.31 ms Abfragespeichernutzung: 0.008 MB Speichernutzung vor Abfrage: 4.078 MB

DELETE

FROM `nbd3r_session`

WHERE `time` < '1411391981'

Erklären
„EXPLAIN“ unmöglich für Abfrage: DELETE FROM `nbd3r_session` WHERE `time` < '1411391981'
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: 2.20 ms Nach letzter Abfrage: 24.33 ms Abfragespeichernutzung: 0.010 MB Speichernutzung vor Abfrage: 4.639 MB Zeilen zurückgegeben: 200

SELECT folder AS type, element AS name, params

FROM nbd3r_extensions

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

ORDER BY ordering

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_extensions ref extension extension 62 const 313 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.11 ms Nach letzter Abfrage: 66.41 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 8.777 MB Zeilen zurückgegeben: 0

SELECT `query`

FROM `nbd3r_admintools_wafexceptions`

WHERE (`option` IS NULL OR `option` = '')
AND (`view` IS NULL OR `view` = '')

GROUP BY `query`

ORDER BY `query` ASC

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_admintools_wafexceptions ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 Using where; Using temporary; filesort wurde genutzt
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
JROOT/plugins/system/admintools/admintools/pro.php:4266
JROOT/plugins/system/admintools/admintools/pro.php:62
JROOT/plugins/system/admintools/admintools/main.php:44
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:576
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.46 ms Nach letzter Abfrage: 13.50 ms Abfragespeichernutzung: 0.012 MB Speichernutzung vor Abfrage: 9.843 MB Zeilen zurückgegeben: 1
Doppelte Abfragen: #6

SELECT `enabled`

FROM `nbd3r_extensions`

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

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_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/plugins/system/backuponupdate/backuponupdate.php:61
JROOT/libraries/cms/plugin/helper.php:232
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:576
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.11 ms Nach letzter Abfrage: 38.27 ms Abfragespeichernutzung: 0.012 MB Speichernutzung vor Abfrage: 14.055 MB Zeilen zurückgegeben: 1
Doppelte Abfragen: #5

SELECT `enabled`

FROM `nbd3r_extensions`

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

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_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/plugins/system/srp/srp.php:47
JROOT/libraries/cms/plugin/helper.php:232
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:576
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: 2.48 ms Nach letzter Abfrage: 17.55 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 15.836 MB Zeilen zurückgegeben: 407
Doppelte Abfragen: #14

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/jsnframework/libraries/joomlashine/config/helper.php:68
JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:98
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:576
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.09 ms Nach letzter Abfrage: 0.77 ms Abfragespeichernutzung: 0.013 MB Speichernutzung vor Abfrage: 15.930 MB Zeilen zurückgegeben: 2

SELECT name,value

FROM nbd3r_jsn_poweradmin_config

WHERE 1

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_jsn_poweradmin_config ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:81
JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:98
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:576
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.33 ms Nach letzter Abfrage: 1.92 ms Abfragespeichernutzung: 0.013 MB Speichernutzung vor Abfrage: 15.928 MB Zeilen zurückgegeben: 1

SELECT COUNT(*)

FROM nbd3r_extensions

WHERE element="jsnadminbar"

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_extensions ref element_clientid,element_folder_clientid element_clientid 302 const 1 Using where; Using index
Profil (Profile)
Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)
Aufrufstapel (Call Stack)
JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:799
JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:104
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/libraries/cms/application/cms.php:576
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.14 ms Nach letzter Abfrage: 87.20 ms Abfragespeichernutzung: 0.015 MB Speichernutzung vor Abfrage: 20.558 MB Zeilen zurückgegeben: 0

SELECT *

FROM `nbd3r_admintools_ipautoban`

WHERE `ip` = '178.83.7.167'

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/admintools/admintools/pro.php:3162
JROOT/plugins/system/admintools/admintools/pro.php:127
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.10 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.016 MB Speichernutzung vor Abfrage: 20.572 MB Zeilen zurückgegeben: 1

SELECT `value`

FROM `nbd3r_admintools_storage`

WHERE `key` = 'cparams'

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_admintools_storage const PRIMARY PRIMARY 767 const 1
Profil (Profile)
Status Duration
starting 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
checking query cache for query 0.0 ms
checking privileges on cached 0.0 ms
checking permissions 0.0 ms
sending cached result to clien 0.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/administrator/components/com_admintools/models/storage.php:97
JROOT/administrator/components/com_admintools/models/storage.php:49
JROOT/plugins/system/admintools/admintools/pro.php:130
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.09 ms Nach letzter Abfrage: 1.41 ms Abfragespeichernutzung: 0.015 MB Speichernutzung vor Abfrage: 20.611 MB Zeilen zurückgegeben: 0

SELECT `source`,`keepurlparams`

FROM `nbd3r_admintools_redirects`

WHERE ((`dest` = 'gesundheits-themen/gesundheit-allgemein/krankheiten/item/edit/312') OR (`dest` = 'gesundheits-themen/gesundheit-allgemein/krankheiten/item/edit/312?tmpl=component'))
AND `published` = '1'

ORDER BY `ordering` DESC
LIMIT 0, 1

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_admintools_redirects ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 Using where; filesort wurde genutzt
Profil (Profile)
Status Duration
starting 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
checking query cache for query 0.0 ms
checking privileges on cached 0.0 ms
checking permissions 0.0 ms
sending cached result to clien 0.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/plugins/system/admintools/admintools/pro.php:1304
JROOT/plugins/system/admintools/admintools/pro.php:351
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.18 ms Nach letzter Abfrage: 20.38 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 21.735 MB Zeilen zurückgegeben: 164

SELECT setting,value
FROM nbd3r_jfbconnect_config

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_jfbconnect_config ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 122
Profil (Profile)
Status Duration
starting 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
checking query cache for query 0.0 ms
checking privileges on cached 0.0 ms
checking permissions 0.0 ms
sending cached result to clien 0.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/administrator/components/com_jfbconnect/models/config.php:271
JROOT/administrator/components/com_jfbconnect/models/config.php:282
JROOT/administrator/components/com_jfbconnect/models/config.php:317
JROOT/components/com_jfbconnect/libraries/provider.php:38
JROOT/components/com_jfbconnect/libraries/provider/facebook.php:25
JROOT/components/com_jfbconnect/libraries/factory.php:60
JROOT/libraries/sourcecoast/openGraphPlugin.php:41
JROOT/libraries/cms/plugin/helper.php:257
JROOT/libraries/cms/plugin/helper.php:172
JROOT/plugins/system/jfbcsystem/jfbcsystem.php:55
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: 2.52 ms Nach letzter Abfrage: 60.21 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 26.325 MB Zeilen zurückgegeben: 407
Doppelte Abfragen: #7

SHOW TABLES

Erklären
„EXPLAIN“ unmöglich für Abfrage: SHOW TABLES
Profil (Profile)
Status Duration
starting 0.0 ms
checking permissions 0.0 ms
Opening tables 0.1 ms
System lock 0.0 ms
init 0.0 ms
optimizing 0.0 ms
statistics 0.0 ms
preparing 0.0 ms
executing 0.0 ms
checking permissions 2.0 ms
Sending data 0.1 ms
end 0.0 ms
query end 0.0 ms
closing tables 0.0 ms
removing tmp table 0.0 ms
closing tables 0.0 ms
freeing items 0.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/components/com_payplans/xiframework/base/helper/table.php:33
JROOT/components/com_payplans/xiframework/base/table.php:108
JROOT/components/com_payplans/xiframework/base/abstract/factory.php:38
JROOT/components/com_payplans/xiframework/base/abstract/model.php:219
JROOT/components/com_payplans/xiframework/base/model.php:285
JROOT/components/com_payplans/xiframework/base/abstract/model.php:117
JROOT/components/com_payplans/xiframework/base/model.php:34
JROOT/components/com_payplans/helpers/app.php:145
JROOT/components/com_payplans/helpers/app.php:180
JROOT/components/com_payplans/helpers/event.php:80
JROOT/plugins/system/payplans/payplans.php:193
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.69 ms Nach letzter Abfrage: 1.62 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 26.426 MB Zeilen zurückgegeben: 8

SHOW FULL COLUMNS
FROM `nbd3r_payplans_app`

Erklären
„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `nbd3r_payplans_app`
Profil (Profile)
Status Duration
starting 0.0 ms
checking permissions 0.0 ms
Opening tables 0.2 ms
System lock 0.0 ms
init 0.0 ms
optimizing 0.0 ms
statistics 0.0 ms
preparing 0.0 ms
executing 0.0 ms
Opening tables 0.0 ms
checking permissions 0.0 ms
checking permissions 0.0 ms
checking permissions 0.0 ms
checking permissions 0.0 ms
checking permissions 0.0 ms
checking permissions 0.0 ms
checking permissions 0.0 ms
checking permissions 0.0 ms
Sending data 0.1 ms
end 0.0 ms
query end 0.0 ms
closing tables 0.0 ms
removing tmp table 0.1 ms
closing tables 0.0 ms
freeing items 0.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/components/com_payplans/xiframework/base/table.php:172
JROOT/libraries/joomla/table/table.php:150
JROOT/components/com_payplans/xiframework/base/table.php:115
JROOT/components/com_payplans/xiframework/base/abstract/factory.php:38
JROOT/components/com_payplans/xiframework/base/abstract/model.php:219
JROOT/components/com_payplans/xiframework/base/model.php:285
JROOT/components/com_payplans/xiframework/base/abstract/model.php:117
JROOT/components/com_payplans/xiframework/base/model.php:34
JROOT/components/com_payplans/helpers/app.php:145
JROOT/components/com_payplans/helpers/app.php:180
JROOT/components/com_payplans/helpers/event.php:80
JROOT/plugins/system/payplans/payplans.php:193
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.12 ms Nach letzter Abfrage: 2.11 ms Abfragespeichernutzung: 0.018 MB Speichernutzung vor Abfrage: 26.516 MB Zeilen zurückgegeben: 19

SELECT tbl.*

FROM nbd3r_payplans_app AS tbl

WHERE `tbl`.`published` ='1'

ORDER BY ordering ASC

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tbl ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 20 Using where; filesort wurde genutzt
Profil (Profile)
Status Duration
starting 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
checking query cache for query 0.0 ms
checking privileges on cached 0.0 ms
checking permissions 0.0 ms
sending cached result to clien 0.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/components/com_payplans/xiframework/base/model.php:78
JROOT/components/com_payplans/helpers/app.php:145
JROOT/components/com_payplans/helpers/app.php:180
JROOT/components/com_payplans/helpers/event.php:80
JROOT/plugins/system/payplans/payplans.php:193
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.57 ms Nach letzter Abfrage: 8.44 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 27.285 MB Zeilen zurückgegeben: 3

SHOW FULL COLUMNS
FROM `nbd3r_payplans_planapp`

Erklären
„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `nbd3r_payplans_planapp`
Profil (Profile)
Status Duration
starting 0.0 ms
checking permissions 0.0 ms
Opening tables 0.2 ms
System lock 0.0 ms
init 0.0 ms
optimizing 0.0 ms
statistics 0.0 ms
preparing 0.0 ms
executing 0.0 ms
Opening tables 0.0 ms
checking permissions 0.0 ms
checking permissions 0.0 ms
checking permissions 0.0 ms
Sending data 0.0 ms
end 0.0 ms
query end 0.0 ms
closing tables 0.0 ms
removing tmp table 0.1 ms
closing tables 0.0 ms
freeing items 0.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/components/com_payplans/xiframework/base/table.php:172
JROOT/libraries/joomla/table/table.php:150
JROOT/components/com_payplans/xiframework/base/table.php:115
JROOT/components/com_payplans/xiframework/base/abstract/factory.php:38
JROOT/components/com_payplans/xiframework/base/abstract/model.php:219
JROOT/components/com_payplans/xiframework/base/model.php:285
JROOT/components/com_payplans/xiframework/base/abstract/model.php:117
JROOT/components/com_payplans/libraries/model/planapp.php:71
JROOT/components/com_payplans/libraries/lib/app.php:181
JROOT/components/com_payplans/xiframework/base/lib.php:290
JROOT/components/com_payplans/libraries/lib/app.php:191
JROOT/components/com_payplans/xiframework/base/lib.php:143
JROOT/components/com_payplans/libraries/lib/app.php:56
JROOT/components/com_payplans/helpers/app.php:152
JROOT/components/com_payplans/helpers/app.php:180
JROOT/components/com_payplans/helpers/event.php:80
JROOT/plugins/system/payplans/payplans.php:193
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.11 ms Nach letzter Abfrage: 0.62 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 27.331 MB Zeilen zurückgegeben: 60

SELECT app_id,plan_id

FROM nbd3r_payplans_planapp AS tbl

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tbl ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 60
Profil (Profile)
Status Duration
starting 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
checking query cache for query 0.0 ms
checking privileges on cached 0.0 ms
checking permissions 0.0 ms
sending cached result to clien 0.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/components/com_payplans/libraries/model/planapp.php:30
JROOT/components/com_payplans/libraries/model/planapp.php:71
JROOT/components/com_payplans/libraries/lib/app.php:181
JROOT/components/com_payplans/xiframework/base/lib.php:290
JROOT/components/com_payplans/libraries/lib/app.php:191
JROOT/components/com_payplans/xiframework/base/lib.php:143
JROOT/components/com_payplans/libraries/lib/app.php:56
JROOT/components/com_payplans/helpers/app.php:152
JROOT/components/com_payplans/helpers/app.php:180
JROOT/components/com_payplans/helpers/event.php:80
JROOT/plugins/system/payplans/payplans.php:193
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.09 ms Nach letzter Abfrage: 20.93 ms Abfragespeichernutzung: 0.016 MB Speichernutzung vor Abfrage: 29.587 MB Zeilen zurückgegeben: 2

SELECT b.id

FROM nbd3r_user_usergroup_map AS map

LEFT JOIN nbd3r_usergroups AS a
ON a.id = map.group_id

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

WHERE map.user_id = 1008

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE map ref PRIMARY PRIMARY 4 const 1 Using index
1 SIMPLE a eq_ref PRIMARY PRIMARY 4 dennisth_xxx.map.group_id 1
1 SIMPLE b index idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 8 NULL 8 Using index
Profil (Profile)
Status Duration
starting 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 1.0 ms
checking query cache for query 0.0 ms
checking privileges on cached 0.0 ms
checking permissions 0.0 ms
checking permissions 0.0 ms
checking permissions 0.0 ms
sending cached result to clien 0.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/libraries/joomla/access/access.php:336
JROOT/plugins/system/easyfrontendseo/easyfrontendseo.php:871
JROOT/plugins/system/easyfrontendseo/easyfrontendseo.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: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: 3.83 ms Nach letzter Abfrage: 1.30 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 29.708 MB Zeilen zurückgegeben: 85

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 nbd3r_menu AS m

LEFT JOIN nbd3r_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 191 Using where; filesort wurde genutzt
1 SIMPLE e eq_ref PRIMARY PRIMARY 4 dennisth_xxx.m.component_id 1
Profil (Profile)
Status Duration
starting 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
checking query cache for query 0.1 ms
checking permissions 0.0 ms
checking permissions 0.0 ms
Opening tables 0.0 ms
System lock 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.1 ms
init 0.0 ms
optimizing 0.0 ms
statistics 0.1 ms
preparing 0.0 ms
executing 0.0 ms
Sorting result 0.8 ms
Sending data 0.5 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.8 ms
Sending data 0.3 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
Sending data 0.4 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
Sending data 0.1 ms
end 0.0 ms
query end 0.0 ms
closing tables 0.0 ms
freeing items 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
freeing items 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
freeing items 0.0 ms
storing result in query cache 0.6 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/libraries/cms/menu/site.php:68
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/plugins/system/jreviews_sef/jreviews_router.php:901
JROOT/libraries/cms/router/router.php:511
JROOT/libraries/cms/router/site.php:530
JROOT/libraries/cms/router/router.php:493
JROOT/libraries/cms/router/router.php:181
JROOT/libraries/cms/router/site.php:90
JROOT/plugins/system/easyfrontendseo/easyfrontendseo.php:837
JROOT/plugins/system/easyfrontendseo/easyfrontendseo.php:63
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.14 ms Nach letzter Abfrage: 9.75 ms Abfragespeichernutzung: 0.015 MB Speichernutzung vor Abfrage: 30.706 MB Zeilen zurückgegeben: 1
Doppelte Abfragen: #22

select `rank`
from nbd3r_mioseo_settings

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_mioseo_settings ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1
Profil (Profile)
Status Duration
starting 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
checking query cache for query 0.0 ms
checking privileges on cached 0.0 ms
checking permissions 0.0 ms
sending cached result to clien 0.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/components/com_mioseo/helpers/rank_google.php:22
JROOT/plugins/system/mioseo/mioseo.php:51
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.06 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.015 MB Speichernutzung vor Abfrage: 30.721 MB Zeilen zurückgegeben: 1
Doppelte Abfragen: #21

select `rank`
from nbd3r_mioseo_settings

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_mioseo_settings ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1
Profil (Profile)
Status Duration
starting 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
checking query cache for query 0.0 ms
checking privileges on cached 0.0 ms
checking permissions 0.0 ms
sending cached result to clien 0.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/components/com_mioseo/helpers/rank_google.php:23
JROOT/plugins/system/mioseo/mioseo.php:51
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.06 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.015 MB Speichernutzung vor Abfrage: 30.737 MB Zeilen zurückgegeben: 0
Doppelte Abfragen: #24

select *
from nbd3r_mioseo_rank
where `date_checked` < '2014-09-22'
ORDER BY `date_checked` asc
LIMIT 0,5

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_mioseo_rank ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2 Using where; filesort wurde genutzt
Profil (Profile)
Status Duration
starting 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
checking query cache for query 0.0 ms
checking privileges on cached 0.0 ms
checking permissions 0.0 ms
sending cached result to clien 0.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/components/com_mioseo/helpers/rank_google.php:42
JROOT/plugins/system/mioseo/mioseo.php:51
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.05 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.015 MB Speichernutzung vor Abfrage: 30.752 MB Zeilen zurückgegeben: 0
Doppelte Abfragen: #23

select *
from nbd3r_mioseo_rank
where `date_checked` < '2014-09-22'
ORDER BY `date_checked` asc
LIMIT 0,5

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_mioseo_rank ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2 Using where; filesort wurde genutzt
Profil (Profile)
Status Duration
starting 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
checking query cache for query 0.0 ms
checking privileges on cached 0.0 ms
checking permissions 0.0 ms
sending cached result to clien 0.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/components/com_mioseo/helpers/rank_google.php:43
JROOT/plugins/system/mioseo/mioseo.php:51
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.46 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.015 MB Speichernutzung vor Abfrage: 30.766 MB Zeilen zurückgegeben: 1
Doppelte Abfragen: #26

select *
from nbd3r_mioseo_statistics
where `date_checked` = '2014-09-22'

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_mioseo_statistics ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 76 Using where
Profil (Profile)
Status Duration
starting 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
checking query cache for query 0.1 ms
checking permissions 0.0 ms
Opening tables 0.0 ms
System lock 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
init 0.0 ms
optimizing 0.0 ms
statistics 0.0 ms
preparing 0.0 ms
executing 0.0 ms
Sending data 0.1 ms
end 0.0 ms
query end 0.0 ms
closing tables 0.0 ms
freeing items 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
freeing items 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
freeing items 0.0 ms
storing result in query cache 0.6 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/components/com_mioseo/helpers/statistics.php:24
JROOT/plugins/system/mioseo/mioseo.php:52
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.56 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.015 MB Speichernutzung vor Abfrage: 30.781 MB Zeilen zurückgegeben: 1
Doppelte Abfragen: #25

select *
from nbd3r_mioseo_statistics
where `date_checked` = '2014-09-22'

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_mioseo_statistics ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 76 Using where
Profil (Profile)
Status Duration
starting 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
checking query cache for query 0.0 ms
checking privileges on cached 0.0 ms
checking permissions 0.0 ms
sending cached result to clien 0.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/components/com_mioseo/helpers/statistics.php:25
JROOT/plugins/system/mioseo/mioseo.php:52
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.22 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.015 MB Speichernutzung vor Abfrage: 30.795 MB Zeilen zurückgegeben: 1
Doppelte Abfragen: #28

select count(*)
from nbd3r_mioseo_statistics
where `date_checked` = '2014-09-22'

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_mioseo_statistics ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 76 Using where
Profil (Profile)
Status Duration
starting 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
checking query cache for query 0.0 ms
checking permissions 0.0 ms
Opening tables 0.0 ms
System lock 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
init 0.0 ms
optimizing 0.0 ms
statistics 0.0 ms
preparing 0.0 ms
executing 0.0 ms
Sending data 0.0 ms
end 0.0 ms
query end 0.0 ms
closing tables 0.0 ms
freeing items 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
freeing items 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
freeing items 0.0 ms
storing result in query cache 1.4 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/components/com_mioseo/helpers/statistics.php:434
JROOT/plugins/system/mioseo/mioseo.php:53
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.40 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.015 MB Speichernutzung vor Abfrage: 30.810 MB Zeilen zurückgegeben: 1
Doppelte Abfragen: #27

select count(*)
from nbd3r_mioseo_statistics
where `date_checked` = '2014-09-22'

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_mioseo_statistics ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 76 Using where
Profil (Profile)
Status Duration
starting 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
checking query cache for query 0.0 ms
checking privileges on cached 0.0 ms
checking permissions 0.0 ms
sending cached result to clien 0.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/components/com_mioseo/helpers/statistics.php:435
JROOT/plugins/system/mioseo/mioseo.php:53
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.72 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 30.825 MB

update nbd3r_mioseo_statistics
set `nr_links`=(`nr_links`+1)
where `date_checked` = '2014-09-22'

Erklären
„EXPLAIN“ unmöglich für Abfrage: update nbd3r_mioseo_statistics set `nr_links`=(`nr_links`+1) where `date_checked` = '2014-09-22'
Profil (Profile)
Status Duration
starting 0.0 ms
checking permissions 0.0 ms
Opening tables 0.0 ms
System lock 0.0 ms
init 0.0 ms
Updating 0.1 ms
end 0.0 ms
Waiting for query cache lock 0.0 ms
end 1.4 ms
query end 0.1 ms
closing tables 0.0 ms
freeing items 0.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/components/com_mioseo/helpers/statistics.php:446
JROOT/plugins/system/mioseo/mioseo.php:53
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: 6.40 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.015 MB Speichernutzung vor Abfrage: 30.840 MB Zeilen zurückgegeben: 1
Doppelte Abfragen: #31

select count(*)
from nbd3r_mioseo_url_accessed
where `link` = 'www.xxx.org/gesundheits-themen/gesundheit-allgemein/krankheiten/item/edit/312?tmpl=component'

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_mioseo_url_accessed ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 5848 Using where
Profil (Profile)
Status Duration
starting 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
checking query cache for query 0.0 ms
checking permissions 0.0 ms
Opening tables 0.0 ms
System lock 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
init 0.0 ms
optimizing 0.0 ms
statistics 0.0 ms
preparing 0.0 ms
executing 0.0 ms
Sending data 6.1 ms
end 0.0 ms
query end 0.0 ms
closing tables 0.0 ms
freeing items 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
freeing items 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
freeing items 0.0 ms
storing result in query cache 3.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/components/com_mioseo/helpers/statistics.php:449
JROOT/plugins/system/mioseo/mioseo.php:53
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: 2.81 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.015 MB Speichernutzung vor Abfrage: 30.855 MB Zeilen zurückgegeben: 1
Doppelte Abfragen: #30

select count(*)
from nbd3r_mioseo_url_accessed
where `link` = 'www.xxx.org/gesundheits-themen/gesundheit-allgemein/krankheiten/item/edit/312?tmpl=component'

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_mioseo_url_accessed ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 5848 Using where
Profil (Profile)
Status Duration
starting 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
checking query cache for query 0.0 ms
checking privileges on cached 0.0 ms
checking permissions 0.0 ms
sending cached result to clien 0.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/components/com_mioseo/helpers/statistics.php:450
JROOT/plugins/system/mioseo/mioseo.php:53
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: 8.54 ms Nach letzter Abfrage: 0.27 ms Abfragespeichernutzung: 0.014 MB Speichernutzung vor Abfrage: 30.870 MB

update nbd3r_mioseo_url_accessed
set `hits`=(`hits`+1)
where `link` = 'www.xxx.org/gesundheits-themen/gesundheit-allgemein/krankheiten/item/edit/312?tmpl=component'

Erklären
„EXPLAIN“ unmöglich für Abfrage: update nbd3r_mioseo_url_accessed set `hits`=(`hits`+1) where `link` = 'www.xxx.org/gesundheits-themen/gesundheit-allgemein/krankheiten/item/edit/312?tmpl=component'
Profil (Profile)
Status Duration
starting 0.0 ms
checking permissions 0.0 ms
Opening tables 0.0 ms
System lock 0.0 ms
init 0.0 ms
Updating 6.9 ms
end 0.0 ms
Waiting for query cache lock 0.0 ms
end 1.4 ms
query end 0.1 ms
closing tables 0.0 ms
freeing items 0.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/components/com_mioseo/helpers/statistics.php:461
JROOT/plugins/system/mioseo/mioseo.php:53
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.15 ms Nach letzter Abfrage: 14.38 ms Abfragespeichernutzung: 0.016 MB Speichernutzung vor Abfrage: 31.041 MB Zeilen zurückgegeben: 1
Doppelte Abfragen: #103 #105

select id, title, alias
from nbd3r_jumi
where published = 1

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_jumi ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 2 Using where
Profil (Profile)
Status Duration
starting 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
checking query cache for query 0.0 ms
checking privileges on cached 0.0 ms
checking permissions 0.0 ms
sending cached result to clien 0.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/plugins/system/jumirouter/jumirouter.php:57
JROOT/libraries/cms/router/router.php:511
JROOT/libraries/cms/router/site.php:530
JROOT/libraries/cms/router/router.php:493
JROOT/libraries/cms/router/router.php:181
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: 6.00 ms Nach letzter Abfrage: 5.88 ms Abfragespeichernutzung: 0.016 MB Speichernutzung vor Abfrage: 31.567 MB

UPDATE `nbd3r_extensions`

SET `params` = '{\"mediaversion\":\"f0becf18561457e7e5be4d803f7b5acd\"}'

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

Erklären
„EXPLAIN“ unmöglich für Abfrage: UPDATE `nbd3r_extensions` SET `params` = '{\"mediaversion\":\"f0becf18561457e7e5be4d803f7b5acd\"}' WHERE `type` = 'library' AND `element` = 'joomla'
Profil (Profile)
Status Duration
starting 0.1 ms
checking permissions 0.0 ms
Opening tables 0.0 ms
System lock 0.0 ms
init 0.1 ms
Updating 0.1 ms
end 0.0 ms
Waiting for query cache lock 0.0 ms
end 5.5 ms
query end 0.1 ms
closing tables 0.0 ms
freeing items 0.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
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/azrul.system/azrul.system.php:90
JROOT/libraries/joomla/event/dispatcher.php:167
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.09 ms Nach letzter Abfrage: 2.63 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 31.915 MB Zeilen zurückgegeben: 0
Doppelte Abfragen: #36 #37 #38 #98 #102

SELECT j_user_id

FROM nbd3r_jfbconnect_user_map

WHERE `provider`='facebook'
AND `provider_user_id`='0'

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_jfbconnect_user_map ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 6 Using where
Profil (Profile)
Status Duration
starting 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
checking query cache for query 0.0 ms
checking privileges on cached 0.0 ms
checking permissions 0.0 ms
sending cached result to clien 0.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/administrator/components/com_jfbconnect/models/usermap.php:355
JROOT/components/com_jfbconnect/libraries/provider.php:258
JROOT/components/com_jfbconnect/libraries/provider/facebook.php:169
JROOT/libraries/sourcecoast/openGraphPlugin.php:69
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/plugins/system/jfbcsystem/jfbcsystem.php:72
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.08 ms Nach letzter Abfrage: 0.35 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 31.938 MB Zeilen zurückgegeben: 0
Doppelte Abfragen: #35 #37 #38 #98 #102

SELECT j_user_id

FROM nbd3r_jfbconnect_user_map

WHERE `provider`='facebook'
AND `provider_user_id`='0'

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_jfbconnect_user_map ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 6 Using where
Profil (Profile)
Status Duration
starting 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
checking query cache for query 0.0 ms
checking privileges on cached 0.0 ms
checking permissions 0.0 ms
sending cached result to clien 0.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/administrator/components/com_jfbconnect/models/usermap.php:355
JROOT/components/com_jfbconnect/libraries/provider.php:258
JROOT/components/com_jfbconnect/libraries/provider/facebook.php:169
JROOT/libraries/sourcecoast/openGraphPlugin.php:69
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/plugins/system/jfbcsystem/jfbcsystem.php:72
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.05 ms Nach letzter Abfrage: 0.32 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 31.960 MB Zeilen zurückgegeben: 0
Doppelte Abfragen: #35 #36 #38 #98 #102

SELECT j_user_id

FROM nbd3r_jfbconnect_user_map

WHERE `provider`='facebook'
AND `provider_user_id`='0'

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_jfbconnect_user_map ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 6 Using where
Profil (Profile)
Status Duration
starting 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
checking query cache for query 0.0 ms
checking privileges on cached 0.0 ms
checking permissions 0.0 ms
sending cached result to clien 0.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/administrator/components/com_jfbconnect/models/usermap.php:355
JROOT/components/com_jfbconnect/libraries/provider.php:258
JROOT/components/com_jfbconnect/libraries/provider/facebook.php:169
JROOT/libraries/sourcecoast/openGraphPlugin.php:69
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/plugins/system/jfbcsystem/jfbcsystem.php:72
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.09 ms Nach letzter Abfrage: 0.31 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 31.983 MB Zeilen zurückgegeben: 0
Doppelte Abfragen: #35 #36 #37 #98 #102

SELECT j_user_id

FROM nbd3r_jfbconnect_user_map

WHERE `provider`='facebook'
AND `provider_user_id`='0'

Erklären
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE nbd3r_jfbconnect_user_map ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 6 Using where
Profil (Profile)
Status Duration
starting 0.0 ms
Waiting for query cache lock 0.0 ms
Waiting on query cache mutex 0.0 ms
checking query cache for query 0.0 ms
checking privileges on cached 0.0 ms
checking permissions 0.0 ms
sending cached result to clien 0.0 ms
logging slow query 0.0 ms
cleaning up 0.0 ms
Aufrufstapel (Call Stack)
JROOT/administrator/components/com_jfbconnect/models/usermap.php:355
JROOT/components/com_jfbconnect/libraries/provider.php:258
JROOT/components/com_jfbconnect/libraries/provider/facebook.php:169
JROOT/libraries/sourcecoast/openGraphPlugin.php:69
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/plugins/system/jfbcsystem/jfbcsystem.php:72
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.04 ms Nach letzter Abfrage: 46.01 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 34.569 MB Zeilen zurückgegeben: 8

SHOW FULL COLUMNS
FROM `nbd3r_payplans_user`

Erklären
„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `nbd3r_payplans_user`
Profil (Profile)
Status Duration
starting 0.0 ms
checking permissions 0.0 ms
Opening tables 0.2 ms
System lock 0.0 ms
init 0.0 ms
optimizing 0.0 ms
statistics 0.0 ms
preparing 0.0 ms
executing 0.0 ms
Opening tables 0.3 ms
checking pe

As you see K2 is not involved in this. This looks like an issue of payplans. I suggest to ask it's developers for help.

I thought too, but then i disabled payplans to see if it works and therefore its not working?!

Which error are you getting?

In the meantime i found out, that jfbconnect causes the issue.
If i disable the system plugin its working.
Now the support of jfbc looks on it, thanks.

You 're welcome Dennis,

Please post your findings so other users might benefit as well.

It was the jfbconnect plugin. The devs from jfbc are working on a solution.