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

Total elapsed time: 0.49627995491028

# Query Time
(1) connect 0.00077080726623535
(2) DESCRIBE `cruises` 0.0030422210693359
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66808, 66810, 66811, 66812, 66813, 66814)) ORDER BY FIND_IN_SET(id, '66808,66810,66811,66812,66813,66814') 0.00098490715026855
(4) DESCRIBE `cruises` 0.0025579929351807
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66808') 0.00027799606323242
(6) DESCRIBE `ships` 0.0024580955505371
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 683))) 0.0003349781036377
(8) DESCRIBE `ships` 0.0024430751800537
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '683') 0.00027203559875488
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026106834411621
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00024986267089844
(12) DESCRIBE `itineraries` 0.0012509822845459
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66808') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00066685676574707
(14) DESCRIBE `ports` 0.001305103302002
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00031614303588867
(16) DESCRIBE `ports` 0.0012400150299072
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00029802322387695
(18) DESCRIBE `ports` 0.0012431144714355
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0002751350402832
(20) DESCRIBE `sailingdates` 0.0010988712310791
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66808') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00058698654174805
(22) DESCRIBE `ports` 0.001270055770874
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00029087066650391
(24) DESCRIBE `ports` 0.0012550354003906
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00026988983154297
(26) DESCRIBE `ports` 0.0012319087982178
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00036501884460449
(28) DESCRIBE `ports` 0.0013010501861572
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00028491020202637
(30) DESCRIBE `ports` 0.0013771057128906
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00030708312988281
(32) DESCRIBE `ports` 0.0012290477752686
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00026893615722656
(34) DESCRIBE `ports` 0.001255989074707
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00029706954956055
(36) DESCRIBE `ports` 0.0012290477752686
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00026702880859375
(38) DESCRIBE `ports` 0.0014081001281738
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00028395652770996
(40) DESCRIBE `ports` 0.0013599395751953
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00026893615722656
(42) DESCRIBE `ports` 0.0012760162353516
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00032496452331543
(44) DESCRIBE `ports` 0.0012948513031006
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00026893615722656
(46) DESCRIBE `ports` 0.0012748241424561
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00030207633972168
(48) DESCRIBE `ports` 0.0012390613555908
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00031900405883789
(50) DESCRIBE `ports` 0.0012359619140625
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00032496452331543
(52) DESCRIBE `ports` 0.0012319087982178
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00026917457580566
(54) DESCRIBE `ports` 0.0012359619140625
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00029683113098145
(56) DESCRIBE `ports` 0.0012609958648682
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00026702880859375
(58) DESCRIBE `ports` 0.0013549327850342
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00033402442932129
(60) DESCRIBE `ports` 0.0013060569763184
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00026893615722656
(62) DESCRIBE `ports` 0.0012280941009521
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00029921531677246
(64) DESCRIBE `ports` 0.0012571811676025
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00026798248291016
(66) DESCRIBE `ports` 0.0012791156768799
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00029802322387695
(68) DESCRIBE `ports` 0.0014760494232178
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00026893615722656
(70) DESCRIBE `ports` 0.0012741088867188
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030088424682617
(72) DESCRIBE `ports` 0.0013768672943115
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028419494628906
(74) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66808') AND (sailingdate >= '2018-11-20') AND (sailingdate <= '2019-01-17') 0.0039880275726318
(75) DESCRIBE `avid_specials` 0.0011649131774902
(76) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66808 and class = 'Cruise') OR (item_id = 683 AND class = 'Ship') OR (item_id = 8 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.00098085403442383
(77) DESCRIBE `cruiselines` 0.0018320083618164
(78) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00031089782714844
(79) DESCRIBE `orchid_image` 0.0013771057128906
(80) DESCRIBE `cruiselines` 0.0017898082733154
(81) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00031423568725586
(82) DESCRIBE `cruises` 0.0027589797973633
(83) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66810') 0.00044608116149902
(84) DESCRIBE `ships` 0.0031411647796631
(85) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 683))) 0.00036883354187012
(86) DESCRIBE `ships` 0.0024688243865967
(87) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '683') 0.00027990341186523
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026512145996094
(89) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025105476379395
(90) DESCRIBE `itineraries` 0.0012290477752686
(91) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66810') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00052213668823242
(92) DESCRIBE `ports` 0.001323938369751
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032401084899902
(94) DESCRIBE `ports` 0.0014331340789795
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031113624572754
(96) DESCRIBE `ports` 0.0012571811676025
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030398368835449
(98) DESCRIBE `sailingdates` 0.0011348724365234
(99) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66810') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00042009353637695
(100) DESCRIBE `ports` 0.0013489723205566
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039291381835938
(102) DESCRIBE `ports` 0.0013270378112793
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038409233093262
(104) DESCRIBE `ports` 0.0014441013336182
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00030398368835449
(106) DESCRIBE `ports` 0.0013082027435303
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00027203559875488
(108) DESCRIBE `ports` 0.0012521743774414
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00030994415283203
(110) DESCRIBE `ports` 0.0013318061828613
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00027108192443848
(112) DESCRIBE `ports` 0.0012490749359131
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00031089782714844
(114) DESCRIBE `ports` 0.0012879371643066
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00027084350585938
(116) DESCRIBE `ports` 0.0012450218200684
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00036382675170898
(118) DESCRIBE `ports` 0.0012569427490234
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00028109550476074
(120) DESCRIBE `ports` 0.0012679100036621
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00034022331237793
(122) DESCRIBE `ports` 0.0012521743774414
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00028109550476074
(124) DESCRIBE `ports` 0.0013771057128906
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00039911270141602
(126) DESCRIBE `ports` 0.0016350746154785
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00033712387084961
(128) DESCRIBE `ports` 0.0017209053039551
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00031280517578125
(130) DESCRIBE `ports` 0.0013308525085449
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00031304359436035
(132) DESCRIBE `ports` 0.0013060569763184
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.0003209114074707
(134) DESCRIBE `ports` 0.0013070106506348
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.0002741813659668
(136) DESCRIBE `ports` 0.0012578964233398
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00032806396484375
(138) DESCRIBE `ports` 0.0013039112091064
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00028085708618164
(140) DESCRIBE `ports` 0.0014431476593018
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00035190582275391
(142) DESCRIBE `ports` 0.0012719631195068
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00027203559875488
(144) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66810') AND (sailingdate >= '2018-11-20') AND (sailingdate <= '2019-01-17') 0.0027000904083252
(145) DESCRIBE `avid_specials` 0.0011250972747803
(146) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66810 and class = 'Cruise') OR (item_id = 683 AND class = 'Ship') OR (item_id = 8 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.001086950302124
(147) DESCRIBE `cruiselines` 0.0018079280853271
(148) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00031900405883789
(149) DESCRIBE `orchid_image` 0.0014781951904297
(150) DESCRIBE `cruiselines` 0.0018057823181152
(151) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.0002748966217041
(152) DESCRIBE `cruises` 0.0024690628051758
(153) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66811') 0.00030803680419922
(154) DESCRIBE `ships` 0.0026180744171143
(155) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 683))) 0.00037312507629395
(156) DESCRIBE `ships` 0.0025599002838135
(157) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '683') 0.0002748966217041
(158) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026297569274902
(159) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026893615722656
(160) DESCRIBE `itineraries` 0.0012679100036621
(161) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66811') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00043296813964844
(162) DESCRIBE `ports` 0.0013871192932129
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00032591819763184
(164) DESCRIBE `ports` 0.0012609958648682
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00030803680419922
(166) DESCRIBE `ports` 0.0013201236724854
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00028395652770996
(168) DESCRIBE `sailingdates` 0.00118088722229
(169) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66811') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00061511993408203
(170) DESCRIBE `ports` 0.0014970302581787
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00044798851013184
(172) DESCRIBE `ports` 0.0013620853424072
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00046086311340332
(174) DESCRIBE `ports` 0.0013289451599121
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00038599967956543
(176) DESCRIBE `ports` 0.0013039112091064
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00034689903259277
(178) DESCRIBE `ports` 0.0012779235839844
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00029897689819336
(180) DESCRIBE `ports` 0.0013229846954346
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00028085708618164
(182) DESCRIBE `ports` 0.0011739730834961
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00030994415283203
(184) DESCRIBE `ports` 0.0013160705566406
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00044083595275879
(186) DESCRIBE `ports` 0.001507043838501
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00041985511779785
(188) DESCRIBE `ports` 0.0013079643249512
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.0002748966217041
(190) DESCRIBE `ports` 0.0012638568878174
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00031304359436035
(192) DESCRIBE `ports` 0.0012800693511963
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00030899047851562
(194) DESCRIBE `ports` 0.001291036605835
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00029993057250977
(196) DESCRIBE `ports` 0.0012757778167725
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00028109550476074
(198) DESCRIBE `ports` 0.0012531280517578
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00037097930908203
(200) DESCRIBE `ports` 0.0012850761413574
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.0002739429473877
(202) DESCRIBE `ports` 0.001331090927124
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00031399726867676
(204) DESCRIBE `ports` 0.0013129711151123
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00026988983154297
(206) DESCRIBE `ports` 0.0012810230255127
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030279159545898
(208) DESCRIBE `ports` 0.0012822151184082
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00035309791564941
(210) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66811') AND (sailingdate >= '2018-11-20') AND (sailingdate <= '2019-01-17') 0.0028440952301025
(211) DESCRIBE `avid_specials` 0.0012650489807129
(212) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66811 and class = 'Cruise') OR (item_id = 683 AND class = 'Ship') OR (item_id = 8 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.0011529922485352
(213) DESCRIBE `cruiselines` 0.0019040107727051
(214) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00033879280090332
(215) DESCRIBE `orchid_image` 0.0014441013336182
(216) DESCRIBE `cruiselines` 0.0018160343170166
(217) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00028586387634277
(218) DESCRIBE `cruises` 0.0037860870361328
(219) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66812') 0.00041794776916504
(220) DESCRIBE `ships` 0.002532958984375
(221) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 683))) 0.00042486190795898
(222) DESCRIBE `ships` 0.0024800300598145
(223) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '683') 0.00028204917907715
(224) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026798248291016
(225) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025510787963867
(226) DESCRIBE `itineraries` 0.0012328624725342
(227) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66812') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00045108795166016
(228) DESCRIBE `ports` 0.0013480186462402
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003669261932373
(230) DESCRIBE `ports` 0.0013291835784912
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034403800964355
(232) DESCRIBE `ports` 0.0013229846954346
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031304359436035
(234) DESCRIBE `sailingdates` 0.0011658668518066
(235) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66812') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00049209594726562
(236) DESCRIBE `ports` 0.001507043838501
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037693977355957
(238) DESCRIBE `ports` 0.0015010833740234
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00032615661621094
(240) DESCRIBE `ports` 0.0030519962310791
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00036907196044922
(242) DESCRIBE `ports` 0.001345157623291
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00031089782714844
(244) DESCRIBE `ports` 0.001554012298584
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00040817260742188
(246) DESCRIBE `ports` 0.0016140937805176
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00034093856811523
(248) DESCRIBE `ports` 0.0013580322265625
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00032210350036621
(250) DESCRIBE `ports` 0.0013079643249512
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.0002739429473877
(252) DESCRIBE `ports` 0.0013279914855957
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00031590461730957
(254) DESCRIBE `ports` 0.0015769004821777
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00030303001403809
(256) DESCRIBE `ports` 0.0013139247894287
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00030612945556641
(258) DESCRIBE `ports` 0.0014071464538574
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.0002739429473877
(260) DESCRIBE `ports` 0.0012669563293457
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00039291381835938
(262) DESCRIBE `ports` 0.0015449523925781
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00029397010803223
(264) DESCRIBE `ports` 0.0012950897216797
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00032901763916016
(266) DESCRIBE `ports` 0.0012891292572021
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00027918815612793
(268) DESCRIBE `ports` 0.0014121532440186
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00032615661621094
(270) DESCRIBE `ports` 0.0015099048614502
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00029206275939941
(272) DESCRIBE `ports` 0.0013720989227295
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049614906311035
(274) DESCRIBE `ports` 0.0014760494232178
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028610229492188
(276) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66812') AND (sailingdate >= '2018-11-20') AND (sailingdate <= '2019-01-17') 0.0038881301879883
(277) DESCRIBE `avid_specials` 0.0013670921325684
(278) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66812 and class = 'Cruise') OR (item_id = 683 AND class = 'Ship') OR (item_id = 8 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.0010209083557129
(279) DESCRIBE `cruiselines` 0.0018970966339111
(280) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00034022331237793
(281) DESCRIBE `orchid_image` 0.0014729499816895
(282) DESCRIBE `cruiselines` 0.0018210411071777
(283) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00036096572875977
(284) DESCRIBE `cruises` 0.0028200149536133
(285) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66813') 0.00038814544677734
(286) DESCRIBE `ships` 0.0026321411132812
(287) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 683))) 0.00041794776916504
(288) DESCRIBE `ships` 0.0027408599853516
(289) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '683') 0.00033402442932129
(290) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026702880859375
(291) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025701522827148
(292) DESCRIBE `itineraries` 0.0013179779052734
(293) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66813') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00051999092102051
(294) DESCRIBE `ports` 0.0016210079193115
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043106079101562
(296) DESCRIBE `ports` 0.001784086227417
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046110153198242
(298) DESCRIBE `ports` 0.0013349056243896
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028586387634277
(300) DESCRIBE `sailingdates` 0.0013191699981689
(301) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66813') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0005950927734375
(302) DESCRIBE `ports` 0.0020060539245605
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043606758117676
(304) DESCRIBE `ports` 0.0017831325531006
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00032901763916016
(306) DESCRIBE `ports` 0.0016610622406006
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2040))) 0.00042295455932617
(308) DESCRIBE `ports` 0.0018069744110107
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2040') 0.00037693977355957
(310) DESCRIBE `ports` 0.0018289089202881
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00043511390686035
(312) DESCRIBE `ports` 0.0017960071563721
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.0003349781036377
(314) DESCRIBE `ports` 0.0016219615936279
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00039911270141602
(316) DESCRIBE `ports` 0.0017011165618896
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00039219856262207
(318) DESCRIBE `ports` 0.0014281272888184
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00041699409484863
(320) DESCRIBE `ports` 0.0014431476593018
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00033116340637207
(322) DESCRIBE `ports` 0.0018441677093506
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00047922134399414
(324) DESCRIBE `ports` 0.0017490386962891
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00031709671020508
(326) DESCRIBE `ports` 0.0018210411071777
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00043392181396484
(328) DESCRIBE `ports` 0.0017731189727783
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00032997131347656
(330) DESCRIBE `ports` 0.0013458728790283
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00032901763916016
(332) DESCRIBE `ports` 0.0013289451599121
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00031495094299316
(334) DESCRIBE `ports` 0.0015029907226562
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00049996376037598
(336) DESCRIBE `ports` 0.0019829273223877
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00037193298339844
(338) DESCRIBE `ports` 0.0017638206481934
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00037789344787598
(340) DESCRIBE `ports` 0.0014710426330566
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.0003199577331543
(342) DESCRIBE `ports` 0.0029339790344238
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00039196014404297
(344) DESCRIBE `ports` 0.0024611949920654
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00040698051452637
(346) DESCRIBE `ports` 0.0014338493347168
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00036406517028809
(348) DESCRIBE `ports` 0.001410961151123
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00031709671020508
(350) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66813') AND (sailingdate >= '2018-11-20') AND (sailingdate <= '2019-01-17') 0.0046889781951904
(351) DESCRIBE `avid_specials` 0.0019259452819824
(352) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66813 and class = 'Cruise') OR (item_id = 683 AND class = 'Ship') OR (item_id = 8 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.0012991428375244
(353) DESCRIBE `cruiselines` 0.0024960041046143
(354) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00052618980407715
(355) DESCRIBE `orchid_image` 0.0017809867858887
(356) DESCRIBE `cruiselines` 0.0022218227386475
(357) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00036787986755371
(358) DESCRIBE `cruises` 0.0032198429107666
(359) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66814') 0.00049495697021484
(360) DESCRIBE `ships` 0.0036728382110596
(361) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 683))) 0.00070905685424805
(362) DESCRIBE `ships` 0.0034351348876953
(363) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '683') 0.00039911270141602
(364) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026798248291016
(365) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025582313537598
(366) DESCRIBE `itineraries` 0.00160813331604
(367) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66814') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00048303604125977
(368) DESCRIBE `ports` 0.0018939971923828
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0003809928894043
(370) DESCRIBE `ports` 0.0013659000396729
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0003049373626709
(372) DESCRIBE `ports` 0.0016720294952393
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00036096572875977
(374) DESCRIBE `sailingdates` 0.0014081001281738
(375) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66814') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00050806999206543
(376) DESCRIBE `ports` 0.0015389919281006
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00040698051452637
(378) DESCRIBE `ports` 0.0019230842590332
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0004270076751709
(380) DESCRIBE `ports` 0.0015311241149902
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00032901763916016
(382) DESCRIBE `ports` 0.0013048648834229
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.0002892017364502
(384) DESCRIBE `ports` 0.0013589859008789
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00034093856811523
(386) DESCRIBE `ports` 0.0014998912811279
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00030612945556641
(388) DESCRIBE `ports` 0.0014479160308838
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00042891502380371
(390) DESCRIBE `ports` 0.001471996307373
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00031495094299316
(392) DESCRIBE `ports` 0.0018420219421387
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00042605400085449
(394) DESCRIBE `ports` 0.0018391609191895
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.0003960132598877
(396) DESCRIBE `ports` 0.0018470287322998
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00044417381286621
(398) DESCRIBE `ports` 0.002065896987915
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00043892860412598
(400) DESCRIBE `ports` 0.0017991065979004
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00040912628173828
(402) DESCRIBE `ports` 0.0018000602722168
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00036191940307617
(404) DESCRIBE `ports` 0.00174880027771
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00041699409484863
(406) DESCRIBE `ports` 0.0016491413116455
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00035786628723145
(408) DESCRIBE `ports` 0.0017540454864502
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00041079521179199
(410) DESCRIBE `ports` 0.0017759799957275
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00036716461181641
(412) DESCRIBE `ports` 0.0018000602722168
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00041103363037109
(414) DESCRIBE `ports` 0.0016748905181885
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00037193298339844
(416) DESCRIBE `ports` 0.0017800331115723
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00041699409484863
(418) DESCRIBE `ports` 0.0018208026885986
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00034093856811523
(420) DESCRIBE `ports` 0.0017938613891602
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00046086311340332
(422) DESCRIBE `ports` 0.0012979507446289
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00036716461181641
(424) DESCRIBE `ports` 0.0023040771484375
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033211708068848
(426) DESCRIBE `ports` 0.0013389587402344
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002748966217041
(428) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66814') AND (sailingdate >= '2018-11-20') AND (sailingdate <= '2019-01-17') 0.0027718544006348
(429) DESCRIBE `avid_specials` 0.0012209415435791
(430) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66814 and class = 'Cruise') OR (item_id = 683 AND class = 'Ship') OR (item_id = 8 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.0010559558868408
(431) DESCRIBE `cruiselines` 0.0020380020141602
(432) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00037908554077148
(433) DESCRIBE `orchid_image` 0.0014801025390625
(434) DESCRIBE `cruiselines` 0.0017800331115723
(435) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00028681755065918
(436) DESCRIBE `cruisetypes` 0.0014610290527344
(437) 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 = '8') AND (cruises_and_specials.ship_id = '683') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.037671089172363
(438) DESCRIBE `destinations` 0.0020129680633545
(439) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43')) ORDER BY FIND_IN_SET(id, '43') 0.00045990943908691
(440) DESCRIBE `cruiselines` 0.0022730827331543
(441) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00043296813964844
(442) DESCRIBE `ships` 0.00288987159729
(443) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 683))) 0.00033903121948242
(444) DESCRIBE `cruiselines` 0.0023059844970703
(445) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00036287307739258
(446) DESCRIBE `ships` 0.0030109882354736
(447) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 683))) 0.00052809715270996