or, enquire about your chosen options

  1. Carnival Cruise Line teams up with Harlem Globetrotters
  2. Ultra-Luxury Cruising
  3. The Caribbean is still a Preferred Cruise Destination
  4. Catch Up on Cruising: Latest News in bite size!
  5. 8 Romantic Destinations Around the World

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

Total elapsed time: 1.168839931488

# Query Time
(1) connect 0.0011768341064453
(2) DESCRIBE `cruises` 0.0040960311889648
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (76657, 84444, 72590, 73089, 72617, 63617, 76711, 77383, 72515, 77522)) ORDER BY FIND_IN_SET(id, '76657,84444,72590,73089,72617,63617,76711,77383,72515,77522') 0.0016419887542725
(4) DESCRIBE `cruises` 0.0038018226623535
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76657') 0.00048089027404785
(6) DESCRIBE `ships` 0.0054020881652832
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1398))) 0.00065994262695312
(8) DESCRIBE `ships` 0.0036070346832275
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1398') 0.00040102005004883
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00036096572875977
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00043916702270508
(12) DESCRIBE `itineraries` 0.0018620491027832
(13) DESCRIBE `ports` 0.002094030380249
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) 0.00045609474182129
(15) DESCRIBE `ports` 0.0021350383758545
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) 0.00044798851013184
(17) DESCRIBE `ports` 0.0020248889923096
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1266') 0.00043010711669922
(19) DESCRIBE `sailingdates` 0.0016319751739502
(20) DESCRIBE `ports` 0.0023031234741211
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1266))) 0.00047397613525391
(22) DESCRIBE `ports` 0.0019478797912598
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1266') 0.00037598609924316
(24) DESCRIBE `ports` 0.0019230842590332
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00040483474731445
(26) DESCRIBE `ports` 0.002032995223999
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00038003921508789
(28) DESCRIBE `ports` 0.0018410682678223
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 777))) 0.00041007995605469
(30) DESCRIBE `ports` 0.0018570423126221
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '777') 0.00045084953308105
(32) DESCRIBE `ports` 0.0020170211791992
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5650))) 0.0004429817199707
(34) DESCRIBE `ports` 0.0017960071563721
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5650') 0.00038599967956543
(36) DESCRIBE `ports` 0.0020439624786377
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1731))) 0.00043916702270508
(38) DESCRIBE `ports` 0.0018959045410156
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1731') 0.00037217140197754
(40) DESCRIBE `ports` 0.0019218921661377
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1731))) 0.00051403045654297
(42) DESCRIBE `ports` 0.0019431114196777
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1731') 0.00042080879211426
(44) DESCRIBE `ports` 0.001812219619751
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00041007995605469
(46) DESCRIBE `ports` 0.0017859935760498
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00036501884460449
(48) DESCRIBE `ports` 0.0018351078033447
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00038790702819824
(50) DESCRIBE `ports` 0.0018410682678223
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00039982795715332
(52) DESCRIBE `ports` 0.0019321441650391
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00045299530029297
(54) DESCRIBE `ports` 0.0018758773803711
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00037908554077148
(56) DESCRIBE `avid_specials` 0.0017430782318115
(57) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76657 and class = 'Cruise') OR (item_id = 1398 AND class = 'Ship') OR (item_id = 29 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.0015051364898682
(58) DESCRIBE `cruiselines` 0.0026619434356689
(59) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00049209594726562
(60) DESCRIBE `orchid_image` 0.0020890235900879
(61) DESCRIBE `cruises` 0.0039520263671875
(62) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '84444') 0.00049591064453125
(63) DESCRIBE `ships` 0.0039591789245605
(64) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 223))) 0.00061607360839844
(65) DESCRIBE `ships` 0.0041489601135254
(66) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '223') 0.00050497055053711
(67) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00036001205444336
(68) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.0004270076751709
(69) DESCRIBE `itineraries` 0.0021140575408936
(70) DESCRIBE `ports` 0.0031909942626953
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00084710121154785
(72) DESCRIBE `ports` 0.0027990341186523
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00073695182800293
(74) DESCRIBE `ports` 0.0028889179229736
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00063085556030273
(76) DESCRIBE `sailingdates` 0.0024120807647705
(77) DESCRIBE `ports` 0.0028421878814697
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00052404403686523
(79) DESCRIBE `ports` 0.002094030380249
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00043296813964844
(81) DESCRIBE `ports` 0.0019400119781494
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00043702125549316
(83) DESCRIBE `ports` 0.0017740726470947
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00039911270141602
(85) DESCRIBE `ports` 0.0018799304962158
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1190))) 0.00041985511779785
(87) DESCRIBE `ports` 0.0018019676208496
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1190') 0.00042104721069336
(89) DESCRIBE `ports` 0.001910924911499
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00059199333190918
(91) DESCRIBE `ports` 0.0019710063934326
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00054597854614258
(93) DESCRIBE `ports` 0.0019879341125488
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00047802925109863
(95) DESCRIBE `ports` 0.001990795135498
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00044393539428711
(97) DESCRIBE `ports` 0.0018489360809326
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00053095817565918
(99) DESCRIBE `ports` 0.001943826675415
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00055289268493652
(101) DESCRIBE `ports` 0.0020408630371094
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00053787231445312
(103) DESCRIBE `ports` 0.0017788410186768
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00037813186645508
(105) DESCRIBE `ports` 0.0018880367279053
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00041508674621582
(107) DESCRIBE `ports` 0.0019102096557617
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00037884712219238
(109) DESCRIBE `ports` 0.0017638206481934
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2159))) 0.00046491622924805
(111) DESCRIBE `ports` 0.0019330978393555
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2159') 0.00039792060852051
(113) DESCRIBE `ports` 0.002234935760498
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 118))) 0.00045895576477051
(115) DESCRIBE `ports` 0.0020740032196045
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '118') 0.00045108795166016
(117) DESCRIBE `ports` 0.0018701553344727
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00042200088500977
(119) DESCRIBE `ports` 0.0018579959869385
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00046801567077637
(121) DESCRIBE `ports` 0.0021939277648926
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 363))) 0.00043797492980957
(123) DESCRIBE `ports` 0.0024280548095703
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '363') 0.00054097175598145
(125) DESCRIBE `ports` 0.0025961399078369
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 363))) 0.00061321258544922
(127) DESCRIBE `ports` 0.0025479793548584
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '363') 0.00055599212646484
(129) DESCRIBE `ports` 0.0025119781494141
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00052118301391602
(131) DESCRIBE `ports` 0.0024960041046143
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00047183036804199
(133) DESCRIBE `ports` 0.0025849342346191
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.0005638599395752
(135) DESCRIBE `ports` 0.0023541450500488
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00038504600524902
(137) DESCRIBE `ports` 0.0018157958984375
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00045394897460938
(139) DESCRIBE `ports` 0.0017271041870117
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00043392181396484
(141) DESCRIBE `ports` 0.0027761459350586
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 352))) 0.00043988227844238
(143) DESCRIBE `ports` 0.0018398761749268
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '352') 0.00041794776916504
(145) DESCRIBE `ports` 0.0019941329956055
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00042295455932617
(147) DESCRIBE `ports` 0.0018939971923828
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00040102005004883
(149) DESCRIBE `avid_specials` 0.0016460418701172
(150) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 84444 and class = 'Cruise') OR (item_id = 223 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 11 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.0011849403381348
(151) DESCRIBE `cruiselines` 0.0029761791229248
(152) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00061488151550293
(153) DESCRIBE `orchid_image` 0.0026371479034424
(154) DESCRIBE `cruises` 0.00360107421875
(155) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72590') 0.00042104721069336
(156) DESCRIBE `ships` 0.003464937210083
(157) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 148))) 0.00046801567077637
(158) DESCRIBE `ships` 0.0037970542907715
(159) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '148') 0.00045204162597656
(160) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00037097930908203
(161) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00036501884460449
(162) DESCRIBE `itineraries` 0.0018990039825439
(163) DESCRIBE `ports` 0.001939058303833
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0004580020904541
(165) DESCRIBE `ports` 0.0018570423126221
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00041818618774414
(167) DESCRIBE `ports` 0.0018041133880615
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0003819465637207
(169) DESCRIBE `sailingdates` 0.001676082611084
(170) DESCRIBE `ports` 0.0020220279693604
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0004727840423584
(172) DESCRIBE `ports` 0.0019040107727051
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00042510032653809
(174) DESCRIBE `ports` 0.0020148754119873
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00045514106750488
(176) DESCRIBE `ports` 0.0020339488983154
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00042104721069336
(178) DESCRIBE `ports` 0.0021178722381592
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3963))) 0.00044393539428711
(180) DESCRIBE `ports` 0.0021369457244873
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3963') 0.00065898895263672
(182) DESCRIBE `ports` 0.0025970935821533
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.00057291984558105
(184) DESCRIBE `ports` 0.0027070045471191
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.0005180835723877
(186) DESCRIBE `ports` 0.0027101039886475
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00056886672973633
(188) DESCRIBE `ports` 0.0018339157104492
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00037789344787598
(190) DESCRIBE `ports` 0.0017449855804443
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 533))) 0.00040793418884277
(192) DESCRIBE `ports` 0.0017330646514893
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '533') 0.00036907196044922
(194) DESCRIBE `ports` 0.0018329620361328
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 205))) 0.00041103363037109
(196) DESCRIBE `ports` 0.0017468929290771
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '205') 0.00038790702819824
(198) DESCRIBE `ports` 0.0018100738525391
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 204))) 0.00040912628173828
(200) DESCRIBE `ports` 0.0018649101257324
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '204') 0.00038695335388184
(202) DESCRIBE `ports` 0.0017991065979004
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 204))) 0.00039100646972656
(204) DESCRIBE `ports` 0.0017459392547607
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '204') 0.00040411949157715
(206) DESCRIBE `ports` 0.0017721652984619
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00066995620727539
(208) DESCRIBE `ports` 0.0020289421081543
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00052881240844727
(210) DESCRIBE `ports` 0.0020418167114258
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00061917304992676
(212) DESCRIBE `ports` 0.0019309520721436
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00043916702270508
(214) DESCRIBE `avid_specials` 0.010890007019043
(215) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72590 and class = 'Cruise') OR (item_id = 148 AND class = 'Ship') OR (item_id = 29 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.0012600421905518
(216) DESCRIBE `cruiselines` 0.002748966217041
(217) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.0012149810791016
(218) DESCRIBE `orchid_image` 0.0024428367614746
(219) DESCRIBE `cruises` 0.0038621425628662
(220) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73089') 0.0006108283996582
(221) DESCRIBE `ships` 0.0056700706481934
(222) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 223))) 0.00075101852416992
(223) DESCRIBE `ships` 0.0056219100952148
(224) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '223') 0.00066399574279785
(225) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00036907196044922
(226) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00035595893859863
(227) DESCRIBE `itineraries` 0.0023841857910156
(228) DESCRIBE `ports` 0.0023880004882812
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00057101249694824
(230) DESCRIBE `ports` 0.0022737979888916
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00055289268493652
(232) DESCRIBE `ports` 0.0021581649780273
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00049281120300293
(234) DESCRIBE `sailingdates` 0.0017321109771729
(235) DESCRIBE `ports` 0.0024740695953369
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00059199333190918
(237) DESCRIBE `ports` 0.0022621154785156
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00051212310791016
(239) DESCRIBE `ports` 0.0023210048675537
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00056815147399902
(241) DESCRIBE `ports` 0.0019838809967041
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00047111511230469
(243) DESCRIBE `ports` 0.0024099349975586
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1190))) 0.00050091743469238
(245) DESCRIBE `ports` 0.0020999908447266
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1190') 0.00046086311340332
(247) DESCRIBE `ports` 0.00211501121521
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.00053906440734863
(249) DESCRIBE `ports` 0.0020251274108887
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00053596496582031
(251) DESCRIBE `ports` 0.0022220611572266
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00050711631774902
(253) DESCRIBE `ports` 0.0022130012512207
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.0005500316619873
(255) DESCRIBE `ports` 0.0025641918182373
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00082802772521973
(257) DESCRIBE `ports` 0.0022110939025879
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00054597854614258
(259) DESCRIBE `ports` 0.0040168762207031
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00075507164001465
(261) DESCRIBE `ports` 0.0025010108947754
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00057101249694824
(263) DESCRIBE `ports` 0.0025510787963867
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00063490867614746
(265) DESCRIBE `ports` 0.0027639865875244
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00066494941711426
(267) DESCRIBE `ports` 0.002655029296875
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2159))) 0.00063109397888184
(269) DESCRIBE `ports` 0.002500057220459
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2159') 0.00058889389038086
(271) DESCRIBE `ports` 0.0024731159210205
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 118))) 0.00063991546630859
(273) DESCRIBE `ports` 0.0023431777954102
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '118') 0.00055313110351562
(275) DESCRIBE `ports` 0.0029101371765137
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00058984756469727
(277) DESCRIBE `ports` 0.0024309158325195
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00059700012207031
(279) DESCRIBE `avid_specials` 0.0021219253540039
(280) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73089 and class = 'Cruise') OR (item_id = 223 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 11 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.0018911361694336
(281) DESCRIBE `cruiselines` 0.0035851001739502
(282) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00076794624328613
(283) DESCRIBE `orchid_image` 0.0027821063995361
(284) DESCRIBE `cruises` 0.004586935043335
(285) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72617') 0.00059914588928223
(286) DESCRIBE `ships` 0.0048198699951172
(287) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 768))) 0.00080680847167969
(288) DESCRIBE `ships` 0.0047388076782227
(289) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '768') 0.00082898139953613
(290) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00048208236694336
(291) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00050592422485352
(292) DESCRIBE `itineraries` 0.0025429725646973
(293) DESCRIBE `ports` 0.0028471946716309
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00065112113952637
(295) DESCRIBE `ports` 0.0024299621582031
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00055384635925293
(297) DESCRIBE `ports` 0.0025680065155029
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00056099891662598
(299) DESCRIBE `sailingdates` 0.0023460388183594
(300) DESCRIBE `ports` 0.0025801658630371
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00072789192199707
(302) DESCRIBE `ports` 0.0026588439941406
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00062704086303711
(304) DESCRIBE `ports` 0.0026359558105469
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 205))) 0.00060391426086426
(306) DESCRIBE `ports` 0.0025579929351807
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '205') 0.00055193901062012
(308) DESCRIBE `ports` 0.002547025680542
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 204))) 0.00052618980407715
(310) DESCRIBE `ports` 0.0024769306182861
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '204') 0.00055217742919922
(312) DESCRIBE `ports` 0.0026428699493408
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00056982040405273
(314) DESCRIBE `ports` 0.0026137828826904
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00049400329589844
(316) DESCRIBE `ports` 0.0023870468139648
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00058102607727051
(318) DESCRIBE `ports` 0.002377986907959
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00059986114501953
(320) DESCRIBE `ports` 0.0030272006988525
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 429))) 0.00061798095703125
(322) DESCRIBE `ports` 0.002730131149292
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '429') 0.00065898895263672
(324) DESCRIBE `ports` 0.002673864364624
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 609))) 0.00061702728271484
(326) DESCRIBE `ports` 0.0025920867919922
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '609') 0.00056815147399902
(328) DESCRIBE `ports` 0.0025739669799805
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00060105323791504
(330) DESCRIBE `ports` 0.0025351047515869
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00053787231445312
(332) DESCRIBE `avid_specials` 0.0021939277648926
(333) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72617 and class = 'Cruise') OR (item_id = 768 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 45 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.00211501121521
(334) DESCRIBE `cruiselines` 0.0035400390625
(335) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00079202651977539
(336) DESCRIBE `orchid_image` 0.0027079582214355
(337) DESCRIBE `cruises` 0.0050158500671387
(338) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63617') 0.00055384635925293
(339) DESCRIBE `ships` 0.0049741268157959
(340) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1095))) 0.00086498260498047
(341) DESCRIBE `ships` 0.0049731731414795
(342) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1095') 0.0005640983581543
(343) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00046706199645996
(344) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0004580020904541
(345) DESCRIBE `itineraries` 0.0024499893188477
(346) DESCRIBE `ports` 0.0025820732116699
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2595))) 0.00062012672424316
(348) DESCRIBE `ports` 0.0027589797973633
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2595))) 0.00057697296142578
(350) DESCRIBE `ports` 0.0025589466094971
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2595') 0.00057196617126465
(352) DESCRIBE `sailingdates` 0.002119779586792
(353) DESCRIBE `ports` 0.0027170181274414
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2595))) 0.00073790550231934
(355) DESCRIBE `ports` 0.0024030208587646
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2595') 0.00055503845214844
(357) DESCRIBE `ports` 0.0024139881134033
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2597))) 0.00061416625976562
(359) DESCRIBE `ports` 0.0023899078369141
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2597') 0.0004730224609375
(361) DESCRIBE `ports` 0.0023012161254883
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5369))) 0.00059890747070312
(363) DESCRIBE `ports` 0.0025200843811035
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5369') 0.00053787231445312
(365) DESCRIBE `ports` 0.0026259422302246
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2599))) 0.00058197975158691
(367) DESCRIBE `ports` 0.0024449825286865
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2599') 0.00050997734069824
(369) DESCRIBE `ports` 0.0026290416717529
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4182))) 0.00053000450134277
(371) DESCRIBE `ports` 0.002467155456543
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4182') 0.00076389312744141
(373) DESCRIBE `ports` 0.0024619102478027
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4452))) 0.0005340576171875
(375) DESCRIBE `ports` 0.002439022064209
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4452') 0.00053000450134277
(377) DESCRIBE `ports` 0.0026049613952637
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4453))) 0.00057315826416016
(379) DESCRIBE `ports` 0.0027401447296143
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4453') 0.00052499771118164
(381) DESCRIBE `ports` 0.0025110244750977
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2663))) 0.0004119873046875
(383) DESCRIBE `ports` 0.0083069801330566
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2663') 0.00041699409484863
(385) DESCRIBE `ports` 0.0018761157989502
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4183))) 0.00058388710021973
(387) DESCRIBE `ports` 0.0017518997192383
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4183') 0.00036501884460449
(389) DESCRIBE `ports` 0.0018079280853271
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2527))) 0.00040984153747559
(391) DESCRIBE `ports` 0.0045769214630127
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2527') 0.00037598609924316
(393) DESCRIBE `ports` 0.0017380714416504
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2666))) 0.0093131065368652
(395) DESCRIBE `ports` 0.0020210742950439
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2666') 0.00049519538879395
(397) DESCRIBE `ports` 0.0018699169158936
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2671))) 0.00043702125549316
(399) DESCRIBE `ports` 0.0018320083618164
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2671') 0.00037884712219238
(401) DESCRIBE `avid_specials` 0.010024070739746
(402) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63617 and class = 'Cruise') OR (item_id = 1095 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 37 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.00142502784729
(403) DESCRIBE `cruiselines` 0.0027811527252197
(404) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00050497055053711
(405) DESCRIBE `orchid_image` 0.0022971630096436
(406) DESCRIBE `cruises` 0.0084421634674072
(407) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76711') 0.00075006484985352
(408) DESCRIBE `ships` 0.0093569755554199
(409) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 149))) 0.00063014030456543
(410) DESCRIBE `ships` 0.0040628910064697
(411) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '149') 0.0073931217193604
(412) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00035381317138672
(413) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00033903121948242
(414) DESCRIBE `itineraries` 0.001816987991333
(415) DESCRIBE `ports` 0.002781867980957
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.0004580020904541
(417) DESCRIBE `ports` 0.008432149887085
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.0006721019744873
(419) DESCRIBE `ports` 0.0023159980773926
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00057101249694824
(421) DESCRIBE `sailingdates` 0.0017640590667725
(422) DESCRIBE `ports` 0.0019540786743164
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00042414665222168
(424) DESCRIBE `ports` 0.0027601718902588
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00060701370239258
(426) DESCRIBE `ports` 0.0027031898498535
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00069499015808105
(428) DESCRIBE `ports` 0.0027379989624023
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.0005640983581543
(430) DESCRIBE `ports` 0.0030360221862793
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 702))) 0.0007169246673584
(432) DESCRIBE `ports` 0.0044610500335693
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '702') 0.00059986114501953
(434) DESCRIBE `ports` 0.0024878978729248
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00068306922912598
(436) DESCRIBE `ports` 0.0028600692749023
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.00064301490783691
(438) DESCRIBE `ports` 0.0027980804443359
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00059199333190918
(440) DESCRIBE `ports` 0.0024988651275635
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00042510032653809
(442) DESCRIBE `ports` 0.0020029544830322
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00065016746520996
(444) DESCRIBE `ports` 0.0029420852661133
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00066184997558594
(446) DESCRIBE `ports` 0.0029590129852295
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00056314468383789
(448) DESCRIBE `ports` 0.0020630359649658
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00045680999755859
(450) DESCRIBE `ports` 0.0021219253540039
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2159))) 0.00060820579528809
(452) DESCRIBE `ports` 0.0021071434020996
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2159') 0.00058484077453613
(454) DESCRIBE `ports` 0.0026609897613525
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00062203407287598
(456) DESCRIBE `ports` 0.0019509792327881
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00046992301940918
(458) DESCRIBE `ports` 0.0018298625946045
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00043296813964844
(460) DESCRIBE `ports` 0.0020720958709717
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00040411949157715
(462) DESCRIBE `ports` 0.0025889873504639
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1095))) 0.00065779685974121
(464) DESCRIBE `ports` 0.0036759376525879
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1095') 0.00089097023010254
(466) DESCRIBE `ports` 0.0028431415557861
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1388))) 0.0005490779876709
(468) DESCRIBE `ports` 0.0025179386138916
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1388') 0.00051498413085938
(470) DESCRIBE `avid_specials` 0.0021770000457764
(471) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76711 and class = 'Cruise') OR (item_id = 149 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 11 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.0020351409912109
(472) DESCRIBE `cruiselines` 0.0036330223083496
(473) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00064706802368164
(474) DESCRIBE `orchid_image` 0.0028049945831299
(475) DESCRIBE `cruises` 0.0048389434814453
(476) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77383') 0.00059008598327637
(477) DESCRIBE `ships` 0.0050878524780273
(478) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 717))) 0.00072717666625977
(479) DESCRIBE `ships` 0.0051300525665283
(480) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '717') 0.00065398216247559
(481) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00050711631774902
(482) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00046992301940918
(483) DESCRIBE `itineraries` 0.0030670166015625
(484) DESCRIBE `ports` 0.0027191638946533
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.0007169246673584
(486) DESCRIBE `ports` 0.0028209686279297
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.00072383880615234
(488) DESCRIBE `ports` 0.0053529739379883
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.00058197975158691
(490) DESCRIBE `sailingdates` 0.0018930435180664
(491) DESCRIBE `ports` 0.0022327899932861
(492) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.0004730224609375
(493) DESCRIBE `ports` 0.0018148422241211
(494) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.00041007995605469
(495) DESCRIBE `ports` 0.0017929077148438
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 619))) 0.00042009353637695
(497) DESCRIBE `ports` 0.0018701553344727
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '619') 0.0003809928894043
(499) DESCRIBE `ports` 0.0020442008972168
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 620))) 0.0004279613494873
(501) DESCRIBE `ports` 0.0018289089202881
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '620') 0.0005500316619873
(503) DESCRIBE `ports` 0.0027248859405518
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2150))) 0.00059103965759277
(505) DESCRIBE `ports` 0.0026149749755859
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2150') 0.00056982040405273
(507) DESCRIBE `ports` 0.0026838779449463
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3676))) 0.00060486793518066
(509) DESCRIBE `ports` 0.0025980472564697
(510) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3676') 0.00066518783569336
(511) DESCRIBE `ports` 0.002561092376709
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3040))) 0.00060296058654785
(513) DESCRIBE `ports` 0.0026640892028809
(514) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3040') 0.00077104568481445
(515) DESCRIBE `ports` 0.0029008388519287
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4864))) 0.00070595741271973
(517) DESCRIBE `ports` 0.0028290748596191
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4864') 0.00060510635375977
(519) DESCRIBE `ports` 0.0026340484619141
(520) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1874))) 0.00066709518432617
(521) DESCRIBE `ports` 0.0029571056365967
(522) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1874') 0.00070381164550781
(523) DESCRIBE `ports` 0.0031909942626953
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5468))) 0.00081896781921387
(525) DESCRIBE `ports` 0.0033740997314453
(526) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5468') 0.00087404251098633
(527) DESCRIBE `ports` 0.0028510093688965
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 879))) 0.00070714950561523
(529) DESCRIBE `ports` 0.0024359226226807
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '879') 0.00048398971557617
(531) DESCRIBE `avid_specials` 0.0018720626831055
(532) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77383 and class = 'Cruise') OR (item_id = 717 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 37 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.0011579990386963
(533) DESCRIBE `cruiselines` 0.0027039051055908
(534) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00049400329589844
(535) DESCRIBE `orchid_image` 0.0022048950195312
(536) DESCRIBE `cruises` 0.0042619705200195
(537) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72515') 0.00055885314941406
(538) DESCRIBE `ships` 0.004133939743042
(539) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 147))) 0.00051498413085938
(540) DESCRIBE `ships` 0.0038189888000488
(541) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '147') 0.00049614906311035
(542) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00039291381835938
(543) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00037193298339844
(544) DESCRIBE `itineraries` 0.0018069744110107
(545) DESCRIBE `ports` 0.0019879341125488
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 431))) 0.00049209594726562
(547) DESCRIBE `ports` 0.0018901824951172
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 431))) 0.00046300888061523
(549) DESCRIBE `ports` 0.002514123916626
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '431') 0.00050687789916992
(551) DESCRIBE `sailingdates` 0.0021979808807373
(552) DESCRIBE `ports` 0.0024580955505371
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 431))) 0.00060606002807617
(554) DESCRIBE `ports` 0.0024950504302979
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '431') 0.00052499771118164
(556) DESCRIBE `ports` 0.002485990524292
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1854))) 0.00063800811767578
(558) DESCRIBE `ports` 0.0026421546936035
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1854') 0.00053286552429199
(560) DESCRIBE `ports` 0.002047061920166
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 336))) 0.00044703483581543
(562) DESCRIBE `ports` 0.0018022060394287
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '336') 0.00040888786315918
(564) DESCRIBE `ports` 0.0023610591888428
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1861))) 0.00055289268493652
(566) DESCRIBE `ports` 0.0020511150360107
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1861') 0.00042200088500977
(568) DESCRIBE `ports` 0.0019428730010986
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1855))) 0.00046491622924805
(570) DESCRIBE `ports` 0.0019118785858154
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1855') 0.00052905082702637
(572) DESCRIBE `ports` 0.0020430088043213
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 335))) 0.00045394897460938
(574) DESCRIBE `ports` 0.0019059181213379
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '335') 0.00043892860412598
(576) DESCRIBE `ports` 0.0020921230316162
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 324))) 0.00044488906860352
(578) DESCRIBE `ports` 0.0018720626831055
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '324') 0.00039982795715332
(580) DESCRIBE `ports` 0.002047061920166
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3570))) 0.00043702125549316
(582) DESCRIBE `ports` 0.0018830299377441
(583) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3570') 0.00042986869812012
(584) DESCRIBE `ports` 0.0017750263214111
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 323))) 0.00046181678771973
(586) DESCRIBE `ports` 0.0021932125091553
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '323') 0.00039505958557129
(588) DESCRIBE `ports` 0.0019519329071045
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 882))) 0.00040197372436523
(590) DESCRIBE `ports` 0.0022120475769043
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '882') 0.0003819465637207
(592) DESCRIBE `ports` 0.001741886138916
(593) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3362))) 0.00039386749267578
(594) DESCRIBE `ports` 0.0017600059509277
(595) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3362') 0.00037598609924316
(596) DESCRIBE `ports` 0.0018529891967773
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5735))) 0.00046992301940918
(598) DESCRIBE `ports` 0.0019490718841553
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5735') 0.00038695335388184
(600) DESCRIBE `ports` 0.0020060539245605
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5286))) 0.00044798851013184
(602) DESCRIBE `ports` 0.0017690658569336
(603) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5286') 0.00048589706420898
(604) DESCRIBE `ports` 0.0018310546875
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2374))) 0.00043702125549316
(606) DESCRIBE `ports` 0.0022060871124268
(607) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2374') 0.00054287910461426
(608) DESCRIBE `ports` 0.0025238990783691
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2374))) 0.00043201446533203
(610) DESCRIBE `ports` 0.0019028186798096
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2374') 0.00042295455932617
(612) DESCRIBE `ports` 0.0018980503082275
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00044584274291992
(614) DESCRIBE `ports` 0.0024549961090088
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00048995018005371
(616) DESCRIBE `ports` 0.002216100692749
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5789))) 0.00043487548828125
(618) DESCRIBE `ports` 0.0024352073669434
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5789') 0.0005190372467041
(620) DESCRIBE `ports` 0.0026447772979736
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1697))) 0.00058889389038086
(622) DESCRIBE `ports` 0.0026609897613525
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1697') 0.00050687789916992
(624) DESCRIBE `ports` 0.0026059150695801
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5790))) 0.00058197975158691
(626) DESCRIBE `ports` 0.0025818347930908
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5790') 0.00051403045654297
(628) DESCRIBE `ports` 0.0025608539581299
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1035))) 0.00056886672973633
(630) DESCRIBE `ports` 0.0025160312652588
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1035') 0.00058102607727051
(632) DESCRIBE `ports` 0.002856969833374
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 476))) 0.00065898895263672
(634) DESCRIBE `ports` 0.0022759437561035
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '476') 0.00043797492980957
(636) DESCRIBE `ports` 0.001957893371582
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00046014785766602
(638) DESCRIBE `ports` 0.0019500255584717
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00040507316589355
(640) DESCRIBE `avid_specials` 0.0022051334381104
(641) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72515 and class = 'Cruise') OR (item_id = 147 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 37 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.0016648769378662
(642) DESCRIBE `cruiselines` 0.0036170482635498
(643) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00062918663024902
(644) DESCRIBE `orchid_image` 0.0030639171600342
(645) DESCRIBE `cruises` 0.0045990943908691
(646) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77522') 0.00057601928710938
(647) DESCRIBE `ships` 0.00484299659729
(648) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 223))) 0.00075197219848633
(649) DESCRIBE `ships` 0.004802942276001
(650) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '223') 0.00059890747070312
(651) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00051712989807129
(652) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00043201446533203
(653) DESCRIBE `itineraries` 0.0025179386138916
(654) DESCRIBE `ports` 0.0027310848236084
(655) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00059199333190918
(656) DESCRIBE `ports` 0.0025091171264648
(657) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00058317184448242
(658) DESCRIBE `ports` 0.0025599002838135
(659) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00058388710021973
(660) DESCRIBE `sailingdates` 0.0025489330291748
(661) DESCRIBE `ports` 0.0028679370880127
(662) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00072717666625977
(663) DESCRIBE `ports` 0.0028219223022461
(664) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00059103965759277
(665) DESCRIBE `ports` 0.0028359889984131
(666) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 363))) 0.00070405006408691
(667) DESCRIBE `ports` 0.0028119087219238
(668) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '363') 0.00061202049255371
(669) DESCRIBE `ports` 0.0028789043426514
(670) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 363))) 0.00065398216247559
(671) DESCRIBE `ports` 0.002842903137207
(672) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '363') 0.00059103965759277
(673) DESCRIBE `ports` 0.0027701854705811
(674) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00058603286743164
(675) DESCRIBE `ports` 0.002781867980957
(676) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00058889389038086
(677) DESCRIBE `ports` 0.0027859210968018
(678) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00078511238098145
(679) DESCRIBE `ports` 0.0028190612792969
(680) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.0006098747253418
(681) DESCRIBE `ports` 0.0028319358825684
(682) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00066685676574707
(683) DESCRIBE `ports` 0.0028419494628906
(684) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00058388710021973
(685) DESCRIBE `ports` 0.0027909278869629
(686) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 352))) 0.00068497657775879
(687) DESCRIBE `ports` 0.0027270317077637
(688) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '352') 0.00057601928710938
(689) DESCRIBE `ports` 0.0027949810028076
(690) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00058698654174805
(691) DESCRIBE `ports` 0.0024468898773193
(692) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00048589706420898
(693) DESCRIBE `avid_specials` 0.002108097076416
(694) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77522 and class = 'Cruise') OR (item_id = 223 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0019710063934326
(695) DESCRIBE `cruiselines` 0.0035099983215332
(696) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00064420700073242
(697) DESCRIBE `orchid_image` 0.0026600360870361
(698) DESCRIBE `ships` 0.0051250457763672
(699) SELECT `ships`.* FROM `ships` WHERE (id IN ('768', '1398', '148', '223', '1810', '1095', '1757', '149', '147', '717', '1855')) ORDER BY FIND_IN_SET(id, '768,1398,148,223,1810,1095,1757,149,147,717,1855') 0.0026149749755859
(700) DESCRIBE `cruisetypes` 0.002284049987793
(701) DESCRIBE `destinations` 0.0033130645751953
(702) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('37', '22', '12', '35', '2', '7', '43', '38', '49', '28', '25', '26', '8', '11', '21', '40', '45', '30', '48', '52', '34')) ORDER BY FIND_IN_SET(id, '37,22,12,35,2,7,43,38,49,28,25,26,8,11,21,40,45,30,48,52,34') 0.0028560161590576
(703) DESCRIBE `cruiselines` 0.0037238597869873
(704) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00063204765319824
(705) DESCRIBE `cruiselines` 0.0036089420318604
(706) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00067400932312012