gistfile1.rb

AppUser Load (44.0ms)   SELECT * FROM `app_users` WHERE (id = 17480) 
  AppUserContribution Load (44.9ms)   
 select sum(direct_amount + karmic_amount) as total
 from app_user_contributions 
 where app_charity_goal_id = 244 and app_user_id in (17480)
  AppUser Load (33.7ms)   SELECT * FROM `app_users` WHERE (id = 17480) 
  AppUserContribution Load (46.9ms)   
 select sum(app_user_contributions.direct_amount + app_user_contributions.karmic_amount) as total
 from app_user_contributions inner join app_charity_goals on app_user_contributions.app_charity_goal_id = app_charity_goals.id
 where app_charity_goals.app_charity_id = 10 and app_user_contributions.app_user_id in (17480)
==> Got SystemVariable:value:point_conversion_factor from cache. (0.00076)
Cache hit: AppCharity:10:supporter_count ({:expires_in=>60 seconds})
  AppUserContribution Load (40.8ms)   SELECT * FROM `app_user_contributions` WHERE (`app_user_contributions`.app_user_id = 17480 AND (app_charity_goal_id = 244)) 
  SponsorshipAppActivity Load (52.7ms)   SELECT * FROM `app_activities` WHERE (autoswitch_value is not null and active = true) AND ( (`app_activities`.`type` = 'SponsorshipAppActivity' ) ) 
  AppUser Load (174.7ms)   SELECT * FROM `app_users` WHERE ( activity_autoswitch = true and app_id != 1 and id > 29031 ) ORDER BY id LIMIT 500
  AppCharity Load (43.6ms)   SELECT * FROM `app_charities` WHERE (`app_charities`.`id` = 3) 
  AppCharityGoal Load (53.2ms)   SELECT * FROM `app_charity_goals` WHERE (`app_charity_goals`.app_charity_id = 3 AND (app_charity_goals.status = 'active')) LIMIT 1


AppUser Load (68.3ms)   SELECT * FROM `app_users` WHERE (id = 17817) 
  AppUserContribution Load (42.9ms)   
 select sum(direct_amount + karmic_amount) as total
 from app_user_contributions 
 where app_charity_goal_id = 276 and app_user_id in (17817)
  AppUser Load (52.5ms)   SELECT * FROM `app_users` WHERE (id = 17817) 
  AppUserContribution Load (46.3ms)   
 select sum(app_user_contributions.direct_amount + app_user_contributions.karmic_amount) as total
 from app_user_contributions inner join app_charity_goals on app_user_contributions.app_charity_goal_id = app_charity_goals.id
 where app_charity_goals.app_charity_id = 3 and app_user_contributions.app_user_id in (17817)
==> Got SystemVariable:value:point_conversion_factor from cache. (0.00055)
Cache hit: AppCharity:3:supporter_count ({:expires_in=>60 seconds})
  AppUserContribution Load (43.3ms)   SELECT * FROM `app_user_contributions` WHERE (`app_user_contributions`.app_user_id = 17817 AND (app_charity_goal_id = 276)) 
  SponsorshipAppActivity Load (53.4ms)   SELECT * FROM `app_activities` WHERE (autoswitch_value is not null and active = true) AND ( (`app_activities`.`type` = 'SponsorshipAppActivity' ) ) 
  AppUser Load (175.0ms)   SELECT * FROM `app_users` WHERE ( activity_autoswitch = true and app_id != 1 and id > 29031 ) ORDER BY id LIMIT 500
  AppCharity Load (42.1ms)   SELECT * FROM `app_charities` WHERE (`app_charities`.`id` = 9) 
  AppCharityGoal Load (54.4ms)   SELECT * FROM `app_charity_goals` WHERE (`app_charity_goals`.app_charity_id = 9 AND (app_charity_goals.status = 'active')) LIMIT 1


