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

 
 

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

Total elapsed time: 2.0632991790771

# Query Time
(1) connect 0.00064897537231445
(2) DESCRIBE `cruises` 0.0041179656982422
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (73748, 73034, 34169, 49442, 58199, 69540, 64046, 66888, 71829, 62833)) ORDER BY FIND_IN_SET(id, '73748,73034,34169,49442,58199,69540,64046,66888,71829,62833') 0.0021851062774658
(4) DESCRIBE `cruises` 0.0036368370056152
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73748') 0.00058221817016602
(6) DESCRIBE `ships` 0.0037720203399658
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1257))) 0.00037002563476562
(8) DESCRIBE `ships` 0.0044360160827637
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1257') 0.0004420280456543
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034213066101074
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037503242492676
(12) DESCRIBE `itineraries` 0.0018429756164551
(13) DESCRIBE `ports` 0.0018820762634277
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 495))) 0.00037717819213867
(15) DESCRIBE `ports` 0.0015158653259277
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 495))) 0.00029611587524414
(17) DESCRIBE `ports` 0.0018908977508545
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '495') 0.00029206275939941
(19) DESCRIBE `sailingdates` 0.0017299652099609
(20) DESCRIBE `ports` 0.0022740364074707
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 495))) 0.00032615661621094
(22) DESCRIBE `ports` 0.001453161239624
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '495') 0.00028491020202637
(24) DESCRIBE `ports` 0.0015649795532227
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 495))) 0.00032806396484375
(26) DESCRIBE `ports` 0.0019259452819824
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '495') 0.00041699409484863
(28) DESCRIBE `ports` 0.0014090538024902
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 467))) 0.00027108192443848
(30) DESCRIBE `ports` 0.001255989074707
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '467') 0.0002589225769043
(32) DESCRIBE `ports` 0.0015130043029785
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2055))) 0.00028085708618164
(34) DESCRIBE `ports` 0.0017738342285156
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2055') 0.00040602684020996
(36) DESCRIBE `ports` 0.0013298988342285
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 619))) 0.00039792060852051
(38) DESCRIBE `ports` 0.0016670227050781
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '619') 0.00035405158996582
(40) DESCRIBE `ports` 0.0014989376068115
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 620))) 0.00029301643371582
(42) DESCRIBE `ports` 0.0014288425445557
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '620') 0.00027084350585938
(44) DESCRIBE `ports` 0.0013020038604736
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2827))) 0.00024294853210449
(46) DESCRIBE `ports` 0.0012259483337402
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2827') 0.00024104118347168
(48) DESCRIBE `ports` 0.0013418197631836
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 615))) 0.00034189224243164
(50) DESCRIBE `ports` 0.0015528202056885
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '615') 0.00034117698669434
(52) DESCRIBE `ports` 0.0013728141784668
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2863))) 0.00031900405883789
(54) DESCRIBE `ports` 0.0012390613555908
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2863') 0.00022506713867188
(56) DESCRIBE `ports` 0.0015978813171387
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4889))) 0.0004880428314209
(58) DESCRIBE `ports` 0.0014641284942627
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4889') 0.0003199577331543
(60) DESCRIBE `ports` 0.0018978118896484
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4889))) 0.00032806396484375
(62) DESCRIBE `ports` 0.001939058303833
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4889') 0.00033092498779297
(64) DESCRIBE `ports` 0.0014300346374512
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2864))) 0.00097107887268066
(66) DESCRIBE `ports` 0.0020480155944824
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2864') 0.00041913986206055
(68) DESCRIBE `ports` 0.0018210411071777
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2864))) 0.00047993659973145
(70) DESCRIBE `ports` 0.0018279552459717
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2864') 0.00040912628173828
(72) DESCRIBE `ports` 0.0019741058349609
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3022))) 0.00045299530029297
(74) DESCRIBE `ports` 0.0023062229156494
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3022') 0.0004119873046875
(76) DESCRIBE `ports` 0.001971960067749
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.00045418739318848
(78) DESCRIBE `ports` 0.0020899772644043
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.00040817260742188
(80) DESCRIBE `ports` 0.002418041229248
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4744))) 0.00044703483581543
(82) DESCRIBE `ports` 0.0018289089202881
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4744') 0.00042009353637695
(84) DESCRIBE `ports` 0.0024311542510986
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4744))) 0.00042891502380371
(86) DESCRIBE `ports` 0.0023040771484375
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4744') 0.0004429817199707
(88) DESCRIBE `avid_specials` 0.0015230178833008
(89) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73748 and class = 'Cruise') OR (item_id = 1257 AND class = 'Ship') OR (item_id = 209 AND class = 'CruiseLine') OR (item_id = 48 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.0019998550415039
(90) DESCRIBE `cruiselines` 0.0033919811248779
(91) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 209))) 0.00036716461181641
(92) DESCRIBE `orchid_image` 0.0018041133880615
(93) DESCRIBE `cruiselines` 0.0024521350860596
(94) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '209') 0.00041007995605469
(95) DESCRIBE `cruises` 0.0032830238342285
(96) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73034') 0.00038313865661621
(97) DESCRIBE `ships` 0.003126859664917
(98) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 485))) 0.00063300132751465
(99) DESCRIBE `ships` 0.0035369396209717
(100) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '485') 0.00043988227844238
(101) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031709671020508
(102) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033688545227051
(103) DESCRIBE `itineraries` 0.0014739036560059
(104) DESCRIBE `ports` 0.0016250610351562
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0005190372467041
(106) DESCRIBE `ports` 0.0022671222686768
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042319297790527
(108) DESCRIBE `ports` 0.0023269653320312
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 1.6212463378906E-5
(110) DESCRIBE `sailingdates` 0.0011429786682129
(111) DESCRIBE `ports` 0.0016109943389893
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034999847412109
(113) DESCRIBE `ports` 0.0016109943389893
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00033307075500488
(115) DESCRIBE `ports` 0.0015058517456055
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00035595893859863
(117) DESCRIBE `ports` 0.0015139579772949
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00034713745117188
(119) DESCRIBE `ports` 0.0015130043029785
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00038909912109375
(121) DESCRIBE `ports` 0.001554012298584
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.0003058910369873
(123) DESCRIBE `ports` 0.0016448497772217
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00037288665771484
(125) DESCRIBE `ports` 0.0021028518676758
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.0003809928894043
(127) DESCRIBE `ports` 0.013715982437134
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00049805641174316
(129) DESCRIBE `ports` 0.0022459030151367
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00037693977355957
(131) DESCRIBE `ports` 0.0018870830535889
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.0003669261932373
(133) DESCRIBE `ports` 0.0013771057128906
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00029993057250977
(135) DESCRIBE `ports` 0.0048220157623291
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00032210350036621
(137) DESCRIBE `ports` 0.0017030239105225
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00038814544677734
(139) DESCRIBE `ports` 0.0014321804046631
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00034880638122559
(141) DESCRIBE `ports` 0.0013229846954346
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00029087066650391
(143) DESCRIBE `ports` 0.0013508796691895
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00031399726867676
(145) DESCRIBE `ports` 0.0015230178833008
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00024104118347168
(147) DESCRIBE `ports` 0.001939058303833
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00035691261291504
(149) DESCRIBE `ports` 0.0017158985137939
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00040698051452637
(151) DESCRIBE `ports` 0.0018949508666992
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0024878978729248
(153) DESCRIBE `ports` 0.0026729106903076
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0041851997375488
(155) DESCRIBE `avid_specials` 0.0028009414672852
(156) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73034 and class = 'Cruise') OR (item_id = 485 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.004655122756958
(157) DESCRIBE `cruiselines` 0.0062918663024902
(158) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.0043401718139648
(159) DESCRIBE `orchid_image` 0.0016989707946777
(160) DESCRIBE `cruiselines` 0.0060050487518311
(161) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.0044059753417969
(162) DESCRIBE `cruises` 0.0060479640960693
(163) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '34169') 0.0036959648132324
(164) DESCRIBE `ships` 0.0030150413513184
(165) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 31))) 0.0059940814971924
(166) DESCRIBE `ships` 0.0032780170440674
(167) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '31') 0.0057120323181152
(168) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00033092498779297
(169) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.001060962677002
(170) DESCRIBE `itineraries` 0.0048260688781738
(171) DESCRIBE `ports` 0.0030539035797119
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.0026659965515137
(173) DESCRIBE `ports` 0.0049788951873779
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00060701370239258
(175) DESCRIBE `ports` 0.0057089328765869
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00051093101501465
(177) DESCRIBE `sailingdates` 0.0022940635681152
(178) DESCRIBE `ports` 0.0085339546203613
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.0044291019439697
(180) DESCRIBE `ports` 0.0016348361968994
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00043892860412598
(182) DESCRIBE `ports` 0.0027999877929688
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.0027639865875244
(184) DESCRIBE `ports` 0.0017101764678955
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.0037569999694824
(186) DESCRIBE `ports` 0.0018858909606934
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.0014028549194336
(188) DESCRIBE `ports` 0.0039210319519043
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.00040197372436523
(190) DESCRIBE `ports` 0.0027360916137695
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.0039520263671875
(192) DESCRIBE `ports` 0.0017120838165283
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.0020599365234375
(194) DESCRIBE `ports` 0.0038690567016602
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.0039410591125488
(196) DESCRIBE `ports` 0.0017969608306885
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.003464937210083
(198) DESCRIBE `ports` 0.001345157623291
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 272))) 0.0008537769317627
(200) DESCRIBE `ports` 0.0044050216674805
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '272') 0.0012590885162354
(202) DESCRIBE `ports` 0.0042290687561035
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 273))) 0.0012359619140625
(204) DESCRIBE `ports` 0.004417896270752
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '273') 0.0014801025390625
(206) DESCRIBE `ports` 0.0018360614776611
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.0038268566131592
(208) DESCRIBE `ports` 0.0051548480987549
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.0011279582977295
(210) DESCRIBE `ports` 0.0051701068878174
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 889))) 0.0032670497894287
(212) DESCRIBE `ports` 0.0034408569335938
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '889') 0.0043609142303467
(214) DESCRIBE `ports` 0.0018870830535889
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.0042619705200195
(216) DESCRIBE `ports` 0.0019228458404541
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.0043859481811523
(218) DESCRIBE `ports` 0.00223708152771
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 271))) 0.004647970199585
(220) DESCRIBE `ports` 0.0027520656585693
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '271') 0.0046248435974121
(222) DESCRIBE `ports` 0.0019938945770264
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.0044310092926025
(224) DESCRIBE `ports` 0.0019779205322266
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.010113000869751
(226) DESCRIBE `ports` 0.0019569396972656
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 889))) 0.011713027954102
(228) DESCRIBE `ports` 0.0021681785583496
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '889') 0.0045320987701416
(230) DESCRIBE `ports` 0.010057210922241
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.0032351016998291
(232) DESCRIBE `ports` 0.0020310878753662
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.0042190551757812
(234) DESCRIBE `ports` 0.0015537738800049
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 273))) 0.0033690929412842
(236) DESCRIBE `ports` 0.0013189315795898
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '273') 0.00388503074646
(238) DESCRIBE `ports` 0.0017311573028564
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 272))) 0.0038678646087646
(240) DESCRIBE `ports` 0.0030550956726074
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '272') 0.0035989284515381
(242) DESCRIBE `ports` 0.0041589736938477
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.0012979507446289
(244) DESCRIBE `ports` 0.0016801357269287
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.003324031829834
(246) DESCRIBE `ports` 0.0040988922119141
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.0012991428375244
(248) DESCRIBE `ports` 0.0039949417114258
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.0035190582275391
(250) DESCRIBE `ports` 0.001600980758667
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.0040860176086426
(252) DESCRIBE `ports` 0.0017600059509277
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.0042190551757812
(254) DESCRIBE `ports` 0.0019550323486328
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.0042550563812256
(256) DESCRIBE `ports` 0.0016539096832275
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.0039119720458984
(258) DESCRIBE `ports` 0.0020232200622559
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00037312507629395
(260) DESCRIBE `ports` 0.0051300525665283
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.0074310302734375
(262) DESCRIBE `avid_specials` 0.0017499923706055
(263) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 34169 and class = 'Cruise') OR (item_id = 31 AND class = 'Ship') OR (item_id = 7 AND class = 'CruiseLine') OR (item_id = 25 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.0022120475769043
(264) DESCRIBE `cruiselines` 0.011992931365967
(265) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 7))) 0.00063920021057129
(266) DESCRIBE `orchid_image` 0.0020730495452881
(267) DESCRIBE `cruiselines` 0.0080430507659912
(268) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '7') 0.0044980049133301
(269) DESCRIBE `cruises` 0.003870964050293
(270) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '49442') 0.0053701400756836
(271) DESCRIBE `ships` 0.0091300010681152
(272) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1253))) 0.005518913269043
(273) DESCRIBE `ships` 0.0042738914489746
(274) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1253') 0.0069820880889893
(275) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034403800964355
(276) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00039386749267578
(277) DESCRIBE `itineraries` 0.0025949478149414
(278) DESCRIBE `ports` 0.0090348720550537
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4718))) 0.00054407119750977
(280) DESCRIBE `ports` 0.0018188953399658
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4718))) 0.0038609504699707
(282) DESCRIBE `ports` 0.002647876739502
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4718') 0.0029568672180176
(284) DESCRIBE `sailingdates` 0.0048990249633789
(285) DESCRIBE `ports` 0.002039909362793
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4718))) 0.0043120384216309
(287) DESCRIBE `ports` 0.001816987991333
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4718') 0.0068790912628174
(289) DESCRIBE `ports` 0.0019640922546387
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3615))) 0.001554012298584
(291) DESCRIBE `ports` 0.0070769786834717
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3615') 0.0037741661071777
(293) DESCRIBE `ports` 0.0016450881958008
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4720))) 0.0077171325683594
(295) DESCRIBE `ports` 0.0015749931335449
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4720') 0.00029993057250977
(297) DESCRIBE `ports` 0.0013058185577393
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4720))) 0.0038168430328369
(299) DESCRIBE `ports` 0.0012528896331787
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4720') 0.00028800964355469
(301) DESCRIBE `ports` 0.0020859241485596
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4721))) 0.0036780834197998
(303) DESCRIBE `ports` 0.0018529891967773
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4721') 0.0045571327209473
(305) DESCRIBE `ports` 0.0016231536865234
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4721))) 0.0040090084075928
(307) DESCRIBE `ports` 0.0015230178833008
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4721') 0.0061318874359131
(309) DESCRIBE `ports` 0.0015320777893066
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4703))) 0.0066511631011963
(311) DESCRIBE `ports` 0.0016601085662842
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4703') 0.0071158409118652
(313) DESCRIBE `ports` 0.001521110534668
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4722))) 0.0002741813659668
(315) DESCRIBE `ports` 0.0058069229125977
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4722') 0.00034499168395996
(317) DESCRIBE `ports` 0.0025968551635742
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4724))) 0.0031518936157227
(319) DESCRIBE `ports` 0.0015518665313721
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4724') 0.0025811195373535
(321) DESCRIBE `ports` 0.0014040470123291
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4724))) 0.0035309791564941
(323) DESCRIBE `ports` 0.001439094543457
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4724') 0.0030300617218018
(325) DESCRIBE `ports` 0.0013020038604736
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4725))) 0.0029938220977783
(327) DESCRIBE `ports` 0.0014379024505615
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4725') 0.0030200481414795
(329) DESCRIBE `ports` 0.001410961151123
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4725))) 0.0029909610748291
(331) DESCRIBE `ports` 0.0013351440429688
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4725') 0.0057001113891602
(333) DESCRIBE `ports` 0.0016999244689941
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3620))) 0.00040197372436523
(335) DESCRIBE `ports` 0.0033829212188721
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3620') 0.0051720142364502
(337) DESCRIBE `ports` 0.0018301010131836
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3622))) 0.0016999244689941
(339) DESCRIBE `ports` 0.0076601505279541
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3622') 0.00032520294189453
(341) DESCRIBE `ports` 0.0018079280853271
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3622))) 0.00022602081298828
(343) DESCRIBE `ports` 0.0014050006866455
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3622') 0.0038018226623535
(345) DESCRIBE `ports` 0.0013067722320557
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4729))) 0.0074799060821533
(347) DESCRIBE `ports` 0.0021700859069824
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4729') 0.00049686431884766
(349) DESCRIBE `ports` 0.0055701732635498
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4729))) 0.00056314468383789
(351) DESCRIBE `ports` 0.00217604637146
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4729') 0.0065820217132568
(353) DESCRIBE `avid_specials` 0.0051791667938232
(354) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 49442 and class = 'Cruise') OR (item_id = 1253 AND class = 'Ship') OR (item_id = 248 AND class = 'CruiseLine') OR (item_id = 56 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.0069918632507324
(355) DESCRIBE `cruiselines` 0.009335994720459
(356) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 248))) 0.007498025894165
(357) DESCRIBE `orchid_image` 0.0088341236114502
(358) DESCRIBE `cruiselines` 0.0024800300598145
(359) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '248') 0.00052714347839355
(360) DESCRIBE `cruises` 0.0034048557281494
(361) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58199') 0.0062000751495361
(362) DESCRIBE `ships` 0.0038909912109375
(363) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 768))) 0.00630784034729
(364) DESCRIBE `ships` 0.0032780170440674
(365) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '768') 0.00058102607727051
(366) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00037884712219238
(367) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00030994415283203
(368) DESCRIBE `itineraries` 0.0019600391387939
(369) DESCRIBE `ports` 0.0086791515350342
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00043582916259766
(371) DESCRIBE `ports` 0.0018298625946045
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00045108795166016
(373) DESCRIBE `ports` 0.0017919540405273
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0059881210327148
(375) DESCRIBE `sailingdates` 0.0014228820800781
(376) DESCRIBE `ports` 0.0017919540405273
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00049591064453125
(378) DESCRIBE `ports` 0.0015709400177002
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0065200328826904
(380) DESCRIBE `ports` 0.0020320415496826
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 352))) 0.00044703483581543
(382) DESCRIBE `ports` 0.0019471645355225
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '352') 0.00052189826965332
(384) DESCRIBE `ports` 0.0019938945770264
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.0085740089416504
(386) DESCRIBE `ports` 0.0023508071899414
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00055599212646484
(388) DESCRIBE `ports` 0.0034880638122559
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 663))) 0.00055098533630371
(390) DESCRIBE `ports` 0.0018680095672607
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '663') 0.0063068866729736
(392) DESCRIBE `ports` 0.0020608901977539
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.0005650520324707
(394) DESCRIBE `ports` 0.0018219947814941
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00038409233093262
(396) DESCRIBE `ports` 0.0017290115356445
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.0029029846191406
(398) DESCRIBE `ports` 0.00180983543396
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.0026900768280029
(400) DESCRIBE `ports` 0.0017838478088379
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0050728321075439
(402) DESCRIBE `ports` 0.0022509098052979
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.0043389797210693
(404) DESCRIBE `ports` 0.0061230659484863
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0030629634857178
(406) DESCRIBE `ports` 0.0039641857147217
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0043330192565918
(408) DESCRIBE `avid_specials` 0.0024449825286865
(409) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 58199 and class = 'Cruise') OR (item_id = 768 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 12 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.005730152130127
(410) DESCRIBE `cruiselines` 0.0086228847503662
(411) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.0037779808044434
(412) DESCRIBE `orchid_image` 0.0018088817596436
(413) DESCRIBE `cruises` 0.00730299949646
(414) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69540') 0.0060939788818359
(415) DESCRIBE `ships` 0.0029439926147461
(416) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1602))) 0.0046770572662354
(417) DESCRIBE `ships` 0.0031311511993408
(418) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1602') 0.010800838470459
(419) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032305717468262
(420) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 9.608268737793E-5
(421) DESCRIBE `itineraries` 0.0023331642150879
(422) DESCRIBE `ports` 0.0020570755004883
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 108))) 0
(424) DESCRIBE `ports` 0.0011470317840576
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 108))) 0.003986120223999
(426) DESCRIBE `ports` 0.00665283203125
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '108') 0.00024914741516113
(428) DESCRIBE `sailingdates` 0.002316951751709
(429) DESCRIBE `ports` 0.012200117111206
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 108))) 0.0055861473083496
(431) DESCRIBE `ports` 0.0028069019317627
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '108') 0.0027511119842529
(433) DESCRIBE `ports` 0.0023949146270752
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 108))) 0.0011968612670898
(435) DESCRIBE `ports` 0.0035979747772217
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '108') 0.00033998489379883
(437) DESCRIBE `ports` 0.0023369789123535
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 108))) 0.0029618740081787
(439) DESCRIBE `ports` 0.0028538703918457
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '108') 0.0023510456085205
(441) DESCRIBE `ports` 0.0011658668518066
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 108))) 0.0032727718353271
(443) DESCRIBE `ports` 0.002507209777832
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '108') 0.0034489631652832
(445) DESCRIBE `ports` 0.0011317729949951
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.000946044921875
(447) DESCRIBE `ports` 0.0043139457702637
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '100') 0.00099778175354004
(449) DESCRIBE `ports` 0.0042428970336914
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.0003960132598877
(451) DESCRIBE `ports` 0.0024890899658203
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '100') 0.0042979717254639
(453) DESCRIBE `ports` 0.00205397605896
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5678))) 0.0014050006866455
(455) DESCRIBE `ports` 0.0033760070800781
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5678') 0.00098800659179688
(457) DESCRIBE `ports` 0.0022358894348145
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1690))) 0.0055561065673828
(459) DESCRIBE `ports` 0.0011749267578125
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1690') 0.0030710697174072
(461) DESCRIBE `ports` 0.0018060207366943
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 103))) 0.0039710998535156
(463) DESCRIBE `ports` 0.0014090538024902
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '103') 0.0027899742126465
(465) DESCRIBE `ports` 0.0014090538024902
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 103))) 0.0013151168823242
(467) DESCRIBE `ports` 0.0015568733215332
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '103') 0.0029911994934082
(469) DESCRIBE `ports` 0.0010628700256348
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 102))) 0.0009920597076416
(471) DESCRIBE `ports` 0.0011091232299805
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '102') 0.0027179718017578
(473) DESCRIBE `ports` 0.0013370513916016
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.0014438629150391
(475) DESCRIBE `ports` 0.0016520023345947
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '100') 0.0030100345611572
(477) DESCRIBE `ports` 0.0011868476867676
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 108))) 0.0051071643829346
(479) DESCRIBE `ports` 0.0014569759368896
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '108') 0.00046706199645996
(481) DESCRIBE `ports` 0.0013649463653564
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 108))) 0.0049569606781006
(483) DESCRIBE `ports` 0.0018148422241211
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '108') 0.0072348117828369
(485) DESCRIBE `avid_specials` 0.0016660690307617
(486) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69540 and class = 'Cruise') OR (item_id = 1602 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 44 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.0014069080352783
(487) DESCRIBE `cruiselines` 0.0020589828491211
(488) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.0040380954742432
(489) DESCRIBE `orchid_image` 0.0022830963134766
(490) DESCRIBE `cruiselines` 0.006317138671875
(491) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.0037479400634766
(492) DESCRIBE `cruises` 0.0030651092529297
(493) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64046') 0.0052499771118164
(494) DESCRIBE `ships` 0.0025069713592529
(495) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1259))) 0.0049629211425781
(496) DESCRIBE `ships` 0.0027229785919189
(497) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1259') 0.0083191394805908
(498) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.0010859966278076
(499) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0
(500) DESCRIBE `itineraries` 0.001533031463623
(501) DESCRIBE `ports` 0.0042459964752197
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.003364086151123
(503) DESCRIBE `ports` 0.0016961097717285
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0031399726867676
(505) DESCRIBE `ports` 0.0015280246734619
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.0027608871459961
(507) DESCRIBE `sailingdates` 0.0012860298156738
(508) DESCRIBE `ports` 0.0053670406341553
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0037620067596436
(510) DESCRIBE `ports` 0.0019989013671875
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.0042510032653809
(512) DESCRIBE `ports` 0.0019068717956543
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0044460296630859
(514) DESCRIBE `ports` 0.0029070377349854
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.0062191486358643
(516) DESCRIBE `ports` 0.0018651485443115
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 410))) 0.0075259208679199
(518) DESCRIBE `ports` 0.0010828971862793
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '410') 0.00039219856262207
(520) DESCRIBE `ports` 0.0017170906066895
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00040698051452637
(522) DESCRIBE `ports` 0.0026509761810303
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00038981437683105
(524) DESCRIBE `ports` 0.0017940998077393
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00039410591125488
(526) DESCRIBE `ports` 0.0015928745269775
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0
(528) DESCRIBE `ports` 0.0015830993652344
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00038695335388184
(530) DESCRIBE `ports` 0.0016329288482666
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00030088424682617
(532) DESCRIBE `ports` 0.0019941329956055
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 663))) 0.00066304206848145
(534) DESCRIBE `ports` 0.0016639232635498
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '663') 0
(536) DESCRIBE `ports` 0.0023839473724365
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0
(538) DESCRIBE `ports` 0.0016961097717285
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00037503242492676
(540) DESCRIBE `ports` 0.0015730857849121
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00043511390686035
(542) DESCRIBE `ports` 0.0018901824951172
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00035905838012695
(544) DESCRIBE `ports` 0.0016460418701172
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 347))) 0.0033550262451172
(546) DESCRIBE `ports` 0.001417875289917
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '347') 0.00047492980957031
(548) DESCRIBE `ports` 0.0017039775848389
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0095670223236084
(550) DESCRIBE `ports` 0.011220932006836
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00042486190795898
(552) DESCRIBE `avid_specials` 0.001633882522583
(553) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64046 and class = 'Cruise') OR (item_id = 1259 AND class = 'Ship') OR (item_id = 262 AND class = 'CruiseLine') OR (item_id = 12 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.0028188228607178
(554) DESCRIBE `cruiselines` 0.0089311599731445
(555) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 262))) 0.0005650520324707
(556) DESCRIBE `orchid_image` 0.0019931793212891
(557) DESCRIBE `cruiselines` 0.011646032333374
(558) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '262') 0.00047397613525391
(559) DESCRIBE `cruises` 0.0042939186096191
(560) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66888') 0.0004880428314209
(561) DESCRIBE `ships` 0.0034592151641846
(562) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 968))) 0.0040020942687988
(563) DESCRIBE `ships` 0.01653003692627
(564) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '968') 0.0011498928070068
(565) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031018257141113
(566) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036406517028809
(567) DESCRIBE `itineraries` 0.0017809867858887
(568) DESCRIBE `ports` 0.015864133834839
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00050520896911621
(570) DESCRIBE `ports` 0.00086879730224609
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00043416023254395
(572) DESCRIBE `ports` 0.0017309188842773
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00045084953308105
(574) DESCRIBE `sailingdates` 0.0020978450775146
(575) DESCRIBE `ports` 0.0028269290924072
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0091249942779541
(577) DESCRIBE `ports` 0.0019240379333496
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00043797492980957
(579) DESCRIBE `ports` 0.0017640590667725
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00032401084899902
(581) DESCRIBE `ports` 0.0018138885498047
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00039196014404297
(583) DESCRIBE `ports` 0.0016798973083496
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.0026378631591797
(585) DESCRIBE `ports` 0.0015759468078613
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.0029737949371338
(587) DESCRIBE `ports` 0.0017478466033936
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.0037350654602051
(589) DESCRIBE `ports` 0.0086488723754883
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.013559818267822
(591) DESCRIBE `ports` 0.0018210411071777
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00043916702270508
(593) DESCRIBE `ports` 0.0017209053039551
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.0003659725189209
(595) DESCRIBE `ports` 0.0017819404602051
(596) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.0065021514892578
(597) DESCRIBE `ports` 0.0011980533599854
(598) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.0014021396636963
(599) DESCRIBE `ports` 0.00081396102905273
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00037384033203125
(601) DESCRIBE `ports` 0.0017130374908447
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00034999847412109
(603) DESCRIBE `avid_specials` 0.0024011135101318
(604) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66888 and class = 'Cruise') OR (item_id = 968 AND class = 'Ship') OR (item_id = 8 AND class = 'CruiseLine') OR (item_id = 12 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.0090320110321045
(605) DESCRIBE `cruiselines` 0.0024280548095703
(606) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00054192543029785
(607) DESCRIBE `orchid_image` 0.0029568672180176
(608) DESCRIBE `cruiselines` 0.0057330131530762
(609) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.0026068687438965
(610) DESCRIBE `cruises` 0.0043618679046631
(611) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71829') 0.0088150501251221
(612) DESCRIBE `ships` 0.003093957901001
(613) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 462))) 0.006432056427002
(614) DESCRIBE `ships` 0.0034408569335938
(615) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '462') 0.0094089508056641
(616) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033020973205566
(617) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031089782714844
(618) DESCRIBE `itineraries` 0.0017719268798828
(619) DESCRIBE `ports` 0.0012390613555908
(620) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00044107437133789
(621) DESCRIBE `ports` 0.001568078994751
(622) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0
(623) DESCRIBE `ports` 0.0015881061553955
(624) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.0055739879608154
(625) DESCRIBE `sailingdates` 0.0010550022125244
(626) DESCRIBE `ports` 0.0022099018096924
(627) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.005932092666626
(628) DESCRIBE `ports` 0.0017859935760498
(629) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00037503242492676
(630) DESCRIBE `ports` 0.01190185546875
(631) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00042009353637695
(632) DESCRIBE `ports` 0.0018520355224609
(633) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00034308433532715
(634) DESCRIBE `ports` 0.0034840106964111
(635) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00046205520629883
(636) DESCRIBE `ports` 0.010360956192017
(637) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00090694427490234
(638) DESCRIBE `ports` 0.00091814994812012
(639) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00041389465332031
(640) DESCRIBE `ports` 0.0024759769439697
(641) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 5.4836273193359E-5
(642) DESCRIBE `ports` 0.0021450519561768
(643) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.0004119873046875
(644) DESCRIBE `ports` 0.0080990791320801
(645) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00059080123901367
(646) DESCRIBE `ports` 0.0022091865539551
(647) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0
(648) DESCRIBE `ports` 0.0016000270843506
(649) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0
(650) DESCRIBE `ports` 0.00072979927062988
(651) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.0068421363830566
(652) DESCRIBE `ports` 0.0012791156768799
(653) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0
(654) DESCRIBE `ports` 0.0031630992889404
(655) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0002591609954834
(656) DESCRIBE `ports` 0.0016319751739502
(657) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00036907196044922
(658) DESCRIBE `ports` 0.0015408992767334
(659) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.012737035751343
(660) DESCRIBE `ports` 0.0069239139556885
(661) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00041007995605469
(662) DESCRIBE `ports` 0.0025951862335205
(663) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00030398368835449
(664) DESCRIBE `ports` 0.0019149780273438
(665) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00034117698669434
(666) DESCRIBE `avid_specials` 0.0016200542449951
(667) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71829 and class = 'Cruise') OR (item_id = 462 AND class = 'Ship') OR (item_id = 19 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.010390996932983
(668) DESCRIBE `cruiselines` 0.0025420188903809
(669) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00048184394836426
(670) DESCRIBE `orchid_image` 0.0020718574523926
(671) DESCRIBE `cruiselines` 0.0034670829772949
(672) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00040411949157715
(673) DESCRIBE `cruises` 0.0075361728668213
(674) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62833') 0.00060105323791504
(675) DESCRIBE `ships` 0.0053679943084717
(676) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1471))) 0.0049259662628174
(677) DESCRIBE `ships` 0.0085949897766113
(678) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1471') 0.0015051364898682
(679) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00043606758117676
(680) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0
(681) DESCRIBE `itineraries` 0.0036430358886719
(682) DESCRIBE `ports` 0.0042901039123535
(683) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 879))) 0.0022048950195312
(684) DESCRIBE `ports` 0.0025830268859863
(685) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 879))) 0.0017509460449219
(686) DESCRIBE `ports` 0.0015270709991455
(687) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '879') 0.0018658638000488
(688) DESCRIBE `sailingdates` 0.0030860900878906
(689) DESCRIBE `ports` 0.010380983352661
(690) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 879))) 0.006411075592041
(691) DESCRIBE `ports` 0.0026278495788574
(692) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '879') 0.00054788589477539
(693) DESCRIBE `ports` 0.0015718936920166
(694) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 99))) 0.00040006637573242
(695) DESCRIBE `ports` 0.0015671253204346
(696) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '99') 0.00037598609924316
(697) DESCRIBE `ports` 0.007918119430542
(698) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2597))) 0.00042414665222168
(699) DESCRIBE `ports` 0.0022170543670654
(700) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2597') 0.00055599212646484
(701) DESCRIBE `ports` 0.006371021270752
(702) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2525))) 0.00055718421936035
(703) DESCRIBE `ports` 0.0022158622741699
(704) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2525') 0.00030207633972168
(705) DESCRIBE `ports` 0.002410888671875
(706) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1650))) 0.00041294097900391
(707) DESCRIBE `ports` 0.0024118423461914
(708) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1650') 0.00096511840820312
(709) DESCRIBE `ports` 0.0055129528045654
(710) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2528))) 0.00010204315185547
(711) DESCRIBE `ports` 0.0013659000396729
(712) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2528') 0.00044584274291992
(713) DESCRIBE `ports` 0.0021770000457764
(714) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4454))) 0.00040316581726074
(715) DESCRIBE `ports` 0.0091030597686768
(716) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4454') 0.00044894218444824
(717) DESCRIBE `ports` 0.0021109580993652
(718) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1652))) 0.00046396255493164
(719) DESCRIBE `ports` 0.0019059181213379
(720) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1652') 0.00047111511230469
(721) DESCRIBE `ports` 0.0014078617095947
(722) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 99))) 0.0078270435333252
(723) DESCRIBE `ports` 0.0018119812011719
(724) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '99') 0.00010085105895996
(725) DESCRIBE `ports` 0.0014710426330566
(726) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 879))) 0.00043106079101562
(727) DESCRIBE `ports` 0.0017499923706055
(728) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '879') 0.00050187110900879
(729) DESCRIBE `ports` 0.001643180847168
(730) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 879))) 0.00041007995605469
(731) DESCRIBE `ports` 0.0088739395141602
(732) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '879') 0.00031399726867676
(733) DESCRIBE `avid_specials` 0.0016038417816162
(734) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62833 and class = 'Cruise') OR (item_id = 1471 AND class = 'Ship') OR (item_id = 110 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.0018739700317383
(735) DESCRIBE `cruiselines` 0.0026450157165527
(736) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 110))) 0.002190113067627
(737) DESCRIBE `orchid_image` 0.0033140182495117
(738) DESCRIBE `cruiselines` 0.004209041595459
(739) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '110') 0.0011301040649414
(740) DESCRIBE `cruiselines` 0.0019898414611816
(741) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '183', '26', '19', '77', '23', '7', '20', '12', '8', '18', '171', '221', '144', '31', '101', '103', '232', '131', '96', '50', '29', '239', '258', '15', '191', '251', '206', '33', '91', '114', '170', '37', '14', '16', '24', '268', '262', '36', '256', '28', '120', '195', '47', '240', '208', '146', '110', '156', '174', '187', '220', '141', '153', '118', '229', '108', '49', '151', '128', '35', '30', '216', '168', '196', '181', '236', '88', '4', '200', '212', '38', '264', '73', '225', '238', '159', '90', '211', '39', '147', '115', '140', '184', '249', '59', '48', '257', '275', '219', '132', '213', '276', '230', '113', '182', '261', '64', '188', '237', '57', '180', '95', '248', '235', '209', '62', '231', '52', '116', '266', '105', '82', '177', '119', '134', '244', '210', '224', '245')) ORDER BY FIND_IN_SET(id, '218,183,26,19,77,23,7,20,12,8,18,171,221,144,31,101,103,232,131,96,50,29,239,258,15,191,251,206,33,91,114,170,37,14,16,24,268,262,36,256,28,120,195,47,240,208,146,110,156,174,187,220,141,153,118,229,108,49,151,128,35,30,216,168,196,181,236,88,4,200,212,38,264,73,225,238,159,90,211,39,147,115,140,184,249,59,48,257,275,219,132,213,276,230,113,182,261,64,188,237,57,180,95,248,235,209,62,231,52,116,266,105,82,177,119,134,244,210,224,245') 0.013428926467896
(742) DESCRIBE `ships` 0.0031390190124512
(743) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1127', '1554', '1555', '1247', '1324', '517', '1032', '974', '797', '21', '22', '461', '1292', '393', '207', '28', '977', '1205', '330', '258', '480', '1291', '1599', '737', '1199', '1010', '1417', '11', '10', '780', '349', '439', '9', '333', '404', '739', '1135', '986', '1359', '14', '454', '1272', '265', '1677', '855', '1237', '24', '25', '731', '1067', '859', '817', '1594', '770', '1607', '113', '1481', '1588', '3', '31', '37', '38', '837', '34', '378', '985', '1239', '1372', '542', '407', '390', '39', '1320', '30', '43', '748', '1579', '36', '970', '1012', '573', '726', '1323', '1402', '1744', '66', '854', '1376', '1768', '526', '582', '1245', '27', '1422', '1424', '327', '332', '882', '1413', '590', '1420', '1552', '1411', '1419', '1423', '1284', '1418', '1421', '1586', '35', '791', '792', '1410', '441', '674', '1773', '585', '1587', '1183', '1415', '455', '1184', '114', '580', '857', '1501', '858', '1176', '711', '1193', '1382', '434', '462', '1236', '1405', '1574', '162', '722', '1215', '1682', '325', '160', '1742', '452', '639', '285', '1021', '1141', '1454', '78', '119', '658', '683', '852', '81', '1008', '1412', '69', '1168', '338', '1095', '1408', '1678', '1760', '1373', '1572', '163', '678', '1172', '869', '1082', '776', '850', '1319', '211', '335', '1630', '111', '253', '610', '1782', '45', '314', '403', '503', '1302', '1383', '1569', '1628', '124', '348', '451', '1259', '1384', '70', '340', '405', '4', '116', '766', '968', '1711', '635', '966', '626', '651', '851', '944', '1159', '148', '286', '386', '553', '63', '324', '385', '508', '749', '768', '1303', '1330', '123', '262', '389', '559', '1068', '1260', '1455', '198', '485', '616', '1266', '1301', '375', '406', '467', '1088', '1108', '1325', '1632', '1672', '84', '291', '784', '1212', '1562', '1575', '287', '1195', '108', '483', '716', '1208', '1781', '98', '421', '1639', '290', '401', '1064', '1571', '394', '1398', '1492', '1614', '1645', '1721', '652', '657', '1308', '883', '954', '147', '150', '152', '341', '1321', '1389', '1724', '149', '151', '223', '704', '874', '1139', '1486', '1611', '1722', '775', '885', '1269', '1539', '1601', '1717', '1268', '1615', '547', '958', '1289', '1557', '1738', '105', '1143', '1326', '1327', '1437', '545', '717', '1771', '351', '516', '1040', '1075', '1704', '75', '790', '818', '1270', '1471', '1679', '868', '1063', '1151', '1213', '1282', '1673', '1684', '796', '823', '1367', '479', '574', '665', '1013', '1214', '1262', '1318', '1676', '1740', '82', '93', '205', '701', '1561', '1766', '520', '1043', '1218', '1460', '1526', '1540', '1566', '644', '673', '715', '988', '1144', '1157', '743', '751', '1137', '1223', '1226', '1344', '212', '266', '669', '884', '1027', '1029', '1163', '1229', '1343', '1409', '1602', '1716', '201', '795', '1160', '1217', '1283', '1452', '1453', '1604', '707', '769', '1025', '1090', '1414', '1612', '1613', '1055', '1073', '1136', '1216', '1426', '1448', '1713', '1715', '417', '448', '601', '695', '905', '996', '1019', '1026', '1110', '1145', '1233', '1243', '1253', '1458', '1496', '1714', '643', '1188', '1211', '1743', '1772', '1783', '74', '888', '973', '997', '1034', '1149', '1351', '1358', '1366', '1404', '1516', '1609', '811', '1049', '1150', '1196', '1222', '1231', '1241', '1345', '1360', '1361', '1362', '1368', '1395', '1449', '1459', '1522', '1619', '1647', '1730', '618', '666', '920', '921', '927', '931', '1047', '1152', '1230', '1354', '1474', '1627', '1663', '1729', '261', '423', '733', '914', '923', '993', '1004', '1322', '1348', '1517', '1518', '1567', '1580', '663', '740', '836', '915', '916', '926', '930', '1037', '1042', '1072', '1138', '1521', '1674', '1708', '1751', '453', '494', '499', '703', '709')) ORDER BY FIND_IN_SET(id, '1761,1127,1554,1555,1247,1324,517,1032,974,797,21,22,461,1292,393,207,28,977,1205,330,258,480,1291,1599,737,1199,1010,1417,11,10,780,349,439,9,333,404,739,1135,986,1359,14,454,1272,265,1677,855,1237,24,25,731,1067,859,817,1594,770,1607,113,1481,1588,3,31,37,38,837,34,378,985,1239,1372,542,407,390,39,1320,30,43,748,1579,36,970,1012,573,726,1323,1402,1744,66,854,1376,1768,526,582,1245,27,1422,1424,327,332,882,1413,590,1420,1552,1411,1419,1423,1284,1418,1421,1586,35,791,792,1410,441,674,1773,585,1587,1183,1415,455,1184,114,580,857,1501,858,1176,711,1193,1382,434,462,1236,1405,1574,162,722,1215,1682,325,160,1742,452,639,285,1021,1141,1454,78,119,658,683,852,81,1008,1412,69,1168,338,1095,1408,1678,1760,1373,1572,163,678,1172,869,1082,776,850,1319,211,335,1630,111,253,610,1782,45,314,403,503,1302,1383,1569,1628,124,348,451,1259,1384,70,340,405,4,116,766,968,1711,635,966,626,651,851,944,1159,148,286,386,553,63,324,385,508,749,768,1303,1330,123,262,389,559,1068,1260,1455,198,485,616,1266,1301,375,406,467,1088,1108,1325,1632,1672,84,291,784,1212,1562,1575,287,1195,108,483,716,1208,1781,98,421,1639,290,401,1064,1571,394,1398,1492,1614,1645,1721,652,657,1308,883,954,147,150,152,341,1321,1389,1724,149,151,223,704,874,1139,1486,1611,1722,775,885,1269,1539,1601,1717,1268,1615,547,958,1289,1557,1738,105,1143,1326,1327,1437,545,717,1771,351,516,1040,1075,1704,75,790,818,1270,1471,1679,868,1063,1151,1213,1282,1673,1684,796,823,1367,479,574,665,1013,1214,1262,1318,1676,1740,82,93,205,701,1561,1766,520,1043,1218,1460,1526,1540,1566,644,673,715,988,1144,1157,743,751,1137,1223,1226,1344,212,266,669,884,1027,1029,1163,1229,1343,1409,1602,1716,201,795,1160,1217,1283,1452,1453,1604,707,769,1025,1090,1414,1612,1613,1055,1073,1136,1216,1426,1448,1713,1715,417,448,601,695,905,996,1019,1026,1110,1145,1233,1243,1253,1458,1496,1714,643,1188,1211,1743,1772,1783,74,888,973,997,1034,1149,1351,1358,1366,1404,1516,1609,811,1049,1150,1196,1222,1231,1241,1345,1360,1361,1362,1368,1395,1449,1459,1522,1619,1647,1730,618,666,920,921,927,931,1047,1152,1230,1354,1474,1627,1663,1729,261,423,733,914,923,993,1004,1322,1348,1517,1518,1567,1580,663,740,836,915,916,926,930,1037,1042,1072,1138,1521,1674,1708,1751,453,494,499,703,709') 0.10759210586548
(744) DESCRIBE `cruisetypes` 0.0017430782318115
(745) DESCRIBE `destinations` 0.0024869441986084
(746) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '35', '22', '54', '25', '37', '9', '43', '2', '8', '44', '55', '53', '39', '26', '38', '28', '49', '7', '40', '11', '21', '48', '56', '30', '46', '29', '45', '34', '10', '52', '32')) ORDER BY FIND_IN_SET(id, '50,12,35,22,54,25,37,9,43,2,8,44,55,53,39,26,38,28,49,7,40,11,21,48,56,30,46,29,45,34,10,52,32') 0.0025341510772705