Including Functions.php

Time Before: 0.00040 seconds
Time After: 0.00045 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.00048 seconds
Time After: 0.00107 seconds
Time Taken: 0.00059 seconds

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

SQL Query
SET @@sql_mode = ''

Time Before: 0.00125 seconds
Time After: 0.00136 seconds
Time Taken: 0.00012 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.00138 seconds
Time After: 0.00870 seconds
Time Taken: 0.00732 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.167.29.208'
	AND idhash = '0dff5f3234f2fcdd209de9a645a0d78a'
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsession refguest_lookup,user_activityguest_lookup55const,const,const1100.00 

Time Before: 0.00996 seconds
Time After: 0.01021 seconds
Time Taken: 0.00025 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.01107 seconds
Time After: 0.01158 seconds
Time Taken: 0.00052 seconds

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

Time Before: 0.00931 seconds
Time After: 0.01174 seconds
Time Taken: 0.00243 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.05628 seconds
Time After: 0.05659 seconds
Time Taken: 0.00031 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.05738 seconds
Time After: 0.05792 seconds
Time Taken: 0.00054 seconds

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

End call of global.php: 0.06167197227478
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.06291 seconds
Time After: 0.06367 seconds
Time Taken: 0.00076 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.06602 seconds
Time After: 0.06806 seconds
Time Taken: 0.00204 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.06930 seconds
Time After: 0.06949 seconds
Time Taken: 0.00020 seconds

Memory Before: 2,636.055 KB
Memory After: 2,652.336 KB
Memory Used: 16.281 KB

SQL Query
UPDATE session
SET lastactivity = 1519509945, location = '/forum/member.php?30868-Surendra-nath&explain=1', badlocation = 1
WHERE sessionhash = '2531030a415ade521b5053fb5e07b50d'

Time Before: 0.07254 seconds
Time After: 0.07427 seconds
Time Taken: 0.00173 seconds

Memory Before: 2,746.000 KB
Memory After: 2,745.844 KB
Memory Used: -0.156 KB

Page generated in 0.072181940078735 seconds with 10 queries, spending 0.0076241493225098 doing MySQL queries and 0.064557790756226 doing PHP things.
Shutdown Queries:
DISABLED