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

Total elapsed time: 1.1338813304901

# Query Time
(1) connect 0.0015430450439453
(2) DESCRIBE `cruises` 0.0034160614013672
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (67110, 67373, 59221, 65237, 65604, 67370, 65026, 65899, 66644, 67111)) ORDER BY FIND_IN_SET(id, '67110,67373,59221,65237,65604,67370,65026,65899,66644,67111') 0.0011510848999023
(4) DESCRIBE `cruises` 0.0033919811248779
(5) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67110') 0.00082778930664062
(6) DESCRIBE `ships` 0.0043649673461914
(7) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 340))) 0.00019192695617676
(8) DESCRIBE `ships` 0.0037739276885986
(9) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '340') 0.00043797492980957
(10) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00039792060852051
(11) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00040197372436523
(12) DESCRIBE `itineraries` 0.0018131732940674
(13) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67110') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00085091590881348
(14) DESCRIBE `ports` 0.0015690326690674
(15) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00049901008605957
(16) DESCRIBE `ports` 0.00091791152954102
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00044107437133789
(18) DESCRIBE `ports` 0.0019340515136719
(19) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00042390823364258
(20) DESCRIBE `sailingdates` 0.0014829635620117
(21) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67110') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00060892105102539
(22) DESCRIBE `ports` 0.0018999576568604
(23) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0004730224609375
(24) DESCRIBE `ports` 0.0018291473388672
(25) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00041389465332031
(26) DESCRIBE `ports` 0.0022900104522705
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00049400329589844
(28) DESCRIBE `ports` 0.0016019344329834
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00034689903259277
(30) DESCRIBE `ports` 0.001417875289917
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00032496452331543
(32) DESCRIBE `ports` 0.0014297962188721
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.00029492378234863
(34) DESCRIBE `ports` 0.0014021396636963
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00054192543029785
(36) DESCRIBE `ports` 0.0019569396972656
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00042486190795898
(38) DESCRIBE `ports` 0.0013201236724854
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 197))) 0.00052309036254883
(40) DESCRIBE `ports` 0.0017468929290771
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '197') 0.00035810470581055
(42) DESCRIBE `ports` 0.0019998550415039
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00037407875061035
(44) DESCRIBE `ports` 0.0015370845794678
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00070595741271973
(46) DESCRIBE `ports` 0.001147985458374
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2476))) 0.00029993057250977
(48) DESCRIBE `ports` 0.0017099380493164
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2476') 0.00034093856811523
(50) DESCRIBE `ports` 0.0018811225891113
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00039792060852051
(52) DESCRIBE `ports` 0.0016090869903564
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00035810470581055
(54) DESCRIBE `ports` 0.00177001953125
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00044107437133789
(56) DESCRIBE `ports` 0.0016100406646729
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.00037217140197754
(58) DESCRIBE `ports` 0.0015690326690674
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00046491622924805
(60) DESCRIBE `ports` 0.0014770030975342
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.0003669261932373
(62) DESCRIBE `ports` 0.0014910697937012
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00038886070251465
(64) DESCRIBE `ports` 0.0016350746154785
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00030303001403809
(66) DESCRIBE `ports` 0.0016050338745117
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0003058910369873
(68) DESCRIBE `ports` 0.0017819404602051
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00031304359436035
(70) DESCRIBE `ports` 0.0016438961029053
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 526))) 0.00084805488586426
(72) DESCRIBE `ports` 0.0014259815216064
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '526') 0.00040388107299805
(74) DESCRIBE `ports` 0.00136399269104
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2499))) 0.00029897689819336
(76) DESCRIBE `ports` 0.0012619495391846
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2499') 0.00027298927307129
(78) DESCRIBE `ports` 0.0012369155883789
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 370))) 0.00029993057250977
(80) DESCRIBE `ports` 0.0012800693511963
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '370') 0.00027608871459961
(82) DESCRIBE `ports` 0.001370906829834
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00030016899108887
(84) DESCRIBE `ports` 0.001323938369751
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00027680397033691
(86) DESCRIBE `ports` 0.0012509822845459
(87) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00029921531677246
(88) DESCRIBE `ports` 0.0012798309326172
(89) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00029587745666504
(90) DESCRIBE `ports` 0.0014951229095459
(91) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 211))) 0.00031113624572754
(92) DESCRIBE `ports` 0.0014138221740723
(93) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '211') 0.00031018257141113
(94) DESCRIBE `ports` 0.0014948844909668
(95) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 376))) 0.00040006637573242
(96) DESCRIBE `ports` 0.0014579296112061
(97) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '376') 0.00032901763916016
(98) DESCRIBE `ports` 0.0017881393432617
(99) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 275))) 0.00035285949707031
(100) DESCRIBE `ports` 0.0012669563293457
(101) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '275') 0.00029897689819336
(102) DESCRIBE `ports` 0.0013628005981445
(103) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00029706954956055
(104) DESCRIBE `ports` 0.0012581348419189
(105) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00026893615722656
(106) DESCRIBE `ports` 0.0012369155883789
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 206))) 0.00034093856811523
(108) DESCRIBE `ports` 0.0013120174407959
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '206') 0.00026917457580566
(110) DESCRIBE `avid_specials` 0.0012478828430176
(111) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67110 and class = 'Cruise') OR (item_id = 340 AND class = 'Ship') OR (item_id = 18 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.0011529922485352
(112) DESCRIBE `cruiselines` 0.0020890235900879
(113) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.0003659725189209
(114) DESCRIBE `orchid_image` 0.0016281604766846
(115) DESCRIBE `cruiselines` 0.0019299983978271
(116) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.0003209114074707
(117) DESCRIBE `cruises` 0.0033631324768066
(118) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67373') 0.00040006637573242
(119) DESCRIBE `ships` 0.0034370422363281
(120) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 798))) 0.00045108795166016
(121) DESCRIBE `ships` 0.0033869743347168
(122) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '798') 0.00040411949157715
(123) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00039100646972656
(124) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00028395652770996
(125) DESCRIBE `itineraries` 0.0014591217041016
(126) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67373') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00082182884216309
(127) DESCRIBE `ports` 0.0013999938964844
(128) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00034689903259277
(129) DESCRIBE `ports` 0.0013208389282227
(130) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.000701904296875
(131) DESCRIBE `ports` 0.0011281967163086
(132) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.0002892017364502
(133) DESCRIBE `sailingdates` 0.0015449523925781
(134) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67373') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00047111511230469
(135) DESCRIBE `ports` 0.0016059875488281
(136) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00034308433532715
(137) DESCRIBE `ports` 0.0017929077148438
(138) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00036406517028809
(139) DESCRIBE `ports` 0.0014338493347168
(140) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00092816352844238
(141) DESCRIBE `ports` 0.0020160675048828
(142) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00042915344238281
(143) DESCRIBE `ports` 0.0018489360809326
(144) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00040698051452637
(145) DESCRIBE `ports` 0.0018038749694824
(146) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00035619735717773
(147) DESCRIBE `ports` 0.0018470287322998
(148) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.00040984153747559
(149) DESCRIBE `ports` 0.0018548965454102
(150) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1552') 0.00039315223693848
(151) DESCRIBE `ports` 0.0017681121826172
(152) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1551))) 0.00040602684020996
(153) DESCRIBE `ports` 0.0017800331115723
(154) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1551') 0.00042414665222168
(155) DESCRIBE `ports` 0.0017120838165283
(156) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1550))) 0.00038290023803711
(157) DESCRIBE `ports` 0.0017380714416504
(158) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1550') 0.00030899047851562
(159) DESCRIBE `ports` 0.0012791156768799
(160) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4505))) 0.00030303001403809
(161) DESCRIBE `ports` 0.0015480518341064
(162) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4505') 0.00033402442932129
(163) DESCRIBE `ports` 0.001594066619873
(164) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00037193298339844
(165) DESCRIBE `ports` 0.0013060569763184
(166) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00032711029052734
(167) DESCRIBE `ports` 0.001427173614502
(168) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00030612945556641
(169) DESCRIBE `ports` 0.0013399124145508
(170) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00035405158996582
(171) DESCRIBE `ports` 0.0016648769378662
(172) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00031685829162598
(173) DESCRIBE `ports` 0.0015909671783447
(174) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00031805038452148
(175) DESCRIBE `ports` 0.0015850067138672
(176) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00040483474731445
(177) DESCRIBE `ports` 0.001366138458252
(178) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00033307075500488
(179) DESCRIBE `ports` 0.0013759136199951
(180) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1554))) 0.00031304359436035
(181) DESCRIBE `ports` 0.0016028881072998
(182) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1554') 0.00037598609924316
(183) DESCRIBE `ports` 0.0013048648834229
(184) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1558))) 0.0003349781036377
(185) DESCRIBE `ports` 0.0015921592712402
(186) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1558') 0.00037908554077148
(187) DESCRIBE `ports` 0.0014939308166504
(188) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00031018257141113
(189) DESCRIBE `ports` 0.0013949871063232
(190) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00031495094299316
(191) DESCRIBE `ports` 0.0013730525970459
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00031495094299316
(193) DESCRIBE `ports` 0.001309871673584
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00027298927307129
(195) DESCRIBE `ports` 0.0012490749359131
(196) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1556))) 0.00029993057250977
(197) DESCRIBE `ports` 0.0013048648834229
(198) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1556') 0.00030803680419922
(199) DESCRIBE `ports` 0.00142502784729
(200) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00045013427734375
(201) DESCRIBE `ports` 0.0015630722045898
(202) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00035810470581055
(203) DESCRIBE `ports` 0.0015249252319336
(204) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0
(205) DESCRIBE `ports` 0.0015058517456055
(206) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00043678283691406
(207) DESCRIBE `ports` 0.0015900135040283
(208) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4087))) 0.00039410591125488
(209) DESCRIBE `ports` 0.0016171932220459
(210) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4087') 0.00028800964355469
(211) DESCRIBE `ports` 0.0014808177947998
(212) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2673))) 0.00091409683227539
(213) DESCRIBE `ports` 0.002100944519043
(214) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2673') 0.0004580020904541
(215) DESCRIBE `ports` 0.0017919540405273
(216) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4086))) 0.00040197372436523
(217) DESCRIBE `ports` 0.0018160343170166
(218) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4086') 0.00036501884460449
(219) DESCRIBE `ports` 0.0018398761749268
(220) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4088))) 0.00039291381835938
(221) DESCRIBE `ports` 0.0019538402557373
(222) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4088') 0.0003509521484375
(223) DESCRIBE `ports` 0.0017871856689453
(224) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4088))) 0.00041007995605469
(225) DESCRIBE `ports` 0.0018391609191895
(226) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4088') 0.0003669261932373
(227) DESCRIBE `ports` 0.0017778873443604
(228) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00040888786315918
(229) DESCRIBE `ports` 0.0017859935760498
(230) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.0003960132598877
(231) DESCRIBE `ports` 0.0018978118896484
(232) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00041484832763672
(233) DESCRIBE `ports` 0.001723051071167
(234) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00036096572875977
(235) DESCRIBE `ports` 0.0017681121826172
(236) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 527))) 0.00040507316589355
(237) DESCRIBE `ports` 0.0017540454864502
(238) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '527') 0.00039100646972656
(239) DESCRIBE `avid_specials` 0.0014779567718506
(240) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67373 and class = 'Cruise') OR (item_id = 798 AND class = 'Ship') OR (item_id = 181 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.0014681816101074
(241) DESCRIBE `cruiselines` 0.0023748874664307
(242) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.00042390823364258
(243) DESCRIBE `orchid_image` 0.001183032989502
(244) DESCRIBE `cruiselines` 0.0021040439605713
(245) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00030398368835449
(246) DESCRIBE `cruises` 0.0026659965515137
(247) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '59221') 0.00032877922058105
(248) DESCRIBE `ships` 0.0026888847351074
(249) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1412))) 0.00036311149597168
(250) DESCRIBE `ships` 0.0025119781494141
(251) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1412') 0.00039219856262207
(252) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00026488304138184
(253) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00025486946105957
(254) DESCRIBE `itineraries` 0.0014548301696777
(255) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '59221') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00095295906066895
(256) DESCRIBE `ports` 0.0014748573303223
(257) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00033783912658691
(258) DESCRIBE `ports` 0.001276969909668
(259) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00030183792114258
(260) DESCRIBE `ports` 0.001305103302002
(261) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00030899047851562
(262) DESCRIBE `sailingdates` 0.0012688636779785
(263) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '59221') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00078415870666504
(264) DESCRIBE `ports` 0.0016460418701172
(265) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.0003659725189209
(266) DESCRIBE `ports` 0.0013959407806396
(267) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00028896331787109
(268) DESCRIBE `ports` 0.0015029907226562
(269) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1580))) 0.00037503242492676
(270) DESCRIBE `ports` 0.0015051364898682
(271) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1580') 0.00028705596923828
(272) DESCRIBE `ports` 0.001349925994873
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 936))) 0.00029897689819336
(274) DESCRIBE `ports` 0.0012738704681396
(275) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '936') 0.00027608871459961
(276) DESCRIBE `ports` 0.0014579296112061
(277) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00031113624572754
(278) DESCRIBE `ports` 0.001352071762085
(279) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00029206275939941
(280) DESCRIBE `ports` 0.0012800693511963
(281) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00031590461730957
(282) DESCRIBE `ports` 0.0013039112091064
(283) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.0002739429473877
(284) DESCRIBE `ports` 0.0012478828430176
(285) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.00030398368835449
(286) DESCRIBE `ports` 0.0013201236724854
(287) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.00028109550476074
(288) DESCRIBE `ports` 0.00142502784729
(289) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00036716461181641
(290) DESCRIBE `ports` 0.0014619827270508
(291) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00034999847412109
(292) DESCRIBE `ports` 0.0015180110931396
(293) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00031495094299316
(294) DESCRIBE `ports` 0.0014920234680176
(295) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00037193298339844
(296) DESCRIBE `ports` 0.0013549327850342
(297) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00031518936157227
(298) DESCRIBE `ports` 0.0013320446014404
(299) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00028109550476074
(300) DESCRIBE `ports` 0.0013740062713623
(301) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3337))) 0.00030803680419922
(302) DESCRIBE `ports` 0.0013020038604736
(303) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3337') 0.00027799606323242
(304) DESCRIBE `ports` 0.0013179779052734
(305) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0.00033092498779297
(306) DESCRIBE `ports` 0.0013411045074463
(307) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00027298927307129
(308) DESCRIBE `ports` 0.0012619495391846
(309) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00034713745117188
(310) DESCRIBE `ports` 0.0012531280517578
(311) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00033903121948242
(312) DESCRIBE `ports` 0.0013790130615234
(313) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.00035810470581055
(314) DESCRIBE `ports` 0.0014801025390625
(315) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.00032210350036621
(316) DESCRIBE `ports` 0.0016090869903564
(317) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00030803680419922
(318) DESCRIBE `ports` 0.0017919540405273
(319) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00031399726867676
(320) DESCRIBE `ports` 0.0011780261993408
(321) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1566))) 0.00031495094299316
(322) DESCRIBE `ports` 0.0013768672943115
(323) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1566') 0.00028085708618164
(324) DESCRIBE `ports` 0.0012738704681396
(325) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00030517578125
(326) DESCRIBE `ports` 0.0012609958648682
(327) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00030398368835449
(328) DESCRIBE `ports` 0.0013349056243896
(329) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1592))) 0.00034308433532715
(330) DESCRIBE `ports` 0.0018100738525391
(331) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1592') 0.00038695335388184
(332) DESCRIBE `ports` 0.0018770694732666
(333) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00042510032653809
(334) DESCRIBE `ports` 0.0018110275268555
(335) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00030994415283203
(336) DESCRIBE `ports` 0.0012969970703125
(337) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1515))) 0.00041604042053223
(338) DESCRIBE `ports` 0.0015349388122559
(339) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1515') 0.00029802322387695
(340) DESCRIBE `avid_specials` 0.0016121864318848
(341) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 59221 and class = 'Cruise') OR (item_id = 1412 AND class = 'Ship') OR (item_id = 258 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.0015840530395508
(342) DESCRIBE `cruiselines` 0.0019080638885498
(343) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 258))) 0.00036382675170898
(344) DESCRIBE `orchid_image` 0.0019040107727051
(345) DESCRIBE `cruiselines` 0.0026760101318359
(346) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '258') 0.00054001808166504
(347) DESCRIBE `cruises` 0.0031790733337402
(348) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65237') 0.00044989585876465
(349) DESCRIBE `ships` 0.0029559135437012
(350) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 265))) 0.00052905082702637
(351) DESCRIBE `ships` 0.0027980804443359
(352) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '265') 0.00035381317138672
(353) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00026798248291016
(354) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00030398368835449
(355) DESCRIBE `itineraries` 0.0014541149139404
(356) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65237') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00081181526184082
(357) DESCRIBE `ports` 0.0017180442810059
(358) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00046014785766602
(359) DESCRIBE `ports` 0.0014660358428955
(360) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00031900405883789
(361) DESCRIBE `ports` 0.0013511180877686
(362) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00029110908508301
(363) DESCRIBE `sailingdates` 0.0011539459228516
(364) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65237') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00078988075256348
(365) DESCRIBE `ports` 0.0017521381378174
(366) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00081896781921387
(367) DESCRIBE `ports` 0.0018339157104492
(368) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.0003199577331543
(369) DESCRIBE `ports` 0.001305103302002
(370) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00031590461730957
(371) DESCRIBE `ports` 0.0012891292572021
(372) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00028491020202637
(373) DESCRIBE `ports` 0.0013179779052734
(374) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 195))) 0.00035691261291504
(375) DESCRIBE `ports` 0.0013630390167236
(376) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '195') 0.00031304359436035
(377) DESCRIBE `ports` 0.0014028549194336
(378) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 239))) 0.00031900405883789
(379) DESCRIBE `ports` 0.0014030933380127
(380) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '239') 0.00029611587524414
(381) DESCRIBE `ports` 0.0015900135040283
(382) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 534))) 5.8889389038086E-5
(383) DESCRIBE `ports` 0.0015511512756348
(384) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '534') 0.00044798851013184
(385) DESCRIBE `ports` 0.0015079975128174
(386) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00031208992004395
(387) DESCRIBE `ports` 0.0015730857849121
(388) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00032401084899902
(389) DESCRIBE `ports` 0.0012800693511963
(390) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00035381317138672
(391) DESCRIBE `ports` 0.0014510154724121
(392) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.0002901554107666
(393) DESCRIBE `ports` 0.0016200542449951
(394) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2452))) 0.00032305717468262
(395) DESCRIBE `ports` 0.0015990734100342
(396) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2452') 0.00041007995605469
(397) DESCRIBE `ports` 0.0011851787567139
(398) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00042819976806641
(399) DESCRIBE `ports` 0.0016751289367676
(400) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00028800964355469
(401) DESCRIBE `ports` 0.0017211437225342
(402) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2613))) 0.00037813186645508
(403) DESCRIBE `ports` 0.0015420913696289
(404) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2613') 0.00031900405883789
(405) DESCRIBE `ports` 0.0015180110931396
(406) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 216))) 0.00037503242492676
(407) DESCRIBE `ports` 0.0017929077148438
(408) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '216') 0.00047612190246582
(409) DESCRIBE `avid_specials` 0.0015368461608887
(410) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65237 and class = 'Cruise') OR (item_id = 265 AND class = 'Ship') OR (item_id = 50 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.0012290477752686
(411) DESCRIBE `cruiselines` 0.0024788379669189
(412) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 50))) 0.00045013427734375
(413) DESCRIBE `orchid_image` 0.0015499591827393
(414) DESCRIBE `cruiselines` 0.00235915184021
(415) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '50') 0.00038886070251465
(416) DESCRIBE `cruises` 0.0035269260406494
(417) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65604') 0.00059986114501953
(418) DESCRIBE `ships` 0.0036609172821045
(419) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1413))) 0.00053787231445312
(420) DESCRIBE `ships` 0.0037689208984375
(421) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1413') 0.0004889965057373
(422) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035309791564941
(423) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00034189224243164
(424) DESCRIBE `itineraries` 0.001917839050293
(425) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65604') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00078296661376953
(426) DESCRIBE `ports` 0.0014960765838623
(427) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00044703483581543
(428) DESCRIBE `ports` 0.0012919902801514
(429) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00031805038452148
(430) DESCRIBE `ports` 0.0013439655303955
(431) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00033688545227051
(432) DESCRIBE `sailingdates` 0.0014522075653076
(433) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65604') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00056695938110352
(434) DESCRIBE `ports` 0.0016660690307617
(435) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.0004279613494873
(436) DESCRIBE `ports` 0.0017421245574951
(437) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00033998489379883
(438) DESCRIBE `ports` 0.0016119480133057
(439) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 939))) 0.00058102607727051
(440) DESCRIBE `ports` 0.0016019344329834
(441) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '939') 0.00040316581726074
(442) DESCRIBE `ports` 0.0016059875488281
(443) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1601))) 0.0003361701965332
(444) DESCRIBE `ports` 0.0017259120941162
(445) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1601') 0.0003509521484375
(446) DESCRIBE `ports` 0.0016541481018066
(447) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1576))) 0.00030899047851562
(448) DESCRIBE `ports` 0.0017390251159668
(449) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1576') 0.00038909912109375
(450) DESCRIBE `ports` 0.0016350746154785
(451) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1581))) 0.00037002563476562
(452) DESCRIBE `ports` 0.001784086227417
(453) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1581') 0.0003359317779541
(454) DESCRIBE `ports` 0.0017638206481934
(455) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1575))) 0.00034093856811523
(456) DESCRIBE `ports` 0.0015110969543457
(457) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1575') 0.00037598609924316
(458) DESCRIBE `ports` 0.0017819404602051
(459) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1574))) 0
(460) DESCRIBE `ports` 0.0017788410186768
(461) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1574') 0.00058102607727051
(462) DESCRIBE `ports` 0.0017640590667725
(463) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1571))) 0.00040602684020996
(464) DESCRIBE `ports` 0.0017631053924561
(465) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1571') 0.00029611587524414
(466) DESCRIBE `ports` 0.0016090869903564
(467) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1570))) 0.00035500526428223
(468) DESCRIBE `ports` 0.0012779235839844
(469) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1570') 0.00031495094299316
(470) DESCRIBE `ports` 0.0012660026550293
(471) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1600))) 0.00030899047851562
(472) DESCRIBE `ports` 0.0012791156768799
(473) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1600') 0.00027585029602051
(474) DESCRIBE `ports` 0.0013020038604736
(475) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1566))) 0.00031805038452148
(476) DESCRIBE `ports` 0.0015370845794678
(477) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1566') 0.00028800964355469
(478) DESCRIBE `ports` 0.0014908313751221
(479) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1563))) 0.00047016143798828
(480) DESCRIBE `ports` 0.0015969276428223
(481) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1563') 0.00029802322387695
(482) DESCRIBE `ports` 0.0016450881958008
(483) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1594))) 0.00036191940307617
(484) DESCRIBE `ports` 0.0016782283782959
(485) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1594') 0.00077986717224121
(486) DESCRIBE `ports` 0.0020859241485596
(487) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3806))) 0.00047898292541504
(488) DESCRIBE `ports` 0.0018990039825439
(489) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3806') 0.00045990943908691
(490) DESCRIBE `ports` 0.0018520355224609
(491) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.0004279613494873
(492) DESCRIBE `ports` 0.0019040107727051
(493) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00039196014404297
(494) DESCRIBE `ports` 0.0016970634460449
(495) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2379))) 0.00044012069702148
(496) DESCRIBE `ports` 0.0019690990447998
(497) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2379') 0.00040793418884277
(498) DESCRIBE `avid_specials` 0.0017290115356445
(499) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65604 and class = 'Cruise') OR (item_id = 1413 AND class = 'Ship') OR (item_id = 258 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.0017199516296387
(500) DESCRIBE `cruiselines` 0.0028290748596191
(501) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 258))) 0.00057697296142578
(502) DESCRIBE `orchid_image` 0.0021378993988037
(503) DESCRIBE `cruiselines` 0.0027801990509033
(504) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '258') 0.00051307678222656
(505) DESCRIBE `cruises` 0.0028591156005859
(506) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67370') 0.00035500526428223
(507) DESCRIBE `ships` 0.0032570362091064
(508) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 798))) 0.00052189826965332
(509) DESCRIBE `ships` 0.0032908916473389
(510) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '798') 0.00035500526428223
(511) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035405158996582
(512) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00035905838012695
(513) DESCRIBE `itineraries` 0.0015239715576172
(514) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67370') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00053286552429199
(515) DESCRIBE `ports` 0.0022029876708984
(516) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00044584274291992
(517) DESCRIBE `ports` 0.0019760131835938
(518) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00030303001403809
(519) DESCRIBE `ports` 0.0014808177947998
(520) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00033116340637207
(521) DESCRIBE `sailingdates` 0.0013198852539062
(522) DESCRIBE `ports` 0.0018298625946045
(523) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00039792060852051
(524) DESCRIBE `ports` 0.0014400482177734
(525) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00043916702270508
(526) DESCRIBE `ports` 0.0017139911651611
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1510))) 0.00044989585876465
(528) DESCRIBE `ports` 0.0016250610351562
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1510') 0.00035405158996582
(530) DESCRIBE `ports` 0.0015809535980225
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1508))) 0.00036287307739258
(532) DESCRIBE `ports` 0.0016078948974609
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1508') 0.00033807754516602
(534) DESCRIBE `ports` 0.0016219615936279
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1552))) 0.00040292739868164
(536) DESCRIBE `ports` 0.0017678737640381
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1552') 0.00042581558227539
(538) DESCRIBE `ports` 0.001676082611084
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1551))) 0.00037097930908203
(540) DESCRIBE `ports` 0.0017099380493164
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1551') 0.00036501884460449
(542) DESCRIBE `ports` 0.0016529560089111
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1550))) 0.00036501884460449
(544) DESCRIBE `ports` 0.0015938282012939
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1550') 0.00034594535827637
(546) DESCRIBE `ports` 0.0015640258789062
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4505))) 0.00036787986755371
(548) DESCRIBE `ports` 0.0015361309051514
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4505') 0.0003509521484375
(550) DESCRIBE `ports` 0.0017900466918945
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00036406517028809
(552) DESCRIBE `ports` 0.0015990734100342
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00036096572875977
(554) DESCRIBE `ports` 0.0016767978668213
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00041794776916504
(556) DESCRIBE `ports` 0.0016469955444336
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00035309791564941
(558) DESCRIBE `ports` 0.0016689300537109
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1549))) 0.00039100646972656
(560) DESCRIBE `ports` 0.0016779899597168
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1549') 0.00034379959106445
(562) DESCRIBE `ports` 0.0015320777893066
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00037908554077148
(564) DESCRIBE `ports` 0.0015280246734619
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00033307075500488
(566) DESCRIBE `ports` 0.0016231536865234
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00040698051452637
(568) DESCRIBE `ports` 0.0016059875488281
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00032901763916016
(570) DESCRIBE `ports` 0.0015401840209961
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1554))) 0.00036883354187012
(572) DESCRIBE `ports` 0.0016260147094727
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1554') 0.00035810470581055
(574) DESCRIBE `ports` 0.0016751289367676
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1558))) 0.0003659725189209
(576) DESCRIBE `ports` 0.0017390251159668
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1558') 0.00035715103149414
(578) DESCRIBE `ports` 0.0017218589782715
(579) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00037097930908203
(580) DESCRIBE `ports` 0.0016498565673828
(581) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00033688545227051
(582) DESCRIBE `ports` 0.001676082611084
(583) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1557))) 0.00038385391235352
(584) DESCRIBE `ports` 0.0015928745269775
(585) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1557') 0.00033402442932129
(586) DESCRIBE `ports` 0.0015900135040283
(587) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1556))) 0.00034403800964355
(588) DESCRIBE `ports` 0.0015652179718018
(589) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1556') 0.00038003921508789
(590) DESCRIBE `ports` 0.0015349388122559
(591) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1506))) 0.00035810470581055
(592) DESCRIBE `ports` 0.0015828609466553
(593) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1506') 0.00032496452331543
(594) DESCRIBE `avid_specials` 0.0015039443969727
(595) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67370 and class = 'Cruise') OR (item_id = 798 AND class = 'Ship') OR (item_id = 181 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.0015830993652344
(596) DESCRIBE `cruiselines` 0.0025331974029541
(597) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 181))) 0.0004580020904541
(598) DESCRIBE `orchid_image` 0.0019941329956055
(599) DESCRIBE `cruiselines` 0.0024130344390869
(600) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '181') 0.00036382675170898
(601) DESCRIBE `cruises` 0.0037758350372314
(602) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65026') 0.00044012069702148
(603) DESCRIBE `ships` 0.0036790370941162
(604) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1191))) 0.00053501129150391
(605) DESCRIBE `ships` 0.0036110877990723
(606) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1191') 0.00041818618774414
(607) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003509521484375
(608) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0003359317779541
(609) DESCRIBE `itineraries` 0.0017120838165283
(610) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65026') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0010459423065186
(611) DESCRIBE `ports` 0.0020358562469482
(612) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00036501884460449
(613) DESCRIBE `ports` 0.0016460418701172
(614) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00030994415283203
(615) DESCRIBE `ports` 0.0014019012451172
(616) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00028896331787109
(617) DESCRIBE `sailingdates` 0.0012872219085693
(618) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65026') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00067305564880371
(619) DESCRIBE `ports` 0.0013949871063232
(620) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00032615661621094
(621) DESCRIBE `ports` 0.001305103302002
(622) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00028085708618164
(623) DESCRIBE `ports` 0.0016400814056396
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00030684471130371
(625) DESCRIBE `ports` 0.0014691352844238
(626) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.00028514862060547
(627) DESCRIBE `ports` 0.0013740062713623
(628) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 116))) 0.00033998489379883
(629) DESCRIBE `ports` 0.0013759136199951
(630) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '116') 0.0003049373626709
(631) DESCRIBE `ports` 0.0016520023345947
(632) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00038909912109375
(633) DESCRIBE `ports` 0.0017850399017334
(634) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00036406517028809
(635) DESCRIBE `ports` 0.0015158653259277
(636) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2200))) 0.00031590461730957
(637) DESCRIBE `ports` 0.0013840198516846
(638) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2200') 0.00028800964355469
(639) DESCRIBE `ports` 0.0013210773468018
(640) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1190))) 0.00029301643371582
(641) DESCRIBE `ports` 0.0013630390167236
(642) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1190') 0.00034379959106445
(643) DESCRIBE `ports` 0.0016658306121826
(644) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 3096))) 0.00035786628723145
(645) DESCRIBE `ports` 0.0014908313751221
(646) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '3096') 0.00036907196044922
(647) DESCRIBE `ports` 0.0012950897216797
(648) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 115))) 0.00040602684020996
(649) DESCRIBE `ports` 0.0012791156768799
(650) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '115') 0.00027704238891602
(651) DESCRIBE `ports` 0.0013108253479004
(652) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4570))) 0.00038886070251465
(653) DESCRIBE `ports` 0.0013670921325684
(654) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4570') 0.00030016899108887
(655) DESCRIBE `ports` 0.0014710426330566
(656) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4567))) 0.00032901763916016
(657) DESCRIBE `ports` 0.00148606300354
(658) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4567') 0.00033307075500488
(659) DESCRIBE `ports` 0.0013501644134521
(660) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1811))) 0.00031900405883789
(661) DESCRIBE `ports` 0.0012969970703125
(662) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1811') 0.00035786628723145
(663) DESCRIBE `ports` 0.0016241073608398
(664) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 355))) 0.00040602684020996
(665) DESCRIBE `ports` 0.0014140605926514
(666) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '355') 0.00037479400634766
(667) DESCRIBE `avid_specials` 0.0017349720001221
(668) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65026 and class = 'Cruise') OR (item_id = 1191 AND class = 'Ship') OR (item_id = 231 AND class = 'CruiseLine') OR (item_id = 11 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.0016441345214844
(669) DESCRIBE `cruiselines` 0.0024240016937256
(670) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 231))) 0.00047802925109863
(671) DESCRIBE `orchid_image` 0.001910924911499
(672) DESCRIBE `cruiselines` 0.0023839473724365
(673) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '231') 0.00037503242492676
(674) DESCRIBE `cruises` 0.0027408599853516
(675) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '65899') 0.00035881996154785
(676) DESCRIBE `ships` 0.0032598972320557
(677) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1550))) 0.0011119842529297
(678) DESCRIBE `ships` 0.0034170150756836
(679) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1550') 0.00052189826965332
(680) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.00027203559875488
(681) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '14') 0.0002589225769043
(682) DESCRIBE `itineraries` 0.0014410018920898
(683) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '65899') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00079488754272461
(684) DESCRIBE `ports` 0.0015621185302734
(685) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00037503242492676
(686) DESCRIBE `ports` 0.0015480518341064
(687) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00034189224243164
(688) DESCRIBE `ports` 0.0013980865478516
(689) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00026702880859375
(690) DESCRIBE `sailingdates` 0.0014598369598389
(691) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '65899') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.0006868839263916
(692) DESCRIBE `ports` 0.001453161239624
(693) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00029802322387695
(694) DESCRIBE `ports` 0.0014939308166504
(695) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00034403800964355
(696) DESCRIBE `ports` 0.0014889240264893
(697) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00028204917907715
(698) DESCRIBE `ports` 0.0014121532440186
(699) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00031018257141113
(700) DESCRIBE `ports` 0.0014560222625732
(701) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 183))) 0.00034284591674805
(702) DESCRIBE `ports` 0.0018270015716553
(703) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '183') 0.00036191940307617
(704) DESCRIBE `ports` 0.0018219947814941
(705) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2616))) 0.00039887428283691
(706) DESCRIBE `ports` 0.0018100738525391
(707) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2616') 0.00036001205444336
(708) DESCRIBE `ports` 0.0017340183258057
(709) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2616))) 0.0003969669342041
(710) DESCRIBE `ports` 0.0017719268798828
(711) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2616') 0.00037503242492676
(712) DESCRIBE `ports` 0.0017681121826172
(713) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2201))) 0.00040006637573242
(714) DESCRIBE `ports` 0.0017669200897217
(715) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2201') 0.00036406517028809
(716) DESCRIBE `ports` 0.0017991065979004
(717) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 5552))) 0.00041103363037109
(718) DESCRIBE `ports` 0.0017900466918945
(719) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '5552') 0.00039386749267578
(720) DESCRIBE `ports` 0.0018048286437988
(721) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2204))) 0.00039005279541016
(722) DESCRIBE `ports` 0.0017831325531006
(723) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2204') 0.00036787986755371
(724) DESCRIBE `ports` 0.001795768737793
(725) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1204))) 0.00048112869262695
(726) DESCRIBE `ports` 0.0017549991607666
(727) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1204') 0.00038003921508789
(728) DESCRIBE `ports` 0.0017681121826172
(729) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 563))) 0.0003969669342041
(730) DESCRIBE `ports` 0.0018241405487061
(731) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '563') 0.00036311149597168
(732) DESCRIBE `ports` 0.0017778873443604
(733) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 563))) 0.00039792060852051
(734) DESCRIBE `ports` 0.0017518997192383
(735) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '563') 0.00036907196044922
(736) DESCRIBE `ports` 0.0017740726470947
(737) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 563))) 0.00049591064453125
(738) DESCRIBE `ports` 0.0018000602722168
(739) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '563') 0.00046920776367188
(740) DESCRIBE `ports` 0.0018839836120605
(741) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4384))) 0.00042200088500977
(742) DESCRIBE `ports` 0.0018551349639893
(743) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4384') 0.0003809928894043
(744) DESCRIBE `ports` 0.0018119812011719
(745) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4384))) 0.00041103363037109
(746) DESCRIBE `ports` 0.0019600391387939
(747) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4384') 0.00040006637573242
(748) DESCRIBE `ports` 0.0018670558929443
(749) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4384))) 0.0004420280456543
(750) DESCRIBE `ports` 0.0018188953399658
(751) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4384') 0.00043702125549316
(752) DESCRIBE `ports` 0.0017900466918945
(753) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4384))) 0.0004119873046875
(754) DESCRIBE `ports` 0.0017709732055664
(755) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4384') 0.00037002563476562
(756) DESCRIBE `avid_specials` 0.0015811920166016
(757) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 65899 and class = 'Cruise') OR (item_id = 1550 AND class = 'Ship') OR (item_id = 204 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.0017638206481934
(758) DESCRIBE `cruiselines` 0.0026159286499023
(759) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 204))) 0.00045919418334961
(760) DESCRIBE `orchid_image` 0.0020589828491211
(761) DESCRIBE `cruiselines` 0.0025999546051025
(762) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '204') 0.00041007995605469
(763) DESCRIBE `cruises` 0.020856857299805
(764) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66644') 0.00054693222045898
(765) DESCRIBE `ships` 0.0041818618774414
(766) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 1021))) 0.00085592269897461
(767) DESCRIBE `ships` 0.034590005874634
(768) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '1021') 0.00068998336791992
(769) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00044703483581543
(770) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '4') 0.00064206123352051
(771) DESCRIBE `itineraries` 0.0094869136810303
(772) DESCRIBE `ports` 0.0034940242767334
(773) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00059103965759277
(774) DESCRIBE `ports` 0.0018601417541504
(775) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00043487548828125
(776) DESCRIBE `ports` 0.0017988681793213
(777) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.0004580020904541
(778) DESCRIBE `sailingdates` 0.0016169548034668
(779) DESCRIBE `ports` 0.0018939971923828
(780) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.0004420280456543
(781) DESCRIBE `ports` 0.0018470287322998
(782) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.00039005279541016
(783) DESCRIBE `ports` 0.0018899440765381
(784) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 434))) 0.00042104721069336
(785) DESCRIBE `ports` 0.0017828941345215
(786) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '434') 0.00038290023803711
(787) DESCRIBE `ports` 0.0017910003662109
(788) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2417))) 0.0004429817199707
(789) DESCRIBE `ports` 0.0015878677368164
(790) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2417') 0.00039410591125488
(791) DESCRIBE `ports` 0.0017719268798828
(792) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 752))) 0.00052499771118164
(793) DESCRIBE `ports` 0.0019080638885498
(794) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '752') 0.00046515464782715
(795) DESCRIBE `ports` 0.001884937286377
(796) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.00049805641174316
(797) DESCRIBE `ports` 0.0018248558044434
(798) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00039005279541016
(799) DESCRIBE `ports` 0.0018410682678223
(800) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 753))) 0.0004580020904541
(801) DESCRIBE `ports` 0.001845121383667
(802) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '753') 0.00040102005004883
(803) DESCRIBE `ports` 0.0016789436340332
(804) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 748))) 0.00044989585876465
(805) DESCRIBE `ports` 0.0015928745269775
(806) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '748') 0.00034499168395996
(807) DESCRIBE `ports` 0.0014529228210449
(808) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 747))) 0.00042605400085449
(809) DESCRIBE `ports` 0.001655101776123
(810) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '747') 0.00041604042053223
(811) DESCRIBE `ports` 0.0017259120941162
(812) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 747))) 0.00057888031005859
(813) DESCRIBE `ports` 0.0019509792327881
(814) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '747') 0.00037908554077148
(815) DESCRIBE `ports` 0.0017580986022949
(816) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 571))) 0.00048995018005371
(817) DESCRIBE `ports` 0.002094030380249
(818) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '571') 0.00050592422485352
(819) DESCRIBE `ports` 0.0019869804382324
(820) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1089))) 0.00043511390686035
(821) DESCRIBE `ports` 0.0018191337585449
(822) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1089') 0.0003969669342041
(823) DESCRIBE `ports` 0.0018320083618164
(824) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 248))) 0.00042486190795898
(825) DESCRIBE `ports` 0.0017290115356445
(826) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '248') 0.00039291381835938
(827) DESCRIBE `avid_specials` 0.0015439987182617
(828) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66644 and class = 'Cruise') OR (item_id = 1021 AND class = 'Ship') OR (item_id = 23 AND class = 'CruiseLine') OR (item_id = 21 AND class = 'Destination')) AND (date_start < NOW() OR date_start is null) AND (date_end > NOW() OR date_end is null OR date_end = '')) 0.0015959739685059
(829) DESCRIBE `cruiselines` 0.0025701522827148
(830) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 23))) 0.00047397613525391
(831) DESCRIBE `orchid_image` 0.0020079612731934
(832) DESCRIBE `cruiselines` 0.0025548934936523
(833) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '23') 0.00044894218444824
(834) DESCRIBE `cruises` 0.0034639835357666
(835) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '67111') 0.00046896934509277
(836) DESCRIBE `ships` 0.0036301612854004
(837) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 340))) 0.00061893463134766
(838) DESCRIBE `ships` 0.003903865814209
(839) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '340') 0.0004580020904541
(840) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00031208992004395
(841) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '5') 0.00033688545227051
(842) DESCRIBE `itineraries` 0.0016939640045166
(843) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '67111') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0005950927734375
(844) DESCRIBE `ports` 0.0019102096557617
(845) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.0003960132598877
(846) DESCRIBE `ports` 0.0015292167663574
(847) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00034999847412109
(848) DESCRIBE `ports` 0.0014491081237793
(849) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00033092498779297
(850) DESCRIBE `sailingdates` 0.0014231204986572
(851) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '67111') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00047993659973145
(852) DESCRIBE `ports` 0.0019381046295166
(853) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1881))) 0.00066304206848145
(854) DESCRIBE `ports` 0.0024640560150146
(855) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1881') 0.00055599212646484
(856) DESCRIBE `ports` 0.0024478435516357
(857) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 213))) 0.00045204162597656
(858) DESCRIBE `ports` 0.0020079612731934
(859) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '213') 0.00049591064453125
(860) DESCRIBE `ports` 0.0019981861114502
(861) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 196))) 0.00050020217895508
(862) DESCRIBE `ports` 0.002316951751709
(863) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '196') 0.0004570484161377
(864) DESCRIBE `ports` 0.0019309520721436
(865) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 198))) 0.00046110153198242
(866) DESCRIBE `ports` 0.0019659996032715
(867) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '198') 0.00050115585327148
(868) DESCRIBE `ports` 0.001910924911499
(869) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 197))) 0.00055909156799316
(870) DESCRIBE `ports` 0.0019128322601318
(871) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '197') 0.00045394897460938
(872) DESCRIBE `ports` 0.0019490718841553
(873) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1810))) 0.00048494338989258
(874) DESCRIBE `ports` 0.0019600391387939
(875) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1810') 0.00044703483581543
(876) DESCRIBE `ports` 0.0019559860229492
(877) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2476))) 7.8916549682617E-5
(878) DESCRIBE `ports` 0.0019638538360596
(879) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2476') 0.00058102607727051
(880) DESCRIBE `ports` 0.0019989013671875
(881) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1122))) 0.00040292739868164
(882) DESCRIBE `ports` 0.0017619132995605
(883) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1122') 0.00039386749267578
(884) DESCRIBE `ports` 0.0019261837005615
(885) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 525))) 0.00042510032653809
(886) DESCRIBE `ports` 0.0019650459289551
(887) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '525') 0.0004270076751709
(888) DESCRIBE `ports` 0.001863956451416
(889) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1839))) 0.00046491622924805
(890) DESCRIBE `ports` 0.0020501613616943
(891) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1839') 0.00042295455932617
(892) DESCRIBE `ports` 0.0019180774688721
(893) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.00039386749267578
(894) DESCRIBE `ports` 0.0017039775848389
(895) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00040006637573242
(896) DESCRIBE `ports` 0.0020010471343994
(897) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 201))) 0.0004270076751709
(898) DESCRIBE `ports` 0.0018470287322998
(899) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '201') 0.00045108795166016
(900) DESCRIBE `avid_specials` 0.0016560554504395
(901) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 67111 and class = 'Cruise') OR (item_id = 340 AND class = 'Ship') OR (item_id = 18 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.0017368793487549
(902) DESCRIBE `cruiselines` 0.0027740001678467
(903) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 18))) 0.00053882598876953
(904) DESCRIBE `orchid_image` 0.0021259784698486
(905) DESCRIBE `cruiselines` 0.0039010047912598
(906) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '18') 0.00055503845214844
(907) DESCRIBE `cruiselines` 0.0030021667480469
(908) 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', '131', '268', '37', '156', '28', '91', '262', '110', '114', '141', '208', '187', '153', '14', '232', '24', '118', '49', '181', '258', '151', '36', '212', '30', '206', '140', '4', '204', '256', '238', '249', '220', '16', '239', '47', '174', '113', '35', '90', '264', '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', '229', '225', '108', '88', '230', '276', '82', '244', '269', '105', '132', '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,131,268,37,156,28,91,262,110,114,141,208,187,153,14,232,24,118,49,181,258,151,36,212,30,206,140,4,204,256,238,249,220,16,239,47,174,113,35,90,264,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,229,225,108,88,230,276,82,244,269,105,132,275,48,119,240,116,64,266,38,134,224,210') 0.0082828998565674
(909) DESCRIBE `ships` 0.0037620067596436
(910) 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', '37', '38', '28', '34', '378', '31', '393', '726', '817', '1424', '1135', '30', '349', '36', '39', '1012', '780', '1422', '1419', '1423', '1420', '1418', '1421', '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', '207', '797', '1460', '3', '573', '974', '340', '553', '1454', '116', '520', '25', '1372', '1455', '160', '1193', '874', '517', '580', '1021', '1302', '1284', '1471', '390', '1095', '1325', '1402', '253', '285', '4', '332', '748', '43', '66', '1172', '1320', '658', '765', '791', '582', '1323', '434', '1068', '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', '657', '966', '1088', '1108', '1282', '1587', '1672', '163', '348', '652', '1321', '111', '262', '325', '338', '1326', '1327', '333', '451', '1143', '1389', '123', '508', '521', '1579', '1724', '389', '1159', '1243', '1376', '148', '351', '683', '1151', '1526', '314', '483', '1013', '1027', '1214', '1367', '162', '290', '75', '93', '287', '394', '626', '1163', '1318', '1398', '545', '651', '731', '859', '751', '1075', '1344', '1602', '673', '768', '1040', '1137', '1144', '1157', '1343', '98', '291', '335', '716', '743', '852', '1063', '1168', '1413', '149', '152', '610', '818', '884', '968', '1223', '1303', '1345', '1452', '1453', '1604', '1711', '401', '669', '769', '958', '1025', '1043', '1090', '1136', '1233', '1283', '1301', '1373', '1552', '45', '82', '150', '151', '352', '790', '796', '1145', '1241', '1581', '201', '223', '485', '776', '882', '1160', '1717', '59', '108', '467', '503', '1152', '1539', '1738', '324', '341', '639', '905', '988', '1149', '1226', '1448', '266', '1150', '1409', '1449', '1463', '1540', '417', '871', '885', '1253', '1411', '1647', '105', '601', '811', '1458', '1682', '1704', '74', '1026', '1029', '1073', '1188', '1351', '1632', '448', '701', '973', '1055', '1231', '1489', '1505', '954', '986', '1034', '1047', '1366', '1408', '1496', '1609', '1742', '494', '666', '704', '795', '851', '1230', '1362', '1368', '1516', '1740', '205', '208', '738', '888', '996', '1154', '1285', '147', '1049', '1470', '1474', '1580', '1627', '493', '618', '836', '1037', '1224', '1444', '423', '837', '1382', '1417', '1518', '1521', '1176', '1229', '1404', '1407', '1410', '1716', '204', '422', '643', '985', '1196', '1593', '709', '857', '1054', '1138', '1262', '1445', '1486', '1517', '1522', '1619', '671', '672', '717', '972', '1017', '1042', '1051', '1148', '1322', '1352', '1358', '1426', '1713', '1715', '781', '994', '1175', '1714', '479', '480', '663', '938', '1106', '1240', '1254', '1412', '1673', '665', '995', '1514', '1606', '1614', '1684', '17', '499', '574', '821', '1045', '1360', '1361', '1459', '1601', '1011', '1019', '1053', '1134', '1384', '1481', '313', '420', '1028', '1217', '1383', '1501', '1515', '1628', '1676', '453', '749', '937', '982', '1439', '1461', '1645', '1708', '1743', '775', '999', '1052', '1206', '1256', '1615', '1722', '1723', '419', '744', '798', '808', '1631', '1729', '487', '687', '969', '1071', '1189', '1232', '1274', '1293', '1338', '1355', '1035', '1048', '1297', '1679', '1681', '1697', '70')) 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,37,38,28,34,378,31,393,726,817,1424,1135,30,349,36,39,1012,780,1422,1419,1423,1420,1418,1421,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,207,797,1460,3,573,974,340,553,1454,116,520,25,1372,1455,160,1193,874,517,580,1021,1302,1284,1471,390,1095,1325,1402,253,285,4,332,748,43,66,1172,1320,658,765,791,582,1323,434,1068,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,657,966,1088,1108,1282,1587,1672,163,348,652,1321,111,262,325,338,1326,1327,333,451,1143,1389,123,508,521,1579,1724,389,1159,1243,1376,148,351,683,1151,1526,314,483,1013,1027,1214,1367,162,290,75,93,287,394,626,1163,1318,1398,545,651,731,859,751,1075,1344,1602,673,768,1040,1137,1144,1157,1343,98,291,335,716,743,852,1063,1168,1413,149,152,610,818,884,968,1223,1303,1345,1452,1453,1604,1711,401,669,769,958,1025,1043,1090,1136,1233,1283,1301,1373,1552,45,82,150,151,352,790,796,1145,1241,1581,201,223,485,776,882,1160,1717,59,108,467,503,1152,1539,1738,324,341,639,905,988,1149,1226,1448,266,1150,1409,1449,1463,1540,417,871,885,1253,1411,1647,105,601,811,1458,1682,1704,74,1026,1029,1073,1188,1351,1632,448,701,973,1055,1231,1489,1505,954,986,1034,1047,1366,1408,1496,1609,1742,494,666,704,795,851,1230,1362,1368,1516,1740,205,208,738,888,996,1154,1285,147,1049,1470,1474,1580,1627,493,618,836,1037,1224,1444,423,837,1382,1417,1518,1521,1176,1229,1404,1407,1410,1716,204,422,643,985,1196,1593,709,857,1054,1138,1262,1445,1486,1517,1522,1619,671,672,717,972,1017,1042,1051,1148,1322,1352,1358,1426,1713,1715,781,994,1175,1714,479,480,663,938,1106,1240,1254,1412,1673,665,995,1514,1606,1614,1684,17,499,574,821,1045,1360,1361,1459,1601,1011,1019,1053,1134,1384,1481,313,420,1028,1217,1383,1501,1515,1628,1676,453,749,937,982,1439,1461,1645,1708,1743,775,999,1052,1206,1256,1615,1722,1723,419,744,798,808,1631,1729,487,687,969,1071,1189,1232,1274,1293,1338,1355,1035,1048,1297,1679,1681,1697,70') 0.058596849441528
(911) DESCRIBE `cruisetypes` 0.0020890235900879
(912) DESCRIBE `destinations` 0.0025351047515869
(913) 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.0029001235961914