Including Functions.php

Time Before: 0.08169 seconds
Time After: 0.09378 seconds
Time Taken: 0.01210 seconds

Memory Before: 1,564.742 KB
Memory After: 2,308.813 KB
Memory Used: 744.070 KB

Connect to Database on Server: localhost

Time Before: 0.09389 seconds
Time After: 0.09454 seconds
Time Taken: 0.00065 seconds

Memory Before: 2,308.797 KB
Memory After: 2,316.344 KB
Memory Used: 7.547 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.09477 seconds
Time After: 0.09511 seconds
Time Taken: 0.00033 seconds

Memory Before: 2,317.055 KB
Memory After: 2,317.617 KB
Memory Used: 0.563 KB

Datastore Setup
SQL Query
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','smiliecache','bbcodecache','mailqueue','bookmarksitecache')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY52 18Using index condition

Time Before: 0.09602 seconds
Time After: 0.09783 seconds
Time Taken: 0.00182 seconds

Memory Before: 2,320.492 KB
Memory After: 2,366.969 KB
Memory Used: 46.477 KB

Time Before: 0.09515 seconds
Time After: 0.09931 seconds
Time Taken: 0.00416 seconds

Memory Before: 2,316.859 KB
Memory After: 3,946.219 KB
Memory Used: 1,629.359 KB

SQL Query
SELECT *
FROM datastore
WHERE title IN ('ehdaa_userban','ehdaa')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY52 2Using index condition

Time Before: 0.10028 seconds
Time After: 0.10077 seconds
Time Taken: 0.00048 seconds

Memory Before: 3,971.055 KB
Memory After: 3,973.563 KB
Memory Used: 2.508 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '216.73.216.40'
	AND idhash = 'ea5a359a73a8141a16de516480d33c34'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionALL    94Using where

Time Before: 0.10150 seconds
Time After: 0.10204 seconds
Time Taken: 0.00054 seconds

Memory Before: 3,996.883 KB
Memory After: 4,002.352 KB
Memory Used: 5.469 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_posting AS phrasegroup_posting,
			phrasegroup_postbit AS phrasegroup_postbit,
			phrasegroup_showthread AS phrasegroup_showthread,
			phrasegroup_inlinemod AS phrasegroup_inlinemod,
			phrasegroup_reputationlevel AS phrasegroup_reputationlevel,
			options AS lang_options,
			languagecode AS lang_code,
			charset AS lang_charset,
			locale AS lang_locale,
			imagesoverride AS lang_imagesoverride,
			dateoverride AS lang_dateoverride,
			timeoverride AS lang_timeoverride,
			registereddateoverride AS lang_registereddateoverride,
			calformat1override AS lang_calformat1override,
			calformat2override AS lang_calformat2override,
			logdateoverride AS lang_logdateoverride,
			decimalsep AS lang_decimalsep,
			thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 2
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLElanguageconstPRIMARYPRIMARY2const1 

Time Before: 0.10276 seconds
Time After: 0.10332 seconds
Time Taken: 0.00057 seconds

Memory Before: 4,008.273 KB
Memory After: 4,014.305 KB
Memory Used: 6.031 KB

Time Before: 0.10087 seconds
Time After: 0.10338 seconds
Time Taken: 0.00251 seconds

Memory Before: 3,992.133 KB
Memory After: 4,075.352 KB
Memory Used: 83.219 KB

SQL Query
SELECT post.*,
IF(post.visible = 2, 1, 0) AS isdeleted,


editlog.userid AS edit_userid, editlog.dateline AS edit_dateline, editlog.reason AS edit_reason, editlog.hashistory

FROM post AS post

LEFT JOIN editlog AS editlog ON (editlog.postid = post.postid)

WHERE post.postid = 161218
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostconstPRIMARYPRIMARY4const1 
1SIMPLEeditlogconstPRIMARYPRIMARY4const0Unique row not found

Time Before: 0.18536 seconds
Time After: 0.18585 seconds
Time Taken: 0.00049 seconds

Memory Before: 4,208.703 KB
Memory After: 4,215.148 KB
Memory Used: 6.445 KB

SQL Query
SELECT IF(visible = 2, 1, 0) AS isdeleted,



thread.*


FROM thread AS thread






WHERE thread.threadid = 257
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEthreadconstPRIMARYPRIMARY4const1 

Time Before: 0.18712 seconds
Time After: 0.18752 seconds
Time Taken: 0.00040 seconds

Memory Before: 4,216.484 KB
Memory After: 4,227.188 KB
Memory Used: 10.703 KB

SQL Query
SELECT *
FROM style
WHERE (styleid = 72 AND userselect = 1)
	OR styleid = 72
ORDER BY styleid ASC
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstyleconstPRIMARYPRIMARY2const1 

Time Before: 0.18872 seconds
Time After: 0.18913 seconds
Time Taken: 0.00041 seconds

