Including Functions.php

Time Before: 0.00043 seconds
Time After: 0.00048 seconds
Time Taken: 0.00005 seconds

Memory Before: 433.898 KB
Memory After: 500.852 KB
Memory Used: 66.953 KB

Connect to Database on Server: 127.0.0.1

Time Before: 0.00051 seconds
Time After: 0.00102 seconds
Time Taken: 0.00051 seconds

Memory Before: 500.828 KB
Memory After: 501.719 KB
Memory Used: 0.891 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00119 seconds
Time After: 0.00130 seconds
Time Taken: 0.00011 seconds

Memory Before: 501.742 KB
Memory After: 501.797 KB
Memory Used: 0.055 KB

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

Time Before: 0.00184 seconds
Time After: 0.00241 seconds
Time Taken: 0.00057 seconds

Memory Before: 503.500 KB
Memory After: 737.398 KB
Memory Used: 233.898 KB

Time Before: 0.00132 seconds
Time After: 0.00896 seconds
Time Taken: 0.00764 seconds

Memory Before: 501.563 KB
Memory After: 1,082.523 KB
Memory Used: 580.961 KB

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

Time Before: 0.01028 seconds
Time After: 0.01062 seconds
Time Taken: 0.00034 seconds

Memory Before: 1,244.555 KB
Memory After: 1,261.320 KB
Memory Used: 16.766 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_wol AS phrasegroup_wol,
			phrasegroup_user AS phrasegroup_user,
			phrasegroup_messaging AS phrasegroup_messaging,
			phrasegroup_cprofilefield AS phrasegroup_cprofilefield,
			phrasegroup_infractionlevel AS phrasegroup_infractionlevel,
			phrasegroup_posting AS phrasegroup_posting,
			phrasegroup_profilefield AS phrasegroup_profilefield,
			phrasegroup_activitystream AS phrasegroup_activitystream,
			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.01166 seconds
Time After: 0.01226 seconds
Time Taken: 0.00060 seconds

Memory Before: 1,253.492 KB
Memory After: 1,398.383 KB
Memory Used: 144.891 KB

Time Before: 0.00950 seconds
Time After: 0.01239 seconds
Time Taken: 0.00289 seconds

Memory Before: 1,242.633 KB
Memory After: 1,392.984 KB
Memory Used: 150.352 KB

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

Time Before: 0.05872 seconds
Time After: 0.05895 seconds
Time Taken: 0.00023 seconds

Memory Before: 1,697.156 KB
Memory After: 1,713.344 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.05973 seconds
Time After: 0.06007 seconds
Time Taken: 0.00034 seconds

Memory Before: 1,690.961 KB
Memory After: 1,819.602 KB
Memory Used: 128.641 KB

End call of global.php: 0.063864946365356
SQL Query
SELECT text, languageid, special
FROM phrase AS phrase
LEFT JOIN phrasetype USING (fieldname)
WHERE phrase.fieldname = 'error'
	AND varname = 'nopermission_loggedout' 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.06497 seconds
Time After: 0.06556 seconds
Time Taken: 0.00059 seconds

Memory Before: 2,212.563 KB
Memory After: 2,228.750 KB
Memory Used: 16.188 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (21595,24057,23979,23981,23985,23997,23995,23649,23651,23653,0,0,23655,0,0,23657,23667,23659,23661,23663,23669,23671,23673,23675,23677,23779,23783,23787,23791,23795,0,23891,23889,23895,23897,23903,23905,24389,24729,24741,24007,24003,24009,24013,24011,24015,24017,24019,24021,24023,24025,24027,24037,24031,24035,24029,24033,24055,24059,24061,24079,24043,24065,24067,24069,24071,24075,24001,24053,24063,24081,24073,24085,24083,24077,24237,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 112100.00Using index condition

Time Before: 0.06778 seconds
Time After: 0.06918 seconds
Time Taken: 0.00140 seconds

Memory Before: 2,364.188 KB
Memory After: 2,642.008 KB
Memory Used: 277.820 KB

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

Time Before: 0.07068 seconds
Time After: 0.07083 seconds
Time Taken: 0.00015 seconds

Memory Before: 2,636.070 KB
Memory After: 2,652.352 KB
Memory Used: 16.281 KB

SQL Query
UPDATE session
SET lastactivity = 1519283521, location = '/forum/member.php?4088-guard_the_jones&explain=1'
WHERE sessionhash = '5483c2687d6edda5eac083f63e1fd80f'

Time Before: 0.07401 seconds
Time After: 0.07599 seconds
Time Taken: 0.00199 seconds

Memory Before: 2,745.977 KB
Memory After: 2,745.852 KB
Memory Used: -0.125 KB

Page generated in 0.073640823364258 seconds with 10 queries, spending 0.0068378448486328 doing MySQL queries and 0.066802978515625 doing PHP things.
Shutdown Queries:
DISABLED