or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Cruise Ship Lingo? Look like a cruise expert before you get on the ship
  3. BREAKING NEWS FOR PRINCESS FANS: Register your interest now!!!
  4. Catch Up on Cruising: Latest News in bite size!
  5. Review: China – Part Two

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

Total elapsed time: 0.70449471473694

# Query Time
(1) connect 0.00082588195800781
(2) DESCRIBE `cruises` 0.0036799907684326
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (52467, 52584, 56791, 57979, 57981, 59379, 74537, 75766, 59442, 59758)) ORDER BY FIND_IN_SET(id, '52467,52584,56791,57979,57981,59379,74537,75766,59442,59758') 0.0022811889648438
(4) DESCRIBE `cruises` 0.0032601356506348
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52467') 0.00040602684020996
(6) DESCRIBE `ships` 0.0030250549316406
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 970))) 0.00054097175598145
(8) DESCRIBE `ships` 0.0035390853881836
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '970') 0.00044608116149902
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031685829162598
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032401084899902
(12) DESCRIBE `itineraries` 0.0018510818481445
(13) DESCRIBE `ports` 0.0020699501037598
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00043988227844238
(15) DESCRIBE `ports` 0.0015840530395508
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00032401084899902
(17) DESCRIBE `ports` 0.001352071762085
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00028109550476074
(19) DESCRIBE `sailingdates` 0.0016279220581055
(20) DESCRIBE `ports` 0.0019090175628662
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00042605400085449
(22) DESCRIBE `ports` 0.0014369487762451
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.0003049373626709
(24) DESCRIBE `ports` 0.0013279914855957
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00030803680419922
(26) DESCRIBE `ports` 0.001331090927124
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00032496452331543
(28) DESCRIBE `ports` 0.0018348693847656
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00039911270141602
(30) DESCRIBE `ports` 0.0016608238220215
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00034499168395996
(32) DESCRIBE `ports` 0.0016889572143555
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00040197372436523
(34) DESCRIBE `ports` 0.0015938282012939
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00034308433532715
(36) DESCRIBE `ports` 0.0016210079193115
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00036001205444336
(38) DESCRIBE `ports` 0.0016889572143555
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00035500526428223
(40) DESCRIBE `ports` 0.0017001628875732
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00040793418884277
(42) DESCRIBE `ports` 0.001755952835083
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.0003669261932373
(44) DESCRIBE `avid_specials` 0.0015630722045898
(45) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 52467 and class = 'Cruise') OR (item_id = 970 AND class = 'Ship') OR (item_id = 218 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.0018658638000488
(46) DESCRIBE `cruiselines` 0.0025711059570312
(47) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00043511390686035
(48) DESCRIBE `orchid_image` 0.0019769668579102
(49) DESCRIBE `cruiselines` 0.0024569034576416
(50) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00040698051452637
(51) DESCRIBE `cruises` 0.0033960342407227
(52) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52584') 0.00050806999206543
(53) DESCRIBE `ships` 0.0034730434417725
(54) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 582))) 0.00051689147949219
(55) DESCRIBE `ships` 0.0032188892364502
(56) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '582') 0.00041913986206055
(57) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031399726867676
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030612945556641
(59) DESCRIBE `itineraries` 0.0016508102416992
(60) DESCRIBE `ports` 0.0016658306121826
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00045394897460938
(62) DESCRIBE `ports` 0.0016639232635498
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00037407875061035
(64) DESCRIBE `ports` 0.0017640590667725
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00038599967956543
(66) DESCRIBE `sailingdates` 0.0015051364898682
(67) DESCRIBE `ports` 0.0018579959869385
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00046896934509277
(69) DESCRIBE `ports` 0.0016720294952393
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00037121772766113
(71) DESCRIBE `ports` 0.0016970634460449
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00040292739868164
(73) DESCRIBE `ports` 0.0016920566558838
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00035309791564941
(75) DESCRIBE `ports` 0.0013859272003174
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 327))) 0.00030803680419922
(77) DESCRIBE `ports` 0.0013420581817627
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '327') 0.00031399726867676
(79) DESCRIBE `ports` 0.0014128684997559
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00030899047851562
(81) DESCRIBE `ports` 0.0014410018920898
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00036811828613281
(83) DESCRIBE `ports` 0.0014641284942627
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00060606002807617
(85) DESCRIBE `ports` 0.0018939971923828
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.0004279613494873
(87) DESCRIBE `avid_specials` 0.0015308856964111
(88) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 52584 and class = 'Cruise') OR (item_id = 582 AND class = 'Ship') OR (item_id = 218 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.0017499923706055
(89) DESCRIBE `cruiselines` 0.0027220249176025
(90) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00047802925109863
(91) DESCRIBE `orchid_image` 0.0020229816436768
(92) DESCRIBE `cruiselines` 0.0026161670684814
(93) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00043606758117676
(94) DESCRIBE `cruises` 0.0035929679870605
(95) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56791') 0.00049185752868652
(96) DESCRIBE `ships` 0.0033679008483887
(97) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 390))) 0.00048208236694336
(98) DESCRIBE `ships` 0.0032551288604736
(99) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '390') 0.00048995018005371
(100) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00045490264892578
(101) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028300285339355
(102) DESCRIBE `itineraries` 0.0015389919281006
(103) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '56791') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00081205368041992
(104) DESCRIBE `ports` 0.0013449192047119
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00033020973205566
(106) DESCRIBE `ports` 0.0012710094451904
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00030112266540527
(108) DESCRIBE `ports` 0.0014619827270508
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00037002563476562
(110) DESCRIBE `sailingdates` 0.0013868808746338
(111) DESCRIBE `ports` 0.0014700889587402
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00042915344238281
(113) DESCRIBE `ports` 0.0013530254364014
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00034618377685547
(115) DESCRIBE `ports` 0.0013041496276855
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00031280517578125
(117) DESCRIBE `ports` 0.0012991428375244
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.0003809928894043
(119) DESCRIBE `ports` 0.0018348693847656
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.0004279613494873
(121) DESCRIBE `ports` 0.0017998218536377
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00037908554077148
(123) DESCRIBE `ports` 0.0017800331115723
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00041294097900391
(125) DESCRIBE `ports` 0.0017459392547607
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00045394897460938
(127) DESCRIBE `ports` 0.0017261505126953
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00030994415283203
(129) DESCRIBE `ports` 0.0015609264373779
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00027799606323242
(131) DESCRIBE `ports` 0.0013089179992676
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00034308433532715
(133) DESCRIBE `ports` 0.0013189315795898
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00028085708618164
(135) DESCRIBE `avid_specials` 0.00142502784729
(136) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56791 and class = 'Cruise') OR (item_id = 390 AND class = 'Ship') OR (item_id = 218 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.002140998840332
(137) DESCRIBE `cruiselines` 0.0026099681854248
(138) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00045418739318848
(139) DESCRIBE `orchid_image` 0.0019340515136719
(140) DESCRIBE `cruiselines` 0.0025570392608643
(141) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00040602684020996
(142) DESCRIBE `cruises` 0.0036258697509766
(143) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57979') 0.00042605400085449
(144) DESCRIBE `ships` 0.0035500526428223
(145) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1184))) 0.0005650520324707
(146) DESCRIBE `ships` 0.0036420822143555
(147) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1184') 0.0004730224609375
(148) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00032496452331543
(149) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0003659725189209
(150) DESCRIBE `itineraries` 0.0016880035400391
(151) DESCRIBE `ports` 0.0014200210571289
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2595))) 0.00034189224243164
(153) DESCRIBE `ports` 0.0012569427490234
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2595))) 0.00029301643371582
(155) DESCRIBE `ports` 0.0013201236724854
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2595') 0.00032496452331543
(157) DESCRIBE `sailingdates` 0.001276969909668
(158) DESCRIBE `ports` 0.0015568733215332
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2595))) 0.00037717819213867
(160) DESCRIBE `ports` 0.0015828609466553
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2595') 0.00031709671020508
(162) DESCRIBE `ports` 0.0014309883117676
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2882))) 0.00032615661621094
(164) DESCRIBE `ports` 0.0016319751739502
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2882') 0.00032806396484375
(166) DESCRIBE `ports` 0.0015320777893066
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2525))) 0.00036096572875977
(168) DESCRIBE `ports` 0.0016410350799561
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2525') 0.0004279613494873
(170) DESCRIBE `ports` 0.0019941329956055
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2529))) 0.00042200088500977
(172) DESCRIBE `ports` 0.0018668174743652
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2529') 0.00045204162597656
(174) DESCRIBE `ports` 0.0018439292907715
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2600))) 0.00046586990356445
(176) DESCRIBE `ports` 0.0019111633300781
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2600') 0.00049996376037598
(178) DESCRIBE `ports` 0.0018711090087891
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2523))) 0.00043988227844238
(180) DESCRIBE `ports` 0.0018560886383057
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2523') 0.00042414665222168
(182) DESCRIBE `ports` 0.0019099712371826
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2883))) 0.00042295455932617
(184) DESCRIBE `ports` 0.0017821788787842
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2883') 0.0003960132598877
(186) DESCRIBE `ports` 0.001788854598999
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2663))) 0.00042915344238281
(188) DESCRIBE `ports` 0.0017409324645996
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2663') 0.00060701370239258
(190) DESCRIBE `ports` 0.001741886138916
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2525))) 0.0004429817199707
(192) DESCRIBE `ports` 0.00177001953125
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2525') 0.00039410591125488
(194) DESCRIBE `ports` 0.0016069412231445
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2525))) 0.00031089782714844
(196) DESCRIBE `ports` 0.0012509822845459
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2525') 0.00031304359436035
(198) DESCRIBE `avid_specials` 0.0011141300201416
(199) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57979 and class = 'Cruise') OR (item_id = 1184 AND class = 'Ship') OR (item_id = 229 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.00099897384643555
(200) DESCRIBE `cruiselines` 0.0023829936981201
(201) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 229))) 0.00050616264343262
(202) DESCRIBE `orchid_image` 0.0018010139465332
(203) DESCRIBE `cruiselines` 0.0022878646850586
(204) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '229') 0.0003819465637207
(205) DESCRIBE `cruises` 0.0029067993164062
(206) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57981') 0.0004267692565918
(207) DESCRIBE `ships` 0.0028698444366455
(208) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1183))) 0.00041007995605469
(209) DESCRIBE `ships` 0.0030689239501953
(210) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1183') 0.00039410591125488
(211) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034499168395996
(212) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00030899047851562
(213) DESCRIBE `itineraries` 0.0014240741729736
(214) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '57981') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0014798641204834
(215) DESCRIBE `ports` 0.0017361640930176
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2595))) 0.00046110153198242
(217) DESCRIBE `ports` 0.0014779567718506
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2595))) 0.00030398368835449
(219) DESCRIBE `ports` 0.0015079975128174
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2595') 0.00034785270690918
(221) DESCRIBE `sailingdates` 0.0012991428375244
(222) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '57981') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0012259483337402
(223) DESCRIBE `ports` 0.0018360614776611
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2595))) 0.00036001205444336
(225) DESCRIBE `ports` 0.0012760162353516
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2595') 0.00029802322387695
(227) DESCRIBE `ports` 0.0013508796691895
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1652))) 0.00030398368835449
(229) DESCRIBE `ports` 0.0015799999237061
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1652') 0.00026988983154297
(231) DESCRIBE `ports` 0.0014290809631348
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4454))) 0.00029802322387695
(233) DESCRIBE `ports` 0.0015029907226562
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4454') 0.00027799606323242
(235) DESCRIBE `ports` 0.0012288093566895
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4183))) 0.00034999847412109
(237) DESCRIBE `ports` 0.0017139911651611
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4183') 0.00034880638122559
(239) DESCRIBE `ports` 0.0014371871948242
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2525))) 0.00028491020202637
(241) DESCRIBE `ports` 0.0012779235839844
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2525') 0.00026416778564453
(243) DESCRIBE `ports` 0.0012950897216797
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2525))) 0.00027894973754883
(245) DESCRIBE `ports` 0.001378059387207
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2525') 0.00027108192443848
(247) DESCRIBE `ports` 0.0012879371643066
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2662))) 0.00030112266540527
(249) DESCRIBE `ports` 0.0013401508331299
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2662') 0.0002748966217041
(251) DESCRIBE `ports` 0.0012459754943848
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2597))) 0.00029110908508301
(253) DESCRIBE `ports` 0.0016069412231445
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2597') 0.0003349781036377
(255) DESCRIBE `ports` 0.0015830993652344
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2523))) 0.0003509521484375
(257) DESCRIBE `ports` 0.0013070106506348
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2523') 0.0002741813659668
(259) DESCRIBE `ports` 0.0012640953063965
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2525))) 0.00038599967956543
(261) DESCRIBE `ports` 0.0015461444854736
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2525') 0.0003359317779541
(263) DESCRIBE `avid_specials` 0.001370906829834
(264) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57981 and class = 'Cruise') OR (item_id = 1183 AND class = 'Ship') OR (item_id = 229 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.0016660690307617
(265) DESCRIBE `cruiselines` 0.0024690628051758
(266) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 229))) 0.00048089027404785
(267) DESCRIBE `orchid_image` 0.002061128616333
(268) DESCRIBE `cruiselines` 0.0025742053985596
(269) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '229') 0.00044894218444824
(270) DESCRIBE `cruises` 0.0036571025848389
(271) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59379') 0.00048494338989258
(272) DESCRIBE `ships` 0.0035672187805176
(273) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 452))) 0.00055313110351562
(274) DESCRIBE `ships` 0.0033299922943115
(275) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '452') 0.0003960132598877
(276) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026702880859375
(277) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025320053100586
(278) DESCRIBE `itineraries` 0.0015590190887451
(279) DESCRIBE `ports` 0.0024218559265137
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00046110153198242
(281) DESCRIBE `ports` 0.0018630027770996
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0003960132598877
(283) DESCRIBE `ports` 0.001816987991333
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00035881996154785
(285) DESCRIBE `sailingdates` 0.0015959739685059
(286) DESCRIBE `ports` 0.0018599033355713
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00041985511779785
(288) DESCRIBE `ports` 0.0017490386962891
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00036191940307617
(290) DESCRIBE `ports` 0.0032079219818115
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00039982795715332
(292) DESCRIBE `ports` 0.0016460418701172
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00044989585876465
(294) DESCRIBE `ports` 0.0014162063598633
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.0004580020904541
(296) DESCRIBE `ports` 0.0017569065093994
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00031590461730957
(298) DESCRIBE `ports` 0.0017719268798828
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00043606758117676
(300) DESCRIBE `ports` 0.0018548965454102
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00034999847412109
(302) DESCRIBE `ports` 0.0015199184417725
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00035905838012695
(304) DESCRIBE `ports` 0.0014309883117676
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.0003509521484375
(306) DESCRIBE `ports` 0.0016019344329834
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00045609474182129
(308) DESCRIBE `ports` 0.0017468929290771
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00042486190795898
(310) DESCRIBE `ports` 0.0017580986022949
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00037097930908203
(312) DESCRIBE `ports` 0.0017528533935547
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.0003821849822998
(314) DESCRIBE `avid_specials` 0.0015521049499512
(315) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59379 and class = 'Cruise') OR (item_id = 452 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012609958648682
(316) DESCRIBE `cruiselines` 0.0020899772644043
(317) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00043702125549316
(318) DESCRIBE `orchid_image` 0.0019791126251221
(319) DESCRIBE `cruiselines` 0.0025122165679932
(320) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00046992301940918
(321) DESCRIBE `cruises` 0.0036768913269043
(322) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74537') 0.00065207481384277
(323) DESCRIBE `ships` 0.003896951675415
(324) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 626))) 0.00059008598327637
(325) DESCRIBE `ships` 0.0038950443267822
(326) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '626') 0.00047588348388672
(327) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034499168395996
(328) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033187866210938
(329) DESCRIBE `itineraries` 0.0019340515136719
(330) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74537') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.001953125
(331) DESCRIBE `ports` 0.0021159648895264
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00037598609924316
(333) DESCRIBE `ports` 0.0013530254364014
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00037693977355957
(335) DESCRIBE `ports` 0.0015079975128174
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00030303001403809
(337) DESCRIBE `sailingdates` 0.0012729167938232
(338) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74537') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011539459228516
(339) DESCRIBE `ports` 0.0015881061553955
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00037908554077148
(341) DESCRIBE `ports` 0.0013229846954346
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00030612945556641
(343) DESCRIBE `ports` 0.001323938369751
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00030303001403809
(345) DESCRIBE `ports` 0.0014681816101074
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00036811828613281
(347) DESCRIBE `ports` 0.0056869983673096
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 333))) 0.00053095817565918
(349) DESCRIBE `ports` 0.0017809867858887
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '333') 0.00038409233093262
(351) DESCRIBE `ports` 0.0018529891967773
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.0004270076751709
(353) DESCRIBE `ports` 0.0018689632415771
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00038290023803711
(355) DESCRIBE `ports` 0.0017790794372559
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00041699409484863
(357) DESCRIBE `ports` 0.0014820098876953
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00034713745117188
(359) DESCRIBE `ports` 0.0013351440429688
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 118))) 0.00030207633972168
(361) DESCRIBE `ports` 0.0015227794647217
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '118') 0.00036001205444336
(363) DESCRIBE `ports` 0.0013101100921631
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00030112266540527
(365) DESCRIBE `ports` 0.0015649795532227
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00030517578125
(367) DESCRIBE `avid_specials` 0.001276969909668
(368) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74537 and class = 'Cruise') OR (item_id = 626 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 11 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.0016469955444336
(369) DESCRIBE `cruiselines` 0.0019979476928711
(370) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00047898292541504
(371) DESCRIBE `orchid_image` 0.0016729831695557
(372) DESCRIBE `cruiselines` 0.0021810531616211
(373) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00036787986755371
(374) DESCRIBE `cruises` 0.0029091835021973
(375) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75766') 0.0067980289459229
(376) DESCRIBE `ships` 0.0035359859466553
(377) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 487))) 0.0019450187683105
(378) DESCRIBE `ships` 0.0038189888000488
(379) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '487') 0.00043797492980957
(380) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00028014183044434
(381) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00026106834411621
(382) DESCRIBE `itineraries` 0.0014638900756836
(383) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '75766') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0014050006866455
(384) DESCRIBE `ports` 0.0017349720001221
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00043702125549316
(386) DESCRIBE `ports` 0.001478910446167
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00034284591674805
(388) DESCRIBE `ports` 0.0013940334320068
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00039887428283691
(390) DESCRIBE `sailingdates` 0.0012919902801514
(391) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '75766') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.001129150390625
(392) DESCRIBE `ports` 0.0015780925750732
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00033903121948242
(394) DESCRIBE `ports` 0.0013270378112793
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00035786628723145
(396) DESCRIBE `ports` 0.0013360977172852
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2534))) 0.00031614303588867
(398) DESCRIBE `ports` 0.0012941360473633
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2534') 0.00030612945556641
(400) DESCRIBE `ports` 0.0013151168823242
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00031208992004395
(402) DESCRIBE `ports` 0.0012879371643066
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00027799606323242
(404) DESCRIBE `ports` 0.0012719631195068
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4435))) 0.00030922889709473
(406) DESCRIBE `ports` 0.0012679100036621
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4435') 0.00027894973754883
(408) DESCRIBE `ports` 0.0012660026550293
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3549))) 0.00029397010803223
(410) DESCRIBE `ports` 0.0012369155883789
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3549') 0.0002748966217041
(412) DESCRIBE `ports` 0.0012719631195068
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00029301643371582
(414) DESCRIBE `ports` 0.0012960433959961
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.0002739429473877
(416) DESCRIBE `avid_specials` 0.0011398792266846
(417) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75766 and class = 'Cruise') OR (item_id = 487 AND class = 'Ship') OR (item_id = 110 AND class = 'CruiseLine') OR (item_id = 2 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.00099682807922363
(418) DESCRIBE `cruiselines` 0.0018529891967773
(419) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 110))) 0.00037622451782227
(420) DESCRIBE `orchid_image` 0.001446008682251
(421) DESCRIBE `cruiselines` 0.0017390251159668
(422) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '110') 0.0003049373626709
(423) DESCRIBE `cruises` 0.0024781227111816
(424) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59442') 0.00032806396484375
(425) DESCRIBE `ships` 0.0025231838226318
(426) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1423))) 0.00039386749267578
(427) DESCRIBE `ships` 0.0025320053100586
(428) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1423') 0.00030899047851562
(429) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026702880859375
(430) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027799606323242
(431) DESCRIBE `itineraries` 0.0012331008911133
(432) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '59442') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00077986717224121
(433) DESCRIBE `ports` 0.0013608932495117
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00033903121948242
(435) DESCRIBE `ports` 0.0012860298156738
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00031590461730957
(437) DESCRIBE `ports` 0.0013401508331299
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00031590461730957
(439) DESCRIBE `sailingdates` 0.0011608600616455
(440) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '59442') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0015261173248291
(441) DESCRIBE `ports` 0.0014560222625732
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00037312507629395
(443) DESCRIBE `ports` 0.0013229846954346
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00029397010803223
(445) DESCRIBE `ports` 0.0018110275268555
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2204))) 0.00033688545227051
(447) DESCRIBE `ports` 0.0012619495391846
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2204') 0.00027203559875488
(449) DESCRIBE `ports` 0.0012938976287842
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.0002899169921875
(451) DESCRIBE `ports` 0.0015530586242676
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.00027799606323242
(453) DESCRIBE `ports` 0.0017631053924561
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2831))) 0.00029706954956055
(455) DESCRIBE `ports` 0.0013148784637451
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2831') 0.0002741813659668
(457) DESCRIBE `ports` 0.0013020038604736
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2201))) 0.00035405158996582
(459) DESCRIBE `ports` 0.0012738704681396
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2201') 0.00027203559875488
(461) DESCRIBE `ports` 0.0015628337860107
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2203))) 0.00029897689819336
(463) DESCRIBE `ports` 0.001270055770874
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2203') 0.00034594535827637
(465) DESCRIBE `ports` 0.0013129711151123
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2831))) 0.00027894973754883
(467) DESCRIBE `ports` 0.0012948513031006
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2831') 0.00026106834411621
(469) DESCRIBE `ports` 0.0013141632080078
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.00030112266540527
(471) DESCRIBE `ports` 0.0012428760528564
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.00032901763916016
(473) DESCRIBE `ports` 0.0012669563293457
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2832))) 0.00029397010803223
(475) DESCRIBE `ports` 0.0012619495391846
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2832') 0.00026988983154297
(477) DESCRIBE `ports` 0.0013680458068848
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.0003349781036377
(479) DESCRIBE `ports` 0.00130295753479
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00035595893859863
(481) DESCRIBE `avid_specials` 0.0011789798736572
(482) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59442 and class = 'Cruise') OR (item_id = 1423 AND class = 'Ship') OR (item_id = 31 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001317024230957
(483) DESCRIBE `cruiselines` 0.002133846282959
(484) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 31))) 0.00043702125549316
(485) DESCRIBE `orchid_image` 0.0015687942504883
(486) DESCRIBE `cruiselines` 0.0020720958709717
(487) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '31') 0.00034713745117188
(488) DESCRIBE `cruises` 0.002453088760376
(489) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59758') 0.0003209114074707
(490) DESCRIBE `ships` 0.0028271675109863
(491) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 893))) 0.00035309791564941
(492) DESCRIBE `ships` 0.0024800300598145
(493) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '893') 0.00029897689819336
(494) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026416778564453
(495) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025200843811035
(496) DESCRIBE `itineraries` 0.0012209415435791
(497) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '59758') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0006411075592041
(498) DESCRIBE `ports` 0.001288890838623
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.00033187866210938
(500) DESCRIBE `ports` 0.0012390613555908
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.00029587745666504
(502) DESCRIBE `ports` 0.0012710094451904
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1543') 0.00031685829162598
(504) DESCRIBE `sailingdates` 0.0014369487762451
(505) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '59758') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00096607208251953
(506) DESCRIBE `ports` 0.001276969909668
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.00030016899108887
(508) DESCRIBE `ports` 0.0012412071228027
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1543') 0.00027108192443848
(510) DESCRIBE `ports` 0.0012679100036621
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1543))) 0.00046110153198242
(512) DESCRIBE `ports` 0.0012500286102295
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1543') 0.00027108192443848
(514) DESCRIBE `ports` 0.0013439655303955
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2985))) 0.00030398368835449
(516) DESCRIBE `ports` 0.0016307830810547
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2985') 0.00035405158996582
(518) DESCRIBE `ports` 0.0015459060668945
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2985))) 0.00034594535827637
(520) DESCRIBE `ports` 0.0015439987182617
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2985') 0.00028085708618164
(522) DESCRIBE `ports` 0.0014541149139404
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1540))) 0.00034999847412109
(524) DESCRIBE `ports` 0.0012810230255127
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1540') 0.00029802322387695
(526) DESCRIBE `ports` 0.0014569759368896
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1540))) 0.00033283233642578
(528) DESCRIBE `ports` 0.0012788772583008
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1540') 0.00028395652770996
(530) DESCRIBE `ports` 0.0016109943389893
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1540))) 0.00030207633972168
(532) DESCRIBE `ports` 0.0012609958648682
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1540') 0.00039005279541016
(534) DESCRIBE `ports` 0.0013911724090576
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1539))) 0.00028800964355469
(536) DESCRIBE `ports` 0.0012807846069336
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1539') 0.00027203559875488
(538) DESCRIBE `ports` 0.0014569759368896
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1539))) 0.00034308433532715
(540) DESCRIBE `ports` 0.0013480186462402
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1539') 0.00026893615722656
(542) DESCRIBE `ports` 0.0012359619140625
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1536))) 0.00037908554077148
(544) DESCRIBE `ports` 0.0012979507446289
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1536') 0.00028204917907715
(546) DESCRIBE `ports` 0.0012362003326416
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1534))) 0.00031399726867676
(548) DESCRIBE `ports` 0.0012340545654297
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1534') 0.00031685829162598
(550) DESCRIBE `ports` 0.0013649463653564
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1533))) 0.00028800964355469
(552) DESCRIBE `ports` 0.001291036605835
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1533') 0.00026917457580566
(554) DESCRIBE `avid_specials` 0.0012738704681396
(555) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59758 and class = 'Cruise') OR (item_id = 893 AND class = 'Ship') OR (item_id = 204 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.00098896026611328
(556) DESCRIBE `cruiselines` 0.001816987991333
(557) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 204))) 0.00031185150146484
(558) DESCRIBE `orchid_image` 0.0014441013336182
(559) DESCRIBE `cruiselines` 0.0018010139465332
(560) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '204') 0.0002751350402832
(561) DESCRIBE `cruiselines` 0.0018072128295898
(562) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '19', '77', '26', '7', '12', '23', '171', '20', '18', '144', '31', '101', '8', '131', '96', '239', '29', '15', '191', '120', '183', '103', '50', '206', '91', '16', '262', '221', '33', '24', '28', '114', '110', '268', '156', '37', '208', '141', '14', '187', '153', '118', '49', '151', '211', '30', '258', '216', '181', '88', '212', '4', '36', '232', '225', '238', '140', '184', '249', '159', '113', '90', '47', '230', '182', '136', '213', '256', '261', '35', '237', '188', '174', '57', '180', '64', '264', '73', '248', '146', '195', '95', '52', '115', '204', '209', '59', '168', '196', '219', '231', '116', '82', '229', '119', '170', '244', '134', '105', '240', '276', '48', '108', '275', '132', '224', '210', '269')) ORDER BY FIND_IN_SET(id, '218,19,77,26,7,12,23,171,20,18,144,31,101,8,131,96,239,29,15,191,120,183,103,50,206,91,16,262,221,33,24,28,114,110,268,156,37,208,141,14,187,153,118,49,151,211,30,258,216,181,88,212,4,36,232,225,238,140,184,249,159,113,90,47,230,182,136,213,256,261,35,237,188,174,57,180,64,264,73,248,146,195,95,52,115,204,209,59,168,196,219,231,116,82,229,119,170,244,134,105,240,276,48,108,275,132,224,210,269') 0.0069749355316162
(563) DESCRIBE `ships` 0.0030961036682129
(564) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1032', '1292', '1205', '1199', '258', '1291', '977', '1359', '454', '1599', '1272', '855', '986', '1237', '404', '1594', '780', '1677', '1067', '1588', '837', '37', '38', '34', '22', '27', '378', '461', '21', '28', '407', '31', '393', '1607', '817', '1135', '1247', '1554', '1555', '1012', '30', '36', '349', '39', '1424', '726', '35', '1422', '462', '1415', '792', '1423', '585', '882', '1245', '1419', '1420', '1421', '1176', '1418', '1215', '1574', '113', '330', '1405', '24', '711', '11', '439', '1744', '9', '10', '265', '766', '455', '452', '542', '1141', '1193', '78', '739', '81', '635', '1572', '69', '124', '674', '3', '1095', '1454', '770', '1008', '1372', '5', '850', '874', '338', '116', '340', '573', '1168', '580', '1471', '1021', '1569', '553', '1284', '43', '70', '1302', '25', '66', '160', '253', '285', '332', '405', '716', '1402', '148', '451', '658', '944', '1678', '111', '390', '1562', '4', '748', '1172', '386', '520', '797', '966', '1259', '1260', '1460', '385', '626', '791', '1320', '1323', '406', '1455', '974', '1088', '1108', '1325', '286', '314', '678', '351', '590', '768', '582', '970', '1195', '1373', '1575', '63', '119', '327', '434', '508', '526', '108', '335', '375', '616', '993', '1587', '559', '854', '207', '84', '394', '401', '722', '1208', '1266', '517', '1398', '1492', '1571', '657', '775', '1068', '1268', '150', '421', '1236', '1586', '485', '1308', '1672', '114', '403', '704', '1742', '147', '152', '547', '784', '883', '105', '151', '1064', '1289', '1319', '223', '325', '652', '683', '958', '1269', '1724', '123', '149', '262', '348', '715', '1321', '1270', '75', '163', '389', '483', '1243', '1389', '1143', '1159', '1282', '1561', '1330', '1437', '1557', '14', '441', '1013', '1526', '1579', '1711', '287', '717', '1139', '1151', '1214', '1326', '1327', '1348', '162', '333', '545', '790', '796', '1367', '1722', '290', '732', '823', '1216', '1301', '1539', '1717', '93', '651', '1738', '291', '884', '968', '1075', '1318', '201', '673', '1540', '1602', '82', '98', '212', '769', '818', '1063', '1137', '1144', '1303', '1344', '45', '516', '743', '852', '1040', '1160', '1343', '1704', '751', '776', '1163', '1217', '1452', '1453', '1604', '701', '1043', '1218', '1283', '1409', '1426', '1566', '1682', '266', '324', '341', '521', '811', '885', '988', '1025', '1027', '1090', '1136', '1157', '1241', '1449', '448', '669', '1253', '1413', '1552', '1632', '1676', '1740', '467', '574', '738', '795', '1019', '1073', '1223', '1358', '1411', '639', '905', '1152', '1226', '1233', '1345', '1376', '1448', '1474', '601', '888', '1150', '1721', '494', '1029', '1145', '1647', '74', '417', '997', '1055', '1229', '1322', '1408', '1458', '1716', '1026', '1188', '1580', '618', '709', '836', '1149', '1231', '1351', '1410', '1463', '1489', '1496', '1505', '1619', '1663', '205', '208', '666', '954', '973', '1034', '1047', '1222', '1366', '1713', '1715', '204', '352', '423', '493', '610', '996', '1049', '1230', '1714', '643', '851', '1154', '1262', '1362', '1368', '1407', '1444', '1516', '1609', '1673', '1743', '663', '920', '927', '1017', '1404', '1567', '1606', '499', '703', '921', '931', '1004', '1020', '1037', '1187', '1196', '1285', '1354', '1360', '1361', '1459', '1470', '1508', '1627', '731', '859', '914', '923', '1042', '1175', '1518', '503', '915', '916', '926', '930', '1003', '1045', '1072', '1106', '1138', '1486', '1517', '1521', '422', '479', '781', '924', '972', '1092', '1254', '1352', '1412', '1522', '1596', '1708', '1751', '17', '671', '1001', '1091', '1240', '1593', '1723', '453', '656', '665', '938', '1005', '1051', '1054', '1148', '1445', '1514', '1729', '420', '672', '937', '1684', '1002', '1052', '1601', '1679', '1681', '1697')) ORDER BY FIND_IN_SET(id, '1127,1032,1292,1205,1199,258,1291,977,1359,454,1599,1272,855,986,1237,404,1594,780,1677,1067,1588,837,37,38,34,22,27,378,461,21,28,407,31,393,1607,817,1135,1247,1554,1555,1012,30,36,349,39,1424,726,35,1422,462,1415,792,1423,585,882,1245,1419,1420,1421,1176,1418,1215,1574,113,330,1405,24,711,11,439,1744,9,10,265,766,455,452,542,1141,1193,78,739,81,635,1572,69,124,674,3,1095,1454,770,1008,1372,5,850,874,338,116,340,573,1168,580,1471,1021,1569,553,1284,43,70,1302,25,66,160,253,285,332,405,716,1402,148,451,658,944,1678,111,390,1562,4,748,1172,386,520,797,966,1259,1260,1460,385,626,791,1320,1323,406,1455,974,1088,1108,1325,286,314,678,351,590,768,582,970,1195,1373,1575,63,119,327,434,508,526,108,335,375,616,993,1587,559,854,207,84,394,401,722,1208,1266,517,1398,1492,1571,657,775,1068,1268,150,421,1236,1586,485,1308,1672,114,403,704,1742,147,152,547,784,883,105,151,1064,1289,1319,223,325,652,683,958,1269,1724,123,149,262,348,715,1321,1270,75,163,389,483,1243,1389,1143,1159,1282,1561,1330,1437,1557,14,441,1013,1526,1579,1711,287,717,1139,1151,1214,1326,1327,1348,162,333,545,790,796,1367,1722,290,732,823,1216,1301,1539,1717,93,651,1738,291,884,968,1075,1318,201,673,1540,1602,82,98,212,769,818,1063,1137,1144,1303,1344,45,516,743,852,1040,1160,1343,1704,751,776,1163,1217,1452,1453,1604,701,1043,1218,1283,1409,1426,1566,1682,266,324,341,521,811,885,988,1025,1027,1090,1136,1157,1241,1449,448,669,1253,1413,1552,1632,1676,1740,467,574,738,795,1019,1073,1223,1358,1411,639,905,1152,1226,1233,1345,1376,1448,1474,601,888,1150,1721,494,1029,1145,1647,74,417,997,1055,1229,1322,1408,1458,1716,1026,1188,1580,618,709,836,1149,1231,1351,1410,1463,1489,1496,1505,1619,1663,205,208,666,954,973,1034,1047,1222,1366,1713,1715,204,352,423,493,610,996,1049,1230,1714,643,851,1154,1262,1362,1368,1407,1444,1516,1609,1673,1743,663,920,927,1017,1404,1567,1606,499,703,921,931,1004,1020,1037,1187,1196,1285,1354,1360,1361,1459,1470,1508,1627,731,859,914,923,1042,1175,1518,503,915,916,926,930,1003,1045,1072,1106,1138,1486,1517,1521,422,479,781,924,972,1092,1254,1352,1412,1522,1596,1708,1751,17,671,1001,1091,1240,1593,1723,453,656,665,938,1005,1051,1054,1148,1445,1514,1729,420,672,937,1684,1002,1052,1601,1679,1681,1697') 0.058167934417725
(565) DESCRIBE `cruisetypes` 0.0014970302581787
(566) DESCRIBE `destinations` 0.0017979145050049
(567) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '25', '37', '9', '43', '2', '8', '53', '55', '39', '38', '28', '7', '40', '26', '30', '48', '11', '21', '29', '45', '49', '56', '44', '10', '34', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,25,37,9,43,2,8,53,55,39,38,28,7,40,26,30,48,11,21,29,45,49,56,44,10,34,52,46,32') 0.0018560886383057