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

Total elapsed time: 1.1539962291718

# Query Time
(1) connect 0.0012540817260742
(2) DESCRIBE `cruises` 0.0062031745910645
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (65919, 65921, 65920, 71154, 80327, 75752, 75753, 75077, 75747, 75749)) ORDER BY FIND_IN_SET(id, '65919,65921,65920,71154,80327,75752,75753,75077,75747,75749') 0.0032849311828613
(4) DESCRIBE `cruises` 0.0047569274902344
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65919') 0.00060892105102539
(6) DESCRIBE `ships` 0.0047199726104736
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1554))) 0.00066900253295898
(8) DESCRIBE `ships` 0.0039451122283936
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1554') 0.00049185752868652
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00040698051452637
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034904479980469
(12) DESCRIBE `itineraries` 0.001878023147583
(13) DESCRIBE `ports` 0.002025842666626
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00049591064453125
(15) DESCRIBE `ports` 0.0019011497497559
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0003969669342041
(17) DESCRIBE `ports` 0.0020709037780762
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00039505958557129
(19) DESCRIBE `sailingdates` 0.0016951560974121
(20) DESCRIBE `ports` 0.0024449825286865
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00060200691223145
(22) DESCRIBE `ports` 0.0027470588684082
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00063800811767578
(24) DESCRIBE `ports` 0.0028090476989746
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0007178783416748
(26) DESCRIBE `ports` 0.0029611587524414
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00055980682373047
(28) DESCRIBE `ports` 0.0029017925262451
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0006108283996582
(30) DESCRIBE `ports` 0.0027930736541748
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00056600570678711
(32) DESCRIBE `avid_specials` 0.0022940635681152
(33) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65919 and class = 'Cruise') OR (item_id = 1554 AND class = 'Ship') OR (item_id = 183 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.0012040138244629
(34) DESCRIBE `cruiselines` 0.0026779174804688
(35) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00044488906860352
(36) DESCRIBE `orchid_image` 0.0021939277648926
(37) DESCRIBE `cruiselines` 0.0025680065155029
(38) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00045108795166016
(39) DESCRIBE `cruises` 0.0035867691040039
(40) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65921') 0.0004429817199707
(41) DESCRIBE `ships` 0.0036470890045166
(42) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1555))) 0.00047397613525391
(43) DESCRIBE `ships` 0.0036690235137939
(44) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1555') 0.00041794776916504
(45) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00041007995605469
(46) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00060391426086426
(47) DESCRIBE `itineraries` 0.0021460056304932
(48) DESCRIBE `ports` 0.0018219947814941
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00043797492980957
(50) DESCRIBE `ports` 0.0018320083618164
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00038695335388184
(52) DESCRIBE `ports` 0.0019211769104004
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00039315223693848
(54) DESCRIBE `sailingdates` 0.0015809535980225
(55) DESCRIBE `ports` 0.0023448467254639
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0004730224609375
(57) DESCRIBE `ports` 0.0021209716796875
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00043797492980957
(59) DESCRIBE `ports` 0.0018141269683838
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00043201446533203
(61) DESCRIBE `ports` 0.0018470287322998
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00037884712219238
(63) DESCRIBE `ports` 0.0020649433135986
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00052404403686523
(65) DESCRIBE `ports` 0.0023179054260254
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00041007995605469
(67) DESCRIBE `avid_specials` 0.0016679763793945
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65921 and class = 'Cruise') OR (item_id = 1555 AND class = 'Ship') OR (item_id = 183 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.0020449161529541
(69) DESCRIBE `cruiselines` 0.003803014755249
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00058317184448242
(71) DESCRIBE `orchid_image` 0.0030050277709961
(72) DESCRIBE `cruiselines` 0.0039880275726318
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00050592422485352
(74) DESCRIBE `cruises` 0.0040140151977539
(75) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65920') 0.00046300888061523
(76) DESCRIBE `ships` 0.0041069984436035
(77) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1554))) 0.00056290626525879
(78) DESCRIBE `ships` 0.0047969818115234
(79) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1554') 0.00060296058654785
(80) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035786628723145
(81) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034594535827637
(82) DESCRIBE `itineraries` 0.0018720626831055
(83) DESCRIBE `ports` 0.0019600391387939
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00053215026855469
(85) DESCRIBE `ports` 0.0018718242645264
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00039100646972656
(87) DESCRIBE `ports` 0.0019049644470215
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00039482116699219
(89) DESCRIBE `sailingdates` 0.0017228126525879
(90) DESCRIBE `ports` 0.0021078586578369
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00046586990356445
(92) DESCRIBE `ports` 0.0021359920501709
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0004119873046875
(94) DESCRIBE `ports` 0.0018951892852783
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00039291381835938
(96) DESCRIBE `ports` 0.0021259784698486
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00039410591125488
(98) DESCRIBE `avid_specials` 0.0020771026611328
(99) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65920 and class = 'Cruise') OR (item_id = 1554 AND class = 'Ship') OR (item_id = 183 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.0011940002441406
(100) DESCRIBE `cruiselines` 0.0026860237121582
(101) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00041413307189941
(102) DESCRIBE `orchid_image` 0.0022070407867432
(103) DESCRIBE `cruiselines` 0.0027620792388916
(104) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00044083595275879
(105) DESCRIBE `cruises` 0.0034871101379395
(106) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71154') 0.00042581558227539
(107) DESCRIBE `ships` 0.0035459995269775
(108) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1555))) 0.00054788589477539
(109) DESCRIBE `ships` 0.0035150051116943
(110) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1555') 0.00042486190795898
(111) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034713745117188
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00033307075500488
(113) DESCRIBE `itineraries` 0.0019230842590332
(114) DESCRIBE `ports` 0.0021989345550537
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00047111511230469
(116) DESCRIBE `ports` 0.0021588802337646
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00043201446533203
(118) DESCRIBE `ports` 0.001953125
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0004889965057373
(120) DESCRIBE `sailingdates` 0.0017008781433105
(121) DESCRIBE `ports` 0.002453088760376
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00065708160400391
(123) DESCRIBE `ports` 0.0026309490203857
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00043416023254395
(125) DESCRIBE `ports` 0.0019838809967041
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00046277046203613
(127) DESCRIBE `ports` 0.0019040107727051
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00040197372436523
(129) DESCRIBE `avid_specials` 0.001716136932373
(130) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71154 and class = 'Cruise') OR (item_id = 1555 AND class = 'Ship') OR (item_id = 183 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.0011157989501953
(131) DESCRIBE `cruiselines` 0.0029761791229248
(132) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00050497055053711
(133) DESCRIBE `orchid_image` 0.0021021366119385
(134) DESCRIBE `cruiselines` 0.0026841163635254
(135) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00040411949157715
(136) DESCRIBE `cruises` 0.0039889812469482
(137) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '80327') 0.0005030632019043
(138) DESCRIBE `ships` 0.0046260356903076
(139) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1761))) 0.00058197975158691
(140) DESCRIBE `ships` 0.003741979598999
(141) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1761') 0.00045895576477051
(142) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035309791564941
(143) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00038695335388184
(144) DESCRIBE `itineraries` 0.0018751621246338
(145) DESCRIBE `ports` 0.00189208984375
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00043201446533203
(147) DESCRIBE `ports` 0.0017969608306885
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00044918060302734
(149) DESCRIBE `ports` 0.0021131038665771
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00041007995605469
(151) DESCRIBE `sailingdates` 0.0016000270843506
(152) DESCRIBE `ports` 0.0022652149200439
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.00046300888061523
(154) DESCRIBE `ports` 0.0020861625671387
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00039982795715332
(156) DESCRIBE `ports` 0.0020990371704102
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4713))) 0.0004122257232666
(158) DESCRIBE `ports` 0.0023810863494873
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4713') 0.00055217742919922
(160) DESCRIBE `avid_specials` 0.0019450187683105
(161) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 80327 and class = 'Cruise') OR (item_id = 1761 AND class = 'Ship') OR (item_id = 183 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.002100944519043
(162) DESCRIBE `cruiselines` 0.0036928653717041
(163) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.0006871223449707
(164) DESCRIBE `orchid_image` 0.0028860569000244
(165) DESCRIBE `cruiselines` 0.0032589435577393
(166) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00040221214294434
(167) DESCRIBE `cruises` 0.0037059783935547
(168) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75752') 0.00056219100952148
(169) DESCRIBE `ships` 0.004688024520874
(170) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1594))) 0.0006110668182373
(171) DESCRIBE `ships` 0.0050830841064453
(172) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1594') 0.00053691864013672
(173) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035786628723145
(174) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00042104721069336
(175) DESCRIBE `itineraries` 0.0019152164459229
(176) DESCRIBE `ports` 0.0022640228271484
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.0004420280456543
(178) DESCRIBE `ports` 0.0024499893188477
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.0004880428314209
(180) DESCRIBE `ports` 0.0026919841766357
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00056791305541992
(182) DESCRIBE `sailingdates` 0.0018250942230225
(183) DESCRIBE `ports` 0.0019979476928711
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00058913230895996
(185) DESCRIBE `ports` 0.0022299289703369
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00042581558227539
(187) DESCRIBE `ports` 0.0022001266479492
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00050806999206543
(189) DESCRIBE `ports` 0.0022270679473877
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.0005180835723877
(191) DESCRIBE `ports` 0.0019910335540771
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00040912628173828
(193) DESCRIBE `ports` 0.0019171237945557
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00038409233093262
(195) DESCRIBE `ports` 0.0018851757049561
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00046396255493164
(197) DESCRIBE `ports` 0.002302885055542
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.0005950927734375
(199) DESCRIBE `ports` 0.0026910305023193
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00049281120300293
(201) DESCRIBE `ports` 0.003154993057251
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00070881843566895
(203) DESCRIBE `ports` 0.0020101070404053
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3488))) 0.00062704086303711
(205) DESCRIBE `ports` 0.0021960735321045
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3488') 0.00053191184997559
(207) DESCRIBE `ports` 0.0026609897613525
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00046706199645996
(209) DESCRIBE `ports` 0.0021100044250488
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00058794021606445
(211) DESCRIBE `ports` 0.0027000904083252
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.0006871223449707
(213) DESCRIBE `ports` 0.0029401779174805
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00069499015808105
(215) DESCRIBE `ports` 0.0029809474945068
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00066304206848145
(217) DESCRIBE `ports` 0.0021998882293701
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00050878524780273
(219) DESCRIBE `ports` 0.0022599697113037
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3679))) 0.00045585632324219
(221) DESCRIBE `ports` 0.0021531581878662
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3679') 0.00041794776916504
(223) DESCRIBE `ports` 0.0021278858184814
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.0004880428314209
(225) DESCRIBE `ports` 0.001978874206543
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00040912628173828
(227) DESCRIBE `ports` 0.0023250579833984
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00051188468933105
(229) DESCRIBE `ports` 0.0022871494293213
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00056219100952148
(231) DESCRIBE `ports` 0.0018460750579834
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00066089630126953
(233) DESCRIBE `ports` 0.0018939971923828
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00042104721069336
(235) DESCRIBE `ports` 0.0018579959869385
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.0004420280456543
(237) DESCRIBE `ports` 0.0019128322601318
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.0005638599395752
(239) DESCRIBE `ports` 0.0026109218597412
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00060510635375977
(241) DESCRIBE `ports` 0.0023980140686035
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00053596496582031
(243) DESCRIBE `ports` 0.0026600360870361
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00043392181396484
(245) DESCRIBE `ports` 0.0022029876708984
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00041294097900391
(247) DESCRIBE `ports` 0.002051830291748
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00053620338439941
(249) DESCRIBE `ports` 0.002039909362793
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00059700012207031
(251) DESCRIBE `ports` 0.0030090808868408
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0006558895111084
(253) DESCRIBE `ports` 0.0029449462890625
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00057792663574219
(255) DESCRIBE `ports` 0.0027210712432861
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00068521499633789
(257) DESCRIBE `ports` 0.0027320384979248
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00041007995605469
(259) DESCRIBE `ports` 0.001943826675415
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00053310394287109
(261) DESCRIBE `ports` 0.0019528865814209
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00046586990356445
(263) DESCRIBE `ports` 0.0020689964294434
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00049114227294922
(265) DESCRIBE `ports` 0.0019309520721436
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00040388107299805
(267) DESCRIBE `ports` 0.0020170211791992
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00044798851013184
(269) DESCRIBE `ports` 0.0019679069519043
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00050497055053711
(271) DESCRIBE `avid_specials` 0.0024318695068359
(272) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75752 and class = 'Cruise') OR (item_id = 1594 AND class = 'Ship') OR (item_id = 101 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.0018410682678223
(273) DESCRIBE `cruiselines` 0.0031259059906006
(274) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00057196617126465
(275) DESCRIBE `orchid_image` 0.0023131370544434
(276) DESCRIBE `cruiselines` 0.0032589435577393
(277) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00067400932312012
(278) DESCRIBE `cruises` 0.0063331127166748
(279) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75753') 0.00061392784118652
(280) DESCRIBE `ships` 0.0047481060028076
(281) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1237))) 0.0007469654083252
(282) DESCRIBE `ships` 0.0038940906524658
(283) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1237') 0.00060081481933594
(284) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00038003921508789
(285) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00047802925109863
(286) DESCRIBE `itineraries` 0.0020608901977539
(287) DESCRIBE `ports` 0.0021929740905762
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00063204765319824
(289) DESCRIBE `ports` 0.001964807510376
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00048112869262695
(291) DESCRIBE `ports` 0.0021309852600098
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.0005340576171875
(293) DESCRIBE `sailingdates` 0.0017969608306885
(294) DESCRIBE `ports` 0.0020549297332764
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00045299530029297
(296) DESCRIBE `ports` 0.0020480155944824
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00049400329589844
(298) DESCRIBE `ports` 0.0025529861450195
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.0006871223449707
(300) DESCRIBE `ports` 0.0030081272125244
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.0006411075592041
(302) DESCRIBE `ports` 0.0028409957885742
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.0006718635559082
(304) DESCRIBE `ports` 0.0020570755004883
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00043511390686035
(306) DESCRIBE `ports` 0.0019180774688721
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00046181678771973
(308) DESCRIBE `ports` 0.0019361972808838
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00044417381286621
(310) DESCRIBE `ports` 0.0020220279693604
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4135))) 0.00045299530029297
(312) DESCRIBE `ports` 0.0020179748535156
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4135') 0.00043892860412598
(314) DESCRIBE `ports` 0.0020380020141602
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00040411949157715
(316) DESCRIBE `ports` 0.0018939971923828
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00037598609924316
(318) DESCRIBE `ports` 0.0018208026885986
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00045394897460938
(320) DESCRIBE `ports` 0.0021839141845703
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00051712989807129
(322) DESCRIBE `ports` 0.0021898746490479
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00093603134155273
(324) DESCRIBE `ports` 0.0028610229492188
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00067901611328125
(326) DESCRIBE `ports` 0.0030012130737305
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3488))) 0.0006401538848877
(328) DESCRIBE `ports` 0.0028071403503418
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3488') 0.00056600570678711
(330) DESCRIBE `ports` 0.0025599002838135
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00050806999206543
(332) DESCRIBE `ports` 0.0020740032196045
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00054693222045898
(334) DESCRIBE `ports` 0.0022070407867432
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00045108795166016
(336) DESCRIBE `ports` 0.0026950836181641
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00058102607727051
(338) DESCRIBE `ports` 0.0020401477813721
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00040888786315918
(340) DESCRIBE `ports` 0.0027170181274414
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00057101249694824
(342) DESCRIBE `ports` 0.0028440952301025
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00070905685424805
(344) DESCRIBE `ports` 0.0027971267700195
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00055289268493652
(346) DESCRIBE `ports` 0.002810001373291
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00059604644775391
(348) DESCRIBE `ports` 0.002985954284668
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00056004524230957
(350) DESCRIBE `ports` 0.0027961730957031
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00061488151550293
(352) DESCRIBE `ports` 0.0027728080749512
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00057005882263184
(354) DESCRIBE `ports` 0.0027389526367188
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00061821937561035
(356) DESCRIBE `ports` 0.0030710697174072
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00056982040405273
(358) DESCRIBE `ports` 0.0028069019317627
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.0006558895111084
(360) DESCRIBE `ports` 0.0037670135498047
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00043606758117676
(362) DESCRIBE `ports` 0.0023119449615479
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00047993659973145
(364) DESCRIBE `ports` 0.0025489330291748
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00048184394836426
(366) DESCRIBE `ports` 0.002086877822876
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00064301490783691
(368) DESCRIBE `ports` 0.0027551651000977
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00054001808166504
(370) DESCRIBE `ports` 0.0029079914093018
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00058102607727051
(372) DESCRIBE `ports` 0.0022139549255371
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00046205520629883
(374) DESCRIBE `ports` 0.0022759437561035
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00062203407287598
(376) DESCRIBE `ports` 0.0025649070739746
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00065708160400391
(378) DESCRIBE `ports` 0.0024840831756592
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00061583518981934
(380) DESCRIBE `ports` 0.0027370452880859
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00068497657775879
(382) DESCRIBE `avid_specials` 0.0027339458465576
(383) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75753 and class = 'Cruise') OR (item_id = 1237 AND class = 'Ship') OR (item_id = 101 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.0022010803222656
(384) DESCRIBE `cruiselines` 0.0040678977966309
(385) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00073885917663574
(386) DESCRIBE `orchid_image` 0.0027439594268799
(387) DESCRIBE `cruiselines` 0.0027308464050293
(388) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00042891502380371
(389) DESCRIBE `cruises` 0.0038299560546875
(390) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75077') 0.00050806999206543
(391) DESCRIBE `ships` 0.0037190914154053
(392) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1152))) 0.00080490112304688
(393) DESCRIBE `ships` 0.0055890083312988
(394) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1152') 0.00069499015808105
(395) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00059080123901367
(396) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00049805641174316
(397) DESCRIBE `itineraries` 0.0028500556945801
(398) DESCRIBE `ports` 0.0030379295349121
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00068092346191406
(400) DESCRIBE `ports` 0.0026869773864746
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00059795379638672
(402) DESCRIBE `ports` 0.0024230480194092
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00056004524230957
(404) DESCRIBE `sailingdates` 0.0021238327026367
(405) DESCRIBE `ports` 0.0019779205322266
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00048494338989258
(407) DESCRIBE `ports` 0.0019259452819824
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00051307678222656
(409) DESCRIBE `ports` 0.0019669532775879
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.0004580020904541
(411) DESCRIBE `ports` 0.0018908977508545
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00058603286743164
(413) DESCRIBE `ports` 0.0027098655700684
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00061392784118652
(415) DESCRIBE `ports` 0.0027258396148682
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00058102607727051
(417) DESCRIBE `ports` 0.002655029296875
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00065302848815918
(419) DESCRIBE `ports` 0.0027680397033691
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.0006098747253418
(421) DESCRIBE `ports` 0.0027241706848145
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00067400932312012
(423) DESCRIBE `ports` 0.0027039051055908
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00059199333190918
(425) DESCRIBE `ports` 0.0029141902923584
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00069189071655273
(427) DESCRIBE `ports` 0.0028450489044189
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00060009956359863
(429) DESCRIBE `ports` 0.0027410984039307
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00064992904663086
(431) DESCRIBE `ports` 0.0026810169219971
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00067901611328125
(433) DESCRIBE `ports` 0.0026590824127197
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00061798095703125
(435) DESCRIBE `ports` 0.0027070045471191
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00057315826416016
(437) DESCRIBE `ports` 0.0027658939361572
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.0006718635559082
(439) DESCRIBE `ports` 0.0026440620422363
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00055885314941406
(441) DESCRIBE `ports` 0.0026190280914307
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00070691108703613
(443) DESCRIBE `ports` 0.0030138492584229
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00061988830566406
(445) DESCRIBE `ports` 0.002687931060791
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00043487548828125
(447) DESCRIBE `ports` 0.0024900436401367
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00050902366638184
(449) DESCRIBE `ports` 0.0023729801177979
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00046491622924805
(451) DESCRIBE `ports` 0.0023810863494873
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00041794776916504
(453) DESCRIBE `ports` 0.0020298957824707
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00044012069702148
(455) DESCRIBE `ports` 0.0019090175628662
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00046396255493164
(457) DESCRIBE `ports` 0.0018529891967773
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.00059890747070312
(459) DESCRIBE `ports` 0.0018398761749268
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00040602684020996
(461) DESCRIBE `ports` 0.0020809173583984
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.0004270076751709
(463) DESCRIBE `ports` 0.0020499229431152
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00038790702819824
(465) DESCRIBE `ports` 0.0018210411071777
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 140))) 0.0004880428314209
(467) DESCRIBE `ports` 0.0018789768218994
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '140') 0.00038814544677734
(469) DESCRIBE `avid_specials` 0.0024940967559814
(470) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75077 and class = 'Cruise') OR (item_id = 1152 AND class = 'Ship') OR (item_id = 77 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.0023269653320312
(471) DESCRIBE `cruiselines` 0.0035369396209717
(472) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00062990188598633
(473) DESCRIBE `orchid_image` 0.0027971267700195
(474) DESCRIBE `cruiselines` 0.0035669803619385
(475) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00046896934509277
(476) DESCRIBE `cruises` 0.003565788269043
(477) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75747') 0.0004730224609375
(478) DESCRIBE `ships` 0.0046229362487793
(479) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1237))) 0.00088381767272949
(480) DESCRIBE `ships` 0.0057210922241211
(481) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1237') 0.00081896781921387
(482) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00055193901062012
(483) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00053501129150391
(484) DESCRIBE `itineraries` 0.0030779838562012
(485) DESCRIBE `ports` 0.0031459331512451
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00074195861816406
(487) DESCRIBE `ports` 0.0034351348876953
(488) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00065302848815918
(489) DESCRIBE `ports` 0.0026009082794189
(490) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00055289268493652
(491) DESCRIBE `sailingdates` 0.0018250942230225
(492) DESCRIBE `ports` 0.002065896987915
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00062298774719238
(494) DESCRIBE `ports` 0.002763032913208
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00059103965759277
(496) DESCRIBE `ports` 0.0024731159210205
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.0013608932495117
(498) DESCRIBE `ports` 0.0034248828887939
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00079894065856934
(500) DESCRIBE `ports` 0.0032958984375
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00088095664978027
(502) DESCRIBE `ports` 0.0033080577850342
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00070786476135254
(504) DESCRIBE `ports` 0.0033628940582275
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.0008549690246582
(506) DESCRIBE `ports` 0.0033421516418457
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00069713592529297
(508) DESCRIBE `ports` 0.0033628940582275
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4135))) 0.00083804130554199
(510) DESCRIBE `ports` 0.0033869743347168
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4135') 0.0007469654083252
(512) DESCRIBE `ports` 0.0032670497894287
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3679))) 0.00075292587280273
(514) DESCRIBE `ports` 0.0032069683074951
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3679') 0.00068116188049316
(516) DESCRIBE `ports` 0.0031070709228516
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00059294700622559
(518) DESCRIBE `ports` 0.0030398368835449
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00060415267944336
(520) DESCRIBE `ports` 0.0030300617218018
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00066304206848145
(522) DESCRIBE `ports` 0.0028400421142578
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00064206123352051
(524) DESCRIBE `ports` 0.0029981136322021
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00071287155151367
(526) DESCRIBE `ports` 0.0029468536376953
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00075984001159668
(528) DESCRIBE `ports` 0.002892017364502
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3488))) 0.00067400932312012
(530) DESCRIBE `ports` 0.0029590129852295
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3488') 0.0006561279296875
(532) DESCRIBE `ports` 0.0035130977630615
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00078415870666504
(534) DESCRIBE `ports` 0.0033779144287109
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00071406364440918
(536) DESCRIBE `ports` 0.0032410621643066
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00069594383239746
(538) DESCRIBE `ports` 0.0025811195373535
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00046014785766602
(540) DESCRIBE `ports` 0.0019659996032715
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00043320655822754
(542) DESCRIBE `ports` 0.001953125
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00044512748718262
(544) DESCRIBE `ports` 0.0018739700317383
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00043082237243652
(546) DESCRIBE `ports` 0.0020110607147217
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.0003969669342041
(548) DESCRIBE `ports` 0.0020139217376709
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.0005180835723877
(550) DESCRIBE `ports` 0.0019869804382324
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00038790702819824
(552) DESCRIBE `avid_specials` 0.001662015914917
(553) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75747 and class = 'Cruise') OR (item_id = 1237 AND class = 'Ship') OR (item_id = 101 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.0017209053039551
(554) DESCRIBE `cruiselines` 0.002856969833374
(555) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00049018859863281
(556) DESCRIBE `orchid_image` 0.0026319026947021
(557) DESCRIBE `cruiselines` 0.0036740303039551
(558) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00064396858215332
(559) DESCRIBE `cruises` 0.004878044128418
(560) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75749') 0.00046801567077637
(561) DESCRIBE `ships` 0.0041031837463379
(562) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1594))) 0.00060200691223145
(563) DESCRIBE `ships` 0.0046689510345459
(564) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1594') 0.00054311752319336
(565) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00040197372436523
(566) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0004570484161377
(567) DESCRIBE `itineraries` 0.0029489994049072
(568) DESCRIBE `ports` 0.0033011436462402
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00073814392089844
(570) DESCRIBE `ports` 0.0029909610748291
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00065708160400391
(572) DESCRIBE `ports` 0.0030500888824463
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.0005948543548584
(574) DESCRIBE `sailingdates` 0.0026099681854248
(575) DESCRIBE `ports` 0.0032880306243896
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00080609321594238
(577) DESCRIBE `ports` 0.0030519962310791
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00070405006408691
(579) DESCRIBE `ports` 0.0028321743011475
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00073790550231934
(581) DESCRIBE `ports` 0.0029199123382568
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00061392784118652
(583) DESCRIBE `ports` 0.0029981136322021
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00069117546081543
(585) DESCRIBE `ports` 0.0027241706848145
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.0005948543548584
(587) DESCRIBE `ports` 0.0029010772705078
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00081992149353027
(589) DESCRIBE `ports` 0.0029988288879395
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00063610076904297
(591) DESCRIBE `ports` 0.0028190612792969
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.0006871223449707
(593) DESCRIBE `ports` 0.0029089450836182
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00063395500183105
(595) DESCRIBE `ports` 0.0031008720397949
(596) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3488))) 0.00068902969360352
(597) DESCRIBE `ports` 0.0028290748596191
(598) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3488') 0.00066781044006348
(599) DESCRIBE `ports` 0.0026650428771973
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00075197219848633
(601) DESCRIBE `ports` 0.003115177154541
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00060701370239258
(603) DESCRIBE `ports` 0.0030148029327393
(604) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00068998336791992
(605) DESCRIBE `ports` 0.0027899742126465
(606) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00064301490783691
(607) DESCRIBE `ports` 0.0021209716796875
(608) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00057697296142578
(609) DESCRIBE `ports` 0.0024130344390869
(610) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00055909156799316
(611) DESCRIBE `ports` 0.0020520687103271
(612) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3679))) 0.00051093101501465
(613) DESCRIBE `ports` 0.0020740032196045
(614) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3679') 0.00041794776916504
(615) DESCRIBE `ports` 0.002065896987915
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00074505805969238
(617) DESCRIBE `ports` 0.0033488273620605
(618) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.0006859302520752
(619) DESCRIBE `ports` 0.0030159950256348
(620) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00071310997009277
(621) DESCRIBE `ports` 0.0031421184539795
(622) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.0006709098815918
(623) DESCRIBE `ports` 0.0028660297393799
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00068879127502441
(625) DESCRIBE `ports` 0.0029821395874023
(626) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00063896179199219
(627) DESCRIBE `ports` 0.0030150413513184
(628) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00074315071105957
(629) DESCRIBE `ports` 0.0030200481414795
(630) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00073909759521484
(631) DESCRIBE `avid_specials` 0.0025911331176758
(632) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75749 and class = 'Cruise') OR (item_id = 1594 AND class = 'Ship') OR (item_id = 101 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.0011701583862305
(633) DESCRIBE `cruiselines` 0.0033321380615234
(634) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 101))) 0.00054001808166504
(635) DESCRIBE `orchid_image` 0.0027821063995361
(636) DESCRIBE `cruiselines` 0.0038778781890869
(637) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '101') 0.00053691864013672
(638) DESCRIBE `cruiselines` 0.0044069290161133
(639) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '171', '23', '144', '12', '20', '7', '183', '18', '101', '8', '120', '31', '131', '29', '96', '15', '103', '206', '91', '33', '170', '262', '114', '24', '28', '14', '156', '191', '50', '258', '195', '37', '153', '16', '208', '187', '36', '49', '47', '88', '216', '251', '151', '141', '212', '181', '4', '110', '118', '59', '30', '140', '73', '115', '147', '261', '264', '48', '213', '159', '108', '276', '209', '211', '113', '90', '57', '82', '184', '95', '38', '180', '52', '244', '35', '105', '64', '134', '257', '172', '245', '177')) ORDER BY FIND_IN_SET(id, '218,77,19,26,171,23,144,12,20,7,183,18,101,8,120,31,131,29,96,15,103,206,91,33,170,262,114,24,28,14,156,191,50,258,195,37,153,16,208,187,36,49,47,88,216,251,151,141,212,181,4,110,118,59,30,140,73,115,147,261,264,48,213,159,108,276,209,211,113,90,57,82,184,95,38,180,52,244,35,105,64,134,257,172,245,177') 0.0084471702575684
(640) DESCRIBE `ships` 0.0040199756622314
(641) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '732', '1744', '517', '726', '258', '737', '780', '1417', '855', '1324', '1588', '1717', '207', '1794', '1291', '874', '871', '1594', '977', '1199', '1572', '454', '1766', '1359', '404', '1272', '770', '22', '330', '461', '1032', '974', '21', '393', '1237', '66', '716', '1424', '28', '797', '1292', '434', '738', '1682', '553', '1134', '332', '521', '1348', '265', '333', '711', '349', '766', '1768', '1415', '1260', '11', '857', '1419', '1423', '9', '585', '858', '1422', '1501', '1677', '10', '715', '792', '1418', '1420', '1421', '739', '163', '407', '439', '25', '34', '455', '31', '36', '378', '1678', '1132', '3', '24', '39', '657', '542', '674', '1205', '1460', '1008', '1141', '1721', '520', '837', '1067', '1607', '385', '1569', '1302', '1402', '1742', '1773', '386', '966', '1852', '113', '882', '1168', '35', '160', '1012', '1372', '850', '1233', '1454', '1574', '1822', '573', '626', '1135', '1455', '1505', '1811', '37', '98', '338', '768', '1319', '1602', '1676', '610', '30', '63', '285', '1021', '451', '1373', '352', '1284', '986', '1413', '38', '817', '1259', '1733', '547', '1282', '1411', '148', '1398', '1410', '108', '111', '314', '503', '1193', '1722', '1782', '43', '375', '406', '1088', '286', '1308', '1437', '748', '1108', '1711', '198', '340', '508', '526', '627', '1320', '1323', '1579', '116', '970', '1063', '1808', '1145', '1738', '124', '327', '485', '854', '883', '1325', '1586', '390', '582', '1571', '348', '590', '1149', '394', '1028', '1208', '1266', '119', '335', '1492', '1552', '1321', '1724', '480', '616', '944', '1068', '1412', '1575', '223', '791', '1587', '1672', '1810', '70', '82', '114', '652', '704', '1157', '75', '658', '1461', '1809', '4', '147', '545', '1027', '1801', '351', '441', '462', '678', '1289', '683', '1853', '69', '162', '325', '884', '988', '78', '201', '403', '405', '601', '722', '1245', '1318', '1330', '1408', '105', '401', '958', '1820', '291', '790', '1188', '1303', '149', '287', '341', '389', '818', '1073', '1139', '1486', '123', '262', '580', '651', '776', '1236', '81', '483', '1037', '1539', '1772', '1159', '1326', '1327', '1367', '1526', '1704', '1771', '423', '673', '1013', '1151', '1172', '1463', '1540', '266', '796', '1019', '1043', '1757', '290', '1040', '1554', '1555', '45', '574', '639', '968', '1474', '1573', '1730', '635', '1035', '1426', '1743', '84', '751', '775', '795', '1160', '1223', '1681', '1715', '852', '1217', '1338', '1344', '1740', '324', '717', '1029', '1283', '1716', '1758', '972', '1095', '1143', '1144', '1163', '1206', '1226', '1229', '1343', '1358', '1409', '1452', '1453', '1604', '1663', '665', '709', '905', '1045', '1048', '1146', '1150', '151', '212', '417', '643', '1405', '1483', '1673', '1807', '1833', '644', '851', '885', '1136', '1137', '1152', '1262', '1293', '1448', '1449', '1746', '1042', '1230', '1231', '1351', '1647', '1787', '467', '769', '1026', '1051', '1109', '1749', '1791', '150', '453', '1025', '1090', '1140', '1154', '1340', '1458', '1723', '1759', '1806', '208', '448', '663', '707', '954', '973', '1224', '1366', '1368', '1459', '1519', '1609', '1632', '1649', '1750', '1751', '1816', '559', '701', '740', '920', '996', '1044', '1049', '1050', '1052', '1148', '1196', '1274', '1329', '1354', '1360', '1361', '1362', '1601', '1708', '1713', '1805', '666', '914', '921', '923', '927', '1055', '1071', '1072', '1294', '1322', '1339', '1580', '1714', '1788', '1823', '14', '886', '915', '916', '926', '930', '931', '1047', '1599', '1854', '205', '703', '784', '924', '1039', '1350', '1352', '1389', '1596', '1650', '93', '253', '299', '300', '422', '1004', '1020', '1036', '1054', '1225', '1451', '1664', '479', '888', '937', '965', '1626', '1674', '27', '487', '672', '999', '1256')) ORDER BY FIND_IN_SET(id, '1761,732,1744,517,726,258,737,780,1417,855,1324,1588,1717,207,1794,1291,874,871,1594,977,1199,1572,454,1766,1359,404,1272,770,22,330,461,1032,974,21,393,1237,66,716,1424,28,797,1292,434,738,1682,553,1134,332,521,1348,265,333,711,349,766,1768,1415,1260,11,857,1419,1423,9,585,858,1422,1501,1677,10,715,792,1418,1420,1421,739,163,407,439,25,34,455,31,36,378,1678,1132,3,24,39,657,542,674,1205,1460,1008,1141,1721,520,837,1067,1607,385,1569,1302,1402,1742,1773,386,966,1852,113,882,1168,35,160,1012,1372,850,1233,1454,1574,1822,573,626,1135,1455,1505,1811,37,98,338,768,1319,1602,1676,610,30,63,285,1021,451,1373,352,1284,986,1413,38,817,1259,1733,547,1282,1411,148,1398,1410,108,111,314,503,1193,1722,1782,43,375,406,1088,286,1308,1437,748,1108,1711,198,340,508,526,627,1320,1323,1579,116,970,1063,1808,1145,1738,124,327,485,854,883,1325,1586,390,582,1571,348,590,1149,394,1028,1208,1266,119,335,1492,1552,1321,1724,480,616,944,1068,1412,1575,223,791,1587,1672,1810,70,82,114,652,704,1157,75,658,1461,1809,4,147,545,1027,1801,351,441,462,678,1289,683,1853,69,162,325,884,988,78,201,403,405,601,722,1245,1318,1330,1408,105,401,958,1820,291,790,1188,1303,149,287,341,389,818,1073,1139,1486,123,262,580,651,776,1236,81,483,1037,1539,1772,1159,1326,1327,1367,1526,1704,1771,423,673,1013,1151,1172,1463,1540,266,796,1019,1043,1757,290,1040,1554,1555,45,574,639,968,1474,1573,1730,635,1035,1426,1743,84,751,775,795,1160,1223,1681,1715,852,1217,1338,1344,1740,324,717,1029,1283,1716,1758,972,1095,1143,1144,1163,1206,1226,1229,1343,1358,1409,1452,1453,1604,1663,665,709,905,1045,1048,1146,1150,151,212,417,643,1405,1483,1673,1807,1833,644,851,885,1136,1137,1152,1262,1293,1448,1449,1746,1042,1230,1231,1351,1647,1787,467,769,1026,1051,1109,1749,1791,150,453,1025,1090,1140,1154,1340,1458,1723,1759,1806,208,448,663,707,954,973,1224,1366,1368,1459,1519,1609,1632,1649,1750,1751,1816,559,701,740,920,996,1044,1049,1050,1052,1148,1196,1274,1329,1354,1360,1361,1362,1601,1708,1713,1805,666,914,921,923,927,1055,1071,1072,1294,1322,1339,1580,1714,1788,1823,14,886,915,916,926,930,931,1047,1599,1854,205,703,784,924,1039,1350,1352,1389,1596,1650,93,253,299,300,422,1004,1020,1036,1054,1225,1451,1664,479,888,937,965,1626,1674,27,487,672,999,1256') 0.073133945465088
(642) DESCRIBE `cruisetypes` 0.002547025680542
(643) DESCRIBE `destinations` 0.0036919116973877
(644) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '43', '25', '37', '9', '2', '8', '44', '55', '53', '39', '40', '26', '38', '28', '30', '7', '49', '11', '45', '48', '21', '29', '52', '34', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,43,25,37,9,2,8,44,55,53,39,40,26,38,28,30,7,49,11,45,48,21,29,52,34,10,46,56,32') 0.0031261444091797