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

 
  • Musica, Italy Greece Montenegro ex Venice Return

    Nights 7 Ship MSC Musica
    Star Rating 4 Star Departs Venice, Italy
    Sailing 2018: 25 Mar, 1 Apr, 8 Apr, 15 Apr, 22 Apr, 29 Apr, 6 May, 13 May, 20 May, 27 May, 3 Jun, 10 Jun, 17 Jun, 24 Jun, 1 Jul, 8 Jul, 15 Jul, 22 Jul, 29 Jul, 5 Aug, 12 Aug, 19 Aug, 26 Aug, 2 Sep, 9 Sep, 16 Sep, 23 Sep, 30 Sep, 7 Oct
    Ports of Call Venice, Brindisi, Katakolon, Santorini, Athens (Piraeus) Greece, Corfu, Kotor

    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.

     
    MSC CRUISES SUPER SAVER DEALS NOT JUST A REGULAR SALE! Plan ahead, secure your cabin and get a great deal with MSC. 2018-2019 cruising now at 2017 prices! ADDITIONAL 10% OFF all early bird bookings. 7 night Mediterranean cruises from $649pp, 7 night Caribbean cruises from $749pp, 7 night Northern Europe cruises from $1279pp. Selected sailings, terms and conditions apply.
     
    Plan a Cruise Month Special: MSC Cruises 90 selected departures offer the 2nd passenger at 50% off (excluding port charges). Departures include Northern Europe cruises through Summer 2018, Cuba, Arabian Peninsula, 7 & 10 night cruises in the Mediterranean, the West Indies and Grand Voyage cruises. Available for sale for the month of October 2017, availability is limited, so secure your cabin now. Terms and conditions apply. Contact us for details.
  • Meraviglia, Italy Malta Spain France ex Genoa Roundtrip

    Nights 7 Ship MSC Meraviglia
    Star Rating 4 Star Departs Genoa, Italy
    Sailing 2018: 25 Mar, 1 Apr, 8 Apr, 17 Nov, 24 Nov, 1 Dec, 8 Dec, 15 Dec, 22 Dec, 29 Dec 2019: 5 Jan, 12 Jan, 19 Jan, 26 Jan, 2 Feb, 9 Feb, 16 Feb, 23 Feb, 2 Mar, 9 Mar, 16 Mar, 23 Mar, 30 Mar
    Ports of Call Genoa, Rome (Civitavecchia), Palermo, Valletta, Barcelona, Marseilles

    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.

     
    MSC CRUISES SUPER SAVER DEALS NOT JUST A REGULAR SALE! Plan ahead, secure your cabin and get a great deal with MSC. 2018-2019 cruising now at 2017 prices! ADDITIONAL 10% OFF all early bird bookings. 7 night Mediterranean cruises from $649pp, 7 night Caribbean cruises from $749pp, 7 night Northern Europe cruises from $1279pp. Selected sailings, terms and conditions apply.
     
    Plan a Cruise Month Special: MSC Cruises 90 selected departures offer the 2nd passenger at 50% off (excluding port charges). Departures include Northern Europe cruises through Summer 2018, Cuba, Arabian Peninsula, 7 & 10 night cruises in the Mediterranean, the West Indies and Grand Voyage cruises. Available for sale for the month of October 2017, availability is limited, so secure your cabin now. Terms and conditions apply. Contact us for details.
  • Fantasia, Caribbean & Antilles ex Guadeloupe Roundtrip

    Nights 7 Ship MSC Fantasia
    Star Rating 4 Star Departs Pointe-a-Pitre, Guadeloupe
    Sailing 2018: 25 Mar
    Ports of Call Pointe-a-Pitre, Castries, Bridgetown, Trinidad (Port of Spain), St Georges, Basseterre, Forte de France

    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.

     
    MSC CRUISES SUPER SAVER DEALS NOT JUST A REGULAR SALE! Plan ahead, secure your cabin and get a great deal with MSC. 2018-2019 cruising now at 2017 prices! ADDITIONAL 10% OFF all early bird bookings. 7 night Mediterranean cruises from $649pp, 7 night Caribbean cruises from $749pp, 7 night Northern Europe cruises from $1279pp. Selected sailings, terms and conditions apply.
     
    Plan a Cruise Month Special: MSC Cruises 90 selected departures offer the 2nd passenger at 50% off (excluding port charges). Departures include Northern Europe cruises through Summer 2018, Cuba, Arabian Peninsula, 7 & 10 night cruises in the Mediterranean, the West Indies and Grand Voyage cruises. Available for sale for the month of October 2017, availability is limited, so secure your cabin now. Terms and conditions apply. Contact us for details.
  • Musica, Italy Greece Montenegro ex Brindisi Return

    Nights 7 Ship MSC Musica
    Star Rating 4 Star Departs Brindisi, Italy
    Sailing 2018: 26 Mar, 2 Apr, 9 Apr, 16 Apr, 23 Apr, 30 Apr, 7 May, 14 May, 21 May, 28 May, 4 Jun, 11 Jun, 18 Jun, 25 Jun, 2 Jul, 9 Jul, 16 Jul, 23 Jul, 30 Jul, 6 Aug, 13 Aug, 20 Aug, 27 Aug, 3 Sep, 10 Sep, 17 Sep, 24 Sep, 1 Oct
    Ports of Call Brindisi, Katakolon, Santorini, Athens (Piraeus) Greece, Corfu, Kotor, Venice

    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.

     
    MSC CRUISES SUPER SAVER DEALS NOT JUST A REGULAR SALE! Plan ahead, secure your cabin and get a great deal with MSC. 2018-2019 cruising now at 2017 prices! ADDITIONAL 10% OFF all early bird bookings. 7 night Mediterranean cruises from $649pp, 7 night Caribbean cruises from $749pp, 7 night Northern Europe cruises from $1279pp. Selected sailings, terms and conditions apply.
     
    Plan a Cruise Month Special: MSC Cruises 90 selected departures offer the 2nd passenger at 50% off (excluding port charges). Departures include Northern Europe cruises through Summer 2018, Cuba, Arabian Peninsula, 7 & 10 night cruises in the Mediterranean, the West Indies and Grand Voyage cruises. Available for sale for the month of October 2017, availability is limited, so secure your cabin now. Terms and conditions apply. Contact us for details.
  • Sinfonia, Pomene Island ex Durban Return

    Nights 4 Ship MSC Sinfonia
    Star Rating 4 Star Departs Durban, South Africa
    Sailing 2018: 26 Mar
    Ports of Call Durban, Pomene

    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.

     
    MSC CRUISES SUPER SAVER DEALS NOT JUST A REGULAR SALE! Plan ahead, secure your cabin and get a great deal with MSC. 2018-2019 cruising now at 2017 prices! ADDITIONAL 10% OFF all early bird bookings. 7 night Mediterranean cruises from $649pp, 7 night Caribbean cruises from $749pp, 7 night Northern Europe cruises from $1279pp. Selected sailings, terms and conditions apply.
     
    Plan a Cruise Month Special: MSC Cruises 90 selected departures offer the 2nd passenger at 50% off (excluding port charges). Departures include Northern Europe cruises through Summer 2018, Cuba, Arabian Peninsula, 7 & 10 night cruises in the Mediterranean, the West Indies and Grand Voyage cruises. Available for sale for the month of October 2017, availability is limited, so secure your cabin now. Terms and conditions apply. Contact us for details.
  • Meraviglia, Italy Malta Spain France ex Rome Roundtrip

    Nights 7 Ship MSC Meraviglia
    Star Rating 4 Star Departs Rome (Civitavecchia), Italy
    Sailing 2018: 26 Mar, 2 Apr, 18 Nov, 25 Nov, 2 Dec, 9 Dec, 16 Dec, 23 Dec, 30 Dec 2019: 6 Jan, 13 Jan, 20 Jan, 27 Jan, 3 Feb, 10 Feb, 17 Feb, 24 Feb, 3 Mar, 10 Mar, 17 Mar, 24 Mar
    Ports of Call Rome (Civitavecchia), Palermo, Valletta, Barcelona, Marseilles, Genoa

    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.

     
    MSC CRUISES SUPER SAVER DEALS NOT JUST A REGULAR SALE! Plan ahead, secure your cabin and get a great deal with MSC. 2018-2019 cruising now at 2017 prices! ADDITIONAL 10% OFF all early bird bookings. 7 night Mediterranean cruises from $649pp, 7 night Caribbean cruises from $749pp, 7 night Northern Europe cruises from $1279pp. Selected sailings, terms and conditions apply.
     
    Plan a Cruise Month Special: MSC Cruises 90 selected departures offer the 2nd passenger at 50% off (excluding port charges). Departures include Northern Europe cruises through Summer 2018, Cuba, Arabian Peninsula, 7 & 10 night cruises in the Mediterranean, the West Indies and Grand Voyage cruises. Available for sale for the month of October 2017, availability is limited, so secure your cabin now. Terms and conditions apply. Contact us for details.
  • Orchestra, Italy France Spain Morocco Portugal ex Rome Return

    Nights 12 Ship MSC Orchestra
    Star Rating 4 Star Departs Rome (Civitavecchia), Italy
    Sailing 2018: 26 Mar
    Ports of Call Rome (Civitavecchia), Genoa, Marseilles, Barcelona, Casablanca, Santa Cruz de Tenerife, Funchal (Madeira), Malaga

    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.

     
    MSC CRUISES SUPER SAVER DEALS NOT JUST A REGULAR SALE! Plan ahead, secure your cabin and get a great deal with MSC. 2018-2019 cruising now at 2017 prices! ADDITIONAL 10% OFF all early bird bookings. 7 night Mediterranean cruises from $649pp, 7 night Caribbean cruises from $749pp, 7 night Northern Europe cruises from $1279pp. Selected sailings, terms and conditions apply.
     
    Plan a Cruise Month Special: MSC Cruises 90 selected departures offer the 2nd passenger at 50% off (excluding port charges). Departures include Northern Europe cruises through Summer 2018, Cuba, Arabian Peninsula, 7 & 10 night cruises in the Mediterranean, the West Indies and Grand Voyage cruises. Available for sale for the month of October 2017, availability is limited, so secure your cabin now. Terms and conditions apply. Contact us for details.
  • Poesia, South America Cruise ex Buenos Aires Return

    Nights 9 Ship MSC Poesia
    Star Rating 4 Star Departs Buenos Aires, Argentina
    Sailing 2018: 26 Mar
    Ports of Call Buenos Aires, Punta del Este, Illhabela, Rio de Janeiro, Cabo Frio, Ilha Grande

    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.

     
    MSC CRUISES SUPER SAVER DEALS NOT JUST A REGULAR SALE! Plan ahead, secure your cabin and get a great deal with MSC. 2018-2019 cruising now at 2017 prices! ADDITIONAL 10% OFF all early bird bookings. 7 night Mediterranean cruises from $649pp, 7 night Caribbean cruises from $749pp, 7 night Northern Europe cruises from $1279pp. Selected sailings, terms and conditions apply.
     
    Plan a Cruise Month Special: MSC Cruises 90 selected departures offer the 2nd passenger at 50% off (excluding port charges). Departures include Northern Europe cruises through Summer 2018, Cuba, Arabian Peninsula, 7 & 10 night cruises in the Mediterranean, the West Indies and Grand Voyage cruises. Available for sale for the month of October 2017, availability is limited, so secure your cabin now. Terms and conditions apply. Contact us for details.
  • Divina, Italy France Spain ex Valencia to Genoa

    Nights 2 Ship MSC Divina
    Star Rating 4 Star Departs Valencia, Spain
    Sailing 2018: 26 Mar
    Ports of Call Valencia, Marseilles, Genoa

    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.

     
    MSC CRUISES SUPER SAVER DEALS NOT JUST A REGULAR SALE! Plan ahead, secure your cabin and get a great deal with MSC. 2018-2019 cruising now at 2017 prices! ADDITIONAL 10% OFF all early bird bookings. 7 night Mediterranean cruises from $649pp, 7 night Caribbean cruises from $749pp, 7 night Northern Europe cruises from $1279pp. Selected sailings, terms and conditions apply.
     
    Plan a Cruise Month Special: MSC Cruises 90 selected departures offer the 2nd passenger at 50% off (excluding port charges). Departures include Northern Europe cruises through Summer 2018, Cuba, Arabian Peninsula, 7 & 10 night cruises in the Mediterranean, the West Indies and Grand Voyage cruises. Available for sale for the month of October 2017, availability is limited, so secure your cabin now. Terms and conditions apply. Contact us for details.
  • Meraviglia, Italy Malta Spain France ex Palermo Roundtrip

    Nights 7 Ship MSC Meraviglia
    Star Rating 4 Star Departs Palermo, Sicily. IT
    Sailing 2018: 27 Mar, 3 Apr, 19 Nov, 26 Nov, 3 Dec, 10 Dec, 17 Dec, 24 Dec, 31 Dec 2019: 7 Jan, 14 Jan, 21 Jan, 28 Jan, 4 Feb, 11 Feb, 18 Feb, 25 Feb, 4 Mar, 11 Mar, 18 Mar, 25 Mar
    Ports of Call Palermo, Valletta, Barcelona, Marseilles, Genoa, 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.

     
    MSC CRUISES SUPER SAVER DEALS NOT JUST A REGULAR SALE! Plan ahead, secure your cabin and get a great deal with MSC. 2018-2019 cruising now at 2017 prices! ADDITIONAL 10% OFF all early bird bookings. 7 night Mediterranean cruises from $649pp, 7 night Caribbean cruises from $749pp, 7 night Northern Europe cruises from $1279pp. Selected sailings, terms and conditions apply.
     
    Plan a Cruise Month Special: MSC Cruises 90 selected departures offer the 2nd passenger at 50% off (excluding port charges). Departures include Northern Europe cruises through Summer 2018, Cuba, Arabian Peninsula, 7 & 10 night cruises in the Mediterranean, the West Indies and Grand Voyage cruises. Available for sale for the month of October 2017, availability is limited, so secure your cabin now. 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: 540

