or, enquire about your chosen options

  1. Catch Up on Cruising: Latest News in bite size!
  2. Solo Cruisers
  3. Catch Up on Cruising: Latest News in bite size!
  4. Should I buy a beverage package?
  5. SPOTLIGHT ON: Viking Ocean and River Cruises

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

Total elapsed time: 1.0945739746094

# Query Time
(1) connect 0.0017430782318115
(2) DESCRIBE `cruises` 0.0042390823364258
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (38122, 38149, 40595, 45258, 48299, 51415, 55033, 55784, 55793, 55810)) ORDER BY FIND_IN_SET(id, '38122,38149,40595,45258,48299,51415,55033,55784,55793,55810') 0.0034010410308838
(4) DESCRIBE `cruises` 0.011199951171875
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '38122') 0.00057888031005859
(6) DESCRIBE `ships` 0.003633975982666
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 821))) 0.0072910785675049
(8) DESCRIBE `ships` 0.0041861534118652
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '821') 0.00056719779968262
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00035214424133301
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00032591819763184
(12) DESCRIBE `itineraries` 0.0051379203796387
(13) DESCRIBE `ports` 0.0075640678405762
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4401))) 0.00074481964111328
(15) DESCRIBE `ports` 0.001666784286499
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4401))) 0.00037789344787598
(17) DESCRIBE `ports` 0.0014081001281738
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4401') 0.00031208992004395
(19) DESCRIBE `sailingdates` 0.0015778541564941
(20) DESCRIBE `ports` 0.0016210079193115
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4401))) 0.00035715103149414
(22) DESCRIBE `ports` 0.0013508796691895
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4401') 0.00031089782714844
(24) DESCRIBE `ports` 0.0013909339904785
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3178))) 0.00042510032653809
(26) DESCRIBE `ports` 0.0016939640045166
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3178') 0.00033402442932129
(28) DESCRIBE `ports` 0.0014441013336182
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3180))) 0.00042891502380371
(30) DESCRIBE `ports` 0.0012969970703125
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3180') 0.00025391578674316
(32) DESCRIBE `ports` 0.0013160705566406
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00036215782165527
(34) DESCRIBE `ports` 0.0015521049499512
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00035715103149414
(36) DESCRIBE `ports` 0.0017571449279785
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 905))) 0.00050187110900879
(38) DESCRIBE `ports` 0.0017769336700439
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '905') 0.0020780563354492
(40) DESCRIBE `ports` 0.0045180320739746
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 373))) 0.00039005279541016
(42) DESCRIBE `ports` 0.0081110000610352
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '373') 0.00035214424133301
(44) DESCRIBE `ports` 0.0016460418701172
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00040197372436523
(46) DESCRIBE `ports` 0.0028579235076904
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.0074880123138428
(48) DESCRIBE `ports` 0.0015749931335449
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3747))) 0.00032901763916016
(50) DESCRIBE `ports` 0.0013241767883301
(51) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3747') 0.00029301643371582
(52) DESCRIBE `ports` 0.0015790462493896
(53) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4401))) 0.00031709671020508
(54) DESCRIBE `ports` 0.0013351440429688
(55) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4401') 0.00030016899108887
(56) DESCRIBE `ports` 0.002208948135376
(57) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4401))) 0.00038981437683105
(58) DESCRIBE `ports` 0.0027849674224854
(59) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4401') 0.00030994415283203
(60) DESCRIBE `avid_specials` 0.0011599063873291
(61) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 38122 and class = 'Cruise') OR (item_id = 821 AND class = 'Ship') OR (item_id = 141 AND class = 'CruiseLine') OR (item_id = 22 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.0011160373687744
(62) DESCRIBE `cruiselines` 0.002094030380249
(63) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 141))) 0.00032496452331543
(64) DESCRIBE `orchid_image` 0.0030701160430908
(65) DESCRIBE `cruiselines` 0.002518892288208
(66) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '141') 0.00044393539428711
(67) DESCRIBE `cruises` 0.0030319690704346
(68) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '38149') 0.0004279613494873
(69) DESCRIBE `ships` 0.0026960372924805
(70) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 207))) 0.00046610832214355
(71) DESCRIBE `ships` 0.0030591487884521
(72) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '207') 0.0004580020904541
(73) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00033998489379883
(74) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00025796890258789
(75) DESCRIBE `itineraries` 0.0014569759368896
(76) DESCRIBE `ports` 0.0019350051879883
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00044107437133789
(78) DESCRIBE `ports` 0.0017077922821045
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00039386749267578
(80) DESCRIBE `ports` 0.0013918876647949
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00036096572875977
(82) DESCRIBE `sailingdates` 0.001133918762207
(83) DESCRIBE `ports` 0.0016629695892334
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00036501884460449
(85) DESCRIBE `ports` 0.0013341903686523
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00030803680419922
(87) DESCRIBE `ports` 0.0015439987182617
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 261))) 0.00049901008605957
(89) DESCRIBE `ports` 0.0015161037445068
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '261') 0.0003969669342041
(91) DESCRIBE `ports` 0.002004861831665
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 262))) 0.00033879280090332
(93) DESCRIBE `ports` 0.0014059543609619
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '262') 0.00030303001403809
(95) DESCRIBE `ports` 0.0014829635620117
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 260))) 0.00030899047851562
(97) DESCRIBE `ports` 0.0014128684997559
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '260') 0.00038504600524902
(99) DESCRIBE `ports` 0.0017719268798828
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00039386749267578
(101) DESCRIBE `ports` 0.0015010833740234
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00031709671020508
(103) DESCRIBE `ports` 0.0015389919281006
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 263))) 0.00036501884460449
(105) DESCRIBE `ports` 0.0015058517456055
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '263') 0.00041389465332031
(107) DESCRIBE `ports` 0.0019981861114502
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 265))) 0.00040292739868164
(109) DESCRIBE `ports` 0.0017509460449219
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '265') 0.00036501884460449
(111) DESCRIBE `ports` 0.0016829967498779
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 266))) 0.00049996376037598
(113) DESCRIBE `ports` 0.0019359588623047
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '266') 0.00039815902709961
(115) DESCRIBE `ports` 0.0018060207366943
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00050115585327148
(117) DESCRIBE `ports` 0.0018379688262939
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00040316581726074
(119) DESCRIBE `avid_specials` 0.0016241073608398
(120) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 38149 and class = 'Cruise') OR (item_id = 207 AND class = 'Ship') OR (item_id = 36 AND class = 'CruiseLine') OR (item_id = 8 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.0018348693847656
(121) DESCRIBE `cruiselines` 0.0025050640106201
(122) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 36))) 0.0006101131439209
(123) DESCRIBE `orchid_image` 0.001798152923584
(124) DESCRIBE `cruiselines` 0.0023891925811768
(125) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '36') 0.0004570484161377
(126) DESCRIBE `cruises` 0.007580041885376
(127) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '40595') 0.0087358951568604
(128) DESCRIBE `ships` 0.003148078918457
(129) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1032))) 0.00048112869262695
(130) DESCRIBE `ships` 0.0032451152801514
(131) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1032') 0.0087668895721436
(132) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034499168395996
(133) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033688545227051
(134) DESCRIBE `itineraries` 0.0019209384918213
(135) DESCRIBE `ports` 0.010569095611572
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00052094459533691
(137) DESCRIBE `ports` 0.001884937286377
(138) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.0024600028991699
(139) DESCRIBE `ports` 0.0021710395812988
(140) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.010072946548462
(141) DESCRIBE `sailingdates` 0.0018188953399658
(142) DESCRIBE `ports` 0.0082528591156006
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.0090909004211426
(144) DESCRIBE `ports` 0.0021741390228271
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00051784515380859
(146) DESCRIBE `ports` 0.0018868446350098
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00050091743469238
(148) DESCRIBE `ports` 0.0019159317016602
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00043582916259766
(150) DESCRIBE `ports` 0.0020041465759277
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00046992301940918
(152) DESCRIBE `ports` 0.0017750263214111
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.0058760643005371
(154) DESCRIBE `ports` 0.0021579265594482
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00061798095703125
(156) DESCRIBE `ports` 0.0018868446350098
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.0003960132598877
(158) DESCRIBE `ports` 0.0018808841705322
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00071001052856445
(160) DESCRIBE `ports` 0.0018908977508545
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00037097930908203
(162) DESCRIBE `ports` 0.0019669532775879
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.0004889965057373
(164) DESCRIBE `ports` 0.0028259754180908
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00029492378234863
(166) DESCRIBE `ports` 0.0017440319061279
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 309))) 0.00070905685424805
(168) DESCRIBE `ports` 0.002000093460083
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '309') 0.00055098533630371
(170) DESCRIBE `ports` 0.0021319389343262
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1247))) 0.00054717063903809
(172) DESCRIBE `ports` 0.0019290447235107
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1247') 0.00041389465332031
(174) DESCRIBE `avid_specials` 0.0014729499816895
(175) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 40595 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.0014870166778564
(176) DESCRIBE `cruiselines` 0.0022850036621094
(177) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 2.0980834960938E-5
(178) DESCRIBE `orchid_image` 0.0017530918121338
(179) DESCRIBE `cruiselines` 0.0017521381378174
(180) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00040602684020996
(181) DESCRIBE `cruises` 0.0027461051940918
(182) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '45258') 0.00037407875061035
(183) DESCRIBE `ships` 0.0028719902038574
(184) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 517))) 0.00040411949157715
(185) DESCRIBE `ships` 0.0026211738586426
(186) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '517') 0.0003821849822998
(187) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 9.5129013061523E-5
(188) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00022792816162109
(189) DESCRIBE `itineraries` 0.00154709815979
(190) DESCRIBE `ports` 0.0019919872283936
(191) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00013494491577148
(192) DESCRIBE `ports` 0.0013768672943115
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00053596496582031
(194) DESCRIBE `ports` 0.0020060539245605
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00021791458129883
(196) DESCRIBE `sailingdates` 0.0016300678253174
(197) DESCRIBE `ports` 0.0021500587463379
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00053691864013672
(199) DESCRIBE `ports` 0.0017910003662109
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00014996528625488
(201) DESCRIBE `ports` 0.0014090538024902
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00053715705871582
(203) DESCRIBE `ports` 0.0018320083618164
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00036811828613281
(205) DESCRIBE `ports` 0.0017988681793213
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00012898445129395
(207) DESCRIBE `ports` 0.0013039112091064
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00029206275939941
(209) DESCRIBE `ports` 0.0013589859008789
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 288))) 0.00035285949707031
(211) DESCRIBE `ports` 0.0014538764953613
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '288') 0.00035905838012695
(213) DESCRIBE `ports` 0.0014541149139404
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0.00039982795715332
(215) DESCRIBE `ports` 0.001629114151001
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00033187866210938
(217) DESCRIBE `ports` 0.0009610652923584
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 285))) 0.00072002410888672
(219) DESCRIBE `ports` 0.0014359951019287
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '285') 0
(221) DESCRIBE `ports` 0.0016810894012451
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 269))) 0
(223) DESCRIBE `ports` 0.0011019706726074
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '269') 0.00013303756713867
(225) DESCRIBE `ports` 0.001655101776123
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00039196014404297
(227) DESCRIBE `ports` 0.0013880729675293
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00030684471130371
(229) DESCRIBE `avid_specials` 0.0017430782318115
(230) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 45258 and class = 'Cruise') OR (item_id = 517 AND class = 'Ship') OR (item_id = 47 AND class = 'CruiseLine') OR (item_id = 43 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0019791126251221
(231) DESCRIBE `cruiselines` 0.0022740364074707
(232) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 47))) 0.00024509429931641
(233) DESCRIBE `orchid_image` 0.0016810894012451
(234) DESCRIBE `cruiselines` 0.0017659664154053
(235) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '47') 0
(236) DESCRIBE `cruises` 0.0030431747436523
(237) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '48299') 0.0004270076751709
(238) DESCRIBE `ships` 0.0038249492645264
(239) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1205))) 0.00062394142150879
(240) DESCRIBE `ships` 0.0039057731628418
(241) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1205') 0.00057482719421387
(242) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00043106079101562
(243) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032711029052734
(244) DESCRIBE `itineraries` 0.0019659996032715
(245) DESCRIBE `ports` 0.0020020008087158
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00045394897460938
(247) DESCRIBE `ports` 0.0017869472503662
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00030803680419922
(249) DESCRIBE `ports` 0.0018470287322998
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.00043892860412598
(251) DESCRIBE `sailingdates` 0.0015621185302734
(252) DESCRIBE `ports` 0.0020110607147217
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.0004279613494873
(254) DESCRIBE `ports` 0.0018651485443115
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.0003969669342041
(256) DESCRIBE `ports` 0.0017819404602051
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.0003209114074707
(258) DESCRIBE `ports` 0.001600980758667
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00032210350036621
(260) DESCRIBE `ports` 0.0014729499816895
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00030684471130371
(262) DESCRIBE `ports` 0.0014770030975342
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00029706954956055
(264) DESCRIBE `ports` 0.0015079975128174
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.00027918815612793
(266) DESCRIBE `ports` 0.0015909671783447
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.00039005279541016
(268) DESCRIBE `ports` 0.0014438629150391
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00025296211242676
(270) DESCRIBE `ports` 0.0021309852600098
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00055718421936035
(272) DESCRIBE `ports` 0.0014839172363281
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3672))) 0.00062203407287598
(274) DESCRIBE `ports` 0.0015668869018555
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3672') 0.0003809928894043
(276) DESCRIBE `ports` 0.0018858909606934
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00051307678222656
(278) DESCRIBE `ports` 0.0018970966339111
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.0004429817199707
(280) DESCRIBE `ports` 0.0017378330230713
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00042414665222168
(282) DESCRIBE `ports` 0.0014488697052002
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00028300285339355
(284) DESCRIBE `ports` 0.0013899803161621
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00031614303588867
(286) DESCRIBE `ports` 0.0016579627990723
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00027918815612793
(288) DESCRIBE `ports` 0.0013241767883301
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00037908554077148
(290) DESCRIBE `ports` 0.0017378330230713
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.0003821849822998
(292) DESCRIBE `avid_specials` 0.0013349056243896
(293) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 48299 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.0039680004119873
(294) DESCRIBE `cruiselines` 0.0042622089385986
(295) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 191))) 0.00046396255493164
(296) DESCRIBE `orchid_image` 0.0019679069519043
(297) DESCRIBE `cruiselines` 0.0081799030303955
(298) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '191') 0.00076699256896973
(299) DESCRIBE `cruises` 0.0068612098693848
(300) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '51415') 0.00082993507385254
(301) DESCRIBE `ships` 0.003939151763916
(302) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1284))) 0.00089597702026367
(303) DESCRIBE `ships` 0.0036900043487549
(304) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1284') 0.00037693977355957
(305) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00035595893859863
(306) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00029897689819336
(307) DESCRIBE `itineraries` 0.0017910003662109
(308) DESCRIBE `ports` 0.0021791458129883
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00032782554626465
(310) DESCRIBE `ports` 0.0018069744110107
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00032806396484375
(312) DESCRIBE `ports` 0.0021889209747314
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00034999847412109
(314) DESCRIBE `sailingdates` 0.0072410106658936
(315) DESCRIBE `ports` 0.0028719902038574
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.00040197372436523
(317) DESCRIBE `ports` 0.0013358592987061
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.00035190582275391
(319) DESCRIBE `ports` 0.010829210281372
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 499))) 0.00043797492980957
(321) DESCRIBE `ports` 0.0014548301696777
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '499') 0.00033783912658691
(323) DESCRIBE `ports` 0.001521110534668
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00036001205444336
(325) DESCRIBE `ports` 0.0014348030090332
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.00029993057250977
(327) DESCRIBE `ports` 0.0015311241149902
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 22))) 0.00042891502380371
(329) DESCRIBE `ports` 0.0016520023345947
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '22') 0.0076050758361816
(331) DESCRIBE `ports` 0.001986026763916
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2360))) 0.00050711631774902
(333) DESCRIBE `ports` 0.0018389225006104
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2360') 0.00040411949157715
(335) DESCRIBE `ports` 0.0018351078033447
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 27))) 0.005789041519165
(337) DESCRIBE `ports` 0.0019609928131104
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '27') 0.0004429817199707
(339) DESCRIBE `avid_specials` 0.0016050338745117
(340) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 51415 and class = 'Cruise') OR (item_id = 1284 AND class = 'Ship') OR (item_id = 37 AND class = 'CruiseLine') OR (item_id = 8 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.0018880367279053
(341) DESCRIBE `cruiselines` 0.0085000991821289
(342) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00046706199645996
(343) DESCRIBE `orchid_image` 0.0020170211791992
(344) DESCRIBE `cruiselines` 0.0094330310821533
(345) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00049495697021484
(346) DESCRIBE `cruises` 0.0032119750976562
(347) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55033') 0.00040197372436523
(348) DESCRIBE `ships` 0.0032889842987061
(349) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 262))) 0.0090670585632324
(350) DESCRIBE `ships` 0.0036799907684326
(351) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '262') 0.00047016143798828
(352) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00037598609924316
(353) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031208992004395
(354) DESCRIBE `itineraries` 0.0017800331115723
(355) DESCRIBE `ports` 0.008929967880249
(356) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00047206878662109
(357) DESCRIBE `ports` 0.0018270015716553
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00040602684020996
(359) DESCRIBE `ports` 0.0018150806427002
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.0003659725189209
(361) DESCRIBE `sailingdates` 0.0071179866790771
(362) DESCRIBE `ports` 0.0018560886383057
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00048184394836426
(364) DESCRIBE `ports` 0.001845121383667
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.00030303001403809
(366) DESCRIBE `ports` 0.0078549385070801
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1229))) 0.0004880428314209
(368) DESCRIBE `ports` 0.0018489360809326
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1229') 0.00040793418884277
(370) DESCRIBE `ports` 0.0018651485443115
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.0064840316772461
(372) DESCRIBE `ports` 0.0029139518737793
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.00053191184997559
(374) DESCRIBE `ports` 0.0029430389404297
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 142))) 0.0023651123046875
(376) DESCRIBE `ports` 0.0020499229431152
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '142') 0.0094079971313477
(378) DESCRIBE `ports` 0.0026588439941406
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 112))) 0.00046205520629883
(380) DESCRIBE `ports` 0.0017189979553223
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '112') 0.00032401084899902
(382) DESCRIBE `ports` 0.0019750595092773
(383) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 141))) 0.00057721138000488
(384) DESCRIBE `ports` 0.0029540061950684
(385) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '141') 0.0095558166503906
(386) DESCRIBE `avid_specials` 0.0018308162689209
(387) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55033 and class = 'Cruise') OR (item_id = 262 AND class = 'Ship') OR (item_id = 26 AND class = 'CruiseLine') OR (item_id = 34 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.0017180442810059
(388) DESCRIBE `cruiselines` 0.0028350353240967
(389) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 26))) 0.0060451030731201
(390) DESCRIBE `orchid_image` 0.0022079944610596
(391) DESCRIBE `cruiselines` 0.0027759075164795
(392) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '26') 0.00049614906311035
(393) DESCRIBE `cruises` 0.012170791625977
(394) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55784') 0.00051188468933105
(395) DESCRIBE `ships` 0.0034701824188232
(396) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1090))) 0.00058293342590332
(397) DESCRIBE `ships` 0.0035951137542725
(398) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1090') 0.0081088542938232
(399) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031089782714844
(400) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027108192443848
(401) DESCRIBE `itineraries` 0.001849889755249
(402) DESCRIBE `ports` 0.0019040107727051
(403) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.010560035705566
(404) DESCRIBE `ports` 0.0020029544830322
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00042986869812012
(406) DESCRIBE `ports` 0.0018420219421387
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00043392181396484
(408) DESCRIBE `sailingdates` 0.0015709400177002
(409) DESCRIBE `ports` 0.0017061233520508
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00043988227844238
(411) DESCRIBE `ports` 0.0013809204101562
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.0092639923095703
(413) DESCRIBE `ports` 0.001863956451416
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.0004279613494873
(415) DESCRIBE `ports` 0.0016720294952393
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00038695335388184
(417) DESCRIBE `ports` 0.0016129016876221
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00042104721069336
(419) DESCRIBE `ports` 0.001708984375
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00034618377685547
(421) DESCRIBE `ports` 0.0016000270843506
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2914))) 0.0084338188171387
(423) DESCRIBE `ports` 0.0019321441650391
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2914') 0.00036501884460449
(425) DESCRIBE `ports` 0.0014400482177734
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00045990943908691
(427) DESCRIBE `ports` 0.0018050670623779
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00040912628173828
(429) DESCRIBE `ports` 0.0016770362854004
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.0073330402374268
(431) DESCRIBE `ports` 0.001514196395874
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00029206275939941
(433) DESCRIBE `ports` 0.0014419555664062
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2186))) 0.00040793418884277
(435) DESCRIBE `ports` 0.011011123657227
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2186') 0.00038313865661621
(437) DESCRIBE `ports` 0.0013759136199951
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00037813186645508
(439) DESCRIBE `ports` 0.0013439655303955
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00019001960754395
(441) DESCRIBE `ports` 0.0015068054199219
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00027704238891602
(443) DESCRIBE `ports` 0.0015149116516113
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.0090551376342773
(445) DESCRIBE `avid_specials` 0.0018432140350342
(446) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55784 and class = 'Cruise') OR (item_id = 1090 AND class = 'Ship') OR (item_id = 77 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.0018539428710938
(447) DESCRIBE `cruiselines` 0.0029189586639404
(448) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00054478645324707
(449) DESCRIBE `orchid_image` 0.0021679401397705
(450) DESCRIBE `cruiselines` 0.010486125946045
(451) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00046992301940918
(452) DESCRIBE `cruises` 0.0035300254821777
(453) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55793') 0.0061829090118408
(454) DESCRIBE `ships` 0.0030279159545898
(455) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1025))) 0.00038909912109375
(456) DESCRIBE `ships` 0.0030770301818848
(457) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1025') 0.0061359405517578
(458) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003211498260498
(459) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00031399726867676
(460) DESCRIBE `itineraries` 0.0014948844909668
(461) DESCRIBE `ports` 0.0014989376068115
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.0089490413665771
(463) DESCRIBE `ports` 0.0016219615936279
(464) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00031709671020508
(465) DESCRIBE `ports` 0.0013539791107178
(466) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00029087066650391
(467) DESCRIBE `sailingdates` 0.0011849403381348
(468) DESCRIBE `ports` 0.0015032291412354
(469) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00039100646972656
(470) DESCRIBE `ports` 0.0014021396636963
(471) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00031805038452148
(472) DESCRIBE `ports` 0.0012679100036621
(473) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2186))) 0.0090138912200928
(474) DESCRIBE `ports` 0.0015318393707275
(475) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2186') 0.0004270076751709
(476) DESCRIBE `ports` 0.0018858909606934
(477) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00045299530029297
(478) DESCRIBE `ports` 0.0018951892852783
(479) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00031781196594238
(480) DESCRIBE `ports` 0.0013501644134521
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1573))) 0.00027990341186523
(482) DESCRIBE `ports` 0.0013258457183838
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1573') 0
(484) DESCRIBE `ports` 0.001798152923584
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00057482719421387
(486) DESCRIBE `ports` 0.0012891292572021
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00089192390441895
(488) DESCRIBE `ports` 0.0011038780212402
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2914))) 0.00031089782714844
(490) DESCRIBE `ports` 0.0014259815216064
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2914') 0.00034999847412109
(492) DESCRIBE `ports` 0.0013999938964844
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00035309791564941
(494) DESCRIBE `ports` 0.0015029907226562
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00035405158996582
(496) DESCRIBE `ports` 0.0011839866638184
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00036096572875977
(498) DESCRIBE `ports` 0.0013649463653564
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0
(500) DESCRIBE `ports` 0.00063085556030273
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0
(502) DESCRIBE `ports` 0.0010519027709961
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00019097328186035
(504) DESCRIBE `ports` 0.0016701221466064
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0
(506) DESCRIBE `ports` 0.0014111995697021
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0
(508) DESCRIBE `avid_specials` 0.0014979839324951
(509) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55793 and class = 'Cruise') OR (item_id = 1025 AND class = 'Ship') OR (item_id = 77 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.0012409687042236
(510) DESCRIBE `cruiselines` 0.0023949146270752
(511) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00035381317138672
(512) DESCRIBE `orchid_image` 0.0020589828491211
(513) DESCRIBE `cruiselines` 0.00118088722229
(514) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0
(515) DESCRIBE `cruises` 0.0027620792388916
(516) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55810') 0
(517) DESCRIBE `ships` 0.0024352073669434
(518) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1343))) 0.00048303604125977
(519) DESCRIBE `ships` 0.003223180770874
(520) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1343') 0.0006868839263916
(521) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002748966217041
(522) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00036001205444336
(523) DESCRIBE `itineraries` 0.0019810199737549
(524) DESCRIBE `ports` 0.0017008781433105
(525) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.000823974609375
(526) DESCRIBE `ports` 0.0018570423126221
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00032210350036621
(528) DESCRIBE `ports` 0.0012490749359131
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00035715103149414
(530) DESCRIBE `sailingdates` 0.0012481212615967
(531) DESCRIBE `ports` 0.0016191005706787
(532) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00043201446533203
(533) DESCRIBE `ports` 0.0017950534820557
(534) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00029802322387695
(535) DESCRIBE `ports` 0.0016441345214844
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2004))) 0.00037789344787598
(537) DESCRIBE `ports` 0.0013778209686279
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2004') 0.00016903877258301
(539) DESCRIBE `ports` 0.0014669895172119
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00034999847412109
(541) DESCRIBE `ports` 0.0013179779052734
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00039291381835938
(543) DESCRIBE `ports` 0.0015029907226562
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1068))) 0.00017809867858887
(545) DESCRIBE `ports` 0.001655101776123
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1068') 0.00039196014404297
(547) DESCRIBE `ports` 0.0016350746154785
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00044798851013184
(549) DESCRIBE `ports` 0.0014040470123291
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00030016899108887
(551) DESCRIBE `ports` 0.0016131401062012
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00039100646972656
(553) DESCRIBE `ports` 0.0014181137084961
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00025701522827148
(555) DESCRIBE `ports` 0.0015108585357666
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00033020973205566
(557) DESCRIBE `ports` 0.0014369487762451
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00035405158996582
(559) DESCRIBE `ports` 0.0017299652099609
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3685))) 0.00039291381835938
(561) DESCRIBE `ports` 0.0017819404602051
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3685') 0.00041913986206055
(563) DESCRIBE `ports` 0.0015931129455566
(564) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00045204162597656
(565) DESCRIBE `ports` 0.0017919540405273
(566) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00044393539428711
(567) DESCRIBE `avid_specials` 0.0016860961914062
(568) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55810 and class = 'Cruise') OR (item_id = 1343 AND class = 'Ship') OR (item_id = 77 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.0017750263214111
(569) DESCRIBE `cruiselines` 0.002814769744873
(570) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00031781196594238
(571) DESCRIBE `orchid_image` 0.0020778179168701
(572) DESCRIBE `cruiselines` 0.0027501583099365
(573) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00031208992004395
(574) DESCRIBE `cruiselines` 0.0027279853820801
(575) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '7', '12', '23', '171', '144', '18', '20', '101', '31', '8', '96', '131', '183', '239', '120', '191', '206', '50', '103', '29', '15', '221', '33', '28', '262', '24', '91', '268', '114', '110', '156', '37', '208', '141', '14', '187', '153', '118', '49', '211', '151', '30', '232', '258', '216', '181', '212', '36', '4', '140', '225', '238', '249', '256', '204', '47', '113', '16', '174', '90', '261', '35', '182', '230', '88', '188', '136', '237', '264', '159', '195', '146', '115', '213', '220', '180', '57', '64', '73', '248', '196', '209', '95', '168', '52', '184', '219', '59', '231', '170', '229', '116', '82', '119', '244', '105', '134', '108', '276', '48', '275', '240', '269', '132', '266', '224', '210')) ORDER BY FIND_IN_SET(id, '218,77,19,26,7,12,23,171,144,18,20,101,31,8,96,131,183,239,120,191,206,50,103,29,15,221,33,28,262,24,91,268,114,110,156,37,208,141,14,187,153,118,49,211,151,30,232,258,216,181,212,36,4,140,225,238,249,256,204,47,113,16,174,90,261,35,182,230,88,188,136,237,264,159,195,146,115,213,220,180,57,64,73,248,196,209,95,168,52,184,219,59,231,170,229,116,82,119,244,105,134,108,276,48,275,240,269,132,266,224,210') 0.0083460807800293
(576) DESCRIBE `ships` 0.0040619373321533
(577) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1032', '1292', '1205', '1199', '1359', '977', '1291', '454', '1272', '1247', '1554', '1555', '1599', '855', '986', '1237', '1594', '1588', '1067', '258', '407', '1677', '34', '22', '27', '37', '38', '378', '461', '21', '28', '31', '393', '817', '1135', '780', '30', '36', '349', '726', '1012', '1424', '39', '1422', '35', '1419', '1423', '1420', '1415', '1418', '1421', '404', '882', '1176', '462', '113', '1215', '1245', '1405', '766', '24', '330', '711', '11', '1574', '439', '452', '9', '265', '10', '455', '1607', '1744', '1141', '585', '542', '739', '1572', '124', '635', '674', '770', '573', '3', '5', '874', '792', '1454', '340', '1372', '116', '580', '351', '716', '1193', '338', '553', '1168', '1302', '520', '797', '1284', '1460', '25', '66', '1402', '1471', '160', '285', '974', '1021', '332', '1095', '1455', '207', '253', '4', '43', '390', '748', '111', '658', '993', '1172', '1325', '791', '1260', '1320', '1678', '81', '517', '1259', '1323', '1562', '406', '1195', '582', '590', '678', '286', '434', '1068', '1575', '119', '327', '526', '559', '970', '616', '63', '108', '421', '854', '78', '375', '401', '657', '883', '1266', '547', '1139', '1571', '1586', '84', '722', '1208', '1569', '775', '1492', '150', '335', '850', '1008', '1236', '1398', '1587', '114', '1308', '1437', '14', '784', '152', '403', '958', '1268', '1672', '151', '1064', '1108', '1289', '1319', '1724', '148', '405', '451', '652', '704', '715', '823', '966', '1088', '325', '348', '683', '1282', '1321', '123', '162', '790', '1243', '262', '389', '1013', '1143', '1159', '1269', '1330', '1348', '1389', '732', '75', '163', '441', '483', '1270', '1326', '1327', '1526', '1579', '508', '1151', '1214', '1557', '1561', '314', '333', '1367', '394', '626', '1318', '1376', '93', '287', '290', '545', '1711', '1075', '1602', '82', '98', '521', '651', '796', '968', '1344', '1539', '1722', '149', '673', '751', '768', '818', '884', '1027', '1040', '1137', '1144', '1163', '1216', '1343', '1717', '201', '291', '743', '852', '1160', '1223', '1373', '1409', '385', '769', '1063', '1157', '1452', '1453', '1604', '1738', '776', '1025', '1090', '1136', '1283', '1301', '1303', '1540', '1552', '45', '223', '341', '1217', '1241', '1413', '105', '485', '516', '669', '811', '1043', '1073', '1233', '1345', '1426', '1449', '1704', '266', '324', '467', '1019', '1152', '1358', '1632', '448', '503', '639', '701', '885', '888', '905', '1029', '1145', '1218', '1226', '1253', '1411', '1448', '1566', '1682', '795', '859', '988', '1150', '1742', '352', '601', '1322', '1647', '1676', '1740', '74', '417', '610', '731', '738', '1149', '1458', '1026', '1188', '493', '494', '973', '1055', '1231', '1351', '1408', '1489', '1496', '1505', '1580', '666', '954', '1034', '1047', '1049', '1366', '1474', '147', '205', '618', '851', '1229', '1230', '1516', '1609', '1716', '208', '836', '1154', '1362', '1368', '1444', '1470', '423', '663', '709', '920', '927', '1262', '1463', '1619', '204', '921', '931', '996', '1004', '1020', '1222', '1285', '1354', '1407', '1410', '1508', '1627', '1713', '1715', '703', '914', '923', '1196', '1518', '1714', '643', '717', '915', '916', '926', '930', '1003', '1037', '1072', '1106', '1224', '1240', '1521', '1581', '1673', '1743', '422', '924', '1017', '1042', '1138', '1352', '1404', '1486', '1567', '1593', '1596', '1606', '499', '972', '1175', '1187', '1360', '1361', '1459', '1522', '479', '671', '672', '781', '1001', '1051', '1148', '1254', '1412', '1445', '1517', '17', '656', '837', '1054', '1382', '1417', '665', '938', '994', '1002', '1514', '1601', '1708', '1751', '504', '985', '1005', '1045', '1053', '1684', '1723', '420', '453', '574', '761', '821', '982', '995', '1028', '1729', '857', '937')) ORDER BY FIND_IN_SET(id, '1127,1032,1292,1205,1199,1359,977,1291,454,1272,1247,1554,1555,1599,855,986,1237,1594,1588,1067,258,407,1677,34,22,27,37,38,378,461,21,28,31,393,817,1135,780,30,36,349,726,1012,1424,39,1422,35,1419,1423,1420,1415,1418,1421,404,882,1176,462,113,1215,1245,1405,766,24,330,711,11,1574,439,452,9,265,10,455,1607,1744,1141,585,542,739,1572,124,635,674,770,573,3,5,874,792,1454,340,1372,116,580,351,716,1193,338,553,1168,1302,520,797,1284,1460,25,66,1402,1471,160,285,974,1021,332,1095,1455,207,253,4,43,390,748,111,658,993,1172,1325,791,1260,1320,1678,81,517,1259,1323,1562,406,1195,582,590,678,286,434,1068,1575,119,327,526,559,970,616,63,108,421,854,78,375,401,657,883,1266,547,1139,1571,1586,84,722,1208,1569,775,1492,150,335,850,1008,1236,1398,1587,114,1308,1437,14,784,152,403,958,1268,1672,151,1064,1108,1289,1319,1724,148,405,451,652,704,715,823,966,1088,325,348,683,1282,1321,123,162,790,1243,262,389,1013,1143,1159,1269,1330,1348,1389,732,75,163,441,483,1270,1326,1327,1526,1579,508,1151,1214,1557,1561,314,333,1367,394,626,1318,1376,93,287,290,545,1711,1075,1602,82,98,521,651,796,968,1344,1539,1722,149,673,751,768,818,884,1027,1040,1137,1144,1163,1216,1343,1717,201,291,743,852,1160,1223,1373,1409,385,769,1063,1157,1452,1453,1604,1738,776,1025,1090,1136,1283,1301,1303,1540,1552,45,223,341,1217,1241,1413,105,485,516,669,811,1043,1073,1233,1345,1426,1449,1704,266,324,467,1019,1152,1358,1632,448,503,639,701,885,888,905,1029,1145,1218,1226,1253,1411,1448,1566,1682,795,859,988,1150,1742,352,601,1322,1647,1676,1740,74,417,610,731,738,1149,1458,1026,1188,493,494,973,1055,1231,1351,1408,1489,1496,1505,1580,666,954,1034,1047,1049,1366,1474,147,205,618,851,1229,1230,1516,1609,1716,208,836,1154,1362,1368,1444,1470,423,663,709,920,927,1262,1463,1619,204,921,931,996,1004,1020,1222,1285,1354,1407,1410,1508,1627,1713,1715,703,914,923,1196,1518,1714,643,717,915,916,926,930,1003,1037,1072,1106,1224,1240,1521,1581,1673,1743,422,924,1017,1042,1138,1352,1404,1486,1567,1593,1596,1606,499,972,1175,1187,1360,1361,1459,1522,479,671,672,781,1001,1051,1148,1254,1412,1445,1517,17,656,837,1054,1382,1417,665,938,994,1002,1514,1601,1708,1751,504,985,1005,1045,1053,1684,1723,420,453,574,761,821,982,995,1028,1729,857,937') 0.05971097946167
(578) DESCRIBE `cruisetypes` 0.0063631534576416
(579) DESCRIBE `destinations` 0.0055809020996094
(580) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '25', '37', '43', '9', '2', '8', '53', '55', '39', '28', '38', '40', '7', '26', '30', '48', '11', '21', '45', '29', '49', '56', '44', '34', '10', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,25,37,43,9,2,8,53,55,39,28,38,40,7,26,30,48,11,21,45,29,49,56,44,34,10,52,46,32') 0.0019810199737549