Including Functions.php

Time Before: 0.00558 seconds
Time After: 0.01438 seconds
Time Taken: 0.00880 seconds

Memory Before: 1,578.719 KB
Memory After: 2,773.594 KB
Memory Used: 1,194.875 KB

Connect to Database on Server: localhost

Time Before: 0.01447 seconds
Time After: 0.01511 seconds
Time Taken: 0.00064 seconds

Memory Before: 2,773.578 KB
Memory After: 2,774.523 KB
Memory Used: 0.945 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.01526 seconds
Time After: 0.01533 seconds
Time Taken: 0.00008 seconds

Memory Before: 2,775.211 KB
Memory After: 2,775.766 KB
Memory Used: 0.555 KB

Datastore Setup
SQL Query
SELECT *
FROM datastore
WHERE title IN ('smiliecache','bbcodecache','blogcategorycache','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY52 17Using where

Time Before: 0.01572 seconds
Time After: 0.01817 seconds
Time Taken: 0.00245 seconds

Memory Before: 2,778.977 KB
Memory After: 2,779.250 KB
Memory Used: 0.273 KB

Time Before: 0.01537 seconds
Time After: 0.02140 seconds
Time Taken: 0.00603 seconds

Memory Before: 2,775.016 KB
Memory After: 4,648.563 KB
Memory Used: 1,873.547 KB

SQL Query
SELECT *
FROM datastore
WHERE title IN ('dbtech_vbshout_button','dbtech_vbshout_chatroom','dbtech_vbshout_instance','dbtech_livewall_contenttype')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY52 4Using where

Time Before: 0.02439 seconds
Time After: 0.02456 seconds
Time Taken: 0.00017 seconds

Memory Before: 5,285.578 KB
Memory After: 5,286.000 KB
Memory Used: 0.422 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '54.196.213.0'
	AND idhash = 'a620bef3bac9ecb97ed637c44b87f2c4'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionrefguest_lookup,user_activityguest_lookup51const,const,const2Using where

Time Before: 0.02505 seconds
Time After: 0.02519 seconds
Time Taken: 0.00014 seconds

Memory Before: 5,340.148 KB
Memory After: 5,340.570 KB
Memory Used: 0.422 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_activitystream AS phrasegroup_activitystream,
			phrasegroup_user AS phrasegroup_user,
			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
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLElanguageconstPRIMARYPRIMARY2const1 

Time Before: 0.02579 seconds
Time After: 0.02618 seconds
Time Taken: 0.00039 seconds

Memory Before: 5,352.016 KB
Memory After: 5,351.836 KB
Memory Used: -0.180 KB

Time Before: 0.02474 seconds
Time After: 0.02638 seconds
Time Taken: 0.00164 seconds

Memory Before: 5,333.289 KB
Memory After: 5,480.359 KB
Memory Used: 147.070 KB

SQL Query
SELECT *
FROM datastore
WHERE title IN ('routes')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastoreconstPRIMARYPRIMARY52const1 

Time Before: 0.02677 seconds
Time After: 0.02687 seconds
Time Taken: 0.00010 seconds

Memory Before: 5,488.852 KB
Memory After: 5,489.336 KB
Memory Used: 0.484 KB

SQL Query
SELECT *
FROM style
WHERE (styleid = 12 AND userselect = 1)
	OR styleid = 12
ORDER BY styleid ASC
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstyleconstPRIMARYPRIMARY2const1 

Time Before: 0.05509 seconds
Time After: 0.05534 seconds
Time Taken: 0.00025 seconds

Memory Before: 7,574.523 KB
Memory After: 7,574.953 KB
Memory Used: 0.430 KB

End call of global.php: 0.057210206985474
SQL Query
SELECT stream.*, type.section, type.type
FROM activitystream AS stream
LEFT JOIN activitystreamtype AS type ON (stream.typeid = type.typeid)
WHERE stream.dateline <> 0 AND stream.dateline <= 1519403914
ORDER BY dateline DESC
LIMIT 0, 30
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstreamrangedatelinedateline4 537Using where
1SIMPLEtypeeq_refPRIMARYPRIMARY4douglasr_bleachforuns.stream.typeid1 

Time Before: 0.05969 seconds
Time After: 0.05992 seconds
Time Taken: 0.00022 seconds

Memory Before: 8,491.563 KB
Memory After: 8,491.875 KB
Memory Used: 0.313 KB

SQL Query
SELECT
	p.postid AS p_postid, p.threadid AS p_threadid, p.title AS p_title, p.visible AS p_visible, p.userid AS p_userid, p.pagetext AS p_pagetext, p.username AS p_username,
	t.threadid AS t_threadid, t.title AS t_title, t.forumid AS t_forumid, t.pollid AS t_pollid, t.open AS t_open, t.postusername AS t_postusername,
	t.views AS t_views, t.visible AS t_visible, t.postuserid AS t_postuserid, t.postuserid AS t_userid, t.replycount AS t_replycount,
	fp.pagetext AS t_pagetext
FROM post AS p
INNER JOIN thread AS t ON (p.threadid = t.threadid)
INNER JOIN post AS fp ON (t.firstpostid = fp.postid)
WHERE
	p.postid IN (136475,136428,136427,136425,136424,136423,136422,136418,136415)
		AND
	p.visible <> 2
		AND
	t.visible <> 2
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEprangePRIMARY,threadid,threadid_visible_datelinePRIMARY4 9Using where
1SIMPLEteq_refPRIMARYPRIMARY4douglasr_bleachforuns.p.threadid1Using where
1SIMPLEfpeq_refPRIMARYPRIMARY4douglasr_bleachforuns.t.firstpostid1 

Time Before: 0.06174 seconds
Time After: 0.06201 seconds
Time Taken: 0.00027 seconds

Memory Before: 8,736.477 KB
Memory After: 8,736.281 KB
Memory Used: -0.195 KB

SQL Query
SELECT
	vm.userid, vm.postuserid, vm.dateline, vm.state, vm.title, vm.pagetext, vm.vmid, vm.postusername
FROM visitormessage AS vm
WHERE
	vm.vmid IN (2638,2637,2636,2635,2634,2633,2632,2631,2630,2629,2628,2627,2626,2625,2624,2623,2622,2621,2620,2619,2618)
		AND
	vm.state <> 'deleted'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvmrangePRIMARYPRIMARY4 21Using where

Time Before: 0.06248 seconds
Time After: 0.06297 seconds
Time Taken: 0.00049 seconds

Memory Before: 8,759.992 KB
Memory After: 8,760.250 KB
Memory Used: 0.258 KB

SQL Query
SELECT u.*
	, av.avatarpath, NOT ISNULL(cu.userid) AS hascustomavatar,
		cu.dateline AS avatardateline, cu.width AS avwidth, cu.height AS avheight, cu.height_thumb AS avheight_thumb,
		cu.width_thumb AS avwidth_thumb, NOT ISNULL(cu.filedata_thumb) AS filedata_thumb
		
FROM user AS u

	LEFT JOIN avatar AS av ON(av.avatarid = u.avatarid)
	LEFT JOIN customavatar AS cu ON(cu.userid = u.userid)
	
WHERE u.userid IN (30538,20,34592,58,40125,40126,40128,40132,40133,40135,40138,40140,40141,40137,40150,40152,40157,40158,40159,40161,40165,40167,40168,40171,40172)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEurangePRIMARYPRIMARY4 25Using where
1SIMPLEaveq_refPRIMARYPRIMARY2douglasr_bleachforuns.u.avatarid1 
1SIMPLEcueq_refPRIMARYPRIMARY4douglasr_bleachforuns.u.userid1 

Time Before: 0.06493 seconds
Time After: 0.06553 seconds
Time Taken: 0.00060 seconds

Memory Before: 9,017.313 KB
Memory After: 9,017.289 KB
Memory Used: -0.023 KB

SQL Query
SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
	 , dbtech_livewall_settings.posts_display , dbtech_livewall_settings.posts_privacy , dbtech_livewall_settings.socialgroupposts_display , dbtech_livewall_settings.socialgroupposts_privacy , dbtech_livewall_settings.socialgroupthreads_display , dbtech_livewall_settings.socialgroupthreads_privacy , dbtech_livewall_settings.threads_display , dbtech_livewall_settings.threads_privacy , dbtech_livewall_settings.statusupdate_display , dbtech_livewall_settings.statusupdate_privacy , dbtech_livewall_settings.aptl_display , dbtech_livewall_settings.aptl_privacy
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 dbtech_livewall_settings AS dbtech_livewall_settings ON(dbtech_livewall_settings.userid = user.userid)
WHERE user.userid = 40172
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
1SIMPLEdbtech_livewall_settingsconstPRIMARYPRIMARY4const1 

Time Before: 0.06899 seconds
Time After: 0.06938 seconds
Time Taken: 0.00039 seconds

Memory Before: 9,642.438 KB
Memory After: 9,641.930 KB
Memory Used: -0.508 KB

SQL Query
SELECT requirement
FROM profileblockprivacy
WHERE userid = 40172
	AND blockid = 'visitor_messaging'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.06985 seconds
Time After: 0.06992 seconds
Time Taken: 0.00007 seconds

Memory Before: 9,681.742 KB
Memory After: 9,682.195 KB
Memory Used: 0.453 KB

SQL Query
SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
	 , dbtech_livewall_settings.posts_display , dbtech_livewall_settings.posts_privacy , dbtech_livewall_settings.socialgroupposts_display , dbtech_livewall_settings.socialgroupposts_privacy , dbtech_livewall_settings.socialgroupthreads_display , dbtech_livewall_settings.socialgroupthreads_privacy , dbtech_livewall_settings.threads_display , dbtech_livewall_settings.threads_privacy , dbtech_livewall_settings.statusupdate_display , dbtech_livewall_settings.statusupdate_privacy , dbtech_livewall_settings.aptl_display , dbtech_livewall_settings.aptl_privacy
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 dbtech_livewall_settings AS dbtech_livewall_settings ON(dbtech_livewall_settings.userid = user.userid)
WHERE user.userid = 40171
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
1SIMPLEdbtech_livewall_settingsconstPRIMARYPRIMARY4const1 

Time Before: 0.07103 seconds
Time After: 0.07131 seconds
Time Taken: 0.00028 seconds

Memory Before: 9,750.070 KB
Memory After: 9,749.563 KB
Memory Used: -0.508 KB

SQL Query
SELECT requirement
FROM profileblockprivacy
WHERE userid = 40171
	AND blockid = 'visitor_messaging'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.07158 seconds
Time After: 0.07165 seconds
Time Taken: 0.00006 seconds

Memory Before: 9,788.625 KB
Memory After: 9,789.078 KB
Memory Used: 0.453 KB

SQL Query
SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
	 , dbtech_livewall_settings.posts_display , dbtech_livewall_settings.posts_privacy , dbtech_livewall_settings.socialgroupposts_display , dbtech_livewall_settings.socialgroupposts_privacy , dbtech_livewall_settings.socialgroupthreads_display , dbtech_livewall_settings.socialgroupthreads_privacy , dbtech_livewall_settings.threads_display , dbtech_livewall_settings.threads_privacy , dbtech_livewall_settings.statusupdate_display , dbtech_livewall_settings.statusupdate_privacy , dbtech_livewall_settings.aptl_display , dbtech_livewall_settings.aptl_privacy
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 dbtech_livewall_settings AS dbtech_livewall_settings ON(dbtech_livewall_settings.userid = user.userid)
WHERE user.userid = 40168
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
1SIMPLEdbtech_livewall_settingsconstPRIMARYPRIMARY4const1 

Time Before: 0.07213 seconds
Time After: 0.07240 seconds
Time Taken: 0.00027 seconds

Memory Before: 9,779.078 KB
Memory After: 9,778.570 KB
Memory Used: -0.508 KB

SQL Query
SELECT requirement
FROM profileblockprivacy
WHERE userid = 40168
	AND blockid = 'visitor_messaging'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.07267 seconds
Time After: 0.07274 seconds
Time Taken: 0.00007 seconds

Memory Before: 9,817.703 KB
Memory After: 9,818.156 KB
Memory Used: 0.453 KB

SQL Query
SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
	 , dbtech_livewall_settings.posts_display , dbtech_livewall_settings.posts_privacy , dbtech_livewall_settings.socialgroupposts_display , dbtech_livewall_settings.socialgroupposts_privacy , dbtech_livewall_settings.socialgroupthreads_display , dbtech_livewall_settings.socialgroupthreads_privacy , dbtech_livewall_settings.threads_display , dbtech_livewall_settings.threads_privacy , dbtech_livewall_settings.statusupdate_display , dbtech_livewall_settings.statusupdate_privacy , dbtech_livewall_settings.aptl_display , dbtech_livewall_settings.aptl_privacy
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 dbtech_livewall_settings AS dbtech_livewall_settings ON(dbtech_livewall_settings.userid = user.userid)
WHERE user.userid = 40167
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
1SIMPLEdbtech_livewall_settingsconstPRIMARYPRIMARY4const1 

Time Before: 0.07326 seconds
Time After: 0.07365 seconds
Time Taken: 0.00039 seconds

Memory Before: 9,808.164 KB
Memory After: 9,807.656 KB
Memory Used: -0.508 KB

SQL Query
SELECT requirement
FROM profileblockprivacy
WHERE userid = 40167
	AND blockid = 'visitor_messaging'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.07394 seconds
Time After: 0.07401 seconds
Time Taken: 0.00007 seconds

Memory Before: 9,847.039 KB
Memory After: 9,847.492 KB
Memory Used: 0.453 KB

SQL Query
SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
	 , dbtech_livewall_settings.posts_display , dbtech_livewall_settings.posts_privacy , dbtech_livewall_settings.socialgroupposts_display , dbtech_livewall_settings.socialgroupposts_privacy , dbtech_livewall_settings.socialgroupthreads_display , dbtech_livewall_settings.socialgroupthreads_privacy , dbtech_livewall_settings.threads_display , dbtech_livewall_settings.threads_privacy , dbtech_livewall_settings.statusupdate_display , dbtech_livewall_settings.statusupdate_privacy , dbtech_livewall_settings.aptl_display , dbtech_livewall_settings.aptl_privacy
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 dbtech_livewall_settings AS dbtech_livewall_settings ON(dbtech_livewall_settings.userid = user.userid)
WHERE user.userid = 40165
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
1SIMPLEdbtech_livewall_settingsconstPRIMARYPRIMARY4const1 

Time Before: 0.07453 seconds
Time After: 0.07488 seconds
Time Taken: 0.00035 seconds

Memory Before: 9,837.500 KB
Memory After: 9,836.992 KB
Memory Used: -0.508 KB

SQL Query
SELECT requirement
FROM profileblockprivacy
WHERE userid = 40165
	AND blockid = 'visitor_messaging'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.07520 seconds
Time After: 0.07528 seconds
Time Taken: 0.00009 seconds

Memory Before: 9,876.344 KB
Memory After: 9,876.797 KB
Memory Used: 0.453 KB

SQL Query
SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
	 , dbtech_livewall_settings.posts_display , dbtech_livewall_settings.posts_privacy , dbtech_livewall_settings.socialgroupposts_display , dbtech_livewall_settings.socialgroupposts_privacy , dbtech_livewall_settings.socialgroupthreads_display , dbtech_livewall_settings.socialgroupthreads_privacy , dbtech_livewall_settings.threads_display , dbtech_livewall_settings.threads_privacy , dbtech_livewall_settings.statusupdate_display , dbtech_livewall_settings.statusupdate_privacy , dbtech_livewall_settings.aptl_display , dbtech_livewall_settings.aptl_privacy
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 dbtech_livewall_settings AS dbtech_livewall_settings ON(dbtech_livewall_settings.userid = user.userid)
WHERE user.userid = 40161
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
1SIMPLEdbtech_livewall_settingsconstPRIMARYPRIMARY4const1 

Time Before: 0.07583 seconds
Time After: 0.07620 seconds
Time Taken: 0.00036 seconds

Memory Before: 9,866.805 KB
Memory After: 9,866.297 KB
Memory Used: -0.508 KB

SQL Query
SELECT requirement
FROM profileblockprivacy
WHERE userid = 40161
	AND blockid = 'visitor_messaging'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.07648 seconds
Time After: 0.07657 seconds
Time Taken: 0.00008 seconds

Memory Before: 9,905.406 KB
Memory After: 9,905.859 KB
Memory Used: 0.453 KB

SQL Query
SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
	 , dbtech_livewall_settings.posts_display , dbtech_livewall_settings.posts_privacy , dbtech_livewall_settings.socialgroupposts_display , dbtech_livewall_settings.socialgroupposts_privacy , dbtech_livewall_settings.socialgroupthreads_display , dbtech_livewall_settings.socialgroupthreads_privacy , dbtech_livewall_settings.threads_display , dbtech_livewall_settings.threads_privacy , dbtech_livewall_settings.statusupdate_display , dbtech_livewall_settings.statusupdate_privacy , dbtech_livewall_settings.aptl_display , dbtech_livewall_settings.aptl_privacy
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 dbtech_livewall_settings AS dbtech_livewall_settings ON(dbtech_livewall_settings.userid = user.userid)
WHERE user.userid = 40159
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
1SIMPLEdbtech_livewall_settingsconstPRIMARYPRIMARY4const1 

Time Before: 0.07707 seconds
Time After: 0.07739 seconds
Time Taken: 0.00032 seconds

Memory Before: 9,895.867 KB
Memory After: 9,895.359 KB
Memory Used: -0.508 KB

SQL Query
SELECT requirement
FROM profileblockprivacy
WHERE userid = 40159
	AND blockid = 'visitor_messaging'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.07769 seconds
Time After: 0.07778 seconds
Time Taken: 0.00008 seconds

Memory Before: 9,934.516 KB
Memory After: 9,934.969 KB
Memory Used: 0.453 KB

SQL Query
SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
	 , dbtech_livewall_settings.posts_display , dbtech_livewall_settings.posts_privacy , dbtech_livewall_settings.socialgroupposts_display , dbtech_livewall_settings.socialgroupposts_privacy , dbtech_livewall_settings.socialgroupthreads_display , dbtech_livewall_settings.socialgroupthreads_privacy , dbtech_livewall_settings.threads_display , dbtech_livewall_settings.threads_privacy , dbtech_livewall_settings.statusupdate_display , dbtech_livewall_settings.statusupdate_privacy , dbtech_livewall_settings.aptl_display , dbtech_livewall_settings.aptl_privacy
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 dbtech_livewall_settings AS dbtech_livewall_settings ON(dbtech_livewall_settings.userid = user.userid)
WHERE user.userid = 40158
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
1SIMPLEdbtech_livewall_settingsconstPRIMARYPRIMARY4const1 

Time Before: 0.07833 seconds
Time After: 0.07871 seconds
Time Taken: 0.00038 seconds

Memory Before: 9,924.977 KB
Memory After: 9,924.469 KB
Memory Used: -0.508 KB

SQL Query
SELECT requirement
FROM profileblockprivacy
WHERE userid = 40158
	AND blockid = 'visitor_messaging'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.07905 seconds
Time After: 0.07917 seconds
Time Taken: 0.00012 seconds

Memory Before: 9,963.844 KB
Memory After: 9,964.297 KB
Memory Used: 0.453 KB

SQL Query
SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
	 , dbtech_livewall_settings.posts_display , dbtech_livewall_settings.posts_privacy , dbtech_livewall_settings.socialgroupposts_display , dbtech_livewall_settings.socialgroupposts_privacy , dbtech_livewall_settings.socialgroupthreads_display , dbtech_livewall_settings.socialgroupthreads_privacy , dbtech_livewall_settings.threads_display , dbtech_livewall_settings.threads_privacy , dbtech_livewall_settings.statusupdate_display , dbtech_livewall_settings.statusupdate_privacy , dbtech_livewall_settings.aptl_display , dbtech_livewall_settings.aptl_privacy
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 dbtech_livewall_settings AS dbtech_livewall_settings ON(dbtech_livewall_settings.userid = user.userid)
WHERE user.userid = 40157
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
1SIMPLEdbtech_livewall_settingsconstPRIMARYPRIMARY4const1 

Time Before: 0.07970 seconds
Time After: 0.08006 seconds
Time Taken: 0.00036 seconds

Memory Before: 9,954.367 KB
Memory After: 9,953.859 KB
Memory Used: -0.508 KB

SQL Query
SELECT requirement
FROM profileblockprivacy
WHERE userid = 40157
	AND blockid = 'visitor_messaging'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.08038 seconds
Time After: 0.08045 seconds
Time Taken: 0.00007 seconds

Memory Before: 9,993.117 KB
Memory After: 9,993.570 KB
Memory Used: 0.453 KB

SQL Query
SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
	 , dbtech_livewall_settings.posts_display , dbtech_livewall_settings.posts_privacy , dbtech_livewall_settings.socialgroupposts_display , dbtech_livewall_settings.socialgroupposts_privacy , dbtech_livewall_settings.socialgroupthreads_display , dbtech_livewall_settings.socialgroupthreads_privacy , dbtech_livewall_settings.threads_display , dbtech_livewall_settings.threads_privacy , dbtech_livewall_settings.statusupdate_display , dbtech_livewall_settings.statusupdate_privacy , dbtech_livewall_settings.aptl_display , dbtech_livewall_settings.aptl_privacy
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 dbtech_livewall_settings AS dbtech_livewall_settings ON(dbtech_livewall_settings.userid = user.userid)
WHERE user.userid = 40152
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
1SIMPLEdbtech_livewall_settingsconstPRIMARYPRIMARY4const1 

Time Before: 0.08094 seconds
Time After: 0.08121 seconds
Time Taken: 0.00027 seconds

Memory Before: 9,983.578 KB
Memory After: 9,983.070 KB
Memory Used: -0.508 KB

SQL Query
SELECT requirement
FROM profileblockprivacy
WHERE userid = 40152
	AND blockid = 'visitor_messaging'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.08148 seconds
Time After: 0.08154 seconds
Time Taken: 0.00006 seconds

Memory Before: 10,022.227 KB
Memory After: 10,022.680 KB
Memory Used: 0.453 KB

SQL Query
SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
	 , dbtech_livewall_settings.posts_display , dbtech_livewall_settings.posts_privacy , dbtech_livewall_settings.socialgroupposts_display , dbtech_livewall_settings.socialgroupposts_privacy , dbtech_livewall_settings.socialgroupthreads_display , dbtech_livewall_settings.socialgroupthreads_privacy , dbtech_livewall_settings.threads_display , dbtech_livewall_settings.threads_privacy , dbtech_livewall_settings.statusupdate_display , dbtech_livewall_settings.statusupdate_privacy , dbtech_livewall_settings.aptl_display , dbtech_livewall_settings.aptl_privacy
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 dbtech_livewall_settings AS dbtech_livewall_settings ON(dbtech_livewall_settings.userid = user.userid)
WHERE user.userid = 40150
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
1SIMPLEdbtech_livewall_settingsconstPRIMARYPRIMARY4const1 

Time Before: 0.08203 seconds
Time After: 0.08231 seconds
Time Taken: 0.00029 seconds

Memory Before: 10,012.688 KB
Memory After: 10,012.180 KB
Memory Used: -0.508 KB

SQL Query
SELECT requirement
FROM profileblockprivacy
WHERE userid = 40150
	AND blockid = 'visitor_messaging'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.08266 seconds
Time After: 0.08273 seconds
Time Taken: 0.00007 seconds

Memory Before: 10,051.406 KB
Memory After: 10,051.859 KB
Memory Used: 0.453 KB

SQL Query
SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
	 , dbtech_livewall_settings.posts_display , dbtech_livewall_settings.posts_privacy , dbtech_livewall_settings.socialgroupposts_display , dbtech_livewall_settings.socialgroupposts_privacy , dbtech_livewall_settings.socialgroupthreads_display , dbtech_livewall_settings.socialgroupthreads_privacy , dbtech_livewall_settings.threads_display , dbtech_livewall_settings.threads_privacy , dbtech_livewall_settings.statusupdate_display , dbtech_livewall_settings.statusupdate_privacy , dbtech_livewall_settings.aptl_display , dbtech_livewall_settings.aptl_privacy
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 dbtech_livewall_settings AS dbtech_livewall_settings ON(dbtech_livewall_settings.userid = user.userid)
WHERE user.userid = 40137
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
1SIMPLEdbtech_livewall_settingsconstPRIMARYPRIMARY4const1 

Time Before: 0.08334 seconds
Time After: 0.08362 seconds
Time Taken: 0.00028 seconds

Memory Before: 10,042.039 KB
Memory After: 10,041.531 KB
Memory Used: -0.508 KB

SQL Query
SELECT requirement
FROM profileblockprivacy
WHERE userid = 40137
	AND blockid = 'visitor_messaging'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.08389 seconds
Time After: 0.08395 seconds
Time Taken: 0.00006 seconds

Memory Before: 10,080.711 KB
Memory After: 10,081.164 KB
Memory Used: 0.453 KB

SQL Query
SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
	 , dbtech_livewall_settings.posts_display , dbtech_livewall_settings.posts_privacy , dbtech_livewall_settings.socialgroupposts_display , dbtech_livewall_settings.socialgroupposts_privacy , dbtech_livewall_settings.socialgroupthreads_display , dbtech_livewall_settings.socialgroupthreads_privacy , dbtech_livewall_settings.threads_display , dbtech_livewall_settings.threads_privacy , dbtech_livewall_settings.statusupdate_display , dbtech_livewall_settings.statusupdate_privacy , dbtech_livewall_settings.aptl_display , dbtech_livewall_settings.aptl_privacy
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 dbtech_livewall_settings AS dbtech_livewall_settings ON(dbtech_livewall_settings.userid = user.userid)
WHERE user.userid = 40141
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
1SIMPLEdbtech_livewall_settingsconstPRIMARYPRIMARY4const1 

Time Before: 0.08442 seconds
Time After: 0.08470 seconds
Time Taken: 0.00028 seconds

Memory Before: 10,071.172 KB
Memory After: 10,070.664 KB
Memory Used: -0.508 KB

SQL Query
SELECT requirement
FROM profileblockprivacy
WHERE userid = 40141
	AND blockid = 'visitor_messaging'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.08499 seconds
Time After: 0.08505 seconds
Time Taken: 0.00006 seconds

Memory Before: 10,109.836 KB
Memory After: 10,110.289 KB
Memory Used: 0.453 KB

SQL Query
SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
	 , dbtech_livewall_settings.posts_display , dbtech_livewall_settings.posts_privacy , dbtech_livewall_settings.socialgroupposts_display , dbtech_livewall_settings.socialgroupposts_privacy , dbtech_livewall_settings.socialgroupthreads_display , dbtech_livewall_settings.socialgroupthreads_privacy , dbtech_livewall_settings.threads_display , dbtech_livewall_settings.threads_privacy , dbtech_livewall_settings.statusupdate_display , dbtech_livewall_settings.statusupdate_privacy , dbtech_livewall_settings.aptl_display , dbtech_livewall_settings.aptl_privacy
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 dbtech_livewall_settings AS dbtech_livewall_settings ON(dbtech_livewall_settings.userid = user.userid)
WHERE user.userid = 40140
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
1SIMPLEdbtech_livewall_settingsconstPRIMARYPRIMARY4const1 

Time Before: 0.08554 seconds
Time After: 0.08581 seconds
Time Taken: 0.00027 seconds

Memory Before: 10,100.297 KB
Memory After: 10,099.789 KB
Memory Used: -0.508 KB

SQL Query
SELECT requirement
FROM profileblockprivacy
WHERE userid = 40140
	AND blockid = 'visitor_messaging'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.08608 seconds
Time After: 0.08614 seconds
Time Taken: 0.00006 seconds

Memory Before: 10,138.953 KB
Memory After: 10,139.406 KB
Memory Used: 0.453 KB

SQL Query
SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
	 , dbtech_livewall_settings.posts_display , dbtech_livewall_settings.posts_privacy , dbtech_livewall_settings.socialgroupposts_display , dbtech_livewall_settings.socialgroupposts_privacy , dbtech_livewall_settings.socialgroupthreads_display , dbtech_livewall_settings.socialgroupthreads_privacy , dbtech_livewall_settings.threads_display , dbtech_livewall_settings.threads_privacy , dbtech_livewall_settings.statusupdate_display , dbtech_livewall_settings.statusupdate_privacy , dbtech_livewall_settings.aptl_display , dbtech_livewall_settings.aptl_privacy
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 dbtech_livewall_settings AS dbtech_livewall_settings ON(dbtech_livewall_settings.userid = user.userid)
WHERE user.userid = 40138
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
1SIMPLEdbtech_livewall_settingsconstPRIMARYPRIMARY4const1 

Time Before: 0.08661 seconds
Time After: 0.08688 seconds
Time Taken: 0.00027 seconds

Memory Before: 10,129.539 KB
Memory After: 10,129.031 KB
Memory Used: -0.508 KB

SQL Query
SELECT requirement
FROM profileblockprivacy
WHERE userid = 40138
	AND blockid = 'visitor_messaging'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.08717 seconds
Time After: 0.08723 seconds
Time Taken: 0.00006 seconds

Memory Before: 10,168.141 KB
Memory After: 10,168.594 KB
Memory Used: 0.453 KB

SQL Query
SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
	 , dbtech_livewall_settings.posts_display , dbtech_livewall_settings.posts_privacy , dbtech_livewall_settings.socialgroupposts_display , dbtech_livewall_settings.socialgroupposts_privacy , dbtech_livewall_settings.socialgroupthreads_display , dbtech_livewall_settings.socialgroupthreads_privacy , dbtech_livewall_settings.threads_display , dbtech_livewall_settings.threads_privacy , dbtech_livewall_settings.statusupdate_display , dbtech_livewall_settings.statusupdate_privacy , dbtech_livewall_settings.aptl_display , dbtech_livewall_settings.aptl_privacy
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 dbtech_livewall_settings AS dbtech_livewall_settings ON(dbtech_livewall_settings.userid = user.userid)
WHERE user.userid = 40135
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
1SIMPLEdbtech_livewall_settingsconstPRIMARYPRIMARY4const1 

Time Before: 0.08773 seconds
Time After: 0.08800 seconds
Time Taken: 0.00027 seconds

Memory Before: 10,158.688 KB
Memory After: 10,158.180 KB
Memory Used: -0.508 KB

SQL Query
SELECT requirement
FROM profileblockprivacy
WHERE userid = 40135
	AND blockid = 'visitor_messaging'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.08827 seconds
Time After: 0.08834 seconds
Time Taken: 0.00007 seconds

Memory Before: 10,197.320 KB
Memory After: 10,197.773 KB
Memory Used: 0.453 KB

SQL Query
SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
	 , dbtech_livewall_settings.posts_display , dbtech_livewall_settings.posts_privacy , dbtech_livewall_settings.socialgroupposts_display , dbtech_livewall_settings.socialgroupposts_privacy , dbtech_livewall_settings.socialgroupthreads_display , dbtech_livewall_settings.socialgroupthreads_privacy , dbtech_livewall_settings.threads_display , dbtech_livewall_settings.threads_privacy , dbtech_livewall_settings.statusupdate_display , dbtech_livewall_settings.statusupdate_privacy , dbtech_livewall_settings.aptl_display , dbtech_livewall_settings.aptl_privacy
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 dbtech_livewall_settings AS dbtech_livewall_settings ON(dbtech_livewall_settings.userid = user.userid)
WHERE user.userid = 40133
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
1SIMPLEdbtech_livewall_settingsconstPRIMARYPRIMARY4const1 

Time Before: 0.08887 seconds
Time After: 0.08918 seconds
Time Taken: 0.00031 seconds

Memory Before: 10,188.039 KB
Memory After: 10,187.531 KB
Memory Used: -0.508 KB

SQL Query
SELECT requirement
FROM profileblockprivacy
WHERE userid = 40133
	AND blockid = 'visitor_messaging'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.08948 seconds
Time After: 0.08954 seconds
Time Taken: 0.00007 seconds

Memory Before: 10,226.758 KB
Memory After: 10,227.211 KB
Memory Used: 0.453 KB

SQL Query
SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
	 , dbtech_livewall_settings.posts_display , dbtech_livewall_settings.posts_privacy , dbtech_livewall_settings.socialgroupposts_display , dbtech_livewall_settings.socialgroupposts_privacy , dbtech_livewall_settings.socialgroupthreads_display , dbtech_livewall_settings.socialgroupthreads_privacy , dbtech_livewall_settings.threads_display , dbtech_livewall_settings.threads_privacy , dbtech_livewall_settings.statusupdate_display , dbtech_livewall_settings.statusupdate_privacy , dbtech_livewall_settings.aptl_display , dbtech_livewall_settings.aptl_privacy
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 dbtech_livewall_settings AS dbtech_livewall_settings ON(dbtech_livewall_settings.userid = user.userid)
WHERE user.userid = 40132
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
1SIMPLEdbtech_livewall_settingsconstPRIMARYPRIMARY4const1 

Time Before: 0.09004 seconds
Time After: 0.09031 seconds
Time Taken: 0.00027 seconds

Memory Before: 10,217.305 KB
Memory After: 10,216.797 KB
Memory Used: -0.508 KB

SQL Query
SELECT requirement
FROM profileblockprivacy
WHERE userid = 40132
	AND blockid = 'visitor_messaging'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.09058 seconds
Time After: 0.09064 seconds
Time Taken: 0.00006 seconds

Memory Before: 10,255.969 KB
Memory After: 10,256.422 KB
Memory Used: 0.453 KB

SQL Query
SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
	 , dbtech_livewall_settings.posts_display , dbtech_livewall_settings.posts_privacy , dbtech_livewall_settings.socialgroupposts_display , dbtech_livewall_settings.socialgroupposts_privacy , dbtech_livewall_settings.socialgroupthreads_display , dbtech_livewall_settings.socialgroupthreads_privacy , dbtech_livewall_settings.threads_display , dbtech_livewall_settings.threads_privacy , dbtech_livewall_settings.statusupdate_display , dbtech_livewall_settings.statusupdate_privacy , dbtech_livewall_settings.aptl_display , dbtech_livewall_settings.aptl_privacy
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 dbtech_livewall_settings AS dbtech_livewall_settings ON(dbtech_livewall_settings.userid = user.userid)
WHERE user.userid = 40128
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
1SIMPLEdbtech_livewall_settingsconstPRIMARYPRIMARY4const1 

Time Before: 0.09113 seconds
Time After: 0.09139 seconds
Time Taken: 0.00027 seconds

Memory Before: 10,246.516 KB
Memory After: 10,246.008 KB
Memory Used: -0.508 KB

SQL Query
SELECT requirement
FROM profileblockprivacy
WHERE userid = 40128
	AND blockid = 'visitor_messaging'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.09168 seconds
Time After: 0.09175 seconds
Time Taken: 0.00006 seconds

Memory Before: 10,285.633 KB
Memory After: 10,286.086 KB
Memory Used: 0.453 KB

SQL Query
SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
	 , dbtech_livewall_settings.posts_display , dbtech_livewall_settings.posts_privacy , dbtech_livewall_settings.socialgroupposts_display , dbtech_livewall_settings.socialgroupposts_privacy , dbtech_livewall_settings.socialgroupthreads_display , dbtech_livewall_settings.socialgroupthreads_privacy , dbtech_livewall_settings.threads_display , dbtech_livewall_settings.threads_privacy , dbtech_livewall_settings.statusupdate_display , dbtech_livewall_settings.statusupdate_privacy , dbtech_livewall_settings.aptl_display , dbtech_livewall_settings.aptl_privacy
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 dbtech_livewall_settings AS dbtech_livewall_settings ON(dbtech_livewall_settings.userid = user.userid)
WHERE user.userid = 40126
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
1SIMPLEdbtech_livewall_settingsconstPRIMARYPRIMARY4const1 

Time Before: 0.09225 seconds
Time After: 0.09254 seconds
Time Taken: 0.00029 seconds

Memory Before: 10,276.094 KB
Memory After: 10,275.586 KB
Memory Used: -0.508 KB

SQL Query
SELECT requirement
FROM profileblockprivacy
WHERE userid = 40126
	AND blockid = 'visitor_messaging'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.09283 seconds
Time After: 0.09289 seconds
Time Taken: 0.00007 seconds

Memory Before: 10,314.750 KB
Memory After: 10,315.203 KB
Memory Used: 0.453 KB

SQL Query
SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
	 , dbtech_livewall_settings.posts_display , dbtech_livewall_settings.posts_privacy , dbtech_livewall_settings.socialgroupposts_display , dbtech_livewall_settings.socialgroupposts_privacy , dbtech_livewall_settings.socialgroupthreads_display , dbtech_livewall_settings.socialgroupthreads_privacy , dbtech_livewall_settings.threads_display , dbtech_livewall_settings.threads_privacy , dbtech_livewall_settings.statusupdate_display , dbtech_livewall_settings.statusupdate_privacy , dbtech_livewall_settings.aptl_display , dbtech_livewall_settings.aptl_privacy
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 dbtech_livewall_settings AS dbtech_livewall_settings ON(dbtech_livewall_settings.userid = user.userid)
WHERE user.userid = 40125
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
1SIMPLEdbtech_livewall_settingsconstPRIMARYPRIMARY4const1 

Time Before: 0.09339 seconds
Time After: 0.09367 seconds
Time Taken: 0.00028 seconds

Memory Before: 10,305.211 KB
Memory After: 10,304.703 KB
Memory Used: -0.508 KB

SQL Query
SELECT requirement
FROM profileblockprivacy
WHERE userid = 40125
	AND blockid = 'visitor_messaging'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.09396 seconds
Time After: 0.09402 seconds
Time Taken: 0.00006 seconds

Memory Before: 10,343.867 KB
Memory After: 10,344.320 KB
Memory Used: 0.453 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (5146,5138,5139,5140,5141,5142,5147,5143,5144,5145,5148,5149,5150,5151,5152,6324,5776,5717,5787,2029,2028,2030,2020,2019,2026,5081,5088,2024,2033,2034,5068,5473,5769,6286,6287,5420,5421,5422,5785,0,0,5748,5750,5443,5444,5446,5447,5670,5712,5711,5761,5713,5270,5269,5273,3059,3639,3701,3702,3703,6103,6098,6112,6111,6113,6105,5260,6107,6106,6050,6049,6051,0,6328)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 72Using where

Time Before: 0.09586 seconds
Time After: 0.09676 seconds
Time Taken: 0.00090 seconds

Memory Before: 10,561.398 KB
Memory After: 10,561.539 KB
Memory Used: 0.141 KB

SQL Query
SELECT *
FROM navigation
WHERE state & 4 = 0
ORDER BY navtype, displayorder
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnavigationALL    35Using where; Using filesort

Time Before: 0.13371 seconds
Time After: 0.13399 seconds
Time Taken: 0.00028 seconds

Memory Before: 10,978.578 KB
Memory After: 10,979.055 KB
Memory Used: 0.477 KB

SQL Query
UPDATE session
SET lastactivity = 1519403914, location = '/activity.php?explain=1', inforum = 0, inthread = 0, badlocation = 0
WHERE sessionhash = '70e309c042b38771e7559cd78d01d3f3'

Time Before: 0.13719 seconds
Time After: 0.13734 seconds
Time Taken: 0.00015 seconds

Memory Before: 11,431.914 KB
Memory After: 11,432.117 KB
Memory Used: 0.203 KB

Page generated in 0.13637018203735 seconds with 56 queries, spending 0.015059947967529 doing MySQL queries and 0.12131023406982 doing PHP things.
Shutdown Queries:
DISABLED