Memory Before: 4,232.680 KB
Memory After: 4,237.172 KB
Memory Used: 4.492 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (5097,5098,5100,5099,5182,5588,5214,5215,5217,5224,5223,5017,5397,5383,5384,5386,5385,5388,5390,5391,5392,5394,5396,5120,5122,5124,5126,5021,5426,5429,5430,5427,5425,5498,5499,5376,5375,5377,5381,5379,5526,5160,5159,5161,5162,6838,6856,5592,5095,5094,5096,5091,5090,5367,5006,5319,5320,5321,5587,5590,5599,5340,5341,5342,5343,5541,5604,5603,5605,5608,4697,4702,4701,4703,4705,4684,4675,4676,4680,4683,4681,4677,4673,4682,4685,4686,4678,4674,4687,4679,4644,4645,4656,4669,4670,3211,4503,0,4504,4506,4507,6848,6850,6849,4689,4690,4698,4699,4700,6034,6038,6037,6036,6035,6032,6031,5159,5160,5161,5162,5163,5164,5166,5329,5167,5177,6033,6039)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 124Using index condition

Time Before: 0.19131 seconds
Time After: 0.19340 seconds
Time Taken: 0.00209 seconds

Memory Before: 4,464.719 KB
Memory After: 4,469.188 KB
Memory Used: 4.469 KB

SQL Query
SELECT userip
FROM cybvilxh_guests AS cybvilxh_guests
WHERE userip = '216.73.216.40'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcybvilxh_guestsALL    608Using where

Time Before: 0.40065 seconds
Time After: 0.40124 seconds
Time Taken: 0.00060 seconds

Memory Before: 6,111.508 KB
Memory After: 6,113.500 KB
Memory Used: 1.992 KB

SQL Query
UPDATE cybvilxh_guests
SET dateline = '1755650552'
WHERE userip = '216.73.216.40'

Time Before: 0.40132 seconds
Time After: 0.40503 seconds
Time Taken: 0.00371 seconds

Memory Before: 6,113.695 KB
Memory After: 6,114.063 KB
Memory Used: 0.367 KB

SQL Query
DELETE FROM cybvilxh_guests WHERE dateline < '1755391352'

Time Before: 0.40509 seconds
Time After: 0.40570 seconds
Time Taken: 0.00061 seconds

Memory Before: 6,111.375 KB
Memory After: 6,111.664 KB
Memory Used: 0.289 KB

End call of global.php: 0.47997307777405
SQL Query
SELECT thread.threadid, thread.title
	
FROM thread AS thread

WHERE forumid = 144
	AND visible = 1
	AND open <> 10
	
AND lastpost > 1297979625
ORDER BY lastpost
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEthreadrefforumid,lastpostforumid4const,const2Using index condition; Using where; Using filesort

Time Before: 0.49001 seconds
Time After: 0.49085 seconds
Time Taken: 0.00084 seconds

Memory Before: 5,669.328 KB
Memory After: 5,671.445 KB
Memory Used: 2.117 KB

SQL Query
SELECT thread.threadid, thread.title
	
FROM thread AS thread

WHERE forumid = 144
	AND visible = 1
	AND open <> 10
	
AND lastpost < 1297979625
ORDER BY lastpost DESC
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEthreadrefforumid,lastpostforumid4const,const2Using index condition; Using where; Using filesort

Time Before: 0.49162 seconds
Time After: 0.49205 seconds
Time Taken: 0.00044 seconds

Memory Before: 5,670.109 KB
Memory After: 5,672.188 KB
Memory Used: 2.078 KB

SQL Query
SELECT
	post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
	user.*, userfield.*
	
	
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)

WHERE threadid = 257
	
ORDER BY postid
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefthreadid,threadid_2threadid4const347Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4abotglb_vb368.post.userid1 
1SIMPLEuserfieldeq_refPRIMARYPRIMARY4abotglb_vb368.user.userid1Using where

Time Before: 0.49725 seconds
Time After: 0.50831 seconds
Time Taken: 0.01106 seconds

Memory Before: 5,755.359 KB
Memory After: 6,108.555 KB
Memory Used: 353.195 KB

SQL Query
SELECT dateline, thumbnail_dateline,filename, filesize, visible, attachmentid, counter,
	postid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, thumbnail_filesize,
	attachmenttype.thumbnail AS build_thumbnail, attachmenttype.newwindow
