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

Total elapsed time: 2.1762936115265

# Query Time
(1) connect 0.0062320232391357
(2) DESCRIBE `cruises` 0.014481067657471
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (41778, 50857, 55703, 70947, 70948, 41776, 65891, 50866, 63373, 55702)) ORDER BY FIND_IN_SET(id, '41778,50857,55703,70947,70948,41776,65891,50866,63373,55702') 0.0039520263671875
(4) DESCRIBE `cruises` 0.018128871917725
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41778') 0.0018858909606934
(6) DESCRIBE `ships` 0.012794017791748
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00084495544433594
(8) DESCRIBE `ships` 0.020365953445435
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.008922815322876
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0065650939941406
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00050592422485352
(12) DESCRIBE `itineraries` 0.0028579235076904
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '41778') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0031960010528564
(14) DESCRIBE `ports` 0.003277063369751
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0011210441589355
(16) DESCRIBE `ports` 0.0051147937774658
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00075721740722656
(18) DESCRIBE `ports` 0.0087480545043945
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00062918663024902
(20) DESCRIBE `sailingdates` 0.011380195617676
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '41778') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.001431941986084
(22) DESCRIBE `ports` 0.0026648044586182
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00060820579528809
(24) DESCRIBE `ports` 0.0027079582214355
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0005190372467041
(26) DESCRIBE `ports` 0.0040180683135986
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0067448616027832
(28) DESCRIBE `ports` 0.0035750865936279
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0010139942169189
(30) DESCRIBE `avid_specials` 0.0058810710906982
(31) 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.004518985748291
(32) DESCRIBE `cruiselines` 0.004539966583252
(33) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00073814392089844
(34) DESCRIBE `orchid_image` 0.0039021968841553
(35) DESCRIBE `cruiselines` 0.0052170753479004
(36) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0071139335632324
(37) DESCRIBE `cruises` 0.01056694984436
(38) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50857') 0.00059390068054199
(39) DESCRIBE `ships` 0.018729209899902
(40) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.0016160011291504
(41) DESCRIBE `ships` 0.0098810195922852
(42) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00079703330993652
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0020740032196045
(44) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00063991546630859
(45) DESCRIBE `itineraries` 0.0052361488342285
(46) DESCRIBE `ports` 0.018755912780762
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0022609233856201
(48) DESCRIBE `ports` 0.014749050140381
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0031051635742188
(50) DESCRIBE `ports` 0.034480810165405
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.010786056518555
(52) DESCRIBE `sailingdates` 0.0035901069641113
(53) DESCRIBE `ports` 0.0050899982452393
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00118088722229
(55) DESCRIBE `ports` 0.0032889842987061
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00066709518432617
(57) DESCRIBE `ports` 0.0036351680755615
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00086617469787598
(59) DESCRIBE `ports` 0.0061750411987305
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0097610950469971
(61) DESCRIBE `ports` 0.052490949630737
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.0031290054321289
(63) DESCRIBE `ports` 0.0034921169281006
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00070500373840332
(65) DESCRIBE `ports` 0.008342981338501
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0011260509490967
(67) DESCRIBE `ports` 0.0076029300689697
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00071001052856445
(69) DESCRIBE `ports` 0.0062379837036133
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.0069160461425781
(71) DESCRIBE `ports` 0.0050859451293945
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.013526916503906
(73) DESCRIBE `ports` 0.0027468204498291
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00076413154602051
(75) DESCRIBE `ports` 0.0027420520782471
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.012337923049927
(77) DESCRIBE `avid_specials` 0.0027709007263184
(78) 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.0024850368499756
(79) DESCRIBE `cruiselines` 0.031753063201904
(80) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00079083442687988
(81) DESCRIBE `orchid_image` 0.018959999084473
(82) DESCRIBE `cruiselines` 0.026180982589722
(83) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0019989013671875
(84) DESCRIBE `cruises` 0.018444061279297
(85) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55703') 0.0017650127410889
(86) DESCRIBE `ships` 0.016713857650757
(87) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.02173900604248
(88) DESCRIBE `ships` 0.026726007461548
(89) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00053882598876953
(90) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0006248950958252
(91) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00048995018005371
(92) DESCRIBE `itineraries` 0.0026190280914307
(93) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '55703') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.001107931137085
(94) DESCRIBE `ports` 0.0027627944946289
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0077979564666748
(96) DESCRIBE `ports` 0.0027670860290527
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00054121017456055
(98) DESCRIBE `ports` 0.014955997467041
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00075006484985352
(100) DESCRIBE `sailingdates` 0.0062410831451416
(101) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '55703') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0069899559020996
(102) DESCRIBE `ports` 0.0032320022583008
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00069618225097656
(104) DESCRIBE `ports` 0.00325608253479
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00065302848815918
(106) DESCRIBE `ports` 0.0027511119842529
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.0023519992828369
(108) DESCRIBE `ports` 0.0030548572540283
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.020498037338257
(110) DESCRIBE `ports` 0.0057699680328369
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0014989376068115
(112) DESCRIBE `ports` 0.012848138809204
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0007939338684082
(114) DESCRIBE `avid_specials` 0.025729894638062
(115) 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.0070888996124268
(116) DESCRIBE `cruiselines` 0.0066330432891846
(117) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0008080005645752
(118) DESCRIBE `orchid_image` 0.0031709671020508
(119) DESCRIBE `cruiselines` 0.0046749114990234
(120) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0007479190826416
(121) DESCRIBE `cruises` 0.018149137496948
(122) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70947') 0.00067996978759766
(123) DESCRIBE `ships` 0.023216962814331
(124) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.004601001739502
(125) DESCRIBE `ships` 0.013417959213257
(126) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0025670528411865
(127) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00060391426086426
(128) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00050806999206543
(129) DESCRIBE `itineraries` 0.0069551467895508
(130) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70947') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00090289115905762
(131) DESCRIBE `ports` 0.0044608116149902
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00072717666625977
(133) DESCRIBE `ports` 0.02006196975708
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0011310577392578
(135) DESCRIBE `ports` 0.0028069019317627
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0050749778747559
(137) DESCRIBE `sailingdates` 0.0024740695953369
(138) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70947') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.012233018875122
(139) DESCRIBE `ports` 0.0075860023498535
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00088381767272949
(141) DESCRIBE `ports` 0.022260904312134
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00087404251098633
(143) DESCRIBE `ports` 0.010648012161255
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00076413154602051
(145) DESCRIBE `ports` 0.0030438899993896
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00065088272094727
(147) DESCRIBE `ports` 0.003140926361084
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.0093410015106201
(149) DESCRIBE `ports` 0.0029101371765137
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00066184997558594
(151) DESCRIBE `ports` 0.0027029514312744
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.0067038536071777
(153) DESCRIBE `ports` 0.015729904174805
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00061988830566406
(155) DESCRIBE `ports` 0.004417896270752
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00094294548034668
(157) DESCRIBE `ports` 0.0046629905700684
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0087909698486328
(159) DESCRIBE `ports` 0.0046930313110352
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0010499954223633
(161) DESCRIBE `ports` 0.0041999816894531
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0029571056365967
(163) DESCRIBE `avid_specials` 0.010019779205322
(164) 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.0023190975189209
(165) DESCRIBE `cruiselines` 0.014478921890259
(166) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00075602531433105
(167) DESCRIBE `orchid_image` 0.0031421184539795
(168) DESCRIBE `cruiselines` 0.0047369003295898
(169) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.012917041778564
(170) DESCRIBE `cruises` 0.0053679943084717
(171) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70948') 0.00069808959960938
(172) DESCRIBE `ships` 0.017214775085449
(173) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00087189674377441
(174) DESCRIBE `ships` 0.017734050750732
(175) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0011498928070068
(176) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00092101097106934
(177) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0068509578704834
(178) DESCRIBE `itineraries` 0.018337965011597
(179) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70948') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0091140270233154
(180) DESCRIBE `ports` 0.0052890777587891
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.000701904296875
(182) DESCRIBE `ports` 0.0030999183654785
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00076818466186523
(184) DESCRIBE `ports` 0.0030388832092285
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00059008598327637
(186) DESCRIBE `sailingdates` 0.002443790435791
(187) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70948') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010428428649902
(188) DESCRIBE `ports` 0.0033349990844727
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00067710876464844
(190) DESCRIBE `ports` 0.0029358863830566
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00060915946960449
(192) DESCRIBE `ports` 0.0027310848236084
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4208))) 0.00076818466186523
(194) DESCRIBE `ports` 0.0027198791503906
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4208') 0.00061917304992676
(196) DESCRIBE `ports` 0.0029399394989014
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00067496299743652
(198) DESCRIBE `ports` 0.0023119449615479
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00057005882263184
(200) DESCRIBE `ports` 0.0025811195373535
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2751))) 0.00065016746520996
(202) DESCRIBE `ports` 0.0023541450500488
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2751') 0.00045394897460938
(204) DESCRIBE `ports` 0.0025510787963867
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 734))) 0.00049591064453125
(206) DESCRIBE `ports` 0.0025689601898193
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '734') 0.00053191184997559
(208) DESCRIBE `ports` 0.0026309490203857
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00076794624328613
(210) DESCRIBE `ports` 0.003032922744751
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00064182281494141
(212) DESCRIBE `ports` 0.0030519962310791
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00064706802368164
(214) DESCRIBE `ports` 0.002263069152832
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041103363037109
(216) DESCRIBE `avid_specials` 0.0016849040985107
(217) 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.0016541481018066
(218) DESCRIBE `cruiselines` 0.0032010078430176
(219) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00061392784118652
(220) DESCRIBE `orchid_image` 0.0022869110107422
(221) DESCRIBE `cruiselines` 0.0030570030212402
(222) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00044989585876465
(223) DESCRIBE `cruises` 0.0043020248413086
(224) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41776') 0.00051307678222656
(225) DESCRIBE `ships` 0.0042459964752197
(226) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00081300735473633
(227) DESCRIBE `ships` 0.0043308734893799
(228) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00063204765319824
(229) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00048303604125977
(230) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00044512748718262
(231) DESCRIBE `itineraries` 0.003587007522583
(232) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '41776') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010550022125244
(233) DESCRIBE `ports` 0.0035510063171387
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00080513954162598
(235) DESCRIBE `ports` 0.003000020980835
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0006411075592041
(237) DESCRIBE `ports` 0.0029458999633789
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00080299377441406
(239) DESCRIBE `sailingdates` 0.0025949478149414
(240) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '41776') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011441707611084
(241) DESCRIBE `ports` 0.01213002204895
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0022280216217041
(243) DESCRIBE `ports` 0.0061118602752686
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0010139942169189
(245) DESCRIBE `ports` 0.0032548904418945
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.001349925994873
(247) DESCRIBE `ports` 0.0031859874725342
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00062203407287598
(249) DESCRIBE `ports` 0.0027248859405518
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00070405006408691
(251) DESCRIBE `ports` 0.0024380683898926
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00061821937561035
(253) DESCRIBE `ports` 0.0030679702758789
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00080084800720215
(255) DESCRIBE `ports` 0.0029079914093018
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00076580047607422
(257) DESCRIBE `ports` 0.0029590129852295
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00087904930114746
(259) DESCRIBE `ports` 0.003108024597168
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00059795379638672
(261) DESCRIBE `avid_specials` 0.0027370452880859
(262) 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.003093957901001
(263) DESCRIBE `cruiselines` 0.0043978691101074
(264) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00098180770874023
(265) DESCRIBE `orchid_image` 0.0028891563415527
(266) DESCRIBE `cruiselines` 0.004356861114502
(267) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00064992904663086
(268) DESCRIBE `cruises` 0.00577712059021
(269) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65891') 0.00082302093505859
(270) DESCRIBE `ships` 0.0058829784393311
(271) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00089097023010254
(272) DESCRIBE `ships` 0.0058009624481201
(273) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00078487396240234
(274) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00058507919311523
(275) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0006561279296875
(276) DESCRIBE `itineraries` 0.0034620761871338
(277) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65891') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.001492977142334
(278) DESCRIBE `ports` 0.0033249855041504
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0013220310211182
(280) DESCRIBE `ports` 0.0046448707580566
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.001882791519165
(282) DESCRIBE `ports` 0.0048410892486572
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0012040138244629
(284) DESCRIBE `sailingdates` 0.010606050491333
(285) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65891') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0016229152679443
(286) DESCRIBE `ports` 0.0029158592224121
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0007328987121582
(288) DESCRIBE `ports` 0.0027799606323242
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00057005882263184
(290) DESCRIBE `ports` 0.0027341842651367
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00081515312194824
(292) DESCRIBE `ports` 0.013007879257202
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00074100494384766
(294) DESCRIBE `ports` 0.002885103225708
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.0006711483001709
(296) DESCRIBE `ports` 0.0033409595489502
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.0009009838104248
(298) DESCRIBE `ports` 0.0029971599578857
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00078201293945312
(300) DESCRIBE `ports` 0.0030210018157959
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00070691108703613
(302) DESCRIBE `avid_specials` 0.0027170181274414
(303) 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.0032100677490234
(304) DESCRIBE `cruiselines` 0.0080440044403076
(305) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0015048980712891
(306) DESCRIBE `orchid_image` 0.016813039779663
(307) DESCRIBE `cruiselines` 0.031723022460938
(308) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00092506408691406
(309) DESCRIBE `cruises` 0.0061979293823242
(310) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50866') 0.0030019283294678
(311) DESCRIBE `ships` 0.0082089900970459
(312) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.0011608600616455
(313) DESCRIBE `ships` 0.0077190399169922
(314) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0016908645629883
(315) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0023739337921143
(316) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0013940334320068
(317) DESCRIBE `itineraries` 0.012021064758301
(318) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '50866') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0070569515228271
(319) DESCRIBE `ports` 0.0037829875946045
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0053770542144775
(321) DESCRIBE `ports` 0.0032398700714111
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00084304809570312
(323) DESCRIBE `ports` 0.0034830570220947
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0010471343994141
(325) DESCRIBE `sailingdates` 0.0056009292602539
(326) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '50866') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0018370151519775
(327) DESCRIBE `ports` 0.0032858848571777
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0013248920440674
(329) DESCRIBE `ports` 0.0060348510742188
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0016529560089111
(331) DESCRIBE `ports` 0.0058140754699707
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0010368824005127
(333) DESCRIBE `ports` 0.0029139518737793
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00072598457336426
(335) DESCRIBE `ports` 0.0031092166900635
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00074577331542969
(337) DESCRIBE `ports` 0.0037310123443604
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00070881843566895
(339) DESCRIBE `ports` 0.003242015838623
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00085997581481934
(341) DESCRIBE `ports` 0.0031590461730957
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00078487396240234
(343) DESCRIBE `ports` 0.0031149387359619
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00088095664978027
(345) DESCRIBE `ports` 0.0032570362091064
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00070905685424805
(347) DESCRIBE `avid_specials` 0.0026121139526367
(348) 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.0021979808807373
(349) DESCRIBE `cruiselines` 0.004019021987915
(350) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00085902214050293
(351) DESCRIBE `orchid_image` 0.0036928653717041
(352) DESCRIBE `cruiselines` 0.076303958892822
(353) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00068902969360352
(354) DESCRIBE `cruises` 0.0061390399932861
(355) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63373') 0.00080704689025879
(356) DESCRIBE `ships` 0.0060789585113525
(357) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.0015749931335449
(358) DESCRIBE `ships` 0.0060329437255859
(359) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00096011161804199
(360) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00056195259094238
(361) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00044584274291992
(362) DESCRIBE `itineraries` 0.02447509765625
(363) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63373') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0019810199737549
(364) DESCRIBE `ports` 0.017374038696289
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00094914436340332
(366) DESCRIBE `ports` 0.0031909942626953
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00078797340393066
(368) DESCRIBE `ports` 0.0036251544952393
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00079202651977539
(370) DESCRIBE `sailingdates` 0.0029830932617188
(371) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63373') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0013539791107178
(372) DESCRIBE `ports` 0.0030968189239502
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.012764930725098
(374) DESCRIBE `ports` 0.0036399364471436
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00084614753723145
(376) DESCRIBE `ports` 0.0031471252441406
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00066685676574707
(378) DESCRIBE `ports` 0.003119945526123
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00071120262145996
(380) DESCRIBE `ports` 0.0033299922943115
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00088214874267578
(382) DESCRIBE `ports` 0.003068208694458
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00064706802368164
(384) DESCRIBE `ports` 0.0030670166015625
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00072193145751953
(386) DESCRIBE `ports` 0.0030221939086914
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00067305564880371
(388) DESCRIBE `ports` 0.0030069351196289
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.0007328987121582
(390) DESCRIBE `ports` 0.0028610229492188
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00061607360839844
(392) DESCRIBE `ports` 0.00295090675354
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0007178783416748
(394) DESCRIBE `ports` 0.0031979084014893
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00068497657775879
(396) DESCRIBE `ports` 0.0030760765075684
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00089406967163086
(398) DESCRIBE `ports` 0.0029489994049072
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00066709518432617
(400) DESCRIBE `avid_specials` 0.002734899520874
(401) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63373 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.0023651123046875
(402) DESCRIBE `cruiselines` 0.0042741298675537
(403) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00084996223449707
(404) DESCRIBE `orchid_image` 0.0033199787139893
(405) DESCRIBE `cruiselines` 0.0042030811309814
(406) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00091290473937988
(407) DESCRIBE `cruises` 0.0059659481048584
(408) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55702') 0.00073885917663574
(409) DESCRIBE `ships` 0.0058591365814209
(410) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.0010490417480469
(411) DESCRIBE `ships` 0.0057721138000488
(412) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00074386596679688
(413) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00050687789916992
(414) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00053787231445312
(415) DESCRIBE `itineraries` 0.0027039051055908
(416) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '55702') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00098896026611328
(417) DESCRIBE `ports` 0.0029380321502686
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00070405006408691
(419) DESCRIBE `ports` 0.0029129981994629
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00067710876464844
(421) DESCRIBE `ports` 0.0028750896453857
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.001162052154541
(423) DESCRIBE `sailingdates` 0.0024127960205078
(424) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '55702') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011470317840576
(425) DESCRIBE `ports` 0.014894008636475
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00079584121704102
(427) DESCRIBE `ports` 0.0030601024627686
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00061202049255371
(429) DESCRIBE `ports` 0.0028297901153564
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.0026040077209473
(431) DESCRIBE `ports` 0.0030179023742676
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.0012040138244629
(433) DESCRIBE `ports` 0.003521203994751
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00071501731872559
(435) DESCRIBE `ports` 0.0024628639221191
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0005490779876709
(437) DESCRIBE `avid_specials` 0.0024549961090088
(438) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55702 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.0021431446075439
(439) DESCRIBE `cruiselines` 0.007922887802124
(440) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.000946044921875
(441) DESCRIBE `orchid_image` 0.0035560131072998
(442) DESCRIBE `cruiselines` 0.0045499801635742
(443) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00099611282348633
(444) DESCRIBE `ships` 0.027577877044678
(445) SELECT `ships`.* FROM `ships` WHERE (id IN ('1722', '4')) ORDER BY FIND_IN_SET(id, '1722,4') 0.001884937286377
(446) DESCRIBE `cruisetypes` 0.017383098602295
(447) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '4') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.10585403442383
(448) DESCRIBE `destinations` 0.004871129989624
(449) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.0011191368103027
(450) DESCRIBE `cruiselines` 0.0050339698791504
(451) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00098109245300293
(452) DESCRIBE `cruiselines` 0.011251926422119
(453) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0050578117370605