Total elapsed time: 0.36880683898926

# Query Time
(1) connect 0.0005948543548584
(2) DESCRIBE `cruises` 0.0017459392547607
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (62666, 62661, 70236, 62667, 64926, 62662, 68527, 70352, 67961, 62663)) ORDER BY FIND_IN_SET(id, '62666,62661,70236,62667,64926,62662,68527,70352,67961,62663') 0.0015909671783447
(4) DESCRIBE `cruises` 0.001582145690918
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62666') 0.00027704238891602
(6) DESCRIBE `ships` 0.0019791126251221
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 553))) 0.00026202201843262
(8) DESCRIBE `ships` 0.00130295753479
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '553') 0.00019717216491699
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017499923706055
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016307830810547
(12) DESCRIBE `itineraries` 0.00066399574279785
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62666') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00059413909912109
(14) DESCRIBE `ports` 0.00070381164550781
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021696090698242
(16) DESCRIBE `ports` 0.0006859302520752
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019001960754395
(18) DESCRIBE `ports` 0.00065803527832031
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017404556274414
(20) DESCRIBE `sailingdates` 0.0005950927734375
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62666') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00077509880065918
(22) DESCRIBE `ports` 0.00087094306945801
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00023293495178223
(24) DESCRIBE `ports` 0.00070691108703613
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00022196769714355
(26) DESCRIBE `ports` 0.00066399574279785
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00020098686218262
(28) DESCRIBE `ports` 0.00066089630126953
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00018095970153809
(30) DESCRIBE `ports` 0.00066709518432617
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00020599365234375
(32) DESCRIBE `ports` 0.00066518783569336
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00018000602722168
(34) DESCRIBE `ports` 0.00066685676574707
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00020098686218262
(36) DESCRIBE `ports` 0.0009608268737793
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00019001960754395
(38) DESCRIBE `ports` 0.00092697143554688
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00020384788513184
(40) DESCRIBE `ports` 0.00092983245849609
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00024104118347168
(42) DESCRIBE `ports` 0.00095200538635254
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00020599365234375
(44) DESCRIBE `ports` 0.00090503692626953
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00018191337585449
(46) DESCRIBE `ports` 0.00091814994812012
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00021004676818848
(48) DESCRIBE `ports` 0.00069308280944824
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00018596649169922
(50) DESCRIBE `ports` 0.00069499015808105
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020098686218262
(52) DESCRIBE `ports` 0.00066900253295898
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018095970153809
(54) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62666') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0043330192565918
(55) DESCRIBE `avid_specials` 0.00066304206848145
(56) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62666 and class = 'Cruise') OR (item_id = 553 AND class = 'Ship') OR (item_id = 19 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.0013761520385742
(57) DESCRIBE `cruiselines` 0.0013320446014404
(58) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00029206275939941
(59) DESCRIBE `orchid_image` 0.00097489356994629
(60) DESCRIBE `cruiselines` 0.00099706649780273
(61) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00019097328186035
(62) DESCRIBE `cruises` 0.00205397605896
(63) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62661') 0.00029087066650391
(64) DESCRIBE `ships` 0.0017249584197998
(65) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00033402442932129
(66) DESCRIBE `ships` 0.0017580986022949
(67) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00022983551025391
(68) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020718574523926
(69) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019598007202148
(70) DESCRIBE `itineraries` 0.00086116790771484
(71) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62661') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00060415267944336
(72) DESCRIBE `ports` 0.0010120868682861
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00027585029602051
(74) DESCRIBE `ports` 0.00087094306945801
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00025796890258789
(76) DESCRIBE `ports` 0.00086402893066406
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00022196769714355
(78) DESCRIBE `sailingdates` 0.00076508522033691
(79) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62661') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00095582008361816
(80) DESCRIBE `ports` 0.0012400150299072
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00031208992004395
(82) DESCRIBE `ports` 0.00091290473937988
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00023603439331055
(84) DESCRIBE `ports` 0.00098204612731934
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0002591609954834
(86) DESCRIBE `ports` 0.00097489356994629
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00023198127746582
(88) DESCRIBE `ports` 0.00097513198852539
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00026988983154297
(90) DESCRIBE `ports` 0.00097894668579102
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00025701522827148
(92) DESCRIBE `ports` 0.00099587440490723
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00026893615722656
(94) DESCRIBE `ports` 0.00096297264099121
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00023508071899414
(96) DESCRIBE `ports` 0.00096297264099121
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00027608871459961
(98) DESCRIBE `ports` 0.0010321140289307
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00023603439331055
(100) DESCRIBE `ports` 0.00098919868469238
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00026297569274902
(102) DESCRIBE `ports` 0.00099992752075195
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00023984909057617
(104) DESCRIBE `ports` 0.0010199546813965
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00028491020202637
(106) DESCRIBE `ports` 0.0010130405426025
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00026297569274902
(108) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62661') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0088908672332764
(109) DESCRIBE `avid_specials` 0.0012221336364746
(110) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62661 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 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.001971960067749
(111) DESCRIBE `cruiselines` 0.0015408992767334
(112) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00034189224243164
(113) DESCRIBE `orchid_image` 0.0011329650878906
(114) DESCRIBE `cruiselines` 0.001276969909668
(115) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00024700164794922
(116) DESCRIBE `cruises` 0.0017280578613281
(117) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70236') 0.0002751350402832
(118) DESCRIBE `ships` 0.0016958713531494
(119) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 726))) 0.00033807754516602
(120) DESCRIBE `ships` 0.0016481876373291
(121) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '726') 0.00021696090698242
(122) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020813941955566
(123) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019383430480957
(124) DESCRIBE `itineraries` 0.00084805488586426
(125) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70236') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00074601173400879
(126) DESCRIBE `ports` 0.00094509124755859
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.0002751350402832
(128) DESCRIBE `ports` 0.00085592269897461
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00025391578674316
(130) DESCRIBE `ports` 0.00086688995361328
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00023388862609863
(132) DESCRIBE `sailingdates` 0.00077199935913086
(133) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70236') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00070881843566895
(134) DESCRIBE `ports` 0.00096607208251953
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00027179718017578
(136) DESCRIBE `ports` 0.00090503692626953
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.0002288818359375
(138) DESCRIBE `ports` 0.00085902214050293
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00026202201843262
(140) DESCRIBE `ports` 0.00090289115905762
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.0002288818359375
(142) DESCRIBE `ports` 0.00098705291748047
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00025486946105957
(144) DESCRIBE `ports` 0.00075197219848633
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00019478797912598
(146) DESCRIBE `ports` 0.00067710876464844
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 55))) 0.00020813941955566
(148) DESCRIBE `ports` 0.00067996978759766
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '55') 0.0001828670501709
(150) DESCRIBE `ports` 0.00068187713623047
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 308))) 0.00021505355834961
(152) DESCRIBE `ports` 0.00067806243896484
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '308') 0.00018692016601562
(154) DESCRIBE `ports` 0.00066900253295898
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00021100044250488
(156) DESCRIBE `ports` 0.00067901611328125
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00018715858459473
(158) DESCRIBE `ports` 0.00068807601928711
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00021600723266602
(160) DESCRIBE `ports` 0.00069594383239746
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00019097328186035
(162) DESCRIBE `ports` 0.00086688995361328
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00022602081298828
(164) DESCRIBE `ports` 0.00068116188049316
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.0001990795135498
(166) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '70236') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0042638778686523
(167) DESCRIBE `avid_specials` 0.00072813034057617
(168) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70236 and class = 'Cruise') OR (item_id = 726 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010690689086914
(169) DESCRIBE `cruiselines` 0.0011379718780518
(170) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00045990943908691
(171) DESCRIBE `orchid_image` 0.0012490749359131
(172) DESCRIBE `cruiselines` 0.00095987319946289
(173) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00018811225891113
(174) DESCRIBE `cruises` 0.0012960433959961
(175) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62667') 0.00020790100097656
(176) DESCRIBE `ships` 0.0013699531555176
(177) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 553))) 0.00025701522827148
(178) DESCRIBE `ships` 0.0012650489807129
(179) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '553') 0.00017690658569336
(180) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019097328186035
(181) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016307830810547
(182) DESCRIBE `itineraries` 0.00067615509033203
(183) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62667') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00040602684020996
(184) DESCRIBE `ports` 0.00070905685424805
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00020813941955566
(186) DESCRIBE `ports` 0.00067901611328125
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.0002439022064209
(188) DESCRIBE `ports` 0.0008091926574707
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00019693374633789
(190) DESCRIBE `sailingdates` 0.00063109397888184
(191) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62667') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00053286552429199
(192) DESCRIBE `ports` 0.00082206726074219
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00023698806762695
(194) DESCRIBE `ports` 0.0007171630859375
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00019478797912598
(196) DESCRIBE `ports` 0.00069093704223633
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00021195411682129
(198) DESCRIBE `ports` 0.0006859302520752
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00020003318786621
(200) DESCRIBE `ports` 0.00085020065307617
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00023603439331055
(202) DESCRIBE `ports` 0.00073909759521484
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00019407272338867
(204) DESCRIBE `ports` 0.00074601173400879
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00024080276489258
(206) DESCRIBE `ports` 0.00074100494384766
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00021195411682129
(208) DESCRIBE `ports` 0.00070691108703613
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00022697448730469
(210) DESCRIBE `ports` 0.00069808959960938
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.0001990795135498
(212) DESCRIBE `ports` 0.00069594383239746
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00021600723266602
(214) DESCRIBE `ports` 0.00074100494384766
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00018906593322754
(216) DESCRIBE `ports` 0.0007321834564209
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00022387504577637
(218) DESCRIBE `ports` 0.00069189071655273
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018596649169922
(220) DESCRIBE `ports` 0.00069284439086914
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.0002140998840332
(222) DESCRIBE `ports` 0.000701904296875
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00018787384033203
(224) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62667') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0043580532073975
(225) DESCRIBE `avid_specials` 0.00080013275146484
(226) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62667 and class = 'Cruise') OR (item_id = 553 AND class = 'Ship') OR (item_id = 19 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.0011031627655029
(227) DESCRIBE `cruiselines` 0.0011038780212402
(228) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00026082992553711
(229) DESCRIBE `orchid_image` 0.00083518028259277
(230) DESCRIBE `cruiselines` 0.001039981842041
(231) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00021982192993164
(232) DESCRIBE `cruises` 0.0014002323150635
(233) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64926') 0.00027704238891602
(234) DESCRIBE `ships` 0.0014340877532959
(235) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 462))) 0.00032210350036621
(236) DESCRIBE `ships` 0.0014970302581787
(237) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '462') 0.000244140625
(238) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017595291137695
(239) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016212463378906
(240) DESCRIBE `itineraries` 0.00085210800170898
(241) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64926') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00056886672973633
(242) DESCRIBE `ports` 0.000823974609375
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00024104118347168
(244) DESCRIBE `ports` 0.00070405006408691
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00021815299987793
(246) DESCRIBE `ports` 0.00071001052856445
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00020599365234375
(248) DESCRIBE `sailingdates` 0.00066900253295898
(249) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64926') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00056004524230957
(250) DESCRIBE `ports` 0.00085306167602539
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00024890899658203
(252) DESCRIBE `ports` 0.00094294548034668
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00021004676818848
(254) DESCRIBE `ports` 0.0007169246673584
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2965))) 0.00028085708618164
(256) DESCRIBE `ports` 0.00072503089904785
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2965') 0.00019192695617676
(258) DESCRIBE `ports` 0.00068402290344238
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00022506713867188
(260) DESCRIBE `ports` 0.00076103210449219
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00018000602722168
(262) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '64926') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0042839050292969
(263) DESCRIBE `avid_specials` 0.00066304206848145
(264) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64926 and class = 'Cruise') OR (item_id = 462 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 52 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.0011320114135742
(265) DESCRIBE `cruiselines` 0.0010659694671631
(266) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00022792816162109
(267) DESCRIBE `orchid_image` 0.00075793266296387
(268) DESCRIBE `cruiselines` 0.00094699859619141
(269) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00018692016601562
(270) DESCRIBE `cruises` 0.0013010501861572
(271) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62662') 0.00021004676818848
(272) DESCRIBE `ships` 0.001305103302002
(273) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00026988983154297
(274) DESCRIBE `ships` 0.0018680095672607
(275) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00033807754516602
(276) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021696090698242
(277) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016498565673828
(278) DESCRIBE `itineraries` 0.00078201293945312
(279) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62662') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0003960132598877
(280) DESCRIBE `ports` 0.00071811676025391
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00024199485778809
(282) DESCRIBE `ports` 0.00074005126953125
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00019311904907227
(284) DESCRIBE `ports` 0.0007021427154541
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00019001960754395
(286) DESCRIBE `sailingdates` 0.00059890747070312
(287) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62662') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0007479190826416
(288) DESCRIBE `ports` 0.0010089874267578
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00027203559875488
(290) DESCRIBE `ports` 0.00072598457336426
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0001988410949707
(292) DESCRIBE `ports` 0.00067496299743652
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00020909309387207
(294) DESCRIBE `ports` 0.00079107284545898
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00043892860412598
(296) DESCRIBE `ports` 0.0012421607971191
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00030803680419922
(298) DESCRIBE `ports` 0.0010480880737305
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00022411346435547
(300) DESCRIBE `ports` 0.00093698501586914
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00021982192993164
(302) DESCRIBE `ports` 0.00067591667175293
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00017595291137695
(304) DESCRIBE `ports` 0.00068020820617676
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00020909309387207
(306) DESCRIBE `ports` 0.00069403648376465
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00017595291137695
(308) DESCRIBE `ports` 0.00066781044006348
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00020694732666016
(310) DESCRIBE `ports` 0.0006709098815918
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00017380714416504
(312) DESCRIBE `ports` 0.00068402290344238
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021195411682129
(314) DESCRIBE `ports` 0.00069904327392578
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00017404556274414
(316) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62662') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0042619705200195
(317) DESCRIBE `avid_specials` 0.00074410438537598
(318) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62662 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 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.0010960102081299
(319) DESCRIBE `cruiselines` 0.0011708736419678
(320) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00024795532226562
(321) DESCRIBE `orchid_image` 0.00078105926513672
(322) DESCRIBE `cruiselines` 0.0010051727294922
(323) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0001988410949707
(324) DESCRIBE `cruises` 0.0013258457183838
(325) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68527') 0.00023579597473145
(326) DESCRIBE `ships` 0.0013339519500732
(327) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 610))) 0.00026106834411621
(328) DESCRIBE `ships` 0.0013120174407959
(329) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '610') 0.00019097328186035
(330) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019311904907227
(331) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016593933105469
(332) DESCRIBE `itineraries` 0.00065803527832031
(333) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68527') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00058102607727051
(334) DESCRIBE `ports` 0.00073003768920898
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00023078918457031
(336) DESCRIBE `ports` 0.00072479248046875
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020194053649902
(338) DESCRIBE `ports` 0.00066781044006348
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00017786026000977
(340) DESCRIBE `sailingdates` 0.00062417984008789
(341) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68527') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00056815147399902
(342) DESCRIBE `ports` 0.00077581405639648
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021696090698242
(344) DESCRIBE `ports` 0.0006718635559082
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00023484230041504
(346) DESCRIBE `ports` 0.00076198577880859
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00023293495178223
(348) DESCRIBE `ports` 0.00071597099304199
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00021481513977051
(350) DESCRIBE `ports` 0.0007021427154541
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00020718574523926
(352) DESCRIBE `ports` 0.00073003768920898
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00018596649169922
(354) DESCRIBE `ports` 0.00067496299743652
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020289421081543
(356) DESCRIBE `ports` 0.00069284439086914
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00017690658569336
(358) DESCRIBE `ports` 0.00066208839416504
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 69))) 0.00020194053649902
(360) DESCRIBE `ports` 0.00074315071105957
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '69') 0.00017499923706055
(362) DESCRIBE `ports` 0.00067400932312012
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 598))) 0.00021100044250488
(364) DESCRIBE `ports` 0.00066614151000977
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '598') 0.00018692016601562
(366) DESCRIBE `ports` 0.0007178783416748
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 628))) 0.0002288818359375
(368) DESCRIBE `ports` 0.00074195861816406
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '628') 0.00019407272338867
(370) DESCRIBE `ports` 0.00069308280944824
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.0002439022064209
(372) DESCRIBE `ports` 0.00068807601928711
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00019693374633789
(374) DESCRIBE `ports` 0.00071096420288086
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020909309387207
(376) DESCRIBE `ports` 0.00078010559082031
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018119812011719
(378) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68527') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0066471099853516
(379) DESCRIBE `avid_specials` 0.00084686279296875
(380) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68527 and class = 'Cruise') OR (item_id = 610 AND class = 'Ship') OR (item_id = 19 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.0011148452758789
(381) DESCRIBE `cruiselines` 0.0010910034179688
(382) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00047898292541504
(383) DESCRIBE `orchid_image` 0.0013909339904785
(384) DESCRIBE `cruiselines` 0.0016310214996338
(385) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00030708312988281
(386) DESCRIBE `cruises` 0.0019989013671875
(387) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70352') 0.00031685829162598
(388) DESCRIBE `ships` 0.0019731521606445
(389) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 674))) 0.00033688545227051
(390) DESCRIBE `ships` 0.0018391609191895
(391) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '674') 0.00025701522827148
(392) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021886825561523
(393) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020384788513184
(394) DESCRIBE `itineraries` 0.00095605850219727
(395) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70352') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00066280364990234
(396) DESCRIBE `ports` 0.0010209083557129
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00027799606323242
(398) DESCRIBE `ports` 0.00092506408691406
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00024294853210449
(400) DESCRIBE `ports` 0.00091099739074707
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.0002140998840332
(402) DESCRIBE `sailingdates` 0.00078797340393066
(403) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70352') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00057411193847656
(404) DESCRIBE `ports` 0.00069403648376465
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00020694732666016
(406) DESCRIBE `ports` 0.00067687034606934
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00018501281738281
(408) DESCRIBE `ports` 0.00066494941711426
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1150))) 0.0001988410949707
(410) DESCRIBE `ports` 0.00066685676574707
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1150') 0.00017881393432617
(412) DESCRIBE `ports` 0.00067710876464844
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1761))) 0.00021481513977051
(414) DESCRIBE `ports` 0.00067710876464844
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1761') 0.00017380714416504
(416) DESCRIBE `ports` 0.0006709098815918
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00019598007202148
(418) DESCRIBE `ports` 0.00070095062255859
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.0001828670501709
(420) DESCRIBE `ports` 0.00066494941711426
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2870))) 0.0001978874206543
(422) DESCRIBE `ports` 0.00066399574279785
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2870') 0.00017213821411133
(424) DESCRIBE `ports` 0.0006868839263916
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2470))) 0.0002140998840332
(426) DESCRIBE `ports` 0.00067496299743652
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2470') 0.00017189979553223
(428) DESCRIBE `ports` 0.0006709098815918
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00019598007202148
(430) DESCRIBE `ports` 0.00067615509033203
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.0002591609954834
(432) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '70352') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0051767826080322
(433) DESCRIBE `avid_specials` 0.00073885917663574
(434) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70352 and class = 'Cruise') OR (item_id = 674 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 37 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010659694671631
(435) DESCRIBE `cruiselines` 0.0010108947753906
(436) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0002291202545166
(437) DESCRIBE `orchid_image` 0.00078701972961426
(438) DESCRIBE `cruiselines` 0.00095391273498535
(439) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00018596649169922
(440) DESCRIBE `cruises` 0.0013620853424072
(441) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67961') 0.00021791458129883
(442) DESCRIBE `ships` 0.0013039112091064
(443) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 977))) 0.0002739429473877
(444) DESCRIBE `ships` 0.0017359256744385
(445) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '977') 0.00030994415283203
(446) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023508071899414
(447) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025415420532227
(448) DESCRIBE `itineraries` 0.001107931137085
(449) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67961') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00061488151550293
(450) DESCRIBE `ports` 0.00085997581481934
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00023698806762695
(452) DESCRIBE `ports` 0.00069308280944824
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00020813941955566
(454) DESCRIBE `ports` 0.00068402290344238
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00018692016601562
(456) DESCRIBE `sailingdates` 0.00061702728271484
(457) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67961') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00059103965759277
(458) DESCRIBE `ports` 0.001093864440918
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00027084350585938
(460) DESCRIBE `ports` 0.00067496299743652
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.0001990795135498
(462) DESCRIBE `ports` 0.00068187713623047
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00020980834960938
(464) DESCRIBE `ports` 0.00066709518432617
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00020408630371094
(466) DESCRIBE `ports` 0.00074100494384766
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00020408630371094
(468) DESCRIBE `ports` 0.00068402290344238
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00018405914306641
(470) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '67961') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.004349946975708
(471) DESCRIBE `avid_specials` 0.00071907043457031
(472) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67961 and class = 'Cruise') OR (item_id = 977 AND class = 'Ship') OR (item_id = 19 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.0010988712310791
(473) DESCRIBE `cruiselines` 0.00098013877868652
(474) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00022602081298828
(475) DESCRIBE `orchid_image` 0.00074195861816406
(476) DESCRIBE `cruiselines` 0.00091195106506348
(477) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00019001960754395
(478) DESCRIBE `cruises` 0.0013458728790283
(479) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62663') 0.00020599365234375
(480) DESCRIBE `ships` 0.0012750625610352
(481) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00031089782714844
(482) DESCRIBE `ships` 0.0013399124145508
(483) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00020098686218262
(484) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017690658569336
(485) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016903877258301
(486) DESCRIBE `itineraries` 0.00073814392089844
(487) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62663') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00048995018005371
(488) DESCRIBE `ports` 0.0014150142669678
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.0003049373626709
(490) DESCRIBE `ports` 0.0010111331939697
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00027799606323242
(492) DESCRIBE `ports` 0.00075292587280273
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.0001988410949707
(494) DESCRIBE `sailingdates` 0.0006110668182373
(495) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62663') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00064396858215332
(496) DESCRIBE `ports` 0.0010709762573242
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00037312507629395
(498) DESCRIBE `ports` 0.00073099136352539
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00020694732666016
(500) DESCRIBE `ports` 0.0006718635559082
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00021505355834961
(502) DESCRIBE `ports` 0.00071287155151367
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00020408630371094
(504) DESCRIBE `ports` 0.0006711483001709
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020503997802734
(506) DESCRIBE `ports` 0.00071620941162109
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00019288063049316
(508) DESCRIBE `ports` 0.00071287155151367
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00020503997802734
(510) DESCRIBE `ports` 0.0006711483001709
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00018906593322754
(512) DESCRIBE `ports` 0.00070381164550781
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00021100044250488
(514) DESCRIBE `ports` 0.00066804885864258
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00018310546875
(516) DESCRIBE `ports` 0.00066399574279785
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020599365234375
(518) DESCRIBE `ports` 0.00070309638977051
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018405914306641
(520) DESCRIBE `ports` 0.00067305564880371
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00022387504577637
(522) DESCRIBE `ports` 0.00084590911865234
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00022196769714355
(524) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62663') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0044169425964355
(525) DESCRIBE `avid_specials` 0.00072693824768066
(526) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62663 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 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.0011701583862305
(527) DESCRIBE `cruiselines` 0.0010910034179688
(528) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00028300285339355
(529) DESCRIBE `orchid_image` 0.00082302093505859
(530) DESCRIBE `cruiselines` 0.00093293190002441
(531) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00020384788513184
(532) DESCRIBE `ships` 0.0016911029815674
(533) SELECT `ships`.* FROM `ships` WHERE (id IN ('977', '1359', '1067', '726', '407', '766', '1588', '452', '462', '553', '1415', '610', '674', '738', '1599')) ORDER BY FIND_IN_SET(id, '977,1359,1067,726,407,766,1588,452,462,553,1415,610,674,738,1599') 0.0008699893951416
(534) DESCRIBE `cruisetypes` 0.0007328987121582
(535) DESCRIBE `destinations` 0.00095200538635254
(536) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '28', '25', '26', '52', '45', '40', '38', '21', '35', '49', '37')) ORDER BY FIND_IN_SET(id, '22,12,28,25,26,52,45,40,38,21,35,49,37') 0.00082302093505859
(537) DESCRIBE `cruiselines` 0.001021146774292
(538) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00023603439331055
(539) DESCRIBE `cruiselines` 0.0014781951904297
(540) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00029897689819336