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

Total elapsed time: 0.1734094619751

# Query Time
(1) connect 0.00058603286743164
(2) DESCRIBE `cruises` 0.0017039775848389
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (45259, 45258)) ORDER BY FIND_IN_SET(id, '45259,45258') 0.000701904296875
(4) DESCRIBE `specials` 0.0020561218261719
(5) SELECT `specials`.* FROM `specials` WHERE (id = '1420991') AND (specials.orchid_available = 1) LIMIT 1 0.00053286552429199
(6) DESCRIBE `specials` 0.0023529529571533
(7) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1420991') 0.00025701522827148
(8) DESCRIBE `ships` 0.0015988349914551
(9) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.0002601146697998
(10) DESCRIBE `ships` 0.001115083694458
(11) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00018596649169922
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00016307830810547
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0001521110534668
(14) DESCRIBE `itineraries` 0.00060510635375977
(15) DESCRIBE `ports` 0.00064682960510254
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00019693374633789
(17) DESCRIBE `ports` 0.0005950927734375
(18) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00017690658569336
(19) DESCRIBE `ports` 0.00058794021606445
(20) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00016689300537109
(21) DESCRIBE `specialsailingdates` 0.00072717666625977
(22) DESCRIBE `sailingdates` 0.00064897537231445
(23) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465290))) 0.00023293495178223
(24) DESCRIBE `sailingdates` 0.00052690505981445
(25) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465291))) 0.00017213821411133
(26) DESCRIBE `sailingdates` 0.00052189826965332
(27) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465292))) 0.00017595291137695
(28) DESCRIBE `sailingdates` 0.00057101249694824
(29) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465293))) 0.00016498565673828
(30) DESCRIBE `sailingdates` 0.00051689147949219
(31) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465294))) 0.00016498565673828
(32) DESCRIBE `sailingdates` 0.00054502487182617
(33) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465295))) 0.00016498565673828
(34) DESCRIBE `sailingdates` 0.00055289268493652
(35) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465296))) 0.00020599365234375
(36) DESCRIBE `sailingdates` 0.00076007843017578
(37) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465297))) 0.0001678466796875
(38) DESCRIBE `sailingdates` 0.00072097778320312
(39) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465298))) 0.00022196769714355
(40) DESCRIBE `sailingdates` 0.00058603286743164
(41) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465299))) 0.00017690658569336
(42) DESCRIBE `sailingdates` 0.00087094306945801
(43) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465300))) 0.00035405158996582
(44) DESCRIBE `sailingdates` 0.00078320503234863
(45) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465301))) 0.00020694732666016
(46) DESCRIBE `sailingdates` 0.00065112113952637
(47) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465302))) 0.00019001960754395
(48) DESCRIBE `sailingdates` 0.00070405006408691
(49) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465303))) 0.0002589225769043
(50) DESCRIBE `sailingdates` 0.00090909004211426
(51) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465304))) 0.00024795532226562
(52) DESCRIBE `sailingdates` 0.00085902214050293
(53) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465305))) 0.00024199485778809
(54) DESCRIBE `sailingdates` 0.00086498260498047
(55) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465306))) 0.00024104118347168
(56) DESCRIBE `sailingdates` 0.00083708763122559
(57) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465307))) 0.00021886825561523
(58) DESCRIBE `sailingdates` 0.00086307525634766
(59) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465308))) 0.00022697448730469
(60) DESCRIBE `sailingdates` 0.0007932186126709
(61) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465309))) 0.00024104118347168
(62) DESCRIBE `sailingdates` 0.00094294548034668
(63) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465310))) 0.00023889541625977
(64) DESCRIBE `sailingdates` 0.00092506408691406
(65) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465311))) 0.00029301643371582
(66) DESCRIBE `sailingdates` 0.00066614151000977
(67) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465312))) 0.00019598007202148
(68) DESCRIBE `sailingdates` 0.00060510635375977
(69) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465313))) 0.00019311904907227
(70) DESCRIBE `sailingdates` 0.0006718635559082
(71) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465314))) 0.00019598007202148
(72) DESCRIBE `sailingdates` 0.00062799453735352
(73) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465315))) 0.00022387504577637
(74) DESCRIBE `sailingdates` 0.00081992149353027
(75) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465316))) 0.00021505355834961
(76) DESCRIBE `sailingdates` 0.00067591667175293
(77) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465317))) 0.00019097328186035
(78) DESCRIBE `sailingdates` 0.00060486793518066
(79) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465318))) 0.00019097328186035
(80) DESCRIBE `sailingdates` 0.00059890747070312
(81) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465319))) 0.00018787384033203
(82) DESCRIBE `sailingdates` 0.0005958080291748
(83) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465320))) 0.00019097328186035
(84) DESCRIBE `sailingdates` 0.00065708160400391
(85) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465321))) 0.00019693374633789
(86) DESCRIBE `sailingdates` 0.00063300132751465
(87) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465322))) 0.00019001960754395
(88) DESCRIBE `sailingdates` 0.00061202049255371
(89) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465323))) 0.00022006034851074
(90) DESCRIBE `sailingdates` 0.00067400932312012
(91) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465324))) 0.00020098686218262
(92) DESCRIBE `sailingdates` 0.00061202049255371
(93) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465325))) 0.00022006034851074
(94) DESCRIBE `sailingdates` 0.00072002410888672
(95) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465326))) 0.00019288063049316
(96) DESCRIBE `sailingdates` 0.00062298774719238
(97) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465327))) 0.00020599365234375
(98) DESCRIBE `sailingdates` 0.00062417984008789
(99) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465328))) 0.00019311904907227
(100) DESCRIBE `sailingdates` 0.00063896179199219
(101) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465329))) 0.00019407272338867
(102) DESCRIBE `sailingdates` 0.00060701370239258
(103) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465330))) 0.00022411346435547
(104) DESCRIBE `sailingdates` 0.00080108642578125
(105) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465331))) 0.00024199485778809
(106) DESCRIBE `sailingdates` 0.00063419342041016
(107) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465332))) 0.00019407272338867
(108) DESCRIBE `sailingdates` 0.00062990188598633
(109) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465333))) 0.00019598007202148
(110) DESCRIBE `ports` 0.00073099136352539
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0002281665802002
(112) DESCRIBE `ports` 0.00073719024658203
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00024294853210449
(114) DESCRIBE `ports` 0.00093793869018555
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00024104118347168
(116) DESCRIBE `ports` 0.00082993507385254
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00038409233093262
(118) DESCRIBE `ports` 0.0010149478912354
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00025486946105957
(120) DESCRIBE `ports` 0.00075197219848633
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.0001828670501709
(122) DESCRIBE `ports` 0.00073695182800293
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00021696090698242
(124) DESCRIBE `ports` 0.0006868839263916
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00017905235290527
(126) DESCRIBE `ports` 0.0006859302520752
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00023198127746582
(128) DESCRIBE `ports` 0.00086712837219238
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00025391578674316
(130) DESCRIBE `cruises` 0.001755952835083
(131) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 45259))) 0.0004570484161377
(132) DESCRIBE `avid_specials` 0.00082898139953613
(133) 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.0015659332275391
(134) DESCRIBE `cruiselines` 0.0013198852539062
(135) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00028705596923828
(136) DESCRIBE `orchid_image` 0.00096988677978516
(137) DESCRIBE `cruiselines` 0.0012900829315186
(138) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00022006034851074
(139) DESCRIBE `specials` 0.0016992092132568
(140) SELECT `specials`.* FROM `specials` WHERE (id = '1420976') AND (specials.orchid_available = 1) LIMIT 1 0.00043702125549316
(141) DESCRIBE `specials` 0.0025031566619873
(142) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1420976') 0.00024700164794922
(143) DESCRIBE `ships` 0.0012989044189453
(144) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00026297569274902
(145) DESCRIBE `ships` 0.001554012298584
(146) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00033211708068848
(147) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00021219253540039
(148) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00019502639770508
(149) DESCRIBE `itineraries` 0.00097513198852539
(150) DESCRIBE `ports` 0.0010659694671631
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00028395652770996
(152) DESCRIBE `ports` 0.00093507766723633
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00024795532226562
(154) DESCRIBE `ports` 0.0007319450378418
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00021696090698242
(156) DESCRIBE `specialsailingdates` 0.00057291984558105
(157) DESCRIBE `sailingdates` 0.00072503089904785
(158) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465343))) 0.00023508071899414
(159) DESCRIBE `sailingdates` 0.00060582160949707
(160) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465344))) 0.00017189979553223
(161) DESCRIBE `sailingdates` 0.0005340576171875
(162) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465345))) 0.00018191337585449
(163) DESCRIBE `sailingdates` 0.00058293342590332
(164) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465346))) 0.00017285346984863
(165) DESCRIBE `sailingdates` 0.00053906440734863
(166) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465347))) 0.00017094612121582
(167) DESCRIBE `sailingdates` 0.00053811073303223
(168) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465348))) 0.00017309188842773
(169) DESCRIBE `sailingdates` 0.00061297416687012
(170) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465349))) 0.00022006034851074
(171) DESCRIBE `sailingdates` 0.00075006484985352
(172) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465350))) 0.00021910667419434
(173) DESCRIBE `sailingdates` 0.0007331371307373
(174) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465351))) 0.00023698806762695
(175) DESCRIBE `sailingdates` 0.00072407722473145
(176) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465352))) 0.00022792816162109
(177) DESCRIBE `sailingdates` 0.00058698654174805
(178) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465353))) 0.00022506713867188
(179) DESCRIBE `sailingdates` 0.00062012672424316
(180) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465354))) 0.00017499923706055
(181) DESCRIBE `sailingdates` 0.00053501129150391
(182) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465355))) 0.00016379356384277
(183) DESCRIBE `sailingdates` 0.00054597854614258
(184) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465356))) 0.00017189979553223
(185) DESCRIBE `sailingdates` 0.00055813789367676
(186) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465357))) 0.00017309188842773
(187) DESCRIBE `sailingdates` 0.00053095817565918
(188) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465358))) 0.00016689300537109
(189) DESCRIBE `sailingdates` 0.0005638599395752
(190) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465359))) 0.00017094612121582
(191) DESCRIBE `sailingdates` 0.00053501129150391
(192) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465360))) 0.0001678466796875
(193) DESCRIBE `sailingdates` 0.00052595138549805
(194) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465361))) 0.00022506713867188
(195) DESCRIBE `sailingdates` 0.00064897537231445
(196) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465362))) 0.00017809867858887
(197) DESCRIBE `sailingdates` 0.00058603286743164
(198) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465363))) 0.00017309188842773
(199) DESCRIBE `sailingdates` 0.00068306922912598
(200) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465364))) 0.00018501281738281
(201) DESCRIBE `sailingdates` 0.0005650520324707
(202) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465365))) 0.00017380714416504
(203) DESCRIBE `sailingdates` 0.0005340576171875
(204) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465366))) 0.00017094612121582
(205) DESCRIBE `sailingdates` 0.0006558895111084
(206) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465367))) 0.00021886825561523
(207) DESCRIBE `sailingdates` 0.00071310997009277
(208) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465368))) 0.00022292137145996
(209) DESCRIBE `sailingdates` 0.00079703330993652
(210) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465369))) 0.00023388862609863
(211) DESCRIBE `sailingdates` 0.00079703330993652
(212) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465370))) 0.00022101402282715
(213) DESCRIBE `sailingdates` 0.00057506561279297
(214) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465371))) 0.00019001960754395
(215) DESCRIBE `sailingdates` 0.00052881240844727
(216) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465372))) 0.00019311904907227
(217) DESCRIBE `sailingdates` 0.00059819221496582
(218) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465373))) 0.00017690658569336
(219) DESCRIBE `sailingdates` 0.00054788589477539
(220) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465374))) 0.00017380714416504
(221) DESCRIBE `sailingdates` 0.00058293342590332
(222) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465375))) 0.00021696090698242
(223) DESCRIBE `sailingdates` 0.00055313110351562
(224) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465376))) 0.00017309188842773
(225) DESCRIBE `sailingdates` 0.00056695938110352
(226) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465377))) 0.00020718574523926
(227) DESCRIBE `sailingdates` 0.00068783760070801
(228) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465378))) 0.00019502639770508
(229) DESCRIBE `sailingdates` 0.00054502487182617
(230) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465379))) 0.00016617774963379
(231) DESCRIBE `sailingdates` 0.00052499771118164
(232) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465380))) 0.00016498565673828
(233) DESCRIBE `sailingdates` 0.00052595138549805
(234) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465381))) 0.0001678466796875
(235) DESCRIBE `sailingdates` 0.00058412551879883
(236) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465382))) 0.00016593933105469
(237) DESCRIBE `sailingdates` 0.00052905082702637
(238) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465383))) 0.00019216537475586
(239) DESCRIBE `sailingdates` 0.00053691864013672
(240) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465384))) 0.00017881393432617
(241) DESCRIBE `sailingdates` 0.00052785873413086
(242) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465385))) 0.00016403198242188
(243) DESCRIBE `sailingdates` 0.00053501129150391
(244) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465386))) 0.00016498565673828
(245) DESCRIBE `ports` 0.00069713592529297
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0001990795135498
(247) DESCRIBE `ports` 0.00059890747070312
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00017213821411133
(249) DESCRIBE `ports` 0.00061297416687012
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00019097328186035
(251) DESCRIBE `ports` 0.00060296058654785
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00016188621520996
(253) DESCRIBE `ports` 0.00059008598327637
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00017595291137695
(255) DESCRIBE `ports` 0.00060606002807617
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00016188621520996
(257) DESCRIBE `ports` 0.00058698654174805
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00018191337585449
(259) DESCRIBE `ports` 0.00063395500183105
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00016903877258301
(261) DESCRIBE `ports` 0.00065898895263672
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00017809867858887
(263) DESCRIBE `ports` 0.0006110668182373
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00016212463378906
(265) DESCRIBE `ports` 0.00058698654174805
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00020003318786621
(267) DESCRIBE `ports` 0.00067687034606934
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00021100044250488
(269) DESCRIBE `ports` 0.00081801414489746
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00019001960754395
(271) DESCRIBE `ports` 0.00059390068054199
(272) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00016403198242188
(273) DESCRIBE `ports` 0.00060486793518066
(274) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00017690658569336
(275) DESCRIBE `ports` 0.00058603286743164
(276) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00019598007202148
(277) DESCRIBE `cruises` 0.0011460781097412
(278) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 45258))) 0.00029397010803223
(279) DESCRIBE `avid_specials` 0.0005500316619873
(280) 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.0008549690246582
(281) DESCRIBE `cruiselines` 0.00087904930114746
(282) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00020718574523926
(283) DESCRIBE `orchid_image` 0.00067782402038574
(284) DESCRIBE `cruiselines` 0.00086402893066406
(285) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.0001680850982666
(286) DESCRIBE `ships` 0.0011899471282959
(287) SELECT `ships`.* FROM `ships` WHERE (id IN ('517')) ORDER BY FIND_IN_SET(id, '517') 0.00025486946105957
(288) DESCRIBE `cruisetypes` 0.00052595138549805
(289) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '47') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.024912118911743
(290) DESCRIBE `destinations` 0.0016870498657227
(291) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43')) ORDER BY FIND_IN_SET(id, '43') 0.00036287307739258
(292) DESCRIBE `cruiselines` 0.0012819766998291
(293) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00028181076049805
(294) DESCRIBE `cruiselines` 0.0016000270843506
(295) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00033712387084961