Orange Bay VIP

Orange Bay, Giftun island, Egypt

Not Rated from 0 reviews
0/5
0% of guests recommend

Duration

9 Hours

Tour Type

Trips in hurghada

Location

Hurghada

Overview

Embark on a VIP Sea Adventure with an Exclusive Day at Orange Bay

  • Comfortable and Well-Equipped Boats: Set sail aboard one of our modern, fully equipped boats, designed for maximum comfort and convenience.

  • Exclusive Availability: This VIP experience is available only on Wednesdays and Sundays, ensuring a more private and personalized adventure.

  • Snorkeling in Pristine Waters: Enjoy a guided snorkeling session in the crystal-clear waters of the Red Sea, with all necessary equipment provided at no additional cost.

  • Refreshments Throughout the Journey: Stay refreshed with unlimited soft drinks, fresh fruit, tea, and coffee served throughout your trip.

  • Delicious Beachside Lunch: Savor a delectable lunch served on the beach, offering a variety of tasty dishes to enhance your experience.

  • Discover Orange Bay: Spend up to three hours in Orange Bay, located on the beautiful Giftun Islands, often called the "Egyptian Maldives" for its stunning turquoise waters and powdery white sands.

  • Perfect Blend of Adventure and Relaxation: Whether you're swimming in the crystal-clear waters or lounging on the beach under the sun, this exclusive trip offers the perfect mix of excitement and tranquility.

 

Don't miss out on this unforgettable VIP experience—book your spot today and enjoy the serenity and beauty of Orange Bay!

Included/Excluded

Round-trip transportation from and to your hotel.
Professional snorkeling guide.
Snorkeling equipment.
Lunch served on the beach.
Fresh fruit and soft drinks.
Thrilling water sports activities (banana boat and sofa ride).
Tips for the crew.
Drinks at the island bar.
Professional photo session with a photographer.

Travel Styles

Marine
Activities

FAQs

What do I need to complete my booking?
Simply select the date of the trip, then choose how many adults, children and infants, then contact us via WhatsApp or Facebook Messenger to send us your hotel name and room number.
How will I know the pickup time?
The team will contact you one day before the trip via your WhatsApp number or Facebook Messenger to let you know the pick-up time, which will be local Egyptian time at the reception of your hotel.
Are the transport included in the price ?
Yes, all prices include transportation costs, but if the hotel is located in Elguna, Safaga, Sahel Hashish and Soma Bay, additional charges will apply.

Tour Location

Orange Bay, Giftun island, Egypt

Reviews

