or, enquire about your chosen options

  1. Ultra-Luxury Cruising
  2. The Caribbean is still a Preferred Cruise Destination
  3. Catch Up on Cruising: Latest News in bite size!
  4. 8 Romantic Destinations Around the World
  5. Royal Caribbean Launch “Royal Up”

Sign up to our newsletter and become the first to know about our latest deals and promotions

Itinerary for Cruise Sun, Circle Pacific 2020 Sector ex Sydney to Auckalnd

Cruise Itinerary

Day Port Arrive Depart
Day 1 Sydney, NSW, Australia
Day 2 At Sea
Day 3 Brisbane, QLD, Australia
Day 4 At Sea
Day 5 At Sea
Day 6 Alotau, Papua New Guinea
Day 7 At Sea
Day 8 At Sea
Day 9 At Sea
Day 10 At Sea
Day 11 At Sea
Day 12 Manila, Philippines
Day 13 At Sea
Day 14 Hong Kong
Day 15 At Sea
Day 16 At Sea
Day 17 Shanghai, China
Day 18 At Sea
Day 19 Busan, (Pusan) South Korea
Day 20 At Sea
Day 21 Osaka, Japan
Day 22 Shimizu (Shizuoka), Japan
Day 23 Yokohama, Japan
Day 24 At Sea
Day 25 Hakodate, Japan
Day 26 Kushiro, Japan
Day 27 At Sea
Day 28 Date Line Crossing
Day 29 At Sea
Day 30 At Sea
Day 31 At Sea
Day 32 Kodiak, Alaska
Day 33 Seward, Alaska
Day 34 College Fjord, Alaska
Day 35 Hubbard Glacier, Alaska
Day 36 Sitka, Alaska
Day 37 Skagway, Alaska
Day 38 Juneau, Alaska
Day 39 Ketchikan, Alaska
Day 40 Inside Passage, Alaska
Day 41 Vancouver, BC. Canada
Day 42 Vancouver, BC. Canada
Day 43 Victoria, BC. Canada
Day 44 Seattle, Washington, USA
Day 45 At Sea
Day 46 Astoria, Oregon, USA
Day 47 At Sea
Day 48 San Francisco, California, USA
Day 49 San Francisco, California, USA
Day 50 Monterey, California, USA
Day 51 Santa Barbara, California, USA
Day 52 San Diego, California, USA
Day 53 At Sea
Day 54 At Sea
Day 55 At Sea
Day 56 At Sea
Day 57 At Sea
Day 58 Honolulu, Hawaii
Day 59 Lahaina Maui, Hawaii
Day 60 At Sea
Day 61 At Sea
Day 62 At Sea
Day 63 At Sea
Day 64 At Sea
Day 65 Papeete, Tahiti
Day 66 Raiatea, French Polynesia
Day 67 At Sea
Day 68 At Sea
Day 69 Pago Pago American Samoa
Day 70 At Sea
Day 71 At Sea
Day 72 Date Line Crossing
Day 73 At Sea
Day 74 Auckland, New Zealand

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

Total elapsed time: 0.59903502464294

