Including Functions.php

Time Before: 0.00317 seconds
Time After: 0.00760 seconds
Time Taken: 0.00443 seconds

Memory Before: 1,565.016 KB
Memory After: 2,309.047 KB
Memory Used: 744.031 KB

Connect to Database on Server: localhost

Time Before: 0.00766 seconds
Time After: 0.00832 seconds
Time Taken: 0.00066 seconds

Memory Before: 2,309.031 KB
Memory After: 2,316.586 KB
Memory Used: 7.555 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00865 seconds
Time After: 0.00927 seconds
Time Taken: 0.00063 seconds

Memory Before: 2,317.289 KB
Memory After: 2,317.852 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.01051 seconds
Time After: 0.08951 seconds
Time Taken: 0.07900 seconds

Memory Before: 2,320.727 KB
Memory After: 2,367.227 KB
Memory Used: 46.500 KB

Time Before: 0.00938 seconds
Time After: 0.09371 seconds
Time Taken: 0.08433 seconds

Memory Before: 2,317.094 KB
Memory After: 3,946.461 KB
Memory Used: 1,629.367 KB

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

Time Before: 0.09571 seconds
Time After: 0.09661 seconds
Time Taken: 0.00089 seconds

Memory Before: 3,971.297 KB
Memory After: 3,973.805 KB
Memory Used: 2.508 KB

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

Time Before: 0.09804 seconds
Time After: 0.09842 seconds
Time Taken: 0.00038 seconds

Memory Before: 3,997.195 KB
Memory After: 4,002.656 KB
Memory Used: 5.461 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.09986 seconds
Time After: 0.10048 seconds
Time Taken: 0.00061 seconds

Memory Before: 4,008.586 KB
Memory After: 4,014.617 KB
Memory Used: 6.031 KB

Time Before: 0.09700 seconds
Time After: 0.10062 seconds
Time Taken: 0.00362 seconds

Memory Before: 3,992.438 KB
Memory After: 4,075.664 KB
Memory Used: 83.227 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 = 166696
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostconstPRIMARYPRIMARY4const1 
1SIMPLEeditlogconstPRIMARYPRIMARY4const0Unique row not found

Time Before: 0.10427 seconds
Time After: 0.10482 seconds
Time Taken: 0.00055 seconds

Memory Before: 4,208.883 KB
Memory After: 4,215.320 KB
Memory Used: 6.438 KB

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



thread.*


FROM thread AS thread






WHERE thread.threadid = 9449
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEthreadconstPRIMARYPRIMARY4const1 

Time Before: 0.10544 seconds
Time After: 0.10589 seconds
Time Taken: 0.00045 seconds

Memory Before: 4,216.836 KB
Memory After: 4,227.516 KB
Memory Used: 10.680 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.10664 seconds
Time After: 0.10695 seconds
Time Taken: 0.00031 seconds

Memory Before: 4,233.023 KB
Memory After: 4,237.516 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.10851 seconds
Time After: 0.11100 seconds
Time Taken: 0.00249 seconds

Memory Before: 4,465.063 KB
Memory After: 4,469.531 KB
Memory Used: 4.469 KB

SQL Query
SELECT userip
FROM cybvilxh_guests AS cybvilxh_guests
WHERE userip = '216.73.216.51'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcybvilxh_guestsALL    1091Using where

Time Before: 0.30445 seconds
Time After: 0.30537 seconds
Time Taken: 0.00092 seconds

Memory Before: 6,111.414 KB
Memory After: 6,113.414 KB
Memory Used: 2.000 KB

SQL Query
UPDATE cybvilxh_guests
SET dateline = '1759581815'
WHERE userip = '216.73.216.51'

Time Before: 0.30547 seconds
Time After: 0.31283 seconds
Time Taken: 0.00736 seconds

Memory Before: 6,113.602 KB
Memory After: 6,113.969 KB
Memory Used: 0.367 KB

SQL Query
DELETE FROM cybvilxh_guests WHERE dateline < '1759322615'

Time Before: 0.31290 seconds
Time After: 0.31400 seconds
Time Taken: 0.00110 seconds

Memory Before: 6,111.281 KB
Memory After: 6,111.570 KB
Memory Used: 0.289 KB

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

WHERE forumid = 36
	AND visible = 1
	AND open <> 10
	
