Contact Us:  
Tour Video

Dolphin show

Dolphin World Egypt, Hurghada 1, Egypt

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

Duration

4 Hours

Tour Type

Trips in hurghada

Location

Hurghada

Overview

Embark on a thrilling and educational adventure at the renowned dolphin show in Hurghada.

This captivating one-hour event begins with an informative introduction to dolphin behavior and ongoing conservation efforts, setting the stage for an extraordinary live performance.

Watch in awe as a group of expertly trained dolphins display their incredible talents through high-energy acrobatic jumps, synchronized flips, and impressive stunts. Their interaction with professional trainers showcases not only their intelligence but also the strong bond between humans and marine life.

Throughout the show, you’ll have the opportunity to take memorable photos and gain a deeper appreciation for dolphins and their natural environments.

Enhancing the experience further, the performance includes appearances by other fascinating marine animals such as walruses and sea cows, offering a diverse and engaging spectacle suitable for all ages.

Led by experienced marine trainers, this show is both entertaining and enlightening, aiming to inspire greater awareness about marine conservation and the importance of protecting our oceans’ most remarkable creatures.

 

Don’t miss this unforgettable experience—discover the magic of marine life in Hurghada!

Included/Excluded

Transfer from and to hotel
Photo session and video with the photographer
Tips

Travel Styles

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

Dolphin World Egypt, Hurghada 1, 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
21%
from $35 $28
Book
Enquiry
Please select date!
From 11 years and above
$28 per person
from 5 - 11 years old
$14 per person
BOOK NOW
Monday 08:00 - 19:00
Tuesday 08:00 - 19:00
Wednesday 08:00 - 19:00
Thursday 08:00 - 19:00
Friday 08:00 - 19:00
Saturday Closed
Sunday 08:00 - 19:00

You might also like

15%
Family Photo session with dolphins
Hurghada
Family Photo session with dolphins
0 Review
4H
from
$130 $110
17%
Photo Session with Dolphin
Hurghada
Photo Session with Dolphin
0 Review
4H
from
$60 $50
16%
Swimming with Dolphins
Hurghada
Swimming with Dolphins
0 Review
4H
from
$60 $50
7%
Swimming + Photo session with Dolphins
Hurghada
Swimming + Photo session with Dolphins
0 Review
4H
from
$95 $88
from
$35 $28
0 Review
Book Now

Get Updates & More

Thoughtful thoughts to your inbox

Do you need help?
Call Us
+ 20 115 700 2392
+ 20 114 330 4640
Sen us an e-mail
info@raholiday.com
Follow us
Travel agency
Suport

Copyright © 2022 RA Holiday Co. All rights reserved.

Developed by 

