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

 
  • Meraviglia, Italy Malta Spain France ex Messina Return

    Nights 7 Ship MSC Meraviglia
    Star Rating 4 Star Departs Messina, Sicily. IT
    Sailing 2017: 24 Oct, 31 Oct, 7 Nov
    Ports of Call Messina, Valletta, Barcelona, Marseilles, Genoa, Naples
    Please enquire about this cruise for pricing.
     
    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.
  • Magnifica, Italy Spain Morocco Portugal France ex Marseilles Return

    Nights 9 Ship MSC Magnifica
    Star Rating 4 Star Departs Marseilles, France
    Sailing 2017: 25 Oct
    Ports of Call Marseilles, Genoa, Malaga, Casablanca, Lisbon, Barcelona
    Please enquire about this cruise for pricing.
     
    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.
  • Magnifica, Italy Spain Morocco Portugal France ex Genoa Return

    Nights 9 Ship MSC Magnifica
    Star Rating 4 Star Departs Genoa, Italy
    Sailing 2017: 26 Oct
    Ports of Call Genoa, Malaga, Casablanca, Lisbon, Barcelona, Marseilles
    Please enquire about this cruise for pricing.
     
    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.
  • Splendida, Spain, France, Italy ex Valencia Return

    Nights 7 Ship MSC Splendida
    Star Rating 4 Star Departs Valencia, Spain
    Sailing 2017: 26 Oct
    Ports of Call Valencia, Marseilles, Genoa, Rome (Civitavecchia), Palermo, Cagliari, Palma
    Please enquire about this cruise for pricing.
     
    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.
  • Armonia, Italy France Spain Malta ex Messina Roundtrip

    Nights 7 Ship MSC Armonia
    Star Rating 4 Star Departs Messina, Sicily. IT
    Sailing 2017: 26 Oct
    Ports of Call Messina, Naples, Genoa, Marseilles, Mahon, Cagliari, Valletta
    Please enquire about this cruise for pricing.
     
    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, Spain France Italy Malta ex Barcelona Return

    Nights 7 Ship MSC Meraviglia
    Star Rating 4 Star Departs Barcelona, Spain
    Sailing 2017: 27 Oct, 3 Nov, 10 Nov
    Ports of Call Barcelona, Marseilles, Genoa, Naples, Messina, Valletta

    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.
  • Splendida, France, Italy, Spain ex Marseille Return

    Nights 7 Ship MSC Splendida
    Star Rating 4 Star Departs Marseilles, France
    Sailing 2017: 27 Oct
    Ports of Call Marseilles, Genoa, Rome (Civitavecchia), Palermo, Cagliari, Palma, Valencia
    Please enquire about this cruise for pricing.
     
    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.
  • Armonia, Italy France Spain Malta ex Naples Roundtrip

    Nights 7 Ship MSC Armonia
    Star Rating 4 Star Departs Naples, Italy
    Sailing 2017: 27 Oct
    Ports of Call Naples, Genoa, Marseilles, Mahon, Cagliari, Valletta, Messina
    Please enquire about this cruise for pricing.
     
    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.
  • Preziosa, Italy Spain France ex Genoa Return

    Nights 5 Ship MSC Preziosa
    Star Rating 4 Star Departs Genoa, Italy
    Sailing 2017: 27 Oct
    Ports of Call Genoa, Barcelona, Mallorca, Marseilles
    Please enquire about this cruise for pricing.
     
    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.
  • Armonia & Sinfonia, Grand Mediterranean ex Genoa to Venice

    Nights 14 Ship MSC Armonia
    Star Rating 4 Star Departs Genoa, Italy
    Sailing 2017: 28 Oct
    Ports of Call Genoa, Marseilles, Mahon, Cagliari, Valletta, Messina, Naples, Venice, Split, Santorini, Mykonos, Dubrovnik, Ancona
    Please enquire about this cruise for pricing.
     
    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: 588

Total elapsed time: 0.33942127227783

