Including Functions.php

Time Before: 0.00058 seconds
Time After: 0.00066 seconds
Time Taken: 0.00008 seconds

Memory Before: 433.219 KB
Memory After: 500.172 KB
Memory Used: 66.953 KB

Connect to Database on Server: 127.0.0.1

Time Before: 0.00071 seconds
Time After: 0.00161 seconds
Time Taken: 0.00090 seconds

Memory Before: 500.148 KB
Memory After: 501.039 KB
Memory Used: 0.891 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00188 seconds
Time After: 0.00204 seconds
Time Taken: 0.00016 seconds

Memory Before: 501.063 KB
Memory After: 501.117 KB
Memory Used: 0.055 KB

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

Time Before: 0.00268 seconds
Time After: 0.00345 seconds
Time Taken: 0.00078 seconds

Memory Before: 502.758 KB
Memory After: 726.156 KB
Memory Used: 223.398 KB

Time Before: 0.00207 seconds
Time After: 0.01283 seconds
Time Taken: 0.01076 seconds

Memory Before: 500.883 KB
Memory After: 1,061.750 KB
Memory Used: 560.867 KB

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

Time Before: 0.01438 seconds
Time After: 0.01473 seconds
Time Taken: 0.00036 seconds

Memory Before: 1,221.359 KB
Memory After: 1,238.125 KB
Memory Used: 16.766 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_messaging AS phrasegroup_messaging,
			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.01567 seconds
Time After: 0.01615 seconds
Time Taken: 0.00048 seconds

Memory Before: 1,229.234 KB
Memory After: 1,289.813 KB
Memory Used: 60.578 KB

Time Before: 0.01345 seconds
Time After: 0.01628 seconds
Time Taken: 0.00283 seconds

Memory Before: 1,219.438 KB
Memory After: 1,275.164 KB
Memory Used: 55.727 KB

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

Time Before: 0.02141 seconds
Time After: 0.02167 seconds
Time Taken: 0.00025 seconds

Memory Before: 1,466.828 KB
Memory After: 1,483.016 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.02231 seconds
Time After: 0.02279 seconds
Time Taken: 0.00047 seconds

Memory Before: 1,460.008 KB
Memory After: 1,588.648 KB
Memory Used: 128.641 KB

End call of global.php: 0.028632164001465
SQL Query
SELECT title, template
FROM template
WHERE templateid IN (24791,24915,24825,24883,24239,0,23975,16601,25469,25468,24891,14189,14188,14190,14185,14184,14951,14953,14949,14947,14193,14194,14961,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 47100.00Using index condition

Time Before: 0.03120 seconds
Time After: 0.03202 seconds
Time Taken: 0.00082 seconds

Memory Before: 2,075.438 KB
Memory After: 2,173.742 KB
Memory Used: 98.305 KB

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

Time Before: 0.03321 seconds
Time After: 0.03341 seconds
Time Taken: 0.00021 seconds

Memory Before: 2,179.789 KB
Memory After: 2,196.070 KB
Memory Used: 16.281 KB

SQL Query
SELECT hvquestion.questionid, COUNT(*) AS answers
FROM hvquestion AS hvquestion
LEFT JOIN hvanswer AS hvanswer
	ON (hvquestion.questionid = hvanswer.questionid)
WHERE hvanswer.answerid IS NOT NULL
	OR hvquestion.regex <> ''
GROUP BY hvquestion.questionid
ORDER BY RAND()
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhvquestion ALLPRIMARY   3100.00Using temporary; Using filesort
1SIMPLEhvanswer ALLquestionid   5100.00Using where; Using join buffer (Block Nested Loop)

Time Before: 0.03619 seconds
Time After: 0.03660 seconds
Time Taken: 0.00041 seconds

Memory Before: 2,204.203 KB
Memory After: 2,220.750 KB
Memory Used: 16.547 KB

SQL Query
INSERT INTO humanverify
	(hash, answer, dateline)
VALUES
	('080df408b5cb0d9838371726a4d0c15d', '17', 1519518565)

Time Before: 0.03697 seconds
Time After: 0.03744 seconds
Time Taken: 0.00048 seconds

Memory Before: 2,203.664 KB
Memory After: 2,203.602 KB
Memory Used: -0.063 KB

SQL Query
SELECT text, languageid, special
FROM phrase AS phrase
LEFT JOIN phrasetype USING (fieldname)
WHERE phrase.fieldname = 'hvquestion'
	AND varname = 'question17'
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEphrase refname_lang_typename_lang_type252const110.00Using index condition
1SIMPLEphrasetype constPRIMARYPRIMARY22const1100.00 

Time Before: 0.03795 seconds
Time After: 0.03829 seconds
Time Taken: 0.00035 seconds

Memory Before: 2,204.383 KB
Memory After: 2,220.602 KB
Memory Used: 16.219 KB

SQL Query
UPDATE session
SET lastactivity = 1519518565, location = '/forum/sendmessage.php?explain=1', badlocation = 0
WHERE sessionhash = '6cf8629be88d83041ec2b949211d4664'

Time Before: 0.03999 seconds
Time After: 0.04188 seconds
Time Taken: 0.00189 seconds

Memory Before: 2,305.852 KB
Memory After: 2,305.727 KB
Memory Used: -0.125 KB

Page generated in 0.039659976959229 seconds with 12 queries, spending 0.007561206817627 doing MySQL queries and 0.032098770141602 doing PHP things.
Shutdown Queries:
DISABLED