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

Total elapsed time: 0.2584924697876

# Query Time
(1) connect 0.00050997734069824
(2) DESCRIBE `cruises` 0.0022521018981934
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (63403, 63374, 63402, 63461, 55703, 68795, 63373, 63401, 63460, 41777)) ORDER BY FIND_IN_SET(id, '63403,63374,63402,63461,55703,68795,63373,63401,63460,41777') 0.0014479160308838
(4) DESCRIBE `cruises` 0.0018730163574219
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63403') 0.00029706954956055
(6) DESCRIBE `ships` 0.00164794921875
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00029397010803223
(8) DESCRIBE `ships` 0.0014200210571289
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00026082992553711
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016307830810547
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015091896057129
(12) DESCRIBE `itineraries` 0.0007319450378418
(13) DESCRIBE `ports` 0.0010058879852295
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023889541625977
(15) DESCRIBE `ports` 0.00063490867614746
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020909309387207
(17) DESCRIBE `ports` 0.00089406967163086
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00024294853210449
(19) DESCRIBE `sailingdates` 0.00085306167602539
(20) DESCRIBE `ports` 0.0010452270507812
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032401084899902
(22) DESCRIBE `ports` 0.00099301338195801
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028586387634277
(24) DESCRIBE `ports` 0.00091791152954102
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.0002589225769043
(26) DESCRIBE `ports` 0.00084805488586426
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00021195411682129
(28) DESCRIBE `ports` 0.00075793266296387
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00022792816162109
(30) DESCRIBE `ports` 0.00083494186401367
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00020003318786621
(32) DESCRIBE `ports` 0.0007779598236084
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00022602081298828
(34) DESCRIBE `ports` 0.00082802772521973
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00020194053649902
(36) DESCRIBE `ports` 0.00078105926513672
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023508071899414
(38) DESCRIBE `ports` 0.00078701972961426
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023293495178223
(40) DESCRIBE `avid_specials` 0.00077414512634277
(41) 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.0014588832855225
(42) DESCRIBE `cruiselines` 0.001298189163208
(43) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00030183792114258
(44) DESCRIBE `orchid_image` 0.0011320114135742
(45) DESCRIBE `cruiselines` 0.0013608932495117
(46) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00029301643371582
(47) DESCRIBE `cruises` 0.0015590190887451
(48) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63374') 0.00024294853210449
(49) DESCRIBE `ships` 0.0011999607086182
(50) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00024294853210449
(51) DESCRIBE `ships` 0.0012600421905518
(52) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0002131462097168
(53) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016283988952637
(54) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015091896057129
(55) DESCRIBE `itineraries` 0.00063395500183105
(56) DESCRIBE `ports` 0.00069594383239746
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021910667419434
(58) DESCRIBE `ports` 0.00062894821166992
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00018501281738281
(60) DESCRIBE `ports` 0.00061607360839844
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017881393432617
(62) DESCRIBE `sailingdates` 0.00054383277893066
(63) DESCRIBE `ports` 0.0007021427154541
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023388862609863
(65) DESCRIBE `ports` 0.00060606002807617
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00020003318786621
(67) DESCRIBE `ports` 0.00059390068054199
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 448))) 0.00020503997802734
(69) DESCRIBE `ports` 0.00061202049255371
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '448') 0.00018596649169922
(71) DESCRIBE `ports` 0.00060009956359863
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00019216537475586
(73) DESCRIBE `ports` 0.000640869140625
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00016999244689941
(75) DESCRIBE `ports` 0.00060796737670898
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00020217895507812
(77) DESCRIBE `ports` 0.00070500373840332
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.0002129077911377
(79) DESCRIBE `ports` 0.00067782402038574
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00021505355834961
(81) DESCRIBE `ports` 0.00075984001159668
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.0001828670501709
(83) DESCRIBE `ports` 0.00072002410888672
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002281665802002
(85) DESCRIBE `ports` 0.00077104568481445
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019502639770508
(87) DESCRIBE `avid_specials` 0.00059700012207031
(88) 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.0008549690246582
(89) DESCRIBE `cruiselines` 0.0010330677032471
(90) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00024986267089844
(91) DESCRIBE `orchid_image` 0.00081896781921387
(92) DESCRIBE `cruiselines` 0.0010349750518799
(93) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0002138614654541
(94) DESCRIBE `cruises` 0.0013699531555176
(95) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63402') 0.0002899169921875
(96) DESCRIBE `ships` 0.0013020038604736
(97) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00026106834411621
(98) DESCRIBE `ships` 0.001349925994873
(99) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00020813941955566
(100) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016117095947266
(101) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015020370483398
(102) DESCRIBE `itineraries` 0.00069403648376465
(103) DESCRIBE `ports` 0.00065302848815918
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024199485778809
(105) DESCRIBE `ports` 0.00067305564880371
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021004676818848
(107) DESCRIBE `ports` 0.00067305564880371
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017595291137695
(109) DESCRIBE `sailingdates` 0.00053095817565918
(110) DESCRIBE `ports` 0.00070619583129883
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024986267089844
(112) DESCRIBE `ports` 0.00075483322143555
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00019979476928711
(114) DESCRIBE `ports` 0.00074315071105957
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00022506713867188
(116) DESCRIBE `ports` 0.00076508522033691
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00020885467529297
(118) DESCRIBE `ports` 0.00076699256896973
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00023102760314941
(120) DESCRIBE `ports` 0.00084710121154785
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00022697448730469
(122) DESCRIBE `ports` 0.00078296661376953
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0002439022064209
(124) DESCRIBE `ports` 0.00082516670227051
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00020503997802734
(126) DESCRIBE `avid_specials` 0.000640869140625
(127) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63402 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.00095105171203613
(128) DESCRIBE `cruiselines` 0.0010180473327637
(129) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00023388862609863
(130) DESCRIBE `orchid_image` 0.00074005126953125
(131) DESCRIBE `cruiselines` 0.00088191032409668
(132) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00020289421081543
(133) DESCRIBE `cruises` 0.0013880729675293
(134) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63461') 0.00026297569274902
(135) DESCRIBE `ships` 0.001190185546875
(136) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.0002448558807373
(137) DESCRIBE `ships` 0.001723051071167
(138) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00027084350585938
(139) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016403198242188
(140) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015091896057129
(141) DESCRIBE `itineraries` 0.00073719024658203
(142) DESCRIBE `ports` 0.00069594383239746
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00022983551025391
(144) DESCRIBE `ports` 0.00060892105102539
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00018811225891113
(146) DESCRIBE `ports` 0.00067400932312012
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00017714500427246
(148) DESCRIBE `sailingdates` 0.00057816505432129
(149) DESCRIBE `ports` 0.00065207481384277
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00023221969604492
(151) DESCRIBE `ports` 0.00060796737670898
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00018191337585449
(153) DESCRIBE `ports` 0.00058698654174805
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00018882751464844
(155) DESCRIBE `ports` 0.00058197975158691
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00016498565673828
(157) DESCRIBE `ports` 0.00061202049255371
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.0001838207244873
(159) DESCRIBE `ports` 0.00058794021606445
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00016498565673828
(161) DESCRIBE `ports` 0.00057315826416016
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00017595291137695
(163) DESCRIBE `ports` 0.00060391426086426
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00016403198242188
(165) DESCRIBE `ports` 0.00065279006958008
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00019097328186035
(167) DESCRIBE `ports` 0.00059413909912109
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00016903877258301
(169) DESCRIBE `ports` 0.00063395500183105
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00018811225891113
(171) DESCRIBE `ports` 0.00058817863464355
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00017404556274414
(173) DESCRIBE `avid_specials` 0.0005497932434082
(174) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63461 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.001413106918335
(175) DESCRIBE `cruiselines` 0.0013558864593506
(176) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00035190582275391
(177) DESCRIBE `orchid_image` 0.0011930465698242
(178) DESCRIBE `cruiselines` 0.0014550685882568
(179) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00029802322387695
(180) DESCRIBE `cruises` 0.0017831325531006
(181) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55703') 0.00026702880859375
(182) DESCRIBE `ships` 0.0016579627990723
(183) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00032687187194824
(184) DESCRIBE `ships` 0.0021989345550537
(185) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00030517578125
(186) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00022315979003906
(187) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020194053649902
(188) DESCRIBE `itineraries` 0.0010230541229248
(189) DESCRIBE `ports` 0.00094389915466309
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030398368835449
(191) DESCRIBE `ports` 0.00095415115356445
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00026583671569824
(193) DESCRIBE `ports` 0.00094103813171387
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00025510787963867
(195) DESCRIBE `sailingdates` 0.00084495544433594
(196) DESCRIBE `ports` 0.0011320114135742
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031089782714844
(198) DESCRIBE `ports` 0.0009310245513916
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00021696090698242
(200) DESCRIBE `ports` 0.00079703330993652
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00022602081298828
(202) DESCRIBE `ports` 0.0007789134979248
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00020408630371094
(204) DESCRIBE `ports` 0.00084495544433594
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023889541625977
(206) DESCRIBE `ports` 0.0007929801940918
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00023794174194336
(208) DESCRIBE `avid_specials` 0.00096797943115234
(209) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55703 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0015060901641846
(210) DESCRIBE `cruiselines` 0.0014071464538574
(211) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00031185150146484
(212) DESCRIBE `orchid_image` 0.001060962677002
(213) DESCRIBE `cruiselines` 0.001492977142334
(214) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00028681755065918
(215) DESCRIBE `cruises` 0.0019998550415039
(216) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68795') 0.00033903121948242
(217) DESCRIBE `ships` 0.0019791126251221
(218) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00041007995605469
(219) DESCRIBE `ships` 0.0017681121826172
(220) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00033402442932129
(221) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019598007202148
(222) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(223) DESCRIBE `itineraries` 0.0009300708770752
(224) DESCRIBE `ports` 0.0010859966278076
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003058910369873
(226) DESCRIBE `ports` 0.00093698501586914
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027990341186523
(228) DESCRIBE `ports` 0.00091409683227539
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00024700164794922
(230) DESCRIBE `sailingdates` 0.00083303451538086
(231) DESCRIBE `ports` 0.00095486640930176
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030994415283203
(233) DESCRIBE `ports` 0.00095510482788086
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00024199485778809
(235) DESCRIBE `ports` 0.00090694427490234
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00027012825012207
(237) DESCRIBE `ports` 0.00096392631530762
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00023913383483887
(239) DESCRIBE `ports` 0.00089788436889648
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00026988983154297
(241) DESCRIBE `ports` 0.00094199180603027
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00023317337036133
(243) DESCRIBE `ports` 0.00080084800720215
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.0002288818359375
(245) DESCRIBE `ports` 0.00081682205200195
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00020003318786621
(247) DESCRIBE `ports` 0.00080108642578125
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023508071899414
(249) DESCRIBE `ports` 0.00084209442138672
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00022506713867188
(251) DESCRIBE `avid_specials` 0.00081110000610352
(252) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68795 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0015039443969727
(253) DESCRIBE `cruiselines` 0.0014059543609619
(254) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0003349781036377
(255) DESCRIBE `orchid_image` 0.0010969638824463
(256) DESCRIBE `cruiselines` 0.0013558864593506
(257) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0003049373626709
(258) DESCRIBE `cruises` 0.0019731521606445
(259) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63373') 0.0003199577331543
(260) DESCRIBE `ships` 0.0019659996032715
(261) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00034999847412109
(262) DESCRIBE `ships` 0.0017399787902832
(263) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0002448558807373
(264) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020098686218262
(265) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017905235290527
(266) DESCRIBE `itineraries` 0.00090885162353516
(267) DESCRIBE `ports` 0.00092411041259766
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032591819763184
(269) DESCRIBE `ports` 0.00069284439086914
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021791458129883
(271) DESCRIBE `ports` 0.00063681602478027
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018501281738281
(273) DESCRIBE `sailingdates` 0.00055789947509766
(274) DESCRIBE `ports` 0.00080299377441406
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00025820732116699
(276) DESCRIBE `ports` 0.00069403648376465
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017809867858887
(278) DESCRIBE `ports` 0.00059914588928223
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00018787384033203
(280) DESCRIBE `ports` 0.0006101131439209
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00016403198242188
(282) DESCRIBE `ports` 0.00057888031005859
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00020503997802734
(284) DESCRIBE `ports` 0.00060892105102539
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00016593933105469
(286) DESCRIBE `ports` 0.00061893463134766
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00018405914306641
(288) DESCRIBE `ports` 0.00063896179199219
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.0001678466796875
(290) DESCRIBE `ports` 0.00058412551879883
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00019097328186035
(292) DESCRIBE `ports` 0.00062823295593262
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00016498565673828
(294) DESCRIBE `ports` 0.00058197975158691
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00018692016601562
(296) DESCRIBE `ports` 0.00071001052856445
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00017285346984863
(298) DESCRIBE `ports` 0.0006411075592041
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002138614654541
(300) DESCRIBE `ports` 0.00074005126953125
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017189979553223
(302) DESCRIBE `avid_specials` 0.00055789947509766
(303) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63373 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.00087809562683105
(304) DESCRIBE `cruiselines` 0.00087308883666992
(305) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00021004676818848
(306) DESCRIBE `orchid_image` 0.00068998336791992
(307) DESCRIBE `cruiselines` 0.00084304809570312
(308) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00019001960754395
(309) DESCRIBE `cruises` 0.0012388229370117
(310) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63401') 0.00021600723266602
(311) DESCRIBE `ships` 0.0012528896331787
(312) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00026702880859375
(313) DESCRIBE `ships` 0.0012950897216797
(314) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00018310546875
(315) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016283988952637
(316) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00015997886657715
(317) DESCRIBE `itineraries` 0.00060915946960449
(318) DESCRIBE `ports` 0.00060081481933594
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0001981258392334
(320) DESCRIBE `ports` 0.00059294700622559
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00019192695617676
(322) DESCRIBE `ports` 0.00062894821166992
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00017118453979492
(324) DESCRIBE `sailingdates` 0.00057411193847656
(325) DESCRIBE `ports` 0.00093793869018555
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00036096572875977
(327) DESCRIBE `ports` 0.00066995620727539
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00017714500427246
(329) DESCRIBE `ports` 0.00059294700622559
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00019001960754395
(331) DESCRIBE `ports` 0.00058913230895996
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00016283988952637
(333) DESCRIBE `ports` 0.00060510635375977
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0001828670501709
(335) DESCRIBE `ports` 0.00062894821166992
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00017404556274414
(337) DESCRIBE `avid_specials` 0.00058293342590332
(338) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63401 and class = 'Cruise') OR (item_id = 288 AND class = 'Ship') OR (item_id = 4 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.00090503692626953
(339) DESCRIBE `cruiselines` 0.0009160041809082
(340) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00021600723266602
(341) DESCRIBE `orchid_image` 0.00071287155151367
(342) DESCRIBE `cruiselines` 0.00084304809570312
(343) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00018596649169922
(344) DESCRIBE `cruises` 0.0012788772583008
(345) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63460') 0.00021886825561523
(346) DESCRIBE `ships` 0.0012171268463135
(347) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 288))) 0.00029802322387695
(348) DESCRIBE `ships` 0.0012319087982178
(349) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '288') 0.00018310546875
(350) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016117095947266
(351) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00014996528625488
(352) DESCRIBE `itineraries` 0.00062203407287598
(353) DESCRIBE `ports` 0.00061917304992676
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00021600723266602
(355) DESCRIBE `ports` 0.00066685676574707
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00018596649169922
(357) DESCRIBE `ports` 0.00065898895263672
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00017380714416504
(359) DESCRIBE `sailingdates` 0.00053286552429199
(360) DESCRIBE `ports` 0.00060796737670898
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00021100044250488
(362) DESCRIBE `ports` 0.00061488151550293
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00016593933105469
(364) DESCRIBE `ports` 0.00058197975158691
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00023388862609863
(366) DESCRIBE `ports` 0.00075483322143555
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00017595291137695
(368) DESCRIBE `ports` 0.00062108039855957
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00019192695617676
(370) DESCRIBE `ports` 0.00059700012207031
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00016522407531738
(372) DESCRIBE `ports` 0.00058102607727051
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00017809867858887
(374) DESCRIBE `ports` 0.00060701370239258
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00016093254089355
(376) DESCRIBE `ports` 0.00058507919311523
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00018596649169922
(378) DESCRIBE `ports` 0.00059700012207031
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00016188621520996
(380) DESCRIBE `ports` 0.00062108039855957
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00017786026000977
(382) DESCRIBE `ports` 0.00066184997558594
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00015997886657715
(384) DESCRIBE `avid_specials` 0.00053286552429199
(385) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63460 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.0008690357208252
(386) DESCRIBE `cruiselines` 0.00090789794921875
(387) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00021505355834961
(388) DESCRIBE `orchid_image` 0.00072884559631348
(389) DESCRIBE `cruiselines` 0.0011160373687744
(390) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00022196769714355
(391) DESCRIBE `cruises` 0.0012481212615967
(392) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41777') 0.00022196769714355
(393) DESCRIBE `ships` 0.0013518333435059
(394) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00030112266540527
(395) DESCRIBE `ships` 0.0019090175628662
(396) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00036287307739258
(397) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021791458129883
(398) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020909309387207
(399) DESCRIBE `itineraries` 0.0010759830474854
(400) DESCRIBE `ports` 0.00089502334594727
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027298927307129
(402) DESCRIBE `ports` 0.00078392028808594
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00018596649169922
(404) DESCRIBE `ports` 0.00061702728271484
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017309188842773
(406) DESCRIBE `sailingdates` 0.00057005882263184
(407) DESCRIBE `ports` 0.00069904327392578
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00024199485778809
(409) DESCRIBE `ports` 0.00058913230895996
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017189979553223
(411) DESCRIBE `ports` 0.00058698654174805
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00019001960754395
(413) DESCRIBE `ports` 0.00064897537231445
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00018906593322754
(415) DESCRIBE `ports` 0.00058603286743164
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00018191337585449
(417) DESCRIBE `ports` 0.00058388710021973
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00015997886657715
(419) DESCRIBE `ports` 0.00058913230895996
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0001838207244873
(421) DESCRIBE `ports` 0.00057888031005859
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00017809867858887
(423) DESCRIBE `avid_specials` 0.0005338191986084
(424) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41777 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.00084900856018066
(425) DESCRIBE `cruiselines` 0.00090503692626953
(426) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00021195411682129
(427) DESCRIBE `orchid_image` 0.00069403648376465
(428) DESCRIBE `cruiselines` 0.00088000297546387
(429) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00018978118896484
(430) DESCRIBE `ships` 0.0017049312591553
(431) SELECT `ships`.* FROM `ships` WHERE (id IN ('4', '288')) ORDER BY FIND_IN_SET(id, '4,288') 0.00059199333190918
(432) DESCRIBE `cruisetypes` 0.00091791152954102
(433) DESCRIBE `destinations` 0.0012509822845459
(434) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8', '35')) ORDER BY FIND_IN_SET(id, '43,8,35') 0.00049591064453125
(435) DESCRIBE `cruiselines` 0.0015521049499512
(436) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0003211498260498
(437) DESCRIBE `cruiselines` 0.0015950202941895
(438) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0003819465637207