Let’s party overlooking the Caribbean sea at Coco Bongo Beach Party! You are a free soul and know how to party the best, we are ready to invite you to have the time of your life enjoying the sun, music, drinks, and the Cancun turquoise waters while you dance, make new friends, watch the show with the most amazing acrobats on stage that will take your breath. Book now and get your Coco Bongo Beach Party ticket with us.
Be at check in 30 minutes before.
Tuesday to Sunday from 13:00 - 18:00 hrs
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Configuration`.`key`, `Configuration`.`value` FROM `tmdb`.`configurations` AS `Configuration` WHERE 1 = 1 | 44 | 44 | 1 | |
| 2 | SELECT `WebPageSeo`.`id`, `WebPageSeo`.`key`, `WebPageSeo`.`es_name`, `WebPageSeo`.`en_name`, `WebPageSeo`.`es_title`, `WebPageSeo`.`en_title`, `WebPageSeo`.`es_description`, `WebPageSeo`.`en_description`, `WebPageSeo`.`es_meta`, `WebPageSeo`.`en_meta`, `WebPageSeo`.`es_header_code`, `WebPageSeo`.`en_header_code`, `WebPageSeo`.`es_footer_code`, `WebPageSeo`.`en_footer_code`, `WebPageSeo`.`created`, `WebPageSeo`.`modified`, `MediaImage`.`id`, `MediaImage`.`name`, `MediaImage`.`title`, `MediaImage`.`subtitle`, `MediaImage`.`alt`, `MediaImage`.`share_key`, `MediaImage`.`extra`, `MediaImage`.`type`, `MediaImage`.`model`, `MediaImage`.`foreign_key`, `MediaImage`.`collection`, `MediaImage`.`order`, `MediaImage`.`key`, `MediaImage`.`source`, `MediaImage`.`source_format`, `MediaImage`.`format`, `MediaImage`.`width`, `MediaImage`.`height`, `MediaImage`.`size`, `MediaImage`.`length`, `MediaImage`.`public`, `MediaImage`.`main`, `MediaImage`.`shared`, `MediaImage`.`is_file`, `MediaImage`.`created`, `MediaImage`.`modified` FROM `tmdb`.`web_page_seos` AS `WebPageSeo` LEFT JOIN `tmdb`.`media` AS `MediaImage` ON (`MediaImage`.`foreign_key` = `WebPageSeo`.`id` AND `MediaImage`.`model` = 'WebPageSeo' AND `MediaImage`.`collection` = 'image') WHERE 1 = 1 ORDER BY `WebPageSeo`.`es_name` ASC | 7 | 7 | 1 | |
| 3 | SELECT `TourCategory`.`slug_en`, `TourCategory`.`name_en`, `TourCategory`.`special_offer` FROM `tmdb`.`tour_categories` AS `TourCategory` WHERE `TourCategory`.`active` = '1' AND ((`TourCategory`.`active_tours` > 0) OR (`TourCategory`.`rel_active_tours` > 0)) ORDER BY `TourCategory`.`order` ASC | 9 | 9 | 1 | |
| 4 | SELECT `Tour`.`id`, `Tour`.`name`, `Tour`.`name_en`, `Tour`.`subtitle`, `Tour`.`subtitle_en`, `Tour`.`slug`, `Tour`.`slug_en`, `Tour`.`genesis_id`, `Tour`.`genesis_code`, `Tour`.`genesis_desc`, `Tour`.`genesis_active`, `Tour`.`short_description`, `Tour`.`short_description_en`, `Tour`.`description`, `Tour`.`description_en`, `Tour`.`meta_title`, `Tour`.`meta_title_en`, `Tour`.`meta_description`, `Tour`.`meta_description_en`, `Tour`.`recommendations`, `Tour`.`recommendations_en`, `Tour`.`schedule`, `Tour`.`schedule_en`, `Tour`.`promo`, `Tour`.`all_day`, `Tour`.`min_price_mxn`, `Tour`.`min_price_usd`, `Tour`.`ranking`, `Tour`.`duration`, `Tour`.`duration_en`, `Tour`.`monday`, `Tour`.`tuesday`, `Tour`.`wednesday`, `Tour`.`thursday`, `Tour`.`friday`, `Tour`.`saturday`, `Tour`.`sunday`, `Tour`.`age_min`, `Tour`.`age_max`, `Tour`.`tour_category_id`, `Tour`.`tour_type_id`, `Tour`.`tour_level_id`, `Tour`.`order`, `Tour`.`active`, `Tour`.`created`, `Tour`.`modified`, `Tour`.`genesis_update`, `Tour`.`new`, (CONCAT("<span class=\"d-inline-block badge bg-dark text-white\">ESP:</span> ", `Tour`.`name`, "<br>", "<span class=\"d-inline-block badge bg-dark text-white\">ENG:</span> ", `Tour`.`name_en`, IF(`Tour`.`new`, "<br /><div class=\"d-inline-block badge bg-success text-white\">Nuevo</div>", ""))) AS `Tour__set_name`, (DATE_FORMAT(`Tour`.`created`, "%d/%m/%y %H:%i")) AS `Tour__display_created`, (IF(`Tour`.`genesis_active`, "<span class=\"bg-success text-white p-2 rounded\">Si</span>", "<span class=\"bg-danger text-white p-2 rounded\">No</span>")) AS `Tour__is_active`, `TourCategory`.`id`, `TourCategory`.`name`, `TourCategory`.`name_en`, `TourCategory`.`title`, `TourCategory`.`title_en`, `TourCategory`.`subtitle`, `TourCategory`.`subtitle_en`, `TourCategory`.`banner`, `TourCategory`.`key`, `TourCategory`.`special_offer`, `TourCategory`.`order`, `TourCategory`.`created`, `TourCategory`.`modified`, `TourCategory`.`slug`, `TourCategory`.`slug_en`, `TourCategory`.`genesis`, `TourCategory`.`class_id`, `TourCategory`.`class_code`, `TourCategory`.`class_desc`, `TourCategory`.`tours`, `TourCategory`.`active_tours`, `TourCategory`.`rel_tours`, `TourCategory`.`rel_active_tours`, `TourCategory`.`active`, `TourCategory`.`seo_title`, `TourCategory`.`seo_title_en`, `TourCategory`.`seo_description`, `TourCategory`.`seo_description_en`, (IF(special_offer, "Sí", "No")) AS `TourCategory__special_offer_display`, (IF(genesis, "Sí", "No")) AS `TourCategory__is_genesis`, (CONCAT(`TourCategory`.`name`, " / ", `TourCategory`.`name_en`)) AS `TourCategory__set_name`, (IF(genesis, 0, 1)) AS `TourCategory__deletable`, `TourLevel`.`id`, `TourLevel`.`name`, `TourLevel`.`name_en`, `TourLevel`.`active`, `TourLevel`.`tours`, `TourLevel`.`active_tours`, `TourLevel`.`order`, `TourLevel`.`created`, `TourLevel`.`modified`, (CONCAT(`TourLevel`.`name`, " / ", `TourLevel`.`name_en`)) AS `TourLevel__set_name`, `TourType`.`id`, `TourType`.`name`, `TourType`.`name_en`, `TourType`.`active`, `TourType`.`tours`, `TourType`.`active_tours`, `TourType`.`order`, `TourType`.`created`, `TourType`.`modified`, (CONCAT(`TourType`.`name`, " / ", `TourType`.`name_en`)) AS `TourType__set_name`, `MediaCover`.`id`, `MediaCover`.`name`, `MediaCover`.`title`, `MediaCover`.`subtitle`, `MediaCover`.`alt`, `MediaCover`.`share_key`, `MediaCover`.`extra`, `MediaCover`.`type`, `MediaCover`.`model`, `MediaCover`.`foreign_key`, `MediaCover`.`collection`, `MediaCover`.`order`, `MediaCover`.`key`, `MediaCover`.`source`, `MediaCover`.`source_format`, `MediaCover`.`format`, `MediaCover`.`width`, `MediaCover`.`height`, `MediaCover`.`size`, `MediaCover`.`length`, `MediaCover`.`public`, `MediaCover`.`main`, `MediaCover`.`shared`, `MediaCover`.`is_file`, `MediaCover`.`created`, `MediaCover`.`modified` FROM `tmdb`.`tours` AS `Tour` LEFT JOIN `tmdb`.`tour_categories` AS `TourCategory` ON (`Tour`.`tour_category_id` = `TourCategory`.`id`) LEFT JOIN `tmdb`.`tour_levels` AS `TourLevel` ON (`Tour`.`tour_level_id` = `TourLevel`.`id`) LEFT JOIN `tmdb`.`tour_types` AS `TourType` ON (`Tour`.`tour_type_id` = `TourType`.`id`) LEFT JOIN `tmdb`.`media` AS `MediaCover` ON (`MediaCover`.`foreign_key` = `Tour`.`id` AND `MediaCover`.`model` = 'Tour' AND `MediaCover`.`collection` = 'cover') WHERE `Tour`.`slug_en` = 'coco-bongo-beach-party' AND `Tour`.`active` = '1' AND `Tour`.`genesis_active` = '1' LIMIT 1 | 1 | 1 | 1 | |
| 5 | SELECT `TourInclude`.`id`, `TourInclude`.`name`, `TourInclude`.`name_en`, `TourInclude`.`order`, `TourInclude`.`tour_id`, `TourInclude`.`created`, `TourInclude`.`modified`, ("<i class=\"fa fa-check-circle text-success\"></i>") AS `TourInclude__icon_field`, (DATE_FORMAT(`TourInclude`.`created`, "%d/%m/%y %H:%i")) AS `TourInclude__display_created` FROM `tmdb`.`tour_includes` AS `TourInclude` WHERE `TourInclude`.`tour_id` = (172) ORDER BY `TourInclude`.`order` ASC | 2 | 2 | 0 | |
| 6 | SELECT `TourExclude`.`id`, `TourExclude`.`name`, `TourExclude`.`name_en`, `TourExclude`.`order`, `TourExclude`.`tour_id`, `TourExclude`.`created`, `TourExclude`.`modified`, ("<i class=\"fa fa-times-circle text-danger\"></i>") AS `TourExclude__icon_field`, (DATE_FORMAT(`TourExclude`.`created`, "%d/%m/%y %H:%i")) AS `TourExclude__display_created` FROM `tmdb`.`tour_excludes` AS `TourExclude` WHERE `TourExclude`.`tour_id` = (172) ORDER BY `TourExclude`.`order` ASC | 0 | 0 | 0 | |
| 7 | SELECT `TourItem`.`id`, `TourItem`.`name`, `TourItem`.`name_en`, `TourItem`.`order`, `TourItem`.`tour_id`, `TourItem`.`created`, `TourItem`.`modified`, (DATE_FORMAT(`TourItem`.`created`, "%d/%m/%y %H:%i")) AS `TourItem__display_created` FROM `tmdb`.`tour_items` AS `TourItem` WHERE `TourItem`.`tour_id` = (172) ORDER BY `TourItem`.`order` ASC | 0 | 0 | 0 | |
| 8 | SELECT `TourQuestion`.`id`, `TourQuestion`.`name`, `TourQuestion`.`name_en`, `TourQuestion`.`description`, `TourQuestion`.`description_en`, `TourQuestion`.`order`, `TourQuestion`.`tour_id`, `TourQuestion`.`created`, `TourQuestion`.`modified`, (DATE_FORMAT(`TourQuestion`.`created`, "%d/%m/%y %H:%i")) AS `TourQuestion__display_created`, (CONCAT("<strong>", `TourQuestion`.`name`, "</strong><div>", `TourQuestion`.`description`, "</div>")) AS `TourQuestion__set_name`, (CONCAT("<strong>", `TourQuestion`.`name_en`, "</strong><div>", `TourQuestion`.`description_en`, "</div>")) AS `TourQuestion__set_name_en` FROM `tmdb`.`tour_questions` AS `TourQuestion` WHERE `TourQuestion`.`tour_id` = (172) ORDER BY `TourQuestion`.`order` ASC | 0 | 0 | 0 | |
| 9 | SELECT `TourBenefit`.`id`, `TourBenefit`.`name`, `TourBenefit`.`name_en`, `TourBenefit`.`description`, `TourBenefit`.`description_en`, `TourBenefit`.`order`, `TourBenefit`.`tour_id`, `TourBenefit`.`created`, `TourBenefit`.`modified`, (DATE_FORMAT(`TourBenefit`.`created`, "%d/%m/%y %H:%i")) AS `TourBenefit__display_created`, (CONCAT("<strong>", `TourBenefit`.`name`, "</strong><div>", `TourBenefit`.`description`, "</div>")) AS `TourBenefit__set_name`, (CONCAT("<strong>", `TourBenefit`.`name_en`, "</strong><div>", `TourBenefit`.`description_en`, "</div>")) AS `TourBenefit__set_name_en` FROM `tmdb`.`tour_benefits` AS `TourBenefit` WHERE `TourBenefit`.`tour_id` = (172) ORDER BY `TourBenefit`.`order` ASC | 0 | 0 | 0 | |
| 10 | SELECT `TourVariant`.`id`, `TourVariant`.`tour_id`, `TourVariant`.`name`, `TourVariant`.`name_en`, `TourVariant`.`code`, `TourVariant`.`pax_restriction`, `TourVariant`.`genesis_variant_id`, `TourVariant`.`genesis_item_variant_id`, `TourVariant`.`genesis_desc`, `TourVariant`.`order`, `TourVariant`.`active`, `TourVariant`.`new`, `TourVariant`.`created`, `TourVariant`.`modified` FROM `tmdb`.`tour_variants` AS `TourVariant` WHERE `TourVariant`.`active` = '1' AND `TourVariant`.`tour_id` = (172) | 1 | 1 | 0 | |
| 11 | SELECT `MediaGallery`.`id`, `MediaGallery`.`name`, `MediaGallery`.`title`, `MediaGallery`.`subtitle`, `MediaGallery`.`alt`, `MediaGallery`.`share_key`, `MediaGallery`.`extra`, `MediaGallery`.`type`, `MediaGallery`.`model`, `MediaGallery`.`foreign_key`, `MediaGallery`.`collection`, `MediaGallery`.`order`, `MediaGallery`.`key`, `MediaGallery`.`source`, `MediaGallery`.`source_format`, `MediaGallery`.`format`, `MediaGallery`.`width`, `MediaGallery`.`height`, `MediaGallery`.`size`, `MediaGallery`.`length`, `MediaGallery`.`public`, `MediaGallery`.`main`, `MediaGallery`.`shared`, `MediaGallery`.`is_file`, `MediaGallery`.`created`, `MediaGallery`.`modified` FROM `tmdb`.`media` AS `MediaGallery` WHERE `MediaGallery`.`model` = 'Tour' AND `MediaGallery`.`collection` = 'gallery' AND `MediaGallery`.`foreign_key` = (172) ORDER BY `MediaGallery`.`order` DESC | 0 | 0 | 1 | |
| 12 | SELECT `TourCategory`.`id`, `TourCategory`.`name` FROM `tmdb`.`tour_categories` AS `TourCategory` WHERE `TourCategory`.`special_offer` = '1' AND `TourCategory`.`active` = '1' | 1 | 1 | 1 | |
| 13 | SELECT `Tour`.`id`, `Tour`.`name`, `Tour`.`name_en`, `Tour`.`subtitle`, `Tour`.`subtitle_en`, `Tour`.`slug`, `Tour`.`slug_en`, `Tour`.`genesis_id`, `Tour`.`genesis_code`, `Tour`.`genesis_desc`, `Tour`.`genesis_active`, `Tour`.`short_description`, `Tour`.`short_description_en`, `Tour`.`description`, `Tour`.`description_en`, `Tour`.`meta_title`, `Tour`.`meta_title_en`, `Tour`.`meta_description`, `Tour`.`meta_description_en`, `Tour`.`recommendations`, `Tour`.`recommendations_en`, `Tour`.`schedule`, `Tour`.`schedule_en`, `Tour`.`promo`, `Tour`.`all_day`, `Tour`.`min_price_mxn`, `Tour`.`min_price_usd`, `Tour`.`ranking`, `Tour`.`duration`, `Tour`.`duration_en`, `Tour`.`monday`, `Tour`.`tuesday`, `Tour`.`wednesday`, `Tour`.`thursday`, `Tour`.`friday`, `Tour`.`saturday`, `Tour`.`sunday`, `Tour`.`age_min`, `Tour`.`age_max`, `Tour`.`tour_category_id`, `Tour`.`tour_type_id`, `Tour`.`tour_level_id`, `Tour`.`order`, `Tour`.`active`, `Tour`.`created`, `Tour`.`modified`, `Tour`.`genesis_update`, `Tour`.`new`, (CONCAT("<span class=\"d-inline-block badge bg-dark text-white\">ESP:</span> ", `Tour`.`name`, "<br>", "<span class=\"d-inline-block badge bg-dark text-white\">ENG:</span> ", `Tour`.`name_en`, IF(`Tour`.`new`, "<br /><div class=\"d-inline-block badge bg-success text-white\">Nuevo</div>", ""))) AS `Tour__set_name`, (DATE_FORMAT(`Tour`.`created`, "%d/%m/%y %H:%i")) AS `Tour__display_created`, (IF(`Tour`.`genesis_active`, "<span class=\"bg-success text-white p-2 rounded\">Si</span>", "<span class=\"bg-danger text-white p-2 rounded\">No</span>")) AS `Tour__is_active`, `TourCategory`.`id`, `TourCategory`.`name`, `TourCategory`.`name_en`, `TourCategory`.`title`, `TourCategory`.`title_en`, `TourCategory`.`subtitle`, `TourCategory`.`subtitle_en`, `TourCategory`.`banner`, `TourCategory`.`key`, `TourCategory`.`special_offer`, `TourCategory`.`order`, `TourCategory`.`created`, `TourCategory`.`modified`, `TourCategory`.`slug`, `TourCategory`.`slug_en`, `TourCategory`.`genesis`, `TourCategory`.`class_id`, `TourCategory`.`class_code`, `TourCategory`.`class_desc`, `TourCategory`.`tours`, `TourCategory`.`active_tours`, `TourCategory`.`rel_tours`, `TourCategory`.`rel_active_tours`, `TourCategory`.`active`, `TourCategory`.`seo_title`, `TourCategory`.`seo_title_en`, `TourCategory`.`seo_description`, `TourCategory`.`seo_description_en`, (IF(special_offer, "Sí", "No")) AS `TourCategory__special_offer_display`, (IF(genesis, "Sí", "No")) AS `TourCategory__is_genesis`, (CONCAT(`TourCategory`.`name`, " / ", `TourCategory`.`name_en`)) AS `TourCategory__set_name`, (IF(genesis, 0, 1)) AS `TourCategory__deletable`, `MediaCover`.`id`, `MediaCover`.`name`, `MediaCover`.`title`, `MediaCover`.`subtitle`, `MediaCover`.`alt`, `MediaCover`.`share_key`, `MediaCover`.`extra`, `MediaCover`.`type`, `MediaCover`.`model`, `MediaCover`.`foreign_key`, `MediaCover`.`collection`, `MediaCover`.`order`, `MediaCover`.`key`, `MediaCover`.`source`, `MediaCover`.`source_format`, `MediaCover`.`format`, `MediaCover`.`width`, `MediaCover`.`height`, `MediaCover`.`size`, `MediaCover`.`length`, `MediaCover`.`public`, `MediaCover`.`main`, `MediaCover`.`shared`, `MediaCover`.`is_file`, `MediaCover`.`created`, `MediaCover`.`modified`, `MediaThumbnail`.`id`, `MediaThumbnail`.`name`, `MediaThumbnail`.`title`, `MediaThumbnail`.`subtitle`, `MediaThumbnail`.`alt`, `MediaThumbnail`.`share_key`, `MediaThumbnail`.`extra`, `MediaThumbnail`.`type`, `MediaThumbnail`.`model`, `MediaThumbnail`.`foreign_key`, `MediaThumbnail`.`collection`, `MediaThumbnail`.`order`, `MediaThumbnail`.`key`, `MediaThumbnail`.`source`, `MediaThumbnail`.`source_format`, `MediaThumbnail`.`format`, `MediaThumbnail`.`width`, `MediaThumbnail`.`height`, `MediaThumbnail`.`size`, `MediaThumbnail`.`length`, `MediaThumbnail`.`public`, `MediaThumbnail`.`main`, `MediaThumbnail`.`shared`, `MediaThumbnail`.`is_file`, `MediaThumbnail`.`created`, `MediaThumbnail`.`modified` FROM `tmdb`.`tours` AS `Tour` LEFT JOIN `tmdb`.`tour_categories` AS `TourCategory` ON (`Tour`.`tour_category_id` = `TourCategory`.`id`) LEFT JOIN `tmdb`.`media` AS `MediaCover` ON (`MediaCover`.`foreign_key` = `Tour`.`id` AND `MediaCover`.`model` = 'Tour' AND `MediaCover`.`collection` = 'cover') LEFT JOIN `tmdb`.`media` AS `MediaThumbnail` ON (`MediaThumbnail`.`foreign_key` = `Tour`.`id` AND `MediaThumbnail`.`model` = 'Tour' AND `MediaThumbnail`.`collection` = 'thumbnail') LEFT JOIN `tmdb`.`tours_categories` AS `ToursCategory` ON (`ToursCategory`.`tour_id` = `Tour`.`id` AND `ToursCategory`.`tour_category_id` = (24)) WHERE `Tour`.`active` = '1' AND `Tour`.`genesis_active` = '1' AND ((`Tour`.`tour_category_id` = (24)) OR (`ToursCategory`.`id` IS NOT NULL)) AND `Tour`.`id` <> 172 GROUP BY `Tour`.`id` ORDER BY rand() ASC LIMIT 4 | 4 | 4 | 4 |
