or, enquire about your chosen options

  1. Should I buy a beverage package?
  2. SPOTLIGHT ON: Viking Ocean and River Cruises
  3. Catch Up on Cruising: Latest News in bite size!
  4. Catch Up on Cruising: Latest News in bite size!
  5. REVIEW: P & O Australia’s Pacific Aria

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

Total elapsed time: 0.61263418197632

# Query Time
(1) connect 0.00098204612731934
(2) DESCRIBE `cruises` 0.0031819343566895
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (46637, 66996, 53605, 34056, 66994, 66955, 66993, 66998, 65173, 66995)) ORDER BY FIND_IN_SET(id, '46637,66996,53605,34056,66994,66955,66993,66998,65173,66995') 0.0014758110046387
(4) DESCRIBE `cruises` 0.0029361248016357
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '46637') 0.00038790702819824
(6) DESCRIBE `ships` 0.0033819675445557
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 770))) 0.00047802925109863
(8) DESCRIBE `ships` 0.0035340785980225
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '770') 0.00049209594726562
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035715103149414
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033402442932129
(12) DESCRIBE `itineraries` 0.00166916847229
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '46637') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00084996223449707
(14) DESCRIBE `ports` 0.0018420219421387
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00042104721069336
(16) DESCRIBE `ports` 0.0016610622406006
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00048303604125977
(18) DESCRIBE `ports` 0.0017549991607666
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00037598609924316
(20) DESCRIBE `sailingdates` 0.0016379356384277
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '46637') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0012691020965576
(22) DESCRIBE `ports` 0.0017921924591064
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00035381317138672
(24) DESCRIBE `ports` 0.0016119480133057
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0003819465637207
(26) DESCRIBE `ports` 0.0015320777893066
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00030899047851562
(28) DESCRIBE `ports` 0.0012409687042236
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00027203559875488
(30) DESCRIBE `ports` 0.0013539791107178
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00029492378234863
(32) DESCRIBE `ports` 0.0012249946594238
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00026702880859375
(34) DESCRIBE `ports` 0.0013258457183838
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00031900405883789
(36) DESCRIBE `ports` 0.0012807846069336
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00031781196594238
(38) DESCRIBE `ports` 0.0012531280517578
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.0003049373626709
(40) DESCRIBE `ports` 0.0013020038604736
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00026798248291016
(42) DESCRIBE `ports` 0.001230001449585
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00030112266540527
(44) DESCRIBE `ports` 0.001291036605835
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00027990341186523
(46) DESCRIBE `ports` 0.0012550354003906
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00029397010803223
(48) DESCRIBE `ports` 0.0013401508331299
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00026607513427734
(50) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '46637') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0039951801300049
(51) DESCRIBE `avid_specials` 0.0013818740844727
(52) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 46637 and class = 'Cruise') OR (item_id = 770 AND class = 'Ship') OR (item_id = 20 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.0010571479797363
(53) DESCRIBE `cruiselines` 0.0021140575408936
(54) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00032901763916016
(55) DESCRIBE `orchid_image` 0.0014598369598389
(56) DESCRIBE `cruiselines` 0.0017671585083008
(57) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00027084350585938
(58) DESCRIBE `cruises` 0.0026521682739258
(59) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66996') 0.00028896331787109
(60) DESCRIBE `ships` 0.002457857131958
(61) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00035500526428223
(62) DESCRIBE `ships` 0.0029520988464355
(63) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00028705596923828
(64) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026512145996094
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025391578674316
(66) DESCRIBE `itineraries` 0.0012180805206299
(67) DESCRIBE `ports` 0.0012879371643066
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0003509521484375
(69) DESCRIBE `ports` 0.0012359619140625
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00033020973205566
(71) DESCRIBE `ports` 0.0013101100921631
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027608871459961
(73) DESCRIBE `sailingdates` 0.001295804977417
(74) DESCRIBE `ports` 0.0013401508331299
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00034785270690918
(76) DESCRIBE `ports` 0.0013809204101562
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0003211498260498
(78) DESCRIBE `ports` 0.0015130043029785
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00038480758666992
(80) DESCRIBE `ports` 0.0015130043029785
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00031614303588867
(82) DESCRIBE `ports` 0.0014660358428955
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00031900405883789
(84) DESCRIBE `ports` 0.0013468265533447
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00027203559875488
(86) DESCRIBE `ports` 0.0012950897216797
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00039005279541016
(88) DESCRIBE `ports` 0.0012381076812744
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00029277801513672
(90) DESCRIBE `ports` 0.0012319087982178
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.0002899169921875
(92) DESCRIBE `ports` 0.001248836517334
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.0003209114074707
(94) DESCRIBE `ports` 0.0012359619140625
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00030016899108887
(96) DESCRIBE `ports` 0.0012381076812744
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00029110908508301
(98) DESCRIBE `ports` 0.0012362003326416
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00030398368835449
(100) DESCRIBE `ports` 0.0013000965118408
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0002741813659668
(102) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66996') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0026769638061523
(103) DESCRIBE `avid_specials` 0.0013699531555176
(104) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66996 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.0010190010070801
(105) DESCRIBE `cruiselines` 0.0018470287322998
(106) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00030612945556641
(107) DESCRIBE `orchid_image` 0.0014500617980957
(108) DESCRIBE `cruiselines` 0.0017859935760498
(109) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00026607513427734
(110) DESCRIBE `cruises` 0.0023820400238037
(111) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '53605') 0.00030899047851562
(112) DESCRIBE `ships` 0.0024609565734863
(113) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 770))) 0.00030899047851562
(114) DESCRIBE `ships` 0.0025238990783691
(115) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '770') 0.00026607513427734
(116) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026583671569824
(117) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025391578674316
(118) DESCRIBE `itineraries` 0.0014259815216064
(119) DESCRIBE `ports` 0.0012640953063965
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00030398368835449
(121) DESCRIBE `ports` 0.0013599395751953
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00046300888061523
(123) DESCRIBE `ports` 0.0012738704681396
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00028014183044434
(125) DESCRIBE `sailingdates` 0.0012290477752686
(126) DESCRIBE `ports` 0.0017180442810059
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00035214424133301
(128) DESCRIBE `ports` 0.0013320446014404
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00028395652770996
(130) DESCRIBE `ports` 0.0012829303741455
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00032997131347656
(132) DESCRIBE `ports` 0.0013518333435059
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00026512145996094
(134) DESCRIBE `ports` 0.0012249946594238
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00029397010803223
(136) DESCRIBE `ports` 0.0012600421905518
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00029683113098145
(138) DESCRIBE `ports` 0.0012249946594238
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.0003058910369873
(140) DESCRIBE `ports` 0.0012309551239014
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00026988983154297
(142) DESCRIBE `ports` 0.0014350414276123
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00029897689819336
(144) DESCRIBE `ports` 0.0013449192047119
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00026702880859375
(146) DESCRIBE `ports` 0.0014810562133789
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00028514862060547
(148) DESCRIBE `ports` 0.0012640953063965
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00026607513427734
(150) DESCRIBE `ports` 0.0012359619140625
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00033903121948242
(152) DESCRIBE `ports` 0.0013198852539062
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00026583671569824
(154) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '53605') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0026710033416748
(155) DESCRIBE `avid_specials` 0.0011429786682129
(156) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 53605 and class = 'Cruise') OR (item_id = 770 AND class = 'Ship') OR (item_id = 20 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.0011308193206787
(157) DESCRIBE `cruiselines` 0.0020899772644043
(158) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00032687187194824
(159) DESCRIBE `orchid_image` 0.0015418529510498
(160) DESCRIBE `cruiselines` 0.0018210411071777
(161) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00027012825012207
(162) DESCRIBE `cruises` 0.0024549961090088
(163) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '34056') 0.00028800964355469
(164) DESCRIBE `ships` 0.0025699138641357
(165) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 448))) 0.0003969669342041
(166) DESCRIBE `ships` 0.0027861595153809
(167) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '448') 0.00033998489379883
(168) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026607513427734
(169) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026917457580566
(170) DESCRIBE `itineraries` 0.0013210773468018
(171) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '34056') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00063204765319824
(172) DESCRIBE `ports` 0.0012881755828857
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00031113624572754
(174) DESCRIBE `ports` 0.0012478828430176
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00029897689819336
(176) DESCRIBE `ports` 0.0012710094451904
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00027704238891602
(178) DESCRIBE `sailingdates` 0.001107931137085
(179) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '34056') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00062203407287598
(180) DESCRIBE `ports` 0.0013370513916016
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00039196014404297
(182) DESCRIBE `ports` 0.0014657974243164
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00028777122497559
(184) DESCRIBE `ports` 0.0012900829315186
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00029993057250977
(186) DESCRIBE `ports` 0.0016810894012451
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00051403045654297
(188) DESCRIBE `ports` 0.0015931129455566
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00033903121948242
(190) DESCRIBE `ports` 0.0013360977172852
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00028800964355469
(192) DESCRIBE `ports` 0.0012481212615967
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0003361701965332
(194) DESCRIBE `ports` 0.001349925994873
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027203559875488
(196) DESCRIBE `ports` 0.0012810230255127
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2565))) 0.00033092498779297
(198) DESCRIBE `ports` 0.0012719631195068
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2565') 0.00027203559875488
(200) DESCRIBE `ports` 0.0012829303741455
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00031590461730957
(202) DESCRIBE `ports` 0.0012969970703125
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00026893615722656
(204) DESCRIBE `ports` 0.0013358592987061
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00029802322387695
(206) DESCRIBE `ports` 0.0012750625610352
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00027203559875488
(208) DESCRIBE `ports` 0.0013160705566406
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00029802322387695
(210) DESCRIBE `ports` 0.0012650489807129
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00026988983154297
(212) DESCRIBE `ports` 0.0013930797576904
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00030994415283203
(214) DESCRIBE `ports` 0.001270055770874
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00029301643371582
(216) DESCRIBE `ports` 0.0013880729675293
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00030112266540527
(218) DESCRIBE `ports` 0.0013048648834229
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00027203559875488
(220) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '34056') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.002734899520874
(221) DESCRIBE `avid_specials` 0.0011601448059082
(222) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 34056 and class = 'Cruise') OR (item_id = 448 AND class = 'Ship') OR (item_id = 20 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.0010659694671631
(223) DESCRIBE `cruiselines` 0.0019810199737549
(224) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00032210350036621
(225) DESCRIBE `orchid_image` 0.0014369487762451
(226) DESCRIBE `cruiselines` 0.0017731189727783
(227) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00027298927307129
(228) DESCRIBE `cruises` 0.0023739337921143
(229) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66994') 0.00029277801513672
(230) DESCRIBE `ships` 0.0024731159210205
(231) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 448))) 0.00040292739868164
(232) DESCRIBE `ships` 0.0026319026947021
(233) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '448') 0.00027012825012207
(234) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026392936706543
(235) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025320053100586
(236) DESCRIBE `itineraries` 0.0012421607971191
(237) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66994') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00081706047058105
(238) DESCRIBE `ports` 0.0015289783477783
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00033712387084961
(240) DESCRIBE `ports` 0.0012600421905518
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00023198127746582
(242) DESCRIBE `ports` 0.0013399124145508
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00028896331787109
(244) DESCRIBE `sailingdates` 0.001115083694458
(245) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66994') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00062799453735352
(246) DESCRIBE `ports` 0.0018007755279541
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00045585632324219
(248) DESCRIBE `ports` 0.0012869834899902
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00028085708618164
(250) DESCRIBE `ports` 0.0011899471282959
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00032401084899902
(252) DESCRIBE `ports` 0.0013260841369629
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00054788589477539
(254) DESCRIBE `ports` 0.0014698505401611
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00031208992004395
(256) DESCRIBE `ports` 0.0013089179992676
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00027298927307129
(258) DESCRIBE `ports` 0.0012719631195068
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00037407875061035
(260) DESCRIBE `ports` 0.001554012298584
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00036787986755371
(262) DESCRIBE `ports` 0.0018241405487061
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00036001205444336
(264) DESCRIBE `ports` 0.0013148784637451
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00028300285339355
(266) DESCRIBE `ports` 0.0012879371643066
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00030899047851562
(268) DESCRIBE `ports` 0.0013308525085449
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00028800964355469
(270) DESCRIBE `ports` 0.0012638568878174
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00031590461730957
(272) DESCRIBE `ports` 0.0012960433959961
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00027608871459961
(274) DESCRIBE `ports` 0.0012600421905518
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.0003049373626709
(276) DESCRIBE `ports` 0.00136399269104
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00033807754516602
(278) DESCRIBE `ports` 0.0013179779052734
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00030207633972168
(280) DESCRIBE `ports` 0.001323938369751
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00028491020202637
(282) DESCRIBE `ports` 0.0013928413391113
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00032997131347656
(284) DESCRIBE `ports` 0.0013611316680908
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.0002751350402832
(286) DESCRIBE `ports` 0.0012860298156738
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00037312507629395
(288) DESCRIBE `ports` 0.0016090869903564
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00029420852661133
(290) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66994') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0029878616333008
(291) DESCRIBE `avid_specials` 0.0011868476867676
(292) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66994 and class = 'Cruise') OR (item_id = 448 AND class = 'Ship') OR (item_id = 20 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.00099396705627441
(293) DESCRIBE `cruiselines` 0.0021131038665771
(294) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00032591819763184
(295) DESCRIBE `orchid_image` 0.0014290809631348
(296) DESCRIBE `cruiselines` 0.001845121383667
(297) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00027108192443848
(298) DESCRIBE `cruises` 0.0027711391448975
(299) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66955') 0.00033402442932129
(300) DESCRIBE `ships` 0.0025641918182373
(301) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00037407875061035
(302) DESCRIBE `ships` 0.0027718544006348
(303) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00029706954956055
(304) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026702880859375
(305) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025510787963867
(306) DESCRIBE `itineraries` 0.0013730525970459
(307) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66955') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00047898292541504
(308) DESCRIBE `ports` 0.0013968944549561
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00032496452331543
(310) DESCRIBE `ports` 0.0013210773468018
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00032615661621094
(312) DESCRIBE `ports` 0.0012798309326172
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027608871459961
(314) DESCRIBE `sailingdates` 0.0011310577392578
(315) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66955') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00045108795166016
(316) DESCRIBE `ports` 0.001399040222168
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00030994415283203
(318) DESCRIBE `ports` 0.0014190673828125
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027990341186523
(320) DESCRIBE `ports` 0.0013539791107178
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00031614303588867
(322) DESCRIBE `ports` 0.001262903213501
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00027203559875488
(324) DESCRIBE `ports` 0.0013289451599121
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00030398368835449
(326) DESCRIBE `ports` 0.0012760162353516
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00028395652770996
(328) DESCRIBE `ports` 0.0012938976287842
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00032496452331543
(330) DESCRIBE `ports` 0.0014069080352783
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00029301643371582
(332) DESCRIBE `ports` 0.0012691020965576
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00030398368835449
(334) DESCRIBE `ports` 0.0013508796691895
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0002739429473877
(336) DESCRIBE `ports` 0.0012621879577637
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00030279159545898
(338) DESCRIBE `ports` 0.0013120174407959
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00028085708618164
(340) DESCRIBE `ports` 0.0013349056243896
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00031399726867676
(342) DESCRIBE `ports` 0.0012810230255127
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027298927307129
(344) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66955') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0026650428771973
(345) DESCRIBE `avid_specials` 0.0011329650878906
(346) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66955 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.0010600090026855
(347) DESCRIBE `cruiselines` 0.0018379688262939
(348) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00032591819763184
(349) DESCRIBE `orchid_image` 0.0014331340789795
(350) DESCRIBE `cruiselines` 0.0017731189727783
(351) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00026798248291016
(352) DESCRIBE `cruises` 0.0024130344390869
(353) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66993') 0.00034785270690918
(354) DESCRIBE `ships` 0.0026440620422363
(355) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 448))) 0.00035810470581055
(356) DESCRIBE `ships` 0.0025520324707031
(357) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '448') 0.00026798248291016
(358) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026607513427734
(359) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025510787963867
(360) DESCRIBE `itineraries` 0.0016200542449951
(361) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66993') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00045514106750488
(362) DESCRIBE `ports` 0.0013668537139893
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00032806396484375
(364) DESCRIBE `ports` 0.0012650489807129
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00036406517028809
(366) DESCRIBE `ports` 0.0012979507446289
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00034904479980469
(368) DESCRIBE `sailingdates` 0.0014078617095947
(369) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66993') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00042605400085449
(370) DESCRIBE `ports` 0.0014801025390625
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00035881996154785
(372) DESCRIBE `ports` 0.0012791156768799
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00029397010803223
(374) DESCRIBE `ports` 0.0016598701477051
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00040411949157715
(376) DESCRIBE `ports` 0.001276969909668
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00029301643371582
(378) DESCRIBE `ports` 0.0012669563293457
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00030088424682617
(380) DESCRIBE `ports` 0.0012989044189453
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00027203559875488
(382) DESCRIBE `ports` 0.0012989044189453
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00031304359436035
(384) DESCRIBE `ports` 0.0013668537139893
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00028491020202637
(386) DESCRIBE `ports` 0.0012640953063965
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00029802322387695
(388) DESCRIBE `ports` 0.0013298988342285
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00027108192443848
(390) DESCRIBE `ports` 0.001284122467041
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3963))) 0.00035285949707031
(392) DESCRIBE `ports` 0.0013551712036133
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3963') 0.00027108192443848
(394) DESCRIBE `ports` 0.0013999938964844
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00031399726867676
(396) DESCRIBE `ports` 0.0012819766998291
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00027990341186523
(398) DESCRIBE `ports` 0.0013189315795898
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00029778480529785
(400) DESCRIBE `ports` 0.0012788772583008
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00027298927307129
(402) DESCRIBE `ports` 0.0012919902801514
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00031113624572754
(404) DESCRIBE `ports` 0.0013148784637451
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00027298927307129
(406) DESCRIBE `ports` 0.001378059387207
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00030112266540527
(408) DESCRIBE `ports` 0.0012779235839844
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00030708312988281
(410) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66993') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0026590824127197
(411) DESCRIBE `avid_specials` 0.0012328624725342
(412) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66993 and class = 'Cruise') OR (item_id = 448 AND class = 'Ship') OR (item_id = 20 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.0010991096496582
(413) DESCRIBE `cruiselines` 0.0019090175628662
(414) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00032210350036621
(415) DESCRIBE `orchid_image` 0.0017180442810059
(416) DESCRIBE `cruiselines` 0.001788854598999
(417) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00027799606323242
(418) DESCRIBE `cruises` 0.002504825592041
(419) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66998') 0.00045108795166016
(420) DESCRIBE `ships` 0.002899169921875
(421) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00036096572875977
(422) DESCRIBE `ships` 0.002636194229126
(423) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00030207633972168
(424) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002899169921875
(425) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026202201843262
(426) DESCRIBE `itineraries` 0.0013959407806396
(427) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66998') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0004580020904541
(428) DESCRIBE `ports` 0.0013480186462402
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00037121772766113
(430) DESCRIBE `ports` 0.0012691020965576
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00031900405883789
(432) DESCRIBE `ports` 0.0013020038604736
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0003511905670166
(434) DESCRIBE `sailingdates` 0.0012350082397461
(435) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66998') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00047898292541504
(436) DESCRIBE `ports` 0.0013148784637451
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0003049373626709
(438) DESCRIBE `ports` 0.0013771057128906
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027608871459961
(440) DESCRIBE `ports` 0.0012729167938232
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00030708312988281
(442) DESCRIBE `ports` 0.0013251304626465
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00027704238891602
(444) DESCRIBE `ports` 0.0012719631195068
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00031685829162598
(446) DESCRIBE `ports` 0.0013289451599121
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00028491020202637
(448) DESCRIBE `ports` 0.001349925994873
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00030088424682617
(450) DESCRIBE `ports` 0.0012719631195068
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00027298927307129
(452) DESCRIBE `ports` 0.0013060569763184
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00031304359436035
(454) DESCRIBE `ports` 0.0012600421905518
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00032305717468262
(456) DESCRIBE `ports` 0.0014429092407227
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00033307075500488
(458) DESCRIBE `ports` 0.0012969970703125
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00028300285339355
(460) DESCRIBE `ports` 0.0012660026550293
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00030016899108887
(462) DESCRIBE `ports` 0.0013408660888672
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00027203559875488
(464) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66998') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0026829242706299
(465) DESCRIBE `avid_specials` 0.0014009475708008
(466) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66998 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.001255989074707
(467) DESCRIBE `cruiselines` 0.0018889904022217
(468) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00032997131347656
(469) DESCRIBE `orchid_image` 0.0014479160308838
(470) DESCRIBE `cruiselines` 0.0020620822906494
(471) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00027585029602051
(472) DESCRIBE `cruises` 0.0025858879089355
(473) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65173') 0.00045108795166016
(474) DESCRIBE `ships` 0.0026249885559082
(475) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 770))) 0.00036311149597168
(476) DESCRIBE `ships` 0.0025210380554199
(477) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '770') 0.00026702880859375
(478) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026512145996094
(479) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026893615722656
(480) DESCRIBE `itineraries` 0.0014309883117676
(481) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65173') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00063800811767578
(482) DESCRIBE `ports` 0.0018320083618164
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0003809928894043
(484) DESCRIBE `ports` 0.0014410018920898
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00031089782714844
(486) DESCRIBE `ports` 0.0012760162353516
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00029897689819336
(488) DESCRIBE `sailingdates` 0.0011870861053467
(489) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65173') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0006110668182373
(490) DESCRIBE `ports` 0.0013401508331299
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00030779838562012
(492) DESCRIBE `ports` 0.0013289451599121
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00031495094299316
(494) DESCRIBE `ports` 0.001270055770874
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00039386749267578
(496) DESCRIBE `ports` 0.001384973526001
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00027084350585938
(498) DESCRIBE `ports` 0.0012519359588623
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00031304359436035
(500) DESCRIBE `ports` 0.001309871673584
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00026416778564453
(502) DESCRIBE `ports` 0.0013909339904785
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00031304359436035
(504) DESCRIBE `ports` 0.0013329982757568
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00026893615722656
(506) DESCRIBE `ports` 0.0012741088867188
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00030708312988281
(508) DESCRIBE `ports` 0.0012989044189453
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00029182434082031
(510) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '65173') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.002769947052002
(511) DESCRIBE `avid_specials` 0.0011529922485352
(512) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65173 and class = 'Cruise') OR (item_id = 770 AND class = 'Ship') OR (item_id = 20 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.001107931137085
(513) DESCRIBE `cruiselines` 0.001945972442627
(514) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00035595893859863
(515) DESCRIBE `orchid_image` 0.0014441013336182
(516) DESCRIBE `cruiselines` 0.0017828941345215
(517) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00029516220092773
(518) DESCRIBE `cruises` 0.0024850368499756
(519) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66995') 0.00027203559875488
(520) DESCRIBE `ships` 0.0024580955505371
(521) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 448))) 0.00031685829162598
(522) DESCRIBE `ships` 0.002471923828125
(523) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '448') 0.00026297569274902
(524) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002601146697998
(525) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026297569274902
(526) DESCRIBE `itineraries` 0.0013558864593506
(527) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66995') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00047087669372559
(528) DESCRIBE `ports` 0.0013217926025391
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00029611587524414
(530) DESCRIBE `ports` 0.0013840198516846
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00036215782165527
(532) DESCRIBE `ports` 0.0012509822845459
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00026702880859375
(534) DESCRIBE `sailingdates` 0.0011119842529297
(535) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66995') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00040197372436523
(536) DESCRIBE `ports` 0.0012598037719727
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00028705596923828
(538) DESCRIBE `ports` 0.0012619495391846
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00026702880859375
(540) DESCRIBE `ports` 0.0012609958648682
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00028800964355469
(542) DESCRIBE `ports` 0.0012240409851074
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00026512145996094
(544) DESCRIBE `ports` 0.001270055770874
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00029492378234863
(546) DESCRIBE `ports` 0.0013358592987061
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00026583671569824
(548) DESCRIBE `ports` 0.0014491081237793
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00028300285339355
(550) DESCRIBE `ports` 0.0012400150299072
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00026607513427734
(552) DESCRIBE `ports` 0.001276969909668
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00029706954956055
(554) DESCRIBE `ports` 0.0014619827270508
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00026798248291016
(556) DESCRIBE `ports` 0.0012478828430176
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00031399726867676
(558) DESCRIBE `ports` 0.0015199184417725
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.000244140625
(560) DESCRIBE `ports` 0.0012640953063965
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 696))) 0.00030112266540527
(562) DESCRIBE `ports` 0.0013151168823242
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '696') 0.00026798248291016
(564) DESCRIBE `ports` 0.0012669563293457
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00028586387634277
(566) DESCRIBE `ports` 0.0015180110931396
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00026798248291016
(568) DESCRIBE `ports` 0.0013539791107178
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.0002901554107666
(570) DESCRIBE `ports` 0.001276969909668
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00034403800964355
(572) DESCRIBE `ports` 0.0013079643249512
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00031113624572754
(574) DESCRIBE `ports` 0.0012698173522949
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00026512145996094
(576) DESCRIBE `ports` 0.0012478828430176
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00028204917907715
(578) DESCRIBE `ports` 0.0015268325805664
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00026893615722656
(580) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66995') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.003244161605835
(581) DESCRIBE `avid_specials` 0.0012061595916748
(582) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66995 and class = 'Cruise') OR (item_id = 448 AND class = 'Ship') OR (item_id = 20 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.0010268688201904
(583) DESCRIBE `cruiselines` 0.0018141269683838
(584) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00036191940307617
(585) DESCRIBE `orchid_image` 0.0015780925750732
(586) DESCRIBE `cruiselines` 0.0018179416656494
(587) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00026297569274902
(588) DESCRIBE `ships` 0.0030009746551514
(589) SELECT `ships`.* FROM `ships` WHERE (id IN ('770', '93', '448')) ORDER BY FIND_IN_SET(id, '770,93,448') 0.00062394142150879
(590) DESCRIBE `cruisetypes` 0.001284122467041
(591) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruises_and_specials.destination_id = '22') AND (cruises_and_specials.cruiseline_id = '20') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.029559135437012
(592) DESCRIBE `cruiselines` 0.0023200511932373
(593) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00035500526428223
(594) DESCRIBE `destinations` 0.0017490386962891
(595) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 22))) 0.00034904479980469
(596) DESCRIBE `destinations` 0.0017468929290771
(597) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 22))) 0.00029301643371582
(598) DESCRIBE `cruiselines` 0.0021500587463379
(599) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00034213066101074