or, enquire about your chosen options

  1. Catch up on Cruising: Latest news in bite size
  2. Catch up on Cruising: Latest news in bite size
  3. Family Cruising – Have you considered it ?
  4. New Azamara Ship to arrive in March 2018
  5. Enhanced amenities for Oceania Cruises

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

 
  • Legend, Short Cruise ex Sydney Return

    Nights 3 Ship Carnival Legend
    Star Rating 4 Star Departs Sydney, NSW, Australia
    Sailing 2017: 3 Nov
    Ports of Call Sydney

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

     
    Carnival 5th Birthday - 5 Years of Fun Sale Fantastic rates, up to $400 On Board Credit per cabin and a bottle of bubbles. Available on selected sailings between 03 November 2017 and 31 December 2018
  • Spirit, Melbourne Cup ex Sydney Return

    Nights 6 Ship Carnival Spirit
    Star Rating 4 Star Departs Sydney, NSW, Australia
    Sailing 2017: 5 Nov 2018: 4 Nov
    Ports of Call Sydney, Melbourne

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

     
    Carnival 5th Birthday - 5 Years of Fun Sale Fantastic rates, up to $400 On Board Credit per cabin and a bottle of bubbles. Available on selected sailings between 03 November 2017 and 31 December 2018
  • Legend, Pacific Islands Cruise ex Sydney Roundtrip

    Nights 8 Ship Carnival Legend
    Star Rating 4 Star Departs Sydney, NSW, Australia
    Sailing 2017: 6 Nov 2018: 9 Dec
    Ports of Call Sydney, Noumea, Mare Island, Isle of Pines

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

     
    Carnival 5th Birthday - 5 Years of Fun Sale Fantastic rates, up to $400 On Board Credit per cabin and a bottle of bubbles. Available on selected sailings between 03 November 2017 and 31 December 2018
  • Spirit, Pacific Islands Cruise ex Sydney Return1

    Nights 12 Ship Carnival Spirit
    Star Rating 4 Star Departs Sydney, NSW, Australia
    Sailing 2017: 11 Nov
    Ports of Call Sydney, Noumea, Port Denarau (Nadi), Suva Fiji, Mystery Island, Isle of Pines

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

     
    Carnival 5th Birthday - 5 Years of Fun Sale Fantastic rates, up to $400 On Board Credit per cabin and a bottle of bubbles. Available on selected sailings between 03 November 2017 and 31 December 2018
  • Legend, Pacific Islands Cruise ex Sydney Return

    Nights 8 Ship Carnival Legend
    Star Rating 4 Star Departs Sydney, NSW, Australia
    Sailing 2017: 14 Nov
    Ports of Call Sydney, Isle of Pines, Lifou, Noumea

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

     
    Carnival 5th Birthday - 5 Years of Fun Sale Fantastic rates, up to $400 On Board Credit per cabin and a bottle of bubbles. Available on selected sailings between 03 November 2017 and 31 December 2018
  • Legend, Tasmania Cruise ex Sydney Return

    Nights 5 Ship Carnival Legend
    Star Rating 4 Star Departs Sydney, NSW, Australia
    Sailing 2017: 22 Nov
    Ports of Call Sydney, Hobart, Port Arthur

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

     
    Carnival 5th Birthday - 5 Years of Fun Sale Fantastic rates, up to $400 On Board Credit per cabin and a bottle of bubbles. Available on selected sailings between 03 November 2017 and 31 December 2018
  • Spirit, Pacific Islands Cruise ex Sydney Roundtrip

    Nights 9 Ship Carnival Spirit
    Star Rating 4 Star Departs Sydney, NSW, Australia
    Sailing 2017: 23 Nov
    Ports of Call Sydney, Noumea, Mare Island, Lifou, Isle of Pines

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

     
    Carnival 5th Birthday - 5 Years of Fun Sale Fantastic rates, up to $400 On Board Credit per cabin and a bottle of bubbles. Available on selected sailings between 03 November 2017 and 31 December 2018
  • Legend, Pacific Islands Cruise ex Sydney Return

    Nights 9 Ship Carnival Legend
    Star Rating 4 Star Departs Sydney, NSW, Australia
    Sailing 2017: 27 Nov 2018: 15 Jan, 30 Nov
    Ports of Call Sydney, Isle of Pines, Mare Island, Lifou, Noumea

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

     
    Carnival 5th Birthday - 5 Years of Fun Sale Fantastic rates, up to $400 On Board Credit per cabin and a bottle of bubbles. Available on selected sailings between 03 November 2017 and 31 December 2018
  • Spirit, Pacific Islands Cruise ex Sydney Return

    Nights 8 Ship Carnival Spirit
    Star Rating 4 Star Departs Sydney, NSW, Australia
    Sailing 2017: 2 Dec 2018: 17 Mar, 13 Apr, 21 Apr, 30 Aug, 29 Nov
    Ports of Call Sydney, Noumea, Mare Island, Isle of Pines

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

     
    Carnival 5th Birthday - 5 Years of Fun Sale Fantastic rates, up to $400 On Board Credit per cabin and a bottle of bubbles. Available on selected sailings between 03 November 2017 and 31 December 2018
  • Legend, Pacific Islands Cruise ex Sydney Roundtrip

    Nights 10 Ship Carnival Legend
    Star Rating 4 Star Departs Sydney, NSW, Australia
    Sailing 2017: 6 Dec
    Ports of Call Sydney, Lifou, Mystery Island, Mare Island, Noumea

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

     
    Carnival 5th Birthday - 5 Years of Fun Sale Fantastic rates, up to $400 On Board Credit per cabin and a bottle of bubbles. Available on selected sailings between 03 November 2017 and 31 December 2018
 

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

