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

Total elapsed time: 0.68167209625244

# Query Time
(1) connect 0.00072193145751953
(2) DESCRIBE `cruises` 0.0030169486999512
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (65724, 67150, 67614, 70872, 70887, 15922, 27131, 40897, 53605, 55806)) ORDER BY FIND_IN_SET(id, '65724,67150,67614,70872,70887,15922,27131,40897,53605,55806') 0.0014519691467285
(4) DESCRIBE `cruises` 0.0038461685180664
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65724') 0.00042605400085449
(6) DESCRIBE `ships` 0.0036070346832275
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1071))) 0.00037312507629395
(8) DESCRIBE `ships` 0.0026390552520752
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1071') 0.00028395652770996
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002589225769043
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00024914741516113
(12) DESCRIBE `itineraries` 0.0013899803161621
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65724') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00068283081054688
(14) DESCRIBE `ports` 0.0013980865478516
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00031518936157227
(16) DESCRIBE `ports` 0.0014941692352295
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.0003049373626709
(18) DESCRIBE `ports` 0.0012938976287842
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00028800964355469
(20) DESCRIBE `sailingdates` 0.0012240409851074
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65724') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00069594383239746
(22) DESCRIBE `ports` 0.0019831657409668
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00036811828613281
(24) DESCRIBE `ports` 0.0012760162353516
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00031018257141113
(26) DESCRIBE `ports` 0.0014290809631348
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1045))) 0.00029397010803223
(28) DESCRIBE `ports` 0.0012729167938232
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1045') 0.00047898292541504
(30) DESCRIBE `ports` 0.0016679763793945
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2949))) 0.00035405158996582
(32) DESCRIBE `ports` 0.0017130374908447
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2949') 0.00033187866210938
(34) DESCRIBE `ports` 0.0018799304962158
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4135))) 0.00034713745117188
(36) DESCRIBE `ports` 0.0013930797576904
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4135') 0.00032496452331543
(38) DESCRIBE `ports` 0.0019769668579102
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2775))) 0.00039386749267578
(40) DESCRIBE `ports` 0.0013329982757568
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2775') 0.00035905838012695
(42) DESCRIBE `ports` 0.0015990734100342
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3671))) 0.00032687187194824
(44) DESCRIBE `ports` 0.0014441013336182
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3671') 0.00013303756713867
(46) DESCRIBE `ports` 0.0012340545654297
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2776))) 0.00027990341186523
(48) DESCRIBE `ports` 0.0013008117675781
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2776') 0.00030803680419922
(50) DESCRIBE `ports` 0.0015990734100342
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.0004580020904541
(52) DESCRIBE `ports` 0.0012891292572021
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00029516220092773
(54) DESCRIBE `ports` 0.001317024230957
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2777))) 0.00031185150146484
(56) DESCRIBE `ports` 0.0013909339904785
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2777') 0.00030803680419922
(58) DESCRIBE `ports` 0.0016100406646729
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5068))) 0.00039196014404297
(60) DESCRIBE `ports` 0.0014541149139404
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5068') 0.00028300285339355
(62) DESCRIBE `ports` 0.0013689994812012
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4095))) 0.00036501884460449
(64) DESCRIBE `ports` 0.0016860961914062
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4095') 0.00035810470581055
(66) DESCRIBE `ports` 0.0019910335540771
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00033783912658691
(68) DESCRIBE `ports` 0.0014259815216064
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00031113624572754
(70) DESCRIBE `ports` 0.0017290115356445
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2779))) 0.00038695335388184
(72) DESCRIBE `ports` 0.0018699169158936
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2779') 0.00037002563476562
(74) DESCRIBE `ports` 0.0018570423126221
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2780))) 0.00029993057250977
(76) DESCRIBE `ports` 0.00152587890625
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2780') 0.0002739429473877
(78) DESCRIBE `avid_specials` 0.0011239051818848
(79) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65724 and class = 'Cruise') OR (item_id = 1071 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 54 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.0010850429534912
(80) DESCRIBE `cruiselines` 0.001990795135498
(81) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00034499168395996
(82) DESCRIBE `orchid_image` 0.0014209747314453
(83) DESCRIBE `cruiselines` 0.001856803894043
(84) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00037097930908203
(85) DESCRIBE `cruises` 0.0026328563690186
(86) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67150') 0.00034999847412109
(87) DESCRIBE `ships` 0.0026209354400635
(88) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 765))) 0.00036811828613281
(89) DESCRIBE `ships` 0.0024588108062744
(90) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '765') 0.00027894973754883
(91) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026488304138184
(92) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '3') 0.00026297569274902
(93) DESCRIBE `itineraries` 0.0013000965118408
(94) DESCRIBE `ports` 0.0012531280517578
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0003509521484375
(96) DESCRIBE `ports` 0.0015430450439453
(97) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00032806396484375
(98) DESCRIBE `ports` 0.0013158321380615
(99) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00029706954956055
(100) DESCRIBE `sailingdates` 0.0010979175567627
(101) DESCRIBE `ports` 0.0012781620025635
(102) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.0002901554107666
(103) DESCRIBE `ports` 0.0012941360473633
(104) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00027298927307129
(105) DESCRIBE `ports` 0.0013251304626465
(106) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 87))) 0.00029993057250977
(107) DESCRIBE `ports` 0.001255989074707
(108) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '87') 0.00029778480529785
(109) DESCRIBE `ports` 0.001276969909668
(110) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3503))) 0.00028896331787109
(111) DESCRIBE `ports` 0.0013611316680908
(112) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3503') 0.00029182434082031
(113) DESCRIBE `ports` 0.001244068145752
(114) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1758))) 0.00030303001403809
(115) DESCRIBE `ports` 0.00136399269104
(116) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1758') 0.00028204917907715
(117) DESCRIBE `ports` 0.0012409687042236
(118) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 447))) 0.00028777122497559
(119) DESCRIBE `ports` 0.0013151168823242
(120) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '447') 0.00028204917907715
(121) DESCRIBE `avid_specials` 0.0014410018920898
(122) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67150 and class = 'Cruise') OR (item_id = 765 AND class = 'Ship') OR (item_id = 37 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.0011718273162842
(123) DESCRIBE `cruiselines` 0.0018360614776611
(124) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 37))) 0.00036907196044922
(125) DESCRIBE `orchid_image` 0.0015130043029785
(126) DESCRIBE `cruiselines` 0.0018389225006104
(127) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '37') 0.00038313865661621
(128) DESCRIBE `cruises` 0.0029239654541016
(129) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67614') 0.00031495094299316
(130) DESCRIBE `ships` 0.002565860748291
(131) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1581))) 0.00036215782165527
(132) DESCRIBE `ships` 0.0024440288543701
(133) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1581') 0.00027918815612793
(134) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027012825012207
(135) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025796890258789
(136) DESCRIBE `itineraries` 0.0013148784637451
(137) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67614') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00090217590332031
(138) DESCRIBE `ports` 0.0013060569763184
(139) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4214))) 0.00030899047851562
(140) DESCRIBE `ports` 0.0014171600341797
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4214))) 0.00037622451782227
(142) DESCRIBE `ports` 0.0013880729675293
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4214') 0.00034904479980469
(144) DESCRIBE `sailingdates` 0.0011069774627686
(145) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67614') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00076794624328613
(146) DESCRIBE `ports` 0.0015420913696289
(147) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4214))) 0.0003349781036377
(148) DESCRIBE `ports` 0.00160813331604
(149) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4214') 0.00033712387084961
(150) DESCRIBE `ports` 0.0014550685882568
(151) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4214))) 0.00037097930908203
(152) DESCRIBE `ports` 0.0014219284057617
(153) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4214') 0.00028800964355469
(154) DESCRIBE `ports` 0.0013360977172852
(155) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5646))) 0.0003058910369873
(156) DESCRIBE `ports` 0.0015840530395508
(157) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5646') 0.00032901763916016
(158) DESCRIBE `ports` 0.0013689994812012
(159) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00030398368835449
(160) DESCRIBE `ports` 0.0009310245513916
(161) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00041007995605469
(162) DESCRIBE `ports` 0.0017149448394775
(163) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3489))) 0.00029087066650391
(164) DESCRIBE `ports` 0.0014798641204834
(165) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3489') 0.00081610679626465
(166) DESCRIBE `ports` 0.0011329650878906
(167) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5647))) 0.00033378601074219
(168) DESCRIBE `ports` 0.0016891956329346
(169) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5647') 0.00027799606323242
(170) DESCRIBE `ports` 0.0013101100921631
(171) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5647))) 0.00029802322387695
(172) DESCRIBE `ports` 0.0013329982757568
(173) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5647') 0.00029802322387695
(174) DESCRIBE `ports` 0.0012810230255127
(175) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5648))) 0.00028586387634277
(176) DESCRIBE `ports` 0.0013389587402344
(177) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5648') 0.00029397010803223
(178) DESCRIBE `ports` 0.0012581348419189
(179) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5649))) 0.00029611587524414
(180) DESCRIBE `ports` 0.0014538764953613
(181) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5649') 0.0002739429473877
(182) DESCRIBE `ports` 0.0012600421905518
(183) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5649))) 0.00028705596923828
(184) DESCRIBE `ports` 0.0013890266418457
(185) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5649') 0.00027990341186523
(186) DESCRIBE `avid_specials` 0.0011351108551025
(187) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67614 and class = 'Cruise') OR (item_id = 1581 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 52 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.0010418891906738
(188) DESCRIBE `cruiselines` 0.0019998550415039
(189) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00034499168395996
(190) DESCRIBE `orchid_image` 0.0014121532440186
(191) DESCRIBE `cruiselines` 0.0018050670623779
(192) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00028800964355469
(193) DESCRIBE `cruises` 0.0024559497833252
(194) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70872') 0.0003058910369873
(195) DESCRIBE `ships` 0.0027189254760742
(196) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1581))) 0.00035405158996582
(197) DESCRIBE `ships` 0.0024850368499756
(198) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1581') 0.00032997131347656
(199) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002901554107666
(200) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002589225769043
(201) DESCRIBE `itineraries` 0.0012359619140625
(202) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70872') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00061511993408203
(203) DESCRIBE `ports` 0.0013771057128906
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4214))) 0.00041079521179199
(205) DESCRIBE `ports` 0.0012810230255127
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4214))) 0.00030303001403809
(207) DESCRIBE `ports` 0.00136399269104
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4214') 0.00027894973754883
(209) DESCRIBE `sailingdates` 0.0011019706726074
(210) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70872') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00063610076904297
(211) DESCRIBE `ports` 0.0013720989227295
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4214))) 0.00029492378234863
(213) DESCRIBE `ports` 0.0012960433959961
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4214') 0.0002892017364502
(215) DESCRIBE `ports` 0.001288890838623
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4214))) 0.00028204917907715
(217) DESCRIBE `ports` 0.0012860298156738
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4214') 0.00027203559875488
(219) DESCRIBE `ports` 0.001255989074707
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5646))) 0.00029397010803223
(221) DESCRIBE `ports` 0.0012669563293457
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5646') 0.00027203559875488
(223) DESCRIBE `ports` 0.0012519359588623
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5648))) 0.00031805038452148
(225) DESCRIBE `ports` 0.0012650489807129
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5648') 0.00026988983154297
(227) DESCRIBE `ports` 0.0012950897216797
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5648))) 0.00033402442932129
(229) DESCRIBE `ports` 0.0013279914855957
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5648') 0.00026893615722656
(231) DESCRIBE `ports` 0.0013289451599121
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5647))) 0.0003349781036377
(233) DESCRIBE `ports` 0.0012941360473633
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5647') 0.00038695335388184
(235) DESCRIBE `ports` 0.0012869834899902
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5647))) 0.00028204917907715
(237) DESCRIBE `ports` 0.0013461112976074
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5647') 0.00029301643371582
(239) DESCRIBE `ports` 0.0013248920440674
(240) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5647))) 0.00031590461730957
(241) DESCRIBE `ports` 0.0013530254364014
(242) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5647') 0.00029397010803223
(243) DESCRIBE `ports` 0.0012660026550293
(244) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5647))) 0.00031208992004395
(245) DESCRIBE `ports` 0.0013430118560791
(246) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5647') 0.00026893615722656
(247) DESCRIBE `ports` 0.0012738704681396
(248) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5649))) 0.00028395652770996
(249) DESCRIBE `ports` 0.0012509822845459
(250) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5649') 0.00026798248291016
(251) DESCRIBE `ports` 0.0013191699981689
(252) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5649))) 0.00029397010803223
(253) DESCRIBE `ports` 0.0015408992767334
(254) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5649') 0.00032711029052734
(255) DESCRIBE `avid_specials` 0.001115083694458
(256) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70872 and class = 'Cruise') OR (item_id = 1581 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 52 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.0010628700256348
(257) DESCRIBE `cruiselines` 0.0018379688262939
(258) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00032591819763184
(259) DESCRIBE `orchid_image` 0.0015208721160889
(260) DESCRIBE `cruiselines` 0.0021219253540039
(261) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00032496452331543
(262) DESCRIBE `cruises` 0.0024900436401367
(263) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '70887') 0.00042986869812012
(264) DESCRIBE `ships` 0.002877950668335
(265) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1036))) 0.00036406517028809
(266) DESCRIBE `ships` 0.003093957901001
(267) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1036') 0.00030303001403809
(268) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00057697296142578
(269) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035285949707031
(270) DESCRIBE `itineraries` 0.0018439292907715
(271) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '70887') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00070905685424805
(272) DESCRIBE `ports` 0.001816987991333
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00047588348388672
(274) DESCRIBE `ports` 0.0014331340789795
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00029110908508301
(276) DESCRIBE `ports` 0.0012989044189453
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.0002739429473877
(278) DESCRIBE `sailingdates` 0.0010981559753418
(279) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '70887') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00068497657775879
(280) DESCRIBE `ports` 0.001431941986084
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00033879280090332
(282) DESCRIBE `ports` 0.0012390613555908
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00026798248291016
(284) DESCRIBE `ports` 0.0013079643249512
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00031399726867676
(286) DESCRIBE `ports` 0.0012531280517578
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00026202201843262
(288) DESCRIBE `ports` 0.00124192237854
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2004))) 0.00031781196594238
(290) DESCRIBE `ports` 0.0013000965118408
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2004') 0.00028681755065918
(292) DESCRIBE `ports` 0.001230001449585
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.00027894973754883
(294) DESCRIBE `ports` 0.0012800693511963
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00026082992553711
(296) DESCRIBE `ports` 0.0012431144714355
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1599))) 0.00029587745666504
(298) DESCRIBE `ports` 0.0012369155883789
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1599') 0.00026607513427734
(300) DESCRIBE `ports` 0.0012369155883789
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00034594535827637
(302) DESCRIBE `ports` 0.0012438297271729
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00026607513427734
(304) DESCRIBE `ports` 0.0014219284057617
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00030398368835449
(306) DESCRIBE `ports` 0.0012528896331787
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00028395652770996
(308) DESCRIBE `ports` 0.0012788772583008
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1593))) 0.00028610229492188
(310) DESCRIBE `ports` 0.0013411045074463
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1593') 0.00026607513427734
(312) DESCRIBE `ports` 0.0012388229370117
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 993))) 0.00029802322387695
(314) DESCRIBE `ports` 0.0014691352844238
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '993') 0.00026893615722656
(316) DESCRIBE `ports` 0.0012431144714355
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00029706954956055
(318) DESCRIBE `ports` 0.0015349388122559
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00026917457580566
(320) DESCRIBE `ports` 0.0013108253479004
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00029802322387695
(322) DESCRIBE `ports` 0.0014770030975342
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00026893615722656
(324) DESCRIBE `ports` 0.0013020038604736
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00028300285339355
(326) DESCRIBE `ports` 0.0012428760528564
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00026893615722656
(328) DESCRIBE `avid_specials` 0.0011510848999023
(329) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 70887 and class = 'Cruise') OR (item_id = 1036 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.0012369155883789
(330) DESCRIBE `cruiselines` 0.0020120143890381
(331) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 0.00035715103149414
(332) DESCRIBE `orchid_image` 0.0014350414276123
(333) DESCRIBE `cruiselines` 0.0018839836120605
(334) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00031900405883789
(335) DESCRIBE `cruises` 0.0025339126586914
(336) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '15922') 0.00030779838562012
(337) DESCRIBE `ships` 0.0026700496673584
(338) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 291))) 0.00036120414733887
(339) DESCRIBE `ships` 0.0026319026947021
(340) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '291') 0.00029611587524414
(341) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00027298927307129
(342) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025105476379395
(343) DESCRIBE `itineraries` 0.0014970302581787
(344) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '15922') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00076198577880859
(345) DESCRIBE `ports` 0.0016341209411621
(346) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00035786628723145
(347) DESCRIBE `ports` 0.0012531280517578
(348) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00029993057250977
(349) DESCRIBE `ports` 0.0013790130615234
(350) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00029397010803223
(351) DESCRIBE `sailingdates` 0.0011169910430908
(352) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '15922') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00095605850219727
(353) DESCRIBE `ports` 0.002126932144165
(354) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00046682357788086
(355) DESCRIBE `ports` 0.0014359951019287
(356) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00030088424682617
(357) DESCRIBE `ports` 0.0012950897216797
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.00034093856811523
(359) DESCRIBE `ports` 0.001276969909668
(360) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00029110908508301
(361) DESCRIBE `ports` 0.0012719631195068
(362) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.0003201961517334
(363) DESCRIBE `ports` 0.0018608570098877
(364) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.00036716461181641
(365) DESCRIBE `ports` 0.0018429756164551
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00038909912109375
(367) DESCRIBE `ports` 0.0017731189727783
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00036501884460449
(369) DESCRIBE `ports` 0.0011088848114014
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.0004270076751709
(371) DESCRIBE `ports` 0.0013728141784668
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00029087066650391
(373) DESCRIBE `ports` 0.0013489723205566
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 292))) 0.00030398368835449
(375) DESCRIBE `ports` 0.0013089179992676
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '292') 0.00027894973754883
(377) DESCRIBE `ports` 0.0012829303741455
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00036001205444336
(379) DESCRIBE `ports` 0.0015740394592285
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.00027704238891602
(381) DESCRIBE `avid_specials` 0.00111985206604
(382) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 15922 and class = 'Cruise') OR (item_id = 291 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 2 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.0012331008911133
(383) DESCRIBE `cruiselines` 0.0018529891967773
(384) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00035786628723145
(385) DESCRIBE `orchid_image` 0.0013909339904785
(386) DESCRIBE `cruiselines` 0.002061128616333
(387) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00016689300537109
(388) DESCRIBE `cruises` 0.0035691261291504
(389) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '27131') 0.00042581558227539
(390) DESCRIBE `ships` 0.0037150382995605
(391) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 348))) 0.00039792060852051
(392) DESCRIBE `ships` 0.0026748180389404
(393) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '348') 0.00029206275939941
(394) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00020003318786621
(395) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00025582313537598
(396) DESCRIBE `itineraries` 0.0012779235839844
(397) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '27131') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00063490867614746
(398) DESCRIBE `ports` 0.0012929439544678
(399) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.0003199577331543
(400) DESCRIBE `ports` 0.0013279914855957
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00031304359436035
(402) DESCRIBE `ports` 0.0013489723205566
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.00028514862060547
(404) DESCRIBE `sailingdates` 0.0012161731719971
(405) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '27131') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00065898895263672
(406) DESCRIBE `ports` 0.0013852119445801
(407) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2022))) 0.00033092498779297
(408) DESCRIBE `ports` 0.0013530254364014
(409) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2022') 0.0002751350402832
(410) DESCRIBE `ports` 0.0013949871063232
(411) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 295))) 0.00035309791564941
(412) DESCRIBE `ports` 0.0015289783477783
(413) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '295') 0.00035309791564941
(414) DESCRIBE `ports` 0.0018320083618164
(415) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 36))) 0.00040721893310547
(416) DESCRIBE `ports` 0.0018348693847656
(417) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '36') 0.00038313865661621
(418) DESCRIBE `ports` 0.0018439292907715
(419) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 32))) 0.00039505958557129
(420) DESCRIBE `ports` 0.0017769336700439
(421) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '32') 0.00037407875061035
(422) DESCRIBE `ports` 0.0018320083618164
(423) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 28))) 0.00045514106750488
(424) DESCRIBE `ports` 0.001777172088623
(425) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '28') 0.0003669261932373
(426) DESCRIBE `ports` 0.0017690658569336
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 35))) 0.0003969669342041
(428) DESCRIBE `ports` 0.0018408298492432
(429) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '35') 0.00037193298339844
(430) DESCRIBE `ports` 0.0019969940185547
(431) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 111))) 0.00042200088500977
(432) DESCRIBE `ports` 0.0019650459289551
(433) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '111') 0.00038599967956543
(434) DESCRIBE `avid_specials` 0.0016391277313232
(435) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 27131 and class = 'Cruise') OR (item_id = 348 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 2 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.0011348724365234
(436) DESCRIBE `cruiselines` 0.0019090175628662
(437) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00034689903259277
(438) DESCRIBE `orchid_image` 0.0015280246734619
(439) DESCRIBE `cruiselines` 0.0019710063934326
(440) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00029897689819336
(441) DESCRIBE `cruises` 0.002748966217041
(442) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '40897') 0.00043797492980957
(443) DESCRIBE `ships` 0.0026891231536865
(444) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1049))) 0.00040102005004883
(445) DESCRIBE `ships` 0.0026559829711914
(446) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1049') 0.00030207633972168
(447) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00054693222045898
(448) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028610229492188
(449) DESCRIBE `itineraries` 0.0013511180877686
(450) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '40897') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0006718635559082
(451) DESCRIBE `ports` 0.0013430118560791
(452) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00033187866210938
(453) DESCRIBE `ports` 0.00096607208251953
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00032186508178711
(455) DESCRIBE `ports` 0.0013570785522461
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00022602081298828
(457) DESCRIBE `sailingdates` 0.0011370182037354
(458) DESCRIBE `ports` 0.0019471645355225
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00040411949157715
(460) DESCRIBE `ports` 0.001378059387207
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00073099136352539
(462) DESCRIBE `ports` 0.001101016998291
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1548))) 0.00031208992004395
(464) DESCRIBE `ports` 0.0014691352844238
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1548') 0.00037193298339844
(466) DESCRIBE `ports` 0.0013430118560791
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1550))) 0.00030088424682617
(468) DESCRIBE `ports` 0.0010318756103516
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1550') 0.00035500526428223
(470) DESCRIBE `ports` 0.0014231204986572
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1550))) 0.00039291381835938
(472) DESCRIBE `ports` 0.0016119480133057
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1550') 0.00037407875061035
(474) DESCRIBE `ports` 0.0018150806427002
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00040507316589355
(476) DESCRIBE `ports` 0.001453161239624
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00035405158996582
(478) DESCRIBE `ports` 0.0014948844909668
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.00037693977355957
(480) DESCRIBE `ports` 0.0018990039825439
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1552') 0.00039100646972656
(482) DESCRIBE `ports` 0.0012929439544678
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1551))) 0.00030708312988281
(484) DESCRIBE `ports` 0.0013570785522461
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1551') 0.00028514862060547
(486) DESCRIBE `ports` 0.0009150505065918
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00031208992004395
(488) DESCRIBE `ports` 0.0014791488647461
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00027894973754883
(490) DESCRIBE `avid_specials` 0.0011799335479736
(491) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 40897 and class = 'Cruise') OR (item_id = 1049 AND class = 'Ship') OR (item_id = 144 AND class = 'CruiseLine') OR (item_id = 50 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.0011279582977295
(492) DESCRIBE `cruiselines` 0.0021641254425049
(493) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 144))) 6.4849853515625E-5
(494) DESCRIBE `orchid_image` 0.0015139579772949
(495) DESCRIBE `cruiselines` 0.0023000240325928
(496) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '144') 0.00037097930908203
(497) DESCRIBE `cruises` 0.0027890205383301
(498) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '53605') 0.00046920776367188
(499) DESCRIBE `ships` 0.0038530826568604
(500) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 770))) 0.0005791187286377
(501) DESCRIBE `ships` 0.0033438205718994
(502) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '770') 0.00040411949157715
(503) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00028419494628906
(504) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00029277801513672
(505) DESCRIBE `itineraries` 0.0014081001281738
(506) DESCRIBE `ports` 0.0018441677093506
(507) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00039911270141602
(508) DESCRIBE `ports` 0.0014300346374512
(509) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00031805038452148
(510) DESCRIBE `ports` 0.001533031463623
(511) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00032401084899902
(512) DESCRIBE `sailingdates` 0.0011389255523682
(513) DESCRIBE `ports` 0.0018689632415771
(514) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00036287307739258
(515) DESCRIBE `ports` 0.0014340877532959
(516) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00030803680419922
(517) DESCRIBE `ports` 0.0014340877532959
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00031900405883789
(519) DESCRIBE `ports` 0.001291036605835
(520) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00030708312988281
(521) DESCRIBE `ports` 0.0014748573303223
(522) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 387))) 0.00030016899108887
(523) DESCRIBE `ports` 0.0024409294128418
(524) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '387') 0.00032305717468262
(525) DESCRIBE `ports` 0.0013730525970459
(526) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 692))) 0.00039815902709961
(527) DESCRIBE `ports` 0.0012979507446289
(528) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '692') 0.00028800964355469
(529) DESCRIBE `ports` 0.0014188289642334
(530) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00030899047851562
(531) DESCRIBE `ports` 0.0013270378112793
(532) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00033712387084961
(533) DESCRIBE `ports` 0.0017359256744385
(534) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00039196014404297
(535) DESCRIBE `ports` 0.0018069744110107
(536) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00037312507629395
(537) DESCRIBE `ports` 0.0019071102142334
(538) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00040197372436523
(539) DESCRIBE `ports` 0.0012979507446289
(540) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00027704238891602
(541) DESCRIBE `avid_specials` 0.0012919902801514
(542) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 53605 and class = 'Cruise') OR (item_id = 770 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.0012109279632568
(543) DESCRIBE `cruiselines` 0.0018391609191895
(544) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 20))) 0.00042200088500977
(545) DESCRIBE `orchid_image` 0.0018908977508545
(546) DESCRIBE `cruiselines` 0.0026249885559082
(547) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '20') 0.0004570484161377
(548) DESCRIBE `cruises` 0.0030810832977295
(549) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '55806') 0.00043106079101562
(550) DESCRIBE `ships` 0.0034151077270508
(551) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1146))) 0.00067305564880371
(552) DESCRIBE `ships` 0.0032539367675781
(553) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1146') 0.00048589706420898
(554) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034308433532715
(555) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00032806396484375
(556) DESCRIBE `itineraries` 0.001863956451416
(557) DESCRIBE `ports` 0.0019431114196777
(558) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00043797492980957
(559) DESCRIBE `ports` 0.0018019676208496
(560) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00040817260742188
(561) DESCRIBE `ports` 0.0013608932495117
(562) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00028800964355469
(563) DESCRIBE `sailingdates` 0.0012459754943848
(564) DESCRIBE `ports` 0.0018858909606934
(565) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00048613548278809
(566) DESCRIBE `ports` 0.0015649795532227
(567) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00032901763916016
(568) DESCRIBE `ports` 0.0015568733215332
(569) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2004))) 0.00057482719421387
(570) DESCRIBE `ports` 0.0019609928131104
(571) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2004') 0.00036501884460449
(572) DESCRIBE `ports` 0.0017199516296387
(573) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1590))) 0.0004429817199707
(574) DESCRIBE `ports` 0.001878023147583
(575) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1590') 0.00081896781921387
(576) DESCRIBE `ports` 0.0017151832580566
(577) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1068))) 0.00041294097900391
(578) DESCRIBE `ports` 0.0017540454864502
(579) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1068') 0.00037193298339844
(580) DESCRIBE `ports` 0.001755952835083
(581) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1564))) 0.00039505958557129
(582) DESCRIBE `ports` 0.001802921295166
(583) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1564') 0.00039100646972656
(584) DESCRIBE `ports` 0.0018870830535889
(585) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00043702125549316
(586) DESCRIBE `ports` 0.0017681121826172
(587) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00036787986755371
(588) DESCRIBE `ports` 0.00177001953125
(589) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00041794776916504
(590) DESCRIBE `ports` 0.0017690658569336
(591) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.0003669261932373
(592) DESCRIBE `ports` 0.0015950202941895
(593) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3685))) 0.00031495094299316
(594) DESCRIBE `ports` 0.0015869140625
(595) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3685') 0.00036382675170898
(596) DESCRIBE `ports` 0.0015847682952881
(597) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00030803680419922
(598) DESCRIBE `ports` 0.0017890930175781
(599) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00037813186645508
(600) DESCRIBE `avid_specials` 0.0034441947937012
(601) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 55806 and class = 'Cruise') OR (item_id = 1146 AND class = 'Ship') OR (item_id = 77 AND class = 'CruiseLine') OR (item_id = 50 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.0016160011291504
(602) DESCRIBE `cruiselines` 0.002572774887085
(603) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 77))) 0.00045180320739746
(604) DESCRIBE `orchid_image` 0.0023748874664307
(605) DESCRIBE `cruiselines` 0.0025918483734131
(606) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '77') 0.00040388107299805
(607) DESCRIBE `cruiselines` 0.0029020309448242
(608) SELECT `cruiselines`.* FROM `cruiselines` WHERE (id IN ('218', '77', '19', '26', '7', '171', '23', '144', '18', '31', '20', '101', '8', '183', '96', '12', '120', '191', '50', '103', '221', '29', '15', '33', '268', '37', '156', '28', '91', '262', '114', '110', '141', '131', '208', '153', '187', '14', '232', '24', '118', '49', '181', '258', '151', '36', '212', '30', '206', '140', '204', '4', '256', '238', '249', '220', '16', '239', '47', '174', '113', '35', '264', '90', '195', '216', '188', '182', '261', '136', '146', '159', '213', '237', '211', '115', '168', '196', '180', '73', '209', '57', '95', '248', '59', '219', '52', '184', '231', '170', '225', '229', '108', '88', '230', '276', '82', '244', '132', '269', '105', '275', '48', '119', '240', '116', '64', '266', '38', '134', '224', '210')) ORDER BY FIND_IN_SET(id, '218,77,19,26,7,171,23,144,18,31,20,101,8,183,96,12,120,191,50,103,221,29,15,33,268,37,156,28,91,262,114,110,141,131,208,153,187,14,232,24,118,49,181,258,151,36,212,30,206,140,204,4,256,238,249,220,16,239,47,174,113,35,264,90,195,216,188,182,261,136,146,159,213,237,211,115,168,196,180,73,209,57,95,248,59,219,52,184,231,170,225,229,108,88,230,276,82,244,132,269,105,275,48,119,240,116,64,266,38,134,224,210') 0.0076560974121094
(609) DESCRIBE `ships` 0.0035600662231445
(610) SELECT `ships`.* FROM `ships` WHERE (id IN ('1127', '1032', '1292', '1205', '977', '1199', '1247', '1554', '1555', '1291', '1359', '1272', '1588', '1067', '1237', '1599', '407', '258', '1594', '27', '22', '21', '461', '28', '37', '38', '34', '378', '31', '393', '726', '817', '1424', '349', '1135', '30', '1012', '36', '39', '1422', '780', '1419', '1423', '1420', '1421', '1418', '35', '1415', '462', '113', '404', '452', '1677', '24', '766', '265', '1405', '11', '439', '1245', '711', '10', '330', '1215', '1574', '9', '585', '455', '542', '1141', '674', '124', '739', '770', '635', '1572', '1607', '5', '792', '797', '207', '1460', '3', '573', '974', '116', '340', '520', '553', '1454', '25', '1372', '1455', '160', '1193', '874', '517', '580', '1021', '1284', '1302', '390', '1095', '1325', '1402', '253', '285', '4', '332', '748', '43', '66', '1172', '1320', '658', '765', '791', '1068', '582', '1323', '434', '1260', '421', '559', '993', '1259', '1575', '327', '590', '883', '1586', '81', '286', '970', '1678', '119', '406', '526', '678', '78', '854', '1571', '375', '616', '14', '454', '722', '850', '855', '1236', '1492', '547', '823', '1266', '1569', '114', '405', '1008', '1064', '1139', '1208', '1308', '84', '441', '403', '784', '732', '1319', '1330', '1348', '1437', '348', '657', '966', '1088', '1108', '1282', '1587', '1672', '111', '163', '652', '1321', '262', '325', '338', '1326', '1327', '333', '451', '1143', '1389', '123', '508', '521', '1579', '1724', '389', '1027', '1159', '1243', '1376', '148', '351', '683', '1151', '1471', '1526', '314', '483', '1013', '1214', '1367', '162', '290', '75', '93', '287', '394', '626', '1163', '1318', '1398', '545', '651', '731', '859', '751', '1075', '1344', '1602', '291', '673', '768', '1040', '1137', '1144', '1157', '1343', '98', '149', '335', '716', '743', '852', '968', '1063', '1168', '1233', '1413', '1604', '152', '610', '818', '884', '1223', '1303', '1345', '1452', '1453', '1581', '1711', '82', '401', '669', '769', '1025', '1043', '1090', '1136', '1145', '1283', '1301', '1373', '1552', '45', '150', '151', '352', '790', '796', '1241', '201', '223', '485', '776', '882', '1160', '1717', '59', '108', '467', '503', '1152', '1226', '1539', '1738', '324', '341', '639', '905', '988', '1149', '1150', '1448', '1463', '266', '1409', '1449', '1540', '417', '871', '885', '1253', '1411', '1647', '105', '601', '811', '1055', '1458', '1682', '1704', '74', '1026', '1029', '1073', '1188', '1351', '1632', '448', '701', '973', '1231', '1489', '1505', '954', '986', '1034', '1047', '1366', '1408', '1496', '1609', '1742', '494', '666', '704', '795', '851', '1049', '1230', '1362', '1368', '1516', '1740', '205', '208', '738', '888', '996', '1154', '1285', '147', '493', '1037', '1470', '1474', '1580', '1627', '618', '836', '1224', '1444', '1518', '423', '837', '1176', '1382', '1417', '1521', '1229', '1404', '1407', '1410', '1716', '204', '422', '643', '985', '1138', '1196', '1262', '1593', '672', '709', '857', '1054', '1148', '1445', '1486', '1517', '1522', '1619', '671', '717', '972', '1017', '1042', '1051', '1352', '1713', '1715', '781', '994', '1175', '1714', '479', '480', '938', '1106', '1240', '1254', '1412', '1673', '665', '995', '1514', '1606', '1614', '1684', '17', '499', '574', '821', '1045', '1360', '1361', '1459', '1601', '1011', '1053', '1134', '1384', '1481', '1628', '313', '420', '982', '1028', '1322', '1358', '1383', '1501', '1515', '1676', '453', '749', '937', '958', '1439', '1461', '1645', '1708', '1743', '775', '999', '1052', '1071', '1206', '1256', '1615', '1722', '1723', '419', '744', '798', '808', '1631', '1729', '487', '687', '969', '1189', '1232', '1274', '1293', '1297', '1338', '1355', '1035', '1048', '1679', '1681', '1697', '70', '212', '288', '1060', '1089')) ORDER BY FIND_IN_SET(id, '1127,1032,1292,1205,977,1199,1247,1554,1555,1291,1359,1272,1588,1067,1237,1599,407,258,1594,27,22,21,461,28,37,38,34,378,31,393,726,817,1424,349,1135,30,1012,36,39,1422,780,1419,1423,1420,1421,1418,35,1415,462,113,404,452,1677,24,766,265,1405,11,439,1245,711,10,330,1215,1574,9,585,455,542,1141,674,124,739,770,635,1572,1607,5,792,797,207,1460,3,573,974,116,340,520,553,1454,25,1372,1455,160,1193,874,517,580,1021,1284,1302,390,1095,1325,1402,253,285,4,332,748,43,66,1172,1320,658,765,791,1068,582,1323,434,1260,421,559,993,1259,1575,327,590,883,1586,81,286,970,1678,119,406,526,678,78,854,1571,375,616,14,454,722,850,855,1236,1492,547,823,1266,1569,114,405,1008,1064,1139,1208,1308,84,441,403,784,732,1319,1330,1348,1437,348,657,966,1088,1108,1282,1587,1672,111,163,652,1321,262,325,338,1326,1327,333,451,1143,1389,123,508,521,1579,1724,389,1027,1159,1243,1376,148,351,683,1151,1471,1526,314,483,1013,1214,1367,162,290,75,93,287,394,626,1163,1318,1398,545,651,731,859,751,1075,1344,1602,291,673,768,1040,1137,1144,1157,1343,98,149,335,716,743,852,968,1063,1168,1233,1413,1604,152,610,818,884,1223,1303,1345,1452,1453,1581,1711,82,401,669,769,1025,1043,1090,1136,1145,1283,1301,1373,1552,45,150,151,352,790,796,1241,201,223,485,776,882,1160,1717,59,108,467,503,1152,1226,1539,1738,324,341,639,905,988,1149,1150,1448,1463,266,1409,1449,1540,417,871,885,1253,1411,1647,105,601,811,1055,1458,1682,1704,74,1026,1029,1073,1188,1351,1632,448,701,973,1231,1489,1505,954,986,1034,1047,1366,1408,1496,1609,1742,494,666,704,795,851,1049,1230,1362,1368,1516,1740,205,208,738,888,996,1154,1285,147,493,1037,1470,1474,1580,1627,618,836,1224,1444,1518,423,837,1176,1382,1417,1521,1229,1404,1407,1410,1716,204,422,643,985,1138,1196,1262,1593,672,709,857,1054,1148,1445,1486,1517,1522,1619,671,717,972,1017,1042,1051,1352,1713,1715,781,994,1175,1714,479,480,938,1106,1240,1254,1412,1673,665,995,1514,1606,1614,1684,17,499,574,821,1045,1360,1361,1459,1601,1011,1053,1134,1384,1481,1628,313,420,982,1028,1322,1358,1383,1501,1515,1676,453,749,937,958,1439,1461,1645,1708,1743,775,999,1052,1071,1206,1256,1615,1722,1723,419,744,798,808,1631,1729,487,687,969,1189,1232,1274,1293,1297,1338,1355,1035,1048,1679,1681,1697,70,212,288,1060,1089') 0.045692920684814
(611) DESCRIBE `cruisetypes` 0.0021297931671143
(612) DESCRIBE `destinations` 0.0020110607147217
(613) SELECT `destinations`.* FROM `destinations` WHERE (id IN ('50', '12', '22', '54', '35', '25', '37', '9', '43', '2', '8', '53', '39', '55', '28', '40', '26', '38', '11', '7', '30', '48', '21', '49', '45', '44', '56', '29', '34', '10', '52', '46', '32')) ORDER BY FIND_IN_SET(id, '50,12,22,54,35,25,37,9,43,2,8,53,39,55,28,40,26,38,11,7,30,48,21,49,45,44,56,29,34,10,52,46,32') 0.0023388862609863