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

Total elapsed time: 0.79153561592102

# Query Time
(1) connect 0.00097894668579102
(2) DESCRIBE `cruises` 0.0039918422698975
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (68562, 63785, 71368, 62066, 74190, 58747, 62662, 71371, 66811, 74647)) ORDER BY FIND_IN_SET(id, '68562,63785,71368,62066,74190,58747,62662,71371,66811,74647') 0.0021779537200928
(4) DESCRIBE `specials` 0.0035049915313721
(5) DESCRIBE `specials` 0.0039539337158203
(6) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1480605') 0.00040006637573242
(7) DESCRIBE `ships` 0.0029850006103516
(8) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1262))) 0.00045609474182129
(9) DESCRIBE `ships` 0.0028488636016846
(10) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1262') 0.00040006637573242
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00032496452331543
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00024795532226562
(13) DESCRIBE `itineraries` 0.0017249584197998
(14) DESCRIBE `ports` 0.0018060207366943
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00046205520629883
(16) DESCRIBE `ports` 0.0016350746154785
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00032210350036621
(18) DESCRIBE `ports` 0.0016229152679443
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00032591819763184
(20) DESCRIBE `specialsailingdates` 0.0022799968719482
(21) DESCRIBE `sailingdates` 0.0015571117401123
(22) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 431868))) 0.00053000450134277
(23) DESCRIBE `ports` 0.001896858215332
(24) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 92))) 0.00054287910461426
(25) DESCRIBE `ports` 0.0017769336700439
(26) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '92') 0.00035905838012695
(27) DESCRIBE `ports` 0.0016419887542725
(28) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00031709671020508
(29) DESCRIBE `ports` 0.0012550354003906
(30) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00027799606323242
(31) DESCRIBE `ports` 0.0012891292572021
(32) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1263))) 0.0005638599395752
(33) DESCRIBE `ports` 0.0017819404602051
(34) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1263') 0.00034809112548828
(35) DESCRIBE `ports` 0.0018079280853271
(36) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00038814544677734
(37) DESCRIBE `ports` 0.0017588138580322
(38) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.0004119873046875
(39) DESCRIBE `ports` 0.0017499923706055
(40) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.00037598609924316
(41) DESCRIBE `ports` 0.0014169216156006
(42) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.00026917457580566
(43) DESCRIBE `ports` 0.0012660026550293
(44) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 160))) 0.0002899169921875
(45) DESCRIBE `ports` 0.0013220310211182
(46) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '160') 0.00035905838012695
(47) DESCRIBE `ports` 0.001823902130127
(48) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2087))) 0.00037789344787598
(49) DESCRIBE `ports` 0.0017530918121338
(50) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2087') 0.00035500526428223
(51) DESCRIBE `ports` 0.0017459392547607
(52) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00035810470581055
(53) DESCRIBE `ports` 0.0013430118560791
(54) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.0002751350402832
(55) DESCRIBE `cruises` 0.0025229454040527
(56) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 68562))) 0.00040006637573242
(57) DESCRIBE `avid_specials` 0.0011188983917236
(58) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1480605 and class = 'Special') OR (item_id = 68562 and class = 'Cruise') OR (item_id = 1262 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.0011258125305176
(59) DESCRIBE `cruiselines` 0.0018060207366943
(60) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.0003199577331543
(61) DESCRIBE `orchid_image` 0.0014150142669678
(62) DESCRIBE `cruiselines` 0.0018811225891113
(63) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00033307075500488
(64) DESCRIBE `specials` 0.0039188861846924
(65) DESCRIBE `specials` 0.004019021987915
(66) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1475648') 0.00036907196044922
(67) DESCRIBE `ships` 0.0027289390563965
(68) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 547))) 0.00033783912658691
(69) DESCRIBE `ships` 0.0026469230651855
(70) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '547') 0.00026893615722656
(71) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00027990341186523
(72) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00024890899658203
(73) DESCRIBE `itineraries` 0.0022759437561035
(74) DESCRIBE `ports` 0.001305103302002
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00031709671020508
(76) DESCRIBE `ports` 0.001248836517334
(77) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00028610229492188
(78) DESCRIBE `ports` 0.0012509822845459
(79) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00028800964355469
(80) DESCRIBE `specialsailingdates` 0.0010490417480469
(81) DESCRIBE `sailingdates` 0.001105785369873
(82) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 449648))) 0.00042486190795898
(83) DESCRIBE `ports` 0.0012860298156738
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0002899169921875
(85) DESCRIBE `ports` 0.0012650489807129
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00036978721618652
(87) DESCRIBE `ports` 0.0013070106506348
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00029993057250977
(89) DESCRIBE `ports` 0.0013260841369629
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00026702880859375
(91) DESCRIBE `ports` 0.0013461112976074
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00027203559875488
(93) DESCRIBE `ports` 0.0013000965118408
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00025796890258789
(95) DESCRIBE `ports` 0.0012691020965576
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00028300285339355
(97) DESCRIBE `ports` 0.0013289451599121
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00028705596923828
(99) DESCRIBE `ports` 0.0013368129730225
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00028491020202637
(101) DESCRIBE `ports` 0.001262903213501
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00029301643371582
(103) DESCRIBE `ports` 0.001255989074707
(104) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00028514862060547
(105) DESCRIBE `ports` 0.0012462139129639
(106) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00026798248291016
(107) DESCRIBE `ports` 0.0013759136199951
(108) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00028800964355469
(109) DESCRIBE `ports` 0.0013351440429688
(110) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00028610229492188
(111) DESCRIBE `ports` 0.0013079643249512
(112) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 0.00029706954956055
(113) DESCRIBE `ports` 0.0013289451599121
(114) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00030708312988281
(115) DESCRIBE `ports` 0.0014770030975342
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00033211708068848
(117) DESCRIBE `ports` 0.0012450218200684
(118) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00026702880859375
(119) DESCRIBE `ports` 0.0013241767883301
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00034308433532715
(121) DESCRIBE `ports` 0.0013179779052734
(122) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00029492378234863
(123) DESCRIBE `ports` 0.0013980865478516
(124) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030088424682617
(125) DESCRIBE `ports` 0.0013208389282227
(126) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029706954956055
(127) DESCRIBE `cruises` 0.0026559829711914
(128) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 63785))) 0.00050616264343262
(129) DESCRIBE `avid_specials` 0.0012528896331787
(130) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1475648 and class = 'Special') OR (item_id = 63785 and class = 'Cruise') OR (item_id = 547 AND class = 'Ship') OR (item_id = 18 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.0010178089141846
(131) DESCRIBE `cruiselines` 0.0019221305847168
(132) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00042605400085449
(133) DESCRIBE `orchid_image` 0.0015311241149902
(134) DESCRIBE `cruiselines` 0.001788854598999
(135) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00034403800964355
(136) DESCRIBE `specials` 0.0043289661407471
(137) DESCRIBE `specials` 0.0031719207763672
(138) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1483909') 0.00039196014404297
(139) DESCRIBE `ships` 0.0027041435241699
(140) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 75))) 0.0003669261932373
(141) DESCRIBE `ships` 0.0025479793548584
(142) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '75') 0.00032210350036621
(143) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031089782714844
(144) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00028800964355469
(145) DESCRIBE `itineraries` 0.0025420188903809
(146) DESCRIBE `ports` 0.0014479160308838
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00039505958557129
(148) DESCRIBE `ports` 0.0014369487762451
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00036311149597168
(150) DESCRIBE `ports` 0.0012738704681396
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00031900405883789
(152) DESCRIBE `specialsailingdates` 0.0010709762573242
(153) DESCRIBE `sailingdates` 0.001121997833252
(154) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 453235))) 0.00057291984558105
(155) DESCRIBE `ports` 0.0017731189727783
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 451))) 0.00034809112548828
(157) DESCRIBE `ports` 0.0012989044189453
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '451') 0.00029993057250977
(159) DESCRIBE `ports` 0.0011849403381348
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1265))) 0.0003058910369873
(161) DESCRIBE `ports` 0.0015110969543457
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1265') 0.00028800964355469
(163) DESCRIBE `ports` 0.0013101100921631
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1341))) 0.00031805038452148
(165) DESCRIBE `ports` 0.0013179779052734
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1341') 0.00027894973754883
(167) DESCRIBE `ports` 0.0028350353240967
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1177))) 0.00032305717468262
(169) DESCRIBE `ports` 0.001309871673584
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1177') 0.00035786628723145
(171) DESCRIBE `ports` 0.00140380859375
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1044))) 0.00031781196594238
(173) DESCRIBE `ports` 0.0014488697052002
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1044') 0.00029611587524414
(175) DESCRIBE `ports` 0.0012941360473633
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 88))) 0.00031781196594238
(177) DESCRIBE `ports` 0.0014469623565674
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '88') 0.00030708312988281
(179) DESCRIBE `ports` 0.0013439655303955
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00030779838562012
(181) DESCRIBE `ports` 0.0014019012451172
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00028610229492188
(183) DESCRIBE `ports` 0.001305103302002
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1758))) 0.00025010108947754
(185) DESCRIBE `ports` 0.0013439655303955
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1758') 0.00027585029602051
(187) DESCRIBE `ports` 0.0014681816101074
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 419))) 0.00034189224243164
(189) DESCRIBE `ports` 0.0012779235839844
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '419') 0.0002739429473877
(191) DESCRIBE `ports` 0.0014591217041016
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00034403800964355
(193) DESCRIBE `ports` 0.0013489723205566
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00034689903259277
(195) DESCRIBE `cruises` 0.0027890205383301
(196) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71368))) 0.00037503242492676
(197) DESCRIBE `avid_specials` 0.0011460781097412
(198) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1483909 and class = 'Special') OR (item_id = 71368 and class = 'Cruise') OR (item_id = 75 AND class = 'Ship') OR (item_id = 18 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.0011429786682129
(199) DESCRIBE `cruiselines` 0.002284049987793
(200) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.0005340576171875
(201) DESCRIBE `orchid_image` 0.0014679431915283
(202) DESCRIBE `cruiselines` 0.0019199848175049
(203) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.0003049373626709
(204) DESCRIBE `specials` 0.0043208599090576
(205) DESCRIBE `specials` 0.0048980712890625
(206) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1480537') 0.00046205520629883
(207) DESCRIBE `ships` 0.0035371780395508
(208) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1262))) 0.00048184394836426
(209) DESCRIBE `ships` 0.0035719871520996
(210) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1262') 0.0003972053527832
(211) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034117698669434
(212) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033903121948242
(213) DESCRIBE `itineraries` 0.0016999244689941
(214) DESCRIBE `ports` 0.0019948482513428
(215) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00048017501831055
(216) DESCRIBE `ports` 0.0018949508666992
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00041294097900391
(218) DESCRIBE `ports` 0.0015721321105957
(219) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00029206275939941
(220) DESCRIBE `specialsailingdates` 0.0011122226715088
(221) DESCRIBE `sailingdates` 0.0011649131774902
(222) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 431869))) 0.00032591819763184
(223) DESCRIBE `sailingdates` 0.0011889934539795
(224) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 431870))) 0.00028204917907715
(225) DESCRIBE `ports` 0.0012831687927246
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00029921531677246
(227) DESCRIBE `ports` 0.0015380382537842
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00027203559875488
(229) DESCRIBE `ports` 0.0018439292907715
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00031685829162598
(231) DESCRIBE `ports` 0.0013160705566406
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00032281875610352
(233) DESCRIBE `ports` 0.0012960433959961
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0
(235) DESCRIBE `ports` 0.0015249252319336
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0
(237) DESCRIBE `ports` 0.0014560222625732
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2087))) 0.00036501884460449
(239) DESCRIBE `ports` 0.0014820098876953
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2087') 0.00031685829162598
(241) DESCRIBE `ports` 0.0014300346374512
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4696))) 0.00034284591674805
(243) DESCRIBE `ports` 0.0013928413391113
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4696') 0.00029611587524414
(245) DESCRIBE `ports` 0.0013971328735352
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 160))) 0.0003058910369873
(247) DESCRIBE `ports` 0.0013351440429688
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '160') 0.00032591819763184
(249) DESCRIBE `ports` 0.0013349056243896
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 317))) 0.00030398368835449
(251) DESCRIBE `ports` 0.0014498233795166
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '317') 0.0003659725189209
(253) DESCRIBE `ports` 0.0017600059509277
(254) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00043106079101562
(255) DESCRIBE `ports` 0.0017421245574951
(256) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.0003509521484375
(257) DESCRIBE `ports` 0.0018899440765381
(258) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00042605400085449
(259) DESCRIBE `ports` 0.0019388198852539
(260) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00035786628723145
(261) DESCRIBE `ports` 0.0017499923706055
(262) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00031685829162598
(263) DESCRIBE `ports` 0.0013480186462402
(264) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00027990341186523
(265) DESCRIBE `cruises` 0.0024840831756592
(266) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 62066))) 0.00044012069702148
(267) DESCRIBE `avid_specials` 0.001701831817627
(268) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1480537 and class = 'Special') OR (item_id = 62066 and class = 'Cruise') OR (item_id = 1262 AND class = 'Ship') OR (item_id = 114 AND class = 'CruiseLine') OR (item_id = 7 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.0011341571807861
(269) DESCRIBE `cruiselines` 0.0019781589508057
(270) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 114))) 0.00034809112548828
(271) DESCRIBE `orchid_image` 0.0015010833740234
(272) DESCRIBE `cruiselines` 0.002432107925415
(273) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '114') 0.00096607208251953
(274) DESCRIBE `specials` 0.0035929679870605
(275) DESCRIBE `specials` 0.0028450489044189
(276) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1471453') 0.0003669261932373
(277) DESCRIBE `ships` 0.0030069351196289
(278) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 547))) 0.00050497055053711
(279) DESCRIBE `ships` 0.002875804901123
(280) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '547') 0.00030398368835449
(281) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026702880859375
(282) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00029110908508301
(283) DESCRIBE `itineraries` 0.0018289089202881
(284) DESCRIBE `ports` 0.0020058155059814
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036287307739258
(286) DESCRIBE `ports` 0.0012931823730469
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033402442932129
(288) DESCRIBE `ports` 0.001417875289917
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00033903121948242
(290) DESCRIBE `specialsailingdates` 0.0011880397796631
(291) DESCRIBE `sailingdates` 0.0012538433074951
(292) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 466390))) 0.00033092498779297
(293) DESCRIBE `ports` 0.001309871673584
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031614303588867
(295) DESCRIBE `ports` 0.0012681484222412
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029706954956055
(297) DESCRIBE `ports` 0.0013871192932129
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1230))) 0.00031208992004395
(299) DESCRIBE `ports` 0.0012929439544678
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1230') 0.00029611587524414
(301) DESCRIBE `ports` 0.0013680458068848
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00032711029052734
(303) DESCRIBE `ports` 0.0014300346374512
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00028181076049805
(305) DESCRIBE `ports` 0.0013439655303955
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 25))) 0.00030303001403809
(307) DESCRIBE `ports` 0.0013411045074463
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '25') 0.00033187866210938
(309) DESCRIBE `ports` 0.0015168190002441
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00035715103149414
(311) DESCRIBE `ports` 0.0014939308166504
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.00029492378234863
(313) DESCRIBE `ports` 0.001662015914917
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 21))) 0.00038599967956543
(315) DESCRIBE `ports` 0.0015950202941895
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '21') 0.0003659725189209
(317) DESCRIBE `ports` 0.001406192779541
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3978))) 0.00040006637573242
(319) DESCRIBE `ports` 0.0015668869018555
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3978') 0.0003509521484375
(321) DESCRIBE `ports` 0.0014810562133789
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3395))) 0.00031399726867676
(323) DESCRIBE `ports` 0.0013439655303955
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3395') 0.00027704238891602
(325) DESCRIBE `ports` 0.0013248920440674
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.0003659725189209
(327) DESCRIBE `ports` 0.0013020038604736
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00028514862060547
(329) DESCRIBE `ports` 0.0015108585357666
(330) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00035405158996582
(331) DESCRIBE `ports` 0.0012998580932617
(332) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.0004279613494873
(333) DESCRIBE `ports` 0.0015840530395508
(334) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 794))) 0.00040507316589355
(335) DESCRIBE `ports` 0.0017678737640381
(336) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '794') 0.00034999847412109
(337) DESCRIBE `ports` 0.0017688274383545
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2086))) 1.5020370483398E-5
(339) DESCRIBE `ports` 0.0013010501861572
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2086') 0.00027799606323242
(341) DESCRIBE `ports` 0.0012650489807129
(342) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030994415283203
(343) DESCRIBE `ports` 0.0012588500976562
(344) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00048112869262695
(345) DESCRIBE `cruises` 0.0026781558990479
(346) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 74190))) 0.00048208236694336
(347) DESCRIBE `avid_specials` 0.0011959075927734
(348) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1471453 and class = 'Special') OR (item_id = 74190 and class = 'Cruise') OR (item_id = 547 AND class = 'Ship') OR (item_id = 18 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.0010509490966797
(349) DESCRIBE `cruiselines` 0.0018470287322998
(350) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00034904479980469
(351) DESCRIBE `orchid_image` 0.0016200542449951
(352) DESCRIBE `cruiselines` 0.0021131038665771
(353) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00031518936157227
(354) DESCRIBE `specials` 0.0035529136657715
(355) DESCRIBE `specials` 0.0034639835357666
(356) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1483970') 0.00034093856811523
(357) DESCRIBE `ships` 0.0029499530792236
(358) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 75))) 0.00036716461181641
(359) DESCRIBE `ships` 0.0025570392608643
(360) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '75') 0.00028181076049805
(361) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026798248291016
(362) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.0002901554107666
(363) DESCRIBE `itineraries` 0.0012309551239014
(364) DESCRIBE `ports` 0.0013730525970459
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0003349781036377
(366) DESCRIBE `ports` 0.0012621879577637
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00036811828613281
(368) DESCRIBE `ports` 0.0013968944549561
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00027894973754883
(370) DESCRIBE `specialsailingdates` 0.0010550022125244
(371) DESCRIBE `sailingdates` 0.0012290477752686
(372) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 453238))) 0.00045013427734375
(373) DESCRIBE `ports` 0.0018551349639893
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00041413307189941
(375) DESCRIBE `ports` 0.0017151832580566
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00035715103149414
(377) DESCRIBE `ports` 0.0016701221466064
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5565))) 0.00042486190795898
(379) DESCRIBE `ports` 0.0017030239105225
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5565') 0.00046610832214355
(381) DESCRIBE `ports` 0.0016739368438721
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2179))) 0.0003969669342041
(383) DESCRIBE `ports` 0.0017039775848389
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2179') 5.793571472168E-5
(385) DESCRIBE `ports` 0.0019979476928711
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00047922134399414
(387) DESCRIBE `ports` 0.0018019676208496
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00042200088500977
(389) DESCRIBE `ports` 0.0018870830535889
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00043702125549316
(391) DESCRIBE `ports` 0.0020067691802979
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.0003960132598877
(393) DESCRIBE `ports` 0.001802921295166
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00043106079101562
(395) DESCRIBE `ports` 0.0018248558044434
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00038695335388184
(397) DESCRIBE `ports` 0.0017499923706055
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00046110153198242
(399) DESCRIBE `ports` 0.0017669200897217
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00035500526428223
(401) DESCRIBE `ports` 0.0018270015716553
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2586))) 0.00041103363037109
(403) DESCRIBE `ports` 0.0018918514251709
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2586') 0.00039505958557129
(405) DESCRIBE `ports` 0.0017869472503662
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00042104721069336
(407) DESCRIBE `ports` 0.0017390251159668
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00036191940307617
(409) DESCRIBE `cruises` 0.003471851348877
(410) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 58747))) 0.00059103965759277
(411) DESCRIBE `avid_specials` 0.001823902130127
(412) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1483970 and class = 'Special') OR (item_id = 58747 and class = 'Cruise') OR (item_id = 75 AND class = 'Ship') OR (item_id = 18 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.0016241073608398
(413) DESCRIBE `cruiselines` 0.0025968551635742
(414) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00043606758117676
(415) DESCRIBE `orchid_image` 0.0020289421081543
(416) DESCRIBE `cruiselines` 0.0027000904083252
(417) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00046801567077637
(418) DESCRIBE `specials` 0.0057058334350586
(419) DESCRIBE `specials` 0.0051829814910889
(420) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1467751') 0.00045585632324219
(421) DESCRIBE `ships` 0.0035438537597656
(422) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1359))) 7.8678131103516E-6
(423) DESCRIBE `ships` 0.0036110877990723
(424) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1359') 0.00043296813964844
(425) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034284591674805
(426) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0
(427) DESCRIBE `itineraries` 0.0010519027709961
(428) DESCRIBE `ports` 0.0018429756164551
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00058197975158691
(430) DESCRIBE `ports` 0.001816987991333
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00042605400085449
(432) DESCRIBE `ports` 0.0021719932556152
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00039505958557129
(434) DESCRIBE `specialsailingdates` 0.0011258125305176
(435) DESCRIBE `sailingdates` 0.0016558170318604
(436) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 424598))) 0.00012993812561035
(437) DESCRIBE `ports` 0.0018541812896729
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0
(439) DESCRIBE `ports` 0.0018129348754883
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00036787986755371
(441) DESCRIBE `ports` 0.0011739730834961
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00044393539428711
(443) DESCRIBE `ports` 0.0017879009246826
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00037908554077148
(445) DESCRIBE `ports` 0.0017330646514893
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00040507316589355
(447) DESCRIBE `ports` 0.0018141269683838
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00042295455932617
(449) DESCRIBE `ports` 0.0019190311431885
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00043320655822754
(451) DESCRIBE `ports` 0.0018420219421387
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00038504600524902
(453) DESCRIBE `ports` 0.0018820762634277
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00045490264892578
(455) DESCRIBE `ports` 0.0019290447235107
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00040698051452637
(457) DESCRIBE `ports` 0.0018219947814941
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00048518180847168
(459) DESCRIBE `ports` 0.0017819404602051
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00035905838012695
(461) DESCRIBE `ports` 0.0017819404602051
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00039196014404297
(463) DESCRIBE `ports` 0.0018289089202881
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00035691261291504
(465) DESCRIBE `cruises` 0.0034310817718506
(466) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 62662))) 0.00049495697021484
(467) DESCRIBE `avid_specials` 0.0015640258789062
(468) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1467751 and class = 'Special') OR (item_id = 62662 and class = 'Cruise') OR (item_id = 1359 AND class = 'Ship') OR (item_id = 19 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.0016210079193115
(469) DESCRIBE `cruiselines` 0.0031578540802002
(470) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00044512748718262
(471) DESCRIBE `orchid_image` 0.0012640953063965
(472) DESCRIBE `cruiselines` 0.0025789737701416
(473) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00039815902709961
(474) DESCRIBE `specials` 0.0045931339263916
(475) DESCRIBE `specials` 0.0055460929870605
(476) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1483995') 0.00053811073303223
(477) DESCRIBE `ships` 0.0043981075286865
(478) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 75))) 0.00051093101501465
(479) DESCRIBE `ships` 0.0037350654602051
(480) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '75') 0.00039196014404297
(481) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034904479980469
(482) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00034093856811523
(483) DESCRIBE `itineraries` 0.0029139518737793
(484) DESCRIBE `ports` 0.0023081302642822
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00014400482177734
(486) DESCRIBE `ports` 0.0019700527191162
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00040102005004883
(488) DESCRIBE `ports` 0.0019400119781494
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00048208236694336
(490) DESCRIBE `specialsailingdates` 0.0014998912811279
(491) DESCRIBE `sailingdates` 0.0016360282897949
(492) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 453239))) 0.00039792060852051
(493) DESCRIBE `ports` 0.0018510818481445
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00040698051452637
(495) DESCRIBE `ports` 0.0018830299377441
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00037288665771484
(497) DESCRIBE `ports` 0.0018279552459717
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00042200088500977
(499) DESCRIBE `ports` 0.0018448829650879
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00036501884460449
(501) DESCRIBE `ports` 0.0018208026885986
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.00039887428283691
(503) DESCRIBE `ports` 0.001863956451416
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00035881996154785
(505) DESCRIBE `ports` 0.0018749237060547
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 446))) 0.00038504600524902
(507) DESCRIBE `ports` 0.0018899440765381
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '446') 0.00034499168395996
(509) DESCRIBE `ports` 0.0018191337585449
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00045204162597656
(511) DESCRIBE `ports` 0.0018351078033447
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.00036406517028809
(513) DESCRIBE `ports` 0.0018830299377441
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3922))) 0.00040507316589355
(515) DESCRIBE `ports` 0.0018730163574219
(516) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3922') 0.00038003921508789
(517) DESCRIBE `ports` 0.00187087059021
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1921))) 0.00039911270141602
(519) DESCRIBE `ports` 0.0018701553344727
(520) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1921') 0.00035786628723145
(521) DESCRIBE `ports` 0.0018289089202881
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1472))) 0.00040793418884277
(523) DESCRIBE `ports` 0.0018529891967773
(524) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1472') 0.00036406517028809
(525) DESCRIBE `ports` 0.0018260478973389
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00048685073852539
(527) DESCRIBE `ports` 0.0019090175628662
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00037097930908203
(529) DESCRIBE `ports` 0.0018980503082275
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0
(531) DESCRIBE `ports` 0.0025999546051025
(532) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00042295455932617
(533) DESCRIBE `ports` 0.001845121383667
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1664))) 1.2874603271484E-5
(535) DESCRIBE `ports` 0.0018219947814941
(536) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1664') 0.00030612945556641
(537) DESCRIBE `ports` 0.001331090927124
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003199577331543
(539) DESCRIBE `ports` 0.0013160705566406
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00033807754516602
(541) DESCRIBE `cruises` 0.0026669502258301
(542) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 71371))) 0.00046801567077637
(543) DESCRIBE `avid_specials` 0.0013020038604736
(544) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1483995 and class = 'Special') OR (item_id = 71371 and class = 'Cruise') OR (item_id = 75 AND class = 'Ship') OR (item_id = 18 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.0012631416320801
(545) DESCRIBE `cruiselines` 0.0019869804382324
(546) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.0003209114074707
(547) DESCRIBE `orchid_image` 0.0016729831695557
(548) DESCRIBE `cruiselines` 0.001856803894043
(549) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00030112266540527
(550) DESCRIBE `specials` 0.0039908885955811
(551) DESCRIBE `specials` 0.0042300224304199
(552) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1481852') 0.00039219856262207
(553) DESCRIBE `ships` 0.0030488967895508
(554) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 683))) 0.00047612190246582
(555) DESCRIBE `ships` 0.002251148223877
(556) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '683') 0.00033998489379883
(557) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026607513427734
(558) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025105476379395
(559) DESCRIBE `itineraries` 0.0017638206481934
(560) DESCRIBE `ports` 0.0015099048614502
(561) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00032711029052734
(562) DESCRIBE `ports` 0.0013339519500732
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00030803680419922
(564) DESCRIBE `ports` 0.0013930797576904
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00029611587524414
(566) DESCRIBE `specialsailingdates` 0.0011570453643799
(567) DESCRIBE `sailingdates` 0.0014770030975342
(568) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419446))) 0.00041794776916504
(569) DESCRIBE `ports` 0.0015799999237061
(570) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00034403800964355
(571) DESCRIBE `ports` 0.0014598369598389
(572) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00051999092102051
(573) DESCRIBE `ports` 0.0012779235839844
(574) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 488))) 0.0010340213775635
(575) DESCRIBE `ports` 0.00095915794372559
(576) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '488') 0.00029802322387695
(577) DESCRIBE `ports` 0.0014958381652832
(578) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 445))) 0.00038909912109375
(579) DESCRIBE `ports` 0.0021839141845703
(580) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '445') 0.0005190372467041
(581) DESCRIBE `ports` 0.0017819404602051
(582) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 508))) 0.00041508674621582
(583) DESCRIBE `ports` 0.0015039443969727
(584) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '508') 0.00039315223693848
(585) DESCRIBE `ports` 0.0018930435180664
(586) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1473))) 0.00041389465332031
(587) DESCRIBE `ports` 0.0018341541290283
(588) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1473') 0.00037217140197754
(589) DESCRIBE `ports` 0.0018508434295654
(590) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 491))) 0.00041508674621582
(591) DESCRIBE `ports` 0.001777172088623
(592) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '491') 0.00028705596923828
(593) DESCRIBE `ports` 0.0012738704681396
(594) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1171))) 0.00031089782714844
(595) DESCRIBE `ports` 0.0015120506286621
(596) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1171') 0.00030899047851562
(597) DESCRIBE `ports` 0.001284122467041
(598) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 509))) 0.00039100646972656
(599) DESCRIBE `ports` 0.0013329982757568
(600) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '509') 0.00028204917907715
(601) DESCRIBE `ports` 0.001399040222168
(602) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 492))) 0.00040721893310547
(603) DESCRIBE `ports` 0.0020029544830322
(604) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '492') 0.00047206878662109
(605) DESCRIBE `ports` 0.0014901161193848
(606) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 8.7976455688477E-5
(607) DESCRIBE `ports` 0.00092577934265137
(608) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00036096572875977
(609) DESCRIBE `cruises` 0.0032279491424561
(610) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 66811))) 0.00051784515380859
(611) DESCRIBE `avid_specials` 0.00027918815612793
(612) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1481852 and class = 'Special') OR (item_id = 66811 and class = 'Cruise') OR (item_id = 683 AND class = 'Ship') OR (item_id = 8 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.001194953918457
(613) DESCRIBE `cruiselines` 0.0022079944610596
(614) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 8))) 0.00032997131347656
(615) DESCRIBE `orchid_image` 0.0014660358428955
(616) DESCRIBE `cruiselines` 0.0020520687103271
(617) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '8') 0.00028681755065918
(618) DESCRIBE `specials` 0.0036718845367432
(619) DESCRIBE `specials` 0.0035960674285889
(620) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1476709') 0.00032997131347656
(621) DESCRIBE `ships` 0.0027329921722412
(622) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1266))) 0.00039792060852051
(623) DESCRIBE `ships` 0.0025560855865479
(624) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1266') 0.00029993057250977
(625) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00026702880859375
(626) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00025606155395508
(627) DESCRIBE `itineraries` 0.001255989074707
(628) DESCRIBE `ports` 0.0013449192047119
(629) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00038290023803711
(630) DESCRIBE `ports` 0.0013110637664795
(631) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00038790702819824
(632) DESCRIBE `ports` 0.001568078994751
(633) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.00035691261291504
(634) DESCRIBE `specialsailingdates` 0.001183032989502
(635) DESCRIBE `sailingdates` 0.001417875289917
(636) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 471477))) 0.00056815147399902
(637) DESCRIBE `ports` 0.0013887882232666
(638) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00040483474731445
(639) DESCRIBE `ports` 0.0015461444854736
(640) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0003058910369873
(641) DESCRIBE `ports` 0.0015439987182617
(642) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00033092498779297
(643) DESCRIBE `ports` 0.0013260841369629
(644) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00028800964355469
(645) DESCRIBE `ports` 0.0012609958648682
(646) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 185))) 0.00033283233642578
(647) DESCRIBE `ports` 0.0015180110931396
(648) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '185') 0.00034499168395996
(649) DESCRIBE `ports` 0.0013620853424072
(650) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 176))) 0.0003669261932373
(651) DESCRIBE `ports` 0.0013418197631836
(652) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '176') 0.00027799606323242
(653) DESCRIBE `ports` 0.0012800693511963
(654) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 173))) 0.00030803680419922
(655) DESCRIBE `ports` 0.0014100074768066
(656) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '173') 0.00031399726867676
(657) DESCRIBE `ports` 0.0013132095336914
(658) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2752))) 0.00031208992004395
(659) DESCRIBE `ports` 0.001309871673584
(660) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2752') 0.00028705596923828
(661) DESCRIBE `ports` 0.001284122467041
(662) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 135))) 0.00037884712219238
(663) DESCRIBE `ports` 0.0016188621520996
(664) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '135') 0.0003201961517334
(665) DESCRIBE `cruises` 0.0025291442871094
(666) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 74647))) 0.0003969669342041
(667) DESCRIBE `avid_specials` 0.0013060569763184
(668) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1476709 and class = 'Special') OR (item_id = 74647 and class = 'Cruise') OR (item_id = 1266 AND class = 'Ship') OR (item_id = 33 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.0010640621185303
(669) DESCRIBE `cruiselines` 0.001906156539917
(670) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 33))) 0.00043106079101562
(671) DESCRIBE `orchid_image` 0.0014221668243408
(672) DESCRIBE `cruiselines` 0.001896858215332
(673) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '33') 0.00035405158996582
(674) DESCRIBE `cruiselines` 0.0023560523986816
(675) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('101', '140', '110', '18', '114', '23', '33', '8', '171', '20', '19', '24', '29', '91', '188', '212', '14', '218', '37', '180', '191')) ORDER BY FIND_IN_SET(id, '101,140,110,18,114,23,33,8,171,20,19,24,29,91,188,212,14,218,37,180,191') 0.0015571117401123
(676) DESCRIBE `ships` 0.0035331249237061
(677) SELECT `ships`.* FROM `ships` WHERE (id IN ('1471', '1139', '1237', '683', '1266', '1292', '888', '933', '1224', '1631', '1262', '1393', '1491', '1594', '75', '162', '547', '741', '823', '1073', '1359', '1409', '1739', '82', '108', '580', '796', '835', '1223', '1328', '1539', '1569', '1607', '66', '406', '795', '1013', '1029', '1163', '1189', '1318', '1319', '1587', '45', '74', '78', '81', '98', '111', '148', '291', '324', '332', '348', '394', '404', '434', '455', '485', '542', '573', '582', '626', '657', '669', '678', '769', '966', '973', '1095', '1135', '1159', '1205', '1282', '1302', '1303', '1402')) ORDER BY FIND_IN_SET(id, '1471,1139,1237,683,1266,1292,888,933,1224,1631,1262,1393,1491,1594,75,162,547,741,823,1073,1359,1409,1739,82,108,580,796,835,1223,1328,1539,1569,1607,66,406,795,1013,1029,1163,1189,1318,1319,1587,45,74,78,81,98,111,148,291,324,332,348,394,404,434,455,485,542,573,582,626,657,669,678,769,966,973,1095,1135,1159,1205,1282,1302,1303,1402') 0.0096259117126465
(678) DESCRIBE `cruisetypes` 0.0014438629150391
(679) DESCRIBE `destinations` 0.0018010139465332
(680) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '37', '22', '43', '35', '54', '7', '2', '8', '26', '39', '40', '48', '53', '12', '11', '25', '28', '29', '34', '38')) ORDER BY FIND_IN_SET(id, '50,37,22,43,35,54,7,2,8,26,39,40,48,53,12,11,25,28,29,34,38') 0.0013248920440674