FROM attachment
LEFT JOIN attachmenttype AS attachmenttype USING (extension)
WHERE postid IN (-1,3880,3900,3917,4059,4061,4075,4077,4093,4095,4122,5685,6572,6602,6603,8181,8205,10412,11139,11160,12459,12535,13026,15328,15330,15771,15775,15778,15779,15781,15782,15801,15809,19952,58031,58033,61298,61553,63970,64270,64451,64865,64884,65542,65554,76415,76416,76421,76424,76425,80948,83772,90022,90951,91292,94252,94273,94282,95099,95127,95137,95138,95317,95348,95349,97494,97498,97499,97500,97507,98433,98625,98644,98650,98658,98660,98673,99469,99610,99639,99640,99672,99688,99864,100215,100930,100931,100978,100983,100989,101032,101036,101128,101129,101130,101174,101175,101176,101178,101442,101444,101449,102007,102008,102011,102416,102450,102451,102473,102474,102478,102479,102481,102488,102490,102867,102868,102936,102938,102940,102941,102942,102954,102955,102957,102998,104124,104196,104416,105016,105020,105026,105028,105128,105129,105191,105193,105266,105271,105387,105392,105538,105539,105553,105580,105590,105663,105742,105766,107048,107063,107082,107107,107111,107271,109488,109489,109490,109493,109494,109495,109500,109501,109502,109503,109504,109505,109509,112564,112567,112574,112577,112583,113186,113188,113196,113200,113213,113914,113920,114009,114013,114050,114058,114059,114061,114064,114103,114105,114120,114279,114292,114309,114374,114943,114950,115292,115298,115314,115365,115469,116127,116188,116202,116223,116235,116249,116922,116949,117503,117504,117581,117583,117616,122452,123080,123096,123099,123112,123118,124264,124271,124272,124308,124309,124433,124434,124444,124498,124631,124636,125736,125753,125754,125756,125759,125848,125853,126468,128327,134079,134087,134100,134111,134126,134285,134287,134288,134289,134290,134291,134494,134495,134514,141316,141327,141417,141492,141539,141715,141717,141739,141813,141814,142050,142052,142059,142061,142063,142069,142266,142270,142395,142400,142415,143773,143807,143813,144351,146398,146400,147287,147487,147650,148465,151114,151115,151146,151451,151514,151515,151601,151603,151622,152446,152469,152472,152480,152718,152724,153432,153436,153437,153439,153456,153457,153461,153678,153679,153716,153868,153869,153871,153880,153886,153896,153903,153915,153917,153919,153920,153925,153929,153943,153944,153963,153964,153968,153969,153997,154004,154113,154134,161138,161194,161199,161204,161214,161216,161217,161218,161219,161226,167319,170643,172242,172767,172777)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEattachmentrangepostidpostid4 55Using index condition
1SIMPLEattachmenttypeeq_refPRIMARYPRIMARY22abotglb_vb368.attachment.extension1 

Time Before: 0.68740 seconds
Time After: 0.68859 seconds
Time Taken: 0.00119 seconds

Memory Before: 13,835.617 KB
Memory After: 13,838.477 KB
Memory Used: 2.859 KB

SQL Query
SELECT
	post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
	user.*, userfield.*, usertextfield.*,
	icon.title as icontitle, icon.iconpath,
	avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,
	
	
	editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
	editlog.reason AS edit_reason, editlog.hashistory,
	postparsed.pagetext_html, postparsed.hasimages,
	sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
	sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
	
	
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)

	
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 72 AND postparsed.languageid = 2)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 72 AND sigparsed.languageid = 2)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
	
WHERE post.postid IN (153679,153716,153868,153869,153871,153880,153886,153896,153903,153943,153963,153915,153917,153919,153920,153925,153929,153944,153964,153968,153969,153997,154004,154113,154134,161138,161194,161199,161204,161214,161216,161217,161218,161219,161226,167319,170643,172242,172767,172777)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostparsedsystemPRIMARY   0Const row not found
1SIMPLEpostrangePRIMARYPRIMARY4 40Using index condition
1SIMPLEusereq_refPRIMARYPRIMARY4abotglb_vb368.post.userid1 
1SIMPLEuserfieldeq_refPRIMARYPRIMARY4abotglb_vb368.user.userid1Using where
1SIMPLEusertextfieldeq_refPRIMARYPRIMARY4abotglb_vb368.user.userid1Using where
1SIMPLEiconeq_refPRIMARYPRIMARY2abotglb_vb368.post.iconid1 
1SIMPLEavatareq_refPRIMARYPRIMARY2abotglb_vb368.user.avatarid1Using where
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4abotglb_vb368.user.userid1Using where
1SIMPLEsigparsedeq_refPRIMARYPRIMARY8abotglb_vb368.user.userid,const,const1Using where
1SIMPLEsigpiceq_refPRIMARYPRIMARY4abotglb_vb368.post.userid1 
1SIMPLEeditlogeq_refPRIMARYPRIMARY4abotglb_vb368.post.postid1 

Time Before: 1.08307 seconds
Time After: 1.08865 seconds
Time Taken: 0.00557 seconds

Memory Before: 13,832.516 KB
Memory After: 13,910.859 KB
Memory Used: 78.344 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.10002 seconds
Time After: 1.10039 seconds
Time Taken: 0.00036 seconds

Memory Before: 7,304.422 KB
Memory After: 7,306.453 KB
Memory Used: 2.031 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.10091 seconds
Time After: 1.10124 seconds
Time Taken: 0.00033 seconds

Memory Before: 7,305.141 KB
Memory After: 7,307.172 KB
Memory Used: 2.031 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 90
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 1.10181 seconds
Time After: 1.10258 seconds
Time Taken: 0.00077 seconds

Memory Before: 7,307.555 KB
Memory After: 7,309.539 KB
Memory Used: 1.984 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.19220 seconds
Time After: 1.19261 seconds
Time Taken: 0.00041 seconds

Memory Before: 7,400.055 KB
Memory After: 7,402.117 KB
Memory Used: 2.063 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.19318 seconds
Time After: 1.19352 seconds
Time Taken: 0.00034 seconds

Memory Before: 7,400.773 KB
Memory After: 7,402.836 KB
Memory Used: 2.063 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 90
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 1.19414 seconds
Time After: 1.19504 seconds
Time Taken: 0.00090 seconds

Memory Before: 7,402.578 KB
Memory After: 7,404.586 KB
Memory Used: 2.008 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.20218 seconds
Time After: 1.20259 seconds
Time Taken: 0.00040 seconds

Memory Before: 7,464.047 KB
Memory After: 7,466.078 KB
Memory Used: 2.031 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.20312 seconds
Time After: 1.20346 seconds
Time Taken: 0.00034 seconds

