or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. 8 Romantic Destinations Around the World
  3. Royal Caribbean Launch “Royal Up”
  4. Catch Up on Cruising: Latest News in bite size!
  5. Drinks Package Comparison

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

Total elapsed time: 0.76726746559143

# Query Time
(1) connect 0.0010519027709961
(2) DESCRIBE `cruises` 0.0039560794830322
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (72067, 62665, 69258, 68317, 70032, 77397, 62653, 62661, 68316, 70031)) ORDER BY FIND_IN_SET(id, '72067,62665,69258,68317,70032,77397,62653,62661,68316,70031') 0.002561092376709
(4) DESCRIBE `cruises` 0.0039288997650146
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '72067') 0.00065898895263672
(6) DESCRIBE `ships` 0.0039279460906982
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 462))) 0.00060486793518066
(8) DESCRIBE `ships` 0.0033049583435059
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '462') 0.00048303604125977
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00057005882263184
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033998489379883
(12) DESCRIBE `itineraries` 0.0021281242370605
(13) DESCRIBE `ports` 0.0022220611572266
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00049614906311035
(15) DESCRIBE `ports` 0.0019700527191162
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00048184394836426
(17) DESCRIBE `ports` 0.0019478797912598
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00039005279541016
(19) DESCRIBE `sailingdates` 0.0016920566558838
(20) DESCRIBE `ports` 0.0019669532775879
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00042390823364258
(22) DESCRIBE `ports` 0.0019299983978271
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00045013427734375
(24) DESCRIBE `ports` 0.0017910003662109
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00043201446533203
(26) DESCRIBE `ports` 0.0019659996032715
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.0004580020904541
(28) DESCRIBE `ports` 0.0016031265258789
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00037693977355957
(30) DESCRIBE `ports` 0.0016331672668457
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00034308433532715
(32) DESCRIBE `ports` 0.001370906829834
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00035476684570312
(34) DESCRIBE `ports` 0.0014450550079346
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00029802322387695
(36) DESCRIBE `ports` 0.0019180774688721
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00074315071105957
(38) DESCRIBE `ports` 0.0022151470184326
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.0005791187286377
(40) DESCRIBE `ports` 0.0020599365234375
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00059413909912109
(42) DESCRIBE `ports` 0.0019338130950928
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00051498413085938
(44) DESCRIBE `ports` 0.0019829273223877
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00058913230895996
(46) DESCRIBE `ports` 0.0019381046295166
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00046110153198242
(48) DESCRIBE `ports` 0.0016069412231445
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00041007995605469
(50) DESCRIBE `ports` 0.0017828941345215
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.0004730224609375
(52) DESCRIBE `ports` 0.002234935760498
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00060296058654785
(54) DESCRIBE `ports` 0.002079963684082
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00045490264892578
(56) DESCRIBE `ports` 0.0020267963409424
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00050997734069824
(58) DESCRIBE `ports` 0.001978874206543
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00044417381286621
(60) DESCRIBE `avid_specials` 0.0018079280853271
(61) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 72067 and class = 'Cruise') OR (item_id = 462 AND class = 'Ship') OR (item_id = 19 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.0019700527191162
(62) DESCRIBE `cruiselines` 0.0027670860290527
(63) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00060510635375977
(64) DESCRIBE `orchid_image` 0.0020840167999268
(65) DESCRIBE `cruiselines` 0.0027379989624023
(66) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00047111511230469
(67) DESCRIBE `cruises` 0.0037949085235596
(68) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62665') 0.00054502487182617
(69) DESCRIBE `ships` 0.0039260387420654
(70) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00063705444335938
(71) DESCRIBE `ships` 0.0038371086120605
(72) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00052404403686523
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035214424133301
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034022331237793
(75) DESCRIBE `itineraries` 0.0020580291748047
(76) DESCRIBE `ports` 0.0019857883453369
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00078296661376953
(78) DESCRIBE `ports` 0.0019180774688721
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00047993659973145
(80) DESCRIBE `ports` 0.0014970302581787
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00032401084899902
(82) DESCRIBE `sailingdates` 0.0013017654418945
(83) DESCRIBE `ports` 0.0021781921386719
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00055599212646484
(85) DESCRIBE `ports` 0.0019609928131104
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00037097930908203
(87) DESCRIBE `ports` 0.0016591548919678
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00037622451782227
(89) DESCRIBE `ports` 0.001378059387207
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00034689903259277
(91) DESCRIBE `ports` 0.0015029907226562
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00037693977355957
(93) DESCRIBE `ports` 0.0013761520385742
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00030303001403809
(95) DESCRIBE `ports` 0.0013589859008789
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00039505958557129
(97) DESCRIBE `ports` 0.0015521049499512
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00033020973205566
(99) DESCRIBE `ports` 0.0015759468078613
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.0003960132598877
(101) DESCRIBE `ports` 0.0015020370483398
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00033783912658691
(103) DESCRIBE `ports` 0.001990795135498
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0004730224609375
(105) DESCRIBE `ports` 0.0019280910491943
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00044107437133789
(107) DESCRIBE `ports` 0.0019388198852539
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00044798851013184
(109) DESCRIBE `ports` 0.0019280910491943
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.0004279613494873
(111) DESCRIBE `avid_specials` 0.0015552043914795
(112) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62665 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 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.001284122467041
(113) DESCRIBE `cruiselines` 0.0022499561309814
(114) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00045204162597656
(115) DESCRIBE `orchid_image` 0.0016608238220215
(116) DESCRIBE `cruiselines` 0.0018548965454102
(117) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00037813186645508
(118) DESCRIBE `cruises` 0.0031571388244629
(119) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69258') 0.00040197372436523
(120) DESCRIBE `ships` 0.0032219886779785
(121) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 553))) 0.00057196617126465
(122) DESCRIBE `ships` 0.0034489631652832
(123) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '553') 0.00050806999206543
(124) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034904479980469
(125) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033092498779297
(126) DESCRIBE `itineraries` 0.0017478466033936
(127) DESCRIBE `ports` 0.0018379688262939
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00044894218444824
(129) DESCRIBE `ports` 0.0017871856689453
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00044703483581543
(131) DESCRIBE `ports` 0.0018551349639893
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.0004270076751709
(133) DESCRIBE `sailingdates` 0.0015270709991455
(134) DESCRIBE `ports` 0.001986026763916
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.00050711631774902
(136) DESCRIBE `ports` 0.0018279552459717
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00043892860412598
(138) DESCRIBE `ports` 0.0018339157104492
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 709))) 0.00048589706420898
(140) DESCRIBE `ports` 0.0018389225006104
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '709') 0.0004880428314209
(142) DESCRIBE `ports` 0.0018420219421387
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 709))) 0.00046896934509277
(144) DESCRIBE `ports` 0.0017499923706055
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '709') 0.00041818618774414
(146) DESCRIBE `ports` 0.0016469955444336
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 68))) 0.0004270076751709
(148) DESCRIBE `ports` 0.0016958713531494
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '68') 0.00044894218444824
(150) DESCRIBE `avid_specials` 0.0017030239105225
(151) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69258 and class = 'Cruise') OR (item_id = 553 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 52 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.0017240047454834
(152) DESCRIBE `cruiselines` 0.0027968883514404
(153) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00063109397888184
(154) DESCRIBE `orchid_image` 0.0022420883178711
(155) DESCRIBE `cruiselines` 0.0028619766235352
(156) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00062108039855957
(157) DESCRIBE `cruises` 0.0037829875946045
(158) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68317') 0.00075697898864746
(159) DESCRIBE `ships` 0.0041911602020264
(160) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1067))) 0.00064516067504883
(161) DESCRIBE `ships` 0.0041182041168213
(162) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1067') 0.0005800724029541
(163) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037193298339844
(164) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00053095817565918
(165) DESCRIBE `itineraries` 0.0020279884338379
(166) DESCRIBE `ports` 0.0023128986358643
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00052189826965332
(168) DESCRIBE `ports` 0.0020370483398438
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00046181678771973
(170) DESCRIBE `ports` 0.0020170211791992
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00043702125549316
(172) DESCRIBE `sailingdates` 0.0017359256744385
(173) DESCRIBE `ports` 0.0024609565734863
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00047993659973145
(175) DESCRIBE `ports` 0.0015008449554443
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00031399726867676
(177) DESCRIBE `ports` 0.0018889904022217
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00046801567077637
(179) DESCRIBE `ports` 0.0015120506286621
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00036311149597168
(181) DESCRIBE `ports` 0.0014278888702393
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 352))) 0.0003049373626709
(183) DESCRIBE `ports` 0.0015659332275391
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '352') 0.00036096572875977
(185) DESCRIBE `ports` 0.0015699863433838
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00040888786315918
(187) DESCRIBE `ports` 0.0016789436340332
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00044393539428711
(189) DESCRIBE `ports` 0.0019500255584717
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 663))) 0.00057196617126465
(191) DESCRIBE `ports` 0.0020918846130371
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '663') 0.00054693222045898
(193) DESCRIBE `ports` 0.0021669864654541
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00071382522583008
(195) DESCRIBE `ports` 0.0020649433135986
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00062799453735352
(197) DESCRIBE `ports` 0.0019259452819824
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00034904479980469
(199) DESCRIBE `ports` 0.0013749599456787
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00035595893859863
(201) DESCRIBE `ports` 0.0013689994812012
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00031805038452148
(203) DESCRIBE `ports` 0.001533031463623
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00030684471130371
(205) DESCRIBE `ports` 0.001378059387207
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00033712387084961
(207) DESCRIBE `ports` 0.0015871524810791
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00034880638122559
(209) DESCRIBE `ports` 0.0017600059509277
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00042819976806641
(211) DESCRIBE `ports` 0.0018529891967773
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00031709671020508
(213) DESCRIBE `ports` 0.0013899803161621
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 43))) 0.00035691261291504
(215) DESCRIBE `ports` 0.0016670227050781
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '43') 0.00035381317138672
(217) DESCRIBE `ports` 0.0016138553619385
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 55))) 0.00064277648925781
(219) DESCRIBE `ports` 0.002119779586792
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '55') 0.00043988227844238
(221) DESCRIBE `ports` 0.0020508766174316
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 308))) 0.00047183036804199
(223) DESCRIBE `ports` 0.0020360946655273
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '308') 0.00046205520629883
(225) DESCRIBE `ports` 0.0020430088043213
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 679))) 0.00051093101501465
(227) DESCRIBE `ports` 0.0019590854644775
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '679') 0.00036811828613281
(229) DESCRIBE `ports` 0.0017390251159668
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00040698051452637
(231) DESCRIBE `ports` 0.0017020702362061
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00032901763916016
(233) DESCRIBE `avid_specials` 0.0014569759368896
(234) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68317 and class = 'Cruise') OR (item_id = 1067 AND class = 'Ship') OR (item_id = 19 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.0012259483337402
(235) DESCRIBE `cruiselines` 0.0025579929351807
(236) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00052714347839355
(237) DESCRIBE `orchid_image` 0.0020649433135986
(238) DESCRIBE `cruiselines` 0.0033469200134277
(239) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00049805641174316
(240) DESCRIBE `cruises` 0.003964900970459
(241) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70032') 0.00052094459533691
(242) DESCRIBE `ships` 0.0038430690765381
(243) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1415))) 0.0006711483001709
(244) DESCRIBE `ships` 0.0048048496246338
(245) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1415') 0.00047922134399414
(246) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00033092498779297
(247) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.0002601146697998
(248) DESCRIBE `itineraries` 0.0018410682678223
(249) DESCRIBE `ports` 0.0019621849060059
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00048303604125977
(251) DESCRIBE `ports` 0.0020389556884766
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046706199645996
(253) DESCRIBE `ports` 0.0018389225006104
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00039482116699219
(255) DESCRIBE `sailingdates` 0.0014569759368896
(256) DESCRIBE `ports` 0.0018298625946045
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00051188468933105
(258) DESCRIBE `ports` 0.0015718936920166
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00040698051452637
(260) DESCRIBE `ports` 0.001788854598999
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.0004119873046875
(262) DESCRIBE `ports` 0.0018811225891113
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.0003960132598877
(264) DESCRIBE `ports` 0.0016448497772217
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00044417381286621
(266) DESCRIBE `ports` 0.0014708042144775
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00037693977355957
(268) DESCRIBE `ports` 0.0014050006866455
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00032210350036621
(270) DESCRIBE `ports` 0.0015828609466553
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00032901763916016
(272) DESCRIBE `ports` 0.0013899803161621
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00041103363037109
(274) DESCRIBE `ports` 0.0014138221740723
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00030183792114258
(276) DESCRIBE `ports` 0.0018200874328613
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00043487548828125
(278) DESCRIBE `ports` 0.0019500255584717
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00040292739868164
(280) DESCRIBE `ports` 0.0018560886383057
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00046396255493164
(282) DESCRIBE `ports` 0.0019011497497559
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00039410591125488
(284) DESCRIBE `ports` 0.0016341209411621
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00042510032653809
(286) DESCRIBE `ports` 0.0015320777893066
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00033807754516602
(288) DESCRIBE `ports` 0.0014328956604004
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 347))) 0.00041508674621582
(290) DESCRIBE `ports` 0.0015230178833008
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '347') 0.00038790702819824
(292) DESCRIBE `ports` 0.0015530586242676
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00039219856262207
(294) DESCRIBE `ports` 0.001884937286377
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00045418739318848
(296) DESCRIBE `ports` 0.0020749568939209
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00049901008605957
(298) DESCRIBE `ports` 0.0020701885223389
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.0004880428314209
(300) DESCRIBE `ports` 0.0019738674163818
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00052499771118164
(302) DESCRIBE `ports` 0.0018248558044434
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00048518180847168
(304) DESCRIBE `avid_specials` 0.001737117767334
(305) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70032 and class = 'Cruise') OR (item_id = 1415 AND class = 'Ship') OR (item_id = 19 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.0017378330230713
(306) DESCRIBE `cruiselines` 0.0025889873504639
(307) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00056099891662598
(308) DESCRIBE `orchid_image` 0.0020909309387207
(309) DESCRIBE `cruiselines` 0.0027840137481689
(310) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00042605400085449
(311) DESCRIBE `cruises` 0.0038061141967773
(312) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77397') 0.00044608116149902
(313) DESCRIBE `ships` 0.0030779838562012
(314) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 738))) 0.00060319900512695
(315) DESCRIBE `ships` 0.0028350353240967
(316) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '738') 0.00035190582275391
(317) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029683113098145
(318) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028800964355469
(319) DESCRIBE `itineraries` 0.0016589164733887
(320) DESCRIBE `ports` 0.0015499591827393
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00046610832214355
(322) DESCRIBE `ports` 0.001492977142334
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00039410591125488
(324) DESCRIBE `ports` 0.0013859272003174
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00031900405883789
(326) DESCRIBE `sailingdates` 0.0012500286102295
(327) DESCRIBE `ports` 0.0013909339904785
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00039505958557129
(329) DESCRIBE `ports` 0.0012948513031006
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00029182434082031
(331) DESCRIBE `ports` 0.0016300678253174
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.00042891502380371
(333) DESCRIBE `ports` 0.0018260478973389
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.00039386749267578
(335) DESCRIBE `ports` 0.0017869472503662
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3079))) 0.00044107437133789
(337) DESCRIBE `ports` 0.0018820762634277
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3079') 0.00042510032653809
(339) DESCRIBE `ports` 0.0018408298492432
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00043201446533203
(341) DESCRIBE `ports` 0.0020060539245605
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00047111511230469
(343) DESCRIBE `ports` 0.0021100044250488
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1064))) 0.00051999092102051
(345) DESCRIBE `ports` 0.0019609928131104
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1064') 0.00043797492980957
(347) DESCRIBE `ports` 0.0019881725311279
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.0005180835723877
(349) DESCRIBE `ports` 0.0020418167114258
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00035500526428223
(351) DESCRIBE `ports` 0.0017120838165283
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00060606002807617
(353) DESCRIBE `ports` 0.0017650127410889
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00044703483581543
(355) DESCRIBE `ports` 0.0019650459289551
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.00056791305541992
(357) DESCRIBE `ports` 0.0018699169158936
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.00042200088500977
(359) DESCRIBE `ports` 0.0018160343170166
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3079))) 0.00043606758117676
(361) DESCRIBE `ports` 0.0017788410186768
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3079') 0.00040411949157715
(363) DESCRIBE `ports` 0.0019030570983887
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2939))) 0.00043702125549316
(365) DESCRIBE `ports` 0.0015101432800293
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2939') 0.00032901763916016
(367) DESCRIBE `ports` 0.0013689994812012
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 816))) 0.00038909912109375
(369) DESCRIBE `ports` 0.0019569396972656
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '816') 0.00041699409484863
(371) DESCRIBE `ports` 0.0019669532775879
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00047397613525391
(373) DESCRIBE `ports` 0.0017027854919434
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00033378601074219
(375) DESCRIBE `ports` 0.0013928413391113
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.0003509521484375
(377) DESCRIBE `ports` 0.0013818740844727
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.0002899169921875
(379) DESCRIBE `avid_specials` 0.0012340545654297
(380) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77397 and class = 'Cruise') OR (item_id = 738 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 45 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.0011100769042969
(381) DESCRIBE `cruiselines` 0.0021798610687256
(382) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00039505958557129
(383) DESCRIBE `orchid_image` 0.0016520023345947
(384) DESCRIBE `cruiselines` 0.0023641586303711
(385) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00048995018005371
(386) DESCRIBE `cruises` 0.0028989315032959
(387) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62653') 0.00047802925109863
(388) DESCRIBE `ships` 0.0028789043426514
(389) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 738))) 0.0005638599395752
(390) DESCRIBE `ships` 0.0038430690765381
(391) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '738') 0.00056290626525879
(392) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035405158996582
(393) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035285949707031
(394) DESCRIBE `itineraries` 0.0021929740905762
(395) DESCRIBE `ports` 0.0019910335540771
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00039505958557129
(397) DESCRIBE `ports` 0.0016610622406006
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00038599967956543
(399) DESCRIBE `ports` 0.0015418529510498
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00032711029052734
(401) DESCRIBE `sailingdates` 0.0012450218200684
(402) DESCRIBE `ports` 0.0019152164459229
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.0003972053527832
(404) DESCRIBE `ports` 0.0023140907287598
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00047397613525391
(406) DESCRIBE `ports` 0.0018439292907715
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1725))) 0.00043702125549316
(408) DESCRIBE `ports` 0.001823902130127
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1725') 0.00038504600524902
(410) DESCRIBE `ports` 0.0017440319061279
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3079))) 0.00041007995605469
(412) DESCRIBE `ports` 0.0021529197692871
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3079') 0.0004429817199707
(414) DESCRIBE `ports` 0.0019350051879883
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.0004570484161377
(416) DESCRIBE `ports` 0.0020089149475098
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00048112869262695
(418) DESCRIBE `ports` 0.0019991397857666
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1064))) 0.00042605400085449
(420) DESCRIBE `ports` 0.0018789768218994
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1064') 0.00042605400085449
(422) DESCRIBE `ports` 0.0018610954284668
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.0004730224609375
(424) DESCRIBE `ports` 0.0017960071563721
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00037312507629395
(426) DESCRIBE `ports` 0.0015208721160889
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.0003960132598877
(428) DESCRIBE `ports` 0.0015771389007568
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00032520294189453
(430) DESCRIBE `avid_specials` 0.0013968944549561
(431) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62653 and class = 'Cruise') OR (item_id = 738 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 45 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.001676082611084
(432) DESCRIBE `cruiselines` 0.0027511119842529
(433) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00051212310791016
(434) DESCRIBE `orchid_image` 0.0018959045410156
(435) DESCRIBE `cruiselines` 0.0029811859130859
(436) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0005950927734375
(437) DESCRIBE `cruises` 0.003770112991333
(438) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62661') 0.00050592422485352
(439) DESCRIBE `ships` 0.0036580562591553
(440) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 0.00042891502380371
(441) DESCRIBE `ships` 0.0038681030273438
(442) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00050783157348633
(443) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036287307739258
(444) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035190582275391
(445) DESCRIBE `itineraries` 0.0022721290588379
(446) DESCRIBE `ports` 0.0021350383758545
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00054597854614258
(448) DESCRIBE `ports` 0.002032995223999
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00052690505981445
(450) DESCRIBE `ports` 0.0014550685882568
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00035595893859863
(452) DESCRIBE `sailingdates` 0.0018811225891113
(453) DESCRIBE `ports` 0.0020990371704102
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00041413307189941
(455) DESCRIBE `ports` 0.0015449523925781
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00031208992004395
(457) DESCRIBE `ports` 0.0016708374023438
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00033903121948242
(459) DESCRIBE `ports` 0.0013768672943115
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00039482116699219
(461) DESCRIBE `ports` 0.0015749931335449
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00041317939758301
(463) DESCRIBE `ports` 0.0014500617980957
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.0003209114074707
(465) DESCRIBE `ports` 0.0014669895172119
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00034189224243164
(467) DESCRIBE `ports` 0.0013930797576904
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00037193298339844
(469) DESCRIBE `ports` 0.0015509128570557
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00036406517028809
(471) DESCRIBE `ports` 0.0017609596252441
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00033879280090332
(473) DESCRIBE `ports` 0.0015220642089844
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00041604042053223
(475) DESCRIBE `ports` 0.0015339851379395
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00032901763916016
(477) DESCRIBE `ports` 0.0014698505401611
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00054407119750977
(479) DESCRIBE `ports` 0.0021040439605713
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00041103363037109
(481) DESCRIBE `avid_specials` 0.0016942024230957
(482) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62661 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 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.0018391609191895
(483) DESCRIBE `cruiselines` 0.0026991367340088
(484) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00056982040405273
(485) DESCRIBE `orchid_image` 0.002194881439209
(486) DESCRIBE `cruiselines` 0.0027170181274414
(487) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00042200088500977
(488) DESCRIBE `cruises` 0.0034589767456055
(489) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68316') 0.00046610832214355
(490) DESCRIBE `ships` 0.0035200119018555
(491) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1067))) 0.00055503845214844
(492) DESCRIBE `ships` 0.0036170482635498
(493) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1067') 0.0003969669342041
(494) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030303001403809
(495) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030279159545898
(496) DESCRIBE `itineraries` 0.0015640258789062
(497) DESCRIBE `ports` 0.0013408660888672
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00057792663574219
(499) DESCRIBE `ports` 0.0017049312591553
(500) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00046205520629883
(501) DESCRIBE `ports` 0.001755952835083
(502) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00045299530029297
(503) DESCRIBE `sailingdates` 0.0018529891967773
(504) DESCRIBE `ports` 0.0024261474609375
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00051999092102051
(506) DESCRIBE `ports` 0.0020170211791992
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00039196014404297
(508) DESCRIBE `ports` 0.0018448829650879
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1093))) 0.00051212310791016
(510) DESCRIBE `ports` 0.0018050670623779
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1093') 0.00039196014404297
(512) DESCRIBE `ports` 0.0018138885498047
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 352))) 0.00045490264892578
(514) DESCRIBE `ports` 0.0019979476928711
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '352') 0.00037407875061035
(516) DESCRIBE `ports` 0.0015139579772949
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00037813186645508
(518) DESCRIBE `ports` 0.0016310214996338
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00039792060852051
(520) DESCRIBE `ports` 0.0015449523925781
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 663))) 0.00036191940307617
(522) DESCRIBE `ports` 0.001615047454834
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '663') 0.00033211708068848
(524) DESCRIBE `ports` 0.0018429756164551
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 365))) 0.00044512748718262
(526) DESCRIBE `ports` 0.0017068386077881
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '365') 0.00035595893859863
(528) DESCRIBE `ports` 0.0015618801116943
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 349))) 0.00035309791564941
(530) DESCRIBE `ports` 0.0017750263214111
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '349') 0.00036001205444336
(532) DESCRIBE `ports` 0.0017240047454834
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 667))) 0.00047707557678223
(534) DESCRIBE `ports` 0.001945972442627
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '667') 0.00032901763916016
(536) DESCRIBE `avid_specials` 0.0012319087982178
(537) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68316 and class = 'Cruise') OR (item_id = 1067 AND class = 'Ship') OR (item_id = 19 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.0010809898376465
(538) DESCRIBE `cruiselines` 0.0018620491027832
(539) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00047397613525391
(540) DESCRIBE `orchid_image` 0.0018160343170166
(541) DESCRIBE `cruiselines` 0.0027101039886475
(542) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00037598609924316
(543) DESCRIBE `cruises` 0.0031330585479736
(544) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70031') 0.00047588348388672
(545) DESCRIBE `ships` 0.0031590461730957
(546) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1415))) 0.00046896934509277
(547) DESCRIBE `ships` 0.0030150413513184
(548) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1415') 0.00050497055053711
(549) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00035405158996582
(550) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00034785270690918
(551) DESCRIBE `itineraries` 0.0017750263214111
(552) DESCRIBE `ports` 0.0021309852600098
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00040292739868164
(554) DESCRIBE `ports` 0.0020151138305664
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00047397613525391
(556) DESCRIBE `ports` 0.0019059181213379
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00044083595275879
(558) DESCRIBE `sailingdates` 0.0016970634460449
(559) DESCRIBE `ports` 0.0023219585418701
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0005800724029541
(561) DESCRIBE `ports` 0.0020179748535156
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0003960132598877
(563) DESCRIBE `ports` 0.0018310546875
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00041985511779785
(565) DESCRIBE `ports` 0.0018160343170166
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00038504600524902
(567) DESCRIBE `ports` 0.0021481513977051
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00040483474731445
(569) DESCRIBE `ports` 0.0018379688262939
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00036001205444336
(571) DESCRIBE `ports` 0.0017809867858887
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00040078163146973
(573) DESCRIBE `ports` 0.0019228458404541
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.0003969669342041
(575) DESCRIBE `ports` 0.0020909309387207
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.0010130405426025
(577) DESCRIBE `ports` 0.0017988681793213
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00037813186645508
(579) DESCRIBE `ports` 0.0016820430755615
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00053787231445312
(581) DESCRIBE `ports` 0.0016930103302002
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0004119873046875
(583) DESCRIBE `avid_specials` 0.0019059181213379
(584) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70031 and class = 'Cruise') OR (item_id = 1415 AND class = 'Ship') OR (item_id = 19 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.0018880367279053
(585) DESCRIBE `cruiselines` 0.0027730464935303
(586) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00048995018005371
(587) DESCRIBE `orchid_image` 0.0020887851715088
(588) DESCRIBE `cruiselines` 0.0026857852935791
(589) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00043892860412598
(590) DESCRIBE `ships` 0.0039949417114258
(591) SELECT `ships`.* FROM `ships` WHERE (id IN ('977', '1599', '1588', '726', '1359', '1067', '1768', '407', '674', '1415', '452', '462', '610', '766', '553', '1717', '352', '738')) ORDER BY FIND_IN_SET(id, '977,1599,1588,726,1359,1067,1768,407,674,1415,452,462,610,766,553,1717,352,738') 0.0027110576629639
(592) DESCRIBE `cruisetypes` 0.0015950202941895
(593) DESCRIBE `destinations` 0.0032520294189453
(594) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '37', '26', '25', '52', '45', '38', '28', '40', '9', '49', '11', '21', '35')) ORDER BY FIND_IN_SET(id, '22,12,37,26,25,52,45,38,28,40,9,49,11,21,35') 0.0016329288482666
(595) DESCRIBE `cruiselines` 0.0026481151580811
(596) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00049304962158203
(597) DESCRIBE `cruiselines` 0.0029590129852295
(598) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00055885314941406