or, enquire about your chosen options

  1. REVIEW: P & O Australia’s Pacific Aria
  2. Catch Up on Cruising: Latest News in bite size!
  3. Asian Adventures with Zuleika from the Cruise Factor Team
  4. A short cruise is a good cruise!!
  5. SPOTLIGHT ON: Symphony of the Seas

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

Total elapsed time: 0.26574420928955

# Query Time
(1) connect 0.00050806999206543
(2) DESCRIBE `cruises` 0.0016601085662842
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (64368, 67148, 65470, 62162, 71263, 62568, 71247, 67150, 67178, 62153)) ORDER BY FIND_IN_SET(id, '64368,67148,65470,62162,71263,62568,71247,67150,67178,62153') 0.00092792510986328
(4) DESCRIBE `cruises` 0.002500057220459
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '64368') 0.00023293495178223
(6) DESCRIBE `ships` 0.0014519691467285
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 573))) 0.00025486946105957
(8) DESCRIBE `ships` 0.001349925994873
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '573') 0.00019216537475586
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001978874206543
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017499923706055
(12) DESCRIBE `itineraries` 0.00075483322143555
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '64368') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0021579265594482
(14) DESCRIBE `ports` 0.00092816352844238
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00025200843811035
(16) DESCRIBE `ports` 0.00067281723022461
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00019693374633789
(18) DESCRIBE `ports` 0.00066208839416504
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00018191337585449
(20) DESCRIBE `sailingdates` 0.00060582160949707
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '64368') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0021731853485107
(22) DESCRIBE `ports` 0.0012340545654297
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00032591819763184
(24) DESCRIBE `ports` 0.00095200538635254
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00024294853210449
(26) DESCRIBE `ports` 0.00093388557434082
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00026798248291016
(28) DESCRIBE `ports` 0.00093388557434082
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00022983551025391
(30) DESCRIBE `ports` 0.00069689750671387
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00020408630371094
(32) DESCRIBE `ports` 0.00073599815368652
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00019097328186035
(34) DESCRIBE `ports` 0.00066804885864258
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00020098686218262
(36) DESCRIBE `ports` 0.00066518783569336
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00021100044250488
(38) DESCRIBE `ports` 0.00066208839416504
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00020599365234375
(40) DESCRIBE `ports` 0.0006558895111084
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00018119812011719
(42) DESCRIBE `avid_specials` 0.00069499015808105
(43) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 64368 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.0010859966278076
(44) DESCRIBE `cruiselines` 0.0009760856628418
(45) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00022482872009277
(46) DESCRIBE `orchid_image` 0.00074911117553711
(47) DESCRIBE `cruiselines` 0.0011382102966309
(48) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.0001828670501709
(49) DESCRIBE `cruises` 0.0014078617095947
(50) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67148') 0.00020313262939453
(51) DESCRIBE `ships` 0.001255989074707
(52) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 765))) 0.00023579597473145
(53) DESCRIBE `ships` 0.0012729167938232
(54) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '765') 0.00018191337585449
(55) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018596649169922
(56) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016999244689941
(57) DESCRIBE `itineraries` 0.00066208839416504
(58) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67148') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00079488754272461
(59) DESCRIBE `ports` 0.0010781288146973
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00026702880859375
(61) DESCRIBE `ports` 0.00070691108703613
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00021505355834961
(63) DESCRIBE `ports` 0.00067520141601562
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00019407272338867
(65) DESCRIBE `sailingdates` 0.00065898895263672
(66) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67148') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0005950927734375
(67) DESCRIBE `ports` 0.00072407722473145
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00021910667419434
(69) DESCRIBE `ports` 0.00069594383239746
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00018501281738281
(71) DESCRIBE `ports` 0.0006859302520752
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1901))) 0.00020790100097656
(73) DESCRIBE `ports` 0.00066399574279785
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1901') 0.00018191337585449
(75) DESCRIBE `ports` 0.00069999694824219
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1902))) 0.00021815299987793
(77) DESCRIBE `ports` 0.00070095062255859
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1902') 0.00018501281738281
(79) DESCRIBE `ports` 0.0006859302520752
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00020289421081543
(81) DESCRIBE `ports` 0.00070786476135254
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00023007392883301
(83) DESCRIBE `ports` 0.00067591667175293
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00020599365234375
(85) DESCRIBE `ports` 0.00066900253295898
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00018215179443359
(87) DESCRIBE `ports` 0.0006868839263916
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0001990795135498
(89) DESCRIBE `ports` 0.00067710876464844
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00018095970153809
(91) DESCRIBE `avid_specials` 0.00080394744873047
(92) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67148 and class = 'Cruise') OR (item_id = 765 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.0018970966339111
(93) DESCRIBE `cruiselines` 0.0015060901641846
(94) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00049400329589844
(95) DESCRIBE `orchid_image` 0.0009758472442627
(96) DESCRIBE `cruiselines` 0.001007080078125
(97) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00019407272338867
(98) DESCRIBE `cruises` 0.002202033996582
(99) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65470') 0.00030398368835449
(100) DESCRIBE `ships` 0.0019748210906982
(101) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.00036001205444336
(102) DESCRIBE `ships` 0.0019528865814209
(103) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00025200843811035
(104) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026798248291016
(105) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00023293495178223
(106) DESCRIBE `itineraries` 0.0010170936584473
(107) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65470') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012338161468506
(108) DESCRIBE `ports` 0.0011470317840576
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00031590461730957
(110) DESCRIBE `ports` 0.00099897384643555
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00026583671569824
(112) DESCRIBE `ports` 0.0010278224945068
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00026202201843262
(114) DESCRIBE `sailingdates` 0.00071001052856445
(115) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65470') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00058817863464355
(116) DESCRIBE `ports` 0.00072097778320312
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00021505355834961
(118) DESCRIBE `ports` 0.00069308280944824
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00018477439880371
(120) DESCRIBE `ports` 0.0007169246673584
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2090))) 0.00022697448730469
(122) DESCRIBE `ports` 0.00080609321594238
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2090') 0.0002140998840332
(124) DESCRIBE `ports` 0.00092697143554688
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1319))) 0.00021600723266602
(126) DESCRIBE `ports` 0.00067591667175293
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1319') 0.00021696090698242
(128) DESCRIBE `ports` 0.00074601173400879
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 791))) 0.00020289421081543
(130) DESCRIBE `ports` 0.00067901611328125
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '791') 0.00018191337585449
(132) DESCRIBE `ports` 0.00070905685424805
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4650))) 0.00024199485778809
(134) DESCRIBE `ports` 0.00070381164550781
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4650') 0.00018596649169922
(136) DESCRIBE `ports` 0.0006721019744873
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5306))) 0.00021004676818848
(138) DESCRIBE `ports` 0.00081300735473633
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5306') 0.00020599365234375
(140) DESCRIBE `ports` 0.00078701972961426
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00024223327636719
(142) DESCRIBE `ports` 0.00072789192199707
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00018692016601562
(144) DESCRIBE `avid_specials` 0.00087094306945801
(145) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65470 and class = 'Cruise') OR (item_id = 1284 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.0010881423950195
(146) DESCRIBE `cruiselines` 0.0010230541229248
(147) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00024509429931641
(148) DESCRIBE `orchid_image` 0.00075101852416992
(149) DESCRIBE `cruiselines` 0.0010337829589844
(150) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00022196769714355
(151) DESCRIBE `cruises` 0.0013551712036133
(152) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62162') 0.00021696090698242
(153) DESCRIBE `ships` 0.0012948513031006
(154) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.0002901554107666
(155) DESCRIBE `ships` 0.0015928745269775
(156) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00020694732666016
(157) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018906593322754
(158) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017404556274414
(159) DESCRIBE `itineraries` 0.00067806243896484
(160) DESCRIBE `ports` 0.00068902969360352
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022196769714355
(162) DESCRIBE `ports` 0.00067901611328125
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020503997802734
(164) DESCRIBE `ports` 0.00067806243896484
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018596649169922
(166) DESCRIBE `sailingdates` 0.00061297416687012
(167) DESCRIBE `ports` 0.00069499015808105
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022506713867188
(169) DESCRIBE `ports` 0.00067400932312012
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018596649169922
(171) DESCRIBE `ports` 0.0006721019744873
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00019979476928711
(173) DESCRIBE `ports` 0.00068306922912598
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018501281738281
(175) DESCRIBE `avid_specials` 0.00061488151550293
(176) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62162 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.00094795227050781
(177) DESCRIBE `cruiselines` 0.00099802017211914
(178) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00022506713867188
(179) DESCRIBE `orchid_image` 0.00076389312744141
(180) DESCRIBE `cruiselines` 0.00091910362243652
(181) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00018596649169922
(182) DESCRIBE `cruises` 0.0012681484222412
(183) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71263') 0.00020885467529297
(184) DESCRIBE `ships` 0.0014748573303223
(185) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1285))) 0.00025701522827148
(186) DESCRIBE `ships` 0.001284122467041
(187) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1285') 0.00018501281738281
(188) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00022387504577637
(189) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017595291137695
(190) DESCRIBE `itineraries` 0.0006721019744873
(191) DESCRIBE `ports` 0.00070285797119141
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022006034851074
(193) DESCRIBE `ports` 0.0006861686706543
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020313262939453
(195) DESCRIBE `ports` 0.00072908401489258
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00021219253540039
(197) DESCRIBE `sailingdates` 0.00061511993408203
(198) DESCRIBE `ports` 0.00068378448486328
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020885467529297
(200) DESCRIBE `ports` 0.00069212913513184
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018405914306641
(202) DESCRIBE `ports` 0.00067496299743652
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020003318786621
(204) DESCRIBE `ports` 0.00067806243896484
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018310546875
(206) DESCRIBE `avid_specials` 0.00063395500183105
(207) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71263 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.00095200538635254
(208) DESCRIBE `cruiselines` 0.0012428760528564
(209) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00027680397033691
(210) DESCRIBE `orchid_image` 0.00081110000610352
(211) DESCRIBE `cruiselines` 0.0011467933654785
(212) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00022387504577637
(213) DESCRIBE `cruises` 0.0014269351959229
(214) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62568') 0.00026702880859375
(215) DESCRIBE `ships` 0.0014100074768066
(216) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1285))) 0.00027012825012207
(217) DESCRIBE `ships` 0.0014150142669678
(218) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1285') 0.00019097328186035
(219) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018692016601562
(220) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017595291137695
(221) DESCRIBE `itineraries` 0.0006868839263916
(222) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62568') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00055098533630371
(223) DESCRIBE `ports` 0.00073909759521484
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022196769714355
(225) DESCRIBE `ports` 0.00068283081054688
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020599365234375
(227) DESCRIBE `ports` 0.00077605247497559
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018596649169922
(229) DESCRIBE `sailingdates` 0.00060701370239258
(230) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62568') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0004880428314209
(231) DESCRIBE `ports` 0.00071310997009277
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020813941955566
(233) DESCRIBE `ports` 0.00070095062255859
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018405914306641
(235) DESCRIBE `ports` 0.00067806243896484
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00020980834960938
(237) DESCRIBE `ports` 0.00067400932312012
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00018692016601562
(239) DESCRIBE `ports` 0.00069999694824219
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00020217895507812
(241) DESCRIBE `ports` 0.0006718635559082
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00018692016601562
(243) DESCRIBE `ports` 0.00067400932312012
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 734))) 0.00020003318786621
(245) DESCRIBE `ports` 0.00067019462585449
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '734') 0.00018405914306641
(247) DESCRIBE `ports` 0.0006721019744873
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00020599365234375
(249) DESCRIBE `ports` 0.00080299377441406
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00018310546875
(251) DESCRIBE `ports` 0.00068497657775879
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00020599365234375
(253) DESCRIBE `ports` 0.00067400932312012
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00018405914306641
(255) DESCRIBE `ports` 0.00070691108703613
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00020408630371094
(257) DESCRIBE `ports` 0.00068879127502441
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0001828670501709
(259) DESCRIBE `avid_specials` 0.00061893463134766
(260) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62568 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.00094795227050781
(261) DESCRIBE `cruiselines` 0.0010099411010742
(262) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00022196769714355
(263) DESCRIBE `orchid_image` 0.00080084800720215
(264) DESCRIBE `cruiselines` 0.00092506408691406
(265) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00022411346435547
(266) DESCRIBE `cruises` 0.0014679431915283
(267) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71247') 0.00029087066650391
(268) DESCRIBE `ships` 0.0017421245574951
(269) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00037121772766113
(270) DESCRIBE `ships` 0.0017390251159668
(271) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00027608871459961
(272) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00023102760314941
(273) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00021815299987793
(274) DESCRIBE `itineraries` 0.00099587440490723
(275) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '71247') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0013830661773682
(276) DESCRIBE `ports` 0.0007939338684082
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00023508071899414
(278) DESCRIBE `ports` 0.00068783760070801
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028204917907715
(280) DESCRIBE `ports` 0.00084114074707031
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0001978874206543
(282) DESCRIBE `sailingdates` 0.00062799453735352
(283) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '71247') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00091385841369629
(284) DESCRIBE `ports` 0.0012819766998291
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027680397033691
(286) DESCRIBE `ports` 0.00071191787719727
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0001990795135498
(288) DESCRIBE `ports` 0.00069904327392578
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00020790100097656
(290) DESCRIBE `ports` 0.00068402290344238
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00020313262939453
(292) DESCRIBE `ports` 0.00067782402038574
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00021100044250488
(294) DESCRIBE `ports` 0.0008389949798584
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00019502639770508
(296) DESCRIBE `ports` 0.00093293190002441
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021100044250488
(298) DESCRIBE `ports` 0.00070405006408691
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018715858459473
(300) DESCRIBE `avid_specials` 0.00066494941711426
(301) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71247 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.00095796585083008
(302) DESCRIBE `cruiselines` 0.0010068416595459
(303) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00022101402282715
(304) DESCRIBE `orchid_image` 0.00084114074707031
(305) DESCRIBE `cruiselines` 0.00094389915466309
(306) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00020790100097656
(307) DESCRIBE `cruises` 0.0013449192047119
(308) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67150') 0.00020003318786621
(309) DESCRIBE `ships` 0.0012969970703125
(310) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 765))) 0.00025296211242676
(311) DESCRIBE `ships` 0.0013101100921631
(312) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '765') 0.00018811225891113
(313) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018596649169922
(314) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017404556274414
(315) DESCRIBE `itineraries` 0.00067710876464844
(316) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67150') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00035905838012695
(317) DESCRIBE `ports` 0.0007631778717041
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00022292137145996
(319) DESCRIBE `ports` 0.00070381164550781
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00020003318786621
(321) DESCRIBE `ports` 0.00069689750671387
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00018596649169922
(323) DESCRIBE `sailingdates` 0.00061488151550293
(324) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67150') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00035691261291504
(325) DESCRIBE `ports` 0.0007789134979248
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00020694732666016
(327) DESCRIBE `ports` 0.00074100494384766
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00018715858459473
(329) DESCRIBE `ports` 0.00097799301147461
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00027585029602051
(331) DESCRIBE `ports` 0.0010221004486084
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00019502639770508
(333) DESCRIBE `ports` 0.00074100494384766
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00021195411682129
(335) DESCRIBE `ports` 0.00067782402038574
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00018477439880371
(337) DESCRIBE `ports` 0.00071883201599121
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1758))) 0.00020503997802734
(339) DESCRIBE `ports` 0.00069499015808105
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1758') 0.00018811225891113
(341) DESCRIBE `ports` 0.00068092346191406
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00020503997802734
(343) DESCRIBE `ports` 0.00067615509033203
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00020194053649902
(345) DESCRIBE `avid_specials` 0.00068497657775879
(346) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67150 and class = 'Cruise') OR (item_id = 765 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.0013139247894287
(347) DESCRIBE `cruiselines` 0.0010759830474854
(348) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00023889541625977
(349) DESCRIBE `orchid_image` 0.00079703330993652
(350) DESCRIBE `cruiselines` 0.00098991394042969
(351) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00020503997802734
(352) DESCRIBE `cruises` 0.001492977142334
(353) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67178') 0.00024509429931641
(354) DESCRIBE `ships` 0.0015029907226562
(355) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.0002739429473877
(356) DESCRIBE `ships` 0.001978874206543
(357) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00024795532226562
(358) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00023508071899414
(359) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00019288063049316
(360) DESCRIBE `itineraries` 0.00087094306945801
(361) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67178') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00042200088500977
(362) DESCRIBE `ports` 0.00087189674377441
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.0002901554107666
(364) DESCRIBE `ports` 0.00079894065856934
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00020289421081543
(366) DESCRIBE `ports` 0.00081181526184082
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0002138614654541
(368) DESCRIBE `sailingdates` 0.00069212913513184
(369) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67178') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00037097930908203
(370) DESCRIBE `ports` 0.00082206726074219
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00022315979003906
(372) DESCRIBE `ports` 0.00082588195800781
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00019001960754395
(374) DESCRIBE `ports` 0.00081992149353027
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 499))) 0.00021219253540039
(376) DESCRIBE `ports` 0.00076007843017578
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '499') 0.00022602081298828
(378) DESCRIBE `ports` 0.00074291229248047
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 121))) 0.00021100044250488
(380) DESCRIBE `ports` 0.0007178783416748
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '121') 0.00020003318786621
(382) DESCRIBE `ports` 0.00074386596679688
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00020694732666016
(384) DESCRIBE `ports` 0.00071191787719727
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00018620491027832
(386) DESCRIBE `ports` 0.0006871223449707
(387) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00020289421081543
(388) DESCRIBE `ports` 0.00067901611328125
(389) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00018405914306641
(390) DESCRIBE `ports` 0.000823974609375
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2895))) 0.00021219253540039
(392) DESCRIBE `ports` 0.00086498260498047
(393) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2895') 0.00019502639770508
(394) DESCRIBE `ports` 0.00071501731872559
(395) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00020408630371094
(396) DESCRIBE `ports` 0.00069904327392578
(397) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00018405914306641
(398) DESCRIBE `avid_specials` 0.00062012672424316
(399) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67178 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.00099706649780273
(400) DESCRIBE `cruiselines` 0.0010039806365967
(401) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00022292137145996
(402) DESCRIBE `orchid_image` 0.00076198577880859
(403) DESCRIBE `cruiselines` 0.0009310245513916
(404) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00018501281738281
(405) DESCRIBE `cruises` 0.0013461112976074
(406) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '62153') 0.00021600723266602
(407) DESCRIBE `ships` 0.0013759136199951
(408) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1402))) 0.00028014183044434
(409) DESCRIBE `ships` 0.001291036605835
(410) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1402') 0.00020122528076172
(411) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018596649169922
(412) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017595291137695
(413) DESCRIBE `itineraries` 0.00068497657775879
(414) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '62153') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0011410713195801
(415) DESCRIBE `ports` 0.00073504447937012
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021886825561523
(417) DESCRIBE `ports` 0.00074505805969238
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0002138614654541
(419) DESCRIBE `ports` 0.00070905685424805
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018715858459473
(421) DESCRIBE `sailingdates` 0.00061702728271484
(422) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '62153') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00036191940307617
(423) DESCRIBE `ports` 0.00072407722473145
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00021886825561523
(425) DESCRIBE `ports` 0.0006868839263916
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00018906593322754
(427) DESCRIBE `ports` 0.0007328987121582
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00022792816162109
(429) DESCRIBE `ports` 0.00067710876464844
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0001838207244873
(431) DESCRIBE `avid_specials` 0.00064992904663086
(432) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 62153 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.00093197822570801
(433) DESCRIBE `cruiselines` 0.00099301338195801
(434) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00023388862609863
(435) DESCRIBE `orchid_image` 0.00076723098754883
(436) DESCRIBE `cruiselines` 0.00093293190002441
(437) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00019311904907227
(438) DESCRIBE `ships` 0.0014870166778564
(439) SELECT `ships`.* FROM `ships` WHERE (id IN ('573', '1402', '1284', '765', '1285')) ORDER BY FIND_IN_SET(id, '573,1402,1284,765,1285') 0.00049495697021484
(440) DESCRIBE `cruisetypes` 0.00080704689025879
(441) DESCRIBE `destinations` 0.0011210441589355
(442) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('8', '43', '35')) ORDER BY FIND_IN_SET(id, '8,43,35') 0.00041818618774414
(443) DESCRIBE `cruiselines` 0.0010011196136475
(444) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00030303001403809
(445) DESCRIBE `cruiselines` 0.0012750625610352
(446) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00025796890258789