or, enquire about your chosen options

  1. Catch up on Cruising: Latest news in bite size
  2. Catch up on Cruising: Latest news in bite size
  3. Family Cruising – Have you considered it ?
  4. New Azamara Ship to arrive in March 2018
  5. Enhanced amenities for Oceania Cruises

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

 
  • Vision, Southern Caribbean Cruise ex Cape Liberty to Galveston

    Nights 14 Ship Vision of the Seas
    Star Rating 4 Star Departs Cape Liberty Cruise Port, New Jersey, USA
    Sailing 2017: 23 Oct
    Ports of Call Cape Liberty Cruise Port, Labadee, Kralendijk, Willemstad, Oranjestad, Grand Cayman (George Town), Cozumel, Costa Maya, Progresso, Galveston

    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.

     
    Royal Caribbean: Celebrating 10 Years of Royal Birthday Sale Up to 40% off cruise fares plus guests 3 and 4 cruise from NZ$80 per day. Bonus onboard credits of up to US$100 per stateroom on sailings 4 nights or longer. Selected sailings and terms and conditions apply. Contact us for details.
  • Mariner, Penang & Langkawi ex Singapore Return

    Nights 4 Ship Mariner of the Seas
    Star Rating 4 Star Departs Singapore, Singapore
    Sailing 2017: 23 Oct, 6 Nov, 20 Nov, 4 Dec 2018: 29 Jan
    Ports of Call Singapore, Penang, Langkawi

    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.

     
    Royal Caribbean: Celebrating 10 Years of Royal Birthday Sale Up to 40% off cruise fares plus guests 3 and 4 cruise from NZ$80 per day. Bonus onboard credits of up to US$100 per stateroom on sailings 4 nights or longer. Selected sailings and terms and conditions apply. Contact us for details.
  • Enchantment, Bahamas Cruise ex Miami Return

    Nights 4 Ship Enchantment of the Seas
    Star Rating 4 Star Departs Miami
    Sailing 2017: 23 Oct, 30 Oct, 13 Nov, 20 Nov, 18 Dec 2018: 8 Jan, 15 Jan, 29 Jan, 5 Feb, 19 Feb, 26 Feb, 5 Mar, 12 Mar, 19 Mar, 26 Mar, 2 Apr, 9 Apr, 16 Apr, 23 Apr, 30 Apr, 14 May, 21 May, 4 Jun, 11 Jun
    Ports of Call Miami, Nassau, Cococay, Key West

    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.

     
    Royal Caribbean: Celebrating 10 Years of Royal Birthday Sale Up to 40% off cruise fares plus guests 3 and 4 cruise from NZ$80 per day. Bonus onboard credits of up to US$100 per stateroom on sailings 4 nights or longer. Selected sailings and terms and conditions apply. Contact us for details.
  • Majesty, Bahamas ex Port Canaveral Roundtrip

    Nights 4 Ship Majesty of the Seas
    Star Rating 4 Star Departs Port Canaveral, USA
    Sailing 2017: 23 Oct, 30 Oct, 6 Nov, 13 Nov, 20 Nov, 27 Nov, 4 Dec, 18 Dec, 22 Dec, 29 Dec 2018: 15 Jan, 5 Feb, 12 Feb, 19 Feb, 26 Feb, 5 Mar, 12 Mar, 19 Mar, 26 Mar, 2 Apr, 16 Apr More 23 Apr, 30 Apr, 28 May, 25 Jun, 23 Jul, 20 Aug, 29 Oct, 5 Nov, 12 Nov, 19 Nov, 26 Nov, 17 Dec, 24 Dec 2019: 21 Jan, 18 Feb, 18 Mar, 25 Mar, 1 Apr, 8 Apr Less
    Ports of Call Port Canaveral, Nassau, Cococay

    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.

     
    Royal Caribbean: Celebrating 10 Years of Royal Birthday Sale Up to 40% off cruise fares plus guests 3 and 4 cruise from NZ$80 per day. Bonus onboard credits of up to US$100 per stateroom on sailings 4 nights or longer. Selected sailings and terms and conditions apply. Contact us for details.
  • Independence, French & Dutch Adventure Cruise ex Southampton Return

    Nights 5 Ship Independence of the Seas
    Star Rating 4 Star Departs Southampton, England
    Sailing 2017: 24 Oct
    Ports of Call Southampton, Rotterdam, Brussels (Brugge), Cherbourg, Le Havre
    Please enquire about this cruise for pricing.
     
    Royal Caribbean: Celebrating 10 Years of Royal Birthday Sale Up to 40% off cruise fares plus guests 3 and 4 cruise from NZ$80 per day. Bonus onboard credits of up to US$100 per stateroom on sailings 4 nights or longer. Selected sailings and terms and conditions apply. Contact us for details.
  • Jewel, Mediterranean Barcelona Cruise ex Rome Return

    Nights 12 Ship Jewel of the Seas
    Star Rating 4 Star Departs Rome (Civitavecchia), Italy
    Sailing 2017: 25 Oct
    Ports of Call Rome (Civitavecchia), Villefranche (Nice), Provence, Barcelona, Valencia, Palma, Valletta, Messina, Capri

    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.

     
    Royal Caribbean: Celebrating 10 Years of Royal Birthday Sale Up to 40% off cruise fares plus guests 3 and 4 cruise from NZ$80 per day. Bonus onboard credits of up to US$100 per stateroom on sailings 4 nights or longer. Selected sailings and terms and conditions apply. Contact us for details.
  • Empress, Key West Havana & Cozumel ex Tampa Return

    Nights 5 Ship Empress of the Seas
    Star Rating Not Rated Departs Tampa, Florida
    Sailing 2017: 25 Oct 2018: 4 Jul, 29 Aug, 10 Oct, 24 Oct
    Ports of Call Tampa, Key West, Havana, Cozumel
    Please enquire about this cruise for pricing.
     
    Royal Caribbean: Celebrating 10 Years of Royal Birthday Sale Up to 40% off cruise fares plus guests 3 and 4 cruise from NZ$80 per day. Bonus onboard credits of up to US$100 per stateroom on sailings 4 nights or longer. Selected sailings and terms and conditions apply. Contact us for details.
  • Navigator, Sunshine in the Canaries Cruise ex Southampton Return

    Nights 10 Ship Navigator of the Seas
    Star Rating 4 Star Departs Southampton, England
    Sailing 2017: 27 Oct 2018: 26 Oct
    Ports of Call Southampton, Funchal (Madeira), Tenerife, Gran Canaria (Las Palmas), Arrecife, Vigo

    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.

     
    Royal Caribbean: Celebrating 10 Years of Royal Birthday Sale Up to 40% off cruise fares plus guests 3 and 4 cruise from NZ$80 per day. Bonus onboard credits of up to US$100 per stateroom on sailings 4 nights or longer. Selected sailings and terms and conditions apply. Contact us for details.
  • Mariner, Weekend Cruise to Port Klang ex Singapore Roundtrip

    Nights 3 Ship Mariner of the Seas
    Star Rating 4 Star Departs Singapore, Singapore
    Sailing 2017: 27 Oct, 3 Nov, 10 Nov 2018: 12 Jan, 19 Jan, 26 Jan, 2 Feb, 16 Mar
    Ports of Call Singapore, Kuala Lumpur

    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.

     
    Royal Caribbean: Celebrating 10 Years of Royal Birthday Sale Up to 40% off cruise fares plus guests 3 and 4 cruise from NZ$80 per day. Bonus onboard credits of up to US$100 per stateroom on sailings 4 nights or longer. Selected sailings and terms and conditions apply. Contact us for details.
  • Enchantment, Bahamas Cruise ex Miami Return

    Nights 3 Ship Enchantment of the Seas
    Star Rating 4 Star Departs Miami
    Sailing 2017: 27 Oct, 3 Nov, 10 Nov, 17 Nov, 24 Nov, 26 Dec 2018: 2 Jan, 5 Jan, 12 Jan, 19 Jan, 26 Jan, 2 Feb, 9 Feb, 16 Feb, 23 Feb, 2 Mar, 9 Mar, 16 Mar, 23 Mar, 30 Mar, 6 Apr, 13 Apr, 20 Apr, 27 Apr, 4 May, 11 May, 18 May, 25 May, 1 Jun, 8 Jun, 15 Jun, 18 Jun
    Ports of Call Miami, Cococay, Nassau

    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.

     
    Royal Caribbean: Celebrating 10 Years of Royal Birthday Sale Up to 40% off cruise fares plus guests 3 and 4 cruise from NZ$80 per day. Bonus onboard credits of up to US$100 per stateroom on sailings 4 nights or longer. Selected sailings and terms and conditions apply. Contact us for details.
 

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

