or, enquire about your chosen options

  1. REVIEW: P & O Australia’s Pacific Aria
  2. Catch Up on Cruising: Latest News in bite size!
  3. Asian Adventures with Zuleika from the Cruise Factor Team
  4. A short cruise is a good cruise!!
  5. SPOTLIGHT ON: Symphony of the Seas

Sign up to our newsletter and become the first to know about our latest deals and promotions

Itinerary for Cruise Sapphire, Malaysia, Thailand & Vietnam Grand Adventure ex Singapore Roundtrip

Cruise Itinerary

Day Port Arrive Depart
Day 1 Singapore, Singapore 04:00 PM
Day 2 Penang, Malaysia 03:00 PM 09:00 PM
Day 3 Kuala Lumpur, Malaysia 09:00 AM 06:00 PM
Day 4 Singapore, Singapore 07:00 AM 04:00 PM
Day 5 At Sea
Day 6 Kota Kinabalu, Malaysia 12:00 PM 08:00 PM
Day 7 At Sea
Day 8 Nha Trang, Vietnam 07:00 AM 04:00 PM
Day 9 Ho Chi Minh City (Phu My) Vietnam 07:00 AM 06:00 PM
Day 10 At Sea
Day 11 Bangkok (Laem Chabang) Thailand 07:00 AM 07:00 PM
Day 12 Ko Samui, Thailand 08:00 AM 05:00 PM
Day 13 At Sea
Day 14 Singapore, Singapore 07:00 AM

Please note, while cruise details and inclusions are accurate at time of loading they are subject to change due to changes in cruise line practices and policies. Please check details and inclusions at time of booking.

Database Profiling Report

Total queries executed: 156

Total elapsed time: 0.090725898742676

