Quote:

SELECT t1.B_Number,t2.U_Username,t1.B_Posted,t1.B_IP,t1.B_Subject,t1.B_Body,t1.B_File,t1.B_Status,t2.U_Picture,t1.B_Reged,t2.U_Title,t2.U_Color,t1.B_Icon,t1.B_Poll,t1.B_Parent,t2.U_Status,t2.U_Signature,t1.B_LastEdit,t1.B_LastEditBy,t2.U_Location,t2.U_Totalposts,t2.U_Registered,t2.U_PicWidth,t2.U_PicHeight,t2.U_Number,t1.B_FileCounter,t1.B_ParentUser,t2.U_Birthday,t1.B_AddSig,t2.U_Laston,t2.U_GradStart,t2.U_GradEnd,t2.U_Groups,t2.U_FAH,t2.U_Prefs,t1.B_Mood,t2.U_GRate,t2.U_TRate,t2.U_GTotal,t2.U_TTotal,t2.U_Normalized,t2.U_NoRate FROM w3t_Posts AS t1 LEFT JOIN w3t_Users AS t2 ON t1.B_PosterId = t2.U_Number WHERE t1.B_Main = 11293791 ORDER BY B_Number LIMIT 20, 20 took 0.003
SELECT COUNT(*) FROM w3t_Posts WHERE B_Board = '23' AND B_Topic = 2 took 0.012
SELECT W_Word, W_Freq FROM w3t_WordFreq WHERE W_Board = '23' AND W_Word IN ('JST','RMMP','SMN','KMPLN','APT','0N','PRT','MT','PRF','RMF','PN','KS','TK','FRM','FT','TST','TM','LF','NPSP','PL','MN','KT','PT','RL','AMPRS','SRPRS','0T','HPN','TKTR','ST','ANNK','PS','A0','SM','STF','S','HL','PK','PRSNL','0NK','TR','P','ANPRS','KRT','ARK','A0N','JF','ATFK','SPNT','TL','ANFSTK','TRT','MK','APRS','AKSPKT','ANTRNT','MMPR','0R','PLNT','APF','HR','ANTL','TSS','APR','MNK','LFT','AR','0','PLS','TRF','A','KNTRPTR','ARKR','SLK','XRMR','SNTR','HP','KM','PRFT','TNM','PRSNK','APL','ANTRKT','TRPLXT','KR','SKNT','NN','HF','AT','ALT','KLTL','ALKM','AN','LTR','JNR','PRSN','TSTRKT','K','0S','SRFK','AL','SNRK','PRTX','HMR','A0NK','KN','MS','ANT','MKFLKS','SNT','LK','RTKL','RMR','ARNT','H','TNT','AFN','N','TLK') took 0.032
SELECT t1.B_Number, t1.B_Last_Post, t1.B_LastPostNum, t1.B_Subject, t1.B_Icon, t1.B_PosterId, t1.B_Counter, t1.B_Replies, t1.B_Reged AS PostReged, t2.U_Username, t2.U_Status, t2.U_GradStart, t2.U_GradEnd, t2.U_Groups, t2.U_Prefs, t3.U_Username AS U_ReplierName, t4.B_Reged AS ReplyReged FROM w3t_Posts AS t1, w3t_Users AS t2, w3t_Users AS t3, w3t_Posts AS t4 WHERE t1.B_PosterId = t2.U_Number AND t1.B_LastPosterId = t3.U_Number AND t4.B_Number = t1.B_LastPostNum AND t1.B_Number IN (10374804, 8349214, 9165901, 5398355, 9837823, 10058892, 9729315, 10296600) ORDER BY FIELD(t1.B_Number, 10374804, 8349214, 9165901, 5398355, 9837823, 10058892, 9729315, 10296600) took 0.004
Shroomery Forums Main Site
UPDATE w3t_Users SET U_Laston = '1256543523' WHERE U_Number = 155900 took 0.065
Welcome makaveli8x8

    * None
    * Amused
    * Angry
    * Bored
    * Busy
    * Confused
    * Crankey
    * Cynical
    * Depressed
    * Drunk
    * Excited
    * Happy
    * Horny
    * Hung Over
    * In Love
    * Lonely
    * Medicated
    * Messed Up
    * Nervous
    * Nodding
    * Relaxed
    * Sad
    * Sick
    * Sober
    * Stoned
    * Stressed
    * Tired
    * Tripping


