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

Total elapsed time: 0.74982571601868

# Query Time
(1) connect 0.0015890598297119
(2) DESCRIBE `cruises` 0.0040218830108643
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (62156, 75450, 62161, 67182, 67246, 32836, 65470, 64368, 62162, 62170)) ORDER BY FIND_IN_SET(id, '62156,75450,62161,67182,67246,32836,65470,64368,62162,62170') 0.0019738674163818
(4) DESCRIBE `cruises` 0.0037310123443604
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62156') 0.00050115585327148
(6) DESCRIBE `ships` 0.0036580562591553
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00055193901062012
(8) DESCRIBE `ships` 0.0037810802459717
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00047612190246582
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00035905838012695
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034403800964355
(12) DESCRIBE `itineraries` 0.0047078132629395
(13) DESCRIBE `ports` 0.0020320415496826
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004580020904541
(15) DESCRIBE `ports` 0.0021212100982666
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038790702819824
(17) DESCRIBE `ports` 0.0018601417541504
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042510032653809
(19) DESCRIBE `sailingdates` 0.0016140937805176
(20) DESCRIBE `ports` 0.0019011497497559
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043106079101562
(22) DESCRIBE `ports` 0.001953125
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003669261932373
(24) DESCRIBE `ports` 0.00193190574646
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004889965057373
(26) DESCRIBE `ports` 0.0018010139465332
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037813186645508
(28) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62156') AND (sailingdate >= '2019-08-27') 0.0093507766723633
(29) DESCRIBE `avid_specials` 0.0018658638000488
(30) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62156 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 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.0013039112091064
(31) DESCRIBE `cruiselines` 0.0027408599853516
(32) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00049901008605957
(33) DESCRIBE `orchid_image` 0.0021789073944092
(34) DESCRIBE `cruiselines` 0.003432035446167
(35) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00053000450134277
(36) DESCRIBE `cruises` 0.0045621395111084
(37) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75450') 0.00044584274291992
(38) DESCRIBE `ships` 0.0036940574645996
(39) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.00047516822814941
(40) DESCRIBE `ships` 0.0034949779510498
(41) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00038599967956543
(42) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00035500526428223
(43) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034594535827637
(44) DESCRIBE `itineraries` 0.001849889755249
(45) DESCRIBE `ports` 0.0017831325531006
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00051498413085938
(47) DESCRIBE `ports` 0.001802921295166
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00056099891662598
(49) DESCRIBE `ports` 0.0020930767059326
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00040698051452637
(51) DESCRIBE `sailingdates` 0.0017499923706055
(52) DESCRIBE `ports` 0.0020930767059326
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00064706802368164
(54) DESCRIBE `ports` 0.0019979476928711
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00040292739868164
(56) DESCRIBE `ports` 0.0020642280578613
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00044393539428711
(58) DESCRIBE `ports` 0.0019090175628662
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00045108795166016
(60) DESCRIBE `ports` 0.0017609596252441
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00042390823364258
(62) DESCRIBE `ports` 0.00177001953125
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00052094459533691
(64) DESCRIBE `ports` 0.0018000602722168
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00042986869812012
(66) DESCRIBE `ports` 0.0019688606262207
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00039005279541016
(68) DESCRIBE `ports` 0.0019161701202393
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00049304962158203
(70) DESCRIBE `ports` 0.0018260478973389
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00041508674621582
(72) DESCRIBE `ports` 0.0017621517181396
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00044894218444824
(74) DESCRIBE `ports` 0.0018010139465332
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00044083595275879
(76) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75450') AND (sailingdate >= '2019-08-27') 0.0068738460540771
(77) DESCRIBE `avid_specials` 0.0020759105682373
(78) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75450 and class = 'Cruise') OR (item_id = 1284 AND class = 'Ship') OR (item_id = 37 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.0012719631195068
(79) DESCRIBE `cruiselines` 0.0031249523162842
(80) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00062799453735352
(81) DESCRIBE `orchid_image` 0.0023000240325928
(82) DESCRIBE `cruiselines` 0.0029342174530029
(83) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00042510032653809
(84) DESCRIBE `cruises` 0.0036790370941162
(85) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62161') 0.00048208236694336
(86) DESCRIBE `ships` 0.0036749839782715
(87) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00055599212646484
(88) DESCRIBE `ships` 0.0035419464111328
(89) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00052309036254883
(90) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0004279613494873
(91) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00036501884460449
(92) DESCRIBE `itineraries` 0.0035390853881836
(93) DESCRIBE `ports` 0.0024189949035645
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043392181396484
(95) DESCRIBE `ports` 0.0020010471343994
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00050806999206543
(97) DESCRIBE `ports` 0.0017819404602051
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00057506561279297
(99) DESCRIBE `sailingdates` 0.0022249221801758
(100) DESCRIBE `ports` 0.0026049613952637
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0006251335144043
(102) DESCRIBE `ports` 0.0026049613952637
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00053715705871582
(104) DESCRIBE `ports` 0.0026161670684814
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00063395500183105
(106) DESCRIBE `ports` 0.0026850700378418
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00062799453735352
(108) DESCRIBE `ports` 0.0027449131011963
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00058507919311523
(110) DESCRIBE `ports` 0.0026240348815918
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00056195259094238
(112) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62161') AND (sailingdate >= '2019-08-27') 0.010470867156982
(113) DESCRIBE `avid_specials` 0.0025360584259033
(114) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62161 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 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.0021719932556152
(115) DESCRIBE `cruiselines` 0.0038840770721436
(116) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00067806243896484
(117) DESCRIBE `orchid_image` 0.0024349689483643
(118) DESCRIBE `cruiselines` 0.0026440620422363
(119) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00041103363037109
(120) DESCRIBE `cruises` 0.0036900043487549
(121) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67182') 0.00050783157348633
(122) DESCRIBE `ships` 0.0049960613250732
(123) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.00074386596679688
(124) DESCRIBE `ships` 0.0051259994506836
(125) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00059700012207031
(126) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00047516822814941
(127) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0004570484161377
(128) DESCRIBE `itineraries` 0.002514123916626
(129) DESCRIBE `ports` 0.0026490688323975
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00064301490783691
(131) DESCRIBE `ports` 0.0025129318237305
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00068116188049316
(133) DESCRIBE `ports` 0.002424955368042
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0005950927734375
(135) DESCRIBE `sailingdates` 0.0021910667419434
(136) DESCRIBE `ports` 0.0025720596313477
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00057697296142578
(138) DESCRIBE `ports` 0.0032370090484619
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00064206123352051
(140) DESCRIBE `ports` 0.0025360584259033
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00061798095703125
(142) DESCRIBE `ports` 0.0024559497833252
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00039911270141602
(144) DESCRIBE `ports` 0.0018608570098877
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00041413307189941
(146) DESCRIBE `ports` 0.0018420219421387
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0003809928894043
(148) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '67182') AND (sailingdate >= '2019-08-27') 0.0071799755096436
(149) DESCRIBE `avid_specials` 0.0019981861114502
(150) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67182 and class = 'Cruise') OR (item_id = 1284 AND class = 'Ship') OR (item_id = 37 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.0012540817260742
(151) DESCRIBE `cruiselines` 0.0031790733337402
(152) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00076889991760254
(153) DESCRIBE `orchid_image` 0.002892017364502
(154) DESCRIBE `cruiselines` 0.0030021667480469
(155) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00048089027404785
(156) DESCRIBE `cruises` 0.0038161277770996
(157) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67246') 0.00042295455932617
(158) DESCRIBE `ships` 0.0055348873138428
(159) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00080513954162598
(160) DESCRIBE `ships` 0.0041120052337646
(161) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00057721138000488
(162) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00036406517028809
(163) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00035977363586426
(164) DESCRIBE `itineraries` 0.0018129348754883
(165) DESCRIBE `ports` 0.0019040107727051
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049304962158203
(167) DESCRIBE `ports` 0.0017619132995605
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047492980957031
(169) DESCRIBE `ports` 0.0019900798797607
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041413307189941
(171) DESCRIBE `sailingdates` 0.0020751953125
(172) DESCRIBE `ports` 0.0022540092468262
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049996376037598
(174) DESCRIBE `ports` 0.0019090175628662
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00051689147949219
(176) DESCRIBE `ports` 0.0020499229431152
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00052213668823242
(178) DESCRIBE `ports` 0.0028009414672852
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00062298774719238
(180) DESCRIBE `ports` 0.0027871131896973
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00054097175598145
(182) DESCRIBE `ports` 0.0024540424346924
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00050497055053711
(184) DESCRIBE `ports` 0.0020899772644043
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00046300888061523
(186) DESCRIBE `ports` 0.0021731853485107
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00043892860412598
(188) DESCRIBE `ports` 0.0018491744995117
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045299530029297
(190) DESCRIBE `ports` 0.0019488334655762
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00052285194396973
(192) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '67246') AND (sailingdate >= '2019-08-27') 0.0061299800872803
(193) DESCRIBE `avid_specials` 0.0019509792327881
(194) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67246 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 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.0015850067138672
(195) DESCRIBE `cruiselines` 0.0027251243591309
(196) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00051212310791016
(197) DESCRIBE `orchid_image` 0.0026941299438477
(198) DESCRIBE `cruiselines` 0.0026850700378418
(199) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00055694580078125
(200) DESCRIBE `cruises` 0.0037891864776611
(201) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '32836') 0.0004270076751709
(202) DESCRIBE `ships` 0.0045487880706787
(203) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.00057315826416016
(204) DESCRIBE `ships` 0.0042381286621094
(205) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00059795379638672
(206) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00055313110351562
(207) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00051403045654297
(208) DESCRIBE `itineraries` 0.0027670860290527
(209) DESCRIBE `ports` 0.0023391246795654
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00043702125549316
(211) DESCRIBE `ports` 0.0019659996032715
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00039410591125488
(213) DESCRIBE `ports` 0.0018310546875
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00041913986206055
(215) DESCRIBE `sailingdates` 0.0016589164733887
(216) DESCRIBE `ports` 0.0018911361694336
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00046896934509277
(218) DESCRIBE `ports` 0.0026829242706299
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00058913230895996
(220) DESCRIBE `ports` 0.0023729801177979
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00041913986206055
(222) DESCRIBE `ports` 0.0021069049835205
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00038290023803711
(224) DESCRIBE `ports` 0.0020828247070312
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2751))) 0.00048398971557617
(226) DESCRIBE `ports` 0.0017850399017334
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2751') 0.00052380561828613
(228) DESCRIBE `ports` 0.0020730495452881
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 734))) 0.00040698051452637
(230) DESCRIBE `ports` 0.001856803894043
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '734') 0.00042891502380371
(232) DESCRIBE `ports` 0.0021669864654541
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00039887428283691
(234) DESCRIBE `ports` 0.0020480155944824
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00041913986206055
(236) DESCRIBE `ports` 0.0018320083618164
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00047707557678223
(238) DESCRIBE `ports` 0.0018761157989502
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00044107437133789
(240) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '32836') AND (sailingdate >= '2019-08-27') 0.0061850547790527
(241) DESCRIBE `avid_specials` 0.0018060207366943
(242) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 32836 and class = 'Cruise') OR (item_id = 573 AND class = 'Ship') OR (item_id = 37 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.0013749599456787
(243) DESCRIBE `cruiselines` 0.0028839111328125
(244) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00041913986206055
(245) DESCRIBE `orchid_image` 0.0025310516357422
(246) DESCRIBE `cruiselines` 0.0032689571380615
(247) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00044989585876465
(248) DESCRIBE `cruises` 0.0034530162811279
(249) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65470') 0.00043582916259766
(250) DESCRIBE `ships` 0.003715991973877
(251) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.00051212310791016
(252) DESCRIBE `ships` 0.0039660930633545
(253) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00044703483581543
(254) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00035905838012695
(255) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00035500526428223
(256) DESCRIBE `itineraries` 0.0017590522766113
(257) DESCRIBE `ports` 0.0022211074829102
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00050210952758789
(259) DESCRIBE `ports` 0.0025918483734131
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00066804885864258
(261) DESCRIBE `ports` 0.0024991035461426
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00054502487182617
(263) DESCRIBE `sailingdates` 0.0021460056304932
(264) DESCRIBE `ports` 0.0019199848175049
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00044918060302734
(266) DESCRIBE `ports` 0.0017819404602051
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00039386749267578
(268) DESCRIBE `ports` 0.0019497871398926
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.0004119873046875
(270) DESCRIBE `ports` 0.001755952835083
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.00039505958557129
(272) DESCRIBE `ports` 0.001953125
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1319))) 0.00066900253295898
(274) DESCRIBE `ports` 0.0019030570983887
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1319') 0.00042104721069336
(276) DESCRIBE `ports` 0.0018141269683838
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 791))) 0.00047183036804199
(278) DESCRIBE `ports` 0.0018861293792725
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '791') 0.0003819465637207
(280) DESCRIBE `ports` 0.0019021034240723
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4650))) 0.00044417381286621
(282) DESCRIBE `ports` 0.0020639896392822
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4650') 0.00046706199645996
(284) DESCRIBE `ports` 0.0018389225006104
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5306))) 0.00043988227844238
(286) DESCRIBE `ports` 0.0018260478973389
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5306') 0.0003972053527832
(288) DESCRIBE `ports` 0.002748966217041
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00061202049255371
(290) DESCRIBE `ports` 0.0026211738586426
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00066590309143066
(292) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '65470') AND (sailingdate >= '2019-08-27') 0.011055946350098
(293) DESCRIBE `avid_specials` 0.0026319026947021
(294) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65470 and class = 'Cruise') OR (item_id = 1284 AND class = 'Ship') OR (item_id = 37 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.0021970272064209
(295) DESCRIBE `cruiselines` 0.0038449764251709
(296) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00066208839416504
(297) DESCRIBE `orchid_image` 0.0029561519622803
(298) DESCRIBE `cruiselines` 0.0037329196929932
(299) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00082993507385254
(300) DESCRIBE `cruises` 0.0050361156463623
(301) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64368') 0.00055909156799316
(302) DESCRIBE `ships` 0.0052449703216553
(303) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.00071287155151367
(304) DESCRIBE `ships` 0.0053689479827881
(305) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00056195259094238
(306) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00050902366638184
(307) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00056695938110352
(308) DESCRIBE `itineraries` 0.0025711059570312
(309) DESCRIBE `ports` 0.0027198791503906
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00043511390686035
(311) DESCRIBE `ports` 0.0018479824066162
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00041699409484863
(313) DESCRIBE `ports` 0.0021049976348877
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00038313865661621
(315) DESCRIBE `sailingdates` 0.0018448829650879
(316) DESCRIBE `ports` 0.0019378662109375
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00048398971557617
(318) DESCRIBE `ports` 0.0021998882293701
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00037598609924316
(320) DESCRIBE `ports` 0.0021250247955322
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00049304962158203
(322) DESCRIBE `ports` 0.0018701553344727
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00056600570678711
(324) DESCRIBE `ports` 0.0017578601837158
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00042009353637695
(326) DESCRIBE `ports` 0.0018188953399658
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00039100646972656
(328) DESCRIBE `ports` 0.0020451545715332
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00047397613525391
(330) DESCRIBE `ports` 0.0018560886383057
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00039196014404297
(332) DESCRIBE `ports` 0.002000093460083
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00041317939758301
(334) DESCRIBE `ports` 0.0022830963134766
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00045990943908691
(336) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '64368') AND (sailingdate >= '2019-08-27') 0.0061218738555908
(337) DESCRIBE `avid_specials` 0.0017781257629395
(338) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64368 and class = 'Cruise') OR (item_id = 573 AND class = 'Ship') OR (item_id = 37 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.0018990039825439
(339) DESCRIBE `cruiselines` 0.0033900737762451
(340) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00047802925109863
(341) DESCRIBE `orchid_image` 0.0027198791503906
(342) DESCRIBE `cruiselines` 0.0029468536376953
(343) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00053596496582031
(344) DESCRIBE `cruises` 0.0034329891204834
(345) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62162') 0.00040292739868164
(346) DESCRIBE `ships` 0.0035820007324219
(347) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00054597854614258
(348) DESCRIBE `ships` 0.0035240650177002
(349) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00043988227844238
(350) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00042390823364258
(351) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00035595893859863
(352) DESCRIBE `itineraries` 0.0017380714416504
(353) DESCRIBE `ports` 0.0017869472503662
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0006260871887207
(355) DESCRIBE `ports` 0.0019419193267822
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0005490779876709
(357) DESCRIBE `ports` 0.0018739700317383
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040793418884277
(359) DESCRIBE `sailingdates` 0.0019321441650391
(360) DESCRIBE `ports` 0.0019221305847168
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00054693222045898
(362) DESCRIBE `ports` 0.0021910667419434
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00055289268493652
(364) DESCRIBE `ports` 0.0017490386962891
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043177604675293
(366) DESCRIBE `ports` 0.0018839836120605
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003960132598877
(368) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62162') AND (sailingdate >= '2019-08-27') 0.0061089992523193
(369) DESCRIBE `avid_specials` 0.0017349720001221
(370) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62162 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 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.0013220310211182
(371) DESCRIBE `cruiselines` 0.0034389495849609
(372) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00075793266296387
(373) DESCRIBE `orchid_image` 0.0025441646575928
(374) DESCRIBE `cruiselines` 0.0028960704803467
(375) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00051617622375488
(376) DESCRIBE `cruises` 0.0051839351654053
(377) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62170') 0.00058293342590332
(378) DESCRIBE `ships` 0.0050990581512451
(379) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00081801414489746
(380) DESCRIBE `ships` 0.0051529407501221
(381) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00070595741271973
(382) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00056290626525879
(383) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00049996376037598
(384) DESCRIBE `itineraries` 0.0025289058685303
(385) DESCRIBE `ports` 0.0019969940185547
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00061392784118652
(387) DESCRIBE `ports` 0.0017809867858887
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048613548278809
(389) DESCRIBE `ports` 0.0018110275268555
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038409233093262
(391) DESCRIBE `sailingdates` 0.001655101776123
(392) DESCRIBE `ports` 0.0018711090087891
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045585632324219
(394) DESCRIBE `ports` 0.0018610954284668
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038290023803711
(396) DESCRIBE `ports` 0.0017549991607666
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00053095817565918
(398) DESCRIBE `ports` 0.0019190311431885
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00038981437683105
(400) DESCRIBE `ports` 0.002302885055542
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00052881240844727
(402) DESCRIBE `ports` 0.00223708152771
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00052309036254883
(404) DESCRIBE `ports` 0.0018179416656494
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00043702125549316
(406) DESCRIBE `ports` 0.0017740726470947
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00039505958557129
(408) DESCRIBE `ports` 0.0018751621246338
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00041079521179199
(410) DESCRIBE `ports` 0.0018119812011719
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00044107437133789
(412) DESCRIBE `ports` 0.0020971298217773
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044488906860352
(414) DESCRIBE `ports` 0.00211501121521
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0005640983581543
(416) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62170') AND (sailingdate >= '2019-08-27') 0.0091099739074707
(417) DESCRIBE `avid_specials` 0.0020849704742432
(418) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62170 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 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.00187087059021
(419) DESCRIBE `cruiselines` 0.0031337738037109
(420) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00059604644775391
(421) DESCRIBE `orchid_image` 0.0026531219482422
(422) DESCRIBE `cruiselines` 0.0029499530792236
(423) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00050210952758789
(424) DESCRIBE `ships` 0.0045368671417236
(425) SELECT `ships`.* FROM `ships` WHERE (id IN ('1402', '573', '1284', '1758')) ORDER BY FIND_IN_SET(id, '1402,573,1284,1758') 0.0016241073608398
(426) DESCRIBE `cruisetypes` 0.0025501251220703
(427) DESCRIBE `destinations` 0.00388503074646
(428) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('8', '43', '35')) ORDER BY FIND_IN_SET(id, '8,43,35') 0.0013492107391357
(429) DESCRIBE `cruiselines` 0.004108190536499
(430) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00078916549682617
(431) DESCRIBE `cruiselines` 0.004209041595459
(432) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00078392028808594