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

Total elapsed time: 0.69168281555176

# Query Time
(1) connect 0.00080108642578125
(2) DESCRIBE `cruises` 0.0034809112548828
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (70721, 70720, 73029, 73030, 73032, 72992, 72993, 72994, 72995, 72996)) ORDER BY FIND_IN_SET(id, '70721,70720,73029,73030,73032,72992,72993,72994,72995,72996') 0.0021860599517822
(4) DESCRIBE `cruises` 0.0027668476104736
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70721') 0.00034093856811523
(6) DESCRIBE `ships` 0.0024378299713135
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00036406517028809
(8) DESCRIBE `ships` 0.0025360584259033
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00031900405883789
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030183792114258
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024914741516113
(12) DESCRIBE `itineraries` 0.0014839172363281
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70721') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00093293190002441
(14) DESCRIBE `ports` 0.0016121864318848
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00077700614929199
(16) DESCRIBE `ports` 0.0017228126525879
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00081014633178711
(18) DESCRIBE `ports` 0.0017139911651611
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00082302093505859
(20) DESCRIBE `sailingdates` 0.00111985206604
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70721') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00075411796569824
(22) DESCRIBE `ports` 0.0015740394592285
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00035309791564941
(24) DESCRIBE `ports` 0.0013308525085449
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00028014183044434
(26) DESCRIBE `ports` 0.0014100074768066
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00029301643371582
(28) DESCRIBE `ports` 0.0012698173522949
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00031518936157227
(30) DESCRIBE `ports` 0.0012309551239014
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 553))) 0.00030684471130371
(32) DESCRIBE `ports` 0.0012409687042236
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '553') 0.00028800964355469
(34) DESCRIBE `ports` 0.0012950897216797
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00027894973754883
(36) DESCRIBE `ports` 0.0012698173522949
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00026178359985352
(38) DESCRIBE `ports` 0.001270055770874
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3629))) 0.00028300285339355
(40) DESCRIBE `ports` 0.0013298988342285
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3629') 0.00026488304138184
(42) DESCRIBE `ports` 0.0012619495391846
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00029802322387695
(44) DESCRIBE `ports` 0.001284122467041
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00026607513427734
(46) DESCRIBE `ports` 0.0013079643249512
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00028395652770996
(48) DESCRIBE `ports` 0.0012810230255127
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00027894973754883
(50) DESCRIBE `ports` 0.0013070106506348
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00028395652770996
(52) DESCRIBE `ports` 0.0012829303741455
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00027608871459961
(54) DESCRIBE `ports` 0.0012431144714355
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00034499168395996
(56) DESCRIBE `ports` 0.0012810230255127
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.0002748966217041
(58) DESCRIBE `avid_specials` 0.0013539791107178
(59) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70721 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 2 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.0014100074768066
(60) DESCRIBE `cruiselines` 0.0020220279693604
(61) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00036191940307617
(62) DESCRIBE `orchid_image` 0.0014488697052002
(63) DESCRIBE `cruiselines` 0.0018799304962158
(64) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00028014183044434
(65) DESCRIBE `cruises` 0.0025260448455811
(66) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70720') 0.00036501884460449
(67) DESCRIBE `ships` 0.0025970935821533
(68) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.0003662109375
(69) DESCRIBE `ships` 0.002791166305542
(70) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00034809112548828
(71) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027203559875488
(72) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024795532226562
(73) DESCRIBE `itineraries` 0.0013391971588135
(74) DESCRIBE `ports` 0.0012679100036621
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.0003349781036377
(76) DESCRIBE `ports` 0.0013458728790283
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00034594535827637
(78) DESCRIBE `ports` 0.0012919902801514
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00027990341186523
(80) DESCRIBE `sailingdates` 0.0010950565338135
(81) DESCRIBE `ports` 0.0012760162353516
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00029897689819336
(83) DESCRIBE `ports` 0.0012459754943848
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00027704238891602
(85) DESCRIBE `ports` 0.0013108253479004
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00028514862060547
(87) DESCRIBE `ports` 0.0012531280517578
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00026416778564453
(89) DESCRIBE `ports` 0.0012741088867188
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00028610229492188
(91) DESCRIBE `ports` 0.0014081001281738
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00033092498779297
(93) DESCRIBE `ports` 0.0014240741729736
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00032401084899902
(95) DESCRIBE `ports` 0.0013668537139893
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00027894973754883
(97) DESCRIBE `ports` 0.0014400482177734
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00031900405883789
(99) DESCRIBE `ports` 0.0013298988342285
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00027990341186523
(101) DESCRIBE `ports` 0.0012898445129395
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00033998489379883
(103) DESCRIBE `ports` 0.0012550354003906
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.0003669261932373
(105) DESCRIBE `ports` 0.0016489028930664
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00040793418884277
(107) DESCRIBE `ports` 0.0014641284942627
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00012302398681641
(109) DESCRIBE `ports` 0.0012810230255127
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00029587745666504
(111) DESCRIBE `ports` 0.0013010501861572
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00026798248291016
(113) DESCRIBE `avid_specials` 0.0011298656463623
(114) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70720 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 2 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.0012280941009521
(115) DESCRIBE `cruiselines` 0.0017919540405273
(116) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.0003211498260498
(117) DESCRIBE `orchid_image` 0.0017948150634766
(118) DESCRIBE `cruiselines` 0.0022799968719482
(119) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00030303001403809
(120) DESCRIBE `cruises` 0.0027971267700195
(121) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73029') 0.00032711029052734
(122) DESCRIBE `ships` 0.0029580593109131
(123) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00049805641174316
(124) DESCRIBE `ships` 0.0026650428771973
(125) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00076508522033691
(126) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024700164794922
(127) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025510787963867
(128) DESCRIBE `itineraries` 0.0015749931335449
(129) DESCRIBE `ports` 0.0014758110046387
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00038003921508789
(131) DESCRIBE `ports` 0.0010080337524414
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00033688545227051
(133) DESCRIBE `ports` 0.0015490055084229
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0
(135) DESCRIBE `sailingdates` 0.0013089179992676
(136) DESCRIBE `ports` 0.0016341209411621
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00044798851013184
(138) DESCRIBE `ports` 0.0020158290863037
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00039887428283691
(140) DESCRIBE `ports` 0.0017809867858887
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0
(142) DESCRIBE `ports` 0.0017759799957275
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00044107437133789
(144) DESCRIBE `ports` 0.0020730495452881
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00042295455932617
(146) DESCRIBE `ports` 0.00187087059021
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00040602684020996
(148) DESCRIBE `ports` 0.0018739700317383
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3629))) 0.00040793418884277
(150) DESCRIBE `ports` 0.0018198490142822
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3629') 0.00035786628723145
(152) DESCRIBE `ports` 0.0017728805541992
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.0004119873046875
(154) DESCRIBE `ports` 0.0017638206481934
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00047087669372559
(156) DESCRIBE `ports` 0.0018291473388672
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1280))) 0.00040292739868164
(158) DESCRIBE `ports` 0.0018541812896729
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1280') 0.00036287307739258
(160) DESCRIBE `ports` 0.0017828941345215
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 538))) 0.00039505958557129
(162) DESCRIBE `ports` 0.0017459392547607
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '538') 0.00036001205444336
(164) DESCRIBE `ports` 0.0017149448394775
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1308))) 0.00043892860412598
(166) DESCRIBE `ports` 0.0016248226165771
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1308') 0.00032591819763184
(168) DESCRIBE `ports` 0.0014147758483887
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2354))) 0.00029993057250977
(170) DESCRIBE `ports` 0.001295804977417
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2354') 0.00030088424682617
(172) DESCRIBE `ports` 0.00074410438537598
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.0003049373626709
(174) DESCRIBE `ports` 0.001276969909668
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00075984001159668
(176) DESCRIBE `avid_specials` 0.0010340213775635
(177) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73029 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 2 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.0010218620300293
(178) DESCRIBE `cruiselines` 0.0018911361694336
(179) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00030207633972168
(180) DESCRIBE `orchid_image` 0.0015020370483398
(181) DESCRIBE `cruiselines` 0.0018060207366943
(182) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00027203559875488
(183) DESCRIBE `cruises` 0.0023708343505859
(184) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73030') 0.0003361701965332
(185) DESCRIBE `ships` 0.0026519298553467
(186) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00050091743469238
(187) DESCRIBE `ships` 0.0022201538085938
(188) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00070810317993164
(189) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00012588500976562
(190) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033807754516602
(191) DESCRIBE `itineraries` 0.0013740062713623
(192) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '73030') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00081419944763184
(193) DESCRIBE `ports` 0.0016899108886719
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.0003349781036377
(195) DESCRIBE `ports` 0.0013580322265625
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00040292739868164
(197) DESCRIBE `ports` 0.0012879371643066
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00027799606323242
(199) DESCRIBE `sailingdates` 0.0011210441589355
(200) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '73030') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00024604797363281
(201) DESCRIBE `ports` 0.001910924911499
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00047111511230469
(203) DESCRIBE `ports` 0.0016179084777832
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00037384033203125
(205) DESCRIBE `ports` 0.001878023147583
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00041484832763672
(207) DESCRIBE `ports` 0.0017609596252441
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.0003809928894043
(209) DESCRIBE `ports` 0.0017950534820557
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4363))) 0.00040817260742188
(211) DESCRIBE `ports` 0.0017719268798828
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4363') 0.0003809928894043
(213) DESCRIBE `ports` 0.0017499923706055
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00038886070251465
(215) DESCRIBE `ports` 0.0017309188842773
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00035500526428223
(217) DESCRIBE `ports` 0.0017499923706055
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00042891502380371
(219) DESCRIBE `ports` 0.0020129680633545
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00040602684020996
(221) DESCRIBE `ports` 0.0018610954284668
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00042200088500977
(223) DESCRIBE `ports` 0.0018270015716553
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00037002563476562
(225) DESCRIBE `ports` 0.0014991760253906
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 550))) 0.00034785270690918
(227) DESCRIBE `ports` 0.0014739036560059
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '550') 0.0003058910369873
(229) DESCRIBE `ports` 0.0017590522766113
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00030207633972168
(231) DESCRIBE `ports` 0.0012547969818115
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00029492378234863
(233) DESCRIBE `ports` 0.00140380859375
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 596))) 0.00030708312988281
(235) DESCRIBE `ports` 0.0015780925750732
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '596') 0.00037193298339844
(237) DESCRIBE `ports` 0.0016951560974121
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.0003969669342041
(239) DESCRIBE `ports` 0.0017790794372559
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00031113624572754
(241) DESCRIBE `ports` 0.0019359588623047
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00046682357788086
(243) DESCRIBE `ports` 0.0019419193267822
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00040507316589355
(245) DESCRIBE `ports` 0.001823902130127
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 504))) 0.00048303604125977
(247) DESCRIBE `ports` 0.0024809837341309
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '504') 0.00045299530029297
(249) DESCRIBE `ports` 0.0017821788787842
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00041508674621582
(251) DESCRIBE `ports` 0.0018448829650879
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0007328987121582
(253) DESCRIBE `avid_specials` 0.0016629695892334
(254) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73030 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 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.0016329288482666
(255) DESCRIBE `cruiselines` 0.0026719570159912
(256) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00053787231445312
(257) DESCRIBE `orchid_image` 0.0016191005706787
(258) DESCRIBE `cruiselines` 0.0018730163574219
(259) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00030994415283203
(260) DESCRIBE `cruises` 0.0034279823303223
(261) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73032') 0.00056290626525879
(262) DESCRIBE `ships` 0.0027248859405518
(263) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00048089027404785
(264) DESCRIBE `ships` 0.0029110908508301
(265) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00034189224243164
(266) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030708312988281
(267) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033783912658691
(268) DESCRIBE `itineraries` 0.0016088485717773
(269) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '73032') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0005500316619873
(270) DESCRIBE `ports` 0.0016300678253174
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00041604042053223
(272) DESCRIBE `ports` 0.0018970966339111
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00075101852416992
(274) DESCRIBE `ports` 0.0017440319061279
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00038313865661621
(276) DESCRIBE `sailingdates` 0.0014870166778564
(277) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '73032') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00059008598327637
(278) DESCRIBE `ports` 0.002169132232666
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00048685073852539
(280) DESCRIBE `ports` 0.0017919540405273
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00038599967956543
(282) DESCRIBE `ports` 0.0018031597137451
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00042986869812012
(284) DESCRIBE `ports` 0.0018389225006104
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00037407875061035
(286) DESCRIBE `ports` 0.001784086227417
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 178))) 0.00041389465332031
(288) DESCRIBE `ports` 0.0022609233856201
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '178') 0.0004429817199707
(290) DESCRIBE `ports` 0.002007007598877
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00050687789916992
(292) DESCRIBE `ports` 0.0014638900756836
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00057506561279297
(294) DESCRIBE `ports` 0.001594066619873
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00037384033203125
(296) DESCRIBE `ports` 0.0019259452819824
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.0003960132598877
(298) DESCRIBE `ports` 0.0017540454864502
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.0004270076751709
(300) DESCRIBE `ports` 0.0017662048339844
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00041580200195312
(302) DESCRIBE `ports` 0.0017569065093994
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00040888786315918
(304) DESCRIBE `ports` 0.0018539428710938
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0003809928894043
(306) DESCRIBE `avid_specials` 0.0015869140625
(307) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73032 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 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.0015518665313721
(308) DESCRIBE `cruiselines` 0.0026290416717529
(309) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00043201446533203
(310) DESCRIBE `orchid_image` 0.0020508766174316
(311) DESCRIBE `cruiselines` 0.0026860237121582
(312) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00040316581726074
(313) DESCRIBE `cruises` 0.0035998821258545
(314) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72992') 0.00045990943908691
(315) DESCRIBE `ships` 0.0032970905303955
(316) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00055599212646484
(317) DESCRIBE `ships` 0.0038309097290039
(318) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00050711631774902
(319) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032997131347656
(320) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035881996154785
(321) DESCRIBE `itineraries` 0.0014100074768066
(322) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72992') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00064706802368164
(323) DESCRIBE `ports` 0.0015468597412109
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00044798851013184
(325) DESCRIBE `ports` 0.001823902130127
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00038313865661621
(327) DESCRIBE `ports` 0.0018222332000732
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0002901554107666
(329) DESCRIBE `sailingdates` 0.0013339519500732
(330) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72992') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00052595138549805
(331) DESCRIBE `ports` 0.0018229484558105
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00040102005004883
(333) DESCRIBE `ports` 0.0016860961914062
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00036096572875977
(335) DESCRIBE `ports` 0.001723051071167
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 417))) 0.00044083595275879
(337) DESCRIBE `ports` 0.0017099380493164
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '417') 0.00037193298339844
(339) DESCRIBE `ports` 0.0017831325531006
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00031614303588867
(341) DESCRIBE `ports` 0.001338005065918
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00026607513427734
(343) DESCRIBE `ports` 0.0015110969543457
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00041389465332031
(345) DESCRIBE `ports` 0.0018157958984375
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00035285949707031
(347) DESCRIBE `ports` 0.0017600059509277
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1037))) 0.00031304359436035
(349) DESCRIBE `ports` 0.0016739368438721
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1037') 0.00040602684020996
(351) DESCRIBE `ports` 0.0015149116516113
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.0003969669342041
(353) DESCRIBE `ports` 0.0017321109771729
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.0003969669342041
(355) DESCRIBE `ports` 0.0016679763793945
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00040221214294434
(357) DESCRIBE `ports` 0.0016829967498779
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00035905838012695
(359) DESCRIBE `ports` 0.0016548633575439
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00048112869262695
(361) DESCRIBE `ports` 0.0016820430755615
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.0003669261932373
(363) DESCRIBE `ports` 0.0016589164733887
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00040793418884277
(365) DESCRIBE `ports` 0.0016598701477051
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00036907196044922
(367) DESCRIBE `ports` 0.001655101776123
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00037884712219238
(369) DESCRIBE `ports` 0.0016500949859619
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00034379959106445
(371) DESCRIBE `ports` 0.0017061233520508
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00036787986755371
(373) DESCRIBE `ports` 0.0014359951019287
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00029206275939941
(375) DESCRIBE `ports` 0.0013070106506348
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2040))) 0.00030303001403809
(377) DESCRIBE `ports` 0.001305103302002
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2040') 0.00027298927307129
(379) DESCRIBE `ports` 0.0012578964233398
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031495094299316
(381) DESCRIBE `ports` 0.0014519691467285
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00032591819763184
(383) DESCRIBE `avid_specials` 0.0015380382537842
(384) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72992 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 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.0010790824890137
(385) DESCRIBE `cruiselines` 0.0019669532775879
(386) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00040507316589355
(387) DESCRIBE `orchid_image` 0.0014369487762451
(388) DESCRIBE `cruiselines` 0.0013659000396729
(389) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00028514862060547
(390) DESCRIBE `cruises` 0.0025670528411865
(391) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72993') 0.00033688545227051
(392) DESCRIBE `ships` 0.0034341812133789
(393) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.0004730224609375
(394) DESCRIBE `ships` 0.0035130977630615
(395) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00040698051452637
(396) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028491020202637
(397) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029706954956055
(398) DESCRIBE `itineraries` 0.0014448165893555
(399) DESCRIBE `ports` 0.0018520355224609
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047898292541504
(401) DESCRIBE `ports` 0.0019090175628662
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00052499771118164
(403) DESCRIBE `ports` 0.0020160675048828
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00045680999755859
(405) DESCRIBE `sailingdates` 0.0017249584197998
(406) DESCRIBE `ports` 0.0020091533660889
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00050902366638184
(408) DESCRIBE `ports` 0.0018939971923828
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042009353637695
(410) DESCRIBE `ports` 0.0018229484558105
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00044608116149902
(412) DESCRIBE `ports` 0.0017929077148438
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00041007995605469
(414) DESCRIBE `ports` 0.0017728805541992
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00044703483581543
(416) DESCRIBE `ports` 0.0018231868743896
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00037384033203125
(418) DESCRIBE `ports` 0.0017979145050049
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00044488906860352
(420) DESCRIBE `ports` 0.0018770694732666
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00041007995605469
(422) DESCRIBE `ports` 0.0018730163574219
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00045299530029297
(424) DESCRIBE `ports` 0.001816987991333
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00042510032653809
(426) DESCRIBE `ports` 0.0018157958984375
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00052094459533691
(428) DESCRIBE `ports` 0.0018711090087891
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00039887428283691
(430) DESCRIBE `ports` 0.0017199516296387
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00049400329589844
(432) DESCRIBE `ports` 0.0018999576568604
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00047993659973145
(434) DESCRIBE `ports` 0.0018939971923828
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00072789192199707
(436) DESCRIBE `ports` 0.0020630359649658
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.0004570484161377
(438) DESCRIBE `ports` 0.0019209384918213
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00050520896911621
(440) DESCRIBE `ports` 0.0019290447235107
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00043702125549316
(442) DESCRIBE `ports` 0.0019018650054932
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00048613548278809
(444) DESCRIBE `ports` 0.0019440650939941
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00042104721069336
(446) DESCRIBE `ports` 0.0018789768218994
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044107437133789
(448) DESCRIBE `ports` 0.0017671585083008
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036501884460449
(450) DESCRIBE `avid_specials` 0.0012669563293457
(451) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72993 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 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.001291036605835
(452) DESCRIBE `cruiselines` 0.0019619464874268
(453) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00034618377685547
(454) DESCRIBE `orchid_image` 0.0014321804046631
(455) DESCRIBE `cruiselines` 0.0020408630371094
(456) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00030994415283203
(457) DESCRIBE `cruises` 0.0026099681854248
(458) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72994') 0.00031113624572754
(459) DESCRIBE `ships` 0.0024330615997314
(460) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00046682357788086
(461) DESCRIBE `ships` 0.0024421215057373
(462) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00037813186645508
(463) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026679039001465
(464) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025510787963867
(465) DESCRIBE `itineraries` 0.0012500286102295
(466) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72994') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00043487548828125
(467) DESCRIBE `ports` 0.0013139247894287
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003960132598877
(469) DESCRIBE `ports` 0.0013191699981689
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029993057250977
(471) DESCRIBE `ports` 0.0013229846954346
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029397010803223
(473) DESCRIBE `sailingdates` 0.0012848377227783
(474) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72994') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00046801567077637
(475) DESCRIBE `ports` 0.0015518665313721
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040102005004883
(477) DESCRIBE `ports` 0.0014011859893799
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029897689819336
(479) DESCRIBE `ports` 0.0012459754943848
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00030398368835449
(481) DESCRIBE `ports` 0.001338005065918
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00027298927307129
(483) DESCRIBE `ports` 0.0012950897216797
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00033378601074219
(485) DESCRIBE `ports` 0.0012609958648682
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00026988983154297
(487) DESCRIBE `ports` 0.0012829303741455
(488) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00029706954956055
(489) DESCRIBE `ports` 0.0013930797576904
(490) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00033116340637207
(491) DESCRIBE `ports` 0.0013449192047119
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027108192443848
(493) DESCRIBE `ports` 0.0012710094451904
(494) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027298927307129
(495) DESCRIBE `avid_specials` 0.0011420249938965
(496) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72994 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 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.0010080337524414
(497) DESCRIBE `cruiselines` 0.0018241405487061
(498) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00032401084899902
(499) DESCRIBE `orchid_image` 0.0013909339904785
(500) DESCRIBE `cruiselines` 0.0017979145050049
(501) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00028014183044434
(502) DESCRIBE `cruises` 0.0026650428771973
(503) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72995') 0.00056600570678711
(504) DESCRIBE `ships` 0.002565860748291
(505) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00049281120300293
(506) DESCRIBE `ships` 0.0025351047515869
(507) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00012707710266113
(508) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026607513427734
(509) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031304359436035
(510) DESCRIBE `itineraries` 0.0012509822845459
(511) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72995') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00060796737670898
(512) DESCRIBE `ports` 0.0013980865478516
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032901763916016
(514) DESCRIBE `ports` 0.0015859603881836
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031590461730957
(516) DESCRIBE `ports` 0.0015048980712891
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027680397033691
(518) DESCRIBE `sailingdates` 0.0011508464813232
(519) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72995') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00044894218444824
(520) DESCRIBE `ports` 0.001305103302002
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031614303588867
(522) DESCRIBE `ports` 0.0013091564178467
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002899169921875
(524) DESCRIBE `ports` 0.0012631416320801
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2086))) 0.00031518936157227
(526) DESCRIBE `ports` 0.0013079643249512
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2086') 0.00028610229492188
(528) DESCRIBE `ports` 0.0017468929290771
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00031805038452148
(530) DESCRIBE `ports` 0.0012760162353516
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00027799606323242
(532) DESCRIBE `ports` 0.00142502784729
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00036787986755371
(534) DESCRIBE `ports` 0.0013129711151123
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00030303001403809
(536) DESCRIBE `ports` 0.0014290809631348
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00029993057250977
(538) DESCRIBE `ports` 0.0013399124145508
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00027108192443848
(540) DESCRIBE `ports` 0.001309871673584
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00031208992004395
(542) DESCRIBE `ports` 0.0012869834899902
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00026893615722656
(544) DESCRIBE `ports` 0.0012950897216797
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 4.7206878662109E-5
(546) DESCRIBE `ports` 0.00093197822570801
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00027894973754883
(548) DESCRIBE `ports` 0.0014140605926514
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00019216537475586
(550) DESCRIBE `ports` 0.0014119148254395
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00028395652770996
(552) DESCRIBE `ports` 0.0013980865478516
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00029706954956055
(554) DESCRIBE `ports` 0.0014679431915283
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00056791305541992
(556) DESCRIBE `ports` 0.0011780261993408
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00030994415283203
(558) DESCRIBE `ports` 0.0012879371643066
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00017213821411133
(560) DESCRIBE `ports` 0.0014278888702393
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00029993057250977
(562) DESCRIBE `ports` 0.0014441013336182
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.0003049373626709
(564) DESCRIBE `ports` 0.0014951229095459
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.0007169246673584
(566) DESCRIBE `ports` 0.0011420249938965
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.0002598762512207
(568) DESCRIBE `ports` 0.0015091896057129
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00030303001403809
(570) DESCRIBE `ports` 0.0013599395751953
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00029301643371582
(572) DESCRIBE `ports` 0.0012869834899902
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00033688545227051
(574) DESCRIBE `ports` 0.0013718605041504
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00029587745666504
(576) DESCRIBE `ports` 0.0014200210571289
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035595893859863
(578) DESCRIBE `ports` 0.0012929439544678
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027108192443848
(580) DESCRIBE `avid_specials` 0.0012619495391846
(581) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72995 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 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.0014019012451172
(582) DESCRIBE `cruiselines` 0.0025091171264648
(583) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00041508674621582
(584) DESCRIBE `orchid_image` 0.0015671253204346
(585) DESCRIBE `cruiselines` 0.0025691986083984
(586) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.0004122257232666
(587) DESCRIBE `cruises` 0.002640962600708
(588) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72996') 0.00038409233093262
(589) DESCRIBE `ships` 0.0026569366455078
(590) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.0004267692565918
(591) DESCRIBE `ships` 0.002781867980957
(592) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00032591819763184
(593) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002591609954834
(594) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024604797363281
(595) DESCRIBE `itineraries` 0.001291036605835
(596) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72996') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00046586990356445
(597) DESCRIBE `ports` 0.0014069080352783
(598) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032687187194824
(599) DESCRIBE `ports` 0.0012950897216797
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036907196044922
(601) DESCRIBE `ports` 0.0012600421905518
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027799606323242
(603) DESCRIBE `sailingdates` 0.0013718605041504
(604) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72996') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00047183036804199
(605) DESCRIBE `ports` 0.0013771057128906
(606) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031685829162598
(607) DESCRIBE `ports` 0.0012609958648682
(608) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002739429473877
(609) DESCRIBE `ports` 0.0012998580932617
(610) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00028800964355469
(611) DESCRIBE `ports` 0.0012350082397461
(612) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0003352165222168
(613) DESCRIBE `ports` 0.0012578964233398
(614) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00029492378234863
(615) DESCRIBE `ports` 0.0012478828430176
(616) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00026702880859375
(617) DESCRIBE `ports` 0.0012459754943848
(618) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00029397010803223
(619) DESCRIBE `ports` 0.0012950897216797
(620) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00027608871459961
(621) DESCRIBE `ports` 0.0012519359588623
(622) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00036096572875977
(623) DESCRIBE `ports` 0.0012838840484619
(624) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00028800964355469
(625) DESCRIBE `ports` 0.001331090927124
(626) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00031208992004395
(627) DESCRIBE `ports` 0.001305103302002
(628) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00033688545227051
(629) DESCRIBE `ports` 0.0013730525970459
(630) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00030994415283203
(631) DESCRIBE `ports` 0.001410961151123
(632) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00027894973754883
(633) DESCRIBE `ports` 0.0013179779052734
(634) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031399726867676
(635) DESCRIBE `ports` 0.0014779567718506
(636) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034999847412109
(637) DESCRIBE `avid_specials` 0.0012459754943848
(638) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72996 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 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.0010638236999512
(639) DESCRIBE `cruiselines` 0.0023360252380371
(640) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00042915344238281
(641) DESCRIBE `orchid_image` 0.0017590522766113
(642) DESCRIBE `cruiselines` 0.0023510456085205
(643) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00035905838012695
(644) DESCRIBE `cruisetypes` 0.0014958381652832
(645) DESCRIBE `destinations` 0.0021779537200928
(646) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('2', '43', '35', '8', '29', '34')) ORDER BY FIND_IN_SET(id, '2,43,35,8,29,34') 0.0011122226715088
(647) DESCRIBE `cruiselines` 0.0026068687438965
(648) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00047397613525391
(649) DESCRIBE `ships` 0.0028810501098633
(650) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00070905685424805
(651) DESCRIBE `cruiselines` 0.0029711723327637
(652) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00050806999206543
(653) DESCRIBE `ships` 0.0037379264831543
(654) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00095081329345703