or, enquire about your chosen options

  1. Holland America’s View and Veranda promotion is back!!
  2. The Big Laugh Comedy Festival Cruise
  3. Catch up on Cruising: Latest news in bite size
  4. Meet the Cruise Factor Team – Don
  5. Catch up on Cruising: Latest news in bite size

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

 
  • Jewel, Southern Caribbean Cruise ex San Juan Roundtrip

    Nights 7 Ship Jewel of the Seas
    Star Rating 4 Star Departs San Juan, Puerto Rico
    Sailing 2017: 17 Dec, 31 Dec 2018: 14 Jan, 28 Jan, 11 Feb, 25 Feb, 11 Mar, 25 Mar, 8 Apr, 22 Apr
    Ports of Call San Juan, Charlotte Amalie, Basseterre, St Johns, Castries, Bridgetown

    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.

  • Oasis, Eastern Caribbean ex Port Canaveral Return

    Nights 7 Ship Oasis of the Seas
    Star Rating 4 Star Departs Port Canaveral, USA
    Sailing 2017: 17 Dec, 31 Dec 2018: 14 Jan, 28 Jan, 11 Feb, 25 Feb, 11 Mar, 25 Mar, 8 Apr, 22 Apr, 20 May, 3 Jun, 1 Jul, 15 Jul, 12 Aug, 26 Aug, 23 Sep, 7 Oct
    Ports of Call Port Canaveral, Philipsburg, San Juan, Labadee

    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.

  • Freedom, Western Caribbean ex Ft Lauderdale Roundtrip

    Nights 6 Ship Freedom of the Seas
    Star Rating 4 Star Departs Ft Lauderdale (Pt Everglades), USA
    Sailing 2017: 17 Dec, 31 Dec 2018: 14 Jan, 28 Jan, 11 Feb, 25 Feb, 11 Mar, 25 Mar, 8 Apr, 22 Apr
    Ports of Call Ft Lauderdale (Pt Everglades), Grand Cayman (George Town), Costa Maya, Cozumel

    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.

  • Allure, Western Caribbean ex Ft Lauderdale Return

    Nights 7 Ship Allure of the Seas
    Star Rating 4 Star Departs Ft Lauderdale (Pt Everglades), USA
    Sailing 2017: 17 Dec 2018: 14 Jan, 28 Jan, 11 Feb, 25 Feb
    Ports of Call Ft Lauderdale (Pt Everglades), Labadee, Falmouth, Cozumel

    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.

  • Liberty, Western Caribbean Cruise ex Galveston Return

    Nights 7 Ship Liberty of the Seas
    Star Rating 4 Star Departs Galveston, Texas, USA
    Sailing 2017: 17 Dec 2018: 14 Jan, 28 Jan, 11 Feb, 25 Feb, 11 Mar, 25 Mar, 8 Apr, 22 Apr, 20 May, 17 Jun, 15 Jul, 12 Aug, 9 Sep, 7 Oct, 28 Oct, 25 Nov, 23 Dec 2019: 20 Jan, 17 Feb, 17 Mar, 14 Apr, 12 May, 9 Jun, 7 Jul, 4 Aug, 1 Sep, 29 Sep, 27 Oct, 10 Nov, 8 Dec 2020: 5 Jan, 2 Feb, 1 Mar, 29 Mar, 26 Apr
    Ports of Call Galveston, Roatan, Costa Maya, Cozumel

    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.

  • Rhapsody, Western Caribbean ex Tampa Roundtrip

    Nights 7 Ship Rhapsody of the Seas
    Star Rating 4 Star Departs Tampa, Florida
    Sailing 2017: 17 Dec 2018: 14 Jan, 21 Jan, 18 Feb, 11 Mar, 18 Mar, 25 Mar, 15 Apr, 22 Apr, 29 Apr, 22 Dec 2019: 5 Jan, 19 Jan, 2 Feb, 16 Feb, 2 Mar, 16 Mar, 30 Mar, 13 Apr
    Ports of Call Tampa, Key West, Cozumel, Belize City, Costa Maya

    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.

  • Empress, Bahamas & Havana ex Miami Return

    Nights 6 Ship Empress of the Seas
    Star Rating Not Rated Departs Miami
    Sailing 2017: 18 Dec
    Ports of Call Miami, Cococay, Key West, Havana
    Please enquire about this cruise for pricing.
  • Brilliance, Western Caribbean ex Tampa Return

    Nights 5 Ship Brilliance of the Seas
    Star Rating 4 Star Departs Tampa, Florida
    Sailing 2017: 18 Dec, 28 Dec 2018: 29 Jan, 26 Feb, 12 Mar, 26 Mar, 17 Sep, 1 Oct, 15 Oct, 29 Oct, 12 Nov, 26 Nov, 10 Dec, 24 Dec 2019: 7 Jan, 18 Feb, 4 Mar, 18 Mar, 1 Apr, 15 Apr, 29 Apr
    Ports of Call Tampa, Key West, Cozumel

    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.

  • Vision, Western Caribbean ex Galveston Return

    Nights 5 Ship Vision of the Seas
    Star Rating 4 Star Departs Galveston, Texas, USA
    Sailing 2017: 18 Dec 2019: 27 Mar, 10 Apr
    Ports of Call Galveston, Progresso, Cozumel

    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.

  • Enchantment, Bahamas Cruise ex Miami Return

    Nights 4 Ship Enchantment of the Seas
    Star Rating 4 Star Departs Miami
    Sailing 2017: 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.

 

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

