or, enquire about your chosen options

  1. Carnival Cruise Line teams up with Harlem Globetrotters
  2. Ultra-Luxury Cruising
  3. The Caribbean is still a Preferred Cruise Destination
  4. Catch Up on Cruising: Latest News in bite size!
  5. 8 Romantic Destinations Around the World

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

Itinerary for Cruise QE, Japan & Alaska Q015B ex Yokohama to Vancouver

Day Port Arrive Depart
Day 1 Yokohama, Japan
Day 2 At Sea
Day 3 Akita, Japan
Day 4 Kanazawa, Japan
Day 5 Maizuru, Japan
Day 6 Sakaiminato, Japan
Day 7 Busan, (Pusan) South Korea
Day 8 Nagasaki, Japan
Day 9 At Sea
Day 10 Yokohama, Japan
Day 11 At Sea
Day 12 Hakodate, Japan
Day 13 Otaru Ko, Japan
Day 14 At Sea
Day 15 Korsakov, Russia
Day 16 At Sea
Day 17 At Sea
Day 18 Date Line Crossing
Day 19 At Sea
Day 20 At Sea
Day 21 Kodiak, Alaska
Day 22 Anchorage, Alaska
Day 23 At Sea
Day 24 Hubbard Glacier, Alaska
Day 25 Juneau, Alaska
Day 25 Tracy Arm Fjord, Alaska
Day 26 At Sea
Day 27 Inside Passage, Alaska
Day 28 Vancouver, BC. Canada
Day 29 Inside Passage, Alaska
Day 30 Juneau, Alaska
Day 30 Tracy Arm Fjord, Alaska
Day 31 Skagway, Alaska
Day 32 Hubbard Glacier, Alaska
Day 33 Icy Strait Point, Alaska
Day 34 Sitka, Alaska
Day 35 Ketchikan, Alaska
Day 36 At Sea
Day 37 Victoria, BC. Canada
Day 38 Vancouver, BC. Canada

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

Total elapsed time: 0.59102368354797

