Including Functions.php

Time Before: 0.00478 seconds
Time After: 0.01272 seconds
Time Taken: 0.00794 seconds

Memory Before: 2,180.039 KB
Memory After: 2,924.227 KB
Memory Used: 744.188 KB

Connect to Database on Server: localhost

Time Before: 0.01280 seconds
Time After: 0.01314 seconds
Time Taken: 0.00034 seconds

Memory Before: 2,924.211 KB
Memory After: 2,925.164 KB
Memory Used: 0.953 KB

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

Time Before: 0.01371 seconds
Time After: 0.01432 seconds
Time Taken: 0.00062 seconds

Memory Before: 2,928.969 KB
Memory After: 2,929.969 KB
Memory Used: 1.000 KB

Time Before: 0.01326 seconds
Time After: 0.01568 seconds
Time Taken: 0.00243 seconds

Memory Before: 2,924.898 KB
Memory After: 3,466.266 KB
Memory Used: 541.367 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '54.224.118.247'
	AND idhash = 'c91fee56b36ac6b9bbc06a54b6b636cb'
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsession ALL    1020.98Using where

Time Before: 0.01665 seconds
Time After: 0.01689 seconds
Time Taken: 0.00024 seconds

Memory Before: 3,499.820 KB
Memory After: 3,500.398 KB
Memory Used: 0.578 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_socialgroups AS phrasegroup_socialgroups,
			phrasegroup_search AS phrasegroup_search,
			phrasegroup_user AS phrasegroup_user,
			phrasegroup_posting AS phrasegroup_posting,
			phrasegroup_album AS phrasegroup_album,
			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.01750 seconds
Time After: 0.01808 seconds
Time Taken: 0.00058 seconds

Memory Before: 3,511.195 KB
Memory After: 3,511.133 KB
Memory Used: -0.063 KB

Time Before: 0.01620 seconds
Time After: 0.01825 seconds
Time Taken: 0.00206 seconds

Memory Before: 3,494.984 KB
Memory After: 3,639.422 KB
Memory Used: 144.438 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.02440 seconds
Time After: 0.02457 seconds
Time Taken: 0.00016 seconds

Memory Before: 3,843.109 KB
Memory After: 3,843.695 KB
Memory Used: 0.586 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (2181,2382,2087,2086,2088,2089,2111,2354,2400,2373,2375,2378,2377,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 38100.00Using index condition

Time Before: 0.02557 seconds
Time After: 0.02636 seconds
Time Taken: 0.00079 seconds

Memory Before: 4,023.391 KB
Memory After: 4,024.656 KB
Memory Used: 1.266 KB

End call of global.php: 0.027765989303589
SQL Query
SELECT socialgroup.*,
	user.username AS creatorusername,
	sgc.title AS categoryname
	
	, socialgroupicon.dateline AS icondateline, socialgroupicon.width AS iconwidth, socialgroupicon.height AS iconheight, socialgroupicon.thumbnail_width AS iconthumb_width, socialgroupicon.thumbnail_height AS iconthumb_height
FROM socialgroup AS socialgroup
LEFT JOIN user AS user ON (socialgroup.creatoruserid = user.userid)
LEFT JOIN socialgroupicon AS socialgroupicon ON
		(socialgroupicon.groupid = socialgroup.groupid)
LEFT JOIN socialgroupcategory AS sgc ON (sgc.socialgroupcategoryid = socialgroup.socialgroupcategoryid)
WHERE socialgroup.groupid = 2
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsocialgroup constPRIMARYPRIMARY4const1100.00 
1SIMPLEuser constPRIMARYPRIMARY4const1100.00 
1SIMPLEsocialgroupicon constPRIMARYPRIMARY4const00.00unique row not found
1SIMPLEsgc systemPRIMARY   1100.00 

Time Before: 0.03917 seconds
Time After: 0.03962 seconds
Time Taken: 0.00045 seconds

Memory Before: 4,961.328 KB
Memory After: 4,961.516 KB
Memory Used: 0.188 KB

SQL Query
SELECT userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
	IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid
	, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb, customavatar.width as avwidth, customavatar.height as avheight, customavatar.filedata_thumb, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight, user.icq AS icq, user.aim AS aim, user.yahoo AS yahoo, user.msn AS msn, user.skype AS skype
FROM socialgroupmember AS socialgroupmember
INNER JOIN user AS user ON (user.userid = socialgroupmember.userid)
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) WHERE socialgroupmember.groupid = 2 AND socialgroupmember.type = 'member'
ORDER BY user.lastactivity DESC
LIMIT 10
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEavatar systemPRIMARY   00.00const row not found
1SIMPLEsocialgroupmember refPRIMARY,groupid,useridPRIMARY4const2233.33Using where; Using temporary; Using filesort
1SIMPLEuser eq_refPRIMARYPRIMARY4sambees_sammourco.socialgroupmember.userid1100.00 
1SIMPLEuserfield eq_refPRIMARYPRIMARY4sambees_sammourco.socialgroupmember.userid1100.00 
1SIMPLEusertextfield eq_refPRIMARYPRIMARY4sambees_sammourco.socialgroupmember.userid1100.00 
1SIMPLEcustomavatar eq_refPRIMARYPRIMARY4sambees_sammourco.socialgroupmember.userid1100.00 
1SIMPLEcustomprofilepic eq_refPRIMARYPRIMARY4sambees_sammourco.socialgroupmember.userid1100.00 

