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

Total elapsed time: 0.94224071502686

# Query Time
(1) connect 0.0020630359649658
(2) DESCRIBE `cruises` 0.010092973709106
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (75670, 75790, 75791, 75792, 77804, 77805, 77806, 77807, 77808, 77809)) ORDER BY FIND_IN_SET(id, '75670,75790,75791,75792,77804,77805,77806,77807,77808,77809') 0.0036358833312988
(4) DESCRIBE `cruises` 0.0050158500671387
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75670') 0.00056314468383789
(6) DESCRIBE `ships` 0.0060632228851318
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.0057811737060547
(8) DESCRIBE `ships` 0.0048661231994629
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1722') 0.0093750953674316
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00040984153747559
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034689903259277
(12) DESCRIBE `itineraries` 0.0020408630371094
(13) DESCRIBE `ports` 0.0096569061279297
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00041794776916504
(15) DESCRIBE `ports` 0.0019810199737549
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00038909912109375
(17) DESCRIBE `ports` 0.0020530223846436
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00055503845214844
(19) DESCRIBE `sailingdates` 0.0098450183868408
(20) DESCRIBE `ports` 0.009242057800293
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00052189826965332
(22) DESCRIBE `ports` 0.0025770664215088
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00047588348388672
(24) DESCRIBE `ports` 0.0021460056304932
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.0064089298248291
(26) DESCRIBE `ports` 0.0031850337982178
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00041985511779785
(28) DESCRIBE `ports` 0.0018908977508545
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1037))) 0.00050902366638184
(30) DESCRIBE `ports` 0.002129077911377
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1037') 0.0004570484161377
(32) DESCRIBE `ports` 0.0021090507507324
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00041103363037109
(34) DESCRIBE `ports` 0.0020251274108887
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00046181678771973
(36) DESCRIBE `ports` 0.0029830932617188
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00043296813964844
(38) DESCRIBE `ports` 0.0020229816436768
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00038909912109375
(40) DESCRIBE `ports` 0.0020980834960938
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.0037641525268555
(42) DESCRIBE `ports` 0.0056569576263428
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00059795379638672
(44) DESCRIBE `ports` 0.0026872158050537
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004580020904541
(46) DESCRIBE `ports` 0.0017578601837158
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043606758117676
(48) DESCRIBE `avid_specials` 0.0020618438720703
(49) 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.0017349720001221
(50) DESCRIBE `cruiselines` 0.0028648376464844
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00051093101501465
(52) DESCRIBE `orchid_image` 0.002269983291626
(53) DESCRIBE `cruiselines` 0.01269793510437
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00047397613525391
(55) DESCRIBE `cruises` 0.0036780834197998
(56) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75790') 0.00040388107299805
(57) DESCRIBE `ships` 0.0048959255218506
(58) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.00062298774719238
(59) DESCRIBE `ships` 0.0044050216674805
(60) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1722') 0.00057816505432129
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00052118301391602
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00052595138549805
(63) DESCRIBE `itineraries` 0.0026640892028809
(64) DESCRIBE `ports` 0.0026271343231201
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00063395500183105
(66) DESCRIBE `ports` 0.0027930736541748
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00057792663574219
(68) DESCRIBE `ports` 0.011344194412231
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0006251335144043
(70) DESCRIBE `sailingdates` 0.0024278163909912
(71) DESCRIBE `ports` 0.0033919811248779
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0007319450378418
(73) DESCRIBE `ports` 0.0027129650115967
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00053286552429199
(75) DESCRIBE `ports` 0.0025289058685303
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00054192543029785
(77) DESCRIBE `ports` 0.0025200843811035
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00052785873413086
(79) DESCRIBE `ports` 0.0025651454925537
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00051999092102051
(81) DESCRIBE `ports` 0.0026731491088867
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00042080879211426
(83) DESCRIBE `ports` 0.0021898746490479
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00062799453735352
(85) DESCRIBE `ports` 0.0027379989624023
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00052905082702637
(87) DESCRIBE `ports` 0.0026340484619141
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00059604644775391
(89) DESCRIBE `ports` 0.0037891864776611
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00066184997558594
(91) DESCRIBE `avid_specials` 0.0025820732116699
(92) 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
(93) DESCRIBE `cruiselines` 0.0045559406280518
(94) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00062394142150879
(95) DESCRIBE `orchid_image` 0.0032320022583008
(96) DESCRIBE `cruiselines` 0.0037908554077148
(97) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00065207481384277
(98) DESCRIBE `cruises` 0.013047933578491
(99) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75791') 0.00048995018005371
(100) DESCRIBE `ships` 0.0099399089813232
(101) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.00072288513183594
(102) DESCRIBE `ships` 0.0040409564971924
(103) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1722') 0.0060379505157471
(104) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00048708915710449
(105) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00048494338989258
(106) DESCRIBE `itineraries` 0.0021300315856934
(107) DESCRIBE `ports` 0.002190113067627
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00054287910461426
(109) DESCRIBE `ports` 0.0022339820861816
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00062894821166992
(111) DESCRIBE `ports` 0.010347843170166
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0042939186096191
(113) DESCRIBE `sailingdates` 0.0025870800018311
(114) DESCRIBE `ports` 0.0038740634918213
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.005033016204834
(116) DESCRIBE `ports` 0.0028910636901855
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0058300495147705
(118) DESCRIBE `ports` 0.0026929378509521
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0057258605957031
(120) DESCRIBE `ports` 0.0020091533660889
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.005253791809082
(122) DESCRIBE `ports` 0.0033009052276611
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00048613548278809
(124) DESCRIBE `ports` 0.0028388500213623
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00049281120300293
(126) DESCRIBE `ports` 0.0026209354400635
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00059318542480469
(128) DESCRIBE `ports` 0.0029120445251465
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00048017501831055
(130) DESCRIBE `ports` 0.0027949810028076
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00055718421936035
(132) DESCRIBE `ports` 0.0027999877929688
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00055885314941406
(134) DESCRIBE `avid_specials` 0.0026860237121582
(135) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75791 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.0020298957824707
(136) DESCRIBE `cruiselines` 0.0045068264007568
(137) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00060820579528809
(138) DESCRIBE `orchid_image` 0.0028831958770752
(139) DESCRIBE `cruiselines` 0.003748893737793
(140) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00052905082702637
(141) DESCRIBE `cruises` 0.0049140453338623
(142) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75792') 0.00055098533630371
(143) DESCRIBE `ships` 0.0054450035095215
(144) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.00091195106506348
(145) DESCRIBE `ships` 0.0052139759063721
(146) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1722') 0.0007479190826416
(147) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00049996376037598
(148) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00054502487182617
(149) DESCRIBE `itineraries` 0.002741813659668
(150) DESCRIBE `ports` 0.0028438568115234
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00061511993408203
(152) DESCRIBE `ports` 0.0028069019317627
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0006861686706543
(154) DESCRIBE `ports` 0.0028340816497803
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00074291229248047
(156) DESCRIBE `sailingdates` 0.0022761821746826
(157) DESCRIBE `ports` 0.0027968883514404
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0006709098815918
(159) DESCRIBE `ports` 0.0048527717590332
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00075793266296387
(161) DESCRIBE `ports` 0.0026769638061523
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00055408477783203
(163) DESCRIBE `ports` 0.0021660327911377
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00046610832214355
(165) DESCRIBE `ports` 0.0017929077148438
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00050711631774902
(167) DESCRIBE `ports` 0.0021350383758545
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00046420097351074
(169) DESCRIBE `ports` 0.0020861625671387
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.0004417896270752
(171) DESCRIBE `ports` 0.0025949478149414
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00048613548278809
(173) DESCRIBE `ports` 0.002964973449707
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00046586990356445
(175) DESCRIBE `ports` 0.0020289421081543
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0005488395690918
(177) DESCRIBE `ports` 0.0021450519561768
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00066900253295898
(179) DESCRIBE `ports` 0.0024800300598145
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042486190795898
(181) DESCRIBE `avid_specials` 0.0019500255584717
(182) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75792 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.001417875289917
(183) DESCRIBE `cruiselines` 0.0031659603118896
(184) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00048398971557617
(185) DESCRIBE `orchid_image` 0.00282883644104
(186) DESCRIBE `cruiselines` 0.0031418800354004
(187) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00060796737670898
(188) DESCRIBE `cruises` 0.0045950412750244
(189) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77804') 0.00062799453735352
(190) DESCRIBE `ships` 0.0039799213409424
(191) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.00058889389038086
(192) DESCRIBE `ships` 0.0044310092926025
(193) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1722') 0.00064611434936523
(194) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00050687789916992
(195) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00038313865661621
(196) DESCRIBE `itineraries` 0.0022320747375488
(197) DESCRIBE `ports` 0.0021800994873047
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049710273742676
(199) DESCRIBE `ports` 0.0021870136260986
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047516822814941
(201) DESCRIBE `ports` 0.0019869804382324
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00053596496582031
(203) DESCRIBE `sailingdates` 0.0017490386962891
(204) DESCRIBE `ports` 0.0020198822021484
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00049090385437012
(206) DESCRIBE `ports` 0.0018010139465332
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00048494338989258
(208) DESCRIBE `ports` 0.0020780563354492
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00041294097900391
(210) DESCRIBE `ports` 0.0018298625946045
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00042605400085449
(212) DESCRIBE `ports` 0.0021078586578369
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00042295455932617
(214) DESCRIBE `ports` 0.0025289058685303
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00050902366638184
(216) DESCRIBE `ports` 0.0024700164794922
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00060606002807617
(218) DESCRIBE `ports` 0.0020179748535156
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.0003969669342041
(220) DESCRIBE `ports` 0.0019388198852539
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00043797492980957
(222) DESCRIBE `ports` 0.0018148422241211
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00038886070251465
(224) DESCRIBE `ports` 0.0018978118896484
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00051403045654297
(226) DESCRIBE `ports` 0.0018861293792725
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039100646972656
(228) DESCRIBE `avid_specials` 0.0017809867858887
(229) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77804 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.0013039112091064
(230) DESCRIBE `cruiselines` 0.002593994140625
(231) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00045895576477051
(232) DESCRIBE `orchid_image` 0.002108097076416
(233) DESCRIBE `cruiselines` 0.0029962062835693
(234) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00041389465332031
(235) DESCRIBE `cruises` 0.0038230419158936
(236) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77805') 0.00050497055053711
(237) DESCRIBE `ships` 0.013928174972534
(238) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.0010640621185303
(239) DESCRIBE `ships` 0.0055880546569824
(240) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1722') 0.000762939453125
(241) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0085721015930176
(242) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00049996376037598
(243) DESCRIBE `itineraries` 0.0026819705963135
(244) DESCRIBE `ports` 0.0029489994049072
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00065994262695312
(246) DESCRIBE `ports` 0.0026857852935791
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00063705444335938
(248) DESCRIBE `ports` 0.0026841163635254
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00068521499633789
(250) DESCRIBE `sailingdates` 0.0023109912872314
(251) DESCRIBE `ports` 0.014567136764526
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00072383880615234
(253) DESCRIBE `ports` 0.0026900768280029
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00053787231445312
(255) DESCRIBE `ports` 0.0026071071624756
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00065779685974121
(257) DESCRIBE `ports` 0.0030679702758789
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00058817863464355
(259) DESCRIBE `ports` 0.0028450489044189
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00061416625976562
(261) DESCRIBE `ports` 0.0026111602783203
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00051498413085938
(263) DESCRIBE `avid_specials` 0.0023097991943359
(264) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77805 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.0020370483398438
(265) DESCRIBE `cruiselines` 0.0059549808502197
(266) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00065708160400391
(267) DESCRIBE `orchid_image` 0.0029189586639404
(268) DESCRIBE `cruiselines` 0.0039398670196533
(269) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00053620338439941
(270) DESCRIBE `cruises` 0.0046749114990234
(271) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77806') 0.00053811073303223
(272) DESCRIBE `ships` 0.0049281120300293
(273) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.00079607963562012
(274) DESCRIBE `ships` 0.0048229694366455
(275) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1722') 0.00064682960510254
(276) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00047516822814941
(277) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00056886672973633
(278) DESCRIBE `itineraries` 0.0023999214172363
(279) DESCRIBE `ports` 0.0026640892028809
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00060606002807617
(281) DESCRIBE `ports` 0.0029680728912354
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00054383277893066
(283) DESCRIBE `ports` 0.0025460720062256
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0010631084442139
(285) DESCRIBE `sailingdates` 0.002223014831543
(286) DESCRIBE `ports` 0.0027129650115967
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00060606002807617
(288) DESCRIBE `ports` 0.0025169849395752
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00050997734069824
(290) DESCRIBE `ports` 0.0027039051055908
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00056600570678711
(292) DESCRIBE `ports` 0.0024428367614746
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00058698654174805
(294) DESCRIBE `ports` 0.0025131702423096
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00057291984558105
(296) DESCRIBE `ports` 0.0024309158325195
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00048303604125977
(298) DESCRIBE `ports` 0.0025279521942139
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00072407722473145
(300) DESCRIBE `ports` 0.0026400089263916
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00056290626525879
(302) DESCRIBE `ports` 0.0026330947875977
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00064492225646973
(304) DESCRIBE `ports` 0.0022299289703369
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00051999092102051
(306) DESCRIBE `avid_specials` 0.0017859935760498
(307) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77806 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.0012729167938232
(308) DESCRIBE `cruiselines` 0.0028691291809082
(309) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00056886672973633
(310) DESCRIBE `orchid_image` 0.0024640560150146
(311) DESCRIBE `cruiselines` 0.0028231143951416
(312) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00049018859863281
(313) DESCRIBE `cruises` 0.0046679973602295
(314) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77807') 0.00050091743469238
(315) DESCRIBE `ships` 0.0043919086456299
(316) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.00064897537231445
(317) DESCRIBE `ships` 0.0040550231933594
(318) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1722') 0.00054597854614258
(319) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00042605400085449
(320) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036287307739258
(321) DESCRIBE `itineraries` 0.0021131038665771
(322) DESCRIBE `ports` 0.0026679039001465
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00062704086303711
(324) DESCRIBE `ports` 0.0020768642425537
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004580020904541
(326) DESCRIBE `ports` 0.0019729137420654
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042414665222168
(328) DESCRIBE `sailingdates` 0.0024068355560303
(329) DESCRIBE `ports` 0.0028810501098633
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00066208839416504
(331) DESCRIBE `ports` 0.0028209686279297
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00062799453735352
(333) DESCRIBE `ports` 0.0058090686798096
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00059294700622559
(335) DESCRIBE `ports` 0.0020749568939209
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00044989585876465
(337) DESCRIBE `ports` 0.0020859241485596
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00054788589477539
(339) DESCRIBE `ports` 0.0027928352355957
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00045084953308105
(341) DESCRIBE `ports` 0.0021049976348877
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.0066230297088623
(343) DESCRIBE `ports` 0.0021100044250488
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00088810920715332
(345) DESCRIBE `ports` 0.0022058486938477
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00051784515380859
(347) DESCRIBE `ports` 0.0019099712371826
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.0004279613494873
(349) DESCRIBE `ports` 0.0021018981933594
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047898292541504
(351) DESCRIBE `ports` 0.0022871494293213
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00060105323791504
(353) DESCRIBE `avid_specials` 0.0018730163574219
(354) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77807 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.0014519691467285
(355) DESCRIBE `cruiselines` 0.0028970241546631
(356) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00057506561279297
(357) DESCRIBE `orchid_image` 0.002371072769165
(358) DESCRIBE `cruiselines` 0.003338098526001
(359) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00044798851013184
(360) DESCRIBE `cruises` 0.0038261413574219
(361) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77808') 0.00053501129150391
(362) DESCRIBE `ships` 0.0039589405059814
(363) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.00062203407287598
(364) DESCRIBE `ships` 0.0041120052337646
(365) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1722') 0.0006709098815918
(366) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003960132598877
(367) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00047397613525391
(368) DESCRIBE `itineraries` 0.0021319389343262
(369) DESCRIBE `ports` 0.0023529529571533
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00052714347839355
(371) DESCRIBE `ports` 0.0020389556884766
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00051498413085938
(373) DESCRIBE `ports` 0.0020079612731934
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041413307189941
(375) DESCRIBE `sailingdates` 0.0019559860229492
(376) DESCRIBE `ports` 0.0020859241485596
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048208236694336
(378) DESCRIBE `ports` 0.0020129680633545
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00063300132751465
(380) DESCRIBE `ports` 0.0020501613616943
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00050806999206543
(382) DESCRIBE `ports` 0.0020520687103271
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00048613548278809
(384) DESCRIBE `ports` 0.0021169185638428
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00066304206848145
(386) DESCRIBE `ports` 0.0020229816436768
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00039291381835938
(388) DESCRIBE `ports` 0.0021340847015381
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043201446533203
(390) DESCRIBE `ports` 0.001856803894043
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00045323371887207
(392) DESCRIBE `avid_specials` 0.0020239353179932
(393) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77808 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.0014030933380127
(394) DESCRIBE `cruiselines` 0.0027837753295898
(395) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00046706199645996
(396) DESCRIBE `orchid_image` 0.0022509098052979
(397) DESCRIBE `cruiselines` 0.0027389526367188
(398) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00041604042053223
(399) DESCRIBE `cruises` 0.0036730766296387
(400) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77809') 0.00052809715270996
(401) DESCRIBE `ships` 0.0040149688720703
(402) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.00068402290344238
(403) DESCRIBE `ships` 0.0043468475341797
(404) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1722') 0.00063014030456543
(405) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00038313865661621
(406) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00051307678222656
(407) DESCRIBE `itineraries` 0.0019378662109375
(408) DESCRIBE `ports` 0.002288818359375
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047588348388672
(410) DESCRIBE `ports` 0.0033199787139893
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00056099891662598
(412) DESCRIBE `ports` 0.002241849899292
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044894218444824
(414) DESCRIBE `sailingdates` 0.0016059875488281
(415) DESCRIBE `ports` 0.0018899440765381
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044107437133789
(417) DESCRIBE `ports` 0.0018661022186279
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039196014404297
(419) DESCRIBE `ports` 0.0019938945770264
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00042200088500977
(421) DESCRIBE `ports` 0.0018050670623779
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00040006637573242
(423) DESCRIBE `ports` 0.0020210742950439
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00042486190795898
(425) DESCRIBE `ports` 0.0022678375244141
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00039792060852051
(427) DESCRIBE `ports` 0.002032995223999
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044894218444824
(429) DESCRIBE `ports` 0.0027000904083252
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00055098533630371
(431) DESCRIBE `avid_specials` 0.0022540092468262
(432) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77809 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.0021860599517822
(433) DESCRIBE `cruiselines` 0.0035660266876221
(434) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00062704086303711
(435) DESCRIBE `orchid_image` 0.0027918815612793
(436) DESCRIBE `cruiselines` 0.0035579204559326
(437) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00054311752319336
(438) DESCRIBE `cruisetypes` 0.0023269653320312
(439) DESCRIBE `destinations` 0.0032789707183838
(440) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.00090408325195312
(441) DESCRIBE `cruiselines` 0.0038020610809326
(442) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00059199333190918
(443) DESCRIBE `ships` 0.0051200389862061
(444) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.00081706047058105
(445) DESCRIBE `cruiselines` 0.0037260055541992
(446) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00059604644775391
(447) DESCRIBE `ships` 0.0048379898071289
(448) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1722))) 0.00085687637329102