2013-05-21, 02:58 AM
That is definitely your hosting mate, just trust me... 9 queries in 6.3 seconds is stupidly slow. It's like an olympic athlete running the 100 metres in 6 minutes...
MyBB Debug Information
Page Generation
Page Generation Statistics
Page Generation Time: 0.28294396400452 seconds No. DB Queries: 9
PHP Processing Time: 0.2694886 seconds (95.24%) DB Processing Time: 0.0134554 seconds (4.76%)
Extensions Used: mysqli, xml Global.php Processing Time: 0.2169080 seconds
PHP Version: 5.2.17 Server Load: Unknown
GZip Encoding Status: Enabled No. Templates Used: 43 (44 Cached / 0 Manually Loaded)
Memory Usage: 3.75 MB (3932160 bytes) Memory Limit: 32M
Database Connections (1 Total)
[READ] [email protected] (Connected in 0s)
Database Queries (9 Total)
#1 - Write Query
SET NAMES 'utf8'
Query Time: 0.00046515464782715
#2 - Select Query
SELECT title,cache FROM mybb_cfaforumdatacache
table type possible_keys key key_len ref rows Extra
mybb_cfaforumdatacache ALL 30
Query Time: 0.0041379928588867
#3 - Select Query
SELECT * FROM mybb_cfaforumsessions WHERE sid='bbae0786be4097e97b6585b6307a3035' AND ip='24.175.191.38' LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_cfaforumsessions const PRIMARY,ip PRIMARY 98 const 1
Query Time: 0.00069212913513184
#4 - Select Query
SELECT u.*, f.* FROM mybb_cfaforumusers u LEFT JOIN mybb_cfaforumuserfields 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.001121997833252
#5 - Write Query
UPDATE mybb_cfaforumsessions SET `uid`='1', `time`='1369105262', `location`='/forum/index.php?debug=1', `useragent`='Mozilla/5.0 (Windows NT 6.2; WOW64; rv:21.0) Gecko/20100101 Firefox/21.0', `location1`='0', `location2`='0', `nopermission`='0' WHERE sid='bbae0786be4097e97b6585b6307a3035' LIMIT 1
Query Time: 0.00070309638977051
#6 - Select Query
SELECT name, tid, properties, stylesheets FROM mybb_cfaforumthemes WHERE tid='5' LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_cfaforumthemes const PRIMARY PRIMARY 2 const 1
Query Time: 0.00085306167602539
#7 - Select Query
SELECT title,template FROM mybb_cfaforumtemplates WHERE title IN ('' ,'index' ,'index_whosonline' ,'index_whosonline_memberbit' ,'forumbit_depth1_cat' ,'forumbit_depth1_forum' ,'forumbit_depth2_cat' ,'forumbit_depth2_forum' ,'forumbit_depth1_forum_lastpost' ,'forumbit_depth2_forum_lastpost' ,'forumbit_moderators' ,'forumbit_subforums' ,'index_birthdays_birthday' ,'index_birthdays' ,'index_loginform' ,'index_logoutlink' ,'index_stats' ,'forumbit_depth3' ,'forumbit_depth3_statusicon' ,'index_boardstats' ,'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' ,'global_boardclosed_warning' ,'global_bannedwarning' ,'error_inline' ,'error_nopermission_loggedin' ,'error_nopermission') AND sid IN ('-2','-1','4') ORDER BY sid ASC
table type possible_keys key key_len ref rows Extra
mybb_cfaforumtemplates ALL 640 Using where; Using filesort
Query Time: 0.0014729499816895
#8 - 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_cfaforumsessions s LEFT JOIN mybb_cfaforumusers u ON (s.uid=u.uid) WHERE s.time>'1369104362' 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 Robmeister89.s.uid 1
Query Time: 0.0011200904846191
#9 - Select Query
SELECT f.*, fr.dateline AS lastread FROM mybb_cfaforumforums f LEFT JOIN mybb_cfaforumforumsread 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 17 Using where; Using filesort
fr eq_ref fid fid 8 Robmeister89.f.fid,const 1
Query Time: 0.00089693069458008
Template Statistics
Templates Used (Loaded for this Page) - 43 Total
global_boardclosed_warning, 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_nopermission, error_nopermission_loggedin, error, index_whosonline_memberbit, forumbit_depth2_cat, nav, nav_bit, nav_bit_active, error_inline, global_bannedwarning, htmldoctype, footer_languageselect, index_boardstats, forumbit_depth2_forum_lastpost, forumbit_depth1_forum_lastpost
Templates Requiring Additional Calls (Not Cached at Startup) - 0 Total
(2013-05-21, 02:58 AM)Grumpy Wrote: [ -> ]That is definitely your hosting mate, just trust me... 9 queries in 6.3 seconds is stupidly slow. It's like an olympic athlete running the 100 metres in 6 minutes...