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

Total elapsed time: 0.99611973762512

# Query Time
(1) connect 0.0017650127410889
(2) DESCRIBE `cruises` 0.0063650608062744
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (80643, 80644, 80576, 61570, 80577, 57752, 56235, 80578, 77978, 77979)) ORDER BY FIND_IN_SET(id, '80643,80644,80576,61570,80577,57752,56235,80578,77978,77979') 0.003040075302124
(4) DESCRIBE `cruises` 0.0050148963928223
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80643') 0.00079703330993652
(6) DESCRIBE `ships` 0.0056970119476318
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1730))) 0.00077199935913086
(8) DESCRIBE `ships` 0.0048182010650635
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1730') 0.00049281120300293
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00046086311340332
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00048303604125977
(12) DESCRIBE `itineraries` 0.0027749538421631
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '80643') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011270046234131
(14) DESCRIBE `ports` 0.0027170181274414
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0006568431854248
(16) DESCRIBE `ports` 0.0024640560150146
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00068998336791992
(18) DESCRIBE `ports` 0.0025091171264648
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00061297416687012
(20) DESCRIBE `sailingdates` 0.0021350383758545
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '80643') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010929107666016
(22) DESCRIBE `ports` 0.0028548240661621
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00067877769470215
(24) DESCRIBE `ports` 0.0024430751800537
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00052094459533691
(26) DESCRIBE `ports` 0.0022251605987549
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0005040168762207
(28) DESCRIBE `ports` 0.0022869110107422
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00053691864013672
(30) DESCRIBE `ports` 0.0024399757385254
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00065898895263672
(32) DESCRIBE `ports` 0.0027070045471191
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00066113471984863
(34) DESCRIBE `ports` 0.0026631355285645
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00051093101501465
(36) DESCRIBE `ports` 0.0024428367614746
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00068807601928711
(38) DESCRIBE `ports` 0.0030479431152344
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00069594383239746
(40) DESCRIBE `ports` 0.0048518180847168
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00091695785522461
(42) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80643') AND (sailingdate >= '2019-11-27') 0.01320481300354
(43) DESCRIBE `avid_specials` 0.0028669834136963
(44) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80643 and class = 'Cruise') OR (item_id = 1730 AND class = 'Ship') OR (item_id = 187 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.0023908615112305
(45) DESCRIBE `cruiselines` 0.0050539970397949
(46) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00082015991210938
(47) DESCRIBE `orchid_image` 0.0036571025848389
(48) DESCRIBE `cruiselines` 0.004101037979126
(49) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00065398216247559
(50) DESCRIBE `cruises` 0.0061769485473633
(51) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80644') 0.00068807601928711
(52) DESCRIBE `ships` 0.0052440166473389
(53) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1730))) 0.0007939338684082
(54) DESCRIBE `ships` 0.0051028728485107
(55) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1730') 0.00068187713623047
(56) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0004880428314209
(57) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00046992301940918
(58) DESCRIBE `itineraries` 0.0028610229492188
(59) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '80644') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0009770393371582
(60) DESCRIBE `ports` 0.0033478736877441
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00089502334594727
(62) DESCRIBE `ports` 0.0026710033416748
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00075292587280273
(64) DESCRIBE `ports` 0.0028181076049805
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00064802169799805
(66) DESCRIBE `sailingdates` 0.002493143081665
(67) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '80644') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0013210773468018
(68) DESCRIBE `ports` 0.0029940605163574
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00064992904663086
(70) DESCRIBE `ports` 0.0025150775909424
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00061917304992676
(72) DESCRIBE `ports` 0.002479076385498
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00073385238647461
(74) DESCRIBE `ports` 0.0024828910827637
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00059795379638672
(76) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80644') AND (sailingdate >= '2019-11-27') 0.010710954666138
(77) DESCRIBE `avid_specials` 0.0025629997253418
(78) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80644 and class = 'Cruise') OR (item_id = 1730 AND class = 'Ship') OR (item_id = 187 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.0021798610687256
(79) DESCRIBE `cruiselines` 0.0036249160766602
(80) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00071382522583008
(81) DESCRIBE `orchid_image` 0.0028510093688965
(82) DESCRIBE `cruiselines` 0.004234790802002
(83) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00058913230895996
(84) DESCRIBE `cruises` 0.0042431354522705
(85) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80576') 0.00071811676025391
(86) DESCRIBE `ships` 0.005795955657959
(87) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1730))) 0.00090503692626953
(88) DESCRIBE `ships` 0.0046260356903076
(89) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1730') 0.00058317184448242
(90) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00056695938110352
(91) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00051498413085938
(92) DESCRIBE `itineraries` 0.0027861595153809
(93) DESCRIBE `ports` 0.0033822059631348
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00081396102905273
(95) DESCRIBE `ports` 0.0033071041107178
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00092506408691406
(97) DESCRIBE `ports` 0.0031070709228516
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00071406364440918
(99) DESCRIBE `sailingdates` 0.0024299621582031
(100) DESCRIBE `ports` 0.0026490688323975
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0006260871887207
(102) DESCRIBE `ports` 0.0020937919616699
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00054407119750977
(104) DESCRIBE `ports` 0.002640962600708
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00063586235046387
(106) DESCRIBE `ports` 0.0026130676269531
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.0005648136138916
(108) DESCRIBE `ports` 0.0027370452880859
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00074410438537598
(110) DESCRIBE `ports` 0.0025410652160645
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00060796737670898
(112) DESCRIBE `ports` 0.0024220943450928
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00063800811767578
(114) DESCRIBE `ports` 0.0035121440887451
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00080585479736328
(116) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80576') AND (sailingdate >= '2019-11-27') 0.0099101066589355
(117) DESCRIBE `avid_specials` 0.0028128623962402
(118) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80576 and class = 'Cruise') OR (item_id = 1730 AND class = 'Ship') OR (item_id = 187 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.0023479461669922
(119) DESCRIBE `cruiselines` 0.0043458938598633
(120) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.0007631778717041
(121) DESCRIBE `orchid_image` 0.0031008720397949
(122) DESCRIBE `cruiselines` 0.0034308433532715
(123) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00067591667175293
(124) DESCRIBE `cruises` 0.0051050186157227
(125) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61570') 0.00055289268493652
(126) DESCRIBE `ships` 0.0058920383453369
(127) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1454))) 0.0010650157928467
(128) DESCRIBE `ships` 0.0056660175323486
(129) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1454') 0.00085186958312988
(130) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00054287910461426
(131) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00046014785766602
(132) DESCRIBE `itineraries` 0.002730131149292
(133) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '61570') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0020699501037598
(134) DESCRIBE `ports` 0.0028419494628906
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0010218620300293
(136) DESCRIBE `ports` 0.0033218860626221
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0008690357208252
(138) DESCRIBE `ports` 0.0026330947875977
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00056314468383789
(140) DESCRIBE `sailingdates` 0.0036330223083496
(141) DESCRIBE `ports` 0.0044348239898682
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00085687637329102
(143) DESCRIBE `ports` 0.0033409595489502
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00069499015808105
(145) DESCRIBE `ports` 0.0028312206268311
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00084090232849121
(147) DESCRIBE `ports` 0.0028820037841797
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00065994262695312
(149) DESCRIBE `ports` 0.0030701160430908
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00074005126953125
(151) DESCRIBE `ports` 0.0026149749755859
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00062704086303711
(153) DESCRIBE `ports` 0.002540111541748
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00062704086303711
(155) DESCRIBE `ports` 0.0025429725646973
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00055694580078125
(157) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '61570') AND (sailingdate >= '2019-11-27') 0.010029077529907
(158) DESCRIBE `avid_specials` 0.0024590492248535
(159) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61570 and class = 'Cruise') OR (item_id = 1454 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 21 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.0021181106567383
(160) DESCRIBE `cruiselines` 0.0037491321563721
(161) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00077605247497559
(162) DESCRIBE `orchid_image` 0.0033378601074219
(163) DESCRIBE `cruiselines` 0.0044410228729248
(164) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00095200538635254
(165) DESCRIBE `cruises` 0.0048859119415283
(166) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80577') 0.00068402290344238
(167) DESCRIBE `ships` 0.0045139789581299
(168) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1730))) 0.0008549690246582
(169) DESCRIBE `ships` 0.0047221183776855
(170) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1730') 0.00047588348388672
(171) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00036096572875977
(172) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00044488906860352
(173) DESCRIBE `itineraries` 0.0023488998413086
(174) DESCRIBE `ports` 0.0021731853485107
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00049901008605957
(176) DESCRIBE `ports` 0.0021548271179199
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00050997734069824
(178) DESCRIBE `ports` 0.0028798580169678
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00064301490783691
(180) DESCRIBE `sailingdates` 0.0042080879211426
(181) DESCRIBE `ports` 0.0025079250335693
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00074005126953125
(183) DESCRIBE `ports` 0.0031628608703613
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00066304206848145
(185) DESCRIBE `ports` 0.0028469562530518
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6035))) 0.00069689750671387
(187) DESCRIBE `ports` 0.0027728080749512
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6035') 0.00065088272094727
(189) DESCRIBE `ports` 0.0029950141906738
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3395))) 0.00071620941162109
(191) DESCRIBE `ports` 0.0029540061950684
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3395') 0.00060510635375977
(193) DESCRIBE `ports` 0.0023910999298096
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00064206123352051
(195) DESCRIBE `ports` 0.002910852432251
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00076699256896973
(197) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80577') AND (sailingdate >= '2019-11-27') 0.0099267959594727
(198) DESCRIBE `avid_specials` 0.0023341178894043
(199) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80577 and class = 'Cruise') OR (item_id = 1730 AND class = 'Ship') OR (item_id = 187 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.0021438598632812
(200) DESCRIBE `cruiselines` 0.00394606590271
(201) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00096797943115234
(202) DESCRIBE `orchid_image` 0.0035679340362549
(203) DESCRIBE `cruiselines` 0.0039708614349365
(204) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00066900253295898
(205) DESCRIBE `cruises` 0.0047779083251953
(206) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57752') 0.00069999694824219
(207) DESCRIBE `ships` 0.0053870677947998
(208) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 818))) 0.00092291831970215
(209) DESCRIBE `ships` 0.0063509941101074
(210) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '818') 0.00075316429138184
(211) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00048208236694336
(212) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00046110153198242
(213) DESCRIBE `itineraries` 0.0028319358825684
(214) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '57752') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0023660659790039
(215) DESCRIBE `ports` 0.0030789375305176
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3269))) 0.0011091232299805
(217) DESCRIBE `ports` 0.0046439170837402
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3269))) 0.00069093704223633
(219) DESCRIBE `ports` 0.0028879642486572
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3269') 0.00061893463134766
(221) DESCRIBE `sailingdates` 0.0024769306182861
(222) DESCRIBE `ports` 0.0026700496673584
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3269))) 0.0005650520324707
(224) DESCRIBE `ports` 0.0024840831756592
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3269') 0.00056004524230957
(226) DESCRIBE `ports` 0.0027468204498291
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00061917304992676
(228) DESCRIBE `ports` 0.0027518272399902
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00071191787719727
(230) DESCRIBE `ports` 0.0029001235961914
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00069379806518555
(232) DESCRIBE `ports` 0.0029520988464355
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00059413909912109
(234) DESCRIBE `ports` 0.0026919841766357
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.0006721019744873
(236) DESCRIBE `ports` 0.0024869441986084
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00081419944763184
(238) DESCRIBE `ports` 0.0026741027832031
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3269))) 0.00059700012207031
(240) DESCRIBE `ports` 0.0028481483459473
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3269') 0.00061178207397461
(242) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '57752') AND (sailingdate >= '2019-11-27') 0.0067899227142334
(243) DESCRIBE `avid_specials` 0.0023150444030762
(244) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57752 and class = 'Cruise') OR (item_id = 818 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 21 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.0013570785522461
(245) DESCRIBE `cruiselines` 0.0035469532012939
(246) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00077104568481445
(247) DESCRIBE `orchid_image` 0.0031609535217285
(248) DESCRIBE `cruiselines` 0.0043520927429199
(249) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00066399574279785
(250) DESCRIBE `cruises` 0.0058388710021973
(251) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56235') 0.00075888633728027
(252) DESCRIBE `ships` 0.006007194519043
(253) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1308))) 0.00089406967163086
(254) DESCRIBE `ships` 0.0051729679107666
(255) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1308') 0.00068092346191406
(256) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00047707557678223
(257) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00047588348388672
(258) DESCRIBE `itineraries` 0.0025990009307861
(259) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '56235') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011188983917236
(260) DESCRIBE `ports` 0.0027470588684082
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00067996978759766
(262) DESCRIBE `ports` 0.0026237964630127
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00061488151550293
(264) DESCRIBE `ports` 0.0027039051055908
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00063204765319824
(266) DESCRIBE `sailingdates` 0.0021939277648926
(267) DESCRIBE `ports` 0.0024509429931641
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00057601928710938
(269) DESCRIBE `ports` 0.0022389888763428
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00054097175598145
(271) DESCRIBE `ports` 0.0026209354400635
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.0006561279296875
(273) DESCRIBE `ports` 0.0029048919677734
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00059413909912109
(275) DESCRIBE `ports` 0.0027170181274414
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00062799453735352
(277) DESCRIBE `ports` 0.0026030540466309
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00066184997558594
(279) DESCRIBE `ports` 0.0023400783538818
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.00054097175598145
(281) DESCRIBE `ports` 0.0022249221801758
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.00052380561828613
(283) DESCRIBE `ports` 0.0019619464874268
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0004880428314209
(285) DESCRIBE `ports` 0.002363920211792
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00059604644775391
(287) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '56235') AND (sailingdate >= '2019-11-27') 0.0085179805755615
(288) DESCRIBE `avid_specials` 0.0026891231536865
(289) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56235 and class = 'Cruise') OR (item_id = 1308 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 21 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.0022268295288086
(290) DESCRIBE `cruiselines` 0.0036220550537109
(291) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00069522857666016
(292) DESCRIBE `orchid_image` 0.0027730464935303
(293) DESCRIBE `cruiselines` 0.0036342144012451
(294) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00054407119750977
(295) DESCRIBE `cruises` 0.0045650005340576
(296) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80578') 0.00057196617126465
(297) DESCRIBE `ships` 0.0041301250457764
(298) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1730))) 0.00068092346191406
(299) DESCRIBE `ships` 0.0046460628509521
(300) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1730') 0.00061607360839844
(301) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00039911270141602
(302) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00046181678771973
(303) DESCRIBE `itineraries` 0.0019600391387939
(304) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '80578') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00074315071105957
(305) DESCRIBE `ports` 0.0021369457244873
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00049400329589844
(307) DESCRIBE `ports` 0.0019340515136719
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00044393539428711
(309) DESCRIBE `ports` 0.0021331310272217
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00041580200195312
(311) DESCRIBE `sailingdates` 0.0017399787902832
(312) DESCRIBE `ports` 0.0020389556884766
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00047016143798828
(314) DESCRIBE `ports` 0.0020740032196045
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00042891502380371
(316) DESCRIBE `ports` 0.0021710395812988
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00059390068054199
(318) DESCRIBE `ports` 0.0024809837341309
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00071501731872559
(320) DESCRIBE `ports` 0.0030629634857178
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00071406364440918
(322) DESCRIBE `ports` 0.0028579235076904
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00058293342590332
(324) DESCRIBE `ports` 0.0026428699493408
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.0010020732879639
(326) DESCRIBE `ports` 0.0029160976409912
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.0007941722869873
(328) DESCRIBE `ports` 0.0024349689483643
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00062704086303711
(330) DESCRIBE `ports` 0.0025608539581299
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00043702125549316
(332) DESCRIBE `ports` 0.0019230842590332
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00054383277893066
(334) DESCRIBE `ports` 0.0022079944610596
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00043606758117676
(336) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80578') AND (sailingdate >= '2019-11-27') 0.0055530071258545
(337) DESCRIBE `avid_specials` 0.0028538703918457
(338) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80578 and class = 'Cruise') OR (item_id = 1730 AND class = 'Ship') OR (item_id = 187 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.0022399425506592
(339) DESCRIBE `cruiselines` 0.0034768581390381
(340) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00067496299743652
(341) DESCRIBE `orchid_image` 0.0027689933776855
(342) DESCRIBE `cruiselines` 0.0034248828887939
(343) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00057101249694824
(344) DESCRIBE `cruises` 0.0044729709625244
(345) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77978') 0.00048613548278809
(346) DESCRIBE `ships` 0.0038559436798096
(347) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1454))) 0.00081586837768555
(348) DESCRIBE `ships` 0.0036449432373047
(349) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1454') 0.00056886672973633
(350) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00036716461181641
(351) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00043892860412598
(352) DESCRIBE `itineraries` 0.001978874206543
(353) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '77978') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0009000301361084
(354) DESCRIBE `ports` 0.0025238990783691
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00065088272094727
(356) DESCRIBE `ports` 0.0022227764129639
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0007171630859375
(358) DESCRIBE `ports` 0.0028390884399414
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00052595138549805
(360) DESCRIBE `sailingdates` 0.0021798610687256
(361) DESCRIBE `ports` 0.0026381015777588
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0005190372467041
(363) DESCRIBE `ports` 0.0020918846130371
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00049495697021484
(365) DESCRIBE `ports` 0.0021121501922607
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1526))) 0.00048089027404785
(367) DESCRIBE `ports` 0.0025701522827148
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1526') 0.00059294700622559
(369) DESCRIBE `ports` 0.0030109882354736
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00075507164001465
(371) DESCRIBE `ports` 0.003000020980835
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00067806243896484
(373) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '77978') AND (sailingdate >= '2019-11-27') 0.01031494140625
(374) DESCRIBE `avid_specials` 0.0028018951416016
(375) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77978 and class = 'Cruise') OR (item_id = 1454 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 21 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.0023620128631592
(376) DESCRIBE `cruiselines` 0.0041079521179199
(377) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00075697898864746
(378) DESCRIBE `orchid_image` 0.0032789707183838
(379) DESCRIBE `cruiselines` 0.0034699440002441
(380) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00070786476135254
(381) DESCRIBE `cruises` 0.0049788951873779
(382) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77979') 0.00063395500183105
(383) DESCRIBE `ships` 0.004770040512085
(384) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1454))) 0.00098919868469238
(385) DESCRIBE `ships` 0.0052001476287842
(386) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1454') 0.00071310997009277
(387) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00047922134399414
(388) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00047087669372559
(389) DESCRIBE `itineraries` 0.0025961399078369
(390) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '77979') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012049674987793
(391) DESCRIBE `ports` 0.0119948387146
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.0010650157928467
(393) DESCRIBE `ports` 0.0029280185699463
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00083017349243164
(395) DESCRIBE `ports` 0.0029199123382568
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00063204765319824
(397) DESCRIBE `sailingdates` 0.0025269985198975
(398) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '77979') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0013079643249512
(399) DESCRIBE `ports` 0.002964973449707
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00076985359191895
(401) DESCRIBE `ports` 0.0021300315856934
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00054502487182617
(403) DESCRIBE `ports` 0.0020649433135986
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.0011119842529297
(405) DESCRIBE `ports` 0.0022010803222656
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.0005040168762207
(407) DESCRIBE `ports` 0.002025842666626
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00059199333190918
(409) DESCRIBE `ports` 0.002493143081665
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00059199333190918
(411) DESCRIBE `ports` 0.0029339790344238
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1526))) 0.00073599815368652
(413) DESCRIBE `ports` 0.0025961399078369
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1526') 0.00057697296142578
(415) DESCRIBE `ports` 0.0025811195373535
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00061607360839844
(417) DESCRIBE `ports` 0.0026381015777588
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00059008598327637
(419) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '77979') AND (sailingdate >= '2019-11-27') 0.009537935256958
(420) DESCRIBE `avid_specials` 0.0025911331176758
(421) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77979 and class = 'Cruise') OR (item_id = 1454 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 21 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.0022819042205811
(422) DESCRIBE `cruiselines` 0.0037961006164551
(423) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00073790550231934
(424) DESCRIBE `orchid_image` 0.0029311180114746
(425) DESCRIBE `cruiselines` 0.0045609474182129
(426) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00072789192199707
(427) DESCRIBE `ships` 0.0059921741485596
(428) SELECT `ships`.* FROM `ships` WHERE (id IN ('1454', '1308', '818', '1730', '1479')) ORDER BY FIND_IN_SET(id, '1454,1308,818,1730,1479') 0.0020239353179932
(429) DESCRIBE `cruisetypes` 0.0023400783538818
(430) 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 = '187') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.044723033905029
(431) DESCRIBE `destinations` 0.0045158863067627
(432) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('40', '21', '28', '8', '25', '26', '49', '35', '30', '55')) ORDER BY FIND_IN_SET(id, '40,21,28,8,25,26,49,35,30,55') 0.0033869743347168
(433) DESCRIBE `cruiselines` 0.0043509006500244
(434) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00084185600280762
(435) DESCRIBE `cruiselines` 0.0045819282531738
(436) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00093388557434082