Including Functions.php

Time Before: 0.00044 seconds
Time After: 0.00050 seconds
Time Taken: 0.00005 seconds

Memory Before: 425.148 KB
Memory After: 492.102 KB
Memory Used: 66.953 KB

Connect to Database on Server:

Time Before: 0.00053 seconds
Time After: 0.00110 seconds
Time Taken: 0.00056 seconds

Memory Before: 492.078 KB
Memory After: 492.969 KB
Memory Used: 0.891 KB

SQL Query
SET @@sql_mode = ''

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

Memory Before: 492.992 KB
Memory After: 493.047 KB
Memory Used: 0.055 KB

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

Time Before: 0.00195 seconds
Time After: 0.00255 seconds
Time Taken: 0.00060 seconds

Memory Before: 494.938 KB
Memory After: 728.648 KB
Memory Used: 233.711 KB

Time Before: 0.00146 seconds
Time After: 0.01472 seconds
Time Taken: 0.01326 seconds

Memory Before: 492.813 KB
Memory After: 1,073.773 KB
Memory Used: 580.961 KB

Session Handling
SQL Query
FROM session
WHERE userid = 0
	AND host = ''
	AND idhash = 'ba7b142566bb0e254094c7d5ef1aa653'
1SIMPLEsession refguest_lookup,user_activityguest_lookup55const,const,const1100.00 

Time Before: 0.01595 seconds
Time After: 0.01623 seconds
Time Taken: 0.00028 seconds

Memory Before: 1,233.406 KB
Memory After: 1,250.172 KB
Memory Used: 16.766 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_activitystream AS phrasegroup_activitystream,
			phrasegroup_user AS phrasegroup_user,
			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
1SIMPLElanguage systemPRIMARY   1100.00 

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

Memory Before: 1,241.406 KB
Memory After: 1,346.234 KB
Memory Used: 104.828 KB

Time Before: 0.01519 seconds
Time After: 0.01740 seconds
Time Taken: 0.00221 seconds

Memory Before: 1,231.484 KB
Memory After: 1,335.211 KB
Memory Used: 103.727 KB

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

Time Before: 0.09343 seconds
Time After: 0.09366 seconds
Time Taken: 0.00023 seconds

Memory Before: 1,619.461 KB
Memory After: 1,635.648 KB
Memory Used: 16.188 KB

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

Time Before: 0.09431 seconds
Time After: 0.09466 seconds
Time Taken: 0.00035 seconds

Memory Before: 1,612.641 KB
Memory After: 1,741.281 KB
Memory Used: 128.641 KB

End call of global.php: 0.099230051040649
SQL Query
SELECT stream.*, type.section, type.type
FROM activitystream AS stream
LEFT JOIN activitystreamtype AS type ON (stream.typeid = type.typeid)
WHERE stream.dateline <> 0 AND stream.dateline <= 1521430328
ORDER BY score DESC, dateline DESC
LIMIT 0, 30
1SIMPLEstream ALLdateline   66797.45Using where; Using filesort

Time Before: 0.10045 seconds
Time After: 0.10134 seconds
Time Taken: 0.00089 seconds

Memory Before: 2,139.820 KB
Memory After: 2,165.375 KB
Memory Used: 25.555 KB

SQL Query
	t.threadid, t.title, t.forumid, t.pollid,, t.views, t.visible, t.postuserid, t.postuserid AS userid, t.replycount,
	t.postusername, t.prefixid, fp.pagetext
FROM thread AS t
INNER JOIN post AS fp ON (t.firstpostid = fp.postid)
	t.threadid IN (368581,368599,368701,368583,368681,368708,368691,368584,368663,368594,368614,368617,368687,368633,368721,368726,368604,368640,368664,368634,368683,368711,368650,368696,368742,368598,368670,368665,368734,368654)
	t.visible <> 2
1SIMPLEt rangePRIMARYPRIMARY4 3090.00Using where
1SIMPLEfp eq_refPRIMARYPRIMARY4webdev.t.firstpostid1100.00 

Time Before: 0.10213 seconds
Time After: 0.10289 seconds
Time Taken: 0.00076 seconds

Memory Before: 2,223.938 KB
Memory After: 2,279.711 KB
Memory Used: 55.773 KB

SQL Query
	, av.avatarpath, NOT ISNULL(cu.userid) AS hascustomavatar,
		cu.dateline AS avatardateline, cu.width AS avwidth, cu.height AS avheight, cu.height_thumb AS avheight_thumb,
		cu.width_thumb AS avwidth_thumb, NOT ISNULL(cu.filedata_thumb) AS filedata_thumb
FROM user AS u

	LEFT JOIN avatar AS av ON(av.avatarid = u.avatarid)
	LEFT JOIN customavatar AS cu ON(cu.userid = u.userid)
WHERE u.userid IN (305831,304115,230451,305369,305860,80845,290305,305904,115230,305932,168965,305945,305963,305966,299839,305994,305995,306000,306006,45844,295317,293005,302193,306032,303877,306047,306075,306080,306085,306097)
1SIMPLEav systemPRIMARY   00.00const row not found
1SIMPLEu rangePRIMARYPRIMARY4 30100.00Using where
1SIMPLEcu eq_refPRIMARYPRIMARY4webdev.u.userid1100.00 

Time Before: 0.10382 seconds
Time After: 0.10478 seconds
Time Taken: 0.00097 seconds

Memory Before: 2,324.148 KB
Memory After: 2,381.516 KB
Memory Used: 57.367 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (23665,23649,23651,23653,23655,23657,23667,23659,23661,23663,23669,23671,23673,23675,23677,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)
1SIMPLEtemplate rangePRIMARYPRIMARY4 56100.00Using index condition

Time Before: 0.11256 seconds
Time After: 0.11327 seconds
Time Taken: 0.00071 seconds

Memory Before: 2,759.945 KB
Memory After: 2,888.172 KB
Memory Used: 128.227 KB

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

Time Before: 0.11425 seconds
Time After: 0.11441 seconds
Time Taken: 0.00016 seconds

Memory Before: 2,893.961 KB
Memory After: 2,910.242 KB
Memory Used: 16.281 KB

SQL Query
UPDATE session
SET lastactivity = 1521430328, location = '/forum/activity.php?sortby=popular&show=all&time=anytime&explain=1', inforum = 0, inthread = 0, badlocation = 0
WHERE sessionhash = '09703715c866fb46d7055af1dd338b55'

Time Before: 0.14929 seconds
Time After: 0.15109 seconds
Time Taken: 0.00180 seconds

Memory Before: 3,088.742 KB
Memory After: 3,088.492 KB
Memory Used: -0.250 KB

Page generated in 0.14868807792664 seconds with 12 queries, spending 0.007819652557373 doing MySQL queries and 0.14086842536926 doing PHP things.
Shutdown Queries: