or, enquire about your chosen options

  1. What happens when you cruise back to back?
  2. Catch Up on Cruising: Latest News in bite size!
  3. Majestic Princess – Auckland 23 October 2018
  4. Catch Up on Cruising: Latest News in bite size!
  5. Cruise Ship Lingo? Look like a cruise expert before you get on the ship

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

Total elapsed time: 1.1232149600983

# Query Time
(1) connect 0.0011970996856689
(2) DESCRIBE `cruises` 0.0032539367675781
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (75314, 75299, 75301, 75300, 75316, 75317, 75318, 75328, 75319, 75326)) ORDER BY FIND_IN_SET(id, '75314,75299,75301,75300,75316,75317,75318,75328,75319,75326') 0.001945972442627
(4) DESCRIBE `cruises` 0.0030050277709961
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75314') 0.00027203559875488
(6) DESCRIBE `ships` 0.0032370090484619
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00042486190795898
(8) DESCRIBE `ships` 0.0042450428009033
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00042200088500977
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033903121948242
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025796890258789
(12) DESCRIBE `itineraries` 0.0016119480133057
(13) DESCRIBE `ports` 0.0018558502197266
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00033783912658691
(15) DESCRIBE `ports` 0.0020468235015869
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00032401084899902
(17) DESCRIBE `ports` 0.0015459060668945
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00031399726867676
(19) DESCRIBE `sailingdates` 0.0012040138244629
(20) DESCRIBE `ports` 0.0016121864318848
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00037193298339844
(22) DESCRIBE `ports` 0.0015139579772949
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00035500526428223
(24) DESCRIBE `ports` 0.0018410682678223
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00043797492980957
(26) DESCRIBE `ports` 0.0020649433135986
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00035405158996582
(28) DESCRIBE `ports` 0.0021891593933105
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00037717819213867
(30) DESCRIBE `ports` 0.0018010139465332
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00033807754516602
(32) DESCRIBE `ports` 0.0018820762634277
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.00040817260742188
(34) DESCRIBE `ports` 0.0020730495452881
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.00040197372436523
(36) DESCRIBE `ports` 0.0020589828491211
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00048494338989258
(38) DESCRIBE `ports` 0.0017740726470947
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00039100646972656
(40) DESCRIBE `ports` 0.0024299621582031
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00015091896057129
(42) DESCRIBE `ports` 0.00205397605896
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00029397010803223
(44) DESCRIBE `ports` 0.0016911029815674
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00067806243896484
(46) DESCRIBE `ports` 0.0020949840545654
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00035500526428223
(48) DESCRIBE `ports` 0.0018701553344727
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00039505958557129
(50) DESCRIBE `ports` 0.0020730495452881
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.0006859302520752
(52) DESCRIBE `ports` 0.0015888214111328
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.0004580020904541
(54) DESCRIBE `ports` 0.0019009113311768
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00042390823364258
(56) DESCRIBE `ports` 0.0020310878753662
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00042414665222168
(58) DESCRIBE `ports` 0.002223014831543
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00040197372436523
(60) DESCRIBE `ports` 0.0020430088043213
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00044012069702148
(62) DESCRIBE `ports` 0.0018548965454102
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00037312507629395
(64) DESCRIBE `ports` 0.0020859241485596
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00040888786315918
(66) DESCRIBE `ports` 0.0020351409912109
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00043320655822754
(68) DESCRIBE `ports` 0.0018517971038818
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00036406517028809
(70) DESCRIBE `ports` 0.0016958713531494
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00040292739868164
(72) DESCRIBE `ports` 0.0017969608306885
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00049090385437012
(74) DESCRIBE `ports` 0.001957893371582
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00045394897460938
(76) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75314') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.01161789894104
(77) DESCRIBE `avid_specials` 0.001910924911499
(78) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75314 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 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.0017809867858887
(79) DESCRIBE `cruiselines` 0.0025620460510254
(80) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00042390823364258
(81) DESCRIBE `orchid_image` 0.0021119117736816
(82) DESCRIBE `cruiselines` 0.0022571086883545
(83) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00041508674621582
(84) DESCRIBE `cruises` 0.0038979053497314
(85) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75299') 0.00041508674621582
(86) DESCRIBE `ships` 0.0040760040283203
(87) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00053000450134277
(88) DESCRIBE `ships` 0.0037028789520264
(89) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00045013427734375
(90) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00039911270141602
(91) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033712387084961
(92) DESCRIBE `itineraries` 0.0017070770263672
(93) DESCRIBE `ports` 0.0018091201782227
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00044012069702148
(95) DESCRIBE `ports` 0.0022549629211426
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00040102005004883
(97) DESCRIBE `ports` 0.0021719932556152
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00038814544677734
(99) DESCRIBE `sailingdates` 0.0014290809631348
(100) DESCRIBE `ports` 0.0015909671783447
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.0003049373626709
(102) DESCRIBE `ports` 0.0012500286102295
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00027012825012207
(104) DESCRIBE `ports` 0.0016260147094727
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0003960132598877
(106) DESCRIBE `ports` 0.0018019676208496
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00034904479980469
(108) DESCRIBE `ports` 0.0018930435180664
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00038909912109375
(110) DESCRIBE `ports` 0.0020828247070312
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00034403800964355
(112) DESCRIBE `ports` 0.0021500587463379
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00066399574279785
(114) DESCRIBE `ports` 0.0017709732055664
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00039505958557129
(116) DESCRIBE `ports` 0.0024230480194092
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00039410591125488
(118) DESCRIBE `ports` 0.0031449794769287
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00041794776916504
(120) DESCRIBE `ports` 0.0021159648895264
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.0004429817199707
(122) DESCRIBE `ports` 0.0022218227386475
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00028204917907715
(124) DESCRIBE `ports` 0.0018229484558105
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00035905838012695
(126) DESCRIBE `ports` 0.0023069381713867
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00037384033203125
(128) DESCRIBE `ports` 0.0019309520721436
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00036716461181641
(130) DESCRIBE `ports` 0.0017762184143066
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00036406517028809
(132) DESCRIBE `ports` 0.0020899772644043
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00038695335388184
(134) DESCRIBE `ports` 0.0024440288543701
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0003361701965332
(136) DESCRIBE `ports` 0.0021121501922607
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00038790702819824
(138) DESCRIBE `ports` 0.002377986907959
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00046801567077637
(140) DESCRIBE `ports` 0.0021998882293701
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00046491622924805
(142) DESCRIBE `ports` 0.0019240379333496
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00043487548828125
(144) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75299') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.0080051422119141
(145) DESCRIBE `avid_specials` 0.0015690326690674
(146) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75299 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 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.0010550022125244
(147) DESCRIBE `cruiselines` 0.0021560192108154
(148) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00040698051452637
(149) DESCRIBE `orchid_image` 0.0013349056243896
(150) DESCRIBE `cruiselines` 0.0020229816436768
(151) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.0005490779876709
(152) DESCRIBE `cruises` 0.0027611255645752
(153) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75301') 0.00015807151794434
(154) DESCRIBE `ships` 0.0031650066375732
(155) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00070786476135254
(156) DESCRIBE `ships` 0.0035169124603271
(157) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00074505805969238
(158) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00010395050048828
(159) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00042986869812012
(160) DESCRIBE `itineraries` 0.0019838809967041
(161) DESCRIBE `ports` 0.0016729831695557
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00058889389038086
(163) DESCRIBE `ports` 0.0015459060668945
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00021600723266602
(165) DESCRIBE `ports` 0.0021610260009766
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00052595138549805
(167) DESCRIBE `sailingdates` 0.0018141269683838
(168) DESCRIBE `ports` 0.0021669864654541
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00051093101501465
(170) DESCRIBE `ports` 0.0019149780273438
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00045514106750488
(172) DESCRIBE `ports` 0.0016310214996338
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.0004889965057373
(174) DESCRIBE `ports` 0.0019159317016602
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00032520294189453
(176) DESCRIBE `ports` 0.0015740394592285
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00036382675170898
(178) DESCRIBE `ports` 0.0018200874328613
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00035691261291504
(180) DESCRIBE `ports` 0.0020730495452881
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00047707557678223
(182) DESCRIBE `ports` 0.0020370483398438
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00043201446533203
(184) DESCRIBE `ports` 0.0021119117736816
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00041794776916504
(186) DESCRIBE `ports` 0.0016930103302002
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00036001205444336
(188) DESCRIBE `ports` 0.0022270679473877
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00045084953308105
(190) DESCRIBE `ports` 0.0021369457244873
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00041699409484863
(192) DESCRIBE `ports` 0.001816987991333
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00038599967956543
(194) DESCRIBE `ports` 0.0023469924926758
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00042295455932617
(196) DESCRIBE `ports` 0.0022308826446533
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00041699409484863
(198) DESCRIBE `ports` 0.0020279884338379
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00041604042053223
(200) DESCRIBE `ports` 0.0020771026611328
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0003509521484375
(202) DESCRIBE `ports` 0.0017170906066895
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00071501731872559
(204) DESCRIBE `ports` 0.0018620491027832
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.0004279613494873
(206) DESCRIBE `ports` 0.0017240047454834
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00057697296142578
(208) DESCRIBE `ports` 0.0030820369720459
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.00055599212646484
(210) DESCRIBE `ports` 0.0025150775909424
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.00040602684020996
(212) DESCRIBE `ports` 0.002255916595459
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00047016143798828
(214) DESCRIBE `ports` 0.0019171237945557
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00044703483581543
(216) DESCRIBE `ports` 0.0021970272064209
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0004889965057373
(218) DESCRIBE `ports` 0.0018088817596436
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00042200088500977
(220) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75301') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.0086629390716553
(221) DESCRIBE `avid_specials` 0.0023889541625977
(222) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75301 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 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.0018510818481445
(223) DESCRIBE `cruiselines` 0.0026619434356689
(224) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00042510032653809
(225) DESCRIBE `orchid_image` 0.0017058849334717
(226) DESCRIBE `cruiselines` 0.0028140544891357
(227) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00044894218444824
(228) DESCRIBE `cruises` 0.004040002822876
(229) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75300') 0.00053501129150391
(230) DESCRIBE `ships` 0.0026991367340088
(231) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00039196014404297
(232) DESCRIBE `ships` 0.0034151077270508
(233) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00029206275939941
(234) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026988983154297
(235) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029301643371582
(236) DESCRIBE `itineraries` 0.0016281604766846
(237) DESCRIBE `ports` 0.0015180110931396
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00041413307189941
(239) DESCRIBE `ports` 0.0018191337585449
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00030994415283203
(241) DESCRIBE `ports` 0.001295804977417
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00033903121948242
(243) DESCRIBE `sailingdates` 0.0012080669403076
(244) DESCRIBE `ports` 0.0012819766998291
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00030303001403809
(246) DESCRIBE `ports` 0.0018777847290039
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00028610229492188
(248) DESCRIBE `ports` 0.0012791156768799
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00033283233642578
(250) DESCRIBE `ports` 0.0012950897216797
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00037002563476562
(252) DESCRIBE `ports` 0.0014870166778564
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00035619735717773
(254) DESCRIBE `ports` 0.0016970634460449
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00033688545227051
(256) DESCRIBE `ports` 0.0012991428375244
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.0003969669342041
(258) DESCRIBE `ports` 0.0015649795532227
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00028705596923828
(260) DESCRIBE `ports` 0.0013208389282227
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00035691261291504
(262) DESCRIBE `ports` 0.0014331340789795
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00029110908508301
(264) DESCRIBE `ports` 0.0017399787902832
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00034213066101074
(266) DESCRIBE `ports` 0.0016498565673828
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00029301643371582
(268) DESCRIBE `ports` 0.001446008682251
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00040102005004883
(270) DESCRIBE `ports` 0.0016429424285889
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00045609474182129
(272) DESCRIBE `ports` 0.0019090175628662
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00041985511779785
(274) DESCRIBE `ports` 0.0019590854644775
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0003669261932373
(276) DESCRIBE `ports` 0.0014278888702393
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00036406517028809
(278) DESCRIBE `ports` 0.0021390914916992
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00029706954956055
(280) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75300') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.0085630416870117
(281) DESCRIBE `avid_specials` 0.0014750957489014
(282) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75300 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 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.0017910003662109
(283) DESCRIBE `cruiselines` 0.0024771690368652
(284) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00039100646972656
(285) DESCRIBE `orchid_image` 0.0022909641265869
(286) DESCRIBE `cruiselines` 0.0025069713592529
(287) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00031781196594238
(288) DESCRIBE `cruises` 0.0046539306640625
(289) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75316') 0.00041484832763672
(290) DESCRIBE `ships` 0.0041210651397705
(291) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00049495697021484
(292) DESCRIBE `ships` 0.003633975982666
(293) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00037908554077148
(294) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034308433532715
(295) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032210350036621
(296) DESCRIBE `itineraries` 0.0017650127410889
(297) DESCRIBE `ports` 0.0022919178009033
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00043320655822754
(299) DESCRIBE `ports` 0.0017828941345215
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00039410591125488
(301) DESCRIBE `ports` 0.0017480850219727
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00037217140197754
(303) DESCRIBE `sailingdates` 0.0016090869903564
(304) DESCRIBE `ports` 0.0018861293792725
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00046610832214355
(306) DESCRIBE `ports` 0.0017838478088379
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0003809928894043
(308) DESCRIBE `ports` 0.002223014831543
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00040602684020996
(310) DESCRIBE `ports` 0.0016460418701172
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00041699409484863
(312) DESCRIBE `ports` 0.0016849040985107
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.00034904479980469
(314) DESCRIBE `ports` 0.0016059875488281
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.00083398818969727
(316) DESCRIBE `ports` 0.0027689933776855
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00044918060302734
(318) DESCRIBE `ports` 0.0018429756164551
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00040888786315918
(320) DESCRIBE `ports` 0.0017960071563721
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00040793418884277
(322) DESCRIBE `ports` 0.0025980472564697
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00044608116149902
(324) DESCRIBE `ports` 0.002471923828125
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00043010711669922
(326) DESCRIBE `ports` 0.0023088455200195
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.0004570484161377
(328) DESCRIBE `ports` 0.0021579265594482
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00037789344787598
(330) DESCRIBE `ports` 0.001471996307373
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00026416778564453
(332) DESCRIBE `ports` 0.0023159980773926
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00055313110351562
(334) DESCRIBE `ports` 0.0023159980773926
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00063705444335938
(336) DESCRIBE `ports` 0.0020959377288818
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00056910514831543
(338) DESCRIBE `ports` 0.002173900604248
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 9.3936920166016E-5
(340) DESCRIBE `ports` 0.0027511119842529
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00045299530029297
(342) DESCRIBE `ports` 0.0021219253540039
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.0004119873046875
(344) DESCRIBE `ports` 0.0017590522766113
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00040602684020996
(346) DESCRIBE `ports` 0.0018038749694824
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00038886070251465
(348) DESCRIBE `ports` 0.0021460056304932
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00015091896057129
(350) DESCRIBE `ports` 0.0020270347595215
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00062012672424316
(352) DESCRIBE `ports` 0.0021548271179199
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00041484832763672
(354) DESCRIBE `ports` 0.0017468929290771
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00035190582275391
(356) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75316') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.0085420608520508
(357) DESCRIBE `avid_specials` 0.0016360282897949
(358) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75316 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 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.0017650127410889
(359) DESCRIBE `cruiselines` 0.0030121803283691
(360) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00052285194396973
(361) DESCRIBE `orchid_image` 0.0026421546936035
(362) DESCRIBE `cruiselines` 0.0030200481414795
(363) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00039005279541016
(364) DESCRIBE `cruises` 0.0035610198974609
(365) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75317') 0.00037288665771484
(366) DESCRIBE `ships` 0.0037901401519775
(367) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00052118301391602
(368) DESCRIBE `ships` 0.003734827041626
(369) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00047087669372559
(370) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033903121948242
(371) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033307075500488
(372) DESCRIBE `itineraries` 0.0018939971923828
(373) DESCRIBE `ports` 0.0019478797912598
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00045490264892578
(375) DESCRIBE `ports` 0.0019040107727051
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00042009353637695
(377) DESCRIBE `ports` 0.0018129348754883
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00036311149597168
(379) DESCRIBE `sailingdates` 0.0023670196533203
(380) DESCRIBE `ports` 0.0019237995147705
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00071215629577637
(382) DESCRIBE `ports` 0.0022001266479492
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00043201446533203
(384) DESCRIBE `ports` 0.001986026763916
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.00045585632324219
(386) DESCRIBE `ports` 0.0025999546051025
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.00054502487182617
(388) DESCRIBE `ports` 0.002051830291748
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00045204162597656
(390) DESCRIBE `ports` 0.0018448829650879
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00038599967956543
(392) DESCRIBE `ports` 0.0018651485443115
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00043606758117676
(394) DESCRIBE `ports` 0.0016951560974121
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00035786628723145
(396) DESCRIBE `ports` 0.0016119480133057
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00036883354187012
(398) DESCRIBE `ports` 0.0020089149475098
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00042510032653809
(400) DESCRIBE `ports` 0.0022711753845215
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.0017678737640381
(402) DESCRIBE `ports` 0.001986026763916
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00052404403686523
(404) DESCRIBE `ports` 0.0018429756164551
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00068283081054688
(406) DESCRIBE `ports` 0.0023238658905029
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00038003921508789
(408) DESCRIBE `ports` 0.0030510425567627
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00062799453735352
(410) DESCRIBE `ports` 0.0023808479309082
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00078201293945312
(412) DESCRIBE `ports` 0.0023758411407471
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00069379806518555
(414) DESCRIBE `ports` 0.0027179718017578
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.0003960132598877
(416) DESCRIBE `ports` 0.0024008750915527
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00044488906860352
(418) DESCRIBE `ports` 0.0020041465759277
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00038695335388184
(420) DESCRIBE `ports` 0.0023682117462158
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 8.8214874267578E-5
(422) DESCRIBE `ports` 0.0017762184143066
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00045895576477051
(424) DESCRIBE `ports` 0.0030331611633301
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00043511390686035
(426) DESCRIBE `ports` 0.0026698112487793
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00045418739318848
(428) DESCRIBE `ports` 0.0024151802062988
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00078392028808594
(430) DESCRIBE `ports` 0.002216100692749
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00054407119750977
(432) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75317') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.0093100070953369
(433) DESCRIBE `avid_specials` 0.0018360614776611
(434) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75317 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 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.0019471645355225
(435) DESCRIBE `cruiselines` 0.0025920867919922
(436) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00055789947509766
(437) DESCRIBE `orchid_image` 0.002169132232666
(438) DESCRIBE `cruiselines` 0.0027539730072021
(439) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00045895576477051
(440) DESCRIBE `cruises` 0.003648042678833
(441) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75318') 0.00047492980957031
(442) DESCRIBE `ships` 0.0039360523223877
(443) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00048685073852539
(444) DESCRIBE `ships` 0.0048091411590576
(445) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00059700012207031
(446) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033116340637207
(447) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031399726867676
(448) DESCRIBE `itineraries` 0.0034589767456055
(449) DESCRIBE `ports` 0.0020289421081543
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00052714347839355
(451) DESCRIBE `ports` 0.0024919509887695
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00049400329589844
(453) DESCRIBE `ports` 0.0028738975524902
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00054192543029785
(455) DESCRIBE `sailingdates` 0.0034708976745605
(456) DESCRIBE `ports` 0.002816915512085
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00038909912109375
(458) DESCRIBE `ports` 0.0017750263214111
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00034689903259277
(460) DESCRIBE `ports` 0.0020599365234375
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.00043201446533203
(462) DESCRIBE `ports` 0.0024089813232422
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.00062298774719238
(464) DESCRIBE `ports` 0.0028791427612305
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00053095817565918
(466) DESCRIBE `ports` 0.0021040439605713
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00047898292541504
(468) DESCRIBE `ports` 0.0023679733276367
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0005488395690918
(470) DESCRIBE `ports` 0.0022401809692383
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00011205673217773
(472) DESCRIBE `ports` 0.0025639533996582
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00024700164794922
(474) DESCRIBE `ports` 0.0026030540466309
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00024199485778809
(476) DESCRIBE `ports` 0.0022091865539551
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00039315223693848
(478) DESCRIBE `ports` 0.0018680095672607
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00043010711669922
(480) DESCRIBE `ports` 0.0021669864654541
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.0044929981231689
(482) DESCRIBE `ports` 0.0019130706787109
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00062084197998047
(484) DESCRIBE `ports` 0.002025842666626
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00066113471984863
(486) DESCRIBE `ports` 0.0020101070404053
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00049614906311035
(488) DESCRIBE `ports` 0.0023601055145264
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00055098533630371
(490) DESCRIBE `ports` 0.0020527839660645
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00043892860412598
(492) DESCRIBE `ports` 0.0020081996917725
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00050806999206543
(494) DESCRIBE `ports` 0.0025041103363037
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00044512748718262
(496) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75318') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.0087201595306396
(497) DESCRIBE `avid_specials` 0.0020530223846436
(498) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75318 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 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.0018191337585449
(499) DESCRIBE `cruiselines` 0.0024421215057373
(500) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00046396255493164
(501) DESCRIBE `orchid_image` 0.003709077835083
(502) DESCRIBE `cruiselines` 0.0029289722442627
(503) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.0029540061950684
(504) DESCRIBE `cruises` 0.0057320594787598
(505) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75328') 0.00038290023803711
(506) DESCRIBE `ships` 0.0032451152801514
(507) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00053000450134277
(508) DESCRIBE `ships` 0.0034189224243164
(509) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00044488906860352
(510) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032496452331543
(511) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030398368835449
(512) DESCRIBE `itineraries` 0.0027568340301514
(513) DESCRIBE `ports` 0.0025019645690918
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00039911270141602
(515) DESCRIBE `ports` 0.0024921894073486
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00052213668823242
(517) DESCRIBE `ports` 0.0023651123046875
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00043606758117676
(519) DESCRIBE `sailingdates` 0.0016329288482666
(520) DESCRIBE `ports` 0.0023269653320312
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0010359287261963
(522) DESCRIBE `ports` 0.0018970966339111
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00071096420288086
(524) DESCRIBE `ports` 0.002500057220459
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00037097930908203
(526) DESCRIBE `ports` 0.002140998840332
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00086402893066406
(528) DESCRIBE `ports` 0.003119945526123
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.0017440319061279
(530) DESCRIBE `ports` 0.0019690990447998
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.0004429817199707
(532) DESCRIBE `ports` 0.0018908977508545
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00046086311340332
(534) DESCRIBE `ports` 0.0020909309387207
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00043010711669922
(536) DESCRIBE `ports` 0.0021159648895264
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00042891502380371
(538) DESCRIBE `ports` 0.001906156539917
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00042891502380371
(540) DESCRIBE `ports` 0.0019040107727051
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.0005030632019043
(542) DESCRIBE `ports` 0.0019938945770264
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00032186508178711
(544) DESCRIBE `ports` 0.0026450157165527
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00041294097900391
(546) DESCRIBE `ports` 0.0025789737701416
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00045609474182129
(548) DESCRIBE `ports` 0.0031170845031738
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00052714347839355
(550) DESCRIBE `ports` 0.00199294090271
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00047707557678223
(552) DESCRIBE `ports` 0.001856803894043
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00042986869812012
(554) DESCRIBE `ports` 0.0021929740905762
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00042200088500977
(556) DESCRIBE `ports` 0.0029258728027344
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00034117698669434
(558) DESCRIBE `ports` 0.002269983291626
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.0004730224609375
(560) DESCRIBE `ports` 0.0021851062774658
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00053215026855469
(562) DESCRIBE `ports` 0.0022199153900146
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.0011999607086182
(564) DESCRIBE `ports` 0.0027689933776855
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.0011670589447021
(566) DESCRIBE `ports` 0.0020179748535156
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00047993659973145
(568) DESCRIBE `ports` 0.0027201175689697
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0067529678344727
(570) DESCRIBE `ports` 0.0091018676757812
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00043702125549316
(572) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75328') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.0082488059997559
(573) DESCRIBE `avid_specials` 0.013097047805786
(574) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75328 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 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.0020589828491211
(575) DESCRIBE `cruiselines` 0.003831148147583
(576) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.0020430088043213
(577) DESCRIBE `orchid_image` 0.018996953964233
(578) DESCRIBE `cruiselines` 0.002514123916626
(579) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00046706199645996
(580) DESCRIBE `cruises` 0.0029330253601074
(581) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75319') 0.0094840526580811
(582) DESCRIBE `ships` 0.0038697719573975
(583) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00067901611328125
(584) DESCRIBE `ships` 0.0039560794830322
(585) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00048398971557617
(586) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031304359436035
(587) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033211708068848
(588) DESCRIBE `itineraries` 0.0019299983978271
(589) DESCRIBE `ports` 0.0029129981994629
(590) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00091290473937988
(591) DESCRIBE `ports` 0.0042960643768311
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00061798095703125
(593) DESCRIBE `ports` 0.002432107925415
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0004580020904541
(595) DESCRIBE `sailingdates` 0.0016138553619385
(596) DESCRIBE `ports` 0.0022060871124268
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00048494338989258
(598) DESCRIBE `ports` 0.0019218921661377
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00044393539428711
(600) DESCRIBE `ports` 0.0018479824066162
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00048494338989258
(602) DESCRIBE `ports` 0.0018961429595947
(603) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00040793418884277
(604) DESCRIBE `ports` 0.0016639232635498
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00056791305541992
(606) DESCRIBE `ports` 0.0020821094512939
(607) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00051712989807129
(608) DESCRIBE `ports` 0.0037350654602051
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00089120864868164
(610) DESCRIBE `ports` 0.0041971206665039
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00051999092102051
(612) DESCRIBE `ports` 0.0027101039886475
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00055599212646484
(614) DESCRIBE `ports` 0.0032470226287842
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00055098533630371
(616) DESCRIBE `ports` 0.0036830902099609
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00088906288146973
(618) DESCRIBE `ports` 0.0024259090423584
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00053000450134277
(620) DESCRIBE `ports` 0.0021510124206543
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.001133918762207
(622) DESCRIBE `ports` 0.0023448467254639
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00044894218444824
(624) DESCRIBE `ports` 0.0019640922546387
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00049901008605957
(626) DESCRIBE `ports` 0.0018470287322998
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.001349925994873
(628) DESCRIBE `ports` 0.0018260478973389
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00049495697021484
(630) DESCRIBE `ports` 0.0020251274108887
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00047802925109863
(632) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75319') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.0087759494781494
(633) DESCRIBE `avid_specials` 0.0021381378173828
(634) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75319 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 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.0016281604766846
(635) DESCRIBE `cruiselines` 0.0028369426727295
(636) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.0005488395690918
(637) DESCRIBE `orchid_image` 0.0022890567779541
(638) DESCRIBE `cruiselines` 0.0029690265655518
(639) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00060415267944336
(640) DESCRIBE `cruises` 0.0035979747772217
(641) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75326') 0.00023198127746582
(642) DESCRIBE `ships` 0.0039620399475098
(643) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00052618980407715
(644) DESCRIBE `ships` 0.0035128593444824
(645) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00039815902709961
(646) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032496452331543
(647) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031208992004395
(648) DESCRIBE `itineraries` 0.0019989013671875
(649) DESCRIBE `ports` 0.0019509792327881
(650) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00062990188598633
(651) DESCRIBE `ports` 0.0023460388183594
(652) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00055718421936035
(653) DESCRIBE `ports` 0.0017290115356445
(654) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 9.2983245849609E-5
(655) DESCRIBE `sailingdates` 0.0016090869903564
(656) DESCRIBE `ports` 0.0019562244415283
(657) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00049805641174316
(658) DESCRIBE `ports` 0.0018041133880615
(659) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00044798851013184
(660) DESCRIBE `ports` 0.0031669139862061
(661) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.0005500316619873
(662) DESCRIBE `ports` 0.0023770332336426
(663) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00051403045654297
(664) DESCRIBE `ports` 0.0020699501037598
(665) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00054502487182617
(666) DESCRIBE `ports` 0.0021190643310547
(667) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00048184394836426
(668) DESCRIBE `ports` 0.0019810199737549
(669) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00051712989807129
(670) DESCRIBE `ports` 0.0020589828491211
(671) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.0004270076751709
(672) DESCRIBE `ports` 0.0020029544830322
(673) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00051522254943848
(674) DESCRIBE `ports` 0.0021159648895264
(675) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00054788589477539
(676) DESCRIBE `ports` 0.0022189617156982
(677) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00056004524230957
(678) DESCRIBE `ports` 0.0022158622741699
(679) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00051093101501465
(680) DESCRIBE `ports` 0.0021059513092041
(681) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00053811073303223
(682) DESCRIBE `ports` 0.0019550323486328
(683) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0004119873046875
(684) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '75326') AND (sailingdate >= '2019-12-06') AND (sailingdate <= '2020-03-02') 0.0059428215026855
(685) DESCRIBE `avid_specials` 0.0018579959869385
(686) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75326 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 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.0023097991943359
(687) DESCRIBE `cruiselines` 0.0030298233032227
(688) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00065302848815918
(689) DESCRIBE `orchid_image` 0.0023801326751709
(690) DESCRIBE `cruiselines` 0.00307297706604
(691) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00047612190246582
(692) DESCRIBE `cruisetypes` 0.0017240047454834
(693) DESCRIBE `destinations` 0.0024008750915527
(694) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.00074410438537598
(695) DESCRIBE `cruiselines` 0.0028450489044189
(696) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00055480003356934
(697) DESCRIBE `ships` 0.0042099952697754
(698) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.0006871223449707
(699) DESCRIBE `cruiselines` 0.0032551288604736
(700) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.00066304206848145
(701) DESCRIBE `ships` 0.0042791366577148
(702) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00076603889465332
(703) DESCRIBE `ports` 0.0023770332336426
(704) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0005488395690918