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

Total elapsed time: 0.38790011405945

# Query Time
(1) connect 0.000640869140625
(2) DESCRIBE `cruises` 0.001708984375
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (65885, 58792, 65898, 53015, 58793, 41360, 40596, 53020, 50527, 53022)) ORDER BY FIND_IN_SET(id, '65885,58792,65898,53015,58793,41360,40596,53020,50527,53022') 0.0010290145874023
(4) DESCRIBE `specials` 0.0023388862609863
(5) DESCRIBE `specials` 0.0021579265594482
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1258060') 0.00031399726867676
(7) DESCRIBE `ships` 0.0013871192932129
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1463))) 0.00027298927307129
(9) DESCRIBE `ships` 0.00130295753479
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1463') 0.00020599365234375
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00017285346984863
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00016903877258301
(13) DESCRIBE `itineraries` 0.00072622299194336
(14) DESCRIBE `ports` 0.00069093704223633
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00021886825561523
(16) DESCRIBE `ports` 0.00066208839416504
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00018692016601562
(18) DESCRIBE `ports` 0.00066304206848145
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00020313262939453
(20) DESCRIBE `specialsailingdates` 0.00058197975158691
(21) DESCRIBE `sailingdates` 0.00061321258544922
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413562))) 0.00022006034851074
(23) DESCRIBE `sailingdates` 0.00058603286743164
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413500))) 0.00021100044250488
(25) DESCRIBE `sailingdates` 0.00058388710021973
(26) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413501))) 0.00019598007202148
(27) DESCRIBE `sailingdates` 0.00058913230895996
(28) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413502))) 0.00023698806762695
(29) DESCRIBE `sailingdates` 0.00058412551879883
(30) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413505))) 0.00019717216491699
(31) DESCRIBE `sailingdates` 0.00059604644775391
(32) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413506))) 0.00019192695617676
(33) DESCRIBE `sailingdates` 0.00063204765319824
(34) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413507))) 0.00019192695617676
(35) DESCRIBE `sailingdates` 0.00063204765319824
(36) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413565))) 0.00019097328186035
(37) DESCRIBE `sailingdates` 0.00059795379638672
(38) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413566))) 0.00019192695617676
(39) DESCRIBE `sailingdates` 0.00065803527832031
(40) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413567))) 0.00019383430480957
(41) DESCRIBE `sailingdates` 0.00058984756469727
(42) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413568))) 0.00018405914306641
(43) DESCRIBE `sailingdates` 0.00059914588928223
(44) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413569))) 0.0002138614654541
(45) DESCRIBE `ports` 0.00068283081054688
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00021600723266602
(47) DESCRIBE `ports` 0.00069594383239746
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00019288063049316
(49) DESCRIBE `ports` 0.00067400932312012
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00020098686218262
(51) DESCRIBE `ports` 0.00067305564880371
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00017905235290527
(53) DESCRIBE `cruises` 0.0013298988342285
(54) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 65885))) 0.00026202201843262
(55) DESCRIBE `avid_specials` 0.00061702728271484
(56) 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.00065898895263672
(57) DESCRIBE `cruiselines` 0.00099992752075195
(58) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00024104118347168
(59) DESCRIBE `orchid_image` 0.00094890594482422
(60) DESCRIBE `cruiselines` 0.0010180473327637
(61) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.0002129077911377
(62) DESCRIBE `specials` 0.0019350051879883
(63) DESCRIBE `specials` 0.0018460750579834
(64) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1251112') 0.000244140625
(65) DESCRIBE `ships` 0.0013101100921631
(66) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1082))) 0.00028014183044434
(67) DESCRIBE `ships` 0.0013260841369629
(68) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1082') 0.00020003318786621
(69) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017905235290527
(70) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00020098686218262
(71) DESCRIBE `itineraries` 0.00071310997009277
(72) DESCRIBE `ports` 0.00068211555480957
(73) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00023889541625977
(74) DESCRIBE `ports` 0.00066709518432617
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020003318786621
(76) DESCRIBE `ports` 0.00071883201599121
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00018000602722168
(78) DESCRIBE `specialsailingdates` 0.0006110668182373
(79) DESCRIBE `sailingdates` 0.00060606002807617
(80) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393649))) 0.00032496452331543
(81) DESCRIBE `sailingdates` 0.00061202049255371
(82) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393650))) 0.00020313262939453
(83) DESCRIBE `sailingdates` 0.00059795379638672
(84) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393651))) 0.00018692016601562
(85) DESCRIBE `sailingdates` 0.00075697898864746
(86) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393652))) 0.00024986267089844
(87) DESCRIBE `sailingdates` 0.00079488754272461
(88) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393653))) 0.00020599365234375
(89) DESCRIBE `sailingdates` 0.00071620941162109
(90) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393654))) 0.00024318695068359
(91) DESCRIBE `sailingdates` 0.00070905685424805
(92) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393655))) 0.00019407272338867
(93) DESCRIBE `ports` 0.00069594383239746
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0002129077911377
(95) DESCRIBE `ports` 0.00071597099304199
(96) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00018787384033203
(97) DESCRIBE `ports` 0.00068998336791992
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.0001978874206543
(99) DESCRIBE `ports` 0.00068998336791992
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00017309188842773
(101) DESCRIBE `ports` 0.0006721019744873
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00020289421081543
(103) DESCRIBE `ports` 0.00072216987609863
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00025200843811035
(105) DESCRIBE `ports` 0.00099706649780273
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00027608871459961
(107) DESCRIBE `ports` 0.00084996223449707
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00019598007202148
(109) DESCRIBE `ports` 0.00070309638977051
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00021195411682129
(111) DESCRIBE `ports` 0.00067710876464844
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00018692016601562
(113) DESCRIBE `ports` 0.00067901611328125
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020289421081543
(115) DESCRIBE `ports` 0.00067806243896484
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00018095970153809
(117) DESCRIBE `cruises` 0.0013308525085449
(118) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 58792))) 0.00029587745666504
(119) DESCRIBE `avid_specials` 0.0006260871887207
(120) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1251112 and class = 'Special') OR (item_id = 58792 and class = 'Cruise') OR (item_id = 1082 AND class = 'Ship') OR (item_id = 38 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.0006859302520752
(121) DESCRIBE `cruiselines` 0.00096607208251953
(122) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00022006034851074
(123) DESCRIBE `orchid_image` 0.00074100494384766
(124) DESCRIBE `cruiselines` 0.00096511840820312
(125) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00018000602722168
(126) DESCRIBE `specials` 0.0022969245910645
(127) DESCRIBE `specials` 0.0020089149475098
(128) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1258062') 0.00023913383483887
(129) DESCRIBE `ships` 0.0015769004821777
(130) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1463))) 0.00031781196594238
(131) DESCRIBE `ships` 0.0012989044189453
(132) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1463') 0.00018882751464844
(133) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00018095970153809
(134) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.0001678466796875
(135) DESCRIBE `itineraries` 0.00065708160400391
(136) DESCRIBE `ports` 0.00068187713623047
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00021600723266602
(138) DESCRIBE `ports` 0.00067305564880371
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00020217895507812
(140) DESCRIBE `ports` 0.00067782402038574
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.0001828670501709
(142) DESCRIBE `specialsailingdates` 0.00057601928710938
(143) DESCRIBE `sailingdates` 0.0006251335144043
(144) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413544))) 0.00023484230041504
(145) DESCRIBE `sailingdates` 0.00059986114501953
(146) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413545))) 0.00019502639770508
(147) DESCRIBE `sailingdates` 0.00060105323791504
(148) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413546))) 0.00019478797912598
(149) DESCRIBE `sailingdates` 0.00060486793518066
(150) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413547))) 0.00019407272338867
(151) DESCRIBE `sailingdates` 0.00060200691223145
(152) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413548))) 0.00021910667419434
(153) DESCRIBE `sailingdates` 0.00060796737670898
(154) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413549))) 0.00019502639770508
(155) DESCRIBE `sailingdates` 0.00060606002807617
(156) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413550))) 0.00019383430480957
(157) DESCRIBE `sailingdates` 0.00064897537231445
(158) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413552))) 0.00020194053649902
(159) DESCRIBE `sailingdates` 0.00060391426086426
(160) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413553))) 0.00019288063049316
(161) DESCRIBE `sailingdates` 0.00059986114501953
(162) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413554))) 0.00025796890258789
(163) DESCRIBE `sailingdates` 0.00066494941711426
(164) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413555))) 0.00025296211242676
(165) DESCRIBE `sailingdates` 0.00086283683776855
(166) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413556))) 0.00020289421081543
(167) DESCRIBE `sailingdates` 0.00071191787719727
(168) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413557))) 0.00019598007202148
(169) DESCRIBE `sailingdates` 0.00060606002807617
(170) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413558))) 0.00019216537475586
(171) DESCRIBE `sailingdates` 0.00060200691223145
(172) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413559))) 0.00018692016601562
(173) DESCRIBE `ports` 0.00070786476135254
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00022602081298828
(175) DESCRIBE `ports` 0.00067901611328125
(176) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00019717216491699
(177) DESCRIBE `ports` 0.00070691108703613
(178) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1424))) 0.0002439022064209
(179) DESCRIBE `ports` 0.00068902969360352
(180) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1424') 0.00019502639770508
(181) DESCRIBE `ports` 0.00068211555480957
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 503))) 0.00020313262939453
(183) DESCRIBE `ports` 0.00072193145751953
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '503') 0.00018787384033203
(185) DESCRIBE `ports` 0.00067806243896484
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00020098686218262
(187) DESCRIBE `ports` 0.00067901611328125
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00017786026000977
(189) DESCRIBE `ports` 0.00069594383239746
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1424))) 0.00021815299987793
(191) DESCRIBE `ports` 0.00073885917663574
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1424') 0.00022196769714355
(193) DESCRIBE `ports` 0.00068402290344238
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00023818016052246
(195) DESCRIBE `ports` 0.00098609924316406
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00024104118347168
(197) DESCRIBE `cruises` 0.0019879341125488
(198) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 65898))) 0.00037789344787598
(199) DESCRIBE `avid_specials` 0.00090599060058594
(200) 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.00093698501586914
(201) DESCRIBE `cruiselines` 0.00097918510437012
(202) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00023794174194336
(203) DESCRIBE `orchid_image` 0.0007469654083252
(204) DESCRIBE `cruiselines` 0.0010559558868408
(205) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00019478797912598
(206) DESCRIBE `specials` 0.0017809867858887
(207) DESCRIBE `specials` 0.0020711421966553
(208) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1243360') 0.00029492378234863
(209) DESCRIBE `ships` 0.0014100074768066
(210) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 555))) 0.00026178359985352
(211) DESCRIBE `ships` 0.0013260841369629
(212) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '555') 0.00018501281738281
(213) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018310546875
(214) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017380714416504
(215) DESCRIBE `itineraries` 0.00066280364990234
(216) DESCRIBE `ports` 0.00073385238647461
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00021696090698242
(218) DESCRIBE `ports` 0.00068306922912598
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00020098686218262
(220) DESCRIBE `ports` 0.00066685676574707
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00018596649169922
(222) DESCRIBE `specialsailingdates` 0.00056600570678711
(223) DESCRIBE `sailingdates` 0.00061988830566406
(224) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 409754))) 0.00033783912658691
(225) DESCRIBE `sailingdates` 0.00062799453735352
(226) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 409716))) 0.00019001960754395
(227) DESCRIBE `sailingdates` 0.0005948543548584
(228) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 409717))) 0.00018787384033203
(229) DESCRIBE `sailingdates` 0.00059294700622559
(230) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 409718))) 0.00018692016601562
(231) DESCRIBE `sailingdates` 0.00060200691223145
(232) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 409719))) 0.00019598007202148
(233) DESCRIBE `sailingdates` 0.00059199333190918
(234) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 409720))) 0.00019288063049316
(235) DESCRIBE `sailingdates` 0.00059604644775391
(236) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 409721))) 0.00019407272338867
(237) DESCRIBE `sailingdates` 0.00060796737670898
(238) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 409722))) 0.00018811225891113
(239) DESCRIBE `sailingdates` 0.00063896179199219
(240) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 409725))) 0.00019407272338867
(241) DESCRIBE `sailingdates` 0.0005948543548584
(242) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 409736))) 0.00019407272338867
(243) DESCRIBE `sailingdates` 0.00060200691223145
(244) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 409747))) 0.00019383430480957
(245) DESCRIBE `sailingdates` 0.00059390068054199
(246) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 409748))) 0.00019311904907227
(247) DESCRIBE `sailingdates` 0.00062203407287598
(248) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 409749))) 0.00022196769714355
(249) DESCRIBE `sailingdates` 0.00060486793518066
(250) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 409750))) 0.00019288063049316
(251) DESCRIBE `ports` 0.00070595741271973
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00022006034851074
(253) DESCRIBE `ports` 0.00066900253295898
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00018787384033203
(255) DESCRIBE `ports` 0.00067591667175293
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00021100044250488
(257) DESCRIBE `ports` 0.00067019462585449
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00018596649169922
(259) DESCRIBE `ports` 0.0006711483001709
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2805))) 0.00020313262939453
(261) DESCRIBE `ports` 0.00066900253295898
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2805') 0.00018000602722168
(263) DESCRIBE `ports` 0.00068187713623047
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.0001981258392334
(265) DESCRIBE `ports` 0.00067996978759766
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00018310546875
(267) DESCRIBE `cruises` 0.0012660026550293
(268) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 53015))) 0.0002748966217041
(269) DESCRIBE `avid_specials` 0.00060892105102539
(270) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1243360 and class = 'Special') OR (item_id = 53015 and class = 'Cruise') OR (item_id = 555 AND class = 'Ship') OR (item_id = 38 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.00069212913513184
(271) DESCRIBE `cruiselines` 0.00094485282897949
(272) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00021886825561523
(273) DESCRIBE `orchid_image` 0.0007469654083252
(274) DESCRIBE `cruiselines` 0.00093913078308105
(275) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00018000602722168
(276) DESCRIBE `specials` 0.0017750263214111
(277) DESCRIBE `specials` 0.001708984375
(278) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1251116') 0.0002291202545166
(279) DESCRIBE `ships` 0.0012679100036621
(280) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1082))) 0.00027585029602051
(281) DESCRIBE `ships` 0.0012590885162354
(282) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1082') 0.00019311904907227
(283) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018095970153809
(284) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016903877258301
(285) DESCRIBE `itineraries` 0.00064802169799805
(286) DESCRIBE `ports` 0.00067496299743652
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.0002131462097168
(288) DESCRIBE `ports` 0.00074291229248047
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020289421081543
(290) DESCRIBE `ports` 0.00066494941711426
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00019693374633789
(292) DESCRIBE `specialsailingdates` 0.00061988830566406
(293) DESCRIBE `sailingdates` 0.00069022178649902
(294) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393659))) 0.00022411346435547
(295) DESCRIBE `sailingdates` 0.00059103965759277
(296) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393660))) 0.00019407272338867
(297) DESCRIBE `sailingdates` 0.00059390068054199
(298) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393661))) 0.00019502639770508
(299) DESCRIBE `sailingdates` 0.00059199333190918
(300) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393662))) 0.00019598007202148
(301) DESCRIBE `sailingdates` 0.00059103965759277
(302) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393663))) 0.00021195411682129
(303) DESCRIBE `sailingdates` 0.00060009956359863
(304) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393664))) 0.00020313262939453
(305) DESCRIBE `sailingdates` 0.00059199333190918
(306) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393665))) 0.00018596649169922
(307) DESCRIBE `ports` 0.00074982643127441
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020980834960938
(309) DESCRIBE `ports` 0.00067496299743652
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00018692016601562
(311) DESCRIBE `ports` 0.00067019462585449
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00021696090698242
(313) DESCRIBE `ports` 0.00067615509033203
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00020289421081543
(315) DESCRIBE `ports` 0.00097203254699707
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.0002748966217041
(317) DESCRIBE `ports` 0.00081396102905273
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.0001978874206543
(319) DESCRIBE `ports` 0.00072407722473145
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020885467529297
(321) DESCRIBE `ports` 0.00070905685424805
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00018310546875
(323) DESCRIBE `cruises` 0.0012850761413574
(324) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 58793))) 0.00030398368835449
(325) DESCRIBE `avid_specials` 0.00075197219848633
(326) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1251116 and class = 'Special') OR (item_id = 58793 and class = 'Cruise') OR (item_id = 1082 AND class = 'Ship') OR (item_id = 38 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.00093197822570801
(327) DESCRIBE `cruiselines` 0.0010130405426025
(328) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00029706954956055
(329) DESCRIBE `orchid_image` 0.001035213470459
(330) DESCRIBE `cruiselines` 0.0013480186462402
(331) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00024080276489258
(332) DESCRIBE `specials` 0.0023961067199707
(333) DESCRIBE `specials` 0.0017549991607666
(334) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1233873') 0.00025510787963867
(335) DESCRIBE `ships` 0.0012550354003906
(336) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1071))) 0.00025796890258789
(337) DESCRIBE `ships` 0.001255989074707
(338) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1071') 0.00018715858459473
(339) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0001981258392334
(340) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017118453979492
(341) DESCRIBE `itineraries` 0.00067615509033203
(342) DESCRIBE `ports` 0.00067901611328125
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.0002129077911377
(344) DESCRIBE `ports` 0.0006721019744873
(345) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00019979476928711
(346) DESCRIBE `ports` 0.0006721019744873
(347) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00017905235290527
(348) DESCRIBE `specialsailingdates` 0.00062084197998047
(349) DESCRIBE `sailingdates` 0.00064706802368164
(350) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 390302))) 0.00033402442932129
(351) DESCRIBE `sailingdates` 0.00060391426086426
(352) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 390304))) 0.0002138614654541
(353) DESCRIBE `sailingdates` 0.00060081481933594
(354) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 390305))) 0.00019383430480957
(355) DESCRIBE `sailingdates` 0.00059604644775391
(356) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 390306))) 0.00019502639770508
(357) DESCRIBE `ports` 0.00069713592529297
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00021100044250488
(359) DESCRIBE `ports` 0.00066900253295898
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00018000602722168
(361) DESCRIBE `ports` 0.00067782402038574
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.0002140998840332
(363) DESCRIBE `ports` 0.00083494186401367
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00021100044250488
(365) DESCRIBE `ports` 0.00072884559631348
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00020408630371094
(367) DESCRIBE `ports` 0.00067281723022461
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00018310546875
(369) DESCRIBE `ports` 0.00066518783569336
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4135))) 0.00020194053649902
(371) DESCRIBE `ports` 0.0006709098815918
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4135') 0.00017905235290527
(373) DESCRIBE `ports` 0.00070595741271973
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00019598007202148
(375) DESCRIBE `ports` 0.00066614151000977
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00017380714416504
(377) DESCRIBE `ports` 0.00066995620727539
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00020384788513184
(379) DESCRIBE `ports` 0.0007178783416748
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00017905235290527
(381) DESCRIBE `ports` 0.00067400932312012
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00019598007202148
(383) DESCRIBE `ports` 0.00066995620727539
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00017499923706055
(385) DESCRIBE `ports` 0.00066804885864258
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00019407272338867
(387) DESCRIBE `ports` 0.00068497657775879
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00017499923706055
(389) DESCRIBE `ports` 0.0006711483001709
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00020408630371094
(391) DESCRIBE `ports` 0.00066995620727539
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00017499923706055
(393) DESCRIBE `ports` 0.00069999694824219
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.00023007392883301
(395) DESCRIBE `ports` 0.00066685676574707
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.00018191337585449
(397) DESCRIBE `ports` 0.00066089630126953
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00023293495178223
(399) DESCRIBE `ports` 0.00066494941711426
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00018000602722168
(401) DESCRIBE `ports` 0.0006711483001709
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00019478797912598
(403) DESCRIBE `ports` 0.00067281723022461
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00017404556274414
(405) DESCRIBE `ports` 0.00066804885864258
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00020813941955566
(407) DESCRIBE `ports` 0.0006711483001709
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00017404556274414
(409) DESCRIBE `ports` 0.00066304206848145
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00025296211242676
(411) DESCRIBE `ports` 0.00091385841369629
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00021886825561523
(413) DESCRIBE `ports` 0.00094294548034668
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00024199485778809
(415) DESCRIBE `ports` 0.0010478496551514
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00023913383483887
(417) DESCRIBE `ports` 0.0010159015655518
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00026583671569824
(419) DESCRIBE `ports` 0.00099277496337891
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00023484230041504
(421) DESCRIBE `cruises` 0.0019481182098389
(422) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 41360))) 0.00046300888061523
(423) DESCRIBE `avid_specials` 0.00091981887817383
(424) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1233873 and class = 'Special') OR (item_id = 41360 and class = 'Cruise') OR (item_id = 1071 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 54 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010371208190918
(425) DESCRIBE `cruiselines` 0.0014939308166504
(426) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00031590461730957
(427) DESCRIBE `orchid_image` 0.0010759830474854
(428) DESCRIBE `cruiselines` 0.0014770030975342
(429) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00027704238891602
(430) DESCRIBE `specials` 0.0027620792388916
(431) DESCRIBE `specials` 0.0028109550476074
(432) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1259079') 0.00038886070251465
(433) DESCRIBE `ships` 0.0018959045410156
(434) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1032))) 0.00036215782165527
(435) DESCRIBE `ships` 0.0018961429595947
(436) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1032') 0.0002439022064209
(437) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00021886825561523
(438) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00020503997802734
(439) DESCRIBE `itineraries` 0.00092387199401855
(440) DESCRIBE `ports` 0.0011019706726074
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00032210350036621
(442) DESCRIBE `ports` 0.00096797943115234
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00028085708618164
(444) DESCRIBE `ports` 0.001039981842041
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00027918815612793
(446) DESCRIBE `specialsailingdates` 0.00089907646179199
(447) DESCRIBE `sailingdates` 0.00090193748474121
(448) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383635))) 0.00044894218444824
(449) DESCRIBE `sailingdates` 0.00087404251098633
(450) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383636))) 0.00026893615722656
(451) DESCRIBE `sailingdates` 0.00092506408691406
(452) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383637))) 0.00024580955505371
(453) DESCRIBE `sailingdates` 0.00082111358642578
(454) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383638))) 0.00025510787963867
(455) DESCRIBE `sailingdates` 0.0008080005645752
(456) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383639))) 0.00023794174194336
(457) DESCRIBE `sailingdates` 0.00084996223449707
(458) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383640))) 0.00026583671569824
(459) DESCRIBE `sailingdates` 0.00094795227050781
(460) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383641))) 0.00027608871459961
(461) DESCRIBE `sailingdates` 0.00091290473937988
(462) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383642))) 0.00025296211242676
(463) DESCRIBE `sailingdates` 0.00089287757873535
(464) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383643))) 0.00036191940307617
(465) DESCRIBE `sailingdates` 0.00076413154602051
(466) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383644))) 0.00019097328186035
(467) DESCRIBE `sailingdates` 0.00061392784118652
(468) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383645))) 0.00019478797912598
(469) DESCRIBE `ports` 0.00072097778320312
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00022411346435547
(471) DESCRIBE `ports` 0.00067305564880371
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00019383430480957
(473) DESCRIBE `ports` 0.00068807601928711
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.0002131462097168
(475) DESCRIBE `ports` 0.0006711483001709
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00030899047851562
(477) DESCRIBE `ports` 0.00069189071655273
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00020384788513184
(479) DESCRIBE `ports` 0.00067996978759766
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00018715858459473
(481) DESCRIBE `ports` 0.00074505805969238
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00020194053649902
(483) DESCRIBE `ports` 0.00066781044006348
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00017881393432617
(485) DESCRIBE `ports` 0.00066900253295898
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00020194053649902
(487) DESCRIBE `ports` 0.00066900253295898
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00018095970153809
(489) DESCRIBE `ports` 0.00069808959960938
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00020790100097656
(491) DESCRIBE `ports` 0.0008399486541748
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00018692016601562
(493) DESCRIBE `ports` 0.00066804885864258
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00022792816162109
(495) DESCRIBE `ports` 0.00069499015808105
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00018000602722168
(497) DESCRIBE `ports` 0.00066995620727539
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00020194053649902
(499) DESCRIBE `ports` 0.0006871223449707
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00020313262939453
(501) DESCRIBE `cruises` 0.0012669563293457
(502) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 40596))) 0.00032305717468262
(503) DESCRIBE `avid_specials` 0.00061988830566406
(504) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1259079 and class = 'Special') OR (item_id = 40596 and class = 'Cruise') OR (item_id = 1032 AND class = 'Ship') OR (item_id = 191 AND class = 'CruiseLine') OR (item_id = 55 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00066995620727539
(505) DESCRIBE `cruiselines` 0.00096511840820312
(506) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00026607513427734
(507) DESCRIBE `orchid_image` 0.00078892707824707
(508) DESCRIBE `cruiselines` 0.0009768009185791
(509) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00021004676818848
(510) DESCRIBE `specials` 0.0018408298492432
(511) DESCRIBE `specials` 0.0018229484558105
(512) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1251110') 0.0002439022064209
(513) DESCRIBE `ships` 0.0012738704681396
(514) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1082))) 0.00026297569274902
(515) DESCRIBE `ships` 0.0012691020965576
(516) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1082') 0.00019288063049316
(517) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018596649169922
(518) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00020289421081543
(519) DESCRIBE `itineraries` 0.00067400932312012
(520) DESCRIBE `ports` 0.00068998336791992
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00021600723266602
(522) DESCRIBE `ports` 0.00071191787719727
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020909309387207
(524) DESCRIBE `ports` 0.00074195861816406
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00019192695617676
(526) DESCRIBE `specialsailingdates` 0.00057482719421387
(527) DESCRIBE `sailingdates` 0.00062298774719238
(528) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393627))) 0.00022196769714355
(529) DESCRIBE `sailingdates` 0.00060415267944336
(530) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393628))) 0.00019383430480957
(531) DESCRIBE `sailingdates` 0.00062108039855957
(532) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393629))) 0.00019693374633789
(533) DESCRIBE `sailingdates` 0.00061798095703125
(534) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393630))) 0.00019407272338867
(535) DESCRIBE `sailingdates` 0.00060486793518066
(536) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393631))) 0.00018596649169922
(537) DESCRIBE `sailingdates` 0.00063896179199219
(538) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393632))) 0.00019407272338867
(539) DESCRIBE `sailingdates` 0.00059604644775391
(540) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393633))) 0.00025701522827148
(541) DESCRIBE `sailingdates` 0.00059700012207031
(542) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393634))) 0.00018715858459473
(543) DESCRIBE `ports` 0.00069808959960938
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020098686218262
(545) DESCRIBE `ports` 0.00066804885864258
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00019001960754395
(547) DESCRIBE `ports` 0.00071001052856445
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00020194053649902
(549) DESCRIBE `ports` 0.00067901611328125
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00017595291137695
(551) DESCRIBE `ports` 0.00066614151000977
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 178))) 0.0001990795135498
(553) DESCRIBE `ports` 0.00069403648376465
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '178') 0.00018501281738281
(555) DESCRIBE `ports` 0.00068998336791992
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020098686218262
(557) DESCRIBE `ports` 0.00068902969360352
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00017905235290527
(559) DESCRIBE `ports` 0.00074505805969238
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2752))) 0.00021886825561523
(561) DESCRIBE `ports` 0.00078105926513672
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2752') 0.00019216537475586
(563) DESCRIBE `ports` 0.00074887275695801
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00022101402282715
(565) DESCRIBE `ports` 0.00070500373840332
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00017905235290527
(567) DESCRIBE `cruises` 0.0013129711151123
(568) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 53020))) 0.0003058910369873
(569) DESCRIBE `avid_specials` 0.00062084197998047
(570) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1251110 and class = 'Special') OR (item_id = 53020 and class = 'Cruise') OR (item_id = 1082 AND class = 'Ship') OR (item_id = 38 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.00067901611328125
(571) DESCRIBE `cruiselines` 0.00093889236450195
(572) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00023102760314941
(573) DESCRIBE `orchid_image` 0.00075602531433105
(574) DESCRIBE `cruiselines` 0.00095295906066895
(575) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.0001828670501709
(576) DESCRIBE `specials` 0.001788854598999
(577) DESCRIBE `specials` 0.0017268657684326
(578) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1243359') 0.00022196769714355
(579) DESCRIBE `ships` 0.0013260841369629
(580) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 555))) 0.00026607513427734
(581) DESCRIBE `ships` 0.0013270378112793
(582) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '555') 0.00020599365234375
(583) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018405914306641
(584) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00017213821411133
(585) DESCRIBE `itineraries` 0.00064897537231445
(586) DESCRIBE `ports` 0.00070095062255859
(587) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00020599365234375
(588) DESCRIBE `ports` 0.00069212913513184
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00019693374633789
(590) DESCRIBE `ports` 0.0006718635559082
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.0001838207244873
(592) DESCRIBE `specialsailingdates` 0.00056815147399902
(593) DESCRIBE `sailingdates` 0.00062394142150879
(594) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 409697))) 0.00020599365234375
(595) DESCRIBE `ports` 0.00068187713623047
(596) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00020599365234375
(597) DESCRIBE `ports` 0.00073599815368652
(598) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00018405914306641
(599) DESCRIBE `ports` 0.00067901611328125
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2805))) 0.00020408630371094
(601) DESCRIBE `ports` 0.00069117546081543
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2805') 0.00017905235290527
(603) DESCRIBE `ports` 0.00068998336791992
(604) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00020289421081543
(605) DESCRIBE `ports` 0.0006868839263916
(606) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00018119812011719
(607) DESCRIBE `ports` 0.00076889991760254
(608) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00020790100097656
(609) DESCRIBE `ports` 0.00070595741271973
(610) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00018000602722168
(611) DESCRIBE `cruises` 0.0013439655303955
(612) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 50527))) 0.00028800964355469
(613) DESCRIBE `avid_specials` 0.0007779598236084
(614) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1243359 and class = 'Special') OR (item_id = 50527 and class = 'Cruise') OR (item_id = 555 AND class = 'Ship') OR (item_id = 38 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.00071310997009277
(615) DESCRIBE `cruiselines` 0.0010001659393311
(616) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00022196769714355
(617) DESCRIBE `orchid_image` 0.00075197219848633
(618) DESCRIBE `cruiselines` 0.00098514556884766
(619) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00018882751464844
(620) DESCRIBE `specials` 0.0018930435180664
(621) DESCRIBE `specials` 0.0017850399017334
(622) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1251114') 0.00021505355834961
(623) DESCRIBE `ships` 0.0012860298156738
(624) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1082))) 0.00025606155395508
(625) DESCRIBE `ships` 0.0013589859008789
(626) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1082') 0.00019001960754395
(627) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00018095970153809
(628) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00016880035400391
(629) DESCRIBE `itineraries` 0.00066304206848145
(630) DESCRIBE `ports` 0.00070500373840332
(631) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00021195411682129
(632) DESCRIBE `ports` 0.00067782402038574
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020289421081543
(634) DESCRIBE `ports` 0.00071811676025391
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00020289421081543
(636) DESCRIBE `specialsailingdates` 0.00058102607727051
(637) DESCRIBE `sailingdates` 0.00062203407287598
(638) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393639))) 0.00021505355834961
(639) DESCRIBE `sailingdates` 0.00061511993408203
(640) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393640))) 0.00019502639770508
(641) DESCRIBE `sailingdates` 0.00085687637329102
(642) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393641))) 0.00024700164794922
(643) DESCRIBE `sailingdates` 0.00084805488586426
(644) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393642))) 0.00023603439331055
(645) DESCRIBE `sailingdates` 0.00084710121154785
(646) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393643))) 0.0002748966217041
(647) DESCRIBE `sailingdates` 0.00063800811767578
(648) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393644))) 0.00020313262939453
(649) DESCRIBE `sailingdates` 0.0006098747253418
(650) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393645))) 0.0001990795135498
(651) DESCRIBE `sailingdates` 0.00062894821166992
(652) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393646))) 0.00019288063049316
(653) DESCRIBE `ports` 0.0007479190826416
(654) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00021910667419434
(655) DESCRIBE `ports` 0.0007021427154541
(656) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00019502639770508
(657) DESCRIBE `ports` 0.00068807601928711
(658) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00021910667419434
(659) DESCRIBE `ports` 0.00070500373840332
(660) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00018405914306641
(661) DESCRIBE `ports` 0.00069189071655273
(662) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 178))) 0.00020503997802734
(663) DESCRIBE `ports` 0.00069808959960938
(664) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '178') 0.00018095970153809
(665) DESCRIBE `ports` 0.00067806243896484
(666) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00020194053649902
(667) DESCRIBE `ports` 0.00067901611328125
(668) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00018596649169922
(669) DESCRIBE `cruises` 0.0013689994812012
(670) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 53022))) 0.0002751350402832
(671) DESCRIBE `avid_specials` 0.00064706802368164
(672) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1251114 and class = 'Special') OR (item_id = 53022 and class = 'Cruise') OR (item_id = 1082 AND class = 'Ship') OR (item_id = 38 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.001039981842041
(673) DESCRIBE `cruiselines` 0.0014209747314453
(674) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00029420852661133
(675) DESCRIBE `orchid_image` 0.0010941028594971
(676) DESCRIBE `cruiselines` 0.0014300346374512
(677) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00018692016601562
(678) DESCRIBE `cruiselines` 0.0010089874267578
(679) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('144', '38', '141', '91', '101', '264', '23', '191', '82', '47', '33', '114', '147', '57', '26', '77', '37', '96', '151', '24', '29', '8', '15', '19')) ORDER BY FIND_IN_SET(id, '144,38,141,91,101,264,23,191,82,47,33,114,147,57,26,77,37,96,151,24,29,8,15,19') 0.00095176696777344
(680) DESCRIBE `ships` 0.0014491081237793
(681) SELECT `ships`.* FROM `ships` WHERE (id IN ('555', '1068', '1063', '1064', '1082', '1463', '743', '1035', '1206', '1232', '821', '1071', '1032', '1338', '517', '1049', '1045', '1055', '709', '1040', '1060', '650', '1047', '1053', '1266', '1036', '1262', '1468', '1483', '225', '394', '1052', '850', '1043', '1051', '1319', '1048', '1293', '508', '643', '1044', '1318', '105', '966', '1021', '1038', '1054', '1154', '1465', '616', '786', '973', '1028', '1050', '1062', '1108', '1135', '1139', '1286', '253', '291', '338', '451', '580', '45', '98', '115', '124', '262', '287', '299', '348', '406', '434', '542', '553', '560', '585', '678', '751', '765', '888', '972', '1042', '1073', '1089', '1090', '1138', '1189', '1205', '1223', '1237', '1285', '1321', '1330', '1355', '1371', '1398', '1402', '1409', '1452', '1455')) ORDER BY FIND_IN_SET(id, '555,1068,1063,1064,1082,1463,743,1035,1206,1232,821,1071,1032,1338,517,1049,1045,1055,709,1040,1060,650,1047,1053,1266,1036,1262,1468,1483,225,394,1052,850,1043,1051,1319,1048,1293,508,643,1044,1318,105,966,1021,1038,1054,1154,1465,616,786,973,1028,1050,1062,1108,1135,1139,1286,253,291,338,451,580,45,98,115,124,262,287,299,348,406,434,542,553,560,585,678,751,765,888,972,1042,1073,1089,1090,1138,1189,1205,1223,1237,1285,1321,1330,1355,1371,1398,1402,1409,1452,1455') 0.0035979747772217
(682) DESCRIBE `cruisetypes` 0.00095200538635254
(683) DESCRIBE `destinations` 0.000946044921875
(684) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '35', '22', '43', '54', '55', '2', '49', '40', '8', '26', '38', '25', '28', '11', '12', '21', '30', '34', '37', '45', '48', '53')) ORDER BY FIND_IN_SET(id, '50,35,22,43,54,55,2,49,40,8,26,38,25,28,11,12,21,30,34,37,45,48,53') 0.00087094306945801