Zitat:MyBB Debug Information
Page Generation
Page Generation Statistics
Page Generation Time: 6.7120070457458 seconds No. DB Queries: 58
PHP Processing Time: 4.2940860 seconds (63.98%) DB Processing Time: 2.4179211 seconds (36.02%)
Extensions Used: mysql, xml Global.php Processing Time: 2.699853181839 seconds
PHP Version: 5.2.17 Server Load: 8.3594
GZip Encoding Status: Disabled No. Templates Used: 75 (71 Cached / 10 Manually Loaded)
Memory Usage: 6,5 MB (6815744 bytes) Memory Limit: 104M
Database Connections (1 Total)
[READ] U806924@rdbms.strato.de (Connected in 0s)

Database Queries (58 Total)
0.0139401
#1 - Write Query
SET NAMES 'utf8'
Query Time: 0.00024700164794922

0.0176420
#2 - Select Query
SELECT title,cache FROM mybb_datacache
table type possible_keys key key_len ref rows Extra
mybb_datacache ALL 31
Query Time: 0.0026531219482422

0.1335661
#3 - Select Query
SELECT * FROM mybb_sessions WHERE sid='b94740dbffe03bbcecfc8978860cc7dd' AND ip='188.108.183.189' LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_sessions const PRIMARY,ip PRIMARY 98 const 1
Query Time: 0.00028681755065918