AND lastpost > 1269025648
ORDER BY lastpost
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEthreadrangeforumid,lastpostlastpost4 4055Using where

Time Before: 0.39738 seconds
Time After: 0.39864 seconds
Time Taken: 0.00127 seconds

Memory Before: 5,669.125 KB
Memory After: 5,671.242 KB
Memory Used: 2.117 KB

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

WHERE forumid = 36
	AND visible = 1
	AND open <> 10
	
AND lastpost < 1269025648
ORDER BY lastpost DESC
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEthreadrangeforumid,lastpostlastpost4 7353Using where

Time Before: 0.39990 seconds
Time After: 0.40083 seconds
Time Taken: 0.00094 seconds

Memory Before: 5,669.898 KB
Memory After: 5,672.016 KB
Memory Used: 2.117 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 = 9449
	
ORDER BY postid
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefthreadid,threadid_2threadid4const41Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4abotglb_vb368.post.userid1 
1SIMPLEuserfieldeq_refPRIMARYPRIMARY4abotglb_vb368.user.userid1Using where

Time Before: 0.40502 seconds
Time After: 0.40775 seconds
Time Taken: 0.00273 seconds

Memory Before: 5,755.641 KB
Memory After: 5,822.180 KB
Memory Used: 66.539 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 (165686,165689,165690,165721,165733,165737,165743,165747,165788,165902,165948,165972,166008,166010,166018,166039,166047,166085,166086,166090,166092,166095,166104,166126,166131,166133,166162,166186,166187,166238,166263,166417,166443,166549,166632,166666,166696,168755,168897,168915)
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: 0.49273 seconds
Time After: 0.49892 seconds
Time Taken: 0.00619 seconds

Memory Before: 6,733.523 KB
Memory After: 6,811.781 KB
Memory Used: 78.258 KB

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

Time Before: 0.51130 seconds
Time After: 0.51174 seconds
Time Taken: 0.00044 seconds

Memory Before: 7,236.180 KB
Memory After: 7,238.180 KB
Memory Used: 2.000 KB

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

Time Before: 0.51249 seconds
Time After: 0.51290 seconds
Time Taken: 0.00040 seconds

Memory Before: 7,236.563 KB
Memory After: 7,238.563 KB
Memory Used: 2.000 KB

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

Time Before: 0.58885 seconds
Time After: 0.59022 seconds
Time Taken: 0.00137 seconds

Memory Before: 7,242.563 KB
Memory After: 7,244.570 KB
Memory Used: 2.008 KB

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

Time Before: 0.60566 seconds
Time After: 0.60653 seconds
Time Taken: 0.00087 seconds

Memory Before: 7,382.320 KB
Memory After: 7,384.313 KB
Memory Used: 1.992 KB

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

Time Before: 0.60762 seconds
Time After: 0.60857 seconds
Time Taken: 0.00096 seconds

Memory Before: 7,382.703 KB
Memory After: 7,384.695 KB
Memory Used: 1.992 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: 0.60928 seconds
Time After: 0.61034 seconds
Time Taken: 0.00107 seconds

Memory Before: 7,384.320 KB
Memory After: 7,386.305 KB
Memory Used: 1.984 KB

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

Time Before: 0.61461 seconds
Time After: 0.61534 seconds
Time Taken: 0.00072 seconds

Memory Before: 7,430.750 KB
Memory After: 7,432.758 KB
Memory Used: 2.008 KB

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

Time Before: 0.61592 seconds
Time After: 0.61619 seconds
Time Taken: 0.00027 seconds

Memory Before: 7,431.133 KB
Memory After: 7,433.141 KB
Memory Used: 2.008 KB

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

Time Before: 0.68891 seconds
Time After: 0.69026 seconds
Time Taken: 0.00135 seconds

Memory Before: 7,435.836 KB
Memory After: 7,437.820 KB
Memory Used: 1.984 KB

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

Time Before: 0.70414 seconds
Time After: 0.70462 seconds
Time Taken: 0.00048 seconds

Memory Before: 7,546.789 KB
Memory After: 7,548.789 KB
Memory Used: 2.000 KB

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

Time Before: 0.70547 seconds
Time After: 0.70599 seconds
Time Taken: 0.00053 seconds

Memory Before: 7,547.172 KB
Memory After: 7,549.172 KB
Memory Used: 2.000 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: 0.70654 seconds
Time After: 0.70755 seconds
Time Taken: 0.00101 seconds

