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

Total elapsed time: 0.4260950088501

# Query Time
(1) connect 0.00090599060058594
(2) DESCRIBE `cruises` 0.0041542053222656
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (50857, 41778, 50866, 63373, 55702, 70935)) ORDER BY FIND_IN_SET(id, '50857,41778,50866,63373,55702,70935') 0.0014760494232178
(4) DESCRIBE `cruises` 0.0036170482635498
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50857') 0.00038409233093262
(6) DESCRIBE `ships` 0.0035698413848877
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00052213668823242
(8) DESCRIBE `ships` 0.0037579536437988
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00039911270141602
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035595893859863
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034594535827637
(12) DESCRIBE `itineraries` 0.0018181800842285
(13) DESCRIBE `ports` 0.0017809867858887
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00052809715270996
(15) DESCRIBE `ports` 0.0017650127410889
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038886070251465
(17) DESCRIBE `ports` 0.0020220279693604
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037908554077148
(19) DESCRIBE `sailingdates` 0.0020158290863037
(20) DESCRIBE `ports` 0.0018410682678223
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00052690505981445
(22) DESCRIBE `ports` 0.0017979145050049
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037717819213867
(24) DESCRIBE `ports` 0.0018770694732666
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00041294097900391
(26) DESCRIBE `ports` 0.0018150806427002
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00041818618774414
(28) DESCRIBE `ports` 0.0017540454864502
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00048089027404785
(30) DESCRIBE `ports` 0.0017919540405273
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00037193298339844
(32) DESCRIBE `ports` 0.001816987991333
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00037407875061035
(34) DESCRIBE `ports` 0.00174880027771
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00035405158996582
(36) DESCRIBE `ports` 0.00193190574646
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.0003960132598877
(38) DESCRIBE `ports` 0.0019021034240723
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00037407875061035
(40) DESCRIBE `ports` 0.0019021034240723
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039196014404297
(42) DESCRIBE `ports` 0.0018777847290039
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037097930908203
(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.0074939727783203
(45) DESCRIBE `avid_specials` 0.0016419887542725
(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.0011749267578125
(47) DESCRIBE `cruiselines` 0.0027518272399902
(48) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0004270076751709
(49) DESCRIBE `orchid_image` 0.002065896987915
(50) DESCRIBE `cruiselines` 0.0024490356445312
(51) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00037193298339844
(52) DESCRIBE `cruises` 0.0034358501434326
(53) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41778') 0.00038313865661621
(54) DESCRIBE `ships` 0.0034451484680176
(55) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00048303604125977
(56) DESCRIBE `ships` 0.0035700798034668
(57) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00037813186645508
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035285949707031
(59) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034499168395996
(60) DESCRIBE `itineraries` 0.0017600059509277
(61) DESCRIBE `ports` 0.0018069744110107
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042295455932617
(63) DESCRIBE `ports` 0.0017437934875488
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038599967956543
(65) DESCRIBE `ports` 0.0017900466918945
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037193298339844
(67) DESCRIBE `sailingdates` 0.0016810894012451
(68) DESCRIBE `ports` 0.0018000602722168
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0005500316619873
(70) DESCRIBE `ports` 0.0017530918121338
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00045990943908691
(72) DESCRIBE `ports` 0.0018160343170166
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040793418884277
(74) DESCRIBE `ports` 0.0017800331115723
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036907196044922
(76) 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.0052840709686279
(77) DESCRIBE `avid_specials` 0.001774787902832
(78) 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.0014619827270508
(79) DESCRIBE `cruiselines` 0.0026888847351074
(80) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00049591064453125
(81) DESCRIBE `orchid_image` 0.0025749206542969
(82) DESCRIBE `cruiselines` 0.0024690628051758
(83) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00036716461181641
(84) DESCRIBE `cruises` 0.0032780170440674
(85) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50866') 0.00043392181396484
(86) DESCRIBE `ships` 0.0039131641387939
(87) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00073003768920898
(88) DESCRIBE `ships` 0.003493070602417
(89) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00038909912109375
(90) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00038313865661621
(91) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003509521484375
(92) DESCRIBE `itineraries` 0.0017619132995605
(93) DESCRIBE `ports` 0.0019230842590332
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042581558227539
(95) DESCRIBE `ports` 0.0020101070404053
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041699409484863
(97) DESCRIBE `ports` 0.0018370151519775
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037908554077148
(99) DESCRIBE `sailingdates` 0.0016319751739502
(100) DESCRIBE `ports` 0.0017960071563721
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041794776916504
(102) DESCRIBE `ports` 0.0017890930175781
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043916702270508
(104) DESCRIBE `ports` 0.0018420219421387
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0003960132598877
(106) DESCRIBE `ports` 0.0018730163574219
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00037693977355957
(108) DESCRIBE `ports` 0.0019130706787109
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00043201446533203
(110) DESCRIBE `ports` 0.0018820762634277
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00041413307189941
(112) DESCRIBE `ports` 0.0019280910491943
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00042200088500977
(114) DESCRIBE `ports` 0.0018808841705322
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00038504600524902
(116) DESCRIBE `ports` 0.0017960071563721
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049209594726562
(118) DESCRIBE `ports` 0.0019590854644775
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038313865661621
(120) 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.0054030418395996
(121) DESCRIBE `avid_specials` 0.0017580986022949
(122) 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.0011880397796631
(123) DESCRIBE `cruiselines` 0.0031328201293945
(124) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00066494941711426
(125) DESCRIBE `orchid_image` 0.0021259784698486
(126) DESCRIBE `cruiselines` 0.0027627944946289
(127) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00041604042053223
(128) DESCRIBE `cruises` 0.0035138130187988
(129) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63373') 0.00053715705871582
(130) DESCRIBE `ships` 0.0036110877990723
(131) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00050520896911621
(132) DESCRIBE `ships` 0.0037391185760498
(133) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00042510032653809
(134) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00043201446533203
(135) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00042390823364258
(136) DESCRIBE `itineraries` 0.0018711090087891
(137) DESCRIBE `ports` 0.0018391609191895
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042200088500977
(139) DESCRIBE `ports` 0.0017428398132324
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045108795166016
(141) DESCRIBE `ports` 0.0018279552459717
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003969669342041
(143) DESCRIBE `sailingdates` 0.0017440319061279
(144) DESCRIBE `ports` 0.001971960067749
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046396255493164
(146) DESCRIBE `ports` 0.0018188953399658
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00046896934509277
(148) DESCRIBE `ports` 0.0019590854644775
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00043606758117676
(150) DESCRIBE `ports` 0.0018749237060547
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00040102005004883
(152) DESCRIBE `ports` 0.0018620491027832
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00042009353637695
(154) DESCRIBE `ports` 0.0018308162689209
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00050687789916992
(156) DESCRIBE `ports` 0.002122163772583
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0004119873046875
(158) DESCRIBE `ports` 0.0022029876708984
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00063705444335938
(160) DESCRIBE `ports` 0.0019690990447998
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00046610832214355
(162) DESCRIBE `ports` 0.0019609928131104
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00043106079101562
(164) DESCRIBE `ports` 0.0019090175628662
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00041913986206055
(166) DESCRIBE `ports` 0.0019409656524658
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00045609474182129
(168) DESCRIBE `ports` 0.0023620128631592
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00062894821166992
(170) DESCRIBE `ports` 0.0026881694793701
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0005190372467041
(172) 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.0067830085754395
(173) DESCRIBE `avid_specials` 0.0016658306121826
(174) 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.001190185546875
(175) DESCRIBE `cruiselines` 0.0024850368499756
(176) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00040411949157715
(177) DESCRIBE `orchid_image` 0.0019450187683105
(178) DESCRIBE `cruiselines` 0.0023899078369141
(179) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00036191940307617
(180) DESCRIBE `cruises` 0.0045909881591797
(181) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55702') 0.00051116943359375
(182) DESCRIBE `ships` 0.0044760704040527
(183) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00045990943908691
(184) DESCRIBE `ships` 0.0043878555297852
(185) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00050616264343262
(186) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035881996154785
(187) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003509521484375
(188) DESCRIBE `itineraries` 0.0016989707946777
(189) DESCRIBE `ports` 0.0018069744110107
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042486190795898
(191) DESCRIBE `ports` 0.0018959045410156
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041007995605469
(193) DESCRIBE `ports` 0.0018210411071777
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040006637573242
(195) DESCRIBE `sailingdates` 0.0016238689422607
(196) DESCRIBE `ports` 0.001924991607666
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042605400085449
(198) DESCRIBE `ports` 0.0018391609191895
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044107437133789
(200) DESCRIBE `ports` 0.0018939971923828
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00041699409484863
(202) DESCRIBE `ports` 0.0018889904022217
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00052499771118164
(204) DESCRIBE `ports` 0.0019700527191162
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004279613494873
(206) DESCRIBE `ports` 0.0017490386962891
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039196014404297
(208) 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.006195068359375
(209) DESCRIBE `avid_specials` 0.0021300315856934
(210) 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.0020349025726318
(211) DESCRIBE `cruiselines` 0.0031850337982178
(212) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00063300132751465
(213) DESCRIBE `orchid_image` 0.0021679401397705
(214) DESCRIBE `cruiselines` 0.0026028156280518
(215) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00043511390686035
(216) DESCRIBE `cruises` 0.0034821033477783
(217) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70935') 0.00043892860412598
(218) DESCRIBE `ships` 0.0037729740142822
(219) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00071883201599121
(220) DESCRIBE `ships` 0.0037989616394043
(221) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00053811073303223
(222) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036001205444336
(223) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00041699409484863
(224) DESCRIBE `itineraries` 0.0019299983978271
(225) DESCRIBE `ports` 0.0022790431976318
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046014785766602
(227) DESCRIBE `ports` 0.0018439292907715
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004570484161377
(229) DESCRIBE `ports` 0.0018320083618164
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0004270076751709
(231) DESCRIBE `sailingdates` 0.0022721290588379
(232) DESCRIBE `ports` 0.0020551681518555
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00053787231445312
(234) DESCRIBE `ports` 0.0019378662109375
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00083708763122559
(236) DESCRIBE `ports` 0.0020129680633545
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0004580020904541
(238) DESCRIBE `ports` 0.0019450187683105
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00038599967956543
(240) DESCRIBE `ports` 0.0017790794372559
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00045490264892578
(242) DESCRIBE `ports` 0.0019171237945557
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00041079521179199
(244) DESCRIBE `ports` 0.0018389225006104
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00041389465332031
(246) DESCRIBE `ports` 0.001878023147583
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00037717819213867
(248) DESCRIBE `ports` 0.0018148422241211
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00047087669372559
(250) DESCRIBE `ports` 0.0022861957550049
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00062894821166992
(252) DESCRIBE `ports` 0.0026359558105469
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00061511993408203
(254) DESCRIBE `ports` 0.0023469924926758
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.0003960132598877
(256) DESCRIBE `ports` 0.0023500919342041
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047707557678223
(258) DESCRIBE `ports` 0.0019350051879883
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041890144348145
(260) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '70935') AND (sailingdate >= '2019-08-26') AND (sailingdate <= '2019-12-06') 0.005450963973999
(261) DESCRIBE `avid_specials` 0.0018229484558105
(262) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70935 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015017986297607
(263) DESCRIBE `cruiselines` 0.0027470588684082
(264) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00046300888061523
(265) DESCRIBE `orchid_image` 0.0019869804382324
(266) DESCRIBE `cruiselines` 0.0027511119842529
(267) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00055694580078125
(268) DESCRIBE `cruisetypes` 0.0023398399353027
(269) DESCRIBE `destinations` 0.002777099609375
(270) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('8', '43')) ORDER BY FIND_IN_SET(id, '8,43') 0.00087308883666992
(271) DESCRIBE `cruiselines` 0.0029840469360352
(272) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0004580020904541
(273) DESCRIBE `ships` 0.0049760341644287
(274) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00058603286743164
(275) DESCRIBE `cruiselines` 0.0038068294525146
(276) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00060105323791504
(277) DESCRIBE `ships` 0.0057079792022705
(278) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00070500373840332