Time Before: 0.05431 seconds
Time After: 0.05676 seconds
Time Taken: 0.00245 seconds

Memory Before: 5,028.508 KB
Memory After: 5,036.289 KB
Memory Used: 7.781 KB

SQL Query
SELECT picture.pictureid, picture.userid, picture.caption, picture.extension, picture.filesize, picture.idhash,
	picture.thumbnail_filesize, picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height,
	socialgrouppicture.dateline, user.username
	
FROM socialgrouppicture AS socialgrouppicture
INNER JOIN picture AS picture ON (picture.pictureid = socialgrouppicture.pictureid)
INNER JOIN socialgroupmember AS socialgroupmember ON
	(socialgroupmember.userid = picture.userid AND socialgroupmember.groupid = 2 AND socialgroupmember.type = 'member')
LEFT JOIN user AS user ON (user.userid = picture.userid)

WHERE socialgrouppicture.groupid = 2
	
ORDER BY socialgrouppicture.dateline DESC
LIMIT 5
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsocialgrouppicture refPRIMARY,groupid,pictureidgroupid4const4100.00Using where
1SIMPLEpicture eq_refPRIMARY,useridPRIMARY4sambees_sammourco.socialgrouppicture.pictureid1100.00 
1SIMPLEsocialgroupmember eq_refPRIMARY,groupid,useridPRIMARY8const,sambees_sammourco.picture.userid133.33Using where
1SIMPLEuser eq_refPRIMARYPRIMARY4sambees_sammourco.picture.userid1100.00 

Time Before: 0.05939 seconds
Time After: 0.06000 seconds
Time Taken: 0.00061 seconds

Memory Before: 5,054.117 KB
Memory After: 5,054.469 KB
Memory Used: 0.352 KB

SQL Query
SELECT d.discussionid, gm.state
	
	
FROM discussion AS d
INNER JOIN groupmessage AS gm ON (gm.gmid = d.firstpostid)


WHERE
	d.groupid = 2



ORDER BY d.lastpost DESC
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEd refgroupidgroupid4const1100.00Using where
1SIMPLEgm eq_refPRIMARYPRIMARY4sambees_sammourco.d.firstpostid1100.00 

Time Before: 0.07855 seconds
Time After: 0.07872 seconds
Time Taken: 0.00017 seconds

Memory Before: 6,181.711 KB
Memory After: 6,182.125 KB
Memory Used: 0.414 KB

SQL Query
SELECT SQL_CALC_FOUND_ROWS
						d.*, gm.*, user.*,
						gm.ipaddress AS itemipaddress, d.lastpost AS lastpost, d.lastpostid AS lastpostid		
					FROM discussion AS d
					INNER JOIN groupmessage AS gm
						ON (gm.gmid = d.firstpostid)
					LEFT JOIN user AS user ON (gm.postuserid = user.userid)	
					
					WHERE 1=1 AND d.groupid = 2 AND d.discussionid IN (0,2) AND (gm.state IN ('visible')) 
						 ORDER BY d.lastpost DESC
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEd refPRIMARY,groupidgroupid4const133.33Using where
1SIMPLEgm eq_refPRIMARYPRIMARY4sambees_sammourco.d.firstpostid133.33Using where
1SIMPLEuser eq_refPRIMARYPRIMARY4sambees_sammourco.gm.postuserid1100.00 

Time Before: 0.07945 seconds
Time After: 0.07973 seconds
Time Taken: 0.00029 seconds

Memory Before: 6,181.930 KB
Memory After: 6,182.883 KB
Memory Used: 0.953 KB

SQL Query
UPDATE session
SET lastactivity = 1540284827, location = '/vb/group.php?groupid=2&explain=1', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = '417d380848e67cfae8ebd76643536c71'

Time Before: 0.08581 seconds
Time After: 0.08594 seconds
Time Taken: 0.00012 seconds

Memory Before: 6,514.305 KB
Memory After: 6,514.484 KB
Memory Used: 0.180 KB

Page generated in 0.085313081741333 seconds with 11 queries, spending 0.0068249702453613 doing MySQL queries and 0.078488111495972 doing PHP things.
Shutdown Queries:
DISABLED