or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. REVIEW: P & O Australia’s Pacific Aria
  3. Catch Up on Cruising: Latest News in bite size!
  4. Asian Adventures with Zuleika from the Cruise Factor Team
  5. A short cruise is a good cruise!!

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

 
  • Magnifica, Northern Europe ex Southampton Return

    Nights 14 Ship MSC Magnifica
    Star Rating 4 Star Departs Southampton, England
    Sailing 2018: 25 Jun, 9 Aug
    Ports of Call Southampton, Le Havre, Leixoes, Lisbon, Cadiz, Malaga, La Coruna, Amsterdam, Hamburg

    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: 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 Palermo Return

    Nights 7 Ship MSC Divina
    Star Rating 4 Star Departs Palermo, Sicily. IT
    Sailing 2018: 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
    Ports of Call Palermo, Cagliari, Palma, Valencia, 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.

  • Seaview, Italy Malta Spain France ex Naples Return

    Nights 7 Ship MSC Seaview
    Star Rating 4 Star Departs Naples, Italy
    Sailing 2018: 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, 8 Oct, 15 Oct, 22 Oct, 29 Oct, 5 Nov
    Ports of Call Naples, Messina, 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.

  • Fantasia, Italy France Spain ex Cannes Return

    Nights 7 Ship MSC Fantasia
    Star Rating 4 Star Departs Cannes, France
    Sailing 2018: 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, 8 Oct, 15 Oct, 22 Oct, 29 Oct
    Ports of Call Cannes, Mallorca, Barcelona, Ajaccio, Rome (Civitavecchia), La Spezia, 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.

  • Magnifica, Northern Europe ex Le Havre Return

    Nights 14 Ship MSC Magnifica
    Star Rating 4 Star Departs Le Havre, France
    Sailing 2018: 26 Jun, 10 Aug
    Ports of Call Le Havre, Leixoes, Lisbon, Cadiz, Malaga, La Coruna, Amsterdam, Hamburg, Southampton

    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 Cagliari Return

    Nights 7 Ship MSC Divina
    Star Rating 4 Star Departs Cagliari, Sardinia. IT
    Sailing 2018: 26 Jun, 3 Jul, 10 Jul, 17 Jul, 24 Jul, 31 Jul, 7 Aug, 14 Aug, 21 Aug, 28 Aug, 4 Sep, 11 Sep, 18 Sep, 25 Sep
    Ports of Call Cagliari, Palma, Valencia, Marseilles, Genoa, Rome (Civitavecchia), Palermo

    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.

  • Seaview, Italy Malta Spain France ex Messina Return

    Nights 7 Ship MSC Seaview
    Star Rating 4 Star Departs Messina, Sicily. IT
    Sailing 2018: 26 Jun, 3 Jul, 10 Jul, 17 Jul, 24 Jul, 31 Jul, 7 Aug, 14 Aug, 21 Aug, 28 Aug, 4 Sep, 11 Sep, 18 Sep, 25 Sep, 2 Oct, 9 Oct, 16 Oct, 23 Oct, 30 Oct, 6 Nov
    Ports of Call Messina, Valletta, Barcelona, Marseilles, Genoa, Naples

    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, Italy France Spain ex Barcelona Return

    Nights 7 Ship MSC Fantasia
    Star Rating 4 Star Departs Barcelona, Spain
    Sailing 2018: 27 Jun, 4 Jul, 11 Jul, 18 Jul, 25 Jul, 1 Aug, 8 Aug, 15 Aug, 22 Aug, 29 Aug, 5 Sep, 12 Sep, 19 Sep, 26 Sep, 3 Oct, 10 Oct, 17 Oct, 24 Oct
    Ports of Call Barcelona, Ajaccio, Rome (Civitavecchia), La Spezia, Genoa, Cannes, Mallorca

    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, Spain France Italy ex Palma Return

    Nights 7 Ship MSC Divina
    Star Rating 4 Star Departs Palma, Majorca. SP
    Sailing 2018: 27 Jun, 4 Jul, 11 Jul, 18 Jul, 25 Jul, 1 Aug, 8 Aug, 15 Aug, 22 Aug, 29 Aug, 5 Sep, 12 Sep, 19 Sep, 26 Sep
    Ports of Call Palma, Valencia, Marseilles, Genoa, Rome (Civitavecchia), Palermo, Cagliari

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

