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

Total elapsed time: 0.46616625785828

# Query Time
(1) connect 0.00077390670776367
(2) DESCRIBE `cruises` 0.0020899772644043
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (52861, 50857, 52889, 36066, 63404, 63371, 46218, 50856, 63403, 63374)) ORDER BY FIND_IN_SET(id, '52861,50857,52889,36066,63404,63371,46218,50856,63403,63374') 0.0014348030090332
(4) DESCRIBE `cruises` 0.002025842666626
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52861') 0.00038480758666992
(6) DESCRIBE `ships` 0.0018200874328613
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00038003921508789
(8) DESCRIBE `ships` 0.0018620491027832
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00031495094299316
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001990795135498
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018310546875
(12) DESCRIBE `itineraries` 0.00096607208251953
(13) DESCRIBE `ports` 0.0010077953338623
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027990341186523
(15) DESCRIBE `ports` 0.00092291831970215
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023603439331055
(17) DESCRIBE `ports` 0.00079202651977539
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00021815299987793
(19) DESCRIBE `sailingdates` 0.00075697898864746
(20) DESCRIBE `ports` 0.00085997581481934
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027012825012207
(22) DESCRIBE `ports` 0.00084018707275391
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022101402282715
(24) DESCRIBE `ports` 0.00079107284545898
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.00058221817016602
(26) DESCRIBE `ports` 0.001288890838623
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.00039291381835938
(28) DESCRIBE `ports` 0.0011539459228516
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00028800964355469
(30) DESCRIBE `ports` 0.00093293190002441
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00025796890258789
(32) DESCRIBE `ports` 0.00094199180603027
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00025105476379395
(34) DESCRIBE `ports` 0.00077605247497559
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00020194053649902
(36) DESCRIBE `ports` 0.00084900856018066
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.0002601146697998
(38) DESCRIBE `ports` 0.00086498260498047
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00022697448730469
(40) DESCRIBE `ports` 0.00089907646179199
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00032210350036621
(42) DESCRIBE `ports` 0.0011119842529297
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00026988983154297
(44) DESCRIBE `ports` 0.001046895980835
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029110908508301
(46) DESCRIBE `ports` 0.00084114074707031
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002288818359375
(48) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '52861') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.011489868164062
(49) DESCRIBE `avid_specials` 0.0011229515075684
(50) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 52861 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.0017731189727783
(51) DESCRIBE `cruiselines` 0.0015320777893066
(52) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00034999847412109
(53) DESCRIBE `orchid_image` 0.0022449493408203
(54) DESCRIBE `cruiselines` 0.0013740062713623
(55) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0002601146697998
(56) DESCRIBE `cruises` 0.0016260147094727
(57) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50857') 0.00031089782714844
(58) DESCRIBE `ships` 0.0016088485717773
(59) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00037312507629395
(60) DESCRIBE `ships` 0.0017669200897217
(61) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00028204917907715
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019097328186035
(63) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017690658569336
(64) DESCRIBE `itineraries` 0.0011410713195801
(65) DESCRIBE `ports` 0.00088214874267578
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002601146697998
(67) DESCRIBE `ports` 0.0012140274047852
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029492378234863
(69) DESCRIBE `ports` 0.0010581016540527
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023984909057617
(71) DESCRIBE `sailingdates` 0.0009760856628418
(72) DESCRIBE `ports` 0.0013060569763184
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035190582275391
(74) DESCRIBE `ports` 0.001723051071167
(75) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029206275939941
(76) DESCRIBE `ports` 0.0060570240020752
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00032806396484375
(78) DESCRIBE `ports` 0.00094985961914062
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00024795532226562
(80) DESCRIBE `ports` 0.00092506408691406
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00024604797363281
(82) DESCRIBE `ports` 0.0008399486541748
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00023102760314941
(84) DESCRIBE `ports` 0.00090789794921875
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0002748966217041
(86) DESCRIBE `ports` 0.00099301338195801
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00023698806762695
(88) DESCRIBE `ports` 0.0010149478912354
(89) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00023794174194336
(90) DESCRIBE `ports` 0.00088596343994141
(91) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00028800964355469
(92) DESCRIBE `ports` 0.00072813034057617
(93) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023508071899414
(94) DESCRIBE `ports` 0.00079703330993652
(95) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00021100044250488
(96) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '50857') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.011767864227295
(97) DESCRIBE `avid_specials` 0.0011661052703857
(98) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 50857 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0016250610351562
(99) DESCRIBE `cruiselines` 0.0016660690307617
(100) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00031185150146484
(101) DESCRIBE `orchid_image` 0.0011191368103027
(102) DESCRIBE `cruiselines` 0.0013351440429688
(103) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00027894973754883
(104) DESCRIBE `cruises` 0.0019090175628662
(105) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '52889') 0.00034284591674805
(106) DESCRIBE `ships` 0.0016779899597168
(107) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00033998489379883
(108) DESCRIBE `ships` 0.0028660297393799
(109) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00034213066101074
(110) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036001205444336
(111) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00038790702819824
(112) DESCRIBE `itineraries` 0.0010101795196533
(113) DESCRIBE `ports` 0.00096607208251953
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028800964355469
(115) DESCRIBE `ports` 0.00086212158203125
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002589225769043
(117) DESCRIBE `ports` 0.0008549690246582
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023221969604492
(119) DESCRIBE `sailingdates` 0.0007472038269043
(120) DESCRIBE `ports` 0.0010089874267578
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030899047851562
(122) DESCRIBE `ports` 0.0010669231414795
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029301643371582
(124) DESCRIBE `ports` 0.0011708736419678
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.00047588348388672
(126) DESCRIBE `ports` 0.0011179447174072
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.00025296211242676
(128) DESCRIBE `ports` 0.00099992752075195
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00029301643371582
(130) DESCRIBE `ports` 0.0009760856628418
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00024104118347168
(132) DESCRIBE `ports` 0.00072193145751953
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00026202201843262
(134) DESCRIBE `ports` 0.00081396102905273
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00023913383483887
(136) DESCRIBE `ports` 0.00095105171203613
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00027298927307129
(138) DESCRIBE `ports` 0.0011119842529297
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00037002563476562
(140) DESCRIBE `ports` 0.0013270378112793
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031614303588867
(142) DESCRIBE `ports` 0.0012149810791016
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027799606323242
(144) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '52889') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.009084939956665
(145) DESCRIBE `avid_specials` 0.0011539459228516
(146) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 52889 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.0016300678253174
(147) DESCRIBE `cruiselines` 0.0014770030975342
(148) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00041985511779785
(149) DESCRIBE `orchid_image` 0.0036499500274658
(150) DESCRIBE `cruiselines` 0.0015711784362793
(151) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00029993057250977
(152) DESCRIBE `cruises` 0.0018908977508545
(153) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '36066') 0.00032711029052734
(154) DESCRIBE `ships` 0.00193190574646
(155) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00043296813964844
(156) DESCRIBE `ships` 0.0019941329956055
(157) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00033998489379883
(158) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020790100097656
(159) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019693374633789
(160) DESCRIBE `itineraries` 0.0010590553283691
(161) DESCRIBE `ports` 0.00099587440490723
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035500526428223
(163) DESCRIBE `ports` 0.00095081329345703
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024008750915527
(165) DESCRIBE `ports` 0.00089693069458008
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022196769714355
(167) DESCRIBE `sailingdates` 0.00078082084655762
(168) DESCRIBE `ports` 0.00094795227050781
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028800964355469
(170) DESCRIBE `ports` 0.00088691711425781
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022101402282715
(172) DESCRIBE `ports` 0.00094914436340332
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00024509429931641
(174) DESCRIBE `ports` 0.00088000297546387
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00021004676818848
(176) DESCRIBE `ports` 0.00090813636779785
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.0002589225769043
(178) DESCRIBE `ports` 0.00094199180603027
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00025415420532227
(180) DESCRIBE `ports` 0.00096917152404785
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00037717819213867
(182) DESCRIBE `ports` 0.0010828971862793
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00025081634521484
(184) DESCRIBE `ports` 0.00091814994812012
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00031805038452148
(186) DESCRIBE `ports` 0.0010311603546143
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00023078918457031
(188) DESCRIBE `ports` 0.00080299377441406
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00019192695617676
(190) DESCRIBE `ports` 0.00084590911865234
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022602081298828
(192) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '36066') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0068538188934326
(193) DESCRIBE `avid_specials` 0.001060962677002
(194) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 36066 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0017118453979492
(195) DESCRIBE `cruiselines` 0.0014798641204834
(196) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00049614906311035
(197) DESCRIBE `orchid_image` 0.0010859966278076
(198) DESCRIBE `cruiselines` 0.0014140605926514
(199) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00031590461730957
(200) DESCRIBE `cruises` 0.0030369758605957
(201) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63404') 0.00044894218444824
(202) DESCRIBE `ships` 0.0021429061889648
(203) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.0005190372467041
(204) DESCRIBE `ships` 0.0023670196533203
(205) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00038909912109375
(206) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020384788513184
(207) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018906593322754
(208) DESCRIBE `itineraries` 0.0010471343994141
(209) DESCRIBE `ports` 0.0010931491851807
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003058910369873
(211) DESCRIBE `ports` 0.00074911117553711
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023913383483887
(213) DESCRIBE `ports` 0.00082802772521973
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022315979003906
(215) DESCRIBE `sailingdates` 0.00085783004760742
(216) DESCRIBE `ports` 0.0010011196136475
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030994415283203
(218) DESCRIBE `ports` 0.00093698501586914
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022792816162109
(220) DESCRIBE `ports` 0.00084018707275391
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00026679039001465
(222) DESCRIBE `ports` 0.0007169246673584
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00019717216491699
(224) DESCRIBE `ports` 0.0007169246673584
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00018405914306641
(226) DESCRIBE `ports` 0.00072193145751953
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.0001838207244873
(228) DESCRIBE `ports` 0.00067496299743652
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00023913383483887
(230) DESCRIBE `ports` 0.00081992149353027
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.0002291202545166
(232) DESCRIBE `ports` 0.00073409080505371
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00021696090698242
(234) DESCRIBE `ports` 0.00070309638977051
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00024294853210449
(236) DESCRIBE `ports` 0.00087380409240723
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022006034851074
(238) DESCRIBE `ports` 0.00064492225646973
(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 = '63404') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0096690654754639
(241) DESCRIBE `avid_specials` 0.0010678768157959
(242) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63404 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.002310037612915
(243) DESCRIBE `cruiselines` 0.0015230178833008
(244) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00036096572875977
(245) DESCRIBE `orchid_image` 0.0011658668518066
(246) DESCRIBE `cruiselines` 0.0013408660888672
(247) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00027012825012207
(248) DESCRIBE `cruises` 0.0019149780273438
(249) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63371') 0.00039100646972656
(250) DESCRIBE `ships` 0.0019190311431885
(251) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00043606758117676
(252) DESCRIBE `ships` 0.0026538372039795
(253) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00036907196044922
(254) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022196769714355
(255) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021004676818848
(256) DESCRIBE `itineraries` 0.0010888576507568
(257) DESCRIBE `ports` 0.0010340213775635
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034713745117188
(259) DESCRIBE `ports` 0.00099587440490723
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030708312988281
(261) DESCRIBE `ports` 0.001039981842041
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025105476379395
(263) DESCRIBE `sailingdates` 0.00084209442138672
(264) DESCRIBE `ports` 0.0010631084442139
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031185150146484
(266) DESCRIBE `ports` 0.00094389915466309
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00026702880859375
(268) DESCRIBE `ports` 0.00094199180603027
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00027179718017578
(270) DESCRIBE `ports` 0.00098490715026855
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00023794174194336
(272) DESCRIBE `ports` 0.0012869834899902
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00032615661621094
(274) DESCRIBE `ports` 0.00073599815368652
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00018000602722168
(276) DESCRIBE `ports` 0.00066709518432617
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00020384788513184
(278) DESCRIBE `ports` 0.00060391426086426
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00019693374633789
(280) DESCRIBE `ports` 0.00059890747070312
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00017499923706055
(282) DESCRIBE `ports` 0.00071811676025391
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0001838207244873
(284) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63371') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0051670074462891
(285) DESCRIBE `avid_specials` 0.00088191032409668
(286) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63371 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0012469291687012
(287) DESCRIBE `cruiselines` 0.0013470649719238
(288) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00025320053100586
(289) DESCRIBE `orchid_image` 0.0010449886322021
(290) DESCRIBE `cruiselines` 0.0016651153564453
(291) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00029587745666504
(292) DESCRIBE `cruises` 0.0018649101257324
(293) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '46218') 0.00034904479980469
(294) DESCRIBE `ships` 0.001906156539917
(295) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00039005279541016
(296) DESCRIBE `ships` 0.001967191696167
(297) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00031495094299316
(298) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002129077911377
(299) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019717216491699
(300) DESCRIBE `itineraries` 0.001183032989502
(301) DESCRIBE `ports` 0.0012779235839844
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003359317779541
(303) DESCRIBE `ports` 0.00098395347595215
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028705596923828
(305) DESCRIBE `ports` 0.00098800659179688
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00020384788513184
(307) DESCRIBE `sailingdates` 0.00078821182250977
(308) DESCRIBE `ports` 0.0009610652923584
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029206275939941
(310) DESCRIBE `ports` 0.00089287757873535
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022697448730469
(312) DESCRIBE `ports` 0.0007011890411377
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00021910667419434
(314) DESCRIBE `ports` 0.00065493583679199
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.0001680850982666
(316) DESCRIBE `ports` 0.00069499015808105
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00044393539428711
(318) DESCRIBE `ports` 0.0010650157928467
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00023698806762695
(320) DESCRIBE `ports` 0.00093698501586914
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00025010108947754
(322) DESCRIBE `ports` 0.00088787078857422
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.0002138614654541
(324) DESCRIBE `ports` 0.00094008445739746
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00024104118347168
(326) DESCRIBE `ports` 0.0008997917175293
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00023102760314941
(328) DESCRIBE `ports` 0.00087404251098633
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026106834411621
(330) DESCRIBE `ports` 0.00091910362243652
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002291202545166
(332) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '46218') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0096008777618408
(333) DESCRIBE `avid_specials` 0.00099611282348633
(334) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 46218 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.0015108585357666
(335) DESCRIBE `cruiselines` 0.0012900829315186
(336) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00031399726867676
(337) DESCRIBE `orchid_image` 0.00099682807922363
(338) DESCRIBE `cruiselines` 0.0044980049133301
(339) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00035190582275391
(340) DESCRIBE `cruises` 0.0017759799957275
(341) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50856') 0.00031805038452148
(342) DESCRIBE `ships` 0.0034210681915283
(343) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00051093101501465
(344) DESCRIBE `ships` 0.0019948482513428
(345) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00041079521179199
(346) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002140998840332
(347) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019598007202148
(348) DESCRIBE `itineraries` 0.0010409355163574
(349) DESCRIBE `ports` 0.0010230541229248
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029993057250977
(351) DESCRIBE `ports` 0.00091385841369629
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024890899658203
(353) DESCRIBE `ports` 0.00085783004760742
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002140998840332
(355) DESCRIBE `sailingdates` 0.00076508522033691
(356) DESCRIBE `ports` 0.00094890594482422
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028896331787109
(358) DESCRIBE `ports` 0.0011329650878906
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00024795532226562
(360) DESCRIBE `ports` 0.00083303451538086
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00024795532226562
(362) DESCRIBE `ports` 0.00087785720825195
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00022196769714355
(364) DESCRIBE `ports` 0.00085306167602539
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.0002598762512207
(366) DESCRIBE `ports` 0.00087118148803711
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00022196769714355
(368) DESCRIBE `ports` 0.00088596343994141
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00027298927307129
(370) DESCRIBE `ports` 0.00086212158203125
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.0002129077911377
(372) DESCRIBE `ports` 0.00081896781921387
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0012907981872559
(374) DESCRIBE `ports` 0.0011191368103027
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00028085708618164
(376) DESCRIBE `ports` 0.0010120868682861
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.0002739429473877
(378) DESCRIBE `ports` 0.00090718269348145
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00024318695068359
(380) DESCRIBE `ports` 0.00094485282897949
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042009353637695
(382) DESCRIBE `ports` 0.0010490417480469
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025510787963867
(384) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '50856') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0094380378723145
(385) DESCRIBE `avid_specials` 0.0010530948638916
(386) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 50856 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0016870498657227
(387) DESCRIBE `cruiselines` 0.0014519691467285
(388) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00033807754516602
(389) DESCRIBE `orchid_image` 0.0010638236999512
(390) DESCRIBE `cruiselines` 0.0013489723205566
(391) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00026297569274902
(392) DESCRIBE `cruises` 0.0023319721221924
(393) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63403') 0.00087809562683105
(394) DESCRIBE `ships` 0.0030009746551514
(395) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00055217742919922
(396) DESCRIBE `ships` 0.0019419193267822
(397) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00038385391235352
(398) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019502639770508
(399) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014686584472656
(400) DESCRIBE `itineraries` 0.0010898113250732
(401) DESCRIBE `ports` 0.001201868057251
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032210350036621
(403) DESCRIBE `ports` 0.001046895980835
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002739429473877
(405) DESCRIBE `ports` 0.00097203254699707
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025010108947754
(407) DESCRIBE `sailingdates` 0.00087189674377441
(408) DESCRIBE `ports` 0.0010290145874023
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025010108947754
(410) DESCRIBE `ports` 0.00062203407287598
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017786026000977
(412) DESCRIBE `ports` 0.0008540153503418
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00025296211242676
(414) DESCRIBE `ports` 0.000885009765625
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00023818016052246
(416) DESCRIBE `ports` 0.00082206726074219
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00026798248291016
(418) DESCRIBE `ports` 0.00092387199401855
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00022697448730469
(420) DESCRIBE `ports` 0.00067591667175293
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00023007392883301
(422) DESCRIBE `ports` 0.00075912475585938
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00018906593322754
(424) DESCRIBE `ports` 0.00063109397888184
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020313262939453
(426) DESCRIBE `ports` 0.00084304809570312
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018000602722168
(428) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63403') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0092542171478271
(429) DESCRIBE `avid_specials` 0.00084900856018066
(430) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63403 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.0009620189666748
(431) DESCRIBE `cruiselines` 0.0010089874267578
(432) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00022387504577637
(433) DESCRIBE `orchid_image` 0.0009000301361084
(434) DESCRIBE `cruiselines` 0.0014300346374512
(435) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00029492378234863
(436) DESCRIBE `cruises` 0.0013809204101562
(437) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63374') 0.00028681755065918
(438) DESCRIBE `ships` 0.0014779567718506
(439) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00036883354187012
(440) DESCRIBE `ships` 0.0018739700317383
(441) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00030398368835449
(442) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001978874206543
(443) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018000602722168
(444) DESCRIBE `itineraries` 0.00099682807922363
(445) DESCRIBE `ports` 0.00092291831970215
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029087066650391
(447) DESCRIBE `ports` 0.00081491470336914
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024008750915527
(449) DESCRIBE `ports` 0.00086498260498047
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023794174194336
(451) DESCRIBE `sailingdates` 0.00077009201049805
(452) DESCRIBE `ports` 0.0010139942169189
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032496452331543
(454) DESCRIBE `ports` 0.00081706047058105
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029397010803223
(456) DESCRIBE `ports` 0.0011360645294189
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00035810470581055
(458) DESCRIBE `ports` 0.0010929107666016
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00029206275939941
(460) DESCRIBE `ports` 0.00085783004760742
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00037002563476562
(462) DESCRIBE `ports` 0.0011510848999023
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00029301643371582
(464) DESCRIBE `ports` 0.0010077953338623
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00029683113098145
(466) DESCRIBE `ports` 0.00091195106506348
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.0003359317779541
(468) DESCRIBE `ports` 0.0010669231414795
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.0003349781036377
(470) DESCRIBE `ports` 0.00098204612731934
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00025200843811035
(472) DESCRIBE `ports` 0.0010101795196533
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029897689819336
(474) DESCRIBE `ports` 0.0010058879852295
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025486946105957
(476) SELECT `sailingdate_lowest_price`.`lowest_price` AS `price`, MIN(lowest_price) AS `int` FROM `sailingdate_lowest_price` WHERE (cruise_id = '63374') AND (sailingdate >= '2017-11-03') AND (sailingdate <= '2018-12-31') 0.0080258846282959
(477) DESCRIBE `avid_specials` 0.0011250972747803
(478) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63374 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0020029544830322
(479) DESCRIBE `cruiselines` 0.0016961097717285
(480) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00040483474731445
(481) DESCRIBE `orchid_image` 0.0012369155883789
(482) DESCRIBE `cruiselines` 0.0015571117401123
(483) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00034117698669434
(484) DESCRIBE `ships` 0.0022978782653809
(485) SELECT `ships`.* FROM `ships` WHERE (id IN ('4', '288')) ORDER BY FIND_IN_SET(id, '4,288') 0.00056695938110352
(486) DESCRIBE `cruisetypes` 0.0009770393371582
(487) DESCRIBE `destinations` 0.0013577938079834
(488) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8', '35')) ORDER BY FIND_IN_SET(id, '43,8,35') 0.00051498413085938
(489) DESCRIBE `cruiselines` 0.0016791820526123
(490) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00036120414733887
(491) DESCRIBE `cruiselines` 0.0015370845794678
(492) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00028204917907715