Total elapsed time: 0.28450655937195

# Query Time
(1) connect 0.00070285797119141
(2) DESCRIBE `cruises` 0.0020129680633545
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (46038, 61238, 55120, 50062, 54749, 63959, 69551, 43401, 64319, 54739)) ORDER BY FIND_IN_SET(id, '46038,61238,55120,50062,54749,63959,69551,43401,64319,54739') 0.0009000301361084
(4) DESCRIBE `cruises` 0.0017988681793213
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '46038') 0.00043511390686035
(6) DESCRIBE `ships` 0.0025029182434082
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 403))) 0.00036001205444336
(8) DESCRIBE `ships` 0.0020639896392822
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '403') 0.00025796890258789
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031495094299316
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022292137145996
(12) DESCRIBE `itineraries` 0.0010321140289307
(13) DESCRIBE `ports` 0.0011389255523682
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00031590461730957
(15) DESCRIBE `ports` 0.00088405609130859
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00034618377685547
(17) DESCRIBE `ports` 0.00093793869018555
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00024604797363281
(19) DESCRIBE `sailingdates` 0.00084280967712402
(20) DESCRIBE `ports` 0.0010831356048584
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00031614303588867
(22) DESCRIBE `ports` 0.00088191032409668
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00023508071899414
(24) DESCRIBE `ports` 0.00090718269348145
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 347))) 0.00026702880859375
(26) DESCRIBE `ports` 0.00087213516235352
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '347') 0.0002281665802002
(28) DESCRIBE `ports` 0.00093197822570801
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00027608871459961
(30) DESCRIBE `ports` 0.00095295906066895
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00025606155395508
(32) DESCRIBE `ports` 0.00093698501586914
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00025796890258789
(34) DESCRIBE `ports` 0.00091099739074707
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00024914741516113
(36) DESCRIBE `ports` 0.00090408325195312
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.0002751350402832
(38) DESCRIBE `ports` 0.00089907646179199
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00028896331787109
(40) DESCRIBE `ports` 0.00092482566833496
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00027680397033691
(42) DESCRIBE `ports` 0.00094413757324219
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00025391578674316
(44) DESCRIBE `ports` 0.00093984603881836
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00027990341186523
(46) DESCRIBE `ports` 0.00095009803771973
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00023484230041504
(48) DESCRIBE `avid_specials` 0.00086498260498047
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 46038 and class = 'Cruise') OR (item_id = 403 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.0017781257629395
(50) DESCRIBE `cruiselines` 0.0012640953063965
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00026583671569824
(52) DESCRIBE `orchid_image` 0.00090813636779785
(53) DESCRIBE `cruiselines` 0.0011270046234131
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00023603439331055
(55) DESCRIBE `cruises` 0.001406192779541
(56) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61238') 0.00029706954956055
(57) DESCRIBE `ships` 0.0013630390167236
(58) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 748))) 0.00028204917907715
(59) DESCRIBE `ships` 0.0013890266418457
(60) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '748') 0.00021004676818848
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019407272338867
(63) DESCRIBE `itineraries` 0.0007178783416748
(64) DESCRIBE `ports` 0.00069499015808105
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00022983551025391
(66) DESCRIBE `ports` 0.00070881843566895
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00020599365234375
(68) DESCRIBE `ports` 0.00069189071655273
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00019288063049316
(70) DESCRIBE `sailingdates` 0.00060915946960449
(71) DESCRIBE `ports` 0.00078296661376953
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00023913383483887
(73) DESCRIBE `ports` 0.00069499015808105
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.0001981258392334
(75) DESCRIBE `ports` 0.00079011917114258
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00021696090698242
(77) DESCRIBE `ports` 0.00068902969360352
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00018501281738281
(79) DESCRIBE `ports` 0.00067591667175293
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0002129077911377
(81) DESCRIBE `ports` 0.0006721019744873
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00018501281738281
(83) DESCRIBE `ports` 0.00066685676574707
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 465))) 0.00020408630371094
(85) DESCRIBE `ports` 0.00066995620727539
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '465') 0.00018692016601562
(87) DESCRIBE `ports` 0.00071501731872559
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00020694732666016
(89) DESCRIBE `ports` 0.00069189071655273
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00018692016601562
(91) DESCRIBE `avid_specials` 0.00064897537231445
(92) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61238 and class = 'Cruise') OR (item_id = 748 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.0010209083557129
(93) DESCRIBE `cruiselines` 0.0011060237884521
(94) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00028896331787109
(95) DESCRIBE `orchid_image` 0.00086188316345215
(96) DESCRIBE `cruiselines` 0.0011630058288574
(97) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00023317337036133
(98) DESCRIBE `cruises` 0.0015377998352051
(99) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55120') 0.00025296211242676
(100) DESCRIBE `ships` 0.0015771389007568
(101) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 526))) 0.00029182434082031
(102) DESCRIBE `ships` 0.0016758441925049
(103) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '526') 0.00021791458129883
(104) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018596649169922
(105) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017189979553223
(106) DESCRIBE `itineraries` 0.00071215629577637
(107) DESCRIBE `ports` 0.00070714950561523
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00023388862609863
(109) DESCRIBE `ports` 0.00067591667175293
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00020384788513184
(111) DESCRIBE `ports` 0.00070691108703613
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00019693374633789
(113) DESCRIBE `sailingdates` 0.00060510635375977
(114) DESCRIBE `ports` 0.0010061264038086
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00024700164794922
(116) DESCRIBE `ports` 0.00072884559631348
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0002129077911377
(118) DESCRIBE `ports` 0.00072598457336426
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00021600723266602
(120) DESCRIBE `ports` 0.0006721019744873
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00018596649169922
(122) DESCRIBE `ports` 0.00067496299743652
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00022697448730469
(124) DESCRIBE `ports` 0.00070405006408691
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00018000602722168
(126) DESCRIBE `ports` 0.00067996978759766
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00020408630371094
(128) DESCRIBE `ports` 0.0006709098815918
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00018596649169922
(130) DESCRIBE `ports` 0.00070905685424805
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00021195411682129
(132) DESCRIBE `ports` 0.00066900253295898
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00018405914306641
(134) DESCRIBE `avid_specials` 0.00062799453735352
(135) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55120 and class = 'Cruise') OR (item_id = 526 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.0010049343109131
(136) DESCRIBE `cruiselines` 0.0010700225830078
(137) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.0003960132598877
(138) DESCRIBE `orchid_image` 0.0010449886322021
(139) DESCRIBE `cruiselines` 0.0011780261993408
(140) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00030803680419922
(141) DESCRIBE `cruises` 0.0016410350799561
(142) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50062') 0.00028204917907715
(143) DESCRIBE `ships` 0.0015699863433838
(144) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 791))) 0.00030088424682617
(145) DESCRIBE `ships` 0.0016169548034668
(146) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '791') 0.00024700164794922
(147) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020003318786621
(148) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018596649169922
(149) DESCRIBE `itineraries` 0.00081515312194824
(150) DESCRIBE `ports` 0.000823974609375
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00027799606323242
(152) DESCRIBE `ports` 0.00072717666625977
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00023293495178223
(154) DESCRIBE `ports` 0.00086092948913574
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00023913383483887
(156) DESCRIBE `sailingdates` 0.00076985359191895
(157) DESCRIBE `ports` 0.00089621543884277
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.000244140625
(159) DESCRIBE `ports` 0.00073099136352539
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00019288063049316
(161) DESCRIBE `ports` 0.00077295303344727
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 465))) 0.00023293495178223
(163) DESCRIBE `ports` 0.00082993507385254
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '465') 0.00019288063049316
(165) DESCRIBE `ports` 0.00067305564880371
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3563))) 0.0001978874206543
(167) DESCRIBE `ports` 0.00072598457336426
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3563') 0.00018000602722168
(169) DESCRIBE `ports` 0.00066494941711426
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.0002140998840332
(171) DESCRIBE `ports` 0.00066399574279785
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00020813941955566
(173) DESCRIBE `ports` 0.00068998336791992
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00020408630371094
(175) DESCRIBE `ports` 0.00070381164550781
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00018477439880371
(177) DESCRIBE `avid_specials` 0.00065088272094727
(178) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 50062 and class = 'Cruise') OR (item_id = 791 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.0012130737304688
(179) DESCRIBE `cruiselines` 0.0010101795196533
(180) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00028491020202637
(181) DESCRIBE `orchid_image` 0.00089883804321289
(182) DESCRIBE `cruiselines` 0.0010011196136475
(183) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00023698806762695
(184) DESCRIBE `cruises` 0.0014331340789795
(185) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '54749') 0.00024604797363281
(186) DESCRIBE `ships` 0.001439094543457
(187) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 590))) 0.00026702880859375
(188) DESCRIBE `ships` 0.0014197826385498
(189) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '590') 0.00020194053649902
(190) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018811225891113
(191) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017189979553223
(192) DESCRIBE `itineraries` 0.00069403648376465
(193) DESCRIBE `ports` 0.00075507164001465
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.0002598762512207
(195) DESCRIBE `ports` 0.00069785118103027
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00027704238891602
(197) DESCRIBE `ports` 0.00069093704223633
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00019407272338867
(199) DESCRIBE `sailingdates` 0.00066518783569336
(200) DESCRIBE `ports` 0.001060962677002
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00025796890258789
(202) DESCRIBE `ports` 0.00075292587280273
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00021600723266602
(204) DESCRIBE `ports` 0.0007479190826416
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00022196769714355
(206) DESCRIBE `ports` 0.00079202651977539
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00029706954956055
(208) DESCRIBE `ports` 0.000946044921875
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00028300285339355
(210) DESCRIBE `ports` 0.0010240077972412
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.0002589225769043
(212) DESCRIBE `ports` 0.00089406967163086
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00030112266540527
(214) DESCRIBE `ports` 0.00097393989562988
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00025701522827148
(216) DESCRIBE `ports` 0.00099706649780273
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00031018257141113
(218) DESCRIBE `ports` 0.0010499954223633
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00026512145996094
(220) DESCRIBE `avid_specials` 0.0010671615600586
(221) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 54749 and class = 'Cruise') OR (item_id = 590 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.0017929077148438
(222) DESCRIBE `cruiselines` 0.0017080307006836
(223) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.0003969669342041
(224) DESCRIBE `orchid_image` 0.0012519359588623
(225) DESCRIBE `cruiselines` 0.0010530948638916
(226) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00028300285339355
(227) DESCRIBE `cruises` 0.002039909362793
(228) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63959') 0.00037097930908203
(229) DESCRIBE `ships` 0.0021989345550537
(230) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 119))) 0.00039982795715332
(231) DESCRIBE `ships` 0.0023300647735596
(232) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '119') 0.0003199577331543
(233) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.000244140625
(234) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023603439331055
(235) DESCRIBE `itineraries` 0.0012140274047852
(236) DESCRIBE `ports` 0.0011429786682129
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.0003349781036377
(238) DESCRIBE `ports` 0.00105881690979
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00026798248291016
(240) DESCRIBE `ports` 0.00094699859619141
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00026106834411621
(242) DESCRIBE `sailingdates` 0.00085902214050293
(243) DESCRIBE `ports` 0.001244068145752
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00037884712219238
(245) DESCRIBE `ports` 0.0012199878692627
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00028681755065918
(247) DESCRIBE `ports` 0.00081801414489746
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00022196769714355
(249) DESCRIBE `ports` 0.0006871223449707
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00018692016601562
(251) DESCRIBE `ports` 0.00071811676025391
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00020885467529297
(253) DESCRIBE `ports` 0.00071597099304199
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00018906593322754
(255) DESCRIBE `ports` 0.00073409080505371
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.0002140998840332
(257) DESCRIBE `ports` 0.000762939453125
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00020408630371094
(259) DESCRIBE `ports` 0.00069189071655273
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.0001981258392334
(261) DESCRIBE `ports` 0.00089621543884277
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00018191337585449
(263) DESCRIBE `ports` 0.00069999694824219
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00021815299987793
(265) DESCRIBE `ports` 0.00069594383239746
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00018501281738281
(267) DESCRIBE `avid_specials` 0.00064301490783691
(268) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63959 and class = 'Cruise') OR (item_id = 119 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.0010578632354736
(269) DESCRIBE `cruiselines` 0.0010960102081299
(270) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00024199485778809
(271) DESCRIBE `orchid_image` 0.0010170936584473
(272) DESCRIBE `cruiselines` 0.00097298622131348
(273) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00022602081298828
(274) DESCRIBE `cruises` 0.0013680458068848
(275) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69551') 0.00026893615722656
(276) DESCRIBE `ships` 0.0014889240264893
(277) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1571))) 0.00027799606323242
(278) DESCRIBE `ships` 0.001323938369751
(279) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1571') 0.00019979476928711
(280) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00018692016601562
(281) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00017404556274414
(282) DESCRIBE `itineraries` 0.00074005126953125
(283) DESCRIBE `ports` 0.00075793266296387
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00030708312988281
(285) DESCRIBE `ports` 0.0006868839263916
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020599365234375
(287) DESCRIBE `ports` 0.00068902969360352
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00021195411682129
(289) DESCRIBE `sailingdates` 0.00087404251098633
(290) DESCRIBE `ports` 0.00091004371643066
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00025796890258789
(292) DESCRIBE `ports` 0.00075197219848633
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00020885467529297
(294) DESCRIBE `ports` 0.00075101852416992
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.00021600723266602
(296) DESCRIBE `ports` 0.00069189071655273
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.00019097328186035
(298) DESCRIBE `ports` 0.00072383880615234
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00020980834960938
(300) DESCRIBE `ports` 0.00076413154602051
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00022602081298828
(302) DESCRIBE `ports` 0.00075197219848633
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0002598762512207
(304) DESCRIBE `ports` 0.00075006484985352
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00023388862609863
(306) DESCRIBE `ports` 0.00086402893066406
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.000244140625
(308) DESCRIBE `ports` 0.00079703330993652
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00018119812011719
(310) DESCRIBE `ports` 0.00066995620727539
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00021100044250488
(312) DESCRIBE `ports` 0.00072002410888672
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00018787384033203
(314) DESCRIBE `avid_specials` 0.00065016746520996
(315) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69551 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.0010511875152588
(316) DESCRIBE `cruiselines` 0.00099515914916992
(317) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00023198127746582
(318) DESCRIBE `orchid_image` 0.00076413154602051
(319) DESCRIBE `cruiselines` 0.0009610652923584
(320) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00021195411682129
(321) DESCRIBE `cruises` 0.0013749599456787
(322) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '43401') 0.00025296211242676
(323) DESCRIBE `ships` 0.0013501644134521
(324) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 285))) 0.00025200843811035
(325) DESCRIBE `ships` 0.0013530254364014
(326) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '285') 0.00019621849060059
(327) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018215179443359
(328) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016999244689941
(329) DESCRIBE `itineraries` 0.00071215629577637
(330) DESCRIBE `ports` 0.00084209442138672
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00036406517028809
(332) DESCRIBE `ports` 0.00085806846618652
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00021100044250488
(334) DESCRIBE `ports` 0.00068116188049316
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00020790100097656
(336) DESCRIBE `sailingdates` 0.00061893463134766
(337) DESCRIBE `ports` 0.00079202651977539
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00023388862609863
(339) DESCRIBE `ports` 0.00069999694824219
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00020003318786621
(341) DESCRIBE `ports` 0.00072407722473145
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00021696090698242
(343) DESCRIBE `ports` 0.00070095062255859
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00019097328186035
(345) DESCRIBE `ports` 0.0006718635559082
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00021195411682129
(347) DESCRIBE `ports` 0.00071597099304199
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00019097328186035
(349) DESCRIBE `ports` 0.00070500373840332
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.0002741813659668
(351) DESCRIBE `ports` 0.00077700614929199
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00020503997802734
(353) DESCRIBE `avid_specials` 0.00069212913513184
(354) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 43401 and class = 'Cruise') OR (item_id = 285 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.0011601448059082
(355) DESCRIBE `cruiselines` 0.0011160373687744
(356) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00023508071899414
(357) DESCRIBE `orchid_image` 0.00076794624328613
(358) DESCRIBE `cruiselines` 0.00094890594482422
(359) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00020408630371094
(360) DESCRIBE `cruises` 0.0014700889587402
(361) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64319') 0.00022578239440918
(362) DESCRIBE `ships` 0.0013868808746338
(363) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 123))) 0.00025200843811035
(364) DESCRIBE `ships` 0.0014529228210449
(365) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '123') 0.00019216537475586
(366) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021982192993164
(367) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017189979553223
(368) DESCRIBE `itineraries` 0.00071287155151367
(369) DESCRIBE `ports` 0.00069308280944824
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00022292137145996
(371) DESCRIBE `ports` 0.00092816352844238
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00020313262939453
(373) DESCRIBE `ports` 0.00069785118103027
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00020909309387207
(375) DESCRIBE `sailingdates` 0.00061202049255371
(376) DESCRIBE `ports` 0.00093388557434082
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00022506713867188
(378) DESCRIBE `ports` 0.00069379806518555
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00018787384033203
(380) DESCRIBE `ports` 0.00092601776123047
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2298))) 0.00025010108947754
(382) DESCRIBE `ports` 0.00096988677978516
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2298') 0.00023508071899414
(384) DESCRIBE `ports` 0.0010788440704346
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00028300285339355
(386) DESCRIBE `ports` 0.00098800659179688
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00028204917907715
(388) DESCRIBE `ports` 0.00098395347595215
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00027203559875488
(390) DESCRIBE `ports` 0.0009770393371582
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00024890899658203
(392) DESCRIBE `avid_specials` 0.00087809562683105
(393) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64319 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.0017790794372559
(394) DESCRIBE `cruiselines` 0.0014529228210449
(395) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00030708312988281
(396) DESCRIBE `orchid_image` 0.0011439323425293
(397) DESCRIBE `cruiselines` 0.0014078617095947
(398) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00026106834411621
(399) DESCRIBE `cruises` 0.0020620822906494
(400) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '54739') 0.00030517578125
(401) DESCRIBE `ships` 0.002100944519043
(402) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 113))) 0.00036787986755371
(403) DESCRIBE `ships` 0.001816987991333
(404) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '113') 0.00021100044250488
(405) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018405914306641
(406) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017499923706055
(407) DESCRIBE `itineraries` 0.00067996978759766
(408) DESCRIBE `ports` 0.00079584121704102
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00025105476379395
(410) DESCRIBE `ports` 0.00075912475585938
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020384788513184
(412) DESCRIBE `ports` 0.0006709098815918
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00019311904907227
(414) DESCRIBE `sailingdates` 0.0006110668182373
(415) DESCRIBE `ports` 0.00093913078308105
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00025391578674316
(417) DESCRIBE `ports` 0.00069594383239746
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0001990795135498
(419) DESCRIBE `ports` 0.00069403648376465
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00020885467529297
(421) DESCRIBE `ports` 0.00066804885864258
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00018215179443359
(423) DESCRIBE `ports` 0.0006718635559082
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.00020098686218262
(425) DESCRIBE `ports` 0.00066494941711426
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.0001828670501709
(427) DESCRIBE `ports` 0.00066614151000977
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00020885467529297
(429) DESCRIBE `ports` 0.00066304206848145
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00018191337585449
(431) DESCRIBE `ports` 0.00066709518432617
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020384788513184
(433) DESCRIBE `ports` 0.00066089630126953
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00018596649169922
(435) DESCRIBE `avid_specials` 0.00064802169799805
(436) 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.0010139942169189
(437) DESCRIBE `cruiselines` 0.00098013877868652
(438) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00021505355834961
(439) DESCRIBE `orchid_image` 0.00075888633728027
(440) DESCRIBE `cruiselines` 0.0009310245513916
(441) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00021719932556152
(442) DESCRIBE `ships` 0.0016109943389893
(443) SELECT `ships`.* FROM `ships` WHERE (id IN ('393', '113', '330', '791', '1323', '590', '526', '1586', '116', '1571', '286', '124', '1236', '114', '1141', '285', '658', '748', '119', '403', '123', '1330', '262', '287', '389')) ORDER BY FIND_IN_SET(id, '393,113,330,791,1323,590,526,1586,116,1571,286,124,1236,114,1141,285,658,748,119,403,123,1330,262,287,389') 0.0011460781097412
(444) DESCRIBE `cruisetypes` 0.00083088874816895
(445) DESCRIBE `destinations` 0.00095200538635254
(446) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '9', '35', '22', '43', '10', '11', '2', '26', '8', '28', '38', '25', '34', '21', '29', '48')) ORDER BY FIND_IN_SET(id, '12,9,35,22,43,10,11,2,26,8,28,38,25,34,21,29,48') 0.00083684921264648
(447) DESCRIBE `cruiselines` 0.001392126083374
(448) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.0002899169921875
(449) DESCRIBE `cruiselines` 0.001215934753418
(450) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00026297569274902