or, enquire about your chosen options

  1. Carnival Cruise Line teams up with Harlem Globetrotters
  2. Ultra-Luxury Cruising
  3. The Caribbean is still a Preferred Cruise Destination
  4. Catch Up on Cruising: Latest News in bite size!
  5. 8 Romantic Destinations Around the World

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

 
  • Symphony, Western Caribbean & Perfect Day ex Miami Roundtrip

    Nights 7 Ship Symphony of the Seas
    Star Rating 4 Star Departs Miami
    Sailing 2019: 20 Jul, 3 Aug, 17 Aug, 14 Sep, 28 Sep, 12 Oct, 26 Oct, 9 Nov, 23 Nov, 7 Dec, 21 Dec 2020: 4 Jan, 18 Jan, 1 Feb, 15 Feb, 29 Feb, 14 Mar, 28 Mar, 11 Apr, 25 Apr, 7 Nov, 21 Nov, 5 Dec, 19 Dec 2021: 2 Jan, 16 Jan, 30 Jan, 13 Feb, 27 Feb, 13 Mar, 27 Mar, 10 Apr, 24 Apr
    Ports of Call Miami, Roatan, Costa Maya, Cozumel, Cococay

    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.

  • Symphony, Eastern Caribbean Cruise ex Miami Roundtrip

    Nights 7 Ship Symphony of the Seas
    Star Rating 4 Star Departs Miami
    Sailing 2019: 10 Aug, 7 Sep, 5 Oct, 16 Nov, 14 Dec 2020: 11 Jan, 8 Feb, 7 Mar, 4 Apr
    Ports of Call Miami, Basseterre, Charlotte Amalie, Cococay

    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.

  • Symphony, Bahamas ex Miami Return

    Nights 3 Ship Symphony of the Seas
    Star Rating 4 Star Departs Miami
    Sailing 2019: 31 Aug
    Ports of Call Miami, Nassau

    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.

  • Symphony, Bahamas ex Miami Return

    Nights 4 Ship Symphony of the Seas
    Star Rating 4 Star Departs Miami
    Sailing 2019: 3 Sep
    Ports of Call Miami, Nassau, Cococay

    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.

  • Symphony, Eastern Caribbean ex Miami Roundtrip

    Nights 7 Ship Symphony of the Seas
    Star Rating 4 Star Departs Miami
    Sailing 2019: 21 Sep
    Ports of Call Miami, Philipsburg, San Juan, Labadee

    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.

  • Symphony, Eastern Caribbean & Perfect Day ex Miami Return

    Nights 7 Ship Symphony of the Seas
    Star Rating 4 Star Departs Miami
    Sailing 2019: 28 Dec 2020: 18 Apr, 31 Oct, 28 Nov, 26 Dec 2021: 6 Feb, 6 Mar, 3 Apr
    Ports of Call Miami, Philipsburg, San Juan, Cococay

    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.

  • Symphony, A Perfect Day & Eastern Caribbean Cruise ex Miami Return

    Nights 7 Ship Symphony of the Seas
    Star Rating 4 Star Departs Miami
    Sailing 2020: 2 May, 23 May, 13 Jun, 4 Jul, 25 Jul, 15 Aug, 5 Sep, 26 Sep, 17 Oct
    Ports of Call Miami, Philipsburg, Charlotte Amalie, Cococay

    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.

  • Symphony, An Eastern Caribbean & Perfect Day ex Miami Return

    Nights 7 Ship Symphony of the Seas
    Star Rating 4 Star Departs Miami
    Sailing 2020: 9 May, 30 May, 20 Jun, 11 Jul, 1 Aug, 22 Aug, 12 Sep, 3 Oct, 24 Oct, 14 Nov, 12 Dec 2021: 9 Jan, 23 Jan, 20 Feb, 20 Mar, 17 Apr
    Ports of Call Miami, Labadee, San Juan, Charlotte Amalie, Cococay

    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.

  • Symphony, A Western Caribbean Cruise ex Miami Return

    Nights 7 Ship Symphony of the Seas
    Star Rating 4 Star Departs Miami
    Sailing 2020: 16 May, 6 Jun, 27 Jun, 18 Jul, 8 Aug, 29 Aug, 19 Sep, 10 Oct
    Ports of Call Miami, Labadee, Falmouth, Cozumel

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

