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

Total elapsed time: 0.51106214523315

# Query Time
(1) connect 0.00058293342590332
(2) DESCRIBE `cruises` 0.0022158622741699
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66992, 34056, 46637, 43597, 53605, 66993, 66953, 66955, 66996, 66994)) ORDER BY FIND_IN_SET(id, '66992,34056,46637,43597,53605,66993,66953,66955,66996,66994') 0.0019028186798096
(4) DESCRIBE `cruises` 0.0023190975189209
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66992') 0.0003659725189209
(6) DESCRIBE `ships` 0.0021388530731201
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 448))) 0.00037813186645508
(8) DESCRIBE `ships` 0.001971960067749
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '448') 0.00032877922058105
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020980834960938
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019311904907227
(12) DESCRIBE `itineraries` 0.00098896026611328
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66992') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0015089511871338
(14) DESCRIBE `ports` 0.0011849403381348
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031089782714844
(16) DESCRIBE `ports` 0.00088310241699219
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00025701522827148
(18) DESCRIBE `ports` 0.00087308883666992
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00023508071899414
(20) DESCRIBE `sailingdates` 0.00075507164001465
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66992') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.001291036605835
(22) DESCRIBE `ports` 0.0011851787567139
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00029897689819336
(24) DESCRIBE `ports` 0.00092506408691406
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00023794174194336
(26) DESCRIBE `ports` 0.0009160041809082
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00026917457580566
(28) DESCRIBE `ports` 0.00089406967163086
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00022196769714355
(30) DESCRIBE `ports` 0.00084590911865234
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.0002601146697998
(32) DESCRIBE `ports` 0.00082588195800781
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00021481513977051
(34) DESCRIBE `ports` 0.00094008445739746
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1493))) 0.00028109550476074
(36) DESCRIBE `ports` 0.00091814994812012
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1493') 0.00024008750915527
(38) DESCRIBE `ports` 0.00098991394042969
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 379))) 0.00027799606323242
(40) DESCRIBE `ports` 0.00085592269897461
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '379') 0.00023603439331055
(42) DESCRIBE `ports` 0.00098490715026855
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00027012825012207
(44) DESCRIBE `ports` 0.00088596343994141
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00022411346435547
(46) DESCRIBE `ports` 0.00086498260498047
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.0002748966217041
(48) DESCRIBE `ports` 0.00091886520385742
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00023818016052246
(50) DESCRIBE `ports` 0.00087499618530273
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00027084350585938
(52) DESCRIBE `ports` 0.00091290473937988
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00022602081298828
(54) DESCRIBE `ports` 0.00086021423339844
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00026178359985352
(56) DESCRIBE `ports` 0.000885009765625
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00023317337036133
(58) DESCRIBE `ports` 0.00092411041259766
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.0003058910369873
(60) DESCRIBE `ports` 0.00091099739074707
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00023198127746582
(62) DESCRIBE `ports` 0.00085592269897461
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00026893615722656
(64) DESCRIBE `ports` 0.00091886520385742
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00029587745666504
(66) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66992') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0089559555053711
(67) DESCRIBE `avid_specials` 0.001121997833252
(68) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66992 and class = 'Cruise') OR (item_id = 448 AND class = 'Ship') OR (item_id = 20 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.001643180847168
(69) DESCRIBE `cruiselines` 0.0014290809631348
(70) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00033211708068848
(71) DESCRIBE `orchid_image` 0.001121997833252
(72) DESCRIBE `cruiselines` 0.0013458728790283
(73) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00028181076049805
(74) DESCRIBE `cruises` 0.0020811557769775
(75) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '34056') 0.00032496452331543
(76) DESCRIBE `ships` 0.0018520355224609
(77) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 448))) 0.00040698051452637
(78) DESCRIBE `ships` 0.0020110607147217
(79) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '448') 0.00031900405883789
(80) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019979476928711
(81) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018906593322754
(82) DESCRIBE `itineraries` 0.0010321140289307
(83) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '34056') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011119842529297
(84) DESCRIBE `ports` 0.0010390281677246
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00029516220092773
(86) DESCRIBE `ports` 0.00084900856018066
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00024819374084473
(88) DESCRIBE `ports` 0.00078892707824707
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00022602081298828
(90) DESCRIBE `sailingdates` 0.0007169246673584
(91) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '34056') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00066399574279785
(92) DESCRIBE `ports` 0.001168966293335
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00030899047851562
(94) DESCRIBE `ports` 0.00091886520385742
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00023603439331055
(96) DESCRIBE `ports` 0.000823974609375
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00025010108947754
(98) DESCRIBE `ports` 0.00086593627929688
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00023007392883301
(100) DESCRIBE `ports` 0.00086116790771484
(101) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00026488304138184
(102) DESCRIBE `ports` 0.00089502334594727
(103) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00022411346435547
(104) DESCRIBE `ports` 0.00082111358642578
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00032496452331543
(106) DESCRIBE `ports` 0.00085806846618652
(107) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00024294853210449
(108) DESCRIBE `ports` 0.00084114074707031
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2565))) 0.00025796890258789
(110) DESCRIBE `ports` 0.0009310245513916
(111) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2565') 0.00023293495178223
(112) DESCRIBE `ports` 0.0007939338684082
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00023794174194336
(114) DESCRIBE `ports` 0.00081706047058105
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00021505355834961
(116) DESCRIBE `ports` 0.00084400177001953
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00026607513427734
(118) DESCRIBE `ports` 0.00095200538635254
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00026202201843262
(120) DESCRIBE `ports` 0.00084090232849121
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00025606155395508
(122) DESCRIBE `ports` 0.00085210800170898
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00021886825561523
(124) DESCRIBE `ports` 0.00083184242248535
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00027203559875488
(126) DESCRIBE `ports` 0.00092887878417969
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00025582313537598
(128) DESCRIBE `ports` 0.00083684921264648
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00024294853210449
(130) DESCRIBE `ports` 0.00082111358642578
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.0002140998840332
(132) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '34056') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0092129707336426
(133) DESCRIBE `avid_specials` 0.0010161399841309
(134) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 34056 and class = 'Cruise') OR (item_id = 448 AND class = 'Ship') OR (item_id = 20 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.0015499591827393
(135) DESCRIBE `cruiselines` 0.0013868808746338
(136) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00031590461730957
(137) DESCRIBE `orchid_image` 0.0010120868682861
(138) DESCRIBE `cruiselines` 0.0012390613555908
(139) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00026202201843262
(140) DESCRIBE `cruises` 0.0017721652984619
(141) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '46637') 0.00030779838562012
(142) DESCRIBE `ships` 0.0019361972808838
(143) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 770))) 0.00041508674621582
(144) DESCRIBE `ships` 0.0020289421081543
(145) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '770') 0.00037407875061035
(146) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021600723266602
(147) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020503997802734
(148) DESCRIBE `itineraries` 0.0010359287261963
(149) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '46637') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0013411045074463
(150) DESCRIBE `ports` 0.0011270046234131
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00029301643371582
(152) DESCRIBE `ports` 0.00086593627929688
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00025081634521484
(154) DESCRIBE `ports` 0.00086212158203125
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00023889541625977
(156) DESCRIBE `sailingdates` 0.00075793266296387
(157) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '46637') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0015079975128174
(158) DESCRIBE `ports` 0.0014209747314453
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00040102005004883
(160) DESCRIBE `ports` 0.0011019706726074
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00026297569274902
(162) DESCRIBE `ports` 0.00097417831420898
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00029397010803223
(164) DESCRIBE `ports` 0.00098800659179688
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.0002598762512207
(166) DESCRIBE `ports` 0.00096392631530762
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00028014183044434
(168) DESCRIBE `ports` 0.00086188316345215
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00023698806762695
(170) DESCRIBE `ports` 0.00087904930114746
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.0002601146697998
(172) DESCRIBE `ports` 0.00088000297546387
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00022292137145996
(174) DESCRIBE `ports` 0.00084900856018066
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00025796890258789
(176) DESCRIBE `ports` 0.00092196464538574
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00023102760314941
(178) DESCRIBE `ports` 0.00089192390441895
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00027608871459961
(180) DESCRIBE `ports` 0.00099778175354004
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00024008750915527
(182) DESCRIBE `ports` 0.00093507766723633
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00027179718017578
(184) DESCRIBE `ports` 0.00088596343994141
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00023388862609863
(186) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '46637') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0093669891357422
(187) DESCRIBE `avid_specials` 0.0011169910430908
(188) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 46637 and class = 'Cruise') OR (item_id = 770 AND class = 'Ship') OR (item_id = 20 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.0014982223510742
(189) DESCRIBE `cruiselines` 0.0013439655303955
(190) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00031590461730957
(191) DESCRIBE `orchid_image` 0.0011270046234131
(192) DESCRIBE `cruiselines` 0.0016191005706787
(193) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00027179718017578
(194) DESCRIBE `cruises` 0.0020451545715332
(195) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '43597') 0.00037717819213867
(196) DESCRIBE `ships` 0.001971960067749
(197) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 770))) 0.00040006637573242
(198) DESCRIBE `ships` 0.0020778179168701
(199) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '770') 0.0003669261932373
(200) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00023198127746582
(201) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022792816162109
(202) DESCRIBE `itineraries` 0.0011069774627686
(203) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '43597') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010027885437012
(204) DESCRIBE `ports` 0.0010771751403809
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0002751350402832
(206) DESCRIBE `ports` 0.00083613395690918
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00024700164794922
(208) DESCRIBE `ports` 0.0009150505065918
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00024700164794922
(210) DESCRIBE `sailingdates` 0.00079917907714844
(211) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '43597') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0010039806365967
(212) DESCRIBE `ports` 0.0011749267578125
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00036001205444336
(214) DESCRIBE `ports` 0.00096988677978516
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00025582313537598
(216) DESCRIBE `ports` 0.0010678768157959
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.0002748966217041
(218) DESCRIBE `ports` 0.00092601776123047
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00021600723266602
(220) DESCRIBE `ports` 0.00085592269897461
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00023818016052246
(222) DESCRIBE `ports` 0.00088191032409668
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00022196769714355
(224) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '43597') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0089051723480225
(225) DESCRIBE `avid_specials` 0.001162052154541
(226) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 43597 and class = 'Cruise') OR (item_id = 770 AND class = 'Ship') OR (item_id = 20 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.0016560554504395
(227) DESCRIBE `cruiselines` 0.0014967918395996
(228) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00033998489379883
(229) DESCRIBE `orchid_image` 0.001255989074707
(230) DESCRIBE `cruiselines` 0.0014910697937012
(231) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00029397010803223
(232) DESCRIBE `cruises` 0.001924991607666
(233) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '53605') 0.00030088424682617
(234) DESCRIBE `ships` 0.0020589828491211
(235) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 770))) 0.00038599967956543
(236) DESCRIBE `ships` 0.0018398761749268
(237) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '770') 0.0002899169921875
(238) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022196769714355
(239) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018310546875
(240) DESCRIBE `itineraries` 0.00096392631530762
(241) DESCRIBE `ports` 0.0011072158813477
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00030016899108887
(243) DESCRIBE `ports` 0.00084400177001953
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00024008750915527
(245) DESCRIBE `ports` 0.00081801414489746
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00022101402282715
(247) DESCRIBE `sailingdates` 0.00072407722473145
(248) DESCRIBE `ports` 0.0012331008911133
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00033211708068848
(250) DESCRIBE `ports` 0.00094699859619141
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00026297569274902
(252) DESCRIBE `ports` 0.00087809562683105
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00028610229492188
(254) DESCRIBE `ports` 0.00086212158203125
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00023698806762695
(256) DESCRIBE `ports` 0.00082182884216309
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00027322769165039
(258) DESCRIBE `ports` 0.0012781620025635
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00026583671569824
(260) DESCRIBE `ports` 0.00087213516235352
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.0003209114074707
(262) DESCRIBE `ports` 0.0010261535644531
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00020885467529297
(264) DESCRIBE `ports` 0.00078201293945312
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020790100097656
(266) DESCRIBE `ports` 0.00080418586730957
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00021505355834961
(268) DESCRIBE `ports` 0.00083494186401367
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00024986267089844
(270) DESCRIBE `ports` 0.00082898139953613
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00022101402282715
(272) DESCRIBE `ports` 0.001352071762085
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0002589225769043
(274) DESCRIBE `ports` 0.00083398818969727
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018501281738281
(276) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '53605') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0052340030670166
(277) DESCRIBE `avid_specials` 0.00097107887268066
(278) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 53605 and class = 'Cruise') OR (item_id = 770 AND class = 'Ship') OR (item_id = 20 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.0012238025665283
(279) DESCRIBE `cruiselines` 0.0012519359588623
(280) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00028681755065918
(281) DESCRIBE `orchid_image` 0.0010120868682861
(282) DESCRIBE `cruiselines` 0.0046529769897461
(283) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00030398368835449
(284) DESCRIBE `cruises` 0.0068929195404053
(285) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66993') 0.00029206275939941
(286) DESCRIBE `ships` 0.0023810863494873
(287) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 448))) 0.00049281120300293
(288) DESCRIBE `ships` 0.0023961067199707
(289) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '448') 0.00035405158996582
(290) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019288063049316
(291) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020480155944824
(292) DESCRIBE `itineraries` 0.0010550022125244
(293) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66993') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00049519538879395
(294) DESCRIBE `ports` 0.0012919902801514
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00031590461730957
(296) DESCRIBE `ports` 0.00099897384643555
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00030803680419922
(298) DESCRIBE `ports` 0.00096988677978516
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00024199485778809
(300) DESCRIBE `sailingdates` 0.00083303451538086
(301) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66993') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00056600570678711
(302) DESCRIBE `ports` 0.0012838840484619
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0003359317779541
(304) DESCRIBE `ports` 0.0010321140289307
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00027894973754883
(306) DESCRIBE `ports` 0.00095605850219727
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00034093856811523
(308) DESCRIBE `ports` 0.00092697143554688
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00023007392883301
(310) DESCRIBE `ports` 0.00074386596679688
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0002129077911377
(312) DESCRIBE `ports` 0.00064897537231445
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00020503997802734
(314) DESCRIBE `ports` 0.00061392784118652
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00022292137145996
(316) DESCRIBE `ports` 0.00064897537231445
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.0001680850982666
(318) DESCRIBE `ports` 0.00058794021606445
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.0001988410949707
(320) DESCRIBE `ports` 0.00058579444885254
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00016593933105469
(322) DESCRIBE `ports` 0.00063705444335938
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3963))) 0.00021219253540039
(324) DESCRIBE `ports` 0.00059103965759277
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3963') 0.00018978118896484
(326) DESCRIBE `ports` 0.0006098747253418
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00018882751464844
(328) DESCRIBE `ports` 0.00061583518981934
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00020599365234375
(330) DESCRIBE `ports` 0.00059390068054199
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00020885467529297
(332) DESCRIBE `ports` 0.00076603889465332
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.0002288818359375
(334) DESCRIBE `ports` 0.00087094306945801
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00024986267089844
(336) DESCRIBE `ports` 0.00066399574279785
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00017404556274414
(338) DESCRIBE `ports` 0.00074601173400879
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00025200843811035
(340) DESCRIBE `ports` 0.00088000297546387
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00023102760314941
(342) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66993') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.008253812789917
(343) DESCRIBE `avid_specials` 0.0010449886322021
(344) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66993 and class = 'Cruise') OR (item_id = 448 AND class = 'Ship') OR (item_id = 20 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.0014898777008057
(345) DESCRIBE `cruiselines` 0.0014200210571289
(346) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00030207633972168
(347) DESCRIBE `orchid_image` 0.00098991394042969
(348) DESCRIBE `cruiselines` 0.001305103302002
(349) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00026297569274902
(350) DESCRIBE `cruises` 0.0018699169158936
(351) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66953') 0.00033807754516602
(352) DESCRIBE `ships` 0.0017380714416504
(353) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00042486190795898
(354) DESCRIBE `ships` 0.0020279884338379
(355) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00034594535827637
(356) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021505355834961
(357) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020194053649902
(358) DESCRIBE `itineraries` 0.0010640621185303
(359) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66953') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0013399124145508
(360) DESCRIBE `ports` 0.0011951923370361
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00030207633972168
(362) DESCRIBE `ports` 0.00085711479187012
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00024104118347168
(364) DESCRIBE `ports` 0.00085592269897461
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00021505355834961
(366) DESCRIBE `sailingdates` 0.00075888633728027
(367) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66953') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00053215026855469
(368) DESCRIBE `ports` 0.0010089874267578
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00028681755065918
(370) DESCRIBE `ports` 0.00084400177001953
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00022506713867188
(372) DESCRIBE `ports` 0.00084900856018066
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.0002591609954834
(374) DESCRIBE `ports` 0.00089693069458008
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00023198127746582
(376) DESCRIBE `ports` 0.00081086158752441
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00024199485778809
(378) DESCRIBE `ports` 0.00089097023010254
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00021791458129883
(380) DESCRIBE `ports` 0.00081300735473633
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00025701522827148
(382) DESCRIBE `ports` 0.00084400177001953
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00021600723266602
(384) DESCRIBE `ports` 0.00085091590881348
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00026702880859375
(386) DESCRIBE `ports` 0.00089502334594727
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00022292137145996
(388) DESCRIBE `ports` 0.00081205368041992
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00025200843811035
(390) DESCRIBE `ports` 0.00087499618530273
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00022387504577637
(392) DESCRIBE `ports` 0.0008690357208252
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00026392936706543
(394) DESCRIBE `ports` 0.00081801414489746
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0002281665802002
(396) DESCRIBE `ports` 0.00088405609130859
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2613))) 0.00023794174194336
(398) DESCRIBE `ports` 0.00085806846618652
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2613') 0.00020194053649902
(400) DESCRIBE `ports` 0.00081110000610352
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0002598762512207
(402) DESCRIBE `ports` 0.00080513954162598
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00022006034851074
(404) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66953') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0092401504516602
(405) DESCRIBE `avid_specials` 0.001133918762207
(406) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66953 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.001500129699707
(407) DESCRIBE `cruiselines` 0.0013837814331055
(408) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00032496452331543
(409) DESCRIBE `orchid_image` 0.00097107887268066
(410) DESCRIBE `cruiselines` 0.0014069080352783
(411) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00026512145996094
(412) DESCRIBE `cruises` 0.0020899772644043
(413) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66955') 0.00031781196594238
(414) DESCRIBE `ships` 0.0019609928131104
(415) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00038409233093262
(416) DESCRIBE `ships` 0.0020210742950439
(417) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00032782554626465
(418) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020718574523926
(419) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019097328186035
(420) DESCRIBE `itineraries` 0.00097203254699707
(421) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66955') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00046801567077637
(422) DESCRIBE `ports` 0.0010781288146973
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00029993057250977
(424) DESCRIBE `ports` 0.00092005729675293
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00026202201843262
(426) DESCRIBE `ports` 0.0009150505065918
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00023317337036133
(428) DESCRIBE `sailingdates` 0.0007789134979248
(429) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66955') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00050783157348633
(430) DESCRIBE `ports` 0.001021146774292
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00028610229492188
(432) DESCRIBE `ports` 0.00085902214050293
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00021815299987793
(434) DESCRIBE `ports` 0.00085091590881348
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00025105476379395
(436) DESCRIBE `ports` 0.00089597702026367
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00023293495178223
(438) DESCRIBE `ports` 0.00088000297546387
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00026297569274902
(440) DESCRIBE `ports` 0.00088000297546387
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00023102760314941
(442) DESCRIBE `ports` 0.00086712837219238
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00025582313537598
(444) DESCRIBE `ports` 0.00087404251098633
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00021696090698242
(446) DESCRIBE `ports` 0.0006709098815918
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00019097328186035
(448) DESCRIBE `ports` 0.00062394142150879
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00020098686218262
(450) DESCRIBE `ports` 0.00088810920715332
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00025796890258789
(452) DESCRIBE `ports` 0.00063395500183105
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00016999244689941
(454) DESCRIBE `ports` 0.00058603286743164
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021696090698242
(456) DESCRIBE `ports` 0.00059008598327637
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00015878677368164
(458) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66955') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0048089027404785
(459) DESCRIBE `avid_specials` 0.00082087516784668
(460) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66955 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.00095796585083008
(461) DESCRIBE `cruiselines` 0.00090384483337402
(462) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00021791458129883
(463) DESCRIBE `orchid_image` 0.00072288513183594
(464) DESCRIBE `cruiselines` 0.00092601776123047
(465) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00019311904907227
(466) DESCRIBE `cruises` 0.0013229846954346
(467) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66996') 0.00034213066101074
(468) DESCRIBE `ships` 0.0012521743774414
(469) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00026893615722656
(470) DESCRIBE `ships` 0.0012309551239014
(471) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00019311904907227
(472) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016403198242188
(473) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014805793762207
(474) DESCRIBE `itineraries` 0.00064277648925781
(475) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66996') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00090312957763672
(476) DESCRIBE `ports` 0.00068783760070801
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020384788513184
(478) DESCRIBE `ports` 0.00059700012207031
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00017499923706055
(480) DESCRIBE `ports` 0.0005948543548584
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00016498565673828
(482) DESCRIBE `sailingdates` 0.00053095817565918
(483) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66996') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00048494338989258
(484) DESCRIBE `ports` 0.00081706047058105
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00027012825012207
(486) DESCRIBE `ports` 0.00069379806518555
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017404556274414
(488) DESCRIBE `ports` 0.0006101131439209
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00021100044250488
(490) DESCRIBE `ports` 0.0007779598236084
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00016593933105469
(492) DESCRIBE `ports` 0.00059390068054199
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00018405914306641
(494) DESCRIBE `ports` 0.00058698654174805
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00016903877258301
(496) DESCRIBE `ports` 0.00058984756469727
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00019598007202148
(498) DESCRIBE `ports` 0.00077199935913086
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00021100044250488
(500) DESCRIBE `ports` 0.0007479190826416
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00020599365234375
(502) DESCRIBE `ports` 0.00068116188049316
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00016403198242188
(504) DESCRIBE `ports` 0.00058507919311523
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00017690658569336
(506) DESCRIBE `ports` 0.00058794021606445
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00016379356384277
(508) DESCRIBE `ports` 0.00061988830566406
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00018191337585449
(510) DESCRIBE `ports` 0.00059199333190918
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00016593933105469
(512) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66996') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0049841403961182
(513) DESCRIBE `avid_specials` 0.00079703330993652
(514) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66996 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.0009300708770752
(515) DESCRIBE `cruiselines` 0.00096321105957031
(516) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00021696090698242
(517) DESCRIBE `orchid_image` 0.00077986717224121
(518) DESCRIBE `cruiselines` 0.00084495544433594
(519) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00018787384033203
(520) DESCRIBE `cruises` 0.0012760162353516
(521) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66994') 0.00023317337036133
(522) DESCRIBE `ships` 0.0012428760528564
(523) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 448))) 0.00023603439331055
(524) DESCRIBE `ships` 0.0012860298156738
(525) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '448') 0.00017809867858887
(526) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017499923706055
(527) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014805793762207
(528) DESCRIBE `itineraries` 0.00095009803771973
(529) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66994') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00058102607727051
(530) DESCRIBE `ports` 0.0011720657348633
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00032782554626465
(532) DESCRIBE `ports` 0.00087904930114746
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00023198127746582
(534) DESCRIBE `ports` 0.00086808204650879
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00021600723266602
(536) DESCRIBE `sailingdates` 0.00075697898864746
(537) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66994') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00048089027404785
(538) DESCRIBE `ports` 0.00098299980163574
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00028586387634277
(540) DESCRIBE `ports` 0.00089097023010254
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00031113624572754
(542) DESCRIBE `ports` 0.00086307525634766
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00025010108947754
(544) DESCRIBE `ports` 0.0008389949798584
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00021719932556152
(546) DESCRIBE `ports` 0.00085306167602539
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00025010108947754
(548) DESCRIBE `ports` 0.00089597702026367
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00022387504577637
(550) DESCRIBE `ports` 0.00087380409240723
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00025606155395508
(552) DESCRIBE `ports` 0.0010309219360352
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00024604797363281
(554) DESCRIBE `ports` 0.00089192390441895
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00023698806762695
(556) DESCRIBE `ports` 0.0012369155883789
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00026583671569824
(558) DESCRIBE `ports` 0.0009000301361084
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.0002589225769043
(560) DESCRIBE `ports` 0.00092196464538574
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00022506713867188
(562) DESCRIBE `ports` 0.00087809562683105
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00025415420532227
(564) DESCRIBE `ports` 0.00091195106506348
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00022387504577637
(566) DESCRIBE `ports` 0.0008690357208252
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00026607513427734
(568) DESCRIBE `ports` 0.00091004371643066
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00021696090698242
(570) DESCRIBE `ports` 0.00089788436889648
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00023794174194336
(572) DESCRIBE `ports` 0.00089812278747559
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00024795532226562
(574) DESCRIBE `ports` 0.00092792510986328
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00026607513427734
(576) DESCRIBE `ports` 0.00099492073059082
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00022578239440918
(578) DESCRIBE `ports` 0.00091004371643066
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0002439022064209
(580) DESCRIBE `ports` 0.00086283683776855
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00024008750915527
(582) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '66994') AND (sailingdate >= '2018-04-01') AND (sailingdate <= '2018-12-31') 0.0080990791320801
(583) DESCRIBE `avid_specials` 0.0010478496551514
(584) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66994 and class = 'Cruise') OR (item_id = 448 AND class = 'Ship') OR (item_id = 20 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.0014500617980957
(585) DESCRIBE `cruiselines` 0.0013730525970459
(586) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00029206275939941
(587) DESCRIBE `orchid_image` 0.0010080337524414
(588) DESCRIBE `cruiselines` 0.0012099742889404
(589) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00024604797363281
(590) DESCRIBE `ships` 0.0019271373748779
(591) SELECT `ships`.* FROM `ships` WHERE (id IN ('770', '93', '448')) ORDER BY FIND_IN_SET(id, '770,93,448') 0.00050806999206543
(592) DESCRIBE `cruisetypes` 0.00082802772521973
(593) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruises_and_specials.destination_id = '22') AND (cruises_and_specials.cruiseline_id = '20') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.028196096420288
(594) DESCRIBE `cruiselines` 0.0011370182037354
(595) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00024104118347168
(596) DESCRIBE `destinations` 0.00082683563232422
(597) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 22))) 0.00019097328186035
(598) DESCRIBE `destinations` 0.00089216232299805
(599) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 22))) 0.00023603439331055
(600) DESCRIBE `cruiselines` 0.00090408325195312
(601) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00019598007202148