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

Total elapsed time: 0.76616740226746

# Query Time
(1) connect 0.0009009838104248
(2) DESCRIBE `cruises` 0.0044748783111572
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66996, 66955, 66998, 66999, 66001, 38689, 25176, 38690, 67001, 67000)) ORDER BY FIND_IN_SET(id, '66996,66955,66998,66999,66001,38689,25176,38690,67001,67000') 0.0020098686218262
(4) DESCRIBE `cruises` 0.0041379928588867
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66996') 0.00046205520629883
(6) DESCRIBE `ships` 0.0042450428009033
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00054001808166504
(8) DESCRIBE `ships` 0.0036618709564209
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.0003960132598877
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029110908508301
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025796890258789
(12) DESCRIBE `itineraries` 0.0016419887542725
(13) DESCRIBE `ports` 0.00160813331604
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00040221214294434
(15) DESCRIBE `ports` 0.0017650127410889
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00042295455932617
(17) DESCRIBE `ports` 0.0018899440765381
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0003960132598877
(19) DESCRIBE `sailingdates` 0.0016140937805176
(20) DESCRIBE `ports` 0.0022919178009033
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00047397613525391
(22) DESCRIBE `ports` 0.0017099380493164
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00038909912109375
(24) DESCRIBE `ports` 0.00177001953125
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00041317939758301
(26) DESCRIBE `ports` 0.001971960067749
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00039005279541016
(28) DESCRIBE `ports` 0.0017318725585938
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00043392181396484
(30) DESCRIBE `ports` 0.001978874206543
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00040793418884277
(32) DESCRIBE `ports` 0.0019819736480713
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00050902366638184
(34) DESCRIBE `ports` 0.0019340515136719
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00039196014404297
(36) DESCRIBE `ports` 0.0017387866973877
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00039792060852051
(38) DESCRIBE `ports` 0.0018761157989502
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.0009920597076416
(40) DESCRIBE `ports` 0.0017430782318115
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00041413307189941
(42) DESCRIBE `ports` 0.001676082611084
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00034308433532715
(44) DESCRIBE `ports` 0.0085101127624512
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0061688423156738
(46) DESCRIBE `ports` 0.0019910335540771
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00039505958557129
(48) DESCRIBE `avid_specials` 0.0013940334320068
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66996 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.0015189647674561
(50) DESCRIBE `cruiselines` 0.0090949535369873
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00050210952758789
(52) DESCRIBE `orchid_image` 0.0021929740905762
(53) DESCRIBE `cruiselines` 0.0028009414672852
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.0042169094085693
(55) DESCRIBE `cruises` 0.0041739940643311
(56) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66955') 0.00049686431884766
(57) DESCRIBE `ships` 0.0039482116699219
(58) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00066614151000977
(59) DESCRIBE `ships` 0.0039799213409424
(60) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00047898292541504
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034499168395996
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033211708068848
(63) DESCRIBE `itineraries` 0.0019140243530273
(64) DESCRIBE `ports` 0.0019299983978271
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0004429817199707
(66) DESCRIBE `ports` 0.0018539428710938
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00048995018005371
(68) DESCRIBE `ports` 0.001521110534668
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00037813186645508
(70) DESCRIBE `sailingdates` 0.0015461444854736
(71) DESCRIBE `ports` 0.0027320384979248
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00054216384887695
(73) DESCRIBE `ports` 0.001924991607666
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00039005279541016
(75) DESCRIBE `ports` 0.0017619132995605
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00039911270141602
(77) DESCRIBE `ports` 0.0017890930175781
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00038599967956543
(79) DESCRIBE `ports` 0.0021090507507324
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.0004580020904541
(81) DESCRIBE `ports` 0.001835823059082
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00036716461181641
(83) DESCRIBE `ports` 0.0017671585083008
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00039100646972656
(85) DESCRIBE `ports` 0.0017271041870117
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00035500526428223
(87) DESCRIBE `ports` 0.0016069412231445
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00038814544677734
(89) DESCRIBE `ports` 0.0017600059509277
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00037288665771484
(91) DESCRIBE `ports` 0.001816987991333
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00042915344238281
(93) DESCRIBE `ports` 0.0017938613891602
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00046992301940918
(95) DESCRIBE `ports` 0.0030419826507568
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00084400177001953
(97) DESCRIBE `ports` 0.0023858547210693
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00044608116149902
(99) DESCRIBE `avid_specials` 0.0015869140625
(100) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66955 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.0021750926971436
(101) DESCRIBE `cruiselines` 0.002241849899292
(102) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00038695335388184
(103) DESCRIBE `orchid_image` 0.0017719268798828
(104) DESCRIBE `cruiselines` 0.0021119117736816
(105) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00039911270141602
(106) DESCRIBE `cruises` 0.0028760433197021
(107) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66998') 0.00037884712219238
(108) DESCRIBE `ships` 0.0029921531677246
(109) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00046300888061523
(110) DESCRIBE `ships` 0.0038659572601318
(111) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.0005650520324707
(112) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032997131347656
(113) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033307075500488
(114) DESCRIBE `itineraries` 0.0019869804382324
(115) DESCRIBE `ports` 0.0020821094512939
(116) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00046014785766602
(117) DESCRIBE `ports` 0.0019328594207764
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00044989585876465
(119) DESCRIBE `ports` 0.0018608570098877
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00041317939758301
(121) DESCRIBE `sailingdates` 0.0015599727630615
(122) DESCRIBE `ports` 0.0017831325531006
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00044012069702148
(124) DESCRIBE `ports` 0.0018658638000488
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0003819465637207
(126) DESCRIBE `ports` 0.0018150806427002
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00040316581726074
(128) DESCRIBE `ports` 0.0019299983978271
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00042915344238281
(130) DESCRIBE `ports` 0.002032995223999
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00048208236694336
(132) DESCRIBE `ports` 0.0020499229431152
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00041389465332031
(134) DESCRIBE `ports` 0.0019268989562988
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00046205520629883
(136) DESCRIBE `ports` 0.0018990039825439
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00043606758117676
(138) DESCRIBE `ports` 0.0019340515136719
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00051093101501465
(140) DESCRIBE `ports` 0.0019421577453613
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.0003969669342041
(142) DESCRIBE `ports` 0.0014698505401611
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00034689903259277
(144) DESCRIBE `ports` 0.00154709815979
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00036907196044922
(146) DESCRIBE `ports` 0.0014529228210449
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00069904327392578
(148) DESCRIBE `ports` 0.0016908645629883
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00043702125549316
(150) DESCRIBE `avid_specials` 0.0016040802001953
(151) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66998 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 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.0017027854919434
(152) DESCRIBE `cruiselines` 0.0027520656585693
(153) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00054502487182617
(154) DESCRIBE `orchid_image` 0.0022721290588379
(155) DESCRIBE `cruiselines` 0.0028479099273682
(156) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00044393539428711
(157) DESCRIBE `cruises` 0.0033349990844727
(158) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66999') 0.00045394897460938
(159) DESCRIBE `ships` 0.0032980442047119
(160) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00058603286743164
(161) DESCRIBE `ships` 0.0036220550537109
(162) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00046110153198242
(163) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034189224243164
(164) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034403800964355
(165) DESCRIBE `itineraries` 0.0018308162689209
(166) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66999') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00064611434936523
(167) DESCRIBE `ports` 0.0018959045410156
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00046706199645996
(169) DESCRIBE `ports` 0.0017340183258057
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00038313865661621
(171) DESCRIBE `ports` 0.0015339851379395
(172) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00038695335388184
(173) DESCRIBE `sailingdates` 0.0015790462493896
(174) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66999') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00057506561279297
(175) DESCRIBE `ports` 0.0019819736480713
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00046110153198242
(177) DESCRIBE `ports` 0.0020630359649658
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00041794776916504
(179) DESCRIBE `ports` 0.0019698143005371
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00042891502380371
(181) DESCRIBE `ports` 0.0018041133880615
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0003960132598877
(183) DESCRIBE `ports` 0.0018091201782227
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00050592422485352
(185) DESCRIBE `ports` 0.001849889755249
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.0004119873046875
(187) DESCRIBE `ports` 0.0018172264099121
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 628))) 0.00044703483581543
(189) DESCRIBE `ports` 0.001906156539917
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '628') 0.00041007995605469
(191) DESCRIBE `ports` 0.0018689632415771
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00040817260742188
(193) DESCRIBE `ports` 0.0018079280853271
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00038599967956543
(195) DESCRIBE `ports` 0.0016250610351562
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00050806999206543
(197) DESCRIBE `ports` 0.0017499923706055
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00040197372436523
(199) DESCRIBE `avid_specials` 0.0015749931335449
(200) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66999 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 38 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.0015881061553955
(201) DESCRIBE `cruiselines` 0.002593994140625
(202) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00047397613525391
(203) DESCRIBE `orchid_image` 0.0019290447235107
(204) DESCRIBE `cruiselines` 0.0026700496673584
(205) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00041818618774414
(206) DESCRIBE `cruises` 0.0043840408325195
(207) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66001') 0.00075006484985352
(208) DESCRIBE `ships` 0.0039420127868652
(209) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00072002410888672
(210) DESCRIBE `ships` 0.003964900970459
(211) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00052309036254883
(212) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00038695335388184
(213) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032210350036621
(214) DESCRIBE `itineraries` 0.00187087059021
(215) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66001') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00084996223449707
(216) DESCRIBE `ports` 0.0027430057525635
(217) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00047588348388672
(218) DESCRIBE `ports` 0.0016682147979736
(219) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00047612190246582
(220) DESCRIBE `ports` 0.0018689632415771
(221) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00048589706420898
(222) DESCRIBE `sailingdates` 0.0016558170318604
(223) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66001') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00077915191650391
(224) DESCRIBE `ports` 0.0032370090484619
(225) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00064396858215332
(226) DESCRIBE `ports` 0.0019299983978271
(227) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00054597854614258
(228) DESCRIBE `ports` 0.0019547939300537
(229) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.0006248950958252
(230) DESCRIBE `ports` 0.0018987655639648
(231) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00046110153198242
(232) DESCRIBE `ports` 0.0018701553344727
(233) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 170))) 0.00044989585876465
(234) DESCRIBE `ports` 0.0018599033355713
(235) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '170') 0.00040078163146973
(236) DESCRIBE `ports` 0.0024640560150146
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 346))) 0.00050687789916992
(238) DESCRIBE `ports` 0.001945972442627
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '346') 0.00043606758117676
(240) DESCRIBE `ports` 0.0017321109771729
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00047993659973145
(242) DESCRIBE `ports` 0.0022611618041992
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.0007929801940918
(244) DESCRIBE `ports` 0.002000093460083
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 57))) 0.00044417381286621
(246) DESCRIBE `ports` 0.0019350051879883
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '57') 0.00044608116149902
(248) DESCRIBE `ports` 0.00211501121521
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00052094459533691
(250) DESCRIBE `ports` 0.0022850036621094
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00043487548828125
(252) DESCRIBE `avid_specials` 0.00160813331604
(253) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66001 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 12 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.0016200542449951
(254) DESCRIBE `cruiselines` 0.002683162689209
(255) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00052499771118164
(256) DESCRIBE `orchid_image` 0.0022029876708984
(257) DESCRIBE `cruiselines` 0.0027480125427246
(258) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00043296813964844
(259) DESCRIBE `cruises` 0.0038139820098877
(260) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '38689') 0.0005650520324707
(261) DESCRIBE `ships` 0.0037720203399658
(262) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00056099891662598
(263) DESCRIBE `ships` 0.0037639141082764
(264) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00046300888061523
(265) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036001205444336
(266) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034213066101074
(267) DESCRIBE `itineraries` 0.0018398761749268
(268) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '38689') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00082516670227051
(269) DESCRIBE `ports` 0.0019350051879883
(270) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00044083595275879
(271) DESCRIBE `ports` 0.0018417835235596
(272) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.0004119873046875
(273) DESCRIBE `ports` 0.0017800331115723
(274) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00038599967956543
(275) DESCRIBE `sailingdates` 0.0015521049499512
(276) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '38689') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00082707405090332
(277) DESCRIBE `ports` 0.0018529891967773
(278) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00045204162597656
(279) DESCRIBE `ports` 0.0018489360809326
(280) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00038599967956543
(281) DESCRIBE `ports` 0.0019400119781494
(282) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00040698051452637
(283) DESCRIBE `ports` 0.0017220973968506
(284) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.0004432201385498
(285) DESCRIBE `ports` 0.0013408660888672
(286) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00042104721069336
(287) DESCRIBE `ports` 0.0017099380493164
(288) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00039196014404297
(289) DESCRIBE `ports` 0.0018630027770996
(290) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.00042414665222168
(291) DESCRIBE `ports` 0.0015919208526611
(292) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.00017309188842773
(293) DESCRIBE `ports` 0.0018820762634277
(294) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2863))) 0.00073409080505371
(295) DESCRIBE `ports` 0.001878023147583
(296) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2863') 0.0005958080291748
(297) DESCRIBE `ports` 0.0016129016876221
(298) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.00049114227294922
(299) DESCRIBE `ports` 0.0018479824066162
(300) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.00043702125549316
(301) DESCRIBE `ports` 0.0022990703582764
(302) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2131))) 0.00052499771118164
(303) DESCRIBE `ports` 0.0020420551300049
(304) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2131') 0.00049495697021484
(305) DESCRIBE `ports` 0.0020592212677002
(306) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00044012069702148
(307) DESCRIBE `ports` 0.0041720867156982
(308) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00068783760070801
(309) DESCRIBE `ports` 0.0016129016876221
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00043606758117676
(311) DESCRIBE `ports` 0.0015690326690674
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00037002563476562
(313) DESCRIBE `avid_specials` 0.0015301704406738
(314) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 38689 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 48 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.0014829635620117
(315) DESCRIBE `cruiselines` 0.0024030208587646
(316) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00051593780517578
(317) DESCRIBE `orchid_image` 0.0018370151519775
(318) DESCRIBE `cruiselines` 0.0023679733276367
(319) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.0004580020904541
(320) DESCRIBE `cruises` 0.0054709911346436
(321) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '25176') 0.00046205520629883
(322) DESCRIBE `ships` 0.0029871463775635
(323) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00043988227844238
(324) DESCRIBE `ships` 0.0033888816833496
(325) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00040292739868164
(326) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029492378234863
(327) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028300285339355
(328) DESCRIBE `itineraries` 0.0015020370483398
(329) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '25176') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0007331371307373
(330) DESCRIBE `ports` 0.0014069080352783
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00038290023803711
(332) DESCRIBE `ports` 0.0014879703521729
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00035905838012695
(334) DESCRIBE `ports` 0.0015840530395508
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00069189071655273
(336) DESCRIBE `sailingdates` 0.0012280941009521
(337) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '25176') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00079488754272461
(338) DESCRIBE `ports` 0.0020198822021484
(339) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00049209594726562
(340) DESCRIBE `ports` 0.0020849704742432
(341) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00047516822814941
(342) DESCRIBE `ports` 0.0016419887542725
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 9.3936920166016E-5
(344) DESCRIBE `ports` 0.0014660358428955
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00033187866210938
(346) DESCRIBE `ports` 0.0017518997192383
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.00032997131347656
(348) DESCRIBE `ports` 0.0014159679412842
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.00029897689819336
(350) DESCRIBE `ports` 0.00136399269104
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.00032806396484375
(352) DESCRIBE `ports` 0.0014510154724121
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00036382675170898
(354) DESCRIBE `ports` 0.0013937950134277
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00038290023803711
(356) DESCRIBE `ports` 0.001384973526001
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00028610229492188
(358) DESCRIBE `avid_specials` 0.0013248920440674
(359) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 25176 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 53 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.0013060569763184
(360) DESCRIBE `cruiselines` 0.0024161338806152
(361) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00047588348388672
(362) DESCRIBE `orchid_image` 0.0020029544830322
(363) DESCRIBE `cruiselines` 0.0019271373748779
(364) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00031495094299316
(365) DESCRIBE `cruises` 0.0026369094848633
(366) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '38690') 0.0003819465637207
(367) DESCRIBE `ships` 0.003615140914917
(368) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00011301040649414
(369) DESCRIBE `ships` 0.0037109851837158
(370) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00054621696472168
(371) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035691261291504
(372) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029397010803223
(373) DESCRIBE `itineraries` 0.0020601749420166
(374) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '38690') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00060105323791504
(375) DESCRIBE `ports` 0.0018289089202881
(376) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00089716911315918
(377) DESCRIBE `ports` 0.0014939308166504
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00041913986206055
(379) DESCRIBE `ports` 0.0018079280853271
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00041913986206055
(381) DESCRIBE `sailingdates` 0.0016539096832275
(382) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '38690') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00074386596679688
(383) DESCRIBE `ports` 0.0022079944610596
(384) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00077486038208008
(385) DESCRIBE `ports` 0.0015931129455566
(386) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00070881843566895
(387) DESCRIBE `ports` 0.0018460750579834
(388) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.0003049373626709
(389) DESCRIBE `ports` 0.0016000270843506
(390) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00033688545227051
(391) DESCRIBE `ports` 0.0016970634460449
(392) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2131))) 0.00037193298339844
(393) DESCRIBE `ports` 0.0016961097717285
(394) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2131') 0.00034093856811523
(395) DESCRIBE `ports` 0.0017149448394775
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 357))) 0.00037384033203125
(397) DESCRIBE `ports` 0.0017609596252441
(398) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '357') 0.00034594535827637
(399) DESCRIBE `ports` 0.0017590522766113
(400) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 615))) 0.00038886070251465
(401) DESCRIBE `ports` 0.0017471313476562
(402) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '615') 0.00037813186645508
(403) DESCRIBE `ports` 0.0016250610351562
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 169))) 0.00038719177246094
(405) DESCRIBE `ports` 0.002169132232666
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '169') 0.00049996376037598
(407) DESCRIBE `ports` 0.0018739700317383
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 165))) 0.00041007995605469
(409) DESCRIBE `ports` 0.0019071102142334
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '165') 0.00034904479980469
(411) DESCRIBE `ports` 0.0017619132995605
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 96))) 0.00039196014404297
(413) DESCRIBE `ports` 0.0018091201782227
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '96') 0.00036716461181641
(415) DESCRIBE `ports` 0.0017411708831787
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00047898292541504
(417) DESCRIBE `ports` 0.0018088817596436
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00037384033203125
(419) DESCRIBE `avid_specials` 0.0012490749359131
(420) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 38690 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 48 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.0014441013336182
(421) DESCRIBE `cruiselines` 0.0025358200073242
(422) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00050497055053711
(423) DESCRIBE `orchid_image` 0.001863956451416
(424) DESCRIBE `cruiselines` 0.0024287700653076
(425) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00043797492980957
(426) DESCRIBE `cruises` 0.00347900390625
(427) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67001') 0.00037097930908203
(428) DESCRIBE `ships` 0.0026512145996094
(429) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00042605400085449
(430) DESCRIBE `ships` 0.0026090145111084
(431) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00031685829162598
(432) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0002598762512207
(433) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028085708618164
(434) DESCRIBE `itineraries` 0.0013840198516846
(435) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67001') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00042295455932617
(436) DESCRIBE `ports` 0.0020020008087158
(437) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00090694427490234
(438) DESCRIBE `ports` 0.0025639533996582
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00084900856018066
(440) DESCRIBE `ports` 0.0026369094848633
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00037789344787598
(442) DESCRIBE `sailingdates` 0.0014550685882568
(443) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67001') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00060606002807617
(444) DESCRIBE `ports` 0.0018520355224609
(445) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.00043678283691406
(446) DESCRIBE `ports` 0.0016839504241943
(447) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00037097930908203
(448) DESCRIBE `ports` 0.001755952835083
(449) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 166))) 0.00034785270690918
(450) DESCRIBE `ports` 0.0014181137084961
(451) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '166') 0.00046801567077637
(452) DESCRIBE `ports` 0.0015718936920166
(453) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2148))) 0.00033092498779297
(454) DESCRIBE `ports` 0.0014557838439941
(455) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2148') 0.00034999847412109
(456) DESCRIBE `ports` 0.0016610622406006
(457) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2134))) 0.0004270076751709
(458) DESCRIBE `ports` 0.0017659664154053
(459) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2134') 0.00034308433532715
(460) DESCRIBE `ports` 0.0017139911651611
(461) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 331))) 0.00041818618774414
(462) DESCRIBE `ports` 0.0017809867858887
(463) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '331') 0.00041699409484863
(464) DESCRIBE `ports` 0.001882791519165
(465) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 144))) 0.0004270076751709
(466) DESCRIBE `ports` 0.0015971660614014
(467) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '144') 0.00039100646972656
(468) DESCRIBE `avid_specials` 0.0013461112976074
(469) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67001 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 53 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.0016250610351562
(470) DESCRIBE `cruiselines` 0.0030841827392578
(471) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00058317184448242
(472) DESCRIBE `orchid_image` 0.0030539035797119
(473) DESCRIBE `cruiselines` 0.0034041404724121
(474) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00049901008605957
(475) DESCRIBE `cruises` 0.0037829875946045
(476) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67000') 0.0004880428314209
(477) DESCRIBE `ships` 0.0037879943847656
(478) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00057697296142578
(479) DESCRIBE `ships` 0.0038230419158936
(480) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00054717063903809
(481) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033116340637207
(482) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003211498260498
(483) DESCRIBE `itineraries` 0.0019440650939941
(484) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67000') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00042295455932617
(485) DESCRIBE `ports` 0.0020360946655273
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00047183036804199
(487) DESCRIBE `ports` 0.0017650127410889
(488) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00055122375488281
(489) DESCRIBE `ports` 0.0015671253204346
(490) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00049304962158203
(491) DESCRIBE `sailingdates` 0.0015509128570557
(492) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67000') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00065803527832031
(493) DESCRIBE `ports` 0.0022029876708984
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00052094459533691
(495) DESCRIBE `ports` 0.0019240379333496
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00038814544677734
(497) DESCRIBE `ports` 0.0016181468963623
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 413))) 0.00040507316589355
(499) DESCRIBE `ports` 0.0018749237060547
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '413') 0.00041699409484863
(501) DESCRIBE `ports` 0.0017979145050049
(502) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.0004420280456543
(503) DESCRIBE `ports` 0.0018599033355713
(504) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00058317184448242
(505) DESCRIBE `ports` 0.0019669532775879
(506) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00060606002807617
(507) DESCRIBE `ports` 0.0021028518676758
(508) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00040102005004883
(509) DESCRIBE `ports` 0.0022609233856201
(510) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.0010130405426025
(511) DESCRIBE `ports` 0.0015699863433838
(512) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00054383277893066
(513) DESCRIBE `ports` 0.0019600391387939
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00043296813964844
(515) DESCRIBE `ports` 0.0017721652984619
(516) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00039196014404297
(517) DESCRIBE `avid_specials` 0.0016100406646729
(518) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67000 and class = 'Cruise') OR (item_id = 93 AND class = 'Ship') OR (item_id = 20 AND class = 'CruiseLine') OR (item_id = 12 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.0016579627990723
(519) DESCRIBE `cruiselines` 0.0031609535217285
(520) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00053596496582031
(521) DESCRIBE `orchid_image` 0.0020959377288818
(522) DESCRIBE `cruiselines` 0.0027420520782471
(523) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00043821334838867
(524) DESCRIBE `cruisetypes` 0.0017769336700439
(525) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruisetypes.id = cruises_and_specials.cruisetype_id) AND (cruises_and_specials.cruiseline_id = '20') AND (cruises_and_specials.ship_id = '93') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.038715839385986
(526) DESCRIBE `destinations` 0.0027849674224854
(527) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '53', '37', '48', '12', '38')) ORDER BY FIND_IN_SET(id, '22,53,37,48,12,38') 0.0010969638824463
(528) DESCRIBE `cruiselines` 0.0027589797973633
(529) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00044417381286621
(530) DESCRIBE `ships` 0.0037491321563721
(531) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00057005882263184
(532) DESCRIBE `cruiselines` 0.0027341842651367
(533) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00049996376037598
(534) DESCRIBE `ships` 0.0037150382995605
(535) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00051999092102051