Dubai Dolphinarium Overview
The Middle East’s first fully air-conditioned Dolphinarium - Dubai Dolphinarium provides non-stop family entertainment and fun in its up-to-date marine mammal facility. Spread over 5,000 square meters within Bur Dubai’s Creek Park, it is complete with cutting-edge sound / light system and a 180 degree amphitheater that has seating arranged around a salt water pool.
One of the key highlights of this amusement venue is the 45 minutes live Dolphins and Seal Show wherein the incredibly smart bottle nose dolphins and fur seals give spectacular performance while displaying their intelligence and interacting with the audience as well as trainers. This enables you to get closer with dolphins and seals and gain some interesting info on the incredible marine life.
As a great attraction ideal for all age groups, it is certain that these wonderfully friendly mammals will amaze you throughout with its unequaled acumen and agility. From your perfectly arranged indoor seating, you’ll get to watch them juggling with colorful balls, singing, painting, and even easily jumping through hoops, among other mindblowing acts.
Besides Dolphin show Dubai, you can add such interesting sessions to your Dubai Dolphinarium visit as Dolphin Meet and Greet, Up-close & Personal to Dolphins, and Majestic Dolphin Swim, allowing for some close encounters with this awesome creature. Another option available for your ticket upgrade is the exotic Creek Park Bird Show which is the first of its kind in the UAE.
Dubai Dolphinarium Highlights
· It’s the Middle East’s first dolphinarium that is set indoors and fully air-conditioned.
· You’ll get the unique chance to see, interact and get up close with the playful dolphins and seals here.
· The main highlight is the 45-minute Dolphin and Seal show where these adorable creatures will take your breath away with their brilliant acts.
· Watch them juggle, paint, dance, play basketballs and jump through hoops, among others.
· The stunning performance is staged in a vast pool that is 5.5 deep with over three million liters of water.
· With its 180-degree arena style seating, you can be assured of the best vantage point to enjoy the show.
· It’s located in one of Dubai’s most amazing parks at Dubai Creekside Park.
· You can make your Dubai Dolphinarium trip an absolute family outing by adding experiences such as the country’s one-of-its-kind Exotic Bird Show and Mirror Maze.
For marine and wildlife enthusiasts, there are more attractions such as the Green Planet Dubai and Dubai Aquarium and Penguin Encounter. Your little ones kids won’t get bored either; just take them to Ain Dubai Ferris Wheel, Mattel Play! Town Dubai, LEGOLAND Dubai, and KidZania Dubai, among other kids’ favourites in the region.
Dubai Dolphinarium Inclusions
· Transfers (if selected)
· Admission ticket to Dolphin Live Show
· Access to up-to-date marine mammal facility
· Perfect for people of all age groups
Dubai Dolphinarium How to Redeem
· Shortly after the completion of booking, you’ll receive your tour confirmation voucher in your email.
· Make sure that you check your spam / junk folder or notify us in case you don’t find it in your inbox.
· Print this voucher or show its mobile version to exchange it for your physical tickets once you arrive at the destination.
· Your voucher also features a QR code image which you can scan at the ticket counter to gain entry.
Dubai Dolphinarium Important Information
· Please arrive at the venue at least 30 minutes before the session commences.
· Shared transfers are only provided from centrally located hotels and residences in Dubai city. (Deira, Bur Dubai, Sheikh Zayed, Marina).
· The timings for transfers may vary, depending on traffic conditions and your location.
· All entrants must pay AED 5 to enter Creek Park with a NOL card; for tourist without NOL card, you can purchase this card at Creek Park Gate 1 amounting to AED 25 with AED 19 credit
· Child age is 2-12 years. Under 2 years is free of charge.
· For water activity, Children must be 8 years old or above, and confident swimmers.
· The venue usually provides basic facilities such as seating, refreshments, and souvenir shops.
· Pregnant women and people with injuries will not be allowed swimming with dolphin
· Swim with Dolphins' sessions will remain operational and accept bookings for this period.
Dolphin and Seal show -11am, 02pm and 05pm Exotic Bird show -12:15PM, 03:00PM and 06:00PM Swimming with the Dolphins - 10:45am, 01:30pm, 02:30pm and 04:15pm
دبى - الامارات العربية المتحدة
دبى - الامارات العربية المتحدة
دبى - الامارات العربية المتحدة
Dear Valued Visitor,
We are currently performing maintenance to enhance your experience on our website. During this time, online bookings may be temporarily unavailable.
However, we’re still here to assist you! You can book with us offline by WhatsApping us at +971 56 524 0107 or emailing us at info@rouvana.com.
We apologize for any inconvenience this may cause and appreciate your understanding. Thank you for your patience, and we look forward to serving you better soon!
Warm regards,
Rouvana Tours
| 1 x Application (69.66%) | 174.00ms |
| 1 x Booting (30.23%) | 75.51ms |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
select * from `bravo_events` where `slug` = 'dubai-dolphinarium' and `bravo_events`.`deleted_at` is null limit 13.55ms/modules/Event/Controllers/EventController.php:101u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_locations` where `bravo_locations`.`id` in (15) and `bravo_locations`.`deleted_at` is null1.36ms/modules/Event/Controllers/EventController.php:101u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `bravo_location_translations` where `locale` = 'egy' and `bravo_location_translations`.`origin_id` in (15)850μs/modules/Event/Controllers/EventController.php:101u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_event_translations` where `locale` = 'egy' and `bravo_event_translations`.`origin_id` in (102) and `bravo_event_translations`.`deleted_at` is null1.13ms/modules/Event/Controllers/EventController.php:101u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `user_wishlist` where `object_model` = 'event' and `user_id` = 0 and `user_wishlist`.`object_id` in (102)2.69ms/modules/Event/Controllers/EventController.php:101u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_events` where `location_id` = 15 and `status` = 'publish' and `id` not in (102) and `bravo_events`.`deleted_at` is null limit 41.4ms/modules/Event/Controllers/EventController.php:109u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_locations` where `bravo_locations`.`id` in (15) and `bravo_locations`.`deleted_at` is null410μs/modules/Event/Controllers/EventController.php:109u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `bravo_location_translations` where `locale` = 'egy' and `bravo_location_translations`.`origin_id` in (15)300μs/modules/Event/Controllers/EventController.php:109u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_event_translations` where `locale` = 'egy' and `bravo_event_translations`.`origin_id` in (97, 98, 100, 101) and `bravo_event_translations`.`deleted_at` is null740μs/modules/Event/Controllers/EventController.php:109u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `user_wishlist` where `object_model` = 'event' and `user_id` = 0 and `user_wishlist`.`object_id` in (97, 98, 100, 101)370μs/modules/Event/Controllers/EventController.php:109u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `bravo_review` where `object_id` = 102 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null780μs/modules/Event/Models/Event.php:726u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `location_category` where `status` = 'publish' and `location_category`.`deleted_at` is null560μs/modules/Event/Controllers/EventController.php:116u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `location_category_translations` where `locale` = 'egy' and `location_category_translations`.`origin_id` in (1, 2, 3)840μs/modules/Event/Controllers/EventController.php:116u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_seo` where `object_id` = 102 and `object_model` = 'event_translation_egy' limit 1550μs/app/BaseModel.php:199u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_locations` where (30 between `bravo_locations`.`_lft` and `bravo_locations`.`_rgt` and `bravo_locations`.`id` <> 15) and `bravo_locations`.`deleted_at` is null2.19ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:159u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 1510μs/app/BaseModel.php:135u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 1720μs/app/BaseModel.php:135u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 1430μs/app/BaseModel.php:135u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 1360μs/app/BaseModel.php:135u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 1420μs/app/BaseModel.php:135u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `media_files` where `media_files`.`id` = '' and `media_files`.`deleted_at` is null limit 1280μs/app/BaseModel.php:135u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select AVG(rate_number) as score_total , COUNT(id) as total_review from `bravo_review` where `object_id` = 102 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1950μs/modules/Event/Models/Event.php:677u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
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` = 102 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1920μs/modules/Event/Models/Event.php:689u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `user_wishlist` where `user_wishlist`.`object_id` = 102 and `user_wishlist`.`object_id` is not null and `object_model` = 'event'300μs/modules/Event/Models/Event.php:1037u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select AVG(rate_number) as score_total , COUNT(id) as total_review from `bravo_review` where `object_id` = 102 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 11.09ms/modules/Event/Models/Event.php:677u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
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` = 102 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 12.65ms/modules/Event/Models/Event.php:689u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
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` = 102 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 11.56ms/modules/Booking/Models/Bookable.php:357u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_event_term` where `bravo_event_term`.`target_id` = 102 and `bravo_event_term`.`target_id` is not null530μsview::bd460402903718cbc3260af005784b6e9889c686:2u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_terms` where `bravo_terms`.`id` in (767, 768) and `bravo_terms`.`deleted_at` is null340μs/modules/Core/Models/Terms.php:42u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_terms_translations` where `locale` = 'egy' and `bravo_terms_translations`.`origin_id` in (767, 768)940μs/modules/Core/Models/Terms.php:42u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_attrs` where `bravo_attrs`.`id` in (106) and `bravo_attrs`.`deleted_at` is null830μs/modules/Core/Models/Terms.php:42u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_attrs_translations` where `bravo_attrs_translations`.`origin_id` = 106 and `bravo_attrs_translations`.`origin_id` is not null and `locale` = 'egy' limit 1490μs/app/Traits/HasTranslations.php:51u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select AVG(rate_number) as score_total , COUNT(id) as total_review from `bravo_review` where `object_id` = 102 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 11.29ms/modules/Event/Models/Event.php:677u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
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` = 102 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1760μs/modules/Event/Models/Event.php:689u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `core_menu_translations` where `core_menu_translations`.`origin_id` = 2 and `core_menu_translations`.`origin_id` is not null and `locale` = 'egy' limit 1610μs/app/Traits/HasTranslations.php:51u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `core_pages` where `core_pages`.`id` = '20' and `core_pages`.`deleted_at` is null limit 1320μs/app/Helpers/AppHelper.php:627u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_popup_translations` where `bravo_popup_translations`.`origin_id` = 1 and `bravo_popup_translations`.`origin_id` is not null and `locale` = 'egy' limit 1400μs/app/Traits/HasTranslations.php:51u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
200
[]
[]
0 of 0array:22 [▼ "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 => "br" ] "host" => array:1 [▶ 0 => "rouvana.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" ] "x-forwarded-for" => array:1 [▶ 0 => "3.144.45.224" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "x-real-ip" => array:1 [▶ 0 => "3.144.45.224" ] "x-real-port" => array:1 [▶ 0 => "65361" ] "x-forwarded-port" => array:1 [▶ 0 => "443" ] "x-port" => array:1 [▶ 0 => "443" ] "x-lscache" => array:1 [▶ 0 => "1" ] "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" ] ]
0 of 0array:60 [▼ "LSPHP_ProcessGroup" => "on" "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT" => "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" "HTTP_ACCEPT_ENCODING" => "br" "HTTP_HOST" => "rouvana.com" "HTTP_PRAGMA" => "no-cache" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_X_FORWARDED_FOR" => "3.144.45.224" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_REAL_IP" => "3.144.45.224" "HTTP_X_REAL_PORT" => "65361" "HTTP_X_FORWARDED_PORT" => "443" "HTTP_X_PORT" => "443" "HTTP_X_LSCACHE" => "1" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_PRIORITY" => "u=0, i" "DOCUMENT_ROOT" => "/home/u479693165/domains/rouvana.com/public_html" "REMOTE_ADDR" => "3.144.45.224" "REMOTE_PORT" => "26228" "SERVER_ADDR" => "2a02:4780:11:1654:0:1c97:896d:3" "SERVER_NAME" => "rouvana.com" "SERVER_ADMIN" => "" "SERVER_PORT" => "443" "REQUEST_SCHEME" => "https" "REQUEST_URI" => "/egy/event/dubai-dolphinarium" "REDIRECT_URL" => "/public/egy/event/dubai-dolphinarium" "REDIRECT_REQUEST_METHOD" => "GET" "PROXY_REMOTE_ADDR" => "2a02:4780:1:25::2" "HTTPS" => "on" "CRAWLER_USLEEP" => "1000" "CRAWLER_LOAD_LIMIT_ENFORCE" => "25" "H_PLATFORM" => "Hostinger" "H_TYPE" => "shared" "H_CANARY" => "false" "H_STAGING" => "false" "REDIRECT_STATUS" => "200" "SSL_PROTOCOL" => "TLSv1.3" "SSL_CIPHER" => "TLS_AES_256_GCM_SHA384" "SSL_CIPHER_USEKEYSIZE" => "256" "SSL_CIPHER_ALGKEYSIZE" => "256" "SCRIPT_FILENAME" => "/home/u479693165/domains/rouvana.com/public_html/public/index.php" "QUERY_STRING" => "" "SCRIPT_URI" => "https://rouvana.com/egy/event/dubai-dolphinarium" "SCRIPT_URL" => "/egy/event/dubai-dolphinarium" "SCRIPT_NAME" => "/public/index.php" "SERVER_PROTOCOL" => "HTTP/1.1" "SERVER_SOFTWARE" => "LiteSpeed" "REQUEST_METHOD" => "GET" "X-LSCACHE" => "on,crawler,esi,combine" "PHP_SELF" => "/public/index.php" "REQUEST_TIME_FLOAT" => 1744232254.2055 "REQUEST_TIME" => 1744232254 ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Wed, 09 Apr 2025 20:57:34 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ik9EY1NiZHMyRldaWGFBc2YrWEJKMHc9PSIsInZhbHVlIjoiem5NbkVOVi93Y1JnWXNvVW9nTzJJdTdrZkloYklxN0hYYTJqT1d3T09oNm8wU0hkSURTa2tJcE55V1VNdjk1QTc2WGZZYWQxRlRJdXlGTklsQ085OGNvM2IwbkczYlpROEg1WTJSV2NaNUczNGZKa005Mkl5WUFMZVZpdGxqVDMiLCJtYWMiOiJhM2ZmNzI1OWRlYmRmZDQ5Mzg5ZGM2MmMyNmY1ZTI4MWM0ZjFiZmE5Zjc2YzJiMTk5Y2M5MmEwY2ZjOGNkNWJhIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 22:57:34 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ik9EY1NiZHMyRldaWGFBc2YrWEJKMHc9PSIsInZhbHVlIjoiem5NbkVOVi93Y1JnWXNvVW9nTzJJdTdrZkloYklxN0hYYTJqT1d3T09oNm8wU0hkSURTa2tJcE55V1VNdjk1QTc2WGZZY ▶" 1 => "rouvana_session=eyJpdiI6IlZtdVNsZVR4Q2VIRGVMVnR2Tm5lb3c9PSIsInZhbHVlIjoiakJkY3pLTXJEL295TWlFcGJDcm80cm4rc3NhZHpHZHZ0R01hTXZUa0c1MDY2YkswbEorSEFwT2dIalFNbkpBNGdKVGs2MDM0aitHOHF2bWRHVWZvQk03YnhBRGdHbGdOcmp0UUhzUit2Vis3akM5U0d0TzR1b0t3c3BVMnFJQXQiLCJtYWMiOiJkMjc1MWE5ZmYwNDA4NDViMzBhZWRiZDg1ODE2MzAzYzdkMGRkNTFlMjhkNjQzYmY5MTMyM2UwMDQ0NzU2YWFlIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 22:57:34 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀rouvana_session=eyJpdiI6IlZtdVNsZVR4Q2VIRGVMVnR2Tm5lb3c9PSIsInZhbHVlIjoiakJkY3pLTXJEL295TWlFcGJDcm80cm4rc3NhZHpHZHZ0R01hTXZUa0c1MDY2YkswbEorSEFwT2dIalFNbkpBNGdK ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ik9EY1NiZHMyRldaWGFBc2YrWEJKMHc9PSIsInZhbHVlIjoiem5NbkVOVi93Y1JnWXNvVW9nTzJJdTdrZkloYklxN0hYYTJqT1d3T09oNm8wU0hkSURTa2tJcE55V1VNdjk1QTc2WGZZYWQxRlRJdXlGTklsQ085OGNvM2IwbkczYlpROEg1WTJSV2NaNUczNGZKa005Mkl5WUFMZVZpdGxqVDMiLCJtYWMiOiJhM2ZmNzI1OWRlYmRmZDQ5Mzg5ZGM2MmMyNmY1ZTI4MWM0ZjFiZmE5Zjc2YzJiMTk5Y2M5MmEwY2ZjOGNkNWJhIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 22:57:34 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ik9EY1NiZHMyRldaWGFBc2YrWEJKMHc9PSIsInZhbHVlIjoiem5NbkVOVi93Y1JnWXNvVW9nTzJJdTdrZkloYklxN0hYYTJqT1d3T09oNm8wU0hkSURTa2tJcE55V1VNdjk1QTc2WGZZY ▶" 1 => "rouvana_session=eyJpdiI6IlZtdVNsZVR4Q2VIRGVMVnR2Tm5lb3c9PSIsInZhbHVlIjoiakJkY3pLTXJEL295TWlFcGJDcm80cm4rc3NhZHpHZHZ0R01hTXZUa0c1MDY2YkswbEorSEFwT2dIalFNbkpBNGdKVGs2MDM0aitHOHF2bWRHVWZvQk03YnhBRGdHbGdOcmp0UUhzUit2Vis3akM5U0d0TzR1b0t3c3BVMnFJQXQiLCJtYWMiOiJkMjc1MWE5ZmYwNDA4NDViMzBhZWRiZDg1ODE2MzAzYzdkMGRkNTFlMjhkNjQzYmY5MTMyM2UwMDQ0NzU2YWFlIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 22:57:34 GMT; path=/; httponly ◀rouvana_session=eyJpdiI6IlZtdVNsZVR4Q2VIRGVMVnR2Tm5lb3c9PSIsInZhbHVlIjoiakJkY3pLTXJEL295TWlFcGJDcm80cm4rc3NhZHpHZHZ0R01hTXZUa0c1MDY2YkswbEorSEFwT2dIalFNbkpBNGdK ▶" ] ]
0 of 0array:4 [▼ "_token" => "n0Ft5BDVXhjVW88sCU5Ws0bJiJZrg2iRTXLyz9YY" "_previous" => array:1 [▶ "url" => "https://rouvana.com/egy/event/dubai-dolphinarium" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]