or, enquire about your chosen options

  1. Ovation of the Seas coming to Australia & New Zealand
  2. Heritage Expeditions: Secrets of Melanesia Cruise
  3. Vietnam Cruise a ‘must do’
  4. Explorer of the Seas to visit New Zealand
  5. Panama Canal – Norwegian Star

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

Total elapsed time: 0.39364433288574

# Query Time
(1) connect 0.0006258487701416
(2) DESCRIBE `cruises` 0.0019419193267822
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (65898, 58701, 41031, 52039, 57777, 40900, 65885, 41320, 41316, 41030)) ORDER BY FIND_IN_SET(id, '65898,58701,41031,52039,57777,40900,65885,41320,41316,41030') 0.0012540817260742
(4) DESCRIBE `specials` 0.0027949810028076
(5) DESCRIBE `specials` 0.0028820037841797
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1258062') 0.0003659725189209
(7) DESCRIBE `ships` 0.0017139911651611
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1463))) 0.00033092498779297
(9) DESCRIBE `ships` 0.0015320777893066
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1463') 0.00022506713867188
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00017690658569336
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00016498565673828
(13) DESCRIBE `itineraries` 0.00095009803771973
(14) DESCRIBE `ports` 0.00095605850219727
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00025701522827148
(16) DESCRIBE `ports` 0.00077986717224121
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00019311904907227
(18) DESCRIBE `ports` 0.00062203407287598
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00019311904907227
(20) DESCRIBE `specialsailingdates` 0.00058197975158691
(21) DESCRIBE `sailingdates` 0.0005490779876709
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413559))) 0.00036287307739258
(23) DESCRIBE `ports` 0.00082612037658691
(24) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00026202201843262
(25) DESCRIBE `ports` 0.00074505805969238
(26) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00020194053649902
(27) DESCRIBE `ports` 0.00062990188598633
(28) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1424))) 0.00020408630371094
(29) DESCRIBE `ports` 0.00061702728271484
(30) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1424') 0.00017499923706055
(31) DESCRIBE `ports` 0.00062108039855957
(32) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 503))) 0.0001990795135498
(33) DESCRIBE `ports` 0.00071215629577637
(34) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '503') 0.00016283988952637
(35) DESCRIBE `ports` 0.00058794021606445
(36) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00017595291137695
(37) DESCRIBE `ports` 0.00059080123901367
(38) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00016212463378906
(39) DESCRIBE `ports` 0.00060391426086426
(40) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1424))) 0.00021791458129883
(41) DESCRIBE `ports` 0.00060796737670898
(42) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1424') 0.00018501281738281
(43) DESCRIBE `ports` 0.00068187713623047
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00020480155944824
(45) DESCRIBE `ports` 0.00091695785522461
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00021886825561523
(47) DESCRIBE `cruises` 0.0012519359588623
(48) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 65898))) 0.00029301643371582
(49) DESCRIBE `avid_specials` 0.00062990188598633
(50) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1258062 and class = 'Special') OR (item_id = 65898 and class = 'Cruise') OR (item_id = 1463 AND class = 'Ship') OR (item_id = 264 AND class = 'CruiseLine') OR (item_id = 35 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.00081515312194824
(51) DESCRIBE `cruiselines` 0.00092482566833496
(52) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.0002448558807373
(53) DESCRIBE `orchid_image` 0.00075316429138184
(54) DESCRIBE `cruiselines` 0.00089192390441895
(55) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00019097328186035
(56) DESCRIBE `specials` 0.0019512176513672
(57) DESCRIBE `specials` 0.0017948150634766
(58) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1276047') 0.00030803680419922
(59) DESCRIBE `ships` 0.0012078285217285
(60) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 111))) 0.0002601146697998
(61) DESCRIBE `ships` 0.0011899471282959
(62) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '111') 0.00017905235290527
(63) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00016093254089355
(64) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '6') 0.00014901161193848
(65) DESCRIBE `itineraries` 0.00074291229248047
(66) DESCRIBE `ports` 0.00065994262695312
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00021195411682129
(68) DESCRIBE `ports` 0.00059795379638672
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00018787384033203
(70) DESCRIBE `ports` 0.00067806243896484
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00022196769714355
(72) DESCRIBE `specialsailingdates` 0.00054597854614258
(73) DESCRIBE `sailingdates` 0.00057196617126465
(74) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 369364))) 0.00022482872009277
(75) DESCRIBE `ports` 0.00068497657775879
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00020098686218262
(77) DESCRIBE `ports` 0.00076198577880859
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00018310546875
(79) DESCRIBE `ports` 0.00064182281494141
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 410))) 0.00019502639770508
(81) DESCRIBE `ports` 0.00062894821166992
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '410') 0.0001680850982666
(83) DESCRIBE `ports` 0.0006558895111084
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1084))) 0.00020503997802734
(85) DESCRIBE `ports` 0.00061202049255371
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1084') 0.00016617774963379
(87) DESCRIBE `ports` 0.00060892105102539
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 307))) 0.00021004676818848
(89) DESCRIBE `ports` 0.00063085556030273
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '307') 0.00020289421081543
(91) DESCRIBE `ports` 0.00081110000610352
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1805))) 0.00023412704467773
(93) DESCRIBE `ports` 0.00080299377441406
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1805') 0.00020098686218262
(95) DESCRIBE `ports` 0.00074481964111328
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00019598007202148
(97) DESCRIBE `ports` 0.00060200691223145
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00017189979553223
(99) DESCRIBE `ports` 0.00073599815368652
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00018501281738281
(101) DESCRIBE `ports` 0.0006411075592041
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00018906593322754
(103) DESCRIBE `ports` 0.00062394142150879
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00018501281738281
(105) DESCRIBE `ports` 0.00077700614929199
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00021600723266602
(107) DESCRIBE `cruises` 0.0016758441925049
(108) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 58701))) 0.00032210350036621
(109) DESCRIBE `avid_specials` 0.00060892105102539
(110) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1276047 and class = 'Special') OR (item_id = 58701 and class = 'Cruise') OR (item_id = 111 AND class = 'Ship') OR (item_id = 24 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.00081992149353027
(111) DESCRIBE `cruiselines` 0.0010130405426025
(112) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 24))) 0.00021195411682129
(113) DESCRIBE `orchid_image` 0.00068497657775879
(114) DESCRIBE `cruiselines` 0.00089192390441895
(115) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '24') 0.00018310546875
(116) DESCRIBE `specials` 0.0018939971923828
(117) DESCRIBE `specials` 0.0029568672180176
(118) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1225970') 0.00039219856262207
(119) DESCRIBE `ships` 0.0017979145050049
(120) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1063))) 0.00031709671020508
(121) DESCRIBE `ships` 0.0012328624725342
(122) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1063') 0.00018882751464844
(123) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015997886657715
(124) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014805793762207
(125) DESCRIBE `itineraries` 0.00059914588928223
(126) DESCRIBE `ports` 0.00061297416687012
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00026106834411621
(128) DESCRIBE `ports` 0.00065016746520996
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00017499923706055
(130) DESCRIBE `ports` 0.00060296058654785
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00016498565673828
(132) DESCRIBE `specialsailingdates` 0.0005500316619873
(133) DESCRIBE `sailingdates` 0.00059199333190918
(134) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395460))) 0.00032401084899902
(135) DESCRIBE `sailingdates` 0.00057101249694824
(136) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396692))) 0.00017499923706055
(137) DESCRIBE `sailingdates` 0.00062298774719238
(138) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396693))) 0.00017595291137695
(139) DESCRIBE `sailingdates` 0.00076508522033691
(140) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396694))) 0.00020289421081543
(141) DESCRIBE `sailingdates` 0.0006110668182373
(142) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396695))) 0.00016999244689941
(143) DESCRIBE `sailingdates` 0.00064682960510254
(144) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396696))) 0.00019192695617676
(145) DESCRIBE `sailingdates` 0.00056791305541992
(146) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396697))) 0.00021505355834961
(147) DESCRIBE `ports` 0.00065517425537109
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020599365234375
(149) DESCRIBE `ports` 0.0006248950958252
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017499923706055
(151) DESCRIBE `ports` 0.00069904327392578
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00018191337585449
(153) DESCRIBE `ports` 0.00059700012207031
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00016593933105469
(155) DESCRIBE `ports` 0.00063395500183105
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00022387504577637
(157) DESCRIBE `ports` 0.00090503692626953
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00021505355834961
(159) DESCRIBE `ports` 0.00088286399841309
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3209))) 0.00024700164794922
(161) DESCRIBE `ports` 0.00083589553833008
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3209') 0.00021481513977051
(163) DESCRIBE `ports` 0.0008389949798584
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00024819374084473
(165) DESCRIBE `ports` 0.00082588195800781
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00020503997802734
(167) DESCRIBE `ports` 0.00083398818969727
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0002288818359375
(169) DESCRIBE `ports` 0.000823974609375
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00021100044250488
(171) DESCRIBE `cruises` 0.0016369819641113
(172) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 41031))) 0.00034594535827637
(173) DESCRIBE `avid_specials` 0.0007941722869873
(174) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1225970 and class = 'Special') OR (item_id = 41031 and class = 'Cruise') OR (item_id = 1063 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.0013320446014404
(175) DESCRIBE `cruiselines` 0.0014019012451172
(176) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00031495094299316
(177) DESCRIBE `orchid_image` 0.00081300735473633
(178) DESCRIBE `cruiselines` 0.0010499954223633
(179) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.0002439022064209
(180) DESCRIBE `specials` 0.0020589828491211
(181) DESCRIBE `specials` 0.0025880336761475
(182) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1230127') 0.00033092498779297
(183) DESCRIBE `ships` 0.0019400119781494
(184) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1206))) 0.00035905838012695
(185) DESCRIBE `ships` 0.0012950897216797
(186) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1206') 0.00017905235290527
(187) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016999244689941
(188) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016903877258301
(189) DESCRIBE `itineraries` 0.00068998336791992
(190) DESCRIBE `ports` 0.00071191787719727
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00022196769714355
(192) DESCRIBE `ports` 0.00072693824768066
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00020003318786621
(194) DESCRIBE `ports` 0.00091195106506348
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00020909309387207
(196) DESCRIBE `specialsailingdates` 0.00065302848815918
(197) DESCRIBE `sailingdates` 0.00077009201049805
(198) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395792))) 0.0002291202545166
(199) DESCRIBE `sailingdates` 0.00066113471984863
(200) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395793))) 0.00019407272338867
(201) DESCRIBE `ports` 0.00071096420288086
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00020217895507812
(203) DESCRIBE `ports` 0.00070714950561523
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00019097328186035
(205) DESCRIBE `ports` 0.00069189071655273
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00023698806762695
(207) DESCRIBE `ports` 0.00062704086303711
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.0001678466796875
(209) DESCRIBE `ports` 0.0007469654083252
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2004))) 0.00027799606323242
(211) DESCRIBE `ports` 0.0010309219360352
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2004') 0.0002291202545166
(213) DESCRIBE `ports` 0.00074100494384766
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00027799606323242
(215) DESCRIBE `ports` 0.0009610652923584
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00022196769714355
(217) DESCRIBE `ports` 0.00083303451538086
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1599))) 0.00025200843811035
(219) DESCRIBE `ports` 0.00093507766723633
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1599') 0.00020909309387207
(221) DESCRIBE `ports` 0.00076699256896973
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00024890899658203
(223) DESCRIBE `ports` 0.00081706047058105
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.0001990795135498
(225) DESCRIBE `ports` 0.00078678131103516
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.0002589225769043
(227) DESCRIBE `ports` 0.00093317031860352
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00022697448730469
(229) DESCRIBE `ports` 0.00087404251098633
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1593))) 0.00020790100097656
(231) DESCRIBE `ports` 0.00075697898864746
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1593') 0.00021791458129883
(233) DESCRIBE `ports` 0.00079703330993652
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 993))) 0.00019001960754395
(235) DESCRIBE `ports` 0.000701904296875
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '993') 0.00016880035400391
(237) DESCRIBE `ports` 0.00066995620727539
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00024819374084473
(239) DESCRIBE `ports` 0.00084590911865234
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00021696090698242
(241) DESCRIBE `ports` 0.00089192390441895
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00019693374633789
(243) DESCRIBE `ports` 0.00064396858215332
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00018811225891113
(245) DESCRIBE `ports` 0.00065803527832031
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00018692016601562
(247) DESCRIBE `ports` 0.00064992904663086
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00016999244689941
(249) DESCRIBE `cruises` 0.0011789798736572
(250) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 52039))) 0.00032401084899902
(251) DESCRIBE `avid_specials` 0.00061893463134766
(252) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1230127 and class = 'Special') OR (item_id = 52039 and class = 'Cruise') OR (item_id = 1206 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.00088906288146973
(253) DESCRIBE `cruiselines` 0.0013248920440674
(254) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00026893615722656
(255) DESCRIBE `orchid_image` 0.00091695785522461
(256) DESCRIBE `cruiselines` 0.00094103813171387
(257) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00021910667419434
(258) DESCRIBE `specials` 0.0018801689147949
(259) DESCRIBE `specials` 0.0022928714752197
(260) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1225874') 0.00040006637573242
(261) DESCRIBE `ships` 0.001708984375
(262) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1293))) 0.00027012825012207
(263) DESCRIBE `ships` 0.0012309551239014
(264) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1293') 0.00018692016601562
(265) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015997886657715
(266) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015020370483398
(267) DESCRIBE `itineraries` 0.00063395500183105
(268) DESCRIBE `ports` 0.00077295303344727
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00022602081298828
(270) DESCRIBE `ports` 0.00065207481384277
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00018787384033203
(272) DESCRIBE `ports` 0.00069093704223633
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00023388862609863
(274) DESCRIBE `specialsailingdates` 0.0007481575012207
(275) DESCRIBE `sailingdates` 0.00082612037658691
(276) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396083))) 0.00027894973754883
(277) DESCRIBE `sailingdates` 0.00079107284545898
(278) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396094))) 0.00024008750915527
(279) DESCRIBE `ports` 0.00095701217651367
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00026702880859375
(281) DESCRIBE `ports` 0.00091791152954102
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.0002288818359375
(283) DESCRIBE `ports` 0.0009000301361084
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.0002589225769043
(285) DESCRIBE `ports` 0.00091814994812012
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00022292137145996
(287) DESCRIBE `ports` 0.00089812278747559
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2691))) 0.00024914741516113
(289) DESCRIBE `ports` 0.00092482566833496
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2691') 0.00021815299987793
(291) DESCRIBE `ports` 0.00074100494384766
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2937))) 0.00018405914306641
(293) DESCRIBE `ports` 0.00064396858215332
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2937') 0.00016212463378906
(295) DESCRIBE `ports` 0.00074601173400879
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3208))) 0.00018191337585449
(297) DESCRIBE `ports` 0.00064897537231445
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3208') 0.00021600723266602
(299) DESCRIBE `ports` 0.00094389915466309
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3207))) 0.00023794174194336
(301) DESCRIBE `ports` 0.00089216232299805
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3207') 0.00022292137145996
(303) DESCRIBE `ports` 0.00072312355041504
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2692))) 0.00020003318786621
(305) DESCRIBE `ports` 0.00062012672424316
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2692') 0.00017094612121582
(307) DESCRIBE `ports` 0.00085306167602539
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2692))) 0.00031399726867676
(309) DESCRIBE `ports` 0.00089001655578613
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2692') 0.00021195411682129
(311) DESCRIBE `ports` 0.0006561279296875
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00026392936706543
(313) DESCRIBE `ports` 0.00076198577880859
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00017499923706055
(315) DESCRIBE `ports` 0.00063610076904297
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00018811225891113
(317) DESCRIBE `ports` 0.00062394142150879
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00015878677368164
(319) DESCRIBE `cruises` 0.0013279914855957
(320) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 57777))) 0.00026297569274902
(321) DESCRIBE `avid_specials` 0.0005640983581543
(322) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1225874 and class = 'Special') OR (item_id = 57777 and class = 'Cruise') OR (item_id = 1293 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.00078392028808594
(323) DESCRIBE `cruiselines` 0.0010008811950684
(324) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00021195411682129
(325) DESCRIBE `orchid_image` 0.00075793266296387
(326) DESCRIBE `cruiselines` 0.00095510482788086
(327) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00023484230041504
(328) DESCRIBE `specials` 0.0019710063934326
(329) DESCRIBE `specials` 0.0022249221801758
(330) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1221492') 0.00029897689819336
(331) DESCRIBE `ships` 0.0012960433959961
(332) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1049))) 0.00032210350036621
(333) DESCRIBE `ships` 0.0017609596252441
(334) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1049') 0.00030303001403809
(335) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020885467529297
(336) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00019598007202148
(337) DESCRIBE `itineraries` 0.001007080078125
(338) DESCRIBE `ports` 0.0011029243469238
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00030517578125
(340) DESCRIBE `ports` 0.00092291831970215
(341) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00026893615722656
(342) DESCRIBE `ports` 0.00069093704223633
(343) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00018405914306641
(344) DESCRIBE `specialsailingdates` 0.00055694580078125
(345) DESCRIBE `sailingdates` 0.00058507919311523
(346) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396446))) 0.00025391578674316
(347) DESCRIBE `sailingdates` 0.0007939338684082
(348) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396447))) 0.00019598007202148
(349) DESCRIBE `ports` 0.00069093704223633
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00020503997802734
(351) DESCRIBE `ports` 0.00064992904663086
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00020217895507812
(353) DESCRIBE `ports` 0.00066804885864258
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.0001981258392334
(355) DESCRIBE `ports` 0.00063610076904297
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00020384788513184
(357) DESCRIBE `ports` 0.00089812278747559
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00019598007202148
(359) DESCRIBE `ports` 0.00063586235046387
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00017118453979492
(361) DESCRIBE `ports` 0.00062417984008789
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00019407272338867
(363) DESCRIBE `ports` 0.00061488151550293
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00016903877258301
(365) DESCRIBE `ports` 0.00060701370239258
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.00023603439331055
(367) DESCRIBE `ports` 0.00091409683227539
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1552') 0.00022506713867188
(369) DESCRIBE `ports` 0.0009300708770752
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3212))) 0.00026106834411621
(371) DESCRIBE `ports` 0.00089192390441895
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3212') 0.00025105476379395
(373) DESCRIBE `ports` 0.00089097023010254
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.0002589225769043
(375) DESCRIBE `ports` 0.00067996978759766
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00017905235290527
(377) DESCRIBE `cruises` 0.0013291835784912
(378) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 40900))) 0.00041604042053223
(379) DESCRIBE `avid_specials` 0.00095415115356445
(380) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1221492 and class = 'Special') OR (item_id = 40900 and class = 'Cruise') OR (item_id = 1049 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.0014610290527344
(381) DESCRIBE `cruiselines` 0.0013890266418457
(382) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00042295455932617
(383) DESCRIBE `orchid_image` 0.0012609958648682
(384) DESCRIBE `cruiselines` 0.001183032989502
(385) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00022292137145996
(386) DESCRIBE `specials` 0.0028679370880127
(387) DESCRIBE `specials` 0.0030968189239502
(388) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1258060') 0.00044393539428711
(389) DESCRIBE `ships` 0.0020768642425537
(390) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1463))) 0.00043702125549316
(391) DESCRIBE `ships` 0.0016570091247559
(392) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1463') 0.00023102760314941
(393) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00016403198242188
(394) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.0001521110534668
(395) DESCRIBE `itineraries` 0.00067400932312012
(396) DESCRIBE `ports` 0.00065398216247559
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00022006034851074
(398) DESCRIBE `ports` 0.00062799453735352
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00022196769714355
(400) DESCRIBE `ports` 0.00063109397888184
(401) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00017380714416504
(402) DESCRIBE `specialsailingdates` 0.00056219100952148
(403) DESCRIBE `sailingdates` 0.00055909156799316
(404) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413569))) 0.00023508071899414
(405) DESCRIBE `ports` 0.00066709518432617
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00020122528076172
(407) DESCRIBE `ports` 0.00064206123352051
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00022792816162109
(409) DESCRIBE `ports` 0.00093579292297363
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.0002739429473877
(411) DESCRIBE `ports` 0.00095796585083008
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00024199485778809
(413) DESCRIBE `cruises` 0.0019431114196777
(414) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 65885))) 0.00047397613525391
(415) DESCRIBE `avid_specials` 0.00089883804321289
(416) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1258060 and class = 'Special') OR (item_id = 65885 and class = 'Cruise') OR (item_id = 1463 AND class = 'Ship') OR (item_id = 264 AND class = 'CruiseLine') OR (item_id = 35 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.001392126083374
(417) DESCRIBE `cruiselines` 0.0015110969543457
(418) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00030303001403809
(419) DESCRIBE `orchid_image` 0.001086950302124
(420) DESCRIBE `cruiselines` 0.001384973526001
(421) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00027704238891602
(422) DESCRIBE `specials` 0.0029301643371582
(423) DESCRIBE `specials` 0.0030632019042969
(424) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1222011') 0.00035786628723145
(425) DESCRIBE `ships` 0.0020139217376709
(426) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1068))) 0.00041508674621582
(427) DESCRIBE `ships` 0.0019879341125488
(428) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1068') 0.00030803680419922
(429) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021696090698242
(430) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020408630371094
(431) DESCRIBE `itineraries` 0.00095391273498535
(432) DESCRIBE `ports` 0.00095510482788086
(433) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00028204917907715
(434) DESCRIBE `ports` 0.00095987319946289
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00026297569274902
(436) DESCRIBE `ports` 0.00092196464538574
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00024795532226562
(438) DESCRIBE `specialsailingdates` 0.00070023536682129
(439) DESCRIBE `sailingdates` 0.00081706047058105
(440) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396288))) 0.00027608871459961
(441) DESCRIBE `sailingdates` 0.00084304809570312
(442) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396289))) 0.00024890899658203
(443) DESCRIBE `sailingdates` 0.0007328987121582
(444) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396290))) 0.0002288818359375
(445) DESCRIBE `ports` 0.00087809562683105
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.0003199577331543
(447) DESCRIBE `ports` 0.0008389949798584
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00021910667419434
(449) DESCRIBE `ports` 0.00092816352844238
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2673))) 0.00024509429931641
(451) DESCRIBE `ports` 0.00085592269897461
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2673') 0.00023698806762695
(453) DESCRIBE `ports` 0.00084114074707031
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4086))) 0.00029206275939941
(455) DESCRIBE `ports` 0.00090599060058594
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4086') 0.00022602081298828
(457) DESCRIBE `ports` 0.0009150505065918
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4088))) 0.00024199485778809
(459) DESCRIBE `ports` 0.00089097023010254
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4088') 0.0002138614654541
(461) DESCRIBE `ports` 0.0008399486541748
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00022506713867188
(463) DESCRIBE `ports` 0.0009000301361084
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00024509429931641
(465) DESCRIBE `ports` 0.00096511840820312
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00026702880859375
(467) DESCRIBE `ports` 0.00095391273498535
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00021910667419434
(469) DESCRIBE `cruises` 0.001788854598999
(470) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 41320))) 0.00041604042053223
(471) DESCRIBE `avid_specials` 0.00094199180603027
(472) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1222011 and class = 'Special') OR (item_id = 41320 and class = 'Cruise') OR (item_id = 1068 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.0013971328735352
(473) DESCRIBE `cruiselines` 0.0012919902801514
(474) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00034785270690918
(475) DESCRIBE `orchid_image` 0.0010349750518799
(476) DESCRIBE `cruiselines` 0.0013010501861572
(477) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00029993057250977
(478) DESCRIBE `specials` 0.0028889179229736
(479) DESCRIBE `specials` 0.0030620098114014
(480) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1221835') 0.00040292739868164
(481) DESCRIBE `ships` 0.0018570423126221
(482) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1068))) 0.00037384033203125
(483) DESCRIBE `ships` 0.0019989013671875
(484) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1068') 0.00033688545227051
(485) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020408630371094
(486) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018501281738281
(487) DESCRIBE `itineraries` 0.00098013877868652
(488) DESCRIBE `ports` 0.00092911720275879
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00031590461730957
(490) DESCRIBE `ports` 0.00094103813171387
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00025606155395508
(492) DESCRIBE `ports` 0.00086402893066406
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00023579597473145
(494) DESCRIBE `specialsailingdates` 0.00079679489135742
(495) DESCRIBE `sailingdates` 0.00080513954162598
(496) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396271))) 0.00028419494628906
(497) DESCRIBE `sailingdates` 0.00075411796569824
(498) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396272))) 0.00026202201843262
(499) DESCRIBE `sailingdates` 0.00089907646179199
(500) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396273))) 0.00027894973754883
(501) DESCRIBE `ports` 0.0010027885437012
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00029492378234863
(503) DESCRIBE `ports` 0.00090312957763672
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00024604797363281
(505) DESCRIBE `ports` 0.00089287757873535
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2673))) 0.00029706954956055
(507) DESCRIBE `ports` 0.00089097023010254
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2673') 0.00024795532226562
(509) DESCRIBE `ports` 0.00093412399291992
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4086))) 0.00032806396484375
(511) DESCRIBE `ports` 0.00094079971313477
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4086') 0.00026106834411621
(513) DESCRIBE `ports` 0.00095915794372559
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4088))) 0.00028014183044434
(515) DESCRIBE `ports` 0.00090408325195312
(516) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4088') 0.00022101402282715
(517) DESCRIBE `ports` 0.00087213516235352
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00027799606323242
(519) DESCRIBE `ports` 0.00095105171203613
(520) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00024700164794922
(521) DESCRIBE `ports` 0.00090408325195312
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.0002899169921875
(523) DESCRIBE `ports` 0.00095295906066895
(524) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00023603439331055
(525) DESCRIBE `cruises` 0.0017499923706055
(526) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 41316))) 0.00036716461181641
(527) DESCRIBE `avid_specials` 0.00078797340393066
(528) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1221835 and class = 'Special') OR (item_id = 41316 and class = 'Cruise') OR (item_id = 1068 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.0013349056243896
(529) DESCRIBE `cruiselines` 0.0012538433074951
(530) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00028109550476074
(531) DESCRIBE `orchid_image` 0.0010139942169189
(532) DESCRIBE `cruiselines` 0.0012707710266113
(533) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00025296211242676
(534) DESCRIBE `specials` 0.0027370452880859
(535) DESCRIBE `specials` 0.0026650428771973
(536) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1226050') 0.0003049373626709
(537) DESCRIBE `ships` 0.0017390251159668
(538) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1063))) 0.00031495094299316
(539) DESCRIBE `ships` 0.0016469955444336
(540) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1063') 0.00018095970153809
(541) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016188621520996
(542) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014901161193848
(543) DESCRIBE `itineraries` 0.00062108039855957
(544) DESCRIBE `ports` 0.00063300132751465
(545) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021505355834961
(546) DESCRIBE `ports` 0.0008080005645752
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00022006034851074
(548) DESCRIBE `ports` 0.00080299377441406
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00021100044250488
(550) DESCRIBE `specialsailingdates` 0.00065779685974121
(551) DESCRIBE `sailingdates` 0.00056815147399902
(552) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396075))) 0.00021600723266602
(553) DESCRIBE `sailingdates` 0.00056290626525879
(554) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396076))) 0.00018215179443359
(555) DESCRIBE `ports` 0.00062108039855957
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00018596649169922
(557) DESCRIBE `ports` 0.00060486793518066
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00016999244689941
(559) DESCRIBE `ports` 0.00065302848815918
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00023317337036133
(561) DESCRIBE `ports` 0.00065803527832031
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00016188621520996
(563) DESCRIBE `ports` 0.00067496299743652
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3209))) 0.00018405914306641
(565) DESCRIBE `ports` 0.00060510635375977
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3209') 0.00016093254089355
(567) DESCRIBE `ports` 0.00082707405090332
(568) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2682))) 0.00018405914306641
(569) DESCRIBE `ports` 0.00060510635375977
(570) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2682') 0.00017595291137695
(571) DESCRIBE `ports` 0.00068092346191406
(572) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3210))) 0.00018119812011719
(573) DESCRIBE `ports` 0.00062298774719238
(574) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3210') 0.00015902519226074
(575) DESCRIBE `ports` 0.00062394142150879
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3210))) 0.00020885467529297
(577) DESCRIBE `ports` 0.00061511993408203
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3210') 0.00016188621520996
(579) DESCRIBE `ports` 0.00061607360839844
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00018596649169922
(581) DESCRIBE `ports` 0.00061988830566406
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017809867858887
(583) DESCRIBE `ports` 0.00060701370239258
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00017094612121582
(585) DESCRIBE `ports` 0.00061893463134766
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018310546875
(587) DESCRIBE `cruises` 0.0012869834899902
(588) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 41030))) 0.00027704238891602
(589) DESCRIBE `avid_specials` 0.00058102607727051
(590) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1226050 and class = 'Special') OR (item_id = 41030 and class = 'Cruise') OR (item_id = 1063 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.00080013275146484
(591) DESCRIBE `cruiselines` 0.00088286399841309
(592) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00025606155395508
(593) DESCRIBE `orchid_image` 0.00070905685424805
(594) DESCRIBE `cruiselines` 0.0008540153503418
(595) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00017309188842773
(596) DESCRIBE `cruiselines` 0.00130295753479
(597) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('144', '101', '47', '38', '91', '33', '23', '218', '147', '208', '77', '188', '263', '24', '8', '171', '14', '29', '30', '73', '20', '262', '37', '140', '191', '15', '19', '105', '212', '26', '88', '151', '264', '4', '28', '50', '269')) ORDER BY FIND_IN_SET(id, '144,101,47,38,91,33,23,218,147,208,77,188,263,24,8,171,14,29,30,73,20,262,37,140,191,15,19,105,212,26,88,151,264,4,28,50,269') 0.0016131401062012
(598) DESCRIBE `ships` 0.0015559196472168
(599) SELECT `ships`.* FROM `ships` WHERE (id IN ('517', '189', '1068', '1063', '1064', '1237', '644', '1355', '1035', '1206', '1232', '163', '973', '650', '1049', '1055', '1045', '709', '1154', '1040', '1060', '823', '1028', '1047', '1053', '1139', '1318', '988', '1036', '1319', '1468', '1483', '1052', '1108', '1224', '332', '966', '1043', '1051', '1223', '441', '786', '1026', '1048', '1071', '1292', '1293', '1456', '1492', '508', '643', '850', '888', '1044', '1321', '1457', '1579', '105', '394', '580', '972', '1038', '1054', '1266', '1303', '1465', '24', '148', '150', '151', '258', '338', '406', '407', '439', '451', '485', '704', '740', '758', '1021', '1050', '1062', '1109', '1138', '1168', '1205', '1248', '1286', '43', '45', '108', '111', '152', '223', '324', '349', '386', '448', '506', '624', '625', '683', '707', '727', '728', '768', '1032', '1149', '1326', '1463', '1526', '4', '21', '22', '66', '93', '253', '262', '287', '291', '341', '348', '434', '483', '542', '573', '582', '585', '616', '652', '669', '674', '678', '765', '785', '968', '970', '1013', '1029', '1042', '1088', '1135', '1145', '1159', '1189', '1226', '1233', '1284', '1285', '1320', '1325', '1371', '1392', '1393', '1402', '1458', '1558')) ORDER BY FIND_IN_SET(id, '517,189,1068,1063,1064,1237,644,1355,1035,1206,1232,163,973,650,1049,1055,1045,709,1154,1040,1060,823,1028,1047,1053,1139,1318,988,1036,1319,1468,1483,1052,1108,1224,332,966,1043,1051,1223,441,786,1026,1048,1071,1292,1293,1456,1492,508,643,850,888,1044,1321,1457,1579,105,394,580,972,1038,1054,1266,1303,1465,24,148,150,151,258,338,406,407,439,451,485,704,740,758,1021,1050,1062,1109,1138,1168,1205,1248,1286,43,45,108,111,152,223,324,349,386,448,506,624,625,683,707,727,728,768,1032,1149,1326,1463,1526,4,21,22,66,93,253,262,287,291,341,348,434,483,542,573,582,585,616,652,669,674,678,765,785,968,970,1013,1029,1042,1088,1135,1145,1159,1189,1226,1233,1284,1285,1320,1325,1371,1392,1393,1402,1458,1558') 0.0070269107818604
(600) DESCRIBE `cruisetypes` 0.00090289115905762
(601) DESCRIBE `destinations` 0.0011270046234131
(602) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '43', '35', '54', '22', '2', '12', '40', '37', '49', '53', '26', '8', '28', '48', '29', '38', '7', '11', '21', '39', '55', '25', '34', '45')) ORDER BY FIND_IN_SET(id, '50,43,35,54,22,2,12,40,37,49,53,26,8,28,48,29,38,7,11,21,39,55,25,34,45') 0.00085616111755371