or, enquire about your chosen options

  1. REVIEW: P & O Australia’s Pacific Aria
  2. Catch Up on Cruising: Latest News in bite size!
  3. Asian Adventures with Zuleika from the Cruise Factor Team
  4. A short cruise is a good cruise!!
  5. SPOTLIGHT ON: Symphony of the Seas

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

Total elapsed time: 0.50586867332458

# Query Time
(1) connect 0.00059890747070312
(2) DESCRIBE `cruises` 0.0025207996368408
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (69888, 69854, 69855, 69891, 69873, 69856, 69874, 69857, 69892, 69875)) ORDER BY FIND_IN_SET(id, '69888,69854,69855,69891,69873,69856,69874,69857,69892,69875') 0.0014119148254395
(4) DESCRIBE `cruises` 0.0022859573364258
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69888') 0.00041604042053223
(6) DESCRIBE `ships` 0.0017390251159668
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00038313865661621
(8) DESCRIBE `ships` 0.0021040439605713
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.00028681755065918
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017595291137695
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016379356384277
(12) DESCRIBE `itineraries` 0.00078892707824707
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69888') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010361671447754
(14) DESCRIBE `ports` 0.001270055770874
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00041699409484863
(16) DESCRIBE `ports` 0.001162052154541
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00039196014404297
(18) DESCRIBE `ports` 0.0012400150299072
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00027298927307129
(20) DESCRIBE `sailingdates` 0.00087189674377441
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69888') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00077509880065918
(22) DESCRIBE `ports` 0.0011818408966064
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.0003349781036377
(24) DESCRIBE `ports` 0.00098395347595215
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00021791458129883
(26) DESCRIBE `ports` 0.00078582763671875
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00021791458129883
(28) DESCRIBE `ports` 0.00080299377441406
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.0002138614654541
(30) DESCRIBE `ports` 0.00085210800170898
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00027298927307129
(32) DESCRIBE `ports` 0.00079202651977539
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00019288063049316
(34) DESCRIBE `ports` 0.00069403648376465
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00024604797363281
(36) DESCRIBE `ports` 0.00071501731872559
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00022292137145996
(38) DESCRIBE `ports` 0.00075197219848633
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00026297569274902
(40) DESCRIBE `ports` 0.00081706047058105
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00018882751464844
(42) DESCRIBE `ports` 0.00073504447937012
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00024199485778809
(44) DESCRIBE `ports` 0.00068092346191406
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00023889541625977
(46) DESCRIBE `ports` 0.00073599815368652
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00028491020202637
(48) DESCRIBE `ports` 0.00074911117553711
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00018906593322754
(50) DESCRIBE `ports` 0.00073099136352539
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021505355834961
(52) DESCRIBE `ports` 0.00074887275695801
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002129077911377
(54) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69888') AND (sailingdate >= '2018-01-10') 0.013972997665405
(55) DESCRIBE `avid_specials` 0.0011420249938965
(56) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69888 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.001784086227417
(57) DESCRIBE `cruiselines` 0.0016860961914062
(58) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00037407875061035
(59) DESCRIBE `orchid_image` 0.0012869834899902
(60) DESCRIBE `cruiselines` 0.0015268325805664
(61) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00032901763916016
(62) DESCRIBE `cruises` 0.0018789768218994
(63) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69854') 0.00025081634521484
(64) DESCRIBE `ships` 0.0014200210571289
(65) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 262))) 0.00030303001403809
(66) DESCRIBE `ships` 0.0019490718841553
(67) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '262') 0.00026082992553711
(68) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021910667419434
(69) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021004676818848
(70) DESCRIBE `itineraries` 0.00076007843017578
(71) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69854') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00083184242248535
(72) DESCRIBE `ports` 0.001370906829834
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00032210350036621
(74) DESCRIBE `ports` 0.00098395347595215
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00027012825012207
(76) DESCRIBE `ports` 0.00094509124755859
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00024199485778809
(78) DESCRIBE `sailingdates` 0.00086593627929688
(79) DESCRIBE `ports` 0.0009620189666748
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00032401084899902
(81) DESCRIBE `ports` 0.00094699859619141
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00024509429931641
(83) DESCRIBE `ports` 0.00093984603881836
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00026392936706543
(85) DESCRIBE `ports` 0.00094795227050781
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00023889541625977
(87) DESCRIBE `ports` 0.00093889236450195
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 384))) 0.00027680397033691
(89) DESCRIBE `ports` 0.00094389915466309
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '384') 0.00023913383483887
(91) DESCRIBE `ports` 0.00095081329345703
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00025510787963867
(93) DESCRIBE `ports` 0.0009310245513916
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00023579597473145
(95) DESCRIBE `ports` 0.00098490715026855
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00026988983154297
(97) DESCRIBE `ports` 0.00094795227050781
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00024819374084473
(99) DESCRIBE `ports` 0.00096797943115234
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00027298927307129
(101) DESCRIBE `ports` 0.0010030269622803
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00040388107299805
(103) DESCRIBE `ports` 0.0011720657348633
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00029993057250977
(105) DESCRIBE `ports` 0.0010471343994141
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00029993057250977
(107) DESCRIBE `ports` 0.0010190010070801
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00028300285339355
(109) DESCRIBE `ports` 0.00097417831420898
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00024700164794922
(111) DESCRIBE `ports` 0.00098705291748047
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024795532226562
(113) DESCRIBE `ports` 0.0006868839263916
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018882751464844
(115) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69854') AND (sailingdate >= '2018-01-10') 0.0054950714111328
(116) DESCRIBE `avid_specials` 0.00080513954162598
(117) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69854 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.00098609924316406
(118) DESCRIBE `cruiselines` 0.0015568733215332
(119) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00028204917907715
(120) DESCRIBE `orchid_image` 0.00097894668579102
(121) DESCRIBE `cruiselines` 0.0011420249938965
(122) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00028300285339355
(123) DESCRIBE `cruises` 0.0022439956665039
(124) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69855') 0.00043606758117676
(125) DESCRIBE `ships` 0.0023958683013916
(126) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 262))) 0.00046491622924805
(127) DESCRIBE `ships` 0.0025029182434082
(128) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '262') 0.00040602684020996
(129) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024294853210449
(130) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002291202545166
(131) DESCRIBE `itineraries` 0.0011811256408691
(132) DESCRIBE `ports` 0.0012781620025635
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036501884460449
(134) DESCRIBE `ports` 0.0011210441589355
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030803680419922
(136) DESCRIBE `ports` 0.0011639595031738
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034284591674805
(138) DESCRIBE `sailingdates` 0.0011579990386963
(139) DESCRIBE `ports` 0.0013859272003174
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038790702819824
(141) DESCRIBE `ports` 0.0012819766998291
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00033402442932129
(143) DESCRIBE `ports` 0.001147985458374
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.0003349781036377
(145) DESCRIBE `ports` 0.0012240409851074
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00035285949707031
(147) DESCRIBE `ports` 0.0011739730834961
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00031900405883789
(149) DESCRIBE `ports` 0.0011348724365234
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00027608871459961
(151) DESCRIBE `ports` 0.0011188983917236
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00031399726867676
(153) DESCRIBE `ports` 0.0010778903961182
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00027012825012207
(155) DESCRIBE `ports` 0.0010950565338135
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00029492378234863
(157) DESCRIBE `ports` 0.0010538101196289
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00032901763916016
(159) DESCRIBE `ports` 0.0010719299316406
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00030708312988281
(161) DESCRIBE `ports` 0.0011239051818848
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00029277801513672
(163) DESCRIBE `ports` 0.0010900497436523
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036096572875977
(165) DESCRIBE `ports` 0.0010929107666016
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027918815612793
(167) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69855') AND (sailingdate >= '2018-01-10') 0.010344982147217
(168) DESCRIBE `avid_specials` 0.001284122467041
(169) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69855 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.001896858215332
(170) DESCRIBE `cruiselines` 0.0017790794372559
(171) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00041103363037109
(172) DESCRIBE `orchid_image` 0.0016889572143555
(173) DESCRIBE `cruiselines` 0.0019590854644775
(174) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.0004889965057373
(175) DESCRIBE `cruises` 0.0026252269744873
(176) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69891') 0.00042486190795898
(177) DESCRIBE `ships` 0.0016379356384277
(178) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00037193298339844
(179) DESCRIBE `ships` 0.0016121864318848
(180) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.00027608871459961
(181) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021696090698242
(182) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020384788513184
(183) DESCRIBE `itineraries` 0.0010800361633301
(184) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69891') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010731220245361
(185) DESCRIBE `ports` 0.0012180805206299
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032401084899902
(187) DESCRIBE `ports` 0.0010111331939697
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027990341186523
(189) DESCRIBE `ports` 0.0010268688201904
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027108192443848
(191) DESCRIBE `sailingdates` 0.00095105171203613
(192) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69891') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00046706199645996
(193) DESCRIBE `ports` 0.0011720657348633
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029683113098145
(195) DESCRIBE `ports` 0.00072288513183594
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018811225891113
(197) DESCRIBE `ports` 0.00067996978759766
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.0002140998840332
(199) DESCRIBE `ports` 0.00085687637329102
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00022411346435547
(201) DESCRIBE `ports` 0.00099015235900879
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00029397010803223
(203) DESCRIBE `ports` 0.0010619163513184
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00035405158996582
(205) DESCRIBE `ports` 0.0010871887207031
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00032305717468262
(207) DESCRIBE `ports` 0.0010490417480469
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00026798248291016
(209) DESCRIBE `ports` 0.0010180473327637
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00029706954956055
(211) DESCRIBE `ports` 0.0010340213775635
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00026583671569824
(213) DESCRIBE `ports` 0.0010330677032471
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00028204917907715
(215) DESCRIBE `ports` 0.00083589553833008
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00020408630371094
(217) DESCRIBE `ports` 0.00076699256896973
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00025510787963867
(219) DESCRIBE `ports` 0.00071597099304199
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00018906593322754
(221) DESCRIBE `ports` 0.00073099136352539
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002138614654541
(223) DESCRIBE `ports` 0.00078487396240234
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00020313262939453
(225) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69891') AND (sailingdate >= '2018-01-10') 0.0080509185791016
(226) DESCRIBE `avid_specials` 0.0012280941009521
(227) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69891 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.0018630027770996
(228) DESCRIBE `cruiselines` 0.0016422271728516
(229) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00037503242492676
(230) DESCRIBE `orchid_image` 0.0012469291687012
(231) DESCRIBE `cruiselines` 0.00146484375
(232) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00028800964355469
(233) DESCRIBE `cruises` 0.002439022064209
(234) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69873') 0.00032281875610352
(235) DESCRIBE `ships` 0.001863956451416
(236) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00030303001403809
(237) DESCRIBE `ships` 0.0014231204986572
(238) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00025606155395508
(239) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017809867858887
(240) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016903877258301
(241) DESCRIBE `itineraries` 0.00086808204650879
(242) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69873') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00054001808166504
(243) DESCRIBE `ports` 0.0011470317840576
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033903121948242
(245) DESCRIBE `ports` 0.00098586082458496
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036215782165527
(247) DESCRIBE `ports` 0.0010251998901367
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025391578674316
(249) DESCRIBE `sailingdates` 0.00063800811767578
(250) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69873') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00037193298339844
(251) DESCRIBE `ports` 0.00091719627380371
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023794174194336
(253) DESCRIBE `ports` 0.000701904296875
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019288063049316
(255) DESCRIBE `ports` 0.00072097778320312
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00022292137145996
(257) DESCRIBE `ports` 0.00067496299743652
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00018095970153809
(259) DESCRIBE `ports` 0.00075697898864746
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00021100044250488
(261) DESCRIBE `ports` 0.00072693824768066
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00022220611572266
(263) DESCRIBE `ports` 0.00094103813171387
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.0002751350402832
(265) DESCRIBE `ports` 0.0010459423065186
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00023412704467773
(267) DESCRIBE `ports` 0.00095105171203613
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00026082992553711
(269) DESCRIBE `ports` 0.00098586082458496
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00025200843811035
(271) DESCRIBE `ports` 0.00096607208251953
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00026702880859375
(273) DESCRIBE `ports` 0.00097393989562988
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00023102760314941
(275) DESCRIBE `ports` 0.00098586082458496
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00021815299987793
(277) DESCRIBE `ports` 0.00081205368041992
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00024199485778809
(279) DESCRIBE `ports` 0.00092577934265137
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00027298927307129
(281) DESCRIBE `ports` 0.00093603134155273
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00026392936706543
(283) DESCRIBE `ports` 0.00094318389892578
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.0002129077911377
(285) DESCRIBE `ports` 0.00068306922912598
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00018787384033203
(287) DESCRIBE `ports` 0.00067901611328125
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025796890258789
(289) DESCRIBE `ports` 0.00070810317993164
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00020480155944824
(291) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69873') AND (sailingdate >= '2018-01-10') 0.0065150260925293
(292) DESCRIBE `avid_specials` 0.00094103813171387
(293) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69873 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.0014660358428955
(294) DESCRIBE `cruiselines` 0.0010700225830078
(295) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00024008750915527
(296) DESCRIBE `orchid_image` 0.00077581405639648
(297) DESCRIBE `cruiselines` 0.0010168552398682
(298) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00018811225891113
(299) DESCRIBE `cruises` 0.0023398399353027
(300) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69856') 0.00032401084899902
(301) DESCRIBE `ships` 0.0019919872283936
(302) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 262))) 0.00031805038452148
(303) DESCRIBE `ships` 0.0018680095672607
(304) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '262') 0.00023412704467773
(305) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017905235290527
(306) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016593933105469
(307) DESCRIBE `itineraries` 0.00072503089904785
(308) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69856') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00042390823364258
(309) DESCRIBE `ports` 0.00078105926513672
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022602081298828
(311) DESCRIBE `ports` 0.00071001052856445
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00019311904907227
(313) DESCRIBE `ports` 0.00068902969360352
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018000602722168
(315) DESCRIBE `sailingdates` 0.0006098747253418
(316) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69856') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00038409233093262
(317) DESCRIBE `ports` 0.00072598457336426
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022387504577637
(319) DESCRIBE `ports` 0.00068306922912598
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019097328186035
(321) DESCRIBE `ports` 0.00066900253295898
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00020694732666016
(323) DESCRIBE `ports` 0.00070905685424805
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00018787384033203
(325) DESCRIBE `ports` 0.0006711483001709
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00020289421081543
(327) DESCRIBE `ports` 0.00068783760070801
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00018715858459473
(329) DESCRIBE `ports` 0.00066804885864258
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00020503997802734
(331) DESCRIBE `ports` 0.00069308280944824
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0001978874206543
(333) DESCRIBE `ports` 0.00067591667175293
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00020599365234375
(335) DESCRIBE `ports` 0.00066399574279785
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00027108192443848
(337) DESCRIBE `ports` 0.00067782402038574
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021791458129883
(339) DESCRIBE `ports` 0.00070405006408691
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00021100044250488
(341) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69856') AND (sailingdate >= '2018-01-10') 0.0062069892883301
(342) DESCRIBE `avid_specials` 0.00092506408691406
(343) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69856 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.0010578632354736
(344) DESCRIBE `cruiselines` 0.001039981842041
(345) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00024509429931641
(346) DESCRIBE `orchid_image` 0.00082087516784668
(347) DESCRIBE `cruiselines` 0.00094413757324219
(348) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00020408630371094
(349) DESCRIBE `cruises` 0.0014851093292236
(350) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69874') 0.00030207633972168
(351) DESCRIBE `ships` 0.0014150142669678
(352) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00037193298339844
(353) DESCRIBE `ships` 0.0020480155944824
(354) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00029802322387695
(355) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002281665802002
(356) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002138614654541
(357) DESCRIBE `itineraries` 0.001039981842041
(358) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69874') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00037002563476562
(359) DESCRIBE `ports` 0.00080108642578125
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002291202545166
(361) DESCRIBE `ports` 0.00069403648376465
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00019407272338867
(363) DESCRIBE `ports` 0.00073790550231934
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00020003318786621
(365) DESCRIBE `sailingdates` 0.00060510635375977
(366) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69874') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00036907196044922
(367) DESCRIBE `ports` 0.00077915191650391
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028586387634277
(369) DESCRIBE `ports` 0.00075292587280273
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019001960754395
(371) DESCRIBE `ports` 0.00097799301147461
(372) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00021696090698242
(373) DESCRIBE `ports` 0.0006859302520752
(374) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00018000602722168
(375) DESCRIBE `ports` 0.00067305564880371
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0002138614654541
(377) DESCRIBE `ports` 0.00094008445739746
(378) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00020599365234375
(379) DESCRIBE `ports` 0.00080585479736328
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00021004676818848
(381) DESCRIBE `ports` 0.00091791152954102
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00025415420532227
(383) DESCRIBE `ports` 0.0010271072387695
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028491020202637
(385) DESCRIBE `ports` 0.0010430812835693
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00024509429931641
(387) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69874') AND (sailingdate >= '2018-01-10') 0.0056989192962646
(388) DESCRIBE `avid_specials` 0.00097990036010742
(389) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69874 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.0010640621185303
(390) DESCRIBE `cruiselines` 0.0010578632354736
(391) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00024795532226562
(392) DESCRIBE `orchid_image` 0.00080394744873047
(393) DESCRIBE `cruiselines` 0.0011601448059082
(394) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.0002140998840332
(395) DESCRIBE `cruises` 0.001694917678833
(396) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69857') 0.00028204917907715
(397) DESCRIBE `ships` 0.0016529560089111
(398) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 262))) 0.00028705596923828
(399) DESCRIBE `ships` 0.0014660358428955
(400) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '262') 0.00021100044250488
(401) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017690658569336
(402) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016498565673828
(403) DESCRIBE `itineraries` 0.00077915191650391
(404) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69857') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00042891502380371
(405) DESCRIBE `ports` 0.00081706047058105
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025415420532227
(407) DESCRIBE `ports` 0.00070500373840332
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020289421081543
(409) DESCRIBE `ports` 0.00068783760070801
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018787384033203
(411) DESCRIBE `sailingdates` 0.00071287155151367
(412) DESCRIBE `ports` 0.00069212913513184
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022506713867188
(414) DESCRIBE `ports` 0.00081896781921387
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026512145996094
(416) DESCRIBE `ports` 0.00084400177001953
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00022292137145996
(418) DESCRIBE `ports` 0.00068306922912598
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0002129077911377
(420) DESCRIBE `ports` 0.00071191787719727
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.0001990795135498
(422) DESCRIBE `ports` 0.00069689750671387
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00019288063049316
(424) DESCRIBE `ports` 0.00073409080505371
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00021505355834961
(426) DESCRIBE `ports` 0.00070095062255859
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00017786026000977
(428) DESCRIBE `ports` 0.0007021427154541
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00020909309387207
(430) DESCRIBE `ports` 0.00066804885864258
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00017881393432617
(432) DESCRIBE `ports` 0.00066900253295898
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00020408630371094
(434) DESCRIBE `ports` 0.00066590309143066
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00017905235290527
(436) DESCRIBE `ports` 0.00067591667175293
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020599365234375
(438) DESCRIBE `ports` 0.00067996978759766
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0001981258392334
(440) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69857') AND (sailingdate >= '2018-01-10') 0.0061440467834473
(441) DESCRIBE `avid_specials` 0.00090694427490234
(442) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69857 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.0010190010070801
(443) DESCRIBE `cruiselines` 0.0010519027709961
(444) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00024914741516113
(445) DESCRIBE `orchid_image` 0.00083613395690918
(446) DESCRIBE `cruiselines` 0.0010039806365967
(447) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00021100044250488
(448) DESCRIBE `cruises` 0.0014898777008057
(449) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69892') 0.00026679039001465
(450) DESCRIBE `ships` 0.0016369819641113
(451) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00036001205444336
(452) DESCRIBE `ships` 0.0021569728851318
(453) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.00033187866210938
(454) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023412704467773
(455) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022101402282715
(456) DESCRIBE `itineraries` 0.0010888576507568
(457) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69892') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00046801567077637
(458) DESCRIBE `ports` 0.00084090232849121
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025105476379395
(460) DESCRIBE `ports` 0.00075602531433105
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022983551025391
(462) DESCRIBE `ports` 0.00084686279296875
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022196769714355
(464) DESCRIBE `sailingdates` 0.00066709518432617
(465) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69892') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00046086311340332
(466) DESCRIBE `ports` 0.0013399124145508
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029301643371582
(468) DESCRIBE `ports` 0.0009610652923584
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023794174194336
(470) DESCRIBE `ports` 0.00073885917663574
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00022506713867188
(472) DESCRIBE `ports` 0.00069618225097656
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00018906593322754
(474) DESCRIBE `ports` 0.00075793266296387
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00020289421081543
(476) DESCRIBE `ports` 0.00082492828369141
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00018715858459473
(478) DESCRIBE `ports` 0.00066399574279785
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00020599365234375
(480) DESCRIBE `ports` 0.00068187713623047
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00018405914306641
(482) DESCRIBE `ports` 0.00067710876464844
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00020599365234375
(484) DESCRIBE `ports` 0.00071501731872559
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.0002140998840332
(486) DESCRIBE `ports` 0.00075793266296387
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00020599365234375
(488) DESCRIBE `ports` 0.00094699859619141
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00025796890258789
(490) DESCRIBE `ports` 0.00092697143554688
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00022983551025391
(492) DESCRIBE `ports` 0.00069117546081543
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00018882751464844
(494) DESCRIBE `ports` 0.00068807601928711
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.0001978874206543
(496) DESCRIBE `ports` 0.00069379806518555
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00020003318786621
(498) DESCRIBE `ports` 0.00067901611328125
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00020503997802734
(500) DESCRIBE `ports` 0.00072097778320312
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00018906593322754
(502) DESCRIBE `ports` 0.00072002410888672
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00021219253540039
(504) DESCRIBE `ports` 0.00075483322143555
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00024986267089844
(506) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69892') AND (sailingdate >= '2018-01-10') 0.0079460144042969
(507) DESCRIBE `avid_specials` 0.0010139942169189
(508) 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.0011520385742188
(509) DESCRIBE `cruiselines` 0.0011229515075684
(510) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00038695335388184
(511) DESCRIBE `orchid_image` 0.0011978149414062
(512) DESCRIBE `cruiselines` 0.0015299320220947
(513) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00043392181396484
(514) DESCRIBE `cruises` 0.0020420551300049
(515) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69875') 0.00036787986755371
(516) DESCRIBE `ships` 0.0020430088043213
(517) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00066208839416504
(518) DESCRIBE `ships` 0.0019760131835938
(519) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00032901763916016
(520) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018000602722168
(521) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001680850982666
(522) DESCRIBE `itineraries` 0.00089097023010254
(523) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69875') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00052905082702637
(524) DESCRIBE `ports` 0.0011029243469238
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030803680419922
(526) DESCRIBE `ports` 0.00098395347595215
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028300285339355
(528) DESCRIBE `ports` 0.0010490417480469
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027298927307129
(530) DESCRIBE `sailingdates` 0.00091004371643066
(531) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '69875') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00048708915710449
(532) DESCRIBE `ports` 0.0010981559753418
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031900405883789
(534) DESCRIBE `ports` 0.00099921226501465
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025010108947754
(536) DESCRIBE `ports` 0.00096797943115234
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00024795532226562
(538) DESCRIBE `ports` 0.00095891952514648
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00024580955505371
(540) DESCRIBE `ports` 0.00096702575683594
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00027608871459961
(542) DESCRIBE `ports` 0.00097513198852539
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00025200843811035
(544) DESCRIBE `ports` 0.00083613395690918
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.0002739429473877
(546) DESCRIBE `ports` 0.00096297264099121
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00024509429931641
(548) DESCRIBE `ports` 0.00095891952514648
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00026583671569824
(550) DESCRIBE `ports` 0.00097990036010742
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00024914741516113
(552) DESCRIBE `ports` 0.00098395347595215
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00028109550476074
(554) DESCRIBE `ports` 0.0010769367218018
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00024509429931641
(556) DESCRIBE `ports` 0.0010058879852295
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00030398368835449
(558) DESCRIBE `ports` 0.00099587440490723
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00025701522827148
(560) DESCRIBE `ports` 0.00099301338195801
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00028586387634277
(562) DESCRIBE `ports` 0.0010199546813965
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00025296211242676
(564) DESCRIBE `ports` 0.0010058879852295
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.0002129077911377
(566) DESCRIBE `ports` 0.00068998336791992
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00018692016601562
(568) DESCRIBE `ports` 0.0007481575012207
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.0002129077911377
(570) DESCRIBE `ports` 0.00074100494384766
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00019097328186035
(572) DESCRIBE `ports` 0.00067996978759766
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022387504577637
(574) DESCRIBE `ports` 0.00072598457336426
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019407272338867
(576) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '69875') AND (sailingdate >= '2018-01-10') 0.0091540813446045
(577) DESCRIBE `avid_specials` 0.0012128353118896
(578) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69875 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.0018141269683838
(579) DESCRIBE `cruiselines` 0.0016520023345947
(580) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00030517578125
(581) DESCRIBE `orchid_image` 0.0011248588562012
(582) DESCRIBE `cruiselines` 0.0013649463653564
(583) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.0002598762512207
(584) DESCRIBE `ships` 0.0022709369659424
(585) SELECT `ships`.* FROM `ships` WHERE (id IN ('1330', '287', '262', '124')) ORDER BY FIND_IN_SET(id, '1330,287,262,124') 0.00064301490783691
(586) DESCRIBE `cruisetypes` 0.00089097023010254
(587) 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.03009295463562
(588) DESCRIBE `cruiselines` 0.0012869834899902
(589) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00026822090148926
(590) DESCRIBE `destinations` 0.00088906288146973
(591) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 43))) 0.0002439022064209
(592) DESCRIBE `destinations` 0.00088000297546387
(593) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 43))) 0.00023317337036133
(594) DESCRIBE `cruiselines` 0.0010161399841309
(595) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00021982192993164