Including Functions.php

Time Before: 0.00582 seconds
Time After: 0.01444 seconds
Time Taken: 0.00862 seconds

Memory Before: 1,604.297 KB
Memory After: 2,849.258 KB
Memory Used: 1,244.961 KB

Connect to Database on Server: localhost

Time Before: 0.01457 seconds
Time After: 0.01512 seconds
Time Taken: 0.00056 seconds

Memory Before: 2,849.195 KB
Memory After: 2,850.148 KB
Memory Used: 0.953 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.01528 seconds
Time After: 0.01535 seconds
Time Taken: 0.00007 seconds

Memory Before: 2,850.883 KB
Memory After: 2,851.438 KB
Memory Used: 0.555 KB

Datastore Setup
SQL Query
SELECT *
FROM datastore
WHERE title IN ('smiliecache','bbcodecache','blogcategorycache','navdata','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream','routes')
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEdatastore rangePRIMARYPRIMARY152 19100.00Using index condition

Time Before: 0.01586 seconds
Time After: 0.01755 seconds
Time Taken: 0.00168 seconds

Memory Before: 2,854.766 KB
Memory After: 2,855.648 KB
Memory Used: 0.883 KB

Time Before: 0.01538 seconds
Time After: 0.02277 seconds
Time Taken: 0.00739 seconds

Memory Before: 2,850.688 KB
Memory After: 5,396.945 KB
Memory Used: 2,546.258 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '162.158.78.27'
	AND idhash = '202dc64119be75f956de2f57dd7c3812'
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsession refguest_lookup,user_activityguest_lookup145const,const,const2100.00 

Time Before: 0.02541 seconds
Time After: 0.02558 seconds
Time Taken: 0.00017 seconds

Memory Before: 5,990.992 KB
Memory After: 5,991.602 KB
Memory Used: 0.609 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 = 8
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLElanguage constPRIMARYPRIMARY2const1100.00 

Time Before: 0.02657 seconds
Time After: 0.02725 seconds
Time Taken: 0.00069 seconds

Memory Before: 6,003.953 KB
Memory After: 6,003.961 KB
Memory Used: 0.008 KB

Time Before: 0.02477 seconds
Time After: 0.02747 seconds
Time Taken: 0.00270 seconds

Memory Before: 5,983.320 KB
Memory After: 6,151.766 KB
Memory Used: 168.445 KB

SQL Query
SELECT *
FROM style
WHERE (styleid = 7 AND userselect = 1)
	OR styleid = 7
ORDER BY styleid ASC
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEstyle constPRIMARYPRIMARY2const1100.00 

Time Before: 0.03210 seconds
Time After: 0.03241 seconds
Time Taken: 0.00031 seconds

Memory Before: 6,758.375 KB
Memory After: 6,758.969 KB
Memory Used: 0.594 KB

End call of global.php: 0.033805847167969
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 <= 1563678777 AND stream.dateline > 1563073977
ORDER BY dateline DESC
LIMIT 0, 30
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLE         no matching row in const table

Time Before: 0.03606 seconds
Time After: 0.03619 seconds
Time Taken: 0.00012 seconds

Memory Before: 7,668.000 KB
Memory After: 7,668.313 KB
Memory Used: 0.313 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (9573,11294,11295,11296,11297,11298,11303,11299,11300,11301,11304,11305,11306,11307,11308,11923,11933,11874,11944,0,0,5728,5722,8390,5355,5727,5725,5361,5729,5730,5731,11630,11926,11576,11580,11577,11578,11579,11942,0,0,11905,11907,11600,11601,11603,11604,11827,11869,11868,11918,11870,11427,11426,11430)
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEtemplate rangePRIMARYPRIMARY4 52100.00Using index condition

Time Before: 0.03731 seconds
Time After: 0.03791 seconds
Time Taken: 0.00060 seconds

Memory Before: 7,932.102 KB
Memory After: 7,933.523 KB
Memory Used: 1.422 KB

SQL Query
UPDATE session
SET lastactivity = 1563678777, location = '/activity.php?time=week&show=all&sortby=recent&explain=1', badlocation = 0
WHERE sessionhash = 'e8eb2791ed10cee03a53987b25f43af0'

Time Before: 0.04341 seconds
Time After: 0.04367 seconds
Time Taken: 0.00026 seconds

Memory Before: 8,354.305 KB
Memory After: 8,354.469 KB
Memory Used: 0.164 KB

Page generated in 0.042991876602173 seconds with 8 queries, spending 0.0044736862182617 doing MySQL queries and 0.038518190383911 doing PHP things.
Shutdown Queries:
DISABLED