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

Total elapsed time: 0.47694849967957

# Query Time
(1) connect 0.00061297416687012
(2) DESCRIBE `cruises` 0.0015761852264404
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (62106, 62128, 62145, 62095, 62108, 62129, 62109, 62089, 62130, 62110)) ORDER BY FIND_IN_SET(id, '62106,62128,62145,62095,62108,62129,62109,62089,62130,62110') 0.0008699893951416
(4) DESCRIBE `cruises` 0.0015201568603516
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62106') 0.00023603439331055
(6) DESCRIBE `ships` 0.0012400150299072
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 124))) 0.00025296211242676
(8) DESCRIBE `ships` 0.0012309551239014
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '124') 0.00018095970153809
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017905235290527
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015807151794434
(12) DESCRIBE `itineraries` 0.00062394142150879
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62106') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00054001808166504
(14) DESCRIBE `ports` 0.00080585479736328
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025200843811035
(16) DESCRIBE `ports` 0.00061893463134766
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00017809867858887
(18) DESCRIBE `ports` 0.00058484077453613
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0001988410949707
(20) DESCRIBE `sailingdates` 0.00074982643127441
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62106') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00064301490783691
(22) DESCRIBE `ports` 0.00081706047058105
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022697448730469
(24) DESCRIBE `ports` 0.00066614151000977
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017404556274414
(26) DESCRIBE `ports` 0.00058794021606445
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00018811225891113
(28) DESCRIBE `ports` 0.00059795379638672
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00016307830810547
(30) DESCRIBE `ports` 0.00057196617126465
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.0001828670501709
(32) DESCRIBE `ports` 0.00057101249694824
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00016403198242188
(34) DESCRIBE `ports` 0.00059103965759277
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00018787384033203
(36) DESCRIBE `ports` 0.0006411075592041
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00017189979553223
(38) DESCRIBE `ports` 0.00058412551879883
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00020313262939453
(40) DESCRIBE `ports` 0.0006101131439209
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00017499923706055
(42) DESCRIBE `ports` 0.00057601928710938
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0001828670501709
(44) DESCRIBE `ports` 0.00061702728271484
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00016689300537109
(46) DESCRIBE `ports` 0.00063085556030273
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00018620491027832
(48) DESCRIBE `ports` 0.00059604644775391
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00016403198242188
(50) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62106') AND (sailingdate >= '2018-01-10') 0.0076360702514648
(51) DESCRIBE `avid_specials` 0.00082278251647949
(52) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62106 and class = 'Cruise') OR (item_id = 124 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010499954223633
(53) DESCRIBE `cruiselines` 0.0010268688201904
(54) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00026297569274902
(55) DESCRIBE `orchid_image` 0.00085592269897461
(56) DESCRIBE `cruiselines` 0.0011279582977295
(57) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00024199485778809
(58) DESCRIBE `cruises` 0.0017809867858887
(59) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62128') 0.00023603439331055
(60) DESCRIBE `ships` 0.0014760494232178
(61) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 262))) 0.00028681755065918
(62) DESCRIBE `ships` 0.0016341209411621
(63) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '262') 0.00019598007202148
(64) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015401840209961
(65) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014281272888184
(66) DESCRIBE `itineraries` 0.00074887275695801
(67) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62128') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00039792060852051
(68) DESCRIBE `ports` 0.0009009838104248
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032186508178711
(70) DESCRIBE `ports` 0.000885009765625
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002281665802002
(72) DESCRIBE `ports` 0.00059008598327637
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017285346984863
(74) DESCRIBE `sailingdates` 0.0006248950958252
(75) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62128') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00046610832214355
(76) DESCRIBE `ports` 0.00073814392089844
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00019598007202148
(78) DESCRIBE `ports` 0.00065207481384277
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00016903877258301
(80) DESCRIBE `ports` 0.00057601928710938
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00017189979553223
(82) DESCRIBE `ports` 0.00062179565429688
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00016379356384277
(84) DESCRIBE `ports` 0.00065207481384277
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00018405914306641
(86) DESCRIBE `ports` 0.00062108039855957
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00016307830810547
(88) DESCRIBE `ports` 0.00064706802368164
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.00016999244689941
(90) DESCRIBE `ports` 0.00060200691223145
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.00022387504577637
(92) DESCRIBE `ports` 0.00076413154602051
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00023698806762695
(94) DESCRIBE `ports` 0.0010449886322021
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00020194053649902
(96) DESCRIBE `ports` 0.00060892105102539
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00019121170043945
(98) DESCRIBE `ports` 0.00058388710021973
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00015902519226074
(100) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62128') AND (sailingdate >= '2018-01-10') 0.0048089027404785
(101) DESCRIBE `avid_specials` 0.00092506408691406
(102) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62128 and class = 'Cruise') OR (item_id = 262 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015060901641846
(103) DESCRIBE `cruiselines` 0.001115083694458
(104) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00024604797363281
(105) DESCRIBE `orchid_image` 0.0007169246673584
(106) DESCRIBE `cruiselines` 0.00085711479187012
(107) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00023102760314941
(108) DESCRIBE `cruises` 0.0015749931335449
(109) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62145') 0.00025105476379395
(110) DESCRIBE `ships` 0.0018820762634277
(111) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 287))) 0.00037097930908203
(112) DESCRIBE `ships` 0.0020630359649658
(113) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '287') 0.00028610229492188
(114) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021195411682129
(115) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001978874206543
(116) DESCRIBE `itineraries` 0.0010309219360352
(117) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62145') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00089383125305176
(118) DESCRIBE `ports` 0.0012137889862061
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029087066650391
(120) DESCRIBE `ports` 0.00091004371643066
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002439022064209
(122) DESCRIBE `ports` 0.00092601776123047
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022006034851074
(124) DESCRIBE `sailingdates` 0.00075888633728027
(125) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62145') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00050687789916992
(126) DESCRIBE `ports` 0.001121997833252
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027894973754883
(128) DESCRIBE `ports` 0.00095295906066895
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00024509429931641
(130) DESCRIBE `ports` 0.00095391273498535
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00026512145996094
(132) DESCRIBE `ports` 0.00098800659179688
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00036501884460449
(134) DESCRIBE `ports` 0.0012500286102295
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00030708312988281
(136) DESCRIBE `ports` 0.00088620185852051
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00022006034851074
(138) DESCRIBE `ports` 0.00088882446289062
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00027990341186523
(140) DESCRIBE `ports` 0.00087404251098633
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00024104118347168
(142) DESCRIBE `ports` 0.00087094306945801
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00026297569274902
(144) DESCRIBE `ports` 0.0010051727294922
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00034189224243164
(146) DESCRIBE `ports` 0.0010161399841309
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00029802322387695
(148) DESCRIBE `ports` 0.00083804130554199
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00021195411682129
(150) DESCRIBE `ports` 0.0007779598236084
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00023794174194336
(152) DESCRIBE `ports` 0.00079894065856934
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00023102760314941
(154) DESCRIBE `ports` 0.00089001655578613
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00024199485778809
(156) DESCRIBE `ports` 0.00081801414489746
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00020790100097656
(158) DESCRIBE `ports` 0.00080704689025879
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00024700164794922
(160) DESCRIBE `ports` 0.00081396102905273
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00022292137145996
(162) DESCRIBE `ports` 0.00084090232849121
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.0002589225769043
(164) DESCRIBE `ports` 0.0008552074432373
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00023293495178223
(166) DESCRIBE `ports` 0.00087308883666992
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025796890258789
(168) DESCRIBE `ports` 0.000823974609375
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022315979003906
(170) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62145') AND (sailingdate >= '2018-01-10') 0.0097141265869141
(171) DESCRIBE `avid_specials` 0.00099897384643555
(172) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62145 and class = 'Cruise') OR (item_id = 287 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013988018035889
(173) DESCRIBE `cruiselines` 0.0016381740570068
(174) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00033998489379883
(175) DESCRIBE `orchid_image` 0.0010149478912354
(176) DESCRIBE `cruiselines` 0.001194953918457
(177) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00024914741516113
(178) DESCRIBE `cruises` 0.0019419193267822
(179) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62095') 0.00031113624572754
(180) DESCRIBE `ships` 0.0018651485443115
(181) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00037288665771484
(182) DESCRIBE `ships` 0.0019729137420654
(183) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00029087066650391
(184) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020098686218262
(185) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018405914306641
(186) DESCRIBE `itineraries` 0.00089406967163086
(187) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62095') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00057888031005859
(188) DESCRIBE `ports` 0.00099611282348633
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027799606323242
(190) DESCRIBE `ports` 0.00087094306945801
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024199485778809
(192) DESCRIBE `ports` 0.00085306167602539
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023698806762695
(194) DESCRIBE `sailingdates` 0.00086879730224609
(195) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62095') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00050878524780273
(196) DESCRIBE `ports` 0.0010509490966797
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029897689819336
(198) DESCRIBE `ports` 0.00089097023010254
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00024509429931641
(200) DESCRIBE `ports` 0.0010139942169189
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00029587745666504
(202) DESCRIBE `ports` 0.00089001655578613
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00021982192993164
(204) DESCRIBE `ports` 0.00084710121154785
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00025081634521484
(206) DESCRIBE `ports` 0.00090289115905762
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00029516220092773
(208) DESCRIBE `ports` 0.00089097023010254
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00026392936706543
(210) DESCRIBE `ports` 0.00085687637329102
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00025200843811035
(212) DESCRIBE `ports` 0.00083494186401367
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.0002591609954834
(214) DESCRIBE `ports` 0.00086188316345215
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00027298927307129
(216) DESCRIBE `ports` 0.00086212158203125
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00029397010803223
(218) DESCRIBE `ports` 0.00096416473388672
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00026893615722656
(220) DESCRIBE `ports` 0.00089788436889648
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00028586387634277
(222) DESCRIBE `ports` 0.00090193748474121
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00024509429931641
(224) DESCRIBE `ports` 0.00084900856018066
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00027203559875488
(226) DESCRIBE `ports` 0.00087094306945801
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.0002288818359375
(228) DESCRIBE `ports` 0.00087690353393555
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00026512145996094
(230) DESCRIBE `ports` 0.00094699859619141
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00024890899658203
(232) DESCRIBE `ports` 0.000885009765625
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00026893615722656
(234) DESCRIBE `ports` 0.00089693069458008
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00023293495178223
(236) DESCRIBE `ports` 0.00084805488586426
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026082992553711
(238) DESCRIBE `ports` 0.00088310241699219
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022602081298828
(240) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62095') AND (sailingdate >= '2018-01-10') 0.0099549293518066
(241) DESCRIBE `avid_specials` 0.001039981842041
(242) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62095 and class = 'Cruise') OR (item_id = 1330 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0017211437225342
(243) DESCRIBE `cruiselines` 0.0014669895172119
(244) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00033903121948242
(245) DESCRIBE `orchid_image` 0.0010731220245361
(246) DESCRIBE `cruiselines` 0.0012989044189453
(247) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00025701522827148
(248) DESCRIBE `cruises` 0.0018441677093506
(249) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62108') 0.00030803680419922
(250) DESCRIBE `ships` 0.0018529891967773
(251) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 124))) 0.00035214424133301
(252) DESCRIBE `ships` 0.0018649101257324
(253) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '124') 0.00029587745666504
(254) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020098686218262
(255) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019192695617676
(256) DESCRIBE `itineraries` 0.00096702575683594
(257) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62108') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0005488395690918
(258) DESCRIBE `ports` 0.0010340213775635
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029206275939941
(260) DESCRIBE `ports` 0.00084495544433594
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024008750915527
(262) DESCRIBE `ports` 0.00083613395690918
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022196769714355
(264) DESCRIBE `sailingdates` 0.00084304809570312
(265) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62108') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00064492225646973
(266) DESCRIBE `ports` 0.0013229846954346
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034308433532715
(268) DESCRIBE `ports` 0.00094008445739746
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00024080276489258
(270) DESCRIBE `ports` 0.00084590911865234
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.0002892017364502
(272) DESCRIBE `ports` 0.00088191032409668
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00025105476379395
(274) DESCRIBE `ports` 0.00086498260498047
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00024914741516113
(276) DESCRIBE `ports` 0.00088381767272949
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00025701522827148
(278) DESCRIBE `ports` 0.00086808204650879
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00025582313537598
(280) DESCRIBE `ports` 0.00085878372192383
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00021600723266602
(282) DESCRIBE `ports` 0.00088906288146973
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00031709671020508
(284) DESCRIBE `ports` 0.00098800659179688
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00023889541625977
(286) DESCRIBE `ports` 0.00093483924865723
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00024795532226562
(288) DESCRIBE `ports` 0.00091814994812012
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00024104118347168
(290) DESCRIBE `ports` 0.00089502334594727
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024509429931641
(292) DESCRIBE `ports` 0.00080299377441406
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022006034851074
(294) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62108') AND (sailingdate >= '2018-01-10') 0.0090420246124268
(295) DESCRIBE `avid_specials` 0.0010209083557129
(296) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62108 and class = 'Cruise') OR (item_id = 124 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001471996307373
(297) DESCRIBE `cruiselines` 0.0013091564178467
(298) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00029802322387695
(299) DESCRIBE `orchid_image` 0.00098299980163574
(300) DESCRIBE `cruiselines` 0.0012199878692627
(301) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00024700164794922
(302) DESCRIBE `cruises` 0.0019528865814209
(303) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62129') 0.00032496452331543
(304) DESCRIBE `ships` 0.0019760131835938
(305) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 262))) 0.00036001205444336
(306) DESCRIBE `ships` 0.0019359588623047
(307) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '262') 0.00033402442932129
(308) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020599365234375
(309) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019288063049316
(310) DESCRIBE `itineraries` 0.0010190010070801
(311) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62129') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00042295455932617
(312) DESCRIBE `ports` 0.00092697143554688
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028109550476074
(314) DESCRIBE `ports` 0.00084090232849121
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022792816162109
(316) DESCRIBE `ports` 0.00078606605529785
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00020599365234375
(318) DESCRIBE `sailingdates` 0.00068306922912598
(319) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62129') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00073504447937012
(320) DESCRIBE `ports` 0.00093793869018555
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025200843811035
(322) DESCRIBE `ports` 0.00077509880065918
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00020909309387207
(324) DESCRIBE `ports` 0.00077605247497559
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0002138614654541
(326) DESCRIBE `ports` 0.0009310245513916
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00020503997802734
(328) DESCRIBE `ports` 0.00078701972961426
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00024104118347168
(330) DESCRIBE `ports` 0.00082802772521973
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00023794174194336
(332) DESCRIBE `ports` 0.00083398818969727
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00029492378234863
(334) DESCRIBE `ports` 0.00082588195800781
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00022006034851074
(336) DESCRIBE `ports` 0.00080013275146484
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00026297569274902
(338) DESCRIBE `ports` 0.00083613395690918
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00022697448730469
(340) DESCRIBE `ports` 0.00083613395690918
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029087066650391
(342) DESCRIBE `ports` 0.00086784362792969
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023794174194336
(344) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62129') AND (sailingdate >= '2018-01-10') 0.0090219974517822
(345) DESCRIBE `avid_specials` 0.0010368824005127
(346) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62129 and class = 'Cruise') OR (item_id = 262 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015809535980225
(347) DESCRIBE `cruiselines` 0.0014619827270508
(348) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00035405158996582
(349) DESCRIBE `orchid_image` 0.0011169910430908
(350) DESCRIBE `cruiselines` 0.0014979839324951
(351) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00029897689819336
(352) DESCRIBE `cruises` 0.0020148754119873
(353) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62109') 0.00040483474731445
(354) DESCRIBE `ships` 0.0021078586578369
(355) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 124))) 0.0003969669342041
(356) DESCRIBE `ships` 0.0020110607147217
(357) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '124') 0.0003049373626709
(358) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020098686218262
(359) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(360) DESCRIBE `itineraries` 0.00093317031860352
(361) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62109') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0005030632019043
(362) DESCRIBE `ports` 0.0010628700256348
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029802322387695
(364) DESCRIBE `ports` 0.00090408325195312
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026702880859375
(366) DESCRIBE `ports` 0.00090289115905762
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00021505355834961
(368) DESCRIBE `sailingdates` 0.00075721740722656
(369) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62109') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00049877166748047
(370) DESCRIBE `ports` 0.00092411041259766
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029492378234863
(372) DESCRIBE `ports` 0.00086188316345215
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023317337036133
(374) DESCRIBE `ports` 0.00084495544433594
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00028800964355469
(376) DESCRIBE `ports` 0.0009770393371582
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00025486946105957
(378) DESCRIBE `ports` 0.00083303451538086
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.0002739429473877
(380) DESCRIBE `ports` 0.0009150505065918
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00023102760314941
(382) DESCRIBE `ports` 0.00088214874267578
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00026297569274902
(384) DESCRIBE `ports` 0.00099897384643555
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00026106834411621
(386) DESCRIBE `ports` 0.00089001655578613
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00028610229492188
(388) DESCRIBE `ports` 0.00083804130554199
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00021600723266602
(390) DESCRIBE `ports` 0.00083804130554199
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041484832763672
(392) DESCRIBE `ports` 0.00098204612731934
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023388862609863
(394) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62109') AND (sailingdate >= '2018-01-10') 0.0096437931060791
(395) DESCRIBE `avid_specials` 0.0010120868682861
(396) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62109 and class = 'Cruise') OR (item_id = 124 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015480518341064
(397) DESCRIBE `cruiselines` 0.0013158321380615
(398) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00033903121948242
(399) DESCRIBE `orchid_image` 0.00099611282348633
(400) DESCRIBE `cruiselines` 0.0012528896331787
(401) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00027298927307129
(402) DESCRIBE `cruises` 0.0017590522766113
(403) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62089') 0.00028181076049805
(404) DESCRIBE `ships` 0.0012660026550293
(405) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1330))) 0.00024890899658203
(406) DESCRIBE `ships` 0.0011990070343018
(407) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1330') 0.00019598007202148
(408) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017499923706055
(409) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014901161193848
(410) DESCRIBE `itineraries` 0.00062799453735352
(411) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62089') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00034093856811523
(412) DESCRIBE `ports` 0.00067377090454102
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021100044250488
(414) DESCRIBE `ports` 0.00083589553833008
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025081634521484
(416) DESCRIBE `ports` 0.00086307525634766
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022602081298828
(418) DESCRIBE `sailingdates` 0.00077700614929199
(419) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62089') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00059604644775391
(420) DESCRIBE `ports` 0.00095796585083008
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026202201843262
(422) DESCRIBE `ports` 0.00061321258544922
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019192695617676
(424) DESCRIBE `ports` 0.00060200691223145
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00018692016601562
(426) DESCRIBE `ports` 0.00058507919311523
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00015997886657715
(428) DESCRIBE `ports` 0.00059103965759277
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00020003318786621
(430) DESCRIBE `ports` 0.00059819221496582
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0002129077911377
(432) DESCRIBE `ports` 0.0009148120880127
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023007392883301
(434) DESCRIBE `ports` 0.00088691711425781
(435) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00020694732666016
(436) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62089') AND (sailingdate >= '2018-01-10') 0.004817008972168
(437) DESCRIBE `avid_specials` 0.00082993507385254
(438) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62089 and class = 'Cruise') OR (item_id = 1330 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011060237884521
(439) DESCRIBE `cruiselines` 0.000946044921875
(440) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00022983551025391
(441) DESCRIBE `orchid_image` 0.00071907043457031
(442) DESCRIBE `cruiselines` 0.00089097023010254
(443) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00024795532226562
(444) DESCRIBE `cruises` 0.0020201206207275
(445) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62130') 0.00031805038452148
(446) DESCRIBE `ships` 0.0018491744995117
(447) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 262))) 0.00040888786315918
(448) DESCRIBE `ships` 0.001906156539917
(449) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '262') 0.00029301643371582
(450) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019621849060059
(451) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018811225891113
(452) DESCRIBE `itineraries` 0.00092887878417969
(453) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62130') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00048208236694336
(454) DESCRIBE `ports` 0.0010931491851807
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031113624572754
(456) DESCRIBE `ports` 0.00090599060058594
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029802322387695
(458) DESCRIBE `ports` 0.00092816352844238
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00024509429931641
(460) DESCRIBE `sailingdates` 0.00075697898864746
(461) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62130') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00053286552429199
(462) DESCRIBE `ports` 0.0010488033294678
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031018257141113
(464) DESCRIBE `ports` 0.00085711479187012
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023102760314941
(466) DESCRIBE `ports` 0.00082612037658691
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0003211498260498
(468) DESCRIBE `ports` 0.00097894668579102
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00025415420532227
(470) DESCRIBE `ports` 0.00089693069458008
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00026583671569824
(472) DESCRIBE `ports` 0.00084614753723145
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00023102760314941
(474) DESCRIBE `ports` 0.00089693069458008
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00026106834411621
(476) DESCRIBE `ports` 0.00086092948913574
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00023102760314941
(478) DESCRIBE `ports` 0.00082015991210938
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 79))) 0.00024604797363281
(480) DESCRIBE `ports` 0.00083208084106445
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '79') 0.00024890899658203
(482) DESCRIBE `ports` 0.0008389949798584
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00024318695068359
(484) DESCRIBE `ports` 0.00078606605529785
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.0002138614654541
(486) DESCRIBE `ports` 0.0008080005645752
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025796890258789
(488) DESCRIBE `ports` 0.00085997581481934
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025701522827148
(490) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62130') AND (sailingdate >= '2018-01-10') 0.0095651149749756
(491) DESCRIBE `avid_specials` 0.0010371208190918
(492) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62130 and class = 'Cruise') OR (item_id = 262 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015158653259277
(493) DESCRIBE `cruiselines` 0.0015039443969727
(494) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00026297569274902
(495) DESCRIBE `orchid_image` 0.00072097778320312
(496) DESCRIBE `cruiselines` 0.00089502334594727
(497) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00018692016601562
(498) DESCRIBE `cruises` 0.0012779235839844
(499) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62110') 0.0002129077911377
(500) DESCRIBE `ships` 0.0012040138244629
(501) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 124))) 0.00039291381835938
(502) DESCRIBE `ships` 0.0019190311431885
(503) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '124') 0.00026512145996094
(504) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019192695617676
(505) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001828670501709
(506) DESCRIBE `itineraries` 0.00086808204650879
(507) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62110') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00045394897460938
(508) DESCRIBE `ports` 0.00090503692626953
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025510787963867
(510) DESCRIBE `ports` 0.00083398818969727
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023293495178223
(512) DESCRIBE `ports` 0.00083208084106445
(513) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022983551025391
(514) DESCRIBE `sailingdates` 0.00071215629577637
(515) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62110') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00045204162597656
(516) DESCRIBE `ports` 0.00083518028259277
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024104118347168
(518) DESCRIBE `ports` 0.00076103210449219
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019717216491699
(520) DESCRIBE `ports` 0.00075292587280273
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.0002288818359375
(522) DESCRIBE `ports` 0.00075912475585938
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00019621849060059
(524) DESCRIBE `ports` 0.00075602531433105
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 79))) 0.00021791458129883
(526) DESCRIBE `ports` 0.00076818466186523
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '79') 0.00019717216491699
(528) DESCRIBE `ports` 0.00075578689575195
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00022006034851074
(530) DESCRIBE `ports` 0.00077986717224121
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00020980834960938
(532) DESCRIBE `ports` 0.00079202651977539
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.00024199485778809
(534) DESCRIBE `ports` 0.00082898139953613
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.00020909309387207
(536) DESCRIBE `ports` 0.0007929801940918
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00025296211242676
(538) DESCRIBE `ports` 0.0008389949798584
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00021100044250488
(540) DESCRIBE `ports` 0.00078797340393066
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00022006034851074
(542) DESCRIBE `ports` 0.00078296661376953
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.0001981258392334
(544) DESCRIBE `ports` 0.00078201293945312
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00023698806762695
(546) DESCRIBE `ports` 0.00081396102905273
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00020503997802734
(548) DESCRIBE `ports` 0.00080299377441406
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023889541625977
(550) DESCRIBE `ports` 0.00086402893066406
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00020217895507812
(552) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '62110') AND (sailingdate >= '2018-01-10') 0.0097019672393799
(553) DESCRIBE `avid_specials` 0.0010030269622803
(554) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62110 and class = 'Cruise') OR (item_id = 124 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0014898777008057
(555) DESCRIBE `cruiselines` 0.0012462139129639
(556) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00027894973754883
(557) DESCRIBE `orchid_image` 0.00093913078308105
(558) DESCRIBE `cruiselines` 0.0011930465698242
(559) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00024700164794922
(560) DESCRIBE `ships` 0.0018570423126221
(561) SELECT `ships`.* FROM `ships` WHERE (id IN ('262', '287', '1330', '124')) ORDER BY FIND_IN_SET(id, '262,287,1330,124') 0.0005490779876709
(562) DESCRIBE `cruisetypes` 0.0007319450378418
(563) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruises_and_specials.destination_id = '43') AND (cruises_and_specials.cruiseline_id = '26') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.034690141677856
(564) DESCRIBE `cruiselines` 0.0015161037445068
(565) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00035715103149414
(566) DESCRIBE `destinations` 0.0012161731719971
(567) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 43))) 0.00029492378234863
(568) DESCRIBE `destinations` 0.001168966293335
(569) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 43))) 0.00028610229492188
(570) DESCRIBE `cruiselines` 0.0012068748474121
(571) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00028491020202637