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

Total elapsed time: 1.1541802883148

# Query Time
(1) connect 0.0012321472167969
(2) DESCRIBE `cruises` 0.0042479038238525
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (62159, 62580, 67213, 64368, 70134, 71911, 67223, 71698, 70155, 67246)) ORDER BY FIND_IN_SET(id, '62159,62580,67213,64368,70134,71911,67223,71698,70155,67246') 0.0027308464050293
(4) DESCRIBE `cruises` 0.0036849975585938
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62159') 0.00058913230895996
(6) DESCRIBE `ships` 0.0046439170837402
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00069808959960938
(8) DESCRIBE `ships` 0.0043108463287354
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00059914588928223
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00042986869812012
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0003349781036377
(12) DESCRIBE `itineraries` 0.0020408630371094
(13) DESCRIBE `ports` 0.0022499561309814
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047993659973145
(15) DESCRIBE `ports` 0.001924991607666
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00066900253295898
(17) DESCRIBE `ports` 0.0019750595092773
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043320655822754
(19) DESCRIBE `sailingdates` 0.0016930103302002
(20) DESCRIBE `ports` 0.0020689964294434
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045490264892578
(22) DESCRIBE `ports` 0.0015759468078613
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0004580020904541
(24) DESCRIBE `ports` 0.0017881393432617
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00037908554077148
(26) DESCRIBE `ports` 0.0019009113311768
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00098800659179688
(28) DESCRIBE `ports` 0.0017352104187012
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00045609474182129
(30) DESCRIBE `ports` 0.0046319961547852
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00056314468383789
(32) DESCRIBE `ports` 0.0020768642425537
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 734))) 0.0024549961090088
(34) DESCRIBE `ports` 0.002169132232666
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '734') 0.00065207481384277
(36) DESCRIBE `ports` 0.0018210411071777
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00037288665771484
(38) DESCRIBE `ports` 0.0018448829650879
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00073099136352539
(40) DESCRIBE `ports` 0.0032880306243896
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0001220703125
(42) DESCRIBE `ports` 0.0061359405517578
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00072097778320312
(44) DESCRIBE `ports` 0.0021958351135254
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048089027404785
(46) DESCRIBE `ports` 0.0019969940185547
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00046706199645996
(48) DESCRIBE `avid_specials` 0.0018539428710938
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62159 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015850067138672
(50) DESCRIBE `cruiselines` 0.0089950561523438
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00057697296142578
(52) DESCRIBE `orchid_image` 0.0030419826507568
(53) DESCRIBE `cruiselines` 0.0040571689605713
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.0007481575012207
(55) DESCRIBE `cruises` 0.0046849250793457
(56) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62580') 0.00069689750671387
(57) DESCRIBE `ships` 0.0044021606445312
(58) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 765))) 0.00057816505432129
(59) DESCRIBE `ships` 0.006525993347168
(60) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '765') 0.00052595138549805
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0003659725189209
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00086784362792969
(63) DESCRIBE `itineraries` 0.0020930767059326
(64) DESCRIBE `ports` 0.0027451515197754
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00031208992004395
(66) DESCRIBE `ports` 0.0017180442810059
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00056719779968262
(68) DESCRIBE `ports` 0.0027680397033691
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00086307525634766
(70) DESCRIBE `sailingdates` 0.0027639865875244
(71) DESCRIBE `ports` 0.0027718544006348
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00049495697021484
(73) DESCRIBE `ports` 0.0021719932556152
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00045895576477051
(75) DESCRIBE `ports` 0.0025730133056641
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0012760162353516
(77) DESCRIBE `ports` 0.0026149749755859
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00062704086303711
(79) DESCRIBE `avid_specials` 0.0016748905181885
(80) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62580 and class = 'Cruise') OR (item_id = 765 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012929439544678
(81) DESCRIBE `cruiselines` 0.0034730434417725
(82) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00052118301391602
(83) DESCRIBE `orchid_image` 0.002187967300415
(84) DESCRIBE `cruiselines` 0.0032408237457275
(85) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00054788589477539
(86) DESCRIBE `cruises` 0.0035929679870605
(87) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67213') 0.00042605400085449
(88) DESCRIBE `ships` 0.004796028137207
(89) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1285))) 0.00078797340393066
(90) DESCRIBE `ships` 0.0042381286621094
(91) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1285') 0.00073409080505371
(92) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00055694580078125
(93) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0013039112091064
(94) DESCRIBE `itineraries` 0.0026001930236816
(95) DESCRIBE `ports` 0.002100944519043
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.0003211498260498
(97) DESCRIBE `ports` 0.0020689964294434
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00047111511230469
(99) DESCRIBE `ports` 0.0018420219421387
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.0003960132598877
(101) DESCRIBE `sailingdates` 0.0019619464874268
(102) DESCRIBE `ports` 0.0016610622406006
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00045299530029297
(104) DESCRIBE `ports` 0.0016329288482666
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00037193298339844
(106) DESCRIBE `ports` 0.0015931129455566
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00038504600524902
(108) DESCRIBE `ports` 0.0016019344329834
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.0003969669342041
(110) DESCRIBE `ports` 0.0016880035400391
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00043582916259766
(112) DESCRIBE `ports` 0.002025842666626
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00034189224243164
(114) DESCRIBE `avid_specials` 0.0015590190887451
(115) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67213 and class = 'Cruise') OR (item_id = 1285 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015709400177002
(116) DESCRIBE `cruiselines` 0.0026891231536865
(117) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00048398971557617
(118) DESCRIBE `orchid_image` 0.0024361610412598
(119) DESCRIBE `cruiselines` 0.0026068687438965
(120) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00043106079101562
(121) DESCRIBE `cruises` 0.0035898685455322
(122) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64368') 0.00041508674621582
(123) DESCRIBE `ships` 0.0037970542907715
(124) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.0005490779876709
(125) DESCRIBE `ships` 0.0036118030548096
(126) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00046896934509277
(127) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035500526428223
(128) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033307075500488
(129) DESCRIBE `itineraries` 0.0018370151519775
(130) DESCRIBE `ports` 0.0023190975189209
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00053286552429199
(132) DESCRIBE `ports` 0.0018939971923828
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00047993659973145
(134) DESCRIBE `ports` 0.0023620128631592
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00054216384887695
(136) DESCRIBE `sailingdates` 0.0017788410186768
(137) DESCRIBE `ports` 0.0025792121887207
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00011897087097168
(139) DESCRIBE `ports` 0.0021719932556152
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00052618980407715
(141) DESCRIBE `ports` 0.0022919178009033
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00049805641174316
(143) DESCRIBE `ports` 0.0018990039825439
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00039219856262207
(145) DESCRIBE `ports` 0.0019609928131104
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00045514106750488
(147) DESCRIBE `ports` 0.0019130706787109
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00042414665222168
(149) DESCRIBE `ports` 0.0017538070678711
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00046992301940918
(151) DESCRIBE `ports` 0.0022568702697754
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00042390823364258
(153) DESCRIBE `ports` 0.0039710998535156
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00054216384887695
(155) DESCRIBE `ports` 0.0026278495788574
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00082588195800781
(157) DESCRIBE `avid_specials` 0.0047991275787354
(158) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64368 and class = 'Cruise') OR (item_id = 573 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017669200897217
(159) DESCRIBE `cruiselines` 0.0026578903198242
(160) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00054788589477539
(161) DESCRIBE `orchid_image` 0.0032269954681396
(162) DESCRIBE `cruiselines` 0.002701997756958
(163) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00041913986206055
(164) DESCRIBE `cruises` 0.0033690929412842
(165) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70134') 0.0005040168762207
(166) DESCRIBE `ships` 0.003364086151123
(167) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 765))) 0.00054311752319336
(168) DESCRIBE `ships` 0.0032880306243896
(169) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '765') 0.00053191184997559
(170) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00032401084899902
(171) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00030994415283203
(172) DESCRIBE `itineraries` 0.0016739368438721
(173) DESCRIBE `ports` 0.0018868446350098
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00045490264892578
(175) DESCRIBE `ports` 0.0052139759063721
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0059850215911865
(177) DESCRIBE `ports` 0.0019519329071045
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00040411949157715
(179) DESCRIBE `sailingdates` 0.0015091896057129
(180) DESCRIBE `ports` 0.0019040107727051
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0022428035736084
(182) DESCRIBE `ports` 0.0021719932556152
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00042295455932617
(184) DESCRIBE `ports` 0.001784086227417
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00042605400085449
(186) DESCRIBE `ports` 0.0018157958984375
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00040292739868164
(188) DESCRIBE `avid_specials` 0.001615047454834
(189) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70134 and class = 'Cruise') OR (item_id = 765 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017769336700439
(190) DESCRIBE `cruiselines` 0.0026900768280029
(191) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00050091743469238
(192) DESCRIBE `orchid_image` 0.0021629333496094
(193) DESCRIBE `cruiselines` 0.0027039051055908
(194) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00045299530029297
(195) DESCRIBE `cruises` 0.0069270133972168
(196) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71911') 0.0005490779876709
(197) DESCRIBE `ships` 0.004256010055542
(198) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1285))) 0.0005958080291748
(199) DESCRIBE `ships` 0.0045678615570068
(200) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1285') 0.00040197372436523
(201) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034999847412109
(202) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00033187866210938
(203) DESCRIBE `itineraries` 0.0027990341186523
(204) DESCRIBE `ports` 0.0026040077209473
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00051593780517578
(206) DESCRIBE `ports` 0.0019378662109375
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00046801567077637
(208) DESCRIBE `ports` 0.0019381046295166
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00070810317993164
(210) DESCRIBE `sailingdates` 0.0018510818481445
(211) DESCRIBE `ports` 0.0022208690643311
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00046706199645996
(213) DESCRIBE `ports` 0.0026009082794189
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00045895576477051
(215) DESCRIBE `ports` 0.0019290447235107
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.00044393539428711
(217) DESCRIBE `ports` 0.0024850368499756
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.00062799453735352
(219) DESCRIBE `ports` 0.0020151138305664
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1319))) 0.00048494338989258
(221) DESCRIBE `ports` 0.0015230178833008
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1319') 0.00045585632324219
(223) DESCRIBE `ports` 0.0017280578613281
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 791))) 0.00041794776916504
(225) DESCRIBE `ports` 0.0019359588623047
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '791') 0.00042009353637695
(227) DESCRIBE `ports` 0.0020039081573486
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5762))) 0.00044989585876465
(229) DESCRIBE `ports` 0.002004861831665
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5762') 0.00071310997009277
(231) DESCRIBE `ports` 0.001878023147583
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 453))) 0.00048518180847168
(233) DESCRIBE `ports` 0.001945972442627
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '453') 0.00044393539428711
(235) DESCRIBE `ports` 0.0023438930511475
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00020599365234375
(237) DESCRIBE `ports` 0.0023889541625977
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00039005279541016
(239) DESCRIBE `ports` 0.0019149780273438
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 121))) 0.00020194053649902
(241) DESCRIBE `ports` 0.0019009113311768
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '121') 0.0007779598236084
(243) DESCRIBE `avid_specials` 0.001694917678833
(244) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71911 and class = 'Cruise') OR (item_id = 1285 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017619132995605
(245) DESCRIBE `cruiselines` 0.0031828880310059
(246) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00050902366638184
(247) DESCRIBE `orchid_image` 0.0022239685058594
(248) DESCRIBE `cruiselines` 0.002795934677124
(249) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00043606758117676
(250) DESCRIBE `cruises` 0.0040009021759033
(251) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67223') 0.00059390068054199
(252) DESCRIBE `ships` 0.0041399002075195
(253) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1285))) 0.00015497207641602
(254) DESCRIBE `ships` 0.0040650367736816
(255) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1285') 0.00047516822814941
(256) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00035810470581055
(257) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00036096572875977
(258) DESCRIBE `itineraries` 0.0019261837005615
(259) DESCRIBE `ports` 0.0021729469299316
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00046300888061523
(261) DESCRIBE `ports` 0.0019810199737549
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00049805641174316
(263) DESCRIBE `ports` 0.0018601417541504
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00042915344238281
(265) DESCRIBE `sailingdates` 0.0016069412231445
(266) DESCRIBE `ports` 0.0019400119781494
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00056195259094238
(268) DESCRIBE `ports` 0.0020558834075928
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.0005180835723877
(270) DESCRIBE `ports` 0.0022759437561035
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.0010440349578857
(272) DESCRIBE `ports` 0.002249002456665
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.00014519691467285
(274) DESCRIBE `ports` 0.0013108253479004
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1319))) 0.00025200843811035
(276) DESCRIBE `ports` 0.0018839836120605
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1319') 0.00062298774719238
(278) DESCRIBE `ports` 0.0019118785858154
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 791))) 0.0004580020904541
(280) DESCRIBE `ports` 0.0033349990844727
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '791') 0.00039100646972656
(282) DESCRIBE `ports` 0.0024600028991699
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5762))) 0.00039196014404297
(284) DESCRIBE `ports` 0.0053591728210449
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5762') 0.006878137588501
(286) DESCRIBE `ports` 0.001906156539917
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 453))) 0.0056650638580322
(288) DESCRIBE `ports` 0.0033559799194336
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '453') 0.0015759468078613
(290) DESCRIBE `ports` 0.0025360584259033
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.0056591033935547
(292) DESCRIBE `ports` 0.0080838203430176
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.0004580020904541
(294) DESCRIBE `avid_specials` 0.0034170150756836
(295) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67223 and class = 'Cruise') OR (item_id = 1285 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0032660961151123
(296) DESCRIBE `cruiselines` 0.012472152709961
(297) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.0079250335693359
(298) DESCRIBE `orchid_image` 0.0026059150695801
(299) DESCRIBE `cruiselines` 0.01493501663208
(300) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.0008080005645752
(301) DESCRIBE `cruises` 0.01966404914856
(302) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71698') 0.00058794021606445
(303) DESCRIBE `ships` 0.024116992950439
(304) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.00079798698425293
(305) DESCRIBE `ships` 0.0042397975921631
(306) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00059390068054199
(307) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0091788768768311
(308) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00079584121704102
(309) DESCRIBE `itineraries` 0.0026700496673584
(310) DESCRIBE `ports` 0.0018770694732666
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0050480365753174
(312) DESCRIBE `ports` 0.0021729469299316
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0045068264007568
(314) DESCRIBE `ports` 0.010470151901245
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00044679641723633
(316) DESCRIBE `sailingdates` 0.0018131732940674
(317) DESCRIBE `ports` 0.0092978477478027
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0012028217315674
(319) DESCRIBE `ports` 0.0034358501434326
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0077190399169922
(321) DESCRIBE `ports` 0.0055980682373047
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 121))) 0.0005190372467041
(323) DESCRIBE `ports` 0.0019760131835938
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '121') 0.00043916702270508
(325) DESCRIBE `ports` 0.0021131038665771
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.006554126739502
(327) DESCRIBE `ports` 0.0022828578948975
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00042414665222168
(329) DESCRIBE `ports` 0.002208948135376
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00050210952758789
(331) DESCRIBE `ports` 0.0018031597137451
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.015763998031616
(333) DESCRIBE `avid_specials` 0.0027701854705811
(334) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71698 and class = 'Cruise') OR (item_id = 1284 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0053050518035889
(335) DESCRIBE `cruiselines` 0.032312870025635
(336) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00064897537231445
(337) DESCRIBE `orchid_image` 0.0022470951080322
(338) DESCRIBE `cruiselines` 0.019917964935303
(339) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.0005030632019043
(340) DESCRIBE `cruises` 0.0037169456481934
(341) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70155') 0.00046801567077637
(342) DESCRIBE `ships` 0.0068800449371338
(343) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 765))) 0.0025811195373535
(344) DESCRIBE `ships` 0.0048971176147461
(345) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '765') 0.0044190883636475
(346) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0012829303741455
(347) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00041294097900391
(348) DESCRIBE `itineraries` 0.0095758438110352
(349) DESCRIBE `ports` 0.014741897583008
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00041604042053223
(351) DESCRIBE `ports` 0.0016701221466064
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00041604042053223
(353) DESCRIBE `ports` 0.0018670558929443
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00040793418884277
(355) DESCRIBE `sailingdates` 0.0016748905181885
(356) DESCRIBE `ports` 0.0046448707580566
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00048208236694336
(358) DESCRIBE `ports` 0.013433933258057
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0056211948394775
(360) DESCRIBE `ports` 0.0019581317901611
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0042531490325928
(362) DESCRIBE `ports` 0.0018758773803711
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0016241073608398
(364) DESCRIBE `avid_specials` 0.0040991306304932
(365) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70155 and class = 'Cruise') OR (item_id = 765 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0091869831085205
(366) DESCRIBE `cruiselines` 0.0029430389404297
(367) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00057101249694824
(368) DESCRIBE `orchid_image` 0.002108097076416
(369) DESCRIBE `cruiselines` 0.0048198699951172
(370) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.0053169727325439
(371) DESCRIBE `cruises` 0.0036921501159668
(372) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67246') 0.0089881420135498
(373) DESCRIBE `ships` 0.024698972702026
(374) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00062203407287598
(375) DESCRIBE `ships` 0.0055620670318604
(376) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.010142087936401
(377) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00032997131347656
(378) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00030207633972168
(379) DESCRIBE `itineraries` 0.0082271099090576
(380) DESCRIBE `ports` 0.0044841766357422
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0045430660247803
(382) DESCRIBE `ports` 0.0020389556884766
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0076019763946533
(384) DESCRIBE `ports` 0.0021071434020996
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.018100023269653
(386) DESCRIBE `sailingdates` 0.0022909641265869
(387) DESCRIBE `ports` 0.0043230056762695
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0032970905303955
(389) DESCRIBE `ports` 0.007375955581665
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0021941661834717
(391) DESCRIBE `ports` 0.015224933624268
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0055899620056152
(393) DESCRIBE `ports` 0.0020370483398438
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00069308280944824
(395) DESCRIBE `ports` 0.0029489994049072
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0032119750976562
(397) DESCRIBE `ports` 0.0023789405822754
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00043392181396484
(399) DESCRIBE `ports` 0.0047500133514404
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00043702125549316
(401) DESCRIBE `ports` 0.0029690265655518
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.0031828880310059
(403) DESCRIBE `ports` 0.0021388530731201
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00872802734375
(405) DESCRIBE `ports` 0.003695011138916
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00053501129150391
(407) DESCRIBE `avid_specials` 0.003676176071167
(408) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67246 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0049839019775391
(409) DESCRIBE `cruiselines` 0.011528968811035
(410) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.0012369155883789
(411) DESCRIBE `orchid_image` 0.0037209987640381
(412) DESCRIBE `cruiselines` 0.013501882553101
(413) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.01177191734314
(414) DESCRIBE `ships` 0.0076251029968262
(415) SELECT `ships`.* FROM `ships` WHERE (id IN ('573', '1284', '1402', '765', '1285')) ORDER BY FIND_IN_SET(id, '573,1284,1402,765,1285') 0.0050420761108398
(416) DESCRIBE `cruisetypes` 0.001723051071167
(417) DESCRIBE `destinations` 0.0026328563690186
(418) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('8', '43', '35')) ORDER BY FIND_IN_SET(id, '8,43,35') 0.00091910362243652
(419) DESCRIBE `cruiselines` 0.010334968566895
(420) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00061798095703125
(421) DESCRIBE `cruiselines` 0.0053632259368896
(422) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.0024588108062744