10 Night Alaskan Fun Cruise from San Francisco Return

Sail to Alaska and witness amazing scenery, and fascinating destinations filled with unique culture and wildlife

Miracle, Alaska Cruise ex San Francisco Return

Nights	10	Ship	Carnival Miracle
Star Rating		Departs	San Francisco, California, USA

Sailing	2020: 30 Jul
Ports of Call	San Francisco, Juneau, Skagway, Sitka, Tracy Arm Fjord, Victoria

Special Pricing SpecialsPrice (Cabins)

Sailing Dates

Select a cabin to get pricing. Pricing is approximate.

NZ $2,219

Miracle, Alaska Cruise ex San Francisco Return

Download Flyer »

Carnival Miracle

Valid: 4 Dec 2019 - 15 Jan 2020

10-Night cruise and accommodation onboard Carnival Miracle
All meals in main dining venues included during your cruise
Entertainment and activities while cruising
Supervised children's club
Many bars throughout the ship
Adults only area
Splash zone and Water Park with hydroslides
Port taxes and government fees

Special Conditions

Cruise costs are in New Zealand Dollars (NZD). Offer subject to availability at time of booking. Prices are per person share twin based on best available cruise fare, inclusive of all discounts unless otherwise stated. Subject to availability and currency fluctuations. All fares and taxes are subject to change without notice up until full payment is received. Itinerary may be subject to change. Credit card payments will incur a fee. Cruise deposit, amendment and cancellation conditions apply. Travel agent service fees may apply. Special conditions apply - please ask for full details at time of enquiry. Cruise Line reserves the right to re-instate the fuel supplement for all guests up to US$9 per person per day if the price of light sweet crude on the New York Mercantile Exchange (NYMEX) exceeds US$70 per barrel. Please consult cruise line website for current information.

