Beiträge: 127
Themen: 34
Registriert seit: 27.12.2007
Nein, nur Administratoren haben darauf Zugriff.
Beiträge: 127
Themen: 34
Registriert seit: 27.12.2007
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
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:
Das sollte eine Ausgabe des Arrays bewirken.
|
