or, enquire about your chosen options

  1. Carnival Cruise Line teams up with Harlem Globetrotters
  2. Ultra-Luxury Cruising
  3. The Caribbean is still a Preferred Cruise Destination
  4. Catch Up on Cruising: Latest News in bite size!
  5. 8 Romantic Destinations Around the World

Sign up to our newsletter and become the first to know about our latest deals and promotions

 
 

Please note, while cruise details and inclusions are accurate at time of loading they are subject to change due to changes in cruise line practices and policies. Please check details and inclusions at time of booking.

Database Profiling Report

Total queries executed: 446

Total elapsed time: 0.92466807365417

# Query Time
(1) connect 0.0015218257904053
(2) DESCRIBE `cruises` 0.0045480728149414
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (50857, 55703, 70947, 70948, 41776, 65891, 41778, 50866, 63373, 55702)) ORDER BY FIND_IN_SET(id, '50857,55703,70947,70948,41776,65891,41778,50866,63373,55702') 0.0025830268859863
(4) DESCRIBE `cruises` 0.0055270195007324
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50857') 0.00038003921508789
(6) DESCRIBE `ships` 0.0040528774261475
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00064301490783691
(8) DESCRIBE `ships` 0.0052070617675781
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00055289268493652
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00050902366638184
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00050902366638184
(12) DESCRIBE `itineraries` 0.0028929710388184
(13) DESCRIBE `ports` 0.0033919811248779
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00055694580078125
(15) DESCRIBE `ports` 0.0027401447296143
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00061988830566406
(17) DESCRIBE `ports` 0.0027391910552979
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00053715705871582
(19) DESCRIBE `sailingdates` 0.002485990524292
(20) DESCRIBE `ports` 0.0028440952301025
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00055694580078125
(22) DESCRIBE `ports` 0.0027909278869629
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00054097175598145
(24) DESCRIBE `ports` 0.0029120445251465
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00044393539428711
(26) DESCRIBE `ports` 0.0020270347595215
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00047087669372559
(28) DESCRIBE `ports` 0.0018839836120605
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00040006637573242
(30) DESCRIBE `ports` 0.0022108554840088
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00043201446533203
(32) DESCRIBE `ports` 0.0019359588623047
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00041890144348145
(34) DESCRIBE `ports` 0.0018370151519775
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00036001205444336
(36) DESCRIBE `ports` 0.0017919540405273
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00053882598876953
(38) DESCRIBE `ports` 0.0020289421081543
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00045299530029297
(40) DESCRIBE `ports` 0.0020129680633545
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040888786315918
(42) DESCRIBE `ports` 0.0028450489044189
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00065994262695312
(44) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '50857') AND (sailingdate >= '2019-08-26') AND (sailingdate <= '2019-12-06') 0.009843111038208
(45) DESCRIBE `avid_specials` 0.0019550323486328
(46) 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.0025231838226318
(47) DESCRIBE `cruiselines` 0.0028378963470459
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00049781799316406
(49) DESCRIBE `orchid_image` 0.0024111270904541
(50) DESCRIBE `cruiselines` 0.0031919479370117
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00036811828613281
(52) DESCRIBE `cruises` 0.0036778450012207
(53) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55703') 0.0004889965057373
(54) DESCRIBE `ships` 0.0043869018554688
(55) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00067710876464844
(56) DESCRIBE `ships` 0.0047328472137451
(57) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00046706199645996
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00060606002807617
(59) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00048303604125977
(60) DESCRIBE `itineraries` 0.0028600692749023
(61) DESCRIBE `ports` 0.0019919872283936
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044012069702148
(63) DESCRIBE `ports` 0.002810001373291
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00054597854614258
(65) DESCRIBE `ports` 0.0027740001678467
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00057101249694824
(67) DESCRIBE `sailingdates` 0.0022008419036865
(68) DESCRIBE `ports` 0.0026249885559082
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040912628173828
(70) DESCRIBE `ports` 0.0018839836120605
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039911270141602
(72) DESCRIBE `ports` 0.0024170875549316
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00067710876464844
(74) DESCRIBE `ports` 0.0031189918518066
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00060009956359863
(76) DESCRIBE `ports` 0.0035660266876221
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00063896179199219
(78) DESCRIBE `ports` 0.003220796585083
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00054693222045898
(80) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '55703') AND (sailingdate >= '2019-08-26') AND (sailingdate <= '2019-12-06') 0.0069220066070557
(81) DESCRIBE `avid_specials` 0.0026140213012695
(82) 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.0018939971923828
(83) DESCRIBE `cruiselines` 0.0036070346832275
(84) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00055599212646484
(85) DESCRIBE `orchid_image` 0.0037479400634766
(86) DESCRIBE `cruiselines` 0.0045058727264404
(87) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00047111511230469
(88) DESCRIBE `cruises` 0.0045640468597412
(89) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70947') 0.00041890144348145
(90) DESCRIBE `ships` 0.0049099922180176
(91) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00063800811767578
(92) DESCRIBE `ships` 0.0052530765533447
(93) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00052404403686523
(94) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00046896934509277
(95) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00046300888061523
(96) DESCRIBE `itineraries` 0.0024280548095703
(97) DESCRIBE `ports` 0.0026140213012695
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00063896179199219
(99) DESCRIBE `ports` 0.002640962600708
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00064301490783691
(101) DESCRIBE `ports` 0.0030927658081055
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00054597854614258
(103) DESCRIBE `sailingdates` 0.0025370121002197
(104) DESCRIBE `ports` 0.0030760765075684
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00057101249694824
(106) DESCRIBE `ports` 0.0031759738922119
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00049686431884766
(108) DESCRIBE `ports` 0.0025899410247803
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00054788589477539
(110) DESCRIBE `ports` 0.0023341178894043
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00063395500183105
(112) DESCRIBE `ports` 0.0031991004943848
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00066184997558594
(114) DESCRIBE `ports` 0.0021679401397705
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00050592422485352
(116) DESCRIBE `ports` 0.002161979675293
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00065088272094727
(118) DESCRIBE `ports` 0.0027868747711182
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00061511993408203
(120) DESCRIBE `ports` 0.0028579235076904
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00068783760070801
(122) DESCRIBE `ports` 0.0028200149536133
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00060009956359863
(124) DESCRIBE `ports` 0.0032989978790283
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00066208839416504
(126) DESCRIBE `ports` 0.0024151802062988
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00063204765319824
(128) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '70947') AND (sailingdate >= '2019-08-26') AND (sailingdate <= '2019-12-06') 0.0105299949646
(129) DESCRIBE `avid_specials` 0.0034301280975342
(130) 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.0024290084838867
(131) DESCRIBE `cruiselines` 0.0047879219055176
(132) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0007469654083252
(133) DESCRIBE `orchid_image` 0.003709077835083
(134) DESCRIBE `cruiselines` 0.0045650005340576
(135) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0007178783416748
(136) DESCRIBE `cruises` 0.0063178539276123
(137) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70948') 0.00056099891662598
(138) DESCRIBE `ships` 0.0060300827026367
(139) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00064682960510254
(140) DESCRIBE `ships` 0.0051789283752441
(141) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00060296058654785
(142) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00051116943359375
(143) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00047612190246582
(144) DESCRIBE `itineraries` 0.0028080940246582
(145) DESCRIBE `ports` 0.0027148723602295
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00063204765319824
(147) DESCRIBE `ports` 0.0024580955505371
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043201446533203
(149) DESCRIBE `ports` 0.0033049583435059
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00065302848815918
(151) DESCRIBE `sailingdates` 0.002331018447876
(152) DESCRIBE `ports` 0.0029191970825195
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00060009956359863
(154) DESCRIBE `ports` 0.0019819736480713
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00053095817565918
(156) DESCRIBE `ports` 0.0020678043365479
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4208))) 0.00053787231445312
(158) DESCRIBE `ports` 0.0026900768280029
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4208') 0.00046896934509277
(160) DESCRIBE `ports` 0.0022358894348145
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.000579833984375
(162) DESCRIBE `ports` 0.0029160976409912
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00061488151550293
(164) DESCRIBE `ports` 0.0029568672180176
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2751))) 0.00071001052856445
(166) DESCRIBE `ports` 0.0025599002838135
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2751') 0.0005948543548584
(168) DESCRIBE `ports` 0.0027518272399902
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 734))) 0.00076389312744141
(170) DESCRIBE `ports` 0.0027990341186523
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '734') 0.00060391426086426
(172) DESCRIBE `ports` 0.0030171871185303
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00070500373840332
(174) DESCRIBE `ports` 0.002601146697998
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.0005500316619873
(176) DESCRIBE `ports` 0.0025460720062256
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00051403045654297
(178) DESCRIBE `ports` 0.0026681423187256
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0006108283996582
(180) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '70948') AND (sailingdate >= '2019-08-26') AND (sailingdate <= '2019-12-06') 0.0089459419250488
(181) DESCRIBE `avid_specials` 0.0022819042205811
(182) 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.002396821975708
(183) DESCRIBE `cruiselines` 0.0038321018218994
(184) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00059700012207031
(185) DESCRIBE `orchid_image` 0.0029149055480957
(186) DESCRIBE `cruiselines` 0.0038390159606934
(187) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00052905082702637
(188) DESCRIBE `cruises` 0.0058848857879639
(189) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41776') 0.00090503692626953
(190) DESCRIBE `ships` 0.005544900894165
(191) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00072383880615234
(192) DESCRIBE `ships` 0.0051219463348389
(193) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00058794021606445
(194) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00050187110900879
(195) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00054597854614258
(196) DESCRIBE `itineraries` 0.0026509761810303
(197) DESCRIBE `ports` 0.0029120445251465
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00074505805969238
(199) DESCRIBE `ports` 0.0032148361206055
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00082302093505859
(201) DESCRIBE `ports` 0.0032539367675781
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00049591064453125
(203) DESCRIBE `sailingdates` 0.0022978782653809
(204) DESCRIBE `ports` 0.0029969215393066
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00065112113952637
(206) DESCRIBE `ports` 0.0030760765075684
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00069499015808105
(208) DESCRIBE `ports` 0.0026900768280029
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0005180835723877
(210) DESCRIBE `ports` 0.0021951198577881
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00052118301391602
(212) DESCRIBE `ports` 0.0034329891204834
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00050592422485352
(214) DESCRIBE `ports` 0.0024261474609375
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00063800811767578
(216) DESCRIBE `ports` 0.0026910305023193
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00049018859863281
(218) DESCRIBE `ports` 0.0023889541625977
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.0005950927734375
(220) DESCRIBE `ports` 0.0025348663330078
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048685073852539
(222) DESCRIBE `ports` 0.002263069152832
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00047492980957031
(224) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '41776') AND (sailingdate >= '2019-08-26') AND (sailingdate <= '2019-12-06') 0.0080471038818359
(225) DESCRIBE `avid_specials` 0.0028510093688965
(226) 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.0015280246734619
(227) DESCRIBE `cruiselines` 0.0031149387359619
(228) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00055885314941406
(229) DESCRIBE `orchid_image` 0.0028331279754639
(230) DESCRIBE `cruiselines` 0.0035309791564941
(231) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00046491622924805
(232) DESCRIBE `cruises` 0.0038681030273438
(233) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65891') 0.00051403045654297
(234) DESCRIBE `ships` 0.004633903503418
(235) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00047397613525391
(236) DESCRIBE `ships` 0.0039858818054199
(237) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00053596496582031
(238) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0004880428314209
(239) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00051593780517578
(240) DESCRIBE `itineraries` 0.0030591487884521
(241) DESCRIBE `ports` 0.001945972442627
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045609474182129
(243) DESCRIBE `ports` 0.0019412040710449
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00050997734069824
(245) DESCRIBE `ports` 0.0021889209747314
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039911270141602
(247) DESCRIBE `sailingdates` 0.0017530918121338
(248) DESCRIBE `ports` 0.0024988651275635
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045108795166016
(250) DESCRIBE `ports` 0.0029480457305908
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040483474731445
(252) DESCRIBE `ports` 0.002147912979126
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00055289268493652
(254) DESCRIBE `ports` 0.0020811557769775
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00053691864013672
(256) DESCRIBE `ports` 0.0024740695953369
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.0005040168762207
(258) DESCRIBE `ports` 0.0018951892852783
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00044798851013184
(260) DESCRIBE `ports` 0.0026299953460693
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00062680244445801
(262) DESCRIBE `ports` 0.0034420490264893
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00071096420288086
(264) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '65891') AND (sailingdate >= '2019-08-26') AND (sailingdate <= '2019-12-06') 0.0084550380706787
(265) DESCRIBE `avid_specials` 0.0021350383758545
(266) 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.0022790431976318
(267) DESCRIBE `cruiselines` 0.003201961517334
(268) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00053715705871582
(269) DESCRIBE `orchid_image` 0.0031828880310059
(270) DESCRIBE `cruiselines` 0.0028491020202637
(271) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00037908554077148
(272) DESCRIBE `cruises` 0.0046191215515137
(273) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41778') 0.0005190372467041
(274) DESCRIBE `ships` 0.0039491653442383
(275) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00075817108154297
(276) DESCRIBE `ships` 0.0062351226806641
(277) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00065779685974121
(278) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00049877166748047
(279) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00040888786315918
(280) DESCRIBE `itineraries` 0.0025711059570312
(281) DESCRIBE `ports` 0.0024008750915527
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046014785766602
(283) DESCRIBE `ports` 0.0021450519561768
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00051999092102051
(285) DESCRIBE `ports` 0.002647876739502
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0006098747253418
(287) DESCRIBE `sailingdates` 0.0021750926971436
(288) DESCRIBE `ports` 0.0025811195373535
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00065994262695312
(290) DESCRIBE `ports` 0.002730131149292
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00051593780517578
(292) DESCRIBE `ports` 0.0032331943511963
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049996376037598
(294) DESCRIBE `ports` 0.0024409294128418
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040698051452637
(296) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '41778') AND (sailingdate >= '2019-08-26') AND (sailingdate <= '2019-12-06') 0.0089850425720215
(297) DESCRIBE `avid_specials` 0.0035750865936279
(298) 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.0024499893188477
(299) DESCRIBE `cruiselines` 0.0047779083251953
(300) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00058412551879883
(301) DESCRIBE `orchid_image` 0.0024220943450928
(302) DESCRIBE `cruiselines` 0.0036311149597168
(303) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00038886070251465
(304) DESCRIBE `cruises` 0.0046820640563965
(305) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50866') 0.00046300888061523
(306) DESCRIBE `ships` 0.004317045211792
(307) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00063991546630859
(308) DESCRIBE `ships` 0.0044350624084473
(309) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00054502487182617
(310) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00047898292541504
(311) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00044512748718262
(312) DESCRIBE `itineraries` 0.0021350383758545
(313) DESCRIBE `ports` 0.0020229816436768
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040793418884277
(315) DESCRIBE `ports` 0.001939058303833
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041699409484863
(317) DESCRIBE `ports` 0.0019831657409668
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043511390686035
(319) DESCRIBE `sailingdates` 0.0019280910491943
(320) DESCRIBE `ports` 0.0019500255584717
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00055885314941406
(322) DESCRIBE `ports` 0.0019009113311768
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040698051452637
(324) DESCRIBE `ports` 0.0023770332336426
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00051593780517578
(326) DESCRIBE `ports` 0.0026450157165527
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00057291984558105
(328) DESCRIBE `ports` 0.0033500194549561
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00061988830566406
(330) DESCRIBE `ports` 0.0035011768341064
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00054407119750977
(332) DESCRIBE `ports` 0.0035970211029053
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00085806846618652
(334) DESCRIBE `ports` 0.0036568641662598
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0006098747253418
(336) DESCRIBE `ports` 0.0029871463775635
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00079107284545898
(338) DESCRIBE `ports` 0.0036189556121826
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00057291984558105
(340) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '50866') AND (sailingdate >= '2019-08-26') AND (sailingdate <= '2019-12-06') 0.010155916213989
(341) DESCRIBE `avid_specials` 0.0024628639221191
(342) 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.0020630359649658
(343) DESCRIBE `cruiselines` 0.0044510364532471
(344) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00068998336791992
(345) DESCRIBE `orchid_image` 0.0033180713653564
(346) DESCRIBE `cruiselines` 0.0040230751037598
(347) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0005800724029541
(348) DESCRIBE `cruises` 0.0049729347229004
(349) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63373') 0.00062203407287598
(350) DESCRIBE `ships` 0.0052618980407715
(351) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00077414512634277
(352) DESCRIBE `ships` 0.0070400238037109
(353) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00069284439086914
(354) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00055885314941406
(355) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00053691864013672
(356) DESCRIBE `itineraries` 0.003119945526123
(357) DESCRIBE `ports` 0.0034091472625732
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00071501731872559
(359) DESCRIBE `ports` 0.0031700134277344
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00072598457336426
(361) DESCRIBE `ports` 0.0027658939361572
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00057315826416016
(363) DESCRIBE `sailingdates` 0.0033500194549561
(364) DESCRIBE `ports` 0.0032360553741455
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.000762939453125
(366) DESCRIBE `ports` 0.0029780864715576
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00054001808166504
(368) DESCRIBE `ports` 0.0029938220977783
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0005180835723877
(370) DESCRIBE `ports` 0.0020630359649658
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00040888786315918
(372) DESCRIBE `ports` 0.002161979675293
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00050997734069824
(374) DESCRIBE `ports` 0.0019738674163818
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00041508674621582
(376) DESCRIBE `ports` 0.013334035873413
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00049304962158203
(378) DESCRIBE `ports` 0.0020051002502441
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00040006637573242
(380) DESCRIBE `ports` 0.0018699169158936
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00053691864013672
(382) DESCRIBE `ports` 0.0018289089202881
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00041580200195312
(384) DESCRIBE `ports` 0.0023670196533203
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00047397613525391
(386) DESCRIBE `ports` 0.0020420551300049
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00047683715820312
(388) DESCRIBE `ports` 0.0025539398193359
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00060915946960449
(390) DESCRIBE `ports` 0.0019252300262451
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041413307189941
(392) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63373') AND (sailingdate >= '2019-08-26') AND (sailingdate <= '2019-12-06') 0.0065219402313232
(393) DESCRIBE `avid_specials` 0.0023729801177979
(394) 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.0012850761413574
(395) DESCRIBE `cruiselines` 0.0028529167175293
(396) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00053906440734863
(397) DESCRIBE `orchid_image` 0.0020480155944824
(398) DESCRIBE `cruiselines` 0.0028319358825684
(399) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00062084197998047
(400) DESCRIBE `cruises` 0.0051820278167725
(401) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55702') 0.00075912475585938
(402) DESCRIBE `ships` 0.0052599906921387
(403) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00078487396240234
(404) DESCRIBE `ships` 0.0048179626464844
(405) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00069117546081543
(406) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00056099891662598
(407) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00059103965759277
(408) DESCRIBE `itineraries` 0.0024659633636475
(409) DESCRIBE `ports` 0.0024259090423584
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00065398216247559
(411) DESCRIBE `ports` 0.0022778511047363
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00050020217895508
(413) DESCRIBE `ports` 0.0020990371704102
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041508674621582
(415) DESCRIBE `sailingdates` 0.0017280578613281
(416) DESCRIBE `ports` 0.0019388198852539
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00054001808166504
(418) DESCRIBE `ports` 0.0022118091583252
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00045895576477051
(420) DESCRIBE `ports` 0.0021038055419922
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00042891502380371
(422) DESCRIBE `ports` 0.0019071102142334
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00051689147949219
(424) DESCRIBE `ports` 0.0029478073120117
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00078892707824707
(426) DESCRIBE `ports` 0.0031058788299561
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00072789192199707
(428) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '55702') AND (sailingdate >= '2019-08-26') AND (sailingdate <= '2019-12-06') 0.010255813598633
(429) DESCRIBE `avid_specials` 0.002903938293457
(430) 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.0027220249176025
(431) DESCRIBE `cruiselines` 0.0042099952697754
(432) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00068497657775879
(433) DESCRIBE `orchid_image` 0.0030839443206787
(434) DESCRIBE `cruiselines` 0.0042569637298584
(435) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0007479190826416
(436) DESCRIBE `cruisetypes` 0.0025718212127686
(437) DESCRIBE `destinations` 0.0037579536437988
(438) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.0010941028594971
(439) DESCRIBE `cruiselines` 0.0043530464172363
(440) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00078392028808594
(441) DESCRIBE `ships` 0.0057368278503418
(442) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00084590911865234
(443) DESCRIBE `cruiselines` 0.004288911819458
(444) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00067901611328125
(445) DESCRIBE `ships` 0.0046088695526123
(446) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00065302848815918