Resort Search Results
Why trust TripOffbeat
One Stop Shop
Verified Resorts And Hotels
Choice Of Destinations
Custom Itineraries
Experts on Call
Emergency Assistance
One Stop Shop
Verified Resorts And Hotels
Choice Of Destinations
Custom Itineraries
Experts on Call
Emergency Assistance
| 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 | 8 | |
| 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 `Activity`.`id`, `Activity`.`activity_name` FROM `u407119412_tripoffbeat2`.`activities` AS `Activity` WHERE `Activity`.`parent_id` = 0 | 11 | 11 | 0 | |
| 12 | SELECT `Category`.`name`, `Category`.`id` FROM `u407119412_tripoffbeat2`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`is_delete` = 0 | 10 | 10 | 0 | |
| 13 | SELECT `Accomondation`.`title`, `Accomondation`.`id` FROM `u407119412_tripoffbeat2`.`accomondations` AS `Accomondation` WHERE `Accomondation`.`is_delete` = 0 | 18 | 18 | 0 | |
| 14 | SELECT `Resort`.`id`, `Resort`.`state_id` FROM `u407119412_tripoffbeat2`.`resorts` AS `Resort` WHERE 1 = 1 GROUP BY `Resort`.`state_id` | 24 | 24 | 1 | |
| 15 | SELECT `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`.`states` AS `State` WHERE `State`.`id` IN (1, 11, 12, 13, 14, 15, 16, 17, 19, 2, 21, 22, 24, 2569, 2576, 26, 31, 32, 33, 35, 38, 39, 4, 41) | 23 | 23 | 0 |