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

Total elapsed time: 0.79997730255127

# Query Time
(1) connect 0.0022048950195312
(2) DESCRIBE `cruises` 0.0062241554260254
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (76085, 76109, 76091, 76100, 62009, 76088, 56179, 76102, 76089, 76101)) ORDER BY FIND_IN_SET(id, '76085,76109,76091,76100,62009,76088,56179,76102,76089,76101') 0.0022439956665039
(4) DESCRIBE `cruises` 0.0047259330749512
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76085') 0.00054192543029785
(6) DESCRIBE `ships` 0.0046448707580566
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00087499618530273
(8) DESCRIBE `ships` 0.0050251483917236
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00074195861816406
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00054216384887695
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0004889965057373
(12) DESCRIBE `itineraries` 0.0028550624847412
(13) DESCRIBE `ports` 0.0030431747436523
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00065517425537109
(15) DESCRIBE `ports` 0.0029239654541016
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00069403648376465
(17) DESCRIBE `ports` 0.002424955368042
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00058197975158691
(19) DESCRIBE `sailingdates` 0.0022900104522705
(20) DESCRIBE `ports` 0.0031719207763672
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00074005126953125
(22) DESCRIBE `ports` 0.0031490325927734
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00081491470336914
(24) DESCRIBE `ports` 0.0029740333557129
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00072002410888672
(26) DESCRIBE `ports` 0.0030899047851562
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00072097778320312
(28) DESCRIBE `ports` 0.0030770301818848
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00075197219848633
(30) DESCRIBE `ports` 0.0029520988464355
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00066113471984863
(32) DESCRIBE `ports` 0.0029737949371338
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.0007331371307373
(34) DESCRIBE `ports` 0.003032922744751
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00065302848815918
(36) DESCRIBE `ports` 0.0029869079589844
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00075101852416992
(38) DESCRIBE `ports` 0.0032389163970947
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00067710876464844
(40) DESCRIBE `ports` 0.0029270648956299
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.0006709098815918
(42) DESCRIBE `ports` 0.0030219554901123
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00064206123352051
(44) DESCRIBE `ports` 0.0027849674224854
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.0007178783416748
(46) DESCRIBE `ports` 0.0027568340301514
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00058102607727051
(48) DESCRIBE `ports` 0.0029878616333008
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00063085556030273
(50) DESCRIBE `ports` 0.0020060539245605
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003969669342041
(52) 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.0077440738677979
(53) DESCRIBE `avid_specials` 0.0022110939025879
(54) 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.0011930465698242
(55) DESCRIBE `cruiselines` 0.0028359889984131
(56) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00057196617126465
(57) DESCRIBE `orchid_image` 0.0025198459625244
(58) DESCRIBE `cruiselines` 0.002892017364502
(59) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00041294097900391
(60) DESCRIBE `cruises` 0.0034000873565674
(61) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76109') 0.0004420280456543
(62) DESCRIBE `ships` 0.0039079189300537
(63) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.000640869140625
(64) DESCRIBE `ships` 0.0036129951477051
(65) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.00037312507629395
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00040912628173828
(67) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037002563476562
(68) DESCRIBE `itineraries` 0.0019710063934326
(69) DESCRIBE `ports` 0.0019922256469727
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044894218444824
(71) DESCRIBE `ports` 0.0020389556884766
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046706199645996
(73) DESCRIBE `ports` 0.0020170211791992
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00045394897460938
(75) DESCRIBE `sailingdates` 0.0018072128295898
(76) DESCRIBE `ports` 0.0019729137420654
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047993659973145
(78) DESCRIBE `ports` 0.0019159317016602
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0004580020904541
(80) DESCRIBE `ports` 0.0017960071563721
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00040793418884277
(82) DESCRIBE `ports` 0.0018618106842041
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00059390068054199
(84) DESCRIBE `ports` 0.0024878978729248
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0005800724029541
(86) DESCRIBE `ports` 0.0018150806427002
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00040793418884277
(88) DESCRIBE `ports` 0.0017738342285156
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.00041007995605469
(90) DESCRIBE `ports` 0.0021209716796875
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.00040602684020996
(92) DESCRIBE `ports` 0.0018060207366943
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00043797492980957
(94) DESCRIBE `ports` 0.0017490386962891
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00037002563476562
(96) DESCRIBE `ports` 0.0017571449279785
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038695335388184
(98) DESCRIBE `ports` 0.0018141269683838
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037097930908203
(100) 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.005403995513916
(101) DESCRIBE `avid_specials` 0.0016858577728271
(102) 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.0011029243469238
(103) DESCRIBE `cruiselines` 0.0025730133056641
(104) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00045108795166016
(105) DESCRIBE `orchid_image` 0.0019919872283936
(106) DESCRIBE `cruiselines` 0.0025300979614258
(107) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00046992301940918
(108) DESCRIBE `cruises` 0.0036048889160156
(109) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76091') 0.00043892860412598
(110) DESCRIBE `ships` 0.0036449432373047
(111) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00050902366638184
(112) DESCRIBE `ships` 0.0034499168395996
(113) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00044083595275879
(114) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035285949707031
(115) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034189224243164
(116) DESCRIBE `itineraries` 0.0022461414337158
(117) DESCRIBE `ports` 0.0018489360809326
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043988227844238
(119) DESCRIBE `ports` 0.0017869472503662
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040006637573242
(121) DESCRIBE `ports` 0.0019130706787109
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043416023254395
(123) DESCRIBE `sailingdates` 0.0015978813171387
(124) DESCRIBE `ports` 0.0019669532775879
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046491622924805
(126) DESCRIBE `ports` 0.0020179748535156
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039505958557129
(128) DESCRIBE `ports` 0.0019900798797607
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00042414665222168
(130) DESCRIBE `ports` 0.0018689632415771
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00039792060852051
(132) DESCRIBE `ports` 0.0024089813232422
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00040984153747559
(134) DESCRIBE `ports` 0.0019228458404541
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00037813186645508
(136) DESCRIBE `ports` 0.0021250247955322
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00043511390686035
(138) DESCRIBE `ports` 0.0022399425506592
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00040411949157715
(140) DESCRIBE `ports` 0.0018069744110107
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.0004270076751709
(142) DESCRIBE `ports` 0.0021049976348877
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00040102005004883
(144) DESCRIBE `ports` 0.0019471645355225
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00043797492980957
(146) DESCRIBE `ports` 0.0018000602722168
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00045418739318848
(148) DESCRIBE `ports` 0.0018279552459717
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00046682357788086
(150) DESCRIBE `ports` 0.0018391609191895
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00038409233093262
(152) DESCRIBE `ports` 0.0019290447235107
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00058412551879883
(154) DESCRIBE `ports` 0.0025510787963867
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00039482116699219
(156) DESCRIBE `ports` 0.0018210411071777
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.0003969669342041
(158) DESCRIBE `ports` 0.0018069744110107
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00052213668823242
(160) DESCRIBE `ports` 0.0020499229431152
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043916702270508
(162) DESCRIBE `ports` 0.0018088817596436
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037908554077148
(164) 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.0054800510406494
(165) DESCRIBE `avid_specials` 0.0018281936645508
(166) 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.0011849403381348
(167) DESCRIBE `cruiselines` 0.002601146697998
(168) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00043296813964844
(169) DESCRIBE `orchid_image` 0.002018928527832
(170) DESCRIBE `cruiselines` 0.002622127532959
(171) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00043916702270508
(172) DESCRIBE `cruises` 0.0035037994384766
(173) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76100') 0.00044798851013184
(174) DESCRIBE `ships` 0.0034890174865723
(175) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00045204162597656
(176) DESCRIBE `ships` 0.0035290718078613
(177) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.00045609474182129
(178) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00042605400085449
(179) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003509521484375
(180) DESCRIBE `itineraries` 0.0017518997192383
(181) DESCRIBE `ports` 0.0017998218536377
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041103363037109
(183) DESCRIBE `ports` 0.0020101070404053
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00053596496582031
(185) DESCRIBE `ports` 0.0020971298217773
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038695335388184
(187) DESCRIBE `sailingdates` 0.0016238689422607
(188) DESCRIBE `ports` 0.0019619464874268
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046992301940918
(190) DESCRIBE `ports` 0.0018630027770996
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041890144348145
(192) DESCRIBE `ports` 0.001816987991333
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00041604042053223
(194) DESCRIBE `ports` 0.0018680095672607
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00037598609924316
(196) DESCRIBE `ports` 0.001737117767334
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00045919418334961
(198) DESCRIBE `ports` 0.0018761157989502
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00037813186645508
(200) DESCRIBE `ports` 0.0017731189727783
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00041413307189941
(202) DESCRIBE `ports` 0.0017719268798828
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00037693977355957
(204) DESCRIBE `ports` 0.0018839836120605
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042414665222168
(206) DESCRIBE `ports` 0.0017869472503662
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037598609924316
(208) 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.0059099197387695
(209) DESCRIBE `avid_specials` 0.0019011497497559
(210) 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.0013649463653564
(211) DESCRIBE `cruiselines` 0.0028700828552246
(212) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00048494338989258
(213) DESCRIBE `orchid_image` 0.0020871162414551
(214) DESCRIBE `cruiselines` 0.0027289390563965
(215) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00042915344238281
(216) DESCRIBE `cruises` 0.0035178661346436
(217) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62009') 0.00043296813964844
(218) DESCRIBE `ships` 0.0035970211029053
(219) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00055384635925293
(220) DESCRIBE `ships` 0.0038228034973145
(221) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00047802925109863
(222) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003659725189209
(223) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003509521484375
(224) DESCRIBE `itineraries` 0.0018270015716553
(225) DESCRIBE `ports` 0.0017838478088379
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0005030632019043
(227) DESCRIBE `ports` 0.0017890930175781
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00052189826965332
(229) DESCRIBE `ports` 0.0019700527191162
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038886070251465
(231) DESCRIBE `sailingdates` 0.0016341209411621
(232) DESCRIBE `ports` 0.0024969577789307
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00053787231445312
(234) DESCRIBE `ports` 0.0020198822021484
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043702125549316
(236) DESCRIBE `ports` 0.0022501945495605
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00059318542480469
(238) DESCRIBE `ports` 0.002155065536499
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040507316589355
(240) 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.0054330825805664
(241) DESCRIBE `avid_specials` 0.0021119117736816
(242) 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.0013761520385742
(243) DESCRIBE `cruiselines` 0.0030660629272461
(244) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00046014785766602
(245) DESCRIBE `orchid_image` 0.0029101371765137
(246) DESCRIBE `cruiselines` 0.0038731098175049
(247) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00053501129150391
(248) DESCRIBE `cruises` 0.003917932510376
(249) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76088') 0.00045490264892578
(250) DESCRIBE `ships` 0.0045959949493408
(251) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00062799453735352
(252) DESCRIBE `ships` 0.0036180019378662
(253) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00051188468933105
(254) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036787986755371
(255) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035381317138672
(256) DESCRIBE `itineraries` 0.0017919540405273
(257) DESCRIBE `ports` 0.0018241405487061
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045490264892578
(259) DESCRIBE `ports` 0.0017838478088379
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042986869812012
(261) DESCRIBE `ports` 0.0017459392547607
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00046491622924805
(263) DESCRIBE `sailingdates` 0.0016689300537109
(264) DESCRIBE `ports` 0.0018541812896729
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045108795166016
(266) DESCRIBE `ports` 0.0017759799957275
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037622451782227
(268) DESCRIBE `ports` 0.0017359256744385
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00041103363037109
(270) DESCRIBE `ports` 0.0018661022186279
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00038003921508789
(272) DESCRIBE `ports` 0.0017931461334229
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00040984153747559
(274) DESCRIBE `ports` 0.0018689632415771
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00037813186645508
(276) DESCRIBE `ports` 0.0018289089202881
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00042915344238281
(278) DESCRIBE `ports` 0.0017321109771729
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00037407875061035
(280) DESCRIBE `ports` 0.0018069744110107
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00042915344238281
(282) DESCRIBE `ports` 0.0017578601837158
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00039315223693848
(284) DESCRIBE `ports` 0.0018129348754883
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00053095817565918
(286) DESCRIBE `ports` 0.0018420219421387
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00037312507629395
(288) DESCRIBE `ports` 0.0018620491027832
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00038981437683105
(290) DESCRIBE `ports` 0.002371072769165
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00046491622924805
(292) DESCRIBE `ports` 0.0019979476928711
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00042295455932617
(294) DESCRIBE `ports` 0.0018329620361328
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00046706199645996
(296) DESCRIBE `ports` 0.0017499923706055
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044393539428711
(298) DESCRIBE `ports` 0.0018219947814941
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037407875061035
(300) 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.0054459571838379
(301) DESCRIBE `avid_specials` 0.0022470951080322
(302) 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.0012359619140625
(303) DESCRIBE `cruiselines` 0.0024969577789307
(304) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00046706199645996
(305) DESCRIBE `orchid_image` 0.0019581317901611
(306) DESCRIBE `cruiselines` 0.0026288032531738
(307) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00043797492980957
(308) DESCRIBE `cruises` 0.0037939548492432
(309) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56179') 0.00046610832214355
(310) DESCRIBE `ships` 0.0035758018493652
(311) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 124))) 0.00066614151000977
(312) DESCRIBE `ships` 0.0039210319519043
(313) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '124') 0.00038790702819824
(314) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035810470581055
(315) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003809928894043
(316) DESCRIBE `itineraries` 0.0017549991607666
(317) DESCRIBE `ports` 0.0018539428710938
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0004570484161377
(319) DESCRIBE `ports` 0.0017621517181396
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00046300888061523
(321) DESCRIBE `ports` 0.0017991065979004
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00037479400634766
(323) DESCRIBE `sailingdates` 0.0016798973083496
(324) DESCRIBE `ports` 0.0017828941345215
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00056290626525879
(326) DESCRIBE `ports` 0.0017549991607666
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0004270076751709
(328) DESCRIBE `ports` 0.0017900466918945
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00043201446533203
(330) DESCRIBE `ports` 0.0021798610687256
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00051498413085938
(332) DESCRIBE `ports` 0.0018908977508545
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2751))) 0.00054788589477539
(334) DESCRIBE `ports` 0.0019679069519043
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2751') 0.00048708915710449
(336) DESCRIBE `ports` 0.0018219947814941
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.0005640983581543
(338) DESCRIBE `ports` 0.0018279552459717
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00039291381835938
(340) DESCRIBE `ports` 0.0018279552459717
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00051188468933105
(342) DESCRIBE `ports` 0.0019750595092773
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00044798851013184
(344) DESCRIBE `ports` 0.0019528865814209
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047898292541504
(346) DESCRIBE `ports` 0.0020511150360107
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041794776916504
(348) 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.005640983581543
(349) DESCRIBE `avid_specials` 0.0019431114196777
(350) 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.0013070106506348
(351) DESCRIBE `cruiselines` 0.0027148723602295
(352) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00045895576477051
(353) DESCRIBE `orchid_image` 0.001971960067749
(354) DESCRIBE `cruiselines` 0.0028719902038574
(355) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00044703483581543
(356) DESCRIBE `cruises` 0.0037548542022705
(357) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76102') 0.00046300888061523
(358) DESCRIBE `ships` 0.0042390823364258
(359) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00049710273742676
(360) DESCRIBE `ships` 0.0035040378570557
(361) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.00037312507629395
(362) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036001205444336
(363) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034904479980469
(364) DESCRIBE `itineraries` 0.0018289089202881
(365) DESCRIBE `ports` 0.0019121170043945
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045204162597656
(367) DESCRIBE `ports` 0.0018148422241211
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040888786315918
(369) DESCRIBE `ports` 0.0017759799957275
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0004570484161377
(371) DESCRIBE `sailingdates` 0.0016169548034668
(372) DESCRIBE `ports` 0.0018959045410156
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044798851013184
(374) DESCRIBE `ports` 0.001845121383667
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038409233093262
(376) DESCRIBE `ports` 0.0018711090087891
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00041794776916504
(378) DESCRIBE `ports` 0.002018928527832
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00039005279541016
(380) DESCRIBE `ports` 0.0019819736480713
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00044584274291992
(382) DESCRIBE `ports` 0.0020370483398438
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00040793418884277
(384) DESCRIBE `ports` 0.0025241374969482
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.0004429817199707
(386) DESCRIBE `ports` 0.0019450187683105
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00040888786315918
(388) DESCRIBE `ports` 0.0019168853759766
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00051403045654297
(390) DESCRIBE `ports` 0.0018041133880615
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00039196014404297
(392) DESCRIBE `ports` 0.0020301342010498
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00076413154602051
(394) DESCRIBE `ports` 0.0029921531677246
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.0006108283996582
(396) DESCRIBE `ports` 0.0019941329956055
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00042605400085449
(398) DESCRIBE `ports` 0.0018692016601562
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00044989585876465
(400) DESCRIBE `ports` 0.0017900466918945
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.0004570484161377
(402) DESCRIBE `ports` 0.001845121383667
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00040602684020996
(404) DESCRIBE `ports` 0.0017938613891602
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043606758117676
(406) DESCRIBE `ports` 0.0017960071563721
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039005279541016
(408) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '76102') AND (sailingdate >= '2019-09-20') AND (sailingdate <= '2020-04-21') 0.0061829090118408
(409) DESCRIBE `avid_specials` 0.0024561882019043
(410) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76102 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.0021708011627197
(411) DESCRIBE `cruiselines` 0.0026299953460693
(412) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00043702125549316
(413) DESCRIBE `orchid_image` 0.0020229816436768
(414) DESCRIBE `cruiselines` 0.0025351047515869
(415) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00038695335388184
(416) DESCRIBE `cruises` 0.0033800601959229
(417) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76089') 0.00040292739868164
(418) DESCRIBE `ships` 0.0035369396209717
(419) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00054097175598145
(420) DESCRIBE `ships` 0.0034990310668945
(421) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00047802925109863
(422) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035595893859863
(423) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00044798851013184
(424) DESCRIBE `itineraries` 0.0017859935760498
(425) DESCRIBE `ports` 0.0018179416656494
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043606758117676
(427) DESCRIBE `ports` 0.0017549991607666
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004270076751709
(429) DESCRIBE `ports` 0.0018489360809326
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040507316589355
(431) DESCRIBE `sailingdates` 0.0016858577728271
(432) DESCRIBE `ports` 0.0017940998077393
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046801567077637
(434) DESCRIBE `ports` 0.0018229484558105
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00055789947509766
(436) DESCRIBE `ports` 0.0021140575408936
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00044488906860352
(438) DESCRIBE `ports` 0.0018539428710938
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00039505958557129
(440) DESCRIBE `ports` 0.0018110275268555
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00049901008605957
(442) DESCRIBE `ports` 0.0017998218536377
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.0003969669342041
(444) DESCRIBE `ports` 0.0017931461334229
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00042009353637695
(446) DESCRIBE `ports` 0.0018830299377441
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00037884712219238
(448) DESCRIBE `ports` 0.0018501281738281
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00043106079101562
(450) DESCRIBE `ports` 0.0018930435180664
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00048589706420898
(452) DESCRIBE `ports` 0.001863956451416
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042295455932617
(454) DESCRIBE `ports` 0.0018770694732666
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0004119873046875
(456) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '76089') AND (sailingdate >= '2019-09-20') AND (sailingdate <= '2020-04-21') 0.0061640739440918
(457) DESCRIBE `avid_specials` 0.0018551349639893
(458) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76089 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.0016169548034668
(459) DESCRIBE `cruiselines` 0.0028588771820068
(460) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00048685073852539
(461) DESCRIBE `orchid_image` 0.0020589828491211
(462) DESCRIBE `cruiselines` 0.0025310516357422
(463) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00040102005004883
(464) DESCRIBE `cruises` 0.003425121307373
(465) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76101') 0.00044703483581543
(466) DESCRIBE `ships` 0.0034539699554443
(467) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00047206878662109
(468) DESCRIBE `ships` 0.0034298896789551
(469) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.0003809928894043
(470) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037908554077148
(471) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00042104721069336
(472) DESCRIBE `itineraries` 0.0020730495452881
(473) DESCRIBE `ports` 0.0026910305023193
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0005950927734375
(475) DESCRIBE `ports` 0.0025990009307861
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00058889389038086
(477) DESCRIBE `ports` 0.0022470951080322
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039196014404297
(479) DESCRIBE `sailingdates` 0.0015749931335449
(480) DESCRIBE `ports` 0.0018718242645264
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048708915710449
(482) DESCRIBE `ports` 0.0017831325531006
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039792060852051
(484) DESCRIBE `ports` 0.0017740726470947
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00041508674621582
(486) DESCRIBE `ports` 0.0018918514251709
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0004119873046875
(488) DESCRIBE `ports` 0.0017831325531006
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00044989585876465
(490) DESCRIBE `ports` 0.0021030902862549
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00052595138549805
(492) DESCRIBE `ports` 0.0018661022186279
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.0005338191986084
(494) DESCRIBE `ports` 0.0020880699157715
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.0003809928894043
(496) DESCRIBE `ports` 0.0018160343170166
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00043320655822754
(498) DESCRIBE `ports` 0.0019729137420654
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00043296813964844
(500) DESCRIBE `ports` 0.0018720626831055
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0005028247833252
(502) DESCRIBE `ports` 0.0018959045410156
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0004417896270752
(504) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '76101') AND (sailingdate >= '2019-09-20') AND (sailingdate <= '2020-04-21') 0.0061709880828857
(505) DESCRIBE `avid_specials` 0.0019569396972656
(506) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76101 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.0018730163574219
(507) DESCRIBE `cruiselines` 0.0034091472625732
(508) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00080108642578125
(509) DESCRIBE `orchid_image` 0.0029110908508301
(510) DESCRIBE `cruiselines` 0.0036299228668213
(511) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00058507919311523
(512) DESCRIBE `ships` 0.0053730010986328
(513) SELECT `ships`.* FROM `ships` WHERE (id IN ('124', '1330', '287')) ORDER BY FIND_IN_SET(id, '124,1330,287') 0.0012750625610352
(514) DESCRIBE `cruisetypes` 0.0016908645629883
(515) DESCRIBE `destinations` 0.0023910999298096
(516) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.00069308280944824
(517) DESCRIBE `cruiselines` 0.002838134765625
(518) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00053000450134277
(519) DESCRIBE `cruiselines` 0.0031580924987793
(520) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00060606002807617
(521) DESCRIBE `ports` 0.0020260810852051
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00050997734069824