Memory Before: 7,549.023 KB
Memory After: 7,551.023 KB
Memory Used: 2.000 KB

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

Time Before: 0.71194 seconds
Time After: 0.71228 seconds
Time Taken: 0.00034 seconds

Memory Before: 7,638.039 KB
Memory After: 7,640.031 KB
Memory Used: 1.992 KB

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

Time Before: 0.71285 seconds
Time After: 0.71313 seconds
Time Taken: 0.00029 seconds

Memory Before: 7,638.422 KB
Memory After: 7,640.414 KB
Memory Used: 1.992 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: 0.71355 seconds
Time After: 0.71421 seconds
Time Taken: 0.00066 seconds

Memory Before: 7,640.469 KB
Memory After: 7,642.453 KB
Memory Used: 1.984 KB

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

Time Before: 0.79567 seconds
Time After: 0.79628 seconds
Time Taken: 0.00061 seconds

Memory Before: 7,733.789 KB
Memory After: 7,735.781 KB
Memory Used: 1.992 KB

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

Time Before: 0.79722 seconds
Time After: 0.79779 seconds
Time Taken: 0.00056 seconds

Memory Before: 7,734.172 KB
Memory After: 7,736.164 KB
Memory Used: 1.992 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: 0.79902 seconds
Time After: 0.80003 seconds
Time Taken: 0.00100 seconds

Memory Before: 7,736.281 KB
Memory After: 7,738.266 KB
Memory Used: 1.984 KB

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

Time Before: 0.89218 seconds
Time After: 0.89279 seconds
Time Taken: 0.00060 seconds

Memory Before: 7,830.281 KB
Memory After: 7,832.273 KB
Memory Used: 1.992 KB

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

Time Before: 0.89369 seconds
Time After: 0.89460 seconds
Time Taken: 0.00090 seconds

Memory Before: 7,830.664 KB
Memory After: 7,832.656 KB
Memory Used: 1.992 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: 0.89585 seconds
Time After: 0.89714 seconds
Time Taken: 0.00129 seconds

Memory Before: 7,832.273 KB
Memory After: 7,834.258 KB
Memory Used: 1.984 KB

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

Time Before: 0.90727 seconds
Time After: 0.90779 seconds
Time Taken: 0.00052 seconds

Memory Before: 7,886.289 KB
Memory After: 7,888.289 KB
Memory Used: 2.000 KB

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

Time Before: 0.90885 seconds
Time After: 0.90957 seconds
Time Taken: 0.00072 seconds

Memory Before: 7,886.672 KB
Memory After: 7,888.680 KB
Memory Used: 2.008 KB

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

Time Before: 0.91154 seconds
Time After: 0.91257 seconds
Time Taken: 0.00102 seconds

Memory Before: 7,891.445 KB
Memory After: 7,893.430 KB
Memory Used: 1.984 KB

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

Time Before: 1.00091 seconds
Time After: 1.00179 seconds
Time Taken: 0.00087 seconds

Memory Before: 7,995.836 KB
Memory After: 7,997.859 KB
Memory Used: 2.023 KB

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

Time Before: 1.00233 seconds
Time After: 1.00279 seconds
Time Taken: 0.00046 seconds

Memory Before: 7,996.219 KB
Memory After: 7,998.242 KB
Memory Used: 2.023 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: 1.00339 seconds
Time After: 1.00431 seconds
Time Taken: 0.00093 seconds

Memory Before: 7,998.063 KB
Memory After: 8,000.070 KB
Memory Used: 2.008 KB

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

Time Before: 1.00915 seconds
Time After: 1.00953 seconds
Time Taken: 0.00038 seconds

Memory Before: 8,088.609 KB
Memory After: 8,090.609 KB
Memory Used: 2.000 KB

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

Time Before: 1.01049 seconds
Time After: 1.01097 seconds
Time Taken: 0.00048 seconds

Memory Before: 8,089.023 KB
Memory After: 8,091.016 KB
Memory Used: 1.992 KB

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

Time Before: 1.01261 seconds
Time After: 1.01353 seconds
Time Taken: 0.00092 seconds

Memory Before: 8,093.852 KB
Memory After: 8,095.836 KB
Memory Used: 1.984 KB

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

Time Before: 1.09992 seconds
Time After: 1.10080 seconds
Time Taken: 0.00088 seconds

