I did what you guys said with the headers and it didnt remove the white stripe. The stripe shows up in my forums header anyways, I just dont want it to show on myvbindex page.
Query: SELECT template FROM template WHERE title='options'
Time before: 0.067090034484863
Time after: 0.069048047065735
table type possible_keys key key_len ref rows Extra
template ref title title 30 const 1 Using where
--------------------------------------------------------------------------------
Query: SELECT sessionhash,userid,host,useragent,styleid FROM session WHERE lastactivity>1059162995 AND sessionhash='dc0592577954f6fe5d940af59f88d8c3' AND (host='68.41.47.235' OR (althash='' AND althash<>'')) AND useragent='Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;'
Time before: 0.081784009933472
Time after: 0.082612991333008
table type possible_keys key key_len ref rows Extra
session const PRIMARY PRIMARY 32 const 1
--------------------------------------------------------------------------------
Query: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='1'
Time before: 0.083825945854187
Time after: 0.085193991661072
table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1
userfield const PRIMARY PRIMARY 4 const 1
--------------------------------------------------------------------------------
Query: SELECT templatesetid,replacementsetid,userselect FROM style WHERE styleid='1'
Time before: 0.087414979934692
Time after: 0.088251948356628
table type possible_keys key key_len ref rows Extra
style const PRIMARY PRIMARY 2 const 1
--------------------------------------------------------------------------------
Query: SELECT template,title
FROM template
WHERE (title IN ('index','index_header','index_footer','headinclud e','index_welcometext','index_ logincode','index_buddy','index_buddylist','index_ buddypmlink','forumhome_logged inuser','index_online','index_search','index_welco metext_avatar','index_calendar ','index_calendar_todaysevents','index_weather','i ndex_custom1','index_custom2', 'index_stats','index_birthdaybits','index_threadbi t','index_newsbits','index_new s_adminopts','index_news_comments','index_news_com mentnull','index_news_readmore ','index_newsbits_rating','index_newsbits_signatur e','index_newsbits_avatar','in dex_newsbits_sendtofriend','index_newsbits_printab le','showthread_ratingdisplay' ,'index_pollresult','index_polloption_multiple','i ndex_polloption','index_pollop tions','index_pollresults_voted','index_pollresult s_closed','index_pollreview',' index_pollresults','index_polldiscuss','index_poll edit','','gobutton','timezone' ,'username_loggedout','username_loggedin','phpincl ude','headinclude','header','f ooter','forumjumpbit','forumjump','nav_linkoff','n av_linkon','navbar','nav_joine r','pagenav','pagenav_curpage','pagenav_firstlink' ,'pagenav_lastlink','pagenav_n extlink','pagenav_pagelink','pagenav_prevlink','mi crostats')
AND (templatesetid=-1 OR templatesetid=1))
OR (title = 'maxloggedin')
OR (title = 'birthdays')
ORDER BY templatesetid
Time before: 0.089380025863647
Time after: 0.10731399059296
table type possible_keys key key_len ref rows Extra
template range title title 32 131 Using where; Using filesort
--------------------------------------------------------------------------------
Query: update vbstats_counter set count=count+1 where (type='total' and var='hits') or (var='MSIE' and type='browser') or (var='Windows' and type='os')
Time before: 0.1263689994812
Time after: 0.12737095355988
--------------------------------------------------------------------------------
Query: update vbstats_countries set hits = hits+1 where code = 'us'
Time before: 0.12776899337769
Time after: 0.12833797931671
--------------------------------------------------------------------------------
Query: Select date from vbstats_date WHERE date='2003-07-25'
Time before: 0.12861597537994
Time after: 0.12964296340942
table type possible_keys key key_len ref rows Extra
vbstats_date ALL 248 Using where
--------------------------------------------------------------------------------
Query: UPDATE vbstats_date set count = count+1 where date = '2003-07-25'
Time before: 0.13033998012543
Time after: 0.13225495815277
--------------------------------------------------------------------------------
Query: SELECT * FROM usergroup WHERE usergroupid=6
Time before: 0.13749396800995
Time after: 0.13856601715088
table type possible_keys key key_len ref rows Extra
usergroup const PRIMARY PRIMARY 2 const 1
--------------------------------------------------------------------------------
Query: SELECT count(*) AS count FROM post WHERE dateline>='1059152592'
Time before: 0.14228403568268
Time after: 0.35819399356842
table type possible_keys key key_len ref rows Extra
post ALL 26582 Using where
--------------------------------------------------------------------------------
Query: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid='1' AND messageread='0' AND folderid='0'
Time before: 0.35933005809784
Time after: 0.36073505878448
table type possible_keys key key_len ref rows Extra
privatemessage ref userid userid 4 const 45 Using where
--------------------------------------------------------------------------------
Query: SELECT userid,username,invisible,lastactivity,lastvisit FROM user WHERE (user.userid='143' OR user.userid='134' OR user.userid='160' OR user.userid='121' OR user.userid='118') AND lastactivity > 1059162995 AND lastvisit!=lastactivity ORDER BY username
Time before: 0.36296999454498
Time after: 0.36397504806519
table type possible_keys key key_len ref rows Extra
user range PRIMARY PRIMARY 4 5 Using where; Using filesort
--------------------------------------------------------------------------------
Query: SELECT template FROM template WHERE title='index_buddy_none' AND (templatesetid=-1 OR templatesetid=1) ORDER BY templatesetid DESC LIMIT 1
Time before: 0.36498701572418
Time after: 0.36581897735596
table type possible_keys key key_len ref rows Extra
template range title title 32 2 Using where
--------------------------------------------------------------------------------
Query: SELECT COUNT(*) AS sessions FROM session WHERE userid=0 AND lastactivity>1059162995
Time before: 0.36761403083801
Time after: 0.36813902854919
table type possible_keys key key_len ref rows Extra
session ALL 3 Using where
--------------------------------------------------------------------------------
Query: SELECT DISTINCT session.userid,username,invisible,usergroupid
FROM session LEFT JOIN user ON (user.userid=session.userid)
WHERE session.userid>0 AND session.lastactivity>1059162995
ORDER BY invisible ASC, username ASC
Time before: 0.36893403530121
Time after: 0.36982703208923
table type possible_keys key key_len ref rows Extra
session ALL 3 Using where; Using temporary; Using filesort
user eq_ref PRIMARY PRIMARY 4 session.userid 1
--------------------------------------------------------------------------------
Query: SELECT forumid,canview FROM forumpermission WHERE usergroupid='6'
Time before: 0.37197494506836
Time after: 0.37254595756531
table type possible_keys key key_len ref rows Extra
forumpermission ref ugid_fid ugid_fid 2 const 1 Using where
--------------------------------------------------------------------------------
Query: SELECT forumid,parentid,displayorder FROM forum WHERE displayorder<>0 ORDER BY parentid,displayorder
Time before: 0.37338399887085
Time after: 0.37498998641968
table type possible_keys key key_len ref rows Extra
forum ALL 51 Using where; Using filesort
--------------------------------------------------------------------------------
Query: SELECT thread.pollid, open, threadid, replycount, question, poll.dateline, options, votes, active, numberoptions, timeout, multiple, voters
FROM thread
LEFT JOIN poll ON (thread.pollid=poll.pollid)
WHERE forumid='71' AND thread.pollid!='0' ORDER BY poll.pollid DESC LIMIT 1
Time before: 0.37878203392029
Time after: 0.38135600090027
table type possible_keys key key_len ref rows Extra
thread ref forumid forumid 2 const 12 Using where; Using temporary; Using filesort
poll eq_ref PRIMARY PRIMARY 4 thread.pollid 1
--------------------------------------------------------------------------------
Query: SELECT smilietext,smiliepath FROM smilie
Time before: 0.38301599025726
Time after: 0.38529205322266
table type possible_keys key key_len ref rows Extra
smilie ALL 193
--------------------------------------------------------------------------------
Query: SELECT pollvoteid FROM pollvote WHERE userid='1' AND pollid='92'
Time before: 0.4006199836731
Time after: 0.40136098861694
table type possible_keys key key_len ref rows Extra
pollvote ref userid userid 8 const,const 1 Using where
--------------------------------------------------------------------------------
Query: SELECT
threadid,thread.title,replycount,postusername,post userid,dateline,views,lastpost er,lastpost,thread.iconid as iconid,icon.title as icontitle,icon.iconpath as iconpath
FROM thread
LEFT JOIN icon ON icon.iconid=thread.iconid
WHERE open<>10 ORDER BY lastpost DESC LIMIT 10
Time before: 0.43457794189453
Time after: 0.45274901390076
table type possible_keys key key_len ref rows Extra
thread ALL 2639 Using where; Using filesort
icon eq_ref PRIMARY PRIMARY 2 thread.iconid 1
--------------------------------------------------------------------------------
Query: SELECT thread.threadid,thread.title,replycount,postuserna me,postuserid,thread.dateline, views,thread.iconid,votenum,votetotal,postid,paget ext,allowsmilie,showsignature, signature ,thread.iconid as iconid,icon.title as icontitle,icon.iconpath as iconpath
FROM thread
LEFT JOIN post ON (thread.threadid=post.threadid)
LEFT JOIN user ON (user.userid=post.userid)
LEFT JOIN icon ON icon.iconid=thread.iconid
WHERE forumid='66' AND isnews='Y' AND open<>10
GROUP BY thread.threadid
ORDER BY thread.threadid DESC LIMIT 10
Time before: 0.46166598796844
Time after: 0.46672296524048
table type possible_keys key key_len ref rows Extra
thread ref forumid forumid 2 const 8 Using where; Using temporary; Using filesort
post ref threadid threadid 4 thread.threadid 11 Using where
user eq_ref PRIMARY PRIMARY 4 post.userid 1
icon eq_ref PRIMARY PRIMARY 2 thread.iconid 1
--------------------------------------------------------------------------------
Query: SELECT bbcodetag,bbcodereplacement,twoparams FROM bbcode
Time before: 0.48248398303986
Time after: 0.48327898979187
table type possible_keys key key_len ref rows Extra
bbcode ALL 9
--------------------------------------------------------------------------------
Query: SELECT eventdate,subject,eventid,public FROM calendar_events WHERE eventdate LIKE '2003-07-%' AND ((userid='1' AND public='0') OR (public='1'))
Time before: 0.76708197593689
Time after: 0.76792299747467
table type possible_keys key key_len ref rows Extra
calendar_events ALL userid 12 Using where
--------------------------------------------------------------------------------
Query: SELECT template FROM template WHERE title='index_rotm' AND (templatesetid=-1 OR templatesetid=1) ORDER BY templatesetid DESC LIMIT 1
Time before: 0.77690303325653
Time after: 0.77811396121979
table type possible_keys key key_len ref rows Extra
template range title title 32 2 Using where
--------------------------------------------------------------------------------
Query:
SELECT findword, replaceword, replacementsetid
FROM replacement
WHERE replacementsetid IN(-1, '1')
ORDER BY replacementsetid, replacementid DESC
Time before: 0.79495394229889
Time after: 0.79683399200439
table type possible_keys key key_len ref rows Extra
replacement ALL replacementsetid 56 Using where; Using filesort
--------------------------------------------------------------------------------
Page generated in 0.78423702716827 seconds with 27 queries,
spending 0.28480398654938 doing MySQL queries and 0.4994330406189 doing PHP things.
Query: UPDATE session SET lastactivity=1059163895,location='/index.php?explain=1' WHERE sessionhash='dc0592577954f6fe5d940af59f88d8c3' Time before: 0.82737004756927 Time after: 0.8279869556427
--------------------------------------------------------------------------------
Query: UPDATE user SET lastactivity=1059163895,inforum='0' WHERE userid='1' Time before: 0.82818400859833 Time after: 0.82877898216248
|
More Information