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

Total elapsed time: 0.37840366363525

# Query Time
(1) connect 0.00054812431335449
(2) DESCRIBE `cruises` 0.0016331672668457
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (41031, 40596, 44079, 57673, 57674, 40591, 65885, 65898, 40593, 48303)) ORDER BY FIND_IN_SET(id, '41031,40596,44079,57673,57674,40591,65885,65898,40593,48303') 0.0012061595916748
(4) DESCRIBE `specials` 0.0026769638061523
(5) SELECT `specials`.* FROM `specials` WHERE (id = '1225970') AND (specials.orchid_available = 1) LIMIT 1 0.00049996376037598
(6) DESCRIBE `specials` 0.0022990703582764
(7) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1225970') 0.00025296211242676
(8) DESCRIBE `ships` 0.0016410350799561
(9) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1063))) 0.0003058910369873
(10) DESCRIBE `ships` 0.0015819072723389
(11) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1063') 0.0002131462097168
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0001828670501709
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00017189979553223
(14) DESCRIBE `itineraries` 0.00089216232299805
(15) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '41031') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00061202049255371
(16) DESCRIBE `ports` 0.00090599060058594
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0002439022064209
(18) DESCRIBE `ports` 0.00079607963562012
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00021505355834961
(20) DESCRIBE `ports` 0.00080990791320801
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00020718574523926
(22) DESCRIBE `specialsailingdates` 0.00061988830566406
(23) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1225970') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.0005800724029541
(24) DESCRIBE `sailingdates` 0.00059294700622559
(25) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395455))) 0.00017690658569336
(26) DESCRIBE `sailingdates` 0.00055694580078125
(27) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396671))) 0.00016999244689941
(28) DESCRIBE `sailingdates` 0.00053811073303223
(29) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396672))) 0.0001671314239502
(30) DESCRIBE `sailingdates` 0.00068998336791992
(31) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396673))) 0.00021505355834961
(32) DESCRIBE `sailingdates` 0.00075507164001465
(33) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396674))) 0.00021696090698242
(34) DESCRIBE `sailingdates` 0.00070810317993164
(35) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395460))) 0.00017094612121582
(36) DESCRIBE `sailingdates` 0.00054097175598145
(37) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396692))) 0.00016593933105469
(38) DESCRIBE `sailingdates` 0.00054597854614258
(39) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396693))) 0.00016593933105469
(40) DESCRIBE `sailingdates` 0.00052714347839355
(41) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396694))) 0.00020289421081543
(42) DESCRIBE `sailingdates` 0.00061511993408203
(43) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396695))) 0.0001680850982666
(44) DESCRIBE `sailingdates` 0.00055789947509766
(45) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396696))) 0.00016498565673828
(46) DESCRIBE `sailingdates` 0.00052809715270996
(47) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 396697))) 0.0001680850982666
(48) DESCRIBE `ports` 0.00080990791320801
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00022006034851074
(50) DESCRIBE `ports` 0.00061678886413574
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00017094612121582
(52) DESCRIBE `ports` 0.00059700012207031
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00020909309387207
(54) DESCRIBE `ports` 0.00073099136352539
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00019407272338867
(56) DESCRIBE `ports` 0.0006098747253418
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00018095970153809
(58) DESCRIBE `ports` 0.0006110668182373
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00016403198242188
(60) DESCRIBE `ports` 0.00075316429138184
(61) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3209))) 0.00024008750915527
(62) DESCRIBE `ports` 0.00084495544433594
(63) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3209') 0.00021696090698242
(64) DESCRIBE `ports` 0.00085592269897461
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00025200843811035
(66) DESCRIBE `ports` 0.00069212913513184
(67) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00016093254089355
(68) DESCRIBE `ports` 0.00063109397888184
(69) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00017499923706055
(70) DESCRIBE `ports` 0.00072598457336426
(71) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00018501281738281
(72) DESCRIBE `cruises` 0.0012061595916748
(73) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 41031))) 0.00025391578674316
(74) DESCRIBE `avid_specials` 0.00066995620727539
(75) 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.00078511238098145
(76) DESCRIBE `cruiselines` 0.00092911720275879
(77) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00022697448730469
(78) DESCRIBE `orchid_image` 0.00079488754272461
(79) DESCRIBE `cruiselines` 0.0012180805206299
(80) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00026988983154297
(81) DESCRIBE `specials` 0.0016911029815674
(82) SELECT `specials`.* FROM `specials` WHERE (id = '1274075') AND (specials.orchid_available = 1) LIMIT 1 0.00031208992004395
(83) DESCRIBE `specials` 0.0014879703521729
(84) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1274075') 0.0001671314239502
(85) DESCRIBE `ships` 0.0010929107666016
(86) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1032))) 0.00022101402282715
(87) DESCRIBE `ships` 0.0010991096496582
(88) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1032') 0.00016593933105469
(89) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00015807151794434
(90) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00014591217041016
(91) DESCRIBE `itineraries` 0.00058293342590332
(92) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '40596') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00057601928710938
(93) DESCRIBE `ports` 0.00063109397888184
(94) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00018811225891113
(95) DESCRIBE `ports` 0.00058913230895996
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00017285346984863
(97) DESCRIBE `ports` 0.0005948543548584
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00016117095947266
(99) DESCRIBE `specialsailingdates` 0.00050091743469238
(100) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1274075') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00049209594726562
(101) DESCRIBE `sailingdates` 0.00055193901062012
(102) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383646))) 0.00016880035400391
(103) DESCRIBE `sailingdates` 0.00052499771118164
(104) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383647))) 0.00016403198242188
(105) DESCRIBE `ports` 0.0007021427154541
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00018191337585449
(107) DESCRIBE `ports` 0.00060701370239258
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00016212463378906
(109) DESCRIBE `ports` 0.00058197975158691
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00017499923706055
(111) DESCRIBE `ports` 0.00058293342590332
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00015711784362793
(113) DESCRIBE `ports` 0.00059413909912109
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00017189979553223
(115) DESCRIBE `ports` 0.00058221817016602
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00015807151794434
(117) DESCRIBE `ports` 0.00058293342590332
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00017595291137695
(119) DESCRIBE `ports` 0.0005800724029541
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00015807151794434
(121) DESCRIBE `ports` 0.0005791187286377
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00017094612121582
(123) DESCRIBE `ports` 0.00060796737670898
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00015687942504883
(125) DESCRIBE `ports` 0.00058293342590332
(126) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00017094612121582
(127) DESCRIBE `ports` 0.00060200691223145
(128) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.0002448558807373
(129) DESCRIBE `ports` 0.00063395500183105
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00018715858459473
(131) DESCRIBE `ports` 0.00059413909912109
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00016283988952637
(133) DESCRIBE `ports` 0.00059604644775391
(134) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00017714500427246
(135) DESCRIBE `ports` 0.00058817863464355
(136) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00016093254089355
(137) DESCRIBE `cruises` 0.0011281967163086
(138) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 40596))) 0.00029706954956055
(139) DESCRIBE `avid_specials` 0.00056600570678711
(140) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1274075 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.00075602531433105
(141) DESCRIBE `cruiselines` 0.0008540153503418
(142) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00019693374633789
(143) DESCRIBE `orchid_image` 0.00067806243896484
(144) DESCRIBE `cruiselines` 0.00081706047058105
(145) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00017595291137695
(146) DESCRIBE `specials` 0.002932071685791
(147) SELECT `specials`.* FROM `specials` WHERE (id = '1272476') AND (specials.orchid_available = 1) LIMIT 1 0.00064897537231445
(148) DESCRIBE `specials` 0.0027921199798584
(149) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1272476') 0.00030899047851562
(150) DESCRIBE `ships` 0.0018479824066162
(151) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 163))) 0.00032806396484375
(152) DESCRIBE `ships` 0.0018048286437988
(153) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '163') 0.00027894973754883
(154) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00021195411682129
(155) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00020194053649902
(156) DESCRIBE `itineraries` 0.00096416473388672
(157) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '44079') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00062799453735352
(158) DESCRIBE `ports` 0.0010650157928467
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00029802322387695
(160) DESCRIBE `ports` 0.00063800811767578
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00020408630371094
(162) DESCRIBE `ports` 0.00060796737670898
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00017786026000977
(164) DESCRIBE `specialsailingdates` 0.00051307678222656
(165) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1272476') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.0005338191986084
(166) DESCRIBE `sailingdates` 0.0005800724029541
(167) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 379647))) 0.00018095970153809
(168) DESCRIBE `ports` 0.00061917304992676
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00019192695617676
(170) DESCRIBE `ports` 0.00059890747070312
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00017285346984863
(172) DESCRIBE `ports` 0.00062298774719238
(173) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 512))) 0.00023102760314941
(174) DESCRIBE `ports` 0.00059294700622559
(175) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '512') 0.00016188621520996
(176) DESCRIBE `ports` 0.00059008598327637
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 585))) 0.00024104118347168
(178) DESCRIBE `ports` 0.00063800811767578
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '585') 0.00016999244689941
(180) DESCRIBE `ports` 0.00059199333190918
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00018501281738281
(182) DESCRIBE `ports` 0.00059080123901367
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00016403198242188
(184) DESCRIBE `ports` 0.00062298774719238
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 515))) 0.00018692016601562
(186) DESCRIBE `ports` 0.00060200691223145
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '515') 0.00017404556274414
(188) DESCRIBE `ports` 0.00059103965759277
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00017905235290527
(190) DESCRIBE `ports` 0.00061488151550293
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00018000602722168
(192) DESCRIBE `ports` 0.00061798095703125
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 450))) 0.00017905235290527
(194) DESCRIBE `ports` 0.00058794021606445
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '450') 0.00015997886657715
(196) DESCRIBE `ports` 0.0007319450378418
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 514))) 0.00019311904907227
(198) DESCRIBE `ports` 0.00063109397888184
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '514') 0.00016307830810547
(200) DESCRIBE `ports` 0.00058698654174805
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00024008750915527
(202) DESCRIBE `ports` 0.00085711479187012
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00021195411682129
(204) DESCRIBE `cruises` 0.0012750625610352
(205) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 44079))) 0.00030899047851562
(206) DESCRIBE `avid_specials` 0.0005488395690918
(207) 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.00075697898864746
(208) DESCRIBE `cruiselines` 0.00083112716674805
(209) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.0001990795135498
(210) DESCRIBE `orchid_image` 0.00065994262695312
(211) DESCRIBE `cruiselines` 0.00081992149353027
(212) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00017118453979492
(213) DESCRIBE `specials` 0.0022249221801758
(214) SELECT `specials`.* FROM `specials` WHERE (id = '1274101') AND (specials.orchid_available = 1) LIMIT 1 0.00040316581726074
(215) DESCRIBE `specials` 0.0022170543670654
(216) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1274101') 0.00026798248291016
(217) DESCRIBE `ships` 0.0011940002441406
(218) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1205))) 0.00024700164794922
(219) DESCRIBE `ships` 0.0012729167938232
(220) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1205') 0.00019502639770508
(221) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00016093254089355
(222) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014996528625488
(223) DESCRIBE `itineraries` 0.00083589553833008
(224) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '57673') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00055909156799316
(225) DESCRIBE `ports` 0.00071191787719727
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00021195411682129
(227) DESCRIBE `ports` 0.00059604644775391
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00018501281738281
(229) DESCRIBE `ports` 0.00059103965759277
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00019288063049316
(231) DESCRIBE `specialsailingdates` 0.00050711631774902
(232) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1274101') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00043797492980957
(233) DESCRIBE `sailingdates` 0.00059294700622559
(234) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383882))) 0.00018191337585449
(235) DESCRIBE `sailingdates` 0.00053596496582031
(236) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383883))) 0.00016903877258301
(237) DESCRIBE `sailingdates` 0.00060510635375977
(238) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383884))) 0.00022101402282715
(239) DESCRIBE `ports` 0.00086402893066406
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00026082992553711
(241) DESCRIBE `ports` 0.00084686279296875
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00017809867858887
(243) DESCRIBE `ports` 0.00059604644775391
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00017285346984863
(245) DESCRIBE `ports` 0.00059700012207031
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00016403198242188
(247) DESCRIBE `ports` 0.00064706802368164
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.0001838207244873
(249) DESCRIBE `ports` 0.00059294700622559
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.00016403198242188
(251) DESCRIBE `ports` 0.00058484077453613
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5645))) 0.00017619132995605
(253) DESCRIBE `ports` 0.00067687034606934
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5645') 0.00016903877258301
(255) DESCRIBE `ports` 0.00059318542480469
(256) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.0001838207244873
(257) DESCRIBE `ports` 0.00059008598327637
(258) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00016188621520996
(259) DESCRIBE `ports` 0.00058698654174805
(260) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00017786026000977
(261) DESCRIBE `ports` 0.00058698654174805
(262) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00016403198242188
(263) DESCRIBE `ports` 0.00058293342590332
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00018310546875
(265) DESCRIBE `ports` 0.00058507919311523
(266) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00018191337585449
(267) DESCRIBE `ports` 0.00060296058654785
(268) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00016999244689941
(269) DESCRIBE `ports` 0.00058197975158691
(270) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00015497207641602
(271) DESCRIBE `ports` 0.00059008598327637
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00017499923706055
(273) DESCRIBE `ports` 0.00063800811767578
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00016117095947266
(275) DESCRIBE `ports` 0.00060200691223145
(276) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00017595291137695
(277) DESCRIBE `ports` 0.00062012672424316
(278) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00019097328186035
(279) DESCRIBE `ports` 0.00087714195251465
(280) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00024604797363281
(281) DESCRIBE `ports` 0.00078797340393066
(282) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.0002291202545166
(283) DESCRIBE `ports` 0.0009000301361084
(284) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00025701522827148
(285) DESCRIBE `ports` 0.0006711483001709
(286) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00016593933105469
(287) DESCRIBE `cruises` 0.0011599063873291
(288) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 57673))) 0.00025796890258789
(289) DESCRIBE `avid_specials` 0.0005500316619873
(290) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1274101 and class = 'Special') OR (item_id = 57673 and class = 'Cruise') OR (item_id = 1205 AND class = 'Ship') OR (item_id = 191 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.00077414512634277
(291) DESCRIBE `cruiselines` 0.00086593627929688
(292) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00019407272338867
(293) DESCRIBE `orchid_image` 0.00066494941711426
(294) DESCRIBE `cruiselines` 0.00083589553833008
(295) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00017905235290527
(296) DESCRIBE `specials` 0.0015900135040283
(297) SELECT `specials`.* FROM `specials` WHERE (id = '1274091') AND (specials.orchid_available = 1) LIMIT 1 0.00031614303588867
(298) DESCRIBE `specials` 0.0015108585357666
(299) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1274091') 0.00018692016601562
(300) DESCRIBE `ships` 0.0011160373687744
(301) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1205))) 0.00023889541625977
(302) DESCRIBE `ships` 0.0010991096496582
(303) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1205') 0.00020503997802734
(304) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015902519226074
(305) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00014805793762207
(306) DESCRIBE `itineraries` 0.00063514709472656
(307) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '57674') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00040388107299805
(308) DESCRIBE `ports` 0.00064682960510254
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00019311904907227
(310) DESCRIBE `ports` 0.00063085556030273
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00017714500427246
(312) DESCRIBE `ports` 0.00060200691223145
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00016498565673828
(314) DESCRIBE `specialsailingdates` 0.00053000450134277
(315) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1274091') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00043106079101562
(316) DESCRIBE `sailingdates` 0.00055599212646484
(317) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383822))) 0.00017690658569336
(318) DESCRIBE `sailingdates` 0.00054693222045898
(319) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383823))) 0.00018596649169922
(320) DESCRIBE `sailingdates` 0.0005648136138916
(321) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383824))) 0.00018405914306641
(322) DESCRIBE `ports` 0.00061392784118652
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00019097328186035
(324) DESCRIBE `ports` 0.0006859302520752
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00017309188842773
(326) DESCRIBE `ports` 0.00072717666625977
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.00039005279541016
(328) DESCRIBE `ports` 0.0010020732879639
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.00022697448730469
(330) DESCRIBE `ports` 0.00073790550231934
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5645))) 0.0001981258392334
(332) DESCRIBE `ports` 0.00060081481933594
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5645') 0.00016093254089355
(334) DESCRIBE `ports` 0.00060105323791504
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00018000602722168
(336) DESCRIBE `ports` 0.00081396102905273
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00016283988952637
(338) DESCRIBE `ports` 0.00059700012207031
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00016903877258301
(340) DESCRIBE `ports` 0.00059914588928223
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00017213821411133
(342) DESCRIBE `ports` 0.0011918544769287
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00024008750915527
(344) DESCRIBE `ports` 0.00067996978759766
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00017499923706055
(346) DESCRIBE `cruises` 0.0012049674987793
(347) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 57674))) 0.00026106834411621
(348) DESCRIBE `avid_specials` 0.0005500316619873
(349) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1274091 and class = 'Special') OR (item_id = 57674 and class = 'Cruise') OR (item_id = 1205 AND class = 'Ship') OR (item_id = 191 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.00081110000610352
(350) DESCRIBE `cruiselines` 0.00094103813171387
(351) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00020599365234375
(352) DESCRIBE `orchid_image` 0.00067901611328125
(353) DESCRIBE `cruiselines` 0.0010018348693848
(354) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00018692016601562
(355) DESCRIBE `specials` 0.0017290115356445
(356) SELECT `specials`.* FROM `specials` WHERE (id = '1274065') AND (specials.orchid_available = 1) LIMIT 1 0.00034713745117188
(357) DESCRIBE `specials` 0.0016360282897949
(358) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1274065') 0.00019502639770508
(359) DESCRIBE `ships` 0.0012059211730957
(360) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1032))) 0.00023984909057617
(361) DESCRIBE `ships` 0.0011410713195801
(362) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1032') 0.00018310546875
(363) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00017690658569336
(364) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00015711784362793
(365) DESCRIBE `itineraries` 0.00072789192199707
(366) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '40591') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00031185150146484
(367) DESCRIBE `ports` 0.00063681602478027
(368) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00020408630371094
(369) DESCRIBE `ports` 0.00061202049255371
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00017809867858887
(371) DESCRIBE `ports` 0.00059318542480469
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00016689300537109
(373) DESCRIBE `specialsailingdates` 0.00050711631774902
(374) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1274065') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.0004420280456543
(375) DESCRIBE `sailingdates` 0.0011699199676514
(376) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383538))) 0.00031709671020508
(377) DESCRIBE `sailingdates` 0.00071883201599121
(378) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383539))) 0.00022983551025391
(379) DESCRIBE `sailingdates` 0.00080204010009766
(380) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383542))) 0.00023484230041504
(381) DESCRIBE `ports` 0.00091314315795898
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00026607513427734
(383) DESCRIBE `ports` 0.00090503692626953
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00025200843811035
(385) DESCRIBE `ports` 0.00089406967163086
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00025200843811035
(387) DESCRIBE `ports` 0.00088787078857422
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00025606155395508
(389) DESCRIBE `ports` 0.00089097023010254
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00024509429931641
(391) DESCRIBE `ports` 0.00084996223449707
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00024795532226562
(393) DESCRIBE `ports` 0.00091409683227539
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00024914741516113
(395) DESCRIBE `ports` 0.00089478492736816
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00025105476379395
(397) DESCRIBE `cruises` 0.0017740726470947
(398) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 40591))) 0.00039005279541016
(399) DESCRIBE `avid_specials` 0.00083684921264648
(400) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1274065 and class = 'Special') OR (item_id = 40591 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.0013840198516846
(401) DESCRIBE `cruiselines` 0.0013880729675293
(402) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00027799606323242
(403) DESCRIBE `orchid_image` 0.00095009803771973
(404) DESCRIBE `cruiselines` 0.0012240409851074
(405) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00024199485778809
(406) DESCRIBE `specials` 0.0025990009307861
(407) SELECT `specials`.* FROM `specials` WHERE (id = '1258060') AND (specials.orchid_available = 1) LIMIT 1 0.00047779083251953
(408) DESCRIBE `specials` 0.002547025680542
(409) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1258060') 0.0002739429473877
(410) DESCRIBE `ships` 0.0017960071563721
(411) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1463))) 0.00035309791564941
(412) DESCRIBE `ships` 0.0018668174743652
(413) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1463') 0.00027084350585938
(414) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00019598007202148
(415) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00018501281738281
(416) DESCRIBE `itineraries` 0.00095295906066895
(417) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65885') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00060391426086426
(418) DESCRIBE `ports` 0.00094914436340332
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00026392936706543
(420) DESCRIBE `ports` 0.00092506408691406
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00023102760314941
(422) DESCRIBE `ports` 0.000885009765625
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.0002281665802002
(424) DESCRIBE `specialsailingdates` 0.00073504447937012
(425) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1258060') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00081515312194824
(426) DESCRIBE `sailingdates` 0.0007178783416748
(427) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413565))) 0.00024294853210449
(428) DESCRIBE `sailingdates` 0.00081014633178711
(429) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413566))) 0.00019216537475586
(430) DESCRIBE `sailingdates` 0.00054788589477539
(431) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413567))) 0.00017309188842773
(432) DESCRIBE `sailingdates` 0.00052714347839355
(433) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413568))) 0.00017404556274414
(434) DESCRIBE `sailingdates` 0.00056290626525879
(435) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413569))) 0.0001680850982666
(436) DESCRIBE `ports` 0.00062108039855957
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00019621849060059
(438) DESCRIBE `ports` 0.00067996978759766
(439) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00025510787963867
(440) DESCRIBE `ports` 0.000946044921875
(441) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00027298927307129
(442) DESCRIBE `ports` 0.0010271072387695
(443) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00022101402282715
(444) DESCRIBE `cruises` 0.0012528896331787
(445) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 65885))) 0.00030303001403809
(446) DESCRIBE `avid_specials` 0.00061416625976562
(447) 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.00076007843017578
(448) DESCRIBE `cruiselines` 0.00085687637329102
(449) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.0002131462097168
(450) DESCRIBE `orchid_image` 0.0006711483001709
(451) SELECT `orchid_image`.* FROM `orchid_image` WHERE (model_name = 'CruiseLine') AND (model_id = '264') 0.025117158889771
(452) DESCRIBE `cruiselines` 0.0011458396911621
(453) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00022697448730469
(454) DESCRIBE `specials` 0.002249002456665
(455) SELECT `specials`.* FROM `specials` WHERE (id = '1258062') AND (specials.orchid_available = 1) LIMIT 1 0.00041913986206055
(456) DESCRIBE `specials` 0.0018420219421387
(457) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1258062') 0.00025010108947754
(458) DESCRIBE `ships` 0.0012109279632568
(459) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1463))) 0.00025606155395508
(460) DESCRIBE `ships` 0.0011868476867676
(461) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1463') 0.00016999244689941
(462) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00016498565673828
(463) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00014305114746094
(464) DESCRIBE `itineraries` 0.00058293342590332
(465) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65898') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00040411949157715
(466) DESCRIBE `ports` 0.00063610076904297
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00018787384033203
(468) DESCRIBE `ports` 0.00082302093505859
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00023388862609863
(470) DESCRIBE `ports` 0.00087404251098633
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00021100044250488
(472) DESCRIBE `specialsailingdates` 0.00071597099304199
(473) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1258062') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00059795379638672
(474) DESCRIBE `sailingdates` 0.00079989433288574
(475) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413556))) 0.00025105476379395
(476) DESCRIBE `sailingdates` 0.00073814392089844
(477) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413557))) 0.00016999244689941
(478) DESCRIBE `sailingdates` 0.0005338191986084
(479) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413558))) 0.00016498565673828
(480) DESCRIBE `sailingdates` 0.00053095817565918
(481) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 413559))) 0.00019097328186035
(482) DESCRIBE `ports` 0.00062298774719238
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00019693374633789
(484) DESCRIBE `ports` 0.00062203407287598
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00016903877258301
(486) DESCRIBE `ports` 0.00062799453735352
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1424))) 0.00023603439331055
(488) DESCRIBE `ports` 0.00059604644775391
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1424') 0.00016617774963379
(490) DESCRIBE `ports` 0.00059103965759277
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 503))) 0.00018119812011719
(492) DESCRIBE `ports` 0.00067996978759766
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '503') 0.00023889541625977
(494) DESCRIBE `ports` 0.00064301490783691
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 548))) 0.00018191337585449
(496) DESCRIBE `ports` 0.00059986114501953
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '548') 0.0001530647277832
(498) DESCRIBE `ports` 0.00059914588928223
(499) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1424))) 0.00020289421081543
(500) DESCRIBE `ports` 0.00059890747070312
(501) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1424') 0.00017714500427246
(502) DESCRIBE `ports` 0.00060820579528809
(503) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 136))) 0.00017285346984863
(504) DESCRIBE `ports` 0.0006101131439209
(505) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '136') 0.00017905235290527
(506) DESCRIBE `cruises` 0.0011839866638184
(507) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 65898))) 0.00025200843811035
(508) DESCRIBE `avid_specials` 0.0005490779876709
(509) 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.00080204010009766
(510) DESCRIBE `cruiselines` 0.00094485282897949
(511) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 264))) 0.00022506713867188
(512) DESCRIBE `orchid_image` 0.0006709098815918
(513) DESCRIBE `cruiselines` 0.00092411041259766
(514) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '264') 0.00017595291137695
(515) DESCRIBE `specials` 0.0017859935760498
(516) SELECT `specials`.* FROM `specials` WHERE (id = '1274070') AND (specials.orchid_available = 1) LIMIT 1 0.00034809112548828
(517) DESCRIBE `specials` 0.0017070770263672
(518) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1274070') 0.00020694732666016
(519) DESCRIBE `ships` 0.0011930465698242
(520) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1032))) 0.00026488304138184
(521) DESCRIBE `ships` 0.0013079643249512
(522) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1032') 0.00023698806762695
(523) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019693374633789
(524) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00019216537475586
(525) DESCRIBE `itineraries` 0.00087380409240723
(526) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '40593') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00049614906311035
(527) DESCRIBE `ports` 0.00086593627929688
(528) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00025606155395508
(529) DESCRIBE `ports` 0.00080084800720215
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00019097328186035
(531) DESCRIBE `ports` 0.00064802169799805
(532) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00017094612121582
(533) DESCRIBE `specialsailingdates` 0.00051498413085938
(534) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1274070') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00044512748718262
(535) DESCRIBE `sailingdates` 0.0006108283996582
(536) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383618))) 0.0001978874206543
(537) DESCRIBE `sailingdates` 0.0005340576171875
(538) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383619))) 0.00016379356384277
(539) DESCRIBE `sailingdates` 0.0005340576171875
(540) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383620))) 0.00017309188842773
(541) DESCRIBE `sailingdates` 0.00061702728271484
(542) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383621))) 0.00017285346984863
(543) DESCRIBE `ports` 0.00062990188598633
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00019502639770508
(545) DESCRIBE `ports` 0.00061297416687012
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00018620491027832
(547) DESCRIBE `ports` 0.00062799453735352
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00017690658569336
(549) DESCRIBE `ports` 0.0006411075592041
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00020313262939453
(551) DESCRIBE `ports` 0.00061416625976562
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00018620491027832
(553) DESCRIBE `ports` 0.00073909759521484
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00022506713867188
(555) DESCRIBE `ports` 0.0008690357208252
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00023984909057617
(557) DESCRIBE `ports` 0.00088810920715332
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00021791458129883
(559) DESCRIBE `ports` 0.00086402893066406
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00020098686218262
(561) DESCRIBE `ports` 0.0006258487701416
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00016689300537109
(563) DESCRIBE `cruises` 0.0012989044189453
(564) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 40593))) 0.00029110908508301
(565) DESCRIBE `avid_specials` 0.00056314468383789
(566) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1274070 and class = 'Special') OR (item_id = 40593 and class = 'Cruise') OR (item_id = 1032 AND class = 'Ship') OR (item_id = 191 AND class = 'CruiseLine') OR (item_id = 55 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.00075817108154297
(567) DESCRIBE `cruiselines` 0.00087690353393555
(568) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00019621849060059
(569) DESCRIBE `orchid_image` 0.00066494941711426
(570) DESCRIBE `cruiselines` 0.00085878372192383
(571) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00018596649169922
(572) DESCRIBE `specials` 0.001662015914917
(573) SELECT `specials`.* FROM `specials` WHERE (id = '1274085') AND (specials.orchid_available = 1) LIMIT 1 0.00033879280090332
(574) DESCRIBE `specials` 0.0019378662109375
(575) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1274085') 0.0002601146697998
(576) DESCRIBE `ships` 0.0012590885162354
(577) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1205))) 0.00026416778564453
(578) DESCRIBE `ships` 0.0012249946594238
(579) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1205') 0.00018596649169922
(580) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00015711784362793
(581) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0001838207244873
(582) DESCRIBE `itineraries` 0.00059008598327637
(583) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '48303') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00053000450134277
(584) DESCRIBE `ports` 0.00086593627929688
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00023913383483887
(586) DESCRIBE `ports` 0.00083398818969727
(587) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00021886825561523
(588) DESCRIBE `ports` 0.00083804130554199
(589) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00020003318786621
(590) DESCRIBE `specialsailingdates` 0.00062084197998047
(591) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1274085') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00042486190795898
(592) DESCRIBE `sailingdates` 0.00053811073303223
(593) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383718))) 0.00016999244689941
(594) DESCRIBE `sailingdates` 0.00056004524230957
(595) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 383719))) 0.00017213821411133
(596) DESCRIBE `ports` 0.0006110668182373
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00018715858459473
(598) DESCRIBE `ports` 0.00058913230895996
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00016903877258301
(600) DESCRIBE `ports` 0.00060796737670898
(601) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00018000602722168
(602) DESCRIBE `ports` 0.00059795379638672
(603) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.00015902519226074
(604) DESCRIBE `ports` 0.00059914588928223
(605) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00018596649169922
(606) DESCRIBE `ports` 0.00076889991760254
(607) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.0002131462097168
(608) DESCRIBE `ports` 0.00088787078857422
(609) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00019311904907227
(610) DESCRIBE `ports` 0.00061607360839844
(611) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00020909309387207
(612) DESCRIBE `ports` 0.00062680244445801
(613) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00018692016601562
(614) DESCRIBE `ports` 0.00097918510437012
(615) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00018692016601562
(616) DESCRIBE `ports` 0.00065994262695312
(617) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00018596649169922
(618) DESCRIBE `ports` 0.00060892105102539
(619) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00015902519226074
(620) DESCRIBE `cruises` 0.0011870861053467
(621) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 48303))) 0.00028300285339355
(622) DESCRIBE `avid_specials` 0.00055289268493652
(623) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1274085 and class = 'Special') OR (item_id = 48303 and class = 'Cruise') OR (item_id = 1205 AND class = 'Ship') OR (item_id = 191 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.00078892707824707
(624) DESCRIBE `cruiselines` 0.0008549690246582
(625) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.0001981258392334
(626) DESCRIBE `orchid_image` 0.00065994262695312
(627) DESCRIBE `cruiselines` 0.00088405609130859
(628) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.0001680850982666
(629) DESCRIBE `cruiselines` 0.00095891952514648
(630) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('144', '47', '33', '91', '23', '191', '101', '18', '147', '188', '28', '24', '8', '218', '264', '30', '208', '15', '19', '77', '171', '262', '20', '37', '120', '50', '26', '73', '105', '151', '212', '29', '114', '263', '269')) ORDER BY FIND_IN_SET(id, '144,47,33,91,23,191,101,18,147,188,28,24,8,218,264,30,208,15,19,77,171,262,20,37,120,50,26,73,105,151,212,29,114,263,269') 0.0016698837280273
(631) DESCRIBE `ships` 0.0014748573303223
(632) SELECT `ships`.* FROM `ships` WHERE (id IN ('517', '1068', '1063', '1064', '163', '1035', '1206', '1232', '650', '1049', '1045', '1055', '709', '823', '1040', '1060', '1205', '547', '1047', '1053', '1325', '1036', '1319', '1468', '1032', '1463', '1483', '75', '1052', '1071', '966', '1043', '1051', '1021', '1048', '1266', '1292', '1293', '1492', '394', '643', '1044', '105', '508', '580', '850', '988', '1038', '1054', '1108', '1154', '1303', '1465', '24', '150', '151', '258', '338', '451', '483', '758', '1050', '1062', '1109', '1168', '1286', '43', '45', '108', '111', '124', '152', '324', '349', '485', '506', '520', '585', '616', '683', '727', '973', '977', '1028', '1073', '1135', '1223', '1237', '1240', '1284', '1526', '97', '98', '148', '205', '253', '262', '291', '341', '348', '404', '406', '434', '441', '448', '521', '542', '652', '669', '674', '678', '726', '738', '765', '768', '780', '786', '790', '888', '968', '1013', '1026', '1042', '1088', '1089', '1139', '1148', '1159', '1225', '1285', '1318', '1321', '1344', '1355', '1359', '1371', '1392', '1402', '1452', '1464', '1558')) ORDER BY FIND_IN_SET(id, '517,1068,1063,1064,163,1035,1206,1232,650,1049,1045,1055,709,823,1040,1060,1205,547,1047,1053,1325,1036,1319,1468,1032,1463,1483,75,1052,1071,966,1043,1051,1021,1048,1266,1292,1293,1492,394,643,1044,105,508,580,850,988,1038,1054,1108,1154,1303,1465,24,150,151,258,338,451,483,758,1050,1062,1109,1168,1286,43,45,108,111,124,152,324,349,485,506,520,585,616,683,727,973,977,1028,1073,1135,1223,1237,1240,1284,1526,97,98,148,205,253,262,291,341,348,404,406,434,441,448,521,542,652,669,674,678,726,738,765,768,780,786,790,888,968,1013,1026,1042,1088,1089,1139,1148,1159,1225,1285,1318,1321,1344,1355,1359,1371,1392,1402,1452,1464,1558') 0.0045058727264404
(633) DESCRIBE `cruisetypes` 0.00086092948913574
(634) DESCRIBE `destinations` 0.00087094306945801
(635) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '43', '22', '54', '2', '35', '37', '40', '12', '55', '26', '28', '8', '48', '49', '21', '7', '38', '39', '25', '29', '34', '52', '53')) ORDER BY FIND_IN_SET(id, '50,43,22,54,2,35,37,40,12,55,26,28,8,48,49,21,7,38,39,25,29,34,52,53') 0.00084614753723145