or, enquire about your chosen options

  1. Carnival Cruise Line teams up with Harlem Globetrotters
  2. Ultra-Luxury Cruising
  3. The Caribbean is still a Preferred Cruise Destination
  4. Catch Up on Cruising: Latest News in bite size!
  5. 8 Romantic Destinations Around the World

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

 
 

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

Total elapsed time: 0.99853444099426

# Query Time
(1) connect 0.00095891952514648
(2) DESCRIBE `cruises` 0.004403829574585
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (85106, 76370, 76214, 76406, 61411, 76353, 72818, 76352, 61419, 76401)) ORDER BY FIND_IN_SET(id, '85106,76370,76214,76406,61411,76353,72818,76352,61419,76401') 0.0025150775909424
(4) DESCRIBE `cruises` 0.0042300224304199
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '85106') 0.00040793418884277
(6) DESCRIBE `ships` 0.0033879280090332
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1108))) 0.00043606758117676
(8) DESCRIBE `ships` 0.003896951675415
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1108') 0.00038790702819824
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003509521484375
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037598609924316
(12) DESCRIBE `itineraries` 0.0017189979553223
(13) DESCRIBE `ports` 0.0017549991607666
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00041818618774414
(15) DESCRIBE `ports` 0.0019102096557617
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00039982795715332
(17) DESCRIBE `ports` 0.0020711421966553
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00056195259094238
(19) DESCRIBE `sailingdates` 0.0019428730010986
(20) DESCRIBE `ports` 0.0020608901977539
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00055789947509766
(22) DESCRIBE `ports` 0.0018119812011719
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00039792060852051
(24) DESCRIBE `ports` 0.0022327899932861
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00037789344787598
(26) DESCRIBE `ports` 0.0017340183258057
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00035214424133301
(28) DESCRIBE `ports` 0.0018258094787598
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4949))) 0.00040316581726074
(30) DESCRIBE `ports` 0.0017440319061279
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4949') 0.00054287910461426
(32) DESCRIBE `ports` 0.0017452239990234
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00039196014404297
(34) DESCRIBE `ports` 0.0017569065093994
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00036382675170898
(36) DESCRIBE `ports` 0.0023539066314697
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00040698051452637
(38) DESCRIBE `ports` 0.0018360614776611
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.0003659725189209
(40) DESCRIBE `ports` 0.0017189979553223
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00040006637573242
(42) DESCRIBE `ports` 0.0018019676208496
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00037789344787598
(44) DESCRIBE `avid_specials` 0.001568078994751
(45) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 85106 and class = 'Cruise') OR (item_id = 1108 AND class = 'Ship') OR (item_id = 91 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.0011880397796631
(46) DESCRIBE `cruiselines` 0.0027561187744141
(47) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00051689147949219
(48) DESCRIBE `orchid_image` 0.0021889209747314
(49) DESCRIBE `cruiselines` 0.0025680065155029
(50) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00039100646972656
(51) DESCRIBE `cruises` 0.0032820701599121
(52) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76370') 0.0005638599395752
(53) DESCRIBE `ships` 0.0033609867095947
(54) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 508))) 0.00044107437133789
(55) DESCRIBE `ships` 0.0034470558166504
(56) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '508') 0.00044798851013184
(57) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034880638122559
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033783912658691
(59) DESCRIBE `itineraries` 0.0017189979553223
(60) DESCRIBE `ports` 0.0017688274383545
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00049304962158203
(62) DESCRIBE `ports` 0.0019030570983887
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00040507316589355
(64) DESCRIBE `ports` 0.0017290115356445
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00037503242492676
(66) DESCRIBE `sailingdates` 0.0015900135040283
(67) DESCRIBE `ports` 0.0018689632415771
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00045895576477051
(69) DESCRIBE `ports` 0.0019679069519043
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00045299530029297
(71) DESCRIBE `ports` 0.0017259120941162
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00038790702819824
(73) DESCRIBE `ports` 0.0017328262329102
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00036382675170898
(75) DESCRIBE `ports` 0.0018570423126221
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 534))) 0.0003819465637207
(77) DESCRIBE `ports` 0.0018041133880615
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '534') 0.00036406517028809
(79) DESCRIBE `ports` 0.0017390251159668
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 205))) 0.00045490264892578
(81) DESCRIBE `ports` 0.0017971992492676
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '205') 0.00038599967956543
(83) DESCRIBE `ports` 0.0018320083618164
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 205))) 0.0003819465637207
(85) DESCRIBE `ports` 0.0017890930175781
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '205') 0.00036287307739258
(87) DESCRIBE `ports` 0.0017490386962891
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.0003659725189209
(89) DESCRIBE `ports` 0.0018389225006104
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00034904479980469
(91) DESCRIBE `ports` 0.0018939971923828
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 429))) 0.00038504600524902
(93) DESCRIBE `ports` 0.0017368793487549
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '429') 0.0003969669342041
(95) DESCRIBE `ports` 0.001723051071167
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 429))) 0.00037789344787598
(97) DESCRIBE `ports` 0.0020051002502441
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '429') 0.00036191940307617
(99) DESCRIBE `ports` 0.0017819404602051
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00037908554077148
(101) DESCRIBE `ports` 0.0018939971923828
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00036191940307617
(103) DESCRIBE `ports` 0.0018482208251953
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 609))) 0.00040197372436523
(105) DESCRIBE `ports` 0.0017638206481934
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '609') 0.00049018859863281
(107) DESCRIBE `ports` 0.0021390914916992
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00045990943908691
(109) DESCRIBE `ports` 0.0018508434295654
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00036811828613281
(111) DESCRIBE `ports` 0.0017549991607666
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1726))) 0.00041699409484863
(113) DESCRIBE `ports` 0.0018749237060547
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1726') 0.00036096572875977
(115) DESCRIBE `ports` 0.0017349720001221
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00041604042053223
(117) DESCRIBE `ports` 0.0018270015716553
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00036907196044922
(119) DESCRIBE `avid_specials` 0.0017020702362061
(120) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76370 and class = 'Cruise') OR (item_id = 508 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 45 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.001190185546875
(121) DESCRIBE `cruiselines` 0.0024738311767578
(122) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00039100646972656
(123) DESCRIBE `orchid_image` 0.002079963684082
(124) DESCRIBE `cruiselines` 0.002561092376709
(125) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.0003819465637207
(126) DESCRIBE `cruises` 0.0032989978790283
(127) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76214') 0.00041913986206055
(128) DESCRIBE `ships` 0.0034539699554443
(129) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 394))) 0.0004432201385498
(130) DESCRIBE `ships` 0.003680944442749
(131) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '394') 0.00037479400634766
(132) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035595893859863
(133) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034594535827637
(134) DESCRIBE `itineraries` 0.0017459392547607
(135) DESCRIBE `ports` 0.001755952835083
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00040388107299805
(137) DESCRIBE `ports` 0.0017280578613281
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00058293342590332
(139) DESCRIBE `ports` 0.0019478797912598
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00038290023803711
(141) DESCRIBE `sailingdates` 0.0018270015716553
(142) DESCRIBE `ports` 0.002025842666626
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00042295455932617
(144) DESCRIBE `ports` 0.0023391246795654
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.0005028247833252
(146) DESCRIBE `ports` 0.0020182132720947
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00040602684020996
(148) DESCRIBE `ports` 0.0018789768218994
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00044989585876465
(150) DESCRIBE `ports` 0.0017580986022949
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00039410591125488
(152) DESCRIBE `ports` 0.0021829605102539
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00037598609924316
(154) DESCRIBE `ports` 0.0019428730010986
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 86))) 0.00042104721069336
(156) DESCRIBE `ports` 0.0018341541290283
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '86') 0.00040912628173828
(158) DESCRIBE `ports` 0.0017509460449219
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00051712989807129
(160) DESCRIBE `ports` 0.0019140243530273
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00036096572875977
(162) DESCRIBE `ports` 0.0018510818481445
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 511))) 0.00042200088500977
(164) DESCRIBE `ports` 0.00199294090271
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '511') 0.00055909156799316
(166) DESCRIBE `ports` 0.0019309520721436
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 79))) 0.00039982795715332
(168) DESCRIBE `ports` 0.0018558502197266
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '79') 0.00037407875061035
(170) DESCRIBE `ports` 0.0018038749694824
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00041508674621582
(172) DESCRIBE `ports` 0.0018939971923828
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.0003819465637207
(174) DESCRIBE `ports` 0.0018479824066162
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00042200088500977
(176) DESCRIBE `ports` 0.0020239353179932
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00037693977355957
(178) DESCRIBE `ports` 0.0018701553344727
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00039792060852051
(180) DESCRIBE `ports` 0.0019130706787109
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00037693977355957
(182) DESCRIBE `ports` 0.0020389556884766
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00042009353637695
(184) DESCRIBE `ports` 0.001896858215332
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00038504600524902
(186) DESCRIBE `ports` 0.002051830291748
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046896934509277
(188) DESCRIBE `ports` 0.0017590522766113
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042390823364258
(190) DESCRIBE `avid_specials` 0.0017080307006836
(191) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76214 and class = 'Cruise') OR (item_id = 394 AND class = 'Ship') OR (item_id = 91 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.0011940002441406
(192) DESCRIBE `cruiselines` 0.0025019645690918
(193) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00048518180847168
(194) DESCRIBE `orchid_image` 0.0019729137420654
(195) DESCRIBE `cruiselines` 0.0028789043426514
(196) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00039005279541016
(197) DESCRIBE `cruises` 0.0033230781555176
(198) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76406') 0.00040602684020996
(199) DESCRIBE `ships` 0.0034348964691162
(200) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.00058197975158691
(201) DESCRIBE `ships` 0.0036590099334717
(202) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.00049781799316406
(203) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035691261291504
(204) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034713745117188
(205) DESCRIBE `itineraries` 0.001737117767334
(206) DESCRIBE `ports` 0.0022850036621094
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00051212310791016
(208) DESCRIBE `ports` 0.0021209716796875
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00052404403686523
(210) DESCRIBE `ports` 0.0017671585083008
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00041317939758301
(212) DESCRIBE `sailingdates` 0.0018808841705322
(213) DESCRIBE `ports` 0.0018880367279053
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046896934509277
(215) DESCRIBE `ports` 0.0018200874328613
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00039911270141602
(217) DESCRIBE `ports` 0.0017719268798828
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00040006637573242
(219) DESCRIBE `ports` 0.0018188953399658
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00037693977355957
(221) DESCRIBE `ports` 0.0023691654205322
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00043797492980957
(223) DESCRIBE `ports` 0.0023641586303711
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00039982795715332
(225) DESCRIBE `ports` 0.001755952835083
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00042080879211426
(227) DESCRIBE `ports` 0.0019030570983887
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00056004524230957
(229) DESCRIBE `ports` 0.0017940998077393
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1637))) 0.00043606758117676
(231) DESCRIBE `ports` 0.0020849704742432
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1637') 0.00040292739868164
(233) DESCRIBE `ports` 0.0019381046295166
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.00041103363037109
(235) DESCRIBE `ports` 0.0020079612731934
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.00044798851013184
(237) DESCRIBE `ports` 0.0019741058349609
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2863))) 0.00040602684020996
(239) DESCRIBE `ports` 0.0019879341125488
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2863') 0.00044679641723633
(241) DESCRIBE `ports` 0.0018680095672607
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.00040388107299805
(243) DESCRIBE `ports` 0.0019497871398926
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.00038385391235352
(245) DESCRIBE `ports` 0.0017988681793213
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2131))) 0.00042390823364258
(247) DESCRIBE `ports` 0.0019428730010986
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2131') 0.00040602684020996
(249) DESCRIBE `ports` 0.0018661022186279
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00038695335388184
(251) DESCRIBE `ports` 0.0017490386962891
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00035905838012695
(253) DESCRIBE `ports` 0.001737117767334
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00039792060852051
(255) DESCRIBE `ports` 0.0018119812011719
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00037312507629395
(257) DESCRIBE `ports` 0.0018880367279053
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00041413307189941
(259) DESCRIBE `ports` 0.0017271041870117
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00037193298339844
(261) DESCRIBE `ports` 0.0017318725585938
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2129))) 0.00038886070251465
(263) DESCRIBE `ports` 0.0018479824066162
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2129') 0.0003809928894043
(265) DESCRIBE `ports` 0.0017359256744385
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 331))) 0.0003969669342041
(267) DESCRIBE `ports` 0.0019009113311768
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '331') 0.00037693977355957
(269) DESCRIBE `ports` 0.0021140575408936
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00039792060852051
(271) DESCRIBE `ports` 0.0020689964294434
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00038385391235352
(273) DESCRIBE `ports` 0.0017688274383545
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2224))) 0.00039911270141602
(275) DESCRIBE `ports` 0.0018899440765381
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2224') 0.00040483474731445
(277) DESCRIBE `ports` 0.0018520355224609
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1655))) 0.00041294097900391
(279) DESCRIBE `ports` 0.00177001953125
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1655') 0.00037789344787598
(281) DESCRIBE `ports` 0.0024230480194092
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00045609474182129
(283) DESCRIBE `ports` 0.0018060207366943
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00037789344787598
(285) DESCRIBE `avid_specials` 0.00154709815979
(286) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76406 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 48 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.0011818408966064
(287) DESCRIBE `cruiselines` 0.0031039714813232
(288) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00049400329589844
(289) DESCRIBE `orchid_image` 0.0021209716796875
(290) DESCRIBE `cruiselines` 0.0025451183319092
(291) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00041317939758301
(292) DESCRIBE `cruises` 0.0033209323883057
(293) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61411') 0.0004119873046875
(294) DESCRIBE `ships` 0.0036039352416992
(295) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.00055789947509766
(296) DESCRIBE `ships` 0.0037980079650879
(297) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.00072002410888672
(298) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035786628723145
(299) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034713745117188
(300) DESCRIBE `itineraries` 0.0018310546875
(301) DESCRIBE `ports` 0.0018899440765381
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00051593780517578
(303) DESCRIBE `ports` 0.001751184463501
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00041890144348145
(305) DESCRIBE `ports` 0.0018150806427002
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00039887428283691
(307) DESCRIBE `sailingdates` 0.0016078948974609
(308) DESCRIBE `ports` 0.0018930435180664
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00050592422485352
(310) DESCRIBE `ports` 0.0017380714416504
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00039196014404297
(312) DESCRIBE `ports` 0.0017910003662109
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00051689147949219
(314) DESCRIBE `ports` 0.0020179748535156
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00037503242492676
(316) DESCRIBE `ports` 0.0017960071563721
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00039482116699219
(318) DESCRIBE `ports` 0.0017449855804443
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00037789344787598
(320) DESCRIBE `ports` 0.0019941329956055
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00044989585876465
(322) DESCRIBE `ports` 0.0018610954284668
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00040411949157715
(324) DESCRIBE `ports` 0.001755952835083
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1637))) 0.00040292739868164
(326) DESCRIBE `ports` 0.001953125
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1637') 0.00037002563476562
(328) DESCRIBE `ports` 0.0018520355224609
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.00041103363037109
(330) DESCRIBE `ports` 0.0017311573028564
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.00044608116149902
(332) DESCRIBE `ports` 0.0018620491027832
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2863))) 0.00039410591125488
(334) DESCRIBE `ports` 0.0017712116241455
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2863') 0.00037193298339844
(336) DESCRIBE `ports` 0.0019118785858154
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.00039219856262207
(338) DESCRIBE `ports` 0.0017712116241455
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.00037789344787598
(340) DESCRIBE `ports` 0.0017650127410889
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2131))) 0.00050091743469238
(342) DESCRIBE `ports` 0.0018658638000488
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2131') 0.00037503242492676
(344) DESCRIBE `ports` 0.001823902130127
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.0005190372467041
(346) DESCRIBE `ports` 0.0018110275268555
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00036311149597168
(348) DESCRIBE `ports` 0.0017740726470947
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00039911270141602
(350) DESCRIBE `ports` 0.0017788410186768
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00037193298339844
(352) DESCRIBE `ports` 0.0017809867858887
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00054812431335449
(354) DESCRIBE `ports` 0.0018508434295654
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00037908554077148
(356) DESCRIBE `avid_specials` 0.0015439987182617
(357) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61411 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 48 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.001305103302002
(358) DESCRIBE `cruiselines` 0.0028729438781738
(359) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00049877166748047
(360) DESCRIBE `orchid_image` 0.0021491050720215
(361) DESCRIBE `cruiselines` 0.0028228759765625
(362) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00059700012207031
(363) DESCRIBE `cruises` 0.003432035446167
(364) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76353') 0.00042104721069336
(365) DESCRIBE `ships` 0.0034229755401611
(366) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.00044989585876465
(367) DESCRIBE `ships` 0.0051398277282715
(368) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.00040602684020996
(369) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0004270076751709
(370) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00041699409484863
(371) DESCRIBE `itineraries` 0.0018579959869385
(372) DESCRIBE `ports` 0.0018529891967773
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00044512748718262
(374) DESCRIBE `ports` 0.0018000602722168
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00053596496582031
(376) DESCRIBE `ports` 0.0018000602722168
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00038790702819824
(378) DESCRIBE `sailingdates` 0.0015528202056885
(379) DESCRIBE `ports` 0.0018229484558105
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00040698051452637
(381) DESCRIBE `ports` 0.0017740726470947
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00037693977355957
(383) DESCRIBE `ports` 0.0018408298492432
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 598))) 0.00046896934509277
(385) DESCRIBE `ports` 0.0017309188842773
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '598') 0.00039196014404297
(387) DESCRIBE `ports` 0.0018548965454102
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 601))) 0.00040483474731445
(389) DESCRIBE `ports` 0.0017499923706055
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '601') 0.00037908554077148
(391) DESCRIBE `ports` 0.0018100738525391
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 705))) 0.00037908554077148
(393) DESCRIBE `ports` 0.0019431114196777
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '705') 0.00044488906860352
(395) DESCRIBE `ports` 0.0018191337585449
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 321))) 0.0003960132598877
(397) DESCRIBE `ports` 0.0017259120941162
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '321') 0.00040698051452637
(399) DESCRIBE `ports` 0.0018410682678223
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00039196014404297
(401) DESCRIBE `ports` 0.0023088455200195
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00038599967956543
(403) DESCRIBE `ports` 0.0018179416656494
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00040984153747559
(405) DESCRIBE `ports` 0.0018610954284668
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00038003921508789
(407) DESCRIBE `ports` 0.0018160343170166
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00039505958557129
(409) DESCRIBE `ports` 0.0020811557769775
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00041103363037109
(411) DESCRIBE `ports` 0.0017869472503662
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 770))) 0.00044703483581543
(413) DESCRIBE `ports` 0.0017399787902832
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '770') 0.00037813186645508
(415) DESCRIBE `ports` 0.0020430088043213
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2470))) 0.00043082237243652
(417) DESCRIBE `ports` 0.0017850399017334
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2470') 0.00037693977355957
(419) DESCRIBE `ports` 0.0019230842590332
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1873))) 0.00064206123352051
(421) DESCRIBE `ports` 0.0018529891967773
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1873') 0.00039792060852051
(423) DESCRIBE `ports` 0.0018260478973389
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00041317939758301
(425) DESCRIBE `ports` 0.0018880367279053
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00039887428283691
(427) DESCRIBE `ports` 0.0018329620361328
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1743))) 0.00045514106750488
(429) DESCRIBE `ports` 0.0023870468139648
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1743') 0.00059103965759277
(431) DESCRIBE `ports` 0.002377986907959
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1780))) 0.00061702728271484
(433) DESCRIBE `ports` 0.0024149417877197
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1780') 0.00060391426086426
(435) DESCRIBE `ports` 0.0023939609527588
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1150))) 0.0005950927734375
(437) DESCRIBE `ports` 0.0024402141571045
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1150') 0.00055694580078125
(439) DESCRIBE `ports` 0.0017929077148438
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00051712989807129
(441) DESCRIBE `ports` 0.0018281936645508
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00038599967956543
(443) DESCRIBE `ports` 0.0018188953399658
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00040411949157715
(445) DESCRIBE `ports` 0.0017578601837158
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00041484832763672
(447) DESCRIBE `ports` 0.0017600059509277
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00040602684020996
(449) DESCRIBE `ports` 0.0018448829650879
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00039005279541016
(451) DESCRIBE `avid_specials` 0.0015490055084229
(452) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76353 and class = 'Cruise') OR (item_id = 850 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 38 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.0011630058288574
(453) DESCRIBE `cruiselines` 0.0025489330291748
(454) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00042295455932617
(455) DESCRIBE `orchid_image` 0.0027551651000977
(456) DESCRIBE `cruiselines` 0.0030460357666016
(457) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00041890144348145
(458) DESCRIBE `cruises` 0.0036211013793945
(459) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72818') 0.0006098747253418
(460) DESCRIBE `ships` 0.0037310123443604
(461) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1108))) 0.00058388710021973
(462) DESCRIBE `ships` 0.0038459300994873
(463) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1108') 0.00063896179199219
(464) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037312507629395
(465) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035214424133301
(466) DESCRIBE `itineraries` 0.0020229816436768
(467) DESCRIBE `ports` 0.0021510124206543
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046801567077637
(469) DESCRIBE `ports` 0.0020880699157715
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00042009353637695
(471) DESCRIBE `ports` 0.0018000602722168
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00046992301940918
(473) DESCRIBE `sailingdates` 0.001655101776123
(474) DESCRIBE `ports` 0.0018279552459717
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046110153198242
(476) DESCRIBE `ports` 0.002065896987915
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00040602684020996
(478) DESCRIBE `ports` 0.0019800662994385
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00048995018005371
(480) DESCRIBE `ports` 0.002028226852417
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00045990943908691
(482) DESCRIBE `ports` 0.0020148754119873
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00040602684020996
(484) DESCRIBE `ports` 0.002392053604126
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00041103363037109
(486) DESCRIBE `ports` 0.0024421215057373
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 55))) 0.00055503845214844
(488) DESCRIBE `ports` 0.0023112297058105
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '55') 0.00052404403686523
(490) DESCRIBE `ports` 0.002277135848999
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00051999092102051
(492) DESCRIBE `ports` 0.0022590160369873
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00048112869262695
(494) DESCRIBE `ports` 0.0022859573364258
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 310))) 0.00050997734069824
(496) DESCRIBE `ports` 0.0022718906402588
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '310') 0.00048494338989258
(498) DESCRIBE `ports` 0.0026028156280518
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 311))) 0.00049209594726562
(500) DESCRIBE `ports` 0.0022170543670654
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '311') 0.00046181678771973
(502) DESCRIBE `ports` 0.0021798610687256
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 312))) 0.00051188468933105
(504) DESCRIBE `ports` 0.0021970272064209
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '312') 0.00046086311340332
(506) DESCRIBE `ports` 0.002180814743042
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 312))) 0.00055789947509766
(508) DESCRIBE `ports` 0.002202033996582
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '312') 0.00063800811767578
(510) DESCRIBE `ports` 0.0022709369659424
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3686))) 0.00065302848815918
(512) DESCRIBE `ports` 0.0023050308227539
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3686') 0.00054502487182617
(514) DESCRIBE `ports` 0.0022249221801758
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 672))) 0.0005030632019043
(516) DESCRIBE `ports` 0.0021839141845703
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '672') 0.00049400329589844
(518) DESCRIBE `ports` 0.0022339820861816
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00053286552429199
(520) DESCRIBE `ports` 0.0023860931396484
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00050187110900879
(522) DESCRIBE `ports` 0.0022869110107422
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2286))) 0.00051593780517578
(524) DESCRIBE `ports` 0.0024318695068359
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2286') 0.00047898292541504
(526) DESCRIBE `ports` 0.0022420883178711
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00050687789916992
(528) DESCRIBE `ports` 0.0023119449615479
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00051784515380859
(530) DESCRIBE `ports` 0.0023870468139648
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00050497055053711
(532) DESCRIBE `ports` 0.0022737979888916
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00045895576477051
(534) DESCRIBE `ports` 0.0022261142730713
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00053596496582031
(536) DESCRIBE `ports` 0.0022649765014648
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00046300888061523
(538) DESCRIBE `ports` 0.0023720264434814
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4467))) 0.00073814392089844
(540) DESCRIBE `ports` 0.0019791126251221
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4467') 0.00047111511230469
(542) DESCRIBE `ports` 0.0018200874328613
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00045299530029297
(544) DESCRIBE `ports` 0.00193190574646
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00044894218444824
(546) DESCRIBE `avid_specials` 0.0020301342010498
(547) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72818 and class = 'Cruise') OR (item_id = 1108 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 55 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.001201868057251
(548) DESCRIBE `cruiselines` 0.0026500225067139
(549) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00044798851013184
(550) DESCRIBE `orchid_image` 0.0021238327026367
(551) DESCRIBE `cruiselines` 0.0028200149536133
(552) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00054407119750977
(553) DESCRIBE `cruises` 0.0043630599975586
(554) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76352') 0.00061488151550293
(555) DESCRIBE `ships` 0.0038819313049316
(556) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.00046586990356445
(557) DESCRIBE `ships` 0.0038659572601318
(558) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.00055384635925293
(559) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00044918060302734
(560) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003659725189209
(561) DESCRIBE `itineraries` 0.0020549297332764
(562) DESCRIBE `ports` 0.0020260810852051
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00042915344238281
(564) DESCRIBE `ports` 0.0020771026611328
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00043416023254395
(566) DESCRIBE `ports` 0.0018880367279053
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00054812431335449
(568) DESCRIBE `sailingdates` 0.0023729801177979
(569) DESCRIBE `ports` 0.0020561218261719
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00058984756469727
(571) DESCRIBE `ports` 0.0023808479309082
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00047993659973145
(573) DESCRIBE `ports` 0.0018999576568604
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 598))) 0.00044107437133789
(575) DESCRIBE `ports` 0.0018370151519775
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '598') 0.00038790702819824
(577) DESCRIBE `ports` 0.0018200874328613
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 601))) 0.00045919418334961
(579) DESCRIBE `ports` 0.0018010139465332
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '601') 0.00046706199645996
(581) DESCRIBE `ports` 0.0017940998077393
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 705))) 0.00039410591125488
(583) DESCRIBE `ports` 0.0018889904022217
(584) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '705') 0.00037193298339844
(585) DESCRIBE `ports` 0.002025842666626
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 321))) 0.00041103363037109
(587) DESCRIBE `ports` 0.0019550323486328
(588) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '321') 0.00043296813964844
(589) DESCRIBE `ports` 0.0020380020141602
(590) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00040793418884277
(591) DESCRIBE `ports` 0.0019838809967041
(592) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.0003972053527832
(593) DESCRIBE `ports` 0.0017769336700439
(594) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00041913986206055
(595) DESCRIBE `ports` 0.0017459392547607
(596) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00044989585876465
(597) DESCRIBE `avid_specials` 0.0018680095672607
(598) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76352 and class = 'Cruise') OR (item_id = 850 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 38 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.0013580322265625
(599) DESCRIBE `cruiselines` 0.0026860237121582
(600) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00056195259094238
(601) DESCRIBE `orchid_image` 0.002593994140625
(602) DESCRIBE `cruiselines` 0.002708911895752
(603) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.0006110668182373
(604) DESCRIBE `cruises` 0.0049798488616943
(605) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61419') 0.00058197975158691
(606) DESCRIBE `ships` 0.0053620338439941
(607) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.00092387199401855
(608) DESCRIBE `ships` 0.0039229393005371
(609) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.00045299530029297
(610) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00042200088500977
(611) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035214424133301
(612) DESCRIBE `itineraries` 0.0017910003662109
(613) DESCRIBE `ports` 0.0022540092468262
(614) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00050592422485352
(615) DESCRIBE `ports` 0.0018141269683838
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0004432201385498
(617) DESCRIBE `ports` 0.0017399787902832
(618) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00042009353637695
(619) DESCRIBE `sailingdates` 0.0016119480133057
(620) DESCRIBE `ports` 0.0018410682678223
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00045895576477051
(622) DESCRIBE `ports` 0.0019581317901611
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00044703483581543
(624) DESCRIBE `ports` 0.0023319721221924
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00051093101501465
(626) DESCRIBE `ports` 0.0021100044250488
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00042009353637695
(628) DESCRIBE `ports` 0.0018141269683838
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00044393539428711
(630) DESCRIBE `ports` 0.0019280910491943
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00041604042053223
(632) DESCRIBE `ports` 0.0019698143005371
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4949))) 0.0005030632019043
(634) DESCRIBE `ports` 0.0020949840545654
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4949') 0.000518798828125
(636) DESCRIBE `ports` 0.0021758079528809
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1082))) 0.00052905082702637
(638) DESCRIBE `ports` 0.0019259452819824
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1082') 0.00042104721069336
(640) DESCRIBE `ports` 0.0018339157104492
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00049304962158203
(642) DESCRIBE `ports` 0.0018930435180664
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00046920776367188
(644) DESCRIBE `ports` 0.0024960041046143
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00048208236694336
(646) DESCRIBE `ports` 0.0020420551300049
(647) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00048995018005371
(648) DESCRIBE `ports` 0.0018689632415771
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00044608116149902
(650) DESCRIBE `ports` 0.0019490718841553
(651) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00051212310791016
(652) DESCRIBE `ports` 0.0018329620361328
(653) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046491622924805
(654) DESCRIBE `ports` 0.0017719268798828
(655) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0005190372467041
(656) DESCRIBE `avid_specials` 0.0017240047454834
(657) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61419 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 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.0021770000457764
(658) DESCRIBE `cruiselines` 0.0030701160430908
(659) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00047588348388672
(660) DESCRIBE `orchid_image` 0.0021100044250488
(661) DESCRIBE `cruiselines` 0.0030839443206787
(662) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00065493583679199
(663) DESCRIBE `cruises` 0.0038540363311768
(664) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76401') 0.00054502487182617
(665) DESCRIBE `ships` 0.0041680335998535
(666) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.00066995620727539
(667) DESCRIBE `ships` 0.0038731098175049
(668) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.0004270076751709
(669) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0004570484161377
(670) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00038695335388184
(671) DESCRIBE `itineraries` 0.0019240379333496
(672) DESCRIBE `ports` 0.0026791095733643
(673) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00062894821166992
(674) DESCRIBE `ports` 0.0019969940185547
(675) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0005340576171875
(676) DESCRIBE `ports` 0.0017988681793213
(677) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00043487548828125
(678) DESCRIBE `sailingdates` 0.0016210079193115
(679) DESCRIBE `ports` 0.0021059513092041
(680) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00051212310791016
(681) DESCRIBE `ports` 0.0022208690643311
(682) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00043916702270508
(683) DESCRIBE `ports` 0.0019619464874268
(684) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 413))) 0.00046586990356445
(685) DESCRIBE `ports` 0.0021920204162598
(686) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '413') 0.00043082237243652
(687) DESCRIBE `ports` 0.0019450187683105
(688) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00052380561828613
(689) DESCRIBE `ports` 0.0027258396148682
(690) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00059103965759277
(691) DESCRIBE `ports` 0.0028009414672852
(692) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00061607360839844
(693) DESCRIBE `ports` 0.0018699169158936
(694) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00039005279541016
(695) DESCRIBE `ports` 0.0020289421081543
(696) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00043606758117676
(697) DESCRIBE `ports` 0.0020101070404053
(698) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00037503242492676
(699) DESCRIBE `ports` 0.0019559860229492
(700) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.0004270076751709
(701) DESCRIBE `ports` 0.0030150413513184
(702) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00060391426086426
(703) DESCRIBE `ports` 0.0026628971099854
(704) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00064897537231445
(705) DESCRIBE `ports` 0.0027258396148682
(706) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00059199333190918
(707) DESCRIBE `ports` 0.0027740001678467
(708) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00068998336791992
(709) DESCRIBE `ports` 0.0027890205383301
(710) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00060796737670898
(711) DESCRIBE `ports` 0.0025811195373535
(712) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00043392181396484
(713) DESCRIBE `ports` 0.0018248558044434
(714) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00038909912109375
(715) DESCRIBE `ports` 0.0018079280853271
(716) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00042510032653809
(717) DESCRIBE `ports` 0.0018479824066162
(718) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00039815902709961
(719) DESCRIBE `ports` 0.0017900466918945
(720) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4949))) 0.00047898292541504
(721) DESCRIBE `ports` 0.0019779205322266
(722) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4949') 0.00047707557678223
(723) DESCRIBE `ports` 0.0019338130950928
(724) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00040793418884277
(725) DESCRIBE `ports` 0.0018191337585449
(726) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00038909912109375
(727) DESCRIBE `ports` 0.0017561912536621
(728) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00049400329589844
(729) DESCRIBE `ports` 0.0017471313476562
(730) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00039410591125488
(731) DESCRIBE `avid_specials` 0.0020380020141602
(732) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76401 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 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.0019280910491943
(733) DESCRIBE `cruiselines` 0.0032899379730225
(734) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00043606758117676
(735) DESCRIBE `orchid_image` 0.0019478797912598
(736) DESCRIBE `cruiselines` 0.0026569366455078
(737) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00038599967956543
(738) DESCRIBE `ships` 0.0036380290985107
(739) SELECT `ships`.* FROM `ships` WHERE (id IN ('966', '850', '1319', '1108', '508', '394')) ORDER BY FIND_IN_SET(id, '966,850,1319,1108,508,394') 0.001154899597168
(740) DESCRIBE `cruisetypes` 0.0017189979553223
(741) DESCRIBE `destinations` 0.0026111602783203
(742) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '40', '26', '37', '2', '38', '35', '43', '28', '21', '11', '48', '49', '8', '45', '30', '10', '52', '25', '34', '32', '55')) ORDER BY FIND_IN_SET(id, '22,12,40,26,37,2,38,35,43,28,21,11,48,49,8,45,30,10,52,25,34,32,55') 0.002183198928833
(743) DESCRIBE `cruiselines` 0.0026159286499023
(744) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00044798851013184
(745) DESCRIBE `cruiselines` 0.0025570392608643
(746) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00046896934509277