Time Before: 0.00077 seconds
Time After: 0.00091 seconds
Time Taken: 0.00014 seconds

Memory Before: 420.516 KB
Memory After: 428.633 KB
Memory Used: 8.117 KB

Time Before: 0.00096 seconds
Time After: 0.00137 seconds
Time Taken: 0.00041 seconds

Memory Before: 428.570 KB
Memory After: 429.484 KB
Memory Used: 0.914 KB

SET @@sql_mode = ''

Time Before: 0.00156 seconds
Time After: 0.00169 seconds
Time Taken: 0.00013 seconds

Memory Before: 430.016 KB
Memory After: 430.539 KB
Memory Used: 0.523 KB

SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','smiliecache','bbcodecache','mailqueue','bookmarksitecache')

Time Before: 0.00172 seconds
Time After: 0.00868 seconds
Time Taken: 0.00696 seconds

Memory Before: 429.828 KB
Memory After: 2,037.938 KB
Memory Used: 1,608.109 KB

SELECT *
FROM datastore
WHERE title IN ('v3a_awards')

Time Before: 0.00944 seconds
Time After: 0.00983 seconds
Time Taken: 0.00038 seconds

Memory Before: 2,045.391 KB
Memory After: 2,045.961 KB
Memory Used: 0.570 KB

SELECT *
FROM session
WHERE sessionhash = 'dd5c214c49fe2b5040988954d09188b8'
	AND lastactivity > 1716077384
	AND idhash = '9c5dd4f250565b775436f12c96cf87ba'

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 = 1

Time Before: 0.01044 seconds
Time After: 0.01315 seconds
Time Taken: 0.00271 seconds

Memory Before: 2,192.883 KB
Memory After: 2,291.563 KB
Memory Used: 98.680 KB

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



thread.*


FROM thread AS thread






WHERE thread.threadid = 67399

Time Before: 0.01507 seconds
Time After: 0.01543 seconds
Time Taken: 0.00036 seconds

Memory Before: 2,309.211 KB
Memory After: 2,309.922 KB
Memory Used: 0.711 KB

SELECT *
FROM style
WHERE (styleid = 1 AND userselect = 1)
	OR styleid = 1
ORDER BY styleid ASC
LIMIT 1

Time Before: 0.01613 seconds
Time After: 0.01651 seconds
Time Taken: 0.00037 seconds

Memory Before: 2,324.008 KB
Memory After: 2,324.586 KB
Memory Used: 0.578 KB

SELECT title, template
FROM template
WHERE templateid IN (2740,2741,2743,2742,2825,3401,2857,2858,2860,2867,2866,2663,3040,3026,3027,3029,3028,3031,3033,3034,3035,3037,3039,2763,2765,2767,435,2670,3069,3072,3073,3070,3965,3141,3142,3019,3018,3020,3024,3022,3169,2803,2016,2804,2805,4003,2662,2073,2738,2737,2739,2734,2733,3010,1033,2962,2963,2964,3230,3233,3242,2983,2984,2985,2986,3184,3247,3246,3248,3251,2806,2809,2810,2013,2001,1997,1989,1991,1990,1992,1993,1994,1995,1996,1035,1034,3398,3400,3449,3787,3788,3790,3791,3792,3794,3795,3793,3803,3829,3821,3828)

Time Before: 0.01871 seconds
Time After: 0.02074 seconds
Time Taken: 0.00203 seconds

Memory Before: 2,531.039 KB
Memory After: 2,533.438 KB
Memory Used: 2.398 KB

SELECT
	post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
	user.*, userfield.*
	, '' AS field7
	
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 = 67399
	
ORDER BY postid

Time Before: 0.02966 seconds
Time After: 0.04159 seconds
Time Taken: 0.01193 seconds

Memory Before: 2,896.859 KB
Memory After: 3,094.797 KB
Memory Used: 197.938 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,
	
	deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
	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(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
	, '' AS field7
	
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 deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 1 AND postparsed.languageid = 1)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 1 AND sigparsed.languageid = 1)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
	