#	Query	Time
(1)	connect	0.0010690689086914
(2)	DESCRIBE `specials`	0.0068869590759277
(3)	SELECT `specials`.* FROM `specials` WHERE (orchid_slug = '10-night-alaskan-fun-cruise-from-san-francisco-return-1608124') AND (orchid_available = 1) LIMIT 1	0.0015058517456055
(4)	DESCRIBE `cruises`	0.0035400390625
(5)	SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 81448)))	0.00052809715270996
(6)	DESCRIBE `avid_specials`	0.0016090869903564
(7)	SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1608124 and class = 'Special') OR (item_id = 81448 and class = 'Cruise') OR (item_id = 441 AND class = 'Ship') OR (item_id = 218 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.0011780261993408
(8)	SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1608124')	0.00036215782165527
(9)	DESCRIBE `ships`	0.0036048889160156
(10)	SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 441)))	0.00046181678771973
(11)	DESCRIBE `ships`	0.0034651756286621
(12)	SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '441')	0.0004270076751709
(13)	SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4')	0.00034999847412109
(14)	SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4')	0.00033903121948242
(15)	DESCRIBE `itineraries`	0.0019638538360596
(16)	DESCRIBE `ports`	0.0022001266479492
(17)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142)))	0.00048422813415527
(18)	DESCRIBE `ports`	0.0019209384918213
(19)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142)))	0.00045609474182129
(20)	DESCRIBE `ports`	0.0022289752960205
(21)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142')	0.00038385391235352
(22)	DESCRIBE `specialsailingdates`	0.0015699863433838
(23)	DESCRIBE `sailingdates`	0.0015580654144287
(24)	SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 512616)))	0.00044608116149902
(25)	DESCRIBE `ports`	0.0019149780273438
(26)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142)))	0.00042891502380371
(27)	DESCRIBE `ports`	0.0019938945770264
(28)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142')	0.00037789344787598
(29)	DESCRIBE `ports`	0.0018339157104492
(30)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28)))	0.00040793418884277
(31)	DESCRIBE `ports`	0.0018150806427002
(32)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28')	0.00037312507629395
(33)	DESCRIBE `ports`	0.0018079280853271
(34)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32)))	0.00052714347839355
(35)	DESCRIBE `ports`	0.0019209384918213
(36)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32')	0.00038695335388184
(37)	DESCRIBE `ports`	0.0019669532775879
(38)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29)))	0.0026741027832031
(39)	DESCRIBE `ports`	0.0022580623626709
(40)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29')	0.00040698051452637
(41)	DESCRIBE `ports`	0.0020849704742432
(42)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 58)))	0.00044608116149902
(43)	DESCRIBE `ports`	0.0019018650054932
(44)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '58')	0.00040698051452637
(45)	DESCRIBE `ports`	0.0021500587463379
(46)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112)))	0.00049591064453125
(47)	DESCRIBE `ports`	0.0020570755004883
(48)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112')	0.00040912628173828
(49)	DESCRIBE `ports`	0.0025179386138916
(50)	SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142)))	0.00053596496582031
(51)	DESCRIBE `ports`	0.0019059181213379
(52)	SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142')	0.00039005279541016
(53)	DESCRIBE `specialsmultipricing`	0.0019228458404541
(54)	DESCRIBE `leadpricing`	0.0017340183258057
(55)	DESCRIBE `specialspricing`	0.0019278526306152
(56)	DESCRIBE `cabins`	0.0018811225891113
(57)	SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 2630)))	0.00045990943908691
(58)	DESCRIBE `currencies`	0.0014939308166504
(59)	SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6)))	0.00047397613525391
(60)	DESCRIBE `cruiselines`	0.0034010410308838
(61)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218)))	0.00049996376037598
(62)	DESCRIBE `orchid_image`	0.002169132232666
(63)	DESCRIBE `cruiselines`	0.0029621124267578
(64)	SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218')	0.00052404403686523
(65)	DESCRIBE `cruises`	0.0035679340362549
(66)	SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81448')	0.00053215026855469
(67)	DESCRIBE `deckplans`	0.0018250942230225
(68)	DESCRIBE `cabins`	0.0025961399078369
(69)	DESCRIBE `shipphotos`	0.0020740032196045
(70)	DESCRIBE `cruiselines`	0.0026919841766357
(71)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218)))	0.00067019462585449
(72)	DESCRIBE `orchid_image`	0.0026280879974365
(73)	DESCRIBE `cruiselines`	0.0024468898773193
(74)	SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218')	0.00049209594726562
(75)	DESCRIBE `cruises`	0.0036728382110596
(76)	SELECT `cruises`.* FROM `cruises` WHERE (id IN (45259, 4425, 6056, 45258, 76235, 4424, 81017, 78347, 37234, 80905)) ORDER BY FIND_IN_SET(id, '45259,4425,6056,45258,76235,4424,81017,78347,37234,80905')	0.0013959407806396
(77)	DESCRIBE `cruiselines`	0.003180980682373
(78)	SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('23', '216', '47', '20', '191', '33', '8', '14', '26', '151', '19', '91', '101', '114', '15', '24', '29', '37', '96', '18')) ORDER BY FIND_IN_SET(id, '23,216,47,20,191,33,8,14,26,151,19,91,101,114,15,24,29,37,96,18')	0.0019481182098389
(79)	DESCRIBE `ships`	0.0038530826568604
(80)	SELECT `ships`.* FROM `ships` WHERE (id IN ('855', '517', '1808', '66', '1282', '338', '780', '148', '652', '683', '776', '1021', '1746', '1766', '124', '290', '332', '404', '448', '542', '616', '966', '1088', '1159', '1193', '1321', '1409', '1672', '75', '160', '163', '286', '287', '291', '349', '406', '434', '573', '580', '585', '766', '1028', '1318', '1319', '1330', '1359', '1402', '1539', '1569', '1771', '45', '98', '105', '149', '253', '262', '285', '341', '389', '394', '422', '508', '547', '553', '559', '665', '674', '678', '726', '738', '748', '768', '770', '907', '968', '1029', '1073', '1108', '1135', '1157', '1262', '1283', '1415', '1587', '1682', '1721', '1758')) ORDER BY FIND_IN_SET(id, '855,517,1808,66,1282,338,780,148,652,683,776,1021,1746,1766,124,290,332,404,448,542,616,966,1088,1159,1193,1321,1409,1672,75,160,163,286,287,291,349,406,434,573,580,585,766,1028,1318,1319,1330,1359,1402,1539,1569,1771,45,98,105,149,253,262,285,341,389,394,422,508,547,553,559,665,674,678,726,738,748,768,770,907,968,1029,1073,1108,1135,1157,1262,1283,1415,1587,1682,1721,1758')	0.0140540599823
(81)	DESCRIBE `cruisetypes`	0.0019769668579102
(82)	DESCRIBE `destinations`	0.0024759769439697
(83)	SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '22', '35', '2', '54', '50', '26', '8', '12', '25', '48', '49', '29', '53', '40', '11', '28', '37')) ORDER BY FIND_IN_SET(id, '43,22,35,2,54,50,26,8,12,25,48,49,29,53,40,11,28,37')	0.002187967300415

