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

 
  • Quest, Iberian Adventure Voyage ex Lisbon to Barcelona

    Nights 8 Ship Azamara Quest
    Star Rating 5 Star Departs Lisbon, Portugal
    Sailing 2018: 20 Apr
    Ports of Call Lisbon, Portimao, Cadiz, Gibraltar, Malaga, Valencia, Barcelona

    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.

     
    Azamara's Luxury Inclusions • House beer, wines and spirits • Prepaid gratuities • Gourmet cuisine • Friendly and attentive service • Concierge for onboard and onshore reservations • Luxury accommodation • Shuttles to and from some ports • An AzAmazing Evening shore excursion (included on most voyages)
     
    Plan a Cruise Month Special: Azamara Club Cruises Take advantage of Azamara's Enjoy More Sale plus bonus onboard credit for Plan a Cruise Month! Book one of 34 selected Europe 2018 cruises and receive a FREE double upgrade from Interior to Verandah plus a bonus US$100 onboard credit! Terms and conditions apply. Contact us for details.
  • Journey, Oman, Luxor & Israel ex Dubai to Athens

    Nights 17 Ship Azamara Journey
    Star Rating 5 Star Departs Dubai, United Arab Emirates
    Sailing 2018: 26 Apr
    Ports of Call Dubai, Muscat, Salalah, Safaga (Luxor), Aqaba, Sharm el-Sheikh, Suez Canal, Ashdod (Jerusalem), Haifa, Limassol, Athens (Piraeus) Greece

    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.

     
    Azamara's Luxury Inclusions • House beer, wines and spirits • Prepaid gratuities • Gourmet cuisine • Friendly and attentive service • Concierge for onboard and onshore reservations • Luxury accommodation • Shuttles to and from some ports • An AzAmazing Evening shore excursion (included on most voyages)
     
    Plan a Cruise Month Special: Azamara Club Cruises Take advantage of Azamara's Enjoy More Sale plus bonus onboard credit for Plan a Cruise Month! Book one of 34 selected Europe 2018 cruises and receive a FREE double upgrade from Interior to Verandah plus a bonus US$100 onboard credit! Terms and conditions apply. Contact us for details.
  • Quest, Mediterranean Springtime Voyage ex Barcelona to Rome

    Nights 7 Ship Azamara Quest
    Star Rating 5 Star Departs Barcelona, Spain
    Sailing 2018: 28 Apr
    Ports of Call Barcelona, Sete, Marseilles, Monte Carlo, Santa Margherita, Livorno, Rome (Civitavecchia)
    Please enquire about this cruise for pricing.
     
    Azamara's Luxury Inclusions • House beer, wines and spirits • Prepaid gratuities • Gourmet cuisine • Friendly and attentive service • Concierge for onboard and onshore reservations • Luxury accommodation • Shuttles to and from some ports • An AzAmazing Evening shore excursion (included on most voyages)
     
    Plan a Cruise Month Special: Azamara Club Cruises Take advantage of Azamara's Enjoy More Sale plus bonus onboard credit for Plan a Cruise Month! Book one of 34 selected Europe 2018 cruises and receive a FREE double upgrade from Interior to Verandah plus a bonus US$100 onboard credit! Terms and conditions apply. Contact us for details.
  • Quest,Classix Grand Prix & Med Voyage ex Rome to Barcelona

    Nights 10 Ship Azamara Quest
    Star Rating 5 Star Departs Rome (Civitavecchia), Italy
    Sailing 2018: 5 May
    Ports of Call Rome (Civitavecchia), Amalfi, Taormina, Valletta, Olbia, Ajaccio, Monte Carlo, Barcelona

    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.

     
    Azamara's Luxury Inclusions • House beer, wines and spirits • Prepaid gratuities • Gourmet cuisine • Friendly and attentive service • Concierge for onboard and onshore reservations • Luxury accommodation • Shuttles to and from some ports • An AzAmazing Evening shore excursion (included on most voyages)
     
    Plan a Cruise Month Special: Azamara Club Cruises Take advantage of Azamara's Enjoy More Sale plus bonus onboard credit for Plan a Cruise Month! Book one of 34 selected Europe 2018 cruises and receive a FREE double upgrade from Interior to Verandah plus a bonus US$100 onboard credit! Terms and conditions apply. Contact us for details.
  • Greek Isles to Italy - Cruise Sale

    Receive a free upgrade & an onboard credit

    Nights 8 Ship Azamara Journey
    Star Rating 5 Star Departs Athens (Piraeus) Greece
    Sailing 2018: 13 May
    Ports of Call Athens (Piraeus) Greece, Mykonos, Kusadasi, Lindos, Santorini, Taormina, Amalfi, Rome (Civitavecchia)
    Special! Priced from NZ $5989 p.p.
     
    Azamara's Luxury Inclusions • House beer, wines and spirits • Prepaid gratuities • Gourmet cuisine • Friendly and attentive service • Concierge for onboard and onshore reservations • Luxury accommodation • Shuttles to and from some ports • An AzAmazing Evening shore excursion (included on most voyages)
     
    Plan a Cruise Month Special: Azamara Club Cruises Take advantage of Azamara's Enjoy More Sale plus bonus onboard credit for Plan a Cruise Month! Book one of 34 selected Europe 2018 cruises and receive a FREE double upgrade from Interior to Verandah plus a bonus US$100 onboard credit! Terms and conditions apply. Contact us for details.
  • Journey, Greek Isles to Italy ex Athens to Rome

    Nights 8 Ship Azamara Journey
    Star Rating 5 Star Departs Athens (Piraeus) Greece
    Sailing 2018: 13 May
    Ports of Call Athens (Piraeus) Greece, Mykonos, Kusadasi, Lindos, Santorini, Taormina, Amalfi, Rome (Civitavecchia)

    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.

     
    Azamara's Luxury Inclusions • House beer, wines and spirits • Prepaid gratuities • Gourmet cuisine • Friendly and attentive service • Concierge for onboard and onshore reservations • Luxury accommodation • Shuttles to and from some ports • An AzAmazing Evening shore excursion (included on most voyages)
     
    Plan a Cruise Month Special: Azamara Club Cruises Take advantage of Azamara's Enjoy More Sale plus bonus onboard credit for Plan a Cruise Month! Book one of 34 selected Europe 2018 cruises and receive a FREE double upgrade from Interior to Verandah plus a bonus US$100 onboard credit! Terms and conditions apply. Contact us for details.
  • Quest, Mediterranean Classics Voyage ex Barcelona to Nice

    Nights 9 Ship Azamara Quest
    Star Rating 5 Star Departs Barcelona, Spain
    Sailing 2018: 15 May
    Ports of Call Barcelona, Rome (Civitavecchia), Livorno, St Tropez, Cannes, Monte Carlo, Nice

    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.

     
    Azamara's Luxury Inclusions • House beer, wines and spirits • Prepaid gratuities • Gourmet cuisine • Friendly and attentive service • Concierge for onboard and onshore reservations • Luxury accommodation • Shuttles to and from some ports • An AzAmazing Evening shore excursion (included on most voyages)
     
    Plan a Cruise Month Special: Azamara Club Cruises Take advantage of Azamara's Enjoy More Sale plus bonus onboard credit for Plan a Cruise Month! Book one of 34 selected Europe 2018 cruises and receive a FREE double upgrade from Interior to Verandah plus a bonus US$100 onboard credit! Terms and conditions apply. Contact us for details.
  • Journey, Grand Prix & Cannes ex Rome to Barcelona

    Nights 8 Ship Azamara Journey
    Star Rating 5 Star Departs Rome (Civitavecchia), Italy
    Sailing 2018: 21 May
    Ports of Call Rome (Civitavecchia), Livorno, Cannes, Ajaccio, Monte Carlo, Barcelona

    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.

     
    Azamara's Luxury Inclusions • House beer, wines and spirits • Prepaid gratuities • Gourmet cuisine • Friendly and attentive service • Concierge for onboard and onshore reservations • Luxury accommodation • Shuttles to and from some ports • An AzAmazing Evening shore excursion (included on most voyages)
     
    Plan a Cruise Month Special: Azamara Club Cruises Take advantage of Azamara's Enjoy More Sale plus bonus onboard credit for Plan a Cruise Month! Book one of 34 selected Europe 2018 cruises and receive a FREE double upgrade from Interior to Verandah plus a bonus US$100 onboard credit! Terms and conditions apply. Contact us for details.
  • Quest, Grand Prix Weekend Voyage ex Nice Return

    Nights 4 Ship Azamara Quest
    Star Rating 5 Star Departs Nice, France
    Sailing 2018: 24 May
    Ports of Call Nice, Santa Margherita, St Tropez, Monte Carlo

    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.

     
    Azamara's Luxury Inclusions • House beer, wines and spirits • Prepaid gratuities • Gourmet cuisine • Friendly and attentive service • Concierge for onboard and onshore reservations • Luxury accommodation • Shuttles to and from some ports • An AzAmazing Evening shore excursion (included on most voyages)
     
    Plan a Cruise Month Special: Azamara Club Cruises Take advantage of Azamara's Enjoy More Sale plus bonus onboard credit for Plan a Cruise Month! Book one of 34 selected Europe 2018 cruises and receive a FREE double upgrade from Interior to Verandah plus a bonus US$100 onboard credit! Terms and conditions apply. Contact us for details.
  • Journey, Tapas, Wine & Golf ex Barcelona to Lisbon

    Nights 9 Ship Azamara Journey
    Star Rating 5 Star Departs Barcelona, Spain
    Sailing 2018: 29 May
    Ports of Call Barcelona, Alcudia, Valencia, Alicante, Cartagena, Gibraltar, Seville, Portimao, Lisbon

    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.

     
    Azamara's Luxury Inclusions • House beer, wines and spirits • Prepaid gratuities • Gourmet cuisine • Friendly and attentive service • Concierge for onboard and onshore reservations • Luxury accommodation • Shuttles to and from some ports • An AzAmazing Evening shore excursion (included on most voyages)
     
    Plan a Cruise Month Special: Azamara Club Cruises Take advantage of Azamara's Enjoy More Sale plus bonus onboard credit for Plan a Cruise Month! Book one of 34 selected Europe 2018 cruises and receive a FREE double upgrade from Interior to Verandah plus a bonus US$100 onboard credit! Terms and conditions apply. Contact us for details.
 

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

