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

Total elapsed time: 1.0153772830963

# Query Time
(1) connect 0.00099706649780273
(2) DESCRIBE `cruises` 0.0042049884796143
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (50857, 41778, 50866, 63373, 55702, 75670, 70935, 70947, 75790, 55704)) ORDER BY FIND_IN_SET(id, '50857,41778,50866,63373,55702,75670,70935,70947,75790,55704') 0.0023398399353027
(4) DESCRIBE `cruises` 0.0037450790405273
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50857') 0.00050091743469238
(6) DESCRIBE `ships` 0.0039901733398438
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00053000450134277
(8) DESCRIBE `ships` 0.0038611888885498
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00046992301940918
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00041913986206055
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034594535827637
(12) DESCRIBE `itineraries` 0.0024139881134033
(13) DESCRIBE `ports` 0.002039909362793
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046396255493164
(15) DESCRIBE `ports` 0.0019450187683105
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043988227844238
(17) DESCRIBE `ports` 0.0022039413452148
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042390823364258
(19) DESCRIBE `sailingdates` 0.0020821094512939
(20) DESCRIBE `ports` 0.0023300647735596
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043892860412598
(22) DESCRIBE `ports` 0.002263069152832
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042414665222168
(24) DESCRIBE `ports` 0.0022060871124268
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00043487548828125
(26) DESCRIBE `ports` 0.0019879341125488
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00040006637573242
(28) DESCRIBE `ports` 0.0019409656524658
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00051093101501465
(30) DESCRIBE `ports` 0.0019569396972656
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00039887428283691
(32) DESCRIBE `ports` 0.0019130706787109
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00040602684020996
(34) DESCRIBE `ports` 0.0017871856689453
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00035786628723145
(36) DESCRIBE `ports` 0.0018019676208496
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00046896934509277
(38) DESCRIBE `ports` 0.0018370151519775
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.0003809928894043
(40) DESCRIBE `ports` 0.0020360946655273
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00055408477783203
(42) DESCRIBE `ports` 0.0017738342285156
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037789344787598
(44) DESCRIBE `avid_specials` 0.0017778873443604
(45) 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.0012011528015137
(46) DESCRIBE `cruiselines` 0.0033009052276611
(47) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0004580020904541
(48) DESCRIBE `orchid_image` 0.0024588108062744
(49) DESCRIBE `cruiselines` 0.002993106842041
(50) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00040507316589355
(51) DESCRIBE `cruises` 0.0040969848632812
(52) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41778') 0.00045895576477051
(53) DESCRIBE `ships` 0.0041000843048096
(54) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00054311752319336
(55) DESCRIBE `ships` 0.004019021987915
(56) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00046896934509277
(57) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034618377685547
(58) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00042605400085449
(59) DESCRIBE `itineraries` 0.0018129348754883
(60) DESCRIBE `ports` 0.0020499229431152
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047588348388672
(62) DESCRIBE `ports` 0.0022871494293213
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046491622924805
(64) DESCRIBE `ports` 0.0022201538085938
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00046515464782715
(66) DESCRIBE `sailingdates` 0.00199294090271
(67) DESCRIBE `ports` 0.0019509792327881
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047087669372559
(69) DESCRIBE `ports` 0.0019462108612061
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041580200195312
(71) DESCRIBE `ports` 0.0021090507507324
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004270076751709
(73) DESCRIBE `ports` 0.001986026763916
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044393539428711
(75) DESCRIBE `avid_specials` 0.0017478466033936
(76) 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.0012328624725342
(77) DESCRIBE `cruiselines` 0.0033638477325439
(78) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0007328987121582
(79) DESCRIBE `orchid_image` 0.0027670860290527
(80) DESCRIBE `cruiselines` 0.0033950805664062
(81) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00054311752319336
(82) DESCRIBE `cruises` 0.0046091079711914
(83) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50866') 0.00058293342590332
(84) DESCRIBE `ships` 0.0042738914489746
(85) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00060009956359863
(86) DESCRIBE `ships` 0.0041208267211914
(87) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00044703483581543
(88) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037503242492676
(89) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036907196044922
(90) DESCRIBE `itineraries` 0.0023691654205322
(91) DESCRIBE `ports` 0.0021100044250488
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045514106750488
(93) DESCRIBE `ports` 0.0021531581878662
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00051212310791016
(95) DESCRIBE `ports` 0.0024700164794922
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00058197975158691
(97) DESCRIBE `sailingdates` 0.0022778511047363
(98) DESCRIBE `ports` 0.001986026763916
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00059890747070312
(100) DESCRIBE `ports` 0.0022609233856201
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040698051452637
(102) DESCRIBE `ports` 0.0020148754119873
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00043201446533203
(104) DESCRIBE `ports` 0.002068042755127
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0006401538848877
(106) DESCRIBE `ports` 0.0018091201782227
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00060391426086426
(108) DESCRIBE `ports` 0.0026710033416748
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00053811073303223
(110) DESCRIBE `ports` 0.0019400119781494
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00045585632324219
(112) DESCRIBE `ports` 0.0019371509552002
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00037908554077148
(114) DESCRIBE `ports` 0.0018680095672607
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043296813964844
(116) DESCRIBE `ports` 0.0019350051879883
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003809928894043
(118) DESCRIBE `avid_specials` 0.0015640258789062
(119) 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.0019330978393555
(120) DESCRIBE `cruiselines` 0.0039670467376709
(121) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00067901611328125
(122) DESCRIBE `orchid_image` 0.0027990341186523
(123) DESCRIBE `cruiselines` 0.0034589767456055
(124) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00054216384887695
(125) DESCRIBE `cruises` 0.0046420097351074
(126) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63373') 0.00060701370239258
(127) DESCRIBE `ships` 0.0047640800476074
(128) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00072813034057617
(129) DESCRIBE `ships` 0.0046801567077637
(130) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00057506561279297
(131) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00045895576477051
(132) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00044679641723633
(133) DESCRIBE `itineraries` 0.0020589828491211
(134) DESCRIBE `ports` 0.0021438598632812
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00058484077453613
(136) DESCRIBE `ports` 0.0023040771484375
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00056576728820801
(138) DESCRIBE `ports` 0.0022869110107422
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00047898292541504
(140) DESCRIBE `sailingdates` 0.0022058486938477
(141) DESCRIBE `ports` 0.0022859573364258
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00058603286743164
(143) DESCRIBE `ports` 0.0026071071624756
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00058102607727051
(145) DESCRIBE `ports` 0.002816915512085
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00060105323791504
(147) DESCRIBE `ports` 0.0028841495513916
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00072598457336426
(149) DESCRIBE `ports` 0.0027260780334473
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00064611434936523
(151) DESCRIBE `ports` 0.0028159618377686
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00059795379638672
(153) DESCRIBE `ports` 0.0025591850280762
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.000518798828125
(155) DESCRIBE `ports` 0.0025870800018311
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00041007995605469
(157) DESCRIBE `ports` 0.001924991607666
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00044393539428711
(159) DESCRIBE `ports` 0.0021209716796875
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00054502487182617
(161) DESCRIBE `ports` 0.0018191337585449
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00058698654174805
(163) DESCRIBE `ports` 0.001953125
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00038003921508789
(165) DESCRIBE `ports` 0.0021650791168213
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044989585876465
(167) DESCRIBE `ports` 0.0021600723266602
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040411949157715
(169) DESCRIBE `avid_specials` 0.0019500255584717
(170) 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.0012340545654297
(171) DESCRIBE `cruiselines` 0.0027318000793457
(172) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00046205520629883
(173) DESCRIBE `orchid_image` 0.0025248527526855
(174) DESCRIBE `cruiselines` 0.0029771327972412
(175) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00047016143798828
(176) DESCRIBE `cruises` 0.0036888122558594
(177) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55702') 0.00061202049255371
(178) DESCRIBE `ships` 0.0052859783172607
(179) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00089120864868164
(180) DESCRIBE `ships` 0.0052521228790283
(181) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00061202049255371
(182) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00049114227294922
(183) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0005028247833252
(184) DESCRIBE `itineraries` 0.0026779174804688
(185) DESCRIBE `ports` 0.0026869773864746
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00060701370239258
(187) DESCRIBE `ports` 0.0026540756225586
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048685073852539
(189) DESCRIBE `ports` 0.0020620822906494
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039911270141602
(191) DESCRIBE `sailingdates` 0.0016891956329346
(192) DESCRIBE `ports` 0.0018959045410156
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044107437133789
(194) DESCRIBE `ports` 0.0019028186798096
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038814544677734
(196) DESCRIBE `ports` 0.0017809867858887
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00048398971557617
(198) DESCRIBE `ports` 0.0020911693572998
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00039386749267578
(200) DESCRIBE `ports` 0.0019280910491943
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004270076751709
(202) DESCRIBE `ports` 0.001971960067749
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039315223693848
(204) DESCRIBE `avid_specials` 0.0018060207366943
(205) 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.0011658668518066
(206) DESCRIBE `cruiselines` 0.0032708644866943
(207) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00048494338989258
(208) DESCRIBE `orchid_image` 0.0020639896392822
(209) DESCRIBE `cruiselines` 0.0026140213012695
(210) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00040292739868164
(211) DESCRIBE `cruises` 0.0034439563751221
(212) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75670') 0.00043177604675293
(213) DESCRIBE `ships` 0.0036280155181885
(214) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.0005800724029541
(215) DESCRIBE `ships` 0.0038201808929443
(216) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1722') 0.00055098533630371
(217) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036001205444336
(218) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034999847412109
(219) DESCRIBE `itineraries` 0.0018658638000488
(220) DESCRIBE `ports` 0.0025439262390137
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00061202049255371
(222) DESCRIBE `ports` 0.0026688575744629
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0005948543548584
(224) DESCRIBE `ports` 0.0025098323822021
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00053906440734863
(226) DESCRIBE `sailingdates` 0.0023479461669922
(227) DESCRIBE `ports` 0.0026340484619141
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0006110668182373
(229) DESCRIBE `ports` 0.002561092376709
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00062012672424316
(231) DESCRIBE `ports` 0.0025620460510254
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00056791305541992
(233) DESCRIBE `ports` 0.0026171207427979
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00054502487182617
(235) DESCRIBE `ports` 0.0027120113372803
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1037))) 0.00061297416687012
(237) DESCRIBE `ports` 0.0027189254760742
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1037') 0.00055503845214844
(239) DESCRIBE `ports` 0.0026528835296631
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00060296058654785
(241) DESCRIBE `ports` 0.0025808811187744
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00064277648925781
(243) DESCRIBE `ports` 0.0025670528411865
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00062012672424316
(245) DESCRIBE `ports` 0.0026309490203857
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00060510635375977
(247) DESCRIBE `ports` 0.002640962600708
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00087380409240723
(249) DESCRIBE `ports` 0.0026688575744629
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.0010569095611572
(251) DESCRIBE `ports` 0.0026190280914307
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00071191787719727
(253) DESCRIBE `ports` 0.0025591850280762
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00053906440734863
(255) DESCRIBE `avid_specials` 0.0022609233856201
(256) 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.0021569728851318
(257) DESCRIBE `cruiselines` 0.0029010772705078
(258) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00051593780517578
(259) DESCRIBE `orchid_image` 0.002187967300415
(260) DESCRIBE `cruiselines` 0.0039389133453369
(261) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00060582160949707
(262) DESCRIBE `cruises` 0.0050919055938721
(263) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70935') 0.00052285194396973
(264) DESCRIBE `ships` 0.0058779716491699
(265) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00093483924865723
(266) DESCRIBE `ships` 0.0056278705596924
(267) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00075602531433105
(268) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00060391426086426
(269) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00053501129150391
(270) DESCRIBE `itineraries` 0.0028619766235352
(271) DESCRIBE `ports` 0.003511905670166
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0030288696289062
(273) DESCRIBE `ports` 0.0030791759490967
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00076508522033691
(275) DESCRIBE `ports` 0.0032269954681396
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00099682807922363
(277) DESCRIBE `sailingdates` 0.0027370452880859
(278) DESCRIBE `ports` 0.0028319358825684
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00074100494384766
(280) DESCRIBE `ports` 0.0028359889984131
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0008089542388916
(282) DESCRIBE `ports` 0.0027098655700684
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0006721019744873
(284) DESCRIBE `ports` 0.0029871463775635
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00061702728271484
(286) DESCRIBE `ports` 0.0028500556945801
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00070500373840332
(288) DESCRIBE `ports` 0.0026931762695312
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00056815147399902
(290) DESCRIBE `ports` 0.0025339126586914
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00064396858215332
(292) DESCRIBE `ports` 0.0028328895568848
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.0006709098815918
(294) DESCRIBE `ports` 0.0028760433197021
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00067710876464844
(296) DESCRIBE `ports` 0.0030980110168457
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00078892707824707
(298) DESCRIBE `ports` 0.0091409683227539
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00089216232299805
(300) DESCRIBE `ports` 0.0028660297393799
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00066685676574707
(302) DESCRIBE `ports` 0.0029349327087402
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00067996978759766
(304) DESCRIBE `ports` 0.0029218196868896
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00074601173400879
(306) DESCRIBE `avid_specials` 0.0027191638946533
(307) 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.0022628307342529
(308) DESCRIBE `cruiselines` 0.0041778087615967
(309) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00072216987609863
(310) DESCRIBE `orchid_image` 0.0036659240722656
(311) DESCRIBE `cruiselines` 0.0038979053497314
(312) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00068807601928711
(313) DESCRIBE `cruises` 0.0062088966369629
(314) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70947') 0.00069808959960938
(315) DESCRIBE `ships` 0.0056450366973877
(316) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00084900856018066
(317) DESCRIBE `ships` 0.012455940246582
(318) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00079584121704102
(319) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00054407119750977
(320) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00046110153198242
(321) DESCRIBE `itineraries` 0.0031039714813232
(322) DESCRIBE `ports` 0.003187894821167
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00077104568481445
(324) DESCRIBE `ports` 0.003389835357666
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00075507164001465
(326) DESCRIBE `ports` 0.0030448436737061
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00067591667175293
(328) DESCRIBE `sailingdates` 0.0024869441986084
(329) DESCRIBE `ports` 0.0033309459686279
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00076198577880859
(331) DESCRIBE `ports` 0.002938985824585
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00064206123352051
(333) DESCRIBE `ports` 0.0028138160705566
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00069499015808105
(335) DESCRIBE `ports` 0.0029349327087402
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00064492225646973
(337) DESCRIBE `ports` 0.0029270648956299
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.0010478496551514
(339) DESCRIBE `ports` 0.0030031204223633
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00064611434936523
(341) DESCRIBE `ports` 0.0027899742126465
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00069093704223633
(343) DESCRIBE `ports` 0.0029940605163574
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00062990188598633
(345) DESCRIBE `ports` 0.0037422180175781
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00072503089904785
(347) DESCRIBE `ports` 0.0033900737762451
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0007178783416748
(349) DESCRIBE `ports` 0.0026869773864746
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00071001052856445
(351) DESCRIBE `ports` 0.0034229755401611
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0006411075592041
(353) DESCRIBE `avid_specials` 0.0026309490203857
(354) 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.0021548271179199
(355) DESCRIBE `cruiselines` 0.0040719509124756
(356) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00073099136352539
(357) DESCRIBE `orchid_image` 0.0035638809204102
(358) DESCRIBE `cruiselines` 0.0042099952697754
(359) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00065207481384277
(360) DESCRIBE `cruises` 0.012615919113159
(361) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75790') 0.0010561943054199
(362) DESCRIBE `ships` 0.0058960914611816
(363) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.001060962677002
(364) DESCRIBE `ships` 0.0057978630065918
(365) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1722') 0.0009760856628418
(366) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00052094459533691
(367) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00051307678222656
(368) DESCRIBE `itineraries` 0.0029070377349854
(369) DESCRIBE `ports` 0.0032429695129395
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00075483322143555
(371) DESCRIBE `ports` 0.0030069351196289
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00067687034606934
(373) DESCRIBE `ports` 0.0030548572540283
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00064897537231445
(375) DESCRIBE `sailingdates` 0.0027201175689697
(376) DESCRIBE `ports` 0.0029458999633789
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00065398216247559
(378) DESCRIBE `ports` 0.016864061355591
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00096392631530762
(380) DESCRIBE `ports` 0.0069689750671387
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00071597099304199
(382) DESCRIBE `ports` 0.0028610229492188
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0006871223449707
(384) DESCRIBE `ports` 0.0056159496307373
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.0006859302520752
(386) DESCRIBE `ports` 0.002842903137207
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00058484077453613
(388) DESCRIBE `ports` 0.0069289207458496
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00077080726623535
(390) DESCRIBE `ports` 0.020358085632324
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00070405006408691
(392) DESCRIBE `ports` 0.0024590492248535
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00083613395690918
(394) DESCRIBE `ports` 0.0027821063995361
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00066399574279785
(396) DESCRIBE `avid_specials` 0.0023880004882812
(397) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75790 and class = 'Cruise') OR (item_id = 1722 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.0020620822906494
(398) DESCRIBE `cruiselines` 0.0041191577911377
(399) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00063085556030273
(400) DESCRIBE `orchid_image` 0.0028090476989746
(401) DESCRIBE `cruiselines` 0.0035169124603271
(402) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00069403648376465
(403) DESCRIBE `cruises` 0.0091512203216553
(404) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55704') 0.0011498928070068
(405) DESCRIBE `ships` 0.0066070556640625
(406) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00088787078857422
(407) DESCRIBE `ships` 0.0058269500732422
(408) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00076699256896973
(409) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00053286552429199
(410) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00053095817565918
(411) DESCRIBE `itineraries` 0.0030250549316406
(412) DESCRIBE `ports` 0.0030651092529297
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00084900856018066
(414) DESCRIBE `ports` 0.0065600872039795
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00092005729675293
(416) DESCRIBE `ports` 0.0028870105743408
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00070095062255859
(418) DESCRIBE `sailingdates` 0.0028371810913086
(419) DESCRIBE `ports` 0.0040221214294434
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00076198577880859
(421) DESCRIBE `ports` 0.0033750534057617
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.001223087310791
(423) DESCRIBE `ports` 0.0103440284729
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00092005729675293
(425) DESCRIBE `ports` 0.0038261413574219
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0012309551239014
(427) DESCRIBE `ports` 0.004162073135376
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00086212158203125
(429) DESCRIBE `ports` 0.0027759075164795
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00060105323791504
(431) DESCRIBE `ports` 0.0028359889984131
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00066304206848145
(433) DESCRIBE `ports` 0.0026881694793701
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00055408477783203
(435) DESCRIBE `ports` 0.0066478252410889
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.001121997833252
(437) DESCRIBE `ports` 0.004324197769165
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00069618225097656
(439) DESCRIBE `ports` 0.0027830600738525
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00072002410888672
(441) DESCRIBE `ports` 0.0027720928192139
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00061607360839844
(443) DESCRIBE `ports` 0.0028700828552246
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0022718906402588
(445) DESCRIBE `ports` 0.0067799091339111
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00067615509033203
(447) DESCRIBE `avid_specials` 0.0027689933776855
(448) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55704 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.0025010108947754
(449) DESCRIBE `cruiselines` 0.0038971900939941
(450) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00071597099304199
(451) DESCRIBE `orchid_image` 0.0038979053497314
(452) DESCRIBE `cruiselines` 0.02892804145813
(453) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00072598457336426
(454) DESCRIBE `ships` 0.0062918663024902
(455) SELECT `ships`.* FROM `ships` WHERE (id IN ('1722', '4')) ORDER BY FIND_IN_SET(id, '1722,4') 0.0014059543609619
(456) DESCRIBE `cruisetypes` 0.0025279521942139
(457) DESCRIBE `destinations` 0.0061399936676025
(458) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.0013101100921631
(459) DESCRIBE `cruiselines` 0.0054218769073486
(460) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0066769123077393
(461) DESCRIBE `cruiselines` 0.030778884887695
(462) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0095360279083252