Memory Before: 8,196.289 KB
Memory After: 8,198.289 KB
Memory Used: 2.000 KB

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

Time Before: 1.10138 seconds
Time After: 1.10183 seconds
Time Taken: 0.00045 seconds

Memory Before: 8,196.688 KB
Memory After: 8,198.688 KB
Memory Used: 2.000 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: 1.10244 seconds
Time After: 1.10333 seconds
Time Taken: 0.00090 seconds

Memory Before: 8,199.047 KB
Memory After: 8,201.031 KB
Memory Used: 1.984 KB

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

Time Before: 1.18890 seconds
Time After: 1.18980 seconds
Time Taken: 0.00090 seconds

Memory Before: 8,292.094 KB
Memory After: 8,294.102 KB
Memory Used: 2.008 KB

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

Time Before: 1.19095 seconds
Time After: 1.19185 seconds
Time Taken: 0.00090 seconds

Memory Before: 8,292.477 KB
Memory After: 8,294.484 KB
Memory Used: 2.008 KB

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

Time Before: 1.19517 seconds
Time After: 1.19618 seconds
Time Taken: 0.00101 seconds

Memory Before: 8,296.977 KB
Memory After: 8,298.984 KB
Memory Used: 2.008 KB

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

Time Before: 1.20919 seconds
Time After: 1.20967 seconds
Time Taken: 0.00048 seconds

Memory Before: 8,405.930 KB
Memory After: 8,407.922 KB
Memory Used: 1.992 KB

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

Time Before: 1.21024 seconds
Time After: 1.21075 seconds
Time Taken: 0.00051 seconds

Memory Before: 8,406.313 KB
Memory After: 8,408.305 KB
Memory Used: 1.992 KB

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

Time Before: 1.21125 seconds
Time After: 1.21207 seconds
Time Taken: 0.00082 seconds

Memory Before: 8,408.102 KB
Memory After: 8,410.070 KB
Memory Used: 1.969 KB

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

Time Before: 1.29314 seconds
Time After: 1.29401 seconds
Time Taken: 0.00087 seconds

Memory Before: 8,461.852 KB
Memory After: 8,463.844 KB
Memory Used: 1.992 KB

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

Time Before: 1.29510 seconds
Time After: 1.29597 seconds
Time Taken: 0.00087 seconds

Memory Before: 8,462.234 KB
Memory After: 8,464.227 KB
Memory Used: 1.992 KB

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

Time Before: 1.29705 seconds
Time After: 1.29820 seconds
Time Taken: 0.00115 seconds

Memory Before: 8,464.406 KB
Memory After: 8,466.391 KB
Memory Used: 1.984 KB

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

Time Before: 1.30625 seconds
Time After: 1.30644 seconds
Time Taken: 0.00019 seconds

Memory Before: 8,566.445 KB
Memory After: 8,568.445 KB
Memory Used: 2.000 KB

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

Time Before: 1.30674 seconds
Time After: 1.30717 seconds
Time Taken: 0.00043 seconds

Memory Before: 8,566.875 KB
Memory After: 8,568.875 KB
Memory Used: 2.000 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: 1.30750 seconds
Time After: 1.30826 seconds
Time Taken: 0.00076 seconds

Memory Before: 8,569.086 KB
Memory After: 8,571.055 KB
Memory Used: 1.969 KB

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

Time Before: 1.38908 seconds
Time After: 1.39008 seconds
Time Taken: 0.00100 seconds

Memory Before: 8,669.633 KB
Memory After: 8,671.617 KB
Memory Used: 1.984 KB

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

Time Before: 1.39123 seconds
Time After: 1.39191 seconds
Time Taken: 0.00067 seconds

Memory Before: 8,670.031 KB
Memory After: 8,672.031 KB
Memory Used: 2.000 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.39545 seconds
Time After: 1.39640 seconds
Time Taken: 0.00095 seconds

Memory Before: 8,674.445 KB
Memory After: 8,676.422 KB
Memory Used: 1.977 KB

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

Time Before: 1.40896 seconds
Time After: 1.40933 seconds
Time Taken: 0.00038 seconds

Memory Before: 8,779.586 KB
Memory After: 8,781.578 KB
Memory Used: 1.992 KB

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

Time Before: 1.40997 seconds
Time After: 1.41030 seconds
Time Taken: 0.00034 seconds

