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

Total elapsed time: 0.4059956073761

# Query Time
(1) connect 0.00053691864013672
(2) DESCRIBE `cruises` 0.0019969940185547
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (65434, 58395, 58161, 71110, 65442, 58377, 71121)) ORDER BY FIND_IN_SET(id, '65434,58395,58161,71110,65442,58377,71121') 0.00099301338195801
(4) DESCRIBE `specials` 0.0023610591888428
(5) SELECT `specials`.* FROM `specials` WHERE (id = '1422569') AND (specials.orchid_available = 1) LIMIT 1 0.00049710273742676
(6) DESCRIBE `specials` 0.0030181407928467
(7) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1422569') 0.00036501884460449
(8) DESCRIBE `ships` 0.0020439624786377
(9) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 147))) 0.00036311149597168
(10) DESCRIBE `ships` 0.0015139579772949
(11) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '147') 0.00026297569274902
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00022196769714355
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00016999244689941
(14) DESCRIBE `itineraries` 0.00088882446289062
(15) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65434') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0013668537139893
(16) DESCRIBE `ports` 0.0014169216156006
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00037908554077148
(18) DESCRIBE `ports` 0.0012021064758301
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00028204917907715
(20) DESCRIBE `ports` 0.001223087310791
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00034379959106445
(22) DESCRIBE `specialsailingdates` 0.00099706649780273
(23) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1422569') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00089597702026367
(24) DESCRIBE `sailingdates` 0.001154899597168
(25) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 411788))) 0.00036096572875977
(26) DESCRIBE `ports` 0.0012571811676025
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00034594535827637
(28) DESCRIBE `ports` 0.00082111358642578
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00026607513427734
(30) DESCRIBE `ports` 0.00084304809570312
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1026))) 0.00022697448730469
(32) DESCRIBE `ports` 0.00071907043457031
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1026') 0.00025701522827148
(34) DESCRIBE `ports` 0.0010550022125244
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 316))) 0.00032806396484375
(36) DESCRIBE `ports` 0.0011608600616455
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '316') 0.00031399726867676
(38) DESCRIBE `ports` 0.0011279582977295
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.00033187866210938
(40) DESCRIBE `ports` 0.0011711120605469
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.00023603439331055
(42) DESCRIBE `ports` 0.00078105926513672
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0002288818359375
(44) DESCRIBE `ports` 0.00075984001159668
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00021004676818848
(46) DESCRIBE `ports` 0.00075006484985352
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1029))) 0.00029897689819336
(48) DESCRIBE `ports` 0.0010910034179688
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1029') 0.00028610229492188
(50) DESCRIBE `ports` 0.0010778903961182
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00037312507629395
(52) DESCRIBE `ports` 0.0010759830474854
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00029706954956055
(54) DESCRIBE `ports` 0.0011358261108398
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.0003049373626709
(56) DESCRIBE `ports` 0.00077700614929199
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00021100044250488
(58) DESCRIBE `ports` 0.00069212913513184
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2804))) 0.0002129077911377
(60) DESCRIBE `ports` 0.00073695182800293
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2804') 0.00026798248291016
(62) DESCRIBE `ports` 0.001086950302124
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0003211498260498
(64) DESCRIBE `ports` 0.0011169910430908
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00030899047851562
(66) DESCRIBE `ports` 0.0011000633239746
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00033187866210938
(68) DESCRIBE `ports` 0.0011839866638184
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00022602081298828
(70) DESCRIBE `ports` 0.00087189674377441
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00026392936706543
(72) DESCRIBE `ports` 0.00075101852416992
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00019407272338867
(74) DESCRIBE `cruises` 0.0019850730895996
(75) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 65434))) 0.00049686431884766
(76) DESCRIBE `avid_specials` 0.001133918762207
(77) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1422569 and class = 'Special') OR (item_id = 65434 and class = 'Cruise') OR (item_id = 147 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 7 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.0016191005706787
(78) DESCRIBE `cruiselines` 0.0012369155883789
(79) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00030803680419922
(80) DESCRIBE `orchid_image` 0.00090503692626953
(81) DESCRIBE `specials` 0.0022139549255371
(82) SELECT `specials`.* FROM `specials` WHERE (id = '1422621') AND (specials.orchid_available = 1) LIMIT 1 0.00052618980407715
(83) DESCRIBE `specials` 0.0021669864654541
(84) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1422621') 0.00033211708068848
(85) DESCRIBE `ships` 0.0015699863433838
(86) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 717))) 0.00030994415283203
(87) DESCRIBE `ships` 0.0017950534820557
(88) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '717') 0.00035190582275391
(89) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00024294853210449
(90) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0002291202545166
(91) DESCRIBE `itineraries` 0.0012149810791016
(92) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '58395') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00057792663574219
(93) DESCRIBE `ports` 0.00097894668579102
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00026488304138184
(95) DESCRIBE `ports` 0.0007479190826416
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.0002129077911377
(97) DESCRIBE `ports` 0.00070786476135254
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00019407272338867
(99) DESCRIBE `specialsailingdates` 0.00059413909912109
(100) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1422621') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00062894821166992
(101) DESCRIBE `sailingdates` 0.00072503089904785
(102) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 446653))) 0.00022411346435547
(103) DESCRIBE `ports` 0.00074315071105957
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00022697448730469
(105) DESCRIBE `ports` 0.00072717666625977
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00020599365234375
(107) DESCRIBE `ports` 0.00070595741271973
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 316))) 0.00027203559875488
(109) DESCRIBE `ports` 0.0007779598236084
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '316') 0.00027084350585938
(111) DESCRIBE `ports` 0.00072908401489258
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3134))) 0.00024509429931641
(113) DESCRIBE `ports` 0.00071406364440918
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3134') 0.00021004676818848
(115) DESCRIBE `ports` 0.00077295303344727
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.00026893615722656
(117) DESCRIBE `ports` 0.00080394744873047
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.0001988410949707
(119) DESCRIBE `ports` 0.0007178783416748
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00023818016052246
(121) DESCRIBE `ports` 0.0006868839263916
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00020909309387207
(123) DESCRIBE `ports` 0.00072288513183594
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00021791458129883
(125) DESCRIBE `ports` 0.00069594383239746
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00019478797912598
(127) DESCRIBE `ports` 0.00073099136352539
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00020980834960938
(129) DESCRIBE `ports` 0.00069308280944824
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00019502639770508
(131) DESCRIBE `ports` 0.00067496299743652
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1028))) 0.00021600723266602
(133) DESCRIBE `ports` 0.0006871223449707
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1028') 0.00020694732666016
(135) DESCRIBE `ports` 0.00069403648376465
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00021696090698242
(137) DESCRIBE `ports` 0.00073599815368652
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00019598007202148
(139) DESCRIBE `ports` 0.00070619583129883
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00023698806762695
(141) DESCRIBE `ports` 0.00069785118103027
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00019502639770508
(143) DESCRIBE `ports` 0.00067901611328125
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00020790100097656
(145) DESCRIBE `ports` 0.0007011890411377
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018787384033203
(147) DESCRIBE `ports` 0.00067615509033203
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00020194053649902
(149) DESCRIBE `ports` 0.00069212913513184
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018620491027832
(151) DESCRIBE `ports` 0.00067520141601562
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00020885467529297
(153) DESCRIBE `ports` 0.00069284439086914
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00022292137145996
(155) DESCRIBE `ports` 0.00069379806518555
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00026798248291016
(157) DESCRIBE `ports` 0.00095796585083008
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00027108192443848
(159) DESCRIBE `ports` 0.00072097778320312
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00021696090698242
(161) DESCRIBE `ports` 0.00078892707824707
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00022101402282715
(163) DESCRIBE `cruises` 0.0013868808746338
(164) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 58395))) 0.00034785270690918
(165) DESCRIBE `avid_specials` 0.00079202651977539
(166) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1422621 and class = 'Special') OR (item_id = 58395 and class = 'Cruise') OR (item_id = 717 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 7 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.0009770393371582
(167) DESCRIBE `cruiselines` 0.0010409355163574
(168) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00026798248291016
(169) DESCRIBE `orchid_image` 0.00078201293945312
(170) DESCRIBE `specials` 0.0019600391387939
(171) SELECT `specials`.* FROM `specials` WHERE (id = '1422647') AND (specials.orchid_available = 1) LIMIT 1 0.00052118301391602
(172) DESCRIBE `specials` 0.0018661022186279
(173) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1422647') 0.00023007392883301
(174) DESCRIBE `ships` 0.001298189163208
(175) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 147))) 0.00031495094299316
(176) DESCRIBE `ships` 0.0016169548034668
(177) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '147') 0.00029802322387695
(178) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00019288063049316
(179) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00017595291137695
(180) DESCRIBE `itineraries` 0.00078201293945312
(181) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '58161') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00044393539428711
(182) DESCRIBE `ports` 0.00073504447937012
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00021505355834961
(184) DESCRIBE `ports` 0.0006859302520752
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.0001988410949707
(186) DESCRIBE `ports` 0.00068879127502441
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00018811225891113
(188) DESCRIBE `specialsailingdates` 0.00058102607727051
(189) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1422647') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00045990943908691
(190) DESCRIBE `sailingdates` 0.00062990188598633
(191) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 411794))) 0.0001990795135498
(192) DESCRIBE `sailingdates` 0.00061392784118652
(193) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 411795))) 0.00019407272338867
(194) DESCRIBE `ports` 0.00073885917663574
(195) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.0002131462097168
(196) DESCRIBE `ports` 0.00076818466186523
(197) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00019407272338867
(198) DESCRIBE `ports` 0.00074505805969238
(199) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00021004676818848
(200) DESCRIBE `ports` 0.00072193145751953
(201) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00020909309387207
(202) DESCRIBE `ports` 0.00067901611328125
(203) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00020313262939453
(204) DESCRIBE `ports` 0.00067806243896484
(205) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00018811225891113
(206) DESCRIBE `ports` 0.00067687034606934
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1029))) 0.00020694732666016
(208) DESCRIBE `ports` 0.00069117546081543
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1029') 0.00018906593322754
(210) DESCRIBE `ports` 0.00067710876464844
(211) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00020408630371094
(212) DESCRIBE `ports` 0.00069403648376465
(213) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018811225891113
(214) DESCRIBE `ports` 0.00070405006408691
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00026202201843262
(216) DESCRIBE `ports` 0.00083398818969727
(217) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00021791458129883
(218) DESCRIBE `ports` 0.00069403648376465
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00020885467529297
(220) DESCRIBE `ports` 0.00067996978759766
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00023484230041504
(222) DESCRIBE `ports` 0.00071096420288086
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2804))) 0.00020599365234375
(224) DESCRIBE `ports` 0.00075006484985352
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2804') 0.00018787384033203
(226) DESCRIBE `ports` 0.00080299377441406
(227) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00024318695068359
(228) DESCRIBE `ports` 0.00068402290344238
(229) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00018596649169922
(230) DESCRIBE `ports` 0.00069904327392578
(231) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00020003318786621
(232) DESCRIBE `ports` 0.00068497657775879
(233) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00020790100097656
(234) DESCRIBE `ports` 0.00069904327392578
(235) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.0001978874206543
(236) DESCRIBE `ports` 0.00067496299743652
(237) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00018119812011719
(238) DESCRIBE `cruises` 0.0013830661773682
(239) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 58161))) 0.00034499168395996
(240) DESCRIBE `avid_specials` 0.00064301490783691
(241) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1422647 and class = 'Special') OR (item_id = 58161 and class = 'Cruise') OR (item_id = 147 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 7 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.00095605850219727
(242) DESCRIBE `cruiselines` 0.0010159015655518
(243) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00024294853210449
(244) DESCRIBE `orchid_image` 0.0007622241973877
(245) DESCRIBE `specials` 0.0020520687103271
(246) SELECT `specials`.* FROM `specials` WHERE (id = '1422608') AND (specials.orchid_available = 1) LIMIT 1 0.00041794776916504
(247) DESCRIBE `specials` 0.0018901824951172
(248) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1422608') 0.00031495094299316
(249) DESCRIBE `ships` 0.0016000270843506
(250) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 717))) 0.00028204917907715
(251) DESCRIBE `ships` 0.0014228820800781
(252) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '717') 0.00020313262939453
(253) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018882751464844
(254) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017595291137695
(255) DESCRIBE `itineraries` 0.00076198577880859
(256) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '71110') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0009610652923584
(257) DESCRIBE `ports` 0.00084614753723145
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00023078918457031
(259) DESCRIBE `ports` 0.00070405006408691
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00020599365234375
(261) DESCRIBE `ports` 0.00071501731872559
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00019288063049316
(263) DESCRIBE `specialsailingdates` 0.00059294700622559
(264) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1422608') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00051498413085938
(265) DESCRIBE `sailingdates` 0.00067400932312012
(266) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 446657))) 0.00026392936706543
(267) DESCRIBE `ports` 0.0010209083557129
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00030303001403809
(269) DESCRIBE `ports` 0.0010900497436523
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00029802322387695
(271) DESCRIBE `ports` 0.0010640621185303
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00027894973754883
(273) DESCRIBE `ports` 0.0010068416595459
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00024580955505371
(275) DESCRIBE `ports` 0.00093412399291992
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00028014183044434
(277) DESCRIBE `ports` 0.00098800659179688
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00024700164794922
(279) DESCRIBE `ports` 0.0010030269622803
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00028109550476074
(281) DESCRIBE `ports` 0.00099301338195801
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00025200843811035
(283) DESCRIBE `ports` 0.0010619163513184
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00029397010803223
(285) DESCRIBE `ports` 0.0010769367218018
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0002589225769043
(287) DESCRIBE `ports` 0.0009310245513916
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.0002140998840332
(289) DESCRIBE `ports` 0.0007939338684082
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00022292137145996
(291) DESCRIBE `ports` 0.0010290145874023
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2804))) 0.00029706954956055
(293) DESCRIBE `ports` 0.0010619163513184
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2804') 0.00026416778564453
(295) DESCRIBE `ports` 0.0010251998901367
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0004420280456543
(297) DESCRIBE `ports` 0.0011341571807861
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00025200843811035
(299) DESCRIBE `ports` 0.00094079971313477
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00026512145996094
(301) DESCRIBE `ports` 0.00093698501586914
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00024604797363281
(303) DESCRIBE `ports` 0.00095987319946289
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00027179718017578
(305) DESCRIBE `ports` 0.00096011161804199
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00023412704467773
(307) DESCRIBE `cruises` 0.0018031597137451
(308) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71110))) 0.00039887428283691
(309) DESCRIBE `avid_specials` 0.00094103813171387
(310) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1422608 and class = 'Special') OR (item_id = 71110 and class = 'Cruise') OR (item_id = 717 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 7 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.0016088485717773
(311) DESCRIBE `cruiselines` 0.0014340877532959
(312) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00033807754516602
(313) DESCRIBE `orchid_image` 0.0011389255523682
(314) DESCRIBE `specials` 0.0022320747375488
(315) SELECT `specials`.* FROM `specials` WHERE (id = '1422634') AND (specials.orchid_available = 1) LIMIT 1 0.00047516822814941
(316) DESCRIBE `specials` 0.0020968914031982
(317) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1422634') 0.00026893615722656
(318) DESCRIBE `ships` 0.0014839172363281
(319) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 147))) 0.00031709671020508
(320) DESCRIBE `ships` 0.0019600391387939
(321) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '147') 0.00039482116699219
(322) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00025296211242676
(323) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00023984909057617
(324) DESCRIBE `itineraries` 0.0013501644134521
(325) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65442') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00058293342590332
(326) DESCRIBE `ports` 0.0014059543609619
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00034594535827637
(328) DESCRIBE `ports` 0.001068115234375
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00028300285339355
(330) DESCRIBE `ports` 0.0010569095611572
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00027799606323242
(332) DESCRIBE `specialsailingdates` 0.00087809562683105
(333) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1422634') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00075101852416992
(334) DESCRIBE `sailingdates` 0.0012331008911133
(335) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 411796))) 0.00037908554077148
(336) DESCRIBE `ports` 0.0012049674987793
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00034499168395996
(338) DESCRIBE `ports` 0.001147985458374
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00028395652770996
(340) DESCRIBE `ports` 0.001054048538208
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1026))) 0.00031399726867676
(342) DESCRIBE `ports` 0.0010831356048584
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1026') 0.00025582313537598
(344) DESCRIBE `ports` 0.0010230541229248
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 316))) 0.0002751350402832
(346) DESCRIBE `ports` 0.0010621547698975
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '316') 0.00025200843811035
(348) DESCRIBE `ports` 0.0010290145874023
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.00029110908508301
(350) DESCRIBE `ports` 0.0009920597076416
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.00024604797363281
(352) DESCRIBE `ports` 0.00097417831420898
(353) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2884))) 0.00028705596923828
(354) DESCRIBE `ports` 0.00098896026611328
(355) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2884') 0.00026202201843262
(356) DESCRIBE `ports` 0.0010089874267578
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1837))) 0.0002892017364502
(358) DESCRIBE `ports` 0.00072407722473145
(359) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1837') 0.00019598007202148
(360) DESCRIBE `ports` 0.00070309638977051
(361) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00021004676818848
(362) DESCRIBE `ports` 0.00091695785522461
(363) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00019192695617676
(364) DESCRIBE `ports` 0.00082993507385254
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1028))) 0.00023818016052246
(366) DESCRIBE `ports` 0.00078487396240234
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1028') 0.00041604042053223
(368) DESCRIBE `ports` 0.0012359619140625
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1029))) 0.00031900405883789
(370) DESCRIBE `ports` 0.0010321140289307
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1029') 0.00025200843811035
(372) DESCRIBE `ports` 0.0009920597076416
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00029110908508301
(374) DESCRIBE `ports` 0.0010499954223633
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00025486946105957
(376) DESCRIBE `ports` 0.0010521411895752
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00028491020202637
(378) DESCRIBE `ports` 0.0010349750518799
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0002751350402832
(380) DESCRIBE `ports` 0.0010209083557129
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.0002739429473877
(382) DESCRIBE `ports` 0.0010411739349365
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00024509429931641
(384) DESCRIBE `ports` 0.0010151863098145
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00027990341186523
(386) DESCRIBE `ports` 0.001039981842041
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00025701522827148
(388) DESCRIBE `ports` 0.001025915145874
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2804))) 0.00032281875610352
(390) DESCRIBE `ports` 0.0010538101196289
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2804') 0.0002589225769043
(392) DESCRIBE `ports` 0.0010559558868408
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00027894973754883
(394) DESCRIBE `ports` 0.0010459423065186
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.0002598762512207
(396) DESCRIBE `ports` 0.0010859966278076
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00029492378234863
(398) DESCRIBE `ports` 0.0014510154724121
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00032806396484375
(400) DESCRIBE `ports` 0.0010640621185303
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00027298927307129
(402) DESCRIBE `ports` 0.001068115234375
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.0001990795135498
(404) DESCRIBE `cruises` 0.0018250942230225
(405) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 65442))) 0.00041580200195312
(406) DESCRIBE `avid_specials` 0.0010130405426025
(407) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1422634 and class = 'Special') OR (item_id = 65442 and class = 'Cruise') OR (item_id = 147 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 7 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.0011999607086182
(408) DESCRIBE `cruiselines` 0.0016751289367676
(409) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00042510032653809
(410) DESCRIBE `orchid_image` 0.0012121200561523
(411) DESCRIBE `specials` 0.0021991729736328
(412) SELECT `specials`.* FROM `specials` WHERE (id = '1422595') AND (specials.orchid_available = 1) LIMIT 1 0.00044608116149902
(413) DESCRIBE `specials` 0.0019180774688721
(414) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1422595') 0.00031900405883789
(415) DESCRIBE `ships` 0.0013759136199951
(416) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 717))) 0.00026798248291016
(417) DESCRIBE `ships` 0.001323938369751
(418) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '717') 0.00019502639770508
(419) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018501281738281
(420) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00020194053649902
(421) DESCRIBE `itineraries` 0.00072717666625977
(422) DESCRIBE `ports` 0.00099301338195801
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00029706954956055
(424) DESCRIBE `ports` 0.00075507164001465
(425) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.0002589225769043
(426) DESCRIBE `ports` 0.00097417831420898
(427) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00024199485778809
(428) DESCRIBE `specialsailingdates` 0.000823974609375
(429) DESCRIBE `sailingdates` 0.00081515312194824
(430) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 446763))) 0.00036001205444336
(431) DESCRIBE `ports` 0.00070714950561523
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00027585029602051
(433) DESCRIBE `ports` 0.00069499015808105
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00019502639770508
(435) DESCRIBE `ports` 0.00069308280944824
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00038385391235352
(437) DESCRIBE `ports` 0.00087499618530273
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00020909309387207
(439) DESCRIBE `ports` 0.00075602531433105
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0002131462097168
(441) DESCRIBE `ports` 0.00071191787719727
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00019001960754395
(443) DESCRIBE `ports` 0.00069117546081543
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00020599365234375
(445) DESCRIBE `ports` 0.00072193145751953
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018692016601562
(447) DESCRIBE `ports` 0.00067996978759766
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00021004676818848
(449) DESCRIBE `ports` 0.00069212913513184
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00019001960754395
(451) DESCRIBE `ports` 0.00067996978759766
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00021195411682129
(453) DESCRIBE `ports` 0.0008690357208252
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00019598007202148
(455) DESCRIBE `ports` 0.00071597099304199
(456) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00021195411682129
(457) DESCRIBE `ports` 0.00072097778320312
(458) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00023508071899414
(459) DESCRIBE `ports` 0.00068879127502441
(460) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00021004676818848
(461) DESCRIBE `ports` 0.000762939453125
(462) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00019288063049316
(463) DESCRIBE `ports` 0.00068497657775879
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2804))) 0.0002129077911377
(465) DESCRIBE `ports` 0.00072908401489258
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2804') 0.00019192695617676
(467) DESCRIBE `ports` 0.00068497657775879
(468) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00021600723266602
(469) DESCRIBE `ports` 0.00068902969360352
(470) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00018978118896484
(471) DESCRIBE `ports` 0.00067996978759766
(472) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00021910667419434
(473) DESCRIBE `ports` 0.00069594383239746
(474) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00019192695617676
(475) DESCRIBE `ports` 0.00072503089904785
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00021100044250488
(477) DESCRIBE `ports` 0.00069618225097656
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00018501281738281
(479) DESCRIBE `cruises` 0.0013389587402344
(480) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 58377))) 0.00033211708068848
(481) DESCRIBE `avid_specials` 0.00066208839416504
(482) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1422595 and class = 'Special') OR (item_id = 58377 and class = 'Cruise') OR (item_id = 717 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 7 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.00096702575683594
(483) DESCRIBE `cruiselines` 0.0011529922485352
(484) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00025701522827148
(485) DESCRIBE `orchid_image` 0.00078010559082031
(486) DESCRIBE `specials` 0.0022158622741699
(487) SELECT `specials`.* FROM `specials` WHERE (id = '1422582') AND (specials.orchid_available = 1) LIMIT 1 0.00049304962158203
(488) DESCRIBE `specials` 0.0020060539245605
(489) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1422582') 0.00032782554626465
(490) DESCRIBE `ships` 0.0017180442810059
(491) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 717))) 0.00036787986755371
(492) DESCRIBE `ships` 0.0017380714416504
(493) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '717') 0.00030803680419922
(494) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00022101402282715
(495) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017690658569336
(496) DESCRIBE `itineraries` 0.00088000297546387
(497) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '71121') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010778903961182
(498) DESCRIBE `ports` 0.0010499954223633
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00027084350585938
(500) DESCRIBE `ports` 0.00083088874816895
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00020599365234375
(502) DESCRIBE `ports` 0.00070786476135254
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.0001978874206543
(504) DESCRIBE `specialsailingdates` 0.00061202049255371
(505) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1422582') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00046801567077637
(506) DESCRIBE `sailingdates` 0.00078582763671875
(507) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 446764))) 0.00022196769714355
(508) DESCRIBE `ports` 0.00075888633728027
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00021815299987793
(510) DESCRIBE `ports` 0.00069284439086914
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00020790100097656
(512) DESCRIBE `ports` 0.00068402290344238
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2023))) 0.00020790100097656
(514) DESCRIBE `ports` 0.00070691108703613
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2023') 0.00019192695617676
(516) DESCRIBE `ports` 0.00069499015808105
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5501))) 0.00021600723266602
(518) DESCRIBE `ports` 0.00073719024658203
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5501') 0.00022506713867188
(520) DESCRIBE `ports` 0.00068306922912598
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3448))) 0.0002140998840332
(522) DESCRIBE `ports` 0.00067687034606934
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3448') 0.00019097328186035
(524) DESCRIBE `ports` 0.00069308280944824
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00025582313537598
(526) DESCRIBE `ports` 0.00072717666625977
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00019216537475586
(528) DESCRIBE `ports` 0.00071406364440918
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 883))) 0.00021195411682129
(530) DESCRIBE `ports` 0.00069093704223633
(531) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '883') 0.00018906593322754
(532) DESCRIBE `ports` 0.00067687034606934
(533) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2374))) 0.00021195411682129
(534) DESCRIBE `ports` 0.00069808959960938
(535) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2374') 0.00020694732666016
(536) DESCRIBE `ports` 0.00070095062255859
(537) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5286))) 0.00022411346435547
(538) DESCRIBE `ports` 0.0007171630859375
(539) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5286') 0.00020408630371094
(540) DESCRIBE `ports` 0.00072216987609863
(541) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3362))) 0.00020790100097656
(542) DESCRIBE `ports` 0.00073409080505371
(543) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3362') 0.00019717216491699
(544) DESCRIBE `ports` 0.00084090232849121
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 882))) 0.00028800964355469
(546) DESCRIBE `ports` 0.0010089874267578
(547) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '882') 0.00028300285339355
(548) DESCRIBE `ports` 0.0011389255523682
(549) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 323))) 0.00032401084899902
(550) DESCRIBE `ports` 0.0010440349578857
(551) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '323') 0.00028491020202637
(552) DESCRIBE `ports` 0.0011110305786133
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3570))) 0.00031900405883789
(554) DESCRIBE `ports` 0.0011379718780518
(555) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3570') 0.00029802322387695
(556) DESCRIBE `ports` 0.0011191368103027
(557) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 324))) 0.00034189224243164
(558) DESCRIBE `ports` 0.0011918544769287
(559) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '324') 0.00023412704467773
(560) DESCRIBE `cruises` 0.0014541149139404
(561) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71121))) 0.00043988227844238
(562) DESCRIBE `avid_specials` 0.00079107284545898
(563) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1422582 and class = 'Special') OR (item_id = 71121 and class = 'Cruise') OR (item_id = 717 AND class = 'Ship') OR (item_id = 29 AND class = 'CruiseLine') OR (item_id = 37 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.00099015235900879
(564) DESCRIBE `cruiselines` 0.0011420249938965
(565) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00028705596923828
(566) DESCRIBE `orchid_image` 0.00088381767272949
(567) DESCRIBE `ships` 0.002335786819458
(568) SELECT `ships`.* FROM `ships` WHERE (id IN ('147', '717')) ORDER BY FIND_IN_SET(id, '147,717') 0.00053715705871582
(569) DESCRIBE `cruisetypes` 0.00088787078857422
(570) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '29') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.031722068786621
(571) DESCRIBE `destinations` 0.0014030933380127
(572) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('7', '37')) ORDER BY FIND_IN_SET(id, '7,37') 0.00040483474731445
(573) DESCRIBE `cruiselines` 0.0009620189666748
(574) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00024604797363281
(575) DESCRIBE `cruiselines` 0.00098896026611328
(576) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 29))) 0.00028896331787109