vb.org Archive - View Single Post

arracing · #**1550** 07-25-2003, 08:42 PM

Also here is the explain thing for my forums, can you show me how to get rid of some queries their?

Query: SELECT template FROM template WHERE title='options'
Time before: 0.07497501373291
Time after: 0.07695198059082

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>1059168462 AND sessionhash='91adba9914cb16019f205696dda10b35' 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.09148097038269
Time after: 0.092326998710632

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.093616008758545
Time after: 0.095041990280151

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.097440004348755
Time after: 0.098170042037964

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 ('forumhome_birthdaybit','error_nopermission','for umhome_pmloggedin','forumhome_ welcometext','forumhome_logoutcode','forumhome_new posts','forumhome_todayposts', 'forumhome_logincode','forumhome_loggedinuser','fo rumhome_loggedinusers','forumh ome_lastpostby','forumhome_moderator','forumhome_f orumbit_level1_nopost','forumh ome_forumbit_level1_post','forumhome_forumbit_leve l2_nopost','forumhome_forumbit _level2_post','forumhome','forumhome_unregmessage' ,'index_rotm','index_buddy_non e','gobutton','timezone','username_loggedout','use rname_loggedin','phpinclude',' headinclude','header','footer','forumjumpbit','for umjump','nav_linkoff','nav_lin kon','navbar','nav_joiner','pagenav','pagenav_curp age','pagenav_firstlink','page nav_lastlink','pagenav_nextlink','pagenav_pagelink ','pagenav_prevlink','microsta ts')
AND (templatesetid=-1 OR templatesetid=1))
OR (title = 'maxloggedin')
OR (title = 'birthdays')
ORDER BY templatesetid
Time before: 0.099313974380493
Time after: 0.11214196681976

table type possible_keys key key_len ref rows Extra
template range title title 32 87 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.1307510137558
Time after: 0.13244700431824

--------------------------------------------------------------------------------

Query: update vbstats_countries set hits = hits+1 where code = 'us'
Time before: 0.13284802436829
Time after: 0.13345098495483

--------------------------------------------------------------------------------

Query: Select date from vbstats_date WHERE date='2003-07-25'
Time before: 0.13375794887543
Time after: 0.13481605052948

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.13570702075958
Time after: 0.13771498203278

--------------------------------------------------------------------------------

Query: SELECT * FROM usergroup WHERE usergroupid=6
Time before: 0.14379394054413
Time after: 0.14503705501556

table type possible_keys key key_len ref rows Extra
usergroup const PRIMARY PRIMARY 2 const 1

--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1
Time before: 0.14890003204346
Time after: 0.14967596530914

table type possible_keys key key_len ref rows Extra
privatemessage ref userid userid 4 const 45 Using where; Using index

--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1 AND dateline>1059165043 AND folderid=0
Time before: 0.15060794353485
Time after: 0.15190196037292

table type possible_keys key key_len ref rows Extra
privatemessage ref userid userid 4 const 45 Using where

--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1 AND messageread=0 AND folderid=0
Time before: 0.15289795398712
Time after: 0.15412402153015

table type possible_keys key key_len ref rows Extra
privatemessage ref userid userid 4 const 45 Using where

--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS users,MAX(userid) AS max FROM user
Time before: 0.15628504753113
Time after: 0.15683901309967

table type possible_keys key key_len ref rows Extra

--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS posts FROM post
Time before: 0.15768694877625
Time after: 0.15807497501373

table type possible_keys key key_len ref rows Extra

--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS threads FROM thread
Time before: 0.15872097015381
Time after: 0.15909194946289

table type possible_keys key key_len ref rows Extra

--------------------------------------------------------------------------------

Query: SELECT userid,username FROM user WHERE userid=390
Time before: 0.15973997116089
Time after: 0.16027796268463

table type possible_keys key key_len ref rows Extra
user const PRIMARY PRIMARY 4 const 1

--------------------------------------------------------------------------------

Query: SELECT * FROM forum WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder
Time before: 0.16230797767639
Time after: 0.16545104980469

table type possible_keys key key_len ref rows Extra
forum ALL 51 Using where; Using filesort

--------------------------------------------------------------------------------

Query: SELECT forumid,canview,canpostnew FROM forumpermission WHERE usergroupid='6'
Time before: 0.17623496055603
Time after: 0.17706000804901

table type possible_keys key key_len ref rows Extra
forumpermission ref ugid_fid ugid_fid 2 const 1 Using where

--------------------------------------------------------------------------------

Query: SELECT forumid,accessmask FROM access WHERE userid='1'
Time before: 0.17811703681946
Time after: 0.17866396903992

table type possible_keys key key_len ref rows Extra
access ref userid userid 4 const 1 Using where

--------------------------------------------------------------------------------

Query: SELECT user.userid,user.username,moderator.forumid
FROM moderator
LEFT JOIN user
ON (moderator.userid=user.userid)
ORDER BY user.username
Time before: 0.17950904369354
Time after: 0.18144702911377

table type possible_keys key key_len ref rows Extra
moderator index userid 6 42 Using index; Using temporary; Using filesort
user eq_ref PRIMARY PRIMARY 4 moderator.userid 1

--------------------------------------------------------------------------------

Query: SELECT COUNT(*) AS sessions FROM session WHERE userid=0 AND lastactivity>1059168462
Time before: 0.18493902683258
Time after: 0.18557298183441

table type possible_keys key key_len ref rows Extra
session ALL 4 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>1059168462
ORDER BY invisible ASC, username ASC
Time before: 0.29781603813171
Time after: 0.29889500141144

table type possible_keys key key_len ref rows Extra
session ALL 4 Using where; Using temporary; Using filesort
user eq_ref PRIMARY PRIMARY 4 session.userid 1

--------------------------------------------------------------------------------

Query:
SELECT findword, replaceword, replacementsetid
FROM replacement
WHERE replacementsetid IN(-1, '1')
ORDER BY replacementsetid, replacementid DESC

Time before: 0.42030394077301
Time after: 0.42234098911285

table type possible_keys key key_len ref rows Extra
replacement ALL replacementsetid 56 Using where; Using filesort

--------------------------------------------------------------------------------

Page generated in 0.40744400024414 seconds with 24 queries,
spending 0.039765119552612 doing MySQL queries and 0.36767888069153 doing PHP things.
Query: UPDATE session SET lastactivity=1059169362,location='/forums/index.php?explain=1' WHERE sessionhash='91adba9914cb16019f205696dda10b35' Time before: 0.47847700119019 Time after: 0.47915899753571
--------------------------------------------------------------------------------
Query: UPDATE user SET lastactivity=1059169362,inforum='0' WHERE userid='1' Time before: 0.47937405109406 Time after: 0.48000800609589

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02602 seconds Memory Usage 1,814KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_onlinestatus (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start showpost_complete
Messages: