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

Total elapsed time: 1.3515832424164

# Query Time
(1) connect 0.00081896781921387
(2) DESCRIBE `cruises` 0.004021167755127
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66644, 67227, 54842, 66487, 66525, 70581, 54648, 59347, 66503, 66516)) ORDER BY FIND_IN_SET(id, '66644,67227,54842,66487,66525,70581,54648,59347,66503,66516') 0.0022850036621094
(4) DESCRIBE `cruises` 0.0041220188140869
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66644') 0.00066685676574707
(6) DESCRIBE `ships` 0.0042219161987305
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1021))) 0.00062298774719238
(8) DESCRIBE `ships` 0.0034880638122559
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1021') 0.0004279613494873
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030899047851562
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032806396484375
(12) DESCRIBE `itineraries` 0.0016558170318604
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66644') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00093889236450195
(14) DESCRIBE `ports` 0.0016989707946777
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00040411949157715
(16) DESCRIBE `ports` 0.0016999244689941
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00044417381286621
(18) DESCRIBE `ports` 0.0018110275268555
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.00037908554077148
(20) DESCRIBE `sailingdates` 0.0013730525970459
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66644') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00080609321594238
(22) DESCRIBE `ports` 0.0022640228271484
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00084114074707031
(24) DESCRIBE `ports` 0.0020041465759277
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.00047588348388672
(26) DESCRIBE `ports` 0.0019462108612061
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00044107437133789
(28) DESCRIBE `ports` 0.0017380714416504
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00040292739868164
(30) DESCRIBE `ports` 0.0022289752960205
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2417))) 0.00045180320739746
(32) DESCRIBE `ports` 0.0028200149536133
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2417') 0.0003972053527832
(34) DESCRIBE `ports` 0.0018470287322998
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 752))) 0.00040698051452637
(36) DESCRIBE `ports` 0.0017619132995605
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '752') 0.0003809928894043
(38) DESCRIBE `ports` 0.001708984375
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00048398971557617
(40) DESCRIBE `ports` 0.0016331672668457
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.0003669261932373
(42) DESCRIBE `ports` 0.0016119480133057
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00047588348388672
(44) DESCRIBE `ports` 0.0018401145935059
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00039505958557129
(46) DESCRIBE `ports` 0.0017938613891602
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 748))) 0.00059390068054199
(48) DESCRIBE `ports` 0.0019910335540771
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '748') 0.00054192543029785
(50) DESCRIBE `ports` 0.0027220249176025
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 747))) 0.00041699409484863
(52) DESCRIBE `ports` 0.0029480457305908
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '747') 0.00045680999755859
(54) DESCRIBE `ports` 0.00193190574646
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 747))) 0.00043082237243652
(56) DESCRIBE `ports` 0.0019519329071045
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '747') 0.00047707557678223
(58) DESCRIBE `ports` 0.0017580986022949
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 571))) 0.0004730224609375
(60) DESCRIBE `ports` 0.0018219947814941
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '571') 0.00053691864013672
(62) DESCRIBE `ports` 0.0018980503082275
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1089))) 0.0004570484161377
(64) DESCRIBE `ports` 0.0022621154785156
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1089') 0.00049901008605957
(66) DESCRIBE `ports` 0.0020039081573486
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00038886070251465
(68) DESCRIBE `ports` 0.0017709732055664
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.0031189918518066
(70) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66644') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.014128923416138
(71) DESCRIBE `avid_specials` 0.0018830299377441
(72) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66644 and class = 'Cruise') OR (item_id = 1021 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 21 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.0019118785858154
(73) DESCRIBE `cruiselines` 0.0028140544891357
(74) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00080609321594238
(75) DESCRIBE `orchid_image` 0.0021898746490479
(76) DESCRIBE `cruiselines` 0.0025708675384521
(77) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00041604042053223
(78) DESCRIBE `cruises` 0.0041911602020264
(79) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67227') 0.00069093704223633
(80) DESCRIBE `ships` 0.0051820278167725
(81) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1021))) 0.00085091590881348
(82) DESCRIBE `ships` 0.0052311420440674
(83) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1021') 0.00049901008605957
(84) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032305717468262
(85) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031614303588867
(86) DESCRIBE `itineraries` 0.0018889904022217
(87) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67227') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00068402290344238
(88) DESCRIBE `ports` 0.0031411647796631
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00049304962158203
(90) DESCRIBE `ports` 0.0021438598632812
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.0004429817199707
(92) DESCRIBE `ports` 0.0023629665374756
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00037503242492676
(94) DESCRIBE `sailingdates` 0.0015652179718018
(95) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67227') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00056695938110352
(96) DESCRIBE `ports` 0.0020411014556885
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00046396255493164
(98) DESCRIBE `ports` 0.0023260116577148
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00043201446533203
(100) DESCRIBE `ports` 0.0021510124206543
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2417))) 0.00053119659423828
(102) DESCRIBE `ports` 0.0018398761749268
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2417') 0.00034284591674805
(104) DESCRIBE `ports` 0.0016031265258789
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 752))) 0.0004122257232666
(106) DESCRIBE `ports` 0.0016632080078125
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '752') 0.00041508674621582
(108) DESCRIBE `ports` 0.0016710758209229
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00046420097351074
(110) DESCRIBE `ports` 0.0017790794372559
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00038409233093262
(112) DESCRIBE `ports` 0.0017991065979004
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00050187110900879
(114) DESCRIBE `ports` 0.0016860961914062
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00037002563476562
(116) DESCRIBE `ports` 0.0017368793487549
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 748))) 0.00038409233093262
(118) DESCRIBE `ports` 0.0016040802001953
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '748') 0.00033116340637207
(120) DESCRIBE `ports` 0.0015721321105957
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 747))) 0.00036096572875977
(122) DESCRIBE `ports` 0.0016529560089111
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '747') 0.00035810470581055
(124) DESCRIBE `ports` 0.0017838478088379
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 747))) 0.00013303756713867
(126) DESCRIBE `ports` 0.0019521713256836
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '747') 0.00040602684020996
(128) DESCRIBE `ports` 0.0020508766174316
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 571))) 0.00055503845214844
(130) DESCRIBE `ports` 0.0019450187683105
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '571') 0.00060415267944336
(132) DESCRIBE `ports` 0.0017561912536621
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1089))) 0.00040102005004883
(134) DESCRIBE `ports` 0.0015981197357178
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1089') 0.00037407875061035
(136) DESCRIBE `ports` 0.0017499923706055
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00039100646972656
(138) DESCRIBE `ports` 0.0017509460449219
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.00039982795715332
(140) DESCRIBE `ports` 0.001910924911499
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00043010711669922
(142) DESCRIBE `ports` 0.0018610954284668
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00038695335388184
(144) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '67227') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.010182857513428
(145) DESCRIBE `avid_specials` 0.0019068717956543
(146) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67227 and class = 'Cruise') OR (item_id = 1021 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 21 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.0017638206481934
(147) DESCRIBE `cruiselines` 0.0026090145111084
(148) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00034403800964355
(149) DESCRIBE `orchid_image` 0.0022358894348145
(150) DESCRIBE `cruiselines` 0.0027220249176025
(151) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00042986869812012
(152) DESCRIBE `cruises` 0.0032858848571777
(153) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '54842') 0.00043296813964844
(154) DESCRIBE `ships` 0.0035600662231445
(155) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1135))) 0.00068211555480957
(156) DESCRIBE `ships` 0.0038199424743652
(157) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1135') 0.0004580020904541
(158) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00039887428283691
(159) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033187866210938
(160) DESCRIBE `itineraries` 0.0018398761749268
(161) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '54842') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00084209442138672
(162) DESCRIBE `ports` 0.0021569728851318
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00048303604125977
(164) DESCRIBE `ports` 0.001863956451416
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00042891502380371
(166) DESCRIBE `ports` 0.0019209384918213
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00033998489379883
(168) DESCRIBE `sailingdates` 0.0013401508331299
(169) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '54842') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00069618225097656
(170) DESCRIBE `ports` 0.0022768974304199
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00048303604125977
(172) DESCRIBE `ports` 0.0021529197692871
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00043010711669922
(174) DESCRIBE `ports` 0.0041899681091309
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.005457878112793
(176) DESCRIBE `ports` 0.0022180080413818
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00088405609130859
(178) DESCRIBE `ports` 0.055155992507935
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00054192543029785
(180) DESCRIBE `ports` 0.0013439655303955
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.0003969669342041
(182) DESCRIBE `ports` 0.0016381740570068
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.0004279613494873
(184) DESCRIBE `ports` 0.0019450187683105
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00041604042053223
(186) DESCRIBE `ports` 0.0018761157989502
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00042009353637695
(188) DESCRIBE `ports` 0.0021328926086426
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.0003969669342041
(190) DESCRIBE `ports` 0.0018370151519775
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00011706352233887
(192) DESCRIBE `ports` 0.0017790794372559
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00063800811767578
(194) DESCRIBE `ports` 0.0017690658569336
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00044488906860352
(196) DESCRIBE `ports` 0.003026008605957
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00041794776916504
(198) DESCRIBE `ports` 0.0018250942230225
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 560))) 0.00040006637573242
(200) DESCRIBE `ports` 0.0018649101257324
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '560') 0.00037407875061035
(202) DESCRIBE `ports` 0.0018250942230225
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00064897537231445
(204) DESCRIBE `ports` 0.001884937286377
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00043487548828125
(206) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '54842') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0089778900146484
(207) DESCRIBE `avid_specials` 0.001939058303833
(208) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 54842 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.0017769336700439
(209) DESCRIBE `cruiselines` 0.02782416343689
(210) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00066781044006348
(211) DESCRIBE `orchid_image` 0.0020661354064941
(212) DESCRIBE `cruiselines` 0.0037479400634766
(213) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00047898292541504
(214) DESCRIBE `cruises` 0.0039081573486328
(215) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66487') 0.00050902366638184
(216) DESCRIBE `ships` 0.004004955291748
(217) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 406))) 0.00068283081054688
(218) DESCRIBE `ships` 0.0038747787475586
(219) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '406') 0.00054383277893066
(220) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003969669342041
(221) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029587745666504
(222) DESCRIBE `itineraries` 0.0018389225006104
(223) DESCRIBE `ports` 0.0020890235900879
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00048303604125977
(225) DESCRIBE `ports` 0.0019731521606445
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00041985511779785
(227) DESCRIBE `ports` 0.0019118785858154
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00039911270141602
(229) DESCRIBE `sailingdates` 0.0015990734100342
(230) DESCRIBE `ports` 0.0021600723266602
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00052595138549805
(232) DESCRIBE `ports` 0.0020298957824707
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00041103363037109
(234) DESCRIBE `ports` 0.0017502307891846
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.00042915344238281
(236) DESCRIBE `ports` 0.0019218921661377
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.00045990943908691
(238) DESCRIBE `ports` 0.0018739700317383
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) 0.00045299530029297
(240) DESCRIBE `ports` 0.0018479824066162
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') 0.00049090385437012
(242) DESCRIBE `ports` 0.0018410682678223
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 223))) 0.00046801567077637
(244) DESCRIBE `ports` 0.0017979145050049
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '223') 0.0042581558227539
(246) DESCRIBE `ports` 0.0028719902038574
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226))) 0.00043582916259766
(248) DESCRIBE `ports` 0.0090579986572266
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226') 0.00051999092102051
(250) DESCRIBE `ports` 0.0019071102142334
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.00050783157348633
(252) DESCRIBE `ports` 0.0018520355224609
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.00040698051452637
(254) DESCRIBE `ports` 0.00193190574646
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00054597854614258
(256) DESCRIBE `ports` 0.0019998550415039
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00044488906860352
(258) DESCRIBE `ports` 0.0019898414611816
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00065207481384277
(260) DESCRIBE `ports` 0.0022318363189697
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00080609321594238
(262) DESCRIBE `ports` 0.0019571781158447
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 800))) 0.00058889389038086
(264) DESCRIBE `ports` 0.0019209384918213
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '800') 0.00039386749267578
(266) DESCRIBE `ports` 0.0019168853759766
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00046896934509277
(268) DESCRIBE `ports` 0.0019450187683105
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.00041007995605469
(270) DESCRIBE `ports` 0.0019059181213379
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00052499771118164
(272) DESCRIBE `ports` 0.0019040107727051
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00045609474182129
(274) DESCRIBE `ports` 0.0025019645690918
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00061893463134766
(276) DESCRIBE `ports` 0.0017979145050049
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00038003921508789
(278) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66487') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0098540782928467
(279) DESCRIBE `avid_specials` 0.0020840167999268
(280) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66487 and class = 'Cruise') OR (item_id = 406 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 25 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.0017349720001221
(281) DESCRIBE `cruiselines` 0.0027570724487305
(282) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00048708915710449
(283) DESCRIBE `orchid_image` 0.002331018447876
(284) DESCRIBE `cruiselines` 0.0035941600799561
(285) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00062179565429688
(286) DESCRIBE `cruises` 0.01355504989624
(287) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66525') 0.00048398971557617
(288) DESCRIBE `ships` 0.0036649703979492
(289) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 542))) 0.00060606002807617
(290) DESCRIBE `ships` 0.0032730102539062
(291) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '542') 0.00038909912109375
(292) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028800964355469
(293) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027108192443848
(294) DESCRIBE `itineraries` 0.0020639896392822
(295) DESCRIBE `ports` 0.0022189617156982
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00044989585876465
(297) DESCRIBE `ports` 0.0017762184143066
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00043821334838867
(299) DESCRIBE `ports` 0.0018410682678223
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00042009353637695
(301) DESCRIBE `sailingdates` 0.0017070770263672
(302) DESCRIBE `ports` 0.0021262168884277
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00046300888061523
(304) DESCRIBE `ports` 0.0019071102142334
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00042390823364258
(306) DESCRIBE `ports` 0.0018191337585449
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.0004580020904541
(308) DESCRIBE `ports` 0.0019171237945557
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00044608116149902
(310) DESCRIBE `ports` 0.0018939971923828
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00044703483581543
(312) DESCRIBE `ports` 0.0018270015716553
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.0004279613494873
(314) DESCRIBE `ports` 0.0017788410186768
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00041007995605469
(316) DESCRIBE `ports` 0.0017349720001221
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00038003921508789
(318) DESCRIBE `ports` 0.0018260478973389
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00041890144348145
(320) DESCRIBE `ports` 0.0018801689147949
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00039219856262207
(322) DESCRIBE `ports` 0.0019941329956055
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0004727840423584
(324) DESCRIBE `ports` 0.0020270347595215
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00041794776916504
(326) DESCRIBE `ports` 0.0018410682678223
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00046801567077637
(328) DESCRIBE `ports` 0.0018630027770996
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00042581558227539
(330) DESCRIBE `ports` 0.0018301010131836
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00044584274291992
(332) DESCRIBE `ports` 0.0017960071563721
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00035595893859863
(334) DESCRIBE `ports` 0.0015089511871338
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.0003669261932373
(336) DESCRIBE `ports` 0.0018339157104492
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.0006561279296875
(338) DESCRIBE `ports` 0.0020730495452881
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00055909156799316
(340) DESCRIBE `ports` 0.0020918846130371
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00046086311340332
(342) DESCRIBE `ports` 0.0019881725311279
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00049400329589844
(344) DESCRIBE `ports` 0.00189208984375
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00046300888061523
(346) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66525') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0089569091796875
(347) DESCRIBE `avid_specials` 0.0023410320281982
(348) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66525 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.03634786605835
(349) DESCRIBE `cruiselines` 0.0031170845031738
(350) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00058889389038086
(351) DESCRIBE `orchid_image` 0.0023298263549805
(352) DESCRIBE `cruiselines` 0.0028457641601562
(353) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0004889965057373
(354) DESCRIBE `cruises` 0.0036380290985107
(355) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70581') 0.00054097175598145
(356) DESCRIBE `ships` 0.0040481090545654
(357) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 434))) 0.00088405609130859
(358) DESCRIBE `ships` 0.0041148662567139
(359) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '434') 0.0020160675048828
(360) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0004270076751709
(361) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034999847412109
(362) DESCRIBE `itineraries` 0.0020718574523926
(363) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70581') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0014960765838623
(364) DESCRIBE `ports` 0.0025818347930908
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.0017271041870117
(366) DESCRIBE `ports` 0.002769947052002
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00072979927062988
(368) DESCRIBE `ports` 0.0032241344451904
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.0029308795928955
(370) DESCRIBE `sailingdates` 0.015752792358398
(371) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70581') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011191368103027
(372) DESCRIBE `ports` 0.0020730495452881
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00046682357788086
(374) DESCRIBE `ports` 0.0021131038665771
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00051689147949219
(376) DESCRIBE `ports` 0.0021069049835205
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.00051116943359375
(378) DESCRIBE `ports` 0.0018980503082275
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00041913986206055
(380) DESCRIBE `ports` 0.0018332004547119
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00046181678771973
(382) DESCRIBE `ports` 0.0020239353179932
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00041818618774414
(384) DESCRIBE `ports` 0.0019571781158447
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00046396255493164
(386) DESCRIBE `ports` 0.00205397605896
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00040817260742188
(388) DESCRIBE `ports` 0.0018517971038818
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00044393539428711
(390) DESCRIBE `ports` 0.0018961429595947
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00040316581726074
(392) DESCRIBE `ports` 0.0019228458404541
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.0004580020904541
(394) DESCRIBE `ports` 0.0019171237945557
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00041389465332031
(396) DESCRIBE `ports` 0.0018398761749268
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00046586990356445
(398) DESCRIBE `ports` 0.0018250942230225
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.0003960132598877
(400) DESCRIBE `ports` 0.0018069744110107
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00011587142944336
(402) DESCRIBE `ports` 0.0019159317016602
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00043296813964844
(404) DESCRIBE `ports` 0.0018439292907715
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00047779083251953
(406) DESCRIBE `ports` 0.0019798278808594
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00063705444335938
(408) DESCRIBE `ports` 0.0016999244689941
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00060009956359863
(410) DESCRIBE `ports` 0.001986026763916
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00041103363037109
(412) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '70581') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0092239379882812
(413) DESCRIBE `avid_specials` 0.0023708343505859
(414) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70581 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.002032995223999
(415) DESCRIBE `cruiselines` 0.0026340484619141
(416) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00045204162597656
(417) DESCRIBE `orchid_image` 0.0020401477813721
(418) DESCRIBE `cruiselines` 0.0027539730072021
(419) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00044608116149902
(420) DESCRIBE `cruises` 0.0069539546966553
(421) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '54648') 0.00051093101501465
(422) DESCRIBE `ships` 0.0039560794830322
(423) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 290))) 0.00061178207397461
(424) DESCRIBE `ships` 0.0038690567016602
(425) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '290') 0.00052499771118164
(426) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034117698669434
(427) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034284591674805
(428) DESCRIBE `itineraries` 0.00199294090271
(429) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '54648') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00085711479187012
(430) DESCRIBE `ports` 0.030709028244019
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.014411926269531
(432) DESCRIBE `ports` 0.0020661354064941
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00049304962158203
(434) DESCRIBE `ports` 0.0018930435180664
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00039100646972656
(436) DESCRIBE `sailingdates` 0.0020279884338379
(437) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '54648') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011460781097412
(438) DESCRIBE `ports` 0.0021541118621826
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00049614906311035
(440) DESCRIBE `ports` 0.0017499923706055
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00034785270690918
(442) DESCRIBE `ports` 0.0020618438720703
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00039005279541016
(444) DESCRIBE `ports` 0.0018990039825439
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00044107437133789
(446) DESCRIBE `ports` 0.0019018650054932
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00050115585327148
(448) DESCRIBE `ports` 0.0019159317016602
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00046491622924805
(450) DESCRIBE `ports` 0.0073661804199219
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.018817186355591
(452) DESCRIBE `ports` 0.0019640922546387
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00049090385437012
(454) DESCRIBE `ports` 0.0025839805603027
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00048184394836426
(456) DESCRIBE `ports` 0.0018970966339111
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00026917457580566
(458) DESCRIBE `ports` 0.0023629665374756
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 292))) 0.00086712837219238
(460) DESCRIBE `ports` 0.0014359951019287
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '292') 0.0004420280456543
(462) DESCRIBE `ports` 0.001816987991333
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00044894218444824
(464) DESCRIBE `ports` 0.001971960067749
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.00044012069702148
(466) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '54648') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0097730159759521
(467) DESCRIBE `avid_specials` 0.011317014694214
(468) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 54648 and class = 'Cruise') OR (item_id = 290 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.0021388530731201
(469) DESCRIBE `cruiselines` 0.0085771083831787
(470) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0030059814453125
(471) DESCRIBE `orchid_image` 0.003835916519165
(472) DESCRIBE `cruiselines` 0.0028588771820068
(473) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0040509700775146
(474) DESCRIBE `cruises` 0.019439935684204
(475) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59347') 0.0033748149871826
(476) DESCRIBE `ships` 0.0048568248748779
(477) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 678))) 0.00064492225646973
(478) DESCRIBE `ships` 0.0038261413574219
(479) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '678') 0.00080299377441406
(480) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00039505958557129
(481) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026988983154297
(482) DESCRIBE `itineraries` 0.0016059875488281
(483) DESCRIBE `ports` 0.0016000270843506
(484) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.0018379688262939
(485) DESCRIBE `ports` 0.0024170875549316
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00036907196044922
(487) DESCRIBE `ports` 0.0024030208587646
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00048184394836426
(489) DESCRIBE `sailingdates` 0.0088019371032715
(490) DESCRIBE `ports` 0.0023770332336426
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00041794776916504
(492) DESCRIBE `ports` 0.0018429756164551
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00042414665222168
(494) DESCRIBE `ports` 0.001802921295166
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00043892860412598
(496) DESCRIBE `ports` 0.0019330978393555
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00041389465332031
(498) DESCRIBE `ports` 0.0015778541564941
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00043392181396484
(500) DESCRIBE `ports` 0.0016069412231445
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00038003921508789
(502) DESCRIBE `ports` 0.0018348693847656
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00041103363037109
(504) DESCRIBE `ports` 0.0019228458404541
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00039982795715332
(506) DESCRIBE `ports` 0.0017931461334229
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00039792060852051
(508) DESCRIBE `ports` 0.0018589496612549
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.0003669261932373
(510) DESCRIBE `ports` 0.0017449855804443
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00044512748718262
(512) DESCRIBE `ports` 0.0016019344329834
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00030612945556641
(514) DESCRIBE `ports` 0.0014009475708008
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00032591819763184
(516) DESCRIBE `ports` 0.0014598369598389
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00030303001403809
(518) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '59347') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.022281885147095
(519) DESCRIBE `avid_specials` 0.0019278526306152
(520) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59347 and class = 'Cruise') OR (item_id = 678 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.0045149326324463
(521) DESCRIBE `cruiselines` 0.0026531219482422
(522) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00043797492980957
(523) DESCRIBE `orchid_image` 0.030003070831299
(524) DESCRIBE `cruiselines` 0.0028581619262695
(525) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0005028247833252
(526) DESCRIBE `cruises` 0.0036389827728271
(527) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66503') 0.00045490264892578
(528) DESCRIBE `ships` 0.0037140846252441
(529) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 253))) 0.00065708160400391
(530) DESCRIBE `ships` 0.0038158893585205
(531) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '253') 0.00052404403686523
(532) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034618377685547
(533) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032997131347656
(534) DESCRIBE `itineraries` 0.001945972442627
(535) DESCRIBE `ports` 0.0021219253540039
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00046491622924805
(537) DESCRIBE `ports` 0.0019099712371826
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00045299530029297
(539) DESCRIBE `ports` 0.0018558502197266
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.00041484832763672
(541) DESCRIBE `sailingdates` 0.0016870498657227
(542) DESCRIBE `ports` 0.0021371841430664
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00048112869262695
(544) DESCRIBE `ports` 0.0017721652984619
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.00043702125549316
(546) DESCRIBE `ports` 0.0017859935760498
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.008695125579834
(548) DESCRIBE `ports` 0.0045530796051025
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00045895576477051
(550) DESCRIBE `ports` 0.0019161701202393
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00051307678222656
(552) DESCRIBE `ports` 0.0025389194488525
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.0020730495452881
(554) DESCRIBE `ports` 0.007033109664917
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00054097175598145
(556) DESCRIBE `ports` 0.0056569576263428
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00047206878662109
(558) DESCRIBE `ports` 0.0017809867858887
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00036096572875977
(560) DESCRIBE `ports` 0.0014481544494629
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00033783912658691
(562) DESCRIBE `ports` 0.0016829967498779
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00053191184997559
(564) DESCRIBE `ports` 0.0019550323486328
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00040507316589355
(566) DESCRIBE `ports` 0.0023689270019531
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00087809562683105
(568) DESCRIBE `ports` 0.0022549629211426
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00041294097900391
(570) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66503') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.014975070953369
(571) DESCRIBE `avid_specials` 0.0021657943725586
(572) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66503 and class = 'Cruise') OR (item_id = 253 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.0013871192932129
(573) DESCRIBE `cruiselines` 0.0030560493469238
(574) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00052499771118164
(575) DESCRIBE `orchid_image` 0.0023350715637207
(576) DESCRIBE `cruiselines` 0.0026490688323975
(577) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00044608116149902
(578) DESCRIBE `cruises` 0.0035171508789062
(579) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66516') 0.00044107437133789
(580) DESCRIBE `ships` 0.0038518905639648
(581) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 542))) 0.00059390068054199
(582) DESCRIBE `ships` 0.0093519687652588
(583) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '542') 0.00054287910461426
(584) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034713745117188
(585) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033712387084961
(586) DESCRIBE `itineraries` 0.0022048950195312
(587) DESCRIBE `ports` 0.001924991607666
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00049114227294922
(589) DESCRIBE `ports` 0.0020620822906494
(590) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00042819976806641
(591) DESCRIBE `ports` 0.0020101070404053
(592) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00036382675170898
(593) DESCRIBE `sailingdates` 0.0015850067138672
(594) DESCRIBE `ports` 0.0018620491027832
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00039482116699219
(596) DESCRIBE `ports` 0.0016999244689941
(597) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00036215782165527
(598) DESCRIBE `ports` 0.0021131038665771
(599) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00014495849609375
(600) DESCRIBE `ports` 0.0018370151519775
(601) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.0008080005645752
(602) DESCRIBE `ports` 0.0046060085296631
(603) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00063300132751465
(604) DESCRIBE `ports` 0.0019769668579102
(605) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00054812431335449
(606) DESCRIBE `ports` 0.0019140243530273
(607) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.0005490779876709
(608) DESCRIBE `ports` 0.0018298625946045
(609) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00061392784118652
(610) DESCRIBE `ports` 0.0016908645629883
(611) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00011610984802246
(612) DESCRIBE `ports` 0.001863956451416
(613) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00030183792114258
(614) DESCRIBE `ports` 0.0016419887542725
(615) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00045180320739746
(616) DESCRIBE `ports` 0.0016679763793945
(617) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00052809715270996
(618) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66516') AND (sailingdate >= '2018-06-08') AND (sailingdate <= '2019-04-16') 0.0089919567108154
(619) DESCRIBE `avid_specials` 0.005605936050415
(620) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66516 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.0061800479888916
(621) DESCRIBE `cruiselines` 0.0050349235534668
(622) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00063300132751465
(623) DESCRIBE `orchid_image` 0.0050339698791504
(624) DESCRIBE `cruiselines` 0.0026841163635254
(625) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00046277046203613
(626) DESCRIBE `ships` 0.0038721561431885
(627) SELECT `ships`.* FROM `ships` WHERE (id IN ('349', '1135', '542', '434', '1021', '406', '678', '253', '451', '348', '105', '580', '290', '1409', '98', '341', '291')) ORDER BY FIND_IN_SET(id, '349,1135,542,434,1021,406,678,253,451,348,105,580,290,1409,98,341,291') 0.0017449855804443
(628) DESCRIBE `cruisetypes` 0.0018229484558105
(629) DESCRIBE `destinations` 0.020541191101074
(630) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '35', '43', '48', '53', '8', '2', '22', '34', '38', '29', '40', '37', '11', '26', '21', '28', '25', '30', '49')) ORDER BY FIND_IN_SET(id, '12,35,43,48,53,8,2,22,34,38,29,40,37,11,26,21,28,25,30,49') 0.0024151802062988
(631) DESCRIBE `cruiselines` 0.0042729377746582
(632) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00075197219848633
(633) DESCRIBE `cruiselines` 0.0033388137817383
(634) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00057697296142578