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

 
 

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

Total elapsed time: 0.613685131073

# Query Time
(1) connect 0.0013689994812012
(2) DESCRIBE `cruises` 0.0061638355255127
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (82171, 81962, 82126, 82063)) ORDER BY FIND_IN_SET(id, '82171,81962,82126,82063') 0.0028150081634521
(4) DESCRIBE `specials` 0.0070750713348389
(5) DESCRIBE `specials` 0.0076689720153809
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1612734') 0.0017499923706055
(7) DESCRIBE `ships` 0.0060780048370361
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00085687637329102
(9) DESCRIBE `ships` 0.0058548450469971
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00090289115905762
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00058603286743164
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00042819976806641
(13) DESCRIBE `itineraries` 0.0029311180114746
(14) DESCRIBE `ports` 0.0034680366516113
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00095295906066895
(16) DESCRIBE `ports` 0.0030281543731689
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00070714950561523
(18) DESCRIBE `ports` 0.0029220581054688
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00074410438537598
(20) DESCRIBE `specialsailingdates` 0.002392053604126
(21) DESCRIBE `sailingdates` 0.0039811134338379
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 516367))) 0.00081992149353027
(23) DESCRIBE `ports` 0.0028300285339355
(24) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00070691108703613
(25) DESCRIBE `ports` 0.0025339126586914
(26) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00060606002807617
(27) DESCRIBE `ports` 0.0024979114532471
(28) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00065898895263672
(29) DESCRIBE `ports` 0.0026659965515137
(30) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00064587593078613
(31) DESCRIBE `ports` 0.0027120113372803
(32) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.00063085556030273
(33) DESCRIBE `ports` 0.0036261081695557
(34) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.00073504447937012
(35) DESCRIBE `ports` 0.002985954284668
(36) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00076413154602051
(37) DESCRIBE `ports` 0.0027561187744141
(38) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00062108039855957
(39) DESCRIBE `ports` 0.0029449462890625
(40) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00085306167602539
(41) DESCRIBE `ports` 0.002856969833374
(42) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00075292587280273
(43) DESCRIBE `ports` 0.0029549598693848
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00085306167602539
(45) DESCRIBE `ports` 0.0031039714813232
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00069403648376465
(47) DESCRIBE `ports` 0.0026321411132812
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00072789192199707
(49) DESCRIBE `ports` 0.0028998851776123
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00066995620727539
(51) DESCRIBE `ports` 0.0030298233032227
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00065493583679199
(53) DESCRIBE `ports` 0.0023140907287598
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00051784515380859
(55) DESCRIBE `ports` 0.0026438236236572
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00085306167602539
(57) DESCRIBE `ports` 0.0030829906463623
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00067400932312012
(59) DESCRIBE `cruises` 0.0052688121795654
(60) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82171))) 0.0011048316955566
(61) DESCRIBE `avid_specials` 0.0025839805603027
(62) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1612734 and class = 'Special') OR (item_id = 82171 and class = 'Cruise') OR (item_id = 1013 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0022270679473877
(63) DESCRIBE `cruiselines` 0.0038008689880371
(64) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00075316429138184
(65) DESCRIBE `orchid_image` 0.0031747817993164
(66) DESCRIBE `cruiselines` 0.0039300918579102
(67) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.0006558895111084
(68) DESCRIBE `specials` 0.0086369514465332
(69) SELECT `specials`.* FROM `specials` WHERE (id = '1612754') AND (specials.orchid_available = 1) LIMIT 1 0.0010428428649902
(70) DESCRIBE `specials` 0.0079801082611084
(71) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1612754') 0.00074291229248047
(72) DESCRIBE `ships` 0.0055720806121826
(73) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1791))) 0.0011770725250244
(74) DESCRIBE `ships` 0.0054309368133545
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1791') 0.0010049343109131
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0006260871887207
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00044488906860352
(78) DESCRIBE `itineraries` 0.0026719570159912
(79) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '81962') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012898445129395
(80) DESCRIBE `ports` 0.0030660629272461
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00084400177001953
(82) DESCRIBE `ports` 0.002993106842041
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00069499015808105
(84) DESCRIBE `ports` 0.0025041103363037
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00053000450134277
(86) DESCRIBE `specialsailingdates` 0.0022759437561035
(87) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1612754') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.0013251304626465
(88) DESCRIBE `sailingdates` 0.0027990341186523
(89) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 514816))) 0.00067615509033203
(90) DESCRIBE `sailingdates` 0.0028350353240967
(91) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 514818))) 0.000762939453125
(92) DESCRIBE `ports` 0.0029711723327637
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00070595741271973
(94) DESCRIBE `ports` 0.0028789043426514
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00063896179199219
(96) DESCRIBE `ports` 0.0030560493469238
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.0007319450378418
(98) DESCRIBE `ports` 0.0029499530792236
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.00063300132751465
(100) DESCRIBE `ports` 0.0028691291809082
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.0008091926574707
(102) DESCRIBE `ports` 0.0029070377349854
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00064897537231445
(104) DESCRIBE `ports` 0.0028910636901855
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00066399574279785
(106) DESCRIBE `ports` 0.0026969909667969
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.0008399486541748
(108) DESCRIBE `ports` 0.0030970573425293
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00065803527832031
(110) DESCRIBE `ports` 0.0031139850616455
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.0006098747253418
(112) DESCRIBE `ports` 0.003303050994873
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00057792663574219
(114) DESCRIBE `ports` 0.0025269985198975
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00067305564880371
(116) DESCRIBE `ports` 0.003119945526123
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00070500373840332
(118) DESCRIBE `ports` 0.0028040409088135
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00057101249694824
(120) DESCRIBE `ports` 0.0031368732452393
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00084495544433594
(122) DESCRIBE `ports` 0.010612964630127
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00059294700622559
(124) DESCRIBE `cruises` 0.0055320262908936
(125) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 81962))) 0.00099515914916992
(126) DESCRIBE `avid_specials` 0.0032479763031006
(127) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1612754 and class = 'Special') OR (item_id = 81962 and class = 'Cruise') OR (item_id = 1791 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0026040077209473
(128) DESCRIBE `cruiselines` 0.0052099227905273
(129) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00099086761474609
(130) DESCRIBE `orchid_image` 0.0032660961151123
(131) DESCRIBE `cruiselines` 0.0041778087615967
(132) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00074601173400879
(133) DESCRIBE `specials` 0.0071051120758057
(134) SELECT `specials`.* FROM `specials` WHERE (id = '1612726') AND (specials.orchid_available = 1) LIMIT 1 0.00088191032409668
(135) DESCRIBE `specials` 0.0074779987335205
(136) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1612726') 0.00069808959960938
(137) DESCRIBE `ships` 0.0047011375427246
(138) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1013))) 0.00079607963562012
(139) DESCRIBE `ships` 0.0052001476287842
(140) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1013') 0.00076198577880859
(141) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00064206123352051
(142) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00060606002807617
(143) DESCRIBE `itineraries` 0.0026378631591797
(144) DESCRIBE `ports` 0.0034890174865723
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00078582763671875
(146) DESCRIBE `ports` 0.0031399726867676
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00068211555480957
(148) DESCRIBE `ports` 0.0033199787139893
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00065803527832031
(150) DESCRIBE `specialsailingdates` 0.0022580623626709
(151) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1612726') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.0013539791107178
(152) DESCRIBE `sailingdates` 0.0029129981994629
(153) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515724))) 0.0006868839263916
(154) DESCRIBE `ports` 0.0031108856201172
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00085902214050293
(156) DESCRIBE `ports` 0.003032922744751
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00064992904663086
(158) DESCRIBE `ports` 0.0042881965637207
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00081491470336914
(160) DESCRIBE `ports` 0.0023758411407471
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00064706802368164
(162) DESCRIBE `ports` 0.0029358863830566
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4585))) 0.00068998336791992
(164) DESCRIBE `ports` 0.0027170181274414
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4585') 0.0006258487701416
(166) DESCRIBE `ports` 0.0030350685119629
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00071096420288086
(168) DESCRIBE `ports` 0.0026860237121582
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00062108039855957
(170) DESCRIBE `ports` 0.0030341148376465
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00091791152954102
(172) DESCRIBE `ports` 0.0055100917816162
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.0015521049499512
(174) DESCRIBE `ports` 0.0032751560211182
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00069904327392578
(176) DESCRIBE `ports` 0.0025351047515869
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00074505805969238
(178) DESCRIBE `ports` 0.0030319690704346
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00073599815368652
(180) DESCRIBE `ports` 0.003115177154541
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00076198577880859
(182) DESCRIBE `ports` 0.0036928653717041
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.0014638900756836
(184) DESCRIBE `ports` 0.0033268928527832
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00061702728271484
(186) DESCRIBE `ports` 0.002788782119751
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00070500373840332
(188) DESCRIBE `ports` 0.0028948783874512
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.00065803527832031
(190) DESCRIBE `cruises` 0.004547119140625
(191) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82126))) 0.00092101097106934
(192) DESCRIBE `avid_specials` 0.0028989315032959
(193) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1612726 and class = 'Special') OR (item_id = 82126 and class = 'Cruise') OR (item_id = 1013 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.002626895904541
(194) DESCRIBE `cruiselines` 0.00388503074646
(195) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00054407119750977
(196) DESCRIBE `orchid_image` 0.0024831295013428
(197) DESCRIBE `cruiselines` 0.0036609172821045
(198) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00084280967712402
(199) DESCRIBE `specials` 0.0071091651916504
(200) SELECT `specials`.* FROM `specials` WHERE (id = '1612744') AND (specials.orchid_available = 1) LIMIT 1 0.001237154006958
(201) DESCRIBE `specials` 0.0086150169372559
(202) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1612744') 0.00079703330993652
(203) DESCRIBE `ships` 0.00537109375
(204) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1526))) 0.00090217590332031
(205) DESCRIBE `ships` 0.0046439170837402
(206) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1526') 0.00061917304992676
(207) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0004420280456543
(208) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00050997734069824
(209) DESCRIBE `itineraries` 0.0029351711273193
(210) DESCRIBE `ports` 0.002824068069458
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00069022178649902
(212) DESCRIBE `ports` 0.0026750564575195
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00064587593078613
(214) DESCRIBE `ports` 0.0027868747711182
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00060486793518066
(216) DESCRIBE `specialsailingdates` 0.0022499561309814
(217) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1612744') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.0012919902801514
(218) DESCRIBE `sailingdates` 0.0026819705963135
(219) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515291))) 0.00086688995361328
(220) DESCRIBE `sailingdates` 0.0025119781494141
(221) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 515331))) 0.0006721019744873
(222) DESCRIBE `ports` 0.0024228096008301
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00046586990356445
(224) DESCRIBE `ports` 0.0025210380554199
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00060486793518066
(226) DESCRIBE `ports` 0.0027909278869629
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 146))) 0.00079917907714844
(228) DESCRIBE `ports` 0.0030460357666016
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '146') 0.00068092346191406
(230) DESCRIBE `ports` 0.0027649402618408
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6129))) 0.00055289268493652
(232) DESCRIBE `ports` 0.0028929710388184
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6129') 0.00057482719421387
(234) DESCRIBE `ports` 0.0027139186859131
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 155))) 0.00088715553283691
(236) DESCRIBE `ports` 0.002701997756958
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '155') 0.00061392784118652
(238) DESCRIBE `ports` 0.003277063369751
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 154))) 0.00059294700622559
(240) DESCRIBE `ports` 0.0030941963195801
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '154') 0.00074601173400879
(242) DESCRIBE `ports` 0.0027098655700684
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 156))) 0.00073909759521484
(244) DESCRIBE `ports` 0.0035459995269775
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '156') 0.00073790550231934
(246) DESCRIBE `ports` 0.0032141208648682
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 157))) 0.00072717666625977
(248) DESCRIBE `ports` 0.0036301612854004
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '157') 0.00081515312194824
(250) DESCRIBE `ports` 0.0026760101318359
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1366))) 0.00069999694824219
(252) DESCRIBE `ports` 0.0025510787963867
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1366') 0.00058197975158691
(254) DESCRIBE `ports` 0.002593994140625
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 145))) 0.00067400932312012
(256) DESCRIBE `ports` 0.002918004989624
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '145') 0.0006260871887207
(258) DESCRIBE `cruises` 0.00559401512146
(259) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 82063))) 0.001060962677002
(260) DESCRIBE `avid_specials` 0.0026249885559082
(261) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1612744 and class = 'Special') OR (item_id = 82063 and class = 'Cruise') OR (item_id = 1526 AND class = 'Ship') OR (item_id = 212 AND class = 'CruiseLine') OR (item_id = 39 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.0025250911712646
(262) DESCRIBE `cruiselines` 0.0037221908569336
(263) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00075602531433105
(264) DESCRIBE `orchid_image` 0.0031788349151611
(265) DESCRIBE `cruiselines` 0.0040237903594971
(266) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '212') 0.00074005126953125
(267) DESCRIBE `ships` 0.0056118965148926
(268) SELECT `ships`.* FROM `ships` WHERE (id IN ('1013', '1791', '1526')) ORDER BY FIND_IN_SET(id, '1013,1791,1526') 0.0019311904907227
(269) DESCRIBE `cruisetypes` 0.0026259422302246
(270) DESCRIBE `destinations` 0.0040221214294434
(271) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('39')) ORDER BY FIND_IN_SET(id, '39') 0.00098586082458496
(272) DESCRIBE `cruiselines` 0.0048279762268066
(273) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00074410438537598
(274) DESCRIBE `cruiselines` 0.0039238929748535
(275) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 212))) 0.00062704086303711