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

Total elapsed time: 1.0932724475861

# Query Time
(1) connect 0.0019400119781494
(2) DESCRIBE `cruises` 0.0060920715332031
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (53038, 84441, 63617, 72508, 72591, 72646, 72528, 63616, 72555, 72629)) ORDER BY FIND_IN_SET(id, '53038,84441,63617,72508,72591,72646,72528,63616,72555,72629') 0.0037500858306885
(4) DESCRIBE `cruises` 0.0042870044708252
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '53038') 0.00054097175598145
(6) DESCRIBE `ships` 0.0044951438903809
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 149))) 0.00062894821166992
(8) DESCRIBE `ships` 0.00400710105896
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '149') 0.00054502487182617
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00050210952758789
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00048089027404785
(12) DESCRIBE `itineraries` 0.0025761127471924
(13) DESCRIBE `ports` 0.0021119117736816
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00049996376037598
(15) DESCRIBE `ports` 0.0022530555725098
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00060105323791504
(17) DESCRIBE `ports` 0.0021929740905762
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '217') 0.00050806999206543
(19) DESCRIBE `sailingdates` 0.0022668838500977
(20) DESCRIBE `ports` 0.0022001266479492
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 217))) 0.00061202049255371
(22) DESCRIBE `ports` 0.0023069381713867
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '217') 0.00054502487182617
(24) DESCRIBE `ports` 0.0024921894073486
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 751))) 0.00056290626525879
(26) DESCRIBE `ports` 0.0022759437561035
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '751') 0.00046992301940918
(28) DESCRIBE `ports` 0.0021481513977051
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2110))) 0.00049614906311035
(30) DESCRIBE `ports` 0.0021729469299316
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2110') 0.00051498413085938
(32) DESCRIBE `ports` 0.0022859573364258
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 752))) 0.00050997734069824
(34) DESCRIBE `ports` 0.0027220249176025
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '752') 0.0006260871887207
(36) DESCRIBE `ports` 0.0025899410247803
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00059795379638672
(38) DESCRIBE `ports` 0.0027179718017578
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00055980682373047
(40) DESCRIBE `ports` 0.0027010440826416
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 748))) 0.00052499771118164
(42) DESCRIBE `ports` 0.002547025680542
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '748') 0.00056099891662598
(44) DESCRIBE `ports` 0.0025961399078369
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1972))) 0.00064897537231445
(46) DESCRIBE `ports` 0.0029938220977783
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1972') 0.00055694580078125
(48) DESCRIBE `ports` 0.0034770965576172
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2361))) 0.00065016746520996
(50) DESCRIBE `ports` 0.0025680065155029
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2361') 0.00058197975158691
(52) DESCRIBE `ports` 0.0025870800018311
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.0006110668182373
(54) DESCRIBE `ports` 0.0026531219482422
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00055289268493652
(56) DESCRIBE `ports` 0.0025410652160645
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00057792663574219
(58) DESCRIBE `ports` 0.0025770664215088
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00057315826416016
(60) DESCRIBE `avid_specials` 0.0022199153900146
(61) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 53038 and class = 'Cruise') OR (item_id = 149 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 49 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.0023360252380371
(62) DESCRIBE `cruiselines` 0.0040221214294434
(63) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00073099136352539
(64) DESCRIBE `orchid_image` 0.0033450126647949
(65) DESCRIBE `cruises` 0.0040850639343262
(66) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '84441') 0.00052809715270996
(67) DESCRIBE `ships` 0.0040960311889648
(68) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 223))) 0.00075697898864746
(69) DESCRIBE `ships` 0.0049030780792236
(70) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '223') 0.00051784515380859
(71) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00042200088500977
(72) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00034713745117188
(73) DESCRIBE `itineraries` 0.0026860237121582
(74) DESCRIBE `ports` 0.0026488304138184
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00068402290344238
(76) DESCRIBE `ports` 0.0026800632476807
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00066995620727539
(78) DESCRIBE `ports` 0.0019428730010986
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00042390823364258
(80) DESCRIBE `sailingdates` 0.0018792152404785
(81) DESCRIBE `ports` 0.0027439594268799
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00065922737121582
(83) DESCRIBE `ports` 0.0022149085998535
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00047397613525391
(85) DESCRIBE `ports` 0.0022218227386475
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 584))) 0.00053715705871582
(87) DESCRIBE `ports` 0.0026240348815918
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '584') 0.00091004371643066
(89) DESCRIBE `ports` 0.0028128623962402
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00063705444335938
(91) DESCRIBE `ports` 0.0031039714813232
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00063085556030273
(93) DESCRIBE `ports` 0.0028171539306641
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00060296058654785
(95) DESCRIBE `ports` 0.0026280879974365
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00042510032653809
(97) DESCRIBE `ports` 0.0020120143890381
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1832))) 0.00050497055053711
(99) DESCRIBE `ports` 0.0024909973144531
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1832') 0.00053191184997559
(101) DESCRIBE `ports` 0.002601146697998
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00064706802368164
(103) DESCRIBE `ports` 0.0027830600738525
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.0006260871887207
(105) DESCRIBE `ports` 0.0027289390563965
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 925))) 0.00058197975158691
(107) DESCRIBE `ports` 0.0027310848236084
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '925') 0.00045394897460938
(109) DESCRIBE `ports` 0.0018241405487061
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00044393539428711
(111) DESCRIBE `ports` 0.002000093460083
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00038385391235352
(113) DESCRIBE `ports` 0.0018949508666992
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00047492980957031
(115) DESCRIBE `ports` 0.0024619102478027
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00052690505981445
(117) DESCRIBE `avid_specials` 0.002230167388916
(118) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 84441 and class = 'Cruise') OR (item_id = 223 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 22 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.0013120174407959
(119) DESCRIBE `cruiselines` 0.0029699802398682
(120) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00045204162597656
(121) DESCRIBE `orchid_image` 0.0021610260009766
(122) DESCRIBE `cruises` 0.0037829875946045
(123) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63617') 0.00063705444335938
(124) DESCRIBE `ships` 0.0043458938598633
(125) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1095))) 0.00056219100952148
(126) DESCRIBE `ships` 0.0035910606384277
(127) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1095') 0.00038290023803711
(128) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00040006637573242
(129) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00034809112548828
(130) DESCRIBE `itineraries` 0.0019040107727051
(131) DESCRIBE `ports` 0.0019121170043945
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2595))) 0.00064396858215332
(133) DESCRIBE `ports` 0.0023601055145264
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2595))) 0.0005340576171875
(135) DESCRIBE `ports` 0.001953125
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2595') 0.00040912628173828
(137) DESCRIBE `sailingdates` 0.0017790794372559
(138) DESCRIBE `ports` 0.0030620098114014
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2595))) 0.00061416625976562
(140) DESCRIBE `ports` 0.0019068717956543
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2595') 0.00042915344238281
(142) DESCRIBE `ports` 0.0020899772644043
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2597))) 0.00044608116149902
(144) DESCRIBE `ports` 0.0024580955505371
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2597') 0.00040698051452637
(146) DESCRIBE `ports` 0.002140998840332
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5369))) 0.00043582916259766
(148) DESCRIBE `ports` 0.0021121501922607
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5369') 0.00042414665222168
(150) DESCRIBE `ports` 0.0021371841430664
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2599))) 0.00047612190246582
(152) DESCRIBE `ports` 0.0022299289703369
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2599') 0.00044012069702148
(154) DESCRIBE `ports` 0.0021920204162598
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4182))) 0.00055599212646484
(156) DESCRIBE `ports` 0.0029449462890625
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4182') 0.00065994262695312
(158) DESCRIBE `ports` 0.0027589797973633
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4452))) 0.00058412551879883
(160) DESCRIBE `ports` 0.0027899742126465
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4452') 0.0005500316619873
(162) DESCRIBE `ports` 0.0027229785919189
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4453))) 0.00060296058654785
(164) DESCRIBE `ports` 0.0027580261230469
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4453') 0.0003969669342041
(166) DESCRIBE `ports` 0.0019540786743164
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2663))) 0.00040006637573242
(168) DESCRIBE `ports` 0.0018649101257324
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2663') 0.00045490264892578
(170) DESCRIBE `ports` 0.0017719268798828
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4183))) 0.00040292739868164
(172) DESCRIBE `ports` 0.0018231868743896
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4183') 0.00036907196044922
(174) DESCRIBE `ports` 0.0017900466918945
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2527))) 0.00039196014404297
(176) DESCRIBE `ports` 0.0018711090087891
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2527') 0.00044894218444824
(178) DESCRIBE `ports` 0.0020689964294434
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2666))) 0.00041699409484863
(180) DESCRIBE `ports` 0.0022192001342773
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2666') 0.00039386749267578
(182) DESCRIBE `ports` 0.0018398761749268
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2671))) 0.00039792060852051
(184) DESCRIBE `ports` 0.0026509761810303
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2671') 0.00058913230895996
(186) DESCRIBE `avid_specials` 0.0025758743286133
(187) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63617 and class = 'Cruise') OR (item_id = 1095 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 37 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.002310037612915
(188) DESCRIBE `cruiselines` 0.004054069519043
(189) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00078892707824707
(190) DESCRIBE `orchid_image` 0.0030131340026855
(191) DESCRIBE `cruises` 0.0037529468536377
(192) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72508') 0.00042605400085449
(193) DESCRIBE `ships` 0.0043950080871582
(194) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 147))) 0.00074505805969238
(195) DESCRIBE `ships` 0.0042388439178467
(196) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '147') 0.00060796737670898
(197) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00035476684570312
(198) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.0004580020904541
(199) DESCRIBE `itineraries` 0.0025019645690918
(200) DESCRIBE `ports` 0.00189208984375
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00051593780517578
(202) DESCRIBE `ports` 0.0022678375244141
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00045609474182129
(204) DESCRIBE `ports` 0.0018570423126221
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00040793418884277
(206) DESCRIBE `sailingdates` 0.0017399787902832
(207) DESCRIBE `ports` 0.0019230842590332
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00041317939758301
(209) DESCRIBE `ports` 0.0021328926086426
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00062918663024902
(211) DESCRIBE `ports` 0.002007007598877
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 861))) 0.00046277046203613
(213) DESCRIBE `ports` 0.0017850399017334
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '861') 0.00041580200195312
(215) DESCRIBE `ports` 0.0019240379333496
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3587))) 0.00052595138549805
(217) DESCRIBE `ports` 0.0025870800018311
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3587') 0.0003969669342041
(219) DESCRIBE `ports` 0.0020339488983154
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3587))) 0.00041484832763672
(221) DESCRIBE `ports` 0.0022079944610596
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3587') 0.00075292587280273
(223) DESCRIBE `ports` 0.002310037612915
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3587))) 0.0004270076751709
(225) DESCRIBE `ports` 0.0022568702697754
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3587') 0.00047492980957031
(227) DESCRIBE `ports` 0.0018470287322998
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3587))) 0.00071191787719727
(229) DESCRIBE `ports` 0.0030231475830078
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3587') 0.00057005882263184
(231) DESCRIBE `ports` 0.0026521682739258
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3587))) 0.00064802169799805
(233) DESCRIBE `ports` 0.0024838447570801
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3587') 0.00042414665222168
(235) DESCRIBE `ports` 0.0019090175628662
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3587))) 0.00048184394836426
(237) DESCRIBE `ports` 0.0022790431976318
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3587') 0.00060415267944336
(239) DESCRIBE `ports` 0.0021059513092041
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1843))) 0.0004420280456543
(241) DESCRIBE `ports` 0.0021848678588867
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1843') 0.00038003921508789
(243) DESCRIBE `ports` 0.0024039745330811
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 572))) 0.00054717063903809
(245) DESCRIBE `ports` 0.002086877822876
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '572') 0.00038790702819824
(247) DESCRIBE `ports` 0.0018718242645264
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3435))) 0.00040102005004883
(249) DESCRIBE `ports` 0.0018141269683838
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3435') 0.00038003921508789
(251) DESCRIBE `ports` 0.0021059513092041
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1183))) 0.00057697296142578
(253) DESCRIBE `ports` 0.0025100708007812
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1183') 0.00058889389038086
(255) DESCRIBE `ports` 0.0025069713592529
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 229))) 0.00052499771118164
(257) DESCRIBE `ports` 0.0022399425506592
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '229') 0.00046706199645996
(259) DESCRIBE `avid_specials` 0.0021400451660156
(260) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72508 and class = 'Cruise') OR (item_id = 147 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 49 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.0014638900756836
(261) DESCRIBE `cruiselines` 0.0035579204559326
(262) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00046014785766602
(263) DESCRIBE `orchid_image` 0.0027420520782471
(264) DESCRIBE `cruises` 0.0045168399810791
(265) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72591') 0.00055408477783203
(266) DESCRIBE `ships` 0.0049138069152832
(267) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 717))) 0.00062799453735352
(268) DESCRIBE `ships` 0.0041749477386475
(269) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '717') 0.00055599212646484
(270) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00052785873413086
(271) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00048995018005371
(272) DESCRIBE `itineraries` 0.0027878284454346
(273) DESCRIBE `ports` 0.0023679733276367
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00064706802368164
(275) DESCRIBE `ports` 0.0028300285339355
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00060606002807617
(277) DESCRIBE `ports` 0.0024008750915527
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00044584274291992
(279) DESCRIBE `sailingdates` 0.0019609928131104
(280) DESCRIBE `ports` 0.0019450187683105
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00058603286743164
(282) DESCRIBE `ports` 0.0032780170440674
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00052380561828613
(284) DESCRIBE `ports` 0.0021491050720215
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4627))) 0.00042390823364258
(286) DESCRIBE `ports` 0.0019900798797607
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4627') 0.00048708915710449
(288) DESCRIBE `ports` 0.0019721984863281
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1294))) 0.00044107437133789
(290) DESCRIBE `ports` 0.0019989013671875
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1294') 0.00039482116699219
(292) DESCRIBE `ports` 0.0020978450775146
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1934))) 0.0004270076751709
(294) DESCRIBE `ports` 0.0021350383758545
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1934') 0.00047516822814941
(296) DESCRIBE `ports` 0.0018959045410156
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4626))) 0.00064587593078613
(298) DESCRIBE `ports` 0.002147912979126
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4626') 0.00045418739318848
(300) DESCRIBE `ports` 0.0020301342010498
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4625))) 0.00051689147949219
(302) DESCRIBE `ports` 0.0021889209747314
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4625') 0.00041007995605469
(304) DESCRIBE `ports` 0.002112865447998
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1291))) 0.00043010711669922
(306) DESCRIBE `ports` 0.0020108222961426
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1291') 0.00039005279541016
(308) DESCRIBE `ports` 0.0024008750915527
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1290))) 0.0004730224609375
(310) DESCRIBE `ports` 0.0019168853759766
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1290') 0.00048089027404785
(312) DESCRIBE `ports` 0.0018100738525391
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1289))) 0.00042390823364258
(314) DESCRIBE `ports` 0.0019800662994385
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1289') 0.00042009353637695
(316) DESCRIBE `ports` 0.0019969940185547
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1269))) 0.00044608116149902
(318) DESCRIBE `ports` 0.0019030570983887
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1269') 0.00040888786315918
(320) DESCRIBE `ports` 0.0018179416656494
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4615))) 0.00043010711669922
(322) DESCRIBE `ports` 0.0018129348754883
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4615') 0.00039291381835938
(324) DESCRIBE `ports` 0.0019381046295166
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4629))) 0.00051999092102051
(326) DESCRIBE `ports` 0.0029900074005127
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4629') 0.00068902969360352
(328) DESCRIBE `ports` 0.0030629634857178
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00083208084106445
(330) DESCRIBE `ports` 0.0019948482513428
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00044107437133789
(332) DESCRIBE `ports` 0.0019960403442383
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1790))) 0.00046920776367188
(334) DESCRIBE `ports` 0.0023159980773926
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1790') 0.0004270076751709
(336) DESCRIBE `ports` 0.0020020008087158
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4641))) 0.00045299530029297
(338) DESCRIBE `ports` 0.0019490718841553
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4641') 0.00057196617126465
(340) DESCRIBE `ports` 0.0020239353179932
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4636))) 0.00052404403686523
(342) DESCRIBE `ports` 0.0018858909606934
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4636') 0.00047516822814941
(344) DESCRIBE `ports` 0.0019230842590332
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4633))) 0.00047802925109863
(346) DESCRIBE `ports` 0.0019421577453613
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4633') 0.00043201446533203
(348) DESCRIBE `ports` 0.0021109580993652
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5124))) 0.00054192543029785
(350) DESCRIBE `ports` 0.0020577907562256
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5124') 0.00045990943908691
(352) DESCRIBE `ports` 0.0019781589508057
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5523))) 0.00044488906860352
(354) DESCRIBE `ports` 0.0022039413452148
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5523') 0.00040817260742188
(356) DESCRIBE `ports` 0.0018370151519775
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5807))) 0.00047898292541504
(358) DESCRIBE `ports` 0.0017919540405273
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5807') 0.00058889389038086
(360) DESCRIBE `ports` 0.0032169818878174
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5808))) 0.00067996978759766
(362) DESCRIBE `ports` 0.0031900405883789
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5808') 0.000701904296875
(364) DESCRIBE `ports` 0.003242015838623
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00065994262695312
(366) DESCRIBE `ports` 0.0031781196594238
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00067996978759766
(368) DESCRIBE `ports` 0.0030310153961182
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1908))) 0.00069904327392578
(370) DESCRIBE `ports` 0.0033609867095947
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1908') 0.00068187713623047
(372) DESCRIBE `ports` 0.0032038688659668
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1284))) 0.0006411075592041
(374) DESCRIBE `ports` 0.002856969833374
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1284') 0.00057888031005859
(376) DESCRIBE `avid_specials` 0.0023581981658936
(377) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72591 and class = 'Cruise') OR (item_id = 717 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 2 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.002777099609375
(378) DESCRIBE `cruiselines` 0.0047049522399902
(379) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00090312957763672
(380) DESCRIBE `orchid_image` 0.0040180683135986
(381) DESCRIBE `cruises` 0.0042018890380859
(382) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72646') 0.00045609474182129
(383) DESCRIBE `ships` 0.0048329830169678
(384) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 768))) 0.00078392028808594
(385) DESCRIBE `ships` 0.0050249099731445
(386) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '768') 0.00058388710021973
(387) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00047492980957031
(388) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00061392784118652
(389) DESCRIBE `itineraries` 0.0029678344726562
(390) DESCRIBE `ports` 0.002856969833374
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0019299983978271
(392) DESCRIBE `ports` 0.0019710063934326
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0004429817199707
(394) DESCRIBE `ports` 0.0020289421081543
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00044989585876465
(396) DESCRIBE `sailingdates` 0.0018339157104492
(397) DESCRIBE `ports` 0.0020627975463867
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00057387351989746
(399) DESCRIBE `ports` 0.002032995223999
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00046515464782715
(401) DESCRIBE `ports` 0.0019268989562988
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00048089027404785
(403) DESCRIBE `ports` 0.0020480155944824
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00044512748718262
(405) DESCRIBE `ports` 0.0020778179168701
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3691))) 0.00059390068054199
(407) DESCRIBE `ports` 0.0023221969604492
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3691') 0.00047802925109863
(409) DESCRIBE `ports` 0.0021510124206543
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) 0.00065708160400391
(411) DESCRIBE `ports` 0.0028009414672852
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') 0.0006260871887207
(413) DESCRIBE `ports` 0.0027589797973633
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.00074219703674316
(415) DESCRIBE `ports` 0.0026810169219971
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.00059700012207031
(417) DESCRIBE `ports` 0.0026929378509521
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 223))) 0.00073504447937012
(419) DESCRIBE `ports` 0.0027179718017578
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '223') 0.00059604644775391
(421) DESCRIBE `ports` 0.0025560855865479
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226))) 0.00099492073059082
(423) DESCRIBE `ports` 0.0020480155944824
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226') 0.00042891502380371
(425) DESCRIBE `ports` 0.0018148422241211
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.0004279613494873
(427) DESCRIBE `ports` 0.0019261837005615
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00040197372436523
(429) DESCRIBE `ports` 0.0018701553344727
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 520))) 0.00045490264892578
(431) DESCRIBE `ports` 0.0018730163574219
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '520') 0.00039196014404297
(433) DESCRIBE `ports` 0.0018129348754883
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00047898292541504
(435) DESCRIBE `ports` 0.0021491050720215
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00058197975158691
(437) DESCRIBE `avid_specials` 0.0017249584197998
(438) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72646 and class = 'Cruise') OR (item_id = 768 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 25 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.0012741088867188
(439) DESCRIBE `cruiselines` 0.0027139186859131
(440) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00048017501831055
(441) DESCRIBE `orchid_image` 0.0029590129852295
(442) DESCRIBE `cruises` 0.0063250064849854
(443) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72528') 0.00067687034606934
(444) DESCRIBE `ships` 0.005465030670166
(445) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1398))) 0.0014119148254395
(446) DESCRIBE `ships` 0.0045058727264404
(447) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1398') 0.00065493583679199
(448) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00040698051452637
(449) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00043892860412598
(450) DESCRIBE `itineraries` 0.0032110214233398
(451) DESCRIBE `ports` 0.0025730133056641
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00053715705871582
(453) DESCRIBE `ports` 0.0019588470458984
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00047612190246582
(455) DESCRIBE `ports` 0.0020630359649658
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00047588348388672
(457) DESCRIBE `sailingdates` 0.0017259120941162
(458) DESCRIBE `ports` 0.0022189617156982
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00072407722473145
(460) DESCRIBE `ports` 0.0023400783538818
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00051283836364746
(462) DESCRIBE `ports` 0.0020999908447266
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00071907043457031
(464) DESCRIBE `ports` 0.0033049583435059
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00061893463134766
(466) DESCRIBE `ports` 0.0027871131896973
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00063109397888184
(468) DESCRIBE `ports` 0.0028529167175293
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00064897537231445
(470) DESCRIBE `ports` 0.0024070739746094
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00050783157348633
(472) DESCRIBE `ports` 0.0018730163574219
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00042200088500977
(474) DESCRIBE `ports` 0.0021979808807373
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00050210952758789
(476) DESCRIBE `ports` 0.0022299289703369
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00049304962158203
(478) DESCRIBE `ports` 0.0025501251220703
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 29))) 0.00060391426086426
(480) DESCRIBE `ports` 0.0025651454925537
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '29') 0.00060105323791504
(482) DESCRIBE `ports` 0.0023210048675537
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00062108039855957
(484) DESCRIBE `ports` 0.002345085144043
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00046801567077637
(486) DESCRIBE `ports` 0.0019400119781494
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00042891502380371
(488) DESCRIBE `ports` 0.0020060539245605
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00037503242492676
(490) DESCRIBE `avid_specials` 0.0017919540405273
(491) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72528 and class = 'Cruise') OR (item_id = 1398 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 2 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.0012660026550293
(492) DESCRIBE `cruiselines` 0.0030419826507568
(493) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00050997734069824
(494) DESCRIBE `orchid_image` 0.0021731853485107
(495) DESCRIBE `cruises` 0.004539966583252
(496) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63616') 0.00048685073852539
(497) DESCRIBE `ships` 0.0052750110626221
(498) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1095))) 0.00087785720825195
(499) DESCRIBE `ships` 0.0054121017456055
(500) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1095') 0.00076198577880859
(501) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00046396255493164
(502) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00046014785766602
(503) DESCRIBE `itineraries` 0.0021708011627197
(504) DESCRIBE `ports` 0.001917839050293
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2671))) 0.00062108039855957
(506) DESCRIBE `ports` 0.0018751621246338
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2671))) 0.00041794776916504
(508) DESCRIBE `ports` 0.0018401145935059
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2671') 0.00039196014404297
(510) DESCRIBE `sailingdates` 0.0019190311431885
(511) DESCRIBE `ports` 0.0024030208587646
(512) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2671))) 0.00059294700622559
(513) DESCRIBE `ports` 0.0024330615997314
(514) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2671') 0.00057697296142578
(515) DESCRIBE `ports` 0.0026328563690186
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4209))) 0.00042986869812012
(517) DESCRIBE `ports` 0.0020790100097656
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4209') 0.00059008598327637
(519) DESCRIBE `ports` 0.0022590160369873
(520) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2600))) 0.00075197219848633
(521) DESCRIBE `ports` 0.0020508766174316
(522) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2600') 0.00058102607727051
(523) DESCRIBE `ports` 0.0020740032196045
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4451))) 0.00051188468933105
(525) DESCRIBE `ports` 0.0019481182098389
(526) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4451') 0.00056982040405273
(527) DESCRIBE `ports` 0.0022101402282715
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5370))) 0.00059413909912109
(529) DESCRIBE `ports` 0.0026121139526367
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5370') 0.00064492225646973
(531) DESCRIBE `ports` 0.0026400089263916
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2662))) 0.00060701370239258
(533) DESCRIBE `ports` 0.0026390552520752
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2662') 0.00056314468383789
(535) DESCRIBE `ports` 0.0026679039001465
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2525))) 0.00060892105102539
(537) DESCRIBE `ports` 0.0027260780334473
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2525') 0.00056195259094238
(539) DESCRIBE `ports` 0.0026569366455078
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2595))) 0.00055694580078125
(541) DESCRIBE `ports` 0.0020651817321777
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2595') 0.00040006637573242
(543) DESCRIBE `ports` 0.0019497871398926
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5374))) 0.00044894218444824
(545) DESCRIBE `ports` 0.0023329257965088
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5374') 0.00043201446533203
(547) DESCRIBE `ports` 0.0025970935821533
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2524))) 0.00064206123352051
(549) DESCRIBE `ports` 0.0027129650115967
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2524') 0.0004889965057373
(551) DESCRIBE `ports` 0.0021898746490479
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2878))) 0.00044584274291992
(553) DESCRIBE `ports` 0.0020260810852051
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2878') 0.00040912628173828
(555) DESCRIBE `ports` 0.0018908977508545
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2666))) 0.00045585632324219
(557) DESCRIBE `ports` 0.002094030380249
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2666') 0.00057697296142578
(559) DESCRIBE `ports` 0.0025269985198975
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2882))) 0.00069999694824219
(561) DESCRIBE `ports` 0.0023870468139648
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2882') 0.00052499771118164
(563) DESCRIBE `ports` 0.0022192001342773
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2595))) 0.00051712989807129
(565) DESCRIBE `ports` 0.002208948135376
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2595') 0.00049400329589844
(567) DESCRIBE `avid_specials` 0.0020167827606201
(568) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63616 and class = 'Cruise') OR (item_id = 1095 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 37 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.0017869472503662
(569) DESCRIBE `cruiselines` 0.0031790733337402
(570) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.0006251335144043
(571) DESCRIBE `orchid_image` 0.0023460388183594
(572) DESCRIBE `cruises` 0.0059719085693359
(573) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72555') 0.00081014633178711
(574) DESCRIBE `ships` 0.006248950958252
(575) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 148))) 0.00090503692626953
(576) DESCRIBE `ships` 0.0058231353759766
(577) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '148') 0.00068497657775879
(578) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00048398971557617
(579) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.0003960132598877
(580) DESCRIBE `itineraries` 0.0024080276489258
(581) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '72555') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0014140605926514
(582) DESCRIBE `ports` 0.0036380290985107
(583) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00074100494384766
(584) DESCRIBE `ports` 0.0034868717193604
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00057101249694824
(586) DESCRIBE `ports` 0.0022690296173096
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0004429817199707
(588) DESCRIBE `sailingdates` 0.0018861293792725
(589) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '72555') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010509490966797
(590) DESCRIBE `ports` 0.0022928714752197
(591) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00057816505432129
(592) DESCRIBE `ports` 0.0020699501037598
(593) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00049209594726562
(594) DESCRIBE `ports` 0.0023369789123535
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 698))) 0.00050616264343262
(596) DESCRIBE `ports` 0.0019302368164062
(597) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '698') 0.00046801567077637
(598) DESCRIBE `ports` 0.0018658638000488
(599) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1709))) 0.00040912628173828
(600) DESCRIBE `ports` 0.0018749237060547
(601) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1709') 0.00037598609924316
(602) DESCRIBE `ports` 0.0020599365234375
(603) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 661))) 0.00038909912109375
(604) DESCRIBE `ports` 0.0017690658569336
(605) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '661') 0.00037097930908203
(606) DESCRIBE `ports` 0.001762866973877
(607) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00039315223693848
(608) DESCRIBE `ports` 0.0018551349639893
(609) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00037217140197754
(610) DESCRIBE `ports` 0.0020229816436768
(611) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1213))) 0.00041794776916504
(612) DESCRIBE `ports` 0.0023071765899658
(613) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1213') 0.00064706802368164
(614) DESCRIBE `ports` 0.0019309520721436
(615) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00040507316589355
(616) DESCRIBE `ports` 0.001816987991333
(617) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00037407875061035
(618) DESCRIBE `ports` 0.0019960403442383
(619) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00039100646972656
(620) DESCRIBE `ports` 0.0023880004882812
(621) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00049281120300293
(622) DESCRIBE `avid_specials` 0.0019090175628662
(623) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72555 and class = 'Cruise') OR (item_id = 148 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 22 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.0013408660888672
(624) DESCRIBE `cruiselines` 0.0030550956726074
(625) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00050711631774902
(626) DESCRIBE `orchid_image` 0.0021998882293701
(627) DESCRIBE `cruises` 0.0039288997650146
(628) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72629') 0.0004570484161377
(629) DESCRIBE `ships` 0.0040390491485596
(630) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 223))) 0.0005030632019043
(631) DESCRIBE `ships` 0.0052859783172607
(632) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '223') 0.0006558895111084
(633) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00051617622375488
(634) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00046086311340332
(635) DESCRIBE `itineraries` 0.0028829574584961
(636) DESCRIBE `ports` 0.0026280879974365
(637) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00064706802368164
(638) DESCRIBE `ports` 0.0028531551361084
(639) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00056791305541992
(640) DESCRIBE `ports` 0.002769947052002
(641) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00055599212646484
(642) DESCRIBE `sailingdates` 0.002065896987915
(643) DESCRIBE `ports` 0.0022878646850586
(644) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00044107437133789
(645) DESCRIBE `ports` 0.0019359588623047
(646) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0004730224609375
(647) DESCRIBE `ports` 0.0022389888763428
(648) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1626))) 0.00043606758117676
(649) DESCRIBE `ports` 0.0017900466918945
(650) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1626') 0.00046491622924805
(651) DESCRIBE `ports` 0.0019550323486328
(652) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00040292739868164
(653) DESCRIBE `ports` 0.001953125
(654) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00038313865661621
(655) DESCRIBE `ports` 0.00235915184021
(656) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00052118301391602
(657) DESCRIBE `ports` 0.0023250579833984
(658) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00043606758117676
(659) DESCRIBE `ports` 0.0018179416656494
(660) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.0004889965057373
(661) DESCRIBE `ports` 0.0021328926086426
(662) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00056004524230957
(663) DESCRIBE `ports` 0.0020999908447266
(664) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 651))) 0.00042510032653809
(665) DESCRIBE `ports` 0.0025742053985596
(666) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '651') 0.00055789947509766
(667) DESCRIBE `ports` 0.0019099712371826
(668) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00043988227844238
(669) DESCRIBE `ports` 0.0018742084503174
(670) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00043106079101562
(671) DESCRIBE `ports` 0.0018129348754883
(672) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00049996376037598
(673) DESCRIBE `ports` 0.0019018650054932
(674) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00037717819213867
(675) DESCRIBE `avid_specials` 0.0015881061553955
(676) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72629 and class = 'Cruise') OR (item_id = 223 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 22 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.0014209747314453
(677) DESCRIBE `cruiselines` 0.0026991367340088
(678) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00058698654174805
(679) DESCRIBE `orchid_image` 0.0022909641265869
(680) DESCRIBE `ships` 0.0039088726043701
(681) SELECT `ships`.* FROM `ships` WHERE (id IN ('1398', '148', '1095', '223', '768', '147', '717', '149', '1810', '1757')) ORDER BY FIND_IN_SET(id, '1398,148,1095,223,768,147,717,149,1810,1757') 0.0018379688262939
(682) DESCRIBE `cruisetypes` 0.0021588802337646
(683) DESCRIBE `destinations` 0.0031759738922119
(684) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('37', '22', '12', '2', '7', '35', '43', '49', '38', '11', '26', '8', '40', '28', '21', '45', '25', '30', '48', '52', '34')) ORDER BY FIND_IN_SET(id, '37,22,12,2,7,35,43,49,38,11,26,8,40,28,21,45,25,30,48,52,34') 0.0022079944610596
(685) DESCRIBE `cruiselines` 0.0043509006500244
(686) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00072193145751953
(687) DESCRIBE `cruiselines` 0.0040690898895264
(688) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00072717666625977