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

Total elapsed time: 0.7536313533783

# Query Time
(1) connect 0.0010018348693848
(2) DESCRIBE `cruises` 0.0041561126708984
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (65603, 67956, 66183, 59379, 67311, 67944, 69080, 70029, 73138, 67312)) ORDER BY FIND_IN_SET(id, '65603,67956,66183,59379,67311,67944,69080,70029,73138,67312') 0.0027627944946289
(4) DESCRIBE `cruises` 0.0038261413574219
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65603') 0.00046992301940918
(6) DESCRIBE `ships` 0.0033278465270996
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1415))) 0.00045394897460938
(8) DESCRIBE `ships` 0.0027790069580078
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1415') 0.00034689903259277
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.0002589225769043
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00024700164794922
(12) DESCRIBE `itineraries` 0.0013840198516846
(13) DESCRIBE `ports` 0.0015609264373779
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0003359317779541
(15) DESCRIBE `ports` 0.0017130374908447
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00040197372436523
(17) DESCRIBE `ports` 0.0017359256744385
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00035285949707031
(19) DESCRIBE `sailingdates` 0.0011630058288574
(20) DESCRIBE `ports` 0.0014951229095459
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00035309791564941
(22) DESCRIBE `ports` 0.0013370513916016
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00031495094299316
(24) DESCRIBE `ports` 0.0013008117675781
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00032186508178711
(26) DESCRIBE `ports` 0.0014870166778564
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.0002739429473877
(28) DESCRIBE `ports` 0.0012919902801514
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00031805038452148
(30) DESCRIBE `ports` 0.0015950202941895
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.0003359317779541
(32) DESCRIBE `ports` 0.0016911029815674
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00047206878662109
(34) DESCRIBE `ports` 0.0014901161193848
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00031208992004395
(36) DESCRIBE `ports` 0.0012600421905518
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00031805038452148
(38) DESCRIBE `ports` 0.0014948844909668
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00029301643371582
(40) DESCRIBE `ports` 0.0013132095336914
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00035905838012695
(42) DESCRIBE `ports` 0.001507043838501
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00033116340637207
(44) DESCRIBE `ports` 0.0014679431915283
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00029492378234863
(46) DESCRIBE `ports` 0.0013399124145508
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00030803680419922
(48) DESCRIBE `ports` 0.0013000965118408
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00030112266540527
(50) DESCRIBE `ports` 0.0013570785522461
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00026798248291016
(52) DESCRIBE `ports` 0.0013198852539062
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00030303001403809
(54) DESCRIBE `ports` 0.0013368129730225
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00030016899108887
(56) DESCRIBE `ports` 0.0013070106506348
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00031495094299316
(58) DESCRIBE `ports` 0.0018799304962158
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00040984153747559
(60) DESCRIBE `avid_specials` 0.0016231536865234
(61) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65603 and class = 'Cruise') OR (item_id = 1415 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0014388561248779
(62) DESCRIBE `cruiselines` 0.0020208358764648
(63) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00033998489379883
(64) DESCRIBE `orchid_image` 0.001410961151123
(65) DESCRIBE `cruiselines` 0.0018448829650879
(66) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0003049373626709
(67) DESCRIBE `cruises` 0.0024950504302979
(68) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67956') 0.00037598609924316
(69) DESCRIBE `ships` 0.0036380290985107
(70) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 452))) 0.0003809928894043
(71) DESCRIBE `ships` 0.0026099681854248
(72) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '452') 0.00030088424682617
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026416778564453
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002899169921875
(75) DESCRIBE `itineraries` 0.0015101432800293
(76) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67956') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011050701141357
(77) DESCRIBE `ports` 0.0014200210571289
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00032901763916016
(79) DESCRIBE `ports` 0.0014560222625732
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00033402442932129
(81) DESCRIBE `ports` 0.0014221668243408
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00029993057250977
(83) DESCRIBE `sailingdates` 0.0013039112091064
(84) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67956') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00097298622131348
(85) DESCRIBE `ports` 0.0015468597412109
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00030803680419922
(87) DESCRIBE `ports` 0.0014100074768066
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00026917457580566
(89) DESCRIBE `ports` 0.010833978652954
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00055909156799316
(91) DESCRIBE `ports` 0.0018131732940674
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.0003349781036377
(93) DESCRIBE `ports` 0.001323938369751
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00030398368835449
(95) DESCRIBE `ports` 0.0013129711151123
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00039887428283691
(97) DESCRIBE `ports` 0.0022749900817871
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00031018257141113
(99) DESCRIBE `ports` 0.0036590099334717
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00030303001403809
(101) DESCRIBE `ports` 0.0012829303741455
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00028300285339355
(103) DESCRIBE `ports` 0.001230001449585
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00025606155395508
(105) DESCRIBE `ports` 0.0012710094451904
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00028800964355469
(107) DESCRIBE `ports` 0.0012271404266357
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00026988983154297
(109) DESCRIBE `ports` 0.0053820610046387
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00030612945556641
(111) DESCRIBE `ports` 0.0014090538024902
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.0040619373321533
(113) DESCRIBE `ports` 0.0014209747314453
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00031876564025879
(115) DESCRIBE `ports` 0.0012538433074951
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.0089449882507324
(117) DESCRIBE `ports` 0.0015008449554443
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00030994415283203
(119) DESCRIBE `ports` 0.011373043060303
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.0045609474182129
(121) DESCRIBE `ports` 0.0015401840209961
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 344))) 0.00033307075500488
(123) DESCRIBE `ports` 0.0013358592987061
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '344') 0.00030398368835449
(125) DESCRIBE `ports` 0.0061609745025635
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00034189224243164
(127) DESCRIBE `ports` 0.0051229000091553
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00033402442932129
(129) DESCRIBE `ports` 0.0013370513916016
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00054693222045898
(131) DESCRIBE `ports` 0.0013179779052734
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00028896331787109
(133) DESCRIBE `ports` 0.0013341903686523
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00027918815612793
(135) DESCRIBE `ports` 0.0012919902801514
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00034093856811523
(137) DESCRIBE `avid_specials` 0.0014820098876953
(138) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67956 and class = 'Cruise') OR (item_id = 452 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010459423065186
(139) DESCRIBE `cruiselines` 0.010869979858398
(140) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00032997131347656
(141) DESCRIBE `orchid_image` 0.0014760494232178
(142) DESCRIBE `cruiselines` 0.0018179416656494
(143) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00027704238891602
(144) DESCRIBE `cruises` 0.0025069713592529
(145) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66183') 0.00028800964355469
(146) DESCRIBE `ships` 0.0025119781494141
(147) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 766))) 0.00034189224243164
(148) DESCRIBE `ships` 0.0026998519897461
(149) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '766') 0.0002901554107666
(150) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034403800964355
(151) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002591609954834
(152) DESCRIBE `itineraries` 0.0014150142669678
(153) DESCRIBE `ports` 0.0026960372924805
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00033402442932129
(155) DESCRIBE `ports` 0.0012850761413574
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00027894973754883
(157) DESCRIBE `ports` 0.0020649433135986
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00027298927307129
(159) DESCRIBE `sailingdates` 0.0011558532714844
(160) DESCRIBE `ports` 0.0086688995361328
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00034403800964355
(162) DESCRIBE `ports` 0.0097208023071289
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00037217140197754
(164) DESCRIBE `ports` 0.0019440650939941
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00034904479980469
(166) DESCRIBE `ports` 0.0021359920501709
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00041508674621582
(168) DESCRIBE `ports` 0.0023009777069092
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.0032978057861328
(170) DESCRIBE `ports` 0.001762866973877
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.00027894973754883
(172) DESCRIBE `ports` 0.001305103302002
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1842))) 0.00037598609924316
(174) DESCRIBE `ports` 0.0014760494232178
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1842') 0.00028514862060547
(176) DESCRIBE `ports` 0.0013689994812012
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00029611587524414
(178) DESCRIBE `ports` 0.0014290809631348
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00029182434082031
(180) DESCRIBE `ports` 0.0017139911651611
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00031805038452148
(182) DESCRIBE `ports` 0.001600980758667
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00035691261291504
(184) DESCRIBE `ports` 0.0014369487762451
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00032806396484375
(186) DESCRIBE `ports` 0.0019490718841553
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00042080879211426
(188) DESCRIBE `ports` 0.0015599727630615
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00034403800964355
(190) DESCRIBE `ports` 0.0013759136199951
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00027298927307129
(192) DESCRIBE `ports` 0.0013899803161621
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00031113624572754
(194) DESCRIBE `ports` 0.0017712116241455
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00032401084899902
(196) DESCRIBE `avid_specials` 0.0016369819641113
(197) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66183 and class = 'Cruise') OR (item_id = 766 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010089874267578
(198) DESCRIBE `cruiselines` 0.0020151138305664
(199) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0003349781036377
(200) DESCRIBE `orchid_image` 0.0014858245849609
(201) DESCRIBE `cruiselines` 0.0018517971038818
(202) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00028800964355469
(203) DESCRIBE `cruises` 0.0026500225067139
(204) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59379') 0.00032901763916016
(205) DESCRIBE `ships` 0.0026910305023193
(206) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 452))) 0.00037503242492676
(207) DESCRIBE `ships` 0.0032031536102295
(208) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '452') 0.00028491020202637
(209) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026488304138184
(210) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027012825012207
(211) DESCRIBE `itineraries` 0.0015289783477783
(212) DESCRIBE `ports` 0.0013329982757568
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00029397010803223
(214) DESCRIBE `ports` 0.0012519359588623
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00028800964355469
(216) DESCRIBE `ports` 0.0014171600341797
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00026297569274902
(218) DESCRIBE `sailingdates` 0.0014278888702393
(219) DESCRIBE `ports` 0.0014050006866455
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00037598609924316
(221) DESCRIBE `ports` 0.0017600059509277
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00037789344787598
(223) DESCRIBE `ports` 0.0015718936920166
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00029301643371582
(225) DESCRIBE `ports` 0.0012810230255127
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00026416778564453
(227) DESCRIBE `ports` 0.0015571117401123
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00030684471130371
(229) DESCRIBE `ports` 0.0013730525970459
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.0002741813659668
(231) DESCRIBE `ports` 0.0019471645355225
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00031208992004395
(233) DESCRIBE `ports` 0.0013840198516846
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00027704238891602
(235) DESCRIBE `ports` 0.0012550354003906
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00029897689819336
(237) DESCRIBE `ports` 0.0017549991607666
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.0002598762512207
(239) DESCRIBE `ports` 0.0012600421905518
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00033402442932129
(241) DESCRIBE `ports` 0.0014128684997559
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00028014183044434
(243) DESCRIBE `ports` 0.010180950164795
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00035905838012695
(245) DESCRIBE `ports` 0.0013508796691895
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.0052499771118164
(247) DESCRIBE `avid_specials` 0.0014011859893799
(248) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59379 and class = 'Cruise') OR (item_id = 452 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011041164398193
(249) DESCRIBE `cruiselines` 0.0021131038665771
(250) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00033712387084961
(251) DESCRIBE `orchid_image` 0.013446807861328
(252) DESCRIBE `cruiselines` 0.0020270347595215
(253) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00033020973205566
(254) DESCRIBE `cruises` 0.002532958984375
(255) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67311') 0.00029802322387695
(256) DESCRIBE `ships` 0.0027260780334473
(257) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00088596343994141
(258) DESCRIBE `ships` 0.0028729438781738
(259) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00032496452331543
(260) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026798248291016
(261) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026082992553711
(262) DESCRIBE `itineraries` 0.0013411045074463
(263) DESCRIBE `ports` 0.0016441345214844
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00044798851013184
(265) DESCRIBE `ports` 0.0014321804046631
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.0003359317779541
(267) DESCRIBE `ports` 0.0013890266418457
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00035500526428223
(269) DESCRIBE `sailingdates` 0.0014529228210449
(270) DESCRIBE `ports` 0.0015430450439453
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00035810470581055
(272) DESCRIBE `ports` 0.0013680458068848
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00029802322387695
(274) DESCRIBE `ports` 0.0013790130615234
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00032210350036621
(276) DESCRIBE `ports` 0.0017158985137939
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00037097930908203
(278) DESCRIBE `ports` 0.0013589859008789
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00032687187194824
(280) DESCRIBE `ports` 0.0013659000396729
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00030708312988281
(282) DESCRIBE `ports` 0.001417875289917
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00034213066101074
(284) DESCRIBE `ports` 0.0013771057128906
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00037097930908203
(286) DESCRIBE `ports` 0.0017449855804443
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00038504600524902
(288) DESCRIBE `ports` 0.0017409324645996
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00037288665771484
(290) DESCRIBE `ports` 0.001708984375
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00043916702270508
(292) DESCRIBE `ports` 0.0017368793487549
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00037908554077148
(294) DESCRIBE `ports` 0.0017449855804443
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00039815902709961
(296) DESCRIBE `ports` 0.0017180442810059
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00035405158996582
(298) DESCRIBE `ports` 0.0018007755279541
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00044989585876465
(300) DESCRIBE `ports` 0.0013320446014404
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00029206275939941
(302) DESCRIBE `avid_specials` 0.0012140274047852
(303) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67311 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0024349689483643
(304) DESCRIBE `cruiselines` 0.0029239654541016
(305) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00046396255493164
(306) DESCRIBE `orchid_image` 0.0020029544830322
(307) DESCRIBE `cruiselines` 0.0025408267974854
(308) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00038909912109375
(309) DESCRIBE `cruises` 0.0033390522003174
(310) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67944') 0.00047898292541504
(311) DESCRIBE `ships` 0.0034220218658447
(312) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 407))) 0.00049710273742676
(313) DESCRIBE `ships` 0.0036180019378662
(314) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '407') 0.00044012069702148
(315) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034284591674805
(316) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033211708068848
(317) DESCRIBE `itineraries` 0.0017580986022949
(318) DESCRIBE `ports` 0.0017991065979004
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00044703483581543
(320) DESCRIBE `ports` 0.0017199516296387
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00047707557678223
(322) DESCRIBE `ports` 0.0019021034240723
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00040507316589355
(324) DESCRIBE `sailingdates` 0.001655101776123
(325) DESCRIBE `ports` 0.001971960067749
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00044488906860352
(327) DESCRIBE `ports` 0.0018370151519775
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00037908554077148
(329) DESCRIBE `ports` 0.0018880367279053
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.0004270076751709
(331) DESCRIBE `ports` 0.0014269351959229
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00033283233642578
(333) DESCRIBE `ports` 0.001291036605835
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00035500526428223
(335) DESCRIBE `ports` 0.0012428760528564
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00031399726867676
(337) DESCRIBE `ports` 0.0013418197631836
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00033783912658691
(339) DESCRIBE `ports` 0.0013480186462402
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00028705596923828
(341) DESCRIBE `ports` 0.0014729499816895
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00030779838562012
(343) DESCRIBE `ports` 0.0012497901916504
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00036478042602539
(345) DESCRIBE `ports` 0.0012671947479248
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00032305717468262
(347) DESCRIBE `ports` 0.0013220310211182
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00028181076049805
(349) DESCRIBE `ports` 0.001349925994873
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00032711029052734
(351) DESCRIBE `ports` 0.0015370845794678
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.0003809928894043
(353) DESCRIBE `ports` 0.0017118453979492
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.0003199577331543
(355) DESCRIBE `ports` 0.0016560554504395
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00039792060852051
(357) DESCRIBE `avid_specials` 0.0011498928070068
(358) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67944 and class = 'Cruise') OR (item_id = 407 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010881423950195
(359) DESCRIBE `cruiselines` 0.0019330978393555
(360) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00038385391235352
(361) DESCRIBE `orchid_image` 0.0014238357543945
(362) DESCRIBE `cruiselines` 0.0018479824066162
(363) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00029611587524414
(364) DESCRIBE `cruises` 0.0033218860626221
(365) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69080') 0.00034403800964355
(366) DESCRIBE `ships` 0.0024881362915039
(367) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1588))) 0.0003969669342041
(368) DESCRIBE `ships` 0.0024528503417969
(369) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1588') 0.00029993057250977
(370) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026607513427734
(371) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025510787963867
(372) DESCRIBE `itineraries` 0.0012860298156738
(373) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69080') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00069999694824219
(374) DESCRIBE `ports` 0.0013089179992676
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00048017501831055
(376) DESCRIBE `ports` 0.0012640953063965
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.0002899169921875
(378) DESCRIBE `ports` 0.0014090538024902
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00028014183044434
(380) DESCRIBE `sailingdates` 0.0011029243469238
(381) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69080') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00079679489135742
(382) DESCRIBE `ports` 0.0013430118560791
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00032997131347656
(384) DESCRIBE `ports` 0.0013630390167236
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00029993057250977
(386) DESCRIBE `ports` 0.0012519359588623
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00030112266540527
(388) DESCRIBE `ports` 0.001384973526001
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.0059409141540527
(390) DESCRIBE `ports` 0.0041089057922363
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00033092498779297
(392) DESCRIBE `ports` 0.0013010501861572
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.0010550022125244
(394) DESCRIBE `ports` 0.0013711452484131
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00068092346191406
(396) DESCRIBE `ports` 0.0014090538024902
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00028300285339355
(398) DESCRIBE `ports` 0.0012848377227783
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00048494338989258
(400) DESCRIBE `ports` 0.0012719631195068
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00031900405883789
(402) DESCRIBE `ports` 0.0013668537139893
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00036096572875977
(404) DESCRIBE `ports` 0.0012600421905518
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0002739429473877
(406) DESCRIBE `ports` 0.0013220310211182
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00030183792114258
(408) DESCRIBE `ports` 0.0013329982757568
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00027704238891602
(410) DESCRIBE `avid_specials` 0.0011308193206787
(411) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69080 and class = 'Cruise') OR (item_id = 1588 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011429786682129
(412) DESCRIBE `cruiselines` 0.0019841194152832
(413) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00031900405883789
(414) DESCRIBE `orchid_image` 0.0014760494232178
(415) DESCRIBE `cruiselines` 0.0019559860229492
(416) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00072693824768066
(417) DESCRIBE `cruises` 0.0036468505859375
(418) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70029') 0.00048589706420898
(419) DESCRIBE `ships` 0.0036518573760986
(420) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1415))) 0.00061678886413574
(421) DESCRIBE `ships` 0.0037109851837158
(422) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1415') 0.00048303604125977
(423) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00034689903259277
(424) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.0003819465637207
(425) DESCRIBE `itineraries` 0.0017809867858887
(426) DESCRIBE `ports` 0.0019237995147705
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00058913230895996
(428) DESCRIBE `ports` 0.0017569065093994
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00042986869812012
(430) DESCRIBE `ports` 0.0018699169158936
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00039100646972656
(432) DESCRIBE `sailingdates` 0.0015699863433838
(433) DESCRIBE `ports` 0.0018060207366943
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046801567077637
(435) DESCRIBE `ports` 0.0017600059509277
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00039386749267578
(437) DESCRIBE `ports` 0.0017318725585938
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00047087669372559
(439) DESCRIBE `ports` 0.0017468929290771
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00038981437683105
(441) DESCRIBE `ports` 0.0018608570098877
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00035619735717773
(443) DESCRIBE `ports` 0.0015499591827393
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00032520294189453
(445) DESCRIBE `ports` 0.0015149116516113
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00046086311340332
(447) DESCRIBE `ports` 0.0014088153839111
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00033688545227051
(449) DESCRIBE `ports` 0.0016059875488281
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00039005279541016
(451) DESCRIBE `ports` 0.0015549659729004
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00034809112548828
(453) DESCRIBE `ports` 0.0015411376953125
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00047397613525391
(455) DESCRIBE `ports` 0.0018980503082275
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00047802925109863
(457) DESCRIBE `avid_specials` 0.0016918182373047
(458) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70029 and class = 'Cruise') OR (item_id = 1415 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018858909606934
(459) DESCRIBE `cruiselines` 0.0028080940246582
(460) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0005028247833252
(461) DESCRIBE `orchid_image` 0.002039909362793
(462) DESCRIBE `cruiselines` 0.0025508403778076
(463) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00050210952758789
(464) DESCRIBE `cruises` 0.0039880275726318
(465) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73138') 0.00068902969360352
(466) DESCRIBE `ships` 0.003525972366333
(467) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 352))) 0.00055503845214844
(468) DESCRIBE `ships` 0.003209114074707
(469) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '352') 0.00044488906860352
(470) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036501884460449
(471) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033903121948242
(472) DESCRIBE `itineraries` 0.0018649101257324
(473) DESCRIBE `ports` 0.0019230842590332
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 764))) 0.00047993659973145
(475) DESCRIBE `ports` 0.0018100738525391
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 764))) 0.00042915344238281
(477) DESCRIBE `ports` 0.0018119812011719
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '764') 0.0004420280456543
(479) DESCRIBE `sailingdates` 0.0016920566558838
(480) DESCRIBE `ports` 0.0014989376068115
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 764))) 0.00038504600524902
(482) DESCRIBE `ports` 0.0016720294952393
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '764') 0.00035381317138672
(484) DESCRIBE `ports` 0.0017468929290771
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00033378601074219
(486) DESCRIBE `ports` 0.0014410018920898
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00035715103149414
(488) DESCRIBE `ports` 0.0014588832855225
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 534))) 0.00034999847412109
(490) DESCRIBE `ports` 0.0015270709991455
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '534') 0.00032901763916016
(492) DESCRIBE `ports` 0.0016679763793945
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00034999847412109
(494) DESCRIBE `ports` 0.0013420581817627
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00037002563476562
(496) DESCRIBE `ports` 0.0014700889587402
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00035905838012695
(498) DESCRIBE `ports` 0.001878023147583
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00049114227294922
(500) DESCRIBE `ports` 0.0019600391387939
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0004880428314209
(502) DESCRIBE `ports` 0.0023541450500488
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00050091743469238
(504) DESCRIBE `ports` 0.0019750595092773
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 764))) 0.00044608116149902
(506) DESCRIBE `ports` 0.0018439292907715
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '764') 0.00042200088500977
(508) DESCRIBE `avid_specials` 0.0016250610351562
(509) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73138 and class = 'Cruise') OR (item_id = 352 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0020661354064941
(510) DESCRIBE `cruiselines` 0.0029430389404297
(511) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00051593780517578
(512) DESCRIBE `orchid_image` 0.0020530223846436
(513) DESCRIBE `cruiselines` 0.0028700828552246
(514) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00065302848815918
(515) DESCRIBE `cruises` 0.0036859512329102
(516) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67312') 0.00047516822814941
(517) DESCRIBE `ships` 0.0036880970001221
(518) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00058388710021973
(519) DESCRIBE `ships` 0.0033848285675049
(520) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00042390823364258
(521) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027704238891602
(522) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029182434082031
(523) DESCRIBE `itineraries` 0.0014288425445557
(524) DESCRIBE `ports` 0.0013871192932129
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00042414665222168
(526) DESCRIBE `ports` 0.0016260147094727
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00040507316589355
(528) DESCRIBE `ports` 0.0018551349639893
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00040602684020996
(530) DESCRIBE `sailingdates` 0.0012671947479248
(531) DESCRIBE `ports` 0.0016729831695557
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00044488906860352
(533) DESCRIBE `ports` 0.0016889572143555
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00033307075500488
(535) DESCRIBE `ports` 0.0013670921325684
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00034785270690918
(537) DESCRIBE `ports` 0.001460075378418
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00032401084899902
(539) DESCRIBE `ports` 0.0012528896331787
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00030994415283203
(541) DESCRIBE `ports` 0.0016579627990723
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00032401084899902
(543) DESCRIBE `ports` 0.0014829635620117
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.0004429817199707
(545) DESCRIBE `ports` 0.0017938613891602
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.0003669261932373
(547) DESCRIBE `ports` 0.0012929439544678
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00033807754516602
(549) DESCRIBE `ports` 0.0014960765838623
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00034999847412109
(551) DESCRIBE `ports` 0.0017189979553223
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.0004730224609375
(553) DESCRIBE `ports` 0.0017631053924561
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00039815902709961
(555) DESCRIBE `ports` 0.0017919540405273
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00044012069702148
(557) DESCRIBE `ports` 0.001812219619751
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00041484832763672
(559) DESCRIBE `ports` 0.0017671585083008
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00043296813964844
(561) DESCRIBE `ports` 0.0017821788787842
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0004279613494873
(563) DESCRIBE `avid_specials` 0.0013871192932129
(564) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67312 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018010139465332
(565) DESCRIBE `cruiselines` 0.0026528835296631
(566) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0005040168762207
(567) DESCRIBE `orchid_image` 0.002079963684082
(568) DESCRIBE `cruiselines` 0.002769947052002
(569) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00047087669372559
(570) DESCRIBE `ships` 0.0034489631652832
(571) SELECT `ships`.* FROM `ships` WHERE (id IN ('977', '1359', '1599', '1067', '1588', '407', '726', '462', '1415', '766', '452', '674', '553', '1717', '738', '352', '610')) ORDER BY FIND_IN_SET(id, '977,1359,1599,1067,1588,407,726,462,1415,766,452,674,553,1717,738,352,610') 0.002108097076416
(572) DESCRIBE `cruisetypes` 0.0015771389007568
(573) DESCRIBE `destinations` 0.0022461414337158
(574) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '45', '26', '25', '37', '28', '52', '38', '40', '9', '49', '11', '21', '35')) ORDER BY FIND_IN_SET(id, '22,12,45,26,25,37,28,52,38,40,9,49,11,21,35') 0.0012550354003906
(575) DESCRIBE `cruiselines` 0.0023229122161865
(576) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00041103363037109
(577) DESCRIBE `cruiselines` 0.0018842220306396
(578) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00035810470581055