Including Functions.php

Time Before: 0.00216 seconds
Time After: 0.00542 seconds
Time Taken: 0.00326 seconds

Memory Before: 1,565.320 KB
Memory After: 2,309.555 KB
Memory Used: 744.234 KB

Connect to Database on Server: localhost

Time Before: 0.00546 seconds
Time After: 0.00591 seconds
Time Taken: 0.00045 seconds

Memory Before: 2,309.539 KB
Memory After: 2,317.086 KB
Memory Used: 7.547 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00614 seconds
Time After: 0.00664 seconds
Time Taken: 0.00049 seconds

Memory Before: 2,317.797 KB
Memory After: 2,318.359 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.00753 seconds
Time After: 0.00961 seconds
Time Taken: 0.00208 seconds

Memory Before: 2,321.234 KB
Memory After: 2,367.711 KB
Memory Used: 46.477 KB

Time Before: 0.00670 seconds
Time After: 0.08784 seconds
Time Taken: 0.08114 seconds

Memory Before: 2,317.602 KB
Memory After: 3,946.961 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.08993 seconds
Time After: 0.09043 seconds
Time Taken: 0.00050 seconds

Memory Before: 3,971.797 KB
Memory After: 3,974.305 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.09185 seconds
Time After: 0.09227 seconds
Time Taken: 0.00042 seconds

Memory Before: 3,997.750 KB
Memory After: 4,003.219 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.09357 seconds
Time After: 0.09412 seconds
Time Taken: 0.00055 seconds

Memory Before: 4,009.250 KB
Memory After: 4,015.281 KB
Memory Used: 6.031 KB

Time Before: 0.09092 seconds
Time After: 0.09425 seconds
Time Taken: 0.00333 seconds

Memory Before: 3,992.938 KB
Memory After: 4,076.328 KB
Memory Used: 83.391 KB

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



thread.*


FROM thread AS thread






WHERE thread.threadid = 6896
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEthreadconstPRIMARYPRIMARY4const1 

Time Before: 0.09857 seconds
Time After: 0.09890 seconds
Time Taken: 0.00033 seconds

Memory Before: 4,209.609 KB
Memory After: 4,220.383 KB
Memory Used: 10.773 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.09974 seconds
Time After: 0.10009 seconds
Time Taken: 0.00035 seconds

Memory Before: 4,225.805 KB
Memory After: 4,230.297 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.10194 seconds
Time After: 0.10454 seconds
Time Taken: 0.00260 seconds

Memory Before: 4,457.805 KB
Memory After: 4,462.273 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.40287 seconds
Time After: 0.40322 seconds
Time Taken: 0.00034 seconds

Memory Before: 6,104.336 KB
Memory After: 6,106.336 KB
Memory Used: 2.000 KB

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

Time Before: 0.40329 seconds
Time After: 0.40592 seconds
Time Taken: 0.00263 seconds

Memory Before: 6,106.523 KB
Memory After: 6,106.891 KB
Memory Used: 0.367 KB

SQL Query
DELETE FROM cybvilxh_guests WHERE dateline < '1759322622'

Time Before: 0.40598 seconds
Time After: 0.40620 seconds
Time Taken: 0.00022 seconds

Memory Before: 6,104.203 KB
Memory After: 6,104.492 KB
Memory Used: 0.289 KB

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

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

Time Before: 0.49049 seconds
Time After: 0.49140 seconds
Time Taken: 0.00091 seconds

Memory Before: 5,661.781 KB
Memory After: 5,663.898 KB
Memory Used: 2.117 KB

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

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

Time Before: 0.49237 seconds
Time After: 0.49308 seconds
Time Taken: 0.00071 seconds

Memory Before: 5,662.531 KB
Memory After: 5,664.641 KB
Memory Used: 2.109 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 = 6896
	
ORDER BY postid
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefthreadid,threadid_2threadid4const28Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4abotglb_vb368.post.userid1 
1SIMPLEuserfieldeq_refPRIMARYPRIMARY4abotglb_vb368.user.userid1Using where

Time Before: 0.49709 seconds
Time After: 0.49879 seconds
Time Taken: 0.00170 seconds

