or, enquire about your chosen options

  1. Holland America’s View and Veranda promotion is back!!
  2. The Big Laugh Comedy Festival Cruise
  3. Catch up on Cruising: Latest news in bite size
  4. Meet the Cruise Factor Team – Don
  5. Catch up on Cruising: Latest news in bite size

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

 
 

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: 238

Total elapsed time: 0.14984393119812

# Query Time
(1) connect 0.00041913986206055
(2) DESCRIBE `cruises` 0.0016629695892334
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (62014, 62028, 62030)) ORDER BY FIND_IN_SET(id, '62014,62028,62030') 0.00096583366394043
(4) DESCRIBE `cruises` 0.0011839866638184
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62014') 0.00018000602722168
(6) DESCRIBE `ships` 0.0011599063873291
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1456))) 0.00022792816162109
(8) DESCRIBE `ships` 0.0013759136199951
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1456') 0.00018692016601562
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015878677368164
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017595291137695
(12) DESCRIBE `itineraries` 0.00063300132751465
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62014') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00060701370239258
(14) DESCRIBE `ports` 0.00088095664978027
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00027608871459961
(16) DESCRIBE `ports` 0.00085186958312988
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00023794174194336
(18) DESCRIBE `ports` 0.00091099739074707
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00022697448730469
(20) DESCRIBE `sailingdates` 0.00070285797119141
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62014') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00093984603881836
(22) DESCRIBE `ports` 0.00081110000610352
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.0002448558807373
(24) DESCRIBE `ports` 0.00076198577880859
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00020003318786621
(26) DESCRIBE `ports` 0.00082683563232422
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00023508071899414
(28) DESCRIBE `ports` 0.00082015991210938
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00015997886657715
(30) DESCRIBE `ports` 0.00057601928710938
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00024294853210449
(32) DESCRIBE `ports` 0.00058102607727051
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00018000602722168
(34) DESCRIBE `ports` 0.00057792663574219
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00017189979553223
(36) DESCRIBE `ports` 0.00057506561279297
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00015687942504883
(38) DESCRIBE `ports` 0.00057601928710938
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00016999244689941
(40) DESCRIBE `ports` 0.00059795379638672
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.0001530647277832
(42) DESCRIBE `ports` 0.00057482719421387
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00016999244689941
(44) DESCRIBE `ports` 0.00057291984558105
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00015497207641602
(46) DESCRIBE `ports` 0.00059199333190918
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00018095970153809
(48) DESCRIBE `ports` 0.00059390068054199
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00015592575073242
(50) DESCRIBE `ports` 0.00057387351989746
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.0001671314239502
(52) DESCRIBE `ports` 0.00070095062255859
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00017499923706055
(54) DESCRIBE `ports` 0.00066804885864258
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00018310546875
(56) DESCRIBE `ports` 0.00061488151550293
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00016999244689941
(58) DESCRIBE `ports` 0.00060701370239258
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00021600723266602
(60) DESCRIBE `ports` 0.00084710121154785
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00019288063049316
(62) DESCRIBE `ports` 0.00082015991210938
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00021696090698242
(64) DESCRIBE `ports` 0.00082111358642578
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00019288063049316
(66) DESCRIBE `ports` 0.00080585479736328
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.0002439022064209
(68) DESCRIBE `ports` 0.00085091590881348
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00019001960754395
(70) DESCRIBE `avid_specials` 0.0007469654083252
(71) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62014 and class = 'Cruise') OR (item_id = 1456 AND class = 'Ship') OR (item_id = 263 AND class = 'CruiseLine') OR (item_id = 54 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.0014848709106445
(72) DESCRIBE `cruiselines` 0.0012400150299072
(73) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 263))) 0.00028800964355469
(74) DESCRIBE `orchid_image` 0.00096487998962402
(75) DESCRIBE `cruiselines` 0.0010302066802979
(76) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '263') 0.00018000602722168
(77) DESCRIBE `cruises` 0.0012331008911133
(78) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62028') 0.0001988410949707
(79) DESCRIBE `ships` 0.001187801361084
(80) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1457))) 0.00022196769714355
(81) DESCRIBE `ships` 0.0012760162353516
(82) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1457') 0.0001671314239502
(83) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0001521110534668
(84) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014305114746094
(85) DESCRIBE `itineraries` 0.00063705444335938
(86) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62028') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00088596343994141
(87) DESCRIBE `ports` 0.001244068145752
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00032305717468262
(89) DESCRIBE `ports` 0.00081396102905273
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00025391578674316
(91) DESCRIBE `ports` 0.00079798698425293
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00024008750915527
(93) DESCRIBE `sailingdates` 0.00069403648376465
(94) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62028') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00046896934509277
(95) DESCRIBE `ports` 0.00094795227050781
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00025486946105957
(97) DESCRIBE `ports` 0.00082802772521973
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00025296211242676
(99) DESCRIBE `ports` 0.00086712837219238
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00025701522827148
(101) DESCRIBE `ports` 0.00084018707275391
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.0002439022064209
(103) DESCRIBE `ports` 0.00087904930114746
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00028300285339355
(105) DESCRIBE `ports` 0.00081515312194824
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00023293495178223
(107) DESCRIBE `ports` 0.00089097023010254
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.00023508071899414
(109) DESCRIBE `ports` 0.000885009765625
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0.00021004676818848
(111) DESCRIBE `ports` 0.00090503692626953
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00032615661621094
(113) DESCRIBE `ports` 0.00084209442138672
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00025582313537598
(115) DESCRIBE `ports` 0.00091314315795898
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00027298927307129
(117) DESCRIBE `ports` 0.00086307525634766
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00025320053100586
(119) DESCRIBE `ports` 0.00081300735473633
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4533))) 0.00023508071899414
(121) DESCRIBE `ports` 0.00085115432739258
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4533') 0.00023913383483887
(123) DESCRIBE `ports` 0.00088214874267578
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3516))) 0.00023603439331055
(125) DESCRIBE `ports` 0.0008690357208252
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3516') 0.00023388862609863
(127) DESCRIBE `ports` 0.00087499618530273
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3157))) 0.00026106834411621
(129) DESCRIBE `ports` 0.00079703330993652
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3157') 0.00023698806762695
(131) DESCRIBE `ports` 0.00089311599731445
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3157))) 0.0002739429473877
(133) DESCRIBE `ports` 0.00090408325195312
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3157') 0.00029110908508301
(135) DESCRIBE `ports` 0.00090599060058594
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.00026297569274902
(137) DESCRIBE `ports` 0.00087404251098633
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '479') 0.00027108192443848
(139) DESCRIBE `ports` 0.00091814994812012
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.00026392936706543
(141) DESCRIBE `ports` 0.00088000297546387
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '479') 0.00017809867858887
(143) DESCRIBE `ports` 0.0006110668182373
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.00018715858459473
(145) DESCRIBE `ports` 0.00059199333190918
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '479') 0.00017309188842773
(147) DESCRIBE `avid_specials` 0.00055909156799316
(148) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62028 and class = 'Cruise') OR (item_id = 1457 AND class = 'Ship') OR (item_id = 263 AND class = 'CruiseLine') OR (item_id = 54 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.00085592269897461
(149) DESCRIBE `cruiselines` 0.00088381767272949
(150) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 263))) 0.00021791458129883
(151) DESCRIBE `orchid_image` 0.00067901611328125
(152) DESCRIBE `cruiselines` 0.00080299377441406
(153) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '263') 0.00018811225891113
(154) DESCRIBE `cruises` 0.0012271404266357
(155) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62030') 0.00030303001403809
(156) DESCRIBE `ships` 0.00118088722229
(157) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1457))) 0.00023913383483887
(158) DESCRIBE `ships` 0.0011570453643799
(159) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1457') 0.00017404556274414
(160) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016093254089355
(161) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016689300537109
(162) DESCRIBE `itineraries` 0.00060081481933594
(163) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62030') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00034618377685547
(164) DESCRIBE `ports` 0.00060796737670898
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.00019502639770508
(166) DESCRIBE `ports` 0.0005950927734375
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.00017499923706055
(168) DESCRIBE `ports` 0.00058197975158691
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '479') 0.0001680850982666
(170) DESCRIBE `sailingdates` 0.00052595138549805
(171) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62030') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00034594535827637
(172) DESCRIBE `ports` 0.00061988830566406
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.00019693374633789
(174) DESCRIBE `ports` 0.00058698654174805
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '479') 0.00016498565673828
(176) DESCRIBE `ports` 0.00059318542480469
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.00018000602722168
(178) DESCRIBE `ports` 0.0005791187286377
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '479') 0.00016093254089355
(180) DESCRIBE `ports` 0.00058412551879883
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.0001828670501709
(182) DESCRIBE `ports` 0.00059700012207031
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '479') 0.00016188621520996
(184) DESCRIBE `ports` 0.00058197975158691
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3516))) 0.00017809867858887
(186) DESCRIBE `ports` 0.00058794021606445
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3516') 0.00016283988952637
(188) DESCRIBE `ports` 0.00059890747070312
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3160))) 0.00021481513977051
(190) DESCRIBE `ports` 0.00058507919311523
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3160') 0.00017499923706055
(192) DESCRIBE `ports` 0.00061488151550293
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4533))) 0.00018000602722168
(194) DESCRIBE `ports` 0.00065088272094727
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4533') 0.00016379356384277
(196) DESCRIBE `ports` 0.00058102607727051
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00022196769714355
(198) DESCRIBE `ports` 0.00061798095703125
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00019288063049316
(200) DESCRIBE `ports` 0.00060391426086426
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00020599365234375
(202) DESCRIBE `ports` 0.00058603286743164
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00019192695617676
(204) DESCRIBE `ports` 0.00061798095703125
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.00018215179443359
(206) DESCRIBE `ports` 0.00059819221496582
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0.00016212463378906
(208) DESCRIBE `ports` 0.00058603286743164
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00020503997802734
(210) DESCRIBE `ports` 0.00060200691223145
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.0001828670501709
(212) DESCRIBE `ports` 0.00060296058654785
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.0001988410949707
(214) DESCRIBE `ports` 0.00058293342590332
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00017881393432617
(216) DESCRIBE `ports` 0.00060510635375977
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00019502639770508
(218) DESCRIBE `ports` 0.00062108039855957
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.0001828670501709
(220) DESCRIBE `avid_specials` 0.00053000450134277
(221) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62030 and class = 'Cruise') OR (item_id = 1457 AND class = 'Ship') OR (item_id = 263 AND class = 'CruiseLine') OR (item_id = 54 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.00095891952514648
(222) DESCRIBE `cruiselines` 0.00092911720275879
(223) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 263))) 0.00020503997802734
(224) DESCRIBE `orchid_image` 0.0006871223449707
(225) DESCRIBE `cruiselines` 0.00084495544433594
(226) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '263') 0.00017905235290527
(227) DESCRIBE `ships` 0.001460075378418
(228) SELECT `ships`.* FROM `ships` WHERE (id IN ('1457', '1456')) ORDER BY FIND_IN_SET(id, '1457,1456') 0.00039911270141602
(229) DESCRIBE `cruisetypes` 0.00062394142150879
(230) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruises_and_specials.destination_id = '54') AND (cruises_and_specials.cruiseline_id = '263') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.025673151016235
(231) DESCRIBE `cruiselines` 0.0012710094451904
(232) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 263))) 0.00026798248291016
(233) DESCRIBE `destinations` 0.00093412399291992
(234) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 54))) 0.00023102760314941
(235) DESCRIBE `destinations` 0.0010590553283691
(236) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 54))) 0.00034904479980469
(237) DESCRIBE `cruiselines` 0.001025915145874
(238) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 263))) 0.00019407272338867