or, enquire about your chosen options

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

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

 
 

Please note, while cruise details and inclusions are accurate at time of loading they are subject to change due to changes in cruise line practices and policies. Please check details and inclusions at time of booking.

Database Profiling Report

Total queries executed: 574

Total elapsed time: 1.38259100914

# Query Time
(1) connect 0.010187149047852
(2) DESCRIBE `cruises` 0.0035159587860107
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66481, 66521, 68081, 66671, 69775, 69313, 69314, 69782, 59386, 66566)) ORDER BY FIND_IN_SET(id, '66481,66521,68081,66671,69775,69313,69314,69782,59386,66566') 0.010284185409546
(4) DESCRIBE `cruises` 0.0076770782470703
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66481') 0.004019021987915
(6) DESCRIBE `ships` 0.0076630115509033
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 406))) 0.0013699531555176
(8) DESCRIBE `ships` 0.0069448947906494
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '406') 0.0039119720458984
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033402442932129
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033307075500488
(12) DESCRIBE `itineraries` 0.0033071041107178
(13) DESCRIBE `ports` 0.011713027954102
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00044894218444824
(15) DESCRIBE `ports` 0.0027639865875244
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0030019283294678
(17) DESCRIBE `ports` 0.0018289089202881
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.001262903213501
(19) DESCRIBE `sailingdates` 0.00718092918396
(20) DESCRIBE `ports` 0.0020310878753662
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0021560192108154
(22) DESCRIBE `ports` 0.0091769695281982
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00039100646972656
(24) DESCRIBE `ports` 0.0017879009246826
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 566))) 0.00037693977355957
(26) DESCRIBE `ports` 0.0018908977508545
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '566') 0.00035691261291504
(28) DESCRIBE `ports` 0.0017139911651611
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00040912628173828
(30) DESCRIBE `ports` 0.0017879009246826
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.0038430690765381
(32) DESCRIBE `ports` 0.0016498565673828
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 275))) 0.00035691261291504
(34) DESCRIBE `ports` 0.0013160705566406
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '275') 0.00028395652770996
(36) DESCRIBE `ports` 0.0012588500976562
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00032496452331543
(38) DESCRIBE `ports` 0.0013680458068848
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00027990341186523
(40) DESCRIBE `ports` 0.0014247894287109
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00046396255493164
(42) DESCRIBE `ports` 0.0013821125030518
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00025200843811035
(44) DESCRIBE `ports` 0.0016720294952393
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00030517578125
(46) DESCRIBE `ports` 0.0035710334777832
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00040292739868164
(48) DESCRIBE `ports` 0.0098531246185303
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00047898292541504
(50) DESCRIBE `ports` 0.0021331310272217
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00042986869812012
(52) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66481') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.018687009811401
(53) DESCRIBE `avid_specials` 0.0018999576568604
(54) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66481 and class = 'Cruise') OR (item_id = 406 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 22 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.0032389163970947
(55) DESCRIBE `cruiselines` 0.0023510456085205
(56) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00040793418884277
(57) DESCRIBE `orchid_image` 0.010847091674805
(58) DESCRIBE `cruiselines` 0.0027971267700195
(59) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00041317939758301
(60) DESCRIBE `cruises` 0.0042788982391357
(61) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66521') 0.00035190582275391
(62) DESCRIBE `ships` 0.0031280517578125
(63) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 542))) 0.00041699409484863
(64) DESCRIBE `ships` 0.0035028457641602
(65) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '542') 0.0004267692565918
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030279159545898
(67) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003209114074707
(68) DESCRIBE `itineraries` 0.0023541450500488
(69) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66521') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011129379272461
(70) DESCRIBE `ports` 0.0021541118621826
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00052809715270996
(72) DESCRIBE `ports` 0.002007007598877
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00048685073852539
(74) DESCRIBE `ports` 0.0020301342010498
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00041413307189941
(76) DESCRIBE `sailingdates` 0.00166916847229
(77) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66521') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00099420547485352
(78) DESCRIBE `ports` 0.008159875869751
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00056600570678711
(80) DESCRIBE `ports` 0.002345085144043
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00017809867858887
(82) DESCRIBE `ports` 0.0026190280914307
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 704))) 0.00053000450134277
(84) DESCRIBE `ports` 0.0026929378509521
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '704') 0.00010490417480469
(86) DESCRIBE `ports` 0.002716064453125
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00048589706420898
(88) DESCRIBE `ports` 0.0015871524810791
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.0001521110534668
(90) DESCRIBE `ports` 0.0015089511871338
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00062799453735352
(92) DESCRIBE `ports` 0.0020370483398438
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00040888786315918
(94) DESCRIBE `ports` 0.0024399757385254
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00044417381286621
(96) DESCRIBE `ports` 0.0072469711303711
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00035500526428223
(98) DESCRIBE `ports` 0.0015511512756348
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.0004570484161377
(100) DESCRIBE `ports` 0.0020320415496826
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00047183036804199
(102) DESCRIBE `ports` 0.0082859992980957
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00036191940307617
(104) DESCRIBE `ports` 0.0015721321105957
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00028514862060547
(106) DESCRIBE `ports` 0.0015561580657959
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 275))) 0.0003969669342041
(108) DESCRIBE `ports` 0.0017859935760498
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '275') 0.0003809928894043
(110) DESCRIBE `ports` 0.0018279552459717
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00039911270141602
(112) DESCRIBE `ports` 0.0020899772644043
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00042414665222168
(114) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66521') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0052759647369385
(115) DESCRIBE `avid_specials` 0.0013558864593506
(116) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66521 and class = 'Cruise') OR (item_id = 542 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 22 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.0013060569763184
(117) DESCRIBE `cruiselines` 0.0019340515136719
(118) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00036406517028809
(119) DESCRIBE `orchid_image` 0.0016939640045166
(120) DESCRIBE `cruiselines` 0.002007007598877
(121) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00028395652770996
(122) DESCRIBE `cruises` 0.0027980804443359
(123) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68081') 0.0003058910369873
(124) DESCRIBE `ships` 0.0026450157165527
(125) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 451))) 0.00035309791564941
(126) DESCRIBE `ships` 0.0026991367340088
(127) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '451') 0.00037097930908203
(128) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019288063049316
(129) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00013303756713867
(130) DESCRIBE `itineraries` 0.0018959045410156
(131) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68081') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00067710876464844
(132) DESCRIBE `ports` 0.0023670196533203
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00044798851013184
(134) DESCRIBE `ports` 0.001924991607666
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00043010711669922
(136) DESCRIBE `ports` 0.0023279190063477
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00029516220092773
(138) DESCRIBE `sailingdates` 0.001147985458374
(139) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68081') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00066113471984863
(140) DESCRIBE `ports` 0.001896858215332
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00035500526428223
(142) DESCRIBE `ports` 0.0015931129455566
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00031900405883789
(144) DESCRIBE `ports` 0.001305103302002
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00031113624572754
(146) DESCRIBE `ports` 0.0013020038604736
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00028896331787109
(148) DESCRIBE `ports` 0.0012979507446289
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 734))) 0.00031590461730957
(150) DESCRIBE `ports` 0.0017759799957275
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '734') 0.00040102005004883
(152) DESCRIBE `ports` 0.0019001960754395
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00039887428283691
(154) DESCRIBE `ports` 0.0016968250274658
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.0083160400390625
(156) DESCRIBE `ports` 0.0014030933380127
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00030303001403809
(158) DESCRIBE `ports` 0.0017139911651611
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00028204917907715
(160) DESCRIBE `ports` 0.0017919540405273
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031089782714844
(162) DESCRIBE `ports` 0.001270055770874
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027608871459961
(164) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68081') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0052089691162109
(165) DESCRIBE `avid_specials` 0.0014030933380127
(166) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68081 and class = 'Cruise') OR (item_id = 451 AND class = 'Ship') OR (item_id = 23 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.0012760162353516
(167) DESCRIBE `cruiselines` 0.0024380683898926
(168) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00031590461730957
(169) DESCRIBE `orchid_image` 0.0080499649047852
(170) DESCRIBE `cruiselines` 0.0025289058685303
(171) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00036406517028809
(172) DESCRIBE `cruises` 0.0034480094909668
(173) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66671') 0.00030899047851562
(174) DESCRIBE `ships` 0.0027780532836914
(175) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1135))) 0.00035190582275391
(176) DESCRIBE `ships` 0.0026540756225586
(177) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1135') 0.00035905838012695
(178) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026082992553711
(179) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025415420532227
(180) DESCRIBE `itineraries` 0.0016438961029053
(181) DESCRIBE `ports` 0.0022318363189697
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00046610832214355
(183) DESCRIBE `ports` 0.0057990550994873
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0036830902099609
(185) DESCRIBE `ports` 0.0014111995697021
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.0010519027709961
(187) DESCRIBE `sailingdates` 0.0037989616394043
(188) DESCRIBE `ports` 0.0052299499511719
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0012249946594238
(190) DESCRIBE `ports` 0.0031430721282959
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00078797340393066
(192) DESCRIBE `ports` 0.0018680095672607
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 118))) 0.0038051605224609
(194) DESCRIBE `ports` 0.0018730163574219
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '118') 0.0029730796813965
(196) DESCRIBE `ports` 0.0021979808807373
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.0041639804840088
(198) DESCRIBE `ports` 0.0013201236724854
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.0014290809631348
(200) DESCRIBE `ports` 0.001554012298584
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.003835916519165
(202) DESCRIBE `ports` 0.0014350414276123
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.007580041885376
(204) DESCRIBE `ports` 0.0021610260009766
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 333))) 0.00044989585876465
(206) DESCRIBE `ports` 0.0013470649719238
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '333') 0.0010190010070801
(208) DESCRIBE `ports` 0.0039770603179932
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00035905838012695
(210) DESCRIBE `ports` 0.0014050006866455
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.0053920745849609
(212) DESCRIBE `ports` 0.0017509460449219
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0038368701934814
(214) DESCRIBE `ports` 0.0016980171203613
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.0052189826965332
(216) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66671') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.005443811416626
(217) DESCRIBE `avid_specials` 0.011669158935547
(218) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66671 and class = 'Cruise') OR (item_id = 1135 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 11 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.0046539306640625
(219) DESCRIBE `cruiselines` 0.0048410892486572
(220) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0028398036956787
(221) DESCRIBE `orchid_image` 0.0014619827270508
(222) DESCRIBE `cruiselines` 0.0045440196990967
(223) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0035109519958496
(224) DESCRIBE `cruises` 0.0040249824523926
(225) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69775') 0.0033500194549561
(226) DESCRIBE `ships` 0.0042788982391357
(227) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 678))) 0.0049550533294678
(228) DESCRIBE `ships` 0.0026381015777588
(229) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '678') 0.0049841403961182
(230) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028705596923828
(231) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027990341186523
(232) DESCRIBE `itineraries` 0.001655101776123
(233) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69775') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0032570362091064
(234) DESCRIBE `ports` 0.0037939548492432
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.0011210441589355
(236) DESCRIBE `ports` 0.0028531551361084
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.0025379657745361
(238) DESCRIBE `ports` 0.0013589859008789
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.002532958984375
(240) DESCRIBE `sailingdates` 0.0016210079193115
(241) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69775') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0036070346832275
(242) DESCRIBE `ports` 0.0022130012512207
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.0026900768280029
(244) DESCRIBE `ports` 0.0028679370880127
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.0012650489807129
(246) DESCRIBE `ports` 0.002892017364502
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.0025441646575928
(248) DESCRIBE `ports` 0.0013949871063232
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.0027718544006348
(250) DESCRIBE `ports` 0.0012969970703125
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.002903938293457
(252) DESCRIBE `ports` 0.0017111301422119
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.0027260780334473
(254) DESCRIBE `ports` 0.002140998840332
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2224))) 0.0020089149475098
(256) DESCRIBE `ports` 0.0038700103759766
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2224') 0.0027410984039307
(258) DESCRIBE `ports` 0.0014591217041016
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.0053541660308838
(260) DESCRIBE `ports` 0.0019168853759766
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.0029940605163574
(262) DESCRIBE `ports` 0.0015389919281006
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.0042681694030762
(264) DESCRIBE `ports` 0.0017631053924561
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.0073211193084717
(266) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69775') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0047938823699951
(267) DESCRIBE `avid_specials` 0.0070290565490723
(268) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69775 and class = 'Cruise') OR (item_id = 678 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 34 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.0011708736419678
(269) DESCRIBE `cruiselines` 0.0020079612731934
(270) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0
(271) DESCRIBE `orchid_image` 0.0019059181213379
(272) DESCRIBE `cruiselines` 0.010616064071655
(273) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0
(274) DESCRIBE `cruises` 0.0030369758605957
(275) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69313') 0.0063490867614746
(276) DESCRIBE `ships` 0.0029771327972412
(277) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 253))) 0.004256010055542
(278) DESCRIBE `ships` 0.0021378993988037
(279) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '253') 0.00031590461730957
(280) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0
(281) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0
(282) DESCRIBE `itineraries` 0.0015909671783447
(283) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69313') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0013928413391113
(284) DESCRIBE `ports` 0.0013861656188965
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 3.1948089599609E-5
(286) DESCRIBE `ports` 0.0015089511871338
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00033211708068848
(288) DESCRIBE `ports` 0.0014059543609619
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0
(290) DESCRIBE `sailingdates` 0.0019659996032715
(291) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69313') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011889934539795
(292) DESCRIBE `ports` 0.00189208984375
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 8.9883804321289E-5
(294) DESCRIBE `ports` 0.0014150142669678
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.0002899169921875
(296) DESCRIBE `ports` 0.0024449825286865
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0
(298) DESCRIBE `ports` 0.0017359256744385
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 9.608268737793E-5
(300) DESCRIBE `ports` 0.0015149116516113
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00035786628723145
(302) DESCRIBE `ports` 0.0015799999237061
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.0010781288146973
(304) DESCRIBE `ports` 0.00087690353393555
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.0003359317779541
(306) DESCRIBE `ports` 0.0019609928131104
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00059604644775391
(308) DESCRIBE `ports` 0.0014290809631348
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00055480003356934
(310) DESCRIBE `ports` 0.00089192390441895
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00029301643371582
(312) DESCRIBE `ports` 0.0019330978393555
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00025105476379395
(314) DESCRIBE `ports` 0.0018460750579834
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.0004279613494873
(316) DESCRIBE `ports` 0.0020260810852051
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 86))) 0.00058698654174805
(318) DESCRIBE `ports` 0.0018768310546875
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '86') 0.00036001205444336
(320) DESCRIBE `ports` 0.0078580379486084
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0
(322) DESCRIBE `ports` 0.0016751289367676
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00024700164794922
(324) DESCRIBE `ports` 0.0018711090087891
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0002751350402832
(326) DESCRIBE `ports` 0.0011370182037354
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0
(328) DESCRIBE `ports` 0.0017478466033936
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.0056719779968262
(330) DESCRIBE `ports` 0.0015251636505127
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00057506561279297
(332) DESCRIBE `ports` 0.0013959407806396
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00092911720275879
(334) DESCRIBE `ports` 0.0080978870391846
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00055098533630371
(336) DESCRIBE `ports` 0.0011179447174072
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00030398368835449
(338) DESCRIBE `ports` 0.0081989765167236
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00032305717468262
(340) DESCRIBE `ports` 0.0010969638824463
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 5.2928924560547E-5
(342) DESCRIBE `ports` 0.00085902214050293
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00030088424682617
(344) DESCRIBE `ports` 0.0017220973968506
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039100646972656
(346) DESCRIBE `ports` 0.0017530918121338
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003659725189209
(348) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69313') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0062088966369629
(349) DESCRIBE `avid_specials` 0.0015590190887451
(350) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69313 and class = 'Cruise') OR (item_id = 253 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.0012509822845459
(351) DESCRIBE `cruiselines` 0.0022420883178711
(352) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00035214424133301
(353) DESCRIBE `orchid_image` 0.001863956451416
(354) DESCRIBE `cruiselines` 0.0019001960754395
(355) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00031685829162598
(356) DESCRIBE `cruises` 0.0025641918182373
(357) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69314') 0.00033998489379883
(358) DESCRIBE `ships` 0.0027539730072021
(359) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 253))) 0.00057792663574219
(360) DESCRIBE `ships` 0.0039241313934326
(361) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '253') 0.0002741813659668
(362) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002748966217041
(363) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025200843811035
(364) DESCRIBE `itineraries` 0.0013430118560791
(365) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69314') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00050687789916992
(366) DESCRIBE `ports` 0.010216951370239
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00033020973205566
(368) DESCRIBE `ports` 0.0012011528015137
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00030517578125
(370) DESCRIBE `ports` 0.0013201236724854
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00037717819213867
(372) DESCRIBE `sailingdates` 0.0013401508331299
(373) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69314') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00053000450134277
(374) DESCRIBE `ports` 0.0022590160369873
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.0007939338684082
(376) DESCRIBE `ports` 0.00073099136352539
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00030303001403809
(378) DESCRIBE `ports` 0.0022921562194824
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0
(380) DESCRIBE `ports` 0.0094761848449707
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.0003349781036377
(382) DESCRIBE `ports` 0.0013880729675293
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0
(384) DESCRIBE `ports` 0.0014429092407227
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00026202201843262
(386) DESCRIBE `ports` 0.0074350833892822
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00027894973754883
(388) DESCRIBE `ports` 0.0016460418701172
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00041985511779785
(390) DESCRIBE `ports` 0.0013799667358398
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.0002901554107666
(392) DESCRIBE `ports` 0.00136399269104
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00031304359436035
(394) DESCRIBE `ports` 0.0014500617980957
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00041007995605469
(396) DESCRIBE `ports` 0.0073189735412598
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00017499923706055
(398) DESCRIBE `ports` 0.0016229152679443
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 86))) 0.00042915344238281
(400) DESCRIBE `ports` 0.0050349235534668
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '86') 0.00027799606323242
(402) DESCRIBE `ports` 0.0014400482177734
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00063204765319824
(404) DESCRIBE `ports` 0.0011818408966064
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00048398971557617
(406) DESCRIBE `ports` 0.0010249614715576
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0
(408) DESCRIBE `ports` 0.0011200904846191
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0
(410) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69314') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0062899589538574
(411) DESCRIBE `avid_specials` 0.0027399063110352
(412) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69314 and class = 'Cruise') OR (item_id = 253 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.0010321140289307
(413) DESCRIBE `cruiselines` 0.0029289722442627
(414) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0026731491088867
(415) DESCRIBE `orchid_image` 0.0016300678253174
(416) DESCRIBE `cruiselines` 0.0051708221435547
(417) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0062909126281738
(418) DESCRIBE `cruises` 0.002781867980957
(419) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69782') 0.0080239772796631
(420) DESCRIBE `ships` 0.0038220882415771
(421) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 98))) 0.015058040618896
(422) DESCRIBE `ships` 0.0043160915374756
(423) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '98') 0.0012938976287842
(424) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 6.413459777832E-5
(425) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032401084899902
(426) DESCRIBE `itineraries` 0.001823902130127
(427) DESCRIBE `ports` 0.012839794158936
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00038504600524902
(429) DESCRIBE `ports` 0.0022459030151367
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.0092229843139648
(431) DESCRIBE `ports` 0.0020480155944824
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00039386749267578
(433) DESCRIBE `sailingdates` 0.0018069744110107
(434) DESCRIBE `ports` 0.0091750621795654
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00048398971557617
(436) DESCRIBE `ports` 0.0026888847351074
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00032401084899902
(438) DESCRIBE `ports` 0.001906156539917
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.0040020942687988
(440) DESCRIBE `ports` 0.0018620491027832
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0
(442) DESCRIBE `ports` 0.0055198669433594
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00055289268493652
(444) DESCRIBE `ports` 0.0015079975128174
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.0004270076751709
(446) DESCRIBE `ports` 0.00193190574646
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.0021119117736816
(448) DESCRIBE `ports` 0.02312707901001
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00046706199645996
(450) DESCRIBE `ports` 0.0019640922546387
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00049901008605957
(452) DESCRIBE `ports` 0.0020248889923096
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00043201446533203
(454) DESCRIBE `ports` 0.010822057723999
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00051498413085938
(456) DESCRIBE `ports` 0.0018630027770996
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00038790702819824
(458) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69782') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0084648132324219
(459) DESCRIBE `avid_specials` 0.013247966766357
(460) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69782 and class = 'Cruise') OR (item_id = 98 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 34 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.01009202003479
(461) DESCRIBE `cruiselines` 0.0084888935089111
(462) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00050115585327148
(463) DESCRIBE `orchid_image` 0.0016469955444336
(464) DESCRIBE `cruiselines` 0.001924991607666
(465) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00034904479980469
(466) DESCRIBE `cruises` 0.00819993019104
(467) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59386') 0.00052404403686523
(468) DESCRIBE `ships` 0.0043590068817139
(469) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 580))) 0.0029969215393066
(470) DESCRIBE `ships` 0.011647939682007
(471) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '580') 0.0083239078521729
(472) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027704238891602
(473) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029683113098145
(474) DESCRIBE `itineraries` 0.0014932155609131
(475) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '59386') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0033650398254395
(476) DESCRIBE `ports` 0.0015590190887451
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00036096572875977
(478) DESCRIBE `ports` 0.0066370964050293
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00039196014404297
(480) DESCRIBE `ports` 0.0013589859008789
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00490403175354
(482) DESCRIBE `sailingdates` 0.0013470649719238
(483) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '59386') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0026669502258301
(484) DESCRIBE `ports` 0.0065600872039795
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00042009353637695
(486) DESCRIBE `ports` 0.0015280246734619
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00038599967956543
(488) DESCRIBE `ports` 0.0017600059509277
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.0083680152893066
(490) DESCRIBE `ports` 0.0017201900482178
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.0003359317779541
(492) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '59386') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0050060749053955
(493) DESCRIBE `avid_specials` 0.0078170299530029
(494) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59386 and class = 'Cruise') OR (item_id = 580 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 34 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.00124192237854
(495) DESCRIBE `cruiselines` 0.0021991729736328
(496) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00039792060852051
(497) DESCRIBE `orchid_image` 0.0018069744110107
(498) DESCRIBE `cruiselines` 0.009990930557251
(499) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.010656118392944
(500) DESCRIBE `cruises` 0.0037181377410889
(501) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66566') 0.0053541660308838
(502) DESCRIBE `ships` 0.0039329528808594
(503) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 341))) 0.0078179836273193
(504) DESCRIBE `ships` 0.0043010711669922
(505) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '341') 0.0012450218200684
(506) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00069713592529297
(507) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00059390068054199
(508) DESCRIBE `itineraries` 0.0017480850219727
(509) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66566') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0016438961029053
(510) DESCRIBE `ports` 0.0023441314697266
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 218))) 0.00035715103149414
(512) DESCRIBE `ports` 0.001460075378418
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 218))) 0.00031590461730957
(514) DESCRIBE `ports` 0.001539945602417
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '218') 0.00029611587524414
(516) DESCRIBE `sailingdates` 0.0098989009857178
(517) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66566') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00067877769470215
(518) DESCRIBE `ports` 0.0015878677368164
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 218))) 0.0003209114074707
(520) DESCRIBE `ports` 0.0016641616821289
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '218') 0.00029802322387695
(522) DESCRIBE `ports` 0.0013759136199951
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00033402442932129
(524) DESCRIBE `ports` 0.0017611980438232
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00035715103149414
(526) DESCRIBE `ports` 0.0018081665039062
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.007378101348877
(528) DESCRIBE `ports` 0.0019609928131104
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00039100646972656
(530) DESCRIBE `ports` 0.001762866973877
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00040197372436523
(532) DESCRIBE `ports` 0.0015571117401123
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.0067248344421387
(534) DESCRIBE `ports` 0.0016410350799561
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00037288665771484
(536) DESCRIBE `ports` 0.0014231204986572
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00036406517028809
(538) DESCRIBE `ports` 0.0015809535980225
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 642))) 0.00035309791564941
(540) DESCRIBE `ports` 0.0012998580932617
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '642') 0.0095131397247314
(542) DESCRIBE `ports` 0.0016438961029053
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.0003049373626709
(544) DESCRIBE `ports` 0.0012941360473633
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00026488304138184
(546) DESCRIBE `ports` 0.0012648105621338
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1526))) 0.00034999847412109
(548) DESCRIBE `ports` 0.001331090927124
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1526') 0.00027298927307129
(550) DESCRIBE `ports` 0.0013589859008789
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00034213066101074
(552) DESCRIBE `ports` 0.0015251636505127
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.0089540481567383
(554) DESCRIBE `ports` 0.0017931461334229
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 218))) 0.00033307075500488
(556) DESCRIBE `ports` 0.0014572143554688
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '218') 0.00041699409484863
(558) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66566') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.020776033401489
(559) DESCRIBE `avid_specials` 0.0018560886383057
(560) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66566 and class = 'Cruise') OR (item_id = 341 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 26 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.0019099712371826
(561) DESCRIBE `cruiselines` 0.001723051071167
(562) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00038313865661621
(563) DESCRIBE `orchid_image` 0.0020370483398438
(564) DESCRIBE `cruiselines` 0.0028848648071289
(565) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.011821985244751
(566) DESCRIBE `ships` 0.0089418888092041
(567) SELECT `ships`.* FROM `ships` WHERE (id IN ('349', '1135', '406', '542', '678', '1021', '434', '105', '253', '451', '341', '348', '580', '1409', '98', '290', '291')) ORDER BY FIND_IN_SET(id, '349,1135,406,542,678,1021,434,105,253,451,341,348,580,1409,98,290,291') 0.0017931461334229
(568) DESCRIBE `cruisetypes` 0.001384973526001
(569) DESCRIBE `destinations` 0.0018959045410156
(570) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '35', '43', '53', '8', '48', '34', '22', '29', '37', '40', '11', '38', '21', '26', '28', '30')) ORDER BY FIND_IN_SET(id, '12,35,43,53,8,48,34,22,29,37,40,11,38,21,26,28,30') 0.0015709400177002
(571) DESCRIBE `cruiselines` 0.0078420639038086
(572) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00048089027404785
(573) DESCRIBE `cruiselines` 0.011184930801392
(574) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00059199333190918