hotelbeds response

hotelbeds-orders-temp-rs.json

{"data":{"hotel_id":2131673,"user_id":null,"total":294.11,"origin_total":294.11,"currency":"EUR","status":"temp","start_at":{"date":"2021-12-27 00:00:00.000000","timezone_type":3,"timezone":"UTC"},"end_at":{"date":"2021-12-30 00:00:00.000000","timezone_type":3,"timezone":"UTC"},"untaxed_price":243.06363636363633,"vat":26.74,"fee":24.30636363636367,"discount":0,"exchange_rate_version":"2021-12-13","bed_adult_price":0,"bed_child_price":0,"tax_number":null,"lang":"zh_tw","mail_token":"0b67ca20a941bf1d4a424a5eec986a14","customer_auth_type":null,"ga_client_id":"797704552.1639038877","source":"hotelbeds","meal_type":0,"from":"owljourney","is_prepaid":false,"updated_at":"2021-12-14 02:42:09","created_at":"2021-12-14 02:42:09","id":2426,"order_serial":"OWJ8190421121402426","pms_order_serial":"OWJ8190421121402426","items":[{"id":5332,"order_id":2426,"plan_id":9921165,"room_id":61717,"date":"2021-12-27","total_price":"294.11","count":1,"price":"294.11","discount":"0.00","bed_infant":0,"bed_child":0,"bed_adult":0,"cancel_policy_id":1,"created_at":"2021-12-14 02:42:09","updated_at":"2021-12-14 02:42:09","deleted_at":null,"ota_room":{"id":61717,"hotel_id":2131673,"name":"DBL.SU","status":0,"_price":"0.00","_currency":"TWD","stock_count":0,"sort":0,"open":1,"created_at":"2021-12-07 10:21:44","updated_at":"2021-12-07 10:21:44","ota_room_id":"124623.DBL.SU","ota_type":2,"meta":null,"meta_translations":[]},"ota_plan":{"id":9921165,"hotel_id":2131673,"name":"DOUBLE SUPERIOR \/ BED AND BREAKFAST","status":0,"_price":"0.00","_currency":"TWD","min_stay":0,"max_stay":0,"booking_interval":0,"cancel_policy_id":1,"can_booking":1,"sort":0,"breakfast_count":1,"is_flexible":0,"flexible_room_list":"","base_plan_id":0,"_flexible_type":null,"is_ota_plan":1,"created_at":"2021-12-14 02:42:09","updated_at":"2021-12-14 02:42:09","deleted_at":null,"ota_plan_id":"20211227|20211230|W|514|124623|DBL.SU|BA","ota_type":2,"cancel_policy":{"id":1,"hotel_id":2,"name":"\u4e0d\u53ef\u9000\u8cbb!","content":"\"\\u5982\\u9867\\u5ba2\\u672a\\u5982\\u671f\\u5165\\u4f4f\\uff0c\\u5c07\\u6536\\u53d6\\u9810\\u8a02\\u7e3d\\u91d1\\u984d\\u5168\\u984d\\u3002\"","created_at":"2018-02-28 09:13:02","updated_at":"2018-02-28 09:13:02"}}},{"id":5333,"order_id":2426,"plan_id":9921165,"room_id":61717,"date":"2021-12-28","total_price":"294.11","count":1,"price":"294.11","discount":"0.00","bed_infant":0,"bed_child":0,"bed_adult":0,"cancel_policy_id":1,"created_at":"2021-12-14 02:42:09","updated_at":"2021-12-14 02:42:09","deleted_at":null,"ota_room":{"id":61717,"hotel_id":2131673,"name":"DBL.SU","status":0,"_price":"0.00","_currency":"TWD","stock_count":0,"sort":0,"open":1,"created_at":"2021-12-07 10:21:44","updated_at":"2021-12-07 10:21:44","ota_room_id":"124623.DBL.SU","ota_type":2,"meta":null,"meta_translations":[]},"ota_plan":{"id":9921165,"hotel_id":2131673,"name":"DOUBLE SUPERIOR \/ BED AND BREAKFAST","status":0,"_price":"0.00","_currency":"TWD","min_stay":0,"max_stay":0,"booking_interval":0,"cancel_policy_id":1,"can_booking":1,"sort":0,"breakfast_count":1,"is_flexible":0,"flexible_room_list":"","base_plan_id":0,"_flexible_type":null,"is_ota_plan":1,"created_at":"2021-12-14 02:42:09","updated_at":"2021-12-14 02:42:09","deleted_at":null,"ota_plan_id":"20211227|20211230|W|514|124623|DBL.SU|BA","ota_type":2,"cancel_policy":{"id":1,"hotel_id":2,"name":"\u4e0d\u53ef\u9000\u8cbb!","content":"\"\\u5982\\u9867\\u5ba2\\u672a\\u5982\\u671f\\u5165\\u4f4f\\uff0c\\u5c07\\u6536\\u53d6\\u9810\\u8a02\\u7e3d\\u91d1\\u984d\\u5168\\u984d\\u3002\"","created_at":"2018-02-28 09:13:02","updated_at":"2018-02-28 09:13:02"}}},{"id":5334,"order_id":2426,"plan_id":9921165,"room_id":61717,"date":"2021-12-29","total_price":"294.11","count":1,"price":"294.11","discount":"0.00","bed_infant":0,"bed_child":0,"bed_adult":0,"cancel_policy_id":1,"created_at":"2021-12-14 02:42:09","updated_at":"2021-12-14 02:42:09","deleted_at":null,"ota_room":{"id":61717,"hotel_id":2131673,"name":"DBL.SU","status":0,"_price":"0.00","_currency":"TWD","stock_count":0,"sort":0,"open":1,"created_at":"2021-12-07 10:21:44","updated_at":"2021-12-07 10:21:44","ota_room_id":"124623.DBL.SU","ota_type":2,"meta":null,"meta_translations":[]},"ota_plan":{"id":9921165,"hotel_id":2131673,"name":"DOUBLE SUPERIOR \/ BED AND BREAKFAST","status":0,"_price":"0.00","_currency":"TWD","min_stay":0,"max_stay":0,"booking_interval":0,"cancel_policy_id":1,"can_booking":1,"sort":0,"breakfast_count":1,"is_flexible":0,"flexible_room_list":"","base_plan_id":0,"_flexible_type":null,"is_ota_plan":1,"created_at":"2021-12-14 02:42:09","updated_at":"2021-12-14 02:42:09","deleted_at":null,"ota_plan_id":"20211227|20211230|W|514|124623|DBL.SU|BA","ota_type":2,"cancel_policy":{"id":1,"hotel_id":2,"name":"\u4e0d\u53ef\u9000\u8cbb!","content":"\"\\u5982\\u9867\\u5ba2\\u672a\\u5982\\u671f\\u5165\\u4f4f\\uff0c\\u5c07\\u6536\\u53d6\\u9810\\u8a02\\u7e3d\\u91d1\\u984d\\u5168\\u984d\\u3002\"","created_at":"2018-02-28 09:13:02","updated_at":"2018-02-28 09:13:02"}}},{"id":5335,"order_id":2426,"plan_id":9921165,"room_id":61717,"date":"2021-12-30","total_price":"294.11","count":1,"price":"294.11","discount":"0.00","bed_infant":0,"bed_child":0,"bed_adult":0,"cancel_policy_id":1,"created_at":"2021-12-14 02:42:09","updated_at":"2021-12-14 02:42:09","deleted_at":null,"ota_room":{"id":61717,"hotel_id":2131673,"name":"DBL.SU","status":0,"_price":"0.00","_currency":"TWD","stock_count":0,"sort":0,"open":1,"created_at":"2021-12-07 10:21:44","updated_at":"2021-12-07 10:21:44","ota_room_id":"124623.DBL.SU","ota_type":2,"meta":null,"meta_translations":[]},"ota_plan":{"id":9921165,"hotel_id":2131673,"name":"DOUBLE SUPERIOR \/ BED AND BREAKFAST","status":0,"_price":"0.00","_currency":"TWD","min_stay":0,"max_stay":0,"booking_interval":0,"cancel_policy_id":1,"can_booking":1,"sort":0,"breakfast_count":1,"is_flexible":0,"flexible_room_list":"","base_plan_id":0,"_flexible_type":null,"is_ota_plan":1,"created_at":"2021-12-14 02:42:09","updated_at":"2021-12-14 02:42:09","deleted_at":null,"ota_plan_id":"20211227|20211230|W|514|124623|DBL.SU|BA","ota_type":2,"cancel_policy":{"id":1,"hotel_id":2,"name":"\u4e0d\u53ef\u9000\u8cbb!","content":"\"\\u5982\\u9867\\u5ba2\\u672a\\u5982\\u671f\\u5165\\u4f4f\\uff0c\\u5c07\\u6536\\u53d6\\u9810\\u8a02\\u7e3d\\u91d1\\u984d\\u5168\\u984d\\u3002\"","created_at":"2018-02-28 09:13:02","updated_at":"2018-02-28 09:13:02"}}}],"ota_hotel":{"id":2131673,"name":"\u53f0\u5317\u798f\u83ef\u5927\u98ef\u5e97","hotel_uuid":"571208f9-fad9-4520-9adf-6dacecc14f68","user_id":0,"can_booking":1,"currency":"EUR","language":"en","booking_interval":0,"timezone":"","atm_interval":0,"owlpayment_customer_token":null,"is_sync_to_ota":1,"is_legal":1,"be_version":null,"can_ota_booking":1,"can_es_search":1,"created_at":"2021-12-07 10:21:44","updated_at":"2021-12-08 03:04:34","deleted_at":null,"ota_hotel_id":"124623","ota_type":2,"meta":{"id":2072662,"hotel_id":2131673,"accommodation_type":204,"accommodation_type_string":"Hotel","type":"hotel","content":"","latitude":"25.037805","longitude":"121.543312","address":"\u4ec1\u611b\u8def\u4e09\u6bb5 160 \u865f, 160, \u53f0\u5317\u5e02, TW","features":"","ota_receipt_type":null,"ota_payment_type":null,"stars":"0.00","check_in_start_time_at":"18:00:00","check_in_end_time_at":"01:00:00","check_out_time_at":"12:00:00","is_allow_early_check_in":null,"allow_early_check_in_price_per_hour":null,"is_allow_late_check_out":null,"allow_late_check_out_price_per_hour":null,"is_extra_resident_available":null,"created_at":"2021-12-07 10:21:44","updated_at":"2021-12-08 03:03:45"},"meta_translations":[{"id":235755920,"trans_id":2131673,"trans_type":"App\\Models\\OTA\\Hotel","column":"address","lang":"en","text":"\u4ec1\u611b\u8def\u4e09\u6bb5 160 \u865f, 160, \u53f0\u5317\u5e02, TW","created_at":"2021-12-07 10:21:44","updated_at":"2021-12-08 03:03:45"},{"id":235755919,"trans_id":2131673,"trans_type":"App\\Models\\OTA\\Hotel","column":"description","lang":"en","text":"\u9019\u95935\u661f\u7d1a\u8c6a\u83ef\u9152\u5e97\u4f4d\u65bc\u53f0\u5317\u5546\u696d\u5340\u4e2d\u5fc3\u5730\u5e36\uff0c\u5468\u570d\u6709\u773e\u591a\u5a1b\u6a02\u8cfc\u7269\u5efa\u7bc9\u7fa4\u3002\u9152\u5e97\u8ddd\u5fe0\u5b5d\u5fa9\u8208\u6377\u904b\u7ad9\u50c57\u5206\u9418\u6b65\u884c\u8def\u7a0b\u3002\u540c\u6642\u63d0\u4f9b\u6709\u5ba4\u5916\u6cf3\u6c60\u3001\u6851\u62ff\u8a2d\u65bd\u548c\u73fe\u5834\u514d\u8cbb\u505c\u8eca\u5834\u3002\u5ba2\u623f\u5ba4\u5167\u88dd\u4fee\u5341\u5206\u73fe\u4ee3\u5316\uff0c\u914d\u5099\u6709\u8ff7\u4f60\u5427\u3001\u6ce1\u8336\/\u716e\u5496\u5561\u8a2d\u65bd\u548c\u5e73\u677f\u96fb\u8996\u3002\u5957\u9593\u81e5\u5ba4\u5167\u8a2d\u63d0\u4f9b\u6709\u5316\u599d\u7528\u5177\u548c\u6dcb\u6d74\u9593\u3002\u623f\u5ba2\u53ef\u5728\u5065\u8eab\u4e2d\u5fc3\u6216\u6c27\u5427\u904b\u52d5\u5065\u8eab\u3002\u65c5\u904a\u6ac3\u81fa\u53ef\u4ee5\u5e6b\u52a9\u65c5\u5ba2\u5b89\u6392\u65c5\u904a\u884c\u7a0b\u3002\u9152\u5e97\u5167\u9084\u8a2d\u6709\u8cfc\u7269\u4e2d\u5fc3\u3002Rosewood\u9910\u5ef3\u53ef\u63d0\u4f9b\u6cd5\u570b\u83dc\u3002\u9152\u5e97\u5167\u7684\u9910\u5ef3\u53ef\u63d0\u4f9b\u5404\u985e\u4e9e\u6d32\u7279\u8272\u83dc\u991a\u548c\u897f\u9910\u3002","created_at":"2021-12-07 10:21:44","updated_at":"2021-12-08 03:03:45"},{"id":235755918,"trans_id":2131673,"trans_type":"App\\Models\\OTA\\Hotel","column":"name","lang":"en","text":"\u53f0\u5317\u798f\u83ef\u5927\u98ef\u5e97","created_at":"2021-12-07 10:21:44","updated_at":"2021-12-08 03:03:45"}],"places":[]},"order_customers":[{"id":5929,"order_id":2426,"type":"customer","first_name":"","last_name":"","email":"","phone":"","created_at":"2021-12-14 02:42:09","updated_at":"2021-12-14 02:42:09","deleted_at":null,"gender":"unknown","phone_code":"","age":-1},{"id":5930,"order_id":2426,"type":"traveler","first_name":"","last_name":"","email":"","phone":"","created_at":"2021-12-14 02:42:09","updated_at":"2021-12-14 02:42:09","deleted_at":null,"gender":"unknown","phone_code":"","age":-1}],"order_meta":null,"user_coupon":null,"extras":[],"order_caches":[],"payments":[],"partial_refunds":[]},"status":200,"debug":{"database":{"total":53,"items":[{"connection":"mysql","query":"select * from `Hotel` where `hotel_uuid` = '571208f9-fad9-4520-9adf-6dacecc14f68' and `Hotel`.`deleted_at` is null limit 1;","time":1.94},{"connection":"mysql","query":"select * from `HotelMeta` where `HotelMeta`.`hotel_id` = '2131673' and `HotelMeta`.`hotel_id` is not null and `type` = 'hotel' limit 1;","time":0.72},{"connection":"PMSdb","query":"select `Place`.*, `owlnest_ota`.`HotelPlace`.`hotel_id` as `pivot_hotel_id`, `owlnest_ota`.`HotelPlace`.`place_id` as `pivot_place_id` from `Place` inner join `owlnest_ota`.`HotelPlace` on `Place`.`id` = `owlnest_ota`.`HotelPlace`.`place_id` where `owlnest_ota`.`HotelPlace`.`hotel_id` = '2131673';","time":87.16},{"connection":"mysql","query":"select * from `Room` where `Room`.`hotel_id` = '2131673' and `Room`.`hotel_id` is not null;","time":0.74},{"connection":"mysql","query":"INSERT INTO owlnest_ota.Plan (`hotel_id`, `name`, `status`, `min_stay`, `max_stay`, `booking_interval`, `cancel_policy_id`, `can_booking`, `sort`, `breakfast_count`, `is_ota_plan`, `created_at`, `updated_at`, `ota_plan_id`, `ota_type`) VALUES (\"2131673\", \"DOUBLE SUPERIOR \/ BED AND BREAKFAST\", \"0\", \"0\", \"0\", \"0\", \"1\", \"1\", \"0\", \"1\", \"1\", \"2021-12-14 02:42:09\", \"2021-12-14 02:42:09\", \"20211227|20211230|W|514|124623|DBL.SU|BA\", \"2\") ON DUPLICATE KEY UPDATE name=VALUES(name), cancel_policy_id=VALUES(cancel_policy_id), min_stay=VALUES(min_stay), max_stay=VALUES(max_stay), booking_interval=VALUES(booking_interval), updated_at=VALUES(updated_at);","time":0.39},{"connection":"mysql","query":"select * from `Plan` where `ota_plan_id` = '20211227|20211230|W|514|124623|DBL.SU|BA' limit 1;","time":0.37},{"connection":"mysql","query":"insert into `orders` (`hotel_id`, `user_id`, `total`, `origin_total`, `currency`, `status`, `start_at`, `end_at`, `untaxed_price`, `vat`, `fee`, `discount`, `exchange_rate_version`, `bed_adult_price`, `bed_child_price`, `tax_number`, `lang`, `mail_token`, `customer_auth_type`, `ga_client_id`, `source`, `meal_type`, `from`, `is_prepaid`, `updated_at`, `created_at`) values ('2131673', '', '294.11', '294.11', 'EUR', 'temp', '2021-12-27 00:00:00', '2021-12-30 00:00:00', '243.06363636364', '26.74', '24.306363636364', '0', '2021-12-13', '0', '0', '', 'zh_tw', '0b67ca20a941bf1d4a424a5eec986a14', '', '797704552.1639038877', 'hotelbeds', '0', 'owljourney', '', '2021-12-14 02:42:09', '2021-12-14 02:42:09');","time":0.46},{"connection":"mysql","query":"update `orders` set `order_serial` = 'OWJ8190421121402426', `pms_order_serial` = 'OWJ8190421121402426', `updated_at` = '2021-12-14 02:42:09' where `id` = '2426';","time":0.36},{"connection":"PMSdb","query":"select * from `HotelCancelPolicy` where `HotelCancelPolicy`.`id` = '1' limit 1;","time":0.43},{"connection":"mysql","query":"insert into `order_items` (`plan_id`, `room_id`, `price`, `total_price`, `count`, `date`, `cancel_policy_id`, `order_id`, `updated_at`, `created_at`) values ('9921165', '61717', '294.11', '294.11', '1', '2021-12-27', '1', '2426', '2021-12-14 02:42:09', '2021-12-14 02:42:09');","time":0.31},{"connection":"mysql","query":"insert into `order_items` (`plan_id`, `room_id`, `price`, `total_price`, `count`, `date`, `cancel_policy_id`, `order_id`, `updated_at`, `created_at`) values ('9921165', '61717', '294.11', '294.11', '1', '2021-12-28', '1', '2426', '2021-12-14 02:42:09', '2021-12-14 02:42:09');","time":0.29},{"connection":"mysql","query":"insert into `order_items` (`plan_id`, `room_id`, `price`, `total_price`, `count`, `date`, `cancel_policy_id`, `order_id`, `updated_at`, `created_at`) values ('9921165', '61717', '294.11', '294.11', '1', '2021-12-29', '1', '2426', '2021-12-14 02:42:09', '2021-12-14 02:42:09');","time":0.29},{"connection":"mysql","query":"insert into `order_items` (`plan_id`, `room_id`, `price`, `total_price`, `count`, `date`, `cancel_policy_id`, `order_id`, `updated_at`, `created_at`) values ('9921165', '61717', '294.11', '294.11', '1', '2021-12-30', '1', '2426', '2021-12-14 02:42:09', '2021-12-14 02:42:09');","time":0.31},{"connection":"mysql","query":"insert into `order_customers` (`type`, `first_name`, `last_name`, `email`, `phone_code`, `phone`, `gender`, `order_id`, `updated_at`, `created_at`) values ('customer', '', '', '', '', '', 'unknown', '2426', '2021-12-14 02:42:09', '2021-12-14 02:42:09');","time":0.32},{"connection":"mysql","query":"insert into `order_customers` (`type`, `first_name`, `last_name`, `email`, `phone_code`, `phone`, `gender`, `age`, `order_id`, `updated_at`, `created_at`) values ('traveler', '', '', '', '', '', 'unknown', '-1', '2426', '2021-12-14 02:42:09', '2021-12-14 02:42:09');","time":0.29},{"connection":"mysql","query":"select * from `order_items` where `order_items`.`order_id` in (2426) and `order_items`.`deleted_at` is null;","time":2.02},{"connection":"mysql","query":"select * from `Room` where `Room`.`id` in (61717);","time":0.45},{"connection":"mysql","query":"select * from `Plan` where `Plan`.`id` in (9921165);","time":0.4},{"connection":"mysql","query":"select * from `Hotel` where `Hotel`.`id` in (2131673) and `Hotel`.`deleted_at` is null;","time":0.4},{"connection":"mysql","query":"select * from `HotelMeta` where `type` = 'hotel' and `HotelMeta`.`hotel_id` in (2131673);","time":0.54},{"connection":"mysql","query":"select * from `MetaTranslation` where `MetaTranslation`.`trans_id` in (2131673) and `MetaTranslation`.`trans_type` = 'App\\Models\\OTA\\Hotel';","time":0.54},{"connection":"mysql","query":"select * from `order_customers` where `order_customers`.`order_id` in (2426) and `order_customers`.`deleted_at` is null;","time":3.76},{"connection":"mysql","query":"select * from `order_metas` where `order_metas`.`order_id` in (2426) and `order_metas`.`deleted_at` is null;","time":2.95},{"connection":"mysql","query":"select * from `user_coupons` where `user_coupons`.`order_id` in (2426) and `user_coupons`.`deleted_at` is null;","time":1.52},{"connection":"mysql","query":"select * from `order_extras` where `order_extras`.`order_id` in (2426) and `order_extras`.`deleted_at` is null;","time":0.58},{"connection":"mysql","query":"select * from `orders` where `orders`.`id` = '2426' limit 1;","time":0.48},{"connection":"mysql","query":"select * from `order_items` where `order_items`.`order_id` in (2426) and `order_items`.`deleted_at` is null;","time":2.37},{"connection":"mysql","query":"select * from `Room` where `Room`.`id` in (61717);","time":0.35},{"connection":"mysql","query":"select * from `Plan` where `Plan`.`id` in (9921165);","time":0.41},{"connection":"mysql","query":"select * from `Hotel` where `Hotel`.`id` in (2131673) and `Hotel`.`deleted_at` is null;","time":0.41},{"connection":"mysql","query":"select * from `HotelMeta` where `type` = 'hotel' and `HotelMeta`.`hotel_id` in (2131673);","time":0.42},{"connection":"mysql","query":"select * from `MetaTranslation` where `MetaTranslation`.`trans_id` in (2131673) and `MetaTranslation`.`trans_type` = 'App\\Models\\OTA\\Hotel';","time":0.38},{"connection":"mysql","query":"select * from `order_customers` where `order_customers`.`order_id` in (2426) and `order_customers`.`deleted_at` is null;","time":2.53},{"connection":"mysql","query":"select * from `order_metas` where `order_metas`.`order_id` in (2426) and `order_metas`.`deleted_at` is null;","time":2.41},{"connection":"mysql","query":"select * from `user_coupons` where `user_coupons`.`order_id` in (2426) and `user_coupons`.`deleted_at` is null;","time":1.29},{"connection":"mysql","query":"select * from `order_extras` where `order_extras`.`order_id` in (2426) and `order_extras`.`deleted_at` is null;","time":0.34},{"connection":"PMSdb","query":"select * from `Hotel` where `Hotel`.`id` = '2131673' and `Hotel`.`deleted_at` is null limit 1;","time":0.45},{"connection":"PMSdb","query":"select * from `Hotel` where `Hotel`.`id` = '2131673' limit 1;","time":0.39},{"connection":"PMSdb","query":"select * from `HotelCancelPolicy` where `HotelCancelPolicy`.`id` = '1' limit 1;","time":0.36},{"connection":"PMSdb","query":"select * from `Plan` where `Plan`.`id` = '9921165' limit 1;","time":0.42},{"connection":"mysql","query":"select * from `order_caches` where `order_caches`.`order_id` = '2426' and `order_caches`.`order_id` is not null;","time":0.35},{"connection":"PMSdb","query":"select * from `HotelCancelPolicy` where `HotelCancelPolicy`.`id` = '1' limit 1;","time":0.39},{"connection":"PMSdb","query":"select `Place`.*, `owlnest_ota`.`HotelPlace`.`hotel_id` as `pivot_hotel_id`, `owlnest_ota`.`HotelPlace`.`place_id` as `pivot_place_id` from `Place` inner join `owlnest_ota`.`HotelPlace` on `Place`.`id` = `owlnest_ota`.`HotelPlace`.`place_id` where `owlnest_ota`.`HotelPlace`.`hotel_id` = '2131673';","time":84.46},{"connection":"mysql","query":"select * from `RoomMetaContent` where `RoomMetaContent`.`room_id` = '61717' and `RoomMetaContent`.`room_id` is not null limit 1;","time":0.47},{"connection":"mysql","query":"select * from `Hotel` where `Hotel`.`id` = '2131673' limit 1;","time":0.43},{"connection":"mysql","query":"select * from `images` where `images`.`imageable_id` = '2131673' and `images`.`imageable_id` is not null and `images`.`imageable_type` = 'App\\Models\\OTA\\Hotel';","time":1.33},{"connection":"mysql","query":"select * from `MetaTranslation` where `MetaTranslation`.`trans_id` = '61717' and `MetaTranslation`.`trans_id` is not null and `MetaTranslation`.`trans_type` = 'App\\Models\\OTA\\Room';","time":0.49},{"connection":"PMSdb","query":"select * from `Features` where `type` = 'yokoso_hotel' and 0 = 1 and `Features`.`deleted_at` is null;","time":0.67},{"connection":"mysql","query":"select `tags`.*, `taggables`.`taggable_id` as `pivot_taggable_id`, `taggables`.`tag_id` as `pivot_tag_id`, `taggables`.`taggable_type` as `pivot_taggable_type` from `tags` inner join `taggables` on `tags`.`id` = `taggables`.`tag_id` where `taggables`.`taggable_id` = '2131673' and `taggables`.`taggable_type` = 'App\\Models\\OTA\\Hotel' and `tags`.`deleted_at` is null;","time":0.53},{"connection":"mysql","query":"select * from `payment_ways` where `enable` = '1';","time":0.38},{"connection":"mysql","query":"select * from `images` where `images`.`imageable_id` = '2131673' and `images`.`imageable_id` is not null and `images`.`imageable_type` = 'App\\Models\\OTA\\Hotel';","time":1.46},{"connection":"mysql","query":"select * from `payments` where `payments`.`order_id` = '2426' and `payments`.`order_id` is not null and `payments`.`deleted_at` is null;","time":1.75},{"connection":"mysql","query":"select * from `order_partial_refunds` where `order_partial_refunds`.`order_id` = '2426' and `order_partial_refunds`.`order_id` is not null and `order_partial_refunds`.`deleted_at` is null;","time":0.37}]},"cache":{"hit":{"keys":[],"total":0},"miss":{"keys":[],"total":0},"write":{"keys":[],"total":0},"forget":{"keys":[],"total":0}},"profiling":[{"event":"request-time","time":1.5997920036315918}],"memory":{"usage":9418128,"peak":9802080}}}