Memory Before: 7,464.766 KB
Memory After: 7,466.797 KB
Memory Used: 2.031 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 7
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 1.28160 seconds
Time After: 1.28253 seconds
Time Taken: 0.00093 seconds

Memory Before: 7,470.633 KB
Memory After: 7,472.609 KB
Memory Used: 1.977 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.30126 seconds
Time After: 1.30163 seconds
Time Taken: 0.00038 seconds

Memory Before: 7,574.602 KB
Memory After: 7,576.633 KB
Memory Used: 2.031 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.30220 seconds
Time After: 1.30253 seconds
Time Taken: 0.00033 seconds

Memory Before: 7,575.320 KB
Memory After: 7,577.352 KB
Memory Used: 2.031 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 7
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 1.37932 seconds
Time After: 1.38069 seconds
Time Taken: 0.00137 seconds

Memory Before: 7,579.695 KB
Memory After: 7,581.672 KB
Memory Used: 1.977 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.40301 seconds
Time After: 1.40367 seconds
Time Taken: 0.00066 seconds

Memory Before: 7,686.828 KB
Memory After: 7,688.875 KB
Memory Used: 2.047 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.40432 seconds
Time After: 1.40465 seconds
Time Taken: 0.00033 seconds

Memory Before: 7,687.547 KB
Memory After: 7,689.594 KB
Memory Used: 2.047 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 196
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 1.40528 seconds
Time After: 1.40617 seconds
Time Taken: 0.00089 seconds

Memory Before: 7,689.078 KB
Memory After: 7,691.078 KB
Memory Used: 2.000 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.49630 seconds
Time After: 1.49669 seconds
Time Taken: 0.00038 seconds

Memory Before: 7,782.680 KB
Memory After: 7,784.719 KB
Memory Used: 2.039 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.49736 seconds
Time After: 1.49773 seconds
Time Taken: 0.00036 seconds

Memory Before: 7,783.398 KB
Memory After: 7,785.438 KB
Memory Used: 2.039 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 7
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 1.49984 seconds
Time After: 1.50099 seconds
Time Taken: 0.00115 seconds

Memory Before: 7,788.734 KB
Memory After: 7,790.719 KB
Memory Used: 1.984 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.59077 seconds
Time After: 1.59141 seconds
Time Taken: 0.00064 seconds

Memory Before: 7,884.094 KB
Memory After: 7,886.125 KB
Memory Used: 2.031 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.59209 seconds
Time After: 1.59246 seconds
Time Taken: 0.00037 seconds

Memory Before: 7,884.813 KB
Memory After: 7,886.844 KB
Memory Used: 2.031 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 196
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 1.59300 seconds
Time After: 1.59373 seconds
Time Taken: 0.00073 seconds

Memory Before: 7,887.500 KB
Memory After: 7,889.484 KB
Memory Used: 1.984 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.60092 seconds
Time After: 1.60157 seconds
Time Taken: 0.00065 seconds

Memory Before: 7,989.328 KB
Memory After: 7,991.375 KB
Memory Used: 2.047 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.60211 seconds
Time After: 1.60244 seconds
Time Taken: 0.00033 seconds

Memory Before: 7,990.047 KB
Memory After: 7,992.094 KB
Memory Used: 2.047 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 295
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 1.60306 seconds
Time After: 1.60375 seconds
Time Taken: 0.00069 seconds

Memory Before: 7,991.672 KB
Memory After: 7,993.656 KB
Memory Used: 1.984 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.69172 seconds
Time After: 1.69212 seconds
Time Taken: 0.00040 seconds

Memory Before: 8,049.672 KB
Memory After: 8,051.703 KB
Memory Used: 2.031 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.69267 seconds
Time After: 1.69301 seconds
Time Taken: 0.00034 seconds

Memory Before: 8,050.391 KB
Memory After: 8,052.422 KB
Memory Used: 2.031 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 13
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 1.69358 seconds
Time After: 1.69430 seconds
Time Taken: 0.00072 seconds

Memory Before: 8,052.297 KB
Memory After: 8,054.281 KB
Memory Used: 1.984 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.78598 seconds
Time After: 1.78667 seconds
Time Taken: 0.00069 seconds

Memory Before: 8,115.984 KB
Memory After: 8,118.016 KB
Memory Used: 2.031 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.78724 seconds
Time After: 1.78773 seconds
Time Taken: 0.00050 seconds

Memory Before: 8,116.703 KB
Memory After: 8,118.734 KB
Memory Used: 2.031 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 2
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 1.78865 seconds
Time After: 1.78949 seconds
Time Taken: 0.00084 seconds

Memory Before: 8,117.906 KB
Memory After: 8,119.883 KB
Memory Used: 1.977 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.80306 seconds
Time After: 1.80370 seconds
Time Taken: 0.00064 seconds

Memory Before: 8,218.930 KB
Memory After: 8,220.977 KB
Memory Used: 2.047 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.80422 seconds
Time After: 1.80457 seconds
Time Taken: 0.00035 seconds

Memory Before: 8,219.656 KB
Memory After: 8,221.695 KB
Memory Used: 2.039 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 13
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 1.80518 seconds
Time After: 1.80603 seconds
Time Taken: 0.00086 seconds

