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

Total elapsed time: 0.50021123886108

# Query Time
(1) connect 0.0011539459228516
(2) DESCRIBE `cruises` 0.0030570030212402
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (29065, 51446, 62566, 74886, 51415, 64368, 70160, 51426, 59080, 51457)) ORDER BY FIND_IN_SET(id, '29065,51446,62566,74886,51415,64368,70160,51426,59080,51457') 0.0016820430755615
(4) DESCRIBE `cruises` 0.0030758380889893
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '29065') 0.00039196014404297
(6) DESCRIBE `ships` 0.0032739639282227
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.00046801567077637
(8) DESCRIBE `ships` 0.003140926361084
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00035309791564941
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030922889709473
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029206275939941
(12) DESCRIBE `itineraries` 0.0016310214996338
(13) DESCRIBE `ports` 0.0020620822906494
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00035810470581055
(15) DESCRIBE `ports` 0.0019700527191162
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00032305717468262
(17) DESCRIBE `ports` 0.0014247894287109
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00029897689819336
(19) DESCRIBE `sailingdates` 0.0015151500701904
(20) DESCRIBE `ports` 0.0019948482513428
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0005040168762207
(22) DESCRIBE `ports` 0.0020380020141602
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00040292739868164
(24) DESCRIBE `ports` 0.0014522075653076
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00029706954956055
(26) DESCRIBE `ports` 0.0014128684997559
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00034785270690918
(28) DESCRIBE `avid_specials` 0.0015699863433838
(29) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 29065 and class = 'Cruise') OR (item_id = 573 AND class = 'Ship') OR (item_id = 37 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.0018188953399658
(30) DESCRIBE `cruiselines` 0.002593994140625
(31) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00044798851013184
(32) DESCRIBE `orchid_image` 0.0022940635681152
(33) DESCRIBE `cruiselines` 0.001945972442627
(34) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00034403800964355
(35) DESCRIBE `cruises` 0.002701997756958
(36) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '51446') 0.00035881996154785
(37) DESCRIBE `ships` 0.002514123916626
(38) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1285))) 0.00033998489379883
(39) DESCRIBE `ships` 0.0028040409088135
(40) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1285') 0.00029897689819336
(41) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026416778564453
(42) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00024795532226562
(43) DESCRIBE `itineraries` 0.0014760494232178
(44) DESCRIBE `ports` 0.0017330646514893
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042486190795898
(46) DESCRIBE `ports` 0.0017828941345215
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033807754516602
(48) DESCRIBE `ports` 0.0013229846954346
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030994415283203
(50) DESCRIBE `sailingdates` 0.0017998218536377
(51) DESCRIBE `ports` 0.0015687942504883
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030303001403809
(53) DESCRIBE `ports` 0.0012938976287842
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029587745666504
(55) DESCRIBE `ports` 0.001284122467041
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00039291381835938
(57) DESCRIBE `ports` 0.0020627975463867
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00041484832763672
(59) DESCRIBE `ports` 0.0016689300537109
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035786628723145
(61) DESCRIBE `ports` 0.0016341209411621
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003669261932373
(63) DESCRIBE `avid_specials` 0.0014691352844238
(64) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 51446 and class = 'Cruise') OR (item_id = 1285 AND class = 'Ship') OR (item_id = 37 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.0017409324645996
(65) DESCRIBE `cruiselines` 0.0024080276489258
(66) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00040102005004883
(67) DESCRIBE `orchid_image` 0.0019710063934326
(68) DESCRIBE `cruiselines` 0.0028409957885742
(69) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00043320655822754
(70) DESCRIBE `cruises` 0.0038039684295654
(71) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62566') 0.0004420280456543
(72) DESCRIBE `ships` 0.0047938823699951
(73) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.00045394897460938
(74) DESCRIBE `ships` 0.0028340816497803
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00032401084899902
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026798248291016
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025296211242676
(78) DESCRIBE `itineraries` 0.0014991760253906
(79) DESCRIBE `ports` 0.001708984375
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00045585632324219
(81) DESCRIBE `ports` 0.0014610290527344
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00037407875061035
(83) DESCRIBE `ports` 0.0016810894012451
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00037384033203125
(85) DESCRIBE `sailingdates` 0.0016160011291504
(86) DESCRIBE `ports` 0.0017721652984619
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00036096572875977
(88) DESCRIBE `ports` 0.0013999938964844
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00028395652770996
(90) DESCRIBE `ports` 0.0014629364013672
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00039792060852051
(92) DESCRIBE `ports` 0.001676082611084
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00034999847412109
(94) DESCRIBE `ports` 0.0016429424285889
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00037288665771484
(96) DESCRIBE `ports` 0.0017158985137939
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00036501884460449
(98) DESCRIBE `avid_specials` 0.001561164855957
(99) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62566 and class = 'Cruise') OR (item_id = 573 AND class = 'Ship') OR (item_id = 37 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.0016880035400391
(100) DESCRIBE `cruiselines` 0.0024259090423584
(101) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00043797492980957
(102) DESCRIBE `orchid_image` 0.0019440650939941
(103) DESCRIBE `cruiselines` 0.0024778842926025
(104) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00046420097351074
(105) DESCRIBE `cruises` 0.0033249855041504
(106) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74886') 0.0003960132598877
(107) DESCRIBE `ships` 0.0033619403839111
(108) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1285))) 0.00043201446533203
(109) DESCRIBE `ships` 0.0032958984375
(110) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1285') 0.00034689903259277
(111) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00032496452331543
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00032806396484375
(113) DESCRIBE `itineraries` 0.0016109943389893
(114) DESCRIBE `ports` 0.0016791820526123
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032520294189453
(116) DESCRIBE `ports` 0.0012450218200684
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029993057250977
(118) DESCRIBE `ports` 0.0012691020965576
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00048398971557617
(120) DESCRIBE `sailingdates` 0.0014450550079346
(121) DESCRIBE `ports` 0.0017800331115723
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039887428283691
(123) DESCRIBE `ports` 0.0016870498657227
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034689903259277
(125) DESCRIBE `ports` 0.0017170906066895
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0003659725189209
(127) DESCRIBE `ports` 0.0016579627990723
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00037312507629395
(129) DESCRIBE `ports` 0.0015850067138672
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00036501884460449
(131) DESCRIBE `ports` 0.0017039775848389
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00033283233642578
(133) DESCRIBE `ports` 0.001662015914917
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00038003921508789
(135) DESCRIBE `ports` 0.0016641616821289
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00040602684020996
(137) DESCRIBE `ports` 0.0016648769378662
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037503242492676
(139) DESCRIBE `ports` 0.0016889572143555
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00033879280090332
(141) DESCRIBE `avid_specials` 0.0015640258789062
(142) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74886 and class = 'Cruise') OR (item_id = 1285 AND class = 'Ship') OR (item_id = 37 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.0012121200561523
(143) DESCRIBE `cruiselines` 0.0017979145050049
(144) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00031709671020508
(145) DESCRIBE `orchid_image` 0.0013811588287354
(146) DESCRIBE `cruiselines` 0.0017778873443604
(147) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00026702880859375
(148) DESCRIBE `cruises` 0.0023918151855469
(149) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '51415') 0.00028085708618164
(150) DESCRIBE `ships` 0.002471923828125
(151) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.00034880638122559
(152) DESCRIBE `ships` 0.0027711391448975
(153) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00029301643371582
(154) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026583671569824
(155) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00025200843811035
(156) DESCRIBE `itineraries` 0.0015828609466553
(157) DESCRIBE `ports` 0.0012738704681396
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00034189224243164
(159) DESCRIBE `ports` 0.0012459754943848
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00029802322387695
(161) DESCRIBE `ports` 0.001276969909668
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00027608871459961
(163) DESCRIBE `sailingdates` 0.001101016998291
(164) DESCRIBE `ports` 0.0012819766998291
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00030994415283203
(166) DESCRIBE `ports` 0.0018601417541504
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00044393539428711
(168) DESCRIBE `ports` 0.0018808841705322
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 499))) 0.00044894218444824
(170) DESCRIBE `ports` 0.0018439292907715
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '499') 0.00039315223693848
(172) DESCRIBE `ports` 0.0019278526306152
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00046515464782715
(174) DESCRIBE `ports` 0.0019361972808838
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00040817260742188
(176) DESCRIBE `ports` 0.0018680095672607
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.0003969669342041
(178) DESCRIBE `ports` 0.0019440650939941
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00059700012207031
(180) DESCRIBE `ports` 0.0018899440765381
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00043797492980957
(182) DESCRIBE `ports` 0.0016529560089111
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00034904479980469
(184) DESCRIBE `ports` 0.0015718936920166
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0002899169921875
(186) DESCRIBE `ports` 0.0012679100036621
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00026893615722656
(188) DESCRIBE `avid_specials` 0.0010950565338135
(189) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 51415 and class = 'Cruise') OR (item_id = 1284 AND class = 'Ship') OR (item_id = 37 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.0010769367218018
(190) DESCRIBE `cruiselines` 0.0020029544830322
(191) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00029802322387695
(192) DESCRIBE `orchid_image` 0.0013940334320068
(193) DESCRIBE `cruiselines` 0.0017449855804443
(194) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00026512145996094
(195) DESCRIBE `cruises` 0.0028989315032959
(196) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64368') 0.00043511390686035
(197) DESCRIBE `ships` 0.0035932064056396
(198) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.00046110153198242
(199) DESCRIBE `ships` 0.0034470558166504
(200) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00053906440734863
(201) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036787986755371
(202) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033402442932129
(203) DESCRIBE `itineraries` 0.0019211769104004
(204) DESCRIBE `ports` 0.0019960403442383
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00066494941711426
(206) DESCRIBE `ports` 0.0019800662994385
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00050592422485352
(208) DESCRIBE `ports` 0.0019440650939941
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00042104721069336
(210) DESCRIBE `sailingdates` 0.0017139911651611
(211) DESCRIBE `ports` 0.0021510124206543
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00048398971557617
(213) DESCRIBE `ports` 0.0019798278808594
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00055789947509766
(215) DESCRIBE `ports` 0.001878023147583
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00038290023803711
(217) DESCRIBE `ports` 0.0015621185302734
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00033807754516602
(219) DESCRIBE `ports` 0.0017030239105225
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00036787986755371
(221) DESCRIBE `ports` 0.0012979507446289
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00033807754516602
(223) DESCRIBE `ports` 0.0017001628875732
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00039482116699219
(225) DESCRIBE `ports` 0.0017411708831787
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00037503242492676
(227) DESCRIBE `ports` 0.0017690658569336
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00044989585876465
(229) DESCRIBE `ports` 0.0019538402557373
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0003819465637207
(231) DESCRIBE `avid_specials` 0.0013229846954346
(232) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64368 and class = 'Cruise') OR (item_id = 573 AND class = 'Ship') OR (item_id = 37 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
(233) DESCRIBE `cruiselines` 0.0026600360870361
(234) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00061893463134766
(235) DESCRIBE `orchid_image` 0.0023760795593262
(236) DESCRIBE `cruiselines` 0.0026419162750244
(237) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.0004580020904541
(238) DESCRIBE `cruises` 0.0035960674285889
(239) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70160') 0.00044107437133789
(240) DESCRIBE `ships` 0.0038309097290039
(241) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 765))) 0.00059390068054199
(242) DESCRIBE `ships` 0.0038180351257324
(243) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '765') 0.0005340576171875
(244) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034499168395996
(245) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0003349781036377
(246) DESCRIBE `itineraries` 0.001640796661377
(247) DESCRIBE `ports` 0.0019447803497314
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00039100646972656
(249) DESCRIBE `ports` 0.0017650127410889
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0004889965057373
(251) DESCRIBE `ports` 0.0015380382537842
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00035691261291504
(253) DESCRIBE `sailingdates` 0.0014650821685791
(254) DESCRIBE `ports` 0.0013771057128906
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00051188468933105
(256) DESCRIBE `ports` 0.0016839504241943
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00040388107299805
(258) DESCRIBE `ports` 0.0014579296112061
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.00034809112548828
(260) DESCRIBE `ports` 0.001399040222168
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.00033998489379883
(262) DESCRIBE `ports` 0.0013120174407959
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1319))) 0.00043487548828125
(264) DESCRIBE `ports` 0.0015788078308105
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1319') 0.00030183792114258
(266) DESCRIBE `ports` 0.0013978481292725
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 791))) 0.00031614303588867
(268) DESCRIBE `ports` 0.0012719631195068
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '791') 0.00030899047851562
(270) DESCRIBE `ports` 0.0012729167938232
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4650))) 0.00062799453735352
(272) DESCRIBE `ports` 0.0017578601837158
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4650') 0.0003359317779541
(274) DESCRIBE `ports` 0.0016560554504395
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5306))) 0.00039005279541016
(276) DESCRIBE `ports` 0.0013179779052734
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5306') 0.0003359317779541
(278) DESCRIBE `ports` 0.0016617774963379
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00047421455383301
(280) DESCRIBE `ports` 0.0017609596252441
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00037813186645508
(282) DESCRIBE `avid_specials` 0.0014760494232178
(283) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70160 and class = 'Cruise') OR (item_id = 765 AND class = 'Ship') OR (item_id = 37 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.0016939640045166
(284) DESCRIBE `cruiselines` 0.0024721622467041
(285) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00043892860412598
(286) DESCRIBE `orchid_image` 0.0020480155944824
(287) DESCRIBE `cruiselines` 0.0025467872619629
(288) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.0004119873046875
(289) DESCRIBE `cruises` 0.0035669803619385
(290) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '51426') 0.00039505958557129
(291) DESCRIBE `ships` 0.0028312206268311
(292) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.00054001808166504
(293) DESCRIBE `ships` 0.0026769638061523
(294) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00042295455932617
(295) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00034594535827637
(296) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00032782554626465
(297) DESCRIBE `itineraries` 0.0018119812011719
(298) DESCRIBE `ports` 0.0018730163574219
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00043320655822754
(300) DESCRIBE `ports` 0.0017039775848389
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00040102005004883
(302) DESCRIBE `ports` 0.0017499923706055
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00039005279541016
(304) DESCRIBE `sailingdates` 0.0015268325805664
(305) DESCRIBE `ports` 0.0017769336700439
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00043201446533203
(307) DESCRIBE `ports` 0.0015749931335449
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00039100646972656
(309) DESCRIBE `ports` 0.0014939308166504
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00034189224243164
(311) DESCRIBE `ports` 0.0015161037445068
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00028800964355469
(313) DESCRIBE `ports` 0.0013678073883057
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00060796737670898
(315) DESCRIBE `ports` 0.0020029544830322
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00039792060852051
(317) DESCRIBE `ports` 0.0018770694732666
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.00040197372436523
(319) DESCRIBE `ports` 0.0019168853759766
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.00040888786315918
(321) DESCRIBE `ports` 0.0019521713256836
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00047612190246582
(323) DESCRIBE `ports` 0.001816987991333
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00039792060852051
(325) DESCRIBE `avid_specials` 0.0016911029815674
(326) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 51426 and class = 'Cruise') OR (item_id = 1284 AND class = 'Ship') OR (item_id = 37 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.0018398761749268
(327) DESCRIBE `cruiselines` 0.0027370452880859
(328) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00067400932312012
(329) DESCRIBE `orchid_image` 0.0022859573364258
(330) DESCRIBE `cruiselines` 0.0020480155944824
(331) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00032305717468262
(332) DESCRIBE `cruises` 0.0028061866760254
(333) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59080') 0.00043916702270508
(334) DESCRIBE `ships` 0.0029230117797852
(335) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.0005948543548584
(336) DESCRIBE `ships` 0.0027167797088623
(337) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00030994415283203
(338) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028300285339355
(339) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030994415283203
(340) DESCRIBE `itineraries` 0.0013999938964844
(341) DESCRIBE `ports` 0.0014169216156006
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00034904479980469
(343) DESCRIBE `ports` 0.0014848709106445
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00039982795715332
(345) DESCRIBE `ports` 0.0013659000396729
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00032496452331543
(347) DESCRIBE `sailingdates` 0.0012269020080566
(348) DESCRIBE `ports` 0.0017521381378174
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00041818618774414
(350) DESCRIBE `ports` 0.0017731189727783
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00040102005004883
(352) DESCRIBE `ports` 0.0016560554504395
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00039792060852051
(354) DESCRIBE `ports` 0.0017168521881104
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00029206275939941
(356) DESCRIBE `ports` 0.0014979839324951
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00031495094299316
(358) DESCRIBE `ports` 0.001248836517334
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00027298927307129
(360) DESCRIBE `ports` 0.0012800693511963
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00029778480529785
(362) DESCRIBE `ports` 0.0013370513916016
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00028610229492188
(364) DESCRIBE `avid_specials` 0.0011680126190186
(365) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59080 and class = 'Cruise') OR (item_id = 573 AND class = 'Ship') OR (item_id = 37 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.0013039112091064
(366) DESCRIBE `cruiselines` 0.0020458698272705
(367) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00032401084899902
(368) DESCRIBE `orchid_image` 0.0014469623565674
(369) DESCRIBE `cruiselines` 0.0020039081573486
(370) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00030398368835449
(371) DESCRIBE `cruises` 0.0024979114532471
(372) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '51457') 0.00030899047851562
(373) DESCRIBE `ships` 0.0026059150695801
(374) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1285))) 0.00034499168395996
(375) DESCRIBE `ships` 0.0027730464935303
(376) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1285') 0.00027799606323242
(377) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026988983154297
(378) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026392936706543
(379) DESCRIBE `itineraries` 0.0012800693511963
(380) DESCRIBE `ports` 0.0012929439544678
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032496452331543
(382) DESCRIBE `ports` 0.0012412071228027
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030899047851562
(384) DESCRIBE `ports` 0.0013248920440674
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028514862060547
(386) DESCRIBE `sailingdates` 0.0011119842529297
(387) DESCRIBE `ports` 0.00174880027771
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00050783157348633
(389) DESCRIBE `ports` 0.0015928745269775
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00033998489379883
(391) DESCRIBE `ports` 0.0012931823730469
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00040197372436523
(393) DESCRIBE `ports` 0.0012831687927246
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00032687187194824
(395) DESCRIBE `ports` 0.0016000270843506
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00035905838012695
(397) DESCRIBE `ports` 0.0013699531555176
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00029397010803223
(399) DESCRIBE `ports` 0.0013091564178467
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0003349781036377
(401) DESCRIBE `ports` 0.0012741088867188
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00029993057250977
(403) DESCRIBE `ports` 0.0013341903686523
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038480758666992
(405) DESCRIBE `ports` 0.0013339519500732
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030088424682617
(407) DESCRIBE `avid_specials` 0.0011279582977295
(408) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 51457 and class = 'Cruise') OR (item_id = 1285 AND class = 'Ship') OR (item_id = 37 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.0010008811950684
(409) DESCRIBE `cruiselines` 0.0018320083618164
(410) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00032281875610352
(411) DESCRIBE `orchid_image` 0.0015249252319336
(412) DESCRIBE `cruiselines` 0.0019638538360596
(413) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00029683113098145
(414) DESCRIBE `ships` 0.0029199123382568
(415) SELECT `ships`.* FROM `ships` WHERE (id IN ('573', '1284', '1402', '1285', '765')) ORDER BY FIND_IN_SET(id, '573,1284,1402,1285,765') 0.00078105926513672
(416) DESCRIBE `cruisetypes` 0.0011239051818848
(417) DESCRIBE `destinations` 0.0019350051879883
(418) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('8', '43', '35')) ORDER BY FIND_IN_SET(id, '8,43,35') 0.00097894668579102
(419) DESCRIBE `cruiselines` 0.0027351379394531
(420) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00039005279541016
(421) DESCRIBE `cruiselines` 0.0019400119781494
(422) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00034403800964355