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

Total elapsed time: 0.55455899238586

# Query Time
(1) connect 0.00077605247497559
(2) DESCRIBE `cruises` 0.0018179416656494
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (40889, 45259, 40978, 41031, 41033, 66230, 48869, 52067, 45260, 40897)) ORDER BY FIND_IN_SET(id, '40889,45259,40978,41031,41033,66230,48869,52067,45260,40897') 0.001288890838623
(4) DESCRIBE `specials` 0.0026919841766357
(5) DESCRIBE `specials` 0.002263069152832
(6) DESCRIBE `specials` 0.0030679702758789
(7) DESCRIBE `cruises` 0.0023131370544434
(8) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '40889') 0.00045204162597656
(9) DESCRIBE `specials` 0.0033910274505615
(10) DESCRIBE `ships` 0.0026021003723145
(11) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1045))) 0.00047779083251953
(12) DESCRIBE `ships` 0.0020730495452881
(13) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1045') 0.00033092498779297
(14) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022101402282715
(15) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020909309387207
(16) DESCRIBE `itineraries` 0.0010480880737305
(17) DESCRIBE `ports` 0.001162052154541
(18) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.0003209114074707
(19) DESCRIBE `ports` 0.00097417831420898
(20) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00022411346435547
(21) DESCRIBE `ports` 0.00078415870666504
(22) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00021100044250488
(23) DESCRIBE `specials` 0.0020558834075928
(24) DESCRIBE `sailingdates` 0.0007929801940918
(25) DESCRIBE `ports` 0.00072503089904785
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00027084350585938
(27) DESCRIBE `ports` 0.00070881843566895
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.00020098686218262
(29) DESCRIBE `ports` 0.00068783760070801
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.0002131462097168
(31) DESCRIBE `ports` 0.00071907043457031
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00020217895507812
(33) DESCRIBE `ports` 0.00078582763671875
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.0002131462097168
(35) DESCRIBE `ports` 0.00080013275146484
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00019097328186035
(37) DESCRIBE `ports` 0.00069189071655273
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.00024795532226562
(39) DESCRIBE `ports` 0.00071001052856445
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.00019407272338867
(41) DESCRIBE `ports` 0.00077605247497559
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00020909309387207
(43) DESCRIBE `ports` 0.00095701217651367
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00025391578674316
(45) DESCRIBE `ports` 0.0008699893951416
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00030708312988281
(47) DESCRIBE `ports` 0.0010941028594971
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00030803680419922
(49) DESCRIBE `ports` 0.0010380744934082
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 941))) 0.00025510787963867
(51) DESCRIBE `ports` 0.00072908401489258
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '941') 0.0002140998840332
(53) DESCRIBE `ports` 0.00068807601928711
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2618))) 0.0002129077911377
(55) DESCRIBE `ports` 0.00084710121154785
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2618') 0.00021910667419434
(57) DESCRIBE `ports` 0.00083589553833008
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2564))) 0.00023198127746582
(59) DESCRIBE `ports` 0.00075101852416992
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2564') 0.00026321411132812
(61) DESCRIBE `ports` 0.00072002410888672
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2096))) 0.00021696090698242
(63) DESCRIBE `ports` 0.00083804130554199
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2096') 0.00020003318786621
(65) DESCRIBE `ports` 0.00079798698425293
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2097))) 0.00023984909057617
(67) DESCRIBE `ports` 0.0010170936584473
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2097') 0.0002131462097168
(69) DESCRIBE `ports` 0.0007939338684082
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2935))) 0.00022411346435547
(71) DESCRIBE `ports` 0.00072908401489258
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2935') 0.00020122528076172
(73) DESCRIBE `ports` 0.00068807601928711
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2935))) 0.00021505355834961
(75) DESCRIBE `ports` 0.00072312355041504
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2935') 0.00018596649169922
(77) DESCRIBE `ports` 0.00076794624328613
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2617))) 0.00020694732666016
(79) DESCRIBE `ports` 0.00072097778320312
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2617') 0.00019717216491699
(81) DESCRIBE `ports` 0.00087499618530273
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 945))) 0.00032186508178711
(83) DESCRIBE `ports` 0.0010781288146973
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '945') 0.00027680397033691
(85) DESCRIBE `ports` 0.0011129379272461
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2967))) 0.0003211498260498
(87) DESCRIBE `ports` 0.0010969638824463
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2967') 0.00027179718017578
(89) DESCRIBE `ports` 0.0010900497436523
(90) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2967))) 0.00034594535827637
(91) DESCRIBE `ports` 0.0012149810791016
(92) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2967') 0.00031900405883789
(93) DESCRIBE `specials` 0.0031650066375732
(94) DESCRIBE `specials` 0.0029840469360352
(95) DESCRIBE `avid_specials` 0.00085592269897461
(96) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 40889 and class = 'Cruise') OR (item_id = 1045 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.0013229846954346
(97) DESCRIBE `cruiselines` 0.0012021064758301
(98) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00028204917907715
(99) DESCRIBE `orchid_image` 0.0012860298156738
(100) DESCRIBE `cruiselines` 0.001694917678833
(101) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00036406517028809
(102) DESCRIBE `specials` 0.0032949447631836
(103) DESCRIBE `specials` 0.0033860206604004
(104) DESCRIBE `specials` 0.003619909286499
(105) DESCRIBE `specials` 0.0035200119018555
(106) DESCRIBE `cruises` 0.0021460056304932
(107) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45259') 0.00031709671020508
(108) DESCRIBE `specials` 0.0022120475769043
(109) DESCRIBE `ships` 0.0017919540405273
(110) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00030994415283203
(111) DESCRIBE `ships` 0.002032995223999
(112) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.0002899169921875
(113) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00022006034851074
(114) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0002439022064209
(115) DESCRIBE `itineraries` 0.0010068416595459
(116) DESCRIBE `ports` 0.0009310245513916
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00032186508178711
(118) DESCRIBE `ports` 0.00070810317993164
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00019979476928711
(120) DESCRIBE `ports` 0.00077700614929199
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00024795532226562
(122) DESCRIBE `specials` 0.0021271705627441
(123) DESCRIBE `sailingdates` 0.00089693069458008
(124) DESCRIBE `ports` 0.0014288425445557
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00040602684020996
(126) DESCRIBE `ports` 0.0011289119720459
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00028300285339355
(128) DESCRIBE `ports` 0.0011050701141357
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00030303001403809
(130) DESCRIBE `ports` 0.0010678768157959
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00025820732116699
(132) DESCRIBE `ports` 0.0010879039764404
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00028514862060547
(134) DESCRIBE `ports` 0.0010979175567627
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0.00029611587524414
(136) DESCRIBE `ports` 0.0011429786682129
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00033998489379883
(138) DESCRIBE `ports` 0.001168966293335
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.0003359317779541
(140) DESCRIBE `ports` 0.0011720657348633
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00034999847412109
(142) DESCRIBE `ports` 0.0011491775512695
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00028800964355469
(144) DESCRIBE `specials` 0.0032529830932617
(145) DESCRIBE `specials` 0.0033550262451172
(146) DESCRIBE `avid_specials` 0.0010600090026855
(147) 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.0017900466918945
(148) DESCRIBE `cruiselines` 0.0016119480133057
(149) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.0003349781036377
(150) DESCRIBE `orchid_image` 0.0012378692626953
(151) DESCRIBE `cruiselines` 0.0017209053039551
(152) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00032615661621094
(153) DESCRIBE `specials` 0.003220796585083
(154) DESCRIBE `specials` 0.0033919811248779
(155) DESCRIBE `specials` 0.0033760070800781
(156) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1230476') 0.00038599967956543
(157) DESCRIBE `ships` 0.0023221969604492
(158) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1060))) 0.00043296813964844
(159) DESCRIBE `ships` 0.0022110939025879
(160) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1060') 0.00027108192443848
(161) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002291202545166
(162) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022697448730469
(163) DESCRIBE `itineraries` 0.0010709762573242
(164) DESCRIBE `ports` 0.001223087310791
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00034713745117188
(166) DESCRIBE `ports` 0.0010719299316406
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.0002899169921875
(168) DESCRIBE `ports` 0.0011019706726074
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00027894973754883
(170) DESCRIBE `specialsailingdates` 0.00088977813720703
(171) DESCRIBE `sailingdates` 0.00097298622131348
(172) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396100))) 0.00033187866210938
(173) DESCRIBE `sailingdates` 0.00095295906066895
(174) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396102))) 0.00029683113098145
(175) DESCRIBE `sailingdates` 0.00093913078308105
(176) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396103))) 0.00028204917907715
(177) DESCRIBE `sailingdates` 0.00096893310546875
(178) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396104))) 0.00029492378234863
(179) DESCRIBE `sailingdates` 0.00097298622131348
(180) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396105))) 0.00036811828613281
(181) DESCRIBE `sailingdates` 0.0010049343109131
(182) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396117))) 0.00031590461730957
(183) DESCRIBE `ports` 0.0012350082397461
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00037503242492676
(185) DESCRIBE `ports` 0.0012111663818359
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00042104721069336
(187) DESCRIBE `ports` 0.00084805488586426
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00024104118347168
(189) DESCRIBE `ports` 0.0007929801940918
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00020194053649902
(191) DESCRIBE `ports` 0.00070500373840332
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2691))) 0.00021004676818848
(193) DESCRIBE `ports` 0.00071597099304199
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2691') 0.00019693374633789
(195) DESCRIBE `ports` 0.00071811676025391
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3208))) 0.00034618377685547
(197) DESCRIBE `ports` 0.001194953918457
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3208') 0.00032997131347656
(199) DESCRIBE `ports` 0.0010969638824463
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2937))) 0.00028586387634277
(201) DESCRIBE `ports` 0.00079798698425293
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2937') 0.0002448558807373
(203) DESCRIBE `ports` 0.000823974609375
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3207))) 0.00026893615722656
(205) DESCRIBE `ports` 0.00088715553283691
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3207') 0.0002448558807373
(207) DESCRIBE `ports` 0.00074505805969238
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2692))) 0.00023579597473145
(209) DESCRIBE `ports` 0.000823974609375
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2692') 0.00019097328186035
(211) DESCRIBE `ports` 0.00077390670776367
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2692))) 0.00028109550476074
(213) DESCRIBE `ports` 0.0007319450378418
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2692') 0.00019717216491699
(215) DESCRIBE `ports` 0.00084280967712402
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2589))) 0.00024104118347168
(217) DESCRIBE `ports` 0.0007941722869873
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2589') 0.00022792816162109
(219) DESCRIBE `cruises` 0.0014219284057617
(220) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 40978))) 0.00037503242492676
(221) DESCRIBE `avid_specials` 0.00078010559082031
(222) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1230476 and class = 'Special') OR (item_id = 40978 and class = 'Cruise') OR (item_id = 1060 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.0013070106506348
(223) DESCRIBE `cruiselines` 0.0013241767883301
(224) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00027608871459961
(225) DESCRIBE `orchid_image` 0.00083589553833008
(226) DESCRIBE `cruiselines` 0.0011310577392578
(227) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00023508071899414
(228) DESCRIBE `specials` 0.0020079612731934
(229) DESCRIBE `specials` 0.002047061920166
(230) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1225954') 0.0002739429473877
(231) DESCRIBE `ships` 0.0013399124145508
(232) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1063))) 0.00031208992004395
(233) DESCRIBE `ships` 0.0015299320220947
(234) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1063') 0.00021982192993164
(235) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018191337585449
(236) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017309188842773
(237) DESCRIBE `itineraries` 0.00091099739074707
(238) DESCRIBE `ports` 0.0012550354003906
(239) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00031614303588867
(240) DESCRIBE `ports` 0.00088715553283691
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00022196769714355
(242) DESCRIBE `ports` 0.0007469654083252
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00019598007202148
(244) DESCRIBE `specialsailingdates` 0.00064492225646973
(245) DESCRIBE `sailingdates` 0.00083684921264648
(246) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396681))) 0.00041794776916504
(247) DESCRIBE `sailingdates` 0.0007469654083252
(248) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395466))) 0.00041007995605469
(249) DESCRIBE `sailingdates` 0.00067400932312012
(250) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395467))) 0.00022101402282715
(251) DESCRIBE `sailingdates` 0.00066399574279785
(252) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395468))) 0.00020098686218262
(253) DESCRIBE `sailingdates` 0.00068211555480957
(254) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396682))) 0.0002140998840332
(255) DESCRIBE `sailingdates` 0.00067901611328125
(256) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396683))) 0.00020909309387207
(257) DESCRIBE `sailingdates` 0.00067615509033203
(258) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396684))) 0.00021100044250488
(259) DESCRIBE `sailingdates` 0.00065207481384277
(260) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396685))) 0.00022792816162109
(261) DESCRIBE `sailingdates` 0.00069093704223633
(262) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395473))) 0.00020194053649902
(263) DESCRIBE `sailingdates` 0.00069403648376465
(264) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396687))) 0.00020980834960938
(265) DESCRIBE `sailingdates` 0.00088906288146973
(266) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395479))) 0.00020503997802734
(267) DESCRIBE `sailingdates` 0.00086593627929688
(268) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396688))) 0.00022602081298828
(269) DESCRIBE `sailingdates` 0.00077295303344727
(270) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396689))) 0.00023198127746582
(271) DESCRIBE `sailingdates` 0.0006411075592041
(272) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396690))) 0.0002291202545166
(273) DESCRIBE `sailingdates` 0.00078892707824707
(274) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396691))) 0.0004429817199707
(275) DESCRIBE `ports` 0.0013151168823242
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0002739429473877
(277) DESCRIBE `ports` 0.00079202651977539
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0002140998840332
(279) DESCRIBE `ports` 0.00085878372192383
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00022292137145996
(281) DESCRIBE `ports` 0.00078916549682617
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00028204917907715
(283) DESCRIBE `ports` 0.0011119842529297
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00030207633972168
(285) DESCRIBE `ports` 0.0012691020965576
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00030994415283203
(287) DESCRIBE `ports` 0.0011360645294189
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3209))) 0.00034499168395996
(289) DESCRIBE `ports` 0.001255989074707
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3209') 0.00030016899108887
(291) DESCRIBE `ports` 0.0010929107666016
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00032305717468262
(293) DESCRIBE `ports` 0.001162052154541
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027704238891602
(295) DESCRIBE `ports` 0.0011448860168457
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0003049373626709
(297) DESCRIBE `ports` 0.00079607963562012
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00029492378234863
(299) DESCRIBE `cruises` 0.0017099380493164
(300) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 41031))) 0.00033307075500488
(301) DESCRIBE `avid_specials` 0.00084018707275391
(302) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1225954 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.00097990036010742
(303) DESCRIBE `cruiselines` 0.0010530948638916
(304) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00027203559875488
(305) DESCRIBE `orchid_image` 0.00081706047058105
(306) DESCRIBE `cruiselines` 0.0010478496551514
(307) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.0002892017364502
(308) DESCRIBE `specials` 0.0022969245910645
(309) DESCRIBE `specials` 0.003058910369873
(310) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1230256') 0.00047993659973145
(311) DESCRIBE `ships` 0.0017189979553223
(312) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1035))) 0.00030303001403809
(313) DESCRIBE `ships` 0.0014970302581787
(314) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1035') 0.00022196769714355
(315) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018405914306641
(316) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017309188842773
(317) DESCRIBE `itineraries` 0.00076794624328613
(318) DESCRIBE `ports` 0.00078797340393066
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00025606155395508
(320) DESCRIBE `ports` 0.0010039806365967
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.0003058910369873
(322) DESCRIBE `ports` 0.00093889236450195
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00021505355834961
(324) DESCRIBE `specialsailingdates` 0.00060296058654785
(325) DESCRIBE `sailingdates` 0.00087094306945801
(326) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395968))) 0.00027894973754883
(327) DESCRIBE `sailingdates` 0.00084209442138672
(328) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395970))) 0.0002901554107666
(329) DESCRIBE `sailingdates` 0.00098609924316406
(330) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395971))) 0.00026893615722656
(331) DESCRIBE `sailingdates` 0.00072884559631348
(332) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395972))) 0.0002138614654541
(333) DESCRIBE `sailingdates` 0.000640869140625
(334) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395973))) 0.00024986267089844
(335) DESCRIBE `sailingdates` 0.00072503089904785
(336) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395974))) 0.00026392936706543
(337) DESCRIBE `sailingdates` 0.00095081329345703
(338) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395975))) 0.00027108192443848
(339) DESCRIBE `sailingdates` 0.0010190010070801
(340) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395976))) 0.00022792816162109
(341) DESCRIBE `sailingdates` 0.00095891952514648
(342) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395985))) 0.00026988983154297
(343) DESCRIBE `sailingdates` 0.00071096420288086
(344) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395986))) 0.00020790100097656
(345) DESCRIBE `sailingdates` 0.00063085556030273
(346) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395988))) 0.00019192695617676
(347) DESCRIBE `sailingdates` 0.00065994262695312
(348) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395989))) 0.00019598007202148
(349) DESCRIBE `ports` 0.00074601173400879
(350) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00023198127746582
(351) DESCRIBE `ports` 0.00071096420288086
(352) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00019717216491699
(353) DESCRIBE `ports` 0.00071310997009277
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00020313262939453
(355) DESCRIBE `ports` 0.000762939453125
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00018715858459473
(357) DESCRIBE `ports` 0.00073695182800293
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.0002138614654541
(359) DESCRIBE `ports` 0.00071501731872559
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.00020599365234375
(361) DESCRIBE `ports` 0.0008091926574707
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 940))) 0.00024700164794922
(363) DESCRIBE `ports` 0.00086402893066406
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '940') 0.00025296211242676
(365) DESCRIBE `ports` 0.0010170936584473
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00029802322387695
(367) DESCRIBE `ports` 0.0010628700256348
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00030016899108887
(369) DESCRIBE `ports` 0.0011870861053467
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00032806396484375
(371) DESCRIBE `ports` 0.0010559558868408
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00023078918457031
(373) DESCRIBE `ports` 0.00074100494384766
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1578))) 0.00021505355834961
(375) DESCRIBE `ports` 0.00071811676025391
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1578') 0.00019693374633789
(377) DESCRIBE `ports` 0.00070095062255859
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00021100044250488
(379) DESCRIBE `ports` 0.00072097778320312
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.0001988410949707
(381) DESCRIBE `ports` 0.00078821182250977
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00021195411682129
(383) DESCRIBE `ports` 0.00092291831970215
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00018692016601562
(385) DESCRIBE `cruises` 0.0015630722045898
(386) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 41033))) 0.0003211498260498
(387) DESCRIBE `avid_specials` 0.00066995620727539
(388) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1230256 and class = 'Special') OR (item_id = 41033 and class = 'Cruise') OR (item_id = 1035 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.00099897384643555
(389) DESCRIBE `cruiselines` 0.0010890960693359
(390) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00025391578674316
(391) DESCRIBE `orchid_image` 0.00083398818969727
(392) DESCRIBE `cruiselines` 0.0012130737304688
(393) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00021815299987793
(394) DESCRIBE `specials` 0.0022990703582764
(395) DESCRIBE `specials` 0.002025842666626
(396) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1258930') 0.00028395652770996
(397) DESCRIBE `ships` 0.0013890266418457
(398) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1035))) 0.00029277801513672
(399) DESCRIBE `ships` 0.0015060901641846
(400) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1035') 0.0002288818359375
(401) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018596649169922
(402) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00020503997802734
(403) DESCRIBE `itineraries` 0.00074315071105957
(404) DESCRIBE `ports` 0.0011351108551025
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00031614303588867
(406) DESCRIBE `ports` 0.0009911060333252
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00029397010803223
(408) DESCRIBE `ports` 0.0011050701141357
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00025296211242676
(410) DESCRIBE `specialsailingdates` 0.00094103813171387
(411) DESCRIBE `sailingdates` 0.0010170936584473
(412) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 415231))) 0.00048184394836426
(413) DESCRIBE `sailingdates` 0.00096583366394043
(414) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 415279))) 0.00028300285339355
(415) DESCRIBE `ports` 0.0011899471282959
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00032186508178711
(417) DESCRIBE `ports` 0.00082111358642578
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00021505355834961
(419) DESCRIBE `ports` 0.00090980529785156
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00024986267089844
(421) DESCRIBE `ports` 0.00086617469787598
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00021600723266602
(423) DESCRIBE `ports` 0.00085687637329102
(424) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00025391578674316
(425) DESCRIBE `ports` 0.00084900856018066
(426) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00021505355834961
(427) DESCRIBE `ports` 0.00087404251098633
(428) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.00026297569274902
(429) DESCRIBE `ports` 0.00099992752075195
(430) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.00022006034851074
(431) DESCRIBE `ports` 0.00092387199401855
(432) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 940))) 0.00025820732116699
(433) DESCRIBE `ports` 0.00080704689025879
(434) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '940') 0.00020384788513184
(435) DESCRIBE `ports` 0.0007178783416748
(436) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00021600723266602
(437) DESCRIBE `ports` 0.00076198577880859
(438) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.0001990795135498
(439) DESCRIBE `ports` 0.00072383880615234
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00021600723266602
(441) DESCRIBE `ports` 0.00081896781921387
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00021600723266602
(443) DESCRIBE `ports` 0.00085306167602539
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1578))) 0.00022101402282715
(445) DESCRIBE `ports` 0.0007178783416748
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1578') 0.00022196769714355
(447) DESCRIBE `ports` 0.00074195861816406
(448) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00023484230041504
(449) DESCRIBE `ports` 0.00091814994812012
(450) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00020194053649902
(451) DESCRIBE `ports` 0.00072503089904785
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00028896331787109
(453) DESCRIBE `ports` 0.00077390670776367
(454) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00020599365234375
(455) DESCRIBE `cruises` 0.0015969276428223
(456) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 66230))) 0.00036311149597168
(457) DESCRIBE `avid_specials` 0.00077581405639648
(458) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1258930 and class = 'Special') OR (item_id = 66230 and class = 'Cruise') OR (item_id = 1035 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.00092196464538574
(459) DESCRIBE `cruiselines` 0.0012221336364746
(460) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00030803680419922
(461) DESCRIBE `orchid_image` 0.00094509124755859
(462) DESCRIBE `cruiselines` 0.0011870861053467
(463) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00022697448730469
(464) DESCRIBE `specials` 0.0019919872283936
(465) DESCRIBE `specials` 0.002856969833374
(466) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1222203') 0.00034499168395996
(467) DESCRIBE `ships` 0.0021250247955322
(468) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1232))) 0.00040507316589355
(469) DESCRIBE `ships` 0.0022208690643311
(470) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1232') 0.00033187866210938
(471) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027322769165039
(472) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021195411682129
(473) DESCRIBE `itineraries` 0.0010888576507568
(474) DESCRIBE `ports` 0.0010731220245361
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2507))) 0.00032806396484375
(476) DESCRIBE `ports` 0.0010449886322021
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2507))) 0.00027799606323242
(478) DESCRIBE `ports` 0.0010139942169189
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2507') 0.00026702880859375
(480) DESCRIBE `specialsailingdates` 0.0008540153503418
(481) DESCRIBE `sailingdates` 0.00099086761474609
(482) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396390))) 0.00029993057250977
(483) DESCRIBE `sailingdates` 0.0006711483001709
(484) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396392))) 0.0002129077911377
(485) DESCRIBE `sailingdates` 0.00063419342041016
(486) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396393))) 0.0001990795135498
(487) DESCRIBE `sailingdates` 0.00065302848815918
(488) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396395))) 0.00020098686218262
(489) DESCRIBE `sailingdates` 0.00064301490783691
(490) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396396))) 0.00021100044250488
(491) DESCRIBE `sailingdates` 0.00070786476135254
(492) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396397))) 0.00024795532226562
(493) DESCRIBE `sailingdates` 0.0007178783416748
(494) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396398))) 0.00020003318786621
(495) DESCRIBE `sailingdates` 0.00064396858215332
(496) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396401))) 0.00020003318786621
(497) DESCRIBE `sailingdates` 0.00066089630126953
(498) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396402))) 0.00019097328186035
(499) DESCRIBE `sailingdates` 0.00063300132751465
(500) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396403))) 0.00019598007202148
(501) DESCRIBE `ports` 0.0007939338684082
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2507))) 0.00025486946105957
(503) DESCRIBE `ports` 0.00077605247497559
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2507') 0.00020289421081543
(505) DESCRIBE `ports` 0.00072503089904785
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2507))) 0.00022506713867188
(507) DESCRIBE `ports` 0.00071310997009277
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2507') 0.00019192695617676
(509) DESCRIBE `ports` 0.00071597099304199
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2410))) 0.00020813941955566
(511) DESCRIBE `ports` 0.00072216987609863
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2410') 0.00021982192993164
(513) DESCRIBE `ports` 0.00079202651977539
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4484))) 0.00022506713867188
(515) DESCRIBE `ports` 0.0007178783416748
(516) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4484') 0.00018692016601562
(517) DESCRIBE `ports` 0.00079488754272461
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4485))) 0.00021886825561523
(519) DESCRIBE `ports` 0.00071191787719727
(520) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4485') 0.00018596649169922
(521) DESCRIBE `ports` 0.00069999694824219
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4485))) 0.00020885467529297
(523) DESCRIBE `ports` 0.00075101852416992
(524) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4485') 0.00019693374633789
(525) DESCRIBE `ports` 0.00072407722473145
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4484))) 0.00021600723266602
(527) DESCRIBE `ports` 0.00075888633728027
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4484') 0.00019693374633789
(529) DESCRIBE `ports` 0.00088286399841309
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2507))) 0.00022101402282715
(531) DESCRIBE `ports` 0.00075411796569824
(532) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2507') 0.00020694732666016
(533) DESCRIBE `cruises` 0.0013649463653564
(534) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 48869))) 0.00031805038452148
(535) DESCRIBE `avid_specials` 0.00080084800720215
(536) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1222203 and class = 'Special') OR (item_id = 48869 and class = 'Cruise') OR (item_id = 1232 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.00093197822570801
(537) DESCRIBE `cruiselines` 0.0010991096496582
(538) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00025010108947754
(539) DESCRIBE `orchid_image` 0.00089097023010254
(540) DESCRIBE `cruiselines` 0.0010359287261963
(541) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00021886825561523
(542) DESCRIBE `specials` 0.0029869079589844
(543) DESCRIBE `specials` 0.0022940635681152
(544) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1236260') 0.00028896331787109
(545) DESCRIBE `ships` 0.0014231204986572
(546) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1055))) 0.00026607513427734
(547) DESCRIBE `ships` 0.0013768672943115
(548) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1055') 0.00022411346435547
(549) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00018405914306641
(550) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017499923706055
(551) DESCRIBE `itineraries` 0.00089597702026367
(552) DESCRIBE `ports` 0.00079202651977539
(553) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00024700164794922
(554) DESCRIBE `ports` 0.00070905685424805
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00020790100097656
(556) DESCRIBE `ports` 0.00080680847167969
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00021100044250488
(558) DESCRIBE `specialsailingdates` 0.0006108283996582
(559) DESCRIBE `sailingdates` 0.00066518783569336
(560) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396201))) 0.00023198127746582
(561) DESCRIBE `ports` 0.0010559558868408
(562) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00029897689819336
(563) DESCRIBE `ports` 0.00094890594482422
(564) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00027203559875488
(565) DESCRIBE `ports` 0.0010929107666016
(566) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1556))) 0.00029993057250977
(567) DESCRIBE `ports` 0.0010080337524414
(568) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1556') 0.00021004676818848
(569) DESCRIBE `ports` 0.00073695182800293
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00022983551025391
(571) DESCRIBE `ports` 0.00075984001159668
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00020098686218262
(573) DESCRIBE `ports` 0.000823974609375
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 714))) 0.00025820732116699
(575) DESCRIBE `ports` 0.00078916549682617
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '714') 0.00018620491027832
(577) DESCRIBE `ports` 0.00071287155151367
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1558))) 0.00025486946105957
(579) DESCRIBE `ports` 0.000762939453125
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1558') 0.00020909309387207
(581) DESCRIBE `ports` 0.00083303451538086
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00022006034851074
(583) DESCRIBE `ports` 0.00071501731872559
(584) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00018906593322754
(585) DESCRIBE `ports` 0.00077390670776367
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.0002140998840332
(587) DESCRIBE `ports` 0.00072598457336426
(588) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00018811225891113
(589) DESCRIBE `ports` 0.00070905685424805
(590) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.0002138614654541
(591) DESCRIBE `ports` 0.00070095062255859
(592) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00022506713867188
(593) DESCRIBE `cruises` 0.0014400482177734
(594) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 52067))) 0.00034594535827637
(595) DESCRIBE `avid_specials` 0.00079488754272461
(596) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1236260 and class = 'Special') OR (item_id = 52067 and class = 'Cruise') OR (item_id = 1055 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.00095605850219727
(597) DESCRIBE `cruiselines` 0.0010759830474854
(598) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.0002591609954834
(599) DESCRIBE `orchid_image` 0.0009009838104248
(600) DESCRIBE `cruiselines` 0.0012271404266357
(601) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00022292137145996
(602) DESCRIBE `specials` 0.00223708152771
(603) DESCRIBE `specials` 0.0019199848175049
(604) DESCRIBE `specials` 0.0021641254425049
(605) DESCRIBE `cruises` 0.0017039775848389
(606) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45260') 0.00029087066650391
(607) DESCRIBE `specials` 0.0020160675048828
(608) DESCRIBE `ships` 0.0015671253204346
(609) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00039291381835938
(610) DESCRIBE `ships` 0.0020430088043213
(611) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.00030398368835449
(612) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00023794174194336
(613) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00022697448730469
(614) DESCRIBE `itineraries` 0.00087404251098633
(615) DESCRIBE `ports` 0.00076508522033691
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00023484230041504
(617) DESCRIBE `ports` 0.00092911720275879
(618) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00023102760314941
(619) DESCRIBE `ports` 0.00073814392089844
(620) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.0002291202545166
(621) DESCRIBE `specials` 0.0022599697113037
(622) DESCRIBE `sailingdates` 0.00088310241699219
(623) DESCRIBE `ports` 0.0010080337524414
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00026893615722656
(625) DESCRIBE `ports` 0.0007328987121582
(626) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.0001990795135498
(627) DESCRIBE `ports` 0.00073695182800293
(628) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00021815299987793
(629) DESCRIBE `ports` 0.00070595741271973
(630) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00019192695617676
(631) DESCRIBE `ports` 0.00075507164001465
(632) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00022697448730469
(633) DESCRIBE `ports` 0.00075697898864746
(634) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00019001960754395
(635) DESCRIBE `ports` 0.0010030269622803
(636) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00021910667419434
(637) DESCRIBE `ports` 0.00074601173400879
(638) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00018906593322754
(639) DESCRIBE `specials` 0.002000093460083
(640) DESCRIBE `specials` 0.0022628307342529
(641) DESCRIBE `avid_specials` 0.00075292587280273
(642) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 45260 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.00098395347595215
(643) DESCRIBE `cruiselines` 0.0010910034179688
(644) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00023603439331055
(645) DESCRIBE `orchid_image` 0.00080704689025879
(646) DESCRIBE `cruiselines` 0.0010440349578857
(647) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0.00021791458129883
(648) DESCRIBE `specials` 0.0019898414611816
(649) DESCRIBE `specials` 0.0034229755401611
(650) DESCRIBE `specials` 0.003201961517334
(651) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1221723') 0.00048208236694336
(652) DESCRIBE `ships` 0.0020761489868164
(653) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1049))) 0.00036191940307617
(654) DESCRIBE `ships` 0.015475034713745
(655) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1049') 0.00034403800964355
(656) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00022697448730469
(657) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021910667419434
(658) DESCRIBE `itineraries` 0.0010640621185303
(659) DESCRIBE `ports` 0.0010280609130859
(660) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00030994415283203
(661) DESCRIBE `ports` 0.0010128021240234
(662) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00026893615722656
(663) DESCRIBE `ports` 0.0010199546813965
(664) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00024604797363281
(665) DESCRIBE `specialsailingdates` 0.00088214874267578
(666) DESCRIBE `sailingdates` 0.00067591667175293
(667) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396473))) 0.00026702880859375
(668) DESCRIBE `ports` 0.00071907043457031
(669) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00023198127746582
(670) DESCRIBE `ports` 0.00068783760070801
(671) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00019502639770508
(672) DESCRIBE `ports` 0.00082588195800781
(673) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1548))) 0.00024318695068359
(674) DESCRIBE `ports` 0.00087308883666992
(675) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1548') 0.00023794174194336
(676) DESCRIBE `ports` 0.00092601776123047
(677) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1550))) 0.00025820732116699
(678) DESCRIBE `ports` 0.00081110000610352
(679) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1550') 0.00021219253540039
(680) DESCRIBE `ports` 0.00078201293945312
(681) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00023889541625977
(682) DESCRIBE `ports` 0.00078105926513672
(683) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00022792816162109
(684) DESCRIBE `ports` 0.00097012519836426
(685) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00028204917907715
(686) DESCRIBE `ports` 0.0010190010070801
(687) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00024795532226562
(688) DESCRIBE `ports` 0.0010221004486084
(689) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.00028204917907715
(690) DESCRIBE `ports` 0.0009770393371582
(691) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1552') 0.00024890899658203
(692) DESCRIBE `ports` 0.0010039806365967
(693) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1551))) 0.00028800964355469
(694) DESCRIBE `ports` 0.00095510482788086
(695) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1551') 0.00024104118347168
(696) DESCRIBE `ports` 0.0010080337524414
(697) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.0003049373626709
(698) DESCRIBE `ports` 0.0011122226715088
(699) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.0002751350402832
(700) DESCRIBE `cruises` 0.001906156539917
(701) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 40897))) 0.00047183036804199
(702) DESCRIBE `avid_specials` 0.00099587440490723
(703) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1221723 and class = 'Special') OR (item_id = 40897 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.0016539096832275
(704) DESCRIBE `cruiselines` 0.0014479160308838
(705) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00027298927307129
(706) DESCRIBE `orchid_image` 0.0010950565338135
(707) DESCRIBE `cruiselines` 0.00097417831420898
(708) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00019598007202148
(709) DESCRIBE `cruiselines` 0.0019948482513428
(710) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('144', '47', '38', '101', '91', '23', '24', '77', '140', '147', '8', '208', '14', '29', '262', '18', '19', '218', '28', '15', '26', '37', '153', '180', '188', '33', '50', '114', '263')) ORDER BY FIND_IN_SET(id, '144,47,38,101,91,23,24,77,140,147,8,208,14,29,262,18,19,218,28,15,26,37,153,180,188,33,50,114,263') 0.0011920928955078
(711) DESCRIBE `ships` 0.0022139549255371
(712) SELECT `ships`.* FROM `ships` WHERE (id IN ('517', '189', '1068', '1063', '1064', '644', '1035', '1232', '1206', '650', '1045', '709', '1060', '1036', '1168', '1468', '1047', '1049', '1040', '1052', '1055', '1483', '332', '1043', '988', '1026', '1492', '643', '1051', '1293', '1579', '338', '394', '966', '1044', '1078', '1108', '1139', '148', '407', '451', '624', '704', '786', '850', '968', '973', '1028', '1053', '1054', '1286', '1318', '1328', '1465', '45', '75', '105', '223', '406', '508', '580', '625', '683', '711', '768', '769', '823', '1021', '1029', '1050', '1062', '1138', '1149', '1223', '1319', '1321', '1325', '1326', '66', '124', '163', '258', '287', '291', '324', '348', '349', '434', '452', '483', '542', '547', '585', '657', '678', '722', '765', '780', '785', '796', '835', '933', '977', '1038', '1135', '1145', '1154', '1188', '1189', '1224', '1226', '1233', '1256', '1302', '1330', '1371', '1402', '1458', '1464', '1587')) ORDER BY FIND_IN_SET(id, '517,189,1068,1063,1064,644,1035,1232,1206,650,1045,709,1060,1036,1168,1468,1047,1049,1040,1052,1055,1483,332,1043,988,1026,1492,643,1051,1293,1579,338,394,966,1044,1078,1108,1139,148,407,451,624,704,786,850,968,973,1028,1053,1054,1286,1318,1328,1465,45,75,105,223,406,508,580,625,683,711,768,769,823,1021,1029,1050,1062,1138,1149,1223,1319,1321,1325,1326,66,124,163,258,287,291,324,348,349,434,452,483,542,547,585,657,678,722,765,780,785,796,835,933,977,1038,1135,1145,1154,1188,1189,1224,1226,1233,1256,1302,1330,1371,1402,1458,1464,1587') 0.005662202835083
(713) DESCRIBE `cruisetypes` 0.0010619163513184
(714) DESCRIBE `destinations` 0.0015709400177002
(715) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '43', '35', '22', '12', '54', '40', '2', '53', '8', '11', '26', '29', '25', '37', '48', '21', '28', '38', '45', '49')) ORDER BY FIND_IN_SET(id, '50,43,35,22,12,54,40,2,53,8,11,26,29,25,37,48,21,28,38,45,49') 0.001176118850708