MyBB Debug Information
Page Generation
Page Generation Statistics
Page Generation Time: 	0.075273990631104 seconds 	No. DB Queries: 	13
PHP Processing Time: 	0.0702987 seconds (93.39%) 	DB Processing Time: 	0.0049753 seconds (6.61%)
Extensions Used: 	mysql, xml 	Global.php Processing Time: 	0.0451531 seconds
PHP Version: 	5.3.3-1ubuntu9.5 	Server Load: 	0.09
GZip Encoding Status: 	Disabled 	No. Templates Used: 	39 (47 Cached / 1 Manually Loaded)
Memory Usage: 	6.75 MB (7077888 bytes) 	Memory Limit: 	128M
Database Connections (1 Total)
[READ] forums@localhost (Connected in 0s)

Database Queries (13 Total)
#1 - Write Query
SET NAMES 'utf8'
Query Time: 8.2015991210938E-5

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

#3 - Select Query
SELECT * FROM mybb_sessions WHERE sid='58c3bf194e6b1167aeff36a4b84207ca' AND ip='77.249.190.165' LIMIT 1
table 	type 	possible_keys 	key 	key_len 	ref 	rows 	Extra
mybb_sessions 	const 	PRIMARY,ip 	PRIMARY 	98 	const 	1
Query Time: 0.00026702880859375

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

#5 - Write Query
UPDATE mybb_sessions SET `uid`='3', `time`='1313153343', `location`='/forum/index.php?debug=1', `useragent`='Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0.1) Gecko/20100101 Firefox/5.0.1', `location1`='0', `location2`='0', `nopermission`='0' WHERE sid='58c3bf194e6b1167aeff36a4b84207ca' LIMIT 1
Query Time: 0.00021505355834961

#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 					6 	Using where
Query Time: 7.0095062255859E-5

#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' ,'' ,'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','10') ORDER BY sid ASC
table 	type 	possible_keys 	key 	key_len 	ref 	rows 	Extra
mybb_templates 	ALL 					795 	Using where; Using filesort
Query Time: 0.00010490417480469

(Plugin Hook: index_start)
#8 - Select Query
SELECT s.sid, s.ip, s.time, s.location, u.uid, u.username, u.invisible, u.usergroup, u.displaygroup FROM mybb_users u LEFT JOIN mybb_sessions s ON (u.uid=s.uid) WHERE u.lastactive > 1313066943 ORDER BY u.username ASC, s.time DESC
table 	type 	possible_keys 	key 	key_len 	ref 	rows 	Extra
u 	ALL 					116 	Using where; Using temporary; Using filesort
s 	ref 	uid 	uid 	4 	forums.u.uid 	1
Query Time: 0.00095391273498535

(Plugin Hook: index_start)
#9 - 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>'1313066943' ORDER BY u.username ASC, s.time DESC
table 	type 	possible_keys 	key 	key_len 	ref 	rows 	Extra
s 	ALL 	time 				488 	Using where; Using temporary; Using filesort
u 	eq_ref 	PRIMARY 	PRIMARY 	4 	forums.s.uid 	1
Query Time: 0.0012969970703125

(Plugin Hook: index_start)
#10 - Select Query
SELECT template FROM mybb_templates WHERE title='online_today_index' AND sid IN ('-2','-1','10') ORDER BY sid DESC LIMIT 1
table 	type 	possible_keys 	key 	key_len 	ref 	rows 	Extra
mybb_templates 	ALL 					795 	Using where; Using filesort
Query Time: 0.00015091896057129

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

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

(Plugin Hook: build_forumbits_forum)
#13 - Select Query
SELECT * FROM mybb_themes ORDER BY pid, name
table 	type 	possible_keys 	key 	key_len 	ref 	rows 	Extra
mybb_themes 	ALL 					6 	Using filesort
Query Time: 6.2227249145508E-5

Template Statistics
Templates Used (Loaded for this Page) - 39 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, online_today_index

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