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

Total elapsed time: 0.6298840045929

# Query Time
(1) connect 0.00079703330993652
(2) DESCRIBE `cruises` 0.0030169486999512
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (68310, 66164, 67968, 69078, 71455, 66165, 67999, 70204, 68168, 67969)) ORDER BY FIND_IN_SET(id, '68310,66164,67968,69078,71455,66165,67999,70204,68168,67969') 0.0016059875488281
(4) DESCRIBE `cruises` 0.0026810169219971
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68310') 0.00033187866210938
(6) DESCRIBE `ships` 0.0027241706848145
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1067))) 0.00038695335388184
(8) DESCRIBE `ships` 0.0027010440826416
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1067') 0.00034403800964355
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026202201843262
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024914741516113
(12) DESCRIBE `itineraries` 0.0013859272003174
(13) DESCRIBE `ports` 0.0014140605926514
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00034308433532715
(15) DESCRIBE `ports` 0.0012469291687012
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00028300285339355
(17) DESCRIBE `ports` 0.0012710094451904
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00027704238891602
(19) DESCRIBE `sailingdates` 0.001107931137085
(20) DESCRIBE `ports` 0.0012519359588623
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.0002901554107666
(22) DESCRIBE `ports` 0.0012710094451904
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00027203559875488
(24) DESCRIBE `ports` 0.0012800693511963
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00030303001403809
(26) DESCRIBE `ports` 0.0013058185577393
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0002751350402832
(28) DESCRIBE `ports` 0.0012381076812744
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00028610229492188
(30) DESCRIBE `ports` 0.0013151168823242
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00029492378234863
(32) DESCRIBE `ports` 0.0014121532440186
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00038599967956543
(34) DESCRIBE `ports` 0.0013501644134521
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00028491020202637
(36) DESCRIBE `ports` 0.0012719631195068
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00029993057250977
(38) DESCRIBE `ports` 0.0013961791992188
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00027298927307129
(40) DESCRIBE `ports` 0.0016529560089111
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 69))) 0.00030207633972168
(42) DESCRIBE `ports` 0.0012500286102295
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '69') 0.00027322769165039
(44) DESCRIBE `ports` 0.0012748241424561
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00034499168395996
(46) DESCRIBE `ports` 0.0012648105621338
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00033998489379883
(48) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68310') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0048539638519287
(49) DESCRIBE `avid_specials` 0.0015060901641846
(50) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68310 and class = 'Cruise') OR (item_id = 1067 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010321140289307
(51) DESCRIBE `cruiselines` 0.0018460750579834
(52) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00034379959106445
(53) DESCRIBE `orchid_image` 0.0015900135040283
(54) DESCRIBE `cruiselines` 0.0018079280853271
(55) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00034880638122559
(56) DESCRIBE `cruises` 0.0024909973144531
(57) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66164') 0.0003209114074707
(58) DESCRIBE `ships` 0.0025599002838135
(59) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 766))) 0.00035810470581055
(60) DESCRIBE `ships` 0.0024659633636475
(61) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '766') 0.00030183792114258
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028800964355469
(63) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025105476379395
(64) DESCRIBE `itineraries` 0.0012378692626953
(65) DESCRIBE `ports` 0.0013339519500732
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00031590461730957
(67) DESCRIBE `ports` 0.0013070106506348
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00028491020202637
(69) DESCRIBE `ports` 0.00124192237854
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.00028514862060547
(71) DESCRIBE `sailingdates` 0.0011250972747803
(72) DESCRIBE `ports` 0.0013799667358398
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00030279159545898
(74) DESCRIBE `ports` 0.0012428760528564
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.00027704238891602
(76) DESCRIBE `ports` 0.0012860298156738
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.00028800964355469
(78) DESCRIBE `ports` 0.0012729167938232
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.00026893615722656
(80) DESCRIBE `ports` 0.0013620853424072
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00028800964355469
(82) DESCRIBE `ports` 0.0012359619140625
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00026702880859375
(84) DESCRIBE `ports` 0.0012650489807129
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00029802322387695
(86) DESCRIBE `ports` 0.0012938976287842
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00026798248291016
(88) DESCRIBE `ports` 0.0015521049499512
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 3.6954879760742E-5
(90) DESCRIBE `ports` 0.0012190341949463
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0
(92) DESCRIBE `ports` 0.0011851787567139
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00028896331787109
(94) DESCRIBE `ports` 0.0019278526306152
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0
(96) DESCRIBE `ports` 0.0012619495391846
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00029897689819336
(98) DESCRIBE `ports` 0.001708984375
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.00026702880859375
(100) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66164') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0060479640960693
(101) DESCRIBE `avid_specials` 0.0012829303741455
(102) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66164 and class = 'Cruise') OR (item_id = 766 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 28 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.0011141300201416
(103) DESCRIBE `cruiselines` 0.0021951198577881
(104) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00037503242492676
(105) DESCRIBE `orchid_image` 0.0014801025390625
(106) DESCRIBE `cruiselines` 0.001209020614624
(107) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00028610229492188
(108) DESCRIBE `cruises` 0.0032169818878174
(109) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67968') 0.00031304359436035
(110) DESCRIBE `ships` 0.0025699138641357
(111) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 977))) 0.00035691261291504
(112) DESCRIBE `ships` 0.0025911331176758
(113) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '977') 0.00033402442932129
(114) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002601146697998
(115) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025200843811035
(116) DESCRIBE `itineraries` 0.0013189315795898
(117) DESCRIBE `ports` 0.001305103302002
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00033998489379883
(119) DESCRIBE `ports` 0.0012471675872803
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00028586387634277
(121) DESCRIBE `ports` 0.0012409687042236
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00030398368835449
(123) DESCRIBE `sailingdates` 0.0012838840484619
(124) DESCRIBE `ports` 0.0013179779052734
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00029802322387695
(126) DESCRIBE `ports` 0.0012497901916504
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00032687187194824
(128) DESCRIBE `ports` 0.0013768672943115
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00030994415283203
(130) DESCRIBE `ports` 0.0013091564178467
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00027990341186523
(132) DESCRIBE `ports` 0.0012969970703125
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.0003199577331543
(134) DESCRIBE `ports` 0.0013267993927002
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00028514862060547
(136) DESCRIBE `ports` 0.0012879371643066
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00031900405883789
(138) DESCRIBE `ports` 0.0013349056243896
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00029397010803223
(140) DESCRIBE `ports` 0.0012578964233398
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00030517578125
(142) DESCRIBE `ports` 0.001317024230957
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00027585029602051
(144) DESCRIBE `ports` 0.0012619495391846
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00032997131347656
(146) DESCRIBE `ports` 0.0013201236724854
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00030803680419922
(148) DESCRIBE `ports` 0.0013649463653564
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00032591819763184
(150) DESCRIBE `ports` 0.0012731552124023
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00028586387634277
(152) DESCRIBE `ports` 0.0015349388122559
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.0003058910369873
(154) DESCRIBE `ports` 0.0012989044189453
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00028395652770996
(156) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '67968') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0067510604858398
(157) DESCRIBE `avid_specials` 0.0016679763793945
(158) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67968 and class = 'Cruise') OR (item_id = 977 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001068115234375
(159) DESCRIBE `cruiselines` 0.0024750232696533
(160) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00036311149597168
(161) DESCRIBE `orchid_image` 0.0014760494232178
(162) DESCRIBE `cruiselines` 0.0018007755279541
(163) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00030803680419922
(164) DESCRIBE `cruises` 0.0033860206604004
(165) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69078') 0.00038409233093262
(166) DESCRIBE `ships` 0.0033318996429443
(167) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1588))) 0
(168) DESCRIBE `ships` 0.0025789737701416
(169) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1588') 0
(170) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026702880859375
(171) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025486946105957
(172) DESCRIBE `itineraries` 0.0012860298156738
(173) DESCRIBE `ports` 0.0013401508331299
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00034689903259277
(175) DESCRIBE `ports` 0.0022602081298828
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0
(177) DESCRIBE `ports` 0.0012650489807129
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00028395652770996
(179) DESCRIBE `sailingdates` 0.00027608871459961
(180) DESCRIBE `ports` 0.0013768672943115
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00031709671020508
(182) DESCRIBE `ports` 0.0013179779052734
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00031208992004395
(184) DESCRIBE `ports` 0.0004270076751709
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00031709671020508
(186) DESCRIBE `ports` 0.0012788772583008
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0
(188) DESCRIBE `ports` 0.0010979175567627
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00030112266540527
(190) DESCRIBE `ports` 0.0019030570983887
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00031495094299316
(192) DESCRIBE `ports` 0.0017039775848389
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00030899047851562
(194) DESCRIBE `ports` 0.00049400329589844
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00029492378234863
(196) DESCRIBE `ports` 0.0016250610351562
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0
(198) DESCRIBE `ports` 0.0013191699981689
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00028800964355469
(200) DESCRIBE `ports` 0.0015668869018555
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00030398368835449
(202) DESCRIBE `ports` 0.0013039112091064
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.0011301040649414
(204) DESCRIBE `ports` 0.00060200691223145
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00036191940307617
(206) DESCRIBE `ports` 0.0013120174407959
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0
(208) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69078') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0048179626464844
(209) DESCRIBE `avid_specials` 0.001262903213501
(210) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69078 and class = 'Cruise') OR (item_id = 1588 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00037503242492676
(211) DESCRIBE `cruiselines` 0.0018880367279053
(212) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0
(213) DESCRIBE `orchid_image` 0.0014839172363281
(214) DESCRIBE `cruiselines` 0.0031418800354004
(215) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00040984153747559
(216) DESCRIBE `cruises` 0.0034749507904053
(217) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71455') 0.00040197372436523
(218) DESCRIBE `ships` 0.0037000179290771
(219) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 407))) 0.00056195259094238
(220) DESCRIBE `ships` 0.0036969184875488
(221) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '407') 0.00042915344238281
(222) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035500526428223
(223) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030803680419922
(224) DESCRIBE `itineraries` 0.0018329620361328
(225) DESCRIBE `ports` 0.0019280910491943
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00046420097351074
(227) DESCRIBE `ports` 0.0013999938964844
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00031614303588867
(229) DESCRIBE `ports` 0.001270055770874
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00028586387634277
(231) DESCRIBE `sailingdates` 0.0011200904846191
(232) DESCRIBE `ports` 0.0012838840484619
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.0003209114074707
(234) DESCRIBE `ports` 0.0014040470123291
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00029516220092773
(236) DESCRIBE `ports` 0.0013549327850342
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00043106079101562
(238) DESCRIBE `ports` 0.0015308856964111
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00028395652770996
(240) DESCRIBE `ports` 0.0012919902801514
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00030016899108887
(242) DESCRIBE `ports` 0.0012519359588623
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00027203559875488
(244) DESCRIBE `ports` 0.0013070106506348
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00030016899108887
(246) DESCRIBE `ports` 0.0012569427490234
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00027298927307129
(248) DESCRIBE `ports` 0.0012869834899902
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00031208992004395
(250) DESCRIBE `ports` 0.0014388561248779
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00041580200195312
(252) DESCRIBE `ports` 0.0013608932495117
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00031399726867676
(254) DESCRIBE `ports` 0.0016708374023438
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00034904479980469
(256) DESCRIBE `ports` 0.0017430782318115
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00030303001403809
(258) DESCRIBE `ports` 0.0016889572143555
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00040888786315918
(260) DESCRIBE `ports` 0.0016779899597168
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00044584274291992
(262) DESCRIBE `ports` 0.0016450881958008
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.0003809928894043
(264) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '71455') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.006087064743042
(265) DESCRIBE `avid_specials` 0.0017039775848389
(266) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71455 and class = 'Cruise') OR (item_id = 407 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015678405761719
(267) DESCRIBE `cruiselines` 0.0024991035461426
(268) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00043106079101562
(269) DESCRIBE `orchid_image` 0.0019111633300781
(270) DESCRIBE `cruiselines` 0.0019769668579102
(271) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00038480758666992
(272) DESCRIBE `cruises` 0.0031969547271729
(273) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66165') 0.00042009353637695
(274) DESCRIBE `ships` 0.0035028457641602
(275) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 766))) 0.00046300888061523
(276) DESCRIBE `ships` 0.0027470588684082
(277) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '766') 0.00042414665222168
(278) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019192695617676
(279) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030517578125
(280) DESCRIBE `itineraries` 0.0015108585357666
(281) DESCRIBE `ports` 0.0010318756103516
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.00038886070251465
(283) DESCRIBE `ports` 0.0016300678253174
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.00045514106750488
(285) DESCRIBE `ports` 0.0013689994812012
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.0003209114074707
(287) DESCRIBE `sailingdates` 0.0015120506286621
(288) DESCRIBE `ports` 0.0014710426330566
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.00034999847412109
(290) DESCRIBE `ports` 0.0014171600341797
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.00029301643371582
(292) DESCRIBE `ports` 0.0013809204101562
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00035285949707031
(294) DESCRIBE `ports` 0.0012729167938232
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00029182434082031
(296) DESCRIBE `ports` 0.0013668537139893
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2357))) 0.00033211708068848
(298) DESCRIBE `ports` 0.0013301372528076
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2357') 0.00036907196044922
(300) DESCRIBE `ports` 0.0013370513916016
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00030088424682617
(302) DESCRIBE `ports` 0.0012569427490234
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00026512145996094
(304) DESCRIBE `ports` 0.001284122467041
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00030803680419922
(306) DESCRIBE `ports` 0.0013151168823242
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00034689903259277
(308) DESCRIBE `ports` 0.0013449192047119
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00030899047851562
(310) DESCRIBE `ports` 0.0014801025390625
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.00027704238891602
(312) DESCRIBE `ports` 0.0014538764953613
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.00031304359436035
(314) DESCRIBE `ports` 0.0013561248779297
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.0002901554107666
(316) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66165') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0050561428070068
(317) DESCRIBE `avid_specials` 0.0014631748199463
(318) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66165 and class = 'Cruise') OR (item_id = 766 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 28 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.0010640621185303
(319) DESCRIBE `cruiselines` 0.0021779537200928
(320) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00036787986755371
(321) DESCRIBE `orchid_image` 0.0015978813171387
(322) DESCRIBE `cruiselines` 0.0019569396972656
(323) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00032401084899902
(324) DESCRIBE `cruises` 0.0026421546936035
(325) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67999') 0.00032901763916016
(326) DESCRIBE `ships` 0.002626895904541
(327) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 726))) 0.0004119873046875
(328) DESCRIBE `ships` 0.0029370784759521
(329) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '726') 0.00034213066101074
(330) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026702880859375
(331) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026702880859375
(332) DESCRIBE `itineraries` 0.0012540817260742
(333) DESCRIBE `ports` 0.0014069080352783
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00032687187194824
(335) DESCRIBE `ports` 0.0014729499816895
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031590461730957
(337) DESCRIBE `ports` 0.00136399269104
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00029802322387695
(339) DESCRIBE `sailingdates` 0.0011711120605469
(340) DESCRIBE `ports` 0.0014100074768066
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00034785270690918
(342) DESCRIBE `ports` 0.0012960433959961
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00028276443481445
(344) DESCRIBE `ports` 0.0018019676208496
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.0003352165222168
(346) DESCRIBE `ports` 0.0013442039489746
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00034499168395996
(348) DESCRIBE `ports` 0.0014960765838623
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00033903121948242
(350) DESCRIBE `ports` 0.0014529228210449
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00041103363037109
(352) DESCRIBE `ports` 0.0018680095672607
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2264))) 0.00050783157348633
(354) DESCRIBE `ports` 0.0020108222961426
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2264') 0.00034499168395996
(356) DESCRIBE `ports` 0.0012938976287842
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00031590461730957
(358) DESCRIBE `ports` 0.0013079643249512
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00028181076049805
(360) DESCRIBE `ports` 0.0012750625610352
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00032615661621094
(362) DESCRIBE `ports` 0.0013020038604736
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00027894973754883
(364) DESCRIBE `ports` 0.0012900829315186
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.0003669261932373
(366) DESCRIBE `ports` 0.001349925994873
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00029611587524414
(368) DESCRIBE `ports` 0.0013651847839355
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00030994415283203
(370) DESCRIBE `ports` 0.0013258457183838
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00028204917907715
(372) DESCRIBE `ports` 0.0013740062713623
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031781196594238
(374) DESCRIBE `ports` 0.0013608932495117
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00028586387634277
(376) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '67999') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0049560070037842
(377) DESCRIBE `avid_specials` 0.0014810562133789
(378) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67999 and class = 'Cruise') OR (item_id = 726 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011048316955566
(379) DESCRIBE `cruiselines` 0.0018789768218994
(380) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00042605400085449
(381) DESCRIBE `orchid_image` 0.0016012191772461
(382) DESCRIBE `cruiselines` 0.0018391609191895
(383) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00032496452331543
(384) DESCRIBE `cruises` 0.0025038719177246
(385) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70204') 0.0003361701965332
(386) DESCRIBE `ships` 0.0026299953460693
(387) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 977))) 0.00044012069702148
(388) DESCRIBE `ships` 0.0031387805938721
(389) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '977') 0.00047087669372559
(390) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035285949707031
(391) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034213066101074
(392) DESCRIBE `itineraries` 0.0019700527191162
(393) DESCRIBE `ports` 0.0019049644470215
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00044608116149902
(395) DESCRIBE `ports` 0.0017709732055664
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00042319297790527
(397) DESCRIBE `ports` 0.001762866973877
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00022101402282715
(399) DESCRIBE `sailingdates` 0.0012800693511963
(400) DESCRIBE `ports` 0.001399040222168
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00037693977355957
(402) DESCRIBE `ports` 0.001471996307373
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0
(404) DESCRIBE `ports` 0.0010631084442139
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00030684471130371
(406) DESCRIBE `ports` 0.0017709732055664
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00034904479980469
(408) DESCRIBE `ports` 0.0013468265533447
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00097203254699707
(410) DESCRIBE `ports` 0.0010299682617188
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00031805038452148
(412) DESCRIBE `ports` 0.0019028186798096
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00020313262939453
(414) DESCRIBE `ports` 0.0013060569763184
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00028681755065918
(416) DESCRIBE `ports` 0.0013620853424072
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0003199577331543
(418) DESCRIBE `ports` 0.0012979507446289
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0012490749359131
(420) DESCRIBE `ports` 0.0008389949798584
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.0003211498260498
(422) DESCRIBE `ports` 0.0020349025726318
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00019311904907227
(424) DESCRIBE `ports` 0.0014331340789795
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00030994415283203
(426) DESCRIBE `ports` 0.0013151168823242
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00031709671020508
(428) DESCRIBE `ports` 0.0013129711151123
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.0010528564453125
(430) DESCRIBE `ports` 0.0010190010070801
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00031495094299316
(432) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '70204') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0069260597229004
(433) DESCRIBE `avid_specials` 0.0022718906402588
(434) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70204 and class = 'Cruise') OR (item_id = 977 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012581348419189
(435) DESCRIBE `cruiselines` 0.0023880004882812
(436) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00040197372436523
(437) DESCRIBE `orchid_image` 0.0016260147094727
(438) DESCRIBE `cruiselines` 0.002310037612915
(439) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00036811828613281
(440) DESCRIBE `cruises` 0.0028419494628906
(441) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68168') 0.00036907196044922
(442) DESCRIBE `ships` 0.002763032913208
(443) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 610))) 0.00046586990356445
(444) DESCRIBE `ships` 0.0032219886779785
(445) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '610') 0.00046801567077637
(446) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032305717468262
(447) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034499168395996
(448) DESCRIBE `itineraries` 0.0017149448394775
(449) DESCRIBE `ports` 0.0017120838165283
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00051689147949219
(451) DESCRIBE `ports` 0.0016639232635498
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00038409233093262
(453) DESCRIBE `ports` 0.0017070770263672
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00040602684020996
(455) DESCRIBE `sailingdates` 0.0013000965118408
(456) DESCRIBE `ports` 0.0015389919281006
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00043106079101562
(458) DESCRIBE `ports` 0.0014359951019287
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00030612945556641
(460) DESCRIBE `ports` 0.0015130043029785
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.001168966293335
(462) DESCRIBE `ports` 0.00098109245300293
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00033402442932129
(464) DESCRIBE `ports` 0.0017859935760498
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00047898292541504
(466) DESCRIBE `ports` 0.00211501121521
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00043201446533203
(468) DESCRIBE `ports` 0.0019199848175049
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00043702125549316
(470) DESCRIBE `ports` 0.0017690658569336
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00030207633972168
(472) DESCRIBE `ports` 0.0013430118560791
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00037813186645508
(474) DESCRIBE `ports` 0.0013120174407959
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00029087066650391
(476) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68168') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0063719749450684
(477) DESCRIBE `avid_specials` 0.0016889572143555
(478) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68168 and class = 'Cruise') OR (item_id = 610 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0018839836120605
(479) DESCRIBE `cruiselines` 0.0035889148712158
(480) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00040292739868164
(481) DESCRIBE `orchid_image` 0.0020439624786377
(482) DESCRIBE `cruiselines` 0.0023500919342041
(483) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00041913986206055
(484) DESCRIBE `cruises` 0.0028359889984131
(485) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67969') 0.0015900135040283
(486) DESCRIBE `ships` 0.004188060760498
(487) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 977))) 0.0006251335144043
(488) DESCRIBE `ships` 0.0038549900054932
(489) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '977') 0.00054502487182617
(490) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036120414733887
(491) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033092498779297
(492) DESCRIBE `itineraries` 0.0019910335540771
(493) DESCRIBE `ports` 0.0020840167999268
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00047206878662109
(495) DESCRIBE `ports` 0.001896858215332
(496) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00042891502380371
(497) DESCRIBE `ports` 0.0018181800842285
(498) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00041484832763672
(499) DESCRIBE `sailingdates` 0.0015990734100342
(500) DESCRIBE `ports` 0.0019590854644775
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00049710273742676
(502) DESCRIBE `ports` 0.0018458366394043
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00041103363037109
(504) DESCRIBE `ports` 0.0018692016601562
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00043702125549316
(506) DESCRIBE `ports` 0.0019290447235107
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00042295455932617
(508) DESCRIBE `ports` 0.0019149780273438
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00049114227294922
(510) DESCRIBE `ports` 0.0020179748535156
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00044989585876465
(512) DESCRIBE `ports` 0.0019910335540771
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00045609474182129
(514) DESCRIBE `ports` 0.0019659996032715
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00043010711669922
(516) DESCRIBE `ports` 0.0018539428710938
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00049591064453125
(518) DESCRIBE `ports` 0.0019388198852539
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00036382675170898
(520) DESCRIBE `ports` 0.0015799999237061
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00034904479980469
(522) DESCRIBE `ports` 0.0014030933380127
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00036382675170898
(524) DESCRIBE `ports` 0.0016119480133057
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.0003960132598877
(526) DESCRIBE `ports` 0.001558780670166
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00029802322387695
(528) DESCRIBE `ports` 0.001291036605835
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.0003211498260498
(530) DESCRIBE `ports` 0.0013880729675293
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00030708312988281
(532) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '67969') AND (sailingdate >= '2018-03-25') AND (sailingdate <= '2019-04-26') 0.0060608386993408
(533) DESCRIBE `avid_specials` 0.0016839504241943
(534) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67969 and class = 'Cruise') OR (item_id = 977 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00142502784729
(535) DESCRIBE `cruiselines` 0.0023579597473145
(536) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00073599815368652
(537) DESCRIBE `orchid_image` 0.0022830963134766
(538) DESCRIBE `cruiselines` 0.0026211738586426
(539) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00037384033203125
(540) DESCRIBE `ships` 0.0039210319519043
(541) SELECT `ships`.* FROM `ships` WHERE (id IN ('1359', '407', '1588', '1067', '462', '766', '1415', '977', '553', '726', '452', '738', '674', '352', '1599', '610')) ORDER BY FIND_IN_SET(id, '1359,407,1588,1067,462,766,1415,977,553,726,452,738,674,352,1599,610') 0.0020949840545654
(542) DESCRIBE `cruisetypes` 0.0015010833740234
(543) DESCRIBE `destinations` 0.0024621486663818
(544) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '37', '45', '52', '38', '40', '28', '26', '35')) ORDER BY FIND_IN_SET(id, '22,12,37,45,52,38,40,28,26,35') 0.0015490055084229
(545) DESCRIBE `cruiselines` 0.002842903137207
(546) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00053286552429199
(547) DESCRIBE `cruiselines` 0.0027179718017578
(548) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00055599212646484