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

Total elapsed time: 0.29785537719727

# Query Time
(1) connect 0.00057315826416016
(2) DESCRIBE `cruises` 0.002112865447998
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (24582, 65476, 51443, 62583, 62173, 51447, 67243, 65482, 51422, 62584)) ORDER BY FIND_IN_SET(id, '24582,65476,51443,62583,62173,51447,67243,65482,51422,62584') 0.0018990039825439
(4) DESCRIBE `cruises` 0.0020749568939209
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '24582') 0.00033211708068848
(6) DESCRIBE `ships` 0.0021209716796875
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.00041389465332031
(8) DESCRIBE `ships` 0.0019011497497559
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00027799606323242
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018596649169922
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017595291137695
(12) DESCRIBE `itineraries` 0.00092387199401855
(13) DESCRIBE `ports` 0.0010299682617188
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00030088424682617
(15) DESCRIBE `ports` 0.0008389949798584
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00023579597473145
(17) DESCRIBE `ports` 0.00082612037658691
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0002129077911377
(19) DESCRIBE `sailingdates` 0.00071001052856445
(20) DESCRIBE `ports` 0.00089502334594727
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0002751350402832
(22) DESCRIBE `ports` 0.00081276893615723
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00026607513427734
(24) DESCRIBE `ports` 0.00087499618530273
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00024604797363281
(26) DESCRIBE `ports` 0.00077605247497559
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00024700164794922
(28) DESCRIBE `ports` 0.00078797340393066
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00023388862609863
(30) DESCRIBE `ports` 0.0007929801940918
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00020790100097656
(32) DESCRIBE `ports` 0.00078892707824707
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 437))) 0.00024986267089844
(34) DESCRIBE `ports` 0.00080990791320801
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '437') 0.00021195411682129
(36) DESCRIBE `ports` 0.00081300735473633
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00023102760314941
(38) DESCRIBE `ports` 0.00078797340393066
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00020098686218262
(40) DESCRIBE `avid_specials` 0.00074100494384766
(41) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 24582 and class = 'Cruise') OR (item_id = 573 AND class = 'Ship') OR (item_id = 37 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.0015199184417725
(42) DESCRIBE `cruiselines` 0.0013148784637451
(43) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00030994415283203
(44) DESCRIBE `orchid_image` 0.0010910034179688
(45) DESCRIBE `cruiselines` 0.0012681484222412
(46) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00026106834411621
(47) DESCRIBE `cruises` 0.0017111301422119
(48) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65476') 0.00030708312988281
(49) DESCRIBE `ships` 0.0018050670623779
(50) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1285))) 0.00038290023803711
(51) DESCRIBE `ships` 0.0018458366394043
(52) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1285') 0.00030398368835449
(53) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00019383430480957
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018191337585449
(55) DESCRIBE `itineraries` 0.00091314315795898
(56) DESCRIBE `ports` 0.0009000301361084
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002748966217041
(58) DESCRIBE `ports` 0.00079798698425293
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023198127746582
(60) DESCRIBE `ports` 0.00082588195800781
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022506713867188
(62) DESCRIBE `sailingdates` 0.00071310997009277
(63) DESCRIBE `ports` 0.00098180770874023
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029706954956055
(65) DESCRIBE `ports` 0.00084590911865234
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022602081298828
(67) DESCRIBE `ports` 0.00080704689025879
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024795532226562
(69) DESCRIBE `ports` 0.00084114074707031
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00021219253540039
(71) DESCRIBE `avid_specials` 0.00072312355041504
(72) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65476 and class = 'Cruise') OR (item_id = 1285 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0016200542449951
(73) DESCRIBE `cruiselines` 0.0013329982757568
(74) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00029993057250977
(75) DESCRIBE `orchid_image` 0.00098013877868652
(76) DESCRIBE `cruiselines` 0.0011661052703857
(77) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00025701522827148
(78) DESCRIBE `cruises` 0.0018758773803711
(79) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '51443') 0.00027918815612793
(80) DESCRIBE `ships` 0.0016870498657227
(81) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.00035500526428223
(82) DESCRIBE `ships` 0.0019879341125488
(83) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00029301643371582
(84) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00020098686218262
(85) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018596649169922
(86) DESCRIBE `itineraries` 0.00095915794372559
(87) DESCRIBE `ports` 0.00079989433288574
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00026082992553711
(89) DESCRIBE `ports` 0.00078296661376953
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00022602081298828
(91) DESCRIBE `ports` 0.00077581405639648
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00020790100097656
(93) DESCRIBE `sailingdates` 0.0007169246673584
(94) DESCRIBE `ports` 0.00084018707275391
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00028395652770996
(96) DESCRIBE `ports` 0.00096297264099121
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00028014183044434
(98) DESCRIBE `ports` 0.0008699893951416
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2040))) 0.00025796890258789
(100) DESCRIBE `ports` 0.00084018707275391
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2040') 0.00020909309387207
(102) DESCRIBE `ports` 0.00079989433288574
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024008750915527
(104) DESCRIBE `ports` 0.0007631778717041
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00021791458129883
(106) DESCRIBE `ports` 0.00088787078857422
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00024795532226562
(108) DESCRIBE `ports` 0.00087690353393555
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00023007392883301
(110) DESCRIBE `ports` 0.00089406967163086
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00023579597473145
(112) DESCRIBE `ports` 0.00082087516784668
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00021004676818848
(114) DESCRIBE `avid_specials` 0.00072383880615234
(115) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 51443 and class = 'Cruise') OR (item_id = 1284 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.00160813331604
(116) DESCRIBE `cruiselines` 0.0013539791107178
(117) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00028705596923828
(118) DESCRIBE `orchid_image` 0.0010190010070801
(119) DESCRIBE `cruiselines` 0.0012528896331787
(120) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00026798248291016
(121) DESCRIBE `cruises` 0.0018570423126221
(122) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62583') 0.00028586387634277
(123) DESCRIBE `ships` 0.0019910335540771
(124) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 765))) 0.00035619735717773
(125) DESCRIBE `ships` 0.0019960403442383
(126) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '765') 0.00029993057250977
(127) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00020813941955566
(128) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0001981258392334
(129) DESCRIBE `itineraries` 0.0010099411010742
(130) DESCRIBE `ports` 0.00089097023010254
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0002748966217041
(132) DESCRIBE `ports` 0.00089788436889648
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00025701522827148
(134) DESCRIBE `ports` 0.0008699893951416
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00022602081298828
(136) DESCRIBE `sailingdates` 0.00070905685424805
(137) DESCRIBE `ports` 0.00088405609130859
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00030994415283203
(139) DESCRIBE `ports` 0.00095701217651367
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00025582313537598
(141) DESCRIBE `ports` 0.00094699859619141
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.00029778480529785
(143) DESCRIBE `ports` 0.0010249614715576
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.00035715103149414
(145) DESCRIBE `ports` 0.0011248588562012
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00034213066101074
(147) DESCRIBE `ports` 0.0010581016540527
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00026798248291016
(149) DESCRIBE `ports` 0.00089693069458008
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3395))) 0.00026607513427734
(151) DESCRIBE `ports` 0.00082087516784668
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3395') 0.00022006034851074
(153) DESCRIBE `ports` 0.00087594985961914
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00023698806762695
(155) DESCRIBE `ports` 0.00078105926513672
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00020718574523926
(157) DESCRIBE `avid_specials` 0.00080513954162598
(158) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62583 and class = 'Cruise') OR (item_id = 765 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0015101432800293
(159) DESCRIBE `cruiselines` 0.001345157623291
(160) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00032520294189453
(161) DESCRIBE `orchid_image` 0.0010490417480469
(162) DESCRIBE `cruiselines` 0.0013620853424072
(163) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00028896331787109
(164) DESCRIBE `cruises` 0.0020260810852051
(165) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62173') 0.0003509521484375
(166) DESCRIBE `ships` 0.0021159648895264
(167) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00043106079101562
(168) DESCRIBE `ships` 0.0021138191223145
(169) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00052595138549805
(170) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00022602081298828
(171) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00020599365234375
(172) DESCRIBE `itineraries` 0.0010719299316406
(173) DESCRIBE `ports` 0.0011200904846191
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035595893859863
(175) DESCRIBE `ports` 0.00099897384643555
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025415420532227
(177) DESCRIBE `ports` 0.00086593627929688
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002291202545166
(179) DESCRIBE `sailingdates` 0.00081086158752441
(180) DESCRIBE `ports` 0.00093317031860352
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032305717468262
(182) DESCRIBE `ports` 0.00089907646179199
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023698806762695
(184) DESCRIBE `ports` 0.00088906288146973
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030398368835449
(186) DESCRIBE `ports` 0.00091290473937988
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00024795532226562
(188) DESCRIBE `ports` 0.00090503692626953
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023794174194336
(190) DESCRIBE `ports` 0.00088596343994141
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023412704467773
(192) DESCRIBE `avid_specials` 0.00080609321594238
(193) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62173 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0015959739685059
(194) DESCRIBE `cruiselines` 0.001474142074585
(195) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00032901763916016
(196) DESCRIBE `orchid_image` 0.001133918762207
(197) DESCRIBE `cruiselines` 0.00142502784729
(198) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00028705596923828
(199) DESCRIBE `cruises` 0.0020301342010498
(200) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '51447') 0.00037312507629395
(201) DESCRIBE `ships` 0.0021359920501709
(202) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1285))) 0.00044512748718262
(203) DESCRIBE `ships` 0.0021638870239258
(204) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1285') 0.00029182434082031
(205) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00021791458129883
(206) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00021004676818848
(207) DESCRIBE `itineraries` 0.00096011161804199
(208) DESCRIBE `ports` 0.0010218620300293
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00029706954956055
(210) DESCRIBE `ports` 0.00099897384643555
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028705596923828
(212) DESCRIBE `ports` 0.00095891952514648
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00024604797363281
(214) DESCRIBE `sailingdates` 0.00082612037658691
(215) DESCRIBE `ports` 0.001068115234375
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031900405883789
(217) DESCRIBE `ports` 0.00094914436340332
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002739429473877
(219) DESCRIBE `ports` 0.00086784362792969
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026988983154297
(221) DESCRIBE `ports` 0.00083589553833008
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00021815299987793
(223) DESCRIBE `ports` 0.00081491470336914
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025415420532227
(225) DESCRIBE `ports` 0.00080299377441406
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002129077911377
(227) DESCRIBE `avid_specials` 0.00072097778320312
(228) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 51447 and class = 'Cruise') OR (item_id = 1285 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0016388893127441
(229) DESCRIBE `cruiselines` 0.0015099048614502
(230) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00034213066101074
(231) DESCRIBE `orchid_image` 0.0010509490966797
(232) DESCRIBE `cruiselines` 0.001366138458252
(233) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00026702880859375
(234) DESCRIBE `cruises` 0.0017449855804443
(235) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67243') 0.00031614303588867
(236) DESCRIBE `ships` 0.0018100738525391
(237) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00039386749267578
(238) DESCRIBE `ships` 0.0017571449279785
(239) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00026202201843262
(240) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016307830810547
(241) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0001521110534668
(242) DESCRIBE `itineraries` 0.0008089542388916
(243) DESCRIBE `ports` 0.00069594383239746
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025796890258789
(245) DESCRIBE `ports` 0.00061392784118652
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00018620491027832
(247) DESCRIBE `ports` 0.00059294700622559
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017213821411133
(249) DESCRIBE `sailingdates` 0.00056886672973633
(250) DESCRIBE `ports` 0.00062179565429688
(251) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021791458129883
(252) DESCRIBE `ports` 0.00069689750671387
(253) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022602081298828
(254) DESCRIBE `ports` 0.00063896179199219
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2086))) 0.00020909309387207
(256) DESCRIBE `ports` 0.00070500373840332
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2086') 0.00017905235290527
(258) DESCRIBE `ports` 0.00060486793518066
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00022006034851074
(260) DESCRIBE `ports` 0.00068402290344238
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00017404556274414
(262) DESCRIBE `ports` 0.0006101131439209
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00020480155944824
(264) DESCRIBE `ports` 0.0006098747253418
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00018405914306641
(266) DESCRIBE `ports` 0.00063300132751465
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.0001990795135498
(268) DESCRIBE `ports` 0.0005948543548584
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00016903877258301
(270) DESCRIBE `ports` 0.00059604644775391
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00018906593322754
(272) DESCRIBE `ports` 0.00061988830566406
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00016593933105469
(274) DESCRIBE `avid_specials` 0.00053787231445312
(275) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67243 and class = 'Cruise') OR (item_id = 1402 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0011608600616455
(276) DESCRIBE `cruiselines` 0.0012719631195068
(277) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00031208992004395
(278) DESCRIBE `orchid_image` 0.0009760856628418
(279) DESCRIBE `cruiselines` 0.0013689994812012
(280) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00031495094299316
(281) DESCRIBE `cruises` 0.0021400451660156
(282) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65482') 0.0004420280456543
(283) DESCRIBE `ships` 0.0021378993988037
(284) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1285))) 0.0004270076751709
(285) DESCRIBE `ships` 0.0021979808807373
(286) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1285') 0.0003349781036377
(287) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0002140998840332
(288) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018787384033203
(289) DESCRIBE `itineraries` 0.00074291229248047
(290) DESCRIBE `ports` 0.0006859302520752
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023698806762695
(292) DESCRIBE `ports` 0.00067996978759766
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023317337036133
(294) DESCRIBE `ports` 0.00090312957763672
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025606155395508
(296) DESCRIBE `sailingdates` 0.0008540153503418
(297) DESCRIBE `ports` 0.001147985458374
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00037002563476562
(299) DESCRIBE `ports` 0.0010499954223633
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002601146697998
(301) DESCRIBE `ports` 0.00088810920715332
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00029087066650391
(303) DESCRIBE `ports` 0.0010221004486084
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.0002741813659668
(305) DESCRIBE `ports` 0.00093293190002441
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00027990341186523
(307) DESCRIBE `ports` 0.0009300708770752
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00025105476379395
(309) DESCRIBE `ports` 0.00094199180603027
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00026798248291016
(311) DESCRIBE `ports` 0.0009150505065918
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.0002281665802002
(313) DESCRIBE `ports` 0.00090909004211426
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00026488304138184
(315) DESCRIBE `ports` 0.00089597702026367
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00024199485778809
(317) DESCRIBE `ports` 0.0009000301361084
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027799606323242
(319) DESCRIBE `ports` 0.0009148120880127
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023698806762695
(321) DESCRIBE `avid_specials` 0.00082778930664062
(322) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65482 and class = 'Cruise') OR (item_id = 1285 AND class = 'Ship') OR (item_id = 37 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.0015101432800293
(323) DESCRIBE `cruiselines` 0.0014212131500244
(324) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00032901763916016
(325) DESCRIBE `orchid_image` 0.0011110305786133
(326) DESCRIBE `cruiselines` 0.0015499591827393
(327) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00034713745117188
(328) DESCRIBE `cruises` 0.0019028186798096
(329) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '51422') 0.00034189224243164
(330) DESCRIBE `ships` 0.0019140243530273
(331) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.00047111511230469
(332) DESCRIBE `ships` 0.0019490718841553
(333) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00030708312988281
(334) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00020098686218262
(335) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00019598007202148
(336) DESCRIBE `itineraries` 0.00079607963562012
(337) DESCRIBE `ports` 0.00076413154602051
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00024104118347168
(339) DESCRIBE `ports` 0.00084900856018066
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00024008750915527
(341) DESCRIBE `ports` 0.00084519386291504
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00024318695068359
(343) DESCRIBE `sailingdates` 0.00078392028808594
(344) DESCRIBE `ports` 0.00082707405090332
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00044798851013184
(346) DESCRIBE `ports` 0.0010271072387695
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00029706954956055
(348) DESCRIBE `ports` 0.0010659694671631
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 499))) 0.00031399726867676
(350) DESCRIBE `ports` 0.00092315673828125
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '499') 0.00025081634521484
(352) DESCRIBE `ports` 0.00084781646728516
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00025296211242676
(354) DESCRIBE `ports` 0.00081586837768555
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00023102760314941
(356) DESCRIBE `avid_specials` 0.00074100494384766
(357) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 51422 and class = 'Cruise') OR (item_id = 1284 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0015089511871338
(358) DESCRIBE `cruiselines` 0.0013439655303955
(359) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00031805038452148
(360) DESCRIBE `orchid_image` 0.0010199546813965
(361) DESCRIBE `cruiselines` 0.0012738704681396
(362) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00027799606323242
(363) DESCRIBE `cruises` 0.0017869472503662
(364) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62584') 0.00036096572875977
(365) DESCRIBE `ships` 0.0019209384918213
(366) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 765))) 0.00039792060852051
(367) DESCRIBE `ships` 0.0018990039825439
(368) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '765') 0.00030708312988281
(369) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.0002129077911377
(370) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00020503997802734
(371) DESCRIBE `itineraries` 0.0010161399841309
(372) DESCRIBE `ports` 0.0010209083557129
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00031518936157227
(374) DESCRIBE `ports` 0.0009000301361084
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00028300285339355
(376) DESCRIBE `ports` 0.00083112716674805
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0002448558807373
(378) DESCRIBE `sailingdates` 0.00071501731872559
(379) DESCRIBE `ports` 0.00089287757873535
(380) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00029802322387695
(381) DESCRIBE `ports` 0.00086188316345215
(382) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00024700164794922
(383) DESCRIBE `ports` 0.00082492828369141
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00025081634521484
(385) DESCRIBE `ports` 0.00081586837768555
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00023698806762695
(387) DESCRIBE `ports` 0.000823974609375
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00024104118347168
(389) DESCRIBE `ports` 0.00080680847167969
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00026988983154297
(391) DESCRIBE `ports` 0.00080585479736328
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00025105476379395
(393) DESCRIBE `ports` 0.00081801414489746
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.0002598762512207
(395) DESCRIBE `ports` 0.00081586837768555
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00025510787963867
(397) DESCRIBE `ports` 0.00083589553833008
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0002741813659668
(399) DESCRIBE `avid_specials` 0.00076889991760254
(400) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62584 and class = 'Cruise') OR (item_id = 765 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0016641616821289
(401) DESCRIBE `cruiselines` 0.001406192779541
(402) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00030994415283203
(403) DESCRIBE `orchid_image` 0.0010280609130859
(404) DESCRIBE `cruiselines` 0.0012321472167969
(405) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00028109550476074
(406) DESCRIBE `ships` 0.0021212100982666
(407) SELECT `ships`.* FROM `ships` WHERE (id IN ('573', '1285', '1402', '765', '1284')) ORDER BY FIND_IN_SET(id, '573,1285,1402,765,1284') 0.00065994262695312
(408) DESCRIBE `cruisetypes` 0.0010218620300293
(409) DESCRIBE `destinations` 0.0012040138244629
(410) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('8', '43', '35')) ORDER BY FIND_IN_SET(id, '8,43,35') 0.0004889965057373
(411) DESCRIBE `cruiselines` 0.0015709400177002
(412) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00036907196044922
(413) DESCRIBE `cruiselines` 0.0015599727630615
(414) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00033283233642578