WHERE post.postid IN (2618492,2618357,2618545,2618553,2618562,2618567,2618571,2618605,2618628,2618612,2618653,2618654,2618661,2618659,2618699,2618711,2618714,2618844,2618956,2619085,2619099,2618750,2618755,2618781,2619019,2619118,2619145,2619191,2619124,2619133,2619141,2619193,2619227,2619204,2619205,2619207,2619209,2619228,2619208,2619212,2619232)

Time Before: 0.11163 seconds
Time After: 0.11588 seconds
Time Taken: 0.00424 seconds

Memory Before: 7,947.523 KB
Memory After: 7,989.500 KB
Memory Used: 41.977 KB

SELECT *
FROM bbcode

Time Before: 0.11986 seconds
Time After: 0.12008 seconds
Time Taken: 0.00022 seconds

Memory Before: 3,963.867 KB
Memory After: 3,966.063 KB
Memory Used: 2.195 KB

SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid
	
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 

WHERE user.userid = 217

Time Before: 0.12266 seconds
Time After: 0.12309 seconds
Time Taken: 0.00043 seconds

Memory Before: 4,267.711 KB
Memory After: 4,268.633 KB
Memory Used: 0.922 KB

SELECT *
FROM mysmiliesvb
WHERE userid='217'

Time Before: 0.15519 seconds
Time After: 0.15540 seconds
Time Taken: 0.00021 seconds

Memory Before: 4,370.047 KB
Memory After: 4,370.578 KB
Memory Used: 0.531 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 217

Time Before: 0.15646 seconds
Time After: 0.15669 seconds
Time Taken: 0.00022 seconds

Memory Before: 4,408.102 KB
Memory After: 4,408.625 KB
Memory Used: 0.523 KB

SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid
	
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 

WHERE user.userid = 89

Time Before: 0.15915 seconds
Time After: 0.15957 seconds
Time Taken: 0.00041 seconds

Memory Before: 4,430.789 KB
Memory After: 4,431.703 KB
Memory Used: 0.914 KB

SELECT *
FROM mysmiliesvb
WHERE userid='89'

Time Before: 0.16379 seconds
Time After: 0.16406 seconds
Time Taken: 0.00027 seconds

Memory Before: 4,445.617 KB
Memory After: 4,446.938 KB
Memory Used: 1.320 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 89

Time Before: 0.16511 seconds
Time After: 0.16532 seconds
Time Taken: 0.00022 seconds

Memory Before: 4,468.805 KB
Memory After: 4,469.375 KB
Memory Used: 0.570 KB

SELECT *
FROM mysmiliesvb
WHERE userid='89'

Time Before: 0.16834 seconds
Time After: 0.16863 seconds
Time Taken: 0.00029 seconds

Memory Before: 4,445.984 KB
Memory After: 4,447.305 KB
Memory Used: 1.320 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 89

Time Before: 0.16956 seconds
Time After: 0.16977 seconds
Time Taken: 0.00021 seconds

Memory Before: 4,467.516 KB
Memory After: 4,468.094 KB
Memory Used: 0.578 KB

SELECT *
FROM mysmiliesvb
WHERE userid='217'

Time Before: 0.17337 seconds
Time After: 0.17357 seconds
Time Taken: 0.00021 seconds

Memory Before: 4,435.875 KB
Memory After: 4,436.406 KB
Memory Used: 0.531 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 217

Time Before: 0.17428 seconds
Time After: 0.17447 seconds
Time Taken: 0.00019 seconds

Memory Before: 4,471.586 KB
Memory After: 4,472.109 KB
Memory Used: 0.523 KB

SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid
	
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 

WHERE user.userid = 1886

Time Before: 0.17689 seconds
Time After: 0.17730 seconds
Time Taken: 0.00041 seconds

Memory Before: 4,477.945 KB
Memory After: 4,478.867 KB
Memory Used: 0.922 KB

