Skip to content

Instantly share code, notes, and snippets.

@dlcmh

dlcmh/after_end_date_change.rb

Created December 16, 2019 13:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dlcmh/640894af4ce12be28e9601936f1882c1 to your computer and use it in GitHub Desktop.
Save dlcmh/640894af4ce12be28e9601936f1882c1 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
after_end_date_change.rb
(0.4ms) SET NAMES utf8mb4 COLLATE utf8mb4_polish_ci, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'), @@SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483
User Load (0.3ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 103475 ORDER BY `users`.`id` ASC LIMIT 1
Started PATCH "/offers/12498"
Processing by Admin::OffersController#update as HTML
Parameters: {"utf8"=>"✓", "authenticity_token"=>"VkfT9U/xTCwQ3p8IRzCZ7/FUvoOnnXvPqwiBXu39GLrc+JSUJkyQtcqupxI1qx74WoN1Us3ILEmEtv8WCXePLg==", "offer"=>{"title_en_gb"=>"Private Departure Transfer: Bali Hotels/Accommodations to Denpasar International Airport", "title_zh_cn"=>"", "title_id_id"=>"", "title_th_th"=>"", "title_ms_my"=>"", "destination_id"=>"2", "merchant_id"=>"344", "confirmation_type"=>"24-hours", "partner_name"=>"", "duration"=>"1", "cut_off_time_in_days"=>"1", "summary"=>"Enjoy a hassle-free journey to Denpasar International Airport for your departure flight on this private airport transfer. Meet your friendly driver at your hotel/accommodation lobby before being transported to the airport which will take between 30–60 minutes, depending on your accommodation location. You will travel in a private air-conditioned minivan which accommodates up to 4 people including luggage.", "highlights"=>"* Convenient and affordable transfer to Denpasar International Airport\r\n* Private transfer is operated with just your party and a driver\r\n* Hassle-free and worry-free experience, especially for first-time visitors\r\n* Transfer serves several regions in Bali including Kuta, Seminyak, Ubud, Jimbaran, Nusa Dua and more\r\n* No surcharge for midnight transfers", "description_en_gb"=>"Depart for Denpasar International Airport on a worry-free and hassle-free transfer service that offers pickup from hotels and private residence accommodations across major regions in Bali.\r\n\r\nBe greeted by your warm and friendly driver at the lobby of your Bali hotel or private residence. As your driver helps to load your luggage, take your seat in a comfortable air-conditioned minivan.\r\n\r\nThe journey to the airport ranges between 30 and 60 minutes depending on your accommodation's location. Regions/areas served for this departure airport transfer includes Canggu, Denpasar city, Jimbaran, Kuta, Nusa Dua, Sanur, Seminyak, Tanah Lot, Ubud and Uluwatu (ensure correct option your accommodation area is selected upon booking).\r\n\r\nYour vehicle is private to just you and your party and can accommodate up to 4 people comfortably, including luggage.\r\n\r\nPrice is per person based on 1 to 4 people per vehicle.", "description_zh_cn"=>"", "description_id_id"=>"", "description_th_th"=>"", "description_ms_my"=>"", "inclusions"=>"One-way private transfer from your Bali accommodation to the airport\r\nTransport by private air-conditioned minivan\r\nComplimentary bottled water", "exclusions"=>"Excess luggage charges (where applicable)\r\nGratuities (optional)", "additional_info"=>"Confirmation will be received at time of booking.\r\nInfant seats are available on request if advised at time of booking.\r\nA maximum of 4 people per booking is allowed.\r\nBe sure to select the correct region/areas for your accommodation. A surcharge may be imposed by the local service provider if the accommodation specified is not within the region/area selected.", "warning_info"=>"", "cancellation_policy"=>"<ul><li>Cancellations made at least 3 days prior to scheduled departure is fully refundable. Cancellations made 2 days or less prior to scheduled departure incurs a 100% cancellation fee.</li></ul>", "voucher_requirements"=>"You can present either a paper or an electronic voucher for this activity.", "operates"=>"Daily", "departure_point"=>"Your hotel or private residence in Bali", "departure_time"=>"Flexible", "departure_time_comments"=>"", "duration_in_words"=>"30–60 minutes (depending on location of accommodation)", "return_details"=>"Transfer ends at Denpasar International Airport", "offer_skus_attributes"=>{"0"=>{"skip_update_offer"=>"true", "title"=>"From accommodations in Canggu", "grade_description"=>"", "available_start_at"=>"2017-10-01", "available_end_at"=>"2020-01-02", "included_dates_schedule"=>"{\"validations\":{},\"rule_type\":\"IceCube::DailyRule\",\"interval\":1}", "included_dates_specific"=>"", "excluded_dates_schedule"=>"null", "excluded_dates_specific"=>"2019-03:06,2019-03:07,2019-03:08,2019-12:31,2020-01:01,2020-03:24,2020-03:25", "requires_pickup"=>"0", "age_bands_attributes"=>{"0"=>{"description"=>"Adult", "age_band_names"=>["[{\"description\":\"Adult\",\"plural_description\":\"Adults\"},{\"description\":\"Senior\",\"plural_description\":\"Seniors\"},{\"description\":\"Child\",\"plural_description\":\"Children\"},{\"description\":\"Infant\",\"plural_description\":\"Infants\"},{\"description\":\"Youth\",\"plural_description\":\"Youths\"}]"], "plural_description"=>"Adults", "band_id"=>"1", "group_id"=>"0", "age_from"=>"3", "age_to"=>"99", "price_currency"=>"USD", "price"=>"10.00", "value_price_currency"=>"USD", "value_price"=>"12.50", "commission_currency"=>"USD", "commission"=>"2.00", "merchant_price_currency"=>"USD", "minimum_count_required"=>"4", "maximum_count_required"=>"4", "_destroy"=>"false", "id"=>"5088401"}, "1"=>{"description"=>"Infant", "age_band_names"=>["[{\"description\":\"Adult\",\"plural_description\":\"Adults\"},{\"description\":\"Senior\",\"plural_description\":\"Seniors\"},{\"description\":\"Child\",\"plural_description\":\"Children\"},{\"description\":\"Infant\",\"plural_description\":\"Infants\"},{\"description\":\"Youth\",\"plural_description\":\"Youths\"}]"], "plural_description"=>"Infants", "band_id"=>"2", "group_id"=>"0", "age_from"=>"0", "age_to"=>"2", "price_currency"=>"USD", "price"=>"0.00", "value_price_currency"=>"USD", "value_price"=>"0.00", "commission_currency"=>"USD", "commission"=>"0.00", "merchant_price_currency"=>"USD", "minimum_count_required"=>"0", "maximum_count_required"=>"1", "_destroy"=>"false", "id"=>"5088402"}, "2"=>{"description"=>"Adult", "age_band_names"=>["[{\"description\":\"Adult\",\"plural_description\":\"Adults\"},{\"description\":\"Senior\",\"plural_description\":\"Seniors\"},{\"description\":\"Child\",\"plural_description\":\"Children\"},{\"description\":\"Infant\",\"plural_description\":\"Infants\"},{\"description\":\"Youth\",\"plural_description\":\"Youths\"}]"], "plural_description"=>"Adults", "band_id"=>"1", "group_id"=>"1", "age_from"=>"3", "age_to"=>"99", "price_currency"=>"USD", "price"=>"13.40", "value_price_currency"=>"USD", "value_price"=>"16.75", "commission_currency"=>"USD", "commission"=>"2.74", "merchant_price_currency"=>"USD", "minimum_count_required"=>"3", "maximum_count_required"=>"3", "_destroy"=>"false", "id"=>"5088403"}, "3"=>{"description"=>"Infant", "age_band_names"=>["[{\"description\":\"Adult\",\"plural_description\":\"Adults\"},{\"description\":\"Senior\",\"plural_description\":\"Seniors\"},{\"description\":\"Child\",\"plural_description\":\"Children\"},{\"description\":\"Infant\",\"plural_description\":\"Infants\"},{\"description\":\"Youth\",\"plural_description\":\"Youths\"}]"], "plural_description"=>"Infants", "band_id"=>"2", "group_id"=>"1", "age_from"=>"0", "age_to"=>"2", "price_currency"=>"USD", "price"=>"0.00", "value_price_currency"=>"USD", "value_price"=>"0.00", "commission_currency"=>"USD", "commission"=>"0.00", "merchant_price_currency"=>"USD", "minimum_count_required"=>"0", "maximum_count_required"=>"2", "_destroy"=>"false", "id"=>"5088404"}, "4"=>{"description"=>"Adult", "age_band_names"=>["[{\"description\":\"Adult\",\"plural_description\":\"Adults\"},{\"description\":\"Senior\",\"plural_description\":\"Seniors\"},{\"description\":\"Child\",\"plural_description\":\"Children\"},{\"description\":\"Infant\",\"plural_description\":\"Infants\"},{\"description\":\"Youth\",\"plural_description\":\"Youths\"}]"], "plural_description"=>"Adults", "band_id"=>"1", "group_id"=>"2", "age_from"=>"3", "age_to"=>"99", "price_currency"=>"USD", "price"=>"20.00", "value_price_currency"=>"USD", "value_price"=>"25.00", "commission_currency"=>"USD", "commission"=>"4.00", "merchant_price_currency"=>"USD", "minimum_count_required"=>"2", "maximum_count_required"=>"2", "_destroy"=>"false", "id"=>"5088405"}, "5"=>{"description"=>"Infant", "age_band_names"=>["[{\"description\":\"Adult\",\"plural_description\":\"Adults\"},{\"description\":\"Senior\",\"plural_description\":\"Seniors\"},{\"description\":\"Child\",\"plural_description\":\"
Role Load (0.3ms) SELECT `roles`.* FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 103475
Offer Load (0.4ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
(0.2ms) BEGIN
Offer::Translation Load (0.3ms) SELECT `offer_translations`.* FROM `offer_translations` WHERE `offer_translations`.`offer_id` = 12498
Location Load (0.2ms) SELECT `locations`.* FROM `locations` WHERE `locations`.`offer_id` = 12498 AND `locations`.`id` = 13164
OfferSku Load (0.6ms) SELECT `offer_skus`.* FROM `offer_skus` WHERE `offer_skus`.`offer_id` = 12498 AND `offer_skus`.`id` IN (28462, 58458, 58459, 58460, 58461, 58462, 58463, 58464, 58465, 58466)
AgeBand Load (0.3ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 28462 AND `age_bands`.`group_id` IS NOT NULL AND `age_bands`.`id` IN (5088401, 5088402, 5088403, 5088404, 5088405, 5088406, 5088407, 5088408)
BookingQuestion Load (0.4ms) SELECT `booking_questions`.* FROM `booking_questions` INNER JOIN `booking_questions_offer_skus` ON `booking_questions`.`id` = `booking_questions_offer_skus`.`booking_question_id` WHERE `booking_questions_offer_skus`.`offer_sku_id` = 28462 AND `booking_questions`.`id` IN (1626, 1627, 1628, 1629, 1630)
AgeBand Load (0.5ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58458 AND `age_bands`.`group_id` IS NOT NULL AND `age_bands`.`id` IN (5263423, 5263424, 5263425, 5263426, 5263427, 5263428, 5263429, 5263430)
BookingQuestion Load (0.5ms) SELECT `booking_questions`.* FROM `booking_questions` INNER JOIN `booking_questions_offer_skus` ON `booking_questions`.`id` = `booking_questions_offer_skus`.`booking_question_id` WHERE `booking_questions_offer_skus`.`offer_sku_id` = 58458 AND `booking_questions`.`id` IN (1631, 1632, 1633, 1634, 1635)
AgeBand Load (0.5ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58459 AND `age_bands`.`group_id` IS NOT NULL AND `age_bands`.`id` IN (5263431, 5263432, 5263433, 5263434, 5263435, 5263436, 5263437, 5263438)
BookingQuestion Load (0.5ms) SELECT `booking_questions`.* FROM `booking_questions` INNER JOIN `booking_questions_offer_skus` ON `booking_questions`.`id` = `booking_questions_offer_skus`.`booking_question_id` WHERE `booking_questions_offer_skus`.`offer_sku_id` = 58459 AND `booking_questions`.`id` IN (1636, 1637, 1638, 1639, 1640)
AgeBand Load (0.6ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58460 AND `age_bands`.`group_id` IS NOT NULL AND `age_bands`.`id` IN (5263439, 5263440, 5263441, 5263442, 5263443, 5263444, 5263445, 5263446)
BookingQuestion Load (0.5ms) SELECT `booking_questions`.* FROM `booking_questions` INNER JOIN `booking_questions_offer_skus` ON `booking_questions`.`id` = `booking_questions_offer_skus`.`booking_question_id` WHERE `booking_questions_offer_skus`.`offer_sku_id` = 58460 AND `booking_questions`.`id` IN (1641, 1642, 1643, 1644, 1645)
AgeBand Load (0.5ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58461 AND `age_bands`.`group_id` IS NOT NULL AND `age_bands`.`id` IN (5263447, 5263448, 5263449, 5263450, 5263451, 5263452, 5263453, 5263454)
BookingQuestion Load (0.3ms) SELECT `booking_questions`.* FROM `booking_questions` INNER JOIN `booking_questions_offer_skus` ON `booking_questions`.`id` = `booking_questions_offer_skus`.`booking_question_id` WHERE `booking_questions_offer_skus`.`offer_sku_id` = 58461 AND `booking_questions`.`id` IN (1646, 1647, 1648, 1649, 1650)
AgeBand Load (0.4ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58462 AND `age_bands`.`group_id` IS NOT NULL AND `age_bands`.`id` IN (5263455, 5263456, 5263457, 5263458, 5263459, 5263460, 5263461, 5263462)
BookingQuestion Load (0.9ms) SELECT `booking_questions`.* FROM `booking_questions` INNER JOIN `booking_questions_offer_skus` ON `booking_questions`.`id` = `booking_questions_offer_skus`.`booking_question_id` WHERE `booking_questions_offer_skus`.`offer_sku_id` = 58462 AND `booking_questions`.`id` IN (1651, 1652, 1653, 1654, 1655)
AgeBand Load (0.4ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58463 AND `age_bands`.`group_id` IS NOT NULL AND `age_bands`.`id` IN (5263463, 5263464, 5263465, 5263466, 5263467, 5263468, 5263469, 5263470)
BookingQuestion Load (0.4ms) SELECT `booking_questions`.* FROM `booking_questions` INNER JOIN `booking_questions_offer_skus` ON `booking_questions`.`id` = `booking_questions_offer_skus`.`booking_question_id` WHERE `booking_questions_offer_skus`.`offer_sku_id` = 58463 AND `booking_questions`.`id` IN (1659, 1660, 1661, 1662, 1663)
AgeBand Load (0.4ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58464 AND `age_bands`.`group_id` IS NOT NULL AND `age_bands`.`id` IN (5263471, 5263472, 5263473, 5263474, 5263475, 5263476, 5263477, 5263478)
BookingQuestion Load (0.5ms) SELECT `booking_questions`.* FROM `booking_questions` INNER JOIN `booking_questions_offer_skus` ON `booking_questions`.`id` = `booking_questions_offer_skus`.`booking_question_id` WHERE `booking_questions_offer_skus`.`offer_sku_id` = 58464 AND `booking_questions`.`id` IN (1664, 1665, 1666, 1667, 1668)
AgeBand Load (0.5ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58465 AND `age_bands`.`group_id` IS NOT NULL AND `age_bands`.`id` IN (5263479, 5263480, 5263481, 5263482, 5263483, 5263484, 5263485, 5263486)
BookingQuestion Load (0.4ms) SELECT `booking_questions`.* FROM `booking_questions` INNER JOIN `booking_questions_offer_skus` ON `booking_questions`.`id` = `booking_questions_offer_skus`.`booking_question_id` WHERE `booking_questions_offer_skus`.`offer_sku_id` = 58465 AND `booking_questions`.`id` IN (1669, 1670, 1671, 1672, 1673)
AgeBand Load (0.4ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58466 AND `age_bands`.`group_id` IS NOT NULL AND `age_bands`.`id` IN (5263487, 5263488, 5263489, 5263490, 5263491, 5263492, 5263493, 5263494)
BookingQuestion Load (0.4ms) SELECT `booking_questions`.* FROM `booking_questions` INNER JOIN `booking_questions_offer_skus` ON `booking_questions`.`id` = `booking_questions_offer_skus`.`booking_question_id` WHERE `booking_questions_offer_skus`.`offer_sku_id` = 58466 AND `booking_questions`.`id` IN (1674, 1675, 1676, 1677, 1678)
Merchant Load (0.2ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
Destination Load (0.3ms) SELECT `destinations`.* FROM `destinations` WHERE `destinations`.`id` = 2 LIMIT 1
AgeBand Load (0.4ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 28462 AND `age_bands`.`group_id` IS NOT NULL
[Geo] geocode_with_fallback
OfferSku Load (0.5ms) SELECT `offer_skus`.* FROM `offer_skus` WHERE `offer_skus`.`offer_id` = 12498
AgeBand Load (0.4ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58458 AND `age_bands`.`group_id` IS NOT NULL
AgeBand Load (0.4ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58459 AND `age_bands`.`group_id` IS NOT NULL
AgeBand Load (0.3ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58460 AND `age_bands`.`group_id` IS NOT NULL
AgeBand Load (0.4ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58461 AND `age_bands`.`group_id` IS NOT NULL
AgeBand Load (0.4ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58462 AND `age_bands`.`group_id` IS NOT NULL
AgeBand Load (0.4ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58463 AND `age_bands`.`group_id` IS NOT NULL
AgeBand Load (0.3ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58464 AND `age_bands`.`group_id` IS NOT NULL
AgeBand Load (0.4ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58465 AND `age_bands`.`group_id` IS NOT NULL
AgeBand Load (0.4ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58466 AND `age_bands`.`group_id` IS NOT NULL
OfferSku Update (11.8ms) UPDATE `offer_skus` SET `available_end_at` = '2020-01-02', `updated_at` = '2019-12-16 13:04:36', `available_dates` = '---\n2017-10:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n- \'29\'\n- \'30\'\n- \'31\'\n2017-11:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n- \'29\'\n- \'30\'\n2017-12:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n- \'29\'\n- \'30\'\n- \'31\'\n2018-01:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n- \'29\'\n- \'30\'\n- \'31\'\n2018-02:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n2018-03:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n- \'29\'\n- \'30\'\n- \'31\'\n2018-04:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n- \'29\'\n- \'30\'\n2018-05:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n- \'29\'\n- \'30\'\n- \'31\'\n2018-06:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n- \'29\'\n- \'30\'\n2018-07:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n- \'29\'\n- \'30\'\n- \'31\'\n2018-08:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n- \'29\'\n- \'30\'\n- \'31\'\n2018-09:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n- \'29\'\n- \'30\'\n2018-10:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n- \'29\'\n- \'30\'\n- \'31\'\n2018-11:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n- \'29\'\n- \'30\'\n2018-12:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n- \'29\'\n- \'30\'\n- \'31\'\n2019-01:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n- \'29\'\n- \'30\'\n- \'31\'\n2019-02:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n2019-03:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n- \'29\'\n- \'30\'\n- \'31\'\n2019-04:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n- \'29\'\n- \'30\'\n2019-05:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n- \'29\'\n- \'30\'\n- \'31\'\n2019-06:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n- \'29\'\n- \'30\'\n2019-07:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n- \'29\'\n- \'30\'\n- \'31\'\n2019-08:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n- \'29\'\n- \'30\'\n- \'31\'\n2019-09:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n- \'29\'\n- \'30\'\n2019-10:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\n- \'19\'\n- \'20\'\n- \'21\'\n- \'22\'\n- \'23\'\n- \'24\'\n- \'25\'\n- \'26\'\n- \'27\'\n- \'28\'\n- \'29\'\n- \'30\'\n- \'31\'\n2019-11:\n- \'01\'\n- \'02\'\n- \'03\'\n- \'04\'\n- \'05\'\n- \'06\'\n- \'07\'\n- \'08\'\n- \'09\'\n- \'10\'\n- \'11\'\n- \'12\'\n- \'13\'\n- \'14\'\n- \'15\'\n- \'16\'\n- \'17\'\n- \'18\'\
(12.0ms) SELECT COUNT(*) FROM `offers` WHERE `offers`.`destination_id` = 2 AND `offers`.`is_published` = TRUE AND `offers`.`is_available` = TRUE AND `offers`.`is_shown` = TRUE
Offer Update (0.3ms) UPDATE `offers` SET `updated_at` = '2019-12-16 13:04:36' WHERE `offers`.`id` = 12498
Offers::Variant Load (0.6ms) SELECT `offer_skus`.* FROM `offer_skus` WHERE `offer_skus`.`offer_id` = 12498
Offer Load (0.4ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
Merchant Load (0.2ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offers::Variant Load (0.0ms) SELECT `offer_skus`.* FROM `offer_skus` WHERE `offer_skus`.`offer_id` = 12498
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offers::Variant Load (0.0ms) SELECT `offer_skus`.* FROM `offer_skus` WHERE `offer_skus`.`offer_id` = 12498
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
CACHE Offer Load (0.0ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
CACHE Merchant Load (0.0ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
Offer Update (0.3ms) UPDATE `offers` SET `updated_at` = '2019-12-16 13:04:37', `available_last_date` = '2020-01-02' WHERE `offers`.`id` = 12498
(10.4ms) SELECT COUNT(*) FROM `offers` WHERE `offers`.`destination_id` = 2 AND `offers`.`is_published` = TRUE AND `offers`.`is_available` = TRUE AND `offers`.`is_shown` = TRUE
(7.3ms) COMMIT
Completed 302 Found in 2157.491ms
User Load (0.4ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 103475 ORDER BY `users`.`id` ASC LIMIT 1
Started GET "/offers/12498"
Processing by Admin::OffersController#show as HTML
Parameters: {"id"=>"12498"}
Role Load (0.3ms) SELECT `roles`.* FROM `roles` INNER JOIN `roles_users` ON `roles`.`id` = `roles_users`.`role_id` WHERE `roles_users`.`user_id` = 103475
Offer Load (0.4ms) SELECT `offers`.* FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
Offer Exists (0.2ms) SELECT 1 AS one FROM `offers` WHERE `offers`.`id` = 12498 LIMIT 1
Location Load (18.3ms) SELECT `locations`.* FROM `locations` WHERE `locations`.`offer_id` = 12498
ActsAsTaggableOn::Tagging Load (1.3ms) SELECT `taggings`.* FROM `taggings` WHERE `taggings`.`taggable_id` = 13164 AND `taggings`.`taggable_type` = 'Location'
ActsAsTaggableOn::Tag Load (1.2ms) SELECT `tags`.* FROM `tags` INNER JOIN `taggings` ON `tags`.`id` = `taggings`.`tag_id` WHERE `taggings`.`taggable_id` = 13164 AND `taggings`.`taggable_type` = 'Location' AND (taggings.context = 'tags' AND taggings.tagger_id IS NULL)
Offer::Translation Load (0.4ms) SELECT `offer_translations`.* FROM `offer_translations` WHERE `offer_translations`.`offer_id` = 12498
OfferSku Exists (0.3ms) SELECT 1 AS one FROM `offer_skus` WHERE `offer_skus`.`offer_id` = 12498 LIMIT 1
CACHE OfferSku Exists (0.0ms) SELECT 1 AS one FROM `offer_skus` WHERE `offer_skus`.`offer_id` = 12498 LIMIT 1
OfferSku Load (0.6ms) SELECT `offer_skus`.* FROM `offer_skus` WHERE `offer_skus`.`offer_id` = 12498
Merchant Load (0.3ms) SELECT `merchants`.* FROM `merchants` WHERE `merchants`.`id` = 344 LIMIT 1
Touristly::Currency Load (0.3ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1
CACHE OfferSku Load (0.0ms) SELECT `offer_skus`.* FROM `offer_skus` WHERE `offer_skus`.`offer_id` = 12498
AgeBand Load (0.7ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`group_id` IS NOT NULL AND `age_bands`.`offer_sku_id` IN (28462, 58458, 58459, 58460, 58461, 58462, 58463, 58464, 58465, 58466)
Rendered application/_offer_admin_buttons.html.haml (4.1ms)
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
AgeBand Exists (0.4ms) SELECT 1 AS one FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 28462 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") LIMIT 1
AgeBand Load (0.3ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 28462 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") ORDER BY `age_bands`.`id` ASC LIMIT 1
CACHE AgeBand Exists (0.0ms) SELECT 1 AS one FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 28462 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") LIMIT 1
CACHE AgeBand Load (0.0ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 28462 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") ORDER BY `age_bands`.`id` ASC LIMIT 1
CACHE Touristly::Currency Load (0.1ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
AgeBand Exists (0.3ms) SELECT 1 AS one FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58458 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") LIMIT 1
AgeBand Load (0.2ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58458 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") ORDER BY `age_bands`.`id` ASC LIMIT 1
CACHE AgeBand Exists (0.0ms) SELECT 1 AS one FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58458 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") LIMIT 1
CACHE AgeBand Load (0.0ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58458 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") ORDER BY `age_bands`.`id` ASC LIMIT 1
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
AgeBand Exists (0.3ms) SELECT 1 AS one FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58459 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") LIMIT 1
AgeBand Load (0.3ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58459 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") ORDER BY `age_bands`.`id` ASC LIMIT 1
CACHE AgeBand Exists (0.0ms) SELECT 1 AS one FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58459 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") LIMIT 1
CACHE AgeBand Load (0.0ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58459 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") ORDER BY `age_bands`.`id` ASC LIMIT 1
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
AgeBand Exists (0.3ms) SELECT 1 AS one FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58460 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") LIMIT 1
AgeBand Load (0.3ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58460 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") ORDER BY `age_bands`.`id` ASC LIMIT 1
CACHE AgeBand Exists (0.0ms) SELECT 1 AS one FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58460 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") LIMIT 1
CACHE AgeBand Load (0.0ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58460 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") ORDER BY `age_bands`.`id` ASC LIMIT 1
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
AgeBand Exists (0.3ms) SELECT 1 AS one FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58461 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") LIMIT 1
AgeBand Load (0.3ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58461 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") ORDER BY `age_bands`.`id` ASC LIMIT 1
CACHE AgeBand Exists (0.0ms) SELECT 1 AS one FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58461 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") LIMIT 1
CACHE AgeBand Load (0.0ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58461 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") ORDER BY `age_bands`.`id` ASC LIMIT 1
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
AgeBand Exists (0.3ms) SELECT 1 AS one FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58462 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") LIMIT 1
AgeBand Load (0.3ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58462 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") ORDER BY `age_bands`.`id` ASC LIMIT 1
CACHE AgeBand Exists (0.0ms) SELECT 1 AS one FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58462 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") LIMIT 1
CACHE AgeBand Load (0.0ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58462 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") ORDER BY `age_bands`.`id` ASC LIMIT 1
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
AgeBand Exists (0.3ms) SELECT 1 AS one FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58463 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") LIMIT 1
AgeBand Load (0.3ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58463 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") ORDER BY `age_bands`.`id` ASC LIMIT 1
CACHE AgeBand Exists (0.0ms) SELECT 1 AS one FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58463 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") LIMIT 1
CACHE AgeBand Load (0.0ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58463 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") ORDER BY `age_bands`.`id` ASC LIMIT 1
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
AgeBand Exists (0.3ms) SELECT 1 AS one FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58464 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") LIMIT 1
AgeBand Load (0.3ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58464 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") ORDER BY `age_bands`.`id` ASC LIMIT 1
CACHE AgeBand Exists (0.0ms) SELECT 1 AS one FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58464 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") LIMIT 1
CACHE AgeBand Load (0.0ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58464 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") ORDER BY `age_bands`.`id` ASC LIMIT 1
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
AgeBand Exists (0.3ms) SELECT 1 AS one FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58465 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") LIMIT 1
AgeBand Load (0.3ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58465 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") ORDER BY `age_bands`.`id` ASC LIMIT 1
CACHE AgeBand Exists (0.0ms) SELECT 1 AS one FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58465 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") LIMIT 1
CACHE AgeBand Load (0.0ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58465 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") ORDER BY `age_bands`.`id` ASC LIMIT 1
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
AgeBand Exists (0.4ms) SELECT 1 AS one FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58466 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") LIMIT 1
AgeBand Load (0.3ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58466 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") ORDER BY `age_bands`.`id` ASC LIMIT 1
CACHE AgeBand Exists (0.0ms) SELECT 1 AS one FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58466 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") LIMIT 1
CACHE AgeBand Load (0.0ms) SELECT `age_bands`.* FROM `age_bands` WHERE `age_bands`.`offer_sku_id` = 58466 AND `age_bands`.`group_id` IS NOT NULL AND (treat_as_adult = 1 OR age_bands.description = "Adult") ORDER BY `age_bands`.`id` ASC LIMIT 1
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
CACHE Touristly::Currency Load (0.0ms) SELECT `currencies`.* FROM `currencies` WHERE `currencies`.`code` = 'USD' LIMIT 1 [["code", "USD"], ["LIMIT", 1]]
Rendered admin/offers/_submenu.slim (3.0ms)
Rendered admin/offers/show.html.slim within layouts/application (336.6ms)
Rendered application/_head.html.haml (98.2ms)
Rendered application/_navbar.html.slim (32.4ms)
Completed 200 OK in 730.5390000000001ms
@dlcmh
Copy link
Author

dlcmh commented Oct 31, 2020

hello

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment