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

Admiralty Dream

The Admiralty Dream is perfect for adventure in the wilderness waterways. With its shallow draft and stately pace of cruising, nothing will be missed in channels, bays and wilderness islands that the Allen family calls home.

Enquire about this cruise ship »

#	Query	Time
(1)	connect	0.0015170574188232
(2)	DESCRIBE `ships`	0.0061111450195312
(3)	SELECT `ships`.* FROM `ships` WHERE (orchid_slug = 'admiralty-dream') LIMIT 1	0.01295280456543
(4)	DESCRIBE `avid_specials`	0.0028769969940186
(5)	SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1022 AND class = 'Ship') OR (item_id = 213 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.0024650096893311
(6)	DESCRIBE `cruiselines`	0.0043790340423584
(7)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 213)))	0.00076818466186523
(8)	DESCRIBE `orchid_image`	0.0029568672180176
(9)	DESCRIBE `cruiselines`	0.0038790702819824
(10)	SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '213')	0.00061702728271484
(11)	SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1022')	0.00048398971557617
(12)	DESCRIBE `deckplans`	0.0027480125427246
(13)	DESCRIBE `cabins`	0.002964973449707
(14)	DESCRIBE `shipphotos`	0.0027379989624023
(15)	DESCRIBE `cruisetypes`	0.002424955368042
(16)	DESCRIBE `destinations`	0.0035748481750488
(17)	DESCRIBE `cruiselines`	0.003849983215332
(18)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 73)))	0.00061702728271484
(19)	DESCRIBE `ships`	0.0051491260528564
(20)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1022)))	0.00067996978759766
(21)	DESCRIBE `cruiselines`	0.00370192527771
(22)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 73)))	0.00049591064453125
(23)	DESCRIBE `ships`	0.0044620037078857
(24)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1022)))	0.00056195259094238

Query

Time

(1)

connect

0.0015170574188232

(2)

DESCRIBE `ships`

0.0061111450195312

(3)

SELECT `ships`.* FROM `ships` WHERE (orchid_slug = 'admiralty-dream') LIMIT 1

0.01295280456543

(4)

DESCRIBE `avid_specials`

0.0028769969940186

(5)

SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1022 AND class = 'Ship') OR (item_id = 213 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.0024650096893311

(6)

DESCRIBE `cruiselines`

0.0043790340423584

(7)

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

0.00076818466186523

(8)

DESCRIBE `orchid_image`

0.0029568672180176

(9)

DESCRIBE `cruiselines`

0.0038790702819824

(10)

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

0.00061702728271484

(11)

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

0.00048398971557617

(12)

DESCRIBE `deckplans`

0.0027480125427246

(13)

DESCRIBE `cabins`

0.002964973449707

(14)

DESCRIBE `shipphotos`

0.0027379989624023

(15)

DESCRIBE `cruisetypes`

0.002424955368042

(16)

DESCRIBE `destinations`

0.0035748481750488

(17)

DESCRIBE `cruiselines`

0.003849983215332

(18)

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

0.00061702728271484

(19)

DESCRIBE `ships`

0.0051491260528564

(20)

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

0.00067996978759766

(21)

DESCRIBE `cruiselines`

0.00370192527771

(22)

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

0.00049591064453125

(23)

DESCRIBE `ships`

0.0044620037078857

(24)

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

0.00056195259094238

Find Your Cruise

Admiralty Dream

Database Profiling Report