AppUser Load (48.9ms)   SELECT * FROM `app_users` WHERE (id = 30015) 
  AppUserContribution Load (45.1ms)   
 select sum(direct_amount + karmic_amount) as total
 from app_user_contributions 
 where app_charity_goal_id = 276 and app_user_id in (30015)
  AppUser Load (56.4ms)   SELECT * FROM `app_users` WHERE (id = 30015) 
  AppUserContribution Load (46.8ms)   
 select sum(app_user_contributions.direct_amount + app_user_contributions.karmic_amount) as total
 from app_user_contributions inner join app_charity_goals on app_user_contributions.app_charity_goal_id = app_charity_goals.id
 where app_charity_goals.app_charity_id = 3 and app_user_contributions.app_user_id in (30015)
==> Got SystemVariable:value:point_conversion_factor from cache. (0.01634)
Cache hit: AppCharity:3:supporter_count ({:expires_in=>60 seconds})
  AppUserContribution Load (42.5ms)   SELECT * FROM `app_user_contributions` WHERE (`app_user_contributions`.app_user_id = 30015 AND (app_charity_goal_id = 276)) 
  SponsorshipAppActivity Load (61.0ms)   SELECT * FROM `app_activities` WHERE (autoswitch_value is not null and active = true) AND ( (`app_activities`.`type` = 'SponsorshipAppActivity' OR `app_activities`.`type` = 'UserGeneratedSponsorshipAppActivity' OR `app_activities`.`type` = 'QuestionOfTheDayUserGeneratedSponsorshipAppActivity' ) ) 
  AppUser Load (166.5ms)   SELECT * FROM `app_users` WHERE ( activity_autoswitch = true and app_id != 1 and id > 34897 ) ORDER BY id LIMIT 500
  AppCharity Load (57.2ms)   SELECT * FROM `app_charities` WHERE (`app_charities`.`id` = 14) 
  AppCharityGoal Load (46.1ms)   SELECT * FROM `app_charity_goals` WHERE (`app_charity_goals`.app_charity_id = 14 AND (app_charity_goals.status = 'active')) LIMIT 1

===============
After adding the include : 

AppUser Load (45.1ms)   SELECT * FROM `app_users` WHERE (id = 24049) 
  AppUserContribution Load (50.2ms)   
 select sum(direct_amount + karmic_amount) as total
 from app_user_contributions 
 where app_charity_goal_id = 267 and app_user_id in (24049)
  AppUser Load (118.1ms)   SELECT * FROM `app_users` WHERE (id = 24049) 
  AppUserContribution Load (49.7ms)   
 select sum(app_user_contributions.direct_amount + app_user_contributions.karmic_amount) as total
 from app_user_contributions inner join app_charity_goals on app_user_contributions.app_charity_goal_id = app_charity_goals.id
 where app_charity_goals.app_charity_id = 5 and app_user_contributions.app_user_id in (24049)
