or, enquire about your chosen options

  1. Review: China – Part Two
  2. Catch Up on Cruising: Latest News in bite size!
  3. Review: China – Part One
  4. Catch Up on Cruising: Latest News in bite size!
  5. DESTINATION: ALASKA

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

Total elapsed time: 0.64481592178345

# Query Time
(1) connect 0.0049879550933838
(2) DESCRIBE `cruises` 0.0033769607543945
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (69896, 69878, 69863, 69879, 69892, 69864, 69881, 69893, 69861, 69882)) ORDER BY FIND_IN_SET(id, '69896,69878,69863,69879,69892,69864,69881,69893,69861,69882') 0.0014898777008057
(4) DESCRIBE `cruises` 0.0033779144287109
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69896') 0.00047802925109863
(6) DESCRIBE `ships` 0.0037360191345215
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00049495697021484
(8) DESCRIBE `ships` 0.0034291744232178
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.00037503242492676
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030398368835449
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003349781036377
(12) DESCRIBE `itineraries` 0.0015938282012939
(13) DESCRIBE `ports` 0.0020179748535156
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049114227294922
(15) DESCRIBE `ports` 0.0014421939849854
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046181678771973
(17) DESCRIBE `ports` 0.0016961097717285
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028085708618164
(19) DESCRIBE `sailingdates` 0.00146484375
(20) DESCRIBE `ports` 0.0017731189727783
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003809928894043
(22) DESCRIBE `ports` 0.0016570091247559
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00033807754516602
(24) DESCRIBE `ports` 0.0015227794647217
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00037693977355957
(26) DESCRIBE `ports` 0.0012369155883789
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00027298927307129
(28) DESCRIBE `ports` 0.0012538433074951
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00040507316589355
(30) DESCRIBE `ports` 0.0012259483337402
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00026297569274902
(32) DESCRIBE `ports` 0.0012390613555908
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00029206275939941
(34) DESCRIBE `ports` 0.0012249946594238
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00026106834411621
(36) DESCRIBE `ports` 0.0012428760528564
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00039482116699219
(38) DESCRIBE `ports` 0.0012359619140625
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00027203559875488
(40) DESCRIBE `ports` 0.0013060569763184
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00029897689819336
(42) DESCRIBE `ports` 0.0014150142669678
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00028491020202637
(44) DESCRIBE `ports` 0.001349925994873
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00028586387634277
(46) DESCRIBE `ports` 0.0012509822845459
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00030994415283203
(48) DESCRIBE `ports` 0.0017099380493164
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00040102005004883
(50) DESCRIBE `ports` 0.0017998218536377
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00035810470581055
(52) DESCRIBE `ports` 0.00091314315795898
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00031590461730957
(54) DESCRIBE `ports` 0.0012588500976562
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00028419494628906
(56) DESCRIBE `ports` 0.00042510032653809
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033402442932129
(58) DESCRIBE `ports` 0.001230001449585
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0010089874267578
(60) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69896') AND (sailingdate >= '2019-01-01') 0.0069460868835449
(61) DESCRIBE `avid_specials` 0.0012378692626953
(62) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69896 and class = 'Cruise') OR (item_id = 287 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011391639709473
(63) DESCRIBE `cruiselines` 0.0022871494293213
(64) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00063300132751465
(65) DESCRIBE `orchid_image` 0.0015552043914795
(66) DESCRIBE `cruiselines` 0.0017919540405273
(67) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00028109550476074
(68) DESCRIBE `cruises` 0.0034298896789551
(69) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69878') 0
(70) DESCRIBE `ships` 0.0028140544891357
(71) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00041413307189941
(72) DESCRIBE `ships` 0.002633810043335
(73) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00059700012207031
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035190582275391
(75) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003359317779541
(76) DESCRIBE `itineraries` 0.00051593780517578
(77) DESCRIBE `ports` 0.0017819404602051
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027608871459961
(79) DESCRIBE `ports` 0.0013248920440674
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0013270378112793
(81) DESCRIBE `ports` 0.00063109397888184
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028586387634277
(83) DESCRIBE `sailingdates` 0.0011241436004639
(84) DESCRIBE `ports` 0.00066018104553223
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029110908508301
(86) DESCRIBE `ports` 0.0012269020080566
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0
(88) DESCRIBE `ports` 0.0009000301361084
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00030207633972168
(90) DESCRIBE `ports` 0.0015699863433838
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00027298927307129
(92) DESCRIBE `ports` 0.0013039112091064
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00027680397033691
(94) DESCRIBE `ports` 0.0012590885162354
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00027203559875488
(96) DESCRIBE `ports` 0.001255989074707
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00030803680419922
(98) DESCRIBE `ports` 0.0012590885162354
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00027298927307129
(100) DESCRIBE `ports` 0.0013198852539062
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00028800964355469
(102) DESCRIBE `ports` 0.0012478828430176
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00026702880859375
(104) DESCRIBE `ports` 0.0012991428375244
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00029993057250977
(106) DESCRIBE `ports` 0.0012459754943848
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00026917457580566
(108) DESCRIBE `ports` 0.0012760162353516
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00028514862060547
(110) DESCRIBE `ports` 0.0017750263214111
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00015687942504883
(112) DESCRIBE `ports` 0.0012249946594238
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.0010921955108643
(114) DESCRIBE `ports` 0.00066494941711426
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00027012825012207
(116) DESCRIBE `ports` 0.0012271404266357
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 8.392333984375E-5
(118) DESCRIBE `ports` 0.00077009201049805
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026988983154297
(120) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69878') AND (sailingdate >= '2019-01-01') 0.0046710968017578
(121) DESCRIBE `avid_specials` 0.0012710094451904
(122) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69878 and class = 'Cruise') OR (item_id = 1330 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011329650878906
(123) DESCRIBE `cruiselines` 0.0019729137420654
(124) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00029993057250977
(125) DESCRIBE `orchid_image` 0.0013978481292725
(126) DESCRIBE `cruiselines` 0.0012111663818359
(127) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00029206275939941
(128) DESCRIBE `cruises` 0.0027709007263184
(129) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69863') 0.00029420852661133
(130) DESCRIBE `ships` 0.0025520324707031
(131) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 262))) 0.00046682357788086
(132) DESCRIBE `ships` 0.0023322105407715
(133) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '262') 0.00087308883666992
(134) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 6.4849853515625E-5
(135) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027704238891602
(136) DESCRIBE `itineraries` 0.0014021396636963
(137) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69863') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0024800300598145
(138) DESCRIBE `ports` 0.001539945602417
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033903121948242
(140) DESCRIBE `ports` 0.0012590885162354
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034499168395996
(142) DESCRIBE `ports` 0.0017621517181396
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003659725189209
(144) DESCRIBE `sailingdates` 0.0011458396911621
(145) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69863') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00064897537231445
(146) DESCRIBE `ports` 0.001317024230957
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030803680419922
(148) DESCRIBE `ports` 0.0013229846954346
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002751350402832
(150) DESCRIBE `ports` 0.0012578964233398
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00029492378234863
(152) DESCRIBE `ports` 0.0012180805206299
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00030708312988281
(154) DESCRIBE `ports` 0.0014679431915283
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00031208992004395
(156) DESCRIBE `ports` 0.0012409687042236
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.0002748966217041
(158) DESCRIBE `ports` 0.0013329982757568
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00029206275939941
(160) DESCRIBE `ports` 0.0012400150299072
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00027108192443848
(162) DESCRIBE `ports` 0.0012838840484619
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00029897689819336
(164) DESCRIBE `ports` 0.0015339851379395
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00029611587524414
(166) DESCRIBE `ports` 0.0015509128570557
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032997131347656
(168) DESCRIBE `ports` 0.0013110637664795
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027298927307129
(170) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69863') AND (sailingdate >= '2019-01-01') 0.0047500133514404
(171) DESCRIBE `avid_specials` 0.0011541843414307
(172) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69863 and class = 'Cruise') OR (item_id = 262 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0009920597076416
(173) DESCRIBE `cruiselines` 0.0018050670623779
(174) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00030088424682617
(175) DESCRIBE `orchid_image` 0.0014021396636963
(176) DESCRIBE `cruiselines` 0.0018370151519775
(177) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00026702880859375
(178) DESCRIBE `cruises` 0.0032000541687012
(179) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69879') 0.00028705596923828
(180) DESCRIBE `ships` 0.0024678707122803
(181) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00036907196044922
(182) DESCRIBE `ships` 0.002547025680542
(183) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00030398368835449
(184) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026583671569824
(185) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0009760856628418
(186) DESCRIBE `itineraries` 0.00075387954711914
(187) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69879') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00040006637573242
(188) DESCRIBE `ports` 0.00035810470581055
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030779838562012
(190) DESCRIBE `ports` 0.0012638568878174
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0
(192) DESCRIBE `ports` 0.00088405609130859
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026202201843262
(194) DESCRIBE `sailingdates` 0.0010979175567627
(195) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69879') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0
(196) DESCRIBE `ports` 0.0012600421905518
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0012619495391846
(198) DESCRIBE `ports` 0.00060915946960449
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026106834411621
(200) DESCRIBE `ports` 0.0012779235839844
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00038886070251465
(202) DESCRIBE `ports` 0.00078892707824707
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00032210350036621
(204) DESCRIBE `ports` 0.0014450550079346
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00030398368835449
(206) DESCRIBE `ports` 0.0013279914855957
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0
(208) DESCRIBE `ports` 0.00081300735473633
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00029087066650391
(210) DESCRIBE `ports` 0.0021591186523438
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0
(212) DESCRIBE `ports` 0.0012698173522949
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031208992004395
(214) DESCRIBE `ports` 0.0012919902801514
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023198127746582
(216) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69879') AND (sailingdate >= '2019-01-01') 0.0049619674682617
(217) DESCRIBE `avid_specials` 0.0011699199676514
(218) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69879 and class = 'Cruise') OR (item_id = 1330 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010049343109131
(219) DESCRIBE `cruiselines` 0.0018019676208496
(220) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00031685829162598
(221) DESCRIBE `orchid_image` 0.0013329982757568
(222) DESCRIBE `cruiselines` 0.0020508766174316
(223) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00033092498779297
(224) DESCRIBE `cruises` 0.0027210712432861
(225) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69892') 0.00030398368835449
(226) DESCRIBE `ships` 0.0025980472564697
(227) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00036215782165527
(228) DESCRIBE `ships` 0.002485990524292
(229) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.00026106834411621
(230) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002591609954834
(231) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024700164794922
(232) DESCRIBE `itineraries` 0.0012259483337402
(233) DESCRIBE `ports` 0.0013110637664795
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004119873046875
(235) DESCRIBE `ports` 0.0012450218200684
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029397010803223
(237) DESCRIBE `ports` 0.0013880729675293
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028014183044434
(239) DESCRIBE `sailingdates` 0.0011351108551025
(240) DESCRIBE `ports` 0.0012631416320801
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003361701965332
(242) DESCRIBE `ports` 0.0012681484222412
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026917457580566
(244) DESCRIBE `ports` 0.0012688636779785
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00030708312988281
(246) DESCRIBE `ports` 0.0012869834899902
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00026917457580566
(248) DESCRIBE `ports` 0.0012779235839844
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00030279159545898
(250) DESCRIBE `ports` 0.001863956451416
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00032210350036621
(252) DESCRIBE `ports` 0.001284122467041
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.0003211498260498
(254) DESCRIBE `ports` 0.0014331340789795
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00028300285339355
(256) DESCRIBE `ports` 0.0013120174407959
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00020289421081543
(258) DESCRIBE `ports` 0.0012588500976562
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00026893615722656
(260) DESCRIBE `ports` 0.0012798309326172
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00030708312988281
(262) DESCRIBE `ports` 0.0012669563293457
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00040507316589355
(264) DESCRIBE `ports` 0.0012950897216797
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00034999847412109
(266) DESCRIBE `ports` 0.0014328956604004
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00036382675170898
(268) DESCRIBE `ports` 0.0012710094451904
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00030398368835449
(270) DESCRIBE `ports` 0.0013399124145508
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00026702880859375
(272) DESCRIBE `ports` 0.0017681121826172
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00040507316589355
(274) DESCRIBE `ports` 0.0013298988342285
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00028300285339355
(276) DESCRIBE `ports` 0.0013959407806396
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0003509521484375
(278) DESCRIBE `ports` 0.0013248920440674
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00027608871459961
(280) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69892') AND (sailingdate >= '2019-01-01') 0.0051729679107666
(281) DESCRIBE `avid_specials` 0.0013718605041504
(282) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69892 and class = 'Cruise') OR (item_id = 287 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0014498233795166
(283) DESCRIBE `cruiselines` 0.0018830299377441
(284) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00036382675170898
(285) DESCRIBE `orchid_image` 0.0014030933380127
(286) DESCRIBE `cruiselines` 0.0017859935760498
(287) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.0003359317779541
(288) DESCRIBE `cruises` 0.002946138381958
(289) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69864') 0.0013198852539062
(290) DESCRIBE `ships` 0.0030369758605957
(291) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 262))) 0.00038695335388184
(292) DESCRIBE `ships` 0.0030641555786133
(293) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '262') 0.00040507316589355
(294) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032901763916016
(295) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031304359436035
(296) DESCRIBE `itineraries` 0.00072002410888672
(297) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69864') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0015411376953125
(298) DESCRIBE `ports` 0.0013899803161621
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033712387084961
(300) DESCRIBE `ports` 0.0012528896331787
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029301643371582
(302) DESCRIBE `ports` 0.0012869834899902
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028395652770996
(304) DESCRIBE `sailingdates` 0.0011191368103027
(305) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69864') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00044512748718262
(306) DESCRIBE `ports` 0.0012810230255127
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029897689819336
(308) DESCRIBE `ports` 0.0012428760528564
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026702880859375
(310) DESCRIBE `ports` 0.0012409687042236
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00031399726867676
(312) DESCRIBE `ports` 0.0013158321380615
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00026583671569824
(314) DESCRIBE `ports` 0.0012688636779785
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00029802322387695
(316) DESCRIBE `ports` 0.0012381076812744
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00026392936706543
(318) DESCRIBE `ports` 0.0013668537139893
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00030803680419922
(320) DESCRIBE `ports` 0.0012829303741455
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00026607513427734
(322) DESCRIBE `ports` 0.0012500286102295
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0003509521484375
(324) DESCRIBE `ports` 0.0014438629150391
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00028586387634277
(326) DESCRIBE `ports` 0.0012931823730469
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032401084899902
(328) DESCRIBE `ports` 0.0013341903686523
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031399726867676
(330) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69864') AND (sailingdate >= '2019-01-01') 0.0079030990600586
(331) DESCRIBE `avid_specials` 0.0019009113311768
(332) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69864 and class = 'Cruise') OR (item_id = 262 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016851425170898
(333) DESCRIBE `cruiselines` 0.0026009082794189
(334) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00064587593078613
(335) DESCRIBE `orchid_image` 0.002007007598877
(336) DESCRIBE `cruiselines` 0.0023398399353027
(337) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00046086311340332
(338) DESCRIBE `cruises` 0.0032789707183838
(339) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69881') 0.00040698051452637
(340) DESCRIBE `ships` 0.0028829574584961
(341) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00043416023254395
(342) DESCRIBE `ships` 0.0025608539581299
(343) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00051307678222656
(344) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00038599967956543
(345) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035214424133301
(346) DESCRIBE `itineraries` 0.0025420188903809
(347) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69881') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00059008598327637
(348) DESCRIBE `ports` 0.0012509822845459
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033998489379883
(350) DESCRIBE `ports` 0.0015771389007568
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030612945556641
(352) DESCRIBE `ports` 0.0016210079193115
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0
(354) DESCRIBE `sailingdates` 0.0013608932495117
(355) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69881') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00046205520629883
(356) DESCRIBE `ports` 0.0012879371643066
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031495094299316
(358) DESCRIBE `ports` 0.0015690326690674
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027608871459961
(360) DESCRIBE `ports` 0.0012378692626953
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00031399726867676
(362) DESCRIBE `ports` 0.0013110637664795
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00027203559875488
(364) DESCRIBE `ports` 0.0012390613555908
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00032997131347656
(366) DESCRIBE `ports` 0.0012679100036621
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00027203559875488
(368) DESCRIBE `ports` 0.0012409687042236
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00031208992004395
(370) DESCRIBE `ports` 0.0012459754943848
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00027203559875488
(372) DESCRIBE `ports` 0.0012850761413574
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00029802322387695
(374) DESCRIBE `ports` 0.001291036605835
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00029397010803223
(376) DESCRIBE `ports` 0.0015230178833008
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.0003209114074707
(378) DESCRIBE `ports` 0.0014128684997559
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.0003199577331543
(380) DESCRIBE `ports` 0.0014979839324951
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00030899047851562
(382) DESCRIBE `ports` 0.0013840198516846
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00027704238891602
(384) DESCRIBE `ports` 0.0012500286102295
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00030016899108887
(386) DESCRIBE `ports` 0.0012710094451904
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00027298927307129
(388) DESCRIBE `ports` 0.0012550354003906
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00031900405883789
(390) DESCRIBE `ports` 0.0012462139129639
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00034594535827637
(392) DESCRIBE `ports` 0.0013389587402344
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029993057250977
(394) DESCRIBE `ports` 0.0012409687042236
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027012825012207
(396) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69881') AND (sailingdate >= '2019-01-01') 0.0050868988037109
(397) DESCRIBE `avid_specials` 0.0013430118560791
(398) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69881 and class = 'Cruise') OR (item_id = 1330 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010490417480469
(399) DESCRIBE `cruiselines` 0.0020208358764648
(400) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00035691261291504
(401) DESCRIBE `orchid_image` 0.0017809867858887
(402) DESCRIBE `cruiselines` 0.0018680095672607
(403) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00028491020202637
(404) DESCRIBE `cruises` 0.0024559497833252
(405) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69893') 0.00029993057250977
(406) DESCRIBE `ships` 0.0025410652160645
(407) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00034403800964355
(408) DESCRIBE `ships` 0.0032989978790283
(409) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.00037002563476562
(410) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035500526428223
(411) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036811828613281
(412) DESCRIBE `itineraries` 0.0013899803161621
(413) DESCRIBE `ports` 0.0012860298156738
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00032520294189453
(415) DESCRIBE `ports` 0.0012509822845459
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00032210350036621
(417) DESCRIBE `ports` 0.0012609958648682
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0002899169921875
(419) DESCRIBE `sailingdates` 0.001162052154541
(420) DESCRIBE `ports` 0.0015931129455566
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00040888786315918
(422) DESCRIBE `ports` 0.0012879371643066
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00031590461730957
(424) DESCRIBE `ports` 0.0013010501861572
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00040507316589355
(426) DESCRIBE `ports` 0.0017118453979492
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00044798851013184
(428) DESCRIBE `ports` 0.0016810894012451
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00043201446533203
(430) DESCRIBE `ports` 0.0014588832855225
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00030803680419922
(432) DESCRIBE `ports` 0.0012731552124023
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.001378059387207
(434) DESCRIBE `ports` 0.0014438629150391
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.0002899169921875
(436) DESCRIBE `ports` 0.001284122467041
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00030016899108887
(438) DESCRIBE `ports` 0.0013110637664795
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00036001205444336
(440) DESCRIBE `ports` 0.0012881755828857
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00031304359436035
(442) DESCRIBE `ports` 0.0012879371643066
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00031614303588867
(444) DESCRIBE `ports` 0.0014398097991943
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00030398368835449
(446) DESCRIBE `ports` 0.0013020038604736
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00031495094299316
(448) DESCRIBE `ports` 0.0014369487762451
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00034904479980469
(450) DESCRIBE `ports` 0.0013420581817627
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00028300285339355
(452) DESCRIBE `ports` 0.0013618469238281
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00030207633972168
(454) DESCRIBE `ports` 0.0012922286987305
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.0002739429473877
(456) DESCRIBE `ports` 0.0014560222625732
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00029897689819336
(458) DESCRIBE `ports` 0.0017411708831787
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00043296813964844
(460) DESCRIBE `ports` 0.0013489723205566
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003049373626709
(462) DESCRIBE `ports` 0.0013360977172852
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036001205444336
(464) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69893') AND (sailingdate >= '2019-01-01') 0.0059511661529541
(465) DESCRIBE `avid_specials` 0.0015549659729004
(466) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69893 and class = 'Cruise') OR (item_id = 287 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010509490966797
(467) DESCRIBE `cruiselines` 0.0018870830535889
(468) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00032615661621094
(469) DESCRIBE `orchid_image` 0.0014820098876953
(470) DESCRIBE `cruiselines` 0.001798152923584
(471) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.0002748966217041
(472) DESCRIBE `cruises` 0.0024161338806152
(473) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69861') 0.00028896331787109
(474) DESCRIBE `ships` 0.0028350353240967
(475) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 262))) 0.00038599967956543
(476) DESCRIBE `ships` 0.002964973449707
(477) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '262') 0.00033307075500488
(478) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026702880859375
(479) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025391578674316
(480) DESCRIBE `itineraries` 0.0013511180877686
(481) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69861') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00043392181396484
(482) DESCRIBE `ports` 0.0018620491027832
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037384033203125
(484) DESCRIBE `ports` 0.0017268657684326
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004270076751709
(486) DESCRIBE `ports` 0.001410961151123
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028800964355469
(488) DESCRIBE `sailingdates` 0.001129150390625
(489) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69861') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00045204162597656
(490) DESCRIBE `ports` 0.0013351440429688
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030183792114258
(492) DESCRIBE `ports` 0.0012288093566895
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026392936706543
(494) DESCRIBE `ports` 0.0012571811676025
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00038790702819824
(496) DESCRIBE `ports` 0.0013449192047119
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00030183792114258
(498) DESCRIBE `ports` 0.00069999694824219
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00028705596923828
(500) DESCRIBE `ports` 0.0012340545654297
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00026702880859375
(502) DESCRIBE `ports` 0.0013599395751953
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00028491020202637
(504) DESCRIBE `ports` 0.0012269020080566
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.0003049373626709
(506) DESCRIBE `ports` 0.0012350082397461
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028777122497559
(508) DESCRIBE `ports` 0.0012350082397461
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026702880859375
(510) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69861') AND (sailingdate >= '2019-01-01') 0.0047380924224854
(511) DESCRIBE `avid_specials` 0.0011639595031738
(512) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69861 and class = 'Cruise') OR (item_id = 262 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0021898746490479
(513) DESCRIBE `cruiselines` 0.0018060207366943
(514) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00032186508178711
(515) DESCRIBE `orchid_image` 0.001370906829834
(516) DESCRIBE `cruiselines` 0.0017881393432617
(517) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00027799606323242
(518) DESCRIBE `cruises` 0.0031208992004395
(519) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69882') 0.0004580020904541
(520) DESCRIBE `ships` 0.0034959316253662
(521) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00053501129150391
(522) DESCRIBE `ships` 0.0029900074005127
(523) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00034403800964355
(524) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026392936706543
(525) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026392936706543
(526) DESCRIBE `itineraries` 0.0014090538024902
(527) DESCRIBE `ports` 0.0013289451599121
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032305717468262
(529) DESCRIBE `ports` 0.0012998580932617
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028610229492188
(531) DESCRIBE `ports` 0.0014088153839111
(532) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028181076049805
(533) DESCRIBE `sailingdates` 0.0012459754943848
(534) DESCRIBE `ports` 0.0013730525970459
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031280517578125
(536) DESCRIBE `ports` 0.0012350082397461
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00033402442932129
(538) DESCRIBE `ports` 0.0012660026550293
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00029993057250977
(540) DESCRIBE `ports` 0.0012421607971191
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00026607513427734
(542) DESCRIBE `ports` 0.0012562274932861
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00028610229492188
(544) DESCRIBE `ports` 0.0012681484222412
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00026488304138184
(546) DESCRIBE `ports` 0.0012400150299072
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00030112266540527
(548) DESCRIBE `ports` 0.0012929439544678
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00027084350585938
(550) DESCRIBE `ports` 0.0012381076812744
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00028705596923828
(552) DESCRIBE `ports` 0.0012619495391846
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00027298927307129
(554) DESCRIBE `ports` 0.0014150142669678
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00040698051452637
(556) DESCRIBE `ports` 0.0012581348419189
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00028204917907715
(558) DESCRIBE `ports` 0.001234769821167
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028896331787109
(560) DESCRIBE `ports` 0.0012340545654297
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028300285339355
(562) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69882') AND (sailingdate >= '2019-01-01') 0.0050618648529053
(563) DESCRIBE `avid_specials` 0.0012929439544678
(564) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69882 and class = 'Cruise') OR (item_id = 1330 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00055122375488281
(565) DESCRIBE `cruiselines` 0.0019741058349609
(566) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00031614303588867
(567) DESCRIBE `orchid_image` 0.0014519691467285
(568) DESCRIBE `cruiselines` 0.0018990039825439
(569) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00027894973754883
(570) DESCRIBE `ships` 0.0026140213012695
(571) SELECT `ships`.* FROM `ships` WHERE (id IN ('1330', '287', '124', '262')) ORDER BY FIND_IN_SET(id, '1330,287,124,262') 0.00068092346191406
(572) DESCRIBE `cruisetypes` 0.0010340213775635
(573) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruises_and_specials.destination_id = '43') AND (cruises_and_specials.cruiseline_id = '26') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.031880855560303
(574) DESCRIBE `cruiselines` 0.0022439956665039
(575) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.0004270076751709
(576) DESCRIBE `destinations` 0.0019588470458984
(577) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 43))) 0.0015101432800293
(578) DESCRIBE `destinations` 0.0016870498657227
(579) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 43))) 0.00031304359436035
(580) DESCRIBE `cruiselines` 0.0019960403442383
(581) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00029611587524414