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

Total elapsed time: 0.79158043861389

# Query Time
(1) connect 0.00074982643127441
(2) DESCRIBE `cruises` 0.0039920806884766
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66996, 66955, 66998, 74236, 74237, 67256, 74238, 74239, 74240)) ORDER BY FIND_IN_SET(id, '66996,66955,66998,74236,74237,67256,74238,74239,74240') 0.0021591186523438
(4) DESCRIBE `cruises` 0.0036959648132324
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66996') 0.00040102005004883
(6) DESCRIBE `ships` 0.0043869018554688
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00049996376037598
(8) DESCRIBE `ships` 0.0035099983215332
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00037503242492676
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003349781036377
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00032401084899902
(12) DESCRIBE `itineraries` 0.0021319389343262
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66996') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010459423065186
(14) DESCRIBE `ports` 0.0021171569824219
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00042414665222168
(16) DESCRIBE `ports` 0.0019791126251221
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00045180320739746
(18) DESCRIBE `ports` 0.0018680095672607
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00047397613525391
(20) DESCRIBE `sailingdates` 0.0015690326690674
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66996') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00088691711425781
(22) DESCRIBE `ports` 0.0020060539245605
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 4.4107437133789E-5
(24) DESCRIBE `ports` 0.0013809204101562
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0002748966217041
(26) DESCRIBE `ports` 0.0013399124145508
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.0002748966217041
(28) DESCRIBE `ports` 0.0023400783538818
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00042510032653809
(30) DESCRIBE `ports` 0.0018279552459717
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00043010711669922
(32) DESCRIBE `ports` 0.0027401447296143
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00035715103149414
(34) DESCRIBE `ports` 0.0018179416656494
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00039815902709961
(36) DESCRIBE `ports` 0.0017549991607666
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00034308433532715
(38) DESCRIBE `ports` 0.002004861831665
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00039291381835938
(40) DESCRIBE `ports` 0.0014050006866455
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00031399726867676
(42) DESCRIBE `ports` 0.0013680458068848
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00030994415283203
(44) DESCRIBE `ports` 0.0014410018920898
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00026392936706543
(46) DESCRIBE `ports` 0.0017709732055664
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00030303001403809
(48) DESCRIBE `ports` 0.001594066619873
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027608871459961
(50) DESCRIBE `avid_specials` 0.0011570453643799
(51) 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.0012328624725342
(52) DESCRIBE `cruiselines` 0.0019190311431885
(53) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00035309791564941
(54) DESCRIBE `orchid_image` 0.0021450519561768
(55) DESCRIBE `cruiselines` 0.0024471282958984
(56) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00030207633972168
(57) DESCRIBE `cruises` 0.0040159225463867
(58) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66955') 0.00041985511779785
(59) DESCRIBE `ships` 0.0036790370941162
(60) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00037908554077148
(61) DESCRIBE `ships` 0.003000020980835
(62) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00039792060852051
(63) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034093856811523
(64) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031399726867676
(65) DESCRIBE `itineraries` 0.0014619827270508
(66) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66955') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00056099891662598
(67) DESCRIBE `ports` 0.0014910697937012
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00032281875610352
(69) DESCRIBE `ports` 0.0015890598297119
(70) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00029301643371582
(71) DESCRIBE `ports` 0.0017359256744385
(72) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0002901554107666
(73) DESCRIBE `sailingdates` 0.0011610984802246
(74) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66955') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00046515464782715
(75) DESCRIBE `ports` 0.0017919540405273
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00049185752868652
(77) DESCRIBE `ports` 0.001878023147583
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00032305717468262
(79) DESCRIBE `ports` 0.0016119480133057
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00038504600524902
(81) DESCRIBE `ports` 0.001708984375
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00029206275939941
(83) DESCRIBE `ports` 0.0015950202941895
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00033211708068848
(85) DESCRIBE `ports` 0.001492977142334
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00035309791564941
(87) DESCRIBE `ports` 0.0018479824066162
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.0003659725189209
(89) DESCRIBE `ports` 0.0017240047454834
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.0003058910369873
(91) DESCRIBE `ports` 0.0014901161193848
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00031805038452148
(93) DESCRIBE `ports` 0.001471996307373
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00030207633972168
(95) DESCRIBE `ports` 0.0017819404602051
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00033402442932129
(97) DESCRIBE `ports` 0.0020549297332764
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00034213066101074
(99) DESCRIBE `ports` 0.0019209384918213
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00040388107299805
(101) DESCRIBE `ports` 0.0017428398132324
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00034880638122559
(103) DESCRIBE `avid_specials` 0.0014619827270508
(104) 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.0014419555664062
(105) DESCRIBE `cruiselines` 0.002094030380249
(106) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00040411949157715
(107) DESCRIBE `orchid_image` 0.0021131038665771
(108) DESCRIBE `cruiselines` 0.0021190643310547
(109) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.0002748966217041
(110) DESCRIBE `cruises` 0.00301194190979
(111) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66998') 0.00054216384887695
(112) DESCRIBE `ships` 0.0029709339141846
(113) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00041007995605469
(114) DESCRIBE `ships` 0.0029909610748291
(115) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00028800964355469
(116) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026607513427734
(117) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025606155395508
(118) DESCRIBE `itineraries` 0.0013720989227295
(119) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66998') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00050616264343262
(120) DESCRIBE `ports` 0.0017950534820557
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00040411949157715
(122) DESCRIBE `ports` 0.0015769004821777
(123) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00029897689819336
(124) DESCRIBE `ports` 0.0013570785522461
(125) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00028610229492188
(126) DESCRIBE `sailingdates` 0.0011050701141357
(127) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66998') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00042891502380371
(128) DESCRIBE `ports` 0.002047061920166
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00038003921508789
(130) DESCRIBE `ports` 0.0013680458068848
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027608871459961
(132) DESCRIBE `ports` 0.0013360977172852
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00030708312988281
(134) DESCRIBE `ports` 0.0017039775848389
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00028705596923828
(136) DESCRIBE `ports` 0.0016810894012451
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00037884712219238
(138) DESCRIBE `ports` 0.0016469955444336
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00029301643371582
(140) DESCRIBE `ports` 0.0017359256744385
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00027298927307129
(142) DESCRIBE `ports` 0.001784086227417
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00025701522827148
(144) DESCRIBE `ports` 0.0016992092132568
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00030398368835449
(146) DESCRIBE `ports` 0.0020520687103271
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00036501884460449
(148) DESCRIBE `ports` 0.0016160011291504
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00030398368835449
(150) DESCRIBE `ports` 0.0017900466918945
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00037193298339844
(152) DESCRIBE `ports` 0.0017509460449219
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00045394897460938
(154) DESCRIBE `ports` 0.0017158985137939
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00035715103149414
(156) DESCRIBE `avid_specials` 0.0011458396911621
(157) 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.0010299682617188
(158) DESCRIBE `cruiselines` 0.002032995223999
(159) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00038909912109375
(160) DESCRIBE `orchid_image` 0.0014970302581787
(161) DESCRIBE `cruiselines` 0.0018069744110107
(162) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00027990341186523
(163) DESCRIBE `cruises` 0.0025060176849365
(164) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74236') 0.00041389465332031
(165) DESCRIBE `ships` 0.0035490989685059
(166) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0
(167) DESCRIBE `ships` 0.0030779838562012
(168) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 7.8916549682617E-5
(169) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00066494941711426
(170) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034713745117188
(171) DESCRIBE `itineraries` 0.0022869110107422
(172) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74236') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0008540153503418
(173) DESCRIBE `ports` 0.002586841583252
(174) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 8.9883804321289E-5
(175) DESCRIBE `ports` 0.0017328262329102
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0003349781036377
(177) DESCRIBE `ports` 0.0016980171203613
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00027704238891602
(179) DESCRIBE `sailingdates` 0.0012381076812744
(180) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74236') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00075602531433105
(181) DESCRIBE `ports` 0.0014631748199463
(182) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00038409233093262
(183) DESCRIBE `ports` 0.0015900135040283
(184) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00028610229492188
(185) DESCRIBE `ports` 0.0017180442810059
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00046396255493164
(187) DESCRIBE `ports` 0.0022070407867432
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00032496452331543
(189) DESCRIBE `ports` 0.0015640258789062
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00034499168395996
(191) DESCRIBE `ports` 0.0015130043029785
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00032496452331543
(193) DESCRIBE `ports` 0.0013980865478516
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0003049373626709
(195) DESCRIBE `ports` 0.001446008682251
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00029802322387695
(197) DESCRIBE `ports` 0.0013308525085449
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00037813186645508
(199) DESCRIBE `ports` 0.0015189647674561
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.0003049373626709
(201) DESCRIBE `ports` 0.0014128684997559
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00032711029052734
(203) DESCRIBE `ports` 0.0016100406646729
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00032711029052734
(205) DESCRIBE `ports` 0.0014328956604004
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00041794776916504
(207) DESCRIBE `ports` 0.00160813331604
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00030303001403809
(209) DESCRIBE `ports` 0.001572847366333
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00032401084899902
(211) DESCRIBE `ports` 0.0020089149475098
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00037503242492676
(213) DESCRIBE `ports` 0.0013248920440674
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00033903121948242
(215) DESCRIBE `ports` 0.0017390251159668
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00032997131347656
(217) DESCRIBE `ports` 0.0016849040985107
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00038504600524902
(219) DESCRIBE `ports` 0.00166916847229
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00028705596923828
(221) DESCRIBE `ports` 0.0014920234680176
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.0003058910369873
(223) DESCRIBE `ports` 0.0016958713531494
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00035905838012695
(225) DESCRIBE `ports` 0.0019240379333496
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00042009353637695
(227) DESCRIBE `ports` 0.0018911361694336
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00037217140197754
(229) DESCRIBE `avid_specials` 0.0017409324645996
(230) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74236 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.0012519359588623
(231) DESCRIBE `cruiselines` 0.0030868053436279
(232) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.0004730224609375
(233) DESCRIBE `orchid_image` 0.0019209384918213
(234) DESCRIBE `cruiselines` 0.0026450157165527
(235) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00034594535827637
(236) DESCRIBE `cruises` 0.0041739940643311
(237) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74237') 0.00036501884460449
(238) DESCRIBE `ships` 0.0038540363311768
(239) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00047492980957031
(240) DESCRIBE `ships` 0.0036821365356445
(241) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00043511390686035
(242) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033903121948242
(243) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031399726867676
(244) DESCRIBE `itineraries` 0.0018050670623779
(245) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74237') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00078010559082031
(246) DESCRIBE `ports` 0.0019948482513428
(247) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00044918060302734
(248) DESCRIBE `ports` 0.002540111541748
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00023078918457031
(250) DESCRIBE `ports` 0.0016000270843506
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00036811828613281
(252) DESCRIBE `sailingdates` 0.001882791519165
(253) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74237') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00084996223449707
(254) DESCRIBE `ports` 0.0020990371704102
(255) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00051784515380859
(256) DESCRIBE `ports` 0.0019118785858154
(257) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 9.8943710327148E-5
(258) DESCRIBE `ports` 0.0023760795593262
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.0004429817199707
(260) DESCRIBE `ports` 0.0019650459289551
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00045394897460938
(262) DESCRIBE `ports` 0.0018489360809326
(263) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00052690505981445
(264) DESCRIBE `ports` 0.0024659633636475
(265) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00038695335388184
(266) DESCRIBE `ports` 0.0017738342285156
(267) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00039196014404297
(268) DESCRIBE `ports` 0.0017459392547607
(269) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00036287307739258
(270) DESCRIBE `ports` 0.0019440650939941
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00039315223693848
(272) DESCRIBE `ports` 0.0027401447296143
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00046896934509277
(274) DESCRIBE `ports` 0.0021529197692871
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00056314468383789
(276) DESCRIBE `ports` 0.0024099349975586
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.0003669261932373
(278) DESCRIBE `ports` 0.0024690628051758
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00062394142150879
(280) DESCRIBE `ports` 0.002169132232666
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00057077407836914
(282) DESCRIBE `ports` 0.0022590160369873
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00054693222045898
(284) DESCRIBE `ports` 0.0020191669464111
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.0003809928894043
(286) DESCRIBE `ports` 0.0036978721618652
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.001086950302124
(288) DESCRIBE `ports` 0.001986026763916
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00086283683776855
(290) DESCRIBE `ports` 0.0025041103363037
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00072407722473145
(292) DESCRIBE `ports` 0.0025701522827148
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00050520896911621
(294) DESCRIBE `avid_specials` 0.0021300315856934
(295) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74237 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.0018010139465332
(296) DESCRIBE `cruiselines` 0.0060470104217529
(297) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00044989585876465
(298) DESCRIBE `orchid_image` 0.0025691986083984
(299) DESCRIBE `cruiselines` 0.0031459331512451
(300) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00037693977355957
(301) DESCRIBE `cruises` 0.0035190582275391
(302) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67256') 0.00042414665222168
(303) DESCRIBE `ships` 0.003281831741333
(304) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00054693222045898
(305) DESCRIBE `ships` 0.0036690235137939
(306) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00036191940307617
(307) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030398368835449
(308) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029706954956055
(309) DESCRIBE `itineraries` 0.0014510154724121
(310) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67256') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00090408325195312
(311) DESCRIBE `ports` 0.0016591548919678
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00036191940307617
(313) DESCRIBE `ports` 0.0014548301696777
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00040411949157715
(315) DESCRIBE `ports` 0.0014510154724121
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00031208992004395
(317) DESCRIBE `sailingdates` 0.0012800693511963
(318) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67256') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00075817108154297
(319) DESCRIBE `ports` 0.0019619464874268
(320) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00040197372436523
(321) DESCRIBE `ports` 0.0018529891967773
(322) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00041604042053223
(323) DESCRIBE `ports` 0.0026261806488037
(324) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00047206878662109
(325) DESCRIBE `ports` 0.0019738674163818
(326) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00061297416687012
(327) DESCRIBE `ports` 0.0091478824615479
(328) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00031304359436035
(329) DESCRIBE `ports` 0.0035018920898438
(330) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00045514106750488
(331) DESCRIBE `ports` 0.0022599697113037
(332) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00041699409484863
(333) DESCRIBE `ports` 0.002338171005249
(334) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00038003921508789
(335) DESCRIBE `ports` 0.0023021697998047
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00039315223693848
(337) DESCRIBE `ports` 0.0017330646514893
(338) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00035405158996582
(339) DESCRIBE `ports` 0.0023081302642822
(340) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00039792060852051
(341) DESCRIBE `ports` 0.0018079280853271
(342) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00037384033203125
(343) DESCRIBE `ports` 0.0020179748535156
(344) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00038814544677734
(345) DESCRIBE `ports` 0.0017859935760498
(346) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00036501884460449
(347) DESCRIBE `ports` 0.0023748874664307
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00040602684020996
(349) DESCRIBE `ports` 0.0019159317016602
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00034713745117188
(351) DESCRIBE `avid_specials` 0.0015659332275391
(352) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67256 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.0014591217041016
(353) DESCRIBE `cruiselines` 0.0028901100158691
(354) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00042009353637695
(355) DESCRIBE `orchid_image` 0.0018091201782227
(356) DESCRIBE `cruiselines` 0.0023651123046875
(357) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00035405158996582
(358) DESCRIBE `cruises` 0.0035169124603271
(359) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74238') 0.0003819465637207
(360) DESCRIBE `ships` 0.0047659873962402
(361) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00058698654174805
(362) DESCRIBE `ships` 0.0036928653717041
(363) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00044584274291992
(364) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003509521484375
(365) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003359317779541
(366) DESCRIBE `itineraries` 0.0019149780273438
(367) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74238') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.000640869140625
(368) DESCRIBE `ports` 0.0020370483398438
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00040888786315918
(370) DESCRIBE `ports` 0.0018839836120605
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00040507316589355
(372) DESCRIBE `ports` 0.0022990703582764
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00036907196044922
(374) DESCRIBE `sailingdates` 0.0015411376953125
(375) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74238') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00066208839416504
(376) DESCRIBE `ports` 0.001849889755249
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00060296058654785
(378) DESCRIBE `ports` 0.0019071102142334
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0003821849822998
(380) DESCRIBE `ports` 0.0018091201782227
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00040984153747559
(382) DESCRIBE `ports` 0.001777172088623
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.00037193298339844
(384) DESCRIBE `ports` 0.0017631053924561
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00040698051452637
(386) DESCRIBE `ports` 0.0014560222625732
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00034713745117188
(388) DESCRIBE `ports` 0.0013799667358398
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00037598609924316
(390) DESCRIBE `ports` 0.0025420188903809
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00038695335388184
(392) DESCRIBE `ports` 0.0018289089202881
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00044798851013184
(394) DESCRIBE `ports` 0.0022389888763428
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00041508674621582
(396) DESCRIBE `ports` 0.0023438930511475
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0004119873046875
(398) DESCRIBE `ports` 0.0023679733276367
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00035500526428223
(400) DESCRIBE `ports` 0.0023360252380371
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.0003819465637207
(402) DESCRIBE `ports` 0.0025320053100586
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00036311149597168
(404) DESCRIBE `ports` 0.0022618770599365
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00034499168395996
(406) DESCRIBE `ports` 0.0017728805541992
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00038409233093262
(408) DESCRIBE `ports` 0.0017540454864502
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.0004270076751709
(410) DESCRIBE `ports` 0.0021040439605713
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00053000450134277
(412) DESCRIBE `ports` 0.0030300617218018
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00023007392883301
(414) DESCRIBE `ports` 0.0025210380554199
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00032615661621094
(416) DESCRIBE `ports` 0.0022618770599365
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0003960132598877
(418) DESCRIBE `ports` 0.0017409324645996
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00036501884460449
(420) DESCRIBE `ports` 0.0017020702362061
(421) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00041604042053223
(422) DESCRIBE `ports` 0.0017299652099609
(423) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.011413097381592
(424) DESCRIBE `avid_specials` 0.0017199516296387
(425) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74238 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.0017580986022949
(426) DESCRIBE `cruiselines` 0.0024938583374023
(427) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.0068330764770508
(428) DESCRIBE `orchid_image` 0.0021021366119385
(429) DESCRIBE `cruiselines` 0.0024480819702148
(430) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00039887428283691
(431) DESCRIBE `cruises` 0.0030839443206787
(432) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74239') 0.00037193298339844
(433) DESCRIBE `ships` 0.0030050277709961
(434) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00055885314941406
(435) DESCRIBE `ships` 0.0028448104858398
(436) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.012928009033203
(437) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027322769165039
(438) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030779838562012
(439) DESCRIBE `itineraries` 0.0015580654144287
(440) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74239') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0005800724029541
(441) DESCRIBE `ports` 0.0014688968658447
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00043797492980957
(443) DESCRIBE `ports` 0.0015740394592285
(444) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00032806396484375
(445) DESCRIBE `ports` 0.0015108585357666
(446) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0028560161590576
(447) DESCRIBE `sailingdates` 0.0011060237884521
(448) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74239') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00043702125549316
(449) DESCRIBE `ports` 0.001594066619873
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00031304359436035
(451) DESCRIBE `ports` 0.001352071762085
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0002899169921875
(453) DESCRIBE `ports` 0.0016648769378662
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00037407875061035
(455) DESCRIBE `ports` 0.0013489723205566
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00027704238891602
(457) DESCRIBE `ports` 0.0014359951019287
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1065))) 0.00029706954956055
(459) DESCRIBE `ports` 0.001276969909668
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1065') 0.0002751350402832
(461) DESCRIBE `ports` 0.0013117790222168
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00031685829162598
(463) DESCRIBE `ports` 0.0012540817260742
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00045990943908691
(465) DESCRIBE `ports` 0.0014989376068115
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 9.7036361694336E-5
(467) DESCRIBE `ports` 0.0011889934539795
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00027799606323242
(469) DESCRIBE `ports` 0.0011138916015625
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00029683113098145
(471) DESCRIBE `ports` 0.0013751983642578
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00029897689819336
(473) DESCRIBE `ports` 0.001755952835083
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00041389465332031
(475) DESCRIBE `ports` 0.0014090538024902
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.0003349781036377
(477) DESCRIBE `ports` 0.0014691352844238
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00043797492980957
(479) DESCRIBE `ports` 0.0017127990722656
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00034809112548828
(481) DESCRIBE `ports` 0.0012650489807129
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00030994415283203
(483) DESCRIBE `ports` 0.0013949871063232
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00032997131347656
(485) DESCRIBE `ports` 0.0014519691467285
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00038480758666992
(487) DESCRIBE `ports` 0.0015780925750732
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00032401084899902
(489) DESCRIBE `ports` 0.0016129016876221
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00043821334838867
(491) DESCRIBE `ports` 0.0015418529510498
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00031304359436035
(493) DESCRIBE `avid_specials` 0.0014710426330566
(494) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74239 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.0017271041870117
(495) DESCRIBE `cruiselines` 0.0026459693908691
(496) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00047588348388672
(497) DESCRIBE `orchid_image` 0.0021378993988037
(498) DESCRIBE `cruiselines` 0.0038399696350098
(499) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00040006637573242
(500) DESCRIBE `cruises` 0.0049428939819336
(501) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74240') 0.00041007995605469
(502) DESCRIBE `ships` 0.0030579566955566
(503) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.00047898292541504
(504) DESCRIBE `ships` 0.0028870105743408
(505) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '93') 0.00034904479980469
(506) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029301643371582
(507) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025701522827148
(508) DESCRIBE `itineraries` 0.0013530254364014
(509) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '74240') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00052404403686523
(510) DESCRIBE `ports` 0.0012998580932617
(511) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00031399726867676
(512) DESCRIBE `ports` 0.0013039112091064
(513) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0002892017364502
(514) DESCRIBE `ports` 0.0015649795532227
(515) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00028610229492188
(516) DESCRIBE `sailingdates` 0.0012249946594238
(517) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '74240') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00050210952758789
(518) DESCRIBE `ports` 0.0013809204101562
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00035691261291504
(520) DESCRIBE `ports` 0.0013599395751953
(521) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00028109550476074
(522) DESCRIBE `ports` 0.0015919208526611
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00038290023803711
(524) DESCRIBE `ports` 0.0015711784362793
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00036001205444336
(526) DESCRIBE `ports` 0.0016500949859619
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00036787986755371
(528) DESCRIBE `ports` 0.0015997886657715
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00027894973754883
(530) DESCRIBE `ports` 0.0016341209411621
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00054502487182617
(532) DESCRIBE `ports` 0.0017621517181396
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00039100646972656
(534) DESCRIBE `ports` 0.0014920234680176
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00037908554077148
(536) DESCRIBE `ports` 0.0019221305847168
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00044393539428711
(538) DESCRIBE `ports` 0.0019781589508057
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00046706199645996
(540) DESCRIBE `ports` 0.0019409656524658
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00040197372436523
(542) DESCRIBE `ports` 0.0019118785858154
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00044608116149902
(544) DESCRIBE `ports` 0.0018370151519775
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00039887428283691
(546) DESCRIBE `ports` 0.0018811225891113
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00045609474182129
(548) DESCRIBE `ports` 0.0018730163574219
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00039196014404297
(550) DESCRIBE `ports` 0.0018930435180664
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00042390823364258
(552) DESCRIBE `ports` 0.0014030933380127
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00028705596923828
(554) DESCRIBE `ports` 0.0012731552124023
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00031280517578125
(556) DESCRIBE `ports` 0.0017180442810059
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00031304359436035
(558) DESCRIBE `ports` 0.0016000270843506
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1509))) 0.00035810470581055
(560) DESCRIBE `ports` 0.0013778209686279
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1509') 0.00038409233093262
(562) DESCRIBE `ports` 0.0015652179718018
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00040698051452637
(564) DESCRIBE `ports` 0.0013730525970459
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00035190582275391
(566) DESCRIBE `avid_specials` 0.0012450218200684
(567) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74240 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.0010631084442139
(568) DESCRIBE `cruiselines` 0.0019779205322266
(569) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00018811225891113
(570) DESCRIBE `orchid_image` 0.0015318393707275
(571) DESCRIBE `cruiselines` 0.0019240379333496
(572) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.00041508674621582
(573) DESCRIBE `cruisetypes` 0.0016069412231445
(574) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruises_and_specials.destination_id = '22') 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.039908885955811
(575) DESCRIBE `cruiselines` 0.0028519630432129
(576) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00046896934509277
(577) DESCRIBE `ships` 0.0037028789520264
(578) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.0005340576171875
(579) DESCRIBE `destinations` 0.0025389194488525
(580) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 22))) 0.00042200088500977
(581) DESCRIBE `destinations` 0.0025179386138916
(582) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 22))) 0.00046491622924805
(583) DESCRIBE `cruiselines` 0.0025689601898193
(584) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00043296813964844
(585) DESCRIBE `ships` 0.0039129257202148
(586) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 93))) 0.000579833984375