0.1946850
#4 - Select Query
SELECT u.*, f.* FROM mybb_users u LEFT JOIN mybb_userfields f ON (f.ufid=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
Query Time: 0.0034420490264893

0.8761551
#5 - Write Query
UPDATE mybb_sessions SET `uid`='1', `time`='1298223736', `location`='/index.php?debug=1', `useragent`='Mozilla/5.0 (Windows; U; Windows NT 6.1; de; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13', `location1`='0', `location2`='0', `nopermission`='0' WHERE sid='b94740dbffe03bbcecfc8978860cc7dd' LIMIT 1
Query Time: 0.2468159198761

1.1093950
#6 - Select Query
SELECT name, tid, properties, stylesheets FROM mybb_themes WHERE def='1' LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_themes ALL 7 Using where
Query Time: 0.21832895278931

1.3341341
#7 - Select Query
SELECT title,template FROM mybb_templates WHERE title IN ('' ,'index' ,'index_whosonline' ,'index_welcomemembertext' ,'index_welcomeguest' ,'index_whosonline_memberbit' ,'forumbit_depth1_cat' ,'forumbit_depth1_forum' ,'forumbit_depth2_cat' ,'forumbit_depth2_forum' ,'forumbit_depth1_forum_lastpost' ,'forumbit_depth2_forum_lastpost' ,'index_modcolumn' ,'forumbit_moderators' ,'forumbit_subforums' ,'index_welcomeguesttext' ,'index_birthdays_birthday' ,'index_birthdays' ,'index_pms' ,'index_loginform' ,'index_logoutlink' ,'index_stats' ,'forumbit_depth3' ,'forumbit_depth3_statusicon' ,'index_boardstats' ,'prostats' ,'prostats_readstate_icon' ,'prostats_newmembers' ,'prostats_newmembers_row' ,'prostats_topposters' ,'prostats_topposters_row' ,'prostats_topreferrers' ,'prostats_topreferrers_row' ,'prostats_mostthanks' ,'prostats_mostthanks_row' ,'prostats_newthreads' ,'prostats_newthreads_row' ,'prostats_newthreads_specialchar' ,'prostats_mostreplies' ,'prostats_mostreplies_row' ,'prostats_mostviews' ,'prostats_mostviews_row' ,'prostats_newposts' ,'prostats_newposts_row' ,'prostats_topdownloads' ,'prostats_topdownloads_row' ,'prostats_message' ,'prostats_onerowextra' ,'prostats_tworowextra' ,'thanks_postbit_count' ,'css' ,'headerinclude' ,'header' ,'footer' ,'gobutton' ,'htmldoctype' ,'header_welcomeblock_member' ,'header_welcomeblock_guest' ,'header_welcomeblock_member_admin' ,'global_pm_alert' ,'global_unreadreports' ,'' ,'global_pending_joinrequests' ,'nav' ,'nav_sep' ,'nav_bit' ,'nav_sep_active' ,'nav_bit_active' ,'footer_languageselect' ,'header_welcomeblock_member_moderator' ,'redirect' ,'error') AND sid IN ('-2','-1','1') ORDER BY sid ASC
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 825 Using where; Using filesort
Query Time: 0.0011360645294189

(Plugin Hook: global_end)
2.6943951
#8 - Select Query
SELECT * FROM mybb_attachments WHERE `thumbnail` != '' ORDER BY aid DESC
table type possible_keys key key_len ref rows Extra
mybb_attachments ALL 303 Using where; Using filesort
Query Time: 0.0019919872283936

(Plugin Hook: global_end)
2.6959531
#9 - Select Query
SELECT * FROM mybb_posts WHERE pid='2835'
table type possible_keys key key_len ref rows Extra
mybb_posts const PRIMARY PRIMARY 4 const 1
Query Time: 0.00060701370239258

(Plugin Hook: global_end)
2.6981442
#10 - Select Query
SELECT template FROM mybb_templates WHERE title='atchgallery' 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 825 Using where; Using filesort
Query Time: 0.0009758472442627

(Plugin Hook: global_end)
2.6998532
#11 - Write Query
REPLACE INTO mybb_datacache SET `title`='atchgallery',`cache`='a:2:{s:7:\"content\";s:1611:\"<!-- start: atchgallery -->\n<br class=\"clear\" />\n<table border=\"0\" cellspacing=\"1\" cellpadding=\"4\" class=\"tborder\">\n <thead>\n <tr>\n <td class=\"thead\" colspan=\"6\">\n \n <div class=\"expcolimage\">\n <img src=\"images/collapse.gif\" id=\"atchgallery_id_img\" class=\"expander\" alt=\"[-]\" />\n </div>\n <div><strong>Die letzen Pic´s auf QFSH</strong></div>\n </td>\n </tr>\n </thead>\n <tbody style=\"\" id=\"atchgallery_id_e\">\n <tr style=\"height: 106px;\">\n <td class=\"trow1\" style=\"text-align: center; width: 16.666666666667%;\">\n <a href=\"showthread.php?tid=358&amp;pid=2835#pid2835\" target=\"_blank\"><img src=\"attachment.php?thumbnail=346\" class=\"attachment\" alt=\"\"></a>\n</td>\n<td class=\"trow1\" style=\"text-align: center; width: 16.666666666667%;\">\n <a href=\"showthread.php?tid=358&amp;pid=2835#pid2835\" target=\"_blank\"><img src=\"attachment.php?thumbnail=345\" class=\"attachment\" alt=\"\"></a>\n</td>\n<td class=\"trow1\" style=\"text-align: center; width: 16.666666666667%;\">\n <a href=\"showthread.php?tid=358&amp;pid=2835#pid2835\" target=\"_blank\"><img src=\"attachment.php?thumbnail=344\" class=\"attachment\" alt=\"\"></a>\n</td>\n<td class=\"trow1\" style=\"text-align: center; width: 16.666666666667%;\">\n <a href=\"showthread.php?tid=358&amp;pid=2835#pid2835\" target=\"_blank\"><img src=\"attachment.php?thumbnail=343\" class=\"attachment\" alt=\"\"></a>\n</td>\n<td class=\"trow1\" style=\"text-align: center; width: 16.666666666667%;\">\n <a href=\"showthread.php?tid=358&amp;pid=2835#pid2835\" target=\"_blank\"><img src=\"attachment.php?thumbnail=342\" class=\"attachment\" alt=\"\"></a>\n</td>\n\n </tr>\n </tbody>\n</table>\n<!-- end: atchgallery -->\";s:12:\"last_updated\";i:1298223738;}'
Query Time: 0.00050687789916992

(Plugin Hook: index_start)
3.0618892
#12 - Select Query
SELECT t.subject,t.username,t.uid,t.tid,t.fid,t.lastpost,t.lastposter,t.lastposteruid,t.replies,tr.uid AS truid,tr.dateline,f.name FROM mybb_threads t LEFT JOIN mybb_threadsread tr ON (tr.tid=t.tid AND tr.uid='1') LEFT JOIN mybb_forums f ON (f.fid = t.fid) WHERE t.visible='1' AND t.closed NOT LIKE 'moved|%' ORDER BY t.lastpost DESC LIMIT 0,11
table type possible_keys key key_len ref rows Extra
t index lastpost 10 309 Using where
tr eq_ref tid tid 8 DB806924.t.tid,const 1
f eq_ref PRIMARY PRIMARY 2 DB806924.t.fid 1
Query Time: 0.34129405021667

(Plugin Hook: index_start)
3.0800772
#13 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '71'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00049304962158203

(Plugin Hook: index_start)
3.0810840
#14 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '71'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00054407119750977

(Plugin Hook: index_start)
3.0825450
#15 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '21'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00041699409484863

(Plugin Hook: index_start)
3.2160220
#16 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '21'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.13298606872559

(Plugin Hook: index_start)
3.2485201
#17 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '71'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00028610229492188

(Plugin Hook: index_start)
4.2012851
#18 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '71'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00087714195251465

(Plugin Hook: index_start)
4.2025962
#19 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '71'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00052595138549805

(Plugin Hook: index_start)
4.2038722
#20 - Select Query
SELECT username,usergroup,displaygroup 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.00046896934509277

(Plugin Hook: index_start)
4.2059641
#21 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '8'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0010530948638916

(Plugin Hook: index_start)
5.0403750
#22 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '4'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.83309483528137

(Plugin Hook: index_start)
5.0419030
#23 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '70'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00063014030456543

(Plugin Hook: index_start)
5.0428691
#24 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '70'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00049185752868652

(Plugin Hook: index_start)
5.0439911
#25 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '38'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00034785270690918

(Plugin Hook: index_start)
5.0448780
#26 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '24'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00041294097900391

(Plugin Hook: index_start)
5.0459821
#27 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '38'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0003509521484375

(Plugin Hook: index_start)
5.0467410
#28 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '4'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00035500526428223

(Plugin Hook: index_start)
5.0481341
#29 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '2'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00042200088500977

(Plugin Hook: index_start)
5.0488591
#30 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '2'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00024795532226562

(Plugin Hook: index_start)
5.0505002
#31 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '9'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00076913833618164

(Plugin Hook: index_start)
5.0514970
#32 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '24'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00040888786315918

(Plugin Hook: index_start)
5.0527382
#33 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '16'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00034809112548828

(Plugin Hook: index_start)
5.0538921
#34 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '2'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.00037813186645508

(Plugin Hook: index_start)
5.0574062
#35 - Write Query
SHOW COLUMNS FROM mybb_users LIKE 'thxcount'
Query Time: 0.002918004989624

(Plugin Hook: index_start)
5.0582561
#36 - Select Query
SELECT uid,username,usergroup,displaygroup,thxcount FROM mybb_users ORDER BY thxcount DESC LIMIT 0,5
table type possible_keys key key_len ref rows Extra
mybb_users ALL 66 Using filesort
Query Time: 0.00078201293945312

(Plugin Hook: index_start)
5.0599022
#37 - Select Query
SELECT uid,regdate,username,usergroup,displaygroup FROM mybb_users ORDER BY uid DESC LIMIT 0,5
table type possible_keys key key_len ref rows Extra
mybb_users index PRIMARY 4 66
Query Time: 0.00051712989807129

(Plugin Hook: index_start)
5.0627091
#38 - Select Query
SELECT t.subject,t.tid,t.replies,t.lastpost,tr.uid AS truid,tr.dateline FROM mybb_threads t LEFT JOIN mybb_threadsread tr ON (tr.tid=t.tid AND tr.uid='1') LEFT JOIN mybb_forums f ON (f.fid = t.fid) WHERE t.visible='1' AND t.closed NOT LIKE 'moved|%' ORDER BY t.replies DESC LIMIT 0,5
table type possible_keys key key_len ref rows Extra
t ALL 309 Using where; Using filesort
tr eq_ref tid tid 8 DB806924.t.tid,const 1
f eq_ref PRIMARY PRIMARY 2 DB806924.t.fid 1 Using index
Query Time: 0.0012049674987793

(Plugin Hook: index_start)
5.0649600
#39 - Select Query
SELECT username,postnum,uid,usergroup,displaygroup FROM mybb_users ORDER BY postnum DESC LIMIT 0,5
table type possible_keys key key_len ref rows Extra
mybb_users ALL 66 Using filesort
Query Time: 0.0009310245513916

(Plugin Hook: index_start)
5.0672331
#40 - Select Query
SELECT t.subject,t.tid,t.lastpost,t.views,tr.uid AS truid,tr.dateline FROM mybb_threads t LEFT JOIN mybb_threadsread tr ON (tr.tid=t.tid AND tr.uid='1') LEFT JOIN mybb_forums f ON (f.fid = t.fid) WHERE t.visible='1' AND t.closed NOT LIKE 'moved|%' ORDER BY t.views DESC LIMIT 0,5
table type possible_keys key key_len ref rows Extra
t ALL 309 Using where; Using filesort
tr eq_ref tid tid 8 DB806924.t.tid,const 1
f eq_ref PRIMARY PRIMARY 2 DB806924.t.fid 1 Using index
Query Time: 0.0012319087982178

(Plugin Hook: index_start)
5.0697241
#41 - Select Query
SELECT u.uid,u.username,u.usergroup,u.displaygroup,count(*) as refcount FROM mybb_users u LEFT JOIN mybb_users r ON (r.referrer = u.uid) WHERE r.referrer = u.uid GROUP BY r.referrer DESC ORDER BY refcount DESC LIMIT 0 ,5
table type possible_keys key key_len ref rows Extra
r ALL 66 Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 DB806924.r.referrer 1
Query Time: 0.0012187957763672

(Plugin Hook: index_start)
5.0718992
#42 - Select Query
SELECT COUNT(pid) AS newposts FROM mybb_posts WHERE visible=1 AND dateline>'1298203048'
table type possible_keys key key_len ref rows Extra
mybb_posts range visible,dateline dateline 8 71 Using where
Query Time: 0.00021910667419434

(Plugin Hook: index_start)
5.0726950
#43 - Select Query
SELECT COUNT(tid) AS newthreads FROM mybb_threads WHERE visible=1 AND dateline>'1298203048'
table type possible_keys key key_len ref rows Extra
mybb_threads range dateline dateline 8 15 Using where
Query Time: 0.00034117698669434

(Plugin Hook: index_start)
5.0734651
#44 - Select Query
SELECT COUNT(tid) AS newann FROM mybb_threads WHERE visible=1 AND dateline>'1298203048' AND fid IN (2)
table type possible_keys key key_len ref rows Extra
mybb_threads ref fid,dateline fid 6 const,const 1 Using where
Query Time: 0.00041484832763672

(Plugin Hook: index_start)
5.0741541
#45 - Select Query
SELECT template FROM mybb_templates WHERE title='portal_welcome_membertext' 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 825 Using where; Using filesort
Query Time: 0.00025486946105957

(Plugin Hook: index_start)
5.0749140
#46 - Select Query
SELECT template FROM mybb_templates WHERE title='portal_welcome' 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 825 Using where; Using filesort
Query Time: 0.00020790100097656

(Plugin Hook: index_start)
5.0756810
#47 - Select Query
SELECT COUNT(*) AS pms_total, SUM(IF(status='0' AND folder='1','1','0')) AS pms_unread FROM mybb_privatemessages WHERE uid='1'
table type possible_keys key key_len ref rows Extra
mybb_privatemessages ref uid uid 4 const 236
Query Time: 0.00026392936706543

(Plugin Hook: index_start)
5.0763171
#48 - Select Query
SELECT template FROM mybb_templates WHERE title='portal_pms' 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 825 Using where; Using filesort
Query Time: 0.00023913383483887

(Plugin Hook: index_start)
5.0770402
#49 - Select Query
SELECT template FROM mybb_templates WHERE title='portal_stats' 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 825 Using where; Using filesort
Query Time: 0.00029397010803223

(Plugin Hook: index_start)
5.0777640
#50 - Select Query
SELECT template FROM mybb_templates WHERE title='portal_search' 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 825 Using where; Using filesort
Query Time: 0.00028204917907715

(Plugin Hook: index_start)
5.0792341
#51 - Select Query
SELECT s.sid, s.ip, s.uid, s.time, s.location, u.username, u.invisible, u.usergroup, u.displaygroup FROM mybb_sessions s LEFT JOIN mybb_users u ON (s.uid=u.uid) WHERE s.time>'1298222836' ORDER BY u.username ASC, s.time DESC
table type possible_keys key key_len ref rows Extra
s range time time 8 18 Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 DB806924.s.uid 1
Query Time: 0.0010478496551514

(Plugin Hook: index_start)
5.2386260
#52 - Select Query
SELECT template FROM mybb_templates WHERE title='portal_whosonline_memberbit' 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 825 Using where; Using filesort
Query Time: 0.010980844497681

(Plugin Hook: index_start)
5.3200872
#53 - Select Query
SELECT template FROM mybb_templates WHERE title='portal_whosonline' 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 825 Using where; Using filesort
Query Time: 0.00028514862060547

(Plugin Hook: index_start)
6.0935121
#54 - Select Query
SELECT t.*, u.username FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid=t.uid) WHERE 1=1 AND t.visible='1' AND t.closed NOT LIKE 'moved|%' ORDER BY t.lastpost DESC LIMIT 0, 10
table type possible_keys key key_len ref rows Extra
t index lastpost 10 309 Using where
u eq_ref PRIMARY PRIMARY 4 DB806924.t.uid 1
Query Time: 0.53643298149109