SELECT *
FROM mysmiliesvb
WHERE userid='1886'

Time Before: 0.17929 seconds
Time After: 0.17950 seconds
Time Taken: 0.00021 seconds

Memory Before: 4,509.680 KB
Memory After: 4,510.211 KB
Memory Used: 0.531 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 1886

Time Before: 0.18029 seconds
Time After: 0.18048 seconds
Time Taken: 0.00019 seconds

Memory Before: 4,520.625 KB
Memory After: 4,521.148 KB
Memory Used: 0.523 KB

SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid
	
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 

WHERE user.userid = 1425

Time Before: 0.18266 seconds
Time After: 0.18305 seconds
Time Taken: 0.00039 seconds

Memory Before: 4,508.961 KB
Memory After: 4,509.883 KB
Memory Used: 0.922 KB

SELECT *
FROM mysmiliesvb
WHERE userid='1425'

Time Before: 0.18471 seconds
Time After: 0.18496 seconds
Time Taken: 0.00026 seconds

Memory Before: 4,528.961 KB
Memory After: 4,529.492 KB
Memory Used: 0.531 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 1425

Time Before: 0.18583 seconds
Time After: 0.18609 seconds
Time Taken: 0.00026 seconds

Memory Before: 4,550.492 KB
Memory After: 4,551.016 KB
Memory Used: 0.523 KB

SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid
	
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 

WHERE user.userid = 286

Time Before: 0.18823 seconds
Time After: 0.18866 seconds
Time Taken: 0.00043 seconds

Memory Before: 4,545.336 KB
Memory After: 4,546.258 KB
Memory Used: 0.922 KB

SELECT *
FROM mysmiliesvb
WHERE userid='286'

Time Before: 0.19045 seconds
Time After: 0.19071 seconds
Time Taken: 0.00025 seconds

Memory Before: 4,565.203 KB
Memory After: 4,565.734 KB
Memory Used: 0.531 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 286

Time Before: 0.19143 seconds
Time After: 0.19181 seconds
Time Taken: 0.00038 seconds

Memory Before: 4,587.398 KB
Memory After: 4,587.969 KB
Memory Used: 0.570 KB

SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid
	
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 

WHERE user.userid = 1030

Time Before: 0.19401 seconds
Time After: 0.19441 seconds
Time Taken: 0.00040 seconds

Memory Before: 4,583.672 KB
Memory After: 4,584.594 KB
Memory Used: 0.922 KB

SELECT *
FROM mysmiliesvb
WHERE userid='1030'

Time Before: 0.19557 seconds
Time After: 0.19578 seconds
Time Taken: 0.00022 seconds

Memory Before: 4,603.445 KB
Memory After: 4,604.063 KB
Memory Used: 0.617 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 1030

Time Before: 0.19660 seconds
Time After: 0.19684 seconds
Time Taken: 0.00024 seconds

Memory Before: 4,625.445 KB
Memory After: 4,625.969 KB
Memory Used: 0.523 KB

SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid
	
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 

WHERE user.userid = 156

Time Before: 0.19903 seconds
Time After: 0.19947 seconds
Time Taken: 0.00044 seconds

Memory Before: 4,623.531 KB
Memory After: 4,624.453 KB
Memory Used: 0.922 KB

SELECT *
FROM mysmiliesvb
WHERE userid='156'

Time Before: 0.20127 seconds
Time After: 0.20145 seconds
Time Taken: 0.00019 seconds

Memory Before: 4,644.633 KB
Memory After: 4,645.164 KB
Memory Used: 0.531 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 156

Time Before: 0.20223 seconds
Time After: 0.20242 seconds
Time Taken: 0.00019 seconds

Memory Before: 4,666.273 KB
Memory After: 4,666.797 KB
Memory Used: 0.523 KB

SELECT *
FROM mysmiliesvb
WHERE userid='1030'

Time Before: 0.20496 seconds
Time After: 0.20522 seconds
Time Taken: 0.00026 seconds

