MyBB Debug Information

Page Generation

Page Generation Statistics
Page Generation Time: 14.7507040501 seconds No. DB Queries: 147
PHP Processing Time: 7.4816055 seconds (50.72%) DB Processing Time: 7.2690985 seconds (49.28%)
Extensions Used: mysql, xml Global.php Processing Time: 2.0095601 seconds
PHP Version: 5.2.10 Server Load: 0.73
GZip Encoding Status: Enabled No. Templates Used: 51 (44 Cached / 14 Manually Loaded)
Memory Usage: 2.75 Mb (2883584 bytes) Memory Limit: 250M

Database Connections (1 Total)

[READ] migsrbij_jorgovanw@66.7.199.212 (Connected in 0s)

Database Queries (147 Total)

#1 - Write Query
SET NAMES 'utf8'
Query Time: 0.0497841835022

#2 - Select Query
SELECT * FROM mybb_sessions WHERE sid='ffd3fd3632e453fb0fc4561a326b13ec' AND ip='62.193.158.239' LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_sessions const PRIMARY,ip PRIMARY 98 const 1
Query Time: 0.0495879650116

#3 - 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 0 unique row not found
Query Time: 0.085019826889

#4 - Write Query
UPDATE mybb_sessions SET `uid`='1', `time`='1249434344', `location`='/index.php?debug=1', `useragent`='Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9) Gecko/2008052906 Firefox/3.0', `location1`='0', `location2`='0', `nopermission`='0' WHERE sid='ffd3fd3632e453fb0fc4561a326b13ec' LIMIT 1
Query Time: 0.0472168922424

(Plugin Hook: global_start)
#5 - Select Query
SELECT * FROM mybb_ads WHERE `mode` != 4 AND `mode` != 3
table type possible_keys key key_len ref rows Extra
mybb_ads system 1
Query Time: 0.0440890789032

(Plugin Hook: global_start)
#6 - Select Query
SELECT * FROM mybb_ads
table type possible_keys key key_len ref rows Extra
mybb_ads system 1
Query Time: 0.0430130958557

(Plugin Hook: global_start)
#7 - Select Query
SELECT * FROM mybb_ads WHERE aid='2'
table type possible_keys key key_len ref rows Extra
mybb_ads system PRIMARY 1
Query Time: 0.0425028800964

(Plugin Hook: global_start)
#8 - Write Query
UPDATE mybb_ads SET shown='178927' WHERE aid='2'
Query Time: 0.0464968681335

#9 - 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 3 Using where
Query Time: 0.0404381752014

#10 - 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' ,'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 625 Using where; Using filesort
Query Time: 0.125567913055

(Plugin Hook: global_end)
#11 - Select Query
SELECT uid, username, birthday, email, usergroup FROM mybb_users WHERE birthday LIKE '5-8-%' AND email != ''
table type possible_keys key key_len ref rows Extra
mybb_users range birthday birthday 47 1 Using where
Query Time: 0.0431890487671

(Plugin Hook: global_end)
#12 - Select Query
SELECT value FROM mybb_settings WHERE name='bdaym'
table type possible_keys key key_len ref rows Extra
mybb_settings ALL 275 Using where
Query Time: 0.0408639907837

(Plugin Hook: global_end)
#13 - Write Query
UPDATE mybb_settings SET value='' WHERE name='bdaym'
Query Time: 0.0442459583282

(Plugin Hook: global_end)
#14 - Select Query
SELECT * FROM mybb_settings WHERE name='dm_keywords'
table type possible_keys key key_len ref rows Extra
mybb_settings ALL 275 Using where
Query Time: 0.0424501895905

(Plugin Hook: global_end)
#15 - Select Query
SELECT * FROM mybb_settings WHERE name='dm_defdesc'
table type possible_keys key key_len ref rows Extra
mybb_settings ALL 275 Using where
Query Time: 0.0446100234985

(Plugin Hook: index_start)
#16 - Select Query
SELECT template FROM mybb_templates WHERE title='haber' 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 625 Using where; Using filesort
Query Time: 0.0479230880737

(Plugin Hook: index_start)
#17 - 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 17598 Using where
tr eq_ref tid tid 8 migsrbij_jorgovanw.t.tid,const 1
f eq_ref PRIMARY PRIMARY 2 migsrbij_jorgovanw.t.fid 1
Query Time: 0.0425221920013

