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

Total elapsed time: 0.79847550392151

# Query Time
(1) connect 0.0016059875488281
(2) DESCRIBE `cruises` 0.0046548843383789
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (53527, 49426, 73853, 53530, 81081, 81082, 81083, 81084, 81139, 84410)) ORDER BY FIND_IN_SET(id, '53527,49426,73853,53530,81081,81082,81083,81084,81139,84410') 0.00337815284729
(4) DESCRIBE `cruises` 0.0037431716918945
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '53527') 0.0004119873046875
(6) DESCRIBE `ships` 0.0036299228668213
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 43))) 0.00048208236694336
(8) DESCRIBE `ships` 0.0039370059967041
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '43') 0.00044393539428711
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035214424133301
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034213066101074
(12) DESCRIBE `itineraries` 0.0017659664154053
(13) DESCRIBE `ports` 0.0019931793212891
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00055694580078125
(15) DESCRIBE `ports` 0.0018799304962158
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00038909912109375
(17) DESCRIBE `ports` 0.0017740726470947
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00037193298339844
(19) DESCRIBE `sailingdates` 0.0022850036621094
(20) DESCRIBE `ports` 0.00205397605896
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00046801567077637
(22) DESCRIBE `ports` 0.0019659996032715
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00043106079101562
(24) DESCRIBE `ports` 0.0032060146331787
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00040507316589355
(26) DESCRIBE `ports` 0.0020298957824707
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00036406517028809
(28) DESCRIBE `ports` 0.0017178058624268
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.0003819465637207
(30) DESCRIBE `ports` 0.0017910003662109
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00037217140197754
(32) DESCRIBE `ports` 0.0018529891967773
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00038385391235352
(34) DESCRIBE `ports` 0.0018579959869385
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0003659725189209
(36) DESCRIBE `avid_specials` 0.0016021728515625
(37) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 53527 and class = 'Cruise') OR (item_id = 43 AND class = 'Ship') OR (item_id = 8 AND class = 'CruiseLine') OR (item_id = 9 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.0012311935424805
(38) DESCRIBE `cruiselines` 0.0026471614837646
(39) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.0004119873046875
(40) DESCRIBE `orchid_image` 0.0020411014556885
(41) DESCRIBE `cruiselines` 0.0029511451721191
(42) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00035619735717773
(43) DESCRIBE `cruises` 0.0033209323883057
(44) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '49426') 0.00038480758666992
(45) DESCRIBE `ships` 0.0040359497070312
(46) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 43))) 0.00044989585876465
(47) DESCRIBE `ships` 0.0042040348052979
(48) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '43') 0.0003809928894043
(49) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035309791564941
(50) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034689903259277
(51) DESCRIBE `itineraries` 0.0027999877929688
(52) DESCRIBE `ports` 0.0028848648071289
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00061607360839844
(54) DESCRIBE `ports` 0.0025360584259033
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00063705444335938
(56) DESCRIBE `ports` 0.0024800300598145
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00068902969360352
(58) DESCRIBE `sailingdates` 0.0021488666534424
(59) DESCRIBE `ports` 0.0029280185699463
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00058698654174805
(61) DESCRIBE `ports` 0.0028049945831299
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00060606002807617
(63) DESCRIBE `ports` 0.0029292106628418
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00050592422485352
(65) DESCRIBE `ports` 0.003058910369873
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00047111511230469
(67) DESCRIBE `ports` 0.0023288726806641
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.0005791187286377
(69) DESCRIBE `ports` 0.0019760131835938
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00040602684020996
(71) DESCRIBE `ports` 0.0019650459289551
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00041508674621582
(73) DESCRIBE `ports` 0.0025908946990967
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0004429817199707
(75) DESCRIBE `avid_specials` 0.0018041133880615
(76) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 49426 and class = 'Cruise') OR (item_id = 43 AND class = 'Ship') OR (item_id = 8 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.0011239051818848
(77) DESCRIBE `cruiselines` 0.0041890144348145
(78) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00069904327392578
(79) DESCRIBE `orchid_image` 0.0030300617218018
(80) DESCRIBE `cruiselines` 0.0027930736541748
(81) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00047397613525391
(82) DESCRIBE `cruises` 0.0036520957946777
(83) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73853') 0.00048589706420898
(84) DESCRIBE `ships` 0.0048618316650391
(85) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 43))) 0.0004889965057373
(86) DESCRIBE `ships` 0.0036568641662598
(87) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '43') 0.00039505958557129
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00046515464782715
(89) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003662109375
(90) DESCRIBE `itineraries` 0.0019779205322266
(91) DESCRIBE `ports` 0.0021169185638428
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00048589706420898
(93) DESCRIBE `ports` 0.0027701854705811
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00065302848815918
(95) DESCRIBE `ports` 0.0027370452880859
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00042581558227539
(97) DESCRIBE `sailingdates` 0.002007007598877
(98) DESCRIBE `ports` 0.00211501121521
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00054001808166504
(100) DESCRIBE `ports` 0.0019040107727051
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00056195259094238
(102) DESCRIBE `ports` 0.0024540424346924
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00050520896911621
(104) DESCRIBE `ports` 0.0025990009307861
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00074315071105957
(106) DESCRIBE `ports` 0.0030221939086914
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00048017501831055
(108) DESCRIBE `ports` 0.0020630359649658
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00050187110900879
(110) DESCRIBE `ports` 0.002371072769165
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00051498413085938
(112) DESCRIBE `ports` 0.0030050277709961
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0005490779876709
(114) DESCRIBE `avid_specials` 0.0020608901977539
(115) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73853 and class = 'Cruise') OR (item_id = 43 AND class = 'Ship') OR (item_id = 8 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.0020170211791992
(116) DESCRIBE `cruiselines` 0.0038471221923828
(117) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.0011961460113525
(118) DESCRIBE `orchid_image` 0.0030388832092285
(119) DESCRIBE `cruiselines` 0.003303050994873
(120) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.0004889965057373
(121) DESCRIBE `cruises` 0.0043220520019531
(122) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '53530') 0.00065016746520996
(123) DESCRIBE `ships` 0.0051121711730957
(124) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 43))) 0.00066995620727539
(125) DESCRIBE `ships` 0.0059661865234375
(126) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '43') 0.00066995620727539
(127) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00062394142150879
(128) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00046515464782715
(129) DESCRIBE `itineraries` 0.0034549236297607
(130) DESCRIBE `ports` 0.0020630359649658
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00047111511230469
(132) DESCRIBE `ports` 0.0018320083618164
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00044989585876465
(134) DESCRIBE `ports` 0.0020639896392822
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0004580020904541
(136) DESCRIBE `sailingdates` 0.002161979675293
(137) DESCRIBE `ports` 0.0024988651275635
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00051403045654297
(139) DESCRIBE `ports` 0.0025010108947754
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00046992301940918
(141) DESCRIBE `ports` 0.0024809837341309
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00040793418884277
(143) DESCRIBE `ports` 0.0023829936981201
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00038003921508789
(145) DESCRIBE `ports` 0.002485990524292
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00044918060302734
(147) DESCRIBE `ports` 0.0022587776184082
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00046014785766602
(149) DESCRIBE `avid_specials` 0.0025529861450195
(150) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 53530 and class = 'Cruise') OR (item_id = 43 AND class = 'Ship') OR (item_id = 8 AND class = 'CruiseLine') OR (item_id = 9 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.0013129711151123
(151) DESCRIBE `cruiselines` 0.0028398036956787
(152) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00043892860412598
(153) DESCRIBE `orchid_image` 0.0024521350860596
(154) DESCRIBE `cruiselines` 0.0026769638061523
(155) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00040602684020996
(156) DESCRIBE `cruises` 0.0036070346832275
(157) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81081') 0.00046205520629883
(158) DESCRIBE `ships` 0.0041208267211914
(159) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 43))) 0.00047993659973145
(160) DESCRIBE `ships` 0.0047149658203125
(161) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '43') 0.00051188468933105
(162) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00044107437133789
(163) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035905838012695
(164) DESCRIBE `itineraries` 0.0020270347595215
(165) DESCRIBE `ports` 0.0020039081573486
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00043082237243652
(167) DESCRIBE `ports` 0.0019848346710205
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00054097175598145
(169) DESCRIBE `ports` 0.0019528865814209
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00044083595275879
(171) DESCRIBE `sailingdates` 0.0016660690307617
(172) DESCRIBE `ports` 0.0023849010467529
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00043797492980957
(174) DESCRIBE `ports` 0.002108097076416
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00045299530029297
(176) DESCRIBE `ports` 0.0021309852600098
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00042414665222168
(178) DESCRIBE `ports` 0.0018670558929443
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00038886070251465
(180) DESCRIBE `ports` 0.0019111633300781
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00040793418884277
(182) DESCRIBE `ports` 0.0024960041046143
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00038504600524902
(184) DESCRIBE `ports` 0.0024659633636475
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00043106079101562
(186) DESCRIBE `ports` 0.0027310848236084
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00042510032653809
(188) DESCRIBE `avid_specials` 0.002593994140625
(189) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81081 and class = 'Cruise') OR (item_id = 43 AND class = 'Ship') OR (item_id = 8 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.0014839172363281
(190) DESCRIBE `cruiselines` 0.0037050247192383
(191) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00051188468933105
(192) DESCRIBE `orchid_image` 0.0026531219482422
(193) DESCRIBE `cruiselines` 0.003115177154541
(194) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00047588348388672
(195) DESCRIBE `cruises` 0.0045499801635742
(196) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81082') 0.00047802925109863
(197) DESCRIBE `ships` 0.0048348903656006
(198) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 43))) 0.00052881240844727
(199) DESCRIBE `ships` 0.0037801265716553
(200) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '43') 0.00048518180847168
(201) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036787986755371
(202) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036096572875977
(203) DESCRIBE `itineraries` 0.0025861263275146
(204) DESCRIBE `ports` 0.002094030380249
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00048995018005371
(206) DESCRIBE `ports` 0.0019550323486328
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046515464782715
(208) DESCRIBE `ports` 0.0019590854644775
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00044488906860352
(210) DESCRIBE `sailingdates` 0.0019271373748779
(211) DESCRIBE `ports` 0.0020289421081543
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00045990943908691
(213) DESCRIBE `ports` 0.0020580291748047
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00042104721069336
(215) DESCRIBE `ports` 0.0019609928131104
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1135))) 0.00043797492980957
(217) DESCRIBE `ports` 0.0018370151519775
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1135') 0.00045895576477051
(219) DESCRIBE `ports` 0.0019848346710205
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 600))) 0.00042200088500977
(221) DESCRIBE `ports` 0.0022819042205811
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '600') 0.00045299530029297
(223) DESCRIBE `ports` 0.0019519329071045
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00045299530029297
(225) DESCRIBE `ports` 0.0023880004882812
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00039291381835938
(227) DESCRIBE `ports` 0.0018930435180664
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 532))) 0.00050687789916992
(229) DESCRIBE `ports` 0.0018858909606934
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '532') 0.00041413307189941
(231) DESCRIBE `ports` 0.002000093460083
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00043511390686035
(233) DESCRIBE `ports` 0.0020818710327148
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00043487548828125
(235) DESCRIBE `avid_specials` 0.0019161701202393
(236) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81082 and class = 'Cruise') OR (item_id = 43 AND class = 'Ship') OR (item_id = 8 AND class = 'CruiseLine') OR (item_id = 38 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.0011851787567139
(237) DESCRIBE `cruiselines` 0.0027279853820801
(238) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00044608116149902
(239) DESCRIBE `orchid_image` 0.0022480487823486
(240) DESCRIBE `cruiselines` 0.0026779174804688
(241) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00039315223693848
(242) DESCRIBE `cruises` 0.0037219524383545
(243) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81083') 0.0005948543548584
(244) DESCRIBE `ships` 0.00543212890625
(245) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 43))) 0.00064992904663086
(246) DESCRIBE `ships` 0.0046150684356689
(247) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '43') 0.00047087669372559
(248) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037097930908203
(249) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036382675170898
(250) DESCRIBE `itineraries` 0.0027029514312744
(251) DESCRIBE `ports` 0.002129077911377
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00045204162597656
(253) DESCRIBE `ports` 0.0023050308227539
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00041007995605469
(255) DESCRIBE `ports` 0.0028119087219238
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00045108795166016
(257) DESCRIBE `sailingdates` 0.002946138381958
(258) DESCRIBE `ports` 0.0020959377288818
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00042200088500977
(260) DESCRIBE `ports` 0.0018520355224609
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00040388107299805
(262) DESCRIBE `ports` 0.0023500919342041
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00044393539428711
(264) DESCRIBE `ports` 0.0023629665374756
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00038695335388184
(266) DESCRIBE `ports` 0.0020170211791992
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 532))) 0.00066089630126953
(268) DESCRIBE `ports` 0.0022189617156982
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '532') 0.00045204162597656
(270) DESCRIBE `ports` 0.0023229122161865
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00051283836364746
(272) DESCRIBE `ports` 0.0017988681793213
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00038814544677734
(274) DESCRIBE `ports` 0.0020809173583984
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00043892860412598
(276) DESCRIBE `ports` 0.0018861293792725
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00044918060302734
(278) DESCRIBE `ports` 0.0018439292907715
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1493))) 0.0004270076751709
(280) DESCRIBE `ports` 0.0021741390228271
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1493') 0.0003809928894043
(282) DESCRIBE `ports` 0.0019791126251221
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00043511390686035
(284) DESCRIBE `ports` 0.0021591186523438
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00038480758666992
(286) DESCRIBE `ports` 0.0020029544830322
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 583))) 0.00041484832763672
(288) DESCRIBE `ports` 0.0021378993988037
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '583') 0.00041007995605469
(290) DESCRIBE `ports` 0.0018579959869385
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2264))) 0.00040388107299805
(292) DESCRIBE `ports` 0.0018739700317383
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2264') 0.00038695335388184
(294) DESCRIBE `ports` 0.002094030380249
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00050497055053711
(296) DESCRIBE `ports` 0.0020890235900879
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00040602684020996
(298) DESCRIBE `ports` 0.0021028518676758
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00047397613525391
(300) DESCRIBE `ports` 0.0028641223907471
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00045895576477051
(302) DESCRIBE `avid_specials` 0.0025618076324463
(303) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81083 and class = 'Cruise') OR (item_id = 43 AND class = 'Ship') OR (item_id = 8 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.001215934753418
(304) DESCRIBE `cruiselines` 0.0029680728912354
(305) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00046300888061523
(306) DESCRIBE `orchid_image` 0.0021381378173828
(307) DESCRIBE `cruiselines` 0.0034151077270508
(308) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00040197372436523
(309) DESCRIBE `cruises` 0.0036690235137939
(310) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81084') 0.00041794776916504
(311) DESCRIBE `ships` 0.0040838718414307
(312) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 43))) 0.0005500316619873
(313) DESCRIBE `ships` 0.0039060115814209
(314) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '43') 0.0004279613494873
(315) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003819465637207
(316) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00036001205444336
(317) DESCRIBE `itineraries` 0.0019209384918213
(318) DESCRIBE `ports` 0.0020821094512939
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00044083595275879
(320) DESCRIBE `ports` 0.0027949810028076
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00042605400085449
(322) DESCRIBE `ports` 0.0018339157104492
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00039482116699219
(324) DESCRIBE `sailingdates` 0.0018339157104492
(325) DESCRIBE `ports` 0.0027680397033691
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00043511390686035
(327) DESCRIBE `ports` 0.0018889904022217
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00045680999755859
(329) DESCRIBE `ports` 0.002202033996582
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00046610832214355
(331) DESCRIBE `ports` 0.0020778179168701
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00042390823364258
(333) DESCRIBE `ports` 0.0018570423126221
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00046896934509277
(335) DESCRIBE `ports` 0.0019359588623047
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00044703483581543
(337) DESCRIBE `ports` 0.0020689964294434
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00041985511779785
(339) DESCRIBE `ports` 0.0019838809967041
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.0003819465637207
(341) DESCRIBE `ports` 0.0019609928131104
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2264))) 0.00044107437133789
(343) DESCRIBE `ports` 0.0022451877593994
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2264') 0.00040197372436523
(345) DESCRIBE `ports` 0.0020210742950439
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00049996376037598
(347) DESCRIBE `ports` 0.0021171569824219
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00041699409484863
(349) DESCRIBE `ports` 0.0029990673065186
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00043320655822754
(351) DESCRIBE `ports` 0.0023770332336426
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00037503242492676
(353) DESCRIBE `ports` 0.0028109550476074
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00044989585876465
(355) DESCRIBE `ports` 0.0021541118621826
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00045990943908691
(357) DESCRIBE `ports` 0.0026929378509521
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 703))) 0.00049901008605957
(359) DESCRIBE `ports` 0.0023200511932373
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '703') 0.00046205520629883
(361) DESCRIBE `ports` 0.0024549961090088
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00057506561279297
(363) DESCRIBE `ports` 0.0026559829711914
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.0003969669342041
(365) DESCRIBE `ports` 0.0024919509887695
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00042200088500977
(367) DESCRIBE `ports` 0.0025458335876465
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00042605400085449
(369) DESCRIBE `avid_specials` 0.0022249221801758
(370) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81084 and class = 'Cruise') OR (item_id = 43 AND class = 'Ship') OR (item_id = 8 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.0022571086883545
(371) DESCRIBE `cruiselines` 0.0029258728027344
(372) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00047612190246582
(373) DESCRIBE `orchid_image` 0.0023801326751709
(374) DESCRIBE `cruiselines` 0.0031390190124512
(375) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00037097930908203
(376) DESCRIBE `cruises` 0.0040709972381592
(377) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '81139') 0.00039887428283691
(378) DESCRIBE `ships` 0.0054938793182373
(379) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 43))) 0.00066089630126953
(380) DESCRIBE `ships` 0.0057098865509033
(381) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '43') 0.0004279613494873
(382) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0006110668182373
(383) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00040102005004883
(384) DESCRIBE `itineraries` 0.0017929077148438
(385) DESCRIBE `ports` 0.0020890235900879
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00042319297790527
(387) DESCRIBE `ports` 0.0022768974304199
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00040507316589355
(389) DESCRIBE `ports` 0.002640962600708
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0003819465637207
(391) DESCRIBE `sailingdates` 0.0015621185302734
(392) DESCRIBE `ports` 0.0021350383758545
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00042200088500977
(394) DESCRIBE `ports` 0.0025739669799805
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00045108795166016
(396) DESCRIBE `ports` 0.0024518966674805
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00049114227294922
(398) DESCRIBE `ports` 0.0024728775024414
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00038599967956543
(400) DESCRIBE `ports` 0.0020179748535156
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00045108795166016
(402) DESCRIBE `ports` 0.0023760795593262
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.0004270076751709
(404) DESCRIBE `ports` 0.0027179718017578
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00057196617126465
(406) DESCRIBE `ports` 0.0026121139526367
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00042200088500977
(408) DESCRIBE `ports` 0.0027210712432861
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00049090385437012
(410) DESCRIBE `ports` 0.0026230812072754
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00041794776916504
(412) DESCRIBE `ports` 0.002601146697998
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00043010711669922
(414) DESCRIBE `ports` 0.0026330947875977
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00043296813964844
(416) DESCRIBE `ports` 0.0026021003723145
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00046992301940918
(418) DESCRIBE `ports` 0.0025970935821533
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00040888786315918
(420) DESCRIBE `ports` 0.002647876739502
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00048208236694336
(422) DESCRIBE `ports` 0.0026350021362305
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00050806999206543
(424) DESCRIBE `ports` 0.0032949447631836
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00047206878662109
(426) DESCRIBE `ports` 0.0031890869140625
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00042104721069336
(428) DESCRIBE `avid_specials` 0.0019190311431885
(429) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 81139 and class = 'Cruise') OR (item_id = 43 AND class = 'Ship') OR (item_id = 8 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.0011458396911621
(430) DESCRIBE `cruiselines` 0.0027780532836914
(431) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00063085556030273
(432) DESCRIBE `orchid_image` 0.0027120113372803
(433) DESCRIBE `cruiselines` 0.0034191608428955
(434) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00042891502380371
(435) DESCRIBE `cruises` 0.0043179988861084
(436) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '84410') 0.0004580020904541
(437) DESCRIBE `ships` 0.003882884979248
(438) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 43))) 0.00082588195800781
(439) DESCRIBE `ships` 0.0037229061126709
(440) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '43') 0.00058388710021973
(441) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00052213668823242
(442) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00049591064453125
(443) DESCRIBE `itineraries` 0.0028071403503418
(444) DESCRIBE `ports` 0.0030920505523682
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00056219100952148
(446) DESCRIBE `ports` 0.0023770332336426
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00050091743469238
(448) DESCRIBE `ports` 0.0020380020141602
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00041699409484863
(450) DESCRIBE `sailingdates` 0.0021018981933594
(451) DESCRIBE `ports` 0.0024459362030029
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00044107437133789
(453) DESCRIBE `ports` 0.0019280910491943
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00043606758117676
(455) DESCRIBE `ports` 0.0017879009246826
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3268))) 0.0004889965057373
(457) DESCRIBE `ports` 0.0019838809967041
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3268') 0.00040197372436523
(459) DESCRIBE `ports` 0.0019240379333496
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.0004570484161377
(461) DESCRIBE `ports` 0.0021588802337646
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00038313865661621
(463) DESCRIBE `ports` 0.0020210742950439
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00042009353637695
(465) DESCRIBE `ports` 0.0018229484558105
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00045204162597656
(467) DESCRIBE `ports` 0.0019669532775879
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00043797492980957
(469) DESCRIBE `ports` 0.0024328231811523
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00039196014404297
(471) DESCRIBE `ports` 0.0025398731231689
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00043797492980957
(473) DESCRIBE `ports` 0.0024828910827637
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00038003921508789
(475) DESCRIBE `ports` 0.002377986907959
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00046610832214355
(477) DESCRIBE `ports` 0.0019090175628662
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00037813186645508
(479) DESCRIBE `ports` 0.0019378662109375
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00050997734069824
(481) DESCRIBE `ports` 0.0022721290588379
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00044703483581543
(483) DESCRIBE `avid_specials` 0.0020689964294434
(484) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 84410 and class = 'Cruise') OR (item_id = 43 AND class = 'Ship') OR (item_id = 8 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.0012907981872559
(485) DESCRIBE `cruiselines` 0.0026469230651855
(486) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00050806999206543
(487) DESCRIBE `orchid_image` 0.0026569366455078
(488) DESCRIBE `cruiselines` 0.0042228698730469
(489) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00050806999206543
(490) DESCRIBE `cruisetypes` 0.0021970272064209
(491) DESCRIBE `destinations` 0.0034458637237549
(492) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('9', '12', '53', '22', '28', '38')) ORDER BY FIND_IN_SET(id, '9,12,53,22,28,38') 0.0014469623565674
(493) DESCRIBE `cruiselines` 0.0038270950317383
(494) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00063991546630859
(495) DESCRIBE `ships` 0.005180835723877
(496) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 43))) 0.00062704086303711
(497) DESCRIBE `cruiselines` 0.0037500858306885
(498) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00063490867614746
(499) DESCRIBE `ships` 0.0050339698791504
(500) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 43))) 0.00065994262695312