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

Total elapsed time: 0.59300184249878

# Query Time
(1) connect 0.0012640953063965
(2) DESCRIBE `cruises` 0.0037319660186768
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (57159, 67970, 67998, 69079, 71452, 71457, 65603, 67956, 50721, 59379)) ORDER BY FIND_IN_SET(id, '57159,67970,67998,69079,71452,71457,65603,67956,50721,59379') 0.002140998840332
(4) DESCRIBE `cruises` 0.0029349327087402
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '57159') 0.0003669261932373
(6) DESCRIBE `ships` 0.0025820732116699
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 352))) 0.00049805641174316
(8) DESCRIBE `ships` 0.0025599002838135
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '352') 0.00031614303588867
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025296211242676
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024294853210449
(12) DESCRIBE `itineraries` 0.0013887882232666
(13) DESCRIBE `ports` 0.0014009475708008
(14) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00036382675170898
(15) DESCRIBE `ports` 0.0012600421905518
(16) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00028610229492188
(17) DESCRIBE `ports` 0.001262903213501
(18) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00029611587524414
(19) DESCRIBE `sailingdates` 0.0011181831359863
(20) DESCRIBE `ports` 0.0012598037719727
(21) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0002892017364502
(22) DESCRIBE `ports` 0.0012190341949463
(23) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0003199577331543
(24) DESCRIBE `ports` 0.0012381076812744
(25) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 764))) 0.00028586387634277
(26) DESCRIBE `ports` 0.0012190341949463
(27) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '764') 0.00027799606323242
(28) DESCRIBE `ports` 0.0012211799621582
(29) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00029802322387695
(30) DESCRIBE `ports` 0.0013411045074463
(31) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.0002739429473877
(32) DESCRIBE `ports` 0.0011301040649414
(33) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 534))) 0.0003659725189209
(34) DESCRIBE `ports` 0.0013141632080078
(35) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '534') 0.00027298927307129
(36) DESCRIBE `ports` 0.0012400150299072
(37) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00029706954956055
(38) DESCRIBE `ports` 0.0012869834899902
(39) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00026702880859375
(40) DESCRIBE `ports` 0.0012669563293457
(41) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00028395652770996
(42) DESCRIBE `ports` 0.0012359619140625
(43) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00026702880859375
(44) DESCRIBE `ports` 0.001255989074707
(45) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00035285949707031
(46) DESCRIBE `ports` 0.0012409687042236
(47) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00026988983154297
(48) DESCRIBE `avid_specials` 0.0012280941009521
(49) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 57159 and class = 'Cruise') OR (item_id = 352 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010089874267578
(50) DESCRIBE `cruiselines` 0.0020089149475098
(51) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00013208389282227
(52) DESCRIBE `orchid_image` 0.0014629364013672
(53) DESCRIBE `cruiselines` 0.0018899440765381
(54) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0011460781097412
(55) DESCRIBE `cruises` 0.0025670528411865
(56) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67970') 3.3140182495117E-5
(57) DESCRIBE `ships` 0.0025310516357422
(58) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 977))) 0
(59) DESCRIBE `ships` 0.0029220581054688
(60) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '977') 0.00036311149597168
(61) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026297569274902
(62) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00024700164794922
(63) DESCRIBE `itineraries` 0.0014159679412842
(64) DESCRIBE `ports` 0.001288890838623
(65) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00034785270690918
(66) DESCRIBE `ports` 0.0023388862609863
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00029802322387695
(68) DESCRIBE `ports` 0.001392126083374
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00027799606323242
(70) DESCRIBE `sailingdates` 0.001101016998291
(71) DESCRIBE `ports` 0.0012369155883789
(72) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00030899047851562
(73) DESCRIBE `ports` 0.0012941360473633
(74) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00026893615722656
(75) DESCRIBE `ports` 0.0012221336364746
(76) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00029110908508301
(77) DESCRIBE `ports` 0.0012590885162354
(78) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00026488304138184
(79) DESCRIBE `ports` 0.0012679100036621
(80) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00028610229492188
(81) DESCRIBE `ports` 0.0012960433959961
(82) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00026607513427734
(83) DESCRIBE `ports` 0.0012199878692627
(84) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 695))) 0.00029301643371582
(85) DESCRIBE `ports` 0.0013198852539062
(86) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '695') 0.00027298927307129
(87) DESCRIBE `ports` 0.0012819766998291
(88) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00029706954956055
(89) DESCRIBE `ports` 0.0012810230255127
(90) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00026297569274902
(91) DESCRIBE `ports` 0.0012209415435791
(92) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00027990341186523
(93) DESCRIBE `ports` 0.0012829303741455
(94) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00026512145996094
(95) DESCRIBE `ports` 0.0013511180877686
(96) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 763))) 0.00033903121948242
(97) DESCRIBE `ports` 0.0014729499816895
(98) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '763') 0.00026583671569824
(99) DESCRIBE `ports` 0.0012271404266357
(100) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00029897689819336
(101) DESCRIBE `ports` 0.001492977142334
(102) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00027108192443848
(103) DESCRIBE `avid_specials` 0.0012052059173584
(104) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67970 and class = 'Cruise') OR (item_id = 977 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011558532714844
(105) DESCRIBE `cruiselines` 0.0018579959869385
(106) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0003049373626709
(107) DESCRIBE `orchid_image` 0.001460075378418
(108) DESCRIBE `cruiselines` 0.0017590522766113
(109) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.0002741813659668
(110) DESCRIBE `cruises` 0.0023729801177979
(111) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67998') 0.00027990341186523
(112) DESCRIBE `ships` 0.0025391578674316
(113) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 726))) 0.00036287307739258
(114) DESCRIBE `ships` 0.0026860237121582
(115) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '726') 0.00028896331787109
(116) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026106834411621
(117) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027823448181152
(118) DESCRIBE `itineraries` 0.0015790462493896
(119) DESCRIBE `ports` 0.0012989044189453
(120) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0
(121) DESCRIBE `ports` 0.0010230541229248
(122) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00029516220092773
(123) DESCRIBE `ports` 0.0012660026550293
(124) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00027704238891602
(125) DESCRIBE `sailingdates` 0.001194953918457
(126) DESCRIBE `ports` 0.0012450218200684
(127) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00031304359436035
(128) DESCRIBE `ports` 0.001349925994873
(129) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00032401084899902
(130) DESCRIBE `ports` 0.001230001449585
(131) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2264))) 0.00030207633972168
(132) DESCRIBE `ports` 0.001284122467041
(133) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2264') 0.00026392936706543
(134) DESCRIBE `ports` 0.0015687942504883
(135) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00033903121948242
(136) DESCRIBE `ports` 0.001378059387207
(137) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00032210350036621
(138) DESCRIBE `ports` 0.0012381076812744
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00033402442932129
(140) DESCRIBE `ports` 0.0013198852539062
(141) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00027680397033691
(142) DESCRIBE `ports` 0.0012798309326172
(143) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00031304359436035
(144) DESCRIBE `ports` 0.0020718574523926
(145) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00029492378234863
(146) DESCRIBE `ports` 0.001288890838623
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 582))) 0.00029301643371582
(148) DESCRIBE `ports` 0.0012388229370117
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '582') 0.00033688545227051
(150) DESCRIBE `ports` 0.0013868808746338
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00030708312988281
(152) DESCRIBE `ports` 0.0012350082397461
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00031208992004395
(154) DESCRIBE `ports` 0.0012609958648682
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 210))) 0.00030398368835449
(156) DESCRIBE `ports` 0.0013320446014404
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '210') 0.00034308433532715
(158) DESCRIBE `ports` 0.0012350082397461
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0003211498260498
(160) DESCRIBE `ports` 0.0012907981872559
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00027298927307129
(162) DESCRIBE `avid_specials` 0.0011069774627686
(163) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67998 and class = 'Cruise') OR (item_id = 726 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0013659000396729
(164) DESCRIBE `cruiselines` 0.0020780563354492
(165) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00034213066101074
(166) DESCRIBE `orchid_image` 0.0015630722045898
(167) DESCRIBE `cruiselines` 0.0020179748535156
(168) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00034594535827637
(169) DESCRIBE `cruises` 0.0025241374969482
(170) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '69079') 0.00040197372436523
(171) DESCRIBE `ships` 0.0027890205383301
(172) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1588))) 0.00046396255493164
(173) DESCRIBE `ships` 0.002979040145874
(174) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1588') 0.0003199577331543
(175) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026607513427734
(176) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028395652770996
(177) DESCRIBE `itineraries` 0.0012869834899902
(178) DESCRIBE `ports` 0.001507043838501
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00034999847412109
(180) DESCRIBE `ports` 0.0013270378112793
(181) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00031208992004395
(182) DESCRIBE `ports` 0.0013270378112793
(183) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00033402442932129
(184) DESCRIBE `sailingdates` 0.00051689147949219
(185) DESCRIBE `ports` 0.0014050006866455
(186) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.0003659725189209
(187) DESCRIBE `ports` 0.0015830993652344
(188) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00029683113098145
(189) DESCRIBE `ports` 0.0013058185577393
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00031185150146484
(191) DESCRIBE `ports` 0.0013909339904785
(192) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00028300285339355
(193) DESCRIBE `ports` 0.0013489723205566
(194) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00030684471130371
(195) DESCRIBE `ports` 0.0013391971588135
(196) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00028514862060547
(197) DESCRIBE `ports` 0.0014128684997559
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00031208992004395
(199) DESCRIBE `ports` 0.001248836517334
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.0002748966217041
(201) DESCRIBE `ports` 0.0012710094451904
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00032401084899902
(203) DESCRIBE `ports` 0.00152587890625
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00043106079101562
(205) DESCRIBE `ports` 0.0015208721160889
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00039100646972656
(207) DESCRIBE `ports` 0.0013859272003174
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00028514862060547
(209) DESCRIBE `ports` 0.0013391971588135
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00036382675170898
(211) DESCRIBE `ports` 0.0013699531555176
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00028300285339355
(213) DESCRIBE `avid_specials` 0.0011539459228516
(214) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 69079 and class = 'Cruise') OR (item_id = 1588 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0010349750518799
(215) DESCRIBE `cruiselines` 0.0018301010131836
(216) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0003209114074707
(217) DESCRIBE `orchid_image` 0.0022170543670654
(218) DESCRIBE `cruiselines` 0.002892017364502
(219) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00048112869262695
(220) DESCRIBE `cruises` 0.0034289360046387
(221) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71452') 0.00039196014404297
(222) DESCRIBE `ships` 0.0036771297454834
(223) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 452))) 0.00051999092102051
(224) DESCRIBE `ships` 0.0035440921783447
(225) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '452') 0.00029492378234863
(226) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026702880859375
(227) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028181076049805
(228) DESCRIBE `itineraries` 0.0012190341949463
(229) DESCRIBE `ports` 0.0012989044189453
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00033402442932129
(231) DESCRIBE `ports` 0.0013730525970459
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00032401084899902
(233) DESCRIBE `ports` 0.0014328956604004
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00038385391235352
(235) DESCRIBE `sailingdates` 0.0015890598297119
(236) DESCRIBE `ports` 0.0015139579772949
(237) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00034022331237793
(238) DESCRIBE `ports` 0.0012679100036621
(239) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00030088424682617
(240) DESCRIBE `ports` 0.0016391277313232
(241) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0003209114074707
(242) DESCRIBE `ports` 0.0015659332275391
(243) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.0003669261932373
(244) DESCRIBE `ports` 0.0013930797576904
(245) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00033211708068848
(246) DESCRIBE `ports` 0.001561164855957
(247) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00036501884460449
(248) DESCRIBE `ports` 0.0015671253204346
(249) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00033712387084961
(250) DESCRIBE `ports` 0.001323938369751
(251) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00030803680419922
(252) DESCRIBE `ports` 0.0013599395751953
(253) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.0003361701965332
(254) DESCRIBE `ports` 0.0013802051544189
(255) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00031900405883789
(256) DESCRIBE `ports` 0.0015528202056885
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.0003049373626709
(258) DESCRIBE `ports` 0.0014200210571289
(259) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00028896331787109
(260) DESCRIBE `ports` 0.0012459754943848
(261) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00030994415283203
(262) DESCRIBE `ports` 0.0013401508331299
(263) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00027298927307129
(264) DESCRIBE `avid_specials` 0.0011529922485352
(265) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71452 and class = 'Cruise') OR (item_id = 452 AND class = 'Ship') OR (item_id = 19 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.0010290145874023
(266) DESCRIBE `cruiselines` 0.0022389888763428
(267) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0004270076751709
(268) DESCRIBE `orchid_image` 0.0018010139465332
(269) DESCRIBE `cruiselines` 0.0020060539245605
(270) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00032877922058105
(271) DESCRIBE `cruises` 0.0024750232696533
(272) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '71457') 0.00034785270690918
(273) DESCRIBE `ships` 0.0030651092529297
(274) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 407))) 0.00052022933959961
(275) DESCRIBE `ships` 0.0032379627227783
(276) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '407') 0.00029706954956055
(277) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026798248291016
(278) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025486946105957
(279) DESCRIBE `itineraries` 0.0012450218200684
(280) DESCRIBE `ports` 0.0013418197631836
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00031900405883789
(282) DESCRIBE `ports` 0.0012719631195068
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.0003819465637207
(284) DESCRIBE `ports` 0.00060606002807617
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00029110908508301
(286) DESCRIBE `sailingdates` 0.0011279582977295
(287) DESCRIBE `ports` 0.001338005065918
(288) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00031805038452148
(289) DESCRIBE `ports` 0.0012898445129395
(290) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00027894973754883
(291) DESCRIBE `ports` 0.0012760162353516
(292) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 368))) 0.00030303001403809
(293) DESCRIBE `ports` 0.0012848377227783
(294) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '368') 0.00028705596923828
(295) DESCRIBE `ports` 0.0015108585357666
(296) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 208))) 0.00033092498779297
(297) DESCRIBE `ports` 0.0013411045074463
(298) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '208') 0.00028085708618164
(299) DESCRIBE `ports` 0.0015361309051514
(300) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 277))) 0.00030803680419922
(301) DESCRIBE `ports` 0.0013620853424072
(302) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '277') 0.00037908554077148
(303) DESCRIBE `ports` 0.0013091564178467
(304) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 587))) 0.00031590461730957
(305) DESCRIBE `ports` 0.0013148784637451
(306) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '587') 0.00029802322387695
(307) DESCRIBE `ports` 0.0013489723205566
(308) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00033402442932129
(309) DESCRIBE `ports` 0.0014920234680176
(310) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00035595893859863
(311) DESCRIBE `ports` 0.0015709400177002
(312) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 215))) 0.00040006637573242
(313) DESCRIBE `ports` 0.0012731552124023
(314) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '215') 0.00031089782714844
(315) DESCRIBE `ports` 0.0012807846069336
(316) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00032591819763184
(317) DESCRIBE `ports` 0.0014698505401611
(318) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.0003659725189209
(319) DESCRIBE `avid_specials` 0.0012869834899902
(320) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 71457 and class = 'Cruise') OR (item_id = 407 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0011961460113525
(321) DESCRIBE `cruiselines` 0.0021729469299316
(322) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00042080879211426
(323) DESCRIBE `orchid_image` 0.0016839504241943
(324) DESCRIBE `cruiselines` 0.0021960735321045
(325) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00035500526428223
(326) DESCRIBE `cruises` 0.002561092376709
(327) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65603') 0.00034499168395996
(328) DESCRIBE `ships` 0.0028469562530518
(329) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1415))) 0.00051307678222656
(330) DESCRIBE `ships` 0.0037009716033936
(331) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1415') 0.00041389465332031
(332) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00026893615722656
(333) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '1') 0.00025415420532227
(334) DESCRIBE `itineraries` 0.0014891624450684
(335) DESCRIBE `ports` 0.0014121532440186
(336) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00034403800964355
(337) DESCRIBE `ports` 0.0012748241424561
(338) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00046396255493164
(339) DESCRIBE `ports` 0.0015289783477783
(340) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00041103363037109
(341) DESCRIBE `sailingdates` 0.0014591217041016
(342) DESCRIBE `ports` 0.0013248920440674
(343) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00035786628723145
(344) DESCRIBE `ports` 0.0014128684997559
(345) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00032711029052734
(346) DESCRIBE `ports` 0.0012748241424561
(347) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 414))) 0.00032806396484375
(348) DESCRIBE `ports` 0.0012969970703125
(349) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '414') 0.00032186508178711
(350) DESCRIBE `ports` 0.001366138458252
(351) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00032305717468262
(352) DESCRIBE `ports` 0.0012969970703125
(353) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00031495094299316
(354) DESCRIBE `ports` 0.0012989044189453
(355) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00036096572875977
(356) DESCRIBE `ports` 0.0013549327850342
(357) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00029087066650391
(358) DESCRIBE `ports` 0.0012738704681396
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00032806396484375
(360) DESCRIBE `ports` 0.0013501644134521
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00031781196594238
(362) DESCRIBE `ports` 0.0012969970703125
(363) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00032687187194824
(364) DESCRIBE `ports` 0.0013940334320068
(365) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00031113624572754
(366) DESCRIBE `ports` 0.0012609958648682
(367) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 351))) 0.00031781196594238
(368) DESCRIBE `ports` 0.0016419887542725
(369) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '351') 0.00029087066650391
(370) DESCRIBE `ports` 0.0012710094451904
(371) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 51))) 0.00032305717468262
(372) DESCRIBE `ports` 0.0012660026550293
(373) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '51') 0.00032711029052734
(374) DESCRIBE `ports` 0.0015189647674561
(375) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 466))) 0.00032186508178711
(376) DESCRIBE `ports` 0.0012779235839844
(377) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '466') 0.00028395652770996
(378) DESCRIBE `ports` 0.0015349388122559
(379) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 131))) 0.00033092498779297
(380) DESCRIBE `ports` 0.0014009475708008
(381) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '131') 0.00045084953308105
(382) DESCRIBE `avid_specials` 0.0014660358428955
(383) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65603 and class = 'Cruise') OR (item_id = 1415 AND class = 'Ship') OR (item_id = 19 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.0016570091247559
(384) DESCRIBE `cruiselines` 0.0020310878753662
(385) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00037121772766113
(386) DESCRIBE `orchid_image` 0.0015721321105957
(387) DESCRIBE `cruiselines` 0.0022499561309814
(388) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00036001205444336
(389) DESCRIBE `cruises` 0.0028200149536133
(390) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67956') 0.00036096572875977
(391) DESCRIBE `ships` 0.0025730133056641
(392) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 452))) 0.00041794776916504
(393) DESCRIBE `ships` 0.0028519630432129
(394) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '452') 0.00038695335388184
(395) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027108192443848
(396) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029993057250977
(397) DESCRIBE `itineraries` 0.0016660690307617
(398) DESCRIBE `ports` 0.00090408325195312
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00037002563476562
(400) DESCRIBE `ports` 0.0013058185577393
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00032591819763184
(402) DESCRIBE `ports` 0.0013010501861572
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00029206275939941
(404) DESCRIBE `sailingdates` 0.0011148452758789
(405) DESCRIBE `ports` 0.0013790130615234
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00034093856811523
(407) DESCRIBE `ports` 0.0013339519500732
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00031590461730957
(409) DESCRIBE `ports` 0.0018219947814941
(410) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00040602684020996
(411) DESCRIBE `ports` 0.0016999244689941
(412) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00036001205444336
(413) DESCRIBE `ports` 0.0019471645355225
(414) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00051307678222656
(415) DESCRIBE `ports` 0.0013651847839355
(416) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0
(417) DESCRIBE `ports` 0.001370906829834
(418) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00034618377685547
(419) DESCRIBE `ports` 0.0013308525085449
(420) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00030183792114258
(421) DESCRIBE `ports` 0.0016739368438721
(422) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00035881996154785
(423) DESCRIBE `ports` 0.0015561580657959
(424) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00039005279541016
(425) DESCRIBE `ports` 0.0026619434356689
(426) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00050497055053711
(427) DESCRIBE `ports` 0.0019059181213379
(428) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00043988227844238
(429) DESCRIBE `ports` 0.0018379688262939
(430) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00043892860412598
(431) DESCRIBE `ports` 0.0015838146209717
(432) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00032591819763184
(433) DESCRIBE `ports` 0.001356840133667
(434) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00032901763916016
(435) DESCRIBE `ports` 0.0013480186462402
(436) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00027608871459961
(437) DESCRIBE `ports` 0.0017871856689453
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00043296813964844
(439) DESCRIBE `ports` 0.0017092227935791
(440) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00035214424133301
(441) DESCRIBE `ports` 0.0018110275268555
(442) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 344))) 0.00038814544677734
(443) DESCRIBE `ports` 0.0017850399017334
(444) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '344') 0.0003819465637207
(445) DESCRIBE `ports` 0.0017900466918945
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 464))) 0.00046801567077637
(447) DESCRIBE `ports` 0.0016388893127441
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '464') 0.00033307075500488
(449) DESCRIBE `ports` 0.0014829635620117
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00031805038452148
(451) DESCRIBE `ports` 0.0018191337585449
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00035691261291504
(453) DESCRIBE `ports` 0.0015051364898682
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00036907196044922
(455) DESCRIBE `ports` 0.0015630722045898
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00037598609924316
(457) DESCRIBE `avid_specials` 0.0013771057128906
(458) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67956 and class = 'Cruise') OR (item_id = 452 AND class = 'Ship') OR (item_id = 19 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.0014340877532959
(459) DESCRIBE `cruiselines` 0.0021700859069824
(460) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00054216384887695
(461) DESCRIBE `orchid_image` 0.0021390914916992
(462) DESCRIBE `cruiselines` 0.0026149749755859
(463) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00047397613525391
(464) DESCRIBE `cruises` 0.0036251544952393
(465) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '50721') 0.00049901008605957
(466) DESCRIBE `ships` 0.0037069320678711
(467) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 674))) 0.00055599212646484
(468) DESCRIBE `ships` 0.0035779476165771
(469) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '674') 0.00042295455932617
(470) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00034904479980469
(471) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033807754516602
(472) DESCRIBE `itineraries` 0.0018441677093506
(473) DESCRIBE `ports` 0.0018439292907715
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0004730224609375
(475) DESCRIBE `ports` 0.0017249584197998
(476) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00040578842163086
(477) DESCRIBE `ports` 0.0017049312591553
(478) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.0003960132598877
(479) DESCRIBE `sailingdates` 0.0015659332275391
(480) DESCRIBE `ports` 0.0018470287322998
(481) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00052285194396973
(482) DESCRIBE `ports` 0.0015819072723389
(483) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00029420852661133
(484) DESCRIBE `ports` 0.0015711784362793
(485) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 764))) 0.00037598609924316
(486) DESCRIBE `ports` 0.001410961151123
(487) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '764') 0.00031399726867676
(488) DESCRIBE `ports` 0.0016119480133057
(489) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00038599967956543
(490) DESCRIBE `ports` 0.0017430782318115
(491) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00038290023803711
(492) DESCRIBE `ports` 0.0013630390167236
(493) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00031185150146484
(494) DESCRIBE `ports` 0.0013389587402344
(495) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00027894973754883
(496) DESCRIBE `ports` 0.0013859272003174
(497) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.0003960132598877
(498) DESCRIBE `ports` 0.0017650127410889
(499) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00040698051452637
(500) DESCRIBE `ports` 0.0015878677368164
(501) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.00032186508178711
(502) DESCRIBE `ports` 0.0013790130615234
(503) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.00029206275939941
(504) DESCRIBE `ports` 0.0012650489807129
(505) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.0003209114074707
(506) DESCRIBE `ports` 0.0013320446014404
(507) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00035405158996582
(508) DESCRIBE `ports` 0.0018501281738281
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00047206878662109
(510) DESCRIBE `ports` 0.0012991428375244
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00048589706420898
(512) DESCRIBE `avid_specials` 0.0012578964233398
(513) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 50721 and class = 'Cruise') OR (item_id = 674 AND class = 'Ship') OR (item_id = 19 AND class = 'CruiseLine') OR (item_id = 22 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0019469261169434
(514) DESCRIBE `cruiselines` 0.0032219886779785
(515) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.0005040168762207
(516) DESCRIBE `orchid_image` 0.0019099712371826
(517) DESCRIBE `cruiselines` 0.0019559860229492
(518) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00041699409484863
(519) DESCRIBE `cruises` 0.0024471282958984
(520) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59379') 0.00030112266540527
(521) DESCRIBE `ships` 0.0025668144226074
(522) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 452))) 0.00039815902709961
(523) DESCRIBE `ships` 0.0024781227111816
(524) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '452') 0
(525) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.0003201961517334
(526) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00033402442932129
(527) DESCRIBE `itineraries` 0.0017321109771729
(528) DESCRIBE `ports` 0.0017879009246826
(529) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00038981437683105
(530) DESCRIBE `ports` 0.0012428760528564
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00028419494628906
(532) DESCRIBE `ports` 0.001288890838623
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00026202201843262
(534) DESCRIBE `sailingdates` 0.001295804977417
(535) DESCRIBE `ports` 0.0013058185577393
(536) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00029206275939941
(537) DESCRIBE `ports` 0.0012850761413574
(538) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00031495094299316
(539) DESCRIBE `ports` 0.0012791156768799
(540) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.0003058910369873
(541) DESCRIBE `ports` 0.0012600421905518
(542) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00025606155395508
(543) DESCRIBE `ports` 0.0012450218200684
(544) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2283))) 0.00029516220092773
(545) DESCRIBE `ports` 0.001366138458252
(546) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2283') 0.00026893615722656
(547) DESCRIBE `ports` 0.0012450218200684
(548) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2300))) 0.00029706954956055
(549) DESCRIBE `ports` 0.0013208389282227
(550) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2300') 0.00027799606323242
(551) DESCRIBE `ports` 0.0012359619140625
(552) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1344))) 0.00030994415283203
(553) DESCRIBE `ports` 0.0013301372528076
(554) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1344') 0.00027894973754883
(555) DESCRIBE `ports` 0.0012969970703125
(556) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 367))) 0.00032401084899902
(557) DESCRIBE `ports` 0.0012969970703125
(558) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '367') 0.00026702880859375
(559) DESCRIBE `ports` 0.0012791156768799
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 666))) 0.00033903121948242
(561) DESCRIBE `ports` 0.0014040470123291
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '666') 0.00026416778564453
(563) DESCRIBE `avid_specials` 0.0011448860168457
(564) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59379 and class = 'Cruise') OR (item_id = 452 AND class = 'Ship') OR (item_id = 19 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.0010430812835693
(565) DESCRIBE `cruiselines` 0.0030550956726074
(566) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00054192543029785
(567) DESCRIBE `orchid_image` 0.0020430088043213
(568) DESCRIBE `cruiselines` 0.0032439231872559
(569) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '19') 0.00044584274291992
(570) DESCRIBE `ships` 0.0033349990844727
(571) SELECT `ships`.* FROM `ships` WHERE (id IN ('1359', '977', '1599', '1588', '1067', '407', '726', '1415', '462', '766', '452', '674', '553', '1717', '352', '610', '738')) ORDER BY FIND_IN_SET(id, '1359,977,1599,1588,1067,407,726,1415,462,766,452,674,553,1717,352,610,738') 0.0018811225891113
(572) DESCRIBE `cruisetypes` 0.0014588832855225
(573) DESCRIBE `destinations` 0.0026819705963135
(574) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('22', '12', '45', '26', '25', '28', '37', '38', '52', '40', '49', '11', '21', '35')) ORDER BY FIND_IN_SET(id, '22,12,45,26,25,28,37,38,52,40,49,11,21,35') 0.0015120506286621
(575) DESCRIBE `cruiselines` 0.0021989345550537
(576) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00038003921508789
(577) DESCRIBE `cruiselines` 0.0021641254425049
(578) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 19))) 0.00039219856262207