(Plugin Hook: index_start)
#18 - Select Query
SELECT uid FROM mybb_sessions WHERE uid != '0' AND time > '1249433444'
table type possible_keys key key_len ref rows Extra
mybb_sessions range time,uid time 8 6 Using where
Query Time: 0.0546050071716

(Plugin Hook: index_start)
#19 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (17619)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0456640720367

(Plugin Hook: index_start)
#20 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_readstate_icon' 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 625 Using where; Using filesort
Query Time: 0.042690038681

(Plugin Hook: index_start)
#21 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newthreads_specialchar' 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 625 Using where; Using filesort
Query Time: 0.0519800186157

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

(Plugin Hook: index_start)
#23 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (10296,1,1497)
table type possible_keys key key_len ref rows Extra
mybb_google_seo range idtype,active active 7 3 Using where
Query Time: 0.0408298969269

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

(Plugin Hook: index_start)
#25 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=3 AND id IN (10)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0462319850922

(Plugin Hook: index_start)
#26 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newthreads_row' 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 625 Using where; Using filesort
Query Time: 0.0496821403503

(Plugin Hook: index_start)
#27 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (17618)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0420761108398

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

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

(Plugin Hook: index_start)
#30 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=3 AND id IN (21)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0479238033295

(Plugin Hook: index_start)
#31 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (17617)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0438640117645

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

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

(Plugin Hook: index_start)
#34 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (17616)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0494649410248

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

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

(Plugin Hook: index_start)
#37 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (17615)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0443758964539

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

(Plugin Hook: index_start)
#39 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (10128)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0418620109558

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

(Plugin Hook: index_start)
#41 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=3 AND id IN (40)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0490870475769

(Plugin Hook: index_start)
#42 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (17614)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0424058437347

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

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

(Plugin Hook: index_start)
#45 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (17608)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0462000370026

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

(Plugin Hook: index_start)
#47 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (10269)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0415930747986

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

(Plugin Hook: index_start)
#49 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (574)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0410668849945

(Plugin Hook: index_start)
#50 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=3 AND id IN (7)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0454959869385

(Plugin Hook: index_start)
#51 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (17613)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0418889522552

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

(Plugin Hook: index_start)
#53 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (2870)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0397820472717

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

(Plugin Hook: index_start)
#55 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (17612)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0441899299622

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

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

(Plugin Hook: index_start)
#58 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (17611)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0464251041412

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

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

(Plugin Hook: index_start)
#61 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (17610)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0426440238953

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

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

(Plugin Hook: index_start)
#64 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newthreads' 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 625 Using where; Using filesort
Query Time: 0.0449998378754

(Plugin Hook: index_start)
#65 - 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 17598 Using where; Using filesort
tr eq_ref tid tid 8 migsrbij_jorgovanw.t.tid,const 1
f eq_ref PRIMARY PRIMARY 2 migsrbij_jorgovanw.t.fid 1 Using index
Query Time: 0.262501001358

(Plugin Hook: index_start)
#66 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (12855)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0415050983429

(Plugin Hook: index_start)
#67 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_mostreplies_row' 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 625 Using where; Using filesort
Query Time: 0.0481281280518

(Plugin Hook: index_start)
#68 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (9709)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.044184923172

(Plugin Hook: index_start)
#69 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (14365)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0418779850006

(Plugin Hook: index_start)
#70 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (2806)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0416400432587

(Plugin Hook: index_start)
#71 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (16184)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.041531085968

(Plugin Hook: index_start)
#72 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_mostreplies' 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 625 Using where; Using filesort
Query Time: 0.0411109924316

(Plugin Hook: index_start)
#73 - 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 10296 Using filesort
Query Time: 0.0416340827942

(Plugin Hook: index_start)
#74 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (6)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0449359416962

(Plugin Hook: index_start)
#75 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_topposters_row' 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 625 Using where; Using filesort
Query Time: 0.0624070167542

(Plugin Hook: index_start)
#76 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (49)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0462901592255

(Plugin Hook: index_start)
#77 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (747)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0425808429718

(Plugin Hook: index_start)
#78 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (484)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0415849685669

(Plugin Hook: index_start)
#79 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_topposters' 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 625 Using where; Using filesort
Query Time: 0.0450539588928

(Plugin Hook: index_start)
#80 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_tworowextra' 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 625 Using where; Using filesort
Query Time: 0.041405916214

