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

Total elapsed time: 1.2180967330933

# Query Time
(1) connect 0.0049560070037842
(2) DESCRIBE `cruises` 0.020543813705444
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (76117, 76097, 69889, 76085, 76109, 76091, 76100, 62009, 76088, 56179)) ORDER BY FIND_IN_SET(id, '76117,76097,69889,76085,76109,76091,76100,62009,76088,56179') 0.0057299137115479
(4) DESCRIBE `cruises` 0.0040030479431152
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76117') 0.00040507316589355
(6) DESCRIBE `ships` 0.010205030441284
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00060009956359863
(8) DESCRIBE `ships` 0.00382399559021
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.0087559223175049
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036501884460449
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035500526428223
(12) DESCRIBE `itineraries` 0.0018880367279053
(13) DESCRIBE `ports` 0.0019750595092773
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00044417381286621
(15) DESCRIBE `ports` 0.0023438930511475
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.0073540210723877
(17) DESCRIBE `ports` 0.002007007598877
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.0003960132598877
(19) DESCRIBE `sailingdates` 0.0016679763793945
(20) DESCRIBE `ports` 0.0098278522491455
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00054383277893066
(22) DESCRIBE `ports` 0.0022399425506592
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00046586990356445
(24) DESCRIBE `ports` 0.0022211074829102
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00052404403686523
(26) DESCRIBE `ports` 0.0034148693084717
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00040197372436523
(28) DESCRIBE `ports` 0.0021660327911377
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.0031120777130127
(30) DESCRIBE `ports` 0.0094060897827148
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.0006718635559082
(32) DESCRIBE `ports` 0.0030210018157959
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00056099891662598
(34) DESCRIBE `ports` 0.0019052028656006
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.0049839019775391
(36) DESCRIBE `ports` 0.0020670890808105
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00041007995605469
(38) DESCRIBE `ports` 0.011350154876709
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00063991546630859
(40) DESCRIBE `ports` 0.0034370422363281
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00053501129150391
(42) DESCRIBE `ports` 0.0063560009002686
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00054597854614258
(44) DESCRIBE `ports` 0.0027921199798584
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00055909156799316
(46) DESCRIBE `ports` 0.002457857131958
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00044798851013184
(48) DESCRIBE `ports` 0.0019400119781494
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00042605400085449
(50) DESCRIBE `ports` 0.002392053604126
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00039196014404297
(52) DESCRIBE `ports` 0.0020871162414551
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044393539428711
(54) DESCRIBE `ports` 0.001884937286377
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036787986755371
(56) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '76117') AND (sailingdate >= '2019-09-20') AND (sailingdate <= '2020-04-21') 0.0086100101470947
(57) DESCRIBE `avid_specials` 0.0017240047454834
(58) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76117 and class = 'Cruise') OR (item_id = 287 AND class = 'Ship') OR (item_id = 26 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.0023860931396484
(59) DESCRIBE `cruiselines` 0.0027830600738525
(60) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.0005488395690918
(61) DESCRIBE `orchid_image` 0.0021791458129883
(62) DESCRIBE `cruiselines` 0.002640962600708
(63) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00044798851013184
(64) DESCRIBE `cruises` 0.0034971237182617
(65) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76097') 0.00038290023803711
(66) DESCRIBE `ships` 0.0042080879211426
(67) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00049400329589844
(68) DESCRIBE `ships` 0.0036759376525879
(69) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.0004279613494873
(70) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035810470581055
(71) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00040316581726074
(72) DESCRIBE `itineraries` 0.0017578601837158
(73) DESCRIBE `ports` 0.00211501121521
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00041890144348145
(75) DESCRIBE `ports` 0.0023441314697266
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00039911270141602
(77) DESCRIBE `ports` 0.0018000602722168
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.0003809928894043
(79) DESCRIBE `sailingdates` 0.0019419193267822
(80) DESCRIBE `ports` 0.0020320415496826
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00041985511779785
(82) DESCRIBE `ports` 0.0020699501037598
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00048398971557617
(84) DESCRIBE `ports` 0.002004861831665
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00041699409484863
(86) DESCRIBE `ports` 0.002112865447998
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00039005279541016
(88) DESCRIBE `ports` 0.0055279731750488
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00043892860412598
(90) DESCRIBE `ports` 0.010068893432617
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00047779083251953
(92) DESCRIBE `ports` 0.0019829273223877
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00043296813964844
(94) DESCRIBE `ports` 0.0070769786834717
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00039100646972656
(96) DESCRIBE `ports` 0.0021309852600098
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00069785118103027
(98) DESCRIBE `ports` 0.0072929859161377
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00044083595275879
(100) DESCRIBE `ports` 0.0023090839385986
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00037288665771484
(102) DESCRIBE `ports` 0.0018329620361328
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00038599967956543
(104) DESCRIBE `ports` 0.0018289089202881
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00047397613525391
(106) DESCRIBE `ports` 0.0029370784759521
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00042104721069336
(108) DESCRIBE `ports` 0.0017471313476562
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00042104721069336
(110) DESCRIBE `ports` 0.0018720626831055
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00038313865661621
(112) DESCRIBE `ports` 0.0019218921661377
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038719177246094
(114) DESCRIBE `ports` 0.0021610260009766
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044393539428711
(116) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '76097') AND (sailingdate >= '2019-09-20') AND (sailingdate <= '2020-04-21') 0.0058259963989258
(117) DESCRIBE `avid_specials` 0.002640962600708
(118) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76097 and class = 'Cruise') OR (item_id = 1330 AND class = 'Ship') OR (item_id = 26 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.0012421607971191
(119) DESCRIBE `cruiselines` 0.0026118755340576
(120) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00039792060852051
(121) DESCRIBE `orchid_image` 0.0020840167999268
(122) DESCRIBE `cruiselines` 0.0025579929351807
(123) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00036907196044922
(124) DESCRIBE `cruises` 0.0033321380615234
(125) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69889') 0.00040197372436523
(126) DESCRIBE `ships` 0.00347900390625
(127) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00043201446533203
(128) DESCRIBE `ships` 0.0037238597869873
(129) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.00061893463134766
(130) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003812313079834
(131) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037813186645508
(132) DESCRIBE `itineraries` 0.0018479824066162
(133) DESCRIBE `ports` 0.0021810531616211
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044488906860352
(135) DESCRIBE `ports` 0.0019140243530273
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004270076751709
(137) DESCRIBE `ports` 0.0018339157104492
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040197372436523
(139) DESCRIBE `sailingdates` 0.0021259784698486
(140) DESCRIBE `ports` 0.002748966217041
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0005648136138916
(142) DESCRIBE `ports` 0.0021600723266602
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00050210952758789
(144) DESCRIBE `ports` 0.0031731128692627
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044417381286621
(146) DESCRIBE `ports` 0.0078580379486084
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040388107299805
(148) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69889') AND (sailingdate >= '2019-09-20') AND (sailingdate <= '2020-04-21') 0.0070462226867676
(149) DESCRIBE `avid_specials` 0.011120796203613
(150) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69889 and class = 'Cruise') OR (item_id = 287 AND class = 'Ship') OR (item_id = 26 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.0013971328735352
(151) DESCRIBE `cruiselines` 0.0088670253753662
(152) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00046586990356445
(153) DESCRIBE `orchid_image` 0.0019989013671875
(154) DESCRIBE `cruiselines` 0.0025770664215088
(155) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00037288665771484
(156) DESCRIBE `cruises` 0.003389835357666
(157) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76085') 0.0010099411010742
(158) DESCRIBE `ships` 0.0058579444885254
(159) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00049304962158203
(160) DESCRIBE `ships` 0.0036048889160156
(161) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.0034961700439453
(162) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035381317138672
(163) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034403800964355
(164) DESCRIBE `itineraries` 0.010489940643311
(165) DESCRIBE `ports` 0.0020580291748047
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045895576477051
(167) DESCRIBE `ports` 0.0019171237945557
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0064690113067627
(169) DESCRIBE `ports` 0.0019669532775879
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039196014404297
(171) DESCRIBE `sailingdates` 0.0018539428710938
(172) DESCRIBE `ports` 0.0018179416656494
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040888786315918
(174) DESCRIBE `ports` 0.0076639652252197
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036406517028809
(176) DESCRIBE `ports` 0.0021719932556152
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00041580200195312
(178) DESCRIBE `ports` 0.0018661022186279
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00038409233093262
(180) DESCRIBE `ports` 0.0018248558044434
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00043177604675293
(182) DESCRIBE `ports` 0.0017368793487549
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00037598609924316
(184) DESCRIBE `ports` 0.002338171005249
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00058102607727051
(186) DESCRIBE `ports` 0.0020098686218262
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00044488906860352
(188) DESCRIBE `ports` 0.0074100494384766
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00039386749267578
(190) DESCRIBE `ports` 0.0019629001617432
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00036811828613281
(192) DESCRIBE `ports` 0.0019190311431885
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.0080990791320801
(194) DESCRIBE `ports` 0.0079429149627686
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00037980079650879
(196) DESCRIBE `ports` 0.001751184463501
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00043010711669922
(198) DESCRIBE `ports` 0.0024700164794922
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.0005500316619873
(200) DESCRIBE `ports` 0.0020408630371094
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004580020904541
(202) DESCRIBE `ports` 0.0021100044250488
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00046610832214355
(204) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '76085') AND (sailingdate >= '2019-09-20') AND (sailingdate <= '2020-04-21') 0.00736403465271
(205) DESCRIBE `avid_specials` 0.011403799057007
(206) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76085 and class = 'Cruise') OR (item_id = 1330 AND class = 'Ship') OR (item_id = 26 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.0087888240814209
(207) DESCRIBE `cruiselines` 0.0087010860443115
(208) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.0004119873046875
(209) DESCRIBE `orchid_image` 0.0022339820861816
(210) DESCRIBE `cruiselines` 0.011731863021851
(211) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00038290023803711
(212) DESCRIBE `cruises` 0.012439966201782
(213) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76109') 0.00055694580078125
(214) DESCRIBE `ships` 0.0036520957946777
(215) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00042009353637695
(216) DESCRIBE `ships` 0.0034408569335938
(217) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.00034999847412109
(218) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0064258575439453
(219) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035619735717773
(220) DESCRIBE `itineraries` 0.0018138885498047
(221) DESCRIBE `ports` 0.0017910003662109
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039887428283691
(223) DESCRIBE `ports` 0.0019819736480713
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046992301940918
(225) DESCRIBE `ports` 0.0075700283050537
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037693977355957
(227) DESCRIBE `sailingdates` 0.0016047954559326
(228) DESCRIBE `ports` 0.0017979145050049
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043487548828125
(230) DESCRIBE `ports` 0.0017430782318115
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036501884460449
(232) DESCRIBE `ports` 0.002007007598877
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00038504600524902
(234) DESCRIBE `ports` 0.0019478797912598
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00047397613525391
(236) DESCRIBE `ports` 0.0021281242370605
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00037598609924316
(238) DESCRIBE `ports` 0.0019090175628662
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00035405158996582
(240) DESCRIBE `ports` 0.0017828941345215
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.00039505958557129
(242) DESCRIBE `ports` 0.0017960071563721
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.00037097930908203
(244) DESCRIBE `ports` 0.0021491050720215
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00040102005004883
(246) DESCRIBE `ports` 0.0024361610412598
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00048303604125977
(248) DESCRIBE `ports` 0.0025050640106201
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048494338989258
(250) DESCRIBE `ports` 0.0024650096893311
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037598609924316
(252) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '76109') AND (sailingdate >= '2019-09-20') AND (sailingdate <= '2020-04-21') 0.0058081150054932
(253) DESCRIBE `avid_specials` 0.0026710033416748
(254) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76109 and class = 'Cruise') OR (item_id = 287 AND class = 'Ship') OR (item_id = 26 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.0012569427490234
(255) DESCRIBE `cruiselines` 0.0025429725646973
(256) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00041890144348145
(257) DESCRIBE `orchid_image` 0.0026299953460693
(258) DESCRIBE `cruiselines` 0.0034940242767334
(259) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00046396255493164
(260) DESCRIBE `cruises` 0.0037789344787598
(261) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76091') 0.00045013427734375
(262) DESCRIBE `ships` 0.0036489963531494
(263) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00070905685424805
(264) DESCRIBE `ships` 0.0056819915771484
(265) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00045895576477051
(266) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035500526428223
(267) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034594535827637
(268) DESCRIBE `itineraries` 0.0020239353179932
(269) DESCRIBE `ports` 0.0070619583129883
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044012069702148
(271) DESCRIBE `ports` 0.010581970214844
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039815902709961
(273) DESCRIBE `ports` 0.0023720264434814
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037693977355957
(275) DESCRIBE `sailingdates` 0.0020871162414551
(276) DESCRIBE `ports` 0.0017900466918945
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048208236694336
(278) DESCRIBE `ports` 0.0017991065979004
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037407875061035
(280) DESCRIBE `ports` 0.0018942356109619
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00048398971557617
(282) DESCRIBE `ports` 0.0021538734436035
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00066494941711426
(284) DESCRIBE `ports` 0.0084459781646729
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00044012069702148
(286) DESCRIBE `ports` 0.0023789405822754
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0023469924926758
(288) DESCRIBE `ports` 0.0022470951080322
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00041508674621582
(290) DESCRIBE `ports` 0.0019230842590332
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00037598609924316
(292) DESCRIBE `ports` 0.0026290416717529
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00067806243896484
(294) DESCRIBE `ports` 0.0018508434295654
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.0003819465637207
(296) DESCRIBE `ports` 0.0018510818481445
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00039505958557129
(298) DESCRIBE `ports` 0.0020740032196045
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.0004580020904541
(300) DESCRIBE `ports` 0.0025680065155029
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00057196617126465
(302) DESCRIBE `ports` 0.0025379657745361
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00056195259094238
(304) DESCRIBE `ports` 0.0019009113311768
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00040507316589355
(306) DESCRIBE `ports` 0.0019528865814209
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00044703483581543
(308) DESCRIBE `ports` 0.0034089088439941
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00047016143798828
(310) DESCRIBE `ports` 0.0018129348754883
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00038409233093262
(312) DESCRIBE `ports` 0.0020320415496826
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004119873046875
(314) DESCRIBE `ports` 0.0019609928131104
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00046586990356445
(316) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '76091') AND (sailingdate >= '2019-09-20') AND (sailingdate <= '2020-04-21') 0.0058059692382812
(317) DESCRIBE `avid_specials` 0.0016899108886719
(318) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76091 and class = 'Cruise') OR (item_id = 1330 AND class = 'Ship') OR (item_id = 26 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.001460075378418
(319) DESCRIBE `cruiselines` 0.0024948120117188
(320) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00040507316589355
(321) DESCRIBE `orchid_image` 0.0019240379333496
(322) DESCRIBE `cruiselines` 0.0030879974365234
(323) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00042319297790527
(324) DESCRIBE `cruises` 0.0033950805664062
(325) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76100') 0.00040102005004883
(326) DESCRIBE `ships` 0.0035679340362549
(327) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.0004570484161377
(328) DESCRIBE `ships` 0.0035889148712158
(329) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.00036311149597168
(330) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003659725189209
(331) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034785270690918
(332) DESCRIBE `itineraries` 0.0018830299377441
(333) DESCRIBE `ports` 0.0018241405487061
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041007995605469
(335) DESCRIBE `ports` 0.002039909362793
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004420280456543
(337) DESCRIBE `ports` 0.002140998840332
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043392181396484
(339) DESCRIBE `sailingdates` 0.0026509761810303
(340) DESCRIBE `ports` 0.045192956924438
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0005190372467041
(342) DESCRIBE `ports` 0.0033130645751953
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042605400085449
(344) DESCRIBE `ports` 0.0019500255584717
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00043106079101562
(346) DESCRIBE `ports` 0.0023841857910156
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00087618827819824
(348) DESCRIBE `ports` 0.0019588470458984
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00046586990356445
(350) DESCRIBE `ports` 0.0082869529724121
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.0005800724029541
(352) DESCRIBE `ports` 0.002593994140625
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00042891502380371
(354) DESCRIBE `ports` 0.0087430477142334
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00071096420288086
(356) DESCRIBE `ports` 0.0026009082794189
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.000640869140625
(358) DESCRIBE `ports` 0.0022070407867432
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00048685073852539
(360) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '76100') AND (sailingdate >= '2019-09-20') AND (sailingdate <= '2020-04-21') 0.0066587924957275
(361) DESCRIBE `avid_specials` 0.0024850368499756
(362) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76100 and class = 'Cruise') OR (item_id = 287 AND class = 'Ship') OR (item_id = 26 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.0020430088043213
(363) DESCRIBE `cruiselines` 0.010995864868164
(364) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00048518180847168
(365) DESCRIBE `orchid_image` 0.0031778812408447
(366) DESCRIBE `cruiselines` 0.012042045593262
(367) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00055217742919922
(368) DESCRIBE `cruises` 0.0043950080871582
(369) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62009') 0.0070137977600098
(370) DESCRIBE `ships` 0.0045630931854248
(371) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.0008080005645752
(372) DESCRIBE `ships` 0.012892961502075
(373) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00047898292541504
(374) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036382675170898
(375) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035190582275391
(376) DESCRIBE `itineraries` 0.0017590522766113
(377) DESCRIBE `ports` 0.0018711090087891
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043320655822754
(379) DESCRIBE `ports` 0.0020098686218262
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038695335388184
(381) DESCRIBE `ports` 0.0024740695953369
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038313865661621
(383) DESCRIBE `sailingdates` 0.0015530586242676
(384) DESCRIBE `ports` 0.0020101070404053
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049209594726562
(386) DESCRIBE `ports` 0.0018560886383057
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038290023803711
(388) DESCRIBE `ports` 0.0021328926086426
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042104721069336
(390) DESCRIBE `ports` 0.0035331249237061
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00076484680175781
(392) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62009') AND (sailingdate >= '2019-09-20') AND (sailingdate <= '2020-04-21') 0.0060851573944092
(393) DESCRIBE `avid_specials` 0.0017490386962891
(394) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62009 and class = 'Cruise') OR (item_id = 1330 AND class = 'Ship') OR (item_id = 26 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.0013759136199951
(395) DESCRIBE `cruiselines` 0.0025510787963867
(396) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00043010711669922
(397) DESCRIBE `orchid_image` 0.002249002456665
(398) DESCRIBE `cruiselines` 0.0081491470336914
(399) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00049304962158203
(400) DESCRIBE `cruises` 0.013298988342285
(401) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76088') 0.00051784515380859
(402) DESCRIBE `ships` 0.0035779476165771
(403) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00052118301391602
(404) DESCRIBE `ships` 0.0038411617279053
(405) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.0006568431854248
(406) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00051307678222656
(407) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00052785873413086
(408) DESCRIBE `itineraries` 0.012753009796143
(409) DESCRIBE `ports` 0.0027270317077637
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00052690505981445
(411) DESCRIBE `ports` 0.0024971961975098
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043916702270508
(413) DESCRIBE `ports` 0.0025181770324707
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038790702819824
(415) DESCRIBE `sailingdates` 0.0016689300537109
(416) DESCRIBE `ports` 0.0018649101257324
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049781799316406
(418) DESCRIBE `ports` 0.0018179416656494
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037813186645508
(420) DESCRIBE `ports` 0.00223708152771
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00057888031005859
(422) DESCRIBE `ports` 0.0019609928131104
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00045490264892578
(424) DESCRIBE `ports` 0.0022540092468262
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00045013427734375
(426) DESCRIBE `ports` 0.0044558048248291
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.0010561943054199
(428) DESCRIBE `ports` 0.0025420188903809
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00043678283691406
(430) DESCRIBE `ports` 0.0029981136322021
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.0020091533660889
(432) DESCRIBE `ports` 0.0047798156738281
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.0043458938598633
(434) DESCRIBE `ports` 0.0025241374969482
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.0021331310272217
(436) DESCRIBE `ports` 0.004004955291748
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.0020110607147217
(438) DESCRIBE `ports` 0.0021421909332275
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00051116943359375
(440) DESCRIBE `ports` 0.0018811225891113
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00042414665222168
(442) DESCRIBE `ports` 0.0020620822906494
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.0011649131774902
(444) DESCRIBE `ports` 0.0019981861114502
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00044012069702148
(446) DESCRIBE `ports` 0.0018479824066162
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00040006637573242
(448) DESCRIBE `ports` 0.0018019676208496
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004580020904541
(450) DESCRIBE `ports` 0.0018479824066162
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00047802925109863
(452) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '76088') AND (sailingdate >= '2019-09-20') AND (sailingdate <= '2020-04-21') 0.0065250396728516
(453) DESCRIBE `avid_specials` 0.0017759799957275
(454) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76088 and class = 'Cruise') OR (item_id = 1330 AND class = 'Ship') OR (item_id = 26 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.0012099742889404
(455) DESCRIBE `cruiselines` 0.0061490535736084
(456) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00049400329589844
(457) DESCRIBE `orchid_image` 0.0025408267974854
(458) DESCRIBE `cruiselines` 0.0028650760650635
(459) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00038290023803711
(460) DESCRIBE `cruises` 0.0035600662231445
(461) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56179') 0.00065207481384277
(462) DESCRIBE `ships` 0.0045819282531738
(463) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 124))) 0.00059700012207031
(464) DESCRIBE `ships` 0.0037500858306885
(465) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '124') 0.00043916702270508
(466) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036001205444336
(467) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034999847412109
(468) DESCRIBE `itineraries` 0.0019009113311768
(469) DESCRIBE `ports` 0.0023279190063477
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00046086311340332
(471) DESCRIBE `ports` 0.0024969577789307
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00042104721069336
(473) DESCRIBE `ports` 0.0027749538421631
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00041484832763672
(475) DESCRIBE `sailingdates` 0.0024700164794922
(476) DESCRIBE `ports` 0.0029680728912354
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00047898292541504
(478) DESCRIBE `ports` 0.0020451545715332
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00056791305541992
(480) DESCRIBE `ports` 0.0026669502258301
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00051712989807129
(482) DESCRIBE `ports` 0.0022480487823486
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00064301490783691
(484) DESCRIBE `ports` 0.01131796836853
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2751))) 0.0025119781494141
(486) DESCRIBE `ports` 0.0060851573944092
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2751') 0.00048422813415527
(488) DESCRIBE `ports` 0.0018050670623779
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.0050370693206787
(490) DESCRIBE `ports` 0.0021097660064697
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.0004279613494873
(492) DESCRIBE `ports` 0.0018610954284668
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0028591156005859
(494) DESCRIBE `ports` 0.0018801689147949
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00040197372436523
(496) DESCRIBE `ports` 0.0017440319061279
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00052213668823242
(498) DESCRIBE `ports` 0.0018570423126221
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00047516822814941
(500) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '56179') AND (sailingdate >= '2019-09-20') AND (sailingdate <= '2020-04-21') 0.0063230991363525
(501) DESCRIBE `avid_specials` 0.0020139217376709
(502) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56179 and class = 'Cruise') OR (item_id = 124 AND class = 'Ship') OR (item_id = 26 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.0012450218200684
(503) DESCRIBE `cruiselines` 0.0025379657745361
(504) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00049304962158203
(505) DESCRIBE `orchid_image` 0.0021359920501709
(506) DESCRIBE `cruiselines` 0.0025131702423096
(507) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00037908554077148
(508) DESCRIBE `ships` 0.0046069622039795
(509) SELECT `ships`.* FROM `ships` WHERE (id IN ('1330', '124', '287')) ORDER BY FIND_IN_SET(id, '1330,124,287') 0.0010471343994141
(510) DESCRIBE `cruisetypes` 0.0016410350799561
(511) DESCRIBE `destinations` 0.0031628608703613
(512) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.00087690353393555
(513) DESCRIBE `cruiselines` 0.0034668445587158
(514) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00046586990356445
(515) DESCRIBE `cruiselines` 0.0034539699554443
(516) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00069093704223633
(517) DESCRIBE `ports` 0.0026698112487793
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00052905082702637