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

Total elapsed time: 0.246910572052

# Query Time
(1) connect 0.00054502487182617
(2) DESCRIBE `cruises` 0.0020418167114258
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (45258, 45258, 45260, 45259, 45259)) ORDER BY FIND_IN_SET(id, '45258,45258,45260,45259,45259') 0.00091409683227539
(4) DESCRIBE `specials` 0.0022299289703369
(5) DESCRIBE `specials` 0.0023748874664307
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1420976') 0.00023984909057617
(7) DESCRIBE `ships` 0.0012478828430176
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00032520294189453
(9) DESCRIBE `ships` 0.00199294090271
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00029587745666504
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00023198127746582
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0002140998840332
(13) DESCRIBE `itineraries` 0.00071001052856445
(14) DESCRIBE `ports` 0.00069594383239746
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00021696090698242
(16) DESCRIBE `ports` 0.00083088874816895
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00020885467529297
(18) DESCRIBE `ports` 0.00076889991760254
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00018405914306641
(20) DESCRIBE `specialsailingdates` 0.00057196617126465
(21) DESCRIBE `sailingdates` 0.00063610076904297
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465342))) 0.00024700164794922
(23) DESCRIBE `sailingdates` 0.00059890747070312
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465343))) 0.00019288063049316
(25) DESCRIBE `sailingdates` 0.00071907043457031
(26) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465344))) 0.00020194053649902
(27) DESCRIBE `sailingdates` 0.00060200691223145
(28) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465345))) 0.00018906593322754
(29) DESCRIBE `sailingdates` 0.00063109397888184
(30) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465346))) 0.00018692016601562
(31) DESCRIBE `sailingdates` 0.0006098747253418
(32) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465347))) 0.00018692016601562
(33) DESCRIBE `sailingdates` 0.00059604644775391
(34) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465348))) 0.00018501281738281
(35) DESCRIBE `sailingdates` 0.00059294700622559
(36) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465349))) 0.00018620491027832
(37) DESCRIBE `sailingdates` 0.0005948543548584
(38) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465350))) 0.00018692016601562
(39) DESCRIBE `sailingdates` 0.00058913230895996
(40) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465351))) 0.0001978874206543
(41) DESCRIBE `sailingdates` 0.00059199333190918
(42) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465352))) 0.00021100044250488
(43) DESCRIBE `sailingdates` 0.00059294700622559
(44) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465353))) 0.00018501281738281
(45) DESCRIBE `sailingdates` 0.00058889389038086
(46) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465354))) 0.00018501281738281
(47) DESCRIBE `sailingdates` 0.00074505805969238
(48) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465355))) 0.0001988410949707
(49) DESCRIBE `sailingdates` 0.00061702728271484
(50) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465356))) 0.00018787384033203
(51) DESCRIBE `sailingdates` 0.00062894821166992
(52) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465357))) 0.00019311904907227
(53) DESCRIBE `sailingdates` 0.00061583518981934
(54) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465358))) 0.00018787384033203
(55) DESCRIBE `sailingdates` 0.00059604644775391
(56) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465359))) 0.00019288063049316
(57) DESCRIBE `sailingdates` 0.0006718635559082
(58) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465360))) 0.00021886825561523
(59) DESCRIBE `sailingdates` 0.00061988830566406
(60) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465361))) 0.00019097328186035
(61) DESCRIBE `sailingdates` 0.00060200691223145
(62) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465362))) 0.00019001960754395
(63) DESCRIBE `sailingdates` 0.00077009201049805
(64) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465363))) 0.0001990795135498
(65) DESCRIBE `sailingdates` 0.00059700012207031
(66) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465364))) 0.00018811225891113
(67) DESCRIBE `sailingdates` 0.00059294700622559
(68) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465365))) 0.00018692016601562
(69) DESCRIBE `sailingdates` 0.00064992904663086
(70) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465366))) 0.00018596649169922
(71) DESCRIBE `sailingdates` 0.0006260871887207
(72) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465367))) 0.00018787384033203
(73) DESCRIBE `sailingdates` 0.00059413909912109
(74) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465368))) 0.00020909309387207
(75) DESCRIBE `sailingdates` 0.00060701370239258
(76) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465369))) 0.00018692016601562
(77) DESCRIBE `sailingdates` 0.00059700012207031
(78) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465370))) 0.00018405914306641
(79) DESCRIBE `sailingdates` 0.00059413909912109
(80) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465371))) 0.00021910667419434
(81) DESCRIBE `sailingdates` 0.00061678886413574
(82) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465372))) 0.00018596649169922
(83) DESCRIBE `sailingdates` 0.00059390068054199
(84) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465373))) 0.00018787384033203
(85) DESCRIBE `sailingdates` 0.00061988830566406
(86) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465374))) 0.00018596649169922
(87) DESCRIBE `sailingdates` 0.00060391426086426
(88) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465375))) 0.00019478797912598
(89) DESCRIBE `sailingdates` 0.00061202049255371
(90) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465376))) 0.00018501281738281
(91) DESCRIBE `sailingdates` 0.00062823295593262
(92) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465377))) 0.00019598007202148
(93) DESCRIBE `sailingdates` 0.00059413909912109
(94) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465378))) 0.00018596649169922
(95) DESCRIBE `sailingdates` 0.00068902969360352
(96) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465379))) 0.00034499168395996
(97) DESCRIBE `sailingdates` 0.00078701972961426
(98) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465380))) 0.00018787384033203
(99) DESCRIBE `sailingdates` 0.00060105323791504
(100) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465381))) 0.00018715858459473
(101) DESCRIBE `sailingdates` 0.00065803527832031
(102) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465382))) 0.00018692016601562
(103) DESCRIBE `sailingdates` 0.00059604644775391
(104) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465383))) 0.00018692016601562
(105) DESCRIBE `sailingdates` 0.00060510635375977
(106) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465384))) 0.00018501281738281
(107) DESCRIBE `sailingdates` 0.0005950927734375
(108) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465385))) 0.00018811225891113
(109) DESCRIBE `sailingdates` 0.00058603286743164
(110) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465386))) 0.00019097328186035
(111) DESCRIBE `ports` 0.00072288513183594
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00021696090698242
(113) DESCRIBE `ports` 0.00067901611328125
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00019311904907227
(115) DESCRIBE `ports` 0.00066685676574707
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00020194053649902
(117) DESCRIBE `ports` 0.00066399574279785
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00018000602722168
(119) DESCRIBE `ports` 0.00069189071655273
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00020313262939453
(121) DESCRIBE `ports` 0.00069904327392578
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00019502639770508
(123) DESCRIBE `ports` 0.00066304206848145
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.0001990795135498
(125) DESCRIBE `ports` 0.00066280364990234
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00018000602722168
(127) DESCRIBE `ports` 0.00066089630126953
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00019717216491699
(129) DESCRIBE `ports` 0.0011091232299805
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00025296211242676
(131) DESCRIBE `ports` 0.0010108947753906
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00026988983154297
(133) DESCRIBE `ports` 0.0010149478912354
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00024104118347168
(135) DESCRIBE `ports` 0.0012130737304688
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00039100646972656
(137) DESCRIBE `ports` 0.0014181137084961
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.0002439022064209
(139) DESCRIBE `ports` 0.0010089874267578
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00027799606323242
(141) DESCRIBE `ports` 0.001166820526123
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00043702125549316
(143) DESCRIBE `cruises` 0.0023488998413086
(144) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 45258))) 0.00034308433532715
(145) DESCRIBE `avid_specials` 0.00063300132751465
(146) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1420976 and class = 'Special') OR (item_id = 45258 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 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.0010280609130859
(147) DESCRIBE `cruiselines` 0.00099396705627441
(148) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00024008750915527
(149) DESCRIBE `orchid_image` 0.00098896026611328
(150) DESCRIBE `cruiselines` 0.0011911392211914
(151) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00022101402282715
(152) DESCRIBE `cruises` 0.0015659332275391
(153) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45258') 0.00025010108947754
(154) DESCRIBE `ships` 0.0016438961029053
(155) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00029301643371582
(156) DESCRIBE `ships` 0.0015299320220947
(157) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00019097328186035
(158) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00020813941955566
(159) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00022292137145996
(160) DESCRIBE `itineraries` 0.00077080726623535
(161) DESCRIBE `ports` 0.00080490112304688
(162) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00022006034851074
(163) DESCRIBE `ports` 0.00095200538635254
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00020599365234375
(165) DESCRIBE `ports` 0.00080990791320801
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00019502639770508
(167) DESCRIBE `sailingdates` 0.00072383880615234
(168) DESCRIBE `ports` 0.00081205368041992
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00023508071899414
(170) DESCRIBE `ports` 0.00067615509033203
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00019216537475586
(172) DESCRIBE `ports` 0.00068402290344238
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00020503997802734
(174) DESCRIBE `ports` 0.0006711483001709
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.0001838207244873
(176) DESCRIBE `ports` 0.00075411796569824
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00023818016052246
(178) DESCRIBE `ports` 0.00071501731872559
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.0001838207244873
(180) DESCRIBE `ports` 0.00066900253295898
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00020098686218262
(182) DESCRIBE `ports` 0.00077390670776367
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00018310546875
(184) DESCRIBE `ports` 0.0006721019744873
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.0001990795135498
(186) DESCRIBE `ports` 0.00067901611328125
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00018501281738281
(188) DESCRIBE `ports` 0.00068902969360352
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00020718574523926
(190) DESCRIBE `ports` 0.00073003768920898
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00018191337585449
(192) DESCRIBE `ports` 0.00066590309143066
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.0002138614654541
(194) DESCRIBE `ports` 0.00093317031860352
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00040197372436523
(196) DESCRIBE `ports` 0.0011661052703857
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00028491020202637
(198) DESCRIBE `ports` 0.00097012519836426
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.000244140625
(200) DESCRIBE `avid_specials` 0.00087594985961914
(201) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 45258 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 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.0016422271728516
(202) DESCRIBE `cruiselines` 0.0014159679412842
(203) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00031900405883789
(204) DESCRIBE `orchid_image` 0.0011420249938965
(205) DESCRIBE `cruiselines` 0.0014228820800781
(206) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.0002739429473877
(207) DESCRIBE `cruises` 0.0018589496612549
(208) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45260') 0.00028204917907715
(209) DESCRIBE `ships` 0.0019111633300781
(210) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00033903121948242
(211) DESCRIBE `ships` 0.001878023147583
(212) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00024509429931641
(213) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00023603439331055
(214) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00022196769714355
(215) DESCRIBE `itineraries` 0.00098013877868652
(216) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '45260') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0012350082397461
(217) DESCRIBE `ports` 0.001039981842041
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00029587745666504
(219) DESCRIBE `ports` 0.00094008445739746
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00029397010803223
(221) DESCRIBE `ports` 0.0010080337524414
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00020599365234375
(223) DESCRIBE `sailingdates` 0.00069093704223633
(224) DESCRIBE `ports` 0.00094318389892578
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.000244140625
(226) DESCRIBE `ports` 0.00070500373840332
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.0001981258392334
(228) DESCRIBE `ports` 0.00073003768920898
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00020599365234375
(230) DESCRIBE `ports` 0.00067496299743652
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00018596649169922
(232) DESCRIBE `ports` 0.0006721019744873
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00020599365234375
(234) DESCRIBE `ports` 0.0006709098815918
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00018405914306641
(236) DESCRIBE `ports` 0.00075507164001465
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00020003318786621
(238) DESCRIBE `ports` 0.00066781044006348
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00018596649169922
(240) DESCRIBE `avid_specials` 0.00060892105102539
(241) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 45260 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 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.0010030269622803
(242) DESCRIBE `cruiselines` 0.00098109245300293
(243) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00021481513977051
(244) DESCRIBE `orchid_image` 0.00076103210449219
(245) DESCRIBE `cruiselines` 0.00092291831970215
(246) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00018501281738281
(247) DESCRIBE `specials` 0.0029730796813965
(248) DESCRIBE `specials` 0.0018301010131836
(249) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1420991') 0.00027108192443848
(250) DESCRIBE `ships` 0.0015909671783447
(251) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00026297569274902
(252) DESCRIBE `ships` 0.0014221668243408
(253) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00044083595275879
(254) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00024294853210449
(255) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00021696090698242
(256) DESCRIBE `itineraries` 0.0011959075927734
(257) DESCRIBE `ports` 0.0010449886322021
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00030303001403809
(259) DESCRIBE `ports` 0.0010750293731689
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00027990341186523
(261) DESCRIBE `ports` 0.001032829284668
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.000244140625
(263) DESCRIBE `specialsailingdates` 0.00085020065307617
(264) DESCRIBE `sailingdates` 0.00099396705627441
(265) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465290))) 0.00034403800964355
(266) DESCRIBE `sailingdates` 0.00090694427490234
(267) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465291))) 0.00025391578674316
(268) DESCRIBE `sailingdates` 0.00093507766723633
(269) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465292))) 0.00024294853210449
(270) DESCRIBE `sailingdates` 0.0008549690246582
(271) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465293))) 0.00024509429931641
(272) DESCRIBE `sailingdates` 0.00087904930114746
(273) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465294))) 0.00024008750915527
(274) DESCRIBE `sailingdates` 0.00084090232849121
(275) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465295))) 0.00024294853210449
(276) DESCRIBE `sailingdates` 0.00084686279296875
(277) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465296))) 0.00023603439331055
(278) DESCRIBE `sailingdates` 0.00081205368041992
(279) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465297))) 0.00023603439331055
(280) DESCRIBE `sailingdates` 0.00087404251098633
(281) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465298))) 0.00024914741516113
(282) DESCRIBE `sailingdates` 0.00087189674377441
(283) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465299))) 0.00025796890258789
(284) DESCRIBE `sailingdates` 0.00090217590332031
(285) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465300))) 0.00024890899658203
(286) DESCRIBE `sailingdates` 0.00087380409240723
(287) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465301))) 0.00028204917907715
(288) DESCRIBE `sailingdates` 0.00087094306945801
(289) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465302))) 0.00024604797363281
(290) DESCRIBE `sailingdates` 0.00085806846618652
(291) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465303))) 0.00025200843811035
(292) DESCRIBE `sailingdates` 0.00086402893066406
(293) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465304))) 0.00025296211242676
(294) DESCRIBE `sailingdates` 0.00088620185852051
(295) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465305))) 0.00025010108947754
(296) DESCRIBE `sailingdates` 0.00086188316345215
(297) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465306))) 0.00025582313537598
(298) DESCRIBE `sailingdates` 0.00095915794372559
(299) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465307))) 0.00027799606323242
(300) DESCRIBE `sailingdates` 0.0009000301361084
(301) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465308))) 0.00025010108947754
(302) DESCRIBE `sailingdates` 0.00088405609130859
(303) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465309))) 0.00025296211242676
(304) DESCRIBE `sailingdates` 0.00087499618530273
(305) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465310))) 0.00029802322387695
(306) DESCRIBE `sailingdates` 0.00089097023010254
(307) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465311))) 0.00027108192443848
(308) DESCRIBE `sailingdates` 0.00090408325195312
(309) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465312))) 0.00026893615722656
(310) DESCRIBE `sailingdates` 0.00089001655578613
(311) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465313))) 0.00022482872009277
(312) DESCRIBE `sailingdates` 0.00074505805969238
(313) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465314))) 0.00020194053649902
(314) DESCRIBE `sailingdates` 0.00075888633728027
(315) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465315))) 0.00022196769714355
(316) DESCRIBE `sailingdates` 0.00077009201049805
(317) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465316))) 0.00024104118347168
(318) DESCRIBE `sailingdates` 0.00086307525634766
(319) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465317))) 0.00023317337036133
(320) DESCRIBE `sailingdates` 0.00077295303344727
(321) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465318))) 0.00023984909057617
(322) DESCRIBE `sailingdates` 0.000762939453125
(323) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465319))) 0.00018906593322754
(324) DESCRIBE `sailingdates` 0.00066304206848145
(325) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465320))) 0.00019001960754395
(326) DESCRIBE `sailingdates` 0.00063395500183105
(327) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465321))) 0.00019001960754395
(328) DESCRIBE `sailingdates` 0.00060796737670898
(329) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465322))) 0.00018811225891113
(330) DESCRIBE `sailingdates` 0.00070476531982422
(331) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465323))) 0.00041389465332031
(332) DESCRIBE `sailingdates` 0.00099706649780273
(333) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465324))) 0.00019502639770508
(334) DESCRIBE `sailingdates` 0.00063395500183105
(335) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465325))) 0.00019001960754395
(336) DESCRIBE `sailingdates` 0.00071191787719727
(337) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465326))) 0.00019693374633789
(338) DESCRIBE `sailingdates` 0.00060200691223145
(339) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465327))) 0.00020194053649902
(340) DESCRIBE `sailingdates` 0.00062704086303711
(341) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465328))) 0.00018596649169922
(342) DESCRIBE `sailingdates` 0.00060415267944336
(343) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465329))) 0.00018906593322754
(344) DESCRIBE `sailingdates` 0.00060105323791504
(345) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465330))) 0.00018501281738281
(346) DESCRIBE `sailingdates` 0.00063395500183105
(347) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465331))) 0.00018596649169922
(348) DESCRIBE `sailingdates` 0.0006110668182373
(349) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465332))) 0.00018596649169922
(350) DESCRIBE `sailingdates` 0.00061988830566406
(351) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465333))) 0.00018596649169922
(352) DESCRIBE `ports` 0.00072097778320312
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00021696090698242
(354) DESCRIBE `ports` 0.00071597099304199
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00020194053649902
(356) DESCRIBE `ports` 0.00068211555480957
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00023484230041504
(358) DESCRIBE `ports` 0.00086307525634766
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00025200843811035
(360) DESCRIBE `ports` 0.000762939453125
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00020408630371094
(362) DESCRIBE `ports` 0.00071096420288086
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00018191337585449
(364) DESCRIBE `ports` 0.0009610652923584
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00020217895507812
(366) DESCRIBE `ports` 0.0008389949798584
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00024294853210449
(368) DESCRIBE `ports` 0.00069284439086914
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00020289421081543
(370) DESCRIBE `ports` 0.00077390670776367
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00018906593322754
(372) DESCRIBE `cruises` 0.0013809204101562
(373) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 45259))) 0.00030517578125
(374) DESCRIBE `avid_specials` 0.00066018104553223
(375) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1420991 and class = 'Special') OR (item_id = 45259 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 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.0012509822845459
(376) DESCRIBE `cruiselines` 0.00095391273498535
(377) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00022506713867188
(378) DESCRIBE `orchid_image` 0.00075888633728027
(379) DESCRIBE `cruiselines` 0.0009160041809082
(380) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00018095970153809
(381) DESCRIBE `cruises` 0.0012068748474121
(382) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45259') 0.00019121170043945
(383) DESCRIBE `ships` 0.0013358592987061
(384) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00022578239440918
(385) DESCRIBE `ships` 0.0012581348419189
(386) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00017380714416504
(387) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017714500427246
(388) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017380714416504
(389) DESCRIBE `itineraries` 0.00070095062255859
(390) DESCRIBE `ports` 0.00071096420288086
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00021696090698242
(392) DESCRIBE `ports` 0.00067591667175293
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0001988410949707
(394) DESCRIBE `ports` 0.00067591667175293
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00018405914306641
(396) DESCRIBE `sailingdates` 0.00060701370239258
(397) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '45259') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0004889965057373
(398) DESCRIBE `ports` 0.00086021423339844
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00030303001403809
(400) DESCRIBE `ports` 0.0010569095611572
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00021696090698242
(402) DESCRIBE `ports` 0.00069594383239746
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00021505355834961
(404) DESCRIBE `ports` 0.00067806243896484
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00018405914306641
(406) DESCRIBE `ports` 0.00069618225097656
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00021791458129883
(408) DESCRIBE `ports` 0.00074410438537598
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00018811225891113
(410) DESCRIBE `ports` 0.0006871223449707
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00020408630371094
(412) DESCRIBE `ports` 0.00069403648376465
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00018310546875
(414) DESCRIBE `ports` 0.00067782402038574
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00020003318786621
(416) DESCRIBE `ports` 0.00074291229248047
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.0001838207244873
(418) DESCRIBE `avid_specials` 0.00061988830566406
(419) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 45259 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 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.0015008449554443
(420) DESCRIBE `cruiselines` 0.0013949871063232
(421) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00028109550476074
(422) DESCRIBE `orchid_image` 0.0010499954223633
(423) DESCRIBE `cruiselines` 0.0010850429534912
(424) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00019001960754395
(425) DESCRIBE `ships` 0.0013418197631836
(426) SELECT `ships`.* FROM `ships` WHERE (id IN ('517')) ORDER BY FIND_IN_SET(id, '517') 0.00026392936706543
(427) DESCRIBE `cruisetypes` 0.00059890747070312
(428) DESCRIBE `destinations` 0.00085997581481934
(429) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43')) ORDER BY FIND_IN_SET(id, '43') 0.00025105476379395
(430) DESCRIBE `cruiselines` 0.00093817710876465
(431) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00021982192993164
(432) DESCRIBE `cruiselines` 0.0010330677032471
(433) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00024199485778809