# Query Time
(1) connect 0.0010910034179688
(2) DESCRIBE `cruises` 0.0040998458862305
(3) SELECT `cruises`.* FROM `cruises` WHERE (orchid_slug = 'qe-japan-alaska-q015b-ex-yokohama-to-vancouver') AND (orchid_available = 1) LIMIT 1 0.041306018829346
(4) DESCRIBE `avid_specials` 0.0019428730010986
(5) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75386 and class = 'Cruise') OR (item_id = 780 AND class = 'Ship') OR (item_id = 15 AND class = 'CruiseLine') OR (item_id = 2 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.0019230842590332
(6) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75386') 0.00042581558227539
(7) DESCRIBE `ships` 0.0044450759887695
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 780))) 0.00050592422485352
(9) DESCRIBE `ships` 0.0043659210205078
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '780') 0.00045895576477051
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00042319297790527
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034093856811523
(13) DESCRIBE `itineraries` 0.0020608901977539
(14) DESCRIBE `ports` 0.002730131149292
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00044798851013184
(16) DESCRIBE `ports` 0.0019938945770264
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00052213668823242
(18) DESCRIBE `ports` 0.0021371841430664
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00064182281494141
(20) DESCRIBE `sailingdates` 0.0019299983978271
(21) DESCRIBE `ports` 0.0019099712371826
(22) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00045299530029297
(23) DESCRIBE `ports` 0.0017600059509277
(24) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00038790702819824
(25) DESCRIBE `ports` 0.0018069744110107
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3203))) 0.00043892860412598
(27) DESCRIBE `ports` 0.0023961067199707
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3203') 0.00040793418884277
(29) DESCRIBE `ports` 0.0019969940185547
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1433))) 0.00047993659973145
(31) DESCRIBE `ports` 0.0019757747650146
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1433') 0.00044083595275879
(33) DESCRIBE `ports` 0.0018279552459717
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4361))) 0.00040888786315918
(35) DESCRIBE `ports` 0.0017950534820557
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4361') 0.0004279613494873
(37) DESCRIBE `ports` 0.0022439956665039
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1432))) 0.00044512748718262
(39) DESCRIBE `ports` 0.0018839836120605
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1432') 0.00039505958557129
(41) DESCRIBE `ports` 0.0018289089202881
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00049901008605957
(43) DESCRIBE `ports` 0.0019519329071045
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00037288665771484
(45) DESCRIBE `ports` 0.0018279552459717
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 540))) 0.00038909912109375
(47) DESCRIBE `ports` 0.0020449161529541
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '540') 0.00051593780517578
(49) DESCRIBE `ports` 0.0022499561309814
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00043511390686035
(51) DESCRIBE `ports` 0.00211501121521
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00039005279541016
(53) DESCRIBE `ports` 0.0026190280914307
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1308))) 0.00059795379638672
(55) DESCRIBE `ports` 0.002877950668335
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1308') 0.0005640983581543
(57) DESCRIBE `ports` 0.0027239322662354
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1307))) 0.00074195861816406
(59) DESCRIBE `ports` 0.0025990009307861
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1307') 0.00042009353637695
(61) DESCRIBE `ports` 0.0021369457244873
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2509))) 0.00047206878662109
(63) DESCRIBE `ports` 0.0023000240325928
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2509') 0.00052213668823242
(65) DESCRIBE `ports` 0.0028910636901855
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00055909156799316
(67) DESCRIBE `ports` 0.0025660991668701
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.0004880428314209
(69) DESCRIBE `ports` 0.0025019645690918
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 37))) 0.00056791305541992
(71) DESCRIBE `ports` 0.0022881031036377
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '37') 0.00043988227844238
(73) DESCRIBE `ports` 0.0022058486938477
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 31))) 0.00049018859863281
(75) DESCRIBE `ports` 0.0024170875549316
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '31') 0.00053310394287109
(77) DESCRIBE `ports` 0.0027778148651123
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00058197975158691
(79) DESCRIBE `ports` 0.0025680065155029
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00050210952758789
(81) DESCRIBE `ports` 0.0024361610412598
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.0005490779876709
(83) DESCRIBE `ports` 0.0024299621582031
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00048398971557617
(85) DESCRIBE `ports` 0.0023818016052246
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 58))) 0.00051689147949219
(87) DESCRIBE `ports` 0.0019340515136719
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '58') 0.00038313865661621
(89) DESCRIBE `ports` 0.0018668174743652
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00040912628173828
(91) DESCRIBE `ports` 0.0017321109771729
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.0004429817199707
(93) DESCRIBE `ports` 0.0019321441650391
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00042009353637695
(95) DESCRIBE `ports` 0.0019440650939941
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00039911270141602
(97) DESCRIBE `ports` 0.0019629001617432
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00041699409484863
(99) DESCRIBE `ports` 0.0017311573028564
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00041890144348145
(101) DESCRIBE `ports` 0.0018868446350098
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00039792060852051
(103) DESCRIBE `ports` 0.0020151138305664
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.0004119873046875
(105) DESCRIBE `ports` 0.0021519660949707
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 58))) 0.00039792060852051
(107) DESCRIBE `ports` 0.002094030380249
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '58') 0.00046706199645996
(109) DESCRIBE `ports` 0.0019190311431885
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00055813789367676
(111) DESCRIBE `ports` 0.0019919872283936
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00039100646972656
(113) DESCRIBE `ports` 0.0028460025787354
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00046491622924805
(115) DESCRIBE `ports` 0.0020298957824707
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00051999092102051
(117) DESCRIBE `ports` 0.0022270679473877
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 553))) 0.00042104721069336
(119) DESCRIBE `ports` 0.0019559860229492
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '553') 0.00040912628173828
(121) DESCRIBE `ports` 0.0018219947814941
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.0004119873046875
(123) DESCRIBE `ports` 0.0019330978393555
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00049185752868652
(125) DESCRIBE `ports` 0.0023431777954102
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00075697898864746
(127) DESCRIBE `ports` 0.0026559829711914
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00057697296142578
(129) DESCRIBE `ports` 0.0026938915252686
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00062298774719238
(131) DESCRIBE `ports` 0.0026459693908691
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00057101249694824
(133) DESCRIBE `ports` 0.0026240348815918
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00066113471984863
(135) DESCRIBE `ports` 0.0026729106903076
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00059103965759277
(137) DESCRIBE `cruiselines` 0.0039141178131104
(138) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 15))) 0.0006411075592041
(139) DESCRIBE `orchid_image` 0.0030760765075684
(140) DESCRIBE `cruiselines` 0.0033259391784668
(141) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '15') 0.00042295455932617
(142) DESCRIBE `cabins` 0.0027070045471191
(143) DESCRIBE `deckplans` 0.0025360584259033
(144) DESCRIBE `shipphotos` 0.0018179416656494
(145) DESCRIBE `ports` 0.0019509792327881
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00046896934509277
(147) DESCRIBE `ports` 0.0019950866699219
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00038409233093262
(149) DESCRIBE `ports` 0.0017549991607666
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00049495697021484
(151) DESCRIBE `ports` 0.0018990039825439
(152) DESCRIBE `ports` 0.0018181800842285
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3203))) 0.00045514106750488
(154) DESCRIBE `ports` 0.0018899440765381
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3203') 0.00046896934509277
(156) DESCRIBE `ports` 0.0018551349639893
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3203))) 0.00043416023254395
(158) DESCRIBE `ports` 0.0021450519561768
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1433))) 0.0004429817199707
(160) DESCRIBE `ports` 0.0018219947814941
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1433') 0.00037598609924316
(162) DESCRIBE `ports` 0.0018990039825439
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1433))) 0.00039911270141602
(164) DESCRIBE `ports` 0.0017328262329102
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4361))) 0.00039792060852051
(166) DESCRIBE `ports` 0.0017290115356445
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4361') 0.00056004524230957
(168) DESCRIBE `ports` 0.0020668506622314
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4361))) 0.00043892860412598
(170) DESCRIBE `ports` 0.0019819736480713
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1432))) 0.00043511390686035
(172) DESCRIBE `ports` 0.0017600059509277
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1432') 0.00042581558227539
(174) DESCRIBE `ports` 0.0018818378448486
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1432))) 0.00041389465332031
(176) DESCRIBE `ports` 0.0019741058349609
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00038981437683105
(178) DESCRIBE `ports` 0.0017580986022949
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00039386749267578
(180) DESCRIBE `ports` 0.0018370151519775
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00056600570678711
(182) DESCRIBE `ports` 0.0018050670623779
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 540))) 0.00040507316589355
(184) DESCRIBE `ports` 0.0019829273223877
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '540') 0.00038695335388184
(186) DESCRIBE `ports` 0.0019469261169434
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 540))) 0.00042200088500977
(188) DESCRIBE `ports` 0.0018842220306396
(189) DESCRIBE `ports` 0.0018501281738281
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.0004119873046875
(191) DESCRIBE `ports` 0.0021169185638428
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00049710273742676
(193) DESCRIBE `ports` 0.0020740032196045
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00040197372436523
(195) DESCRIBE `ports` 0.0018138885498047
(196) DESCRIBE `ports` 0.0021488666534424
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1308))) 0.00052690505981445
(198) DESCRIBE `ports` 0.0024878978729248
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1308') 0.00050187110900879
(200) DESCRIBE `ports` 0.0018379688262939
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1308))) 0.00050115585327148
(202) DESCRIBE `ports` 0.0022408962249756
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1307))) 0.00043797492980957
(204) DESCRIBE `ports` 0.001863956451416
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1307') 0.0003819465637207
(206) DESCRIBE `ports` 0.001802921295166
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1307))) 0.00040102005004883
(208) DESCRIBE `ports` 0.0018517971038818
(209) DESCRIBE `ports` 0.0017530918121338
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2509))) 0.00043511390686035
(211) DESCRIBE `ports` 0.0018298625946045
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2509') 0.00048303604125977
(213) DESCRIBE `ports` 0.0018990039825439
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2509))) 0.00046801567077637
(215) DESCRIBE `ports` 0.0020730495452881
(216) DESCRIBE `ports` 0.0022180080413818
(217) DESCRIBE `ports` 0.0018110275268555
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00042486190795898
(219) DESCRIBE `ports` 0.0021400451660156
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00038504600524902
(221) DESCRIBE `ports` 0.0019810199737549
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00043082237243652
(223) DESCRIBE `ports` 0.0019462108612061
(224) DESCRIBE `ports` 0.0019359588623047
(225) DESCRIBE `ports` 0.0021660327911377
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 37))) 0.00057601928710938
(227) DESCRIBE `ports` 0.0023519992828369
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '37') 0.00053310394287109
(229) DESCRIBE `ports` 0.0028171539306641
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 37))) 0.00059795379638672
(231) DESCRIBE `ports` 0.0027709007263184
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 31))) 0.00053787231445312
(233) DESCRIBE `ports` 0.0022399425506592
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '31') 0.0035359859466553
(235) DESCRIBE `ports` 0.0023810863494873
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 31))) 0.00047707557678223
(237) DESCRIBE `ports` 0.0020179748535156
(238) DESCRIBE `ports` 0.0021240711212158
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.0005490779876709
(240) DESCRIBE `ports` 0.0022358894348145
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.0005340576171875
(242) DESCRIBE `ports` 0.0019080638885498
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00042009353637695
(244) DESCRIBE `ports` 0.0018131732940674
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00039100646972656
(246) DESCRIBE `ports` 0.0018019676208496
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00038313865661621
(248) DESCRIBE `ports` 0.0021800994873047
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.0004880428314209
(250) DESCRIBE `ports` 0.0018711090087891
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 58))) 0.00062799453735352
(252) DESCRIBE `ports` 0.0018930435180664
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '58') 0.00042080879211426
(254) DESCRIBE `ports` 0.0019450187683105
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 58))) 0.00038504600524902
(256) DESCRIBE `ports` 0.0020661354064941
(257) DESCRIBE `ports` 0.002133846282959
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00048398971557617
(259) DESCRIBE `ports` 0.0019330978393555
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00044488906860352
(261) DESCRIBE `ports` 0.0020651817321777
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00047802925109863
(263) DESCRIBE `ports` 0.0019910335540771
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00048685073852539
(265) DESCRIBE `ports` 0.0020720958709717
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00049090385437012
(267) DESCRIBE `ports` 0.001884937286377
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00041985511779785
(269) DESCRIBE `ports` 0.0020899772644043
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00040793418884277
(271) DESCRIBE `ports` 0.0020577907562256
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00045394897460938
(273) DESCRIBE `ports` 0.002112865447998
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00043988227844238
(275) DESCRIBE `ports` 0.0017499923706055
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00041890144348145
(277) DESCRIBE `ports` 0.0018289089202881
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00038290023803711
(279) DESCRIBE `ports` 0.0018820762634277
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00048303604125977
(281) DESCRIBE `ports` 0.0017650127410889
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 58))) 0.00046610832214355
(283) DESCRIBE `ports` 0.0017480850219727
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '58') 0.00037693977355957
(285) DESCRIBE `ports` 0.0018699169158936
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 58))) 0.00039100646972656
(287) DESCRIBE `ports` 0.0018758773803711
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00041294097900391
(289) DESCRIBE `ports` 0.0017290115356445
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00037908554077148
(291) DESCRIBE `ports` 0.0021350383758545
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00042510032653809
(293) DESCRIBE `ports` 0.0018210411071777
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00039100646972656
(295) DESCRIBE `ports` 0.0019989013671875
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00054192543029785
(297) DESCRIBE `ports` 0.0018680095672607
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00049114227294922
(299) DESCRIBE `ports` 0.0021929740905762
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 553))) 0.00053501129150391
(301) DESCRIBE `ports` 0.0026650428771973
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '553') 0.0004730224609375
(303) DESCRIBE `ports` 0.0018689632415771
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 553))) 0.00039815902709961
(305) DESCRIBE `ports` 0.0018990039825439
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00041413307189941
(307) DESCRIBE `ports` 0.0018439292907715
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00038599967956543
(309) DESCRIBE `ports` 0.0017919540405273
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00041294097900391
(311) DESCRIBE `ports` 0.0020508766174316
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00039219856262207
(313) DESCRIBE `ports` 0.0018858909606934
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00038290023803711
(315) DESCRIBE `ports` 0.0017240047454834
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00041007995605469
(317) DESCRIBE `ports` 0.0018229484558105
(318) DESCRIBE `ports` 0.0018630027770996
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00049686431884766
(320) DESCRIBE `ports` 0.0023500919342041
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00050187110900879
(322) DESCRIBE `ports` 0.0019021034240723
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00043082237243652
(324) DESCRIBE `ports` 0.0024459362030029
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00049400329589844
(326) DESCRIBE `ports` 0.0018031597137451
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00040388107299805
(328) DESCRIBE `ports` 0.0019850730895996
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00044488906860352
(330) DESCRIBE `cruises` 0.0047330856323242
(331) SELECT `cruises`.* FROM `cruises` WHERE (id IN (29119, 34150, 34161, 34188, 38147, 38149, 40591, 40596, 45258, 45258)) ORDER BY FIND_IN_SET(id, '29119,34150,34161,34188,38147,38149,40591,40596,45258,45258') 0.0025951862335205
(332) DESCRIBE `cruiselines` 0.0037059783935547
(333) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('77', '218', '19', '26', '171', '23', '144', '20', '12', '7', '18', '183', '101', '8', '31', '120', '131', '29', '96', '103', '15', '206', '91', '262', '33', '114', '24', '170', '14', '28', '156', '258', '191', '50', '195', '37', '153', '208', '16', '187', '49', '36', '88', '47', '251', '216', '151', '141', '212', '181', '4', '118', '110', '59', '140', '30', '147', '48', '261', '73', '213', '211', '276', '209', '115', '159', '264', '108', '82', '113', '57', '90', '95', '184', '244', '52', '180', '38', '64', '35', '105', '134', '257', '245')) ORDER BY FIND_IN_SET(id, '77,218,19,26,171,23,144,20,12,7,18,183,101,8,31,120,131,29,96,103,15,206,91,262,33,114,24,170,14,28,156,258,191,50,195,37,153,208,16,187,49,36,88,47,251,216,151,141,212,181,4,118,110,59,140,30,147,48,261,73,213,211,276,209,115,159,264,108,82,113,57,90,95,184,244,52,180,38,64,35,105,134,257,245') 0.0083818435668945
(334) DESCRIBE `ships` 0.0038611888885498
(335) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '732', '1744', '726', '258', '517', '1324', '780', '737', '1417', '1588', '1717', '855', '871', '207', '1794', '1766', '1291', '874', '977', '1572', '454', '1594', '404', '1359', '770', '1272', '1199', '22', '66', '330', '461', '21', '1032', '393', '738', '1134', '1424', '434', '974', '716', '28', '265', '553', '332', '1237', '1292', '1682', '333', '797', '1768', '521', '1348', '349', '1260', '1419', '1423', '1422', '1418', '1420', '1421', '1415', '766', '711', '715', '163', '792', '9', '455', '11', '407', '1678', '10', '25', '739', '439', '585', '674', '857', '858', '1132', '1501', '1677', '657', '3', '34', '542', '24', '36', '378', '1460', '31', '39', '520', '1008', '1721', '1852', '966', '1141', '1569', '1233', '385', '1607', '1742', '1822', '1505', '1811', '386', '1168', '1372', '1402', '1676', '1302', '35', '626', '837', '1012', '1455', '1773', '768', '850', '1373', '98', '1205', '113', '986', '1319', '817', '1602', '338', '451', '573', '882', '1282', '1413', '160', '1135', '1574', '1021', '1067', '1410', '1782', '352', '610', '1259', '1284', '1411', '1733', '285', '547', '1454', '37', '111', '63', '148', '1398', '30', '198', '314', '375', '1063', '1437', '508', '1145', '1193', '1722', '108', '627', '883', '1088', '1308', '286', '1808', '748', '1149', '38', '340', '406', '526', '970', '1320', '1323', '1579', '1711', '43', '1028', '124', '327', '485', '1108', '1325', '394', '854', '1068', '1586', '116', '348', '390', '582', '1492', '1810', '590', '1157', '1321', '1412', '1571', '1724', '1461', '1738', '1809', '119', '223', '616', '1208', '1575', '1672', '1801', '82', '462', '652', '944', '1853', '351', '791', '1027', '1587', '114', '147', '704', '678', '884', '1266', '1318', '1408', '1552', '1820', '4', '70', '75', '335', '503', '683', '78', '545', '658', '1139', '1486', '201', '325', '401', '441', '722', '958', '988', '1188', '1289', '1330', '81', '149', '162', '291', '601', '1772', '403', '790', '1326', '1327', '1771', '105', '287', '580', '776', '1073', '1367', '389', '423', '651', '1037', '1043', '1151', '1236', '1303', '1704', '1757', '69', '818', '1040', '1539', '123', '262', '341', '1013', '1019', '266', '405', '1172', '290', '483', '673', '796', '1223', '1526', '45', '480', '639', '1159', '1474', '1540', '1740', '84', '751', '1029', '1338', '1715', '1743', '1758', '795', '852', '1035', '1160', '1163', '1206', '1245', '1344', '1426', '1681', '635', '968', '972', '1146', '1150', '1217', '1226', '1229', '1452', '1453', '1573', '1604', '1716', '324', '417', '643', '709', '717', '1143', '1144', '1283', '1343', '1358', '1483', '1807', '1833', '574', '775', '851', '905', '1048', '1136', '1262', '1293', '1448', '1746', '1042', '1045', '1095', '1230', '1231', '1663', '1787', '467', '885', '1026', '1051', '1137', '1730', '1749', '1791', '1140', '1154', '1340', '1351', '1409', '1458', '1463', '1723', '1759', '1806', '663', '665', '954', '1224', '1366', '1368', '1459', '1609', '1632', '1673', '1751', '151', '559', '920', '973', '996', '1049', '1050', '1148', '1274', '1354', '1360', '1361', '1362', '1647', '1708', '1713', '1805', '448', '666', '914', '921', '923', '927', '1025', '1044', '1055', '1072', '1090', '1152', '1196', '1339', '1449', '1601', '1714', '1788', '1823', '212', '453', '886', '915', '916', '926', '930', '931', '1109', '1322', '1649', '1750', '1816', '1854', '208', '703', '769', '924', '1047', '1052', '1519', '1596', '1650', '150', '299', '300', '422', '740', '1004', '1020', '1036', '1039', '1054', '1225', '1352', '1451', '1580', '707', '937', '1294', '1389', '479', '487', '672', '888', '1071', '1256', '1301', '1329', '93', '205', '671', '821', '1232', '1445', '1664', '516', '644', '784', '1005', '1060', '1350', '1405', '1626', '1792', '1821')) ORDER BY FIND_IN_SET(id, '1761,732,1744,726,258,517,1324,780,737,1417,1588,1717,855,871,207,1794,1766,1291,874,977,1572,454,1594,404,1359,770,1272,1199,22,66,330,461,21,1032,393,738,1134,1424,434,974,716,28,265,553,332,1237,1292,1682,333,797,1768,521,1348,349,1260,1419,1423,1422,1418,1420,1421,1415,766,711,715,163,792,9,455,11,407,1678,10,25,739,439,585,674,857,858,1132,1501,1677,657,3,34,542,24,36,378,1460,31,39,520,1008,1721,1852,966,1141,1569,1233,385,1607,1742,1822,1505,1811,386,1168,1372,1402,1676,1302,35,626,837,1012,1455,1773,768,850,1373,98,1205,113,986,1319,817,1602,338,451,573,882,1282,1413,160,1135,1574,1021,1067,1410,1782,352,610,1259,1284,1411,1733,285,547,1454,37,111,63,148,1398,30,198,314,375,1063,1437,508,1145,1193,1722,108,627,883,1088,1308,286,1808,748,1149,38,340,406,526,970,1320,1323,1579,1711,43,1028,124,327,485,1108,1325,394,854,1068,1586,116,348,390,582,1492,1810,590,1157,1321,1412,1571,1724,1461,1738,1809,119,223,616,1208,1575,1672,1801,82,462,652,944,1853,351,791,1027,1587,114,147,704,678,884,1266,1318,1408,1552,1820,4,70,75,335,503,683,78,545,658,1139,1486,201,325,401,441,722,958,988,1188,1289,1330,81,149,162,291,601,1772,403,790,1326,1327,1771,105,287,580,776,1073,1367,389,423,651,1037,1043,1151,1236,1303,1704,1757,69,818,1040,1539,123,262,341,1013,1019,266,405,1172,290,483,673,796,1223,1526,45,480,639,1159,1474,1540,1740,84,751,1029,1338,1715,1743,1758,795,852,1035,1160,1163,1206,1245,1344,1426,1681,635,968,972,1146,1150,1217,1226,1229,1452,1453,1573,1604,1716,324,417,643,709,717,1143,1144,1283,1343,1358,1483,1807,1833,574,775,851,905,1048,1136,1262,1293,1448,1746,1042,1045,1095,1230,1231,1663,1787,467,885,1026,1051,1137,1730,1749,1791,1140,1154,1340,1351,1409,1458,1463,1723,1759,1806,663,665,954,1224,1366,1368,1459,1609,1632,1673,1751,151,559,920,973,996,1049,1050,1148,1274,1354,1360,1361,1362,1647,1708,1713,1805,448,666,914,921,923,927,1025,1044,1055,1072,1090,1152,1196,1339,1449,1601,1714,1788,1823,212,453,886,915,916,926,930,931,1109,1322,1649,1750,1816,1854,208,703,769,924,1047,1052,1519,1596,1650,150,299,300,422,740,1004,1020,1036,1039,1054,1225,1352,1451,1580,707,937,1294,1389,479,487,672,888,1071,1256,1301,1329,93,205,671,821,1232,1445,1664,516,644,784,1005,1060,1350,1405,1626,1792,1821') 0.075489044189453
(336) DESCRIBE `cruisetypes` 0.0023190975189209
(337) DESCRIBE `destinations` 0.0023868083953857
(338) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '25', '43', '37', '2', '9', '8', '44', '55', '39', '53', '26', '38', '28', '40', '30', '49', '11', '21', '7', '45', '29', '48', '52', '34', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,25,43,37,2,9,8,44,55,39,53,26,38,28,40,30,49,11,21,7,45,29,48,52,34,10,46,56,32') 0.0029501914978027