or, enquire about your chosen options

  1. Catch up on Cruising: Latest news in bite size
  2. Catch up on Cruising: Latest news in bite size
  3. Family Cruising – Have you considered it ?
  4. New Azamara Ship to arrive in March 2018
  5. Enhanced amenities for Oceania 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: 813

Total elapsed time: 0.47784042358398

# Query Time
(1) connect 0.00058197975158691
(2) DESCRIBE `cruises` 0.0017468929290771
(3) SELECT `cruises`.* FROM `cruises` WHERE (id IN (66919, 66919, 66914, 49107, 49107, 63047, 49109, 66915, 66917, 66918)) ORDER BY FIND_IN_SET(id, '66919,66919,66914,49107,49107,63047,49109,66915,66917,66918') 0.0014119148254395
(4) DESCRIBE `specials` 0.0026590824127197
(5) SELECT `specials`.* FROM `specials` WHERE (id = '1363122') AND (specials.orchid_available = 1) LIMIT 1 0.00055503845214844
(6) DESCRIBE `specials` 0.0022900104522705
(7) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1363122') 0.00032591819763184
(8) DESCRIBE `ships` 0.0014691352844238
(9) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 225))) 0.00027108192443848
(10) DESCRIBE `ships` 0.0013930797576904
(11) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '225') 0.00022101402282715
(12) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017905235290527
(13) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00016188621520996
(14) DESCRIBE `itineraries` 0.00074505805969238
(15) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66919') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00067806243896484
(16) DESCRIBE `ports` 0.00086593627929688
(17) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00030016899108887
(18) DESCRIBE `ports` 0.0006709098815918
(19) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00019097328186035
(20) DESCRIBE `ports` 0.00067496299743652
(21) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.0002129077911377
(22) DESCRIBE `specialsailingdates` 0.00079083442687988
(23) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1363122') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00084900856018066
(24) DESCRIBE `sailingdates` 0.00077390670776367
(25) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419935))) 0.00023603439331055
(26) DESCRIBE `ports` 0.00075316429138184
(27) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00023198127746582
(28) DESCRIBE `ports` 0.00072193145751953
(29) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00019502639770508
(30) DESCRIBE `ports` 0.0006711483001709
(31) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2023))) 0.00021505355834961
(32) DESCRIBE `ports` 0.00069594383239746
(33) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2023') 0.00020003318786621
(34) DESCRIBE `ports` 0.00073409080505371
(35) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00022101402282715
(36) DESCRIBE `ports` 0.00069499015808105
(37) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00019288063049316
(38) DESCRIBE `ports` 0.00068783760070801
(39) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00024700164794922
(40) DESCRIBE `ports` 0.00068497657775879
(41) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00019001960754395
(42) DESCRIBE `ports` 0.00067710876464844
(43) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00020790100097656
(44) DESCRIBE `ports` 0.00076794624328613
(45) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00019192695617676
(46) DESCRIBE `ports` 0.00068211555480957
(47) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00020384788513184
(48) DESCRIBE `ports` 0.00068211555480957
(49) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00019097328186035
(50) DESCRIBE `ports` 0.00084114074707031
(51) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00020694732666016
(52) DESCRIBE `ports` 0.00068998336791992
(53) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00019502639770508
(54) DESCRIBE `ports` 0.00068807601928711
(55) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00023698806762695
(56) DESCRIBE `ports` 0.00069499015808105
(57) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00019407272338867
(58) DESCRIBE `ports` 0.00068497657775879
(59) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1028))) 0.00021815299987793
(60) DESCRIBE `ports` 0.0007319450378418
(61) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1028') 0.00018882751464844
(62) DESCRIBE `ports` 0.00066685676574707
(63) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.0002140998840332
(64) DESCRIBE `ports` 0.00066304206848145
(65) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00019216537475586
(66) DESCRIBE `ports` 0.00071001052856445
(67) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00022697448730469
(68) DESCRIBE `ports` 0.00076198577880859
(69) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00019192695617676
(70) DESCRIBE `ports` 0.00069308280944824
(71) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00024604797363281
(72) DESCRIBE `ports` 0.00072002410888672
(73) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00018501281738281
(74) DESCRIBE `ports` 0.00066280364990234
(75) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1263))) 0.00020885467529297
(76) DESCRIBE `ports` 0.0006709098815918
(77) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1263') 0.00020194053649902
(78) DESCRIBE `ports` 0.00066804885864258
(79) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.00020694732666016
(80) DESCRIBE `ports` 0.00067305564880371
(81) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.00017499923706055
(82) DESCRIBE `ports` 0.00072503089904785
(83) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00020694732666016
(84) DESCRIBE `ports` 0.00075411796569824
(85) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00017905235290527
(86) DESCRIBE `cruises` 0.0014781951904297
(87) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 66919))) 0.00036406517028809
(88) DESCRIBE `avid_specials` 0.0007328987121582
(89) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1363122 and class = 'Special') OR (item_id = 66919 and class = 'Cruise') OR (item_id = 225 AND class = 'Ship') OR (item_id = 57 AND class = 'CruiseLine') OR (item_id = 7 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.002100944519043
(90) DESCRIBE `cruiselines` 0.0016300678253174
(91) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 57))) 0.00035905838012695
(92) DESCRIBE `orchid_image` 0.0013461112976074
(93) DESCRIBE `cruiselines` 0.0010120868682861
(94) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '57') 0.00023603439331055
(95) DESCRIBE `cruises` 0.0012998580932617
(96) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66919') 0.00025200843811035
(97) DESCRIBE `ships` 0.0014019012451172
(98) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 225))) 0.00028800964355469
(99) DESCRIBE `ships` 0.0018320083618164
(100) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '225') 0.0002448558807373
(101) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00021982192993164
(102) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00020885467529297
(103) DESCRIBE `itineraries` 0.00089001655578613
(104) DESCRIBE `ports` 0.00094103813171387
(105) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00025486946105957
(106) DESCRIBE `ports` 0.00071501731872559
(107) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00022006034851074
(108) DESCRIBE `ports` 0.00070095062255859
(109) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00019502639770508
(110) DESCRIBE `sailingdates` 0.00060796737670898
(111) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66919') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00044393539428711
(112) DESCRIBE `ports` 0.0010771751403809
(113) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00031900405883789
(114) DESCRIBE `ports` 0.00075697898864746
(115) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00026392936706543
(116) DESCRIBE `ports` 0.00068283081054688
(117) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2023))) 0.00020503997802734
(118) DESCRIBE `ports` 0.00069308280944824
(119) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2023') 0.00018715858459473
(120) DESCRIBE `ports` 0.00066494941711426
(121) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00020885467529297
(122) DESCRIBE `ports` 0.00066804885864258
(123) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00018191337585449
(124) DESCRIBE `ports` 0.00068306922912598
(125) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00019717216491699
(126) DESCRIBE `ports` 0.00066113471984863
(127) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00018215179443359
(128) DESCRIBE `ports` 0.00066304206848145
(129) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00023102760314941
(130) DESCRIBE `ports` 0.00067019462585449
(131) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018191337585449
(132) DESCRIBE `ports` 0.0006721019744873
(133) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00019979476928711
(134) DESCRIBE `ports` 0.00067496299743652
(135) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0001990795135498
(136) DESCRIBE `ports` 0.0006709098815918
(137) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00020408630371094
(138) DESCRIBE `ports` 0.00067901611328125
(139) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018215179443359
(140) DESCRIBE `ports` 0.00072193145751953
(141) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.0001981258392334
(142) DESCRIBE `ports` 0.00071382522583008
(143) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018620491027832
(144) DESCRIBE `ports` 0.00066494941711426
(145) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1028))) 0.00021195411682129
(146) DESCRIBE `ports` 0.00069212913513184
(147) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1028') 0.0001978874206543
(148) DESCRIBE `ports` 0.00087904930114746
(149) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00022077560424805
(150) DESCRIBE `ports` 0.00069999694824219
(151) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00019097328186035
(152) DESCRIBE `ports` 0.00072598457336426
(153) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00021195411682129
(154) DESCRIBE `ports` 0.00070881843566895
(155) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00019598007202148
(156) DESCRIBE `ports` 0.00086712837219238
(157) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.0002589225769043
(158) DESCRIBE `ports` 0.00069499015808105
(159) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00019311904907227
(160) DESCRIBE `ports` 0.00070595741271973
(161) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1263))) 0.00021004676818848
(162) DESCRIBE `ports` 0.00090384483337402
(163) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1263') 0.00021100044250488
(164) DESCRIBE `ports` 0.00084996223449707
(165) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.00027799606323242
(166) DESCRIBE `ports` 0.0010249614715576
(167) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.00023484230041504
(168) DESCRIBE `ports` 0.00096797943115234
(169) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00025606155395508
(170) DESCRIBE `ports` 0.0009920597076416
(171) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00023078918457031
(172) DESCRIBE `avid_specials` 0.00086808204650879
(173) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66919 and class = 'Cruise') OR (item_id = 225 AND class = 'Ship') OR (item_id = 57 AND class = 'CruiseLine') OR (item_id = 7 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.0020051002502441
(174) DESCRIBE `cruiselines` 0.0014491081237793
(175) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 57))) 0.0003209114074707
(176) DESCRIBE `orchid_image` 0.0011141300201416
(177) DESCRIBE `cruiselines` 0.001492977142334
(178) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '57') 0.00026392936706543
(179) DESCRIBE `cruises` 0.0019900798797607
(180) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66914') 0.00032687187194824
(181) DESCRIBE `ships` 0.002094030380249
(182) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 225))) 0.00039315223693848
(183) DESCRIBE `ships` 0.0018899440765381
(184) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '225') 0.00022482872009277
(185) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00021600723266602
(186) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017404556274414
(187) DESCRIBE `itineraries` 0.00069785118103027
(188) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66914') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0005040168762207
(189) DESCRIBE `ports` 0.0011367797851562
(190) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00026106834411621
(191) DESCRIBE `ports` 0.00076699256896973
(192) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00020718574523926
(193) DESCRIBE `ports` 0.00078201293945312
(194) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00021696090698242
(195) DESCRIBE `sailingdates` 0.00068092346191406
(196) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66914') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00045108795166016
(197) DESCRIBE `ports` 0.0007481575012207
(198) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00023913383483887
(199) DESCRIBE `ports` 0.00067996978759766
(200) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00018596649169922
(201) DESCRIBE `ports` 0.00067400932312012
(202) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 496))) 0.0002129077911377
(203) DESCRIBE `ports` 0.00069093704223633
(204) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '496') 0.00018501281738281
(205) DESCRIBE `ports` 0.00067996978759766
(206) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00020885467529297
(207) DESCRIBE `ports` 0.00087594985961914
(208) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00020503997802734
(209) DESCRIBE `ports` 0.00070619583129883
(210) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00021481513977051
(211) DESCRIBE `ports` 0.00071406364440918
(212) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00019311904907227
(213) DESCRIBE `ports` 0.00071501731872559
(214) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.0002129077911377
(215) DESCRIBE `ports` 0.00069904327392578
(216) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00019001960754395
(217) DESCRIBE `ports` 0.00077390670776367
(218) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00023388862609863
(219) DESCRIBE `ports` 0.00075101852416992
(220) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00019717216491699
(221) DESCRIBE `ports` 0.00068998336791992
(222) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00023102760314941
(223) DESCRIBE `ports` 0.00077104568481445
(224) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00019502639770508
(225) DESCRIBE `ports` 0.00068187713623047
(226) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00021505355834961
(227) DESCRIBE `ports` 0.0007171630859375
(228) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00019001960754395
(229) DESCRIBE `ports` 0.00067782402038574
(230) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00020599365234375
(231) DESCRIBE `ports` 0.00068092346191406
(232) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0002129077911377
(233) DESCRIBE `ports` 0.0006871223449707
(234) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00021505355834961
(235) DESCRIBE `ports` 0.00068116188049316
(236) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018906593322754
(237) DESCRIBE `ports` 0.00069904327392578
(238) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00025415420532227
(239) DESCRIBE `ports` 0.00069117546081543
(240) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00019097328186035
(241) DESCRIBE `ports` 0.00068283081054688
(242) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00024294853210449
(243) DESCRIBE `ports` 0.00079703330993652
(244) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00019598007202148
(245) DESCRIBE `ports` 0.00067710876464844
(246) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 496))) 0.00020790100097656
(247) DESCRIBE `ports` 0.00069808959960938
(248) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '496') 0.0001988410949707
(249) DESCRIBE `ports` 0.00070691108703613
(250) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00021004676818848
(251) DESCRIBE `ports` 0.00068306922912598
(252) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.0001838207244873
(253) DESCRIBE `avid_specials` 0.00063705444335938
(254) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66914 and class = 'Cruise') OR (item_id = 225 AND class = 'Ship') OR (item_id = 57 AND class = 'CruiseLine') OR (item_id = 7 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.0011229515075684
(255) DESCRIBE `cruiselines` 0.0010309219360352
(256) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 57))) 0.00024700164794922
(257) DESCRIBE `orchid_image` 0.00076699256896973
(258) DESCRIBE `cruiselines` 0.00097203254699707
(259) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '57') 0.00021910667419434
(260) DESCRIBE `specials` 0.0021369457244873
(261) SELECT `specials`.* FROM `specials` WHERE (id = '1363127') AND (specials.orchid_available = 1) LIMIT 1 0.00042605400085449
(262) DESCRIBE `specials` 0.0021090507507324
(263) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1363127') 0.00025486946105957
(264) DESCRIBE `ships` 0.0014019012451172
(265) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 225))) 0.00027608871459961
(266) DESCRIBE `ships` 0.0013158321380615
(267) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '225') 0.00020599365234375
(268) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0001838207244873
(269) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017499923706055
(270) DESCRIBE `itineraries` 0.00070285797119141
(271) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '49107') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.0005490779876709
(272) DESCRIBE `ports` 0.00078392028808594
(273) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00022578239440918
(274) DESCRIBE `ports` 0.00068998336791992
(275) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.0001990795135498
(276) DESCRIBE `ports` 0.00073599815368652
(277) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00019216537475586
(278) DESCRIBE `specialsailingdates` 0.00057101249694824
(279) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1363127') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00050806999206543
(280) DESCRIBE `sailingdates` 0.00067615509033203
(281) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 395148))) 0.00021886825561523
(282) DESCRIBE `ports` 0.0007319450378418
(283) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00024914741516113
(284) DESCRIBE `ports` 0.00071096420288086
(285) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00019192695617676
(286) DESCRIBE `ports` 0.00067496299743652
(287) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00020599365234375
(288) DESCRIBE `ports` 0.00069403648376465
(289) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00020003318786621
(290) DESCRIBE `ports` 0.00069189071655273
(291) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00020408630371094
(292) DESCRIBE `ports` 0.00069689750671387
(293) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00019001960754395
(294) DESCRIBE `ports` 0.00070405006408691
(295) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00020503997802734
(296) DESCRIBE `ports` 0.0006871223449707
(297) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018501281738281
(298) DESCRIBE `ports` 0.00069999694824219
(299) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00022006034851074
(300) DESCRIBE `ports` 0.00069808959960938
(301) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0001838207244873
(302) DESCRIBE `ports` 0.00067996978759766
(303) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00023484230041504
(304) DESCRIBE `ports` 0.000701904296875
(305) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018501281738281
(306) DESCRIBE `ports` 0.00068521499633789
(307) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00021100044250488
(308) DESCRIBE `ports` 0.00070309638977051
(309) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018310546875
(310) DESCRIBE `ports` 0.0007328987121582
(311) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1028))) 0.00021195411682129
(312) DESCRIBE `ports` 0.00068092346191406
(313) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1028') 0.00021791458129883
(314) DESCRIBE `ports` 0.00067400932312012
(315) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00021505355834961
(316) DESCRIBE `ports` 0.00077605247497559
(317) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00021100044250488
(318) DESCRIBE `ports` 0.00071215629577637
(319) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00021219253540039
(320) DESCRIBE `ports` 0.00072312355041504
(321) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00019288063049316
(322) DESCRIBE `ports` 0.00068807601928711
(323) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00024509429931641
(324) DESCRIBE `ports` 0.00070309638977051
(325) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00018882751464844
(326) DESCRIBE `ports` 0.00067901611328125
(327) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1263))) 0.00020098686218262
(328) DESCRIBE `ports` 0.00071215629577637
(329) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1263') 0.00018310546875
(330) DESCRIBE `ports` 0.00076508522033691
(331) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.0001981258392334
(332) DESCRIBE `ports` 0.00091195106506348
(333) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.00019502639770508
(334) DESCRIBE `ports` 0.00091099739074707
(335) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4186))) 0.00023698806762695
(336) DESCRIBE `ports` 0.00069880485534668
(337) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4186') 0.00020289421081543
(338) DESCRIBE `cruises` 0.0014219284057617
(339) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 49107))) 0.00031304359436035
(340) DESCRIBE `avid_specials` 0.00069403648376465
(341) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1363127 and class = 'Special') OR (item_id = 49107 and class = 'Cruise') OR (item_id = 225 AND class = 'Ship') OR (item_id = 57 AND class = 'CruiseLine') OR (item_id = 7 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.0011410713195801
(342) DESCRIBE `cruiselines` 0.00098896026611328
(343) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 57))) 0.00027799606323242
(344) DESCRIBE `orchid_image` 0.00079107284545898
(345) DESCRIBE `cruiselines` 0.0012550354003906
(346) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '57') 0.00025606155395508
(347) DESCRIBE `cruises` 0.0017740726470947
(348) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '49107') 0.00025486946105957
(349) DESCRIBE `ships` 0.0013480186462402
(350) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 225))) 0.0003669261932373
(351) DESCRIBE `ships` 0.0021798610687256
(352) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '225') 0.0002901554107666
(353) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00023317337036133
(354) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00023007392883301
(355) DESCRIBE `itineraries` 0.0010950565338135
(356) DESCRIBE `ports` 0.0012650489807129
(357) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00034689903259277
(358) DESCRIBE `ports` 0.0010368824005127
(359) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00025200843811035
(360) DESCRIBE `ports` 0.0010478496551514
(361) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00025701522827148
(362) DESCRIBE `sailingdates` 0.00078010559082031
(363) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '49107') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00045990943908691
(364) DESCRIBE `ports` 0.00075006484985352
(365) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00021791458129883
(366) DESCRIBE `ports` 0.00070691108703613
(367) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00018692016601562
(368) DESCRIBE `ports` 0.0006868839263916
(369) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00021195411682129
(370) DESCRIBE `ports` 0.00070095062255859
(371) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00019288063049316
(372) DESCRIBE `ports` 0.0007178783416748
(373) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.0001988410949707
(374) DESCRIBE `ports` 0.00068283081054688
(375) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00018906593322754
(376) DESCRIBE `ports` 0.00071501731872559
(377) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00022006034851074
(378) DESCRIBE `ports` 0.00068497657775879
(379) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018715858459473
(380) DESCRIBE `ports` 0.00071215629577637
(381) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00023007392883301
(382) DESCRIBE `ports` 0.00072002410888672
(383) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018906593322754
(384) DESCRIBE `ports` 0.00068211555480957
(385) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.0002140998840332
(386) DESCRIBE `ports` 0.00069689750671387
(387) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018596649169922
(388) DESCRIBE `ports` 0.00072193145751953
(389) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00020313262939453
(390) DESCRIBE `ports` 0.00081300735473633
(391) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00020098686218262
(392) DESCRIBE `ports` 0.00070500373840332
(393) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1028))) 0.00020599365234375
(394) DESCRIBE `ports` 0.00068402290344238
(395) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1028') 0.00018501281738281
(396) DESCRIBE `ports` 0.00070095062255859
(397) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00021600723266602
(398) DESCRIBE `ports` 0.00072097778320312
(399) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00018906593322754
(400) DESCRIBE `ports` 0.00069713592529297
(401) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.0002138614654541
(402) DESCRIBE `ports` 0.00071001052856445
(403) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00019001960754395
(404) DESCRIBE `ports` 0.00067806243896484
(405) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00024914741516113
(406) DESCRIBE `ports` 0.00078415870666504
(407) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00019311904907227
(408) DESCRIBE `ports` 0.00068783760070801
(409) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1263))) 0.00020194053649902
(410) DESCRIBE `ports` 0.00071907043457031
(411) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1263') 0.00019407272338867
(412) DESCRIBE `ports` 0.00070285797119141
(413) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.00020694732666016
(414) DESCRIBE `ports` 0.00075793266296387
(415) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.00023508071899414
(416) DESCRIBE `ports` 0.00099396705627441
(417) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 4186))) 0.00029182434082031
(418) DESCRIBE `ports` 0.0010280609130859
(419) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '4186') 0.0002589225769043
(420) DESCRIBE `avid_specials` 0.00068402290344238
(421) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 49107 and class = 'Cruise') OR (item_id = 225 AND class = 'Ship') OR (item_id = 57 AND class = 'CruiseLine') OR (item_id = 7 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.0012240409851074
(422) DESCRIBE `cruiselines` 0.0010590553283691
(423) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 57))) 0.000244140625
(424) DESCRIBE `orchid_image` 0.00094509124755859
(425) DESCRIBE `cruiselines` 0.0010349750518799
(426) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '57') 0.00023913383483887
(427) DESCRIBE `cruises` 0.0014088153839111
(428) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '63047') 0.00025510787963867
(429) DESCRIBE `ships` 0.0014050006866455
(430) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 225))) 0.00028610229492188
(431) DESCRIBE `ships` 0.0013349056243896
(432) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '225') 0.00021696090698242
(433) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018310546875
(434) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017309188842773
(435) DESCRIBE `itineraries` 0.00071597099304199
(436) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '63047') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00051188468933105
(437) DESCRIBE `ports` 0.0008089542388916
(438) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00023579597473145
(439) DESCRIBE `ports` 0.00070714950561523
(440) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00021886825561523
(441) DESCRIBE `ports` 0.00068402290344238
(442) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00019478797912598
(443) DESCRIBE `sailingdates` 0.00060915946960449
(444) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '63047') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00042295455932617
(445) DESCRIBE `ports` 0.00074601173400879
(446) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00022721290588379
(447) DESCRIBE `ports` 0.00072908401489258
(448) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00019192695617676
(449) DESCRIBE `ports` 0.00069499015808105
(450) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1737))) 0.00020194053649902
(451) DESCRIBE `ports` 0.00068283081054688
(452) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1737') 0.00018215179443359
(453) DESCRIBE `ports` 0.000701904296875
(454) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1263))) 0.00022101402282715
(455) DESCRIBE `ports` 0.00073099136352539
(456) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1263') 0.00019097328186035
(457) DESCRIBE `ports` 0.00071907043457031
(458) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00023198127746582
(459) DESCRIBE `ports` 0.00069308280944824
(460) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.0001981258392334
(461) DESCRIBE `ports` 0.00070285797119141
(462) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00022602081298828
(463) DESCRIBE `ports` 0.00070309638977051
(464) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00019121170043945
(465) DESCRIBE `ports` 0.000701904296875
(466) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1745))) 0.00021505355834961
(467) DESCRIBE `ports` 0.00071406364440918
(468) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1745') 0.00021481513977051
(469) DESCRIBE `ports` 0.00068807601928711
(470) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1028))) 0.0002138614654541
(471) DESCRIBE `ports` 0.00070500373840332
(472) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1028') 0.00019097328186035
(473) DESCRIBE `ports` 0.00070285797119141
(474) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00020599365234375
(475) DESCRIBE `ports` 0.00071501731872559
(476) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018477439880371
(477) DESCRIBE `ports` 0.00068998336791992
(478) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00023102760314941
(479) DESCRIBE `ports` 0.00071191787719727
(480) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018501281738281
(481) DESCRIBE `ports` 0.00068902969360352
(482) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00021004676818848
(483) DESCRIBE `ports` 0.00070405006408691
(484) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018596649169922
(485) DESCRIBE `ports` 0.00067996978759766
(486) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00020599365234375
(487) DESCRIBE `ports` 0.00069785118103027
(488) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00022506713867188
(489) DESCRIBE `ports` 0.00068092346191406
(490) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00020480155944824
(491) DESCRIBE `ports` 0.00069904327392578
(492) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00020098686218262
(493) DESCRIBE `ports` 0.00070786476135254
(494) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00020790100097656
(495) DESCRIBE `ports` 0.00070285797119141
(496) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00018692016601562
(497) DESCRIBE `ports` 0.00071096420288086
(498) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00021195411682129
(499) DESCRIBE `ports` 0.00069808959960938
(500) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00018095970153809
(501) DESCRIBE `avid_specials` 0.00062108039855957
(502) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 63047 and class = 'Cruise') OR (item_id = 225 AND class = 'Ship') OR (item_id = 57 AND class = 'CruiseLine') OR (item_id = 7 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.0011730194091797
(503) DESCRIBE `cruiselines` 0.00099396705627441
(504) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 57))) 0.00029802322387695
(505) DESCRIBE `orchid_image` 0.00089192390441895
(506) DESCRIBE `cruiselines` 0.0010631084442139
(507) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '57') 0.00024223327636719
(508) DESCRIBE `cruises` 0.0013711452484131
(509) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '49109') 0.00023508071899414
(510) DESCRIBE `ships` 0.0014088153839111
(511) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 225))) 0.00029492378234863
(512) DESCRIBE `ships` 0.0013730525970459
(513) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '225') 0.00020313262939453
(514) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018405914306641
(515) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00019383430480957
(516) DESCRIBE `itineraries` 0.00069284439086914
(517) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '49109') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00041604042053223
(518) DESCRIBE `ports` 0.00075006484985352
(519) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00023293495178223
(520) DESCRIBE `ports` 0.00073909759521484
(521) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00020408630371094
(522) DESCRIBE `ports` 0.00071597099304199
(523) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00024890899658203
(524) DESCRIBE `sailingdates` 0.00069904327392578
(525) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '49109') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00046801567077637
(526) DESCRIBE `ports` 0.00076389312744141
(527) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00023293495178223
(528) DESCRIBE `ports` 0.00072503089904785
(529) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00020503997802734
(530) DESCRIBE `ports` 0.00079607963562012
(531) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 496))) 0.00022792816162109
(532) DESCRIBE `ports` 0.00071811676025391
(533) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '496') 0.00020003318786621
(534) DESCRIBE `ports` 0.00069499015808105
(535) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00021600723266602
(536) DESCRIBE `ports` 0.00069308280944824
(537) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00024008750915527
(538) DESCRIBE `ports` 0.00069093704223633
(539) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2804))) 0.00021100044250488
(540) DESCRIBE `ports` 0.00092005729675293
(541) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2804') 0.00022101402282715
(542) DESCRIBE `ports` 0.00092101097106934
(543) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00026106834411621
(544) DESCRIBE `ports` 0.0009148120880127
(545) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00025200843811035
(546) DESCRIBE `ports` 0.00089597702026367
(547) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00026702880859375
(548) DESCRIBE `ports` 0.00087904930114746
(549) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00022387504577637
(550) DESCRIBE `ports` 0.00069785118103027
(551) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00023388862609863
(552) DESCRIBE `ports` 0.00070881843566895
(553) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0001988410949707
(554) DESCRIBE `ports` 0.00071191787719727
(555) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.0002129077911377
(556) DESCRIBE `ports` 0.00069117546081543
(557) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018811225891113
(558) DESCRIBE `ports` 0.00069308280944824
(559) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.0002291202545166
(560) DESCRIBE `ports` 0.00070786476135254
(561) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00025391578674316
(562) DESCRIBE `ports` 0.00072097778320312
(563) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00022196769714355
(564) DESCRIBE `ports` 0.0007319450378418
(565) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00019598007202148
(566) DESCRIBE `ports` 0.00067996978759766
(567) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2927))) 0.0002131462097168
(568) DESCRIBE `ports` 0.00070285797119141
(569) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2927') 0.00019097328186035
(570) DESCRIBE `ports` 0.00088596343994141
(571) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00021815299987793
(572) DESCRIBE `ports` 0.00071191787719727
(573) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00019001960754395
(574) DESCRIBE `ports` 0.00070905685424805
(575) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.0002140998840332
(576) DESCRIBE `ports` 0.00070500373840332
(577) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00020003318786621
(578) DESCRIBE `avid_specials` 0.00075411796569824
(579) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 49109 and class = 'Cruise') OR (item_id = 225 AND class = 'Ship') OR (item_id = 57 AND class = 'CruiseLine') OR (item_id = 7 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.0013608932495117
(580) DESCRIBE `cruiselines` 0.0011699199676514
(581) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 57))) 0.00029110908508301
(582) DESCRIBE `orchid_image` 0.00084900856018066
(583) DESCRIBE `cruiselines` 0.0011579990386963
(584) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '57') 0.00023508071899414
(585) DESCRIBE `cruises` 0.0014851093292236
(586) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66915') 0.00023984909057617
(587) DESCRIBE `ships` 0.0013289451599121
(588) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 225))) 0.00030899047851562
(589) DESCRIBE `ships` 0.0013539791107178
(590) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '225') 0.00020313262939453
(591) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00018310546875
(592) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017499923706055
(593) DESCRIBE `itineraries` 0.00075292587280273
(594) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66915') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00041413307189941
(595) DESCRIBE `ports` 0.00082492828369141
(596) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00024604797363281
(597) DESCRIBE `ports` 0.00068902969360352
(598) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00021004676818848
(599) DESCRIBE `ports` 0.00070905685424805
(600) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00020003318786621
(601) DESCRIBE `sailingdates` 0.00069284439086914
(602) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66915') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00044608116149902
(603) DESCRIBE `ports` 0.00075101852416992
(604) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00023412704467773
(605) DESCRIBE `ports` 0.00068402290344238
(606) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00020909309387207
(607) DESCRIBE `ports` 0.00069808959960938
(608) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00021100044250488
(609) DESCRIBE `ports` 0.00071907043457031
(610) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00019192695617676
(611) DESCRIBE `ports` 0.00069093704223633
(612) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2927))) 0.00021791458129883
(613) DESCRIBE `ports` 0.00081992149353027
(614) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2927') 0.00021195411682129
(615) DESCRIBE `ports` 0.00081682205200195
(616) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00024580955505371
(617) DESCRIBE `ports` 0.00079894065856934
(618) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00021982192993164
(619) DESCRIBE `ports` 0.00078606605529785
(620) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00025510787963867
(621) DESCRIBE `ports` 0.00079917907714844
(622) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00020599365234375
(623) DESCRIBE `ports` 0.00082087516784668
(624) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00033807754516602
(625) DESCRIBE `ports` 0.000762939453125
(626) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00025010108947754
(627) DESCRIBE `ports` 0.00069999694824219
(628) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00021481513977051
(629) DESCRIBE `ports` 0.00074005126953125
(630) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00020289421081543
(631) DESCRIBE `ports` 0.00070905685424805
(632) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00021791458129883
(633) DESCRIBE `ports` 0.00074005126953125
(634) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.0001990795135498
(635) DESCRIBE `ports` 0.00069999694824219
(636) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00022411346435547
(637) DESCRIBE `ports` 0.0010008811950684
(638) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00022196769714355
(639) DESCRIBE `ports` 0.00071096420288086
(640) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2804))) 0.00021815299987793
(641) DESCRIBE `ports` 0.00073003768920898
(642) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2804') 0.00019311904907227
(643) DESCRIBE `ports` 0.00074911117553711
(644) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00026202201843262
(645) DESCRIBE `ports` 0.00070381164550781
(646) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00019383430480957
(647) DESCRIBE `ports` 0.00067996978759766
(648) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2023))) 0.00022077560424805
(649) DESCRIBE `ports` 0.00069904327392578
(650) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2023') 0.00018906593322754
(651) DESCRIBE `ports` 0.0006868839263916
(652) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00024890899658203
(653) DESCRIBE `ports` 0.00073099136352539
(654) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00019311904907227
(655) DESCRIBE `avid_specials` 0.00061202049255371
(656) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66915 and class = 'Cruise') OR (item_id = 225 AND class = 'Ship') OR (item_id = 57 AND class = 'CruiseLine') OR (item_id = 7 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.00111985206604
(657) DESCRIBE `cruiselines` 0.0010108947753906
(658) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 57))) 0.00023508071899414
(659) DESCRIBE `orchid_image` 0.00077414512634277
(660) DESCRIBE `cruiselines` 0.00098204612731934
(661) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '57') 0.00021886825561523
(662) DESCRIBE `cruises` 0.001370906829834
(663) SELECT `cruises`.`orchid_slug` FROM `cruises` WHERE (id = '66917') 0.00024700164794922
(664) DESCRIBE `ships` 0.0013940334320068
(665) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 225))) 0.00027298927307129
(666) DESCRIBE `ships` 0.0013549327850342
(667) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '225') 0.00020694732666016
(668) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00020599365234375
(669) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00017499923706055
(670) DESCRIBE `itineraries` 0.00070309638977051
(671) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66917') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00040888786315918
(672) DESCRIBE `ports` 0.0011341571807861
(673) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.0002741813659668
(674) DESCRIBE `ports` 0.00069808959960938
(675) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00021195411682129
(676) DESCRIBE `ports` 0.00069403648376465
(677) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.0001978874206543
(678) DESCRIBE `sailingdates` 0.0006110668182373
(679) SELECT `sailingdates`.* FROM `sailingdates` WHERE (cruise_id = '66917') AND (sailingdate >= CURDATE()) ORDER BY `sailingdate` ASC 0.00043606758117676
(680) DESCRIBE `ports` 0.00075602531433105
(681) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00021982192993164
(682) DESCRIBE `ports` 0.00068306922912598
(683) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.0002129077911377
(684) DESCRIBE `ports` 0.00067996978759766
(685) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2023))) 0.00024104118347168
(686) DESCRIBE `ports` 0.00067687034606934
(687) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2023') 0.00018596649169922
(688) DESCRIBE `ports` 0.00066900253295898
(689) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 496))) 0.00024509429931641
(690) DESCRIBE `ports` 0.00071096420288086
(691) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '496') 0.00018501281738281
(692) DESCRIBE `ports` 0.00066590309143066
(693) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00020909309387207
(694) DESCRIBE `ports` 0.00076699256896973
(695) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00024008750915527
(696) DESCRIBE `ports` 0.00071096420288086
(697) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00023889541625977
(698) DESCRIBE `ports` 0.00068998336791992
(699) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00018596649169922
(700) DESCRIBE `ports` 0.00071501731872559
(701) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00021195411682129
(702) DESCRIBE `ports` 0.00069403648376465
(703) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00018596649169922
(704) DESCRIBE `ports` 0.00067496299743652
(705) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 163))) 0.00021100044250488
(706) DESCRIBE `ports` 0.0009310245513916
(707) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '163') 0.00019192695617676
(708) DESCRIBE `ports` 0.00078892707824707
(709) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 320))) 0.00020813941955566
(710) DESCRIBE `ports` 0.00074291229248047
(711) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '320') 0.00019097328186035
(712) DESCRIBE `ports` 0.00067806243896484
(713) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2927))) 0.0002138614654541
(714) DESCRIBE `ports` 0.00074005126953125
(715) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2927') 0.00018787384033203
(716) DESCRIBE `ports` 0.00069594383239746
(717) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00023508071899414
(718) DESCRIBE `ports` 0.00083684921264648
(719) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00020503997802734
(720) DESCRIBE `ports` 0.00078296661376953
(721) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00022006034851074
(722) DESCRIBE `ports` 0.00067710876464844
(723) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00019288063049316
(724) DESCRIBE `avid_specials` 0.00064492225646973
(725) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 66917 and class = 'Cruise') OR (item_id = 225 AND class = 'Ship') OR (item_id = 57 AND class = 'CruiseLine') OR (item_id = 7 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.0011239051818848
(726) DESCRIBE `cruiselines` 0.0010340213775635
(727) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 57))) 0.00029492378234863
(728) DESCRIBE `orchid_image` 0.00078082084655762
(729) DESCRIBE `cruiselines` 0.0010080337524414
(730) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '57') 0.0002448558807373
(731) DESCRIBE `specials` 0.0020930767059326
(732) SELECT `specials`.* FROM `specials` WHERE (id = '1363130') AND (specials.orchid_available = 1) LIMIT 1 0.00060701370239258
(733) DESCRIBE `specials` 0.0025618076324463
(734) SELECT `specials`.`orchid_slug` FROM `specials` WHERE (id = '1363130') 0.00027894973754883
(735) DESCRIBE `ships` 0.0016231536865234
(736) SELECT `ships`.* FROM `ships` WHERE (((`ships`.`id` = 225))) 0.00033211708068848
(737) DESCRIBE `ships` 0.0019221305847168
(738) SELECT `ships`.`orchid_slug` FROM `ships` WHERE (id = '225') 0.00022983551025391
(739) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.00020885467529297
(740) SELECT `starrating`.`rating`, `starrating`.`orchid_image` FROM `starrating` WHERE (id = '2') 0.0001978874206543
(741) DESCRIBE `itineraries` 0.00080299377441406
(742) SELECT `itineraries`.* FROM `itineraries` WHERE (cruise_id = '66918') ORDER BY `day` ASC, `itineraries`.`portorder` ASC 0.00046205520629883
(743) DESCRIBE `ports` 0.00085902214050293
(744) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.0002739429473877
(745) DESCRIBE `ports` 0.00078701972961426
(746) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00022602081298828
(747) DESCRIBE `ports` 0.00088000297546387
(748) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00042390823364258
(749) DESCRIBE `specialsailingdates` 0.0010130405426025
(750) SELECT DISTINCT `specialsailingdates`.* FROM `specialsailingdates` INNER JOIN `sailingdates` ON specialsailingdates.sailingdate_id = sailingdates.id WHERE (specialsailingdates.special_id = '1363130') AND (sailingdates.sailingdate >= NOW()) ORDER BY `sailingdates`.`sailingdate` ASC 0.00056910514831543
(751) DESCRIBE `sailingdates` 0.00069713592529297
(752) SELECT `sailingdates`.* FROM `sailingdates` WHERE (((`sailingdates`.`id` = 419934))) 0.00021505355834961
(753) DESCRIBE `ports` 0.0007939338684082
(754) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00029802322387695
(755) DESCRIBE `ports` 0.0010499954223633
(756) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00027084350585938
(757) DESCRIBE `ports` 0.0010030269622803
(758) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 326))) 0.00029206275939941
(759) DESCRIBE `ports` 0.00099802017211914
(760) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '326') 0.00025296211242676
(761) DESCRIBE `ports` 0.00099301338195801
(762) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 2927))) 0.00022315979003906
(763) DESCRIBE `ports` 0.00069689750671387
(764) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '2927') 0.00019097328186035
(765) DESCRIBE `ports` 0.00069499015808105
(766) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 320))) 0.0002129077911377
(767) DESCRIBE `ports` 0.00068092346191406
(768) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '320') 0.00018596649169922
(769) DESCRIBE `ports` 0.00099301338195801
(770) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 163))) 0.00029802322387695
(771) DESCRIBE `ports` 0.0010159015655518
(772) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '163') 0.00026988983154297
(773) DESCRIBE `ports` 0.0010001659393311
(774) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 161))) 0.00029897689819336
(775) DESCRIBE `ports` 0.0010111331939697
(776) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '161') 0.00023221969604492
(777) DESCRIBE `ports` 0.00070714950561523
(778) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00021004676818848
(779) DESCRIBE `ports` 0.0006868839263916
(780) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00020599365234375
(781) DESCRIBE `ports` 0.00073099136352539
(782) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 1258))) 0.00020909309387207
(783) DESCRIBE `ports` 0.0010430812835693
(784) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '1258') 0.00034022331237793
(785) DESCRIBE `ports` 0.00086498260498047
(786) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 496))) 0.00022101402282715
(787) DESCRIBE `ports` 0.00069403648376465
(788) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '496') 0.00019097328186035
(789) DESCRIBE `ports` 0.00069594383239746
(790) SELECT `ports`.* FROM `ports` WHERE (((`ports`.`id` = 158))) 0.00025486946105957
(791) DESCRIBE `ports` 0.00068902969360352
(792) SELECT `ports`.`orchid_slug` FROM `ports` WHERE (id = '158') 0.00019001960754395
(793) DESCRIBE `cruises` 0.0013241767883301
(794) SELECT `cruises`.* FROM `cruises` WHERE (((`cruises`.`id` = 66918))) 0.00031781196594238
(795) DESCRIBE `avid_specials` 0.00065898895263672
(796) SELECT `avid_specials`.* FROM `avid_specials` LEFT JOIN `avid_specials_links` ON avid_specials.id = avid_specials_links.special_id WHERE (((item_id = 1363130 and class = 'Special') OR (item_id = 66918 and class = 'Cruise') OR (item_id = 225 AND class = 'Ship') OR (item_id = 57 AND class = 'CruiseLine') OR (item_id = 7 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.0010969638824463
(797) DESCRIBE `cruiselines` 0.0010051727294922
(798) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 57))) 0.0002439022064209
(799) DESCRIBE `orchid_image` 0.00076007843017578
(800) DESCRIBE `cruiselines` 0.0009758472442627
(801) SELECT `cruiselines`.`orchid_slug` FROM `cruiselines` WHERE (id = '57') 0.00020480155944824
(802) DESCRIBE `ships` 0.0015220642089844
(803) SELECT `ships`.* FROM `ships` WHERE (id IN ('225')) ORDER BY FIND_IN_SET(id, '225') 0.00031089782714844
(804) DESCRIBE `cruisetypes` 0.0006108283996582
(805) SELECT DISTINCT `cruisetypes`.* FROM `cruisetypes` LEFT JOIN `cruises_and_specials` ON cruisetypes.id = cruises_and_specials.cruisetype_id WHERE (cruises_and_specials.destination_id = '7') AND (cruises_and_specials.cruiseline_id = '57') AND (cruises_and_specials.orchid_available = 1) AND (cruisetypes.orchid_available = 1) ORDER BY `name` ASC 0.023707151412964
(806) DESCRIBE `cruiselines` 0.0014848709106445
(807) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 57))) 0.00028300285339355
(808) DESCRIBE `destinations` 0.00093317031860352
(809) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 7))) 0.00023889541625977
(810) DESCRIBE `destinations` 0.001082181930542
(811) SELECT `destinations`.* FROM `destinations` WHERE (((`destinations`.`id` = 7))) 0.00032806396484375
(812) DESCRIBE `cruiselines` 0.0010750293731689
(813) SELECT `cruiselines`.* FROM `cruiselines` WHERE (((`cruiselines`.`id` = 57))) 0.00023007392883301