# Query Time
(1) connect 0.00068998336791992
(2) DESCRIBE `cruises` 0.0016980171203613
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (56914, 70281, 62645, 62679, 70215, 56915, 62677, 62846, 52332, 64474)) ORDER BY FIND_IN_SET(id, '56914,70281,62645,62679,70215,56915,62677,62846,52332,64474') 0.0011780261993408
(4) DESCRIBE `cruises` 0.0015130043029785
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56914') 0.00025606155395508
(6) DESCRIBE `ships` 0.0012938976287842
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00028085708618164
(8) DESCRIBE `ships` 0.001554012298584
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00019598007202148
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017309188842773
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017809867858887
(12) DESCRIBE `itineraries` 0.00066280364990234
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '56914') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0006260871887207
(14) DESCRIBE `ports` 0.0010509490966797
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00029993057250977
(16) DESCRIBE `ports` 0.00067281723022461
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.0001990795135498
(18) DESCRIBE `ports` 0.0013539791107178
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00037097930908203
(20) DESCRIBE `sailingdates` 0.00073599815368652
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '56914') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00061511993408203
(22) DESCRIBE `ports` 0.00087308883666992
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00025200843811035
(24) DESCRIBE `ports` 0.00074100494384766
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00024819374084473
(26) DESCRIBE `ports` 0.0010349750518799
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.0002739429473877
(28) DESCRIBE `ports` 0.00080490112304688
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00022101402282715
(30) DESCRIBE `ports` 0.00076198577880859
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00025296211242676
(32) DESCRIBE `ports` 0.00076699256896973
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0002291202545166
(34) DESCRIBE `ports` 0.00081110000610352
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00026106834411621
(36) DESCRIBE `ports` 0.00076603889465332
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00024795532226562
(38) DESCRIBE `ports` 0.00083780288696289
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00029397010803223
(40) DESCRIBE `ports` 0.00080204010009766
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00022196769714355
(42) DESCRIBE `ports` 0.00077605247497559
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00029897689819336
(44) DESCRIBE `ports` 0.00078988075256348
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00022101402282715
(46) DESCRIBE `ports` 0.00077104568481445
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00027203559875488
(48) DESCRIBE `ports` 0.00079703330993652
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00023198127746582
(50) DESCRIBE `avid_specials` 0.00075697898864746
(51) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56914 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.0012061595916748
(52) DESCRIBE `cruiselines` 0.001154899597168
(53) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00030899047851562
(54) DESCRIBE `orchid_image` 0.00093197822570801
(55) DESCRIBE `cruiselines` 0.0011382102966309
(56) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00026607513427734
(57) DESCRIBE `cruises` 0.0014917850494385
(58) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70281') 0.00029706954956055
(59) DESCRIBE `ships` 0.0014801025390625
(60) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 766))) 0.00035786628723145
(61) DESCRIBE `ships` 0.0015480518341064
(62) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '766') 0.00027012825012207
(63) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018191337585449
(64) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017404556274414
(65) DESCRIBE `itineraries` 0.00079894065856934
(66) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70281') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00066089630126953
(67) DESCRIBE `ports` 0.00096511840820312
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.0003201961517334
(69) DESCRIBE `ports` 0.0008089542388916
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.0002591609954834
(71) DESCRIBE `ports` 0.0007939338684082
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00024580955505371
(73) DESCRIBE `sailingdates` 0.00073409080505371
(74) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70281') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00062298774719238
(75) DESCRIBE `ports` 0.00097203254699707
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00027322769165039
(77) DESCRIBE `ports` 0.0008080005645752
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.0002439022064209
(79) DESCRIBE `ports` 0.00078296661376953
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00024890899658203
(81) DESCRIBE `ports` 0.00080490112304688
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00023818016052246
(83) DESCRIBE `ports` 0.0007789134979248
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.0002281665802002
(85) DESCRIBE `ports` 0.00071096420288086
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00020503997802734
(87) DESCRIBE `ports` 0.00074100494384766
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 69))) 0.00022697448730469
(89) DESCRIBE `ports` 0.00074601173400879
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '69') 0.0001978874206543
(91) DESCRIBE `ports` 0.00069594383239746
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.0002129077911377
(93) DESCRIBE `ports` 0.00069618225097656
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00020194053649902
(95) DESCRIBE `ports` 0.00068998336791992
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00022196769714355
(97) DESCRIBE `ports` 0.00069689750671387
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00020217895507812
(99) DESCRIBE `ports` 0.00069713592529297
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00020694732666016
(101) DESCRIBE `ports` 0.00067305564880371
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00018000602722168
(103) DESCRIBE `avid_specials` 0.00072598457336426
(104) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70281 and class = 'Cruise') OR (item_id = 766 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.001166820526123
(105) DESCRIBE `cruiselines` 0.0010218620300293
(106) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00022697448730469
(107) DESCRIBE `orchid_image` 0.00083589553833008
(108) DESCRIBE `cruiselines` 0.0010879039764404
(109) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0002281665802002
(110) DESCRIBE `cruises` 0.001478910446167
(111) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62645') 0.00033211708068848
(112) DESCRIBE `ships` 0.0016069412231445
(113) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 766))) 0.00031089782714844
(114) DESCRIBE `ships` 0.00136399269104
(115) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '766') 0.0002288818359375
(116) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017714500427246
(117) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016403198242188
(118) DESCRIBE `itineraries` 0.00072097778320312
(119) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62645') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00058293342590332
(120) DESCRIBE `ports` 0.0013349056243896
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00029420852661133
(122) DESCRIBE `ports` 0.00079178810119629
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00023388862609863
(124) DESCRIBE `ports` 0.000762939453125
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00022006034851074
(126) DESCRIBE `sailingdates` 0.00070786476135254
(127) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62645') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0006098747253418
(128) DESCRIBE `ports` 0.0010950565338135
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00031399726867676
(130) DESCRIBE `ports` 0.0008549690246582
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00022792816162109
(132) DESCRIBE `ports` 0.00072407722473145
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00022315979003906
(134) DESCRIBE `ports` 0.00069689750671387
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.0001990795135498
(136) DESCRIBE `ports` 0.00072193145751953
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 69))) 0.00021696090698242
(138) DESCRIBE `ports` 0.00069999694824219
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '69') 0.00018882751464844
(140) DESCRIBE `ports` 0.00067901611328125
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00021195411682129
(142) DESCRIBE `ports` 0.00071215629577637
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00019598007202148
(144) DESCRIBE `ports` 0.00067782402038574
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00021004676818848
(146) DESCRIBE `ports` 0.00069308280944824
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00020694732666016
(148) DESCRIBE `ports` 0.00068402290344238
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.0002131462097168
(150) DESCRIBE `ports` 0.0007169246673584
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00019407272338867
(152) DESCRIBE `ports` 0.00084805488586426
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00027608871459961
(154) DESCRIBE `ports` 0.00076985359191895
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00021004676818848
(156) DESCRIBE `avid_specials` 0.00067496299743652
(157) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62645 and class = 'Cruise') OR (item_id = 766 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.0011539459228516
(158) DESCRIBE `cruiselines` 0.0011029243469238
(159) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00028896331787109
(160) DESCRIBE `orchid_image` 0.00088310241699219
(161) DESCRIBE `cruiselines` 0.0010488033294678
(162) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00022387504577637
(163) DESCRIBE `cruises` 0.0013790130615234
(164) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62679') 0.00024890899658203
(165) DESCRIBE `ships` 0.0013601779937744
(166) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 738))) 0.00039792060852051
(167) DESCRIBE `ships` 0.0019888877868652
(168) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '738') 0.00042915344238281
(169) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002281665802002
(170) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022006034851074
(171) DESCRIBE `itineraries` 0.00098395347595215
(172) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62679') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00063014030456543
(173) DESCRIBE `ports` 0.0010209083557129
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00026488304138184
(175) DESCRIBE `ports` 0.00073003768920898
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00022506713867188
(177) DESCRIBE `ports` 0.00076508522033691
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00021100044250488
(179) DESCRIBE `sailingdates` 0.0006568431854248
(180) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62679') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00044798851013184
(181) DESCRIBE `ports` 0.00079488754272461
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00023388862609863
(183) DESCRIBE `ports` 0.00071501731872559
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.0002138614654541
(185) DESCRIBE `ports` 0.00071382522583008
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00022697448730469
(187) DESCRIBE `ports` 0.00074100494384766
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.0001990795135498
(189) DESCRIBE `ports` 0.00069618225097656
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00022792816162109
(191) DESCRIBE `ports` 0.00072598457336426
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00020813941955566
(193) DESCRIBE `ports` 0.00071382522583008
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00022006034851074
(195) DESCRIBE `ports` 0.00070810317993164
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00020194053649902
(197) DESCRIBE `ports` 0.00073480606079102
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00022506713867188
(199) DESCRIBE `ports` 0.00070714950561523
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00020503997802734
(201) DESCRIBE `ports` 0.00070810317993164
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.0002131462097168
(203) DESCRIBE `ports` 0.00068497657775879
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00019097328186035
(205) DESCRIBE `ports` 0.00068306922912598
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00027012825012207
(207) DESCRIBE `ports` 0.00092196464538574
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00021219253540039
(209) DESCRIBE `ports` 0.00074601173400879
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00024604797363281
(211) DESCRIBE `ports` 0.00073695182800293
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00025010108947754
(213) DESCRIBE `avid_specials` 0.00064301490783691
(214) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62679 and class = 'Cruise') OR (item_id = 738 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.0012199878692627
(215) DESCRIBE `cruiselines` 0.001039981842041
(216) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00024890899658203
(217) DESCRIBE `orchid_image` 0.00081586837768555
(218) DESCRIBE `cruiselines` 0.00098586082458496
(219) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00021982192993164
(220) DESCRIBE `cruises` 0.0013680458068848
(221) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70215') 0.00026988983154297
(222) DESCRIBE `ships` 0.0013730525970459
(223) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 452))) 0.00032210350036621
(224) DESCRIBE `ships` 0.0015799999237061
(225) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '452') 0.00027894973754883
(226) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019502639770508
(227) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017786026000977
(228) DESCRIBE `itineraries` 0.00079202651977539
(229) DESCRIBE `ports` 0.00081014633178711
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00028014183044434
(231) DESCRIBE `ports` 0.00078678131103516
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00025081634521484
(233) DESCRIBE `ports` 0.00077581405639648
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00022220611572266
(235) DESCRIBE `sailingdates` 0.00073814392089844
(236) DESCRIBE `ports` 0.00083088874816895
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00026798248291016
(238) DESCRIBE `ports` 0.0008080005645752
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00021505355834961
(240) DESCRIBE `ports` 0.00072908401489258
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.0003809928894043
(242) DESCRIBE `ports` 0.00091195106506348
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00023317337036133
(244) DESCRIBE `ports` 0.00076985359191895
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00024890899658203
(246) DESCRIBE `ports` 0.00077605247497559
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00025296211242676
(248) DESCRIBE `ports` 0.00078701972961426
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00025701522827148
(250) DESCRIBE `ports` 0.00083804130554199
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00023603439331055
(252) DESCRIBE `ports` 0.00078105926513672
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00023293495178223
(254) DESCRIBE `ports` 0.00074005126953125
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00030899047851562
(256) DESCRIBE `ports` 0.00075697898864746
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00027799606323242
(258) DESCRIBE `ports` 0.00089478492736816
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00034785270690918
(260) DESCRIBE `ports` 0.00086092948913574
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00021600723266602
(262) DESCRIBE `ports` 0.000701904296875
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.0001838207244873
(264) DESCRIBE `ports` 0.00068092346191406
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00020694732666016
(266) DESCRIBE `ports` 0.00067996978759766
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00019598007202148
(268) DESCRIBE `avid_specials` 0.00062203407287598
(269) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70215 and class = 'Cruise') OR (item_id = 452 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.0011157989501953
(270) DESCRIBE `cruiselines` 0.00097203254699707
(271) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00022578239440918
(272) DESCRIBE `orchid_image` 0.00078296661376953
(273) DESCRIBE `cruiselines` 0.0010371208190918
(274) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00020408630371094
(275) DESCRIBE `cruises` 0.0013010501861572
(276) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56915') 0.00022602081298828
(277) DESCRIBE `ships` 0.0012609958648682
(278) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00027585029602051
(279) DESCRIBE `ships` 0.0012750625610352
(280) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00019001960754395
(281) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(282) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017404556274414
(283) DESCRIBE `itineraries` 0.00065183639526367
(284) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '56915') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00039100646972656
(285) DESCRIBE `ports` 0.00070595741271973
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00021219253540039
(287) DESCRIBE `ports` 0.00066995620727539
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020384788513184
(289) DESCRIBE `ports` 0.00067996978759766
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0001838207244873
(291) DESCRIBE `sailingdates` 0.00060296058654785
(292) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '56915') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00036907196044922
(293) DESCRIBE `ports` 0.001121997833252
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00033807754516602
(295) DESCRIBE `ports` 0.0009150505065918
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00025105476379395
(297) DESCRIBE `ports` 0.00070714950561523
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00021696090698242
(299) DESCRIBE `ports` 0.0007171630859375
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00018596649169922
(301) DESCRIBE `ports` 0.0006709098815918
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00020503997802734
(303) DESCRIBE `ports` 0.00066614151000977
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00018405914306641
(305) DESCRIBE `ports` 0.00077009201049805
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00020194053649902
(307) DESCRIBE `ports` 0.00066709518432617
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00018405914306641
(309) DESCRIBE `ports` 0.00069713592529297
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00020098686218262
(311) DESCRIBE `ports` 0.00066494941711426
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00023698806762695
(313) DESCRIBE `ports` 0.00072002410888672
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00019979476928711
(315) DESCRIBE `ports` 0.00069308280944824
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00021791458129883
(317) DESCRIBE `ports` 0.00073814392089844
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00021100044250488
(319) DESCRIBE `ports` 0.00070691108703613
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018501281738281
(321) DESCRIBE `avid_specials` 0.00066089630126953
(322) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56915 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.0011720657348633
(323) DESCRIBE `cruiselines` 0.0010139942169189
(324) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00022602081298828
(325) DESCRIBE `orchid_image` 0.00076389312744141
(326) DESCRIBE `cruiselines` 0.00092506408691406
(327) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00018811225891113
(328) DESCRIBE `cruises` 0.0013940334320068
(329) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62677') 0.00021886825561523
(330) DESCRIBE `ships` 0.001270055770874
(331) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 738))) 0.00029683113098145
(332) DESCRIBE `ships` 0.0012800693511963
(333) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '738') 0.00018882751464844
(334) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018715858459473
(335) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017786026000977
(336) DESCRIBE `itineraries` 0.00066304206848145
(337) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62677') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00037002563476562
(338) DESCRIBE `ports` 0.000701904296875
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00022506713867188
(340) DESCRIBE `ports` 0.0006709098815918
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00020098686218262
(342) DESCRIBE `ports` 0.00069713592529297
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00019192695617676
(344) DESCRIBE `sailingdates` 0.00060796737670898
(345) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62677') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00042104721069336
(346) DESCRIBE `ports` 0.00078201293945312
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00022792816162109
(348) DESCRIBE `ports` 0.00070810317993164
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00018787384033203
(350) DESCRIBE `ports` 0.0006718635559082
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00020289421081543
(352) DESCRIBE `ports` 0.00069808959960938
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00018501281738281
(354) DESCRIBE `ports` 0.0006709098815918
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020194053649902
(356) DESCRIBE `ports` 0.00066804885864258
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018405914306641
(358) DESCRIBE `ports` 0.00067710876464844
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00020694732666016
(360) DESCRIBE `ports` 0.00071501731872559
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00019121170043945
(362) DESCRIBE `ports` 0.0006709098815918
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00020790100097656
(364) DESCRIBE `ports` 0.00071001052856445
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00018811225891113
(366) DESCRIBE `ports` 0.00071907043457031
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00021004676818848
(368) DESCRIBE `ports` 0.0006718635559082
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00018692016601562
(370) DESCRIBE `ports` 0.00066804885864258
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00020289421081543
(372) DESCRIBE `ports` 0.00069618225097656
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00019001960754395
(374) DESCRIBE `ports` 0.00069618225097656
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00023603439331055
(376) DESCRIBE `ports` 0.00069904327392578
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00019001960754395
(378) DESCRIBE `avid_specials` 0.00061607360839844
(379) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62677 and class = 'Cruise') OR (item_id = 738 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.0011088848114014
(380) DESCRIBE `cruiselines` 0.0010159015655518
(381) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00030803680419922
(382) DESCRIBE `orchid_image` 0.00086498260498047
(383) DESCRIBE `cruiselines` 0.00094008445739746
(384) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00021910667419434
(385) DESCRIBE `cruises` 0.0013110637664795
(386) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62846') 0.00022697448730469
(387) DESCRIBE `ships` 0.001291036605835
(388) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 452))) 0.00027894973754883
(389) DESCRIBE `ships` 0.001568078994751
(390) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '452') 0.00020790100097656
(391) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(392) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017404556274414
(393) DESCRIBE `itineraries` 0.00067687034606934
(394) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62846') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00063419342041016
(395) DESCRIBE `ports` 0.00071907043457031
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00022006034851074
(397) DESCRIBE `ports` 0.00074410438537598
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00020718574523926
(399) DESCRIBE `ports` 0.00068187713623047
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00018596649169922
(401) DESCRIBE `sailingdates` 0.00060296058654785
(402) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62846') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00039291381835938
(403) DESCRIBE `ports` 0.00071907043457031
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00020194053649902
(405) DESCRIBE `ports` 0.00067687034606934
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00020885467529297
(407) DESCRIBE `ports` 0.00073480606079102
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00022101402282715
(409) DESCRIBE `ports` 0.000701904296875
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00018405914306641
(411) DESCRIBE `ports` 0.00070881843566895
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00020098686218262
(413) DESCRIBE `ports` 0.00069713592529297
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00018405914306641
(415) DESCRIBE `ports` 0.00067901611328125
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.0002598762512207
(417) DESCRIBE `ports` 0.00068092346191406
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00018692016601562
(419) DESCRIBE `ports` 0.00068497657775879
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00020098686218262
(421) DESCRIBE `ports` 0.00070405006408691
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00018501281738281
(423) DESCRIBE `ports` 0.00073003768920898
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00020408630371094
(425) DESCRIBE `ports` 0.00073504447937012
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00019097328186035
(427) DESCRIBE `ports` 0.0006859302520752
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.0002288818359375
(429) DESCRIBE `ports` 0.00068402290344238
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00018501281738281
(431) DESCRIBE `ports` 0.00075387954711914
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00020599365234375
(433) DESCRIBE `ports` 0.00068998336791992
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00018692016601562
(435) DESCRIBE `avid_specials` 0.0006098747253418
(436) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62846 and class = 'Cruise') OR (item_id = 452 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.0011570453643799
(437) DESCRIBE `cruiselines` 0.001046895980835
(438) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00023889541625977
(439) DESCRIBE `orchid_image` 0.00078415870666504
(440) DESCRIBE `cruiselines` 0.00094795227050781
(441) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00021004676818848
(442) DESCRIBE `cruises` 0.0013880729675293
(443) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52332') 0.00022697448730469
(444) DESCRIBE `ships` 0.0013680458068848
(445) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1067))) 0.00030398368835449
(446) DESCRIBE `ships` 0.0013008117675781
(447) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1067') 0.00019693374633789
(448) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018405914306641
(449) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017404556274414
(450) DESCRIBE `itineraries` 0.00066995620727539
(451) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '52332') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00049614906311035
(452) DESCRIBE `ports` 0.00077009201049805
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00022697448730469
(454) DESCRIBE `ports` 0.00067996978759766
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00020694732666016
(456) DESCRIBE `ports` 0.00068402290344238
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00019502639770508
(458) DESCRIBE `sailingdates` 0.00060892105102539
(459) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '52332') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00046396255493164
(460) DESCRIBE `ports` 0.00078105926513672
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00036907196044922
(462) DESCRIBE `ports` 0.00088691711425781
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00023388862609863
(464) DESCRIBE `ports` 0.00078105926513672
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00024294853210449
(466) DESCRIBE `ports` 0.00075006484985352
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00021696090698242
(468) DESCRIBE `ports` 0.00080013275146484
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.0002589225769043
(470) DESCRIBE `ports` 0.00081682205200195
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00031495094299316
(472) DESCRIBE `ports` 0.00083804130554199
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00036311149597168
(474) DESCRIBE `ports` 0.0009458065032959
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00030803680419922
(476) DESCRIBE `ports` 0.0010180473327637
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.0003211498260498
(478) DESCRIBE `ports` 0.0010490417480469
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00027608871459961
(480) DESCRIBE `ports` 0.00082802772521973
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00033187866210938
(482) DESCRIBE `ports` 0.00094795227050781
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00029182434082031
(484) DESCRIBE `avid_specials` 0.00090503692626953
(485) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 52332 and class = 'Cruise') OR (item_id = 1067 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.0014219284057617
(486) DESCRIBE `cruiselines` 0.0012919902801514
(487) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00038003921508789
(488) DESCRIBE `orchid_image` 0.00094103813171387
(489) DESCRIBE `cruiselines` 0.001147985458374
(490) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00026297569274902
(491) DESCRIBE `cruises` 0.0015878677368164
(492) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64474') 0.00034213066101074
(493) DESCRIBE `ships` 0.0014729499816895
(494) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 452))) 0.00035500526428223
(495) DESCRIBE `ships` 0.0014932155609131
(496) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '452') 0.00028204917907715
(497) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019097328186035
(498) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017595291137695
(499) DESCRIBE `itineraries` 0.00086593627929688
(500) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64474') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00065088272094727
(501) DESCRIBE `ports` 0.0010049343109131
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00028896331787109
(503) DESCRIBE `ports` 0.00078296661376953
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00023198127746582
(505) DESCRIBE `ports` 0.0007479190826416
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00021815299987793
(507) DESCRIBE `sailingdates` 0.00068998336791992
(508) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64474') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00047707557678223
(509) DESCRIBE `ports` 0.00085091590881348
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00028085708618164
(511) DESCRIBE `ports` 0.00077009201049805
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.0002138614654541
(513) DESCRIBE `ports` 0.00074505805969238
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00025105476379395
(515) DESCRIBE `ports` 0.00077104568481445
(516) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00023698806762695
(517) DESCRIBE `ports` 0.0007481575012207
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.000244140625
(519) DESCRIBE `ports` 0.00079488754272461
(520) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00022196769714355
(521) DESCRIBE `ports` 0.00081086158752441
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00024199485778809
(523) DESCRIBE `ports` 0.00081205368041992
(524) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.0002129077911377
(525) DESCRIBE `ports` 0.00074982643127441
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.0002288818359375
(527) DESCRIBE `ports` 0.00072503089904785
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00023293495178223
(529) DESCRIBE `ports` 0.00073599815368652
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.0002448558807373
(531) DESCRIBE `ports` 0.00076699256896973
(532) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00023508071899414
(533) DESCRIBE `ports` 0.00078392028808594
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00023698806762695
(535) DESCRIBE `ports` 0.00079107284545898
(536) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00025701522827148
(537) DESCRIBE `ports` 0.00079584121704102
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00026202201843262
(539) DESCRIBE `ports` 0.00075483322143555
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00021505355834961
(541) DESCRIBE `ports` 0.00073599815368652
(542) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00024294853210449
(543) DESCRIBE `ports` 0.00077486038208008
(544) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00020408630371094
(545) DESCRIBE `ports` 0.00072908401489258
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00033783912658691
(547) DESCRIBE `ports` 0.00081491470336914
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00022506713867188
(549) DESCRIBE `ports` 0.00077199935913086
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00030803680419922
(551) DESCRIBE `ports` 0.00081801414489746
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.0002899169921875
(553) DESCRIBE `ports` 0.0008089542388916
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00025200843811035
(555) DESCRIBE `ports` 0.00075602531433105
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00021886825561523
(557) DESCRIBE `ports` 0.00074386596679688
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00024819374084473
(559) DESCRIBE `ports` 0.00084614753723145
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00025105476379395
(561) DESCRIBE `ports` 0.00077390670776367
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00024890899658203
(563) DESCRIBE `ports` 0.0009307861328125
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00031900405883789
(565) DESCRIBE `ports` 0.00088095664978027
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 923))) 0.00025320053100586
(567) DESCRIBE `ports` 0.00078201293945312
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '923') 0.0002129077911377
(569) DESCRIBE `ports` 0.00078415870666504
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0002591609954834
(571) DESCRIBE `ports` 0.00080204010009766
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00023102760314941
(573) DESCRIBE `avid_specials` 0.00071310997009277
(574) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64474 and class = 'Cruise') OR (item_id = 452 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.0012180805206299
(575) DESCRIBE `cruiselines` 0.0011920928955078
(576) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00034999847412109
(577) DESCRIBE `orchid_image` 0.00095200538635254
(578) DESCRIBE `cruiselines` 0.0011670589447021
(579) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00028491020202637
(580) DESCRIBE `ships` 0.0017211437225342
(581) SELECT `ships`.* FROM `ships` WHERE (id IN ('1359', '977', '726', '1067', '452', '1599', '462', '407', '766', '1415', '553', '1588', '610', '674', '738')) ORDER BY FIND_IN_SET(id, '1359,977,726,1067,452,1599,462,407,766,1415,553,1588,610,674,738') 0.00097799301147461
(582) DESCRIBE `cruisetypes` 0.00093483924865723
(583) DESCRIBE `destinations` 0.001129150390625
(584) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '52', '28', '25', '26', '37', '45', '38', '40', '21', '35', '49', '48')) ORDER BY FIND_IN_SET(id, '22,12,52,28,25,26,37,45,38,40,21,35,49,48') 0.00096011161804199
(585) DESCRIBE `cruiselines` 0.0012218952178955
(586) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00030398368835449
(587) DESCRIBE `cruiselines` 0.0011720657348633
(588) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00027012825012207