# Query Time
(1) connect 0.0010190010070801
(2) DESCRIBE `specials` 0.0061929225921631
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'circle-pacific-sydney-to-auckland') AND (orchid_available = 1) LIMIT 1 0.0012519359588623
(4) DESCRIBE `cruises` 0.0037841796875
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 79643))) 0.00084495544433594
(6) DESCRIBE `avid_specials` 0.0019271373748779
(7) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1490159 and class = 'Special') OR (item_id = 79643 and class = 'Cruise') OR (item_id = 105 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 40 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.0013329982757568
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1490159') 0.0004119873046875
(9) DESCRIBE `ships` 0.0036690235137939
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 105))) 0.0004420280456543
(11) DESCRIBE `ships` 0.0033969879150391
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '105') 0.00044608116149902
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030899047851562
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031113624572754
(15) DESCRIBE `itineraries` 0.0018429756164551
(16) DESCRIBE `ports` 0.0022690296173096
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047516822814941
(18) DESCRIBE `ports` 0.0019757747650146
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048708915710449
(20) DESCRIBE `ports` 0.0019760131835938
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039887428283691
(22) DESCRIBE `specialsailingdates` 0.0016109943389893
(23) DESCRIBE `sailingdates` 0.001594066619873
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 493202))) 0.00037312507629395
(25) DESCRIBE `ports` 0.0015408992767334
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042200088500977
(27) DESCRIBE `ports` 0.001417875289917
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029087066650391
(29) DESCRIBE `ports` 0.0017330646514893
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00043106079101562
(31) DESCRIBE `ports` 0.0019559860229492
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00041794776916504
(33) DESCRIBE `ports` 0.0017728805541992
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.00042605400085449
(35) DESCRIBE `ports` 0.0018680095672607
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.00047397613525391
(37) DESCRIBE `ports` 0.0020058155059814
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.00050091743469238
(39) DESCRIBE `ports` 0.0020210742950439
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '421') 0.00046205520629883
(41) DESCRIBE `ports` 0.0018649101257324
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00046992301940918
(43) DESCRIBE `ports` 0.0020139217376709
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00042986869812012
(45) DESCRIBE `ports` 0.0018730163574219
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00043678283691406
(47) DESCRIBE `ports` 0.0016868114471436
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00040817260742188
(49) DESCRIBE `ports` 0.001694917678833
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00043511390686035
(51) DESCRIBE `ports` 0.0017437934875488
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00021100044250488
(53) DESCRIBE `ports` 0.0017848014831543
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00058293342590332
(55) DESCRIBE `ports` 0.0018379688262939
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00041508674621582
(57) DESCRIBE `ports` 0.0019500255584717
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00043797492980957
(59) DESCRIBE `ports` 0.0018007755279541
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.00039911270141602
(61) DESCRIBE `ports` 0.0017950534820557
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.0005190372467041
(63) DESCRIBE `ports` 0.0016500949859619
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00042581558227539
(65) DESCRIBE `ports` 0.0018539428710938
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1308))) 0.0004270076751709
(67) DESCRIBE `ports` 0.0019259452819824
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1308') 0.00040507316589355
(69) DESCRIBE `ports` 0.001727819442749
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1273))) 0.00041699409484863
(71) DESCRIBE `ports` 0.001741886138916
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1273') 0.00038504600524902
(73) DESCRIBE `ports` 0.0017499923706055
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00039410591125488
(75) DESCRIBE `ports` 0.00180983543396
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00040102005004883
(77) DESCRIBE `ports` 0.0018520355224609
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 37))) 0.00045084953308105
(79) DESCRIBE `ports` 0.0016300678253174
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '37') 0.00037789344787598
(81) DESCRIBE `ports` 0.0016160011291504
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00038695335388184
(83) DESCRIBE `ports` 0.0014979839324951
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00034809112548828
(85) DESCRIBE `ports` 0.0016148090362549
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 292))) 0.00066280364990234
(87) DESCRIBE `ports` 0.0019428730010986
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '292') 0.00059199333190918
(89) DESCRIBE `ports` 0.0017669200897217
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00043106079101562
(91) DESCRIBE `ports` 0.00189208984375
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00042581558227539
(93) DESCRIBE `ports` 0.0021779537200928
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.0004580020904541
(95) DESCRIBE `ports` 0.0019090175628662
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00037097930908203
(97) DESCRIBE `ports` 0.0018458366394043
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.0003669261932373
(99) DESCRIBE `ports` 0.0018041133880615
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00084114074707031
(101) DESCRIBE `ports` 0.0021200180053711
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.0004727840423584
(103) DESCRIBE `ports` 0.0018370151519775
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00037908554077148
(105) DESCRIBE `ports` 0.0014848709106445
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00038313865661621
(107) DESCRIBE `ports` 0.0015769004821777
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00025796890258789
(109) DESCRIBE `ports` 0.0014488697052002
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00038695335388184
(111) DESCRIBE `ports` 0.0014510154724121
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00032997131347656
(113) DESCRIBE `ports` 0.0015199184417725
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00039291381835938
(115) DESCRIBE `ports` 0.0014939308166504
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00036001205444336
(117) DESCRIBE `ports` 0.0014538764953613
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00054001808166504
(119) DESCRIBE `ports` 0.0028529167175293
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00046205520629883
(121) DESCRIBE `ports` 0.002047061920166
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00047898292541504
(123) DESCRIBE `ports` 0.0022289752960205
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00039887428283691
(125) DESCRIBE `ports` 0.0017759799957275
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00087308883666992
(127) DESCRIBE `ports` 0.0018229484558105
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.0005180835723877
(129) DESCRIBE `ports` 0.0021090507507324
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00046300888061523
(131) DESCRIBE `ports` 0.0017921924591064
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00037312507629395
(133) DESCRIBE `ports` 0.0016400814056396
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00046014785766602
(135) DESCRIBE `ports` 0.0017631053924561
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00041699409484863
(137) DESCRIBE `ports` 0.0018939971923828
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00047802925109863
(139) DESCRIBE `ports` 0.0019218921661377
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00039219856262207
(141) DESCRIBE `ports` 0.0015809535980225
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2224))) 0.00043010711669922
(143) DESCRIBE `ports` 0.0018289089202881
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2224') 0.00040507316589355
(145) DESCRIBE `ports` 0.0017809867858887
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1655))) 0.00042510032653809
(147) DESCRIBE `ports` 0.0014841556549072
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1655') 0.00034093856811523
(149) DESCRIBE `ports` 0.001816987991333
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00026297569274902
(151) DESCRIBE `ports` 0.0018138885498047
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.00052404403686523
(153) DESCRIBE `ports` 0.0017409324645996
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00055384635925293
(155) DESCRIBE `ports` 0.0017578601837158
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00048398971557617
(157) DESCRIBE `ports` 0.0017859935760498
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 384))) 0.00053310394287109
(159) DESCRIBE `ports` 0.0018601417541504
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '384') 0.00042104721069336
(161) DESCRIBE `ports` 0.0018880367279053
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.0004279613494873
(163) DESCRIBE `ports` 0.0015342235565186
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00036096572875977
(165) DESCRIBE `ports` 0.0013120174407959
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00037717819213867
(167) DESCRIBE `ports` 0.0015988349914551
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00036907196044922
(169) DESCRIBE `ports` 0.0017070770263672
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 86))) 0.00032901763916016
(171) DESCRIBE `ports` 0.0016782283782959
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '86') 0.00033783912658691
(173) DESCRIBE `ports` 0.0013189315795898
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00029492378234863
(175) DESCRIBE `ports` 0.0016279220581055
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00035190582275391
(177) DESCRIBE `ports` 0.0014710426330566
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00046801567077637
(179) DESCRIBE `ports` 0.0015990734100342
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00039505958557129
(181) DESCRIBE `specialsmultipricing` 0.0014688968658447
(182) DESCRIBE `leadpricing` 0.0013730525970459
(183) DESCRIBE `specialspricing` 0.0018429756164551
(184) DESCRIBE `cabins` 0.0024740695953369
(185) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 2655))) 0.00060486793518066
(186) DESCRIBE `currencies` 0.0019700527191162
(187) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00044918060302734
(188) DESCRIBE `cruiselines` 0.0037860870361328
(189) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00045609474182129
(190) DESCRIBE `orchid_image` 0.0022730827331543
(191) DESCRIBE `cruiselines` 0.0030028820037842
(192) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00046801567077637
(193) DESCRIBE `cruises` 0.0034849643707275
(194) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79643') 0.00066995620727539
(195) DESCRIBE `deckplans` 0.0020580291748047
(196) DESCRIBE `cabins` 0.0016419887542725
(197) DESCRIBE `shipphotos` 0.0017530918121338
(198) DESCRIBE `specialitineraries` 0.0022728443145752
(199) SELECT `specialitineraries`.* FROM `specialitineraries` WHERE (type = 'pre' AND special_id = '1490159') ORDER BY `order` ASC 0.0008389949798584
(200) DESCRIBE `ports` 0.002129077911377
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00052809715270996
(202) DESCRIBE `ports` 0.0022199153900146
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00053691864013672
(204) DESCRIBE `ports` 0.0020289421081543
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00053095817565918
(206) DESCRIBE `ports` 0.0019369125366211
(207) DESCRIBE `ports` 0.001945972442627
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00060009956359863
(209) DESCRIBE `ports` 0.0019769668579102
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00043797492980957
(211) DESCRIBE `ports` 0.0020790100097656
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00054621696472168
(213) DESCRIBE `ports` 0.0019350051879883
(214) DESCRIBE `ports` 0.0017440319061279
(215) DESCRIBE `ports` 0.0017831325531006
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.00047183036804199
(217) DESCRIBE `ports` 0.0019309520721436
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.00042104721069336
(219) DESCRIBE `ports` 0.0018949508666992
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.00033998489379883
(221) DESCRIBE `ports` 0.0014710426330566
(222) DESCRIBE `ports` 0.0016231536865234
(223) DESCRIBE `ports` 0.0021231174468994
(224) DESCRIBE `ports` 0.0018491744995117
(225) DESCRIBE `ports` 0.0018692016601562
(226) DESCRIBE `ports` 0.0019559860229492
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.00050091743469238
(228) DESCRIBE `ports` 0.0021212100982666
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '421') 0.00039792060852051
(230) DESCRIBE `ports` 0.0016429424285889
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.00039911270141602
(232) DESCRIBE `ports` 0.0015709400177002
(233) DESCRIBE `ports` 0.0016710758209229
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00046491622924805
(235) DESCRIBE `ports` 0.0017588138580322
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00039219856262207
(237) DESCRIBE `ports` 0.001521110534668
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00040006637573242
(239) DESCRIBE `ports` 0.0016329288482666
(240) DESCRIBE `ports` 0.0020051002502441
(241) DESCRIBE `ports` 0.0014700889587402
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00037312507629395
(243) DESCRIBE `ports` 0.0017950534820557
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00045204162597656
(245) DESCRIBE `ports` 0.0016741752624512
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.0004270076751709
(247) DESCRIBE `ports` 0.0020010471343994
(248) DESCRIBE `ports` 0.0020248889923096
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00048494338989258
(250) DESCRIBE `ports` 0.0019490718841553
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.0004429817199707
(252) DESCRIBE `ports` 0.0020279884338379
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00046801567077637
(254) DESCRIBE `ports` 0.0019710063934326
(255) DESCRIBE `ports` 0.0017068386077881
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00056314468383789
(257) DESCRIBE `ports` 0.0018007755279541
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00047993659973145
(259) DESCRIBE `ports` 0.0017209053039551
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.0003809928894043
(261) DESCRIBE `ports` 0.0014288425445557
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00030708312988281
(263) DESCRIBE `ports` 0.0014750957489014
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.00031208992004395
(265) DESCRIBE `ports` 0.001615047454834
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00038909912109375
(267) DESCRIBE `ports` 0.001924991607666
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00047492980957031
(269) DESCRIBE `ports` 0.0019009113311768
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.0003960132598877
(271) DESCRIBE `ports` 0.0015950202941895
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00044107437133789
(273) DESCRIBE `ports` 0.0016300678253174
(274) DESCRIBE `ports` 0.0016012191772461
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1308))) 0.00040292739868164
(276) DESCRIBE `ports` 0.0016758441925049
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1308') 0.00031399726867676
(278) DESCRIBE `ports` 0.0014519691467285
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1308))) 0.0003821849822998
(280) DESCRIBE `ports` 0.0018138885498047
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1273))) 0.00036501884460449
(282) DESCRIBE `ports` 0.0016031265258789
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1273') 0.00030398368835449
(284) DESCRIBE `ports` 0.0013670921325684
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1273))) 0.00031685829162598
(286) DESCRIBE `ports` 0.0014970302581787
(287) DESCRIBE `ports` 0.0016391277313232
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00043892860412598
(289) DESCRIBE `ports` 0.0018501281738281
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00037384033203125
(291) DESCRIBE `ports` 0.0018069744110107
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00050210952758789
(293) DESCRIBE `ports` 0.0018692016601562
(294) DESCRIBE `ports` 0.0018050670623779
(295) DESCRIBE `ports` 0.0017688274383545
(296) DESCRIBE `ports` 0.0018148422241211
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 37))) 0.0004730224609375
(298) DESCRIBE `ports` 0.0018091201782227
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '37') 0.00035619735717773
(300) DESCRIBE `ports` 0.0018489360809326
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 37))) 0.00040102005004883
(302) DESCRIBE `ports` 0.0018420219421387
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.0004730224609375
(304) DESCRIBE `ports` 0.0016849040985107
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.0003969669342041
(306) DESCRIBE `ports` 0.0023620128631592
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00060081481933594
(308) DESCRIBE `ports` 0.0021789073944092
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 292))) 0.00062394142150879
(310) DESCRIBE `ports` 0.0018548965454102
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '292') 0.00066113471984863
(312) DESCRIBE `ports` 0.0020060539245605
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 292))) 0.00057196617126465
(314) DESCRIBE `ports` 0.0021798610687256
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00055599212646484
(316) DESCRIBE `ports` 0.0016090869903564
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00046205520629883
(318) DESCRIBE `ports` 0.0018768310546875
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.0006260871887207
(320) DESCRIBE `ports` 0.0017719268798828
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00044798851013184
(322) DESCRIBE `ports` 0.0016748905181885
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00039005279541016
(324) DESCRIBE `ports` 0.0017809867858887
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00045180320739746
(326) DESCRIBE `ports` 0.0018210411071777
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.0004270076751709
(328) DESCRIBE `ports` 0.0017988681793213
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00039196014404297
(330) DESCRIBE `ports` 0.001708984375
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00050687789916992
(332) DESCRIBE `ports` 0.0017402172088623
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.0005340576171875
(334) DESCRIBE `ports` 0.0018000602722168
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00044512748718262
(336) DESCRIBE `ports` 0.0017969608306885
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00047993659973145
(338) DESCRIBE `ports` 0.0019140243530273
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00045895576477051
(340) DESCRIBE `ports` 0.0017890930175781
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00034999847412109
(342) DESCRIBE `ports` 0.0018019676208496
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00045299530029297
(344) DESCRIBE `ports` 0.0017399787902832
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.0006401538848877
(346) DESCRIBE `ports` 0.0020461082458496
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00048398971557617
(348) DESCRIBE `ports` 0.0019700527191162
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00065493583679199
(350) DESCRIBE `ports` 0.0017590522766113
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00056695938110352
(352) DESCRIBE `ports` 0.002051830291748
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00049591064453125
(354) DESCRIBE `ports` 0.0019550323486328
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00049591064453125
(356) DESCRIBE `ports` 0.0017290115356445
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00050497055053711
(358) DESCRIBE `ports` 0.0019218921661377
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.0005190372467041
(360) DESCRIBE `ports` 0.0019009113311768
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00050115585327148
(362) DESCRIBE `ports` 0.0019099712371826
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.000885009765625
(364) DESCRIBE `ports` 0.0017271041870117
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00041103363037109
(366) DESCRIBE `ports` 0.001924991607666
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00051212310791016
(368) DESCRIBE `ports` 0.0019371509552002
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00045013427734375
(370) DESCRIBE `ports` 0.0019030570983887
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00040507316589355
(372) DESCRIBE `ports` 0.0018019676208496
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00049090385437012
(374) DESCRIBE `ports` 0.0018839836120605
(375) DESCRIBE `ports` 0.0017478466033936
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00043487548828125
(377) DESCRIBE `ports` 0.0016219615936279
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00037097930908203
(379) DESCRIBE `ports` 0.0016319751739502
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00051999092102051
(381) DESCRIBE `ports` 0.0020489692687988
(382) DESCRIBE `ports` 0.0018360614776611
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00065183639526367
(384) DESCRIBE `ports` 0.001863956451416
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00044608116149902
(386) DESCRIBE `ports` 0.0019381046295166
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00041294097900391
(388) DESCRIBE `ports` 0.002187967300415
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00049400329589844
(390) DESCRIBE `ports` 0.0018811225891113
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00043988227844238
(392) DESCRIBE `ports` 0.0018579959869385
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.0004420280456543
(394) DESCRIBE `ports` 0.001957893371582
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2224))) 0.00051593780517578
(396) DESCRIBE `ports` 0.0018901824951172
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2224') 0.0004880428314209
(398) DESCRIBE `ports` 0.0018219947814941
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2224))) 0.00049710273742676
(400) DESCRIBE `ports` 0.0019888877868652
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1655))) 0.00048089027404785
(402) DESCRIBE `ports` 0.0019659996032715
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1655') 0.00042414665222168
(404) DESCRIBE `ports` 0.0018000602722168
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1655))) 0.00050187110900879
(406) DESCRIBE `ports` 0.0019619464874268
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00039315223693848
(408) DESCRIBE `ports` 0.001655101776123
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.00054001808166504
(410) DESCRIBE `ports` 0.0019268989562988
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00050210952758789
(412) DESCRIBE `ports` 0.0018460750579834
(413) DESCRIBE `ports` 0.0018670558929443
(414) DESCRIBE `ports` 0.002202033996582
(415) DESCRIBE `ports` 0.0018539428710938
(416) DESCRIBE `ports` 0.0023460388183594
(417) DESCRIBE `ports` 0.0023488998413086
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00054478645324707
(419) DESCRIBE `ports` 0.0024449825286865
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00044608116149902
(421) DESCRIBE `ports` 0.0019080638885498
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.0004279613494873
(423) DESCRIBE `ports` 0.0016171932220459
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 384))) 0.00041985511779785
(425) DESCRIBE `ports` 0.0016970634460449
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '384') 0.00043511390686035
(427) DESCRIBE `ports` 0.0018711090087891
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 384))) 0.00043916702270508
(429) DESCRIBE `ports` 0.0018479824066162
(430) DESCRIBE `ports` 0.0020129680633545
(431) DESCRIBE `ports` 0.0017530918121338
(432) DESCRIBE `ports` 0.0016589164733887
(433) DESCRIBE `ports` 0.0016651153564453
(434) DESCRIBE `ports` 0.0016179084777832
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00045299530029297
(436) DESCRIBE `ports` 0.0018181800842285
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00039410591125488
(438) DESCRIBE `ports` 0.0018031597137451
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00053596496582031
(440) DESCRIBE `ports` 0.0016970634460449
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00041317939758301
(442) DESCRIBE `ports` 0.0016419887542725
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00038790702819824
(444) DESCRIBE `ports` 0.0018138885498047
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00047802925109863
(446) DESCRIBE `ports` 0.0018370151519775
(447) DESCRIBE `ports` 0.0014550685882568
(448) DESCRIBE `ports` 0.0012731552124023
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 86))) 0.00038313865661621
(450) DESCRIBE `ports` 0.0012969970703125
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '86') 0.00031900405883789
(452) DESCRIBE `ports` 0.0015640258789062
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 86))) 0.00030899047851562
(454) DESCRIBE `ports` 0.001399040222168
(455) DESCRIBE `ports` 0.0017020702362061
(456) DESCRIBE `ports` 0.0015189647674561
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00038886070251465
(458) DESCRIBE `ports` 0.0016670227050781
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00028705596923828
(460) DESCRIBE `ports` 0.0012710094451904
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.0003199577331543
(462) DESCRIBE `ports` 0.001270055770874
(463) DESCRIBE `ports` 0.0013060569763184
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00043606758117676
(465) DESCRIBE `ports` 0.0013720989227295
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00031208992004395
(467) DESCRIBE `ports` 0.0015640258789062
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00031399726867676
(469) DESCRIBE `specialitineraries` 0.0013959407806396
(470) SELECT `specialitineraries`.* FROM `specialitineraries` WHERE (type = 'post' AND special_id = '1490159') ORDER BY `order` ASC 0.0004420280456543
(471) DESCRIBE `cruises` 0.0035319328308105
(472) SELECT `cruises`.* FROM `cruises` WHERE (id IN (45259, 48303, 45260, 71399, 71400, 11517, 56860, 56889, 67266, 67378)) ORDER BY FIND_IN_SET(id, '45259,48303,45260,71399,71400,11517,56860,56889,67266,67378') 0.0018839836120605
(473) DESCRIBE `cruiselines` 0.0022740364074707
(474) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('120', '212', '218', '47', '264', '191', '33', '18', '14', '20', '23', '29', '24', '114', '8', '213', '4')) ORDER BY FIND_IN_SET(id, '120,212,218,47,264,191,33,18,14,20,23,29,24,114,8,213,4') 0.00166916847229
(475) DESCRIBE `ships` 0.0032889842987061
(476) SELECT `ships`.* FROM `ships` WHERE (id IN ('521', '520', '1163', '627', '1526', '517', '1767', '1013', '701', '441', '163', '1205', '1032', '401', '1168', '1398', '1788', '66', '390', '451', '461', '683', '1303', '9', '10', '21', '22', '24', '25', '27', '105', '404', '439', '547', '582', '970', '1008', '1320', '1372', '1579', '1749', '1773', '1791', '3', '4', '11', '28', '74', '148', '160', '327', '332', '333', '335', '340', '626', '669', '678', '739', '792', '1073', '1243', '1262', '1302', '1347', '1385', '1539', '1540', '1569', '1711')) ORDER BY FIND_IN_SET(id, '521,520,1163,627,1526,517,1767,1013,701,441,163,1205,1032,401,1168,1398,1788,66,390,451,461,683,1303,9,10,21,22,24,25,27,105,404,439,547,582,970,1008,1320,1372,1579,1749,1773,1791,3,4,11,28,74,148,160,327,332,333,335,340,626,669,678,739,792,1073,1243,1262,1302,1347,1385,1539,1540,1569,1711') 0.008263111114502
(477) DESCRIBE `cruisetypes` 0.0016858577728271
(478) DESCRIBE `destinations` 0.002471923828125
(479) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('54', '39', '43', '12', '8', '2', '53', '35', '9', '29', '40', '48', '55', '22', '26', '34', '7', '25', '30', '49', '56')) ORDER BY FIND_IN_SET(id, '54,39,43,12,8,2,53,35,9,29,40,48,55,22,26,34,7,25,30,49,56') 0.0022158622741699