Time Before: 0.00013 seconds
Time After: 0.00015 seconds
Time Taken: 0.00002 seconds

Memory Before: 455.805 KB
Memory After: 522.758 KB
Memory Used: 66.953 KB

Time Before: 0.00017 seconds
Time After: 0.00048 seconds
Time Taken: 0.00031 seconds

Memory Before: 522.711 KB
Memory After: 523.602 KB
Memory Used: 0.891 KB

SET @@sql_mode = ''

Time Before: 0.00060 seconds
Time After: 0.00070 seconds
Time Taken: 0.00010 seconds

Memory Before: 523.625 KB
Memory After: 523.680 KB
Memory Used: 0.055 KB

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

Time Before: 0.00073 seconds
Time After: 0.00406 seconds
Time Taken: 0.00333 seconds

Memory Before: 523.445 KB
Memory After: 980.516 KB
Memory Used: 457.070 KB

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

Time Before: 0.00439 seconds
Time After: 0.00447 seconds
Time Taken: 0.00008 seconds

Memory Before: 1,137.688 KB
Memory After: 1,153.945 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,
			phrasegroup_posting AS phrasegroup_posting,
			phrasegroup_vbblogglobal AS phrasegroup_vbblogglobal,
			phrasegroup_postbit AS phrasegroup_postbit,
			phrasegroup_vbblogcat AS phrasegroup_vbblogcat,
			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.00454 seconds
Time After: 0.00588 seconds
Time Taken: 0.00134 seconds

Memory Before: 1,164.883 KB
Memory After: 1,266.031 KB
Memory Used: 101.148 KB

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

Time Before: 0.00924 seconds
Time After: 0.00938 seconds
Time Taken: 0.00014 seconds

Memory Before: 1,476.578 KB
Memory After: 1,492.688 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.00978 seconds
Time After: 0.00999 seconds
Time Taken: 0.00021 seconds

Memory Before: 1,543.273 KB
Memory After: 1,679.898 KB
Memory Used: 136.625 KB

SELECT vbcmspermissions FROM administrator WHERE userid = 0

Time Before: 0.01227 seconds
Time After: 0.01236 seconds
Time Taken: 0.00010 seconds

Memory Before: 2,025.141 KB
Memory After: 2,041.492 KB
Memory Used: 16.352 KB

SELECT nodeid,
			MAX(permissions & 1) AS canview, MAX(permissions & 2) AS cancreate , MAX(permissions & 4) AS canedit,
			MAX(permissions & 8) AS canpublish, MAX(permissions & 16) AS canusehtml, MAX(permissions & 32) AS candownload
			FROM cms_permissions p
			WHERE usergroupid IN (1)
			GROUP BY nodeid;

Time Before: 0.01258 seconds
Time After: 0.01276 seconds
Time Taken: 0.00018 seconds

Memory Before: 2,025.672 KB
Memory After: 2,042.156 KB
Memory Used: 16.484 KB

SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
	, ptuser.userid AS pt_userid, ptuser.totalissues AS pt_totalissues, bu.bloguserid, bu.entries, bu.options AS blog_options, bu.subscribeown AS blog_subscribeown, bu.memberids, bu.memberblogids,
bu.subscribeothers AS blog_subscribeothers, bu.title AS blog_title, bu.description AS blog_description, bu.allowsmilie AS blog_allowsmilie, bu.draft AS blog_draft, bu.pending AS blog_pending, bu.options_member, bu.options_guest, bu.options_buddy, bu.options_ignore, bu.uncatentries, bu.moderation AS blog_moderation, bu.deleted AS blog_deleted, bu.akismet_key AS blog_akismet_key, isblogmoderator, bu.comments_moderation AS blog_comments_moderation, bu.lastblog, bu.lastblogid, bu.lastblogtitle, bu.categorycache, bu.tagcloud, bu.sidebar, bu.custompages, bu.customblocks, blockparsed.blocktext, 1 AS blogstyleid, blog_usercsscache.csscolors AS blog_csscolors, blog_usercsscache.cachedcss AS blog_cachedcss, IF(blog_usercsscache.cachedcss IS NULL, 0, 1) AS blog_hascachedcss, blog_usercsscache.buildpermissions AS blog_cssbuildpermissions, IF(blog_subscribeuser.blogsubscribeuserid, 1, 0) AS blogsubscribed, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 
LEFT JOIN pt_user AS ptuser ON (user.userid = ptuser.userid)
LEFT JOIN blog_user AS bu ON (bu.bloguserid = user.userid)
LEFT JOIN blog_custom_block_parsed AS blockparsed ON (blockparsed.userid = user.userid AND blockparsed.styleid = 1 AND blockparsed.languageid = 1)
LEFT JOIN blog_subscribeuser AS blog_subscribeuser ON (user.userid = blog_subscribeuser.bloguserid AND blog_subscribeuser.userid = 2)
LEFT JOIN blog_usercsscache AS blog_usercsscache ON (user.userid = blog_usercsscache.userid)
LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid)
WHERE user.userid = 2 LIMIT 1

Time Before: 0.01325 seconds
Time After: 0.01358 seconds
Time Taken: 0.00032 seconds

Memory Before: 2,041.766 KB
Memory After: 2,060.516 KB
Memory Used: 18.750 KB

SELECT text, languageid, special
FROM phrase AS phrase
LEFT JOIN phrasetype USING (fieldname)
WHERE phrase.fieldname = 'frontredirect'
	AND varname = 'blog_markread' AND languageid IN (-1, 0, 1)

Time Before: 0.01416 seconds
Time After: 0.01437 seconds
Time Taken: 0.00020 seconds

Memory Before: 2,058.188 KB
Memory After: 2,074.234 KB
Memory Used: 16.047 KB