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

Total elapsed time: 1.0982031822205

# Query Time
(1) connect 0.00089097023010254
(2) DESCRIBE `cruises` 0.0035650730133057
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (41780, 65912, 74880, 66003, 55703, 65892, 66004, 65893, 66005, 50866)) ORDER BY FIND_IN_SET(id, '41780,65912,74880,66003,55703,65892,66004,65893,66005,50866') 0.0012030601501465
(4) DESCRIBE `cruises` 0.0027930736541748
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41780') 0.00035190582275391
(6) DESCRIBE `ships` 0.0028071403503418
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00036287307739258
(8) DESCRIBE `ships` 0.0027549266815186
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00031399726867676
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029587745666504
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029492378234863
(12) DESCRIBE `itineraries` 0.0012919902801514
(13) DESCRIBE `ports` 0.0013937950134277
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003211498260498
(15) DESCRIBE `ports` 0.0013740062713623
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030779838562012
(17) DESCRIBE `ports` 0.00130295753479
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029683113098145
(19) DESCRIBE `sailingdates` 0.0011260509490967
(20) DESCRIBE `ports` 0.0013289451599121
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030612945556641
(22) DESCRIBE `ports` 0.0015320777893066
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034999847412109
(24) DESCRIBE `ports` 0.0015568733215332
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00032210350036621
(26) DESCRIBE `ports` 0.0012531280517578
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00030303001403809
(28) DESCRIBE `ports` 0.0012779235839844
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00026893615722656
(30) DESCRIBE `ports` 0.0013489723205566
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00025510787963867
(32) DESCRIBE `ports` 0.0014958381652832
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00031018257141113
(34) DESCRIBE `ports` 0.0012838840484619
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00028491020202637
(36) DESCRIBE `ports` 0.0012421607971191
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037908554077148
(38) DESCRIBE `ports` 0.001317024230957
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038504600524902
(40) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '41780') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.10550212860107
(41) DESCRIBE `avid_specials` 0.0019989013671875
(42) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41780 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.19190311431885
(43) DESCRIBE `cruiselines` 0.0022571086883545
(44) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00037097930908203
(45) DESCRIBE `orchid_image` 0.0019271373748779
(46) DESCRIBE `cruiselines` 0.0021231174468994
(47) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00035405158996582
(48) DESCRIBE `cruises` 0.0034511089324951
(49) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65912') 0.00047206878662109
(50) DESCRIBE `ships` 0.0027568340301514
(51) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.0004420280456543
(52) DESCRIBE `ships` 0.0026240348815918
(53) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00029587745666504
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027203559875488
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025010108947754
(56) DESCRIBE `itineraries` 0.0013999938964844
(57) DESCRIBE `ports` 0.0013618469238281
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.0003359317779541
(59) DESCRIBE `ports` 0.0013630390167236
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.0002439022064209
(61) DESCRIBE `ports` 0.0057179927825928
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00039792060852051
(63) DESCRIBE `sailingdates` 0.0014259815216064
(64) DESCRIBE `ports` 0.0013198852539062
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00034594535827637
(66) DESCRIBE `ports` 0.0013160705566406
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00028204917907715
(68) DESCRIBE `ports` 0.0014009475708008
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 353))) 0.00034594535827637
(70) DESCRIBE `ports` 0.0012719631195068
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '353') 0.00026893615722656
(72) DESCRIBE `ports` 0.0015439987182617
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.0003359317779541
(74) DESCRIBE `ports` 0.0016028881072998
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00032711029052734
(76) DESCRIBE `ports` 0.0015168190002441
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.0004267692565918
(78) DESCRIBE `ports` 0.0012781620025635
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00032401084899902
(80) DESCRIBE `ports` 0.0014350414276123
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00031399726867676
(82) DESCRIBE `ports` 0.0013611316680908
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00029706954956055
(84) DESCRIBE `ports` 0.0015039443969727
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.0004420280456543
(86) DESCRIBE `ports` 0.0017831325531006
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00036406517028809
(88) DESCRIBE `ports` 0.0016870498657227
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.0003819465637207
(90) DESCRIBE `ports` 0.0013608932495117
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00027990341186523
(92) DESCRIBE `ports` 0.0014622211456299
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00050806999206543
(94) DESCRIBE `ports` 0.0015649795532227
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00023007392883301
(96) DESCRIBE `ports` 0.00136399269104
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00033402442932129
(98) DESCRIBE `ports` 0.0015110969543457
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00031185150146484
(100) DESCRIBE `ports` 0.0016069412231445
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00063991546630859
(102) DESCRIBE `ports` 0.0018889904022217
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038909912109375
(104) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '65912') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0056681632995605
(105) DESCRIBE `avid_specials` 0.0015490055084229
(106) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65912 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.0011141300201416
(107) DESCRIBE `cruiselines` 0.0026710033416748
(108) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00037813186645508
(109) DESCRIBE `orchid_image` 0.0014991760253906
(110) DESCRIBE `cruiselines` 0.0018889904022217
(111) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00032496452331543
(112) DESCRIBE `cruises` 0.0033528804779053
(113) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74880') 0.00042891502380371
(114) DESCRIBE `ships` 0.0029911994934082
(115) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00045895576477051
(116) DESCRIBE `ships` 0.0029740333557129
(117) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00041317939758301
(118) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034594535827637
(119) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033402442932129
(120) DESCRIBE `itineraries` 0.0017650127410889
(121) DESCRIBE `ports` 0.0072169303894043
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0065269470214844
(123) DESCRIBE `ports` 0.0014960765838623
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0090069770812988
(125) DESCRIBE `ports` 0.0020549297332764
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0
(127) DESCRIBE `sailingdates` 0.0013608932495117
(128) DESCRIBE `ports` 0.0020570755004883
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00053191184997559
(130) DESCRIBE `ports` 0.0017290115356445
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0090339183807373
(132) DESCRIBE `ports` 0.0020358562469482
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00042486190795898
(134) DESCRIBE `ports` 0.0017709732055664
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00035214424133301
(136) DESCRIBE `ports` 0.0014090538024902
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00019288063049316
(138) DESCRIBE `ports` 0.0015189647674561
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0
(140) DESCRIBE `ports` 0.0014481544494629
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0081019401550293
(142) DESCRIBE `ports` 0.0015878677368164
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034785270690918
(144) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '74880') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0057029724121094
(145) DESCRIBE `avid_specials` 0.0015220642089844
(146) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74880 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0010981559753418
(147) DESCRIBE `cruiselines` 0.002208948135376
(148) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00023293495178223
(149) DESCRIBE `orchid_image` 0.0018439292907715
(150) DESCRIBE `cruiselines` 0.002284049987793
(151) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00039196014404297
(152) DESCRIBE `cruises` 0.0035500526428223
(153) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66003') 0.00048995018005371
(154) DESCRIBE `ships` 0.0036759376525879
(155) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00041604042053223
(156) DESCRIBE `ships` 0.0024991035461426
(157) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00030398368835449
(158) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026607513427734
(159) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0011711120605469
(160) DESCRIBE `itineraries` 0.00058603286743164
(161) DESCRIBE `ports` 0.0013918876647949
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034904479980469
(163) DESCRIBE `ports` 0.0012941360473633
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033783912658691
(165) DESCRIBE `ports` 0.0013139247894287
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028705596923828
(167) DESCRIBE `sailingdates` 0.0012180805206299
(168) DESCRIBE `ports` 0.0029518604278564
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0
(170) DESCRIBE `ports` 0.0018739700317383
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00049996376037598
(172) DESCRIBE `ports` 0.0012640953063965
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00058317184448242
(174) DESCRIBE `ports` 0.0015168190002441
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00057291984558105
(176) DESCRIBE `ports` 0.0021219253540039
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00055718421936035
(178) DESCRIBE `ports` 0.0061299800872803
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.0063540935516357
(180) DESCRIBE `ports` 0.001554012298584
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00032401084899902
(182) DESCRIBE `ports` 0.0014710426330566
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00028204917907715
(184) DESCRIBE `ports` 0.0012609958648682
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00033378601074219
(186) DESCRIBE `ports` 0.0012531280517578
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.0028870105743408
(188) DESCRIBE `ports` 0.0012760162353516
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0012450218200684
(190) DESCRIBE `ports` 0.0079910755157471
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041317939758301
(192) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66003') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0053441524505615
(193) DESCRIBE `avid_specials` 0.010744094848633
(194) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66003 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.0018200874328613
(195) DESCRIBE `cruiselines` 0.0031008720397949
(196) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00068092346191406
(197) DESCRIBE `orchid_image` 0.0017490386962891
(198) DESCRIBE `cruiselines` 0.0018279552459717
(199) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0002901554107666
(200) DESCRIBE `cruises` 0.0025391578674316
(201) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55703') 0.00036001205444336
(202) DESCRIBE `ships` 0.0027461051940918
(203) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00055718421936035
(204) DESCRIBE `ships` 0.0034818649291992
(205) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00073003768920898
(206) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028204917907715
(207) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025606155395508
(208) DESCRIBE `itineraries` 0.0017249584197998
(209) DESCRIBE `ports` 0.0018160343170166
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00055885314941406
(211) DESCRIBE `ports` 0.0020020008087158
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042009353637695
(213) DESCRIBE `ports` 0.0022499561309814
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039196014404297
(215) DESCRIBE `sailingdates` 0.0023810863494873
(216) DESCRIBE `ports` 0.002396821975708
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00060892105102539
(218) DESCRIBE `ports` 0.0013840198516846
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038003921508789
(220) DESCRIBE `ports` 0.0021572113037109
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00041699409484863
(222) DESCRIBE `ports` 0.0014400482177734
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00033307075500488
(224) DESCRIBE `ports` 0.0013060569763184
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033807754516602
(226) DESCRIBE `ports` 0.0015971660614014
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036501884460449
(228) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '55703') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0095059871673584
(229) DESCRIBE `avid_specials` 0.0017828941345215
(230) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55703 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0015370845794678
(231) DESCRIBE `cruiselines` 0.0020499229431152
(232) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00038886070251465
(233) DESCRIBE `orchid_image` 0.0017390251159668
(234) DESCRIBE `cruiselines` 0.0018351078033447
(235) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0003201961517334
(236) DESCRIBE `cruises` 0.0026090145111084
(237) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65892') 0.00037908554077148
(238) DESCRIBE `ships` 0.003087043762207
(239) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00039100646972656
(240) DESCRIBE `ships` 0.0029089450836182
(241) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00033283233642578
(242) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00043702125549316
(243) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037908554077148
(244) DESCRIBE `itineraries` 0.00136399269104
(245) DESCRIBE `ports` 0.0013678073883057
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046491622924805
(247) DESCRIBE `ports` 0.0015039443969727
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034093856811523
(249) DESCRIBE `ports` 0.0015192031860352
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.000579833984375
(251) DESCRIBE `sailingdates` 0.0016469955444336
(252) DESCRIBE `ports` 0.0017068386077881
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0048670768737793
(254) DESCRIBE `ports` 0.0015661716461182
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00094008445739746
(256) DESCRIBE `ports` 0.0018270015716553
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0
(258) DESCRIBE `ports` 0.0015640258789062
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00030899047851562
(260) DESCRIBE `ports` 0.010631084442139
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.004539966583252
(262) DESCRIBE `ports` 0.0014281272888184
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00028586387634277
(264) DESCRIBE `ports` 0.001255989074707
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0002901554107666
(266) DESCRIBE `ports` 0.0014169216156006
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00039100646972656
(268) DESCRIBE `ports` 0.0014610290527344
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031590461730957
(270) DESCRIBE `ports` 0.0012509822845459
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028300285339355
(272) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '65892') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0049340724945068
(273) DESCRIBE `avid_specials` 0.0016717910766602
(274) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65892 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0019211769104004
(275) DESCRIBE `cruiselines` 0.0029878616333008
(276) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0018088817596436
(277) DESCRIBE `orchid_image` 0.0017361640930176
(278) DESCRIBE `cruiselines` 0.0019280910491943
(279) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00030088424682617
(280) DESCRIBE `cruises` 0.0020091533660889
(281) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66004') 0.00035309791564941
(282) DESCRIBE `ships` 0.0025880336761475
(283) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00045514106750488
(284) DESCRIBE `ships` 0.0044949054718018
(285) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00032997131347656
(286) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026988983154297
(287) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033187866210938
(288) DESCRIBE `itineraries` 0.0016648769378662
(289) DESCRIBE `ports` 0.0019931793212891
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038409233093262
(291) DESCRIBE `ports` 0.0025010108947754
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037407875061035
(293) DESCRIBE `ports` 0.0013799667358398
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00032806396484375
(295) DESCRIBE `sailingdates` 0.0012798309326172
(296) DESCRIBE `ports` 0.0021300315856934
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034403800964355
(298) DESCRIBE `ports` 0.0016059875488281
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037503242492676
(300) DESCRIBE `ports` 0.0023889541625977
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.0006101131439209
(302) DESCRIBE `ports` 0.0012428760528564
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00037002563476562
(304) DESCRIBE `ports` 0.0017409324645996
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4208))) 0.00034689903259277
(306) DESCRIBE `ports` 0.0015738010406494
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4208') 0.00030708312988281
(308) DESCRIBE `ports` 0.0014410018920898
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00032806396484375
(310) DESCRIBE `ports` 0.0013699531555176
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00030207633972168
(312) DESCRIBE `ports` 0.0012907981872559
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00030612945556641
(314) DESCRIBE `ports` 0.0013189315795898
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00028491020202637
(316) DESCRIBE `ports` 0.0013070106506348
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034284591674805
(318) DESCRIBE `ports` 0.0014290809631348
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040102005004883
(320) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66004') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0082859992980957
(321) DESCRIBE `avid_specials` 0.0014188289642334
(322) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66004 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.0010838508605957
(323) DESCRIBE `cruiselines` 0.0019669532775879
(324) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00064802169799805
(325) DESCRIBE `orchid_image` 0.0018727779388428
(326) DESCRIBE `cruiselines` 0.0035810470581055
(327) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00033092498779297
(328) DESCRIBE `cruises` 0.0030109882354736
(329) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65893') 0
(330) DESCRIBE `ships` 0.0027430057525635
(331) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00038313865661621
(332) DESCRIBE `ships` 0.00520920753479
(333) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00039100646972656
(334) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026798248291016
(335) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028896331787109
(336) DESCRIBE `itineraries` 0.0015878677368164
(337) DESCRIBE `ports` 0.0016241073608398
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037384033203125
(339) DESCRIBE `ports` 0.0016899108886719
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037789344787598
(341) DESCRIBE `ports` 0.0013039112091064
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028705596923828
(343) DESCRIBE `sailingdates` 0.0014040470123291
(344) DESCRIBE `ports` 0.0016989707946777
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0010302066802979
(346) DESCRIBE `ports` 0.0016350746154785
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038504600524902
(348) DESCRIBE `ports` 0.0023210048675537
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00043797492980957
(350) DESCRIBE `ports` 0.00078797340393066
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00031805038452148
(352) DESCRIBE `ports` 0.0019099712371826
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00048995018005371
(354) DESCRIBE `ports` 0.0012650489807129
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00048995018005371
(356) DESCRIBE `ports` 0.00211501121521
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00049686431884766
(358) DESCRIBE `ports` 0.0019290447235107
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00045108795166016
(360) DESCRIBE `ports` 0.0018620491027832
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0003209114074707
(362) DESCRIBE `ports` 0.0013918876647949
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00029897689819336
(364) DESCRIBE `ports` 0.001291036605835
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030612945556641
(366) DESCRIBE `ports` 0.0013608932495117
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028777122497559
(368) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '65893') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0055708885192871
(369) DESCRIBE `avid_specials` 0.0015161037445068
(370) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65893 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0011641979217529
(371) DESCRIBE `cruiselines` 0.0019779205322266
(372) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00043487548828125
(373) DESCRIBE `orchid_image` 0.0015578269958496
(374) DESCRIBE `cruiselines` 0.0018570423126221
(375) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00029706954956055
(376) DESCRIBE `cruises` 0.0039288997650146
(377) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66005') 0.08967399597168
(378) DESCRIBE `ships` 0.0031960010528564
(379) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.0001981258392334
(380) DESCRIBE `ships` 0.0017008781433105
(381) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.0002448558807373
(382) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025510787963867
(383) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025486946105957
(384) DESCRIBE `itineraries` 0.0014638900756836
(385) DESCRIBE `ports` 0.0088250637054443
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00053095817565918
(387) DESCRIBE `ports` 0.0010440349578857
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0
(389) DESCRIBE `ports` 0.0013358592987061
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 6.0081481933594E-5
(391) DESCRIBE `sailingdates` 0.0020201206207275
(392) DESCRIBE `ports` 0.00082588195800781
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0
(394) DESCRIBE `ports` 0.0013611316680908
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00047612190246582
(396) DESCRIBE `ports` 0.0029261112213135
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00093698501586914
(398) DESCRIBE `ports` 0.0019829273223877
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0
(400) DESCRIBE `ports` 0.0022141933441162
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00052976608276367
(402) DESCRIBE `ports` 0.0014190673828125
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0
(404) DESCRIBE `ports` 0.0019190311431885
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.001107931137085
(406) DESCRIBE `ports` 0.0027039051055908
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0
(408) DESCRIBE `ports` 0.0015311241149902
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00046992301940918
(410) DESCRIBE `ports` 0.001046895980835
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00033998489379883
(412) DESCRIBE `ports` 0.0027608871459961
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00046515464782715
(414) DESCRIBE `ports` 0.0021579265594482
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00041794776916504
(416) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66005') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.01205587387085
(417) DESCRIBE `avid_specials` 0.0017728805541992
(418) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66005 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.0017240047454834
(419) DESCRIBE `cruiselines` 0.0087828636169434
(420) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0026829242706299
(421) DESCRIBE `orchid_image` 0.0024909973144531
(422) DESCRIBE `cruiselines` 0.0041229724884033
(423) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00036001205444336
(424) DESCRIBE `cruises` 0.0036458969116211
(425) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50866') 0.005640983581543
(426) DESCRIBE `ships` 0.0040831565856934
(427) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00048923492431641
(428) DESCRIBE `ships` 0.0037250518798828
(429) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00041604042053223
(430) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034308433532715
(431) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032997131347656
(432) DESCRIBE `itineraries` 0.0017871856689453
(433) DESCRIBE `ports` 0.0018739700317383
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047206878662109
(435) DESCRIBE `ports` 0.0019149780273438
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00082302093505859
(437) DESCRIBE `ports` 0.0024821758270264
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0
(439) DESCRIBE `sailingdates` 0.00111985206604
(440) DESCRIBE `ports` 0.00054407119750977
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0
(442) DESCRIBE `ports` 0.0019419193267822
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00061202049255371
(444) DESCRIBE `ports` 0.00051307678222656
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00033092498779297
(446) DESCRIBE `ports` 0.0015990734100342
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00028491020202637
(448) DESCRIBE `ports` 0.0015099048614502
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0001521110534668
(450) DESCRIBE `ports` 0.0019819736480713
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00016212463378906
(452) DESCRIBE `ports` 0.0011990070343018
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00029087066650391
(454) DESCRIBE `ports` 0.0012121200561523
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00038385391235352
(456) DESCRIBE `ports` 0.00063681602478027
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032901763916016
(458) DESCRIBE `ports` 0.0018289089202881
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043010711669922
(460) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '50866') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0059709548950195
(461) DESCRIBE `avid_specials` 0.0010530948638916
(462) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 50866 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.00067901611328125
(463) DESCRIBE `cruiselines` 0.0022039413452148
(464) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00044107437133789
(465) DESCRIBE `orchid_image` 0.0025160312652588
(466) DESCRIBE `cruiselines` 0.0011160373687744
(467) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0
(468) DESCRIBE `ships` 0.0043489933013916
(469) SELECT `ships`.* FROM `ships` WHERE (id IN ('4', '288')) ORDER BY FIND_IN_SET(id, '4,288') 0.00062704086303711
(470) DESCRIBE `cruisetypes` 0.0010769367218018
(471) DESCRIBE `destinations` 0.0017619132995605
(472) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.00061416625976562
(473) DESCRIBE `cruiselines` 0.0011060237884521
(474) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00034904479980469
(475) DESCRIBE `cruiselines` 0.0029540061950684
(476) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00028491020202637