or, enquire about your chosen options

  1. Catch up on Cruising: Latest news in bite size
  2. Catch up on Cruising: Latest news in bite size
  3. Family Cruising – Have you considered it ?
  4. New Azamara Ship to arrive in March 2018
  5. Enhanced amenities for Oceania Cruises

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

Total elapsed time: 0.40180015563965

# Query Time
(1) connect 0.0006098747253418
(2) DESCRIBE `cruises` 0.0025210380554199
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (40978, 62801, 61397, 41031, 68312, 48869, 63173, 68313, 68314, 62825)) ORDER BY FIND_IN_SET(id, '40978,62801,61397,41031,68312,48869,63173,68313,68314,62825') 0.0013320446014404
(4) DESCRIBE `specials` 0.0035140514373779
(5) DESCRIBE `specials` 0.0028228759765625
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1230492') 0.00028085708618164
(7) DESCRIBE `ships` 0.0013511180877686
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1060))) 0.00052595138549805
(9) DESCRIBE `ships` 0.0020709037780762
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1060') 0.00028586387634277
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022792816162109
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022315979003906
(13) DESCRIBE `itineraries` 0.0013508796691895
(14) DESCRIBE `ports` 0.0010769367218018
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00031089782714844
(16) DESCRIBE `ports` 0.00092387199401855
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00024604797363281
(18) DESCRIBE `ports` 0.00093197822570801
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00025081634521484
(20) DESCRIBE `specialsailingdates` 0.00075197219848633
(21) DESCRIBE `sailingdates` 0.0008540153503418
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396119))) 0.00030207633972168
(23) DESCRIBE `ports` 0.00092601776123047
(24) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.0002899169921875
(25) DESCRIBE `ports` 0.00094699859619141
(26) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00021505355834961
(27) DESCRIBE `ports` 0.00076413154602051
(28) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00021481513977051
(29) DESCRIBE `ports` 0.00071597099304199
(30) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00018501281738281
(31) DESCRIBE `ports` 0.00068187713623047
(32) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2691))) 0.00020503997802734
(33) DESCRIBE `ports` 0.00067591667175293
(34) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2691') 0.00021004676818848
(35) DESCRIBE `ports` 0.00073814392089844
(36) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3208))) 0.00023293495178223
(37) DESCRIBE `ports` 0.00075697898864746
(38) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3208') 0.00019216537475586
(39) DESCRIBE `ports` 0.00070714950561523
(40) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2937))) 0.00020503997802734
(41) DESCRIBE `ports` 0.00066900253295898
(42) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2937') 0.0001828670501709
(43) DESCRIBE `ports` 0.00065994262695312
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3207))) 0.00020098686218262
(45) DESCRIBE `ports` 0.00091218948364258
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3207') 0.00020313262939453
(47) DESCRIBE `ports` 0.00068211555480957
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2692))) 0.00023102760314941
(49) DESCRIBE `ports` 0.0007169246673584
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2692') 0.00020194053649902
(51) DESCRIBE `ports` 0.00067496299743652
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2692))) 0.00020790100097656
(53) DESCRIBE `ports` 0.00068807601928711
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2692') 0.00018310546875
(55) DESCRIBE `ports` 0.00077390670776367
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00020503997802734
(57) DESCRIBE `ports` 0.00067710876464844
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00018310546875
(59) DESCRIBE `cruises` 0.0013601779937744
(60) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 40978))) 0.00029993057250977
(61) DESCRIBE `avid_specials` 0.00065898895263672
(62) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1230492 and class = 'Special') OR (item_id = 40978 and class = 'Cruise') OR (item_id = 1060 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.0011999607086182
(63) DESCRIBE `cruiselines` 0.0010199546813965
(64) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00025391578674316
(65) DESCRIBE `orchid_image` 0.00076103210449219
(66) DESCRIBE `cruiselines` 0.00094795227050781
(67) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00020909309387207
(68) DESCRIBE `specials` 0.0021121501922607
(69) DESCRIBE `specials` 0.0019369125366211
(70) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1233777') 0.00028181076049805
(71) DESCRIBE `ships` 0.0013260841369629
(72) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1468))) 0.00028109550476074
(73) DESCRIBE `ships` 0.0012688636779785
(74) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1468') 0.00020885467529297
(75) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018215179443359
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016903877258301
(77) DESCRIBE `itineraries` 0.00067806243896484
(78) DESCRIBE `ports` 0.00071907043457031
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00022792816162109
(80) DESCRIBE `ports` 0.00066399574279785
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00020003318786621
(82) DESCRIBE `ports` 0.00067996978759766
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00018715858459473
(84) DESCRIBE `specialsailingdates` 0.00056719779968262
(85) DESCRIBE `sailingdates` 0.00060510635375977
(86) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393611))) 0.00027799606323242
(87) DESCRIBE `ports` 0.00072288513183594
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00020885467529297
(89) DESCRIBE `ports` 0.00066900253295898
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00018787384033203
(91) DESCRIBE `ports` 0.0006871223449707
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00020813941955566
(93) DESCRIBE `ports` 0.00067496299743652
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00021791458129883
(95) DESCRIBE `ports` 0.00066900253295898
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00019407272338867
(97) DESCRIBE `ports` 0.00067305564880371
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00017619132995605
(99) DESCRIBE `ports` 0.00065898895263672
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4135))) 0.00025296211242676
(101) DESCRIBE `ports` 0.00088310241699219
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4135') 0.00022697448730469
(103) DESCRIBE `ports` 0.000885009765625
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00024890899658203
(105) DESCRIBE `ports` 0.00090193748474121
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00022697448730469
(107) DESCRIBE `ports` 0.00089693069458008
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00025391578674316
(109) DESCRIBE `ports` 0.00079488754272461
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00024604797363281
(111) DESCRIBE `ports` 0.00095891952514648
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00026297569274902
(113) DESCRIBE `ports` 0.0010390281677246
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00025796890258789
(115) DESCRIBE `ports` 0.0010218620300293
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00027704238891602
(117) DESCRIBE `ports` 0.00094699859619141
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00025010108947754
(119) DESCRIBE `ports` 0.00099515914916992
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00026798248291016
(121) DESCRIBE `ports` 0.00088405609130859
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00023818016052246
(123) DESCRIBE `ports` 0.00098800659179688
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.00027608871459961
(125) DESCRIBE `ports` 0.0009768009185791
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.00025296211242676
(127) DESCRIBE `ports` 0.00095200538635254
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00026607513427734
(129) DESCRIBE `ports` 0.00081706047058105
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00025200843811035
(131) DESCRIBE `ports` 0.00097107887268066
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00027918815612793
(133) DESCRIBE `ports` 0.00097012519836426
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00026321411132812
(135) DESCRIBE `ports` 0.00082087516784668
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00028109550476074
(137) DESCRIBE `ports` 0.00079584121704102
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.0002129077911377
(139) DESCRIBE `ports` 0.00068306922912598
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00020909309387207
(141) DESCRIBE `ports` 0.00067400932312012
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00017809867858887
(143) DESCRIBE `ports` 0.00067520141601562
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.0001990795135498
(145) DESCRIBE `ports` 0.00067496299743652
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.0001828670501709
(147) DESCRIBE `ports` 0.0006721019744873
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.0001978874206543
(149) DESCRIBE `ports` 0.00070500373840332
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00017714500427246
(151) DESCRIBE `cruises` 0.0013070106506348
(152) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 62801))) 0.00034189224243164
(153) DESCRIBE `avid_specials` 0.00063014030456543
(154) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1233777 and class = 'Special') OR (item_id = 62801 and class = 'Cruise') OR (item_id = 1468 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 54 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.0010640621185303
(155) DESCRIBE `cruiselines` 0.0009758472442627
(156) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00027704238891602
(157) DESCRIBE `orchid_image` 0.00075602531433105
(158) DESCRIBE `cruiselines` 0.00096011161804199
(159) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00020408630371094
(160) DESCRIBE `specials` 0.0021450519561768
(161) DESCRIBE `specials` 0.0026030540466309
(162) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1343381') 0.00036215782165527
(163) DESCRIBE `ships` 0.0014839172363281
(164) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.00030183792114258
(165) DESCRIBE `ships` 0.0013232231140137
(166) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.00020384788513184
(167) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018405914306641
(168) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017189979553223
(169) DESCRIBE `itineraries` 0.00081300735473633
(170) DESCRIBE `ports` 0.00073599815368652
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00023388862609863
(172) DESCRIBE `ports` 0.00070309638977051
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020813941955566
(174) DESCRIBE `ports` 0.0006868839263916
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018596649169922
(176) DESCRIBE `specialsailingdates` 0.00057697296142578
(177) DESCRIBE `sailingdates` 0.00061297416687012
(178) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 389098))) 0.00023198127746582
(179) DESCRIBE `ports` 0.00069212913513184
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020909309387207
(181) DESCRIBE `ports` 0.00069403648376465
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018501281738281
(183) DESCRIBE `ports` 0.0006868839263916
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1117))) 0.00020909309387207
(185) DESCRIBE `ports` 0.00068497657775879
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1117') 0.00018906593322754
(187) DESCRIBE `ports` 0.00076699256896973
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00020599365234375
(189) DESCRIBE `ports` 0.00069093704223633
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00018692016601562
(191) DESCRIBE `ports` 0.00067305564880371
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00020599365234375
(193) DESCRIBE `ports` 0.00067996978759766
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00018095970153809
(195) DESCRIBE `ports` 0.00067400932312012
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00021505355834961
(197) DESCRIBE `ports` 0.00070095062255859
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.0001828670501709
(199) DESCRIBE `ports` 0.00068783760070801
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020790100097656
(201) DESCRIBE `ports` 0.00066900253295898
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018787384033203
(203) DESCRIBE `ports` 0.00068902969360352
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00021004676818848
(205) DESCRIBE `ports` 0.00067496299743652
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00018501281738281
(207) DESCRIBE `ports` 0.0006721019744873
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00020909309387207
(209) DESCRIBE `ports` 0.00074005126953125
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00018501281738281
(211) DESCRIBE `ports` 0.00068497657775879
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00020885467529297
(213) DESCRIBE `ports` 0.00070405006408691
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00018405914306641
(215) DESCRIBE `ports` 0.00073790550231934
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2565))) 0.00020813941955566
(217) DESCRIBE `ports` 0.00067710876464844
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2565') 0.00020694732666016
(219) DESCRIBE `ports` 0.00071191787719727
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020694732666016
(221) DESCRIBE `ports` 0.00072002410888672
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018000602722168
(223) DESCRIBE `ports` 0.0007481575012207
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0002140998840332
(225) DESCRIBE `ports` 0.000885009765625
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00022697448730469
(227) DESCRIBE `cruises` 0.0013179779052734
(228) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 61397))) 0.00029993057250977
(229) DESCRIBE `avid_specials` 0.00062203407287598
(230) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1343381 and class = 'Special') OR (item_id = 61397 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 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.0010590553283691
(231) DESCRIBE `cruiselines` 0.00096893310546875
(232) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0002281665802002
(233) DESCRIBE `orchid_image` 0.0007479190826416
(234) DESCRIBE `cruiselines` 0.00093793869018555
(235) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00019001960754395
(236) DESCRIBE `specials` 0.0020201206207275
(237) DESCRIBE `specials` 0.0019168853759766
(238) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1225970') 0.00027585029602051
(239) DESCRIBE `ships` 0.0012860298156738
(240) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1063))) 0.00026488304138184
(241) DESCRIBE `ships` 0.0014190673828125
(242) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1063') 0.00020003318786621
(243) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018811225891113
(244) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017213821411133
(245) DESCRIBE `itineraries` 0.00070095062255859
(246) DESCRIBE `ports` 0.00069999694824219
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00024318695068359
(248) DESCRIBE `ports` 0.00072789192199707
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020694732666016
(250) DESCRIBE `ports` 0.00069785118103027
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018715858459473
(252) DESCRIBE `specialsailingdates` 0.00057601928710938
(253) DESCRIBE `sailingdates` 0.00061202049255371
(254) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396696))) 0.0002291202545166
(255) DESCRIBE `sailingdates` 0.00059795379638672
(256) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396697))) 0.0002739429473877
(257) DESCRIBE `ports` 0.00069594383239746
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00022220611572266
(259) DESCRIBE `ports` 0.00070714950561523
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018787384033203
(261) DESCRIBE `ports` 0.00069999694824219
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020694732666016
(263) DESCRIBE `ports` 0.00068998336791992
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0001990795135498
(265) DESCRIBE `ports` 0.00066590309143066
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0001981258392334
(267) DESCRIBE `ports` 0.00066685676574707
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00019192695617676
(269) DESCRIBE `ports` 0.00066900253295898
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3209))) 0.00022006034851074
(271) DESCRIBE `ports` 0.00070810317993164
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3209') 0.00018811225891113
(273) DESCRIBE `ports` 0.00068187713623047
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0002140998840332
(275) DESCRIBE `ports` 0.00071310997009277
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00019001960754395
(277) DESCRIBE `ports` 0.00075411796569824
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021004676818848
(279) DESCRIBE `ports` 0.00068306922912598
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018978118896484
(281) DESCRIBE `cruises` 0.0013599395751953
(282) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 41031))) 0.00029587745666504
(283) DESCRIBE `avid_specials` 0.00062990188598633
(284) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1225970 and class = 'Special') OR (item_id = 41031 and class = 'Cruise') OR (item_id = 1063 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.0010859966278076
(285) DESCRIBE `cruiselines` 0.00096583366394043
(286) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00024294853210449
(287) DESCRIBE `orchid_image` 0.0007941722869873
(288) DESCRIBE `cruiselines` 0.0010190010070801
(289) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00019693374633789
(290) DESCRIBE `specials` 0.0020239353179932
(291) DESCRIBE `specials` 0.002079963684082
(292) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1294016') 0.00023412704467773
(293) DESCRIBE `ships` 0.0013320446014404
(294) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 189))) 0.00028204917907715
(295) DESCRIBE `ships` 0.0013391971588135
(296) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '189') 0.0001838207244873
(297) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019598007202148
(298) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017404556274414
(299) DESCRIBE `itineraries` 0.00070405006408691
(300) DESCRIBE `ports` 0.00072503089904785
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00023293495178223
(302) DESCRIBE `ports` 0.00073409080505371
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00020909309387207
(304) DESCRIBE `ports` 0.00068211555480957
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00019502639770508
(306) DESCRIBE `specialsailingdates` 0.00057291984558105
(307) DESCRIBE `sailingdates` 0.00063204765319824
(308) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430734))) 0.00024199485778809
(309) DESCRIBE `sailingdates` 0.00063490867614746
(310) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430735))) 0.0001981258392334
(311) DESCRIBE `sailingdates` 0.00060105323791504
(312) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430736))) 0.0001988410949707
(313) DESCRIBE `sailingdates` 0.00060296058654785
(314) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430737))) 0.00019001960754395
(315) DESCRIBE `sailingdates` 0.00067806243896484
(316) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430738))) 0.00025582313537598
(317) DESCRIBE `ports` 0.0007631778717041
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00022602081298828
(319) DESCRIBE `ports` 0.0007481575012207
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00019288063049316
(321) DESCRIBE `ports` 0.00069093704223633
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.0002140998840332
(323) DESCRIBE `ports` 0.00069594383239746
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00019502639770508
(325) DESCRIBE `ports` 0.0006718635559082
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00021004676818848
(327) DESCRIBE `ports` 0.00073099136352539
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00018715858459473
(329) DESCRIBE `ports` 0.00069594383239746
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00021004676818848
(331) DESCRIBE `ports` 0.00068998336791992
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.00018191337585449
(333) DESCRIBE `ports` 0.00068116188049316
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.00020599365234375
(335) DESCRIBE `ports` 0.00067591667175293
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.00018978118896484
(337) DESCRIBE `ports` 0.00067400932312012
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00020503997802734
(339) DESCRIBE `ports` 0.0006721019744873
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00017595291137695
(341) DESCRIBE `cruises` 0.0015170574188232
(342) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 68312))) 0.00029397010803223
(343) DESCRIBE `avid_specials` 0.00062704086303711
(344) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1294016 and class = 'Special') OR (item_id = 68312 and class = 'Cruise') OR (item_id = 189 AND class = 'Ship') OR (item_id = 38 AND class = 'CruiseLine') OR (item_id = 35 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.0010700225830078
(345) DESCRIBE `cruiselines` 0.0010168552398682
(346) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00023198127746582
(347) DESCRIBE `orchid_image` 0.00075697898864746
(348) DESCRIBE `cruiselines` 0.0010731220245361
(349) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00020909309387207
(350) DESCRIBE `specials` 0.0023040771484375
(351) DESCRIBE `specials` 0.0023097991943359
(352) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1222219') 0.0003049373626709
(353) DESCRIBE `ships` 0.0014429092407227
(354) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1232))) 0.00029182434082031
(355) DESCRIBE `ships` 0.0013740062713623
(356) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1232') 0.00025296211242676
(357) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018596649169922
(358) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017094612121582
(359) DESCRIBE `itineraries` 0.0008549690246582
(360) DESCRIBE `ports` 0.00079607963562012
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2507))) 0.00024819374084473
(362) DESCRIBE `ports` 0.00069808959960938
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2507))) 0.00021696090698242
(364) DESCRIBE `ports` 0.00069904327392578
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2507') 0.00022292137145996
(366) DESCRIBE `specialsailingdates` 0.00060200691223145
(367) DESCRIBE `sailingdates` 0.00064492225646973
(368) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396406))) 0.00023484230041504
(369) DESCRIBE `ports` 0.00072288513183594
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2507))) 0.00022006034851074
(371) DESCRIBE `ports` 0.00069284439086914
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2507') 0.00021791458129883
(373) DESCRIBE `ports` 0.00068378448486328
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2507))) 0.00020313262939453
(375) DESCRIBE `ports` 0.00069904327392578
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2507') 0.00018095970153809
(377) DESCRIBE `ports` 0.00068902969360352
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2410))) 0.0001981258392334
(379) DESCRIBE `ports` 0.00067687034606934
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2410') 0.00018501281738281
(381) DESCRIBE `ports` 0.00072693824768066
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4484))) 0.0002138614654541
(383) DESCRIBE `ports` 0.00070810317993164
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4484') 0.0001838207244873
(385) DESCRIBE `ports` 0.00069093704223633
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4485))) 0.00021481513977051
(387) DESCRIBE `ports` 0.00073719024658203
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4485') 0.00024294853210449
(389) DESCRIBE `ports` 0.0007021427154541
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4485))) 0.00029397010803223
(391) DESCRIBE `ports` 0.00075912475585938
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4485') 0.00019717216491699
(393) DESCRIBE `ports` 0.00071907043457031
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4484))) 0.00021195411682129
(395) DESCRIBE `ports` 0.00071907043457031
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4484') 0.00018310546875
(397) DESCRIBE `ports` 0.00068497657775879
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2507))) 0.00021100044250488
(399) DESCRIBE `ports` 0.00070405006408691
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2507') 0.00018906593322754
(401) DESCRIBE `cruises` 0.0013718605041504
(402) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 48869))) 0.0003209114074707
(403) DESCRIBE `avid_specials` 0.0006709098815918
(404) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1222219 and class = 'Special') OR (item_id = 48869 and class = 'Cruise') OR (item_id = 1232 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.0010700225830078
(405) DESCRIBE `cruiselines` 0.00097084045410156
(406) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00024008750915527
(407) DESCRIBE `orchid_image` 0.00078701972961426
(408) DESCRIBE `cruiselines` 0.00096011161804199
(409) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00020599365234375
(410) DESCRIBE `specials` 0.0020558834075928
(411) DESCRIBE `specials` 0.0020291805267334
(412) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1230524') 0.00026488304138184
(413) DESCRIBE `ships` 0.0013370513916016
(414) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1062))) 0.00026202201843262
(415) DESCRIBE `ships` 0.001317024230957
(416) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1062') 0.00019288063049316
(417) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0001838207244873
(418) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016999244689941
(419) DESCRIBE `itineraries` 0.00068092346191406
(420) DESCRIBE `ports` 0.00071287155151367
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00021696090698242
(422) DESCRIBE `ports` 0.0006709098815918
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00021004676818848
(424) DESCRIBE `ports` 0.00067400932312012
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00020599365234375
(426) DESCRIBE `specialsailingdates` 0.00056695938110352
(427) DESCRIBE `sailingdates` 0.00060796737670898
(428) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396746))) 0.00022387504577637
(429) DESCRIBE `ports` 0.00068497657775879
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00020599365234375
(431) DESCRIBE `ports` 0.00068783760070801
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00018310546875
(433) DESCRIBE `ports` 0.00068211555480957
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00020813941955566
(435) DESCRIBE `ports` 0.00072407722473145
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00018310546875
(437) DESCRIBE `ports` 0.00067806243896484
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2691))) 0.00020003318786621
(439) DESCRIBE `ports` 0.0006718635559082
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2691') 0.00018095970153809
(441) DESCRIBE `ports` 0.00070786476135254
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2692))) 0.00020098686218262
(443) DESCRIBE `ports` 0.00067496299743652
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2692') 0.00018191337585449
(445) DESCRIBE `ports` 0.00067806243896484
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3208))) 0.00024890899658203
(447) DESCRIBE `ports` 0.00066804885864258
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3208') 0.00018000602722168
(449) DESCRIBE `ports` 0.00066900253295898
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2937))) 0.00020289421081543
(451) DESCRIBE `ports` 0.0006861686706543
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2937') 0.00018095970153809
(453) DESCRIBE `ports` 0.00066900253295898
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4607))) 0.00020718574523926
(455) DESCRIBE `ports` 0.00066995620727539
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4607') 0.00018000602722168
(457) DESCRIBE `ports` 0.00070595741271973
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3207))) 0.00020217895507812
(459) DESCRIBE `ports` 0.0006709098815918
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3207') 0.00017881393432617
(461) DESCRIBE `ports` 0.0006859302520752
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4685))) 0.00021982192993164
(463) DESCRIBE `ports` 0.00069499015808105
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4685') 0.00019502639770508
(465) DESCRIBE `ports` 0.00066804885864258
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00020599365234375
(467) DESCRIBE `ports` 0.00067496299743652
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00018692016601562
(469) DESCRIBE `ports` 0.00067496299743652
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00020408630371094
(471) DESCRIBE `ports` 0.00068902969360352
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00018787384033203
(473) DESCRIBE `ports` 0.00066900253295898
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00020313262939453
(475) DESCRIBE `ports` 0.00066614151000977
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00018095970153809
(477) DESCRIBE `cruises` 0.0014019012451172
(478) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 63173))) 0.00031805038452148
(479) DESCRIBE `avid_specials` 0.00063109397888184
(480) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1230524 and class = 'Special') OR (item_id = 63173 and class = 'Cruise') OR (item_id = 1062 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.0010700225830078
(481) DESCRIBE `cruiselines` 0.0010459423065186
(482) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00023508071899414
(483) DESCRIBE `orchid_image` 0.0007469654083252
(484) DESCRIBE `cruiselines` 0.00098395347595215
(485) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.0002131462097168
(486) DESCRIBE `specials` 0.0020999908447266
(487) DESCRIBE `specials` 0.0019831657409668
(488) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1294017') 0.00026607513427734
(489) DESCRIBE `ships` 0.001704216003418
(490) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 189))) 0.00032806396484375
(491) DESCRIBE `ships` 0.0013241767883301
(492) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '189') 0.00018906593322754
(493) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018215179443359
(494) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016498565673828
(495) DESCRIBE `itineraries` 0.0006861686706543
(496) DESCRIBE `ports` 0.00071406364440918
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00021815299987793
(498) DESCRIBE `ports` 0.00067710876464844
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00021100044250488
(500) DESCRIBE `ports` 0.0007479190826416
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00018501281738281
(502) DESCRIBE `specialsailingdates` 0.00055599212646484
(503) DESCRIBE `sailingdates` 0.00063800811767578
(504) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430756))) 0.00022220611572266
(505) DESCRIBE `sailingdates` 0.00061511993408203
(506) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430757))) 0.00019097328186035
(507) DESCRIBE `sailingdates` 0.00059986114501953
(508) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430758))) 0.00019407272338867
(509) DESCRIBE `sailingdates` 0.00060796737670898
(510) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430759))) 0.0001990795135498
(511) DESCRIBE `ports` 0.00068092346191406
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00020313262939453
(513) DESCRIBE `ports` 0.00070619583129883
(514) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00018596649169922
(515) DESCRIBE `ports` 0.00067305564880371
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00020408630371094
(517) DESCRIBE `ports` 0.00067281723022461
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00017213821411133
(519) DESCRIBE `ports` 0.00076603889465332
(520) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.00021600723266602
(521) DESCRIBE `ports` 0.00067496299743652
(522) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.00017404556274414
(523) DESCRIBE `ports` 0.0006709098815918
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.00020098686218262
(525) DESCRIBE `ports` 0.00089907646179199
(526) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.00026702880859375
(527) DESCRIBE `ports` 0.00072908401489258
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00020718574523926
(529) DESCRIBE `ports` 0.00067710876464844
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00019097328186035
(531) DESCRIBE `ports` 0.0006861686706543
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00020194053649902
(533) DESCRIBE `ports` 0.00068902969360352
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00024104118347168
(535) DESCRIBE `cruises` 0.001798152923584
(536) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 68313))) 0.00038385391235352
(537) DESCRIBE `avid_specials` 0.00064611434936523
(538) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1294017 and class = 'Special') OR (item_id = 68313 and class = 'Cruise') OR (item_id = 189 AND class = 'Ship') OR (item_id = 38 AND class = 'CruiseLine') OR (item_id = 35 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.0010888576507568
(539) DESCRIBE `cruiselines` 0.00098490715026855
(540) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00020909309387207
(541) DESCRIBE `orchid_image` 0.00086307525634766
(542) DESCRIBE `cruiselines` 0.0010678768157959
(543) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00017690658569336
(544) DESCRIBE `specials` 0.002007007598877
(545) DESCRIBE `specials` 0.0019631385803223
(546) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1294018') 0.00025296211242676
(547) DESCRIBE `ships` 0.0015618801116943
(548) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 189))) 0.00025701522827148
(549) DESCRIBE `ships` 0.0012760162353516
(550) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '189') 0.00018620491027832
(551) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021910667419434
(552) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002138614654541
(553) DESCRIBE `itineraries` 0.00070500373840332
(554) DESCRIBE `ports` 0.00089597702026367
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00022697448730469
(556) DESCRIBE `ports` 0.00095200538635254
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.0002439022064209
(558) DESCRIBE `ports` 0.00067520141601562
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00018787384033203
(560) DESCRIBE `specialsailingdates` 0.00058698654174805
(561) DESCRIBE `sailingdates` 0.00060606002807617
(562) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430776))) 0.00030112266540527
(563) DESCRIBE `sailingdates` 0.00060582160949707
(564) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430777))) 0.00018811225891113
(565) DESCRIBE `sailingdates` 0.00063300132751465
(566) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430778))) 0.00022983551025391
(567) DESCRIBE `sailingdates` 0.00059294700622559
(568) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 430779))) 0.00020313262939453
(569) DESCRIBE `ports` 0.00069594383239746
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00022101402282715
(571) DESCRIBE `ports` 0.00067305564880371
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00017809867858887
(573) DESCRIBE `ports` 0.00065994262695312
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2123))) 0.0001978874206543
(575) DESCRIBE `ports` 0.00069212913513184
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2123') 0.00019001960754395
(577) DESCRIBE `ports` 0.00066018104553223
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.00019097328186035
(579) DESCRIBE `ports` 0.00067806243896484
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.00017213821411133
(581) DESCRIBE `ports` 0.00068402290344238
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00019311904907227
(583) DESCRIBE `ports` 0.00067496299743652
(584) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00018692016601562
(585) DESCRIBE `ports` 0.00066304206848145
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00022506713867188
(587) DESCRIBE `ports` 0.00068020820617676
(588) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00018501281738281
(589) DESCRIBE `ports` 0.00065302848815918
(590) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00019001960754395
(591) DESCRIBE `ports` 0.00065398216247559
(592) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00017309188842773
(593) DESCRIBE `cruises` 0.0012891292572021
(594) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 68314))) 0.00026798248291016
(595) DESCRIBE `avid_specials` 0.00063514709472656
(596) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1294018 and class = 'Special') OR (item_id = 68314 and class = 'Cruise') OR (item_id = 189 AND class = 'Ship') OR (item_id = 38 AND class = 'CruiseLine') OR (item_id = 35 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.0010559558868408
(597) DESCRIBE `cruiselines` 0.0009610652923584
(598) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00021600723266602
(599) DESCRIBE `orchid_image` 0.00076985359191895
(600) DESCRIBE `cruiselines` 0.00094699859619141
(601) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00017809867858887
(602) DESCRIBE `specials` 0.0021510124206543
(603) DESCRIBE `specials` 0.0018749237060547
(604) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1364656') 0.00021815299987793
(605) DESCRIBE `ships` 0.0012960433959961
(606) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1308))) 0.00023603439331055
(607) DESCRIBE `ships` 0.0012748241424561
(608) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1308') 0.00017499923706055
(609) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017809867858887
(610) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016307830810547
(611) DESCRIBE `itineraries` 0.00065302848815918
(612) DESCRIBE `ports` 0.00067400932312012
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00025391578674316
(614) DESCRIBE `ports` 0.00066494941711426
(615) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00019407272338867
(616) DESCRIBE `ports` 0.00065994262695312
(617) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00017905235290527
(618) DESCRIBE `specialsailingdates` 0.00055408477783203
(619) DESCRIBE `sailingdates` 0.00059700012207031
(620) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393808))) 0.00020098686218262
(621) DESCRIBE `ports` 0.00068306922912598
(622) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00020599365234375
(623) DESCRIBE `ports` 0.00071096420288086
(624) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00017905235290527
(625) DESCRIBE `ports` 0.00066399574279785
(626) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.0001988410949707
(627) DESCRIBE `ports` 0.00068020820617676
(628) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00017189979553223
(629) DESCRIBE `ports` 0.00068187713623047
(630) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 640))) 0.0001990795135498
(631) DESCRIBE `ports` 0.00066900253295898
(632) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '640') 0.00017690658569336
(633) DESCRIBE `ports` 0.00067496299743652
(634) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00019598007202148
(635) DESCRIBE `ports` 0.00066208839416504
(636) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00017285346984863
(637) DESCRIBE `ports` 0.00066089630126953
(638) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 801))) 0.00019502639770508
(639) DESCRIBE `ports` 0.0006718635559082
(640) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '801') 0.00018501281738281
(641) DESCRIBE `ports` 0.00067496299743652
(642) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00020694732666016
(643) DESCRIBE `ports` 0.0006709098815918
(644) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00017905235290527
(645) DESCRIBE `ports` 0.0006721019744873
(646) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00019598007202148
(647) DESCRIBE `ports` 0.00066900253295898
(648) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00017189979553223
(649) DESCRIBE `ports` 0.00066995620727539
(650) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.00020098686218262
(651) DESCRIBE `ports` 0.0007321834564209
(652) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.00021100044250488
(653) DESCRIBE `ports` 0.00075507164001465
(654) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 657))) 0.00021791458129883
(655) DESCRIBE `ports` 0.0008089542388916
(656) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '657') 0.00021982192993164
(657) DESCRIBE `ports` 0.00067591667175293
(658) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00020718574523926
(659) DESCRIBE `ports` 0.0006709098815918
(660) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00058484077453613
(661) DESCRIBE `ports` 0.0014359951019287
(662) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2945))) 0.00040888786315918
(663) DESCRIBE `ports` 0.0012319087982178
(664) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2945') 0.00030803680419922
(665) DESCRIBE `cruises` 0.0023510456085205
(666) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 62825))) 0.00050497055053711
(667) DESCRIBE `avid_specials` 0.0010550022125244
(668) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1364656 and class = 'Special') OR (item_id = 62825 and class = 'Cruise') OR (item_id = 1308 AND class = 'Ship') OR (item_id = 187 AND class = 'CruiseLine') OR (item_id = 25 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.0019071102142334
(669) DESCRIBE `cruiselines` 0.0016210079193115
(670) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 187))) 0.00036501884460449
(671) DESCRIBE `orchid_image` 0.0013008117675781
(672) DESCRIBE `cruiselines` 0.0016360282897949
(673) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '187') 0.00030684471130371
(674) DESCRIBE `cruiselines` 0.001068115234375
(675) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('140', '33', '28', '191', '18', '23', '30', '29', '38', '91', '26', '144', '8', '15', '24', '151', '57', '218', '37', '101', '20', '110', '262', '263', '19', '187')) ORDER BY FIND_IN_SET(id, '140,33,28,191,18,23,30,29,38,91,26,144,8,15,24,151,57,218,37,101,20,110,262,263,19,187') 0.00096702575683594
(676) DESCRIBE `ships` 0.0016629695892334
(677) SELECT `ships`.* FROM `ships` WHERE (id IN ('189', '1205', '1325', '81', '150', '1032', '1282', '741', '162', '163', '933', '225', '394', '585', '790', '884', '1078', '1266', '1328', '148', '151', '160', '683', '768', '1168', '1393', '1579', '1631', '149', '152', '262', '508', '616', '652', '711', '835', '1159', '1468', '84', '253', '291', '451', '453', '542', '966', '968', '1063', '1135', '1302', '1319', '1330', '1398', '1409', '1464', '1575', '43', '82', '98', '105', '111', '119', '124', '258', '287', '324', '338', '340', '349', '404', '406', '407', '547', '624', '669', '765', '780', '791', '973', '1008', '1060', '1062', '1154', '1232', '1237', '1260', '1284', '1308', '1402', '1465', '1474')) ORDER BY FIND_IN_SET(id, '189,1205,1325,81,150,1032,1282,741,162,163,933,225,394,585,790,884,1078,1266,1328,148,151,160,683,768,1168,1393,1579,1631,149,152,262,508,616,652,711,835,1159,1468,84,253,291,451,453,542,966,968,1063,1135,1302,1319,1330,1398,1409,1464,1575,43,82,98,105,111,119,124,258,287,324,338,340,349,404,406,407,547,624,669,765,780,791,973,1008,1060,1062,1154,1232,1237,1260,1284,1308,1402,1465,1474') 0.0033938884735107
(678) DESCRIBE `cruisetypes` 0.00083684921264648
(679) DESCRIBE `destinations` 0.00092506408691406
(680) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '50', '35', '43', '12', '54', '2', '8', '11', '55', '48', '26', '7', '40', '25', '28', '49', '29', '38', '53')) ORDER BY FIND_IN_SET(id, '22,50,35,43,12,54,2,8,11,55,48,26,7,40,25,28,49,29,38,53') 0.00081300735473633