Skip to content

Instantly share code, notes, and snippets.

@jamland
Created October 10, 2013 16:15
Show Gist options
  • Save jamland/6921099 to your computer and use it in GitHub Desktop.
Save jamland/6921099 to your computer and use it in GitHub Desktop.
Project Load (0.2ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 85087 LIMIT 1
CACHE (0.0ms) SELECT `features`.* FROM `features` WHERE `features`.`name` = 'sms' LIMIT 1
CACHE (0.0ms) SELECT 1 AS one FROM `features` INNER JOIN `feature_flags` ON `features`.`id` = `feature_flags`.`feature_id` WHERE `feature_flags`.`account_id` = 28669 AND `features`.`id` = 10 LIMIT 1
Project Load (0.3ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 85164 LIMIT 1
CACHE (0.0ms) SELECT `features`.* FROM `features` WHERE `features`.`name` = 'sms' LIMIT 1
CACHE (0.0ms) SELECT 1 AS one FROM `features` INNER JOIN `feature_flags` ON `features`.`id` = `feature_flags`.`feature_id` WHERE `feature_flags`.`account_id` = 28669 AND `features`.`id` = 10 LIMIT 1
Project Load (0.3ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 85579 LIMIT 1
CACHE (0.0ms) SELECT `features`.* FROM `features` WHERE `features`.`name` = 'sms' LIMIT 1
CACHE (0.0ms) SELECT 1 AS one FROM `features` INNER JOIN `feature_flags` ON `features`.`id` = `feature_flags`.`feature_id` WHERE `feature_flags`.`account_id` = 28669 AND `features`.`id` = 10 LIMIT 1
Project Load (0.2ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 85635 LIMIT 1
CACHE (0.0ms) SELECT `features`.* FROM `features` WHERE `features`.`name` = 'sms' LIMIT 1
CACHE (0.0ms) SELECT 1 AS one FROM `features` INNER JOIN `feature_flags` ON `features`.`id` = `feature_flags`.`feature_id` WHERE `feature_flags`.`account_id` = 28669 AND `features`.`id` = 10 LIMIT 1
Project Load (0.3ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 86625 LIMIT 1
CACHE (0.0ms) SELECT `features`.* FROM `features` WHERE `features`.`name` = 'sms' LIMIT 1
CACHE (0.0ms) SELECT 1 AS one FROM `features` INNER JOIN `feature_flags` ON `features`.`id` = `feature_flags`.`feature_id` WHERE `feature_flags`.`account_id` = 28669 AND `features`.`id` = 10 LIMIT 1
Project Load (0.3ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 86934 LIMIT 1
CACHE (0.0ms) SELECT `features`.* FROM `features` WHERE `features`.`name` = 'sms' LIMIT 1
CACHE (0.0ms) SELECT 1 AS one FROM `features` INNER JOIN `feature_flags` ON `features`.`id` = `feature_flags`.`feature_id` WHERE `feature_flags`.`account_id` = 28669 AND `features`.`id` = 10 LIMIT 1
Project Load (0.2ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 86935 LIMIT 1
CACHE (0.0ms) SELECT `features`.* FROM `features` WHERE `features`.`name` = 'sms' LIMIT 1
CACHE (0.0ms) SELECT 1 AS one FROM `features` INNER JOIN `feature_flags` ON `features`.`id` = `feature_flags`.`feature_id` WHERE `feature_flags`.`account_id` = 28669 AND `features`.`id` = 10 LIMIT 1
Project Load (0.3ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 87103 LIMIT 1
CACHE (0.0ms) SELECT `features`.* FROM `features` WHERE `features`.`name` = 'sms' LIMIT 1
CACHE (0.0ms) SELECT 1 AS one FROM `features` INNER JOIN `feature_flags` ON `features`.`id` = `feature_flags`.`feature_id` WHERE `feature_flags`.`account_id` = 28669 AND `features`.`id` = 10 LIMIT 1
Project Load (0.3ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 87306 LIMIT 1
CACHE (0.0ms) SELECT `features`.* FROM `features` WHERE `features`.`name` = 'sms' LIMIT 1
CACHE (0.0ms) SELECT 1 AS one FROM `features` INNER JOIN `feature_flags` ON `features`.`id` = `feature_flags`.`feature_id` WHERE `feature_flags`.`account_id` = 28669 AND `features`.`id` = 10 LIMIT 1
Project Load (0.3ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 87542 LIMIT 1
CACHE (0.0ms) SELECT `features`.* FROM `features` WHERE `features`.`name` = 'sms' LIMIT 1
CACHE (0.0ms) SELECT 1 AS one FROM `features` INNER JOIN `feature_flags` ON `features`.`id` = `feature_flags`.`feature_id` WHERE `feature_flags`.`account_id` = 28669 AND `features`.`id` = 10 LIMIT 1
Project Load (0.3ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 87957 LIMIT 1
CACHE (0.0ms) SELECT `features`.* FROM `features` WHERE `features`.`name` = 'sms' LIMIT 1
CACHE (0.0ms) SELECT 1 AS one FROM `features` INNER JOIN `feature_flags` ON `features`.`id` = `feature_flags`.`feature_id` WHERE `feature_flags`.`account_id` = 28669 AND `features`.`id` = 10 LIMIT 1
Project Load (0.3ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 88318 LIMIT 1
CACHE (0.0ms) SELECT `features`.* FROM `features` WHERE `features`.`name` = 'sms' LIMIT 1
CACHE (0.0ms) SELECT 1 AS one FROM `features` INNER JOIN `feature_flags` ON `features`.`id` = `feature_flags`.`feature_id` WHERE `feature_flags`.`account_id` = 28669 AND `features`.`id` = 10 LIMIT 1
CACHE (0.0ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 58578 LIMIT 1
CACHE (0.0ms) SELECT `features`.* FROM `features` WHERE `features`.`name` = 'sms' LIMIT 1
CACHE (0.0ms) SELECT 1 AS one FROM `features` INNER JOIN `feature_flags` ON `features`.`id` = `feature_flags`.`feature_id` WHERE `feature_flags`.`account_id` = 28669 AND `features`.`id` = 10 LIMIT 1
Project Load (0.3ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 88640 LIMIT 1
CACHE (0.0ms) SELECT `features`.* FROM `features` WHERE `features`.`name` = 'sms' LIMIT 1
CACHE (0.0ms) SELECT 1 AS one FROM `features` INNER JOIN `feature_flags` ON `features`.`id` = `feature_flags`.`feature_id` WHERE `feature_flags`.`account_id` = 28669 AND `features`.`id` = 10 LIMIT 1
Project Load (0.2ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 88665 LIMIT 1
CACHE (0.0ms) SELECT `features`.* FROM `features` WHERE `features`.`name` = 'sms' LIMIT 1
CACHE (0.0ms) SELECT 1 AS one FROM `features` INNER JOIN `feature_flags` ON `features`.`id` = `feature_flags`.`feature_id` WHERE `feature_flags`.`account_id` = 28669 AND `features`.`id` = 10 LIMIT 1
Project Load (0.3ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 89578 LIMIT 1
CACHE (0.0ms) SELECT `features`.* FROM `features` WHERE `features`.`name` = 'sms' LIMIT 1
CACHE (0.0ms) SELECT 1 AS one FROM `features` INNER JOIN `feature_flags` ON `features`.`id` = `feature_flags`.`feature_id` WHERE `feature_flags`.`account_id` = 28669 AND `features`.`id` = 10 LIMIT 1
Project Load (0.3ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 89737 LIMIT 1
CACHE (0.0ms) SELECT `features`.* FROM `features` WHERE `features`.`name` = 'sms' LIMIT 1
CACHE (0.0ms) SELECT 1 AS one FROM `features` INNER JOIN `feature_flags` ON `features`.`id` = `feature_flags`.`feature_id` WHERE `feature_flags`.`account_id` = 28669 AND `features`.`id` = 10 LIMIT 1
Project Load (0.2ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 89742 LIMIT 1
CACHE (0.0ms) SELECT `features`.* FROM `features` WHERE `features`.`name` = 'sms' LIMIT 1
CACHE (0.0ms) SELECT 1 AS one FROM `features` INNER JOIN `feature_flags` ON `features`.`id` = `feature_flags`.`feature_id` WHERE `feature_flags`.`account_id` = 28669 AND `features`.`id` = 10 LIMIT 1
Project Load (0.3ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 90072 LIMIT 1
CACHE (0.0ms) SELECT `features`.* FROM `features` WHERE `features`.`name` = 'sms' LIMIT 1
CACHE (0.0ms) SELECT 1 AS one FROM `features` INNER JOIN `feature_flags` ON `features`.`id` = `feature_flags`.`feature_id` WHERE `feature_flags`.`account_id` = 28669 AND `features`.`id` = 10 LIMIT 1
Project Load (0.3ms) SELECT `projects`.* FROM `projects` WHERE `projects`.`id` = 90484 LIMIT 1
CACHE (0.0ms) SELECT `features`.* FROM `features` WHERE `features`.`name` = 'sms' LIMIT 1
CACHE (0.0ms) SELECT 1 AS one FROM `features` INNER JOIN `feature_flags` ON `features`.`id` = `feature_flags`.`feature_id` WHERE `feature_flags`.`account_id` = 28669 AND `features`.`id` = 10 LIMIT 1
Rendered users/edit_notifications.html.erb within layouts/settings (285.1ms)
Project Load (39.2ms) SELECT `projects`.* FROM `projects` INNER JOIN `project_memberships` ON `projects`.`id` = `project_memberships`.`project_id` WHERE `project_memberships`.`user_id` = 63730 ORDER BY project_memberships.updated_at desc LIMIT 1
ProjectMembership Load (35.4ms) SELECT `project_memberships`.* FROM `project_memberships` WHERE `project_memberships`.`user_id` = 63730 AND `project_memberships`.`project_id` = 1055 LIMIT 1
SQL (33.5ms) UPDATE `project_memberships` SET `updated_at` = '2013-10-10 16:14:01' WHERE `project_memberships`.`id` = 564624
Rendered layouts/_head.html.erb (115.0ms)
Project Load (33.0ms) SELECT `projects`.* FROM `projects` INNER JOIN `project_memberships` ON `projects`.`id` = `project_memberships`.`project_id` WHERE `project_memberships`.`user_id` = 63730 ORDER BY projects.name
 (0.4ms) SELECT COUNT(*) FROM `projects` WHERE `projects`.`account_id` = 28669
CACHE (0.0ms) SELECT COUNT(*) FROM `projects` WHERE `projects`.`account_id` = 28669
Rendered projects/_form.html.erb (0.4ms)
CACHE (0.0ms) SELECT COUNT(*) FROM `projects` WHERE `projects`.`account_id` = 28669
Rendered shared/_create_project_modal.html.erb (5.7ms)
Rendered layouts/_navbar.html.erb (49.9ms)
Rendered layouts/_flash_box.html.erb (0.1ms)
Rendered layouts/_settings_sidebar.html.erb (19.8ms)
Rendered layouts/_kiss.html.erb (0.1ms)
Rendered layouts/_footer_for_common_js.html.erb (86.3ms)
Account Load (0.4ms) SELECT `accounts`.* FROM `accounts` WHERE `accounts`.`id` = 28669 LIMIT 1
Subscription Load (0.3ms) SELECT `subscriptions`.* FROM `subscriptions` WHERE `subscriptions`.`id` = 34145 LIMIT 1
Plan Load (0.2ms) SELECT `plans`.* FROM `plans` WHERE `plans`.`id` = 62 LIMIT 1
Integration Load (0.4ms) SELECT `integrations`.* FROM `integrations` WHERE `integrations`.`project_id` = 1055 AND `integrations`.`active` = 1
Service Load (0.3ms) SELECT `services`.* FROM `services` WHERE `services`.`id` = 1 LIMIT 1
Service Load (0.3ms) SELECT `services`.* FROM `services` WHERE `services`.`id` = 2 LIMIT 1
Service Load (0.3ms) SELECT `services`.* FROM `services` WHERE `services`.`id` = 5 LIMIT 1
Service Load (0.2ms) SELECT `services`.* FROM `services` WHERE `services`.`id` = 6 LIMIT 1
Service Load (0.2ms) SELECT `services`.* FROM `services` WHERE `services`.`id` = 10 LIMIT 1
Rendered layouts/_footer_for_rails_js.html.erb (14.9ms)
Completed 200 OK in 589ms (Views: 351.8ms | ActiveRecord: 232.9ms)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment