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

Total elapsed time: 0.71670961380005

# Query Time
(1) connect 0.0013267993927002
(2) DESCRIBE `cruises` 0.0041778087615967
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (80175, 62156, 11217, 62161, 62566, 32836, 55605, 62170, 64368, 70183)) ORDER BY FIND_IN_SET(id, '80175,62156,11217,62161,62566,32836,55605,62170,64368,70183') 0.0020449161529541
(4) DESCRIBE `cruises` 0.0036261081695557
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80175') 0.00058102607727051
(6) DESCRIBE `ships` 0.0043890476226807
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.00052094459533691
(8) DESCRIBE `ships` 0.0036799907684326
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00045394897460938
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00053000450134277
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0003509521484375
(12) DESCRIBE `itineraries` 0.0018210411071777
(13) DESCRIBE `ports` 0.0019440650939941
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0004429817199707
(15) DESCRIBE `ports` 0.0018160343170166
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00040912628173828
(17) DESCRIBE `ports` 0.0018198490142822
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00036811828613281
(19) DESCRIBE `sailingdates` 0.0016200542449951
(20) DESCRIBE `ports` 0.0022838115692139
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00057816505432129
(22) DESCRIBE `ports` 0.0019140243530273
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00040507316589355
(24) DESCRIBE `ports` 0.0019168853759766
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.0005180835723877
(26) DESCRIBE `ports` 0.0019209384918213
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.00040006637573242
(28) DESCRIBE `ports` 0.0018599033355713
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1319))) 0.00043010711669922
(30) DESCRIBE `ports` 0.0018470287322998
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1319') 0.00041794776916504
(32) DESCRIBE `ports` 0.0018889904022217
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4650))) 0.00041103363037109
(34) DESCRIBE `ports` 0.0019569396972656
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4650') 0.00036883354187012
(36) DESCRIBE `ports` 0.0019130706787109
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5306))) 0.00046300888061523
(38) DESCRIBE `ports` 0.0018749237060547
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5306') 0.0004889965057373
(40) DESCRIBE `ports` 0.0019040107727051
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00057697296142578
(42) DESCRIBE `ports` 0.0017678737640381
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00037002563476562
(44) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '80175') AND (sailingdate >= '2019-08-27') 0.010497093200684
(45) DESCRIBE `avid_specials` 0.0025079250335693
(46) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80175 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.0021939277648926
(47) DESCRIBE `cruiselines` 0.0027329921722412
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00066494941711426
(49) DESCRIBE `orchid_image` 0.0029659271240234
(50) DESCRIBE `cruiselines` 0.0039131641387939
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00057506561279297
(52) DESCRIBE `cruises` 0.0040099620819092
(53) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62156') 0.00052499771118164
(54) DESCRIBE `ships` 0.0034871101379395
(55) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00055289268493652
(56) DESCRIBE `ships` 0.0035538673400879
(57) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00045204162597656
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034904479980469
(59) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00035595893859863
(60) DESCRIBE `itineraries` 0.0018911361694336
(61) DESCRIBE `ports` 0.0018861293792725
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00051498413085938
(63) DESCRIBE `ports` 0.0019829273223877
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00057482719421387
(65) DESCRIBE `ports` 0.0020368099212646
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00048112869262695
(67) DESCRIBE `sailingdates` 0.0016310214996338
(68) DESCRIBE `ports` 0.0028128623962402
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00058984756469727
(70) DESCRIBE `ports` 0.0024049282073975
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.000518798828125
(72) DESCRIBE `ports` 0.0018529891967773
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042819976806641
(74) DESCRIBE `ports` 0.0018000602722168
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003809928894043
(76) 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.0058219432830811
(77) DESCRIBE `avid_specials` 0.0021140575408936
(78) 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.0012209415435791
(79) DESCRIBE `cruiselines` 0.0027720928192139
(80) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00047516822814941
(81) DESCRIBE `orchid_image` 0.002161979675293
(82) DESCRIBE `cruiselines` 0.0024659633636475
(83) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00043606758117676
(84) DESCRIBE `cruises` 0.003648042678833
(85) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '11217') 0.00042414665222168
(86) DESCRIBE `ships` 0.0035319328308105
(87) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.00052714347839355
(88) DESCRIBE `ships` 0.0036659240722656
(89) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00039505958557129
(90) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0004429817199707
(91) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033712387084961
(92) DESCRIBE `itineraries` 0.0026810169219971
(93) DESCRIBE `ports` 0.0022339820861816
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0005040168762207
(95) DESCRIBE `ports` 0.0018150806427002
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00042581558227539
(97) DESCRIBE `ports` 0.002007007598877
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00039815902709961
(99) DESCRIBE `sailingdates` 0.0016460418701172
(100) DESCRIBE `ports` 0.0020709037780762
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00042605400085449
(102) DESCRIBE `ports` 0.0020041465759277
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0005030632019043
(104) DESCRIBE `ports` 0.0017969608306885
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00043106079101562
(106) DESCRIBE `ports` 0.0018670558929443
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00045919418334961
(108) DESCRIBE `ports` 0.0027909278869629
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00075197219848633
(110) DESCRIBE `ports` 0.0030241012573242
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00064206123352051
(112) DESCRIBE `ports` 0.0028789043426514
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00066304206848145
(114) DESCRIBE `ports` 0.0027761459350586
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00061511993408203
(116) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '11217') AND (sailingdate >= '2019-08-27') 0.0058419704437256
(117) DESCRIBE `avid_specials` 0.002126932144165
(118) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 11217 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.0012810230255127
(119) DESCRIBE `cruiselines` 0.0028951168060303
(120) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00048589706420898
(121) DESCRIBE `orchid_image` 0.0019340515136719
(122) DESCRIBE `cruiselines` 0.0026259422302246
(123) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00035309791564941
(124) DESCRIBE `cruises` 0.0036821365356445
(125) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62161') 0.00047206878662109
(126) DESCRIBE `ships` 0.0034880638122559
(127) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00059103965759277
(128) DESCRIBE `ships` 0.0048658847808838
(129) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00044107437133789
(130) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00037479400634766
(131) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034403800964355
(132) DESCRIBE `itineraries` 0.0017449855804443
(133) DESCRIBE `ports` 0.0017669200897217
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047397613525391
(135) DESCRIBE `ports` 0.0018208026885986
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043201446533203
(137) DESCRIBE `ports` 0.0020079612731934
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040197372436523
(139) DESCRIBE `sailingdates` 0.0016629695892334
(140) DESCRIBE `ports` 0.0019090175628662
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046992301940918
(142) DESCRIBE `ports` 0.0020639896392822
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040102005004883
(144) DESCRIBE `ports` 0.0017750263214111
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00045585632324219
(146) DESCRIBE `ports` 0.0019469261169434
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00053501129150391
(148) DESCRIBE `ports` 0.0017828941345215
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049901008605957
(150) DESCRIBE `ports` 0.0026428699493408
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00051188468933105
(152) 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.0058829784393311
(153) DESCRIBE `avid_specials` 0.0018870830535889
(154) 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.0011410713195801
(155) DESCRIBE `cruiselines` 0.0027370452880859
(156) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00043201446533203
(157) DESCRIBE `orchid_image` 0.0021719932556152
(158) DESCRIBE `cruiselines` 0.0037288665771484
(159) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00066709518432617
(160) DESCRIBE `cruises` 0.0042948722839355
(161) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62566') 0.00049781799316406
(162) DESCRIBE `ships` 0.0038940906524658
(163) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.00059914588928223
(164) DESCRIBE `ships` 0.0038430690765381
(165) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00041890144348145
(166) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035905838012695
(167) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00051379203796387
(168) DESCRIBE `itineraries` 0.0018680095672607
(169) DESCRIBE `ports` 0.0021109580993652
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00044894218444824
(171) DESCRIBE `ports` 0.0019829273223877
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00042986869812012
(173) DESCRIBE `ports` 0.0017530918121338
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00040006637573242
(175) DESCRIBE `sailingdates` 0.001582145690918
(176) DESCRIBE `ports` 0.001971960067749
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00044608116149902
(178) DESCRIBE `ports` 0.0018908977508545
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0003960132598877
(180) DESCRIBE `ports` 0.0017778873443604
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00043702125549316
(182) DESCRIBE `ports` 0.0017881393432617
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00037693977355957
(184) DESCRIBE `ports` 0.0017459392547607
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00043201446533203
(186) DESCRIBE `ports` 0.0017838478088379
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00037789344787598
(188) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62566') AND (sailingdate >= '2019-08-27') 0.0056078433990479
(189) DESCRIBE `avid_specials` 0.001755952835083
(190) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62566 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.0013871192932129
(191) DESCRIBE `cruiselines` 0.0026950836181641
(192) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00058698654174805
(193) DESCRIBE `orchid_image` 0.0024020671844482
(194) DESCRIBE `cruiselines` 0.003026008605957
(195) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00072693824768066
(196) DESCRIBE `cruises` 0.0035610198974609
(197) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '32836') 0.00039792060852051
(198) DESCRIBE `ships` 0.0035889148712158
(199) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.00059700012207031
(200) DESCRIBE `ships` 0.0039420127868652
(201) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00037193298339844
(202) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035500526428223
(203) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034809112548828
(204) DESCRIBE `itineraries` 0.0021398067474365
(205) DESCRIBE `ports` 0.0018041133880615
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00044608116149902
(207) DESCRIBE `ports` 0.0017340183258057
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00042390823364258
(209) DESCRIBE `ports` 0.0018610954284668
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00037693977355957
(211) DESCRIBE `sailingdates` 0.0018608570098877
(212) DESCRIBE `ports` 0.0019071102142334
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00047802925109863
(214) DESCRIBE `ports` 0.0018630027770996
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0005040168762207
(216) DESCRIBE `ports` 0.0023579597473145
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00058722496032715
(218) DESCRIBE `ports` 0.0019829273223877
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.0004270076751709
(220) DESCRIBE `ports` 0.001784086227417
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2751))) 0.00043487548828125
(222) DESCRIBE `ports` 0.0018320083618164
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2751') 0.00042200088500977
(224) DESCRIBE `ports` 0.0017790794372559
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 734))) 0.00042605400085449
(226) DESCRIBE `ports` 0.0018398761749268
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '734') 0.00043201446533203
(228) DESCRIBE `ports` 0.0017619132995605
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00042414665222168
(230) DESCRIBE `ports` 0.0018219947814941
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00044512748718262
(232) DESCRIBE `ports` 0.0017390251159668
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00042510032653809
(234) DESCRIBE `ports` 0.0021650791168213
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00042510032653809
(236) 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.0052499771118164
(237) DESCRIBE `avid_specials` 0.0018448829650879
(238) 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.0011839866638184
(239) DESCRIBE `cruiselines` 0.0025420188903809
(240) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00044393539428711
(241) DESCRIBE `orchid_image` 0.0021629333496094
(242) DESCRIBE `cruiselines` 0.0039291381835938
(243) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00061988830566406
(244) DESCRIBE `cruises` 0.0045938491821289
(245) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55605') 0.00053787231445312
(246) DESCRIBE `ships` 0.0049738883972168
(247) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.00050592422485352
(248) DESCRIBE `ships` 0.0046069622039795
(249) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00060820579528809
(250) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00059199333190918
(251) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00038790702819824
(252) DESCRIBE `itineraries` 0.0020818710327148
(253) DESCRIBE `ports` 0.0019409656524658
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00052094459533691
(255) DESCRIBE `ports` 0.0017809867858887
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00048613548278809
(257) DESCRIBE `ports` 0.0017690658569336
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00042200088500977
(259) DESCRIBE `sailingdates` 0.0016641616821289
(260) DESCRIBE `ports` 0.0020320415496826
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00044083595275879
(262) DESCRIBE `ports` 0.0018479824066162
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00038695335388184
(264) DESCRIBE `ports` 0.0017850399017334
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00068807601928711
(266) DESCRIBE `ports` 0.002284049987793
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00047111511230469
(268) DESCRIBE `ports` 0.0018291473388672
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00043392181396484
(270) DESCRIBE `ports` 0.0018010139465332
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00039410591125488
(272) DESCRIBE `ports` 0.0022618770599365
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00044798851013184
(274) DESCRIBE `ports` 0.0018250942230225
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00045204162597656
(276) DESCRIBE `ports` 0.0017549991607666
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00041007995605469
(278) DESCRIBE `ports` 0.0019679069519043
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00043582916259766
(280) DESCRIBE `ports` 0.0023720264434814
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.0005500316619873
(282) DESCRIBE `ports` 0.0024218559265137
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00038290023803711
(284) DESCRIBE `ports` 0.0019199848175049
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00043892860412598
(286) DESCRIBE `ports` 0.0018889904022217
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00054693222045898
(288) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '55605') AND (sailingdate >= '2019-08-27') 0.0095729827880859
(289) DESCRIBE `avid_specials` 0.00211501121521
(290) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55605 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.0017170906066895
(291) DESCRIBE `cruiselines` 0.0026280879974365
(292) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00045394897460938
(293) DESCRIBE `orchid_image` 0.0019891262054443
(294) DESCRIBE `cruiselines` 0.0024940967559814
(295) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00037312507629395
(296) DESCRIBE `cruises` 0.0034871101379395
(297) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62170') 0.00044107437133789
(298) DESCRIBE `ships` 0.0038421154022217
(299) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00059390068054199
(300) DESCRIBE `ships` 0.0036211013793945
(301) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00045299530029297
(302) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00035691261291504
(303) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00040006637573242
(304) DESCRIBE `itineraries` 0.0017058849334717
(305) DESCRIBE `ports` 0.0017650127410889
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043916702270508
(307) DESCRIBE `ports` 0.0018758773803711
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042605400085449
(309) DESCRIBE `ports` 0.0018048286437988
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037217140197754
(311) DESCRIBE `sailingdates` 0.0016641616821289
(312) DESCRIBE `ports` 0.0020110607147217
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043511390686035
(314) DESCRIBE `ports` 0.0017850399017334
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037097930908203
(316) DESCRIBE `ports` 0.0018630027770996
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00040507316589355
(318) DESCRIBE `ports` 0.0018219947814941
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00039911270141602
(320) DESCRIBE `ports` 0.0018019676208496
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00041484832763672
(322) DESCRIBE `ports` 0.0018529891967773
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00043201446533203
(324) DESCRIBE `ports` 0.0025990009307861
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00062799453735352
(326) DESCRIBE `ports` 0.0026857852935791
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00038599967956543
(328) DESCRIBE `ports` 0.0018160343170166
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00043106079101562
(330) DESCRIBE `ports` 0.0017480850219727
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00046992301940918
(332) DESCRIBE `ports` 0.0017449855804443
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00050878524780273
(334) DESCRIBE `ports` 0.0017740726470947
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037193298339844
(336) 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.0056118965148926
(337) DESCRIBE `avid_specials` 0.0021560192108154
(338) 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.0011780261993408
(339) DESCRIBE `cruiselines` 0.002640962600708
(340) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00043892860412598
(341) DESCRIBE `orchid_image` 0.0022201538085938
(342) DESCRIBE `cruiselines` 0.0025539398193359
(343) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00047683715820312
(344) DESCRIBE `cruises` 0.0053451061248779
(345) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64368') 0.00061607360839844
(346) DESCRIBE `ships` 0.0046310424804688
(347) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.00049996376037598
(348) DESCRIBE `ships` 0.003364086151123
(349) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00037503242492676
(350) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035715103149414
(351) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034785270690918
(352) DESCRIBE `itineraries` 0.0017669200897217
(353) DESCRIBE `ports` 0.0017521381378174
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00048089027404785
(355) DESCRIBE `ports` 0.0017580986022949
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00042319297790527
(357) DESCRIBE `ports` 0.0019478797912598
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00037407875061035
(359) DESCRIBE `sailingdates` 0.0015709400177002
(360) DESCRIBE `ports` 0.0018539428710938
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00044417381286621
(362) DESCRIBE `ports` 0.001816987991333
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00039887428283691
(364) DESCRIBE `ports` 0.0017728805541992
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00040888786315918
(366) DESCRIBE `ports` 0.0017549991607666
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00037193298339844
(368) DESCRIBE `ports` 0.0017759799957275
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00053095817565918
(370) DESCRIBE `ports` 0.0018291473388672
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00037097930908203
(372) DESCRIBE `ports` 0.0018670558929443
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00041890144348145
(374) DESCRIBE `ports` 0.0017609596252441
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00037193298339844
(376) DESCRIBE `ports` 0.0018188953399658
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00042390823364258
(378) DESCRIBE `ports` 0.0017659664154053
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00039386749267578
(380) 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.0056009292602539
(381) DESCRIBE `avid_specials` 0.0056760311126709
(382) 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.0014350414276123
(383) DESCRIBE `cruiselines` 0.0027570724487305
(384) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00046992301940918
(385) DESCRIBE `orchid_image` 0.0023970603942871
(386) DESCRIBE `cruiselines` 0.0027520656585693
(387) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.0004730224609375
(388) DESCRIBE `cruises` 0.0047018527984619
(389) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70183') 0.00054788589477539
(390) DESCRIBE `ships` 0.0036370754241943
(391) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00062894821166992
(392) DESCRIBE `ships` 0.0066750049591064
(393) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00046920776367188
(394) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00036406517028809
(395) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00038599967956543
(396) DESCRIBE `itineraries` 0.00187087059021
(397) DESCRIBE `ports` 0.0021860599517822
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046205520629883
(399) DESCRIBE `ports` 0.0020618438720703
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044083595275879
(401) DESCRIBE `ports` 0.0022139549255371
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0004119873046875
(403) DESCRIBE `sailingdates` 0.0017318725585938
(404) DESCRIBE `ports` 0.0017910003662109
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00051689147949219
(406) DESCRIBE `ports` 0.0018861293792725
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040912628173828
(408) DESCRIBE `ports` 0.0018131732940674
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2179))) 0.00043511390686035
(410) DESCRIBE `ports` 0.0018689632415771
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2179') 0.00039196014404297
(412) DESCRIBE `ports` 0.0019969940185547
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 419))) 0.00043392181396484
(414) DESCRIBE `ports` 0.0018599033355713
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '419') 0.00041913986206055
(416) DESCRIBE `ports` 0.0019900798797607
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1044))) 0.0004270076751709
(418) DESCRIBE `ports` 0.0017900466918945
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1044') 0.00037503242492676
(420) DESCRIBE `ports` 0.0019299983978271
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1758))) 0.00043487548828125
(422) DESCRIBE `ports` 0.0017890930175781
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1758') 0.00037598609924316
(424) DESCRIBE `ports` 0.0017571449279785
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00043082237243652
(426) DESCRIBE `ports` 0.0019819736480713
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00038886070251465
(428) DESCRIBE `ports` 0.0017588138580322
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00043106079101562
(430) DESCRIBE `ports` 0.0017900466918945
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00041508674621582
(432) DESCRIBE `ports` 0.0020439624786377
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00049996376037598
(434) DESCRIBE `ports` 0.0020921230316162
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00040507316589355
(436) DESCRIBE `ports` 0.0019550323486328
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044107437133789
(438) DESCRIBE `ports` 0.0018970966339111
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037598609924316
(440) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '70183') AND (sailingdate >= '2019-08-27') 0.0057170391082764
(441) DESCRIBE `avid_specials` 0.0023329257965088
(442) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70183 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.0014247894287109
(443) DESCRIBE `cruiselines` 0.0026111602783203
(444) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00046610832214355
(445) DESCRIBE `orchid_image` 0.0019490718841553
(446) DESCRIBE `cruiselines` 0.0024430751800537
(447) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00047397613525391
(448) DESCRIBE `ships` 0.004101037979126
(449) SELECT `ships`.* FROM `ships` WHERE (id IN ('1402', '573', '1284', '1758')) ORDER BY FIND_IN_SET(id, '1402,573,1284,1758') 0.00095605850219727
(450) DESCRIBE `cruisetypes` 0.0015048980712891
(451) DESCRIBE `destinations` 0.002871036529541
(452) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('8', '43', '35')) ORDER BY FIND_IN_SET(id, '8,43,35') 0.00081300735473633
(453) DESCRIBE `cruiselines` 0.0030021667480469
(454) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00047516822814941
(455) DESCRIBE `cruiselines` 0.0029149055480957
(456) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.000579833984375