or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. 8 Romantic Destinations Around the World
  3. Royal Caribbean Launch “Royal Up”
  4. Catch Up on Cruising: Latest News in bite size!
  5. Drinks Package Comparison

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

Total elapsed time: 1.8423025608063

# Query Time
(1) connect 0.0014171600341797
(2) DESCRIBE `cruises` 0.0042989253997803
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (75542, 75543, 75544, 75545, 68724, 75546, 68726, 75547, 68727, 75548)) ORDER BY FIND_IN_SET(id, '75542,75543,75544,75545,68724,75546,68726,75547,68727,75548') 0.0024499893188477
(4) DESCRIBE `cruises` 0.055917024612427
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75542') 0.00058412551879883
(6) DESCRIBE `ships` 0.0041790008544922
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00084304809570312
(8) DESCRIBE `ships` 0.0040960311889648
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00049710273742676
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034403800964355
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003359317779541
(12) DESCRIBE `itineraries` 0.0021059513092041
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75542') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010659694671631
(14) DESCRIBE `ports` 0.002791166305542
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00046706199645996
(16) DESCRIBE `ports` 0.0022628307342529
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.0004429817199707
(18) DESCRIBE `ports` 0.002202033996582
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00040197372436523
(20) DESCRIBE `sailingdates` 0.00187087059021
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75542') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010640621185303
(22) DESCRIBE `ports` 0.002708911895752
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.0005037784576416
(24) DESCRIBE `ports` 0.0019638538360596
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00047492980957031
(26) DESCRIBE `ports` 0.0019338130950928
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00042390823364258
(28) DESCRIBE `ports` 0.0019330978393555
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00041317939758301
(30) DESCRIBE `ports` 0.0019569396972656
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.00047683715820312
(32) DESCRIBE `ports` 0.0041790008544922
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.0025570392608643
(34) DESCRIBE `ports` 0.01519513130188
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00057196617126465
(36) DESCRIBE `ports` 0.0020980834960938
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00054001808166504
(38) DESCRIBE `ports` 0.0021419525146484
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 696))) 0.00046992301940918
(40) DESCRIBE `ports` 0.0062670707702637
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '696') 0.0004889965057373
(42) DESCRIBE `ports` 0.0020971298217773
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00053095817565918
(44) DESCRIBE `ports` 0.0021228790283203
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00046491622924805
(46) DESCRIBE `ports` 0.0038771629333496
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.0005650520324707
(48) DESCRIBE `ports` 0.0021219253540039
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00059008598327637
(50) DESCRIBE `ports` 0.0022099018096924
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00055098533630371
(52) DESCRIBE `ports` 0.0020458698272705
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00043296813964844
(54) DESCRIBE `avid_specials` 0.0019118785858154
(55) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75542 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017309188842773
(56) DESCRIBE `cruiselines` 0.0070450305938721
(57) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00050997734069824
(58) DESCRIBE `orchid_image` 0.0023999214172363
(59) DESCRIBE `cruiselines` 0.0031449794769287
(60) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00046396255493164
(61) DESCRIBE `cruises` 0.044245004653931
(62) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75543') 0.00049495697021484
(63) DESCRIBE `ships` 0.0036458969116211
(64) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00044512748718262
(65) DESCRIBE `ships` 0.0046238899230957
(66) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00048613548278809
(67) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035881996154785
(68) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032591819763184
(69) DESCRIBE `itineraries` 0.0027010440826416
(70) DESCRIBE `ports` 0.0023939609527588
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00043511390686035
(72) DESCRIBE `ports` 0.0018279552459717
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00039196014404297
(74) DESCRIBE `ports` 0.011808156967163
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00048398971557617
(76) DESCRIBE `sailingdates` 0.0074570178985596
(77) DESCRIBE `ports` 0.01233696937561
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00047993659973145
(79) DESCRIBE `ports` 0.0018038749694824
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00088191032409668
(81) DESCRIBE `ports` 0.0019299983978271
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 909))) 0.00041985511779785
(83) DESCRIBE `ports` 0.001823902130127
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '909') 0.00040602684020996
(85) DESCRIBE `ports` 0.0018270015716553
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00061321258544922
(87) DESCRIBE `ports` 0.0018289089202881
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00042200088500977
(89) DESCRIBE `ports` 0.0018470287322998
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00045299530029297
(91) DESCRIBE `ports` 0.00187087059021
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00069499015808105
(93) DESCRIBE `ports` 0.0022339820861816
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 910))) 0.00043511390686035
(95) DESCRIBE `ports` 0.0026488304138184
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '910') 0.00042295455932617
(97) DESCRIBE `ports` 0.0024709701538086
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1709))) 0.00042891502380371
(99) DESCRIBE `ports` 0.0029420852661133
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1709') 0.0037930011749268
(101) DESCRIBE `ports` 0.017843961715698
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 578))) 0.00193190574646
(103) DESCRIBE `ports` 0.0019998550415039
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '578') 0.0025269985198975
(105) DESCRIBE `ports` 0.017899036407471
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.0004429817199707
(107) DESCRIBE `ports` 0.0030031204223633
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.0003659725189209
(109) DESCRIBE `ports` 0.0032329559326172
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00054192543029785
(111) DESCRIBE `ports` 0.0023770332336426
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00052905082702637
(113) DESCRIBE `ports` 0.004040002822876
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00048303604125977
(115) DESCRIBE `ports` 0.003197193145752
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00054121017456055
(117) DESCRIBE `avid_specials` 0.0019659996032715
(118) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75543 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018689632415771
(119) DESCRIBE `cruiselines` 0.0033338069915771
(120) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00046586990356445
(121) DESCRIBE `orchid_image` 0.0025820732116699
(122) DESCRIBE `cruiselines` 0.0028860569000244
(123) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00064897537231445
(124) DESCRIBE `cruises` 0.0042781829833984
(125) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75544') 0.00060701370239258
(126) DESCRIBE `ships` 0.0040090084075928
(127) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00054192543029785
(128) DESCRIBE `ships` 0.012819051742554
(129) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00054287910461426
(130) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036811828613281
(131) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030303001403809
(132) DESCRIBE `itineraries` 0.0018579959869385
(133) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75544') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00080108642578125
(134) DESCRIBE `ports` 0.0023200511932373
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00046896934509277
(136) DESCRIBE `ports` 0.0019700527191162
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00048089027404785
(138) DESCRIBE `ports` 0.022849082946777
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00065088272094727
(140) DESCRIBE `sailingdates` 0.0018789768218994
(141) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75544') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00079512596130371
(142) DESCRIBE `ports` 0.0091559886932373
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00051999092102051
(144) DESCRIBE `ports` 0.0037398338317871
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00046110153198242
(146) DESCRIBE `ports` 0.020808935165405
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 579))) 0.0015439987182617
(148) DESCRIBE `ports` 0.010427951812744
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '579') 0.00070309638977051
(150) DESCRIBE `ports` 0.0068080425262451
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 584))) 0.00087904930114746
(152) DESCRIBE `ports` 0.0036721229553223
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '584') 0.00043082237243652
(154) DESCRIBE `ports` 0.0030930042266846
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00060606002807617
(156) DESCRIBE `ports` 0.002424955368042
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00049996376037598
(158) DESCRIBE `ports` 0.010447978973389
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00060009956359863
(160) DESCRIBE `ports` 0.0019941329956055
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00044894218444824
(162) DESCRIBE `ports` 0.0035388469696045
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1119))) 0.00049185752868652
(164) DESCRIBE `ports` 0.0032041072845459
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1119') 0.00049304962158203
(166) DESCRIBE `ports` 0.0020310878753662
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 697))) 0.00047898292541504
(168) DESCRIBE `ports` 0.0021610260009766
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '697') 0.00045895576477051
(170) DESCRIBE `ports` 0.0022649765014648
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00048398971557617
(172) DESCRIBE `ports` 0.002593994140625
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00059700012207031
(174) DESCRIBE `avid_specials` 0.0050411224365234
(175) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75544 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0021870136260986
(176) DESCRIBE `cruiselines` 0.0039961338043213
(177) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00052595138549805
(178) DESCRIBE `orchid_image` 0.0023469924926758
(179) DESCRIBE `cruiselines` 0.0062260627746582
(180) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.0010480880737305
(181) DESCRIBE `cruises` 0.0039608478546143
(182) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75545') 0.00047206878662109
(183) DESCRIBE `ships` 0.0040280818939209
(184) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00053906440734863
(185) DESCRIBE `ships` 0.0043301582336426
(186) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00048398971557617
(187) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036096572875977
(188) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034594535827637
(189) DESCRIBE `itineraries` 0.0040638446807861
(190) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75545') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00081801414489746
(191) DESCRIBE `ports` 0.0025231838226318
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00062990188598633
(193) DESCRIBE `ports` 0.0038998126983643
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00087499618530273
(195) DESCRIBE `ports` 0.0040328502655029
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0061149597167969
(197) DESCRIBE `sailingdates` 0.006807804107666
(198) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75545') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00079679489135742
(199) DESCRIBE `ports` 0.0021171569824219
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0025749206542969
(201) DESCRIBE `ports` 0.0035510063171387
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00050115585327148
(203) DESCRIBE `ports` 0.0027680397033691
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1252))) 0.00051498413085938
(205) DESCRIBE `ports` 0.0053091049194336
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1252') 0.00062298774719238
(207) DESCRIBE `ports` 0.0021309852600098
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00045204162597656
(209) DESCRIBE `ports` 0.002683162689209
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00041985511779785
(211) DESCRIBE `ports` 0.0019218921661377
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1191))) 0.00044584274291992
(213) DESCRIBE `ports` 0.0022099018096924
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1191') 0.00048518180847168
(215) DESCRIBE `ports` 0.0020840167999268
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1622))) 0.00048303604125977
(217) DESCRIBE `ports` 0.0020780563354492
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1622') 0.00045108795166016
(219) DESCRIBE `ports` 0.0018970966339111
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00052618980407715
(221) DESCRIBE `ports` 0.0020039081573486
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00044417381286621
(223) DESCRIBE `ports` 0.0019700527191162
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2081))) 0.00049805641174316
(225) DESCRIBE `ports` 0.0020639896392822
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2081') 0.00043892860412598
(227) DESCRIBE `ports` 0.0019509792327881
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00052309036254883
(229) DESCRIBE `ports` 0.0020489692687988
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00039792060852051
(231) DESCRIBE `ports` 0.0021991729736328
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00051379203796387
(233) DESCRIBE `ports` 0.0021400451660156
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00090289115905762
(235) DESCRIBE `avid_specials` 0.002467155456543
(236) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75545 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0020818710327148
(237) DESCRIBE `cruiselines` 0.0040068626403809
(238) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00051712989807129
(239) DESCRIBE `orchid_image` 0.0021419525146484
(240) DESCRIBE `cruiselines` 0.0028069019317627
(241) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00047397613525391
(242) DESCRIBE `cruises` 0.0038571357727051
(243) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68724') 0.00052285194396973
(244) DESCRIBE `ships` 0.0060908794403076
(245) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.000579833984375
(246) DESCRIBE `ships` 0.0040130615234375
(247) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.0005650520324707
(248) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035214424133301
(249) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034403800964355
(250) DESCRIBE `itineraries` 0.0060861110687256
(251) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68724') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.001176118850708
(252) DESCRIBE `ports` 0.0056240558624268
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00054097175598145
(254) DESCRIBE `ports` 0.0019659996032715
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00075387954711914
(256) DESCRIBE `ports` 0.0083470344543457
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.002392053604126
(258) DESCRIBE `sailingdates` 0.0069761276245117
(259) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68724') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010960102081299
(260) DESCRIBE `ports` 0.0054728984832764
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00061893463134766
(262) DESCRIBE `ports` 0.0022690296173096
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00048589706420898
(264) DESCRIBE `ports` 0.0025780200958252
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1878))) 0.00053501129150391
(266) DESCRIBE `ports` 0.0020420551300049
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1878') 0.00046801567077637
(268) DESCRIBE `ports` 0.0041801929473877
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00062298774719238
(270) DESCRIBE `ports` 0.011209964752197
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.0036649703979492
(272) DESCRIBE `ports` 0.0058078765869141
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.01664400100708
(274) DESCRIBE `ports` 0.0040888786315918
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00054001808166504
(276) DESCRIBE `ports` 0.014487028121948
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00060606002807617
(278) DESCRIBE `ports` 0.0024681091308594
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00048184394836426
(280) DESCRIBE `ports` 0.0020978450775146
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00051283836364746
(282) DESCRIBE `ports` 0.0020840167999268
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00051093101501465
(284) DESCRIBE `ports` 0.0022311210632324
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.0009310245513916
(286) DESCRIBE `ports` 0.002108097076416
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00076603889465332
(288) DESCRIBE `ports` 0.0022280216217041
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00049304962158203
(290) DESCRIBE `ports` 0.001615047454834
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00042009353637695
(292) DESCRIBE `ports` 0.0019190311431885
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00098013877868652
(294) DESCRIBE `ports` 0.0021400451660156
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00061821937561035
(296) DESCRIBE `avid_specials` 0.0051960945129395
(297) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68724 and class = 'Cruise') OR (item_id = 616 AND class = 'Ship') OR (item_id = 151 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0028038024902344
(298) DESCRIBE `cruiselines` 0.0045089721679688
(299) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00059795379638672
(300) DESCRIBE `orchid_image` 0.003911018371582
(301) DESCRIBE `cruiselines` 0.0058951377868652
(302) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00050616264343262
(303) DESCRIBE `cruises` 0.0040130615234375
(304) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75546') 0.00736403465271
(305) DESCRIBE `ships` 0.0072240829467773
(306) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.0018210411071777
(307) DESCRIBE `ships` 0.0040111541748047
(308) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00082802772521973
(309) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00039911270141602
(310) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033092498779297
(311) DESCRIBE `itineraries` 0.0020852088928223
(312) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75546') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00086092948913574
(313) DESCRIBE `ports` 0.0037679672241211
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00053501129150391
(315) DESCRIBE `ports` 0.0029408931732178
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00054311752319336
(317) DESCRIBE `ports` 0.0023961067199707
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00040602684020996
(319) DESCRIBE `sailingdates` 0.0016889572143555
(320) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75546') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00069284439086914
(321) DESCRIBE `ports` 0.0019841194152832
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00041580200195312
(323) DESCRIBE `ports` 0.0044620037078857
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00069808959960938
(325) DESCRIBE `ports` 0.006680965423584
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.001230001449585
(327) DESCRIBE `ports` 0.0031180381774902
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00043892860412598
(329) DESCRIBE `ports` 0.0052468776702881
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2565))) 0.0012960433959961
(331) DESCRIBE `ports` 0.0026228427886963
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2565') 0.00094985961914062
(333) DESCRIBE `ports` 0.0047628879547119
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.0047199726104736
(335) DESCRIBE `ports` 0.0021600723266602
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00045895576477051
(337) DESCRIBE `ports` 0.0019121170043945
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00053501129150391
(339) DESCRIBE `ports` 0.011215925216675
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0004889965057373
(341) DESCRIBE `ports` 0.0023820400238037
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.0011060237884521
(343) DESCRIBE `ports` 0.01145601272583
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.02268385887146
(345) DESCRIBE `ports` 0.0037460327148438
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4120))) 0.00051498413085938
(347) DESCRIBE `ports` 0.0018861293792725
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4120') 0.00034499168395996
(349) DESCRIBE `ports` 0.0019900798797607
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.0004730224609375
(351) DESCRIBE `ports` 0.0020678043365479
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00047802925109863
(353) DESCRIBE `ports` 0.0020711421966553
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2476))) 0.00037693977355957
(355) DESCRIBE `ports` 0.0022120475769043
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2476') 0.00051283836364746
(357) DESCRIBE `ports` 0.0024030208587646
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00047397613525391
(359) DESCRIBE `ports` 0.013782978057861
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00066399574279785
(361) DESCRIBE `avid_specials` 0.0054559707641602
(362) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75546 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0019330978393555
(363) DESCRIBE `cruiselines` 0.004878044128418
(364) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.0013201236724854
(365) DESCRIBE `orchid_image` 0.016748905181885
(366) DESCRIBE `cruiselines` 0.0031251907348633
(367) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00078797340393066
(368) DESCRIBE `cruises` 0.0037539005279541
(369) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68726') 0.0006260871887207
(370) DESCRIBE `ships` 0.0072228908538818
(371) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00066089630126953
(372) DESCRIBE `ships` 0.0052750110626221
(373) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.00055098533630371
(374) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003359317779541
(375) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035500526428223
(376) DESCRIBE `itineraries` 0.0025639533996582
(377) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68726') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00097513198852539
(378) DESCRIBE `ports` 0.0028278827667236
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00055599212646484
(380) DESCRIBE `ports` 0.0033810138702393
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0005190372467041
(382) DESCRIBE `ports` 0.0021800994873047
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00045585632324219
(384) DESCRIBE `sailingdates` 0.0033009052276611
(385) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68726') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0007932186126709
(386) DESCRIBE `ports` 0.0020129680633545
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0004279613494873
(388) DESCRIBE `ports` 0.0042610168457031
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00048303604125977
(390) DESCRIBE `ports` 0.0021440982818604
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00056886672973633
(392) DESCRIBE `ports` 0.0021669864654541
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00105881690979
(394) DESCRIBE `ports` 0.0064499378204346
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00067496299743652
(396) DESCRIBE `ports` 0.00341796875
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00052714347839355
(398) DESCRIBE `ports` 0.0020999908447266
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1709))) 0.00049805641174316
(400) DESCRIBE `ports` 0.0031869411468506
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1709') 0.00056695938110352
(402) DESCRIBE `ports` 0.0024120807647705
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00051212310791016
(404) DESCRIBE `ports` 0.0033547878265381
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.0012140274047852
(406) DESCRIBE `ports` 0.0023307800292969
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.010812997817993
(408) DESCRIBE `ports` 0.023078918457031
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00049400329589844
(410) DESCRIBE `ports` 0.016538858413696
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 579))) 0.00062108039855957
(412) DESCRIBE `ports` 0.0077102184295654
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '579') 0.00041913986206055
(414) DESCRIBE `ports` 0.0087759494781494
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0010631084442139
(416) DESCRIBE `ports` 0.0028200149536133
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00045895576477051
(418) DESCRIBE `avid_specials` 0.014276027679443
(419) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68726 and class = 'Cruise') OR (item_id = 616 AND class = 'Ship') OR (item_id = 151 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0031189918518066
(420) DESCRIBE `cruiselines` 0.0051829814910889
(421) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00049495697021484
(422) DESCRIBE `orchid_image` 0.011485815048218
(423) DESCRIBE `cruiselines` 0.010150909423828
(424) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00054001808166504
(425) DESCRIBE `cruises` 0.0039529800415039
(426) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75547') 0.00044107437133789
(427) DESCRIBE `ships` 0.0078001022338867
(428) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00055098533630371
(429) DESCRIBE `ships` 0.0046250820159912
(430) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00057601928710938
(431) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035500526428223
(432) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0023031234741211
(433) DESCRIBE `itineraries` 0.0024731159210205
(434) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75547') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00079822540283203
(435) DESCRIBE `ports` 0.0024139881134033
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0005040168762207
(437) DESCRIBE `ports` 0.0046868324279785
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00054788589477539
(439) DESCRIBE `ports` 0.0037941932678223
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00043106079101562
(441) DESCRIBE `sailingdates` 0.003619909286499
(442) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75547') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00099492073059082
(443) DESCRIBE `ports` 0.0024561882019043
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00074315071105957
(445) DESCRIBE `ports` 0.0021770000457764
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0004889965057373
(447) DESCRIBE `ports` 0.0073831081390381
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00094103813171387
(449) DESCRIBE `ports` 0.0029940605163574
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.0003809928894043
(451) DESCRIBE `ports` 0.0069980621337891
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.0010299682617188
(453) DESCRIBE `ports` 0.0030529499053955
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00047492980957031
(455) DESCRIBE `ports` 0.0021829605102539
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3963))) 0.00057196617126465
(457) DESCRIBE `ports` 0.001986026763916
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3963') 0.00044798851013184
(459) DESCRIBE `ports` 0.0020558834075928
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00049901008605957
(461) DESCRIBE `ports` 0.0021238327026367
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00057601928710938
(463) DESCRIBE `ports` 0.0020749568939209
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00043416023254395
(465) DESCRIBE `ports` 0.0020079612731934
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00037598609924316
(467) DESCRIBE `ports` 0.0019080638885498
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00043320655822754
(469) DESCRIBE `ports` 0.0020089149475098
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00037693977355957
(471) DESCRIBE `ports` 0.0019369125366211
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00041699409484863
(473) DESCRIBE `ports` 0.0019791126251221
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00034093856811523
(475) DESCRIBE `ports` 0.0019280910491943
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00041103363037109
(477) DESCRIBE `ports` 0.0019140243530273
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.00039196014404297
(479) DESCRIBE `avid_specials` 0.0016961097717285
(480) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75547 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018749237060547
(481) DESCRIBE `cruiselines` 0.0049171447753906
(482) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00071501731872559
(483) DESCRIBE `orchid_image` 0.0025300979614258
(484) DESCRIBE `cruiselines` 0.0052340030670166
(485) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00036311149597168
(486) DESCRIBE `cruises` 0.0066738128662109
(487) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68727') 0.0005800724029541
(488) DESCRIBE `ships` 0.0061981678009033
(489) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00081992149353027
(490) DESCRIBE `ships` 0.007681131362915
(491) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.0022430419921875
(492) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0015580654144287
(493) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0066001415252686
(494) DESCRIBE `itineraries` 0.021899223327637
(495) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68727') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0019152164459229
(496) DESCRIBE `ports` 0.013608932495117
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00058388710021973
(498) DESCRIBE `ports` 0.0058529376983643
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.078115940093994
(500) DESCRIBE `ports` 0.0025548934936523
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00055098533630371
(502) DESCRIBE `sailingdates` 0.0045511722564697
(503) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68727') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00081396102905273
(504) DESCRIBE `ports` 0.0022540092468262
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00056695938110352
(506) DESCRIBE `ports` 0.002241849899292
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00041794776916504
(508) DESCRIBE `ports` 0.0026760101318359
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00074505805969238
(510) DESCRIBE `ports` 0.001896858215332
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00048494338989258
(512) DESCRIBE `ports` 0.0019259452819824
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1119))) 0.00051093101501465
(514) DESCRIBE `ports` 0.006148099899292
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1119') 0.0014939308166504
(516) DESCRIBE `ports` 0.0019052028656006
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00056290626525879
(518) DESCRIBE `ports` 0.0019550323486328
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00066900253295898
(520) DESCRIBE `ports` 0.0024540424346924
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.0006709098815918
(522) DESCRIBE `ports` 0.001945972442627
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00047492980957031
(524) DESCRIBE `ports` 0.0018858909606934
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00049209594726562
(526) DESCRIBE `ports` 0.0018439292907715
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.0003821849822998
(528) DESCRIBE `ports` 0.0025811195373535
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 578))) 0.00049495697021484
(530) DESCRIBE `ports` 0.0018620491027832
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '578') 0.00043106079101562
(532) DESCRIBE `ports` 0.0018570423126221
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00044608116149902
(534) DESCRIBE `ports` 0.011996030807495
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00063109397888184
(536) DESCRIBE `ports` 0.0023870468139648
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00050115585327148
(538) DESCRIBE `ports` 0.0028090476989746
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00048995018005371
(540) DESCRIBE `ports` 0.0019919872283936
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00045514106750488
(542) DESCRIBE `ports` 0.0018379688262939
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00051093101501465
(544) DESCRIBE `ports` 0.0023159980773926
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00051999092102051
(546) DESCRIBE `ports` 0.0019187927246094
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00045204162597656
(548) DESCRIBE `avid_specials` 0.0022730827331543
(549) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68727 and class = 'Cruise') OR (item_id = 616 AND class = 'Ship') OR (item_id = 151 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0029950141906738
(550) DESCRIBE `cruiselines` 0.0030560493469238
(551) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00061702728271484
(552) DESCRIBE `orchid_image` 0.0091559886932373
(553) DESCRIBE `cruiselines` 0.0029420852661133
(554) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00051307678222656
(555) DESCRIBE `cruises` 0.0038700103759766
(556) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75548') 0.0005190372467041
(557) DESCRIBE `ships` 0.003835916519165
(558) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00076508522033691
(559) DESCRIBE `ships` 0.0045709609985352
(560) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00064802169799805
(561) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032711029052734
(562) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003058910369873
(563) DESCRIBE `itineraries` 0.002025842666626
(564) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75548') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00078082084655762
(565) DESCRIBE `ports` 0.0022339820861816
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.012716054916382
(567) DESCRIBE `ports` 0.0081958770751953
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.0073530673980713
(569) DESCRIBE `ports` 0.0070400238037109
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.00055694580078125
(571) DESCRIBE `sailingdates` 0.023361921310425
(572) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75548') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00872802734375
(573) DESCRIBE `ports` 0.002331018447876
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00059199333190918
(575) DESCRIBE `ports` 0.0021119117736816
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.00047707557678223
(577) DESCRIBE `ports` 0.0020968914031982
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.0005030632019043
(579) DESCRIBE `ports` 0.0022580623626709
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00056290626525879
(581) DESCRIBE `ports` 0.0022110939025879
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1709))) 0.00065994262695312
(583) DESCRIBE `ports` 0.0033278465270996
(584) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1709') 0.00047183036804199
(585) DESCRIBE `ports` 0.0025179386138916
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00047898292541504
(587) DESCRIBE `ports` 0.0019919872283936
(588) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.00055694580078125
(589) DESCRIBE `ports` 0.0020821094512939
(590) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2171))) 0.00046110153198242
(591) DESCRIBE `ports` 0.0020718574523926
(592) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2171') 0.00043320655822754
(593) DESCRIBE `ports` 0.0038537979125977
(594) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00047779083251953
(595) DESCRIBE `ports` 0.0021669864654541
(596) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00058293342590332
(597) DESCRIBE `avid_specials` 0.001849889755249
(598) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75548 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018980503082275
(599) DESCRIBE `cruiselines` 0.0036890506744385
(600) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00071597099304199
(601) DESCRIBE `orchid_image` 0.01067590713501
(602) DESCRIBE `cruiselines` 0.0049948692321777
(603) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.0005340576171875
(604) DESCRIBE `ships` 0.013605117797852
(605) SELECT `ships`.* FROM `ships` WHERE (id IN ('1672', '616', '652')) ORDER BY FIND_IN_SET(id, '1672,616,652') 0.00083804130554199
(606) DESCRIBE `cruisetypes` 0.0016870498657227
(607) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruises_and_specials.destination_id = '22') AND (cruises_and_specials.cruiseline_id = '151') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.052582025527954
(608) DESCRIBE `cruiselines` 0.0035059452056885
(609) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00060510635375977
(610) DESCRIBE `destinations` 0.0025291442871094
(611) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 22))) 0.0005040168762207
(612) DESCRIBE `destinations` 0.0025749206542969
(613) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 22))) 0.00057196617126465
(614) DESCRIBE `cruiselines` 0.0030601024627686
(615) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00057888031005859