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

Total elapsed time: 0.94148206710815

# Query Time
(1) connect 0.0014841556549072
(2) DESCRIBE `cruises` 0.0048110485076904
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (85581, 84878, 85582, 11517, 49093, 82950, 44562, 82478, 68124, 85583)) ORDER BY FIND_IN_SET(id, '85581,84878,85582,11517,49093,82950,44562,82478,68124,85583') 0.0022408962249756
(4) DESCRIBE `cruises` 0.0038259029388428
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '85581') 0.00042319297790527
(6) DESCRIBE `ships` 0.0037209987640381
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 732))) 0.00046610832214355
(8) DESCRIBE `ships` 0.0037808418273926
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '732') 0.00052094459533691
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035285949707031
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034117698669434
(12) DESCRIBE `itineraries` 0.0018980503082275
(13) DESCRIBE `ports` 0.0019290447235107
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00050210952758789
(15) DESCRIBE `ports` 0.0020091533660889
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00042009353637695
(17) DESCRIBE `ports` 0.0022039413452148
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.0004270076751709
(19) DESCRIBE `sailingdates` 0.0016288757324219
(20) DESCRIBE `ports` 0.0021779537200928
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00047397613525391
(22) DESCRIBE `ports` 0.0018429756164551
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00044918060302734
(24) DESCRIBE `ports` 0.0023109912872314
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6150))) 0.00043606758117676
(26) DESCRIBE `ports` 0.0024840831756592
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6150') 0.00038599967956543
(28) DESCRIBE `ports` 0.0018999576568604
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00042104721069336
(30) DESCRIBE `ports` 0.0018038749694824
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00044107437133789
(32) DESCRIBE `ports` 0.0018041133880615
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00037598609924316
(34) DESCRIBE `ports` 0.0023748874664307
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00048303604125977
(36) DESCRIBE `ports` 0.0021381378173828
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00057506561279297
(38) DESCRIBE `ports` 0.0019068717956543
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00039196014404297
(40) DESCRIBE `avid_specials` 0.0019071102142334
(41) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 85581 and class = 'Cruise') OR (item_id = 732 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 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.0011630058288574
(42) DESCRIBE `cruiselines` 0.0027880668640137
(43) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00051307678222656
(44) DESCRIBE `orchid_image` 0.0021648406982422
(45) DESCRIBE `cruiselines` 0.002593994140625
(46) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00038814544677734
(47) DESCRIBE `cruises` 0.0053930282592773
(48) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '84878') 0.0007328987121582
(49) DESCRIBE `ships` 0.0040328502655029
(50) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1294))) 0.0008242130279541
(51) DESCRIBE `ships` 0.0054531097412109
(52) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1294') 0.00072693824768066
(53) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00052309036254883
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00051379203796387
(55) DESCRIBE `itineraries` 0.0027110576629639
(56) DESCRIBE `ports` 0.001939058303833
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4805))) 0.0004420280456543
(58) DESCRIBE `ports` 0.0018620491027832
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4805))) 0.00045990943908691
(60) DESCRIBE `ports` 0.0018501281738281
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4805') 0.0004270076751709
(62) DESCRIBE `sailingdates` 0.0015580654144287
(63) DESCRIBE `ports` 0.0023899078369141
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4805))) 0.00056695938110352
(65) DESCRIBE `ports` 0.0019011497497559
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4805') 0.00042891502380371
(67) DESCRIBE `ports` 0.0020949840545654
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00054287910461426
(69) DESCRIBE `ports` 0.0019431114196777
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.0003960132598877
(71) DESCRIBE `ports` 0.0017819404602051
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4808))) 0.00049304962158203
(73) DESCRIBE `ports` 0.0022108554840088
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4808') 0.00043392181396484
(75) DESCRIBE `ports` 0.0020768642425537
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5539))) 0.00040388107299805
(77) DESCRIBE `ports` 0.0017399787902832
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5539') 0.00037813186645508
(79) DESCRIBE `ports` 0.0018138885498047
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5540))) 0.00060009956359863
(81) DESCRIBE `ports` 0.0025289058685303
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5540') 0.0003969669342041
(83) DESCRIBE `ports` 0.001737117767334
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4481))) 0.00040102005004883
(85) DESCRIBE `ports` 0.001835823059082
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4481') 0.00035786628723145
(87) DESCRIBE `ports` 0.0022799968719482
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4811))) 0.00056791305541992
(89) DESCRIBE `ports` 0.0018320083618164
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4811') 0.00053095817565918
(91) DESCRIBE `ports` 0.0017349720001221
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4812))) 0.00039291381835938
(93) DESCRIBE `ports` 0.0021829605102539
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4812') 0.00066089630126953
(95) DESCRIBE `ports` 0.0027508735656738
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6191))) 0.00064802169799805
(97) DESCRIBE `ports` 0.0026991367340088
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6191') 0.00067782402038574
(99) DESCRIBE `ports` 0.0027730464935303
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4911))) 0.00063800811767578
(101) DESCRIBE `ports` 0.00288987159729
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4911') 0.00059700012207031
(103) DESCRIBE `ports` 0.0028548240661621
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4911))) 0.00063395500183105
(105) DESCRIBE `ports` 0.0027790069580078
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4911') 0.00058317184448242
(107) DESCRIBE `avid_specials` 0.0024521350860596
(108) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 84878 and class = 'Cruise') OR (item_id = 1294 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 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.0022339820861816
(109) DESCRIBE `cruiselines` 0.003957986831665
(110) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00074887275695801
(111) DESCRIBE `orchid_image` 0.0031321048736572
(112) DESCRIBE `cruiselines` 0.0040509700775146
(113) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00062799453735352
(114) DESCRIBE `cruises` 0.0052258968353271
(115) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '85582') 0.00066399574279785
(116) DESCRIBE `ships` 0.0057671070098877
(117) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 732))) 0.00077009201049805
(118) DESCRIBE `ships` 0.0055098533630371
(119) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '732') 0.00061702728271484
(120) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00054001808166504
(121) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00060200691223145
(122) DESCRIBE `itineraries` 0.0026941299438477
(123) DESCRIBE `ports` 0.0027859210968018
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00064206123352051
(125) DESCRIBE `ports` 0.0027260780334473
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.0006248950958252
(127) DESCRIBE `ports` 0.002748966217041
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00060606002807617
(129) DESCRIBE `sailingdates` 0.0024068355560303
(130) DESCRIBE `ports` 0.0032110214233398
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00075197219848633
(132) DESCRIBE `ports` 0.0027508735656738
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00057888031005859
(134) DESCRIBE `ports` 0.0026619434356689
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00061607360839844
(136) DESCRIBE `ports` 0.0027949810028076
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00057291984558105
(138) DESCRIBE `ports` 0.0027599334716797
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00062799453735352
(140) DESCRIBE `ports` 0.0026071071624756
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00047016143798828
(142) DESCRIBE `ports` 0.0022718906402588
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6150))) 0.000518798828125
(144) DESCRIBE `ports` 0.0023229122161865
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6150') 0.00046801567077637
(146) DESCRIBE `ports` 0.0022461414337158
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00042986869812012
(148) DESCRIBE `ports` 0.0019629001617432
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00039196014404297
(150) DESCRIBE `avid_specials` 0.0016810894012451
(151) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 85582 and class = 'Cruise') OR (item_id = 732 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 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.0012860298156738
(152) DESCRIBE `cruiselines` 0.00313401222229
(153) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00066900253295898
(154) DESCRIBE `orchid_image` 0.0033259391784668
(155) DESCRIBE `cruiselines` 0.0038621425628662
(156) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00059604644775391
(157) DESCRIBE `cruises` 0.005241870880127
(158) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '11517') 0.00063204765319824
(159) DESCRIBE `ships` 0.0054728984832764
(160) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 521))) 0.00075101852416992
(161) DESCRIBE `ships` 0.0053451061248779
(162) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '521') 0.00066995620727539
(163) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00052189826965332
(164) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00051283836364746
(165) DESCRIBE `itineraries` 0.0027270317077637
(166) DESCRIBE `ports` 0.0030219554901123
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00069880485534668
(168) DESCRIBE `ports` 0.0029079914093018
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00051689147949219
(170) DESCRIBE `ports` 0.0020589828491211
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00041699409484863
(172) DESCRIBE `sailingdates` 0.0015919208526611
(173) DESCRIBE `ports` 0.0021388530731201
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00053811073303223
(175) DESCRIBE `ports` 0.0027689933776855
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00059390068054199
(177) DESCRIBE `ports` 0.0026500225067139
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00062012672424316
(179) DESCRIBE `ports` 0.0027041435241699
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00056290626525879
(181) DESCRIBE `ports` 0.0027542114257812
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00053787231445312
(183) DESCRIBE `ports` 0.0026850700378418
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00050020217895508
(185) DESCRIBE `ports` 0.0026190280914307
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.00085711479187012
(187) DESCRIBE `ports` 0.0029380321502686
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.00043892860412598
(189) DESCRIBE `ports` 0.0018761157989502
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.00052690505981445
(191) DESCRIBE `ports` 0.0023391246795654
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.00054097175598145
(193) DESCRIBE `ports` 0.0024938583374023
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6151))) 0.00042581558227539
(195) DESCRIBE `ports` 0.0019550323486328
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6151') 0.00047588348388672
(197) DESCRIBE `ports` 0.0025570392608643
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6151))) 0.00053215026855469
(199) DESCRIBE `ports` 0.0026171207427979
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6151') 0.00053191184997559
(201) DESCRIBE `ports` 0.0025207996368408
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00065302848815918
(203) DESCRIBE `ports` 0.0026838779449463
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00065302848815918
(205) DESCRIBE `ports` 0.0027170181274414
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00059199333190918
(207) DESCRIBE `ports` 0.0027298927307129
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00059604644775391
(209) DESCRIBE `ports` 0.0030779838562012
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00072789192199707
(211) DESCRIBE `ports` 0.0032339096069336
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00076603889465332
(213) DESCRIBE `ports` 0.0027921199798584
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.0005791187286377
(215) DESCRIBE `ports` 0.0022130012512207
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00068211555480957
(217) DESCRIBE `ports` 0.0027251243591309
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6150))) 0.00063109397888184
(219) DESCRIBE `ports` 0.0027258396148682
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6150') 0.0005640983581543
(221) DESCRIBE `ports` 0.0025050640106201
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6150))) 0.00048708915710449
(223) DESCRIBE `ports` 0.0018208026885986
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6150') 0.00038003921508789
(225) DESCRIBE `ports` 0.0017650127410889
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00045084953308105
(227) DESCRIBE `ports` 0.0018770694732666
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00038909912109375
(229) DESCRIBE `ports` 0.0019400119781494
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4917))) 0.00042605400085449
(231) DESCRIBE `ports` 0.0019049644470215
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4917') 0.00049901008605957
(233) DESCRIBE `ports` 0.0024478435516357
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00039982795715332
(235) DESCRIBE `ports` 0.00223708152771
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00042605400085449
(237) DESCRIBE `ports` 0.0018670558929443
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.0003819465637207
(239) DESCRIBE `ports` 0.0019760131835938
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00035810470581055
(241) DESCRIBE `ports` 0.0021259784698486
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00040888786315918
(243) DESCRIBE `ports` 0.0017960071563721
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00054287910461426
(245) DESCRIBE `avid_specials` 0.0015561580657959
(246) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 11517 and class = 'Cruise') OR (item_id = 521 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 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.0013890266418457
(247) DESCRIBE `cruiselines` 0.0026731491088867
(248) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00050806999206543
(249) DESCRIBE `orchid_image` 0.002345085144043
(250) DESCRIBE `cruiselines` 0.0036640167236328
(251) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00048708915710449
(252) DESCRIBE `cruises` 0.004626989364624
(253) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '49093') 0.0005338191986084
(254) DESCRIBE `ships` 0.0049951076507568
(255) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 701))) 0.00072216987609863
(256) DESCRIBE `ships` 0.004364013671875
(257) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '701') 0.0005640983581543
(258) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00041890144348145
(259) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00040292739868164
(260) DESCRIBE `itineraries` 0.002000093460083
(261) DESCRIBE `ports` 0.0019581317901611
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00043916702270508
(263) DESCRIBE `ports` 0.0019629001617432
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00038909912109375
(265) DESCRIBE `ports` 0.0019431114196777
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00042200088500977
(267) DESCRIBE `sailingdates` 0.001622200012207
(268) DESCRIBE `ports` 0.0021018981933594
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00042915344238281
(270) DESCRIBE `ports` 0.0018980503082275
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00038886070251465
(272) DESCRIBE `ports` 0.0019240379333496
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00043892860412598
(274) DESCRIBE `ports` 0.0018289089202881
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00046300888061523
(276) DESCRIBE `ports` 0.0023159980773926
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4533))) 0.00052404403686523
(278) DESCRIBE `ports` 0.0028622150421143
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4533') 0.00040292739868164
(280) DESCRIBE `ports` 0.0018520355224609
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5553))) 0.00049304962158203
(282) DESCRIBE `ports` 0.0020999908447266
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5553') 0.00051403045654297
(284) DESCRIBE `ports` 0.0019140243530273
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.0004119873046875
(286) DESCRIBE `ports` 0.0025742053985596
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0.00048518180847168
(288) DESCRIBE `ports` 0.0020320415496826
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3165))) 0.00040197372436523
(290) DESCRIBE `ports` 0.0017719268798828
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3165') 0.00037217140197754
(292) DESCRIBE `ports` 0.0017480850219727
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3632))) 0.00043916702270508
(294) DESCRIBE `ports` 0.0018479824066162
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3632') 0.00039505958557129
(296) DESCRIBE `ports` 0.0020260810852051
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00056314468383789
(298) DESCRIBE `ports` 0.0020890235900879
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00054287910461426
(300) DESCRIBE `avid_specials` 0.0019900798797607
(301) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 49093 and class = 'Cruise') OR (item_id = 701 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 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.0012128353118896
(302) DESCRIBE `cruiselines` 0.0027370452880859
(303) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.0004429817199707
(304) DESCRIBE `orchid_image` 0.0020148754119873
(305) DESCRIBE `cruiselines` 0.002932071685791
(306) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00045990943908691
(307) DESCRIBE `cruises` 0.0036418437957764
(308) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82950') 0.0004429817199707
(309) DESCRIBE `ships` 0.0043458938598633
(310) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 701))) 0.00062298774719238
(311) DESCRIBE `ships` 0.0052309036254883
(312) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '701') 0.00057005882263184
(313) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00049495697021484
(314) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00041389465332031
(315) DESCRIBE `itineraries` 0.0020341873168945
(316) DESCRIBE `ports` 0.0018229484558105
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00060606002807617
(318) DESCRIBE `ports` 0.0023479461669922
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00042414665222168
(320) DESCRIBE `ports` 0.0018301010131836
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00038814544677734
(322) DESCRIBE `sailingdates` 0.0016891956329346
(323) DESCRIBE `ports` 0.0018730163574219
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00042891502380371
(325) DESCRIBE `ports` 0.0017459392547607
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00037908554077148
(327) DESCRIBE `ports` 0.0019490718841553
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3162))) 0.00042414665222168
(329) DESCRIBE `ports` 0.0018980503082275
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3162') 0.00037193298339844
(331) DESCRIBE `ports` 0.0018558502197266
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4533))) 0.00048089027404785
(333) DESCRIBE `ports` 0.0017848014831543
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4533') 0.00041294097900391
(335) DESCRIBE `ports` 0.0018599033355713
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5553))) 0.00052499771118164
(337) DESCRIBE `ports` 0.0018370151519775
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5553') 0.00041103363037109
(339) DESCRIBE `ports` 0.0018799304962158
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3163))) 0.00040411949157715
(341) DESCRIBE `ports` 0.0019419193267822
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3163') 0.00052881240844727
(343) DESCRIBE `ports` 0.002032995223999
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3165))) 0.00051999092102051
(345) DESCRIBE `ports` 0.0020709037780762
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3165') 0.0004889965057373
(347) DESCRIBE `ports` 0.0019590854644775
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3632))) 0.00046992301940918
(349) DESCRIBE `ports` 0.0018520355224609
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3632') 0.00040006637573242
(351) DESCRIBE `ports` 0.0019547939300537
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2696))) 0.00055098533630371
(353) DESCRIBE `ports` 0.0022110939025879
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2696') 0.00049901008605957
(355) DESCRIBE `avid_specials` 0.0016741752624512
(356) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82950 and class = 'Cruise') OR (item_id = 701 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 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.0016148090362549
(357) DESCRIBE `cruiselines` 0.0034539699554443
(358) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00059008598327637
(359) DESCRIBE `orchid_image` 0.0027258396148682
(360) DESCRIBE `cruiselines` 0.0028929710388184
(361) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00045514106750488
(362) DESCRIBE `cruises` 0.0036969184875488
(363) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '44562') 0.00046300888061523
(364) DESCRIBE `ships` 0.0035970211029053
(365) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 521))) 0.00049114227294922
(366) DESCRIBE `ships` 0.0036571025848389
(367) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '521') 0.00041508674621582
(368) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036001205444336
(369) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034999847412109
(370) DESCRIBE `itineraries` 0.0019102096557617
(371) DESCRIBE `ports` 0.0018379688262939
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00042915344238281
(373) DESCRIBE `ports` 0.001978874206543
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00039792060852051
(375) DESCRIBE `ports` 0.0020191669464111
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00037789344787598
(377) DESCRIBE `sailingdates` 0.0017309188842773
(378) DESCRIBE `ports` 0.0020401477813721
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00044393539428711
(380) DESCRIBE `ports` 0.0019700527191162
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00049400329589844
(382) DESCRIBE `ports` 0.002000093460083
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00060486793518066
(384) DESCRIBE `ports` 0.0022969245910645
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00044798851013184
(386) DESCRIBE `ports` 0.0019450187683105
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3488))) 0.00051784515380859
(388) DESCRIBE `ports` 0.0018248558044434
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3488') 0.00037717819213867
(390) DESCRIBE `ports` 0.0019259452819824
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6151))) 0.00055193901062012
(392) DESCRIBE `ports` 0.0023398399353027
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6151') 0.00040292739868164
(394) DESCRIBE `ports` 0.0019059181213379
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00058603286743164
(396) DESCRIBE `ports` 0.0018818378448486
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00055909156799316
(398) DESCRIBE `avid_specials` 0.0016169548034668
(399) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 44562 and class = 'Cruise') OR (item_id = 521 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 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.0013079643249512
(400) DESCRIBE `cruiselines` 0.0026259422302246
(401) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00050497055053711
(402) DESCRIBE `orchid_image` 0.0023889541625977
(403) DESCRIBE `cruiselines` 0.0026359558105469
(404) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00051593780517578
(405) DESCRIBE `cruises` 0.0045559406280518
(406) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '82478') 0.00062203407287598
(407) DESCRIBE `ships` 0.0042119026184082
(408) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 993))) 0.00047397613525391
(409) DESCRIBE `ships` 0.0035569667816162
(410) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '993') 0.00037193298339844
(411) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00037598609924316
(412) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00042390823364258
(413) DESCRIBE `itineraries` 0.0022120475769043
(414) DESCRIBE `ports` 0.0021989345550537
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4729))) 0.00051689147949219
(416) DESCRIBE `ports` 0.0018479824066162
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4729))) 0.00045680999755859
(418) DESCRIBE `ports` 0.0019559860229492
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4729') 0.0004889965057373
(420) DESCRIBE `sailingdates` 0.0019600391387939
(421) DESCRIBE `ports` 0.0021271705627441
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4729))) 0.0005190372467041
(423) DESCRIBE `ports` 0.0018680095672607
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4729') 0.00046300888061523
(425) DESCRIBE `ports` 0.0018570423126221
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4729))) 0.00043201446533203
(427) DESCRIBE `ports` 0.0021941661834717
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4729') 0.00045585632324219
(429) DESCRIBE `ports` 0.0023581981658936
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3778))) 0.00057482719421387
(431) DESCRIBE `ports` 0.0028181076049805
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3778') 0.00057697296142578
(433) DESCRIBE `ports` 0.0028538703918457
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6149))) 0.00060606002807617
(435) DESCRIBE `ports` 0.0027849674224854
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6149') 0.00056600570678711
(437) DESCRIBE `ports` 0.0023322105407715
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6148))) 0.00043892860412598
(439) DESCRIBE `ports` 0.0023179054260254
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6148') 0.00055599212646484
(441) DESCRIBE `ports` 0.002068042755127
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3623))) 0.0004727840423584
(443) DESCRIBE `ports` 0.0018298625946045
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3623') 0.0003960132598877
(445) DESCRIBE `ports` 0.001884937286377
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5250))) 0.00051307678222656
(447) DESCRIBE `ports` 0.0018479824066162
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5250') 0.00042200088500977
(449) DESCRIBE `ports` 0.0020220279693604
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3620))) 0.00046300888061523
(451) DESCRIBE `ports` 0.0020420551300049
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3620') 0.00047898292541504
(453) DESCRIBE `ports` 0.0025520324707031
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4725))) 0.00061798095703125
(455) DESCRIBE `ports` 0.0019559860229492
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4725') 0.00042009353637695
(457) DESCRIBE `ports` 0.0018010139465332
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4724))) 0.00042200088500977
(459) DESCRIBE `ports` 0.0018279552459717
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4724') 0.00041103363037109
(461) DESCRIBE `ports` 0.0019538402557373
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4722))) 0.00040006637573242
(463) DESCRIBE `ports` 0.0019168853759766
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4722') 0.00039982795715332
(465) DESCRIBE `ports` 0.0020170211791992
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4721))) 0.00055217742919922
(467) DESCRIBE `ports` 0.0020179748535156
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4721') 0.00042414665222168
(469) DESCRIBE `ports` 0.002249002456665
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4720))) 0.00074219703674316
(471) DESCRIBE `ports` 0.0024130344390869
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4720') 0.0004878044128418
(473) DESCRIBE `ports` 0.001777172088623
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4719))) 0.00042986869812012
(475) DESCRIBE `ports` 0.0019228458404541
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4719') 0.00038409233093262
(477) DESCRIBE `ports` 0.0018079280853271
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3613))) 0.00042891502380371
(479) DESCRIBE `ports` 0.0017821788787842
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3613') 0.00036501884460449
(481) DESCRIBE `ports` 0.0017509460449219
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4718))) 0.00042295455932617
(483) DESCRIBE `ports` 0.0018470287322998
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4718') 0.00040793418884277
(485) DESCRIBE `ports` 0.0021038055419922
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4718))) 0.00063300132751465
(487) DESCRIBE `ports` 0.0023078918457031
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4718') 0.00044894218444824
(489) DESCRIBE `avid_specials` 0.0016591548919678
(490) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 82478 and class = 'Cruise') OR (item_id = 993 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 56 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.0011720657348633
(491) DESCRIBE `cruiselines` 0.0030770301818848
(492) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00043892860412598
(493) DESCRIBE `orchid_image` 0.0023119449615479
(494) DESCRIBE `cruiselines` 0.0029280185699463
(495) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00050997734069824
(496) DESCRIBE `cruises` 0.0050489902496338
(497) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68124') 0.00057792663574219
(498) DESCRIBE `ships` 0.0037429332733154
(499) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1241))) 0.00065517425537109
(500) DESCRIBE `ships` 0.0041301250457764
(501) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1241') 0.00072383880615234
(502) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034999847412109
(503) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036501884460449
(504) DESCRIBE `itineraries` 0.0019621849060059
(505) DESCRIBE `ports` 0.0027508735656738
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3177))) 0.00062108039855957
(507) DESCRIBE `ports` 0.0026071071624756
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3177))) 0.00063610076904297
(509) DESCRIBE `ports` 0.0017809867858887
(510) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3177') 0.0004119873046875
(511) DESCRIBE `sailingdates` 0.0017349720001221
(512) DESCRIBE `ports` 0.0018520355224609
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3177))) 0.00044894218444824
(514) DESCRIBE `ports` 0.0022830963134766
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3177') 0.00053811073303223
(516) DESCRIBE `ports` 0.0021460056304932
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3173))) 0.00044083595275879
(518) DESCRIBE `ports` 0.0020639896392822
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3173') 0.00043416023254395
(520) DESCRIBE `ports` 0.0018720626831055
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3173))) 0.00050902366638184
(522) DESCRIBE `ports` 0.0018510818481445
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3173') 0.00040411949157715
(524) DESCRIBE `ports` 0.0018889904022217
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3172))) 0.00050497055053711
(526) DESCRIBE `ports` 0.0019800662994385
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3172') 0.00047802925109863
(528) DESCRIBE `ports` 0.0025720596313477
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3171))) 0.00065994262695312
(530) DESCRIBE `ports` 0.0022711753845215
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3171') 0.00055193901062012
(532) DESCRIBE `ports` 0.0028231143951416
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3171))) 0.0007328987121582
(534) DESCRIBE `ports` 0.0025379657745361
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3171') 0.00049304962158203
(536) DESCRIBE `ports` 0.0019700527191162
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3171))) 0.0005650520324707
(538) DESCRIBE `ports` 0.0023989677429199
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3171') 0.00068306922912598
(540) DESCRIBE `ports` 0.0025420188903809
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3171))) 0.00056600570678711
(542) DESCRIBE `ports` 0.0023379325866699
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3171') 0.00066685676574707
(544) DESCRIBE `avid_specials` 0.0019738674163818
(545) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68124 and class = 'Cruise') OR (item_id = 1241 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 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.0017380714416504
(546) DESCRIBE `cruiselines` 0.0033440589904785
(547) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00084400177001953
(548) DESCRIBE `orchid_image` 0.0027830600738525
(549) DESCRIBE `cruiselines` 0.0040271282196045
(550) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00078892707824707
(551) DESCRIBE `cruises` 0.0046780109405518
(552) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '85583') 0.00048303604125977
(553) DESCRIBE `ships` 0.0038599967956543
(554) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1240))) 0.00070405006408691
(555) DESCRIBE `ships` 0.0039069652557373
(556) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1240') 0.00054788589477539
(557) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00041699409484863
(558) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035285949707031
(559) DESCRIBE `itineraries` 0.0020058155059814
(560) DESCRIBE `ports` 0.0022628307342529
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4718))) 0.00053286552429199
(562) DESCRIBE `ports` 0.0021729469299316
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4718))) 0.00043892860412598
(564) DESCRIBE `ports` 0.0018939971923828
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4718') 0.00042986869812012
(566) DESCRIBE `sailingdates` 0.0015838146209717
(567) DESCRIBE `ports` 0.0019800662994385
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4718))) 0.00063490867614746
(569) DESCRIBE `ports` 0.0020010471343994
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4718') 0.0004279613494873
(571) DESCRIBE `ports` 0.0018560886383057
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5254))) 0.0005950927734375
(573) DESCRIBE `ports` 0.0021920204162598
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5254') 0.00044584274291992
(575) DESCRIBE `ports` 0.0018260478973389
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4719))) 0.00057291984558105
(577) DESCRIBE `ports` 0.0021510124206543
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4719') 0.0004878044128418
(579) DESCRIBE `ports` 0.0019009113311768
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4720))) 0.0004580020904541
(581) DESCRIBE `ports` 0.0017979145050049
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4720') 0.00040698051452637
(583) DESCRIBE `ports` 0.0020480155944824
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4721))) 0.00047898292541504
(585) DESCRIBE `ports` 0.0020639896392822
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4721') 0.00045895576477051
(587) DESCRIBE `ports` 0.0019519329071045
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5255))) 0.0004580020904541
(589) DESCRIBE `ports` 0.0017881393432617
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5255') 0.00046205520629883
(591) DESCRIBE `ports` 0.0018079280853271
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4874))) 0.0004889965057373
(593) DESCRIBE `ports` 0.0018160343170166
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4874') 0.00041413307189941
(595) DESCRIBE `ports` 0.0019509792327881
(596) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3613))) 0.00044393539428711
(597) DESCRIBE `ports` 0.0023419857025146
(598) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3613') 0.00047492980957031
(599) DESCRIBE `ports` 0.0023949146270752
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4718))) 0.00066614151000977
(601) DESCRIBE `ports` 0.0019409656524658
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4718') 0.00041985511779785
(603) DESCRIBE `avid_specials` 0.0016169548034668
(604) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 85583 and class = 'Cruise') OR (item_id = 1240 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 56 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.00118088722229
(605) DESCRIBE `cruiselines` 0.003040075302124
(606) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00044107437133789
(607) DESCRIBE `orchid_image` 0.0020840167999268
(608) DESCRIBE `cruiselines` 0.0025749206542969
(609) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00039100646972656
(610) DESCRIBE `ships` 0.0046801567077637
(611) SELECT `ships`.* FROM `ships` WHERE (id IN ('732', '521', '520', '627', '1140', '701', '1519', '1294', '1664', '1240', '1829', '1241', '1242', '1346', '993', '1243')) ORDER BY FIND_IN_SET(id, '732,521,520,627,1140,701,1519,1294,1664,1240,1829,1241,1242,1346,993,1243') 0.0025768280029297
(612) DESCRIBE `cruisetypes` 0.0019190311431885
(613) DESCRIBE `destinations` 0.0024831295013428
(614) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('54', '56')) ORDER BY FIND_IN_SET(id, '54,56') 0.00071501731872559
(615) DESCRIBE `cruiselines` 0.0027580261230469
(616) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00050616264343262
(617) DESCRIBE `cruiselines` 0.0028111934661865
(618) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00047707557678223