MyBB Debug Information

Page Generation

Page Generation Statistics
Page Generation Time: 0.193706989288 seconds No. DB Queries: 12
PHP Processing Time: 0.1907437 seconds (98.47%) DB Processing Time: 0.0029633 seconds (1.53%)
Extensions Used: mysql, xml Global.php Processing Time: 0.0369959 seconds
PHP Version: 5.2.17 Server Load: 1.6
GZip Encoding Status: Disabled No. Templates Used: 39 (46 Cached / 1 Manually Loaded)
Memory Usage: 10.25 MB (10747904 bytes) Memory Limit: 128M

Database Connections (1 Total)

[READ] garrysmo_forum@localhost (Connected in 0s)

Database Queries (12 Total)

#1 - Write Query
SET NAMES 'utf8'
Query Time: 5.00679016113E-5

#2 - Select Query
SELECT value, name FROM mybb_settings ORDER BY title ASC
table type possible_keys key key_len ref rows Extra
mybb_settings ALL 333 Using filesort
Query Time: 0.000110864639282

#3 - Select Query
SELECT * FROM mybb_sessions WHERE sid='93c3785d32720243da1828f9fb5552b7' AND ip='85.237.167.172' LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_sessions const PRIMARY,ip PRIMARY 98 const 1
Query Time: 0.000149965286255

#4 - Select Query
SELECT u.*, f.* FROM mybb_users u LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) WHERE u.uid='118' 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.000321865081787

#5 - Write Query
UPDATE mybb_sessions SET `uid`='118', `time`='1313311749', `location`='/index.php?debug=1', `useragent`='Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/13.0.782.112 Safari', `location1`='0', `location2`='0', `nopermission`='0' WHERE sid='93c3785d32720243da1828f9fb5552b7' LIMIT 1
Query Time: 0.000350952148438

(Plugin Hook: global_start)
#6 - Select Query
SELECT * FROM mybb_ems ORDER BY `order` ASC
table type possible_keys key key_len ref rows Extra
mybb_ems system 1
Query Time: 0.000114917755127

(Plugin Hook: global_start)
#7 - Select Query
SELECT template FROM mybb_templates WHERE title='boardmessage_styles' AND sid IN ('-2','-1','') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 2076 Using where; Using filesort
Query Time: 9.82284545898E-5

#8 - Select Query
SELECT name, tid, properties, stylesheets FROM mybb_themes WHERE tid='48' LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_themes const PRIMARY PRIMARY 2 const 1
Query Time: 0.000955104827881

#9 - 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' ,'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','34') ORDER BY sid ASC
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 2076 Using where; Using filesort
Query Time: 8.9168548584E-5

#10 - Select Query
SELECT COUNT(uid) as total FROM mybb_joinrequests WHERE gid IN (0,4)
table type possible_keys key key_len ref rows Extra
Impossible WHERE noticed after reading const tables
Query Time: 4.10079956055E-5

#11 - 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>'1313310849' ORDER BY u.username ASC, s.time DESC
table type possible_keys key key_len ref rows Extra
s range time time 8 6 Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 garrysmo_forum.s.uid 1
Query Time: 0.000323057174683

#12 - 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='118') WHERE f.active != 0 ORDER BY pid, disporder
table type possible_keys key key_len ref rows Extra
f ALL 70 Using where; Using filesort
fr eq_ref fid fid 8 garrysmo_forum.f.fid,const 1
Query Time: 0.000121116638184

Template Statistics

Templates Used (Loaded for this Page) - 39 Total
boardmessage_styles, 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

Templates Requiring Additional Calls (Not Cached at Startup) - 1 Total
boardmessage_styles