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

Total elapsed time: 0.67868542671204

# Query Time
(1) connect 0.0011861324310303
(2) DESCRIBE `cruises` 0.0043089389801025
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (73587, 70104, 54744, 68595, 69816, 71493, 71152, 55033, 73547, 74768)) ORDER BY FIND_IN_SET(id, '73587,70104,54744,68595,69816,71493,71152,55033,73547,74768') 0.0018918514251709
(4) DESCRIBE `cruises` 0.0043480396270752
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73587') 0.00047993659973145
(6) DESCRIBE `ships` 0.0046758651733398
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 116))) 0.00080108642578125
(8) DESCRIBE `ships` 0.0040950775146484
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '116') 0.00059986114501953
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0012900829315186
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0
(12) DESCRIBE `itineraries` 0.0027251243591309
(13) DESCRIBE `ports` 0.0021359920501709
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00049591064453125
(15) DESCRIBE `ports` 0.0018692016601562
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00040102005004883
(17) DESCRIBE `ports` 0.0017859935760498
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00038599967956543
(19) DESCRIBE `sailingdates` 0.0015819072723389
(20) DESCRIBE `ports` 0.0018191337585449
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00046515464782715
(22) DESCRIBE `ports` 0.0018749237060547
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00039100646972656
(24) DESCRIBE `ports` 0.0017969608306885
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00044679641723633
(26) DESCRIBE `ports` 0.0021660327911377
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00059103965759277
(28) DESCRIBE `ports` 0.0019071102142334
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00041604042053223
(30) DESCRIBE `ports` 0.001863956451416
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00038003921508789
(32) DESCRIBE `ports` 0.0016868114471436
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00047397613525391
(34) DESCRIBE `ports` 0.0020370483398438
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00041484832763672
(36) DESCRIBE `ports` 0.0017039775848389
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.0004580020904541
(38) DESCRIBE `ports` 0.0015139579772949
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00040316581726074
(40) DESCRIBE `avid_specials` 0.0017869472503662
(41) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73587 and class = 'Cruise') OR (item_id = 116 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0020749568939209
(42) DESCRIBE `cruiselines` 0.0034060478210449
(43) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00053977966308594
(44) DESCRIBE `orchid_image` 0.0019490718841553
(45) DESCRIBE `cruiselines` 0.0025999546051025
(46) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00036311149597168
(47) DESCRIBE `cruises` 0.0039420127868652
(48) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70104') 0.0007011890411377
(49) DESCRIBE `ships` 0.0039489269256592
(50) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00054192543029785
(51) DESCRIBE `ships` 0.0033729076385498
(52) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00052714347839355
(53) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00041389465332031
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034093856811523
(55) DESCRIBE `itineraries` 0.0017070770263672
(56) DESCRIBE `ports` 0.0017490386962891
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1731))) 0.00041317939758301
(58) DESCRIBE `ports` 0.0016481876373291
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1731))) 0.00039815902709961
(60) DESCRIBE `ports` 0.0017900466918945
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1731') 0.00040006637573242
(62) DESCRIBE `sailingdates` 0.0016090869903564
(63) DESCRIBE `ports` 0.0018301010131836
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1731))) 0.00048995018005371
(65) DESCRIBE `ports` 0.001943826675415
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1731') 0.00052714347839355
(67) DESCRIBE `ports` 0.0021440982818604
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4551))) 0.0005190372467041
(69) DESCRIBE `ports` 0.0022339820861816
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4551') 0.00054192543029785
(71) DESCRIBE `ports` 0.0018861293792725
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 192))) 0.00050902366638184
(73) DESCRIBE `ports` 0.0019078254699707
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '192') 0.00049495697021484
(75) DESCRIBE `ports` 0.0020549297332764
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1731))) 0.00049901008605957
(77) DESCRIBE `ports` 0.0025300979614258
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1731') 0.00062894821166992
(79) DESCRIBE `avid_specials` 0.0018200874328613
(80) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70104 and class = 'Cruise') OR (item_id = 1330 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0028629302978516
(81) DESCRIBE `cruiselines` 0.0025770664215088
(82) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00043678283691406
(83) DESCRIBE `orchid_image` 0.0024690628051758
(84) DESCRIBE `cruiselines` 0.0019919872283936
(85) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0
(86) DESCRIBE `cruises` 0.0028300285339355
(87) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '54744') 0.00014996528625488
(88) DESCRIBE `ships` 0.0038061141967773
(89) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 114))) 0.00065088272094727
(90) DESCRIBE `ships` 0.0041048526763916
(91) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '114') 0.00053906440734863
(92) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035405158996582
(93) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00039792060852051
(94) DESCRIBE `itineraries` 0.0019950866699219
(95) DESCRIBE `ports` 0.0021169185638428
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 862))) 0.00052785873413086
(97) DESCRIBE `ports` 0.0018069744110107
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 862))) 0.00041103363037109
(99) DESCRIBE `ports` 0.0016839504241943
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '862') 0.00039911270141602
(101) DESCRIBE `sailingdates` 0.0015640258789062
(102) DESCRIBE `ports` 0.0020740032196045
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 862))) 0.00048398971557617
(104) DESCRIBE `ports` 0.0018119812011719
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '862') 0.00037908554077148
(106) DESCRIBE `ports` 0.0016980171203613
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00041007995605469
(108) DESCRIBE `ports` 0.0018138885498047
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.0011110305786133
(110) DESCRIBE `ports` 0.0013408660888672
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 126))) 0.00042486190795898
(112) DESCRIBE `ports` 0.0018329620361328
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '126') 0.0003669261932373
(114) DESCRIBE `ports` 0.0018010139465332
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00038385391235352
(116) DESCRIBE `ports` 0.002032995223999
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00023818016052246
(118) DESCRIBE `ports` 0.0013539791107178
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 333))) 0.00031709671020508
(120) DESCRIBE `ports` 0.001291036605835
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '333') 0.00027704238891602
(122) DESCRIBE `ports` 0.0014159679412842
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00030684471130371
(124) DESCRIBE `ports` 0.0013620853424072
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0
(126) DESCRIBE `ports` 0.0018739700317383
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 862))) 0
(128) DESCRIBE `ports` 0.0017240047454834
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '862') 0.00036811828613281
(130) DESCRIBE `avid_specials` 0.0015769004821777
(131) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 54744 and class = 'Cruise') OR (item_id = 114 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 11 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.0017697811126709
(132) DESCRIBE `cruiselines` 0.0024690628051758
(133) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.001121997833252
(134) DESCRIBE `orchid_image` 0.0019550323486328
(135) DESCRIBE `cruiselines` 0.0025250911712646
(136) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00014400482177734
(137) DESCRIBE `cruises` 0.0035419464111328
(138) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68595') 0.00043797492980957
(139) DESCRIBE `ships` 0.0036449432373047
(140) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 403))) 0.00050711631774902
(141) DESCRIBE `ships` 0.0036940574645996
(142) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '403') 0.00099802017211914
(143) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035405158996582
(144) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003199577331543
(145) DESCRIBE `itineraries` 0.0019099712371826
(146) DESCRIBE `ports` 0.0019237995147705
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00047612190246582
(148) DESCRIBE `ports` 0.0017929077148438
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00040197372436523
(150) DESCRIBE `ports` 0.0018479824066162
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00041484832763672
(152) DESCRIBE `sailingdates` 0.0016329288482666
(153) DESCRIBE `ports` 0.0023131370544434
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00047492980957031
(155) DESCRIBE `ports` 0.0020630359649658
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00053811073303223
(157) DESCRIBE `ports` 0.0023510456085205
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00065088272094727
(159) DESCRIBE `ports` 0.0016980171203613
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.0003960132598877
(161) DESCRIBE `ports` 0.0018179416656494
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00041913986206055
(163) DESCRIBE `ports` 0.0032699108123779
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00049281120300293
(165) DESCRIBE `ports` 0.0017979145050049
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00041294097900391
(167) DESCRIBE `ports` 0.001878023147583
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.0003819465637207
(169) DESCRIBE `ports` 0.0019450187683105
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00045204162597656
(171) DESCRIBE `ports` 0.0023880004882812
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00043416023254395
(173) DESCRIBE `ports` 0.00229811668396
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00043702125549316
(175) DESCRIBE `ports` 0.0019130706787109
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00047588348388672
(177) DESCRIBE `ports` 0.0019040107727051
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00043606758117676
(179) DESCRIBE `ports` 0.0019009113311768
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.0015060901641846
(181) DESCRIBE `ports` 0.0018160343170166
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00057315826416016
(183) DESCRIBE `ports` 0.0017149448394775
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00038504600524902
(185) DESCRIBE `avid_specials` 0.0015089511871338
(186) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68595 and class = 'Cruise') OR (item_id = 403 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0019228458404541
(187) DESCRIBE `cruiselines` 0.0029451847076416
(188) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00049996376037598
(189) DESCRIBE `orchid_image` 0.0019428730010986
(190) DESCRIBE `cruiselines` 0.0028951168060303
(191) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00044894218444824
(192) DESCRIBE `cruises` 0.0040791034698486
(193) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69816') 0.00059819221496582
(194) DESCRIBE `ships` 0.0038430690765381
(195) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1586))) 0.00060391426086426
(196) DESCRIBE `ships` 0.0036821365356445
(197) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1586') 0.00049996376037598
(198) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035715103149414
(199) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033807754516602
(200) DESCRIBE `itineraries` 0.0019018650054932
(201) DESCRIBE `ports` 0.001945972442627
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00046992301940918
(203) DESCRIBE `ports` 0.0019409656524658
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00045990943908691
(205) DESCRIBE `ports` 0.0018870830535889
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00040483474731445
(207) DESCRIBE `sailingdates` 0.0015640258789062
(208) DESCRIBE `ports` 0.0018489360809326
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00049090385437012
(210) DESCRIBE `ports` 0.0018291473388672
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00040292739868164
(212) DESCRIBE `ports` 0.001856803894043
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 756))) 0.00054001808166504
(214) DESCRIBE `ports` 0.001957893371582
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '756') 0.0005180835723877
(216) DESCRIBE `ports` 0.0018990039825439
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00048708915710449
(218) DESCRIBE `ports` 0.0019221305847168
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00044918060302734
(220) DESCRIBE `ports` 0.0019910335540771
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00055503845214844
(222) DESCRIBE `ports` 0.0019688606262207
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.0004429817199707
(224) DESCRIBE `ports` 0.0019440650939941
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00044083595275879
(226) DESCRIBE `ports` 0.0019199848175049
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00041508674621582
(228) DESCRIBE `ports` 0.00189208984375
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2264))) 0.00041389465332031
(230) DESCRIBE `ports` 0.0018019676208496
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2264') 0.00042200088500977
(232) DESCRIBE `ports` 0.0019030570983887
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0005030632019043
(234) DESCRIBE `ports` 0.0018808841705322
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00040388107299805
(236) DESCRIBE `avid_specials` 0.0016629695892334
(237) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69816 and class = 'Cruise') OR (item_id = 1586 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017561912536621
(238) DESCRIBE `cruiselines` 0.0026109218597412
(239) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00047206878662109
(240) DESCRIBE `orchid_image` 0.0015568733215332
(241) DESCRIBE `cruiselines` 0.0027871131896973
(242) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00044107437133789
(243) DESCRIBE `cruises` 0.0037739276885986
(244) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71493') 0.0004889965057373
(245) DESCRIBE `ships` 0.003777027130127
(246) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1141))) 0.00057721138000488
(247) DESCRIBE `ships` 0.0037529468536377
(248) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1141') 0.00046801567077637
(249) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003211498260498
(250) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031900405883789
(251) DESCRIBE `itineraries` 0.001849889755249
(252) DESCRIBE `ports` 0.0018868446350098
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4184))) 0.0004730224609375
(254) DESCRIBE `ports` 0.0019409656524658
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4184))) 0.0004580020904541
(256) DESCRIBE `ports` 0.0013759136199951
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4184') 0.00039100646972656
(258) DESCRIBE `sailingdates` 0.0020511150360107
(259) DESCRIBE `ports` 0.0018529891967773
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4184))) 0.00045394897460938
(261) DESCRIBE `ports` 0.0018770694732666
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4184') 0.00048184394836426
(263) DESCRIBE `ports` 0.0018229484558105
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1430))) 0.00042295455932617
(265) DESCRIBE `ports` 0.0018980503082275
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1430') 0.00059008598327637
(267) DESCRIBE `ports` 0.0019850730895996
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4184))) 0.00046706199645996
(269) DESCRIBE `ports` 0.0018270015716553
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4184') 0.00039005279541016
(271) DESCRIBE `avid_specials` 0.0016288757324219
(272) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71493 and class = 'Cruise') OR (item_id = 1141 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 35 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0023601055145264
(273) DESCRIBE `cruiselines` 0.0025408267974854
(274) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00045895576477051
(275) DESCRIBE `orchid_image` 0.0019490718841553
(276) DESCRIBE `cruiselines` 0.0023040771484375
(277) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.0011968612670898
(278) DESCRIBE `cruises` 0.0037670135498047
(279) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71152') 0.00062680244445801
(280) DESCRIBE `ships` 0.0042488574981689
(281) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 286))) 0.00035309791564941
(282) DESCRIBE `ships` 0.0041520595550537
(283) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '286') 0.00047898292541504
(284) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035309791564941
(285) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033187866210938
(286) DESCRIBE `itineraries` 0.0022101402282715
(287) DESCRIBE `ports` 0.0013880729675293
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.00053310394287109
(289) DESCRIBE `ports` 0.0021028518676758
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.00047206878662109
(291) DESCRIBE `ports` 0.0021429061889648
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2521') 0.00041794776916504
(293) DESCRIBE `sailingdates` 0.0015428066253662
(294) DESCRIBE `ports` 0.0020589828491211
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.00051307678222656
(296) DESCRIBE `ports` 0.0019259452819824
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2521') 0.00043797492980957
(298) DESCRIBE `ports` 0.0018448829650879
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00050616264343262
(300) DESCRIBE `ports` 0.0018229484558105
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00041699409484863
(302) DESCRIBE `ports` 0.0018651485443115
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 126))) 0.00045609474182129
(304) DESCRIBE `ports` 0.002007007598877
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '126') 0.00046992301940918
(306) DESCRIBE `ports` 0.0020091533660889
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 333))) 0.00045394897460938
(308) DESCRIBE `ports` 0.0021388530731201
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '333') 0.00045919418334961
(310) DESCRIBE `ports` 0.0020530223846436
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.0004889965057373
(312) DESCRIBE `ports` 0.0019819736480713
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00045490264892578
(314) DESCRIBE `ports` 0.0019640922546387
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00044488906860352
(316) DESCRIBE `ports` 0.0020120143890381
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00043487548828125
(318) DESCRIBE `ports` 0.00193190574646
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00047612190246582
(320) DESCRIBE `ports` 0.0019659996032715
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00042510032653809
(322) DESCRIBE `ports` 0.0031001567840576
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.0011792182922363
(324) DESCRIBE `ports` 0.0011999607086182
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00043296813964844
(326) DESCRIBE `avid_specials` 0.0016829967498779
(327) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71152 and class = 'Cruise') OR (item_id = 286 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 11 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.0016739368438721
(328) DESCRIBE `cruiselines` 0.0027809143066406
(329) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00057101249694824
(330) DESCRIBE `orchid_image` 0.0021939277648926
(331) DESCRIBE `cruiselines` 0.0027170181274414
(332) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00044393539428711
(333) DESCRIBE `cruises` 0.0037541389465332
(334) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55033') 0.00049495697021484
(335) DESCRIBE `ships` 0.0039730072021484
(336) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 262))) 0.00071501731872559
(337) DESCRIBE `ships` 0.0039868354797363
(338) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '262') 0.00054383277893066
(339) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035691261291504
(340) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033998489379883
(341) DESCRIBE `itineraries` 0.0019869804382324
(342) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '55033') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0016171932220459
(343) DESCRIBE `ports` 0.002129077911377
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00049114227294922
(345) DESCRIBE `ports` 0.001957893371582
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.0005500316619873
(347) DESCRIBE `ports` 0.0019598007202148
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00056099891662598
(349) DESCRIBE `sailingdates` 0.0017020702362061
(350) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '55033') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00098204612731934
(351) DESCRIBE `ports` 0.0020880699157715
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.0004889965057373
(353) DESCRIBE `ports` 0.00199294090271
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00042390823364258
(355) DESCRIBE `ports` 0.001986026763916
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.00052690505981445
(357) DESCRIBE `ports` 0.0019481182098389
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00045299530029297
(359) DESCRIBE `ports` 0.0019309520721436
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00047492980957031
(361) DESCRIBE `ports` 0.001884937286377
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00040507316589355
(363) DESCRIBE `ports` 0.0018720626831055
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.0004889965057373
(365) DESCRIBE `ports` 0.00193190574646
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00041413307189941
(367) DESCRIBE `ports` 0.0019629001617432
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00045609474182129
(369) DESCRIBE `ports` 0.0018010139465332
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.0003809928894043
(371) DESCRIBE `ports` 0.0018119812011719
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00047516822814941
(373) DESCRIBE `ports` 0.0017809867858887
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00042486190795898
(375) DESCRIBE `avid_specials` 0.0016601085662842
(376) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55033 and class = 'Cruise') OR (item_id = 262 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 34 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.0017580986022949
(377) DESCRIBE `cruiselines` 0.0033140182495117
(378) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.0005490779876709
(379) DESCRIBE `orchid_image` 0.0022680759429932
(380) DESCRIBE `cruiselines` 0.0025730133056641
(381) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00050806999206543
(382) DESCRIBE `cruises` 0.0051882266998291
(383) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73547') 0.0014469623565674
(384) DESCRIBE `ships` 0.004209041595459
(385) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 113))) 0.0019068717956543
(386) DESCRIBE `ships` 0.0039241313934326
(387) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '113') 0.00060796737670898
(388) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037312507629395
(389) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034308433532715
(390) DESCRIBE `itineraries` 0.0031061172485352
(391) DESCRIBE `ports` 0.0036280155181885
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00056600570678711
(393) DESCRIBE `ports` 0.001878023147583
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.0010111331939697
(395) DESCRIBE `ports` 0.0018808841705322
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0
(397) DESCRIBE `sailingdates` 0.0032060146331787
(398) DESCRIBE `ports` 0.003605842590332
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00065112113952637
(400) DESCRIBE `ports` 0.0026659965515137
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.0015158653259277
(402) DESCRIBE `ports` 0.0022540092468262
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00048708915710449
(404) DESCRIBE `ports` 0.0019729137420654
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00055503845214844
(406) DESCRIBE `ports` 0.0020260810852051
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.00051999092102051
(408) DESCRIBE `ports` 0.0020949840545654
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.00052189826965332
(410) DESCRIBE `ports` 0.0019140243530273
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00048589706420898
(412) DESCRIBE `ports` 0.0019509792327881
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00043201446533203
(414) DESCRIBE `avid_specials` 0.001704216003418
(415) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73547 and class = 'Cruise') OR (item_id = 113 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 9 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018520355224609
(416) DESCRIBE `cruiselines` 0.0029630661010742
(417) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00050711631774902
(418) DESCRIBE `orchid_image` 0.0021920204162598
(419) DESCRIBE `cruiselines` 0.0020511150360107
(420) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00043106079101562
(421) DESCRIBE `cruises` 0.0033249855041504
(422) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74768') 0.00048089027404785
(423) DESCRIBE `ships` 0.003587007522583
(424) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 393))) 0.00071811676025391
(425) DESCRIBE `ships` 0.0030739307403564
(426) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '393') 0.00045895576477051
(427) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032186508178711
(428) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030803680419922
(429) DESCRIBE `itineraries` 0.00095081329345703
(430) DESCRIBE `ports` 0.0017850399017334
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00047087669372559
(432) DESCRIBE `ports` 0.0017828941345215
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00044393539428711
(434) DESCRIBE `ports` 0.001816987991333
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0
(436) DESCRIBE `sailingdates` 0.0014858245849609
(437) DESCRIBE `ports` 0.00211501121521
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0011169910430908
(439) DESCRIBE `ports` 0.002856969833374
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00042390823364258
(441) DESCRIBE `ports` 0.0018379688262939
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.00046396255493164
(443) DESCRIBE `ports` 0.0045990943908691
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.00050592422485352
(445) DESCRIBE `ports` 0.002032995223999
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00055980682373047
(447) DESCRIBE `ports` 0.0020217895507812
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00041985511779785
(449) DESCRIBE `ports` 0.0019440650939941
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046181678771973
(451) DESCRIBE `ports` 0.0018720626831055
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0004429817199707
(453) DESCRIBE `avid_specials` 0.0010139942169189
(454) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74768 and class = 'Cruise') OR (item_id = 393 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 9 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0020580291748047
(455) DESCRIBE `cruiselines` 0.0025219917297363
(456) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00043702125549316
(457) DESCRIBE `orchid_image` 0.0022819042205811
(458) DESCRIBE `cruiselines` 0.0028529167175293
(459) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00044393539428711
(460) DESCRIBE `ships` 0.004612922668457
(461) SELECT `ships`.* FROM `ships` WHERE (id IN ('393', '113', '330', '1141', '124', '116', '285', '748', '658', '791', '1323', '286', '590', '119', '526', '1571', '1586', '1236', '114', '403', '123', '262', '389', '1330', '287', '1738')) ORDER BY FIND_IN_SET(id, '393,113,330,1141,124,116,285,748,658,791,1323,286,590,119,526,1571,1586,1236,114,403,123,262,389,1330,287,1738') 0.0038421154022217
(462) DESCRIBE `cruisetypes` 0.0019490718841553
(463) DESCRIBE `destinations` 0.0021648406982422
(464) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '9', '35', '22', '43', '10', '11', '2', '8', '26', '28', '38', '45', '21', '48', '25', '29', '30', '34', '40')) ORDER BY FIND_IN_SET(id, '12,9,35,22,43,10,11,2,8,26,28,38,45,21,48,25,29,30,34,40') 0.0018689632415771
(465) DESCRIBE `cruiselines` 0.0025601387023926
(466) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00045394897460938
(467) DESCRIBE `cruiselines` 0.002234935760498
(468) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00045895576477051