Memory Before: 8,779.977 KB
Memory After: 8,781.961 KB
Memory Used: 1.984 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: 1.41092 seconds
Time After: 1.41179 seconds
Time Taken: 0.00087 seconds

Memory Before: 8,782.422 KB
Memory After: 8,784.406 KB
Memory Used: 1.984 KB

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

Time Before: 1.49567 seconds
Time After: 1.49612 seconds
Time Taken: 0.00045 seconds

Memory Before: 8,870.844 KB
Memory After: 8,872.844 KB
Memory Used: 2.000 KB

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

Time Before: 1.49669 seconds
Time After: 1.49705 seconds
Time Taken: 0.00036 seconds

Memory Before: 8,871.273 KB
Memory After: 8,873.273 KB
Memory Used: 2.000 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.49943 seconds
Time After: 1.50029 seconds
Time Taken: 0.00086 seconds

Memory Before: 8,876.172 KB
Memory After: 8,878.164 KB
Memory Used: 1.992 KB

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

Time Before: 1.50889 seconds
Time After: 1.50926 seconds
Time Taken: 0.00037 seconds

Memory Before: 8,980.414 KB
Memory After: 8,982.414 KB
Memory Used: 2.000 KB

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

Time Before: 1.50989 seconds
Time After: 1.51023 seconds
Time Taken: 0.00033 seconds

Memory Before: 8,980.836 KB
Memory After: 8,982.820 KB
Memory Used: 1.984 KB

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

Time Before: 1.51089 seconds
Time After: 1.51208 seconds
Time Taken: 0.00119 seconds

Memory Before: 8,982.695 KB
Memory After: 8,984.672 KB
Memory Used: 1.977 KB

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

Time Before: 1.60695 seconds
Time After: 1.60744 seconds
Time Taken: 0.00049 seconds

Memory Before: 9,032.961 KB
Memory After: 9,034.961 KB
Memory Used: 2.000 KB

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

Time Before: 1.60821 seconds
Time After: 1.60879 seconds
Time Taken: 0.00058 seconds

Memory Before: 9,033.367 KB
Memory After: 9,035.367 KB
Memory Used: 2.000 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: 1.60954 seconds
Time After: 1.61039 seconds
Time Taken: 0.00085 seconds

Memory Before: 9,033.477 KB
Memory After: 9,035.484 KB
Memory Used: 2.008 KB

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

Time Before: 1.70516 seconds
Time After: 1.70554 seconds
Time Taken: 0.00039 seconds

Memory Before: 9,135.977 KB
Memory After: 9,137.977 KB
Memory Used: 2.000 KB

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

Time Before: 1.70684 seconds
Time After: 1.70741 seconds
Time Taken: 0.00058 seconds

Memory Before: 9,136.375 KB
Memory After: 9,138.375 KB
Memory Used: 2.000 KB

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

Time Before: 1.70905 seconds
Time After: 1.70990 seconds
Time Taken: 0.00085 seconds

Memory Before: 9,141.188 KB
Memory After: 9,143.172 KB
Memory Used: 1.984 KB

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

Time Before: 1.80100 seconds
Time After: 1.80144 seconds
Time Taken: 0.00044 seconds

Memory Before: 9,243.086 KB
Memory After: 9,245.086 KB
Memory Used: 2.000 KB

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

Time Before: 1.80205 seconds
Time After: 1.80238 seconds
Time Taken: 0.00033 seconds

Memory Before: 9,243.484 KB
Memory After: 9,245.484 KB
Memory Used: 2.000 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: 1.80287 seconds
Time After: 1.80343 seconds
Time Taken: 0.00056 seconds

Memory Before: 9,245.484 KB
Memory After: 9,247.477 KB
Memory Used: 1.992 KB

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

Time Before: 1.80756 seconds
Time After: 1.80777 seconds
Time Taken: 0.00021 seconds

Memory Before: 9,334.094 KB
Memory After: 9,336.094 KB
Memory Used: 2.000 KB

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

Time Before: 1.80808 seconds
Time After: 1.80831 seconds
Time Taken: 0.00024 seconds

Memory Before: 9,334.492 KB
Memory After: 9,336.484 KB
Memory Used: 1.992 KB

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

Time Before: 1.80857 seconds
Time After: 1.80892 seconds
Time Taken: 0.00035 seconds

