Including Functions.php

Time Before: 0.00531 seconds
Time After: 0.01365 seconds
Time Taken: 0.00835 seconds

Memory Before: 2,800.164 KB
Memory After: 3,994.883 KB
Memory Used: 1,194.719 KB

Connect to Database on Server: localhost

Time Before: 0.01371 seconds
Time After: 0.01461 seconds
Time Taken: 0.00089 seconds

Memory Before: 3,994.867 KB
Memory After: 3,995.813 KB
Memory Used: 0.945 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.01475 seconds
Time After: 0.01480 seconds
Time Taken: 0.00006 seconds

Memory Before: 3,996.500 KB
Memory After: 3,997.055 KB
Memory Used: 0.555 KB

Datastore Setup
SQL Query
SELECT *
FROM datastore
WHERE title IN ('smiliecache','bbcodecache','sg_category_cloud','sg_newest_groups','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY52 18Using where

Time Before: 0.01513 seconds
Time After: 0.01724 seconds
Time Taken: 0.00211 seconds

Memory Before: 4,000.313 KB
Memory After: 4,000.578 KB
Memory Used: 0.266 KB

Time Before: 0.01483 seconds
Time After: 0.01981 seconds
Time Taken: 0.00498 seconds

Memory Before: 3,996.305 KB
Memory After: 5,818.102 KB
Memory Used: 1,821.797 KB

SQL Query
SELECT *
FROM datastore
WHERE title IN ('dbtech_vbshout_button','dbtech_vbshout_chatroom','dbtech_vbshout_instance','dbtech_livewall_contenttype')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY52 4Using where

Time Before: 0.02236 seconds
Time After: 0.02248 seconds
Time Taken: 0.00012 seconds

Memory Before: 6,455.469 KB
Memory After: 6,455.883 KB
Memory Used: 0.414 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '54.224.216.155'
	AND idhash = '3f81deb437973b290fee2800d5773bc8'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionrefguest_lookup,user_activityguest_lookup51const,const,const2Using where

Time Before: 0.02291 seconds
Time After: 0.02301 seconds
Time Taken: 0.00010 seconds

Memory Before: 6,510.070 KB
Memory After: 6,510.484 KB
Memory Used: 0.414 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,
			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_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLElanguageconstPRIMARYPRIMARY2const1 

Time Before: 0.02350 seconds
Time After: 0.02396 seconds
Time Taken: 0.00047 seconds

Memory Before: 6,522.313 KB
Memory After: 6,521.992 KB
Memory Used: -0.320 KB

Time Before: 0.02263 seconds
Time After: 0.02416 seconds
Time Taken: 0.00152 seconds

Memory Before: 6,503.195 KB
Memory After: 6,696.820 KB
Memory Used: 193.625 KB

SQL Query
SELECT *
FROM datastore
WHERE title IN ('routes')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastoreconstPRIMARYPRIMARY52const1 

Time Before: 0.02453 seconds
Time After: 0.02460 seconds
Time Taken: 0.00007 seconds

Memory Before: 6,706.109 KB
Memory After: 6,706.617 KB
Memory Used: 0.508 KB

SQL Query
SELECT *
FROM style
WHERE (styleid = 12 AND userselect = 1)
	OR styleid = 12
ORDER BY styleid ASC
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstyleconstPRIMARYPRIMARY2const1 

Time Before: 0.05134 seconds
Time After: 0.05148 seconds
Time Taken: 0.00015 seconds

Memory Before: 9,080.664 KB
Memory After: 9,081.094 KB
Memory Used: 0.430 KB

End call of global.php: 0.053220987319946
SQL Query
SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'vb_types.types'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcachesystemPRIMARY   1 

Time Before: 0.06577 seconds
Time After: 0.06585 seconds
Time Taken: 0.00008 seconds

Memory Before: 11,410.148 KB
Memory After: 11,410.617 KB
Memory Used: 0.469 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (6300,5575,5597,5598,5612,6324,5776,5717,5787,2029,2028,2030,2020,2019,2026,5081,5088,2024,2033,2034,5068,5473,5769,6286,6287,5420,5421,5422,5785,0,0,5748,5750,5443,5444,5446,5447,5670,5712,5711,5761,5713,5270,5269,5273,3059,3639,3701,3702,3703,6103,6098,6112,6111,6113,6105,5260,6107,6106,6050,6049,6051,0,6328)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 62Using where

Time Before: 0.06773 seconds
Time After: 0.06926 seconds
Time Taken: 0.00152 seconds

Memory Before: 11,683.008 KB
Memory After: 11,683.203 KB
Memory Used: 0.195 KB

SQL Query
SELECT
					socialgroup.*, socialgroup.dateline AS createdate, sgc.title AS categoryname, sgc.socialgroupcategoryid AS categoryid,
					socialgroup.groupid, socialgroup.name, socialgroup.description, socialgroup.dateline, sgicon.dateline AS icondateline,
					socialgroupmember.type AS membertype, socialgroupmember.dateline AS joindate,
					sgicon.thumbnail_width AS iconthumb_width, sgicon.thumbnail_height AS iconthumb_height
				
				FROM socialgroup AS socialgroup
				LEFT JOIN socialgroupmember AS socialgroupmember
					ON (socialgroup.groupid = socialgroupmember.groupid AND socialgroupmember.userid = 0)
				LEFT JOIN socialgroupicon AS sgicon ON (sgicon.groupid = socialgroup.groupid)
				INNER JOIN socialgroupcategory AS sgc ON (sgc.socialgroupcategoryid = socialgroup.socialgroupcategoryid)
				
				
				ORDER BY socialgroup.dateline DESC
				LIMIT 0, 15
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsocialgroupALLsocialgroupcategoryid   56Using filesort
1SIMPLEsocialgroupmembereq_refPRIMARY,groupid,useridPRIMARY8douglasr_bleachforuns.socialgroup.groupid,const1 
1SIMPLEsgceq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroup.socialgroupcategoryid1 
1SIMPLEsgiconeq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroup.groupid1 

Time Before: 0.09609 seconds
Time After: 0.10286 seconds
Time Taken: 0.00677 seconds

Memory Before: 12,074.570 KB
Memory After: 12,074.273 KB
Memory Used: -0.297 KB

SQL Query
REPLACE INTO datastore
	(title, data, unserialize)
VALUES
	('sg_newest_groups', 'a:15:{i:0;a:31:{s:7:\"groupid\";s:2:\"83\";s:4:\"name\";s:20:\"ICHIGO E SEUS AMIGOS\";s:11:\"description\";s:70:\"ENTRE QUEM QUISER MAIS TEM UMA RESTRIÇÃO SEJA AMIGO DO ICHIGO NO ANIMI\";s:13:\"creatoruserid\";s:5:\"39837\";s:8:\"dateline\";s:10:\"1513885431\";s:7:\"members\";s:1:\"1\";s:12:\"picturecount\";s:1:\"0\";s:8:\"lastpost\";s:10:\"1513885431\";s:10:\"lastposter\";s:0:\"\";s:12:\"lastposterid\";s:1:\"0\";s:8:\"lastgmid\";s:1:\"0\";s:7:\"visible\";s:1:\"0\";s:7:\"deleted\";s:1:\"0\";s:10:\"moderation\";s:1:\"0\";s:4:\"type\";s:6:\"public\";s:16:\"moderatedmembers\";s:1:\"0\";s:7:\"options\";s:2:\"12\";s:16:\"lastdiscussionid\";s:1:\"0\";s:11:\"discussions\";s:1:\"0\";s:14:\"lastdiscussion\";s:0:\"\";s:10:\"lastupdate\";s:10:\"1513885431\";s:13:\"transferowner\";s:1:\"0\";s:21:\"socialgroupcategoryid\";s:1:\"2\";s:10:\"createdate\";s:10:\"1513885431\";s:12:\"categoryname\";s:6:\"Bleach\";s:10:\"categoryid\";s:1:\"2\";s:12:\"icondateline\";s:10:\"1513885706\";s:10:\"membertype\";N;s:8:\"joindate\";N;s:15:\"iconthumb_width\";s:2:\"80\";s:16:\"iconthumb_height\";s:2:\"80\";}i:1;a:31:{s:7:\"groupid\";s:2:\"82\";s:4:\"name\";s:15:\"Getsuga Tenshou\";s:11:\"description\";s:19:\"Novo Porem Especial\";s:13:\"creatoruserid\";s:5:\"37852\";s:8:\"dateline\";s:10:\"1425840452\";s:7:\"members\";s:1:\"2\";s:12:\"picturecount\";s:1:\"0\";s:8:\"lastpost\";s:10:\"1425840452\";s:10:\"lastposter\";s:0:\"\";s:12:\"lastposterid\";s:1:\"0\";s:8:\"lastgmid\";s:1:\"0\";s:7:\"visible\";s:1:\"0\";s:7:\"deleted\";s:1:\"0\";s:10:\"moderation\";s:1:\"0\";s:4:\"type\";s:6:\"public\";s:16:\"moderatedmembers\";s:1:\"0\";s:7:\"options\";s:2:\"12\";s:16:\"lastdiscussionid\";s:1:\"0\";s:11:\"discussions\";s:1:\"0\";s:14:\"lastdiscussion\";s:0:\"\";s:10:\"lastupdate\";s:10:\"1437486273\";s:13:\"transferowner\";s:1:\"0\";s:21:\"socialgroupcategoryid\";s:1:\"2\";s:10:\"createdate\";s:10:\"1425840452\";s:12:\"categoryname\";s:6:\"Bleach\";s:10:\"categoryid\";s:1:\"2\";s:12:\"icondateline\";N;s:10:\"membertype\";N;s:8:\"joindate\";N;s:15:\"iconthumb_width\";N;s:16:\"iconthumb_height\";N;}i:2;a:31:{s:7:\"groupid\";s:2:\"81\";s:4:\"name\";s:6:\"bankai\";s:11:\"description\";s:148:\"Grupo dedicado a segunda forma das zanpakutous dos shinigamis, a mais poderoza forma, que da a maioria dos shinigamis o poder de se tornar capitães.\";s:13:\"creatoruserid\";s:5:\"34605\";s:8:\"dateline\";s:10:\"1364995123\";s:7:\"members\";s:2:\"10\";s:12:\"picturecount\";s:1:\"1\";s:8:\"lastpost\";s:10:\"1514295594\";s:10:\"lastposter\";s:4:\"Noah\";s:12:\"lastposterid\";s:5:\"30538\";s:8:\"lastgmid\";s:4:\"1358\";s:7:\"visible\";s:1:\"2\";s:7:\"deleted\";s:1:\"0\";s:10:\"moderation\";s:1:\"0\";s:4:\"type\";s:6:\"public\";s:16:\"moderatedmembers\";s:1:\"0\";s:7:\"options\";s:2:\"12\";s:16:\"lastdiscussionid\";s:3:\"284\";s:11:\"discussions\";s:1:\"1\";s:14:\"lastdiscussion\";s:31:\"Com quem ichigo deveria namorar\";s:10:\"lastupdate\";s:10:\"1514295594\";s:13:\"transferowner\";s:1:\"0\";s:21:\"socialgroupcategoryid\";s:1:\"2\";s:10:\"createdate\";s:10:\"1364995123\";s:12:\"categoryname\";s:6:\"Bleach\";s:10:\"categoryid\";s:1:\"2\";s:12:\"icondateline\";s:10:\"1364995283\";s:10:\"membertype\";N;s:8:\"joindate\";N;s:15:\"iconthumb_width\";s:2:\"80\";s:16:\"iconthumb_height\";s:2:\"62\";}i:3;a:31:{s:7:\"groupid\";s:2:\"80\";s:4:\"name\";s:7:\"amireli\";s:11:\"description\";s:0:\"\";s:13:\"creatoruserid\";s:5:\"30332\";s:8:\"dateline\";s:10:\"1349034197\";s:7:\"members\";s:1:\"1\";s:12:\"picturecount\";s:1:\"0\";s:8:\"lastpost\";s:10:\"1349034197\";s:10:\"lastposter\";s:0:\"\";s:12:\"lastposterid\";s:1:\"0\";s:8:\"lastgmid\";s:1:\"0\";s:7:\"visible\";s:1:\"0\";s:7:\"deleted\";s:1:\"0\";s:10:\"moderation\";s:1:\"0\";s:4:\"type\";s:6:\"public\";s:16:\"moderatedmembers\";s:1:\"0\";s:7:\"options\";s:2:\"12\";s:16:\"lastdiscussionid\";s:1:\"0\";s:11:\"discussions\";s:1:\"0\";s:14:\"lastdiscussion\";s:0:\"\";s:10:\"lastupdate\";s:10:\"1349034197\";s:13:\"transferowner\";s:1:\"0\";s:21:\"socialgroupcategoryid\";s:2:\"29\";s:10:\"createdate\";s:10:\"1349034197\";s:12:\"categoryname\";s:6:\"Outros\";s:10:\"categoryid\";s:2:\"29\";s:12:\"icondateline\";N;s:10:\"membertype\";N;s:8:\"joindate\";N;s:15:\"iconthumb_width\";N;s:16:\"iconthumb_height\";N;}i:4;a:31:{s:7:\"groupid\";s:2:\"79\";s:4:\"name\";s:11:\"IchiRuki FC\";s:11:\"description\";s:274:\"Para quem curte IchiRuki mesmo sabendo que muito provavelmente isto não será explorado no anime ou mangá, mas não consegue deixar de dar um olhar "I see what you did there, Kubo" toda vez que Ichigo e Rukia se encontram no mangá, no anime, nos filmes e nas novels.\";s:13:\"creatoruserid\";s:5:\"21569\";s:8:\"dateline\";s:10:\"1345686424\";s:7:\"members\";s:1:\"8\";s:12:\"picturecount\";s:1:\"0\";s:8:\"lastpost\";s:10:\"1345909532\";s:10:\"lastposter\";s:5:\"Dasts\";s:12:\"lastposterid\";s:2:\"20\";s:8:\"lastgmid\";s:4:\"1350\";s:7:\"visible\";s:1:\"3\";s:7:\"deleted\";s:1:\"0\";s:10:\"moderation\";s:1:\"0\";s:4:\"type\";s:6:\"public\";s:16:\"moderatedmembers\";s:1:\"0\";s:7:\"options\";s:2:\"12\";s:16:\"lastdiscussionid\";s:3:\"283\";s:11:\"discussions\";s:1:\"1\";s:14:\"lastdiscussion\";s:31:\"Seu momento IchiRuki preferido.\";s:10:\"lastupdate\";s:10:\"1429594461\";s:13:\"transferowner\";s:1:\"0\";s:21:\"socialgroupcategoryid\";s:1:\"2\";s:10:\"createdate\";s:10:\"1345686424\";s:12:\"categoryname\";s:6:\"Bleach\";s:10:\"categoryid\";s:1:\"2\";s:12:\"icondateline\";s:10:\"1345686493\";s:10:\"membertype\";N;s:8:\"joindate\";N;s:15:\"iconthumb_width\";s:2:\"80\";s:16:\"iconthumb_height\";s:2:\"49\";}i:5;a:31:{s:7:\"groupid\";s:2:\"78\";s:4:\"name\";s:15:\"Muguruma Kensei\";s:11:\"description\";s:61:\"Para todos aqueles que admiram o atual capitão da 9ª Divisão.\";s:13:\"creatoruserid\";s:5:\"28254\";s:8:\"dateline\";s:10:\"1339640655\";s:7:\"members\";s:1:\"2\";s:12:\"picturecount\";s:1:\"6\";s:8:\"lastpost\";s:10:\"1339640655\";s:10:\"lastposter\";s:0:\"\";s:12:\"lastposterid\";s:1:\"0\";s:8:\"lastgmid\";s:1:\"0\";s:7:\"visible\";s:1:\"0\";s:7:\"deleted\";s:1:\"0\";s:10:\"moderation\";s:1:\"0\";s:4:\"type\";s:6:\"public\";s:16:\"moderatedmembers\";s:1:\"0\";s:7:\"options\";s:2:\"12\";s:16:\"lastdiscussionid\";s:1:\"0\";s:11:\"discussions\";s:1:\"0\";s:14:\"lastdiscussion\";s:0:\"\";s:10:\"lastupdate\";s:10:\"1344030660\";s:13:\"transferowner\";s:1:\"0\";s:21:\"socialgroupcategoryid\";s:1:\"2\";s:10:\"createdate\";s:10:\"1339640655\";s:12:\"categoryname\";s:6:\"Bleach\";s:10:\"categoryid\";s:1:\"2\";s:12:\"icondateline\";s:10:\"1339640894\";s:10:\"membertype\";N;s:8:\"joindate\";N;s:15:\"iconthumb_width\";s:2:\"80\";s:16:\"iconthumb_height\";s:2:\"62\";}i:6;a:31:{s:7:\"groupid\";s:2:\"77\";s:4:\"name\";s:30:\"ichigo getsuga tenshou supremo\";s:11:\"description\";s:141:\"determinado a proteger o mundo de aizen ichigo mesmo sabendo das consequencias ichigo usou seu getsuga tenshou supremo e assim derrotou aizen\";s:13:\"creatoruserid\";s:5:\"25889\";s:8:\"dateline\";s:10:\"1327875618\";s:7:\"members\";s:1:\"1\";s:12:\"picturecount\";s:1:\"0\";s:8:\"lastpost\";s:10:\"1327875618\";s:10:\"lastposter\";s:0:\"\";s:12:\"lastposterid\";s:1:\"0\";s:8:\"lastgmid\";s:1:\"0\";s:7:\"visible\";s:1:\"0\";s:7:\"deleted\";s:1:\"0\";s:10:\"moderation\";s:1:\"0\";s:4:\"type\";s:9:\"moderated\";s:16:\"moderatedmembers\";s:1:\"3\";s:7:\"options\";s:2:\"12\";s:16:\"lastdiscussionid\";s:1:\"0\";s:11:\"discussions\";s:1:\"0\";s:14:\"lastdiscussion\";s:0:\"\";s:10:\"lastupdate\";s:10:\"1431995919\";s:13:\"transferowner\";s:1:\"0\";s:21:\"socialgroupcategoryid\";s:1:\"2\";s:10:\"createdate\";s:10:\"1327875618\";s:12:\"categoryname\";s:6:\"Bleach\";s:10:\"categoryid\";s:1:\"2\";s:12:\"icondateline\";s:10:\"1327875629\";s:10:\"membertype\";N;s:8:\"joindate\";N;s:15:\"iconthumb_width\";s:2:\"80\";s:16:\"iconthumb_height\";s:2:\"45\";}i:7;a:31:{s:7:\"groupid\";s:2:\"76\";s:4:\"name\";s:18:\"ichigo vasto lorde\";s:11:\"description\";s:136:\"para proteger orihime ichigo libetou seu poder hollow assim ele destruiu varios orgons de ulquioria cifer então se tornou um vasto lorde\";s:13:\"creatoruserid\";s:5:\"25889\";s:8:\"dateline\";s:10:\"1327875208\";s:7:\"members\";s:1:\"1\";s:12:\"picturecount\";s:1:\"0\";s:8:\"lastpost\";s:10:\"1327875208\";s:10:\"lastposter\";s:0:\"\";s:12:\"lastposterid\";s:1:\"0\";s:8:\"lastgmid\";s:1:\"0\";s:7:\"visible\";s:1:\"0\";s:7:\"deleted\";s:1:\"0\";s:10:\"moderation\";s:1:\"0\";s:4:\"type\";s:9:\"moderated\";s:16:\"moderatedmembers\";s:1:\"1\";s:7:\"options\";s:2:\"12\";s:16:\"lastdiscussionid\";s:1:\"0\";s:11:\"discussions\";s:1:\"0\";s:14:\"lastdiscussion\";s:0:\"\";s:10:\"lastupdate\";s:10:\"1377120818\";s:13:\"transferowner\";s:1:\"0\";s:21:\"socialgroupcategoryid\";s:1:\"2\";s:10:\"createdate\";s:10:\"1327875208\";s:12:\"categoryname\";s:6:\"Bleach\";s:10:\"categoryid\";s:1:\"2\";s:12:\"icondateline\";s:10:\"1327875296\";s:10:\"membertype\";N;s:8:\"joindate\";N;s:15:\"iconthumb_width\";s:2:\"80\";s:16:\"iconthumb_height\";s:2:\"46\";}i:8;a:31:{s:7:\"groupid\";s:2:\"75\";s:4:\"name\";s:20:\"Kurotsuchi Mayuri FC\";s:11:\"description\";s:131:\"Esse grupo é feito para os fãs do cientista mais louco de todos os animes, e atenção, o Mayuri trata muito bem as membros fêmeas...\";s:13:\"creatoruserid\";s:5:\"26259\";s:8:\"dateline\";s:10:\"1327671035\";s:7:\"members\";s:1:\"1\";s:12:\"picturecount\";s:1:\"4\";s:8:\"lastpost\";s:10:\"1327686619\";s:10:\"lastposter\";s:17:\"Kurotsuchi Mayuri\";s:12:\"lastposterid\";s:5:\"26259\";s:8:\"lastgmid\";s:4:\"1344\";s:7:\"visible\";s:1:\"2\";s:7:\"deleted\";s:1:\"0\";s:10:\"moderation\";s:1:\"0\";s:4:\"type\";s:6:\"public\";s:16:\"moderatedmembers\";s:1:\"0\";s:7:\"options\";s:2:\"12\";s:16:\"lastdiscussionid\";s:3:\"282\";s:11:\"discussions\";s:1:\"2\";s:14:\"lastdiscussion\";s:28:\"A melhor aparição de Mayuri!\";s:10:\"lastupdate\";s:10:\"1327686619\";s:13:\"transferowner\";s:1:\"0\";s:21:\"socialgroupcategoryid\";s:2:\"30\";s:10:\"createdate\";s:10:\"1327671035\";s:12:\"categoryname\";s:6:\"Animes\";s:10:\"categoryid\";s:2:\"30\";s:12:\"icondateline\";s:10:\"1327671652\";s:10:\"membertype\";N;s:8:\"joindate\";N;s:15:\"iconthumb_width\";s:2:\"80\";s:16:\"iconthumb_height\";s:2:\"53\";}i:9;a:31:{s:7:\"groupid\";s:2:\"74\";s:4:\"name\";s:22:\"ichigo hollow completo\";s:11:\"description\";s:86:\"de que gosta quando ichigo se transforma completamente em hollow vai adorar esse grupo\";s:13:\"creatoruserid\";s:5:\"25889\";s:8:\"dateline\";s:10:\"1327539265\";s:7:\"members\";s:1:\"1\";s:12:\"picturecount\";s:1:\"0\";s:8:\"lastpost\";s:10:\"1327539265\";s:10:\"lastposter\";s:0:\"\";s:12:\"lastposterid\";s:1:\"0\";s:8:\"lastgmid\";s:1:\"0\";s:7:\"visible\";s:1:\"0\";s:7:\"deleted\";s:1:\"0\";s:10:\"moderation\";s:1:\"0\";s:4:\"type\";s:9:\"moderated\";s:16:\"moderatedmembers\";s:1:\"1\";s:7:\"options\";s:2:\"12\";s:16:\"lastdiscussionid\";s:1:\"0\";s:11:\"discussions\";s:1:\"0\";s:14:\"lastdiscussion\";s:0:\"\";s:10:\"lastupdate\";s:10:\"1404838912\";s:13:\"transferowner\";s:1:\"0\";s:21:\"socialgroupcategoryid\";s:1:\"2\";s:10:\"createdate\";s:10:\"1327539265\";s:12:\"categoryname\";s:6:\"Bleach\";s:10:\"categoryid\";s:1:\"2\";s:12:\"icondateline\";s:10:\"1327539279\";s:10:\"membertype\";N;s:8:\"joindate\";N;s:15:\"iconthumb_width\";s:2:\"80\";s:16:\"iconthumb_height\";s:2:\"60\";}i:10;a:31:{s:7:\"groupid\";s:2:\"73\";s:4:\"name\";s:21:\"ichigo hollow mascara\";s:11:\"description\";s:100:\"esse grupo é para todos que adoram ichigo quando usa sua mascara esse grupo é para quem adora ichigo\";s:13:\"creatoruserid\";s:5:\"25889\";s:8:\"dateline\";s:10:\"1327536128\";s:7:\"members\";s:1:\"1\";s:12:\"picturecount\";s:1:\"0\";s:8:\"lastpost\";s:10:\"1327536128\";s:10:\"lastposter\";s:0:\"\";s:12:\"lastposterid\";s:1:\"0\";s:8:\"lastgmid\";s:1:\"0\";s:7:\"visible\";s:1:\"0\";s:7:\"deleted\";s:1:\"0\";s:10:\"moderation\";s:1:\"0\";s:4:\"type\";s:9:\"moderated\";s:16:\"moderatedmembers\";s:1:\"0\";s:7:\"options\";s:2:\"12\";s:16:\"lastdiscussionid\";s:1:\"0\";s:11:\"discussions\";s:1:\"0\";s:14:\"lastdiscussion\";s:0:\"\";s:10:\"lastupdate\";s:10:\"1327536128\";s:13:\"transferowner\";s:1:\"0\";s:21:\"socialgroupcategoryid\";s:1:\"2\";s:10:\"createdate\";s:10:\"1327536128\";s:12:\"categoryname\";s:6:\"Bleach\";s:10:\"categoryid\";s:1:\"2\";s:12:\"icondateline\";s:10:\"1327875771\";s:10:\"membertype\";N;s:8:\"joindate\";N;s:15:\"iconthumb_width\";s:2:\"80\";s:16:\"iconthumb_height\";s:2:\"58\";}i:11;a:31:{s:7:\"groupid\";s:2:\"72\";s:4:\"name\";s:19:\"grupo ichigo bankai\";s:11:\"description\";s:110:\"esse grupo foi feito para omenagiar ichigo bankai  eu fiz esse grupo porque adoro o ichigo em sua forma bankai\";s:13:\"creatoruserid\";s:5:\"25889\";s:8:\"dateline\";s:10:\"1327535871\";s:7:\"members\";s:1:\"1\";s:12:\"picturecount\";s:1:\"0\";s:8:\"lastpost\";s:10:\"1327535871\";s:10:\"lastposter\";s:0:\"\";s:12:\"lastposterid\";s:1:\"0\";s:8:\"lastgmid\";s:1:\"0\";s:7:\"visible\";s:1:\"0\";s:7:\"deleted\";s:1:\"0\";s:10:\"moderation\";s:1:\"0\";s:4:\"type\";s:9:\"moderated\";s:16:\"moderatedmembers\";s:1:\"0\";s:7:\"options\";s:2:\"12\";s:16:\"lastdiscussionid\";s:1:\"0\";s:11:\"discussions\";s:1:\"0\";s:14:\"lastdiscussion\";s:0:\"\";s:10:\"lastupdate\";s:10:\"1327535871\";s:13:\"transferowner\";s:1:\"0\";s:21:\"socialgroupcategoryid\";s:1:\"2\";s:10:\"createdate\";s:10:\"1327535871\";s:12:\"categoryname\";s:6:\"Bleach\";s:10:\"categoryid\";s:1:\"2\";s:12:\"icondateline\";s:10:\"1327535919\";s:10:\"membertype\";N;s:8:\"joindate\";N;s:15:\"iconthumb_width\";s:2:\"58\";s:16:\"iconthumb_height\";s:2:\"80\";}i:12;a:31:{s:7:\"groupid\";s:2:\"71\";s:4:\"name\";s:17:\"Yoruichi Shihouin\";s:11:\"description\";s:0:\"\";s:13:\"creatoruserid\";s:5:\"25384\";s:8:\"dateline\";s:10:\"1326461322\";s:7:\"members\";s:1:\"1\";s:12:\"picturecount\";s:1:\"0\";s:8:\"lastpost\";s:10:\"1326461322\";s:10:\"lastposter\";s:0:\"\";s:12:\"lastposterid\";s:1:\"0\";s:8:\"lastgmid\";s:1:\"0\";s:7:\"visible\";s:1:\"0\";s:7:\"deleted\";s:1:\"0\";s:10:\"moderation\";s:1:\"0\";s:4:\"type\";s:6:\"public\";s:16:\"moderatedmembers\";s:1:\"0\";s:7:\"options\";s:2:\"12\";s:16:\"lastdiscussionid\";s:1:\"0\";s:11:\"discussions\";s:1:\"0\";s:14:\"lastdiscussion\";s:0:\"\";s:10:\"lastupdate\";s:10:\"1326461322\";s:13:\"transferowner\";s:1:\"0\";s:21:\"socialgroupcategoryid\";s:1:\"2\";s:10:\"createdate\";s:10:\"1326461322\";s:12:\"categoryname\";s:6:\"Bleach\";s:10:\"categoryid\";s:1:\"2\";s:12:\"icondateline\";s:10:\"1326462570\";s:10:\"membertype\";N;s:8:\"joindate\";N;s:15:\"iconthumb_width\";s:2:\"80\";s:16:\"iconthumb_height\";s:2:\"60\";}i:13;a:31:{s:7:\"groupid\";s:2:\"54\";s:4:\"name\";s:24:\"Fã Clube Ikkaku Madarame\";s:11:\"description\";s:42:\"e pra quem e fã fo Ikkaku e acha ele fodão\";s:13:\"creatoruserid\";s:5:\"25489\";s:8:\"dateline\";s:10:\"1323374580\";s:7:\"members\";s:1:\"4\";s:12:\"picturecount\";s:1:\"0\";s:8:\"lastpost\";s:10:\"1323374682\";s:10:\"lastposter\";s:5:\"Pouvo\";s:12:\"lastposterid\";s:5:\"25489\";s:8:\"lastgmid\";s:4:\"1328\";s:7:\"visible\";s:1:\"1\";s:7:\"deleted\";s:1:\"0\";s:10:\"moderation\";s:1:\"0\";s:4:\"type\";s:6:\"public\";s:16:\"moderatedmembers\";s:1:\"0\";s:7:\"options\";s:2:\"12\";s:16:\"lastdiscussionid\";s:3:\"269\";s:11:\"discussions\";s:1:\"1\";s:14:\"lastdiscussion\";s:30:\"quem e o mais fodão de bleach?\";s:10:\"lastupdate\";s:10:\"1398470454\";s:13:\"transferowner\";s:1:\"0\";s:21:\"socialgroupcategoryid\";s:1:\"2\";s:10:\"createdate\";s:10:\"1323374580\";s:12:\"categoryname\";s:6:\"Bleach\";s:10:\"categoryid\";s:1:\"2\";s:12:\"icondateline\";s:10:\"1323374619\";s:10:\"membertype\";N;s:8:\"joindate\";N;s:15:\"iconthumb_width\";s:2:\"80\";s:16:\"iconthumb_height\";s:2:\"57\";}i:14;a:31:{s:7:\"groupid\";s:2:\"50\";s:4:\"name\";s:11:\"Sou Vaizard\";s:11:\"description\";s:122:\"Para todos aqueles que são/acham/pensam/questionam/refletem... enfim,para todos aqueles que são vaizards, sejam bem vindos\";s:13:\"creatoruserid\";s:5:\"22247\";s:8:\"dateline\";s:10:\"1314053480\";s:7:\"members\";s:1:\"8\";s:12:\"picturecount\";s:1:\"0\";s:8:\"lastpost\";s:10:\"1314053480\";s:10:\"lastposter\";s:0:\"\";s:12:\"lastposterid\";s:1:\"0\";s:8:\"lastgmid\";s:1:\"0\";s:7:\"visible\";s:1:\"0\";s:7:\"deleted\";s:1:\"0\";s:10:\"moderation\";s:1:\"0\";s:4:\"type\";s:6:\"public\";s:16:\"moderatedmembers\";s:1:\"0\";s:7:\"options\";s:2:\"12\";s:16:\"lastdiscussionid\";s:1:\"0\";s:11:\"discussions\";s:1:\"0\";s:14:\"lastdiscussion\";s:0:\"\";s:10:\"lastupdate\";s:10:\"1429594390\";s:13:\"transferowner\";s:1:\"0\";s:21:\"socialgroupcategoryid\";s:1:\"2\";s:10:\"createdate\";s:10:\"1314053480\";s:12:\"categoryname\";s:6:\"Bleach\";s:10:\"categoryid\";s:1:\"2\";s:12:\"icondateline\";s:10:\"1314053890\";s:10:\"membertype\";N;s:8:\"joindate\";N;s:15:\"iconthumb_width\";s:2:\"80\";s:16:\"iconthumb_height\";s:2:\"60\";}}', 1)

Time Before: 0.10315 seconds
Time After: 0.10347 seconds
Time Taken: 0.00032 seconds

Memory Before: 12,230.438 KB
Memory After: 12,214.305 KB
Memory Used: -16.133 KB

SQL Query
SELECT socialgroup.*, socialgroup.dateline AS createdate,
	socialgroupmember.type AS membertype, socialgroupmember.dateline AS joindate,
	groupread.readtime
	,sgicon.dateline AS icondateline, sgicon.thumbnail_width AS iconthumb_width, sgicon.thumbnail_height AS iconthumb_height
	,sgc.title AS categoryname, sgc.socialgroupcategoryid AS categoryid

FROM socialgroup AS socialgroup
LEFT JOIN socialgroupmember AS socialgroupmember
	ON (socialgroup.groupid = socialgroupmember.groupid AND socialgroupmember.userid = 0)
LEFT JOIN groupread AS groupread ON (groupread.groupid = socialgroup.groupid
								AND groupread.userid = 0)
LEFT JOIN socialgroupicon AS sgicon ON sgicon.groupid = socialgroup.groupid
INNER JOIN socialgroupcategory AS sgc ON (sgc.socialgroupcategoryid = socialgroup.socialgroupcategoryid)


ORDER BY socialgroup.lastupdate DESC
LIMIT 0, 10
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEgroupreadsystemPRIMARY   0const row not found
1SIMPLEsocialgroupALLsocialgroupcategoryid   56Using filesort
1SIMPLEsocialgroupmembereq_refPRIMARY,groupid,useridPRIMARY8douglasr_bleachforuns.socialgroup.groupid,const1 
1SIMPLEsgceq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroup.socialgroupcategoryid1 
1SIMPLEsgiconeq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroup.groupid1 

Time Before: 0.11056 seconds
Time After: 0.11106 seconds
Time Taken: 0.00050 seconds

Memory Before: 12,124.891 KB
Memory After: 12,124.578 KB
Memory Used: -0.313 KB

SQL Query
SELECT COUNT(*) AS total
FROM socialgroup AS socialgroup
LEFT JOIN socialgroupicon AS sgicon ON (sgicon.groupid = socialgroup.groupid)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsocialgroupindex PRIMARY4 56Using index
1SIMPLEsgiconeq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroup.groupid1Using index

Time Before: 0.11160 seconds
Time After: 0.11171 seconds
Time Taken: 0.00011 seconds

Memory Before: 12,193.180 KB
Memory After: 12,193.609 KB
Memory Used: 0.430 KB

SQL Query
SELECT socialgroup.*, socialgroup.dateline AS createdate
	,sgicon.dateline AS icondateline, sgicon.thumbnail_width AS iconthumb_width, sgicon.thumbnail_height AS iconthumb_height
	,sgc.title AS categoryname, sgc.socialgroupcategoryid AS categoryid
FROM socialgroup AS socialgroup
LEFT JOIN socialgroupicon AS sgicon ON sgicon.groupid = socialgroup.groupid
INNER JOIN socialgroupcategory AS sgc ON (sgc.socialgroupcategoryid = socialgroup.socialgroupcategoryid)


LIMIT 8, 10
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsocialgroupALLsocialgroupcategoryid   56 
1SIMPLEsgceq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroup.socialgroupcategoryid1 
1SIMPLEsgiconeq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroup.groupid1 

Time Before: 0.11196 seconds
Time After: 0.11250 seconds
Time Taken: 0.00054 seconds

Memory Before: 12,195.023 KB
Memory After: 12,195.102 KB
Memory Used: 0.078 KB

SQL Query
SELECT user.*, socialgroupmember.groupid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM socialgroupmember AS socialgroupmember
LEFT JOIN user AS user ON (socialgroupmember.userid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE socialgroupmember.groupid = 81 AND socialgroupmember.type = 'member'
ORDER BY socialgroupmember.dateline DESC
LIMIT 10
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsocialgroupmemberrefPRIMARY,groupidgroupid5const,const10Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroupmember.userid1 
1SIMPLEavatareq_refPRIMARYPRIMARY2douglasr_bleachforuns.user.avatarid1 
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4douglasr_bleachforuns.user.userid1 

Time Before: 0.11467 seconds
Time After: 0.11507 seconds
Time Taken: 0.00041 seconds

Memory Before: 12,307.680 KB
Memory After: 12,307.641 KB
Memory Used: -0.039 KB

SQL Query
SELECT user.*, socialgroupmember.groupid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM socialgroupmember AS socialgroupmember
LEFT JOIN user AS user ON (socialgroupmember.userid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE socialgroupmember.groupid = 9 AND socialgroupmember.type = 'member'
ORDER BY socialgroupmember.dateline DESC
LIMIT 10
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsocialgroupmemberrefPRIMARY,groupidPRIMARY4const52Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroupmember.userid1 
1SIMPLEavatareq_refPRIMARYPRIMARY2douglasr_bleachforuns.user.avatarid1 
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4douglasr_bleachforuns.user.userid1 

Time Before: 0.11577 seconds
Time After: 0.11621 seconds
Time Taken: 0.00044 seconds

Memory Before: 12,503.188 KB
Memory After: 12,503.141 KB
Memory Used: -0.047 KB

SQL Query
SELECT user.*, socialgroupmember.groupid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM socialgroupmember AS socialgroupmember
LEFT JOIN user AS user ON (socialgroupmember.userid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE socialgroupmember.groupid = 83 AND socialgroupmember.type = 'member'
ORDER BY socialgroupmember.dateline DESC
LIMIT 10
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsocialgroupmemberrefPRIMARY,groupidgroupid5const,const1Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroupmember.userid1 
1SIMPLEavatareq_refPRIMARYPRIMARY2douglasr_bleachforuns.user.avatarid1 
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4douglasr_bleachforuns.user.userid1 

Time Before: 0.11687 seconds
Time After: 0.11712 seconds
Time Taken: 0.00025 seconds

Memory Before: 12,696.164 KB
Memory After: 12,696.125 KB
Memory Used: -0.039 KB

SQL Query
SELECT user.*, socialgroupmember.groupid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM socialgroupmember AS socialgroupmember
LEFT JOIN user AS user ON (socialgroupmember.userid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE socialgroupmember.groupid = 1 AND socialgroupmember.type = 'member'
ORDER BY socialgroupmember.dateline DESC
LIMIT 10
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsocialgroupmemberrefPRIMARY,groupidPRIMARY4const90Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroupmember.userid1 
1SIMPLEavatareq_refPRIMARYPRIMARY2douglasr_bleachforuns.user.avatarid1 
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4douglasr_bleachforuns.user.userid1 

Time Before: 0.11746 seconds
Time After: 0.11794 seconds
Time Taken: 0.00048 seconds

Memory Before: 12,715.500 KB
Memory After: 12,715.453 KB
Memory Used: -0.047 KB

SQL Query
SELECT user.*, socialgroupmember.groupid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM socialgroupmember AS socialgroupmember
LEFT JOIN user AS user ON (socialgroupmember.userid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE socialgroupmember.groupid = 30 AND socialgroupmember.type = 'member'
ORDER BY socialgroupmember.dateline DESC
LIMIT 10
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsocialgroupmemberrefPRIMARY,groupidPRIMARY4const39Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroupmember.userid1 
1SIMPLEavatareq_refPRIMARYPRIMARY2douglasr_bleachforuns.user.avatarid1 
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4douglasr_bleachforuns.user.userid1 

Time Before: 0.11862 seconds
Time After: 0.11905 seconds
Time Taken: 0.00043 seconds

Memory Before: 12,907.703 KB
Memory After: 12,907.656 KB
Memory Used: -0.047 KB

SQL Query
SELECT user.*, socialgroupmember.groupid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM socialgroupmember AS socialgroupmember
LEFT JOIN user AS user ON (socialgroupmember.userid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE socialgroupmember.groupid = 82 AND socialgroupmember.type = 'member'
ORDER BY socialgroupmember.dateline DESC
LIMIT 10
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsocialgroupmemberrefPRIMARY,groupidgroupid5const,const2Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroupmember.userid1 
1SIMPLEavatareq_refPRIMARYPRIMARY2douglasr_bleachforuns.user.avatarid1 
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4douglasr_bleachforuns.user.userid1 

Time Before: 0.11969 seconds
Time After: 0.11996 seconds
Time Taken: 0.00026 seconds

Memory Before: 13,099.820 KB
Memory After: 13,099.781 KB
Memory Used: -0.039 KB

SQL Query
SELECT user.*, socialgroupmember.groupid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM socialgroupmember AS socialgroupmember
LEFT JOIN user AS user ON (socialgroupmember.userid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE socialgroupmember.groupid = 77 AND socialgroupmember.type = 'member'
ORDER BY socialgroupmember.dateline DESC
LIMIT 10
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsocialgroupmemberrefPRIMARY,groupidgroupid5const,const1Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroupmember.userid1 
1SIMPLEavatareq_refPRIMARYPRIMARY2douglasr_bleachforuns.user.avatarid1 
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4douglasr_bleachforuns.user.userid1 

Time Before: 0.12031 seconds
Time After: 0.12057 seconds
Time Taken: 0.00026 seconds

Memory Before: 13,138.430 KB
Memory After: 13,138.391 KB
Memory Used: -0.039 KB

SQL Query
SELECT user.*, socialgroupmember.groupid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM socialgroupmember AS socialgroupmember
LEFT JOIN user AS user ON (socialgroupmember.userid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE socialgroupmember.groupid = 79 AND socialgroupmember.type = 'member'
ORDER BY socialgroupmember.dateline DESC
LIMIT 10
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsocialgroupmemberrefPRIMARY,groupidPRIMARY4const7Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroupmember.userid1 
1SIMPLEavatareq_refPRIMARYPRIMARY2douglasr_bleachforuns.user.avatarid1 
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4douglasr_bleachforuns.user.userid1 

Time Before: 0.12092 seconds
Time After: 0.12128 seconds
Time Taken: 0.00036 seconds

Memory Before: 13,158.609 KB
Memory After: 13,158.563 KB
Memory Used: -0.047 KB

SQL Query
SELECT user.*, socialgroupmember.groupid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM socialgroupmember AS socialgroupmember
LEFT JOIN user AS user ON (socialgroupmember.userid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE socialgroupmember.groupid = 50 AND socialgroupmember.type = 'member'
ORDER BY socialgroupmember.dateline DESC
LIMIT 10
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsocialgroupmemberrefPRIMARY,groupidPRIMARY4const8Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroupmember.userid1 
1SIMPLEavatareq_refPRIMARYPRIMARY2douglasr_bleachforuns.user.avatarid1 
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4douglasr_bleachforuns.user.userid1 

Time Before: 0.12190 seconds
Time After: 0.12222 seconds
Time Taken: 0.00032 seconds

Memory Before: 13,313.523 KB
Memory After: 13,313.477 KB
Memory Used: -0.047 KB

SQL Query
SELECT user.*, socialgroupmember.groupid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM socialgroupmember AS socialgroupmember
LEFT JOIN user AS user ON (socialgroupmember.userid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE socialgroupmember.groupid = 2 AND socialgroupmember.type = 'member'
ORDER BY socialgroupmember.dateline DESC
LIMIT 10
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsocialgroupmemberrefPRIMARY,groupidPRIMARY4const84Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroupmember.userid1 
1SIMPLEavatareq_refPRIMARYPRIMARY2douglasr_bleachforuns.user.avatarid1 
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4douglasr_bleachforuns.user.userid1 

Time Before: 0.12306 seconds
Time After: 0.12347 seconds
Time Taken: 0.00041 seconds

Memory Before: 13,470.445 KB
Memory After: 13,470.398 KB
Memory Used: -0.047 KB

SQL Query
SELECT user.*, socialgroupmember.groupid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM socialgroupmember AS socialgroupmember
LEFT JOIN user AS user ON (socialgroupmember.userid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE socialgroupmember.groupid = 10 AND socialgroupmember.type = 'member'
ORDER BY socialgroupmember.dateline DESC
LIMIT 10
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsocialgroupmemberrefPRIMARY,groupidgroupid5const,const81Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroupmember.userid1 
1SIMPLEavatareq_refPRIMARYPRIMARY2douglasr_bleachforuns.user.avatarid1 
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4douglasr_bleachforuns.user.userid1 

Time Before: 0.12406 seconds
Time After: 0.12446 seconds
Time Taken: 0.00040 seconds

Memory Before: 13,662.859 KB
Memory After: 13,662.820 KB
Memory Used: -0.039 KB

SQL Query
SELECT user.*, socialgroupmember.groupid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM socialgroupmember AS socialgroupmember
LEFT JOIN user AS user ON (socialgroupmember.userid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE socialgroupmember.groupid = 11 AND socialgroupmember.type = 'member'
ORDER BY socialgroupmember.dateline DESC
LIMIT 10
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsocialgroupmemberrefPRIMARY,groupidgroupid5const,const16Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroupmember.userid1 
1SIMPLEavatareq_refPRIMARYPRIMARY2douglasr_bleachforuns.user.avatarid1 
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4douglasr_bleachforuns.user.userid1 

Time Before: 0.12532 seconds
Time After: 0.12580 seconds
Time Taken: 0.00047 seconds

Memory Before: 13,864.727 KB
Memory After: 13,864.688 KB
Memory Used: -0.039 KB

SQL Query
SELECT user.*, socialgroupmember.groupid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM socialgroupmember AS socialgroupmember
LEFT JOIN user AS user ON (socialgroupmember.userid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE socialgroupmember.groupid = 12 AND socialgroupmember.type = 'member'
ORDER BY socialgroupmember.dateline DESC
LIMIT 10
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsocialgroupmemberrefPRIMARY,groupidgroupid5const,const22Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroupmember.userid1 
1SIMPLEavatareq_refPRIMARYPRIMARY2douglasr_bleachforuns.user.avatarid1 
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4douglasr_bleachforuns.user.userid1 

Time Before: 0.12669 seconds
Time After: 0.12710 seconds
Time Taken: 0.00041 seconds

Memory Before: 14,062.820 KB
Memory After: 14,062.781 KB
Memory Used: -0.039 KB

SQL Query
SELECT user.*, socialgroupmember.groupid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM socialgroupmember AS socialgroupmember
LEFT JOIN user AS user ON (socialgroupmember.userid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE socialgroupmember.groupid = 13 AND socialgroupmember.type = 'member'
ORDER BY socialgroupmember.dateline DESC
LIMIT 10
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsocialgroupmemberrefPRIMARY,groupidgroupid5const,const8Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroupmember.userid1 
1SIMPLEavatareq_refPRIMARYPRIMARY2douglasr_bleachforuns.user.avatarid1 
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4douglasr_bleachforuns.user.userid1 

Time Before: 0.12782 seconds
Time After: 0.12825 seconds
Time Taken: 0.00043 seconds

Memory Before: 14,258.352 KB
Memory After: 14,258.313 KB
Memory Used: -0.039 KB

SQL Query
SELECT user.*, socialgroupmember.groupid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM socialgroupmember AS socialgroupmember
LEFT JOIN user AS user ON (socialgroupmember.userid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE socialgroupmember.groupid = 14 AND socialgroupmember.type = 'member'
ORDER BY socialgroupmember.dateline DESC
LIMIT 10
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsocialgroupmemberrefPRIMARY,groupidgroupid5const,const56Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroupmember.userid1 
1SIMPLEavatareq_refPRIMARYPRIMARY2douglasr_bleachforuns.user.avatarid1 
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4douglasr_bleachforuns.user.userid1 

Time Before: 0.12899 seconds
Time After: 0.12942 seconds
Time Taken: 0.00044 seconds

Memory Before: 14,418.188 KB
Memory After: 14,418.148 KB
Memory Used: -0.039 KB

SQL Query
SELECT user.*, socialgroupmember.groupid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM socialgroupmember AS socialgroupmember
LEFT JOIN user AS user ON (socialgroupmember.userid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE socialgroupmember.groupid = 15 AND socialgroupmember.type = 'member'
ORDER BY socialgroupmember.dateline DESC
LIMIT 10
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsocialgroupmemberrefPRIMARY,groupidPRIMARY4const15Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroupmember.userid1 
1SIMPLEavatareq_refPRIMARYPRIMARY2douglasr_bleachforuns.user.avatarid1 
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4douglasr_bleachforuns.user.userid1 

Time Before: 0.13026 seconds
Time After: 0.13063 seconds
Time Taken: 0.00037 seconds

Memory Before: 14,617.180 KB
Memory After: 14,617.133 KB
Memory Used: -0.047 KB

SQL Query
SELECT user.*, socialgroupmember.groupid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM socialgroupmember AS socialgroupmember
LEFT JOIN user AS user ON (socialgroupmember.userid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE socialgroupmember.groupid = 16 AND socialgroupmember.type = 'member'
ORDER BY socialgroupmember.dateline DESC
LIMIT 10
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsocialgroupmemberrefPRIMARY,groupidPRIMARY4const1Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroupmember.userid1 
1SIMPLEavatareq_refPRIMARYPRIMARY2douglasr_bleachforuns.user.avatarid1 
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4douglasr_bleachforuns.user.userid1 

Time Before: 0.13134 seconds
Time After: 0.13157 seconds
Time Taken: 0.00023 seconds

Memory Before: 14,811.516 KB
Memory After: 14,811.469 KB
Memory Used: -0.047 KB

SQL Query
SELECT user.*, socialgroupmember.groupid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM socialgroupmember AS socialgroupmember
LEFT JOIN user AS user ON (socialgroupmember.userid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE socialgroupmember.groupid = 17 AND socialgroupmember.type = 'member'
ORDER BY socialgroupmember.dateline DESC
LIMIT 10
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsocialgroupmemberrefPRIMARY,groupidPRIMARY4const11Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroupmember.userid1 
1SIMPLEavatareq_refPRIMARYPRIMARY2douglasr_bleachforuns.user.avatarid1 
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4douglasr_bleachforuns.user.userid1 

Time Before: 0.13189 seconds
Time After: 0.13227 seconds
Time Taken: 0.00037 seconds

Memory Before: 14,831.766 KB
Memory After: 14,831.719 KB
Memory Used: -0.047 KB

SQL Query
SELECT user.*, socialgroupmember.groupid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM socialgroupmember AS socialgroupmember
LEFT JOIN user AS user ON (socialgroupmember.userid = user.userid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE socialgroupmember.groupid = 19 AND socialgroupmember.type = 'member'
ORDER BY socialgroupmember.dateline DESC
LIMIT 10
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsocialgroupmemberrefPRIMARY,groupidPRIMARY4const5Using where; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4douglasr_bleachforuns.socialgroupmember.userid1 
1SIMPLEavatareq_refPRIMARYPRIMARY2douglasr_bleachforuns.user.avatarid1 
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4douglasr_bleachforuns.user.userid1 

Time Before: 0.13302 seconds
Time After: 0.13330 seconds
Time Taken: 0.00028 seconds

Memory Before: 15,026.656 KB
Memory After: 15,026.609 KB
Memory Used: -0.047 KB

SQL Query
SELECT *
FROM navigation
WHERE state & 4 = 0
ORDER BY navtype, displayorder
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnavigationALL    35Using where; Using filesort

Time Before: 0.15076 seconds
Time After: 0.15092 seconds
Time Taken: 0.00016 seconds

Memory Before: 15,133.680 KB
Memory After: 15,134.156 KB
Memory Used: 0.477 KB

SQL Query
UPDATE session
SET lastactivity = 1532111395, location = '/group.php?explain=1', badlocation = 0
WHERE sessionhash = 'b16a7247d5f9a279f59e2dff5fe72038'

Time Before: 0.15396 seconds
Time After: 0.15408 seconds
Time Taken: 0.00012 seconds

Memory Before: 15,807.906 KB
Memory After: 15,808.141 KB
Memory Used: 0.234 KB

Page generated in 0.15317106246948 seconds with 35 queries, spending 0.021127462387085 doing MySQL queries and 0.1320436000824 doing PHP things.
Shutdown Queries:
DISABLED