or, enquire about your chosen options

  1. Ultra-Luxury Cruising
  2. The Caribbean is still a Preferred Cruise Destination
  3. Catch Up on Cruising: Latest News in bite size!
  4. 8 Romantic Destinations Around the World
  5. Royal Caribbean Launch “Royal Up”

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

Total elapsed time: 1.528080701828

# Query Time
(1) connect 0.0020129680633545
(2) DESCRIBE `cruises` 0.005098819732666
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (46389, 74134, 73027, 74133, 63703, 68552, 68915, 71763, 76005, 71188)) ORDER BY FIND_IN_SET(id, '46389,74134,73027,74133,63703,68552,68915,71763,76005,71188') 0.0033121109008789
(4) DESCRIBE `cruises` 0.0044028759002686
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '46389') 0.00071287155151367
(6) DESCRIBE `ships` 0.004141092300415
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 84))) 0.00066208839416504
(8) DESCRIBE `ships` 0.0042870044708252
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '84') 0.0016610622406006
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037884712219238
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033879280090332
(12) DESCRIBE `itineraries` 0.0023119449615479
(13) DESCRIBE `ports` 0.0023200511932373
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00064516067504883
(15) DESCRIBE `ports` 0.0028970241546631
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00058412551879883
(17) DESCRIBE `ports` 0.0018219947814941
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00045108795166016
(19) DESCRIBE `sailingdates` 0.0021638870239258
(20) DESCRIBE `ports` 0.0020580291748047
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00054621696472168
(22) DESCRIBE `ports` 0.0019950866699219
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00051593780517578
(24) DESCRIBE `ports` 0.0019311904907227
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00045514106750488
(26) DESCRIBE `ports` 0.0020041465759277
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00066685676574707
(28) DESCRIBE `ports` 0.0024092197418213
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00065708160400391
(30) DESCRIBE `ports` 0.0023441314697266
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00046396255493164
(32) DESCRIBE `ports` 0.0020990371704102
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.00054693222045898
(34) DESCRIBE `ports` 0.0017130374908447
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.00049495697021484
(36) DESCRIBE `ports` 0.001533031463623
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1495))) 0.00043821334838867
(38) DESCRIBE `ports` 0.0015771389007568
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1495') 0.00033688545227051
(40) DESCRIBE `ports` 0.0015561580657959
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00035309791564941
(42) DESCRIBE `ports` 0.0017430782318115
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00039386749267578
(44) DESCRIBE `ports` 0.0016961097717285
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 496))) 0.00036716461181641
(46) DESCRIBE `ports` 0.001910924911499
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '496') 0.00046420097351074
(48) DESCRIBE `ports` 0.0020310878753662
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00043916702270508
(50) DESCRIBE `ports` 0.0017378330230713
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00031590461730957
(52) DESCRIBE `ports` 0.0015430450439453
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 418))) 0.00037598609924316
(54) DESCRIBE `ports` 0.0018649101257324
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '418') 0.00044417381286621
(56) DESCRIBE `ports` 0.0020542144775391
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2374))) 0.00054192543029785
(58) DESCRIBE `ports` 0.0019879341125488
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2374') 0.00039291381835938
(60) DESCRIBE `ports` 0.0017290115356445
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 323))) 0.00034093856811523
(62) DESCRIBE `ports` 0.0017178058624268
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '323') 0.00038385391235352
(64) DESCRIBE `ports` 0.0018999576568604
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5768))) 0.00048017501831055
(66) DESCRIBE `ports` 0.0015771389007568
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5768') 0.00033307075500488
(68) DESCRIBE `ports` 0.0016188621520996
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 335))) 0.00043797492980957
(70) DESCRIBE `ports` 0.0019068717956543
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '335') 0.00042510032653809
(72) DESCRIBE `ports` 0.0019030570983887
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1098))) 0.00037097930908203
(74) DESCRIBE `ports` 0.001370906829834
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1098') 0.00030708312988281
(76) DESCRIBE `ports` 0.0015439987182617
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 431))) 0.00042200088500977
(78) DESCRIBE `ports` 0.0015878677368164
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '431') 0.00033998489379883
(80) DESCRIBE `ports` 0.0016899108886719
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 431))) 0.00043892860412598
(82) DESCRIBE `ports` 0.0019948482513428
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '431') 0.00044012069702148
(84) DESCRIBE `ports` 0.0019731521606445
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1097))) 0.00047016143798828
(86) DESCRIBE `ports` 0.0019440650939941
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1097') 0.00043296813964844
(88) DESCRIBE `ports` 0.0019309520721436
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 879))) 0.00052785873413086
(90) DESCRIBE `ports` 0.0016539096832275
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '879') 0.00034689903259277
(92) DESCRIBE `ports` 0.0016529560089111
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 689))) 0.00049304962158203
(94) DESCRIBE `ports` 0.0020310878753662
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '689') 0.00043511390686035
(96) DESCRIBE `ports` 0.0020179748535156
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2140))) 0.00048685073852539
(98) DESCRIBE `ports` 0.0019998550415039
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2140') 0.0004420280456543
(100) DESCRIBE `ports` 0.0019500255584717
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2140))) 0.00047016143798828
(102) DESCRIBE `ports` 0.0018398761749268
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2140') 0.0004279613494873
(104) DESCRIBE `ports` 0.0016121864318848
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2132))) 0.0004417896270752
(106) DESCRIBE `ports` 0.0015130043029785
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2132') 0.00031304359436035
(108) DESCRIBE `ports` 0.0013580322265625
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00036191940307617
(110) DESCRIBE `ports` 0.0013289451599121
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00028681755065918
(112) DESCRIBE `ports` 0.0015418529510498
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2130))) 0.00035285949707031
(114) DESCRIBE `ports` 0.0017361640930176
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2130') 0.00035786628723145
(116) DESCRIBE `ports` 0.0014269351959229
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00036406517028809
(118) DESCRIBE `ports` 0.001478910446167
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00032186508178711
(120) DESCRIBE `ports` 0.0013642311096191
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 346))) 0.00034499168395996
(122) DESCRIBE `ports` 0.001471996307373
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '346') 0.00031614303588867
(124) DESCRIBE `ports` 0.0019540786743164
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 345))) 0.0004270076751709
(126) DESCRIBE `ports` 0.00177001953125
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '345') 0.00043511390686035
(128) DESCRIBE `ports` 0.0020079612731934
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00069594383239746
(130) DESCRIBE `ports` 0.0021190643310547
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00045204162597656
(132) DESCRIBE `avid_specials` 0.0018138885498047
(133) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 46389 and class = 'Cruise') OR (item_id = 84 AND class = 'Ship') OR (item_id = 18 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.0019240379333496
(134) DESCRIBE `cruiselines` 0.002953052520752
(135) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00042319297790527
(136) DESCRIBE `orchid_image` 0.0017499923706055
(137) DESCRIBE `cruiselines` 0.0022950172424316
(138) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00035595893859863
(139) DESCRIBE `cruises` 0.0033268928527832
(140) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74134') 0.00043201446533203
(141) DESCRIBE `ships` 0.003803014755249
(142) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 265))) 0.00058484077453613
(143) DESCRIBE `ships` 0.003911018371582
(144) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '265') 0.00052189826965332
(145) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031614303588867
(146) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034189224243164
(147) DESCRIBE `itineraries` 0.0017528533935547
(148) DESCRIBE `ports` 0.0019741058349609
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00049519538879395
(150) DESCRIBE `ports` 0.0019600391387939
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00044584274291992
(152) DESCRIBE `ports` 0.0015449523925781
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00031518936157227
(154) DESCRIBE `sailingdates` 0.0012779235839844
(155) DESCRIBE `ports` 0.001488208770752
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00035309791564941
(157) DESCRIBE `ports` 0.0017869472503662
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00033712387084961
(159) DESCRIBE `ports` 0.0013630390167236
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00042819976806641
(161) DESCRIBE `ports` 0.0016889572143555
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.0004122257232666
(163) DESCRIBE `ports` 0.0014960765838623
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.00037097930908203
(165) DESCRIBE `ports` 0.0014030933380127
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.00030708312988281
(167) DESCRIBE `ports` 0.001349925994873
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.0003199577331543
(169) DESCRIBE `ports` 0.0019779205322266
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00044798851013184
(171) DESCRIBE `ports` 0.0019299983978271
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 609))) 0.0005040168762207
(173) DESCRIBE `ports` 0.0016920566558838
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '609') 0.00040602684020996
(175) DESCRIBE `ports` 0.0018198490142822
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00049781799316406
(177) DESCRIBE `ports` 0.001924991607666
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00043678283691406
(179) DESCRIBE `ports` 0.001910924911499
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00045394897460938
(181) DESCRIBE `ports` 0.0019340515136719
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00043010711669922
(183) DESCRIBE `ports` 0.0019350051879883
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00048494338989258
(185) DESCRIBE `ports` 0.0019230842590332
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00041413307189941
(187) DESCRIBE `ports` 0.0018620491027832
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 651))) 0.00043916702270508
(189) DESCRIBE `ports` 0.0019018650054932
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '651') 0.00043296813964844
(191) DESCRIBE `ports` 0.001924991607666
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00057291984558105
(193) DESCRIBE `ports` 0.0020339488983154
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00044703483581543
(195) DESCRIBE `ports` 0.002129077911377
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00043988227844238
(197) DESCRIBE `ports` 0.0015199184417725
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00032806396484375
(199) DESCRIBE `ports` 0.0015189647674561
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.0004279613494873
(201) DESCRIBE `ports` 0.0015990734100342
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00031208992004395
(203) DESCRIBE `ports` 0.001500129699707
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00033783912658691
(205) DESCRIBE `ports` 0.0017960071563721
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00039196014404297
(207) DESCRIBE `ports` 0.001920223236084
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 718))) 0.00046014785766602
(209) DESCRIBE `ports` 0.0019168853759766
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '718') 0.0004279613494873
(211) DESCRIBE `ports` 0.0018479824066162
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00045895576477051
(213) DESCRIBE `ports` 0.0019228458404541
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00042390823364258
(215) DESCRIBE `ports` 0.0019259452819824
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.00046205520629883
(217) DESCRIBE `ports` 0.0018820762634277
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.00042605400085449
(219) DESCRIBE `ports` 0.0018761157989502
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.0004730224609375
(221) DESCRIBE `ports` 0.0020291805267334
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00041294097900391
(223) DESCRIBE `avid_specials` 0.0016860961914062
(224) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74134 and class = 'Cruise') OR (item_id = 265 AND class = 'Ship') OR (item_id = 50 AND class = 'CruiseLine') OR (item_id = 45 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.0017359256744385
(225) DESCRIBE `cruiselines` 0.0027151107788086
(226) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.00045609474182129
(227) DESCRIBE `orchid_image` 0.34603190422058
(228) DESCRIBE `cruiselines` 0.003087043762207
(229) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.00052404403686523
(230) DESCRIBE `cruises` 0.0029339790344238
(231) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73027') 0.00044703483581543
(232) DESCRIBE `ships` 0.0033111572265625
(233) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 406))) 0.00050783157348633
(234) DESCRIBE `ships` 0.0034880638122559
(235) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '406') 0.00063991546630859
(236) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00039100646972656
(237) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00038003921508789
(238) DESCRIBE `itineraries` 0.0021200180053711
(239) DESCRIBE `ports` 0.0022201538085938
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00058412551879883
(241) DESCRIBE `ports` 0.0019259452819824
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00053095817565918
(243) DESCRIBE `ports` 0.0019688606262207
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00045204162597656
(245) DESCRIBE `sailingdates` 0.0017678737640381
(246) DESCRIBE `ports` 0.0021209716796875
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00055408477783203
(248) DESCRIBE `ports` 0.0019369125366211
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00042390823364258
(250) DESCRIBE `ports` 0.0019748210906982
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 609))) 0.00046682357788086
(252) DESCRIBE `ports` 0.00199294090271
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '609') 0.00041794776916504
(254) DESCRIBE `ports` 0.0019941329956055
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00048208236694336
(256) DESCRIBE `ports` 0.0019931793212891
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00056695938110352
(258) DESCRIBE `ports` 0.0021288394927979
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00048494338989258
(260) DESCRIBE `ports` 0.0020589828491211
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00041985511779785
(262) DESCRIBE `ports` 0.0020289421081543
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00045680999755859
(264) DESCRIBE `ports` 0.0019571781158447
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00041604042053223
(266) DESCRIBE `ports` 0.0019221305847168
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0004878044128418
(268) DESCRIBE `ports` 0.0020029544830322
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00048017501831055
(270) DESCRIBE `ports` 0.0019640922546387
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00047588348388672
(272) DESCRIBE `ports` 0.0020139217376709
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00051498413085938
(274) DESCRIBE `ports` 0.002065896987915
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00064706802368164
(276) DESCRIBE `ports` 0.0020251274108887
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00059294700622559
(278) DESCRIBE `ports` 0.001953125
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00041413307189941
(280) DESCRIBE `ports` 0.001676082611084
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00035309791564941
(282) DESCRIBE `ports` 0.0015869140625
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00037813186645508
(284) DESCRIBE `ports` 0.0015521049499512
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00048303604125977
(286) DESCRIBE `ports` 0.00160813331604
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00036907196044922
(288) DESCRIBE `ports` 0.0014469623565674
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.0003349781036377
(290) DESCRIBE `ports` 0.0013740062713623
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00039100646972656
(292) DESCRIBE `ports` 0.0016000270843506
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00031709671020508
(294) DESCRIBE `ports` 0.0017950534820557
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0003809928894043
(296) DESCRIBE `ports` 0.0016648769378662
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00040507316589355
(298) DESCRIBE `ports` 0.0019288063049316
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00042390823364258
(300) DESCRIBE `ports` 0.0014297962188721
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00030803680419922
(302) DESCRIBE `ports` 0.0014128684997559
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00033211708068848
(304) DESCRIBE `ports` 0.0013649463653564
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00032496452331543
(306) DESCRIBE `ports` 0.0013830661773682
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00044608116149902
(308) DESCRIBE `ports` 0.0019121170043945
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.00040006637573242
(310) DESCRIBE `ports` 0.0015950202941895
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00047016143798828
(312) DESCRIBE `ports` 0.0019218921661377
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00041699409484863
(314) DESCRIBE `avid_specials` 0.001655101776123
(315) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73027 and class = 'Cruise') OR (item_id = 406 AND class = 'Ship') OR (item_id = 23 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.001788854598999
(316) DESCRIBE `cruiselines` 0.0027711391448975
(317) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0007469654083252
(318) DESCRIBE `orchid_image` 0.0020520687103271
(319) DESCRIBE `cruiselines` 0.0029921531677246
(320) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00050091743469238
(321) DESCRIBE `cruises` 0.0036628246307373
(322) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74133') 0.00041413307189941
(323) DESCRIBE `ships` 0.0038158893585205
(324) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 265))) 0.00060391426086426
(325) DESCRIBE `ships` 0.0039060115814209
(326) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '265') 0.00063180923461914
(327) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00038695335388184
(328) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036191940307617
(329) DESCRIBE `itineraries` 0.0019741058349609
(330) DESCRIBE `ports` 0.0019040107727051
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00058221817016602
(332) DESCRIBE `ports` 0.0021240711212158
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00053095817565918
(334) DESCRIBE `ports` 0.0021090507507324
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00039911270141602
(336) DESCRIBE `sailingdates` 0.0017409324645996
(337) DESCRIBE `ports` 0.0016579627990723
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00048995018005371
(339) DESCRIBE `ports` 0.0019581317901611
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00047183036804199
(341) DESCRIBE `ports` 0.0019590854644775
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00050997734069824
(343) DESCRIBE `ports` 0.0045981407165527
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00053191184997559
(345) DESCRIBE `ports` 0.0020840167999268
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.00051689147949219
(347) DESCRIBE `ports` 0.0031349658966064
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.00063514709472656
(349) DESCRIBE `ports` 0.0025959014892578
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00054001808166504
(351) DESCRIBE `ports` 0.0021450519561768
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00045680999755859
(353) DESCRIBE `ports` 0.0020201206207275
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 609))) 0.00054693222045898
(355) DESCRIBE `ports` 0.0032379627227783
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '609') 0.00052309036254883
(357) DESCRIBE `ports` 0.0024199485778809
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00053596496582031
(359) DESCRIBE `ports` 0.0021059513092041
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.0006561279296875
(361) DESCRIBE `ports` 0.002810001373291
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00071287155151367
(363) DESCRIBE `ports` 0.0033018589019775
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00058698654174805
(365) DESCRIBE `ports` 0.0053031444549561
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.0013701915740967
(367) DESCRIBE `ports` 0.0034780502319336
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0005490779876709
(369) DESCRIBE `ports` 0.0085220336914062
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 651))) 0.00069499015808105
(371) DESCRIBE `ports` 0.0022130012512207
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '651') 0.00052404403686523
(373) DESCRIBE `ports` 0.001986026763916
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.010526895523071
(375) DESCRIBE `ports` 0.0022928714752197
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00058317184448242
(377) DESCRIBE `ports` 0.0051860809326172
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00079989433288574
(379) DESCRIBE `ports` 0.00337815284729
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00052905082702637
(381) DESCRIBE `ports` 0.0035920143127441
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00062990188598633
(383) DESCRIBE `ports` 0.003486156463623
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00069093704223633
(385) DESCRIBE `avid_specials` 0.0020248889923096
(386) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74133 and class = 'Cruise') OR (item_id = 265 AND class = 'Ship') OR (item_id = 50 AND class = 'CruiseLine') OR (item_id = 45 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.0023758411407471
(387) DESCRIBE `cruiselines` 0.0030977725982666
(388) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.0006248950958252
(389) DESCRIBE `orchid_image` 0.0023019313812256
(390) DESCRIBE `cruiselines` 0.0032448768615723
(391) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.00054502487182617
(392) DESCRIBE `cruises` 0.0040898323059082
(393) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63703') 0.00055909156799316
(394) DESCRIBE `ships` 0.0042068958282471
(395) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 84))) 0.00092411041259766
(396) DESCRIBE `ships` 0.0044379234313965
(397) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '84') 0.00068807601928711
(398) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00038480758666992
(399) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036406517028809
(400) DESCRIBE `itineraries` 0.0022799968719482
(401) DESCRIBE `ports` 0.0025060176849365
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00055289268493652
(403) DESCRIBE `ports` 0.001863956451416
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00043582916259766
(405) DESCRIBE `ports` 0.0017390251159668
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00043010711669922
(407) DESCRIBE `sailingdates` 0.001920223236084
(408) DESCRIBE `ports` 0.002331018447876
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00057506561279297
(410) DESCRIBE `ports` 0.0021259784698486
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00049614906311035
(412) DESCRIBE `ports` 0.0020530223846436
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00051689147949219
(414) DESCRIBE `ports` 0.0021579265594482
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00047898292541504
(416) DESCRIBE `ports` 0.0021369457244873
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00055193901062012
(418) DESCRIBE `ports` 0.0022439956665039
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00056099891662598
(420) DESCRIBE `ports` 0.0020899772644043
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.00056099891662598
(422) DESCRIBE `ports` 0.0021648406982422
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.00052714347839355
(424) DESCRIBE `ports` 0.0021610260009766
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1495))) 0.00056099891662598
(426) DESCRIBE `ports` 0.0023560523986816
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1495') 0.00063180923461914
(428) DESCRIBE `ports` 0.0022389888763428
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.0006258487701416
(430) DESCRIBE `ports` 0.0024900436401367
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00048398971557617
(432) DESCRIBE `ports` 0.0023291110992432
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 496))) 0.00050616264343262
(434) DESCRIBE `ports` 0.0021169185638428
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '496') 0.00053000450134277
(436) DESCRIBE `ports` 0.0019869804382324
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00043702125549316
(438) DESCRIBE `ports` 0.0018720626831055
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00052189826965332
(440) DESCRIBE `ports` 0.0019190311431885
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 418))) 0.00054502487182617
(442) DESCRIBE `ports` 0.001986026763916
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '418') 0.00038909912109375
(444) DESCRIBE `ports` 0.0017619132995605
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2374))) 0.00045490264892578
(446) DESCRIBE `ports` 0.0020499229431152
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2374') 0.00048303604125977
(448) DESCRIBE `ports` 0.0020878314971924
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 323))) 0.00048995018005371
(450) DESCRIBE `ports` 0.0021390914916992
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '323') 0.00076985359191895
(452) DESCRIBE `ports` 0.0026919841766357
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5768))) 0.000579833984375
(454) DESCRIBE `ports` 0.0023529529571533
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5768') 0.00059413909912109
(456) DESCRIBE `avid_specials` 0.0019669532775879
(457) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63703 and class = 'Cruise') OR (item_id = 84 AND class = 'Ship') OR (item_id = 18 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.0021400451660156
(458) DESCRIBE `cruiselines` 0.0031170845031738
(459) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00062990188598633
(460) DESCRIBE `orchid_image` 0.0024340152740479
(461) DESCRIBE `cruiselines` 0.0030970573425293
(462) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.0005340576171875
(463) DESCRIBE `cruises` 0.0040068626403809
(464) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68552') 0.000579833984375
(465) DESCRIBE `ships` 0.0055060386657715
(466) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 265))) 0.00075793266296387
(467) DESCRIBE `ships` 0.0060720443725586
(468) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '265') 0.00067496299743652
(469) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00038695335388184
(470) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036478042602539
(471) DESCRIBE `itineraries` 0.003303050994873
(472) DESCRIBE `ports` 0.0040519237518311
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.0031859874725342
(474) DESCRIBE `ports` 0.0026640892028809
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.0044851303100586
(476) DESCRIBE `ports` 0.0025351047515869
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00051403045654297
(478) DESCRIBE `sailingdates` 0.0017938613891602
(479) DESCRIBE `ports` 0.0023040771484375
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00050210952758789
(481) DESCRIBE `ports` 0.0019481182098389
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00048398971557617
(483) DESCRIBE `ports` 0.0021529197692871
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.0005040168762207
(485) DESCRIBE `ports` 0.0023329257965088
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.0005638599395752
(487) DESCRIBE `ports` 0.0023541450500488
(488) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.00047707557678223
(489) DESCRIBE `ports` 0.0022189617156982
(490) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.00046896934509277
(491) DESCRIBE `ports` 0.0019879341125488
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00050902366638184
(493) DESCRIBE `ports` 0.0020928382873535
(494) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00046801567077637
(495) DESCRIBE `ports` 0.0022850036621094
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 609))) 0.00055289268493652
(497) DESCRIBE `ports` 0.0020802021026611
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '609') 0.00047707557678223
(499) DESCRIBE `ports` 0.0021719932556152
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00050878524780273
(501) DESCRIBE `ports` 0.0021958351135254
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00047588348388672
(503) DESCRIBE `ports` 0.0021109580993652
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00050997734069824
(505) DESCRIBE `ports` 0.0021340847015381
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00049400329589844
(507) DESCRIBE `avid_specials` 0.0017910003662109
(508) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68552 and class = 'Cruise') OR (item_id = 265 AND class = 'Ship') OR (item_id = 50 AND class = 'CruiseLine') OR (item_id = 45 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.0062260627746582
(509) DESCRIBE `cruiselines` 0.0034098625183105
(510) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.001655101776123
(511) DESCRIBE `orchid_image` 0.0029070377349854
(512) DESCRIBE `cruiselines` 0.0032269954681396
(513) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.0005040168762207
(514) DESCRIBE `cruises` 0.0039980411529541
(515) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68915') 0.00055480003356934
(516) DESCRIBE `ships` 0.0039970874786377
(517) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1299))) 0.00064897537231445
(518) DESCRIBE `ships` 0.0041489601135254
(519) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1299') 0.00054311752319336
(520) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036811828613281
(521) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035810470581055
(522) DESCRIBE `itineraries` 0.0021538734436035
(523) DESCRIBE `ports` 0.0022308826446533
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.0005650520324707
(525) DESCRIBE `ports` 0.0019569396972656
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.00044512748718262
(527) DESCRIBE `ports` 0.002173900604248
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '479') 0.00045394897460938
(529) DESCRIBE `sailingdates` 0.0017030239105225
(530) DESCRIBE `ports` 0.0023159980773926
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.00058698654174805
(532) DESCRIBE `ports` 0.0048511028289795
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '479') 0.00056791305541992
(534) DESCRIBE `ports` 0.0025308132171631
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.0005640983581543
(536) DESCRIBE `ports` 0.0026068687438965
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '479') 0.00081491470336914
(538) DESCRIBE `ports` 0.0029251575469971
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4825))) 0.0013010501861572
(540) DESCRIBE `ports` 0.0025949478149414
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4825') 0.00085806846618652
(542) DESCRIBE `ports` 0.0024769306182861
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4823))) 0.00054001808166504
(544) DESCRIBE `ports` 0.0018658638000488
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4823') 0.00047397613525391
(546) DESCRIBE `ports` 0.0023910999298096
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3157))) 0.00070905685424805
(548) DESCRIBE `ports` 0.0021431446075439
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3157') 0.00063776969909668
(550) DESCRIBE `ports` 0.002094030380249
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3516))) 0.00054097175598145
(552) DESCRIBE `ports` 0.0022540092468262
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3516') 0.00060081481933594
(554) DESCRIBE `ports` 0.0023510456085205
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3159))) 0.00073695182800293
(556) DESCRIBE `ports` 0.0020730495452881
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3159') 0.00045585632324219
(558) DESCRIBE `ports` 0.0020771026611328
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3160))) 0.00060081481933594
(560) DESCRIBE `ports` 0.0020480155944824
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3160') 0.00052189826965332
(562) DESCRIBE `ports` 0.0019371509552002
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4533))) 0.00048089027404785
(564) DESCRIBE `ports` 0.0018911361694336
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4533') 0.00046110153198242
(566) DESCRIBE `ports` 0.0017931461334229
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00063896179199219
(568) DESCRIBE `ports` 0.001971960067749
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00063490867614746
(570) DESCRIBE `ports` 0.0020318031311035
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2697))) 0.00066304206848145
(572) DESCRIBE `ports` 0.002161979675293
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2697') 0.00068116188049316
(574) DESCRIBE `ports` 0.0019898414611816
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.00049996376037598
(576) DESCRIBE `ports` 0.0021951198577881
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0.00069689750671387
(578) DESCRIBE `ports` 0.0022008419036865
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4824))) 0.0010409355163574
(580) DESCRIBE `ports` 0.0021631717681885
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4824') 0.00052189826965332
(582) DESCRIBE `ports` 0.0021419525146484
(583) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3165))) 0.00053811073303223
(584) DESCRIBE `ports` 0.0022001266479492
(585) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3165') 0.00052404403686523
(586) DESCRIBE `ports` 0.0021491050720215
(587) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3632))) 0.00051212310791016
(588) DESCRIBE `ports` 0.0021138191223145
(589) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3632') 0.00046801567077637
(590) DESCRIBE `ports` 0.0019171237945557
(591) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00061202049255371
(592) DESCRIBE `ports` 0.0020110607147217
(593) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00059294700622559
(594) DESCRIBE `ports` 0.0019679069519043
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00059604644775391
(596) DESCRIBE `ports` 0.0019841194152832
(597) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00047588348388672
(598) DESCRIBE `avid_specials` 0.0015621185302734
(599) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68915 and class = 'Cruise') OR (item_id = 1299 AND class = 'Ship') OR (item_id = 181 AND class = 'CruiseLine') OR (item_id = 54 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.0018148422241211
(600) DESCRIBE `cruiselines` 0.0026109218597412
(601) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00053286552429199
(602) DESCRIBE `orchid_image` 0.0021710395812988
(603) DESCRIBE `cruiselines` 0.0029358863830566
(604) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00050497055053711
(605) DESCRIBE `cruises` 0.0038230419158936
(606) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71763') 0.00052809715270996
(607) DESCRIBE `ships` 0.0039520263671875
(608) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1398))) 0.00071883201599121
(609) DESCRIBE `ships` 0.0037188529968262
(610) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1398') 0.00055193901062012
(611) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00038599967956543
(612) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00042104721069336
(613) DESCRIBE `itineraries` 0.001945972442627
(614) DESCRIBE `ports` 0.0022919178009033
(615) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00044107437133789
(616) DESCRIBE `ports` 0.0018348693847656
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00040197372436523
(618) DESCRIBE `ports` 0.0014140605926514
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00036001205444336
(620) DESCRIBE `sailingdates` 0.0014479160308838
(621) DESCRIBE `ports` 0.0016989707946777
(622) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00046086311340332
(623) DESCRIBE `ports` 0.0015881061553955
(624) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00037693977355957
(625) DESCRIBE `ports` 0.0017099380493164
(626) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 504))) 0.00039005279541016
(627) DESCRIBE `ports` 0.0017890930175781
(628) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '504') 0.00041103363037109
(629) DESCRIBE `ports` 0.0019800662994385
(630) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00044894218444824
(631) DESCRIBE `ports` 0.0020120143890381
(632) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00043296813964844
(633) DESCRIBE `ports` 0.0018808841705322
(634) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 138))) 0.00040197372436523
(635) DESCRIBE `ports` 0.0019500255584717
(636) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '138') 0.00041699409484863
(637) DESCRIBE `ports` 0.0014510154724121
(638) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00036096572875977
(639) DESCRIBE `ports` 0.0015199184417725
(640) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00035214424133301
(641) DESCRIBE `ports` 0.0014138221740723
(642) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00038599967956543
(643) DESCRIBE `ports` 0.0014090538024902
(644) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00029611587524414
(645) DESCRIBE `ports` 0.0015099048614502
(646) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00046300888061523
(647) DESCRIBE `ports` 0.0018079280853271
(648) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00041794776916504
(649) DESCRIBE `ports` 0.0016498565673828
(650) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 503))) 0.0005190372467041
(651) DESCRIBE `ports` 0.0017809867858887
(652) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '503') 0.00040221214294434
(653) DESCRIBE `ports` 0.0016970634460449
(654) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00038290023803711
(655) DESCRIBE `ports` 0.0020620822906494
(656) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00042819976806641
(657) DESCRIBE `ports` 0.0017988681793213
(658) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00056695938110352
(659) DESCRIBE `ports` 0.0019600391387939
(660) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.0005028247833252
(661) DESCRIBE `avid_specials` 0.001863956451416
(662) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71763 and class = 'Cruise') OR (item_id = 1398 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.001230001449585
(663) DESCRIBE `cruiselines` 0.0022752285003662
(664) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00052309036254883
(665) DESCRIBE `orchid_image` 0.0017659664154053
(666) DESCRIBE `cruises` 0.0036108493804932
(667) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76005') 0.00048685073852539
(668) DESCRIBE `ships` 0.0031650066375732
(669) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1285))) 0.0004270076751709
(670) DESCRIBE `ships` 0.0035040378570557
(671) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1285') 0.0004880428314209
(672) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00037598609924316
(673) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00036406517028809
(674) DESCRIBE `itineraries` 0.0020520687103271
(675) DESCRIBE `ports` 0.0021300315856934
(676) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00050806999206543
(677) DESCRIBE `ports` 0.0019941329956055
(678) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00038695335388184
(679) DESCRIBE `ports` 0.0014438629150391
(680) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00033283233642578
(681) DESCRIBE `sailingdates` 0.0013139247894287
(682) DESCRIBE `ports` 0.0020320415496826
(683) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00049495697021484
(684) DESCRIBE `ports` 0.002047061920166
(685) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00044584274291992
(686) DESCRIBE `ports` 0.0020270347595215
(687) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00045108795166016
(688) DESCRIBE `ports` 0.0019798278808594
(689) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.0003359317779541
(690) DESCRIBE `ports` 0.0017321109771729
(691) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00039887428283691
(692) DESCRIBE `ports` 0.0019619464874268
(693) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00037384033203125
(694) DESCRIBE `ports` 0.0016739368438721
(695) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00045394897460938
(696) DESCRIBE `ports` 0.0014240741729736
(697) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00036001205444336
(698) DESCRIBE `ports` 0.0016448497772217
(699) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00035810470581055
(700) DESCRIBE `ports` 0.001662015914917
(701) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00033187866210938
(702) DESCRIBE `ports` 0.0016460418701172
(703) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 178))) 0.00036787986755371
(704) DESCRIBE `ports` 0.001655101776123
(705) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '178') 0.00039291381835938
(706) DESCRIBE `ports` 0.0018990039825439
(707) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00045514106750488
(708) DESCRIBE `ports` 0.0016641616821289
(709) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00039577484130859
(710) DESCRIBE `ports` 0.0017998218536377
(711) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00041890144348145
(712) DESCRIBE `ports` 0.0017120838165283
(713) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00046396255493164
(714) DESCRIBE `avid_specials` 0.0012931823730469
(715) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76005 and class = 'Cruise') OR (item_id = 1285 AND class = 'Ship') OR (item_id = 37 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.0013179779052734
(716) DESCRIBE `cruiselines` 0.0028879642486572
(717) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00050497055053711
(718) DESCRIBE `orchid_image` 0.0019638538360596
(719) DESCRIBE `cruiselines` 0.002331018447876
(720) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00041413307189941
(721) DESCRIBE `cruises` 0.0033168792724609
(722) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71188') 0.00038886070251465
(723) DESCRIBE `ships` 0.0029778480529785
(724) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 148))) 0.00049495697021484
(725) DESCRIBE `ships` 0.0029969215393066
(726) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '148') 0.00042295455932617
(727) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00037503242492676
(728) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00037193298339844
(729) DESCRIBE `itineraries` 0.0019991397857666
(730) DESCRIBE `ports` 0.0020689964294434
(731) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00056290626525879
(732) DESCRIBE `ports` 0.0019290447235107
(733) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00055098533630371
(734) DESCRIBE `ports` 0.0017330646514893
(735) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00038409233093262
(736) DESCRIBE `sailingdates` 0.0015180110931396
(737) DESCRIBE `ports` 0.0020620822906494
(738) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00051593780517578
(739) DESCRIBE `ports` 0.0018360614776611
(740) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00035309791564941
(741) DESCRIBE `ports` 0.0016570091247559
(742) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00037813186645508
(743) DESCRIBE `ports` 0.0014879703521729
(744) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00038504600524902
(745) DESCRIBE `ports` 0.0019538402557373
(746) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.00050997734069824
(747) DESCRIBE `ports` 0.0020339488983154
(748) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '479') 0.00039887428283691
(749) DESCRIBE `ports` 0.0016069412231445
(750) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.00039100646972656
(751) DESCRIBE `ports` 0.0014970302581787
(752) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '479') 0.00045084953308105
(753) DESCRIBE `ports` 0.0016069412231445
(754) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.00041890144348145
(755) DESCRIBE `ports` 0.0018470287322998
(756) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '479') 0.00036287307739258
(757) DESCRIBE `ports` 0.0018970966339111
(758) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 479))) 0.00045585632324219
(759) DESCRIBE `ports` 0.0019960403442383
(760) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '479') 0.00047087669372559
(761) DESCRIBE `ports` 0.0019588470458984
(762) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00040888786315918
(763) DESCRIBE `ports` 0.0016818046569824
(764) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00039982795715332
(765) DESCRIBE `ports` 0.0016989707946777
(766) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 178))) 0.00047588348388672
(767) DESCRIBE `ports` 0.0016181468963623
(768) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '178') 0.00033998489379883
(769) DESCRIBE `ports` 0.0014588832855225
(770) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00035309791564941
(771) DESCRIBE `ports` 0.0018341541290283
(772) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00039100646972656
(773) DESCRIBE `avid_specials` 0.0016970634460449
(774) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((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.0018179416656494
(775) DESCRIBE `cruiselines` 0.0025050640106201
(776) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00043010711669922
(777) DESCRIBE `orchid_image` 0.0020580291748047
(778) DESCRIBE `cruiselines` 0.0031218528747559
(779) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '26', '183', '19', '23', '12', '7', '20', '131', '18', '8', '144', '171', '221', '31', '103', '101', '268', '15', '232', '156', '96', '258', '239', '50', '251', '29', '206', '33', '191', '114', '91', '212', '14', '24', '120', '28', '37', '187', '16', '170', '262', '49', '256', '36', '204', '110', '47', '208', '195', '240', '146', '220', '181', '153', '118', '174', '229', '30', '151', '88', '108', '128', '141', '159', '35', '216', '236', '168', '196', '4', '249', '38', '200', '264', '90', '211', '238', '73', '225', '140', '113', '147', '39', '275', '57', '132', '184', '59', '213', '48', '257', '64', '276', '261', '182', '219', '230', '115', '188', '237', '95', '180', '231', '248', '52', '116', '266', '209', '105', '82', '235', '244', '62', '134', '119', '177', '210', '224', '245')) ORDER BY FIND_IN_SET(id, '218,77,26,183,19,23,12,7,20,131,18,8,144,171,221,31,103,101,268,15,232,156,96,258,239,50,251,29,206,33,191,114,91,212,14,24,120,28,37,187,16,170,262,49,256,36,204,110,47,208,195,240,146,220,181,153,118,174,229,30,151,88,108,128,141,159,35,216,236,168,196,4,249,38,200,264,90,211,238,73,225,140,113,147,39,275,57,132,184,59,213,48,257,64,276,261,182,219,230,115,188,237,95,180,231,248,52,116,266,209,105,82,235,244,62,134,119,177,210,224,245') 0.0084018707275391
(780) DESCRIBE `ships` 0.0032799243927002
(781) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1761', '1247', '1554', '1324', '1555', '1272', '517', '1794', '780', '986', '974', '1032', '258', '1292', '22', '461', '21', '797', '393', '330', '28', '977', '207', '1599', '1205', '480', '349', '11', '10', '439', '1291', '737', '333', '1010', '9', '404', '739', '1199', '1588', '1135', '1417', '265', '726', '817', '1677', '14', '855', '24', '882', '25', '770', '454', '711', '1607', '3', '113', '731', '1067', '1481', '859', '1359', '1372', '34', '38', '31', '37', '657', '837', '378', '585', '1461', '1744', '985', '1237', '1768', '1239', '542', '1163', '66', '1526', '1413', '748', '390', '1320', '1411', '1579', '1323', '1402', '1424', '332', '526', '970', '1410', '1419', '1420', '1422', '1423', '1594', '43', '573', '327', '854', '1418', '1421', '582', '1773', '39', '407', '1012', '1454', '30', '36', '590', '958', '27', '1013', '1586', '674', '791', '792', '1284', '1415', '1308', '580', '1303', '1326', '1327', '84', '114', '1552', '441', '1183', '335', '455', '1184', '1587', '1682', '35', '1245', '1193', '1236', '1742', '386', '162', '1348', '160', '325', '722', '1412', '385', '639', '434', '521', '601', '1408', '1678', '81', '1168', '452', '683', '852', '857', '1172', '1215', '1382', '1501', '858', '1021', '1176', '775', '1019', '1289', '1376', '119', '1574', '78', '201', '338', '658', '1008', '1160', '1405', '1716', '285', '673', '766', '1159', '1217', '1229', '1604', '1373', '1426', '1782', '610', '776', '1095', '1226', '1743', '111', '462', '850', '1137', '1141', '1711', '69', '211', '644', '678', '1136', '1319', '1325', '1448', '163', '286', '1383', '1384', '1628', '45', '253', '520', '851', '1358', '403', '818', '266', '314', '651', '749', '1068', '1259', '1266', '1455', '151', '968', '1458', '1569', '1630', '451', '508', '1108', '1632', '348', '467', '626', '1516', '1572', '4', '150', '1302', '1330', '1360', '1361', '1362', '63', '324', '375', '405', '869', '966', '1260', '1368', '1459', '1627', '70', '148', '389', '421', '485', '616', '663', '768', '944', '1639', '1751', '1760', '116', '262', '291', '553', '885', '1064', '1148', '1517', '1562', '1672', '1708', '108', '1301', '1322', '123', '340', '1139', '1195', '1614', '1721', '124', '287', '1343', '1452', '1521', '1580', '1581', '98', '703', '784', '954', '1088', '1717', '198', '883', '1020', '152', '290', '1212', '1321', '1575', '1724', '635', '652', '1208', '1486', '1492', '1611', '1722', '1750', '1781', '516', '1344', '1601', '147', '483', '1615', '394', '401', '796', '1150', '1398', '1714', '1738', '341', '1143', '1231', '1269', '1437', '1445', '1522', '223', '406', '559', '1230', '1496', '1539', '1771', '1040', '1075', '1268', '149', '886', '1262', '1444', '1571', '1679', '1681', '547', '717', '1151', '1270', '1557', '1593', '1673', '1684', '545', '656', '704', '716', '1367', '982', '1254', '1318', '1676', '74', '105', '761', '1740', '1766', '494', '1043', '1073', '1514', '1518', '1645', '75', '205', '574', '1144', '1157', '1218', '1566', '1704', '1767', '751', '790', '1223', '1561', '1728', '715', '1027', '1029', '1063', '1213', '1389', '82', '351', '627', '795', '808', '1082', '1453', '1471', '1540', '93', '212', '687', '868', '1025', '1090', '1146', '1158', '1283', '1612', '1613', '1706', '1709', '1729', '1772', '479', '503', '823', '1055', '1713', '1715', '665', '905', '996', '1026', '1214', '1233', '1282', '1316', '1342', '1515', '1791', '493', '767', '1145', '1188', '1297', '1409', '1783', '884', '888', '973', '1034', '1089', '1149', '1156', '1341', '1351', '1366', '1404', '1609', '695', '707', '979', '988', '1024', '1049', '1155', '1196', '1216', '1222', '1345', '1647', '1710', '1730', '417', '666', '685', '920', '921', '927', '931', '1047', '1113', '1296', '1311', '1340', '1354', '1788')) ORDER BY FIND_IN_SET(id, '1127,1761,1247,1554,1324,1555,1272,517,1794,780,986,974,1032,258,1292,22,461,21,797,393,330,28,977,207,1599,1205,480,349,11,10,439,1291,737,333,1010,9,404,739,1199,1588,1135,1417,265,726,817,1677,14,855,24,882,25,770,454,711,1607,3,113,731,1067,1481,859,1359,1372,34,38,31,37,657,837,378,585,1461,1744,985,1237,1768,1239,542,1163,66,1526,1413,748,390,1320,1411,1579,1323,1402,1424,332,526,970,1410,1419,1420,1422,1423,1594,43,573,327,854,1418,1421,582,1773,39,407,1012,1454,30,36,590,958,27,1013,1586,674,791,792,1284,1415,1308,580,1303,1326,1327,84,114,1552,441,1183,335,455,1184,1587,1682,35,1245,1193,1236,1742,386,162,1348,160,325,722,1412,385,639,434,521,601,1408,1678,81,1168,452,683,852,857,1172,1215,1382,1501,858,1021,1176,775,1019,1289,1376,119,1574,78,201,338,658,1008,1160,1405,1716,285,673,766,1159,1217,1229,1604,1373,1426,1782,610,776,1095,1226,1743,111,462,850,1137,1141,1711,69,211,644,678,1136,1319,1325,1448,163,286,1383,1384,1628,45,253,520,851,1358,403,818,266,314,651,749,1068,1259,1266,1455,151,968,1458,1569,1630,451,508,1108,1632,348,467,626,1516,1572,4,150,1302,1330,1360,1361,1362,63,324,375,405,869,966,1260,1368,1459,1627,70,148,389,421,485,616,663,768,944,1639,1751,1760,116,262,291,553,885,1064,1148,1517,1562,1672,1708,108,1301,1322,123,340,1139,1195,1614,1721,124,287,1343,1452,1521,1580,1581,98,703,784,954,1088,1717,198,883,1020,152,290,1212,1321,1575,1724,635,652,1208,1486,1492,1611,1722,1750,1781,516,1344,1601,147,483,1615,394,401,796,1150,1398,1714,1738,341,1143,1231,1269,1437,1445,1522,223,406,559,1230,1496,1539,1771,1040,1075,1268,149,886,1262,1444,1571,1679,1681,547,717,1151,1270,1557,1593,1673,1684,545,656,704,716,1367,982,1254,1318,1676,74,105,761,1740,1766,494,1043,1073,1514,1518,1645,75,205,574,1144,1157,1218,1566,1704,1767,751,790,1223,1561,1728,715,1027,1029,1063,1213,1389,82,351,627,795,808,1082,1453,1471,1540,93,212,687,868,1025,1090,1146,1158,1283,1612,1613,1706,1709,1729,1772,479,503,823,1055,1713,1715,665,905,996,1026,1214,1233,1282,1316,1342,1515,1791,493,767,1145,1188,1297,1409,1783,884,888,973,1034,1089,1149,1156,1341,1351,1366,1404,1609,695,707,979,988,1024,1049,1155,1196,1216,1222,1345,1647,1710,1730,417,666,685,920,921,927,931,1047,1113,1296,1311,1340,1354,1788') 0.070717096328735
(782) DESCRIBE `cruisetypes` 0.0018370151519775
(783) DESCRIBE `destinations` 0.0030629634857178
(784) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '35', '54', '25', '9', '37', '43', '2', '8', '39', '44', '53', '55', '26', '28', '38', '49', '11', '21', '40', '7', '48', '56', '46', '30', '29', '45', '34', '10', '52', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,35,54,25,9,37,43,2,8,39,44,53,55,26,28,38,49,11,21,40,7,48,56,46,30,29,45,34,10,52,32') 0.0027830600738525