(Plugin Hook: index_start)
6.1460981
#55 - Select Query
SELECT template FROM mybb_templates WHERE title='portal_latestthreads_thread' 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 825 Using where; Using filesort
Query Time: 0.00030517578125

(Plugin Hook: index_start)
6.1692522
#56 - Select Query
SELECT template FROM mybb_templates WHERE title='portal_latestthreads' 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 825 Using where; Using filesort
Query Time: 0.0011749267578125

6.2459950
#57 - Select Query
SELECT s.sid, s.ip, s.uid, s.time, s.location, s.location1, u.username, u.invisible, u.usergroup, u.displaygroup FROM mybb_sessions s LEFT JOIN mybb_users u ON (s.uid=u.uid) WHERE s.time>'1298222836' ORDER BY u.username ASC, s.time DESC
table type possible_keys key key_len ref rows Extra
s range time time 8 18 Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 DB806924.s.uid 1
Query Time: 0.022027015686035

6.3793151
#58 - Select Query
SELECT f.*, fr.dateline AS lastread FROM mybb_forums f LEFT JOIN mybb_forumsread fr ON (fr.fid=f.fid AND fr.uid='1') WHERE f.active != 0 ORDER BY pid, disporder
table type possible_keys key key_len ref rows Extra
f ALL 77 Using where; Using filesort
fr eq_ref fid fid 8 DB806924.f.fid,const 1
Query Time: 0.03545618057251

