or, enquire about your chosen options

  1. Ultra-Luxury Cruising
  2. The Caribbean is still a Preferred Cruise Destination
  3. Catch Up on Cruising: Latest News in bite size!
  4. 8 Romantic Destinations Around the World
  5. Royal Caribbean Launch “Royal Up”

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

 
  • Armonia, Honduras Mexico Cuba Jamaica Cayman Is ex Miami Return

    Nights 14 Ship MSC Armonia
    Star Rating 4 Star Departs Miami
    Sailing 2019: 22 Apr, 6 May, 20 May, 3 Jun, 17 Jun, 1 Jul, 15 Jul, 29 Jul, 12 Aug, 26 Aug, 9 Sep, 23 Sep, 7 Oct, 21 Oct
    Ports of Call Miami, Roatan, Costa Maya, Cozumel, Havana, Montego Bay, Grand Cayman (George Town)

    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.

  • Preziosa, UK, Belgium, Norway, Germany & France ex Southampton Return

    Nights 8 Ship MSC Preziosa
    Star Rating 4 Star Departs Southampton, England
    Sailing 2019: 22 Apr
    Ports of Call Southampton, Zeebrugge, Oslo, Hamburg, Le Havre

    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.

  • Armonia, Honduras Mexico Cuba ex Miami Return

    Nights 7 Ship MSC Armonia
    Star Rating 4 Star Departs Miami
    Sailing 2019: 22 Apr, 6 May, 20 May, 3 Jun, 17 Jun, 1 Jul, 15 Jul, 29 Jul, 12 Aug, 26 Aug, 9 Sep, 23 Sep, 7 Oct, 21 Oct, 4 Nov 2020: 16 Mar, 30 Mar
    Ports of Call Miami, Roatan, Costa Maya, Cozumel, Havana

    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 Mallorca Roundtrip

    Nights 7 Ship MSC Fantasia
    Star Rating 4 Star Departs Mallorca, Spain
    Sailing 2019: 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, 14 Oct
    Ports of Call Mallorca, Ibiza, Naples, Livorno, Genoa, 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.

  • Seaview, Italy France Spain ex Genoa Return

    Nights 7 Ship MSC Seaview
    Star Rating 4 Star Departs Genoa, Italy
    Sailing 2019: 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, 14 Oct, 21 Oct, 28 Oct, 4 Nov
    Ports of Call Genoa, La Spezia, Rome (Civitavecchia), Cannes, Mallorca, Barcelona, Ajaccio

    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.

  • Bellissima, Italy Malta Spain France ex Naples Return

    Nights 7 Ship MSC Bellissima
    Star Rating Not Rated Departs Naples, Italy
    Sailing 2019: 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, 14 Oct, 21 Oct, 28 Oct
    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.

  • Preziosa, UK, Belgium, Norway & Germany ex Southampton to Hamburg

    Nights 5 Ship MSC Preziosa
    Star Rating 4 Star Departs Southampton, England
    Sailing 2019: 22 Apr
    Ports of Call Southampton, Zeebrugge, Oslo, 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.

  • Poesia, Northern Europe ex Berlin (Warnemunde) Return

    Nights 11 Ship MSC Poesia
    Star Rating 4 Star Departs Berlin (Warnemunde)
    Sailing 2019: 23 Apr, 4 May, 15 May
    Ports of Call Berlin (Warnemunde), Gdynia, Klaipeda, Riga, Tallinn, St Petersburg, Helsinki, Stockholm Sweden, Copenhagen

    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, Northern Europe ex Berlin (Warnemunde) to Copenhagen

    Nights 10 Ship MSC Poesia
    Star Rating 4 Star Departs Berlin (Warnemunde)
    Sailing 2019: 23 Apr
    Ports of Call Berlin (Warnemunde), Gdynia, Klaipeda, Riga, Tallinn, St Petersburg, Helsinki, Stockholm Sweden, Copenhagen

    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.

  • Bellissima, Italy Malta Spain France ex Messina Return

    Nights 7 Ship MSC Bellissima
    Star Rating Not Rated Departs Messina, Sicily. IT
    Sailing 2019: 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, 8 Oct, 15 Oct, 22 Oct, 29 Oct
    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.

 

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

Total elapsed time: 0.64909291267395