Query

Time

(1)

connect

0.0010690689086914

(2)

DESCRIBE `specials`

0.0068869590759277

(3)

SELECT `specials`.* FROM `specials` WHERE (orchid_slug = '10-night-alaskan-fun-cruise-from-san-francisco-return-1608124') AND (orchid_available = 1) LIMIT 1

0.0015058517456055

(4)

DESCRIBE `cruises`

0.0035400390625

(5)

SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 81448)))

0.00052809715270996

(6)

DESCRIBE `avid_specials`

0.0016090869903564

(7)

SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1608124 and class = 'Special') OR (item_id = 81448 and class = 'Cruise') OR (item_id = 441 AND class = 'Ship') OR (item_id = 218 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.0011780261993408

(8)

SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1608124')

0.00036215782165527

(9)

DESCRIBE `ships`

0.0036048889160156

(10)

SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 441)))

0.00046181678771973

(11)

DESCRIBE `ships`

0.0034651756286621

(12)

SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '441')

0.0004270076751709

(13)

SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4')

0.00034999847412109

(14)

SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4')

0.00033903121948242

(15)

DESCRIBE `itineraries`

0.0019638538360596

(16)

DESCRIBE `ports`

0.0022001266479492

(17)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142)))

0.00048422813415527

(18)

DESCRIBE `ports`

0.0019209384918213

(19)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142)))

0.00045609474182129

(20)

DESCRIBE `ports`

0.0022289752960205

(21)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142')

0.00038385391235352

(22)

DESCRIBE `specialsailingdates`

0.0015699863433838

(23)

DESCRIBE `sailingdates`

0.0015580654144287

(24)

SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 512616)))

0.00044608116149902

(25)

DESCRIBE `ports`

0.0019149780273438

(26)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142)))

0.00042891502380371

(27)

DESCRIBE `ports`

0.0019938945770264

(28)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142')

0.00037789344787598

(29)

DESCRIBE `ports`

0.0018339157104492

(30)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28)))

0.00040793418884277

(31)

DESCRIBE `ports`

0.0018150806427002

(32)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28')

0.00037312507629395

(33)

DESCRIBE `ports`

0.0018079280853271

(34)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32)))

0.00052714347839355

(35)

DESCRIBE `ports`

0.0019209384918213

(36)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32')

0.00038695335388184

(37)

DESCRIBE `ports`

0.0019669532775879

(38)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29)))

0.0026741027832031

(39)

DESCRIBE `ports`

0.0022580623626709

(40)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29')

0.00040698051452637

(41)

DESCRIBE `ports`

0.0020849704742432

(42)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 58)))

0.00044608116149902

(43)

DESCRIBE `ports`

0.0019018650054932

(44)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '58')

0.00040698051452637

(45)

DESCRIBE `ports`

0.0021500587463379

(46)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112)))

0.00049591064453125

(47)

DESCRIBE `ports`

0.0020570755004883

(48)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112')

0.00040912628173828

(49)

DESCRIBE `ports`

0.0025179386138916

(50)

SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142)))

0.00053596496582031

(51)

DESCRIBE `ports`

0.0019059181213379

(52)

SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142')

0.00039005279541016

(53)

DESCRIBE `specialsmultipricing`

0.0019228458404541

(54)

DESCRIBE `leadpricing`

0.0017340183258057

(55)