Memory Before: 4,652.297 KB
Memory After: 4,652.914 KB
Memory Used: 0.617 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 1030

Time Before: 0.20639 seconds
Time After: 0.20667 seconds
Time Taken: 0.00028 seconds

Memory Before: 4,674.547 KB
Memory After: 4,675.070 KB
Memory Used: 0.523 KB

SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid
	
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 

WHERE user.userid = 19

Time Before: 0.20906 seconds
Time After: 0.20949 seconds
Time Taken: 0.00042 seconds

Memory Before: 4,670.320 KB
Memory After: 4,671.234 KB
Memory Used: 0.914 KB

SELECT *
FROM mysmiliesvb
WHERE userid='19'

Time Before: 0.21064 seconds
Time After: 0.21095 seconds
Time Taken: 0.00030 seconds

Memory Before: 4,690.391 KB
Memory After: 4,692.180 KB
Memory Used: 1.789 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 19

Time Before: 0.21213 seconds
Time After: 0.21236 seconds
Time Taken: 0.00023 seconds

Memory Before: 4,712.250 KB
Memory After: 4,712.773 KB
Memory Used: 0.523 KB

SELECT *
FROM mysmiliesvb
WHERE userid='156'

Time Before: 0.21537 seconds
Time After: 0.21567 seconds
Time Taken: 0.00029 seconds

Memory Before: 4,695.352 KB
Memory After: 4,695.883 KB
Memory Used: 0.531 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 156

Time Before: 0.21646 seconds
Time After: 0.21672 seconds
Time Taken: 0.00026 seconds

Memory Before: 4,716.609 KB
Memory After: 4,717.133 KB
Memory Used: 0.523 KB

SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid
	
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 

WHERE user.userid = 5068

Time Before: 0.21868 seconds
Time After: 0.21909 seconds
Time Taken: 0.00041 seconds

Memory Before: 4,716.734 KB
Memory After: 4,717.656 KB
Memory Used: 0.922 KB

SELECT *
FROM mysmiliesvb
WHERE userid='5068'

Time Before: 0.22290 seconds
Time After: 0.22312 seconds
Time Taken: 0.00023 seconds

Memory Before: 4,738.828 KB
Memory After: 4,739.359 KB
Memory Used: 0.531 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 5068

Time Before: 0.22394 seconds
Time After: 0.22416 seconds
Time Taken: 0.00022 seconds

Memory Before: 4,760.086 KB
Memory After: 4,760.625 KB
Memory Used: 0.539 KB

SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid
	
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 

WHERE user.userid = 5732

Time Before: 0.22610 seconds
Time After: 0.22651 seconds
Time Taken: 0.00041 seconds

Memory Before: 4,755.594 KB
Memory After: 4,756.516 KB
Memory Used: 0.922 KB

SELECT *
FROM mysmiliesvb
WHERE userid='5732'

Time Before: 0.22867 seconds
Time After: 0.22891 seconds
Time Taken: 0.00023 seconds

Memory Before: 4,774.906 KB
Memory After: 4,775.438 KB
Memory Used: 0.531 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 5732

Time Before: 0.22976 seconds
Time After: 0.22998 seconds
Time Taken: 0.00022 seconds

Memory Before: 4,797.102 KB
Memory After: 4,797.633 KB
Memory Used: 0.531 KB

SELECT *
FROM mysmiliesvb
WHERE userid='1030'

Time Before: 0.23527 seconds
Time After: 0.23568 seconds
Time Taken: 0.00041 seconds

Memory Before: 4,779.023 KB
Memory After: 4,779.641 KB
Memory Used: 0.617 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 1030

Time Before: 0.23697 seconds
Time After: 0.23727 seconds
Time Taken: 0.00030 seconds

Memory Before: 4,800.898 KB
Memory After: 4,801.422 KB
Memory Used: 0.523 KB

SELECT *
FROM mysmiliesvb
WHERE userid='5732'

Time Before: 0.24096 seconds
Time After: 0.24126 seconds
Time Taken: 0.00030 seconds

