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

Total elapsed time: 0.54964423179626

# Query Time
(1) connect 0.00068497657775879
(2) DESCRIBE `cruises` 0.0033740997314453
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66004, 65893, 66005, 50866, 65894, 66006, 65896, 63400, 66007, 41776)) ORDER BY FIND_IN_SET(id, '66004,65893,66005,50866,65894,66006,65896,63400,66007,41776') 0.0019290447235107
(4) DESCRIBE `cruises` 0.0032820701599121
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66004') 0.00036716461181641
(6) DESCRIBE `ships` 0.0026428699493408
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00039315223693848
(8) DESCRIBE `ships` 0.0025961399078369
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00030612945556641
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026607513427734
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034093856811523
(12) DESCRIBE `itineraries` 0.0012679100036621
(13) DESCRIBE `ports` 0.0013198852539062
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031805038452148
(15) DESCRIBE `ports` 0.0013298988342285
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038003921508789
(17) DESCRIBE `ports` 0.0012390613555908
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031900405883789
(19) DESCRIBE `sailingdates` 0.0010979175567627
(20) DESCRIBE `ports` 0.0015461444854736
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003199577331543
(22) DESCRIBE `ports` 0.0016860961914062
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030303001403809
(24) DESCRIBE `ports` 0.0015091896057129
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00032901763916016
(26) DESCRIBE `ports` 0.0013728141784668
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00028705596923828
(28) DESCRIBE `ports` 0.0012998580932617
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4208))) 0.00033712387084961
(30) DESCRIBE `ports` 0.0014290809631348
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4208') 0.00028705596923828
(32) DESCRIBE `ports` 0.0013220310211182
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00029516220092773
(34) DESCRIBE `ports` 0.0015311241149902
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00029206275939941
(36) DESCRIBE `ports` 0.0013589859008789
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00028586387634277
(38) DESCRIBE `ports` 0.001554012298584
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00028610229492188
(40) DESCRIBE `ports` 0.0015408992767334
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031018257141113
(42) DESCRIBE `ports` 0.0012640953063965
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027203559875488
(44) DESCRIBE `avid_specials` 0.0011529922485352
(45) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66004 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010309219360352
(46) DESCRIBE `cruiselines` 0.0024199485778809
(47) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00039887428283691
(48) DESCRIBE `orchid_image` 0.0017440319061279
(49) DESCRIBE `cruiselines` 0.0020370483398438
(50) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00032186508178711
(51) DESCRIBE `cruises` 0.002547025680542
(52) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65893') 0.00034809112548828
(53) DESCRIBE `ships` 0.0027651786804199
(54) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00074100494384766
(55) DESCRIBE `ships` 0.0031440258026123
(56) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0003049373626709
(57) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026512145996094
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029182434082031
(59) DESCRIBE `itineraries` 0.0015158653259277
(60) DESCRIBE `ports` 0.0015289783477783
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037097930908203
(62) DESCRIBE `ports` 0.0013179779052734
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030684471130371
(64) DESCRIBE `ports` 0.0016429424285889
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042605400085449
(66) DESCRIBE `sailingdates` 0.0015320777893066
(67) DESCRIBE `ports` 0.0017721652984619
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039887428283691
(69) DESCRIBE `ports` 0.0014941692352295
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028014183044434
(71) DESCRIBE `ports` 0.0014150142669678
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00038599967956543
(73) DESCRIBE `ports` 0.0017008781433105
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00032401084899902
(75) DESCRIBE `ports` 0.0012760162353516
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00034809112548828
(77) DESCRIBE `ports` 0.0016000270843506
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00036501884460449
(79) DESCRIBE `ports` 0.0013010501861572
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00031185150146484
(81) DESCRIBE `ports` 0.0013577938079834
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00039100646972656
(83) DESCRIBE `ports` 0.001359224319458
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00028705596923828
(85) DESCRIBE `ports` 0.0013151168823242
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00035905838012695
(87) DESCRIBE `ports` 0.0012378692626953
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029587745666504
(89) DESCRIBE `ports` 0.0014438629150391
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027894973754883
(91) DESCRIBE `avid_specials` 0.0011041164398193
(92) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65893 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0019409656524658
(93) DESCRIBE `cruiselines` 0.0078389644622803
(94) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0066819190979004
(95) DESCRIBE `orchid_image` 0.0022120475769043
(96) DESCRIBE `cruiselines` 0.0026748180389404
(97) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00042581558227539
(98) DESCRIBE `cruises` 0.0035438537597656
(99) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66005') 0.0092880725860596
(100) DESCRIBE `ships` 0.0036909580230713
(101) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00054121017456055
(102) DESCRIBE `ships` 0.002748966217041
(103) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00037980079650879
(104) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026893615722656
(105) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003049373626709
(106) DESCRIBE `itineraries` 0.0018630027770996
(107) DESCRIBE `ports` 0.0014019012451172
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037097930908203
(109) DESCRIBE `ports` 0.0014898777008057
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030112266540527
(111) DESCRIBE `ports` 0.0015439987182617
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043511390686035
(113) DESCRIBE `sailingdates` 0.0012531280517578
(114) DESCRIBE `ports` 0.0013248920440674
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035500526428223
(116) DESCRIBE `ports` 0.0017640590667725
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038790702819824
(118) DESCRIBE `ports` 0.0017638206481934
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00039196014404297
(120) DESCRIBE `ports` 0.0018131732940674
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0003058910369873
(122) DESCRIBE `ports` 0.0014121532440186
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00030303001403809
(124) DESCRIBE `ports` 0.0012481212615967
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00028586387634277
(126) DESCRIBE `ports` 0.0013370513916016
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00029587745666504
(128) DESCRIBE `ports` 0.0012829303741455
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00027680397033691
(130) DESCRIBE `ports` 0.0015950202941895
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00037002563476562
(132) DESCRIBE `ports` 0.0015079975128174
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00033402442932129
(134) DESCRIBE `ports` 0.0014758110046387
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0003809928894043
(136) DESCRIBE `ports` 0.001507043838501
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00029802322387695
(138) DESCRIBE `avid_specials` 0.001209020614624
(139) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66005 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010058879852295
(140) DESCRIBE `cruiselines` 0.0018608570098877
(141) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00037789344787598
(142) DESCRIBE `orchid_image` 0.0014028549194336
(143) DESCRIBE `cruiselines` 0.0019421577453613
(144) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00039815902709961
(145) DESCRIBE `cruises` 0.0036938190460205
(146) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50866') 0.00044393539428711
(147) DESCRIBE `ships` 0.0034918785095215
(148) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00052785873413086
(149) DESCRIBE `ships` 0.0033390522003174
(150) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00039291381835938
(151) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033998489379883
(152) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032806396484375
(153) DESCRIBE `itineraries` 0.0016779899597168
(154) DESCRIBE `ports` 0.0016889572143555
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042200088500977
(156) DESCRIBE `ports` 0.0017092227935791
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037789344787598
(158) DESCRIBE `ports` 0.0017049312591553
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036382675170898
(160) DESCRIBE `sailingdates` 0.0014960765838623
(161) DESCRIBE `ports` 0.0018351078033447
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043296813964844
(163) DESCRIBE `ports` 0.0016810894012451
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036287307739258
(165) DESCRIBE `ports` 0.0016770362854004
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00040388107299805
(167) DESCRIBE `ports` 0.0017070770263672
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00035500526428223
(169) DESCRIBE `ports` 0.0016748905181885
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00038290023803711
(171) DESCRIBE `ports` 0.0016717910766602
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00035500526428223
(173) DESCRIBE `ports` 0.0016701221466064
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00039505958557129
(175) DESCRIBE `ports` 0.0017650127410889
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00035309791564941
(177) DESCRIBE `ports` 0.0016810894012451
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044608116149902
(179) DESCRIBE `ports` 0.0016651153564453
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00035691261291504
(181) DESCRIBE `avid_specials` 0.0014970302581787
(182) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 50866 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016911029815674
(183) DESCRIBE `cruiselines` 0.0024209022521973
(184) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00049996376037598
(185) DESCRIBE `orchid_image` 0.0018730163574219
(186) DESCRIBE `cruiselines` 0.0024189949035645
(187) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00041699409484863
(188) DESCRIBE `cruises` 0.0029799938201904
(189) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65894') 0.00036001205444336
(190) DESCRIBE `ships` 0.0035150051116943
(191) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00048303604125977
(192) DESCRIBE `ships` 0.0033860206604004
(193) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00039815902709961
(194) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031304359436035
(195) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030803680419922
(196) DESCRIBE `itineraries` 0.0019228458404541
(197) DESCRIBE `ports` 0.0019779205322266
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048112869262695
(199) DESCRIBE `ports` 0.0016970634460449
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037908554077148
(201) DESCRIBE `ports` 0.0017931461334229
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037288665771484
(203) DESCRIBE `sailingdates` 0.0014967918395996
(204) DESCRIBE `ports` 0.0017271041870117
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039792060852051
(206) DESCRIBE `ports` 0.0017259120941162
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00035595893859863
(208) DESCRIBE `ports` 0.0016598701477051
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00042581558227539
(210) DESCRIBE `ports` 0.0017030239105225
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00035405158996582
(212) DESCRIBE `ports` 0.0017399787902832
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00038003921508789
(214) DESCRIBE `ports` 0.0016980171203613
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.0004279613494873
(216) DESCRIBE `ports` 0.0017168521881104
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00046920776367188
(218) DESCRIBE `ports` 0.0017049312591553
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00036883354187012
(220) DESCRIBE `ports` 0.0017068386077881
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00037002563476562
(222) DESCRIBE `ports` 0.001762866973877
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.0003509521484375
(224) DESCRIBE `ports` 0.0016751289367676
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043392181396484
(226) DESCRIBE `ports` 0.0016820430755615
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00035691261291504
(228) DESCRIBE `avid_specials` 0.0015618801116943
(229) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65894 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016610622406006
(230) DESCRIBE `cruiselines` 0.0024330615997314
(231) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00043892860412598
(232) DESCRIBE `orchid_image` 0.00201416015625
(233) DESCRIBE `cruiselines` 0.0024609565734863
(234) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0003659725189209
(235) DESCRIBE `cruises` 0.0031981468200684
(236) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66006') 0.00038981437683105
(237) DESCRIBE `ships` 0.0035080909729004
(238) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00052714347839355
(239) DESCRIBE `ships` 0.003087043762207
(240) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00040793418884277
(241) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032711029052734
(242) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031805038452148
(243) DESCRIBE `itineraries` 0.0014770030975342
(244) DESCRIBE `ports` 0.0017728805541992
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00045204162597656
(246) DESCRIBE `ports` 0.0016970634460449
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00039815902709961
(248) DESCRIBE `ports` 0.0017409324645996
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00037503242492676
(250) DESCRIBE `sailingdates` 0.0015408992767334
(251) DESCRIBE `ports` 0.001701831817627
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00040912628173828
(253) DESCRIBE `ports` 0.001708984375
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00036811828613281
(255) DESCRIBE `ports` 0.0016720294952393
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00040388107299805
(257) DESCRIBE `ports` 0.0017948150634766
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00037097930908203
(259) DESCRIBE `ports` 0.0017650127410889
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00039792060852051
(261) DESCRIBE `ports` 0.001708984375
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00040411949157715
(263) DESCRIBE `ports` 0.00166916847229
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00040912628173828
(265) DESCRIBE `ports` 0.0020651817321777
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00038504600524902
(267) DESCRIBE `ports` 0.0017659664154053
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00040006637573242
(269) DESCRIBE `ports` 0.0017099380493164
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00038313865661621
(271) DESCRIBE `avid_specials` 0.0040187835693359
(272) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66006 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018789768218994
(273) DESCRIBE `cruiselines` 0.0025131702423096
(274) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00045108795166016
(275) DESCRIBE `orchid_image` 0.0019209384918213
(276) DESCRIBE `cruiselines` 0.0024302005767822
(277) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00043392181396484
(278) DESCRIBE `cruises` 0.0033600330352783
(279) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65896') 0.0004429817199707
(280) DESCRIBE `ships` 0.003572940826416
(281) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00056004524230957
(282) DESCRIBE `ships` 0.0030169486999512
(283) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00035500526428223
(284) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031495094299316
(285) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029611587524414
(286) DESCRIBE `itineraries` 0.0015270709991455
(287) DESCRIBE `ports` 0.0018961429595947
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037503242492676
(289) DESCRIBE `ports` 0.0016770362854004
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041007995605469
(291) DESCRIBE `ports` 0.0017509460449219
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036787986755371
(293) DESCRIBE `sailingdates` 0.0015690326690674
(294) DESCRIBE `ports` 0.0019168853759766
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043296813964844
(296) DESCRIBE `ports` 0.0017368793487549
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003669261932373
(298) DESCRIBE `ports` 0.0016858577728271
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00062704086303711
(300) DESCRIBE `ports` 0.0019669532775879
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00038790702819824
(302) DESCRIBE `ports` 0.0017809867858887
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00040507316589355
(304) DESCRIBE `ports` 0.0018079280853271
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00037693977355957
(306) DESCRIBE `ports` 0.0018279552459717
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.00041890144348145
(308) DESCRIBE `ports` 0.0019500255584717
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.00038599967956543
(310) DESCRIBE `ports` 0.0017971992492676
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00039386749267578
(312) DESCRIBE `ports` 0.0017709732055664
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00035810470581055
(314) DESCRIBE `ports` 0.0017609596252441
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00041294097900391
(316) DESCRIBE `ports` 0.0018320083618164
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.0003809928894043
(318) DESCRIBE `ports` 0.0018200874328613
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004119873046875
(320) DESCRIBE `ports` 0.0018160343170166
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038599967956543
(322) DESCRIBE `avid_specials` 0.0017299652099609
(323) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65896 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017871856689453
(324) DESCRIBE `cruiselines` 0.0026640892028809
(325) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00043392181396484
(326) DESCRIBE `orchid_image` 0.002068042755127
(327) DESCRIBE `cruiselines` 0.0026299953460693
(328) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00040793418884277
(329) DESCRIBE `cruises` 0.0035920143127441
(330) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63400') 0.00043106079101562
(331) DESCRIBE `ships` 0.0036861896514893
(332) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00054001808166504
(333) DESCRIBE `ships` 0.0036239624023438
(334) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00042295455932617
(335) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035285949707031
(336) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034308433532715
(337) DESCRIBE `itineraries` 0.0018990039825439
(338) DESCRIBE `ports` 0.0019559860229492
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00045990943908691
(340) DESCRIBE `ports` 0.0017609596252441
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00048089027404785
(342) DESCRIBE `ports` 0.0017759799957275
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00037884712219238
(344) DESCRIBE `sailingdates` 0.0015721321105957
(345) DESCRIBE `ports` 0.0018081665039062
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00041699409484863
(347) DESCRIBE `ports` 0.0018088817596436
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00036215782165527
(349) DESCRIBE `ports` 0.0017540454864502
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00038599967956543
(351) DESCRIBE `ports` 0.0017538070678711
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00036096572875977
(353) DESCRIBE `avid_specials` 0.0015671253204346
(354) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63400 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018789768218994
(355) DESCRIBE `cruiselines` 0.0025739669799805
(356) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00046205520629883
(357) DESCRIBE `orchid_image` 0.0019640922546387
(358) DESCRIBE `cruiselines` 0.0025379657745361
(359) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00042104721069336
(360) DESCRIBE `cruises` 0.0025730133056641
(361) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66007') 0.00030708312988281
(362) DESCRIBE `ships` 0.0024240016937256
(363) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00034904479980469
(364) DESCRIBE `ships` 0.0026121139526367
(365) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00030422210693359
(366) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030207633972168
(367) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026512145996094
(368) DESCRIBE `itineraries` 0.0012500286102295
(369) DESCRIBE `ports` 0.0016889572143555
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0003349781036377
(371) DESCRIBE `ports` 0.0012609958648682
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00028800964355469
(373) DESCRIBE `ports` 0.0012340545654297
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00027799606323242
(375) DESCRIBE `sailingdates` 0.0012209415435791
(376) DESCRIBE `ports` 0.0018351078033447
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00046610832214355
(378) DESCRIBE `ports` 0.0013999938964844
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00030994415283203
(380) DESCRIBE `ports` 0.0013949871063232
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.0003049373626709
(382) DESCRIBE `ports` 0.0012509822845459
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00027704238891602
(384) DESCRIBE `ports` 0.0012621879577637
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028896331787109
(386) DESCRIBE `ports` 0.0012600421905518
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002751350402832
(388) DESCRIBE `avid_specials` 0.0011599063873291
(389) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66007 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 8 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012819766998291
(390) DESCRIBE `cruiselines` 0.0019640922546387
(391) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0003209114074707
(392) DESCRIBE `orchid_image` 0.0015389919281006
(393) DESCRIBE `cruiselines` 0.0019388198852539
(394) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00027894973754883
(395) DESCRIBE `cruises` 0.0024020671844482
(396) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41776') 0.00030422210693359
(397) DESCRIBE `ships` 0.002471923828125
(398) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00037002563476562
(399) DESCRIBE `ships` 0.0024869441986084
(400) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00029397010803223
(401) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027203559875488
(402) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00043082237243652
(403) DESCRIBE `itineraries` 0.0012850761413574
(404) DESCRIBE `ports` 0.0012772083282471
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040817260742188
(406) DESCRIBE `ports` 0.0013129711151123
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029706954956055
(408) DESCRIBE `ports` 0.0012779235839844
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027894973754883
(410) DESCRIBE `sailingdates` 0.0011179447174072
(411) DESCRIBE `ports` 0.001317024230957
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031399726867676
(413) DESCRIBE `ports` 0.0013129711151123
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00032591819763184
(415) DESCRIBE `ports` 0.0012309551239014
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00029206275939941
(417) DESCRIBE `ports` 0.0012688636779785
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00027298927307129
(419) DESCRIBE `ports` 0.0013020038604736
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00028204917907715
(421) DESCRIBE `ports` 0.0015401840209961
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00035595893859863
(423) DESCRIBE `ports` 0.0017769336700439
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00038385391235352
(425) DESCRIBE `ports` 0.0017499923706055
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00036311149597168
(427) DESCRIBE `ports` 0.001784086227417
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038814544677734
(429) DESCRIBE `ports` 0.0019321441650391
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036096572875977
(431) DESCRIBE `avid_specials` 0.0016100406646729
(432) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41776 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001727819442749
(433) DESCRIBE `cruiselines` 0.0025930404663086
(434) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00043320655822754
(435) DESCRIBE `orchid_image` 0.0019938945770264
(436) DESCRIBE `cruiselines` 0.0026390552520752
(437) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00040411949157715
(438) DESCRIBE `ships` 0.0038549900054932
(439) SELECT `ships`.* FROM `ships` WHERE (id IN ('4', '1722', '288')) ORDER BY FIND_IN_SET(id, '4,1722,288') 0.0010089874267578
(440) DESCRIBE `cruisetypes` 0.0015270709991455
(441) DESCRIBE `destinations` 0.0024070739746094
(442) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.00064206123352051
(443) DESCRIBE `cruiselines` 0.0025720596313477
(444) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00048208236694336
(445) DESCRIBE `cruiselines` 0.0026969909667969
(446) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00045990943908691