Memory Before: 5,748.484 KB
Memory After: 5,802.078 KB
Memory Used: 53.594 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 (116421,116423,116432,116457,116494,116570,116736,116748,116750,116838,116989,117001,117049,117155,117922,117951,118040,119433,119487,119497,119498,119944,139976,141733,141735,141737,141738,165243)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostparsedsystemPRIMARY   0Const row not found
1SIMPLEpostrangePRIMARYPRIMARY4 28Using 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.50457 seconds
Time After: 0.50880 seconds
Time Taken: 0.00423 seconds

Memory Before: 6,396.242 KB
Memory After: 6,460.906 KB
Memory Used: 64.664 KB

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

Time Before: 0.59667 seconds
Time After: 0.59707 seconds
Time Taken: 0.00039 seconds

Memory Before: 6,913.469 KB
Memory After: 6,915.461 KB
Memory Used: 1.992 KB

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

Time Before: 0.59768 seconds
Time After: 0.59813 seconds
Time Taken: 0.00045 seconds

Memory Before: 6,913.852 KB
Memory After: 6,915.844 KB
Memory Used: 1.992 KB

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

Time Before: 0.59892 seconds
Time After: 0.60023 seconds
Time Taken: 0.00132 seconds

Memory Before: 6,915.859 KB
Memory After: 6,917.844 KB
Memory Used: 1.984 KB

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

Time Before: 0.60638 seconds
Time After: 0.60721 seconds
Time Taken: 0.00083 seconds

Memory Before: 7,062.805 KB
Memory After: 7,064.797 KB
Memory Used: 1.992 KB

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

Time Before: 0.60783 seconds
Time After: 0.60815 seconds
Time Taken: 0.00032 seconds

Memory Before: 7,063.188 KB
Memory After: 7,065.180 KB
Memory Used: 1.992 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: 0.60877 seconds
Time After: 0.60963 seconds
Time Taken: 0.00086 seconds

Memory Before: 7,065.367 KB
Memory After: 7,067.344 KB
Memory Used: 1.977 KB

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

Time Before: 0.69199 seconds
Time After: 0.69221 seconds
Time Taken: 0.00022 seconds

Memory Before: 7,156.414 KB
Memory After: 7,158.406 KB
Memory Used: 1.992 KB

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

Time Before: 0.69274 seconds
Time After: 0.69359 seconds
Time Taken: 0.00085 seconds

Memory Before: 7,156.797 KB
Memory After: 7,158.789 KB
Memory Used: 1.992 KB

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

Time Before: 0.69431 seconds
Time After: 0.69513 seconds
Time Taken: 0.00082 seconds

Memory Before: 7,159.344 KB
Memory After: 7,161.328 KB
Memory Used: 1.984 KB

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

Time Before: 0.70079 seconds
Time After: 0.70105 seconds
Time Taken: 0.00026 seconds

Memory Before: 7,257.414 KB
Memory After: 7,259.406 KB
Memory Used: 1.992 KB

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

Time Before: 0.70162 seconds
Time After: 0.70216 seconds
Time Taken: 0.00054 seconds

Memory Before: 7,257.797 KB
Memory After: 7,259.789 KB
Memory Used: 1.992 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: 0.70259 seconds
Time After: 0.70319 seconds
Time Taken: 0.00060 seconds

Memory Before: 7,260.352 KB
Memory After: 7,262.328 KB
Memory Used: 1.977 KB

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

Time Before: 0.70712 seconds
Time After: 0.70757 seconds
Time Taken: 0.00045 seconds

Memory Before: 7,355.352 KB
Memory After: 7,357.344 KB
Memory Used: 1.992 KB

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

Time Before: 0.70803 seconds
Time After: 0.70858 seconds
Time Taken: 0.00054 seconds

Memory Before: 7,355.734 KB
Memory After: 7,357.727 KB
Memory Used: 1.992 KB

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

Time Before: 0.70922 seconds
Time After: 0.71007 seconds
Time Taken: 0.00085 seconds

Memory Before: 7,358.352 KB
Memory After: 7,360.359 KB
Memory Used: 2.008 KB

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

Time Before: 0.79499 seconds
Time After: 0.79522 seconds
Time Taken: 0.00023 seconds

Memory Before: 7,458.672 KB
Memory After: 7,460.664 KB
Memory Used: 1.992 KB

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