Memory Before: 4,788.039 KB
Memory After: 4,788.570 KB
Memory Used: 0.531 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 5732

Time Before: 0.24251 seconds
Time After: 0.24284 seconds
Time Taken: 0.00033 seconds

Memory Before: 4,810.234 KB
Memory After: 4,810.781 KB
Memory Used: 0.547 KB

SELECT *
FROM mysmiliesvb
WHERE userid='19'

Time Before: 0.24949 seconds
Time After: 0.24995 seconds
Time Taken: 0.00046 seconds

Memory Before: 4,790.781 KB
Memory After: 4,792.570 KB
Memory Used: 1.789 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 19

Time Before: 0.25182 seconds
Time After: 0.25206 seconds
Time Taken: 0.00024 seconds

Memory Before: 4,813.336 KB
Memory After: 4,813.859 KB
Memory Used: 0.523 KB

SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid
	
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 

WHERE user.userid = 3200

Time Before: 0.25431 seconds
Time After: 0.25475 seconds
Time Taken: 0.00044 seconds

Memory Before: 4,810.688 KB
Memory After: 4,811.609 KB
Memory Used: 0.922 KB

SELECT *
FROM mysmiliesvb
WHERE userid='3200'

Time Before: 0.26005 seconds
Time After: 0.26028 seconds
Time Taken: 0.00023 seconds

Memory Before: 4,832.422 KB
Memory After: 4,832.953 KB
Memory Used: 0.531 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 3200

Time Before: 0.26110 seconds
Time After: 0.26132 seconds
Time Taken: 0.00022 seconds

Memory Before: 4,854.063 KB
Memory After: 4,854.586 KB
Memory Used: 0.523 KB

SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid
	
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 

WHERE user.userid = 137

Time Before: 0.26361 seconds
Time After: 0.26401 seconds
Time Taken: 0.00040 seconds

Memory Before: 4,860.555 KB
Memory After: 4,861.477 KB
Memory Used: 0.922 KB

SELECT *
FROM mysmiliesvb
WHERE userid='137'

Time Before: 0.26585 seconds
Time After: 0.26609 seconds
Time Taken: 0.00024 seconds

Memory Before: 4,880.633 KB
Memory After: 4,881.164 KB
Memory Used: 0.531 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 137

Time Before: 0.26689 seconds
Time After: 0.26712 seconds
Time Taken: 0.00023 seconds

Memory Before: 4,902.273 KB
Memory After: 4,902.797 KB
Memory Used: 0.523 KB

SELECT *
FROM mysmiliesvb
WHERE userid='3200'

Time Before: 0.27206 seconds
Time After: 0.27230 seconds
Time Taken: 0.00024 seconds

Memory Before: 4,880.625 KB
Memory After: 4,881.156 KB
Memory Used: 0.531 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 3200

Time Before: 0.27311 seconds
Time After: 0.27333 seconds
Time Taken: 0.00022 seconds

Memory Before: 4,902.266 KB
Memory After: 4,902.789 KB
Memory Used: 0.523 KB

SELECT *
FROM mysmiliesvb
WHERE userid='137'

Time Before: 0.28081 seconds
Time After: 0.28104 seconds
Time Taken: 0.00023 seconds

Memory Before: 4,900.016 KB
Memory After: 4,900.547 KB
Memory Used: 0.531 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 137

Time Before: 0.28184 seconds
Time After: 0.28206 seconds
Time Taken: 0.00022 seconds

Memory Before: 4,920.828 KB
Memory After: 4,921.352 KB
Memory Used: 0.523 KB

SELECT *
FROM mysmiliesvb
WHERE userid='19'

Time Before: 0.28472 seconds
Time After: 0.28503 seconds
Time Taken: 0.00030 seconds

Memory Before: 4,901.359 KB
Memory After: 4,903.148 KB
Memory Used: 1.789 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 19

Time Before: 0.28610 seconds
Time After: 0.28633 seconds
Time Taken: 0.00023 seconds

