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

Total elapsed time: 0.82971501350403

# Query Time
(1) connect 0.00053501129150391
(2) DESCRIBE `cruises` 0.0036239624023438
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (80960, 62751, 63984, 13509, 38149, 40596, 45258, 48658, 51600, 57672)) ORDER BY FIND_IN_SET(id, '80960,62751,63984,13509,38149,40596,45258,48658,51600,57672') 0.0027379989624023
(4) DESCRIBE `cruises` 0.0038690567016602
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80960') 0.0005648136138916
(6) DESCRIBE `ships` 0.003957986831665
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 403))) 0.00066804885864258
(8) DESCRIBE `ships` 0.0040621757507324
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '403') 0.00056910514831543
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032591819763184
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033211708068848
(12) DESCRIBE `itineraries` 0.0018539428710938
(13) DESCRIBE `ports` 0.0021560192108154
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00057291984558105
(15) DESCRIBE `ports` 0.0019688606262207
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00048518180847168
(17) DESCRIBE `ports` 0.0018949508666992
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00052595138549805
(19) DESCRIBE `sailingdates` 0.0017910003662109
(20) DESCRIBE `ports` 0.0020210742950439
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00050115585327148
(22) DESCRIBE `ports` 0.0019059181213379
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00048208236694336
(24) DESCRIBE `ports` 0.001878023147583
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 465))) 0.00054097175598145
(26) DESCRIBE `ports` 0.0018661022186279
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '465') 0.00042009353637695
(28) DESCRIBE `ports` 0.0017471313476562
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00047516822814941
(30) DESCRIBE `ports` 0.0020220279693604
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.0004730224609375
(32) DESCRIBE `ports` 0.0020759105682373
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 345))) 0.00049185752868652
(34) DESCRIBE `ports` 0.0019328594207764
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '345') 0.00049400329589844
(36) DESCRIBE `ports` 0.0020029544830322
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 346))) 0.00052309036254883
(38) DESCRIBE `ports` 0.0020818710327148
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '346') 0.00045084953308105
(40) DESCRIBE `ports` 0.0018918514251709
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00056195259094238
(42) DESCRIBE `ports` 0.0017027854919434
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00041007995605469
(44) DESCRIBE `avid_specials` 0.0015678405761719
(45) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80960 and class = 'Cruise') OR (item_id = 403 AND class = 'Ship') OR (item_id = 26 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.0014710426330566
(46) DESCRIBE `cruiselines` 0.0025119781494141
(47) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00051999092102051
(48) DESCRIBE `orchid_image` 0.0021300315856934
(49) DESCRIBE `cruiselines` 0.0029001235961914
(50) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00048708915710449
(51) DESCRIBE `cruises` 0.0037269592285156
(52) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62751') 0.00048685073852539
(53) DESCRIBE `ships` 0.003216028213501
(54) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1109))) 0.00056695938110352
(55) DESCRIBE `ships` 0.0039880275726318
(56) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1109') 0.00058794021606445
(57) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00042986869812012
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034308433532715
(59) DESCRIBE `itineraries` 0.0019240379333496
(60) DESCRIBE `ports` 0.0016698837280273
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 164))) 0.00047016143798828
(62) DESCRIBE `ports` 0.0017490386962891
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 164))) 0.00043988227844238
(64) DESCRIBE `ports` 0.0017812252044678
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '164') 0.00039815902709961
(66) DESCRIBE `sailingdates` 0.0016369819641113
(67) DESCRIBE `ports` 0.002345085144043
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 164))) 0.00053095817565918
(69) DESCRIBE `ports` 0.002065896987915
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '164') 0.00039291381835938
(71) DESCRIBE `ports` 0.0015530586242676
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 164))) 0.00043487548828125
(73) DESCRIBE `ports` 0.0018110275268555
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '164') 0.00039505958557129
(75) DESCRIBE `ports` 0.001859188079834
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2139))) 0.00048208236694336
(77) DESCRIBE `ports` 0.0019919872283936
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2139') 0.00044107437133789
(79) DESCRIBE `ports` 0.0019619464874268
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4930))) 0.00045299530029297
(81) DESCRIBE `ports` 0.0020139217376709
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4930') 0.00044083595275879
(83) DESCRIBE `ports` 0.0020709037780762
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 624))) 0.00052905082702637
(85) DESCRIBE `ports` 0.0019791126251221
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '624') 0.00044989585876465
(87) DESCRIBE `ports` 0.001845121383667
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3040))) 0.0004429817199707
(89) DESCRIBE `ports` 0.0016860961914062
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3040') 0.00040102005004883
(91) DESCRIBE `ports` 0.0017621517181396
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2054))) 0.00047397613525391
(93) DESCRIBE `ports` 0.0017969608306885
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2054') 0.00034117698669434
(95) DESCRIBE `ports` 0.0017900466918945
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 619))) 0.00050497055053711
(97) DESCRIBE `ports` 0.0019669532775879
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '619') 5.2928924560547E-5
(99) DESCRIBE `ports` 0.0019419193267822
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 356))) 0.00041007995605469
(101) DESCRIBE `ports` 0.0016410350799561
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '356') 0
(103) DESCRIBE `avid_specials` 0.0017139911651611
(104) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62751 and class = 'Cruise') OR (item_id = 1109 AND class = 'Ship') OR (item_id = 208 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.0015490055084229
(105) DESCRIBE `cruiselines` 0.0028820037841797
(106) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 208))) 0.00054287910461426
(107) DESCRIBE `orchid_image` 0.0021347999572754
(108) DESCRIBE `cruiselines` 0.003101110458374
(109) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '208') 0.00032997131347656
(110) DESCRIBE `cruises` 0.0032711029052734
(111) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63984') 0.00048184394836426
(112) DESCRIBE `ships` 0.003986120223999
(113) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1236))) 0.00055909156799316
(114) DESCRIBE `ships` 0.0032811164855957
(115) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1236') 6.7949295043945E-5
(116) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034689903259277
(117) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034499168395996
(118) DESCRIBE `itineraries` 0.0021498203277588
(119) DESCRIBE `ports` 0.0019171237945557
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.00043702125549316
(121) DESCRIBE `ports` 0.0024979114532471
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.00034880638122559
(123) DESCRIBE `ports` 0.0017120838165283
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2521') 0
(125) DESCRIBE `sailingdates` 0.0014939308166504
(126) DESCRIBE `ports` 0.0017850399017334
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0.00037908554077148
(128) DESCRIBE `ports` 0.0013899803161621
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2521') 0.0003809928894043
(130) DESCRIBE `ports` 0.0013871192932129
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00037288665771484
(132) DESCRIBE `ports` 0.0016500949859619
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00043416023254395
(134) DESCRIBE `ports` 0.001554012298584
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1757))) 0.00043106079101562
(136) DESCRIBE `ports` 0.0016310214996338
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1757') 0.00052094459533691
(138) DESCRIBE `ports` 0.0018820762634277
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00052714347839355
(140) DESCRIBE `ports` 0.0019700527191162
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0
(142) DESCRIBE `ports` 0.0019009113311768
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2521))) 0
(144) DESCRIBE `ports` 0.0019280910491943
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2521') 0.00045299530029297
(146) DESCRIBE `avid_specials` 0.0015687942504883
(147) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63984 and class = 'Cruise') OR (item_id = 1236 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 9 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.0016598701477051
(148) DESCRIBE `cruiselines` 0.0024750232696533
(149) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00050997734069824
(150) DESCRIBE `orchid_image` 0.0019609928131104
(151) DESCRIBE `cruiselines` 0.0023598670959473
(152) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00042510032653809
(153) DESCRIBE `cruises` 0.0038609504699707
(154) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '13509') 0.00037908554077148
(155) DESCRIBE `ships` 0.0026819705963135
(156) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 14))) 0.0003821849822998
(157) DESCRIBE `ships` 0.0028941631317139
(158) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '14') 0.00032687187194824
(159) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030684471130371
(160) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029492378234863
(161) DESCRIBE `itineraries` 0.0014479160308838
(162) DESCRIBE `ports` 0.0011370182037354
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00046992301940918
(164) DESCRIBE `ports` 0.0016560554504395
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00032591819763184
(166) DESCRIBE `ports` 0.0015769004821777
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0
(168) DESCRIBE `sailingdates` 0.0012810230255127
(169) DESCRIBE `ports` 0.0016570091247559
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00037980079650879
(171) DESCRIBE `ports` 0.0014669895172119
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00033020973205566
(173) DESCRIBE `ports` 0.0014619827270508
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0
(175) DESCRIBE `ports` 0.0014948844909668
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00029802322387695
(177) DESCRIBE `ports` 0.0013010501861572
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1160))) 0.00035476684570312
(179) DESCRIBE `ports` 0.0016729831695557
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1160') 0.00042200088500977
(181) DESCRIBE `ports` 0.0017030239105225
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00047492980957031
(183) DESCRIBE `ports` 0.0016880035400391
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00036001205444336
(185) DESCRIBE `ports` 0.002485990524292
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00042009353637695
(187) DESCRIBE `ports` 0.0018908977508545
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00037384033203125
(189) DESCRIBE `ports` 0.0017430782318115
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1160))) 0.0012960433959961
(191) DESCRIBE `ports` 0.0012378692626953
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1160') 0.00014686584472656
(193) DESCRIBE `ports` 0.0014400482177734
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00042390823364258
(195) DESCRIBE `ports` 0.0018599033355713
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.0004119873046875
(197) DESCRIBE `ports` 0.0018398761749268
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00043392181396484
(199) DESCRIBE `ports` 0.0017659664154053
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00041294097900391
(201) DESCRIBE `ports` 0.0018010139465332
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00042390823364258
(203) DESCRIBE `ports` 0.001802921295166
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00044608116149902
(205) DESCRIBE `ports` 0.0015349388122559
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1161))) 0.00058197975158691
(207) DESCRIBE `ports` 0.0025720596313477
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1161') 0.0004279613494873
(209) DESCRIBE `ports` 0.0019559860229492
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00041508674621582
(211) DESCRIBE `ports` 0.0016598701477051
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00039792060852051
(213) DESCRIBE `ports` 0.0018610954284668
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00040006637573242
(215) DESCRIBE `ports` 0.0019118785858154
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00036001205444336
(217) DESCRIBE `ports` 0.0016841888427734
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3052))) 0.00056290626525879
(219) DESCRIBE `ports` 0.0018699169158936
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3052') 0.00044107437133789
(221) DESCRIBE `ports` 0.0015709400177002
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00037598609924316
(223) DESCRIBE `ports` 0.0018129348754883
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00044584274291992
(225) DESCRIBE `ports` 0.0020010471343994
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00046491622924805
(227) DESCRIBE `ports` 0.0019149780273438
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00046801567077637
(229) DESCRIBE `ports` 0.0019469261169434
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00051689147949219
(231) DESCRIBE `ports` 0.0019979476928711
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00047111511230469
(233) DESCRIBE `avid_specials` 0.0017151832580566
(234) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 13509 and class = 'Cruise') OR (item_id = 14 AND class = 'Ship') OR (item_id = 35 AND class = 'CruiseLine') OR (item_id = 46 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.0018930435180664
(235) DESCRIBE `cruiselines` 0.003180980682373
(236) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 35))) 0.00046300888061523
(237) DESCRIBE `orchid_image` 0.0021991729736328
(238) DESCRIBE `cruiselines` 0.0025389194488525
(239) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '35') 0.00044703483581543
(240) DESCRIBE `cruises` 0.0036110877990723
(241) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '38149') 0.00051188468933105
(242) DESCRIBE `ships` 0.0036101341247559
(243) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 207))) 0.00069808959960938
(244) DESCRIBE `ships` 0.0037448406219482
(245) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '207') 0.0005180835723877
(246) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00031113624572754
(247) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00033020973205566
(248) DESCRIBE `itineraries` 0.0016531944274902
(249) DESCRIBE `ports` 0.001884937286377
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00046896934509277
(251) DESCRIBE `ports` 0.0018188953399658
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00042295455932617
(253) DESCRIBE `ports` 0.0017681121826172
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.0003969669342041
(255) DESCRIBE `sailingdates` 0.0014879703521729
(256) DESCRIBE `ports` 0.002140998840332
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00045514106750488
(258) DESCRIBE `ports` 0.0017271041870117
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00040006637573242
(260) DESCRIBE `ports` 0.00177001953125
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 261))) 0.00082516670227051
(262) DESCRIBE `ports` 0.0021100044250488
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '261') 0.0005638599395752
(264) DESCRIBE `ports` 0.0018801689147949
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 262))) 0.0005040168762207
(266) DESCRIBE `ports` 0.0018851757049561
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '262') 0.00043082237243652
(268) DESCRIBE `ports` 0.0018370151519775
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6058))) 0.0004570484161377
(270) DESCRIBE `ports` 0.0012168884277344
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6058') 0.00044584274291992
(272) DESCRIBE `ports` 0.0019581317901611
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 260))) 0.00047111511230469
(274) DESCRIBE `ports` 0.0019478797912598
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '260') 0.00041389465332031
(276) DESCRIBE `ports` 0.0028200149536133
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00048208236694336
(278) DESCRIBE `ports` 0.0021529197692871
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00039005279541016
(280) DESCRIBE `ports` 0.0016059875488281
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 263))) 0
(282) DESCRIBE `ports` 0.0014100074768066
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '263') 0.00034499168395996
(284) DESCRIBE `ports` 0.0018110275268555
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 265))) 0.00051498413085938
(286) DESCRIBE `ports` 0.001751184463501
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '265') 0.00040793418884277
(288) DESCRIBE `ports` 0.0017280578613281
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 266))) 0.00041508674621582
(290) DESCRIBE `ports` 0.0016419887542725
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '266') 0.00037598609924316
(292) DESCRIBE `ports` 0.0016040802001953
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00040912628173828
(294) DESCRIBE `ports` 0.0029520988464355
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00035405158996582
(296) DESCRIBE `avid_specials` 0.0014979839324951
(297) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 38149 and class = 'Cruise') OR (item_id = 207 AND class = 'Ship') OR (item_id = 36 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015120506286621
(298) DESCRIBE `cruiselines` 0.0023038387298584
(299) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 36))) 0.00037789344787598
(300) DESCRIBE `orchid_image` 0.0016701221466064
(301) DESCRIBE `cruiselines` 0.0024268627166748
(302) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '36') 0.00037193298339844
(303) DESCRIBE `cruises` 0.0033390522003174
(304) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '40596') 0.00060009956359863
(305) DESCRIBE `ships` 0.003756046295166
(306) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1032))) 0.0006248950958252
(307) DESCRIBE `ships` 0.0033040046691895
(308) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1032') 0.00046396255493164
(309) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034093856811523
(310) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025200843811035
(311) DESCRIBE `itineraries` 0.0016000270843506
(312) DESCRIBE `ports` 0.0014081001281738
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00041508674621582
(314) DESCRIBE `ports` 0.0016281604766846
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00041699409484863
(316) DESCRIBE `ports` 0.0018651485443115
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00031900405883789
(318) DESCRIBE `sailingdates` 0.0011391639709473
(319) DESCRIBE `ports` 0.0018599033355713
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00042200088500977
(321) DESCRIBE `ports` 0.0015931129455566
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00040388107299805
(323) DESCRIBE `ports` 0.0018429756164551
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00052690505981445
(325) DESCRIBE `ports` 0.0019149780273438
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00045299530029297
(327) DESCRIBE `ports` 0.00189208984375
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00049495697021484
(329) DESCRIBE `ports` 0.0020740032196045
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00058817863464355
(331) DESCRIBE `ports` 0.0018651485443115
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00061798095703125
(333) DESCRIBE `ports` 0.0018248558044434
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00049901008605957
(335) DESCRIBE `ports` 0.001633882522583
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00043988227844238
(337) DESCRIBE `ports` 0.0017399787902832
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00039911270141602
(339) DESCRIBE `ports` 0.0015530586242676
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00043010711669922
(341) DESCRIBE `ports` 0.0017058849334717
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00035190582275391
(343) DESCRIBE `ports` 0.0016710758209229
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.0013279914855957
(345) DESCRIBE `ports` 0.0011720657348633
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00037407875061035
(347) DESCRIBE `ports` 0.00090408325195312
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.0003972053527832
(349) DESCRIBE `ports` 0.0018532276153564
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00039100646972656
(351) DESCRIBE `avid_specials` 0.0014879703521729
(352) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 40596 and class = 'Cruise') OR (item_id = 1032 AND class = 'Ship') OR (item_id = 191 AND class = 'CruiseLine') OR (item_id = 55 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018320083618164
(353) DESCRIBE `cruiselines` 0.0025451183319092
(354) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.0004420280456543
(355) DESCRIBE `orchid_image` 0.0019009113311768
(356) DESCRIBE `cruiselines` 0.0026121139526367
(357) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.0003819465637207
(358) DESCRIBE `cruises` 0.0025570392608643
(359) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45258') 0.00017690658569336
(360) DESCRIBE `ships` 0.0034480094909668
(361) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00048112869262695
(362) DESCRIBE `ships` 0.0033900737762451
(363) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00041794776916504
(364) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00031805038452148
(365) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00032210350036621
(366) DESCRIBE `itineraries` 0.0019230842590332
(367) DESCRIBE `ports` 0.0016851425170898
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0003509521484375
(369) DESCRIBE `ports` 0.0015909671783447
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00040197372436523
(371) DESCRIBE `ports` 0.0015890598297119
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00035405158996582
(373) DESCRIBE `sailingdates` 0.0014560222625732
(374) DESCRIBE `ports` 0.0021820068359375
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0004570484161377
(376) DESCRIBE `ports` 0.0016989707946777
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00039982795715332
(378) DESCRIBE `ports` 0.0017728805541992
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 284))) 0.00038814544677734
(380) DESCRIBE `ports` 0.001662015914917
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '284') 0.00044798851013184
(382) DESCRIBE `ports` 0.0017509460449219
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00046420097351074
(384) DESCRIBE `ports` 0.0016219615936279
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00035500526428223
(386) DESCRIBE `ports` 0.0022871494293213
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00038504600524902
(388) DESCRIBE `ports` 0.001690149307251
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00031709671020508
(390) DESCRIBE `ports` 0.0015921592712402
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.0003819465637207
(392) DESCRIBE `ports` 0.0017848014831543
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.0003659725189209
(394) DESCRIBE `ports` 0.0014941692352295
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00035691261291504
(396) DESCRIBE `ports` 0.0014421939849854
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00035405158996582
(398) DESCRIBE `ports` 0.0013480186462402
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00031614303588867
(400) DESCRIBE `ports` 0.0013160705566406
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00028395652770996
(402) DESCRIBE `ports` 0.001338005065918
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.0003211498260498
(404) DESCRIBE `ports` 0.0010080337524414
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00033307075500488
(406) DESCRIBE `ports` 0.0017070770263672
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00038599967956543
(408) DESCRIBE `ports` 0.00086808204650879
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0
(410) DESCRIBE `avid_specials` 0.00152587890625
(411) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 45258 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 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.001863956451416
(412) DESCRIBE `cruiselines` 0.0015060901641846
(413) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00033903121948242
(414) DESCRIBE `orchid_image` 0.0015630722045898
(415) DESCRIBE `cruiselines` 0.002234935760498
(416) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00032520294189453
(417) DESCRIBE `cruises` 0.0026178359985352
(418) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '48658') 0.00036191940307617
(419) DESCRIBE `ships` 0.0029089450836182
(420) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1212))) 0.00065398216247559
(421) DESCRIBE `ships` 0.0036110877990723
(422) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1212') 0.0005500316619873
(423) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033402442932129
(424) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031614303588867
(425) DESCRIBE `itineraries` 0.001802921295166
(426) DESCRIBE `ports` 0.0018839836120605
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3610))) 0.00042605400085449
(428) DESCRIBE `ports` 0.0021259784698486
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3610))) 0.00039792060852051
(430) DESCRIBE `ports` 0.0026159286499023
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3610') 0.00046586990356445
(432) DESCRIBE `sailingdates` 0.0016629695892334
(433) DESCRIBE `ports` 0.0020771026611328
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3610))) 0.0012679100036621
(435) DESCRIBE `ports` 0.0018880367279053
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3610') 0.00034189224243164
(437) DESCRIBE `ports` 0.0015621185302734
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3613))) 0.00035309791564941
(439) DESCRIBE `ports` 0.0017268657684326
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3613') 0.00035691261291504
(441) DESCRIBE `ports` 0.0017461776733398
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3615))) 0.00037813186645508
(443) DESCRIBE `ports` 0.0017600059509277
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3615') 0.00034904479980469
(445) DESCRIBE `ports` 0.0017259120941162
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3777))) 0.00038790702819824
(447) DESCRIBE `ports` 0.0018048286437988
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3777') 0.00034785270690918
(449) DESCRIBE `ports` 0.0017790794372559
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5658))) 0.00036883354187012
(451) DESCRIBE `ports` 0.0017499923706055
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5658') 0.0003509521484375
(453) DESCRIBE `ports` 0.0017249584197998
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5255))) 0.00041604042053223
(455) DESCRIBE `ports` 0.0018320083618164
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5255') 0.00039577484130859
(457) DESCRIBE `ports` 0.001741886138916
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3619))) 0.00040388107299805
(459) DESCRIBE `ports` 0.0018389225006104
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3619') 0.00036311149597168
(461) DESCRIBE `ports` 0.0018389225006104
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3619))) 0.00048518180847168
(463) DESCRIBE `ports` 0.0018119812011719
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3619') 0.00041103363037109
(465) DESCRIBE `ports` 0.0018019676208496
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3610))) 0.00044488906860352
(467) DESCRIBE `ports` 0.0018219947814941
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3610') 0.0003960132598877
(469) DESCRIBE `avid_specials` 0.0016610622406006
(470) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 48658 and class = 'Cruise') OR (item_id = 1212 AND class = 'Ship') OR (item_id = 236 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.0017480850219727
(471) DESCRIBE `cruiselines` 0.0021100044250488
(472) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 236))) 0.00039792060852051
(473) DESCRIBE `orchid_image` 0.0015740394592285
(474) DESCRIBE `cruiselines` 0.0024821758270264
(475) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '236') 0.0005028247833252
(476) DESCRIBE `cruises` 0.003821849822998
(477) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '51600') 0.00043797492980957
(478) DESCRIBE `ships` 0.0028998851776123
(479) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 351))) 0.0003960132598877
(480) DESCRIBE `ships` 0.0028748512268066
(481) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '351') 0.00040912628173828
(482) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030612945556641
(483) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00041103363037109
(484) DESCRIBE `itineraries` 0.0020859241485596
(485) DESCRIBE `ports` 0.0020520687103271
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00054407119750977
(487) DESCRIBE `ports` 0.0019750595092773
(488) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00048112869262695
(489) DESCRIBE `ports` 0.0018270015716553
(490) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00041604042053223
(491) DESCRIBE `sailingdates` 0.0017030239105225
(492) DESCRIBE `ports` 0.002173900604248
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00050497055053711
(494) DESCRIBE `ports` 0.0019469261169434
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00039100646972656
(496) DESCRIBE `ports` 0.0018079280853271
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00041985511779785
(498) DESCRIBE `ports` 0.0018470287322998
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00041389465332031
(500) DESCRIBE `ports` 0.0019059181213379
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00047206878662109
(502) DESCRIBE `ports` 0.0019059181213379
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00040602684020996
(504) DESCRIBE `ports` 0.0018727779388428
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.0004119873046875
(506) DESCRIBE `ports` 0.0018470287322998
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00040197372436523
(508) DESCRIBE `ports` 0.0017640590667725
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3079))) 0.00050497055053711
(510) DESCRIBE `ports` 0.0017590522766113
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3079') 0.0002739429473877
(512) DESCRIBE `ports` 0.0014300346374512
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.00033307075500488
(514) DESCRIBE `ports` 0.0013561248779297
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0
(516) DESCRIBE `ports` 0.0014669895172119
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00011110305786133
(518) DESCRIBE `ports` 0.0012760162353516
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00030994415283203
(520) DESCRIBE `ports` 0.0014100074768066
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00036501884460449
(522) DESCRIBE `ports` 0.0018019676208496
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00038719177246094
(524) DESCRIBE `avid_specials` 0.0011320114135742
(525) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 51600 and class = 'Cruise') OR (item_id = 351 AND class = 'Ship') OR (item_id = 12 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.0017678737640381
(526) DESCRIBE `cruiselines` 0.0023951530456543
(527) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00043106079101562
(528) DESCRIBE `orchid_image` 0.0017979145050049
(529) DESCRIBE `cruiselines` 0.0024139881134033
(530) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.00043392181396484
(531) DESCRIBE `cruises` 0.0035400390625
(532) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57672') 0.00044703483581543
(533) DESCRIBE `ships` 0.0037357807159424
(534) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1205))) 0.00062108039855957
(535) DESCRIBE `ships` 0.003903865814209
(536) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1205') 0.00048708915710449
(537) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034403800964355
(538) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034308433532715
(539) DESCRIBE `itineraries` 0.0018990039825439
(540) DESCRIBE `ports` 0.0015640258789062
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00048017501831055
(542) DESCRIBE `ports` 0.0017321109771729
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00047898292541504
(544) DESCRIBE `ports` 0.0017631053924561
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00038599967956543
(546) DESCRIBE `sailingdates` 0.001399040222168
(547) DESCRIBE `ports` 0.0020780563354492
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00047707557678223
(549) DESCRIBE `ports` 0.001896858215332
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00039482116699219
(551) DESCRIBE `ports` 0.0016100406646729
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00040102005004883
(553) DESCRIBE `ports` 0.0016140937805176
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00030803680419922
(555) DESCRIBE `ports` 0.0017359256744385
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00037717819213867
(557) DESCRIBE `ports` 0.0014200210571289
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00034594535827637
(559) DESCRIBE `ports` 0.0015480518341064
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00029706954956055
(561) DESCRIBE `ports` 0.0020968914031982
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00044393539428711
(563) DESCRIBE `ports` 0.0019638538360596
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.0004880428314209
(565) DESCRIBE `ports` 0.0019700527191162
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00043916702270508
(567) DESCRIBE `ports` 0.0021629333496094
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.0005040168762207
(569) DESCRIBE `ports` 0.002100944519043
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00046896934509277
(571) DESCRIBE `ports` 0.0020279884338379
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00059413909912109
(573) DESCRIBE `ports` 0.0021049976348877
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00047588348388672
(575) DESCRIBE `ports` 0.0016889572143555
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.00051784515380859
(577) DESCRIBE `ports` 0.0021171569824219
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.0004420280456543
(579) DESCRIBE `ports` 0.0019218921661377
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5645))) 0.00065803527832031
(581) DESCRIBE `ports` 0.0020761489868164
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5645') 0.00056600570678711
(583) DESCRIBE `ports` 0.0020060539245605
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00047111511230469
(585) DESCRIBE `ports` 0.0019731521606445
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00052595138549805
(587) DESCRIBE `ports` 0.0059711933135986
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00062704086303711
(589) DESCRIBE `ports` 0.0020091533660889
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00038313865661621
(591) DESCRIBE `avid_specials` 0.0020120143890381
(592) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57672 and class = 'Cruise') OR (item_id = 1205 AND class = 'Ship') OR (item_id = 191 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.0018091201782227
(593) DESCRIBE `cruiselines` 0.0030200481414795
(594) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00058102607727051
(595) DESCRIBE `orchid_image` 0.0019948482513428
(596) DESCRIBE `cruiselines` 0.0026860237121582
(597) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0
(598) DESCRIBE `cruiselines` 0.0036370754241943
(599) 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.0089797973632812
(600) DESCRIBE `ships` 0.0039131641387939
(601) 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.056989908218384
(602) DESCRIBE `cruisetypes` 0.0012249946594238
(603) DESCRIBE `destinations` 0.0033400058746338
(604) 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.001741886138916