Your 'Cruise Ship' has been chosenClear this filter or visit another page to change

Adventure of the Seas

This is a Royal Caribbean® favourite upgraded with all-new thrills. Challenge a friend on the twisting, turning waterslides, Cyclone and Typhoon. Catch a perfect wave high above the sea on the FlowRider®. Have fun by the gallon at the Splashaway Bay aquapark. Follow the Latin beat at Boleros. And savour the only dry, aged steaks at sea at Chops Grille. All while island hopping through the Caribbean’s most exotic shores. It’s time to embark on a new adventure – the reinvented Adventure of the Seas®.

Enquire about this cruise ship »

#	Query	Time
(1)	connect	0.001255989074707
(2)	DESCRIBE `ships`	0.005612850189209
(3)	SELECT `ships`.* FROM `ships` WHERE (orchid_slug = 'adventure-of-the-seas') LIMIT 1	0.0015139579772949
(4)	DESCRIBE `avid_specials`	0.0026659965515137
(5)	SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 286 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = ''))	0.0012831687927246
(6)	DESCRIBE `cruiselines`	0.0029089450836182
(7)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26)))	0.00054192543029785
(8)	DESCRIBE `orchid_image`	0.0023460388183594
(9)	DESCRIBE `cruiselines`	0.0030779838562012
(10)	SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26')	0.00049996376037598
(11)	SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '286')	0.00036311149597168
(12)	DESCRIBE `deckplans`	0.0020759105682373
(13)	DESCRIBE `cabins`	0.0020260810852051
(14)	DESCRIBE `shipphotos`	0.002039909362793
(15)	DESCRIBE `cruises`	0.0035800933837891
(16)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (77016, 77014, 71143, 77012, 77013, 77012, 77015, 81216, 81216, 81214)) ORDER BY FIND_IN_SET(id, '77016,77014,71143,77012,77013,77012,77015,81216,81216,81214')	0.001615047454834
(17)	DESCRIBE `cruisetypes`	0.0017569065093994
(18)	DESCRIBE `destinations`	0.0024209022521973
(19)	SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '9', '11')) ORDER BY FIND_IN_SET(id, '12,9,11')	0.00099492073059082
(20)	DESCRIBE `cruiselines`	0.0027968883514404
(21)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26)))	0.00060606002807617
(22)	DESCRIBE `ships`	0.0036470890045166
(23)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 286)))	0.00051403045654297
(24)	DESCRIBE `cruiselines`	0.0025961399078369
(25)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26)))	0.00047802925109863
(26)	DESCRIBE `ships`	0.0034828186035156
(27)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 286)))	0.00043487548828125

Query

Time

(1)

connect

0.001255989074707

(2)

DESCRIBE `ships`

0.005612850189209

(3)

SELECT `ships`.* FROM `ships` WHERE (orchid_slug = 'adventure-of-the-seas') LIMIT 1

0.0015139579772949

(4)

DESCRIBE `avid_specials`

0.0026659965515137

(5)

SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 286 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = ''))

0.0012831687927246

(6)

DESCRIBE `cruiselines`

0.0029089450836182

(7)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26)))

0.00054192543029785

(8)

DESCRIBE `orchid_image`

0.0023460388183594

(9)

DESCRIBE `cruiselines`

0.0030779838562012

(10)

SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26')

0.00049996376037598

(11)

SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '286')

0.00036311149597168

(12)

DESCRIBE `deckplans`

0.0020759105682373

(13)

DESCRIBE `cabins`

0.0020260810852051

(14)

DESCRIBE `shipphotos`

0.002039909362793

(15)

DESCRIBE `cruises`

0.0035800933837891

(16)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (77016, 77014, 71143, 77012, 77013, 77012, 77015, 81216, 81216, 81214)) ORDER BY FIND_IN_SET(id, '77016,77014,71143,77012,77013,77012,77015,81216,81216,81214')

0.001615047454834

(17)

DESCRIBE `cruisetypes`

0.0017569065093994

(18)

DESCRIBE `destinations`

0.0024209022521973

(19)

SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '9', '11')) ORDER BY FIND_IN_SET(id, '12,9,11')

0.00099492073059082

(20)

DESCRIBE `cruiselines`

0.0027968883514404

(21)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26)))

0.00060606002807617

(22)

DESCRIBE `ships`

0.0036470890045166

(23)

SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 286)))

0.00051403045654297

(24)

DESCRIBE `cruiselines`

0.0025961399078369

(25)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26)))

0.00047802925109863

(26)

DESCRIBE `ships`

0.0034828186035156

(27)

SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 286)))

0.00043487548828125

Find Your Cruise

Adventure of the Seas

Database Profiling Report