or, enquire about your chosen options

  1. Should I buy a beverage package?
  2. SPOTLIGHT ON: Viking Ocean and River Cruises
  3. Catch Up on Cruising: Latest News in bite size!
  4. Catch Up on Cruising: Latest News in bite size!
  5. REVIEW: P & O Australia’s Pacific Aria

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

Total elapsed time: 0.66549110412598

# Query Time
(1) connect 0.0010311603546143
(2) DESCRIBE `cruises` 0.0041749477386475
(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.0027458667755127
(4) DESCRIBE `cruises` 0.0033321380615234
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62665') 0.00033807754516602
(6) DESCRIBE `ships` 0.0024681091308594
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00035977363586426
(8) DESCRIBE `ships` 0.0028579235076904
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00039291381835938
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003359317779541
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032901763916016
(12) DESCRIBE `itineraries` 0.0019140243530273
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62665') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00084400177001953
(14) DESCRIBE `ports` 0.0015408992767334
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00035619735717773
(16) DESCRIBE `ports` 0.0014519691467285
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00032901763916016
(18) DESCRIBE `ports` 0.0014009475708008
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00031208992004395
(20) DESCRIBE `sailingdates` 0.0012400150299072
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62665') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00096607208251953
(22) DESCRIBE `ports` 0.0016169548034668
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00036215782165527
(24) DESCRIBE `ports` 0.0013968944549561
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00027608871459961
(26) DESCRIBE `ports` 0.001230001449585
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00028204917907715
(28) DESCRIBE `ports` 0.0012180805206299
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00026106834411621
(30) DESCRIBE `ports` 0.0012140274047852
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0003058910369873
(32) DESCRIBE `ports` 0.0012249946594238
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0002589225769043
(34) DESCRIBE `ports` 0.001255989074707
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00030899047851562
(36) DESCRIBE `ports` 0.0012269020080566
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00034499168395996
(38) DESCRIBE `ports` 0.0013918876647949
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00029087066650391
(40) DESCRIBE `ports` 0.001230001449585
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00027108192443848
(42) DESCRIBE `ports` 0.0013010501861572
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0002899169921875
(44) DESCRIBE `ports` 0.0013110637664795
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00026798248291016
(46) DESCRIBE `ports` 0.0012681484222412
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00028705596923828
(48) DESCRIBE `ports` 0.001227855682373
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00026988983154297
(50) 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.0045149326324463
(51) DESCRIBE `avid_specials` 0.0012848377227783
(52) 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.0012969970703125
(53) DESCRIBE `cruiselines` 0.0021939277648926
(54) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00039505958557129
(55) DESCRIBE `orchid_image` 0.0017139911651611
(56) DESCRIBE `cruiselines` 0.0024039745330811
(57) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00036501884460449
(58) DESCRIBE `cruises` 0.0025699138641357
(59) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68109') 0.00032806396484375
(60) DESCRIBE `ships` 0.002655029296875
(61) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 766))) 0.00038886070251465
(62) DESCRIBE `ships` 0.0025038719177246
(63) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '766') 0.00028491020202637
(64) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026202201843262
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025105476379395
(66) DESCRIBE `itineraries` 0.0012450218200684
(67) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68109') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00063204765319824
(68) DESCRIBE `ports` 0.0013120174407959
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00033092498779297
(70) DESCRIBE `ports` 0.0012729167938232
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00029897689819336
(72) DESCRIBE `ports` 0.0014340877532959
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00036311149597168
(74) DESCRIBE `sailingdates` 0.0013799667358398
(75) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68109') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00073814392089844
(76) DESCRIBE `ports` 0.0014340877532959
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00033402442932129
(78) DESCRIBE `ports` 0.0012640953063965
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.0003659725189209
(80) DESCRIBE `ports` 0.0013010501861572
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00030708312988281
(82) DESCRIBE `ports` 0.001284122467041
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00027894973754883
(84) DESCRIBE `ports` 0.0012950897216797
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00030279159545898
(86) DESCRIBE `ports` 0.0014200210571289
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00027799606323242
(88) DESCRIBE `ports` 0.0012650489807129
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00030994415283203
(90) DESCRIBE `ports` 0.0013411045074463
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00029182434082031
(92) DESCRIBE `ports` 0.0013458728790283
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00037407875061035
(94) DESCRIBE `ports` 0.0015008449554443
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00029587745666504
(96) 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.0026650428771973
(97) DESCRIBE `avid_specials` 0.0013220310211182
(98) 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.0010409355163574
(99) DESCRIBE `cruiselines` 0.0019931793212891
(100) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00038480758666992
(101) DESCRIBE `orchid_image` 0.0018470287322998
(102) DESCRIBE `cruiselines` 0.0022420883178711
(103) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00036311149597168
(104) DESCRIBE `cruises` 0.002816915512085
(105) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70033') 0.00048089027404785
(106) DESCRIBE `ships` 0.0033111572265625
(107) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1415))) 0.00074291229248047
(108) DESCRIBE `ships` 0.0036499500274658
(109) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1415') 0.00049996376037598
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00036501884460449
(111) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00032591819763184
(112) DESCRIBE `itineraries` 0.0015499591827393
(113) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70033') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0005948543548584
(114) DESCRIBE `ports` 0.0014240741729736
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00034904479980469
(116) DESCRIBE `ports` 0.0015261173248291
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00039815902709961
(118) DESCRIBE `ports` 0.0013120174407959
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0003809928894043
(120) DESCRIBE `sailingdates` 0.0011270046234131
(121) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70033') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00088119506835938
(122) DESCRIBE `ports` 0.0014209747314453
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00033092498779297
(124) DESCRIBE `ports` 0.0012938976287842
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00028514862060547
(126) DESCRIBE `ports` 0.0013279914855957
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00029587745666504
(128) DESCRIBE `ports` 0.0012331008911133
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00026106834411621
(130) DESCRIBE `ports` 0.0012550354003906
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00034594535827637
(132) DESCRIBE `ports` 0.0012049674987793
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.0002748966217041
(134) DESCRIBE `ports` 0.0015020370483398
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 347))) 0.00033998489379883
(136) DESCRIBE `ports` 0.0012519359588623
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '347') 0.00027012825012207
(138) DESCRIBE `ports` 0.001399040222168
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00028300285339355
(140) DESCRIBE `ports` 0.0012788772583008
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.0002589225769043
(142) DESCRIBE `ports` 0.0012750625610352
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00029802322387695
(144) DESCRIBE `ports` 0.0012540817260742
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00032210350036621
(146) DESCRIBE `ports` 0.0012438297271729
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0003049373626709
(148) DESCRIBE `ports` 0.0012500286102295
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0002739429473877
(150) 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.0031998157501221
(151) DESCRIBE `avid_specials` 0.0013349056243896
(152) 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.0010209083557129
(153) DESCRIBE `cruiselines` 0.0018630027770996
(154) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00034213066101074
(155) DESCRIBE `orchid_image` 0.0014898777008057
(156) DESCRIBE `cruiselines` 0.0018138885498047
(157) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00039410591125488
(158) DESCRIBE `cruises` 0.0037679672241211
(159) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62661') 0.00046396255493164
(160) DESCRIBE `ships` 0.0037620067596436
(161) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00048398971557617
(162) DESCRIBE `ships` 0.0029900074005127
(163) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00039505958557129
(164) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003821849822998
(165) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025081634521484
(166) DESCRIBE `itineraries` 0.0013179779052734
(167) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62661') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00050711631774902
(168) DESCRIBE `ports` 0.001370906829834
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00034284591674805
(170) DESCRIBE `ports` 0.0012850761413574
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00029802322387695
(172) DESCRIBE `ports` 0.001270055770874
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00032401084899902
(174) DESCRIBE `sailingdates` 0.0011818408966064
(175) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62661') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0007328987121582
(176) DESCRIBE `ports` 0.0021228790283203
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00041508674621582
(178) DESCRIBE `ports` 0.001417875289917
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.0002901554107666
(180) DESCRIBE `ports` 0.0012571811676025
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00031399726867676
(182) DESCRIBE `ports` 0.0016160011291504
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0003058910369873
(184) DESCRIBE `ports` 0.0020649433135986
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00045490264892578
(186) DESCRIBE `ports` 0.0016341209411621
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.0003969669342041
(188) DESCRIBE `ports` 0.0013980865478516
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00036907196044922
(190) DESCRIBE `ports` 0.0013818740844727
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.0002901554107666
(192) DESCRIBE `ports` 0.0013349056243896
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00035500526428223
(194) DESCRIBE `ports` 0.0013148784637451
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00032210350036621
(196) DESCRIBE `ports` 0.0013628005981445
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.0003349781036377
(198) DESCRIBE `ports` 0.0012941360473633
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00032210350036621
(200) DESCRIBE `ports` 0.0013020038604736
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00034308433532715
(202) DESCRIBE `ports` 0.0013999938964844
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00029301643371582
(204) 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.0026209354400635
(205) DESCRIBE `avid_specials` 0.0013790130615234
(206) 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.0010900497436523
(207) DESCRIBE `cruiselines` 0.0018448829650879
(208) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0003509521484375
(209) DESCRIBE `orchid_image` 0.001492977142334
(210) DESCRIBE `cruiselines` 0.0017979145050049
(211) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00041818618774414
(212) DESCRIBE `cruises` 0.0036540031433105
(213) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69259') 0.00068306922912598
(214) DESCRIBE `ships` 0.0038480758666992
(215) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 553))) 0.00061988830566406
(216) DESCRIBE `ships` 0.0038959980010986
(217) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '553') 0.00050616264343262
(218) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034999847412109
(219) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00039196014404297
(220) DESCRIBE `itineraries` 0.0018558502197266
(221) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69259') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0009009838104248
(222) DESCRIBE `ports` 0.001878023147583
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.0003960132598877
(224) DESCRIBE `ports` 0.0014607906341553
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.0003669261932373
(226) DESCRIBE `ports` 0.0015439987182617
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00036811828613281
(228) DESCRIBE `sailingdates` 0.0014150142669678
(229) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69259') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00078678131103516
(230) DESCRIBE `ports` 0.0019688606262207
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00042200088500977
(232) DESCRIBE `ports` 0.0014951229095459
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00032305717468262
(234) DESCRIBE `ports` 0.0012950897216797
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2442))) 0.0003209114074707
(236) DESCRIBE `ports` 0.0012772083282471
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2442') 0.00027298927307129
(238) DESCRIBE `ports` 0.0013329982757568
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 709))) 0.00032711029052734
(240) DESCRIBE `ports` 0.0012578964233398
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '709') 0.00029420852661133
(242) DESCRIBE `ports` 0.001262903213501
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2965))) 0.0003659725189209
(244) DESCRIBE `ports` 0.0012509822845459
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2965') 0.00037598609924316
(246) DESCRIBE `ports` 0.0012469291687012
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00031685829162598
(248) DESCRIBE `ports` 0.0012791156768799
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00030303001403809
(250) 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.0026369094848633
(251) DESCRIBE `avid_specials` 0.0013580322265625
(252) 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.0010521411895752
(253) DESCRIBE `cruiselines` 0.0019011497497559
(254) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00034999847412109
(255) DESCRIBE `orchid_image` 0.001507043838501
(256) DESCRIBE `cruiselines` 0.0018510818481445
(257) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00032901763916016
(258) DESCRIBE `cruises` 0.0027291774749756
(259) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68315') 0.00050210952758789
(260) DESCRIBE `ships` 0.0026588439941406
(261) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1067))) 0.00046896934509277
(262) DESCRIBE `ships` 0.0027840137481689
(263) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1067') 0.00040292739868164
(264) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028300285339355
(265) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025701522827148
(266) DESCRIBE `itineraries` 0.0013530254364014
(267) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68315') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00079584121704102
(268) DESCRIBE `ports` 0.0016438961029053
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00035595893859863
(270) DESCRIBE `ports` 0.0012850761413574
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00031399726867676
(272) DESCRIBE `ports` 0.0016770362854004
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00031089782714844
(274) DESCRIBE `sailingdates` 0.001323938369751
(275) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68315') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00082111358642578
(276) DESCRIBE `ports` 0.0016119480133057
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00040197372436523
(278) DESCRIBE `ports` 0.001352071762085
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00030303001403809
(280) DESCRIBE `ports` 0.0013511180877686
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00037908554077148
(282) DESCRIBE `ports` 0.0012979507446289
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00028395652770996
(284) DESCRIBE `ports` 0.0013968944549561
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00041508674621582
(286) DESCRIBE `ports` 0.0013880729675293
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00036191940307617
(288) DESCRIBE `ports` 0.0012831687927246
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00030684471130371
(290) DESCRIBE `ports` 0.0013480186462402
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00033903121948242
(292) DESCRIBE `ports` 0.0012688636779785
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 55))) 0.00030279159545898
(294) DESCRIBE `ports` 0.0014350414276123
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '55') 0.00027799606323242
(296) DESCRIBE `ports` 0.0012581348419189
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 308))) 0.00037002563476562
(298) DESCRIBE `ports` 0.001539945602417
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '308') 0.00029993057250977
(300) DESCRIBE `ports` 0.0013480186462402
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 679))) 0.00031185150146484
(302) DESCRIBE `ports` 0.0012698173522949
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '679') 0.00031495094299316
(304) DESCRIBE `ports` 0.0013182163238525
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.0003659725189209
(306) DESCRIBE `ports` 0.0013148784637451
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00029611587524414
(308) DESCRIBE `ports` 0.0013010501861572
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00031709671020508
(310) DESCRIBE `ports` 0.0013618469238281
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00029778480529785
(312) DESCRIBE `ports` 0.0012650489807129
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 352))) 0.0003058910369873
(314) DESCRIBE `ports` 0.0012779235839844
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '352') 0.00027298927307129
(316) DESCRIBE `ports` 0.0012550354003906
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00031805038452148
(318) DESCRIBE `ports` 0.0013079643249512
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00026106834411621
(320) DESCRIBE `ports` 0.0012640953063965
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 663))) 0.00030303001403809
(322) DESCRIBE `ports` 0.0013120174407959
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '663') 0.00027012825012207
(324) DESCRIBE `ports` 0.0015299320220947
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00030803680419922
(326) DESCRIBE `ports` 0.0013899803161621
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00041508674621582
(328) DESCRIBE `ports` 0.0013110637664795
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00029397010803223
(330) DESCRIBE `ports` 0.0012950897216797
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00026512145996094
(332) DESCRIBE `ports` 0.0012791156768799
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.0003049373626709
(334) DESCRIBE `ports` 0.0013601779937744
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00028610229492188
(336) 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.0027711391448975
(337) DESCRIBE `avid_specials` 0.0012190341949463
(338) 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.0011670589447021
(339) DESCRIBE `cruiselines` 0.00205397605896
(340) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00035786628723145
(341) DESCRIBE `orchid_image` 0.0019462108612061
(342) DESCRIBE `cruiselines` 0.0025739669799805
(343) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00033998489379883
(344) DESCRIBE `cruises` 0.0024631023406982
(345) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73186') 0.00032997131347656
(346) DESCRIBE `ships` 0.0025131702423096
(347) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1415))) 0.00046181678771973
(348) DESCRIBE `ships` 0.0030949115753174
(349) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1415') 0.00038003921508789
(350) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00029301643371582
(351) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00026392936706543
(352) DESCRIBE `itineraries` 0.0014979839324951
(353) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '73186') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00047707557678223
(354) DESCRIBE `ports` 0.0014429092407227
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00035309791564941
(356) DESCRIBE `ports` 0.0014700889587402
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00032615661621094
(358) DESCRIBE `ports` 0.0013988018035889
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00037288665771484
(360) DESCRIBE `sailingdates` 0.0011148452758789
(361) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '73186') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00046396255493164
(362) DESCRIBE `ports` 0.0014388561248779
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0003359317779541
(364) DESCRIBE `ports` 0.0013141632080078
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00039792060852051
(366) DESCRIBE `ports` 0.0016059875488281
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0003209114074707
(368) DESCRIBE `ports` 0.0013189315795898
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00028800964355469
(370) DESCRIBE `ports` 0.0013229846954346
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00032401084899902
(372) DESCRIBE `ports` 0.0013430118560791
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00029611587524414
(374) DESCRIBE `ports` 0.0014410018920898
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 347))) 0.00033903121948242
(376) DESCRIBE `ports` 0.0013191699981689
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '347') 0.00028014183044434
(378) DESCRIBE `ports` 0.0013868808746338
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00030684471130371
(380) DESCRIBE `ports` 0.0012781620025635
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00030922889709473
(382) DESCRIBE `ports` 0.0013148784637451
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.0003058910369873
(384) DESCRIBE `ports` 0.0013887882232666
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00030899047851562
(386) DESCRIBE `ports` 0.0015721321105957
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00032901763916016
(388) DESCRIBE `ports` 0.001309871673584
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00029301643371582
(390) DESCRIBE `ports` 0.001270055770874
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00030994415283203
(392) DESCRIBE `ports` 0.0014030933380127
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00037312507629395
(394) DESCRIBE `ports` 0.0013558864593506
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00035691261291504
(396) DESCRIBE `ports` 0.0014631748199463
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00034093856811523
(398) DESCRIBE `ports` 0.0014050006866455
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00032401084899902
(400) DESCRIBE `ports` 0.0013439655303955
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00029587745666504
(402) DESCRIBE `ports` 0.0014619827270508
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00041103363037109
(404) DESCRIBE `ports` 0.0014870166778564
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00028491020202637
(406) DESCRIBE `ports` 0.0012891292572021
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00031614303588867
(408) DESCRIBE `ports` 0.001227855682373
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00028705596923828
(410) 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.0026698112487793
(411) DESCRIBE `avid_specials` 0.0012049674987793
(412) 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.0011138916015625
(413) DESCRIBE `cruiselines` 0.0019841194152832
(414) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00034809112548828
(415) DESCRIBE `orchid_image` 0.0014481544494629
(416) DESCRIBE `cruiselines` 0.0018751621246338
(417) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00029587745666504
(418) DESCRIBE `cruises` 0.0025460720062256
(419) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63133') 0.00031685829162598
(420) DESCRIBE `ships` 0.0026049613952637
(421) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1067))) 0.00051212310791016
(422) DESCRIBE `ships` 0.0035579204559326
(423) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1067') 0.00041699409484863
(424) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035619735717773
(425) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033998489379883
(426) DESCRIBE `itineraries` 0.0018301010131836
(427) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63133') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00071501731872559
(428) DESCRIBE `ports` 0.0019829273223877
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00045418739318848
(430) DESCRIBE `ports` 0.001533031463623
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00032615661621094
(432) DESCRIBE `ports` 0.0016348361968994
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00030207633972168
(434) DESCRIBE `sailingdates` 0.0012168884277344
(435) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63133') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00069189071655273
(436) DESCRIBE `ports` 0.0018889904022217
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.0003969669342041
(438) DESCRIBE `ports` 0.0016679763793945
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00044107437133789
(440) DESCRIBE `ports` 0.001910924911499
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00039911270141602
(442) DESCRIBE `ports` 0.0015020370483398
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00032615661621094
(444) DESCRIBE `ports` 0.001500129699707
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00034284591674805
(446) DESCRIBE `ports` 0.0014538764953613
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.0003049373626709
(448) DESCRIBE `ports` 0.0014748573303223
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00047993659973145
(450) DESCRIBE `ports` 0.001406192779541
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00029993057250977
(452) DESCRIBE `ports` 0.0013201236724854
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 55))) 0.00035595893859863
(454) DESCRIBE `ports` 0.0015239715576172
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '55') 0.00027918815612793
(456) DESCRIBE `ports` 0.0012638568878174
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 308))) 0.00029897689819336
(458) DESCRIBE `ports` 0.0014379024505615
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '308') 0.0002739429473877
(460) DESCRIBE `ports` 0.0015110969543457
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 679))) 0.00030207633972168
(462) DESCRIBE `ports` 0.0013577938079834
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '679') 0.00027680397033691
(464) DESCRIBE `ports` 0.0013458728790283
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00030207633972168
(466) DESCRIBE `ports` 0.0012991428375244
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00034785270690918
(468) 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.0035028457641602
(469) DESCRIBE `avid_specials` 0.0017871856689453
(470) 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.0011069774627686
(471) DESCRIBE `cruiselines` 0.0018880367279053
(472) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00032901763916016
(473) DESCRIBE `orchid_image` 0.0017571449279785
(474) DESCRIBE `cruiselines` 0.0019140243530273
(475) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00032901763916016
(476) DESCRIBE `cruises` 0.0037078857421875
(477) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62653') 0.00039887428283691
(478) DESCRIBE `ships` 0.0031311511993408
(479) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 738))) 0.00048398971557617
(480) DESCRIBE `ships` 0.0029559135437012
(481) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '738') 0.00036478042602539
(482) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026297569274902
(483) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025081634521484
(484) DESCRIBE `itineraries` 0.0013861656188965
(485) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62653') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00061702728271484
(486) DESCRIBE `ports` 0.0014219284057617
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00033187866210938
(488) DESCRIBE `ports` 0.0015840530395508
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00032377243041992
(490) DESCRIBE `ports` 0.0014848709106445
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00030803680419922
(492) DESCRIBE `sailingdates` 0.0011970996856689
(493) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62653') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00062918663024902
(494) DESCRIBE `ports` 0.0022668838500977
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00042200088500977
(496) DESCRIBE `ports` 0.0019228458404541
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00049901008605957
(498) DESCRIBE `ports` 0.002051830291748
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.00049304962158203
(500) DESCRIBE `ports` 0.0018858909606934
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.0003812313079834
(502) DESCRIBE `ports` 0.0017919540405273
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3079))) 0.0003819465637207
(504) DESCRIBE `ports` 0.0019080638885498
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3079') 0.00030994415283203
(506) DESCRIBE `ports` 0.0013399124145508
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00029802322387695
(508) DESCRIBE `ports` 0.0013082027435303
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00027608871459961
(510) DESCRIBE `ports` 0.0012691020965576
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1064))) 0.00032496452331543
(512) DESCRIBE `ports` 0.0012688636779785
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1064') 0.00027108192443848
(514) DESCRIBE `ports` 0.0013010501861572
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00028800964355469
(516) DESCRIBE `ports` 0.0012698173522949
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00026607513427734
(518) DESCRIBE `ports` 0.001298189163208
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00028109550476074
(520) DESCRIBE `ports` 0.001291036605835
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00026798248291016
(522) 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.0048148632049561
(523) DESCRIBE `avid_specials` 0.0013518333435059
(524) 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.0011129379272461
(525) DESCRIBE `cruiselines` 0.0018188953399658
(526) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00031590461730957
(527) DESCRIBE `orchid_image` 0.0014100074768066
(528) DESCRIBE `cruiselines` 0.0018420219421387
(529) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00030088424682617
(530) DESCRIBE `cruises` 0.0028769969940186
(531) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69087') 0.00037312507629395
(532) DESCRIBE `ships` 0.0026419162750244
(533) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1588))) 0.00039911270141602
(534) DESCRIBE `ships` 0.002892017364502
(535) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1588') 0.00043606758117676
(536) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026917457580566
(537) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025296211242676
(538) DESCRIBE `itineraries` 0.0013830661773682
(539) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69087') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00067496299743652
(540) DESCRIBE `ports` 0.0018060207366943
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.0003821849822998
(542) DESCRIBE `ports` 0.0013928413391113
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00029397010803223
(544) DESCRIBE `ports` 0.0013909339904785
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00029611587524414
(546) DESCRIBE `sailingdates` 0.0011718273162842
(547) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69087') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00059700012207031
(548) DESCRIBE `ports` 0.0017709732055664
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00037288665771484
(550) DESCRIBE `ports` 0.0015299320220947
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00033092498779297
(552) DESCRIBE `ports` 0.0014579296112061
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 770))) 0.00030303001403809
(554) DESCRIBE `ports` 0.0015060901641846
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '770') 0.00027894973754883
(556) DESCRIBE `ports` 0.0014040470123291
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 470))) 0.00039005279541016
(558) DESCRIBE `ports` 0.0016961097717285
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '470') 0.00030708312988281
(560) DESCRIBE `ports` 0.0014340877532959
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 769))) 0.00054287910461426
(562) DESCRIBE `ports` 0.0014629364013672
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '769') 0.00029110908508301
(564) DESCRIBE `ports` 0.0014681816101074
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2470))) 0.00032687187194824
(566) DESCRIBE `ports` 0.0016500949859619
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2470') 0.00034904479980469
(568) DESCRIBE `ports` 0.0013058185577393
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00029397010803223
(570) DESCRIBE `ports` 0.0013401508331299
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00033187866210938
(572) 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.0031330585479736
(573) DESCRIBE `avid_specials` 0.00148606300354
(574) 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.0012140274047852
(575) DESCRIBE `cruiselines` 0.0022828578948975
(576) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00046300888061523
(577) DESCRIBE `orchid_image` 0.001845121383667
(578) DESCRIBE `cruiselines` 0.0019049644470215
(579) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00031900405883789
(580) DESCRIBE `ships` 0.0043628215789795
(581) 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.0024330615997314
(582) DESCRIBE `cruisetypes` 0.0017859935760498
(583) 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 = '19') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.038749933242798
(584) DESCRIBE `destinations` 0.002223014831543
(585) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '45', '26', '25', '28', '37', '52', '40', '38', '49', '11', '21', '35')) ORDER BY FIND_IN_SET(id, '22,12,45,26,25,28,37,52,40,38,49,11,21,35') 0.0019111633300781
(586) DESCRIBE `cruiselines` 0.0021169185638428
(587) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00036811828613281
(588) DESCRIBE `cruiselines` 0.0021131038665771
(589) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00038695335388184