or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Solo Cruisers
  3. Catch Up on Cruising: Latest News in bite size!
  4. Should I buy a beverage package?
  5. SPOTLIGHT ON: Viking Ocean and River Cruises

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

Total elapsed time: 0.90555739402771

# Query Time
(1) connect 0.0015130043029785
(2) DESCRIBE `cruises` 0.0039858818054199
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (67999, 68992, 69569, 69651, 69843, 69845, 69847, 70204, 38675, 40967)) ORDER BY FIND_IN_SET(id, '67999,68992,69569,69651,69843,69845,69847,70204,38675,40967') 0.0018949508666992
(4) DESCRIBE `cruises` 0.0027720928192139
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67999') 0.00032496452331543
(6) DESCRIBE `ships` 0.0025079250335693
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 726))) 0.00045609474182129
(8) DESCRIBE `ships` 0.0025148391723633
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '726') 0.00034499168395996
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029611587524414
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024580955505371
(12) DESCRIBE `itineraries` 0.0014948844909668
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67999') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0006718635559082
(14) DESCRIBE `ports` 0.0013861656188965
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00030398368835449
(16) DESCRIBE `ports` 0.0012481212615967
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00028204917907715
(18) DESCRIBE `ports` 0.0013599395751953
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0002748966217041
(20) DESCRIBE `sailingdates` 0.0011098384857178
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67999') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0006260871887207
(22) DESCRIBE `ports` 0.0016758441925049
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031900405883789
(24) DESCRIBE `ports` 0.001255989074707
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00026988983154297
(26) DESCRIBE `ports` 0.0012328624725342
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00031805038452148
(28) DESCRIBE `ports` 0.0012431144714355
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00033807754516602
(30) DESCRIBE `ports` 0.00124192237854
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00031208992004395
(32) DESCRIBE `ports` 0.0012879371643066
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00035595893859863
(34) DESCRIBE `ports` 0.0012660026550293
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2264))) 0.00028514862060547
(36) DESCRIBE `ports` 0.0013010501861572
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2264') 0.00026106834411621
(38) DESCRIBE `ports` 0.0012290477752686
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00029993057250977
(40) DESCRIBE `ports` 0.0012681484222412
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.0002748966217041
(42) DESCRIBE `ports` 0.0013492107391357
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00030016899108887
(44) DESCRIBE `ports` 0.0013439655303955
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00028896331787109
(46) DESCRIBE `ports` 0.0014309883117676
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00032901763916016
(48) DESCRIBE `ports` 0.0012941360473633
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00029301643371582
(50) DESCRIBE `ports` 0.0013129711151123
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00031900405883789
(52) DESCRIBE `ports` 0.0013360977172852
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00028204917907715
(54) DESCRIBE `ports` 0.0012829303741455
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00029206275939941
(56) DESCRIBE `ports` 0.001309871673584
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00029110908508301
(58) DESCRIBE `avid_specials` 0.0012631416320801
(59) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67999 and class = 'Cruise') OR (item_id = 726 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012309551239014
(60) DESCRIBE `cruiselines` 0.0019779205322266
(61) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00036978721618652
(62) DESCRIBE `orchid_image` 0.0014679431915283
(63) DESCRIBE `cruiselines` 0.0018761157989502
(64) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00033402442932129
(65) DESCRIBE `cruises` 0.002903938293457
(66) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68992') 0.00034284591674805
(67) DESCRIBE `ships` 0.0026149749755859
(68) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1147))) 0.00041890144348145
(69) DESCRIBE `ships` 0.0029268264770508
(70) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1147') 0.00046086311340332
(71) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026416778564453
(72) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025010108947754
(73) DESCRIBE `itineraries` 0.0014948844909668
(74) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68992') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00079202651977539
(75) DESCRIBE `ports` 0.0016419887542725
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00034689903259277
(77) DESCRIBE `ports` 0.0012969970703125
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00028800964355469
(79) DESCRIBE `ports` 0.0015389919281006
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00040602684020996
(81) DESCRIBE `sailingdates` 0.0013229846954346
(82) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68992') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0006248950958252
(83) DESCRIBE `ports` 0.0022311210632324
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00042581558227539
(85) DESCRIBE `ports` 0.0017299652099609
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00046300888061523
(87) DESCRIBE `ports` 0.0018229484558105
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3685))) 0.00037884712219238
(89) DESCRIBE `ports` 0.0014281272888184
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3685') 0.00027608871459961
(91) DESCRIBE `ports` 0.0012850761413574
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00030183792114258
(93) DESCRIBE `ports` 0.0013680458068848
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00032186508178711
(95) DESCRIBE `ports` 0.0013771057128906
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00037789344787598
(97) DESCRIBE `ports` 0.0019280910491943
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.0004279613494873
(99) DESCRIBE `ports` 0.0018839836120605
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00043487548828125
(101) DESCRIBE `ports` 0.001762866973877
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00038790702819824
(103) DESCRIBE `ports` 0.0017049312591553
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2093))) 0.00043916702270508
(105) DESCRIBE `ports` 0.0018289089202881
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2093') 0.00035905838012695
(107) DESCRIBE `ports` 0.0021109580993652
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1594))) 0.00049614906311035
(109) DESCRIBE `ports` 0.0018808841705322
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1594') 0.00031590461730957
(111) DESCRIBE `ports` 0.0018191337585449
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.0003969669342041
(113) DESCRIBE `ports` 0.0017280578613281
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.0004270076751709
(115) DESCRIBE `ports` 0.0016930103302002
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2004))) 0.00047206878662109
(117) DESCRIBE `ports` 0.0018110275268555
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2004') 0.0003809928894043
(119) DESCRIBE `ports` 0.0018019676208496
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00042891502380371
(121) DESCRIBE `ports` 0.0018320083618164
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00037407875061035
(123) DESCRIBE `avid_specials` 0.0016398429870605
(124) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68992 and class = 'Cruise') OR (item_id = 1147 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 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.0017650127410889
(125) DESCRIBE `cruiselines` 0.0027148723602295
(126) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00043988227844238
(127) DESCRIBE `orchid_image` 0.0022268295288086
(128) DESCRIBE `cruiselines` 0.0032148361206055
(129) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00072908401489258
(130) DESCRIBE `cruises` 0.0035459995269775
(131) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69569') 0.00045299530029297
(132) DESCRIBE `ships` 0.0037229061126709
(133) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1150))) 0.00062203407287598
(134) DESCRIBE `ships` 0.0043389797210693
(135) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1150') 0.0022721290588379
(136) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00046896934509277
(137) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034499168395996
(138) DESCRIBE `itineraries` 0.0032939910888672
(139) DESCRIBE `ports` 0.003911018371582
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00049901008605957
(141) DESCRIBE `ports` 0.0027420520782471
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00043201446533203
(143) DESCRIBE `ports` 0.0023870468139648
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00043797492980957
(145) DESCRIBE `sailingdates` 0.0014832019805908
(146) DESCRIBE `ports` 0.0023329257965088
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.0004429817199707
(148) DESCRIBE `ports` 0.0017879009246826
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.0003809928894043
(150) DESCRIBE `ports` 0.0017168521881104
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00038695335388184
(152) DESCRIBE `ports` 0.0016739368438721
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00035881996154785
(154) DESCRIBE `ports` 0.0016889572143555
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.00040292739868164
(156) DESCRIBE `ports` 0.0017571449279785
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.00036787986755371
(158) DESCRIBE `ports` 0.0022211074829102
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00049901008605957
(160) DESCRIBE `ports` 0.0018019676208496
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00039982795715332
(162) DESCRIBE `ports` 0.0018880367279053
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2914))) 0.0004730224609375
(164) DESCRIBE `ports` 0.0017530918121338
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2914') 0.00040984153747559
(166) DESCRIBE `ports` 0.0018589496612549
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.0004429817199707
(168) DESCRIBE `ports` 0.0019259452819824
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00040698051452637
(170) DESCRIBE `ports` 0.0016469955444336
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00039911270141602
(172) DESCRIBE `ports` 0.0016849040985107
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00042200088500977
(174) DESCRIBE `ports` 0.0018091201782227
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00039291381835938
(176) DESCRIBE `ports` 0.0017681121826172
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00039196014404297
(178) DESCRIBE `ports` 0.001845121383667
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00041794776916504
(180) DESCRIBE `ports` 0.0019509792327881
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00044798851013184
(182) DESCRIBE `ports` 0.0018818378448486
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00046205520629883
(184) DESCRIBE `ports` 0.0019600391387939
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00040507316589355
(186) DESCRIBE `avid_specials` 0.0017681121826172
(187) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69569 and class = 'Cruise') OR (item_id = 1150 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 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.0017590522766113
(188) DESCRIBE `cruiselines` 0.0027139186859131
(189) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00049209594726562
(190) DESCRIBE `orchid_image` 0.0023508071899414
(191) DESCRIBE `cruiselines` 0.0031678676605225
(192) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.0004420280456543
(193) DESCRIBE `cruises` 0.0035150051116943
(194) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69651') 0.00064516067504883
(195) DESCRIBE `ships` 0.0036149024963379
(196) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1604))) 0.00069403648376465
(197) DESCRIBE `ships` 0.0041220188140869
(198) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1604') 0.00060296058654785
(199) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003349781036377
(200) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031900405883789
(201) DESCRIBE `itineraries` 0.00189208984375
(202) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69651') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00095295906066895
(203) DESCRIBE `ports` 0.002068042755127
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00043320655822754
(205) DESCRIBE `ports` 0.0017268657684326
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.0004119873046875
(207) DESCRIBE `ports` 0.0017268657684326
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00039315223693848
(209) DESCRIBE `sailingdates` 0.0015139579772949
(210) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69651') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010199546813965
(211) DESCRIBE `ports` 0.0022139549255371
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00049209594726562
(213) DESCRIBE `ports` 0.0019810199737549
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00042414665222168
(215) DESCRIBE `ports` 0.0019650459289551
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00049901008605957
(217) DESCRIBE `ports` 0.0019412040710449
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00043606758117676
(219) DESCRIBE `ports` 0.0019388198852539
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00048089027404785
(221) DESCRIBE `ports` 0.001986026763916
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00043702125549316
(223) DESCRIBE `ports` 0.0018458366394043
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00047183036804199
(225) DESCRIBE `ports` 0.0019350051879883
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 8.5115432739258E-5
(227) DESCRIBE `ports` 0.0020120143890381
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2914))) 0.00058698654174805
(229) DESCRIBE `ports` 0.0020139217376709
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2914') 0.0004420280456543
(231) DESCRIBE `ports` 0.0018999576568604
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00056195259094238
(233) DESCRIBE `ports` 0.0020830631256104
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00051593780517578
(235) DESCRIBE `ports` 0.0020148754119873
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.00057411193847656
(237) DESCRIBE `ports` 0.0019829273223877
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.00047993659973145
(239) DESCRIBE `ports` 0.0019209384918213
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00053215026855469
(241) DESCRIBE `ports` 0.0015320777893066
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00045990943908691
(243) DESCRIBE `ports` 0.00189208984375
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00048089027404785
(245) DESCRIBE `ports` 0.0018820762634277
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.0004119873046875
(247) DESCRIBE `avid_specials` 0.001737117767334
(248) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69651 and class = 'Cruise') OR (item_id = 1604 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 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.0019190311431885
(249) DESCRIBE `cruiselines` 0.0022549629211426
(250) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00052213668823242
(251) DESCRIBE `orchid_image` 0.002457857131958
(252) DESCRIBE `cruiselines` 0.0029969215393066
(253) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00054287910461426
(254) DESCRIBE `cruises` 0.0039539337158203
(255) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69843') 0.00069117546081543
(256) DESCRIBE `ships` 0.0036218166351318
(257) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1027))) 0.00065302848815918
(258) DESCRIBE `ships` 0.0031659603118896
(259) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1027') 0.00048494338989258
(260) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035500526428223
(261) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033998489379883
(262) DESCRIBE `itineraries` 0.0020208358764648
(263) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69843') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00094199180603027
(264) DESCRIBE `ports` 0.0021169185638428
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.00037097930908203
(266) DESCRIBE `ports` 0.0015060901641846
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.00034308433532715
(268) DESCRIBE `ports` 0.0014011859893799
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5604') 0.00028300285339355
(270) DESCRIBE `sailingdates` 0.0013759136199951
(271) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69843') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0016469955444336
(272) DESCRIBE `ports` 0.0023641586303711
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.00047802925109863
(274) DESCRIBE `ports` 0.0020370483398438
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5604') 0.00045204162597656
(276) DESCRIBE `ports` 0.0019598007202148
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00016188621520996
(278) DESCRIBE `ports` 0.0019090175628662
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00040102005004883
(280) DESCRIBE `ports` 0.0017831325531006
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1554))) 0.00062012672424316
(282) DESCRIBE `ports` 0.0017480850219727
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1554') 0.00035500526428223
(284) DESCRIBE `ports` 0.0017580986022949
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00043892860412598
(286) DESCRIBE `ports` 0.001924991607666
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00039386749267578
(288) DESCRIBE `ports` 0.0017931461334229
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4236))) 0.00048303604125977
(290) DESCRIBE `ports` 0.0022718906402588
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4236') 0.00046801567077637
(292) DESCRIBE `ports` 0.0026619434356689
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1556))) 0.00049996376037598
(294) DESCRIBE `ports` 0.0021388530731201
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1556') 0.00051784515380859
(296) DESCRIBE `ports` 0.0020670890808105
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.00047802925109863
(298) DESCRIBE `ports` 0.0017120838165283
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5604') 0.00041580200195312
(300) DESCRIBE `ports` 0.001945972442627
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.00047612190246582
(302) DESCRIBE `ports` 0.0019550323486328
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5604') 0.00040698051452637
(304) DESCRIBE `avid_specials` 0.0015780925750732
(305) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69843 and class = 'Cruise') OR (item_id = 1027 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 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.0017030239105225
(306) DESCRIBE `cruiselines` 0.0028049945831299
(307) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00052499771118164
(308) DESCRIBE `orchid_image` 0.0023331642150879
(309) DESCRIBE `cruiselines` 0.0030438899993896
(310) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00046896934509277
(311) DESCRIBE `cruises` 0.0035250186920166
(312) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69845') 0.00043320655822754
(313) DESCRIBE `ships` 0.0039279460906982
(314) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1145))) 0.00066685676574707
(315) DESCRIBE `ships` 0.003911018371582
(316) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1145') 0.00064587593078613
(317) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003659725189209
(318) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033402442932129
(319) DESCRIBE `itineraries` 0.0019650459289551
(320) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69845') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00092196464538574
(321) DESCRIBE `ports` 0.0022211074829102
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00047588348388672
(323) DESCRIBE `ports` 0.0018289089202881
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00044107437133789
(325) DESCRIBE `ports` 0.0017769336700439
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00051021575927734
(327) DESCRIBE `sailingdates` 0.0016059875488281
(328) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69845') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00080990791320801
(329) DESCRIBE `ports` 0.00223708152771
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00048589706420898
(331) DESCRIBE `ports` 0.0017299652099609
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00038695335388184
(333) DESCRIBE `ports` 0.0019669532775879
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00057005882263184
(335) DESCRIBE `ports` 0.0020601749420166
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00045084953308105
(337) DESCRIBE `ports` 0.0018060207366943
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00047993659973145
(339) DESCRIBE `ports` 0.0019378662109375
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00045919418334961
(341) DESCRIBE `ports` 0.0018820762634277
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1550))) 0.0004580020904541
(343) DESCRIBE `ports` 0.0020079612731934
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1550') 0.00066804885864258
(345) DESCRIBE `ports` 0.0021882057189941
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1551))) 0.00050520896911621
(347) DESCRIBE `ports` 0.0020849704742432
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1551') 0.00041604042053223
(349) DESCRIBE `ports` 0.0018119812011719
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.00047087669372559
(351) DESCRIBE `ports` 0.0019068717956543
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1552') 0.00060820579528809
(353) DESCRIBE `ports` 0.0021519660949707
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.0006868839263916
(355) DESCRIBE `ports` 0.0020530223846436
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00046801567077637
(357) DESCRIBE `ports` 0.00205397605896
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00049591064453125
(359) DESCRIBE `ports` 0.0042769908905029
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00069284439086914
(361) DESCRIBE `ports` 0.0022990703582764
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00047492980957031
(363) DESCRIBE `ports` 0.0022408962249756
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00043296813964844
(365) DESCRIBE `avid_specials` 0.0016779899597168
(366) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69845 and class = 'Cruise') OR (item_id = 1145 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 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.0022730827331543
(367) DESCRIBE `cruiselines` 0.0023481845855713
(368) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00048303604125977
(369) DESCRIBE `orchid_image` 0.0024130344390869
(370) DESCRIBE `cruiselines` 0.0033700466156006
(371) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.0010190010070801
(372) DESCRIBE `cruises` 0.0056638717651367
(373) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69847') 0.0022358894348145
(374) DESCRIBE `ships` 0.0041348934173584
(375) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1233))) 0.00071215629577637
(376) DESCRIBE `ships` 0.0041439533233643
(377) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1233') 0.00059795379638672
(378) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035405158996582
(379) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033283233642578
(380) DESCRIBE `itineraries` 0.0020110607147217
(381) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69847') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00087499618530273
(382) DESCRIBE `ports` 0.0022838115692139
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00055193901062012
(384) DESCRIBE `ports` 0.0020520687103271
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00048089027404785
(386) DESCRIBE `ports` 0.0021679401397705
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00044417381286621
(388) DESCRIBE `sailingdates` 0.0018548965454102
(389) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69847') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00075507164001465
(390) DESCRIBE `ports` 0.0023970603942871
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00042009353637695
(392) DESCRIBE `ports` 0.0015769004821777
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00038599967956543
(394) DESCRIBE `ports` 0.0017819404602051
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00046205520629883
(396) DESCRIBE `ports` 0.0019481182098389
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00043511390686035
(398) DESCRIBE `ports` 0.0020661354064941
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00048708915710449
(400) DESCRIBE `ports` 0.0020790100097656
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00034904479980469
(402) DESCRIBE `ports` 0.0018830299377441
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.00043702125549316
(404) DESCRIBE `ports` 0.001788854598999
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1552') 0.00042009353637695
(406) DESCRIBE `ports` 0.0030989646911621
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1551))) 0.00054597854614258
(408) DESCRIBE `ports` 0.0027110576629639
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1551') 0.00056982040405273
(410) DESCRIBE `ports` 0.0017650127410889
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1550))) 0.00052785873413086
(412) DESCRIBE `ports` 0.0022869110107422
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1550') 0.00064992904663086
(414) DESCRIBE `ports` 0.0022799968719482
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00082588195800781
(416) DESCRIBE `ports` 0.0028371810913086
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00053095817565918
(418) DESCRIBE `ports` 0.0027649402618408
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.0025548934936523
(420) DESCRIBE `ports` 0.0021119117736816
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00044989585876465
(422) DESCRIBE `ports` 0.0021271705627441
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00049304962158203
(424) DESCRIBE `ports` 0.0018339157104492
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00043702125549316
(426) DESCRIBE `avid_specials` 0.0025150775909424
(427) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69847 and class = 'Cruise') OR (item_id = 1233 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 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.0019350051879883
(428) DESCRIBE `cruiselines` 0.0032570362091064
(429) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00057315826416016
(430) DESCRIBE `orchid_image` 0.0023260116577148
(431) DESCRIBE `cruiselines` 0.0030310153961182
(432) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00052285194396973
(433) DESCRIBE `cruises` 0.0039858818054199
(434) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70204') 0.00060701370239258
(435) DESCRIBE `ships` 0.0049479007720947
(436) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 977))) 0.00075101852416992
(437) DESCRIBE `ships` 0.0042591094970703
(438) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '977') 0.0005500316619873
(439) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00040698051452637
(440) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003349781036377
(441) DESCRIBE `itineraries` 0.0018770694732666
(442) DESCRIBE `ports` 0.0018930435180664
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 8.702278137207E-5
(444) DESCRIBE `ports` 0.0020029544830322
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00033211708068848
(446) DESCRIBE `ports` 0.0017471313476562
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00011491775512695
(448) DESCRIBE `sailingdates` 0.0013751983642578
(449) DESCRIBE `ports` 0.0020110607147217
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00052905082702637
(451) DESCRIBE `ports` 0.0017900466918945
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.0003969669342041
(453) DESCRIBE `ports` 0.0017659664154053
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00045299530029297
(455) DESCRIBE `ports` 0.0019340515136719
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00049495697021484
(457) DESCRIBE `ports` 0.0019981861114502
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00050806999206543
(459) DESCRIBE `ports` 0.0019540786743164
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00041604042053223
(461) DESCRIBE `ports` 0.0023889541625977
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00048995018005371
(463) DESCRIBE `ports` 0.0017869472503662
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00040102005004883
(465) DESCRIBE `ports` 0.0016200542449951
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00038909912109375
(467) DESCRIBE `ports` 0.0015499591827393
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00033807754516602
(469) DESCRIBE `ports` 0.0014889240264893
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00037002563476562
(471) DESCRIBE `ports` 0.0014841556549072
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.0003821849822998
(473) DESCRIBE `ports` 0.0014650821685791
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00035381317138672
(475) DESCRIBE `ports` 0.0014982223510742
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.0003509521484375
(477) DESCRIBE `ports` 0.0014798641204834
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.0003669261932373
(479) DESCRIBE `ports` 0.0013220310211182
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.0003359317779541
(481) DESCRIBE `avid_specials` 0.0019969940185547
(482) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70204 and class = 'Cruise') OR (item_id = 977 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0019209384918213
(483) DESCRIBE `cruiselines` 0.0033318996429443
(484) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00059604644775391
(485) DESCRIBE `orchid_image` 0.0018789768218994
(486) DESCRIBE `cruiselines` 0.0029358863830566
(487) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.001093864440918
(488) DESCRIBE `cruises` 0.0034699440002441
(489) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '38675') 0.00057101249694824
(490) DESCRIBE `ships` 0.0037910938262939
(491) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1012))) 0.00064706802368164
(492) DESCRIBE `ships` 0.0040180683135986
(493) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1012') 0.00068211555480957
(494) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034809112548828
(495) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00033879280090332
(496) DESCRIBE `itineraries` 0.0020370483398438
(497) DESCRIBE `ports` 0.0018060207366943
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00050616264343262
(499) DESCRIBE `ports` 0.0017030239105225
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00041604042053223
(501) DESCRIBE `ports` 0.0015959739685059
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00038599967956543
(503) DESCRIBE `sailingdates` 0.0016779899597168
(504) DESCRIBE `ports` 0.0021390914916992
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00045609474182129
(506) DESCRIBE `ports` 0.0019040107727051
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.0005488395690918
(508) DESCRIBE `ports` 0.0019989013671875
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00058889389038086
(510) DESCRIBE `ports` 0.0018191337585449
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.0005338191986084
(512) DESCRIBE `ports` 0.0019409656524658
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226))) 0.0006098747253418
(514) DESCRIBE `ports` 0.0020008087158203
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226') 0.00043797492980957
(516) DESCRIBE `ports` 0.0018749237060547
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00049090385437012
(518) DESCRIBE `ports` 0.0018200874328613
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.00041604042053223
(520) DESCRIBE `ports` 0.0018188953399658
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.00044989585876465
(522) DESCRIBE `ports` 0.0020451545715332
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.00040888786315918
(524) DESCRIBE `ports` 0.0019450187683105
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00044393539428711
(526) DESCRIBE `ports` 0.0019159317016602
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00043392181396484
(528) DESCRIBE `ports` 0.0019369125366211
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.00041699409484863
(530) DESCRIBE `ports` 0.001953125
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.00071287155151367
(532) DESCRIBE `ports` 0.0018479824066162
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 272))) 0.00052213668823242
(534) DESCRIBE `ports` 0.0020570755004883
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '272') 0.00043392181396484
(536) DESCRIBE `ports` 0.0020160675048828
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 273))) 0.00043416023254395
(538) DESCRIBE `ports` 0.0018391609191895
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '273') 0.00046110153198242
(540) DESCRIBE `ports` 0.0018370151519775
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00037789344787598
(542) DESCRIBE `ports` 0.0018978118896484
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00074100494384766
(544) DESCRIBE `ports` 0.0019321441650391
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 889))) 0.0004580020904541
(546) DESCRIBE `ports` 0.0019259452819824
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '889') 0.00043606758117676
(548) DESCRIBE `ports` 0.0021529197692871
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00048303604125977
(550) DESCRIBE `ports` 0.0016639232635498
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00043821334838867
(552) DESCRIBE `ports` 0.0017540454864502
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 271))) 0.00044798851013184
(554) DESCRIBE `ports` 0.0018410682678223
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '271') 0.00037884712219238
(556) DESCRIBE `avid_specials` 0.0015749931335449
(557) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 38675 and class = 'Cruise') OR (item_id = 1012 AND class = 'Ship') OR (item_id = 7 AND class = 'CruiseLine') OR (item_id = 25 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.0016641616821289
(558) DESCRIBE `cruiselines` 0.0026779174804688
(559) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 7))) 0.00051784515380859
(560) DESCRIBE `orchid_image` 0.0021259784698486
(561) DESCRIBE `cruiselines` 0.0027000904083252
(562) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '7') 0.0004420280456543
(563) DESCRIBE `cruises` 0.0032248497009277
(564) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '40967') 0.00048398971557617
(565) DESCRIBE `ships` 0.0039691925048828
(566) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1055))) 0.00065398216247559
(567) DESCRIBE `ships` 0.004155158996582
(568) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1055') 0.00048494338989258
(569) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00011706352233887
(570) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033187866210938
(571) DESCRIBE `itineraries` 0.0018148422241211
(572) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '40967') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00083494186401367
(573) DESCRIBE `ports` 0.0019040107727051
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00046586990356445
(575) DESCRIBE `ports` 0.0018289089202881
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00044894218444824
(577) DESCRIBE `ports` 0.0018420219421387
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00039482116699219
(579) DESCRIBE `sailingdates` 0.001349925994873
(580) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '40967') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0014379024505615
(581) DESCRIBE `ports` 0.0020620822906494
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00043892860412598
(583) DESCRIBE `ports` 0.0017738342285156
(584) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00041007995605469
(585) DESCRIBE `ports` 0.0027499198913574
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.0004279613494873
(587) DESCRIBE `ports` 0.0015690326690674
(588) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00078797340393066
(589) DESCRIBE `ports` 0.0019941329956055
(590) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00046491622924805
(591) DESCRIBE `ports` 0.0020198822021484
(592) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00043296813964844
(593) DESCRIBE `ports` 0.0018608570098877
(594) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1556))) 0.00045108795166016
(595) DESCRIBE `ports` 0.0019938945770264
(596) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1556') 0.00058317184448242
(597) DESCRIBE `ports` 0.0020270347595215
(598) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00042605400085449
(599) DESCRIBE `ports` 0.0018808841705322
(600) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00043678283691406
(601) DESCRIBE `ports` 0.0025908946990967
(602) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5090))) 0.00051593780517578
(603) DESCRIBE `ports` 0.0020108222961426
(604) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5090') 0.00045514106750488
(605) DESCRIBE `ports` 0.0019631385803223
(606) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00045585632324219
(607) DESCRIBE `ports` 0.0018749237060547
(608) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.0003960132598877
(609) DESCRIBE `ports` 0.0018620491027832
(610) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00045895576477051
(611) DESCRIBE `ports` 0.0019688606262207
(612) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00044703483581543
(613) DESCRIBE `avid_specials` 0.0016319751739502
(614) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 40967 and class = 'Cruise') OR (item_id = 1055 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.0020320415496826
(615) DESCRIBE `cruiselines` 0.0030100345611572
(616) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00060796737670898
(617) DESCRIBE `orchid_image` 0.0022580623626709
(618) DESCRIBE `cruiselines` 0.0028109550476074
(619) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00045585632324219
(620) DESCRIBE `cruiselines` 0.0029468536376953
(621) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '7', '171', '23', '144', '18', '31', '20', '101', '8', '183', '96', '12', '120', '191', '50', '103', '221', '29', '15', '33', '268', '37', '156', '28', '91', '262', '114', '110', '141', '131', '208', '153', '187', '14', '232', '24', '118', '49', '181', '258', '151', '36', '212', '30', '206', '140', '204', '4', '256', '238', '249', '220', '16', '239', '47', '174', '113', '35', '264', '90', '195', '216', '188', '182', '261', '136', '146', '159', '213', '237', '211', '115', '168', '196', '180', '73', '209', '57', '95', '248', '59', '219', '52', '184', '231', '170', '225', '229', '108', '88', '230', '276', '82', '244', '132', '269', '105', '275', '48', '119', '240', '116', '64', '266', '38', '134', '224', '210')) ORDER BY FIND_IN_SET(id, '218,77,19,26,7,171,23,144,18,31,20,101,8,183,96,12,120,191,50,103,221,29,15,33,268,37,156,28,91,262,114,110,141,131,208,153,187,14,232,24,118,49,181,258,151,36,212,30,206,140,204,4,256,238,249,220,16,239,47,174,113,35,264,90,195,216,188,182,261,136,146,159,213,237,211,115,168,196,180,73,209,57,95,248,59,219,52,184,231,170,225,229,108,88,230,276,82,244,132,269,105,275,48,119,240,116,64,266,38,134,224,210') 0.008195161819458
(622) DESCRIBE `ships` 0.0034501552581787
(623) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1032', '1292', '1205', '977', '1199', '1247', '1554', '1555', '1291', '1359', '1272', '1588', '1067', '1237', '1599', '407', '258', '1594', '27', '22', '21', '461', '28', '37', '38', '34', '378', '31', '393', '726', '817', '1424', '349', '1135', '30', '1012', '36', '39', '1422', '780', '1419', '1423', '1420', '1421', '1418', '35', '1415', '462', '113', '404', '452', '1677', '24', '766', '265', '1405', '11', '439', '1245', '711', '10', '330', '1215', '1574', '9', '585', '455', '542', '1141', '674', '124', '739', '770', '635', '1572', '1607', '5', '792', '797', '207', '1460', '3', '573', '974', '116', '340', '520', '553', '1454', '25', '1372', '1455', '160', '1193', '874', '517', '580', '1021', '1284', '1302', '390', '1095', '1325', '1402', '253', '285', '4', '332', '748', '43', '66', '1172', '1320', '658', '765', '791', '1068', '582', '1323', '434', '1260', '421', '559', '993', '1259', '1575', '327', '590', '883', '1586', '81', '286', '970', '1678', '119', '406', '526', '678', '78', '854', '1571', '375', '616', '14', '454', '722', '850', '855', '1236', '1492', '547', '823', '1266', '1569', '114', '405', '1008', '1064', '1139', '1208', '1308', '84', '441', '403', '784', '732', '1319', '1330', '1348', '1437', '348', '657', '966', '1088', '1108', '1282', '1587', '1672', '111', '163', '652', '1321', '262', '325', '338', '1326', '1327', '333', '451', '1143', '1389', '123', '508', '521', '1579', '1724', '389', '1027', '1159', '1243', '1376', '148', '351', '683', '1151', '1471', '1526', '314', '483', '1013', '1214', '1367', '162', '290', '75', '93', '287', '394', '626', '1163', '1318', '1398', '545', '651', '731', '859', '751', '1075', '1344', '1602', '291', '673', '768', '1040', '1137', '1144', '1157', '1343', '98', '149', '335', '716', '743', '852', '968', '1063', '1168', '1233', '1413', '1604', '152', '610', '818', '884', '1223', '1303', '1345', '1452', '1453', '1581', '1711', '82', '401', '669', '769', '1025', '1043', '1090', '1136', '1145', '1283', '1301', '1373', '1552', '45', '150', '151', '352', '790', '796', '1241', '201', '223', '485', '776', '882', '1160', '1717', '59', '108', '467', '503', '1152', '1226', '1539', '1738', '324', '341', '639', '905', '988', '1149', '1150', '1448', '1463', '266', '1409', '1449', '1540', '417', '871', '885', '1253', '1411', '1647', '105', '601', '811', '1055', '1458', '1682', '1704', '74', '1026', '1029', '1073', '1188', '1351', '1632', '448', '701', '973', '1231', '1489', '1505', '954', '986', '1034', '1047', '1366', '1408', '1496', '1609', '1742', '494', '666', '704', '795', '851', '1049', '1230', '1362', '1368', '1516', '1740', '205', '208', '738', '888', '996', '1154', '1285', '147', '493', '1037', '1470', '1474', '1580', '1627', '618', '836', '1224', '1444', '1518', '423', '837', '1176', '1382', '1417', '1521', '1229', '1404', '1407', '1410', '1716', '204', '422', '643', '985', '1138', '1196', '1262', '1593', '672', '709', '857', '1054', '1148', '1445', '1486', '1517', '1522', '1619', '671', '717', '972', '1017', '1042', '1051', '1352', '1713', '1715', '781', '994', '1175', '1714', '479', '480', '938', '1106', '1240', '1254', '1412', '1673', '665', '995', '1514', '1606', '1614', '1684', '17', '499', '574', '821', '1045', '1360', '1361', '1459', '1601', '1011', '1053', '1134', '1384', '1481', '1628', '313', '420', '982', '1028', '1322', '1358', '1383', '1501', '1515', '1676', '453', '749', '937', '958', '1439', '1461', '1645', '1708', '1743', '775', '999', '1052', '1071', '1206', '1256', '1615', '1722', '1723', '419', '744', '798', '808', '1631', '1729', '487', '687', '969', '1189', '1232', '1274', '1293', '1297', '1338', '1355', '1035', '1048', '1679', '1681', '1697', '70', '212', '288', '1060', '1089')) ORDER BY FIND_IN_SET(id, '1127,1032,1292,1205,977,1199,1247,1554,1555,1291,1359,1272,1588,1067,1237,1599,407,258,1594,27,22,21,461,28,37,38,34,378,31,393,726,817,1424,349,1135,30,1012,36,39,1422,780,1419,1423,1420,1421,1418,35,1415,462,113,404,452,1677,24,766,265,1405,11,439,1245,711,10,330,1215,1574,9,585,455,542,1141,674,124,739,770,635,1572,1607,5,792,797,207,1460,3,573,974,116,340,520,553,1454,25,1372,1455,160,1193,874,517,580,1021,1284,1302,390,1095,1325,1402,253,285,4,332,748,43,66,1172,1320,658,765,791,1068,582,1323,434,1260,421,559,993,1259,1575,327,590,883,1586,81,286,970,1678,119,406,526,678,78,854,1571,375,616,14,454,722,850,855,1236,1492,547,823,1266,1569,114,405,1008,1064,1139,1208,1308,84,441,403,784,732,1319,1330,1348,1437,348,657,966,1088,1108,1282,1587,1672,111,163,652,1321,262,325,338,1326,1327,333,451,1143,1389,123,508,521,1579,1724,389,1027,1159,1243,1376,148,351,683,1151,1471,1526,314,483,1013,1214,1367,162,290,75,93,287,394,626,1163,1318,1398,545,651,731,859,751,1075,1344,1602,291,673,768,1040,1137,1144,1157,1343,98,149,335,716,743,852,968,1063,1168,1233,1413,1604,152,610,818,884,1223,1303,1345,1452,1453,1581,1711,82,401,669,769,1025,1043,1090,1136,1145,1283,1301,1373,1552,45,150,151,352,790,796,1241,201,223,485,776,882,1160,1717,59,108,467,503,1152,1226,1539,1738,324,341,639,905,988,1149,1150,1448,1463,266,1409,1449,1540,417,871,885,1253,1411,1647,105,601,811,1055,1458,1682,1704,74,1026,1029,1073,1188,1351,1632,448,701,973,1231,1489,1505,954,986,1034,1047,1366,1408,1496,1609,1742,494,666,704,795,851,1049,1230,1362,1368,1516,1740,205,208,738,888,996,1154,1285,147,493,1037,1470,1474,1580,1627,618,836,1224,1444,1518,423,837,1176,1382,1417,1521,1229,1404,1407,1410,1716,204,422,643,985,1138,1196,1262,1593,672,709,857,1054,1148,1445,1486,1517,1522,1619,671,717,972,1017,1042,1051,1352,1713,1715,781,994,1175,1714,479,480,938,1106,1240,1254,1412,1673,665,995,1514,1606,1614,1684,17,499,574,821,1045,1360,1361,1459,1601,1011,1053,1134,1384,1481,1628,313,420,982,1028,1322,1358,1383,1501,1515,1676,453,749,937,958,1439,1461,1645,1708,1743,775,999,1052,1071,1206,1256,1615,1722,1723,419,744,798,808,1631,1729,487,687,969,1189,1232,1274,1293,1297,1338,1355,1035,1048,1679,1681,1697,70,212,288,1060,1089') 0.060998916625977
(624) DESCRIBE `cruisetypes` 0.002439022064209
(625) DESCRIBE `destinations` 0.0040121078491211
(626) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '25', '37', '9', '43', '2', '8', '53', '39', '55', '28', '40', '26', '38', '11', '7', '30', '48', '21', '49', '45', '44', '56', '29', '34', '10', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,25,37,9,43,2,8,53,39,55,28,40,26,38,11,7,30,48,21,49,45,44,56,29,34,10,52,46,32') 0.0035459995269775