Including Functions.php

Time Before: 0.00564 seconds
Time After: 0.01377 seconds
Time Taken: 0.00813 seconds

Memory Before: 1,604.391 KB
Memory After: 2,849.438 KB
Memory Used: 1,245.047 KB

Connect to Database on Server: localhost

Time Before: 0.01388 seconds
Time After: 0.01438 seconds
Time Taken: 0.00051 seconds

Memory Before: 2,849.375 KB
Memory After: 2,850.328 KB
Memory Used: 0.953 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.01456 seconds
Time After: 0.01463 seconds
Time Taken: 0.00007 seconds

Memory Before: 2,851.063 KB
Memory After: 2,851.617 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.01510 seconds
Time After: 0.01668 seconds
Time Taken: 0.00158 seconds

Memory Before: 2,854.945 KB
Memory After: 2,855.828 KB
Memory Used: 0.883 KB

Time Before: 0.01466 seconds
Time After: 0.02156 seconds
Time Taken: 0.00690 seconds

Memory Before: 2,850.867 KB
Memory After: 5,397.148 KB
Memory Used: 2,546.281 KB

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

Time Before: 0.02394 seconds
Time After: 0.02411 seconds
Time Taken: 0.00016 seconds

Memory Before: 5,991.203 KB
Memory After: 5,991.813 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.02491 seconds
Time After: 0.02552 seconds
Time Taken: 0.00061 seconds

Memory Before: 6,004.164 KB
Memory After: 6,004.172 KB
Memory Used: 0.008 KB

Time Before: 0.02337 seconds
Time After: 0.02573 seconds
Time Taken: 0.00236 seconds

Memory Before: 5,983.531 KB
Memory After: 6,151.977 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.03018 seconds
Time After: 0.03044 seconds
Time Taken: 0.00027 seconds

Memory Before: 6,758.539 KB
Memory After: 6,759.133 KB
Memory Used: 0.594 KB

End call of global.php: 0.031750917434692
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 <= 1573550870 AND stream.dateline > 1572946070
ORDER BY dateline DESC
LIMIT 0, 30
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLE         Impossible WHERE noticed after reading const tables

Time Before: 0.03392 seconds
Time After: 0.03406 seconds
Time Taken: 0.00014 seconds

Memory Before: 7,668.242 KB
Memory After: 7,668.547 KB
Memory Used: 0.305 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.03516 seconds
Time After: 0.03573 seconds
Time Taken: 0.00057 seconds

Memory Before: 7,932.328 KB
Memory After: 7,933.750 KB
Memory Used: 1.422 KB

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

Time Before: 0.04120 seconds
Time After: 0.04141 seconds
Time Taken: 0.00021 seconds

Memory Before: 8,354.617 KB
Memory After: 8,354.797 KB
Memory Used: 0.180 KB

Page generated in 0.04079008102417 seconds with 8 queries, spending 0.0041038990020752 doing MySQL queries and 0.036686182022095 doing PHP things.
Shutdown Queries:
DISABLED