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

Total elapsed time: 1.56680727005

# Query Time
(1) connect 0.0017020702362061
(2) DESCRIBE `cruises` 0.008167028427124
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (76406, 61411, 76353, 72818, 76352, 61419, 76401, 61420, 76215, 84402)) ORDER BY FIND_IN_SET(id, '76406,61411,76353,72818,76352,61419,76401,61420,76215,84402') 0.0028409957885742
(4) DESCRIBE `cruises` 0.004951000213623
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76406') 0.00074601173400879
(6) DESCRIBE `ships` 0.0050880908966064
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.00079584121704102
(8) DESCRIBE `ships` 0.0050919055938721
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.00059914588928223
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00050783157348633
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00049901008605957
(12) DESCRIBE `itineraries` 0.0029261112213135
(13) DESCRIBE `ports` 0.0020570755004883
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00045895576477051
(15) DESCRIBE `ports` 0.0021970272064209
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00048184394836426
(17) DESCRIBE `ports` 0.0019350051879883
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00044393539428711
(19) DESCRIBE `sailingdates` 0.0019519329071045
(20) DESCRIBE `ports` 0.0020110607147217
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0004880428314209
(22) DESCRIBE `ports` 0.0019662380218506
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00046706199645996
(24) DESCRIBE `ports` 0.0020389556884766
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00045609474182129
(26) DESCRIBE `ports` 0.0025808811187744
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.0004270076751709
(28) DESCRIBE `ports` 0.0022339820861816
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00043392181396484
(30) DESCRIBE `ports` 0.002108097076416
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00039291381835938
(32) DESCRIBE `ports` 0.002011775970459
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00054311752319336
(34) DESCRIBE `ports` 0.0030899047851562
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00044012069702148
(36) DESCRIBE `ports` 0.002877950668335
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1637))) 0.00042104721069336
(38) DESCRIBE `ports` 0.0020241737365723
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1637') 0.00051689147949219
(40) DESCRIBE `ports` 0.0028400421142578
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.00054121017456055
(42) DESCRIBE `ports` 0.003371000289917
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.00059294700622559
(44) DESCRIBE `ports` 0.0028798580169678
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2863))) 0.00060296058654785
(46) DESCRIBE `ports` 0.003385066986084
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2863') 0.00057005882263184
(48) DESCRIBE `ports` 0.0037190914154053
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.00056004524230957
(50) DESCRIBE `ports` 0.0032448768615723
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.00053191184997559
(52) DESCRIBE `ports` 0.0034370422363281
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2131))) 0.00047588348388672
(54) DESCRIBE `ports` 0.0027477741241455
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2131') 0.00043106079101562
(56) DESCRIBE `ports` 0.0025467872619629
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.0004119873046875
(58) DESCRIBE `ports` 0.0024738311767578
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.0004420280456543
(60) DESCRIBE `ports` 0.0020959377288818
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00046396255493164
(62) DESCRIBE `ports` 0.0020968914031982
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00039410591125488
(64) DESCRIBE `ports` 0.001863956451416
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00048685073852539
(66) DESCRIBE `ports` 0.0020818710327148
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00050497055053711
(68) DESCRIBE `ports` 0.002065896987915
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2129))) 0.00041079521179199
(70) DESCRIBE `ports` 0.0025370121002197
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2129') 0.00038504600524902
(72) DESCRIBE `ports` 0.002086877822876
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 331))) 0.00047898292541504
(74) DESCRIBE `ports` 0.0027511119842529
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '331') 0.00044393539428711
(76) DESCRIBE `ports` 0.002363920211792
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00060582160949707
(78) DESCRIBE `ports` 0.003007173538208
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00057697296142578
(80) DESCRIBE `ports` 0.0030620098114014
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2224))) 0.00057888031005859
(82) DESCRIBE `ports` 0.0025830268859863
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2224') 0.00069308280944824
(84) DESCRIBE `ports` 0.0025789737701416
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1655))) 0.00063109397888184
(86) DESCRIBE `ports` 0.0027990341186523
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1655') 0.00060296058654785
(88) DESCRIBE `ports` 0.0037062168121338
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00056004524230957
(90) DESCRIBE `ports` 0.0034530162811279
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00066900253295898
(92) DESCRIBE `avid_specials` 0.0021669864654541
(93) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76406 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 48 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.0015659332275391
(94) DESCRIBE `cruiselines` 0.0037658214569092
(95) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00062298774719238
(96) DESCRIBE `orchid_image` 0.0029199123382568
(97) DESCRIBE `cruiselines` 0.015105009078979
(98) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00050115585327148
(99) DESCRIBE `cruises` 0.0047669410705566
(100) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61411') 0.0070798397064209
(101) DESCRIBE `ships` 0.0046751499176025
(102) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1319))) 0.00098800659179688
(103) DESCRIBE `ships` 0.0097219944000244
(104) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1319') 0.00055599212646484
(105) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003819465637207
(106) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035786628723145
(107) DESCRIBE `itineraries` 0.0032801628112793
(108) DESCRIBE `ports` 0.0024030208587646
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00054788589477539
(110) DESCRIBE `ports` 0.0047738552093506
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00073409080505371
(112) DESCRIBE `ports` 0.0057809352874756
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00048208236694336
(114) DESCRIBE `sailingdates` 0.010207176208496
(115) DESCRIBE `ports` 0.0021960735321045
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00049400329589844
(117) DESCRIBE `ports` 0.0019128322601318
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00055980682373047
(119) DESCRIBE `ports` 0.0018978118896484
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00045013427734375
(121) DESCRIBE `ports` 0.0088241100311279
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.0005650520324707
(123) DESCRIBE `ports` 0.0022449493408203
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00061988830566406
(125) DESCRIBE `ports` 0.0022819042205811
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.0004880428314209
(127) DESCRIBE `ports` 0.0098190307617188
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.000640869140625
(129) DESCRIBE `ports` 0.0031330585479736
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00043201446533203
(131) DESCRIBE `ports` 0.010689973831177
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1637))) 0.00054788589477539
(133) DESCRIBE `ports` 0.0026710033416748
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1637') 0.00045680999755859
(135) DESCRIBE `ports` 0.0021309852600098
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.00049805641174316
(137) DESCRIBE `ports` 0.0023410320281982
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.0079917907714844
(139) DESCRIBE `ports` 0.0034348964691162
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2863))) 0.00061607360839844
(141) DESCRIBE `ports` 0.0032539367675781
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2863') 0.00055098533630371
(143) DESCRIBE `ports` 0.010075092315674
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.0004270076751709
(145) DESCRIBE `ports` 0.0021331310272217
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.00038385391235352
(147) DESCRIBE `ports` 0.0029609203338623
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2131))) 0.00046706199645996
(149) DESCRIBE `ports` 0.003593921661377
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2131') 0.009343147277832
(151) DESCRIBE `ports` 0.0030560493469238
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00066184997558594
(153) DESCRIBE `ports` 0.0028820037841797
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00058698654174805
(155) DESCRIBE `ports` 0.010995864868164
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00067591667175293
(157) DESCRIBE `ports` 0.0029759407043457
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.0005650520324707
(159) DESCRIBE `ports` 0.0037088394165039
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00064206123352051
(161) DESCRIBE `ports` 0.012416124343872
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00063705444335938
(163) DESCRIBE `avid_specials` 0.0028338432312012
(164) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61411 and class = 'Cruise') OR (item_id = 1319 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 48 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.0023050308227539
(165) DESCRIBE `cruiselines` 0.012569904327393
(166) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00064587593078613
(167) DESCRIBE `orchid_image` 0.0031461715698242
(168) DESCRIBE `cruiselines` 0.0038549900054932
(169) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00037503242492676
(170) DESCRIBE `cruises` 0.003497838973999
(171) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76353') 0.0004279613494873
(172) DESCRIBE `ships` 0.0036799907684326
(173) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.00049495697021484
(174) DESCRIBE `ships` 0.0036220550537109
(175) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.00036311149597168
(176) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037789344787598
(177) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003509521484375
(178) DESCRIBE `itineraries` 0.0024228096008301
(179) DESCRIBE `ports` 0.0024218559265137
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00050902366638184
(181) DESCRIBE `ports` 0.0018839836120605
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00054812431335449
(183) DESCRIBE `ports` 0.0023598670959473
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00052094459533691
(185) DESCRIBE `sailingdates` 0.0018999576568604
(186) DESCRIBE `ports` 0.0025460720062256
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00042486190795898
(188) DESCRIBE `ports` 0.0018420219421387
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00037384033203125
(190) DESCRIBE `ports` 0.0019099712371826
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 598))) 0.00042605400085449
(192) DESCRIBE `ports` 0.00187087059021
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '598') 0.0003960132598877
(194) DESCRIBE `ports` 0.001878023147583
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 601))) 0.00055098533630371
(196) DESCRIBE `ports` 0.0024600028991699
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '601') 0.00049495697021484
(198) DESCRIBE `ports` 0.0025010108947754
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 705))) 0.00038695335388184
(200) DESCRIBE `ports` 0.0018789768218994
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '705') 0.00036716461181641
(202) DESCRIBE `ports` 0.0018990039825439
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 321))) 0.0004279613494873
(204) DESCRIBE `ports` 0.0020120143890381
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '321') 0.00044989585876465
(206) DESCRIBE `ports` 0.0025839805603027
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00052189826965332
(208) DESCRIBE `ports` 0.0025520324707031
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00038695335388184
(210) DESCRIBE `ports` 0.0019621849060059
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00047397613525391
(212) DESCRIBE `ports` 0.0019180774688721
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00052094459533691
(214) DESCRIBE `ports` 0.0024330615997314
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00044703483581543
(216) DESCRIBE `ports` 0.0021531581878662
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00038695335388184
(218) DESCRIBE `ports` 0.0036721229553223
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 770))) 0.00081610679626465
(220) DESCRIBE `ports` 0.0025360584259033
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '770') 0.00061893463134766
(222) DESCRIBE `ports` 0.0025532245635986
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2470))) 0.00052785873413086
(224) DESCRIBE `ports` 0.0023720264434814
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2470') 0.00049304962158203
(226) DESCRIBE `ports` 0.0026650428771973
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1873))) 0.00058102607727051
(228) DESCRIBE `ports` 0.0024881362915039
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1873') 0.00056314468383789
(230) DESCRIBE `ports` 0.0024089813232422
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00055813789367676
(232) DESCRIBE `ports` 0.0026209354400635
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00054812431335449
(234) DESCRIBE `ports` 0.0029239654541016
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1743))) 0.00053787231445312
(236) DESCRIBE `ports` 0.0028789043426514
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1743') 0.00049901008605957
(238) DESCRIBE `ports` 0.0024268627166748
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1780))) 0.00051593780517578
(240) DESCRIBE `ports` 0.0025360584259033
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1780') 0.00042319297790527
(242) DESCRIBE `ports` 0.0020711421966553
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1150))) 0.00041699409484863
(244) DESCRIBE `ports` 0.0019559860229492
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1150') 0.00039005279541016
(246) DESCRIBE `ports` 0.0022890567779541
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00041007995605469
(248) DESCRIBE `ports` 0.0019738674163818
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00038599967956543
(250) DESCRIBE `ports` 0.0022931098937988
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00061702728271484
(252) DESCRIBE `ports` 0.0023980140686035
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00041294097900391
(254) DESCRIBE `ports` 0.0020561218261719
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00040602684020996
(256) DESCRIBE `ports` 0.0024821758270264
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00040602684020996
(258) DESCRIBE `avid_specials` 0.0026650428771973
(259) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76353 and class = 'Cruise') OR (item_id = 850 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 38 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013439655303955
(260) DESCRIBE `cruiselines` 0.0026731491088867
(261) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00057315826416016
(262) DESCRIBE `orchid_image` 0.0022869110107422
(263) DESCRIBE `cruiselines` 0.0029418468475342
(264) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00042295455932617
(265) DESCRIBE `cruises` 0.0036439895629883
(266) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72818') 0.00043201446533203
(267) DESCRIBE `ships` 0.0037910938262939
(268) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1108))) 0.00047802925109863
(269) DESCRIBE `ships` 0.0036830902099609
(270) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1108') 0.00038504600524902
(271) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003669261932373
(272) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00038814544677734
(273) DESCRIBE `itineraries` 0.0019018650054932
(274) DESCRIBE `ports` 0.002018928527832
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00047111511230469
(276) DESCRIBE `ports` 0.0018739700317383
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046396255493164
(278) DESCRIBE `ports` 0.0019159317016602
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00039911270141602
(280) DESCRIBE `sailingdates` 0.0016429424285889
(281) DESCRIBE `ports` 0.002208948135376
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00047087669372559
(283) DESCRIBE `ports` 0.0034220218658447
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00065016746520996
(285) DESCRIBE `ports` 0.0023009777069092
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00055599212646484
(287) DESCRIBE `ports` 0.0023739337921143
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00044107437133789
(289) DESCRIBE `ports` 0.002086877822876
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00046086311340332
(291) DESCRIBE `ports` 0.0020627975463867
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00043201446533203
(293) DESCRIBE `ports` 0.0028948783874512
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 55))) 0.00042414665222168
(295) DESCRIBE `ports` 0.0025289058685303
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '55') 0.00040411949157715
(297) DESCRIBE `ports` 0.0030040740966797
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00053906440734863
(299) DESCRIBE `ports` 0.0025069713592529
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00050902366638184
(301) DESCRIBE `ports` 0.0022919178009033
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 310))) 0.00049996376037598
(303) DESCRIBE `ports` 0.0023400783538818
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '310') 0.00047707557678223
(305) DESCRIBE `ports` 0.0039560794830322
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 311))) 0.0007319450378418
(307) DESCRIBE `ports` 0.0032930374145508
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '311') 0.00063800811767578
(309) DESCRIBE `ports` 0.0025980472564697
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 312))) 0.00045299530029297
(311) DESCRIBE `ports` 0.0018699169158936
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '312') 0.00051498413085938
(313) DESCRIBE `ports` 0.0019381046295166
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 312))) 0.00043606758117676
(315) DESCRIBE `ports` 0.0021181106567383
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '312') 0.00039982795715332
(317) DESCRIBE `ports` 0.0026278495788574
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3686))) 0.00043392181396484
(319) DESCRIBE `ports` 0.0020318031311035
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3686') 0.00055909156799316
(321) DESCRIBE `ports` 0.0027570724487305
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 672))) 0.00061988830566406
(323) DESCRIBE `ports` 0.0023300647735596
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '672') 0.00050997734069824
(325) DESCRIBE `ports` 0.0023050308227539
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00056195259094238
(327) DESCRIBE `ports` 0.0024840831756592
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00051188468933105
(329) DESCRIBE `ports` 0.0030419826507568
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2286))) 0.00065302848815918
(331) DESCRIBE `ports` 0.0025391578674316
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2286') 0.00060915946960449
(333) DESCRIBE `ports` 0.0024628639221191
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00070405006408691
(335) DESCRIBE `ports` 0.002608060836792
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00044512748718262
(337) DESCRIBE `ports` 0.0064589977264404
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00052189826965332
(339) DESCRIBE `ports` 0.0059030055999756
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00049090385437012
(341) DESCRIBE `ports` 0.0037238597869873
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0008089542388916
(343) DESCRIBE `ports` 0.004223108291626
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00040197372436523
(345) DESCRIBE `ports` 0.0019149780273438
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4467))) 0.00071907043457031
(347) DESCRIBE `ports` 0.0026290416717529
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4467') 0.00037789344787598
(349) DESCRIBE `ports` 0.0019819736480713
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00043892860412598
(351) DESCRIBE `ports` 0.001863956451416
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00039887428283691
(353) DESCRIBE `avid_specials` 0.0016658306121826
(354) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72818 and class = 'Cruise') OR (item_id = 1108 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 55 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.0015578269958496
(355) DESCRIBE `cruiselines` 0.0032660961151123
(356) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00042605400085449
(357) DESCRIBE `orchid_image` 0.0021750926971436
(358) DESCRIBE `cruiselines` 0.0028278827667236
(359) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00043797492980957
(360) DESCRIBE `cruises` 0.0035569667816162
(361) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76352') 0.0088520050048828
(362) DESCRIBE `ships` 0.003882884979248
(363) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 850))) 0.0021958351135254
(364) DESCRIBE `ships` 0.0038912296295166
(365) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '850') 0.0021860599517822
(366) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00082087516784668
(367) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035190582275391
(368) DESCRIBE `itineraries` 0.0020411014556885
(369) DESCRIBE `ports` 0.010150909423828
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0005338191986084
(371) DESCRIBE `ports` 0.0019769668579102
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00040006637573242
(373) DESCRIBE `ports` 0.0021991729736328
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0004119873046875
(375) DESCRIBE `sailingdates` 0.0016829967498779
(376) DESCRIBE `ports` 0.010528087615967
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00041413307189941
(378) DESCRIBE `ports` 0.002579927444458
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00037002563476562
(380) DESCRIBE `ports` 0.0018281936645508
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 598))) 0.00039982795715332
(382) DESCRIBE `ports` 0.00177001953125
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '598') 0.00042605400085449
(384) DESCRIBE `ports` 0.010084867477417
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 601))) 0.00064992904663086
(386) DESCRIBE `ports` 0.0022261142730713
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '601') 0.00043106079101562
(388) DESCRIBE `ports` 0.0019090175628662
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 705))) 0.00046205520629883
(390) DESCRIBE `ports` 0.011445999145508
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '705') 0.00049304962158203
(392) DESCRIBE `ports` 0.0021200180053711
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 321))) 0.00063800811767578
(394) DESCRIBE `ports` 0.0098659992218018
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '321') 0.00064301490783691
(396) DESCRIBE `ports` 0.0035879611968994
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00066804885864258
(398) DESCRIBE `ports` 0.010681867599487
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00052785873413086
(400) DESCRIBE `ports` 0.0030770301818848
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00059294700622559
(402) DESCRIBE `ports` 0.002194881439209
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00080013275146484
(404) DESCRIBE `avid_specials` 0.0030291080474854
(405) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76352 and class = 'Cruise') OR (item_id = 850 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 38 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.01000714302063
(406) DESCRIBE `cruiselines` 0.0038459300994873
(407) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00048708915710449
(408) DESCRIBE `orchid_image` 0.0020740032196045
(409) DESCRIBE `cruiselines` 0.0026531219482422
(410) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.006511926651001
(411) DESCRIBE `cruises` 0.0035779476165771
(412) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61419') 0.0067028999328613
(413) DESCRIBE `ships` 0.0054409503936768
(414) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.00075602531433105
(415) DESCRIBE `ships` 0.011314153671265
(416) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.00045180320739746
(417) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00052309036254883
(418) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00038599967956543
(419) DESCRIBE `itineraries` 0.0020880699157715
(420) DESCRIBE `ports` 0.010459899902344
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00052499771118164
(422) DESCRIBE `ports` 0.0027170181274414
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0081801414489746
(424) DESCRIBE `ports` 0.0027749538421631
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00043082237243652
(426) DESCRIBE `sailingdates` 0.0024759769439697
(427) DESCRIBE `ports` 0.0023930072784424
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0057990550994873
(429) DESCRIBE `ports` 0.0019240379333496
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00038480758666992
(431) DESCRIBE `ports` 0.002432107925415
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00042605400085449
(433) DESCRIBE `ports` 0.0076251029968262
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00064897537231445
(435) DESCRIBE `ports` 0.002730131149292
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.0005800724029541
(437) DESCRIBE `ports` 0.0026330947875977
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.0056970119476318
(439) DESCRIBE `ports` 0.0031521320343018
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4949))) 0.00049710273742676
(441) DESCRIBE `ports` 0.0086138248443604
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4949') 0.00049901008605957
(443) DESCRIBE `ports` 0.0028350353240967
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1082))) 0.00052499771118164
(445) DESCRIBE `ports` 0.0024149417877197
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1082') 0.0091118812561035
(447) DESCRIBE `ports` 0.0022921562194824
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00056600570678711
(449) DESCRIBE `ports` 0.0021770000457764
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00044608116149902
(451) DESCRIBE `ports` 0.00187087059021
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00045394897460938
(453) DESCRIBE `ports` 0.0026710033416748
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.0058228969573975
(455) DESCRIBE `ports` 0.0024199485778809
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.0005948543548584
(457) DESCRIBE `ports` 0.0089471340179443
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.0005340576171875
(459) DESCRIBE `ports` 0.0026569366455078
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00063800811767578
(461) DESCRIBE `ports` 0.002936840057373
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.012111902236938
(463) DESCRIBE `avid_specials` 0.0027408599853516
(464) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61419 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.012784957885742
(465) DESCRIBE `cruiselines` 0.0028798580169678
(466) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.0007328987121582
(467) DESCRIBE `orchid_image` 0.0034201145172119
(468) DESCRIBE `cruiselines` 0.010232925415039
(469) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00066900253295898
(470) DESCRIBE `cruises` 0.005817174911499
(471) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76401') 0.013443946838379
(472) DESCRIBE `ships` 0.004019021987915
(473) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.00057005882263184
(474) DESCRIBE `ships` 0.0037429332733154
(475) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.0078310966491699
(476) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00041985511779785
(477) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034499168395996
(478) DESCRIBE `itineraries` 0.0020389556884766
(479) DESCRIBE `ports` 0.001945972442627
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046801567077637
(481) DESCRIBE `ports` 0.0022461414337158
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0079059600830078
(483) DESCRIBE `ports` 0.0031518936157227
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00067615509033203
(485) DESCRIBE `sailingdates` 0.0026760101318359
(486) DESCRIBE `ports` 0.0030179023742676
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0087289810180664
(488) DESCRIBE `ports` 0.0033819675445557
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00068902969360352
(490) DESCRIBE `ports` 0.0023801326751709
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 413))) 0.0065419673919678
(492) DESCRIBE `ports` 0.0022320747375488
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '413') 0.00055408477783203
(494) DESCRIBE `ports` 0.0021600723266602
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00045394897460938
(496) DESCRIBE `ports` 0.0022118091583252
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00051188468933105
(498) DESCRIBE `ports` 0.002004861831665
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00048494338989258
(500) DESCRIBE `ports` 0.0023159980773926
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00053000450134277
(502) DESCRIBE `ports` 0.0020449161529541
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00052714347839355
(504) DESCRIBE `ports` 0.0060188770294189
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00044703483581543
(506) DESCRIBE `ports` 0.0050458908081055
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00066900253295898
(508) DESCRIBE `ports` 0.0022208690643311
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00069093704223633
(510) DESCRIBE `ports` 0.0026090145111084
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00064682960510254
(512) DESCRIBE `ports` 0.0024387836456299
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00044703483581543
(514) DESCRIBE `ports` 0.0020511150360107
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00055289268493652
(516) DESCRIBE `ports` 0.0027608871459961
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00066494941711426
(518) DESCRIBE `ports` 0.0029520988464355
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00064897537231445
(520) DESCRIBE `ports` 0.0026187896728516
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00063109397888184
(522) DESCRIBE `ports` 0.002910852432251
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00049996376037598
(524) DESCRIBE `ports` 0.002830982208252
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00043511390686035
(526) DESCRIBE `ports` 0.0019679069519043
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4949))) 0.00051283836364746
(528) DESCRIBE `ports` 0.0019187927246094
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4949') 0.00046992301940918
(530) DESCRIBE `ports` 0.0019919872283936
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00041818618774414
(532) DESCRIBE `ports` 0.002263069152832
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00043892860412598
(534) DESCRIBE `ports` 0.002018928527832
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00053000450134277
(536) DESCRIBE `ports` 0.0021390914916992
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00042319297790527
(538) DESCRIBE `avid_specials` 0.0016980171203613
(539) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76401 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011250972747803
(540) DESCRIBE `cruiselines` 0.0026059150695801
(541) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00046610832214355
(542) DESCRIBE `orchid_image` 0.0020699501037598
(543) DESCRIBE `cruiselines` 0.0030460357666016
(544) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00044703483581543
(545) DESCRIBE `cruises` 0.0039880275726318
(546) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '61420') 0.00044107437133789
(547) DESCRIBE `ships` 0.0037040710449219
(548) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 966))) 0.0006868839263916
(549) DESCRIBE `ships` 0.0042798519134521
(550) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '966') 0.00046181678771973
(551) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037598609924316
(552) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00051689147949219
(553) DESCRIBE `itineraries` 0.0022220611572266
(554) DESCRIBE `ports` 0.0019991397857666
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00050592422485352
(556) DESCRIBE `ports` 0.0024831295013428
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046586990356445
(558) DESCRIBE `ports` 0.0021359920501709
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00049781799316406
(560) DESCRIBE `sailingdates` 0.0018179416656494
(561) DESCRIBE `ports` 0.0026299953460693
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00074601173400879
(563) DESCRIBE `ports` 0.002575159072876
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00050091743469238
(565) DESCRIBE `ports` 0.0019791126251221
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 413))) 0.00044703483581543
(567) DESCRIBE `ports` 0.0020220279693604
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '413') 0.00048017501831055
(569) DESCRIBE `ports` 0.0020360946655273
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.0006251335144043
(571) DESCRIBE `ports` 0.002129077911377
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00041818618774414
(573) DESCRIBE `ports` 0.0020730495452881
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00043106079101562
(575) DESCRIBE `ports` 0.002032995223999
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00047612190246582
(577) DESCRIBE `ports` 0.0021688938140869
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00046896934509277
(579) DESCRIBE `ports` 0.0023188591003418
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00041007995605469
(581) DESCRIBE `ports` 0.0018520355224609
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00042009353637695
(583) DESCRIBE `ports` 0.0018479824066162
(584) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00039887428283691
(585) DESCRIBE `ports` 0.0018961429595947
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00061297416687012
(587) DESCRIBE `ports` 0.0020039081573486
(588) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00043392181396484
(589) DESCRIBE `ports` 0.0019760131835938
(590) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00044989585876465
(591) DESCRIBE `ports` 0.0018839836120605
(592) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00040698051452637
(593) DESCRIBE `avid_specials` 0.001615047454834
(594) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 61420 and class = 'Cruise') OR (item_id = 966 AND class = 'Ship') OR (item_id = 91 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0014300346374512
(595) DESCRIBE `cruiselines` 0.002708911895752
(596) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00048208236694336
(597) DESCRIBE `orchid_image` 0.002047061920166
(598) DESCRIBE `cruiselines` 0.0028588771820068
(599) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00048613548278809
(600) DESCRIBE `cruises` 0.0036389827728271
(601) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76215') 0.00044798851013184
(602) DESCRIBE `ships` 0.0038840770721436
(603) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 394))) 0.00055980682373047
(604) DESCRIBE `ships` 0.0040152072906494
(605) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '394') 0.0005040168762207
(606) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00038003921508789
(607) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035405158996582
(608) DESCRIBE `itineraries` 0.0020389556884766
(609) DESCRIBE `ports` 0.0021309852600098
(610) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00073003768920898
(611) DESCRIBE `ports` 0.0024480819702148
(612) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0005490779876709
(613) DESCRIBE `ports` 0.0020601749420166
(614) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0004267692565918
(615) DESCRIBE `sailingdates` 0.001701831817627
(616) DESCRIBE `ports` 0.0019989013671875
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048303604125977
(618) DESCRIBE `ports` 0.0019450187683105
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0005190372467041
(620) DESCRIBE `ports` 0.0018570423126221
(621) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00042486190795898
(622) DESCRIBE `ports` 0.0019199848175049
(623) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00046610832214355
(624) DESCRIBE `ports` 0.001884937286377
(625) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 454))) 0.017670869827271
(626) DESCRIBE `ports` 0.0022749900817871
(627) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '454') 0.00047898292541504
(628) DESCRIBE `ports` 0.0020079612731934
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00052499771118164
(630) DESCRIBE `ports` 0.0022170543670654
(631) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.0017681121826172
(632) DESCRIBE `ports` 0.0021100044250488
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.00045609474182129
(634) DESCRIBE `ports` 0.0018620491027832
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.00055098533630371
(636) DESCRIBE `ports` 0.0022919178009033
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 82))) 0.00063395500183105
(638) DESCRIBE `ports` 0.0020010471343994
(639) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '82') 0.00050091743469238
(640) DESCRIBE `ports` 0.0020849704742432
(641) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00048708915710449
(642) DESCRIBE `ports` 0.0020270347595215
(643) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00041890144348145
(644) DESCRIBE `ports` 0.0019900798797607
(645) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1037))) 0.00046515464782715
(646) DESCRIBE `ports` 0.0019419193267822
(647) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1037') 0.00045013427734375
(648) DESCRIBE `ports` 0.002007007598877
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00045204162597656
(650) DESCRIBE `ports` 0.0020039081573486
(651) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00050020217895508
(652) DESCRIBE `ports` 0.0019969940185547
(653) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00050997734069824
(654) DESCRIBE `ports` 0.0019130706787109
(655) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.0004119873046875
(656) DESCRIBE `ports` 0.0025670528411865
(657) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2059))) 0.00070810317993164
(658) DESCRIBE `ports` 0.0021829605102539
(659) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2059') 0.00042080879211426
(660) DESCRIBE `ports` 0.0020110607147217
(661) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2480))) 0.00048089027404785
(662) DESCRIBE `ports` 0.0018999576568604
(663) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2480') 0.00050497055053711
(664) DESCRIBE `ports` 0.002187967300415
(665) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 23))) 0.00045680999755859
(666) DESCRIBE `ports` 0.00199294090271
(667) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '23') 0.00044894218444824
(668) DESCRIBE `ports` 0.0020198822021484
(669) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 793))) 0.00049209594726562
(670) DESCRIBE `ports` 0.0020899772644043
(671) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '793') 0.00039505958557129
(672) DESCRIBE `ports` 0.0021770000457764
(673) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.0004420280456543
(674) DESCRIBE `ports` 0.0020790100097656
(675) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00059413909912109
(676) DESCRIBE `ports` 0.0021059513092041
(677) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00049090385437012
(678) DESCRIBE `ports` 0.0022521018981934
(679) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00049710273742676
(680) DESCRIBE `ports` 0.0019521713256836
(681) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00044679641723633
(682) DESCRIBE `ports` 0.001910924911499
(683) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00040817260742188
(684) DESCRIBE `ports` 0.0018889904022217
(685) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00050997734069824
(686) DESCRIBE `ports` 0.0022609233856201
(687) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00042009353637695
(688) DESCRIBE `ports` 0.0018901824951172
(689) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2472))) 0.00043201446533203
(690) DESCRIBE `ports` 0.0020108222961426
(691) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2472') 0.0004880428314209
(692) DESCRIBE `ports` 0.0021750926971436
(693) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048398971557617
(694) DESCRIBE `ports` 0.0018398761749268
(695) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0004119873046875
(696) DESCRIBE `avid_specials` 0.0016500949859619
(697) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76215 and class = 'Cruise') OR (item_id = 394 AND class = 'Ship') OR (item_id = 91 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.0013730525970459
(698) DESCRIBE `cruiselines` 0.0028879642486572
(699) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00060892105102539
(700) DESCRIBE `orchid_image` 0.00205397605896
(701) DESCRIBE `cruiselines` 0.0027420520782471
(702) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00040721893310547
(703) DESCRIBE `cruises` 0.0037479400634766
(704) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '84402') 0.00040793418884277
(705) DESCRIBE `ships` 0.0037150382995605
(706) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 394))) 0.00051784515380859
(707) DESCRIBE `ships` 0.0042159557342529
(708) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '394') 0.00046491622924805
(709) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0004889965057373
(710) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035500526428223
(711) DESCRIBE `itineraries` 0.0019950866699219
(712) DESCRIBE `ports` 0.0020179748535156
(713) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0006110668182373
(714) DESCRIBE `ports` 0.0020949840545654
(715) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042200088500977
(716) DESCRIBE `ports` 0.0018620491027832
(717) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00047683715820312
(718) DESCRIBE `sailingdates` 0.001704216003418
(719) DESCRIBE `ports` 0.0020248889923096
(720) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046396255493164
(721) DESCRIBE `ports` 0.0018510818481445
(722) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00046014785766602
(723) DESCRIBE `ports` 0.0020670890808105
(724) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00043511390686035
(725) DESCRIBE `ports` 0.0018880367279053
(726) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00040912628173828
(727) DESCRIBE `ports` 0.0020558834075928
(728) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 454))) 0.0004279613494873
(729) DESCRIBE `ports` 0.0018870830535889
(730) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '454') 0.00043296813964844
(731) DESCRIBE `ports` 0.0018768310546875
(732) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00043606758117676
(733) DESCRIBE `ports` 0.0017929077148438
(734) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00038695335388184
(735) DESCRIBE `ports` 0.0025091171264648
(736) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.00078201293945312
(737) DESCRIBE `ports` 0.0021522045135498
(738) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.00040197372436523
(739) DESCRIBE `ports` 0.0018560886383057
(740) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 82))) 0.00043201446533203
(741) DESCRIBE `ports` 0.0022060871124268
(742) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '82') 0.00041604042053223
(743) DESCRIBE `ports` 0.0019991397857666
(744) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.0004570484161377
(745) DESCRIBE `ports` 0.0018339157104492
(746) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00046896934509277
(747) DESCRIBE `ports` 0.0018370151519775
(748) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1037))) 0.00042891502380371
(749) DESCRIBE `ports` 0.002129077911377
(750) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1037') 0.00038385391235352
(751) DESCRIBE `ports` 0.002000093460083
(752) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00039911270141602
(753) DESCRIBE `ports` 0.0017960071563721
(754) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00035905838012695
(755) DESCRIBE `ports` 0.0017910003662109
(756) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1440))) 0.00050687789916992
(757) DESCRIBE `ports` 0.001835823059082
(758) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1440') 0.00040483474731445
(759) DESCRIBE `avid_specials` 0.0018990039825439
(760) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 84402 and class = 'Cruise') OR (item_id = 394 AND class = 'Ship') OR (item_id = 91 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.0018730163574219
(761) DESCRIBE `cruiselines` 0.0033528804779053
(762) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00064992904663086
(763) DESCRIBE `orchid_image` 0.0029540061950684
(764) DESCRIBE `cruiselines` 0.0032041072845459
(765) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '91') 0.00046205520629883
(766) DESCRIBE `ships` 0.007673978805542
(767) SELECT `ships`.* FROM `ships` WHERE (id IN ('966', '850', '1319', '1108', '508', '394')) ORDER BY FIND_IN_SET(id, '966,850,1319,1108,508,394') 0.0012421607971191
(768) DESCRIBE `cruisetypes` 0.001554012298584
(769) DESCRIBE `destinations` 0.002345085144043
(770) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '40', '26', '37', '2', '38', '35', '43', '28', '21', '11', '48', '49', '8', '30', '45', '10', '52', '25', '34', '32', '55')) ORDER BY FIND_IN_SET(id, '22,12,40,26,37,2,38,35,43,28,21,11,48,49,8,30,45,10,52,25,34,32,55') 0.0021200180053711
(771) DESCRIBE `cruiselines` 0.002532958984375
(772) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00043392181396484
(773) DESCRIBE `cruiselines` 0.0026390552520752
(774) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 91))) 0.00050210952758789