Memory Before: 9,336.055 KB
Memory After: 9,338.031 KB
Memory Used: 1.977 KB

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

Time Before: 1.89625 seconds
Time After: 1.89643 seconds
Time Taken: 0.00018 seconds

Memory Before: 9,388.938 KB
Memory After: 9,390.938 KB
Memory Used: 2.000 KB

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

Time Before: 1.89671 seconds
Time After: 1.89684 seconds
Time Taken: 0.00012 seconds

Memory Before: 9,389.359 KB
Memory After: 9,391.359 KB
Memory Used: 2.000 KB

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

Time Before: 1.89811 seconds
Time After: 1.89844 seconds
Time Taken: 0.00033 seconds

Memory Before: 9,394.383 KB
Memory After: 9,396.367 KB
Memory Used: 1.984 KB

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

Time Before: 1.90530 seconds
Time After: 1.90549 seconds
Time Taken: 0.00020 seconds

Memory Before: 9,502.625 KB
Memory After: 9,504.625 KB
Memory Used: 2.000 KB

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

Time Before: 1.90613 seconds
Time After: 1.90648 seconds
Time Taken: 0.00035 seconds

Memory Before: 9,503.023 KB
Memory After: 9,505.031 KB
Memory Used: 2.008 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.90944 seconds
Time After: 1.98875 seconds
Time Taken: 0.07931 seconds

Memory Before: 9,507.961 KB
Memory After: 9,509.938 KB
Memory Used: 1.977 KB

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

Time Before: 2.00370 seconds
Time After: 2.00458 seconds
Time Taken: 0.00088 seconds

Memory Before: 9,606.328 KB
Memory After: 9,608.336 KB
Memory Used: 2.008 KB

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

Time Before: 2.00560 seconds
Time After: 2.00652 seconds
Time Taken: 0.00091 seconds

Memory Before: 9,606.742 KB
Memory After: 9,608.750 KB
Memory Used: 2.008 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: 2.00729 seconds
Time After: 2.00815 seconds
Time Taken: 0.00086 seconds

Memory Before: 9,609.430 KB
Memory After: 9,611.422 KB
Memory Used: 1.992 KB

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

Time Before: 2.09181 seconds
Time After: 2.09254 seconds
Time Taken: 0.00073 seconds

Memory Before: 9,699.820 KB
Memory After: 9,701.867 KB
Memory Used: 2.047 KB

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

Time Before: 2.09371 seconds
Time After: 2.09451 seconds
Time Taken: 0.00080 seconds

Memory Before: 9,700.234 KB
Memory After: 9,702.273 KB
Memory Used: 2.039 KB

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

Time Before: 2.09581 seconds
Time After: 2.09705 seconds
Time Taken: 0.00124 seconds

Memory Before: 9,702.016 KB
Memory After: 9,704.023 KB
Memory Used: 2.008 KB

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

Time Before: 2.10744 seconds
Time After: 2.10796 seconds
Time Taken: 0.00052 seconds

Memory Before: 9,754.109 KB
Memory After: 9,756.109 KB
Memory Used: 2.000 KB

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

Time Before: 2.10850 seconds
Time After: 2.10898 seconds
Time Taken: 0.00048 seconds

Memory Before: 9,754.500 KB
Memory After: 9,756.508 KB
Memory Used: 2.008 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.19170 seconds
Time After: 2.19285 seconds
Time Taken: 0.00115 seconds

Memory Before: 9,759.484 KB
Memory After: 9,761.484 KB
Memory Used: 2.000 KB

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

Time Before: 2.20541 seconds
Time After: 2.20593 seconds
Time Taken: 0.00052 seconds

Memory Before: 9,867.984 KB
Memory After: 9,870.016 KB
Memory Used: 2.031 KB

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

Time Before: 2.20648 seconds
Time After: 2.20693 seconds
Time Taken: 0.00046 seconds

Memory Before: 9,868.414 KB
Memory After: 9,870.469 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: 2.20753 seconds
Time After: 2.20842 seconds
Time Taken: 0.00090 seconds

Memory Before: 9,870.359 KB
Memory After: 9,872.375 KB
Memory Used: 2.016 KB

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

Time Before: 2.21291 seconds
Time After: 2.21329 seconds
Time Taken: 0.00038 seconds

