or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. 8 Romantic Destinations Around the World
  3. Royal Caribbean Launch “Royal Up”
  4. Catch Up on Cruising: Latest News in bite size!
  5. Drinks Package Comparison

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.69387650489807

# Query Time
(1) connect 0.00085115432739258
(2) DESCRIBE `specials` 0.006464958190918
(3) SELECT `specials`.* FROM `specials` WHERE (orchid_slug = 'circle-pacific-sydney-to-auckland') AND (orchid_available = 1) LIMIT 1 0.0014030933380127
(4) DESCRIBE `cruises` 0.004478931427002
(5) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 79643))) 0.00083208084106445
(6) DESCRIBE `avid_specials` 0.0019519329071045
(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.0018320083618164
(8) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1490159') 0.00060105323791504
(9) DESCRIBE `ships` 0.0039100646972656
(10) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 105))) 0.00066113471984863
(11) DESCRIBE `ships` 0.0040569305419922
(12) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '105') 0.00055408477783203
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036907196044922
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034189224243164
(15) DESCRIBE `itineraries` 0.0022420883178711
(16) DESCRIBE `ports` 0.0022940635681152
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0005500316619873
(18) DESCRIBE `ports` 0.0020289421081543
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045990943908691
(20) DESCRIBE `ports` 0.002161979675293
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00047707557678223
(22) DESCRIBE `specialsailingdates` 0.0017099380493164
(23) DESCRIBE `sailingdates` 0.0018799304962158
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 493202))) 0.00046491622924805
(25) DESCRIBE `ports` 0.0021491050720215
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00052905082702637
(27) DESCRIBE `ports` 0.0021340847015381
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00050687789916992
(29) DESCRIBE `ports` 0.0020570755004883
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00052881240844727
(31) DESCRIBE `ports` 0.0021891593933105
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00052189826965332
(33) DESCRIBE `ports` 0.0019619464874268
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.00049781799316406
(35) DESCRIBE `ports` 0.0018851757049561
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.00042510032653809
(37) DESCRIBE `ports` 0.0018317699432373
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.00068497657775879
(39) DESCRIBE `ports` 0.001957893371582
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '421') 0.00047397613525391
(41) DESCRIBE `ports` 0.0017800331115723
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00045299530029297
(43) DESCRIBE `ports` 0.0017731189727783
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00045299530029297
(45) DESCRIBE `ports` 0.0020670890808105
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00043201446533203
(47) DESCRIBE `ports` 0.0017509460449219
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00049304962158203
(49) DESCRIBE `ports` 0.0021040439605713
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00066184997558594
(51) DESCRIBE `ports` 0.0020549297332764
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00050878524780273
(53) DESCRIBE `ports` 0.0018529891967773
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00049400329589844
(55) DESCRIBE `ports` 0.0018508434295654
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00044083595275879
(57) DESCRIBE `ports` 0.0018870830535889
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00051307678222656
(59) DESCRIBE `ports` 0.0016169548034668
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.00042390823364258
(61) DESCRIBE `ports` 0.0016970634460449
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.0005040168762207
(63) DESCRIBE `ports` 0.0019500255584717
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00052809715270996
(65) DESCRIBE `ports` 0.0020689964294434
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1308))) 0.00053095817565918
(67) DESCRIBE `ports` 0.0020411014556885
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1308') 0.00048089027404785
(69) DESCRIBE `ports` 0.0019919872283936
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1273))) 0.00054788589477539
(71) DESCRIBE `ports` 0.0016732215881348
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1273') 0.00041389465332031
(73) DESCRIBE `ports` 0.0016589164733887
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00047802925109863
(75) DESCRIBE `ports` 0.0020229816436768
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00042986869812012
(77) DESCRIBE `ports` 0.0018389225006104
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 37))) 0.0004119873046875
(79) DESCRIBE `ports` 0.0018539428710938
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '37') 0.00039887428283691
(81) DESCRIBE `ports` 0.001816987991333
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00048303604125977
(83) DESCRIBE `ports` 0.0019669532775879
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00048089027404785
(85) DESCRIBE `ports` 0.0021989345550537
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 292))) 0.00075101852416992
(87) DESCRIBE `ports` 0.0020830631256104
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '292') 0.00049686431884766
(89) DESCRIBE `ports` 0.0020599365234375
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00050806999206543
(91) DESCRIBE `ports` 0.0020289421081543
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00049114227294922
(93) DESCRIBE `ports` 0.0018978118896484
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00050902366638184
(95) DESCRIBE `ports` 0.0019898414611816
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00043892860412598
(97) DESCRIBE `ports` 0.0018069744110107
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00047397613525391
(99) DESCRIBE `ports` 0.0020802021026611
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.0005030632019043
(101) DESCRIBE `ports` 0.0020439624786377
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00055289268493652
(103) DESCRIBE `ports` 0.002187967300415
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00051212310791016
(105) DESCRIBE `ports` 0.0019640922546387
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00049209594726562
(107) DESCRIBE `ports` 0.0020661354064941
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00057721138000488
(109) DESCRIBE `ports` 0.0020110607147217
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00047898292541504
(111) DESCRIBE `ports` 0.0017979145050049
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00042891502380371
(113) DESCRIBE `ports` 0.0017631053924561
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00054788589477539
(115) DESCRIBE `ports` 0.0017738342285156
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00041890144348145
(117) DESCRIBE `ports` 0.00180983543396
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00049209594726562
(119) DESCRIBE `ports` 0.0018529891967773
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00046896934509277
(121) DESCRIBE `ports` 0.001845121383667
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00044703483581543
(123) DESCRIBE `ports` 0.0018057823181152
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00042390823364258
(125) DESCRIBE `ports` 0.0019299983978271
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00048589706420898
(127) DESCRIBE `ports` 0.0018160343170166
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00044798851013184
(129) DESCRIBE `ports` 0.0020709037780762
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00092911720275879
(131) DESCRIBE `ports` 0.0025599002838135
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00057220458984375
(133) DESCRIBE `ports` 0.0021159648895264
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00053501129150391
(135) DESCRIBE `ports` 0.0021209716796875
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00050592422485352
(137) DESCRIBE `ports` 0.0021061897277832
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00057101249694824
(139) DESCRIBE `ports` 0.001971960067749
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00048494338989258
(141) DESCRIBE `ports` 0.0020029544830322
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2224))) 0.00053310394287109
(143) DESCRIBE `ports` 0.0019989013671875
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2224') 0.00046992301940918
(145) DESCRIBE `ports` 0.0020120143890381
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1655))) 0.00050210952758789
(147) DESCRIBE `ports` 0.0020120143890381
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1655') 0.00042819976806641
(149) DESCRIBE `ports` 0.0020120143890381
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.0004730224609375
(151) DESCRIBE `ports` 0.0020079612731934
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.00044703483581543
(153) DESCRIBE `ports` 0.002255916595459
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00056815147399902
(155) DESCRIBE `ports` 0.0020010471343994
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00050806999206543
(157) DESCRIBE `ports` 0.0022189617156982
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 384))) 0.00059390068054199
(159) DESCRIBE `ports` 0.0021829605102539
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '384') 0.00051999092102051
(161) DESCRIBE `ports` 0.0030970573425293
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00076484680175781
(163) DESCRIBE `ports` 0.0040841102600098
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00077104568481445
(165) DESCRIBE `ports` 0.0024731159210205
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00062894821166992
(167) DESCRIBE `ports` 0.0027191638946533
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00052905082702637
(169) DESCRIBE `ports` 0.0025570392608643
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 86))) 0.00063896179199219
(171) DESCRIBE `ports` 0.0020618438720703
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '86') 0.00099897384643555
(173) DESCRIBE `ports` 0.0019941329956055
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00057411193847656
(175) DESCRIBE `ports` 0.0020809173583984
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00061702728271484
(177) DESCRIBE `ports` 0.0025670528411865
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00057220458984375
(179) DESCRIBE `ports` 0.0021288394927979
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00047111511230469
(181) DESCRIBE `specialsmultipricing` 0.0019328594207764
(182) DESCRIBE `leadpricing` 0.0018899440765381
(183) DESCRIBE `specialspricing` 0.0026340484619141
(184) DESCRIBE `cabins` 0.0021040439605713
(185) SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 2655))) 0.00048589706420898
(186) DESCRIBE `currencies` 0.0017189979553223
(187) SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6))) 0.00040984153747559
(188) DESCRIBE `cruiselines` 0.0027029514312744
(189) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00066995620727539
(190) DESCRIBE `orchid_image` 0.0022130012512207
(191) DESCRIBE `cruiselines` 0.0023119449615479
(192) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00045204162597656
(193) DESCRIBE `cruises` 0.0038051605224609
(194) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79643') 0.00060796737670898
(195) DESCRIBE `deckplans` 0.0020499229431152
(196) DESCRIBE `cabins` 0.0022339820861816
(197) DESCRIBE `shipphotos` 0.0021989345550537
(198) DESCRIBE `specialitineraries` 0.0021212100982666
(199) SELECT `specialitineraries`.* FROM `specialitineraries` WHERE (type = 'pre' AND special_id = '1490159') ORDER BY `order` ASC 0.00062298774719238
(200) DESCRIBE `ports` 0.002357006072998
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00051116943359375
(202) DESCRIBE `ports` 0.0019969940185547
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00047016143798828
(204) DESCRIBE `ports` 0.0020089149475098
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049185752868652
(206) DESCRIBE `ports` 0.0019278526306152
(207) DESCRIBE `ports` 0.0018880367279053
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00053691864013672
(209) DESCRIBE `ports` 0.0016999244689941
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00039005279541016
(211) DESCRIBE `ports` 0.0017149448394775
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0004270076751709
(213) DESCRIBE `ports` 0.0018949508666992
(214) DESCRIBE `ports` 0.0018839836120605
(215) DESCRIBE `ports` 0.0018517971038818
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.00067591667175293
(217) DESCRIBE `ports` 0.0022408962249756
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.0006110668182373
(219) DESCRIBE `ports` 0.0019340515136719
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.0005340576171875
(221) DESCRIBE `ports` 0.0021660327911377
(222) DESCRIBE `ports` 0.0021870136260986
(223) DESCRIBE `ports` 0.0025851726531982
(224) DESCRIBE `ports` 0.0022389888763428
(225) DESCRIBE `ports` 0.0021400451660156
(226) DESCRIBE `ports` 0.0018420219421387
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.0005030632019043
(228) DESCRIBE `ports` 0.0020151138305664
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '421') 0.0005030632019043
(230) DESCRIBE `ports` 0.0020151138305664
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 421))) 0.00053095817565918
(232) DESCRIBE `ports` 0.0020091533660889
(233) DESCRIBE `ports` 0.0021100044250488
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00055909156799316
(235) DESCRIBE `ports` 0.002122163772583
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00048995018005371
(237) DESCRIBE `ports` 0.001917839050293
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00053691864013672
(239) DESCRIBE `ports` 0.00223708152771
(240) DESCRIBE `ports` 0.0020020008087158
(241) DESCRIBE `ports` 0.0020451545715332
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00047612190246582
(243) DESCRIBE `ports` 0.0019750595092773
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00047397613525391
(245) DESCRIBE `ports` 0.0021171569824219
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00056910514831543
(247) DESCRIBE `ports` 0.001986026763916
(248) DESCRIBE `ports` 0.001924991607666
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00049495697021484
(250) DESCRIBE `ports` 0.0020978450775146
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00054597854614258
(252) DESCRIBE `ports` 0.0023548603057861
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00053310394287109
(254) DESCRIBE `ports` 0.0020830631256104
(255) DESCRIBE `ports` 0.0018770694732666
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00060200691223145
(257) DESCRIBE `ports` 0.0019218921661377
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00049996376037598
(259) DESCRIBE `ports` 0.0019199848175049
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00052690505981445
(261) DESCRIBE `ports` 0.0023050308227539
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00047802925109863
(263) DESCRIBE `ports` 0.0017728805541992
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.00042104721069336
(265) DESCRIBE `ports` 0.0017580986022949
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.0004889965057373
(267) DESCRIBE `ports` 0.0019950866699219
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00055813789367676
(269) DESCRIBE `ports` 0.0019938945770264
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00050497055053711
(271) DESCRIBE `ports` 0.001986026763916
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00051188468933105
(273) DESCRIBE `ports` 0.0020430088043213
(274) DESCRIBE `ports` 0.0020270347595215
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1308))) 0.00054597854614258
(276) DESCRIBE `ports` 0.0020709037780762
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1308') 0.00042891502380371
(278) DESCRIBE `ports` 0.0018308162689209
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1308))) 0.00049614906311035
(280) DESCRIBE `ports` 0.0019550323486328
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1273))) 0.00050616264343262
(282) DESCRIBE `ports` 0.001863956451416
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1273') 0.00045609474182129
(284) DESCRIBE `ports` 0.0018150806427002
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1273))) 0.00046491622924805
(286) DESCRIBE `ports` 0.0018739700317383
(287) DESCRIBE `ports` 0.0018160343170166
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00046420097351074
(289) DESCRIBE `ports` 0.0018341541290283
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00046706199645996
(291) DESCRIBE `ports` 0.0017471313476562
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00040602684020996
(293) DESCRIBE `ports` 0.0017781257629395
(294) DESCRIBE `ports` 0.0020239353179932
(295) DESCRIBE `ports` 0.001823902130127
(296) DESCRIBE `ports` 0.0017390251159668
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 37))) 0.00044798851013184
(298) DESCRIBE `ports` 0.0018279552459717
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '37') 0.00045418739318848
(300) DESCRIBE `ports` 0.0018820762634277
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 37))) 0.00044798851013184
(302) DESCRIBE `ports` 0.0018510818481445
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00044488906860352
(304) DESCRIBE `ports` 0.0018520355224609
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00042295455932617
(306) DESCRIBE `ports` 0.0017838478088379
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00050997734069824
(308) DESCRIBE `ports` 0.0021770000457764
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 292))) 0.00052881240844727
(310) DESCRIBE `ports` 0.0033831596374512
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '292') 0.00067901611328125
(312) DESCRIBE `ports` 0.0023589134216309
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 292))) 0.0006248950958252
(314) DESCRIBE `ports` 0.0021920204162598
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00048112869262695
(316) DESCRIBE `ports` 0.0019738674163818
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00047898292541504
(318) DESCRIBE `ports` 0.0018539428710938
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00049901008605957
(320) DESCRIBE `ports` 0.0020802021026611
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00052285194396973
(322) DESCRIBE `ports` 0.0021498203277588
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00049209594726562
(324) DESCRIBE `ports` 0.0020771026611328
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00052809715270996
(326) DESCRIBE `ports` 0.0021369457244873
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00053501129150391
(328) DESCRIBE `ports` 0.0022220611572266
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00046992301940918
(330) DESCRIBE `ports` 0.0021181106567383
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00053000450134277
(332) DESCRIBE `ports` 0.0018141269683838
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00049901008605957
(334) DESCRIBE `ports` 0.0020930767059326
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00043797492980957
(336) DESCRIBE `ports` 0.0018401145935059
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00048112869262695
(338) DESCRIBE `ports` 0.0018799304962158
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00042104721069336
(340) DESCRIBE `ports` 0.0018501281738281
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00043106079101562
(342) DESCRIBE `ports` 0.0018517971038818
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00061702728271484
(344) DESCRIBE `ports` 0.0021579265594482
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00052595138549805
(346) DESCRIBE `ports` 0.0024130344390869
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00051212310791016
(348) DESCRIBE `ports` 0.0019941329956055
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00049090385437012
(350) DESCRIBE `ports` 0.0019290447235107
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00047397613525391
(352) DESCRIBE `ports` 0.0020210742950439
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00048708915710449
(354) DESCRIBE `ports` 0.0020208358764648
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00051498413085938
(356) DESCRIBE `ports` 0.0020301342010498
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.0005500316619873
(358) DESCRIBE `ports` 0.0020639896392822
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00052213668823242
(360) DESCRIBE `ports` 0.0019161701202393
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00072479248046875
(362) DESCRIBE `ports` 0.0022270679473877
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.0005340576171875
(364) DESCRIBE `ports` 0.0020849704742432
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00053310394287109
(366) DESCRIBE `ports` 0.0019969940185547
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00056004524230957
(368) DESCRIBE `ports` 0.002310037612915
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00053095817565918
(370) DESCRIBE `ports` 0.0027890205383301
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.0006721019744873
(372) DESCRIBE `ports` 0.0022721290588379
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00061202049255371
(374) DESCRIBE `ports` 0.0020358562469482
(375) DESCRIBE `ports` 0.0022728443145752
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00086498260498047
(377) DESCRIBE `ports` 0.0024869441986084
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00057291984558105
(379) DESCRIBE `ports` 0.0044198036193848
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00060701370239258
(381) DESCRIBE `ports` 0.0028219223022461
(382) DESCRIBE `ports` 0.0020830631256104
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00064492225646973
(384) DESCRIBE `ports` 0.0025420188903809
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00053811073303223
(386) DESCRIBE `ports` 0.0029940605163574
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00060296058654785
(388) DESCRIBE `ports` 0.0026021003723145
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00062203407287598
(390) DESCRIBE `ports` 0.0022950172424316
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00050902366638184
(392) DESCRIBE `ports` 0.0019659996032715
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00050616264343262
(394) DESCRIBE `ports` 0.0020291805267334
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2224))) 0.00051999092102051
(396) DESCRIBE `ports` 0.00201416015625
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2224') 0.00046396255493164
(398) DESCRIBE `ports` 0.0020511150360107
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2224))) 0.00055599212646484
(400) DESCRIBE `ports` 0.002000093460083
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1655))) 0.00051999092102051
(402) DESCRIBE `ports` 0.0020740032196045
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1655') 0.00056219100952148
(404) DESCRIBE `ports` 0.0022552013397217
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1655))) 0.00065112113952637
(406) DESCRIBE `ports` 0.0021140575408936
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00053501129150391
(408) DESCRIBE `ports` 0.0020880699157715
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.00052285194396973
(410) DESCRIBE `ports` 0.002000093460083
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00051593780517578
(412) DESCRIBE `ports` 0.0019991397857666
(413) DESCRIBE `ports` 0.0019810199737549
(414) DESCRIBE `ports` 0.00193190574646
(415) DESCRIBE `ports` 0.0018720626831055
(416) DESCRIBE `ports` 0.0020239353179932
(417) DESCRIBE `ports` 0.0019288063049316
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00054192543029785
(419) DESCRIBE `ports` 0.0022120475769043
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00050091743469238
(421) DESCRIBE `ports` 0.0021200180053711
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.0011827945709229
(423) DESCRIBE `ports` 0.0022737979888916
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 384))) 0.00053596496582031
(425) DESCRIBE `ports` 0.0020649433135986
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '384') 0.00059700012207031
(427) DESCRIBE `ports` 0.0021278858184814
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 384))) 0.00056600570678711
(429) DESCRIBE `ports` 0.0020458698272705
(430) DESCRIBE `ports` 0.0019969940185547
(431) DESCRIBE `ports` 0.001986026763916
(432) DESCRIBE `ports` 0.0019659996032715
(433) DESCRIBE `ports` 0.0019681453704834
(434) DESCRIBE `ports` 0.0021190643310547
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00057601928710938
(436) DESCRIBE `ports` 0.0021078586578369
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00048613548278809
(438) DESCRIBE `ports` 0.0020639896392822
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.0011849403381348
(440) DESCRIBE `ports` 0.0035109519958496
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00056099891662598
(442) DESCRIBE `ports` 0.0029458999633789
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00049591064453125
(444) DESCRIBE `ports` 0.0026021003723145
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00042390823364258
(446) DESCRIBE `ports` 0.0020239353179932
(447) DESCRIBE `ports` 0.002007007598877
(448) DESCRIBE `ports` 0.0028238296508789
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 86))) 0.00066709518432617
(450) DESCRIBE `ports` 0.0023670196533203
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '86') 0.00054693222045898
(452) DESCRIBE `ports` 0.0020220279693604
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 86))) 0.0005040168762207
(454) DESCRIBE `ports` 0.0020051002502441
(455) DESCRIBE `ports` 0.001978874206543
(456) DESCRIBE `ports` 0.0019350051879883
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00051999092102051
(458) DESCRIBE `ports` 0.0019030570983887
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00037908554077148
(460) DESCRIBE `ports` 0.0019130706787109
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00046896934509277
(462) DESCRIBE `ports` 0.002032995223999
(463) DESCRIBE `ports` 0.0021688938140869
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00055694580078125
(465) DESCRIBE `ports` 0.0021500587463379
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00051188468933105
(467) DESCRIBE `ports` 0.0021109580993652
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00049877166748047
(469) DESCRIBE `specialitineraries` 0.0021147727966309
(470) SELECT `specialitineraries`.* FROM `specialitineraries` WHERE (type = 'post' AND special_id = '1490159') ORDER BY `order` ASC 0.00058412551879883
(471) DESCRIBE `cruises` 0.0042929649353027
(472) SELECT `cruises`.* FROM `cruises` WHERE (id IN (75092, 71061, 56368, 75087, 63940, 71423, 63941, 43678, 67915, 75085)) ORDER BY FIND_IN_SET(id, '75092,71061,56368,75087,63940,71423,63941,43678,67915,75085') 0.0018520355224609
(473) DESCRIBE `cruiselines` 0.0030450820922852
(474) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('212', '33', '218', '114', '23', '18', '191', '264', '20', '140', '24', '19', '29', '4', '91', '151')) ORDER BY FIND_IN_SET(id, '212,33,218,114,23,18,191,264,20,140,24,19,29,4,91,151') 0.0019128322601318
(475) DESCRIBE `ships` 0.0050218105316162
(476) SELECT `ships`.* FROM `ships` WHERE (id IN ('1163', '1526', '1013', '1303', '160', '1282', '163', '1159', '1266', '1767', '1772', '1788', '1032', '338', '451', '547', '1262', '75', '162', '404', '580', '1073', '1205', '1491', '1539', '4', '74', '105', '147', '452', '622', '626', '652', '669', '678', '717', '741', '835', '1108', '1168', '1193', '1415', '1540', '1569', '1711')) ORDER BY FIND_IN_SET(id, '1163,1526,1013,1303,160,1282,163,1159,1266,1767,1772,1788,1032,338,451,547,1262,75,162,404,580,1073,1205,1491,1539,4,74,105,147,452,622,626,652,669,678,717,741,835,1108,1168,1193,1415,1540,1569,1711') 0.0064351558685303
(477) DESCRIBE `cruisetypes` 0.0021228790283203
(478) DESCRIBE `destinations` 0.0060369968414307
(479) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('39', '22', '43', '12', '49', '2', '28', '40', '50', '8', '35', '53', '55', '34', '11', '29', '38', '54', '25', '26', '37', '45', '52')) ORDER BY FIND_IN_SET(id, '39,22,43,12,49,2,28,40,50,8,35,53,55,34,11,29,38,54,25,26,37,45,52') 0.0023188591003418