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

Total elapsed time: 0.58128547668457

# Query Time
(1) connect 0.00093483924865723
(2) DESCRIBE `cruises` 0.0030500888824463
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (60250, 60251, 68749, 68750, 68751, 68752)) ORDER BY FIND_IN_SET(id, '60250,60251,68749,68750,68751,68752') 0.001554012298584
(4) DESCRIBE `cruises` 0.0028820037841797
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60250') 0.0003669261932373
(6) DESCRIBE `ships` 0.0035450458526611
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00033187866210938
(8) DESCRIBE `ships` 0.0026340484619141
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00026798248291016
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026893615722656
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00024700164794922
(12) DESCRIBE `itineraries` 0.0017480850219727
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '60250') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00072288513183594
(14) DESCRIBE `ports` 0.0013928413391113
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00030207633972168
(16) DESCRIBE `ports` 0.0012710094451904
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00034904479980469
(18) DESCRIBE `ports` 0.0013079643249512
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00027894973754883
(20) DESCRIBE `sailingdates` 0.0012459754943848
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '60250') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0006859302520752
(22) DESCRIBE `ports` 0.0012938976287842
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00029206275939941
(24) DESCRIBE `ports` 0.001331090927124
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00035405158996582
(26) DESCRIBE `ports` 0.0016319751739502
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3021))) 0.00034618377685547
(28) DESCRIBE `ports` 0.0015408992767334
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3021') 0.00037193298339844
(30) DESCRIBE `ports` 0.001500129699707
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 417))) 0.00030398368835449
(32) DESCRIBE `ports` 0.0014820098876953
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '417') 0.00027298927307129
(34) DESCRIBE `ports` 0.0012509822845459
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1047))) 0.00029397010803223
(36) DESCRIBE `ports` 0.001352071762085
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1047') 0.0090820789337158
(38) DESCRIBE `ports` 0.0016400814056396
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00029706954956055
(40) DESCRIBE `ports` 0.0012359619140625
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00028705596923828
(42) DESCRIBE `ports` 0.0012350082397461
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00029301643371582
(44) DESCRIBE `ports` 0.0012240409851074
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00028395652770996
(46) DESCRIBE `ports` 0.0012331008911133
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1037))) 0.00028705596923828
(48) DESCRIBE `ports` 0.0012280941009521
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1037') 0.00026702880859375
(50) DESCRIBE `ports` 0.0012271404266357
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 24))) 0.00028514862060547
(52) DESCRIBE `ports` 0.0012719631195068
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '24') 0.00026702880859375
(54) DESCRIBE `ports` 0.0012259483337402
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 24))) 0.00027990341186523
(56) DESCRIBE `ports` 0.0013458728790283
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '24') 0.00026702880859375
(58) DESCRIBE `ports` 0.001230001449585
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2059))) 0.00029706954956055
(60) DESCRIBE `ports` 0.0012819766998291
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2059') 0.00026607513427734
(62) DESCRIBE `ports` 0.0012509822845459
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2480))) 0.0003049373626709
(64) DESCRIBE `ports` 0.001262903213501
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2480') 0.00027084350585938
(66) DESCRIBE `ports` 0.0012338161468506
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00028681755065918
(68) DESCRIBE `ports` 0.0015130043029785
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.0002748966217041
(70) DESCRIBE `ports` 0.001230001449585
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.0002899169921875
(72) DESCRIBE `ports` 0.001244068145752
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00026798248291016
(74) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '60250') AND (sailingdate >= '2018-12-06') AND (sailingdate <= '2019-02-21') 0.006882905960083
(75) DESCRIBE `avid_specials` 0.0012619495391846
(76) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60250 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 AND class = 'CruiseLine') OR (item_id = 35 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.0010459423065186
(77) DESCRIBE `cruiselines` 0.0019509792327881
(78) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00030899047851562
(79) DESCRIBE `orchid_image` 0.0013949871063232
(80) DESCRIBE `cruiselines` 0.0017728805541992
(81) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.0002739429473877
(82) DESCRIBE `cruises` 0.0024371147155762
(83) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60251') 0.00029611587524414
(84) DESCRIBE `ships` 0.0025210380554199
(85) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00034308433532715
(86) DESCRIBE `ships` 0.0024030208587646
(87) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.0003812313079834
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026321411132812
(89) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027990341186523
(90) DESCRIBE `itineraries` 0.003709077835083
(91) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '60251') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00065493583679199
(92) DESCRIBE `ports` 0.0014159679412842
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00032997131347656
(94) DESCRIBE `ports` 0.001784086227417
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.0002899169921875
(96) DESCRIBE `ports` 0.0012779235839844
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00028300285339355
(98) DESCRIBE `sailingdates` 0.0011568069458008
(99) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '60251') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00053000450134277
(100) DESCRIBE `ports` 0.0013468265533447
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00029802322387695
(102) DESCRIBE `ports` 0.0012781620025635
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00027179718017578
(104) DESCRIBE `ports` 0.0012819766998291
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 793))) 0.00029277801513672
(106) DESCRIBE `ports` 0.0012259483337402
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '793') 0.0003199577331543
(108) DESCRIBE `ports` 0.0013391971588135
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00029301643371582
(110) DESCRIBE `ports` 0.0012290477752686
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00026893615722656
(112) DESCRIBE `ports` 0.0014281272888184
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.0002899169921875
(114) DESCRIBE `ports` 0.0013010501861572
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.00027298927307129
(116) DESCRIBE `ports` 0.0012350082397461
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029897689819336
(118) DESCRIBE `ports` 0.00124192237854
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027012825012207
(120) DESCRIBE `ports` 0.0014240741729736
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028610229492188
(122) DESCRIBE `ports` 0.0012860298156738
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027203559875488
(124) DESCRIBE `ports` 0.0012331008911133
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028896331787109
(126) DESCRIBE `ports` 0.001276969909668
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027203559875488
(128) DESCRIBE `ports` 0.0014200210571289
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.0003349781036377
(130) DESCRIBE `ports` 0.0013251304626465
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00027894973754883
(132) DESCRIBE `ports` 0.001244068145752
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00029706954956055
(134) DESCRIBE `ports` 0.0012459754943848
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0002739429473877
(136) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '60251') AND (sailingdate >= '2018-12-06') AND (sailingdate <= '2019-02-21') 0.0051419734954834
(137) DESCRIBE `avid_specials` 0.0015799999237061
(138) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60251 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00096011161804199
(139) DESCRIBE `cruiselines` 0.0019938945770264
(140) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00031495094299316
(141) DESCRIBE `orchid_image` 0.0014081001281738
(142) DESCRIBE `cruiselines` 0.0017571449279785
(143) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00028204917907715
(144) DESCRIBE `cruises` 0.012108087539673
(145) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68749') 0.00042104721069336
(146) DESCRIBE `ships` 0.0029001235961914
(147) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00037217140197754
(148) DESCRIBE `ships` 0.0027110576629639
(149) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00054192543029785
(150) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003211498260498
(151) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00060701370239258
(152) DESCRIBE `itineraries` 0.0013830661773682
(153) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68749') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00081181526184082
(154) DESCRIBE `ports` 0.0015218257904053
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0004580020904541
(156) DESCRIBE `ports` 0.0013060569763184
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00037002563476562
(158) DESCRIBE `ports` 0.0015869140625
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00028395652770996
(160) DESCRIBE `sailingdates` 0.0011727809906006
(161) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68749') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00072479248046875
(162) DESCRIBE `ports` 0.0013210773468018
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0003058910369873
(164) DESCRIBE `ports` 0.0012950897216797
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0002739429473877
(166) DESCRIBE `ports` 0.0017330646514893
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00042319297790527
(168) DESCRIBE `ports` 0.0013759136199951
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00032210350036621
(170) DESCRIBE `ports` 0.0014729499816895
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00031709671020508
(172) DESCRIBE `ports` 0.0014050006866455
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00029993057250977
(174) DESCRIBE `ports` 0.0087718963623047
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00034499168395996
(176) DESCRIBE `ports` 0.0014481544494629
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00028300285339355
(178) DESCRIBE `ports` 0.0014300346374512
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00029492378234863
(180) DESCRIBE `ports` 0.0014071464538574
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.0002739429473877
(182) DESCRIBE `ports` 0.0014138221740723
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00029802322387695
(184) DESCRIBE `ports` 0.0013229846954346
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.0076248645782471
(186) DESCRIBE `ports` 0.0013449192047119
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00029706954956055
(188) DESCRIBE `ports` 0.0013430118560791
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00031781196594238
(190) DESCRIBE `ports` 0.001244068145752
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00029397010803223
(192) DESCRIBE `ports` 0.0012619495391846
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00027203559875488
(194) DESCRIBE `ports` 0.0012409687042236
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1921))) 0.0056169033050537
(196) DESCRIBE `ports` 0.0017359256744385
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1921') 0.00028109550476074
(198) DESCRIBE `ports` 0.0016160011291504
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.0003349781036377
(200) DESCRIBE `ports` 0.0013229846954346
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00027298927307129
(202) DESCRIBE `ports` 0.0059189796447754
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00028800964355469
(204) DESCRIBE `ports` 0.0013308525085449
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00026512145996094
(206) DESCRIBE `ports` 0.0013139247894287
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.0056078433990479
(208) DESCRIBE `ports` 0.0013539791107178
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.0002739429473877
(210) DESCRIBE `ports` 0.0013139247894287
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00030303001403809
(212) DESCRIBE `ports` 0.0012609958648682
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00026988983154297
(214) DESCRIBE `ports` 0.0012509822845459
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.007728099822998
(216) DESCRIBE `ports` 0.0013458728790283
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00028705596923828
(218) DESCRIBE `ports` 0.0013120174407959
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00029087066650391
(220) DESCRIBE `ports` 0.0013480186462402
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00027298927307129
(222) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68749') AND (sailingdate >= '2018-12-06') AND (sailingdate <= '2019-02-21') 0.013207197189331
(223) DESCRIBE `avid_specials` 0.0016789436340332
(224) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68749 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 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.0011730194091797
(225) DESCRIBE `cruiselines` 0.0018818378448486
(226) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00032281875610352
(227) DESCRIBE `orchid_image` 0.0015079975128174
(228) DESCRIBE `cruiselines` 0.01109504699707
(229) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00030899047851562
(230) DESCRIBE `cruises` 0.0027449131011963
(231) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68750') 0.00036787986755371
(232) DESCRIBE `ships` 0.0026648044586182
(233) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.0081460475921631
(234) DESCRIBE `ships` 0.0028040409088135
(235) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00027585029602051
(236) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031185150146484
(237) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025320053100586
(238) DESCRIBE `itineraries` 0.0013020038604736
(239) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68750') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012400150299072
(240) DESCRIBE `ports` 0.0014209747314453
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00032305717468262
(242) DESCRIBE `ports` 0.0012590885162354
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00028395652770996
(244) DESCRIBE `ports` 0.0012550354003906
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00026893615722656
(246) DESCRIBE `sailingdates` 0.0011000633239746
(247) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68750') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00048685073852539
(248) DESCRIBE `ports` 0.001244068145752
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00028514862060547
(250) DESCRIBE `ports` 0.0012929439544678
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00026798248291016
(252) DESCRIBE `ports` 0.0012249946594238
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00029397010803223
(254) DESCRIBE `ports` 0.0012850761413574
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00030803680419922
(256) DESCRIBE `ports` 0.0014901161193848
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00031590461730957
(258) DESCRIBE `ports` 0.001331090927124
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00028204917907715
(260) DESCRIBE `ports` 0.0012829303741455
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2586))) 0.00030112266540527
(262) DESCRIBE `ports` 0.0013031959533691
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2586') 0.0002899169921875
(264) DESCRIBE `ports` 0.0013430118560791
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00035405158996582
(266) DESCRIBE `ports` 0.001309871673584
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00026202201843262
(268) DESCRIBE `ports` 0.0012540817260742
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00028610229492188
(270) DESCRIBE `ports` 0.0013208389282227
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.0003209114074707
(272) DESCRIBE `ports` 0.0012750625610352
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.0002901554107666
(274) DESCRIBE `ports` 0.00154709815979
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00032591819763184
(276) DESCRIBE `ports` 0.0013668537139893
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1921))) 0.00033187866210938
(278) DESCRIBE `ports` 0.0014350414276123
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1921') 0.00027012825012207
(280) DESCRIBE `ports` 0.0012650489807129
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00028586387634277
(282) DESCRIBE `ports` 0.0012750625610352
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00026512145996094
(284) DESCRIBE `ports` 0.0012421607971191
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00028395652770996
(286) DESCRIBE `ports` 0.001270055770874
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00026488304138184
(288) DESCRIBE `ports` 0.0012409687042236
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00030803680419922
(290) DESCRIBE `ports` 0.0012989044189453
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00026583671569824
(292) DESCRIBE `ports` 0.0012209415435791
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1919))) 0.00033402442932129
(294) DESCRIBE `ports` 0.0012259483337402
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1919') 0.00027108192443848
(296) DESCRIBE `ports` 0.0012190341949463
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00033712387084961
(298) DESCRIBE `ports` 0.001223087310791
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00027608871459961
(300) DESCRIBE `ports` 0.001223087310791
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00030899047851562
(302) DESCRIBE `ports` 0.0012269020080566
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00026607513427734
(304) DESCRIBE `ports` 0.0013301372528076
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029802322387695
(306) DESCRIBE `ports` 0.0012350082397461
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026512145996094
(308) DESCRIBE `ports` 0.0012791156768799
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003058910369873
(310) DESCRIBE `ports` 0.00136399269104
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026607513427734
(312) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68750') AND (sailingdate >= '2018-12-06') AND (sailingdate <= '2019-02-21') 0.0048038959503174
(313) DESCRIBE `avid_specials` 0.0012640953063965
(314) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68750 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 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.00093913078308105
(315) DESCRIBE `cruiselines` 0.0018689632415771
(316) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00029802322387695
(317) DESCRIBE `orchid_image` 0.0014750957489014
(318) DESCRIBE `cruiselines` 0.0017211437225342
(319) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00026702880859375
(320) DESCRIBE `cruises` 0.0023860931396484
(321) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68751') 0.0003211498260498
(322) DESCRIBE `ships` 0.0024468898773193
(323) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00032615661621094
(324) DESCRIBE `ships` 0.0026350021362305
(325) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00027894973754883
(326) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030684471130371
(327) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025010108947754
(328) DESCRIBE `itineraries` 0.0012228488922119
(329) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68751') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00048708915710449
(330) DESCRIBE `ports` 0.0012550354003906
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032687187194824
(332) DESCRIBE `ports` 0.001345157623291
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034689903259277
(334) DESCRIBE `ports` 0.0014779567718506
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040507316589355
(336) DESCRIBE `sailingdates` 0.0014870166778564
(337) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68751') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00052714347839355
(338) DESCRIBE `ports` 0.0015890598297119
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00057291984558105
(340) DESCRIBE `ports` 0.0021212100982666
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038695335388184
(342) DESCRIBE `ports` 0.0016348361968994
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00040102005004883
(344) DESCRIBE `ports` 0.0017421245574951
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00040888786315918
(346) DESCRIBE `ports` 0.0020639896392822
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00043296813964844
(348) DESCRIBE `ports` 0.0016899108886719
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00035405158996582
(350) DESCRIBE `ports` 0.0018467903137207
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00029611587524414
(352) DESCRIBE `ports` 0.0013320446014404
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00027799606323242
(354) DESCRIBE `ports` 0.0013689994812012
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00030016899108887
(356) DESCRIBE `ports` 0.0017380714416504
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00030303001403809
(358) DESCRIBE `ports` 0.0016331672668457
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00032591819763184
(360) DESCRIBE `ports` 0.0016920566558838
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00029706954956055
(362) DESCRIBE `ports` 0.0016858577728271
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1472))) 0.00047016143798828
(364) DESCRIBE `ports` 0.0016689300537109
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1472') 0.00039792060852051
(366) DESCRIBE `ports` 0.0013070106506348
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00027894973754883
(368) DESCRIBE `ports` 0.0013620853424072
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00026702880859375
(370) DESCRIBE `ports` 0.0013060569763184
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00034213066101074
(372) DESCRIBE `ports` 0.0012609958648682
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00026917457580566
(374) DESCRIBE `ports` 0.0017509460449219
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.0003960132598877
(376) DESCRIBE `ports` 0.0017549991607666
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00037193298339844
(378) DESCRIBE `ports` 0.0021359920501709
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0004730224609375
(380) DESCRIBE `ports` 0.0015249252319336
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00028610229492188
(382) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68751') AND (sailingdate >= '2018-12-06') AND (sailingdate <= '2019-02-21') 0.0048480033874512
(383) DESCRIBE `avid_specials` 0.0012040138244629
(384) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68751 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 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.0010278224945068
(385) DESCRIBE `cruiselines` 0.00187087059021
(386) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.0003209114074707
(387) DESCRIBE `orchid_image` 0.0015900135040283
(388) DESCRIBE `cruiselines` 0.0020999908447266
(389) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00036311149597168
(390) DESCRIBE `cruises` 0.0025908946990967
(391) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68752') 0.00029397010803223
(392) DESCRIBE `ships` 0.0025811195373535
(393) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00031590461730957
(394) DESCRIBE `ships` 0.0028579235076904
(395) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00027108192443848
(396) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034904479980469
(397) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026607513427734
(398) DESCRIBE `itineraries` 0.0016767978668213
(399) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68752') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.001101016998291
(400) DESCRIBE `ports` 0.0016441345214844
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0003960132598877
(402) DESCRIBE `ports` 0.0012819766998291
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00030112266540527
(404) DESCRIBE `ports` 0.0013360977172852
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00029516220092773
(406) DESCRIBE `sailingdates` 0.0011961460113525
(407) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68752') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00054788589477539
(408) DESCRIBE `ports` 0.0013518333435059
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00033402442932129
(410) DESCRIBE `ports` 0.001309871673584
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00028300285339355
(412) DESCRIBE `ports` 0.0012149810791016
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00028085708618164
(414) DESCRIBE `ports` 0.0012590885162354
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00026297569274902
(416) DESCRIBE `ports` 0.0012259483337402
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2586))) 0.00028085708618164
(418) DESCRIBE `ports` 0.0012969970703125
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2586') 0.00026297569274902
(420) DESCRIBE `ports` 0.0012199878692627
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00029611587524414
(422) DESCRIBE `ports` 0.0012218952178955
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00026297569274902
(424) DESCRIBE `ports` 0.0014228820800781
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00035500526428223
(426) DESCRIBE `ports` 0.0012481212615967
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00026988983154297
(428) DESCRIBE `ports` 0.0012550354003906
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1921))) 0.00028395652770996
(430) DESCRIBE `ports` 0.0014228820800781
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1921') 0.00033378601074219
(432) DESCRIBE `ports` 0.0012979507446289
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034499168395996
(434) DESCRIBE `ports` 0.0013260841369629
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029706954956055
(436) DESCRIBE `ports` 0.0012788772583008
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2553))) 0.00029611587524414
(438) DESCRIBE `ports` 0.0012280941009521
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2553') 0.00027990341186523
(440) DESCRIBE `ports` 0.0012438297271729
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 499))) 0.00028777122497559
(442) DESCRIBE `ports` 0.0012550354003906
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '499') 0.00026798248291016
(444) DESCRIBE `ports` 0.0012869834899902
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 121))) 0.00028705596923828
(446) DESCRIBE `ports` 0.0012819766998291
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '121') 0.00026702880859375
(448) DESCRIBE `ports` 0.0012259483337402
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00029993057250977
(450) DESCRIBE `ports` 0.0013189315795898
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00026988983154297
(452) DESCRIBE `ports` 0.0012598037719727
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00028610229492188
(454) DESCRIBE `ports` 0.001230001449585
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00026798248291016
(456) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68752') AND (sailingdate >= '2018-12-06') AND (sailingdate <= '2019-02-21') 0.0051250457763672
(457) DESCRIBE `avid_specials` 0.0015521049499512
(458) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68752 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 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.0017769336700439
(459) DESCRIBE `cruiselines` 0.0024490356445312
(460) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00040006637573242
(461) DESCRIBE `orchid_image` 0.0016419887542725
(462) DESCRIBE `cruiselines` 0.0019068717956543
(463) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00030803680419922
(464) DESCRIBE `cruisetypes` 0.001291036605835
(465) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '151') AND (cruises_and_specials.ship_id = '652') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.026288986206055
(466) DESCRIBE `destinations` 0.001924991607666
(467) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8', '35')) ORDER BY FIND_IN_SET(id, '43,8,35') 0.00065898895263672
(468) DESCRIBE `cruiselines` 0.0019919872283936
(469) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00035285949707031
(470) DESCRIBE `ships` 0.0026240348815918
(471) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00033116340637207
(472) DESCRIBE `cruiselines` 0.0020430088043213
(473) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00030517578125
(474) DESCRIBE `ships` 0.0035760402679443
(475) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00066280364990234