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

Total elapsed time: 0.97428035736084

# Query Time
(1) connect 0.0013148784637451
(2) DESCRIBE `cruises` 0.0046920776367188
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (52240, 75135, 38573, 38580, 44562, 34169, 34190, 47911, 67266, 78107)) ORDER BY FIND_IN_SET(id, '52240,75135,38573,38580,44562,34169,34190,47911,67266,78107') 0.0029850006103516
(4) DESCRIBE `cruises` 0.0043458938598633
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52240') 0.00067877769470215
(6) DESCRIBE `ships` 0.0053110122680664
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1291))) 0.0006561279296875
(8) DESCRIBE `ships` 0.0045201778411865
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1291') 0.00077009201049805
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0004420280456543
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0003809928894043
(12) DESCRIBE `itineraries` 0.0019280910491943
(13) DESCRIBE `ports` 0.0018880367279053
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.0004580020904541
(15) DESCRIBE `ports` 0.0019400119781494
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00039982795715332
(17) DESCRIBE `ports` 0.0019650459289551
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00039196014404297
(19) DESCRIBE `sailingdates` 0.0017509460449219
(20) DESCRIBE `ports` 0.0020909309387207
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00043988227844238
(22) DESCRIBE `ports` 0.0017452239990234
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00037908554077148
(24) DESCRIBE `ports` 0.0018091201782227
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00040507316589355
(26) DESCRIBE `ports` 0.0018279552459717
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00037503242492676
(28) DESCRIBE `ports` 0.001823902130127
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4179))) 0.00039005279541016
(30) DESCRIBE `ports` 0.0018010139465332
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4179') 0.00039005279541016
(32) DESCRIBE `ports` 0.0019180774688721
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2523))) 0.00040197372436523
(34) DESCRIBE `ports` 0.0020260810852051
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2523') 0.0003819465637207
(36) DESCRIBE `ports` 0.0018329620361328
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2529))) 0.00039410591125488
(38) DESCRIBE `ports` 0.0020101070404053
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2529') 0.00038290023803711
(40) DESCRIBE `ports` 0.0019328594207764
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2597))) 0.00043201446533203
(42) DESCRIBE `ports` 0.0024039745330811
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2597') 0.00060606002807617
(44) DESCRIBE `ports` 0.0026130676269531
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2666))) 0.0005800724029541
(46) DESCRIBE `ports` 0.0026059150695801
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2666') 0.00052309036254883
(48) DESCRIBE `ports` 0.0025968551635742
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2525))) 0.00059080123901367
(50) DESCRIBE `ports` 0.0026650428771973
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2525') 0.00057387351989746
(52) DESCRIBE `ports` 0.0025551319122314
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2525))) 0.00057721138000488
(54) DESCRIBE `ports` 0.0027608871459961
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2525') 0.0006251335144043
(56) DESCRIBE `ports` 0.0018730163574219
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00042009353637695
(58) DESCRIBE `ports` 0.0019400119781494
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00042295455932617
(60) DESCRIBE `ports` 0.0019400119781494
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1646))) 0.00042390823364258
(62) DESCRIBE `ports` 0.0018680095672607
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1646') 0.00041699409484863
(64) DESCRIBE `avid_specials` 0.0020098686218262
(65) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 52240 and class = 'Cruise') OR (item_id = 1291 AND class = 'Ship') OR (item_id = 171 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.0011308193206787
(66) DESCRIBE `cruiselines` 0.0026638507843018
(67) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 171))) 0.00042390823364258
(68) DESCRIBE `orchid_image` 0.0024569034576416
(69) DESCRIBE `cruises` 0.005465030670166
(70) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '75135') 0.00063204765319824
(71) DESCRIBE `ships` 0.0048260688781738
(72) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 9))) 0.00061488151550293
(73) DESCRIBE `ships` 0.0036218166351318
(74) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '9') 0.00057315826416016
(75) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00046992301940918
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034809112548828
(77) DESCRIBE `itineraries` 0.0019078254699707
(78) DESCRIBE `ports` 0.0021419525146484
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1827))) 0.00057697296142578
(80) DESCRIBE `ports` 0.0022430419921875
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1827))) 0.00053596496582031
(82) DESCRIBE `ports` 0.0019469261169434
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1827') 0.00049614906311035
(84) DESCRIBE `sailingdates` 0.0015439987182617
(85) DESCRIBE `ports` 0.0019881725311279
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1827))) 0.00044584274291992
(87) DESCRIBE `ports` 0.0019259452819824
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1827') 0.00039005279541016
(89) DESCRIBE `ports` 0.00193190574646
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00041007995605469
(91) DESCRIBE `ports` 0.001986026763916
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.0003960132598877
(93) DESCRIBE `ports` 0.0017600059509277
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00043916702270508
(95) DESCRIBE `ports` 0.0017409324645996
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00037598609924316
(97) DESCRIBE `ports` 0.0018360614776611
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1827))) 0.00039505958557129
(99) DESCRIBE `ports` 0.0018930435180664
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1827') 0.00037884712219238
(101) DESCRIBE `avid_specials` 0.0015430450439453
(102) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 75135 and class = 'Cruise') OR (item_id = 9 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 9 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.0012881755828857
(103) DESCRIBE `cruiselines` 0.0024819374084473
(104) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00059199333190918
(105) DESCRIBE `orchid_image` 0.002079963684082
(106) DESCRIBE `cruiselines` 0.0027902126312256
(107) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00039386749267578
(108) DESCRIBE `cruises` 0.0033831596374512
(109) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '38573') 0.00058197975158691
(110) DESCRIBE `ships` 0.0037868022918701
(111) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 974))) 0.00055599212646484
(112) DESCRIBE `ships` 0.0037868022918701
(113) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '974') 0.00057888031005859
(114) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00037717819213867
(115) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033998489379883
(116) DESCRIBE `itineraries` 0.0017471313476562
(117) DESCRIBE `ports` 0.0021049976348877
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00040197372436523
(119) DESCRIBE `ports` 0.0018601417541504
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00037002563476562
(121) DESCRIBE `ports` 0.0019540786743164
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00041604042053223
(123) DESCRIBE `sailingdates` 0.0016999244689941
(124) DESCRIBE `ports` 0.0020370483398438
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00051498413085938
(126) DESCRIBE `ports` 0.0021710395812988
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.0006101131439209
(128) DESCRIBE `ports` 0.0020098686218262
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00040411949157715
(130) DESCRIBE `ports` 0.00180983543396
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00046491622924805
(132) DESCRIBE `ports` 0.0019600391387939
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00040102005004883
(134) DESCRIBE `ports` 0.0017988681793213
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.0003809928894043
(136) DESCRIBE `ports` 0.0017590522766113
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00042009353637695
(138) DESCRIBE `ports` 0.0017509460449219
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00046491622924805
(140) DESCRIBE `ports` 0.0019831657409668
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00041389465332031
(142) DESCRIBE `ports` 0.0017800331115723
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00039196014404297
(144) DESCRIBE `ports` 0.0017471313476562
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00048303604125977
(146) DESCRIBE `ports` 0.0018110275268555
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00039005279541016
(148) DESCRIBE `ports` 0.0017690658569336
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00040817260742188
(150) DESCRIBE `ports` 0.001727819442749
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00039005279541016
(152) DESCRIBE `avid_specials` 0.0015380382537842
(153) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 38573 and class = 'Cruise') OR (item_id = 974 AND class = 'Ship') OR (item_id = 183 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012378692626953
(154) DESCRIBE `cruiselines` 0.0025088787078857
(155) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00042891502380371
(156) DESCRIBE `orchid_image` 0.0019419193267822
(157) DESCRIBE `cruiselines` 0.002636194229126
(158) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00038504600524902
(159) DESCRIBE `cruises` 0.0053470134735107
(160) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '38580') 0.00065422058105469
(161) DESCRIBE `ships` 0.0056548118591309
(162) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 797))) 0.00050592422485352
(163) DESCRIBE `ships` 0.0037209987640381
(164) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '797') 0.00041413307189941
(165) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035905838012695
(166) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00038313865661621
(167) DESCRIBE `itineraries` 0.0017960071563721
(168) DESCRIBE `ports` 0.0018508434295654
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00040316581726074
(170) DESCRIBE `ports` 0.0017800331115723
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.0003960132598877
(172) DESCRIBE `ports` 0.0017280578613281
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00040316581726074
(174) DESCRIBE `sailingdates` 0.001762866973877
(175) DESCRIBE `ports` 0.0024230480194092
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00067806243896484
(177) DESCRIBE `ports` 0.0020589828491211
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00040006637573242
(179) DESCRIBE `ports` 0.0027408599853516
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00083708763122559
(181) DESCRIBE `ports` 0.0023188591003418
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00047707557678223
(183) DESCRIBE `ports` 0.0018649101257324
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00050187110900879
(185) DESCRIBE `ports` 0.0018730163574219
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00040817260742188
(187) DESCRIBE `ports` 0.0019259452819824
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00041294097900391
(189) DESCRIBE `ports` 0.0017659664154053
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00040388107299805
(191) DESCRIBE `ports` 0.0017709732055664
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00048208236694336
(193) DESCRIBE `ports` 0.0019919872283936
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00037503242492676
(195) DESCRIBE `ports` 0.0019090175628662
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00041699409484863
(197) DESCRIBE `ports` 0.0018110275268555
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00039911270141602
(199) DESCRIBE `ports` 0.0019679069519043
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00043702125549316
(201) DESCRIBE `ports` 0.0020790100097656
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00042104721069336
(203) DESCRIBE `ports` 0.0025231838226318
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00060105323791504
(205) DESCRIBE `ports` 0.0026421546936035
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00050711631774902
(207) DESCRIBE `avid_specials` 0.0020589828491211
(208) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 38580 and class = 'Cruise') OR (item_id = 797 AND class = 'Ship') OR (item_id = 183 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001251220703125
(209) DESCRIBE `cruiselines` 0.0027291774749756
(210) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 183))) 0.00043892860412598
(211) DESCRIBE `orchid_image` 0.0022299289703369
(212) DESCRIBE `cruiselines` 0.0026090145111084
(213) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '183') 0.00041007995605469
(214) DESCRIBE `cruises` 0.0045640468597412
(215) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '44562') 0.00048208236694336
(216) DESCRIBE `ships` 0.0040950775146484
(217) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 521))) 0.00047206878662109
(218) DESCRIBE `ships` 0.0037229061126709
(219) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '521') 0.00039196014404297
(220) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00046491622924805
(221) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003659725189209
(222) DESCRIBE `itineraries` 0.0025181770324707
(223) DESCRIBE `ports` 0.0019290447235107
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.0004429817199707
(225) DESCRIBE `ports` 0.0018069744110107
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00038909912109375
(227) DESCRIBE `ports` 0.0023040771484375
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00048589706420898
(229) DESCRIBE `sailingdates` 0.0017838478088379
(230) DESCRIBE `ports` 0.00199294090271
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.0004880428314209
(232) DESCRIBE `ports` 0.0021848678588867
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00056886672973633
(234) DESCRIBE `ports` 0.0020949840545654
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00054311752319336
(236) DESCRIBE `ports` 0.002514123916626
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00044703483581543
(238) DESCRIBE `ports` 0.0020420551300049
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3488))) 0.00047993659973145
(240) DESCRIBE `ports` 0.0024750232696533
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3488') 0.00058102607727051
(242) DESCRIBE `ports` 0.0029420852661133
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 6151))) 0.00062918663024902
(244) DESCRIBE `ports` 0.0028882026672363
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '6151') 0.00059795379638672
(246) DESCRIBE `ports` 0.0024809837341309
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00046801567077637
(248) DESCRIBE `ports` 0.0026218891143799
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.0005948543548584
(250) DESCRIBE `avid_specials` 0.001737117767334
(251) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 44562 and class = 'Cruise') OR (item_id = 521 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012218952178955
(252) DESCRIBE `cruiselines` 0.0025460720062256
(253) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00048184394836426
(254) DESCRIBE `orchid_image` 0.0020370483398438
(255) DESCRIBE `cruiselines` 0.0026998519897461
(256) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00041580200195312
(257) DESCRIBE `cruises` 0.0033621788024902
(258) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '34169') 0.00041604042053223
(259) DESCRIBE `ships` 0.0035719871520996
(260) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 31))) 0.00052881240844727
(261) DESCRIBE `ships` 0.0057480335235596
(262) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '31') 0.00045895576477051
(263) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00036287307739258
(264) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00040602684020996
(265) DESCRIBE `itineraries` 0.0018441677093506
(266) DESCRIBE `ports` 0.0026860237121582
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00066995620727539
(268) DESCRIBE `ports` 0.0025460720062256
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00056099891662598
(270) DESCRIBE `ports` 0.0027110576629639
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00055789947509766
(272) DESCRIBE `sailingdates` 0.0017249584197998
(273) DESCRIBE `ports` 0.0020999908447266
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00049781799316406
(275) DESCRIBE `ports` 0.00193190574646
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00039219856262207
(277) DESCRIBE `ports` 0.0018670558929443
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00049281120300293
(279) DESCRIBE `ports` 0.0017790794372559
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.0004119873046875
(281) DESCRIBE `ports` 0.0019230842590332
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.00042104721069336
(283) DESCRIBE `ports` 0.0018219947814941
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.0014350414276123
(285) DESCRIBE `ports` 0.001762866973877
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.0004580020904541
(287) DESCRIBE `ports` 0.0019419193267822
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00050210952758789
(289) DESCRIBE `ports` 0.0020921230316162
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.00040316581726074
(291) DESCRIBE `ports` 0.0019199848175049
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.00037908554077148
(293) DESCRIBE `ports` 0.0019998550415039
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 272))) 0.00048995018005371
(295) DESCRIBE `ports` 0.0019388198852539
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '272') 0.00038504600524902
(297) DESCRIBE `ports` 0.0018329620361328
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 273))) 0.00039505958557129
(299) DESCRIBE `ports` 0.0019600391387939
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '273') 0.00039315223693848
(301) DESCRIBE `ports` 0.0024528503417969
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00042104721069336
(303) DESCRIBE `ports` 0.0019919872283936
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00038814544677734
(305) DESCRIBE `ports` 0.001802921295166
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 889))) 0.00046491622924805
(307) DESCRIBE `ports` 0.0017988681793213
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '889') 0.00038599967956543
(309) DESCRIBE `ports` 0.0018250942230225
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.0005040168762207
(311) DESCRIBE `ports` 0.0033040046691895
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00063109397888184
(313) DESCRIBE `ports` 0.0025250911712646
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 271))) 0.00063490867614746
(315) DESCRIBE `ports` 0.0024909973144531
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '271') 0.00044798851013184
(317) DESCRIBE `ports` 0.0026729106903076
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00057315826416016
(319) DESCRIBE `ports` 0.0026369094848633
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00053811073303223
(321) DESCRIBE `ports` 0.0026431083679199
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 889))) 0.00058507919311523
(323) DESCRIBE `ports` 0.002683162689209
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '889') 0.0005490779876709
(325) DESCRIBE `ports` 0.0026538372039795
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00059819221496582
(327) DESCRIBE `ports` 0.0024271011352539
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00050783157348633
(329) DESCRIBE `ports` 0.0024571418762207
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 273))) 0.00055098533630371
(331) DESCRIBE `ports` 0.0024309158325195
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '273') 0.00054812431335449
(333) DESCRIBE `ports` 0.0023469924926758
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 272))) 0.00052809715270996
(335) DESCRIBE `ports` 0.0024988651275635
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '272') 0.00052905082702637
(337) DESCRIBE `ports` 0.0023880004882812
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.00047516822814941
(339) DESCRIBE `ports` 0.0023250579833984
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.00046992301940918
(341) DESCRIBE `ports` 0.0024800300598145
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00055384635925293
(343) DESCRIBE `ports` 0.002485990524292
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.0005340576171875
(345) DESCRIBE `ports` 0.0024478435516357
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.00050783157348633
(347) DESCRIBE `ports` 0.0025150775909424
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.00054597854614258
(349) DESCRIBE `ports` 0.0026960372924805
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00061678886413574
(351) DESCRIBE `ports` 0.0026748180389404
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.00056695938110352
(353) DESCRIBE `ports` 0.0025320053100586
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00068187713623047
(355) DESCRIBE `ports` 0.0025331974029541
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00054001808166504
(357) DESCRIBE `avid_specials` 0.002190113067627
(358) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 34169 and class = 'Cruise') OR (item_id = 31 AND class = 'Ship') OR (item_id = 7 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.0020718574523926
(359) DESCRIBE `cruiselines` 0.0038349628448486
(360) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 7))) 0.00066184997558594
(361) DESCRIBE `orchid_image` 0.0022730827331543
(362) DESCRIBE `cruiselines` 0.0025839805603027
(363) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '7') 0.00041890144348145
(364) DESCRIBE `cruises` 0.0039911270141602
(365) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '34190') 0.00043010711669922
(366) DESCRIBE `ships` 0.0035557746887207
(367) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 31))) 0.0006101131439209
(368) DESCRIBE `ships` 0.0035362243652344
(369) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '31') 0.00041794776916504
(370) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00036191940307617
(371) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00039410591125488
(372) DESCRIBE `itineraries` 0.001924991607666
(373) DESCRIBE `ports` 0.0023739337921143
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00061202049255371
(375) DESCRIBE `ports` 0.00217604637146
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.0004279613494873
(377) DESCRIBE `ports` 0.002241849899292
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00047397613525391
(379) DESCRIBE `sailingdates` 0.0016491413116455
(380) DESCRIBE `ports` 0.0018317699432373
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00045299530029297
(382) DESCRIBE `ports` 0.002129077911377
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00059390068054199
(384) DESCRIBE `ports` 0.0021297931671143
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00048685073852539
(386) DESCRIBE `ports` 0.0018651485443115
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.00044989585876465
(388) DESCRIBE `ports` 0.0021669864654541
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 523))) 0.0006558895111084
(390) DESCRIBE `ports` 0.0024881362915039
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '523') 0.00045895576477051
(392) DESCRIBE `ports` 0.0018520355224609
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 522))) 0.00042486190795898
(394) DESCRIBE `ports` 0.0018649101257324
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '522') 0.00059390068054199
(396) DESCRIBE `ports` 0.0027210712432861
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.00065803527832031
(398) DESCRIBE `ports` 0.0027580261230469
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.00041580200195312
(400) DESCRIBE `ports` 0.0017459392547607
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 272))) 0.00042295455932617
(402) DESCRIBE `ports` 0.0018100738525391
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '272') 0.00046610832214355
(404) DESCRIBE `ports` 0.0018470287322998
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 273))) 0.00049614906311035
(406) DESCRIBE `ports` 0.0021960735321045
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '273') 0.00040102005004883
(408) DESCRIBE `ports` 0.0018031597137451
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00041103363037109
(410) DESCRIBE `ports` 0.0018529891967773
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00049901008605957
(412) DESCRIBE `ports` 0.0017890930175781
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 889))) 0.00042891502380371
(414) DESCRIBE `ports` 0.0018370151519775
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '889') 0.00037789344787598
(416) DESCRIBE `ports` 0.0017778873443604
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00041604042053223
(418) DESCRIBE `ports` 0.0017850399017334
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00043702125549316
(420) DESCRIBE `ports` 0.001835823059082
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 271))) 0.00041103363037109
(422) DESCRIBE `ports` 0.0019268989562988
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '271') 0.00037503242492676
(424) DESCRIBE `avid_specials` 0.0019168853759766
(425) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 34190 and class = 'Cruise') OR (item_id = 31 AND class = 'Ship') OR (item_id = 7 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.0015730857849121
(426) DESCRIBE `cruiselines` 0.0039279460906982
(427) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 7))) 0.00064182281494141
(428) DESCRIBE `orchid_image` 0.0023078918457031
(429) DESCRIBE `cruiselines` 0.0027930736541748
(430) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '7') 0.00039911270141602
(431) DESCRIBE `cruises` 0.0038518905639648
(432) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '47911') 0.00043010711669922
(433) DESCRIBE `ships` 0.0037379264831543
(434) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 639))) 0.00052213668823242
(435) DESCRIBE `ships` 0.0034849643707275
(436) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '639') 0.00045204162597656
(437) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '9') 0.00036311149597168
(438) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '9') 0.00034999847412109
(439) DESCRIBE `itineraries` 0.0018939971923828
(440) DESCRIBE `ports` 0.0020051002502441
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1388))) 0.00047683715820312
(442) DESCRIBE `ports` 0.0018601417541504
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1388))) 0.00053310394287109
(444) DESCRIBE `ports` 0.0022299289703369
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1388') 0.00046801567077637
(446) DESCRIBE `sailingdates` 0.0015799999237061
(447) DESCRIBE `ports` 0.0019500255584717
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1388))) 0.00058889389038086
(449) DESCRIBE `ports` 0.0021288394927979
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1388') 0.00040507316589355
(451) DESCRIBE `ports` 0.0018417835235596
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1675))) 0.00041294097900391
(453) DESCRIBE `ports` 0.0019919872283936
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1675') 0.0004570484161377
(455) DESCRIBE `ports` 0.0017950534820557
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2709))) 0.00045299530029297
(457) DESCRIBE `ports` 0.0017588138580322
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2709') 0.00039100646972656
(459) DESCRIBE `ports` 0.0018730163574219
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 673))) 0.00042200088500977
(461) DESCRIBE `ports` 0.0019619464874268
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '673') 0.00040197372436523
(463) DESCRIBE `ports` 0.0017518997192383
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4621))) 0.00052118301391602
(465) DESCRIBE `ports` 0.0017530918121338
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4621') 0.00047516822814941
(467) DESCRIBE `ports` 0.0017931461334229
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2710))) 0.00042486190795898
(469) DESCRIBE `ports` 0.0018460750579834
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2710') 0.00039505958557129
(471) DESCRIBE `ports` 0.0018839836120605
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2711))) 0.00041699409484863
(473) DESCRIBE `ports` 0.0021190643310547
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2711') 0.00060796737670898
(475) DESCRIBE `ports` 0.0020248889923096
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1145))) 0.00043201446533203
(477) DESCRIBE `ports` 0.001816987991333
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1145') 0.00038695335388184
(479) DESCRIBE `ports` 0.0020201206207275
(480) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1678))) 0.00043201446533203
(481) DESCRIBE `ports` 0.0020308494567871
(482) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1678') 0.00039005279541016
(483) DESCRIBE `avid_specials` 0.0015559196472168
(484) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 47911 and class = 'Cruise') OR (item_id = 639 AND class = 'Ship') OR (item_id = 103 AND class = 'CruiseLine') OR (item_id = 39 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.0013179779052734
(485) DESCRIBE `cruiselines` 0.0026559829711914
(486) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 103))) 0.00052118301391602
(487) DESCRIBE `orchid_image` 0.0019519329071045
(488) DESCRIBE `cruiselines` 0.0024600028991699
(489) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '103') 0.00045394897460938
(490) DESCRIBE `cruises` 0.0034079551696777
(491) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67266') 0.00038814544677734
(492) DESCRIBE `ships` 0.0035848617553711
(493) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 970))) 0.00049495697021484
(494) DESCRIBE `ships` 0.0033700466156006
(495) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '970') 0.00041890144348145
(496) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035595893859863
(497) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034499168395996
(498) DESCRIBE `itineraries` 0.0023391246795654
(499) DESCRIBE `ports` 0.0018370151519775
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00042390823364258
(501) DESCRIBE `ports` 0.0017409324645996
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00040507316589355
(503) DESCRIBE `ports` 0.0018401145935059
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00038409233093262
(505) DESCRIBE `sailingdates` 0.001554012298584
(506) DESCRIBE `ports` 0.0020430088043213
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00044584274291992
(508) DESCRIBE `ports` 0.0018420219421387
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00040817260742188
(510) DESCRIBE `ports` 0.0018889904022217
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4894))) 0.0004889965057373
(512) DESCRIBE `ports` 0.0017850399017334
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4894') 0.00049805641174316
(514) DESCRIBE `ports` 0.002129077911377
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.0005180835723877
(516) DESCRIBE `ports` 0.0018200874328613
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00038599967956543
(518) DESCRIBE `ports` 0.0018351078033447
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00041484832763672
(520) DESCRIBE `ports` 0.002007007598877
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00038504600524902
(522) DESCRIBE `ports` 0.0017549991607666
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1727))) 0.00044012069702148
(524) DESCRIBE `ports` 0.0018889904022217
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1727') 0.00054287910461426
(526) DESCRIBE `ports` 0.0020730495452881
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00049805641174316
(528) DESCRIBE `ports` 0.0020661354064941
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00040793418884277
(530) DESCRIBE `avid_specials` 0.001856803894043
(531) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67266 and class = 'Cruise') OR (item_id = 970 AND class = 'Ship') OR (item_id = 218 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.0014529228210449
(532) DESCRIBE `cruiselines` 0.0029129981994629
(533) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00054001808166504
(534) DESCRIBE `orchid_image` 0.002202033996582
(535) DESCRIBE `cruiselines` 0.0027401447296143
(536) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00053596496582031
(537) DESCRIBE `cruises` 0.0045640468597412
(538) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78107') 0.00071907043457031
(539) DESCRIBE `ships` 0.0048408508300781
(540) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 711))) 0.00052499771118164
(541) DESCRIBE `ships` 0.003892183303833
(542) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '711') 0.00045490264892578
(543) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00038003921508789
(544) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00043082237243652
(545) DESCRIBE `itineraries` 0.0023999214172363
(546) DESCRIBE `ports` 0.0021800994873047
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00051093101501465
(548) DESCRIBE `ports` 0.0017950534820557
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00041794776916504
(550) DESCRIBE `ports` 0.0018620491027832
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00040578842163086
(552) DESCRIBE `sailingdates` 0.0016360282897949
(553) DESCRIBE `ports` 0.00199294090271
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00051593780517578
(555) DESCRIBE `ports` 0.0019559860229492
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00039386749267578
(557) DESCRIBE `ports` 0.002122163772583
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 665))) 0.00046110153198242
(559) DESCRIBE `ports` 0.0018379688262939
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '665') 0.00043296813964844
(561) DESCRIBE `ports` 0.0022251605987549
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5435))) 0.00057697296142578
(563) DESCRIBE `ports` 0.0019190311431885
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5435') 0.00045585632324219
(565) DESCRIBE `ports` 0.0019590854644775
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 408))) 0.00054812431335449
(567) DESCRIBE `ports` 0.0020561218261719
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '408') 0.00052714347839355
(569) DESCRIBE `ports` 0.0021271705627441
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1755))) 0.00050902366638184
(571) DESCRIBE `ports` 0.0022940635681152
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1755') 0.00049495697021484
(573) DESCRIBE `ports` 0.0021839141845703
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00047707557678223
(575) DESCRIBE `ports` 0.0023090839385986
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00039792060852051
(577) DESCRIBE `ports` 0.0018229484558105
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 412))) 0.00059795379638672
(579) DESCRIBE `ports` 0.0026488304138184
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '412') 0.00055503845214844
(581) DESCRIBE `ports` 0.0025660991668701
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00061202049255371
(583) DESCRIBE `ports` 0.0026750564575195
(584) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00058698654174805
(585) DESCRIBE `ports` 0.003026008605957
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1114))) 0.00082588195800781
(587) DESCRIBE `ports` 0.0028948783874512
(588) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1114') 0.00065088272094727
(589) DESCRIBE `ports` 0.0026779174804688
(590) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00099802017211914
(591) DESCRIBE `ports` 0.0027990341186523
(592) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00060391426086426
(593) DESCRIBE `ports` 0.0027310848236084
(594) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00077390670776367
(595) DESCRIBE `ports` 0.0029418468475342
(596) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00060296058654785
(597) DESCRIBE `ports` 0.0024030208587646
(598) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5198))) 0.00046205520629883
(599) DESCRIBE `ports` 0.0019879341125488
(600) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5198') 0.00043988227844238
(601) DESCRIBE `ports` 0.0022289752960205
(602) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00049710273742676
(603) DESCRIBE `ports` 0.0021028518676758
(604) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00059795379638672
(605) DESCRIBE `ports` 0.0029349327087402
(606) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 500))) 0.00064206123352051
(607) DESCRIBE `ports` 0.0025091171264648
(608) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '500') 0.00053882598876953
(609) DESCRIBE `ports` 0.0023059844970703
(610) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00064420700073242
(611) DESCRIBE `ports` 0.002288818359375
(612) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00047993659973145
(613) DESCRIBE `avid_specials` 0.0020978450775146
(614) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78107 and class = 'Cruise') OR (item_id = 711 AND class = 'Ship') OR (item_id = 28 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.0019948482513428
(615) DESCRIBE `cruiselines` 0.0037281513214111
(616) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 28))) 0.00055313110351562
(617) DESCRIBE `orchid_image` 0.0021319389343262
(618) DESCRIBE `cruiselines` 0.0032038688659668
(619) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('77', '218', '19', '26', '171', '23', '144', '20', '12', '7', '18', '101', '31', '183', '8', '120', '131', '96', '29', '103', '206', '15', '91', '262', '24', '114', '33', '14', '156', '170', '28', '258', '50', '191', '153', '195', '37', '208', '49', '16', '187', '251', '36', '88', '47', '151', '216', '212', '141', '181', '118', '4', '110', '140', '59', '147', '261', '213', '48', '30', '211', '276', '73', '209', '159', '82', '95', '113', '57', '90', '115', '184', '244', '52', '264', '108', '180', '64', '105', '35', '38', '134', '245', '257')) ORDER BY FIND_IN_SET(id, '77,218,19,26,171,23,144,20,12,7,18,101,31,183,8,120,131,96,29,103,206,15,91,262,24,114,33,14,156,170,28,258,50,191,153,195,37,208,49,16,187,251,36,88,47,151,216,212,141,181,118,4,110,140,59,147,261,213,48,30,211,276,73,209,159,82,95,113,57,90,115,184,244,52,264,108,180,64,105,35,38,134,245,257') 0.0062580108642578
(620) DESCRIBE `ships` 0.004755973815918
(621) SELECT `ships`.* FROM `ships` WHERE (id IN ('1761', '732', '1744', '726', '1324', '258', '517', '1588', '780', '737', '1417', '871', '1717', '855', '1766', '207', '1572', '404', '454', '977', '1794', '770', '874', '1291', '1594', '1359', '1272', '1134', '738', '1424', '66', '434', '265', '22', '330', '461', '1199', '21', '393', '553', '332', '1032', '1768', '28', '333', '716', '1260', '1419', '1423', '974', '1422', '1418', '1420', '1421', '1682', '766', '1292', '521', '1237', '1348', '1415', '797', '349', '715', '585', '711', '455', '1678', '9', '674', '792', '1132', '407', '657', '25', '163', '439', '11', '739', '1852', '10', '1460', '857', '858', '1008', '1233', '1501', '1677', '3', '24', '520', '542', '1721', '1822', '1505', '1569', '1811', '966', '1742', '31', '34', '36', '39', '378', '35', '1012', '1402', '1455', '1676', '385', '1141', '1168', '386', '626', '768', '986', '1372', '1373', '817', '850', '98', '1302', '1413', '1282', '1607', '338', '1410', '1773', '1782', '451', '1319', '1411', '1602', '837', '113', '352', '1259', '547', '573', '1021', '1145', '1733', '111', '148', '160', '508', '883', '1398', '108', '314', '375', '882', '1437', '1574', '285', '627', '1149', '1205', '1284', '1308', '1063', '1135', '198', '610', '1028', '1193', '1454', '1722', '37', '340', '1088', '1068', '1808', '30', '63', '286', '485', '1067', '1810', '526', '748', '970', '1157', '1320', '1321', '1323', '1325', '1412', '1579', '1711', '1461', '1586', '1809', '327', '348', '394', '406', '1492', '1801', '43', '390', '462', '582', '854', '1724', '38', '82', '116', '124', '223', '616', '1672', '1853', '590', '1027', '1108', '1208', '1571', '1575', '652', '119', '351', '1318', '1408', '1820', '1738', '114', '147', '944', '1139', '1266', '1486', '958', '1188', '1587', '75', '78', '81', '149', '441', '678', '683', '704', '884', '1772', '791', '1326', '1327', '1771', '201', '291', '325', '545', '1367', '4', '70', '105', '287', '401', '423', '580', '601', '1037', '1043', '1151', '1330', '1757', '722', '776', '790', '818', '988', '1040', '1073', '1289', '162', '335', '651', '658', '1019', '1552', '341', '389', '403', '1172', '1539', '1704', '1013', '1223', '1236', '1303', '1740', '639', '751', '796', '1029', '1715', '1743', '1758', '45', '123', '262', '266', '290', '852', '1035', '1160', '1163', '1206', '1344', '1426', '1474', '1526', '69', '84', '972', '1146', '1150', '1217', '1226', '1229', '1338', '1452', '1453', '1540', '1604', '1716', '417', '673', '1143', '1144', '1283', '1343', '1358', '1483', '1807', '1833', '405', '775', '795', '851', '905', '1048', '1136', '1293', '1448', '1746', '643', '717', '968', '1042', '1045', '1159', '1230', '1231', '1681', '1787', '324', '467', '503', '574', '1026', '1051', '1137', '1262', '1749', '1791', '483', '635', '1140', '1154', '1340', '1351', '1458', '1573', '1723', '1759', '1806', '663', '709', '885', '954', '1224', '1366', '1368', '1459', '1609', '1632', '1663', '1751', '559', '920', '973', '996', '1049', '1050', '1148', '1274', '1354', '1360', '1361', '1362', '1647', '1708', '1713', '1805', '666', '914', '921', '923', '927', '1025', '1044', '1072', '1090', '1095', '1196', '1339', '1601', '1673', '1714', '1788', '1823', '448', '886', '915', '916', '926', '930', '931', '1055', '1322', '1649', '1750', '1854', '208', '703', '924', '1047', '1052', '1596', '1650', '299', '300', '422', '665', '1004', '1020', '1036', '1039', '1054', '1225', '1245', '1352', '1451', '1580', '151', '453', '480', '937', '1109', '487', '672', '740', '888', '1152', '1256', '1301', '1409', '1449', '1730', '205', '671', '769', '821', '1232', '1445', '1519', '1816', '516', '707', '1005', '1060', '1294', '1792', '1821', '93', '150', '212', '420', '761', '932', '969', '1038', '1075', '74', '419', '656', '1071', '1138')) ORDER BY FIND_IN_SET(id, '1761,732,1744,726,1324,258,517,1588,780,737,1417,871,1717,855,1766,207,1572,404,454,977,1794,770,874,1291,1594,1359,1272,1134,738,1424,66,434,265,22,330,461,1199,21,393,553,332,1032,1768,28,333,716,1260,1419,1423,974,1422,1418,1420,1421,1682,766,1292,521,1237,1348,1415,797,349,715,585,711,455,1678,9,674,792,1132,407,657,25,163,439,11,739,1852,10,1460,857,858,1008,1233,1501,1677,3,24,520,542,1721,1822,1505,1569,1811,966,1742,31,34,36,39,378,35,1012,1402,1455,1676,385,1141,1168,386,626,768,986,1372,1373,817,850,98,1302,1413,1282,1607,338,1410,1773,1782,451,1319,1411,1602,837,113,352,1259,547,573,1021,1145,1733,111,148,160,508,883,1398,108,314,375,882,1437,1574,285,627,1149,1205,1284,1308,1063,1135,198,610,1028,1193,1454,1722,37,340,1088,1068,1808,30,63,286,485,1067,1810,526,748,970,1157,1320,1321,1323,1325,1412,1579,1711,1461,1586,1809,327,348,394,406,1492,1801,43,390,462,582,854,1724,38,82,116,124,223,616,1672,1853,590,1027,1108,1208,1571,1575,652,119,351,1318,1408,1820,1738,114,147,944,1139,1266,1486,958,1188,1587,75,78,81,149,441,678,683,704,884,1772,791,1326,1327,1771,201,291,325,545,1367,4,70,105,287,401,423,580,601,1037,1043,1151,1330,1757,722,776,790,818,988,1040,1073,1289,162,335,651,658,1019,1552,341,389,403,1172,1539,1704,1013,1223,1236,1303,1740,639,751,796,1029,1715,1743,1758,45,123,262,266,290,852,1035,1160,1163,1206,1344,1426,1474,1526,69,84,972,1146,1150,1217,1226,1229,1338,1452,1453,1540,1604,1716,417,673,1143,1144,1283,1343,1358,1483,1807,1833,405,775,795,851,905,1048,1136,1293,1448,1746,643,717,968,1042,1045,1159,1230,1231,1681,1787,324,467,503,574,1026,1051,1137,1262,1749,1791,483,635,1140,1154,1340,1351,1458,1573,1723,1759,1806,663,709,885,954,1224,1366,1368,1459,1609,1632,1663,1751,559,920,973,996,1049,1050,1148,1274,1354,1360,1361,1362,1647,1708,1713,1805,666,914,921,923,927,1025,1044,1072,1090,1095,1196,1339,1601,1673,1714,1788,1823,448,886,915,916,926,930,931,1055,1322,1649,1750,1854,208,703,924,1047,1052,1596,1650,299,300,422,665,1004,1020,1036,1039,1054,1225,1245,1352,1451,1580,151,453,480,937,1109,487,672,740,888,1152,1256,1301,1409,1449,1730,205,671,769,821,1232,1445,1519,1816,516,707,1005,1060,1294,1792,1821,93,150,212,420,761,932,969,1038,1075,74,419,656,1071,1138') 0.057365894317627
(622) DESCRIBE `cruisetypes` 0.0023138523101807
(623) DESCRIBE `destinations` 0.003737211227417
(624) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '22', '12', '54', '35', '25', '43', '2', '37', '9', '8', '44', '39', '55', '53', '26', '38', '28', '49', '40', '30', '11', '21', '45', '29', '7', '48', '34', '52', '10', '46', '56', '32')) ORDER BY FIND_IN_SET(id, '50,22,12,54,35,25,43,2,37,9,8,44,39,55,53,26,38,28,49,40,30,11,21,45,29,7,48,34,52,10,46,56,32') 0.0038189888000488