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

Allure of the Seas

Allure of the Seas has just been named Best Cruise Ship by Travel Weekly readers for the second year in a row. But this isn't just a cruise ship. It's an adventure that sails way ahead of the curve. Explore seven singular neighbourhoods, from the winding paths of Central Park to the ultimate rush of the Pool and Sports Zone. Surfing. Ziplining. Ice-skating. 3D movies. Come and seek all this and more on Allure of the Seas – your biggest holiday yet.

Enquire about this cruise ship »

#	Query	Time
(1)	connect	0.0012638568878174
(2)	DESCRIBE `ships`	0.0054178237915039
(3)	SELECT `ships`.* FROM `ships` WHERE (orchid_slug = 'allure-of-the-seas') LIMIT 1	0.0095710754394531
(4)	DESCRIBE `avid_specials`	0.0025570392608643
(5)	SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 791 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.0024058818817139
(6)	DESCRIBE `cruiselines`	0.00394606590271
(7)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26)))	0.00075507164001465
(8)	DESCRIBE `orchid_image`	0.0030078887939453
(9)	DESCRIBE `cruiselines`	0.0037369728088379
(10)	SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26')	0.00064301490783691
(11)	SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '791')	0.0007319450378418
(12)	DESCRIBE `deckplans`	0.0031359195709229
(13)	DESCRIBE `cabins`	0.0026459693908691
(14)	DESCRIBE `shipphotos`	0.0027320384979248
(15)	DESCRIBE `cruisetypes`	0.0024628639221191
(16)	DESCRIBE `destinations`	0.0028500556945801
(17)	DESCRIBE `cruiselines`	0.0040080547332764
(18)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 105)))	0.00069212913513184
(19)	DESCRIBE `ships`	0.0057671070098877
(20)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 791)))	0.0006868839263916
(21)	DESCRIBE `cruiselines`	0.0040102005004883
(22)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 105)))	0.00075387954711914
(23)	DESCRIBE `ships`	0.005253791809082
(24)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 791)))	0.00054478645324707

Query

Time

(1)

connect

0.0012638568878174

(2)

DESCRIBE `ships`

0.0054178237915039

(3)

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

0.0095710754394531

(4)

DESCRIBE `avid_specials`

0.0025570392608643

(5)

SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 791 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.0024058818817139

(6)

DESCRIBE `cruiselines`

0.00394606590271

(7)

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

0.00075507164001465

(8)

DESCRIBE `orchid_image`

0.0030078887939453

(9)

DESCRIBE `cruiselines`

0.0037369728088379

(10)

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

0.00064301490783691

(11)

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

0.0007319450378418

(12)

DESCRIBE `deckplans`

0.0031359195709229

(13)

DESCRIBE `cabins`

0.0026459693908691

(14)

DESCRIBE `shipphotos`

0.0027320384979248

(15)

DESCRIBE `cruisetypes`

0.0024628639221191

(16)

DESCRIBE `destinations`

0.0028500556945801

(17)

DESCRIBE `cruiselines`

0.0040080547332764

(18)

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

0.00069212913513184

(19)

DESCRIBE `ships`

0.0057671070098877

(20)

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

0.0006868839263916

(21)

DESCRIBE `cruiselines`

0.0040102005004883

(22)

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

0.00075387954711914

(23)

DESCRIBE `ships`

0.005253791809082

(24)

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

0.00054478645324707

Find Your Cruise

Allure of the Seas

Database Profiling Report