or, enquire about your chosen options

  1. Holland America’s View and Veranda promotion is back!!
  2. The Big Laugh Comedy Festival Cruise
  3. Catch up on Cruising: Latest news in bite size
  4. Meet the Cruise Factor Team – Don
  5. Catch up on Cruising: Latest news in bite size

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

Total elapsed time: 0.44569420814514

# Query Time
(1) connect 0.00060105323791504
(2) DESCRIBE `cruises` 0.0024421215057373
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (47487, 58848, 60175, 60176, 58849, 68492, 58850, 68493, 58851, 60178)) ORDER BY FIND_IN_SET(id, '47487,58848,60175,60176,58849,68492,58850,68493,58851,60178') 0.0015249252319336
(4) DESCRIBE `cruises` 0.0023820400238037
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '47487') 0.00040507316589355
(6) DESCRIBE `ships` 0.0016908645629883
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.0002748966217041
(8) DESCRIBE `ships` 0.0016422271728516
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00021004676818848
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018501281738281
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018811225891113
(12) DESCRIBE `itineraries` 0.0010349750518799
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '47487') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00069904327392578
(14) DESCRIBE `ports` 0.0012619495391846
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00028610229492188
(16) DESCRIBE `ports` 0.00076794624328613
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.0002131462097168
(18) DESCRIBE `ports` 0.00094294548034668
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00020694732666016
(20) DESCRIBE `sailingdates` 0.00070500373840332
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '47487') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0007469654083252
(22) DESCRIBE `ports` 0.0015699863433838
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00034999847412109
(24) DESCRIBE `ports` 0.0010991096496582
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00028491020202637
(26) DESCRIBE `ports` 0.00099396705627441
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1878))) 0.00037717819213867
(28) DESCRIBE `ports` 0.0012040138244629
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1878') 0.00029897689819336
(30) DESCRIBE `ports` 0.001068115234375
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00034499168395996
(32) DESCRIBE `ports` 0.001115083694458
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00027608871459961
(34) DESCRIBE `ports` 0.0010178089141846
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00028300285339355
(36) DESCRIBE `ports` 0.00098609924316406
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00026702880859375
(38) DESCRIBE `ports` 0.0010640621185303
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.00031399726867676
(40) DESCRIBE `ports` 0.0011849403381348
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.0003049373626709
(42) DESCRIBE `ports` 0.0010690689086914
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00030303001403809
(44) DESCRIBE `ports` 0.0010430812835693
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.0002591609954834
(46) DESCRIBE `ports` 0.00098991394042969
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00029516220092773
(48) DESCRIBE `ports` 0.0010888576507568
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00027298927307129
(50) DESCRIBE `ports` 0.0010490417480469
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00030899047851562
(52) DESCRIBE `ports` 0.0010709762573242
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00025200843811035
(54) DESCRIBE `ports` 0.0010290145874023
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00027608871459961
(56) DESCRIBE `ports` 0.00099587440490723
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00026082992553711
(58) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '47487') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.010164022445679
(59) DESCRIBE `avid_specials` 0.0012598037719727
(60) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 47487 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 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.0011379718780518
(61) DESCRIBE `cruiselines` 0.0010960102081299
(62) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00030899047851562
(63) DESCRIBE `orchid_image` 0.00084495544433594
(64) DESCRIBE `cruiselines` 0.0012519359588623
(65) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00028395652770996
(66) DESCRIBE `cruises` 0.00173020362854
(67) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58848') 0.0003960132598877
(68) DESCRIBE `ships` 0.0020480155944824
(69) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00036001205444336
(70) DESCRIBE `ships` 0.0018918514251709
(71) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.0002598762512207
(72) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00021195411682129
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00020003318786621
(74) DESCRIBE `itineraries` 0.00092387199401855
(75) DESCRIBE `ports` 0.0011370182037354
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00030899047851562
(77) DESCRIBE `ports` 0.0010709762573242
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00027108192443848
(79) DESCRIBE `ports` 0.0010080337524414
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00024199485778809
(81) DESCRIBE `sailingdates` 0.00086498260498047
(82) DESCRIBE `ports` 0.0010621547698975
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 482))) 0.00028705596923828
(84) DESCRIBE `ports` 0.0010528564453125
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '482') 0.00028610229492188
(86) DESCRIBE `ports` 0.00098180770874023
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00026392936706543
(88) DESCRIBE `ports` 0.00094199180603027
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.0002288818359375
(90) DESCRIBE `ports` 0.0009160041809082
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 427))) 0.00027179718017578
(92) DESCRIBE `ports` 0.00099587440490723
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '427') 0.00030994415283203
(94) DESCRIBE `ports` 0.001147985458374
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 609))) 0.00031304359436035
(96) DESCRIBE `ports` 0.00095486640930176
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '609') 0.00040984153747559
(98) DESCRIBE `ports` 0.00089216232299805
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 429))) 0.00022101402282715
(100) DESCRIBE `ports` 0.00073790550231934
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '429') 0.00021100044250488
(102) DESCRIBE `ports` 0.00068092346191406
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 428))) 0.00024294853210449
(104) DESCRIBE `ports` 0.00073599815368652
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '428') 0.00019001960754395
(106) DESCRIBE `ports` 0.00069594383239746
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 711))) 0.00023293495178223
(108) DESCRIBE `ports` 0.00077986717224121
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '711') 0.00019097328186035
(110) DESCRIBE `ports` 0.00072097778320312
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 712))) 0.00027704238891602
(112) DESCRIBE `ports` 0.00095105171203613
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '712') 0.00025081634521484
(114) DESCRIBE `ports` 0.0009009838104248
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 204))) 0.00028800964355469
(116) DESCRIBE `ports` 0.00093793869018555
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '204') 0.0002138614654541
(118) DESCRIBE `ports` 0.00071191787719727
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 205))) 0.00021100044250488
(120) DESCRIBE `ports` 0.00088405609130859
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '205') 0.00019693374633789
(122) DESCRIBE `ports` 0.00068402290344238
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 533))) 0.00024294853210449
(124) DESCRIBE `ports` 0.00083708763122559
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '533') 0.00020813941955566
(126) DESCRIBE `ports` 0.00097513198852539
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00023508071899414
(128) DESCRIBE `ports` 0.00067400932312012
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00018501281738281
(130) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '58848') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0059170722961426
(131) DESCRIBE `avid_specials` 0.00093579292297363
(132) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 58848 and class = 'Cruise') OR (item_id = 616 AND class = 'Ship') OR (item_id = 151 AND class = 'CruiseLine') OR (item_id = 45 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.0011258125305176
(133) DESCRIBE `cruiselines` 0.0010550022125244
(134) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00023698806762695
(135) DESCRIBE `orchid_image` 0.00094890594482422
(136) DESCRIBE `cruiselines` 0.0010149478912354
(137) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00020003318786621
(138) DESCRIBE `cruises` 0.0016100406646729
(139) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60175') 0.00025105476379395
(140) DESCRIBE `ships` 0.0028378963470459
(141) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00031709671020508
(142) DESCRIBE `ships` 0.0016191005706787
(143) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00024104118347168
(144) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001828670501709
(145) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0001680850982666
(146) DESCRIBE `itineraries` 0.00073909759521484
(147) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '60175') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00077486038208008
(148) DESCRIBE `ports` 0.00084495544433594
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00023698806762695
(150) DESCRIBE `ports` 0.00073599815368652
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00019717216491699
(152) DESCRIBE `ports` 0.00068402290344238
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00022506713867188
(154) DESCRIBE `sailingdates` 0.00088810920715332
(155) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '60175') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0005800724029541
(156) DESCRIBE `ports` 0.0010089874267578
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00023794174194336
(158) DESCRIBE `ports` 0.00071501731872559
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00023984909057617
(160) DESCRIBE `ports` 0.00091886520385742
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 698))) 0.00026893615722656
(162) DESCRIBE `ports` 0.00068998336791992
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '698') 0.00020289421081543
(164) DESCRIBE `ports` 0.00097012519836426
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00026297569274902
(166) DESCRIBE `ports` 0.00096988677978516
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00029587745666504
(168) DESCRIBE `ports` 0.00096392631530762
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00020909309387207
(170) DESCRIBE `ports` 0.00069093704223633
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00018000602722168
(172) DESCRIBE `ports` 0.00070500373840332
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 579))) 0.00019717216491699
(174) DESCRIBE `ports` 0.00068283081054688
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '579') 0.00018978118896484
(176) DESCRIBE `ports` 0.00066685676574707
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00020813941955566
(178) DESCRIBE `ports` 0.000762939453125
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00025105476379395
(180) DESCRIBE `ports` 0.0010621547698975
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00031495094299316
(182) DESCRIBE `ports` 0.0010349750518799
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.0002739429473877
(184) DESCRIBE `ports` 0.0011091232299805
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00033783912658691
(186) DESCRIBE `ports` 0.0011169910430908
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00029683113098145
(188) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '60175') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0099179744720459
(189) DESCRIBE `avid_specials` 0.00093793869018555
(190) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60175 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 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.0010001659393311
(191) DESCRIBE `cruiselines` 0.001046895980835
(192) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00028300285339355
(193) DESCRIBE `orchid_image` 0.001032829284668
(194) DESCRIBE `cruiselines` 0.0015668869018555
(195) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00032997131347656
(196) DESCRIBE `cruises` 0.0020191669464111
(197) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60176') 0.00030779838562012
(198) DESCRIBE `ships` 0.0018332004547119
(199) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00034403800964355
(200) DESCRIBE `ships` 0.0018661022186279
(201) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00030899047851562
(202) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0002291202545166
(203) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00020599365234375
(204) DESCRIBE `itineraries` 0.0010290145874023
(205) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '60176') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00050711631774902
(206) DESCRIBE `ports` 0.0011470317840576
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00033807754516602
(208) DESCRIBE `ports` 0.0010879039764404
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00043201446533203
(210) DESCRIBE `ports` 0.000885009765625
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00025796890258789
(212) DESCRIBE `sailingdates` 0.00085616111755371
(213) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '60176') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00046801567077637
(214) DESCRIBE `ports` 0.0010039806365967
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00025105476379395
(216) DESCRIBE `ports` 0.00070595741271973
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018787384033203
(218) DESCRIBE `ports` 0.00067305564880371
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1252))) 0.00020313262939453
(220) DESCRIBE `ports` 0.00078296661376953
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1252') 0.00019693374633789
(222) DESCRIBE `ports` 0.00073719024658203
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00020503997802734
(224) DESCRIBE `ports` 0.00070714950561523
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00018906593322754
(226) DESCRIBE `ports` 0.00066709518432617
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00019693374633789
(228) DESCRIBE `ports` 0.0006711483001709
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00019097328186035
(230) DESCRIBE `ports` 0.00067901611328125
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1213))) 0.00020408630371094
(232) DESCRIBE `ports` 0.0007929801940918
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1213') 0.00018692016601562
(234) DESCRIBE `ports` 0.0007331371307373
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00021505355834961
(236) DESCRIBE `ports` 0.00077199935913086
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00018095970153809
(238) DESCRIBE `ports` 0.00069093704223633
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.0001988410949707
(240) DESCRIBE `ports` 0.00075721740722656
(241) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00019407272338867
(242) DESCRIBE `ports` 0.00071907043457031
(243) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00020384788513184
(244) DESCRIBE `ports` 0.00067305564880371
(245) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00017786026000977
(246) DESCRIBE `ports` 0.00066399574279785
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020790100097656
(248) DESCRIBE `ports` 0.00066494941711426
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00017905235290527
(250) DESCRIBE `ports` 0.00067400932312012
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00021100044250488
(252) DESCRIBE `ports` 0.00069284439086914
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00025796890258789
(254) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '60176') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0060188770294189
(255) DESCRIBE `avid_specials` 0.00085687637329102
(256) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60176 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 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.0011918544769287
(257) DESCRIBE `cruiselines` 0.0010559558868408
(258) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00024008750915527
(259) DESCRIBE `orchid_image` 0.00081110000610352
(260) DESCRIBE `cruiselines` 0.0013141632080078
(261) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00024700164794922
(262) DESCRIBE `cruises` 0.0016069412231445
(263) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58849') 0.00026893615722656
(264) DESCRIBE `ships` 0.0017471313476562
(265) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00034809112548828
(266) DESCRIBE `ships` 0.0015010833740234
(267) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.00020599365234375
(268) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017881393432617
(269) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016593933105469
(270) DESCRIBE `itineraries` 0.00081706047058105
(271) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '58849') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0005791187286377
(272) DESCRIBE `ports` 0.00080704689025879
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0002288818359375
(274) DESCRIBE `ports` 0.00093889236450195
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00025796890258789
(276) DESCRIBE `ports` 0.00091695785522461
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00024104118347168
(278) DESCRIBE `sailingdates` 0.00080680847167969
(279) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '58849') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00059700012207031
(280) DESCRIBE `ports` 0.0012519359588623
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00030899047851562
(282) DESCRIBE `ports` 0.00069212913513184
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00019598007202148
(284) DESCRIBE `ports` 0.00071310997009277
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00021100044250488
(286) DESCRIBE `ports` 0.0006868839263916
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00017714500427246
(288) DESCRIBE `ports` 0.00073695182800293
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.00019288063049316
(290) DESCRIBE `ports` 0.0009307861328125
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.00017714500427246
(292) DESCRIBE `ports` 0.00069212913513184
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2501))) 0.00023198127746582
(294) DESCRIBE `ports` 0.00092697143554688
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2501') 0.0002439022064209
(296) DESCRIBE `ports` 0.00094795227050781
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00026202201843262
(298) DESCRIBE `ports` 0.00092291831970215
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.0001981258392334
(300) DESCRIBE `ports` 0.00079798698425293
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00026202201843262
(302) DESCRIBE `ports` 0.00086402893066406
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00017905235290527
(304) DESCRIBE `ports` 0.00068902969360352
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1252))) 0.00022506713867188
(306) DESCRIBE `ports` 0.00069904327392578
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1252') 0.00020599365234375
(308) DESCRIBE `ports` 0.00066494941711426
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00019598007202148
(310) DESCRIBE `ports` 0.00087690353393555
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018191337585449
(312) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '58849') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0092859268188477
(313) DESCRIBE `avid_specials` 0.00094509124755859
(314) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 58849 and class = 'Cruise') OR (item_id = 616 AND class = 'Ship') OR (item_id = 151 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.0010311603546143
(315) DESCRIBE `cruiselines` 0.0011169910430908
(316) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00023603439331055
(317) DESCRIBE `orchid_image` 0.0021181106567383
(318) DESCRIBE `cruiselines` 0.0010321140289307
(319) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00024700164794922
(320) DESCRIBE `cruises` 0.001446008682251
(321) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68492') 0.00022602081298828
(322) DESCRIBE `ships` 0.0012781620025635
(323) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.0002589225769043
(324) DESCRIBE `ships` 0.0018110275268555
(325) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00022697448730469
(326) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00023794174194336
(327) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017094612121582
(328) DESCRIBE `itineraries` 0.00069808959960938
(329) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68492') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00092482566833496
(330) DESCRIBE `ports` 0.0008540153503418
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00028204917907715
(332) DESCRIBE `ports` 0.0010101795196533
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00026082992553711
(334) DESCRIBE `ports` 0.00069689750671387
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00019001960754395
(336) DESCRIBE `sailingdates` 0.00063800811767578
(337) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68492') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0005638599395752
(338) DESCRIBE `ports` 0.00098395347595215
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0002448558807373
(340) DESCRIBE `ports` 0.00079202651977539
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018310546875
(342) DESCRIBE `ports` 0.00089693069458008
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00030112266540527
(344) DESCRIBE `ports` 0.00099992752075195
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00024604797363281
(346) DESCRIBE `ports` 0.0010011196136475
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00028204917907715
(348) DESCRIBE `ports` 0.00068187713623047
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00018000602722168
(350) DESCRIBE `ports` 0.002051830291748
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00024914741516113
(352) DESCRIBE `ports` 0.0007328987121582
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.0001981258392334
(354) DESCRIBE `ports` 0.00074219703674316
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1709))) 0.00021910667419434
(356) DESCRIBE `ports` 0.00094389915466309
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1709') 0.00025296211242676
(358) DESCRIBE `ports` 0.001021146774292
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00028181076049805
(360) DESCRIBE `ports` 0.001032829284668
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00025820732116699
(362) DESCRIBE `ports` 0.00072216987609863
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00021004676818848
(364) DESCRIBE `ports` 0.0006709098815918
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00020718574523926
(366) DESCRIBE `ports` 0.00070500373840332
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00026082992553711
(368) DESCRIBE `ports` 0.00096797943115234
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.00025486946105957
(370) DESCRIBE `ports` 0.0009000301361084
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.0002598762512207
(372) DESCRIBE `ports` 0.00068187713623047
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.00023698806762695
(374) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68492') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0057480335235596
(375) DESCRIBE `avid_specials` 0.00087809562683105
(376) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68492 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 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.0010309219360352
(377) DESCRIBE `cruiselines` 0.0010499954223633
(378) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00023221969604492
(379) DESCRIBE `orchid_image` 0.00078392028808594
(380) DESCRIBE `cruiselines` 0.0011610984802246
(381) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.0001981258392334
(382) DESCRIBE `cruises` 0.0013470649719238
(383) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58850') 0.00022411346435547
(384) DESCRIBE `ships` 0.0012929439544678
(385) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.00025582313537598
(386) DESCRIBE `ships` 0.0012810230255127
(387) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.00025200843811035
(388) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018095970153809
(389) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016689300537109
(390) DESCRIBE `itineraries` 0.00072097778320312
(391) DESCRIBE `ports` 0.00095605850219727
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00022792816162109
(393) DESCRIBE `ports` 0.00069499015808105
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020885467529297
(395) DESCRIBE `ports` 0.00068187713623047
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00019216537475586
(397) DESCRIBE `sailingdates` 0.00085091590881348
(398) DESCRIBE `ports` 0.0010321140289307
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00031304359436035
(400) DESCRIBE `ports` 0.00097107887268066
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00022983551025391
(402) DESCRIBE `ports` 0.00087618827819824
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00026512145996094
(404) DESCRIBE `ports` 0.00087094306945801
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00021791458129883
(406) DESCRIBE `ports` 0.00086212158203125
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00052595138549805
(408) DESCRIBE `ports` 0.0011589527130127
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00026297569274902
(410) DESCRIBE `ports` 0.00099992752075195
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00028800964355469
(412) DESCRIBE `ports` 0.0010120868682861
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00024890899658203
(414) DESCRIBE `ports` 0.00091409683227539
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00020408630371094
(416) DESCRIBE `ports` 0.00076103210449219
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00022482872009277
(418) DESCRIBE `ports` 0.00094294548034668
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00021505355834961
(420) DESCRIBE `ports` 0.00068998336791992
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00018692016601562
(422) DESCRIBE `ports` 0.00069594383239746
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00020194053649902
(424) DESCRIBE `ports` 0.00067996978759766
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00020599365234375
(426) DESCRIBE `ports` 0.00093317031860352
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00022315979003906
(428) DESCRIBE `ports` 0.00071310997009277
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018787384033203
(430) DESCRIBE `ports` 0.00067305564880371
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020098686218262
(432) DESCRIBE `ports` 0.00066995620727539
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00022506713867188
(434) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '58850') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0052921772003174
(435) DESCRIBE `avid_specials` 0.00071382522583008
(436) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 58850 and class = 'Cruise') OR (item_id = 616 AND class = 'Ship') OR (item_id = 151 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.0010290145874023
(437) DESCRIBE `cruiselines` 0.0010099411010742
(438) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.0002138614654541
(439) DESCRIBE `orchid_image` 0.00085186958312988
(440) DESCRIBE `cruiselines` 0.00090599060058594
(441) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00020408630371094
(442) DESCRIBE `cruises` 0.0012679100036621
(443) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68493') 0.00019621849060059
(444) DESCRIBE `ships` 0.0012710094451904
(445) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00024199485778809
(446) DESCRIBE `ships` 0.0012569427490234
(447) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00017404556274414
(448) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018310546875
(449) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016593933105469
(450) DESCRIBE `itineraries` 0.00071406364440918
(451) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '68493') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00033092498779297
(452) DESCRIBE `ports` 0.0007319450378418
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00020408630371094
(454) DESCRIBE `ports` 0.00070905685424805
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00019192695617676
(456) DESCRIBE `ports` 0.00066804885864258
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.00017809867858887
(458) DESCRIBE `sailingdates` 0.00063800811767578
(459) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '68493') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00035595893859863
(460) DESCRIBE `ports` 0.00072693824768066
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00022196769714355
(462) DESCRIBE `ports` 0.00067496299743652
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.00019097328186035
(464) DESCRIBE `ports` 0.00070285797119141
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 579))) 0.00020098686218262
(466) DESCRIBE `ports` 0.00080394744873047
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '579') 0.00017809867858887
(468) DESCRIBE `ports` 0.00067305564880371
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1709))) 0.00020003318786621
(470) DESCRIBE `ports` 0.00066995620727539
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1709') 0.00018692016601562
(472) DESCRIBE `ports` 0.00068998336791992
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00019598007202148
(474) DESCRIBE `ports` 0.00066614151000977
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00017619132995605
(476) DESCRIBE `ports` 0.0006711483001709
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00020289421081543
(478) DESCRIBE `ports` 0.00068402290344238
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00018095970153809
(480) DESCRIBE `ports` 0.00067496299743652
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 524))) 0.00022602081298828
(482) DESCRIBE `ports` 0.00076389312744141
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '524') 0.00018882751464844
(484) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '68493') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0052618980407715
(485) DESCRIBE `avid_specials` 0.00084090232849121
(486) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68493 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 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.00098085403442383
(487) DESCRIBE `cruiselines` 0.00099802017211914
(488) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00026607513427734
(489) DESCRIBE `orchid_image` 0.00084304809570312
(490) DESCRIBE `cruiselines` 0.00097393989562988
(491) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00022506713867188
(492) DESCRIBE `cruises` 0.0013670921325684
(493) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '58851') 0.00025105476379395
(494) DESCRIBE `ships` 0.0013110637664795
(495) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 616))) 0.0002748966217041
(496) DESCRIBE `ships` 0.0013289451599121
(497) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '616') 0.00020885467529297
(498) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018095970153809
(499) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016903877258301
(500) DESCRIBE `itineraries` 0.00072693824768066
(501) DESCRIBE `ports` 0.00069713592529297
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0002131462097168
(503) DESCRIBE `ports` 0.00069284439086914
(504) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020313262939453
(505) DESCRIBE `ports` 0.00067520141601562
(506) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018000602722168
(507) DESCRIBE `sailingdates` 0.00060081481933594
(508) DESCRIBE `ports` 0.00068402290344238
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00019288063049316
(510) DESCRIBE `ports` 0.00078916549682617
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00017809867858887
(512) DESCRIBE `ports` 0.00069785118103027
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4794))) 0.00021195411682129
(514) DESCRIBE `ports` 0.00073695182800293
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4794') 0.00024914741516113
(516) DESCRIBE `ports` 0.00073695182800293
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.0002140998840332
(518) DESCRIBE `ports` 0.00067996978759766
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00018119812011719
(520) DESCRIBE `ports` 0.00068211555480957
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 532))) 0.00020289421081543
(522) DESCRIBE `ports` 0.00068998336791992
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '532') 0.00018000602722168
(524) DESCRIBE `ports` 0.00067305564880371
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1493))) 0.0001978874206543
(526) DESCRIBE `ports` 0.00067901611328125
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1493') 0.00017905235290527
(528) DESCRIBE `ports` 0.0006871223449707
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.0001978874206543
(530) DESCRIBE `ports` 0.00068116188049316
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00019598007202148
(532) DESCRIBE `ports` 0.00069713592529297
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 378))) 0.0001981258392334
(534) DESCRIBE `ports` 0.00067377090454102
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '378') 0.00017499923706055
(536) DESCRIBE `ports` 0.00066494941711426
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1878))) 0.00022292137145996
(538) DESCRIBE `ports` 0.00067615509033203
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1878') 0.00017499923706055
(540) DESCRIBE `ports` 0.00067710876464844
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00019502639770508
(542) DESCRIBE `ports` 0.00068807601928711
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00017404556274414
(544) DESCRIBE `ports` 0.00069403648376465
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00020384788513184
(546) DESCRIBE `ports` 0.00067591667175293
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00017499923706055
(548) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '58851') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0052859783172607
(549) DESCRIBE `avid_specials` 0.00071191787719727
(550) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 58851 and class = 'Cruise') OR (item_id = 616 AND class = 'Ship') OR (item_id = 151 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.00097513198852539
(551) DESCRIBE `cruiselines` 0.00099396705627441
(552) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00023698806762695
(553) DESCRIBE `orchid_image` 0.00077009201049805
(554) DESCRIBE `cruiselines` 0.00094985961914062
(555) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00019502639770508
(556) DESCRIBE `cruises` 0.0013320446014404
(557) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60178') 0.00021910667419434
(558) DESCRIBE `ships` 0.0013279914855957
(559) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 652))) 0.00029397010803223
(560) DESCRIBE `ships` 0.0013589859008789
(561) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '652') 0.00018906593322754
(562) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017595291137695
(563) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019598007202148
(564) DESCRIBE `itineraries` 0.00074005126953125
(565) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '60178') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00038599967956543
(566) DESCRIBE `ports` 0.00075507164001465
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00023889541625977
(568) DESCRIBE `ports` 0.00069189071655273
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020289421081543
(570) DESCRIBE `ports` 0.00072193145751953
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0001978874206543
(572) DESCRIBE `sailingdates` 0.00063681602478027
(573) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '60178') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00035810470581055
(574) DESCRIBE `ports` 0.00080490112304688
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020098686218262
(576) DESCRIBE `ports` 0.00068092346191406
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00023603439331055
(578) DESCRIBE `ports` 0.00068497657775879
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1252))) 0.00020384788513184
(580) DESCRIBE `ports` 0.00069189071655273
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1252') 0.00018191337585449
(582) DESCRIBE `ports` 0.00067687034606934
(583) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2405))) 0.00020194053649902
(584) DESCRIBE `ports` 0.00068092346191406
(585) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2405') 0.00025606155395508
(586) DESCRIBE `ports` 0.00073003768920898
(587) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00020503997802734
(588) DESCRIBE `ports` 0.00074386596679688
(589) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00018215179443359
(590) DESCRIBE `ports` 0.0006871223449707
(591) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00020408630371094
(592) DESCRIBE `ports` 0.00067806243896484
(593) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00018191337585449
(594) DESCRIBE `ports` 0.00067496299743652
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2930))) 0.00020885467529297
(596) DESCRIBE `ports` 0.00068306922912598
(597) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2930') 0.00019407272338867
(598) DESCRIBE `ports` 0.00068497657775879
(599) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 865))) 0.00021600723266602
(600) DESCRIBE `ports` 0.00067687034606934
(601) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '865') 0.00018477439880371
(602) DESCRIBE `ports` 0.0006718635559082
(603) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 691))) 0.00023508071899414
(604) DESCRIBE `ports` 0.00074911117553711
(605) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '691') 0.00018692016601562
(606) DESCRIBE `ports` 0.00068902969360352
(607) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00020313262939453
(608) DESCRIBE `ports` 0.00070691108703613
(609) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00018215179443359
(610) DESCRIBE `ports` 0.00067901611328125
(611) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00020003318786621
(612) DESCRIBE `ports` 0.00067806243896484
(613) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00018095970153809
(614) DESCRIBE `ports` 0.00069594383239746
(615) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020003318786621
(616) DESCRIBE `ports` 0.00069212913513184
(617) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0001838207244873
(618) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '60178') AND (sailingdate >= '2018-04-20') AND (sailingdate <= '2018-10-15') 0.0056338310241699
(619) DESCRIBE `avid_specials` 0.00085806846618652
(620) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60178 and class = 'Cruise') OR (item_id = 652 AND class = 'Ship') OR (item_id = 151 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.0010731220245361
(621) DESCRIBE `cruiselines` 0.00098085403442383
(622) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00023508071899414
(623) DESCRIBE `orchid_image` 0.0007779598236084
(624) DESCRIBE `cruiselines` 0.0009610652923584
(625) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '151') 0.00023102760314941
(626) DESCRIBE `ships` 0.0016520023345947
(627) SELECT `ships`.* FROM `ships` WHERE (id IN ('652', '616', '1672')) ORDER BY FIND_IN_SET(id, '652,616,1672') 0.00041794776916504
(628) DESCRIBE `cruisetypes` 0.00060105323791504
(629) DESCRIBE `destinations` 0.00092792510986328
(630) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '26', '28', '45', '21', '25', '49')) ORDER BY FIND_IN_SET(id, '22,26,28,45,21,25,49') 0.00056600570678711
(631) DESCRIBE `cruiselines` 0.0010590553283691
(632) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00024509429931641
(633) DESCRIBE `cruiselines` 0.0011639595031738
(634) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 151))) 0.00025701522827148