Account · Pics · Threads · Journal · Messages · [Logout] Forum Index Search Posts Active Topics Active Journals Galleries Who's Online FAQ User List Invite Calendar Chat Arcade Store Random Growery


Please support our sponsors.

SELECT B_Number, B_Subject, B_Posted, B_Reged, B_PosterId, U_Username FROM w3t_Posts, w3t_Users WHERE B_Posterid = U_Number AND B_Main = 11293791 ORDER BY B_Number ASC took 0.002

---

Quote:

Total Time: 0.755
Query: SELECT U_Groups, U_TimeOffset,U_TimeFormat,U_LastOn,U_BannedForums,U_Ignored,U_Username,U_Password,U_SessionId,U_StyleSheet,U_Status,U_Privates,U_Number,U_Banned,U_LastOn,U_Groups,U_BanOver,U_Mood,U_Totalposts,U_Registered,U_LastPostIP,U_Prefs,U_TimeFormat,U_TimeOffset,U_Agent,U_Key FROM w3t_Users WHERE U_Number = '155900'
Process List:**********************************************************************


Total Time: 0.005
Query: SELECT t1.Mod_Board,t1.Mod_Uid,t2.U_Username
FROM w3t_Moderators AS t1,
w3t_Users AS t2
WHERE t1.Mod_Uid = t2.U_Number
Process List:**********************************************************************


Total Time: 0.01
Query: SELECT t1.Bo_Title,t1.Bo_Description,t1.Bo_Keyword,t1.Bo_Total,t1.Bo_Last,t1.Bo_Number,t1.Bo_Moderated,t1.Bo_Read_Perm,t1.Bo_Write_Perm,t1.Bo_Threads,t1.Bo_Sorter,t1.Bo_Posterid,t1.Bo_LastMain,t1.Bo_LastNumber,t2.U_Username,t3.B_Subject,t3.B_Icon,t3.B_Reged,t1.Bo_Image,t1.Bo_Cat,t1.Bo_Parent
FROM w3t_Boards AS t1
LEFT JOIN w3t_Users AS t2 ON t1.Bo_Posterid = t2.U_Number
LEFT JOIN w3t_Posts AS t3 ON t1.Bo_LastNumber = t3.B_Number
WHERE t1.Bo_Active = '1'
AND t1.Bo_Cat = '4'
AND t1.Bo_Parent != ''
AND (Bo_Read_Perm LIKE '%-3-%' OR Bo_Read_Perm LIKE '%-6-%' OR Bo_Read_Perm LIKE '%-15-%' OR Bo_Read_Perm LIKE '%-16-%' OR Bo_Read_Perm LIKE '%-18-%' OR Bo_Read_Perm LIKE '%-25-%' OR Bo_Read_Perm LIKE '%-36-%')
ORDER BY t1.Bo_Sorter
Process List:**********************************************************************


Total Time: 0.002
Query: SELECT t1.B_Number, t1.B_Parent, t2.U_Username, t1.B_Posted, t1.B_Subject, t1.B_Main, t1.B_Status, t1.B_Icon, t1.B_Reged, t1.B_Counter, t1.B_Replies, t2.U_Color, t2.U_Status, t1.B_PosterId, t1.B_File, t2.U_Number, t1.B_Sticky, t1.B_LastPosterId, t1.B_LastPostNum, t1.B_Last_Post, t1.B_Poll, t1.B_CalDay, t2.U_GradStart, t2.U_GradEnd, t2.U_Groups, t1.B_PostCategory, t1.B_Board, t1.B_Journal, t2.U_Prefs
FROM w3t_Posts AS t1, w3t_Users AS t2, w3t_Announcements AS t3
WHERE t1.B_Number = t3.A_Topic
AND t3.A_Board IN ('7','ubbt_all_forums')
AND t1.B_PosterId = t2.U_Number

ORDER BY t3.A_Board ASC, t1.B_Last_Post DESC
Process List:**********************************************************************


