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

Total elapsed time: 0.82694530487061

# Query Time
(1) connect 0.00089406967163086
(2) DESCRIBE `cruises` 0.0038650035858154
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (67876, 44408, 66554, 67875, 69282, 69283, 54857, 66532, 66526, 67509)) ORDER BY FIND_IN_SET(id, '67876,44408,66554,67875,69282,69283,54857,66532,66526,67509') 0.0026149749755859
(4) DESCRIBE `cruises` 0.0033519268035889
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67876') 0.00047016143798828
(6) DESCRIBE `ships` 0.0036489963531494
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 349))) 0.00053787231445312
(8) DESCRIBE `ships` 0.0036840438842773
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '349') 0.00026297569274902
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033307075500488
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031805038452148
(12) DESCRIBE `itineraries` 0.0019490718841553
(13) DESCRIBE `ports` 0.0021579265594482
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 5.3882598876953E-5
(15) DESCRIBE `ports` 0.0019838809967041
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.0003960132598877
(17) DESCRIBE `ports` 0.001777172088623
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00037193298339844
(19) DESCRIBE `sailingdates` 0.0016000270843506
(20) DESCRIBE `ports` 0.0019869804382324
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00062417984008789
(22) DESCRIBE `ports` 0.0018579959869385
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00039196014404297
(24) DESCRIBE `ports` 0.0017929077148438
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00042510032653809
(26) DESCRIBE `ports` 0.0018329620361328
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00037693977355957
(28) DESCRIBE `ports` 0.0018329620361328
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5651))) 0.00042605400085449
(30) DESCRIBE `ports` 0.0017721652984619
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5651') 0.00034689903259277
(32) DESCRIBE `ports` 0.0017340183258057
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00040912628173828
(34) DESCRIBE `ports` 0.0017218589782715
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00037598609924316
(36) DESCRIBE `ports` 0.0017490386962891
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1273))) 0.00039792060852051
(38) DESCRIBE `ports` 0.0017960071563721
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1273') 5.6028366088867E-5
(40) DESCRIBE `ports` 0.0016880035400391
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2509))) 0.00070714950561523
(42) DESCRIBE `ports` 0.0017709732055664
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2509') 0.00044608116149902
(44) DESCRIBE `ports` 0.0018131732940674
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1307))) 0.00042891502380371
(46) DESCRIBE `ports` 0.0019080638885498
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1307') 0.00043702125549316
(48) DESCRIBE `ports` 0.0018680095672607
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1308))) 0.00043106079101562
(50) DESCRIBE `ports` 0.0016858577728271
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1308') 0
(52) DESCRIBE `ports` 0.0017240047454834
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00065898895263672
(54) DESCRIBE `ports` 0.0017349720001221
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00037884712219238
(56) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '67876') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.013107061386108
(57) DESCRIBE `avid_specials` 0.001896858215332
(58) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67876 and class = 'Cruise') OR (item_id = 349 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 35 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.0018270015716553
(59) DESCRIBE `cruiselines` 0.0022249221801758
(60) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00069499015808105
(61) DESCRIBE `orchid_image` 0.0020360946655273
(62) DESCRIBE `cruiselines` 0.0025620460510254
(63) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00041103363037109
(64) DESCRIBE `cruises` 0.003093957901001
(65) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '44408') 0.00048685073852539
(66) DESCRIBE `ships` 0.0035421848297119
(67) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 291))) 0.00048995018005371
(68) DESCRIBE `ships` 0.0039229393005371
(69) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '291') 0.00058293342590332
(70) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037789344787598
(71) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034594535827637
(72) DESCRIBE `itineraries` 0.0020370483398438
(73) DESCRIBE `ports` 0.0021939277648926
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00048184394836426
(75) DESCRIBE `ports` 0.0021169185638428
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.0004580020904541
(77) DESCRIBE `ports` 0.0019350051879883
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.00042486190795898
(79) DESCRIBE `sailingdates` 0.0016880035400391
(80) DESCRIBE `ports` 0.0020499229431152
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00045299530029297
(82) DESCRIBE `ports` 0.0018260478973389
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.00037884712219238
(84) DESCRIBE `ports` 0.0017580986022949
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00051212310791016
(86) DESCRIBE `ports` 0.0018279552459717
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00053906440734863
(88) DESCRIBE `ports` 0.0014979839324951
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00049495697021484
(90) DESCRIBE `ports` 0.0017290115356445
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00039792060852051
(92) DESCRIBE `ports` 0.0017821788787842
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00041389465332031
(94) DESCRIBE `ports` 0.0017831325531006
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00037598609924316
(96) DESCRIBE `ports` 0.0017461776733398
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00020313262939453
(98) DESCRIBE `ports` 0.0017528533935547
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00040102005004883
(100) DESCRIBE `ports` 0.001255989074707
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00042080879211426
(102) DESCRIBE `ports` 0.0016419887542725
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00040698051452637
(104) DESCRIBE `ports` 0.0022311210632324
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00043821334838867
(106) DESCRIBE `ports` 0.0018370151519775
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00032901763916016
(108) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '44408') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.0092480182647705
(109) DESCRIBE `avid_specials` 0.0020339488983154
(110) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 44408 and class = 'Cruise') OR (item_id = 291 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015838146209717
(111) DESCRIBE `cruiselines` 0.002608060836792
(112) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00052595138549805
(113) DESCRIBE `orchid_image` 0.0015678405761719
(114) DESCRIBE `cruiselines` 0.0025560855865479
(115) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00045585632324219
(116) DESCRIBE `cruises` 0.0037150382995605
(117) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66554') 0.00048995018005371
(118) DESCRIBE `ships` 0.003709077835083
(119) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 348))) 0.00058507919311523
(120) DESCRIBE `ships` 0.0037961006164551
(121) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '348') 0.00046491622924805
(122) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0005500316619873
(123) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003359317779541
(124) DESCRIBE `itineraries` 0.0018808841705322
(125) DESCRIBE `ports` 0.0018470287322998
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00043702125549316
(127) DESCRIBE `ports` 0.0024659633636475
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.0005791187286377
(129) DESCRIBE `ports` 0.0019948482513428
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.0011050701141357
(131) DESCRIBE `sailingdates` 0.0013530254364014
(132) DESCRIBE `ports` 0.0021700859069824
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00051093101501465
(134) DESCRIBE `ports` 0.0017719268798828
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.0009160041809082
(136) DESCRIBE `ports` 0.0018830299377441
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 553))) 0.00049185752868652
(138) DESCRIBE `ports` 0.0028071403503418
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '553') 0.0015769004821777
(140) DESCRIBE `ports` 0.0032711029052734
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00048303604125977
(142) DESCRIBE `ports` 0.0018651485443115
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00040507316589355
(144) DESCRIBE `ports` 0.0017759799957275
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00041913986206055
(146) DESCRIBE `ports` 0.0016751289367676
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00048208236694336
(148) DESCRIBE `ports` 0.0024740695953369
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00076985359191895
(150) DESCRIBE `ports` 0.0020620822906494
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.0004880428314209
(152) DESCRIBE `ports` 0.00193190574646
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 292))) 0.00045299530029297
(154) DESCRIBE `ports` 0.0018100738525391
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '292') 0.00038814544677734
(156) DESCRIBE `ports` 0.0017719268798828
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00046086311340332
(158) DESCRIBE `ports` 0.0018332004547119
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.00038981437683105
(160) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66554') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.0091807842254639
(161) DESCRIBE `avid_specials` 0.0018990039825439
(162) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66554 and class = 'Cruise') OR (item_id = 348 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0016601085662842
(163) DESCRIBE `cruiselines` 0.0025830268859863
(164) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00052309036254883
(165) DESCRIBE `orchid_image` 0.0020689964294434
(166) DESCRIBE `cruiselines` 0.0026650428771973
(167) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00049114227294922
(168) DESCRIBE `cruises` 0.0036790370941162
(169) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67875') 0.00049901008605957
(170) DESCRIBE `ships` 0.0037760734558105
(171) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 349))) 0.00060105323791504
(172) DESCRIBE `ships` 0.0036399364471436
(173) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '349') 0.0004730224609375
(174) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032687187194824
(175) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030994415283203
(176) DESCRIBE `itineraries` 0.0017900466918945
(177) DESCRIBE `ports` 0.0019121170043945
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00043916702270508
(179) DESCRIBE `ports` 0.001633882522583
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00040102005004883
(181) DESCRIBE `ports` 0.0016357898712158
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00042200088500977
(183) DESCRIBE `sailingdates` 0.0013980865478516
(184) DESCRIBE `ports` 0.0016801357269287
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00038981437683105
(186) DESCRIBE `ports` 0.0016388893127441
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00082802772521973
(188) DESCRIBE `ports` 0.0015640258789062
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00040197372436523
(190) DESCRIBE `ports` 0.0015869140625
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00033903121948242
(192) DESCRIBE `ports` 0.001619815826416
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5651))) 0.00055503845214844
(194) DESCRIBE `ports` 0.0017309188842773
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5651') 0.00062298774719238
(196) DESCRIBE `ports` 0.0014419555664062
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00031590461730957
(198) DESCRIBE `ports` 0.0013129711151123
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.0003058910369873
(200) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '67875') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.0055429935455322
(201) DESCRIBE `avid_specials` 0.001431941986084
(202) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67875 and class = 'Cruise') OR (item_id = 349 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 35 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.0015740394592285
(203) DESCRIBE `cruiselines` 0.0025341510772705
(204) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00057005882263184
(205) DESCRIBE `orchid_image` 0.0022199153900146
(206) DESCRIBE `cruiselines` 0.0026891231536865
(207) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00049090385437012
(208) DESCRIBE `cruises` 0.0039598941802979
(209) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69282') 0.00041985511779785
(210) DESCRIBE `ships` 0.0034089088439941
(211) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1409))) 0.00060701370239258
(212) DESCRIBE `ships` 0.0034990310668945
(213) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1409') 0.00047183036804199
(214) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032997131347656
(215) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031709671020508
(216) DESCRIBE `itineraries` 0.0018379688262939
(217) DESCRIBE `ports` 0.0025250911712646
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00046515464782715
(219) DESCRIBE `ports` 0.0018889904022217
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00040721893310547
(221) DESCRIBE `ports` 0.0017669200897217
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.0003659725189209
(223) DESCRIBE `sailingdates` 0.0015518665313721
(224) DESCRIBE `ports` 0.001939058303833
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00056695938110352
(226) DESCRIBE `ports` 0.0017988681793213
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00036716461181641
(228) DESCRIBE `ports` 0.003464937210083
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00047802925109863
(230) DESCRIBE `ports` 0.0014219284057617
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00045180320739746
(232) DESCRIBE `ports` 0.0017590522766113
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00033092498779297
(234) DESCRIBE `ports` 0.0014801025390625
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00041699409484863
(236) DESCRIBE `ports` 0.0016520023345947
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 550))) 0.00042200088500977
(238) DESCRIBE `ports` 0.002608060836792
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '550') 0.00050687789916992
(240) DESCRIBE `ports` 0.0018730163574219
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.0003349781036377
(242) DESCRIBE `ports` 0.0017070770263672
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00035500526428223
(244) DESCRIBE `ports` 0.0017280578613281
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00045299530029297
(246) DESCRIBE `ports` 0.0018818378448486
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0003972053527832
(248) DESCRIBE `ports` 0.0018389225006104
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.00056195259094238
(250) DESCRIBE `ports` 0.0017950534820557
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00035285949707031
(252) DESCRIBE `ports` 0.00160813331604
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00045680999755859
(254) DESCRIBE `ports` 0.0019569396972656
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00040292739868164
(256) DESCRIBE `ports` 0.0015630722045898
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039386749267578
(258) DESCRIBE `ports` 0.0016188621520996
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034213066101074
(260) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69282') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.010206937789917
(261) DESCRIBE `avid_specials` 0.0016968250274658
(262) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69282 and class = 'Cruise') OR (item_id = 1409 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 35 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.0017409324645996
(263) DESCRIBE `cruiselines` 0.0024008750915527
(264) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00044608116149902
(265) DESCRIBE `orchid_image` 0.0018229484558105
(266) DESCRIBE `cruiselines` 0.0023379325866699
(267) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00042295455932617
(268) DESCRIBE `cruises` 0.0031571388244629
(269) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69283') 0.00046396255493164
(270) DESCRIBE `ships` 0.00370192527771
(271) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1409))) 0.00055098533630371
(272) DESCRIBE `ships` 0.0034661293029785
(273) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1409') 0.00055909156799316
(274) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034809112548828
(275) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033903121948242
(276) DESCRIBE `itineraries` 0.0020051002502441
(277) DESCRIBE `ports` 0.0020480155944824
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00046086311340332
(279) DESCRIBE `ports` 0.0016751289367676
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00036478042602539
(281) DESCRIBE `ports` 0.0016219615936279
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00035500526428223
(283) DESCRIBE `sailingdates` 0.0014340877532959
(284) DESCRIBE `ports` 0.0018410682678223
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00049114227294922
(286) DESCRIBE `ports` 0.0016360282897949
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00034904479980469
(288) DESCRIBE `ports` 0.0017280578613281
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00039792060852051
(290) DESCRIBE `ports` 0.0016331672668457
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00037479400634766
(292) DESCRIBE `ports` 0.0016510486602783
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.0004119873046875
(294) DESCRIBE `ports` 0.0016651153564453
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00043201446533203
(296) DESCRIBE `ports` 0.0016391277313232
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 550))) 0.00040793418884277
(298) DESCRIBE `ports` 0.0017738342285156
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '550') 0.0004889965057373
(300) DESCRIBE `ports` 0.0017268657684326
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00017809867858887
(302) DESCRIBE `ports` 0.0016629695892334
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00034403800964355
(304) DESCRIBE `ports` 0.0012941360473633
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00036287307739258
(306) DESCRIBE `ports` 0.0014441013336182
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00032711029052734
(308) DESCRIBE `ports` 0.0015490055084229
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 497))) 0.0003361701965332
(310) DESCRIBE `ports` 0.0013759136199951
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '497') 0.00028109550476074
(312) DESCRIBE `ports` 0.0016748905181885
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00046491622924805
(314) DESCRIBE `ports` 0.0018119812011719
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00034713745117188
(316) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69283') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.0060050487518311
(317) DESCRIBE `avid_specials` 0.001910924911499
(318) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69283 and class = 'Cruise') OR (item_id = 1409 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 35 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.0017180442810059
(319) DESCRIBE `cruiselines` 0.0025761127471924
(320) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00046300888061523
(321) DESCRIBE `orchid_image` 0.0019490718841553
(322) DESCRIBE `cruiselines` 0.0023138523101807
(323) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0004279613494873
(324) DESCRIBE `cruises` 0.002993106842041
(325) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '54857') 0.00034689903259277
(326) DESCRIBE `ships` 0.002985954284668
(327) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1135))) 0.00039386749267578
(328) DESCRIBE `ships` 0.0024039745330811
(329) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1135') 0.00059008598327637
(330) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027203559875488
(331) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025606155395508
(332) DESCRIBE `itineraries` 0.001338005065918
(333) DESCRIBE `ports` 0.0013768672943115
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00032782554626465
(335) DESCRIBE `ports` 0.0013618469238281
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00030398368835449
(337) DESCRIBE `ports` 0.0013189315795898
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00029301643371582
(339) DESCRIBE `sailingdates` 0.0013809204101562
(340) DESCRIBE `ports` 0.0014650821685791
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00035309791564941
(342) DESCRIBE `ports` 0.0014939308166504
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00036907196044922
(344) DESCRIBE `ports` 0.0015959739685059
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00042605400085449
(346) DESCRIBE `ports` 0.0016570091247559
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00035309791564941
(348) DESCRIBE `ports` 0.001655101776123
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 560))) 0.00041604042053223
(350) DESCRIBE `ports` 0.0017960071563721
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '560') 0.00037789344787598
(352) DESCRIBE `ports` 0.0019102096557617
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00046396255493164
(354) DESCRIBE `ports` 0.0018270015716553
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00041699409484863
(356) DESCRIBE `ports` 0.0017499923706055
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00040698051452637
(358) DESCRIBE `ports` 0.0018060207366943
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00040102005004883
(360) DESCRIBE `ports` 0.0017919540405273
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00040984153747559
(362) DESCRIBE `ports` 0.0017359256744385
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00040102005004883
(364) DESCRIBE `ports` 0.0016238689422607
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00039005279541016
(366) DESCRIBE `ports` 0.0017709732055664
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00040006637573242
(368) DESCRIBE `ports` 0.0017740726470947
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00042104721069336
(370) DESCRIBE `ports` 0.0017688274383545
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00039005279541016
(372) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '54857') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.0070979595184326
(373) DESCRIBE `avid_specials` 0.0015461444854736
(374) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 54857 and class = 'Cruise') OR (item_id = 1135 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 26 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.0011210441589355
(375) DESCRIBE `cruiselines` 0.0022251605987549
(376) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00034189224243164
(377) DESCRIBE `orchid_image` 0.0015928745269775
(378) DESCRIBE `cruiselines` 0.002068042755127
(379) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00035500526428223
(380) DESCRIBE `cruises` 0.0028138160705566
(381) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66532') 0.00038385391235352
(382) DESCRIBE `ships` 0.002979040145874
(383) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 98))) 0.00042295455932617
(384) DESCRIBE `ships` 0.0029339790344238
(385) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '98') 0.00034999847412109
(386) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026702880859375
(387) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028800964355469
(388) DESCRIBE `itineraries` 0.0013108253479004
(389) DESCRIBE `ports` 0.001615047454834
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00038790702819824
(391) DESCRIBE `ports` 0.0014028549194336
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00031590461730957
(393) DESCRIBE `ports` 0.0017459392547607
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.0003819465637207
(395) DESCRIBE `sailingdates` 0.0012450218200684
(396) DESCRIBE `ports` 0.0013730525970459
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00043201446533203
(398) DESCRIBE `ports` 0.0015559196472168
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00039005279541016
(400) DESCRIBE `ports` 0.0018119812011719
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00043296813964844
(402) DESCRIBE `ports` 0.0018289089202881
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00047588348388672
(404) DESCRIBE `ports` 0.0018188953399658
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 30))) 0.0004580020904541
(406) DESCRIBE `ports` 0.0020170211791992
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '30') 0.00041103363037109
(408) DESCRIBE `ports` 0.0020520687103271
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00048613548278809
(410) DESCRIBE `ports` 0.001986026763916
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00041389465332031
(412) DESCRIBE `ports` 0.0019710063934326
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 58))) 0.00039005279541016
(414) DESCRIBE `ports` 0.0014150142669678
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '58') 0.00030398368835449
(416) DESCRIBE `ports` 0.001305103302002
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00035500526428223
(418) DESCRIBE `ports` 0.0013589859008789
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00028896331787109
(420) DESCRIBE `ports` 0.0014770030975342
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00041103363037109
(422) DESCRIBE `ports` 0.0013949871063232
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00038003921508789
(424) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66532') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.0092518329620361
(425) DESCRIBE `avid_specials` 0.0019140243530273
(426) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66532 and class = 'Cruise') OR (item_id = 98 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017421245574951
(427) DESCRIBE `cruiselines` 0.0028650760650635
(428) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00062394142150879
(429) DESCRIBE `orchid_image` 0.0021820068359375
(430) DESCRIBE `cruiselines` 0.0026898384094238
(431) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00046896934509277
(432) DESCRIBE `cruises` 0.0032670497894287
(433) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66526') 0.00036501884460449
(434) DESCRIBE `ships` 0.0028691291809082
(435) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 542))) 0.00050711631774902
(436) DESCRIBE `ships` 0.0038831233978271
(437) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '542') 0.00047087669372559
(438) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003659725189209
(439) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003199577331543
(440) DESCRIBE `itineraries` 0.0019412040710449
(441) DESCRIBE `ports` 0.0021908283233643
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00047612190246582
(443) DESCRIBE `ports` 0.0017209053039551
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00059199333190918
(445) DESCRIBE `ports` 0.0018270015716553
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00043582916259766
(447) DESCRIBE `sailingdates` 0.00152587890625
(448) DESCRIBE `ports` 0.0023140907287598
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00047516822814941
(450) DESCRIBE `ports` 0.0019369125366211
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00043582916259766
(452) DESCRIBE `ports` 0.0022568702697754
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.000885009765625
(454) DESCRIBE `ports` 0.0021870136260986
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00057005882263184
(456) DESCRIBE `ports` 0.0041589736938477
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00048494338989258
(458) DESCRIBE `ports` 0.0020649433135986
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00043392181396484
(460) DESCRIBE `ports` 0.0018529891967773
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00047492980957031
(462) DESCRIBE `ports` 0.0017728805541992
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00037908554077148
(464) DESCRIBE `ports` 0.0017778873443604
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0004889965057373
(466) DESCRIBE `ports` 0.0018470287322998
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.0003809928894043
(468) DESCRIBE `ports` 0.0018019676208496
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00041317939758301
(470) DESCRIBE `ports` 0.0017960071563721
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00037789344787598
(472) DESCRIBE `ports` 0.0017619132995605
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 704))) 0.00043106079101562
(474) DESCRIBE `ports` 0.0015878677368164
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '704') 0.00037813186645508
(476) DESCRIBE `ports` 0.0017240047454834
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.0004270076751709
(478) DESCRIBE `ports` 0.0016999244689941
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00038814544677734
(480) DESCRIBE `ports` 0.0017540454864502
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00044608116149902
(482) DESCRIBE `ports` 0.0018501281738281
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00039792060852051
(484) DESCRIBE `ports` 0.0018241405487061
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3719))) 0.00045299530029297
(486) DESCRIBE `ports` 0.0018260478973389
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3719') 0.00040292739868164
(488) DESCRIBE `ports` 0.0017619132995605
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00051021575927734
(490) DESCRIBE `ports` 0.0017621517181396
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00044918060302734
(492) DESCRIBE `ports` 0.001849889755249
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00045299530029297
(494) DESCRIBE `ports` 0.0018060207366943
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00039196014404297
(496) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66526') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.010104894638062
(497) DESCRIBE `avid_specials` 0.0019640922546387
(498) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66526 and class = 'Cruise') OR (item_id = 542 AND class = 'Ship') OR (item_id = 23 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.0018010139465332
(499) DESCRIBE `cruiselines` 0.0025749206542969
(500) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00059700012207031
(501) DESCRIBE `orchid_image` 0.002147912979126
(502) DESCRIBE `cruiselines` 0.0026431083679199
(503) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00045394897460938
(504) DESCRIBE `cruises` 0.0037200450897217
(505) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67509') 0.00014805793762207
(506) DESCRIBE `ships` 0.0043258666992188
(507) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 434))) 0.00064802169799805
(508) DESCRIBE `ships` 0.003838062286377
(509) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '434') 0.00048017501831055
(510) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031614303588867
(511) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002901554107666
(512) DESCRIBE `itineraries` 0.0026810169219971
(513) DESCRIBE `ports` 0.002112865447998
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00064516067504883
(515) DESCRIBE `ports` 0.0020511150360107
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00045394897460938
(517) DESCRIBE `ports` 0.0018148422241211
(518) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00043702125549316
(519) DESCRIBE `sailingdates` 0.0016129016876221
(520) DESCRIBE `ports` 0.0021510124206543
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00051212310791016
(522) DESCRIBE `ports` 0.0026130676269531
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00062799453735352
(524) DESCRIBE `ports` 0.0020511150360107
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00054407119750977
(526) DESCRIBE `ports` 0.0019810199737549
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00022387504577637
(528) DESCRIBE `ports` 0.0019519329071045
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00059413909912109
(530) DESCRIBE `ports` 0.0019609928131104
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00054097175598145
(532) DESCRIBE `ports` 0.0015950202941895
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00048184394836426
(534) DESCRIBE `ports` 0.0019009113311768
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00048112869262695
(536) DESCRIBE `ports` 0.0018858909606934
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00048303604125977
(538) DESCRIBE `ports` 0.0021090507507324
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00042915344238281
(540) DESCRIBE `ports` 0.0019090175628662
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00047111511230469
(542) DESCRIBE `ports` 0.0019829273223877
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00044703483581543
(544) DESCRIBE `ports` 0.001723051071167
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00050902366638184
(546) DESCRIBE `ports` 0.0017287731170654
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00047612190246582
(548) DESCRIBE `ports` 0.0017349720001221
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00062918663024902
(550) DESCRIBE `ports` 0.0023610591888428
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00053000450134277
(552) DESCRIBE `ports` 0.0020520687103271
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00049591064453125
(554) DESCRIBE `ports` 0.002608060836792
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00039100646972656
(556) DESCRIBE `ports` 0.002161979675293
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00054097175598145
(558) DESCRIBE `ports` 0.0021500587463379
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00044584274291992
(560) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '67509') AND (sailingdate >= '2018-05-01') AND (sailingdate <= '2018-10-31') 0.0099799633026123
(561) DESCRIBE `avid_specials` 0.0026459693908691
(562) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67509 and class = 'Cruise') OR (item_id = 434 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017859935760498
(563) DESCRIBE `cruiselines` 0.002769947052002
(564) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0006558895111084
(565) DESCRIBE `orchid_image` 0.0020570755004883
(566) DESCRIBE `cruiselines` 0.0026459693908691
(567) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00050520896911621
(568) DESCRIBE `ships` 0.003964900970459
(569) SELECT `ships`.* FROM `ships` WHERE (id IN ('349', '542', '434', '1135', '348', '678', '253', '290', '580', '1021', '98', '406', '291', '341', '451', '1409', '105')) ORDER BY FIND_IN_SET(id, '349,542,434,1135,348,678,253,290,580,1021,98,406,291,341,451,1409,105') 0.002007007598877
(570) DESCRIBE `cruisetypes` 0.0017950534820557
(571) DESCRIBE `destinations` 0.0027439594268799
(572) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('2', '35', '22', '34', '43', '48', '11', '8', '38', '12', '26', '40', '53', '21', '29', '28', '49')) ORDER BY FIND_IN_SET(id, '2,35,22,34,43,48,11,8,38,12,26,40,53,21,29,28,49') 0.0017390251159668
(573) DESCRIBE `cruiselines` 0.0028679370880127
(574) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00016903877258301
(575) DESCRIBE `cruiselines` 0.0030100345611572
(576) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00081801414489746