Total elapsed time: 0.33443760871887

# Query Time
(1) connect 0.00054597854614258
(2) DESCRIBE `cruises` 0.00193190574646
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (50908, 50866, 52884, 55704, 56045, 53461, 50864, 46218, 41776, 46216)) ORDER BY FIND_IN_SET(id, '50908,50866,52884,55704,56045,53461,50864,46218,41776,46216') 0.0011019706726074
(4) DESCRIBE `cruises` 0.0017669200897217
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50908') 0.00028586387634277
(6) DESCRIBE `ships` 0.0013821125030518
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00028610229492188
(8) DESCRIBE `ships` 0.0013599395751953
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00024080276489258
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017309188842773
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016498565673828
(12) DESCRIBE `itineraries` 0.00073504447937012
(13) DESCRIBE `ports` 0.00081300735473633
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025105476379395
(15) DESCRIBE `ports` 0.00070095062255859
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020408630371094
(17) DESCRIBE `ports` 0.00072002410888672
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00020694732666016
(19) DESCRIBE `sailingdates` 0.00063014030456543
(20) DESCRIBE `ports` 0.00074505805969238
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026798248291016
(22) DESCRIBE `ports` 0.00072503089904785
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019598007202148
(24) DESCRIBE `ports` 0.00066995620727539
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021004676818848
(26) DESCRIBE `ports` 0.00071287155151367
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018692016601562
(28) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '50908') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0044779777526855
(29) DESCRIBE `avid_specials` 0.00084090232849121
(30) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 50908 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.0014619827270508
(31) DESCRIBE `cruiselines` 0.0010719299316406
(32) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00025296211242676
(33) DESCRIBE `orchid_image` 0.00083208084106445
(34) DESCRIBE `cruiselines` 0.00096416473388672
(35) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00021696090698242
(36) DESCRIBE `cruises` 0.0013508796691895
(37) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50866') 0.00023102760314941
(38) DESCRIBE `ships` 0.0012879371643066
(39) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00028586387634277
(40) DESCRIBE `ships` 0.001533031463623
(41) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0002291202545166
(42) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017309188842773
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018000602722168
(44) DESCRIBE `itineraries` 0.00092911720275879
(45) DESCRIBE `ports` 0.00073695182800293
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022411346435547
(47) DESCRIBE `ports` 0.00066399574279785
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00019001960754395
(49) DESCRIBE `ports` 0.00066280364990234
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017905235290527
(51) DESCRIBE `sailingdates` 0.00069904327392578
(52) DESCRIBE `ports` 0.00072407722473145
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021100044250488
(54) DESCRIBE `ports` 0.00066590309143066
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00020384788513184
(56) DESCRIBE `ports` 0.00069904327392578
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00021004676818848
(58) DESCRIBE `ports` 0.00066113471984863
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00022792816162109
(60) DESCRIBE `ports` 0.00088381767272949
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00020694732666016
(62) DESCRIBE `ports` 0.0007328987121582
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00018095970153809
(64) DESCRIBE `ports` 0.00076913833618164
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0002288818359375
(66) DESCRIBE `ports` 0.00068902969360352
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00017499923706055
(68) DESCRIBE `ports` 0.00065803527832031
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022196769714355
(70) DESCRIBE `ports` 0.00069499015808105
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018095970153809
(72) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '50866') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0046319961547852
(73) DESCRIBE `avid_specials` 0.0008080005645752
(74) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 50866 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0011188983917236
(75) DESCRIBE `cruiselines` 0.001262903213501
(76) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00025606155395508
(77) DESCRIBE `orchid_image` 0.00083088874816895
(78) DESCRIBE `cruiselines` 0.00098180770874023
(79) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00019502639770508
(80) DESCRIBE `cruises` 0.0013260841369629
(81) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52884') 0.00022411346435547
(82) DESCRIBE `ships` 0.0017549991607666
(83) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00031590461730957
(84) DESCRIBE `ships` 0.0017960071563721
(85) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00020909309387207
(86) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018000602722168
(87) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017881393432617
(88) DESCRIBE `itineraries` 0.00071215629577637
(89) DESCRIBE `ports` 0.0010230541229248
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031685829162598
(91) DESCRIBE `ports` 0.00094389915466309
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028085708618164
(93) DESCRIBE `ports` 0.00096511840820312
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00024700164794922
(95) DESCRIBE `sailingdates` 0.00088691711425781
(96) DESCRIBE `ports` 0.0010199546813965
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029683113098145
(98) DESCRIBE `ports` 0.0010108947753906
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025010108947754
(100) DESCRIBE `ports` 0.0010099411010742
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00027799606323242
(102) DESCRIBE `ports` 0.0010178089141846
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00024199485778809
(104) DESCRIBE `ports` 0.0010099411010742
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00026178359985352
(106) DESCRIBE `ports` 0.0010199546813965
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00024318695068359
(108) DESCRIBE `ports` 0.0010511875152588
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00026798248291016
(110) DESCRIBE `ports` 0.0009760856628418
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00023412704467773
(112) DESCRIBE `ports` 0.0010309219360352
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027203559875488
(114) DESCRIBE `ports` 0.0010190010070801
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002899169921875
(116) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '52884') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0081100463867188
(117) DESCRIBE `avid_specials` 0.0011770725250244
(118) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 52884 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.0021979808807373
(119) DESCRIBE `cruiselines` 0.0016269683837891
(120) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00034904479980469
(121) DESCRIBE `orchid_image` 0.0011811256408691
(122) DESCRIBE `cruiselines` 0.001453161239624
(123) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00030207633972168
(124) DESCRIBE `cruises` 0.0020568370819092
(125) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55704') 0.00033187866210938
(126) DESCRIBE `ships` 0.0021588802337646
(127) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00045585632324219
(128) DESCRIBE `ships` 0.0022540092468262
(129) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0002748966217041
(130) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023603439331055
(131) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022315979003906
(132) DESCRIBE `itineraries` 0.0010700225830078
(133) DESCRIBE `ports` 0.0010929107666016
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031399726867676
(135) DESCRIBE `ports` 0.0010521411895752
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029277801513672
(137) DESCRIBE `ports` 0.0010948181152344
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025796890258789
(139) DESCRIBE `sailingdates` 0.00091290473937988
(140) DESCRIBE `ports` 0.001107931137085
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031590461730957
(142) DESCRIBE `ports` 0.0010669231414795
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025820732116699
(144) DESCRIBE `ports` 0.0010418891906738
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00028395652770996
(146) DESCRIBE `ports` 0.0010571479797363
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0002439022064209
(148) DESCRIBE `ports` 0.0010330677032471
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00028395652770996
(150) DESCRIBE `ports` 0.0010490417480469
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00025200843811035
(152) DESCRIBE `ports` 0.0010490417480469
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00030016899108887
(154) DESCRIBE `ports` 0.0010340213775635
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00025606155395508
(156) DESCRIBE `ports` 0.0010979175567627
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00029182434082031
(158) DESCRIBE `ports` 0.0010371208190918
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00026488304138184
(160) DESCRIBE `ports` 0.0010349750518799
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00029587745666504
(162) DESCRIBE `ports` 0.0010862350463867
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00025105476379395
(164) DESCRIBE `ports` 0.0010359287261963
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029611587524414
(166) DESCRIBE `ports` 0.0010950565338135
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027799606323242
(168) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '55704') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0080630779266357
(169) DESCRIBE `avid_specials` 0.0011930465698242
(170) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55704 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0021650791168213
(171) DESCRIBE `cruiselines` 0.001561164855957
(172) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00034499168395996
(173) DESCRIBE `orchid_image` 0.001154899597168
(174) DESCRIBE `cruiselines` 0.0014901161193848
(175) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00028204917907715
(176) DESCRIBE `cruises` 0.002061128616333
(177) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56045') 0.00034785270690918
(178) DESCRIBE `ships` 0.0021219253540039
(179) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00037193298339844
(180) DESCRIBE `ships` 0.0021209716796875
(181) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00024890899658203
(182) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.000244140625
(183) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025391578674316
(184) DESCRIBE `itineraries` 0.0010020732879639
(185) DESCRIBE `ports` 0.0010738372802734
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030517578125
(187) DESCRIBE `ports` 0.0010120868682861
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029897689819336
(189) DESCRIBE `ports` 0.0010690689086914
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026392936706543
(191) DESCRIBE `sailingdates` 0.00089716911315918
(192) DESCRIBE `ports` 0.0010099411010742
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029206275939941
(194) DESCRIBE `ports` 0.0010170936584473
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023913383483887
(196) DESCRIBE `ports` 0.0010709762573242
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00036501884460449
(198) DESCRIBE `ports` 0.00085592269897461
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00018501281738281
(200) DESCRIBE `ports` 0.00069093704223633
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00022411346435547
(202) DESCRIBE `ports` 0.00071001052856445
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00018310546875
(204) DESCRIBE `ports` 0.00068092346191406
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00021815299987793
(206) DESCRIBE `ports` 0.00072789192199707
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00019216537475586
(208) DESCRIBE `ports` 0.00083303451538086
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002140998840332
(210) DESCRIBE `ports` 0.0007321834564209
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019502639770508
(212) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '56045') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0043690204620361
(213) DESCRIBE `avid_specials` 0.00080513954162598
(214) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56045 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.001147985458374
(215) DESCRIBE `cruiselines` 0.0010440349578857
(216) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00024294853210449
(217) DESCRIBE `orchid_image` 0.00079894065856934
(218) DESCRIBE `cruiselines` 0.0010111331939697
(219) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0002140998840332
(220) DESCRIBE `cruises` 0.0014030933380127
(221) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '53461') 0.00022697448730469
(222) DESCRIBE `ships` 0.0013179779052734
(223) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00031900405883789
(224) DESCRIBE `ships` 0.001554012298584
(225) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00026702880859375
(226) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017905235290527
(227) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020217895507812
(228) DESCRIBE `itineraries` 0.00074505805969238
(229) DESCRIBE `ports` 0.00069403648376465
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024986267089844
(231) DESCRIBE `ports` 0.00073003768920898
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020194053649902
(233) DESCRIBE `ports` 0.00069785118103027
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00021195411682129
(235) DESCRIBE `sailingdates` 0.00061202049255371
(236) DESCRIBE `ports` 0.00069499015808105
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022006034851074
(238) DESCRIBE `ports` 0.00068092346191406
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017905235290527
(240) DESCRIBE `ports` 0.00074410438537598
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00020503997802734
(242) DESCRIBE `ports` 0.00072598457336426
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00017690658569336
(244) DESCRIBE `ports` 0.00067400932312012
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00023102760314941
(246) DESCRIBE `ports` 0.00067591667175293
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00018095970153809
(248) DESCRIBE `ports` 0.00067400932312012
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020098686218262
(250) DESCRIBE `ports` 0.00066995620727539
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019192695617676
(252) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '53461') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0043468475341797
(253) DESCRIBE `avid_specials` 0.0007328987121582
(254) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 53461 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.0011680126190186
(255) DESCRIBE `cruiselines` 0.0010061264038086
(256) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00022792816162109
(257) DESCRIBE `orchid_image` 0.00076079368591309
(258) DESCRIBE `cruiselines` 0.00094914436340332
(259) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00021100044250488
(260) DESCRIBE `cruises` 0.0013308525085449
(261) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50864') 0.00022292137145996
(262) DESCRIBE `ships` 0.0013020038604736
(263) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00028300285339355
(264) DESCRIBE `ships` 0.0013968944549561
(265) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00020718574523926
(266) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017595291137695
(267) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016593933105469
(268) DESCRIBE `itineraries` 0.00066089630126953
(269) DESCRIBE `ports` 0.00071406364440918
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022602081298828
(271) DESCRIBE `ports` 0.00067400932312012
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024294853210449
(273) DESCRIBE `ports` 0.00067901611328125
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018787384033203
(275) DESCRIBE `sailingdates` 0.00060081481933594
(276) DESCRIBE `ports` 0.001086950302124
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004580020904541
(278) DESCRIBE `ports` 0.00091099739074707
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019311904907227
(280) DESCRIBE `ports` 0.00073385238647461
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00022792816162109
(282) DESCRIBE `ports` 0.00070309638977051
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00018405914306641
(284) DESCRIBE `ports` 0.00068283081054688
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00020599365234375
(286) DESCRIBE `ports` 0.00070309638977051
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00017499923706055
(288) DESCRIBE `ports` 0.00076699256896973
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00039887428283691
(290) DESCRIBE `ports` 0.00083398818969727
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00019407272338867
(292) DESCRIBE `ports` 0.00075697898864746
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00022602081298828
(294) DESCRIBE `ports` 0.00076079368591309
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00017809867858887
(296) DESCRIBE `ports` 0.00072503089904785
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027203559875488
(298) DESCRIBE `ports` 0.00077295303344727
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018978118896484
(300) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '50864') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0044348239898682
(301) DESCRIBE `avid_specials` 0.0007779598236084
(302) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 50864 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011279582977295
(303) DESCRIBE `cruiselines` 0.00098180770874023
(304) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00023198127746582
(305) DESCRIBE `orchid_image` 0.00075292587280273
(306) DESCRIBE `cruiselines` 0.00094914436340332
(307) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00018715858459473
(308) DESCRIBE `cruises` 0.0014979839324951
(309) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '46218') 0.0002281665802002
(310) DESCRIBE `ships` 0.0015029907226562
(311) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00028586387634277
(312) DESCRIBE `ships` 0.0015091896057129
(313) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00022101402282715
(314) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018191337585449
(315) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018692016601562
(316) DESCRIBE `itineraries` 0.00079894065856934
(317) DESCRIBE `ports` 0.00079011917114258
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024199485778809
(319) DESCRIBE `ports` 0.00076389312744141
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023221969604492
(321) DESCRIBE `ports` 0.00077486038208008
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022101402282715
(323) DESCRIBE `sailingdates` 0.00070905685424805
(324) DESCRIBE `ports` 0.00082492828369141
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029897689819336
(326) DESCRIBE `ports` 0.00082302093505859
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00020313262939453
(328) DESCRIBE `ports` 0.00077605247497559
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00022101402282715
(330) DESCRIBE `ports` 0.0007939338684082
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00020098686218262
(332) DESCRIBE `ports` 0.00078392028808594
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00022506713867188
(334) DESCRIBE `ports` 0.00079512596130371
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00019693374633789
(336) DESCRIBE `ports` 0.00078201293945312
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00023388862609863
(338) DESCRIBE `ports` 0.00075602531433105
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00019097328186035
(340) DESCRIBE `ports` 0.00068902969360352
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0001988410949707
(342) DESCRIBE `ports` 0.00068306922912598
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00017714500427246
(344) DESCRIBE `ports` 0.00068902969360352
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002131462097168
(346) DESCRIBE `ports` 0.00075101852416992
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019478797912598
(348) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '46218') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0044159889221191
(349) DESCRIBE `avid_specials` 0.00079512596130371
(350) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 46218 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.0011348724365234
(351) DESCRIBE `cruiselines` 0.0010120868682861
(352) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00025486946105957
(353) DESCRIBE `orchid_image` 0.00077509880065918
(354) DESCRIBE `cruiselines` 0.00094985961914062
(355) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00026392936706543
(356) DESCRIBE `cruises` 0.0013308525085449
(357) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41776') 0.00020599365234375
(358) DESCRIBE `ships` 0.00130295753479
(359) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00026702880859375
(360) DESCRIBE `ships` 0.0012810230255127
(361) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00019407272338867
(362) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017905235290527
(363) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017619132995605
(364) DESCRIBE `itineraries` 0.00067305564880371
(365) DESCRIBE `ports` 0.00088691711425781
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024199485778809
(367) DESCRIBE `ports` 0.00070595741271973
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020217895507812
(369) DESCRIBE `ports` 0.00068092346191406
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018882751464844
(371) DESCRIBE `sailingdates` 0.00065803527832031
(372) DESCRIBE `ports` 0.00078487396240234
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022697448730469
(374) DESCRIBE `ports` 0.000701904296875
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018787384033203
(376) DESCRIBE `ports` 0.00073003768920898
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00020909309387207
(378) DESCRIBE `ports` 0.00066900253295898
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00017499923706055
(380) DESCRIBE `ports` 0.00066208839416504
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00019097328186035
(382) DESCRIBE `ports` 0.00067901611328125
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00020098686218262
(384) DESCRIBE `ports` 0.00067996978759766
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00020885467529297
(386) DESCRIBE `ports` 0.00070786476135254
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00017285346984863
(388) DESCRIBE `ports` 0.00067591667175293
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020813941955566
(390) DESCRIBE `ports` 0.00067019462585449
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018310546875
(392) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '41776') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0042650699615479
(393) DESCRIBE `avid_specials` 0.00068211555480957
(394) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41776 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0013058185577393
(395) DESCRIBE `cruiselines` 0.00099706649780273
(396) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00022792816162109
(397) DESCRIBE `orchid_image` 0.00088191032409668
(398) DESCRIBE `cruiselines` 0.00096392631530762
(399) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00019693374633789
(400) DESCRIBE `cruises` 0.0015161037445068
(401) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '46216') 0.00025296211242676
(402) DESCRIBE `ships` 0.0014381408691406
(403) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00028419494628906
(404) DESCRIBE `ships` 0.0013799667358398
(405) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00019979476928711
(406) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001988410949707
(407) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017619132995605
(408) DESCRIBE `itineraries` 0.00071096420288086
(409) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '46216') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00055098533630371
(410) DESCRIBE `ports` 0.00069904327392578
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021791458129883
(412) DESCRIBE `ports` 0.00068092346191406
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022292137145996
(414) DESCRIBE `ports` 0.00067806243896484
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018596649169922
(416) DESCRIBE `sailingdates` 0.00059604644775391
(417) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '46216') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00036382675170898
(418) DESCRIBE `ports` 0.00070595741271973
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021004676818848
(420) DESCRIBE `ports` 0.0007178783416748
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0001838207244873
(422) DESCRIBE `ports` 0.00067806243896484
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00020503997802734
(424) DESCRIBE `ports` 0.00066494941711426
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00023293495178223
(426) DESCRIBE `ports` 0.00069212913513184
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.0001981258392334
(428) DESCRIBE `ports` 0.00070881843566895
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00017809867858887
(430) DESCRIBE `ports` 0.00066900253295898
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0001990795135498
(432) DESCRIBE `ports` 0.00067400932312012
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00017213821411133
(434) DESCRIBE `ports` 0.00068402290344238
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00022697448730469
(436) DESCRIBE `ports` 0.00067281723022461
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00023293495178223
(438) DESCRIBE `ports` 0.00091004371643066
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031089782714844
(440) DESCRIBE `ports` 0.00079989433288574
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018405914306641
(442) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '46216') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0044090747833252
(443) DESCRIBE `avid_specials` 0.00071001052856445
(444) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 46216 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.001194953918457
(445) DESCRIBE `cruiselines` 0.0010340213775635
(446) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0002291202545166
(447) DESCRIBE `orchid_image` 0.00079798698425293
(448) DESCRIBE `cruiselines` 0.0010101795196533
(449) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00021100044250488
(450) DESCRIBE `ships` 0.0018501281738281
(451) SELECT `ships`.* FROM `ships` WHERE (id IN ('4', '288')) ORDER BY FIND_IN_SET(id, '4,288') 0.00040912628173828
(452) DESCRIBE `cruisetypes` 0.0006108283996582
(453) DESCRIBE `destinations` 0.0011980533599854
(454) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8', '35')) ORDER BY FIND_IN_SET(id, '43,8,35') 0.00054788589477539
(455) DESCRIBE `cruiselines` 0.0014069080352783
(456) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00024986267089844
(457) DESCRIBE `cruiselines` 0.0010318756103516
(458) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00025010108947754