The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
|||||||
|
#34
11-15-2002, 05:51 PM
|
||||
|
||||
I hate to jump in but i'm having simular issues with my index page. this line appears several times which has jumped my queries on my index page to a shocking 90 queries!
Query: SELECT template FROM template WHERE title='options' Time before: 0.028990030288696 Time after: 0.030089020729065 Query: SELECT sessionhash,userid,host,useragent,styleid FROM session WHERE lastactivity>1037380414 AND sessionhash='57565ca59c79463a10c80c458c712492' AND host='24.52.238.196' AND useragent='Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;' Time before: 0.036381006240845 Time after: 0.036906003952026 Query: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='1' Time before: 0.037148952484131 Time after: 0.038058996200562 Query: UPDATE user SET timeonline=timeonline+214 WHERE userid='1' Time before: 0.038669943809509 Time after: 0.038979053497314 Query: SELECT templatesetid,replacementsetid,userselect FROM style WHERE styleid='24' Time before: 0.03931999206543 Time after: 0.039639949798584 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_todayloggedinuser ','forumhome_todayloggedinuser s','forumhome_loggedinuser','forumhome_loggedinuse rs','forumhome_lastpostby','fo rumhome_moderator','forumhome_forumbit_level1_nopo st','forumhome_forumbit_level1 _post','forumhome_forumbit_level2_nopost','forumho me_forumbit_level2_post','foru mhome','forumhome_unregmessage','gobutton','timezo ne','username_loggedout','user name_loggedin','phpinclude','headinclude','header' ,'footer','forumjumpbit','foru mjump','nav_linkoff','nav_linkon','navbar','nav_jo iner','pagenav','pagenav_curpa ge','pagenav_firstlink','pagenav_lastlink','pagena v_nextlink','pagenav_pagelink' ,'pagenav_prevlink','home_microstats') AND (templatesetid=-1 OR templatesetid='19')) OR (title = 'maxloggedin') OR (title = 'birthdays') ORDER BY templatesetid Time before: 0.0398850440979 Time after: 0.053624987602234 Query: SELECT COUNT(*) AS count FROM session WHERE userid=0 AND lastactivity>1037380414 Time before: 0.056285977363586 Time after: 0.056926965713501 Query: SELECT COUNT(DISTINCT(userid)) AS count FROM session WHERE session.userid>0 AND session.lastactivity>1037380414 Time before: 0.05706000328064 Time after: 0.057842969894409 Query: SELECT * FROM usergroup WHERE usergroupid=6 Time before: 0.060628056526184 Time after: 0.061303973197937 Query: SELECT template FROM template WHERE title='memberoftheday' AND templatesetid=-2 Time before: 0.064283013343811 Time after: 0.06466805934906 Query: SELECT user.avatarid,avatarpath,NOT ISNULL(avatardata) AS hascustom,customavatar.dateline FROM user LEFT JOIN avatar ON avatar.avatarid=user.avatarid LEFT JOIN customavatar ON customavatar.userid=user.userid WHERE user.userid='1' Time before: 0.064878940582275 Time after: 0.066051959991455 Query: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1 Time before: 0.066372036933899 Time after: 0.066789031028748 Query: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1 AND dateline>1037344130 AND folderid=0 Time before: 0.066923022270203 Time after: 0.067540049552917 Query: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1 AND messageread=0 AND folderid=0 Time before: 0.067765951156616 Time after: 0.068228006362915 Query: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1 AND folderid=0 Time before: 0.068578958511353 Time after: 0.069056034088135 Query: SELECT COUNT(*) AS users,MAX(userid) AS max FROM user Time before: 0.070255994796753 Time after: 0.070462942123413 Query: SELECT COUNT(*) AS users,MAX(userid) AS max FROM user WHERE posts=0 Time before: 0.070605993270874 Time after: 0.072136998176575 Query: SELECT COUNT(*) AS users,MAX(userid) FROM user WHERE posts=1 Time before: 0.072307944297791 Time after: 0.073686003684998 Query: SELECT COUNT(*) AS users,MAX(userid) AS max FROM user WHERE joindate Query: SELECT userid,username,posts FROM user ORDER BY posts DESC LIMIT 10 Time before: 0.075706005096436 Time after: 0.077715039253235 Query: SELECT DISTINCT(userid),COUNT(postid) AS posts FROM post WHERE userid > 0 AND post.dateline>=1037303014 GROUP BY userid ORDER BY posts DESC LIMIT 10 Time before: 0.078215003013611 Time after: 0.14599597454071 Query: SELECT username FROM user WHERE userid=142 Time before: 0.14624905586243 Time after: 0.1465630531311 Query: SELECT username FROM user WHERE userid=173 Time before: 0.14674603939056 Time after: 0.1471780538559 Query: SELECT username FROM user WHERE userid=164 Time before: 0.14748001098633 Time after: 0.14765405654907 Query: SELECT username FROM user WHERE userid=71 Time before: 0.1478099822998 Time after: 0.14804303646088 Query: SELECT username FROM user WHERE userid=132 Time before: 0.14824604988098 Time after: 0.14847004413605 Query: SELECT username FROM user WHERE userid=5 Time before: 0.14866399765015 Time after: 0.14887797832489 Query: SELECT username FROM user WHERE userid=16 Time before: 0.14907598495483 Time after: 0.14929699897766 Query: SELECT username FROM user WHERE userid=114 Time before: 0.14949202537537 Time after: 0.14970302581787 Query: SELECT username FROM user WHERE userid=40 Time before: 0.14989900588989 Time after: 0.15011298656464 Query: SELECT username FROM user WHERE userid=179 Time before: 0.15030801296234 Time after: 0.15053200721741 Query: SELECT template FROM template WHERE title='g_statistics' AND (templatesetid=-1 OR templatesetid='19') ORDER BY templatesetid DESC LIMIT 1 Time before: 0.15075099468231 Time after: 0.15162599086761 Query: SELECT username,userid,timeonline FROM user WHERE userid > 1 ORDER BY timeonline DESC LIMIT 1 Time before: 0.15185904502869 Time after: 0.15404903888702 Query: SELECT postid AS posts FROM post ORDER BY postid DESC LIMIT 1 Time before: 0.15432798862457 Time after: 0.15449500083923 Query: SELECT threadid AS threads FROM thread ORDER BY threadid DESC LIMIT 1 Time before: 0.15462899208069 Time after: 0.15504205226898 Query: SELECT userid,username FROM user WHERE userid=181 Time before: 0.15522801876068 Time after: 0.15545797348022 Query: SELECT COUNT(*) AS threads FROM thread WHERE lastpost > '1037344130' Time before: 0.15562796592712 Time after: 0.15971195697784 Query: SELECT count(*) AS posts FROM post WHERE dateline > '1037344130' Time before: 0.15988099575043 Time after: 0.19722998142242 Query: SELECT style.title, user.styleid, COUNT(*) AS count FROM user LEFT JOIN style USING (styleid) WHERE style.styleid IS NOT NULL AND style.userselect=1 GROUP BY user.styleid Time before: 0.19739603996277 Time after: 0.20033705234528 Query: SELECT template FROM template WHERE title='forumhome_dropdownbit' AND (templatesetid=-1 OR templatesetid='19') ORDER BY templatesetid DESC LIMIT 1 Time before: 0.20062303543091 Time after: 0.20155501365662 Query: SELECT * FROM forum WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder Time before: 0.20349204540253 Time after: 0.20521998405457 Query: SELECT forumid,canview,canpostnew FROM forumpermission WHERE usergroupid='6' Time before: 0.21054005622864 Time after: 0.21099603176117 Query: SELECT forumid,accessmask FROM access WHERE userid='1' Time before: 0.21127700805664 Time after: 0.21157097816467 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.21170401573181 Time after: 0.21375501155853 Query: SELECT COUNT(*) AS sessions FROM session WHERE userid=0 AND lastactivity>1037380415 Time before: 0.21618103981018 Time after: 0.21690499782562 Query: SELECT COUNT(*) AS sessions FROM session WHERE userid>0 AND lastactivity>1037380415 Time before: 0.21703994274139 Time after: 0.2175829410553 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>1037380415 ORDER BY invisible ASC, username ASC Time before: 0.21829295158386 Time after: 0.21945405006409 Query: SELECT userid, username, usergroupid, lastactivity, invisible FROM user WHERE lastactivity > 1037343600 ORDER BY username Time before: 0.22246098518372 Time after: 0.22455894947052 Query: SELECT COUNT(*) AS count, inforum FROM user WHERE lastactivity>1037380414 AND lastvisit<>lastactivity GROUP BY inforum Time before: 0.23457598686218 Time after: 0.236083984375 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=3 Time before: 0.23655498027802 Time after: 0.23730397224426 Query: SELECT template FROM template WHERE title='forumhome_newforumthreads' AND (templatesetid=-1 OR templatesetid='19') ORDER BY templatesetid DESC LIMIT 1 Time before: 0.23760294914246 Time after: 0.23877704143524 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=4 Time before: 0.24047100543976 Time after: 0.24087905883789 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=53 Time before: 0.24284100532532 Time after: 0.24322700500488 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=35 Time before: 0.24459004402161 Time after: 0.24491202831268 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=20 Time before: 0.24664103984833 Time after: 0.2471729516983 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=37 Time before: 0.24912095069885 Time after: 0.24941897392273 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=38 Time before: 0.2509800195694 Time after: 0.25136005878448 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=26 Time before: 0.25331604480743 Time after: 0.25352001190186 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=27 Time before: 0.25516498088837 Time after: 0.25558400154114 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=28 Time before: 0.25710201263428 Time after: 0.25764095783234 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=29 Time before: 0.25941598415375 Time after: 0.2599960565567 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=1 Time before: 0.26179897785187 Time after: 0.26199495792389 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=2 Time before: 0.26357901096344 Time after: 0.26453304290771 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=33 Time before: 0.26654398441315 Time after: 0.26704895496368 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=32 Time before: 0.26881396770477 Time after: 0.27069997787476 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=5 Time before: 0.27237796783447 Time after: 0.27317702770233 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=44 Time before: 0.27496600151062 Time after: 0.27517104148865 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=34 Time before: 0.27671599388123 Time after: 0.27701604366302 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=6 Time before: 0.27877295017242 Time after: 0.27897298336029 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=7 Time before: 0.28059005737305 Time after: 0.28095495700836 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=40 Time before: 0.28271305561066 Time after: 0.28316497802734 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=21 Time before: 0.28473496437073 Time after: 0.28509998321533 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=30 Time before: 0.28676199913025 Time after: 0.28702199459076 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=8 Time before: 0.28881895542145 Time after: 0.28944098949432 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=10 Time before: 0.29133296012878 Time after: 0.29168200492859 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=39 Time before: 0.29352200031281 Time after: 0.29386496543884 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=9 Time before: 0.29544997215271 Time after: 0.29576897621155 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=11 Time before: 0.29733800888062 Time after: 0.29765200614929 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=12 Time before: 0.29985797405243 Time after: 0.30007195472717 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=13 Time before: 0.30181300640106 Time after: 0.30256700515747 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=43 Time before: 0.30449604988098 Time after: 0.30477404594421 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=14 Time before: 0.3062299489975 Time after: 0.30673694610596 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=15 Time before: 0.308434009552 Time after: 0.30870294570923 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=17 Time before: 0.31029105186462 Time after: 0.31058895587921 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=16 Time before: 0.31226694583893 Time after: 0.31331396102905 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=18 Time before: 0.31527101993561 Time after: 0.31547796726227 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=19 Time before: 0.31704497337341 Time after: 0.32025003433228 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=36 Time before: 0.32246005535126 Time after: 0.32312798500061 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=23 Time before: 0.32481598854065 Time after: 0.32508099079132 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=25 Time before: 0.32689094543457 Time after: 0.32720601558685 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=24 Time before: 0.32884502410889 Time after: 0.32937395572662 Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=22 Time before: 0.33109605312347 Time after: 0.33147799968719 Query: SELECT findword,replaceword FROM replacement WHERE replacementsetid IN(-1,'20') ORDER BY replacementsetid DESC,replacementid DESC Time before: 0.34253704547882 Time after: 0.34418594837189 
|
«
Previous Thread
|
Next Thread
»
| Thread Tools | |
| Display Modes | |
Threaded Mode
|
|
All times are GMT. The time now is 08:14 PM.