Memory Before: 4,923.680 KB
Memory After: 4,924.203 KB
Memory Used: 0.523 KB

SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid
	
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 

WHERE user.userid = 271

Time Before: 0.28833 seconds
Time After: 0.28882 seconds
Time Taken: 0.00049 seconds

Memory Before: 4,915.125 KB
Memory After: 4,916.047 KB
Memory Used: 0.922 KB

SELECT *
FROM mysmiliesvb
WHERE userid='271'

Time Before: 0.29729 seconds
Time After: 0.29752 seconds
Time Taken: 0.00023 seconds

Memory Before: 4,939.078 KB
Memory After: 4,939.609 KB
Memory Used: 0.531 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 271

Time Before: 0.29835 seconds
Time After: 0.29859 seconds
Time Taken: 0.00024 seconds

Memory Before: 4,960.695 KB
Memory After: 4,961.219 KB
Memory Used: 0.523 KB

SELECT *
FROM mysmiliesvb
WHERE userid='271'

Time Before: 0.30765 seconds
Time After: 0.30788 seconds
Time Taken: 0.00023 seconds

Memory Before: 4,949.977 KB
Memory After: 4,950.523 KB
Memory Used: 0.547 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 271

Time Before: 0.30868 seconds
Time After: 0.30890 seconds
Time Taken: 0.00022 seconds

Memory Before: 4,972.172 KB
Memory After: 4,972.703 KB
Memory Used: 0.531 KB

SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid
	
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 

WHERE user.userid = 142

Time Before: 0.31123 seconds
Time After: 0.31168 seconds
Time Taken: 0.00045 seconds

Memory Before: 4,966.086 KB
Memory After: 4,967.008 KB
Memory Used: 0.922 KB

SELECT *
FROM mysmiliesvb
WHERE userid='142'

Time Before: 0.31283 seconds
Time After: 0.31307 seconds
Time Taken: 0.00023 seconds

Memory Before: 4,985.930 KB
Memory After: 4,986.469 KB
Memory Used: 0.539 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 142

Time Before: 0.31386 seconds
Time After: 0.31409 seconds
Time Taken: 0.00023 seconds

Memory Before: 5,008.125 KB
Memory After: 5,008.695 KB
Memory Used: 0.570 KB

SELECT *
FROM mysmiliesvb
WHERE userid='5732'

Time Before: 0.31736 seconds
Time After: 0.31762 seconds
Time Taken: 0.00026 seconds

Memory Before: 4,989.906 KB
Memory After: 4,990.445 KB
Memory Used: 0.539 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 5732

Time Before: 0.31838 seconds
Time After: 0.31863 seconds
Time Taken: 0.00025 seconds

Memory Before: 5,012.102 KB
Memory After: 5,012.625 KB
Memory Used: 0.523 KB

SELECT *
FROM mysmiliesvb
WHERE userid='1030'

Time Before: 0.32274 seconds
Time After: 0.32297 seconds
Time Taken: 0.00023 seconds

Memory Before: 4,994.664 KB
Memory After: 4,995.281 KB
Memory Used: 0.617 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 1030

Time Before: 0.32384 seconds
Time After: 0.32402 seconds
Time Taken: 0.00018 seconds

Memory Before: 5,016.867 KB
Memory After: 5,017.391 KB
Memory Used: 0.523 KB

SELECT *
FROM mysmiliesvb
WHERE userid='156'

Time Before: 0.32854 seconds
Time After: 0.32875 seconds
Time Taken: 0.00021 seconds

Memory Before: 5,006.133 KB
Memory After: 5,006.664 KB
Memory Used: 0.531 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 156

Time Before: 0.32947 seconds
Time After: 0.32968 seconds
Time Taken: 0.00021 seconds

Memory Before: 5,027.773 KB
Memory After: 5,028.297 KB
Memory Used: 0.523 KB

SELECT *
FROM mysmiliesvb
WHERE userid='142'

