or, enquire about your chosen options

  1. Catch up on Cruising: Latest news in bite size
  2. Catch up on Cruising: Latest news in bite size
  3. Family Cruising – Have you considered it ?
  4. New Azamara Ship to arrive in March 2018
  5. Enhanced amenities for Oceania Cruises

Sign up to our newsletter and become the first to know about our latest deals and promotions

 
 

Please note, while cruise details and inclusions are accurate at time of loading they are subject to change due to changes in cruise line practices and policies. Please check details and inclusions at time of booking.

Database Profiling Report

Total queries executed: 587

Total elapsed time: 0.41911959648132

# Query Time
(1) connect 0.00068187713623047
(2) DESCRIBE `cruises` 0.0017118453979492
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (56593, 59205, 62152, 60968, 64377, 56413, 63044, 63046, 57765, 55007)) ORDER BY FIND_IN_SET(id, '56593,59205,62152,60968,64377,56413,63044,63046,57765,55007') 0.0012509822845459
(4) DESCRIBE `cruises` 0.0015590190887451
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56593') 0.00025200843811035
(6) DESCRIBE `ships` 0.0013821125030518
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 290))) 0.00026893615722656
(8) DESCRIBE `ships` 0.0012948513031006
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '290') 0.00019407272338867
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017380714416504
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016212463378906
(12) DESCRIBE `itineraries` 0.00071001052856445
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '56593') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00059390068054199
(14) DESCRIBE `ports` 0.00077700614929199
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00022506713867188
(16) DESCRIBE `ports` 0.00066590309143066
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00019192695617676
(18) DESCRIBE `ports` 0.00065803527832031
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00019311904907227
(20) DESCRIBE `sailingdates` 0.00059294700622559
(21) DESCRIBE `ports` 0.00077700614929199
(22) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00023603439331055
(23) DESCRIBE `ports` 0.00071096420288086
(24) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00020098686218262
(25) DESCRIBE `ports` 0.00069499015808105
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) 0.00021195411682129
(27) DESCRIBE `ports` 0.00067996978759766
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '17') 0.00018787384033203
(29) DESCRIBE `ports` 0.0007328987121582
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00021195411682129
(31) DESCRIBE `ports` 0.00067496299743652
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00018405914306641
(33) DESCRIBE `ports` 0.00066494941711426
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00019407272338867
(35) DESCRIBE `ports` 0.00066399574279785
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00017595291137695
(37) DESCRIBE `ports` 0.00066304206848145
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 384))) 0.00020003318786621
(39) DESCRIBE `ports` 0.00081992149353027
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '384') 0.0001828670501709
(41) DESCRIBE `ports` 0.00066590309143066
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 331))) 0.00020098686218262
(43) DESCRIBE `ports` 0.00066304206848145
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '331') 0.00018501281738281
(45) DESCRIBE `ports` 0.00072193145751953
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00021100044250488
(47) DESCRIBE `ports` 0.00073814392089844
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00018501281738281
(49) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '56593') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0043830871582031
(50) DESCRIBE `avid_specials` 0.00084710121154785
(51) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56593 and class = 'Cruise') OR (item_id = 290 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 29 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.0011119842529297
(52) DESCRIBE `cruiselines` 0.0010340213775635
(53) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00023293495178223
(54) DESCRIBE `orchid_image` 0.00080609321594238
(55) DESCRIBE `cruiselines` 0.0010459423065186
(56) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00020313262939453
(57) DESCRIBE `cruises` 0.0020461082458496
(58) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59205') 0.00023698806762695
(59) DESCRIBE `ships` 0.0012619495391846
(60) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 542))) 0.00026798248291016
(61) DESCRIBE `ships` 0.0013120174407959
(62) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '542') 0.00021195411682129
(63) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023603439331055
(64) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016498565673828
(65) DESCRIBE `itineraries` 0.00076508522033691
(66) DESCRIBE `ports` 0.00081992149353027
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00024604797363281
(68) DESCRIBE `ports` 0.00066280364990234
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00019383430480957
(70) DESCRIBE `ports` 0.00070595741271973
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00018596649169922
(72) DESCRIBE `sailingdates` 0.00068402290344238
(73) DESCRIBE `ports` 0.00072097778320312
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00021791458129883
(75) DESCRIBE `ports` 0.00066089630126953
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00018095970153809
(77) DESCRIBE `ports` 0.00067806243896484
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00025296211242676
(79) DESCRIBE `ports` 0.00091290473937988
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.0001838207244873
(81) DESCRIBE `ports` 0.00084686279296875
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3473))) 0.00026297569274902
(83) DESCRIBE `ports` 0.00067496299743652
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3473') 0.00023412704467773
(85) DESCRIBE `ports` 0.00094485282897949
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 117))) 0.00021004676818848
(87) DESCRIBE `ports` 0.00067400932312012
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '117') 0.0001978874206543
(89) DESCRIBE `ports` 0.00083303451538086
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00021195411682129
(91) DESCRIBE `ports` 0.00069594383239746
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00018811225891113
(93) DESCRIBE `ports` 0.00068116188049316
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 333))) 0.00021696090698242
(95) DESCRIBE `ports` 0.00071191787719727
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '333') 0.00018215179443359
(97) DESCRIBE `ports` 0.00067520141601562
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00020313262939453
(99) DESCRIBE `ports` 0.00068092346191406
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00021004676818848
(101) DESCRIBE `ports` 0.00067400932312012
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00020599365234375
(103) DESCRIBE `ports` 0.00069904327392578
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00017905235290527
(105) DESCRIBE `ports` 0.0006709098815918
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 118))) 0.0001981258392334
(107) DESCRIBE `ports` 0.00066900253295898
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '118') 0.00017380714416504
(109) DESCRIBE `ports` 0.00066804885864258
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0001981258392334
(111) DESCRIBE `ports` 0.00071287155151367
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00017809867858887
(113) DESCRIBE `ports` 0.00070405006408691
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1095))) 0.00020194053649902
(115) DESCRIBE `ports` 0.00068497657775879
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1095') 0.00026106834411621
(117) DESCRIBE `ports` 0.00099587440490723
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00028204917907715
(119) DESCRIBE `ports` 0.00099587440490723
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00024008750915527
(121) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '59205') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0057640075683594
(122) DESCRIBE `avid_specials` 0.00085091590881348
(123) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59205 and class = 'Cruise') OR (item_id = 542 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 11 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.001209020614624
(124) DESCRIBE `cruiselines` 0.0015060901641846
(125) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00032186508178711
(126) DESCRIBE `orchid_image` 0.0011348724365234
(127) DESCRIBE `cruiselines` 0.0010750293731689
(128) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00022602081298828
(129) DESCRIBE `cruises` 0.0013489723205566
(130) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62152') 0.00048112869262695
(131) DESCRIBE `ships` 0.0019938945770264
(132) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 253))) 0.0004270076751709
(133) DESCRIBE `ships` 0.0016379356384277
(134) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '253') 0.00030398368835449
(135) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(136) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016903877258301
(137) DESCRIBE `itineraries` 0.00084805488586426
(138) DESCRIBE `ports` 0.0009608268737793
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028109550476074
(140) DESCRIBE `ports` 0.00079607963562012
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023889541625977
(142) DESCRIBE `ports` 0.00077700614929199
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002140998840332
(144) DESCRIBE `sailingdates` 0.00070691108703613
(145) DESCRIBE `ports` 0.0010061264038086
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002739429473877
(147) DESCRIBE `ports` 0.00075197219848633
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002138614654541
(149) DESCRIBE `ports` 0.00075888633728027
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00025200843811035
(151) DESCRIBE `ports` 0.00073599815368652
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00020098686218262
(153) DESCRIBE `ports` 0.00072407722473145
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3064))) 0.00028491020202637
(155) DESCRIBE `ports` 0.00073981285095215
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3064') 0.00021910667419434
(157) DESCRIBE `ports` 0.0007319450378418
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.0002291202545166
(159) DESCRIBE `ports` 0.00076794624328613
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00021791458129883
(161) DESCRIBE `ports` 0.00069403648376465
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.000244140625
(163) DESCRIBE `ports` 0.00071406364440918
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00019216537475586
(165) DESCRIBE `ports` 0.00070810317993164
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00023317337036133
(167) DESCRIBE `ports` 0.00072789192199707
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00022411346435547
(169) DESCRIBE `ports` 0.00078511238098145
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023579597473145
(171) DESCRIBE `ports` 0.00073814392089844
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00021195411682129
(173) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62152') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0044729709625244
(174) DESCRIBE `avid_specials` 0.00092411041259766
(175) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62152 and class = 'Cruise') OR (item_id = 253 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 8 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.0011827945709229
(176) DESCRIBE `cruiselines` 0.0012619495391846
(177) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00034403800964355
(178) DESCRIBE `orchid_image` 0.00094389915466309
(179) DESCRIBE `cruiselines` 0.0015060901641846
(180) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00029397010803223
(181) DESCRIBE `cruises` 0.0015790462493896
(182) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60968') 0.00029611587524414
(183) DESCRIBE `ships` 0.0017969608306885
(184) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 349))) 0.0004417896270752
(185) DESCRIBE `ships` 0.001741886138916
(186) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '349') 0.00036787986755371
(187) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023293495178223
(188) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016999244689941
(189) DESCRIBE `itineraries` 0.00085997581481934
(190) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '60968') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00084400177001953
(191) DESCRIBE `ports` 0.0010011196136475
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00031900405883789
(193) DESCRIBE `ports` 0.00098395347595215
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00025796890258789
(195) DESCRIBE `ports` 0.0008549690246582
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00025200843811035
(197) DESCRIBE `sailingdates` 0.00074911117553711
(198) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '60968') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00062084197998047
(199) DESCRIBE `ports` 0.0010089874267578
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00029492378234863
(201) DESCRIBE `ports` 0.00080704689025879
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00022196769714355
(203) DESCRIBE `ports` 0.00084495544433594
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 541))) 0.00025200843811035
(205) DESCRIBE `ports` 0.0007479190826416
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '541') 0.0002140998840332
(207) DESCRIBE `ports` 0.0010349750518799
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 503))) 0.0002589225769043
(209) DESCRIBE `ports` 0.00078296661376953
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '503') 0.00023388862609863
(211) DESCRIBE `ports` 0.00088596343994141
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00028586387634277
(213) DESCRIBE `ports` 0.00079679489135742
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00021886825561523
(215) DESCRIBE `ports` 0.00072503089904785
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.0002589225769043
(217) DESCRIBE `ports` 0.0011680126190186
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00034093856811523
(219) DESCRIBE `ports` 0.0010440349578857
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1437))) 0.00026798248291016
(221) DESCRIBE `ports` 0.00082111358642578
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1437') 0.00022983551025391
(223) DESCRIBE `ports` 0.00078415870666504
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 193))) 0.00023198127746582
(225) DESCRIBE `ports` 0.0009918212890625
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '193') 0.00031685829162598
(227) DESCRIBE `ports` 0.0012071132659912
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1500))) 0.0003199577331543
(229) DESCRIBE `ports` 0.00089788436889648
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1500') 0.00024604797363281
(231) DESCRIBE `ports` 0.00076794624328613
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00024795532226562
(233) DESCRIBE `ports` 0.00081515312194824
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00023889541625977
(235) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '60968') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0045950412750244
(236) DESCRIBE `avid_specials` 0.00093483924865723
(237) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60968 and class = 'Cruise') OR (item_id = 349 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 35 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.0012109279632568
(238) DESCRIBE `cruiselines` 0.0011930465698242
(239) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00030303001403809
(240) DESCRIBE `orchid_image` 0.00088000297546387
(241) DESCRIBE `cruiselines` 0.0010778903961182
(242) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0002739429473877
(243) DESCRIBE `cruises` 0.001596212387085
(244) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64377') 0.0003809928894043
(245) DESCRIBE `ships` 0.0017979145050049
(246) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1135))) 0.00045108795166016
(247) DESCRIBE `ships` 0.0015840530395508
(248) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1135') 0.00029301643371582
(249) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018095970153809
(250) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019598007202148
(251) DESCRIBE `itineraries` 0.00083780288696289
(252) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64377') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00063610076904297
(253) DESCRIBE `ports` 0.0010480880737305
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00032901763916016
(255) DESCRIBE `ports` 0.00084209442138672
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0002589225769043
(257) DESCRIBE `ports` 0.00080013275146484
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00022602081298828
(259) DESCRIBE `sailingdates` 0.0007178783416748
(260) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64377') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00050497055053711
(261) DESCRIBE `ports` 0.00098299980163574
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00031518936157227
(263) DESCRIBE `ports` 0.00086593627929688
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00023007392883301
(265) DESCRIBE `ports` 0.0008089542388916
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00024318695068359
(267) DESCRIBE `ports` 0.00078511238098145
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00023794174194336
(269) DESCRIBE `ports` 0.00079989433288574
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 41))) 0.00025296211242676
(271) DESCRIBE `ports` 0.00078010559082031
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '41') 0.00023913383483887
(273) DESCRIBE `ports` 0.00092601776123047
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1494))) 0.00026798248291016
(275) DESCRIBE `ports` 0.00083804130554199
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1494') 0.00022387504577637
(277) DESCRIBE `ports` 0.00077605247497559
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00026202201843262
(279) DESCRIBE `ports` 0.00084280967712402
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00022697448730469
(281) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '64377') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0051298141479492
(282) DESCRIBE `avid_specials` 0.0011930465698242
(283) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64377 and class = 'Cruise') OR (item_id = 1135 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 12 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0019478797912598
(284) DESCRIBE `cruiselines` 0.0016310214996338
(285) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00045490264892578
(286) DESCRIBE `orchid_image` 0.0012838840484619
(287) DESCRIBE `cruiselines` 0.0016748905181885
(288) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0003361701965332
(289) DESCRIBE `cruises` 0.0016498565673828
(290) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '56413') 0.00037908554077148
(291) DESCRIBE `ships` 0.0016641616821289
(292) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 348))) 0.00039005279541016
(293) DESCRIBE `ships` 0.0016658306121826
(294) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '348') 0.00031185150146484
(295) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019001960754395
(296) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017189979553223
(297) DESCRIBE `itineraries` 0.00084209442138672
(298) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '56413') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00066995620727539
(299) DESCRIBE `ports` 0.0010340213775635
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00035190582275391
(301) DESCRIBE `ports` 0.0008080005645752
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00027799606323242
(303) DESCRIBE `ports` 0.00082206726074219
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00023603439331055
(305) DESCRIBE `sailingdates` 0.0007479190826416
(306) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '56413') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00053596496582031
(307) DESCRIBE `ports` 0.0010302066802979
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00029683113098145
(309) DESCRIBE `ports` 0.00081300735473633
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00021910667419434
(311) DESCRIBE `ports` 0.00084090232849121
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2519))) 0.00026321411132812
(313) DESCRIBE `ports` 0.00078201293945312
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2519') 0.00022482872009277
(315) DESCRIBE `ports` 0.00086498260498047
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00026798248291016
(317) DESCRIBE `ports` 0.00083208084106445
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00024795532226562
(319) DESCRIBE `ports` 0.00077414512634277
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00023794174194336
(321) DESCRIBE `ports` 0.00076603889465332
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00020885467529297
(323) DESCRIBE `ports` 0.00073909759521484
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.00024294853210449
(325) DESCRIBE `ports` 0.00079011917114258
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.00020599365234375
(327) DESCRIBE `ports` 0.00075697898864746
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 615))) 0.00025296211242676
(329) DESCRIBE `ports` 0.00096702575683594
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '615') 0.00023984909057617
(331) DESCRIBE `ports` 0.00075984001159668
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2142))) 0.00023698806762695
(333) DESCRIBE `ports` 0.00080990791320801
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2142') 0.00021219253540039
(335) DESCRIBE `ports` 0.00073599815368652
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00023698806762695
(337) DESCRIBE `ports` 0.00073003768920898
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00026202201843262
(339) DESCRIBE `ports` 0.00072097778320312
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00024604797363281
(341) DESCRIBE `ports` 0.00077509880065918
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00020885467529297
(343) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '56413') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0045511722564697
(344) DESCRIBE `avid_specials` 0.00092577934265137
(345) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 56413 and class = 'Cruise') OR (item_id = 348 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 48 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.001227855682373
(346) DESCRIBE `cruiselines` 0.0011980533599854
(347) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00035691261291504
(348) DESCRIBE `orchid_image` 0.001431941986084
(349) DESCRIBE `cruiselines` 0.0016348361968994
(350) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00037288665771484
(351) DESCRIBE `cruises` 0.0017578601837158
(352) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63044') 0.00035214424133301
(353) DESCRIBE `ships` 0.0017271041870117
(354) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 291))) 0.00039792060852051
(355) DESCRIBE `ships` 0.0016379356384277
(356) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '291') 0.00032711029052734
(357) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018596649169922
(358) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017189979553223
(359) DESCRIBE `itineraries` 0.00087785720825195
(360) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63044') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0005190372467041
(361) DESCRIBE `ports` 0.00098299980163574
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.0003361701965332
(363) DESCRIBE `ports` 0.000823974609375
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00027704238891602
(365) DESCRIBE `ports` 0.00079202651977539
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00021886825561523
(367) DESCRIBE `sailingdates` 0.00069713592529297
(368) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63044') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00049710273742676
(369) DESCRIBE `ports` 0.0013909339904785
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00039792060852051
(371) DESCRIBE `ports` 0.0011768341064453
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00032806396484375
(373) DESCRIBE `ports` 0.0010528564453125
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00031590461730957
(375) DESCRIBE `ports` 0.0011069774627686
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00031805038452148
(377) DESCRIBE `ports` 0.001147985458374
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 615))) 0.00034403800964355
(379) DESCRIBE `ports` 0.0011658668518066
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '615') 0.00028085708618164
(381) DESCRIBE `ports` 0.00086617469787598
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.0002589225769043
(383) DESCRIBE `ports` 0.00077700614929199
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.00021815299987793
(385) DESCRIBE `ports` 0.0007779598236084
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.0002288818359375
(387) DESCRIBE `ports` 0.00075697898864746
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00023508071899414
(389) DESCRIBE `ports` 0.00077700614929199
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00025081634521484
(391) DESCRIBE `ports` 0.00079894065856934
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00022721290588379
(393) DESCRIBE `ports` 0.00079607963562012
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2519))) 0.00023794174194336
(395) DESCRIBE `ports` 0.00078701972961426
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2519') 0.00022506713867188
(397) DESCRIBE `ports` 0.00089001655578613
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00034093856811523
(399) DESCRIBE `ports` 0.00081706047058105
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00024604797363281
(401) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63044') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.004518985748291
(402) DESCRIBE `avid_specials` 0.00091910362243652
(403) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63044 and class = 'Cruise') OR (item_id = 291 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 48 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.0012710094451904
(404) DESCRIBE `cruiselines` 0.0011930465698242
(405) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00031018257141113
(406) DESCRIBE `orchid_image` 0.00097203254699707
(407) DESCRIBE `cruiselines` 0.0011391639709473
(408) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00030899047851562
(409) DESCRIBE `cruises` 0.0016307830810547
(410) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63046') 0.00033712387084961
(411) DESCRIBE `ships` 0.0016729831695557
(412) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 678))) 0.00039887428283691
(413) DESCRIBE `ships` 0.0015859603881836
(414) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '678') 0.00030684471130371
(415) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019001960754395
(416) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017285346984863
(417) DESCRIBE `itineraries` 0.00086617469787598
(418) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63046') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00050902366638184
(419) DESCRIBE `ports` 0.00095510482788086
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00029301643371582
(421) DESCRIBE `ports` 0.00087189674377441
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00026106834411621
(423) DESCRIBE `ports` 0.00078606605529785
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.0002291202545166
(425) DESCRIBE `sailingdates` 0.00081706047058105
(426) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63046') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00054407119750977
(427) DESCRIBE `ports` 0.0010740756988525
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00029301643371582
(429) DESCRIBE `ports` 0.00088596343994141
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00022506713867188
(431) DESCRIBE `ports` 0.00074005126953125
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00022506713867188
(433) DESCRIBE `ports` 0.00080585479736328
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00023412704467773
(435) DESCRIBE `ports` 0.00077605247497559
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.00023603439331055
(437) DESCRIBE `ports` 0.00079011917114258
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.00029516220092773
(439) DESCRIBE `ports` 0.00084996223449707
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00028300285339355
(441) DESCRIBE `ports` 0.00086808204650879
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00025510787963867
(443) DESCRIBE `ports` 0.00074911117553711
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00025200843811035
(445) DESCRIBE `ports` 0.00081801414489746
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00024509429931641
(447) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63046') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0045778751373291
(448) DESCRIBE `avid_specials` 0.00094509124755859
(449) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63046 and class = 'Cruise') OR (item_id = 678 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 53 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.0013329982757568
(450) DESCRIBE `cruiselines` 0.0012660026550293
(451) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00034880638122559
(452) DESCRIBE `orchid_image` 0.00097012519836426
(453) DESCRIBE `cruiselines` 0.0013329982757568
(454) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00033402442932129
(455) DESCRIBE `cruises` 0.0016360282897949
(456) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57765') 0.00036501884460449
(457) DESCRIBE `ships` 0.0016491413116455
(458) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 98))) 0.00049090385437012
(459) DESCRIBE `ships` 0.0017139911651611
(460) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '98') 0.00036191940307617
(461) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021696090698242
(462) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020194053649902
(463) DESCRIBE `itineraries` 0.00092601776123047
(464) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '57765') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00048995018005371
(465) DESCRIBE `ports` 0.0014781951904297
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00038814544677734
(467) DESCRIBE `ports` 0.0013420581817627
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00030803680419922
(469) DESCRIBE `ports` 0.001168966293335
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.0003201961517334
(471) DESCRIBE `sailingdates` 0.0010600090026855
(472) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '57765') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00074219703674316
(473) DESCRIBE `ports` 0.0012400150299072
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00033211708068848
(475) DESCRIBE `ports` 0.000946044921875
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00027179718017578
(477) DESCRIBE `ports` 0.0010139942169189
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) 0.00042605400085449
(479) DESCRIBE `ports` 0.00089693069458008
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '17') 0.00023603439331055
(481) DESCRIBE `ports` 0.00077605247497559
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.0002598762512207
(483) DESCRIBE `ports` 0.00077986717224121
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00022101402282715
(485) DESCRIBE `ports` 0.000762939453125
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00022315979003906
(487) DESCRIBE `ports` 0.00076389312744141
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00023198127746582
(489) DESCRIBE `ports` 0.00090503692626953
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 384))) 0.00025200843811035
(491) DESCRIBE `ports` 0.00079798698425293
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '384') 0.00023007392883301
(493) DESCRIBE `ports` 0.00077509880065918
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 331))) 0.00027298927307129
(495) DESCRIBE `ports` 0.00084209442138672
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '331') 0.00023102760314941
(497) DESCRIBE `ports` 0.00082111358642578
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.0002591609954834
(499) DESCRIBE `ports` 0.00075793266296387
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00023603439331055
(501) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '57765') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0046019554138184
(502) DESCRIBE `avid_specials` 0.00090599060058594
(503) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57765 and class = 'Cruise') OR (item_id = 98 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 29 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.0012538433074951
(504) DESCRIBE `cruiselines` 0.0013539791107178
(505) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00048208236694336
(506) DESCRIBE `orchid_image` 0.0012600421905518
(507) DESCRIBE `cruiselines` 0.0014419555664062
(508) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.0002901554107666
(509) DESCRIBE `cruises` 0.0018250942230225
(510) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55007') 0.00025606155395508
(511) DESCRIBE `ships` 0.0013821125030518
(512) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 341))) 0.00026917457580566
(513) DESCRIBE `ships` 0.0014221668243408
(514) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '341') 0.00031304359436035
(515) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028204917907715
(516) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002281665802002
(517) DESCRIBE `itineraries` 0.0010750293731689
(518) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '55007') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00066804885864258
(519) DESCRIBE `ports` 0.001168966293335
(520) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00034308433532715
(521) DESCRIBE `ports` 0.0010299682617188
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0002748966217041
(523) DESCRIBE `ports` 0.0010390281677246
(524) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00026512145996094
(525) DESCRIBE `sailingdates` 0.00087118148803711
(526) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '55007') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00057291984558105
(527) DESCRIBE `ports` 0.001176118850708
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0003511905670166
(529) DESCRIBE `ports` 0.0011670589447021
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00028896331787109
(531) DESCRIBE `ports` 0.00099682807922363
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00029492378234863
(533) DESCRIBE `ports` 0.0010011196136475
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00030303001403809
(535) DESCRIBE `ports` 0.0009610652923584
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00028610229492188
(537) DESCRIBE `ports` 0.00099492073059082
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00025701522827148
(539) DESCRIBE `ports` 0.00099301338195801
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00027918815612793
(541) DESCRIBE `ports` 0.0010221004486084
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00025391578674316
(543) DESCRIBE `ports` 0.00096893310546875
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00028896331787109
(545) DESCRIBE `ports` 0.0010688304901123
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00028300285339355
(547) DESCRIBE `ports` 0.00078392028808594
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1100))) 0.00029897689819336
(549) DESCRIBE `ports` 0.0010080337524414
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1100') 0.00025701522827148
(551) DESCRIBE `ports` 0.0009911060333252
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00022697448730469
(553) DESCRIBE `ports` 0.00077414512634277
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00019693374633789
(555) DESCRIBE `ports` 0.00071120262145996
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00022602081298828
(557) DESCRIBE `ports` 0.00098896026611328
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00027799606323242
(559) DESCRIBE `ports` 0.0010161399841309
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00028610229492188
(561) DESCRIBE `ports` 0.0010108947753906
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.0002589225769043
(563) DESCRIBE `ports` 0.00099992752075195
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3268))) 0.00022602081298828
(565) DESCRIBE `ports` 0.00068879127502441
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3268') 0.00019001960754395
(567) DESCRIBE `ports` 0.00067901611328125
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021100044250488
(569) DESCRIBE `ports` 0.00067782402038574
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018978118896484
(571) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '55007') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.004457950592041
(572) DESCRIBE `avid_specials` 0.00085186958312988
(573) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55007 and class = 'Cruise') OR (item_id = 341 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011289119720459
(574) DESCRIBE `cruiselines` 0.0010340213775635
(575) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00023913383483887
(576) DESCRIBE `orchid_image` 0.00075602531433105
(577) DESCRIBE `cruiselines` 0.0010359287261963
(578) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00020194053649902
(579) DESCRIBE `ships` 0.0016529560089111
(580) SELECT `ships`.* FROM `ships` WHERE (id IN ('1135', '349', '542', '1021', '406', '434', '253', '451', '678', '105', '580', '290', '291', '98', '348', '341', '1409')) ORDER BY FIND_IN_SET(id, '1135,349,542,1021,406,434,253,451,678,105,580,290,291,98,348,341,1409') 0.00090503692626953
(581) DESCRIBE `cruisetypes` 0.00085306167602539
(582) DESCRIBE `destinations` 0.00091814994812012
(583) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '35', '2', '43', '48', '8', '22', '53', '26', '29', '40', '34', '37', '21', '38', '11', '25', '49', '28')) ORDER BY FIND_IN_SET(id, '12,35,2,43,48,8,22,53,26,29,40,34,37,21,38,11,25,49,28') 0.00083088874816895
(584) DESCRIBE `cruiselines` 0.001305103302002
(585) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00029206275939941
(586) DESCRIBE `cruiselines` 0.0011730194091797
(587) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.0002601146697998