Time Before: 0.00060 seconds
Time After: 0.00068 seconds
Time Taken: 0.00009 seconds

Memory Before: 427.414 KB
Memory After: 494.367 KB
Memory Used: 66.953 KB

Time Before: 0.00075 seconds
Time After: 0.00134 seconds
Time Taken: 0.00059 seconds

Memory Before: 494.320 KB
Memory After: 495.211 KB
Memory Used: 0.891 KB

SET @@sql_mode = ''

Time Before: 0.00159 seconds
Time After: 0.00179 seconds
Time Taken: 0.00020 seconds

Memory Before: 495.234 KB
Memory After: 495.289 KB
Memory Used: 0.055 KB

SELECT *
FROM datastore
WHERE title IN ('navdata','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream','routes')

Time Before: 0.00183 seconds
Time After: 0.02232 seconds
Time Taken: 0.02049 seconds

Memory Before: 495.055 KB
Memory After: 940.141 KB
Memory Used: 445.086 KB

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

Time Before: 0.02322 seconds
Time After: 0.02344 seconds
Time Taken: 0.00022 seconds

Memory Before: 1,097.563 KB
Memory After: 1,113.820 KB
Memory Used: 16.258 KB

SELECT *
FROM session
WHERE userid = 0
	AND host = '216.73.216.48'
	AND idhash = 'ea5a359a73a8141a16de516480d33c34'
LIMIT 1

SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroupinfo AS lang_phrasegroupinfo,
			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.02354 seconds
Time After: 0.02586 seconds
Time Taken: 0.00233 seconds

Memory Before: 1,099.914 KB
Memory After: 1,152.203 KB
Memory Used: 52.289 KB

SELECT MAX(permissions & 1) AS perm
FROM cms_permissions
WHERE nodeid = 1 AND usergroupid IN (1)

Time Before: 0.03215 seconds
Time After: 0.03230 seconds
Time Taken: 0.00015 seconds

Memory Before: 1,271.305 KB
Memory After: 1,287.414 KB
Memory Used: 16.109 KB

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

Time Before: 0.03284 seconds
Time After: 0.03317 seconds
Time Taken: 0.00033 seconds

Memory Before: 1,276.305 KB
Memory After: 1,412.930 KB
Memory Used: 136.625 KB

SELECT profilefieldid
FROM profilefield
WHERE profilefieldid = 2

Time Before: 0.04005 seconds
Time After: 0.04016 seconds
Time Taken: 0.00011 seconds

Memory Before: 1,810.766 KB
Memory After: 1,827.063 KB
Memory Used: 16.297 KB

SELECT user.*,
	usergroup.title,
	user.options, usertextfield.buddylist,
	userfield.field2,
	IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid
	,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,
	customavatar.width AS avwidth,customavatar.height AS avheight, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb, 
	filedata_thumb, NOT ISNULL(customavatar.userid) AS hascustom

FROM user AS user
LEFT JOIN usergroup AS usergroup ON(usergroup.usergroupid = user.usergroupid OR FIND_IN_SET(usergroup.usergroupid, user.membergroupids))
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) 
	LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)

WHERE (usergroup.genericoptions & 1)

Time Before: 0.04082 seconds
Time After: 0.04167 seconds
Time Taken: 0.00085 seconds

Memory Before: 1,824.773 KB
Memory After: 1,880.594 KB
Memory Used: 55.820 KB

SELECT title, template
FROM template
WHERE templateid IN (32543,32546,32547,32496,32694,32726,32727,32747,0,0,7160,7154,18829,7158,7159,7157,7156,7161,7162,7163,32462,32736,32408,32412,32409,32410,32411,32766,0,0,32746,32707,32432,32433,32435,32436,32659,32778,32760,32710,32711,32259,32258,32262,5067,5038,6105,6107,31822)

Time Before: 0.04473 seconds
Time After: 0.04529 seconds
Time Taken: 0.00056 seconds

Memory Before: 2,223.500 KB
Memory After: 2,318.867 KB
Memory Used: 95.367 KB

SELECT user.*,
	moderator.forumid,
	usertextfield.buddylist,
	userfield.field2,
	IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid
	,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb, filedata_thumb, NOT ISNULL(customavatar.userid) AS hascustom

FROM moderator AS moderator
INNER JOIN user AS user USING(userid)
INNER JOIN userfield AS userfield ON(userfield.userid = user.userid)
INNER JOIN usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)

WHERE moderator.forumid <> -1

Time Before: 0.05079 seconds
Time After: 0.05122 seconds
Time Taken: 0.00044 seconds

Memory Before: 2,335.625 KB
Memory After: 2,350.852 KB
Memory Used: 15.227 KB

UPDATE session
SET lastactivity = 1764992889, location = '/showgroups.php?explain=1', inforum = 0, inthread = 0, badlocation = 0
WHERE sessionhash = '0fcbc3c6fdaea91b34f40f93920f0cf9'

Time Before: 0.05227 seconds
Time After: 0.05241 seconds
Time Taken: 0.00014 seconds

Memory Before: 2,462.672 KB
Memory After: 2,462.516 KB
Memory Used: -0.156 KB