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.44769763946533

# Query Time
(1) connect 0.00078892707824707
(2) DESCRIBE `cruises` 0.0030081272125244
(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.0014050006866455
(4) DESCRIBE `cruises` 0.0027430057525635
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66004') 0.00032281875610352
(6) DESCRIBE `ships` 0.0024909973144531
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00033020973205566
(8) DESCRIBE `ships` 0.0030708312988281
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00027298927307129
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025701522827148
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024700164794922
(12) DESCRIBE `itineraries` 0.001255989074707
(13) DESCRIBE `ports` 0.0012619495391846
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035595893859863
(15) DESCRIBE `ports` 0.0012261867523193
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028204917907715
(17) DESCRIBE `ports` 0.0015840530395508
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026798248291016
(19) DESCRIBE `sailingdates` 0.0011608600616455
(20) DESCRIBE `ports` 0.0015599727630615
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030398368835449
(22) DESCRIBE `ports` 0.0013167858123779
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00032687187194824
(24) DESCRIBE `ports` 0.0012590885162354
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00032997131347656
(26) DESCRIBE `ports` 0.0014200210571289
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00026798248291016
(28) DESCRIBE `ports` 0.0012581348419189
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4208))) 0.00029397010803223
(30) DESCRIBE `ports` 0.0012528896331787
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4208') 0.00027704238891602
(32) DESCRIBE `ports` 0.0012221336364746
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00028586387634277
(34) DESCRIBE `ports` 0.0013189315795898
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00026798248291016
(36) DESCRIBE `ports` 0.0012462139129639
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00029611587524414
(38) DESCRIBE `ports` 0.0013298988342285
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00028204917907715
(40) DESCRIBE `ports` 0.0014238357543945
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032401084899902
(42) DESCRIBE `ports` 0.0012929439544678
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027108192443848
(44) DESCRIBE `avid_specials` 0.0013999938964844
(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.0015668869018555
(46) DESCRIBE `cruiselines` 0.0022029876708984
(47) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00039005279541016
(48) DESCRIBE `orchid_image` 0.001507043838501
(49) DESCRIBE `cruiselines` 0.0019729137420654
(50) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0002901554107666
(51) DESCRIBE `cruises` 0.0023820400238037
(52) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65893') 0.00030088424682617
(53) DESCRIBE `ships` 0.002418041229248
(54) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00042104721069336
(55) DESCRIBE `ships` 0.0024080276489258
(56) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00029897689819336
(57) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028896331787109
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024914741516113
(59) DESCRIBE `itineraries` 0.0011968612670898
(60) DESCRIBE `ports` 0.0013442039489746
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029993057250977
(62) DESCRIBE `ports` 0.0012240409851074
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029611587524414
(64) DESCRIBE `ports` 0.001227855682373
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026702880859375
(66) DESCRIBE `sailingdates` 0.0010969638824463
(67) DESCRIBE `ports` 0.0012340545654297
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028586387634277
(69) DESCRIBE `ports` 0.00124192237854
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027084350585938
(71) DESCRIBE `ports` 0.0012240409851074
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00028419494628906
(73) DESCRIBE `ports` 0.0013358592987061
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00026798248291016
(75) DESCRIBE `ports` 0.0015320777893066
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00028800964355469
(77) DESCRIBE `ports` 0.0012550354003906
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00027894973754883
(79) DESCRIBE `ports` 0.0012249946594238
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00028514862060547
(81) DESCRIBE `ports` 0.001291036605835
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00027084350585938
(83) DESCRIBE `ports` 0.0012280941009521
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00027894973754883
(85) DESCRIBE `ports` 0.0012679100036621
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.0002589225769043
(87) DESCRIBE `ports` 0.001230001449585
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038504600524902
(89) DESCRIBE `ports` 0.0012478828430176
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027298927307129
(91) DESCRIBE `avid_specials` 0.0010969638824463
(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.0010368824005127
(93) DESCRIBE `cruiselines` 0.0017778873443604
(94) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00031399726867676
(95) DESCRIBE `orchid_image` 0.0013999938964844
(96) DESCRIBE `cruiselines` 0.0017790794372559
(97) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00027298927307129
(98) DESCRIBE `cruises` 0.0028111934661865
(99) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66005') 0.00033879280090332
(100) DESCRIBE `ships` 0.0026137828826904
(101) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00040102005004883
(102) DESCRIBE `ships` 0.0027198791503906
(103) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00035500526428223
(104) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026297569274902
(105) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025105476379395
(106) DESCRIBE `itineraries` 0.001305103302002
(107) DESCRIBE `ports` 0.0012450218200684
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034499168395996
(109) DESCRIBE `ports` 0.0013339519500732
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031185150146484
(111) DESCRIBE `ports` 0.0012598037719727
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029921531677246
(113) DESCRIBE `sailingdates` 0.0011370182037354
(114) DESCRIBE `ports` 0.0013651847839355
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034284591674805
(116) DESCRIBE `ports` 0.0013859272003174
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028800964355469
(118) DESCRIBE `ports` 0.0012331008911133
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00044989585876465
(120) DESCRIBE `ports` 0.0014328956604004
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00030803680419922
(122) DESCRIBE `ports` 0.0014979839324951
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0003049373626709
(124) DESCRIBE `ports` 0.0012688636779785
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00027799606323242
(126) DESCRIBE `ports` 0.0013589859008789
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00030207633972168
(128) DESCRIBE `ports` 0.0013489723205566
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.0002739429473877
(130) DESCRIBE `ports` 0.001223087310791
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00029993057250977
(132) DESCRIBE `ports` 0.0013580322265625
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00026893615722656
(134) DESCRIBE `ports` 0.0012259483337402
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00030994415283203
(136) DESCRIBE `ports` 0.0014700889587402
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00037598609924316
(138) DESCRIBE `avid_specials` 0.0015609264373779
(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.0016810894012451
(140) DESCRIBE `cruiselines` 0.0023350715637207
(141) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00037097930908203
(142) DESCRIBE `orchid_image` 0.0015978813171387
(143) DESCRIBE `cruiselines` 0.0019140243530273
(144) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00032496452331543
(145) DESCRIBE `cruises` 0.0025420188903809
(146) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50866') 0.00030422210693359
(147) DESCRIBE `ships` 0.0025670528411865
(148) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00035715103149414
(149) DESCRIBE `ships` 0.0025179386138916
(150) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00028204917907715
(151) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027012825012207
(152) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033283233642578
(153) DESCRIBE `itineraries` 0.0013329982757568
(154) DESCRIBE `ports` 0.0013198852539062
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003209114074707
(156) DESCRIBE `ports` 0.0012919902801514
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029206275939941
(158) DESCRIBE `ports` 0.0013008117675781
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027894973754883
(160) DESCRIBE `sailingdates` 0.0011098384857178
(161) DESCRIBE `ports` 0.0015308856964111
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032186508178711
(163) DESCRIBE `ports` 0.0013477802276611
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037407875061035
(165) DESCRIBE `ports` 0.001262903213501
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00031709671020508
(167) DESCRIBE `ports` 0.0013101100921631
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00033187866210938
(169) DESCRIBE `ports` 0.0012400150299072
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00029206275939941
(171) DESCRIBE `ports` 0.0013208389282227
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00028181076049805
(173) DESCRIBE `ports` 0.0013198852539062
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00030899047851562
(175) DESCRIBE `ports` 0.0012619495391846
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00027990341186523
(177) DESCRIBE `ports` 0.0014340877532959
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033807754516602
(179) DESCRIBE `ports` 0.0013158321380615
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031805038452148
(181) DESCRIBE `avid_specials` 0.0011970996856689
(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.0010440349578857
(183) DESCRIBE `cruiselines` 0.0020310878753662
(184) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00033903121948242
(185) DESCRIBE `orchid_image` 0.001694917678833
(186) DESCRIBE `cruiselines` 0.0018918514251709
(187) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00032711029052734
(188) DESCRIBE `cruises` 0.0024690628051758
(189) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65894') 0.00033807754516602
(190) DESCRIBE `ships` 0.0032260417938232
(191) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00044584274291992
(192) DESCRIBE `ships` 0.0029721260070801
(193) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0003809928894043
(194) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028300285339355
(195) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002591609954834
(196) DESCRIBE `itineraries` 0.0013799667358398
(197) DESCRIBE `ports` 0.0015919208526611
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044107437133789
(199) DESCRIBE `ports` 0.0012660026550293
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029516220092773
(201) DESCRIBE `ports` 0.0012960433959961
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028300285339355
(203) DESCRIBE `sailingdates` 0.0010981559753418
(204) DESCRIBE `ports` 0.0012850761413574
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030398368835449
(206) DESCRIBE `ports` 0.0012359619140625
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003058910369873
(208) DESCRIBE `ports` 0.001317024230957
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00030803680419922
(210) DESCRIBE `ports` 0.0012531280517578
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00028300285339355
(212) DESCRIBE `ports` 0.0012898445129395
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00030207633972168
(214) DESCRIBE `ports` 0.0012531280517578
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.0002751350402832
(216) DESCRIBE `ports` 0.0013229846954346
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00032186508178711
(218) DESCRIBE `ports` 0.0012898445129395
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00030803680419922
(220) DESCRIBE `ports` 0.0015361309051514
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0003819465637207
(222) DESCRIBE `ports` 0.001798152923584
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00034594535827637
(224) DESCRIBE `ports` 0.0016248226165771
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035595893859863
(226) DESCRIBE `ports` 0.0012869834899902
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036215782165527
(228) DESCRIBE `avid_specials` 0.0015900135040283
(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.0016520023345947
(230) DESCRIBE `cruiselines` 0.0024619102478027
(231) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00036096572875977
(232) DESCRIBE `orchid_image` 0.0015010833740234
(233) DESCRIBE `cruiselines` 0.002730131149292
(234) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0004279613494873
(235) DESCRIBE `cruises` 0.0029218196868896
(236) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66006') 0.0003969669342041
(237) DESCRIBE `ships` 0.002669095993042
(238) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00043582916259766
(239) DESCRIBE `ships` 0.0031731128692627
(240) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00048398971557617
(241) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034999847412109
(242) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033783912658691
(243) DESCRIBE `itineraries` 0.0018990039825439
(244) DESCRIBE `ports` 0.0014388561248779
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00040006637573242
(246) DESCRIBE `ports` 0.0014238357543945
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00032305717468262
(248) DESCRIBE `ports` 0.0013861656188965
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00033688545227051
(250) DESCRIBE `sailingdates` 0.0014438629150391
(251) DESCRIBE `ports` 0.0015931129455566
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00043988227844238
(253) DESCRIBE `ports` 0.0016419887542725
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00034499168395996
(255) DESCRIBE `ports` 0.0014238357543945
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00039100646972656
(257) DESCRIBE `ports` 0.0014989376068115
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00033688545227051
(259) DESCRIBE `ports` 0.0013811588287354
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00043487548828125
(261) DESCRIBE `ports` 0.0018441677093506
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00041508674621582
(263) DESCRIBE `ports` 0.0013360977172852
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00042915344238281
(265) DESCRIBE `ports` 0.0014421939849854
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.0003209114074707
(267) DESCRIBE `ports` 0.0014898777008057
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0003972053527832
(269) DESCRIBE `ports` 0.0012938976287842
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00027799606323242
(271) DESCRIBE `avid_specials` 0.0011360645294189
(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.0010900497436523
(273) DESCRIBE `cruiselines` 0.0021541118621826
(274) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00035905838012695
(275) DESCRIBE `orchid_image` 0.0017430782318115
(276) DESCRIBE `cruiselines` 0.0020439624786377
(277) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00034999847412109
(278) DESCRIBE `cruises` 0.0026159286499023
(279) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65896') 0.00034809112548828
(280) DESCRIBE `ships` 0.0028390884399414
(281) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00049400329589844
(282) DESCRIBE `ships` 0.0036640167236328
(283) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00047802925109863
(284) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035405158996582
(285) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034499168395996
(286) DESCRIBE `itineraries` 0.0014829635620117
(287) DESCRIBE `ports` 0.0013790130615234
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035810470581055
(289) DESCRIBE `ports` 0.0013811588287354
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047397613525391
(291) DESCRIBE `ports` 0.0017468929290771
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037193298339844
(293) DESCRIBE `sailingdates` 0.0015199184417725
(294) DESCRIBE `ports` 0.0017681121826172
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041294097900391
(296) DESCRIBE `ports` 0.0017728805541992
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036215782165527
(298) DESCRIBE `ports` 0.0018138885498047
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00035810470581055
(300) DESCRIBE `ports` 0.0013430118560791
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00027894973754883
(302) DESCRIBE `ports` 0.0012919902801514
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00030303001403809
(304) DESCRIBE `ports` 0.001284122467041
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00034499168395996
(306) DESCRIBE `ports` 0.0014910697937012
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.00040912628173828
(308) DESCRIBE `ports` 0.0016441345214844
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.00037693977355957
(310) DESCRIBE `ports` 0.0016419887542725
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00037384033203125
(312) DESCRIBE `ports` 0.0014281272888184
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00036191940307617
(314) DESCRIBE `ports` 0.0018548965454102
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00042510032653809
(316) DESCRIBE `ports` 0.0016419887542725
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00031590461730957
(318) DESCRIBE `ports` 0.001439094543457
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037479400634766
(320) DESCRIBE `ports` 0.0015602111816406
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00032687187194824
(322) DESCRIBE `avid_specials` 0.0012819766998291
(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.0010228157043457
(324) DESCRIBE `cruiselines` 0.0019240379333496
(325) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00030612945556641
(326) DESCRIBE `orchid_image` 0.0013840198516846
(327) DESCRIBE `cruiselines` 0.001802921295166
(328) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00027108192443848
(329) DESCRIBE `cruises` 0.0024869441986084
(330) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63400') 0.00029277801513672
(331) DESCRIBE `ships` 0.0025420188903809
(332) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00035190582275391
(333) DESCRIBE `ships` 0.0024769306182861
(334) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.0002739429473877
(335) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026392936706543
(336) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036907196044922
(337) DESCRIBE `itineraries` 0.0012238025665283
(338) DESCRIBE `ports` 0.0013589859008789
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00031709671020508
(340) DESCRIBE `ports` 0.0013561248779297
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00029778480529785
(342) DESCRIBE `ports` 0.001288890838623
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00031208992004395
(344) DESCRIBE `sailingdates` 0.0010991096496582
(345) DESCRIBE `ports` 0.0013999938964844
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00031399726867676
(347) DESCRIBE `ports` 0.0012919902801514
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00028204917907715
(349) DESCRIBE `ports` 0.0012350082397461
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00029802322387695
(351) DESCRIBE `ports` 0.0012891292572021
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00027203559875488
(353) DESCRIBE `avid_specials` 0.0011250972747803
(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.0009911060333252
(355) DESCRIBE `cruiselines` 0.0019218921661377
(356) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00030612945556641
(357) DESCRIBE `orchid_image` 0.0014100074768066
(358) DESCRIBE `cruiselines` 0.0018050670623779
(359) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00028896331787109
(360) DESCRIBE `cruises` 0.002418041229248
(361) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66007') 0.00029420852661133
(362) DESCRIBE `ships` 0.0024888515472412
(363) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00033402442932129
(364) DESCRIBE `ships` 0.0024569034576416
(365) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00026297569274902
(366) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026297569274902
(367) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025296211242676
(368) DESCRIBE `itineraries` 0.0012030601501465
(369) DESCRIBE `ports` 0.0012950897216797
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00030398368835449
(371) DESCRIBE `ports` 0.0012359619140625
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00046801567077637
(373) DESCRIBE `ports` 0.001284122467041
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00028085708618164
(375) DESCRIBE `sailingdates` 0.0010969638824463
(376) DESCRIBE `ports` 0.0012969970703125
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00029778480529785
(378) DESCRIBE `ports` 0.0013070106506348
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00027298927307129
(380) DESCRIBE `ports` 0.0012500286102295
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00028800964355469
(382) DESCRIBE `ports` 0.0014760494232178
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00038504600524902
(384) DESCRIBE `ports` 0.0012800693511963
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030994415283203
(386) DESCRIBE `ports` 0.0013148784637451
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044798851013184
(388) DESCRIBE `avid_specials` 0.0011100769042969
(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.0011341571807861
(390) DESCRIBE `cruiselines` 0.0018048286437988
(391) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00032186508178711
(392) DESCRIBE `orchid_image` 0.0014510154724121
(393) DESCRIBE `cruiselines` 0.0017809867858887
(394) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00026607513427734
(395) DESCRIBE `cruises` 0.0025780200958252
(396) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41776') 0.00028204917907715
(397) DESCRIBE `ships` 0.0024709701538086
(398) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00036191940307617
(399) DESCRIBE `ships` 0.0025198459625244
(400) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0002741813659668
(401) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026488304138184
(402) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025296211242676
(403) DESCRIBE `itineraries` 0.0013480186462402
(404) DESCRIBE `ports` 0.0012450218200684
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033998489379883
(406) DESCRIBE `ports` 0.0012750625610352
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029802322387695
(408) DESCRIBE `ports` 0.001230001449585
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027203559875488
(410) DESCRIBE `sailingdates` 0.0011281967163086
(411) DESCRIBE `ports` 0.0012729167938232
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031304359436035
(413) DESCRIBE `ports` 0.0012390613555908
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028109550476074
(415) DESCRIBE `ports` 0.00142502784729
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00037407875061035
(417) DESCRIBE `ports` 0.0013620853424072
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00028896331787109
(419) DESCRIBE `ports` 0.00124192237854
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0002901554107666
(421) DESCRIBE `ports` 0.0012500286102295
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00027108192443848
(423) DESCRIBE `ports` 0.0012679100036621
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00028896331787109
(425) DESCRIBE `ports` 0.0012941360473633
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00029301643371582
(427) DESCRIBE `ports` 0.0012450218200684
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029802322387695
(429) DESCRIBE `ports` 0.0013129711151123
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026893615722656
(431) DESCRIBE `avid_specials` 0.001121997833252
(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.0010530948638916
(433) DESCRIBE `cruiselines` 0.0017971992492676
(434) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0003209114074707
(435) DESCRIBE `orchid_image` 0.0014419555664062
(436) DESCRIBE `cruiselines` 0.0017440319061279
(437) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00026702880859375
(438) DESCRIBE `ships` 0.0025570392608643
(439) SELECT `ships`.* FROM `ships` WHERE (id IN ('4', '1722', '288')) ORDER BY FIND_IN_SET(id, '4,1722,288') 0.00071310997009277
(440) DESCRIBE `cruisetypes` 0.001025915145874
(441) DESCRIBE `destinations` 0.001615047454834
(442) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.00048208236694336
(443) DESCRIBE `cruiselines` 0.0020201206207275
(444) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00036406517028809
(445) DESCRIBE `cruiselines` 0.0021579265594482
(446) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00031805038452148