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

Total elapsed time: 0.20883584022522

# Query Time
(1) connect 0.0005500316619873
(2) DESCRIBE `cruises` 0.0023739337921143
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (65446, 69501)) ORDER BY FIND_IN_SET(id, '65446,69501') 0.00085806846618652
(4) DESCRIBE `specials` 0.0019659996032715
(5) SELECT `specials`.* FROM `specials` WHERE (id = '1391527') AND (specials.orchid_available = 1) LIMIT 1 0.00039196014404297
(6) DESCRIBE `specials` 0.002007007598877
(7) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1391527') 0.00021791458129883
(8) DESCRIBE `ships` 0.0014548301696777
(9) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1189))) 0.0002751350402832
(10) DESCRIBE `ships` 0.0014622211456299
(11) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1189') 0.00019001960754395
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00021600723266602
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00017714500427246
(14) DESCRIBE `itineraries` 0.00075101852416992
(15) DESCRIBE `ports` 0.00071907043457031
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00022602081298828
(17) DESCRIBE `ports` 0.00072312355041504
(18) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00020408630371094
(19) DESCRIBE `ports` 0.0007789134979248
(20) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00020503997802734
(21) DESCRIBE `specialsailingdates` 0.00057697296142578
(22) DESCRIBE `sailingdates` 0.00061297416687012
(23) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 411801))) 0.00038695335388184
(24) DESCRIBE `ports` 0.00075602531433105
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00024008750915527
(26) DESCRIBE `ports` 0.00067710876464844
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00019383430480957
(28) DESCRIBE `ports` 0.00070881843566895
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3888))) 0.00021886825561523
(30) DESCRIBE `ports` 0.00066995620727539
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3888') 0.00017094612121582
(32) DESCRIBE `ports` 0.00080704689025879
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3888))) 0.00018882751464844
(34) DESCRIBE `ports` 0.00066804885864258
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3888') 0.00017309188842773
(36) DESCRIBE `ports` 0.00067305564880371
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5480))) 0.00018906593322754
(38) DESCRIBE `ports` 0.00072884559631348
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5480') 0.00019407272338867
(40) DESCRIBE `ports` 0.00069594383239746
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 188))) 0.00020003318786621
(42) DESCRIBE `ports` 0.00071096420288086
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '188') 0.00021100044250488
(44) DESCRIBE `ports` 0.0006721019744873
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 189))) 0.00025486946105957
(46) DESCRIBE `ports` 0.00073909759521484
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '189') 0.00018310546875
(48) DESCRIBE `ports` 0.00066804885864258
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 187))) 0.00019407272338867
(50) DESCRIBE `ports` 0.00067687034606934
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '187') 0.0001828670501709
(52) DESCRIBE `ports` 0.0007479190826416
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4474))) 0.00019288063049316
(54) DESCRIBE `ports` 0.00080704689025879
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4474') 0.00018811225891113
(56) DESCRIBE `ports` 0.00066184997558594
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3295))) 0.00019598007202148
(58) DESCRIBE `ports` 0.00066590309143066
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3295') 0.00018596649169922
(60) DESCRIBE `ports` 0.00071310997009277
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 540))) 0.00019598007202148
(62) DESCRIBE `ports` 0.00066399574279785
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '540') 0.00018596649169922
(64) DESCRIBE `cruises` 0.0016989707946777
(65) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 65446))) 0.00033688545227051
(66) DESCRIBE `avid_specials` 0.00077509880065918
(67) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1391527 and class = 'Special') OR (item_id = 65446 and class = 'Cruise') OR (item_id = 1189 AND class = 'Ship') OR (item_id = 29 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.001014232635498
(68) DESCRIBE `cruiselines` 0.00098204612731934
(69) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00022697448730469
(70) DESCRIBE `orchid_image` 0.00075793266296387
(71) DESCRIBE `specials` 0.0020339488983154
(72) SELECT `specials`.* FROM `specials` WHERE (id = '1401841') AND (specials.orchid_available = 1) LIMIT 1 0.00038599967956543
(73) DESCRIBE `specials` 0.0019950866699219
(74) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1401841') 0.00020694732666016
(75) DESCRIBE `ships` 0.0013358592987061
(76) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 223))) 0.00025105476379395
(77) DESCRIBE `ships` 0.0014510154724121
(78) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '223') 0.00023221969604492
(79) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00018501281738281
(80) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00016403198242188
(81) DESCRIBE `itineraries` 0.00084590911865234
(82) DESCRIBE `ports` 0.00084900856018066
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00027179718017578
(84) DESCRIBE `ports` 0.00072884559631348
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00020408630371094
(86) DESCRIBE `ports` 0.00067901611328125
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00019383430480957
(88) DESCRIBE `specialsailingdates` 0.0006258487701416
(89) DESCRIBE `sailingdates` 0.00067591667175293
(90) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 436442))) 0.00034809112548828
(91) DESCRIBE `ports` 0.00073695182800293
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00020599365234375
(93) DESCRIBE `ports` 0.0010919570922852
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00025391578674316
(95) DESCRIBE `ports` 0.00095105171203613
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 870))) 0.00028204917907715
(97) DESCRIBE `ports` 0.0010318756103516
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '870') 0.00025010108947754
(99) DESCRIBE `ports` 0.00097298622131348
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1789))) 0.00028204917907715
(101) DESCRIBE `ports` 0.00098299980163574
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1789') 0.00018906593322754
(103) DESCRIBE `ports` 0.00070786476135254
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00020503997802734
(105) DESCRIBE `ports` 0.00069308280944824
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00018215179443359
(107) DESCRIBE `ports` 0.0006709098815918
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.0001990795135498
(109) DESCRIBE `ports` 0.00069117546081543
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.0001828670501709
(111) DESCRIBE `ports` 0.00069284439086914
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00019598007202148
(113) DESCRIBE `ports` 0.00066900253295898
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00018787384033203
(115) DESCRIBE `ports` 0.00069093704223633
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00020384788513184
(117) DESCRIBE `ports` 0.00066804885864258
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00018000602722168
(119) DESCRIBE `ports` 0.00066590309143066
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1265))) 0.00020003318786621
(121) DESCRIBE `ports` 0.00067996978759766
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1265') 0.00018095970153809
(123) DESCRIBE `ports` 0.00066900253295898
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00020217895507812
(125) DESCRIBE `ports` 0.00069189071655273
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00018692016601562
(127) DESCRIBE `ports` 0.0006868839263916
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1340))) 0.00020289421081543
(129) DESCRIBE `ports` 0.0006718635559082
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1340') 0.00018310546875
(131) DESCRIBE `ports` 0.00065994262695312
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00020217895507812
(133) DESCRIBE `ports` 0.00068306922912598
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00018191337585449
(135) DESCRIBE `ports` 0.00069189071655273
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020813941955566
(137) DESCRIBE `ports` 0.00067496299743652
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017309188842773
(139) DESCRIBE `ports` 0.0009150505065918
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024914741516113
(141) DESCRIBE `ports` 0.00094699859619141
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026202201843262
(143) DESCRIBE `ports` 0.0010738372802734
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00029087066650391
(145) DESCRIBE `ports` 0.0010421276092529
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00026488304138184
(147) DESCRIBE `ports` 0.0010139942169189
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00028586387634277
(149) DESCRIBE `ports` 0.0010809898376465
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00027203559875488
(151) DESCRIBE `ports` 0.0010199546813965
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00029206275939941
(153) DESCRIBE `ports` 0.0010130405426025
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00025296211242676
(155) DESCRIBE `ports` 0.0010180473327637
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1037))) 0.00028705596923828
(157) DESCRIBE `ports` 0.001011848449707
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1037') 0.00025606155395508
(159) DESCRIBE `ports` 0.00085711479187012
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00027084350585938
(161) DESCRIBE `ports` 0.00087499618530273
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00017905235290527
(163) DESCRIBE `ports` 0.00068283081054688
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1425))) 0.00020098686218262
(165) DESCRIBE `ports` 0.00069403648376465
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1425') 0.00017690658569336
(167) DESCRIBE `ports` 0.00072288513183594
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.00020813941955566
(169) DESCRIBE `ports` 0.00070500373840332
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '421') 0.00019693374633789
(171) DESCRIBE `ports` 0.00068306922912598
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1437))) 0.0001988410949707
(173) DESCRIBE `ports` 0.00068902969360352
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1437') 0.00017499923706055
(175) DESCRIBE `ports` 0.00067877769470215
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00020694732666016
(177) DESCRIBE `ports` 0.00088882446289062
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00017619132995605
(179) DESCRIBE `ports` 0.00070905685424805
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00020289421081543
(181) DESCRIBE `ports` 0.00071001052856445
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00018405914306641
(183) DESCRIBE `ports` 0.00074601173400879
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.0002140998840332
(185) DESCRIBE `ports` 0.0007479190826416
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00017786026000977
(187) DESCRIBE `ports` 0.00067806243896484
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) 0.00020480155944824
(189) DESCRIBE `ports` 0.0006859302520752
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1266') 0.0001978874206543
(191) DESCRIBE `ports` 0.00068998336791992
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) 0.0001990795135498
(193) DESCRIBE `ports` 0.00073409080505371
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1266') 0.00017595291137695
(195) DESCRIBE `ports` 0.00069904327392578
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00020194053649902
(197) DESCRIBE `ports` 0.00072312355041504
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.0001828670501709
(199) DESCRIBE `ports` 0.00067496299743652
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00019311904907227
(201) DESCRIBE `ports` 0.00069403648376465
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00020313262939453
(203) DESCRIBE `ports` 0.00072002410888672
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00019717216491699
(205) DESCRIBE `ports` 0.00067305564880371
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.0001828670501709
(207) DESCRIBE `ports` 0.00067782402038574
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00020003318786621
(209) DESCRIBE `ports` 0.00067591667175293
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00017285346984863
(211) DESCRIBE `ports` 0.00069499015808105
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00019598007202148
(213) DESCRIBE `ports` 0.00069093704223633
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00020289421081543
(215) DESCRIBE `ports` 0.00067591667175293
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00019407272338867
(217) DESCRIBE `ports` 0.00071501731872559
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00017905235290527
(219) DESCRIBE `ports` 0.00069904327392578
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00019311904907227
(221) DESCRIBE `ports` 0.00069785118103027
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00019216537475586
(223) DESCRIBE `ports` 0.00070714950561523
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020384788513184
(225) DESCRIBE `ports` 0.00069117546081543
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00019097328186035
(227) DESCRIBE `ports` 0.00075411796569824
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00020503997802734
(229) DESCRIBE `ports` 0.00071001052856445
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00018405914306641
(231) DESCRIBE `ports` 0.00071597099304199
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3087))) 0.00019979476928711
(233) DESCRIBE `ports` 0.000701904296875
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3087') 0.00018882751464844
(235) DESCRIBE `ports` 0.0007169246673584
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) 0.00020098686218262
(237) DESCRIBE `ports` 0.00068211555480957
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') 0.00024700164794922
(239) DESCRIBE `ports` 0.0007481575012207
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 399))) 0.00020599365234375
(241) DESCRIBE `ports` 0.00069403648376465
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '399') 0.0001828670501709
(243) DESCRIBE `ports` 0.00067901611328125
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1783))) 0.00022602081298828
(245) DESCRIBE `ports` 0.00069499015808105
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1783') 0.00017499923706055
(247) DESCRIBE `ports` 0.00067996978759766
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2115))) 0.0001990795135498
(249) DESCRIBE `ports` 0.00067400932312012
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2115') 0.00020098686218262
(251) DESCRIBE `ports` 0.00067496299743652
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 71))) 0.0001990795135498
(253) DESCRIBE `ports` 0.00066995620727539
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '71') 0.00017619132995605
(255) DESCRIBE `ports` 0.00076413154602051
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 71))) 0.00021100044250488
(257) DESCRIBE `ports` 0.00068187713623047
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '71') 0.00018095970153809
(259) DESCRIBE `ports` 0.00067281723022461
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 74))) 0.00019693374633789
(261) DESCRIBE `ports` 0.00070500373840332
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '74') 0.00019097328186035
(263) DESCRIBE `ports` 0.00069618225097656
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 396))) 0.00020813941955566
(265) DESCRIBE `ports` 0.00069904327392578
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '396') 0.00019097328186035
(267) DESCRIBE `ports` 0.00070500373840332
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 487))) 0.00026392936706543
(269) DESCRIBE `ports` 0.00084018707275391
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '487') 0.0001988410949707
(271) DESCRIBE `ports` 0.00097894668579102
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2442))) 0.00020289421081543
(273) DESCRIBE `ports` 0.00070405006408691
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2442') 0.00017499923706055
(275) DESCRIBE `ports` 0.00067496299743652
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 708))) 0.00021600723266602
(277) DESCRIBE `ports` 0.00068902969360352
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '708') 0.00017786026000977
(279) DESCRIBE `ports` 0.00068187713623047
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00021791458129883
(281) DESCRIBE `ports` 0.00071191787719727
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00018095970153809
(283) DESCRIBE `ports` 0.00073599815368652
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 707))) 0.0002140998840332
(285) DESCRIBE `ports` 0.00069499015808105
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '707') 0.00018000602722168
(287) DESCRIBE `ports` 0.0006859302520752
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 66))) 0.00022387504577637
(289) DESCRIBE `ports` 0.00069499015808105
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '66') 0.00017595291137695
(291) DESCRIBE `ports` 0.00068187713623047
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 66))) 0.00028300285339355
(293) DESCRIBE `ports` 0.00073599815368652
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '66') 0.00018000602722168
(295) DESCRIBE `ports` 0.00072288513183594
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 66))) 0.0001990795135498
(297) DESCRIBE `ports` 0.00071406364440918
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '66') 0.00018501281738281
(299) DESCRIBE `ports` 0.00068521499633789
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 64))) 0.00020599365234375
(301) DESCRIBE `ports` 0.00069594383239746
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '64') 0.00018405914306641
(303) DESCRIBE `ports` 0.00070095062255859
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 64))) 0.00019001960754395
(305) DESCRIBE `ports` 0.0007331371307373
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '64') 0.00017213821411133
(307) DESCRIBE `ports` 0.00069308280944824
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1728))) 0.00024509429931641
(309) DESCRIBE `ports` 0.00073885917663574
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1728') 0.00017499923706055
(311) DESCRIBE `ports` 0.00073409080505371
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 63))) 0.00019598007202148
(313) DESCRIBE `ports` 0.00072002410888672
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '63') 0.00017809867858887
(315) DESCRIBE `ports` 0.00068497657775879
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3450))) 0.00020408630371094
(317) DESCRIBE `ports` 0.00070405006408691
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3450') 0.00018000602722168
(319) DESCRIBE `ports` 0.00067591667175293
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 556))) 0.00019598007202148
(321) DESCRIBE `ports` 0.00069189071655273
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '556') 0.00017905235290527
(323) DESCRIBE `ports` 0.00075292587280273
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 60))) 0.00025701522827148
(325) DESCRIBE `ports` 0.0010018348693848
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '60') 0.00026583671569824
(327) DESCRIBE `ports` 0.00086498260498047
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 69))) 0.00030398368835449
(329) DESCRIBE `ports` 0.0010139942169189
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '69') 0.00024104118347168
(331) DESCRIBE `ports` 0.0010578632354736
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00027585029602051
(333) DESCRIBE `ports` 0.0010309219360352
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00025200843811035
(335) DESCRIBE `ports` 0.00098896026611328
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00028109550476074
(337) DESCRIBE `ports` 0.0010221004486084
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00023913383483887
(339) DESCRIBE `ports` 0.00097179412841797
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00026798248291016
(341) DESCRIBE `ports` 0.00099802017211914
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00023007392883301
(343) DESCRIBE `ports` 0.0009610652923584
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00025510787963867
(345) DESCRIBE `ports` 0.0010159015655518
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.0002601146697998
(347) DESCRIBE `ports` 0.00098991394042969
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 557))) 0.00027799606323242
(349) DESCRIBE `ports` 0.0010278224945068
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '557') 0.00023508071899414
(351) DESCRIBE `ports` 0.00105881690979
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00031614303588867
(353) DESCRIBE `ports` 0.0010099411010742
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00025010108947754
(355) DESCRIBE `ports` 0.0010309219360352
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00026202201843262
(357) DESCRIBE `ports` 0.00094795227050781
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00023484230041504
(359) DESCRIBE `ports` 0.0010719299316406
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00028204917907715
(361) DESCRIBE `ports` 0.0010190010070801
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00024199485778809
(363) DESCRIBE `ports` 0.0010237693786621
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 751))) 0.00020503997802734
(365) DESCRIBE `ports` 0.00069499015808105
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '751') 0.00017786026000977
(367) DESCRIBE `ports` 0.00070595741271973
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2806))) 0.00020122528076172
(369) DESCRIBE `ports` 0.00069499015808105
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2806') 0.0001978874206543
(371) DESCRIBE `ports` 0.00072288513183594
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2806))) 0.00019693374633789
(373) DESCRIBE `ports` 0.00072312355041504
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2806') 0.00017404556274414
(375) DESCRIBE `cruises` 0.0013740062713623
(376) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 69501))) 0.00035595893859863
(377) DESCRIBE `avid_specials` 0.00065493583679199
(378) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1401841 and class = 'Special') OR (item_id = 69501 and class = 'Cruise') OR (item_id = 223 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 40 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.0012168884277344
(379) DESCRIBE `cruiselines` 0.0012309551239014
(380) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00032806396484375
(381) DESCRIBE `orchid_image` 0.00083708763122559
(382) DESCRIBE `ships` 0.0017290115356445
(383) SELECT `ships`.* FROM `ships` WHERE (id IN ('223', '1189')) ORDER BY FIND_IN_SET(id, '223,1189') 0.00043392181396484
(384) DESCRIBE `cruisetypes` 0.00066518783569336
(385) DESCRIBE `destinations` 0.00098681449890137
(386) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('35', '40')) ORDER BY FIND_IN_SET(id, '35,40') 0.00034999847412109
(387) DESCRIBE `cruiselines` 0.0010759830474854
(388) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00025796890258789
(389) DESCRIBE `cruiselines` 0.0010840892791748
(390) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00024509429931641