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

Total elapsed time: 0.71993327140808

# Query Time
(1) connect 0.00078201293945312
(2) DESCRIBE `cruises` 0.0016899108886719
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (47487, 58848, 60175, 60176, 58849, 68492, 58850, 68493, 74977, 58851)) ORDER BY FIND_IN_SET(id, '47487,58848,60175,60176,58849,68492,58850,68493,74977,58851') 0.001305103302002
(4) DESCRIBE `cruises` 0.0014150142669678
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '47487') 0.00022792816162109
(6) DESCRIBE `ships` 0.0011370182037354
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00024294853210449
(8) DESCRIBE `ships` 0.0011639595031738
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00016593933105469
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001530647277832
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00014281272888184
(12) DESCRIBE `itineraries` 0.00062108039855957
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '47487') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00053906440734863
(14) DESCRIBE `ports` 0.00070905685424805
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00021505355834961
(16) DESCRIBE `ports` 0.00058984756469727
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00016903877258301
(18) DESCRIBE `ports` 0.00058579444885254
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00015997886657715
(20) DESCRIBE `sailingdates` 0.00054812431335449
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '47487') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00050115585327148
(22) DESCRIBE `ports` 0.00061607360839844
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00017809867858887
(24) DESCRIBE `ports` 0.00058794021606445
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00016212463378906
(26) DESCRIBE `ports` 0.00059795379638672
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1878))) 0.00018095970153809
(28) DESCRIBE `ports` 0.0005958080291748
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1878') 0.00015401840209961
(30) DESCRIBE `ports` 0.00058794021606445
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00017881393432617
(32) DESCRIBE `ports` 0.00061798095703125
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00019502639770508
(34) DESCRIBE `ports` 0.0006709098815918
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00017905235290527
(36) DESCRIBE `ports` 0.00058698654174805
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00015401840209961
(38) DESCRIBE `ports` 0.00067710876464844
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00017309188842773
(40) DESCRIBE `ports` 0.00058388710021973
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00016212463378906
(42) DESCRIBE `ports` 0.00060892105102539
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00017213821411133
(44) DESCRIBE `ports` 0.00062108039855957
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00018906593322754
(46) DESCRIBE `ports` 0.00068306922912598
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00018906593322754
(48) DESCRIBE `ports` 0.00068402290344238
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00015997886657715
(50) DESCRIBE `ports` 0.00060486793518066
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00017309188842773
(52) DESCRIBE `ports` 0.00058197975158691
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00015401840209961
(54) DESCRIBE `ports` 0.00066304206848145
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00017499923706055
(56) DESCRIBE `ports` 0.00066304206848145
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00016307830810547
(58) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '47487') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0045340061187744
(59) DESCRIBE `avid_specials` 0.00077319145202637
(60) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 47487 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 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.00091004371643066
(61) DESCRIBE `cruiselines` 0.0009157657623291
(62) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00021791458129883
(63) DESCRIBE `orchid_image` 0.00067806243896484
(64) DESCRIBE `cruiselines` 0.0011370182037354
(65) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00023007392883301
(66) DESCRIBE `cruises` 0.0015950202941895
(67) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58848') 0.00027704238891602
(68) DESCRIBE `ships` 0.0018279552459717
(69) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00031685829162598
(70) DESCRIBE `ships` 0.0017390251159668
(71) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.00024580955505371
(72) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00020313262939453
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018906593322754
(74) DESCRIBE `itineraries` 0.00079202651977539
(75) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '58848') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00062799453735352
(76) DESCRIBE `ports` 0.0009150505065918
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00026297569274902
(78) DESCRIBE `ports` 0.00077915191650391
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00017619132995605
(80) DESCRIBE `ports` 0.00079584121704102
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00020790100097656
(82) DESCRIBE `sailingdates` 0.0005340576171875
(83) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '58848') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00046896934509277
(84) DESCRIBE `ports` 0.000640869140625
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00018906593322754
(86) DESCRIBE `ports` 0.00058102607727051
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00015902519226074
(88) DESCRIBE `ports` 0.00057888031005859
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00017213821411133
(90) DESCRIBE `ports` 0.00058197975158691
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00017595291137695
(92) DESCRIBE `ports` 0.0006411075592041
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00018095970153809
(94) DESCRIBE `ports` 0.00058484077453613
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.0001530647277832
(96) DESCRIBE `ports` 0.00059890747070312
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 609))) 0.00017595291137695
(98) DESCRIBE `ports` 0.00057411193847656
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '609') 0.0001680850982666
(100) DESCRIBE `ports` 0.000640869140625
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 429))) 0.00017213821411133
(102) DESCRIBE `ports` 0.000579833984375
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '429') 0.0001680850982666
(104) DESCRIBE `ports` 0.0006248950958252
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00017309188842773
(106) DESCRIBE `ports` 0.0005950927734375
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00016999244689941
(108) DESCRIBE `ports` 0.00058197975158691
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 711))) 0.00017809867858887
(110) DESCRIBE `ports` 0.00063180923461914
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '711') 0.0001678466796875
(112) DESCRIBE `ports` 0.00057792663574219
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00019693374633789
(114) DESCRIBE `ports` 0.00058794021606445
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00015401840209961
(116) DESCRIBE `ports` 0.00060701370239258
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 204))) 0.00017285346984863
(118) DESCRIBE `ports` 0.00057411193847656
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '204') 0.00017189979553223
(120) DESCRIBE `ports` 0.00057721138000488
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 205))) 0.0001978874206543
(122) DESCRIBE `ports` 0.00062704086303711
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '205') 0.00015616416931152
(124) DESCRIBE `ports` 0.00060296058654785
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 533))) 0.00017094612121582
(126) DESCRIBE `ports` 0.00057888031005859
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '533') 0.00015377998352051
(128) DESCRIBE `ports` 0.00057506561279297
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00016999244689941
(130) DESCRIBE `ports` 0.00057792663574219
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0001528263092041
(132) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '58848') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0045919418334961
(133) DESCRIBE `avid_specials` 0.00085616111755371
(134) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 58848 and class = 'Cruise') OR (item_id = 616 AND class = 'Ship') OR (item_id = 151 AND class = 'CruiseLine') OR (item_id = 45 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.00088214874267578
(135) DESCRIBE `cruiselines` 0.00090909004211426
(136) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00022506713867188
(137) DESCRIBE `orchid_image` 0.00067687034606934
(138) DESCRIBE `cruiselines` 0.00083208084106445
(139) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00017499923706055
(140) DESCRIBE `cruises` 0.0016000270843506
(141) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60175') 0.00025105476379395
(142) DESCRIBE `ships` 0.0013720989227295
(143) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00025296211242676
(144) DESCRIBE `ships` 0.001262903213501
(145) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00018191337585449
(146) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017690658569336
(147) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001990795135498
(148) DESCRIBE `itineraries` 0.00066494941711426
(149) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '60175') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00053501129150391
(150) DESCRIBE `ports` 0.000701904296875
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00023198127746582
(152) DESCRIBE `ports` 0.00069618225097656
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00019598007202148
(154) DESCRIBE `ports` 0.00068902969360352
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018191337585449
(156) DESCRIBE `sailingdates` 0.00060510635375977
(157) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '60175') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00046801567077637
(158) DESCRIBE `ports` 0.0007169246673584
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00021004676818848
(160) DESCRIBE `ports` 0.00070786476135254
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018811225891113
(162) DESCRIBE `ports` 0.00066494941711426
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 698))) 0.00020098686218262
(164) DESCRIBE `ports` 0.00067615509033203
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '698') 0.0001828670501709
(166) DESCRIBE `ports` 0.00066900253295898
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00020480155944824
(168) DESCRIBE `ports` 0.00066304206848145
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00017881393432617
(170) DESCRIBE `ports` 0.00066900253295898
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00020098686218262
(172) DESCRIBE `ports` 0.00066900253295898
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00018000602722168
(174) DESCRIBE `ports` 0.00069499015808105
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 579))) 0.0001981258392334
(176) DESCRIBE `ports` 0.000762939453125
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '579') 0.00018405914306641
(178) DESCRIBE `ports` 0.00066518783569336
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00020098686218262
(180) DESCRIBE `ports` 0.00068497657775879
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00018596649169922
(182) DESCRIBE `ports` 0.00067591667175293
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0001978874206543
(184) DESCRIBE `ports` 0.000701904296875
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00018000602722168
(186) DESCRIBE `ports` 0.00066399574279785
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020408630371094
(188) DESCRIBE `ports` 0.00067496299743652
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018095970153809
(190) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '60175') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0052001476287842
(191) DESCRIBE `avid_specials` 0.00082206726074219
(192) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60175 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 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.00092816352844238
(193) DESCRIBE `cruiselines` 0.00099086761474609
(194) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00021886825561523
(195) DESCRIBE `orchid_image` 0.000762939453125
(196) DESCRIBE `cruiselines` 0.00098705291748047
(197) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00022292137145996
(198) DESCRIBE `cruises` 0.0012710094451904
(199) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60176') 0.00020790100097656
(200) DESCRIBE `ships` 0.001384973526001
(201) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00023794174194336
(202) DESCRIBE `ships` 0.0013089179992676
(203) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00017786026000977
(204) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018095970153809
(205) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001990795135498
(206) DESCRIBE `itineraries` 0.00074601173400879
(207) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '60176') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00037598609924316
(208) DESCRIBE `ports` 0.00074291229248047
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021100044250488
(210) DESCRIBE `ports` 0.0006859302520752
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00022482872009277
(212) DESCRIBE `ports` 0.00070500373840332
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00021600723266602
(214) DESCRIBE `sailingdates` 0.00060892105102539
(215) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '60176') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00037598609924316
(216) DESCRIBE `ports` 0.00071501731872559
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020003318786621
(218) DESCRIBE `ports` 0.0007319450378418
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018191337585449
(220) DESCRIBE `ports` 0.00071001052856445
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1252))) 0.00020718574523926
(222) DESCRIBE `ports` 0.00068092346191406
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1252') 0.00018119812011719
(224) DESCRIBE `ports` 0.00066590309143066
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.0001990795135498
(226) DESCRIBE `ports` 0.0006868839263916
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00017905235290527
(228) DESCRIBE `ports` 0.00067496299743652
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00023984909057617
(230) DESCRIBE `ports` 0.00066399574279785
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00018310546875
(232) DESCRIBE `ports` 0.00070309638977051
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1213))) 0.00019979476928711
(234) DESCRIBE `ports` 0.00068306922912598
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1213') 0.00018095970153809
(236) DESCRIBE `ports` 0.00066280364990234
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00019693374633789
(238) DESCRIBE `ports` 0.00067305564880371
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00019288063049316
(240) DESCRIBE `ports` 0.00066399574279785
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.0001978874206543
(242) DESCRIBE `ports` 0.00070095062255859
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00017905235290527
(244) DESCRIBE `ports` 0.00066113471984863
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00020694732666016
(246) DESCRIBE `ports` 0.00066089630126953
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00018000602722168
(248) DESCRIBE `ports` 0.00070714950561523
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00019717216491699
(250) DESCRIBE `ports` 0.00068402290344238
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018191337585449
(252) DESCRIBE `ports` 0.00066399574279785
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00019693374633789
(254) DESCRIBE `ports` 0.00072407722473145
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018095970153809
(256) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '60176') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0059800148010254
(257) DESCRIBE `avid_specials` 0.00089597702026367
(258) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60176 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 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.00096607208251953
(259) DESCRIBE `cruiselines` 0.00098395347595215
(260) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00022220611572266
(261) DESCRIBE `orchid_image` 0.0007481575012207
(262) DESCRIBE `cruiselines` 0.0013070106506348
(263) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00019502639770508
(264) DESCRIBE `cruises` 0.0013940334320068
(265) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58849') 0.00020694732666016
(266) DESCRIBE `ships` 0.001568078994751
(267) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00027585029602051
(268) DESCRIBE `ships` 0.00130295753479
(269) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.00025296211242676
(270) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018501281738281
(271) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017499923706055
(272) DESCRIBE `itineraries` 0.00068902969360352
(273) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '58849') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0004429817199707
(274) DESCRIBE `ports` 0.00085806846618652
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00028109550476074
(276) DESCRIBE `ports` 0.00072002410888672
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00023078918457031
(278) DESCRIBE `ports` 0.00067710876464844
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00019001960754395
(280) DESCRIBE `sailingdates` 0.00072002410888672
(281) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '58849') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00040912628173828
(282) DESCRIBE `ports` 0.00068402290344238
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020909309387207
(284) DESCRIBE `ports` 0.00084710121154785
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00018501281738281
(286) DESCRIBE `ports` 0.00072288513183594
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00026202201843262
(288) DESCRIBE `ports` 0.00093483924865723
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00023102760314941
(290) DESCRIBE `ports` 0.00081801414489746
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.00020408630371094
(292) DESCRIBE `ports` 0.00067496299743652
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.00018000602722168
(294) DESCRIBE `ports` 0.00066113471984863
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2501))) 0.00020480155944824
(296) DESCRIBE `ports` 0.00070500373840332
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2501') 0.00018692016601562
(298) DESCRIBE `ports` 0.00067305564880371
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00020003318786621
(300) DESCRIBE `ports` 0.00066304206848145
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00018119812011719
(302) DESCRIBE `ports` 0.00067496299743652
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00022411346435547
(304) DESCRIBE `ports` 0.00066900253295898
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00018215179443359
(306) DESCRIBE `ports` 0.00066018104553223
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1252))) 0.00023388862609863
(308) DESCRIBE `ports` 0.00066208839416504
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1252') 0.00018692016601562
(310) DESCRIBE `ports` 0.00065994262695312
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020217895507812
(312) DESCRIBE `ports` 0.00068211555480957
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018906593322754
(314) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '58849') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.004971981048584
(315) DESCRIBE `avid_specials` 0.00076794624328613
(316) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 58849 and class = 'Cruise') OR (item_id = 616 AND class = 'Ship') OR (item_id = 151 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.00096392631530762
(317) DESCRIBE `cruiselines` 0.00098490715026855
(318) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00022602081298828
(319) DESCRIBE `orchid_image` 0.00075006484985352
(320) DESCRIBE `cruiselines` 0.00092411041259766
(321) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00019407272338867
(322) DESCRIBE `cruises` 0.0014278888702393
(323) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68492') 0.00023388862609863
(324) DESCRIBE `ships` 0.0012989044189453
(325) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00025391578674316
(326) DESCRIBE `ships` 0.0012481212615967
(327) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00018811225891113
(328) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017809867858887
(329) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016880035400391
(330) DESCRIBE `itineraries` 0.00073599815368652
(331) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68492') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00086688995361328
(332) DESCRIBE `ports` 0.0011579990386963
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0002739429473877
(334) DESCRIBE `ports` 0.00072407722473145
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031805038452148
(336) DESCRIBE `ports` 0.00083613395690918
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00021195411682129
(338) DESCRIBE `sailingdates` 0.00061702728271484
(339) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68492') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0006108283996582
(340) DESCRIBE `ports` 0.00076508522033691
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0002281665802002
(342) DESCRIBE `ports` 0.00073814392089844
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00019288063049316
(344) DESCRIBE `ports` 0.000701904296875
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021100044250488
(346) DESCRIBE `ports` 0.00067806243896484
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018811225891113
(348) DESCRIBE `ports` 0.00069785118103027
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00022411346435547
(350) DESCRIBE `ports` 0.00072598457336426
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00019311904907227
(352) DESCRIBE `ports` 0.00076818466186523
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00022721290588379
(354) DESCRIBE `ports` 0.00079512596130371
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00021100044250488
(356) DESCRIBE `ports` 0.0006861686706543
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1709))) 0.00021696090698242
(358) DESCRIBE `ports` 0.00068402290344238
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1709') 0.00018906593322754
(360) DESCRIBE `ports` 0.00072693824768066
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00021505355834961
(362) DESCRIBE `ports` 0.00067996978759766
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.0002138614654541
(364) DESCRIBE `ports` 0.00075197219848633
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00023102760314941
(366) DESCRIBE `ports` 0.00068092346191406
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00018787384033203
(368) DESCRIBE `ports` 0.00076484680175781
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00020790100097656
(370) DESCRIBE `ports` 0.00073385238647461
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.00018715858459473
(372) DESCRIBE `ports` 0.00068116188049316
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00020289421081543
(374) DESCRIBE `ports` 0.00067520141601562
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.00033211708068848
(376) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68492') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0077049732208252
(377) DESCRIBE `avid_specials` 0.0011191368103027
(378) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68492 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 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.0013201236724854
(379) DESCRIBE `cruiselines` 0.0013790130615234
(380) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00031709671020508
(381) DESCRIBE `orchid_image` 0.0010569095611572
(382) DESCRIBE `cruiselines` 0.001629114151001
(383) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00031399726867676
(384) DESCRIBE `cruises` 0.0022640228271484
(385) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58850') 0.00034499168395996
(386) DESCRIBE `ships` 0.0022041797637939
(387) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00041294097900391
(388) DESCRIBE `ships` 0.0021481513977051
(389) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.00040292739868164
(390) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033307075500488
(391) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029087066650391
(392) DESCRIBE `itineraries` 0.0011608600616455
(393) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '58850') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00035405158996582
(394) DESCRIBE `ports` 0.00059890747070312
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00019288063049316
(396) DESCRIBE `ports` 0.00058603286743164
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00018811225891113
(398) DESCRIBE `ports` 0.0005800724029541
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00016880035400391
(400) DESCRIBE `sailingdates` 0.00057888031005859
(401) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '58850') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00031018257141113
(402) DESCRIBE `ports` 0.00061798095703125
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00017809867858887
(404) DESCRIBE `ports` 0.00059294700622559
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00016307830810547
(406) DESCRIBE `ports` 0.00058889389038086
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00017690658569336
(408) DESCRIBE `ports` 0.00066685676574707
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00016093254089355
(410) DESCRIBE `ports` 0.0006568431854248
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00017809867858887
(412) DESCRIBE `ports` 0.00058794021606445
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00016117095947266
(414) DESCRIBE `ports` 0.00073599815368652
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00018095970153809
(416) DESCRIBE `ports` 0.00058984756469727
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00016403198242188
(418) DESCRIBE `ports` 0.00064682960510254
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00023388862609863
(420) DESCRIBE `ports` 0.00067806243896484
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00018501281738281
(422) DESCRIBE `ports` 0.00066804885864258
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00020217895507812
(424) DESCRIBE `ports` 0.00066804885864258
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00018501281738281
(426) DESCRIBE `ports` 0.0006871223449707
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00025606155395508
(428) DESCRIBE `ports` 0.00070309638977051
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00019097328186035
(430) DESCRIBE `ports` 0.00076794624328613
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00024604797363281
(432) DESCRIBE `ports` 0.00067615509033203
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018405914306641
(434) DESCRIBE `ports` 0.00066995620727539
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0001988410949707
(436) DESCRIBE `ports` 0.0006711483001709
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018095970153809
(438) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '58850') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0051219463348389
(439) DESCRIBE `avid_specials` 0.00064206123352051
(440) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 58850 and class = 'Cruise') OR (item_id = 616 AND class = 'Ship') OR (item_id = 151 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.00095391273498535
(441) DESCRIBE `cruiselines` 0.00097489356994629
(442) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00022506713867188
(443) DESCRIBE `orchid_image` 0.00073504447937012
(444) DESCRIBE `cruiselines` 0.00091099739074707
(445) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00017714500427246
(446) DESCRIBE `cruises` 0.001270055770874
(447) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68493') 0.00019407272338867
(448) DESCRIBE `ships` 0.0012791156768799
(449) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00024104118347168
(450) DESCRIBE `ships` 0.0012428760528564
(451) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00018906593322754
(452) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017499923706055
(453) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016593933105469
(454) DESCRIBE `itineraries` 0.00065112113952637
(455) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68493') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00046396255493164
(456) DESCRIBE `ports` 0.00069499015808105
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00020217895507812
(458) DESCRIBE `ports` 0.0038518905639648
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00020813941955566
(460) DESCRIBE `ports` 0.00067782402038574
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.00018477439880371
(462) DESCRIBE `sailingdates` 0.00060486793518066
(463) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68493') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00038909912109375
(464) DESCRIBE `ports` 0.00081205368041992
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00019192695617676
(466) DESCRIBE `ports` 0.00069093704223633
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.00017786026000977
(468) DESCRIBE `ports` 0.00074005126953125
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 579))) 0.00021696090698242
(470) DESCRIBE `ports` 0.00066900253295898
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '579') 0.00017690658569336
(472) DESCRIBE `ports` 0.00069999694824219
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1709))) 0.00021100044250488
(474) DESCRIBE `ports` 0.00066995620727539
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1709') 0.00018882751464844
(476) DESCRIBE `ports` 0.00069618225097656
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.0001978874206543
(478) DESCRIBE `ports` 0.00066804885864258
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00018906593322754
(480) DESCRIBE `ports` 0.00084114074707031
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00019383430480957
(482) DESCRIBE `ports` 0.00065994262695312
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00018811225891113
(484) DESCRIBE `ports` 0.00066184997558594
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00023508071899414
(486) DESCRIBE `ports` 0.00066184997558594
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.00019192695617676
(488) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68493') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0051019191741943
(489) DESCRIBE `avid_specials` 0.000762939453125
(490) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68493 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 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.00094294548034668
(491) DESCRIBE `cruiselines` 0.0040848255157471
(492) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00024914741516113
(493) DESCRIBE `orchid_image` 0.00075602531433105
(494) DESCRIBE `cruiselines` 0.00091981887817383
(495) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00018906593322754
(496) DESCRIBE `cruises` 0.0012731552124023
(497) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74977') 0.00023412704467773
(498) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74977') 0.00018000602722168
(499) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id != '74977') 0.24813795089722
(500) UPDATE `cruises` SET `orchid_slug` = ? WHERE (id = '74977') 0.012939929962158
(501) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id != '74977') 0.039723873138428
(502) UPDATE `cruises` SET `orchid_slug` = ? WHERE (id = '74977') 0.0011560916900635
(503) DESCRIBE `ships` 0.0018432140350342
(504) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00054502487182617
(505) DESCRIBE `ships` 0.0021028518676758
(506) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.0002601146697998
(507) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027799606323242
(508) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00021910667419434
(509) DESCRIBE `itineraries` 0.00098109245300293
(510) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74977') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00064492225646973
(511) DESCRIBE `ports` 0.0011639595031738
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00027108192443848
(513) DESCRIBE `ports` 0.00068783760070801
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00021195411682129
(515) DESCRIBE `ports` 0.00067901611328125
(516) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.0001988410949707
(517) DESCRIBE `sailingdates` 0.00060915946960449
(518) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74977') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00066590309143066
(519) DESCRIBE `ports` 0.00078010559082031
(520) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00023007392883301
(521) DESCRIBE `ports` 0.0007169246673584
(522) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.00019288063049316
(523) DESCRIBE `ports` 0.00093603134155273
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00022602081298828
(525) DESCRIBE `ports` 0.00076484680175781
(526) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00024795532226562
(527) DESCRIBE `ports` 0.00095987319946289
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 703))) 0.00021219253540039
(529) DESCRIBE `ports` 0.00070905685424805
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '703') 0.00018906593322754
(531) DESCRIBE `ports` 0.00071096420288086
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 703))) 0.00020408630371094
(533) DESCRIBE `ports` 0.00067520141601562
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '703') 0.00019693374633789
(535) DESCRIBE `ports` 0.00067996978759766
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00020599365234375
(537) DESCRIBE `ports` 0.00072002410888672
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00018596649169922
(539) DESCRIBE `ports` 0.0006721019744873
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020384788513184
(541) DESCRIBE `ports` 0.0006721019744873
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018501281738281
(543) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '74977') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0049049854278564
(544) DESCRIBE `avid_specials` 0.00063991546630859
(545) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74977 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 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.0011599063873291
(546) DESCRIBE `cruiselines` 0.00099802017211914
(547) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00023102760314941
(548) DESCRIBE `orchid_image` 0.0007469654083252
(549) DESCRIBE `cruiselines` 0.00096988677978516
(550) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00018811225891113
(551) DESCRIBE `cruises` 0.0019919872283936
(552) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58851') 0.0002901554107666
(553) DESCRIBE `ships` 0.0014059543609619
(554) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00032711029052734
(555) DESCRIBE `ships` 0.0013048648834229
(556) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.00023293495178223
(557) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018787384033203
(558) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019192695617676
(559) DESCRIBE `itineraries` 0.00082612037658691
(560) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '58851') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00054717063903809
(561) DESCRIBE `ports` 0.00091409683227539
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00026607513427734
(563) DESCRIBE `ports` 0.00088310241699219
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020909309387207
(565) DESCRIBE `ports` 0.00070691108703613
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00019693374633789
(567) DESCRIBE `sailingdates` 0.00088095664978027
(568) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '58851') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00042986869812012
(569) DESCRIBE `ports` 0.00072193145751953
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00028395652770996
(571) DESCRIBE `ports` 0.00069403648376465
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00024604797363281
(573) DESCRIBE `ports` 0.00084304809570312
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4794))) 0.00022196769714355
(575) DESCRIBE `ports` 0.00073695182800293
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4794') 0.00019502639770508
(577) DESCRIBE `ports` 0.00067591667175293
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00026798248291016
(579) DESCRIBE `ports` 0.0010390281677246
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00025415420532227
(581) DESCRIBE `ports` 0.00096893310546875
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 532))) 0.00020980834960938
(583) DESCRIBE `ports` 0.0007479190826416
(584) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '532') 0.00018501281738281
(585) DESCRIBE `ports` 0.00067687034606934
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1493))) 0.00020909309387207
(587) DESCRIBE `ports` 0.00067281723022461
(588) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1493') 0.00020098686218262
(589) DESCRIBE `ports` 0.00068807601928711
(590) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00020289421081543
(591) DESCRIBE `ports` 0.00088787078857422
(592) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00018692016601562
(593) DESCRIBE `ports` 0.00071811676025391
(594) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00023603439331055
(595) DESCRIBE `ports` 0.00068902969360352
(596) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00022006034851074
(597) DESCRIBE `ports` 0.00076603889465332
(598) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1878))) 0.00020313262939453
(599) DESCRIBE `ports` 0.00078105926513672
(600) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1878') 0.00018501281738281
(601) DESCRIBE `ports` 0.00069117546081543
(602) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.0002288818359375
(603) DESCRIBE `ports` 0.00080609321594238
(604) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00043487548828125
(605) DESCRIBE `ports` 0.0012421607971191
(606) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00029516220092773
(607) DESCRIBE `ports` 0.00071001052856445
(608) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00019502639770508
(609) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '58851') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0052440166473389
(610) DESCRIBE `avid_specials` 0.00090408325195312
(611) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 58851 and class = 'Cruise') OR (item_id = 616 AND class = 'Ship') OR (item_id = 151 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.0010111331939697
(612) DESCRIBE `cruiselines` 0.0010650157928467
(613) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00023484230041504
(614) DESCRIBE `orchid_image` 0.00075912475585938
(615) DESCRIBE `cruiselines` 0.00095701217651367
(616) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00020194053649902
(617) DESCRIBE `ships` 0.0016000270843506
(618) SELECT `ships`.* FROM `ships` WHERE (id IN ('652', '616', '1672')) ORDER BY FIND_IN_SET(id, '652,616,1672') 0.00042295455932617
(619) DESCRIBE `cruisetypes` 0.00058698654174805
(620) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '151') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.029741048812866
(621) DESCRIBE `destinations` 0.0016648769378662
(622) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '26', '28', '45', '21', '25', '49')) ORDER BY FIND_IN_SET(id, '22,26,28,45,21,25,49') 0.00076484680175781
(623) DESCRIBE `cruiselines` 0.0017390251159668
(624) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00037002563476562
(625) DESCRIBE `cruiselines` 0.0015809535980225
(626) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00037193298339844