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

Total elapsed time: 0.41161060333252

# Query Time
(1) connect 0.00046396255493164
(2) DESCRIBE `cruises` 0.0020401477813721
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (41360, 41359, 58448, 65898, 44079, 65885, 41031, 41031, 44079, 58792)) ORDER BY FIND_IN_SET(id, '41360,41359,58448,65898,44079,65885,41031,41031,44079,58792') 0.0015990734100342
(4) DESCRIBE `specials` 0.0021889209747314
(5) DESCRIBE `specials` 0.0018229484558105
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1233873') 0.00031900405883789
(7) DESCRIBE `ships` 0.0014591217041016
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1071))) 0.00026392936706543
(9) DESCRIBE `ships` 0.001384973526001
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1071') 0.00020289421081543
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017595291137695
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016403198242188
(13) DESCRIBE `itineraries` 0.00068807601928711
(14) DESCRIBE `ports` 0.000946044921875
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00025296211242676
(16) DESCRIBE `ports` 0.000885009765625
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00020194053649902
(18) DESCRIBE `ports` 0.00068402290344238
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00020694732666016
(20) DESCRIBE `specialsailingdates` 0.00057888031005859
(21) DESCRIBE `sailingdates` 0.00061917304992676
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 390305))) 0.00023889541625977
(23) DESCRIBE `sailingdates` 0.00066709518432617
(24) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 390306))) 0.00019192695617676
(25) DESCRIBE `ports` 0.00069117546081543
(26) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00021195411682129
(27) DESCRIBE `ports` 0.00067806243896484
(28) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00018692016601562
(29) DESCRIBE `ports` 0.00067996978759766
(30) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00025296211242676
(31) DESCRIBE `ports` 0.00066900253295898
(32) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00017809867858887
(33) DESCRIBE `ports` 0.00065898895263672
(34) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.0001981258392334
(35) DESCRIBE `ports` 0.00065994262695312
(36) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.0002129077911377
(37) DESCRIBE `ports` 0.00074601173400879
(38) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4135))) 0.00020289421081543
(39) DESCRIBE `ports` 0.0007011890411377
(40) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4135') 0.00018692016601562
(41) DESCRIBE `ports` 0.00066304206848145
(42) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00018501281738281
(43) DESCRIBE `ports` 0.00066304206848145
(44) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00021600723266602
(45) DESCRIBE `ports` 0.00082302093505859
(46) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00027704238891602
(47) DESCRIBE `ports` 0.00096321105957031
(48) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00022506713867188
(49) DESCRIBE `ports` 0.00097894668579102
(50) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00024318695068359
(51) DESCRIBE `ports` 0.00068306922912598
(52) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00019001960754395
(53) DESCRIBE `ports` 0.00068497657775879
(54) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00018405914306641
(55) DESCRIBE `ports` 0.00072407722473145
(56) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00018000602722168
(57) DESCRIBE `ports` 0.0007021427154541
(58) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00020599365234375
(59) DESCRIBE `ports` 0.00082087516784668
(60) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00018692016601562
(61) DESCRIBE `ports` 0.00069904327392578
(62) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.00020909309387207
(63) DESCRIBE `ports` 0.00066614151000977
(64) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.00019097328186035
(65) DESCRIBE `ports` 0.00069808959960938
(66) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00020718574523926
(67) DESCRIBE `ports` 0.00074505805969238
(68) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00018787384033203
(69) DESCRIBE `ports` 0.00071096420288086
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00019311904907227
(71) DESCRIBE `ports` 0.00094699859619141
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00021505355834961
(73) DESCRIBE `ports` 0.0008699893951416
(74) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00025296211242676
(75) DESCRIBE `ports` 0.00091290473937988
(76) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00021910667419434
(77) DESCRIBE `ports` 0.00087594985961914
(78) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00026488304138184
(79) DESCRIBE `ports` 0.00087499618530273
(80) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00021600723266602
(81) DESCRIBE `ports` 0.00087594985961914
(82) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00025701522827148
(83) DESCRIBE `ports` 0.00086283683776855
(84) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00020503997802734
(85) DESCRIBE `ports` 0.00089097023010254
(86) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00020599365234375
(87) DESCRIBE `ports` 0.00071811676025391
(88) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00018310546875
(89) DESCRIBE `cruises` 0.0013539791107178
(90) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 41360))) 0.00035190582275391
(91) DESCRIBE `avid_specials` 0.00071883201599121
(92) 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.00083398818969727
(93) DESCRIBE `cruiselines` 0.0010819435119629
(94) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00027704238891602
(95) DESCRIBE `orchid_image` 0.0007939338684082
(96) DESCRIBE `cruiselines` 0.0010020732879639
(97) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00020194053649902
(98) DESCRIBE `specials` 0.0019001960754395
(99) DESCRIBE `specials` 0.0017750263214111
(100) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1233921') 0.00025391578674316
(101) DESCRIBE `ships` 0.0013248920440674
(102) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1071))) 0.00026702880859375
(103) DESCRIBE `ships` 0.0012748241424561
(104) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1071') 0.00019192695617676
(105) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017189979553223
(106) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016093254089355
(107) DESCRIBE `itineraries` 0.00067591667175293
(108) DESCRIBE `ports` 0.00069999694824219
(109) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00020480155944824
(110) DESCRIBE `ports` 0.0007319450378418
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00018906593322754
(112) DESCRIBE `ports` 0.00067710876464844
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00016999244689941
(114) DESCRIBE `specialsailingdates` 0.0005648136138916
(115) DESCRIBE `sailingdates` 0.00062799453735352
(116) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 390323))) 0.00021886825561523
(117) DESCRIBE `sailingdates` 0.00059413909912109
(118) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 390324))) 0.00018787384033203
(119) DESCRIBE `sailingdates` 0.00059294700622559
(120) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 390325))) 0.00020098686218262
(121) DESCRIBE `sailingdates` 0.00059413909912109
(122) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 390326))) 0.00019407272338867
(123) DESCRIBE `ports` 0.0006859302520752
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00020003318786621
(125) DESCRIBE `ports` 0.00079703330993652
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00020194053649902
(127) DESCRIBE `ports` 0.00067400932312012
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.0002129077911377
(129) DESCRIBE `ports` 0.00066995620727539
(130) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00017499923706055
(131) DESCRIBE `ports` 0.00071310997009277
(132) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00018692016601562
(133) DESCRIBE `ports` 0.00066804885864258
(134) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00017905235290527
(135) DESCRIBE `ports` 0.00069499015808105
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00019097328186035
(137) DESCRIBE `ports` 0.00066685676574707
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00017404556274414
(139) DESCRIBE `ports` 0.00069189071655273
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00020289421081543
(141) DESCRIBE `ports` 0.00067710876464844
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00021100044250488
(143) DESCRIBE `ports` 0.000701904296875
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.00023317337036133
(145) DESCRIBE `ports` 0.00068998336791992
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.00018596649169922
(147) DESCRIBE `ports` 0.00066614151000977
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00018811225891113
(149) DESCRIBE `ports` 0.00067901611328125
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.0001680850982666
(151) DESCRIBE `ports` 0.0007319450378418
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00018787384033203
(153) DESCRIBE `ports` 0.00075197219848633
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00017404556274414
(155) DESCRIBE `ports` 0.00066518783569336
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00018906593322754
(157) DESCRIBE `ports` 0.0006711483001709
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00018501281738281
(159) DESCRIBE `ports` 0.00070309638977051
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.0001990795135498
(161) DESCRIBE `ports` 0.0006868839263916
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00017809867858887
(163) DESCRIBE `ports` 0.00066304206848145
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4135))) 0.00019502639770508
(165) DESCRIBE `ports` 0.00067996978759766
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4135') 0.00020003318786621
(167) DESCRIBE `ports` 0.00066804885864258
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00018787384033203
(169) DESCRIBE `ports` 0.00066184997558594
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00016689300537109
(171) DESCRIBE `ports` 0.0006861686706543
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00019097328186035
(173) DESCRIBE `ports` 0.00067996978759766
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00017905235290527
(175) DESCRIBE `ports` 0.00066900253295898
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00021791458129883
(177) DESCRIBE `ports` 0.0006709098815918
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00016689300537109
(179) DESCRIBE `ports` 0.00066900253295898
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00020194053649902
(181) DESCRIBE `ports` 0.00069904327392578
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00016880035400391
(183) DESCRIBE `ports` 0.00066494941711426
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3341))) 0.00019502639770508
(185) DESCRIBE `ports` 0.00066995620727539
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3341') 0.00017499923706055
(187) DESCRIBE `cruises` 0.0014209747314453
(188) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 41359))) 0.00050616264343262
(189) DESCRIBE `avid_specials` 0.00078105926513672
(190) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1233921 and class = 'Special') OR (item_id = 41359 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.00084590911865234
(191) DESCRIBE `cruiselines` 0.00096893310546875
(192) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00025296211242676
(193) DESCRIBE `orchid_image` 0.00074887275695801
(194) DESCRIBE `cruiselines` 0.00094699859619141
(195) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00018882751464844
(196) DESCRIBE `specials` 0.0018391609191895
(197) DESCRIBE `specials` 0.0018150806427002
(198) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1274054') 0.0002291202545166
(199) DESCRIBE `ships` 0.0013020038604736
(200) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 212))) 0.00026488304138184
(201) DESCRIBE `ships` 0.0013010501861572
(202) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '212') 0.00017309188842773
(203) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0001988410949707
(204) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00016283988952637
(205) DESCRIBE `itineraries` 0.00067710876464844
(206) DESCRIBE `ports` 0.00071120262145996
(207) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00023984909057617
(208) DESCRIBE `ports` 0.00086688995361328
(209) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00020909309387207
(210) DESCRIBE `ports` 0.00071382522583008
(211) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.00019001960754395
(212) DESCRIBE `specialsailingdates` 0.00058412551879883
(213) DESCRIBE `sailingdates` 0.00063204765319824
(214) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 368596))) 0.00022602081298828
(215) DESCRIBE `ports` 0.0006861686706543
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 89))) 0.00021886825561523
(217) DESCRIBE `ports` 0.00068902969360352
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '89') 0.0001990795135498
(219) DESCRIBE `ports` 0.00066494941711426
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00019598007202148
(221) DESCRIBE `ports` 0.00068020820617676
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00017786026000977
(223) DESCRIBE `ports` 0.00071215629577637
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1150))) 0.00020599365234375
(225) DESCRIBE `ports` 0.00067806243896484
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1150') 0.00018191337585449
(227) DESCRIBE `ports` 0.00069093704223633
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1143))) 0.00020885467529297
(229) DESCRIBE `ports` 0.00069499015808105
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1143') 0.00017499923706055
(231) DESCRIBE `ports` 0.00068497657775879
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2470))) 0.00019598007202148
(233) DESCRIBE `ports` 0.00068402290344238
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2470') 0.0002131462097168
(235) DESCRIBE `ports` 0.00069093704223633
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 95))) 0.00020289421081543
(237) DESCRIBE `ports` 0.00067806243896484
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '95') 0.00017905235290527
(239) DESCRIBE `cruises` 0.0013389587402344
(240) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 58448))) 0.00027894973754883
(241) DESCRIBE `avid_specials` 0.00060915946960449
(242) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1274054 and class = 'Special') OR (item_id = 58448 and class = 'Cruise') OR (item_id = 212 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 37 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0008540153503418
(243) DESCRIBE `cruiselines` 0.00098800659179688
(244) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.0002131462097168
(245) DESCRIBE `orchid_image` 0.00075888633728027
(246) DESCRIBE `cruiselines` 0.0010168552398682
(247) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00018882751464844
(248) DESCRIBE `specials` 0.0018060207366943
(249) DESCRIBE `specials` 0.0017719268798828
(250) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1258062') 0.00022101402282715
(251) DESCRIBE `ships` 0.0012929439544678
(252) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1463))) 0.00025296211242676
(253) DESCRIBE `ships` 0.0012819766998291
(254) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1463') 0.00018095970153809
(255) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00017499923706055
(256) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00016212463378906
(257) DESCRIBE `itineraries` 0.00075006484985352
(258) DESCRIBE `ports` 0.00067901611328125
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00020790100097656
(260) DESCRIBE `ports` 0.00067901611328125
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00021100044250488
(262) DESCRIBE `ports` 0.00072288513183594
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00018095970153809
(264) DESCRIBE `specialsailingdates` 0.00056099891662598
(265) DESCRIBE `sailingdates` 0.000640869140625
(266) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413552))) 0.00021910667419434
(267) DESCRIBE `sailingdates` 0.00058913230895996
(268) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413553))) 0.00021100044250488
(269) DESCRIBE `sailingdates` 0.0006859302520752
(270) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413554))) 0.00019717216491699
(271) DESCRIBE `sailingdates` 0.00060796737670898
(272) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413555))) 0.00018811225891113
(273) DESCRIBE `sailingdates` 0.00059008598327637
(274) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413556))) 0.00018787384033203
(275) DESCRIBE `sailingdates` 0.00060701370239258
(276) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413557))) 0.0001981258392334
(277) DESCRIBE `sailingdates` 0.00061321258544922
(278) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413558))) 0.00018596649169922
(279) DESCRIBE `sailingdates` 0.00060081481933594
(280) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413559))) 0.00018596649169922
(281) DESCRIBE `ports` 0.00072216987609863
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00022315979003906
(283) DESCRIBE `ports` 0.00067400932312012
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00018596649169922
(285) DESCRIBE `ports` 0.00067305564880371
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1424))) 0.00022101402282715
(287) DESCRIBE `ports` 0.00070500373840332
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1424') 0.00021910667419434
(289) DESCRIBE `ports` 0.00090503692626953
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 503))) 0.00026607513427734
(291) DESCRIBE `ports` 0.00073099136352539
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '503') 0.00020885467529297
(293) DESCRIBE `ports` 0.00068211555480957
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.0001990795135498
(295) DESCRIBE `ports` 0.00067806243896484
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.00017309188842773
(297) DESCRIBE `ports` 0.00067806243896484
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1424))) 0.00022697448730469
(299) DESCRIBE `ports` 0.00067687034606934
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1424') 0.00019502639770508
(301) DESCRIBE `ports` 0.0006718635559082
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00020694732666016
(303) DESCRIBE `ports` 0.00070881843566895
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00017595291137695
(305) DESCRIBE `cruises` 0.0013148784637451
(306) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 65898))) 0.00028014183044434
(307) DESCRIBE `avid_specials` 0.0006098747253418
(308) 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.00081610679626465
(309) DESCRIBE `cruiselines` 0.00099897384643555
(310) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00031590461730957
(311) DESCRIBE `orchid_image` 0.001039981842041
(312) DESCRIBE `cruiselines` 0.0012478828430176
(313) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00025320053100586
(314) DESCRIBE `specials` 0.0024480819702148
(315) DESCRIBE `specials` 0.0018491744995117
(316) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1272495') 0.00027298927307129
(317) DESCRIBE `ships` 0.0013358592987061
(318) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 163))) 0.00028014183044434
(319) DESCRIBE `ships` 0.0013668537139893
(320) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '163') 0.00019192695617676
(321) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017499923706055
(322) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00016403198242188
(323) DESCRIBE `itineraries` 0.00067019462585449
(324) DESCRIBE `ports` 0.0007469654083252
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00022292137145996
(326) DESCRIBE `ports` 0.00067305564880371
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00021100044250488
(328) DESCRIBE `ports` 0.00068497657775879
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00020909309387207
(330) DESCRIBE `specialsailingdates` 0.00058412551879883
(331) DESCRIBE `sailingdates` 0.00060582160949707
(332) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 379644))) 0.00023794174194336
(333) DESCRIBE `sailingdates` 0.00058794021606445
(334) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 379646))) 0.00021100044250488
(335) DESCRIBE `ports` 0.00069499015808105
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00022602081298828
(337) DESCRIBE `ports` 0.00067901611328125
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00019407272338867
(339) DESCRIBE `ports` 0.00069403648376465
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00020003318786621
(341) DESCRIBE `ports` 0.00067496299743652
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00019097328186035
(343) DESCRIBE `ports` 0.00066900253295898
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 585))) 0.0001978874206543
(345) DESCRIBE `ports` 0.00072884559631348
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '585') 0.00019097328186035
(347) DESCRIBE `ports` 0.00066900253295898
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00019717216491699
(349) DESCRIBE `ports` 0.00070285797119141
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00021004676818848
(351) DESCRIBE `ports` 0.00070714950561523
(352) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.0002138614654541
(353) DESCRIBE `ports` 0.00069785118103027
(354) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00017404556274414
(355) DESCRIBE `ports` 0.00067996978759766
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.0001981258392334
(357) DESCRIBE `ports` 0.00066900253295898
(358) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00019097328186035
(359) DESCRIBE `ports` 0.0006718635559082
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00019598007202148
(361) DESCRIBE `ports` 0.00080990791320801
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00017309188842773
(363) DESCRIBE `ports` 0.00066208839416504
(364) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 514))) 0.00020694732666016
(365) DESCRIBE `ports` 0.00070810317993164
(366) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '514') 0.00018095970153809
(367) DESCRIBE `ports` 0.00067591667175293
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00021886825561523
(369) DESCRIBE `ports` 0.00070095062255859
(370) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00017309188842773
(371) DESCRIBE `cruises` 0.0013689994812012
(372) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 44079))) 0.00028300285339355
(373) DESCRIBE `avid_specials` 0.00070810317993164
(374) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1272495 and class = 'Special') OR (item_id = 44079 and class = 'Cruise') OR (item_id = 163 AND class = 'Ship') OR (item_id = 33 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.00085902214050293
(375) DESCRIBE `cruiselines` 0.0010130405426025
(376) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00023007392883301
(377) DESCRIBE `orchid_image` 0.00084710121154785
(378) DESCRIBE `cruiselines` 0.0010321140289307
(379) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00019097328186035
(380) DESCRIBE `specials` 0.0024240016937256
(381) DESCRIBE `specials` 0.0018889904022217
(382) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1258060') 0.00029397010803223
(383) DESCRIBE `ships` 0.0013210773468018
(384) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1463))) 0.00026798248291016
(385) DESCRIBE `ships` 0.0013360977172852
(386) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1463') 0.00018501281738281
(387) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00017619132995605
(388) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00016403198242188
(389) DESCRIBE `itineraries` 0.00067806243896484
(390) DESCRIBE `ports` 0.00068902969360352
(391) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00021004676818848
(392) DESCRIBE `ports` 0.00068092346191406
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00021004676818848
(394) DESCRIBE `ports` 0.000701904296875
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00017714500427246
(396) DESCRIBE `specialsailingdates` 0.00056695938110352
(397) DESCRIBE `sailingdates` 0.00080609321594238
(398) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413505))) 0.00022721290588379
(399) DESCRIBE `sailingdates` 0.00060892105102539
(400) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413506))) 0.00018906593322754
(401) DESCRIBE `sailingdates` 0.0006098747253418
(402) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413507))) 0.0001990795135498
(403) DESCRIBE `sailingdates` 0.00061988830566406
(404) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413565))) 0.00022196769714355
(405) DESCRIBE `sailingdates` 0.00063800811767578
(406) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413566))) 0.00020885467529297
(407) DESCRIBE `sailingdates` 0.00061702728271484
(408) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413567))) 0.00018906593322754
(409) DESCRIBE `sailingdates` 0.00060200691223145
(410) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413568))) 0.00020003318786621
(411) DESCRIBE `sailingdates` 0.0006868839263916
(412) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413569))) 0.00018191337585449
(413) DESCRIBE `ports` 0.00069785118103027
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00020599365234375
(415) DESCRIBE `ports` 0.00069284439086914
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00018811225891113
(417) DESCRIBE `ports` 0.00067400932312012
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00020289421081543
(419) DESCRIBE `ports` 0.00072598457336426
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00018119812011719
(421) DESCRIBE `cruises` 0.0012960433959961
(422) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 65885))) 0.00025200843811035
(423) DESCRIBE `avid_specials` 0.00067400932312012
(424) 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.00086784362792969
(425) DESCRIBE `cruiselines` 0.00095796585083008
(426) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00023102760314941
(427) DESCRIBE `orchid_image` 0.00075197219848633
(428) DESCRIBE `cruiselines` 0.00096797943115234
(429) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00018692016601562
(430) DESCRIBE `specials` 0.001823902130127
(431) DESCRIBE `specials` 0.0022399425506592
(432) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1225986') 0.00034499168395996
(433) DESCRIBE `ships` 0.0021560192108154
(434) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1063))) 0.0003669261932373
(435) DESCRIBE `ships` 0.002039909362793
(436) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1063') 0.00023984909057617
(437) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00023198127746582
(438) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00021100044250488
(439) DESCRIBE `itineraries` 0.00092506408691406
(440) DESCRIBE `ports` 0.00085091590881348
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00028800964355469
(442) DESCRIBE `ports` 0.00098204612731934
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00023913383483887
(444) DESCRIBE `ports` 0.00085783004760742
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0002448558807373
(446) DESCRIBE `specialsailingdates` 0.00062799453735352
(447) DESCRIBE `sailingdates` 0.00063586235046387
(448) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395453))) 0.00022697448730469
(449) DESCRIBE `ports` 0.00072407722473145
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00023007392883301
(451) DESCRIBE `ports` 0.00073504447937012
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00020694732666016
(453) DESCRIBE `ports` 0.00070309638977051
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021791458129883
(455) DESCRIBE `ports` 0.00068306922912598
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00022387504577637
(457) DESCRIBE `ports` 0.00067901611328125
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020313262939453
(459) DESCRIBE `ports` 0.00068211555480957
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018882751464844
(461) DESCRIBE `ports` 0.00067782402038574
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3209))) 0.00020098686218262
(463) DESCRIBE `ports` 0.00069403648376465
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3209') 0.00017380714416504
(465) DESCRIBE `ports` 0.0006711483001709
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00019407272338867
(467) DESCRIBE `ports` 0.00070309638977051
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018906593322754
(469) DESCRIBE `ports` 0.00067305564880371
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021100044250488
(471) DESCRIBE `ports` 0.00067591667175293
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018310546875
(473) DESCRIBE `cruises` 0.0013141632080078
(474) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 41031))) 0.00027203559875488
(475) DESCRIBE `avid_specials` 0.00071811676025391
(476) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1225986 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.00083708763122559
(477) DESCRIBE `cruiselines` 0.000946044921875
(478) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00022602081298828
(479) DESCRIBE `orchid_image` 0.00075387954711914
(480) DESCRIBE `cruiselines` 0.0010068416595459
(481) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00026297569274902
(482) DESCRIBE `specials` 0.0019378662109375
(483) DESCRIBE `specials` 0.0017910003662109
(484) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1225970') 0.00023102760314941
(485) DESCRIBE `ships` 0.001291036605835
(486) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1063))) 0.00025105476379395
(487) DESCRIBE `ships` 0.0012519359588623
(488) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1063') 0.00017404556274414
(489) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017404556274414
(490) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017309188842773
(491) DESCRIBE `itineraries` 0.00069284439086914
(492) DESCRIBE `ports` 0.00068187713623047
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020694732666016
(494) DESCRIBE `ports` 0.00071406364440918
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0002140998840332
(496) DESCRIBE `ports` 0.00069808959960938
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00019192695617676
(498) DESCRIBE `specialsailingdates` 0.00057387351989746
(499) DESCRIBE `sailingdates` 0.00070691108703613
(500) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395455))) 0.00025606155395508
(501) DESCRIBE `sailingdates` 0.0006110668182373
(502) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396671))) 0.00019693374633789
(503) DESCRIBE `sailingdates` 0.00059890747070312
(504) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396672))) 0.00019192695617676
(505) DESCRIBE `sailingdates` 0.00061488151550293
(506) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396673))) 0.00019097328186035
(507) DESCRIBE `sailingdates` 0.00061607360839844
(508) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396674))) 0.00019288063049316
(509) DESCRIBE `sailingdates` 0.00068306922912598
(510) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395460))) 0.0001990795135498
(511) DESCRIBE `sailingdates` 0.00061702728271484
(512) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396692))) 0.00019407272338867
(513) DESCRIBE `sailingdates` 0.00064206123352051
(514) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396693))) 0.00023484230041504
(515) DESCRIBE `sailingdates` 0.00063395500183105
(516) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396694))) 0.00018882751464844
(517) DESCRIBE `sailingdates` 0.00061392784118652
(518) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396695))) 0.00019311904907227
(519) DESCRIBE `sailingdates` 0.00060391426086426
(520) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396696))) 0.00019502639770508
(521) DESCRIBE `sailingdates` 0.00061702728271484
(522) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396697))) 0.00019216537475586
(523) DESCRIBE `ports` 0.0007169246673584
(524) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00022006034851074
(525) DESCRIBE `ports` 0.00069785118103027
(526) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00020098686218262
(527) DESCRIBE `ports` 0.00068497657775879
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020313262939453
(529) DESCRIBE `ports` 0.00069308280944824
(530) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00019216537475586
(531) DESCRIBE `ports` 0.000701904296875
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021004676818848
(533) DESCRIBE `ports` 0.00069904327392578
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018215179443359
(535) DESCRIBE `ports` 0.00080084800720215
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3209))) 0.00020885467529297
(537) DESCRIBE `ports` 0.00068497657775879
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3209') 0.00018215179443359
(539) DESCRIBE `ports` 0.00071382522583008
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020289421081543
(541) DESCRIBE `ports` 0.00078415870666504
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018310546875
(543) DESCRIBE `ports` 0.0006868839263916
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020790100097656
(545) DESCRIBE `ports` 0.00068402290344238
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00023293495178223
(547) DESCRIBE `cruises` 0.0012989044189453
(548) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 41031))) 0.00028300285339355
(549) DESCRIBE `avid_specials` 0.00061988830566406
(550) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1225970 and class = 'Special') OR (item_id = 41031 and class = 'Cruise') OR (item_id = 1063 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00082182884216309
(551) DESCRIBE `cruiselines` 0.00096511840820312
(552) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00021791458129883
(553) DESCRIBE `orchid_image` 0.00080609321594238
(554) DESCRIBE `cruiselines` 0.0010659694671631
(555) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00021815299987793
(556) DESCRIBE `specials` 0.0020570755004883
(557) DESCRIBE `specials` 0.0019080638885498
(558) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1272476') 0.00033807754516602
(559) DESCRIBE `ships` 0.0016860961914062
(560) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 163))) 0.00031399726867676
(561) DESCRIBE `ships` 0.0013599395751953
(562) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '163') 0.00018405914306641
(563) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017499923706055
(564) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017094612121582
(565) DESCRIBE `itineraries` 0.00069499015808105
(566) DESCRIBE `ports` 0.00070095062255859
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00020480155944824
(568) DESCRIBE `ports` 0.00068283081054688
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.0001990795135498
(570) DESCRIBE `ports` 0.00072193145751953
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00017285346984863
(572) DESCRIBE `specialsailingdates` 0.00057601928710938
(573) DESCRIBE `sailingdates` 0.00059604644775391
(574) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 379647))) 0.0002140998840332
(575) DESCRIBE `ports` 0.00071907043457031
(576) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00019121170043945
(577) DESCRIBE `ports` 0.00067591667175293
(578) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00017499923706055
(579) DESCRIBE `ports` 0.00066494941711426
(580) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00020790100097656
(581) DESCRIBE `ports` 0.00077486038208008
(582) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00017380714416504
(583) DESCRIBE `ports` 0.00068902969360352
(584) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 585))) 0.00020408630371094
(585) DESCRIBE `ports` 0.00088596343994141
(586) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '585') 0.00020885467529297
(587) DESCRIBE `ports` 0.00087189674377441
(588) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00024008750915527
(589) DESCRIBE `ports` 0.00086116790771484
(590) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00020503997802734
(591) DESCRIBE `ports` 0.00086498260498047
(592) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00024795532226562
(593) DESCRIBE `ports` 0.00091791152954102
(594) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.0002138614654541
(595) DESCRIBE `ports` 0.00078892707824707
(596) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00022983551025391
(597) DESCRIBE `ports` 0.00081610679626465
(598) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00019311904907227
(599) DESCRIBE `ports` 0.0007169246673584
(600) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00020408630371094
(601) DESCRIBE `ports` 0.00070595741271973
(602) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00017404556274414
(603) DESCRIBE `ports` 0.00068497657775879
(604) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 514))) 0.0001990795135498
(605) DESCRIBE `ports` 0.00076007843017578
(606) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '514') 0.00018906593322754
(607) DESCRIBE `ports` 0.0007178783416748
(608) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00019621849060059
(609) DESCRIBE `ports` 0.00076699256896973
(610) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00017404556274414
(611) DESCRIBE `cruises` 0.0014081001281738
(612) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 44079))) 0.00029087066650391
(613) DESCRIBE `avid_specials` 0.00063300132751465
(614) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1272476 and class = 'Special') OR (item_id = 44079 and class = 'Cruise') OR (item_id = 163 AND class = 'Ship') OR (item_id = 33 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.00082302093505859
(615) DESCRIBE `cruiselines` 0.00097393989562988
(616) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00026798248291016
(617) DESCRIBE `orchid_image` 0.00075793266296387
(618) DESCRIBE `cruiselines` 0.00096893310546875
(619) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00017905235290527
(620) DESCRIBE `specials` 0.0033340454101562
(621) DESCRIBE `specials` 0.0032551288604736
(622) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1264156') 0.00049614906311035
(623) DESCRIBE `ships` 0.0023050308227539
(624) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1082))) 0.00042104721069336
(625) DESCRIBE `ships` 0.0021929740905762
(626) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1082') 0.00032210350036621
(627) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00022697448730469
(628) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00021505355834961
(629) DESCRIBE `itineraries` 0.001060962677002
(630) DESCRIBE `ports` 0.0011470317840576
(631) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00031495094299316
(632) DESCRIBE `ports` 0.00072216987609863
(633) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00022506713867188
(634) DESCRIBE `ports` 0.00085902214050293
(635) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00020003318786621
(636) DESCRIBE `specialsailingdates` 0.00059318542480469
(637) DESCRIBE `sailingdates` 0.00074887275695801
(638) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393654))) 0.00026798248291016
(639) DESCRIBE `sailingdates` 0.00065302848815918
(640) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 393655))) 0.00019502639770508
(641) DESCRIBE `sailingdates` 0.00065803527832031
(642) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 411661))) 0.00022292137145996
(643) DESCRIBE `sailingdates` 0.00080585479736328
(644) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 411662))) 0.00026416778564453
(645) DESCRIBE `sailingdates` 0.00085711479187012
(646) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 411663))) 0.00025510787963867
(647) DESCRIBE `sailingdates` 0.0008690357208252
(648) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 411664))) 0.00024986267089844
(649) DESCRIBE `sailingdates` 0.00084114074707031
(650) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 411665))) 0.00063395500183105
(651) DESCRIBE `sailingdates` 0.00081110000610352
(652) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 411666))) 0.00020289421081543
(653) DESCRIBE `sailingdates` 0.00062799453735352
(654) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 411667))) 0.00019598007202148
(655) DESCRIBE `sailingdates` 0.00066804885864258
(656) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 411668))) 0.0002138614654541
(657) DESCRIBE `sailingdates` 0.00063014030456543
(658) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 411669))) 0.00022506713867188
(659) DESCRIBE `sailingdates` 0.0006110668182373
(660) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 411670))) 0.00018906593322754
(661) DESCRIBE `sailingdates` 0.00063800811767578
(662) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 411671))) 0.00021100044250488
(663) DESCRIBE `sailingdates` 0.00072503089904785
(664) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 411672))) 0.00022602081298828
(665) DESCRIBE `sailingdates` 0.00077509880065918
(666) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 411673))) 0.00023698806762695
(667) DESCRIBE `sailingdates` 0.00074195861816406
(668) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 411674))) 0.0002291202545166
(669) DESCRIBE `ports` 0.00077700614929199
(670) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00031709671020508
(671) DESCRIBE `ports` 0.00089001655578613
(672) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00021910667419434
(673) DESCRIBE `ports` 0.00076413154602051
(674) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.00029706954956055
(675) DESCRIBE `ports` 0.00082111358642578
(676) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00020408630371094
(677) DESCRIBE `ports` 0.00075006484985352
(678) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00024199485778809
(679) DESCRIBE `ports` 0.0007328987121582
(680) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00018787384033203
(681) DESCRIBE `ports` 0.00069403648376465
(682) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00021791458129883
(683) DESCRIBE `ports` 0.0007479190826416
(684) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00020408630371094
(685) DESCRIBE `ports` 0.00069594383239746
(686) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 535))) 0.00027108192443848
(687) DESCRIBE `ports` 0.00087690353393555
(688) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '535') 0.00021195411682129
(689) DESCRIBE `ports` 0.0008690357208252
(690) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00024104118347168
(691) DESCRIBE `ports` 0.00093412399291992
(692) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00029802322387695
(693) DESCRIBE `cruises` 0.0015180110931396
(694) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 58792))) 0.00055599212646484
(695) DESCRIBE `avid_specials` 0.0011498928070068
(696) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1264156 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.0016329288482666
(697) DESCRIBE `cruiselines` 0.0016770362854004
(698) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 38))) 0.00037097930908203
(699) DESCRIBE `orchid_image` 0.0012469291687012
(700) DESCRIBE `cruiselines` 0.0013160705566406
(701) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '38') 0.00032591819763184
(702) DESCRIBE `cruiselines` 0.0015110969543457
(703) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('144', '38', '18', '101', '264', '114', '8', '23', '33', '140', '208', '26', '19', '37', '77', '20', '24', '29', '91', '151', '188', '15', '269')) ORDER BY FIND_IN_SET(id, '144,38,18,101,264,114,8,23,33,140,208,26,19,37,77,20,24,29,91,151,188,15,269') 0.001194953918457
(704) DESCRIBE `ships` 0.0025308132171631
(705) SELECT `ships`.* FROM `ships` WHERE (id IN ('1068', '1063', '1064', '1082', '1035', '1206', '1232', '1071', '1049', '1045', '1055', '1463', '547', '709', '1040', '1060', '1047', '1053', '1036', '1262', '1468', '1483', '75', '1052', '1043', '1051', '727', '1048', '1139', '1293', '163', '643', '1044', '625', '728', '988', '1038', '1054', '1465', '124', '451', '968', '1050', '1062', '1109', '1223', '1286', '262', '291', '324', '338', '394', '616', '624', '765', '823', '977', '1073', '1266', '45', '98', '148', '189', '212', '258', '287', '348', '485', '683', '726', '768', '796', '885', '1042', '1089', '1225', '1284', '1344', '1359', '1371', '1393', '1402', '1558')) ORDER BY FIND_IN_SET(id, '1068,1063,1064,1082,1035,1206,1232,1071,1049,1045,1055,1463,547,709,1040,1060,1047,1053,1036,1262,1468,1483,75,1052,1043,1051,727,1048,1139,1293,163,643,1044,625,728,988,1038,1054,1465,124,451,968,1050,1062,1109,1223,1286,262,291,324,338,394,616,624,765,823,977,1073,1266,45,98,148,189,212,258,287,348,485,683,726,768,796,885,1042,1089,1225,1284,1344,1359,1371,1393,1402,1558') 0.0040419101715088
(706) DESCRIBE `cruisetypes` 0.0013620853424072
(707) DESCRIBE `destinations` 0.0014688968658447
(708) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '35', '22', '43', '54', '2', '8', '28', '40', '48', '12', '26', '21', '37', '52')) ORDER BY FIND_IN_SET(id, '50,35,22,43,54,2,8,28,40,48,12,26,21,37,52') 0.0010020732879639