progress-pie.rb

Started GET "/small_bites/load_user_progress_chart?sitch_progress_charts%5B0%5D%5Belem_id%5D=sitch-progress-221882625431077&sitch_progress_charts%5B0%5D%5Bsitch_id%5D=27791&sitch_progress_charts%5B0%5D%5Buser_id%5D=5&sitch_progress_charts%5B0%5D%5Bopen_tools%5D=" for 127.0.0.1 at 2022-01-25 18:39:06 +0800
Processing by SmallBitesController#load_user_progress_chart as */*
  Parameters: {"sitch_progress_charts"=>{"0"=>{"elem_id"=>"sitch-progress-221882625431077", "sitch_id"=>"27791", "user_id"=>"5", "open_tools"=>""}}}
[Shard: master]  User Load (1.0ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 5 ORDER BY `users`.`id` ASC LIMIT 1
[Shard: master]  BlockedIp Load (0.8ms)  SELECT `blocked_ips`.* FROM `blocked_ips` WHERE `blocked_ips`.`ip_address` = '127.0.0.1' LIMIT 1
[Shard: master]  Account Load (1.0ms)  SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`domain` = 'mainsedemo.storyls.test' LIMIT 1
[Shard: master]  Account Load (1.2ms)  SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`subdomain` = 'mainsedemo' LIMIT 1
[Shard: master]  AccountUser Exists (0.9ms)  SELECT 1 AS one FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 0 LIMIT 1
  CACHE (0.0ms)  SELECT 1 AS one FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 0 LIMIT 1  [["user_id", 5]]
[Shard: master]  AccountUser Load (1.1ms)  SELECT `account_users`.* FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 37 LIMIT 1
  CACHE (0.0ms)  SELECT `account_users`.* FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 37 LIMIT 1  [["user_id", 5]]
  CACHE (0.0ms)  SELECT 1 AS one FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 0 LIMIT 1  [["user_id", 5]]
  CACHE (0.0ms)  SELECT 1 AS one FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 0 LIMIT 1  [["user_id", 5]]
  CACHE (0.0ms)  SELECT `account_users`.* FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 37 LIMIT 1  [["user_id", 5]]
  CACHE (0.0ms)  SELECT 1 AS one FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 0 LIMIT 1  [["user_id", 5]]
  CACHE (0.0ms)  SELECT `account_users`.* FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 37 LIMIT 1  [["user_id", 5]]
  CACHE (0.0ms)  SELECT 1 AS one FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 0 LIMIT 1  [["user_id", 5]]
  CACHE (0.0ms)  SELECT 1 AS one FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 0 LIMIT 1  [["user_id", 5]]
  CACHE (0.0ms)  SELECT `account_users`.* FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 37 LIMIT 1  [["user_id", 5]]
  CACHE (0.0ms)  SELECT `account_users`.* FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 37 LIMIT 1  [["user_id", 5]]
[Shard: master]  Account Load (1.4ms)  SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`subdomain` IN ('mainse', 'mainsedemo') ORDER BY `accounts`.`id` DESC LIMIT 1
  CACHE (0.0ms)  SELECT 1 AS one FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 0 LIMIT 1  [["user_id", 5]]
  CACHE (0.0ms)  SELECT 1 AS one FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 0 LIMIT 1  [["user_id", 5]]
  CACHE (0.0ms)  SELECT `account_users`.* FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 37 LIMIT 1  [["user_id", 5]]
[Shard: master]  AccountSubscription Load (0.9ms)  SELECT `account_subscriptions`.* FROM `account_subscriptions` WHERE `account_subscriptions`.`account_id` = 37
[Shard: master]   (0.7ms)  SELECT DISTINCT COUNT(DISTINCT `webpages`.`id`) FROM `webpages` WHERE (webpages.account_id = 37 OR (webpages.account_id IN (37) AND webpages.hide_in_account_ids NOT LIKE '%37%')) AND `webpages`.`guide_page` = 1 AND `webpages`.`show_url` = '/small_bites/load_user_progress_chart'
[Shard: master]  AccountFeature Load (0.9ms)  SELECT `account_features`.* FROM `account_features` WHERE `account_features`.`account_id` = 37 ORDER BY `account_features`.`id` ASC LIMIT 1
[Shard: master]  SmallBite Load (1.1ms)  SELECT `small_bites`.* FROM `small_bites` WHERE `small_bites`.`account_id` = 37 AND `small_bites`.`id` = 27791 LIMIT 1
[Shard: master]  User Load (1.1ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 5 LIMIT 1
[Shard: master]  SmallBiteProgress Load (1.2ms)  SELECT `small_bite_progresses`.* FROM `small_bite_progresses` WHERE `small_bite_progresses`.`small_bite_id` = 27791 AND `small_bite_progresses`.`user_id` = 5 LIMIT 1
[Shard: master]  Account Load (1.2ms)  SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 37 ORDER BY `accounts`.`id` ASC LIMIT 1
  CACHE (0.0ms)  SELECT `account_features`.* FROM `account_features` WHERE `account_features`.`account_id` = 37 ORDER BY `account_features`.`id` ASC LIMIT 1  [["account_id", 37]]
  CACHE (0.0ms)  SELECT 1 AS one FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 0 LIMIT 1  [["user_id", 5]]
  CACHE (0.0ms)  SELECT 1 AS one FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 0 LIMIT 1  [["user_id", 5]]
  CACHE (0.0ms)  SELECT `account_users`.* FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 37 LIMIT 1  [["user_id", 5]]
  CACHE (0.0ms)  SELECT `small_bite_progresses`.* FROM `small_bite_progresses` WHERE `small_bite_progresses`.`small_bite_id` = 27791 AND `small_bite_progresses`.`user_id` = 5 LIMIT 1  [["small_bite_id", 27791]]
  CACHE (0.0ms)  SELECT 1 AS one FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 0 LIMIT 1  [["user_id", 5]]
  CACHE (0.0ms)  SELECT 1 AS one FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 0 LIMIT 1  [["user_id", 5]]
  CACHE (0.0ms)  SELECT `account_users`.* FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 37 LIMIT 1  [["user_id", 5]]
  CACHE (0.0ms)  SELECT `small_bite_progresses`.* FROM `small_bite_progresses` WHERE `small_bite_progresses`.`small_bite_id` = 27791 AND `small_bite_progresses`.`user_id` = 5 LIMIT 1  [["small_bite_id", 27791]]
  CACHE (0.0ms)  SELECT 1 AS one FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 0 LIMIT 1  [["user_id", 5]]
  CACHE (0.0ms)  SELECT 1 AS one FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 0 LIMIT 1  [["user_id", 5]]
  CACHE (0.0ms)  SELECT `account_users`.* FROM `account_users` WHERE `account_users`.`user_id` = 5 AND `account_users`.`account_id` = 37 LIMIT 1  [["user_id", 5]]
[Shard: master]  Certificate Load (1.1ms)  SELECT `certificates`.* FROM `certificates` WHERE `certificates`.`resource_id` = 27791 AND `certificates`.`resource_type` = 'SmallBite' ORDER BY `certificates`.`id` ASC LIMIT 1
  Rendered small_bites/sitch/_sitch_progress_display.html.haml (111.8ms)
  Rendered small_bites/load_user_progress_chart.js.erb (116.9ms)
Completed 200 OK in 271ms (Views: 125.5ms | ActiveRecord: 16.0ms)