Total Time: 0.054
Query: SELECT t1.B_Number,t1.B_Parent,t2.U_Username,t1.B_Posted,t1.B_Subject,t1.B_Main,t1.B_Status,t1.B_Icon,t1.B_Reged,t1.B_Counter,t1.B_Replies,t2.U_Color,t2.U_Status,t1.B_PosterId,t1.B_File,t2.U_Number,t1.B_Sticky,t1.B_LastPosterId,t1.B_LastPostNum,t1.B_Last_Post,t1.B_Poll,t1.B_CalDay,t2.U_GradStart,t2.U_GradEnd,t2.U_Groups,t1.B_PostCategory,t1.B_Board,t1.B_Journal,t2.U_Prefs
FROM w3t_Posts AS t1,
w3t_Users AS t2
WHERE t1.B_Topic = 2

AND t1.B_Board = '7'
AND t1.B_PosterId = t2.U_Number
AND t1.B_Sticky = '0'
AND (B_PosterId NOT IN (176819) OR B_Reged = 'n')



ORDER BY t1.B_Last_Post DESC
LIMIT 49
Process List:**********************************************************************


Total Time: 0.189
Query: SELECT COUNT(*)
FROM w3t_Posts
WHERE B_Main='11272628'
AND B_Posted > '1256407638'
AND B_PosterId NOT IN ('176819')
Process List:**********************************************************************


Total Time: 0.009
Query: SELECT COUNT(*)
FROM w3t_Posts
WHERE B_Main='11247826'
AND B_Posted > '1256407638'
AND B_PosterId NOT IN ('176819')
Process List:**********************************************************************


Total Time: 0.004
Query: SELECT Mod_Uid, Bo_Title FROM w3t_Moderators, w3t_Boards WHERE Mod_Board = Bo_Number
Process List:**********************************************************************


Total Time: 0.006
Query: SELECT COUNT(*)
FROM w3t_Posts
WHERE B_Main='11285504'
AND B_Posted > '1256407638'
AND B_PosterId NOT IN ('176819')
Process List:**********************************************************************


Total Time: 0.011
Query: SELECT COUNT(*)
FROM w3t_Posts
WHERE B_Main='11283743'
AND B_Posted > '1256407638'
AND B_PosterId NOT IN ('176819')
Process List:**********************************************************************


Total Time: 0.066
Query: SELECT U_Number,U_Username
FROM w3t_Users
WHERE U_Number IN ('7918','155900','197325','102938','2','10279','180370','145982','209848','191134','148829','114588','139015','127896','127466','212114','119790','115593','1636','216083','158741','144366','154650','104708','158050','116083','110725','11544','208873','161687')
Process List:**********************************************************************


Shroomery Forums Main Site
Total Time: 0.003
Query: SELECT MAX(t1.B_Posted), t2.L_Last
FROM w3t_Posts AS t1, w3t_Last AS t2
WHERE t1.B_Journal = t2.L_Uid
AND t1.B_PosterId != '155900'
AND t2.L_Board = 'j155900'
AND t2.L_Uid = '155900'
Process List:**********************************************************************


Total Time: 0.007
Query: UPDATE w3t_Users SET U_Laston = '1256543682' WHERE U_Number = 155900
Process List:**********************************************************************

---

Quote:

Total Time: 0.002
Query: SELECT t1.B_Number,t2.U_Username,t1.B_Posted,t1.B_IP,t1.B_Subject,t1.B_Body,t1.B_File,t1.B_Status,t2.U_Picture,t1.B_Reged,t2.U_Title,t2.U_Color,t1.B_Icon,t1.B_Poll,t1.B_Parent,t2.U_Status,t2.U_Signature,t1.B_LastEdit,t1.B_LastEditBy,t2.U_Location,t2.U_Totalposts,t2.U_Registered,t2.U_PicWidth,t2.U_PicHeight,t2.U_Number,t1.B_FileCounter,t1.B_ParentUser,t2.U_Birthday,t1.B_AddSig,t2.U_Laston,t2.U_GradStart,t2.U_GradEnd,t2.U_Groups,t2.U_FAH,t2.U_Prefs,t1.B_Mood,t2.U_GRate,t2.U_TRate,t2.U_GTotal,t2.U_TTotal,t2.U_Normalized,t2.U_NoRate
FROM w3t_Posts AS t1
LEFT JOIN w3t_Users AS t2 ON t1.B_PosterId = t2.U_Number
WHERE t1.B_Main = 11322369

