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

Total elapsed time: 0.32971215248108

# Query Time
(1) connect 0.00059604644775391
(2) DESCRIBE `cruises` 0.0016741752624512
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (68580, 73589, 8256, 13508, 29120, 39342, 40593, 45259, 45259, 47265)) ORDER BY FIND_IN_SET(id, '68580,73589,8256,13508,29120,39342,40593,45259,45259,47265') 0.00095105171203613
(4) DESCRIBE `cruises` 0.0013160705566406
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '68580') 0.00023508071899414
(6) DESCRIBE `ships` 0.0012691020965576
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 658))) 0.00025320053100586
(8) DESCRIBE `ships` 0.0013267993927002
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '658') 0.00018596649169922
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001828670501709
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017189979553223
(12) DESCRIBE `itineraries` 0.00070309638977051
(13) DESCRIBE `ports` 0.00069904327392578
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00021505355834961
(15) DESCRIBE `ports` 0.00067687034606934
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00028014183044434
(17) DESCRIBE `ports` 0.00083804130554199
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00020503997802734
(19) DESCRIBE `sailingdates` 0.00064206123352051
(20) DESCRIBE `ports` 0.000885009765625
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00024604797363281
(22) DESCRIBE `ports` 0.0008399486541748
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00019598007202148
(24) DESCRIBE `ports` 0.00068092346191406
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1063))) 0.00022387504577637
(26) DESCRIBE `ports` 0.00067710876464844
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1063') 0.00018596649169922
(28) DESCRIBE `ports` 0.00071096420288086
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 752))) 0.00021600723266602
(30) DESCRIBE `ports` 0.00069499015808105
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '752') 0.00018620491027832
(32) DESCRIBE `ports` 0.00069594383239746
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00020813941955566
(34) DESCRIBE `ports` 0.00067996978759766
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00018692016601562
(36) DESCRIBE `avid_specials` 0.0006248950958252
(37) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 68580 and class = 'Cruise') OR (item_id = 658 AND class = 'Ship') OR (item_id = 26 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.0011191368103027
(38) DESCRIBE `cruiselines` 0.0010759830474854
(39) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00024795532226562
(40) DESCRIBE `orchid_image` 0.00078511238098145
(41) DESCRIBE `cruiselines` 0.0013010501861572
(42) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00023007392883301
(43) DESCRIBE `cruises` 0.0014290809631348
(44) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '73589') 0.00024199485778809
(45) DESCRIBE `ships` 0.0013279914855957
(46) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 116))) 0.00027608871459961
(47) DESCRIBE `ships` 0.0013628005981445
(48) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '116') 0.00023412704467773
(49) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018501281738281
(50) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017094612121582
(51) DESCRIBE `itineraries` 0.00067496299743652
(52) DESCRIBE `ports` 0.00095891952514648
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00027990341186523
(54) DESCRIBE `ports` 0.00087881088256836
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00024604797363281
(56) DESCRIBE `ports` 0.0008549690246582
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00022506713867188
(58) DESCRIBE `sailingdates` 0.00076508522033691
(59) DESCRIBE `ports` 0.00092291831970215
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00026202201843262
(61) DESCRIBE `ports` 0.0010190010070801
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.000244140625
(63) DESCRIBE `ports` 0.0010058879852295
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00025415420532227
(65) DESCRIBE `ports` 0.00091314315795898
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00023388862609863
(67) DESCRIBE `ports` 0.00089311599731445
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00024795532226562
(69) DESCRIBE `ports` 0.00094199180603027
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00021719932556152
(71) DESCRIBE `ports` 0.00099587440490723
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00026202201843262
(73) DESCRIBE `ports` 0.00098705291748047
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00023388862609863
(75) DESCRIBE `ports` 0.0010008811950684
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2153))) 0.00026917457580566
(77) DESCRIBE `ports` 0.0010120868682861
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2153') 0.00024104118347168
(79) DESCRIBE `avid_specials` 0.00089788436889648
(80) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 73589 and class = 'Cruise') OR (item_id = 116 AND class = 'Ship') OR (item_id = 26 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.0017039775848389
(81) DESCRIBE `cruiselines` 0.00099396705627441
(82) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.00027799606323242
(83) DESCRIBE `orchid_image` 0.00096297264099121
(84) DESCRIBE `cruiselines` 0.0013360977172852
(85) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00025296211242676
(86) DESCRIBE `cruises` 0.0013349056243896
(87) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '8256') 0.00022602081298828
(88) DESCRIBE `ships` 0.0013489723205566
(89) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 207))) 0.00027298927307129
(90) DESCRIBE `ships` 0.001507043838501
(91) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '207') 0.00023984909057617
(92) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00023293495178223
(93) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00021910667419434
(94) DESCRIBE `itineraries` 0.00098800659179688
(95) DESCRIBE `ports` 0.00071597099304199
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00021982192993164
(97) DESCRIBE `ports` 0.0006859302520752
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00020098686218262
(99) DESCRIBE `ports` 0.00070810317993164
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00024700164794922
(101) DESCRIBE `sailingdates` 0.00066184997558594
(102) DESCRIBE `ports` 0.00081896781921387
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.0002140998840332
(104) DESCRIBE `ports` 0.00069093704223633
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00018787384033203
(106) DESCRIBE `ports` 0.00072884559631348
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 263))) 0.00020384788513184
(108) DESCRIBE `ports` 0.0006711483001709
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '263') 0.0001828670501709
(110) DESCRIBE `ports` 0.0006721019744873
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 265))) 0.0001981258392334
(112) DESCRIBE `ports` 0.00066900253295898
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '265') 0.0001828670501709
(114) DESCRIBE `ports` 0.00080585479736328
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 266))) 0.00020194053649902
(116) DESCRIBE `ports` 0.00069284439086914
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '266') 0.00018310546875
(118) DESCRIBE `ports` 0.00068402290344238
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00020194053649902
(120) DESCRIBE `ports` 0.00069594383239746
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00018215179443359
(122) DESCRIBE `avid_specials` 0.00060606002807617
(123) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 8256 and class = 'Cruise') OR (item_id = 207 AND class = 'Ship') OR (item_id = 36 AND class = 'CruiseLine') OR (item_id = 8 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
(124) DESCRIBE `cruiselines` 0.00099086761474609
(125) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 36))) 0.00023889541625977
(126) DESCRIBE `orchid_image` 0.00081896781921387
(127) DESCRIBE `cruiselines` 0.00093793869018555
(128) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '36') 0.00020003318786621
(129) DESCRIBE `cruises` 0.0013308525085449
(130) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '13508') 0.00023508071899414
(131) DESCRIBE `ships` 0.001500129699707
(132) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 14))) 0.00024318695068359
(133) DESCRIBE `ships` 0.0012791156768799
(134) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '14') 0.00018310546875
(135) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018596649169922
(136) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017213821411133
(137) DESCRIBE `itineraries` 0.00072312355041504
(138) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '13508') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0015811920166016
(139) DESCRIBE `ports` 0.0011470317840576
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00021195411682129
(141) DESCRIBE `ports` 0.00072383880615234
(142) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00021100044250488
(143) DESCRIBE `ports` 0.00070786476135254
(144) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00018310546875
(145) DESCRIBE `sailingdates` 0.00066804885864258
(146) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '13508') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0023438930511475
(147) DESCRIBE `ports` 0.00071501731872559
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.00020694732666016
(149) DESCRIBE `ports` 0.00068902969360352
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00025701522827148
(151) DESCRIBE `ports` 0.00066709518432617
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.0001988410949707
(153) DESCRIBE `ports` 0.0007929801940918
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00021982192993164
(155) DESCRIBE `ports` 0.00075197219848633
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00020098686218262
(157) DESCRIBE `ports` 0.0006711483001709
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00018620491027832
(159) DESCRIBE `ports` 0.00066804885864258
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1161))) 0.00020599365234375
(161) DESCRIBE `ports` 0.00066399574279785
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1161') 0.00018191337585449
(163) DESCRIBE `ports` 0.00066304206848145
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00020003318786621
(165) DESCRIBE `ports` 0.00067400932312012
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00018191337585449
(167) DESCRIBE `ports` 0.00066304206848145
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00019693374633789
(169) DESCRIBE `ports` 0.00065898895263672
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00018000602722168
(171) DESCRIBE `ports` 0.00069594383239746
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00020217895507812
(173) DESCRIBE `ports` 0.00066304206848145
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00018095970153809
(175) DESCRIBE `ports` 0.00066399574279785
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 259))) 0.00022292137145996
(177) DESCRIBE `ports` 0.00067806243896484
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '259') 0.00018215179443359
(179) DESCRIBE `ports` 0.00066614151000977
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.0001981258392334
(181) DESCRIBE `ports` 0.00066208839416504
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00018095970153809
(183) DESCRIBE `ports` 0.00083398818969727
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 268))) 0.0001990795135498
(185) DESCRIBE `ports` 0.00073409080505371
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '268') 0.00018119812011719
(187) DESCRIBE `avid_specials` 0.0007169246673584
(188) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 13508 and class = 'Cruise') OR (item_id = 14 AND class = 'Ship') OR (item_id = 35 AND class = 'CruiseLine') OR (item_id = 46 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
(189) DESCRIBE `cruiselines` 0.00098395347595215
(190) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 35))) 0.0002129077911377
(191) DESCRIBE `orchid_image` 0.00079083442687988
(192) DESCRIBE `cruiselines` 0.00091099739074707
(193) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '35') 0.00017404556274414
(194) DESCRIBE `cruises` 0.0012669563293457
(195) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '29120') 0.00019407272338867
(196) DESCRIBE `ships` 0.001262903213501
(197) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 837))) 0.0002589225769043
(198) DESCRIBE `ships` 0.0012309551239014
(199) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '837') 0.00017499923706055
(200) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017309188842773
(201) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016307830810547
(202) DESCRIBE `itineraries` 0.00065803527832031
(203) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '29120') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00089287757873535
(204) DESCRIBE `ports` 0.00068402290344238
(205) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00021791458129883
(206) DESCRIBE `ports` 0.00065708160400391
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00019001960754395
(208) DESCRIBE `ports` 0.0006568431854248
(209) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00017404556274414
(210) DESCRIBE `sailingdates` 0.00058507919311523
(211) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '29120') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00048589706420898
(212) DESCRIBE `ports` 0.00068497657775879
(213) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00019979476928711
(214) DESCRIBE `ports` 0.00069999694824219
(215) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00018095970153809
(216) DESCRIBE `ports` 0.0006721019744873
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00020194053649902
(218) DESCRIBE `ports` 0.00066399574279785
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00018215179443359
(220) DESCRIBE `ports` 0.00069618225097656
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1102))) 0.00020694732666016
(222) DESCRIBE `ports` 0.00066184997558594
(223) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1102') 0.00018000602722168
(224) DESCRIBE `ports` 0.00065517425537109
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 330))) 0.00020289421081543
(226) DESCRIBE `ports` 0.0006871223449707
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '330') 0.00018501281738281
(228) DESCRIBE `avid_specials` 0.00060796737670898
(229) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 29120 and class = 'Cruise') OR (item_id = 837 AND class = 'Ship') OR (item_id = 16 AND class = 'CruiseLine') OR (item_id = 9 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.00089907646179199
(230) DESCRIBE `cruiselines` 0.00095200538635254
(231) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 16))) 0.00021004676818848
(232) DESCRIBE `orchid_image` 0.00073885917663574
(233) DESCRIBE `cruiselines` 0.00090599060058594
(234) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '16') 0.00018620491027832
(235) DESCRIBE `cruises` 0.0012600421905518
(236) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '39342') 0.00018906593322754
(237) DESCRIBE `ships` 0.0013949871063232
(238) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 27))) 0.00025391578674316
(239) DESCRIBE `ships` 0.0012340545654297
(240) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '27') 0.00018906593322754
(241) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017118453979492
(242) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017118453979492
(243) DESCRIBE `itineraries` 0.0006411075592041
(244) DESCRIBE `ports` 0.00067400932312012
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00019598007202148
(246) DESCRIBE `ports` 0.00067400932312012
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0001990795135498
(248) DESCRIBE `ports` 0.0006558895111084
(249) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00019001960754395
(250) DESCRIBE `sailingdates` 0.00059294700622559
(251) DESCRIBE `ports` 0.00072288513183594
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00023198127746582
(253) DESCRIBE `ports` 0.00066614151000977
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00018596649169922
(255) DESCRIBE `ports` 0.00071096420288086
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 132))) 0.00022602081298828
(257) DESCRIBE `ports` 0.00080084800720215
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '132') 0.00020408630371094
(259) DESCRIBE `ports` 0.00078296661376953
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00021815299987793
(261) DESCRIBE `ports` 0.0006868839263916
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00018095970153809
(263) DESCRIBE `ports` 0.00076389312744141
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00025701522827148
(265) DESCRIBE `ports` 0.00090909004211426
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.0002288818359375
(267) DESCRIBE `avid_specials` 0.00093793869018555
(268) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 39342 and class = 'Cruise') OR (item_id = 27 AND class = 'Ship') OR (item_id = 218 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.0013411045074463
(269) DESCRIBE `cruiselines` 0.0012249946594238
(270) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00022983551025391
(271) DESCRIBE `orchid_image` 0.0013399124145508
(272) DESCRIBE `cruiselines` 0.0016810894012451
(273) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.00045084953308105
(274) DESCRIBE `cruises` 0.0017518997192383
(275) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '40593') 0.00043416023254395
(276) DESCRIBE `ships` 0.0023648738861084
(277) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1032))) 0.00045299530029297
(278) DESCRIBE `ships` 0.0024969577789307
(279) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1032') 0.0001828670501709
(280) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017189979553223
(281) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017213821411133
(282) DESCRIBE `itineraries` 0.00065708160400391
(283) DESCRIBE `ports` 0.0006868839263916
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00021600723266602
(285) DESCRIBE `ports` 0.00067496299743652
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.0001978874206543
(287) DESCRIBE `ports` 0.00066494941711426
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00018501281738281
(289) DESCRIBE `sailingdates` 0.00066614151000977
(290) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '40593') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00057888031005859
(291) DESCRIBE `ports` 0.000701904296875
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00021600723266602
(293) DESCRIBE `ports` 0.00066804885864258
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00018310546875
(295) DESCRIBE `ports` 0.00066900253295898
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.0001990795135498
(297) DESCRIBE `ports` 0.0006721019744873
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00017905235290527
(299) DESCRIBE `ports` 0.00066900253295898
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00020194053649902
(301) DESCRIBE `ports` 0.00072884559631348
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00018191337585449
(303) DESCRIBE `ports` 0.00071191787719727
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00020003318786621
(305) DESCRIBE `ports` 0.00067019462585449
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00018191337585449
(307) DESCRIBE `ports` 0.00066494941711426
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00020384788513184
(309) DESCRIBE `ports` 0.00074005126953125
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00017905235290527
(311) DESCRIBE `avid_specials` 0.00059890747070312
(312) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 40593 and class = 'Cruise') OR (item_id = 1032 AND class = 'Ship') OR (item_id = 191 AND class = 'CruiseLine') OR (item_id = 55 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.00094103813171387
(313) DESCRIBE `cruiselines` 0.00096988677978516
(314) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00020813941955566
(315) DESCRIBE `orchid_image` 0.00074100494384766
(316) DESCRIBE `cruiselines` 0.0010318756103516
(317) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00019383430480957
(318) DESCRIBE `specials` 0.0022599697113037
(319) DESCRIBE `specials` 0.002424955368042
(320) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1420991') 0.00049018859863281
(321) DESCRIBE `ships` 0.0030930042266846
(322) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.0006718635559082
(323) DESCRIBE `ships` 0.0026810169219971
(324) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00035285949707031
(325) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00031304359436035
(326) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00030183792114258
(327) DESCRIBE `itineraries` 0.0011711120605469
(328) DESCRIBE `ports` 0.00082898139953613
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00024104118347168
(330) DESCRIBE `ports` 0.00067496299743652
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00019693374633789
(332) DESCRIBE `ports` 0.0006711483001709
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00018119812011719
(334) DESCRIBE `specialsailingdates` 0.00066089630126953
(335) DESCRIBE `sailingdates` 0.00064897537231445
(336) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465290))) 0.00025081634521484
(337) DESCRIBE `sailingdates` 0.00060105323791504
(338) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465291))) 0.00019097328186035
(339) DESCRIBE `sailingdates` 0.0005948543548584
(340) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465292))) 0.00018692016601562
(341) DESCRIBE `sailingdates` 0.00058913230895996
(342) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465293))) 0.00018596649169922
(343) DESCRIBE `sailingdates` 0.00059008598327637
(344) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465294))) 0.00018692016601562
(345) DESCRIBE `sailingdates` 0.00059080123901367
(346) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465295))) 0.00021100044250488
(347) DESCRIBE `sailingdates` 0.00068211555480957
(348) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465296))) 0.00019097328186035
(349) DESCRIBE `sailingdates` 0.00064492225646973
(350) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465297))) 0.00019311904907227
(351) DESCRIBE `sailingdates` 0.0007779598236084
(352) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465298))) 0.00019598007202148
(353) DESCRIBE `sailingdates` 0.00061392784118652
(354) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465299))) 0.00019097328186035
(355) DESCRIBE `sailingdates` 0.00060200691223145
(356) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465300))) 0.00019001960754395
(357) DESCRIBE `sailingdates` 0.00061798095703125
(358) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465301))) 0.00018811225891113
(359) DESCRIBE `sailingdates` 0.00060606002807617
(360) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465302))) 0.00018811225891113
(361) DESCRIBE `sailingdates` 0.00059700012207031
(362) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465303))) 0.00018715858459473
(363) DESCRIBE `sailingdates` 0.00059199333190918
(364) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465304))) 0.00018906593322754
(365) DESCRIBE `sailingdates` 0.00061511993408203
(366) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465305))) 0.00018811225891113
(367) DESCRIBE `sailingdates` 0.00059103965759277
(368) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465306))) 0.00021100044250488
(369) DESCRIBE `sailingdates` 0.00063896179199219
(370) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465307))) 0.00018811225891113
(371) DESCRIBE `sailingdates` 0.00059199333190918
(372) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465308))) 0.00018811225891113
(373) DESCRIBE `sailingdates` 0.00059103965759277
(374) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465309))) 0.00018811225891113
(375) DESCRIBE `sailingdates` 0.0005948543548584
(376) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465310))) 0.0001978874206543
(377) DESCRIBE `sailingdates` 0.00076103210449219
(378) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465311))) 0.00034713745117188
(379) DESCRIBE `sailingdates` 0.00059103965759277
(380) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465312))) 0.00019192695617676
(381) DESCRIBE `sailingdates` 0.00060701370239258
(382) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465313))) 0.00018692016601562
(383) DESCRIBE `sailingdates` 0.0011820793151855
(384) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465314))) 0.00031399726867676
(385) DESCRIBE `sailingdates` 0.00089597702026367
(386) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465315))) 0.00025200843811035
(387) DESCRIBE `sailingdates` 0.00069618225097656
(388) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465316))) 0.00019192695617676
(389) DESCRIBE `sailingdates` 0.00086283683776855
(390) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465317))) 0.00024795532226562
(391) DESCRIBE `sailingdates` 0.00060415267944336
(392) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465318))) 0.00018906593322754
(393) DESCRIBE `sailingdates` 0.00059890747070312
(394) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465319))) 0.00018906593322754
(395) DESCRIBE `sailingdates` 0.00059413909912109
(396) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465320))) 0.00019216537475586
(397) DESCRIBE `sailingdates` 0.00060009956359863
(398) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465321))) 0.00018811225891113
(399) DESCRIBE `sailingdates` 0.00071096420288086
(400) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465322))) 0.00020813941955566
(401) DESCRIBE `sailingdates` 0.00059390068054199
(402) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465323))) 0.00018620491027832
(403) DESCRIBE `sailingdates` 0.00059413909912109
(404) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465324))) 0.00018620491027832
(405) DESCRIBE `sailingdates` 0.00059199333190918
(406) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465325))) 0.00019001960754395
(407) DESCRIBE `sailingdates` 0.00059604644775391
(408) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465326))) 0.00018692016601562
(409) DESCRIBE `sailingdates` 0.00058913230895996
(410) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465327))) 0.00018596649169922
(411) DESCRIBE `sailingdates` 0.00061798095703125
(412) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465328))) 0.00018692016601562
(413) DESCRIBE `sailingdates` 0.00066590309143066
(414) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465329))) 0.0001990795135498
(415) DESCRIBE `sailingdates` 0.00061607360839844
(416) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465330))) 0.00018906593322754
(417) DESCRIBE `sailingdates` 0.00059390068054199
(418) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465331))) 0.00018692016601562
(419) DESCRIBE `sailingdates` 0.00059604644775391
(420) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465332))) 0.00018811225891113
(421) DESCRIBE `sailingdates` 0.00060892105102539
(422) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 465333))) 0.00024318695068359
(423) DESCRIBE `ports` 0.00072789192199707
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00022506713867188
(425) DESCRIBE `ports` 0.00066995620727539
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00019407272338867
(427) DESCRIBE `ports` 0.0006859302520752
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00020790100097656
(429) DESCRIBE `ports` 0.00066590309143066
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00018095970153809
(431) DESCRIBE `ports` 0.00079202651977539
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00020289421081543
(433) DESCRIBE `ports` 0.0007178783416748
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00018596649169922
(435) DESCRIBE `ports` 0.00066900253295898
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00020909309387207
(437) DESCRIBE `ports` 0.00066494941711426
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00018095970153809
(439) DESCRIBE `ports` 0.00066208839416504
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0001990795135498
(441) DESCRIBE `ports` 0.00066494941711426
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00018095970153809
(443) DESCRIBE `cruises` 0.0013141632080078
(444) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 45259))) 0.00029397010803223
(445) DESCRIBE `avid_specials` 0.00061392784118652
(446) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1420991 and class = 'Special') OR (item_id = 45259 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00094795227050781
(447) DESCRIBE `cruiselines` 0.00095486640930176
(448) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.0002138614654541
(449) DESCRIBE `orchid_image` 0.00075411796569824
(450) DESCRIBE `cruiselines` 0.00095415115356445
(451) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00018191337585449
(452) DESCRIBE `cruises` 0.0012111663818359
(453) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45259') 0.00019598007202148
(454) DESCRIBE `ships` 0.001284122467041
(455) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00023603439331055
(456) DESCRIBE `ships` 0.0012340545654297
(457) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00019598007202148
(458) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0001828670501709
(459) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017213821411133
(460) DESCRIBE `itineraries` 0.00065994262695312
(461) DESCRIBE `ports` 0.00067806243896484
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00020790100097656
(463) DESCRIBE `ports` 0.00189208984375
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00019598007202148
(465) DESCRIBE `ports` 0.00069499015808105
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00018000602722168
(467) DESCRIBE `sailingdates` 0.00060701370239258
(468) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '45259') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00055980682373047
(469) DESCRIBE `ports` 0.00074219703674316
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00023293495178223
(471) DESCRIBE `ports` 0.00072002410888672
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00019121170043945
(473) DESCRIBE `ports` 0.00067400932312012
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00020408630371094
(475) DESCRIBE `ports` 0.00069284439086914
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.0001828670501709
(477) DESCRIBE `ports` 0.00068187713623047
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00020003318786621
(479) DESCRIBE `ports` 0.00067377090454102
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00018215179443359
(481) DESCRIBE `ports` 0.00066494941711426
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.0001981258392334
(483) DESCRIBE `ports` 0.00066709518432617
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00018191337585449
(485) DESCRIBE `ports` 0.0007779598236084
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.0001978874206543
(487) DESCRIBE `ports` 0.00068807601928711
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00018405914306641
(489) DESCRIBE `avid_specials` 0.00060701370239258
(490) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 45259 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00095987319946289
(491) DESCRIBE `cruiselines` 0.00094699859619141
(492) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00020980834960938
(493) DESCRIBE `orchid_image` 0.0007469654083252
(494) DESCRIBE `cruiselines` 0.00092506408691406
(495) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00017881393432617
(496) DESCRIBE `cruises` 0.0013308525085449
(497) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '47265') 0.00020289421081543
(498) DESCRIBE `ships` 0.0012850761413574
(499) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 22))) 0.00025510787963867
(500) DESCRIBE `ships` 0.0012640953063965
(501) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '22') 0.00018692016601562
(502) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00018405914306641
(503) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00017309188842773
(504) DESCRIBE `itineraries` 0.00066208839416504
(505) DESCRIBE `ports` 0.00072884559631348
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.0002129077911377
(507) DESCRIBE `ports` 0.00069713592529297
(508) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00020098686218262
(509) DESCRIBE `ports` 0.00068187713623047
(510) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00018501281738281
(511) DESCRIBE `sailingdates` 0.00060915946960449
(512) DESCRIBE `ports` 0.0008540153503418
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00022220611572266
(514) DESCRIBE `ports` 0.00067305564880371
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00018882751464844
(516) DESCRIBE `ports` 0.00067591667175293
(517) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2129))) 0.00021791458129883
(518) DESCRIBE `ports` 0.00067901611328125
(519) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2129') 0.00018620491027832
(520) DESCRIBE `ports` 0.00067996978759766
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 331))) 0.00020599365234375
(522) DESCRIBE `ports` 0.00066900253295898
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '331') 0.00018310546875
(524) DESCRIBE `ports` 0.00068306922912598
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00020003318786621
(526) DESCRIBE `ports` 0.00067520141601562
(527) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00018191337585449
(528) DESCRIBE `avid_specials` 0.00060892105102539
(529) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 47265 and class = 'Cruise') OR (item_id = 22 AND class = 'Ship') OR (item_id = 218 AND class = 'CruiseLine') OR (item_id = 53 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.00098299980163574
(530) DESCRIBE `cruiselines` 0.0011279582977295
(531) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 218))) 0.00022506713867188
(532) DESCRIBE `orchid_image` 0.00074481964111328
(533) DESCRIBE `cruiselines` 0.00090694427490234
(534) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '218') 0.0001828670501709
(535) DESCRIBE `cruiselines` 0.000946044921875
(536) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '23', '171', '31', '18', '101', '183', '20', '7', '8', '96', '144', '12', '120', '221', '103', '50', '268', '15', '29', '37', '91', '110', '232', '208', '28', '206', '33', '131', '156', '49', '118', '24', '220', '114', '262', '204', '181', '187', '258', '256', '47', '36', '212', '30', '16', '151', '191', '14', '249', '153', '211', '195', '238', '141', '174', '216', '35', '239', '4', '213', '113', '159', '168', '196', '188', '146', '136', '90', '237', '209', '73', '170', '180', '59', '115', '225', '229', '140', '95', '219', '57', '108', '231', '269', '184', '52', '132', '248', '276', '88', '275', '38', '182', '261', '264', '244', '82', '230', '105', '116', '266', '39', '64', '48', '119', '240', '224', '245', '210', '134', '251')) ORDER BY FIND_IN_SET(id, '218,77,19,26,23,171,31,18,101,183,20,7,8,96,144,12,120,221,103,50,268,15,29,37,91,110,232,208,28,206,33,131,156,49,118,24,220,114,262,204,181,187,258,256,47,36,212,30,16,151,191,14,249,153,211,195,238,141,174,216,35,239,4,213,113,159,168,196,188,146,136,90,237,209,73,170,180,59,115,225,229,140,95,219,57,108,231,269,184,52,132,248,276,88,275,38,182,261,264,244,82,230,105,116,266,39,64,48,119,240,224,245,210,134,251') 0.0028929710388184
(537) DESCRIBE `ships` 0.0016889572143555
(538) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1247', '1554', '1555', '977', '1199', '1291', '1588', '407', '517', '726', '258', '1237', '27', '22', '1424', '461', '1599', '28', '21', '817', '1422', '1594', '393', '1419', '1420', '1423', '1418', '1421', '1135', '349', '1359', '452', '780', '113', '766', '265', '24', '11', '439', '1574', '9', '10', '207', '542', '1067', '1245', '585', '674', '770', '330', '404', '1272', '455', '974', '124', '1455', '1460', '792', '1215', '553', '797', '5', '739', '871', '116', '573', '1572', '25', '3', '520', '855', '1607', '14', '78', '711', '1193', '340', '434', '1021', '1302', '1402', '253', '1586', '390', '1284', '748', '1172', '43', '559', '580', '1581', '462', '765', '285', '791', '1320', '1323', '874', '658', '405', '1139', '590', '678', '286', '582', '883', '119', '327', '526', '731', '859', '970', '454', '854', '406', '81', '823', '610', '722', '850', '1236', '1027', '1569', '114', '993', '1348', '1319', '1415', '1614', '30', '31', '34', '35', '36', '37', '38', '82', '378', '403', '1008', '1012', '1326', '1327', '1678', '39', '160', '333', '547', '1330', '451', '1205', '1325', '163', '348', '351', '784', '966', '1454', '338', '657', '84', '262', '701', '1575', '325', '521', '683', '1143', '732', '287', '352', '1318', '4', '111', '508', '1088', '1108', '1151', '1157', '1471', '1579', '389', '1032', '1075', '1134', '1367', '290', '314', '751', '1214', '1233', '1308', '335', '1145', '1223', '1345', '93', '1013', '1321', '1405', '162', '1137', '1344', '1376', '291', '394', '483', '651', '673', '1144', '1343', '1587', '45', '852', '1604', '545', '988', '1149', '1452', '1453', '1615', '152', '401', '1025', '1090', '1095', '1136', '1283', '1724', '98', '441', '882', '968', '1168', '1243', '1373', '1413', '626', '716', '768', '1163', '1301', '1398', '59', '148', '149', '150', '769', '986', '1382', '1417', '1492', '1526', '75', '151', '639', '669', '905', '1150', '1176', '1226', '1292', '1448', '201', '1449', '324', '776', '973', '1647', '223', '417', '601', '616', '837', '996', '1241', '1458', '1552', '1602', '108', '313', '467', '1026', '1411', '266', '341', '857', '1231', '1489', '954', '1029', '1034', '1285', '1366', '1496', '1609', '1711', '74', '421', '666', '704', '851', '1055', '1152', '1362', '1368', '1372', '480', '885', '1230', '1260', '1384', '1516', '105', '147', '574', '888', '1383', '1408', '1470', '1628', '1717', '503', '790', '1054', '1154', '1208', '1224', '1518', '749', '1505', '1571', '208', '1672', '205', '332', '494', '652', '796', '884', '1253', '1501', '1521', '1611', '422', '618', '811', '818', '836', '985', '1148', '123', '493', '1068', '1486', '1517', '1522', '1632', '204', '212', '423', '937', '938', '1409', '1612', '1682', '448', '485', '1138', '1593', '1639', '994', '995', '1410', '66', '972', '1141', '375', '1017', '1303', '1461', '1539', '1627', '1064', '1601', '420', '1073', '1437', '1514', '1028', '1229', '1254', '1481', '1515', '1613', '1716', '453', '487', '665', '1259', '1412', '1684', '1175', '1189', '1262', '1619', '70', '717', '795', '958', '1159', '1713', '1715', '775', '1053', '1266', '1439', '1714', '715', '738', '1011', '1240', '1704', '1274', '1606', '69', '419', '1106', '1110', '1192', '1360', '1361', '1385', '1459', '944', '1183', '1184', '1347', '808', '1058', '1089', '1338', '1339', '1342', '1474', '1543', '1545', '1160', '1195', '1322', '1708', '62', '488', '798', '886', '1071', '1298', '1311', '1404', '1723', '225', '1158', '1310', '1645', '1649', '1697', '1729', '17', '299', '300', '997', '1043', '1087', '1132', '1355', '1358', '1451', '1629', '479', '672', '821', '1023', '1063', '1217', '1257', '1312', '1540', '288', '555', '692', '707', '1047', '1109', '1140', '1282', '1329', '1350', '1426', '1546')) ORDER BY FIND_IN_SET(id, '1127,1247,1554,1555,977,1199,1291,1588,407,517,726,258,1237,27,22,1424,461,1599,28,21,817,1422,1594,393,1419,1420,1423,1418,1421,1135,349,1359,452,780,113,766,265,24,11,439,1574,9,10,207,542,1067,1245,585,674,770,330,404,1272,455,974,124,1455,1460,792,1215,553,797,5,739,871,116,573,1572,25,3,520,855,1607,14,78,711,1193,340,434,1021,1302,1402,253,1586,390,1284,748,1172,43,559,580,1581,462,765,285,791,1320,1323,874,658,405,1139,590,678,286,582,883,119,327,526,731,859,970,454,854,406,81,823,610,722,850,1236,1027,1569,114,993,1348,1319,1415,1614,30,31,34,35,36,37,38,82,378,403,1008,1012,1326,1327,1678,39,160,333,547,1330,451,1205,1325,163,348,351,784,966,1454,338,657,84,262,701,1575,325,521,683,1143,732,287,352,1318,4,111,508,1088,1108,1151,1157,1471,1579,389,1032,1075,1134,1367,290,314,751,1214,1233,1308,335,1145,1223,1345,93,1013,1321,1405,162,1137,1344,1376,291,394,483,651,673,1144,1343,1587,45,852,1604,545,988,1149,1452,1453,1615,152,401,1025,1090,1095,1136,1283,1724,98,441,882,968,1168,1243,1373,1413,626,716,768,1163,1301,1398,59,148,149,150,769,986,1382,1417,1492,1526,75,151,639,669,905,1150,1176,1226,1292,1448,201,1449,324,776,973,1647,223,417,601,616,837,996,1241,1458,1552,1602,108,313,467,1026,1411,266,341,857,1231,1489,954,1029,1034,1285,1366,1496,1609,1711,74,421,666,704,851,1055,1152,1362,1368,1372,480,885,1230,1260,1384,1516,105,147,574,888,1383,1408,1470,1628,1717,503,790,1054,1154,1208,1224,1518,749,1505,1571,208,1672,205,332,494,652,796,884,1253,1501,1521,1611,422,618,811,818,836,985,1148,123,493,1068,1486,1517,1522,1632,204,212,423,937,938,1409,1612,1682,448,485,1138,1593,1639,994,995,1410,66,972,1141,375,1017,1303,1461,1539,1627,1064,1601,420,1073,1437,1514,1028,1229,1254,1481,1515,1613,1716,453,487,665,1259,1412,1684,1175,1189,1262,1619,70,717,795,958,1159,1713,1715,775,1053,1266,1439,1714,715,738,1011,1240,1704,1274,1606,69,419,1106,1110,1192,1360,1361,1385,1459,944,1183,1184,1347,808,1058,1089,1338,1339,1342,1474,1543,1545,1160,1195,1322,1708,62,488,798,886,1071,1298,1311,1404,1723,225,1158,1310,1645,1649,1697,1729,17,299,300,997,1043,1087,1132,1355,1358,1451,1629,479,672,821,1023,1063,1217,1257,1312,1540,288,555,692,707,1047,1109,1140,1282,1329,1350,1426,1546') 0.021858930587769
(539) DESCRIBE `cruisetypes` 0.0010027885437012
(540) DESCRIBE `destinations` 0.00092506408691406
(541) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '37', '2', '25', '9', '43', '8', '39', '53', '28', '26', '55', '11', '21', '38', '40', '49', '7', '44', '48', '30', '29', '10', '56', '45', '34', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,37,2,25,9,43,8,39,53,28,26,55,11,21,38,40,49,7,44,48,30,29,10,56,45,34,52,46,32') 0.0010960102081299