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

Total elapsed time: 0.9628164768219

# Query Time
(1) connect 0.0015468597412109
(2) DESCRIBE `cruises` 0.0063600540161133
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (51426, 60853, 75450, 62156, 62161, 67246, 67182, 32836, 65470, 64368)) ORDER BY FIND_IN_SET(id, '51426,60853,75450,62156,62161,67246,67182,32836,65470,64368') 0.0033800601959229
(4) DESCRIBE `cruises` 0.0046110153198242
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '51426') 0.00071406364440918
(6) DESCRIBE `ships` 0.007098913192749
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.0011489391326904
(8) DESCRIBE `ships` 0.0054421424865723
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00079607963562012
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00049114227294922
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00049519538879395
(12) DESCRIBE `itineraries` 0.002892017364502
(13) DESCRIBE `ports` 0.0025908946990967
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00064206123352051
(15) DESCRIBE `ports` 0.0026860237121582
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00062203407287598
(17) DESCRIBE `ports` 0.0028021335601807
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00059700012207031
(19) DESCRIBE `sailingdates` 0.0024828910827637
(20) DESCRIBE `ports` 0.0029909610748291
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00083303451538086
(22) DESCRIBE `ports` 0.003140926361084
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00067806243896484
(24) DESCRIBE `ports` 0.0026929378509521
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00069999694824219
(26) DESCRIBE `ports` 0.0029361248016357
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00050997734069824
(28) DESCRIBE `ports` 0.0021250247955322
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00058388710021973
(30) DESCRIBE `ports` 0.0020818710327148
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00044012069702148
(32) DESCRIBE `ports` 0.0031378269195557
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.00069093704223633
(34) DESCRIBE `ports` 0.0027890205383301
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.00061202049255371
(36) DESCRIBE `ports` 0.0029089450836182
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.003925085067749
(38) DESCRIBE `ports` 0.0029559135437012
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.001446008682251
(40) DESCRIBE `avid_specials` 0.0023519992828369
(41) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 51426 and class = 'Cruise') OR (item_id = 1284 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 43 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.0019397735595703
(42) DESCRIBE `cruiselines` 0.0033810138702393
(43) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00072193145751953
(44) DESCRIBE `orchid_image` 0.0033118724822998
(45) DESCRIBE `cruiselines` 0.0042428970336914
(46) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00055193901062012
(47) DESCRIBE `cruises` 0.0047988891601562
(48) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60853') 0.00091886520385742
(49) DESCRIBE `ships` 0.0059349536895752
(50) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.00081610679626465
(51) DESCRIBE `ships` 0.0058219432830811
(52) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00072813034057617
(53) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00053787231445312
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00051403045654297
(55) DESCRIBE `itineraries` 0.0031750202178955
(56) DESCRIBE `ports` 0.0031371116638184
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00079107284545898
(58) DESCRIBE `ports` 0.0029258728027344
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00071501731872559
(60) DESCRIBE `ports` 0.0029659271240234
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00070095062255859
(62) DESCRIBE `sailingdates` 0.0044419765472412
(63) DESCRIBE `ports` 0.0040850639343262
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.000762939453125
(65) DESCRIBE `ports` 0.0032010078430176
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00094795227050781
(67) DESCRIBE `ports` 0.0028238296508789
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00086021423339844
(69) DESCRIBE `ports` 0.0024571418762207
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00049591064453125
(71) DESCRIBE `ports` 0.0024368762969971
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1037))) 0.00078797340393066
(73) DESCRIBE `ports` 0.0028362274169922
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1037') 0.00052213668823242
(75) DESCRIBE `ports` 0.0022668838500977
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.0006871223449707
(77) DESCRIBE `ports` 0.0030200481414795
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00065493583679199
(79) DESCRIBE `ports` 0.0027079582214355
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00076794624328613
(81) DESCRIBE `ports` 0.0029568672180176
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00064802169799805
(83) DESCRIBE `ports` 0.002471923828125
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00072598457336426
(85) DESCRIBE `ports` 0.0031061172485352
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00078392028808594
(87) DESCRIBE `ports` 0.0030848979949951
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00050806999206543
(89) DESCRIBE `ports` 0.0021810531616211
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00044107437133789
(91) DESCRIBE `avid_specials` 0.0023019313812256
(92) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60853 and class = 'Cruise') OR (item_id = 573 AND class = 'Ship') OR (item_id = 37 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.0023469924926758
(93) DESCRIBE `cruiselines` 0.004133939743042
(94) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00055289268493652
(95) DESCRIBE `orchid_image` 0.0027649402618408
(96) DESCRIBE `cruiselines` 0.0035431385040283
(97) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00060415267944336
(98) DESCRIBE `cruises` 0.005418062210083
(99) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75450') 0.00081896781921387
(100) DESCRIBE `ships` 0.0051169395446777
(101) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.00084495544433594
(102) DESCRIBE `ships` 0.0050699710845947
(103) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00070691108703613
(104) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00048017501831055
(105) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00047683715820312
(106) DESCRIBE `itineraries` 0.0027120113372803
(107) DESCRIBE `ports` 0.0026381015777588
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00069904327392578
(109) DESCRIBE `ports` 0.002547025680542
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00060200691223145
(111) DESCRIBE `ports` 0.0030791759490967
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00064587593078613
(113) DESCRIBE `sailingdates` 0.0027508735656738
(114) DESCRIBE `ports` 0.0033619403839111
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00055885314941406
(116) DESCRIBE `ports` 0.0027101039886475
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00066208839416504
(118) DESCRIBE `ports` 0.0025441646575928
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00049710273742676
(120) DESCRIBE `ports` 0.0026021003723145
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00058603286743164
(122) DESCRIBE `ports` 0.002708911895752
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.0006251335144043
(124) DESCRIBE `ports` 0.0028719902038574
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00072097778320312
(126) DESCRIBE `ports` 0.0027720928192139
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00066804885864258
(128) DESCRIBE `ports` 0.0027430057525635
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00064206123352051
(130) DESCRIBE `ports` 0.0028390884399414
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00084400177001953
(132) DESCRIBE `ports` 0.0028190612792969
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00063109397888184
(134) DESCRIBE `ports` 0.0027909278869629
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0006871223449707
(136) DESCRIBE `ports` 0.0027918815612793
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0007941722869873
(138) DESCRIBE `avid_specials` 0.0026249885559082
(139) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75450 and class = 'Cruise') OR (item_id = 1284 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0023770332336426
(140) DESCRIBE `cruiselines` 0.0041220188140869
(141) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00071406364440918
(142) DESCRIBE `orchid_image` 0.0031790733337402
(143) DESCRIBE `cruiselines` 0.0030288696289062
(144) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00049996376037598
(145) DESCRIBE `cruises` 0.0040748119354248
(146) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62156') 0.00053906440734863
(147) DESCRIBE `ships` 0.0056140422821045
(148) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00083398818969727
(149) DESCRIBE `ships` 0.004647970199585
(150) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00082015991210938
(151) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00053191184997559
(152) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00052404403686523
(153) DESCRIBE `itineraries` 0.0030100345611572
(154) DESCRIBE `ports` 0.0033679008483887
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00090694427490234
(156) DESCRIBE `ports` 0.0032179355621338
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00077915191650391
(158) DESCRIBE `ports` 0.031062841415405
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00063300132751465
(160) DESCRIBE `sailingdates` 0.0025379657745361
(161) DESCRIBE `ports` 0.0030920505523682
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0017170906066895
(163) DESCRIBE `ports` 0.0032479763031006
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00057792663574219
(165) DESCRIBE `ports` 0.0033009052276611
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00072216987609863
(167) DESCRIBE `ports` 0.0030269622802734
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00064516067504883
(169) DESCRIBE `avid_specials` 0.003629207611084
(170) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62156 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0024330615997314
(171) DESCRIBE `cruiselines` 0.0039660930633545
(172) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00078511238098145
(173) DESCRIBE `orchid_image` 0.003026008605957
(174) DESCRIBE `cruiselines` 0.0037238597869873
(175) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00058794021606445
(176) DESCRIBE `cruises` 0.0052120685577393
(177) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62161') 0.00064706802368164
(178) DESCRIBE `ships` 0.0052359104156494
(179) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00073695182800293
(180) DESCRIBE `ships` 0.0045959949493408
(181) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00071382522583008
(182) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00049686431884766
(183) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00057291984558105
(184) DESCRIBE `itineraries` 0.0025250911712646
(185) DESCRIBE `ports` 0.0030300617218018
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00067496299743652
(187) DESCRIBE `ports` 0.0028038024902344
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00066494941711426
(189) DESCRIBE `ports` 0.0027987957000732
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00067496299743652
(191) DESCRIBE `sailingdates` 0.0021011829376221
(192) DESCRIBE `ports` 0.0030341148376465
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00078296661376953
(194) DESCRIBE `ports` 0.0034210681915283
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00079488754272461
(196) DESCRIBE `ports` 0.0028579235076904
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00069093704223633
(198) DESCRIBE `ports` 0.0026950836181641
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00066208839416504
(200) DESCRIBE `ports` 0.0037059783935547
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00084090232849121
(202) DESCRIBE `ports` 0.002830982208252
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0006248950958252
(204) DESCRIBE `avid_specials` 0.0042998790740967
(205) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62161 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0042698383331299
(206) DESCRIBE `cruiselines` 0.0052180290222168
(207) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00081610679626465
(208) DESCRIBE `orchid_image` 0.0030128955841064
(209) DESCRIBE `cruiselines` 0.0046761035919189
(210) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00072002410888672
(211) DESCRIBE `cruises` 0.00543212890625
(212) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67246') 0.00076413154602051
(213) DESCRIBE `ships` 0.0050168037414551
(214) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.0010180473327637
(215) DESCRIBE `ships` 0.0058000087738037
(216) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00072383880615234
(217) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00048398971557617
(218) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00046801567077637
(219) DESCRIBE `itineraries` 0.0026102066040039
(220) DESCRIBE `ports` 0.0027921199798584
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00088286399841309
(222) DESCRIBE `ports` 0.0024211406707764
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00076198577880859
(224) DESCRIBE `ports` 0.0030560493469238
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0006859302520752
(226) DESCRIBE `sailingdates` 0.0024960041046143
(227) DESCRIBE `ports` 0.0035579204559326
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00070905685424805
(229) DESCRIBE `ports` 0.0027430057525635
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00077915191650391
(231) DESCRIBE `ports` 0.0026228427886963
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00063896179199219
(233) DESCRIBE `ports` 0.0029211044311523
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00066518783569336
(235) DESCRIBE `ports` 0.002871036529541
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00064396858215332
(237) DESCRIBE `ports` 0.0027580261230469
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00057506561279297
(239) DESCRIBE `ports` 0.0025289058685303
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00068116188049316
(241) DESCRIBE `ports` 0.0025310516357422
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00058293342590332
(243) DESCRIBE `ports` 0.0025110244750977
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00059700012207031
(245) DESCRIBE `ports` 0.0026359558105469
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00084185600280762
(247) DESCRIBE `avid_specials` 0.003957986831665
(248) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67246 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 43 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.0022339820861816
(249) DESCRIBE `cruiselines` 0.0047309398651123
(250) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00074505805969238
(251) DESCRIBE `orchid_image` 0.0029611587524414
(252) DESCRIBE `cruiselines` 0.0040619373321533
(253) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00065517425537109
(254) DESCRIBE `cruises` 0.0065691471099854
(255) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67182') 0.00067496299743652
(256) DESCRIBE `ships` 0.0056850910186768
(257) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.00079202651977539
(258) DESCRIBE `ships` 0.0073399543762207
(259) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00073814392089844
(260) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00050711631774902
(261) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00053000450134277
(262) DESCRIBE `itineraries` 0.0034761428833008
(263) DESCRIBE `ports` 0.0032789707183838
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00061297416687012
(265) DESCRIBE `ports` 0.0024240016937256
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00062394142150879
(267) DESCRIBE `ports` 0.002532958984375
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0005490779876709
(269) DESCRIBE `sailingdates` 0.002065896987915
(270) DESCRIBE `ports` 0.0026698112487793
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0010190010070801
(272) DESCRIBE `ports` 0.0029809474945068
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00063610076904297
(274) DESCRIBE `ports` 0.0027961730957031
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.0007011890411377
(276) DESCRIBE `ports` 0.0021460056304932
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00068902969360352
(278) DESCRIBE `ports` 0.0025911331176758
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00061607360839844
(280) DESCRIBE `ports` 0.0049209594726562
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00063300132751465
(282) DESCRIBE `avid_specials` 0.0030410289764404
(283) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67182 and class = 'Cruise') OR (item_id = 1284 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0022969245910645
(284) DESCRIBE `cruiselines` 0.0041790008544922
(285) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00075602531433105
(286) DESCRIBE `orchid_image` 0.0032858848571777
(287) DESCRIBE `cruiselines` 0.0041499137878418
(288) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00067591667175293
(289) DESCRIBE `cruises` 0.0054991245269775
(290) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '32836') 0.0011382102966309
(291) DESCRIBE `ships` 0.0072050094604492
(292) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.00098800659179688
(293) DESCRIBE `ships` 0.0087161064147949
(294) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00088405609130859
(295) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00064301490783691
(296) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00081706047058105
(297) DESCRIBE `itineraries` 0.0025150775909424
(298) DESCRIBE `ports` 0.0036940574645996
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00094509124755859
(300) DESCRIBE `ports` 0.0049741268157959
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00079202651977539
(302) DESCRIBE `ports` 0.0028760433197021
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00080585479736328
(304) DESCRIBE `sailingdates` 0.0059370994567871
(305) DESCRIBE `ports` 0.0052659511566162
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00072789192199707
(307) DESCRIBE `ports` 0.0031790733337402
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0006108283996582
(309) DESCRIBE `ports` 0.0023300647735596
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00063109397888184
(311) DESCRIBE `ports` 0.002493143081665
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00074100494384766
(313) DESCRIBE `ports` 0.0023069381713867
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2751))) 0.0006248950958252
(315) DESCRIBE `ports` 0.0022931098937988
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2751') 0.00052690505981445
(317) DESCRIBE `ports` 0.0026600360870361
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 734))) 0.00080394744873047
(319) DESCRIBE `ports` 0.003026008605957
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '734') 0.00075697898864746
(321) DESCRIBE `ports` 0.0028660297393799
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00064802169799805
(323) DESCRIBE `ports` 0.002633810043335
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00081110000610352
(325) DESCRIBE `ports` 0.0024020671844482
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00060200691223145
(327) DESCRIBE `ports` 0.0023341178894043
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00054693222045898
(329) DESCRIBE `avid_specials` 0.0021359920501709
(330) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 32836 and class = 'Cruise') OR (item_id = 573 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0020158290863037
(331) DESCRIBE `cruiselines` 0.0036349296569824
(332) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00070691108703613
(333) DESCRIBE `orchid_image` 0.002720832824707
(334) DESCRIBE `cruiselines` 0.0034689903259277
(335) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00078916549682617
(336) DESCRIBE `cruises` 0.0046508312225342
(337) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65470') 0.00072097778320312
(338) DESCRIBE `ships` 0.0057270526885986
(339) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.0016458034515381
(340) DESCRIBE `ships` 0.0060968399047852
(341) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00078511238098145
(342) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00055217742919922
(343) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00053501129150391
(344) DESCRIBE `itineraries` 0.0029840469360352
(345) DESCRIBE `ports` 0.0031640529632568
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00083684921264648
(347) DESCRIBE `ports` 0.0035099983215332
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0012528896331787
(349) DESCRIBE `ports` 0.0037610530853271
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00076985359191895
(351) DESCRIBE `sailingdates` 0.0027041435241699
(352) DESCRIBE `ports` 0.0029768943786621
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00079798698425293
(354) DESCRIBE `ports` 0.0030319690704346
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00064587593078613
(356) DESCRIBE `ports` 0.0029571056365967
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.00081801414489746
(358) DESCRIBE `ports` 0.0028760433197021
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.00061583518981934
(360) DESCRIBE `ports` 0.0027999877929688
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1319))) 0.00075197219848633
(362) DESCRIBE `ports` 0.0028231143951416
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1319') 0.00071310997009277
(364) DESCRIBE `ports` 0.0026750564575195
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 791))) 0.00059103965759277
(366) DESCRIBE `ports` 0.0027720928192139
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '791') 0.00061702728271484
(368) DESCRIBE `ports` 0.0028030872344971
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4650))) 0.00062108039855957
(370) DESCRIBE `ports` 0.0025949478149414
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4650') 0.00066590309143066
(372) DESCRIBE `ports` 0.0027740001678467
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5306))) 0.00069999694824219
(374) DESCRIBE `ports` 0.0035820007324219
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5306') 0.00094294548034668
(376) DESCRIBE `ports` 0.0028121471405029
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00068497657775879
(378) DESCRIBE `ports` 0.0031051635742188
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00068092346191406
(380) DESCRIBE `avid_specials` 0.0023331642150879
(381) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65470 and class = 'Cruise') OR (item_id = 1284 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 43 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.0020420551300049
(382) DESCRIBE `cruiselines` 0.0035991668701172
(383) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00076389312744141
(384) DESCRIBE `orchid_image` 0.0029120445251465
(385) DESCRIBE `cruiselines` 0.0039288997650146
(386) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00063896179199219
(387) DESCRIBE `cruises` 0.0042760372161865
(388) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64368') 0.00047898292541504
(389) DESCRIBE `ships` 0.0037949085235596
(390) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.00052785873413086
(391) DESCRIBE `ships` 0.0050089359283447
(392) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00058913230895996
(393) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00039315223693848
(394) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00041699409484863
(395) DESCRIBE `itineraries` 0.0020129680633545
(396) DESCRIBE `ports` 0.0026350021362305
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00049996376037598
(398) DESCRIBE `ports` 0.0022101402282715
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00048089027404785
(400) DESCRIBE `ports` 0.0025320053100586
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00079512596130371
(402) DESCRIBE `sailingdates` 0.0024540424346924
(403) DESCRIBE `ports` 0.0028049945831299
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00070786476135254
(405) DESCRIBE `ports` 0.0029580593109131
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00056886672973633
(407) DESCRIBE `ports` 0.0023391246795654
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00045394897460938
(409) DESCRIBE `ports` 0.0022017955780029
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00049519538879395
(411) DESCRIBE `ports` 0.0025181770324707
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00058293342590332
(413) DESCRIBE `ports` 0.0026390552520752
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00084495544433594
(415) DESCRIBE `ports` 0.0025668144226074
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00052309036254883
(417) DESCRIBE `ports` 0.0021440982818604
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00046420097351074
(419) DESCRIBE `ports` 0.0029940605163574
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00077605247497559
(421) DESCRIBE `ports` 0.0029420852661133
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00056910514831543
(423) DESCRIBE `avid_specials` 0.0027079582214355
(424) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64368 and class = 'Cruise') OR (item_id = 573 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 43 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.002310037612915
(425) DESCRIBE `cruiselines` 0.003939151763916
(426) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00074887275695801
(427) DESCRIBE `orchid_image` 0.0030388832092285
(428) DESCRIBE `cruiselines` 0.003939151763916
(429) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.0006558895111084
(430) DESCRIBE `ships` 0.0054948329925537
(431) SELECT `ships`.* FROM `ships` WHERE (id IN ('1402', '573', '1284', '1758')) ORDER BY FIND_IN_SET(id, '1402,573,1284,1758') 0.0012121200561523
(432) DESCRIBE `cruisetypes` 0.0019221305847168
(433) DESCRIBE `destinations` 0.0041911602020264
(434) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('8', '43', '35')) ORDER BY FIND_IN_SET(id, '8,43,35') 0.0023667812347412
(435) DESCRIBE `cruiselines` 0.003849983215332
(436) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00075602531433105
(437) DESCRIBE `cruiselines` 0.0071721076965332
(438) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00077199935913086