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

Total elapsed time: 0.64924931526184

# Query Time
(1) connect 0.0009768009185791
(2) DESCRIBE `cruises` 0.004086971282959
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (71761, 71188, 72649, 72583, 63616)) ORDER BY FIND_IN_SET(id, '71761,71188,72649,72583,63616') 0.0027899742126465
(4) DESCRIBE `specials` 0.0059881210327148
(5) DESCRIBE `specials` 0.0060501098632812
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1472718') 0.00057792663574219
(7) DESCRIBE `ships` 0.0039041042327881
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1398))) 0.0006101131439209
(9) DESCRIBE `ships` 0.0040030479431152
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1398') 0.00052618980407715
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00029182434082031
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00031900405883789
(13) DESCRIBE `itineraries` 0.0019359588623047
(14) DESCRIBE `ports` 0.0021500587463379
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00047707557678223
(16) DESCRIBE `ports` 0.0018930435180664
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00047087669372559
(18) DESCRIBE `ports` 0.0019218921661377
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00041604042053223
(20) DESCRIBE `specialsailingdates` 0.0016279220581055
(21) DESCRIBE `sailingdates` 0.0015702247619629
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 454981))) 0.00094509124755859
(23) DESCRIBE `ports` 0.001884937286377
(24) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00043797492980957
(25) DESCRIBE `ports` 0.0019481182098389
(26) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00041484832763672
(27) DESCRIBE `ports` 0.0018570423126221
(28) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00047802925109863
(29) DESCRIBE `ports` 0.0018820762634277
(30) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00045394897460938
(31) DESCRIBE `ports` 0.0019090175628662
(32) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049996376037598
(33) DESCRIBE `ports` 0.0018339157104492
(34) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00051999092102051
(35) DESCRIBE `ports` 0.0018150806427002
(36) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046896934509277
(37) DESCRIBE `ports` 0.0019130706787109
(38) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0004429817199707
(39) DESCRIBE `ports` 0.0018761157989502
(40) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00044512748718262
(41) DESCRIBE `ports` 0.0015671253204346
(42) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00040602684020996
(43) DESCRIBE `ports` 0.0018670558929443
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.00047111511230469
(45) DESCRIBE `ports` 0.0019128322601318
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.00037097930908203
(47) DESCRIBE `ports` 0.0015430450439453
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 793))) 0.00033712387084961
(49) DESCRIBE `ports` 0.0016701221466064
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '793') 0.00043797492980957
(51) DESCRIBE `ports` 0.0017361640930176
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00044512748718262
(53) DESCRIBE `ports` 0.0019140243530273
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00044989585876465
(55) DESCRIBE `ports` 0.0019009113311768
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00043606758117676
(57) DESCRIBE `ports` 0.0015289783477783
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00035810470581055
(59) DESCRIBE `ports` 0.0017008781433105
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2480))) 0.0007929801940918
(61) DESCRIBE `ports` 0.0091159343719482
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2480') 0.00065898895263672
(63) DESCRIBE `ports` 0.002856969833374
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.0023899078369141
(65) DESCRIBE `ports` 0.0019159317016602
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00038981437683105
(67) DESCRIBE `cruises` 0.0035161972045898
(68) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71761))) 0.00063014030456543
(69) DESCRIBE `avid_specials` 0.0015838146209717
(70) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1472718 and class = 'Special') OR (item_id = 71761 and class = 'Cruise') OR (item_id = 1398 AND class = 'Ship') OR (item_id = 29 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.0024001598358154
(71) DESCRIBE `cruiselines` 0.0026159286499023
(72) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00048398971557617
(73) DESCRIBE `orchid_image` 0.0026061534881592
(74) DESCRIBE `specials` 0.0054750442504883
(75) DESCRIBE `specials` 0.0089130401611328
(76) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1470474') 0.0021178722381592
(77) DESCRIBE `ships` 0.0042600631713867
(78) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 148))) 0.00028896331787109
(79) DESCRIBE `ships` 0.0032808780670166
(80) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '148') 0.00052404403686523
(81) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00029397010803223
(82) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00028204917907715
(83) DESCRIBE `itineraries` 0.001701831817627
(84) DESCRIBE `ports` 0.00166916847229
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00047802925109863
(86) DESCRIBE `ports` 0.0019559860229492
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00050711631774902
(88) DESCRIBE `ports` 0.0019340515136719
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00041794776916504
(90) DESCRIBE `specialsailingdates` 0.0018818378448486
(91) DESCRIBE `sailingdates` 0.0047049522399902
(92) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 449581))) 0.00070285797119141
(93) DESCRIBE `ports` 0.0021030902862549
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00045895576477051
(95) DESCRIBE `ports` 0.001957893371582
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00043702125549316
(97) DESCRIBE `ports` 0.0018761157989502
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00054216384887695
(99) DESCRIBE `ports` 0.0018999576568604
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00044107437133789
(101) DESCRIBE `ports` 0.0031251907348633
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.00065708160400391
(103) DESCRIBE `ports` 0.0022380352020264
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '479') 0.00047707557678223
(105) DESCRIBE `ports` 0.0019409656524658
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.00033307075500488
(107) DESCRIBE `ports` 0.0020132064819336
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '479') 0.00043892860412598
(109) DESCRIBE `ports` 0.0021770000457764
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.00048708915710449
(111) DESCRIBE `ports` 0.014495134353638
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '479') 0.00060105323791504
(113) DESCRIBE `ports` 0.002241849899292
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.00052118301391602
(115) DESCRIBE `ports` 0.0045280456542969
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '479') 0.00049281120300293
(117) DESCRIBE `ports` 0.0019910335540771
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.000701904296875
(119) DESCRIBE `ports` 0.00319504737854
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00045990943908691
(121) DESCRIBE `ports` 0.0018179416656494
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 178))) 0.00048518180847168
(123) DESCRIBE `ports` 0.0019509792327881
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '178') 0.00045299530029297
(125) DESCRIBE `ports` 0.0025558471679688
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.011528015136719
(127) DESCRIBE `ports` 0.0023989677429199
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00042200088500977
(129) DESCRIBE `cruises` 0.0036680698394775
(130) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71188))) 0.00066614151000977
(131) DESCRIBE `avid_specials` 0.0020360946655273
(132) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1470474 and class = 'Special') OR (item_id = 71188 and class = 'Cruise') OR (item_id = 148 AND class = 'Ship') OR (item_id = 29 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.0020890235900879
(133) DESCRIBE `cruiselines` 0.0081570148468018
(134) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00095105171203613
(135) DESCRIBE `orchid_image` 0.0023908615112305
(136) DESCRIBE `specials` 0.0053250789642334
(137) DESCRIBE `specials` 0.0052790641784668
(138) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1462541') 0.00065302848815918
(139) DESCRIBE `ships` 0.0040731430053711
(140) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 768))) 0.0012989044189453
(141) DESCRIBE `ships` 0.0050919055938721
(142) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '768') 0.001917839050293
(143) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00051188468933105
(144) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.0003199577331543
(145) DESCRIBE `itineraries` 0.0019979476928711
(146) DESCRIBE `ports` 0.0021178722381592
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00047993659973145
(148) DESCRIBE `ports` 0.0018701553344727
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00060796737670898
(150) DESCRIBE `ports` 0.0021250247955322
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00077295303344727
(152) DESCRIBE `specialsailingdates` 0.0014739036560059
(153) DESCRIBE `sailingdates` 0.0015368461608887
(154) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 458121))) 0.00061702728271484
(155) DESCRIBE `ports` 0.0023798942565918
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00052595138549805
(157) DESCRIBE `ports` 0.0020060539245605
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00078487396240234
(159) DESCRIBE `ports` 0.0020840167999268
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00055813789367676
(161) DESCRIBE `ports` 0.0018558502197266
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00049495697021484
(163) DESCRIBE `ports` 0.0019040107727051
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00046491622924805
(165) DESCRIBE `ports` 0.0018658638000488
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00037693977355957
(167) DESCRIBE `ports` 0.0017650127410889
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00041294097900391
(169) DESCRIBE `ports` 0.0021419525146484
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00036215782165527
(171) DESCRIBE `ports` 0.0017228126525879
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.0005791187286377
(173) DESCRIBE `ports` 0.0019590854644775
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00064897537231445
(175) DESCRIBE `ports` 0.0033860206604004
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 382))) 0.00045013427734375
(177) DESCRIBE `ports` 0.0019299983978271
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '382') 0.00040102005004883
(179) DESCRIBE `ports` 0.0032010078430176
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4360))) 0.0032510757446289
(181) DESCRIBE `ports` 0.0031249523162842
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4360') 0.00046396255493164
(183) DESCRIBE `ports` 0.0041730403900146
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2079))) 0.00063490867614746
(185) DESCRIBE `ports` 0.0020918846130371
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2079') 5.793571472168E-5
(187) DESCRIBE `ports` 0.0020179748535156
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00054097175598145
(189) DESCRIBE `ports` 0.0014979839324951
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.0004880428314209
(191) DESCRIBE `cruises` 0.0039157867431641
(192) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 72649))) 0.00078988075256348
(193) DESCRIBE `avid_specials` 0.0017750263214111
(194) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1462541 and class = 'Special') OR (item_id = 72649 and class = 'Cruise') OR (item_id = 768 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 26 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.0026700496673584
(195) DESCRIBE `cruiselines` 0.0029771327972412
(196) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00053787231445312
(197) DESCRIBE `orchid_image` 0.0022389888763428
(198) DESCRIBE `specials` 0.0051231384277344
(199) DESCRIBE `specials` 0.0054728984832764
(200) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1462554') 0.00057291984558105
(201) DESCRIBE `ships` 0.0046219825744629
(202) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 148))) 0.00071382522583008
(203) DESCRIBE `ships` 0.0038859844207764
(204) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '148') 0.00046801567077637
(205) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00055599212646484
(206) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00034093856811523
(207) DESCRIBE `itineraries` 0.0017340183258057
(208) DESCRIBE `ports` 0.0021018981933594
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00052809715270996
(210) DESCRIBE `ports` 0.0019040107727051
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00048398971557617
(212) DESCRIBE `ports` 0.0016860961914062
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00044584274291992
(214) DESCRIBE `specialsailingdates` 0.001410961151123
(215) DESCRIBE `sailingdates` 0.0017020702362061
(216) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 458018))) 0.00047588348388672
(217) DESCRIBE `ports` 0.001964807510376
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00046300888061523
(219) DESCRIBE `ports` 0.0018339157104492
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00044989585876465
(221) DESCRIBE `ports` 0.0017127990722656
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00045585632324219
(223) DESCRIBE `ports` 0.0018110275268555
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00041413307189941
(225) DESCRIBE `ports` 0.0018579959869385
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2801))) 0.00044417381286621
(227) DESCRIBE `ports` 0.0019350051879883
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2801') 0.0004420280456543
(229) DESCRIBE `ports` 0.0020351409912109
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2613))) 0.00046896934509277
(231) DESCRIBE `ports` 0.001924991607666
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2613') 0.00045299530029297
(233) DESCRIBE `ports` 0.0032069683074951
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 733))) 0.0002751350402832
(235) DESCRIBE `ports` 0.0025849342346191
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '733') 0.00052213668823242
(237) DESCRIBE `ports` 0.0021700859069824
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.0014700889587402
(239) DESCRIBE `ports` 0.002180814743042
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.0019230842590332
(241) DESCRIBE `ports` 0.0071470737457275
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00055098533630371
(243) DESCRIBE `ports` 0.0020380020141602
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.0004730224609375
(245) DESCRIBE `ports` 0.0018019676208496
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00044512748718262
(247) DESCRIBE `ports` 0.0030009746551514
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.0012950897216797
(249) DESCRIBE `ports` 0.003338098526001
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00089907646179199
(251) DESCRIBE `ports` 0.004194974899292
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00049209594726562
(253) DESCRIBE `ports` 0.0020620822906494
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 756))) 0.00075817108154297
(255) DESCRIBE `ports` 0.0022640228271484
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '756') 0.0010089874267578
(257) DESCRIBE `ports` 0.0015828609466553
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00070810317993164
(259) DESCRIBE `ports` 0.0018880367279053
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00057601928710938
(261) DESCRIBE `cruises` 0.0033409595489502
(262) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 72583))) 0.00061798095703125
(263) DESCRIBE `avid_specials` 0.0022921562194824
(264) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1462554 and class = 'Special') OR (item_id = 72583 and class = 'Cruise') OR (item_id = 148 AND class = 'Ship') OR (item_id = 29 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.0018320083618164
(265) DESCRIBE `cruiselines` 0.0036399364471436
(266) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00065803527832031
(267) DESCRIBE `orchid_image` 0.0028660297393799
(268) DESCRIBE `specials` 0.0056030750274658
(269) DESCRIBE `specials` 0.0049991607666016
(270) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1470343') 0.00052690505981445
(271) DESCRIBE `ships` 0.0038821697235107
(272) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1095))) 0.001582145690918
(273) DESCRIBE `ships` 0.0053949356079102
(274) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1095') 0.0018630027770996
(275) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0025811195373535
(276) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0065181255340576
(277) DESCRIBE `itineraries` 0.0020458698272705
(278) DESCRIBE `ports` 0.002241849899292
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2671))) 0.0010170936584473
(280) DESCRIBE `ports` 0.0019469261169434
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2671))) 0.00043797492980957
(282) DESCRIBE `ports` 0.0017158985137939
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2671') 0.00052785873413086
(284) DESCRIBE `specialsailingdates` 0.0017879009246826
(285) DESCRIBE `sailingdates` 0.0017490386962891
(286) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 483062))) 0.00061511993408203
(287) DESCRIBE `ports` 0.0025238990783691
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2671))) 0.00043606758117676
(289) DESCRIBE `ports` 0.0019021034240723
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2671') 0.0003821849822998
(291) DESCRIBE `ports` 0.0023679733276367
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4209))) 0.00061917304992676
(293) DESCRIBE `ports` 0.0025022029876709
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4209') 0.00043511390686035
(295) DESCRIBE `ports` 0.0018589496612549
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2600))) 0.00046706199645996
(297) DESCRIBE `ports` 0.0020608901977539
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2600') 0.00068283081054688
(299) DESCRIBE `ports` 0.0019559860229492
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4451))) 0.0004580020904541
(301) DESCRIBE `ports` 0.0018060207366943
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4451') 0.00043296813964844
(303) DESCRIBE `ports` 0.0018088817596436
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5370))) 0.00055193901062012
(305) DESCRIBE `ports` 0.0018889904022217
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5370') 0.00051212310791016
(307) DESCRIBE `ports` 0.0018739700317383
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2662))) 0.00027894973754883
(309) DESCRIBE `ports` 0.0019490718841553
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2662') 0.0003669261932373
(311) DESCRIBE `ports` 0.0018560886383057
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2525))) 0.00052094459533691
(313) DESCRIBE `ports` 0.0019149780273438
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2525') 0.00047111511230469
(315) DESCRIBE `ports` 0.0015950202941895
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2595))) 0.0004730224609375
(317) DESCRIBE `ports` 0.0019321441650391
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2595') 0.00042295455932617
(319) DESCRIBE `ports` 0.0023560523986816
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5374))) 0.00044989585876465
(321) DESCRIBE `ports` 0.0018789768218994
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5374') 0.00041604042053223
(323) DESCRIBE `ports` 0.001284122467041
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2524))) 0.00055313110351562
(325) DESCRIBE `ports` 0.0017459392547607
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2524') 0.00041699409484863
(327) DESCRIBE `ports` 0.0019819736480713
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2878))) 0.00019288063049316
(329) DESCRIBE `ports` 0.0016942024230957
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2878') 0.00090813636779785
(331) DESCRIBE `ports` 0.0026049613952637
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2666))) 0.00071001052856445
(333) DESCRIBE `ports` 0.0035700798034668
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2666') 0.00056815147399902
(335) DESCRIBE `ports` 0.0044460296630859
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2882))) 0.00084209442138672
(337) DESCRIBE `ports` 0.0036730766296387
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2882') 0.00077009201049805
(339) DESCRIBE `ports` 0.0023858547210693
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2595))) 0.00049209594726562
(341) DESCRIBE `ports` 0.0020489692687988
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2595') 0.0004570484161377
(343) DESCRIBE `cruises` 0.0045959949493408
(344) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 63616))) 0.00091695785522461
(345) DESCRIBE `avid_specials` 0.001906156539917
(346) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1470343 and class = 'Special') OR (item_id = 63616 and class = 'Cruise') OR (item_id = 1095 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 37 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.0016798973083496
(347) DESCRIBE `cruiselines` 0.016203880310059
(348) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00068402290344238
(349) DESCRIBE `orchid_image` 0.0044519901275635
(350) DESCRIBE `ships` 0.0039820671081543
(351) SELECT `ships`.* FROM `ships` WHERE (id IN ('148', '768', '1095', '1398')) ORDER BY FIND_IN_SET(id, '148,768,1095,1398') 0.001121997833252
(352) DESCRIBE `cruisetypes` 0.0018219947814941
(353) DESCRIBE `destinations` 0.0026021003723145
(354) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '26', '35', '37', '43')) ORDER BY FIND_IN_SET(id, '22,26,35,37,43') 0.00096797943115234
(355) DESCRIBE `cruiselines` 0.0030128955841064
(356) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00079488754272461
(357) DESCRIBE `cruiselines` 0.0031931400299072
(358) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00052595138549805