Cruise Factor - Find Your Perfect Cruise

Upcoming Sailings

Sailing Date	Nights	Cruise
23 December 2019	17	Saigon, Heart of Cambodia & Vietnam 2019 ex Siem Reap to Hanoi
23 December 2019	17	Siem Reap, Heart of Cambodia ex Ho Chi Minh to Hanoi
23 December 2019	2	Jasmine, Jewels of Halong Bay ex Halong Bay Return
23 December 2019	2	Violet, Jewels of Halong Bay ex Halong Bay Return
23 December 2019	1	Jasmine, The Dragon Passage ex Halong Bay Return
23 December 2019	1	Violet, The Dragon Passage ex Halong Bay Return
27 December 2019	20	Saigon, Southeast Asia & Majestic Mekong 2019 (North) ex Bangkok to Hanoi
27 December 2019	20	Siem Reap, Southeast Asia & Majestic Mekong 2019 (South) ex Bangkok to Hanoi
12 January 2020	5	World Dream, Impressions of Vietnam I ex Hong Kong Return
30 December 2020	17	Siem Reap, Heart of Cambodia & Vietnam 2019 ex Siem Reap to Hanoi

Page Navigation: 1 2 3 4 5 6 7 8 9 Next »

Items 1 - 10 of 84

#	Query	Time
(1)	connect	0.0012829303741455
(2)	DESCRIBE `ports`	0.0024662017822266
(3)	SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'halong-bay-vietnam') AND (orchid_available = 1) LIMIT 1	0.0069921016693115
(4)	DESCRIBE `cruises`	0.0050449371337891
(5)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (75752, 75753, 65919, 65921, 65920, 71154, 75756, 75757, 74655, 75751)) ORDER BY FIND_IN_SET(id, '75752,75753,65919,65921,65920,71154,75756,75757,74655,75751')	0.0024828910827637
(6)	DESCRIBE `cruises`	0.0039169788360596
(7)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75752')	0.00053095817565918
(8)	DESCRIBE `cruises`	0.0036189556121826
(9)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75753')	0.00039410591125488
(10)	DESCRIBE `cruises`	0.0035231113433838
(11)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65919')	0.00044894218444824
(12)	DESCRIBE `cruises`	0.0037810802459717
(13)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65921')	0.00044488906860352
(14)	DESCRIBE `cruises`	0.0036349296569824
(15)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65920')	0.00052690505981445
(16)	DESCRIBE `cruises`	0.0034270286560059
(17)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71154')	0.00039196014404297
(18)	DESCRIBE `cruises`	0.0034081935882568
(19)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75756')	0.00040483474731445
(20)	DESCRIBE `cruises`	0.0032021999359131
(21)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75757')	0.00039887428283691
(22)	DESCRIBE `cruises`	0.0032589435577393
(23)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74655')	0.00045895576477051
(24)	DESCRIBE `cruises`	0.0033280849456787
(25)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75751')	0.00037097930908203
(26)	DESCRIBE `cruisetypes`	0.002701997756958
(27)	DESCRIBE `destinations`	0.0039010047912598
(28)	DESCRIBE `cruiselines`	0.0034980773925781
(29)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 206)))	0.00048589706420898
(30)	DESCRIBE `ships`	0.0038771629333496
(31)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1554)))	0.00051307678222656
(32)	DESCRIBE `cruiselines`	0.003007173538208
(33)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 206)))	0.00051403045654297
(34)	DESCRIBE `ships`	0.0053219795227051
(35)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1554)))	0.00078296661376953
(36)	DESCRIBE `ports`	0.0028591156005859
(37)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548)))	0.00056695938110352

Query

Time

(1)

connect

0.0012829303741455

(2)

DESCRIBE `ports`

0.0024662017822266

(3)

SELECT `ports`.* FROM `ports` WHERE (orchid_slug = 'halong-bay-vietnam') AND (orchid_available = 1) LIMIT 1

0.0069921016693115

(4)

DESCRIBE `cruises`

0.0050449371337891

(5)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (75752, 75753, 65919, 65921, 65920, 71154, 75756, 75757, 74655, 75751)) ORDER BY FIND_IN_SET(id, '75752,75753,65919,65921,65920,71154,75756,75757,74655,75751')

0.0024828910827637

(6)

DESCRIBE `cruises`

0.0039169788360596

(7)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75752')

0.00053095817565918

(8)

DESCRIBE `cruises`

0.0036189556121826

(9)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75753')

0.00039410591125488

(10)

DESCRIBE `cruises`

0.0035231113433838

(11)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65919')

0.00044894218444824

(12)

DESCRIBE `cruises`

0.0037810802459717

(13)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65921')

0.00044488906860352

(14)

DESCRIBE `cruises`

0.0036349296569824

(15)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65920')

0.00052690505981445

(16)

DESCRIBE `cruises`

0.0034270286560059

(17)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71154')

0.00039196014404297

(18)

DESCRIBE `cruises`

0.0034081935882568

(19)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75756')

0.00040483474731445

(20)

DESCRIBE `cruises`

0.0032021999359131

(21)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75757')

0.00039887428283691

(22)

DESCRIBE `cruises`

0.0032589435577393

(23)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74655')

0.00045895576477051

(24)

DESCRIBE `cruises`

0.0033280849456787

(25)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75751')

0.00037097930908203

(26)

DESCRIBE `cruisetypes`

0.002701997756958

(27)

DESCRIBE `destinations`

0.0039010047912598

(28)

DESCRIBE `cruiselines`

0.0034980773925781

(29)

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

0.00048589706420898

(30)

DESCRIBE `ships`

0.0038771629333496

(31)

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

0.00051307678222656

(32)

DESCRIBE `cruiselines`

0.003007173538208

(33)

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

0.00051403045654297

(34)

DESCRIBE `ships`

0.0053219795227051

(35)

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

0.00078296661376953

(36)

DESCRIBE `ports`

0.0028591156005859

(37)

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

0.00056695938110352

Find Your Cruise

Upcoming Sailings

Database Profiling Report