or, enquire about your chosen options

  1. Holland America’s View and Veranda promotion is back!!
  2. The Big Laugh Comedy Festival Cruise
  3. Catch up on Cruising: Latest news in bite size
  4. Meet the Cruise Factor Team – Don
  5. Catch up on Cruising: Latest news in bite size

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

 
  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

 

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

Total elapsed time: 0.36329531669617

# Query Time
(1) connect 0.00069499015808105
(2) DESCRIBE `cruises` 0.0016739368438721
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (62661, 70236, 62666, 62662, 68527, 70352, 64926, 62667, 67961, 62663)) ORDER BY FIND_IN_SET(id, '62661,70236,62666,62662,68527,70352,64926,62667,67961,62663') 0.0011188983917236
(4) DESCRIBE `cruises` 0.0015740394592285
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62661') 0.00025296211242676
(6) DESCRIBE `ships` 0.0012800693511963
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00029897689819336
(8) DESCRIBE `ships` 0.0013220310211182
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.0001990795135498
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016212463378906
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015091896057129
(12) DESCRIBE `itineraries` 0.0006110668182373
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62661') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0007328987121582
(14) DESCRIBE `ports` 0.0009610652923584
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00024795532226562
(16) DESCRIBE `ports` 0.0007169246673584
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00022983551025391
(18) DESCRIBE `ports` 0.00065493583679199
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00018787384033203
(20) DESCRIBE `sailingdates` 0.0005950927734375
(21) DESCRIBE `ports` 0.00099086761474609
(22) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00025200843811035
(23) DESCRIBE `ports` 0.00067806243896484
(24) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.0002439022064209
(25) DESCRIBE `ports` 0.00068211555480957
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00022506713867188
(27) DESCRIBE `ports` 0.00065398216247559
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0001988410949707
(29) DESCRIBE `ports` 0.00075602531433105
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.0002131462097168
(31) DESCRIBE `ports` 0.00062704086303711
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00018119812011719
(33) DESCRIBE `ports` 0.00077199935913086
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00019598007202148
(35) DESCRIBE `ports` 0.00062203407287598
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00021696090698242
(37) DESCRIBE `ports` 0.00062799453735352
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020194053649902
(39) DESCRIBE `ports` 0.0006098747253418
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00017213821411133
(41) DESCRIBE `ports` 0.00075602531433105
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00019502639770508
(43) DESCRIBE `ports` 0.00059294700622559
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00016307830810547
(45) DESCRIBE `ports` 0.00064206123352051
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00018596649169922
(47) DESCRIBE `ports` 0.0005950927734375
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00015997886657715
(49) 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.0074129104614258
(50) DESCRIBE `avid_specials` 0.00070595741271973
(51) 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.0010871887207031
(52) DESCRIBE `cruiselines` 0.0010161399841309
(53) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00024795532226562
(54) DESCRIBE `orchid_image` 0.00077199935913086
(55) DESCRIBE `cruiselines` 0.0013480186462402
(56) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00028610229492188
(57) DESCRIBE `cruises` 0.0020740032196045
(58) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70236') 0.00033402442932129
(59) DESCRIBE `ships` 0.0019140243530273
(60) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 726))) 0.00034499168395996
(61) DESCRIBE `ships` 0.0020489692687988
(62) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '726') 0.00030708312988281
(63) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020194053649902
(64) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019693374633789
(65) DESCRIBE `itineraries` 0.00098299980163574
(66) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70236') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00075507164001465
(67) DESCRIBE `ports` 0.0010299682617188
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00029277801513672
(69) DESCRIBE `ports` 0.000885009765625
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00021100044250488
(71) DESCRIBE `ports` 0.0006260871887207
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00017905235290527
(73) DESCRIBE `sailingdates` 0.0005340576171875
(74) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70236') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00062704086303711
(75) DESCRIBE `ports` 0.0006561279296875
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.0001978874206543
(77) DESCRIBE `ports` 0.00059294700622559
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.0001678466796875
(79) DESCRIBE `ports` 0.00068402290344238
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00018095970153809
(81) DESCRIBE `ports` 0.00063014030456543
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00016307830810547
(83) DESCRIBE `ports` 0.00064301490783691
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00018191337585449
(85) DESCRIBE `ports` 0.00060319900512695
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00016403198242188
(87) DESCRIBE `ports` 0.00060486793518066
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 55))) 0.00017809867858887
(89) DESCRIBE `ports` 0.00058484077453613
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '55') 0.00015997886657715
(91) DESCRIBE `ports` 0.0005791187286377
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 308))) 0.00018692016601562
(93) DESCRIBE `ports` 0.00058603286743164
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '308') 0.00015997886657715
(95) DESCRIBE `ports` 0.00058603286743164
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00017905235290527
(97) DESCRIBE `ports` 0.00058293342590332
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00015902519226074
(99) DESCRIBE `ports` 0.00059795379638672
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00018095970153809
(101) DESCRIBE `ports` 0.0006401538848877
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00016021728515625
(103) DESCRIBE `ports` 0.00058102607727051
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00018501281738281
(105) DESCRIBE `ports` 0.00060296058654785
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00016307830810547
(107) 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.0045990943908691
(108) DESCRIBE `avid_specials` 0.00062799453735352
(109) 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.0008690357208252
(110) DESCRIBE `cruiselines` 0.00087594985961914
(111) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00021004676818848
(112) DESCRIBE `orchid_image` 0.00066804885864258
(113) DESCRIBE `cruiselines` 0.00082707405090332
(114) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00016903877258301
(115) DESCRIBE `cruises` 0.0011889934539795
(116) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62666') 0.00019192695617676
(117) DESCRIBE `ships` 0.0011789798736572
(118) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 553))) 0.00022411346435547
(119) DESCRIBE `ships` 0.0011510848999023
(120) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '553') 0.00015997886657715
(121) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015592575073242
(122) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014591217041016
(123) DESCRIBE `itineraries` 0.00060606002807617
(124) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62666') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00041794776916504
(125) DESCRIBE `ports` 0.00061798095703125
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00017976760864258
(127) DESCRIBE `ports` 0.00059700012207031
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0001678466796875
(129) DESCRIBE `ports` 0.00058603286743164
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00015497207641602
(131) DESCRIBE `sailingdates` 0.00054001808166504
(132) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62666') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00061798095703125
(133) DESCRIBE `ports` 0.00081086158752441
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021600723266602
(135) DESCRIBE `ports` 0.00060415267944336
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00038599967956543
(137) DESCRIBE `ports` 0.00096297264099121
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00021910667419434
(139) DESCRIBE `ports` 0.00069093704223633
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00018405914306641
(141) DESCRIBE `ports` 0.0006721019744873
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00022411346435547
(143) DESCRIBE `ports` 0.00067806243896484
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00018906593322754
(145) DESCRIBE `ports` 0.00066995620727539
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.0001978874206543
(147) DESCRIBE `ports` 0.00070595741271973
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00018811225891113
(149) DESCRIBE `ports` 0.00068211555480957
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00033903121948242
(151) DESCRIBE `ports` 0.00068497657775879
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00022387504577637
(153) DESCRIBE `ports` 0.00066804885864258
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00020480155944824
(155) DESCRIBE `ports` 0.00068283081054688
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.0002140998840332
(157) DESCRIBE `ports` 0.0008080005645752
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00023984909057617
(159) DESCRIBE `ports` 0.00067019462585449
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00017881393432617
(161) DESCRIBE `ports` 0.00066590309143066
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019717216491699
(163) DESCRIBE `ports` 0.00067591667175293
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00021195411682129
(165) 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.0053060054779053
(166) DESCRIBE `avid_specials` 0.00077295303344727
(167) 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.0011000633239746
(168) DESCRIBE `cruiselines` 0.0010690689086914
(169) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00030303001403809
(170) DESCRIBE `orchid_image` 0.00098919868469238
(171) DESCRIBE `cruiselines` 0.00098299980163574
(172) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00021505355834961
(173) DESCRIBE `cruises` 0.0014739036560059
(174) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62662') 0.00024700164794922
(175) DESCRIBE `ships` 0.0013918876647949
(176) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00026917457580566
(177) DESCRIBE `ships` 0.0013949871063232
(178) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00020003318786621
(179) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017690658569336
(180) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001671314239502
(181) DESCRIBE `itineraries` 0.00069308280944824
(182) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62662') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00045013427734375
(183) DESCRIBE `ports` 0.00072193145751953
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00023007392883301
(185) DESCRIBE `ports` 0.0007169246673584
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020098686218262
(187) DESCRIBE `ports` 0.00067305564880371
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00019192695617676
(189) DESCRIBE `sailingdates` 0.00063705444335938
(190) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62662') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00083208084106445
(191) DESCRIBE `ports` 0.0099778175354004
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00035691261291504
(193) DESCRIBE `ports` 0.00065398216247559
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00016903877258301
(195) DESCRIBE `ports` 0.00068306922912598
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00025415420532227
(197) DESCRIBE `ports` 0.00070714950561523
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00016689300537109
(199) DESCRIBE `ports` 0.00058603286743164
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00020003318786621
(201) DESCRIBE `ports` 0.00059986114501953
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00015902519226074
(203) DESCRIBE `ports` 0.00058388710021973
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00018191337585449
(205) DESCRIBE `ports` 0.00084090232849121
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00022387504577637
(207) DESCRIBE `ports` 0.00086593627929688
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.0002741813659668
(209) DESCRIBE `ports` 0.00061917304992676
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00016689300537109
(211) DESCRIBE `ports` 0.0005950927734375
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00018405914306641
(213) DESCRIBE `ports` 0.00061416625976562
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00016093254089355
(215) DESCRIBE `ports` 0.00058794021606445
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00019001960754395
(217) DESCRIBE `ports` 0.00058889389038086
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00015997886657715
(219) 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.0047931671142578
(220) DESCRIBE `avid_specials` 0.00087118148803711
(221) 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.0011160373687744
(222) DESCRIBE `cruiselines` 0.00089907646179199
(223) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00020909309387207
(224) DESCRIBE `orchid_image` 0.00067615509033203
(225) DESCRIBE `cruiselines` 0.00084495544433594
(226) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00018906593322754
(227) DESCRIBE `cruises` 0.0012500286102295
(228) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68527') 0.00025296211242676
(229) DESCRIBE `ships` 0.0011940002441406
(230) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 610))) 0.00022506713867188
(231) DESCRIBE `ships` 0.0012061595916748
(232) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '610') 0.00016093254089355
(233) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015497207641602
(234) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014615058898926
(235) DESCRIBE `itineraries` 0.00059199333190918
(236) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68527') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00090694427490234
(237) DESCRIBE `ports` 0.0012040138244629
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00033402442932129
(239) DESCRIBE `ports` 0.00098896026611328
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00026893615722656
(241) DESCRIBE `ports` 0.0009150505065918
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00019502639770508
(243) DESCRIBE `sailingdates` 0.00060606002807617
(244) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68527') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00063991546630859
(245) DESCRIBE `ports` 0.00072097778320312
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0002129077911377
(247) DESCRIBE `ports` 0.00069999694824219
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00019288063049316
(249) DESCRIBE `ports` 0.00066113471984863
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.0001990795135498
(251) DESCRIBE `ports` 0.00070810317993164
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00023603439331055
(253) DESCRIBE `ports` 0.00076508522033691
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00022792816162109
(255) DESCRIBE `ports` 0.00066399574279785
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00019001960754395
(257) DESCRIBE `ports` 0.00086212158203125
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00019598007202148
(259) DESCRIBE `ports` 0.00066709518432617
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018787384033203
(261) DESCRIBE `ports` 0.00065994262695312
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 69))) 0.00024199485778809
(263) DESCRIBE `ports` 0.00067400932312012
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '69') 0.00018906593322754
(265) DESCRIBE `ports` 0.00066089630126953
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 598))) 0.00021791458129883
(267) DESCRIBE `ports` 0.00068187713623047
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '598') 0.00018787384033203
(269) DESCRIBE `ports` 0.00065994262695312
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 628))) 0.00020599365234375
(271) DESCRIBE `ports` 0.00065922737121582
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '628') 0.00018596649169922
(273) DESCRIBE `ports` 0.00067996978759766
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.0002138614654541
(275) DESCRIBE `ports` 0.00066494941711426
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00018787384033203
(277) DESCRIBE `ports` 0.00066995620727539
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020909309387207
(279) DESCRIBE `ports` 0.00066304206848145
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018787384033203
(281) 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.0052461624145508
(282) DESCRIBE `avid_specials` 0.00073719024658203
(283) 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.00098919868469238
(284) DESCRIBE `cruiselines` 0.0009770393371582
(285) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0002899169921875
(286) DESCRIBE `orchid_image` 0.00076794624328613
(287) DESCRIBE `cruiselines` 0.00091886520385742
(288) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00019598007202148
(289) DESCRIBE `cruises` 0.0020160675048828
(290) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70352') 0.00024199485778809
(291) DESCRIBE `ships` 0.0014159679412842
(292) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 674))) 0.00028204917907715
(293) DESCRIBE `ships` 0.0013880729675293
(294) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '674') 0.00020313262939453
(295) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017881393432617
(296) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017189979553223
(297) DESCRIBE `itineraries` 0.00075197219848633
(298) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70352') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00053000450134277
(299) DESCRIBE `ports` 0.00071215629577637
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00022792816162109
(301) DESCRIBE `ports` 0.00067496299743652
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00020098686218262
(303) DESCRIBE `ports` 0.00066685676574707
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00018000602722168
(305) DESCRIBE `sailingdates` 0.0006251335144043
(306) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70352') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00055313110351562
(307) DESCRIBE `ports` 0.00076508522033691
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00020718574523926
(309) DESCRIBE `ports` 0.0006709098815918
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00018095970153809
(311) DESCRIBE `ports` 0.00067806243896484
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1150))) 0.00021195411682129
(313) DESCRIBE `ports` 0.0007011890411377
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1150') 0.00018000602722168
(315) DESCRIBE `ports` 0.0007331371307373
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1761))) 0.00019407272338867
(317) DESCRIBE `ports` 0.00068092346191406
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1761') 0.00019311904907227
(319) DESCRIBE `ports` 0.00069808959960938
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00019979476928711
(321) DESCRIBE `ports` 0.00066494941711426
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00017595291137695
(323) DESCRIBE `ports` 0.0006718635559082
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2870))) 0.00019621849060059
(325) DESCRIBE `ports` 0.00066399574279785
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2870') 0.00017714500427246
(327) DESCRIBE `ports` 0.00077199935913086
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2470))) 0.0001981258392334
(329) DESCRIBE `ports` 0.00069499015808105
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2470') 0.00017714500427246
(331) DESCRIBE `ports` 0.00065994262695312
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00020098686218262
(333) DESCRIBE `ports` 0.00069999694824219
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00020408630371094
(335) 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.0052249431610107
(336) DESCRIBE `avid_specials` 0.00072288513183594
(337) 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.0010008811950684
(338) DESCRIBE `cruiselines` 0.0010161399841309
(339) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00031590461730957
(340) DESCRIBE `orchid_image` 0.0008091926574707
(341) DESCRIBE `cruiselines` 0.0010001659393311
(342) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00021004676818848
(343) DESCRIBE `cruises` 0.0013659000396729
(344) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64926') 0.00023984909057617
(345) DESCRIBE `ships` 0.0016489028930664
(346) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 462))) 0.00028800964355469
(347) DESCRIBE `ships` 0.0014300346374512
(348) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '462') 0.00020289421081543
(349) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020313262939453
(350) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017285346984863
(351) DESCRIBE `itineraries` 0.00068807601928711
(352) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64926') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00054812431335449
(353) DESCRIBE `ports` 0.00074195861816406
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00023007392883301
(355) DESCRIBE `ports` 0.00067591667175293
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00020194053649902
(357) DESCRIBE `ports` 0.0006721019744873
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.0002439022064209
(359) DESCRIBE `sailingdates` 0.0006101131439209
(360) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64926') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00060009956359863
(361) DESCRIBE `ports` 0.001338005065918
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00027894973754883
(363) DESCRIBE `ports` 0.00083398818969727
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00019097328186035
(365) DESCRIBE `ports` 0.00088000297546387
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2965))) 0.00023198127746582
(367) DESCRIBE `ports` 0.00086188316345215
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2965') 0.00020599365234375
(369) DESCRIBE `ports` 0.00087308883666992
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00022602081298828
(371) DESCRIBE `ports` 0.00085806846618652
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00017809867858887
(373) 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.0048439502716064
(374) DESCRIBE `avid_specials` 0.00069999694824219
(375) 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.00087785720825195
(376) DESCRIBE `cruiselines` 0.00085806846618652
(377) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00020503997802734
(378) DESCRIBE `orchid_image` 0.00074291229248047
(379) DESCRIBE `cruiselines` 0.00080013275146484
(380) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00016689300537109
(381) DESCRIBE `cruises` 0.0012722015380859
(382) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62667') 0.00020098686218262
(383) DESCRIBE `ships` 0.0012059211730957
(384) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 553))) 0.00023913383483887
(385) DESCRIBE `ships` 0.0015912055969238
(386) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '553') 0.00024509429931641
(387) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016093254089355
(388) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001521110534668
(389) DESCRIBE `itineraries` 0.00070595741271973
(390) DESCRIBE `ports` 0.00060582160949707
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00020098686218262
(392) DESCRIBE `ports` 0.00059413909912109
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00017881393432617
(394) DESCRIBE `ports` 0.00062680244445801
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00017809867858887
(396) DESCRIBE `sailingdates` 0.00055408477783203
(397) DESCRIBE `ports` 0.00084280967712402
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00022792816162109
(399) DESCRIBE `ports` 0.0006110668182373
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00017309188842773
(401) DESCRIBE `ports` 0.00059390068054199
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00017714500427246
(403) DESCRIBE `ports` 0.00058412551879883
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00015997886657715
(405) DESCRIBE `ports` 0.00060510635375977
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00017786026000977
(407) DESCRIBE `ports` 0.00057506561279297
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00016498565673828
(409) DESCRIBE `ports` 0.0005791187286377
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00017404556274414
(411) DESCRIBE `ports` 0.00058889389038086
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00015902519226074
(413) DESCRIBE `ports` 0.00057888031005859
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00019001960754395
(415) DESCRIBE `ports` 0.00059008598327637
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00015497207641602
(417) DESCRIBE `ports` 0.00060486793518066
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00018119812011719
(419) DESCRIBE `ports` 0.00058507919311523
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00015807151794434
(421) DESCRIBE `ports` 0.00063180923461914
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00017189979553223
(423) DESCRIBE `ports` 0.00060892105102539
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00016403198242188
(425) DESCRIBE `ports` 0.00058293342590332
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00017213821411133
(427) DESCRIBE `ports` 0.00058102607727051
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00016212463378906
(429) 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.004817008972168
(430) DESCRIBE `avid_specials` 0.00064587593078613
(431) 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.00087213516235352
(432) DESCRIBE `cruiselines` 0.0008699893951416
(433) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00019693374633789
(434) DESCRIBE `orchid_image` 0.00070405006408691
(435) DESCRIBE `cruiselines` 0.00085806846618652
(436) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00016999244689941
(437) DESCRIBE `cruises` 0.0011770725250244
(438) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67961') 0.00019001960754395
(439) DESCRIBE `ships` 0.0011711120605469
(440) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 977))) 0.00022792816162109
(441) DESCRIBE `ships` 0.0011529922485352
(442) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '977') 0.00015902519226074
(443) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024580955505371
(444) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014686584472656
(445) DESCRIBE `itineraries` 0.00060796737670898
(446) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67961') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00050115585327148
(447) DESCRIBE `ports` 0.00068306922912598
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00019001960754395
(449) DESCRIBE `ports` 0.00058603286743164
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00017309188842773
(451) DESCRIBE `ports` 0.00061488151550293
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00015997886657715
(453) DESCRIBE `sailingdates` 0.00052809715270996
(454) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67961') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00050187110900879
(455) DESCRIBE `ports` 0.00065183639526367
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00017499923706055
(457) DESCRIBE `ports` 0.00059700012207031
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00016403198242188
(459) DESCRIBE `ports` 0.00059199333190918
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00018191337585449
(461) DESCRIBE `ports` 0.0006101131439209
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00016593933105469
(463) DESCRIBE `ports` 0.00058221817016602
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00019216537475586
(465) DESCRIBE `ports` 0.00058412551879883
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00016880035400391
(467) 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.004817008972168
(468) DESCRIBE `avid_specials` 0.0008089542388916
(469) 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.00090503692626953
(470) DESCRIBE `cruiselines` 0.00091004371643066
(471) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00021004676818848
(472) DESCRIBE `orchid_image` 0.00069212913513184
(473) DESCRIBE `cruiselines` 0.00080108642578125
(474) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00017023086547852
(475) DESCRIBE `cruises` 0.0012171268463135
(476) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62663') 0.00017189979553223
(477) DESCRIBE `ships` 0.0012621879577637
(478) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00023913383483887
(479) DESCRIBE `ships` 0.0012149810791016
(480) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00017786026000977
(481) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015687942504883
(482) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014591217041016
(483) DESCRIBE `itineraries` 0.00059795379638672
(484) DESCRIBE `ports` 0.00082302093505859
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00023794174194336
(486) DESCRIBE `ports` 0.00061702728271484
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00018405914306641
(488) DESCRIBE `ports` 0.00060009956359863
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.0001680850982666
(490) DESCRIBE `sailingdates` 0.00052809715270996
(491) DESCRIBE `ports` 0.00078201293945312
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00022101402282715
(493) DESCRIBE `ports` 0.00061488151550293
(494) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00017595291137695
(495) DESCRIBE `ports` 0.00059199333190918
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00017905235290527
(497) DESCRIBE `ports` 0.00060200691223145
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00016188621520996
(499) DESCRIBE `ports` 0.00062894821166992
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00021195411682129
(501) DESCRIBE `ports` 0.00060415267944336
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00016093254089355
(503) DESCRIBE `ports` 0.00059914588928223
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00017905235290527
(505) DESCRIBE `ports` 0.00063300132751465
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00016403198242188
(507) DESCRIBE `ports` 0.00060009956359863
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00018215179443359
(509) DESCRIBE `ports` 0.00059390068054199
(510) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00016212463378906
(511) DESCRIBE `ports` 0.00062298774719238
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00018501281738281
(513) DESCRIBE `ports` 0.00061392784118652
(514) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00016307830810547
(515) DESCRIBE `ports` 0.00069689750671387
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00018405914306641
(517) DESCRIBE `ports` 0.0005958080291748
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00016498565673828
(519) 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.0049691200256348
(520) DESCRIBE `avid_specials` 0.00064992904663086
(521) 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.00087690353393555
(522) DESCRIBE `cruiselines` 0.00087189674377441
(523) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00020313262939453
(524) DESCRIBE `orchid_image` 0.00066399574279785
(525) DESCRIBE `cruiselines` 0.00081992149353027
(526) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00018310546875
(527) DESCRIBE `ships` 0.0014288425445557
(528) SELECT `ships`.* FROM `ships` WHERE (id IN ('977', '407', '1359', '1067', '553', '726', '452', '766', '1588', '462', '1415', '610', '352', '674', '738', '1599')) ORDER BY FIND_IN_SET(id, '977,407,1359,1067,553,726,452,766,1588,462,1415,610,352,674,738,1599') 0.00083303451538086
(529) DESCRIBE `cruisetypes` 0.00079917907714844
(530) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '19') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.025032997131348
(531) DESCRIBE `destinations` 0.0010249614715576
(532) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '28', '25', '26', '52', '38', '45', '40', '35', '21', '49', '37')) ORDER BY FIND_IN_SET(id, '22,12,28,25,26,52,38,45,40,35,21,49,37') 0.00072002410888672
(533) DESCRIBE `cruiselines` 0.0014090538024902
(534) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00027585029602051
(535) DESCRIBE `cruiselines` 0.0011110305786133
(536) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00025010108947754