or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Drinks Package Comparison
  3. Regal Princess heads down under!
  4. Catch Up on Cruising: Latest News in bite size!
  5. What happens when you cruise back to back?

Sign up to our newsletter and become the first to know about our latest deals and promotions

Silver Whisper

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

Total elapsed time: 0.65809750556946

# Query Time
(1) connect 0.00084590911865234
(2) DESCRIBE `cruises` 0.003046989440918
(3) SELECT `cruises`.* FROM `cruises` WHERE (orchid_slug = 'whisper-legends-of-cruising-world-cruise-2020-ex-ft-lauderdale-to-amsterdam') AND (orchid_available = 1) LIMIT 1 0.19046497344971
(4) DESCRIBE `avid_specials` 0.0018339157104492
(5) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75504 and class = 'Cruise') OR (item_id = 223 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 40 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.0016670227050781
(6) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75504') 0.00037717819213867
(7) DESCRIBE `ships` 0.0039658546447754
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 223))) 0.00063180923461914
(9) DESCRIBE `ships` 0.0039079189300537
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '223') 0.00049901008605957
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00032782554626465
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00029611587524414
(13) DESCRIBE `itineraries` 0.0014669895172119
(14) DESCRIBE `ports` 0.0013868808746338
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00037312507629395
(16) DESCRIBE `ports` 0.0015978813171387
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00043821334838867
(18) DESCRIBE `ports` 0.0021140575408936
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00041103363037109
(20) DESCRIBE `sailingdates` 0.001655101776123
(21) DESCRIBE `ports` 0.0014290809631348
(22) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00037598609924316
(23) DESCRIBE `ports` 0.0013248920440674
(24) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00029897689819336
(25) DESCRIBE `ports` 0.0013041496276855
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00029897689819336
(27) DESCRIBE `ports` 0.0018019676208496
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00042986869812012
(29) DESCRIBE `ports` 0.0015180110931396
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00033116340637207
(31) DESCRIBE `ports` 0.0020201206207275
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00020909309387207
(33) DESCRIBE `ports` 0.0013129711151123
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2286))) 0.00032401084899902
(35) DESCRIBE `ports` 0.0017800331115723
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2286') 0.00054788589477539
(37) DESCRIBE `ports` 0.00235915184021
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 469))) 0.00050592422485352
(39) DESCRIBE `ports` 0.0019471645355225
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '469') 0.00043082237243652
(41) DESCRIBE `ports` 0.0016098022460938
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1458))) 0.00050997734069824
(43) DESCRIBE `ports` 0.0016489028930664
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1458') 0.00043582916259766
(45) DESCRIBE `ports` 0.0018980503082275
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 470))) 0.00048494338989258
(47) DESCRIBE `ports` 0.0018768310546875
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '470') 0.00042390823364258
(49) DESCRIBE `ports` 0.0017948150634766
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.0004420280456543
(51) DESCRIBE `ports` 0.0014050006866455
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00039291381835938
(53) DESCRIBE `ports` 0.00154709815979
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00041413307189941
(55) DESCRIBE `ports` 0.0014548301696777
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.0004420280456543
(57) DESCRIBE `ports` 0.0014729499816895
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1150))) 0.00040793418884277
(59) DESCRIBE `ports` 0.0016458034515381
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1150') 0.00038290023803711
(61) DESCRIBE `ports` 0.0014688968658447
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00033307075500488
(63) DESCRIBE `ports` 0.0013339519500732
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00030088424682617
(65) DESCRIBE `ports` 0.0013399124145508
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00029921531677246
(67) DESCRIBE `ports` 0.00130295753479
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.0002901554107666
(69) DESCRIBE `ports` 0.0013351440429688
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00031304359436035
(71) DESCRIBE `ports` 0.0013759136199951
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00033903121948242
(73) DESCRIBE `ports` 0.0012919902801514
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 476))) 0.00037193298339844
(75) DESCRIBE `ports` 0.0018761157989502
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '476') 0.00031185150146484
(77) DESCRIBE `ports` 0.0012969970703125
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.00039410591125488
(79) DESCRIBE `ports` 0.0017991065979004
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.0003819465637207
(81) DESCRIBE `ports` 0.0018379688262939
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00040698051452637
(83) DESCRIBE `ports` 0.0013978481292725
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00032711029052734
(85) DESCRIBE `ports` 0.0012919902801514
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00031089782714844
(87) DESCRIBE `ports` 0.00148606300354
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00030708312988281
(89) DESCRIBE `ports` 0.0013220310211182
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.0003349781036377
(91) DESCRIBE `ports` 0.0016939640045166
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0003209114074707
(93) DESCRIBE `ports` 0.0014488697052002
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 9.5367431640625E-7
(95) DESCRIBE `ports` 0.0013620853424072
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00029611587524414
(97) DESCRIBE `ports` 0.0015029907226562
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00034403800964355
(99) DESCRIBE `ports` 0.0013539791107178
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00029492378234863
(101) DESCRIBE `ports` 0.0016059875488281
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00034713745117188
(103) DESCRIBE `ports` 0.001594066619873
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00030088424682617
(105) DESCRIBE `ports` 0.0012860298156738
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2374))) 0.00037598609924316
(107) DESCRIBE `ports` 0.0013279914855957
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2374') 0.00043010711669922
(109) DESCRIBE `ports` 0.0019779205322266
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2374))) 0.00047993659973145
(111) DESCRIBE `ports` 0.0020198822021484
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2374') 0.00042414665222168
(113) DESCRIBE `ports` 0.0024898052215576
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 325))) 0.00049805641174316
(115) DESCRIBE `ports` 0.0019540786743164
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '325') 0.00047206878662109
(117) DESCRIBE `ports` 0.0018620491027832
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 323))) 0.00046706199645996
(119) DESCRIBE `ports` 0.0017681121826172
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '323') 0.00038003921508789
(121) DESCRIBE `ports` 0.0052399635314941
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 324))) 0.00046515464782715
(123) DESCRIBE `ports` 0.0017111301422119
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '324') 0.00036287307739258
(125) DESCRIBE `ports` 0.0018901824951172
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2024))) 0.00035309791564941
(127) DESCRIBE `ports` 0.0015959739685059
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2024') 0.00030803680419922
(129) DESCRIBE `ports` 0.0014150142669678
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 786))) 0.0003669261932373
(131) DESCRIBE `ports` 0.001600980758667
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '786') 0.0003049373626709
(133) DESCRIBE `ports` 0.0014908313751221
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 786))) 0.00036001205444336
(135) DESCRIBE `ports` 0.0015091896057129
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '786') 0.0003209114074707
(137) DESCRIBE `ports` 0.0016560554504395
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1332))) 0.00041413307189941
(139) DESCRIBE `ports` 0.0015549659729004
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1332') 0.00036978721618652
(141) DESCRIBE `ports` 0.0019137859344482
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1331))) 0.00054407119750977
(143) DESCRIBE `ports` 0.0016410350799561
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1331') 0.00032401084899902
(145) DESCRIBE `ports` 0.0017249584197998
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00031518936157227
(147) DESCRIBE `ports` 0.0013220310211182
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00039196014404297
(149) DESCRIBE `ports` 0.0013518333435059
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00036001205444336
(151) DESCRIBE `ports` 0.0014770030975342
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00030398368835449
(153) DESCRIBE `ports` 0.0015091896057129
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00032401084899902
(155) DESCRIBE `ports` 0.0014660358428955
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00039386749267578
(157) DESCRIBE `ports` 0.001478910446167
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1309))) 0.00034499168395996
(159) DESCRIBE `ports` 0.0015060901641846
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1309') 0.00041103363037109
(161) DESCRIBE `ports` 0.0057780742645264
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00043010711669922
(163) DESCRIBE `ports` 0.0027139186859131
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00031304359436035
(165) DESCRIBE `ports` 0.0014400482177734
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 419))) 0.00046205520629883
(167) DESCRIBE `ports` 0.0013370513916016
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '419') 0.00028705596923828
(169) DESCRIBE `ports` 0.0062150955200195
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1340))) 0.00039005279541016
(171) DESCRIBE `ports` 0.0013859272003174
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1340') 0.00096011161804199
(173) DESCRIBE `ports` 0.0016078948974609
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5798))) 0.00033187866210938
(175) DESCRIBE `ports` 0.0013229846954346
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5798') 0.0003199577331543
(177) DESCRIBE `ports` 0.0014469623565674
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 79))) 0.00041007995605469
(179) DESCRIBE `ports` 0.0015320777893066
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '79') 0.00031280517578125
(181) DESCRIBE `ports` 0.0015528202056885
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 440))) 0.00039792060852051
(183) DESCRIBE `ports` 0.0014359951019287
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '440') 0.00023007392883301
(185) DESCRIBE `ports` 0.0012772083282471
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1902))) 0.00030183792114258
(187) DESCRIBE `ports` 0.0013668537139893
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1902') 0.0021171569824219
(189) DESCRIBE `ports` 0.0013480186462402
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00031900405883789
(191) DESCRIBE `ports` 0.0014722347259521
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00032901763916016
(193) DESCRIBE `ports` 0.001291036605835
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034809112548828
(195) DESCRIBE `ports` 0.0015480518341064
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027894973754883
(197) DESCRIBE `ports` 0.0016460418701172
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042080879211426
(199) DESCRIBE `ports` 0.0015110969543457
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0004580020904541
(201) DESCRIBE `ports` 0.0017750263214111
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0003819465637207
(203) DESCRIBE `ports` 0.0027408599853516
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00050592422485352
(205) DESCRIBE `ports` 0.0019910335540771
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.00045204162597656
(207) DESCRIBE `ports` 0.0018990039825439
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.00035190582275391
(209) DESCRIBE `ports` 0.0014948844909668
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 793))) 0.00034904479980469
(211) DESCRIBE `ports` 0.0017051696777344
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '793') 0.00033807754516602
(213) DESCRIBE `ports` 0.0014541149139404
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.0012609958648682
(215) DESCRIBE `ports` 0.0019381046295166
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.0003819465637207
(217) DESCRIBE `ports` 0.0015618801116943
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00040698051452637
(219) DESCRIBE `ports` 0.0016219615936279
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00036907196044922
(221) DESCRIBE `ports` 0.0016450881958008
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00036811828613281
(223) DESCRIBE `ports` 0.0016701221466064
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00037312507629395
(225) DESCRIBE `ports` 0.0018079280853271
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 417))) 0.0006251335144043
(227) DESCRIBE `ports` 0.0018742084503174
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '417') 0.00041580200195312
(229) DESCRIBE `ports` 0.0016059875488281
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0001990795135498
(231) DESCRIBE `ports` 0.001737117767334
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00035715103149414
(233) DESCRIBE `ports` 0.0012030601501465
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0003960132598877
(235) DESCRIBE `ports` 0.0016269683837891
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00038695335388184
(237) DESCRIBE `ports` 0.0015380382537842
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00036096572875977
(239) DESCRIBE `ports` 0.0015881061553955
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00034999847412109
(241) DESCRIBE `ports` 0.0015339851379395
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00035619735717773
(243) DESCRIBE `ports` 0.0015711784362793
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00033688545227051
(245) DESCRIBE `ports` 0.0015950202941895
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) 0.00036287307739258
(247) DESCRIBE `ports` 0.0015630722045898
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') 0.00032687187194824
(249) DESCRIBE `ports` 0.0015411376953125
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 424))) 0.00035500526428223
(251) DESCRIBE `ports` 0.0015578269958496
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '424') 0.00033998489379883
(253) DESCRIBE `ports` 0.0015928745269775
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 481))) 0.00039792060852051
(255) DESCRIBE `ports` 0.0017800331115723
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '481') 0.00040411949157715
(257) DESCRIBE `ports` 0.0016951560974121
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 483))) 0.00042581558227539
(259) DESCRIBE `ports` 0.0016751289367676
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '483') 0.00035810470581055
(261) DESCRIBE `ports` 0.0017378330230713
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 483))) 0.00038790702819824
(263) DESCRIBE `ports` 0.0017139911651611
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '483') 0.00036716461181641
(265) DESCRIBE `ports` 0.001777172088623
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00041103363037109
(267) DESCRIBE `ports` 0.0017449855804443
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00036287307739258
(269) DESCRIBE `ports` 0.0016379356384277
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 609))) 0.0003960132598877
(271) DESCRIBE `ports` 0.0017650127410889
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '609') 0.0003819465637207
(273) DESCRIBE `ports` 0.0016560554504395
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00038814544677734
(275) DESCRIBE `ports` 0.0016748905181885
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00031495094299316
(277) DESCRIBE `ports` 0.0016560554504395
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 429))) 2.0980834960938E-5
(279) DESCRIBE `ports` 0.0017640590667725
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '429') 0.00037097930908203
(281) DESCRIBE `ports` 0.0017220973968506
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00037598609924316
(283) DESCRIBE `ports` 0.0016651153564453
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00038409233093262
(285) DESCRIBE `ports` 0.0016379356384277
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.0003659725189209
(287) DESCRIBE `ports` 0.0017578601837158
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00081396102905273
(289) DESCRIBE `ports` 0.001431941986084
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00039315223693848
(291) DESCRIBE `ports` 0.00164794921875
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00055193901062012
(293) DESCRIBE `ports` 0.0018129348754883
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00042510032653809
(295) DESCRIBE `ports` 0.0016720294952393
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00036883354187012
(297) DESCRIBE `ports` 0.0018110275268555
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00038790702819824
(299) DESCRIBE `ports` 0.0017030239105225
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00040507316589355
(301) DESCRIBE `ports` 0.0017399787902832
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00040602684020996
(303) DESCRIBE `ports` 0.001680850982666
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.0003659725189209
(305) DESCRIBE `ports` 0.0016870498657227
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1842))) 0.00039196014404297
(307) DESCRIBE `ports` 0.0017688274383545
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1842') 0.0003659725189209
(309) DESCRIBE `ports` 0.0017170906066895
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00039291381835938
(311) DESCRIBE `ports` 0.0016860961914062
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00041699409484863
(313) DESCRIBE `ports` 0.0016758441925049
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00062799453735352
(315) DESCRIBE `ports` 0.0015161037445068
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00029611587524414
(317) DESCRIBE `ports` 0.0013291835784912
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 748))) 0.00032687187194824
(319) DESCRIBE `ports` 0.0012919902801514
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '748') 0.00033283233642578
(321) DESCRIBE `ports` 0.0013220310211182
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1062))) 0.00030708312988281
(323) DESCRIBE `ports` 0.0012757778167725
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1062') 0.00028705596923828
(325) DESCRIBE `ports` 0.0013020038604736
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 783))) 0.00030016899108887
(327) DESCRIBE `ports` 0.0013301372528076
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '783') 0.00028705596923828
(329) DESCRIBE `ports` 0.0013329982757568
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00030803680419922
(331) DESCRIBE `ports` 0.0013442039489746
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00028705596923828
(333) DESCRIBE `ports` 0.0013151168823242
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) 0.0003509521484375
(335) DESCRIBE `ports` 0.0014641284942627
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') 0.00043702125549316
(337) DESCRIBE `ports` 0.0015580654144287
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 890))) 0.00034284591674805
(339) DESCRIBE `ports` 0.001492977142334
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '890') 0.00033187866210938
(341) DESCRIBE `ports` 0.0015358924865723
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00041484832763672
(343) DESCRIBE `ports` 0.0015769004821777
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00037789344787598
(345) DESCRIBE `cruiselines` 0.0020568370819092
(346) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00052785873413086
(347) DESCRIBE `orchid_image` 0.0019729137420654
(348) DESCRIBE `cabins` 0.001723051071167
(349) DESCRIBE `deckplans` 0.0015208721160889
(350) DESCRIBE `shipphotos` 0.0019638538360596
(351) DESCRIBE `cruises` 0.018894910812378
(352) SELECT `cruises`.* FROM `cruises` WHERE (id IN (16987, 34150, 34161, 34188, 34711, 44275, 44276, 49176, 49177, 52647)) ORDER BY FIND_IN_SET(id, '16987,34150,34161,34188,34711,44275,44276,49176,49177,52647') 0.0011918544769287
(353) DESCRIBE `cruiselines` 0.0027589797973633
(354) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('183', '218', '19', '26', '77', '23', '7', '12', '20', '8', '18', '171', '144', '101', '31', '103', '50', '131', '96', '29', '239', '15', '258', '191', '33', '91', '206', '37', '120', '16', '114', '24', '262', '36', '268', '14', '28', '174', '110', '208', '156', '221', '187', '141', '153', '118', '49', '151', '211', '30', '216', '181', '88', '4', '212', '264', '225', '238', '159', '140', '184', '249', '90', '113', '230', '213', '182', '276', '136', '261', '57', '64', '237', '47', '188', '180', '115', '35', '232', '248', '95', '73', '209', '231', '52', '105', '116', '82', '219', '119', '146', '59', '134', '244', '195', '168', '196', '240', '170', '229', '256', '204')) ORDER BY FIND_IN_SET(id, '183,218,19,26,77,23,7,12,20,8,18,171,144,101,31,103,50,131,96,29,239,15,258,191,33,91,206,37,120,16,114,24,262,36,268,14,28,174,110,208,156,221,187,141,153,118,49,151,211,30,216,181,88,4,212,264,225,238,159,140,184,249,90,113,230,213,182,276,136,261,57,64,237,47,188,180,115,35,232,248,95,73,209,231,52,105,116,82,219,119,146,59,134,244,195,168,196,240,170,229,256,204') 0.0052249431610107
(355) DESCRIBE `ships` 0.0029709339141846
(356) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1554', '1555', '1127', '974', '1032', '797', '207', '1292', '1205', '977', '258', '1291', '1199', '1599', '1359', '349', '454', '439', '1135', '333', '1272', '404', '780', '855', '1677', '986', '1067', '265', '1237', '1594', '1607', '34', '837', '37', '38', '770', '817', '1588', '21', '22', '27', '378', '461', '31', '28', '393', '407', '1376', '542', '39', '1012', '30', '36', '43', '1245', '573', '970', '726', '1402', '1552', '585', '66', '1424', '35', '1744', '330', '332', '1768', '792', '1284', '1413', '1415', '1422', '882', '1411', '113', '1420', '462', '1419', '1423', '1176', '1410', '1418', '1421', '1587', '24', '711', '11', '1574', '455', '1405', '1773', '9', '10', '580', '722', '1760', '160', '434', '1215', '1021', '1193', '162', '739', '766', '1141', '78', '325', '452', '658', '81', '1682', '69', '1454', '1572', '639', '674', '1008', '1372', '3', '163', '1095', '678', '338', '852', '1168', '1412', '1373', '1319', '1408', '335', '1678', '124', '253', '850', '635', '1172', '1302', '116', '1569', '70', '340', '1159', '111', '285', '1236', '348', '451', '553', '1259', '944', '966', '968', '4', '25', '390', '1108', '1260', '148', '386', '626', '748', '1266', '385', '651', '683', '716', '314', '616', '791', '1320', '1330', '63', '324', '389', '768', '784', '851', '1088', '1323', '1455', '405', '508', '1195', '1325', '1562', '286', '406', '590', '749', '874', '1632', '1645', '375', '559', '582', '1068', '1672', '84', '108', '287', '291', '327', '483', '526', '1301', '1575', '119', '467', '1208', '98', '394', '1742', '854', '1398', '290', '401', '657', '45', '421', '485', '1492', '1571', '1064', '1586', '150', '151', '652', '776', '114', '147', '152', '704', '123', '149', '341', '403', '1308', '223', '520', '547', '775', '883', '954', '1268', '1460', '1269', '1289', '1539', '1711', '885', '1321', '1389', '1724', '262', '1139', '1486', '1601', '1722', '105', '715', '958', '1557', '1717', '351', '1471', '75', '545', '717', '1243', '1738', '790', '1143', '1270', '1282', '1303', '1326', '1327', '1437', '441', '1771', '479', '516', '1040', '1075', '1214', '1526', '1579', '1704', '93', '517', '574', '796', '823', '993', '1013', '1151', '1679', '205', '665', '673', '701', '818', '1063', '1367', '1561', '82', '988', '1218', '1318', '1540', '212', '1262', '1676', '1740', '743', '1566', '1602', '1766', '751', '769', '1043', '1344', '201', '266', '884', '1137', '1144', '1157', '1216', '1217', '1343', '1409', '1721', '503', '795', '1160', '1223', '1226', '1283', '1348', '14', '448', '1027', '1029', '1073', '1229', '1452', '1453', '1604', '1716', '601', '669', '738', '1025', '1090', '1136', '1163', '1247', '1253', '1426', '732', '811', '1241', '1449', '1619', '610', '905', '1019', '1055', '1448', '1496', '1673', '1713', '1715', '74', '417', '996', '997', '1026', '1145', '1152', '1188', '1233', '1358', '1458', '1714', '643', '1351', '1743', '494', '836', '888', '973', '1034', '1149', '1150', '1231', '1345', '1366', '1404', '1474', '1516', '1609', '1663', '1772', '618', '1049', '1196', '1222', '1322', '1360', '1361', '1362', '1368', '1459', '1522', '1647', '1730', '423', '453', '666', '709', '920', '921', '927', '931', '1004', '1047', '1230', '1354', '1470', '1508', '1627', '1729', '208', '914', '923', '1017', '1037', '1407', '1517', '1518', '1567', '1580', '663', '915', '916', '926', '930', '1003', '1042', '1072', '1138', '1140', '1489', '1505', '1593', '1606', '1649', '1674', '1708', '1751', '352', '499', '695', '703', '924', '972', '1001', '1020', '1187', '1352', '1444', '1521', '1596', '1723', '422', '493', '671', '938', '1005', '1054', '1154', '1175', '1514', '1767', '781', '937', '1051', '1515', '1650', '1681', '1684', '672', '1091', '1092', '1254', '1445')) ORDER BY FIND_IN_SET(id, '1761,1554,1555,1127,974,1032,797,207,1292,1205,977,258,1291,1199,1599,1359,349,454,439,1135,333,1272,404,780,855,1677,986,1067,265,1237,1594,1607,34,837,37,38,770,817,1588,21,22,27,378,461,31,28,393,407,1376,542,39,1012,30,36,43,1245,573,970,726,1402,1552,585,66,1424,35,1744,330,332,1768,792,1284,1413,1415,1422,882,1411,113,1420,462,1419,1423,1176,1410,1418,1421,1587,24,711,11,1574,455,1405,1773,9,10,580,722,1760,160,434,1215,1021,1193,162,739,766,1141,78,325,452,658,81,1682,69,1454,1572,639,674,1008,1372,3,163,1095,678,338,852,1168,1412,1373,1319,1408,335,1678,124,253,850,635,1172,1302,116,1569,70,340,1159,111,285,1236,348,451,553,1259,944,966,968,4,25,390,1108,1260,148,386,626,748,1266,385,651,683,716,314,616,791,1320,1330,63,324,389,768,784,851,1088,1323,1455,405,508,1195,1325,1562,286,406,590,749,874,1632,1645,375,559,582,1068,1672,84,108,287,291,327,483,526,1301,1575,119,467,1208,98,394,1742,854,1398,290,401,657,45,421,485,1492,1571,1064,1586,150,151,652,776,114,147,152,704,123,149,341,403,1308,223,520,547,775,883,954,1268,1460,1269,1289,1539,1711,885,1321,1389,1724,262,1139,1486,1601,1722,105,715,958,1557,1717,351,1471,75,545,717,1243,1738,790,1143,1270,1282,1303,1326,1327,1437,441,1771,479,516,1040,1075,1214,1526,1579,1704,93,517,574,796,823,993,1013,1151,1679,205,665,673,701,818,1063,1367,1561,82,988,1218,1318,1540,212,1262,1676,1740,743,1566,1602,1766,751,769,1043,1344,201,266,884,1137,1144,1157,1216,1217,1343,1409,1721,503,795,1160,1223,1226,1283,1348,14,448,1027,1029,1073,1229,1452,1453,1604,1716,601,669,738,1025,1090,1136,1163,1247,1253,1426,732,811,1241,1449,1619,610,905,1019,1055,1448,1496,1673,1713,1715,74,417,996,997,1026,1145,1152,1188,1233,1358,1458,1714,643,1351,1743,494,836,888,973,1034,1149,1150,1231,1345,1366,1404,1474,1516,1609,1663,1772,618,1049,1196,1222,1322,1360,1361,1362,1368,1459,1522,1647,1730,423,453,666,709,920,921,927,931,1004,1047,1230,1354,1470,1508,1627,1729,208,914,923,1017,1037,1407,1517,1518,1567,1580,663,915,916,926,930,1003,1042,1072,1138,1140,1489,1505,1593,1606,1649,1674,1708,1751,352,499,695,703,924,972,1001,1020,1187,1352,1444,1521,1596,1723,422,493,671,938,1005,1054,1154,1175,1514,1767,781,937,1051,1515,1650,1681,1684,672,1091,1092,1254,1445') 0.058623075485229
(357) DESCRIBE `cruisetypes` 0.0021278858184814
(358) DESCRIBE `destinations` 0.0020530223846436
(359) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '35', '22', '54', '25', '37', '9', '2', '43', '8', '39', '53', '28', '26', '38', '55', '40', '7', '11', '48', '21', '30', '49', '45', '29', '44', '56', '34', '10', '52', '32', '46')) ORDER BY FIND_IN_SET(id, '50,12,35,22,54,25,37,9,2,43,8,39,53,28,26,38,55,40,7,11,48,21,30,49,45,29,44,56,34,10,52,32,46') 0.0017960071563721