Memory Before: 8,221.289 KB
Memory After: 8,223.305 KB
Memory Used: 2.016 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.89299 seconds
Time After: 1.89359 seconds
Time Taken: 0.00060 seconds

Memory Before: 8,281.859 KB
Memory After: 8,283.898 KB
Memory Used: 2.039 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.89407 seconds
Time After: 1.89442 seconds
Time Taken: 0.00035 seconds

Memory Before: 8,282.578 KB
Memory After: 8,284.617 KB
Memory Used: 2.039 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 364
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 1.89504 seconds
Time After: 1.89575 seconds
Time Taken: 0.00070 seconds

Memory Before: 8,284.781 KB
Memory After: 8,286.797 KB
Memory Used: 2.016 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.90204 seconds
Time After: 1.90239 seconds
Time Taken: 0.00035 seconds

Memory Before: 8,384.063 KB
Memory After: 8,386.094 KB
Memory Used: 2.031 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.90280 seconds
Time After: 1.90321 seconds
Time Taken: 0.00041 seconds

Memory Before: 8,384.797 KB
Memory After: 8,386.820 KB
Memory Used: 2.023 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 13
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 1.90364 seconds
Time After: 1.90443 seconds
Time Taken: 0.00078 seconds

Memory Before: 8,386.398 KB
Memory After: 8,388.414 KB
Memory Used: 2.016 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.99323 seconds
Time After: 1.99360 seconds
Time Taken: 0.00037 seconds

Memory Before: 8,444.391 KB
Memory After: 8,446.438 KB
Memory Used: 2.047 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 1.99428 seconds
Time After: 1.99461 seconds
Time Taken: 0.00033 seconds

Memory Before: 8,445.117 KB
Memory After: 8,447.156 KB
Memory Used: 2.039 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 21
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 1.99524 seconds
Time After: 1.99608 seconds
Time Taken: 0.00084 seconds

Memory Before: 8,447.633 KB
Memory After: 8,449.648 KB
Memory Used: 2.016 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.07934 seconds
Time After: 2.08008 seconds
Time Taken: 0.00073 seconds

Memory Before: 8,511.602 KB
Memory After: 8,513.641 KB
Memory Used: 2.039 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.08098 seconds
Time After: 2.08162 seconds
Time Taken: 0.00064 seconds

Memory Before: 8,512.320 KB
Memory After: 8,514.359 KB
Memory Used: 2.039 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 13
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 2.08281 seconds
Time After: 2.08404 seconds
Time Taken: 0.00123 seconds

Memory Before: 8,513.695 KB
Memory After: 8,515.719 KB
Memory Used: 2.023 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.09497 seconds
Time After: 2.09563 seconds
Time Taken: 0.00066 seconds

Memory Before: 8,564.109 KB
Memory After: 8,566.156 KB
Memory Used: 2.047 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.09623 seconds
Time After: 2.09659 seconds
Time Taken: 0.00035 seconds

Memory Before: 8,564.828 KB
Memory After: 8,566.875 KB
Memory Used: 2.047 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 196
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 2.09719 seconds
Time After: 2.09792 seconds
Time Taken: 0.00073 seconds

Memory Before: 8,567.742 KB
Memory After: 8,569.766 KB
Memory Used: 2.023 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.10435 seconds
Time After: 2.10467 seconds
Time Taken: 0.00033 seconds

Memory Before: 8,667.273 KB
Memory After: 8,669.297 KB
Memory Used: 2.023 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.10506 seconds
Time After: 2.17896 seconds
Time Taken: 0.07390 seconds

Memory Before: 8,668.000 KB
Memory After: 8,670.047 KB
Memory Used: 2.047 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 13
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 2.18007 seconds
Time After: 2.18096 seconds
Time Taken: 0.00089 seconds

Memory Before: 8,669.219 KB
Memory After: 8,671.234 KB
Memory Used: 2.016 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.19028 seconds
Time After: 2.19049 seconds
Time Taken: 0.00021 seconds

Memory Before: 8,749.648 KB
Memory After: 8,751.680 KB
Memory Used: 2.031 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.19087 seconds
Time After: 2.19106 seconds
Time Taken: 0.00019 seconds

Memory Before: 8,750.367 KB
Memory After: 8,752.406 KB
Memory Used: 2.039 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 314
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 2.19146 seconds
Time After: 2.19186 seconds
Time Taken: 0.00040 seconds

Memory Before: 8,753.070 KB
Memory After: 8,755.063 KB
Memory Used: 1.992 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.19688 seconds
Time After: 2.19703 seconds
Time Taken: 0.00015 seconds

Memory Before: 8,850.141 KB
Memory After: 8,852.164 KB
Memory Used: 2.023 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.19726 seconds
Time After: 2.19738 seconds
Time Taken: 0.00012 seconds

Memory Before: 8,850.859 KB
Memory After: 8,852.883 KB
Memory Used: 2.023 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 13
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 2.19764 seconds
Time After: 2.19791 seconds
Time Taken: 0.00027 seconds

Memory Before: 8,852.586 KB
Memory After: 8,854.555 KB
Memory Used: 1.969 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.28906 seconds
Time After: 2.28970 seconds
Time Taken: 0.00064 seconds