Time Before: 0.79569 seconds
Time After: 0.79612 seconds
Time Taken: 0.00042 seconds

Memory Before: 7,459.055 KB
Memory After: 7,461.047 KB
Memory Used: 1.992 KB

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

Time Before: 0.79680 seconds
Time After: 0.79773 seconds
Time Taken: 0.00094 seconds

Memory Before: 7,461.477 KB
Memory After: 7,463.461 KB
Memory Used: 1.984 KB

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

Time Before: 0.80264 seconds
Time After: 0.80310 seconds
Time Taken: 0.00045 seconds

Memory Before: 7,563.789 KB
Memory After: 7,565.781 KB
Memory Used: 1.992 KB

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

Time Before: 0.80361 seconds
Time After: 0.80396 seconds
Time Taken: 0.00035 seconds

Memory Before: 7,564.172 KB
Memory After: 7,566.164 KB
Memory Used: 1.992 KB

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

Time Before: 0.80445 seconds
Time After: 0.80518 seconds
Time Taken: 0.00073 seconds

Memory Before: 7,565.766 KB
Memory After: 7,567.750 KB
Memory Used: 1.984 KB

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

Time Before: 0.80862 seconds
Time After: 0.80886 seconds
Time Taken: 0.00024 seconds

Memory Before: 7,610.672 KB
Memory After: 7,612.672 KB
Memory Used: 2.000 KB

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

Time Before: 0.80916 seconds
Time After: 0.80937 seconds
Time Taken: 0.00021 seconds

Memory Before: 7,611.063 KB
Memory After: 7,613.078 KB
Memory Used: 2.016 KB

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

Time Before: 0.80977 seconds
Time After: 0.81045 seconds
Time Taken: 0.00068 seconds

Memory Before: 7,613.633 KB
Memory After: 7,615.641 KB
Memory Used: 2.008 KB

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

Time Before: 0.89181 seconds
Time After: 0.89201 seconds
Time Taken: 0.00020 seconds

Memory Before: 7,714.117 KB
Memory After: 7,716.117 KB
Memory Used: 2.000 KB

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

Time Before: 0.89232 seconds
Time After: 0.89262 seconds
Time Taken: 0.00030 seconds

Memory Before: 7,714.500 KB
Memory After: 7,716.492 KB
Memory Used: 1.992 KB

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

Time Before: 0.89316 seconds
Time After: 0.89380 seconds
Time Taken: 0.00063 seconds

Memory Before: 7,717.086 KB
Memory After: 7,719.070 KB
Memory Used: 1.984 KB

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

Time Before: 0.90165 seconds
Time After: 0.90208 seconds
Time Taken: 0.00042 seconds

Memory Before: 7,819.031 KB
Memory After: 7,821.023 KB
Memory Used: 1.992 KB

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

Time Before: 0.90262 seconds
Time After: 0.90281 seconds
Time Taken: 0.00020 seconds

Memory Before: 7,819.414 KB
Memory After: 7,821.406 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.90311 seconds
Time After: 0.90361 seconds
Time Taken: 0.00050 seconds

Memory Before: 7,821.008 KB
Memory After: 7,822.992 KB
Memory Used: 1.984 KB

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

Time Before: 0.99380 seconds
Time After: 0.99407 seconds
Time Taken: 0.00027 seconds

Memory Before: 7,874.797 KB
Memory After: 7,876.781 KB
Memory Used: 1.984 KB

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

Time Before: 0.99457 seconds
Time After: 0.99479 seconds
Time Taken: 0.00023 seconds

Memory Before: 7,875.180 KB
Memory After: 7,877.203 KB
Memory Used: 2.023 KB

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

Time Before: 0.99541 seconds
Time After: 0.99622 seconds
Time Taken: 0.00081 seconds

Memory Before: 7,878.164 KB
Memory After: 7,880.172 KB
Memory Used: 2.008 KB

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

Time Before: 1.00361 seconds
Time After: 1.00400 seconds
Time Taken: 0.00039 seconds

Memory Before: 7,982.523 KB
Memory After: 7,984.516 KB
Memory Used: 1.992 KB

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

Time Before: 1.00453 seconds
Time After: 1.00490 seconds
Time Taken: 0.00037 seconds

