or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Cruise Ship Lingo? Look like a cruise expert before you get on the ship
  3. BREAKING NEWS FOR PRINCESS FANS: Register your interest now!!!
  4. Catch Up on Cruising: Latest News in bite size!
  5. Review: China – Part Two

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

Total elapsed time: 0.73222756385803

# Query Time
(1) connect 0.00075101852416992
(2) DESCRIBE `cruises` 0.0030460357666016
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (62665, 68109, 70033, 62661, 69259, 68315, 73186, 63133, 62653, 69087)) ORDER BY FIND_IN_SET(id, '62665,68109,70033,62661,69259,68315,73186,63133,62653,69087') 0.0018641948699951
(4) DESCRIBE `cruises` 0.0025649070739746
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62665') 0.00031590461730957
(6) DESCRIBE `ships` 0.0024468898773193
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.0003349781036377
(8) DESCRIBE `ships` 0.0023989677429199
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00026607513427734
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036883354187012
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025200843811035
(12) DESCRIBE `itineraries` 0.0012118816375732
(13) DESCRIBE `ports` 0.0012540817260742
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00030803680419922
(15) DESCRIBE `ports` 0.0013837814331055
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00033402442932129
(17) DESCRIBE `ports` 0.001223087310791
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00027108192443848
(19) DESCRIBE `sailingdates` 0.001323938369751
(20) DESCRIBE `ports` 0.0013217926025391
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00029301643371582
(22) DESCRIBE `ports` 0.0012309551239014
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.0003049373626709
(24) DESCRIBE `ports` 0.0012640953063965
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.0003349781036377
(26) DESCRIBE `ports` 0.0012478828430176
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00027298927307129
(28) DESCRIBE `ports` 0.0012328624725342
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00029110908508301
(30) DESCRIBE `ports` 0.0014069080352783
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00035595893859863
(32) DESCRIBE `ports` 0.0017139911651611
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.0003969669342041
(34) DESCRIBE `ports` 0.0016779899597168
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.0002901554107666
(36) DESCRIBE `ports` 0.0013730525970459
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00030183792114258
(38) DESCRIBE `ports` 0.0013902187347412
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.0002739429473877
(40) DESCRIBE `ports` 0.001305103302002
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00028800964355469
(42) DESCRIBE `ports` 0.0012319087982178
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00027203559875488
(44) DESCRIBE `ports` 0.0012691020965576
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00028896331787109
(46) DESCRIBE `ports` 0.0012290477752686
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00030112266540527
(48) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62665') AND (sailingdate >= '2018-12-21') 0.0047168731689453
(49) DESCRIBE `avid_specials` 0.0012519359588623
(50) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62665 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 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.001121997833252
(51) DESCRIBE `cruiselines` 0.0018310546875
(52) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00038599967956543
(53) DESCRIBE `orchid_image` 0.0016350746154785
(54) DESCRIBE `cruiselines` 0.0019931793212891
(55) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0003209114074707
(56) DESCRIBE `cruises` 0.0027949810028076
(57) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68109') 0.00050902366638184
(58) DESCRIBE `ships` 0.0029361248016357
(59) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 766))) 0.0004570484161377
(60) DESCRIBE `ships` 0.0024499893188477
(61) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '766') 0.00028586387634277
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026512145996094
(63) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025391578674316
(64) DESCRIBE `itineraries` 0.0012509822845459
(65) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68109') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00073409080505371
(66) DESCRIBE `ports` 0.0015389919281006
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00036787986755371
(68) DESCRIBE `ports` 0.0013048648834229
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00029778480529785
(70) DESCRIBE `ports` 0.0014691352844238
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00031304359436035
(72) DESCRIBE `sailingdates` 0.001115083694458
(73) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68109') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00066900253295898
(74) DESCRIBE `ports` 0.0015850067138672
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00038814544677734
(76) DESCRIBE `ports` 0.0015490055084229
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.0003659725189209
(78) DESCRIBE `ports` 0.0018620491027832
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00041794776916504
(80) DESCRIBE `ports` 0.0017738342285156
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.0003960132598877
(82) DESCRIBE `ports` 0.0017590522766113
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00040483474731445
(84) DESCRIBE `ports` 0.0014948844909668
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0003669261932373
(86) DESCRIBE `ports` 0.0016031265258789
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00038290023803711
(88) DESCRIBE `ports` 0.0015718936920166
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00036311149597168
(90) DESCRIBE `ports` 0.0015769004821777
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00038909912109375
(92) DESCRIBE `ports` 0.0015718936920166
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00036811828613281
(94) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68109') AND (sailingdate >= '2018-12-21') 0.0094599723815918
(95) DESCRIBE `avid_specials` 0.0016980171203613
(96) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68109 and class = 'Cruise') OR (item_id = 766 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 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.0016961097717285
(97) DESCRIBE `cruiselines` 0.0024809837341309
(98) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00050806999206543
(99) DESCRIBE `orchid_image` 0.0020549297332764
(100) DESCRIBE `cruiselines` 0.0024311542510986
(101) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00045299530029297
(102) DESCRIBE `cruises` 0.0038731098175049
(103) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70033') 0.00050806999206543
(104) DESCRIBE `ships` 0.0032379627227783
(105) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1415))) 0.0005040168762207
(106) DESCRIBE `ships` 0.0030801296234131
(107) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1415') 0.0003819465637207
(108) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00030803680419922
(109) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00029397010803223
(110) DESCRIBE `itineraries` 0.0015921592712402
(111) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70033') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.056020975112915
(112) DESCRIBE `ports` 0.002190113067627
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0005800724029541
(114) DESCRIBE `ports` 0.0017318725585938
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00044107437133789
(116) DESCRIBE `ports` 0.0018320083618164
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00040411949157715
(118) DESCRIBE `sailingdates` 0.0014870166778564
(119) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70033') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00087594985961914
(120) DESCRIBE `ports` 0.0021448135375977
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00048995018005371
(122) DESCRIBE `ports` 0.0020971298217773
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00050997734069824
(124) DESCRIBE `ports` 0.0019052028656006
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00044703483581543
(126) DESCRIBE `ports` 0.001849889755249
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00042605400085449
(128) DESCRIBE `ports` 0.001878023147583
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00043201446533203
(130) DESCRIBE `ports` 0.0018761157989502
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00040698051452637
(132) DESCRIBE `ports` 0.0018420219421387
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 347))) 0.00043797492980957
(134) DESCRIBE `ports` 0.0016939640045166
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '347') 0.00036811828613281
(136) DESCRIBE `ports` 0.0016570091247559
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00037813186645508
(138) DESCRIBE `ports` 0.001755952835083
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00037908554077148
(140) DESCRIBE `ports` 0.0017800331115723
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00040698051452637
(142) DESCRIBE `ports` 0.001737117767334
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00039792060852051
(144) DESCRIBE `ports` 0.0017528533935547
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00042891502380371
(146) DESCRIBE `ports` 0.0017309188842773
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00038385391235352
(148) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '70033') AND (sailingdate >= '2018-12-21') 0.0092439651489258
(149) DESCRIBE `avid_specials` 0.0020208358764648
(150) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70033 and class = 'Cruise') OR (item_id = 1415 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 12 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
(151) DESCRIBE `cruiselines` 0.0025649070739746
(152) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00044822692871094
(153) DESCRIBE `orchid_image` 0.0019829273223877
(154) DESCRIBE `cruiselines` 0.0026199817657471
(155) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00047993659973145
(156) DESCRIBE `cruises` 0.0036160945892334
(157) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62661') 0.00046086311340332
(158) DESCRIBE `ships` 0.0034990310668945
(159) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00049114227294922
(160) DESCRIBE `ships` 0.0034909248352051
(161) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00040388107299805
(162) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037884712219238
(163) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033402442932129
(164) DESCRIBE `itineraries` 0.0017402172088623
(165) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62661') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00067400932312012
(166) DESCRIBE `ports` 0.0018949508666992
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00043606758117676
(168) DESCRIBE `ports` 0.0017910003662109
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00041508674621582
(170) DESCRIBE `ports` 0.0017950534820557
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00037503242492676
(172) DESCRIBE `sailingdates` 0.0015180110931396
(173) DESCRIBE `ports` 0.0021350383758545
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00049901008605957
(175) DESCRIBE `ports` 0.0017490386962891
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00035691261291504
(177) DESCRIBE `ports` 0.0017650127410889
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0003819465637207
(179) DESCRIBE `ports` 0.0017139911651611
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00033402442932129
(181) DESCRIBE `ports` 0.0013079643249512
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00032210350036621
(183) DESCRIBE `ports` 0.0016798973083496
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00036382675170898
(185) DESCRIBE `ports` 0.0017740726470947
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00038385391235352
(187) DESCRIBE `ports` 0.0017378330230713
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00035881996154785
(189) DESCRIBE `ports` 0.0017030239105225
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0004417896270752
(191) DESCRIBE `ports` 0.0017549991607666
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00035786628723145
(193) DESCRIBE `ports` 0.0017228126525879
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00038790702819824
(195) DESCRIBE `ports` 0.0018038749694824
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00036001205444336
(197) DESCRIBE `ports` 0.0017480850219727
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.0003969669342041
(199) DESCRIBE `ports` 0.0017149448394775
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00035810470581055
(201) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62661') AND (sailingdate >= '2018-12-21') 0.0086050033569336
(202) DESCRIBE `avid_specials` 0.0018091201782227
(203) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62661 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 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.0018131732940674
(204) DESCRIBE `cruiselines` 0.0026769638061523
(205) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00043487548828125
(206) DESCRIBE `orchid_image` 0.0019490718841553
(207) DESCRIBE `cruiselines` 0.0025558471679688
(208) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00039505958557129
(209) DESCRIBE `cruises` 0.0034210681915283
(210) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69259') 0.00042605400085449
(211) DESCRIBE `ships` 0.0035560131072998
(212) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 553))) 0.00047588348388672
(213) DESCRIBE `ships` 0.0038189888000488
(214) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '553') 0.00045895576477051
(215) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00039410591125488
(216) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032687187194824
(217) DESCRIBE `itineraries` 0.0018060207366943
(218) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69259') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00087690353393555
(219) DESCRIBE `ports` 0.0019140243530273
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00041389465332031
(221) DESCRIBE `ports` 0.0018730163574219
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.0003821849822998
(223) DESCRIBE `ports` 0.0017099380493164
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00041890144348145
(225) DESCRIBE `sailingdates` 0.0015358924865723
(226) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69259') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00088596343994141
(227) DESCRIBE `ports` 0.0017578601837158
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00037908554077148
(229) DESCRIBE `ports` 0.0017731189727783
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00039792060852051
(231) DESCRIBE `ports` 0.0017900466918945
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2442))) 0.00037288665771484
(233) DESCRIBE `ports` 0.0018539428710938
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2442') 0.00034618377685547
(235) DESCRIBE `ports` 0.0017509460449219
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 709))) 0.00043916702270508
(237) DESCRIBE `ports` 0.0017709732055664
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '709') 0.00037407875061035
(239) DESCRIBE `ports` 0.0017130374908447
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2965))) 0.00038003921508789
(241) DESCRIBE `ports` 0.0017261505126953
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2965') 0.00035810470581055
(243) DESCRIBE `ports` 0.0017640590667725
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00038909912109375
(245) DESCRIBE `ports` 0.0017051696777344
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00036001205444336
(247) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69259') AND (sailingdate >= '2018-12-21') 0.004669189453125
(248) DESCRIBE `avid_specials` 0.0011448860168457
(249) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69259 and class = 'Cruise') OR (item_id = 553 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 52 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.00098395347595215
(250) DESCRIBE `cruiselines` 0.0018429756164551
(251) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0003058910369873
(252) DESCRIBE `orchid_image` 0.001399040222168
(253) DESCRIBE `cruiselines` 0.0017480850219727
(254) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00028514862060547
(255) DESCRIBE `cruises` 0.0024600028991699
(256) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68315') 0.00033783912658691
(257) DESCRIBE `ships` 0.0024778842926025
(258) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1067))) 0.00037503242492676
(259) DESCRIBE `ships` 0.0026669502258301
(260) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1067') 0.00030803680419922
(261) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025796890258789
(262) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025105476379395
(263) DESCRIBE `itineraries` 0.0012478828430176
(264) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68315') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00079607963562012
(265) DESCRIBE `ports` 0.0014050006866455
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00031709671020508
(267) DESCRIBE `ports` 0.0013718605041504
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00032806396484375
(269) DESCRIBE `ports` 0.001262903213501
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00029397010803223
(271) DESCRIBE `sailingdates` 0.0013620853424072
(272) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68315') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00076699256896973
(273) DESCRIBE `ports` 0.0014638900756836
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00040006637573242
(275) DESCRIBE `ports` 0.0012309551239014
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00027894973754883
(277) DESCRIBE `ports` 0.0012838840484619
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00030303001403809
(279) DESCRIBE `ports` 0.001309871673584
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00028491020202637
(281) DESCRIBE `ports` 0.0017199516296387
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00029301643371582
(283) DESCRIBE `ports` 0.0012261867523193
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00026798248291016
(285) DESCRIBE `ports` 0.0012509822845459
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00028181076049805
(287) DESCRIBE `ports` 0.0012609958648682
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00029993057250977
(289) DESCRIBE `ports` 0.0013120174407959
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 55))) 0.00029397010803223
(291) DESCRIBE `ports` 0.0012660026550293
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '55') 0.00030088424682617
(293) DESCRIBE `ports` 0.0015289783477783
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 308))) 0.00031399726867676
(295) DESCRIBE `ports` 0.0013089179992676
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '308') 0.00027108192443848
(297) DESCRIBE `ports` 0.001288890838623
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 679))) 0.0003199577331543
(299) DESCRIBE `ports` 0.0012588500976562
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '679') 0.00026798248291016
(301) DESCRIBE `ports` 0.0014219284057617
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00030303001403809
(303) DESCRIBE `ports` 0.0013329982757568
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.0002748966217041
(305) DESCRIBE `ports` 0.0012550354003906
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00037097930908203
(307) DESCRIBE `ports` 0.0014278888702393
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00030088424682617
(309) DESCRIBE `ports` 0.0012660026550293
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 352))) 0.00032806396484375
(311) DESCRIBE `ports` 0.0012378692626953
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '352') 0.00028300285339355
(313) DESCRIBE `ports` 0.0014381408691406
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00029706954956055
(315) DESCRIBE `ports` 0.0012819766998291
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.0002748966217041
(317) DESCRIBE `ports` 0.0013570785522461
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 663))) 0.00031805038452148
(319) DESCRIBE `ports` 0.0012710094451904
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '663') 0.00027704238891602
(321) DESCRIBE `ports` 0.0012869834899902
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00033783912658691
(323) DESCRIBE `ports` 0.0015418529510498
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00038409233093262
(325) DESCRIBE `ports` 0.0016648769378662
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00030994415283203
(327) DESCRIBE `ports` 0.0013210773468018
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00027179718017578
(329) DESCRIBE `ports` 0.0012660026550293
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00043892860412598
(331) DESCRIBE `ports` 0.0017490386962891
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00029778480529785
(333) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68315') AND (sailingdate >= '2018-12-21') 0.0053410530090332
(334) DESCRIBE `avid_specials` 0.0013198852539062
(335) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68315 and class = 'Cruise') OR (item_id = 1067 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 12 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.0011241436004639
(336) DESCRIBE `cruiselines` 0.0019099712371826
(337) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00033307075500488
(338) DESCRIBE `orchid_image` 0.0014400482177734
(339) DESCRIBE `cruiselines` 0.0017678737640381
(340) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00029492378234863
(341) DESCRIBE `cruises` 0.002504825592041
(342) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73186') 0.00032401084899902
(343) DESCRIBE `ships` 0.0025348663330078
(344) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1415))) 0.00035786628723145
(345) DESCRIBE `ships` 0.002532958984375
(346) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1415') 0.00029706954956055
(347) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00029587745666504
(348) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00025582313537598
(349) DESCRIBE `itineraries` 0.0012819766998291
(350) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '73186') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00069189071655273
(351) DESCRIBE `ports` 0.0014200210571289
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00043201446533203
(353) DESCRIBE `ports` 0.0013809204101562
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00037193298339844
(355) DESCRIBE `ports` 0.0013010501861572
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00030016899108887
(357) DESCRIBE `sailingdates` 0.001201868057251
(358) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '73186') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.000762939453125
(359) DESCRIBE `ports` 0.0013189315795898
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00034880638122559
(361) DESCRIBE `ports` 0.001248836517334
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00028896331787109
(363) DESCRIBE `ports` 0.0012760162353516
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00029897689819336
(365) DESCRIBE `ports` 0.0012538433074951
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00027680397033691
(367) DESCRIBE `ports` 0.0012919902801514
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00033307075500488
(369) DESCRIBE `ports` 0.001774787902832
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00041699409484863
(371) DESCRIBE `ports` 0.0017540454864502
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 347))) 0.00040507316589355
(373) DESCRIBE `ports` 0.0018060207366943
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '347') 0.00036501884460449
(375) DESCRIBE `ports` 0.0018250942230225
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00039100646972656
(377) DESCRIBE `ports` 0.0017299652099609
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00036287307739258
(379) DESCRIBE `ports` 0.0017740726470947
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00038790702819824
(381) DESCRIBE `ports` 0.0017499923706055
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00036001205444336
(383) DESCRIBE `ports` 0.0017790794372559
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0004119873046875
(385) DESCRIBE `ports` 0.0017998218536377
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00038003921508789
(387) DESCRIBE `ports` 0.00174880027771
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00040888786315918
(389) DESCRIBE `ports` 0.0014979839324951
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00033903121948242
(391) DESCRIBE `ports` 0.0015518665313721
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00044083595275879
(393) DESCRIBE `ports` 0.0016639232635498
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00038313865661621
(395) DESCRIBE `ports` 0.0017561912536621
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00046896934509277
(397) DESCRIBE `ports` 0.0017819404602051
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00036787986755371
(399) DESCRIBE `ports` 0.001723051071167
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00033807754516602
(401) DESCRIBE `ports` 0.0012748241424561
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00034594535827637
(403) DESCRIBE `ports` 0.0012478828430176
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00031208992004395
(405) DESCRIBE `ports` 0.0012400150299072
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00028610229492188
(407) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '73186') AND (sailingdate >= '2018-12-21') 0.0048458576202393
(408) DESCRIBE `avid_specials` 0.0013818740844727
(409) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73186 and class = 'Cruise') OR (item_id = 1415 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 12 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.0016069412231445
(410) DESCRIBE `cruiselines` 0.0025801658630371
(411) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00035214424133301
(412) DESCRIBE `orchid_image` 0.0014269351959229
(413) DESCRIBE `cruiselines` 0.0018129348754883
(414) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00030899047851562
(415) DESCRIBE `cruises` 0.002979040145874
(416) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63133') 0.00046205520629883
(417) DESCRIBE `ships` 0.0037767887115479
(418) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1067))) 0.00059700012207031
(419) DESCRIBE `ships` 0.0027408599853516
(420) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1067') 0.00033688545227051
(421) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027012825012207
(422) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025606155395508
(423) DESCRIBE `itineraries` 0.0012898445129395
(424) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63133') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00048995018005371
(425) DESCRIBE `ports` 0.0013670921325684
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00031399726867676
(427) DESCRIBE `ports` 0.0012478828430176
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00029110908508301
(429) DESCRIBE `ports` 0.0012960433959961
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00027990341186523
(431) DESCRIBE `sailingdates` 0.001101016998291
(432) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63133') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00083804130554199
(433) DESCRIBE `ports` 0.0013971328735352
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.0003199577331543
(435) DESCRIBE `ports` 0.0012688636779785
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00027990341186523
(437) DESCRIBE `ports` 0.0012810230255127
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00030994415283203
(439) DESCRIBE `ports` 0.0012929439544678
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00031805038452148
(441) DESCRIBE `ports` 0.0013630390167236
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00029587745666504
(443) DESCRIBE `ports` 0.0012631416320801
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.0002739429473877
(445) DESCRIBE `ports` 0.001349925994873
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00028777122497559
(447) DESCRIBE `ports` 0.0012810230255127
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00026988983154297
(449) DESCRIBE `ports` 0.0012991428375244
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 55))) 0.00029397010803223
(451) DESCRIBE `ports` 0.0012907981872559
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '55') 0.00027918815612793
(453) DESCRIBE `ports` 0.0012428760528564
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 308))) 0.00035309791564941
(455) DESCRIBE `ports` 0.001270055770874
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '308') 0.0002741813659668
(457) DESCRIBE `ports` 0.00136399269104
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 679))) 0.00029683113098145
(459) DESCRIBE `ports` 0.0013129711151123
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '679') 0.00027298927307129
(461) DESCRIBE `ports` 0.0013041496276855
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00029206275939941
(463) DESCRIBE `ports` 0.0014941692352295
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00030398368835449
(465) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63133') AND (sailingdate >= '2018-12-21') 0.0053279399871826
(466) DESCRIBE `avid_specials` 0.0018150806427002
(467) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63133 and class = 'Cruise') OR (item_id = 1067 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 12 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.0018870830535889
(468) DESCRIBE `cruiselines` 0.0025808811187744
(469) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00053191184997559
(470) DESCRIBE `orchid_image` 0.0019829273223877
(471) DESCRIBE `cruiselines` 0.002277135848999
(472) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00045394897460938
(473) DESCRIBE `cruises` 0.0028159618377686
(474) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62653') 0.0003359317779541
(475) DESCRIBE `ships` 0.0025789737701416
(476) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 738))) 0.00037908554077148
(477) DESCRIBE `ships` 0.0027589797973633
(478) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '738') 0.00029897689819336
(479) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026798248291016
(480) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029587745666504
(481) DESCRIBE `itineraries` 0.0013320446014404
(482) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62653') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00062108039855957
(483) DESCRIBE `ports` 0.0012979507446289
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00030803680419922
(485) DESCRIBE `ports` 0.00130295753479
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.0002901554107666
(487) DESCRIBE `ports` 0.0012550354003906
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.0002748966217041
(489) DESCRIBE `sailingdates` 0.0011370182037354
(490) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62653') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00052905082702637
(491) DESCRIBE `ports` 0.0014340877532959
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00033688545227051
(493) DESCRIBE `ports` 0.0012540817260742
(494) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00027894973754883
(495) DESCRIBE `ports` 0.0012428760528564
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.00029587745666504
(497) DESCRIBE `ports` 0.0012378692626953
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.00030088424682617
(499) DESCRIBE `ports` 0.0012478828430176
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3079))) 0.00029516220092773
(501) DESCRIBE `ports` 0.0012509822845459
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3079') 0.00027608871459961
(503) DESCRIBE `ports` 0.0014059543609619
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00029587745666504
(505) DESCRIBE `ports` 0.001399040222168
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00027799606323242
(507) DESCRIBE `ports` 0.0012631416320801
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1064))) 0.00033903121948242
(509) DESCRIBE `ports` 0.0016200542449951
(510) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1064') 0.0003209114074707
(511) DESCRIBE `ports` 0.001533031463623
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00033307075500488
(513) DESCRIBE `ports` 0.0014011859893799
(514) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00028204917907715
(515) DESCRIBE `ports` 0.0013420581817627
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00064492225646973
(517) DESCRIBE `ports` 0.0019419193267822
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00037407875061035
(519) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62653') AND (sailingdate >= '2018-12-21') 0.0058541297912598
(520) DESCRIBE `avid_specials` 0.001568078994751
(521) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62653 and class = 'Cruise') OR (item_id = 738 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 45 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.001121997833252
(522) DESCRIBE `cruiselines` 0.0020551681518555
(523) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0003960132598877
(524) DESCRIBE `orchid_image` 0.0015060901641846
(525) DESCRIBE `cruiselines` 0.0017938613891602
(526) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00034785270690918
(527) DESCRIBE `cruises` 0.0030829906463623
(528) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69087') 0.00043487548828125
(529) DESCRIBE `ships` 0.0025880336761475
(530) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1588))) 0.00038981437683105
(531) DESCRIBE `ships` 0.0028860569000244
(532) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1588') 0.00039005279541016
(533) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027108192443848
(534) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025486946105957
(535) DESCRIBE `itineraries` 0.0013599395751953
(536) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69087') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00092506408691406
(537) DESCRIBE `ports` 0.0020499229431152
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00049090385437012
(539) DESCRIBE `ports` 0.0018799304962158
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00040602684020996
(541) DESCRIBE `ports` 0.0018618106842041
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00049519538879395
(543) DESCRIBE `sailingdates` 0.0016069412231445
(544) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69087') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00087690353393555
(545) DESCRIBE `ports` 0.0018739700317383
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00037288665771484
(547) DESCRIBE `ports` 0.0012061595916748
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00025796890258789
(549) DESCRIBE `ports` 0.0012409687042236
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 770))) 0.00031399726867676
(551) DESCRIBE `ports` 0.0012369155883789
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '770') 0.00027203559875488
(553) DESCRIBE `ports` 0.001230001449585
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 470))) 0.0002899169921875
(555) DESCRIBE `ports` 0.0012619495391846
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '470') 0.00026607513427734
(557) DESCRIBE `ports` 0.0012779235839844
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 769))) 0.00034499168395996
(559) DESCRIBE `ports` 0.0013301372528076
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '769') 0.00036120414733887
(561) DESCRIBE `ports` 0.0017819404602051
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2470))) 0.00038599967956543
(563) DESCRIBE `ports` 0.0018289089202881
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2470') 0.00028300285339355
(565) DESCRIBE `ports` 0.0017380714416504
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00036215782165527
(567) DESCRIBE `ports` 0.0017509460449219
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00037908554077148
(569) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69087') AND (sailingdate >= '2018-12-21') 0.0046100616455078
(570) DESCRIBE `avid_specials` 0.0012080669403076
(571) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69087 and class = 'Cruise') OR (item_id = 1588 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 37 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.0010859966278076
(572) DESCRIBE `cruiselines` 0.001835823059082
(573) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00031805038452148
(574) DESCRIBE `orchid_image` 0.0014171600341797
(575) DESCRIBE `cruiselines` 0.0017461776733398
(576) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00030016899108887
(577) DESCRIBE `ships` 0.0027809143066406
(578) SELECT `ships`.* FROM `ships` WHERE (id IN ('977', '1599', '1359', '1067', '1588', '407', '726', '1415', '462', '766', '452', '674', '553', '1717', '738', '610', '352')) ORDER BY FIND_IN_SET(id, '977,1599,1359,1067,1588,407,726,1415,462,766,452,674,553,1717,738,610,352') 0.0016481876373291
(579) DESCRIBE `cruisetypes` 0.0011069774627686
(580) DESCRIBE `destinations` 0.0017127990722656
(581) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '45', '26', '25', '28', '37', '52', '40', '38', '9', '49', '11', '21', '35')) ORDER BY FIND_IN_SET(id, '22,12,45,26,25,28,37,52,40,38,9,49,11,21,35') 0.0010929107666016
(582) DESCRIBE `cruiselines` 0.0020849704742432
(583) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00037789344787598
(584) DESCRIBE `cruiselines` 0.0019621849060059
(585) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00034499168395996