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

Total elapsed time: 0.51039028167725

# Query Time
(1) connect 0.00096797943115234
(2) DESCRIBE `cruises` 0.0031421184539795
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (41776, 70935, 41778, 70933, 50857, 55703, 70947, 70948, 65891, 50866)) ORDER BY FIND_IN_SET(id, '41776,70935,41778,70933,50857,55703,70947,70948,65891,50866') 0.0014650821685791
(4) DESCRIBE `cruises` 0.0033290386199951
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41776') 0.00036787986755371
(6) DESCRIBE `ships` 0.0026140213012695
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00048398971557617
(8) DESCRIBE `ships` 0.0025439262390137
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00032997131347656
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025701522827148
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.000244140625
(12) DESCRIBE `itineraries` 0.0013880729675293
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '41776') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00070500373840332
(14) DESCRIBE `ports` 0.0014650821685791
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031590461730957
(16) DESCRIBE `ports` 0.0013298988342285
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028896331787109
(18) DESCRIBE `ports` 0.0015780925750732
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00035405158996582
(20) DESCRIBE `sailingdates` 0.0015640258789062
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '41776') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0016000270843506
(22) DESCRIBE `ports` 0.0022299289703369
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046205520629883
(24) DESCRIBE `ports` 0.0023269653320312
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00050997734069824
(26) DESCRIBE `ports` 0.0018460750579834
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0
(28) DESCRIBE `ports` 0.0019018650054932
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00012898445129395
(30) DESCRIBE `ports` 0.0020840167999268
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0
(32) DESCRIBE `ports` 0.0017290115356445
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00030899047851562
(34) DESCRIBE `ports` 0.0015790462493896
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00036311149597168
(36) DESCRIBE `ports` 0.0012929439544678
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0
(38) DESCRIBE `ports` 0.0012857913970947
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038385391235352
(40) DESCRIBE `ports` 0.0017709732055664
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034379959106445
(42) DESCRIBE `avid_specials` 0.0015559196472168
(43) 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.0013060569763184
(44) DESCRIBE `cruiselines` 0.0025620460510254
(45) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00036501884460449
(46) DESCRIBE `orchid_image` 0.0014519691467285
(47) DESCRIBE `cruiselines` 0.0021300315856934
(48) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0
(49) DESCRIBE `cruises` 0.0035519599914551
(50) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70935') 0.00044107437133789
(51) DESCRIBE `ships` 0.0026469230651855
(52) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00033903121948242
(53) DESCRIBE `ships` 0.0035231113433838
(54) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00043988227844238
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0010249614715576
(56) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 2.6941299438477E-5
(57) DESCRIBE `itineraries` 0.0012249946594238
(58) DESCRIBE `ports` 0.0019450187683105
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044918060302734
(60) DESCRIBE `ports` 0.0016958713531494
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038385391235352
(62) DESCRIBE `ports` 0.0013427734375
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037288665771484
(64) DESCRIBE `sailingdates` 0.0014979839324951
(65) DESCRIBE `ports` 0.0015029907226562
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034809112548828
(67) DESCRIBE `ports` 0.00136399269104
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002899169921875
(69) DESCRIBE `ports` 0.0013117790222168
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00029516220092773
(71) DESCRIBE `ports` 0.0013630390167236
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00029993057250977
(73) DESCRIBE `ports` 0.0013048648834229
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.0003058910369873
(75) DESCRIBE `ports` 0.0012960433959961
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00029611587524414
(77) DESCRIBE `ports` 0.0015599727630615
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00042319297790527
(79) DESCRIBE `ports` 0.0018718242645264
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00038409233093262
(81) DESCRIBE `ports` 0.0014770030975342
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00030183792114258
(83) DESCRIBE `ports` 0.0013561248779297
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00090289115905762
(85) DESCRIBE `ports` 0.00142502784729
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.0009620189666748
(87) DESCRIBE `ports` 0.001352071762085
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00031805038452148
(89) DESCRIBE `ports` 0.0016131401062012
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035786628723145
(91) DESCRIBE `ports` 0.0017540454864502
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0
(93) DESCRIBE `avid_specials` 0.0015311241149902
(94) 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.0015780925750732
(95) DESCRIBE `cruiselines` 0.0025579929351807
(96) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00047802925109863
(97) DESCRIBE `orchid_image` 0.0020139217376709
(98) DESCRIBE `cruiselines` 0.0025861263275146
(99) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00042414665222168
(100) DESCRIBE `cruises` 0.0034749507904053
(101) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41778') 0.00041103363037109
(102) DESCRIBE `ships` 0.0036289691925049
(103) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00052118301391602
(104) DESCRIBE `ships` 0.0036869049072266
(105) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00043511390686035
(106) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034499168395996
(107) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030207633972168
(108) DESCRIBE `itineraries` 0.0017349720001221
(109) DESCRIBE `ports` 0.001798152923584
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040292739868164
(111) DESCRIBE `ports` 0.0015959739685059
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040507316589355
(113) DESCRIBE `ports` 0.0016860961914062
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037479400634766
(115) DESCRIBE `sailingdates` 0.0015339851379395
(116) DESCRIBE `ports` 0.0018320083618164
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043821334838867
(118) DESCRIBE `ports` 0.0017938613891602
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037503242492676
(120) DESCRIBE `ports` 0.0018000602722168
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040507316589355
(122) DESCRIBE `ports` 0.0017068386077881
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040197372436523
(124) DESCRIBE `avid_specials` 0.0015010833740234
(125) 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.0016591548919678
(126) DESCRIBE `cruiselines` 0.0023441314697266
(127) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00043702125549316
(128) DESCRIBE `orchid_image` 0.0021889209747314
(129) DESCRIBE `cruiselines` 0.0024819374084473
(130) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00041699409484863
(131) DESCRIBE `cruises` 0.0036249160766602
(132) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70933') 0.00026202201843262
(133) DESCRIBE `ships` 0.0037240982055664
(134) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.0005800724029541
(135) DESCRIBE `ships` 0.0037040710449219
(136) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00045609474182129
(137) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030207633972168
(138) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031709671020508
(139) DESCRIBE `itineraries` 0.0017809867858887
(140) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70933') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00088000297546387
(141) DESCRIBE `ports` 0.0018930435180664
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044989585876465
(143) DESCRIBE `ports` 0.0018539428710938
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043582916259766
(145) DESCRIBE `ports` 0.0017688274383545
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037717819213867
(147) DESCRIBE `sailingdates` 0.0014679431915283
(148) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70933') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.001039981842041
(149) DESCRIBE `ports` 0.0023109912872314
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049495697021484
(151) DESCRIBE `ports` 0.0019159317016602
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 6.3896179199219E-5
(153) DESCRIBE `ports` 0.0018739700317383
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00046896934509277
(155) DESCRIBE `ports` 0.0022730827331543
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00036311149597168
(157) DESCRIBE `ports` 0.0017621517181396
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00012397766113281
(159) DESCRIBE `ports` 0.001662015914917
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00036096572875977
(161) DESCRIBE `ports` 0.0023610591888428
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00049185752868652
(163) DESCRIBE `ports` 0.0019168853759766
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00043988227844238
(165) DESCRIBE `ports` 0.0019159317016602
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00043821334838867
(167) DESCRIBE `ports` 0.001406192779541
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00030398368835449
(169) DESCRIBE `ports` 0.0013079643249512
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044894218444824
(171) DESCRIBE `ports` 0.0012960433959961
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00035405158996582
(173) DESCRIBE `avid_specials` 0.0012350082397461
(174) 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.0012290477752686
(175) DESCRIBE `cruiselines` 0.0021600723266602
(176) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00036907196044922
(177) DESCRIBE `orchid_image` 0.0014359951019287
(178) DESCRIBE `cruiselines` 0.0019211769104004
(179) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00047898292541504
(180) DESCRIBE `cruises` 0.0036001205444336
(181) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50857') 0.00049209594726562
(182) DESCRIBE `ships` 0.0032670497894287
(183) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00062298774719238
(184) DESCRIBE `ships` 0.0038168430328369
(185) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00044393539428711
(186) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033688545227051
(187) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031089782714844
(188) DESCRIBE `itineraries` 0.0018739700317383
(189) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '50857') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00089597702026367
(190) DESCRIBE `ports` 0.0021371841430664
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047421455383301
(192) DESCRIBE `ports` 0.0017600059509277
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039386749267578
(194) DESCRIBE `ports` 0.001971960067749
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037288665771484
(196) DESCRIBE `sailingdates` 0.0014030933380127
(197) DESCRIBE `ports` 0.0014669895172119
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044918060302734
(199) DESCRIBE `ports` 0.0014970302581787
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031208992004395
(201) DESCRIBE `ports` 0.0013201236724854
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00020790100097656
(203) DESCRIBE `ports` 0.0014181137084961
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00032806396484375
(205) DESCRIBE `ports` 0.0013890266418457
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00036096572875977
(207) DESCRIBE `ports` 0.001478910446167
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 8.5115432739258E-5
(209) DESCRIBE `ports` 0.0016729831695557
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00035881996154785
(211) DESCRIBE `ports` 0.0013189315795898
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00027179718017578
(213) DESCRIBE `ports` 0.0013527870178223
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00032496452331543
(215) DESCRIBE `ports` 0.0013549327850342
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00040698051452637
(217) DESCRIBE `ports` 0.0014870166778564
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038409233093262
(219) DESCRIBE `ports` 0.0016770362854004
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003819465637207
(221) DESCRIBE `avid_specials` 0.0013749599456787
(222) 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.0011289119720459
(223) DESCRIBE `cruiselines` 0.0023469924926758
(224) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00033783912658691
(225) DESCRIBE `orchid_image` 0.0014359951019287
(226) DESCRIBE `cruiselines` 0.0017969608306885
(227) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00028705596923828
(228) DESCRIBE `cruises` 0.0023980140686035
(229) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55703') 0.0003049373626709
(230) DESCRIBE `ships` 0.0025689601898193
(231) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00034713745117188
(232) DESCRIBE `ships` 0.0027799606323242
(233) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00030612945556641
(234) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030899047851562
(235) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025701522827148
(236) DESCRIBE `itineraries` 0.0012149810791016
(237) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '55703') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0007319450378418
(238) DESCRIBE `ports` 0.001270055770874
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032782554626465
(240) DESCRIBE `ports` 0.0013160705566406
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037002563476562
(242) DESCRIBE `ports` 0.0013890266418457
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027608871459961
(244) DESCRIBE `sailingdates` 0.0012919902801514
(245) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '55703') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0005950927734375
(246) DESCRIBE `ports` 0.0016031265258789
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045084953308105
(248) DESCRIBE `ports` 0.0016920566558838
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036096572875977
(250) DESCRIBE `ports` 0.0015490055084229
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00038290023803711
(252) DESCRIBE `ports` 0.0012760162353516
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00028300285339355
(254) DESCRIBE `ports` 0.0013320446014404
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030708312988281
(256) DESCRIBE `ports` 0.0012640953063965
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027680397033691
(258) DESCRIBE `avid_specials` 0.0012390613555908
(259) 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.0010621547698975
(260) DESCRIBE `cruiselines` 0.0019130706787109
(261) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00032711029052734
(262) DESCRIBE `orchid_image` 0.0014169216156006
(263) DESCRIBE `cruiselines` 0.0017819404602051
(264) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00031208992004395
(265) DESCRIBE `cruises` 0.0027029514312744
(266) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70947') 0.00038909912109375
(267) DESCRIBE `ships` 0.0027809143066406
(268) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00048708915710449
(269) DESCRIBE `ships` 0.0028560161590576
(270) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00033998489379883
(271) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026702880859375
(272) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025606155395508
(273) DESCRIBE `itineraries` 0.0013880729675293
(274) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70947') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00064587593078613
(275) DESCRIBE `ports` 0.001478910446167
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033307075500488
(277) DESCRIBE `ports` 0.0012948513031006
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037002563476562
(279) DESCRIBE `ports` 0.0015320777893066
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037384033203125
(281) DESCRIBE `sailingdates` 0.0012450218200684
(282) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70947') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0005950927734375
(283) DESCRIBE `ports` 0.0020031929016113
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 4.2915344238281E-5
(285) DESCRIBE `ports` 0.0019640922546387
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 9.0837478637695E-5
(287) DESCRIBE `ports` 0.0014669895172119
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00034093856811523
(289) DESCRIBE `ports` 0.00043082237243652
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00031495094299316
(291) DESCRIBE `ports` 0.0013840198516846
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0
(293) DESCRIBE `ports` 0.001431941986084
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00035691261291504
(295) DESCRIBE `ports` 0.001305103302002
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00031590461730957
(297) DESCRIBE `ports` 0.0013201236724854
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00028300285339355
(299) DESCRIBE `ports` 0.0012590885162354
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0003361701965332
(301) DESCRIBE `ports` 0.001284122467041
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00027298927307129
(303) DESCRIBE `ports` 0.0013298988342285
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034189224243164
(305) DESCRIBE `ports` 0.0015559196472168
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002129077911377
(307) DESCRIBE `avid_specials` 0.0012340545654297
(308) 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.0010240077972412
(309) DESCRIBE `cruiselines` 0.0020411014556885
(310) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00041103363037109
(311) DESCRIBE `orchid_image` 0.0016400814056396
(312) DESCRIBE `cruiselines` 0.0022270679473877
(313) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00040388107299805
(314) DESCRIBE `cruises` 0.0029268264770508
(315) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70948') 0.00034999847412109
(316) DESCRIBE `ships` 0.0029311180114746
(317) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00041508674621582
(318) DESCRIBE `ships` 0.0026538372039795
(319) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00085687637329102
(320) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0
(321) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003211498260498
(322) DESCRIBE `itineraries` 0.0012519359588623
(323) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70948') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0
(324) DESCRIBE `ports` 0.0016679763793945
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037813186645508
(326) DESCRIBE `ports` 0.0014848709106445
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032687187194824
(328) DESCRIBE `ports` 0.0014009475708008
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00032401084899902
(330) DESCRIBE `sailingdates` 0.0012640953063965
(331) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70948') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00059819221496582
(332) DESCRIBE `ports` 0.001474142074585
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032997131347656
(334) DESCRIBE `ports` 0.0013248920440674
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029206275939941
(336) DESCRIBE `ports` 0.0012998580932617
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4208))) 0.00032210350036621
(338) DESCRIBE `ports` 0.0012807846069336
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4208') 0.00028800964355469
(340) DESCRIBE `ports` 0.0012879371643066
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00043821334838867
(342) DESCRIBE `ports` 0.0013201236724854
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00028705596923828
(344) DESCRIBE `ports` 0.0012791156768799
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2751))) 0.0003199577331543
(346) DESCRIBE `ports` 0.0016310214996338
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2751') 0.00094795227050781
(348) DESCRIBE `ports` 0.0010309219360352
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 734))) 0
(350) DESCRIBE `ports` 0.0017850399017334
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '734') 0.00032496452331543
(352) DESCRIBE `ports` 0.00072288513183594
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00031113624572754
(354) DESCRIBE `ports` 0.0013649463653564
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00015592575073242
(356) DESCRIBE `ports` 0.0018219947814941
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00096797943115234
(358) DESCRIBE `ports` 0.0016820430755615
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038504600524902
(360) DESCRIBE `avid_specials` 0.0009768009185791
(361) 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.0023050308227539
(362) DESCRIBE `cruiselines` 0.0019850730895996
(363) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00095200538635254
(364) DESCRIBE `orchid_image` 0.0017011165618896
(365) DESCRIBE `cruiselines` 0.0019049644470215
(366) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00032591819763184
(367) DESCRIBE `cruises` 0.0025269985198975
(368) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65891') 0.0003349781036377
(369) DESCRIBE `ships` 0.0025398731231689
(370) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00039887428283691
(371) DESCRIBE `ships` 0.0027248859405518
(372) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00032711029052734
(373) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026488304138184
(374) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002591609954834
(375) DESCRIBE `itineraries` 0.001431941986084
(376) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65891') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00066590309143066
(377) DESCRIBE `ports` 0.0016889572143555
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034117698669434
(379) DESCRIBE `ports` 0.0012788772583008
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030303001403809
(381) DESCRIBE `ports` 0.0013589859008789
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030398368835449
(383) DESCRIBE `sailingdates` 0.0013210773468018
(384) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65891') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0006859302520752
(385) DESCRIBE `ports` 0.0019240379333496
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042295455932617
(387) DESCRIBE `ports` 0.0016269683837891
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034284591674805
(389) DESCRIBE `ports` 0.0015609264373779
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00038909912109375
(391) DESCRIBE `ports` 0.0014951229095459
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00034594535827637
(393) DESCRIBE `ports` 0.001413106918335
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00033712387084961
(395) DESCRIBE `ports` 0.0013160705566406
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0
(397) DESCRIBE `ports` 0.0012068748474121
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030994415283203
(399) DESCRIBE `ports` 0.0017719268798828
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00035405158996582
(401) DESCRIBE `avid_specials` 0.0011308193206787
(402) 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.0015041828155518
(403) DESCRIBE `cruiselines` 0.0016839504241943
(404) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00035881996154785
(405) DESCRIBE `orchid_image` 0.0015249252319336
(406) DESCRIBE `cruiselines` 0.0020179748535156
(407) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00034594535827637
(408) DESCRIBE `cruises` 0.0035090446472168
(409) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50866') 0.0011889934539795
(410) DESCRIBE `ships` 0.0027949810028076
(411) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00030899047851562
(412) DESCRIBE `ships` 0.0031778812408447
(413) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00038599967956543
(414) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027108192443848
(415) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027918815612793
(416) DESCRIBE `itineraries` 0.0016579627990723
(417) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '50866') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00060081481933594
(418) DESCRIBE `ports` 0.00076198577880859
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034904479980469
(420) DESCRIBE `ports` 0.001298189163208
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0
(422) DESCRIBE `ports` 0.0012650489807129
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029802322387695
(424) DESCRIBE `sailingdates` 0.001561164855957
(425) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '50866') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00059604644775391
(426) DESCRIBE `ports` 0.0015888214111328
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039291381835938
(428) DESCRIBE `ports` 0.0013861656188965
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0
(430) DESCRIBE `ports` 0.0011520385742188
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00037693977355957
(432) DESCRIBE `ports` 0.0016498565673828
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00029516220092773
(434) DESCRIBE `ports` 0.002032995223999
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 7.4148178100586E-5
(436) DESCRIBE `ports` 0.0013809204101562
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00030398368835449
(438) DESCRIBE `ports` 0.0012681484222412
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0
(440) DESCRIBE `ports` 0.001413106918335
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00028896331787109
(442) DESCRIBE `ports` 0.0016040802001953
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032615661621094
(444) DESCRIBE `ports` 0.0012941360473633
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0011241436004639
(446) DESCRIBE `avid_specials` 0.00063800811767578
(447) 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.0011270046234131
(448) DESCRIBE `cruiselines` 0.0021679401397705
(449) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00037002563476562
(450) DESCRIBE `orchid_image` 0.0017039775848389
(451) DESCRIBE `cruiselines` 0.0018229484558105
(452) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0
(453) DESCRIBE `ships` 0.0032649040222168
(454) SELECT `ships`.* FROM `ships` WHERE (id IN ('4', '1722')) ORDER BY FIND_IN_SET(id, '4,1722') 0.00070691108703613
(455) DESCRIBE `cruisetypes` 0.0012068748474121
(456) DESCRIBE `destinations` 0.0017781257629395
(457) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.00051093101501465
(458) DESCRIBE `cruiselines` 0.0019450187683105
(459) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00036191940307617
(460) DESCRIBE `cruiselines` 0.0023140907287598
(461) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0004727840423584