Including Functions.php

Time Before: 0.00039 seconds
Time After: 0.00046 seconds
Time Taken: 0.00007 seconds

Memory Before: 441.445 KB
Memory After: 508.398 KB
Memory Used: 66.953 KB

Connect to Database on Server: 127.0.0.1

Time Before: 0.00050 seconds
Time After: 0.00117 seconds
Time Taken: 0.00066 seconds

Memory Before: 508.375 KB
Memory After: 509.266 KB
Memory Used: 0.891 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00144 seconds
Time After: 0.00156 seconds
Time Taken: 0.00012 seconds

Memory Before: 509.289 KB
Memory After: 509.344 KB
Memory Used: 0.055 KB

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

Time Before: 0.00225 seconds
Time After: 0.00327 seconds
Time Taken: 0.00102 seconds

Memory Before: 511.234 KB
Memory After: 745.164 KB
Memory Used: 233.930 KB

Time Before: 0.00158 seconds
Time After: 0.01109 seconds
Time Taken: 0.00951 seconds

Memory Before: 509.109 KB
Memory After: 1,090.188 KB
Memory Used: 581.078 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '54.167.29.208'
	AND idhash = '0dff5f3234f2fcdd209de9a645a0d78a'
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsession refguest_lookup,user_activityguest_lookup55const,const,const1100.00 

Time Before: 0.01236 seconds
Time After: 0.01274 seconds
Time Taken: 0.00038 seconds

Memory Before: 1,252.875 KB
Memory After: 1,269.641 KB
Memory Used: 16.766 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_posting AS phrasegroup_posting,
			phrasegroup_postbit AS phrasegroup_postbit,
			phrasegroup_showthread AS phrasegroup_showthread,
			phrasegroup_inlinemod AS phrasegroup_inlinemod,
			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_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLElanguage systemPRIMARY   1100.00 

Time Before: 0.01367 seconds
Time After: 0.01410 seconds
Time Taken: 0.00043 seconds

Memory Before: 1,261.125 KB
Memory After: 1,345.703 KB
Memory Used: 84.578 KB

Time Before: 0.01163 seconds
Time After: 0.01422 seconds
Time Taken: 0.00259 seconds

Memory Before: 1,249.102 KB
Memory After: 1,333.180 KB
Memory Used: 84.078 KB

SQL Query
SELECT COUNT(*) AS count FROM user WHERE usergroupid = 4
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEuser refusergroupidusergroupid2const2100.00Using index

Time Before: 0.09365 seconds
Time After: 0.09600 seconds
Time Taken: 0.00235 seconds

Memory Before: 1,608.344 KB
Memory After: 1,624.531 KB
Memory Used: 16.188 KB

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

Time Before: 0.09997 seconds
Time After: 0.10146 seconds
Time Taken: 0.00150 seconds

Memory Before: 1,602.148 KB
Memory After: 1,730.789 KB
Memory Used: 128.641 KB

End call of global.php: 0.10910511016846
SQL Query
SELECT text, languageid, special
FROM phrase AS phrase
LEFT JOIN phrasetype USING (fieldname)
WHERE phrase.fieldname = 'error'
	AND varname = 'noid' AND languageid IN (-1, 0, 1)
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEphrase rangename_lang_type,languageidname_lang_type276 3100.00Using index condition
1SIMPLEphrasetype constPRIMARYPRIMARY22const1100.00 

Time Before: 0.11016 seconds
Time After: 0.11082 seconds
Time Taken: 0.00065 seconds

Memory Before: 2,124.961 KB
Memory After: 2,141.180 KB
Memory Used: 16.219 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (14194,14193,14961,14963,24831,23979,23981,23985,23997,23995,21587,24393,24365,24367,24371,24369,24375,24379,24381,24383,24389,23779,23783,23787,23791,23795,16593,24501,24503,24505,24499,24639,24341,24339,24343,24353,24349,24687,23903,23905,24237,23891,23889,23895,23897,23923,23919,16601,25469,25468,24891,14189,14188,14190,14185,14184,14951,14953,14949,14947,24321,21591,16585,24221,24215,24217,16589,24929,0,0,24889,24811,24261,24263,24267,24269,24715,24953,24917,24817,24819,23915,23913,23921,21563,21565)
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEtemplate rangePRIMARYPRIMARY4 85100.00Using index condition

Time Before: 0.11430 seconds
Time After: 0.11544 seconds
Time Taken: 0.00114 seconds

Memory Before: 2,280.633 KB
Memory After: 2,485.195 KB
Memory Used: 204.563 KB

SQL Query
SELECT template
FROM template
WHERE templateid = 16587
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEtemplate constPRIMARYPRIMARY4const1100.00 

Time Before: 0.11695 seconds
Time After: 0.11711 seconds
Time Taken: 0.00016 seconds

Memory Before: 2,478.547 KB
Memory After: 2,494.828 KB
Memory Used: 16.281 KB

SQL Query
UPDATE session
SET lastactivity = 1519051566, location = '/forum/showthread.php?explain=1', inforum = 0, inthread = 0, badlocation = 3
WHERE sessionhash = '27ffce85f9ee7cb8890d7c28022d36ea'

Time Before: 0.12153 seconds
Time After: 0.12293 seconds
Time Taken: 0.00140 seconds

Memory Before: 2,588.273 KB
Memory After: 2,588.148 KB
Memory Used: -0.125 KB

Page generated in 0.12107706069946 seconds with 10 queries, spending 0.0098128318786621 doing MySQL queries and 0.1112642288208 doing PHP things.
Shutdown Queries:
DISABLED