or, enquire about your chosen options

  1. Should I buy a beverage package?
  2. SPOTLIGHT ON: Viking Ocean and River Cruises
  3. Catch Up on Cruising: Latest News in bite size!
  4. Catch Up on Cruising: Latest News in bite size!
  5. REVIEW: P & O Australia’s Pacific Aria

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

 
  • Pacific Explorer, Discover Vanuatu ex Sydney Return

    Nights 10 Ship Pacific Explorer
    Star Rating 3 Star Departs Sydney, NSW, Australia
    Sailing 2018: 23 Jul, 24 Sep, 8 Oct 2019: 11 Feb
    Ports of Call Sydney, Noumea, Lifou, Port Vila Vanuatu, Mystery Island, Isle of Pines

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

     
    P & O 'SHIP YEAH' SALE!! $1 Deposit + FREE Room Upgrade on SELECTED cruises + a Past Guest Exclusive Offer
  • Pacific Eden, Classic Cruise ex Sydney to Cairns

    Nights 4 Ship Pacific Eden
    Star Rating 3 Star Departs Sydney, NSW, Australia
    Sailing 2018: 23 Jul
    Ports of Call Sydney, Hamilton Island, Cairns
    Please enquire about this cruise for pricing.
     
    P & O 'SHIP YEAH' SALE!! $1 Deposit + FREE Room Upgrade on SELECTED cruises + a Past Guest Exclusive Offer
  • Pacific Jewel, Tongan Discovery ex Auckland Return

    Nights 10 Ship Pacific Jewel
    Star Rating 3 Star Departs Auckland, New Zealand
    Sailing 2018: 24 Jul 2019: 30 Apr
    Ports of Call Auckland, Suva Fiji, Port Denarau (Nadi), Vavau, Nuku'alofa

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

     
    P & O 'SHIP YEAH' SALE!! $1 Deposit + FREE Room Upgrade on SELECTED cruises + a Past Guest Exclusive Offer
  • Pacific Eden, New Guinea Islands ex Cairns Return

    Nights 7 Ship Pacific Eden
    Star Rating 3 Star Departs Cairns, Queensland, Australia
    Sailing 2018: 27 Jul, 17 Aug
    Ports of Call Cairns, Alotau, Kitava Island, Kiriwina Island, Conflict Islands

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

     
    P & O 'SHIP YEAH' SALE!! $1 Deposit + FREE Room Upgrade on SELECTED cruises + a Past Guest Exclusive Offer
  • Pacific Dawn, Food & Wine Cruise ex Brisbane Return

    Nights 3 Ship Pacific Dawn
    Star Rating 4 Star Departs Brisbane, QLD, Australia
    Sailing 2018: 28 Jul, 20 Oct 2019: 1 Jun 2020: 29 Feb
    Ports of Call Brisbane

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

     
    P & O 'SHIP YEAH' SALE!! $1 Deposit + FREE Room Upgrade on SELECTED cruises + a Past Guest Exclusive Offer
  • Pacific Dawn, Whitsundays (Airlie Beach) ex Brisbane Roundtrip

    Nights 4 Ship Pacific Dawn
    Star Rating 4 Star Departs Brisbane, QLD, Australia
    Sailing 2018: 31 Jul, 11 Sep, 2 Oct, 23 Oct, 13 Nov, 4 Dec 2019: 8 Jan, 12 Feb, 26 Feb, 12 Mar, 19 Mar, 9 Apr, 7 May, 4 Jun, 9 Jun, 1 Oct, 22 Oct, 12 Nov, 10 Dec 2020: 7 Jan, 4 Feb, 18 Feb, 3 Mar, 24 Mar
    Ports of Call Brisbane, Airlie Beach

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

     
    P & O 'SHIP YEAH' SALE!! $1 Deposit + FREE Room Upgrade on SELECTED cruises + a Past Guest Exclusive Offer
  • Pacific Explorer, Southern Barrier Reef Discovery ex Sydney Return

    Nights 7 Ship Pacific Explorer
    Star Rating 3 Star Departs Sydney, NSW, Australia
    Sailing 2018: 2 Aug 2019: 25 Feb, 1 Jun, 1 Aug 2020: 16 Mar
    Ports of Call Sydney, Mooloolaba (Noosa), Gladstone, Moreton Island

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

     
    P & O 'SHIP YEAH' SALE!! $1 Deposit + FREE Room Upgrade on SELECTED cruises + a Past Guest Exclusive Offer
  • Pacific Eden, Conflict Islands ex Cairns Return

    Nights 4 Ship Pacific Eden
    Star Rating 3 Star Departs Cairns, Queensland, Australia
    Sailing 2018: 3 Aug
    Ports of Call Cairns, Conflict Islands

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

     
    P & O 'SHIP YEAH' SALE!! $1 Deposit + FREE Room Upgrade on SELECTED cruises + a Past Guest Exclusive Offer
  • Pacific Jewel, Comedy Cruise ex Auckland Return

    Nights 3 Ship Pacific Jewel
    Star Rating 3 Star Departs Auckland, New Zealand
    Sailing 2018: 3 Aug 2019: 6 Apr
    Ports of Call Auckland

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

     
    P & O 'SHIP YEAH' SALE!! $1 Deposit + FREE Room Upgrade on SELECTED cruises + a Past Guest Exclusive Offer
  • Pacific Dawn, Pacific Island Hopper ex Brisbane Roundtrip

    Nights 7 Ship Pacific Dawn
    Star Rating 4 Star Departs Brisbane, QLD, Australia
    Sailing 2018: 4 Aug, 25 Aug, 1 Sep, 15 Sep, 22 Sep, 13 Oct, 27 Oct, 17 Nov, 24 Nov, 8 Dec 2019: 12 Jan, 26 Jan, 2 Feb, 16 Feb, 23 Mar, 30 Mar, 13 Apr, 27 Apr, 11 May, 25 May, 8 Jun, 22 Jun, 29 Jun, 20 Jul, 3 Aug, 31 Aug, 14 Sep, 21 Sep, 26 Oct, 23 Nov 2020: 18 Jan, 25 Jan, 8 Feb, 22 Feb, 7 Mar, 14 Mar, 28 Mar, 4 Apr, 11 Apr
    Ports of Call Brisbane, Noumea, Lifou, Port Vila Vanuatu

    Select a sailing date for approximate pricing.

    Prices are per person, twin share. When booking please check current cruise fare and inclusions. Prices are indicative only, subject to currency fluctuations and may change at any time without notice.

     
    P & O 'SHIP YEAH' SALE!! $1 Deposit + FREE Room Upgrade on SELECTED cruises + a Past Guest Exclusive Offer
 

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

