You don’t need a reason for a holiday. You just want it for a million reasons. Travel has the ability to change your life in the most unexpected way. Travelling around the world is something that has crossed everyone’s mind at some point of time. At the same time, planning a perfect holiday can be overwhelming. Leave it to our holiday experts. From deciding the perfect destination to finding the best hotels to stay – we bring to you a collection of curated holiday ideas that will make your travel much more fun.
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | SELECT WpPost.post_content,WpPost.guid,WpPost.post_date,WpPost.post_title,WpPostmeta2.meta_value FROM `u407119412_tripoffbeat2`.`wp_posts` AS `WpPost` left JOIN `u407119412_tripoffbeat2`.`wp_postmeta` AS `WpPostmeta1` ON (`WpPostmeta1`.`post_id` = `WpPost`.`ID` AND `WpPostmeta1`.`meta_key` = "_thumbnail_id") left JOIN `u407119412_tripoffbeat2`.`wp_postmeta` AS `WpPostmeta2` ON (`WpPostmeta2`.`post_id` = `WpPostmeta1`.`meta_value` AND `WpPostmeta2`.`meta_key` = "_wp_attachment_metadata") WHERE `WpPost`.`post_type` = 'post' AND `WpPost`.`post_status` = 'publish' ORDER BY `WpPost`.`post_date` desc | 63 | 63 | 6 | |
2 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_weekends` = 1 ORDER BY `City`.`name` asc | 8 | 8 | 0 | |
3 | SELECT `City`.`id`, `City`.`name` FROM `u407119412_tripoffbeat2`.`cities` AS `City` WHERE `City`.`is_vacations` = 1 ORDER BY `City`.`name` asc | 8 | 8 | 0 | |
4 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `u407119412_tripoffbeat2`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`is_delete` = 0 AND `Category`.`is_weekends` = 1 | 9 | 9 | 0 | |
5 | SELECT `Category`.`id`, `Category`.`name`, `Category`.`slug` FROM `u407119412_tripoffbeat2`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`is_delete` = 0 AND `Category`.`is_vacations` = 1 | 9 | 9 | 0 | |
6 | SELECT `Category`.`id`, `Category`.`name` FROM `u407119412_tripoffbeat2`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`is_delete` = 0 AND `Category`.`is_destinations` = 1 | 9 | 9 | 0 | |
7 | SELECT `State`.`id`, `State`.`name`, `State`.`slug` FROM `u407119412_tripoffbeat2`.`states` AS `State` WHERE `State`.`is_destinations` = 1 ORDER BY `State`.`name` asc | 14 | 14 | 0 | |
8 | SELECT `State`.`id`, `State`.`name`, `State`.`thumb`, `State`.`slug` FROM `u407119412_tripoffbeat2`.`states` AS `State` WHERE `State`.`is_weekends` = 1 ORDER BY `State`.`name` asc | 6 | 6 | 0 | |
9 | SELECT Activity.id, Activity.activity_name, Activity.slug, `Activity`.`id` FROM `u407119412_tripoffbeat2`.`activities` AS `Activity` WHERE `Activity`.`is_weekends` = 1 | 6 | 6 | 0 | |
10 | SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `u407119412_tripoffbeat2`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`activity_id` IN (40, 43, 44, 45, 46, 50) | 624 | 624 | 1 | |
11 | SELECT `Testimonial`.* FROM `u407119412_tripoffbeat2`.`testimonials` AS `Testimonial` WHERE `Testimonial`.`tl_type` = 'normal' AND `Testimonial`.`is_delete` = 0 AND `Testimonial`.`status` = 1 ORDER BY `Testimonial`.`id` desc | 24 | 24 | 0 | |
12 | SELECT `Resort`.`id`, `Resort`.`resort_name`, `Resort`.`contact_email`, `Resort`.`contact_phone`, `Resort`.`slug`, `Resort`.`meta_title`, `Resort`.`meta_desc`, `Resort`.`meta_keywords`, `Resort`.`payment_type`, `Resort`.`resort_desc`, `Resort`.`resort_main_thumb`, `Resort`.`resort_address`, `Resort`.`city_id`, `Resort`.`state_id`, `Resort`.`country_id`, `Resort`.`tob_rating`, `Resort`.`latitude`, `Resort`.`longitude`, `Resort`.`zipcode`, `Resort`.`is_weekends`, `Resort`.`is_vacations`, `Resort`.`is_destinations`, `Resort`.`is_offsites`, `Resort`.`is_recommends`, `Resort`.`is_school`, `Resort`.`is_honeymoon`, `Resort`.`is_holi`, `Resort`.`is_monsoon`, `Resort`.`is_newyear`, `Resort`.`is_festival`, `Resort`.`is_snowfall`, `Resort`.`is_summer`, `Resort`.`resort_direction`, `Resort`.`dist_del`, `Resort`.`time_del`, `Resort`.`meal_flags`, `Resort`.`child_age_lower_limit_for_meal`, `Resort`.`child_age_upper_limit_for_meal`, `Resort`.`discount`, `Resort`.`is_fun_package`, `Resort`.`is_delight_package`, `Resort`.`is_luxury`, `Resort`.`is_corporate`, `Resort`.`package_price`, `Resort`.`itinerary`, `Resort`.`check_in_time`, `Resort`.`check_out_time`, `Resort`.`cacellation_policy`, `Resort`.`status`, `Resort`.`create_on`, `Resort`.`update_on`, `Resort`.`is_delete`, `City`.`id`, `City`.`name`, `City`.`state_id`, `City`.`latitude`, `City`.`longitude`, `City`.`is_weekends`, `City`.`is_vacations`, `City`.`is_offsites`, `City`.`is_index_parent_id`, `City`.`is_index_parent_type`, `State`.`id`, `State`.`state_code`, `State`.`tin_no`, `State`.`name`, `State`.`slug`, `State`.`meta_title`, `State`.`meta_desc`, `State`.`meta_keywords`, `State`.`thumb`, `State`.`banner`, `State`.`alt_text`, `State`.`country_id`, `State`.`is_weekends`, `State`.`is_destinations`, `State`.`is_featured`, `State`.`is_home_section_3`, `State`.`is_index_weekends`, `State`.`descn`, `State`.`is_delete` FROM `u407119412_tripoffbeat2`.`resorts` AS `Resort` LEFT JOIN `u407119412_tripoffbeat2`.`cities` AS `City` ON (`Resort`.`city_id` = `City`.`id`) LEFT JOIN `u407119412_tripoffbeat2`.`states` AS `State` ON (`Resort`.`state_id` = `State`.`id`) WHERE `Resort`.`tob_rating` > 9 AND `Resort`.`status` = 1 | 10 | 10 | 1 | |
13 | SELECT `ResortRoom`.`id`, `ResortRoom`.`room_id`, `ResortRoom`.`resort_id`, `ResortRoom`.`room_thumbnail`, `ResortRoom`.`number_of_person_allowed`, `ResortRoom`.`number_of_adults_allowed`, `ResortRoom`.`number_of_cildren_allowed`, `ResortRoom`.`extra_bed_allowed`, `ResortRoom`.`total_rooms`, `ResortRoom`.`remaining_room`, `ResortRoom`.`bed_per_room`, `ResortRoom`.`bed_type`, `ResortRoom`.`add_date`, `ResortRoom`.`status` FROM `u407119412_tripoffbeat2`.`resort_rooms` AS `ResortRoom` WHERE `ResortRoom`.`resort_id` IN (2, 28, 31, 32, 49, 52, 55, 78, 91, 108) | 24 | 24 | 1 | |
14 | SELECT `RoomPrice`.`id`, `RoomPrice`.`resort_id`, `RoomPrice`.`room_id`, `RoomPrice`.`CGST`, `RoomPrice`.`SGST`, `RoomPrice`.`1A`, `RoomPrice`.`2A`, `RoomPrice`.`eab`, `RoomPrice`.`ecb`, `RoomPrice`.`ecnb`, `RoomPrice`.`ec_lunch`, `RoomPrice`.`ec_dinner`, `RoomPrice`.`bf`, `RoomPrice`.`lunch`, `RoomPrice`.`dinner`, `RoomPrice`.`full_board`, `RoomPrice`.`c_bf`, `RoomPrice`.`c_lunch`, `RoomPrice`.`c_dinner`, `RoomPrice`.`c_fb`, `RoomPrice`.`update_on`, `RoomPrice`.`create_on`, `RoomPrice`.`is_delete`, `RoomPrice`.`price_date`, `RoomPrice`.`meal_flag` FROM `u407119412_tripoffbeat2`.`room_prices` AS `RoomPrice` WHERE `RoomPrice`.`resort_id` IN (2, 28, 31, 32, 49, 52, 55, 78, 91, 108) | 24 | 24 | 0 | |
15 | SELECT `ResortActivity`.`id`, `ResortActivity`.`activity_id`, `ResortActivity`.`resort_id` FROM `u407119412_tripoffbeat2`.`resort_activities` AS `ResortActivity` WHERE `ResortActivity`.`resort_id` IN (2, 28, 31, 32, 49, 52, 55, 78, 91, 108) | 70 | 70 | 0 | |
16 | SELECT `ResortCategory`.`id`, `ResortCategory`.`resort_id`, `ResortCategory`.`category_id` FROM `u407119412_tripoffbeat2`.`resort_categories` AS `ResortCategory` WHERE `ResortCategory`.`resort_id` IN (2, 28, 31, 32, 49, 52, 55, 78, 91, 108) | 39 | 39 | 0 | |
17 | SELECT `ResortAccomondation`.`id`, `ResortAccomondation`.`resort_id`, `ResortAccomondation`.`accomondation_id` FROM `u407119412_tripoffbeat2`.`resort_accomondations` AS `ResortAccomondation` WHERE `ResortAccomondation`.`resort_id` IN (2, 28, 31, 32, 49, 52, 55, 78, 91, 108) | 17 | 17 | 0 | |
18 | SELECT `ResortImage`.`id`, `ResortImage`.`resort_id`, `ResortImage`.`resort_thumb`, `ResortImage`.`title`, `ResortImage`.`img_type`, `ResortImage`.`is_quote`, `ResortImage`.`status` FROM `u407119412_tripoffbeat2`.`resort_images` AS `ResortImage` WHERE `ResortImage`.`resort_id` IN (2, 28, 31, 32, 49, 52, 55, 78, 91, 108) | 439 | 439 | 1 | |
19 | SELECT `ResortAmenity`.`id`, `ResortAmenity`.`amenity_id`, `ResortAmenity`.`resort_id`, `ResortAmenity`.`created_on`, `ResortAmenity`.`updated_on`, `ResortAmenity`.`is_delete`, `ResortAmenity`.`status` FROM `u407119412_tripoffbeat2`.`resort_amenities` AS `ResortAmenity` WHERE `ResortAmenity`.`resort_id` IN (2, 28, 31, 32, 49, 52, 55, 78, 91, 108) | 44 | 44 | 1 | |
20 | SELECT `InternationalListing`.`id`, `InternationalListing`.`country_name`, `InternationalListing`.`pkg_price`, `InternationalListing`.`no_of_nights`, `InternationalListing`.`feature_listing`, `InternationalListing`.`location_img`, `InternationalListing`.`contact_no`, `InternationalListing`.`is_delete`, `InternationalListing`.`status`, `InternationalListing`.`created_on`, `InternationalListing`.`modified_on` FROM `u407119412_tripoffbeat2`.`international_listings` AS `InternationalListing` WHERE `InternationalListing`.`status` = 1 AND `InternationalListing`.`is_delete` = 0 | 28 | 28 | 1 |