or, enquire about your chosen options

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

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

Total elapsed time: 0.38130068778992

# Query Time
(1) connect 0.0005650520324707
(2) DESCRIBE `cruises` 0.0016670227050781
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66959, 11517, 69465, 45259, 67893, 66859, 66414, 63322, 43678, 67892)) ORDER BY FIND_IN_SET(id, '66959,11517,69465,45259,67893,66859,66414,63322,43678,67892') 0.00098085403442383
(4) DESCRIBE `specials` 0.0018830299377441
(5) DESCRIBE `specials` 0.0017340183258057
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1444901') 0.00025606155395508
(7) DESCRIBE `ships` 0.0012869834899902
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 335))) 0.00025391578674316
(9) DESCRIBE `ships` 0.0012359619140625
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '335') 0.00019288063049316
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017595291137695
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016307830810547
(13) DESCRIBE `itineraries` 0.00069189071655273
(14) DESCRIBE `ports` 0.00080490112304688
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00021505355834961
(16) DESCRIBE `ports` 0.00066089630126953
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.0001981258392334
(18) DESCRIBE `ports` 0.0006561279296875
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00019502639770508
(20) DESCRIBE `specialsailingdates` 0.00056314468383789
(21) DESCRIBE `sailingdates` 0.00059413909912109
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 420111))) 0.0002288818359375
(23) DESCRIBE `ports` 0.00068306922912598
(24) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00024795532226562
(25) DESCRIBE `ports` 0.00066304206848145
(26) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00018191337585449
(27) DESCRIBE `ports` 0.00065803527832031
(28) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 236))) 0.0001981258392334
(29) DESCRIBE `ports` 0.00067305564880371
(30) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '236') 0.00019001960754395
(31) DESCRIBE `ports` 0.0006568431854248
(32) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00019407272338867
(33) DESCRIBE `ports` 0.00065207481384277
(34) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00017189979553223
(35) DESCRIBE `ports` 0.00068092346191406
(36) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 233))) 0.00021600723266602
(37) DESCRIBE `ports` 0.00066304206848145
(38) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '233') 0.00017213821411133
(39) DESCRIBE `ports` 0.0006561279296875
(40) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 235))) 0.00020503997802734
(41) DESCRIBE `ports` 0.00069808959960938
(42) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '235') 0.00017285346984863
(43) DESCRIBE `ports` 0.00065493583679199
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 234))) 0.00020003318786621
(45) DESCRIBE `ports` 0.00064992904663086
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '234') 0.00017213821411133
(47) DESCRIBE `ports` 0.00069308280944824
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 561))) 0.00019288063049316
(49) DESCRIBE `ports` 0.00065398216247559
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '561') 0.00017189979553223
(51) DESCRIBE `ports` 0.00064992904663086
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2403))) 0.00019407272338867
(53) DESCRIBE `ports` 0.00065016746520996
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2403') 0.00016903877258301
(55) DESCRIBE `ports` 0.0006558895111084
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00019717216491699
(57) DESCRIBE `ports` 0.00070691108703613
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00018000602722168
(59) DESCRIBE `cruises` 0.001262903213501
(60) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 66959))) 0.00032281875610352
(61) DESCRIBE `avid_specials` 0.00078392028808594
(62) 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.0010249614715576
(63) DESCRIBE `cruiselines` 0.00095891952514648
(64) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00022506713867188
(65) DESCRIBE `orchid_image` 0.00075411796569824
(66) DESCRIBE `cruiselines` 0.00090503692626953
(67) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00019598007202148
(68) DESCRIBE `specials` 0.0017940998077393
(69) DESCRIBE `specials` 0.0016889572143555
(70) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1444940') 0.00022101402282715
(71) DESCRIBE `ships` 0.001366138458252
(72) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 521))) 0.00027990341186523
(73) DESCRIBE `ships` 0.0012459754943848
(74) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '521') 0.00017404556274414
(75) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019311904907227
(76) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016307830810547
(77) DESCRIBE `itineraries` 0.00065183639526367
(78) DESCRIBE `ports` 0.00068402290344238
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00023889541625977
(80) DESCRIBE `ports` 0.00066113471984863
(81) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00019311904907227
(82) DESCRIBE `ports` 0.00065803527832031
(83) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00017809867858887
(84) DESCRIBE `specialsailingdates` 0.00056195259094238
(85) DESCRIBE `sailingdates` 0.00058698654174805
(86) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423023))) 0.00020503997802734
(87) DESCRIBE `sailingdates` 0.0006258487701416
(88) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423024))) 0.00018310546875
(89) DESCRIBE `sailingdates` 0.0005791187286377
(90) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 423026))) 0.00019192695617676
(91) DESCRIBE `ports` 0.00065994262695312
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2778))) 0.00020313262939453
(93) DESCRIBE `ports` 0.00065398216247559
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2778') 0.00023198127746582
(95) DESCRIBE `ports` 0.00081515312194824
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3490))) 0.00021815299987793
(97) DESCRIBE `ports` 0.00075101852416992
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3490') 0.0001978874206543
(99) DESCRIBE `ports` 0.00075793266296387
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5160))) 0.00021004676818848
(101) DESCRIBE `ports` 0.0006868839263916
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5160') 0.00023603439331055
(103) DESCRIBE `ports` 0.00088095664978027
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00034308433532715
(105) DESCRIBE `ports` 0.00081205368041992
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00018692016601562
(107) DESCRIBE `ports` 0.00066804885864258
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00020003318786621
(109) DESCRIBE `ports` 0.00069093704223633
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00018501281738281
(111) DESCRIBE `ports` 0.00068402290344238
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00021600723266602
(113) DESCRIBE `ports` 0.00066900253295898
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00017499923706055
(115) DESCRIBE `ports` 0.00068998336791992
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00018692016601562
(117) DESCRIBE `ports` 0.00081801414489746
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00018000602722168
(119) DESCRIBE `ports` 0.00065708160400391
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00019598007202148
(121) DESCRIBE `ports` 0.00066113471984863
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00017905235290527
(123) DESCRIBE `ports` 0.00065493583679199
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00018906593322754
(125) DESCRIBE `ports` 0.00065803527832031
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00020003318786621
(127) DESCRIBE `ports` 0.00066304206848145
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00019598007202148
(129) DESCRIBE `ports` 0.00065398216247559
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00016903877258301
(131) DESCRIBE `cruises` 0.0013260841369629
(132) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 11517))) 0.00029897689819336
(133) DESCRIBE `avid_specials` 0.00060796737670898
(134) 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.00095701217651367
(135) DESCRIBE `cruiselines` 0.00093603134155273
(136) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 120))) 0.00022315979003906
(137) DESCRIBE `orchid_image` 0.00074100494384766
(138) DESCRIBE `cruiselines` 0.00094914436340332
(139) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '120') 0.00018191337585449
(140) DESCRIBE `specials` 0.0018010139465332
(141) DESCRIBE `specials` 0.0017340183258057
(142) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1431904') 0.00022697448730469
(143) DESCRIBE `ships` 0.0012991428375244
(144) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1282))) 0.00028896331787109
(145) DESCRIBE `ships` 0.0015239715576172
(146) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1282') 0.00019693374633789
(147) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00017309188842773
(148) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00016188621520996
(149) DESCRIBE `itineraries` 0.00082206726074219
(150) DESCRIBE `ports` 0.00069999694824219
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00023794174194336
(152) DESCRIBE `ports` 0.00069904327392578
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00019598007202148
(154) DESCRIBE `ports` 0.00068998336791992
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00019288063049316
(156) DESCRIBE `specialsailingdates` 0.00056600570678711
(157) DESCRIBE `sailingdates` 0.00065112113952637
(158) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 436294))) 0.00022101402282715
(159) DESCRIBE `ports` 0.00066614151000977
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 238))) 0.00020503997802734
(161) DESCRIBE `ports` 0.00095391273498535
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '238') 0.00018692016601562
(163) DESCRIBE `ports` 0.00093603134155273
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00022292137145996
(165) DESCRIBE `ports` 0.00070500373840332
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00019502639770508
(167) DESCRIBE `ports` 0.00071001052856445
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 220))) 0.00021696090698242
(169) DESCRIBE `ports` 0.00066900253295898
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '220') 0.00017595291137695
(171) DESCRIBE `ports` 0.0006558895111084
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 228))) 0.00020790100097656
(173) DESCRIBE `ports` 0.00069189071655273
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '228') 0.00018882751464844
(175) DESCRIBE `ports` 0.00086092948913574
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 521))) 0.00025200843811035
(177) DESCRIBE `ports` 0.00066804885864258
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '521') 0.00024294853210449
(179) DESCRIBE `ports` 0.00096011161804199
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 754))) 0.00020694732666016
(181) DESCRIBE `ports` 0.00096487998962402
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '754') 0.0001828670501709
(183) DESCRIBE `ports` 0.00071597099304199
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1659))) 0.00025606155395508
(185) DESCRIBE `ports` 0.00074481964111328
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1659') 0.00018811225891113
(187) DESCRIBE `ports` 0.00079512596130371
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 783))) 0.00023388862609863
(189) DESCRIBE `ports` 0.00069308280944824
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '783') 0.00023198127746582
(191) DESCRIBE `ports` 0.00085687637329102
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 571))) 0.00020909309387207
(193) DESCRIBE `ports` 0.00067996978759766
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '571') 0.0002288818359375
(195) DESCRIBE `ports` 0.00094008445739746
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 778))) 0.0001981258392334
(197) DESCRIBE `ports` 0.00071501731872559
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '778') 0.00017690658569336
(199) DESCRIBE `ports` 0.00071310997009277
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 778))) 0.00019192695617676
(201) DESCRIBE `ports` 0.00069618225097656
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '778') 0.00020003318786621
(203) DESCRIBE `cruises` 0.0015678405761719
(204) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 69465))) 0.00029587745666504
(205) DESCRIBE `avid_specials` 0.00062704086303711
(206) 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.00097298622131348
(207) DESCRIBE `cruiselines` 0.00096893310546875
(208) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00021696090698242
(209) DESCRIBE `orchid_image` 0.0007779598236084
(210) DESCRIBE `cruiselines` 0.00090503692626953
(211) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00019502639770508
(212) DESCRIBE `specials` 0.0018179416656494
(213) DESCRIBE `specials` 0.0017030239105225
(214) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1435809') 0.00022792816162109
(215) DESCRIBE `ships` 0.001262903213501
(216) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00023698806762695
(217) DESCRIBE `ships` 0.0012350082397461
(218) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00021004676818848
(219) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018000602722168
(220) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00016617774963379
(221) DESCRIBE `itineraries` 0.0006568431854248
(222) DESCRIBE `ports` 0.00067806243896484
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00020289421081543
(224) DESCRIBE `ports` 0.0006568431854248
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00019288063049316
(226) DESCRIBE `ports` 0.00070714950561523
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00017905235290527
(228) DESCRIBE `specialsailingdates` 0.00056910514831543
(229) DESCRIBE `sailingdates` 0.00063395500183105
(230) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465300))) 0.00021719932556152
(231) DESCRIBE `sailingdates` 0.0005950927734375
(232) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465301))) 0.00018310546875
(233) DESCRIBE `sailingdates` 0.00058197975158691
(234) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465302))) 0.00017905235290527
(235) DESCRIBE `sailingdates` 0.00060200691223145
(236) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465303))) 0.00017786026000977
(237) DESCRIBE `sailingdates` 0.00058603286743164
(238) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465304))) 0.00018906593322754
(239) DESCRIBE `sailingdates` 0.00058293342590332
(240) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465305))) 0.00017809867858887
(241) DESCRIBE `sailingdates` 0.0005800724029541
(242) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465306))) 0.00017905235290527
(243) DESCRIBE `sailingdates` 0.00058484077453613
(244) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465307))) 0.00017905235290527
(245) DESCRIBE `sailingdates` 0.00057816505432129
(246) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465308))) 0.00017714500427246
(247) DESCRIBE `sailingdates` 0.0005791187286377
(248) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465309))) 0.00018405914306641
(249) DESCRIBE `sailingdates` 0.00057888031005859
(250) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465310))) 0.00017809867858887
(251) DESCRIBE `sailingdates` 0.000579833984375
(252) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465311))) 0.00020694732666016
(253) DESCRIBE `sailingdates` 0.00058102607727051
(254) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465312))) 0.00018906593322754
(255) DESCRIBE `sailingdates` 0.00058293342590332
(256) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465313))) 0.00017786026000977
(257) DESCRIBE `sailingdates` 0.00059294700622559
(258) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465314))) 0.00017905235290527
(259) DESCRIBE `sailingdates` 0.00058579444885254
(260) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465315))) 0.00018787384033203
(261) DESCRIBE `sailingdates` 0.00059795379638672
(262) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465316))) 0.00017690658569336
(263) DESCRIBE `sailingdates` 0.00063705444335938
(264) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465317))) 0.00018787384033203
(265) DESCRIBE `sailingdates` 0.00058388710021973
(266) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465318))) 0.00017690658569336
(267) DESCRIBE `sailingdates` 0.0005791187286377
(268) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465319))) 0.00018787384033203
(269) DESCRIBE `sailingdates` 0.00059890747070312
(270) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465320))) 0.00017595291137695
(271) DESCRIBE `sailingdates` 0.00058197975158691
(272) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465321))) 0.00019097328186035
(273) DESCRIBE `sailingdates` 0.00058293342590332
(274) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465322))) 0.00017714500427246
(275) DESCRIBE `sailingdates` 0.00060606002807617
(276) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465323))) 0.00018811225891113
(277) DESCRIBE `sailingdates` 0.000579833984375
(278) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465324))) 0.00017690658569336
(279) DESCRIBE `sailingdates` 0.00066399574279785
(280) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465325))) 0.00022602081298828
(281) DESCRIBE `sailingdates` 0.00060296058654785
(282) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465326))) 0.00019001960754395
(283) DESCRIBE `sailingdates` 0.00058913230895996
(284) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465327))) 0.00018620491027832
(285) DESCRIBE `sailingdates` 0.00058102607727051
(286) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465328))) 0.00019001960754395
(287) DESCRIBE `sailingdates` 0.00058484077453613
(288) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465329))) 0.00019097328186035
(289) DESCRIBE `sailingdates` 0.00057792663574219
(290) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465330))) 0.00018906593322754
(291) DESCRIBE `sailingdates` 0.00057697296142578
(292) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465331))) 0.00018787384033203
(293) DESCRIBE `sailingdates` 0.00059700012207031
(294) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465332))) 0.00018501281738281
(295) DESCRIBE `sailingdates` 0.00060391426086426
(296) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465333))) 0.00018501281738281
(297) DESCRIBE `ports` 0.00072193145751953
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0002138614654541
(299) DESCRIBE `ports` 0.00065779685974121
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00019407272338867
(301) DESCRIBE `ports` 0.00066900253295898
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00020408630371094
(303) DESCRIBE `ports` 0.00066304206848145
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00018095970153809
(305) DESCRIBE `ports` 0.00064897537231445
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00022006034851074
(307) DESCRIBE `ports` 0.00064992904663086
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00020885467529297
(309) DESCRIBE `ports` 0.00069093704223633
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00021100044250488
(311) DESCRIBE `ports` 0.00065708160400391
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00018501281738281
(313) DESCRIBE `ports` 0.00064992904663086
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00020289421081543
(315) DESCRIBE `ports` 0.0006558895111084
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00017404556274414
(317) DESCRIBE `cruises` 0.0012938976287842
(318) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 45259))) 0.00033402442932129
(319) DESCRIBE `avid_specials` 0.00061297416687012
(320) 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.0010449886322021
(321) DESCRIBE `cruiselines` 0.0010049343109131
(322) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.0002291202545166
(323) DESCRIBE `orchid_image` 0.00091695785522461
(324) DESCRIBE `cruiselines` 0.00097084045410156
(325) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00020694732666016
(326) DESCRIBE `specials` 0.0020370483398438
(327) DESCRIBE `specials` 0.0018289089202881
(328) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1447538') 0.00026202201843262
(329) DESCRIBE `ships` 0.0014660358428955
(330) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 163))) 0.00028395652770996
(331) DESCRIBE `ships` 0.0014200210571289
(332) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '163') 0.00019407272338867
(333) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018405914306641
(334) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018310546875
(335) DESCRIBE `itineraries` 0.0006558895111084
(336) DESCRIBE `ports` 0.00067901611328125
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00022792816162109
(338) DESCRIBE `ports` 0.00072002410888672
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00019097328186035
(340) DESCRIBE `ports` 0.00065302848815918
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00018501281738281
(342) DESCRIBE `specialsailingdates` 0.00055813789367676
(343) DESCRIBE `sailingdates` 0.00058293342590332
(344) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 428425))) 0.00021100044250488
(345) DESCRIBE `ports` 0.00066113471984863
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00019288063049316
(347) DESCRIBE `ports` 0.00065207481384277
(348) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00017499923706055
(349) DESCRIBE `ports` 0.00064992904663086
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1778))) 0.00022292137145996
(351) DESCRIBE `ports` 0.00075602531433105
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1778') 0.00017380714416504
(353) DESCRIBE `ports` 0.00066900253295898
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1789))) 0.00019192695617676
(355) DESCRIBE `ports` 0.00066518783569336
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1789') 0.00018620491027832
(357) DESCRIBE `ports` 0.00065302848815918
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 585))) 0.00019288063049316
(359) DESCRIBE `ports` 0.00068497657775879
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '585') 0.00017404556274414
(361) DESCRIBE `ports` 0.0006871223449707
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 514))) 0.00022602081298828
(363) DESCRIBE `ports` 0.0006568431854248
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '514') 0.00017809867858887
(365) DESCRIBE `ports` 0.00066399574279785
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00019311904907227
(367) DESCRIBE `ports` 0.00068402290344238
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00017404556274414
(369) DESCRIBE `ports` 0.001086950302124
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00024914741516113
(371) DESCRIBE `ports` 0.00071191787719727
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00020217895507812
(373) DESCRIBE `ports` 0.00069904327392578
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00020313262939453
(375) DESCRIBE `ports` 0.00068020820617676
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00017499923706055
(377) DESCRIBE `ports` 0.00070810317993164
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00020790100097656
(379) DESCRIBE `ports` 0.00065207481384277
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00017905235290527
(381) DESCRIBE `cruises` 0.0013430118560791
(382) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 67893))) 0.00028109550476074
(383) DESCRIBE `avid_specials` 0.00062203407287598
(384) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1447538 and class = 'Special') OR (item_id = 67893 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.0011229515075684
(385) DESCRIBE `cruiselines` 0.0009920597076416
(386) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00023007392883301
(387) DESCRIBE `orchid_image` 0.00075697898864746
(388) DESCRIBE `cruiselines` 0.00094199180603027
(389) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00018095970153809
(390) DESCRIBE `specials` 0.0018351078033447
(391) DESCRIBE `specials` 0.0018219947814941
(392) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1427648') 0.00023889541625977
(393) DESCRIBE `ships` 0.0013771057128906
(394) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 722))) 0.00025391578674316
(395) DESCRIBE `ships` 0.0012531280517578
(396) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '722') 0.00018596649169922
(397) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017404556274414
(398) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016307830810547
(399) DESCRIBE `itineraries` 0.00065302848815918
(400) DESCRIBE `ports` 0.00068807601928711
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00021910667419434
(402) DESCRIBE `ports` 0.00065517425537109
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020003318786621
(404) DESCRIBE `ports` 0.00066518783569336
(405) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00017809867858887
(406) DESCRIBE `specialsailingdates` 0.00055384635925293
(407) DESCRIBE `sailingdates` 0.00061893463134766
(408) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419625))) 0.00021195411682129
(409) DESCRIBE `ports` 0.00066590309143066
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020217895507812
(411) DESCRIBE `ports` 0.00066709518432617
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00017905235290527
(413) DESCRIBE `ports` 0.00066399574279785
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00021100044250488
(415) DESCRIBE `ports` 0.00067305564880371
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00019097328186035
(417) DESCRIBE `ports` 0.00068020820617676
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.0001990795135498
(419) DESCRIBE `ports` 0.00066614151000977
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00017499923706055
(421) DESCRIBE `ports` 0.0006859302520752
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00020694732666016
(423) DESCRIBE `ports` 0.0006868839263916
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00017809867858887
(425) DESCRIBE `ports` 0.00067710876464844
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00019311904907227
(427) DESCRIBE `ports` 0.00071287155151367
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00017714500427246
(429) DESCRIBE `ports` 0.00066709518432617
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00021719932556152
(431) DESCRIBE `ports` 0.00066614151000977
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00017905235290527
(433) DESCRIBE `cruises` 0.001276969909668
(434) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 66859))) 0.00027012825012207
(435) DESCRIBE `avid_specials` 0.00059700012207031
(436) 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.00098013877868652
(437) DESCRIBE `cruiselines` 0.00092720985412598
(438) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00021815299987793
(439) DESCRIBE `orchid_image` 0.00073790550231934
(440) DESCRIBE `cruiselines` 0.00093793869018555
(441) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00017714500427246
(442) DESCRIBE `specials` 0.0018351078033447
(443) DESCRIBE `specials` 0.0017261505126953
(444) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1427634') 0.00022697448730469
(445) DESCRIBE `ships` 0.0013241767883301
(446) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 45))) 0.00040388107299805
(447) DESCRIBE `ships` 0.0014979839324951
(448) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '45') 0.00018405914306641
(449) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017285346984863
(450) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016188621520996
(451) DESCRIBE `itineraries` 0.00066494941711426
(452) DESCRIBE `ports` 0.00068902969360352
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.0002138614654541
(454) DESCRIBE `ports` 0.00075387954711914
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00020098686218262
(456) DESCRIBE `ports` 0.00066208839416504
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00018596649169922
(458) DESCRIBE `specialsailingdates` 0.00059700012207031
(459) DESCRIBE `sailingdates` 0.0005950927734375
(460) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 417534))) 0.00024318695068359
(461) DESCRIBE `ports` 0.00070405006408691
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00022196769714355
(463) DESCRIBE `ports` 0.00068092346191406
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00021791458129883
(465) DESCRIBE `ports` 0.00080609321594238
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 40))) 0.00021004676818848
(467) DESCRIBE `ports` 0.00070714950561523
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '40') 0.00018000602722168
(469) DESCRIBE `ports` 0.00067782402038574
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00020694732666016
(471) DESCRIBE `ports` 0.00066304206848145
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00019097328186035
(473) DESCRIBE `ports` 0.0007481575012207
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 553))) 0.00020098686218262
(475) DESCRIBE `ports` 0.00069785118103027
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '553') 0.00018405914306641
(477) DESCRIBE `ports` 0.0007469654083252
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.0002291202545166
(479) DESCRIBE `ports` 0.00079202651977539
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00017595291137695
(481) DESCRIBE `ports` 0.0006868839263916
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00024795532226562
(483) DESCRIBE `ports` 0.00091314315795898
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00018095970153809
(485) DESCRIBE `ports` 0.00067496299743652
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00021195411682129
(487) DESCRIBE `ports` 0.00067496299743652
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00017499923706055
(489) DESCRIBE `ports` 0.00066590309143066
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 293))) 0.00021100044250488
(491) DESCRIBE `ports` 0.00068187713623047
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '293') 0.00018000602722168
(493) DESCRIBE `cruises` 0.0013480186462402
(494) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 66414))) 0.00031805038452148
(495) DESCRIBE `avid_specials` 0.00064492225646973
(496) 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.0010299682617188
(497) DESCRIBE `cruiselines` 0.00093221664428711
(498) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.0002291202545166
(499) DESCRIBE `orchid_image` 0.00074505805969238
(500) DESCRIBE `cruiselines` 0.0010008811950684
(501) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00017499923706055
(502) DESCRIBE `specials` 0.0024611949920654
(503) DESCRIBE `specials` 0.0017960071563721
(504) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1447558') 0.00023508071899414
(505) DESCRIBE `ships` 0.0012800693511963
(506) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 163))) 0.00027084350585938
(507) DESCRIBE `ships` 0.0012600421905518
(508) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '163') 0.00018310546875
(509) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00018310546875
(510) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00021195411682129
(511) DESCRIBE `itineraries` 0.0010671615600586
(512) DESCRIBE `ports` 0.00081300735473633
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00023603439331055
(514) DESCRIBE `ports` 0.00068378448486328
(515) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00020885467529297
(516) DESCRIBE `ports` 0.0006859302520752
(517) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00019502639770508
(518) DESCRIBE `specialsailingdates` 0.00057411193847656
(519) DESCRIBE `sailingdates` 0.0006859302520752
(520) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 428433))) 0.00023293495178223
(521) DESCRIBE `ports` 0.00067520141601562
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00020718574523926
(523) DESCRIBE `ports` 0.00067591667175293
(524) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00018310546875
(525) DESCRIBE `ports` 0.00068187713623047
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1778))) 0.0002138614654541
(527) DESCRIBE `ports` 0.00067400932312012
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1778') 0.00018215179443359
(529) DESCRIBE `ports` 0.00070381164550781
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1789))) 0.00020599365234375
(531) DESCRIBE `ports` 0.00070381164550781
(532) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1789') 0.00018095970153809
(533) DESCRIBE `ports` 0.00067710876464844
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 585))) 0.00020790100097656
(535) DESCRIBE `ports` 0.0006721019744873
(536) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '585') 0.00018119812011719
(537) DESCRIBE `ports` 0.00078606605529785
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 514))) 0.00021791458129883
(539) DESCRIBE `ports` 0.00068807601928711
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '514') 0.00019097328186035
(541) DESCRIBE `ports` 0.00067591667175293
(542) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00024604797363281
(543) DESCRIBE `ports` 0.0007021427154541
(544) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.0001828670501709
(545) DESCRIBE `ports` 0.00065994262695312
(546) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00020408630371094
(547) DESCRIBE `ports` 0.00066781044006348
(548) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00018215179443359
(549) DESCRIBE `ports` 0.00066590309143066
(550) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00021100044250488
(551) DESCRIBE `ports` 0.0006711483001709
(552) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00018191337585449
(553) DESCRIBE `ports` 0.0006859302520752
(554) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00020694732666016
(555) DESCRIBE `ports` 0.00066184997558594
(556) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00019598007202148
(557) DESCRIBE `ports` 0.00064921379089355
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00021600723266602
(559) DESCRIBE `ports` 0.00069308280944824
(560) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00018405914306641
(561) DESCRIBE `ports` 0.00066399574279785
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00020599365234375
(563) DESCRIBE `ports` 0.00064897537231445
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00019001960754395
(565) DESCRIBE `ports` 0.00066184997558594
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00020694732666016
(567) DESCRIBE `ports` 0.00064778327941895
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00018405914306641
(569) DESCRIBE `cruises` 0.0012550354003906
(570) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 63322))) 0.00027894973754883
(571) DESCRIBE `avid_specials` 0.00060105323791504
(572) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1447558 and class = 'Special') OR (item_id = 63322 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.0009620189666748
(573) DESCRIBE `cruiselines` 0.00093507766723633
(574) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.0002140998840332
(575) DESCRIBE `orchid_image` 0.00074410438537598
(576) DESCRIBE `cruiselines` 0.00095391273498535
(577) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.0001978874206543
(578) DESCRIBE `specials` 0.0018329620361328
(579) DESCRIBE `specials` 0.0016820430755615
(580) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1447131') 0.00022196769714355
(581) DESCRIBE `ships` 0.0012528896331787
(582) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 404))) 0.00027894973754883
(583) DESCRIBE `ships` 0.0012648105621338
(584) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '404') 0.00019097328186035
(585) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017309188842773
(586) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017309188842773
(587) DESCRIBE `itineraries` 0.00065207481384277
(588) DESCRIBE `ports` 0.0006711483001709
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00020599365234375
(590) DESCRIBE `ports` 0.00066018104553223
(591) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00019502639770508
(592) DESCRIBE `ports` 0.00068402290344238
(593) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00017499923706055
(594) DESCRIBE `specialsailingdates` 0.00055789947509766
(595) DESCRIBE `sailingdates` 0.00060582160949707
(596) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 386422))) 0.00020885467529297
(597) DESCRIBE `ports` 0.00080108642578125
(598) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00027990341186523
(599) DESCRIBE `ports` 0.00067400932312012
(600) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00017809867858887
(601) DESCRIBE `ports` 0.00067806243896484
(602) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 353))) 0.00020503997802734
(603) DESCRIBE `ports` 0.00067877769470215
(604) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '353') 0.00018095970153809
(605) DESCRIBE `ports` 0.00067591667175293
(606) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 353))) 0.00019717216491699
(607) DESCRIBE `ports` 0.00067996978759766
(608) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '353') 0.00018501281738281
(609) DESCRIBE `ports` 0.00066494941711426
(610) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 17))) 0.00019598007202148
(611) DESCRIBE `ports` 0.00073409080505371
(612) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '17') 0.00019288063049316
(613) DESCRIBE `ports` 0.0007021427154541
(614) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 856))) 0.00021004676818848
(615) DESCRIBE `ports` 0.00066018104553223
(616) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '856') 0.00018501281738281
(617) DESCRIBE `ports` 0.00065803527832031
(618) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00019288063049316
(619) DESCRIBE `ports` 0.00070285797119141
(620) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00017094612121582
(621) DESCRIBE `ports` 0.00068187713623047
(622) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 383))) 0.00018906593322754
(623) DESCRIBE `ports` 0.00066494941711426
(624) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '383') 0.00020885467529297
(625) DESCRIBE `ports` 0.00066590309143066
(626) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 10))) 0.00023889541625977
(627) DESCRIBE `ports` 0.00066804885864258
(628) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '10') 0.00017213821411133
(629) DESCRIBE `cruises` 0.0015029907226562
(630) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 43678))) 0.00029587745666504
(631) DESCRIBE `avid_specials` 0.00063395500183105
(632) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1447131 and class = 'Special') OR (item_id = 43678 and class = 'Cruise') OR (item_id = 404 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 29 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.001007080078125
(633) DESCRIBE `cruiselines` 0.0009310245513916
(634) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00022506713867188
(635) DESCRIBE `orchid_image` 0.00075316429138184
(636) DESCRIBE `cruiselines` 0.00093293190002441
(637) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00019097328186035
(638) DESCRIBE `specials` 0.0018751621246338
(639) DESCRIBE `specials` 0.0018210411071777
(640) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1433404') 0.00028204917907715
(641) DESCRIBE `ships` 0.0012900829315186
(642) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 163))) 0.00031685829162598
(643) DESCRIBE `ships` 0.0012640953063965
(644) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '163') 0.00019407272338867
(645) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017380714416504
(646) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016188621520996
(647) DESCRIBE `itineraries` 0.00069093704223633
(648) DESCRIBE `ports` 0.00068998336791992
(649) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00021195411682129
(650) DESCRIBE `ports` 0.00069808959960938
(651) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00019598007202148
(652) DESCRIBE `ports` 0.00068092346191406
(653) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00018310546875
(654) DESCRIBE `specialsailingdates` 0.00064301490783691
(655) DESCRIBE `sailingdates` 0.00061988830566406
(656) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 428412))) 0.0002281665802002
(657) DESCRIBE `ports` 0.00066494941711426
(658) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00021100044250488
(659) DESCRIBE `ports` 0.0009160041809082
(660) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00018596649169922
(661) DESCRIBE `ports` 0.00066804885864258
(662) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.0002140998840332
(663) DESCRIBE `ports` 0.00068402290344238
(664) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00018191337585449
(665) DESCRIBE `ports` 0.0006868839263916
(666) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00020909309387207
(667) DESCRIBE `ports` 0.00066590309143066
(668) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00017809867858887
(669) DESCRIBE `ports` 0.00067782402038574
(670) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00020599365234375
(671) DESCRIBE `ports` 0.00069785118103027
(672) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00017404556274414
(673) DESCRIBE `ports` 0.00065994262695312
(674) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 585))) 0.00020289421081543
(675) DESCRIBE `ports` 0.00067687034606934
(676) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '585') 0.00020194053649902
(677) DESCRIBE `ports` 0.00071597099304199
(678) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00020003318786621
(679) DESCRIBE `ports` 0.00072002410888672
(680) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.0001828670501709
(681) DESCRIBE `ports` 0.00065493583679199
(682) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00020694732666016
(683) DESCRIBE `ports` 0.00070595741271973
(684) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00017380714416504
(685) DESCRIBE `ports` 0.00065302848815918
(686) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 514))) 0.00019717216491699
(687) DESCRIBE `ports` 0.00070405006408691
(688) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '514') 0.00018095970153809
(689) DESCRIBE `ports` 0.00066804885864258
(690) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00019598007202148
(691) DESCRIBE `ports` 0.00066184997558594
(692) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00018310546875
(693) DESCRIBE `cruises` 0.0013720989227295
(694) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 67892))) 0.00029492378234863
(695) DESCRIBE `avid_specials` 0.00072097778320312
(696) 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.00099682807922363
(697) DESCRIBE `cruiselines` 0.00094294548034668
(698) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00024700164794922
(699) DESCRIBE `orchid_image` 0.00078201293945312
(700) DESCRIBE `cruiselines` 0.00097107887268066
(701) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00019192695617676
(702) DESCRIBE `cruiselines` 0.0010800361633301
(703) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('33', '47', '101', '19', '18', '8', '23', '15', '218', '151', '114', '20', '24', '120', '212', '4', '30', '180', '262')) ORDER BY FIND_IN_SET(id, '33,47,101,19,18,8,23,15,218,151,114,20,24,120,212,4,30,180,262') 0.00084996223449707
(704) DESCRIBE `ships` 0.0015549659729004
(705) SELECT `ships`.* FROM `ships` WHERE (id IN ('517', '160', '1359', '888', '1266', '78', '163', '1139', '1282', '683', '780', '1237', '406', '521', '616', '1029', '1303', '1672', '1676', '45', '258', '313', '404', '585', '669', '973', '1159', '1163', '1409', '5', '74', '98', '150', '335', '349', '441', '580', '582', '652', '678', '722', '766', '769', '795', '968', '977', '1013', '1088', '1262', '1302', '1492', '1539', '1587', '1673', '1674', '1722')) ORDER BY FIND_IN_SET(id, '517,160,1359,888,1266,78,163,1139,1282,683,780,1237,406,521,616,1029,1303,1672,1676,45,258,313,404,585,669,973,1159,1163,1409,5,74,98,150,335,349,441,580,582,652,678,722,766,769,795,968,977,1013,1088,1262,1302,1492,1539,1587,1673,1674,1722') 0.0024690628051758
(706) DESCRIBE `cruisetypes` 0.00094509124755859
(707) DESCRIBE `destinations` 0.00089287757873535
(708) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '22', '35', '50', '54', '48', '11', '29', '12', '26', '28', '39', '49', '2', '8', '21', '25', '37', '40', '38', '53')) ORDER BY FIND_IN_SET(id, '43,22,35,50,54,48,11,29,12,26,28,39,49,2,8,21,25,37,40,38,53') 0.00086808204650879