Time Before: 0.33390 seconds
Time After: 0.33407 seconds
Time Taken: 0.00017 seconds

Memory Before: 5,013.195 KB
Memory After: 5,013.727 KB
Memory Used: 0.531 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 142

Time Before: 0.33479 seconds
Time After: 0.33497 seconds
Time Taken: 0.00018 seconds

Memory Before: 5,035.008 KB
Memory After: 5,035.578 KB
Memory Used: 0.570 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 19

Time Before: 0.33713 seconds
Time After: 0.33729 seconds
Time Taken: 0.00016 seconds

Memory Before: 5,111.969 KB
Memory After: 5,112.492 KB
Memory Used: 0.523 KB

SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid
	
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 

WHERE user.userid = 2555

Time Before: 0.33932 seconds
Time After: 0.33973 seconds
Time Taken: 0.00041 seconds

Memory Before: 5,099.523 KB
Memory After: 5,100.445 KB
Memory Used: 0.922 KB

SELECT *
FROM mysmiliesvb
WHERE userid='2555'

Time Before: 0.34084 seconds
Time After: 0.34103 seconds
Time Taken: 0.00019 seconds

Memory Before: 5,119.367 KB
Memory After: 5,119.898 KB
Memory Used: 0.531 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 2555

Time Before: 0.34178 seconds
Time After: 0.34195 seconds
Time Taken: 0.00017 seconds

Memory Before: 5,141.461 KB
Memory After: 5,141.992 KB
Memory Used: 0.531 KB

SELECT *
FROM mysmiliesvb
WHERE userid='271'

Time Before: 0.36995 seconds
Time After: 0.37014 seconds
Time Taken: 0.00019 seconds

Memory Before: 5,144.492 KB
Memory After: 5,145.031 KB
Memory Used: 0.539 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 271

Time Before: 0.37095 seconds
Time After: 0.37113 seconds
Time Taken: 0.00018 seconds

Memory Before: 5,165.258 KB
Memory After: 5,165.781 KB
Memory Used: 0.523 KB

SELECT *
FROM mysmiliesvb
WHERE userid='1030'

Time Before: 0.40131 seconds
Time After: 0.40151 seconds
Time Taken: 0.00020 seconds

Memory Before: 5,175.375 KB
Memory After: 5,176.008 KB
Memory Used: 0.633 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 1030

Time Before: 0.40237 seconds
Time After: 0.40255 seconds
Time Taken: 0.00018 seconds

Memory Before: 5,202.078 KB
Memory After: 5,202.602 KB
Memory Used: 0.523 KB

SELECT *
FROM mysmiliesvb
WHERE userid='156'

Time Before: 0.40571 seconds
Time After: 0.40588 seconds
Time Taken: 0.00017 seconds

Memory Before: 5,176.430 KB
Memory After: 5,176.977 KB
Memory Used: 0.547 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 156

Time Before: 0.40663 seconds
Time After: 0.40681 seconds
Time Taken: 0.00017 seconds

Memory Before: 5,198.219 KB
Memory After: 5,198.742 KB
Memory Used: 0.523 KB

SELECT *
FROM mysmiliesvb
WHERE userid='271'

Time Before: 0.40964 seconds
Time After: 0.40981 seconds
Time Taken: 0.00018 seconds

Memory Before: 5,168.930 KB
Memory After: 5,169.477 KB
Memory Used: 0.547 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 271

Time Before: 0.41059 seconds
Time After: 0.41076 seconds
Time Taken: 0.00018 seconds

Memory Before: 5,190.758 KB
Memory After: 5,191.281 KB
Memory Used: 0.523 KB

SELECT *
FROM mysmiliesvb
WHERE userid='1886'

Time Before: 0.41670 seconds
Time After: 0.41693 seconds
Time Taken: 0.00023 seconds

Memory Before: 5,184.750 KB
Memory After: 5,185.289 KB
Memory Used: 0.539 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 1886

Time Before: 0.41778 seconds
Time After: 0.41802 seconds
Time Taken: 0.00024 seconds

