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

Total elapsed time: 0.82424736022949

# Query Time
(1) connect 0.0012061595916748
(2) DESCRIBE `cruises` 0.0059969425201416
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (70935, 41778, 41776, 70933, 50857, 55703, 70947, 70948, 65891, 50866)) ORDER BY FIND_IN_SET(id, '70935,41778,41776,70933,50857,55703,70947,70948,65891,50866') 0.0032880306243896
(4) DESCRIBE `cruises` 0.0051589012145996
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70935') 0.00082898139953613
(6) DESCRIBE `ships` 0.0053558349609375
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00078582763671875
(8) DESCRIBE `ships` 0.0055818557739258
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00063896179199219
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00049710273742676
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00053811073303223
(12) DESCRIBE `itineraries` 0.0027370452880859
(13) DESCRIBE `ports` 0.0028250217437744
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00061392784118652
(15) DESCRIBE `ports` 0.0027480125427246
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00057888031005859
(17) DESCRIBE `ports` 0.0027461051940918
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00053596496582031
(19) DESCRIBE `sailingdates` 0.0023901462554932
(20) DESCRIBE `ports` 0.0027639865875244
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00064802169799805
(22) DESCRIBE `ports` 0.0030288696289062
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00046181678771973
(24) DESCRIBE `ports` 0.0019700527191162
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00041508674621582
(26) DESCRIBE `ports` 0.0018150806427002
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00038290023803711
(28) DESCRIBE `ports` 0.0019800662994385
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00044417381286621
(30) DESCRIBE `ports` 0.0018429756164551
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.0003819465637207
(32) DESCRIBE `ports` 0.001986026763916
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00045895576477051
(34) DESCRIBE `ports` 0.0021247863769531
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00039386749267578
(36) DESCRIBE `ports` 0.0020718574523926
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00041007995605469
(38) DESCRIBE `ports` 0.0018949508666992
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00038909912109375
(40) DESCRIBE `ports` 0.0019769668579102
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00040507316589355
(42) DESCRIBE `ports` 0.0022680759429932
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00041103363037109
(44) DESCRIBE `ports` 0.0019378662109375
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040602684020996
(46) DESCRIBE `ports` 0.0020720958709717
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00057315826416016
(48) DESCRIBE `avid_specials` 0.0018401145935059
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70935 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0012998580932617
(50) DESCRIBE `cruiselines` 0.0027439594268799
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00041794776916504
(52) DESCRIBE `orchid_image` 0.0023088455200195
(53) DESCRIBE `cruiselines` 0.0037581920623779
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00051999092102051
(55) DESCRIBE `cruises` 0.0047130584716797
(56) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41778') 0.00057315826416016
(57) DESCRIBE `ships` 0.0048789978027344
(58) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00062704086303711
(59) DESCRIBE `ships` 0.0049049854278564
(60) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00070714950561523
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00051188468933105
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00056910514831543
(63) DESCRIBE `itineraries` 0.0028150081634521
(64) DESCRIBE `ports` 0.0031948089599609
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00071310997009277
(66) DESCRIBE `ports` 0.0029270648956299
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00053906440734863
(68) DESCRIBE `ports` 0.002504825592041
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00056910514831543
(70) DESCRIBE `sailingdates` 0.002575159072876
(71) DESCRIBE `ports` 0.0028908252716064
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00063014030456543
(73) DESCRIBE `ports` 0.0027551651000977
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0006110668182373
(75) DESCRIBE `ports` 0.0028538703918457
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00060892105102539
(77) DESCRIBE `ports` 0.0028059482574463
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00068378448486328
(79) DESCRIBE `avid_specials` 0.0021319389343262
(80) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41778 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0017690658569336
(81) DESCRIBE `cruiselines` 0.0036149024963379
(82) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00083398818969727
(83) DESCRIBE `orchid_image` 0.0031929016113281
(84) DESCRIBE `cruiselines` 0.0039169788360596
(85) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00058984756469727
(86) DESCRIBE `cruises` 0.004892110824585
(87) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41776') 0.00056695938110352
(88) DESCRIBE `ships` 0.0040459632873535
(89) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00058507919311523
(90) DESCRIBE `ships` 0.0049018859863281
(91) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00062417984008789
(92) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00054502487182617
(93) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00045609474182129
(94) DESCRIBE `itineraries` 0.0028641223907471
(95) DESCRIBE `ports` 0.0030250549316406
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00062203407287598
(97) DESCRIBE `ports` 0.0028400421142578
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00067591667175293
(99) DESCRIBE `ports` 0.0026950836181641
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00059914588928223
(101) DESCRIBE `sailingdates` 0.0024299621582031
(102) DESCRIBE `ports` 0.0025889873504639
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00069212913513184
(104) DESCRIBE `ports` 0.0020458698272705
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043821334838867
(106) DESCRIBE `ports` 0.0018520355224609
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00053191184997559
(108) DESCRIBE `ports` 0.0018470287322998
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00058507919311523
(110) DESCRIBE `ports` 0.0018401145935059
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00052499771118164
(112) DESCRIBE `ports` 0.0026330947875977
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00055193901062012
(114) DESCRIBE `ports` 0.0025930404663086
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00064706802368164
(116) DESCRIBE `ports` 0.0029749870300293
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00068306922912598
(118) DESCRIBE `ports` 0.0028941631317139
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00072097778320312
(120) DESCRIBE `ports` 0.002918004989624
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0005948543548584
(122) DESCRIBE `avid_specials` 0.0025808811187744
(123) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41776 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0022621154785156
(124) DESCRIBE `cruiselines` 0.0039689540863037
(125) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00071001052856445
(126) DESCRIBE `orchid_image` 0.0031659603118896
(127) DESCRIBE `cruiselines` 0.0040411949157715
(128) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00062298774719238
(129) DESCRIBE `cruises` 0.0053279399871826
(130) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70933') 0.00065517425537109
(131) DESCRIBE `ships` 0.0052721500396729
(132) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00072503089904785
(133) DESCRIBE `ships` 0.0059018135070801
(134) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00068998336791992
(135) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.000701904296875
(136) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00049304962158203
(137) DESCRIBE `itineraries` 0.0023758411407471
(138) DESCRIBE `ports` 0.002418041229248
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0005650520324707
(140) DESCRIBE `ports` 0.002669095993042
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00060892105102539
(142) DESCRIBE `ports` 0.0028040409088135
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044703483581543
(144) DESCRIBE `sailingdates` 0.0023219585418701
(145) DESCRIBE `ports` 0.002918004989624
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00065016746520996
(147) DESCRIBE `ports` 0.0027608871459961
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00095105171203613
(149) DESCRIBE `ports` 0.0028069019317627
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00060701370239258
(151) DESCRIBE `ports` 0.0028431415557861
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00055599212646484
(153) DESCRIBE `ports` 0.0027029514312744
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00055789947509766
(155) DESCRIBE `ports` 0.0025980472564697
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00056600570678711
(157) DESCRIBE `ports` 0.0028009414672852
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00066208839416504
(159) DESCRIBE `ports` 0.0028121471405029
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00058507919311523
(161) DESCRIBE `ports` 0.0028018951416016
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00061893463134766
(163) DESCRIBE `ports` 0.0027258396148682
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00064802169799805
(165) DESCRIBE `ports` 0.0030269622802734
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00065708160400391
(167) DESCRIBE `ports` 0.0028460025787354
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00056600570678711
(169) DESCRIBE `avid_specials` 0.0025379657745361
(170) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70933 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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
(171) DESCRIBE `cruiselines` 0.0040149688720703
(172) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00066781044006348
(173) DESCRIBE `orchid_image` 0.0029571056365967
(174) DESCRIBE `cruiselines` 0.0040030479431152
(175) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00058412551879883
(176) DESCRIBE `cruises` 0.0040509700775146
(177) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50857') 0.0010089874267578
(178) DESCRIBE `ships` 0.0053250789642334
(179) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00068497657775879
(180) DESCRIBE `ships` 0.004019021987915
(181) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00046992301940918
(182) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035810470581055
(183) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00043582916259766
(184) DESCRIBE `itineraries` 0.0019340515136719
(185) DESCRIBE `ports` 0.0019040107727051
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043511390686035
(187) DESCRIBE `ports` 0.0021049976348877
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0005180835723877
(189) DESCRIBE `ports` 0.0018799304962158
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044417381286621
(191) DESCRIBE `sailingdates` 0.0020020008087158
(192) DESCRIBE `ports` 0.0030169486999512
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00069093704223633
(194) DESCRIBE `ports` 0.0027601718902588
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044894218444824
(196) DESCRIBE `ports` 0.0020599365234375
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00044798851013184
(198) DESCRIBE `ports` 0.0018141269683838
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00040197372436523
(200) DESCRIBE `ports` 0.0020830631256104
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00047802925109863
(202) DESCRIBE `ports` 0.0019760131835938
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.0004878044128418
(204) DESCRIBE `ports` 0.0024271011352539
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0004880428314209
(206) DESCRIBE `ports` 0.0022389888763428
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00049519538879395
(208) DESCRIBE `ports` 0.0020520687103271
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00053787231445312
(210) DESCRIBE `ports` 0.0028290748596191
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00055313110351562
(212) DESCRIBE `ports` 0.0028560161590576
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00058794021606445
(214) DESCRIBE `ports` 0.0028841495513916
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00073099136352539
(216) DESCRIBE `avid_specials` 0.0025949478149414
(217) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 50857 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0018248558044434
(218) DESCRIBE `cruiselines` 0.0032598972320557
(219) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00059986114501953
(220) DESCRIBE `orchid_image` 0.0022048950195312
(221) DESCRIBE `cruiselines` 0.0030620098114014
(222) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00057411193847656
(223) DESCRIBE `cruises` 0.0051469802856445
(224) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55703') 0.00061297416687012
(225) DESCRIBE `ships` 0.005324125289917
(226) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00080704689025879
(227) DESCRIBE `ships` 0.0053222179412842
(228) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00058197975158691
(229) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00050997734069824
(230) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00050091743469238
(231) DESCRIBE `itineraries` 0.0029449462890625
(232) DESCRIBE `ports` 0.0020129680633545
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00050091743469238
(234) DESCRIBE `ports` 0.002357006072998
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0006101131439209
(236) DESCRIBE `ports` 0.0027880668640137
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0006110668182373
(238) DESCRIBE `sailingdates` 0.0022220611572266
(239) DESCRIBE `ports` 0.0023658275604248
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00055599212646484
(241) DESCRIBE `ports` 0.0024259090423584
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00054597854614258
(243) DESCRIBE `ports` 0.0028088092803955
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00063300132751465
(245) DESCRIBE `ports` 0.0028548240661621
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.0006098747253418
(247) DESCRIBE `ports` 0.0029771327972412
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00070810317993164
(249) DESCRIBE `ports` 0.0028071403503418
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00071477890014648
(251) DESCRIBE `avid_specials` 0.002565860748291
(252) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55703 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0018761157989502
(253) DESCRIBE `cruiselines` 0.0035820007324219
(254) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00073814392089844
(255) DESCRIBE `orchid_image` 0.0028789043426514
(256) DESCRIBE `cruiselines` 0.0030338764190674
(257) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00048708915710449
(258) DESCRIBE `cruises` 0.0038208961486816
(259) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70947') 0.0004417896270752
(260) DESCRIBE `ships` 0.003777027130127
(261) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00066304206848145
(262) DESCRIBE `ships` 0.0038840770721436
(263) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00043892860412598
(264) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036120414733887
(265) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00064992904663086
(266) DESCRIBE `itineraries` 0.0030021667480469
(267) DESCRIBE `ports` 0.0023372173309326
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00064778327941895
(269) DESCRIBE `ports` 0.002579927444458
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00053191184997559
(271) DESCRIBE `ports` 0.0023660659790039
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00059604644775391
(273) DESCRIBE `sailingdates` 0.0023610591888428
(274) DESCRIBE `ports` 0.0024278163909912
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00071120262145996
(276) DESCRIBE `ports` 0.0021710395812988
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00061297416687012
(278) DESCRIBE `ports` 0.0021219253540039
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00045680999755859
(280) DESCRIBE `ports` 0.0025291442871094
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00044083595275879
(282) DESCRIBE `ports` 0.0018680095672607
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00044393539428711
(284) DESCRIBE `ports` 0.0018939971923828
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.0004270076751709
(286) DESCRIBE `ports` 0.0027821063995361
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00058197975158691
(288) DESCRIBE `ports` 0.0026288032531738
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.0004727840423584
(290) DESCRIBE `ports` 0.0028219223022461
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00082707405090332
(292) DESCRIBE `ports` 0.0029599666595459
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00066399574279785
(294) DESCRIBE `ports` 0.0027129650115967
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00066494941711426
(296) DESCRIBE `ports` 0.0021219253540039
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041890144348145
(298) DESCRIBE `avid_specials` 0.0018160343170166
(299) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70947 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0013198852539062
(300) DESCRIBE `cruiselines` 0.0030980110168457
(301) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00065302848815918
(302) DESCRIBE `orchid_image` 0.0031008720397949
(303) DESCRIBE `cruiselines` 0.0041899681091309
(304) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00067305564880371
(305) DESCRIBE `cruises` 0.0053229331970215
(306) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70948') 0.00070810317993164
(307) DESCRIBE `ships` 0.0054440498352051
(308) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00068902969360352
(309) DESCRIBE `ships` 0.0043280124664307
(310) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00051498413085938
(311) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0005638599395752
(312) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037193298339844
(313) DESCRIBE `itineraries` 0.0022890567779541
(314) DESCRIBE `ports` 0.0024290084838867
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046682357788086
(316) DESCRIBE `ports` 0.0024340152740479
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004889965057373
(318) DESCRIBE `ports` 0.002418041229248
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043392181396484
(320) DESCRIBE `sailingdates` 0.0021471977233887
(321) DESCRIBE `ports` 0.0031909942626953
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00072598457336426
(323) DESCRIBE `ports` 0.0026829242706299
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00066518783569336
(325) DESCRIBE `ports` 0.0027079582214355
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4208))) 0.0009009838104248
(327) DESCRIBE `ports` 0.0029540061950684
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4208') 0.00068306922912598
(329) DESCRIBE `ports` 0.0029230117797852
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00065398216247559
(331) DESCRIBE `ports` 0.0026049613952637
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00062894821166992
(333) DESCRIBE `ports` 0.0022799968719482
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2751))) 0.00054693222045898
(335) DESCRIBE `ports` 0.0024349689483643
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2751') 0.00065708160400391
(337) DESCRIBE `ports` 0.0027561187744141
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 734))) 0.00077700614929199
(339) DESCRIBE `ports` 0.0026350021362305
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '734') 0.00063514709472656
(341) DESCRIBE `ports` 0.0029640197753906
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00072789192199707
(343) DESCRIBE `ports` 0.0029819011688232
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00066709518432617
(345) DESCRIBE `ports` 0.0027740001678467
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00069808959960938
(347) DESCRIBE `ports` 0.0028700828552246
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00053501129150391
(349) DESCRIBE `avid_specials` 0.0021748542785645
(350) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70948 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0014040470123291
(351) DESCRIBE `cruiselines` 0.0029001235961914
(352) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00046896934509277
(353) DESCRIBE `orchid_image` 0.0028278827667236
(354) DESCRIBE `cruiselines` 0.0034940242767334
(355) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00046420097351074
(356) DESCRIBE `cruises` 0.0050010681152344
(357) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65891') 0.00060009956359863
(358) DESCRIBE `ships` 0.0049471855163574
(359) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.0007011890411377
(360) DESCRIBE `ships` 0.0050609111785889
(361) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00074505805969238
(362) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00044989585876465
(363) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00042414665222168
(364) DESCRIBE `itineraries` 0.0024571418762207
(365) DESCRIBE `ports` 0.0023880004882812
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00056791305541992
(367) DESCRIBE `ports` 0.0023009777069092
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00054311752319336
(369) DESCRIBE `ports` 0.0022990703582764
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00049495697021484
(371) DESCRIBE `sailingdates` 0.0030860900878906
(372) DESCRIBE `ports` 0.0030529499053955
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00070881843566895
(374) DESCRIBE `ports` 0.0029268264770508
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00066184997558594
(376) DESCRIBE `ports` 0.0028820037841797
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00075006484985352
(378) DESCRIBE `ports` 0.0029370784759521
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00063490867614746
(380) DESCRIBE `ports` 0.0029339790344238
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00072979927062988
(382) DESCRIBE `ports` 0.0029821395874023
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00065398216247559
(384) DESCRIBE `ports` 0.0029089450836182
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00074100494384766
(386) DESCRIBE `ports` 0.0029580593109131
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00061702728271484
(388) DESCRIBE `avid_specials` 0.0026118755340576
(389) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65891 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0023949146270752
(390) DESCRIBE `cruiselines` 0.0040600299835205
(391) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00075292587280273
(392) DESCRIBE `orchid_image` 0.0032081604003906
(393) DESCRIBE `cruiselines` 0.0043900012969971
(394) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00061893463134766
(395) DESCRIBE `cruises` 0.0042171478271484
(396) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50866') 0.00053787231445312
(397) DESCRIBE `ships` 0.0040278434753418
(398) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00065994262695312
(399) DESCRIBE `ships` 0.0052590370178223
(400) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00053596496582031
(401) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00041699409484863
(402) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00047087669372559
(403) DESCRIBE `itineraries` 0.0030980110168457
(404) DESCRIBE `ports` 0.0030310153961182
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00070786476135254
(406) DESCRIBE `ports` 0.0027809143066406
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00063300132751465
(408) DESCRIBE `ports` 0.002810001373291
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00067591667175293
(410) DESCRIBE `sailingdates` 0.0024240016937256
(411) DESCRIBE `ports` 0.0029470920562744
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0006868839263916
(413) DESCRIBE `ports` 0.0029339790344238
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00068902969360352
(415) DESCRIBE `ports` 0.0029151439666748
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00082015991210938
(417) DESCRIBE `ports` 0.0025198459625244
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00047707557678223
(419) DESCRIBE `ports` 0.0019590854644775
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00046014785766602
(421) DESCRIBE `ports` 0.0019741058349609
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00040698051452637
(423) DESCRIBE `ports` 0.0019550323486328
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0004279613494873
(425) DESCRIBE `ports` 0.0022220611572266
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00043106079101562
(427) DESCRIBE `ports` 0.0018749237060547
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00059700012207031
(429) DESCRIBE `ports` 0.002863883972168
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00064706802368164
(431) DESCRIBE `avid_specials` 0.0025479793548584
(432) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 50866 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0024838447570801
(433) DESCRIBE `cruiselines` 0.0041511058807373
(434) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00068306922912598
(435) DESCRIBE `orchid_image` 0.0041549205780029
(436) DESCRIBE `cruiselines` 0.0036251544952393
(437) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00058794021606445
(438) DESCRIBE `ships` 0.0044939517974854
(439) SELECT `ships`.* FROM `ships` WHERE (id IN ('4', '1722')) ORDER BY FIND_IN_SET(id, '4,1722') 0.0011818408966064
(440) DESCRIBE `cruisetypes` 0.0016329288482666
(441) DESCRIBE `destinations` 0.0027420520782471
(442) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.00072908401489258
(443) DESCRIBE `cruiselines` 0.0032238960266113
(444) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00051999092102051
(445) DESCRIBE `cruiselines` 0.0030820369720459
(446) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00067806243896484