or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Solo Cruisers
  3. Catch Up on Cruising: Latest News in bite size!
  4. Should I buy a beverage package?
  5. SPOTLIGHT ON: Viking Ocean and River Cruises

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

Total elapsed time: 0.17458605766296

# Query Time
(1) connect 0.0010879039764404
(2) DESCRIBE `cruises` 0.0044229030609131
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (45258, 45260, 45259)) ORDER BY FIND_IN_SET(id, '45258,45260,45259') 0.0012741088867188
(4) DESCRIBE `cruises` 0.0028641223907471
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45258') 0.00037503242492676
(6) DESCRIBE `ships` 0.0026571750640869
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00037407875061035
(8) DESCRIBE `ships` 0.0029129981994629
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00029802322387695
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00030183792114258
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00024986267089844
(12) DESCRIBE `itineraries` 0.0012049674987793
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '45258') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00071597099304199
(14) DESCRIBE `ports` 0.0014691352844238
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00031900405883789
(16) DESCRIBE `ports` 0.0013909339904785
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00032186508178711
(18) DESCRIBE `ports` 0.0013079643249512
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00027585029602051
(20) DESCRIBE `sailingdates` 0.001133918762207
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '45258') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010528564453125
(22) DESCRIBE `ports` 0.0023288726806641
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00053691864013672
(24) DESCRIBE `ports` 0.0022051334381104
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00043296813964844
(26) DESCRIBE `ports` 0.0016381740570068
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00063204765319824
(28) DESCRIBE `ports` 0.0020039081573486
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00038003921508789
(30) DESCRIBE `ports` 0.0017421245574951
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00040602684020996
(32) DESCRIBE `ports` 0.0017638206481934
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00035905838012695
(34) DESCRIBE `ports` 0.0017790794372559
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 4.8160552978516E-5
(36) DESCRIBE `ports` 0.0014739036560059
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0
(38) DESCRIBE `ports` 0.0014569759368896
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00032401084899902
(40) DESCRIBE `ports` 0.0013761520385742
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00032877922058105
(42) DESCRIBE `ports` 0.0013999938964844
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00031304359436035
(44) DESCRIBE `ports` 0.0014309883117676
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00029420852661133
(46) DESCRIBE `ports` 0.0014090538024902
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00032615661621094
(48) DESCRIBE `ports` 0.0014219284057617
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00031113624572754
(50) DESCRIBE `ports` 0.001410961151123
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00034999847412109
(52) DESCRIBE `ports` 0.0014121532440186
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0
(54) DESCRIBE `avid_specials` 0.0012869834899902
(55) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 45258 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 AND class = 'CruiseLine') OR (item_id = 43 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.0013818740844727
(56) DESCRIBE `cruiselines` 0.0020828247070312
(57) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.0003049373626709
(58) DESCRIBE `orchid_image` 0.0016307830810547
(59) DESCRIBE `cruiselines` 0.0021359920501709
(60) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00034403800964355
(61) DESCRIBE `cruises` 0.0034778118133545
(62) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45260') 0.00038290023803711
(63) DESCRIBE `ships` 0.0028760433197021
(64) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00038385391235352
(65) DESCRIBE `ships` 0.0033700466156006
(66) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00034999847412109
(67) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00028204917907715
(68) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0002739429473877
(69) DESCRIBE `itineraries` 0.0016560554504395
(70) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '45260') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00074195861816406
(71) DESCRIBE `ports` 0.001971960067749
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00047016143798828
(73) DESCRIBE `ports` 0.0018851757049561
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0004270076751709
(75) DESCRIBE `ports` 0.001816987991333
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00030803680419922
(77) DESCRIBE `sailingdates` 0.0012080669403076
(78) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '45260') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00058507919311523
(79) DESCRIBE `ports` 0.0015900135040283
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0003349781036377
(81) DESCRIBE `ports` 0.0014500617980957
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0
(83) DESCRIBE `ports` 0.0012669563293457
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00033998489379883
(85) DESCRIBE `ports` 0.001704216003418
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00045013427734375
(87) DESCRIBE `ports` 0.0013141632080078
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.0006871223449707
(89) DESCRIBE `ports` 0.0014910697937012
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00033998489379883
(91) DESCRIBE `ports` 0.0012228488922119
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00029206275939941
(93) DESCRIBE `ports` 0.0015270709991455
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00034189224243164
(95) DESCRIBE `avid_specials` 0.0011498928070068
(96) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 45260 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 AND class = 'CruiseLine') OR (item_id = 43 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.0011270046234131
(97) DESCRIBE `cruiselines` 0.0018291473388672
(98) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00030708312988281
(99) DESCRIBE `orchid_image` 0.0017929077148438
(100) DESCRIBE `cruiselines` 0.0018548965454102
(101) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00036501884460449
(102) DESCRIBE `cruises` 0.0035228729248047
(103) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45259') 0.00040507316589355
(104) DESCRIBE `ships` 0.0035750865936279
(105) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00051498413085938
(106) DESCRIBE `ships` 0.0036501884460449
(107) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00045680999755859
(108) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034403800964355
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00036716461181641
(110) DESCRIBE `itineraries` 0.0018949508666992
(111) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '45259') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00062298774719238
(112) DESCRIBE `ports` 0.0019259452819824
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 1.8119812011719E-5
(114) DESCRIBE `ports` 0.0018100738525391
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00040316581726074
(116) DESCRIBE `ports` 0.0013179779052734
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00036120414733887
(118) DESCRIBE `sailingdates` 0.0016040802001953
(119) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '45259') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00071096420288086
(120) DESCRIBE `ports` 0.0021572113037109
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00042104721069336
(122) DESCRIBE `ports` 0.0015909671783447
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.0003209114074707
(124) DESCRIBE `ports` 0.001317024230957
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00034713745117188
(126) DESCRIBE `ports` 0.0012850761413574
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00029611587524414
(128) DESCRIBE `ports` 0.0013110637664795
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00029087066650391
(130) DESCRIBE `ports` 0.0012459754943848
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00026297569274902
(132) DESCRIBE `ports` 0.0012729167938232
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.0003049373626709
(134) DESCRIBE `ports` 0.0014941692352295
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00028610229492188
(136) DESCRIBE `ports` 0.0013561248779297
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00034379959106445
(138) DESCRIBE `ports` 0.0014100074768066
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00027799606323242
(140) DESCRIBE `avid_specials` 0.0011379718780518
(141) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 45259 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 AND class = 'CruiseLine') OR (item_id = 43 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.0010378360748291
(142) DESCRIBE `cruiselines` 0.0019080638885498
(143) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.0003969669342041
(144) DESCRIBE `orchid_image` 0.0014858245849609
(145) DESCRIBE `cruiselines` 0.00217604637146
(146) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00031900405883789
(147) DESCRIBE `ships` 0.0030670166015625
(148) SELECT `ships`.* FROM `ships` WHERE (id IN ('517')) ORDER BY FIND_IN_SET(id, '517') 0.00040602684020996
(149) DESCRIBE `cruisetypes` 0.0012400150299072
(150) DESCRIBE `destinations` 0.0019099712371826
(151) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43')) ORDER BY FIND_IN_SET(id, '43') 0.00061297416687012
(152) DESCRIBE `cruiselines` 0.002748966217041
(153) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00049686431884766
(154) DESCRIBE `cruiselines` 0.0024130344390869
(155) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.0004119873046875