MyBB.de Forum

Normale Version: Bedankungen zählen
Du siehst gerade eine vereinfachte Darstellung unserer Inhalte. Normale Ansicht mit richtiger Formatierung.
Seiten: 1 2
Vielleicht kannst du damit was anfangen:

http://www.pspking.de/forum/showthread.p...53&debug=1

Dave

Nein, nur Administratoren haben darauf Zugriff.
Zitat:MyBB Debug Information
Page Generation
Page Generation Statistics
Page Generation Time: 2.31968998909 seconds No. MySQL Queries: 21
PHP Processing Time: 2.1275938 seconds (91.72%) MySQL Processing Time: 0.1920962 seconds (8.28%)
Extensions Used: mysql, xml Global.php Processing Time: 1.7613211 seconds
PHP Version: 4.4.7 Server Load:
GZip Encoding Status: Enabled No. Templates Used: 70 (74 Cached / 2 Manually Loaded)
Memory Usage: 4.42 MB (4632584 bytes) Memory Limit: 16M
Database Queries (21 Total)
#1 - Select Query
SELECT title,cache FROM mybb_datacache
table type possible_keys key key_len ref rows Extra
mybb_datacache ALL 19
Query Time: 0.0060341

#2 - Select Query
SELECT * FROM mybb_sessions WHERE sid='6c3b6f45fd46a9ddc271650720064f81' AND ip='80.136.233.165' LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_sessions const PRIMARY PRIMARY 32 const 1
Query Time: 0.0021610

#3 - Select Query
SELECT u.*, f.*, b.dateline AS bandate, b.lifted AS banlifted, b.oldgroup AS banoldgroup, b.olddisplaygroup as banolddisplaygroup, b.oldadditionalgroups as banoldadditionalgroups FROM mybb_users u LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) LEFT JOIN mybb_banned b ON (b.uid=u.uid) WHERE u.uid='1' LIMIT 1
table type possible_keys key key_len ref rows Extra
u const PRIMARY PRIMARY 4 const 1
f const PRIMARY PRIMARY 4 const 1
b ref uid uid 4 const 1
Query Time: 0.0030839

#4 - Write Query
UPDATE mybb_sessions SET uid='1', time='1199981197', location='/forum/showthread.php?tid=64&pid=253&debug=1', useragent='Mozilla/5.0 (Windows; U; Windows NT 5.1; de-DE; rv:1.7.8) Gecko/20050511 Firefox/1.0.4', location1='0', location2='64', nopermission='0' WHERE sid='6c3b6f45fd46a9ddc271650720064f81' LIMIT 1
Query Time: 0.0010540

#5 - Select Query
SELECT f.style, f.overridestyle FROM mybb_forums f, mybb_posts p WHERE f.fid=p.fid AND p.pid='253' LIMIT 1
table type possible_keys key key_len ref rows Extra
p const PRIMARY PRIMARY 4 const 1
f const PRIMARY PRIMARY 2 const 1
Query Time: 0.0013940

#6 - Select Query
SELECT name, tid, themebits, csscached FROM mybb_themes WHERE def='1' LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_themes ALL 2 Using where
Query Time: 0.0011449

#7 - Select Query
SELECT title,template FROM mybb_templates WHERE title IN ('' ,'showthread' ,'postbit' ,'postbit_author_user' ,'postbit_author_guest' ,'showthread_newthread' ,'showthread_newreply' ,'showthread_newreply_closed' ,'postbit_sig' ,'showthread_newpoll' ,'postbit_avatar' ,'postbit_profile' ,'postbit_find' ,'postbit_pm' ,'postbit_www' ,'postbit_email' ,'postbit_edit' ,'postbit_quote' ,'postbit_report' ,'postbit_signature' ,'postbit_online' ,'postbit_offline' ,'postbit_away' ,'showthread_ratingdisplay' ,'showthread_ratethread' ,'showthread_moderationoptions' ,'multipage_prevpage' ,'multipage_nextpage' ,'multipage_page_current' ,'multipage_page' ,'multipage_start' ,'multipage_end' ,'multipage' ,'postbit_editedby' ,'showthread_similarthreads' ,'showthread_similarthreads_bit' ,'postbit_iplogged_show' ,'postbit_iplogged_hiden' ,'showthread_quickreply' ,'forumjump_advanced' ,'forumjump_special' ,'forumjump_bit' ,'showthread_multipage' ,'postbit_reputation' ,'postbit_quickdelete' ,'postbit_attachments' ,'thumbnails_thumbnail' ,'postbit_attachments_attachment' ,'postbit_attachments_thumbnails' ,'postbit_attachments_images_image' ,'postbit_attachments_images' ,'postbit_posturl' ,'postbit_inlinecheck' ,'showthread_inlinemoderation' ,'postbit_attachments_thumbnails_thumbnail' ,'postbit_quickquote' ,'postbit_qqmessage' ,'postbit_seperator' ,'postbit_groupimage' ,'postbit_multiquote' ,'css' ,'headerinclude' ,'header' ,'footer' ,'gobutton' ,'htmldoctype' ,'header_welcomeblock_member' ,'header_welcomeblock_guest' ,'header_welcomeblock_member_admin' ,'nav' ,'nav_sep' ,'nav_bit' ,'nav_sep_active' ,'nav_bit_active' ,'global_unreadreports') AND sid IN ('-2','-1','1') ORDER BY sid
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 423 Using where; Using filesort
Query Time: 0.0062191

#8 - Write Query
DELETE FROM mybb_threads WHERE deletetime != '0' AND deletetime < '1199981198'
Query Time: 0.0011952