Total elapsed time: 0.40311861038208

# Query Time
(1) connect 0.000640869140625
(2) DESCRIBE `cruises` 0.0021040439605713
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (47487, 58848, 60175, 60176, 58849, 58849, 68492, 58850, 68493, 58851)) ORDER BY FIND_IN_SET(id, '47487,58848,60175,60176,58849,58849,68492,58850,68493,58851') 0.0017321109771729
(4) DESCRIBE `cruises` 0.0018208026885986
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '47487') 0.00029492378234863
(6) DESCRIBE `ships` 0.0014040470123291
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00026416778564453
(8) DESCRIBE `ships` 0.0015830993652344
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00020813941955566
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00021815299987793
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001680850982666
(12) DESCRIBE `itineraries` 0.00084090232849121
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '47487') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00054407119750977
(14) DESCRIBE `ports` 0.001032829284668
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00024318695068359
(16) DESCRIBE `ports` 0.0011801719665527
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00029802322387695
(18) DESCRIBE `ports` 0.00098991394042969
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00025391578674316
(20) DESCRIBE `sailingdates` 0.00088405609130859
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '47487') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00058293342590332
(22) DESCRIBE `ports` 0.0010571479797363
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00028491020202637
(24) DESCRIBE `ports` 0.00071001052856445
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00020003318786621
(26) DESCRIBE `ports` 0.00067687034606934
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1878))) 0.00021505355834961
(28) DESCRIBE `ports` 0.00071597099304199
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1878') 0.00018811225891113
(30) DESCRIBE `ports` 0.0006721019744873
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00021004676818848
(32) DESCRIBE `ports` 0.00067687034606934
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00018906593322754
(34) DESCRIBE `ports` 0.00075411796569824
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00021100044250488
(36) DESCRIBE `ports` 0.00070905685424805
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00019478797912598
(38) DESCRIBE `ports` 0.00067305564880371
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00020813941955566
(40) DESCRIBE `ports` 0.00071001052856445
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00021100044250488
(42) DESCRIBE `ports` 0.00069499015808105
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00022602081298828
(44) DESCRIBE `ports` 0.0006861686706543
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00019407272338867
(46) DESCRIBE `ports` 0.00069093704223633
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00020599365234375
(48) DESCRIBE `ports` 0.00068092346191406
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.0001838207244873
(50) DESCRIBE `ports` 0.00074005126953125
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020313262939453
(52) DESCRIBE `ports` 0.00066995620727539
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018310546875
(54) DESCRIBE `ports` 0.00066614151000977
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00025010108947754
(56) DESCRIBE `ports` 0.00066995620727539
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018310546875
(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.0043361186981201
(59) DESCRIBE `avid_specials` 0.00079584121704102
(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.0011589527130127
(61) DESCRIBE `cruiselines` 0.0010218620300293
(62) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00029110908508301
(63) DESCRIBE `orchid_image` 0.0009310245513916
(64) DESCRIBE `cruiselines` 0.0010719299316406
(65) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00024509429931641
(66) DESCRIBE `cruises` 0.0015189647674561
(67) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58848') 0.00027990341186523
(68) DESCRIBE `ships` 0.0017290115356445
(69) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00032997131347656
(70) DESCRIBE `ships` 0.0016758441925049
(71) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.00027990341186523
(72) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017595291137695
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001671314239502
(74) DESCRIBE `itineraries` 0.00075888633728027
(75) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '58848') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00060391426086426
(76) DESCRIBE `ports` 0.00077915191650391
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00022697448730469
(78) DESCRIBE `ports` 0.00067806243896484
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00019502639770508
(80) DESCRIBE `ports` 0.00073385238647461
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00019598007202148
(82) DESCRIBE `sailingdates` 0.00059413909912109
(83) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '58848') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00052285194396973
(84) DESCRIBE `ports` 0.00074100494384766
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00022101402282715
(86) DESCRIBE `ports` 0.00068211555480957
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00018906593322754
(88) DESCRIBE `ports` 0.00070905685424805
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00020813941955566
(90) DESCRIBE `ports` 0.00067615509033203
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00018405914306641
(92) DESCRIBE `ports` 0.00067400932312012
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00021791458129883
(94) DESCRIBE `ports` 0.00074005126953125
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00019407272338867
(96) DESCRIBE `ports` 0.00073981285095215
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 609))) 0.00020885467529297
(98) DESCRIBE `ports` 0.00066590309143066
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '609') 0.00018692016601562
(100) DESCRIBE `ports` 0.00066804885864258
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 429))) 0.00020313262939453
(102) DESCRIBE `ports` 0.00068187713623047
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '429') 0.00018715858459473
(104) DESCRIBE `ports` 0.00072193145751953
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00020098686218262
(106) DESCRIBE `ports` 0.0007781982421875
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00018906593322754
(108) DESCRIBE `ports` 0.00066804885864258
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 711))) 0.00020694732666016
(110) DESCRIBE `ports` 0.00067996978759766
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '711') 0.00018596649169922
(112) DESCRIBE `ports` 0.00068402290344238
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.0001978874206543
(114) DESCRIBE `ports` 0.00069403648376465
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00023317337036133
(116) DESCRIBE `ports` 0.0007021427154541
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 204))) 0.00020599365234375
(118) DESCRIBE `ports` 0.00067305564880371
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '204') 0.00018477439880371
(120) DESCRIBE `ports` 0.00066995620727539
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 205))) 0.00020313262939453
(122) DESCRIBE `ports` 0.00076198577880859
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '205') 0.00022697448730469
(124) DESCRIBE `ports` 0.00093388557434082
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 533))) 0.00021600723266602
(126) DESCRIBE `ports` 0.00067996978759766
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '533') 0.00020217895507812
(128) DESCRIBE `ports` 0.00067400932312012
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0002439022064209
(130) DESCRIBE `ports` 0.00076198577880859
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00041699409484863
(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.0068988800048828
(133) DESCRIBE `avid_specials` 0.00087285041809082
(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.0011758804321289
(135) DESCRIBE `cruiselines` 0.0010499954223633
(136) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00025010108947754
(137) DESCRIBE `orchid_image` 0.00092911720275879
(138) DESCRIBE `cruiselines` 0.00097298622131348
(139) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.0002281665802002
(140) DESCRIBE `cruises` 0.0014081001281738
(141) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60175') 0.00035881996154785
(142) DESCRIBE `ships` 0.0012838840484619
(143) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00025391578674316
(144) DESCRIBE `ships` 0.0013401508331299
(145) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00025391578674316
(146) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001838207244873
(147) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017285346984863
(148) DESCRIBE `itineraries` 0.00084686279296875
(149) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '60175') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00054502487182617
(150) DESCRIBE `ports` 0.00072383880615234
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00022387504577637
(152) DESCRIBE `ports` 0.00067520141601562
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00019502639770508
(154) DESCRIBE `ports` 0.00071501731872559
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00019097328186035
(156) DESCRIBE `sailingdates` 0.00067996978759766
(157) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '60175') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00043106079101562
(158) DESCRIBE `ports` 0.00073885917663574
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00021195411682129
(160) DESCRIBE `ports` 0.00066804885864258
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018787384033203
(162) DESCRIBE `ports` 0.00070810317993164
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 698))) 0.00020694732666016
(164) DESCRIBE `ports` 0.00068497657775879
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '698') 0.00018596649169922
(166) DESCRIBE `ports` 0.00069999694824219
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00020694732666016
(168) DESCRIBE `ports` 0.00072193145751953
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00021505355834961
(170) DESCRIBE `ports` 0.00074505805969238
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00022292137145996
(172) DESCRIBE `ports` 0.00075912475585938
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00018095970153809
(174) DESCRIBE `ports` 0.00066399574279785
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 579))) 0.00024890899658203
(176) DESCRIBE `ports` 0.00088596343994141
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '579') 0.00024008750915527
(178) DESCRIBE `ports` 0.0009148120880127
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0002140998840332
(180) DESCRIBE `ports` 0.00070786476135254
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00022196769714355
(182) DESCRIBE `ports` 0.00067806243896484
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0002129077911377
(184) DESCRIBE `ports` 0.00068783760070801
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00018095970153809
(186) DESCRIBE `ports` 0.00068402290344238
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00019598007202148
(188) DESCRIBE `ports` 0.00066208839416504
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00017595291137695
(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.0043799877166748
(191) DESCRIBE `avid_specials` 0.00081300735473633
(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.0011210441589355
(193) DESCRIBE `cruiselines` 0.0010049343109131
(194) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00027084350585938
(195) DESCRIBE `orchid_image` 0.00075817108154297
(196) DESCRIBE `cruiselines` 0.00094389915466309
(197) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00021600723266602
(198) DESCRIBE `cruises` 0.0013430118560791
(199) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60176') 0.00023603439331055
(200) DESCRIBE `ships` 0.0013928413391113
(201) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00027799606323242
(202) DESCRIBE `ships` 0.001309871673584
(203) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00021004676818848
(204) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018000602722168
(205) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016903877258301
(206) DESCRIBE `itineraries` 0.00073003768920898
(207) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '60176') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00049901008605957
(208) DESCRIBE `ports` 0.00083303451538086
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0003209114074707
(210) DESCRIBE `ports` 0.00085186958312988
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021219253540039
(212) DESCRIBE `ports` 0.00068306922912598
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018882751464844
(214) DESCRIBE `sailingdates` 0.00060892105102539
(215) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '60176') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00045299530029297
(216) DESCRIBE `ports` 0.00077915191650391
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00023889541625977
(218) DESCRIBE `ports` 0.0007319450378418
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018715858459473
(220) DESCRIBE `ports` 0.00069093704223633
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1252))) 0.0001990795135498
(222) DESCRIBE `ports` 0.00067496299743652
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1252') 0.00017809867858887
(224) DESCRIBE `ports` 0.00067901611328125
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00020503997802734
(226) DESCRIBE `ports` 0.00094985961914062
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00024604797363281
(228) DESCRIBE `ports` 0.00091195106506348
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00026106834411621
(230) DESCRIBE `ports` 0.00096893310546875
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00026917457580566
(232) DESCRIBE `ports` 0.00086092948913574
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1213))) 0.00022101402282715
(234) DESCRIBE `ports` 0.00077605247497559
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1213') 0.00025296211242676
(236) DESCRIBE `ports` 0.0009148120880127
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00027918815612793
(238) DESCRIBE `ports` 0.001060962677002
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00025105476379395
(240) DESCRIBE `ports` 0.0010080337524414
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00033092498779297
(242) DESCRIBE `ports` 0.00098896026611328
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00020885467529297
(244) DESCRIBE `ports` 0.00074601173400879
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00021600723266602
(246) DESCRIBE `ports` 0.00087809562683105
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00019502639770508
(248) DESCRIBE `ports` 0.00081610679626465
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00029611587524414
(250) DESCRIBE `ports` 0.00073504447937012
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00023794174194336
(252) DESCRIBE `ports` 0.00072622299194336
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0002138614654541
(254) DESCRIBE `ports` 0.00081396102905273
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00020599365234375
(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.0048649311065674
(257) DESCRIBE `avid_specials` 0.00089287757873535
(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.0013740062713623
(259) DESCRIBE `cruiselines` 0.0015201568603516
(260) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00034189224243164
(261) DESCRIBE `orchid_image` 0.0011999607086182
(262) DESCRIBE `cruiselines` 0.0015320777893066
(263) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.0002892017364502
(264) DESCRIBE `specials` 0.0028231143951416
(265) SELECT `specials`.* FROM `specials` WHERE (id = '1359124') AND (specials.orchid_available = 1) LIMIT 1 0.00061202049255371
(266) DESCRIBE `specials` 0.0021908283233643
(267) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1359124') 0.00027298927307129
(268) DESCRIBE `ships` 0.001410961151123
(269) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00026798248291016
(270) DESCRIBE `ships` 0.0013401508331299
(271) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.00021505355834961
(272) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018692016601562
(273) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001680850982666
(274) DESCRIBE `itineraries` 0.0007169246673584
(275) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '58849') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00046586990356445
(276) DESCRIBE `ports` 0.00084304809570312
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00023603439331055
(278) DESCRIBE `ports` 0.00070786476135254
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020790100097656
(280) DESCRIBE `ports` 0.00068807601928711
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00021004676818848
(282) DESCRIBE `specialsailingdates` 0.00058603286743164
(283) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1359124') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00049591064453125
(284) DESCRIBE `sailingdates` 0.00064802169799805
(285) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369960))) 0.00019502639770508
(286) DESCRIBE `ports` 0.00070810317993164
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00021004676818848
(288) DESCRIBE `ports` 0.00074601173400879
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00021004676818848
(290) DESCRIBE `ports` 0.00073599815368652
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00021696090698242
(292) DESCRIBE `ports` 0.0006859302520752
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.0001990795135498
(294) DESCRIBE `ports` 0.00068092346191406
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.00022578239440918
(296) DESCRIBE `ports` 0.00071001052856445
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.00018000602722168
(298) DESCRIBE `ports` 0.00069713592529297
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2501))) 0.00020384788513184
(300) DESCRIBE `ports` 0.00084209442138672
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2501') 0.00019192695617676
(302) DESCRIBE `ports` 0.00081706047058105
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.0002291202545166
(304) DESCRIBE `ports` 0.00071287155151367
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00019192695617676
(306) DESCRIBE `ports` 0.00068783760070801
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00022006034851074
(308) DESCRIBE `ports` 0.00069093704223633
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00018787384033203
(310) DESCRIBE `ports` 0.00070285797119141
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1252))) 0.000244140625
(312) DESCRIBE `ports` 0.00071406364440918
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1252') 0.00018906593322754
(314) DESCRIBE `ports` 0.00067782402038574
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020885467529297
(316) DESCRIBE `ports` 0.00070595741271973
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018692016601562
(318) DESCRIBE `cruises` 0.0013020038604736
(319) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 58849))) 0.00034713745117188
(320) DESCRIBE `avid_specials` 0.00065302848815918
(321) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1359124 and class = 'Special') OR (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.0010900497436523
(322) DESCRIBE `cruiselines` 0.0010149478912354
(323) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00023698806762695
(324) DESCRIBE `orchid_image` 0.00075888633728027
(325) DESCRIBE `cruiselines` 0.00094890594482422
(326) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00019407272338867
(327) DESCRIBE `cruises` 0.0012960433959961
(328) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58849') 0.00026988983154297
(329) DESCRIBE `ships` 0.0019710063934326
(330) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00030708312988281
(331) DESCRIBE `ships` 0.0014469623565674
(332) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.0002439022064209
(333) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00021195411682129
(334) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018692016601562
(335) DESCRIBE `itineraries` 0.00085902214050293
(336) DESCRIBE `ports` 0.00087094306945801
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00026988983154297
(338) DESCRIBE `ports` 0.00079679489135742
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00021100044250488
(340) DESCRIBE `ports` 0.00074505805969238
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00024795532226562
(342) DESCRIBE `sailingdates` 0.00071907043457031
(343) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '58849') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0006868839263916
(344) DESCRIBE `ports` 0.0010221004486084
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00025010108947754
(346) DESCRIBE `ports` 0.00070309638977051
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00019502639770508
(348) DESCRIBE `ports` 0.00097322463989258
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00029587745666504
(350) DESCRIBE `ports` 0.0010042190551758
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00021600723266602
(352) DESCRIBE `ports` 0.00071001052856445
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.00020408630371094
(354) DESCRIBE `ports` 0.00068402290344238
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.00018477439880371
(356) DESCRIBE `ports` 0.00068521499633789
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2501))) 0.00020599365234375
(358) DESCRIBE `ports` 0.00075697898864746
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2501') 0.00018596649169922
(360) DESCRIBE `ports` 0.00067782402038574
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.0002901554107666
(362) DESCRIBE `ports` 0.0013208389282227
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00023198127746582
(364) DESCRIBE `ports` 0.0007178783416748
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00022101402282715
(366) DESCRIBE `ports` 0.00073003768920898
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00018692016601562
(368) DESCRIBE `ports` 0.00068497657775879
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1252))) 0.00020694732666016
(370) DESCRIBE `ports` 0.00068283081054688
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1252') 0.00018501281738281
(372) DESCRIBE `ports` 0.00067710876464844
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020313262939453
(374) DESCRIBE `ports` 0.00070595741271973
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018501281738281
(376) 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.0048117637634277
(377) DESCRIBE `avid_specials` 0.00082302093505859
(378) 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.001121997833252
(379) DESCRIBE `cruiselines` 0.0010039806365967
(380) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00033307075500488
(381) DESCRIBE `orchid_image` 0.00085306167602539
(382) DESCRIBE `cruiselines` 0.0012199878692627
(383) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00022721290588379
(384) DESCRIBE `cruises` 0.0013389587402344
(385) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68492') 0.00022006034851074
(386) DESCRIBE `ships` 0.001317024230957
(387) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00026988983154297
(388) DESCRIBE `ships` 0.0013129711151123
(389) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00019097328186035
(390) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017690658569336
(391) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016593933105469
(392) DESCRIBE `itineraries` 0.00066018104553223
(393) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68492') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00058698654174805
(394) DESCRIBE `ports` 0.00074005126953125
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00022602081298828
(396) DESCRIBE `ports` 0.00067782402038574
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020503997802734
(398) DESCRIBE `ports` 0.00067496299743652
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00019001960754395
(400) DESCRIBE `sailingdates` 0.00060796737670898
(401) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68492') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00052595138549805
(402) DESCRIBE `ports` 0.00076198577880859
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00021696090698242
(404) DESCRIBE `ports` 0.00068283081054688
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00022387504577637
(406) DESCRIBE `ports` 0.0007469654083252
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00022292137145996
(408) DESCRIBE `ports` 0.00068807601928711
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018405914306641
(410) DESCRIBE `ports` 0.00069713592529297
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00020408630371094
(412) DESCRIBE `ports` 0.0006859302520752
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00018811225891113
(414) DESCRIBE `ports` 0.00067996978759766
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00020098686218262
(416) DESCRIBE `ports` 0.0006871223449707
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00018477439880371
(418) DESCRIBE `ports` 0.00068807601928711
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1709))) 0.00021719932556152
(420) DESCRIBE `ports` 0.00071406364440918
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1709') 0.00018811225891113
(422) DESCRIBE `ports` 0.00068402290344238
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00020599365234375
(424) DESCRIBE `ports` 0.00069904327392578
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00018715858459473
(426) DESCRIBE `ports` 0.00068497657775879
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00020503997802734
(428) DESCRIBE `ports` 0.00068306922912598
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00018405914306641
(430) DESCRIBE `ports` 0.00067782402038574
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00020194053649902
(432) DESCRIBE `ports` 0.0006859302520752
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.00018405914306641
(434) DESCRIBE `ports` 0.00068521499633789
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00020909309387207
(436) DESCRIBE `ports` 0.00071811676025391
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.00018596649169922
(438) 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.0043168067932129
(439) DESCRIBE `avid_specials` 0.00080204010009766
(440) 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.0011270046234131
(441) DESCRIBE `cruiselines` 0.00098991394042969
(442) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00023794174194336
(443) DESCRIBE `orchid_image` 0.00082087516784668
(444) DESCRIBE `cruiselines` 0.00094509124755859
(445) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00019502639770508
(446) DESCRIBE `cruises` 0.001384973526001
(447) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58850') 0.00021100044250488
(448) DESCRIBE `ships` 0.0013279914855957
(449) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.0002739429473877
(450) DESCRIBE `ships` 0.0013000965118408
(451) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.00024604797363281
(452) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017619132995605
(453) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016593933105469
(454) DESCRIBE `itineraries` 0.00066590309143066
(455) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '58850') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00044679641723633
(456) DESCRIBE `ports` 0.0007479190826416
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00022196769714355
(458) DESCRIBE `ports` 0.00069093704223633
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020289421081543
(460) DESCRIBE `ports` 0.00069212913513184
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00019192695617676
(462) DESCRIBE `sailingdates` 0.00061607360839844
(463) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '58850') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00040197372436523
(464) DESCRIBE `ports` 0.00082588195800781
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00022792816162109
(466) DESCRIBE `ports` 0.00068402290344238
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018906593322754
(468) DESCRIBE `ports` 0.00071406364440918
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00024604797363281
(470) DESCRIBE `ports` 0.00080394744873047
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.0002129077911377
(472) DESCRIBE `ports` 0.00080490112304688
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00024008750915527
(474) DESCRIBE `ports` 0.00071001052856445
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00019311904907227
(476) DESCRIBE `ports` 0.00095987319946289
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00024604797363281
(478) DESCRIBE `ports` 0.00074982643127441
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00020790100097656
(480) DESCRIBE `ports` 0.00085711479187012
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00020599365234375
(482) DESCRIBE `ports` 0.00068783760070801
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00018405914306641
(484) DESCRIBE `ports` 0.00068902969360352
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00020980834960938
(486) DESCRIBE `ports` 0.0007178783416748
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.0002138614654541
(488) DESCRIBE `ports` 0.00072717666625977
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00020599365234375
(490) DESCRIBE `ports` 0.0006861686706543
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00018405914306641
(492) DESCRIBE `ports` 0.00067901611328125
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020098686218262
(494) DESCRIBE `ports` 0.00069093704223633
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018405914306641
(496) DESCRIBE `ports` 0.00070786476135254
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020194053649902
(498) DESCRIBE `ports` 0.0007469654083252
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018596649169922
(500) 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.0044059753417969
(501) DESCRIBE `avid_specials` 0.00085687637329102
(502) 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.0011229515075684
(503) DESCRIBE `cruiselines` 0.00099802017211914
(504) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00024080276489258
(505) DESCRIBE `orchid_image` 0.00092411041259766
(506) DESCRIBE `cruiselines` 0.0011508464813232
(507) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00022506713867188
(508) DESCRIBE `cruises` 0.0015110969543457
(509) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68493') 0.00023198127746582
(510) DESCRIBE `ships` 0.0014591217041016
(511) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.0003201961517334
(512) DESCRIBE `ships` 0.0013449192047119
(513) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00020098686218262
(514) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017690658569336
(515) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017881393432617
(516) DESCRIBE `itineraries` 0.00069093704223633
(517) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68493') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00039887428283691
(518) DESCRIBE `ports` 0.0010039806365967
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00029921531677246
(520) DESCRIBE `ports` 0.00080490112304688
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00021481513977051
(522) DESCRIBE `ports` 0.00071287155151367
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.00020003318786621
(524) DESCRIBE `sailingdates` 0.00064301490783691
(525) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68493') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0004279613494873
(526) DESCRIBE `ports` 0.00079607963562012
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.0002439022064209
(528) DESCRIBE `ports` 0.00071287155151367
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.00022315979003906
(530) DESCRIBE `ports` 0.00083804130554199
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 579))) 0.00022602081298828
(532) DESCRIBE `ports` 0.00071096420288086
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '579') 0.0001981258392334
(534) DESCRIBE `ports` 0.00075387954711914
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1709))) 0.00022196769714355
(536) DESCRIBE `ports` 0.00072598457336426
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1709') 0.00020003318786621
(538) DESCRIBE `ports` 0.00070095062255859
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.0002291202545166
(540) DESCRIBE `ports` 0.00070500373840332
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.0001990795135498
(542) DESCRIBE `ports` 0.00070095062255859
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00024914741516113
(544) DESCRIBE `ports` 0.00075387954711914
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00022315979003906
(546) DESCRIBE `ports` 0.00075483322143555
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00023984909057617
(548) DESCRIBE `ports` 0.00086188316345215
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.00022196769714355
(550) 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.0047521591186523
(551) DESCRIBE `avid_specials` 0.0011501312255859
(552) 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.002094030380249
(553) DESCRIBE `cruiselines` 0.0015461444854736
(554) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00035905838012695
(555) DESCRIBE `orchid_image` 0.0012378692626953
(556) DESCRIBE `cruiselines` 0.0015959739685059
(557) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00032496452331543
(558) DESCRIBE `cruises` 0.0023429393768311
(559) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58851') 0.00040411949157715
(560) DESCRIBE `ships` 0.0021839141845703
(561) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00043606758117676
(562) DESCRIBE `ships` 0.0021228790283203
(563) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.00032305717468262
(564) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00023984909057617
(565) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00022792816162109
(566) DESCRIBE `itineraries` 0.0011000633239746
(567) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '58851') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00059795379638672
(568) DESCRIBE `ports` 0.0013198852539062
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031900405883789
(570) DESCRIBE `ports` 0.0010199546813965
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00028800964355469
(572) DESCRIBE `ports` 0.0010199546813965
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00028419494628906
(574) DESCRIBE `sailingdates` 0.00089192390441895
(575) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '58851') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00053811073303223
(576) DESCRIBE `ports` 0.0010199546813965
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031089782714844
(578) DESCRIBE `ports` 0.001054048538208
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00025415420532227
(580) DESCRIBE `ports` 0.0010089874267578
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4794))) 0.00030398368835449
(582) DESCRIBE `ports` 0.0010559558868408
(583) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4794') 0.00029087066650391
(584) DESCRIBE `ports` 0.00076699256896973
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00022387504577637
(586) DESCRIBE `ports` 0.0007178783416748
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00018906593322754
(588) DESCRIBE `ports` 0.00069689750671387
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 532))) 0.00021910667419434
(590) DESCRIBE `ports` 0.00068402290344238
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '532') 0.00019693374633789
(592) DESCRIBE `ports` 0.00069713592529297
(593) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1493))) 0.00020885467529297
(594) DESCRIBE `ports` 0.00069594383239746
(595) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1493') 0.00018906593322754
(596) DESCRIBE `ports` 0.00069499015808105
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00020408630371094
(598) DESCRIBE `ports` 0.00069808959960938
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00019598007202148
(600) DESCRIBE `ports` 0.0007481575012207
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00021719932556152
(602) DESCRIBE `ports` 0.00069093704223633
(603) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00019311904907227
(604) DESCRIBE `ports` 0.00070309638977051
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1878))) 0.00021815299987793
(606) DESCRIBE `ports` 0.0007319450378418
(607) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1878') 0.00019097328186035
(608) DESCRIBE `ports` 0.00084710121154785
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00021982192993164
(610) DESCRIBE `ports` 0.00070500373840332
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00019192695617676
(612) DESCRIBE `ports` 0.00069785118103027
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00020384788513184
(614) DESCRIBE `ports` 0.00068998336791992
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00018501281738281
(616) 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.0043618679046631
(617) DESCRIBE `avid_specials` 0.00072813034057617
(618) 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.0010900497436523
(619) DESCRIBE `cruiselines` 0.00099086761474609
(620) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.0002291202545166
(621) DESCRIBE `orchid_image` 0.0008080005645752
(622) DESCRIBE `cruiselines` 0.0010449886322021
(623) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00019502639770508
(624) DESCRIBE `ships` 0.001427173614502
(625) SELECT `ships`.* FROM `ships` WHERE (id IN ('652', '616')) ORDER BY FIND_IN_SET(id, '652,616') 0.00037002563476562
(626) DESCRIBE `cruisetypes` 0.00057005882263184
(627) DESCRIBE `destinations` 0.00090694427490234
(628) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '26', '28', '45', '21', '25')) ORDER BY FIND_IN_SET(id, '22,26,28,45,21,25') 0.00043392181396484
(629) DESCRIBE `cruiselines` 0.0009911060333252
(630) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00028204917907715
(631) DESCRIBE `cruiselines` 0.0011348724365234
(632) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00024104118347168