SeaWorld Abu Dhabi Overview
SeaWorld Abu Dhabi at Yas Island is the region’s first marine life theme park. Besides up-close encounters with hundreds of thousands of aquatic animals, it offers a broad spectrum of attractions and experiences that combine entertainment, education, and conservation initiatives. Stroll around its eight fantastically themed zones, learn about over 150 marine species, hit thrilling rides and immersive shows, and refuel your energy at 17 culinary venues across the park.
WHAT TO EXPECT
Exciting Marine Encounters and Habitats
Be ready for the most extraordinary moments with marine creatures as you start the exploration of SeaWorld’s eight realms. Enter One Ocean, whose focal point is a 360-degree experience that narrates immersive tales of connections that life on our planet and in the ocean share. At Abu Dhabi Ocean Realm, enlighten yourself on the Arabian Gulf’s astonishing marine biodiversity. Discover the Pacific West’s oceanic wonders as you step into Rocky Point, and feel the Arctic region’s incredible ecosystem and lifecycle in the aptly named Arctic realm.
Delight in Polar Paradise and the World’s Largest Aquarium
With temperatures maintained at one degree C, the park’s Antarctica realm allows you to take in the precious marine life that inhabits the icy wonderland (Antarctica region). See Antarctic and sub-Antarctic penguins, and even watch out for their adorable plays. One of the most breathtaking marine experiences awaits you at the Endless Ocean realm, whose highlight is the largest of its kind aquarium. It shelters over 68,000 underwater animals, showcasing diverse marine habitats. See rays, sharks, turtles, and schools of fish.
Dive into Unmatched Aquatic Thrills & Marine Education
Each segment in the park is unique for its marine exhibits and shows and experiences. Depending on the SeaWorld Abu Dhabi tickets, you can watch mesmerizing pearl diving shows, have exhilarating sea lion encounters, and take in dolphin presentations. You can also make the most of the exhilarating rides, such as Arctic’s Hypersphere 360° and Microocean’s captivating rides. But it is more than just a place to enjoy marine-inspired attractions. As the MENA region’s first Global-Humane-certified facility, the park lets you become part of its sea life conservation and protection activities.
SeaWorld Abu Dhabi Highlights
· Immerse yourself in the captivating and mysterious marine world at the UAE’s first marine life theme park, featuring the world’s biggest aquarium, with over 58 million liters of water.
· Witness an astonishing collection of over 68,000 underwater creatures as you wander around this 180,000-square-meter facility with eight zones spread over five levels.
· Explore fascinating realms that unfold the narrative of ‘One Ocean,’ indicating the profound, intricate connection between the ocean and living beings on the planet.
· Take to thrilling rides, check out interactive attractions, catch up with live characters, and watch over 100 shows and experiences that blend entertainment with fantastic marine life themes.
· Discover its enlightening segments, such as the region’s first-of-its-kind Yas SeaWorld Research & Rescue Yas Island.
· Add more amusement and thrill to your outing with its location on Yas Island, also home to Ferrari World, Yas Waterworld, and Warner Bros. Abu Dhabi, to name a few.
SeaWorld Abu Dhabi Inclusions
· Entry ticket to SeaWorld Abu Dhabi 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 (only if chosen at the time of booking)
SeaWorld Abu Dhabi Exclusions
· All personal expenses spend for shopping, drinks and dining etc on-site during the tour.
SeaWorld Abu Dhabi 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 Abu Dhabi Important Information
· There will be no refund for unused or partially used services.
· Children must be accompanied by an adult at all times.
· 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 (85.85%) | 450.41ms |
| 1 x Booting (14.13%) | 74.15ms |
| 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-abu-dhabi' and `bravo_events`.`deleted_at` is null limit 13.43ms/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 null660μ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)640μ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 (123) and `bravo_event_translations`.`deleted_at` is null380μ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 (123)340μs/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 (123) and `bravo_events`.`deleted_at` is null limit 41.03ms/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 null250μ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)870μ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 null390μ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)580μs/modules/Event/Controllers/EventController.php:109u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `bravo_review` where `object_id` = 123 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null1.16ms/modules/Event/Models/Event.php:726u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `location_category` where `status` = 'publish' and `location_category`.`deleted_at` is null300μ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)320μs/modules/Event/Controllers/EventController.php:116u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_seo` where `object_id` = 123 and `object_model` = 'event_translation_egy' limit 11.39ms/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 null1.07ms/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 1730μ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 1260μ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 1260μ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 1560μ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 1230μ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` = 123 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 12.13ms/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` = 123 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 11ms/modules/Event/Models/Event.php:689u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `user_wishlist` where `user_wishlist`.`object_id` = 123 and `user_wishlist`.`object_id` is not null and `object_model` = 'event'700μ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` = 123 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 11.8ms/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` = 123 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 12.02ms/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` = 123 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 12.55ms/modules/Booking/Models/Bookable.php:357u479693165_rouvfbqk_travi| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `bravo_event_term` where `bravo_event_term`.`target_id` = 123 and `bravo_event_term`.`target_id` is not null1.11msview::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` = 123 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1860μ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` = 123 and `object_model` = 'event' and `status` = 'approved' and `bravo_review`.`deleted_at` is null limit 1810μ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 11.09ms/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 1590μ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 11.18ms/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.131.38.255" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "x-real-ip" => array:1 [▶ 0 => "3.131.38.255" ] "x-real-port" => array:1 [▶ 0 => "56650" ] "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.131.38.255" "HTTP_X_FORWARDED_PROTO" => "https" "HTTP_X_REAL_IP" => "3.131.38.255" "HTTP_X_REAL_PORT" => "56650" "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.131.38.255" "REMOTE_PORT" => "46576" "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-abu-dhabi" "REDIRECT_URL" => "/public/egy/event/seaworld-abu-dhabi" "REDIRECT_REQUEST_METHOD" => "GET" "PROXY_REMOTE_ADDR" => "2a02:4780:1:22::3" "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-abu-dhabi" "SCRIPT_URL" => "/egy/event/seaworld-abu-dhabi" "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" => 1744230127.5843 "REQUEST_TIME" => 1744230127 ]
[]
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:22:07 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InJkRnI3TkY1bHUxajdXWEYyU0drYWc9PSIsInZhbHVlIjoiODZOK0FXWDM5bDIvWlhvbzhpeWNsbEJyZ0Z5UE1kSGprUlJUNVhTZDVUMWxzd3lkYkhCMHlLN1RCb1hoRjVhajM5YmtGd1pSZmdvUGZUYVZTYjE2NGp6L1FPbmNwa0Y0cHplK3NyT1NvU25xb0QxWWpHMnVQQzd2YS95YnVENU4iLCJtYWMiOiI4MmEyZDRiODI2YzY1OTEwYjgwMGE2NDdlYTEzMWM1NzY3NzQzOGEzZjIxY2RmMTA1NTc1ZjNmNjI4OGRjYWIxIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 22:22:08 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6InJkRnI3TkY1bHUxajdXWEYyU0drYWc9PSIsInZhbHVlIjoiODZOK0FXWDM5bDIvWlhvbzhpeWNsbEJyZ0Z5UE1kSGprUlJUNVhTZDVUMWxzd3lkYkhCMHlLN1RCb1hoRjVhajM5YmtGd ▶" 1 => "rouvana_session=eyJpdiI6InZtc3lNVXRLN3MwKzBaNmhCUEtUN3c9PSIsInZhbHVlIjoiY0V1S3RqNzRjZmpFQzR5OHRyUHhCUUIxRmp6ZVg4TWVPWmhjMndQYnduRlBISnJEN0NrY2hQZkplcTgvT29SWjBIYXNDa3ppL1BYTVFaa1U5NWVNeUloTTRPc29YSUl2QTNVVWEwWVV4OTRGTUVOTUVGWk1IU2VuVlBDc3g4UUQiLCJtYWMiOiI4ZjE0NGQwMGNjMTE4Y2IxNjA1Y2IxOWQ5NDQzYTg5NThiMGNjN2ZlNmQyN2VjYzc1MzI5ZGJlYjAwZDZhNzgwIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 22:22:08 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀rouvana_session=eyJpdiI6InZtc3lNVXRLN3MwKzBaNmhCUEtUN3c9PSIsInZhbHVlIjoiY0V1S3RqNzRjZmpFQzR5OHRyUHhCUUIxRmp6ZVg4TWVPWmhjMndQYnduRlBISnJEN0NrY2hQZkplcTgvT29SWjBI ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InJkRnI3TkY1bHUxajdXWEYyU0drYWc9PSIsInZhbHVlIjoiODZOK0FXWDM5bDIvWlhvbzhpeWNsbEJyZ0Z5UE1kSGprUlJUNVhTZDVUMWxzd3lkYkhCMHlLN1RCb1hoRjVhajM5YmtGd1pSZmdvUGZUYVZTYjE2NGp6L1FPbmNwa0Y0cHplK3NyT1NvU25xb0QxWWpHMnVQQzd2YS95YnVENU4iLCJtYWMiOiI4MmEyZDRiODI2YzY1OTEwYjgwMGE2NDdlYTEzMWM1NzY3NzQzOGEzZjIxY2RmMTA1NTc1ZjNmNjI4OGRjYWIxIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 22:22:08 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InJkRnI3TkY1bHUxajdXWEYyU0drYWc9PSIsInZhbHVlIjoiODZOK0FXWDM5bDIvWlhvbzhpeWNsbEJyZ0Z5UE1kSGprUlJUNVhTZDVUMWxzd3lkYkhCMHlLN1RCb1hoRjVhajM5YmtGd ▶" 1 => "rouvana_session=eyJpdiI6InZtc3lNVXRLN3MwKzBaNmhCUEtUN3c9PSIsInZhbHVlIjoiY0V1S3RqNzRjZmpFQzR5OHRyUHhCUUIxRmp6ZVg4TWVPWmhjMndQYnduRlBISnJEN0NrY2hQZkplcTgvT29SWjBIYXNDa3ppL1BYTVFaa1U5NWVNeUloTTRPc29YSUl2QTNVVWEwWVV4OTRGTUVOTUVGWk1IU2VuVlBDc3g4UUQiLCJtYWMiOiI4ZjE0NGQwMGNjMTE4Y2IxNjA1Y2IxOWQ5NDQzYTg5NThiMGNjN2ZlNmQyN2VjYzc1MzI5ZGJlYjAwZDZhNzgwIiwidGFnIjoiIn0%3D; expires=Wed, 09-Apr-2025 22:22:08 GMT; path=/; httponly ◀rouvana_session=eyJpdiI6InZtc3lNVXRLN3MwKzBaNmhCUEtUN3c9PSIsInZhbHVlIjoiY0V1S3RqNzRjZmpFQzR5OHRyUHhCUUIxRmp6ZVg4TWVPWmhjMndQYnduRlBISnJEN0NrY2hQZkplcTgvT29SWjBI ▶" ] ]
0 of 0array:4 [▼ "_token" => "5Qtagll6qvKII7wVpiVoGLM1L1YU0Kn872knHIsU" "_previous" => array:1 [▶ "url" => "https://rouvana.com/egy/event/seaworld-abu-dhabi" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]