MessagesTimelineExceptionsViews38RouteQueries32Models28MailsAuthGateSessionRequest
Request history8.1.14PHP Version697msRequest Duration6MBMemory UsageGET tour/{slug}RouteAuth status
    • Booting (209ms)time
    • Application (488ms)time
    • 1 x Application (70.05%)
      488ms
      1 x Booting (29.94%)
      209ms
      38 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
      • 4x 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 duplicated95.79ms
      • select * from `bravo_tours` where `slug` = 'dolphin-show' and `bravo_tours`.`deleted_at` is null limit 13.68msraholidayTourController.php#107
        Bindings
        • 0: dolphin-show
        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 null2.03msraholidayTourController.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)360μsraholidayTourController.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 (68)2msraholidayTourController.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 (68)2.1msraholidayTourController.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 (68) and `bravo_tours`.`deleted_at` is null limit 4400μsraholidayTourController.php#115
        Bindings
        • 0: 1
        • 1: publish
        • 2: 68
        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 null8.37msraholidayTourController.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)340μsraholidayTourController.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 (69, 70, 71, 72)2.11msraholidayTourController.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 (69, 70, 71, 72)300μsraholidayTourController.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` = 68 and `object_model` = 'tour' and `status` = 'approved' and `bravo_review`.`deleted_at` is null3.95msraholidayTour.php#831
        Bindings
        • 0: 68
        • 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` = 68 and `bravo_tour_meta`.`tour_id` is not null limit 14.64msraholidayTour.php#592
        Bindings
        • 0: 68
        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` = 68 and `object_model` = 'tour' limit 1420μsraholidayBaseModel.php#199
        Bindings
        • 0: 68
        • 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 null6.78msraholidayTourController.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.31msraholidayTourController.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 null3.25msraholidayQueryBuilder.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` = 68 and `object_model` = 'tour' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 13.59msraholidayTour.php#757
        Bindings
        • 0: 68
        • 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` = 68 and `object_model` = 'tour' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1350μsraholidayTour.php#769
        Bindings
        • 0: 68
        • 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` = 68 and `object_model` = 'tour' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 16.22msraholidayBookable.php#359
        Bindings
        • 0: 68
        • 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 12.05msraholidaytour-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)320μsraholidaytour-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.26msraholidayBaseModel.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 12.31msraholidayBaseModel.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 14.11msraholidayBaseModel.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.63msraholidayBaseModel.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` = 68 and `bravo_tour_term`.`tour_id` is not null6.16msraholidaytour-attributes.blade.php#2
        Bindings
        • 0: 68
        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 (5) and `bravo_terms`.`deleted_at` is null2.3msraholidayTerms.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 (5)5.05msraholidayTerms.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 null350μsraholidayTerms.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 1320μsraholidayHasTranslations.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 18.46msraholidayHasTranslations.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 13.27msraholidayHasTranslations.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\Tour\Models\Tour
      5Tour.php#?
      Modules\Tour\Models\TourTranslation
      5TourTranslation.php#?
      Modules\Location\Models\LocationCategory
      3LocationCategory.php#?
      Modules\Review\Models\Review
      3Review.php#?
      Modules\Location\Models\Location
      2Location.php#?
      Modules\Location\Models\LocationTranslation
      2LocationTranslation.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\Tour\Models\TourTerm
      1TourTerm.php#?
      Modules\Core\Models\Terms
      1Terms.php#?
      Modules\Core\Models\Attributes
      1Attributes.php#?
        web
        null
        sanctum
        null
          _token
          qv5NAH4SOyiiJ9TzabQJRVCmMdWft4LJaIfK5Ald
          _previous
          array:1 [ "url" => "https://raholiday.com/public/tour/dolphin-show" ]
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /tour/dolphin-show
          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 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "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 => "Sat, 17 May 2025 04:46:09 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlZNcjZWMFkwSW13dFRsR3MxZVkrUFE9PSIsInZhbHVlIjoiOW41c3p6ZmEwZkpQQnpqaVlNbHBWNmZUL3BBWWdCTXVLRjQ3UC9MMGhwM3hSOXlYWUJVY05CeXVvTTZONGZabTVWcmpwdkhjR2FiUENCY2krbWtsRlJGL0w4VHIwYjJpeDJUc0FiTW5tT3hDZkVUOUd0Ky9LMk1BZEZCK1p5aHYiLCJtYWMiOiJkY2RjNTFkYmNkNjdlM2QxNWI0ZDEwNWZiZjlkNzE0MTBjNWU5ZDg2NmVkZTc2ZjE2NmRhOGQ3MjUzMjYxOWZlIiwidGFnIjoiIn0%3D; expires=Sat, 17 May 2025 06:46:09 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IlZNcjZWMFkwSW13dFRsR3MxZVkrUFE9PSIsInZhbHVlIjoiOW41c3p6ZmEwZkpQQnpqaVlNbHBWNmZUL3BBWWdCTXVLRjQ3UC9MMGhwM3hSOXlYWUJVY05CeXVvTTZONGZabTVWcmpwd ▶"
    1 => "ra_holiday_session=eyJpdiI6Im1QUS9GUHlhU0xoRVhqaG91OTNCT3c9PSIsInZhbHVlIjoiUTh0WVNBczZlNjZEZ2YxdE8zbGt0SWYzMlB0TUdUK3NZbmszY3I4ZUJEQ0tDTUdwNVJVUzllc0o1d1Vib1RDdjVDL0U2a2NybTlDSWswYjRjVmZCZzJMSmMvdENlN1lLejk5cTM3NDFnUzllenp0aDRsWWI5MmJCSW1BT09VY24iLCJtYWMiOiJmZWUxODg2MDM2YjFkM2Q0OTQ2NWI5MTZlNTgzYzM4ODMzNTkwMmFkNDQwYjBkODUzYzI4MzljMDg5ZTZjN2VkIiwidGFnIjoiIn0%3D; expires=Sat, 17 May 2025 06:46:09 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀ra_holiday_session=eyJpdiI6Im1QUS9GUHlhU0xoRVhqaG91OTNCT3c9PSIsInZhbHVlIjoiUTh0WVNBczZlNjZEZ2YxdE8zbGt0SWYzMlB0TUdUK3NZbmszY3I4ZUJEQ0tDTUdwNVJVUzllc0o1d1Vib1RDd ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlZNcjZWMFkwSW13dFRsR3MxZVkrUFE9PSIsInZhbHVlIjoiOW41c3p6ZmEwZkpQQnpqaVlNbHBWNmZUL3BBWWdCTXVLRjQ3UC9MMGhwM3hSOXlYWUJVY05CeXVvTTZONGZabTVWcmpwdkhjR2FiUENCY2krbWtsRlJGL0w4VHIwYjJpeDJUc0FiTW5tT3hDZkVUOUd0Ky9LMk1BZEZCK1p5aHYiLCJtYWMiOiJkY2RjNTFkYmNkNjdlM2QxNWI0ZDEwNWZiZjlkNzE0MTBjNWU5ZDg2NmVkZTc2ZjE2NmRhOGQ3MjUzMjYxOWZlIiwidGFnIjoiIn0%3D; expires=Sat, 17-May-2025 06:46:09 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IlZNcjZWMFkwSW13dFRsR3MxZVkrUFE9PSIsInZhbHVlIjoiOW41c3p6ZmEwZkpQQnpqaVlNbHBWNmZUL3BBWWdCTXVLRjQ3UC9MMGhwM3hSOXlYWUJVY05CeXVvTTZONGZabTVWcmpwd ▶"
    1 => "ra_holiday_session=eyJpdiI6Im1QUS9GUHlhU0xoRVhqaG91OTNCT3c9PSIsInZhbHVlIjoiUTh0WVNBczZlNjZEZ2YxdE8zbGt0SWYzMlB0TUdUK3NZbmszY3I4ZUJEQ0tDTUdwNVJVUzllc0o1d1Vib1RDdjVDL0U2a2NybTlDSWswYjRjVmZCZzJMSmMvdENlN1lLejk5cTM3NDFnUzllenp0aDRsWWI5MmJCSW1BT09VY24iLCJtYWMiOiJmZWUxODg2MDM2YjFkM2Q0OTQ2NWI5MTZlNTgzYzM4ODMzNTkwMmFkNDQwYjBkODUzYzI4MzljMDg5ZTZjN2VkIiwidGFnIjoiIn0%3D; expires=Sat, 17-May-2025 06:46:09 GMT; path=/; httponly ◀ra_holiday_session=eyJpdiI6Im1QUS9GUHlhU0xoRVhqaG91OTNCT3c9PSIsInZhbHVlIjoiUTh0WVNBczZlNjZEZ2YxdE8zbGt0SWYzMlB0TUdUK3NZbmszY3I4ZUJEQ0tDTUdwNVJVUzllc0o1d1Vib1RDd ▶"
  ]
]
          session_attributes
            0 of 0   
          array:4 [▼
  "_token" => "qv5NAH4SOyiiJ9TzabQJRVCmMdWft4LJaIfK5Ald"
  "_previous" => array:1 [▶
    "url" => "https://raholiday.com/public/tour/dolphin-show"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]
          ClearShow all
          Date ↕MethodURLData
          #12025-05-17 04:46:09GET/public/tour/dolphin-show383228