Memory Before: 5,195.266 KB
Memory After: 5,195.789 KB
Memory Used: 0.523 KB

SELECT *
FROM mysmiliesvb
WHERE userid='3200'

Time Before: 0.42391 seconds
Time After: 0.42415 seconds
Time Taken: 0.00023 seconds

Memory Before: 5,184.375 KB
Memory After: 5,184.906 KB
Memory Used: 0.531 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 3200

Time Before: 0.42500 seconds
Time After: 0.42522 seconds
Time Taken: 0.00022 seconds

Memory Before: 5,205.141 KB
Memory After: 5,205.664 KB
Memory Used: 0.523 KB

SELECT *
FROM mysmiliesvb
WHERE userid='1030'

Time Before: 0.43247 seconds
Time After: 0.43277 seconds
Time Taken: 0.00030 seconds

Memory Before: 5,200.781 KB
Memory After: 5,201.398 KB
Memory Used: 0.617 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 1030

Time Before: 0.43362 seconds
Time After: 0.43384 seconds
Time Taken: 0.00022 seconds

Memory Before: 5,223.367 KB
Memory After: 5,223.898 KB
Memory Used: 0.531 KB

SELECT *
FROM mysmiliesvb
WHERE userid='271'

Time Before: 0.43607 seconds
Time After: 0.43629 seconds
Time Taken: 0.00022 seconds

Memory Before: 5,203.930 KB
Memory After: 5,204.461 KB
Memory Used: 0.531 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 271

Time Before: 0.43711 seconds
Time After: 0.43733 seconds
Time Taken: 0.00022 seconds

Memory Before: 5,225.867 KB
Memory After: 5,226.406 KB
Memory Used: 0.539 KB

SELECT *
FROM mysmiliesvb
WHERE userid='271'

Time Before: 0.44238 seconds
Time After: 0.44266 seconds
Time Taken: 0.00028 seconds

Memory Before: 5,203.742 KB
Memory After: 5,204.273 KB
Memory Used: 0.531 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 271

Time Before: 0.44348 seconds
Time After: 0.44374 seconds
Time Taken: 0.00026 seconds

Memory Before: 5,224.742 KB
Memory After: 5,225.266 KB
Memory Used: 0.523 KB

SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid
	
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 

WHERE user.userid = 95

Time Before: 0.44606 seconds
Time After: 0.44649 seconds
Time Taken: 0.00043 seconds

Memory Before: 5,222.367 KB
Memory After: 5,223.281 KB
Memory Used: 0.914 KB

SELECT *
FROM mysmiliesvb
WHERE userid='95'

Time Before: 0.44948 seconds
Time After: 0.44973 seconds
Time Taken: 0.00025 seconds

Memory Before: 5,245.328 KB
Memory After: 5,245.859 KB
Memory Used: 0.531 KB

SELECT userid,lat_map,username,lng_map FROM googlemapme WHERE userid = 95

Time Before: 0.45057 seconds
Time After: 0.45080 seconds
Time Taken: 0.00023 seconds

Memory Before: 5,266.117 KB
Memory After: 5,266.648 KB
Memory Used: 0.531 KB

UPDATE session
SET location = '/archive/showthread.php?t=67399&page=2&explain=1', inforum = 75, inthread = 67399, incalendar = 0, badlocation = 0, useragent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
WHERE sessionhash = 'dd5c214c49fe2b5040988954d09188b8'

Time Before: 0.45991 seconds
Time After: 0.46012 seconds
Time Taken: 0.00021 seconds

Memory Before: 7,335.094 KB
Memory After: 7,335.156 KB
Memory Used: 0.063 KB

UPDATE thread
SET views = views + 1
WHERE threadid = 67399

Time Before: 0.46018 seconds
Time After: 0.46044 seconds
Time Taken: 0.00026 seconds

Memory Before: 7,329.023 KB
Memory After: 7,329.367 KB
Memory Used: 0.344 KB