Memory Before: 8,914.148 KB
Memory After: 8,916.180 KB
Memory Used: 2.031 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.29036 seconds
Time After: 2.29069 seconds
Time Taken: 0.00033 seconds

Memory Before: 8,914.867 KB
Memory After: 8,916.898 KB
Memory Used: 2.031 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 160
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 2.29135 seconds
Time After: 2.29210 seconds
Time Taken: 0.00076 seconds

Memory Before: 8,916.820 KB
Memory After: 8,918.805 KB
Memory Used: 1.984 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.29807 seconds
Time After: 2.29843 seconds
Time Taken: 0.00036 seconds

Memory Before: 8,974.352 KB
Memory After: 8,976.422 KB
Memory Used: 2.070 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.29907 seconds
Time After: 2.29940 seconds
Time Taken: 0.00032 seconds

Memory Before: 8,975.148 KB
Memory After: 8,977.195 KB
Memory Used: 2.047 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 13
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 2.29991 seconds
Time After: 2.30062 seconds
Time Taken: 0.00071 seconds

Memory Before: 8,977.031 KB
Memory After: 8,979.055 KB
Memory Used: 2.023 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.39156 seconds
Time After: 2.39203 seconds
Time Taken: 0.00047 seconds

Memory Before: 9,034.930 KB
Memory After: 9,036.969 KB
Memory Used: 2.039 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.39284 seconds
Time After: 2.39353 seconds
Time Taken: 0.00069 seconds

Memory Before: 9,035.688 KB
Memory After: 9,037.719 KB
Memory Used: 2.031 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 90
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 2.39423 seconds
Time After: 2.39502 seconds
Time Taken: 0.00079 seconds

Memory Before: 9,037.586 KB
Memory After: 9,039.563 KB
Memory Used: 1.977 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.40040 seconds
Time After: 2.40073 seconds
Time Taken: 0.00033 seconds

Memory Before: 9,092.453 KB
Memory After: 9,094.492 KB
Memory Used: 2.039 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.40124 seconds
Time After: 2.40153 seconds
Time Taken: 0.00029 seconds

Memory Before: 9,093.203 KB
Memory After: 9,095.250 KB
Memory Used: 2.047 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 13
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 2.40195 seconds
Time After: 2.40258 seconds
Time Taken: 0.00063 seconds

Memory Before: 9,094.789 KB
Memory After: 9,096.773 KB
Memory Used: 1.984 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.48246 seconds
Time After: 2.48285 seconds
Time Taken: 0.00039 seconds

Memory Before: 9,155.141 KB
Memory After: 9,157.172 KB
Memory Used: 2.031 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.48373 seconds
Time After: 2.48414 seconds
Time Taken: 0.00041 seconds

Memory Before: 9,155.867 KB
Memory After: 9,157.891 KB
Memory Used: 2.023 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 54
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 2.48483 seconds
Time After: 2.48587 seconds
Time Taken: 0.00104 seconds

Memory Before: 9,157.758 KB
Memory After: 9,159.742 KB
Memory Used: 1.984 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.49743 seconds
Time After: 2.49802 seconds
Time Taken: 0.00060 seconds

Memory Before: 9,255.117 KB
Memory After: 9,257.148 KB
Memory Used: 2.031 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.49851 seconds
Time After: 2.49907 seconds
Time Taken: 0.00056 seconds

Memory Before: 9,255.859 KB
Memory After: 9,257.891 KB
Memory Used: 2.031 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 13
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 2.49966 seconds
Time After: 2.50052 seconds
Time Taken: 0.00086 seconds

Memory Before: 9,258.055 KB
Memory After: 9,260.047 KB
Memory Used: 1.992 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.59334 seconds
Time After: 2.59359 seconds
Time Taken: 0.00026 seconds

Memory Before: 9,316.680 KB
Memory After: 9,318.711 KB
Memory Used: 2.031 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.59402 seconds
Time After: 2.59460 seconds
Time Taken: 0.00058 seconds

Memory Before: 9,317.398 KB
Memory After: 9,319.430 KB
Memory Used: 2.031 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 7
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 2.59618 seconds
Time After: 2.59671 seconds
Time Taken: 0.00053 seconds

Memory Before: 9,321.117 KB
Memory After: 9,323.094 KB
Memory Used: 1.977 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.68432 seconds
Time After: 2.68490 seconds
Time Taken: 0.00058 seconds

Memory Before: 9,427.977 KB
Memory After: 9,430.063 KB
Memory Used: 2.086 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.68602 seconds
Time After: 2.68659 seconds
Time Taken: 0.00056 seconds

Memory Before: 9,428.766 KB
Memory After: 9,430.820 KB
Memory Used: 2.055 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 314
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 2.68762 seconds
Time After: 2.68832 seconds
Time Taken: 0.00070 seconds

Memory Before: 9,431.883 KB
Memory After: 9,433.883 KB
Memory Used: 2.000 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.69759 seconds
Time After: 2.69809 seconds
Time Taken: 0.00050 seconds

Memory Before: 9,519.281 KB
Memory After: 9,521.320 KB
Memory Used: 2.039 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.69885 seconds
Time After: 2.69961 seconds
Time Taken: 0.00076 seconds

Memory Before: 9,520.039 KB
Memory After: 9,522.086 KB
Memory Used: 2.047 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 2
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 2.70038 seconds
Time After: 2.70110 seconds
Time Taken: 0.00073 seconds

