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

Total elapsed time: 0.73588824272156

# Query Time
(1) connect 0.00096511840820312
(2) DESCRIBE `cruises` 0.0041220188140869
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (81389, 72058, 73612, 73617, 77673, 69413, 73611, 54733, 75582, 81928)) ORDER BY FIND_IN_SET(id, '81389,72058,73612,73617,77673,69413,73611,54733,75582,81928') 0.0025830268859863
(4) DESCRIBE `cruises` 0.004101037979126
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81389') 0.0007171630859375
(6) DESCRIBE `ships` 0.0051131248474121
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 403))) 0.00071477890014648
(8) DESCRIBE `ships` 0.0049769878387451
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '403') 0.00069999694824219
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00048589706420898
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00040507316589355
(12) DESCRIBE `itineraries` 0.0026850700378418
(13) DESCRIBE `ports` 0.0024349689483643
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00052404403686523
(15) DESCRIBE `ports` 0.0019309520721436
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00040793418884277
(17) DESCRIBE `ports` 0.0018699169158936
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00037717819213867
(19) DESCRIBE `sailingdates` 0.001666784286499
(20) DESCRIBE `ports` 0.0021891593933105
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00049185752868652
(22) DESCRIBE `ports` 0.0018229484558105
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00039100646972656
(24) DESCRIBE `ports` 0.0018420219421387
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00070309638977051
(26) DESCRIBE `ports` 0.0021669864654541
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00039792060852051
(28) DESCRIBE `ports` 0.0018460750579834
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00042510032653809
(30) DESCRIBE `ports` 0.002094030380249
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00051403045654297
(32) DESCRIBE `ports` 0.0020029544830322
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00042009353637695
(34) DESCRIBE `ports` 0.0019822120666504
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00057196617126465
(36) DESCRIBE `ports` 0.0019271373748779
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00040698051452637
(38) DESCRIBE `ports` 0.0017690658569336
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00043010711669922
(40) DESCRIBE `ports` 0.0020709037780762
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00041794776916504
(42) DESCRIBE `ports` 0.0019128322601318
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00037503242492676
(44) DESCRIBE `ports` 0.0017709732055664
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00045108795166016
(46) DESCRIBE `ports` 0.0021798610687256
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00040292739868164
(48) DESCRIBE `ports` 0.0019099712371826
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00040602684020996
(50) DESCRIBE `ports` 0.0019328594207764
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00039315223693848
(52) DESCRIBE `avid_specials` 0.0018198490142822
(53) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81389 and class = 'Cruise') OR (item_id = 403 AND class = 'Ship') OR (item_id = 26 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.0012490749359131
(54) DESCRIBE `cruiselines` 0.0026190280914307
(55) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00055408477783203
(56) DESCRIBE `orchid_image` 0.0029850006103516
(57) DESCRIBE `cruiselines` 0.0026450157165527
(58) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00043106079101562
(59) DESCRIBE `cruises` 0.0044651031494141
(60) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72058') 0.00048089027404785
(61) DESCRIBE `ships` 0.0040440559387207
(62) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 124))) 0.00056314468383789
(63) DESCRIBE `ships` 0.0038599967956543
(64) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '124') 0.00058317184448242
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00044608116149902
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035190582275391
(67) DESCRIBE `itineraries` 0.0019941329956055
(68) DESCRIBE `ports` 0.002190113067627
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00051403045654297
(70) DESCRIBE `ports` 0.0020720958709717
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0007021427154541
(72) DESCRIBE `ports` 0.0028529167175293
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00061488151550293
(74) DESCRIBE `sailingdates` 0.0023889541625977
(75) DESCRIBE `ports` 0.0025398731231689
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00067400932312012
(77) DESCRIBE `ports` 0.0023541450500488
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00047206878662109
(79) DESCRIBE `ports` 0.0020010471343994
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00059413909912109
(81) DESCRIBE `ports` 0.0019629001617432
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00037908554077148
(83) DESCRIBE `ports` 0.00205397605896
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00050711631774902
(85) DESCRIBE `ports` 0.0024230480194092
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00039482116699219
(87) DESCRIBE `ports` 0.0018851757049561
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00054121017456055
(89) DESCRIBE `ports` 0.0020158290863037
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00039291381835938
(91) DESCRIBE `avid_specials` 0.0016069412231445
(92) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72058 and class = 'Cruise') OR (item_id = 124 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 35 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.001533031463623
(93) DESCRIBE `cruiselines` 0.0026328563690186
(94) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00053501129150391
(95) DESCRIBE `orchid_image` 0.0019590854644775
(96) DESCRIBE `cruiselines` 0.0027449131011963
(97) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00039005279541016
(98) DESCRIBE `cruises` 0.0034871101379395
(99) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73612') 0.00047898292541504
(100) DESCRIBE `ships` 0.0037341117858887
(101) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 393))) 0.00058197975158691
(102) DESCRIBE `ships` 0.0035750865936279
(103) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '393') 0.00053310394287109
(104) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00044584274291992
(105) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034594535827637
(106) DESCRIBE `itineraries` 0.0017421245574951
(107) DESCRIBE `ports` 0.0019638538360596
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00045490264892578
(109) DESCRIBE `ports` 0.0018219947814941
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00049805641174316
(111) DESCRIBE `ports` 0.0025539398193359
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00054192543029785
(113) DESCRIBE `sailingdates` 0.0022749900817871
(114) DESCRIBE `ports` 0.0018730163574219
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00042915344238281
(116) DESCRIBE `ports` 0.0017821788787842
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00041508674621582
(118) DESCRIBE `ports` 0.0017518997192383
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00042891502380371
(120) DESCRIBE `ports` 0.0018370151519775
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00037813186645508
(122) DESCRIBE `ports` 0.0018758773803711
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.00040483474731445
(124) DESCRIBE `ports` 0.0020499229431152
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.00040197372436523
(126) DESCRIBE `ports` 0.001784086227417
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00039386749267578
(128) DESCRIBE `ports` 0.0018970966339111
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00040292739868164
(130) DESCRIBE `avid_specials` 0.0016939640045166
(131) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73612 and class = 'Cruise') OR (item_id = 393 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.0014410018920898
(132) DESCRIBE `cruiselines` 0.0026757717132568
(133) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.0004889965057373
(134) DESCRIBE `orchid_image` 0.0028738975524902
(135) DESCRIBE `cruiselines` 0.0038077831268311
(136) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00051999092102051
(137) DESCRIBE `cruises` 0.0046498775482178
(138) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73617') 0.0004270076751709
(139) DESCRIBE `ships` 0.0035810470581055
(140) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 330))) 0.00046086311340332
(141) DESCRIBE `ships` 0.0037448406219482
(142) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '330') 0.00039100646972656
(143) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00047802925109863
(144) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003509521484375
(145) DESCRIBE `itineraries` 0.0019619464874268
(146) DESCRIBE `ports` 0.0020878314971924
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0005030632019043
(148) DESCRIBE `ports` 0.0019230842590332
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00045299530029297
(150) DESCRIBE `ports` 0.002579927444458
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00041913986206055
(152) DESCRIBE `sailingdates` 0.0020298957824707
(153) DESCRIBE `ports` 0.0020990371704102
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00047993659973145
(155) DESCRIBE `ports` 0.0017580986022949
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00043821334838867
(157) DESCRIBE `ports` 0.0021650791168213
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00060200691223145
(159) DESCRIBE `ports` 0.0024089813232422
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00048089027404785
(161) DESCRIBE `ports` 0.0022120475769043
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.00045514106750488
(163) DESCRIBE `ports` 0.0024011135101318
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.00046586990356445
(165) DESCRIBE `ports` 0.0018680095672607
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0004429817199707
(167) DESCRIBE `ports` 0.0019111633300781
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00043511390686035
(169) DESCRIBE `avid_specials` 0.0018539428710938
(170) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73617 and class = 'Cruise') OR (item_id = 330 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.0017919540405273
(171) DESCRIBE `cruiselines` 0.0025811195373535
(172) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00056099891662598
(173) DESCRIBE `orchid_image` 0.0019898414611816
(174) DESCRIBE `cruiselines` 0.0027389526367188
(175) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00041103363037109
(176) DESCRIBE `cruises` 0.0040531158447266
(177) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77673') 0.00047111511230469
(178) DESCRIBE `ships` 0.0037949085235596
(179) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1738))) 0.00057291984558105
(180) DESCRIBE `ships` 0.0042679309844971
(181) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1738') 0.00054717063903809
(182) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035786628723145
(183) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035500526428223
(184) DESCRIBE `itineraries` 0.0018868446350098
(185) DESCRIBE `ports` 0.0018677711486816
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4184))) 0.00047492980957031
(187) DESCRIBE `ports` 0.0017979145050049
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4184))) 0.00058698654174805
(189) DESCRIBE `ports` 0.0027749538421631
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4184') 0.00092601776123047
(191) DESCRIBE `sailingdates` 0.0025839805603027
(192) DESCRIBE `ports` 0.0030059814453125
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4184))) 0.00071501731872559
(194) DESCRIBE `ports` 0.0020339488983154
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4184') 0.00039005279541016
(196) DESCRIBE `ports` 0.0018160343170166
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 540))) 0.00065898895263672
(198) DESCRIBE `ports` 0.0029850006103516
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '540') 0.00062704086303711
(200) DESCRIBE `ports` 0.0031630992889404
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.00077104568481445
(202) DESCRIBE `ports` 0.0028820037841797
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.00058412551879883
(204) DESCRIBE `ports` 0.0029020309448242
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4184))) 0.00071501731872559
(206) DESCRIBE `ports` 0.0029590129852295
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4184') 0.00067305564880371
(208) DESCRIBE `avid_specials` 0.0020699501037598
(209) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77673 and class = 'Cruise') OR (item_id = 1738 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 35 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.0012872219085693
(210) DESCRIBE `cruiselines` 0.0027871131896973
(211) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00060510635375977
(212) DESCRIBE `orchid_image` 0.0026650428771973
(213) DESCRIBE `cruiselines` 0.0027329921722412
(214) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.0003969669342041
(215) DESCRIBE `cruises` 0.0041420459747314
(216) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69413') 0.00042891502380371
(217) DESCRIBE `ships` 0.0041530132293701
(218) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 113))) 0.00058484077453613
(219) DESCRIBE `ships` 0.004054069519043
(220) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '113') 0.00051593780517578
(221) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037693977355957
(222) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00039792060852051
(223) DESCRIBE `itineraries` 0.002528190612793
(224) DESCRIBE `ports` 0.0019600391387939
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00049281120300293
(226) DESCRIBE `ports` 0.0033538341522217
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00048017501831055
(228) DESCRIBE `ports` 0.0021228790283203
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00044703483581543
(230) DESCRIBE `sailingdates` 0.0018179416656494
(231) DESCRIBE `ports` 0.0024900436401367
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00049901008605957
(233) DESCRIBE `ports` 0.0023610591888428
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00044417381286621
(235) DESCRIBE `ports` 0.0021319389343262
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2298))) 0.00048589706420898
(237) DESCRIBE `ports` 0.0020060539245605
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2298') 0.00041699409484863
(239) DESCRIBE `ports` 0.0020790100097656
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00072312355041504
(241) DESCRIBE `ports` 0.0020649433135986
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00041508674621582
(243) DESCRIBE `ports` 0.0020608901977539
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00049209594726562
(245) DESCRIBE `ports` 0.0018291473388672
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00039887428283691
(247) DESCRIBE `avid_specials` 0.0023970603942871
(248) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69413 and class = 'Cruise') OR (item_id = 113 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.0014901161193848
(249) DESCRIBE `cruiselines` 0.0032958984375
(250) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00052595138549805
(251) DESCRIBE `orchid_image` 0.00223708152771
(252) DESCRIBE `cruiselines` 0.0025928020477295
(253) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00046992301940918
(254) DESCRIBE `cruises` 0.004371166229248
(255) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73611') 0.00049495697021484
(256) DESCRIBE `ships` 0.0037078857421875
(257) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 116))) 0.00055909156799316
(258) DESCRIBE `ships` 0.0041930675506592
(259) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '116') 0.00064587593078613
(260) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00058197975158691
(261) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00054097175598145
(262) DESCRIBE `itineraries` 0.0028090476989746
(263) DESCRIBE `ports` 0.0028138160705566
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00066709518432617
(265) DESCRIBE `ports` 0.0026888847351074
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00051093101501465
(267) DESCRIBE `ports` 0.002032995223999
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00061297416687012
(269) DESCRIBE `sailingdates` 0.0026021003723145
(270) DESCRIBE `ports` 0.0028369426727295
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00049901008605957
(272) DESCRIBE `ports` 0.0019290447235107
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00042295455932617
(274) DESCRIBE `ports` 0.0019140243530273
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00043201446533203
(276) DESCRIBE `ports` 0.0022530555725098
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00046992301940918
(278) DESCRIBE `ports` 0.0018630027770996
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00046801567077637
(280) DESCRIBE `ports` 0.0020928382873535
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.0004570484161377
(282) DESCRIBE `ports` 0.0021231174468994
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00045680999755859
(284) DESCRIBE `ports` 0.0025341510772705
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0004420280456543
(286) DESCRIBE `avid_specials` 0.0017290115356445
(287) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73611 and class = 'Cruise') OR (item_id = 116 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.0012741088867188
(288) DESCRIBE `cruiselines` 0.0028481483459473
(289) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00061702728271484
(290) DESCRIBE `orchid_image` 0.0031931400299072
(291) DESCRIBE `cruiselines` 0.0032100677490234
(292) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00051689147949219
(293) DESCRIBE `cruises` 0.0043148994445801
(294) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '54733') 0.00048017501831055
(295) DESCRIBE `ships` 0.004080057144165
(296) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1236))) 0.00056886672973633
(297) DESCRIBE `ships` 0.0052809715270996
(298) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1236') 0.00056099891662598
(299) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00041604042053223
(300) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00041604042053223
(301) DESCRIBE `itineraries` 0.0019371509552002
(302) DESCRIBE `ports` 0.0019428730010986
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.00047898292541504
(304) DESCRIBE `ports` 0.0020029544830322
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.00041699409484863
(306) DESCRIBE `ports` 0.0018370151519775
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2521') 0.00042200088500977
(308) DESCRIBE `sailingdates` 0.0016288757324219
(309) DESCRIBE `ports` 0.0018138885498047
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.00070595741271973
(311) DESCRIBE `ports` 0.0018908977508545
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2521') 0.00042104721069336
(313) DESCRIBE `ports` 0.0022518634796143
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00070691108703613
(315) DESCRIBE `ports` 0.0030331611633301
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00061511993408203
(317) DESCRIBE `ports` 0.003101110458374
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 126))) 0.00071001052856445
(319) DESCRIBE `ports` 0.0028231143951416
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '126') 0.00063896179199219
(321) DESCRIBE `ports` 0.0026991367340088
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00063586235046387
(323) DESCRIBE `ports` 0.0027279853820801
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00065779685974121
(325) DESCRIBE `ports` 0.0029118061065674
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 333))) 0.00074982643127441
(327) DESCRIBE `ports` 0.0028929710388184
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '333') 0.00060391426086426
(329) DESCRIBE `ports` 0.0028460025787354
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00067400932312012
(331) DESCRIBE `ports` 0.0027410984039307
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00059986114501953
(333) DESCRIBE `ports` 0.0027570724487305
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.00070500373840332
(335) DESCRIBE `ports` 0.0027370452880859
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2521') 0.0006248950958252
(337) DESCRIBE `avid_specials` 0.002561092376709
(338) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 54733 and class = 'Cruise') OR (item_id = 1236 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 11 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.0022788047790527
(339) DESCRIBE `cruiselines` 0.0038459300994873
(340) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00062417984008789
(341) DESCRIBE `orchid_image` 0.0030820369720459
(342) DESCRIBE `cruiselines` 0.0037989616394043
(343) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00057291984558105
(344) DESCRIBE `cruises` 0.0050430297851562
(345) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75582') 0.00058412551879883
(346) DESCRIBE `ships` 0.005418062210083
(347) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 262))) 0.00097107887268066
(348) DESCRIBE `ships` 0.0057380199432373
(349) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '262') 0.00077414512634277
(350) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00048398971557617
(351) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00049400329589844
(352) DESCRIBE `itineraries` 0.0027940273284912
(353) DESCRIBE `ports` 0.0030720233917236
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00066113471984863
(355) DESCRIBE `ports` 0.0027620792388916
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00068211555480957
(357) DESCRIBE `ports` 0.0027849674224854
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00062298774719238
(359) DESCRIBE `sailingdates` 0.0031650066375732
(360) DESCRIBE `ports` 0.0024280548095703
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00052785873413086
(362) DESCRIBE `ports` 0.002540111541748
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00058317184448242
(364) DESCRIBE `ports` 0.0028200149536133
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 628))) 0.00068783760070801
(366) DESCRIBE `ports` 0.0023739337921143
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '628') 0.00050210952758789
(368) DESCRIBE `ports` 0.0020270347595215
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1170))) 0.00045108795166016
(370) DESCRIBE `ports` 0.002345085144043
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1170') 0.00056290626525879
(372) DESCRIBE `ports` 0.0028431415557861
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 685))) 0.00065112113952637
(374) DESCRIBE `ports` 0.002918004989624
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '685') 0.00067687034606934
(376) DESCRIBE `ports` 0.0028839111328125
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 599))) 0.0006718635559082
(378) DESCRIBE `ports` 0.0027928352355957
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '599') 0.00062179565429688
(380) DESCRIBE `ports` 0.0027279853820801
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 566))) 0.00073504447937012
(382) DESCRIBE `ports` 0.0028440952301025
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '566') 0.00041484832763672
(384) DESCRIBE `ports` 0.0025570392608643
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00061392784118652
(386) DESCRIBE `ports` 0.0020999908447266
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00052714347839355
(388) DESCRIBE `avid_specials` 0.0024030208587646
(389) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75582 and class = 'Cruise') OR (item_id = 262 AND class = 'Ship') OR (item_id = 26 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.0023880004882812
(390) DESCRIBE `cruiselines` 0.0040199756622314
(391) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00070595741271973
(392) DESCRIBE `orchid_image` 0.0029640197753906
(393) DESCRIBE `cruiselines` 0.0029218196868896
(394) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00046610832214355
(395) DESCRIBE `cruises` 0.0038671493530273
(396) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81928') 0.00058817863464355
(397) DESCRIBE `ships` 0.0044350624084473
(398) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1571))) 0.00072503089904785
(399) DESCRIBE `ships` 0.004572868347168
(400) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1571') 0.00048184394836426
(401) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00039005279541016
(402) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00040698051452637
(403) DESCRIBE `itineraries` 0.0018918514251709
(404) DESCRIBE `ports` 0.0029988288879395
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0006709098815918
(406) DESCRIBE `ports` 0.001945972442627
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0004889965057373
(408) DESCRIBE `ports` 0.0018289089202881
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0004270076751709
(410) DESCRIBE `sailingdates` 0.0039000511169434
(411) DESCRIBE `ports` 0.0019421577453613
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00062990188598633
(413) DESCRIBE `ports` 0.0017948150634766
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00041103363037109
(415) DESCRIBE `ports` 0.0018110275268555
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.00049090385437012
(417) DESCRIBE `ports` 0.0019450187683105
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.0004580020904541
(419) DESCRIBE `ports` 0.0019540786743164
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00049495697021484
(421) DESCRIBE `ports` 0.0019528865814209
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00053000450134277
(423) DESCRIBE `ports` 0.0019931793212891
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 410))) 0.00049090385437012
(425) DESCRIBE `ports` 0.0018069744110107
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '410') 0.00040411949157715
(427) DESCRIBE `ports` 0.0021791458129883
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 347))) 0.00061988830566406
(429) DESCRIBE `ports` 0.0021288394927979
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '347') 0.00043797492980957
(431) DESCRIBE `ports` 0.0019428730010986
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00054383277893066
(433) DESCRIBE `ports` 0.0020060539245605
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00050878524780273
(435) DESCRIBE `avid_specials` 0.0018730163574219
(436) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81928 and class = 'Cruise') OR (item_id = 1571 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.0012068748474121
(437) DESCRIBE `cruiselines` 0.0031390190124512
(438) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00049495697021484
(439) DESCRIBE `orchid_image` 0.002190113067627
(440) DESCRIBE `cruiselines` 0.0026619434356689
(441) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00041007995605469
(442) DESCRIBE `ships` 0.0040998458862305
(443) SELECT `ships`.* FROM `ships` WHERE (id IN ('330', '393', '1141', '113', '285', '116', '286', '1738', '124', '526', '1323', '748', '1571', '590', '1586', '119', '791', '658', '114', '403', '1330', '1236', '262', '389', '287', '123')) ORDER BY FIND_IN_SET(id, '330,393,1141,113,285,116,286,1738,124,526,1323,748,1571,590,1586,119,791,658,114,403,1330,1236,262,389,287,123') 0.0046329498291016
(444) DESCRIBE `cruisetypes` 0.0017590522766113
(445) DESCRIBE `destinations` 0.0027601718902588
(446) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '9', '35', '43', '22', '2', '11', '8', '45', '10', '26', '38', '28', '48', '29', '49', '21', '25', '34')) ORDER BY FIND_IN_SET(id, '12,9,35,43,22,2,11,8,45,10,26,38,28,48,29,49,21,25,34') 0.0019340515136719
(447) DESCRIBE `cruiselines` 0.0030951499938965
(448) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00042915344238281
(449) DESCRIBE `cruiselines` 0.002885103225708
(450) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00046801567077637