Template Statistics
Templates Used (Loaded for this Page) - 75 Total
global_pm_alert, index, header_welcomeblock_member, header_welcomeblock_member_moderator, header_welcomeblock_member_admin, redirect, gobutton, forumbit_depth2_forum, forumbit_depth3, forumbit_depth3_statusicon, forumbit_subforums, footer, headerinclude, nav_sep, nav_sep_active, header_welcomeblock_guest, header, forumbit_depth1_cat, global_unreadreports, global_pending_joinrequests, index_loginform, index_whosonline, index_stats, index_birthdays_birthday, forumbit_moderators, index_birthdays, index_logoutlink, error, index_whosonline_memberbit, forumbit_depth2_cat, nav, nav_bit, nav_bit_active, htmldoctype, footer_languageselect, index_boardstats, forumbit_depth2_forum_lastpost, forumbit_depth1_forum_lastpost, prostats_newmembers_row, prostats_topposters, prostats_topposters_row, prostats_topreferrers, prostats_topreferrers_row, prostats_mostthanks, prostats_mostthanks_row, prostats_newthreads, prostats_newthreads_row, prostats_newthreads_specialchar, prostats, prostats_readstate_icon, prostats_newmembers, prostats_mostreplies_row, prostats_mostviews, prostats_mostviews_row, prostats_newposts, prostats_mostreplies, prostats_newposts_row, prostats_topdownloads, prostats_topdownloads_row, prostats_message, prostats_onerowextra, prostats_tworowextra, thanks_postbit_count, atchgallery, forumdisplay, portal, portal_welcome_membertext, portal_welcome, portal_pms, portal_stats, portal_search, portal_whosonline_memberbit, portal_whosonline, portal_latestthreads_thread, portal_latestthreads

Templates Requiring Additional Calls (Not Cached at Startup) - 10 Total
atchgallery, portal_welcome_membertext, portal_welcome, portal_pms, portal_stats, portal_search, portal_whosonline_memberbit, portal_whosonline, portal_latestthreads_thread, portal_latestthreads