# Query Time
(1) connect 0.00050997734069824
(2) DESCRIBE `specials` 0.0034210681915283
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'spotlight-on-asia-malaysia-thailand-vietnam-grand-adventure') AND (orchid_available = 1) LIMIT 1 0.00082492828369141
(4) DESCRIBE `cruises` 0.0012710094451904
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 70013))) 0.00036501884460449
(6) DESCRIBE `avid_specials` 0.00061607360839844
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1431423 and class = 'Special') OR (item_id = 70013 and class = 'Cruise') OR (item_id = 406 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00091910362243652
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1431423') 0.00019502639770508
(9) DESCRIBE `ships` 0.0013000965118408
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 406))) 0.00023818016052246
(11) DESCRIBE `ships` 0.0013370513916016
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '406') 0.00019383430480957
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017499923706055
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019311904907227
(15) DESCRIBE `itineraries` 0.00070905685424805
(16) DESCRIBE `ports` 0.00088000297546387
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00027608871459961
(18) DESCRIBE `ports` 0.00069403648376465
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00019383430480957
(20) DESCRIBE `ports` 0.0006709098815918
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00018692016601562
(22) DESCRIBE `specialsailingdates` 0.00057291984558105
(23) DESCRIBE `sailingdates` 0.00062894821166992
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 439426))) 0.00022411346435547
(25) DESCRIBE `ports` 0.00067782402038574
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00019693374633789
(27) DESCRIBE `ports` 0.00066590309143066
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00019288063049316
(29) DESCRIBE `ports` 0.00066614151000977
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00019598007202148
(31) DESCRIBE `ports` 0.00065302848815918
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00016999244689941
(33) DESCRIBE `ports` 0.0006568431854248
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 173))) 0.00020503997802734
(35) DESCRIBE `ports` 0.00065398216247559
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '173') 0.00017499923706055
(37) DESCRIBE `ports` 0.00065183639526367
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00019407272338867
(39) DESCRIBE `ports` 0.0006561279296875
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00018692016601562
(41) DESCRIBE `ports` 0.00065302848815918
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 444))) 0.00019383430480957
(43) DESCRIBE `ports` 0.00065279006958008
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '444') 0.00017404556274414
(45) DESCRIBE `ports` 0.00066280364990234
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 550))) 0.00022411346435547
(47) DESCRIBE `ports` 0.00075602531433105
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '550') 0.00019216537475586
(49) DESCRIBE `ports` 0.00065994262695312
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00020098686218262
(51) DESCRIBE `ports` 0.00066900253295898
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00018787384033203
(53) DESCRIBE `ports` 0.0006561279296875
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.0001981258392334
(55) DESCRIBE `ports` 0.00065517425537109
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00017380714416504
(57) DESCRIBE `ports` 0.00067806243896484
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 504))) 0.00020408630371094
(59) DESCRIBE `ports` 0.00065302848815918
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '504') 0.00017404556274414
(61) DESCRIBE `ports` 0.00065517425537109
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00021505355834961
(63) DESCRIBE `ports` 0.0006721019744873
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00017213821411133
(65) DESCRIBE `specialsmultipricing` 0.00064206123352051
(66) DESCRIBE `leadpricing` 0.00060701370239258
(67) DESCRIBE `specials` 0.001896858215332
(68) DESCRIBE `currencies` 0.00059604644775391
(69) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00018405914306641
(70) DESCRIBE `cruiselines` 0.00091910362243652
(71) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00021600723266602
(72) DESCRIBE `orchid_image` 0.00077700614929199
(73) DESCRIBE `cruiselines` 0.00095677375793457
(74) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00018596649169922
(75) DESCRIBE `cruises` 0.0012249946594238
(76) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70013') 0.00022196769714355
(77) DESCRIBE `deckplans` 0.00072503089904785
(78) DESCRIBE `cabins` 0.0009009838104248
(79) DESCRIBE `shipphotos` 0.0010058879852295
(80) DESCRIBE `specialitineraries` 0.0010080337524414
(81) SELECT `specialitineraries`.* FROM `specialitineraries` WHERE (type = 'pre' AND special_id = '1431423') ORDER BY `order` ASC 0.00043296813964844
(82) DESCRIBE `ports` 0.0010161399841309
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00032210350036621
(84) DESCRIBE `ports` 0.00099802017211914
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00025200843811035
(86) DESCRIBE `ports` 0.00096702575683594
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00022220611572266
(88) DESCRIBE `ports` 0.00079917907714844
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00023698806762695
(90) DESCRIBE `ports` 0.00081992149353027
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00023198127746582
(92) DESCRIBE `ports` 0.00069284439086914
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00024080276489258
(94) DESCRIBE `ports` 0.00081419944763184
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 173))) 0.00021195411682129
(96) DESCRIBE `ports` 0.00068998336791992
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '173') 0.00018191337585449
(98) DESCRIBE `ports` 0.00074315071105957
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 173))) 0.00020480155944824
(100) DESCRIBE `ports` 0.00069689750671387
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020503997802734
(102) DESCRIBE `ports` 0.00066518783569336
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00018191337585449
(104) DESCRIBE `ports` 0.00081110000610352
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0002281665802002
(106) DESCRIBE `ports` 0.00077080726623535
(107) DESCRIBE `ports` 0.00094199180603027
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 444))) 0.0004580020904541
(109) DESCRIBE `ports` 0.001194953918457
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '444') 0.00022983551025391
(111) DESCRIBE `ports` 0.00077104568481445
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 444))) 0.00020384788513184
(113) DESCRIBE `ports` 0.00068187713623047
(114) DESCRIBE `ports` 0.00066494941711426
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 550))) 0.00022721290588379
(116) DESCRIBE `ports` 0.00082802772521973
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '550') 0.00019192695617676
(118) DESCRIBE `ports` 0.00069499015808105
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 550))) 0.00020003318786621
(120) DESCRIBE `ports` 0.00068807601928711
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00020503997802734
(122) DESCRIBE `ports` 0.00067496299743652
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00018000602722168
(124) DESCRIBE `ports` 0.00067687034606934
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00020003318786621
(126) DESCRIBE `ports` 0.00071096420288086
(127) DESCRIBE `ports` 0.00067400932312012
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00020503997802734
(129) DESCRIBE `ports` 0.00066399574279785
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00018787384033203
(131) DESCRIBE `ports` 0.00069093704223633
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00020098686218262
(133) DESCRIBE `ports` 0.00091409683227539
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 504))) 0.00020289421081543
(135) DESCRIBE `ports` 0.0006721019744873
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '504') 0.00021100044250488
(137) DESCRIBE `ports` 0.00066304206848145
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 504))) 0.00019717216491699
(139) DESCRIBE `ports` 0.00066399574279785
(140) DESCRIBE `ports` 0.00064706802368164
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00021481513977051
(142) DESCRIBE `ports` 0.00070810317993164
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00018787384033203
(144) DESCRIBE `ports` 0.00065898895263672
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00024795532226562
(146) DESCRIBE `specialitineraries` 0.00066280364990234
(147) SELECT `specialitineraries`.* FROM `specialitineraries` WHERE (type = 'post' AND special_id = '1431423') ORDER BY `order` ASC 0.00031113624572754
(148) DESCRIBE `cruises` 0.0016789436340332
(149) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66959, 11517, 45259, 69465, 66859, 66414, 67892, 69524, 66478, 66529)) ORDER BY FIND_IN_SET(id, '66959,11517,45259,69465,66859,66414,67892,69524,66478,66529') 0.00091004371643066
(150) DESCRIBE `cruiselines` 0.0011332035064697
(151) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('47', '33', '101', '19', '18', '8', '15', '218', '23', '151', '114', '20', '24', '120', '212', '30', '180', '262')) ORDER BY FIND_IN_SET(id, '47,33,101,19,18,8,15,218,23,151,114,20,24,120,212,30,180,262') 0.00075507164001465
(152) DESCRIBE `ships` 0.0013959407806396
(153) SELECT `ships`.* FROM `ships` WHERE (id IN ('517', '160', '1359', '1139', '888', '1266', '78', '1282', '683', '780', '1237', '406', '521', '616', '1029', '1303', '1672', '1676', '45', '258', '313', '404', '585', '669', '973', '1163', '5', '74', '98', '150', '163', '335', '349', '441', '580', '582', '652', '678', '722', '766', '769', '795', '968', '977', '1013', '1088', '1159', '1262', '1302', '1492', '1539', '1587', '1673', '1674')) ORDER BY FIND_IN_SET(id, '517,160,1359,1139,888,1266,78,1282,683,780,1237,406,521,616,1029,1303,1672,1676,45,258,313,404,585,669,973,1163,5,74,98,150,163,335,349,441,580,582,652,678,722,766,769,795,968,977,1013,1088,1159,1262,1302,1492,1539,1587,1673,1674') 0.0021789073944092
(154) DESCRIBE `cruisetypes` 0.00098085403442383
(155) DESCRIBE `destinations` 0.00096797943115234
(156) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '43', '50', '35', '54', '48', '11', '29', '12', '26', '28', '39', '49', '2', '21', '25', '37', '40', '8', '38', '53')) ORDER BY FIND_IN_SET(id, '22,43,50,35,54,48,11,29,12,26,28,39,49,2,21,25,37,40,8,38,53') 0.00088095664978027