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

Ginger

The gracious Ginger will be Heritage Line’s new vessel cruising the Lan Ha Bay, which is a tranquil part of the famous Halong Bay in Vietnam. Ginger hosts only 12 large suites, all naturally light-flooded and with well-sized balcony. There will be two Regent Suites in the highest room category. Additional four Signature Suites and six Junior Suites complete the suite only vessel. Ginger expresses her elegance with warm timber floors, marble bathrooms and distinguished design themes that interlace the long-lasting traditions of Northern Vietnam paired with contemporary accents.

Enquire about this cruise ship »

#	Query	Time
(1)	connect	0.001007080078125
(2)	DESCRIBE `ships`	0.0050508975982666
(3)	SELECT `ships`.* FROM `ships` WHERE (orchid_slug = 'ginger') LIMIT 1	0.017632007598877
(4)	DESCRIBE `avid_specials`	0.0024929046630859
(5)	SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1761 AND class = 'Ship') OR (item_id = 183 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.0019071102142334
(6)	DESCRIBE `cruiselines`	0.003108024597168
(7)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183)))	0.0006110668182373
(8)	DESCRIBE `orchid_image`	0.0022158622741699
(9)	DESCRIBE `cruiselines`	0.0033299922943115
(10)	SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183')	0.00047183036804199
(11)	SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1761')	0.00043082237243652
(12)	DESCRIBE `deckplans`	0.0025351047515869
(13)	DESCRIBE `cabins`	0.0028951168060303
(14)	DESCRIBE `shipphotos`	0.0029900074005127
(15)	DESCRIBE `cruisetypes`	0.0025098323822021
(16)	SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '183') AND (cruises_and_specials.ship_id = '1761') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC	0.034770011901855
(17)	DESCRIBE `destinations`	0.0035970211029053
(18)	SELECT DISTINCT `destinations`.* FROM `destinations` LEFT JOIN `cruises_and_specials` ON destinations.id = cruises_and_specials.destination_id LEFT JOIN `ports` ON ports.destination_id = destinations.id WHERE (destinations.id = cruises_and_specials.destination_id) AND (cruises_and_specials.cruiseline_id = '183') AND (cruises_and_specials.ship_id = '1761') AND (ports.id = '548') AND (cruises_and_specials.orchid_available = 1) AND (destinations.orchid_available = 1) ORDER BY `destinations`.`name` ASC, `name` ASC	0.040127038955688
(19)	DESCRIBE `cruiselines`	0.0041699409484863
(20)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183)))	0.00087094306945801
(21)	DESCRIBE `ships`	0.0055360794067383
(22)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1761)))	0.00063586235046387
(23)	DESCRIBE `cruiselines`	0.003788948059082
(24)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183)))	0.00051188468933105
(25)	DESCRIBE `ships`	0.004655122756958
(26)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1761)))	0.00056600570678711
(27)	DESCRIBE `ports`	0.0019900798797607
(28)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548)))	0.00062108039855957

Query

Time

(1)

connect

0.001007080078125

(2)

DESCRIBE `ships`

0.0050508975982666

(3)

SELECT `ships`.* FROM `ships` WHERE (orchid_slug = 'ginger') LIMIT 1

0.017632007598877

(4)

DESCRIBE `avid_specials`

0.0024929046630859

(5)

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

(6)

DESCRIBE `cruiselines`

0.003108024597168

(7)

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

0.0006110668182373

(8)

DESCRIBE `orchid_image`

0.0022158622741699

(9)

DESCRIBE `cruiselines`

0.0033299922943115

(10)

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

0.00047183036804199

(11)

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

0.00043082237243652

(12)

DESCRIBE `deckplans`

0.0025351047515869

(13)

DESCRIBE `cabins`

0.0028951168060303

(14)

DESCRIBE `shipphotos`

0.0029900074005127

(15)

DESCRIBE `cruisetypes`

0.0025098323822021

(16)

SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '183') AND (cruises_and_specials.ship_id = '1761') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC

0.034770011901855

(17)

DESCRIBE `destinations`

0.0035970211029053

(18)

SELECT DISTINCT `destinations`.* FROM `destinations` LEFT JOIN `cruises_and_specials` ON destinations.id = cruises_and_specials.destination_id LEFT JOIN `ports` ON ports.destination_id = destinations.id WHERE (destinations.id = cruises_and_specials.destination_id) AND (cruises_and_specials.cruiseline_id = '183') AND (cruises_and_specials.ship_id = '1761') AND (ports.id = '548') AND (cruises_and_specials.orchid_available = 1) AND (destinations.orchid_available = 1) ORDER BY `destinations`.`name` ASC, `name` ASC

0.040127038955688

(19)

DESCRIBE `cruiselines`

0.0041699409484863

(20)

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

0.00087094306945801

(21)

DESCRIBE `ships`

0.0055360794067383

(22)

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

0.00063586235046387

(23)

DESCRIBE `cruiselines`

0.003788948059082

(24)

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

0.00051188468933105

(25)

DESCRIBE `ships`

0.004655122756958

(26)

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

0.00056600570678711

(27)

DESCRIBE `ports`

0.0019900798797607

(28)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548)))

0.00062108039855957

My Favourite Cruises

Ginger

Database Profiling Report

Find Your Cruise

My Favourite Cruises

Ginger

Database Profiling Report