# Query Time
(1) connect 0.00091695785522461
(2) DESCRIBE `cruises` 0.0033259391784668
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (76747, 77183, 76572, 76800, 77088, 69366, 77182, 77099, 77098, 69367)) ORDER BY FIND_IN_SET(id, '76747,77183,76572,76800,77088,69366,77182,77099,77098,69367') 0.0014898777008057
(4) DESCRIBE `cruises` 0.0031120777130127
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76747') 0.00040388107299805
(6) DESCRIBE `ships` 0.0027320384979248
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 452))) 0.0003662109375
(8) DESCRIBE `ships` 0.0027580261230469
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '452') 0.00029492378234863
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031709671020508
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025200843811035
(12) DESCRIBE `itineraries` 0.0013301372528076
(13) DESCRIBE `ports` 0.0015690326690674
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00034999847412109
(15) DESCRIBE `ports` 0.001507043838501
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00030708312988281
(17) DESCRIBE `ports` 0.0013749599456787
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00035905838012695
(19) DESCRIBE `sailingdates` 0.0010957717895508
(20) DESCRIBE `ports` 0.0014398097991943
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00033783912658691
(22) DESCRIBE `ports` 0.0013020038604736
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00027704238891602
(24) DESCRIBE `ports` 0.0012760162353516
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00029301643371582
(26) DESCRIBE `ports` 0.001399040222168
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00029301643371582
(28) DESCRIBE `ports` 0.0013129711151123
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.0003960132598877
(30) DESCRIBE `ports` 0.0017719268798828
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00041007995605469
(32) DESCRIBE `ports` 0.0015749931335449
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00032806396484375
(34) DESCRIBE `ports` 0.0014638900756836
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00034689903259277
(36) DESCRIBE `ports` 0.0013229846954346
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00027918815612793
(38) DESCRIBE `ports` 0.0012938976287842
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00028705596923828
(40) DESCRIBE `ports` 0.0014119148254395
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0003509521484375
(42) DESCRIBE `ports` 0.0014200210571289
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00028014183044434
(44) DESCRIBE `ports` 0.0014979839324951
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0003819465637207
(46) DESCRIBE `ports` 0.001410961151123
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00029110908508301
(48) DESCRIBE `ports` 0.0014810562133789
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 344))) 0.00037598609924316
(50) DESCRIBE `ports` 0.0014448165893555
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '344') 0.00033092498779297
(52) DESCRIBE `ports` 0.0013010501861572
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.0002901554107666
(54) DESCRIBE `ports` 0.0016119480133057
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00028204917907715
(56) DESCRIBE `ports` 0.0014910697937012
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00029492378234863
(58) DESCRIBE `ports` 0.0013790130615234
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00029921531677246
(60) DESCRIBE `ports` 0.0014209747314453
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00027918815612793
(62) DESCRIBE `ports` 0.0014688968658447
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00028681755065918
(64) DESCRIBE `ports` 0.0014441013336182
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0003049373626709
(66) DESCRIBE `ports` 0.0014069080352783
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00030016899108887
(68) DESCRIBE `ports` 0.0017249584197998
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00039100646972656
(70) DESCRIBE `ports` 0.0017960071563721
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00049591064453125
(72) DESCRIBE `avid_specials` 0.0015308856964111
(73) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76747 and class = 'Cruise') OR (item_id = 452 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.0011930465698242
(74) DESCRIBE `cruiselines` 0.0021660327911377
(75) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00036716461181641
(76) DESCRIBE `orchid_image` 0.0016870498657227
(77) DESCRIBE `cruiselines` 0.0021839141845703
(78) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00035905838012695
(79) DESCRIBE `cruises` 0.0028629302978516
(80) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77183') 0.00032711029052734
(81) DESCRIBE `ships` 0.0031509399414062
(82) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1067))) 0.00042891502380371
(83) DESCRIBE `ships` 0.0031960010528564
(84) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1067') 0.00033998489379883
(85) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030398368835449
(86) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028419494628906
(87) DESCRIBE `itineraries` 0.00130295753479
(88) DESCRIBE `ports` 0.0012679100036621
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00035595893859863
(90) DESCRIBE `ports` 0.0013759136199951
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00029110908508301
(92) DESCRIBE `ports` 0.0013108253479004
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00027203559875488
(94) DESCRIBE `sailingdates` 0.0011420249938965
(95) DESCRIBE `ports` 0.001317024230957
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00037884712219238
(97) DESCRIBE `ports` 0.0019409656524658
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00046420097351074
(99) DESCRIBE `ports` 0.0019490718841553
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.00031113624572754
(101) DESCRIBE `ports` 0.0012969970703125
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.00029897689819336
(103) DESCRIBE `ports` 0.0014090538024902
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00034713745117188
(105) DESCRIBE `ports` 0.0014801025390625
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00036787986755371
(107) DESCRIBE `ports` 0.0015871524810791
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00032806396484375
(109) DESCRIBE `ports` 0.0012919902801514
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00026202201843262
(111) DESCRIBE `ports` 0.0013020038604736
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00030303001403809
(113) DESCRIBE `ports` 0.0013909339904785
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.0002739429473877
(115) DESCRIBE `ports` 0.0013189315795898
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00029110908508301
(117) DESCRIBE `ports` 0.0012679100036621
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00038313865661621
(119) DESCRIBE `avid_specials` 0.0015029907226562
(120) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77183 and class = 'Cruise') OR (item_id = 1067 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.0014729499816895
(121) DESCRIBE `cruiselines` 0.0023670196533203
(122) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00037288665771484
(123) DESCRIBE `orchid_image` 0.0018410682678223
(124) DESCRIBE `cruiselines` 0.0021741390228271
(125) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00030303001403809
(126) DESCRIBE `cruises` 0.002964973449707
(127) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76572') 0.00053882598876953
(128) DESCRIBE `ships` 0.0030219554901123
(129) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 452))) 0.00046300888061523
(130) DESCRIBE `ships` 0.0031819343566895
(131) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '452') 0.00032305717468262
(132) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026607513427734
(133) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029683113098145
(134) DESCRIBE `itineraries` 0.001270055770874
(135) DESCRIBE `ports` 0.0013270378112793
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00032305717468262
(137) DESCRIBE `ports` 0.0012860298156738
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00030708312988281
(139) DESCRIBE `ports` 0.0013539791107178
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00029301643371582
(141) DESCRIBE `sailingdates` 0.0011579990386963
(142) DESCRIBE `ports` 0.0023899078369141
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0005190372467041
(144) DESCRIBE `ports` 0.0019299983978271
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00043201446533203
(146) DESCRIBE `ports` 0.0017991065979004
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00040316581726074
(148) DESCRIBE `ports` 0.0017290115356445
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.0003819465637207
(150) DESCRIBE `ports` 0.0017828941345215
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00044894218444824
(152) DESCRIBE `ports` 0.0017940998077393
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.0003659725189209
(154) DESCRIBE `ports` 0.001694917678833
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00042104721069336
(156) DESCRIBE `ports` 0.0017590522766113
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.0004119873046875
(158) DESCRIBE `ports` 0.0018129348754883
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00041985511779785
(160) DESCRIBE `ports` 0.0018420219421387
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.000244140625
(162) DESCRIBE `ports` 0.0017838478088379
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00049495697021484
(164) DESCRIBE `ports` 0.0017330646514893
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00050783157348633
(166) DESCRIBE `ports` 0.0017290115356445
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00042605400085449
(168) DESCRIBE `ports` 0.0019679069519043
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0015759468078613
(170) DESCRIBE `avid_specials` 0.0014297962188721
(171) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76572 and class = 'Cruise') OR (item_id = 452 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.0014128684997559
(172) DESCRIBE `cruiselines` 0.0021359920501709
(173) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00036406517028809
(174) DESCRIBE `orchid_image` 0.0016050338745117
(175) DESCRIBE `cruiselines` 0.0019428730010986
(176) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00034594535827637
(177) DESCRIBE `cruises` 0.0028259754180908
(178) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76800') 0.0003509521484375
(179) DESCRIBE `ships` 0.0038549900054932
(180) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 726))) 0.00054502487182617
(181) DESCRIBE `ships` 0.0035979747772217
(182) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '726') 0.0004889965057373
(183) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027298927307129
(184) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025796890258789
(185) DESCRIBE `itineraries` 0.0013880729675293
(186) DESCRIBE `ports` 0.0015089511871338
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00036883354187012
(188) DESCRIBE `ports` 0.001507043838501
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00033783912658691
(190) DESCRIBE `ports` 0.0013909339904785
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00032305717468262
(192) DESCRIBE `sailingdates` 0.0011570453643799
(193) DESCRIBE `ports` 0.0026068687438965
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00054121017456055
(195) DESCRIBE `ports` 0.0020031929016113
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00040602684020996
(197) DESCRIBE `ports` 0.0018651485443115
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00038385391235352
(199) DESCRIBE `ports` 0.0015199184417725
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00032496452331543
(201) DESCRIBE `ports` 0.0016958713531494
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 703))) 0.00040411949157715
(203) DESCRIBE `ports` 0.0013439655303955
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '703') 0.00031208992004395
(205) DESCRIBE `ports` 0.001471996307373
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00039482116699219
(207) DESCRIBE `ports` 0.0015089511871338
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00037598609924316
(209) DESCRIBE `ports` 0.0014400482177734
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00040292739868164
(211) DESCRIBE `ports` 0.0013668537139893
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.0002901554107666
(213) DESCRIBE `ports` 0.0012750625610352
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00030517578125
(215) DESCRIBE `ports` 0.0012640953063965
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00028610229492188
(217) DESCRIBE `ports` 0.001471996307373
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00039291381835938
(219) DESCRIBE `ports` 0.0016970634460449
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00049185752868652
(221) DESCRIBE `ports` 0.0014159679412842
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00031709671020508
(223) DESCRIBE `ports` 0.0015099048614502
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.0002748966217041
(225) DESCRIBE `avid_specials` 0.0012228488922119
(226) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76800 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.0035359859466553
(227) DESCRIBE `cruiselines` 0.0027718544006348
(228) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00091695785522461
(229) DESCRIBE `orchid_image` 0.0021319389343262
(230) DESCRIBE `cruiselines` 0.0042760372161865
(231) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00047993659973145
(232) DESCRIBE `cruises` 0.0035028457641602
(233) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77088') 0.00043702125549316
(234) DESCRIBE `ships` 0.0040087699890137
(235) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1588))) 0.00051021575927734
(236) DESCRIBE `ships` 0.0036020278930664
(237) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1588') 0.00045680999755859
(238) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018191337585449
(239) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028395652770996
(240) DESCRIBE `itineraries` 0.0019781589508057
(241) DESCRIBE `ports` 0.0018579959869385
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00040912628173828
(243) DESCRIBE `ports` 0.0016758441925049
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00037503242492676
(245) DESCRIBE `ports` 0.0016438961029053
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00041317939758301
(247) DESCRIBE `sailingdates` 0.0014369487762451
(248) DESCRIBE `ports` 0.0067892074584961
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00058698654174805
(250) DESCRIBE `ports` 0.0017831325531006
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00038003921508789
(252) DESCRIBE `ports` 0.0018219947814941
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2264))) 0.0054459571838379
(254) DESCRIBE `ports` 0.0016100406646729
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2264') 0.00038003921508789
(256) DESCRIBE `ports` 0.0015289783477783
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00033807754516602
(258) DESCRIBE `ports` 0.0017931461334229
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00032901763916016
(260) DESCRIBE `ports` 0.0015261173248291
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00029897689819336
(262) DESCRIBE `ports` 0.0011870861053467
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00035810470581055
(264) DESCRIBE `ports` 0.001539945602417
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00048494338989258
(266) DESCRIBE `ports` 0.0015509128570557
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00048398971557617
(268) DESCRIBE `ports` 0.0018579959869385
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00043416023254395
(270) DESCRIBE `ports` 0.0018789768218994
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00030899047851562
(272) DESCRIBE `ports` 0.0014939308166504
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00026607513427734
(274) DESCRIBE `ports` 0.0015699863433838
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00028204917907715
(276) DESCRIBE `ports` 0.0011360645294189
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00040316581726074
(278) DESCRIBE `ports` 0.0012118816375732
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00043201446533203
(280) DESCRIBE `avid_specials` 0.0012369155883789
(281) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77088 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.0010759830474854
(282) DESCRIBE `cruiselines` 0.0025088787078857
(283) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00037980079650879
(284) DESCRIBE `orchid_image` 0.0015120506286621
(285) DESCRIBE `cruiselines` 0.0021438598632812
(286) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00032901763916016
(287) DESCRIBE `cruises` 0.0026969909667969
(288) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69366') 0.00043487548828125
(289) DESCRIBE `ships` 0.0038549900054932
(290) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1599))) 0.00047707557678223
(291) DESCRIBE `ships` 0.0029370784759521
(292) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1599') 0.00036811828613281
(293) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00026512145996094
(294) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00024986267089844
(295) DESCRIBE `itineraries` 0.0015289783477783
(296) DESCRIBE `ports` 0.0013749599456787
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00031900405883789
(298) DESCRIBE `ports` 0.0013270378112793
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00029492378234863
(300) DESCRIBE `ports` 0.0014870166778564
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00030088424682617
(302) DESCRIBE `sailingdates` 0.001349925994873
(303) DESCRIBE `ports` 0.0018360614776611
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.0003809928894043
(305) DESCRIBE `ports` 0.0014081001281738
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.0003199577331543
(307) DESCRIBE `ports` 0.0014638900756836
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00030612945556641
(309) DESCRIBE `ports` 0.0013899803161621
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.0002901554107666
(311) DESCRIBE `ports` 0.0012600421905518
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00029301643371582
(313) DESCRIBE `ports` 0.0013480186462402
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.0002751350402832
(315) DESCRIBE `ports` 0.0015289783477783
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00037693977355957
(317) DESCRIBE `ports` 0.0014688968658447
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00027680397033691
(319) DESCRIBE `ports` 0.0014171600341797
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.0003049373626709
(321) DESCRIBE `ports` 0.0012660026550293
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00032901763916016
(323) DESCRIBE `ports` 0.0013689994812012
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00030398368835449
(325) DESCRIBE `ports` 0.0013790130615234
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00027704238891602
(327) DESCRIBE `ports` 0.001366138458252
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00038409233093262
(329) DESCRIBE `ports` 0.0015170574188232
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00027203559875488
(331) DESCRIBE `avid_specials` 0.0011699199676514
(332) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69366 and class = 'Cruise') OR (item_id = 1599 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
(333) DESCRIBE `cruiselines` 0.0022158622741699
(334) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00035595893859863
(335) DESCRIBE `orchid_image` 0.0014770030975342
(336) DESCRIBE `cruiselines` 0.0022389888763428
(337) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00037312507629395
(338) DESCRIBE `cruises` 0.002769947052002
(339) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77182') 0.00032496452331543
(340) DESCRIBE `ships` 0.0030519962310791
(341) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1067))) 0.00044393539428711
(342) DESCRIBE `ships` 0.0029809474945068
(343) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1067') 0.00034499168395996
(344) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002899169921875
(345) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031781196594238
(346) DESCRIBE `itineraries` 0.0014610290527344
(347) DESCRIBE `ports` 0.0014650821685791
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00037097930908203
(349) DESCRIBE `ports` 0.0014629364013672
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0003960132598877
(351) DESCRIBE `ports` 0.0014081001281738
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00036287307739258
(353) DESCRIBE `sailingdates` 0.0012140274047852
(354) DESCRIBE `ports` 0.0016980171203613
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00031304359436035
(356) DESCRIBE `ports` 0.0018541812896729
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00035285949707031
(358) DESCRIBE `ports` 0.0014967918395996
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.00031399726867676
(360) DESCRIBE `ports` 0.0013890266418457
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.00029087066650391
(362) DESCRIBE `ports` 0.0014219284057617
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00033903121948242
(364) DESCRIBE `ports` 0.0013608932495117
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00027585029602051
(366) DESCRIBE `ports` 0.0013270378112793
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00037693977355957
(368) DESCRIBE `ports` 0.00148606300354
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.0003669261932373
(370) DESCRIBE `avid_specials` 0.0014438629150391
(371) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77182 and class = 'Cruise') OR (item_id = 1067 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.001338005065918
(372) DESCRIBE `cruiselines` 0.002241849899292
(373) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00045013427734375
(374) DESCRIBE `orchid_image` 0.0016310214996338
(375) DESCRIBE `cruiselines` 0.0018410682678223
(376) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00030994415283203
(377) DESCRIBE `cruises` 0.0027568340301514
(378) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77099') 0.00040698051452637
(379) DESCRIBE `ships` 0.0029079914093018
(380) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 674))) 0.00052690505981445
(381) DESCRIBE `ships` 0.0028648376464844
(382) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '674') 0.00031900405883789
(383) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026702880859375
(384) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032877922058105
(385) DESCRIBE `itineraries` 0.0017139911651611
(386) DESCRIBE `ports` 0.0017509460449219
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00031900405883789
(388) DESCRIBE `ports` 0.0013461112976074
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00031495094299316
(390) DESCRIBE `ports` 0.0017158985137939
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00039887428283691
(392) DESCRIBE `sailingdates` 0.0015449523925781
(393) DESCRIBE `ports` 0.0013260841369629
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00033807754516602
(395) DESCRIBE `ports` 0.001572847366333
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00032901763916016
(397) DESCRIBE `ports` 0.0015950202941895
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 653))) 0.00041508674621582
(399) DESCRIBE `ports` 0.0013489723205566
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '653') 0.00029802322387695
(401) DESCRIBE `ports` 0.0012729167938232
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00032591819763184
(403) DESCRIBE `ports` 0.0015628337860107
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00030994415283203
(405) DESCRIBE `ports` 0.0013949871063232
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.00034809112548828
(407) DESCRIBE `ports` 0.0016381740570068
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.00036311149597168
(409) DESCRIBE `ports` 0.0015709400177002
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.0004570484161377
(411) DESCRIBE `ports` 0.0018880367279053
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00040888786315918
(413) DESCRIBE `ports` 0.0014939308166504
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00040793418884277
(415) DESCRIBE `ports` 0.0020928382873535
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00032997131347656
(417) DESCRIBE `ports` 0.0015778541564941
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00036191940307617
(419) DESCRIBE `ports` 0.0018599033355713
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0004730224609375
(421) DESCRIBE `ports` 0.0019199848175049
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00042390823364258
(423) DESCRIBE `ports` 0.0016510486602783
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00031900405883789
(425) DESCRIBE `ports` 0.0017910003662109
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.0004279613494873
(427) DESCRIBE `ports` 0.0018668174743652
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00035190582275391
(429) DESCRIBE `ports` 0.0017189979553223
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0003819465637207
(431) DESCRIBE `ports` 0.0016658306121826
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00036287307739258
(433) DESCRIBE `ports` 0.0016438961029053
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.0003821849822998
(435) DESCRIBE `ports` 0.0017209053039551
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00028800964355469
(437) DESCRIBE `avid_specials` 0.0012960433959961
(438) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77099 and class = 'Cruise') OR (item_id = 674 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 26 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.0017521381378174
(439) DESCRIBE `cruiselines` 0.0025720596313477
(440) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00047397613525391
(441) DESCRIBE `orchid_image` 0.0020270347595215
(442) DESCRIBE `cruiselines` 0.0026569366455078
(443) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00076103210449219
(444) DESCRIBE `cruises` 0.0038819313049316
(445) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77098') 0.00044894218444824
(446) DESCRIBE `ships` 0.0038559436798096
(447) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 674))) 0.00045204162597656
(448) DESCRIBE `ships` 0.0032029151916504
(449) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '674') 0.00037384033203125
(450) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032496452331543
(451) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032591819763184
(452) DESCRIBE `itineraries` 0.0015830993652344
(453) DESCRIBE `ports` 0.0013790130615234
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00031900405883789
(455) DESCRIBE `ports` 0.0013210773468018
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00029993057250977
(457) DESCRIBE `ports` 0.0013279914855957
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00027799606323242
(459) DESCRIBE `sailingdates` 0.0012819766998291
(460) DESCRIBE `ports` 0.0013320446014404
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00031590461730957
(462) DESCRIBE `ports` 0.0013558864593506
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00037097930908203
(464) DESCRIBE `ports` 0.0013358592987061
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 653))) 0.00032305717468262
(466) DESCRIBE `ports` 0.001554012298584
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '653') 0.00028181076049805
(468) DESCRIBE `ports` 0.0013129711151123
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1703))) 0.00037908554077148
(470) DESCRIBE `ports` 0.0013248920440674
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1703') 0.00028204917907715
(472) DESCRIBE `ports` 0.0016510486602783
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 518))) 0.00030899047851562
(474) DESCRIBE `ports` 0.0013570785522461
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '518') 0.0003821849822998
(476) DESCRIBE `ports` 0.0014379024505615
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00034403800964355
(478) DESCRIBE `ports` 0.002540111541748
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00059914588928223
(480) DESCRIBE `ports` 0.001917839050293
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00043702125549316
(482) DESCRIBE `ports` 0.0018630027770996
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00036406517028809
(484) DESCRIBE `ports` 0.0017099380493164
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00041389465332031
(486) DESCRIBE `ports` 0.0018019676208496
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00043106079101562
(488) DESCRIBE `ports` 0.0018188953399658
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00057196617126465
(490) DESCRIBE `ports` 0.0015919208526611
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00040793418884277
(492) DESCRIBE `ports` 0.0017349720001221
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00035190582275391
(494) DESCRIBE `ports` 0.0016570091247559
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00038313865661621
(496) DESCRIBE `ports` 0.0018310546875
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00043702125549316
(498) DESCRIBE `ports` 0.0017869472503662
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00017118453979492
(500) DESCRIBE `avid_specials` 0.0016751289367676
(501) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77098 and class = 'Cruise') OR (item_id = 674 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 26 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.0014889240264893
(502) DESCRIBE `cruiselines` 0.0022170543670654
(503) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00040817260742188
(504) DESCRIBE `orchid_image` 0.0019168853759766
(505) DESCRIBE `cruiselines` 0.0023617744445801
(506) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00032782554626465
(507) DESCRIBE `cruises` 0.0040740966796875
(508) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69367') 0.00045585632324219
(509) DESCRIBE `ships` 0.0039429664611816
(510) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1599))) 0.00051689147949219
(511) DESCRIBE `ships` 0.0031669139862061
(512) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1599') 0.00042986869812012
(513) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.0003809928894043
(514) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00034689903259277
(515) DESCRIBE `itineraries` 0.0016930103302002
(516) DESCRIBE `ports` 0.0018401145935059
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00047492980957031
(518) DESCRIBE `ports` 0.001378059387207
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00034499168395996
(520) DESCRIBE `ports` 0.0014801025390625
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00030207633972168
(522) DESCRIBE `sailingdates` 0.0011498928070068
(523) DESCRIBE `ports` 0.0015599727630615
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00041389465332031
(525) DESCRIBE `ports` 0.0016040802001953
(526) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00036001205444336
(527) DESCRIBE `ports` 0.0018432140350342
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00045394897460938
(529) DESCRIBE `ports` 0.0018930435180664
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00033998489379883
(531) DESCRIBE `ports` 0.0014951229095459
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00039196014404297
(533) DESCRIBE `ports` 0.0017540454864502
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00039196014404297
(535) DESCRIBE `ports` 0.001788854598999
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00031685829162598
(537) DESCRIBE `ports` 0.0015830993652344
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00029897689819336
(539) DESCRIBE `ports` 0.0014681816101074
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00048017501831055
(541) DESCRIBE `ports` 0.0018529891967773
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00038504600524902
(543) DESCRIBE `ports` 0.0014431476593018
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.0003352165222168
(545) DESCRIBE `ports` 0.0013270378112793
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00040221214294434
(547) DESCRIBE `ports` 0.0019009113311768
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00045084953308105
(549) DESCRIBE `ports` 0.0020039081573486
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00033712387084961
(551) DESCRIBE `avid_specials` 0.0016040802001953
(552) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69367 and class = 'Cruise') OR (item_id = 1599 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.0011777877807617
(553) DESCRIBE `cruiselines` 0.0020928382873535
(554) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00041103363037109
(555) DESCRIBE `orchid_image` 0.0015711784362793
(556) DESCRIBE `cruiselines` 0.0025830268859863
(557) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00041604042053223
(558) DESCRIBE `ships` 0.0036718845367432
(559) SELECT `ships`.* FROM `ships` WHERE (id IN ('726', '977', '1717', '1359', '1599', '1588', '766', '1768', '1067', '452', '407', '674', '1415', '462', '610', '553', '352', '738')) ORDER BY FIND_IN_SET(id, '726,977,1717,1359,1599,1588,766,1768,1067,452,407,674,1415,462,610,553,352,738') 0.0018770694732666
(560) DESCRIBE `cruisetypes` 0.0014839172363281
(561) DESCRIBE `destinations` 0.0017437934875488
(562) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '25', '26', '37', '45', '28', '52', '38', '40', '9', '11', '49', '21')) ORDER BY FIND_IN_SET(id, '22,12,25,26,37,45,28,52,38,40,9,11,49,21') 0.0020270347595215
(563) DESCRIBE `cruiselines` 0.0023000240325928
(564) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00043797492980957
(565) DESCRIBE `cruiselines` 0.0021679401397705
(566) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00041007995605469