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

Total elapsed time: 0.38519620895386

# Query Time
(1) connect 0.0005638599395752
(2) DESCRIBE `cruises` 0.002000093460083
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (62516, 67864, 15922, 27131, 67875, 66480, 66526, 70581, 66663, 54648)) ORDER BY FIND_IN_SET(id, '62516,67864,15922,27131,67875,66480,66526,70581,66663,54648') 0.0011169910430908
(4) DESCRIBE `cruises` 0.0013339519500732
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62516') 0.00018882751464844
(6) DESCRIBE `ships` 0.0013351440429688
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1135))) 0.00022411346435547
(8) DESCRIBE `ships` 0.0012960433959961
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1135') 0.00017213821411133
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017309188842773
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018596649169922
(12) DESCRIBE `itineraries` 0.00079107284545898
(13) DESCRIBE `ports` 0.00069594383239746
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00024008750915527
(15) DESCRIBE `ports` 0.00073599815368652
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00019407272338867
(17) DESCRIBE `ports` 0.00076508522033691
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00018620491027832
(19) DESCRIBE `sailingdates` 0.00064206123352051
(20) DESCRIBE `ports` 0.00067591667175293
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00019288063049316
(22) DESCRIBE `ports` 0.00076484680175781
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00018692016601562
(24) DESCRIBE `ports` 0.00092577934265137
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.0001988410949707
(26) DESCRIBE `ports` 0.00087499618530273
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00017404556274414
(28) DESCRIBE `ports` 0.00082206726074219
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00019288063049316
(30) DESCRIBE `ports` 0.00076103210449219
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00017189979553223
(32) DESCRIBE `ports` 0.00074195861816406
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00020098686218262
(34) DESCRIBE `ports` 0.0007779598236084
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00020408630371094
(36) DESCRIBE `ports` 0.0006859302520752
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.0001990795135498
(38) DESCRIBE `ports` 0.00066900253295898
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00017309188842773
(40) DESCRIBE `ports` 0.0006861686706543
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00019502639770508
(42) DESCRIBE `ports` 0.00066304206848145
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00017404556274414
(44) DESCRIBE `ports` 0.0032210350036621
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00020098686218262
(46) DESCRIBE `ports` 0.00068283081054688
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00018405914306641
(48) DESCRIBE `ports` 0.00066804885864258
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00019598007202148
(50) DESCRIBE `ports` 0.00068092346191406
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00017595291137695
(52) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62516') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0053970813751221
(53) DESCRIBE `avid_specials` 0.0006561279296875
(54) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62516 and class = 'Cruise') OR (item_id = 1135 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 26 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.00094103813171387
(55) DESCRIBE `cruiselines` 0.0009920597076416
(56) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.012853145599365
(57) DESCRIBE `orchid_image` 0.0010480880737305
(58) DESCRIBE `cruiselines` 0.0010209083557129
(59) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00019598007202148
(60) DESCRIBE `cruises` 0.0012631416320801
(61) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67864') 0.00021505355834961
(62) DESCRIBE `ships` 0.0012688636779785
(63) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 349))) 0.00025010108947754
(64) DESCRIBE `ships` 0.0013020038604736
(65) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '349') 0.00018620491027832
(66) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018310546875
(67) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001680850982666
(68) DESCRIBE `itineraries` 0.00067806243896484
(69) DESCRIBE `ports` 0.00069499015808105
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00021195411682129
(71) DESCRIBE `ports` 0.0006711483001709
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00019598007202148
(73) DESCRIBE `ports` 0.00068807601928711
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00018095970153809
(75) DESCRIBE `sailingdates` 0.00060892105102539
(76) DESCRIBE `ports` 0.00067400932312012
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00020980834960938
(78) DESCRIBE `ports` 0.00067806243896484
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00018095970153809
(80) DESCRIBE `ports` 0.00069189071655273
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00021195411682129
(82) DESCRIBE `ports` 0.00066089630126953
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00020217895507812
(84) DESCRIBE `ports` 0.00067520141601562
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5651))) 0.00020599365234375
(86) DESCRIBE `ports` 0.00066614151000977
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5651') 0.00017690658569336
(88) DESCRIBE `ports` 0.00066804885864258
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00021600723266602
(90) DESCRIBE `ports` 0.00087308883666992
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00018596649169922
(92) DESCRIBE `ports` 0.00068807601928711
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4475))) 0.00019693374633789
(94) DESCRIBE `ports` 0.00070786476135254
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4475') 0.00017619132995605
(96) DESCRIBE `ports` 0.00066614151000977
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00020384788513184
(98) DESCRIBE `ports` 0.00066590309143066
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00018000602722168
(100) DESCRIBE `ports` 0.00071406364440918
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1432))) 0.0001978874206543
(102) DESCRIBE `ports` 0.00066494941711426
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1432') 0.00017905235290527
(104) DESCRIBE `ports` 0.00066208839416504
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1433))) 0.00022101402282715
(106) DESCRIBE `ports` 0.0006709098815918
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1433') 0.00017905235290527
(108) DESCRIBE `ports` 0.00066089630126953
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5353))) 0.00020098686218262
(110) DESCRIBE `ports` 0.00066685676574707
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5353') 0.0001828670501709
(112) DESCRIBE `ports` 0.0021181106567383
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00020694732666016
(114) DESCRIBE `ports` 0.00068402290344238
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00017905235290527
(116) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '67864') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0054469108581543
(117) DESCRIBE `avid_specials` 0.00065898895263672
(118) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67864 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.00096511840820312
(119) DESCRIBE `cruiselines` 0.00094699859619141
(120) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00022006034851074
(121) DESCRIBE `orchid_image` 0.0007939338684082
(122) DESCRIBE `cruiselines` 0.00091218948364258
(123) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00018596649169922
(124) DESCRIBE `cruises` 0.0012660026550293
(125) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '15922') 0.00020599365234375
(126) DESCRIBE `ships` 0.001255989074707
(127) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 291))) 0.00023984909057617
(128) DESCRIBE `ships` 0.0012679100036621
(129) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '291') 0.00018501281738281
(130) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018095970153809
(131) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001678466796875
(132) DESCRIBE `itineraries` 0.00066208839416504
(133) DESCRIBE `ports` 0.0006868839263916
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00021696090698242
(135) DESCRIBE `ports` 0.00070595741271973
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00020003318786621
(137) DESCRIBE `ports` 0.00069499015808105
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00018477439880371
(139) DESCRIBE `sailingdates` 0.00059103965759277
(140) DESCRIBE `ports` 0.00072503089904785
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00021505355834961
(142) DESCRIBE `ports` 0.00066399574279785
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00018596649169922
(144) DESCRIBE `ports` 0.00065779685974121
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00020003318786621
(146) DESCRIBE `ports` 0.00070619583129883
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00018095970153809
(148) DESCRIBE `ports` 0.00072717666625977
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00023698806762695
(150) DESCRIBE `ports` 0.0006711483001709
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00019001960754395
(152) DESCRIBE `ports` 0.00066900253295898
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.0001990795135498
(154) DESCRIBE `ports` 0.00066709518432617
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00018000602722168
(156) DESCRIBE `ports` 0.00066590309143066
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00020909309387207
(158) DESCRIBE `ports` 0.00070095062255859
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00018596649169922
(160) DESCRIBE `ports` 0.00066614151000977
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 292))) 0.00020289421081543
(162) DESCRIBE `ports` 0.00070595741271973
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '292') 0.00017976760864258
(164) DESCRIBE `ports` 0.00069093704223633
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00020098686218262
(166) DESCRIBE `ports` 0.00066900253295898
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.0001828670501709
(168) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '15922') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0054459571838379
(169) DESCRIBE `avid_specials` 0.0010330677032471
(170) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 15922 and class = 'Cruise') OR (item_id = 291 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0012080669403076
(171) DESCRIBE `cruiselines` 0.00099301338195801
(172) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00024008750915527
(173) DESCRIBE `orchid_image` 0.00076484680175781
(174) DESCRIBE `cruiselines` 0.0012660026550293
(175) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00019001960754395
(176) DESCRIBE `cruises` 0.0014801025390625
(177) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '27131') 0.00020885467529297
(178) DESCRIBE `ships` 0.0013599395751953
(179) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 348))) 0.00024509429931641
(180) DESCRIBE `ships` 0.0012848377227783
(181) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '348') 0.00018405914306641
(182) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001828670501709
(183) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016880035400391
(184) DESCRIBE `itineraries` 0.00071287155151367
(185) DESCRIBE `ports` 0.00069308280944824
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.0002140998840332
(187) DESCRIBE `ports` 0.0008080005645752
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00023198127746582
(189) DESCRIBE `ports` 0.00094413757324219
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.00021815299987793
(191) DESCRIBE `sailingdates` 0.00069808959960938
(192) DESCRIBE `ports` 0.00078392028808594
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00024199485778809
(194) DESCRIBE `ports` 0.00069093704223633
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.00020599365234375
(196) DESCRIBE `ports` 0.00074481964111328
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00019693374633789
(198) DESCRIBE `ports` 0.00083684921264648
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00020313262939453
(200) DESCRIBE `ports` 0.00076103210449219
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00023508071899414
(202) DESCRIBE `ports` 0.00085806846618652
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.0001981258392334
(204) DESCRIBE `ports` 0.00067019462585449
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00021815299987793
(206) DESCRIBE `ports` 0.0007331371307373
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00022292137145996
(208) DESCRIBE `ports` 0.00084495544433594
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00020599365234375
(210) DESCRIBE `ports` 0.00076007843017578
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00018095970153809
(212) DESCRIBE `ports` 0.00067305564880371
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00019598007202148
(214) DESCRIBE `ports` 0.0007781982421875
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00018000602722168
(216) DESCRIBE `ports` 0.00076198577880859
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00021696090698242
(218) DESCRIBE `ports` 0.0008080005645752
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00018310546875
(220) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '27131') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.005842924118042
(221) DESCRIBE `avid_specials` 0.00090789794921875
(222) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 27131 and class = 'Cruise') OR (item_id = 348 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001105785369873
(223) DESCRIBE `cruiselines` 0.0010590553283691
(224) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00022315979003906
(225) DESCRIBE `orchid_image` 0.00093388557434082
(226) DESCRIBE `cruiselines` 0.0010781288146973
(227) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00026297569274902
(228) DESCRIBE `cruises` 0.0012950897216797
(229) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67875') 0.00023579597473145
(230) DESCRIBE `ships` 0.0013470649719238
(231) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 349))) 0.00026297569274902
(232) DESCRIBE `ships` 0.0013110637664795
(233) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '349') 0.00019001960754395
(234) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018310546875
(235) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017094612121582
(236) DESCRIBE `itineraries` 0.00067710876464844
(237) DESCRIBE `ports` 0.00069713592529297
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00021004676818848
(239) DESCRIBE `ports` 0.0006868839263916
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00019502639770508
(241) DESCRIBE `ports` 0.00066399574279785
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00019001960754395
(243) DESCRIBE `sailingdates` 0.00062990188598633
(244) DESCRIBE `ports` 0.00067496299743652
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00020694732666016
(246) DESCRIBE `ports` 0.00067019462585449
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00023698806762695
(248) DESCRIBE `ports` 0.00072097778320312
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3698))) 0.00021004676818848
(250) DESCRIBE `ports` 0.00073909759521484
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3698') 0.00018191337585449
(252) DESCRIBE `ports` 0.00070786476135254
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5651))) 0.00019693374633789
(254) DESCRIBE `ports` 0.00071597099304199
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5651') 0.00017881393432617
(256) DESCRIBE `ports` 0.00066995620727539
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 833))) 0.00021505355834961
(258) DESCRIBE `ports` 0.00066995620727539
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '833') 0.00017881393432617
(260) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '67875') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0059940814971924
(261) DESCRIBE `avid_specials` 0.000823974609375
(262) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67875 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.0011599063873291
(263) DESCRIBE `cruiselines` 0.0011179447174072
(264) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00022697448730469
(265) DESCRIBE `orchid_image` 0.00083804130554199
(266) DESCRIBE `cruiselines` 0.0012471675872803
(267) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00024795532226562
(268) DESCRIBE `cruises` 0.0016050338745117
(269) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66480') 0.00028705596923828
(270) DESCRIBE `ships` 0.0014960765838623
(271) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 406))) 0.00028014183044434
(272) DESCRIBE `ships` 0.001478910446167
(273) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '406') 0.00021886825561523
(274) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018000602722168
(275) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001671314239502
(276) DESCRIBE `itineraries` 0.00093293190002441
(277) DESCRIBE `ports` 0.00070500373840332
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00021696090698242
(279) DESCRIBE `ports` 0.0006718635559082
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00019502639770508
(281) DESCRIBE `ports` 0.00066304206848145
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00017905235290527
(283) DESCRIBE `sailingdates` 0.0007169246673584
(284) DESCRIBE `ports` 0.0006859302520752
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00020599365234375
(286) DESCRIBE `ports` 0.00066900253295898
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00018215179443359
(288) DESCRIBE `ports` 0.00073099136352539
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 574))) 0.0001988410949707
(290) DESCRIBE `ports` 0.00066781044006348
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '574') 0.00017881393432617
(292) DESCRIBE `ports` 0.00067996978759766
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3149))) 0.00019693374633789
(294) DESCRIBE `ports` 0.00068402290344238
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3149') 0.00017881393432617
(296) DESCRIBE `ports` 0.00066113471984863
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 223))) 0.0001990795135498
(298) DESCRIBE `ports` 0.00068497657775879
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '223') 0.00020194053649902
(300) DESCRIBE `ports` 0.00066399574279785
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 226))) 0.00020384788513184
(302) DESCRIBE `ports` 0.000823974609375
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '226') 0.00018596649169922
(304) DESCRIBE `ports` 0.00069403648376465
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 221))) 0.00020313262939453
(306) DESCRIBE `ports` 0.00071978569030762
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '221') 0.00017905235290527
(308) DESCRIBE `ports` 0.00089597702026367
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 224))) 0.00020599365234375
(310) DESCRIBE `ports` 0.00067710876464844
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '224') 0.00018215179443359
(312) DESCRIBE `ports` 0.00066804885864258
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 227))) 0.00020003318786621
(314) DESCRIBE `ports` 0.00066804885864258
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '227') 0.00017809867858887
(316) DESCRIBE `ports` 0.00073790550231934
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 800))) 0.00020098686218262
(318) DESCRIBE `ports` 0.0006721019744873
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '800') 0.00018095970153809
(320) DESCRIBE `ports` 0.00066709518432617
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 647))) 0.00024580955505371
(322) DESCRIBE `ports` 0.00067710876464844
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '647') 0.00018596649169922
(324) DESCRIBE `ports` 0.00066709518432617
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.0001988410949707
(326) DESCRIBE `ports` 0.00069689750671387
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00018191337585449
(328) DESCRIBE `ports` 0.0006721019744873
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00020313262939453
(330) DESCRIBE `ports` 0.00066995620727539
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00018215179443359
(332) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66480') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0054728984832764
(333) DESCRIBE `avid_specials` 0.00083398818969727
(334) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66480 and class = 'Cruise') OR (item_id = 406 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 25 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.0010130405426025
(335) DESCRIBE `cruiselines` 0.0010149478912354
(336) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00023198127746582
(337) DESCRIBE `orchid_image` 0.00080704689025879
(338) DESCRIBE `cruiselines` 0.00096392631530762
(339) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00020003318786621
(340) DESCRIBE `cruises` 0.0012869834899902
(341) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66526') 0.0002448558807373
(342) DESCRIBE `ships` 0.0012960433959961
(343) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 542))) 0.00026988983154297
(344) DESCRIBE `ships` 0.0016388893127441
(345) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '542') 0.00022387504577637
(346) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018000602722168
(347) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016999244689941
(348) DESCRIBE `itineraries` 0.00076198577880859
(349) DESCRIBE `ports` 0.00097298622131348
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00034117698669434
(351) DESCRIBE `ports` 0.00078392028808594
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020599365234375
(353) DESCRIBE `ports` 0.0006859302520752
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00020003318786621
(355) DESCRIBE `sailingdates` 0.00064301490783691
(356) DESCRIBE `ports` 0.00070595741271973
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00021910667419434
(358) DESCRIBE `ports` 0.00069999694824219
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00019502639770508
(360) DESCRIBE `ports` 0.00067281723022461
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00019598007202148
(362) DESCRIBE `ports` 0.00070381164550781
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00018715858459473
(364) DESCRIBE `ports` 0.00069689750671387
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00019979476928711
(366) DESCRIBE `ports` 0.00067806243896484
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00017786026000977
(368) DESCRIBE `ports` 0.00067901611328125
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00019717216491699
(370) DESCRIBE `ports` 0.00070905685424805
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00018405914306641
(372) DESCRIBE `ports` 0.00067281723022461
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00021791458129883
(374) DESCRIBE `ports` 0.0007331371307373
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00018906593322754
(376) DESCRIBE `ports` 0.00079607963562012
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00023007392883301
(378) DESCRIBE `ports` 0.00069403648376465
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00019407272338867
(380) DESCRIBE `ports` 0.00072097778320312
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 704))) 0.0001990795135498
(382) DESCRIBE `ports` 0.00066709518432617
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '704') 0.00019097328186035
(384) DESCRIBE `ports` 0.00068116188049316
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00020098686218262
(386) DESCRIBE `ports` 0.00066399574279785
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00019192695617676
(388) DESCRIBE `ports` 0.00066494941711426
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.0002589225769043
(390) DESCRIBE `ports` 0.00069618225097656
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00019311904907227
(392) DESCRIBE `ports` 0.0006718635559082
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3719))) 0.00020194053649902
(394) DESCRIBE `ports` 0.0006709098815918
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3719') 0.00018191337585449
(396) DESCRIBE `ports` 0.00093698501586914
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00021600723266602
(398) DESCRIBE `ports` 0.0007481575012207
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00023198127746582
(400) DESCRIBE `ports` 0.00066804885864258
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00024104118347168
(402) DESCRIBE `ports` 0.0006721019744873
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00017690658569336
(404) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66526') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0057468414306641
(405) DESCRIBE `avid_specials` 0.00094413757324219
(406) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66526 and class = 'Cruise') OR (item_id = 542 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.0010969638824463
(407) DESCRIBE `cruiselines` 0.0011520385742188
(408) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00027990341186523
(409) DESCRIBE `orchid_image` 0.00087118148803711
(410) DESCRIBE `cruiselines` 0.001230001449585
(411) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00023818016052246
(412) DESCRIBE `cruises` 0.0012788772583008
(413) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70581') 0.00021004676818848
(414) DESCRIBE `ships` 0.001255989074707
(415) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 434))) 0.00024199485778809
(416) DESCRIBE `ships` 0.0013360977172852
(417) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '434') 0.00017690658569336
(418) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017809867858887
(419) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016593933105469
(420) DESCRIBE `itineraries` 0.00066304206848145
(421) DESCRIBE `ports` 0.00069689750671387
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00021696090698242
(423) DESCRIBE `ports` 0.00066781044006348
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00019407272338867
(425) DESCRIBE `ports` 0.00071501731872559
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00018191337585449
(427) DESCRIBE `sailingdates` 0.0005950927734375
(428) DESCRIBE `ports` 0.00066995620727539
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00021481513977051
(430) DESCRIBE `ports` 0.00068211555480957
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00017905235290527
(432) DESCRIBE `ports` 0.00082898139953613
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 839))) 0.0001990795135498
(434) DESCRIBE `ports` 0.00068879127502441
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '839') 0.00017809867858887
(436) DESCRIBE `ports` 0.00067305564880371
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00021696090698242
(438) DESCRIBE `ports` 0.00070309638977051
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00017905235290527
(440) DESCRIBE `ports` 0.00071501731872559
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 296))) 0.00019502639770508
(442) DESCRIBE `ports` 0.0006871223449707
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '296') 0.00017499923706055
(444) DESCRIBE `ports` 0.00071215629577637
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00019693374633789
(446) DESCRIBE `ports` 0.00069499015808105
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00017809867858887
(448) DESCRIBE `ports` 0.00066900253295898
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.0001988410949707
(450) DESCRIBE `ports` 0.0007178783416748
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00019192695617676
(452) DESCRIBE `ports` 0.00071001052856445
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00019979476928711
(454) DESCRIBE `ports` 0.00071287155151367
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00017809867858887
(456) DESCRIBE `ports` 0.0006868839263916
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00019717216491699
(458) DESCRIBE `ports` 0.00068020820617676
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00017690658569336
(460) DESCRIBE `ports` 0.00066900253295898
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00021910667419434
(462) DESCRIBE `ports` 0.00071191787719727
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00019001960754395
(464) DESCRIBE `ports` 0.00070285797119141
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 133))) 0.00021696090698242
(466) DESCRIBE `ports` 0.00068306922912598
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '133') 0.00018906593322754
(468) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '70581') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0055701732635498
(469) DESCRIBE `avid_specials` 0.00069999694824219
(470) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70581 and class = 'Cruise') OR (item_id = 434 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.00098204612731934
(471) DESCRIBE `cruiselines` 0.0011100769042969
(472) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00022387504577637
(473) DESCRIBE `orchid_image` 0.00077414512634277
(474) DESCRIBE `cruiselines` 0.0010168552398682
(475) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00020694732666016
(476) DESCRIBE `cruises` 0.0012931823730469
(477) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66663') 0.00022697448730469
(478) DESCRIBE `ships` 0.001384973526001
(479) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1135))) 0.00027203559875488
(480) DESCRIBE `ships` 0.0013229846954346
(481) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1135') 0.00018310546875
(482) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017595291137695
(483) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016498565673828
(484) DESCRIBE `itineraries` 0.00068306922912598
(485) DESCRIBE `ports` 0.00069403648376465
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00026392936706543
(487) DESCRIBE `ports` 0.00074887275695801
(488) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00023984909057617
(489) DESCRIBE `ports` 0.00070810317993164
(490) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00019097328186035
(491) DESCRIBE `sailingdates` 0.0006251335144043
(492) DESCRIBE `ports` 0.00070810317993164
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00020408630371094
(494) DESCRIBE `ports` 0.0006721019744873
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00022506713867188
(496) DESCRIBE `ports` 0.00083518028259277
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00019717216491699
(498) DESCRIBE `ports` 0.0006859302520752
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00017905235290527
(500) DESCRIBE `ports` 0.00073599815368652
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.0001988410949707
(502) DESCRIBE `ports` 0.00066900253295898
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.0001828670501709
(504) DESCRIBE `ports` 0.00069880485534668
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00021004676818848
(506) DESCRIBE `ports` 0.00066399574279785
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00020813941955566
(508) DESCRIBE `ports` 0.00066804885864258
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00021505355834961
(510) DESCRIBE `ports` 0.00066304206848145
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00018000602722168
(512) DESCRIBE `ports` 0.00066089630126953
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.0001988410949707
(514) DESCRIBE `ports` 0.00094985961914062
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00023818016052246
(516) DESCRIBE `ports` 0.00067496299743652
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00020194053649902
(518) DESCRIBE `ports` 0.00066995620727539
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00018000602722168
(520) DESCRIBE `ports` 0.00067496299743652
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00023102760314941
(522) DESCRIBE `ports` 0.00087094306945801
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00023698806762695
(524) DESCRIBE `ports` 0.0010161399841309
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00021100044250488
(526) DESCRIBE `ports` 0.0006721019744873
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00018787384033203
(528) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66663') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.0055599212646484
(529) DESCRIBE `avid_specials` 0.00082206726074219
(530) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66663 and class = 'Cruise') OR (item_id = 1135 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 26 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.0009760856628418
(531) DESCRIBE `cruiselines` 0.001046895980835
(532) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00022983551025391
(533) DESCRIBE `orchid_image` 0.00075507164001465
(534) DESCRIBE `cruiselines` 0.00091791152954102
(535) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00019121170043945
(536) DESCRIBE `cruises` 0.0012500286102295
(537) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '54648') 0.00047397613525391
(538) DESCRIBE `ships` 0.0016191005706787
(539) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 290))) 0.00026202201843262
(540) DESCRIBE `ships` 0.0012650489807129
(541) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '290') 0.00018811225891113
(542) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018000602722168
(543) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016689300537109
(544) DESCRIBE `itineraries` 0.00066018104553223
(545) DESCRIBE `ports` 0.00081992149353027
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00022101402282715
(547) DESCRIBE `ports` 0.00067305564880371
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00025200843811035
(549) DESCRIBE `ports` 0.00088214874267578
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00031304359436035
(551) DESCRIBE `sailingdates` 0.0008089542388916
(552) DESCRIBE `ports` 0.0012290477752686
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.0004417896270752
(554) DESCRIBE `ports` 0.00085997581481934
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00018501281738281
(556) DESCRIBE `ports` 0.00066399574279785
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00020313262939453
(558) DESCRIBE `ports` 0.0006558895111084
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00021600723266602
(560) DESCRIBE `ports` 0.00071501731872559
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00019407272338867
(562) DESCRIBE `ports` 0.00065493583679199
(563) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00017499923706055
(564) DESCRIBE `ports` 0.00065422058105469
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00020813941955566
(566) DESCRIBE `ports` 0.00065493583679199
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00017404556274414
(568) DESCRIBE `ports` 0.00065493583679199
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00021004676818848
(570) DESCRIBE `ports` 0.0006558895111084
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00018501281738281
(572) DESCRIBE `ports` 0.00065398216247559
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 292))) 0.00019407272338867
(574) DESCRIBE `ports` 0.00070595741271973
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '292') 0.00017189979553223
(576) DESCRIBE `ports` 0.00065708160400391
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00020599365234375
(578) DESCRIBE `ports` 0.00066494941711426
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.00017285346984863
(580) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '54648') AND (sailingdate >= '2017-10-25') AND (sailingdate <= '2019-03-21') 0.005587100982666
(581) DESCRIBE `avid_specials` 0.00083804130554199
(582) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 54648 and class = 'Cruise') OR (item_id = 290 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00099706649780273
(583) DESCRIBE `cruiselines` 0.00099706649780273
(584) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00023818016052246
(585) DESCRIBE `orchid_image` 0.00075888633728027
(586) DESCRIBE `cruiselines` 0.00091791152954102
(587) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00018692016601562
(588) DESCRIBE `ships` 0.0013349056243896
(589) SELECT `ships`.* FROM `ships` WHERE (id IN ('349', '1135', '542', '434', '406', '1021', '678', '253', '348', '290', '580', '451', '105', '98', '291', '341', '1409')) ORDER BY FIND_IN_SET(id, '349,1135,542,434,406,1021,678,253,348,290,580,451,105,98,291,341,1409') 0.00075006484985352
(590) DESCRIBE `cruisetypes` 0.00058102607727051
(591) DESCRIBE `destinations` 0.00088191032409668
(592) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '35', '2', '43', '22', '48', '53', '8', '26', '34', '40', '29', '37', '21', '11', '38', '25', '28', '30', '49')) ORDER BY FIND_IN_SET(id, '12,35,2,43,22,48,53,8,26,34,40,29,37,21,11,38,25,28,30,49') 0.00074601173400879
(593) DESCRIBE `cruiselines` 0.0010600090026855
(594) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00028014183044434
(595) DESCRIBE `cruiselines` 0.00095200538635254
(596) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00026512145996094