Memory Before: 7,982.906 KB
Memory After: 7,984.898 KB
Memory Used: 1.992 KB

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

Time Before: 1.00541 seconds
Time After: 1.00615 seconds
Time Taken: 0.00073 seconds

Memory Before: 7,984.766 KB
Memory After: 7,986.750 KB
Memory Used: 1.984 KB

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

Time Before: 1.01076 seconds
Time After: 1.01113 seconds
Time Taken: 0.00036 seconds

Memory Before: 8,081.375 KB
Memory After: 8,083.375 KB
Memory Used: 2.000 KB

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

Time Before: 1.01173 seconds
Time After: 1.01207 seconds
Time Taken: 0.00034 seconds

Memory Before: 8,081.773 KB
Memory After: 8,083.773 KB
Memory Used: 2.000 KB

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

Time Before: 1.01269 seconds
Time After: 1.01344 seconds
Time Taken: 0.00076 seconds

Memory Before: 8,084.555 KB
Memory After: 8,086.539 KB
Memory Used: 1.984 KB

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

Time Before: 1.09608 seconds
Time After: 1.09646 seconds
Time Taken: 0.00037 seconds

Memory Before: 8,183.609 KB
Memory After: 8,185.602 KB
Memory Used: 1.992 KB

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

Time Before: 1.09731 seconds
Time After: 1.09794 seconds
Time Taken: 0.00063 seconds

Memory Before: 8,183.992 KB
Memory After: 8,185.984 KB
Memory Used: 1.992 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.09879 seconds
Time After: 1.09982 seconds
Time Taken: 0.00102 seconds

Memory Before: 8,186.492 KB
Memory After: 8,188.477 KB
Memory Used: 1.984 KB

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

Time Before: 1.18977 seconds
Time After: 1.19047 seconds
Time Taken: 0.00070 seconds

Memory Before: 8,283.227 KB
Memory After: 8,285.227 KB
Memory Used: 2.000 KB

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

Time Before: 1.19115 seconds
Time After: 1.19163 seconds
Time Taken: 0.00048 seconds

Memory Before: 8,283.617 KB
Memory After: 8,285.617 KB
Memory Used: 2.000 KB

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

Time Before: 1.19239 seconds
Time After: 1.19360 seconds
Time Taken: 0.00121 seconds

Memory Before: 8,286.258 KB
Memory After: 8,288.242 KB
Memory Used: 1.984 KB

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

Time Before: 1.20077 seconds
Time After: 1.20117 seconds
Time Taken: 0.00040 seconds

Memory Before: 8,385.313 KB
Memory After: 8,387.336 KB
Memory Used: 2.023 KB

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

Time Before: 1.20183 seconds
Time After: 1.20221 seconds
Time Taken: 0.00038 seconds

Memory Before: 8,385.695 KB
Memory After: 8,387.734 KB
Memory Used: 2.039 KB

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

Time Before: 1.20288 seconds
Time After: 1.20380 seconds
Time Taken: 0.00092 seconds

Memory Before: 8,387.563 KB
Memory After: 8,389.594 KB
Memory Used: 2.031 KB

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

Time Before: 1.20834 seconds
Time After: 1.20887 seconds
Time Taken: 0.00053 seconds

Memory Before: 8,482.156 KB
Memory After: 8,484.188 KB
Memory Used: 2.031 KB

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

Time Before: 1.20938 seconds
Time After: 1.21019 seconds
Time Taken: 0.00081 seconds

Memory Before: 8,482.586 KB
Memory After: 8,484.609 KB
Memory Used: 2.023 KB

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

Time Before: 1.21082 seconds
Time After: 1.21171 seconds
Time Taken: 0.00089 seconds

Memory Before: 8,485.516 KB
Memory After: 8,487.531 KB
Memory Used: 2.016 KB

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

Time Before: 1.29248 seconds
Time After: 1.29336 seconds
Time Taken: 0.00088 seconds

Memory Before: 8,585.836 KB
Memory After: 8,587.828 KB
Memory Used: 1.992 KB

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

Time Before: 1.29444 seconds
Time After: 1.29536 seconds
Time Taken: 0.00092 seconds