Memory Before: 9,967.156 KB
Memory After: 9,969.234 KB
Memory Used: 2.078 KB

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

Time Before: 2.21394 seconds
Time After: 2.21428 seconds
Time Taken: 0.00034 seconds

Memory Before: 9,967.586 KB
Memory After: 9,969.586 KB
Memory Used: 2.000 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: 2.21490 seconds
Time After: 2.21576 seconds
Time Taken: 0.00086 seconds

Memory Before: 9,969.672 KB
Memory After: 9,971.719 KB
Memory Used: 2.047 KB

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

Time Before: 2.29845 seconds
Time After: 2.29903 seconds
Time Taken: 0.00058 seconds

Memory Before: 10,067.445 KB
Memory After: 10,069.461 KB
Memory Used: 2.016 KB

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

Time Before: 2.29995 seconds
Time After: 2.30081 seconds
Time Taken: 0.00087 seconds

Memory Before: 10,067.906 KB
Memory After: 10,069.930 KB
Memory Used: 2.023 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: 2.30195 seconds
Time After: 2.30338 seconds
Time Taken: 0.00144 seconds

Memory Before: 10,070.125 KB
Memory After: 10,072.180 KB
Memory Used: 2.055 KB

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

Time Before: 2.40000 seconds
Time After: 2.40083 seconds
Time Taken: 0.00083 seconds

Memory Before: 10,170.086 KB
Memory After: 10,172.078 KB
Memory Used: 1.992 KB

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

Time Before: 2.40147 seconds
Time After: 2.40195 seconds
Time Taken: 0.00048 seconds

Memory Before: 10,170.477 KB
Memory After: 10,172.469 KB
Memory Used: 1.992 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.40428 seconds
Time After: 2.40518 seconds
Time Taken: 0.00090 seconds

Memory Before: 10,174.797 KB
Memory After: 10,176.813 KB
Memory Used: 2.016 KB

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

Time Before: 2.48918 seconds
Time After: 2.49009 seconds
Time Taken: 0.00091 seconds

Memory Before: 10,280.859 KB
Memory After: 10,282.891 KB
Memory Used: 2.031 KB

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

Time Before: 2.49120 seconds
Time After: 2.49177 seconds
Time Taken: 0.00057 seconds

Memory Before: 10,281.320 KB
Memory After: 10,283.391 KB
Memory Used: 2.070 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: 2.49314 seconds
Time After: 2.49418 seconds
Time Taken: 0.00104 seconds

Memory Before: 10,283.367 KB
Memory After: 10,285.367 KB
Memory Used: 2.000 KB

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

Time Before: 2.50443 seconds
Time After: 2.50495 seconds
Time Taken: 0.00052 seconds

Memory Before: 10,371.703 KB
Memory After: 10,373.711 KB
Memory Used: 2.008 KB

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

Time Before: 2.50555 seconds
Time After: 2.50599 seconds
Time Taken: 0.00045 seconds

Memory Before: 10,372.125 KB
Memory After: 10,374.125 KB
Memory Used: 2.000 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.50823 seconds
Time After: 2.50914 seconds
Time Taken: 0.00090 seconds

Memory Before: 10,377.531 KB
Memory After: 10,379.727 KB
Memory Used: 2.195 KB

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

Time Before: 2.59949 seconds
Time After: 2.59999 seconds
Time Taken: 0.00050 seconds

Memory Before: 10,485.633 KB
Memory After: 10,487.656 KB
Memory Used: 2.023 KB

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

Time Before: 2.60067 seconds
Time After: 2.60142 seconds
Time Taken: 0.00075 seconds

Memory Before: 10,486.039 KB
Memory After: 10,488.063 KB
Memory Used: 2.023 KB

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

Time Before: 2.60231 seconds
Time After: 2.60359 seconds
Time Taken: 0.00129 seconds

Memory Before: 10,487.750 KB
Memory After: 10,489.773 KB
Memory Used: 2.023 KB

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

Time Before: 2.69371 seconds
Time After: 2.69447 seconds
Time Taken: 0.00076 seconds

Memory Before: 10,536.797 KB
Memory After: 10,538.852 KB
Memory Used: 2.055 KB

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

Time Before: 2.69569 seconds
Time After: 2.69632 seconds
Time Taken: 0.00063 seconds

Memory Before: 10,537.258 KB
Memory After: 10,539.281 KB
Memory Used: 2.023 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: 2.69762 seconds
Time After: 2.69863 seconds
Time Taken: 0.00102 seconds

