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

Total elapsed time: 0.43166565895081

# Query Time
(1) connect 0.00072407722473145
(2) DESCRIBE `cruises` 0.0016880035400391
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66959, 11517, 69465, 45259, 66859, 66414, 67892, 69524, 66478, 66529)) ORDER BY FIND_IN_SET(id, '66959,11517,69465,45259,66859,66414,67892,69524,66478,66529') 0.0010900497436523
(4) DESCRIBE `specials` 0.0020661354064941
(5) SELECT `specials`.* FROM `specials` WHERE (id = '1444901') AND (specials.orchid_available = 1) LIMIT 1 0.00043702125549316
(6) DESCRIBE `specials` 0.002086877822876
(7) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1444901') 0.00020098686218262
(8) DESCRIBE `ships` 0.0015809535980225
(9) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 335))) 0.00024700164794922
(10) DESCRIBE `ships` 0.0012521743774414
(11) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '335') 0.00017690658569336
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017595291137695
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00020790100097656
(14) DESCRIBE `itineraries` 0.00067615509033203
(15) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66959') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00061893463134766
(16) DESCRIBE `ports` 0.0010850429534912
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00030708312988281
(18) DESCRIBE `ports` 0.0010449886322021
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00028395652770996
(20) DESCRIBE `ports` 0.00099706649780273
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00027108192443848
(22) DESCRIBE `specialsailingdates` 0.00059795379638672
(23) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1444901') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00047183036804199
(24) DESCRIBE `sailingdates` 0.00078296661376953
(25) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 420111))) 0.00022411346435547
(26) DESCRIBE `ports` 0.0010190010070801
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00031208992004395
(28) DESCRIBE `ports` 0.001060962677002
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00027704238891602
(30) DESCRIBE `ports` 0.0010049343109131
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.0002901554107666
(32) DESCRIBE `ports` 0.0010471343994141
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00025391578674316
(34) DESCRIBE `ports` 0.00099015235900879
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00021195411682129
(36) DESCRIBE `ports` 0.00072312355041504
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00018405914306641
(38) DESCRIBE `ports` 0.00067996978759766
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00020098686218262
(40) DESCRIBE `ports` 0.00069308280944824
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00021910667419434
(42) DESCRIBE `ports` 0.0008540153503418
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00028204917907715
(44) DESCRIBE `ports` 0.00097489356994629
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00025296211242676
(46) DESCRIBE `ports` 0.00089502334594727
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00024700164794922
(48) DESCRIBE `ports` 0.00089597702026367
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00025391578674316
(50) DESCRIBE `ports` 0.00088787078857422
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00025486946105957
(52) DESCRIBE `ports` 0.0009150505065918
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00021004676818848
(54) DESCRIBE `ports` 0.00068306922912598
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00020194053649902
(56) DESCRIBE `ports` 0.00074601173400879
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00018095970153809
(58) DESCRIBE `ports` 0.0006709098815918
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00024008750915527
(60) DESCRIBE `ports` 0.00067496299743652
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00018811225891113
(62) DESCRIBE `cruises` 0.0013039112091064
(63) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 66959))) 0.00029706954956055
(64) DESCRIBE `avid_specials` 0.00064802169799805
(65) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1444901 and class = 'Special') OR (item_id = 66959 and class = 'Cruise') OR (item_id = 335 AND class = 'Ship') OR (item_id = 18 AND class = 'CruiseLine') OR (item_id = 26 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.0009458065032959
(66) DESCRIBE `cruiselines` 0.0011091232299805
(67) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00024795532226562
(68) DESCRIBE `orchid_image` 0.00083303451538086
(69) DESCRIBE `cruiselines` 0.0012431144714355
(70) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00027298927307129
(71) DESCRIBE `specials` 0.0027749538421631
(72) SELECT `specials`.* FROM `specials` WHERE (id = '1444940') AND (specials.orchid_available = 1) LIMIT 1 0.00048494338989258
(73) DESCRIBE `specials` 0.0026891231536865
(74) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1444940') 0.0002748966217041
(75) DESCRIBE `ships` 0.0020780563354492
(76) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 521))) 0.00034809112548828
(77) DESCRIBE `ships` 0.0018899440765381
(78) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '521') 0.00026202201843262
(79) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021600723266602
(80) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017499923706055
(81) DESCRIBE `itineraries` 0.00080680847167969
(82) DESCRIBE `ports` 0.0009310245513916
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00028800964355469
(84) DESCRIBE `ports` 0.000701904296875
(85) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00021100044250488
(86) DESCRIBE `ports` 0.00075483322143555
(87) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00022196769714355
(88) DESCRIBE `specialsailingdates` 0.00058197975158691
(89) DESCRIBE `sailingdates` 0.00065994262695312
(90) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423023))) 0.00035405158996582
(91) DESCRIBE `sailingdates` 0.0006258487701416
(92) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423024))) 0.00021195411682129
(93) DESCRIBE `sailingdates` 0.00060200691223145
(94) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423026))) 0.00023698806762695
(95) DESCRIBE `ports` 0.00069904327392578
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00023603439331055
(97) DESCRIBE `ports` 0.00071883201599121
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00019598007202148
(99) DESCRIBE `ports` 0.00068783760070801
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.00020098686218262
(101) DESCRIBE `ports` 0.00071907043457031
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.00018405914306641
(103) DESCRIBE `ports` 0.00070405006408691
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5160))) 0.00021696090698242
(105) DESCRIBE `ports` 0.00069785118103027
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5160') 0.00019001960754395
(107) DESCRIBE `ports` 0.00073885917663574
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00020599365234375
(109) DESCRIBE `ports` 0.00090312957763672
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00024604797363281
(111) DESCRIBE `ports` 0.00072193145751953
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.0002129077911377
(113) DESCRIBE `ports` 0.00069904327392578
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00018596649169922
(115) DESCRIBE `ports` 0.00068402290344238
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00020289421081543
(117) DESCRIBE `ports` 0.00068807601928711
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00018596649169922
(119) DESCRIBE `ports` 0.00070810317993164
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00019598007202148
(121) DESCRIBE `ports` 0.00067019462585449
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00019192695617676
(123) DESCRIBE `ports` 0.0010719299316406
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00024700164794922
(125) DESCRIBE `ports` 0.00082206726074219
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00020503997802734
(127) DESCRIBE `ports` 0.00081586837768555
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00020599365234375
(129) DESCRIBE `ports` 0.00068187713623047
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00019216537475586
(131) DESCRIBE `ports` 0.00066804885864258
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00022220611572266
(133) DESCRIBE `ports` 0.00076889991760254
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00018000602722168
(135) DESCRIBE `cruises` 0.0014190673828125
(136) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 11517))) 0.00040388107299805
(137) DESCRIBE `avid_specials` 0.00081706047058105
(138) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1444940 and class = 'Special') OR (item_id = 11517 and class = 'Cruise') OR (item_id = 521 AND class = 'Ship') OR (item_id = 120 AND class = 'CruiseLine') OR (item_id = 54 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.0010261535644531
(139) DESCRIBE `cruiselines` 0.0010640621185303
(140) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00024199485778809
(141) DESCRIBE `orchid_image` 0.00079488754272461
(142) DESCRIBE `cruiselines` 0.00097799301147461
(143) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00022721290588379
(144) DESCRIBE `specials` 0.0019750595092773
(145) SELECT `specials`.* FROM `specials` WHERE (id = '1431904') AND (specials.orchid_available = 1) LIMIT 1 0.00040793418884277
(146) DESCRIBE `specials` 0.0018529891967773
(147) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1431904') 0.0002291202545166
(148) DESCRIBE `ships` 0.0013339519500732
(149) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1282))) 0.00030112266540527
(150) DESCRIBE `ships` 0.0014090538024902
(151) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1282') 0.00024700164794922
(152) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00020313262939453
(153) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00020980834960938
(154) DESCRIBE `itineraries` 0.00081300735473633
(155) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '69465') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010290145874023
(156) DESCRIBE `ports` 0.00079202651977539
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00025510787963867
(158) DESCRIBE `ports` 0.00071406364440918
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00021004676818848
(160) DESCRIBE `ports` 0.00070405006408691
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.0001990795135498
(162) DESCRIBE `specialsailingdates` 0.00058507919311523
(163) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1431904') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00056099891662598
(164) DESCRIBE `sailingdates` 0.00070309638977051
(165) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 436294))) 0.00019598007202148
(166) DESCRIBE `ports` 0.00070381164550781
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00021481513977051
(168) DESCRIBE `ports` 0.00085306167602539
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00020003318786621
(170) DESCRIBE `ports` 0.00067901611328125
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00020313262939453
(172) DESCRIBE `ports` 0.00071597099304199
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00018310546875
(174) DESCRIBE `ports` 0.00069117546081543
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00020194053649902
(176) DESCRIBE `ports` 0.00067806243896484
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00018310546875
(178) DESCRIBE `ports` 0.00069499015808105
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00022602081298828
(180) DESCRIBE `ports` 0.00069499015808105
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00018215179443359
(182) DESCRIBE `ports` 0.00067305564880371
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) 0.00024890899658203
(184) DESCRIBE `ports` 0.00070786476135254
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') 0.00018501281738281
(186) DESCRIBE `ports` 0.00077509880065918
(187) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) 0.00021004676818848
(188) DESCRIBE `ports` 0.00078296661376953
(189) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') 0.00018501281738281
(190) DESCRIBE `ports` 0.00072693824768066
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1659))) 0.00020313262939453
(192) DESCRIBE `ports` 0.00070905685424805
(193) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1659') 0.00018596649169922
(194) DESCRIBE `ports` 0.00083112716674805
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 783))) 0.00021195411682129
(196) DESCRIBE `ports` 0.00071501731872559
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '783') 0.00018501281738281
(198) DESCRIBE `ports` 0.00091791152954102
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 571))) 0.00020599365234375
(200) DESCRIBE `ports` 0.00076603889465332
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '571') 0.00018405914306641
(202) DESCRIBE `ports` 0.00090813636779785
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 778))) 0.00021600723266602
(204) DESCRIBE `ports` 0.00075912475585938
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '778') 0.00018596649169922
(206) DESCRIBE `ports` 0.00068187713623047
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 778))) 0.00020599365234375
(208) DESCRIBE `ports` 0.000762939453125
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '778') 0.00018596649169922
(210) DESCRIBE `cruises` 0.0013329982757568
(211) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 69465))) 0.00029683113098145
(212) DESCRIBE `avid_specials` 0.00067901611328125
(213) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1431904 and class = 'Special') OR (item_id = 69465 and class = 'Cruise') OR (item_id = 1282 AND class = 'Ship') OR (item_id = 33 AND class = 'CruiseLine') OR (item_id = 21 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.0010368824005127
(214) DESCRIBE `cruiselines` 0.0010011196136475
(215) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00022101402282715
(216) DESCRIBE `orchid_image` 0.000762939453125
(217) DESCRIBE `cruiselines` 0.00094699859619141
(218) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00018906593322754
(219) DESCRIBE `specials` 0.0019559860229492
(220) SELECT `specials`.* FROM `specials` WHERE (id = '1435809') AND (specials.orchid_available = 1) LIMIT 1 0.00036311149597168
(221) DESCRIBE `specials` 0.0020020008087158
(222) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1435809') 0.00020694732666016
(223) DESCRIBE `ships` 0.00130295753479
(224) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.0002439022064209
(225) DESCRIBE `ships` 0.0012810230255127
(226) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00021505355834961
(227) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017404556274414
(228) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00016307830810547
(229) DESCRIBE `itineraries` 0.00068402290344238
(230) DESCRIBE `ports` 0.00078797340393066
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00022077560424805
(232) DESCRIBE `ports` 0.0007479190826416
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00031399726867676
(234) DESCRIBE `ports` 0.00099420547485352
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00020599365234375
(236) DESCRIBE `specialsailingdates` 0.00057101249694824
(237) DESCRIBE `sailingdates` 0.00062394142150879
(238) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465300))) 0.00034499168395996
(239) DESCRIBE `sailingdates` 0.00073409080505371
(240) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465301))) 0.00019502639770508
(241) DESCRIBE `sailingdates` 0.0006101131439209
(242) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465302))) 0.00019001960754395
(243) DESCRIBE `sailingdates` 0.00059795379638672
(244) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465303))) 0.00020289421081543
(245) DESCRIBE `sailingdates` 0.00059795379638672
(246) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465304))) 0.00018906593322754
(247) DESCRIBE `sailingdates` 0.00062990188598633
(248) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465305))) 0.00018787384033203
(249) DESCRIBE `sailingdates` 0.00059890747070312
(250) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465306))) 0.00018906593322754
(251) DESCRIBE `sailingdates` 0.00062680244445801
(252) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465307))) 0.00018882751464844
(253) DESCRIBE `sailingdates` 0.00066208839416504
(254) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465308))) 0.00019216537475586
(255) DESCRIBE `sailingdates` 0.00061488151550293
(256) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465309))) 0.00018906593322754
(257) DESCRIBE `sailingdates` 0.00066804885864258
(258) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465310))) 0.00019097328186035
(259) DESCRIBE `sailingdates` 0.00060105323791504
(260) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465311))) 0.00018882751464844
(261) DESCRIBE `sailingdates` 0.00062298774719238
(262) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465312))) 0.00018811225891113
(263) DESCRIBE `sailingdates` 0.0006260871887207
(264) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465313))) 0.00018906593322754
(265) DESCRIBE `sailingdates` 0.00060105323791504
(266) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465314))) 0.00020503997802734
(267) DESCRIBE `sailingdates` 0.00080299377441406
(268) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465315))) 0.00023984909057617
(269) DESCRIBE `sailingdates` 0.00065898895263672
(270) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465316))) 0.00019097328186035
(271) DESCRIBE `sailingdates` 0.00060582160949707
(272) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465317))) 0.00019001960754395
(273) DESCRIBE `sailingdates` 0.0006871223449707
(274) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465318))) 0.00019001960754395
(275) DESCRIBE `sailingdates` 0.00062680244445801
(276) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465319))) 0.00019121170043945
(277) DESCRIBE `sailingdates` 0.00062394142150879
(278) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465320))) 0.00018882751464844
(279) DESCRIBE `sailingdates` 0.00062894821166992
(280) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465321))) 0.0001981258392334
(281) DESCRIBE `sailingdates` 0.00061607360839844
(282) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465322))) 0.00019001960754395
(283) DESCRIBE `sailingdates` 0.00069308280944824
(284) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465323))) 0.00025105476379395
(285) DESCRIBE `sailingdates` 0.00085711479187012
(286) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465324))) 0.00024080276489258
(287) DESCRIBE `sailingdates` 0.00077199935913086
(288) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465325))) 0.00023293495178223
(289) DESCRIBE `sailingdates` 0.00077414512634277
(290) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465326))) 0.00023007392883301
(291) DESCRIBE `sailingdates` 0.00076603889465332
(292) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465327))) 0.0002281665802002
(293) DESCRIBE `sailingdates` 0.00064206123352051
(294) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465328))) 0.00019216537475586
(295) DESCRIBE `sailingdates` 0.0006110668182373
(296) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465329))) 0.00019097328186035
(297) DESCRIBE `sailingdates` 0.00063800811767578
(298) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465330))) 0.00022482872009277
(299) DESCRIBE `sailingdates` 0.00060510635375977
(300) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465331))) 0.00021791458129883
(301) DESCRIBE `sailingdates` 0.00062704086303711
(302) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465332))) 0.00018882751464844
(303) DESCRIBE `sailingdates` 0.00062394142150879
(304) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465333))) 0.00021100044250488
(305) DESCRIBE `ports` 0.00071811676025391
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00023889541625977
(307) DESCRIBE `ports` 0.00068497657775879
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00019478797912598
(309) DESCRIBE `ports` 0.00067901611328125
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00020289421081543
(311) DESCRIBE `ports` 0.00066900253295898
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00020599365234375
(313) DESCRIBE `ports` 0.00071883201599121
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00020599365234375
(315) DESCRIBE `ports` 0.00067687034606934
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00018000602722168
(317) DESCRIBE `ports` 0.00068402290344238
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.0001990795135498
(319) DESCRIBE `ports` 0.00071501731872559
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00018119812011719
(321) DESCRIBE `ports` 0.00067019462585449
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0001988410949707
(323) DESCRIBE `ports` 0.0006859302520752
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00018191337585449
(325) DESCRIBE `cruises` 0.0013189315795898
(326) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 45259))) 0.00030994415283203
(327) DESCRIBE `avid_specials` 0.00063395500183105
(328) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1435809 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.00096893310546875
(329) DESCRIBE `cruiselines` 0.00097084045410156
(330) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00021910667419434
(331) DESCRIBE `orchid_image` 0.00076889991760254
(332) DESCRIBE `cruiselines` 0.00094795227050781
(333) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00019693374633789
(334) DESCRIBE `specials` 0.0018680095672607
(335) SELECT `specials`.* FROM `specials` WHERE (id = '1427648') AND (specials.orchid_available = 1) LIMIT 1 0.00037193298339844
(336) DESCRIBE `specials` 0.0018270015716553
(337) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1427648') 0.00024509429931641
(338) DESCRIBE `ships` 0.0014629364013672
(339) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 722))) 0.00027108192443848
(340) DESCRIBE `ships` 0.0014100074768066
(341) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '722') 0.00022006034851074
(342) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018596649169922
(343) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017189979553223
(344) DESCRIBE `itineraries` 0.00074601173400879
(345) DESCRIBE `ports` 0.00099420547485352
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00026798248291016
(347) DESCRIBE `ports` 0.00073099136352539
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020599365234375
(349) DESCRIBE `ports` 0.00071001052856445
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0001981258392334
(351) DESCRIBE `specialsailingdates` 0.00060105323791504
(352) DESCRIBE `sailingdates` 0.00067400932312012
(353) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419625))) 0.00024914741516113
(354) DESCRIBE `ports` 0.0010151863098145
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00022387504577637
(356) DESCRIBE `ports` 0.0007779598236084
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00029301643371582
(358) DESCRIBE `ports` 0.00098204612731934
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00045895576477051
(360) DESCRIBE `ports` 0.0012240409851074
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00026202201843262
(362) DESCRIBE `ports` 0.00080108642578125
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.0002138614654541
(364) DESCRIBE `ports` 0.00068998336791992
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00018906593322754
(366) DESCRIBE `ports` 0.00070309638977051
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00020694732666016
(368) DESCRIBE `ports` 0.00068211555480957
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00019288063049316
(370) DESCRIBE `ports` 0.00070595741271973
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00020503997802734
(372) DESCRIBE `ports` 0.00070881843566895
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00018000602722168
(374) DESCRIBE `ports` 0.00068116188049316
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00021004676818848
(376) DESCRIBE `ports` 0.00068497657775879
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00019288063049316
(378) DESCRIBE `cruises` 0.0014011859893799
(379) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 66859))) 0.00030612945556641
(380) DESCRIBE `avid_specials` 0.00066494941711426
(381) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1427648 and class = 'Special') OR (item_id = 66859 and class = 'Cruise') OR (item_id = 722 AND class = 'Ship') OR (item_id = 8 AND class = 'CruiseLine') OR (item_id = 12 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.0009310245513916
(382) DESCRIBE `cruiselines` 0.00096297264099121
(383) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.0002288818359375
(384) DESCRIBE `orchid_image` 0.00080513954162598
(385) DESCRIBE `cruiselines` 0.000946044921875
(386) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00020217895507812
(387) DESCRIBE `specials` 0.0018799304962158
(388) SELECT `specials`.* FROM `specials` WHERE (id = '1427634') AND (specials.orchid_available = 1) LIMIT 1 0.0003809928894043
(389) DESCRIBE `specials` 0.0017919540405273
(390) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1427634') 0.0002131462097168
(391) DESCRIBE `ships` 0.0013470649719238
(392) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 45))) 0.0002589225769043
(393) DESCRIBE `ships` 0.0013251304626465
(394) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '45') 0.00020885467529297
(395) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00023078918457031
(396) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018191337585449
(397) DESCRIBE `itineraries` 0.0007469654083252
(398) DESCRIBE `ports` 0.00078582763671875
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.0002448558807373
(400) DESCRIBE `ports` 0.00069880485534668
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00020384788513184
(402) DESCRIBE `ports` 0.00069904327392578
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00019502639770508
(404) DESCRIBE `specialsailingdates` 0.00060415267944336
(405) DESCRIBE `sailingdates` 0.0006248950958252
(406) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 417534))) 0.00025701522827148
(407) DESCRIBE `ports` 0.00075507164001465
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00022315979003906
(409) DESCRIBE `ports` 0.0006868839263916
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00019502639770508
(411) DESCRIBE `ports` 0.00068902969360352
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00021100044250488
(413) DESCRIBE `ports` 0.00071382522583008
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00018906593322754
(415) DESCRIBE `ports` 0.0006868839263916
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00020503997802734
(417) DESCRIBE `ports` 0.00071382522583008
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00019502639770508
(419) DESCRIBE `ports` 0.00074291229248047
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 553))) 0.00020718574523926
(421) DESCRIBE `ports` 0.00067806243896484
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '553') 0.0001828670501709
(423) DESCRIBE `ports` 0.00067806243896484
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00020098686218262
(425) DESCRIBE `ports` 0.00069618225097656
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00018310546875
(427) DESCRIBE `ports` 0.00067615509033203
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00026798248291016
(429) DESCRIBE `ports` 0.00076484680175781
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00018405914306641
(431) DESCRIBE `ports` 0.00068402290344238
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00020718574523926
(433) DESCRIBE `ports` 0.00072503089904785
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00019001960754395
(435) DESCRIBE `ports` 0.00070595741271973
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00020503997802734
(437) DESCRIBE `ports` 0.00071501731872559
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00019097328186035
(439) DESCRIBE `cruises` 0.0013151168823242
(440) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 66414))) 0.00035595893859863
(441) DESCRIBE `avid_specials` 0.00063490867614746
(442) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1427634 and class = 'Special') OR (item_id = 66414 and class = 'Cruise') OR (item_id = 45 AND class = 'Ship') OR (item_id = 8 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.00093698501586914
(443) DESCRIBE `cruiselines` 0.0011138916015625
(444) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00022602081298828
(445) DESCRIBE `orchid_image` 0.00075984001159668
(446) DESCRIBE `cruiselines` 0.00097203254699707
(447) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00020408630371094
(448) DESCRIBE `specials` 0.0027589797973633
(449) SELECT `specials`.* FROM `specials` WHERE (id = '1433404') AND (specials.orchid_available = 1) LIMIT 1 0.00053000450134277
(450) DESCRIBE `specials` 0.0025620460510254
(451) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1433404') 0.00028896331787109
(452) DESCRIBE `ships` 0.0014200210571289
(453) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 163))) 0.00026488304138184
(454) DESCRIBE `ships` 0.001255989074707
(455) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '163') 0.00022196769714355
(456) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017690658569336
(457) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016403198242188
(458) DESCRIBE `itineraries` 0.00077700614929199
(459) DESCRIBE `ports` 0.00069284439086914
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00022506713867188
(461) DESCRIBE `ports` 0.00074386596679688
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00019192695617676
(463) DESCRIBE `ports` 0.00066709518432617
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00019121170043945
(465) DESCRIBE `specialsailingdates` 0.00056815147399902
(466) DESCRIBE `sailingdates` 0.00059008598327637
(467) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 428412))) 0.00033020973205566
(468) DESCRIBE `ports` 0.00069594383239746
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00019502639770508
(470) DESCRIBE `ports` 0.0006709098815918
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00019288063049316
(472) DESCRIBE `ports` 0.00069308280944824
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00025105476379395
(474) DESCRIBE `ports` 0.00088596343994141
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00017809867858887
(476) DESCRIBE `ports` 0.00072193145751953
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00019311904907227
(478) DESCRIBE `ports` 0.00065898895263672
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00017499923706055
(480) DESCRIBE `ports` 0.00067710876464844
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00028109550476074
(482) DESCRIBE `ports` 0.001215934753418
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00022101402282715
(484) DESCRIBE `ports` 0.00068306922912598
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 585))) 0.00023221969604492
(486) DESCRIBE `ports` 0.00078511238098145
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '585') 0.00021600723266602
(488) DESCRIBE `ports` 0.00082516670227051
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00021100044250488
(490) DESCRIBE `ports` 0.00090312957763672
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00023913383483887
(492) DESCRIBE `ports` 0.00096607208251953
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00025296211242676
(494) DESCRIBE `ports` 0.0010330677032471
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00025391578674316
(496) DESCRIBE `ports` 0.0010151863098145
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 514))) 0.00026512145996094
(498) DESCRIBE `ports` 0.0010499954223633
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '514') 0.0002439022064209
(500) DESCRIBE `ports` 0.0010049343109131
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00026702880859375
(502) DESCRIBE `ports` 0.0010228157043457
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.0002601146697998
(504) DESCRIBE `cruises` 0.0020079612731934
(505) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 67892))) 0.00040411949157715
(506) DESCRIBE `avid_specials` 0.00091099739074707
(507) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1433404 and class = 'Special') OR (item_id = 67892 and class = 'Cruise') OR (item_id = 163 AND class = 'Ship') OR (item_id = 33 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.0017330646514893
(508) DESCRIBE `cruiselines` 0.0010261535644531
(509) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00022387504577637
(510) DESCRIBE `orchid_image` 0.00075411796569824
(511) DESCRIBE `cruiselines` 0.00093388557434082
(512) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00018310546875
(513) DESCRIBE `specials` 0.0020589828491211
(514) SELECT `specials`.* FROM `specials` WHERE (id = '1432013') AND (specials.orchid_available = 1) LIMIT 1 0.00043511390686035
(515) DESCRIBE `specials` 0.0036251544952393
(516) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1432013') 0.00030303001403809
(517) DESCRIBE `ships` 0.0015439987182617
(518) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 160))) 0.00029611587524414
(519) DESCRIBE `ships` 0.0013279914855957
(520) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '160') 0.00020194053649902
(521) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00020384788513184
(522) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016498565673828
(523) DESCRIBE `itineraries` 0.00085783004760742
(524) DESCRIBE `ports` 0.00085282325744629
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00022983551025391
(526) DESCRIBE `ports` 0.00075197219848633
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020503997802734
(528) DESCRIBE `ports` 0.00070405006408691
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00022196769714355
(530) DESCRIBE `specialsailingdates` 0.00062108039855957
(531) DESCRIBE `sailingdates` 0.00063204765319824
(532) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 436537))) 0.00024890899658203
(533) DESCRIBE `ports` 0.00073003768920898
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00020313262939453
(535) DESCRIBE `ports` 0.0006721019744873
(536) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00018596649169922
(537) DESCRIBE `ports` 0.00068092346191406
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00019598007202148
(539) DESCRIBE `ports` 0.00066304206848145
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00020909309387207
(541) DESCRIBE `ports` 0.00067496299743652
(542) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1493))) 0.00023603439331055
(543) DESCRIBE `ports` 0.00082898139953613
(544) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1493') 0.00018095970153809
(545) DESCRIBE `ports` 0.00067496299743652
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 696))) 0.00019598007202148
(547) DESCRIBE `ports` 0.00074291229248047
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '696') 0.00017595291137695
(549) DESCRIBE `ports` 0.0006709098815918
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 392))) 0.0001981258392334
(551) DESCRIBE `ports` 0.00066709518432617
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '392') 0.00017595291137695
(553) DESCRIBE `ports` 0.00070405006408691
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 246))) 0.00023508071899414
(555) DESCRIBE `ports` 0.00079107284545898
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '246') 0.00018095970153809
(557) DESCRIBE `ports` 0.00071096420288086
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 531))) 0.00020885467529297
(559) DESCRIBE `ports` 0.0007929801940918
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '531') 0.00024104118347168
(561) DESCRIBE `ports` 0.00098896026611328
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 247))) 0.00027298927307129
(563) DESCRIBE `ports` 0.0010130405426025
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '247') 0.00024199485778809
(565) DESCRIBE `cruises` 0.0019979476928711
(566) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 69524))) 0.00042295455932617
(567) DESCRIBE `avid_specials` 0.0011100769042969
(568) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1432013 and class = 'Special') OR (item_id = 69524 and class = 'Cruise') OR (item_id = 160 AND class = 'Ship') OR (item_id = 33 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.0018930435180664
(569) DESCRIBE `cruiselines` 0.0015671253204346
(570) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00032997131347656
(571) DESCRIBE `orchid_image` 0.0012249946594238
(572) DESCRIBE `cruiselines` 0.0014781951904297
(573) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.0002899169921875
(574) DESCRIBE `specials` 0.0030989646911621
(575) SELECT `specials`.* FROM `specials` WHERE (id = '1434186') AND (specials.orchid_available = 1) LIMIT 1 0.00041317939758301
(576) DESCRIBE `specials` 0.0018711090087891
(577) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1434186') 0.00021100044250488
(578) DESCRIBE `ships` 0.0012900829315186
(579) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 406))) 0.00026297569274902
(580) DESCRIBE `ships` 0.0012929439544678
(581) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '406') 0.0001828670501709
(582) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017499923706055
(583) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016498565673828
(584) DESCRIBE `itineraries` 0.00070381164550781
(585) DESCRIBE `ports` 0.00069308280944824
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00021219253540039
(587) DESCRIBE `ports` 0.00069308280944824
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00019192695617676
(589) DESCRIBE `ports` 0.00067591667175293
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00019216537475586
(591) DESCRIBE `specialsailingdates` 0.00056791305541992
(592) DESCRIBE `sailingdates` 0.00064992904663086
(593) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 417797))) 0.00034689903259277
(594) DESCRIBE `ports` 0.00075387954711914
(595) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00028014183044434
(596) DESCRIBE `ports` 0.00071477890014648
(597) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00019192695617676
(598) DESCRIBE `ports` 0.00068211555480957
(599) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 517))) 0.00020599365234375
(600) DESCRIBE `ports` 0.00068211555480957
(601) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '517') 0.00021910667419434
(602) DESCRIBE `ports` 0.00067687034606934
(603) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0002140998840332
(604) DESCRIBE `ports` 0.00068092346191406
(605) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00019288063049316
(606) DESCRIBE `ports` 0.00069093704223633
(607) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00020694732666016
(608) DESCRIBE `ports` 0.00067996978759766
(609) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00018501281738281
(610) DESCRIBE `ports` 0.00071978569030762
(611) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00020599365234375
(612) DESCRIBE `ports` 0.00071382522583008
(613) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00018715858459473
(614) DESCRIBE `ports` 0.0006718635559082
(615) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00020408630371094
(616) DESCRIBE `ports` 0.00069880485534668
(617) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00018310546875
(618) DESCRIBE `ports` 0.00074100494384766
(619) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00044012069702148
(620) DESCRIBE `ports` 0.00089907646179199
(621) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00021600723266602
(622) DESCRIBE `ports` 0.00072908401489258
(623) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.00021219253540039
(624) DESCRIBE `ports` 0.00071382522583008
(625) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00019407272338867
(626) DESCRIBE `ports` 0.00073409080505371
(627) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 452))) 0.00024294853210449
(628) DESCRIBE `ports` 0.00069189071655273
(629) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '452') 0.00021886825561523
(630) DESCRIBE `ports` 0.00098013877868652
(631) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00027012825012207
(632) DESCRIBE `ports` 0.00098609924316406
(633) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00025200843811035
(634) DESCRIBE `cruises` 0.0019500255584717
(635) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 66478))) 0.00042009353637695
(636) DESCRIBE `avid_specials` 0.00081992149353027
(637) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1434186 and class = 'Special') OR (item_id = 66478 and class = 'Cruise') OR (item_id = 406 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 26 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
(638) DESCRIBE `cruiselines` 0.001039981842041
(639) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00025010108947754
(640) DESCRIBE `orchid_image` 0.0010101795196533
(641) DESCRIBE `cruiselines` 0.00097393989562988
(642) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00025701522827148
(643) DESCRIBE `specials` 0.003309965133667
(644) SELECT `specials`.* FROM `specials` WHERE (id = '1434199') AND (specials.orchid_available = 1) LIMIT 1 0.00066900253295898
(645) DESCRIBE `specials` 0.0021679401397705
(646) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1434199') 0.00025296211242676
(647) DESCRIBE `ships` 0.0014541149139404
(648) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 98))) 0.00030899047851562
(649) DESCRIBE `ships` 0.0014290809631348
(650) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '98') 0.00022196769714355
(651) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00019598007202148
(652) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018596649169922
(653) DESCRIBE `itineraries` 0.0007469654083252
(654) DESCRIBE `ports` 0.00075292587280273
(655) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00024890899658203
(656) DESCRIBE `ports` 0.00069618225097656
(657) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00020408630371094
(658) DESCRIBE `ports` 0.00086092948913574
(659) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.0001990795135498
(660) DESCRIBE `specialsailingdates` 0.00063180923461914
(661) DESCRIBE `sailingdates` 0.00082707405090332
(662) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 418257))) 0.00040102005004883
(663) DESCRIBE `ports` 0.00078082084655762
(664) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00022506713867188
(665) DESCRIBE `ports` 0.00082206726074219
(666) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.0002439022064209
(667) DESCRIBE `ports` 0.00069499015808105
(668) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.0002129077911377
(669) DESCRIBE `ports` 0.00068211555480957
(670) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00025796890258789
(671) DESCRIBE `ports` 0.00068497657775879
(672) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00020289421081543
(673) DESCRIBE `ports` 0.00073909759521484
(674) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00018405914306641
(675) DESCRIBE `ports` 0.00067591667175293
(676) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00020599365234375
(677) DESCRIBE `ports` 0.00070405006408691
(678) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00023484230041504
(679) DESCRIBE `ports` 0.0006859302520752
(680) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00020217895507812
(681) DESCRIBE `ports` 0.00075507164001465
(682) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00018501281738281
(683) DESCRIBE `ports` 0.00072216987609863
(684) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.0002751350402832
(685) DESCRIBE `ports` 0.0014331340789795
(686) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00034403800964355
(687) DESCRIBE `ports` 0.0012359619140625
(688) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.00035786628723145
(689) DESCRIBE `ports` 0.0011498928070068
(690) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.0002601146697998
(691) DESCRIBE `cruises` 0.0019831657409668
(692) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 66529))) 0.0005497932434082
(693) DESCRIBE `avid_specials` 0.0012719631195068
(694) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1434199 and class = 'Special') OR (item_id = 66529 and class = 'Cruise') OR (item_id = 98 AND class = 'Ship') OR (item_id = 23 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.0023930072784424
(695) DESCRIBE `cruiselines` 0.001978874206543
(696) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00027298927307129
(697) DESCRIBE `orchid_image` 0.00080585479736328
(698) DESCRIBE `cruiselines` 0.0017209053039551
(699) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00038504600524902
(700) DESCRIBE `cruiselines` 0.0015170574188232
(701) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('47', '33', '101', '19', '18', '8', '15', '218', '23', '151', '114', '20', '24', '120', '212', '30', '180', '262')) ORDER BY FIND_IN_SET(id, '47,33,101,19,18,8,15,218,23,151,114,20,24,120,212,30,180,262') 0.0008540153503418
(702) DESCRIBE `ships` 0.0016829967498779
(703) SELECT `ships`.* FROM `ships` WHERE (id IN ('517', '160', '1359', '1139', '888', '1266', '78', '1282', '683', '780', '1237', '406', '521', '616', '1029', '1303', '1672', '1676', '45', '258', '313', '404', '585', '669', '973', '1163', '5', '74', '98', '150', '163', '335', '349', '441', '580', '582', '652', '678', '722', '766', '769', '795', '968', '977', '1013', '1088', '1159', '1262', '1302', '1492', '1539', '1587', '1673', '1674')) ORDER BY FIND_IN_SET(id, '517,160,1359,1139,888,1266,78,1282,683,780,1237,406,521,616,1029,1303,1672,1676,45,258,313,404,585,669,973,1163,5,74,98,150,163,335,349,441,580,582,652,678,722,766,769,795,968,977,1013,1088,1159,1262,1302,1492,1539,1587,1673,1674') 0.0022439956665039
(704) DESCRIBE `cruisetypes` 0.0010480880737305
(705) DESCRIBE `destinations` 0.00096297264099121
(706) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '43', '50', '35', '54', '48', '11', '29', '12', '26', '28', '39', '49', '2', '21', '25', '37', '40', '8', '38', '53')) ORDER BY FIND_IN_SET(id, '22,43,50,35,54,48,11,29,12,26,28,39,49,2,21,25,37,40,8,38,53') 0.00089502334594727