or, enquire about your chosen options

  1. What happens when you cruise back to back?
  2. Catch Up on Cruising: Latest News in bite size!
  3. Majestic Princess – Auckland 23 October 2018
  4. Catch Up on Cruising: Latest News in bite size!
  5. Cruise Ship Lingo? Look like a cruise expert before you get on the ship

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

Total elapsed time: 0.7134428024292

# Query Time
(1) connect 0.0010409355163574
(2) DESCRIBE `cruises` 0.002993106842041
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (52239, 69851, 6056, 57948, 59437, 72413, 73130, 34205, 52235, 58888)) ORDER BY FIND_IN_SET(id, '52239,69851,6056,57948,59437,72413,73130,34205,52235,58888') 0.00180983543396
(4) DESCRIBE `cruises` 0.0027658939361572
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52239') 0.00036311149597168
(6) DESCRIBE `ships` 0.0025150775909424
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1291))) 0.00040698051452637
(8) DESCRIBE `ships` 0.0025539398193359
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1291') 0.00030612945556641
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00030803680419922
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00027203559875488
(12) DESCRIBE `itineraries` 0.0014538764953613
(13) DESCRIBE `ports` 0.0019829273223877
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00046706199645996
(15) DESCRIBE `ports` 0.0021090507507324
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00030708312988281
(17) DESCRIBE `ports` 0.001317024230957
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00030612945556641
(19) DESCRIBE `sailingdates` 0.0011188983917236
(20) DESCRIBE `ports` 0.0016448497772217
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00038290023803711
(22) DESCRIBE `ports` 0.0013952255249023
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00044798851013184
(24) DESCRIBE `ports` 0.0017991065979004
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2666))) 0.00035905838012695
(26) DESCRIBE `ports` 0.0015079975128174
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2666') 0.00031185150146484
(28) DESCRIBE `ports` 0.0015010833740234
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5611))) 0.00032210350036621
(30) DESCRIBE `ports` 0.0012788772583008
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5611') 0.0003349781036377
(32) DESCRIBE `ports` 0.0012900829315186
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4209))) 0.00030899047851562
(34) DESCRIBE `ports` 0.0013530254364014
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4209') 0.00029206275939941
(36) DESCRIBE `ports` 0.0012550354003906
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2882))) 0.00031590461730957
(38) DESCRIBE `ports` 0.0012900829315186
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2882') 0.00028204917907715
(40) DESCRIBE `ports` 0.0012600421905518
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2883))) 0.00029301643371582
(42) DESCRIBE `ports` 0.0013270378112793
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2883') 0.00027990341186523
(44) DESCRIBE `ports` 0.0012660026550293
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4179))) 0.00029587745666504
(46) DESCRIBE `ports` 0.0013821125030518
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4179') 0.00031185150146484
(48) DESCRIBE `ports` 0.0015528202056885
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2523))) 0.00032901763916016
(50) DESCRIBE `ports` 0.0014469623565674
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2523') 0.00032401084899902
(52) DESCRIBE `ports` 0.0014750957489014
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2529))) 0.00031495094299316
(54) DESCRIBE `ports` 0.0013298988342285
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2529') 0.00036001205444336
(56) DESCRIBE `ports` 0.0013198852539062
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2597))) 0.00033712387084961
(58) DESCRIBE `ports` 0.0015621185302734
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2597') 0.00036787986755371
(60) DESCRIBE `ports` 0.0017979145050049
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2666))) 0.00034189224243164
(62) DESCRIBE `ports` 0.0014441013336182
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2666') 0.00029587745666504
(64) DESCRIBE `ports` 0.0013730525970459
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.0003058910369873
(66) DESCRIBE `ports` 0.0012829303741455
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00031495094299316
(68) DESCRIBE `ports` 0.0014939308166504
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00033903121948242
(70) DESCRIBE `ports` 0.0016729831695557
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00035405158996582
(72) DESCRIBE `avid_specials` 0.0015161037445068
(73) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 52239 and class = 'Cruise') OR (item_id = 1291 AND class = 'Ship') OR (item_id = 171 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.0010900497436523
(74) DESCRIBE `cruiselines` 0.0020608901977539
(75) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 171))) 0.00033712387084961
(76) DESCRIBE `orchid_image` 0.0018458366394043
(77) DESCRIBE `cruises` 0.0028479099273682
(78) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69851') 0.00041508674621582
(79) DESCRIBE `ships` 0.0031270980834961
(80) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1137))) 0.00048613548278809
(81) DESCRIBE `ships` 0.0029361248016357
(82) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1137') 0.00044798851013184
(83) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034999847412109
(84) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032901763916016
(85) DESCRIBE `itineraries` 0.0017590522766113
(86) DESCRIBE `ports` 0.0014708042144775
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00034213066101074
(88) DESCRIBE `ports` 0.0013060569763184
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00033211708068848
(90) DESCRIBE `ports` 0.0014541149139404
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00042295455932617
(92) DESCRIBE `sailingdates` 0.0017859935760498
(93) DESCRIBE `ports` 0.0019881725311279
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.0004580020904541
(95) DESCRIBE `ports` 0.0018570423126221
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00032901763916016
(97) DESCRIBE `ports` 0.001446008682251
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00044918060302734
(99) DESCRIBE `ports` 0.0017828941345215
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00036501884460449
(101) DESCRIBE `ports` 0.0018589496612549
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00043892860412598
(103) DESCRIBE `ports` 0.0015859603881836
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00032401084899902
(105) DESCRIBE `ports` 0.0013909339904785
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00043988227844238
(107) DESCRIBE `ports` 0.0017659664154053
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00037503242492676
(109) DESCRIBE `ports` 0.001331090927124
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2691))) 5.1975250244141E-5
(111) DESCRIBE `ports` 0.0013089179992676
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2691') 0.00028896331787109
(113) DESCRIBE `ports` 0.0012969970703125
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2692))) 0.00029897689819336
(115) DESCRIBE `ports` 0.0012819766998291
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2692') 0.00038385391235352
(117) DESCRIBE `ports` 0.0018010139465332
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3208))) 0.00041890144348145
(119) DESCRIBE `ports` 0.0018079280853271
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3208') 0.00032901763916016
(121) DESCRIBE `ports` 0.0014340877532959
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2937))) 0.00039887428283691
(123) DESCRIBE `ports` 0.0014009475708008
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2937') 0.00030088424682617
(125) DESCRIBE `ports` 0.0017590522766113
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2692))) 0.00032806396484375
(127) DESCRIBE `ports` 0.0014200210571289
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2692') 0.00031518936157227
(129) DESCRIBE `ports` 0.0015311241149902
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2691))) 0.0003349781036377
(131) DESCRIBE `ports` 0.0014729499816895
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2691') 0.00036478042602539
(133) DESCRIBE `ports` 0.0016510486602783
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00026488304138184
(135) DESCRIBE `ports` 0.0016751289367676
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00029420852661133
(137) DESCRIBE `ports` 0.001305103302002
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00029897689819336
(139) DESCRIBE `ports` 0.0014688968658447
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00028681755065918
(141) DESCRIBE `avid_specials` 0.0011470317840576
(142) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69851 and class = 'Cruise') OR (item_id = 1137 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 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.001115083694458
(143) DESCRIBE `cruiselines` 0.0020670890808105
(144) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00063300132751465
(145) DESCRIBE `orchid_image` 0.001521110534668
(146) DESCRIBE `cruiselines` 0.0025818347930908
(147) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00032305717468262
(148) DESCRIBE `cruises` 0.0025260448455811
(149) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '6056') 0.00032901763916016
(150) DESCRIBE `ships` 0.0030479431152344
(151) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 855))) 0.00048398971557617
(152) DESCRIBE `ships` 0.0030360221862793
(153) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '855') 0.00047588348388672
(154) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00027918815612793
(155) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00040793418884277
(156) DESCRIBE `itineraries` 0.0019950866699219
(157) DESCRIBE `ports` 0.0015871524810791
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00046992301940918
(159) DESCRIBE `ports` 0.001349925994873
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0003049373626709
(161) DESCRIBE `ports` 0.0013971328735352
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00029897689819336
(163) DESCRIBE `sailingdates` 0.0012199878692627
(164) DESCRIBE `ports` 0.0018010139465332
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00040578842163086
(166) DESCRIBE `ports` 0.0013952255249023
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00030279159545898
(168) DESCRIBE `ports` 0.0015029907226562
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00035905838012695
(170) DESCRIBE `ports` 0.0014951229095459
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00034093856811523
(172) DESCRIBE `ports` 0.0013031959533691
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00031709671020508
(174) DESCRIBE `ports` 0.0014400482177734
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00030183792114258
(176) DESCRIBE `ports` 0.0014410018920898
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00030803680419922
(178) DESCRIBE `ports` 0.0013329982757568
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00028300285339355
(180) DESCRIBE `ports` 0.0015208721160889
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00037503242492676
(182) DESCRIBE `ports` 0.001378059387207
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00029301643371582
(184) DESCRIBE `ports` 0.0013399124145508
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00030899047851562
(186) DESCRIBE `ports` 0.0013439655303955
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00028300285339355
(188) DESCRIBE `ports` 0.0013439655303955
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00037002563476562
(190) DESCRIBE `ports` 0.0013840198516846
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00047898292541504
(192) DESCRIBE `ports` 0.0015339851379395
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00030994415283203
(194) DESCRIBE `ports` 0.0014338493347168
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00029897689819336
(196) DESCRIBE `avid_specials` 0.0011441707611084
(197) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 6056 and class = 'Cruise') OR (item_id = 855 AND class = 'Ship') OR (item_id = 216 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.0011270046234131
(198) DESCRIBE `cruiselines` 0.0020279884338379
(199) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 216))) 0.00044894218444824
(200) DESCRIBE `orchid_image` 0.0015170574188232
(201) DESCRIBE `cruiselines` 0.0019669532775879
(202) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '216') 0.00039887428283691
(203) DESCRIBE `cruises` 0.0027470588684082
(204) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57948') 0.00038409233093262
(205) DESCRIBE `ships` 0.0027689933776855
(206) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 985))) 0.00046110153198242
(207) DESCRIBE `ships` 0.0029380321502686
(208) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '985') 0.00041604042053223
(209) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026082992553711
(210) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026893615722656
(211) DESCRIBE `itineraries` 0.0018899440765381
(212) DESCRIBE `ports` 0.001701831817627
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.00037622451782227
(214) DESCRIBE `ports` 0.0015060901641846
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.00033283233642578
(216) DESCRIBE `ports` 0.0016288757324219
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '100') 0.00036406517028809
(218) DESCRIBE `sailingdates` 0.0014219284057617
(219) DESCRIBE `ports` 0.0016520023345947
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.0003819465637207
(221) DESCRIBE `ports` 0.0014858245849609
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '100') 0.0003809928894043
(223) DESCRIBE `ports` 0.0013370513916016
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5100))) 0.00034308433532715
(225) DESCRIBE `ports` 0.0013840198516846
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5100') 0.00035691261291504
(227) DESCRIBE `ports` 0.0015580654144287
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 100))) 0.00032901763916016
(229) DESCRIBE `ports` 0.001309871673584
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '100') 0.00028395652770996
(231) DESCRIBE `ports` 0.0012800693511963
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 102))) 0.00030398368835449
(233) DESCRIBE `ports` 0.001338005065918
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '102') 0.00029993057250977
(235) DESCRIBE `ports` 0.0014979839324951
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 103))) 0.00033712387084961
(237) DESCRIBE `ports` 0.001317024230957
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '103') 0.00028705596923828
(239) DESCRIBE `ports` 0.001284122467041
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 104))) 0.00029802322387695
(241) DESCRIBE `ports` 0.001309871673584
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '104') 0.00027108192443848
(243) DESCRIBE `ports` 0.0017819404602051
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 103))) 0.00037884712219238
(245) DESCRIBE `ports` 0.0017988681793213
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '103') 0.00036406517028809
(247) DESCRIBE `ports` 0.0019080638885498
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 103))) 0.0003960132598877
(249) DESCRIBE `ports` 0.0018439292907715
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '103') 0.00035691261291504
(251) DESCRIBE `ports` 0.0018258094787598
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 103))) 0.00042104721069336
(253) DESCRIBE `ports` 0.0011670589447021
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '103') 0.00031280517578125
(255) DESCRIBE `avid_specials` 0.0011820793151855
(256) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57948 and class = 'Cruise') OR (item_id = 985 AND class = 'Ship') OR (item_id = 146 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.0010409355163574
(257) DESCRIBE `cruiselines` 0.0019030570983887
(258) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 146))) 0.0003209114074707
(259) DESCRIBE `orchid_image` 0.0014171600341797
(260) DESCRIBE `cruiselines` 0.0018379688262939
(261) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '146') 0.00031495094299316
(262) DESCRIBE `cruises` 0.0024900436401367
(263) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59437') 0.00033307075500488
(264) DESCRIBE `ships` 0.0033731460571289
(265) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1418))) 0.00044488906860352
(266) DESCRIBE `ships` 0.0026180744171143
(267) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1418') 0.00033807754516602
(268) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026297569274902
(269) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024890899658203
(270) DESCRIBE `itineraries` 0.0014069080352783
(271) DESCRIBE `ports` 0.0016269683837891
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.0003960132598877
(273) DESCRIBE `ports` 0.0013449192047119
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00034999847412109
(275) DESCRIBE `ports` 0.0013818740844727
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00029301643371582
(277) DESCRIBE `sailingdates` 0.0011799335479736
(278) DESCRIBE `ports` 0.0023541450500488
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00038695335388184
(280) DESCRIBE `ports` 0.0017709732055664
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00032806396484375
(282) DESCRIBE `ports` 0.0016601085662842
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2204))) 0.00034999847412109
(284) DESCRIBE `ports` 0.0017828941345215
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2204') 0.00038290023803711
(286) DESCRIBE `ports` 0.0017681121826172
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.00041413307189941
(288) DESCRIBE `ports` 0.0013349056243896
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.00054693222045898
(290) DESCRIBE `ports` 0.0017631053924561
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2831))) 0.00035595893859863
(292) DESCRIBE `ports` 0.0015361309051514
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2831') 0.00031805038452148
(294) DESCRIBE `ports` 0.0013861656188965
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2201))) 0.00033688545227051
(296) DESCRIBE `ports` 0.0012891292572021
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2201') 0.00028705596923828
(298) DESCRIBE `ports` 0.0013439655303955
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2203))) 0.00032401084899902
(300) DESCRIBE `ports` 0.0012810230255127
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2203') 0.00034213066101074
(302) DESCRIBE `ports` 0.0014059543609619
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2831))) 0.00032711029052734
(304) DESCRIBE `ports` 0.0013501644134521
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2831') 0.00034594535827637
(306) DESCRIBE `ports` 0.0012788772583008
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.0004270076751709
(308) DESCRIBE `ports` 0.0014851093292236
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.00032186508178711
(310) DESCRIBE `ports` 0.0013599395751953
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.00036215782165527
(312) DESCRIBE `ports` 0.0016038417816162
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.00035881996154785
(314) DESCRIBE `ports` 0.0018520355224609
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00045895576477051
(316) DESCRIBE `ports` 0.0018210411071777
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.0004279613494873
(318) DESCRIBE `avid_specials` 0.001619815826416
(319) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59437 and class = 'Cruise') OR (item_id = 1418 AND class = 'Ship') OR (item_id = 31 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.0016500949859619
(320) DESCRIBE `cruiselines` 0.0021851062774658
(321) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 31))) 0.00043201446533203
(322) DESCRIBE `orchid_image` 0.0016438961029053
(323) DESCRIBE `cruiselines` 0.0023760795593262
(324) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '31') 0.00034189224243164
(325) DESCRIBE `cruises` 0.0030050277709961
(326) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72413') 0.00036096572875977
(327) DESCRIBE `ships` 0.0025968551635742
(328) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1439))) 0.00039291381835938
(329) DESCRIBE `ships` 0.0026800632476807
(330) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1439') 0.00030708312988281
(331) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027823448181152
(332) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029683113098145
(333) DESCRIBE `itineraries` 0.0013599395751953
(334) DESCRIBE `ports` 0.0014939308166504
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5160))) 0.00042605400085449
(336) DESCRIBE `ports` 0.0014181137084961
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5160))) 0.00038003921508789
(338) DESCRIBE `ports` 0.0013189315795898
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5160') 0.00033116340637207
(340) DESCRIBE `sailingdates` 0.0011959075927734
(341) DESCRIBE `ports` 0.0014069080352783
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5160))) 0.00036001205444336
(343) DESCRIBE `ports` 0.0013229846954346
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5160') 0.00031900405883789
(345) DESCRIBE `ports` 0.0015349388122559
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00032496452331543
(347) DESCRIBE `ports` 0.0016059875488281
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00032186508178711
(349) DESCRIBE `ports` 0.0014040470123291
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.0003201961517334
(351) DESCRIBE `ports` 0.0015478134155273
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00029802322387695
(353) DESCRIBE `ports` 0.0013110637664795
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.00034904479980469
(355) DESCRIBE `ports` 0.0013060569763184
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.00029397010803223
(357) DESCRIBE `ports` 0.0015320777893066
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00032305717468262
(359) DESCRIBE `ports` 0.0012929439544678
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00029611587524414
(361) DESCRIBE `ports` 0.0013139247894287
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00032806396484375
(363) DESCRIBE `ports` 0.0012879371643066
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00030088424682617
(365) DESCRIBE `ports` 0.0010120868682861
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00031614303588867
(367) DESCRIBE `ports` 0.0012850761413574
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.0003211498260498
(369) DESCRIBE `ports` 0.0014362335205078
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00031399726867676
(371) DESCRIBE `ports` 0.0013511180877686
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00027918815612793
(373) DESCRIBE `ports` 0.0013129711151123
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00034785270690918
(375) DESCRIBE `ports` 0.001427173614502
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.0002899169921875
(377) DESCRIBE `ports` 0.0012741088867188
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00029993057250977
(379) DESCRIBE `ports` 0.0013158321380615
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00028300285339355
(381) DESCRIBE `ports` 0.0013010501861572
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00030398368835449
(383) DESCRIBE `ports` 0.0017058849334717
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00029206275939941
(385) DESCRIBE `ports` 0.0013728141784668
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00029587745666504
(387) DESCRIBE `ports` 0.0013430118560791
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00027704238891602
(389) DESCRIBE `avid_specials` 0.0012550354003906
(390) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72413 and class = 'Cruise') OR (item_id = 1439 AND class = 'Ship') OR (item_id = 249 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.0012140274047852
(391) DESCRIBE `cruiselines` 0.0021450519561768
(392) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 249))) 0.00035691261291504
(393) DESCRIBE `orchid_image` 0.0015659332275391
(394) DESCRIBE `cruiselines` 0.0018441677093506
(395) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '249') 0.00036883354187012
(396) DESCRIBE `cruises` 0.0026590824127197
(397) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73130') 0.00037980079650879
(398) DESCRIBE `ships` 0.0028450489044189
(399) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 407))) 0.00039315223693848
(400) DESCRIBE `ships` 0.0025660991668701
(401) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '407') 0.00032901763916016
(402) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00054812431335449
(403) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019693374633789
(404) DESCRIBE `itineraries` 0.0013840198516846
(405) DESCRIBE `ports` 0.001309871673584
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00031781196594238
(407) DESCRIBE `ports` 0.0017149448394775
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00034403800964355
(409) DESCRIBE `ports` 0.0014059543609619
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00027799606323242
(411) DESCRIBE `sailingdates` 0.0011970996856689
(412) DESCRIBE `ports` 0.0022220611572266
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0004880428314209
(414) DESCRIBE `ports` 0.0018320083618164
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00038385391235352
(416) DESCRIBE `ports` 0.0017580986022949
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00038313865661621
(418) DESCRIBE `ports` 0.0017910003662109
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00032901763916016
(420) DESCRIBE `ports` 0.0017809867858887
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00040698051452637
(422) DESCRIBE `ports` 0.0017797946929932
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00035619735717773
(424) DESCRIBE `ports` 0.0017158985137939
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00042200088500977
(426) DESCRIBE `ports` 0.0017099380493164
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.0003509521484375
(428) DESCRIBE `ports` 0.0017640590667725
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00037598609924316
(430) DESCRIBE `ports` 0.001802921295166
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00035905838012695
(432) DESCRIBE `ports` 0.0017330646514893
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00038814544677734
(434) DESCRIBE `ports` 0.0017530918121338
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00035881996154785
(436) DESCRIBE `ports` 0.0018420219421387
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00030708312988281
(438) DESCRIBE `ports` 0.0017399787902832
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00033783912658691
(440) DESCRIBE `avid_specials` 0.0016210079193115
(441) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73130 and class = 'Cruise') OR (item_id = 407 AND class = 'Ship') OR (item_id = 19 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.0018188953399658
(442) DESCRIBE `cruiselines` 0.002540111541748
(443) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00047016143798828
(444) DESCRIBE `orchid_image` 0.0019450187683105
(445) DESCRIBE `cruiselines` 0.0024518966674805
(446) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00038599967956543
(447) DESCRIBE `cruises` 0.0035018920898438
(448) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '34205') 0.00045013427734375
(449) DESCRIBE `ships` 0.0036919116973877
(450) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 35))) 0.00054788589477539
(451) DESCRIBE `ships` 0.0035200119018555
(452) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '35') 0.00044798851013184
(453) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00033187866210938
(454) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00032210350036621
(455) DESCRIBE `itineraries` 0.0019080638885498
(456) DESCRIBE `ports` 0.0020229816436768
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00045084953308105
(458) DESCRIBE `ports` 0.0019090175628662
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00041890144348145
(460) DESCRIBE `ports` 0.0014147758483887
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00029301643371582
(462) DESCRIBE `sailingdates` 0.0012738704681396
(463) DESCRIBE `ports` 0.0015718936920166
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00039291381835938
(465) DESCRIBE `ports` 0.0012860298156738
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00027894973754883
(467) DESCRIBE `ports` 0.001305103302002
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00030708312988281
(469) DESCRIBE `ports` 0.001262903213501
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.00028204917907715
(471) DESCRIBE `ports` 0.0014529228210449
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.00030303001403809
(473) DESCRIBE `ports` 0.0014050006866455
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.00032615661621094
(475) DESCRIBE `ports` 0.0013468265533447
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00034117698669434
(477) DESCRIBE `ports` 0.0013229846954346
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00026702880859375
(479) DESCRIBE `ports` 0.0012941360473633
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.00029897689819336
(481) DESCRIBE `ports` 0.0013110637664795
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.0002901554107666
(483) DESCRIBE `ports` 0.001291036605835
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 272))) 0.00038003921508789
(485) DESCRIBE `ports` 0.0013101100921631
(486) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '272') 0.00028705596923828
(487) DESCRIBE `ports` 0.0010290145874023
(488) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 273))) 0.00039100646972656
(489) DESCRIBE `ports` 0.0015709400177002
(490) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '273') 0.00030803680419922
(491) DESCRIBE `ports` 0.0013530254364014
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00031089782714844
(493) DESCRIBE `ports` 0.0013110637664795
(494) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00026893615722656
(495) DESCRIBE `ports` 0.0013089179992676
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 889))) 0.00029683113098145
(497) DESCRIBE `ports` 0.0012588500976562
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '889') 0.00026893615722656
(499) DESCRIBE `ports` 0.0013020038604736
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00029397010803223
(501) DESCRIBE `ports` 0.0012860298156738
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00026583671569824
(503) DESCRIBE `ports` 0.0013318061828613
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 271))) 0.00028491020202637
(505) DESCRIBE `ports` 0.0013828277587891
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '271') 0.00026917457580566
(507) DESCRIBE `avid_specials` 0.0012638568878174
(508) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 34205 and class = 'Cruise') OR (item_id = 35 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.0010089874267578
(509) DESCRIBE `cruiselines` 0.0018279552459717
(510) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 7))) 0.00034999847412109
(511) DESCRIBE `orchid_image` 0.0015838146209717
(512) DESCRIBE `cruiselines` 0.0019841194152832
(513) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '7') 0.0003199577331543
(514) DESCRIBE `cruises` 0.0025899410247803
(515) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52235') 0.00035905838012695
(516) DESCRIBE `ships` 0.0031700134277344
(517) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1291))) 0.00041317939758301
(518) DESCRIBE `ships` 0.0025310516357422
(519) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1291') 0.00034785270690918
(520) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00026297569274902
(521) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00024795532226562
(522) DESCRIBE `itineraries` 0.001309871673584
(523) DESCRIBE `ports` 0.0013570785522461
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.0003359317779541
(525) DESCRIBE `ports` 0.001338005065918
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00037002563476562
(527) DESCRIBE `ports` 0.0015981197357178
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00031208992004395
(529) DESCRIBE `sailingdates` 0.001291036605835
(530) DESCRIBE `ports` 0.0017378330230713
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.0004270076751709
(532) DESCRIBE `ports` 0.0016319751739502
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00031399726867676
(534) DESCRIBE `ports` 0.0012819766998291
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2666))) 0.00033116340637207
(536) DESCRIBE `ports` 0.0015418529510498
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2666') 0.00030994415283203
(538) DESCRIBE `ports` 0.0013048648834229
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5611))) 0.00031304359436035
(540) DESCRIBE `ports` 0.0014359951019287
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5611') 0.00034189224243164
(542) DESCRIBE `ports` 0.0012810230255127
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4183))) 0.00032496452331543
(544) DESCRIBE `ports` 0.0012698173522949
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4183') 0.00027298927307129
(546) DESCRIBE `ports` 0.0013179779052734
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4209))) 0.00030303001403809
(548) DESCRIBE `ports` 0.0013718605041504
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4209') 0.00027585029602051
(550) DESCRIBE `ports` 0.001356840133667
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2882))) 0.00035405158996582
(552) DESCRIBE `ports` 0.00130295753479
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2882') 0.00030803680419922
(554) DESCRIBE `ports` 0.0013430118560791
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2883))) 0.00031495094299316
(556) DESCRIBE `ports` 0.0016529560089111
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2883') 0.00029301643371582
(558) DESCRIBE `ports` 0.0014011859893799
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2595))) 0.00030899047851562
(560) DESCRIBE `ports` 0.0016529560089111
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2595') 0.00028514862060547
(562) DESCRIBE `ports` 0.001276969909668
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00036287307739258
(564) DESCRIBE `ports` 0.0010058879852295
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00031495094299316
(566) DESCRIBE `ports` 0.0013220310211182
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00033211708068848
(568) DESCRIBE `ports` 0.0012760162353516
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00042581558227539
(570) DESCRIBE `avid_specials` 0.0012190341949463
(571) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 52235 and class = 'Cruise') OR (item_id = 1291 AND class = 'Ship') OR (item_id = 171 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.0010590553283691
(572) DESCRIBE `cruiselines` 0.0019538402557373
(573) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 171))) 0.00044798851013184
(574) DESCRIBE `orchid_image` 0.0014679431915283
(575) DESCRIBE `cruises` 0.0026781558990479
(576) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58888') 0.0003669261932373
(577) DESCRIBE `ships` 0.003032922744751
(578) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1199))) 0.00043392181396484
(579) DESCRIBE `ships` 0.0026350021362305
(580) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1199') 0.00038409233093262
(581) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 9.2029571533203E-5
(582) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0002901554107666
(583) DESCRIBE `itineraries` 0.0014090538024902
(584) DESCRIBE `ports` 0.0013790130615234
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00034403800964355
(586) DESCRIBE `ports` 0.0012869834899902
(587) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00030803680419922
(588) DESCRIBE `ports` 0.0013937950134277
(589) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00030112266540527
(590) DESCRIBE `sailingdates` 0.0013329982757568
(591) DESCRIBE `ports` 0.0018460750579834
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00037097930908203
(593) DESCRIBE `ports` 0.0014359951019287
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.0003359317779541
(595) DESCRIBE `ports` 0.0015029907226562
(596) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2666))) 0.00036096572875977
(597) DESCRIBE `ports` 0.0015721321105957
(598) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2666') 0.00030303001403809
(599) DESCRIBE `ports` 0.0013530254364014
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2666))) 0.00036907196044922
(601) DESCRIBE `ports` 0.0013401508331299
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2666') 0.00027298927307129
(603) DESCRIBE `ports` 0.0013799667358398
(604) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2671))) 0.00030207633972168
(605) DESCRIBE `ports` 0.0012798309326172
(606) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2671') 0.00027108192443848
(607) DESCRIBE `ports` 0.0013649463653564
(608) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2529))) 0.00030112266540527
(609) DESCRIBE `ports` 0.0015778541564941
(610) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2529') 0.00037193298339844
(611) DESCRIBE `ports` 0.0013182163238525
(612) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2597))) 0.00030708312988281
(613) DESCRIBE `ports` 0.0013618469238281
(614) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2597') 0.00031781196594238
(615) DESCRIBE `ports` 0.0012779235839844
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2527))) 0.00031280517578125
(617) DESCRIBE `ports` 0.0014240741729736
(618) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2527') 0.00027799606323242
(619) DESCRIBE `ports` 0.0016829967498779
(620) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2525))) 0.0004270076751709
(621) DESCRIBE `ports` 0.001356840133667
(622) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2525') 0.00036120414733887
(623) DESCRIBE `ports` 0.0010859966278076
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2671))) 0.0003359317779541
(625) DESCRIBE `ports` 0.0017430782318115
(626) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2671') 0.0003972053527832
(627) DESCRIBE `ports` 0.0014359951019287
(628) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00063896179199219
(629) DESCRIBE `ports` 0.0013449192047119
(630) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00028181076049805
(631) DESCRIBE `ports` 0.0016701221466064
(632) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00034809112548828
(633) DESCRIBE `ports` 0.0014228820800781
(634) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00029706954956055
(635) DESCRIBE `avid_specials` 0.0011630058288574
(636) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 58888 and class = 'Cruise') OR (item_id = 1199 AND class = 'Ship') OR (item_id = 171 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.0011160373687744
(637) DESCRIBE `cruiselines` 0.0020089149475098
(638) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 171))) 0.00044798851013184
(639) DESCRIBE `orchid_image` 0.0020358562469482
(640) DESCRIBE `cruiselines` 0.0027029514312744
(641) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('183', '218', '26', '19', '77', '23', '7', '12', '20', '171', '18', '144', '8', '101', '31', '131', '50', '96', '239', '29', '103', '15', '191', '91', '206', '120', '37', '16', '262', '24', '33', '114', '28', '14', '268', '174', '221', '110', '156', '208', '187', '141', '153', '118', '151', '49', '211', '30', '258', '216', '181', '88', '4', '212', '36', '264', '225', '238', '140', '184', '232', '249', '159', '90', '113', '230', '182', '213', '136', '276', '47', '188', '237', '261', '57', '64', '180', '73', '248', '35', '95', '209', '52', '231', '146', '195', '116', '219', '59', '256', '82', '119', '115', '168', '196', '105', '134', '244', '170', '229', '204', '240', '48', '224')) ORDER BY FIND_IN_SET(id, '183,218,26,19,77,23,7,12,20,171,18,144,8,101,31,131,50,96,239,29,103,15,191,91,206,120,37,16,262,24,33,114,28,14,268,174,221,110,156,208,187,141,153,118,151,49,211,30,258,216,181,88,4,212,36,264,225,238,140,184,232,249,159,90,113,230,182,213,136,276,47,188,237,261,57,64,180,73,248,35,95,209,52,231,146,195,116,219,59,256,82,119,115,168,196,105,134,244,170,229,204,240,48,224') 0.0069899559020996
(642) DESCRIBE `ships` 0.0031101703643799
(643) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1554', '1555', '1127', '974', '1032', '797', '1292', '1205', '1291', '977', '258', '1199', '1359', '1599', '349', '454', '1272', '404', '780', '855', '1135', '1677', '986', '1067', '1237', '265', '1594', '34', '38', '837', '1607', '37', '407', '21', '22', '27', '378', '461', '1376', '28', '31', '770', '1588', '393', '817', '542', '39', '1012', '30', '36', '1245', '573', '1424', '1552', '35', '1402', '726', '792', '585', '330', '1415', '66', '462', '882', '332', '1284', '1422', '1744', '113', '1176', '1423', '711', '1419', '1574', '1760', '9', '24', '1418', '1420', '1421', '11', '1405', '439', '455', '1215', '10', '434', '580', '766', '1021', '1141', '1193', '78', '739', '452', '69', '81', '1454', '1572', '1372', '1682', '3', '635', '674', '1008', '1095', '678', '124', '338', '1373', '1168', '1319', '5', '335', '340', '116', '253', '43', '553', '850', '1247', '1302', '1569', '1678', '70', '148', '285', '1172', '451', '111', '160', '348', '658', '25', '874', '944', '1260', '4', '390', '716', '966', '1259', '386', '748', '385', '405', '616', '626', '651', '1108', '1562', '791', '1320', '1330', '314', '1088', '1323', '1325', '63', '389', '406', '683', '768', '784', '286', '1455', '1645', '1672', '207', '287', '508', '582', '590', '970', '1587', '327', '375', '483', '749', '1195', '119', '526', '1575', '84', '108', '291', '559', '1068', '401', '520', '722', '854', '1208', '1460', '98', '163', '394', '1398', '290', '657', '1742', '485', '1571', '1586', '150', '652', '775', '776', '1236', '1268', '1492', '147', '403', '421', '704', '1269', '114', '151', '152', '341', '547', '1064', '1266', '1308', '123', '223', '1289', '1321', '105', '149', '993', '325', '883', '954', '262', '517', '715', '958', '1270', '1711', '45', '351', '1389', '1471', '1724', '75', '1139', '1243', '1282', '1486', '1601', '1722', '1143', '1557', '1717', '545', '717', '790', '1561', '162', '441', '1526', '1579', '1738', '324', '823', '885', '1013', '1075', '1151', '1159', '1214', '1326', '1327', '1437', '1539', '333', '673', '796', '1303', '1367', '93', '205', '516', '968', '1040', '1301', '1318', '1704', '818', '1216', '1348', '1540', '82', '212', '701', '1063', '1218', '1602', '743', '988', '1043', '1137', '1344', '201', '751', '769', '852', '1144', '1217', '1343', '1566', '1676', '1740', '574', '732', '1160', '1409', '1604', '795', '884', '1163', '1283', '1452', '1453', '266', '448', '639', '738', '1025', '1090', '1136', '1157', '1253', '1721', '601', '669', '811', '1223', '1226', '1241', '1426', '1449', '1766', '14', '905', '1019', '1027', '1029', '1229', '1411', '1413', '1632', '1716', '467', '1073', '1152', '1358', '1474', '494', '997', '1150', '1188', '1233', '1448', '1619', '74', '1055', '1345', '1351', '1408', '1673', '1713', '1715', '417', '836', '996', '1026', '1047', '1145', '1322', '1410', '1458', '1496', '1647', '1663', '1714', '610', '643', '709', '1730', '1743', '423', '453', '618', '888', '973', '1034', '1149', '1231', '1366', '1404', '1580', '1609', '208', '851', '1037', '1049', '1187', '1196', '1222', '1360', '1361', '1362', '1368', '1407', '1459', '1470', '1489', '1505', '1516', '521', '666', '920', '921', '927', '931', '1004', '1017', '1042', '1140', '1154', '1230', '1354', '1508', '1606', '1627', '1649', '352', '493', '914', '923', '1106', '1444', '1517', '1518', '1567', '499', '663', '915', '916', '926', '930', '1003', '1072', '1138', '1674', '1708', '1751', '479', '703', '781', '924', '972', '1001', '1020', '1052', '1175', '1262', '1352', '1412', '1521', '1522', '1593', '1596', '1723', '422', '665', '671', '938', '1005', '1045', '1054', '1254', '1285', '1463', '1729', '937', '1051', '1053', '1091', '1092', '1445', '1650', '1681', '1684', '672', '1514', '1679')) ORDER BY FIND_IN_SET(id, '1761,1554,1555,1127,974,1032,797,1292,1205,1291,977,258,1199,1359,1599,349,454,1272,404,780,855,1135,1677,986,1067,1237,265,1594,34,38,837,1607,37,407,21,22,27,378,461,1376,28,31,770,1588,393,817,542,39,1012,30,36,1245,573,1424,1552,35,1402,726,792,585,330,1415,66,462,882,332,1284,1422,1744,113,1176,1423,711,1419,1574,1760,9,24,1418,1420,1421,11,1405,439,455,1215,10,434,580,766,1021,1141,1193,78,739,452,69,81,1454,1572,1372,1682,3,635,674,1008,1095,678,124,338,1373,1168,1319,5,335,340,116,253,43,553,850,1247,1302,1569,1678,70,148,285,1172,451,111,160,348,658,25,874,944,1260,4,390,716,966,1259,386,748,385,405,616,626,651,1108,1562,791,1320,1330,314,1088,1323,1325,63,389,406,683,768,784,286,1455,1645,1672,207,287,508,582,590,970,1587,327,375,483,749,1195,119,526,1575,84,108,291,559,1068,401,520,722,854,1208,1460,98,163,394,1398,290,657,1742,485,1571,1586,150,652,775,776,1236,1268,1492,147,403,421,704,1269,114,151,152,341,547,1064,1266,1308,123,223,1289,1321,105,149,993,325,883,954,262,517,715,958,1270,1711,45,351,1389,1471,1724,75,1139,1243,1282,1486,1601,1722,1143,1557,1717,545,717,790,1561,162,441,1526,1579,1738,324,823,885,1013,1075,1151,1159,1214,1326,1327,1437,1539,333,673,796,1303,1367,93,205,516,968,1040,1301,1318,1704,818,1216,1348,1540,82,212,701,1063,1218,1602,743,988,1043,1137,1344,201,751,769,852,1144,1217,1343,1566,1676,1740,574,732,1160,1409,1604,795,884,1163,1283,1452,1453,266,448,639,738,1025,1090,1136,1157,1253,1721,601,669,811,1223,1226,1241,1426,1449,1766,14,905,1019,1027,1029,1229,1411,1413,1632,1716,467,1073,1152,1358,1474,494,997,1150,1188,1233,1448,1619,74,1055,1345,1351,1408,1673,1713,1715,417,836,996,1026,1047,1145,1322,1410,1458,1496,1647,1663,1714,610,643,709,1730,1743,423,453,618,888,973,1034,1149,1231,1366,1404,1580,1609,208,851,1037,1049,1187,1196,1222,1360,1361,1362,1368,1407,1459,1470,1489,1505,1516,521,666,920,921,927,931,1004,1017,1042,1140,1154,1230,1354,1508,1606,1627,1649,352,493,914,923,1106,1444,1517,1518,1567,499,663,915,916,926,930,1003,1072,1138,1674,1708,1751,479,703,781,924,972,1001,1020,1052,1175,1262,1352,1412,1521,1522,1593,1596,1723,422,665,671,938,1005,1045,1054,1254,1285,1463,1729,937,1051,1053,1091,1092,1445,1650,1681,1684,672,1514,1679') 0.04349684715271
(644) DESCRIBE `cruisetypes` 0.0019130706787109
(645) DESCRIBE `destinations` 0.0017890930175781
(646) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '35', '22', '54', '25', '37', '9', '43', '2', '8', '53', '39', '28', '55', '26', '38', '40', '7', '30', '48', '21', '11', '49', '45', '29', '44', '56', '10', '34', '52', '32', '46')) ORDER BY FIND_IN_SET(id, '50,12,35,22,54,25,37,9,43,2,8,53,39,28,55,26,38,40,7,30,48,21,11,49,45,29,44,56,10,34,52,32,46') 0.0018861293792725