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

Total elapsed time: 0.67101168632507

# Query Time
(1) connect 0.0014729499816895
(2) DESCRIBE `cruises` 0.0041589736938477
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (69896, 69878, 69863, 69879, 69892, 69864, 69881, 69893, 69861, 69882)) ORDER BY FIND_IN_SET(id, '69896,69878,69863,69879,69892,69864,69881,69893,69861,69882') 0.0017120838165283
(4) DESCRIBE `cruises` 0.0028140544891357
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69896') 0.00033903121948242
(6) DESCRIBE `ships` 0.0025551319122314
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00035905838012695
(8) DESCRIBE `ships` 0.0032181739807129
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.00037503242492676
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032997131347656
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031089782714844
(12) DESCRIBE `itineraries` 0.0017380714416504
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69896') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00090789794921875
(14) DESCRIBE `ports` 0.0018529891967773
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00046610832214355
(16) DESCRIBE `ports` 0.0016388893127441
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036287307739258
(18) DESCRIBE `ports` 0.0017330646514893
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00033998489379883
(20) DESCRIBE `sailingdates` 0.0016298294067383
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69896') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00076198577880859
(22) DESCRIBE `ports` 0.001845121383667
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039911270141602
(24) DESCRIBE `ports` 0.0018270015716553
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040912628173828
(26) DESCRIBE `ports` 0.0018510818481445
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00044512748718262
(28) DESCRIBE `ports` 0.0018219947814941
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00036501884460449
(30) DESCRIBE `ports` 0.0018129348754883
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00042605400085449
(32) DESCRIBE `ports` 0.0017991065979004
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00037288665771484
(34) DESCRIBE `ports` 0.0018579959869385
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00040507316589355
(36) DESCRIBE `ports` 0.0017528533935547
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00038504600524902
(38) DESCRIBE `ports` 0.0018181800842285
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00045180320739746
(40) DESCRIBE `ports` 0.0018301010131836
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00038003921508789
(42) DESCRIBE `ports` 0.0017271041870117
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00039100646972656
(44) DESCRIBE `ports` 0.0017240047454834
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00036311149597168
(46) DESCRIBE `ports` 0.0017380714416504
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00039291381835938
(48) DESCRIBE `ports` 0.0017459392547607
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00045895576477051
(50) DESCRIBE `ports` 0.0016779899597168
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00040793418884277
(52) DESCRIBE `ports` 0.0016911029815674
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00035810470581055
(54) DESCRIBE `ports` 0.0018041133880615
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00040698051452637
(56) DESCRIBE `ports` 0.0017859935760498
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00037789344787598
(58) DESCRIBE `ports` 0.0017101764678955
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00039911270141602
(60) DESCRIBE `ports` 0.0016448497772217
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0004880428314209
(62) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69896') AND (sailingdate >= '2019-01-01') 0.0069000720977783
(63) DESCRIBE `avid_specials` 0.0018370151519775
(64) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69896 and class = 'Cruise') OR (item_id = 287 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 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.0020549297332764
(65) DESCRIBE `cruiselines` 0.002479076385498
(66) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00033187866210938
(67) DESCRIBE `orchid_image` 0.0019009113311768
(68) DESCRIBE `cruiselines` 0.0023939609527588
(69) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00042104721069336
(70) DESCRIBE `cruises` 0.0033559799194336
(71) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69878') 0.00098991394042969
(72) DESCRIBE `ships` 0.0047340393066406
(73) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00043916702270508
(74) DESCRIBE `ships` 0.0034928321838379
(75) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00043892860412598
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036501884460449
(77) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003359317779541
(78) DESCRIBE `itineraries` 0.0018529891967773
(79) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69878') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00073599815368652
(80) DESCRIBE `ports` 0.0020971298217773
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004270076751709
(82) DESCRIBE `ports` 0.0017099380493164
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004119873046875
(84) DESCRIBE `ports` 0.0018420219421387
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00043797492980957
(86) DESCRIBE `sailingdates` 0.0013778209686279
(87) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69878') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00060296058654785
(88) DESCRIBE `ports` 0.0014829635620117
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035881996154785
(90) DESCRIBE `ports` 0.0018601417541504
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00041079521179199
(92) DESCRIBE `ports` 0.0019481182098389
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00041294097900391
(94) DESCRIBE `ports` 0.0018370151519775
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00029611587524414
(96) DESCRIBE `ports` 0.0015139579772949
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.0002598762512207
(98) DESCRIBE `ports` 0.0014278888702393
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.0001828670501709
(100) DESCRIBE `ports` 0.0016169548034668
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00045490264892578
(102) DESCRIBE `ports` 0.0014410018920898
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00030803680419922
(104) DESCRIBE `ports` 0.0014190673828125
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00034308433532715
(106) DESCRIBE `ports` 0.0015151500701904
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00027894973754883
(108) DESCRIBE `ports` 0.0014190673828125
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00032806396484375
(110) DESCRIBE `ports` 0.0016059875488281
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00032305717468262
(112) DESCRIBE `ports` 0.0014340877532959
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00037384033203125
(114) DESCRIBE `ports` 0.0014278888702393
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00029993057250977
(116) DESCRIBE `ports` 0.001446008682251
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00032711029052734
(118) DESCRIBE `ports` 0.0014219284057617
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00031709671020508
(120) DESCRIBE `ports` 0.0014278888702393
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043988227844238
(122) DESCRIBE `ports` 0.0014688968658447
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034999847412109
(124) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69878') AND (sailingdate >= '2019-01-01') 0.0036368370056152
(125) DESCRIBE `avid_specials` 0.0017390251159668
(126) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69878 and class = 'Cruise') OR (item_id = 1330 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 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.0012879371643066
(127) DESCRIBE `cruiselines` 0.0021469593048096
(128) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00034499168395996
(129) DESCRIBE `orchid_image` 0.0018630027770996
(130) DESCRIBE `cruiselines` 0.0023579597473145
(131) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00038003921508789
(132) DESCRIBE `cruises` 0.0030269622802734
(133) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69863') 0.00037789344787598
(134) DESCRIBE `ships` 0.0079059600830078
(135) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 262))) 0.0005500316619873
(136) DESCRIBE `ships` 0.0032291412353516
(137) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '262') 0.00037407875061035
(138) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027012825012207
(139) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003199577331543
(140) DESCRIBE `itineraries` 0.0018301010131836
(141) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69863') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00056910514831543
(142) DESCRIBE `ports` 0.0015320777893066
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040602684020996
(144) DESCRIBE `ports` 0.0015091896057129
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036311149597168
(146) DESCRIBE `ports` 0.0014400482177734
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029993057250977
(148) DESCRIBE `sailingdates` 0.0012819766998291
(149) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69863') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00044798851013184
(150) DESCRIBE `ports` 0.0016441345214844
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031304359436035
(152) DESCRIBE `ports` 0.0015730857849121
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029683113098145
(154) DESCRIBE `ports` 0.0015008449554443
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00031304359436035
(156) DESCRIBE `ports` 0.0016651153564453
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00038599967956543
(158) DESCRIBE `ports` 0.001971960067749
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00040698051452637
(160) DESCRIBE `ports` 0.0013899803161621
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00031685829162598
(162) DESCRIBE `ports` 0.0014021396636963
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.0003209114074707
(164) DESCRIBE `ports` 0.0013370513916016
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00027990341186523
(166) DESCRIBE `ports` 0.0015060901641846
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00033712387084961
(168) DESCRIBE `ports` 0.0015370845794678
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00028395652770996
(170) DESCRIBE `ports` 0.001349925994873
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032496452331543
(172) DESCRIBE `ports` 0.0013010501861572
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028800964355469
(174) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69863') AND (sailingdate >= '2019-01-01') 0.0026969909667969
(175) DESCRIBE `avid_specials` 0.0012729167938232
(176) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69863 and class = 'Cruise') OR (item_id = 262 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 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.0011110305786133
(177) DESCRIBE `cruiselines` 0.001910924911499
(178) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00039196014404297
(179) DESCRIBE `orchid_image` 0.0015881061553955
(180) DESCRIBE `cruiselines` 0.0020191669464111
(181) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00031208992004395
(182) DESCRIBE `cruises` 0.0025289058685303
(183) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69879') 0.00031685829162598
(184) DESCRIBE `ships` 0.0052990913391113
(185) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00057196617126465
(186) DESCRIBE `ships` 0.0028550624847412
(187) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00038504600524902
(188) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003201961517334
(189) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033092498779297
(190) DESCRIBE `itineraries` 0.0022099018096924
(191) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69879') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00053787231445312
(192) DESCRIBE `ports` 0.0018088817596436
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044989585876465
(194) DESCRIBE `ports` 0.0016961097717285
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037598609924316
(196) DESCRIBE `ports` 0.0018501281738281
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00040078163146973
(198) DESCRIBE `sailingdates` 0.0015559196472168
(199) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69879') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00057697296142578
(200) DESCRIBE `ports` 0.0018858909606934
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042080879211426
(202) DESCRIBE `ports` 0.0017070770263672
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00037407875061035
(204) DESCRIBE `ports` 0.0015709400177002
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00032186508178711
(206) DESCRIBE `ports` 0.0013899803161621
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00028610229492188
(208) DESCRIBE `ports` 0.0013442039489746
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00034594535827637
(210) DESCRIBE `ports` 0.001270055770874
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00028681755065918
(212) DESCRIBE `ports` 0.0015890598297119
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00037407875061035
(214) DESCRIBE `ports` 0.0017321109771729
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00040102005004883
(216) DESCRIBE `ports` 0.0015029907226562
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035500526428223
(218) DESCRIBE `ports` 0.0015389919281006
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034308433532715
(220) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69879') AND (sailingdate >= '2019-01-01') 0.0027241706848145
(221) DESCRIBE `avid_specials` 0.0012879371643066
(222) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69879 and class = 'Cruise') OR (item_id = 1330 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 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.0016210079193115
(223) DESCRIBE `cruiselines` 0.0019521713256836
(224) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00036716461181641
(225) DESCRIBE `orchid_image` 0.0015630722045898
(226) DESCRIBE `cruiselines` 0.0019299983978271
(227) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00030517578125
(228) DESCRIBE `cruises` 0.0024590492248535
(229) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69892') 0.00031423568725586
(230) DESCRIBE `ships` 0.0025870800018311
(231) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00046610832214355
(232) DESCRIBE `ships` 0.0027329921722412
(233) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.00032520294189453
(234) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033187866210938
(235) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034308433532715
(236) DESCRIBE `itineraries` 0.0013461112976074
(237) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69892') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00060415267944336
(238) DESCRIBE `ports` 0.0014071464538574
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003361701965332
(240) DESCRIBE `ports` 0.0016410350799561
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003211498260498
(242) DESCRIBE `ports` 0.0013270378112793
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028610229492188
(244) DESCRIBE `sailingdates` 0.0013108253479004
(245) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69892') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00060796737670898
(246) DESCRIBE `ports` 0.0014278888702393
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00043106079101562
(248) DESCRIBE `ports` 0.0016140937805176
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038599967956543
(250) DESCRIBE `ports` 0.0016980171203613
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00032901763916016
(252) DESCRIBE `ports` 0.0016078948974609
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00029087066650391
(254) DESCRIBE `ports` 0.0012750625610352
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00030112266540527
(256) DESCRIBE `ports` 0.0014009475708008
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00027799606323242
(258) DESCRIBE `ports` 0.0013129711151123
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00031399726867676
(260) DESCRIBE `ports` 0.0014262199401855
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00029206275939941
(262) DESCRIBE `ports` 0.0012600421905518
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00030708312988281
(264) DESCRIBE `ports` 0.0012481212615967
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00028610229492188
(266) DESCRIBE `ports` 0.0013461112976074
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00030398368835449
(268) DESCRIBE `ports` 0.0012810230255127
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00035285949707031
(270) DESCRIBE `ports` 0.0012729167938232
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00029993057250977
(272) DESCRIBE `ports` 0.0013642311096191
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00028204917907715
(274) DESCRIBE `ports` 0.0013399124145508
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00028800964355469
(276) DESCRIBE `ports` 0.0012588500976562
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00028300285339355
(278) DESCRIBE `ports` 0.0012409687042236
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00029802322387695
(280) DESCRIBE `ports` 0.0012490749359131
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00027012825012207
(282) DESCRIBE `ports` 0.0012569427490234
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0002899169921875
(284) DESCRIBE `ports` 0.0012919902801514
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00027179718017578
(286) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69892') AND (sailingdate >= '2019-01-01') 0.0032930374145508
(287) DESCRIBE `avid_specials` 0.0012438297271729
(288) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69892 and class = 'Cruise') OR (item_id = 287 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 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.0010550022125244
(289) DESCRIBE `cruiselines` 0.001957893371582
(290) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00037097930908203
(291) DESCRIBE `orchid_image` 0.0018868446350098
(292) DESCRIBE `cruiselines` 0.0022327899932861
(293) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00030279159545898
(294) DESCRIBE `cruises` 0.0025148391723633
(295) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69864') 0.00029087066650391
(296) DESCRIBE `ships` 0.0025179386138916
(297) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 262))) 0.00037097930908203
(298) DESCRIBE `ships` 0.0028541088104248
(299) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '262') 0.00033211708068848
(300) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037407875061035
(301) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028610229492188
(302) DESCRIBE `itineraries` 0.0012590885162354
(303) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69864') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00043821334838867
(304) DESCRIBE `ports` 0.0013120174407959
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033307075500488
(306) DESCRIBE `ports` 0.0013408660888672
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036215782165527
(308) DESCRIBE `ports` 0.0012609958648682
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027894973754883
(310) DESCRIBE `sailingdates` 0.0011310577392578
(311) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69864') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00043582916259766
(312) DESCRIBE `ports` 0.0012969970703125
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003209114074707
(314) DESCRIBE `ports` 0.0014669895172119
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00045990943908691
(316) DESCRIBE `ports` 0.0013320446014404
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00037002563476562
(318) DESCRIBE `ports` 0.001291036605835
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.0002741813659668
(320) DESCRIBE `ports` 0.0012621879577637
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00029802322387695
(322) DESCRIBE `ports` 0.0013649463653564
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.0002739429473877
(324) DESCRIBE `ports` 0.0012509822845459
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00029993057250977
(326) DESCRIBE `ports` 0.0012998580932617
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00028109550476074
(328) DESCRIBE `ports` 0.0014140605926514
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0003209114074707
(330) DESCRIBE `ports` 0.0012948513031006
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0002751350402832
(332) DESCRIBE `ports` 0.0013070106506348
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003359317779541
(334) DESCRIBE `ports` 0.0012929439544678
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028800964355469
(336) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69864') AND (sailingdate >= '2019-01-01') 0.0027720928192139
(337) DESCRIBE `avid_specials` 0.0015859603881836
(338) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69864 and class = 'Cruise') OR (item_id = 262 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 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.0013611316680908
(339) DESCRIBE `cruiselines` 0.0019600391387939
(340) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00034904479980469
(341) DESCRIBE `orchid_image` 0.0014431476593018
(342) DESCRIBE `cruiselines` 0.0018420219421387
(343) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00035405158996582
(344) DESCRIBE `cruises` 0.002856969833374
(345) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69881') 0.00037217140197754
(346) DESCRIBE `ships` 0.0030570030212402
(347) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00045514106750488
(348) DESCRIBE `ships` 0.0030679702758789
(349) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00037384033203125
(350) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033283233642578
(351) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034189224243164
(352) DESCRIBE `itineraries` 0.0018010139465332
(353) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69881') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00061583518981934
(354) DESCRIBE `ports` 0.0015828609466553
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027298927307129
(356) DESCRIBE `ports` 0.0013840198516846
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031208992004395
(358) DESCRIBE `ports` 0.001276969909668
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029802322387695
(360) DESCRIBE `sailingdates` 0.0011959075927734
(361) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69881') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00047206878662109
(362) DESCRIBE `ports` 0.0017938613891602
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041103363037109
(364) DESCRIBE `ports` 0.001284122467041
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025296211242676
(366) DESCRIBE `ports` 0.0012471675872803
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00034093856811523
(368) DESCRIBE `ports` 0.0012068748474121
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00032496452331543
(370) DESCRIBE `ports` 0.0013611316680908
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.0003659725189209
(372) DESCRIBE `ports` 0.001305103302002
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00026893615722656
(374) DESCRIBE `ports` 0.0012919902801514
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00033807754516602
(376) DESCRIBE `ports` 0.0013539791107178
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00026392936706543
(378) DESCRIBE `ports` 0.0013699531555176
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00039887428283691
(380) DESCRIBE `ports` 0.001323938369751
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00026583671569824
(382) DESCRIBE `ports` 0.0012359619140625
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00029110908508301
(384) DESCRIBE `ports` 0.0012309551239014
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00026512145996094
(386) DESCRIBE `ports` 0.001288890838623
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00033092498779297
(388) DESCRIBE `ports` 0.0012309551239014
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00026607513427734
(390) DESCRIBE `ports` 0.001288890838623
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00032901763916016
(392) DESCRIBE `ports` 0.0014572143554688
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00026679039001465
(394) DESCRIBE `ports` 0.0013320446014404
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.0003199577331543
(396) DESCRIBE `ports` 0.0012421607971191
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00030207633972168
(398) DESCRIBE `ports` 0.0012481212615967
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031399726867676
(400) DESCRIBE `ports` 0.0012578964233398
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026488304138184
(402) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69881') AND (sailingdate >= '2019-01-01') 0.0027999877929688
(403) DESCRIBE `avid_specials` 0.0011980533599854
(404) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69881 and class = 'Cruise') OR (item_id = 1330 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 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.0011000633239746
(405) DESCRIBE `cruiselines` 0.0020349025726318
(406) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00031590461730957
(407) DESCRIBE `orchid_image` 0.0015039443969727
(408) DESCRIBE `cruiselines` 0.0017640590667725
(409) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00030708312988281
(410) DESCRIBE `cruises` 0.0024819374084473
(411) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69893') 0.00029301643371582
(412) DESCRIBE `ships` 0.0024399757385254
(413) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00033807754516602
(414) DESCRIBE `ships` 0.0027050971984863
(415) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.0002739429473877
(416) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026082992553711
(417) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024890899658203
(418) DESCRIBE `itineraries` 0.0012290477752686
(419) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69893') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00048184394836426
(420) DESCRIBE `ports` 0.0012760162353516
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00041007995605469
(422) DESCRIBE `ports` 0.0013470649719238
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00028705596923828
(424) DESCRIBE `ports` 0.0012960433959961
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00027298927307129
(426) DESCRIBE `sailingdates` 0.0014059543609619
(427) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69893') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00050592422485352
(428) DESCRIBE `ports` 0.0014338493347168
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00032186508178711
(430) DESCRIBE `ports` 0.0012729167938232
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00027203559875488
(432) DESCRIBE `ports` 0.0014159679412842
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00038504600524902
(434) DESCRIBE `ports` 0.0012500286102295
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00027608871459961
(436) DESCRIBE `ports` 0.0013179779052734
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00029492378234863
(438) DESCRIBE `ports` 0.0012469291687012
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00027203559875488
(440) DESCRIBE `ports` 0.0012838840484619
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00029301643371582
(442) DESCRIBE `ports` 0.0012640953063965
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00025510787963867
(444) DESCRIBE `ports` 0.0013010501861572
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00029301643371582
(446) DESCRIBE `ports` 0.0013279914855957
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00026583671569824
(448) DESCRIBE `ports` 0.0012750625610352
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00030684471130371
(450) DESCRIBE `ports` 0.0012469291687012
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00026583671569824
(452) DESCRIBE `ports` 0.0012800693511963
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00029492378234863
(454) DESCRIBE `ports` 0.0013101100921631
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00026607513427734
(456) DESCRIBE `ports` 0.0014829635620117
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00031900405883789
(458) DESCRIBE `ports` 0.0013110637664795
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00026917457580566
(460) DESCRIBE `ports` 0.0013470649719238
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00039100646972656
(462) DESCRIBE `ports` 0.0016660690307617
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00035810470581055
(464) DESCRIBE `ports` 0.001845121383667
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00032711029052734
(466) DESCRIBE `ports` 0.0013060569763184
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.0003058910369873
(468) DESCRIBE `ports` 0.0013360977172852
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038695335388184
(470) DESCRIBE `ports` 0.0014171600341797
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026893615722656
(472) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69893') AND (sailingdate >= '2019-01-01') 0.002971887588501
(473) DESCRIBE `avid_specials` 0.0012600421905518
(474) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69893 and class = 'Cruise') OR (item_id = 287 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 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.0010261535644531
(475) DESCRIBE `cruiselines` 0.0018951892852783
(476) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00031900405883789
(477) DESCRIBE `orchid_image` 0.0014731884002686
(478) DESCRIBE `cruiselines` 0.0019102096557617
(479) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00032305717468262
(480) DESCRIBE `cruises` 0.003493070602417
(481) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69861') 0.0008549690246582
(482) DESCRIBE `ships` 0.0035810470581055
(483) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 262))) 0.00050497055053711
(484) DESCRIBE `ships` 0.0036559104919434
(485) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '262') 0.00040006637573242
(486) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034713745117188
(487) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033402442932129
(488) DESCRIBE `itineraries` 0.0017659664154053
(489) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69861') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00053501129150391
(490) DESCRIBE `ports` 0.0018570423126221
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040912628173828
(492) DESCRIBE `ports` 0.0019237995147705
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044083595275879
(494) DESCRIBE `ports` 0.0018401145935059
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00048708915710449
(496) DESCRIBE `sailingdates` 0.001323938369751
(497) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69861') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00048995018005371
(498) DESCRIBE `ports` 0.0020899772644043
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0004429817199707
(500) DESCRIBE `ports` 0.0015590190887451
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002751350402832
(502) DESCRIBE `ports` 0.0013689994812012
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00029397010803223
(504) DESCRIBE `ports` 0.0013749599456787
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00027298927307129
(506) DESCRIBE `ports` 0.0012791156768799
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.0004889965057373
(508) DESCRIBE `ports` 0.0014190673828125
(509) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00027298927307129
(510) DESCRIBE `ports` 0.0012691020965576
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00028586387634277
(512) DESCRIBE `ports` 0.0013041496276855
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00028681755065918
(514) DESCRIBE `ports` 0.001284122467041
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029397010803223
(516) DESCRIBE `ports` 0.0012729167938232
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00033807754516602
(518) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69861') AND (sailingdate >= '2019-01-01') 0.0026569366455078
(519) DESCRIBE `avid_specials` 0.001176118850708
(520) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69861 and class = 'Cruise') OR (item_id = 262 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 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.0010020732879639
(521) DESCRIBE `cruiselines` 0.0018560886383057
(522) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00036001205444336
(523) DESCRIBE `orchid_image` 0.0014090538024902
(524) DESCRIBE `cruiselines` 0.0016589164733887
(525) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00026178359985352
(526) DESCRIBE `cruises` 0.0024330615997314
(527) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69882') 0.00028610229492188
(528) DESCRIBE `ships` 0.0024127960205078
(529) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00064420700073242
(530) DESCRIBE `ships` 0.0028419494628906
(531) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00032210350036621
(532) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027084350585938
(533) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033020973205566
(534) DESCRIBE `itineraries` 0.0013270378112793
(535) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69882') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00043392181396484
(536) DESCRIBE `ports` 0.0013420581817627
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003199577331543
(538) DESCRIBE `ports` 0.0012831687927246
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028514862060547
(540) DESCRIBE `ports` 0.0013091564178467
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030088424682617
(542) DESCRIBE `sailingdates` 0.0012619495391846
(543) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69882') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00045680999755859
(544) DESCRIBE `ports` 0.0014698505401611
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030207633972168
(546) DESCRIBE `ports` 0.0012707710266113
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00035810470581055
(548) DESCRIBE `ports` 0.0016610622406006
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00039100646972656
(550) DESCRIBE `ports` 0.0016720294952393
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00034713745117188
(552) DESCRIBE `ports` 0.0016529560089111
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00031208992004395
(554) DESCRIBE `ports` 0.0013840198516846
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00039505958557129
(556) DESCRIBE `ports` 0.0019111633300781
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.0003669261932373
(558) DESCRIBE `ports` 0.0014321804046631
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00033998489379883
(560) DESCRIBE `ports` 0.0014920234680176
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00032711029052734
(562) DESCRIBE `ports` 0.001392126083374
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00030994415283203
(564) DESCRIBE `ports` 0.0014481544494629
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00033903121948242
(566) DESCRIBE `ports` 0.001460075378418
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00031709671020508
(568) DESCRIBE `ports` 0.0014960765838623
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003969669342041
(570) DESCRIBE `ports` 0.0012609958648682
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026798248291016
(572) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69882') AND (sailingdate >= '2019-01-01') 0.0027320384979248
(573) DESCRIBE `avid_specials` 0.0012648105621338
(574) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69882 and class = 'Cruise') OR (item_id = 1330 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 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.0010740756988525
(575) DESCRIBE `cruiselines` 0.0018320083618164
(576) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.0003209114074707
(577) DESCRIBE `orchid_image` 0.0014209747314453
(578) DESCRIBE `cruiselines` 0.0018031597137451
(579) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00027298927307129
(580) DESCRIBE `ships` 0.0028731822967529
(581) SELECT `ships`.* FROM `ships` WHERE (id IN ('1330', '287', '124', '262')) ORDER BY FIND_IN_SET(id, '1330,287,124,262') 0.00070714950561523
(582) DESCRIBE `cruisetypes` 0.0010659694671631
(583) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruises_and_specials.destination_id = '43') AND (cruises_and_specials.cruiseline_id = '26') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.030047178268433
(584) DESCRIBE `cruiselines` 0.0025031566619873
(585) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00042200088500977
(586) DESCRIBE `destinations` 0.0017478466033936
(587) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 43))) 0.00032401084899902
(588) DESCRIBE `destinations` 0.0017950534820557
(589) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 43))) 0.00037097930908203
(590) DESCRIBE `cruiselines` 0.0018379688262939
(591) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00035190582275391