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

Total elapsed time: 0.71054768562317

# Query Time
(1) connect 0.0010318756103516
(2) DESCRIBE `cruises` 0.0041220188140869
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (68562, 68562, 62066, 62066, 68451, 68564, 62062, 68473, 68565, 68474)) ORDER BY FIND_IN_SET(id, '68562,68562,62066,62066,68451,68564,62062,68473,68565,68474') 0.0019359588623047
(4) DESCRIBE `specials` 0.005558967590332
(5) DESCRIBE `specials` 0.0050740242004395
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1480605') 0.00073885917663574
(7) DESCRIBE `ships` 0.0035691261291504
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1262))) 0.00050497055053711
(9) DESCRIBE `ships` 0.00357985496521
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1262') 0.00046706199645996
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003209114074707
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032401084899902
(13) DESCRIBE `itineraries` 0.0016160011291504
(14) DESCRIBE `ports` 0.00211501121521
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00046801567077637
(16) DESCRIBE `ports` 0.0018801689147949
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00030398368835449
(18) DESCRIBE `ports` 0.0012760162353516
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00031685829162598
(20) DESCRIBE `specialsailingdates` 0.001323938369751
(21) DESCRIBE `sailingdates` 0.001147985458374
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 431868))) 0.00047397613525391
(23) DESCRIBE `ports` 0.0013480186462402
(24) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00031304359436035
(25) DESCRIBE `ports` 0.0012428760528564
(26) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00029897689819336
(27) DESCRIBE `ports` 0.0014829635620117
(28) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00042510032653809
(29) DESCRIBE `ports` 0.0015969276428223
(30) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00035405158996582
(31) DESCRIBE `ports` 0.0016601085662842
(32) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1263))) 0.00039005279541016
(33) DESCRIBE `ports` 0.00177001953125
(34) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1263') 0.00035309791564941
(35) DESCRIBE `ports` 0.0017940998077393
(36) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00040912628173828
(37) DESCRIBE `ports` 0.0017428398132324
(38) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00035595893859863
(39) DESCRIBE `ports` 0.0017848014831543
(40) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.00038599967956543
(41) DESCRIBE `ports` 0.0017528533935547
(42) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00037622451782227
(43) DESCRIBE `ports` 0.0013940334320068
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 160))) 0.00030398368835449
(45) DESCRIBE `ports` 0.0012640953063965
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '160') 0.00027084350585938
(47) DESCRIBE `ports` 0.0017509460449219
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2087))) 0.00031399726867676
(49) DESCRIBE `ports` 0.0016899108886719
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2087') 0.00031399726867676
(51) DESCRIBE `ports` 0.0014479160308838
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00028300285339355
(53) DESCRIBE `ports` 0.0012938976287842
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00031495094299316
(55) DESCRIBE `cruises` 0.0027811527252197
(56) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 68562))) 0.00054407119750977
(57) DESCRIBE `avid_specials` 0.001690149307251
(58) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1480605 and class = 'Special') OR (item_id = 68562 and class = 'Cruise') OR (item_id = 1262 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.0011708736419678
(59) DESCRIBE `cruiselines` 0.0026490688323975
(60) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00034999847412109
(61) DESCRIBE `orchid_image` 0.0014779567718506
(62) DESCRIBE `cruiselines` 0.0023410320281982
(63) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00035214424133301
(64) DESCRIBE `cruises` 0.003615140914917
(65) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68562') 0.00046014785766602
(66) DESCRIBE `ships` 0.0040509700775146
(67) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1262))) 0.0005488395690918
(68) DESCRIBE `ships` 0.0037810802459717
(69) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1262') 0.00032901763916016
(70) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00028300285339355
(71) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032901763916016
(72) DESCRIBE `itineraries` 0.0016758441925049
(73) DESCRIBE `ports` 0.001323938369751
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00039505958557129
(75) DESCRIBE `ports` 0.0016379356384277
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.0004580020904541
(77) DESCRIBE `ports` 0.0016629695892334
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00037407875061035
(79) DESCRIBE `sailingdates` 0.001507043838501
(80) DESCRIBE `ports` 0.0016131401062012
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00035405158996582
(82) DESCRIBE `ports` 0.00124192237854
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00027799606323242
(84) DESCRIBE `ports` 0.0013010501861572
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00031495094299316
(86) DESCRIBE `ports` 0.0012989044189453
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00030088424682617
(88) DESCRIBE `ports` 0.0014009475708008
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1263))) 0.00030207633972168
(90) DESCRIBE `ports` 0.0013060569763184
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1263') 0.00027084350585938
(92) DESCRIBE `ports` 0.0012898445129395
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00029897689819336
(94) DESCRIBE `ports` 0.0012288093566895
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00031304359436035
(96) DESCRIBE `ports` 0.0013158321380615
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.00030112266540527
(98) DESCRIBE `ports` 0.0013000965118408
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00029897689819336
(100) DESCRIBE `ports` 0.0012331008911133
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 160))) 0.00029897689819336
(102) DESCRIBE `ports` 0.0013930797576904
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '160') 0.00027012825012207
(104) DESCRIBE `ports` 0.0013198852539062
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2087))) 0.00030279159545898
(106) DESCRIBE `ports` 0.0012989044189453
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2087') 0.00026798248291016
(108) DESCRIBE `ports` 0.0012328624725342
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00033402442932129
(110) DESCRIBE `ports` 0.0013399124145508
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00028085708618164
(112) DESCRIBE `avid_specials` 0.0011091232299805
(113) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68562 and class = 'Cruise') OR (item_id = 1262 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.0011000633239746
(114) DESCRIBE `cruiselines` 0.0018560886383057
(115) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00030398368835449
(116) DESCRIBE `orchid_image` 0.0014269351959229
(117) DESCRIBE `cruiselines` 0.0017690658569336
(118) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00026702880859375
(119) DESCRIBE `specials` 0.0038390159606934
(120) DESCRIBE `specials` 0.003403902053833
(121) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1480537') 0.00034284591674805
(122) DESCRIBE `ships` 0.0024650096893311
(123) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1262))) 0.00035190582275391
(124) DESCRIBE `ships` 0.0024030208587646
(125) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1262') 0.00027084350585938
(126) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026202201843262
(127) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026988983154297
(128) DESCRIBE `itineraries` 0.0012109279632568
(129) DESCRIBE `ports` 0.0013880729675293
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00037193298339844
(131) DESCRIBE `ports` 0.0012838840484619
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00027799606323242
(133) DESCRIBE `ports` 0.0012691020965576
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00026512145996094
(135) DESCRIBE `specialsailingdates` 0.0010409355163574
(136) DESCRIBE `sailingdates` 0.001147985458374
(137) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 431869))) 0.00030708312988281
(138) DESCRIBE `sailingdates` 0.0011038780212402
(139) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 431870))) 0.00029587745666504
(140) DESCRIBE `ports` 0.001244068145752
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00028181076049805
(142) DESCRIBE `ports` 0.0012331008911133
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00031900405883789
(144) DESCRIBE `ports` 0.0013279914855957
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00037288665771484
(146) DESCRIBE `ports` 0.001276969909668
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.0002739429473877
(148) DESCRIBE `ports` 0.001291036605835
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00040507316589355
(150) DESCRIBE `ports` 0.0017337799072266
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00037407875061035
(152) DESCRIBE `ports` 0.0017490386962891
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2087))) 0.00039505958557129
(154) DESCRIBE `ports` 0.0018599033355713
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2087') 0.00038409233093262
(156) DESCRIBE `ports` 0.0015380382537842
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4696))) 0.00031805038452148
(158) DESCRIBE `ports` 0.0012640953063965
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4696') 0.0002741813659668
(160) DESCRIBE `ports` 0.0013949871063232
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 160))) 0.00029301643371582
(162) DESCRIBE `ports` 0.0015931129455566
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '160') 0.00028204917907715
(164) DESCRIBE `ports` 0.0014219284057617
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.00035810470581055
(166) DESCRIBE `ports` 0.0012669563293457
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00027298927307129
(168) DESCRIBE `ports` 0.001276969909668
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00030398368835449
(170) DESCRIBE `ports` 0.0012362003326416
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00032210350036621
(172) DESCRIBE `ports` 0.0012459754943848
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00030303001403809
(174) DESCRIBE `ports` 0.001237154006958
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00027203559875488
(176) DESCRIBE `ports` 0.001255989074707
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00027799606323242
(178) DESCRIBE `ports` 0.0012891292572021
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.0002601146697998
(180) DESCRIBE `cruises` 0.0027310848236084
(181) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 62066))) 0.00038695335388184
(182) DESCRIBE `avid_specials` 0.0011191368103027
(183) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1480537 and class = 'Special') OR (item_id = 62066 and class = 'Cruise') OR (item_id = 1262 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.00098204612731934
(184) DESCRIBE `cruiselines` 0.0017960071563721
(185) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00031876564025879
(186) DESCRIBE `orchid_image` 0.0014820098876953
(187) DESCRIBE `cruiselines` 0.0018181800842285
(188) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00027894973754883
(189) DESCRIBE `cruises` 0.0024888515472412
(190) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62066') 0.00032305717468262
(191) DESCRIBE `ships` 0.0024878978729248
(192) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1262))) 0.00038695335388184
(193) DESCRIBE `ships` 0.0024428367614746
(194) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1262') 0.00028085708618164
(195) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026702880859375
(196) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025510787963867
(197) DESCRIBE `itineraries` 0.0014479160308838
(198) DESCRIBE `ports` 0.0012810230255127
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00030517578125
(200) DESCRIBE `ports` 0.0012938976287842
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00030016899108887
(202) DESCRIBE `ports` 0.0012569427490234
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00026798248291016
(204) DESCRIBE `sailingdates` 0.0011670589447021
(205) DESCRIBE `ports` 0.0012669563293457
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00034904479980469
(207) DESCRIBE `ports` 0.001291036605835
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00028705596923828
(209) DESCRIBE `ports` 0.0012941360473633
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00030303001403809
(211) DESCRIBE `ports` 0.0012500286102295
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00027298927307129
(213) DESCRIBE `ports` 0.0012991428375244
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00030183792114258
(215) DESCRIBE `ports` 0.0012519359588623
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00027179718017578
(217) DESCRIBE `ports` 0.0013298988342285
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2087))) 0.00031495094299316
(219) DESCRIBE `ports` 0.0012950897216797
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2087') 0.00034594535827637
(221) DESCRIBE `ports` 0.0013210773468018
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4696))) 0.00031685829162598
(223) DESCRIBE `ports` 0.001460075378418
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4696') 0.00033187866210938
(225) DESCRIBE `ports` 0.0014829635620117
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 160))) 0.0003809928894043
(227) DESCRIBE `ports` 0.0015339851379395
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '160') 0.00032210350036621
(229) DESCRIBE `ports` 0.0014958381652832
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.0003659725189209
(231) DESCRIBE `ports` 0.0015039443969727
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00032401084899902
(233) DESCRIBE `ports` 0.0015020370483398
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00036191940307617
(235) DESCRIBE `ports` 0.0016531944274902
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00033998489379883
(237) DESCRIBE `ports` 0.0014982223510742
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00041103363037109
(239) DESCRIBE `ports` 0.0015170574188232
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00032687187194824
(241) DESCRIBE `ports` 0.0016288757324219
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00041389465332031
(243) DESCRIBE `ports` 0.0015838146209717
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00032591819763184
(245) DESCRIBE `avid_specials` 0.0013449192047119
(246) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62066 and class = 'Cruise') OR (item_id = 1262 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.001662015914917
(247) DESCRIBE `cruiselines` 0.0022258758544922
(248) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.0004119873046875
(249) DESCRIBE `orchid_image` 0.0014522075653076
(250) DESCRIBE `cruiselines` 0.0018119812011719
(251) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00030517578125
(252) DESCRIBE `cruises` 0.0025260448455811
(253) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68451') 0.0003361701965332
(254) DESCRIBE `ships` 0.0026428699493408
(255) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 796))) 0.00037503242492676
(256) DESCRIBE `ships` 0.0024669170379639
(257) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '796') 0.00037193298339844
(258) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026488304138184
(259) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025415420532227
(260) DESCRIBE `itineraries` 0.0012328624725342
(261) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68451') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0019078254699707
(262) DESCRIBE `ports` 0.001446008682251
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00033307075500488
(264) DESCRIBE `ports` 0.0013880729675293
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00031709671020508
(266) DESCRIBE `ports` 0.0014150142669678
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00028491020202637
(268) DESCRIBE `sailingdates` 0.0011279582977295
(269) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68451') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00076007843017578
(270) DESCRIBE `ports` 0.0016560554504395
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00035715103149414
(272) DESCRIBE `ports` 0.0012819766998291
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00027894973754883
(274) DESCRIBE `ports` 0.0013749599456787
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1026))) 0.0003359317779541
(276) DESCRIBE `ports` 0.0012500286102295
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1026') 0.00030016899108887
(278) DESCRIBE `ports` 0.0012788772583008
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2483))) 0.0003199577331543
(280) DESCRIBE `ports` 0.0013279914855957
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2483') 0.00029206275939941
(282) DESCRIBE `ports` 0.0013031959533691
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00033283233642578
(284) DESCRIBE `ports` 0.0014128684997559
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00029492378234863
(286) DESCRIBE `ports` 0.0013220310211182
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1263))) 0.00037813186645508
(288) DESCRIBE `ports` 0.0013279914855957
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1263') 0.00030899047851562
(290) DESCRIBE `ports` 0.0012588500976562
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00036907196044922
(292) DESCRIBE `ports` 0.0012860298156738
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00029611587524414
(294) DESCRIBE `ports` 0.0013461112976074
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00031900405883789
(296) DESCRIBE `ports` 0.0013091564178467
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00027894973754883
(298) DESCRIBE `ports` 0.0014190673828125
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.0003209114074707
(300) DESCRIBE `ports` 0.0012540817260742
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00027894973754883
(302) DESCRIBE `ports` 0.0012760162353516
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 320))) 0.00045990943908691
(304) DESCRIBE `ports` 0.0014879703521729
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '320') 0.0002899169921875
(306) DESCRIBE `ports` 0.0013830661773682
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00047898292541504
(308) DESCRIBE `ports` 0.0012969970703125
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00031495094299316
(310) DESCRIBE `ports` 0.0015521049499512
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00043106079101562
(312) DESCRIBE `ports` 0.0014450550079346
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00029110908508301
(314) DESCRIBE `ports` 0.0012710094451904
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00031805038452148
(316) DESCRIBE `ports` 0.0013229846954346
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00027585029602051
(318) DESCRIBE `avid_specials` 0.0015459060668945
(319) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68451 and class = 'Cruise') OR (item_id = 796 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.0018291473388672
(320) DESCRIBE `cruiselines` 0.0024209022521973
(321) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00040316581726074
(322) DESCRIBE `orchid_image` 0.0015320777893066
(323) DESCRIBE `cruiselines` 0.0021929740905762
(324) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00030207633972168
(325) DESCRIBE `cruises` 0.0034708976745605
(326) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68564') 0.00043296813964844
(327) DESCRIBE `ships` 0.0036518573760986
(328) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1073))) 0.00049090385437012
(329) DESCRIBE `ships` 0.0036091804504395
(330) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1073') 0.00038886070251465
(331) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026988983154297
(332) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025796890258789
(333) DESCRIBE `itineraries` 0.0013070106506348
(334) DESCRIBE `ports` 0.0019750595092773
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00046420097351074
(336) DESCRIBE `ports` 0.0018579959869385
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00046396255493164
(338) DESCRIBE `ports` 0.0018179416656494
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00036382675170898
(340) DESCRIBE `sailingdates` 0.0016570091247559
(341) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68564') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00087714195251465
(342) DESCRIBE `ports` 0.002100944519043
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00044417381286621
(344) DESCRIBE `ports` 0.001884937286377
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00037193298339844
(346) DESCRIBE `ports` 0.001816987991333
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0004119873046875
(348) DESCRIBE `ports` 0.0013959407806396
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00031900405883789
(350) DESCRIBE `ports` 0.0016379356384277
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00038695335388184
(352) DESCRIBE `ports` 0.0018761157989502
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00041818618774414
(354) DESCRIBE `ports` 0.0018279552459717
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2087))) 0.00038003921508789
(356) DESCRIBE `ports` 0.0014040470123291
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2087') 0.00038003921508789
(358) DESCRIBE `ports` 0.0018908977508545
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4696))) 0.00043606758117676
(360) DESCRIBE `ports` 0.0018069744110107
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4696') 0.00035285949707031
(362) DESCRIBE `ports` 0.0015261173248291
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 160))) 0.00042390823364258
(364) DESCRIBE `ports` 0.0015928745269775
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '160') 0.00036406517028809
(366) DESCRIBE `ports` 0.0017151832580566
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.00040316581726074
(368) DESCRIBE `ports` 0.0015919208526611
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00028800964355469
(370) DESCRIBE `ports` 0.0015490055084229
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00047087669372559
(372) DESCRIBE `ports` 0.0019571781158447
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00041604042053223
(374) DESCRIBE `ports` 0.0015959739685059
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00040197372436523
(376) DESCRIBE `ports` 0.0017330646514893
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00034189224243164
(378) DESCRIBE `ports` 0.0016720294952393
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00035691261291504
(380) DESCRIBE `ports` 0.0016660690307617
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00038599967956543
(382) DESCRIBE `avid_specials` 0.0014560222625732
(383) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68564 and class = 'Cruise') OR (item_id = 1073 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.0016679763793945
(384) DESCRIBE `cruiselines` 0.0021159648895264
(385) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00033307075500488
(386) DESCRIBE `orchid_image` 0.0014569759368896
(387) DESCRIBE `cruiselines` 0.0018930435180664
(388) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00028204917907715
(389) DESCRIBE `cruises` 0.0030059814453125
(390) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62062') 0.00034093856811523
(391) DESCRIBE `ships` 0.0025429725646973
(392) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 795))) 0.00035190582275391
(393) DESCRIBE `ships` 0.0025908946990967
(394) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '795') 0.00035285949707031
(395) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034713745117188
(396) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033092498779297
(397) DESCRIBE `itineraries` 0.0017309188842773
(398) DESCRIBE `ports` 0.0017330646514893
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00031113624572754
(400) DESCRIBE `ports` 0.0013291835784912
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00031399726867676
(402) DESCRIBE `ports` 0.0014870166778564
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00030803680419922
(404) DESCRIBE `sailingdates` 0.0013039112091064
(405) DESCRIBE `ports` 0.0013840198516846
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00030016899108887
(407) DESCRIBE `ports` 0.0014610290527344
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00027990341186523
(409) DESCRIBE `ports` 0.001633882522583
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0003659725189209
(411) DESCRIBE `ports` 0.0014729499816895
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00029802322387695
(413) DESCRIBE `ports` 0.0015189647674561
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00043582916259766
(415) DESCRIBE `ports` 0.0014150142669678
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00033688545227051
(417) DESCRIBE `ports` 0.0014469623565674
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2087))) 0.00033712387084961
(419) DESCRIBE `ports` 0.001352071762085
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2087') 0.00027298927307129
(421) DESCRIBE `ports` 0.001270055770874
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4696))) 0.00038695335388184
(423) DESCRIBE `ports` 0.0013580322265625
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4696') 0.00027918815612793
(425) DESCRIBE `ports` 0.0015358924865723
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 160))) 0.00039076805114746
(427) DESCRIBE `ports` 0.0015320777893066
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '160') 0.00028395652770996
(429) DESCRIBE `ports` 0.0015580654144287
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.00034880638122559
(431) DESCRIBE `ports` 0.0013809204101562
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00027298927307129
(433) DESCRIBE `ports` 0.0015950202941895
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00030088424682617
(435) DESCRIBE `ports` 0.0015699863433838
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00032782554626465
(437) DESCRIBE `ports` 0.0015499591827393
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00040984153747559
(439) DESCRIBE `ports` 0.0014739036560059
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00032615661621094
(441) DESCRIBE `ports` 0.0013740062713623
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00036191940307617
(443) DESCRIBE `ports` 0.0014970302581787
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00035786628723145
(445) DESCRIBE `avid_specials` 0.0013341903686523
(446) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62062 and class = 'Cruise') OR (item_id = 795 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.0012760162353516
(447) DESCRIBE `cruiselines` 0.0022361278533936
(448) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.0003199577331543
(449) DESCRIBE `orchid_image` 0.0015449523925781
(450) DESCRIBE `cruiselines` 0.0021431446075439
(451) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00032401084899902
(452) DESCRIBE `cruises` 0.0026340484619141
(453) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68473') 0.00030016899108887
(454) DESCRIBE `ships` 0.0025358200073242
(455) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 795))) 0.00034713745117188
(456) DESCRIBE `ships` 0.0025680065155029
(457) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '795') 0.00051712989807129
(458) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035309791564941
(459) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032806396484375
(460) DESCRIBE `itineraries` 0.0014002323150635
(461) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68473') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00051689147949219
(462) DESCRIBE `ports` 0.0013401508331299
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00029706954956055
(464) DESCRIBE `ports` 0.001255989074707
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00029301643371582
(466) DESCRIBE `ports` 0.0013501644134521
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00025796890258789
(468) DESCRIBE `sailingdates` 0.0011119842529297
(469) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68473') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00058794021606445
(470) DESCRIBE `ports` 0.0013160705566406
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00029611587524414
(472) DESCRIBE `ports` 0.0012969970703125
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00025606155395508
(474) DESCRIBE `ports` 0.0012531280517578
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1026))) 0.00032806396484375
(476) DESCRIBE `ports` 0.0013649463653564
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1026') 0.00028300285339355
(478) DESCRIBE `ports` 0.0013580322265625
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00033307075500488
(480) DESCRIBE `ports` 0.0013549327850342
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00029492378234863
(482) DESCRIBE `ports` 0.0013599395751953
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1263))) 0.00030207633972168
(484) DESCRIBE `ports` 0.0012550354003906
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1263') 0.00028204917907715
(486) DESCRIBE `ports` 0.0013020038604736
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.0003209114074707
(488) DESCRIBE `ports` 0.0012531280517578
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00028204917907715
(490) DESCRIBE `ports` 0.001384973526001
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00037002563476562
(492) DESCRIBE `ports` 0.0017061233520508
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00042486190795898
(494) DESCRIBE `ports` 0.0018601417541504
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.0004429817199707
(496) DESCRIBE `ports` 0.001737117767334
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00042295455932617
(498) DESCRIBE `ports` 0.0016372203826904
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 320))) 0.0003058910369873
(500) DESCRIBE `ports` 0.0013079643249512
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '320') 0.00028395652770996
(502) DESCRIBE `ports` 0.0014150142669678
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00031208992004395
(504) DESCRIBE `ports` 0.0012979507446289
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.0002748966217041
(506) DESCRIBE `ports` 0.0012879371643066
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00031113624572754
(508) DESCRIBE `ports` 0.0012509822845459
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00027203559875488
(510) DESCRIBE `ports` 0.0013201236724854
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00028705596923828
(512) DESCRIBE `ports` 0.0012750625610352
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.0002598762512207
(514) DESCRIBE `avid_specials` 0.0011801719665527
(515) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68473 and class = 'Cruise') OR (item_id = 795 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.00099992752075195
(516) DESCRIBE `cruiselines` 0.0019950866699219
(517) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00032281875610352
(518) DESCRIBE `orchid_image` 0.0014598369598389
(519) DESCRIBE `cruiselines` 0.0018060207366943
(520) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00027179718017578
(521) DESCRIBE `cruises` 0.0028979778289795
(522) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68565') 0.00034284591674805
(523) DESCRIBE `ships` 0.0024979114532471
(524) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1073))) 0.00040698051452637
(525) DESCRIBE `ships` 0.0025489330291748
(526) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1073') 0.00026988983154297
(527) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00028300285339355
(528) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025415420532227
(529) DESCRIBE `itineraries` 0.0012199878692627
(530) DESCRIBE `ports` 0.0012991428375244
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00035285949707031
(532) DESCRIBE `ports` 0.0013129711151123
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00030207633972168
(534) DESCRIBE `ports` 0.0012509822845459
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00030708312988281
(536) DESCRIBE `sailingdates` 0.0011699199676514
(537) DESCRIBE `ports` 0.0012638568878174
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00029397010803223
(539) DESCRIBE `ports` 0.0013420581817627
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00026583671569824
(541) DESCRIBE `ports` 0.001309871673584
(542) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1026))) 0.0003058910369873
(543) DESCRIBE `ports` 0.0012481212615967
(544) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1026') 0.0002751350402832
(545) DESCRIBE `ports` 0.0013518333435059
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00033092498779297
(547) DESCRIBE `ports` 0.0013198852539062
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00028705596923828
(549) DESCRIBE `ports` 0.0012998580932617
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1263))) 0.00041604042053223
(551) DESCRIBE `ports` 0.0014989376068115
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1263') 0.00029206275939941
(553) DESCRIBE `ports` 0.0013258457183838
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00036978721618652
(555) DESCRIBE `ports` 0.0013101100921631
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00029611587524414
(557) DESCRIBE `ports` 0.0012979507446289
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2087))) 0.00030398368835449
(559) DESCRIBE `ports` 0.0013458728790283
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2087') 0.00031900405883789
(561) DESCRIBE `ports` 0.0029048919677734
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4696))) 0.00032711029052734
(563) DESCRIBE `ports` 0.0013000965118408
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4696') 0.00028085708618164
(565) DESCRIBE `ports` 0.0013008117675781
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.00030303001403809
(567) DESCRIBE `ports` 0.0014450550079346
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00030994415283203
(569) DESCRIBE `ports` 0.0012500286102295
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00031089782714844
(571) DESCRIBE `ports` 0.0012691020965576
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.0002751350402832
(573) DESCRIBE `ports` 0.0012609958648682
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00033903121948242
(575) DESCRIBE `ports` 0.0018050670623779
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00036787986755371
(577) DESCRIBE `ports` 0.0017139911651611
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00030303001403809
(579) DESCRIBE `ports` 0.0012750625610352
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00026702880859375
(581) DESCRIBE `avid_specials` 0.0012960433959961
(582) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68565 and class = 'Cruise') OR (item_id = 1073 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.00099515914916992
(583) DESCRIBE `cruiselines` 0.0018441677093506
(584) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00032186508178711
(585) DESCRIBE `orchid_image` 0.001417875289917
(586) DESCRIBE `cruiselines` 0.0017650127410889
(587) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00027179718017578
(588) DESCRIBE `cruises` 0.002418041229248
(589) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68474') 0.00029587745666504
(590) DESCRIBE `ships` 0.002528190612793
(591) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 795))) 0.00034999847412109
(592) DESCRIBE `ships` 0.0025200843811035
(593) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '795') 0.00026798248291016
(594) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026583671569824
(595) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031781196594238
(596) DESCRIBE `itineraries` 0.001255989074707
(597) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68474') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00046801567077637
(598) DESCRIBE `ports` 0.0012950897216797
(599) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00028705596923828
(600) DESCRIBE `ports` 0.0016851425170898
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00039005279541016
(602) DESCRIBE `ports` 0.0017151832580566
(603) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00035905838012695
(604) DESCRIBE `sailingdates` 0.0012791156768799
(605) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68474') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00052499771118164
(606) DESCRIBE `ports` 0.0012719631195068
(607) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00028896331787109
(608) DESCRIBE `ports` 0.0013179779052734
(609) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00026893615722656
(610) DESCRIBE `ports` 0.00124192237854
(611) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00030088424682617
(612) DESCRIBE `ports` 0.0013539791107178
(613) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00028204917907715
(614) DESCRIBE `ports` 0.0014150142669678
(615) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00031304359436035
(616) DESCRIBE `ports` 0.0014231204986572
(617) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00034618377685547
(618) DESCRIBE `ports` 0.0014829635620117
(619) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2087))) 0.0003199577331543
(620) DESCRIBE `ports` 0.0013041496276855
(621) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2087') 0.0003349781036377
(622) DESCRIBE `ports` 0.0018069744110107
(623) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4696))) 0.00033211708068848
(624) DESCRIBE `ports` 0.0015509128570557
(625) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4696') 0.00030016899108887
(626) DESCRIBE `ports` 0.0013189315795898
(627) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 160))) 0.00040602684020996
(628) DESCRIBE `ports` 0.0016961097717285
(629) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '160') 0.00034809112548828
(630) DESCRIBE `ports` 0.001662015914917
(631) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.00040006637573242
(632) DESCRIBE `ports` 0.0018870830535889
(633) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00043606758117676
(634) DESCRIBE `ports` 0.0016539096832275
(635) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00043296813964844
(636) DESCRIBE `ports` 0.0016679763793945
(637) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00038504600524902
(638) DESCRIBE `ports` 0.0016801357269287
(639) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00042486190795898
(640) DESCRIBE `ports` 0.0016911029815674
(641) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00034904479980469
(642) DESCRIBE `ports` 0.0017349720001221
(643) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00038909912109375
(644) DESCRIBE `ports` 0.0017449855804443
(645) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00033187866210938
(646) DESCRIBE `avid_specials` 0.0014588832855225
(647) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68474 and class = 'Cruise') OR (item_id = 795 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.0016109943389893
(648) DESCRIBE `cruiselines` 0.0024781227111816
(649) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00049805641174316
(650) DESCRIBE `orchid_image` 0.0018699169158936
(651) DESCRIBE `cruiselines` 0.0022759437561035
(652) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00043892860412598
(653) DESCRIBE `ships` 0.0035028457641602
(654) SELECT `ships`.* FROM `ships` WHERE (id IN ('796', '795', '1073', '1262')) ORDER BY FIND_IN_SET(id, '796,795,1073,1262') 0.00071001052856445
(655) DESCRIBE `cruisetypes` 0.0013971328735352
(656) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruises_and_specials.destination_id = '7') AND (cruises_and_specials.cruiseline_id = '114') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.026805877685547
(657) DESCRIBE `cruiselines` 0.0021309852600098
(658) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00043487548828125
(659) DESCRIBE `destinations` 0.0019040107727051
(660) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 7))) 0.00041317939758301
(661) DESCRIBE `destinations` 0.002000093460083
(662) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 7))) 0.00036001205444336
(663) DESCRIBE `cruiselines` 0.0018179416656494
(664) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00031590461730957