Total elapsed time: 0.68175649642944

# Query Time
(1) connect 0.0014650821685791
(2) DESCRIBE `cruises` 0.0047249794006348
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (73558, 73557, 73555, 73556, 82018, 81361, 81364, 81362, 81363)) ORDER BY FIND_IN_SET(id, '73558,73557,73555,73556,82018,81361,81364,81362,81363') 0.0023560523986816
(4) DESCRIBE `cruises` 0.0048680305480957
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73558') 0.00056815147399902
(6) DESCRIBE `ships` 0.0057518482208252
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1586))) 0.00056910514831543
(8) DESCRIBE `ships` 0.0037651062011719
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1586') 0.00044703483581543
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036287307739258
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035285949707031
(12) DESCRIBE `itineraries` 0.0019338130950928
(13) DESCRIBE `ports` 0.0027561187744141
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00042295455932617
(15) DESCRIBE `ports` 0.001945972442627
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00043487548828125
(17) DESCRIBE `ports` 0.002047061920166
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00039196014404297
(19) DESCRIBE `sailingdates` 0.0023629665374756
(20) DESCRIBE `ports` 0.0024740695953369
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00044512748718262
(22) DESCRIBE `ports` 0.002406120300293
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00040006637573242
(24) DESCRIBE `ports` 0.0018279552459717
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.0003960132598877
(26) DESCRIBE `ports` 0.0022139549255371
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00037908554077148
(28) DESCRIBE `ports` 0.0025820732116699
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00040483474731445
(30) DESCRIBE `ports` 0.0024290084838867
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00037002563476562
(32) DESCRIBE `ports` 0.0018670558929443
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00049185752868652
(34) DESCRIBE `ports` 0.0021400451660156
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00037193298339844
(36) DESCRIBE `ports` 0.0026369094848633
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.00039005279541016
(38) DESCRIBE `ports` 0.0023059844970703
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.00042390823364258
(40) DESCRIBE `ports` 0.0020120143890381
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046610832214355
(42) DESCRIBE `ports` 0.0019831657409668
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0004279613494873
(44) DESCRIBE `avid_specials` 0.0020051002502441
(45) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73558 and class = 'Cruise') OR (item_id = 1586 AND class = 'Ship') OR (item_id = 26 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.0016300678253174
(46) DESCRIBE `cruiselines` 0.0028128623962402
(47) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00042510032653809
(48) DESCRIBE `orchid_image` 0.0022211074829102
(49) DESCRIBE `cruiselines` 0.0027139186859131
(50) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00036406517028809
(51) DESCRIBE `cruises` 0.0035510063171387
(52) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73557') 0.00040197372436523
(53) DESCRIBE `ships` 0.0039219856262207
(54) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1586))) 0.00046396255493164
(55) DESCRIBE `ships` 0.0039949417114258
(56) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1586') 0.0005190372467041
(57) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00048398971557617
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00050806999206543
(59) DESCRIBE `itineraries` 0.0025601387023926
(60) DESCRIBE `ports` 0.0027129650115967
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0005638599395752
(62) DESCRIBE `ports` 0.0025238990783691
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00056004524230957
(64) DESCRIBE `ports` 0.0032598972320557
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00055408477783203
(66) DESCRIBE `sailingdates` 0.0033628940582275
(67) DESCRIBE `ports` 0.0032699108123779
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00070095062255859
(69) DESCRIBE `ports` 0.0027339458465576
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00040984153747559
(71) DESCRIBE `ports` 0.0021510124206543
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00043106079101562
(73) DESCRIBE `ports` 0.0019409656524658
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00038981437683105
(75) DESCRIBE `ports` 0.0020937919616699
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 347))) 0.00043797492980957
(77) DESCRIBE `ports` 0.0026259422302246
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '347') 0.0003821849822998
(79) DESCRIBE `ports` 0.0019850730895996
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.0004122257232666
(81) DESCRIBE `ports` 0.002032995223999
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.0003809928894043
(83) DESCRIBE `ports` 0.0031359195709229
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00042200088500977
(85) DESCRIBE `ports` 0.0024459362030029
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00055909156799316
(87) DESCRIBE `avid_specials` 0.0024368762969971
(88) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73557 and class = 'Cruise') OR (item_id = 1586 AND class = 'Ship') OR (item_id = 26 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.001323938369751
(89) DESCRIBE `cruiselines` 0.002903938293457
(90) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00044989585876465
(91) DESCRIBE `orchid_image` 0.0021960735321045
(92) DESCRIBE `cruiselines` 0.0029850006103516
(93) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00052595138549805
(94) DESCRIBE `cruises` 0.0044031143188477
(95) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73555') 0.00041294097900391
(96) DESCRIBE `ships` 0.0043590068817139
(97) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1586))) 0.00051093101501465
(98) DESCRIBE `ships` 0.0037109851837158
(99) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1586') 0.00040006637573242
(100) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00049209594726562
(101) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00050806999206543
(102) DESCRIBE `itineraries` 0.0027740001678467
(103) DESCRIBE `ports` 0.002910852432251
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00065112113952637
(105) DESCRIBE `ports` 0.0029091835021973
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00054693222045898
(107) DESCRIBE `ports` 0.0026140213012695
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00060796737670898
(109) DESCRIBE `sailingdates` 0.0022940635681152
(110) DESCRIBE `ports` 0.0021839141845703
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00048303604125977
(112) DESCRIBE `ports` 0.0021100044250488
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00046586990356445
(114) DESCRIBE `ports` 0.0021960735321045
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00043988227844238
(116) DESCRIBE `ports` 0.0020468235015869
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00048398971557617
(118) DESCRIBE `ports` 0.0018510818481445
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046014785766602
(120) DESCRIBE `ports` 0.0020132064819336
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00050902366638184
(122) DESCRIBE `avid_specials` 0.0017838478088379
(123) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73555 and class = 'Cruise') OR (item_id = 1586 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 9 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.0014879703521729
(124) DESCRIBE `cruiselines` 0.0029101371765137
(125) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00044488906860352
(126) DESCRIBE `orchid_image` 0.0028510093688965
(127) DESCRIBE `cruiselines` 0.0034971237182617
(128) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00056910514831543
(129) DESCRIBE `cruises` 0.0045161247253418
(130) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73556') 0.00044798851013184
(131) DESCRIBE `ships` 0.0042099952697754
(132) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1586))) 0.00051188468933105
(133) DESCRIBE `ships` 0.0049881935119629
(134) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1586') 0.00042414665222168
(135) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037097930908203
(136) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035214424133301
(137) DESCRIBE `itineraries` 0.0032010078430176
(138) DESCRIBE `ports` 0.0031960010528564
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00048494338989258
(140) DESCRIBE `ports` 0.0025429725646973
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00050616264343262
(142) DESCRIBE `ports` 0.0019431114196777
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00042891502380371
(144) DESCRIBE `sailingdates` 0.0018470287322998
(145) DESCRIBE `ports` 0.0035960674285889
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00070905685424805
(147) DESCRIBE `ports` 0.0029110908508301
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0006248950958252
(149) DESCRIBE `ports` 0.0030450820922852
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00064802169799805
(151) DESCRIBE `ports` 0.0029270648956299
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00057482719421387
(153) DESCRIBE `ports` 0.0029890537261963
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.00068807601928711
(155) DESCRIBE `ports` 0.0030131340026855
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.00057601928710938
(157) DESCRIBE `ports` 0.0033121109008789
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00065112113952637
(159) DESCRIBE `ports` 0.0028049945831299
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00060200691223145
(161) DESCRIBE `avid_specials` 0.0026021003723145
(162) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73556 and class = 'Cruise') OR (item_id = 1586 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 9 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.0029120445251465
(163) DESCRIBE `cruiselines` 0.0040121078491211
(164) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00062203407287598
(165) DESCRIBE `orchid_image` 0.003727912902832
(166) DESCRIBE `cruiselines` 0.0040619373321533
(167) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00038003921508789
(168) DESCRIBE `cruises` 0.0040848255157471
(169) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82018') 0.00038003921508789
(170) DESCRIBE `ships` 0.0042488574981689
(171) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1586))) 0.0005190372467041
(172) DESCRIBE `ships` 0.0037450790405273
(173) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1586') 0.00043511390686035
(174) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00042295455932617
(175) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035691261291504
(176) DESCRIBE `itineraries` 0.0020730495452881
(177) DESCRIBE `ports` 0.0024080276489258
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00051188468933105
(179) DESCRIBE `ports` 0.0022428035736084
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00058722496032715
(181) DESCRIBE `ports` 0.0019118785858154
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00049209594726562
(183) DESCRIBE `sailingdates` 0.0017380714416504
(184) DESCRIBE `ports` 0.0020301342010498
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00043511390686035
(186) DESCRIBE `ports` 0.0020439624786377
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00046586990356445
(188) DESCRIBE `ports` 0.0018961429595947
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00040102005004883
(190) DESCRIBE `ports` 0.0021848678588867
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00036311149597168
(192) DESCRIBE `ports` 0.0021891593933105
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0004119873046875
(194) DESCRIBE `ports` 0.0020689964294434
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00037693977355957
(196) DESCRIBE `ports` 0.0024099349975586
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 465))) 0.00041294097900391
(198) DESCRIBE `ports` 0.0022730827331543
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '465') 0.00041103363037109
(200) DESCRIBE `ports` 0.0027270317077637
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00056695938110352
(202) DESCRIBE `ports` 0.0023250579833984
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00042414665222168
(204) DESCRIBE `avid_specials` 0.0017108917236328
(205) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82018 and class = 'Cruise') OR (item_id = 1586 AND class = 'Ship') OR (item_id = 26 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.0012569427490234
(206) DESCRIBE `cruiselines` 0.0030488967895508
(207) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00044989585876465
(208) DESCRIBE `orchid_image` 0.0024089813232422
(209) DESCRIBE `cruiselines` 0.0032050609588623
(210) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.0003659725189209
(211) DESCRIBE `cruises` 0.0051810741424561
(212) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81361') 0.00050902366638184
(213) DESCRIBE `ships` 0.0038309097290039
(214) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1586))) 0.00053286552429199
(215) DESCRIBE `ships` 0.0036518573760986
(216) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1586') 0.00043201446533203
(217) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036406517028809
(218) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003659725189209
(219) DESCRIBE `itineraries` 0.0019490718841553
(220) DESCRIBE `ports` 0.0023550987243652
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00043702125549316
(222) DESCRIBE `ports` 0.0025999546051025
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00055193901062012
(224) DESCRIBE `ports` 0.0026900768280029
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00039982795715332
(226) DESCRIBE `sailingdates` 0.0024268627166748
(227) DESCRIBE `ports` 0.0029571056365967
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00062298774719238
(229) DESCRIBE `ports` 0.0026350021362305
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00042986869812012
(231) DESCRIBE `ports` 0.0025210380554199
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00052094459533691
(233) DESCRIBE `ports` 0.0027649402618408
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00046110153198242
(235) DESCRIBE `ports` 0.0025069713592529
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00054001808166504
(237) DESCRIBE `ports` 0.0024170875549316
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00046110153198242
(239) DESCRIBE `ports` 0.0024011135101318
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.00055503845214844
(241) DESCRIBE `ports` 0.0027821063995361
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.00043606758117676
(243) DESCRIBE `ports` 0.0021719932556152
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00049996376037598
(245) DESCRIBE `ports` 0.0026049613952637
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00040912628173828
(247) DESCRIBE `avid_specials` 0.0020449161529541
(248) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81361 and class = 'Cruise') OR (item_id = 1586 AND class = 'Ship') OR (item_id = 26 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.0013189315795898
(249) DESCRIBE `cruiselines` 0.0028011798858643
(250) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00043201446533203
(251) DESCRIBE `orchid_image` 0.0025629997253418
(252) DESCRIBE `cruiselines` 0.0025880336761475
(253) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00036907196044922
(254) DESCRIBE `cruises` 0.0065791606903076
(255) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81364') 0.00049996376037598
(256) DESCRIBE `ships` 0.0039970874786377
(257) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1586))) 0.00064802169799805
(258) DESCRIBE `ships` 0.003654956817627
(259) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1586') 0.0005340576171875
(260) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00051999092102051
(261) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0005488395690918
(262) DESCRIBE `itineraries` 0.0032820701599121
(263) DESCRIBE `ports` 0.0028722286224365
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00051689147949219
(265) DESCRIBE `ports` 0.0024650096893311
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046300888061523
(267) DESCRIBE `ports` 0.0034799575805664
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00061798095703125
(269) DESCRIBE `sailingdates` 0.0024900436401367
(270) DESCRIBE `ports` 0.0037870407104492
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00091910362243652
(272) DESCRIBE `ports` 0.0037500858306885
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00071001052856445
(274) DESCRIBE `ports` 0.0037541389465332
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00086522102355957
(276) DESCRIBE `ports` 0.00217604637146
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00044488906860352
(278) DESCRIBE `ports` 0.0023469924926758
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 347))) 0.00053906440734863
(280) DESCRIBE `ports` 0.0032389163970947
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '347') 0.00041890144348145
(282) DESCRIBE `ports` 0.0023868083953857
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.0004420280456543
(284) DESCRIBE `ports` 0.0023481845855713
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.0004730224609375
(286) DESCRIBE `ports` 0.0028691291809082
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00053620338439941
(288) DESCRIBE `ports` 0.0018179416656494
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00039815902709961
(290) DESCRIBE `avid_specials` 0.00177001953125
(291) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81364 and class = 'Cruise') OR (item_id = 1586 AND class = 'Ship') OR (item_id = 26 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.0012598037719727
(292) DESCRIBE `cruiselines` 0.004004955291748
(293) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00050592422485352
(294) DESCRIBE `orchid_image` 0.0029761791229248
(295) DESCRIBE `cruiselines` 0.0030889511108398
(296) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00041484832763672
(297) DESCRIBE `cruises` 0.0045449733734131
(298) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81362') 0.00039482116699219
(299) DESCRIBE `ships` 0.0046391487121582
(300) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1586))) 0.00049400329589844
(301) DESCRIBE `ships` 0.0040509700775146
(302) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1586') 0.00044989585876465
(303) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00042009353637695
(304) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035881996154785
(305) DESCRIBE `itineraries` 0.0018999576568604
(306) DESCRIBE `ports` 0.0018229484558105
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046181678771973
(308) DESCRIBE `ports` 0.0025599002838135
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00054311752319336
(310) DESCRIBE `ports` 0.0021698474884033
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00047016143798828
(312) DESCRIBE `sailingdates` 0.0021369457244873
(313) DESCRIBE `ports` 0.0022759437561035
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00051712989807129
(315) DESCRIBE `ports` 0.0018739700317383
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00055813789367676
(317) DESCRIBE `ports` 0.0024809837341309
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 465))) 0.00046086311340332
(319) DESCRIBE `ports` 0.0020849704742432
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '465') 0.00051093101501465
(321) DESCRIBE `ports` 0.0019629001617432
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00047516822814941
(323) DESCRIBE `ports` 0.0021028518676758
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00042319297790527
(325) DESCRIBE `ports` 0.0033137798309326
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 347))) 0.00054097175598145
(327) DESCRIBE `ports` 0.0026638507843018
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '347') 0.00069499015808105
(329) DESCRIBE `ports` 0.0026459693908691
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.00061607360839844
(331) DESCRIBE `ports` 0.002777099609375
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.00044584274291992
(333) DESCRIBE `ports` 0.0028848648071289
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00077605247497559
(335) DESCRIBE `ports` 0.0027720928192139
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00049400329589844
(337) DESCRIBE `avid_specials` 0.0023989677429199
(338) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81362 and class = 'Cruise') OR (item_id = 1586 AND class = 'Ship') OR (item_id = 26 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.0013351440429688
(339) DESCRIBE `cruiselines` 0.0034289360046387
(340) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00050091743469238
(341) DESCRIBE `orchid_image` 0.0022008419036865
(342) DESCRIBE `cruiselines` 0.0026059150695801
(343) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00042581558227539
(344) DESCRIBE `cruises` 0.0040130615234375
(345) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81363') 0.00057101249694824
(346) DESCRIBE `ships` 0.004784107208252
(347) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1586))) 0.00069618225097656
(348) DESCRIBE `ships` 0.004849910736084
(349) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1586') 0.00038981437683105
(350) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036811828613281
(351) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003809928894043
(352) DESCRIBE `itineraries` 0.0019400119781494
(353) DESCRIBE `ports` 0.0021929740905762
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00049901008605957
(355) DESCRIBE `ports` 0.0020890235900879
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00049591064453125
(357) DESCRIBE `ports` 0.0020980834960938
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00041604042053223
(359) DESCRIBE `sailingdates` 0.0018339157104492
(360) DESCRIBE `ports` 0.0023760795593262
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00048303604125977
(362) DESCRIBE `ports` 0.0019650459289551
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00060915946960449
(364) DESCRIBE `ports` 0.0021920204162598
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 465))) 0.00049400329589844
(366) DESCRIBE `ports` 0.0021688938140869
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '465') 0.00067806243896484
(368) DESCRIBE `ports` 0.0026040077209473
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1104))) 0.00063800811767578
(370) DESCRIBE `ports` 0.0026299953460693
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1104') 0.00060701370239258
(372) DESCRIBE `ports` 0.0031759738922119
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00048589706420898
(374) DESCRIBE `ports` 0.0026659965515137
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.0003960132598877
(376) DESCRIBE `ports` 0.0024998188018799
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00043892860412598
(378) DESCRIBE `ports` 0.0025348663330078
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00049519538879395
(380) DESCRIBE `avid_specials` 0.0021219253540039
(381) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81363 and class = 'Cruise') OR (item_id = 1586 AND class = 'Ship') OR (item_id = 26 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.0018529891967773
(382) DESCRIBE `cruiselines` 0.003849983215332
(383) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.0004889965057373
(384) DESCRIBE `orchid_image` 0.0031499862670898
(385) DESCRIBE `cruiselines` 0.002953052520752
(386) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.0004429817199707
(387) DESCRIBE `cruisetypes` 0.0022859573364258
(388) DESCRIBE `destinations` 0.0029151439666748
(389) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '9')) ORDER BY FIND_IN_SET(id, '12,9') 0.0007321834564209
(390) DESCRIBE `cruiselines` 0.0028209686279297
(391) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00044584274291992
(392) DESCRIBE `ships` 0.0039501190185547
(393) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1586))) 0.00044798851013184
(394) DESCRIBE `cruiselines` 0.0045819282531738
(395) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00063896179199219
(396) DESCRIBE `ships` 0.0053501129150391
(397) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1586))) 0.0006721019744873