Skip to content

Instantly share code, notes, and snippets.

@kennethjohnbalgos
Created January 25, 2022 10:44
Show Gist options
  • Save kennethjohnbalgos/ea2671164b889ed035c3e30b5a48067e to your computer and use it in GitHub Desktop.
Save kennethjohnbalgos/ea2671164b889ed035c3e30b5a48067e to your computer and use it in GitHub Desktop.
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)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment