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

Total elapsed time: 1.8844077587128

# Query Time
(1) connect 0.0012838840484619
(2) DESCRIBE `cruises` 0.0040268898010254
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (76745, 78344, 78345, 78345, 63785, 63785, 79234, 78346, 79285, 79236)) ORDER BY FIND_IN_SET(id, '76745,78344,78345,78345,63785,63785,79234,78346,79285,79236') 0.0038979053497314
(4) DESCRIBE `cruises` 0.0049400329589844
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '76745') 0.00044608116149902
(6) DESCRIBE `ships` 0.0043859481811523
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 547))) 0.00066280364990234
(8) DESCRIBE `ships` 0.004951000213623
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '547') 0.00041699409484863
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00041484832763672
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00039315223693848
(12) DESCRIBE `itineraries` 0.0025050640106201
(13) DESCRIBE `ports` 0.016145944595337
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048589706420898
(15) DESCRIBE `ports` 0.0026931762695312
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048112869262695
(17) DESCRIBE `ports` 0.0028419494628906
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0064659118652344
(19) DESCRIBE `sailingdates` 0.002047061920166
(20) DESCRIBE `ports` 0.0025498867034912
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0027730464935303
(22) DESCRIBE `ports` 0.0026249885559082
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041317939758301
(24) DESCRIBE `ports` 0.00205397605896
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00045084953308105
(26) DESCRIBE `ports` 0.0020577907562256
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00040006637573242
(28) DESCRIBE `ports` 0.0093460083007812
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.009260892868042
(30) DESCRIBE `ports` 0.0019049644470215
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00038385391235352
(32) DESCRIBE `ports` 0.0018799304962158
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00040006637573242
(34) DESCRIBE `ports` 0.0020089149475098
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.0068562030792236
(36) DESCRIBE `ports` 0.0019111633300781
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00051188468933105
(38) DESCRIBE `ports` 0.0027701854705811
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.0039072036743164
(40) DESCRIBE `ports` 0.0055921077728271
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.0004429817199707
(42) DESCRIBE `ports` 0.0072281360626221
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.0005030632019043
(44) DESCRIBE `ports` 0.004227876663208
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.0034019947052002
(46) DESCRIBE `ports` 0.0019800662994385
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.0025861263275146
(48) DESCRIBE `ports` 0.0018630027770996
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.0068888664245605
(50) DESCRIBE `ports` 0.0018749237060547
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00048279762268066
(52) DESCRIBE `ports` 0.002708911895752
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.0054690837860107
(54) DESCRIBE `ports` 0.0017991065979004
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.0032930374145508
(56) DESCRIBE `ports` 0.00193190574646
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.0039658546447754
(58) DESCRIBE `ports` 0.0023410320281982
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.0049099922180176
(60) DESCRIBE `ports` 0.0029051303863525
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00518798828125
(62) DESCRIBE `ports` 0.0022380352020264
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.0045669078826904
(64) DESCRIBE `ports` 0.0032269954681396
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0043489933013916
(66) DESCRIBE `ports` 0.0053839683532715
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0074670314788818
(68) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '76745') AND (sailingdate >= '2019-11-09') AND (sailingdate <= '2020-02-01') 0.022235155105591
(69) DESCRIBE `avid_specials` 0.0070490837097168
(70) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 76745 and class = 'Cruise') OR (item_id = 547 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 43 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.0022871494293213
(71) DESCRIBE `cruiselines` 0.0082859992980957
(72) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.0049247741699219
(73) DESCRIBE `orchid_image` 0.0070979595184326
(74) DESCRIBE `cruiselines` 0.0082910060882568
(75) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00055193901062012
(76) DESCRIBE `cruises` 0.0073878765106201
(77) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78344') 0.0081088542938232
(78) DESCRIBE `ships` 0.0050780773162842
(79) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 75))) 0.0074501037597656
(80) DESCRIBE `ships` 0.013456106185913
(81) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '75') 0.0015029907226562
(82) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0042581558227539
(83) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00052690505981445
(84) DESCRIBE `itineraries` 0.0025749206542969
(85) DESCRIBE `ports` 0.007659912109375
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.001622200012207
(87) DESCRIBE `ports` 0.0064361095428467
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0018088817596436
(89) DESCRIBE `ports` 0.0066289901733398
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00061607360839844
(91) DESCRIBE `sailingdates` 0.0096900463104248
(92) DESCRIBE `ports` 0.0027279853820801
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0024590492248535
(94) DESCRIBE `ports` 0.0090219974517822
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00064206123352051
(96) DESCRIBE `ports` 0.0023760795593262
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0070021152496338
(98) DESCRIBE `ports` 0.0024399757385254
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00049686431884766
(100) DESCRIBE `ports` 0.0023050308227539
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4208))) 0.0053219795227051
(102) DESCRIBE `ports` 0.0024888515472412
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4208') 0.0061898231506348
(104) DESCRIBE `ports` 0.0024919509887695
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.0062730312347412
(106) DESCRIBE `ports` 0.0026240348815918
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.0017790794372559
(108) DESCRIBE `ports` 0.0024740695953369
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4650))) 0.0042479038238525
(110) DESCRIBE `ports` 0.008030891418457
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4650') 0.0018370151519775
(112) DESCRIBE `ports` 0.0099868774414062
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1319))) 0.00055789947509766
(114) DESCRIBE `ports` 0.0025560855865479
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1319') 0.00052285194396973
(116) DESCRIBE `ports` 0.0024149417877197
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5306))) 0.00058197975158691
(118) DESCRIBE `ports` 0.0025990009307861
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5306') 0.00054812431335449
(120) DESCRIBE `ports` 0.0086328983306885
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.0005791187286377
(122) DESCRIBE `ports` 0.0025169849395752
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00060319900512695
(124) DESCRIBE `ports` 0.0025420188903809
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 121))) 0.00636887550354
(126) DESCRIBE `ports` 0.0034801959991455
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '121') 0.0006868839263916
(128) DESCRIBE `ports` 0.0025439262390137
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00072598457336426
(130) DESCRIBE `ports` 0.0024499893188477
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00052094459533691
(132) DESCRIBE `ports` 0.016813039779663
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00050687789916992
(134) DESCRIBE `ports` 0.0021741390228271
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.0004270076751709
(136) DESCRIBE `ports` 0.0024199485778809
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0067908763885498
(138) DESCRIBE `ports` 0.0028889179229736
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044798851013184
(140) DESCRIBE `ports` 0.0019619464874268
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00045919418334961
(142) DESCRIBE `ports` 0.0018119812011719
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.0030310153961182
(144) DESCRIBE `ports` 0.0026211738586426
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00063896179199219
(146) DESCRIBE `ports` 0.0024371147155762
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.0036909580230713
(148) DESCRIBE `ports` 0.0020661354064941
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 419))) 0.0082130432128906
(150) DESCRIBE `ports` 0.0019748210906982
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '419') 0.00039005279541016
(152) DESCRIBE `ports` 0.0020627975463867
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1044))) 0.00050497055053711
(154) DESCRIBE `ports` 0.0019330978393555
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1044') 0.00036406517028809
(156) DESCRIBE `ports` 0.0076642036437988
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00046205520629883
(158) DESCRIBE `ports` 0.0022470951080322
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00038290023803711
(160) DESCRIBE `ports` 0.0018661022186279
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1341))) 0.0075149536132812
(162) DESCRIBE `ports` 0.0019857883453369
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1341') 0.0004119873046875
(164) DESCRIBE `ports` 0.00211501121521
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.0005180835723877
(166) DESCRIBE `ports` 0.0091109275817871
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00037407875061035
(168) DESCRIBE `ports` 0.0018110275268555
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 88))) 0.00041317939758301
(170) DESCRIBE `ports` 0.0020790100097656
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '88') 0.00055384635925293
(172) DESCRIBE `ports` 0.0022609233856201
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.0089399814605713
(174) DESCRIBE `ports` 0.001896858215332
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00045490264892578
(176) DESCRIBE `ports` 0.0023541450500488
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1758))) 0.00041007995605469
(178) DESCRIBE `ports` 0.0020239353179932
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1758') 0.0003969669342041
(180) DESCRIBE `ports` 0.0018379688262939
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0077309608459473
(182) DESCRIBE `ports` 0.0026290416717529
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00046491622924805
(184) DESCRIBE `ports` 0.0061240196228027
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00052285194396973
(186) DESCRIBE `ports` 0.0037121772766113
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.0011661052703857
(188) DESCRIBE `ports` 0.004065990447998
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00589919090271
(190) DESCRIBE `ports` 0.005094051361084
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00041079521179199
(192) DESCRIBE `ports` 0.009131908416748
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00065302848815918
(194) DESCRIBE `ports` 0.0025458335876465
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00048089027404785
(196) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '78344') AND (sailingdate >= '2019-11-09') AND (sailingdate <= '2020-02-01') 0.0059120655059814
(197) DESCRIBE `avid_specials` 0.0019450187683105
(198) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78344 and class = 'Cruise') OR (item_id = 75 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 43 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.001215934753418
(199) DESCRIBE `cruiselines` 0.0030748844146729
(200) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00045299530029297
(201) DESCRIBE `orchid_image` 0.01319694519043
(202) DESCRIBE `cruiselines` 0.0080969333648682
(203) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.0018539428710938
(204) DESCRIBE `specials` 0.0052099227905273
(205) DESCRIBE `specials` 0.011078119277954
(206) DESCRIBE `specials` 0.013123035430908
(207) DESCRIBE `cruises` 0.0099551677703857
(208) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78345') 0.00053095817565918
(209) DESCRIBE `specials` 0.011684894561768
(210) DESCRIBE `ships` 0.0078239440917969
(211) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 75))) 0.0069708824157715
(212) DESCRIBE `ships` 0.0043070316314697
(213) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '75') 0.00050497055053711
(214) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00047206878662109
(215) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00040292739868164
(216) DESCRIBE `itineraries` 0.0021438598632812
(217) DESCRIBE `ports` 0.0091648101806641
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00052595138549805
(219) DESCRIBE `ports` 0.0021049976348877
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.002251148223877
(221) DESCRIBE `ports` 0.010089159011841
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00052094459533691
(223) DESCRIBE `specials` 0.015020847320557
(224) DESCRIBE `sailingdates` 0.0020999908447266
(225) DESCRIBE `ports` 0.0083060264587402
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0010249614715576
(227) DESCRIBE `ports` 0.0023560523986816
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00046300888061523
(229) DESCRIBE `ports` 0.0021610260009766
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0078251361846924
(231) DESCRIBE `ports` 0.0023050308227539
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00048995018005371
(233) DESCRIBE `ports` 0.0021250247955322
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4208))) 0.00053596496582031
(235) DESCRIBE `ports` 0.0070347785949707
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4208') 0.00055599212646484
(237) DESCRIBE `ports` 0.0021531581878662
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.010396957397461
(239) DESCRIBE `ports` 0.0023388862609863
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.00045418739318848
(241) DESCRIBE `ports` 0.0021488666534424
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4650))) 0.00050711631774902
(243) DESCRIBE `ports` 0.0021588802337646
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4650') 0.0004429817199707
(245) DESCRIBE `ports` 0.0020968914031982
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1319))) 0.00062203407287598
(247) DESCRIBE `ports` 0.0021929740905762
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1319') 0.00045013427734375
(249) DESCRIBE `ports` 0.0021131038665771
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5306))) 0.00048494338989258
(251) DESCRIBE `ports` 0.0020899772644043
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5306') 0.00045895576477051
(253) DESCRIBE `ports` 0.0020260810852051
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.0005190372467041
(255) DESCRIBE `ports` 0.002065896987915
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00045084953308105
(257) DESCRIBE `ports` 0.0022199153900146
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 121))) 0.00043010711669922
(259) DESCRIBE `ports` 0.0024678707122803
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '121') 0.00053095817565918
(261) DESCRIBE `ports` 0.0026159286499023
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.0006401538848877
(263) DESCRIBE `ports` 0.0026829242706299
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00066900253295898
(265) DESCRIBE `ports` 0.0026581287384033
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00059199333190918
(267) DESCRIBE `ports` 0.0026648044586182
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00055193901062012
(269) DESCRIBE `ports` 0.0026018619537354
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00058507919311523
(271) DESCRIBE `ports` 0.0024580955505371
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00047898292541504
(273) DESCRIBE `specials` 0.0061769485473633
(274) DESCRIBE `specials` 0.0055389404296875
(275) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '78345') AND (sailingdate >= '2019-11-09') AND (sailingdate <= '2020-02-01') 0.007641077041626
(276) DESCRIBE `avid_specials` 0.0019021034240723
(277) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78345 and class = 'Cruise') OR (item_id = 75 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 43 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.001762866973877
(278) DESCRIBE `cruiselines` 0.0029819011688232
(279) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00052690505981445
(280) DESCRIBE `orchid_image` 0.0022411346435547
(281) DESCRIBE `cruiselines` 0.0032222270965576
(282) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00047087669372559
(283) DESCRIBE `specials` 0.0055060386657715
(284) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78345') 0.00061297416687012
(285) DESCRIBE `ships` 0.0034770965576172
(286) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 75))) 0.00043797492980957
(287) DESCRIBE `ships` 0.0038368701934814
(288) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '75') 0.00042414665222168
(289) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035786628723145
(290) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003819465637207
(291) DESCRIBE `itineraries` 0.0023729801177979
(292) DESCRIBE `ports` 0.0023620128631592
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004880428314209
(294) DESCRIBE `ports` 0.0018019676208496
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00059914588928223
(296) DESCRIBE `ports` 0.0018489360809326
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00051212310791016
(298) DESCRIBE `sailingdates` 0.0018959045410156
(299) DESCRIBE `ports` 0.0020699501037598
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042104721069336
(301) DESCRIBE `ports` 0.0020391941070557
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00042605400085449
(303) DESCRIBE `ports` 0.0018789768218994
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00054192543029785
(305) DESCRIBE `ports` 0.0018739700317383
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00043511390686035
(307) DESCRIBE `ports` 0.0017719268798828
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4208))) 0.00044703483581543
(309) DESCRIBE `ports` 0.0018389225006104
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4208') 0.00043892860412598
(311) DESCRIBE `ports` 0.0022258758544922
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.00047707557678223
(313) DESCRIBE `ports` 0.0019681453704834
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.00046896934509277
(315) DESCRIBE `ports` 0.0018770694732666
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4650))) 0.00055193901062012
(317) DESCRIBE `ports` 0.0017859935760498
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4650') 0.00041508674621582
(319) DESCRIBE `ports` 0.0019290447235107
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1319))) 0.00042605400085449
(321) DESCRIBE `ports` 0.0019328594207764
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1319') 0.00063920021057129
(323) DESCRIBE `ports` 0.0023658275604248
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5306))) 0.00046205520629883
(325) DESCRIBE `ports` 0.0021231174468994
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5306') 0.00048995018005371
(327) DESCRIBE `ports` 0.0019600391387939
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00057005882263184
(329) DESCRIBE `ports` 0.0020670890808105
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00051093101501465
(331) DESCRIBE `ports` 0.0023510456085205
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 121))) 0.00045990943908691
(333) DESCRIBE `ports` 0.0019068717956543
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '121') 0.00048613548278809
(335) DESCRIBE `ports` 0.0023238658905029
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00044798851013184
(337) DESCRIBE `ports` 0.0023961067199707
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00039815902709961
(339) DESCRIBE `ports` 0.0019500255584717
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00039982795715332
(341) DESCRIBE `ports` 0.001798152923584
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00044608116149902
(343) DESCRIBE `ports` 0.0017750263214111
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044798851013184
(345) DESCRIBE `ports` 0.0018379688262939
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00046491622924805
(347) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '78345') AND (sailingdate >= '2019-11-09') AND (sailingdate <= '2020-02-01') 0.0056169033050537
(348) DESCRIBE `avid_specials` 0.0017938613891602
(349) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78345 and class = 'Cruise') OR (item_id = 75 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 43 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.0012941360473633
(350) DESCRIBE `cruiselines` 0.0028059482574463
(351) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00049304962158203
(352) DESCRIBE `orchid_image` 0.0021378993988037
(353) DESCRIBE `cruiselines` 0.0028269290924072
(354) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00049901008605957
(355) DESCRIBE `specials` 0.0071010589599609
(356) DESCRIBE `specials` 0.0056569576263428
(357) DESCRIBE `specials` 0.0056049823760986
(358) DESCRIBE `cruises` 0.0042910575866699
(359) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63785') 0.00060200691223145
(360) DESCRIBE `specials` 0.0074279308319092
(361) DESCRIBE `ships` 0.0061979293823242
(362) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 547))) 0.0009000301361084
(363) DESCRIBE `ships` 0.0058419704437256
(364) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '547') 0.0007021427154541
(365) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0005800724029541
(366) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00057101249694824
(367) DESCRIBE `itineraries` 0.0030710697174072
(368) DESCRIBE `ports` 0.0033528804779053
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0006709098815918
(370) DESCRIBE `ports` 0.002875804901123
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00071191787719727
(372) DESCRIBE `ports` 0.0030150413513184
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00063776969909668
(374) DESCRIBE `specials` 0.0078668594360352
(375) DESCRIBE `sailingdates` 0.0028398036956787
(376) DESCRIBE `ports` 0.0031139850616455
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.000701904296875
(378) DESCRIBE `ports` 0.0029611587524414
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00064492225646973
(380) DESCRIBE `ports` 0.0029749870300293
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00069093704223633
(382) DESCRIBE `ports` 0.002903938293457
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00061702728271484
(384) DESCRIBE `ports` 0.0029067993164062
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00062203407287598
(386) DESCRIBE `ports` 0.0029349327087402
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00058698654174805
(388) DESCRIBE `ports` 0.0029690265655518
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00085210800170898
(390) DESCRIBE `ports` 0.0030238628387451
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00069499015808105
(392) DESCRIBE `ports` 0.0028748512268066
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00068998336791992
(394) DESCRIBE `ports` 0.0029690265655518
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00063419342041016
(396) DESCRIBE `ports` 0.0030159950256348
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00069093704223633
(398) DESCRIBE `ports` 0.0028560161590576
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.0006110668182373
(400) DESCRIBE `ports` 0.0028128623962402
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00064611434936523
(402) DESCRIBE `ports` 0.002938985824585
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00059199333190918
(404) DESCRIBE `ports` 0.0028750896453857
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00069403648376465
(406) DESCRIBE `ports` 0.0027840137481689
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00066709518432617
(408) DESCRIBE `ports` 0.0028131008148193
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00075292587280273
(410) DESCRIBE `ports` 0.0028610229492188
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00059390068054199
(412) DESCRIBE `ports` 0.0028419494628906
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00064802169799805
(414) DESCRIBE `ports` 0.0028109550476074
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00069999694824219
(416) DESCRIBE `ports` 0.0027561187744141
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00065016746520996
(418) DESCRIBE `ports` 0.0028731822967529
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00057196617126465
(420) DESCRIBE `specials` 0.0077109336853027
(421) DESCRIBE `specials` 0.007720947265625
(422) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63785') AND (sailingdate >= '2019-11-09') AND (sailingdate <= '2020-02-01') 0.010028123855591
(423) DESCRIBE `avid_specials` 0.0026462078094482
(424) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63785 and class = 'Cruise') OR (item_id = 547 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 43 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.0021750926971436
(425) DESCRIBE `cruiselines` 0.0038940906524658
(426) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00067019462585449
(427) DESCRIBE `orchid_image` 0.0031089782714844
(428) DESCRIBE `cruiselines` 0.0039570331573486
(429) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00062417984008789
(430) DESCRIBE `specials` 0.0077340602874756
(431) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63785') 0.00062990188598633
(432) DESCRIBE `ships` 0.0055739879608154
(433) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 547))) 0.00078797340393066
(434) DESCRIBE `ships` 0.0055561065673828
(435) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '547') 0.00063300132751465
(436) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00052499771118164
(437) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00051498413085938
(438) DESCRIBE `itineraries` 0.0027730464935303
(439) DESCRIBE `ports` 0.0029819011688232
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00064802169799805
(441) DESCRIBE `ports` 0.0028350353240967
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00062704086303711
(443) DESCRIBE `ports` 0.0027828216552734
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00058102607727051
(445) DESCRIBE `sailingdates` 0.0024080276489258
(446) DESCRIBE `ports` 0.0029590129852295
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00068306922912598
(448) DESCRIBE `ports` 0.0029828548431396
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00063514709472656
(450) DESCRIBE `ports` 0.0028810501098633
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00066804885864258
(452) DESCRIBE `ports` 0.002924919128418
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00062298774719238
(454) DESCRIBE `ports` 0.002877950668335
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00059986114501953
(456) DESCRIBE `ports` 0.0029120445251465
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00057005882263184
(458) DESCRIBE `ports` 0.0027859210968018
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00050210952758789
(460) DESCRIBE `ports` 0.0018830299377441
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00042605400085449
(462) DESCRIBE `ports` 0.0017578601837158
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00040698051452637
(464) DESCRIBE `ports` 0.0018761157989502
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.0004429817199707
(466) DESCRIBE `ports` 0.0019159317016602
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00040507316589355
(468) DESCRIBE `ports` 0.0019857883453369
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00037097930908203
(470) DESCRIBE `ports` 0.0018589496612549
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00042510032653809
(472) DESCRIBE `ports` 0.0018770694732666
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00038504600524902
(474) DESCRIBE `ports` 0.0018231868743896
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00045609474182129
(476) DESCRIBE `ports` 0.001784086227417
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.0003659725189209
(478) DESCRIBE `ports` 0.0017430782318115
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00040316581726074
(480) DESCRIBE `ports` 0.0019791126251221
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.0003669261932373
(482) DESCRIBE `ports` 0.0018801689147949
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00040197372436523
(484) DESCRIBE `ports` 0.0017631053924561
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0003669261932373
(486) DESCRIBE `ports` 0.0017509460449219
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040411949157715
(488) DESCRIBE `ports` 0.0018041133880615
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038290023803711
(490) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63785') AND (sailingdate >= '2019-11-09') AND (sailingdate <= '2020-02-01') 0.0052778720855713
(491) DESCRIBE `avid_specials` 0.0015988349914551
(492) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63785 and class = 'Cruise') OR (item_id = 547 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 43 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.0010981559753418
(493) DESCRIBE `cruiselines` 0.0027239322662354
(494) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00060701370239258
(495) DESCRIBE `orchid_image` 0.0021369457244873
(496) DESCRIBE `cruiselines` 0.0024409294128418
(497) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00046706199645996
(498) DESCRIBE `cruises` 0.003605842590332
(499) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79234') 0.00040721893310547
(500) DESCRIBE `ships` 0.0036900043487549
(501) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 75))) 0.00047612190246582
(502) DESCRIBE `ships` 0.0035018920898438
(503) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '75') 0.00039100646972656
(504) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035500526428223
(505) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034594535827637
(506) DESCRIBE `itineraries` 0.0017979145050049
(507) DESCRIBE `ports` 0.0018749237060547
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00057101249694824
(509) DESCRIBE `ports` 0.0021641254425049
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041007995605469
(511) DESCRIBE `ports` 0.0017549991607666
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038290023803711
(513) DESCRIBE `sailingdates` 0.0016281604766846
(514) DESCRIBE `ports` 0.0017638206481934
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042605400085449
(516) DESCRIBE `ports` 0.0018007755279541
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00050806999206543
(518) DESCRIBE `ports` 0.0018379688262939
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00043201446533203
(520) DESCRIBE `ports` 0.0017881393432617
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00053906440734863
(522) DESCRIBE `ports` 0.0017588138580322
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00040984153747559
(524) DESCRIBE `ports` 0.0018770694732666
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00037503242492676
(526) DESCRIBE `ports` 0.0021398067474365
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 419))) 0.00062394142150879
(528) DESCRIBE `ports` 0.0025100708007812
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '419') 0.0003809928894043
(530) DESCRIBE `ports` 0.0018589496612549
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1044))) 0.00041794776916504
(532) DESCRIBE `ports` 0.0017950534820557
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1044') 0.00035405158996582
(534) DESCRIBE `ports` 0.0019547939300537
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00042200088500977
(536) DESCRIBE `ports` 0.0018651485443115
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00035381317138672
(538) DESCRIBE `ports` 0.0018000602722168
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1341))) 0.00040793418884277
(540) DESCRIBE `ports` 0.0022428035736084
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1341') 0.00041103363037109
(542) DESCRIBE `ports` 0.0018119812011719
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00039815902709961
(544) DESCRIBE `ports` 0.0018758773803711
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00037193298339844
(546) DESCRIBE `ports` 0.001777172088623
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 88))) 0.00044488906860352
(548) DESCRIBE `ports` 0.0019700527191162
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '88') 0.00037097930908203
(550) DESCRIBE `ports` 0.0018908977508545
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00038790702819824
(552) DESCRIBE `ports` 0.0019228458404541
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00037097930908203
(554) DESCRIBE `ports` 0.0022358894348145
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1758))) 0.00041294097900391
(556) DESCRIBE `ports` 0.0018208026885986
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1758') 0.00037217140197754
(558) DESCRIBE `ports` 0.0018959045410156
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00040888786315918
(560) DESCRIBE `ports` 0.0019369125366211
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00043392181396484
(562) DESCRIBE `ports` 0.0020220279693604
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00038814544677734
(564) DESCRIBE `ports` 0.0019359588623047
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00044608116149902
(566) DESCRIBE `ports` 0.0018019676208496
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00041484832763672
(568) DESCRIBE `ports` 0.0019979476928711
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00037097930908203
(570) DESCRIBE `ports` 0.0019650459289551
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047993659973145
(572) DESCRIBE `ports` 0.004626989364624
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00082802772521973
(574) DESCRIBE `ports` 0.0023341178894043
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2086))) 0.00062799453735352
(576) DESCRIBE `ports` 0.0024771690368652
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2086') 0.0006868839263916
(578) DESCRIBE `ports` 0.0028648376464844
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00061488151550293
(580) DESCRIBE `ports` 0.0027041435241699
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00047397613525391
(582) DESCRIBE `ports` 0.0022540092468262
(583) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.0005490779876709
(584) DESCRIBE `ports` 0.0020520687103271
(585) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00039219856262207
(586) DESCRIBE `ports` 0.002047061920166
(587) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00047612190246582
(588) DESCRIBE `ports` 0.0021011829376221
(589) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00059008598327637
(590) DESCRIBE `ports` 0.0027520656585693
(591) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.00060009956359863
(592) DESCRIBE `ports` 0.0027880668640137
(593) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.00057601928710938
(594) DESCRIBE `ports` 0.0025711059570312
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00056695938110352
(596) DESCRIBE `ports` 0.0024981498718262
(597) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00049901008605957
(598) DESCRIBE `ports` 0.0018520355224609
(599) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00051403045654297
(600) DESCRIBE `ports` 0.0026628971099854
(601) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00059080123901367
(602) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '79234') AND (sailingdate >= '2019-11-09') AND (sailingdate <= '2020-02-01') 0.0058691501617432
(603) DESCRIBE `avid_specials` 0.0018949508666992
(604) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 79234 and class = 'Cruise') OR (item_id = 75 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 43 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.0015130043029785
(605) DESCRIBE `cruiselines` 0.0028688907623291
(606) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00049090385437012
(607) DESCRIBE `orchid_image` 0.0020630359649658
(608) DESCRIBE `cruiselines` 0.0035171508789062
(609) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.0005500316619873
(610) DESCRIBE `cruises` 0.0046420097351074
(611) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '78346') 0.00054502487182617
(612) DESCRIBE `ships` 0.0048789978027344
(613) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 75))) 0.00065398216247559
(614) DESCRIBE `ships` 0.0049118995666504
(615) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '75') 0.00055599212646484
(616) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00046682357788086
(617) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00052309036254883
(618) DESCRIBE `itineraries` 0.00242018699646
(619) DESCRIBE `ports` 0.0026140213012695
(620) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00060510635375977
(621) DESCRIBE `ports` 0.0024209022521973
(622) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0005500316619873
(623) DESCRIBE `ports` 0.0020160675048828
(624) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043177604675293
(625) DESCRIBE `sailingdates` 0.0016438961029053
(626) DESCRIBE `ports` 0.0022377967834473
(627) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00045013427734375
(628) DESCRIBE `ports` 0.0018110275268555
(629) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038790702819824
(630) DESCRIBE `ports` 0.0023679733276367
(631) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.0006561279296875
(632) DESCRIBE `ports` 0.0021631717681885
(633) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00049495697021484
(634) DESCRIBE `ports` 0.0021121501922607
(635) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00046300888061523
(636) DESCRIBE `ports` 0.0018458366394043
(637) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00057196617126465
(638) DESCRIBE `ports` 0.0019750595092773
(639) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 419))) 0.00043606758117676
(640) DESCRIBE `ports` 0.0021519660949707
(641) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '419') 0.00058698654174805
(642) DESCRIBE `ports` 0.0028400421142578
(643) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1044))) 0.00061297416687012
(644) DESCRIBE `ports` 0.0030500888824463
(645) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1044') 0.00067400932312012
(646) DESCRIBE `ports` 0.0027711391448975
(647) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00058698654174805
(648) DESCRIBE `ports` 0.0027830600738525
(649) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00058197975158691
(650) DESCRIBE `ports` 0.0028350353240967
(651) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1341))) 0.00050806999206543
(652) DESCRIBE `ports` 0.0030081272125244
(653) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1341') 0.00060319900512695
(654) DESCRIBE `ports` 0.0025389194488525
(655) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00063896179199219
(656) DESCRIBE `ports` 0.0022602081298828
(657) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00045299530029297
(658) DESCRIBE `ports` 0.0017950534820557
(659) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 88))) 0.00043201446533203
(660) DESCRIBE `ports` 0.0018200874328613
(661) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '88') 0.00038504600524902
(662) DESCRIBE `ports` 0.0021190643310547
(663) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00051617622375488
(664) DESCRIBE `ports` 0.0018379688262939
(665) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.0003809928894043
(666) DESCRIBE `ports` 0.0019328594207764
(667) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1758))) 0.0012798309326172
(668) DESCRIBE `ports` 0.0022070407867432
(669) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1758') 0.00039792060852051
(670) DESCRIBE `ports` 0.0018870830535889
(671) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00042295455932617
(672) DESCRIBE `ports` 0.0018858909606934
(673) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00040292739868164
(674) DESCRIBE `ports` 0.0018770694732666
(675) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00052690505981445
(676) DESCRIBE `ports` 0.0021200180053711
(677) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00040316581726074
(678) DESCRIBE `ports` 0.0021350383758545
(679) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00045108795166016
(680) DESCRIBE `ports` 0.0024051666259766
(681) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00043797492980957
(682) DESCRIBE `ports` 0.0018551349639893
(683) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00053691864013672
(684) DESCRIBE `ports` 0.001957893371582
(685) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00047492980957031
(686) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '78346') AND (sailingdate >= '2019-11-09') AND (sailingdate <= '2020-02-01') 0.0060229301452637
(687) DESCRIBE `avid_specials` 0.0019550323486328
(688) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 78346 and class = 'Cruise') OR (item_id = 75 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 43 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.0012180805206299
(689) DESCRIBE `cruiselines` 0.003032922744751
(690) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00063204765319824
(691) DESCRIBE `orchid_image` 0.0022101402282715
(692) DESCRIBE `cruiselines` 0.0033049583435059
(693) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00050783157348633
(694) DESCRIBE `cruises` 0.0036258697509766
(695) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79285') 0.00064587593078613
(696) DESCRIBE `ships` 0.0036289691925049
(697) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 547))) 0.00051403045654297
(698) DESCRIBE `ships` 0.0037128925323486
(699) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '547') 0.0004270076751709
(700) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00035595893859863
(701) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034785270690918
(702) DESCRIBE `itineraries` 0.002147912979126
(703) DESCRIBE `ports` 0.0019271373748779
(704) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00045299530029297
(705) DESCRIBE `ports` 0.0023810863494873
(706) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0004580020904541
(707) DESCRIBE `ports` 0.0018050670623779
(708) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00045990943908691
(709) DESCRIBE `sailingdates` 0.001741886138916
(710) DESCRIBE `ports` 0.0019450187683105
(711) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.000579833984375
(712) DESCRIBE `ports` 0.0018990039825439
(713) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00045299530029297
(714) DESCRIBE `ports` 0.0019400119781494
(715) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00058293342590332
(716) DESCRIBE `ports` 0.0018630027770996
(717) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00043010711669922
(718) DESCRIBE `ports` 0.0017750263214111
(719) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00048398971557617
(720) DESCRIBE `ports` 0.0020861625671387
(721) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.0003659725189209
(722) DESCRIBE `ports` 0.0018858909606934
(723) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00039792060852051
(724) DESCRIBE `ports` 0.0019741058349609
(725) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00037598609924316
(726) DESCRIBE `ports` 0.0019540786743164
(727) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00063109397888184
(728) DESCRIBE `ports` 0.0023021697998047
(729) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00052094459533691
(730) DESCRIBE `ports` 0.0020091533660889
(731) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00045490264892578
(732) DESCRIBE `ports` 0.0019450187683105
(733) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00042200088500977
(734) DESCRIBE `ports` 0.0022079944610596
(735) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00052905082702637
(736) DESCRIBE `ports` 0.002086877822876
(737) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00040197372436523
(738) DESCRIBE `ports` 0.0021989345550537
(739) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00043296813964844
(740) DESCRIBE `ports` 0.001859188079834
(741) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00040006637573242
(742) DESCRIBE `ports` 0.0017609596252441
(743) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00041103363037109
(744) DESCRIBE `ports` 0.002190113067627
(745) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00041604042053223
(746) DESCRIBE `ports` 0.002763032913208
(747) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2086))) 0.0007469654083252
(748) DESCRIBE `ports` 0.0027611255645752
(749) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2086') 0.00056886672973633
(750) DESCRIBE `ports` 0.0027949810028076
(751) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00058293342590332
(752) DESCRIBE `ports` 0.0018668174743652
(753) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038719177246094
(754) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '79285') AND (sailingdate >= '2019-11-09') AND (sailingdate <= '2020-02-01') 0.0051658153533936
(755) DESCRIBE `avid_specials` 0.0017421245574951
(756) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 79285 and class = 'Cruise') OR (item_id = 547 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 43 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.0011048316955566
(757) DESCRIBE `cruiselines` 0.0025510787963867
(758) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00042200088500977
(759) DESCRIBE `orchid_image` 0.0022649765014648
(760) DESCRIBE `cruiselines` 0.0029871463775635
(761) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00043201446533203
(762) DESCRIBE `cruises` 0.0033900737762451
(763) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '79236') 0.00053095817565918
(764) DESCRIBE `ships` 0.0034501552581787
(765) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 75))) 0.00047802925109863
(766) DESCRIBE `ships` 0.0034270286560059
(767) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '75') 0.00057506561279297
(768) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00037813186645508
(769) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00038003921508789
(770) DESCRIBE `itineraries` 0.0018370151519775
(771) DESCRIBE `ports` 0.0022761821746826
(772) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044894218444824
(773) DESCRIBE `ports` 0.0018930435180664
(774) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046396255493164
(775) DESCRIBE `ports` 0.0019550323486328
(776) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00053906440734863
(777) DESCRIBE `sailingdates` 0.0017619132995605
(778) DESCRIBE `ports` 0.0018417835235596
(779) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044012069702148
(780) DESCRIBE `ports` 0.0021319389343262
(781) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040411949157715
(782) DESCRIBE `ports` 0.0020360946655273
(783) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2086))) 0.00043010711669922
(784) DESCRIBE `ports` 0.0018119812011719
(785) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2086') 0.00039386749267578
(786) DESCRIBE `ports` 0.0017430782318115
(787) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0005800724029541
(788) DESCRIBE `ports` 0.0020649433135986
(789) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00045204162597656
(790) DESCRIBE `ports` 0.0021848678588867
(791) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00045418739318848
(792) DESCRIBE `ports` 0.0019378662109375
(793) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00048303604125977
(794) DESCRIBE `ports` 0.0019550323486328
(795) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.0004429817199707
(796) DESCRIBE `ports` 0.0021729469299316
(797) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00045609474182129
(798) DESCRIBE `ports` 0.0019009113311768
(799) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.00046110153198242
(800) DESCRIBE `ports` 0.0021669864654541
(801) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.00039005279541016
(802) DESCRIBE `ports` 0.0020210742950439
(803) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00041294097900391
(804) DESCRIBE `ports` 0.0017979145050049
(805) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00037503242492676
(806) DESCRIBE `ports` 0.0018701553344727
(807) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00047707557678223
(808) DESCRIBE `ports` 0.001784086227417
(809) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039196014404297
(810) DESCRIBE `ports` 0.0020201206207275
(811) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0003960132598877
(812) DESCRIBE `ports` 0.0018939971923828
(813) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00038695335388184
(814) DESCRIBE `ports` 0.0019960403442383
(815) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00054812431335449
(816) DESCRIBE `ports` 0.0024580955505371
(817) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00051498413085938
(818) DESCRIBE `ports` 0.0022051334381104
(819) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2066))) 0.0004420280456543
(820) DESCRIBE `ports` 0.0019848346710205
(821) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2066') 0.00041699409484863
(822) DESCRIBE `ports` 0.0019021034240723
(823) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00041699409484863
(824) DESCRIBE `ports` 0.0019490718841553
(825) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.0003960132598877
(826) DESCRIBE `ports` 0.0018861293792725
(827) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00041103363037109
(828) DESCRIBE `ports` 0.0017590522766113
(829) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00039219856262207
(830) DESCRIBE `ports` 0.0019609928131104
(831) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00041294097900391
(832) DESCRIBE `ports` 0.0017728805541992
(833) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00037598609924316
(834) DESCRIBE `ports` 0.0017879009246826
(835) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2179))) 0.00041508674621582
(836) DESCRIBE `ports` 0.0018630027770996
(837) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2179') 0.00045108795166016
(838) DESCRIBE `ports` 0.0017969608306885
(839) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00043702125549316
(840) DESCRIBE `ports` 0.0017759799957275
(841) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00053310394287109
(842) DESCRIBE `ports` 0.0018990039825439
(843) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5565))) 0.00055480003356934
(844) DESCRIBE `ports` 0.0019760131835938
(845) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5565') 0.00046706199645996
(846) DESCRIBE `ports` 0.0017571449279785
(847) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00089693069458008
(848) DESCRIBE `ports` 0.0029458999633789
(849) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00058293342590332
(850) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '79236') AND (sailingdate >= '2019-11-09') AND (sailingdate <= '2020-02-01') 0.0065958499908447
(851) DESCRIBE `avid_specials` 0.001910924911499
(852) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 79236 and class = 'Cruise') OR (item_id = 75 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 43 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.0013351440429688
(853) DESCRIBE `cruiselines` 0.0028090476989746
(854) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00062203407287598
(855) DESCRIBE `orchid_image` 0.0023419857025146
(856) DESCRIBE `cruiselines` 0.0026609897613525
(857) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00040793418884277
(858) DESCRIBE `ships` 0.0040719509124756
(859) SELECT `ships`.* FROM `ships` WHERE (id IN ('75', '547')) ORDER BY FIND_IN_SET(id, '75,547') 0.00061583518981934
(860) DESCRIBE `cruisetypes` 0.0014309883117676
(861) DESCRIBE `cruiselines` 0.0032517910003662
(862) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00061297416687012
(863) DESCRIBE `destinations` 0.0027649402618408
(864) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 43))) 0.00048089027404785
(865) DESCRIBE `destinations` 0.0029308795928955
(866) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 43))) 0.00048017501831055
(867) DESCRIBE `cruiselines` 0.002769947052002
(868) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00056719779968262