Including Functions.php

Time Before: 0.00499 seconds
Time After: 0.01322 seconds
Time Taken: 0.00823 seconds

Memory Before: 1,269.297 KB
Memory After: 2,013.422 KB
Memory Used: 744.125 KB

Connect to Database on Server: localhost

Time Before: 0.01331 seconds
Time After: 0.01364 seconds
Time Taken: 0.00032 seconds

Memory Before: 2,013.406 KB
Memory After: 2,142.273 KB
Memory Used: 128.867 KB

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

Time Before: 0.01425 seconds
Time After: 0.01437 seconds
Time Taken: 0.00012 seconds

Memory Before: 2,145.813 KB
Memory After: 2,146.758 KB
Memory Used: 0.945 KB

Time Before: 0.01374 seconds
Time After: 0.01562 seconds
Time Taken: 0.00188 seconds

Memory Before: 2,014.094 KB
Memory After: 2,483.914 KB
Memory Used: 469.820 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '54.158.208.189'
	AND idhash = '5c4a00303a937b80da6012cdcd519f1e'
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsession ALL    2290.44Using where

Time Before: 0.01672 seconds
Time After: 0.01693 seconds
Time Taken: 0.00022 seconds

Memory Before: 2,645.508 KB
Memory After: 2,646.086 KB
Memory Used: 0.578 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_user AS phrasegroup_user,
			phrasegroup_search AS phrasegroup_search,
			phrasegroup_cprofilefield AS phrasegroup_cprofilefield,
			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.01757 seconds
Time After: 0.01767 seconds
Time Taken: 0.00011 seconds

Memory Before: 2,656.672 KB
Memory After: 2,656.680 KB
Memory Used: 0.008 KB

Time Before: 0.01622 seconds
Time After: 0.01779 seconds
Time Taken: 0.00156 seconds

Memory Before: 2,512.680 KB
Memory After: 2,628.508 KB
Memory Used: 115.828 KB

SQL Query
SELECT *
FROM style
WHERE (styleid = 45 AND userselect = 1)
	OR styleid = 45
ORDER BY styleid ASC
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEstyle constPRIMARYPRIMARY2const1100.00 

Time Before: 0.02008 seconds
Time After: 0.02016 seconds
Time Taken: 0.00008 seconds

Memory Before: 2,773.992 KB
Memory After: 2,774.578 KB
Memory Used: 0.586 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (2188,2189,2192,2190,2191,2141,2142,2144,2151,2150,2111,2323,3538,3542,3540,2022,2021,2023,2018,2017,2294,3443,2246,2247,2248,2514,2517,2526,2267,2268,2269,2270,2468,2531,2530,2532,2535)
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEtemplate rangePRIMARYPRIMARY4 37100.00Using index condition

Time Before: 0.02105 seconds
Time After: 0.02115 seconds
Time Taken: 0.00009 seconds

Memory Before: 2,953.453 KB
Memory After: 2,954.656 KB
Memory Used: 1.203 KB

End call of global.php: 0.022486925125122
SQL Query
SELECT profilefieldid, type, data, optional, memberlist, searchable
FROM profilefield
WHERE form = 0 	AND hidden = 0
ORDER BY displayorder
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEprofilefield ALL    714.29Using where; Using filesort

Time Before: 0.03323 seconds
Time After: 0.03335 seconds
Time Taken: 0.00012 seconds

Memory Before: 3,729.367 KB
Memory After: 3,730.148 KB
Memory Used: 0.781 KB

SQL Query
SELECT COUNT(*) AS users
FROM user AS user


WHERE 1=1 AND username LIKE("G%")
	AND (user.usergroupid IN (-1,7,5,9,6,2,1))
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEuser rangeusergroupid,usernameusername102 4479.47Using index condition; Using where

Time Before: 0.03417 seconds
Time After: 0.03474 seconds
Time Taken: 0.00057 seconds

Memory Before: 3,776.477 KB
Memory After: 3,776.961 KB
Memory Used: 0.484 KB

SQL Query
SELECT user.*,usertextfield.*,userfield.*, user.userid, options,
	IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid

,avatar.avatarpath,NOT ISNULL(customavatar.userid) AS hascustomavatar,customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight

 , IF((options & 512 AND user.userid <> 0), 0, lastactivity) AS lastvisittime 



FROM user AS user
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid=user.userid)

LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)



WHERE 1=1 AND username LIKE("G%")
	AND (user.usergroupid IN (-1,7,5,9,6,2,1))
	
ORDER BY user.username asc 
LIMIT 0, 30
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEavatar systemPRIMARY   00.00const row not found
1SIMPLEuser rangeusergroupid,usernameusername102 4479.47Using index condition; Using where
1SIMPLEusertextfield eq_refPRIMARYPRIMARY4sambees_sammourco.user.userid1100.00 
1SIMPLEuserfield eq_refPRIMARYPRIMARY4sambees_sammourco.user.userid1100.00 
1SIMPLEcustomavatar eq_refPRIMARYPRIMARY4sambees_sammourco.user.userid1100.00 

Time Before: 0.03690 seconds
Time After: 0.03842 seconds
Time Taken: 0.00152 seconds

Memory Before: 3,789.422 KB
Memory After: 3,812.586 KB
Memory Used: 23.164 KB

SQL Query
UPDATE session
SET lastactivity = 1540152957, location = '/vb/memberlist.php?ltr=G&pp=30&sort=username&order=asc&explain=1', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = '459e3f956e5500d23d9f1ceab9c79128'

Time Before: 0.05282 seconds
Time After: 0.05299 seconds
Time Taken: 0.00017 seconds

Memory Before: 4,252.453 KB
Memory After: 4,252.586 KB
Memory Used: 0.133 KB

Page generated in 0.052365064620972 seconds with 9 queries, spending 0.0033197402954102 doing MySQL queries and 0.049045324325562 doing PHP things.
Shutdown Queries:
DISABLED