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

Total elapsed time: 0.77422595024109

# Query Time
(1) connect 0.0016090869903564
(2) DESCRIBE `cruises` 0.0042960643768311
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66888, 62833, 69852, 59503, 62750, 64193, 13509, 40596, 45258, 48299)) ORDER BY FIND_IN_SET(id, '66888,62833,69852,59503,62750,64193,13509,40596,45258,48299') 0.0021231174468994
(4) DESCRIBE `cruises` 0.0033628940582275
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66888') 0.00041103363037109
(6) DESCRIBE `ships` 0.0034520626068115
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 968))) 0.00041103363037109
(8) DESCRIBE `ships` 0.0028800964355469
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '968') 0.00032782554626465
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00028610229492188
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033879280090332
(12) DESCRIBE `itineraries` 0.0016398429870605
(13) DESCRIBE `ports` 0.001492977142334
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00041007995605469
(15) DESCRIBE `ports` 0.0015449523925781
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00030183792114258
(17) DESCRIBE `ports` 0.0014870166778564
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00028204917907715
(19) DESCRIBE `sailingdates` 0.0011742115020752
(20) DESCRIBE `ports` 0.0014281272888184
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00034499168395996
(22) DESCRIBE `ports` 0.0018520355224609
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00034379959106445
(24) DESCRIBE `ports` 0.0014219284057617
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00031495094299316
(26) DESCRIBE `ports` 0.0014479160308838
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.0003809928894043
(28) DESCRIBE `ports` 0.0017518997192383
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00034213066101074
(30) DESCRIBE `ports` 0.0017168521881104
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00032901763916016
(32) DESCRIBE `ports` 0.0017910003662109
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00044107437133789
(34) DESCRIBE `ports` 0.0018889904022217
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00046396255493164
(36) DESCRIBE `ports` 0.0018980503082275
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.0004119873046875
(38) DESCRIBE `ports` 0.0013561248779297
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00031399726867676
(40) DESCRIBE `ports` 0.0014138221740723
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00033187866210938
(42) DESCRIBE `ports` 0.0015978813171387
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00037407875061035
(44) DESCRIBE `ports` 0.0018370151519775
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00058889389038086
(46) DESCRIBE `ports` 0.001884937286377
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00045299530029297
(48) DESCRIBE `avid_specials` 0.0018970966339111
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66888 and class = 'Cruise') OR (item_id = 968 AND class = 'Ship') OR (item_id = 8 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017280578613281
(50) DESCRIBE `cruiselines` 0.0027530193328857
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00049710273742676
(52) DESCRIBE `orchid_image` 0.0020451545715332
(53) DESCRIBE `cruiselines` 0.0026040077209473
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00081300735473633
(55) DESCRIBE `cruises` 0.003140926361084
(56) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62833') 0.00043797492980957
(57) DESCRIBE `ships` 0.0032100677490234
(58) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1471))) 0.00045394897460938
(59) DESCRIBE `ships` 0.0035378932952881
(60) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1471') 0.00053906440734863
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035691261291504
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00032305717468262
(63) DESCRIBE `itineraries` 0.0018777847290039
(64) DESCRIBE `ports` 0.0016429424285889
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 879))) 0.00047016143798828
(66) DESCRIBE `ports` 0.0016660690307617
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 879))) 0.00035786628723145
(68) DESCRIBE `ports` 0.0015690326690674
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '879') 0.0003509521484375
(70) DESCRIBE `sailingdates` 0.00124192237854
(71) DESCRIBE `ports` 0.0021090507507324
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 879))) 0.00045514106750488
(73) DESCRIBE `ports` 0.0018441677093506
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '879') 0.00038981437683105
(75) DESCRIBE `ports` 0.0017931461334229
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 99))) 0.00044918060302734
(77) DESCRIBE `ports` 0.001849889755249
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '99') 0.00041007995605469
(79) DESCRIBE `ports` 0.0018980503082275
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2597))) 0.00042605400085449
(81) DESCRIBE `ports` 0.0019090175628662
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2597') 0.00038981437683105
(83) DESCRIBE `ports` 0.0017781257629395
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2525))) 0.0004429817199707
(85) DESCRIBE `ports` 0.001788854598999
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2525') 0.00040316581726074
(87) DESCRIBE `ports` 0.0018200874328613
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1650))) 0.00047588348388672
(89) DESCRIBE `ports` 0.0017919540405273
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1650') 0.0003662109375
(91) DESCRIBE `ports` 0.0018589496612549
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2528))) 0.00040817260742188
(93) DESCRIBE `ports` 0.0017938613891602
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2528') 0.00045084953308105
(95) DESCRIBE `ports` 0.001943826675415
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4454))) 0.00040292739868164
(97) DESCRIBE `ports` 0.0016689300537109
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4454') 0.00035881996154785
(99) DESCRIBE `ports` 0.0016617774963379
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1652))) 0.00035214424133301
(101) DESCRIBE `ports` 0.0015859603881836
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1652') 0.00034809112548828
(103) DESCRIBE `ports` 0.0017437934875488
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 99))) 0.00038695335388184
(105) DESCRIBE `ports` 0.0023379325866699
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '99') 0.00046205520629883
(107) DESCRIBE `ports` 0.0018599033355713
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 879))) 0.00041890144348145
(109) DESCRIBE `ports` 0.0014350414276123
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '879') 0.00028491020202637
(111) DESCRIBE `ports` 0.0012509822845459
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 879))) 0.00030517578125
(113) DESCRIBE `ports` 0.0012800693511963
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '879') 0.0002739429473877
(115) DESCRIBE `avid_specials` 0.0012469291687012
(116) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62833 and class = 'Cruise') OR (item_id = 1471 AND class = 'Ship') OR (item_id = 110 AND class = 'CruiseLine') OR (item_id = 37 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00099992752075195
(117) DESCRIBE `cruiselines` 0.0016181468963623
(118) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 110))) 0.0003669261932373
(119) DESCRIBE `orchid_image` 0.0014910697937012
(120) DESCRIBE `cruiselines` 0.0018398761749268
(121) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '110') 0.00035786628723145
(122) DESCRIBE `cruises` 0.0027999877929688
(123) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69852') 0.00052595138549805
(124) DESCRIBE `ships` 0.0030980110168457
(125) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1136))) 0.00037813186645508
(126) DESCRIBE `ships` 0.0029361248016357
(127) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1136') 0.00036406517028809
(128) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033283233642578
(129) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00030088424682617
(130) DESCRIBE `itineraries` 0.001629114151001
(131) DESCRIBE `ports` 0.0014829635620117
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00038886070251465
(133) DESCRIBE `ports` 0.0013120174407959
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00035500526428223
(135) DESCRIBE `ports` 0.0014040470123291
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00030183792114258
(137) DESCRIBE `sailingdates` 0.0013508796691895
(138) DESCRIBE `ports` 0.0021300315856934
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00037789344787598
(140) DESCRIBE `ports` 0.0013830661773682
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00029301643371582
(142) DESCRIBE `ports` 0.0013039112091064
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00029397010803223
(144) DESCRIBE `ports` 0.0012550354003906
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00027799606323242
(146) DESCRIBE `ports` 0.0013101100921631
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.0003199577331543
(148) DESCRIBE `ports` 0.0014100074768066
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00028681755065918
(150) DESCRIBE `ports` 0.0012881755828857
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00037884712219238
(152) DESCRIBE `ports` 0.0014009475708008
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00032806396484375
(154) DESCRIBE `ports` 0.0013091564178467
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2691))) 0.00037097930908203
(156) DESCRIBE `ports` 0.0012869834899902
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2691') 0.00028300285339355
(158) DESCRIBE `ports` 0.0012679100036621
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2692))) 0.00033879280090332
(160) DESCRIBE `ports` 0.001338005065918
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2692') 0.00034713745117188
(162) DESCRIBE `ports` 0.0017490386962891
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3208))) 0.00040483474731445
(164) DESCRIBE `ports` 0.0017681121826172
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3208') 0.0003659725189209
(166) DESCRIBE `ports` 0.0017359256744385
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2937))) 0.00043702125549316
(168) DESCRIBE `ports` 0.0015578269958496
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2937') 0.00036907196044922
(170) DESCRIBE `ports` 0.0013601779937744
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2692))) 0.00042200088500977
(172) DESCRIBE `ports` 0.001413106918335
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2692') 0.00032901763916016
(174) DESCRIBE `ports` 0.001291036605835
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2691))) 0.00030708312988281
(176) DESCRIBE `ports` 0.0012741088867188
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2691') 0.00036001205444336
(178) DESCRIBE `ports` 0.0014870166778564
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.0003659725189209
(180) DESCRIBE `ports` 0.0014529228210449
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00028705596923828
(182) DESCRIBE `ports` 0.0013058185577393
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00036501884460449
(184) DESCRIBE `ports` 0.0012550354003906
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00037908554077148
(186) DESCRIBE `avid_specials` 0.0012400150299072
(187) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69852 and class = 'Cruise') OR (item_id = 1136 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.0010049343109131
(188) DESCRIBE `cruiselines` 0.0022799968719482
(189) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00037097930908203
(190) DESCRIBE `orchid_image` 0.0025880336761475
(191) DESCRIBE `cruiselines` 0.0025360584259033
(192) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00040698051452637
(193) DESCRIBE `cruises` 0.0028250217437744
(194) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59503') 0.00034213066101074
(195) DESCRIBE `ships` 0.0033049583435059
(196) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 385))) 0.00059890747070312
(197) DESCRIBE `ships` 0.0039389133453369
(198) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '385') 0.00040411949157715
(199) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027894973754883
(200) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029683113098145
(201) DESCRIBE `itineraries` 0.001802921295166
(202) DESCRIBE `ports` 0.0019230842590332
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00045299530029297
(204) DESCRIBE `ports` 0.0013389587402344
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00032401084899902
(206) DESCRIBE `ports` 0.0012850761413574
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00028800964355469
(208) DESCRIBE `sailingdates` 0.0012459754943848
(209) DESCRIBE `ports` 0.001356840133667
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00036406517028809
(211) DESCRIBE `ports` 0.0017409324645996
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00037908554077148
(213) DESCRIBE `ports` 0.0015828609466553
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 500))) 0.00036406517028809
(215) DESCRIBE `ports` 0.0013670921325684
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '500') 0.00034093856811523
(217) DESCRIBE `ports` 0.0015709400177002
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 665))) 0.00048398971557617
(219) DESCRIBE `ports` 0.0014619827270508
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '665') 0.00032305717468262
(221) DESCRIBE `ports` 0.0013999938964844
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 53))) 0.00033998489379883
(223) DESCRIBE `ports` 0.0015251636505127
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '53') 0.00030803680419922
(225) DESCRIBE `ports` 0.0015299320220947
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 743))) 0.00040721893310547
(227) DESCRIBE `ports` 0.0016639232635498
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '743') 0.00040102005004883
(229) DESCRIBE `ports` 0.0015871524810791
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 742))) 0.00034117698669434
(231) DESCRIBE `ports` 0.0015509128570557
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '742') 0.00035190582275391
(233) DESCRIBE `ports` 0.0016410350799561
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1755))) 0.00055599212646484
(235) DESCRIBE `ports` 0.0017991065979004
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1755') 0.00039982795715332
(237) DESCRIBE `ports` 0.0015909671783447
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2449))) 0.00033712387084961
(239) DESCRIBE `ports` 0.0013868808746338
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2449') 0.00031590461730957
(241) DESCRIBE `ports` 0.0013620853424072
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00034713745117188
(243) DESCRIBE `ports` 0.00142502784729
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00029397010803223
(245) DESCRIBE `ports` 0.0013339519500732
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00034713745117188
(247) DESCRIBE `ports` 0.0014040470123291
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00041484832763672
(249) DESCRIBE `ports` 0.0016398429870605
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2928))) 0.00044107437133789
(251) DESCRIBE `ports` 0.0015778541564941
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2928') 0.0004889965057373
(253) DESCRIBE `avid_specials` 0.0015110969543457
(254) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59503 and class = 'Cruise') OR (item_id = 385 AND class = 'Ship') OR (item_id = 88 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.0013759136199951
(255) DESCRIBE `cruiselines` 0.0025970935821533
(256) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 88))) 0.00052404403686523
(257) DESCRIBE `orchid_image` 0.0019650459289551
(258) DESCRIBE `cruiselines` 0.0026230812072754
(259) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '88') 0.00046896934509277
(260) DESCRIBE `cruises` 0.0034489631652832
(261) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62750') 0.00050497055053711
(262) DESCRIBE `ships` 0.0030689239501953
(263) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1109))) 0.00051116943359375
(264) DESCRIBE `ships` 0.0032639503479004
(265) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1109') 0.00044512748718262
(266) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00031399726867676
(267) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0002589225769043
(268) DESCRIBE `itineraries` 0.0013678073883057
(269) DESCRIBE `ports` 0.0015609264373779
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 495))) 0.00049304962158203
(271) DESCRIBE `ports` 0.0017621517181396
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 495))) 0.00045204162597656
(273) DESCRIBE `ports` 0.0016660690307617
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '495') 0.00039386749267578
(275) DESCRIBE `sailingdates` 0.0012221336364746
(276) DESCRIBE `ports` 0.0015578269958496
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 495))) 0.0003809928894043
(278) DESCRIBE `ports` 0.0013878345489502
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '495') 0.00031900405883789
(280) DESCRIBE `ports` 0.0015089511871338
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 495))) 0.00057697296142578
(282) DESCRIBE `ports` 0.0013828277587891
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '495') 0.00034308433532715
(284) DESCRIBE `ports` 0.0014429092407227
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 356))) 0.00037503242492676
(286) DESCRIBE `ports` 0.0013248920440674
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '356') 0.00039505958557129
(288) DESCRIBE `ports` 0.0017549991607666
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 619))) 0.00011110305786133
(290) DESCRIBE `ports` 0.0013809204101562
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '619') 0.00033998489379883
(292) DESCRIBE `ports` 0.0011920928955078
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2054))) 0.00039410591125488
(294) DESCRIBE `ports` 0.0014450550079346
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2054') 9.2983245849609E-5
(296) DESCRIBE `ports` 0.0014269351959229
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3040))) 0.00036191940307617
(298) DESCRIBE `ports` 0.0013248920440674
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3040') 0.00032305717468262
(300) DESCRIBE `ports` 0.0013339519500732
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4930))) 0.00030112266540527
(302) DESCRIBE `ports` 0.002065896987915
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4930') 0.00042986869812012
(304) DESCRIBE `ports` 0.0014770030975342
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 624))) 0.0003209114074707
(306) DESCRIBE `ports` 0.0013079643249512
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '624') 0.00032210350036621
(308) DESCRIBE `ports` 0.0012619495391846
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00031304359436035
(310) DESCRIBE `ports` 0.0013599395751953
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00031399726867676
(312) DESCRIBE `ports` 0.0014920234680176
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2139))) 0.00031185150146484
(314) DESCRIBE `ports` 0.0013048648834229
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2139') 0.00028014183044434
(316) DESCRIBE `avid_specials` 0.0012149810791016
(317) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62750 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.001147985458374
(318) DESCRIBE `cruiselines` 0.0021090507507324
(319) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 208))) 0.00036501884460449
(320) DESCRIBE `orchid_image` 0.0015721321105957
(321) DESCRIBE `cruiselines` 0.0019090175628662
(322) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '208') 0.00034189224243164
(323) DESCRIBE `cruises` 0.0025930404663086
(324) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64193') 0.00032782554626465
(325) DESCRIBE `ships` 0.0027289390563965
(326) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 722))) 0.00049805641174316
(327) DESCRIBE `ships` 0.0026659965515137
(328) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '722') 0.00034284591674805
(329) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026988983154297
(330) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025701522827148
(331) DESCRIBE `itineraries` 0.0013101100921631
(332) DESCRIBE `ports` 0.0013570785522461
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00035405158996582
(334) DESCRIBE `ports` 0.0013508796691895
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00031304359436035
(336) DESCRIBE `ports` 0.0012791156768799
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00030207633972168
(338) DESCRIBE `sailingdates` 0.0011529922485352
(339) DESCRIBE `ports` 0.0015621185302734
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00036406517028809
(341) DESCRIBE `ports` 0.0015020370483398
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00038003921508789
(343) DESCRIBE `ports` 0.0014619827270508
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00037002563476562
(345) DESCRIBE `ports` 0.0013198852539062
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00029492378234863
(347) DESCRIBE `ports` 0.0012710094451904
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00034785270690918
(349) DESCRIBE `ports` 0.0014629364013672
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00052499771118164
(351) DESCRIBE `ports` 0.0020787715911865
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 347))) 0.00033092498779297
(353) DESCRIBE `ports` 0.0013611316680908
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '347') 0.00029110908508301
(355) DESCRIBE `ports` 0.001255989074707
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4467))) 0.00033998489379883
(357) DESCRIBE `ports` 0.0012879371643066
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4467') 0.00029492378234863
(359) DESCRIBE `ports` 0.0013179779052734
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00032806396484375
(361) DESCRIBE `ports` 0.0015120506286621
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00041890144348145
(363) DESCRIBE `ports` 0.0015439987182617
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00043797492980957
(365) DESCRIBE `ports` 0.0013720989227295
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00031185150146484
(367) DESCRIBE `avid_specials` 0.001129150390625
(368) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64193 and class = 'Cruise') OR (item_id = 722 AND class = 'Ship') OR (item_id = 8 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011568069458008
(369) DESCRIBE `cruiselines` 0.0020151138305664
(370) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00037622451782227
(371) DESCRIBE `orchid_image` 0.0016520023345947
(372) DESCRIBE `cruiselines` 0.0023670196533203
(373) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00042510032653809
(374) DESCRIBE `cruises` 0.0037000179290771
(375) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '13509') 0.00045609474182129
(376) DESCRIBE `ships` 0.0027039051055908
(377) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 14))) 0.00041913986206055
(378) DESCRIBE `ships` 0.0031108856201172
(379) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '14') 0.00034785270690918
(380) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002751350402832
(381) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028896331787109
(382) DESCRIBE `itineraries` 0.0016360282897949
(383) DESCRIBE `ports` 0.0016028881072998
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00039196014404297
(385) DESCRIBE `ports` 0.0012710094451904
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00030708312988281
(387) DESCRIBE `ports` 0.0013260841369629
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00032401084899902
(389) DESCRIBE `sailingdates` 0.0013771057128906
(390) DESCRIBE `ports` 0.0015130043029785
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00035691261291504
(392) DESCRIBE `ports` 0.0018050670623779
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00039196014404297
(394) DESCRIBE `ports` 0.0018961429595947
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00045609474182129
(396) DESCRIBE `ports` 0.0019419193267822
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.0004279613494873
(398) DESCRIBE `ports` 0.0013971328735352
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1160))) 0.00036096572875977
(400) DESCRIBE `ports` 0.0013329982757568
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1160') 0.00030899047851562
(402) DESCRIBE `ports` 0.0013937950134277
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00032901763916016
(404) DESCRIBE `ports` 0.0012979507446289
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00029611587524414
(406) DESCRIBE `ports` 0.0013151168823242
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00030803680419922
(408) DESCRIBE `ports` 0.0012900829315186
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00034785270690918
(410) DESCRIBE `ports` 0.0013599395751953
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1160))) 0.00032186508178711
(412) DESCRIBE `ports` 0.0014219284057617
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1160') 0.00029706954956055
(414) DESCRIBE `ports` 0.0012800693511963
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00034594535827637
(416) DESCRIBE `ports` 0.023003816604614
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00038290023803711
(418) DESCRIBE `ports` 0.001356840133667
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00047802925109863
(420) DESCRIBE `ports` 0.001777172088623
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00036811828613281
(422) DESCRIBE `ports` 0.0017728805541992
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00041079521179199
(424) DESCRIBE `ports` 0.0014610290527344
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00029110908508301
(426) DESCRIBE `ports` 0.0016839504241943
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1161))) 0.00044012069702148
(428) DESCRIBE `ports` 0.001917839050293
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1161') 0.00042510032653809
(430) DESCRIBE `ports` 0.0018448829650879
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.0004570484161377
(432) DESCRIBE `ports` 0.0019371509552002
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00042605400085449
(434) DESCRIBE `ports` 0.0018918514251709
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00063610076904297
(436) DESCRIBE `ports` 0.0019679069519043
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00045013427734375
(438) DESCRIBE `ports` 0.00189208984375
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00036907196044922
(440) DESCRIBE `ports` 0.0013201236724854
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00029397010803223
(442) DESCRIBE `ports` 0.0013358592987061
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00035405158996582
(444) DESCRIBE `ports` 0.0014398097991943
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.0003049373626709
(446) DESCRIBE `ports` 0.0012540817260742
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00035500526428223
(448) DESCRIBE `ports` 0.0015451908111572
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00069093704223633
(450) DESCRIBE `ports` 0.0014798641204834
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00035905838012695
(452) DESCRIBE `ports` 0.0015418529510498
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00030398368835449
(454) DESCRIBE `avid_specials` 0.0011961460113525
(455) 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.00085806846618652
(456) DESCRIBE `cruiselines` 0.0019519329071045
(457) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 35))) 0.0001370906829834
(458) DESCRIBE `orchid_image` 0.0015799999237061
(459) DESCRIBE `cruiselines` 0.0019071102142334
(460) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '35') 0.00035214424133301
(461) DESCRIBE `cruises` 0.0033328533172607
(462) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '40596') 0.0004580020904541
(463) DESCRIBE `ships` 0.0027740001678467
(464) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1032))) 0.0004417896270752
(465) DESCRIBE `ships` 0.0027530193328857
(466) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1032') 0.0003659725189209
(467) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026798248291016
(468) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003201961517334
(469) DESCRIBE `itineraries` 0.0013260841369629
(470) DESCRIBE `ports` 0.001378059387207
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00035595893859863
(472) DESCRIBE `ports` 0.0012998580932617
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00041413307189941
(474) DESCRIBE `ports` 0.0013289451599121
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00032401084899902
(476) DESCRIBE `sailingdates` 0.0011701583862305
(477) DESCRIBE `ports` 0.0017688274383545
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00038290023803711
(479) DESCRIBE `ports` 0.0012979507446289
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00029516220092773
(481) DESCRIBE `ports` 0.0016200542449951
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00032496452331543
(483) DESCRIBE `ports` 0.0012731552124023
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00028395652770996
(485) DESCRIBE `ports` 0.0012989044189453
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00030207633972168
(487) DESCRIBE `ports` 0.0012691020965576
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00027894973754883
(489) DESCRIBE `ports` 0.0013039112091064
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00031399726867676
(491) DESCRIBE `ports` 0.0013298988342285
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00034499168395996
(493) DESCRIBE `ports` 0.0015199184417725
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00040912628173828
(495) DESCRIBE `ports` 0.0013439655303955
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00028610229492188
(497) DESCRIBE `ports` 0.001431941986084
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00040292739868164
(499) DESCRIBE `ports` 0.00130295753479
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00028395652770996
(501) DESCRIBE `ports` 0.0012860298156738
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00030207633972168
(503) DESCRIBE `ports` 0.0014228820800781
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00028800964355469
(505) DESCRIBE `ports` 0.0013630390167236
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00041317939758301
(507) DESCRIBE `ports` 0.0017020702362061
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00029802322387695
(509) DESCRIBE `avid_specials` 0.0011529922485352
(510) 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.0010218620300293
(511) DESCRIBE `cruiselines` 0.0019330978393555
(512) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00031709671020508
(513) DESCRIBE `orchid_image` 0.0014579296112061
(514) DESCRIBE `cruiselines` 0.0018980503082275
(515) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00031900405883789
(516) DESCRIBE `cruises` 0.002608060836792
(517) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45258') 0.00043606758117676
(518) DESCRIBE `ships` 0.0041599273681641
(519) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00045609474182129
(520) DESCRIBE `ships` 0.0029361248016357
(521) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00037503242492676
(522) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00028586387634277
(523) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00025200843811035
(524) DESCRIBE `itineraries` 0.0013890266418457
(525) DESCRIBE `ports` 0.0015628337860107
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00039982795715332
(527) DESCRIBE `ports` 0.0014657974243164
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00036811828613281
(529) DESCRIBE `ports` 0.0019481182098389
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.0003511905670166
(531) DESCRIBE `sailingdates` 0.0020730495452881
(532) DESCRIBE `ports` 0.0018558502197266
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00046801567077637
(534) DESCRIBE `ports` 0.0014989376068115
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00029087066650391
(536) DESCRIBE `ports` 0.0013790130615234
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00031900405883789
(538) DESCRIBE `ports` 0.0012619495391846
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00027084350585938
(540) DESCRIBE `ports` 0.0015320777893066
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00037193298339844
(542) DESCRIBE `ports` 0.0017831325531006
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00034284591674805
(544) DESCRIBE `ports` 0.0013589859008789
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00031805038452148
(546) DESCRIBE `ports` 0.0012578964233398
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00028181076049805
(548) DESCRIBE `ports` 0.0012791156768799
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00037407875061035
(550) DESCRIBE `ports` 0.0013201236724854
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00028395652770996
(552) DESCRIBE `ports` 0.0013999938964844
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.0003058910369873
(554) DESCRIBE `ports` 0.0013420581817627
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00027990341186523
(556) DESCRIBE `ports` 0.0014359951019287
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00031685829162598
(558) DESCRIBE `ports` 0.0013358592987061
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00029516220092773
(560) DESCRIBE `ports` 0.0015101432800293
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00031495094299316
(562) DESCRIBE `ports` 0.0015590190887451
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00028491020202637
(564) DESCRIBE `avid_specials` 0.0011379718780518
(565) 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.0010719299316406
(566) DESCRIBE `cruiselines` 0.0016820430755615
(567) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00035881996154785
(568) DESCRIBE `orchid_image` 0.0017111301422119
(569) DESCRIBE `cruiselines` 0.0018889904022217
(570) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00028705596923828
(571) DESCRIBE `cruises` 0.0025689601898193
(572) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '48299') 0.0004119873046875
(573) DESCRIBE `ships` 0.0035679340362549
(574) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1205))) 0.00050187110900879
(575) DESCRIBE `ships` 0.0026130676269531
(576) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1205') 0.00040984153747559
(577) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00029516220092773
(578) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028109550476074
(579) DESCRIBE `itineraries` 0.0018689632415771
(580) DESCRIBE `ports` 0.0020060539245605
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.0003809928894043
(582) DESCRIBE `ports` 0.0017340183258057
(583) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00045895576477051
(584) DESCRIBE `ports` 0.001194953918457
(585) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00027108192443848
(586) DESCRIBE `sailingdates` 0.0012760162353516
(587) DESCRIBE `ports` 0.0017809867858887
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00035619735717773
(589) DESCRIBE `ports` 0.0013611316680908
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00032305717468262
(591) DESCRIBE `ports` 0.0015921592712402
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00088000297546387
(593) DESCRIBE `ports` 0.00205397605896
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00041794776916504
(595) DESCRIBE `ports` 0.001986026763916
(596) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00043988227844238
(597) DESCRIBE `ports` 0.0019288063049316
(598) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.0003960132598877
(599) DESCRIBE `ports` 0.0019569396972656
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 6.6995620727539E-5
(601) DESCRIBE `ports` 0.0015490055084229
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.00044608116149902
(603) DESCRIBE `ports` 0.0023047924041748
(604) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00052785873413086
(605) DESCRIBE `ports` 0.0021770000457764
(606) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00049209594726562
(607) DESCRIBE `ports` 0.0017600059509277
(608) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00039792060852051
(609) DESCRIBE `ports` 0.0018417835235596
(610) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00041294097900391
(611) DESCRIBE `ports` 0.0018668174743652
(612) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00044989585876465
(613) DESCRIBE `ports` 0.0019509792327881
(614) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00044918060302734
(615) DESCRIBE `ports` 0.0017709732055664
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00047993659973145
(617) DESCRIBE `ports` 0.001917839050293
(618) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00047087669372559
(619) DESCRIBE `ports` 0.0019168853759766
(620) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00058197975158691
(621) DESCRIBE `ports` 0.001986026763916
(622) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00050187110900879
(623) DESCRIBE `ports` 0.00199294090271
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00043296813964844
(625) DESCRIBE `ports` 0.0017189979553223
(626) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00039482116699219
(627) DESCRIBE `avid_specials` 0.0016858577728271
(628) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 48299 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.0013329982757568
(629) DESCRIBE `cruiselines` 0.0023539066314697
(630) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00048589706420898
(631) DESCRIBE `orchid_image` 0.0020999908447266
(632) DESCRIBE `cruiselines` 0.002748966217041
(633) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.0005028247833252
(634) DESCRIBE `cruiselines` 0.002892017364502
(635) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('183', '218', '26', '19', '77', '7', '23', '12', '20', '171', '18', '144', '8', '31', '101', '131', '50', '96', '239', '29', '103', '15', '191', '91', '120', '206', '37', '16', '262', '24', '33', '114', '28', '14', '174', '268', '221', '110', '156', '208', '141', '187', '153', '118', '49', '151', '211', '30', '258', '216', '181', '88', '4', '212', '36', '225', '238', '264', '232', '184', '140', '249', '159', '90', '113', '230', '182', '47', '213', '136', '276', '237', '57', '188', '261', '64', '180', '35', '73', '248', '95', '52', '209', '195', '231', '146', '256', '219', '59', '116', '82', '115', '168', '196', '119', '134', '244', '105', '170', '229', '204', '240', '48', '224')) ORDER BY FIND_IN_SET(id, '183,218,26,19,77,7,23,12,20,171,18,144,8,31,101,131,50,96,239,29,103,15,191,91,120,206,37,16,262,24,33,114,28,14,174,268,221,110,156,208,141,187,153,118,49,151,211,30,258,216,181,88,4,212,36,225,238,264,232,184,140,249,159,90,113,230,182,47,213,136,276,237,57,188,261,64,180,35,73,248,95,52,209,195,231,146,256,219,59,116,82,115,168,196,119,134,244,105,170,229,204,240,48,224') 0.0070278644561768
(636) DESCRIBE `ships` 0.0037398338317871
(637) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '1554', '1555', '1127', '974', '1032', '797', '1292', '1205', '1291', '977', '258', '1199', '1359', '1599', '454', '1272', '404', '780', '855', '1135', '986', '1677', '1067', '1237', '1594', '265', '837', '34', '37', '38', '1607', '21', '22', '27', '378', '461', '1376', '407', '1588', '28', '31', '770', '393', '817', '542', '30', '36', '1012', '39', '1245', '349', '573', '1424', '1552', '35', '1402', '726', '792', '585', '1415', '330', '462', '1422', '66', '113', '882', '1284', '332', '1176', '1744', '1760', '1419', '1423', '1420', '1574', '24', '11', '711', '1405', '1418', '1421', '9', '439', '1215', '455', '10', '434', '766', '1141', '1193', '78', '452', '739', '81', '69', '1572', '1454', '635', '1247', '1372', '3', '1008', '1095', '1682', '674', '124', '1373', '338', '1168', '5', '340', '580', '116', '1319', '43', '335', '553', '850', '1021', '1569', '70', '1302', '1678', '285', '148', '1172', '25', '111', '451', '658', '874', '4', '160', '716', '944', '1260', '253', '348', '390', '1259', '386', '405', '748', '966', '385', '626', '1562', '616', '651', '791', '1108', '1320', '314', '784', '1088', '1323', '1330', '389', '406', '768', '1325', '63', '286', '683', '1645', '508', '582', '590', '749', '970', '1455', '1672', '207', '287', '327', '375', '483', '678', '1587', '119', '526', '1195', '84', '520', '1460', '1575', '108', '559', '722', '854', '1068', '1208', '163', '401', '1398', '394', '657', '1492', '1571', '1586', '1742', '150', '485', '652', '775', '1236', '1266', '1268', '403', '704', '776', '147', '421', '1269', '114', '151', '152', '547', '993', '1064', '1289', '1308', '105', '123', '149', '223', '517', '1321', '325', '262', '715', '883', '954', '958', '1270', '351', '1471', '1711', '45', '1243', '1282', '1389', '1724', '75', '790', '1139', '1143', '1486', '1557', '1601', '1722', '545', '717', '1561', '1717', '441', '1013', '1159', '1526', '1579', '162', '290', '885', '1075', '1151', '1214', '1738', '291', '324', '333', '673', '823', '1326', '1327', '1367', '1437', '1539', '93', '796', '968', '1301', '1303', '98', '205', '516', '1040', '1216', '1318', '1348', '1704', '82', '818', '1540', '1602', '212', '701', '743', '1063', '1218', '1344', '732', '769', '852', '988', '1043', '1137', '1144', '1217', '1343', '1566', '201', '341', '751', '884', '1160', '1409', '1676', '1740', '574', '1163', '1452', '1453', '1604', '14', '266', '795', '1025', '1090', '1136', '1283', '448', '639', '669', '738', '811', '1157', '1241', '1253', '1426', '1449', '1721', '601', '1019', '1223', '1226', '1632', '1766', '467', '905', '1027', '1029', '1152', '1229', '1358', '1411', '1413', '1474', '1716', '997', '1073', '1448', '494', '1150', '1188', '1233', '1345', '1619', '74', '1055', '1322', '1351', '1408', '1647', '1663', '1673', '1713', '1715', '417', '709', '836', '996', '1026', '1047', '1145', '1410', '1458', '1496', '1714', '610', '618', '643', '1580', '1743', '208', '423', '453', '521', '888', '973', '1034', '1149', '1231', '1366', '1404', '1489', '1505', '1609', '666', '851', '1037', '1049', '1187', '1196', '1222', '1360', '1361', '1362', '1368', '1407', '1459', '1470', '1516', '352', '920', '921', '927', '931', '1004', '1017', '1042', '1140', '1154', '1230', '1354', '1444', '1508', '1606', '1627', '1649', '493', '499', '663', '914', '923', '1106', '1517', '1518', '1567', '703', '915', '916', '926', '930', '1003', '1072', '1138', '1262', '1708', '1751', '479', '665', '781', '924', '972', '1001', '1020', '1052', '1175', '1352', '1412', '1463', '1521', '1522', '1593', '1596', '1723', '422', '671', '938', '1005', '1045', '1053', '1054', '1091', '1092', '1254', '1285', '1729', '937', '1051', '1445', '1650', '1681', '1684', '672', '1514', '1679', '1697', '504')) ORDER BY FIND_IN_SET(id, '1761,1554,1555,1127,974,1032,797,1292,1205,1291,977,258,1199,1359,1599,454,1272,404,780,855,1135,986,1677,1067,1237,1594,265,837,34,37,38,1607,21,22,27,378,461,1376,407,1588,28,31,770,393,817,542,30,36,1012,39,1245,349,573,1424,1552,35,1402,726,792,585,1415,330,462,1422,66,113,882,1284,332,1176,1744,1760,1419,1423,1420,1574,24,11,711,1405,1418,1421,9,439,1215,455,10,434,766,1141,1193,78,452,739,81,69,1572,1454,635,1247,1372,3,1008,1095,1682,674,124,1373,338,1168,5,340,580,116,1319,43,335,553,850,1021,1569,70,1302,1678,285,148,1172,25,111,451,658,874,4,160,716,944,1260,253,348,390,1259,386,405,748,966,385,626,1562,616,651,791,1108,1320,314,784,1088,1323,1330,389,406,768,1325,63,286,683,1645,508,582,590,749,970,1455,1672,207,287,327,375,483,678,1587,119,526,1195,84,520,1460,1575,108,559,722,854,1068,1208,163,401,1398,394,657,1492,1571,1586,1742,150,485,652,775,1236,1266,1268,403,704,776,147,421,1269,114,151,152,547,993,1064,1289,1308,105,123,149,223,517,1321,325,262,715,883,954,958,1270,351,1471,1711,45,1243,1282,1389,1724,75,790,1139,1143,1486,1557,1601,1722,545,717,1561,1717,441,1013,1159,1526,1579,162,290,885,1075,1151,1214,1738,291,324,333,673,823,1326,1327,1367,1437,1539,93,796,968,1301,1303,98,205,516,1040,1216,1318,1348,1704,82,818,1540,1602,212,701,743,1063,1218,1344,732,769,852,988,1043,1137,1144,1217,1343,1566,201,341,751,884,1160,1409,1676,1740,574,1163,1452,1453,1604,14,266,795,1025,1090,1136,1283,448,639,669,738,811,1157,1241,1253,1426,1449,1721,601,1019,1223,1226,1632,1766,467,905,1027,1029,1152,1229,1358,1411,1413,1474,1716,997,1073,1448,494,1150,1188,1233,1345,1619,74,1055,1322,1351,1408,1647,1663,1673,1713,1715,417,709,836,996,1026,1047,1145,1410,1458,1496,1714,610,618,643,1580,1743,208,423,453,521,888,973,1034,1149,1231,1366,1404,1489,1505,1609,666,851,1037,1049,1187,1196,1222,1360,1361,1362,1368,1407,1459,1470,1516,352,920,921,927,931,1004,1017,1042,1140,1154,1230,1354,1444,1508,1606,1627,1649,493,499,663,914,923,1106,1517,1518,1567,703,915,916,926,930,1003,1072,1138,1262,1708,1751,479,665,781,924,972,1001,1020,1052,1175,1352,1412,1463,1521,1522,1593,1596,1723,422,671,938,1005,1045,1053,1054,1091,1092,1254,1285,1729,937,1051,1445,1650,1681,1684,672,1514,1679,1697,504') 0.045375823974609
(638) DESCRIBE `cruisetypes` 0.002051830291748
(639) DESCRIBE `destinations` 0.0025489330291748
(640) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '35', '22', '54', '25', '37', '9', '43', '2', '8', '53', '39', '55', '28', '26', '38', '40', '7', '30', '48', '21', '11', '49', '29', '45', '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,55,28,26,38,40,7,30,48,21,11,49,29,45,44,56,10,34,52,32,46') 0.0025529861450195