Memory Before: 8,586.219 KB
Memory After: 8,588.211 KB
Memory Used: 1.992 KB

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

Time Before: 1.29612 seconds
Time After: 1.29703 seconds
Time Taken: 0.00090 seconds

Memory Before: 8,587.688 KB
Memory After: 8,589.695 KB
Memory Used: 2.008 KB

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

Time Before: 1.30180 seconds
Time After: 1.30228 seconds
Time Taken: 0.00048 seconds

Memory Before: 8,643.227 KB
Memory After: 8,645.273 KB
Memory Used: 2.047 KB

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

Time Before: 1.30296 seconds
Time After: 1.30353 seconds
Time Taken: 0.00057 seconds

Memory Before: 8,643.633 KB
Memory After: 8,645.680 KB
Memory Used: 2.047 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: 1.30412 seconds
Time After: 1.30500 seconds
Time Taken: 0.00089 seconds

Memory Before: 8,646.305 KB
Memory After: 8,648.313 KB
Memory Used: 2.008 KB

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

Time Before: 1.30961 seconds
Time After: 1.31000 seconds
Time Taken: 0.00039 seconds

Memory Before: 8,746.539 KB
Memory After: 8,748.570 KB
Memory Used: 2.031 KB

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

Time Before: 1.31068 seconds
Time After: 1.31102 seconds
Time Taken: 0.00033 seconds

Memory Before: 8,746.938 KB
Memory After: 8,748.961 KB
Memory Used: 2.023 KB

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

Time Before: 1.31168 seconds
Time After: 1.31256 seconds
Time Taken: 0.00089 seconds

Memory Before: 8,749.672 KB
Memory After: 8,751.680 KB
Memory Used: 2.008 KB

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

Time Before: 1.39178 seconds
Time After: 1.39217 seconds
Time Taken: 0.00038 seconds

Memory Before: 8,844.617 KB
Memory After: 8,846.633 KB
Memory Used: 2.016 KB

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

Time Before: 1.39287 seconds
Time After: 1.39322 seconds
Time Taken: 0.00035 seconds

Memory Before: 8,845.023 KB
Memory After: 8,847.031 KB
Memory Used: 2.008 KB

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

Time Before: 1.39415 seconds
Time After: 1.39507 seconds
Time Taken: 0.00092 seconds

Memory Before: 8,847.727 KB
Memory After: 8,849.727 KB
Memory Used: 2.000 KB

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

Time Before: 1.40179 seconds
Time After: 1.40230 seconds
Time Taken: 0.00051 seconds

Memory Before: 8,951.500 KB
Memory After: 8,953.523 KB
Memory Used: 2.023 KB

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

Time Before: 1.40339 seconds
Time After: 1.40426 seconds
Time Taken: 0.00087 seconds

Memory Before: 8,951.891 KB
Memory After: 8,953.891 KB
Memory Used: 2.000 KB

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

Time Before: 1.40494 seconds
Time After: 1.40584 seconds
Time Taken: 0.00090 seconds

Memory Before: 8,953.570 KB
Memory After: 8,955.570 KB
Memory Used: 2.000 KB

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

Time Before: 1.48597 seconds
Time After: 1.48654 seconds
Time Taken: 0.00058 seconds

Memory Before: 9,009.500 KB
Memory After: 9,011.500 KB
Memory Used: 2.000 KB

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

Time Before: 1.48778 seconds
Time After: 1.48872 seconds
Time Taken: 0.00094 seconds

Memory Before: 9,009.891 KB
Memory After: 9,011.891 KB
Memory Used: 2.000 KB

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

Time Before: 1.48975 seconds
Time After: 1.49070 seconds
Time Taken: 0.00095 seconds

Memory Before: 9,011.953 KB
Memory After: 9,013.969 KB
Memory Used: 2.016 KB

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

Time Before: 1.49899 seconds
Time After: 1.49953 seconds
Time Taken: 0.00055 seconds

Memory Before: 9,078.867 KB
Memory After: 9,080.859 KB
Memory Used: 1.992 KB

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

Time Before: 1.50044 seconds
Time After: 1.50122 seconds
Time Taken: 0.00078 seconds

Memory Before: 9,079.250 KB
Memory After: 9,081.242 KB
Memory Used: 1.992 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: 1.50189 seconds
Time After: 1.50311 seconds
Time Taken: 0.00122 seconds