Total elapsed time: 0.43435049057007

# Query Time
(1) connect 0.00082588195800781
(2) DESCRIBE `cruises` 0.0024590492248535
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66168, 62667, 67966, 69077, 70257, 66169, 67968, 69078, 67999, 70204)) ORDER BY FIND_IN_SET(id, '66168,62667,67966,69077,70257,66169,67968,69078,67999,70204') 0.0017340183258057
(4) DESCRIBE `cruises` 0.0023431777954102
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66168') 0.00031709671020508
(6) DESCRIBE `ships` 0.001986026763916
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 766))) 0.0003659725189209
(8) DESCRIBE `ships` 0.0020449161529541
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '766') 0.00025486946105957
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002598762512207
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002288818359375
(12) DESCRIBE `itineraries` 0.0010619163513184
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66168') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00098609924316406
(14) DESCRIBE `ports` 0.00076198577880859
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00023984909057617
(16) DESCRIBE `ports` 0.00068402290344238
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00019979476928711
(18) DESCRIBE `ports` 0.00067400932312012
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00018906593322754
(20) DESCRIBE `sailingdates` 0.00060105323791504
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66168') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00047492980957031
(22) DESCRIBE `ports` 0.00069212913513184
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00020313262939453
(24) DESCRIBE `ports` 0.00068402290344238
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00018191337585449
(26) DESCRIBE `ports` 0.00069880485534668
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00020599365234375
(28) DESCRIBE `ports` 0.00066089630126953
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.00018095970153809
(30) DESCRIBE `ports` 0.00069403648376465
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1842))) 0.00020003318786621
(32) DESCRIBE `ports` 0.00065898895263672
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1842') 0.00020480155944824
(34) DESCRIBE `ports` 0.00079202651977539
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00021696090698242
(36) DESCRIBE `ports` 0.00072813034057617
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00018811225891113
(38) DESCRIBE `ports` 0.00070405006408691
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00020790100097656
(40) DESCRIBE `ports` 0.00066804885864258
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00023818016052246
(42) DESCRIBE `ports` 0.00071907043457031
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00021791458129883
(44) DESCRIBE `ports` 0.00066900253295898
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00018000602722168
(46) DESCRIBE `ports` 0.00070309638977051
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 529))) 0.00019288063049316
(48) DESCRIBE `ports` 0.0006718635559082
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '529') 0.00017714500427246
(50) DESCRIBE `ports` 0.00066995620727539
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00020694732666016
(52) DESCRIBE `ports` 0.00069212913513184
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00018095970153809
(54) DESCRIBE `ports` 0.00076913833618164
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.0001981258392334
(56) DESCRIBE `ports` 0.00074100494384766
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00018215179443359
(58) DESCRIBE `ports` 0.00065994262695312
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00019383430480957
(60) DESCRIBE `ports` 0.00068807601928711
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00017905235290527
(62) DESCRIBE `ports` 0.0006721019744873
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00020194053649902
(64) DESCRIBE `ports` 0.00066590309143066
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00018095970153809
(66) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66168') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0053689479827881
(67) DESCRIBE `avid_specials` 0.00064206123352051
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66168 and class = 'Cruise') OR (item_id = 766 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 28 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.00098299980163574
(69) DESCRIBE `cruiselines` 0.0010380744934082
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00022482872009277
(71) DESCRIBE `orchid_image` 0.00091814994812012
(72) DESCRIBE `cruiselines` 0.00093388557434082
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00019311904907227
(74) DESCRIBE `cruises` 0.0012941360473633
(75) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62667') 0.00023412704467773
(76) DESCRIBE `ships` 0.0012609958648682
(77) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 553))) 0.00025701522827148
(78) DESCRIBE `ships` 0.0012609958648682
(79) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '553') 0.00017619132995605
(80) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017118453979492
(81) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016283988952637
(82) DESCRIBE `itineraries` 0.00066018104553223
(83) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62667') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00084710121154785
(84) DESCRIBE `ports` 0.0011138916015625
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00025486946105957
(86) DESCRIBE `ports` 0.00070595741271973
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00019598007202148
(88) DESCRIBE `ports` 0.00067782402038574
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00018715858459473
(90) DESCRIBE `sailingdates` 0.00061702728271484
(91) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62667') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0006260871887207
(92) DESCRIBE `ports` 0.00090408325195312
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00022697448730469
(94) DESCRIBE `ports` 0.00067901611328125
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00019097328186035
(96) DESCRIBE `ports` 0.00065898895263672
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00020503997802734
(98) DESCRIBE `ports` 0.00068306922912598
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00018596649169922
(100) DESCRIBE `ports` 0.00089597702026367
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.0001988410949707
(102) DESCRIBE `ports` 0.00084900856018066
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00017595291137695
(104) DESCRIBE `ports` 0.00065898895263672
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0001988410949707
(106) DESCRIBE `ports` 0.00066494941711426
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00020408630371094
(108) DESCRIBE `ports` 0.00065898895263672
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00019216537475586
(110) DESCRIBE `ports` 0.00066018104553223
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00018620491027832
(112) DESCRIBE `ports` 0.00065994262695312
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00019216537475586
(114) DESCRIBE `ports` 0.0007319450378418
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00019001960754395
(116) DESCRIBE `ports` 0.0006561279296875
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019311904907227
(118) DESCRIBE `ports` 0.00068402290344238
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017404556274414
(120) DESCRIBE `ports` 0.00069403648376465
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00019383430480957
(122) DESCRIBE `ports` 0.00066614151000977
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00017404556274414
(124) 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.0061659812927246
(125) DESCRIBE `avid_specials` 0.00069999694824219
(126) 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.0010368824005127
(127) DESCRIBE `cruiselines` 0.00098204612731934
(128) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00022101402282715
(129) DESCRIBE `orchid_image` 0.0010950565338135
(130) DESCRIBE `cruiselines` 0.0012710094451904
(131) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00027799606323242
(132) DESCRIBE `cruises` 0.0018150806427002
(133) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67966') 0.00025200843811035
(134) DESCRIBE `ships` 0.0012948513031006
(135) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 977))) 0.00029706954956055
(136) DESCRIBE `ships` 0.0012590885162354
(137) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '977') 0.00018215179443359
(138) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017786026000977
(139) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016498565673828
(140) DESCRIBE `itineraries` 0.00067806243896484
(141) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67966') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011820793151855
(142) DESCRIBE `ports` 0.0007469654083252
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00022196769714355
(144) DESCRIBE `ports` 0.00066804885864258
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00020098686218262
(146) DESCRIBE `ports` 0.0006709098815918
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00018715858459473
(148) DESCRIBE `sailingdates` 0.00063681602478027
(149) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67966') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010788440704346
(150) DESCRIBE `ports` 0.00073409080505371
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00021195411682129
(152) DESCRIBE `ports` 0.0006721019744873
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.0001828670501709
(154) DESCRIBE `ports` 0.00066399574279785
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00020098686218262
(156) DESCRIBE `ports` 0.00068092346191406
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00019001960754395
(158) DESCRIBE `ports` 0.00066709518432617
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00019407272338867
(160) DESCRIBE `ports` 0.00066804885864258
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00017499923706055
(162) DESCRIBE `ports` 0.00065898895263672
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00019407272338867
(164) DESCRIBE `ports` 0.00068211555480957
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00017499923706055
(166) DESCRIBE `ports` 0.00066184997558594
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.0001990795135498
(168) DESCRIBE `ports` 0.00066399574279785
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00018692016601562
(170) DESCRIBE `ports` 0.00069093704223633
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00019407272338867
(172) DESCRIBE `ports` 0.00065803527832031
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00018596649169922
(174) DESCRIBE `ports` 0.00072884559631348
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00019288063049316
(176) DESCRIBE `ports` 0.00067591667175293
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018882751464844
(178) DESCRIBE `ports` 0.0006711483001709
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.0001981258392334
(180) DESCRIBE `ports` 0.00068187713623047
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00018906593322754
(182) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '67966') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0056769847869873
(183) DESCRIBE `avid_specials` 0.00094795227050781
(184) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67966 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.0011110305786133
(185) DESCRIBE `cruiselines` 0.0013389587402344
(186) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0002589225769043
(187) DESCRIBE `orchid_image` 0.00088000297546387
(188) DESCRIBE `cruiselines` 0.0011329650878906
(189) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00031208992004395
(190) DESCRIBE `cruises` 0.0020718574523926
(191) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69077') 0.00032401084899902
(192) DESCRIBE `ships` 0.0021109580993652
(193) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1588))) 0.0003199577331543
(194) DESCRIBE `ships` 0.0017800331115723
(195) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1588') 0.00020813941955566
(196) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018191337585449
(197) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019407272338867
(198) DESCRIBE `itineraries` 0.00078797340393066
(199) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69077') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0013399124145508
(200) DESCRIBE `ports` 0.00076699256896973
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00023698806762695
(202) DESCRIBE `ports` 0.00068402290344238
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00020694732666016
(204) DESCRIBE `ports` 0.00071287155151367
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.0002140998840332
(206) DESCRIBE `sailingdates` 0.00072598457336426
(207) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69077') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0006868839263916
(208) DESCRIBE `ports` 0.0011780261993408
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00032997131347656
(210) DESCRIBE `ports` 0.00075316429138184
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00022387504577637
(212) DESCRIBE `ports` 0.00072312355041504
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.0001978874206543
(214) DESCRIBE `ports` 0.00075387954711914
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.0002140998840332
(216) DESCRIBE `ports` 0.00083208084106445
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00024986267089844
(218) DESCRIBE `ports` 0.00076889991760254
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00018000602722168
(220) DESCRIBE `ports` 0.00083494186401367
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00022506713867188
(222) DESCRIBE `ports` 0.00071001052856445
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00021910667419434
(224) DESCRIBE `ports` 0.00096011161804199
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00025606155395508
(226) DESCRIBE `ports` 0.0009770393371582
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00026416778564453
(228) DESCRIBE `ports` 0.0010001659393311
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00024890899658203
(230) DESCRIBE `ports` 0.00094389915466309
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00024104118347168
(232) DESCRIBE `ports` 0.00091004371643066
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00025796890258789
(234) DESCRIBE `ports` 0.00097799301147461
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.0002291202545166
(236) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69077') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0055689811706543
(237) DESCRIBE `avid_specials` 0.00074601173400879
(238) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69077 and class = 'Cruise') OR (item_id = 1588 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.0012991428375244
(239) DESCRIBE `cruiselines` 0.0011420249938965
(240) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00025391578674316
(241) DESCRIBE `orchid_image` 0.00080394744873047
(242) DESCRIBE `cruiselines` 0.0009300708770752
(243) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00020217895507812
(244) DESCRIBE `cruises` 0.0013010501861572
(245) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70257') 0.00023293495178223
(246) DESCRIBE `ships` 0.0012850761413574
(247) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 726))) 0.00027585029602051
(248) DESCRIBE `ships` 0.0012569427490234
(249) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '726') 0.00018692016601562
(250) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017786026000977
(251) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016593933105469
(252) DESCRIBE `itineraries` 0.00068998336791992
(253) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70257') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0009307861328125
(254) DESCRIBE `ports` 0.00084781646728516
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.0002448558807373
(256) DESCRIBE `ports` 0.00084996223449707
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00020384788513184
(258) DESCRIBE `ports` 0.00077915191650391
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00023102760314941
(260) DESCRIBE `sailingdates` 0.0006401538848877
(261) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70257') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00057601928710938
(262) DESCRIBE `ports` 0.00075387954711914
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00020098686218262
(264) DESCRIBE `ports` 0.0009000301361084
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00026106834411621
(266) DESCRIBE `ports` 0.00095105171203613
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00024986267089844
(268) DESCRIBE `ports` 0.00093293190002441
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.0002140998840332
(270) DESCRIBE `ports` 0.00093793869018555
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00019502639770508
(272) DESCRIBE `ports` 0.00066709518432617
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00017690658569336
(274) DESCRIBE `ports` 0.00073504447937012
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00019979476928711
(276) DESCRIBE `ports` 0.00065994262695312
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00017499923706055
(278) DESCRIBE `ports` 0.00071310997009277
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00019192695617676
(280) DESCRIBE `ports` 0.00078296661376953
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00017595291137695
(282) DESCRIBE `ports` 0.00078201293945312
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021004676818848
(284) DESCRIBE `ports` 0.00067901611328125
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00017404556274414
(286) DESCRIBE `ports` 0.00068092346191406
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2264))) 0.00019311904907227
(288) DESCRIBE `ports` 0.00067305564880371
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2264') 0.00018191337585449
(290) DESCRIBE `ports` 0.00066494941711426
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00019502639770508
(292) DESCRIBE `ports` 0.00068807601928711
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00020194053649902
(294) DESCRIBE `ports` 0.00072407722473145
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00021004676818848
(296) DESCRIBE `ports` 0.00093889236450195
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00022983551025391
(298) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '70257') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0089859962463379
(299) DESCRIBE `avid_specials` 0.0011260509490967
(300) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70257 and class = 'Cruise') OR (item_id = 726 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.001802921295166
(301) DESCRIBE `cruiselines` 0.0011088848114014
(302) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00023603439331055
(303) DESCRIBE `orchid_image` 0.00077199935913086
(304) DESCRIBE `cruiselines` 0.0009150505065918
(305) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00018501281738281
(306) DESCRIBE `cruises` 0.0022900104522705
(307) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66169') 0.00033688545227051
(308) DESCRIBE `ships` 0.0020267963409424
(309) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 766))) 0.00040316581726074
(310) DESCRIBE `ships` 0.0020260810852051
(311) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '766') 0.00027894973754883
(312) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018095970153809
(313) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020003318786621
(314) DESCRIBE `itineraries` 0.00069618225097656
(315) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66169') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00043702125549316
(316) DESCRIBE `ports` 0.0014970302581787
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.0003349781036377
(318) DESCRIBE `ports` 0.00067901611328125
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00028109550476074
(320) DESCRIBE `ports` 0.00084304809570312
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.00024795532226562
(322) DESCRIBE `sailingdates` 0.0007631778717041
(323) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66169') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00048089027404785
(324) DESCRIBE `ports` 0.0010378360748291
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00031495094299316
(326) DESCRIBE `ports` 0.001060962677002
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.00024509429931641
(328) DESCRIBE `ports` 0.00099992752075195
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1842))) 0.00026988983154297
(330) DESCRIBE `ports` 0.00081896781921387
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1842') 0.0001988410949707
(332) DESCRIBE `ports` 0.00078892707824707
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00020599365234375
(334) DESCRIBE `ports` 0.00072813034057617
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00018405914306641
(336) DESCRIBE `ports` 0.00066781044006348
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00020098686218262
(338) DESCRIBE `ports` 0.0006709098815918
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00018405914306641
(340) DESCRIBE `ports` 0.00069499015808105
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00020408630371094
(342) DESCRIBE `ports` 0.00066614151000977
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00018596649169922
(344) DESCRIBE `ports` 0.00066804885864258
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 529))) 0.00019288063049316
(346) DESCRIBE `ports` 0.00066995620727539
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '529') 0.00017690658569336
(348) DESCRIBE `ports` 0.00066184997558594
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00020313262939453
(350) DESCRIBE `ports` 0.00066685676574707
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.0001828670501709
(352) DESCRIBE `ports` 0.00066304206848145
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00020313262939453
(354) DESCRIBE `ports` 0.00066781044006348
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00018119812011719
(356) DESCRIBE `ports` 0.00067806243896484
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00019693374633789
(358) DESCRIBE `ports` 0.00084400177001953
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00019001960754395
(360) DESCRIBE `ports` 0.00068378448486328
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00023293495178223
(362) DESCRIBE `ports` 0.00067305564880371
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00018501281738281
(364) DESCRIBE `ports` 0.00067496299743652
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00020098686218262
(366) DESCRIBE `ports` 0.00068998336791992
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.00018310546875
(368) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66169') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0054631233215332
(369) DESCRIBE `avid_specials` 0.00070810317993164
(370) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66169 and class = 'Cruise') OR (item_id = 766 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 28 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.00096702575683594
(371) DESCRIBE `cruiselines` 0.00097107887268066
(372) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00022387504577637
(373) DESCRIBE `orchid_image` 0.00077700614929199
(374) DESCRIBE `cruiselines` 0.00091004371643066
(375) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00018811225891113
(376) DESCRIBE `cruises` 0.0020768642425537
(377) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67968') 0.00029778480529785
(378) DESCRIBE `ships` 0.0017609596252441
(379) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 977))) 0.00032806396484375
(380) DESCRIBE `ships` 0.0012538433074951
(381) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '977') 0.00018095970153809
(382) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017595291137695
(383) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017213821411133
(384) DESCRIBE `itineraries` 0.00066900253295898
(385) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67968') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00034809112548828
(386) DESCRIBE `ports` 0.00069785118103027
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00020909309387207
(388) DESCRIBE `ports` 0.00066590309143066
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00021195411682129
(390) DESCRIBE `ports` 0.00067496299743652
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00017690658569336
(392) DESCRIBE `sailingdates` 0.00060105323791504
(393) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67968') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00045013427734375
(394) DESCRIBE `ports` 0.00071215629577637
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00021004676818848
(396) DESCRIBE `ports` 0.00067806243896484
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00018501281738281
(398) DESCRIBE `ports` 0.00090503692626953
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00020503997802734
(400) DESCRIBE `ports` 0.00067687034606934
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.0001828670501709
(402) DESCRIBE `ports` 0.00071001052856445
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00020289421081543
(404) DESCRIBE `ports` 0.00066804885864258
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00018501281738281
(406) DESCRIBE `ports` 0.00067687034606934
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00020599365234375
(408) DESCRIBE `ports` 0.00066804885864258
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00018501281738281
(410) DESCRIBE `ports` 0.00073599815368652
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00021791458129883
(412) DESCRIBE `ports` 0.00085115432739258
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00018906593322754
(414) DESCRIBE `ports` 0.0006721019744873
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020503997802734
(416) DESCRIBE `ports` 0.00066900253295898
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018501281738281
(418) DESCRIBE `ports` 0.00069189071655273
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00026512145996094
(420) DESCRIBE `ports` 0.00068283081054688
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00021219253540039
(422) DESCRIBE `ports` 0.00075006484985352
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00022292137145996
(424) DESCRIBE `ports` 0.00067901611328125
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.0001828670501709
(426) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '67968') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0055279731750488
(427) DESCRIBE `avid_specials` 0.0006721019744873
(428) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67968 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.00095510482788086
(429) DESCRIBE `cruiselines` 0.00098395347595215
(430) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00022006034851074
(431) DESCRIBE `orchid_image` 0.00077295303344727
(432) DESCRIBE `cruiselines` 0.00090789794921875
(433) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00018095970153809
(434) DESCRIBE `cruises` 0.0012810230255127
(435) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69078') 0.00020384788513184
(436) DESCRIBE `ships` 0.001270055770874
(437) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1588))) 0.00025200843811035
(438) DESCRIBE `ships` 0.0012378692626953
(439) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1588') 0.00018692016601562
(440) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017499923706055
(441) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016689300537109
(442) DESCRIBE `itineraries` 0.00065517425537109
(443) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69078') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00032711029052734
(444) DESCRIBE `ports` 0.00073695182800293
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00036907196044922
(446) DESCRIBE `ports` 0.00088691711425781
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00020694732666016
(448) DESCRIBE `ports` 0.0006871223449707
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00019693374633789
(450) DESCRIBE `sailingdates` 0.00059604644775391
(451) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69078') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00048589706420898
(452) DESCRIBE `ports` 0.00072908401489258
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00020194053649902
(454) DESCRIBE `ports` 0.00071215629577637
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00018405914306641
(456) DESCRIBE `ports` 0.00066900253295898
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.0001981258392334
(458) DESCRIBE `ports` 0.00066494941711426
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00018191337585449
(460) DESCRIBE `ports` 0.00072717666625977
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020003318786621
(462) DESCRIBE `ports` 0.00066208839416504
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018405914306641
(464) DESCRIBE `ports` 0.00070810317993164
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00020289421081543
(466) DESCRIBE `ports` 0.00066781044006348
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00018310546875
(468) DESCRIBE `ports` 0.0007178783416748
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00020599365234375
(470) DESCRIBE `ports` 0.00066995620727539
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00018501281738281
(472) DESCRIBE `ports` 0.00066709518432617
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00020694732666016
(474) DESCRIBE `ports` 0.00070595741271973
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00018501281738281
(476) DESCRIBE `ports` 0.00071501731872559
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00020003318786621
(478) DESCRIBE `ports` 0.00066781044006348
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00018692016601562
(480) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69078') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0056719779968262
(481) DESCRIBE `avid_specials` 0.0006561279296875
(482) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69078 and class = 'Cruise') OR (item_id = 1588 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.00094008445739746
(483) DESCRIBE `cruiselines` 0.00096297264099121
(484) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00022196769714355
(485) DESCRIBE `orchid_image` 0.00077295303344727
(486) DESCRIBE `cruiselines` 0.0011558532714844
(487) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00018405914306641
(488) DESCRIBE `cruises` 0.0017809867858887
(489) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67999') 0.00032687187194824
(490) DESCRIBE `ships` 0.0021169185638428
(491) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 726))) 0.00050806999206543
(492) DESCRIBE `ships` 0.0022389888763428
(493) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '726') 0.00028395652770996
(494) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021815299987793
(495) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020098686218262
(496) DESCRIBE `itineraries` 0.00090694427490234
(497) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67999') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00092720985412598
(498) DESCRIBE `ports` 0.001183032989502
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00033092498779297
(500) DESCRIBE `ports` 0.0010750293731689
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00030708312988281
(502) DESCRIBE `ports` 0.0010480880737305
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00025510787963867
(504) DESCRIBE `sailingdates` 0.00086712837219238
(505) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67999') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0005958080291748
(506) DESCRIBE `ports` 0.0013270378112793
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00027203559875488
(508) DESCRIBE `ports` 0.00070381164550781
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00020194053649902
(510) DESCRIBE `ports` 0.00069212913513184
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00023102760314941
(512) DESCRIBE `ports` 0.00070405006408691
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00019717216491699
(514) DESCRIBE `ports` 0.0007789134979248
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00023698806762695
(516) DESCRIBE `ports` 0.00077986717224121
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00020718574523926
(518) DESCRIBE `ports` 0.0007779598236084
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2264))) 0.00021791458129883
(520) DESCRIBE `ports` 0.00078487396240234
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2264') 0.00020503997802734
(522) DESCRIBE `ports` 0.0006718635559082
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00021100044250488
(524) DESCRIBE `ports` 0.00066900253295898
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00018405914306641
(526) DESCRIBE `ports` 0.00066590309143066
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.0002281665802002
(528) DESCRIBE `ports` 0.00070810317993164
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00018787384033203
(530) DESCRIBE `ports` 0.00066590309143066
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00020503997802734
(532) DESCRIBE `ports` 0.00068283081054688
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00018501281738281
(534) DESCRIBE `ports` 0.00070405006408691
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00020599365234375
(536) DESCRIBE `ports` 0.00067281723022461
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00019621849060059
(538) DESCRIBE `ports` 0.00066900253295898
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020194053649902
(540) DESCRIBE `ports` 0.00066781044006348
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0001828670501709
(542) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '67999') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0055108070373535
(543) DESCRIBE `avid_specials` 0.00089216232299805
(544) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67999 and class = 'Cruise') OR (item_id = 726 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.0012052059173584
(545) DESCRIBE `cruiselines` 0.0011999607086182
(546) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00032305717468262
(547) DESCRIBE `orchid_image` 0.00083518028259277
(548) DESCRIBE `cruiselines` 0.0010440349578857
(549) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0002129077911377
(550) DESCRIBE `cruises` 0.0013811588287354
(551) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70204') 0.00026178359985352
(552) DESCRIBE `ships` 0.0013091564178467
(553) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 977))) 0.00026392936706543
(554) DESCRIBE `ships` 0.0013539791107178
(555) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '977') 0.00020718574523926
(556) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017690658569336
(557) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001678466796875
(558) DESCRIBE `itineraries` 0.00067782402038574
(559) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70204') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00047397613525391
(560) DESCRIBE `ports` 0.0011060237884521
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00027799606323242
(562) DESCRIBE `ports` 0.00068807601928711
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00023198127746582
(564) DESCRIBE `ports` 0.000701904296875
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00019693374633789
(566) DESCRIBE `sailingdates` 0.00062799453735352
(567) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70204') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00052404403686523
(568) DESCRIBE `ports` 0.00079083442687988
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00021791458129883
(570) DESCRIBE `ports` 0.00069403648376465
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00023078918457031
(572) DESCRIBE `ports` 0.00077915191650391
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00021791458129883
(574) DESCRIBE `ports` 0.00068998336791992
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00018715858459473
(576) DESCRIBE `ports` 0.00066995620727539
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00020408630371094
(578) DESCRIBE `ports` 0.00068998336791992
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00021195411682129
(580) DESCRIBE `ports` 0.00070285797119141
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00021195411682129
(582) DESCRIBE `ports` 0.00067901611328125
(583) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00018310546875
(584) DESCRIBE `ports` 0.00069308280944824
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00022387504577637
(586) DESCRIBE `ports` 0.00068283081054688
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018405914306641
(588) DESCRIBE `ports` 0.00066399574279785
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00020694732666016
(590) DESCRIBE `ports` 0.0006709098815918
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00020694732666016
(592) DESCRIBE `ports` 0.00066804885864258
(593) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00020790100097656
(594) DESCRIBE `ports` 0.00087094306945801
(595) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.000244140625
(596) DESCRIBE `ports` 0.00080394744873047
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00023007392883301
(598) DESCRIBE `ports` 0.00094008445739746
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00018906593322754
(600) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '70204') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.005357027053833
(601) DESCRIBE `avid_specials` 0.00069403648376465
(602) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70204 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.0012729167938232
(603) DESCRIBE `cruiselines` 0.0010120868682861
(604) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00022387504577637
(605) DESCRIBE `orchid_image` 0.00076603889465332
(606) DESCRIBE `cruiselines` 0.00095200538635254
(607) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00018692016601562
(608) DESCRIBE `ships` 0.0014331340789795
(609) SELECT `ships`.* FROM `ships` WHERE (id IN ('977', '1359', '1588', '407', '1067', '726', '462', '766', '452', '1415', '553', '674', '352', '610', '738', '1599')) ORDER BY FIND_IN_SET(id, '977,1359,1588,407,1067,726,462,766,452,1415,553,674,352,610,738,1599') 0.00092101097106934
(610) DESCRIBE `cruisetypes` 0.00066900253295898
(611) 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.026544809341431
(612) DESCRIBE `destinations` 0.0011758804321289
(613) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '37', '45', '52', '38', '26', '25', '28', '40', '35', '21', '49')) ORDER BY FIND_IN_SET(id, '22,12,37,45,52,38,26,25,28,40,35,21,49') 0.0009310245513916
(614) DESCRIBE `cruiselines` 0.0011661052703857
(615) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00026202201843262
(616) DESCRIBE `cruiselines` 0.0010499954223633
(617) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00022697448730469