or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Solo Cruisers
  3. Catch Up on Cruising: Latest News in bite size!
  4. Should I buy a beverage package?
  5. SPOTLIGHT ON: Viking Ocean and River Cruises

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

Total elapsed time: 0.71315002441406

# Query Time
(1) connect 0.0014021396636963
(2) DESCRIBE `cruises` 0.003957986831665
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (58865, 60243, 73117, 73118, 58866, 60244, 58867, 73119, 60246, 58873)) ORDER BY FIND_IN_SET(id, '58865,60243,73117,73118,58866,60244,58867,73119,60246,58873') 0.0028150081634521
(4) DESCRIBE `cruises` 0.0026969909667969
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58865') 0.00036501884460449
(6) DESCRIBE `ships` 0.0030479431152344
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00046610832214355
(8) DESCRIBE `ships` 0.0031020641326904
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.0010299682617188
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0
(12) DESCRIBE `itineraries` 0.0014657974243164
(13) DESCRIBE `ports` 0.0018649101257324
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00066304206848145
(15) DESCRIBE `ports` 0.0016260147094727
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00024104118347168
(17) DESCRIBE `ports` 0.00146484375
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00037002563476562
(19) DESCRIBE `sailingdates` 0.00067996978759766
(20) DESCRIBE `ports` 0.0018219947814941
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00044798851013184
(22) DESCRIBE `ports` 0.0020029544830322
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00035905838012695
(24) DESCRIBE `ports` 0.0017518997192383
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.0004119873046875
(26) DESCRIBE `ports` 0.0018429756164551
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00037288665771484
(28) DESCRIBE `ports` 0.0018119812011719
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00040984153747559
(30) DESCRIBE `ports` 0.0017309188842773
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00037479400634766
(32) DESCRIBE `ports` 0.0017631053924561
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 696))) 0
(34) DESCRIBE `ports` 0.0026829242706299
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '696') 0.00011110305786133
(36) DESCRIBE `ports` 0.0018608570098877
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 703))) 0.0005650520324707
(38) DESCRIBE `ports` 0.0016160011291504
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '703') 0.00033998489379883
(40) DESCRIBE `ports` 0.0016558170318604
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 703))) 0.00032496452331543
(42) DESCRIBE `ports` 0.0016000270843506
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '703') 0.00037002563476562
(44) DESCRIBE `ports` 0.0018000602722168
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00041508674621582
(46) DESCRIBE `ports` 0.0012710094451904
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.0003211498260498
(48) DESCRIBE `ports` 0.0013911724090576
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00030517578125
(50) DESCRIBE `ports` 0.0014209747314453
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00030303001403809
(52) DESCRIBE `ports` 0.0013999938964844
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00033807754516602
(54) DESCRIBE `ports` 0.0012991428375244
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0002748966217041
(56) DESCRIBE `ports` 0.0013978481292725
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00028800964355469
(58) DESCRIBE `ports` 0.0012609958648682
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00033187866210938
(60) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '58865') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0052971839904785
(61) DESCRIBE `avid_specials` 0.00092220306396484
(62) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 58865 and class = 'Cruise') OR (item_id = 616 AND class = 'Ship') OR (item_id = 151 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.0015020370483398
(63) DESCRIBE `cruiselines` 0.0022010803222656
(64) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00033402442932129
(65) DESCRIBE `orchid_image` 0.0015420913696289
(66) DESCRIBE `cruiselines` 0.0018949508666992
(67) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00030994415283203
(68) DESCRIBE `cruises` 0.0024421215057373
(69) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60243') 0.00029516220092773
(70) DESCRIBE `ships` 0.0025928020477295
(71) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.0003359317779541
(72) DESCRIBE `ships` 0.0031778812408447
(73) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00023913383483887
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026392936706543
(75) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025200843811035
(76) DESCRIBE `itineraries` 0.0018081665039062
(77) DESCRIBE `ports` 0.0017530918121338
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00042510032653809
(79) DESCRIBE `ports` 0.001629114151001
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00059103965759277
(81) DESCRIBE `ports` 0.0019619464874268
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0004119873046875
(83) DESCRIBE `sailingdates` 0.001554012298584
(84) DESCRIBE `ports` 0.0014889240264893
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00035595893859863
(86) DESCRIBE `ports` 0.0017859935760498
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00041484832763672
(88) DESCRIBE `ports` 0.0016589164733887
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3268))) 0.0004429817199707
(90) DESCRIBE `ports` 0.0019211769104004
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3268') 0.00041913986206055
(92) DESCRIBE `ports` 0.0017960071563721
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2613))) 0.00036406517028809
(94) DESCRIBE `ports` 0.0016160011291504
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2613') 0.00036811828613281
(96) DESCRIBE `ports` 0.0018379688262939
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00042080879211426
(98) DESCRIBE `ports` 0.0016908645629883
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00036406517028809
(100) DESCRIBE `ports` 0.0015389919281006
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00034904479980469
(102) DESCRIBE `ports` 0.0014970302581787
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0003352165222168
(104) DESCRIBE `ports` 0.0016400814056396
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00038409233093262
(106) DESCRIBE `ports` 0.001802921295166
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00034809112548828
(108) DESCRIBE `ports` 0.0022280216217041
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 733))) 0.00017809867858887
(110) DESCRIBE `ports` 0.0015599727630615
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '733') 0.00032806396484375
(112) DESCRIBE `ports` 0.00092792510986328
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2452))) 0.00038695335388184
(114) DESCRIBE `ports` 0.0015678405761719
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2452') 0.00033187866210938
(116) DESCRIBE `ports` 0.0016779899597168
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00036406517028809
(118) DESCRIBE `ports` 0.0014688968658447
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00050091743469238
(120) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '60243') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0071969032287598
(121) DESCRIBE `avid_specials` 0.0017390251159668
(122) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60243 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 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.0016589164733887
(123) DESCRIBE `cruiselines` 0.0023481845855713
(124) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00035905838012695
(125) DESCRIBE `orchid_image` 0.0016560554504395
(126) DESCRIBE `cruiselines` 0.0025620460510254
(127) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00043988227844238
(128) DESCRIBE `cruises` 0.0037600994110107
(129) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73117') 0.00062012672424316
(130) DESCRIBE `ships` 0.0037150382995605
(131) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00052618980407715
(132) DESCRIBE `ships` 0.0034480094909668
(133) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00043201446533203
(134) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033998489379883
(135) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026607513427734
(136) DESCRIBE `itineraries` 0.0020508766174316
(137) DESCRIBE `ports` 0.0018861293792725
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00050902366638184
(139) DESCRIBE `ports` 0.0018248558044434
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00037097930908203
(141) DESCRIBE `ports` 0.0017890930175781
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00037813186645508
(143) DESCRIBE `sailingdates` 0.0015490055084229
(144) DESCRIBE `ports` 0.0018370151519775
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00043320655822754
(146) DESCRIBE `ports` 0.0017838478088379
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00037717819213867
(148) DESCRIBE `ports` 0.0018019676208496
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00040388107299805
(150) DESCRIBE `ports` 0.0017449855804443
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.001183032989502
(152) DESCRIBE `ports` 0.00092601776123047
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.00034594535827637
(154) DESCRIBE `ports` 0.0016069412231445
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.00028300285339355
(156) DESCRIBE `ports` 0.0024778842926025
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 926))) 0.00042009353637695
(158) DESCRIBE `ports` 0.0018069744110107
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '926') 0
(160) DESCRIBE `ports` 0.0018160343170166
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1620))) 0.00045084953308105
(162) DESCRIBE `ports` 0.0011909008026123
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1620') 0.00052785873413086
(164) DESCRIBE `ports` 0.0019590854644775
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3963))) 0.00063300132751465
(166) DESCRIBE `ports` 0.0019831657409668
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3963') 0.00045490264892578
(168) DESCRIBE `ports` 0.0018579959869385
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00047779083251953
(170) DESCRIBE `ports` 0.0019130706787109
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00043606758117676
(172) DESCRIBE `ports` 0.0019330978393555
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00016617774963379
(174) DESCRIBE `ports` 0.0022919178009033
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00037002563476562
(176) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '73117') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0060639381408691
(177) DESCRIBE `avid_specials` 0.0016989707946777
(178) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73117 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 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.0013101100921631
(179) DESCRIBE `cruiselines` 0.002047061920166
(180) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00039887428283691
(181) DESCRIBE `orchid_image` 0.0019629001617432
(182) DESCRIBE `cruiselines` 0.0022501945495605
(183) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00042104721069336
(184) DESCRIBE `cruises` 0.0024111270904541
(185) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73118') 0
(186) DESCRIBE `ships` 0.0032920837402344
(187) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.0004889965057373
(188) DESCRIBE `ships` 0.0038449764251709
(189) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00043606758117676
(190) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027108192443848
(191) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025796890258789
(192) DESCRIBE `itineraries` 0.0013659000396729
(193) DESCRIBE `ports` 0.0016381740570068
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 6.6041946411133E-5
(195) DESCRIBE `ports` 0.0014560222625732
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00033402442932129
(197) DESCRIBE `ports` 0.0014472007751465
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00032305717468262
(199) DESCRIBE `sailingdates` 0.0011920928955078
(200) DESCRIBE `ports` 0.0025260448455811
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00042295455932617
(202) DESCRIBE `ports` 0.0015299320220947
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00036478042602539
(204) DESCRIBE `ports` 0.0015921592712402
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3179))) 0.00035285949707031
(206) DESCRIBE `ports` 0.0015308856964111
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3179') 0.00036907196044922
(208) DESCRIBE `ports` 0.0017800331115723
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00040912628173828
(210) DESCRIBE `ports` 0.001431941986084
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00029397010803223
(212) DESCRIBE `ports` 0.0013461112976074
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00038504600524902
(214) DESCRIBE `ports` 0.00069999694824219
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00030708312988281
(216) DESCRIBE `ports` 0.0013320446014404
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 905))) 0.00036883354187012
(218) DESCRIBE `ports` 0.0015890598297119
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '905') 0.00040507316589355
(220) DESCRIBE `ports` 0.0018758773803711
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00043582916259766
(222) DESCRIBE `ports` 0.0017399787902832
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00049805641174316
(224) DESCRIBE `ports` 0.0015480518341064
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 727))) 0.0003819465637207
(226) DESCRIBE `ports` 0.0014081001281738
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '727') 0.00028491020202637
(228) DESCRIBE `ports` 0.0013089179992676
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3963))) 0.00041508674621582
(230) DESCRIBE `ports` 0.0016329288482666
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3963') 0.00033688545227051
(232) DESCRIBE `ports` 0.0017900466918945
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 720))) 0.0004432201385498
(234) DESCRIBE `ports` 0.0018870830535889
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '720') 0.0003509521484375
(236) DESCRIBE `ports` 0.0014331340789795
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4120))) 0.00039792060852051
(238) DESCRIBE `ports` 0.0013160705566406
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4120') 0.00028800964355469
(240) DESCRIBE `ports` 0.0014259815216064
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00033211708068848
(242) DESCRIBE `ports` 0.00068306922912598
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0002899169921875
(244) DESCRIBE `ports` 0.0018110275268555
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00070285797119141
(246) DESCRIBE `ports` 0.0015928745269775
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00032591819763184
(248) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '73118') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0058310031890869
(249) DESCRIBE `avid_specials` 0.0017070770263672
(250) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73118 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 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.0015869140625
(251) DESCRIBE `cruiselines` 0.002579927444458
(252) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.0004580020904541
(253) DESCRIBE `orchid_image` 0.0017478466033936
(254) DESCRIBE `cruiselines` 0.0021989345550537
(255) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00034403800964355
(256) DESCRIBE `cruises` 0.0025908946990967
(257) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58866') 0.00034809112548828
(258) DESCRIBE `ships` 0.0027878284454346
(259) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00046300888061523
(260) DESCRIBE `ships` 0.0029489994049072
(261) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.00034499168395996
(262) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026893615722656
(263) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025606155395508
(264) DESCRIBE `itineraries` 0.0012369155883789
(265) DESCRIBE `ports` 0.0014998912811279
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00032615661621094
(267) DESCRIBE `ports` 0.0016601085662842
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00035285949707031
(269) DESCRIBE `ports` 0.0015928745269775
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00035500526428223
(271) DESCRIBE `sailingdates` 0.0011169910430908
(272) DESCRIBE `ports` 0.0014021396636963
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031709671020508
(274) DESCRIBE `ports` 0.0012800693511963
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00030708312988281
(276) DESCRIBE `ports` 0.0014729499816895
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 909))) 0.0003809928894043
(278) DESCRIBE `ports` 0.0017011165618896
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '909') 0.00032186508178711
(280) DESCRIBE `ports` 0.001492977142334
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00038409233093262
(282) DESCRIBE `ports` 0.0014441013336182
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00029301643371582
(284) DESCRIBE `ports` 0.0012907981872559
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00031900405883789
(286) DESCRIBE `ports` 0.0013329982757568
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.0003349781036377
(288) DESCRIBE `ports` 0.0013999938964844
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00032401084899902
(290) DESCRIBE `ports` 0.0012938976287842
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.0002748966217041
(292) DESCRIBE `ports` 0.0012648105621338
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 584))) 0.00030207633972168
(294) DESCRIBE `ports` 0.001291036605835
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '584') 0.00037717819213867
(296) DESCRIBE `ports` 0.000823974609375
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.001107931137085
(298) DESCRIBE `ports` 0.00095820426940918
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00045680999755859
(300) DESCRIBE `ports` 0.0012838840484619
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00037097930908203
(302) DESCRIBE `ports` 0.001288890838623
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 7.8678131103516E-6
(304) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '58866') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0048489570617676
(305) DESCRIBE `avid_specials` 0.0012969970703125
(306) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 58866 and class = 'Cruise') OR (item_id = 616 AND class = 'Ship') OR (item_id = 151 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.0021231174468994
(307) DESCRIBE `cruiselines` 0.0021529197692871
(308) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00040102005004883
(309) DESCRIBE `orchid_image` 0.0019409656524658
(310) DESCRIBE `cruiselines` 0.0022199153900146
(311) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00044703483581543
(312) DESCRIBE `cruises` 0.002938985824585
(313) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60244') 0.0004119873046875
(314) DESCRIBE `ships` 0.0027251243591309
(315) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00041294097900391
(316) DESCRIBE `ships` 0.002100944519043
(317) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00037503242492676
(318) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00030803680419922
(319) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025701522827148
(320) DESCRIBE `itineraries` 0.0013401508331299
(321) DESCRIBE `ports` 0.0014209747314453
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00040197372436523
(323) DESCRIBE `ports` 0.0022668838500977
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00033020973205566
(325) DESCRIBE `ports` 0.0013511180877686
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00028395652770996
(327) DESCRIBE `sailingdates` 0.001270055770874
(328) DESCRIBE `ports` 0.001317024230957
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00038504600524902
(330) DESCRIBE `ports` 0.0017430782318115
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00040388107299805
(332) DESCRIBE `ports` 0.0018908977508545
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1106))) 0.00041890144348145
(334) DESCRIBE `ports` 0.0014970302581787
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1106') 0.00028085708618164
(336) DESCRIBE `ports` 0.0012581348419189
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 651))) 0.00030398368835449
(338) DESCRIBE `ports` 0.0015020370483398
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '651') 0.00032806396484375
(340) DESCRIBE `ports` 0.001802921295166
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00047612190246582
(342) DESCRIBE `ports` 0.0016939640045166
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00036120414733887
(344) DESCRIBE `ports` 0.0013508796691895
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.0003199577331543
(346) DESCRIBE `ports` 0.001488208770752
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00033092498779297
(348) DESCRIBE `ports` 0.0013329982757568
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2565))) 0.00030922889709473
(350) DESCRIBE `ports` 0.001399040222168
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2565') 0.00028419494628906
(352) DESCRIBE `ports` 0.0014081001281738
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00033998489379883
(354) DESCRIBE `ports` 0.0014100074768066
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00029897689819336
(356) DESCRIBE `ports` 0.0013799667358398
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00031590461730957
(358) DESCRIBE `ports` 0.0013759136199951
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00029087066650391
(360) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '60244') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.005511999130249
(361) DESCRIBE `avid_specials` 0.001356840133667
(362) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60244 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 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.001154899597168
(363) DESCRIBE `cruiselines` 0.0019600391387939
(364) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00044488906860352
(365) DESCRIBE `orchid_image` 0.0015048980712891
(366) DESCRIBE `cruiselines` 0.0019969940185547
(367) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00030398368835449
(368) DESCRIBE `cruises` 0.0028159618377686
(369) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58867') 0.00032186508178711
(370) DESCRIBE `ships` 0.0026700496673584
(371) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00042414665222168
(372) DESCRIBE `ships` 0.0027310848236084
(373) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.0003209114074707
(374) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032877922058105
(375) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003049373626709
(376) DESCRIBE `itineraries` 0.0012650489807129
(377) DESCRIBE `ports` 0.0013349056243896
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00032806396484375
(379) DESCRIBE `ports` 0.0013599395751953
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00030684471130371
(381) DESCRIBE `ports` 0.0012810230255127
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00037598609924316
(383) DESCRIBE `sailingdates` 0.0013110637664795
(384) DESCRIBE `ports` 0.0014290809631348
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00039100646972656
(386) DESCRIBE `ports` 0.0014569759368896
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00037097930908203
(388) DESCRIBE `ports` 0.0018010139465332
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00040602684020996
(390) DESCRIBE `ports` 0.0019979476928711
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00039386749267578
(392) DESCRIBE `ports` 0.0014610290527344
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 386))) 0.00031399726867676
(394) DESCRIBE `ports` 0.0012779235839844
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '386') 0.00029516220092773
(396) DESCRIBE `ports` 0.0013189315795898
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1119))) 0.00035595893859863
(398) DESCRIBE `ports` 0.0014169216156006
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1119') 0.00034689903259277
(400) DESCRIBE `ports` 0.0013320446014404
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 377))) 0.00036406517028809
(402) DESCRIBE `ports` 0.0015289783477783
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '377') 0.00032401084899902
(404) DESCRIBE `ports` 0.0014560222625732
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1252))) 0.00047707557678223
(406) DESCRIBE `ports` 0.0017600059509277
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1252') 0.00046205520629883
(408) DESCRIBE `ports` 0.0014770030975342
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1623))) 0.00031399726867676
(410) DESCRIBE `ports` 0.0013279914855957
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1623') 0.00031900405883789
(412) DESCRIBE `ports` 0.0012550354003906
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00030517578125
(414) DESCRIBE `ports` 0.0013649463653564
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00028419494628906
(416) DESCRIBE `ports` 0.0012822151184082
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00032401084899902
(418) DESCRIBE `ports` 0.0013308525085449
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00027894973754883
(420) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '58867') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0048527717590332
(421) DESCRIBE `avid_specials` 0.0012748241424561
(422) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 58867 and class = 'Cruise') OR (item_id = 616 AND class = 'Ship') OR (item_id = 151 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.0010631084442139
(423) DESCRIBE `cruiselines` 0.0019559860229492
(424) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00033903121948242
(425) DESCRIBE `orchid_image` 0.0014760494232178
(426) DESCRIBE `cruiselines` 0.0018980503082275
(427) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00031709671020508
(428) DESCRIBE `cruises` 0.001978874206543
(429) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73119') 0.001154899597168
(430) DESCRIBE `ships` 0.002406120300293
(431) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1672))) 0.00042390823364258
(432) DESCRIBE `ships` 0.0028908252716064
(433) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1672') 0.00035405158996582
(434) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027179718017578
(435) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027108192443848
(436) DESCRIBE `itineraries` 0.0014700889587402
(437) DESCRIBE `ports` 0.0017130374908447
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00047802925109863
(439) DESCRIBE `ports` 0.0017318725585938
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00043201446533203
(441) DESCRIBE `ports` 0.0015499591827393
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00040507316589355
(443) DESCRIBE `sailingdates` 0.00062298774719238
(444) DESCRIBE `ports` 0.0016880035400391
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00043702125549316
(446) DESCRIBE `ports` 0.0021491050720215
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00039196014404297
(448) DESCRIBE `ports` 0.0019271373748779
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.0003211498260498
(450) DESCRIBE `ports` 0.0013279914855957
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00027894973754883
(452) DESCRIBE `ports` 0.0013039112091064
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00031399726867676
(454) DESCRIBE `ports` 0.0012481212615967
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00031805038452148
(456) DESCRIBE `ports` 0.0012919902801514
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00030303001403809
(458) DESCRIBE `ports` 0.001317024230957
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00032877922058105
(460) DESCRIBE `ports` 0.0012569427490234
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1198))) 0.00029993057250977
(462) DESCRIBE `ports` 0.0013060569763184
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1198') 0.00027298927307129
(464) DESCRIBE `ports` 0.0012631416320801
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 728))) 0.00030112266540527
(466) DESCRIBE `ports` 0.0013420581817627
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '728') 0.00028300285339355
(468) DESCRIBE `ports` 0.001446008682251
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00046205520629883
(470) DESCRIBE `ports` 0.0012941360473633
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00027608871459961
(472) DESCRIBE `ports` 0.0012469291687012
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 199))) 0.0003509521484375
(474) DESCRIBE `ports` 0.0013940334320068
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '199') 0.00027298927307129
(476) DESCRIBE `ports` 0.0013611316680908
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00030303001403809
(478) DESCRIBE `ports` 0.0012428760528564
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00027203559875488
(480) DESCRIBE `ports` 0.0013141632080078
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00031185150146484
(482) DESCRIBE `ports` 0.0012590885162354
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00030994415283203
(484) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '73119') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0047850608825684
(485) DESCRIBE `avid_specials` 0.0013270378112793
(486) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73119 and class = 'Cruise') OR (item_id = 1672 AND class = 'Ship') OR (item_id = 151 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.00098490715026855
(487) DESCRIBE `cruiselines` 0.0018899440765381
(488) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00031089782714844
(489) DESCRIBE `orchid_image` 0.0015089511871338
(490) DESCRIBE `cruiselines` 0.0017960071563721
(491) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.0004580020904541
(492) DESCRIBE `cruises` 0.0031061172485352
(493) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60246') 0.00038290023803711
(494) DESCRIBE `ships` 0.0027549266815186
(495) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00040197372436523
(496) DESCRIBE `ships` 0.0036580562591553
(497) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.0004119873046875
(498) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003509521484375
(499) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0003199577331543
(500) DESCRIBE `itineraries` 0.0017058849334717
(501) DESCRIBE `ports` 0.0017058849334717
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0003960132598877
(503) DESCRIBE `ports` 0.0016751289367676
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00037693977355957
(505) DESCRIBE `ports` 0.0015881061553955
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00027894973754883
(507) DESCRIBE `sailingdates` 0.0011160373687744
(508) DESCRIBE `ports` 0.001276969909668
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00031304359436035
(510) DESCRIBE `ports` 0.001262903213501
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00029301643371582
(512) DESCRIBE `ports` 0.001471996307373
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 533))) 0.00031805038452148
(514) DESCRIBE `ports` 0.0012590885162354
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '533') 0.00031280517578125
(516) DESCRIBE `ports` 0.0013189315795898
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 204))) 0.00030207633972168
(518) DESCRIBE `ports` 0.0012531280517578
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '204') 0.00031781196594238
(520) DESCRIBE `ports` 0.001248836517334
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 204))) 0.00029802322387695
(522) DESCRIBE `ports` 0.0013751983642578
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '204') 0.00027608871459961
(524) DESCRIBE `ports` 0.0013759136199951
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00029397010803223
(526) DESCRIBE `ports` 0.0013210773468018
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00026488304138184
(528) DESCRIBE `ports` 0.0012450218200684
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00030207633972168
(530) DESCRIBE `ports` 0.00068998336791992
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00034403800964355
(532) DESCRIBE `ports` 0.0022368431091309
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.0001370906829834
(534) DESCRIBE `ports` 0.001378059387207
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00045514106750488
(536) DESCRIBE `ports` 0.0020430088043213
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00045609474182129
(538) DESCRIBE `ports` 0.0013470649719238
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00029492378234863
(540) DESCRIBE `ports` 0.0012860298156738
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 429))) 0.0003819465637207
(542) DESCRIBE `ports` 0.0012679100036621
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '429') 0.00027894973754883
(544) DESCRIBE `ports` 0.0013020038604736
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 609))) 0.00031590461730957
(546) DESCRIBE `ports` 0.0013060569763184
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '609') 0.00029706954956055
(548) DESCRIBE `ports` 0.0013210773468018
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00030684471130371
(550) DESCRIBE `ports` 0.0013511180877686
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00028395652770996
(552) DESCRIBE `ports` 0.0013229846954346
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00032806396484375
(554) DESCRIBE `ports` 0.00065994262695312
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00034594535827637
(556) DESCRIBE `ports` 0.0014851093292236
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00037789344787598
(558) DESCRIBE `ports` 0.001305103302002
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00029397010803223
(560) DESCRIBE `ports` 0.0012929439544678
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00034904479980469
(562) DESCRIBE `ports` 0.0012969970703125
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00028300285339355
(564) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '60246') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0053548812866211
(565) DESCRIBE `avid_specials` 0.0013279914855957
(566) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60246 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 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.001032829284668
(567) DESCRIBE `cruiselines` 0.0018930435180664
(568) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00032186508178711
(569) DESCRIBE `orchid_image` 0.00142502784729
(570) DESCRIBE `cruiselines` 0.0017812252044678
(571) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00028204917907715
(572) DESCRIBE `cruises` 0.0024189949035645
(573) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58873') 0.0013010501861572
(574) DESCRIBE `ships` 0.0018060207366943
(575) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0
(576) DESCRIBE `ships` 0.0034580230712891
(577) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.00031805038452148
(578) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0002748966217041
(579) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026202201843262
(580) DESCRIBE `itineraries` 0.0019831657409668
(581) DESCRIBE `ports` 0.001288890838623
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00034594535827637
(583) DESCRIBE `ports` 0.00044608116149902
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00029897689819336
(585) DESCRIBE `ports` 0.0012788772583008
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0
(587) DESCRIBE `sailingdates` 0.00097107887268066
(588) DESCRIBE `ports` 0.0013411045074463
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00033092498779297
(590) DESCRIBE `ports` 0.001255989074707
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00034999847412109
(592) DESCRIBE `ports` 0.00093197822570801
(593) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00042104721069336
(594) DESCRIBE `ports` 0.0018479824066162
(595) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00037097930908203
(596) DESCRIBE `ports` 0.0024080276489258
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.0003669261932373
(598) DESCRIBE `ports` 0.0015799999237061
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 8.7976455688477E-5
(600) DESCRIBE `ports` 0.0010058879852295
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1493))) 0.00032401084899902
(602) DESCRIBE `ports` 0.0017399787902832
(603) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1493') 0.00028014183044434
(604) DESCRIBE `ports` 0.0012779235839844
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00030612945556641
(606) DESCRIBE `ports` 0.0013129711151123
(607) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00028204917907715
(608) DESCRIBE `ports` 0.0013980865478516
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.0011491775512695
(610) DESCRIBE `ports` 0.00080585479736328
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.0002739429473877
(612) DESCRIBE `ports` 0.0013771057128906
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0
(614) DESCRIBE `ports` 0.0012128353118896
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.0002739429473877
(616) DESCRIBE `ports` 0.0018417835235596
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.0003819465637207
(618) DESCRIBE `ports` 0.0016911029815674
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0
(620) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '58873') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0058059692382812
(621) DESCRIBE `avid_specials` 0.0012388229370117
(622) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 58873 and class = 'Cruise') OR (item_id = 616 AND class = 'Ship') OR (item_id = 151 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.0010249614715576
(623) DESCRIBE `cruiselines` 0.0018689632415771
(624) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00032591819763184
(625) DESCRIBE `orchid_image` 0.0013978481292725
(626) DESCRIBE `cruiselines` 0.0018699169158936
(627) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00028800964355469
(628) DESCRIBE `ships` 0.0030338764190674
(629) SELECT `ships`.* FROM `ships` WHERE (id IN ('616', '652', '1672')) ORDER BY FIND_IN_SET(id, '616,652,1672') 0.00065112113952637
(630) DESCRIBE `cruisetypes` 0.0010769367218018
(631) DESCRIBE `destinations` 0.0017769336700439
(632) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '45')) ORDER BY FIND_IN_SET(id, '22,45') 0.00046396255493164
(633) DESCRIBE `cruiselines` 0.0017950534820557
(634) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00031900405883789
(635) DESCRIBE `cruiselines` 0.002100944519043
(636) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00045609474182129