Skip to content

Instantly share code, notes, and snippets.

@johnmaxwell
Created January 2, 2018 19:28
Show Gist options
  • Save johnmaxwell/f87a1c4b0e40a5b31cc0b7e8a206b8b0 to your computer and use it in GitHub Desktop.
Save johnmaxwell/f87a1c4b0e40a5b31cc0b7e8a206b8b0 to your computer and use it in GitHub Desktop.
first page load after powder restart
DEPRECATION WARNING: ActiveRecord::Base.raise_in_transactional_callbacks= is deprecated, has no effect and will be removed without replacement. (called from <top (required)> at /Users/john/work/3rdhome/config/environment.rb:5)
DEPRECATION WARNING: after_filter is deprecated and will be removed in Rails 5.1. Use after_action instead. (called from <top (required)> at /Users/john/work/3rdhome/config/environment.rb:5)
DEPRECATION WARNING: alias_method_chain is deprecated. Please, use Module#prepend instead. From module, you can access the original method using super. (called from <top (required)> at /Users/john/work/3rdhome/config/environment.rb:5)
DEPRECATION WARNING: In Rails 5.1, The `:subdomains` option of HSTS config will be treated as true if
unspecified. Set `config.ssl_options = { hsts: { subdomains: false } }` to opt out
of this behavior.
(called from <top (required)> at /Users/john/work/3rdhome/config/environment.rb:5)
DEPRECATION WARNING: Active Admin: using `action_item` without a name is deprecated! Use `action_item(:edit)`. (called from block in <top (required)> at /Users/john/work/3rdhome/app/admin/transaction_logs.rb:14)
Creating scope :open. Overwriting existing method StayRequest.open.
DEPRECATION WARNING: Active Admin: using `action_item` without a name is deprecated! Use `action_item(:edit)`. (called from block in <top (required)> at /Users/john/work/3rdhome/app/admin/users.rb:453)
ActiveRecord::SchemaMigration Load (0.6ms) SELECT `schema_migrations`.* FROM `schema_migrations`
User Load (0.5ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 1890 ORDER BY `users`.`id` ASC LIMIT 1
{"method":"GET","path":"/","format":"html","controller":"home","action":"index","status":302,"duration":258.5,"view":0.0,"db":28.88,"location":"https://www.3rdhome.dev/","current_user":{"id":1890,"login":"johnmaxwell"},"params":{}}
(0.1ms) BEGIN
(0.1ms) COMMIT
User Load (0.4ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 1890 ORDER BY `users`.`id` ASC LIMIT 1
{"method":"GET","path":"/","format":"html","controller":"home","action":"index","status":302,"duration":3.57,"view":0.0,"db":0.7,"location":"https://www.3rdhome.dev/account","current_user":{"id":1890,"login":"johnmaxwell"},"params":{}}
(0.2ms) BEGIN
(0.1ms) COMMIT
User Load (0.3ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 1890 ORDER BY `users`.`id` ASC LIMIT 1
Reservation Load (13.3ms) SELECT `reservations`.* FROM `reservations` INNER JOIN `bookings` ON `bookings`.`id` = `reservations`.`booking_id` WHERE `reservations`.`user_id` = 1890 AND (bookings.starts_on < '2018-01-02' AND bookings.ends_on > '2017-11-18 19:27:44') AND `reservations`.`active` = 1
(0.2ms) SELECT `residence_clubs`.id FROM `residence_clubs` WHERE `residence_clubs`.`user_id` = 1890
Reservation Load (0.3ms) SELECT `reservations`.* FROM `reservations` INNER JOIN `bookings` ON `bookings`.`id` = `reservations`.`booking_id` INNER JOIN `properties` ON `properties`.`id` = `bookings`.`property_id` LEFT OUTER JOIN residence_clubs ON residence_clubs.id = properties.residence_club_id WHERE `properties`.`user_id` = 1890 AND (properties.residence_club_id IS NULL OR residence_clubs.handles_reservations = 0) AND (bookings.starts_on < '2018-01-02' AND bookings.ends_on > '2017-11-18 19:27:44') AND `reservations`.`active` = 1
DEPRECATION WARNING: env is deprecated and will be removed from Rails 5.1 (called from register_gon_globals! at /Users/john/work/3rdhome/app/controllers/application_controller.rb:258)
Property Load (0.5ms) SELECT `properties`.* FROM `properties` WHERE `properties`.`user_id` = 1890 LIMIT 4 OFFSET 0
(0.4ms) SELECT COUNT(*) FROM `bookings` WHERE (bookings.starts_on >= CURDATE()) AND `bookings`.`status` = 'reserved' AND `bookings`.`requester_id` = 1890
(0.2ms) SELECT COUNT(*) FROM `saved_searches` WHERE `saved_searches`.`user_id` = 1890
(0.3ms) SELECT COUNT(*) FROM `properties` INNER JOIN `property_watchings` ON `properties`.`id` = `property_watchings`.`property_id` WHERE `property_watchings`.`user_id` = 1890 AND (properties.status = 'active' OR (properties.status = 'template' AND properties.units_count > 0)) AND `properties`.`template_property_id` IS NULL
(0.3ms) SELECT COUNT(*) FROM `deposits` INNER JOIN `properties` ON `deposits`.`property_id` = `properties`.`id` WHERE `properties`.`user_id` = 1890 AND (ends_on >= '2018-01-02') AND `deposits`.`status` IN (0, 7, 1, 3, 8, 9)
(0.3ms) SELECT COUNT(*) FROM `bookings` INNER JOIN `properties` ON `properties`.`id` = `bookings`.`property_id` WHERE `bookings`.`held_for_user_id` = 1890 AND `bookings`.`status` = 'available' AND `properties`.`status` = 'active'
WeekRequest Load (0.3ms) SELECT `week_requests`.* FROM `week_requests` INNER JOIN `properties` ON `properties`.`id` = `week_requests`.`property_id` WHERE `properties`.`user_id` = 1890 AND `week_requests`.`state` = 'awaiting_owner'
WeekRequest Load (0.2ms) SELECT `week_requests`.* FROM `week_requests` WHERE `week_requests`.`user_id` = 1890 AND `week_requests`.`state` = 'awaiting_payment'
(0.3ms) SELECT COUNT(*) FROM `week_request_subscriptions` WHERE `week_request_subscriptions`.`request_type` = 'WeekRequest' AND `week_request_subscriptions`.`user_id` = 1890 AND `week_request_subscriptions`.`outstanding` = 1
Property Load (0.4ms) SELECT `properties`.* FROM `properties` INNER JOIN `properties` `template_properties_properties` ON `template_properties_properties`.`id` = `properties`.`template_property_id` WHERE `properties`.`user_id` = 1890
Availability Load (0.3ms) SELECT `bookings`.* FROM `bookings` INNER JOIN `properties` ON `properties`.`id` = `bookings`.`property_id` WHERE `bookings`.`held_for_user_id` = 1890 AND `bookings`.`status` = 'available' AND `properties`.`status` = 'active' LIMIT 4 OFFSET 0
CACHE (0.0ms) SELECT COUNT(*) FROM `deposits` INNER JOIN `properties` ON `deposits`.`property_id` = `properties`.`id` WHERE `properties`.`user_id` = 1890 AND (ends_on >= '2018-01-02') AND `deposits`.`status` IN (0, 7, 1, 3, 8, 9) [["user_id", 1890]]
CACHE (0.0ms) SELECT COUNT(*) FROM `deposits` INNER JOIN `properties` ON `deposits`.`property_id` = `properties`.`id` WHERE `properties`.`user_id` = 1890 AND (ends_on >= '2018-01-02') AND `deposits`.`status` IN (0, 7, 1, 3, 8, 9) [["user_id", 1890]]
(0.2ms) SELECT COUNT(*) FROM `properties` WHERE `properties`.`user_id` = 1890
(12.2ms) SELECT COUNT(*) FROM `reservations` INNER JOIN `bookings` ON `bookings`.`id` = `reservations`.`booking_id` WHERE `reservations`.`user_id` = 1890 AND `reservations`.`active` = 1 AND `reservations`.`active` = 1 AND (bookings.starts_on >= '2018-01-02')
CACHE (0.0ms) SELECT COUNT(*) FROM `reservations` INNER JOIN `bookings` ON `bookings`.`id` = `reservations`.`booking_id` WHERE `reservations`.`user_id` = 1890 AND `reservations`.`active` = 1 AND `reservations`.`active` = 1 AND (bookings.starts_on >= '2018-01-02') [["user_id", 1890], ["active", 1], ["active", 1]]
CACHE (0.0ms) SELECT COUNT(*) FROM `properties` INNER JOIN `property_watchings` ON `properties`.`id` = `property_watchings`.`property_id` WHERE `property_watchings`.`user_id` = 1890 AND (properties.status = 'active' OR (properties.status = 'template' AND properties.units_count > 0)) AND `properties`.`template_property_id` IS NULL [["user_id", 1890]]
CACHE (0.0ms) SELECT COUNT(*) FROM `properties` INNER JOIN `property_watchings` ON `properties`.`id` = `property_watchings`.`property_id` WHERE `property_watchings`.`user_id` = 1890 AND (properties.status = 'active' OR (properties.status = 'template' AND properties.units_count > 0)) AND `properties`.`template_property_id` IS NULL [["user_id", 1890]]
Property Exists (0.3ms) SELECT 1 AS one FROM `properties` LEFT OUTER JOIN `residence_clubs` ON `residence_clubs`.`id` = `properties`.`residence_club_id` WHERE `properties`.`user_id` = 1890 AND `properties`.`status` = 'active' AND (residence_club_id IS NULL OR residence_clubs.block_rentals = 0) LIMIT 1
(0.3ms) SELECT SUM(`week_requests`.`held_keys`) FROM `week_requests` WHERE `week_requests`.`user_id` = 1890 AND (week_requests.id != 0) AND `week_requests`.`state` IN ('pending', 'awaiting_owner', 'posted', 'requires_approval')
Property Exists (0.3ms) SELECT 1 AS one FROM `properties` LEFT OUTER JOIN `residence_clubs` ON `residence_clubs`.`id` = `properties`.`residence_club_id` WHERE `properties`.`user_id` = 1890 AND `properties`.`status` = 'active' AND (residence_club_id IS NULL OR residence_clubs.block_rentals = 0) LIMIT 1
ResidenceClub Load (0.4ms) SELECT `residence_clubs`.* FROM `residence_clubs` WHERE `residence_clubs`.`user_id` = 1890
SQL (1.0ms) UPDATE `users` SET `users`.`last_active_at` = '2018-01-02 19:27:46', `users`.`last_user_agent` = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.84 Safari/537.36' WHERE `users`.`type` IN ('Member') AND `users`.`id` = 1890
{"method":"GET","path":"/account","format":"html","controller":"accounts","action":"show","status":200,"duration":2826.65,"view":2637.46,"db":106.85,"current_user":{"id":1890,"login":"johnmaxwell"},"params":{}}
(0.1ms) BEGIN
(0.1ms) COMMIT
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment