Seaworld From Dubai Overview
Embark on an immersive journey to SeaWorld Abu Dhabi from Dubai! It is the region’s first marine life theme park that promises you a captivating adventure like no other. Venture through the park’s eight realms as you gain an in-depth understanding of the beauty and diversity of the ocean and its inhabitants. It is also a hub of amusement and education, with its fascinating rides, captivating shows, and enlightening initiatives dedicated to conserving and protecting marine life.
WHAT TO EXPECT
See Up-Close Marine Marvels
Witness diverse marine species and habitats as you set out to discover the eight realms at SeaWorld from Dubai! Each realm offers a unique and awe-inspiring marine encounter that will leave you breathless. Experience the immersive tales of interconnectedness between the planet and the ocean coming to life at One Ocean Realm. Discover the Arabian Gulf's vibrant marine ecosystem in the Abu Dhabi Ocean Realm. Journey to Rocky Point and admire the wonders of the Pacific West. You can further delve into the Arctic region's life cycle in the Arctic realm.
Feel the Chills and Thrills
Brace yourself for breathtaking experiences at the 180,000-square-meter marine life park. Be transported to a polar wonderland in the Antarctic realm, where you can observe Antarctic and sub-Antarctic penguins in their icy habitat. The most astonishing adventures await you at the Endless Ocean realm, home to the world's largest aquarium with over 68,000 underwater animals. You can expect some exhilarating encounters as you marvel at the graceful rays, formidable sharks, and enchanting turtles.
Education Meets Excitement
SeaWorld Abu Dhabi is more than a place to catch diverse marine species and habitats. It offers a blend of entertainment, education, and conservation that will leave you amazed and inspired. Enjoy thrilling rides, interactive exhibits, and captivating shows that showcase the ocean's wonders. From pearl diving shows to sea lion encounters and dolphin presentations, a spectrum of marine-inspired experiences will entertain you. It is also committed to marine conservation and protection, being MENA's first Global Humane-certified facility.
Seaworld From Dubai Highlights
· Dive into the enigmatic marine world while visiting the UAE's first and premier marine life theme park from the water.
· Discover the eight realms across five levels occupying the 180,000-square-meter facility.
· Be greeted by the most astounding marine attractions and experiences, including the One Ocean and the largest-of-its-kind aquarium, boasting an astonishing 58 million liters of water with rays, sharks, etc.
· Buckle up for thrilling rides, meet exciting live characters, and enjoy over 100 amusing shows, all inspired by marine life.
· Prepare to be enlightened on the park's preservation and protection initiatives of the marine ecosystems at its unique zones, such as Yas SeaWorld Research & Rescue Yas Island.
· Take your quest for fun and thrill beyond the park's boundaries, with its location on Yas Island featuring attractions like Ferrari World, Warner Bros. Abu Dhabi, and Yas Waterworld.
Seaworld From Dubai Inclusions
· SeaWorld Abu Dhabi Admission Tickets
· Access to eight realms
· Up-close encounter with over 68,000 marine counters
· Entry into rides, shows, and attractions (subject to the ticket choice)
· Roundtrip hotel transfers (to and from Dubai only if chosen at the time of booking)
Seaworld From Dubai Exclusions
· All personal expenses spend for shopping, drinks and dining etc on-site during the tour.
Seaworld From Dubai How to Redeem
· To redeem your tickets, please ensure you have either your E-tickets or printed copies with you.
· Approach the turnstiles and place your tickets against the scanner.
· Once scanned, you can proceed to enter the venue and embark on a memorable trip.
Seaworld From Dubai Important Information
· There will be no refund for unused or partially used services.
· Children must be accompanied by an adult throughout the visit.
· ATMs, Prayer rooms, Baby changing and feeding facilities, smoking areas are located on the Plaza level.
· Valet parking, Lockers, and Strollers are available on extra charges at the venue itself.
· The service provider holds no responsibility if any component of an attraction is non-operational due to technical reasons.
· Guests are prohibited from bringing food and drinks into the Park.
ابوظبي، الامارات العربية المتحدة
ابوظبي، الامارات العربية المتحدة
ابوظبي، الامارات العربية المتحدة
ابوظبي، الامارات العربية المتحدة
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 (59.79%) | 490.97ms |
| 1 x Booting (40.16%) | 329.79ms |
| 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 | |
| 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` = 'seaworld-from-dubai-price-offers' and `bravo_events`.`deleted_at` is null limit 15.56ms/modules/Event/Controllers/EventController.php:101u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_locations` where `bravo_locations`.`id` in (18) and `bravo_locations`.`deleted_at` is null570μs/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 (18)450μ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 (130) and `bravo_event_translations`.`deleted_at` is null440μs/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 (130)1.33ms/modules/Event/Controllers/EventController.php:101u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_events` where `location_id` = 18 and `status` = 'publish' and `id` not in (130) and `bravo_events`.`deleted_at` is null limit 41.41ms/modules/Event/Controllers/EventController.php:109u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_locations` where `bravo_locations`.`id` in (18) and `bravo_locations`.`deleted_at` is null340μ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 (18)400μ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 (99, 105, 106, 107) and `bravo_event_translations`.`deleted_at` is null960μ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 (99, 105, 106, 107)300μs/modules/Event/Controllers/EventController.php:109u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `bravo_review` where `object_id` = 130 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null1.36ms/modules/Event/Models/Event.php:726u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `location_category` where `status` = 'publish' and `location_category`.`deleted_at` is null420μ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)1.55ms/modules/Event/Controllers/EventController.php:116u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_seo` where `object_id` = 130 and `object_model` = 'event_translation_egy' limit 1620μs/app/BaseModel.php:199u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_locations` where (38 between `bravo_locations`.`_lft` and `bravo_locations`.`_rgt` and `bravo_locations`.`id` <> 18) and `bravo_locations`.`deleted_at` is null520μs/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 1380μ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 1590μ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 1660μ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 1670μ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 1460μ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` = 130 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 11.58ms/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` = 130 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1990μ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` = 130 and `user_wishlist`.`object_id` is not null and `object_model` = 'event'580μ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` = 130 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 12.43ms/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` = 130 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 11.1ms/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` = 130 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 11.32ms/modules/Booking/Models/Bookable.php:357u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_event_term` where `bravo_event_term`.`target_id` = 130 and `bravo_event_term`.`target_id` is not null520μsview::bd460402903718cbc3260af005784b6e9889c686:2u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select AVG(rate_number) as score_total , COUNT(id) as total_review from `bravo_review` where `object_id` = 130 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` = 130 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 11.15ms/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 1420μ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 1310μ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.19.188.198" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "x-real-ip" => array:1 [▶ 0 => "3.19.188.198" ] "x-real-port" => array:1 [▶ 0 => "13628" ] "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.19.188.198" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_REAL_IP" => "3.19.188.198" "HTTP_X_REAL_PORT" => "13628" "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.19.188.198" "REMOTE_PORT" => "24576" "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/seaworld-from-dubai-price-offers" "REDIRECT_URL" => "/public/egy/event/seaworld-from-dubai-price-offers" "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/seaworld-from-dubai-price-offers" "SCRIPT_URL" => "/egy/event/seaworld-from-dubai-price-offers" "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" => 1744386884.0489 "REQUEST_TIME" => 1744386884 ]
[]
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 => "Fri, 11 Apr 2025 15:54:44 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ik9POWFwb3ljRTdYOUVNVkcrcDFCK2c9PSIsInZhbHVlIjoiSUYyNU9nbWRjREkya0xKMk5wT0k4YkVUeEZmSzlpa0xTQUw3RXZGa0plNHlnRnlERHNKZjZSYk9UbGpNSHloQnRCNTQxaU4wYXd1WUxOWGVrOGdFS3JTNVpXaHJKaTJyWjN4QjZCcVBxSTVZZkxpWWRDWUNWeThtUStzVDJUQlAiLCJtYWMiOiIwMGZkOTI0NDJhYWZlNjQ3YmQxNjNhOGMwZTg2MWE0NzRkMDQ5MDRkYmZmYTM3NGNlNTUyNzI0ZDA2NGNmYjQ1IiwidGFnIjoiIn0%3D; expires=Fri, 11-Apr-2025 17:54:44 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ik9POWFwb3ljRTdYOUVNVkcrcDFCK2c9PSIsInZhbHVlIjoiSUYyNU9nbWRjREkya0xKMk5wT0k4YkVUeEZmSzlpa0xTQUw3RXZGa0plNHlnRnlERHNKZjZSYk9UbGpNSHloQnRCNTQxa ▶" 1 => "rouvana_session=eyJpdiI6Ik01dExpMGhhaFNmUkI1NnBOem1abnc9PSIsInZhbHVlIjoiWGZDSUFHb3Awa3RINXpId29BNHZoYzl5ZFRhRjJ4MGxjaEJYWkFFVEVkNm5RcFpIazFpZzRoWkZmWXp3bHFnL2ZhVHlQdG1OcTNSQU1lS1pZUE1CVElicUgxdVE4cFdwdDNIc1U1eUIxYkpQZklSeXdZd0lIdmVyZGNLWTM3Tk0iLCJtYWMiOiI3MzJmNDVlMjIxYTQzZGIxZDdkZGY2MjJjNjliNGFkY2MyYzg5MzJiOTM4NzAzZjU1OWQzNmY0ZjAzNDA2MGY2IiwidGFnIjoiIn0%3D; expires=Fri, 11-Apr-2025 17:54:44 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀rouvana_session=eyJpdiI6Ik01dExpMGhhaFNmUkI1NnBOem1abnc9PSIsInZhbHVlIjoiWGZDSUFHb3Awa3RINXpId29BNHZoYzl5ZFRhRjJ4MGxjaEJYWkFFVEVkNm5RcFpIazFpZzRoWkZmWXp3bHFnL2Zh ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ik9POWFwb3ljRTdYOUVNVkcrcDFCK2c9PSIsInZhbHVlIjoiSUYyNU9nbWRjREkya0xKMk5wT0k4YkVUeEZmSzlpa0xTQUw3RXZGa0plNHlnRnlERHNKZjZSYk9UbGpNSHloQnRCNTQxaU4wYXd1WUxOWGVrOGdFS3JTNVpXaHJKaTJyWjN4QjZCcVBxSTVZZkxpWWRDWUNWeThtUStzVDJUQlAiLCJtYWMiOiIwMGZkOTI0NDJhYWZlNjQ3YmQxNjNhOGMwZTg2MWE0NzRkMDQ5MDRkYmZmYTM3NGNlNTUyNzI0ZDA2NGNmYjQ1IiwidGFnIjoiIn0%3D; expires=Fri, 11-Apr-2025 17:54:44 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ik9POWFwb3ljRTdYOUVNVkcrcDFCK2c9PSIsInZhbHVlIjoiSUYyNU9nbWRjREkya0xKMk5wT0k4YkVUeEZmSzlpa0xTQUw3RXZGa0plNHlnRnlERHNKZjZSYk9UbGpNSHloQnRCNTQxa ▶" 1 => "rouvana_session=eyJpdiI6Ik01dExpMGhhaFNmUkI1NnBOem1abnc9PSIsInZhbHVlIjoiWGZDSUFHb3Awa3RINXpId29BNHZoYzl5ZFRhRjJ4MGxjaEJYWkFFVEVkNm5RcFpIazFpZzRoWkZmWXp3bHFnL2ZhVHlQdG1OcTNSQU1lS1pZUE1CVElicUgxdVE4cFdwdDNIc1U1eUIxYkpQZklSeXdZd0lIdmVyZGNLWTM3Tk0iLCJtYWMiOiI3MzJmNDVlMjIxYTQzZGIxZDdkZGY2MjJjNjliNGFkY2MyYzg5MzJiOTM4NzAzZjU1OWQzNmY0ZjAzNDA2MGY2IiwidGFnIjoiIn0%3D; expires=Fri, 11-Apr-2025 17:54:44 GMT; path=/; httponly ◀rouvana_session=eyJpdiI6Ik01dExpMGhhaFNmUkI1NnBOem1abnc9PSIsInZhbHVlIjoiWGZDSUFHb3Awa3RINXpId29BNHZoYzl5ZFRhRjJ4MGxjaEJYWkFFVEVkNm5RcFpIazFpZzRoWkZmWXp3bHFnL2Zh ▶" ] ]
0 of 0array:4 [▼ "_token" => "tmo0IV7ZRkGIsv6FjFZ6svzb8mIteb8Hhl6bZ2eI" "_previous" => array:1 [▶ "url" => "https://rouvana.com/egy/event/seaworld-from-dubai-price-offers" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]