(Plugin Hook: index_start)
#81 - 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,12
table type possible_keys key key_len ref rows Extra
t ALL 17598 Using where; Using filesort
tr eq_ref tid tid 8 migsrbij_jorgovanw.t.tid,const 1
f eq_ref PRIMARY PRIMARY 2 migsrbij_jorgovanw.t.fid 1 Using index
Query Time: 0.240128993988

(Plugin Hook: index_start)
#82 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_mostviews_row' 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 625 Using where; Using filesort
Query Time: 0.0437798500061

(Plugin Hook: index_start)
#83 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (13177)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0486969947815

(Plugin Hook: index_start)
#84 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (1051)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0429408550262

(Plugin Hook: index_start)
#85 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (10645)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.041051864624

(Plugin Hook: index_start)
#86 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (12171)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0427889823914

(Plugin Hook: index_start)
#87 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (10207)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0400698184967

(Plugin Hook: index_start)
#88 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (9701)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0452010631561

(Plugin Hook: index_start)
#89 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (11696)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0517420768738

(Plugin Hook: index_start)
#90 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (6536)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.043417930603

(Plugin Hook: index_start)
#91 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (300)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0398409366608

(Plugin Hook: index_start)
#92 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_mostviews' 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 625 Using where; Using filesort
Query Time: 0.0399739742279

(Plugin Hook: index_start)
#93 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_onerowextra' 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 625 Using where; Using filesort
Query Time: 0.0533418655396

(Plugin Hook: index_start)
#94 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats' 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 625 Using where; Using filesort
Query Time: 0.0473818778992

#95 - 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>'1249433444' 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 migsrbij_jorgovanw.s.uid 1
Query Time: 0.0702328681946

#96 - 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 48 Using where; Using filesort
fr eq_ref fid fid 8 migsrbij_jorgovanw.f.fid,const 1
Query Time: 0.090423822403

(Plugin Hook: build_forumbits_forum)
#97 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '0'
table type possible_keys key key_len ref rows Extra
Impossible WHERE noticed after reading const tables
Query Time: 0.0435841083527

#98 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=3 AND id IN (1,2,3,5,47,4,6,7,8,9,10,11,26,35,28,29,30,31,36,32,39,33,34,12,13,41,42,14,44,15,16,17,18,24,25,40,43,19,27,21,22,38,23,37,20,45,48)
table type possible_keys key key_len ref rows Extra
mybb_google_seo ref idtype,active idtype 1 const 28 Using where
Query Time: 0.0485458374023

(Plugin Hook: build_forumbits_forum)
#99 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '10269'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0477828979492

#100 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (17266,17608,11305,17400,17619,17534,17510,16134,10633,11696,17572,16998,12055,10314,16769,17299,17584,16767,14374,740,17605,2051,16892,13533,17594,6676,17607,17509,17409,17615,10902,17606,15713,17618,3605,6135,14811,16706,17490,12684,17271)
table type possible_keys key key_len ref rows Extra
mybb_google_seo range idtype,active active 7 31 Using where
Query Time: 0.0528190135956

(Plugin Hook: build_forumbits_forum)
#101 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '0'
table type possible_keys key key_len ref rows Extra
Impossible WHERE noticed after reading const tables
Query Time: 0.0426921844482

(Plugin Hook: build_forumbits_forum)
#102 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '574'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0611140727997

(Plugin Hook: build_forumbits_forum)
#103 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '10269'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0432820320129

(Plugin Hook: build_forumbits_forum)
#104 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '8739'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0418257713318

(Plugin Hook: build_forumbits_forum)
#105 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '6'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0415408611298

(Plugin Hook: build_forumbits_forum)
#106 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '10268'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0413031578064

#107 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (10269,574,8739,484,1497,7781,10268,10263,10200,6707,49,6684,8977,2119,29,6121,6,6108,4245,5300,10218,7942,10128,6808,504,1,9323)
table type possible_keys key key_len ref rows Extra
mybb_google_seo range idtype,active active 7 21 Using where
Query Time: 0.0450508594513

(Plugin Hook: build_forumbits_forum)
#108 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '484'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0444340705872

(Plugin Hook: build_forumbits_forum)
#109 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '6108'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0498118400574

(Plugin Hook: build_forumbits_forum)
#110 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '4245'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0429520606995

(Plugin Hook: build_forumbits_forum)
#111 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '5300'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.04549908638

(Plugin Hook: build_forumbits_forum)
#112 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '10218'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0405058860779

