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

Total elapsed time: 0.85953497886658

# Query Time
(1) connect 0.00089097023010254
(2) DESCRIBE `cruises` 0.0045580863952637
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66973, 66996, 67702, 67811, 67965, 67997, 68285, 69076, 69842, 70394)) ORDER BY FIND_IN_SET(id, '66973,66996,67702,67811,67965,67997,68285,69076,69842,70394') 0.0017921924591064
(4) DESCRIBE `cruises` 0.004155158996582
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66973') 0.00072503089904785
(6) DESCRIBE `ships` 0.0039670467376709
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 574))) 0.00060319900512695
(8) DESCRIBE `ships` 0.0034151077270508
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '574') 0.00042510032653809
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029993057250977
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028204917907715
(12) DESCRIBE `itineraries` 0.0015318393707275
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66973') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010459423065186
(14) DESCRIBE `ports` 0.0021350383758545
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00048589706420898
(16) DESCRIBE `ports` 0.0019021034240723
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00044608116149902
(18) DESCRIBE `ports` 0.002032995223999
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00043702125549316
(20) DESCRIBE `sailingdates` 0.0017311573028564
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66973') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00092601776123047
(22) DESCRIBE `ports` 0.0021171569824219
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00055480003356934
(24) DESCRIBE `ports` 0.001878023147583
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00038290023803711
(26) DESCRIBE `ports` 0.0018038749694824
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00040793418884277
(28) DESCRIBE `ports` 0.0017631053924561
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00039911270141602
(30) DESCRIBE `ports` 0.0017750263214111
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00040292739868164
(32) DESCRIBE `ports` 0.0018250942230225
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00036001205444336
(34) DESCRIBE `ports` 0.0017778873443604
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00040292739868164
(36) DESCRIBE `ports` 0.0017588138580322
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00037598609924316
(38) DESCRIBE `ports` 0.0017709732055664
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00038886070251465
(40) DESCRIBE `ports` 0.0017869472503662
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00036501884460449
(42) DESCRIBE `ports` 0.0016570091247559
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00044894218444824
(44) DESCRIBE `ports` 0.00164794921875
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00034689903259277
(46) DESCRIBE `ports` 0.0017070770263672
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00039291381835938
(48) DESCRIBE `ports` 0.0016999244689941
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00036501884460449
(50) DESCRIBE `avid_specials` 0.0013740062713623
(51) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66973 and class = 'Cruise') OR (item_id = 574 AND class = 'Ship') OR (item_id = 20 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.0013470649719238
(52) DESCRIBE `cruiselines` 0.0027298927307129
(53) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00048708915710449
(54) DESCRIBE `orchid_image` 0.0020020008087158
(55) DESCRIBE `cruiselines` 0.0027849674224854
(56) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00062108039855957
(57) DESCRIBE `cruises` 0.0036559104919434
(58) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66996') 0.00049209594726562
(59) DESCRIBE `ships` 0.0039961338043213
(60) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00060200691223145
(61) DESCRIBE `ships` 0.0039160251617432
(62) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00056099891662598
(63) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035285949707031
(64) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032591819763184
(65) DESCRIBE `itineraries` 0.0019218921661377
(66) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66996') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00089097023010254
(67) DESCRIBE `ports` 0.0020298957824707
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00044512748718262
(69) DESCRIBE `ports` 0.0018401145935059
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00044107437133789
(71) DESCRIBE `ports` 0.001816987991333
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00040411949157715
(73) DESCRIBE `sailingdates` 0.0015311241149902
(74) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66996') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00086879730224609
(75) DESCRIBE `ports` 0.0021669864654541
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00052595138549805
(77) DESCRIBE `ports` 0.0018019676208496
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0004122257232666
(79) DESCRIBE `ports` 0.0018088817596436
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00042915344238281
(81) DESCRIBE `ports` 0.0020580291748047
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00048303604125977
(83) DESCRIBE `ports` 0.0021038055419922
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00048184394836426
(85) DESCRIBE `ports` 0.0019619464874268
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00036501884460449
(87) DESCRIBE `ports` 0.0018959045410156
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00050711631774902
(89) DESCRIBE `ports` 0.0019211769104004
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00040483474731445
(91) DESCRIBE `ports` 0.001788854598999
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00048398971557617
(93) DESCRIBE `ports` 0.0018448829650879
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00038886070251465
(95) DESCRIBE `ports` 0.0018291473388672
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.0004420280456543
(97) DESCRIBE `ports` 0.0018510818481445
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00039792060852051
(99) DESCRIBE `ports` 0.0017848014831543
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0003969669342041
(101) DESCRIBE `ports` 0.0017499923706055
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0003669261932373
(103) DESCRIBE `avid_specials` 0.0015630722045898
(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.0018179416656494
(105) DESCRIBE `cruiselines` 0.0027058124542236
(106) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00043916702270508
(107) DESCRIBE `orchid_image` 0.0020849704742432
(108) DESCRIBE `cruiselines` 0.0027639865875244
(109) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.0004429817199707
(110) DESCRIBE `cruises` 0.0035848617553711
(111) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67702') 0.00046515464782715
(112) DESCRIBE `ships` 0.0037620067596436
(113) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1455))) 0.00057196617126465
(114) DESCRIBE `ships` 0.0037178993225098
(115) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1455') 0.00057291984558105
(116) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034713745117188
(117) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033712387084961
(118) DESCRIBE `itineraries` 0.0018620491027832
(119) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67702') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00082492828369141
(120) DESCRIBE `ports` 0.0019071102142334
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00049901008605957
(122) DESCRIBE `ports` 0.0018560886383057
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00044488906860352
(124) DESCRIBE `ports` 0.001845121383667
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.0004119873046875
(126) DESCRIBE `sailingdates` 0.0016231536865234
(127) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67702') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010271072387695
(128) DESCRIBE `ports` 0.0022549629211426
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00056886672973633
(130) DESCRIBE `ports` 0.0019021034240723
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00041294097900391
(132) DESCRIBE `ports` 0.0017769336700439
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1554))) 0.00043487548828125
(134) DESCRIBE `ports` 0.0018820762634277
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1554') 0.00041007995605469
(136) DESCRIBE `ports` 0.00187087059021
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1556))) 0.00042986869812012
(138) DESCRIBE `ports` 0.0018789768218994
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1556') 0.00040292739868164
(140) DESCRIBE `ports` 0.0018401145935059
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00043892860412598
(142) DESCRIBE `ports` 0.0016648769378662
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00038409233093262
(144) DESCRIBE `ports` 0.0017869472503662
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1558))) 0.00044703483581543
(146) DESCRIBE `ports` 0.0018470287322998
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1558') 0.00040411949157715
(148) DESCRIBE `ports` 0.0019800662994385
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.0004429817199707
(150) DESCRIBE `ports` 0.0018718242645264
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00055909156799316
(152) DESCRIBE `ports` 0.0019600391387939
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5285))) 0.0004880428314209
(154) DESCRIBE `ports` 0.0017988681793213
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5285') 0.00041985511779785
(156) DESCRIBE `ports` 0.0018219947814941
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00044584274291992
(158) DESCRIBE `ports` 0.0015449523925781
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00034785270690918
(160) DESCRIBE `ports` 0.0016410350799561
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00043416023254395
(162) DESCRIBE `ports` 0.0018491744995117
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00046300888061523
(164) DESCRIBE `avid_specials` 0.0016200542449951
(165) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67702 and class = 'Cruise') OR (item_id = 1455 AND class = 'Ship') OR (item_id = 96 AND class = 'CruiseLine') OR (item_id = 50 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.0017220973968506
(166) DESCRIBE `cruiselines` 0.0026650428771973
(167) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 96))) 0.00051999092102051
(168) DESCRIBE `orchid_image` 0.0021331310272217
(169) DESCRIBE `cruiselines` 0.002730131149292
(170) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '96') 0.00047516822814941
(171) DESCRIBE `cruises` 0.0035901069641113
(172) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67811') 0.00052285194396973
(173) DESCRIBE `ships` 0.0037870407104492
(174) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 559))) 0.00073003768920898
(175) DESCRIBE `ships` 0.0038230419158936
(176) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '559') 0.00048494338989258
(177) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00033807754516602
(178) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031685829162598
(179) DESCRIBE `itineraries` 0.0018179416656494
(180) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67811') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00094795227050781
(181) DESCRIBE `ports` 0.0020110607147217
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00047898292541504
(183) DESCRIBE `ports` 0.0024471282958984
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00068497657775879
(185) DESCRIBE `ports` 0.002147912979126
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.0004119873046875
(187) DESCRIBE `sailingdates` 0.0017910003662109
(188) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67811') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00091004371643066
(189) DESCRIBE `ports` 0.0020999908447266
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00061392784118652
(191) DESCRIBE `ports` 0.001943826675415
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00037503242492676
(193) DESCRIBE `ports` 0.0019111633300781
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4087))) 0.00041413307189941
(195) DESCRIBE `ports` 0.0018389225006104
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4087') 0.00038599967956543
(197) DESCRIBE `ports` 0.0019290447235107
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2673))) 0.00046706199645996
(199) DESCRIBE `ports` 0.0020029544830322
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2673') 0.0004420280456543
(201) DESCRIBE `ports` 0.0018579959869385
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4086))) 0.00043892860412598
(203) DESCRIBE `ports` 0.001762866973877
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4086') 0.00036907196044922
(205) DESCRIBE `ports` 0.0016548633575439
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4088))) 0.00042319297790527
(207) DESCRIBE `ports` 0.0018620491027832
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4088') 0.00036191940307617
(209) DESCRIBE `ports` 0.0016798973083496
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4088))) 0.00038790702819824
(211) DESCRIBE `ports` 0.001643180847168
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4088') 0.00032496452331543
(213) DESCRIBE `ports` 0.0017139911651611
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4088))) 0.0004570484161377
(215) DESCRIBE `ports` 0.0017931461334229
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4088') 0.00035881996154785
(217) DESCRIBE `ports` 0.0016698837280273
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00045084953308105
(219) DESCRIBE `ports` 0.001849889755249
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00040006637573242
(221) DESCRIBE `ports` 0.0017409324645996
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00042104721069336
(223) DESCRIBE `ports` 0.001662015914917
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00036191940307617
(225) DESCRIBE `ports` 0.0016069412231445
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.0003209114074707
(227) DESCRIBE `ports` 0.0018129348754883
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00040602684020996
(229) DESCRIBE `avid_specials` 0.0016558170318604
(230) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67811 and class = 'Cruise') OR (item_id = 559 AND class = 'Ship') OR (item_id = 96 AND class = 'CruiseLine') OR (item_id = 50 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.0017549991607666
(231) DESCRIBE `cruiselines` 0.0025269985198975
(232) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 96))) 0.00058102607727051
(233) DESCRIBE `orchid_image` 0.0019619464874268
(234) DESCRIBE `cruiselines` 0.0025408267974854
(235) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '96') 0.00045490264892578
(236) DESCRIBE `cruises` 0.0036060810089111
(237) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67965') 0.00050592422485352
(238) DESCRIBE `ships` 0.0039310455322266
(239) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 977))) 0.00061893463134766
(240) DESCRIBE `ships` 0.0039470195770264
(241) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '977') 0.00055098533630371
(242) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033211708068848
(243) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032901763916016
(244) DESCRIBE `itineraries` 0.0016629695892334
(245) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67965') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00084304809570312
(246) DESCRIBE `ports` 0.0020890235900879
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00052285194396973
(248) DESCRIBE `ports` 0.0022280216217041
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00046586990356445
(250) DESCRIBE `ports` 0.0023479461669922
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00098299980163574
(252) DESCRIBE `sailingdates` 0.0017950534820557
(253) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67965') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00078082084655762
(254) DESCRIBE `ports` 0.0021378993988037
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00053000450134277
(256) DESCRIBE `ports` 0.0018141269683838
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00037217140197754
(258) DESCRIBE `ports` 0.0017290115356445
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00044703483581543
(260) DESCRIBE `ports` 0.0017790794372559
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00040507316589355
(262) DESCRIBE `ports` 0.0019090175628662
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00046396255493164
(264) DESCRIBE `ports` 0.0018560886383057
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00029897689819336
(266) DESCRIBE `ports` 0.001798152923584
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00047802925109863
(268) DESCRIBE `ports` 0.0018990039825439
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00045084953308105
(270) DESCRIBE `ports` 0.0018510818481445
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00053906440734863
(272) DESCRIBE `ports` 0.0019521713256836
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00046181678771973
(274) DESCRIBE `ports` 0.0019590854644775
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00055599212646484
(276) DESCRIBE `ports` 0.0020442008972168
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00043106079101562
(278) DESCRIBE `ports` 0.0023949146270752
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00048303604125977
(280) DESCRIBE `ports` 0.0019500255584717
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00043916702270508
(282) DESCRIBE `ports` 0.0020451545715332
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00049591064453125
(284) DESCRIBE `ports` 0.0019910335540771
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00041294097900391
(286) DESCRIBE `avid_specials` 0.0017120838165283
(287) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67965 and class = 'Cruise') OR (item_id = 977 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001845121383667
(288) DESCRIBE `cruiselines` 0.0028278827667236
(289) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00058913230895996
(290) DESCRIBE `orchid_image` 0.0026240348815918
(291) DESCRIBE `cruiselines` 0.0030159950256348
(292) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00045108795166016
(293) DESCRIBE `cruises` 0.0036799907684326
(294) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67997') 0.00055193901062012
(295) DESCRIBE `ships` 0.0036249160766602
(296) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 726))) 0.00055909156799316
(297) DESCRIBE `ships` 0.0037791728973389
(298) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '726') 0.00046300888061523
(299) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034880638122559
(300) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032711029052734
(301) DESCRIBE `itineraries` 0.0020759105682373
(302) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67997') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00066184997558594
(303) DESCRIBE `ports` 0.0020301342010498
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00045609474182129
(305) DESCRIBE `ports` 0.0017578601837158
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00046300888061523
(307) DESCRIBE `ports` 0.0018367767333984
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00049686431884766
(309) DESCRIBE `sailingdates` 0.0016131401062012
(310) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67997') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00090384483337402
(311) DESCRIBE `ports` 0.0024039745330811
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00049614906311035
(313) DESCRIBE `ports` 0.0023000240325928
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00049996376037598
(315) DESCRIBE `ports` 0.0021071434020996
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00044488906860352
(317) DESCRIBE `ports` 0.0019350051879883
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00039291381835938
(319) DESCRIBE `ports` 0.0017218589782715
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00046706199645996
(321) DESCRIBE `ports` 0.0018901824951172
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00039505958557129
(323) DESCRIBE `ports` 0.0017890930175781
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00041985511779785
(325) DESCRIBE `ports` 0.0018630027770996
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00038790702819824
(327) DESCRIBE `ports` 0.0018100738525391
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00040388107299805
(329) DESCRIBE `ports` 0.0017631053924561
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00035881996154785
(331) DESCRIBE `ports` 0.0018119812011719
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00047898292541504
(333) DESCRIBE `ports` 0.0018479824066162
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00040602684020996
(335) DESCRIBE `ports` 0.0017678737640381
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00042986869812012
(337) DESCRIBE `ports` 0.0022270679473877
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00043296813964844
(339) DESCRIBE `ports` 0.0018720626831055
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2264))) 0.00040006637573242
(341) DESCRIBE `ports` 0.0018491744995117
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2264') 0.00037813186645508
(343) DESCRIBE `ports` 0.0017521381378174
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00041699409484863
(345) DESCRIBE `ports` 0.0018200874328613
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00038313865661621
(347) DESCRIBE `avid_specials` 0.0015950202941895
(348) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67997 and class = 'Cruise') OR (item_id = 726 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0020089149475098
(349) DESCRIBE `cruiselines` 0.0028870105743408
(350) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00054502487182617
(351) DESCRIBE `orchid_image` 0.0021109580993652
(352) DESCRIBE `cruiselines` 0.0027141571044922
(353) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0005500316619873
(354) DESCRIBE `cruises` 0.0049519538879395
(355) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68285') 0.00054693222045898
(356) DESCRIBE `ships` 0.0039989948272705
(357) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1586))) 0.00067496299743652
(358) DESCRIBE `ships` 0.0040318965911865
(359) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1586') 0.00047612190246582
(360) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032997131347656
(361) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031399726867676
(362) DESCRIBE `itineraries` 0.0018241405487061
(363) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68285') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00094890594482422
(364) DESCRIBE `ports` 0.0028989315032959
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00075483322143555
(366) DESCRIBE `ports` 0.0021560192108154
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00041103363037109
(368) DESCRIBE `ports` 0.0021021366119385
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00050091743469238
(370) DESCRIBE `sailingdates` 0.0016748905181885
(371) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68285') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0011310577392578
(372) DESCRIBE `ports` 0.0022289752960205
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00046515464782715
(374) DESCRIBE `ports` 0.0018248558044434
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0012359619140625
(376) DESCRIBE `ports` 0.0025107860565186
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00046014785766602
(378) DESCRIBE `ports` 0.0029551982879639
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00042986869812012
(380) DESCRIBE `ports` 0.0020208358764648
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00052499771118164
(382) DESCRIBE `ports` 0.0023329257965088
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00045204162597656
(384) DESCRIBE `ports` 0.0033907890319824
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2264))) 0.00060701370239258
(386) DESCRIBE `ports` 0.0028879642486572
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2264') 0.0004270076751709
(388) DESCRIBE `ports` 0.001849889755249
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00054192543029785
(390) DESCRIBE `ports` 0.0018100738525391
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00041890144348145
(392) DESCRIBE `ports` 0.0018420219421387
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 756))) 0.00051093101501465
(394) DESCRIBE `ports` 0.0017960071563721
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '756') 0.00041484832763672
(396) DESCRIBE `ports` 0.0017881393432617
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00042891502380371
(398) DESCRIBE `ports` 0.0018279552459717
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00040316581726074
(400) DESCRIBE `avid_specials` 0.0016767978668213
(401) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68285 and class = 'Cruise') OR (item_id = 1586 AND class = 'Ship') OR (item_id = 26 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.0017139911651611
(402) DESCRIBE `cruiselines` 0.0026710033416748
(403) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00055289268493652
(404) DESCRIBE `orchid_image` 0.0038671493530273
(405) DESCRIBE `cruiselines` 0.0032730102539062
(406) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00049805641174316
(407) DESCRIBE `cruises` 0.0043880939483643
(408) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69076') 0.0017120838165283
(409) DESCRIBE `ships` 0.0039820671081543
(410) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1588))) 0.00064897537231445
(411) DESCRIBE `ships` 0.0040290355682373
(412) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1588') 0.00056791305541992
(413) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00042200088500977
(414) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00056791305541992
(415) DESCRIBE `itineraries` 0.0020551681518555
(416) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69076') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00091004371643066
(417) DESCRIBE `ports` 0.0021560192108154
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00048995018005371
(419) DESCRIBE `ports` 0.0018150806427002
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00040411949157715
(421) DESCRIBE `ports` 0.0018210411071777
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00038599967956543
(423) DESCRIBE `sailingdates` 0.001816987991333
(424) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69076') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00095605850219727
(425) DESCRIBE `ports` 0.002418041229248
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.0013000965118408
(427) DESCRIBE `ports` 0.002532958984375
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.0019209384918213
(429) DESCRIBE `ports` 0.0022928714752197
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00052189826965332
(431) DESCRIBE `ports` 0.0019819736480713
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00038409233093262
(433) DESCRIBE `ports` 0.0022389888763428
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00062704086303711
(435) DESCRIBE `ports` 0.0031580924987793
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00061297416687012
(437) DESCRIBE `ports` 0.0023989677429199
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00047397613525391
(439) DESCRIBE `ports` 0.0017879009246826
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00036787986755371
(441) DESCRIBE `ports` 0.001741886138916
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00052905082702637
(443) DESCRIBE `ports` 0.0017571449279785
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00043702125549316
(445) DESCRIBE `ports` 0.0023090839385986
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00041818618774414
(447) DESCRIBE `ports` 0.0031728744506836
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00076198577880859
(449) DESCRIBE `ports` 0.0022928714752197
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00052094459533691
(451) DESCRIBE `ports` 0.00341796875
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00094079971313477
(453) DESCRIBE `avid_specials` 0.001823902130127
(454) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69076 and class = 'Cruise') OR (item_id = 1588 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0031590461730957
(455) DESCRIBE `cruiselines` 0.0027318000793457
(456) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00044822692871094
(457) DESCRIBE `orchid_image` 0.0017220973968506
(458) DESCRIBE `cruiselines` 0.0023059844970703
(459) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00041007995605469
(460) DESCRIBE `cruises` 0.0039780139923096
(461) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69842') 0.0005490779876709
(462) DESCRIBE `ships` 0.003734827041626
(463) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1345))) 0.0010178089141846
(464) DESCRIBE `ships` 0.0036759376525879
(465) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1345') 0.00056910514831543
(466) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036716461181641
(467) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032496452331543
(468) DESCRIBE `itineraries` 0.0019629001617432
(469) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69842') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00081920623779297
(470) DESCRIBE `ports` 0.0018291473388672
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.00042414665222168
(472) DESCRIBE `ports` 0.0020241737365723
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.00042414665222168
(474) DESCRIBE `ports` 0.0020208358764648
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5604') 0.0003809928894043
(476) DESCRIBE `sailingdates` 0.0016078948974609
(477) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69842') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0013329982757568
(478) DESCRIBE `ports` 0.0022211074829102
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.00043082237243652
(480) DESCRIBE `ports` 0.0016498565673828
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5604') 0.00035500526428223
(482) DESCRIBE `ports` 0.0017540454864502
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00041794776916504
(484) DESCRIBE `ports` 0.0018830299377441
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00041294097900391
(486) DESCRIBE `ports` 0.0017940998077393
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1554))) 0.00062799453735352
(488) DESCRIBE `ports` 0.0019340515136719
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1554') 0.00044703483581543
(490) DESCRIBE `ports` 0.0018520355224609
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00056600570678711
(492) DESCRIBE `ports` 0.0018448829650879
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00043010711669922
(494) DESCRIBE `ports` 0.0017881393432617
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4236))) 0.00045514106750488
(496) DESCRIBE `ports` 0.0018491744995117
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4236') 0.00038599967956543
(498) DESCRIBE `ports` 0.0017769336700439
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1556))) 0.00063705444335938
(500) DESCRIBE `ports` 0.0018758773803711
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1556') 0.00037121772766113
(502) DESCRIBE `ports` 0.0017819404602051
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.00043296813964844
(504) DESCRIBE `ports` 0.0020029544830322
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5604') 0.00046086311340332
(506) DESCRIBE `ports` 0.0018370151519775
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5604))) 0.00042200088500977
(508) DESCRIBE `ports` 0.0018820762634277
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5604') 0.00039386749267578
(510) DESCRIBE `avid_specials` 0.0019130706787109
(511) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69842 and class = 'Cruise') OR (item_id = 1345 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 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.001802921295166
(512) DESCRIBE `cruiselines` 0.0028650760650635
(513) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00057411193847656
(514) DESCRIBE `orchid_image` 0.0020558834075928
(515) DESCRIBE `cruiselines` 0.0025119781494141
(516) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.0003969669342041
(517) DESCRIBE `cruises` 0.0035929679870605
(518) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70394') 0.00044608116149902
(519) DESCRIBE `ships` 0.0036377906799316
(520) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 775))) 0.00057005882263184
(521) DESCRIBE `ships` 0.0036230087280273
(522) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '775') 0.00042390823364258
(523) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035285949707031
(524) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036787986755371
(525) DESCRIBE `itineraries` 0.0019419193267822
(526) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70394') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00081396102905273
(527) DESCRIBE `ports` 0.0018510818481445
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00043082237243652
(529) DESCRIBE `ports` 0.0016701221466064
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00037407875061035
(531) DESCRIBE `ports` 0.0017399787902832
(532) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00038313865661621
(533) DESCRIBE `sailingdates` 0.0015809535980225
(534) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70394') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00096797943115234
(535) DESCRIBE `ports` 0.0020620822906494
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00048708915710449
(537) DESCRIBE `ports` 0.0018670558929443
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00054192543029785
(539) DESCRIBE `ports` 0.002202033996582
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 764))) 0.00047183036804199
(541) DESCRIBE `ports` 0.0017971992492676
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '764') 0.00036311149597168
(543) DESCRIBE `ports` 0.0017411708831787
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00042605400085449
(545) DESCRIBE `ports` 0.0017871856689453
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00035691261291504
(547) DESCRIBE `ports` 0.001701831817627
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00042295455932617
(549) DESCRIBE `ports` 0.0017111301422119
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00034594535827637
(551) DESCRIBE `ports` 0.0017859935760498
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.0003960132598877
(553) DESCRIBE `ports` 0.0018620491027832
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00049996376037598
(555) DESCRIBE `ports` 0.0019869804382324
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00043416023254395
(557) DESCRIBE `ports` 0.0019199848175049
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00040793418884277
(559) DESCRIBE `ports` 0.0018339157104492
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00044679641723633
(561) DESCRIBE `ports` 0.0018160343170166
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00048708915710449
(563) DESCRIBE `avid_specials` 0.0017871856689453
(564) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70394 and class = 'Cruise') OR (item_id = 775 AND class = 'Ship') OR (item_id = 12 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.0018148422241211
(565) DESCRIBE `cruiselines` 0.0028388500213623
(566) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 12))) 0.00055503845214844
(567) DESCRIBE `orchid_image` 0.0023021697998047
(568) DESCRIBE `cruiselines` 0.0028939247131348
(569) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '12') 0.0005638599395752
(570) DESCRIBE `cruiselines` 0.0030820369720459
(571) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '23', '144', '171', '31', '101', '18', '20', '8', '183', '7', '96', '120', '191', '12', '103', '221', '50', '29', '15', '268', '37', '91', '262', '28', '110', '33', '114', '141', '208', '232', '153', '187', '14', '24', '118', '49', '131', '181', '258', '206', '156', '151', '36', '204', '212', '30', '220', '256', '140', '4', '249', '238', '16', '47', '239', '174', '195', '35', '264', '113', '211', '216', '90', '146', '182', '188', '159', '213', '136', '168', '196', '237', '115', '209', '180', '73', '95', '57', '219', '248', '59', '170', '184', '225', '229', '52', '108', '231', '261', '88', '132', '276', '269', '275', '244', '82', '230', '105', '48', '119', '64', '116', '240', '38', '266', '39', '134', '210', '224', '245')) ORDER BY FIND_IN_SET(id, '218,77,19,26,23,144,171,31,101,18,20,8,183,7,96,120,191,12,103,221,50,29,15,268,37,91,262,28,110,33,114,141,208,232,153,187,14,24,118,49,131,181,258,206,156,151,36,204,212,30,220,256,140,4,249,238,16,47,239,174,195,35,264,113,211,216,90,146,182,188,159,213,136,168,196,237,115,209,180,73,95,57,219,248,59,170,184,225,229,52,108,231,261,88,132,276,269,275,244,82,230,105,48,119,64,116,240,38,266,39,134,210,224,245') 0.0075678825378418
(572) DESCRIBE `ships` 0.0040080547332764
(573) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1032', '1247', '1554', '1555', '977', '1205', '1199', '1291', '1359', '1588', '1067', '1237', '407', '258', '1599', '1594', '22', '27', '461', '726', '21', '28', '393', '1424', '817', '1135', '1422', '349', '780', '1419', '1420', '1423', '1418', '1421', '1415', '113', '462', '452', '404', '766', '24', '265', '11', '439', '711', '1245', '10', '1574', '9', '330', '542', '1215', '585', '455', '1141', '674', '207', '770', '124', '1460', '739', '797', '5', '520', '635', '974', '792', '1572', '553', '1607', '1454', '1455', '1272', '3', '116', '573', '517', '25', '1372', '1193', '340', '78', '580', '1021', '1325', '874', '1068', '1402', '390', '1284', '253', '748', '1095', '4', '43', '285', '1172', '1320', '332', '1302', '14', '66', '421', '434', '658', '765', '791', '559', '1586', '582', '1323', '1575', '327', '590', '970', '1259', '286', '855', '1139', '1260', '1571', '119', '160', '526', '678', '993', '406', '854', '883', '1064', '1678', '454', '1492', '405', '616', '1321', '722', '850', '1236', '1308', '823', '1569', '114', '441', '732', '1008', '1348', '403', '547', '1208', '84', '81', '163', '784', '338', '1088', '1319', '348', '652', '657', '871', '1108', '1326', '1327', '1330', '111', '325', '333', '451', '521', '966', '1282', '1672', '1027', '1143', '1389', '262', '731', '859', '1376', '1581', '1587', '30', '31', '34', '35', '36', '37', '38', '351', '378', '1012', '1579', '39', '82', '123', '508', '389', '610', '1151', '1471', '148', '314', '683', '1318', '1367', '1724', '93', '290', '1214', '1243', '1405', '287', '394', '483', '626', '751', '1157', '1398', '651', '1013', '1075', '162', '545', '1040', '1137', '1144', '1344', '1345', '291', '673', '1063', '1159', '1223', '1233', '1343', '98', '352', '743', '768', '852', '1145', '1168', '1303', '1413', '1604', '152', '335', '401', '669', '716', '818', '1043', '1452', '1453', '1602', '149', '968', '1025', '1090', '1136', '1283', '1301', '1552', '45', '769', '988', '1149', '1241', '1373', '1526', '150', '151', '1163', '1463', '1711', '59', '201', '223', '467', '776', '905', '1152', '1226', '1448', '324', '639', '1150', '1449', '108', '888', '1539', '1647', '1717', '74', '266', '341', '503', '601', '973', '1029', '1411', '417', '790', '1458', '1738', '796', '885', '1026', '1188', '1231', '1351', '1614', '1055', '1253', '1292', '1489', '1496', '105', '811', '882', '954', '986', '1034', '1047', '1049', '1366', '1609', '1704', '666', '704', '851', '996', '1073', '1154', '1230', '1285', '1362', '1368', '1382', '1408', '1417', '1505', '1632', '75', '494', '574', '701', '837', '985', '1176', '1409', '1470', '1516', '1540', '1682', '208', '480', '493', '738', '1037', '1474', '147', '205', '857', '1518', '1740', '618', '836', '884', '1521', '1627', '423', '1054', '1134', '1196', '1407', '204', '422', '643', '1051', '1410', '448', '672', '1042', '1224', '1437', '1486', '1593', '1615', '671', '709', '795', '1138', '1148', '1229', '1517', '1522', '1716', '485', '717', '781', '972', '994', '1262', '1352', '1384', '1628', '938', '1017', '1383', '1501', '1514', '1619', '1684', '479', '665', '749', '995', '1645', '1713', '1715', '499', '821', '1045', '1175', '1254', '1412', '1461', '1481', '1601', '1673', '1714', '17', '937', '1011', '1106', '1240', '420', '1028', '1439', '1515', '1606', '313', '453', '1053', '1206', '1266', '1360', '1361', '1459', '212', '744', '1052', '1256', '1293', '1676', '487', '1611', '1639', '1708', '70', '419', '775', '808', '969', '1035', '1048', '1071', '1089', '1110', '1189', '1232', '1274', '1631', '1722', '1723', '375', '798', '1338', '1697', '1729', '715', '1060', '1192', '1339', '1342', '1355', '1385', '1612', '958', '1036', '1158', '1491', '1679', '69', '225', '288', '886')) ORDER BY FIND_IN_SET(id, '1127,1032,1247,1554,1555,977,1205,1199,1291,1359,1588,1067,1237,407,258,1599,1594,22,27,461,726,21,28,393,1424,817,1135,1422,349,780,1419,1420,1423,1418,1421,1415,113,462,452,404,766,24,265,11,439,711,1245,10,1574,9,330,542,1215,585,455,1141,674,207,770,124,1460,739,797,5,520,635,974,792,1572,553,1607,1454,1455,1272,3,116,573,517,25,1372,1193,340,78,580,1021,1325,874,1068,1402,390,1284,253,748,1095,4,43,285,1172,1320,332,1302,14,66,421,434,658,765,791,559,1586,582,1323,1575,327,590,970,1259,286,855,1139,1260,1571,119,160,526,678,993,406,854,883,1064,1678,454,1492,405,616,1321,722,850,1236,1308,823,1569,114,441,732,1008,1348,403,547,1208,84,81,163,784,338,1088,1319,348,652,657,871,1108,1326,1327,1330,111,325,333,451,521,966,1282,1672,1027,1143,1389,262,731,859,1376,1581,1587,30,31,34,35,36,37,38,351,378,1012,1579,39,82,123,508,389,610,1151,1471,148,314,683,1318,1367,1724,93,290,1214,1243,1405,287,394,483,626,751,1157,1398,651,1013,1075,162,545,1040,1137,1144,1344,1345,291,673,1063,1159,1223,1233,1343,98,352,743,768,852,1145,1168,1303,1413,1604,152,335,401,669,716,818,1043,1452,1453,1602,149,968,1025,1090,1136,1283,1301,1552,45,769,988,1149,1241,1373,1526,150,151,1163,1463,1711,59,201,223,467,776,905,1152,1226,1448,324,639,1150,1449,108,888,1539,1647,1717,74,266,341,503,601,973,1029,1411,417,790,1458,1738,796,885,1026,1188,1231,1351,1614,1055,1253,1292,1489,1496,105,811,882,954,986,1034,1047,1049,1366,1609,1704,666,704,851,996,1073,1154,1230,1285,1362,1368,1382,1408,1417,1505,1632,75,494,574,701,837,985,1176,1409,1470,1516,1540,1682,208,480,493,738,1037,1474,147,205,857,1518,1740,618,836,884,1521,1627,423,1054,1134,1196,1407,204,422,643,1051,1410,448,672,1042,1224,1437,1486,1593,1615,671,709,795,1138,1148,1229,1517,1522,1716,485,717,781,972,994,1262,1352,1384,1628,938,1017,1383,1501,1514,1619,1684,479,665,749,995,1645,1713,1715,499,821,1045,1175,1254,1412,1461,1481,1601,1673,1714,17,937,1011,1106,1240,420,1028,1439,1515,1606,313,453,1053,1206,1266,1360,1361,1459,212,744,1052,1256,1293,1676,487,1611,1639,1708,70,419,775,808,969,1035,1048,1071,1089,1110,1189,1232,1274,1631,1722,1723,375,798,1338,1697,1729,715,1060,1192,1339,1342,1355,1385,1612,958,1036,1158,1491,1679,69,225,288,886') 0.057695150375366
(574) DESCRIBE `cruisetypes` 0.0017120838165283
(575) DESCRIBE `destinations` 0.0023870468139648
(576) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '37', '9', '2', '43', '25', '8', '53', '55', '39', '28', '26', '40', '38', '11', '30', '21', '48', '7', '44', '49', '29', '45', '56', '34', '10', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,37,9,2,43,25,8,53,55,39,28,26,40,38,11,30,21,48,7,44,49,29,45,56,34,10,52,46,32') 0.0028669834136963