Including Functions.php

Time Before: 0.00574 seconds
Time After: 0.01445 seconds
Time Taken: 0.00872 seconds

Memory Before: 1,705.820 KB
Memory After: 2,900.602 KB
Memory Used: 1,194.781 KB

Connect to Database on Server: localhost

Time Before: 0.01452 seconds
Time After: 0.01520 seconds
Time Taken: 0.00068 seconds

Memory Before: 2,900.578 KB
Memory After: 2,901.523 KB
Memory Used: 0.945 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.01532 seconds
Time After: 0.01537 seconds
Time Taken: 0.00006 seconds

Memory Before: 2,902.211 KB
Memory After: 2,902.766 KB
Memory Used: 0.555 KB

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

Time Before: 0.01571 seconds
Time After: 0.01627 seconds
Time Taken: 0.00056 seconds

Memory Before: 2,905.703 KB
Memory After: 2,906.023 KB
Memory Used: 0.320 KB

Time Before: 0.01540 seconds
Time After: 0.01801 seconds
Time Taken: 0.00261 seconds

Memory Before: 2,902.016 KB
Memory After: 3,852.727 KB
Memory Used: 950.711 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.02101 seconds
Time After: 0.02114 seconds
Time Taken: 0.00012 seconds

Memory Before: 4,489.516 KB
Memory After: 4,489.930 KB
Memory Used: 0.414 KB

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

Time Before: 0.02162 seconds
Time After: 0.02173 seconds
Time Taken: 0.00011 seconds

Memory Before: 4,544.195 KB
Memory After: 4,544.617 KB
Memory Used: 0.422 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_fronthelp AS phrasegroup_fronthelp,
			phrasegroup_register AS phrasegroup_register,
			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.02227 seconds
Time After: 0.02255 seconds
Time Taken: 0.00028 seconds

Memory Before: 4,556.063 KB
Memory After: 4,555.883 KB
Memory Used: -0.180 KB

Time Before: 0.02132 seconds
Time After: 0.02272 seconds
Time Taken: 0.00140 seconds

Memory Before: 4,537.336 KB
Memory After: 4,653.383 KB
Memory Used: 116.047 KB

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

Time Before: 0.02311 seconds
Time After: 0.02319 seconds
Time Taken: 0.00008 seconds

Memory Before: 4,661.852 KB
Memory After: 4,662.359 KB
Memory Used: 0.508 KB

SQL Query
SELECT IF(thread.visible = 2, 1, 0) AS isdeleted,



post.pagetext AS description,
thread.*


FROM thread AS thread




LEFT JOIN post AS post ON(post.postid = thread.firstpostid)


WHERE thread.threadid = 1934
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEthreadconstPRIMARYPRIMARY4const1 
1SIMPLEpostconstPRIMARYPRIMARY4const1 

Time Before: 0.04933 seconds
Time After: 0.04947 seconds
Time Taken: 0.00014 seconds

Memory Before: 6,483.453 KB
Memory After: 6,483.758 KB
Memory Used: 0.305 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.05104 seconds
Time After: 0.05125 seconds
Time Taken: 0.00022 seconds

Memory Before: 6,655.906 KB
Memory After: 6,656.328 KB
Memory Used: 0.422 KB

End call of global.php: 0.052928924560547
SQL Query
SELECT COUNT(postid) AS posts,
	post.username AS postuser,user.userid,user.username
FROM post AS post
LEFT JOIN user AS user USING(userid)
WHERE threadid = 1934
	AND visible = 1
GROUP BY userid
ORDER BY posts DESC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpostrefthreadid,threadid_visible_datelinethreadid_visible_dateline6const,const45Using temporary; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4douglasr_bleachforuns.post.userid1 

Time Before: 0.05481 seconds
Time After: 0.05543 seconds
Time Taken: 0.00062 seconds

Memory Before: 7,274.438 KB
Memory After: 7,274.773 KB
Memory Used: 0.336 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (5698,5699,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 59Using where

Time Before: 0.05708 seconds
Time After: 0.05749 seconds
Time Taken: 0.00041 seconds

Memory Before: 7,565.125 KB
Memory After: 7,565.336 KB
Memory Used: 0.211 KB

SQL Query
UPDATE session
SET lastactivity = 1529610579, location = '/misc.php?do=whoposted&t=1934&explain=1', inforum = 16, inthread = 1934, badlocation = 0
WHERE sessionhash = '60ca433af7a4e6f6dcbe67b2a651598e'

Time Before: 0.07887 seconds
Time After: 0.07900 seconds
Time Taken: 0.00013 seconds

Memory Before: 8,095.523 KB
Memory After: 8,095.711 KB
Memory Used: 0.188 KB

Page generated in 0.078454971313477 seconds with 11 queries, spending 0.0034089088439941 doing MySQL queries and 0.075046062469482 doing PHP things.
Shutdown Queries:
DISABLED