(Plugin Hook: build_forumbits_forum)
#113 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '7942'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0480971336365

(Plugin Hook: build_forumbits_forum)
#114 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '10128'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0423250198364

(Plugin Hook: build_forumbits_forum)
#115 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '6808'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0407388210297

(Plugin Hook: build_forumbits_forum)
#116 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '5300'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0442681312561

(Plugin Hook: build_forumbits_forum)
#117 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '6'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0406999588013

(Plugin Hook: build_forumbits_forum)
#118 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '1497'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0469069480896

(Plugin Hook: build_forumbits_forum)
#119 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '1497'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0441539287567

(Plugin Hook: build_forumbits_forum)
#120 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '504'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0536921024323

(Plugin Hook: build_forumbits_forum)
#121 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '6707'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0457820892334

(Plugin Hook: build_forumbits_forum)
#122 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '10268'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0425040721893

(Plugin Hook: build_forumbits_forum)
#123 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (5319)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0475361347198

(Plugin Hook: build_forumbits_forum)
#124 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '10269'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0410330295563

(Plugin Hook: build_forumbits_forum)
#125 - Select Query
SELECT 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.0409400463104

(Plugin Hook: build_forumbits_forum)
#126 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '6684'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0416159629822

(Plugin Hook: build_forumbits_forum)
#127 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '7781'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.04176902771

(Plugin Hook: build_forumbits_forum)
#128 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '0'
table type possible_keys key key_len ref rows Extra
Impossible WHERE noticed after reading const tables
Query Time: 0.0400948524475

(Plugin Hook: build_forumbits_forum)
#129 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '10268'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0416040420532

(Plugin Hook: build_forumbits_forum)
#130 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '1497'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.041011095047

(Plugin Hook: build_forumbits_forum)
#131 - Select Query
SELECT 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.041738986969

(Plugin Hook: build_forumbits_forum)
#132 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '10263'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0419330596924

(Plugin Hook: build_forumbits_forum)
#133 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '10200'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0420091152191

(Plugin Hook: build_forumbits_forum)
#134 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '6707'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.04132604599

(Plugin Hook: build_forumbits_forum)
#135 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '1497'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0437440872192

(Plugin Hook: build_forumbits_forum)
#136 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '1497'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.042552947998

(Plugin Hook: build_forumbits_forum)
#137 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '49'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0409860610962

(Plugin Hook: build_forumbits_forum)
#138 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '6684'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0415380001068

(Plugin Hook: build_forumbits_forum)
#139 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '8977'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0396449565887

(Plugin Hook: build_forumbits_forum)
#140 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '2119'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0409548282623

(Plugin Hook: build_forumbits_forum)
#141 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '0'
table type possible_keys key key_len ref rows Extra
Impossible WHERE noticed after reading const tables
Query Time: 0.0409569740295

(Plugin Hook: build_forumbits_forum)
#142 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '6121'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.040317773819

(Plugin Hook: build_forumbits_forum)
#143 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '574'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0406830310822

(Plugin Hook: build_forumbits_forum)
#144 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '0'
table type possible_keys key key_len ref rows Extra
Impossible WHERE noticed after reading const tables
Query Time: 0.0403978824615

(Plugin Hook: build_forumbits_forum)
#145 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '9323'
table type possible_keys key key_len ref rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 0.0466959476471

(Plugin Hook: build_forumbits_forum)
#146 - Select Query
SELECT usergroup, displaygroup FROM mybb_users WHERE uid = '0'
table type possible_keys key key_len ref rows Extra
Impossible WHERE noticed after reading const tables
Query Time: 0.0410950183868

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

Template Statistics

Templates Used (Loaded for this Page) - 51 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, 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, haber, prostats_readstate_icon, prostats_newthreads_specialchar, prostats_newthreads_row, prostats_newthreads, prostats_mostreplies_row, prostats_mostreplies, prostats_topposters_row, prostats_topposters, prostats_tworowextra, prostats_mostviews_row, prostats_mostviews, prostats_onerowextra, prostats

Templates Requiring Additional Calls (Not Cached at Startup) - 14 Total
haber, prostats_readstate_icon, prostats_newthreads_specialchar, prostats_newthreads_row, prostats_newthreads, prostats_mostreplies_row, prostats_mostreplies, prostats_topposters_row, prostats_topposters, prostats_tworowextra, prostats_mostviews_row, prostats_mostviews, prostats_onerowextra, prostats