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 Miracle, Baja Mexico ex San Francisco Roundtrip

Select a sailing date:

Day Port Arrive Depart
Day 1 San Francisco, California, USA 04:00 PM
Day 2 At Sea
Day 3 San Diego, California, USA 08:00 AM 05:00 PM
Day 4 Ensenada, Mexico 08:00 AM 06:00 PM
Day 5 At Sea
Day 6 San Francisco, California, USA 08:00 AM

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

Total elapsed time: 0.39619755744934

# Query Time
(1) connect 0.0021109580993652
(2) DESCRIBE `cruises` 0.012439012527466
(3) SELECT `cruises`.* FROM `cruises` WHERE (orchid_slug = 'miracle-baja-mexico-ex-san-francisco-roundtrip') AND (orchid_available = 1) LIMIT 1 0.10677886009216
(4) DESCRIBE `avid_specials` 0.0028979778289795
(5) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81435 and class = 'Cruise') OR (item_id = 441 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 53 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.0023128986358643
(6) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81435') 0.0006718635559082
(7) DESCRIBE `ships` 0.0054299831390381
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 441))) 0.00086498260498047
(9) DESCRIBE `ships` 0.0055141448974609
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '441') 0.00070500373840332
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00051689147949219
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00049901008605957
(13) DESCRIBE `itineraries` 0.0027711391448975
(14) DESCRIBE `ports` 0.0030481815338135
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00069093704223633
(16) DESCRIBE `ports` 0.0028400421142578
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.0012049674987793
(18) DESCRIBE `ports` 0.0031201839447021
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00058507919311523
(20) DESCRIBE `sailingdates` 0.0023059844970703
(21) DESCRIBE `ports` 0.0039708614349365
(22) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00085210800170898
(23) DESCRIBE `ports` 0.0033969879150391
(24) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00087404251098633
(25) DESCRIBE `ports` 0.0033471584320068
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00083088874816895
(27) DESCRIBE `ports` 0.0029778480529785
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.0007929801940918
(29) DESCRIBE `ports` 0.0033211708068848
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 331))) 0.00083518028259277
(31) DESCRIBE `ports` 0.0029227733612061
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '331') 0.00078988075256348
(33) DESCRIBE `ports` 0.0026848316192627
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00070881843566895
(35) DESCRIBE `ports` 0.002918004989624
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00061488151550293
(37) DESCRIBE `cruiselines` 0.0040550231933594
(38) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00085687637329102
(39) DESCRIBE `orchid_image` 0.0034270286560059
(40) DESCRIBE `cruiselines` 0.0040419101715088
(41) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00061202049255371
(42) DESCRIBE `cabins` 0.0027830600738525
(43) DESCRIBE `deckplans` 0.002741813659668
(44) DESCRIBE `shipphotos` 0.0036399364471436
(45) DESCRIBE `ports` 0.0085020065307617
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00085592269897461
(47) DESCRIBE `ports` 0.0043389797210693
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.0010290145874023
(49) DESCRIBE `ports` 0.0030009746551514
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00082683563232422
(51) DESCRIBE `ports` 0.0029098987579346
(52) DESCRIBE `ports` 0.0028622150421143
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.0006561279296875
(54) DESCRIBE `ports` 0.0027229785919189
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '143') 0.0005638599395752
(56) DESCRIBE `ports` 0.0026910305023193
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 143))) 0.00063776969909668
(58) DESCRIBE `ports` 0.0030031204223633
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 331))) 0.00068497657775879
(60) DESCRIBE `ports` 0.0027661323547363
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '331') 0.00073003768920898
(62) DESCRIBE `ports` 0.0027868747711182
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 331))) 0.00082015991210938
(64) DESCRIBE `ports` 0.0036849975585938
(65) DESCRIBE `ports` 0.0032930374145508
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00095105171203613
(67) DESCRIBE `ports` 0.0027120113372803
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.0006251335144043
(69) DESCRIBE `ports` 0.0025749206542969
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00063419342041016
(71) DESCRIBE `cruises` 0.0063929557800293
(72) SELECT `cruises`.* FROM `cruises` WHERE (id IN (29613, 29952, 34157, 38147, 38149, 40591, 40596, 45258, 45258, 45260)) ORDER BY FIND_IN_SET(id, '29613,29952,34157,38147,38149,40591,40596,45258,45258,45260') 0.0024199485778809
(73) DESCRIBE `cruiselines` 0.0042350292205811
(74) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '171', '23', '144', '12', '20', '7', '183', '18', '101', '8', '120', '31', '131', '29', '96', '15', '103', '206', '91', '33', '262', '170', '114', '24', '28', '14', '156', '191', '50', '258', '195', '37', '153', '208', '16', '187', '49', '36', '47', '88', '251', '216', '151', '141', '212', '181', '4', '118', '110', '59', '30', '140', '73', '147', '115', '261', '48', '213', '159', '264', '276', '209', '211', '108', '113', '90', '57', '82', '184', '95', '38', '180', '52', '244', '105', '35', '64', '134', '257', '245', '172')) ORDER BY FIND_IN_SET(id, '218,77,19,26,171,23,144,12,20,7,183,18,101,8,120,31,131,29,96,15,103,206,91,33,262,170,114,24,28,14,156,191,50,258,195,37,153,208,16,187,49,36,47,88,251,216,151,141,212,181,4,118,110,59,30,140,73,147,115,261,48,213,159,264,276,209,211,108,113,90,57,82,184,95,38,180,52,244,105,35,64,134,257,245,172') 0.009965181350708
(75) DESCRIBE `ships` 0.0059480667114258
(76) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '732', '1744', '517', '726', '258', '737', '780', '1417', '1324', '855', '1588', '1717', '207', '1794', '1291', '871', '874', '977', '1594', '454', '1199', '1572', '1766', '404', '1359', '1272', '770', '22', '330', '461', '1032', '21', '393', '974', '66', '716', '1237', '28', '1292', '797', '1424', '434', '738', '1134', '1682', '553', '332', '521', '265', '1348', '333', '766', '1768', '349', '711', '1415', '1260', '1419', '1423', '585', '1422', '1418', '1420', '1421', '9', '715', '11', '792', '857', '858', '1501', '10', '1677', '163', '407', '439', '455', '739', '25', '1132', '1678', '34', '31', '36', '378', '674', '3', '24', '39', '657', '542', '1460', '520', '1008', '1721', '1205', '1141', '1607', '837', '1569', '385', '1067', '1742', '1302', '1852', '386', '966', '1402', '1773', '882', '1168', '1233', '1372', '113', '160', '1822', '35', '850', '1012', '1505', '1811', '338', '626', '768', '1454', '1455', '1574', '1676', '98', '1135', '1319', '1602', '573', '37', '1373', '63', '285', '451', '610', '1021', '30', '352', '986', '817', '1284', '1413', '1733', '547', '1259', '1282', '1398', '1411', '38', '1410', '1782', '111', '148', '314', '1193', '108', '375', '1088', '1722', '43', '286', '406', '503', '1437', '508', '627', '748', '1108', '198', '340', '526', '1063', '1308', '1320', '1323', '1579', '1711', '1808', '970', '1145', '883', '1325', '116', '124', '327', '485', '854', '1586', '348', '390', '582', '1149', '1738', '394', '590', '1571', '1028', '1208', '119', '1266', '1492', '335', '1068', '1575', '1724', '223', '944', '1412', '1552', '1672', '1810', '82', '616', '791', '1157', '1321', '1587', '75', '114', '652', '704', '1461', '1809', '70', '1801', '147', '351', '441', '462', '4', '480', '545', '658', '678', '1027', '1853', '683', '988', '1289', '78', '162', '201', '325', '601', '884', '69', '401', '403', '722', '1318', '1330', '1408', '1820', '105', '291', '405', '790', '958', '1245', '341', '1139', '1188', '1303', '1486', '149', '389', '776', '1236', '81', '123', '262', '287', '580', '818', '1073', '1772', '483', '651', '1326', '1327', '1539', '1704', '1771', '1037', '1159', '1367', '1526', '423', '673', '1013', '1043', '1151', '1540', '1757', '266', '796', '1019', '1040', '1172', '45', '290', '639', '968', '1463', '1474', '1573', '635', '1223', '1730', '1743', '84', '574', '751', '775', '795', '852', '1160', '1426', '1681', '1740', '1029', '1035', '1217', '1338', '1344', '1715', '1758', '324', '717', '1163', '1206', '1716', '709', '972', '1095', '1143', '1144', '1146', '1150', '1226', '1229', '1283', '1343', '1358', '1409', '1452', '1453', '1604', '1663', '417', '643', '1483', '1807', '1833', '151', '665', '851', '905', '1048', '1136', '1262', '1293', '1448', '1673', '1746', '212', '885', '1042', '1045', '1230', '1231', '1449', '1787', '467', '644', '1026', '1051', '1137', '1152', '1351', '1405', '1647', '1749', '1791', '769', '1109', '1140', '1154', '1340', '1458', '1723', '1759', '1806', '150', '453', '663', '954', '1025', '1090', '1224', '1366', '1368', '1459', '1609', '1632', '1751', '1816', '208', '448', '559', '701', '920', '973', '996', '1049', '1050', '1148', '1274', '1329', '1354', '1360', '1361', '1362', '1519', '1601', '1649', '1708', '1713', '1805', '666', '740', '914', '921', '923', '927', '1044', '1055', '1072', '1196', '1322', '1339', '1714', '1750', '1788', '1823', '707', '886', '915', '916', '926', '930', '931', '1071', '1294', '1580', '1854', '703', '924', '1047', '1052', '1389', '1596', '1650', '93', '299', '300', '422', '1004', '1020', '1036', '1039', '1054', '1225', '1350', '1352', '1451', '1599', '1664', '205', '253', '479', '784', '937', '487', '672', '888', '965', '1256', '1301', '1626', '1674', '1679', '14', '671', '821')) ORDER BY FIND_IN_SET(id, '1761,732,1744,517,726,258,737,780,1417,1324,855,1588,1717,207,1794,1291,871,874,977,1594,454,1199,1572,1766,404,1359,1272,770,22,330,461,1032,21,393,974,66,716,1237,28,1292,797,1424,434,738,1134,1682,553,332,521,265,1348,333,766,1768,349,711,1415,1260,1419,1423,585,1422,1418,1420,1421,9,715,11,792,857,858,1501,10,1677,163,407,439,455,739,25,1132,1678,34,31,36,378,674,3,24,39,657,542,1460,520,1008,1721,1205,1141,1607,837,1569,385,1067,1742,1302,1852,386,966,1402,1773,882,1168,1233,1372,113,160,1822,35,850,1012,1505,1811,338,626,768,1454,1455,1574,1676,98,1135,1319,1602,573,37,1373,63,285,451,610,1021,30,352,986,817,1284,1413,1733,547,1259,1282,1398,1411,38,1410,1782,111,148,314,1193,108,375,1088,1722,43,286,406,503,1437,508,627,748,1108,198,340,526,1063,1308,1320,1323,1579,1711,1808,970,1145,883,1325,116,124,327,485,854,1586,348,390,582,1149,1738,394,590,1571,1028,1208,119,1266,1492,335,1068,1575,1724,223,944,1412,1552,1672,1810,82,616,791,1157,1321,1587,75,114,652,704,1461,1809,70,1801,147,351,441,462,4,480,545,658,678,1027,1853,683,988,1289,78,162,201,325,601,884,69,401,403,722,1318,1330,1408,1820,105,291,405,790,958,1245,341,1139,1188,1303,1486,149,389,776,1236,81,123,262,287,580,818,1073,1772,483,651,1326,1327,1539,1704,1771,1037,1159,1367,1526,423,673,1013,1043,1151,1540,1757,266,796,1019,1040,1172,45,290,639,968,1463,1474,1573,635,1223,1730,1743,84,574,751,775,795,852,1160,1426,1681,1740,1029,1035,1217,1338,1344,1715,1758,324,717,1163,1206,1716,709,972,1095,1143,1144,1146,1150,1226,1229,1283,1343,1358,1409,1452,1453,1604,1663,417,643,1483,1807,1833,151,665,851,905,1048,1136,1262,1293,1448,1673,1746,212,885,1042,1045,1230,1231,1449,1787,467,644,1026,1051,1137,1152,1351,1405,1647,1749,1791,769,1109,1140,1154,1340,1458,1723,1759,1806,150,453,663,954,1025,1090,1224,1366,1368,1459,1609,1632,1751,1816,208,448,559,701,920,973,996,1049,1050,1148,1274,1329,1354,1360,1361,1362,1519,1601,1649,1708,1713,1805,666,740,914,921,923,927,1044,1055,1072,1196,1322,1339,1714,1750,1788,1823,707,886,915,916,926,930,931,1071,1294,1580,1854,703,924,1047,1052,1389,1596,1650,93,299,300,422,1004,1020,1036,1039,1054,1225,1350,1352,1451,1599,1664,205,253,479,784,937,487,672,888,965,1256,1301,1626,1674,1679,14,671,821') 0.088629961013794
(77) DESCRIBE `cruisetypes` 0.0029308795928955
(78) DESCRIBE `destinations` 0.0037059783935547
(79) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '43', '25', '37', '9', '2', '8', '44', '55', '53', '39', '40', '26', '38', '28', '30', '7', '49', '11', '45', '21', '48', '29', '52', '34', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,43,25,37,9,2,8,44,55,53,39,40,26,38,28,30,7,49,11,45,21,48,29,52,34,10,46,56,32') 0.0038011074066162