or, enquire about your chosen options

  1. Never been on a cruise? Here’s what to expect……
  2. SPOTLIGHT ON: VIKING SUN
  3. Holland America’s View and Veranda promotion is back!!
  4. The Big Laugh Comedy Festival Cruise
  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: 398

Total elapsed time: 0.26867866516113

# Query Time
(1) connect 0.00052499771118164
(2) DESCRIBE `cruises` 0.0019879341125488
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (62161, 65474, 24582, 70180, 55619, 51422, 71395, 62586, 51426, 67200)) ORDER BY FIND_IN_SET(id, '62161,65474,24582,70180,55619,51422,71395,62586,51426,67200') 0.0014491081237793
(4) DESCRIBE `cruises` 0.0021510124206543
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62161') 0.00030398368835449
(6) DESCRIBE `ships` 0.0018429756164551
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00037384033203125
(8) DESCRIBE `ships` 0.0018601417541504
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00031089782714844
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00020098686218262
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018405914306641
(12) DESCRIBE `itineraries` 0.0010278224945068
(13) DESCRIBE `ports` 0.0011589527130127
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031709671020508
(15) DESCRIBE `ports` 0.00091099739074707
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002439022064209
(17) DESCRIBE `ports` 0.00081491470336914
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023984909057617
(19) DESCRIBE `sailingdates` 0.00079822540283203
(20) DESCRIBE `ports` 0.001276969909668
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031900405883789
(22) DESCRIBE `ports` 0.00092720985412598
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023412704467773
(24) DESCRIBE `ports` 0.00094413757324219
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00025200843811035
(26) DESCRIBE `ports` 0.00085878372192383
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00022482872009277
(28) DESCRIBE `ports` 0.00087404251098633
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026297569274902
(30) DESCRIBE `ports` 0.0008690357208252
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023007392883301
(32) DESCRIBE `avid_specials` 0.00087189674377441
(33) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62161 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0015361309051514
(34) DESCRIBE `cruiselines` 0.0013959407806396
(35) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00030994415283203
(36) DESCRIBE `orchid_image` 0.0010180473327637
(37) DESCRIBE `cruiselines` 0.00091385841369629
(38) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00019693374633789
(39) DESCRIBE `cruises` 0.0012822151184082
(40) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65474') 0.00023388862609863
(41) DESCRIBE `ships` 0.0012311935424805
(42) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.00023198127746582
(43) DESCRIBE `ships` 0.0012879371643066
(44) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00021195411682129
(45) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00015997886657715
(46) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017094612121582
(47) DESCRIBE `itineraries` 0.00069022178649902
(48) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65474') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00057411193847656
(49) DESCRIBE `ports` 0.00071501731872559
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00025606155395508
(51) DESCRIBE `ports` 0.00096702575683594
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00027704238891602
(53) DESCRIBE `ports` 0.00091099739074707
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00018405914306641
(55) DESCRIBE `sailingdates` 0.00054407119750977
(56) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65474') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00061488151550293
(57) DESCRIBE `ports` 0.00070285797119141
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0002439022064209
(59) DESCRIBE `ports` 0.0007319450378418
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00019001960754395
(61) DESCRIBE `ports` 0.00061392784118652
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00023198127746582
(63) DESCRIBE `ports` 0.00061702728271484
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00020289421081543
(65) DESCRIBE `avid_specials` 0.00060296058654785
(66) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65474 and class = 'Cruise') OR (item_id = 1284 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.00096487998962402
(67) DESCRIBE `cruiselines` 0.0010108947753906
(68) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.0002598762512207
(69) DESCRIBE `orchid_image` 0.0010089874267578
(70) DESCRIBE `cruiselines` 0.0011839866638184
(71) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00026202201843262
(72) DESCRIBE `cruises` 0.0014169216156006
(73) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '24582') 0.0002448558807373
(74) DESCRIBE `ships` 0.0016098022460938
(75) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.00026392936706543
(76) DESCRIBE `ships` 0.0012080669403076
(77) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00018095970153809
(78) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015997886657715
(79) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001828670501709
(80) DESCRIBE `itineraries` 0.00063300132751465
(81) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '24582') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00050616264343262
(82) DESCRIBE `ports` 0.00067901611328125
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00024008750915527
(84) DESCRIBE `ports` 0.00059819221496582
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00020408630371094
(86) DESCRIBE `ports` 0.00074505805969238
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00017619132995605
(88) DESCRIBE `sailingdates` 0.00060701370239258
(89) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '24582') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0004880428314209
(90) DESCRIBE `ports` 0.0011470317840576
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00024914741516113
(92) DESCRIBE `ports` 0.00069713592529297
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00023007392883301
(94) DESCRIBE `ports` 0.00092887878417969
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00021696090698242
(96) DESCRIBE `ports` 0.00087904930114746
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00023508071899414
(98) DESCRIBE `ports` 0.00088596343994141
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00021004676818848
(100) DESCRIBE `ports` 0.00061607360839844
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00016593933105469
(102) DESCRIBE `ports` 0.00058507919311523
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.00018000602722168
(104) DESCRIBE `ports` 0.00071001052856445
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.00016498565673828
(106) DESCRIBE `ports` 0.00058984756469727
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00023412704467773
(108) DESCRIBE `ports` 0.00061893463134766
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0001680850982666
(110) DESCRIBE `avid_specials` 0.00054097175598145
(111) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 24582 and class = 'Cruise') OR (item_id = 573 AND class = 'Ship') OR (item_id = 37 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.00096011161804199
(112) DESCRIBE `cruiselines` 0.00092506408691406
(113) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00021910667419434
(114) DESCRIBE `orchid_image` 0.0006868839263916
(115) DESCRIBE `cruiselines` 0.00087499618530273
(116) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00019407272338867
(117) DESCRIBE `cruises` 0.0013890266418457
(118) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70180') 0.00036811828613281
(119) DESCRIBE `ships` 0.0012080669403076
(120) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1285))) 0.00027203559875488
(121) DESCRIBE `ships` 0.0012998580932617
(122) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1285') 0.00025820732116699
(123) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016212463378906
(124) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00014996528625488
(125) DESCRIBE `itineraries` 0.00066804885864258
(126) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70180') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00049614906311035
(127) DESCRIBE `ports` 0.00075292587280273
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00022697448730469
(129) DESCRIBE `ports` 0.0006108283996582
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00018405914306641
(131) DESCRIBE `ports` 0.00058913230895996
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00019311904907227
(133) DESCRIBE `sailingdates` 0.00063800811767578
(134) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70180') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00072813034057617
(135) DESCRIBE `ports` 0.0010409355163574
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00029110908508301
(137) DESCRIBE `ports` 0.00089502334594727
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00019097328186035
(139) DESCRIBE `ports` 0.00062108039855957
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00020408630371094
(141) DESCRIBE `ports` 0.0006098747253418
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00016999244689941
(143) DESCRIBE `avid_specials` 0.00058698654174805
(144) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70180 and class = 'Cruise') OR (item_id = 1285 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.001276969909668
(145) DESCRIBE `cruiselines` 0.0013620853424072
(146) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00029397010803223
(147) DESCRIBE `orchid_image` 0.0010180473327637
(148) DESCRIBE `cruiselines` 0.0013308525085449
(149) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00024008750915527
(150) DESCRIBE `cruises` 0.0019609928131104
(151) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55619') 0.00028419494628906
(152) DESCRIBE `ships` 0.0018548965454102
(153) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 765))) 0.00040197372436523
(154) DESCRIBE `ships` 0.0020699501037598
(155) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '765') 0.00028109550476074
(156) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00021100044250488
(157) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0001978874206543
(158) DESCRIBE `itineraries` 0.00065493583679199
(159) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '55619') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00034213066101074
(160) DESCRIBE `ports` 0.00064301490783691
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00021004676818848
(162) DESCRIBE `ports` 0.00060796737670898
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00022101402282715
(164) DESCRIBE `ports` 0.00086593627929688
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00023412704467773
(166) DESCRIBE `sailingdates` 0.00087904930114746
(167) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '55619') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00075197219848633
(168) DESCRIBE `ports` 0.0013329982757568
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00033402442932129
(170) DESCRIBE `ports` 0.00071310997009277
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0001838207244873
(172) DESCRIBE `ports` 0.00060510635375977
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.00018501281738281
(174) DESCRIBE `ports` 0.00059103965759277
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.00016689300537109
(176) DESCRIBE `ports` 0.0006260871887207
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00018787384033203
(178) DESCRIBE `ports` 0.00058889389038086
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00016379356384277
(180) DESCRIBE `avid_specials` 0.00054812431335449
(181) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55619 and class = 'Cruise') OR (item_id = 765 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0012099742889404
(182) DESCRIBE `cruiselines` 0.0012660026550293
(183) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00029492378234863
(184) DESCRIBE `orchid_image` 0.00078201293945312
(185) DESCRIBE `cruiselines` 0.001183032989502
(186) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00029301643371582
(187) DESCRIBE `cruises` 0.0015010833740234
(188) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '51422') 0.00023007392883301
(189) DESCRIBE `ships` 0.0018401145935059
(190) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.0003058910369873
(191) DESCRIBE `ships` 0.0017750263214111
(192) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00019001960754395
(193) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017309188842773
(194) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017499923706055
(195) DESCRIBE `itineraries` 0.00060892105102539
(196) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '51422') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00043797492980957
(197) DESCRIBE `ports` 0.00065302848815918
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00020408630371094
(199) DESCRIBE `ports` 0.00063490867614746
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00018405914306641
(201) DESCRIBE `ports` 0.00059700012207031
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00018501281738281
(203) DESCRIBE `sailingdates` 0.00069808959960938
(204) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '51422') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00058484077453613
(205) DESCRIBE `ports` 0.00085091590881348
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00026583671569824
(207) DESCRIBE `ports` 0.00066208839416504
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00018906593322754
(209) DESCRIBE `ports` 0.00064396858215332
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 499))) 0.00023603439331055
(211) DESCRIBE `ports` 0.00073790550231934
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '499') 0.00017499923706055
(213) DESCRIBE `ports` 0.00061798095703125
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0002598762512207
(215) DESCRIBE `ports` 0.00089788436889648
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00024986267089844
(217) DESCRIBE `avid_specials` 0.0009150505065918
(218) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 51422 and class = 'Cruise') OR (item_id = 1284 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0010290145874023
(219) DESCRIBE `cruiselines` 0.0009150505065918
(220) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00024604797363281
(221) DESCRIBE `orchid_image` 0.00073122978210449
(222) DESCRIBE `cruiselines` 0.000823974609375
(223) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00019311904907227
(224) DESCRIBE `cruises` 0.0018930435180664
(225) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71395') 0.00031495094299316
(226) DESCRIBE `ships` 0.0013999938964844
(227) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1285))) 0.00024104118347168
(228) DESCRIBE `ships` 0.0011959075927734
(229) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1285') 0.00017499923706055
(230) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00015997886657715
(231) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0001518726348877
(232) DESCRIBE `itineraries` 0.00071501731872559
(233) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '71395') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00052189826965332
(234) DESCRIBE `ports` 0.0006871223449707
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00021505355834961
(236) DESCRIBE `ports` 0.00062012672424316
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00020313262939453
(238) DESCRIBE `ports` 0.00065803527832031
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00019693374633789
(240) DESCRIBE `sailingdates` 0.00061488151550293
(241) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '71395') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00042295455932617
(242) DESCRIBE `ports` 0.00070309638977051
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00022006034851074
(244) DESCRIBE `ports` 0.00069594383239746
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00017786026000977
(246) DESCRIBE `ports` 0.00067591667175293
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00020003318786621
(248) DESCRIBE `ports` 0.00064206123352051
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00016689300537109
(250) DESCRIBE `ports` 0.00061202049255371
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00018692016601562
(252) DESCRIBE `ports` 0.00070095062255859
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00016593933105469
(254) DESCRIBE `avid_specials` 0.00066804885864258
(255) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71395 and class = 'Cruise') OR (item_id = 1285 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.00088000297546387
(256) DESCRIBE `cruiselines` 0.00091791152954102
(257) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00021004676818848
(258) DESCRIBE `orchid_image` 0.00075507164001465
(259) DESCRIBE `cruiselines` 0.00086116790771484
(260) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00024199485778809
(261) DESCRIBE `cruises` 0.0012819766998291
(262) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62586') 0.00022506713867188
(263) DESCRIBE `ships` 0.001471996307373
(264) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 765))) 0.00034499168395996
(265) DESCRIBE `ships` 0.0014591217041016
(266) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '765') 0.00022411346435547
(267) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017213821411133
(268) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018596649169922
(269) DESCRIBE `itineraries` 0.00066494941711426
(270) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62586') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0003819465637207
(271) DESCRIBE `ports` 0.0008549690246582
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00023484230041504
(273) DESCRIBE `ports` 0.00063800811767578
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00025010108947754
(275) DESCRIBE `ports` 0.00063610076904297
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00017809867858887
(277) DESCRIBE `sailingdates` 0.00072503089904785
(278) DESCRIBE `ports` 0.00089883804321289
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00030088424682617
(280) DESCRIBE `ports` 0.00086402893066406
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00023603439331055
(282) DESCRIBE `ports` 0.00088095664978027
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2086))) 0.00022411346435547
(284) DESCRIBE `ports` 0.00064992904663086
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2086') 0.00021982192993164
(286) DESCRIBE `ports` 0.00067782402038574
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00020003318786621
(288) DESCRIBE `ports` 0.00081896781921387
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00019598007202148
(290) DESCRIBE `avid_specials` 0.00055599212646484
(291) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62586 and class = 'Cruise') OR (item_id = 765 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.00091195106506348
(292) DESCRIBE `cruiselines` 0.00099015235900879
(293) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00023508071899414
(294) DESCRIBE `orchid_image` 0.00072097778320312
(295) DESCRIBE `cruiselines` 0.00090408325195312
(296) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.0002601146697998
(297) DESCRIBE `cruises` 0.0017468929290771
(298) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '51426') 0.00035405158996582
(299) DESCRIBE `ships` 0.0018188953399658
(300) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.00033092498779297
(301) DESCRIBE `ships` 0.0015208721160889
(302) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00027084350585938
(303) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00021004676818848
(304) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0001978874206543
(305) DESCRIBE `itineraries` 0.00074100494384766
(306) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '51426') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0004420280456543
(307) DESCRIBE `ports` 0.0007319450378418
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00023579597473145
(309) DESCRIBE `ports` 0.00079703330993652
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00025606155395508
(311) DESCRIBE `ports` 0.00087809562683105
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00018811225891113
(313) DESCRIBE `sailingdates` 0.00054097175598145
(314) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '51426') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00045895576477051
(315) DESCRIBE `ports` 0.0011451244354248
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00030303001403809
(317) DESCRIBE `ports` 0.00093793869018555
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00021910667419434
(319) DESCRIBE `ports` 0.00068998336791992
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00028610229492188
(321) DESCRIBE `ports` 0.00074601173400879
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00017905235290527
(323) DESCRIBE `ports` 0.0007321834564209
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00025701522827148
(325) DESCRIBE `ports` 0.00080513954162598
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00019288063049316
(327) DESCRIBE `ports` 0.00062417984008789
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.00025391578674316
(329) DESCRIBE `ports` 0.00071406364440918
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.0002129077911377
(331) DESCRIBE `ports` 0.00072598457336426
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00019598007202148
(333) DESCRIBE `ports` 0.00065898895263672
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0001680850982666
(335) DESCRIBE `avid_specials` 0.00060009956359863
(336) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 51426 and class = 'Cruise') OR (item_id = 1284 AND class = 'Ship') OR (item_id = 37 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.0011279582977295
(337) DESCRIBE `cruiselines` 0.0010249614715576
(338) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00025105476379395
(339) DESCRIBE `orchid_image` 0.00076413154602051
(340) DESCRIBE `cruiselines` 0.0012259483337402
(341) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00022101402282715
(342) DESCRIBE `cruises` 0.0016062259674072
(343) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67200') 0.00031304359436035
(344) DESCRIBE `ships` 0.0014088153839111
(345) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1285))) 0.00030684471130371
(346) DESCRIBE `ships` 0.0012991428375244
(347) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1285') 0.00018715858459473
(348) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016093254089355
(349) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0001530647277832
(350) DESCRIBE `itineraries` 0.00064706802368164
(351) DESCRIBE `ports` 0.00068092346191406
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00021696090698242
(353) DESCRIBE `ports` 0.00058698654174805
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00024700164794922
(355) DESCRIBE `ports` 0.000823974609375
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0002601146697998
(357) DESCRIBE `sailingdates` 0.0008389949798584
(358) DESCRIBE `ports` 0.00068783760070801
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00022101402282715
(360) DESCRIBE `ports` 0.0006709098815918
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00018095970153809
(362) DESCRIBE `ports` 0.00058603286743164
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.00018000602722168
(364) DESCRIBE `ports` 0.00060582160949707
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.0001671314239502
(366) DESCRIBE `ports` 0.00059795379638672
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00022721290588379
(368) DESCRIBE `ports` 0.00071907043457031
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00018000602722168
(370) DESCRIBE `ports` 0.00076603889465332
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00021886825561523
(372) DESCRIBE `ports` 0.00079107284545898
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00019407272338867
(374) DESCRIBE `ports` 0.00060105323791504
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00018596649169922
(376) DESCRIBE `ports` 0.0005950927734375
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00016498565673828
(378) DESCRIBE `ports` 0.00058507919311523
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0002448558807373
(380) DESCRIBE `ports` 0.00060701370239258
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00018191337585449
(382) DESCRIBE `avid_specials` 0.00057506561279297
(383) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67200 and class = 'Cruise') OR (item_id = 1285 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.00089120864868164
(384) DESCRIBE `cruiselines` 0.0013041496276855
(385) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.0002748966217041
(386) DESCRIBE `orchid_image` 0.0007169246673584
(387) DESCRIBE `cruiselines` 0.0011460781097412
(388) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00028491020202637
(389) DESCRIBE `ships` 0.0019848346710205
(390) SELECT `ships`.* FROM `ships` WHERE (id IN ('573', '1285', '1402', '765', '1284')) ORDER BY FIND_IN_SET(id, '573,1285,1402,765,1284') 0.00054693222045898
(391) DESCRIBE `cruisetypes` 0.00072884559631348
(392) 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 = '37') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.028298139572144
(393) DESCRIBE `destinations` 0.001046895980835
(394) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('8', '43', '35')) ORDER BY FIND_IN_SET(id, '8,43,35') 0.00038504600524902
(395) DESCRIBE `cruiselines` 0.0010139942169189
(396) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00028800964355469
(397) DESCRIBE `cruiselines` 0.0015389919281006
(398) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00030899047851562