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

Total elapsed time: 0.52931475639343

# Query Time
(1) connect 0.00085210800170898
(2) DESCRIBE `cruises` 0.0041348934173584
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (55703, 50857, 41776, 41778, 65890, 41780, 74880, 65892, 65893, 50866)) ORDER BY FIND_IN_SET(id, '55703,50857,41776,41778,65890,41780,74880,65892,65893,50866') 0.0025780200958252
(4) DESCRIBE `cruises` 0.0043299198150635
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55703') 0.00014519691467285
(6) DESCRIBE `ships` 0.0038869380950928
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00048494338989258
(8) DESCRIBE `ships` 0.0036840438842773
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00046706199645996
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033712387084961
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00038313865661621
(12) DESCRIBE `itineraries` 0.0017740726470947
(13) DESCRIBE `ports` 0.0017719268798828
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0005180835723877
(15) DESCRIBE `ports` 0.0017960071563721
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00041604042053223
(17) DESCRIBE `ports` 0.0018148422241211
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0003809928894043
(19) DESCRIBE `sailingdates` 0.0017309188842773
(20) DESCRIBE `ports` 0.00189208984375
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042819976806641
(22) DESCRIBE `ports` 0.0018119812011719
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00035977363586426
(24) DESCRIBE `ports` 0.0017979145050049
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4450))) 0.00040483474731445
(26) DESCRIBE `ports` 0.0017580986022949
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4450') 0.00061392784118652
(28) DESCRIBE `ports` 0.0017499923706055
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00038599967956543
(30) DESCRIBE `ports` 0.0018191337585449
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00035905838012695
(32) DESCRIBE `avid_specials` 0.0016410350799561
(33) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55703 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0015959739685059
(34) DESCRIBE `cruiselines` 0.0025510787963867
(35) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00050997734069824
(36) DESCRIBE `orchid_image` 0.0020530223846436
(37) DESCRIBE `cruiselines` 0.0026488304138184
(38) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00043511390686035
(39) DESCRIBE `cruises` 0.0036208629608154
(40) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50857') 0.00043988227844238
(41) DESCRIBE `ships` 0.003709077835083
(42) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00053191184997559
(43) DESCRIBE `ships` 0.0038900375366211
(44) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00048589706420898
(45) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036001205444336
(46) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00035214424133301
(47) DESCRIBE `itineraries` 0.0063660144805908
(48) DESCRIBE `ports` 0.0015599727630615
(49) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036215782165527
(50) DESCRIBE `ports` 0.0014848709106445
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034809112548828
(52) DESCRIBE `ports` 0.0014801025390625
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029182434082031
(54) DESCRIBE `sailingdates` 0.0011610984802246
(55) DESCRIBE `ports` 0.0017402172088623
(56) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0
(57) DESCRIBE `ports` 0.0013570785522461
(58) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00068998336791992
(59) DESCRIBE `ports` 0.0012519359588623
(60) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0003209114074707
(61) DESCRIBE `ports` 0.0009160041809082
(62) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00072813034057617
(63) DESCRIBE `ports` 0.0012199878692627
(64) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.00030398368835449
(65) DESCRIBE `ports` 0.0013229846954346
(66) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0
(67) DESCRIBE `ports` 0.0013837814331055
(68) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00031590461730957
(69) DESCRIBE `ports` 0.0014009475708008
(70) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00035405158996582
(71) DESCRIBE `ports` 0.001101016998291
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00083112716674805
(73) DESCRIBE `ports` 0.00092411041259766
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00030517578125
(75) DESCRIBE `ports` 0.0016438961029053
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00027608871459961
(77) DESCRIBE `ports` 0.0014238357543945
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0004730224609375
(79) DESCRIBE `avid_specials` 0.0011289119720459
(80) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 50857 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0011048316955566
(81) DESCRIBE `cruiselines` 0.0027689933776855
(82) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00021195411682129
(83) DESCRIBE `orchid_image` 0.0020830631256104
(84) DESCRIBE `cruiselines` 0.0025069713592529
(85) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00062704086303711
(86) DESCRIBE `cruises` 0.0035538673400879
(87) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41776') 0.00032496452331543
(88) DESCRIBE `ships` 0.0025789737701416
(89) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.0004119873046875
(90) DESCRIBE `ships` 0.002924919128418
(91) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00036287307739258
(92) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00010800361633301
(93) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00068092346191406
(94) DESCRIBE `itineraries` 0.00094318389892578
(95) DESCRIBE `ports` 0.0013351440429688
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00056004524230957
(97) DESCRIBE `ports` 0.0018439292907715
(98) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 9.7036361694336E-5
(99) DESCRIBE `ports` 0.0013189315795898
(100) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0004570484161377
(101) DESCRIBE `sailingdates` 0.0011160373687744
(102) DESCRIBE `ports` 0.0015699863433838
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042009353637695
(104) DESCRIBE `ports` 0.0024619102478027
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031590461730957
(106) DESCRIBE `ports` 0.0018391609191895
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00033807754516602
(108) DESCRIBE `ports` 0.0015199184417725
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00035810470581055
(110) DESCRIBE `ports` 0.0013320446014404
(111) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00031590461730957
(112) DESCRIBE `ports` 0.0015180110931396
(113) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00036311149597168
(114) DESCRIBE `ports` 0.0014400482177734
(115) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00034093856811523
(116) DESCRIBE `ports` 0.0012638568878174
(117) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00027298927307129
(118) DESCRIBE `ports` 0.0013859272003174
(119) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003349781036377
(120) DESCRIBE `ports` 0.0013577938079834
(121) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028896331787109
(122) DESCRIBE `avid_specials` 0.0012528896331787
(123) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41776 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.001248836517334
(124) DESCRIBE `cruiselines` 0.0020430088043213
(125) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00034308433532715
(126) DESCRIBE `orchid_image` 0.0015161037445068
(127) DESCRIBE `cruiselines` 0.0020191669464111
(128) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00033211708068848
(129) DESCRIBE `cruises` 0.0027821063995361
(130) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41778') 0.00037097930908203
(131) DESCRIBE `ships` 0.0026209354400635
(132) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00036001205444336
(133) DESCRIBE `ships` 0.0026459693908691
(134) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00028705596923828
(135) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024795532226562
(136) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025510787963867
(137) DESCRIBE `itineraries` 0.0013198852539062
(138) DESCRIBE `ports` 0.0029420852661133
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034594535827637
(140) DESCRIBE `ports` 0.0015339851379395
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035786628723145
(142) DESCRIBE `ports` 0.0012669563293457
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030016899108887
(144) DESCRIBE `sailingdates` 0.0011169910430908
(145) DESCRIBE `ports` 0.001945972442627
(146) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003211498260498
(147) DESCRIBE `ports` 0.0012369155883789
(148) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027608871459961
(149) DESCRIBE `ports` 0.001802921295166
(150) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032186508178711
(151) DESCRIBE `ports` 0.0023767948150635
(152) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00045204162597656
(153) DESCRIBE `avid_specials` 0.0015649795532227
(154) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41778 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0016119480133057
(155) DESCRIBE `cruiselines` 0.0029699802398682
(156) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00043296813964844
(157) DESCRIBE `orchid_image` 0.0018150806427002
(158) DESCRIBE `cruiselines` 0.0023469924926758
(159) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0003349781036377
(160) DESCRIBE `cruises` 0.003201961517334
(161) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65890') 0.00041103363037109
(162) DESCRIBE `ships` 0.0032851696014404
(163) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00049209594726562
(164) DESCRIBE `ships` 0.0041468143463135
(165) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.0003969669342041
(166) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003201961517334
(167) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003058910369873
(168) DESCRIBE `itineraries` 0.0042269229888916
(169) DESCRIBE `ports` 0.0018949508666992
(170) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048995018005371
(171) DESCRIBE `ports` 0.0018489360809326
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00036001205444336
(173) DESCRIBE `ports` 0.0017518997192383
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038504600524902
(175) DESCRIBE `sailingdates` 0.0014820098876953
(176) DESCRIBE `ports` 0.0018870830535889
(177) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00044894218444824
(178) DESCRIBE `ports` 0.0018200874328613
(179) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00039505958557129
(180) DESCRIBE `ports` 0.001816987991333
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00045204162597656
(182) DESCRIBE `ports` 0.0018310546875
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00037002563476562
(184) DESCRIBE `ports` 0.0018801689147949
(185) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00043201446533203
(186) DESCRIBE `ports` 0.0018489360809326
(187) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00036811828613281
(188) DESCRIBE `ports` 0.0019412040710449
(189) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0003960132598877
(190) DESCRIBE `ports` 0.0018250942230225
(191) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00040793418884277
(192) DESCRIBE `ports` 0.0018229484558105
(193) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 438))) 0.0004878044128418
(194) DESCRIBE `ports` 0.0018429756164551
(195) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '438') 0.00037503242492676
(196) DESCRIBE `ports` 0.0018508434295654
(197) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 80))) 0.00040817260742188
(198) DESCRIBE `ports` 0.0018689632415771
(199) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '80') 0.00035881996154785
(200) DESCRIBE `ports` 0.0018088817596436
(201) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042200088500977
(202) DESCRIBE `ports` 0.0017721652984619
(203) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00044989585876465
(204) DESCRIBE `avid_specials` 0.0015509128570557
(205) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65890 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0010778903961182
(206) DESCRIBE `cruiselines` 0.0018548965454102
(207) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00034308433532715
(208) DESCRIBE `orchid_image` 0.0014088153839111
(209) DESCRIBE `cruiselines` 0.0021209716796875
(210) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00027799606323242
(211) DESCRIBE `cruises` 0.0028069019317627
(212) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '41780') 0.00029993057250977
(213) DESCRIBE `ships` 0.002525806427002
(214) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00037193298339844
(215) DESCRIBE `ships` 0.0024909973144531
(216) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00028014183044434
(217) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026488304138184
(218) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00036406517028809
(219) DESCRIBE `itineraries` 0.0013360977172852
(220) DESCRIBE `ports` 0.0013110637664795
(221) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00032782554626465
(222) DESCRIBE `ports` 0.0012660026550293
(223) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00028896331787109
(224) DESCRIBE `ports` 0.0013039112091064
(225) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031614303588867
(226) DESCRIBE `sailingdates` 0.0014848709106445
(227) DESCRIBE `ports` 0.0014710426330566
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00033712387084961
(229) DESCRIBE `ports` 0.0013320446014404
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00027894973754883
(231) DESCRIBE `ports` 0.0013060569763184
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.0003359317779541
(233) DESCRIBE `ports` 0.0012650489807129
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00036716461181641
(235) DESCRIBE `ports` 0.0016400814056396
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00030612945556641
(237) DESCRIBE `ports` 0.0013668537139893
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00030803680419922
(239) DESCRIBE `ports` 0.0014400482177734
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00031495094299316
(241) DESCRIBE `ports` 0.0012590885162354
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00028800964355469
(243) DESCRIBE `ports` 0.0012621879577637
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003819465637207
(245) DESCRIBE `ports` 0.0017080307006836
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00030803680419922
(247) DESCRIBE `avid_specials` 0.0011420249938965
(248) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 41780 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0011241436004639
(249) DESCRIBE `cruiselines` 0.0018692016601562
(250) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00047206878662109
(251) DESCRIBE `orchid_image` 0.0014090538024902
(252) DESCRIBE `cruiselines` 0.0018901824951172
(253) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00031304359436035
(254) DESCRIBE `cruises` 0.0025179386138916
(255) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '74880') 0.00033688545227051
(256) DESCRIBE `ships` 0.0025210380554199
(257) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00040006637573242
(258) DESCRIBE `ships` 0.0025231838226318
(259) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00028610229492188
(260) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00031304359436035
(261) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00043988227844238
(262) DESCRIBE `itineraries` 0.0012481212615967
(263) DESCRIBE `ports` 0.001755952835083
(264) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00040316581726074
(265) DESCRIBE `ports` 0.0013580322265625
(266) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030398368835449
(267) DESCRIBE `ports` 0.0013189315795898
(268) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00034117698669434
(269) DESCRIBE `sailingdates` 0.0011498928070068
(270) DESCRIBE `ports` 0.0013740062713623
(271) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003669261932373
(272) DESCRIBE `ports` 0.0014770030975342
(273) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002892017364502
(274) DESCRIBE `ports` 0.0012879371643066
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00043988227844238
(276) DESCRIBE `ports` 0.0013031959533691
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00027108192443848
(278) DESCRIBE `ports` 0.0013370513916016
(279) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00013399124145508
(280) DESCRIBE `ports` 0.0012979507446289
(281) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00028300285339355
(282) DESCRIBE `ports` 0.0013351440429688
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00030899047851562
(284) DESCRIBE `ports` 0.0016090869903564
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00029993057250977
(286) DESCRIBE `avid_specials` 0.001154899597168
(287) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 74880 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0010099411010742
(288) DESCRIBE `cruiselines` 0.0019609928131104
(289) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.0003352165222168
(290) DESCRIBE `orchid_image` 0.0019421577453613
(291) DESCRIBE `cruiselines` 0.001910924911499
(292) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00040602684020996
(293) DESCRIBE `cruises` 0.0034871101379395
(294) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65892') 0.00038504600524902
(295) DESCRIBE `ships` 0.0026490688323975
(296) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.0004880428314209
(297) DESCRIBE `ships` 0.0027308464050293
(298) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00023007392883301
(299) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026607513427734
(300) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025415420532227
(301) DESCRIBE `itineraries` 0.0012359619140625
(302) DESCRIBE `ports` 0.0014510154724121
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034999847412109
(304) DESCRIBE `ports` 0.0013329982757568
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031304359436035
(306) DESCRIBE `ports` 0.0012860298156738
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028800964355469
(308) DESCRIBE `sailingdates` 0.0013039112091064
(309) DESCRIBE `ports` 0.0012969970703125
(310) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00034117698669434
(311) DESCRIBE `ports` 0.0013260841369629
(312) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002899169921875
(313) DESCRIBE `ports` 0.0012619495391846
(314) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.0003201961517334
(315) DESCRIBE `ports` 0.0013580322265625
(316) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00029397010803223
(317) DESCRIBE `ports` 0.001255989074707
(318) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00030803680419922
(319) DESCRIBE `ports` 0.0013048648834229
(320) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.0002741813659668
(321) DESCRIBE `ports` 0.0014288425445557
(322) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.0003058910369873
(323) DESCRIBE `ports` 0.0016682147979736
(324) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00034499168395996
(325) DESCRIBE `ports` 0.0016651153564453
(326) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00017094612121582
(327) DESCRIBE `ports` 0.0013828277587891
(328) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00028681755065918
(329) DESCRIBE `avid_specials` 0.0014588832855225
(330) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65892 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0010809898376465
(331) DESCRIBE `cruiselines` 0.0019791126251221
(332) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00028896331787109
(333) DESCRIBE `orchid_image` 0.0014629364013672
(334) DESCRIBE `cruiselines` 0.0018749237060547
(335) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.0003199577331543
(336) DESCRIBE `cruises` 0.0027079582214355
(337) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65893') 0.00037789344787598
(338) DESCRIBE `ships` 0.0028460025787354
(339) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00037693977355957
(340) DESCRIBE `ships` 0.0027570724487305
(341) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00043511390686035
(342) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034594535827637
(343) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026321411132812
(344) DESCRIBE `itineraries` 0.0013840198516846
(345) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65893') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00072002410888672
(346) DESCRIBE `ports` 0.0013930797576904
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042295455932617
(348) DESCRIBE `ports` 0.0012991428375244
(349) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.0003058910369873
(350) DESCRIBE `ports` 0.0017011165618896
(351) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00038695335388184
(352) DESCRIBE `sailingdates` 0.0016829967498779
(353) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65893') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00069117546081543
(354) DESCRIBE `ports` 0.0020649433135986
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00048613548278809
(356) DESCRIBE `ports` 0.0018861293792725
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00035405158996582
(358) DESCRIBE `ports` 0.0016498565673828
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 439))) 0.00036096572875977
(360) DESCRIBE `ports` 0.0013549327850342
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '439') 0.00030303001403809
(362) DESCRIBE `ports` 0.0013401508331299
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 435))) 0.00031900405883789
(364) DESCRIBE `ports` 0.0013179779052734
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '435') 0.00040197372436523
(366) DESCRIBE `ports` 0.0013091564178467
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 436))) 0.00034618377685547
(368) DESCRIBE `ports` 0.0014710426330566
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '436') 0.00034618377685547
(370) DESCRIBE `ports` 0.0012779235839844
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3016))) 0.00033807754516602
(372) DESCRIBE `ports` 0.0018088817596436
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3016') 0.00035405158996582
(374) DESCRIBE `ports` 0.0019099712371826
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031590461730957
(376) DESCRIBE `ports` 0.0012779235839844
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00033116340637207
(378) DESCRIBE `avid_specials` 0.0011239051818848
(379) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65893 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0011770725250244
(380) DESCRIBE `cruiselines` 0.0021400451660156
(381) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00036382675170898
(382) DESCRIBE `orchid_image` 0.0013301372528076
(383) DESCRIBE `cruiselines` 0.001990795135498
(384) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00040912628173828
(385) DESCRIBE `cruises` 0.0034089088439941
(386) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50866') 0.00074195861816406
(387) DESCRIBE `ships` 0.0027070045471191
(388) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00018501281738281
(389) DESCRIBE `ships` 0.0032179355621338
(390) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '4') 0.00037598609924316
(391) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027012825012207
(392) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029397010803223
(393) DESCRIBE `itineraries` 0.0016210079193115
(394) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '50866') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0007469654083252
(395) DESCRIBE `ports` 0.0016319751739502
(396) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00035405158996582
(397) DESCRIBE `ports` 0.0014700889587402
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00042605400085449
(399) DESCRIBE `ports` 0.0013959407806396
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031208992004395
(401) DESCRIBE `sailingdates` 0.0011618137359619
(402) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '50866') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00080394744873047
(403) DESCRIBE `ports` 0.0014698505401611
(404) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00058794021606445
(405) DESCRIBE `ports` 0.0013730525970459
(406) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.00031685829162598
(407) DESCRIBE `ports` 0.0014069080352783
(408) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00033688545227051
(409) DESCRIBE `ports` 0.0013060569763184
(410) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00027894973754883
(411) DESCRIBE `ports` 0.0014619827270508
(412) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00036716461181641
(413) DESCRIBE `ports` 0.0012838840484619
(414) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00033688545227051
(415) DESCRIBE `ports` 0.001262903213501
(416) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 20))) 0.00030016899108887
(417) DESCRIBE `ports` 0.0015649795532227
(418) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '20') 0.00028300285339355
(419) DESCRIBE `ports` 0.0013549327850342
(420) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 19))) 0.00031900405883789
(421) DESCRIBE `ports` 0.0012998580932617
(422) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '19') 0.0002899169921875
(423) DESCRIBE `avid_specials` 0.0012581348419189
(424) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 50866 and class = 'Cruise') OR (item_id = 4 AND class = 'Ship') OR (item_id = 4 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.0010731220245361
(425) DESCRIBE `cruiselines` 0.0018539428710938
(426) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00034904479980469
(427) DESCRIBE `orchid_image` 0.0014050006866455
(428) DESCRIBE `cruiselines` 0.0018138885498047
(429) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '4') 0.00016403198242188
(430) DESCRIBE `cruisetypes` 0.0011560916900635
(431) 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 = '4') AND (cruises_and_specials.ship_id = '4') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.02861213684082
(432) DESCRIBE `destinations` 0.0020508766174316
(433) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('43', '8')) ORDER BY FIND_IN_SET(id, '43,8') 0.0005500316619873
(434) DESCRIBE `cruiselines` 0.0018119812011719
(435) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00032997131347656
(436) DESCRIBE `ships` 0.0025110244750977
(437) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00034904479980469
(438) DESCRIBE `cruiselines` 0.0018248558044434
(439) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 4))) 0.00034999847412109
(440) DESCRIBE `ships` 0.0025949478149414
(441) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 4))) 0.00042104721069336