Memory Before: 9,522.977 KB
Memory After: 9,524.969 KB
Memory Used: 1.992 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.70551 seconds
Time After: 2.70600 seconds
Time Taken: 0.00050 seconds

Memory Before: 9,619.391 KB
Memory After: 9,621.422 KB
Memory Used: 2.031 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.70652 seconds
Time After: 2.70702 seconds
Time Taken: 0.00051 seconds

Memory Before: 9,620.125 KB
Memory After: 9,622.164 KB
Memory Used: 2.039 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 90
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 2.70748 seconds
Time After: 2.70836 seconds
Time Taken: 0.00088 seconds

Memory Before: 9,621.891 KB
Memory After: 9,623.883 KB
Memory Used: 1.992 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.79241 seconds
Time After: 2.79289 seconds
Time Taken: 0.00048 seconds

Memory Before: 9,678.211 KB
Memory After: 9,680.250 KB
Memory Used: 2.039 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.79353 seconds
Time After: 2.79394 seconds
Time Taken: 0.00041 seconds

Memory Before: 9,678.961 KB
Memory After: 9,681.000 KB
Memory Used: 2.039 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 364
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 2.79460 seconds
Time After: 2.79552 seconds
Time Taken: 0.00092 seconds

Memory Before: 9,681.125 KB
Memory After: 9,683.094 KB
Memory Used: 1.969 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.89505 seconds
Time After: 2.89539 seconds
Time Taken: 0.00033 seconds

Memory Before: 9,780.617 KB
Memory After: 9,782.656 KB
Memory Used: 2.039 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.89585 seconds
Time After: 2.89635 seconds
Time Taken: 0.00049 seconds

Memory Before: 9,781.359 KB
Memory After: 9,783.398 KB
Memory Used: 2.039 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 7
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 2.89814 seconds
Time After: 2.89877 seconds
Time Taken: 0.00063 seconds

Memory Before: 9,786.664 KB
Memory After: 9,788.641 KB
Memory Used: 1.977 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.90336 seconds
Time After: 2.90367 seconds
Time Taken: 0.00032 seconds

Memory Before: 9,889.586 KB
Memory After: 9,891.633 KB
Memory Used: 2.047 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.90423 seconds
Time After: 2.90453 seconds
Time Taken: 0.00030 seconds

Memory Before: 9,890.367 KB
Memory After: 9,892.391 KB
Memory Used: 2.023 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 7
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 2.90536 seconds
Time After: 2.90580 seconds
Time Taken: 0.00044 seconds

Memory Before: 9,895.914 KB
Memory After: 9,897.906 KB
Memory Used: 1.992 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.98965 seconds
Time After: 2.99020 seconds
Time Taken: 0.00055 seconds

Memory Before: 9,993.305 KB
Memory After: 9,995.352 KB
Memory Used: 2.047 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 2.99086 seconds
Time After: 2.99134 seconds
Time Taken: 0.00047 seconds

Memory Before: 9,994.109 KB
Memory After: 9,996.133 KB
Memory Used: 2.023 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 7
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 2.99305 seconds
Time After: 2.99404 seconds
Time Taken: 0.00099 seconds

Memory Before: 9,999.539 KB
Memory After: 10,001.547 KB
Memory Used: 2.008 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 3.00037 seconds
Time After: 3.00070 seconds
Time Taken: 0.00033 seconds

Memory Before: 10,115.086 KB
Memory After: 10,117.148 KB
Memory Used: 2.063 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 3.00124 seconds
Time After: 3.00156 seconds
Time Taken: 0.00032 seconds

Memory Before: 10,115.875 KB
Memory After: 10,117.922 KB
Memory Used: 2.047 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 7
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 3.00259 seconds
Time After: 3.00356 seconds
Time Taken: 0.00097 seconds

Memory Before: 10,120.781 KB
Memory After: 10,122.805 KB
Memory Used: 2.023 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 3.09459 seconds
Time After: 3.09474 seconds
Time Taken: 0.00014 seconds

Memory Before: 10,222.555 KB
Memory After: 10,224.656 KB
Memory Used: 2.102 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 3.09569 seconds
Time After: 3.09618 seconds
Time Taken: 0.00050 seconds

Memory Before: 10,223.344 KB
Memory After: 10,225.430 KB
Memory Used: 2.086 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 295
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 3.09672 seconds
Time After: 3.09760 seconds
Time Taken: 0.00088 seconds

Memory Before: 10,225.047 KB
Memory After: 10,227.086 KB
Memory Used: 2.039 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 3.10251 seconds
Time After: 3.10304 seconds
Time Taken: 0.00053 seconds

Memory Before: 10,284.594 KB
Memory After: 10,286.641 KB
Memory Used: 2.047 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 3.10382 seconds
Time After: 3.10426 seconds
Time Taken: 0.00045 seconds

Memory Before: 10,285.367 KB
Memory After: 10,287.422 KB
Memory Used: 2.055 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 394
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 3.10472 seconds
Time After: 3.10550 seconds
Time Taken: 0.00078 seconds

Memory Before: 10,286.766 KB
Memory After: 10,288.766 KB
Memory Used: 2.000 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 3.18823 seconds
Time After: 3.18859 seconds
Time Taken: 0.00036 seconds