Cache hit: AppCharity:5:supporter_count ({:expires_in=>60 seconds})
==> Got SystemVariable:value:point_conversion_factor from cache. (0.00094)
  AppUserContribution Load (43.3ms)   SELECT * FROM `app_user_contributions` WHERE (`app_user_contributions`.app_user_id = 24049 AND (app_charity_goal_id = 267)) 
  SponsorshipAppActivity Load (57.0ms)   SELECT * FROM `app_activities` WHERE (autoswitch_value is not null and active = true) AND ( (`app_activities`.`type` = 'SponsorshipAppActivity' OR `app_activities`.`type` = 'UserGeneratedSponsorshipAppActivity' OR `app_activities`.`type` = 'QuestionOfTheDayUserGeneratedSponsorshipAppActivity' ) ) 
  AppUser Load (1666.9ms)   SELECT * FROM `app_users` WHERE ( activity_autoswitch = true and app_id != 1 and id > 34897 ) ORDER BY id LIMIT 1000
  AppUserContribution Load (650.4ms)   SELECT `app_user_contributions`.* FROM `app_user_contributions` WHERE (`app_user_contributions`.app_user_id IN (34900,34914,34925,34929,34942,34972,35002,35004,35042,35043,35064,35090,35091,35128,35135,35142,35145,35157,35159,35164,35185,35194,35195,35215,35218,35219,35227,35229,35240,35246,35258,35263,35270,35271,35286,35288,35292,35298,35301,35304,35312,35313,35317,35319,35327,35335,35348,35365,35368,35369,35371,35376,35380,35384,35390,35400,35404,35419,35423,35430,35455,35457,35459,35462,35467,35483,35493,35495,35497,35500,35504,35507,35519,35526,35534,35551,35568,35606,35615,35617,35635,35640,35653,35655,35662,35663,35695,35696,35719,35725,35734,35737,35738,35739,35758,35759,35777,35781,35785,35793,35802,35808,35826,35831,35839,35841,35842,35849,35855,35868,35900,35907,35923,35932,35938,35939,35972,35995,36008,36032,36037,36048,36102,36111,36121,36137,36139,36157,36170,36173,36182,36197,36213,36218,36226,36239,36253,36271,36302,36308,36311,36317,36324,36330,36334,36357,36373,36384,36394,36429,36462,36468,36483,36496,36497,36499,36538,36547,36573,36575,36590,36609,36629,36655,36672,36673,36674,36683,36703,36736,36741,36742,36744,36756,36760,36777,36784,36799,36818,36822,36848,36856,36858,36861,36862,36867,36873,36898,36906,36908,36912,36971,37001,37006,37009,37011,37063,37067,37083,37086,37088,37100,37102,37103,37104,37108,37122,37129,37132,37137,37143,37149,37175,37188,37209,37210,37212,37213,37233,37247,37258,37267,37270,37320,37341,37346,37362,37431,37442,37443,37474,37494,37498,37533,37556,37586,37625,37651,37729,37736,37807,37831,37998,38023,38044,38051,38052,38055,38066,38075,38083,38131,38227,38276,38326,38328,38443,38467,38614,38678,38703,38722,38725,38728,38806,38808,38823,38867,38875,38885,38892,38920,39003,39053,39057,39061,39107,39109,39110,39117,39118,39147,39150,39156,39159,39163,39166,39209,39245,39266,39272,39311,39329,39332,39346,39359,39403,39408,39413,39456,39457,39476,39517,39524,39556,39563,39574,39590,39601,39614,39620,39624,39635,39673,39687,39692,39700,39728,39748,39762,39766,39779,39782,39869,39870,39884,39898,39901,39915,39917,39976,39998,40011,40082,40091,40100,40140,40143,40157,40160,40174,40183,40191,40201,40203,40212,40217,40219,40226,40228,40236,40263,40264,40266,40289,40296,40300,40302,40303,40319,40351,40371,40382,40392,40396,40397,40408,40411,40412,40413,40420,40426,40428,40430,40433,40437,40444,40446,40451,40457,40459,40465,40466,40467,40472,40475,40481,40483,40491,40497,40501,40502,40511,40514,40524,40532,40536,40539,40544,40555,40570,40589,40593,40597,40601,40604,40610,40621,40636,40642,40647,40664,40666,40668,40681,40688,40710,40711,40713,40719,40735,40739,40746,40756,40760,40765,40776,40786,40793,40799,40812,40821,40826,40835,40843,40865,40870,40873,40874,40879,40884,40894,40898,40913,40917,40920,40924,40930,40934,40938,40940,40944,40947,40948,40950,40953,40958,40972,40978,40980,40988,40993,41012,41026,41034,41036,41041,41047,41048,41055,41073,41080,41083,41085,41087,41090,41092,41099,41109,41112,41117,41118,41128,41133,41134,41137,41145,41146,41155,41159,41177,41193,41200,41202,41207,41208,41209,41212,41218,41222,41226,41232,41233,41236,41237,41238,41239,41241,41259,41263,41270,41272,41285,41309,41323,41335,41344,41345,41357,41374,41382,41386,41393,41398,41399,41415,41420,41422,41427,41436,41437,41446,41452,41454,41489,41490,41500,41502,41507,41513,41518,41528,41545,41546,41557,41561,41578,41586,41602,41612,41613,41622,41626,41632,41639,41643,41647,41655,41658,41663,41679,41680,41682,41683,41685,41687,41689,41691,41693,41709,41713,41717,41720,41728,41731,41746,41749,41752,41776,41781,41789,41795,41813,41814,41816,41844,41847,41859,41861,41862,41864,41870,41871,41875,41891,41897,41904,41908,41913,41922,41928,41945,41964,41976,41977,41986,41987,42016,42042,42058,42060,42065,42069,42071,42079,42100,42103,42122,42137,42144,42149,42150,42156,42164,42166,42186,42189,42194,42217,42222,42227,42242,42250,42260,42269,42287,42291,42297,42301,42309,42320,42322,42323,42324,42332,42338,42344,42353,42355,42356,42360,42366,42381,42410,42411,42424,42427,42430,42433,42434,42435,42446,42447,42451,42455,42460,42462,42463,42472,42481,42484,42493,42496,42500,42503,42520,42531,42549,42574,42577,42588,42600,42607,42613,42614,42623,42624,42629,42635,42639,42643,42650,42653,42663,42667,42672,42676,42694,42699,42703,42725,42727,42745,42747,42751,42755,42757,42760,42777,42781,42785,42793,42799,42803,42806,42809,42837,42838,42852,42872,42874,42880,42882,42891,42911,42913,42919,42928,42929,42932,42939,42943,42950,42956,42960,42964,42970,42979,42986,42988,42996,42999,43004,43010,43014,43016,43020,43021,43035,43039,43048,43056,43062,43072,43081,43089,43090,43128,43150,43155,43157,43160,43162,43171,43172,43184,43198,43201,43206,43211,43222,43224,43227,43251,43257,43269,43287,43288,43289,43311,43313,43315,43317,43324,43333,43334,43339,43344,43346,43362,43366,43378,43382,43385,43386,43397,43409,43410,43413,43415,43417,43418,43420,43433,43438,43442,43449,43450,43455,43457,43461,43468,43469,43471,43475,43477,43484,43487,43489,43491,43492,43495,43499,43518,43519,43521,43522,43526,43529,43531,43532,43533,43553,43556,43563,43568,43587,43593,43594,43599,43603,43604,43611,43612,43617,43618,43658,43684,43692,43693,43695,43700,43708,43713,43720,43730,43733,43741,43745,43760,43775,43777,43792,43806,43811,43819,43844,43850,43857,43858,43869,43871,43878,43884,43885,43886,43889,43890,43895,43896,43905,43943,43952,43963,43980,43984,43986,43987,43990,44007,44009,44023,44043,44059,44067,44073,44100,44107,44111,44127,44131,44134,44141,44144,44147,44160,44166,44170,44173,44183,44184,44185,44195,44197,44204,44205,44210,44214,44219,44222,44223,44224,44232,44238,44240,44246,44255,44256,44260,44265,44270,44272,44277,44278,44279,44284,44291,44305,44307,44317,44342,44346,44349,44350,44353,44358,44372,44376,44382,44386,44388,44392,44403,44404,44406,44407,44408,44410,44418,44425,44433,44439,44441,44451,44454,44458,44466,44468,44469,44479,44483,44485,44489,44495,44499,44503,44507,44517,44519,44525,44526,44532,44533,44536,44540,44542,44549,44561,44569,44571,44577,44580,44581,44583,44584,44585,44593,44595,44598,44601)) 
  AppActivity Load (55.5ms)   SELECT * FROM `app_activities` WHERE (`app_activities`.`id` IN (22,55,6,56,23,91,46,8,13,58,130,36,25,70,119,60,59,37,110,27,39,17,178,123,18,124,31,10,32)) 
  AppCharity Load (96.5ms)   SELECT * FROM `app_charities` WHERE (`app_charities`.`id` IN (22,6,11,23,12,7,35,13,8,25,14,9,26,27,40,39,17,1,18,2,20,31,19,3,10,4,5)) 
  AppCharityGoal Load (55.2ms)   SELECT * FROM `app_charity_goals` WHERE (`app_charity_goals`.app_charity_id = 21 AND (app_charity_goals.status = 'active')) LIMIT 1