ORDER BY B_Number
LIMIT 50
Process List:**********************************************************************


Total Time: 0.006
Query: SELECT COUNT(*) FROM w3t_Posts WHERE B_Board = '7' AND B_Topic = 2
Process List:**********************************************************************


Total Time: 0.014
Query: SELECT W_Word, W_Freq FROM w3t_WordFreq WHERE W_Board = '7' AND W_Word IN ('KTTNK','KNT','KRS','XT','HPN','NPSP','KLK','LNK','KT','AT','PJ','A0R','TM','0','LT','PNX','LK','SLKT','NMR','ASRNM','PST','SPJKT','PT','FL','STT','PKTR','RJ','TTL','KLR','AKN','PL','PRNT','SNTR','LSTTT','LSTTTP','LKT','TTLPST','RJST','PKT','PXT','FLKNT','PRNTS','PR0T','ATSK','LSTN','KRTSTRT','KRTNT','KRP','PRF','MT','KRT','TRT','KTTL','NRML','NRT','FRM','LFT','JN','ASR','PSTRT','AR','MN','ARTR','LMT','TK','PRT','TPK','ART','FRK','ARTFRK','RMP','KMPLN','AMPR','SRPR','TKTR','ANK','PRSNL','ANPR','ATFK','SPNT','ANFSTK','APR','AKSPKT','ANTRNT','MPR','PLNT','ANTL','NTRPTR','ARKR','SRMR','PRFT','PRSNK','ANTRKT','TRPLKST','SKNT','KLTL','ALKM','PRSN','TSTRKT','SRFK','SNRK','PRTKS','MKFLK','RTKL','ARNT','LST','LSTPSTNM','KNTR','RPL','PSTRK','RPLRNM','RPLRK','LSTPSTRT','FLT','XRMR','ST','APTT','MKFLKS','NN','AMS','ANKR','PR','PS','KNFS','KRNK','SNK','TPRS','TRNK','AKST','HP','HRN','HNK','AFR','LF','LN','MTK','MS','NRF','NT','RLKS','SK','SPR','STN','STRS','TR','TRP','AKNT','PK','0RT','JRNL','MSK','ANTKS','SRX','AKTF','A','ANLN','ANFT','KLNTR','ARKT','STR','RNTM','KRR','PLS','SPRT','SPNSR','AFTR','0T','KR','TMFST','TMFRMT','PNTFRM','AKNR','PSRT','SSNT','STLXT','PN','PNF','LSTPSTP','AJNT','PRSS','MTR','TSKPT','RT','PRM','SRTR','LSTMN','LSTNM','AMK','STK','KLT','PSTKTKR','ANNK','APT','TSK','J','SM','HR','FK','K','HF','NFR','SN','PKS','SRF','A0','ANKRPT','ARK','TKST','KM','A0N')
Process List:**********************************************************************


Total Time: 0.006
Query: SELECT t1.B_Number, t1.B_Last_Post, t1.B_LastPostNum, t1.B_Subject, t1.B_Icon, t1.B_PosterId, t1.B_Counter, t1.B_Replies, t1.B_Reged AS PostReged, t2.U_Username, t2.U_Status, t2.U_GradStart, t2.U_GradEnd, t2.U_Groups, t2.U_Prefs, t3.U_Username AS U_ReplierName, t4.B_Reged AS ReplyReged
FROM w3t_Posts AS t1,
w3t_Users AS t2,
w3t_Users AS t3,
w3t_Posts AS t4
WHERE t1.B_PosterId = t2.U_Number
AND t1.B_LastPosterId = t3.U_Number
AND t4.B_Number = t1.B_LastPostNum
AND t1.B_Number IN (928806, 6044745, 1730551, 11285504, 1843254, 10098980, 2860490, 2461529)
ORDER BY FIELD(t1.B_Number, 928806, 6044745, 1730551, 11285504, 1843254, 10098980, 2860490, 2461529)

---

makaveli8x8 said:

i was on earlier today and the site was slow as shit too

---

Cognitive_Shift said:

hey ythan what ever you did the site is running noticeably faster

---

Ythan said:

Sorry that was me it should be fixed though.

---

Quit that!