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

Total elapsed time: 0.41997027397156

# Query Time
(1) connect 0.00074315071105957
(2) DESCRIBE `cruises` 0.0020790100097656
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (63278, 63244, 69280, 48343, 44592, 63243, 57765, 63033, 56529, 63241)) ORDER BY FIND_IN_SET(id, '63278,63244,69280,48343,44592,63243,57765,63033,56529,63241') 0.0015978813171387
(4) DESCRIBE `cruises` 0.0019869804382324
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63278') 0.00029683113098145
(6) DESCRIBE `ships` 0.0018248558044434
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 406))) 0.00039291381835938
(8) DESCRIBE `ships` 0.0017819404602051
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '406') 0.00028681755065918
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020098686218262
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(12) DESCRIBE `itineraries` 0.0009150505065918
(13) DESCRIBE `ports` 0.00105881690979
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00028014183044434
(15) DESCRIBE `ports` 0.00082278251647949
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00023293495178223
(17) DESCRIBE `ports` 0.00080299377441406
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00021910667419434
(19) DESCRIBE `sailingdates` 0.0008399486541748
(20) DESCRIBE `ports` 0.00098896026611328
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00029993057250977
(22) DESCRIBE `ports` 0.00077700614929199
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0002129077911377
(24) DESCRIBE `ports` 0.00066113471984863
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00019192695617676
(26) DESCRIBE `ports` 0.00063300132751465
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00022602081298828
(28) DESCRIBE `ports` 0.00094795227050781
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00026392936706543
(30) DESCRIBE `ports` 0.00082707405090332
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00023698806762695
(32) DESCRIBE `ports` 0.00092506408691406
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00025391578674316
(34) DESCRIBE `ports` 0.00089502334594727
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00023508071899414
(36) DESCRIBE `ports` 0.00082993507385254
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.0002741813659668
(38) DESCRIBE `ports` 0.00083303451538086
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00022101402282715
(40) DESCRIBE `ports` 0.00089001655578613
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00025677680969238
(42) DESCRIBE `ports` 0.00085902214050293
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00023293495178223
(44) DESCRIBE `ports` 0.00090599060058594
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 504))) 0.00028014183044434
(46) DESCRIBE `ports` 0.00087404251098633
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '504') 0.00026798248291016
(48) DESCRIBE `ports` 0.00099802017211914
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00042080879211426
(50) DESCRIBE `ports` 0.0010740756988525
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00023508071899414
(52) DESCRIBE `ports` 0.00088906288146973
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00023984909057617
(54) DESCRIBE `ports` 0.00083088874816895
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00020790100097656
(56) DESCRIBE `ports` 0.00086593627929688
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00024199485778809
(58) DESCRIBE `ports` 0.00086808204650879
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00022721290588379
(60) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63278') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0080301761627197
(61) DESCRIBE `avid_specials` 0.0010061264038086
(62) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63278 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.0016160011291504
(63) DESCRIBE `cruiselines` 0.0014350414276123
(64) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00037717819213867
(65) DESCRIBE `orchid_image` 0.001054048538208
(66) DESCRIBE `cruiselines` 0.0013680458068848
(67) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00025391578674316
(68) DESCRIBE `cruises` 0.0018668174743652
(69) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63244') 0.00029802322387695
(70) DESCRIBE `ships` 0.0018658638000488
(71) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1135))) 0.00035905838012695
(72) DESCRIBE `ships` 0.0018980503082275
(73) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1135') 0.00030398368835449
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020408630371094
(75) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018692016601562
(76) DESCRIBE `itineraries` 0.00098991394042969
(77) DESCRIBE `ports` 0.0011091232299805
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00028800964355469
(79) DESCRIBE `ports` 0.00085997581481934
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00023007392883301
(81) DESCRIBE `ports` 0.00089812278747559
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0002281665802002
(83) DESCRIBE `sailingdates` 0.00080204010009766
(84) DESCRIBE `ports` 0.0011038780212402
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00036907196044922
(86) DESCRIBE `ports` 0.00096297264099121
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00026488304138184
(88) DESCRIBE `ports` 0.00088906288146973
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00025200843811035
(90) DESCRIBE `ports` 0.00085091590881348
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00022006034851074
(92) DESCRIBE `ports` 0.00085902214050293
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3563))) 0.00025510787963867
(94) DESCRIBE `ports` 0.00085783004760742
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3563') 0.00021696090698242
(96) DESCRIBE `ports` 0.0008699893951416
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00026392936706543
(98) DESCRIBE `ports` 0.00086498260498047
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00023698806762695
(100) DESCRIBE `ports` 0.00088000297546387
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00028300285339355
(102) DESCRIBE `ports` 0.00093603134155273
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00023484230041504
(104) DESCRIBE `ports` 0.00085806846618652
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00026679039001465
(106) DESCRIBE `ports` 0.0009000301361084
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00024580955505371
(108) DESCRIBE `ports` 0.00092101097106934
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00026392936706543
(110) DESCRIBE `ports` 0.0009300708770752
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.0002598762512207
(112) DESCRIBE `ports` 0.00095987319946289
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00026893615722656
(114) DESCRIBE `ports` 0.000885009765625
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00024700164794922
(116) DESCRIBE `ports` 0.00090885162353516
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00024795532226562
(118) DESCRIBE `ports` 0.00087308883666992
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00022101402282715
(120) DESCRIBE `ports` 0.00086212158203125
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00025320053100586
(122) DESCRIBE `ports` 0.00091409683227539
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0002439022064209
(124) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63244') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0081260204315186
(125) DESCRIBE `avid_specials` 0.0010440349578857
(126) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63244 and class = 'Cruise') OR (item_id = 1135 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 12 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.0015912055969238
(127) DESCRIBE `cruiselines` 0.00136399269104
(128) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00030612945556641
(129) DESCRIBE `orchid_image` 0.00098991394042969
(130) DESCRIBE `cruiselines` 0.0012221336364746
(131) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00026106834411621
(132) DESCRIBE `cruises` 0.0017690658569336
(133) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69280') 0.00031113624572754
(134) DESCRIBE `ships` 0.0018131732940674
(135) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1409))) 0.00035595893859863
(136) DESCRIBE `ships` 0.0017998218536377
(137) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1409') 0.00034904479980469
(138) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020313262939453
(139) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019288063049316
(140) DESCRIBE `itineraries` 0.0010139942169189
(141) DESCRIBE `ports` 0.0010929107666016
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00028896331787109
(143) DESCRIBE `ports` 0.00093317031860352
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00023508071899414
(145) DESCRIBE `ports` 0.00085687637329102
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00021505355834961
(147) DESCRIBE `sailingdates` 0.00075101852416992
(148) DESCRIBE `ports` 0.00095081329345703
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00027108192443848
(150) DESCRIBE `ports` 0.00092601776123047
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.0002291202545166
(152) DESCRIBE `ports` 0.00086116790771484
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3669))) 0.00024318695068359
(154) DESCRIBE `ports` 0.00089216232299805
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3669') 0.00023603439331055
(156) DESCRIBE `ports` 0.00089216232299805
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00026297569274902
(158) DESCRIBE `ports` 0.00094318389892578
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00023293495178223
(160) DESCRIBE `ports` 0.00087285041809082
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00026607513427734
(162) DESCRIBE `ports` 0.00096917152404785
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00028085708618164
(164) DESCRIBE `ports` 0.00097489356994629
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00039005279541016
(166) DESCRIBE `ports` 0.00098204612731934
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00022506713867188
(168) DESCRIBE `ports` 0.00086498260498047
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00023818016052246
(170) DESCRIBE `ports` 0.0010039806365967
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00025606155395508
(172) DESCRIBE `ports` 0.0009300708770752
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00026512145996094
(174) DESCRIBE `ports` 0.00089192390441895
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00023102760314941
(176) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69280') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0087771415710449
(177) DESCRIBE `avid_specials` 0.0010709762573242
(178) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69280 and class = 'Cruise') OR (item_id = 1409 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.0015950202941895
(179) DESCRIBE `cruiselines` 0.0014290809631348
(180) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00037097930908203
(181) DESCRIBE `orchid_image` 0.0011651515960693
(182) DESCRIBE `cruiselines` 0.0013680458068848
(183) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00028395652770996
(184) DESCRIBE `cruises` 0.00193190574646
(185) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '48343') 0.00034904479980469
(186) DESCRIBE `ships` 0.0019569396972656
(187) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 451))) 0.00037598609924316
(188) DESCRIBE `ships` 0.0019729137420654
(189) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '451') 0.00029706954956055
(190) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020194053649902
(191) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019097328186035
(192) DESCRIBE `itineraries` 0.00097894668579102
(193) DESCRIBE `ports` 0.0010509490966797
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00031208992004395
(195) DESCRIBE `ports` 0.00092697143554688
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00025486946105957
(197) DESCRIBE `ports` 0.00093412399291992
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00023603439331055
(199) DESCRIBE `sailingdates` 0.00078797340393066
(200) DESCRIBE `ports` 0.0010030269622803
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00029611587524414
(202) DESCRIBE `ports` 0.00095391273498535
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00023794174194336
(204) DESCRIBE `ports` 0.00087809562683105
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.0002601146697998
(206) DESCRIBE `ports` 0.00090813636779785
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.00024509429931641
(208) DESCRIBE `ports` 0.00088191032409668
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1319))) 0.00026106834411621
(210) DESCRIBE `ports` 0.00090909004211426
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1319') 0.00025010108947754
(212) DESCRIBE `ports` 0.00089693069458008
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 791))) 0.00027799606323242
(214) DESCRIBE `ports` 0.00094795227050781
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '791') 0.00023508071899414
(216) DESCRIBE `ports` 0.000885009765625
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4650))) 0.00025606155395508
(218) DESCRIBE `ports` 0.0009760856628418
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4650') 0.00027203559875488
(220) DESCRIBE `ports` 0.00090789794921875
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4352))) 0.00026798248291016
(222) DESCRIBE `ports` 0.00095009803771973
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4352') 0.00023102760314941
(224) DESCRIBE `ports` 0.00087404251098633
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2450))) 0.00024890899658203
(226) DESCRIBE `ports` 0.00090217590332031
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2450') 0.00024700164794922
(228) DESCRIBE `ports` 0.000885009765625
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00025391578674316
(230) DESCRIBE `ports` 0.00088810920715332
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00022506713867188
(232) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '48343') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.00885009765625
(233) DESCRIBE `avid_specials` 0.0010590553283691
(234) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 48343 and class = 'Cruise') OR (item_id = 451 AND class = 'Ship') OR (item_id = 23 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.0015029907226562
(235) DESCRIBE `cruiselines` 0.0014069080352783
(236) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00031685829162598
(237) DESCRIBE `orchid_image` 0.0011341571807861
(238) DESCRIBE `cruiselines` 0.0014560222625732
(239) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00033712387084961
(240) DESCRIBE `cruises` 0.0018858909606934
(241) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '44592') 0.00030207633972168
(242) DESCRIBE `ships` 0.0018877983093262
(243) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 406))) 0.00039315223693848
(244) DESCRIBE `ships` 0.001953125
(245) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '406') 0.00029611587524414
(246) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021004676818848
(247) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019192695617676
(248) DESCRIBE `itineraries` 0.00098299980163574
(249) DESCRIBE `ports` 0.0010251998901367
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00029516220092773
(251) DESCRIBE `ports` 0.00094103813171387
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00023603439331055
(253) DESCRIBE `ports` 0.00088882446289062
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0002281665802002
(255) DESCRIBE `sailingdates` 0.00080609321594238
(256) DESCRIBE `ports` 0.0009160041809082
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00022292137145996
(258) DESCRIBE `ports` 0.00081300735473633
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00017905235290527
(260) DESCRIBE `ports` 0.00069403648376465
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00018811225891113
(262) DESCRIBE `ports` 0.00059795379638672
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00019502639770508
(264) DESCRIBE `ports` 0.00060296058654785
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00018811225891113
(266) DESCRIBE `ports` 0.00060892105102539
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00022292137145996
(268) DESCRIBE `ports` 0.00098299980163574
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00028681755065918
(270) DESCRIBE `ports` 0.00092887878417969
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00023698806762695
(272) DESCRIBE `ports` 0.00094008445739746
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00027084350585938
(274) DESCRIBE `ports` 0.00092291831970215
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00023007392883301
(276) DESCRIBE `ports` 0.00090813636779785
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00025486946105957
(278) DESCRIBE `ports` 0.00075602531433105
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00020909309387207
(280) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '44592') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0088350772857666
(281) DESCRIBE `avid_specials` 0.0010650157928467
(282) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 44592 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.0010020732879639
(283) DESCRIBE `cruiselines` 0.0010340213775635
(284) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00026583671569824
(285) DESCRIBE `orchid_image` 0.00070285797119141
(286) DESCRIBE `cruiselines` 0.00084900856018066
(287) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00019192695617676
(288) DESCRIBE `cruises` 0.0011329650878906
(289) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63243') 0.00020003318786621
(290) DESCRIBE `ships` 0.0011138916015625
(291) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1135))) 0.00021696090698242
(292) DESCRIBE `ships` 0.0012180805206299
(293) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1135') 0.00019288063049316
(294) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001521110534668
(295) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015115737915039
(296) DESCRIBE `itineraries` 0.00063395500183105
(297) DESCRIBE `ports` 0.00074005126953125
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00022101402282715
(299) DESCRIBE `ports` 0.00060200691223145
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00019288063049316
(301) DESCRIBE `ports` 0.00062394142150879
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00018501281738281
(303) DESCRIBE `sailingdates` 0.00058889389038086
(304) DESCRIBE `ports` 0.0011558532714844
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00024890899658203
(306) DESCRIBE `ports` 0.00060009956359863
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00021004676818848
(308) DESCRIBE `ports` 0.00059390068054199
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00017690658569336
(310) DESCRIBE `ports` 0.00059604644775391
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00015902519226074
(312) DESCRIBE `ports` 0.00063991546630859
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3563))) 0.00023317337036133
(314) DESCRIBE `ports` 0.00082302093505859
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3563') 0.00015902519226074
(316) DESCRIBE `ports` 0.00059103965759277
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00017881393432617
(318) DESCRIBE `ports` 0.00060915946960449
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00015902519226074
(320) DESCRIBE `ports` 0.00062894821166992
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00017189979553223
(322) DESCRIBE `ports` 0.00057697296142578
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.0001518726348877
(324) DESCRIBE `ports` 0.00058197975158691
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00017786026000977
(326) DESCRIBE `ports` 0.00066089630126953
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00034594535827637
(328) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63243') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0061521530151367
(329) DESCRIBE `avid_specials` 0.00081300735473633
(330) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63243 and class = 'Cruise') OR (item_id = 1135 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 12 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.001323938369751
(331) DESCRIBE `cruiselines` 0.00099802017211914
(332) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00022196769714355
(333) DESCRIBE `orchid_image` 0.00094699859619141
(334) DESCRIBE `cruiselines` 0.0012540817260742
(335) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00029397010803223
(336) DESCRIBE `cruises` 0.0016798973083496
(337) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57765') 0.00030303001403809
(338) DESCRIBE `ships` 0.0017130374908447
(339) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 98))) 0.00028800964355469
(340) DESCRIBE `ships` 0.0012989044189453
(341) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '98') 0.00019598007202148
(342) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015687942504883
(343) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014686584472656
(344) DESCRIBE `itineraries` 0.00062894821166992
(345) DESCRIBE `ports` 0.00064611434936523
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00021100044250488
(347) DESCRIBE `ports` 0.0005958080291748
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00017499923706055
(349) DESCRIBE `ports` 0.00059390068054199
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00016999244689941
(351) DESCRIBE `sailingdates` 0.00055599212646484
(352) DESCRIBE `ports` 0.00083398818969727
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00025200843811035
(354) DESCRIBE `ports` 0.00074005126953125
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00018692016601562
(356) DESCRIBE `ports` 0.00071406364440918
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) 0.00022697448730469
(358) DESCRIBE `ports` 0.0007021427154541
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '17') 0.00022411346435547
(360) DESCRIBE `ports` 0.00060200691223145
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00025010108947754
(362) DESCRIBE `ports` 0.00069808959960938
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00020003318786621
(364) DESCRIBE `ports` 0.00063204765319824
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00023412704467773
(366) DESCRIBE `ports` 0.00067806243896484
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00017595291137695
(368) DESCRIBE `ports` 0.00060486793518066
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 384))) 0.0001990795135498
(370) DESCRIBE `ports` 0.0012309551239014
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '384') 0.00027704238891602
(372) DESCRIBE `ports` 0.00090599060058594
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 331))) 0.00027203559875488
(374) DESCRIBE `ports` 0.00093317031860352
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '331') 0.00022006034851074
(376) DESCRIBE `ports` 0.00087285041809082
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00024795532226562
(378) DESCRIBE `ports` 0.00090813636779785
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00022292137145996
(380) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '57765') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0086321830749512
(381) DESCRIBE `avid_specials` 0.0010628700256348
(382) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57765 and class = 'Cruise') OR (item_id = 98 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 29 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.0016839504241943
(383) DESCRIBE `cruiselines` 0.0013418197631836
(384) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0003209114074707
(385) DESCRIBE `orchid_image` 0.0011851787567139
(386) DESCRIBE `cruiselines` 0.0013108253479004
(387) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00022506713867188
(388) DESCRIBE `cruises` 0.001244068145752
(389) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63033') 0.00021910667419434
(390) DESCRIBE `ships` 0.0011651515960693
(391) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 434))) 0.00023603439331055
(392) DESCRIBE `ships` 0.0011391639709473
(393) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '434') 0.00019502639770508
(394) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015783309936523
(395) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017094612121582
(396) DESCRIBE `itineraries` 0.00071597099304199
(397) DESCRIBE `ports` 0.00066494941711426
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00021886825561523
(399) DESCRIBE `ports` 0.00060296058654785
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00017595291137695
(401) DESCRIBE `ports` 0.00062108039855957
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00018596649169922
(403) DESCRIBE `sailingdates` 0.00063395500183105
(404) DESCRIBE `ports` 0.00069999694824219
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0002288818359375
(406) DESCRIBE `ports` 0.00069093704223633
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00017213821411133
(408) DESCRIBE `ports` 0.0005950927734375
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.0001828670501709
(410) DESCRIBE `ports` 0.00066518783569336
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00017094612121582
(412) DESCRIBE `ports` 0.00060200691223145
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00018596649169922
(414) DESCRIBE `ports` 0.0005950927734375
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00017189979553223
(416) DESCRIBE `ports` 0.00088000297546387
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2139))) 0.00022315979003906
(418) DESCRIBE `ports` 0.00067281723022461
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2139') 0.00017499923706055
(420) DESCRIBE `ports` 0.00070786476135254
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00020098686218262
(422) DESCRIBE `ports` 0.00067710876464844
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00016903877258301
(424) DESCRIBE `ports` 0.00060200691223145
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1155))) 0.00017976760864258
(426) DESCRIBE `ports` 0.00060701370239258
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1155') 0.00015807151794434
(428) DESCRIBE `ports` 0.00072193145751953
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00020718574523926
(430) DESCRIBE `ports` 0.0005958080291748
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.0001671314239502
(432) DESCRIBE `ports` 0.00068283081054688
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00019097328186035
(434) DESCRIBE `ports` 0.0005950927734375
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00019097328186035
(436) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63033') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0045120716094971
(437) DESCRIBE `avid_specials` 0.00081396102905273
(438) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63033 and class = 'Cruise') OR (item_id = 434 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 48 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.00096392631530762
(439) DESCRIBE `cruiselines` 0.00097489356994629
(440) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00022006034851074
(441) DESCRIBE `orchid_image` 0.00071310997009277
(442) DESCRIBE `cruiselines` 0.00085616111755371
(443) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00019001960754395
(444) DESCRIBE `cruises` 0.0011720657348633
(445) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56529') 0.00022292137145996
(446) DESCRIBE `ships` 0.001352071762085
(447) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 678))) 0.00026488304138184
(448) DESCRIBE `ships` 0.0015041828155518
(449) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '678') 0.00023484230041504
(450) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(451) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015592575073242
(452) DESCRIBE `itineraries` 0.00084090232849121
(453) DESCRIBE `ports` 0.00065994262695312
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.0002288818359375
(455) DESCRIBE `ports` 0.00063419342041016
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00020098686218262
(457) DESCRIBE `ports` 0.00089502334594727
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00017786026000977
(459) DESCRIBE `sailingdates` 0.00054502487182617
(460) DESCRIBE `ports` 0.00064396858215332
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00020790100097656
(462) DESCRIBE `ports` 0.0006098747253418
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00016999244689941
(464) DESCRIBE `ports` 0.00060200691223145
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00020313262939453
(466) DESCRIBE `ports` 0.00081896781921387
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00022006034851074
(468) DESCRIBE `ports` 0.00062108039855957
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00018501281738281
(470) DESCRIBE `ports` 0.00060796737670898
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00016498565673828
(472) DESCRIBE `ports` 0.0006251335144043
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00018596649169922
(474) DESCRIBE `ports` 0.00087404251098633
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00022506713867188
(476) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '56529') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0044407844543457
(477) DESCRIBE `avid_specials` 0.00077104568481445
(478) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56529 and class = 'Cruise') OR (item_id = 678 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 53 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.00087213516235352
(479) DESCRIBE `cruiselines` 0.0009768009185791
(480) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00025200843811035
(481) DESCRIBE `orchid_image` 0.00095200538635254
(482) DESCRIBE `cruiselines` 0.0013759136199951
(483) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00025010108947754
(484) DESCRIBE `cruises` 0.0015799999237061
(485) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63241') 0.00025200843811035
(486) DESCRIBE `ships` 0.001209020614624
(487) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 580))) 0.00024008750915527
(488) DESCRIBE `ships` 0.0012540817260742
(489) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '580') 0.00027203559875488
(490) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001828670501709
(491) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016021728515625
(492) DESCRIBE `itineraries` 0.00073790550231934
(493) DESCRIBE `ports` 0.00069093704223633
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00027203559875488
(495) DESCRIBE `ports` 0.00089406967163086
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.0002591609954834
(497) DESCRIBE `ports` 0.00089907646179199
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00017690658569336
(499) DESCRIBE `sailingdates` 0.00055408477783203
(500) DESCRIBE `ports` 0.00074505805969238
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00021100044250488
(502) DESCRIBE `ports` 0.00061917304992676
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00016903877258301
(504) DESCRIBE `ports` 0.00061202049255371
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00017595291137695
(506) DESCRIBE `ports` 0.0005958080291748
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00017213821411133
(508) DESCRIBE `ports` 0.00059008598327637
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00017690658569336
(510) DESCRIBE `ports` 0.00060391426086426
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00017118453979492
(512) DESCRIBE `ports` 0.0006868839263916
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 476))) 0.00017499923706055
(514) DESCRIBE `ports` 0.00060105323791504
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '476') 0.0001678466796875
(516) DESCRIBE `ports` 0.00063705444335938
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.00017714500427246
(518) DESCRIBE `ports` 0.00066089630126953
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.00016689300537109
(520) DESCRIBE `ports` 0.00059986114501953
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 418))) 0.0001978874206543
(522) DESCRIBE `ports` 0.00066184997558594
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '418') 0.00017499923706055
(524) DESCRIBE `ports` 0.00059795379638672
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00022292137145996
(526) DESCRIBE `ports` 0.00079703330993652
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00017905235290527
(528) DESCRIBE `ports` 0.00070095062255859
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00019598007202148
(530) DESCRIBE `ports` 0.0006260871887207
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00016999244689941
(532) DESCRIBE `ports` 0.00060296058654785
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3264))) 0.0002439022064209
(534) DESCRIBE `ports` 0.00059890747070312
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3264') 0.00015902519226074
(536) DESCRIBE `ports` 0.00060415267944336
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 323))) 0.00018906593322754
(538) DESCRIBE `ports` 0.00060105323791504
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '323') 0.0001981258392334
(540) DESCRIBE `ports` 0.00058913230895996
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5768))) 0.0001988410949707
(542) DESCRIBE `ports` 0.00069403648376465
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5768') 0.00016999244689941
(544) DESCRIBE `ports` 0.00059390068054199
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 335))) 0.00018095970153809
(546) DESCRIBE `ports` 0.00060391426086426
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '335') 0.00016999244689941
(548) DESCRIBE `ports` 0.0005950927734375
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1098))) 0.00018000602722168
(550) DESCRIBE `ports` 0.00061702728271484
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1098') 0.00016283988952637
(552) DESCRIBE `ports` 0.00060606002807617
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 431))) 0.00020694732666016
(554) DESCRIBE `ports` 0.00060105323791504
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '431') 0.00017404556274414
(556) DESCRIBE `ports` 0.00058889389038086
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.00018405914306641
(558) DESCRIBE `ports` 0.00059294700622559
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.00015401840209961
(560) DESCRIBE `ports` 0.00066208839416504
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 615))) 0.00018501281738281
(562) DESCRIBE `ports` 0.00064516067504883
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '615') 0.00016307830810547
(564) DESCRIBE `ports` 0.00059103965759277
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00018715858459473
(566) DESCRIBE `ports` 0.00064206123352051
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00015807151794434
(568) DESCRIBE `ports` 0.00091195106506348
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00020408630371094
(570) DESCRIBE `ports` 0.0006248950958252
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00016307830810547
(572) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63241') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0043919086456299
(573) DESCRIBE `avid_specials` 0.00072884559631348
(574) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63241 and class = 'Cruise') OR (item_id = 580 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 37 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.00084900856018066
(575) DESCRIBE `cruiselines` 0.00092506408691406
(576) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00021696090698242
(577) DESCRIBE `orchid_image` 0.00070500373840332
(578) DESCRIBE `cruiselines` 0.00086307525634766
(579) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00018191337585449
(580) DESCRIBE `ships` 0.0013720989227295
(581) SELECT `ships`.* FROM `ships` WHERE (id IN ('1135', '349', '542', '434', '1021', '678', '406', '451', '253', '290', '105', '348', '580', '98', '291', '341', '1409')) ORDER BY FIND_IN_SET(id, '1135,349,542,434,1021,678,406,451,253,290,105,348,580,98,291,341,1409') 0.0012040138244629
(582) DESCRIBE `cruisetypes` 0.00086092948913574
(583) DESCRIBE `destinations` 0.0015361309051514
(584) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '35', '2', '22', '43', '8', '48', '26', '53', '40', '34', '21', '29', '37', '38', '11', '25', '49', '28', '30')) ORDER BY FIND_IN_SET(id, '12,35,2,22,43,8,48,26,53,40,34,21,29,37,38,11,25,49,28,30') 0.0011410713195801
(585) DESCRIBE `cruiselines` 0.0013079643249512
(586) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00025820732116699
(587) DESCRIBE `cruiselines` 0.0010809898376465
(588) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00024890899658203