Total elapsed time: 0.51175427436829

# Query Time
(1) connect 0.00093698501586914
(2) DESCRIBE `cruises` 0.0044028759002686
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (67247, 67215, 62573, 67221, 29065, 62566, 62158, 67222, 62578, 64368)) ORDER BY FIND_IN_SET(id, '67247,67215,62573,67221,29065,62566,62158,67222,62578,64368') 0.0016119480133057
(4) DESCRIBE `cruises` 0.0040891170501709
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67247') 0.00061297416687012
(6) DESCRIBE `ships` 0.0031628608703613
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00048613548278809
(8) DESCRIBE `ships` 0.0027761459350586
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00048589706420898
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026297569274902
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0002739429473877
(12) DESCRIBE `itineraries` 0.0015501976013184
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67247') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00087904930114746
(14) DESCRIBE `ports` 0.0015358924865723
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004279613494873
(16) DESCRIBE `ports` 0.0017759799957275
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042486190795898
(18) DESCRIBE `ports` 0.0016260147094727
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030994415283203
(20) DESCRIBE `sailingdates` 0.0011539459228516
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67247') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00079703330993652
(22) DESCRIBE `ports` 0.0015149116516113
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038695335388184
(24) DESCRIBE `ports` 0.0013790130615234
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029087066650391
(26) DESCRIBE `ports` 0.0013480186462402
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00031495094299316
(28) DESCRIBE `ports` 0.0016109943389893
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00036287307739258
(30) DESCRIBE `ports` 0.0016849040985107
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00036311149597168
(32) DESCRIBE `ports` 0.0017490386962891
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00036406517028809
(34) DESCRIBE `ports` 0.0017099380493164
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.0003969669342041
(36) DESCRIBE `ports` 0.0015628337860107
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00039505958557129
(38) DESCRIBE `ports` 0.0016059875488281
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00038290023803711
(40) DESCRIBE `ports` 0.0017480850219727
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00035810470581055
(42) DESCRIBE `ports` 0.0016820430755615
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.0003969669342041
(44) DESCRIBE `ports` 0.0015630722045898
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00035905838012695
(46) DESCRIBE `ports` 0.0016920566558838
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041818618774414
(48) DESCRIBE `ports` 0.001662015914917
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029397010803223
(50) DESCRIBE `avid_specials` 0.0013959407806396
(51) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67247 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 43 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.0018081665039062
(52) DESCRIBE `cruiselines` 0.0026600360870361
(53) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00036287307739258
(54) DESCRIBE `orchid_image` 0.0017399787902832
(55) DESCRIBE `cruiselines` 0.0021359920501709
(56) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00030899047851562
(57) DESCRIBE `cruises` 0.0037448406219482
(58) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67215') 0.0003509521484375
(59) DESCRIBE `ships` 0.002626895904541
(60) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1285))) 0.00037407875061035
(61) DESCRIBE `ships` 0.0025718212127686
(62) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1285') 0.00030303001403809
(63) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0002601146697998
(64) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00028491020202637
(65) DESCRIBE `itineraries` 0.00130295753479
(66) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67215') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0005488395690918
(67) DESCRIBE `ports` 0.0017521381378174
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040102005004883
(69) DESCRIBE `ports` 0.0012660026550293
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031709671020508
(71) DESCRIBE `ports` 0.0013358592987061
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031590461730957
(73) DESCRIBE `sailingdates` 0.001183032989502
(74) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67215') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0004730224609375
(75) DESCRIBE `ports` 0.0014340877532959
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036191940307617
(77) DESCRIBE `ports` 0.0014188289642334
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00035595893859863
(79) DESCRIBE `ports` 0.001410961151123
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 499))) 0.00036382675170898
(81) DESCRIBE `ports` 0.0013809204101562
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '499') 0.00026988983154297
(83) DESCRIBE `ports` 0.0012669563293457
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00031399726867676
(85) DESCRIBE `ports` 0.0013289451599121
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00026607513427734
(87) DESCRIBE `avid_specials` 0.0011410713195801
(88) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67215 and class = 'Cruise') OR (item_id = 1285 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0010440349578857
(89) DESCRIBE `cruiselines` 0.0018520355224609
(90) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00030922889709473
(91) DESCRIBE `orchid_image` 0.0014009475708008
(92) DESCRIBE `cruiselines` 0.001863956451416
(93) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00034213066101074
(94) DESCRIBE `cruises` 0.0030839443206787
(95) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62573') 0.00035190582275391
(96) DESCRIBE `ships` 0.0030741691589355
(97) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 765))) 0.00043487548828125
(98) DESCRIBE `ships` 0.003180980682373
(99) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '765') 0.00049901008605957
(100) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026583671569824
(101) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00025200843811035
(102) DESCRIBE `itineraries` 0.0014200210571289
(103) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62573') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00060796737670898
(104) DESCRIBE `ports` 0.0018651485443115
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00041794776916504
(106) DESCRIBE `ports` 0.0017180442810059
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00050592422485352
(108) DESCRIBE `ports` 0.001600980758667
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00036191940307617
(110) DESCRIBE `sailingdates` 0.0015010833740234
(111) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62573') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00077295303344727
(112) DESCRIBE `ports` 0.0017361640930176
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00038290023803711
(114) DESCRIBE `ports` 0.0013110637664795
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00031208992004395
(116) DESCRIBE `ports` 0.0015552043914795
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00041699409484863
(118) DESCRIBE `ports` 0.0017359256744385
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00044989585876465
(120) DESCRIBE `ports` 0.0016090869903564
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00030708312988281
(122) DESCRIBE `ports` 0.0013179779052734
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.0002739429473877
(124) DESCRIBE `ports` 0.0012879371643066
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1044))) 0.00034689903259277
(126) DESCRIBE `ports` 0.0012500286102295
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1044') 0.00026392936706543
(128) DESCRIBE `ports` 0.0012459754943848
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 419))) 0.00033807754516602
(130) DESCRIBE `ports` 0.0012538433074951
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '419') 0.0002739429473877
(132) DESCRIBE `ports` 0.0013899803161621
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00029397010803223
(134) DESCRIBE `ports` 0.0013041496276855
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0002739429473877
(136) DESCRIBE `avid_specials` 0.001121997833252
(137) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62573 and class = 'Cruise') OR (item_id = 765 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 43 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.0010578632354736
(138) DESCRIBE `cruiselines` 0.0018579959869385
(139) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00031805038452148
(140) DESCRIBE `orchid_image` 0.0014009475708008
(141) DESCRIBE `cruiselines` 0.0017960071563721
(142) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00029492378234863
(143) DESCRIBE `cruises` 0.0026028156280518
(144) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67221') 0.00032186508178711
(145) DESCRIBE `ships` 0.0026190280914307
(146) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1285))) 0.0004119873046875
(147) DESCRIBE `ships` 0.0025169849395752
(148) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1285') 0.0002741813659668
(149) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026512145996094
(150) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00025796890258789
(151) DESCRIBE `itineraries` 0.0012660026550293
(152) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67221') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00045299530029297
(153) DESCRIBE `ports` 0.0013420581817627
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00032186508178711
(155) DESCRIBE `ports` 0.0012960433959961
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.0003199577331543
(157) DESCRIBE `ports` 0.0014078617095947
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00028085708618164
(159) DESCRIBE `sailingdates` 0.0011320114135742
(160) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67221') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00048494338989258
(161) DESCRIBE `ports` 0.0013458728790283
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00037002563476562
(163) DESCRIBE `ports` 0.0013771057128906
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00029587745666504
(165) DESCRIBE `ports` 0.0012898445129395
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.00031113624572754
(167) DESCRIBE `ports` 0.0013909339904785
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.0003662109375
(169) DESCRIBE `ports` 0.0014598369598389
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1319))) 0.00039100646972656
(171) DESCRIBE `ports` 0.001352071762085
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1319') 0.00030398368835449
(173) DESCRIBE `ports` 0.0013821125030518
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4650))) 0.00031590461730957
(175) DESCRIBE `ports` 0.0014488697052002
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4650') 0.00028514862060547
(177) DESCRIBE `ports` 0.001270055770874
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5306))) 0.0003058910369873
(179) DESCRIBE `ports` 0.0012719631195068
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5306') 0.00032806396484375
(181) DESCRIBE `ports` 0.0014321804046631
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00031590461730957
(183) DESCRIBE `ports` 0.0012609958648682
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00032806396484375
(185) DESCRIBE `avid_specials` 0.0013110637664795
(186) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67221 and class = 'Cruise') OR (item_id = 1285 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 43 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.0011649131774902
(187) DESCRIBE `cruiselines` 0.00217604637146
(188) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00034403800964355
(189) DESCRIBE `orchid_image` 0.0015008449554443
(190) DESCRIBE `cruiselines` 0.0019819736480713
(191) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00031089782714844
(192) DESCRIBE `cruises` 0.0025789737701416
(193) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '29065') 0.00031805038452148
(194) DESCRIBE `ships` 0.0026340484619141
(195) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.00038480758666992
(196) DESCRIBE `ships` 0.0025928020477295
(197) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00035309791564941
(198) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030112266540527
(199) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026082992553711
(200) DESCRIBE `itineraries` 0.0014159679412842
(201) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '29065') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00063109397888184
(202) DESCRIBE `ports` 0.0013477802276611
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00033307075500488
(204) DESCRIBE `ports` 0.0013110637664795
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00030303001403809
(206) DESCRIBE `ports` 0.001427173614502
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00031018257141113
(208) DESCRIBE `sailingdates` 0.0012001991271973
(209) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '29065') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011930465698242
(210) DESCRIBE `ports` 0.0018980503082275
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00042510032653809
(212) DESCRIBE `ports` 0.0016779899597168
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00066280364990234
(214) DESCRIBE `ports` 0.00142502784729
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00037503242492676
(216) DESCRIBE `ports` 0.0019550323486328
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00043797492980957
(218) DESCRIBE `avid_specials` 0.0016989707946777
(219) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 29065 and class = 'Cruise') OR (item_id = 573 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0016348361968994
(220) DESCRIBE `cruiselines` 0.0025651454925537
(221) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00042390823364258
(222) DESCRIBE `orchid_image` 0.0016348361968994
(223) DESCRIBE `cruiselines` 0.0026340484619141
(224) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00046300888061523
(225) DESCRIBE `cruises` 0.0035061836242676
(226) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62566') 0.00049901008605957
(227) DESCRIBE `ships` 0.0036051273345947
(228) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.0005340576171875
(229) DESCRIBE `ships` 0.0034689903259277
(230) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00034117698669434
(231) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026702880859375
(232) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025200843811035
(233) DESCRIBE `itineraries` 0.0013489723205566
(234) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62566') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00063896179199219
(235) DESCRIBE `ports` 0.0014078617095947
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00064396858215332
(237) DESCRIBE `ports` 0.001755952835083
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00042510032653809
(239) DESCRIBE `ports` 0.0015289783477783
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00029301643371582
(241) DESCRIBE `sailingdates` 0.0012390613555908
(242) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62566') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00092887878417969
(243) DESCRIBE `ports` 0.0015799999237061
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00034904479980469
(245) DESCRIBE `ports` 0.0012669563293457
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00027680397033691
(247) DESCRIBE `ports` 0.0016410350799561
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00029802322387695
(249) DESCRIBE `ports` 0.0014858245849609
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.0004119873046875
(251) DESCRIBE `ports` 0.0016539096832275
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00031399726867676
(253) DESCRIBE `ports` 0.0018980503082275
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00039315223693848
(255) DESCRIBE `avid_specials` 0.001716136932373
(256) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62566 and class = 'Cruise') OR (item_id = 573 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0016751289367676
(257) DESCRIBE `cruiselines` 0.0023021697998047
(258) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00039100646972656
(259) DESCRIBE `orchid_image` 0.0014991760253906
(260) DESCRIBE `cruiselines` 0.0018260478973389
(261) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00031018257141113
(262) DESCRIBE `cruises` 0.0027050971984863
(263) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62158') 0.00033903121948242
(264) DESCRIBE `ships` 0.0028238296508789
(265) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00063300132751465
(266) DESCRIBE `ships` 0.0040829181671143
(267) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00053501129150391
(268) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00035881996154785
(269) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034809112548828
(270) DESCRIBE `itineraries` 0.0016448497772217
(271) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62158') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00071501731872559
(272) DESCRIBE `ports` 0.0015029907226562
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041985511779785
(274) DESCRIBE `ports` 0.001471996307373
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033712387084961
(276) DESCRIBE `ports` 0.0014731884002686
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002892017364502
(278) DESCRIBE `sailingdates` 0.0011780261993408
(279) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62158') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00050091743469238
(280) DESCRIBE `ports` 0.0015161037445068
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038599967956543
(282) DESCRIBE `ports` 0.0014619827270508
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028300285339355
(284) DESCRIBE `ports` 0.0014588832855225
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2553))) 0.00032806396484375
(286) DESCRIBE `ports` 0.0016441345214844
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2553') 0.00037288665771484
(288) DESCRIBE `ports` 0.0015158653259277
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4208))) 0.00041389465332031
(290) DESCRIBE `ports` 0.0018379688262939
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4208') 0.00046801567077637
(292) DESCRIBE `ports` 0.0018889904022217
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00041794776916504
(294) DESCRIBE `ports` 0.0017170906066895
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00028395652770996
(296) DESCRIBE `ports` 0.0012969970703125
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030088424682617
(298) DESCRIBE `ports` 0.0012698173522949
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002748966217041
(300) DESCRIBE `avid_specials` 0.0011839866638184
(301) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62158 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0010459423065186
(302) DESCRIBE `cruiselines` 0.0021698474884033
(303) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00042915344238281
(304) DESCRIBE `orchid_image` 0.0026509761810303
(305) DESCRIBE `cruiselines` 0.0022339820861816
(306) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00032210350036621
(307) DESCRIBE `cruises` 0.0029799938201904
(308) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67222') 0.00046396255493164
(309) DESCRIBE `ships` 0.0026710033416748
(310) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1285))) 0.00037217140197754
(311) DESCRIBE `ships` 0.0027840137481689
(312) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1285') 0.00029206275939941
(313) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026297569274902
(314) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026392936706543
(315) DESCRIBE `itineraries` 0.0013439655303955
(316) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67222') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00064802169799805
(317) DESCRIBE `ports` 0.0015048980712891
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00032496452331543
(319) DESCRIBE `ports` 0.0013270378112793
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00028896331787109
(321) DESCRIBE `ports` 0.0013198852539062
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00028514862060547
(323) DESCRIBE `sailingdates` 0.001129150390625
(324) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67222') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00045895576477051
(325) DESCRIBE `ports` 0.0013899803161621
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00034403800964355
(327) DESCRIBE `ports` 0.0013031959533691
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00028800964355469
(329) DESCRIBE `ports` 0.0013039112091064
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5306))) 0.00031304359436035
(331) DESCRIBE `ports` 0.0013141632080078
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5306') 0.00028204917907715
(333) DESCRIBE `ports` 0.0013189315795898
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.0003659725189209
(335) DESCRIBE `ports` 0.0013778209686279
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00029397010803223
(337) DESCRIBE `avid_specials` 0.0016539096832275
(338) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67222 and class = 'Cruise') OR (item_id = 1285 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 43 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.0017349720001221
(339) DESCRIBE `cruiselines` 0.0020859241485596
(340) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00043487548828125
(341) DESCRIBE `orchid_image` 0.0015459060668945
(342) DESCRIBE `cruiselines` 0.0020360946655273
(343) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00032186508178711
(344) DESCRIBE `cruises` 0.0035879611968994
(345) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62578') 0.0006251335144043
(346) DESCRIBE `ships` 0.0033400058746338
(347) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 765))) 0.00055098533630371
(348) DESCRIBE `ships` 0.003291130065918
(349) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '765') 0.00036001205444336
(350) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034713745117188
(351) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00025701522827148
(352) DESCRIBE `itineraries` 0.0018370151519775
(353) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62578') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00056099891662598
(354) DESCRIBE `ports` 0.0017869472503662
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0004119873046875
(356) DESCRIBE `ports` 0.0013589859008789
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00031208992004395
(358) DESCRIBE `ports` 0.0013399124145508
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00033092498779297
(360) DESCRIBE `sailingdates` 0.0012650489807129
(361) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62578') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00064992904663086
(362) DESCRIBE `ports` 0.0016028881072998
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0003669261932373
(364) DESCRIBE `ports` 0.0012779235839844
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00028395652770996
(366) DESCRIBE `ports` 0.0013580322265625
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00041913986206055
(368) DESCRIBE `ports` 0.001535177230835
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00033712387084961
(370) DESCRIBE `avid_specials` 0.0012061595916748
(371) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62578 and class = 'Cruise') OR (item_id = 765 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 43 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.0011379718780518
(372) DESCRIBE `cruiselines` 0.0020051002502441
(373) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00043201446533203
(374) DESCRIBE `orchid_image` 0.0015630722045898
(375) DESCRIBE `cruiselines` 0.0019569396972656
(376) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00030994415283203
(377) DESCRIBE `cruises` 0.0028450489044189
(378) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64368') 0.00035405158996582
(379) DESCRIBE `ships` 0.002856969833374
(380) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.00041007995605469
(381) DESCRIBE `ships` 0.0028071403503418
(382) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00032615661621094
(383) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033283233642578
(384) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027585029602051
(385) DESCRIBE `itineraries` 0.0013999938964844
(386) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64368') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00069499015808105
(387) DESCRIBE `ports` 0.0014309883117676
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00034594535827637
(389) DESCRIBE `ports` 0.0014011859893799
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0003209114074707
(391) DESCRIBE `ports` 0.0013768672943115
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00035214424133301
(393) DESCRIBE `sailingdates` 0.0016560554504395
(394) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64368') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00083398818969727
(395) DESCRIBE `ports` 0.0017180442810059
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0003969669342041
(397) DESCRIBE `ports` 0.0015869140625
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00033903121948242
(399) DESCRIBE `ports` 0.0012691020965576
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00033712387084961
(401) DESCRIBE `ports` 0.0012412071228027
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00026917457580566
(403) DESCRIBE `ports` 0.0012731552124023
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00031900405883789
(405) DESCRIBE `ports` 0.0013620853424072
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.0002748966217041
(407) DESCRIBE `ports` 0.0013580322265625
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00030994415283203
(409) DESCRIBE `ports` 0.0014197826385498
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00027585029602051
(411) DESCRIBE `ports` 0.0013339519500732
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00032806396484375
(413) DESCRIBE `ports` 0.0014820098876953
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00036311149597168
(415) DESCRIBE `avid_specials` 0.0013918876647949
(416) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64368 and class = 'Cruise') OR (item_id = 573 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 43 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.00111985206604
(417) DESCRIBE `cruiselines` 0.0024399757385254
(418) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00038003921508789
(419) DESCRIBE `orchid_image` 0.0018310546875
(420) DESCRIBE `cruiselines` 0.0026950836181641
(421) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00040292739868164
(422) DESCRIBE `ships` 0.0038979053497314
(423) SELECT `ships`.* FROM `ships` WHERE (id IN ('573', '1402', '1284', '765', '1285')) ORDER BY FIND_IN_SET(id, '573,1402,1284,765,1285') 0.0010151863098145
(424) DESCRIBE `cruisetypes` 0.0015900135040283
(425) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '37') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.037358045578003
(426) DESCRIBE `destinations` 0.0025160312652588
(427) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('8', '43', '35')) ORDER BY FIND_IN_SET(id, '8,43,35') 0.00063204765319824
(428) DESCRIBE `cruiselines` 0.0022540092468262
(429) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.0003960132598877
(430) DESCRIBE `cruiselines` 0.00199294090271
(431) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.0004270076751709