Including Functions.php

Time Before: 0.00044 seconds
Time After: 0.00049 seconds
Time Taken: 0.00006 seconds

Memory Before: 433.867 KB
Memory After: 500.820 KB
Memory Used: 66.953 KB

Connect to Database on Server: 127.0.0.1

Time Before: 0.00053 seconds
Time After: 0.00139 seconds
Time Taken: 0.00087 seconds

Memory Before: 500.797 KB
Memory After: 501.688 KB
Memory Used: 0.891 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.00180 seconds
Time After: 0.00197 seconds
Time Taken: 0.00017 seconds

Memory Before: 501.711 KB
Memory After: 501.766 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.00270 seconds
Time After: 0.00372 seconds
Time Taken: 0.00102 seconds

Memory Before: 503.469 KB
Memory After: 737.367 KB
Memory Used: 233.898 KB

Time Before: 0.00202 seconds
Time After: 0.01521 seconds
Time Taken: 0.01319 seconds

Memory Before: 501.531 KB
Memory After: 1,082.492 KB
Memory Used: 580.961 KB

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

Time Before: 0.01691 seconds
Time After: 0.01728 seconds
Time Taken: 0.00038 seconds

Memory Before: 1,244.516 KB
Memory After: 1,261.281 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.01834 seconds
Time After: 0.01906 seconds
Time Taken: 0.00072 seconds

Memory Before: 1,253.453 KB
Memory After: 1,398.344 KB
Memory Used: 144.891 KB

Time Before: 0.01605 seconds
Time After: 0.01920 seconds
Time Taken: 0.00316 seconds

Memory Before: 1,242.594 KB
Memory After: 1,392.945 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.08345 seconds
Time After: 0.08368 seconds
Time Taken: 0.00023 seconds

Memory Before: 1,697.117 KB
Memory After: 1,713.305 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.08431 seconds
Time After: 0.08471 seconds
Time Taken: 0.00040 seconds

Memory Before: 1,690.922 KB
Memory After: 1,819.563 KB
Memory Used: 128.641 KB

End call of global.php: 0.089498996734619
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.09039 seconds
Time After: 0.09085 seconds
Time Taken: 0.00045 seconds

Memory Before: 2,212.523 KB
Memory After: 2,228.711 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.09309 seconds
Time After: 0.09427 seconds
Time Taken: 0.00118 seconds

Memory Before: 2,364.148 KB
Memory After: 2,641.969 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.09670 seconds
Time After: 0.09687 seconds
Time Taken: 0.00017 seconds

Memory Before: 2,636.016 KB
Memory After: 2,652.297 KB
Memory Used: 16.281 KB

SQL Query
UPDATE session
SET lastactivity = 1519590654, location = '/forum/member.php?305736-swatisri&explain=1', badlocation = 1
WHERE sessionhash = '304e7e79108be7d34dd132fb9b2c344a'

Time Before: 0.10183 seconds
Time After: 0.10296 seconds
Time Taken: 0.00113 seconds

Memory Before: 2,745.930 KB
Memory After: 2,745.805 KB
Memory Used: -0.125 KB

Page generated in 0.10124397277832 seconds with 10 queries, spending 0.0067200660705566 doing MySQL queries and 0.094523906707764 doing PHP things.
Shutdown Queries:
DISABLED