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

Total elapsed time: 0.68465256690979

# Query Time
(1) connect 0.0010559558868408
(2) DESCRIBE `cruises` 0.0054969787597656
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (41776, 65891, 50857, 41778, 50866, 63373, 55702, 75670, 70935, 70947)) ORDER BY FIND_IN_SET(id, '41776,65891,50857,41778,50866,63373,55702,75670,70935,70947') 0.0019340515136719
(4) DESCRIBE `cruises` 0.0050168037414551
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41776') 0.0004730224609375
(6) DESCRIBE `ships` 0.0048820972442627
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00078797340393066
(8) DESCRIBE `ships` 0.0059220790863037
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00047779083251953
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00038480758666992
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00039291381835938
(12) DESCRIBE `itineraries` 0.0024709701538086
(13) DESCRIBE `ports` 0.0021300315856934
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043606758117676
(15) DESCRIBE `ports` 0.0022430419921875
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041484832763672
(17) DESCRIBE `ports` 0.0017521381378174
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038814544677734
(19) DESCRIBE `sailingdates` 0.0018260478973389
(20) DESCRIBE `ports` 0.0026419162750244
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00062417984008789
(22) DESCRIBE `ports` 0.0018401145935059
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00051188468933105
(24) DESCRIBE `ports` 0.0020830631256104
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00042390823364258
(26) DESCRIBE `ports` 0.0017960071563721
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00037503242492676
(28) DESCRIBE `ports` 0.0018961429595947
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0005040168762207
(30) DESCRIBE `ports` 0.0024058818817139
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00055313110351562
(32) DESCRIBE `ports` 0.0027952194213867
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00058102607727051
(34) DESCRIBE `ports` 0.0026519298553467
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00052213668823242
(36) DESCRIBE `ports` 0.0026669502258301
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00060510635375977
(38) DESCRIBE `ports` 0.0026669502258301
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00058484077453613
(40) DESCRIBE `avid_specials` 0.0023360252380371
(41) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41776 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0021758079528809
(42) DESCRIBE `cruiselines` 0.0038700103759766
(43) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00067400932312012
(44) DESCRIBE `orchid_image` 0.0032269954681396
(45) DESCRIBE `cruiselines` 0.0037910938262939
(46) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00072002410888672
(47) DESCRIBE `cruises` 0.0050859451293945
(48) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65891') 0.00068116188049316
(49) DESCRIBE `ships` 0.0051958560943604
(50) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00070500373840332
(51) DESCRIBE `ships` 0.0054678916931152
(52) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00057792663574219
(53) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00051307678222656
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00051093101501465
(55) DESCRIBE `itineraries` 0.0025699138641357
(56) DESCRIBE `ports` 0.0026810169219971
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00061416625976562
(58) DESCRIBE `ports` 0.0027079582214355
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00057387351989746
(60) DESCRIBE `ports` 0.0026528835296631
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0005800724029541
(62) DESCRIBE `sailingdates` 0.0024559497833252
(63) DESCRIBE `ports` 0.0028848648071289
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00072813034057617
(65) DESCRIBE `ports` 0.0022780895233154
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00052809715270996
(67) DESCRIBE `ports` 0.002129077911377
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00048494338989258
(69) DESCRIBE `ports` 0.001939058303833
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0003969669342041
(71) DESCRIBE `ports` 0.0019931793212891
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.0004420280456543
(73) DESCRIBE `ports` 0.0019528865814209
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00039505958557129
(75) DESCRIBE `ports` 0.0017478466033936
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040507316589355
(77) DESCRIBE `ports` 0.0017340183258057
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037503242492676
(79) DESCRIBE `avid_specials` 0.0015790462493896
(80) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65891 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0011229515075684
(81) DESCRIBE `cruiselines` 0.0026540756225586
(82) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00043201446533203
(83) DESCRIBE `orchid_image` 0.0021498203277588
(84) DESCRIBE `cruiselines` 0.002514123916626
(85) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00038313865661621
(86) DESCRIBE `cruises` 0.0055210590362549
(87) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50857') 0.00064301490783691
(88) DESCRIBE `ships` 0.0055360794067383
(89) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00074601173400879
(90) DESCRIBE `ships` 0.0054759979248047
(91) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0006260871887207
(92) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00052809715270996
(93) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00052094459533691
(94) DESCRIBE `itineraries` 0.0027029514312744
(95) DESCRIBE `ports` 0.0027658939361572
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00060606002807617
(97) DESCRIBE `ports` 0.0026800632476807
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0006861686706543
(99) DESCRIBE `ports` 0.0026860237121582
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00056695938110352
(101) DESCRIBE `sailingdates` 0.00235915184021
(102) DESCRIBE `ports` 0.0027070045471191
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00061297416687012
(104) DESCRIBE `ports` 0.0027649402618408
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00057387351989746
(106) DESCRIBE `ports` 0.0027549266815186
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00063395500183105
(108) DESCRIBE `ports` 0.0027530193328857
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00057411193847656
(110) DESCRIBE `ports` 0.0027511119842529
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00065398216247559
(112) DESCRIBE `ports` 0.0026390552520752
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00069999694824219
(114) DESCRIBE `ports` 0.0027749538421631
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00060296058654785
(116) DESCRIBE `ports` 0.0028841495513916
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00061702728271484
(118) DESCRIBE `ports` 0.0029439926147461
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.0007021427154541
(120) DESCRIBE `ports` 0.0029468536376953
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00055694580078125
(122) DESCRIBE `ports` 0.0019280910491943
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041103363037109
(124) DESCRIBE `ports` 0.001816987991333
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039005279541016
(126) DESCRIBE `avid_specials` 0.0020179748535156
(127) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 50857 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0012781620025635
(128) DESCRIBE `cruiselines` 0.0027859210968018
(129) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00047087669372559
(130) DESCRIBE `orchid_image` 0.002331018447876
(131) DESCRIBE `cruiselines` 0.0029010772705078
(132) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00060486793518066
(133) DESCRIBE `cruises` 0.0036940574645996
(134) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41778') 0.0004432201385498
(135) DESCRIBE `ships` 0.0035190582275391
(136) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00048494338989258
(137) DESCRIBE `ships` 0.0036189556121826
(138) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00039196014404297
(139) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036215782165527
(140) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003509521484375
(141) DESCRIBE `itineraries` 0.0017619132995605
(142) DESCRIBE `ports` 0.0021121501922607
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00053095817565918
(144) DESCRIBE `ports` 0.001784086227417
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039482116699219
(146) DESCRIBE `ports` 0.0019419193267822
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039410591125488
(148) DESCRIBE `sailingdates` 0.0015928745269775
(149) DESCRIBE `ports` 0.0020949840545654
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041413307189941
(151) DESCRIBE `ports` 0.0018501281738281
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003819465637207
(153) DESCRIBE `ports` 0.0018019676208496
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003969669342041
(155) DESCRIBE `ports` 0.0018842220306396
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040197372436523
(157) DESCRIBE `avid_specials` 0.0015571117401123
(158) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41778 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.001162052154541
(159) DESCRIBE `cruiselines` 0.002532958984375
(160) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00040507316589355
(161) DESCRIBE `orchid_image` 0.0020101070404053
(162) DESCRIBE `cruiselines` 0.0025069713592529
(163) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00038003921508789
(164) DESCRIBE `cruises` 0.0042791366577148
(165) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50866') 0.00039982795715332
(166) DESCRIBE `ships` 0.0036530494689941
(167) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00045013427734375
(168) DESCRIBE `ships` 0.0034689903259277
(169) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00039505958557129
(170) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036001205444336
(171) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037789344787598
(172) DESCRIBE `itineraries` 0.0019099712371826
(173) DESCRIBE `ports` 0.0020630359649658
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041389465332031
(175) DESCRIBE `ports` 0.0022649765014648
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044822692871094
(177) DESCRIBE `ports` 0.0019550323486328
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039219856262207
(179) DESCRIBE `sailingdates` 0.001629114151001
(180) DESCRIBE `ports` 0.0018489360809326
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046586990356445
(182) DESCRIBE `ports` 0.0017681121826172
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044894218444824
(184) DESCRIBE `ports` 0.0019140243530273
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00038981437683105
(186) DESCRIBE `ports` 0.002025842666626
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00037121772766113
(188) DESCRIBE `ports` 0.0017979145050049
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00038504600524902
(190) DESCRIBE `ports` 0.0017640590667725
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00036811828613281
(192) DESCRIBE `ports` 0.0017459392547607
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00038504600524902
(194) DESCRIBE `ports` 0.0018138885498047
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00037288665771484
(196) DESCRIBE `ports` 0.0017139911651611
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048303604125977
(198) DESCRIBE `ports` 0.0018730163574219
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036811828613281
(200) DESCRIBE `avid_specials` 0.0018820762634277
(201) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 50866 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.00124192237854
(202) DESCRIBE `cruiselines` 0.0025069713592529
(203) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00040078163146973
(204) DESCRIBE `orchid_image` 0.0021440982818604
(205) DESCRIBE `cruiselines` 0.0025339126586914
(206) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00037002563476562
(207) DESCRIBE `cruises` 0.0033760070800781
(208) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63373') 0.00038480758666992
(209) DESCRIBE `ships` 0.003371000289917
(210) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00052905082702637
(211) DESCRIBE `ships` 0.0046288967132568
(212) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0006248950958252
(213) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00051021575927734
(214) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00041794776916504
(215) DESCRIBE `itineraries` 0.0018179416656494
(216) DESCRIBE `ports` 0.0020720958709717
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041389465332031
(218) DESCRIBE `ports` 0.001863956451416
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039005279541016
(220) DESCRIBE `ports` 0.00177001953125
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037384033203125
(222) DESCRIBE `sailingdates` 0.0016860961914062
(223) DESCRIBE `ports` 0.0018851757049561
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043392181396484
(225) DESCRIBE `ports` 0.0017499923706055
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041913986206055
(227) DESCRIBE `ports` 0.0019519329071045
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00039291381835938
(229) DESCRIBE `ports` 0.0024731159210205
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00044584274291992
(231) DESCRIBE `ports` 0.001884937286377
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00041890144348145
(233) DESCRIBE `ports` 0.0018680095672607
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00037002563476562
(235) DESCRIBE `ports` 0.0018050670623779
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00038909912109375
(237) DESCRIBE `ports` 0.0021119117736816
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00045895576477051
(239) DESCRIBE `ports` 0.0017321109771729
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00039291381835938
(241) DESCRIBE `ports` 0.0019118785858154
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00036811828613281
(243) DESCRIBE `ports` 0.0018129348754883
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00037288665771484
(245) DESCRIBE `ports` 0.001849889755249
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00035190582275391
(247) DESCRIBE `ports` 0.0018401145935059
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039505958557129
(249) DESCRIBE `ports` 0.0018470287322998
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038290023803711
(251) DESCRIBE `avid_specials` 0.0015630722045898
(252) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63373 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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
(253) DESCRIBE `cruiselines` 0.0026800632476807
(254) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00039219856262207
(255) DESCRIBE `orchid_image` 0.0024759769439697
(256) DESCRIBE `cruiselines` 0.0026638507843018
(257) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00041604042053223
(258) DESCRIBE `cruises` 0.0035829544067383
(259) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55702') 0.00047707557678223
(260) DESCRIBE `ships` 0.0035598278045654
(261) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00047588348388672
(262) DESCRIBE `ships` 0.0036959648132324
(263) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0003821849822998
(264) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035214424133301
(265) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034308433532715
(266) DESCRIBE `itineraries` 0.0017180442810059
(267) DESCRIBE `ports` 0.0020461082458496
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041007995605469
(269) DESCRIBE `ports` 0.0017919540405273
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042390823364258
(271) DESCRIBE `ports` 0.0018110275268555
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00046586990356445
(273) DESCRIBE `sailingdates` 0.0016160011291504
(274) DESCRIBE `ports` 0.0018329620361328
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044989585876465
(276) DESCRIBE `ports` 0.0018470287322998
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037312507629395
(278) DESCRIBE `ports` 0.001777172088623
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00051093101501465
(280) DESCRIBE `ports` 0.0017409324645996
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00036716461181641
(282) DESCRIBE `ports` 0.0019688606262207
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046396255493164
(284) DESCRIBE `ports` 0.0017721652984619
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043511390686035
(286) DESCRIBE `avid_specials` 0.0015830993652344
(287) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55702 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0014820098876953
(288) DESCRIBE `cruiselines` 0.0027229785919189
(289) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00041413307189941
(290) DESCRIBE `orchid_image` 0.0021631717681885
(291) DESCRIBE `cruiselines` 0.0028688907623291
(292) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00036311149597168
(293) DESCRIBE `cruises` 0.004626989364624
(294) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75670') 0.00047993659973145
(295) DESCRIBE `ships` 0.0049519538879395
(296) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.00069499015808105
(297) DESCRIBE `ships` 0.0037271976470947
(298) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1722') 0.00060486793518066
(299) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036001205444336
(300) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0004270076751709
(301) DESCRIBE `itineraries` 0.0018270015716553
(302) DESCRIBE `ports` 0.0018689632415771
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00043892860412598
(304) DESCRIBE `ports` 0.0019569396972656
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00060009956359863
(306) DESCRIBE `ports` 0.0018210411071777
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00049090385437012
(308) DESCRIBE `sailingdates` 0.0017669200897217
(309) DESCRIBE `ports` 0.002396821975708
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00062704086303711
(311) DESCRIBE `ports` 0.0022177696228027
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00041508674621582
(313) DESCRIBE `ports` 0.001924991607666
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00042414665222168
(315) DESCRIBE `ports` 0.001802921295166
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00036716461181641
(317) DESCRIBE `ports` 0.0018088817596436
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1037))) 0.00049304962158203
(319) DESCRIBE `ports` 0.00187087059021
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1037') 0.00039505958557129
(321) DESCRIBE `ports` 0.0019161701202393
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00042200088500977
(323) DESCRIBE `ports` 0.0019078254699707
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00040388107299805
(325) DESCRIBE `ports` 0.0017359256744385
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00049901008605957
(327) DESCRIBE `ports` 0.0017600059509277
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00040292739868164
(329) DESCRIBE `ports` 0.0020921230316162
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00055313110351562
(331) DESCRIBE `ports` 0.0022900104522705
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00048995018005371
(333) DESCRIBE `ports` 0.0024240016937256
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00052309036254883
(335) DESCRIBE `ports` 0.002363920211792
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00066018104553223
(337) DESCRIBE `avid_specials` 0.002187967300415
(338) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75670 and class = 'Cruise') OR (item_id = 1722 AND class = 'Ship') OR (item_id = 4 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.0013358592987061
(339) DESCRIBE `cruiselines` 0.0026061534881592
(340) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00042891502380371
(341) DESCRIBE `orchid_image` 0.0023939609527588
(342) DESCRIBE `cruiselines` 0.0031580924987793
(343) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00040602684020996
(344) DESCRIBE `cruises` 0.0035700798034668
(345) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70935') 0.00041699409484863
(346) DESCRIBE `ships` 0.0038220882415771
(347) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00053191184997559
(348) DESCRIBE `ships` 0.0035209655761719
(349) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00038313865661621
(350) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036406517028809
(351) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035214424133301
(352) DESCRIBE `itineraries` 0.0019059181213379
(353) DESCRIBE `ports` 0.0020551681518555
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00055694580078125
(355) DESCRIBE `ports` 0.0019721984863281
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045990943908691
(357) DESCRIBE `ports` 0.0017631053924561
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039291381835938
(359) DESCRIBE `sailingdates` 0.0017759799957275
(360) DESCRIBE `ports` 0.001906156539917
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043916702270508
(362) DESCRIBE `ports` 0.0017960071563721
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043201446533203
(364) DESCRIBE `ports` 0.0017690658569336
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00049185752868652
(366) DESCRIBE `ports` 0.0019838809967041
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00063514709472656
(368) DESCRIBE `ports` 0.0026559829711914
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00066399574279785
(370) DESCRIBE `ports` 0.0026588439941406
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00046205520629883
(372) DESCRIBE `ports` 0.0020852088928223
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00049400329589844
(374) DESCRIBE `ports` 0.00205397605896
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00048089027404785
(376) DESCRIBE `ports` 0.0020818710327148
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00048398971557617
(378) DESCRIBE `ports` 0.0020730495452881
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00044894218444824
(380) DESCRIBE `ports` 0.0021131038665771
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00050520896911621
(382) DESCRIBE `ports` 0.0021600723266602
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00043702125549316
(384) DESCRIBE `ports` 0.0021109580993652
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00051212310791016
(386) DESCRIBE `ports` 0.0021920204162598
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00047802925109863
(388) DESCRIBE `avid_specials` 0.0019791126251221
(389) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70935 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0017390251159668
(390) DESCRIBE `cruiselines` 0.0029709339141846
(391) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00053095817565918
(392) DESCRIBE `orchid_image` 0.0022571086883545
(393) DESCRIBE `cruiselines` 0.002877950668335
(394) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00043988227844238
(395) DESCRIBE `cruises` 0.0039680004119873
(396) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70947') 0.00049686431884766
(397) DESCRIBE `ships` 0.0040948390960693
(398) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00058507919311523
(399) DESCRIBE `ships` 0.003986120223999
(400) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00044989585876465
(401) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00043702125549316
(402) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00039911270141602
(403) DESCRIBE `itineraries` 0.0020060539245605
(404) DESCRIBE `ports` 0.00211501121521
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00050997734069824
(406) DESCRIBE `ports` 0.0021200180053711
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048494338989258
(408) DESCRIBE `ports` 0.0021278858184814
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00045394897460938
(410) DESCRIBE `sailingdates` 0.0017960071563721
(411) DESCRIBE `ports` 0.0020761489868164
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004880428314209
(413) DESCRIBE `ports` 0.00205397605896
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00056195259094238
(415) DESCRIBE `ports` 0.002018928527832
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00057411193847656
(417) DESCRIBE `ports` 0.0020561218261719
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00044107437133789
(419) DESCRIBE `ports` 0.0020668506622314
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00049209594726562
(421) DESCRIBE `ports` 0.0022721290588379
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00043392181396484
(423) DESCRIBE `ports` 0.0020568370819092
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.0005030632019043
(425) DESCRIBE `ports` 0.0021240711212158
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00043511390686035
(427) DESCRIBE `ports` 0.0020921230316162
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00052499771118164
(429) DESCRIBE `ports` 0.0026159286499023
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00049090385437012
(431) DESCRIBE `ports` 0.0017971992492676
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044107437133789
(433) DESCRIBE `ports` 0.001737117767334
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040221214294434
(435) DESCRIBE `avid_specials` 0.0017530918121338
(436) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70947 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0011441707611084
(437) DESCRIBE `cruiselines` 0.0027589797973633
(438) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00043296813964844
(439) DESCRIBE `orchid_image` 0.0021791458129883
(440) DESCRIBE `cruiselines` 0.0026528835296631
(441) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00038599967956543
(442) DESCRIBE `ships` 0.0040450096130371
(443) SELECT `ships`.* FROM `ships` WHERE (id IN ('1722', '4')) ORDER BY FIND_IN_SET(id, '1722,4') 0.0010969638824463
(444) DESCRIBE `cruisetypes` 0.0018770694732666
(445) DESCRIBE `destinations` 0.0025360584259033
(446) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.00072908401489258
(447) DESCRIBE `cruiselines` 0.0032360553741455
(448) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00047397613525391
(449) DESCRIBE `cruiselines` 0.0027780532836914
(450) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00048422813415527