Memory Before: 10,539.156 KB
Memory After: 10,541.211 KB
Memory Used: 2.055 KB

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

Time Before: 2.70914 seconds
Time After: 2.70981 seconds
Time Taken: 0.00067 seconds

Memory Before: 10,635.672 KB
Memory After: 10,637.766 KB
Memory Used: 2.094 KB

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

Time Before: 2.71044 seconds
Time After: 2.71097 seconds
Time Taken: 0.00052 seconds

Memory Before: 10,636.102 KB
Memory After: 10,638.125 KB
Memory Used: 2.023 KB

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

Time Before: 2.71319 seconds
Time After: 2.71410 seconds
Time Taken: 0.00091 seconds

Memory Before: 10,641.172 KB
Memory After: 10,643.188 KB
Memory Used: 2.016 KB

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

Time Before: 2.79385 seconds
Time After: 2.79458 seconds
Time Taken: 0.00073 seconds

Memory Before: 10,767.047 KB
Memory After: 10,769.125 KB
Memory Used: 2.078 KB

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

Time Before: 2.79587 seconds
Time After: 2.79654 seconds
Time Taken: 0.00067 seconds

Memory Before: 10,767.445 KB
Memory After: 10,769.508 KB
Memory Used: 2.063 KB

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

Time Before: 2.79769 seconds
Time After: 2.79897 seconds
Time Taken: 0.00129 seconds

Memory Before: 10,768.969 KB
Memory After: 10,771.016 KB
Memory Used: 2.047 KB

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

Time Before: 2.80625 seconds
Time After: 2.80669 seconds
Time Taken: 0.00043 seconds

Memory Before: 10,818.898 KB
Memory After: 10,820.938 KB
Memory Used: 2.039 KB

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

Time Before: 2.80771 seconds
Time After: 2.80841 seconds
Time Taken: 0.00070 seconds

Memory Before: 10,819.266 KB
Memory After: 10,821.297 KB
Memory Used: 2.031 KB

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

Time Before: 2.80919 seconds
Time After: 2.81003 seconds
Time Taken: 0.00084 seconds

Memory Before: 10,821.602 KB
Memory After: 10,823.609 KB
Memory Used: 2.008 KB

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

Time Before: 2.90227 seconds
Time After: 2.90287 seconds
Time Taken: 0.00060 seconds

Memory Before: 10,888.578 KB
Memory After: 10,890.656 KB
Memory Used: 2.078 KB

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

Time Before: 2.90391 seconds
Time After: 2.90477 seconds
Time Taken: 0.00086 seconds

Memory Before: 10,888.984 KB
Memory After: 10,891.070 KB
Memory Used: 2.086 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.90699 seconds
Time After: 2.90799 seconds
Time Taken: 0.00101 seconds

Memory Before: 10,893.609 KB
Memory After: 10,895.797 KB
Memory Used: 2.188 KB

Time after parsing all posts: 2.9134750366211 Memory After: 11,375KB
SQL Query
SELECT template
FROM template
WHERE templateid = 4659
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplateconstPRIMARYPRIMARY4const1 

Time Before: 2.99025 seconds
Time After: 2.99112 seconds
Time Taken: 0.00087 seconds

Memory Before: 11,429.188 KB
Memory After: 11,431.219 KB
Memory Used: 2.031 KB

SQL Query
UPDATE session
SET location = '/vb/showthread.php?explain=1&nojs=1&p=166696', inforum = 36, inthread = 9449, incalendar = 0, badlocation = 0, useragent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
WHERE sessionhash = '22cf1542b6754fc99cb18dd2586cf524'

Time Before: 3.00580 seconds
Time After: 3.00664 seconds
Time Taken: 0.00085 seconds

Memory Before: 13,880.117 KB
Memory After: 13,880.258 KB
Memory Used: 0.141 KB

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

Time Before: 3.00671 seconds
Time After: 3.00739 seconds
Time Taken: 0.00068 seconds

Memory Before: 13,873.828 KB
Memory After: 13,874.125 KB
Memory Used: 0.297 KB

Page generated in 2.9981529712677 seconds with 146 queries, spending 0.27499532699585 doing MySQL queries and 2.7231576442719 doing PHP things.
Shutdown Queries:
DISABLED