Memory Before: 9,081.445 KB
Memory After: 9,083.430 KB
Memory Used: 1.984 KB

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

Time Before: 1.50901 seconds
Time After: 1.50955 seconds
Time Taken: 0.00054 seconds

Memory Before: 9,182.383 KB
Memory After: 9,184.383 KB
Memory Used: 2.000 KB

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

Time Before: 1.58389 seconds
Time After: 1.58443 seconds
Time Taken: 0.00054 seconds

Memory Before: 9,182.781 KB
Memory After: 9,184.797 KB
Memory Used: 2.016 KB

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

Time Before: 1.58551 seconds
Time After: 1.58621 seconds
Time Taken: 0.00070 seconds

Memory Before: 9,184.375 KB
Memory After: 9,186.359 KB
Memory Used: 1.984 KB

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

Time Before: 1.59575 seconds
Time After: 1.59607 seconds
Time Taken: 0.00032 seconds

Memory Before: 9,236.953 KB
Memory After: 9,238.953 KB
Memory Used: 2.000 KB

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

Time Before: 1.59681 seconds
Time After: 1.59720 seconds
Time Taken: 0.00039 seconds

Memory Before: 9,237.367 KB
Memory After: 9,239.375 KB
Memory Used: 2.008 KB

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

Time Before: 1.59811 seconds
Time After: 1.59883 seconds
Time Taken: 0.00072 seconds

Memory Before: 9,239.852 KB
Memory After: 9,241.836 KB
Memory Used: 1.984 KB

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

Time Before: 1.60391 seconds
Time After: 1.60426 seconds
Time Taken: 0.00035 seconds

Memory Before: 9,339.828 KB
Memory After: 9,341.828 KB
Memory Used: 2.000 KB

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

Time Before: 1.60482 seconds
Time After: 1.60512 seconds
Time Taken: 0.00031 seconds

Memory Before: 9,340.281 KB
Memory After: 9,342.289 KB
Memory Used: 2.008 KB

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

Time Before: 1.60559 seconds
Time After: 1.60625 seconds
Time Taken: 0.00066 seconds

Memory Before: 9,342.930 KB
Memory After: 9,344.914 KB
Memory Used: 1.984 KB

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

Time Before: 1.69323 seconds
Time After: 1.69379 seconds
Time Taken: 0.00055 seconds

Memory Before: 9,444.461 KB
Memory After: 9,446.461 KB
Memory Used: 2.000 KB

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

Time Before: 1.69437 seconds
Time After: 1.69487 seconds
Time Taken: 0.00050 seconds

Memory Before: 9,444.859 KB
Memory After: 9,446.859 KB
Memory Used: 2.000 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.69566 seconds
Time After: 1.69665 seconds
Time Taken: 0.00099 seconds

Memory Before: 9,446.539 KB
Memory After: 9,448.539 KB
Memory Used: 2.000 KB

Time after parsing all posts: 1.6992950439453 Memory After: 9,643KB
SQL Query
SELECT template
FROM template
WHERE templateid = 4659
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplateconstPRIMARYPRIMARY4const1 

Time Before: 1.70166 seconds
Time After: 1.70207 seconds
Time Taken: 0.00041 seconds

Memory Before: 9,697.695 KB
Memory After: 9,699.711 KB
Memory Used: 2.016 KB

SQL Query
UPDATE session
SET lastactivity = 1759581822, location = '/vb/showthread.php?explain=1&page=2&t=6896', inforum = 50, inthread = 6896, 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: 1.70824 seconds
Time After: 1.70882 seconds
Time Taken: 0.00058 seconds

Memory Before: 11,519.508 KB
Memory After: 11,519.617 KB
Memory Used: 0.109 KB

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

Time Before: 1.70885 seconds
Time After: 1.70914 seconds
Time Taken: 0.00029 seconds

Memory Before: 11,512.867 KB
Memory After: 11,513.164 KB
Memory Used: 0.297 KB

Page generated in 1.7044239044189 seconds with 109 queries, spending 0.075621604919434 doing MySQL queries and 1.6288022994995 doing PHP things.
Shutdown Queries:
DISABLED