0/5
Not Rated
Based on 0 review
Excellent
0
Very Good
0
Average
0
Poor
0
Terrible
0
No Review
You must log in to write review
16%
from $60 $50
Monday 08:00 - 17:00
Tuesday 08:00 - 17:00
Wednesday 08:00 - 17:00
Thursday 08:00 - 17:00
Friday 08:00 - 17:00
Saturday Closed
Sunday 08:00 - 17:00
from
$60 $50
0 Review
Request history8.1.14PHP Version3.35sRequest Duration12MBMemory UsageGET tour/{slug}RouteAuth status
    • Booting (1.95s)time
    • Application (1.4s)time
    • 1 x Booting (58.27%)
      1.95s
      1 x Application (41.73%)
      1.40s
      35 templates were rendered
      • 1x Tour::frontend.detaildetail.blade.php#?blade
      • 1x Layout::parts.bcbc.blade.php#?blade
      • 1x Tour::frontend.layouts.details.tour-bannertour-banner.blade.php#?blade
      • 1x Tour::frontend.layouts.details.tour-detailtour-detail.blade.php#?blade
      • 1x Layout::global.details.gallerygallery.blade.php#?blade
      • 1x Tour::frontend.layouts.details.tour-include-excludetour-include-exclude.blade.php#?blade
      • 1x Tour::frontend.layouts.details.tour-itinerarytour-itinerary.blade.php#?blade
      • 1x Tour::frontend.layouts.details.tour-attributestour-attributes.blade.php#?blade
      • 1x Tour::frontend.layouts.details.tour-faqstour-faqs.blade.php#?blade
      • 1x Hotel::frontend.layouts.details.hotel-surroundinghotel-surrounding.blade.php#?blade
      • 1x Tour::frontend.layouts.details.tour-reviewtour-review.blade.php#?blade
      • 1x Review::frontend.formform.blade.php#?blade
      • 1x Tour::frontend.layouts.details.vendorvendor.blade.php#?blade
      • 1x Tour::frontend.layouts.details.tour-form-booktour-form-book.blade.php#?blade
      • 1x Booking::frontend.global.enquiry-formenquiry-form.blade.php#?blade
      • 1x Tour::frontend.layouts.details.open-hoursopen-hours.blade.php#?blade
      • 1x Tour::frontend.layouts.details.tour-relatedtour-related.blade.php#?blade
      • 1x Tour::frontend.layouts.search.loop-gridloop-grid.blade.php#?blade
      • 1x layouts.appapp.blade.php#?blade
      • 1x Layout::appapp.blade.php#?blade
      • 1x Layout::parts.faviconfavicon.blade.php#?blade
      • 1x Layout::parts.seo-metaseo-meta.blade.php#?blade
      • 1x Layout::parts.global-scriptglobal-script.blade.php#?blade
      • 1x Layout::parts.topbartopbar.blade.php#?blade
      • 2x Core::frontend.currency-switchercurrency-switcher.blade.php#?blade
      • 2x Language::frontend.switcherswitcher.blade.php#?blade
      • 1x Layout::parts.headerheader.blade.php#?blade
      • 1x Layout::parts.footerfooter.blade.php#?blade
      • 1x Layout::parts.login-register-modallogin-register-modal.blade.php#?blade
      • 1x Layout::auth.login-formlogin-form.blade.php#?blade
      • 1x Layout::auth.register-formregister-form.blade.php#?blade
      • 1x Popup::frontend.popuppopup.blade.php#?blade
      • 1x demo_scriptdemo_script.blade.php#?blade
      uri
      GET tour/{slug}
      middleware
      web
      controller
      \Modules\Tour\Controllers\TourController@detail
      namespace
      Modules\Tour\Controllers
      prefix
      /tour
      where
      file
      modules/Tour/Controllers/TourController.php:105-142
      32 statements were executed, 10 of which were duplicates, 22 unique. Show only duplicated154ms
      • select * from `bravo_tours` where `slug` = 'orange-bay-vip-exclusive-paradise-experience' and `bravo_tours`.`deleted_at` is null limit 127.45msraholidayTourController.php#107
        Bindings
        • 0: orange-bay-vip-exclusive-paradise-experience
        Hints
        • 0: Use SELECT * only if you need all columns from table
        • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 16. modules/Tour/Controllers/TourController.php:107
        • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 18. modules/Tour/Controllers/TourController.php:36
        • 19. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_locations` where `bravo_locations`.`id` in (1) and `bravo_locations`.`deleted_at` is null9.63msraholidayTourController.php#107
        Hints
        • 0: Use SELECT * only if you need all columns from table
        Backtrace
        • 21. modules/Tour/Controllers/TourController.php:107
        • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 23. modules/Tour/Controllers/TourController.php:36
        • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_location_translations` where `locale` = 'en' and `bravo_location_translations`.`origin_id` in (1)7.52msraholidayTourController.php#107
        Bindings
        • 0: en
        Hints
        • 0: Use SELECT * only if you need all columns from table
        Backtrace
        • 26. modules/Tour/Controllers/TourController.php:107
        • 27. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 28. modules/Tour/Controllers/TourController.php:36
        • 29. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 30. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_tour_translations` where `locale` = 'en' and `bravo_tour_translations`.`origin_id` in (98)5.32msraholidayTourController.php#107
        Bindings
        • 0: en
        Hints
        • 0: Use SELECT * only if you need all columns from table
        Backtrace
        • 21. modules/Tour/Controllers/TourController.php:107
        • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 23. modules/Tour/Controllers/TourController.php:36
        • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `user_wishlist` where `object_model` = 'tour' and `user_id` = 0 and `user_wishlist`.`object_id` in (98)2.45msraholidayTourController.php#107
        Bindings
        • 0: tour
        • 1: 0
        Hints
        • 0: Use SELECT * only if you need all columns from table
        Backtrace
        • 21. modules/Tour/Controllers/TourController.php:107
        • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 23. modules/Tour/Controllers/TourController.php:36
        • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 25. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_tours` where `location_id` = 1 and `status` = 'publish' and `id` not in (98) and `bravo_tours`.`deleted_at` is null limit 44.4msraholidayTourController.php#115
        Bindings
        • 0: 1
        • 1: publish
        • 2: 98
        Hints
        • 0: Use SELECT * only if you need all columns from table
        • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 15. modules/Tour/Controllers/TourController.php:115
        • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. modules/Tour/Controllers/TourController.php:36
        • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_locations` where `bravo_locations`.`id` in (1) and `bravo_locations`.`deleted_at` is null4.55msraholidayTourController.php#115
        Hints
        • 0: Use SELECT * only if you need all columns from table
        Backtrace
        • 20. modules/Tour/Controllers/TourController.php:115
        • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. modules/Tour/Controllers/TourController.php:36
        • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_location_translations` where `locale` = 'en' and `bravo_location_translations`.`origin_id` in (1)1.98msraholidayTourController.php#115
        Bindings
        • 0: en
        Hints
        • 0: Use SELECT * only if you need all columns from table
        Backtrace
        • 25. modules/Tour/Controllers/TourController.php:115
        • 26. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 27. modules/Tour/Controllers/TourController.php:36
        • 28. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 29. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_tour_translations` where `locale` = 'en' and `bravo_tour_translations`.`origin_id` in (97)810μsraholidayTourController.php#115
        Bindings
        • 0: en
        Hints
        • 0: Use SELECT * only if you need all columns from table
        Backtrace
        • 20. modules/Tour/Controllers/TourController.php:115
        • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. modules/Tour/Controllers/TourController.php:36
        • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `user_wishlist` where `object_model` = 'tour' and `user_id` = 0 and `user_wishlist`.`object_id` in (97)2.44msraholidayTourController.php#115
        Bindings
        • 0: tour
        • 1: 0
        Hints
        • 0: Use SELECT * only if you need all columns from table
        Backtrace
        • 20. modules/Tour/Controllers/TourController.php:115
        • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. modules/Tour/Controllers/TourController.php:36
        • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select count(*) as aggregate from `bravo_review` where `object_id` = 98 and `object_model` = 'tour' and `status` = 'approved' and `bravo_review`.`deleted_at` is null3.37msraholidayTour.php#831
        Bindings
        • 0: 98
        • 1: tour
        • 2: approved
        Backtrace
        • 16. modules/Tour/Models/Tour.php:831
        • 17. modules/Tour/Controllers/TourController.php:117
        • 18. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 19. modules/Tour/Controllers/TourController.php:36
        • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `bravo_tour_meta` where `bravo_tour_meta`.`tour_id` = 98 and `bravo_tour_meta`.`tour_id` is not null limit 12.51msraholidayTour.php#592
        Bindings
        • 0: 98
        Hints
        • 0: Use SELECT * only if you need all columns from table
        • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 22. modules/Tour/Models/Tour.php:592
        • 23. modules/Tour/Controllers/TourController.php:123
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 25. modules/Tour/Controllers/TourController.php:36
        • 26. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `bravo_seo` where `object_id` = 98 and `object_model` = 'tour' limit 12.09msraholidayBaseModel.php#199
        Bindings
        • 0: 98
        • 1: tour
        Hints
        • 0: Use SELECT * only if you need all columns from table
        • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 16. app/BaseModel.php:199
        • 17. app/BaseModel.php:212
        • 18. modules/Tour/Controllers/TourController.php:125
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. modules/Tour/Controllers/TourController.php:36
      • select * from `location_category` where `status` = 'publish' and `location_category`.`deleted_at` is null2.3msraholidayTourController.php#133
        Bindings
        • 0: publish
        Hints
        • 0: Use SELECT * only if you need all columns from table
        Backtrace
        • 15. modules/Tour/Controllers/TourController.php:133
        • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 17. modules/Tour/Controllers/TourController.php:36
        • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `location_category_translations` where `locale` = 'en' and `location_category_translations`.`origin_id` in (1, 2, 3)1.39msraholidayTourController.php#133
        Bindings
        • 0: en
        Hints
        • 0: Use SELECT * only if you need all columns from table
        Backtrace
        • 20. modules/Tour/Controllers/TourController.php:133
        • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 22. modules/Tour/Controllers/TourController.php:36
        • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `bravo_locations` where (2 between `bravo_locations`.`_lft` and `bravo_locations`.`_rgt` and `bravo_locations`.`id` <> 1) and `bravo_locations`.`deleted_at` is null6.08msraholidayQueryBuilder.php#165
        Bindings
        • 0: 2
        • 1: 1
        Hints
        • 0: Use SELECT * only if you need all columns from table
        Backtrace
        • 15. vendor/kalnoy/nestedset/src/QueryBuilder.php:165
        • 18. modules/Location/Traits/HasLocation.php:21
        • 19. modules/Tour/Controllers/TourController.php:135
        • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 21. modules/Tour/Controllers/TourController.php:36
      • select AVG(rate_number) as score_total , COUNT(id) as total_review from `bravo_review` where `object_id` = 98 and `object_model` = 'tour' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 13.05msraholidayTour.php#757
        Bindings
        • 0: 98
        • 1: tour
        • 2: approved
        Hints
        • 0: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 16. modules/Tour/Models/Tour.php:757
        • 22. view::Tour::frontend.detail:15
        • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select COUNT( CASE WHEN rate_number = 5 THEN rate_number ELSE NULL END ) AS rate_5, COUNT( CASE WHEN rate_number = 4 THEN rate_number ELSE NULL END ) AS rate_4, COUNT( CASE WHEN rate_number = 3 THEN rate_number ELSE NULL END ) AS rate_3, COUNT( CASE WHEN rate_number = 2 THEN rate_number ELSE NULL END ) AS rate_2, COUNT( CASE WHEN rate_number = 1 THEN rate_number ELSE NULL END ) AS rate_1 from `bravo_review` where `object_id` = 98 and `object_model` = 'tour' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 13.44msraholidayTour.php#769
        Bindings
        • 0: 98
        • 1: tour
        • 2: approved
        Hints
        • 0: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 16. modules/Tour/Models/Tour.php:769
        • 22. view::Tour::frontend.detail:15
        • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select COUNT( id ) AS total_review, COUNT( CASE WHEN rate_number >= 4 THEN 1 ELSE null END ) as total_review_recommend from `bravo_review` where `object_id` = 98 and `object_model` = 'tour' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 14.87msraholidayBookable.php#359
        Bindings
        • 0: 98
        • 1: tour
        • 2: approved
        Hints
        • 0: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 16. modules/Booking/Models/Bookable.php:359
        • 22. view::Tour::frontend.layouts.details.tour-detail:24
        • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `bravo_tour_category` where `bravo_tour_category`.`id` = 6 and `bravo_tour_category`.`id` is not null and `bravo_tour_category`.`deleted_at` is null limit 13.04msraholidaytour-detail.blade.php#50
        Bindings
        • 0: 6
        Hints
        • 0: Use SELECT * only if you need all columns from table
        • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 22. view::Tour::frontend.layouts.details.tour-detail:50
        • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 27. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `bravo_tour_category_translations` where `locale` = 'en' and `bravo_tour_category_translations`.`origin_id` in (6)12.35msraholidaytour-detail.blade.php#50
        Bindings
        • 0: en
        Hints
        • 0: Use SELECT * only if you need all columns from table
        Backtrace
        • 27. view::Tour::frontend.layouts.details.tour-detail:50
        • 29. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 30. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 31. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 32. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 17.54msraholidayBaseModel.php#135
        Bindings
        • 0: 
        Hints
        • 0: Use SELECT * only if you need all columns from table
        • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 19. app/BaseModel.php:135
        • 20. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:437
        • 21. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • 23. app/BaseModel.php:136
        • 24. modules/Media/Helpers/FileHelper.php:42
      • select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 1510μsraholidayBaseModel.php#135
        Bindings
        • 0: 
        Hints
        • 0: Use SELECT * only if you need all columns from table
        • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 19. app/BaseModel.php:135
        • 20. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:437
        • 21. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • 23. app/BaseModel.php:136
        • 24. modules/Media/Helpers/FileHelper.php:42
      • select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 13.17msraholidayBaseModel.php#135
        Bindings
        • 0: 
        Hints
        • 0: Use SELECT * only if you need all columns from table
        • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 19. app/BaseModel.php:135
        • 20. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:437
        • 21. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • 23. app/BaseModel.php:136
        • 24. modules/Media/Helpers/FileHelper.php:42
      • select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 11.12msraholidayBaseModel.php#135
        Bindings
        • 0: 
        Hints
        • 0: Use SELECT * only if you need all columns from table
        • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 19. app/BaseModel.php:135
        • 20. vendor/laravel/framework/src/Illuminate/Cache/Repository.php:437
        • 21. vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:429
        • 23. app/BaseModel.php:136
        • 24. modules/Media/Helpers/FileHelper.php:42
      • select * from `bravo_tour_term` where `bravo_tour_term`.`tour_id` = 98 and `bravo_tour_term`.`tour_id` is not null8.03msraholidaytour-attributes.blade.php#2
        Bindings
        • 0: 98
        Hints
        • 0: Use SELECT * only if you need all columns from table
        Backtrace
        • 20. view::Tour::frontend.layouts.details.tour-attributes:2
        • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 25. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `bravo_terms` where `bravo_terms`.`id` in (3, 5) and `bravo_terms`.`deleted_at` is null3.61msraholidayTerms.php#42
        Hints
        • 0: Use SELECT * only if you need all columns from table
        Backtrace
        • 17. modules/Core/Models/Terms.php:42
        • 18. view::Tour::frontend.layouts.details.tour-attributes:3
        • 20. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 22. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `bravo_terms_translations` where `locale` = 'en' and `bravo_terms_translations`.`origin_id` in (3, 5)1.93msraholidayTerms.php#42
        Bindings
        • 0: en
        Hints
        • 0: Use SELECT * only if you need all columns from table
        Backtrace
        • 22. modules/Core/Models/Terms.php:42
        • 23. view::Tour::frontend.layouts.details.tour-attributes:3
        • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 27. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `bravo_attrs` where `bravo_attrs`.`id` in (1) and `bravo_attrs`.`deleted_at` is null6.52msraholidayTerms.php#42
        Bindings
        • 0: 1
        Hints
        • 0: Use SELECT * only if you need all columns from table
        Backtrace
        • 22. modules/Core/Models/Terms.php:42
        • 23. view::Tour::frontend.layouts.details.tour-attributes:3
        • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 27. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `bravo_attrs_translations` where `bravo_attrs_translations`.`origin_id` = 1 and `bravo_attrs_translations`.`origin_id` is not null and `locale` = 'en' limit 12.69msraholidayHasTranslations.php#51
        Bindings
        • 0: 1
        • 1: en
        Hints
        • 0: Use SELECT * only if you need all columns from table
        • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 21. app/Traits/HasTranslations.php:51
        • 22. view::Tour::frontend.layouts.details.tour-attributes:7
        • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 26. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `core_menu_translations` where `core_menu_translations`.`origin_id` = 1 and `core_menu_translations`.`origin_id` is not null and `locale` = 'en' limit 15.85msraholidayHasTranslations.php#51
        Bindings
        • 0: 1
        • 1: en
        Hints
        • 0: Use SELECT * only if you need all columns from table
        • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 21. app/Traits/HasTranslations.php:51
        • 22. app/Helpers/AppHelper.php:112
        • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 27. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `core_menu_translations` where `core_menu_translations`.`origin_id` = 1 and `core_menu_translations`.`origin_id` is not null and `locale` = 'en' limit 12.1msraholidayHasTranslations.php#51
        Bindings
        • 0: 1
        • 1: en
        Hints
        • 0: Use SELECT * only if you need all columns from table
        • 1: LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 21. app/Traits/HasTranslations.php:51
        • 22. app/Helpers/AppHelper.php:112
        • 25. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 26. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 27. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      Modules\Location\Models\LocationCategory
      3LocationCategory.php#?
      Modules\Review\Models\Review
      3Review.php#?
      Modules\Tour\Models\Tour
      2Tour.php#?
      Modules\Location\Models\Location
      2Location.php#?
      Modules\Location\Models\LocationTranslation
      2LocationTranslation.php#?
      Modules\Tour\Models\TourTranslation
      2TourTranslation.php#?
      Modules\Tour\Models\TourTerm
      2TourTerm.php#?
      Modules\Core\Models\Terms
      2Terms.php#?
      Modules\Core\Models\MenuTranslation
      2MenuTranslation.php#?
      Modules\Tour\Models\TourMeta
      1TourMeta.php#?
      Modules\Core\Models\SEO
      1SEO.php#?
      Modules\Tour\Models\TourCategory
      1TourCategory.php#?
      Modules\Core\Models\Attributes
      1Attributes.php#?
        web
        null
        sanctum
        null
          _token
          GNtdyJxVkEbfImuZUbIpS2GoOAMW77ccL98Fw7VL
          _previous
          array:1 [ "url" => "https://raholiday.com/tour/orange-bay-vip-exclusive-paradise-experience" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /tour/orange-bay-vip-exclusive-paradise-experience
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          []
          
          request_request
          []
          
          request_headers
          0 of 0
          array:15 [ "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "host" => array:1 [ 0 => "raholiday.com" ] "pragma" => array:1 [ 0 => "no-cache" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "cache-control" => array:1 [ 0 => "no-cache" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "priority" => array:1 [ 0 => "u=0, i" ] ]
          request_cookies
          []
          
          response_headers
          0 of 0
          array:5 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ 0 => "Fri, 04 Apr 2025 14:20:50 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImRPTEJPZlcvTDByUWZ0bk5iQ29Hb2c9PSIsInZhbHVlIjoieThKak5kdEZ2Sy9NZTg3anBvUnA0YjJla05HL1kwZWc0TWUzSldWTWZKTm8xdWhCUzBSNHhuV094WHVyVkpGQ0tsdVJNK1E2ZHlUVUtsam96WW9GUlpqZU54TytkRVdpMEVpTmU3STV0bzhxRTM0eUw1WERtcm5SNGUyL0NIbGYiLCJtYWMiOiJkYTUxOWJiYzgzMTZhNzUwMjg5YWJiNDBmOGQ2NDA5YzRmNjQwN2YyYjg5ZTQyMWU0NDY1OWY2NTQ0OWE1OWIzIiwidGFnIjoiIn0%3D; expires=Fri, 04 Apr 2025 16:20:51 GMT; Max-Age=7200; path=/; secure; samesite=laxXSRF-TOKEN=eyJpdiI6ImRPTEJPZlcvTDByUWZ0bk5iQ29Hb2c9PSIsInZhbHVlIjoieThKak5kdEZ2Sy9NZTg3anBvUnA0YjJla05HL1kwZWc0TWUzSldWTWZKTm8xdWhCUzBSNHhuV094WHVyVkpGQ0tsdVJNK" 1 => "ra_holiday_session=eyJpdiI6Ikp1eEZzQXZ6aEZPdys5ejRkWFh6RXc9PSIsInZhbHVlIjoiK3RDQzdZbC82N2thNFlodjlZRXN5d1Zqa2NiRmNhOXZ5WW9UbFB0bVljNytiVUxuc2QweEZLU2luTHRhUUNkWkorUytSNndOeE0wVnRhMC9lVVBWTFFSby9pT0lsNVpONk5iR0xSZmVTOXY5U3g2aVJmWmdaZ2Q2T1hNSDZkM0ciLCJtYWMiOiI5MjY0NjE1MWRhNjhlZDExMWU0YmU1ZGYwMTUwZWY3NmI2YTFjNjVjYjQzZTlhODgzNWMzM2NmNjk2YjM2YmIyIiwidGFnIjoiIn0%3D; expires=Fri, 04 Apr 2025 16:20:51 GMT; Max-Age=7200; path=/; httponly; samesite=laxra_holiday_session=eyJpdiI6Ikp1eEZzQXZ6aEZPdys5ejRkWFh6RXc9PSIsInZhbHVlIjoiK3RDQzdZbC82N2thNFlodjlZRXN5d1Zqa2NiRmNhOXZ5WW9UbFB0bVljNytiVUxuc2QweEZLU2luTHRhUUNkW" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6ImRPTEJPZlcvTDByUWZ0bk5iQ29Hb2c9PSIsInZhbHVlIjoieThKak5kdEZ2Sy9NZTg3anBvUnA0YjJla05HL1kwZWc0TWUzSldWTWZKTm8xdWhCUzBSNHhuV094WHVyVkpGQ0tsdVJNK1E2ZHlUVUtsam96WW9GUlpqZU54TytkRVdpMEVpTmU3STV0bzhxRTM0eUw1WERtcm5SNGUyL0NIbGYiLCJtYWMiOiJkYTUxOWJiYzgzMTZhNzUwMjg5YWJiNDBmOGQ2NDA5YzRmNjQwN2YyYjg5ZTQyMWU0NDY1OWY2NTQ0OWE1OWIzIiwidGFnIjoiIn0%3D; expires=Fri, 04-Apr-2025 16:20:51 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6ImRPTEJPZlcvTDByUWZ0bk5iQ29Hb2c9PSIsInZhbHVlIjoieThKak5kdEZ2Sy9NZTg3anBvUnA0YjJla05HL1kwZWc0TWUzSldWTWZKTm8xdWhCUzBSNHhuV094WHVyVkpGQ0tsdVJNK" 1 => "ra_holiday_session=eyJpdiI6Ikp1eEZzQXZ6aEZPdys5ejRkWFh6RXc9PSIsInZhbHVlIjoiK3RDQzdZbC82N2thNFlodjlZRXN5d1Zqa2NiRmNhOXZ5WW9UbFB0bVljNytiVUxuc2QweEZLU2luTHRhUUNkWkorUytSNndOeE0wVnRhMC9lVVBWTFFSby9pT0lsNVpONk5iR0xSZmVTOXY5U3g2aVJmWmdaZ2Q2T1hNSDZkM0ciLCJtYWMiOiI5MjY0NjE1MWRhNjhlZDExMWU0YmU1ZGYwMTUwZWY3NmI2YTFjNjVjYjQzZTlhODgzNWMzM2NmNjk2YjM2YmIyIiwidGFnIjoiIn0%3D; expires=Fri, 04-Apr-2025 16:20:51 GMT; path=/; httponlyra_holiday_session=eyJpdiI6Ikp1eEZzQXZ6aEZPdys5ejRkWFh6RXc9PSIsInZhbHVlIjoiK3RDQzdZbC82N2thNFlodjlZRXN5d1Zqa2NiRmNhOXZ5WW9UbFB0bVljNytiVUxuc2QweEZLU2luTHRhUUNkW" ] ]
          session_attributes
          0 of 0
          array:4 [ "_token" => "GNtdyJxVkEbfImuZUbIpS2GoOAMW77ccL98Fw7VL" "_previous" => array:1 [ "url" => "https://raholiday.com/tour/orange-bay-vip-exclusive-paradise-experience" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-04-04 14:20:51GET/tour/orange-bay-vip-exclusive-paradise-experience353224