Memory Before: 10,389.461 KB
Memory After: 10,391.531 KB
Memory Used: 2.070 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 3.18922 seconds
Time After: 3.18955 seconds
Time Taken: 0.00033 seconds

Memory Before: 10,390.234 KB
Memory After: 10,392.313 KB
Memory Used: 2.078 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 3
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 3.19023 seconds
Time After: 3.19107 seconds
Time Taken: 0.00084 seconds

Memory Before: 10,392.469 KB
Memory After: 10,394.547 KB
Memory Used: 2.078 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 3.19637 seconds
Time After: 3.19672 seconds
Time Taken: 0.00035 seconds

Memory Before: 10,489.688 KB
Memory After: 10,491.773 KB
Memory Used: 2.086 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 3.19728 seconds
Time After: 3.19761 seconds
Time Taken: 0.00033 seconds

Memory Before: 10,490.461 KB
Memory After: 10,492.523 KB
Memory Used: 2.063 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 196
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 3.19814 seconds
Time After: 3.19896 seconds
Time Taken: 0.00082 seconds

Memory Before: 10,493.289 KB
Memory After: 10,495.297 KB
Memory Used: 2.008 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 3.27924 seconds
Time After: 3.28006 seconds
Time Taken: 0.00081 seconds

Memory Before: 10,600.047 KB
Memory After: 10,602.148 KB
Memory Used: 2.102 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 3.28131 seconds
Time After: 3.28185 seconds
Time Taken: 0.00054 seconds

Memory Before: 10,600.836 KB
Memory After: 10,602.922 KB
Memory Used: 2.086 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 478
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 3.28311 seconds
Time After: 3.28427 seconds
Time Taken: 0.00116 seconds

Memory Before: 10,602.359 KB
Memory After: 10,604.422 KB
Memory Used: 2.063 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 3.29951 seconds
Time After: 3.30007 seconds
Time Taken: 0.00056 seconds

Memory Before: 10,705.094 KB
Memory After: 10,707.211 KB
Memory Used: 2.117 KB

SQL Query
SELECT userid from post where threadid='257'  AND userid=0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefuserid,threadid,threadid_2threadid8const,const1Using index

Time Before: 3.30092 seconds
Time After: 3.30166 seconds
Time Taken: 0.00073 seconds

Memory Before: 10,705.891 KB
Memory After: 10,708.000 KB
Memory Used: 2.109 KB

SQL Query
SELECT gxcss_wsam
FROM userwsam
WHERE useridr = 7
ORDER BY RAND() LIMIT 0,4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserwsamALL    2Using where; Using temporary; Using filesort

Time Before: 3.30340 seconds
Time After: 3.30419 seconds
Time Taken: 0.00078 seconds

Memory Before: 10,711.125 KB
Memory After: 10,713.180 KB
Memory Used: 2.055 KB

Time after parsing all posts: 3.3883199691772 Memory After: 11,257KB
SQL Query
SELECT thread.threadid, thread.forumid, thread.title, thread.prefixid, thread.taglist, postusername, postuserid,
	thread.lastpost, thread.replycount,
	forum.title AS forumtitle
	,post.pagetext AS preview
	
	
FROM thread AS thread
INNER JOIN forum AS forum ON (forum.forumid = thread.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)



WHERE thread.threadid IN (8348, 4048, 5162, 7593, 6334) AND thread.visible = 1
	AND forum.password = ''
	
	
ORDER BY lastpost DESC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEthreadrangePRIMARY,forumidPRIMARY4 5Using index condition; Using where; Using filesort
1SIMPLEforumeq_refPRIMARYPRIMARY2abotglb_vb368.thread.forumid1Using where
1SIMPLEposteq_refPRIMARYPRIMARY4abotglb_vb368.thread.firstpostid1 

Time Before: 3.38969 seconds
Time After: 3.39054 seconds
Time Taken: 0.00086 seconds

Memory Before: 11,261.523 KB
Memory After: 11,265.703 KB
Memory Used: 4.180 KB

SQL Query
SELECT template
FROM template
WHERE templateid = 4659
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplateconstPRIMARYPRIMARY4const1 

Time Before: 3.39565 seconds
Time After: 3.39598 seconds
Time Taken: 0.00033 seconds

Memory Before: 11,325.102 KB
Memory After: 11,327.125 KB
Memory Used: 2.023 KB

SQL Query
UPDATE session
SET location = '/vb/showthread.php?explain=1&mode=threaded&p=161218', inforum = 144, inthread = 257, incalendar = 0, badlocation = 0, useragent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
WHERE sessionhash = '9f042f3caf5bba903ce6e7c74d7dbe48'

Time Before: 3.48210 seconds
Time After: 3.48267 seconds
Time Taken: 0.00058 seconds

Memory Before: 13,958.906 KB
Memory After: 13,959.039 KB
Memory Used: 0.133 KB

SQL Query
INSERT INTO threadviews (threadid)
VALUES (257)

Time Before: 3.48283 seconds
Time After: 3.48316 seconds
Time Taken: 0.00033 seconds

Memory Before: 13,952.688 KB
Memory After: 13,952.977 KB
Memory Used: 0.289 KB

Page generated in 3.3993721008301 seconds with 148 queries, spending 0.17843222618103 doing MySQL queries and 3.220939874649 doing PHP things.
Shutdown Queries:
DISABLED