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

Total elapsed time: 0.26304411888123

# Query Time
(1) connect 0.00055313110351562
(2) DESCRIBE `cruises` 0.0017709732055664
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (53605, 57373, 43646, 71097, 60002, 67120, 77398, 46637, 66788, 66973)) ORDER BY FIND_IN_SET(id, '53605,57373,43646,71097,60002,67120,77398,46637,66788,66973') 0.00092887878417969
(4) DESCRIBE `cruises` 0.0013949871063232
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '53605') 0.00025296211242676
(6) DESCRIBE `ships` 0.0013360977172852
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 770))) 0.00025796890258789
(8) DESCRIBE `ships` 0.0013220310211182
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '770') 0.00018405914306641
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017285346984863
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016188621520996
(12) DESCRIBE `itineraries` 0.00068497657775879
(13) DESCRIBE `ports` 0.00070405006408691
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0002439022064209
(15) DESCRIBE `ports` 0.00075101852416992
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00021600723266602
(17) DESCRIBE `ports` 0.00069594383239746
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018501281738281
(19) DESCRIBE `sailingdates` 0.00059914588928223
(20) DESCRIBE `ports` 0.00099587440490723
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0002601146697998
(22) DESCRIBE `ports` 0.00067687034606934
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00019288063049316
(24) DESCRIBE `ports` 0.00069904327392578
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00026702880859375
(26) DESCRIBE `ports` 0.00090694427490234
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00019097328186035
(28) DESCRIBE `ports` 0.00067520141601562
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00021004676818848
(30) DESCRIBE `ports` 0.00090718269348145
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00018692016601562
(32) DESCRIBE `ports` 0.00069117546081543
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00020599365234375
(34) DESCRIBE `ports` 0.00068879127502441
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00018095970153809
(36) DESCRIBE `ports` 0.0006709098815918
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00021910667419434
(38) DESCRIBE `ports` 0.00072002410888672
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018000602722168
(40) DESCRIBE `ports` 0.00069499015808105
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00020503997802734
(42) DESCRIBE `ports` 0.0006709098815918
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00018191337585449
(44) DESCRIBE `ports` 0.00068902969360352
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00023198127746582
(46) DESCRIBE `ports` 0.00069189071655273
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00019001960754395
(48) DESCRIBE `avid_specials` 0.00081181526184082
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 53605 and class = 'Cruise') OR (item_id = 770 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 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.0016598701477051
(50) DESCRIBE `cruiselines` 0.001309871673584
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00025200843811035
(52) DESCRIBE `orchid_image` 0.00082516670227051
(53) DESCRIBE `cruiselines` 0.00094199180603027
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00019717216491699
(55) DESCRIBE `cruises` 0.0013210773468018
(56) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57373') 0.00021600723266602
(57) DESCRIBE `ships` 0.0013980865478516
(58) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 314))) 0.0002589225769043
(59) DESCRIBE `ships` 0.0013160705566406
(60) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '314') 0.00018715858459473
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018095970153809
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017094612121582
(63) DESCRIBE `itineraries` 0.00066614151000977
(64) DESCRIBE `ports` 0.00074601173400879
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00021195411682129
(66) DESCRIBE `ports` 0.00067901611328125
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00020194053649902
(68) DESCRIBE `ports` 0.00069499015808105
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00022983551025391
(70) DESCRIBE `sailingdates` 0.00072813034057617
(71) DESCRIBE `ports` 0.00070810317993164
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.00020790100097656
(73) DESCRIBE `ports` 0.00067591667175293
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00020718574523926
(75) DESCRIBE `ports` 0.00067710876464844
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.00020790100097656
(77) DESCRIBE `ports` 0.00070500373840332
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.00018596649169922
(79) DESCRIBE `ports` 0.00067901611328125
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.00019693374633789
(81) DESCRIBE `ports` 0.00067305564880371
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.00018119812011719
(83) DESCRIBE `ports` 0.00068902969360352
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.00021195411682129
(85) DESCRIBE `ports` 0.00071382522583008
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.00018000602722168
(87) DESCRIBE `ports` 0.00066804885864258
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 334))) 0.0002281665802002
(89) DESCRIBE `ports` 0.00066518783569336
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '334') 0.00017881393432617
(91) DESCRIBE `avid_specials` 0.00060606002807617
(92) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57373 and class = 'Cruise') OR (item_id = 314 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 10 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.00097799301147461
(93) DESCRIBE `cruiselines` 0.00099301338195801
(94) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00023818016052246
(95) DESCRIBE `orchid_image` 0.00075888633728027
(96) DESCRIBE `cruiselines` 0.0010440349578857
(97) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00018405914306641
(98) DESCRIBE `cruises` 0.0013251304626465
(99) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '43646') 0.00040102005004883
(100) DESCRIBE `ships` 0.0016469955444336
(101) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 405))) 0.00026893615722656
(102) DESCRIBE `ships` 0.0013551712036133
(103) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '405') 0.00020599365234375
(104) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018310546875
(105) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020694732666016
(106) DESCRIBE `itineraries` 0.00068402290344238
(107) DESCRIBE `ports` 0.00068402290344238
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00022387504577637
(109) DESCRIBE `ports` 0.00070309638977051
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020599365234375
(111) DESCRIBE `ports` 0.00067305564880371
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00018405914306641
(113) DESCRIBE `sailingdates` 0.00059795379638672
(114) DESCRIBE `ports` 0.00069379806518555
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00021910667419434
(116) DESCRIBE `ports` 0.00074505805969238
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00019001960754395
(118) DESCRIBE `ports` 0.00067496299743652
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00020718574523926
(120) DESCRIBE `ports` 0.00067710876464844
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00022792816162109
(122) DESCRIBE `ports` 0.00080609321594238
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 413))) 0.00022983551025391
(124) DESCRIBE `ports` 0.00068402290344238
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '413') 0.00022411346435547
(126) DESCRIBE `ports` 0.00067710876464844
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0002140998840332
(128) DESCRIBE `ports` 0.00068402290344238
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00018715858459473
(130) DESCRIBE `avid_specials` 0.0006110668182373
(131) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 43646 and class = 'Cruise') OR (item_id = 405 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 9 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.00094103813171387
(132) DESCRIBE `cruiselines` 0.0010349750518799
(133) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00022482872009277
(134) DESCRIBE `orchid_image` 0.00075507164001465
(135) DESCRIBE `cruiselines` 0.00095605850219727
(136) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00018310546875
(137) DESCRIBE `cruises` 0.0012609958648682
(138) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71097') 0.00021004676818848
(139) DESCRIBE `ships` 0.0013480186462402
(140) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 212))) 0.00024795532226562
(141) DESCRIBE `ships` 0.0012679100036621
(142) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '212') 0.00019001960754395
(143) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001828670501709
(144) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017189979553223
(145) DESCRIBE `itineraries` 0.00067400932312012
(146) DESCRIBE `ports` 0.00069999694824219
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00022101402282715
(148) DESCRIBE `ports` 0.00072884559631348
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00020503997802734
(150) DESCRIBE `ports` 0.00079703330993652
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00026988983154297
(152) DESCRIBE `sailingdates` 0.00064897537231445
(153) DESCRIBE `ports` 0.0010068416595459
(154) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00029516220092773
(155) DESCRIBE `ports` 0.0009920597076416
(156) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00025010108947754
(157) DESCRIBE `ports` 0.0010290145874023
(158) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 413))) 0.00027298927307129
(159) DESCRIBE `ports` 0.0010149478912354
(160) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '413') 0.00024199485778809
(161) DESCRIBE `ports` 0.0010030269622803
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00023293495178223
(163) DESCRIBE `ports` 0.00067996978759766
(164) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00018477439880371
(165) DESCRIBE `ports` 0.00074100494384766
(166) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00023508071899414
(167) DESCRIBE `ports` 0.00067615509033203
(168) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00018191337585449
(169) DESCRIBE `avid_specials` 0.00083708763122559
(170) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71097 and class = 'Cruise') OR (item_id = 212 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 9 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.0013229846954346
(171) DESCRIBE `cruiselines` 0.0010578632354736
(172) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00030708312988281
(173) DESCRIBE `orchid_image` 0.0011301040649414
(174) DESCRIBE `cruiselines` 0.00093293190002441
(175) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00018405914306641
(176) DESCRIBE `cruises` 0.0013389587402344
(177) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '60002') 0.00020098686218262
(178) DESCRIBE `ships` 0.0012710094451904
(179) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 626))) 0.0002439022064209
(180) DESCRIBE `ships` 0.0013411045074463
(181) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '626') 0.00022387504577637
(182) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(183) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017213821411133
(184) DESCRIBE `itineraries` 0.00072693824768066
(185) DESCRIBE `ports` 0.00068092346191406
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.0002140998840332
(187) DESCRIBE `ports` 0.00069999694824219
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00020289421081543
(189) DESCRIBE `ports` 0.00071001052856445
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00018215179443359
(191) DESCRIBE `sailingdates` 0.00064897537231445
(192) DESCRIBE `ports` 0.00068998336791992
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00020599365234375
(194) DESCRIBE `ports` 0.00067901611328125
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00018215179443359
(196) DESCRIBE `ports` 0.0006721019744873
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 113))) 0.00020718574523926
(198) DESCRIBE `ports` 0.00067710876464844
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '113') 0.00019598007202148
(200) DESCRIBE `ports` 0.00066995620727539
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 333))) 0.00021505355834961
(202) DESCRIBE `ports` 0.00073695182800293
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '333') 0.00018596649169922
(204) DESCRIBE `ports` 0.00068902969360352
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 119))) 0.00020909309387207
(206) DESCRIBE `ports` 0.00066685676574707
(207) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '119') 0.00018191337585449
(208) DESCRIBE `ports` 0.00068998336791992
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 126))) 0.00020408630371094
(210) DESCRIBE `ports` 0.00068306922912598
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '126') 0.0001828670501709
(212) DESCRIBE `ports` 0.00066781044006348
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00020480155944824
(214) DESCRIBE `ports` 0.00068902969360352
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00018095970153809
(216) DESCRIBE `avid_specials` 0.00060105323791504
(217) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 60002 and class = 'Cruise') OR (item_id = 626 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 11 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.00094699859619141
(218) DESCRIBE `cruiselines` 0.00098896026611328
(219) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00022506713867188
(220) DESCRIBE `orchid_image` 0.00079584121704102
(221) DESCRIBE `cruiselines` 0.0010361671447754
(222) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00018811225891113
(223) DESCRIBE `cruises` 0.001244068145752
(224) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67120') 0.00025415420532227
(225) DESCRIBE `ships` 0.001701831817627
(226) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1569))) 0.00026106834411621
(227) DESCRIBE `ships` 0.0012698173522949
(228) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1569') 0.00018787384033203
(229) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00017595291137695
(230) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00016307830810547
(231) DESCRIBE `itineraries` 0.00066804885864258
(232) DESCRIBE `ports` 0.000762939453125
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00022315979003906
(234) DESCRIBE `ports` 0.00067400932312012
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00020909309387207
(236) DESCRIBE `ports` 0.00065898895263672
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00018596649169922
(238) DESCRIBE `sailingdates` 0.00060606002807617
(239) DESCRIBE `ports` 0.00069689750671387
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00022983551025391
(241) DESCRIBE `ports` 0.00067305564880371
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00018405914306641
(243) DESCRIBE `ports` 0.00069308280944824
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00020194053649902
(245) DESCRIBE `ports` 0.00067305564880371
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00018119812011719
(247) DESCRIBE `ports` 0.00072193145751953
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00020408630371094
(249) DESCRIBE `ports` 0.00066518783569336
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00018000602722168
(251) DESCRIBE `ports` 0.00069713592529297
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3629))) 0.0001981258392334
(253) DESCRIBE `ports` 0.00066614151000977
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3629') 0.00017499923706055
(255) DESCRIBE `ports` 0.00065994262695312
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00020289421081543
(257) DESCRIBE `ports` 0.00072097778320312
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00018000602722168
(259) DESCRIBE `ports` 0.00066113471984863
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00020790100097656
(261) DESCRIBE `ports` 0.00066590309143066
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00018000602722168
(263) DESCRIBE `ports` 0.00077104568481445
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00020503997802734
(265) DESCRIBE `ports` 0.00065994262695312
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00018000602722168
(267) DESCRIBE `avid_specials` 0.00059604644775391
(268) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67120 and class = 'Cruise') OR (item_id = 1569 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 2 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0009620189666748
(269) DESCRIBE `cruiselines` 0.00098586082458496
(270) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00020599365234375
(271) DESCRIBE `orchid_image` 0.00074481964111328
(272) DESCRIBE `cruiselines` 0.0009307861328125
(273) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00017404556274414
(274) DESCRIBE `cruises` 0.0012590885162354
(275) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '77398') 0.00030016899108887
(276) DESCRIBE `ships` 0.0012490749359131
(277) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 404))) 0.00025510787963867
(278) DESCRIBE `ships` 0.0012779235839844
(279) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '404') 0.0002131462097168
(280) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017404556274414
(281) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016188621520996
(282) DESCRIBE `itineraries` 0.00066089630126953
(283) DESCRIBE `ports` 0.00068306922912598
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00021505355834961
(285) DESCRIBE `ports` 0.00071907043457031
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00021696090698242
(287) DESCRIBE `ports` 0.00068998336791992
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00018501281738281
(289) DESCRIBE `sailingdates` 0.00061488151550293
(290) DESCRIBE `ports` 0.00068402290344238
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00020694732666016
(292) DESCRIBE `ports` 0.00066995620727539
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00018310546875
(294) DESCRIBE `ports` 0.00068402290344238
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 353))) 0.00020599365234375
(296) DESCRIBE `ports` 0.00070095062255859
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '353') 0.00018095970153809
(298) DESCRIBE `ports` 0.00066399574279785
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 353))) 0.00026702880859375
(300) DESCRIBE `ports` 0.00095987319946289
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '353') 0.00023913383483887
(302) DESCRIBE `ports` 0.00074601173400879
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) 0.00020885467529297
(304) DESCRIBE `ports` 0.00067305564880371
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '17') 0.0002281665802002
(306) DESCRIBE `ports` 0.00069403648376465
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 856))) 0.00022506713867188
(308) DESCRIBE `ports` 0.00066685676574707
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '856') 0.00018191337585449
(310) DESCRIBE `ports` 0.00066304206848145
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00020599365234375
(312) DESCRIBE `ports` 0.0006868839263916
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00022602081298828
(314) DESCRIBE `ports` 0.00069689750671387
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00019216537475586
(316) DESCRIBE `ports` 0.00069284439086914
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00020503997802734
(318) DESCRIBE `ports` 0.00067996978759766
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00020599365234375
(320) DESCRIBE `ports` 0.00068283081054688
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00018191337585449
(322) DESCRIBE `avid_specials` 0.00062394142150879
(323) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 77398 and class = 'Cruise') OR (item_id = 404 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 29 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
(324) DESCRIBE `cruiselines` 0.00096797943115234
(325) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.0002138614654541
(326) DESCRIBE `orchid_image` 0.00079083442687988
(327) DESCRIBE `cruiselines` 0.00098395347595215
(328) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00017404556274414
(329) DESCRIBE `cruises` 0.0012750625610352
(330) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '46637') 0.00019693374633789
(331) DESCRIBE `ships` 0.001255989074707
(332) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 770))) 0.00023198127746582
(333) DESCRIBE `ships` 0.0012631416320801
(334) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '770') 0.00018000602722168
(335) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017309188842773
(336) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016307830810547
(337) DESCRIBE `itineraries` 0.00066685676574707
(338) DESCRIBE `ports` 0.00066590309143066
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020599365234375
(340) DESCRIBE `ports` 0.00065517425537109
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00023388862609863
(342) DESCRIBE `ports` 0.00079202651977539
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00017595291137695
(344) DESCRIBE `sailingdates` 0.00059080123901367
(345) DESCRIBE `ports` 0.00084614753723145
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00023293495178223
(347) DESCRIBE `ports` 0.00066995620727539
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00019407272338867
(349) DESCRIBE `ports` 0.00070905685424805
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00020813941955566
(351) DESCRIBE `ports` 0.00066304206848145
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00018215179443359
(353) DESCRIBE `ports` 0.00067019462585449
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00020694732666016
(355) DESCRIBE `ports` 0.0006861686706543
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00018620491027832
(357) DESCRIBE `ports` 0.0007328987121582
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00020790100097656
(359) DESCRIBE `ports` 0.00066304206848145
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00018095970153809
(361) DESCRIBE `ports` 0.00069189071655273
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00020694732666016
(363) DESCRIBE `ports` 0.00068807601928711
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00018191337585449
(365) DESCRIBE `ports` 0.0006568431854248
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00020599365234375
(367) DESCRIBE `ports` 0.00072598457336426
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00018191337585449
(369) DESCRIBE `ports` 0.00065493583679199
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020384788513184
(371) DESCRIBE `ports` 0.00076603889465332
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00023794174194336
(373) DESCRIBE `avid_specials` 0.00069117546081543
(374) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 46637 and class = 'Cruise') OR (item_id = 770 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 22 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.0010750293731689
(375) DESCRIBE `cruiselines` 0.001025915145874
(376) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00022792816162109
(377) DESCRIBE `orchid_image` 0.00086808204650879
(378) DESCRIBE `cruiselines` 0.0010128021240234
(379) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00019288063049316
(380) DESCRIBE `cruises` 0.0012509822845459
(381) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66788') 0.00020980834960938
(382) DESCRIBE `ships` 0.0013439655303955
(383) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1193))) 0.00026679039001465
(384) DESCRIBE `ships` 0.0012481212615967
(385) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1193') 0.00021219253540039
(386) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018405914306641
(387) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017213821411133
(388) DESCRIBE `itineraries` 0.00072598457336426
(389) DESCRIBE `ports` 0.00068902969360352
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00023007392883301
(391) DESCRIBE `ports` 0.00083518028259277
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00024294853210449
(393) DESCRIBE `ports` 0.00071287155151367
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00018811225891113
(395) DESCRIBE `sailingdates` 0.00061416625976562
(396) DESCRIBE `ports` 0.0007479190826416
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00022292137145996
(398) DESCRIBE `ports` 0.00067996978759766
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00018811225891113
(400) DESCRIBE `ports` 0.00069117546081543
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.00020217895507812
(402) DESCRIBE `ports` 0.00067377090454102
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.00018596649169922
(404) DESCRIBE `ports` 0.00075197219848633
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.0001990795135498
(406) DESCRIBE `ports` 0.00080299377441406
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.0001828670501709
(408) DESCRIBE `ports` 0.00069904327392578
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1700))) 0.00025391578674316
(410) DESCRIBE `ports` 0.00070595741271973
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1700') 0.00018405914306641
(412) DESCRIBE `ports` 0.00074982643127441
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00023508071899414
(414) DESCRIBE `ports` 0.00070786476135254
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00023484230041504
(416) DESCRIBE `avid_specials` 0.00061583518981934
(417) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66788 and class = 'Cruise') OR (item_id = 1193 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 10 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.0010199546813965
(418) DESCRIBE `cruiselines` 0.00099587440490723
(419) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00022482872009277
(420) DESCRIBE `orchid_image` 0.00077199935913086
(421) DESCRIBE `cruiselines` 0.0009150505065918
(422) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00018191337585449
(423) DESCRIBE `cruises` 0.0013339519500732
(424) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66973') 0.00020003318786621
(425) DESCRIBE `ships` 0.0013360977172852
(426) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 574))) 0.00028395652770996
(427) DESCRIBE `ships` 0.0013399124145508
(428) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '574') 0.00020289421081543
(429) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00021195411682129
(430) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017189979553223
(431) DESCRIBE `itineraries` 0.00072407722473145
(432) DESCRIBE `ports` 0.0007021427154541
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00023579597473145
(434) DESCRIBE `ports` 0.00068998336791992
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00020003318786621
(436) DESCRIBE `ports` 0.0008690357208252
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00022101402282715
(438) DESCRIBE `sailingdates` 0.00095486640930176
(439) DESCRIBE `ports` 0.00078797340393066
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00026798248291016
(441) DESCRIBE `ports` 0.00068998336791992
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00019502639770508
(443) DESCRIBE `ports` 0.00067710876464844
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00020909309387207
(445) DESCRIBE `ports` 0.00077390670776367
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00018405914306641
(447) DESCRIBE `ports` 0.00067496299743652
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00020599365234375
(449) DESCRIBE `ports` 0.00067806243896484
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.0001828670501709
(451) DESCRIBE `ports` 0.00069117546081543
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00021100044250488
(453) DESCRIBE `ports` 0.00068783760070801
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00018882751464844
(455) DESCRIBE `ports` 0.00070786476135254
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00020790100097656
(457) DESCRIBE `ports` 0.00067782402038574
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.0001838207244873
(459) DESCRIBE `ports` 0.0006721019744873
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00020790100097656
(461) DESCRIBE `ports` 0.0006721019744873
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00020599365234375
(463) DESCRIBE `ports` 0.00066995620727539
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00020909309387207
(465) DESCRIBE `ports` 0.00066804885864258
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00018191337585449
(467) DESCRIBE `avid_specials` 0.00067496299743652
(468) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66973 and class = 'Cruise') OR (item_id = 574 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 2 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.0010039806365967
(469) DESCRIBE `cruiselines` 0.00097107887268066
(470) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00022196769714355
(471) DESCRIBE `orchid_image` 0.00078892707824707
(472) DESCRIBE `cruiselines` 0.00091791152954102
(473) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00018095970153809
(474) DESCRIBE `ships` 0.0014469623565674
(475) SELECT `ships`.* FROM `ships` WHERE (id IN ('404', '770', '1193', '405', '1569', '1008', '1088', '314', '93', '626', '574', '448', '485', '212', '665', '1721')) ORDER BY FIND_IN_SET(id, '404,770,1193,405,1569,1008,1088,314,93,626,574,448,485,212,665,1721') 0.0010130405426025
(476) DESCRIBE `cruisetypes` 0.00073409080505371
(477) DESCRIBE `destinations` 0.00093817710876465
(478) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('12', '22', '29', '9', '2', '10', '26', '48', '11', '53', '28', '37', '38', '25', '43', '21', '49', '8', '35', '34')) ORDER BY FIND_IN_SET(id, '12,22,29,9,2,10,26,48,11,53,28,37,38,25,43,21,49,8,35,34') 0.00087094306945801
(479) DESCRIBE `cruiselines` 0.0010969638824463
(480) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00025582313537598
(481) DESCRIBE `cruiselines` 0.00098299980163574
(482) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00026202201843262