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

Total elapsed time: 0.72881579399109

# Query Time
(1) connect 0.001533031463623
(2) DESCRIBE `cruises` 0.0049500465393066
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (81042, 84801, 8256, 13508, 39342, 45259, 47265, 59157, 59344, 69411)) ORDER BY FIND_IN_SET(id, '81042,84801,8256,13508,39342,45259,47265,59157,59344,69411') 0.0041627883911133
(4) DESCRIBE `cruises` 0.0051538944244385
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81042') 0.00060796737670898
(6) DESCRIBE `ships` 0.0050761699676514
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1773))) 0.00077509880065918
(8) DESCRIBE `ships` 0.005122184753418
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1773') 0.00064897537231445
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00047898292541504
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00047612190246582
(12) DESCRIBE `itineraries` 0.0026199817657471
(13) DESCRIBE `ports` 0.002863883972168
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00060606002807617
(15) DESCRIBE `ports` 0.0025949478149414
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00057387351989746
(17) DESCRIBE `ports` 0.0026102066040039
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00053095817565918
(19) DESCRIBE `sailingdates` 0.0023190975189209
(20) DESCRIBE `ports` 0.003061056137085
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00068402290344238
(22) DESCRIBE `ports` 0.0042788982391357
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00062179565429688
(24) DESCRIBE `ports` 0.003136157989502
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00066995620727539
(26) DESCRIBE `ports` 0.0038509368896484
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00058317184448242
(28) DESCRIBE `ports` 0.0026481151580811
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00058603286743164
(30) DESCRIBE `ports` 0.0028738975524902
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00060510635375977
(32) DESCRIBE `ports` 0.0023109912872314
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00064396858215332
(34) DESCRIBE `ports` 0.0090291500091553
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0010931491851807
(36) DESCRIBE `avid_specials` 0.0029220581054688
(37) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81042 and class = 'Cruise') OR (item_id = 1773 AND class = 'Ship') OR (item_id = 218 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.0022540092468262
(38) DESCRIBE `cruiselines` 0.0038981437683105
(39) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00074195861816406
(40) DESCRIBE `orchid_image` 0.003593921661377
(41) DESCRIBE `cruiselines` 0.004755973815918
(42) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.0006401538848877
(43) DESCRIBE `cruises` 0.0052731037139893
(44) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '84801') 0.00044894218444824
(45) DESCRIBE `ships` 0.0038700103759766
(46) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 116))) 0.00054407119750977
(47) DESCRIBE `ships` 0.004551887512207
(48) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '116') 0.00082802772521973
(49) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0004889965057373
(50) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00047802925109863
(51) DESCRIBE `itineraries` 0.002626895904541
(52) DESCRIBE `ports` 0.0039238929748535
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00061893463134766
(54) DESCRIBE `ports` 0.0023059844970703
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00044894218444824
(56) DESCRIBE `ports` 0.0020890235900879
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00052404403686523
(58) DESCRIBE `sailingdates` 0.0023548603057861
(59) DESCRIBE `ports` 0.002655029296875
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00065422058105469
(61) DESCRIBE `ports` 0.0027430057525635
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00064802169799805
(63) DESCRIBE `ports` 0.0018908977508545
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00045013427734375
(65) DESCRIBE `ports` 0.0023500919342041
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00052714347839355
(67) DESCRIBE `ports` 0.0017490386962891
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00039815902709961
(69) DESCRIBE `ports` 0.0022680759429932
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00037407875061035
(71) DESCRIBE `ports` 0.0021610260009766
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00054311752319336
(73) DESCRIBE `ports` 0.0027499198913574
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00058293342590332
(75) DESCRIBE `avid_specials` 0.002284049987793
(76) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 84801 and class = 'Cruise') OR (item_id = 116 AND class = 'Ship') OR (item_id = 26 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.0017929077148438
(77) DESCRIBE `cruiselines` 0.0031981468200684
(78) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00045013427734375
(79) DESCRIBE `orchid_image` 0.0020370483398438
(80) DESCRIBE `cruiselines` 0.0025990009307861
(81) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00051498413085938
(82) DESCRIBE `cruises` 0.0048789978027344
(83) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '8256') 0.0005650520324707
(84) DESCRIBE `ships` 0.0037930011749268
(85) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 207))) 0.00053501129150391
(86) DESCRIBE `ships` 0.0055170059204102
(87) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '207') 0.0005490779876709
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00041604042053223
(89) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00041294097900391
(90) DESCRIBE `itineraries` 0.0019998550415039
(91) DESCRIBE `ports` 0.0018649101257324
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00044393539428711
(93) DESCRIBE `ports` 0.0018088817596436
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00051999092102051
(95) DESCRIBE `ports` 0.0018219947814941
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.0003809928894043
(97) DESCRIBE `sailingdates` 0.001823902130127
(98) DESCRIBE `ports` 0.0021810531616211
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.0005338191986084
(100) DESCRIBE `ports` 0.0017960071563721
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00037884712219238
(102) DESCRIBE `ports` 0.0020651817321777
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 263))) 0.0004889965057373
(104) DESCRIBE `ports` 0.0020270347595215
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '263') 0.000701904296875
(106) DESCRIBE `ports` 0.0026788711547852
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 265))) 0.00052094459533691
(108) DESCRIBE `ports` 0.0017659664154053
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '265') 0.00037503242492676
(110) DESCRIBE `ports` 0.0019800662994385
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 266))) 0.00040388107299805
(112) DESCRIBE `ports` 0.0019271373748779
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '266') 0.00039291381835938
(114) DESCRIBE `ports` 0.0017609596252441
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00042390823364258
(116) DESCRIBE `ports` 0.0017499923706055
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00037097930908203
(118) DESCRIBE `avid_specials` 0.0018329620361328
(119) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 8256 and class = 'Cruise') OR (item_id = 207 AND class = 'Ship') OR (item_id = 36 AND class = 'CruiseLine') OR (item_id = 8 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.0011210441589355
(120) DESCRIBE `cruiselines` 0.0025420188903809
(121) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 36))) 0.00045585632324219
(122) DESCRIBE `orchid_image` 0.0023860931396484
(123) DESCRIBE `cruiselines` 0.002856969833374
(124) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '36') 0.0004270076751709
(125) DESCRIBE `cruises` 0.0036609172821045
(126) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '13508') 0.00063705444335938
(127) DESCRIBE `ships` 0.004925012588501
(128) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 14))) 0.00070905685424805
(129) DESCRIBE `ships` 0.0037269592285156
(130) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '14') 0.00040411949157715
(131) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034713745117188
(132) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035786628723145
(133) DESCRIBE `itineraries` 0.0017271041870117
(134) DESCRIBE `ports` 0.0018999576568604
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00042200088500977
(136) DESCRIBE `ports` 0.0017690658569336
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00040483474731445
(138) DESCRIBE `ports` 0.0018100738525391
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00048995018005371
(140) DESCRIBE `sailingdates` 0.0015449523925781
(141) DESCRIBE `ports` 0.0023519992828369
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00042486190795898
(143) DESCRIBE `ports` 0.0018179416656494
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00048685073852539
(145) DESCRIBE `ports` 0.0017540454864502
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00044703483581543
(147) DESCRIBE `ports` 0.0020809173583984
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00039196014404297
(149) DESCRIBE `ports` 0.0017719268798828
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00039386749267578
(151) DESCRIBE `ports` 0.0019669532775879
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00045990943908691
(153) DESCRIBE `ports` 0.0020358562469482
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1161))) 0.00043010711669922
(155) DESCRIBE `ports` 0.00211501121521
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1161') 0.0003969669342041
(157) DESCRIBE `ports` 0.0025308132171631
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.0005638599395752
(159) DESCRIBE `ports` 0.0020761489868164
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00044798851013184
(161) DESCRIBE `ports` 0.0019018650054932
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00044894218444824
(163) DESCRIBE `ports` 0.0019991397857666
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00045108795166016
(165) DESCRIBE `ports` 0.0022900104522705
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00043392181396484
(167) DESCRIBE `ports` 0.0018899440765381
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00043296813964844
(169) DESCRIBE `ports` 0.0019159317016602
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3052))) 0.00041890144348145
(171) DESCRIBE `ports` 0.0020911693572998
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3052') 0.00044798851013184
(173) DESCRIBE `ports` 0.0022408962249756
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00059390068054199
(175) DESCRIBE `ports` 0.0023889541625977
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00043916702270508
(177) DESCRIBE `ports` 0.0022249221801758
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00056600570678711
(179) DESCRIBE `ports` 0.0022561550140381
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00064492225646973
(181) DESCRIBE `avid_specials` 0.0016939640045166
(182) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 13508 and class = 'Cruise') OR (item_id = 14 AND class = 'Ship') OR (item_id = 35 AND class = 'CruiseLine') OR (item_id = 46 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.0011978149414062
(183) DESCRIBE `cruiselines` 0.0026359558105469
(184) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 35))) 0.00046992301940918
(185) DESCRIBE `orchid_image` 0.0020570755004883
(186) DESCRIBE `cruiselines` 0.0029110908508301
(187) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '35') 0.00041794776916504
(188) DESCRIBE `cruises` 0.0036139488220215
(189) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '39342') 0.00047206878662109
(190) DESCRIBE `ships` 0.0042281150817871
(191) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 27))) 0.00078392028808594
(192) DESCRIBE `ships` 0.0038580894470215
(193) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '27') 0.00048494338989258
(194) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036501884460449
(195) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00039100646972656
(196) DESCRIBE `itineraries` 0.0019969940185547
(197) DESCRIBE `ports` 0.001986026763916
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00044894218444824
(199) DESCRIBE `ports` 0.0019140243530273
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00041389465332031
(201) DESCRIBE `ports` 0.0019998550415039
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0004119873046875
(203) DESCRIBE `sailingdates` 0.0016071796417236
(204) DESCRIBE `ports` 0.0021111965179443
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00044107437133789
(206) DESCRIBE `ports` 0.0019111633300781
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00045013427734375
(208) DESCRIBE `ports` 0.0018939971923828
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00047898292541504
(210) DESCRIBE `ports` 0.0019080638885498
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.0003809928894043
(212) DESCRIBE `ports` 0.0019278526306152
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00039815902709961
(214) DESCRIBE `ports` 0.0019321441650391
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00041103363037109
(216) DESCRIBE `ports` 0.0017530918121338
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00054001808166504
(218) DESCRIBE `ports` 0.0018839836120605
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00040507316589355
(220) DESCRIBE `avid_specials` 0.0016648769378662
(221) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 39342 and class = 'Cruise') OR (item_id = 27 AND class = 'Ship') OR (item_id = 218 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.0011801719665527
(222) DESCRIBE `cruiselines` 0.0025479793548584
(223) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00042104721069336
(224) DESCRIBE `orchid_image` 0.0024890899658203
(225) DESCRIBE `cruiselines` 0.0032248497009277
(226) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00048303604125977
(227) DESCRIBE `cruises` 0.0038449764251709
(228) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45259') 0.00065398216247559
(229) DESCRIBE `ships` 0.0044348239898682
(230) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00071978569030762
(231) DESCRIBE `ships` 0.0041379928588867
(232) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00050997734069824
(233) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00042605400085449
(234) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00037288665771484
(235) DESCRIBE `itineraries` 0.0020139217376709
(236) DESCRIBE `ports` 0.0020520687103271
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00049114227294922
(238) DESCRIBE `ports` 0.0019290447235107
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00040602684020996
(240) DESCRIBE `ports` 0.0018360614776611
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00042009353637695
(242) DESCRIBE `sailingdates` 0.0017530918121338
(243) DESCRIBE `ports` 0.0022318363189697
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00051093101501465
(245) DESCRIBE `ports` 0.0022211074829102
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00053691864013672
(247) DESCRIBE `ports` 0.0019979476928711
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.0004580020904541
(249) DESCRIBE `ports` 0.0019729137420654
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00046014785766602
(251) DESCRIBE `ports` 0.001945972442627
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00060009956359863
(253) DESCRIBE `ports` 0.0021910667419434
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00038695335388184
(255) DESCRIBE `ports` 0.0017540454864502
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00039315223693848
(257) DESCRIBE `ports` 0.0018281936645508
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00046181678771973
(259) DESCRIBE `ports` 0.0021810531616211
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00044417381286621
(261) DESCRIBE `ports` 0.0019829273223877
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.0003809928894043
(263) DESCRIBE `ports` 0.0021309852600098
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00040793418884277
(265) DESCRIBE `ports` 0.0017409324645996
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00040817260742188
(267) DESCRIBE `avid_specials` 0.0015449523925781
(268) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 45259 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 AND class = 'CruiseLine') OR (item_id = 43 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.0011129379272461
(269) DESCRIBE `cruiselines` 0.0025830268859863
(270) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.0004420280456543
(271) DESCRIBE `orchid_image` 0.0020568370819092
(272) DESCRIBE `cruiselines` 0.0026049613952637
(273) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00046205520629883
(274) DESCRIBE `cruises` 0.0038011074066162
(275) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '47265') 0.00052213668823242
(276) DESCRIBE `ships` 0.0038580894470215
(277) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 22))) 0.00084614753723145
(278) DESCRIBE `ships` 0.0039129257202148
(279) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '22') 0.00050902366638184
(280) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034999847412109
(281) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034284591674805
(282) DESCRIBE `itineraries` 0.0020959377288818
(283) DESCRIBE `ports` 0.00193190574646
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00054502487182617
(285) DESCRIBE `ports` 0.0023288726806641
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00054192543029785
(287) DESCRIBE `ports` 0.002112865447998
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00040698051452637
(289) DESCRIBE `sailingdates` 0.0017430782318115
(290) DESCRIBE `ports` 0.0023348331451416
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00072598457336426
(292) DESCRIBE `ports` 0.0023820400238037
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00044822692871094
(294) DESCRIBE `ports` 0.0019290447235107
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2129))) 0.00051188468933105
(296) DESCRIBE `ports` 0.0021398067474365
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2129') 0.00045084953308105
(298) DESCRIBE `ports` 0.0019328594207764
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 331))) 0.00064492225646973
(300) DESCRIBE `ports` 0.0021688938140869
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '331') 0.00038599967956543
(302) DESCRIBE `ports` 0.0017600059509277
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00044083595275879
(304) DESCRIBE `ports` 0.0018160343170166
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00037789344787598
(306) DESCRIBE `avid_specials` 0.0016880035400391
(307) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 47265 and class = 'Cruise') OR (item_id = 22 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 53 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.0012390613555908
(308) DESCRIBE `cruiselines` 0.0025990009307861
(309) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00043487548828125
(310) DESCRIBE `orchid_image` 0.0043110847473145
(311) DESCRIBE `cruiselines` 0.0027151107788086
(312) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00069212913513184
(313) DESCRIBE `cruises` 0.0049540996551514
(314) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59157') 0.00056004524230957
(315) DESCRIBE `ships` 0.0049009323120117
(316) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 730))) 0.00069904327392578
(317) DESCRIBE `ships` 0.0048010349273682
(318) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '730') 0.00048494338989258
(319) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00057387351989746
(320) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034904479980469
(321) DESCRIBE `itineraries` 0.002032995223999
(322) DESCRIBE `sailingdates` 0.0016729831695557
(323) DESCRIBE `itineraries` 0.0019371509552002
(324) DESCRIBE `itineraries` 0.0017740726470947
(325) DESCRIBE `avid_specials` 0.0016248226165771
(326) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59157 and class = 'Cruise') OR (item_id = 730 AND class = 'Ship') OR (item_id = 172 AND class = 'CruiseLine') OR (item_id = 44 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.0011839866638184
(327) DESCRIBE `cruiselines` 0.0026321411132812
(328) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 172))) 0.00045609474182129
(329) DESCRIBE `orchid_image` 0.0020718574523926
(330) DESCRIBE `cruiselines` 0.0027470588684082
(331) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '172') 0.00037002563476562
(332) DESCRIBE `cruises` 0.0035610198974609
(333) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59344') 0.0003960132598877
(334) DESCRIBE `ships` 0.0039770603179932
(335) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1417))) 0.0008399486541748
(336) DESCRIBE `ships` 0.0039408206939697
(337) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1417') 0.00050210952758789
(338) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00038790702819824
(339) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00044488906860352
(340) DESCRIBE `itineraries` 0.0018990039825439
(341) DESCRIBE `sailingdates` 0.0022859573364258
(342) DESCRIBE `itineraries` 0.0023500919342041
(343) DESCRIBE `itineraries` 0.0018889904022217
(344) DESCRIBE `avid_specials` 0.0018799304962158
(345) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59344 and class = 'Cruise') OR (item_id = 1417 AND class = 'Ship') OR (item_id = 170 AND class = 'CruiseLine') OR (item_id = 44 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.0014381408691406
(346) DESCRIBE `cruiselines` 0.003032922744751
(347) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 170))) 0.00047492980957031
(348) DESCRIBE `orchid_image` 0.002173900604248
(349) DESCRIBE `cruiselines` 0.0027580261230469
(350) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '170') 0.00048398971557617
(351) DESCRIBE `cruises` 0.0043289661407471
(352) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69411') 0.0004880428314209
(353) DESCRIBE `ships` 0.0045127868652344
(354) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 113))) 0.00076603889465332
(355) DESCRIBE `ships` 0.0045831203460693
(356) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '113') 0.00059008598327637
(357) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037288665771484
(358) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036191940307617
(359) DESCRIBE `itineraries` 0.0020837783813477
(360) DESCRIBE `ports` 0.0021889209747314
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00047612190246582
(362) DESCRIBE `ports` 0.0026819705963135
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00050091743469238
(364) DESCRIBE `ports` 0.0027511119842529
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00042986869812012
(366) DESCRIBE `sailingdates` 0.0025207996368408
(367) DESCRIBE `ports` 0.0024440288543701
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00049686431884766
(369) DESCRIBE `ports` 0.0021970272064209
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00059318542480469
(371) DESCRIBE `ports` 0.0019710063934326
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00043892860412598
(373) DESCRIBE `ports` 0.0019149780273438
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00041103363037109
(375) DESCRIBE `ports` 0.0020561218261719
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1246))) 0.00045394897460938
(377) DESCRIBE `ports` 0.0020229816436768
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1246') 0.00043296813964844
(379) DESCRIBE `avid_specials` 0.0021719932556152
(380) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69411 and class = 'Cruise') OR (item_id = 113 AND class = 'Ship') OR (item_id = 26 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.0024969577789307
(381) DESCRIBE `cruiselines` 0.0047450065612793
(382) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00073504447937012
(383) DESCRIBE `orchid_image` 0.0034379959106445
(384) DESCRIBE `cruiselines` 0.0038008689880371
(385) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00075697898864746
(386) DESCRIBE `cruiselines` 0.0032579898834229
(387) 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.0071229934692383
(388) DESCRIBE `ships` 0.004188060760498
(389) 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.071805000305176
(390) DESCRIBE `cruisetypes` 0.002669095993042
(391) DESCRIBE `destinations` 0.0033628940582275
(392) 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.0035209655761719