Total elapsed time: 0.27055048942566

# Query Time
(1) connect 0.00050616264343262
(2) DESCRIBE `cruises` 0.0016729831695557
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (64320, 47387, 54739, 61222, 60793, 60864, 66780, 60815, 53578, 54738)) ORDER BY FIND_IN_SET(id, '64320,47387,54739,61222,60793,60864,66780,60815,53578,54738') 0.0012590885162354
(4) DESCRIBE `cruises` 0.0017709732055664
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64320') 0.0004429817199707
(6) DESCRIBE `ships` 0.0013759136199951
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 123))) 0.00026297569274902
(8) DESCRIBE `ships` 0.0012679100036621
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '123') 0.00019097328186035
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017499923706055
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016498565673828
(12) DESCRIBE `itineraries` 0.00066590309143066
(13) DESCRIBE `ports` 0.0007169246673584
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.00021600723266602
(15) DESCRIBE `ports` 0.00065994262695312
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.00019097328186035
(17) DESCRIBE `ports` 0.00066113471984863
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2521') 0.00020194053649902
(19) DESCRIBE `sailingdates` 0.00060105323791504
(20) DESCRIBE `ports` 0.0006721019744873
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.00021696090698242
(22) DESCRIBE `ports` 0.0006558895111084
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2521') 0.00018787384033203
(24) DESCRIBE `ports` 0.00065493583679199
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 465))) 0.00019502639770508
(26) DESCRIBE `ports` 0.00066089630126953
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '465') 0.00022006034851074
(28) DESCRIBE `ports` 0.00082302093505859
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 345))) 0.00020003318786621
(30) DESCRIBE `ports` 0.00070285797119141
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '345') 0.00019121170043945
(32) DESCRIBE `ports` 0.00067400932312012
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 346))) 0.00019979476928711
(34) DESCRIBE `ports` 0.00065898895263672
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '346') 0.00018596649169922
(36) DESCRIBE `ports` 0.00065994262695312
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00020408630371094
(38) DESCRIBE `ports` 0.00066208839416504
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00022292137145996
(40) DESCRIBE `ports` 0.00066089630126953
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00019502639770508
(42) DESCRIBE `ports` 0.00065398216247559
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00018405914306641
(44) DESCRIBE `ports` 0.00065898895263672
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.0001988410949707
(46) DESCRIBE `ports` 0.00065112113952637
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00017404556274414
(48) DESCRIBE `ports` 0.00065207481384277
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00020003318786621
(50) DESCRIBE `ports` 0.00074386596679688
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00017499923706055
(52) DESCRIBE `ports` 0.00075984001159668
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2298))) 0.00021791458129883
(54) DESCRIBE `ports` 0.0006721019744873
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2298') 0.00017189979553223
(56) DESCRIBE `ports` 0.0006861686706543
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00019598007202148
(58) DESCRIBE `ports` 0.00067305564880371
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00017499923706055
(60) DESCRIBE `avid_specials` 0.00060701370239258
(61) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64320 and class = 'Cruise') OR (item_id = 123 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 12 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.0010840892791748
(62) DESCRIBE `cruiselines` 0.00098681449890137
(63) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.0002129077911377
(64) DESCRIBE `orchid_image` 0.0007469654083252
(65) DESCRIBE `cruiselines` 0.00094795227050781
(66) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00019502639770508
(67) DESCRIBE `cruises` 0.0013668537139893
(68) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '47387') 0.00024199485778809
(69) DESCRIBE `ships` 0.0013270378112793
(70) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 393))) 0.0002601146697998
(71) DESCRIBE `ships` 0.0012860298156738
(72) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '393') 0.00022101402282715
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017285346984863
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016307830810547
(75) DESCRIBE `itineraries` 0.00065708160400391
(76) DESCRIBE `ports` 0.00072789192199707
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00021696090698242
(78) DESCRIBE `ports` 0.0006711483001709
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00021505355834961
(80) DESCRIBE `ports` 0.00072598457336426
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00018095970153809
(82) DESCRIBE `sailingdates` 0.00068092346191406
(83) DESCRIBE `ports` 0.000762939453125
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00028300285339355
(85) DESCRIBE `ports` 0.00095105171203613
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00023198127746582
(87) DESCRIBE `ports` 0.00067400932312012
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.0002140998840332
(89) DESCRIBE `ports` 0.00081586837768555
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00022792816162109
(91) DESCRIBE `ports` 0.00070095062255859
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 178))) 0.00021600723266602
(93) DESCRIBE `ports` 0.0006718635559082
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '178') 0.00018191337585449
(95) DESCRIBE `ports` 0.00071883201599121
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00024080276489258
(97) DESCRIBE `ports` 0.00074195861816406
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00018596649169922
(99) DESCRIBE `avid_specials` 0.00062298774719238
(100) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 47387 and class = 'Cruise') OR (item_id = 393 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 35 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.0011360645294189
(101) DESCRIBE `cruiselines` 0.0010380744934082
(102) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00025296211242676
(103) DESCRIBE `orchid_image` 0.00075602531433105
(104) DESCRIBE `cruiselines` 0.001366138458252
(105) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00025296211242676
(106) DESCRIBE `cruises` 0.0020978450775146
(107) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '54739') 0.00028705596923828
(108) DESCRIBE `ships` 0.0013811588287354
(109) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 113))) 0.0003199577331543
(110) DESCRIBE `ships` 0.0015850067138672
(111) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '113') 0.00030899047851562
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018715858459473
(113) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016617774963379
(114) DESCRIBE `itineraries` 0.0007479190826416
(115) DESCRIBE `ports` 0.0007171630859375
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0002601146697998
(117) DESCRIBE `ports` 0.0006721019744873
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00022506713867188
(119) DESCRIBE `ports` 0.00069308280944824
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00020503997802734
(121) DESCRIBE `sailingdates` 0.00067710876464844
(122) DESCRIBE `ports` 0.0012421607971191
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0003359317779541
(124) DESCRIBE `ports` 0.00094795227050781
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0002899169921875
(126) DESCRIBE `ports` 0.0010659694671631
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00029110908508301
(128) DESCRIBE `ports` 0.00090694427490234
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00023508071899414
(130) DESCRIBE `ports` 0.00068497657775879
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.0002129077911377
(132) DESCRIBE `ports` 0.00071477890014648
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.00018191337585449
(134) DESCRIBE `ports` 0.00067710876464844
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00020813941955566
(136) DESCRIBE `ports` 0.0007789134979248
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00022101402282715
(138) DESCRIBE `ports` 0.00071310997009277
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00021910667419434
(140) DESCRIBE `ports` 0.00068807601928711
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00018501281738281
(142) DESCRIBE `avid_specials` 0.00066995620727539
(143) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 54739 and class = 'Cruise') OR (item_id = 113 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 9 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.001276969909668
(144) DESCRIBE `cruiselines` 0.0012030601501465
(145) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00029492378234863
(146) DESCRIBE `orchid_image` 0.00080204010009766
(147) DESCRIBE `cruiselines` 0.00095582008361816
(148) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00020289421081543
(149) DESCRIBE `cruises` 0.0013558864593506
(150) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61222') 0.00035881996154785
(151) DESCRIBE `ships` 0.0014119148254395
(152) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 116))) 0.00027084350585938
(153) DESCRIBE `ships` 0.0013329982757568
(154) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '116') 0.00019097328186035
(155) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018692016601562
(156) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017213821411133
(157) DESCRIBE `itineraries` 0.00068306922912598
(158) DESCRIBE `ports` 0.00081706047058105
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00021100044250488
(160) DESCRIBE `ports` 0.00074505805969238
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00020909309387207
(162) DESCRIBE `ports` 0.00080609321594238
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00018692016601562
(164) DESCRIBE `sailingdates` 0.00061583518981934
(165) DESCRIBE `ports` 0.00098896026611328
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00025200843811035
(167) DESCRIBE `ports` 0.00067996978759766
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00019192695617676
(169) DESCRIBE `ports` 0.00068211555480957
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00020289421081543
(171) DESCRIBE `ports` 0.00069403648376465
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00018191337585449
(173) DESCRIBE `ports` 0.00067591667175293
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.00022697448730469
(175) DESCRIBE `ports` 0.00071406364440918
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.00021791458129883
(177) DESCRIBE `ports` 0.00069689750671387
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00021600723266602
(179) DESCRIBE `ports` 0.00069093704223633
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00019001960754395
(181) DESCRIBE `avid_specials` 0.00064396858215332
(182) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61222 and class = 'Cruise') OR (item_id = 116 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 9 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.0010929107666016
(183) DESCRIBE `cruiselines` 0.00098395347595215
(184) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00029301643371582
(185) DESCRIBE `orchid_image` 0.0007789134979248
(186) DESCRIBE `cruiselines` 0.00093293190002441
(187) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00018787384033203
(188) DESCRIBE `cruises` 0.0012941360473633
(189) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60793') 0.00020790100097656
(190) DESCRIBE `ships` 0.0013089179992676
(191) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 658))) 0.00024604797363281
(192) DESCRIBE `ships` 0.0013518333435059
(193) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '658') 0.00018191337585449
(194) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018620491027832
(195) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016999244689941
(196) DESCRIBE `itineraries` 0.0006568431854248
(197) DESCRIBE `ports` 0.00071501731872559
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0002140998840332
(199) DESCRIBE `ports` 0.0007021427154541
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00021100044250488
(201) DESCRIBE `ports` 0.00066900253295898
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00018906593322754
(203) DESCRIBE `sailingdates` 0.00060200691223145
(204) DESCRIBE `ports` 0.00069093704223633
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00020503997802734
(206) DESCRIBE `ports` 0.00096392631530762
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00022101402282715
(208) DESCRIBE `ports` 0.00086092948913574
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1522))) 0.00020813941955566
(210) DESCRIBE `ports` 0.00067520141601562
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1522') 0.00018191337585449
(212) DESCRIBE `ports` 0.0006861686706543
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1527))) 0.00021100044250488
(214) DESCRIBE `ports` 0.00067400932312012
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1527') 0.00018191337585449
(216) DESCRIBE `ports` 0.00069808959960938
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1063))) 0.00019979476928711
(218) DESCRIBE `ports` 0.0006859302520752
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1063') 0.00018501281738281
(220) DESCRIBE `ports` 0.00068497657775879
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00020503997802734
(222) DESCRIBE `ports` 0.00069618225097656
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.00018811225891113
(224) DESCRIBE `ports` 0.00066804885864258
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00021100044250488
(226) DESCRIBE `ports` 0.0006859302520752
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00018215179443359
(228) DESCRIBE `avid_specials` 0.00060391426086426
(229) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60793 and class = 'Cruise') OR (item_id = 658 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 28 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.0011119842529297
(230) DESCRIBE `cruiselines` 0.0010170936584473
(231) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.0002439022064209
(232) DESCRIBE `orchid_image` 0.00077509880065918
(233) DESCRIBE `cruiselines` 0.00093698501586914
(234) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00018215179443359
(235) DESCRIBE `cruises` 0.0012960433959961
(236) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60864') 0.0001978874206543
(237) DESCRIBE `ships` 0.0013289451599121
(238) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 403))) 0.00030803680419922
(239) DESCRIBE `ships` 0.0016999244689941
(240) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '403') 0.00022792816162109
(241) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018596649169922
(242) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017309188842773
(243) DESCRIBE `itineraries` 0.00070405006408691
(244) DESCRIBE `ports` 0.00071501731872559
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0002291202545166
(246) DESCRIBE `ports` 0.00068092346191406
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020408630371094
(248) DESCRIBE `ports` 0.00067496299743652
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018596649169922
(250) DESCRIBE `sailingdates` 0.00060200691223145
(251) DESCRIBE `ports` 0.00069499015808105
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020980834960938
(253) DESCRIBE `ports` 0.00072193145751953
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0001838207244873
(255) DESCRIBE `ports` 0.00067687034606934
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 583))) 0.00020694732666016
(257) DESCRIBE `ports` 0.00067687034606934
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '583') 0.00021505355834961
(259) DESCRIBE `ports` 0.00072908401489258
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1509))) 0.00020694732666016
(261) DESCRIBE `ports` 0.00068902969360352
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1509') 0.00018906593322754
(263) DESCRIBE `ports` 0.00067400932312012
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00022792816162109
(265) DESCRIBE `ports` 0.00068497657775879
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018501281738281
(267) DESCRIBE `ports` 0.00067019462585449
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020289421081543
(269) DESCRIBE `ports` 0.00072097778320312
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00024199485778809
(271) DESCRIBE `ports` 0.00074100494384766
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00021505355834961
(273) DESCRIBE `ports` 0.0006709098815918
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00019001960754395
(275) DESCRIBE `ports` 0.00067496299743652
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00020599365234375
(277) DESCRIBE `ports` 0.00068187713623047
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00018787384033203
(279) DESCRIBE `ports` 0.00088596343994141
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00020790100097656
(281) DESCRIBE `ports` 0.00074005126953125
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00018405914306641
(283) DESCRIBE `ports` 0.00067305564880371
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00020885467529297
(285) DESCRIBE `ports` 0.00072097778320312
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.0001828670501709
(287) DESCRIBE `ports` 0.00067400932312012
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 756))) 0.00020599365234375
(289) DESCRIBE `ports` 0.00067687034606934
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '756') 0.00020909309387207
(291) DESCRIBE `ports` 0.00069499015808105
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020408630371094
(293) DESCRIBE `ports` 0.00070381164550781
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018000602722168
(295) DESCRIBE `avid_specials` 0.00062417984008789
(296) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60864 and class = 'Cruise') OR (item_id = 403 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 22 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.0010800361633301
(297) DESCRIBE `cruiselines` 0.0009768009185791
(298) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00022602081298828
(299) DESCRIBE `orchid_image` 0.00082111358642578
(300) DESCRIBE `cruiselines` 0.00098013877868652
(301) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00019097328186035
(302) DESCRIBE `cruises` 0.0013370513916016
(303) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66780') 0.00022196769714355
(304) DESCRIBE `ships` 0.001323938369751
(305) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1571))) 0.00026988983154297
(306) DESCRIBE `ships` 0.0012969970703125
(307) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1571') 0.00020098686218262
(308) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.0002129077911377
(309) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.0001828670501709
(310) DESCRIBE `itineraries` 0.00067710876464844
(311) DESCRIBE `ports` 0.00069808959960938
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00022411346435547
(313) DESCRIBE `ports` 0.00068998336791992
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00020408630371094
(315) DESCRIBE `ports` 0.00073099136352539
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00019192695617676
(317) DESCRIBE `sailingdates` 0.00060582160949707
(318) DESCRIBE `ports` 0.00080299377441406
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00020503997802734
(320) DESCRIBE `ports` 0.00067710876464844
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00020909309387207
(322) DESCRIBE `ports` 0.00069499015808105
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00023198127746582
(324) DESCRIBE `ports` 0.00085806846618652
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00023698806762695
(326) DESCRIBE `ports` 0.00094795227050781
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00022006034851074
(328) DESCRIBE `ports` 0.00073385238647461
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00018906593322754
(330) DESCRIBE `ports` 0.00067901611328125
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00022315979003906
(332) DESCRIBE `ports` 0.00069499015808105
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00018477439880371
(334) DESCRIBE `ports` 0.00067400932312012
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00021195411682129
(336) DESCRIBE `ports` 0.00069212913513184
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00018215179443359
(338) DESCRIBE `avid_specials` 0.00061297416687012
(339) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66780 and class = 'Cruise') OR (item_id = 1571 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 12 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.0010838508605957
(340) DESCRIBE `cruiselines` 0.0010309219360352
(341) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00022983551025391
(342) DESCRIBE `orchid_image` 0.00075507164001465
(343) DESCRIBE `cruiselines` 0.00097107887268066
(344) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00018501281738281
(345) DESCRIBE `cruises` 0.0014030933380127
(346) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60815') 0.00022983551025391
(347) DESCRIBE `ships` 0.0013220310211182
(348) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 330))) 0.00031113624572754
(349) DESCRIBE `ships` 0.0015449523925781
(350) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '330') 0.00019693374633789
(351) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(352) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017213821411133
(353) DESCRIBE `itineraries` 0.00067996978759766
(354) DESCRIBE `ports` 0.00068402290344238
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00023484230041504
(356) DESCRIBE `ports` 0.00073599815368652
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00020503997802734
(358) DESCRIBE `ports` 0.00068998336791992
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00018501281738281
(360) DESCRIBE `sailingdates` 0.00060820579528809
(361) DESCRIBE `ports` 0.00072503089904785
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00020909309387207
(363) DESCRIBE `ports` 0.00069808959960938
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.0001828670501709
(365) DESCRIBE `ports` 0.00070905685424805
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 628))) 0.00021600723266602
(367) DESCRIBE `ports` 0.00069999694824219
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '628') 0.00021100044250488
(369) DESCRIBE `ports` 0.0007631778717041
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1170))) 0.00020599365234375
(371) DESCRIBE `ports` 0.0007021427154541
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1170') 0.00018811225891113
(373) DESCRIBE `ports` 0.00068402290344238
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 685))) 0.00021195411682129
(375) DESCRIBE `ports` 0.00068497657775879
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '685') 0.00018191337585449
(377) DESCRIBE `ports` 0.0013949871063232
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 599))) 0.00040698051452637
(379) DESCRIBE `ports` 0.00084209442138672
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '599') 0.00022006034851074
(381) DESCRIBE `ports` 0.00075888633728027
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 566))) 0.00025701522827148
(383) DESCRIBE `ports` 0.00075292587280273
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '566') 0.00020313262939453
(385) DESCRIBE `ports` 0.00074601173400879
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00040102005004883
(387) DESCRIBE `ports` 0.00097894668579102
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.0001978874206543
(389) DESCRIBE `avid_specials` 0.00063800811767578
(390) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60815 and class = 'Cruise') OR (item_id = 330 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 28 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.0011370182037354
(391) DESCRIBE `cruiselines` 0.0012578964233398
(392) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.0003359317779541
(393) DESCRIBE `orchid_image` 0.0010769367218018
(394) DESCRIBE `cruiselines` 0.001309871673584
(395) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00027799606323242
(396) DESCRIBE `cruises` 0.0018019676208496
(397) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '53578') 0.00024199485778809
(398) DESCRIBE `ships` 0.00130295753479
(399) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 393))) 0.00027704238891602
(400) DESCRIBE `ships` 0.0013408660888672
(401) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '393') 0.00020003318786621
(402) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018191337585449
(403) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017499923706055
(404) DESCRIBE `itineraries` 0.00069594383239746
(405) DESCRIBE `ports` 0.00071811676025391
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00023913383483887
(407) DESCRIBE `ports` 0.00067400932312012
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020503997802734
(409) DESCRIBE `ports` 0.00068807601928711
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0001990795135498
(411) DESCRIBE `sailingdates` 0.00060796737670898
(412) DESCRIBE `ports` 0.00075912475585938
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00023007392883301
(414) DESCRIBE `ports` 0.00069999694824219
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00019097328186035
(416) DESCRIBE `ports` 0.0006868839263916
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 173))) 0.00021505355834961
(418) DESCRIBE `ports` 0.0006718635559082
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '173') 0.00018811225891113
(420) DESCRIBE `ports` 0.0006709098815918
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020384788513184
(422) DESCRIBE `ports` 0.0006868839263916
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00018000602722168
(424) DESCRIBE `avid_specials` 0.00060391426086426
(425) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 53578 and class = 'Cruise') OR (item_id = 393 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 35 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.001101016998291
(426) DESCRIBE `cruiselines` 0.0010619163513184
(427) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00025010108947754
(428) DESCRIBE `orchid_image` 0.00099992752075195
(429) DESCRIBE `cruiselines` 0.0013580322265625
(430) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00025510787963867
(431) DESCRIBE `cruises` 0.0014760494232178
(432) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '54738') 0.00023603439331055
(433) DESCRIBE `ships` 0.0013799667358398
(434) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 113))) 0.00027203559875488
(435) DESCRIBE `ships` 0.001410961151123
(436) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '113') 0.00020408630371094
(437) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001828670501709
(438) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017189979553223
(439) DESCRIBE `itineraries` 0.00068807601928711
(440) DESCRIBE `ports` 0.00071907043457031
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0002288818359375
(442) DESCRIBE `ports` 0.00071191787719727
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00021791458129883
(444) DESCRIBE `ports` 0.00081110000610352
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00020813941955566
(446) DESCRIBE `sailingdates` 0.00070405006408691
(447) DESCRIBE `ports` 0.0011179447174072
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00028491020202637
(449) DESCRIBE `ports` 0.00072383880615234
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0001990795135498
(451) DESCRIBE `ports` 0.00069594383239746
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.00021004676818848
(453) DESCRIBE `ports` 0.00069022178649902
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.00021600723266602
(455) DESCRIBE `ports` 0.00069713592529297
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.0002140998840332
(457) DESCRIBE `ports` 0.0008552074432373
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00020885467529297
(459) DESCRIBE `ports` 0.00070905685424805
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00021600723266602
(461) DESCRIBE `ports` 0.00067901611328125
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00019097328186035
(463) DESCRIBE `avid_specials` 0.00084996223449707
(464) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 54738 and class = 'Cruise') OR (item_id = 113 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 9 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.0011270046234131
(465) DESCRIBE `cruiselines` 0.0011091232299805
(466) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.0002448558807373
(467) DESCRIBE `orchid_image` 0.00078296661376953
(468) DESCRIBE `cruiselines` 0.0010390281677246
(469) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00020599365234375
(470) DESCRIBE `ships` 0.0016400814056396
(471) SELECT `ships`.* FROM `ships` WHERE (id IN ('116', '393', '113', '1571', '124', '1141', '286', '748', '791', '1323', '590', '1330', '1586', '123', '262', '119', '287', '658', '403', '330', '285', '389', '526', '1236', '114')) ORDER BY FIND_IN_SET(id, '116,393,113,1571,124,1141,286,748,791,1323,590,1330,1586,123,262,119,287,658,403,330,285,389,526,1236,114') 0.0011930465698242
(472) DESCRIBE `cruisetypes` 0.00088810920715332
(473) DESCRIBE `destinations` 0.00093913078308105
(474) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '9', '35', '22', '43', '2', '8', '38', '26', '28', '11', '25', '34', '21', '29', '48')) ORDER BY FIND_IN_SET(id, '12,9,35,22,43,2,8,38,26,28,11,25,34,21,29,48') 0.00077390670776367
(475) DESCRIBE `cruiselines` 0.0011441707611084
(476) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00025606155395508
(477) DESCRIBE `cruiselines` 0.0011870861053467
(478) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00026392936706543