DESCRIBE `specialspricing`

0.0019278526306152

(56)

DESCRIBE `cabins`

0.0018811225891113

(57)

SELECT `cabins`.* FROM `cabins` WHERE (((`cabins`.`id` = 2630)))

0.00045990943908691

(58)

DESCRIBE `currencies`

0.0014939308166504

(59)

SELECT `currencies`.* FROM `currencies` WHERE (((`currencies`.`id` = 6)))

0.00047397613525391

(60)

DESCRIBE `cruiselines`

0.0034010410308838

(61)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218)))

0.00049996376037598

(62)

DESCRIBE `orchid_image`

0.002169132232666

(63)

DESCRIBE `cruiselines`

0.0029621124267578

(64)

SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218')

0.00052404403686523

(65)

DESCRIBE `cruises`

0.0035679340362549

(66)

SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81448')

0.00053215026855469

(67)

DESCRIBE `deckplans`

0.0018250942230225

(68)

DESCRIBE `cabins`

0.0025961399078369

(69)

DESCRIBE `shipphotos`

0.0020740032196045

(70)

DESCRIBE `cruiselines`

0.0026919841766357

(71)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218)))

0.00067019462585449

(72)

DESCRIBE `orchid_image`

0.0026280879974365

(73)

DESCRIBE `cruiselines`

0.0024468898773193

(74)

SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218')

0.00049209594726562

(75)

DESCRIBE `cruises`

0.0036728382110596

(76)

SELECT `cruises`.* FROM `cruises` WHERE (id IN (45259, 4425, 6056, 45258, 76235, 4424, 81017, 78347, 37234, 80905)) ORDER BY FIND_IN_SET(id, '45259,4425,6056,45258,76235,4424,81017,78347,37234,80905')

0.0013959407806396

(77)

DESCRIBE `cruiselines`

0.003180980682373

(78)

SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('23', '216', '47', '20', '191', '33', '8', '14', '26', '151', '19', '91', '101', '114', '15', '24', '29', '37', '96', '18')) ORDER BY FIND_IN_SET(id, '23,216,47,20,191,33,8,14,26,151,19,91,101,114,15,24,29,37,96,18')

0.0019481182098389

(79)

DESCRIBE `ships`

0.0038530826568604

(80)

SELECT `ships`.* FROM `ships` WHERE (id IN ('855', '517', '1808', '66', '1282', '338', '780', '148', '652', '683', '776', '1021', '1746', '1766', '124', '290', '332', '404', '448', '542', '616', '966', '1088', '1159', '1193', '1321', '1409', '1672', '75', '160', '163', '286', '287', '291', '349', '406', '434', '573', '580', '585', '766', '1028', '1318', '1319', '1330', '1359', '1402', '1539', '1569', '1771', '45', '98', '105', '149', '253', '262', '285', '341', '389', '394', '422', '508', '547', '553', '559', '665', '674', '678', '726', '738', '748', '768', '770', '907', '968', '1029', '1073', '1108', '1135', '1157', '1262', '1283', '1415', '1587', '1682', '1721', '1758')) ORDER BY FIND_IN_SET(id, '855,517,1808,66,1282,338,780,148,652,683,776,1021,1746,1766,124,290,332,404,448,542,616,966,1088,1159,1193,1321,1409,1672,75,160,163,286,287,291,349,406,434,573,580,585,766,1028,1318,1319,1330,1359,1402,1539,1569,1771,45,98,105,149,253,262,285,341,389,394,422,508,547,553,559,665,674,678,726,738,748,768,770,907,968,1029,1073,1108,1135,1157,1262,1283,1415,1587,1682,1721,1758')

0.0140540599823

(81)

DESCRIBE `cruisetypes`

0.0019769668579102

(82)

DESCRIBE `destinations`

0.0024759769439697

(83)

SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '22', '35', '2', '54', '50', '26', '8', '12', '25', '48', '49', '29', '53', '40', '11', '28', '37')) ORDER BY FIND_IN_SET(id, '43,22,35,2,54,50,26,8,12,25,48,49,29,53,40,11,28,37')

0.002187967300415

My Favourite Cruises