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
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
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
SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','smiliecache','bbcodecache','mailqueue','bookmarksitecache')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | datastore | range | PRIMARY | PRIMARY | 52 | 18 | Using 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
SELECT * FROM datastore WHERE title IN ('ehdaa_userban','ehdaa')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | datastore | range | PRIMARY | PRIMARY | 52 | 2 | Using 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
SELECT * FROM session WHERE userid = 0 AND host = '216.73.216.51' AND idhash = 'ea5a359a73a8141a16de516480d33c34' LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | session | ALL | 184 | Using 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
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
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | language | const | PRIMARY | PRIMARY | 2 | const | 1 |
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
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
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
1 | SIMPLE | editlog | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique 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
SELECT IF(visible = 2, 1, 0) AS isdeleted, thread.* FROM thread AS thread WHERE thread.threadid = 9449
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 |
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
SELECT * FROM style WHERE (styleid = 72 AND userselect = 1) OR styleid = 72 ORDER BY styleid ASC LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | style | const | PRIMARY | PRIMARY | 2 | const | 1 |
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
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)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | 124 | Using 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
SELECT userip FROM cybvilxh_guests AS cybvilxh_guests WHERE userip = '216.73.216.51'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | cybvilxh_guests | ALL | 1091 | Using 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
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
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
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
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | thread | range | forumid,lastpost | lastpost | 4 | 4055 | Using 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
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
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | thread | range | forumid,lastpost | lastpost | 4 | 7353 | Using 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
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
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | threadid,threadid_2 | threadid | 4 | const | 41 | Using where; Using filesort |
1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | abotglb_vb368.post.userid | 1 | |
1 | SIMPLE | userfield | eq_ref | PRIMARY | PRIMARY | 4 | abotglb_vb368.user.userid | 1 | Using 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
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)
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | postparsed | system | PRIMARY | 0 | Const row not found | |||
1 | SIMPLE | post | range | PRIMARY | PRIMARY | 4 | 40 | Using index condition | |
1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | abotglb_vb368.post.userid | 1 | |
1 | SIMPLE | userfield | eq_ref | PRIMARY | PRIMARY | 4 | abotglb_vb368.user.userid | 1 | Using where |
1 | SIMPLE | usertextfield | eq_ref | PRIMARY | PRIMARY | 4 | abotglb_vb368.user.userid | 1 | Using where |
1 | SIMPLE | icon | eq_ref | PRIMARY | PRIMARY | 2 | abotglb_vb368.post.iconid | 1 | |
1 | SIMPLE | avatar | eq_ref | PRIMARY | PRIMARY | 2 | abotglb_vb368.user.avatarid | 1 | Using where |
1 | SIMPLE | customavatar | eq_ref | PRIMARY | PRIMARY | 4 | abotglb_vb368.user.userid | 1 | Using where |
1 | SIMPLE | sigparsed | eq_ref | PRIMARY | PRIMARY | 8 | abotglb_vb368.user.userid,const,const | 1 | Using where |
1 | SIMPLE | sigpic | eq_ref | PRIMARY | PRIMARY | 4 | abotglb_vb368.post.userid | 1 | |
1 | SIMPLE | editlog | eq_ref | PRIMARY | PRIMARY | 4 | abotglb_vb368.post.postid | 1 |
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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 377 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 13 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 377 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 394 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 394 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 394 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 13 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 377 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 394 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 377 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 394 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 377 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 515 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 509 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 394 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 7 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 394 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 7 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 515 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 394 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 377 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 394 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 515 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 377 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 7 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 394 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 515 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 7 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 394 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 3 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 394 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 7 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 394 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 7 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 515 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 394 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 377 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 565 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 573 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT userid from post where threadid='9449' AND userid=0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | post | ref | userid,threadid,threadid_2 | threadid | 8 | const,const | 1 | Using 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
SELECT gxcss_wsam FROM userwsam WHERE useridr = 7 ORDER BY RAND() LIMIT 0,4
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | userwsam | ALL | 2 | Using 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
SELECT template FROM template WHERE templateid = 4659
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | template | const | PRIMARY | PRIMARY | 4 | const | 1 |
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
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
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