Including Functions.php

Time Before: 0.01487 seconds
Time After: 0.02369 seconds
Time Taken: 0.00882 seconds

Memory Before: 414.016 KB
Memory After: 421.906 KB
Memory Used: 7.891 KB

Connect to Database on Server: sql5c11b.megasqlservers.com

Time Before: 0.02380 seconds
Time After: 0.02807 seconds
Time Taken: 0.00428 seconds

Memory Before: 421.859 KB
Memory After: 422.781 KB
Memory Used: 0.922 KB

Datastore Setup
SQL Query
SELECT title, data
FROM datastore
WHERE title IN ('','options','bitfields','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','iconcache')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY17 11Using index condition

Time Before: 0.02868 seconds
Time After: 0.02895 seconds
Time Taken: 0.00026 seconds

Memory Before: 425.781 KB
Memory After: 426.344 KB
Memory Used: 0.563 KB

Time Before: 0.02825 seconds
Time After: 0.02942 seconds
Time Taken: 0.00116 seconds

Memory Before: 422.453 KB
Memory After: 701.484 KB
Memory Used: 279.031 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '18.205.246.238'
	AND idhash = 'ce926b9ac401199b58191b7d32dbf5fb'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionALL    136Using where

Time Before: 0.02982 seconds
Time After: 0.03016 seconds
Time Taken: 0.00033 seconds

Memory Before: 710.133 KB
Memory After: 710.539 KB
Memory Used: 0.406 KB

SQL Query
SELECT languageid,
			phrasegroup_search AS phrasegroup_search,
			phrasegroup_inlinemod AS phrasegroup_inlinemod,
			phrasegroup_global AS phrasegroup_global,
			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
1SIMPLElanguagesystemPRIMARY   1 

Time Before: 0.03101 seconds
Time After: 0.03123 seconds
Time Taken: 0.00022 seconds

Memory Before: 719.586 KB
Memory After: 719.445 KB
Memory Used: -0.141 KB

Time Before: 0.02951 seconds
Time After: 0.03129 seconds
Time Taken: 0.00178 seconds

Memory Before: 705.656 KB
Memory After: 752.383 KB
Memory Used: 46.727 KB

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

Time Before: 0.03819 seconds
Time After: 0.03837 seconds
Time Taken: 0.00019 seconds

Memory Before: 857.875 KB
Memory After: 858.328 KB
Memory Used: 0.453 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (3300,3301,3302,3303,3352,3353,3354,3243,3341,3340,450,3422,3389,3260,3405,418,3384,3387,3395,3246,3247,3248,3249,3355,3400,3399,3401,3404)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 28Using index condition

Time Before: 0.03891 seconds
Time After: 0.03917 seconds
Time Taken: 0.00026 seconds

Memory Before: 982.133 KB
Memory After: 982.484 KB
Memory Used: 0.352 KB

End call of global.php: 0.039669990539551
SQL Query
SELECT searchid, dateline
FROM search AS search
WHERE ipaddress ='18.205.246.238'
ORDER BY dateline DESC LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.05015 seconds
Time After: 0.05028 seconds
Time Taken: 0.00012 seconds

Memory Before: 1,085.297 KB
Memory After: 1,085.719 KB
Memory Used: 0.422 KB

SQL Query
SELECT moderator.*, user.username,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid
FROM moderator AS moderator
INNER JOIN user AS user USING(userid)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.05065 seconds
Time After: 0.05078 seconds
Time Taken: 0.00013 seconds

Memory Before: 1,093.258 KB
Memory After: 1,093.625 KB
Memory Used: 0.367 KB

SQL Query
SELECT thread.threadid
FROM thread AS thread

WHERE thread.forumid IN(1, 4, 3, 5, 42)
	AND thread.lastpost >= 1547891596
	AND thread.visible IN (0,1,2)
	AND thread.sticky IN (0,1)
	AND thread.open <> 10
ORDER BY thread.lastpost DESC
LIMIT 500
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEthreadrangeforumid,lastpostlastpost6 1Using where

Time Before: 0.05118 seconds
Time After: 0.05143 seconds
Time Taken: 0.00026 seconds

Memory Before: 1,094.570 KB
Memory After: 1,094.867 KB
Memory Used: 0.297 KB

SQL Query
SELECT text, languageid
FROM phrase
WHERE phrasetypeid = 1000
	AND varname = 'searchnoresults' AND languageid IN (-1, 0, 1)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEphraserangename_lang_type,languageidname_lang_type256 3Using index condition

Time Before: 0.05178 seconds
Time After: 0.05188 seconds
Time Taken: 0.00010 seconds

Memory Before: 1,095.773 KB
Memory After: 1,096.195 KB
Memory Used: 0.422 KB

SQL Query
SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount
	
FROM forum AS forum
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEforumALL    6 

Time Before: 0.05217 seconds
Time After: 0.05228 seconds
Time Taken: 0.00010 seconds

Memory Before: 1,099.109 KB
Memory After: 1,099.523 KB
Memory Used: 0.414 KB

Page generated in 0.05295 seconds with 10 queries, spending 0.0062615871429443 doing MySQL queries and 0.046688412857056 doing PHP things.
Shutdown Queries:

SQL Query
UPDATE session
SET lastactivity = 1547977996, location = '/members/search.php?do=getdaily&explain=1', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = '715160364e35b87435fda49eb1dd767d'

Time Before: 0.05315 seconds
Time After: 0.05333 seconds
Time Taken: 0.00017 seconds

Memory Before: 1,222.953 KB
Memory After: 1,223.125 KB
Memory Used: 0.172 KB