#9 - Select Query
SELECT * FROM mybb_threads WHERE tid='64' AND closed NOT LIKE 'moved|%'
table type possible_keys key key_len ref rows Extra
mybb_threads const PRIMARY PRIMARY 4 const 1
Query Time: 0.0564151

#10 - Select Query
SELECT COUNT(p.pid) AS count FROM mybb_posts p WHERE p.tid='64' AND p.pid <= '253' AND (p.visible='0' OR p.visible='1')
table type possible_keys key key_len ref rows Extra
p ref PRIMARY,tid tid 4 const 3 Using where
Query Time: 0.0015290

#11 - Select Query
SELECT COUNT(*) AS replies FROM mybb_posts p WHERE p.tid='64' AND (p.visible='0' OR p.visible='1')
table type possible_keys key key_len ref rows Extra
p ref tid tid 4 const 3 Using where
Query Time: 0.0014071

#12 - Select Query
SELECT p.pid FROM mybb_posts p WHERE p.tid='64' AND (p.visible='0' OR p.visible='1') ORDER BY p.dateline LIMIT 0, 10
table type possible_keys key key_len ref rows Extra
p ref tid tid 4 const 3 Using where; Using filesort
Query Time: 0.0012870

#13 - Select Query
SELECT * FROM mybb_attachments WHERE pid IN('253')
table type possible_keys key key_len ref rows Extra
mybb_attachments ref pid pid 4 const 1 Using where
Query Time: 0.0012469

#14 - Select Query
SELECT u.*, u.username AS userusername, p.*, f.*, eu.username AS editusername FROM mybb_posts p LEFT JOIN mybb_users u ON (u.uid=p.uid) LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) LEFT JOIN mybb_users eu ON (eu.uid=p.edituid) WHERE pid IN('253') ORDER BY p.dateline
table type possible_keys key key_len ref rows Extra
p const PRIMARY PRIMARY 4 const 1
u const PRIMARY PRIMARY 4 const 1
f const PRIMARY PRIMARY 4 const 1
eu const PRIMARY PRIMARY 4 const 1
Query Time: 0.0086119

#15 - Select Query
SELECT * FROM mybb_usertitles ORDER BY posts DESC
table type possible_keys key key_len ref rows Extra
mybb_usertitles ALL 7 Using filesort
Query Time: 0.0019159

#16 - Select Query
SELECT COUNT(*) AS count FROM mybb_thx WHERE adduid=3
table type possible_keys key key_len ref rows Extra
mybb_thx ALL 10 Using where
Query Time: 0.0412061

(Plugin Hook: postbit)
#17 - Select Query
SELECT * FROM mybb_thx WHERE pid='253' AND tid='64' ORDER BY time DESC
table type possible_keys key key_len ref rows Extra
mybb_thx ALL 10 Using where; Using filesort
Query Time: 0.0011499

(Plugin Hook: postbit)
#18 - Select Query
SELECT * FROM mybb_users WHERE uid='1'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0040359

#19 - Select Query
SELECT tid, name, type FROM mybb_modtools WHERE CONCAT(',',forums,',') LIKE '%,13,%' OR CONCAT(',',forums,',') LIKE '%,-1,%'
table type possible_keys key key_len ref rows Extra
mybb_modtools system 1
Query Time: 0.0461869

#20 - Select Query
SELECT template FROM mybb_templates WHERE title='showthread_inlinemoderation_custom_tool' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 423 Using where; Using filesort
Query Time: 0.0026269

#21 - Select Query
SELECT template FROM mybb_templates WHERE title='showthread_inlinemoderation_custom' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 423 Using where; Using filesort
Query Time: 0.0021911

Template Statistics
Templates Used (Loaded for this Page) - 70 Total
header_welcomeblock_member, postbit_online, showthread_moderationoptions, showthread_inlinemoderation, showthread, showthread_ratethread, forumjump_advanced, header_welcomeblock_member_admin, gobutton, postbit_away, footer, headerinclude, showthread_similarthreads, nav_sep, nav_sep_active, header_welcomeblock_guest, header, showthread_newreply_closed, postbit_edit, postbit_email, postbit_find, postbit_pm, postbit_profile, postbit_quickdelete, postbit_quote, postbit_report, postbit_www, postbit_avatar, showthread_quickreply, postbit, postbit_seperator, postbit_groupimage, showthread_newreply, showthread_newthread, global_unreadreports, multipage, multipage_end, multipage_nextpage, multipage_page, multipage_page_current, multipage_prevpage, multipage_start, postbit_attachments_thumbnails, showthread_ratingdisplay, postbit_posturl, postbit_attachments_thumbnails_thumbnail, postbit_attachments_images_image, postbit_signature, postbit_attachments, postbit_attachments_attachment, postbit_attachments_images, postbit_reputation, showthread_multipage, postbit_iplogged_hiden, postbit_iplogged_show, forumjump_bit, forumjump_special, showthread_similarthreads_bit, postbit_offline, postbit_editedby, nav, nav_bit, nav_bit_active, postbit_inlinecheck, htmldoctype, postbit_multiquote, postbit_author_user, postbit_author_guest, showthread_inlinemoderation_custom_tool, showthread_inlinemoderation_custom

Templates Requiring Additional Calls (Not Cached at Startup) - 2 Total
showthread_inlinemoderation_custom_tool, showthread_inlinemoderation_custom

Dave

Ok, das Querz erscheint nicht in der Liste, das kann aber auch auf Grund der Tatsache sein, dass das Query in einer Zwischenseite ausgefuehrt wird.
Setze bitte unter das $reputation Array folgenden Befehel:
PHP-Code:
print_r($reputation); 

Das sollte eine Ausgabe des Arrays bewirken.
Seiten: 1 2