SELECT [t0].[a_id], [t0].[a_site], [t0].[a_model], [t0].[a_type], [t0].[a_special], [t0].[a_name], [t0].[a_from], [t0].[a_from_url], [t0].[a_author], [t0].[a_editor], [t0].[a_describe], [t0].[a_content], [t0].[a_create_date], [t0].[a_tag], [t0].[a_hits], [t0].[a_commend], [t0].[a_istop], [t0].[a_isimg], [t0].[a_cacheimg], [t0].[a_imgurls], [t0].[a_imgurl], [t0].[a_ismedia], [t0].[a_mediaurl], [t0].[a_iscomment], [t0].[a_isRecycle], [t0].[a_weight], [t0].[a_weights], [t0].[a_status], [t0].[a_url], [t0].[a_file_path], [t0].[a_contentfile], [t0].[a_comment], [t0].[a_ispass], [t0].[a_bury], [t0].[a_dig], [t0].[a_score], [t0].[a_rank], [t0].[a_diguser], [t0].[a_buryuser], [t0].[a_viewip], [t0].[a_lastviewdate], [t0].[a_neworimageorvideo], [t0].[class_id], [t0].[class_type], [t0].[class_name], [t0].[class_show_name], [t0].[class_parent_id], [t0].[class_id_path], [t0].[class_name_path], [t0].[class_show_name_path], [t0].[class_depth], [t0].[class_order], [t0].[class_content], [t0].[class_img], [t0].[a_model_name]
FROM [dbo].[mvc_content_view] AS [t0]
WHERE ([t0].[a_id] = @p0) AND ([t0].[a_type] = @p1)
-- @p0: Input BigInt (Size = 0; Prec = 0; Scale = 0) [4501]
-- @p1: Input BigInt (Size = 0; Prec = 0; Scale = 0) [236]
-- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.1
SELECT TOP (1) [t0].[a_id], [t0].[a_site], [t0].[a_model], [t0].[a_type], [t0].[a_special], [t0].[a_name], [t0].[a_from], [t0].[a_from_url], [t0].[a_author], [t0].[a_editor], [t0].[a_describe], [t0].[a_content], [t0].[a_create_date], [t0].[a_tag], [t0].[a_hits], [t0].[a_commend], [t0].[a_istop], [t0].[a_isimg], [t0].[a_cacheimg], [t0].[a_imgurls], [t0].[a_imgurl], [t0].[a_ismedia], [t0].[a_mediaurl], [t0].[a_iscomment], [t0].[a_isRecycle], [t0].[a_weight], [t0].[a_weights], [t0].[a_status], [t0].[a_url], [t0].[a_file_path], [t0].[a_contentfile], [t0].[a_comment], [t0].[a_ispass], [t0].[a_bury], [t0].[a_dig], [t0].[a_score], [t0].[a_rank], [t0].[a_diguser], [t0].[a_buryuser], [t0].[a_viewip], [t0].[a_lastviewdate], [t0].[a_neworimageorvideo], [t0].[class_id], [t0].[class_type], [t0].[class_name], [t0].[class_show_name], [t0].[class_parent_id], [t0].[class_id_path], [t0].[class_name_path], [t0].[class_show_name_path], [t0].[class_depth], [t0].[class_order], [t0].[class_content], [t0].[class_img], [t0].[a_model_name]
FROM [dbo].[mvc_content_view] AS [t0]
WHERE ([t0].[a_type] = @p0) AND ([t0].[a_id] < @p1)
ORDER BY [t0].[a_id] DESC
-- @p0: Input BigInt (Size = 0; Prec = 0; Scale = 0) [236]
-- @p1: Input BigInt (Size = 0; Prec = 0; Scale = 0) [4501]
-- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.1
SELECT TOP (1) [t0].[a_id], [t0].[a_site], [t0].[a_model], [t0].[a_type], [t0].[a_special], [t0].[a_name], [t0].[a_from], [t0].[a_from_url], [t0].[a_author], [t0].[a_editor], [t0].[a_describe], [t0].[a_content], [t0].[a_create_date], [t0].[a_tag], [t0].[a_hits], [t0].[a_commend], [t0].[a_istop], [t0].[a_isimg], [t0].[a_cacheimg], [t0].[a_imgurls], [t0].[a_imgurl], [t0].[a_ismedia], [t0].[a_mediaurl], [t0].[a_iscomment], [t0].[a_isRecycle], [t0].[a_weight], [t0].[a_weights], [t0].[a_status], [t0].[a_url], [t0].[a_file_path], [t0].[a_contentfile], [t0].[a_comment], [t0].[a_ispass], [t0].[a_bury], [t0].[a_dig], [t0].[a_score], [t0].[a_rank], [t0].[a_diguser], [t0].[a_buryuser], [t0].[a_viewip], [t0].[a_lastviewdate], [t0].[a_neworimageorvideo], [t0].[class_id], [t0].[class_type], [t0].[class_name], [t0].[class_show_name], [t0].[class_parent_id], [t0].[class_id_path], [t0].[class_name_path], [t0].[class_show_name_path], [t0].[class_depth], [t0].[class_order], [t0].[class_content], [t0].[class_img], [t0].[a_model_name]
FROM [dbo].[mvc_content_view] AS [t0]
WHERE ([t0].[a_type] = @p0) AND ([t0].[a_id] > @p1)
ORDER BY [t0].[a_id]
-- @p0: Input BigInt (Size = 0; Prec = 0; Scale = 0) [236]
-- @p1: Input BigInt (Size = 0; Prec = 0; Scale = 0) [4501]
-- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.1
SELECT [t0].[a_id], [t0].[a_site], [t0].[a_model], [t0].[a_type], [t0].[a_special], [t0].[a_name], [t0].[a_from], [t0].[a_from_url], [t0].[a_author], [t0].[a_editor], [t0].[a_describe], [t0].[a_content], [t0].[a_create_date], [t0].[a_tag], [t0].[a_hits], [t0].[a_commend], [t0].[a_istop], [t0].[a_isimg], [t0].[a_cacheimg], [t0].[a_imgurls], [t0].[a_imgurl], [t0].[a_ismedia], [t0].[a_mediaurl], [t0].[a_iscomment], [t0].[a_isRecycle], [t0].[a_weight], [t0].[a_weights], [t0].[a_status], [t0].[a_url], [t0].[a_file_path], [t0].[a_contentfile], [t0].[a_comment], [t0].[a_ispass], [t0].[a_bury], [t0].[a_dig], [t0].[a_score], [t0].[a_rank], [t0].[a_diguser], [t0].[a_buryuser], [t0].[a_viewip], [t0].[a_lastviewdate], [t0].[a_neworimageorvideo]
FROM [dbo].[mvc_content] AS [t0]
WHERE ([t0].[a_id] = @p0) AND ([t0].[a_type] = @p1)
-- @p0: Input BigInt (Size = 0; Prec = 0; Scale = 0) [4501]
-- @p1: Input BigInt (Size = 0; Prec = 0; Scale = 0) [236]
-- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.1
UPDATE [dbo].[mvc_content]
SET [a_hits] = @p19
WHERE ([a_id] = @p0) AND ([a_site] = @p1) AND ([a_model] = @p2) AND ([a_type] = @p3) AND ([a_special] = @p4) AND ([a_name] = @p5) AND ([a_from] = @p6) AND ([a_from_url] IS NULL) AND ([a_author] IS NULL) AND ([a_editor] IS NULL) AND ([a_describe] IS NULL) AND ([a_content] = @p7) AND ([a_create_date] = @p8) AND ([a_tag] = @p9) AND ([a_hits] = @p10) AND (NOT ([a_commend] = 1)) AND (NOT ([a_istop] = 1)) AND (NOT ([a_isimg] = 1)) AND ([a_cacheimg] IS NULL) AND ([a_imgurls] IS NULL) AND ([a_imgurl] = @p11) AND (NOT ([a_ismedia] = 1)) AND ([a_mediaurl] IS NULL) AND (NOT ([a_iscomment] = 1)) AND (NOT ([a_isRecycle] = 1)) AND ([a_weight] = @p12) AND ([a_status] = @p13) AND ([a_url] IS NULL) AND ([a_file_path] IS NULL) AND ([a_contentfile] IS NULL) AND ([a_comment] = @p14) AND ([a_ispass] = @p15) AND ([a_bury] = @p16) AND ([a_dig] = @p17) AND ([a_score] = @p18) AND ([a_diguser] IS NULL) AND ([a_buryuser] IS NULL) AND ([a_viewip] IS NULL) AND ([a_lastviewdate] IS NULL) AND ([a_neworimageorvideo] IS NULL)
SELECT [t1].[a_weights], [t1].[a_rank]
FROM [dbo].[mvc_content] AS [t1]
WHERE ((@@ROWCOUNT) > 0) AND ([t1].[a_id] = @p20)
-- @p0: Input BigInt (Size = 0; Prec = 0; Scale = 0) [4501]
-- @p1: Input BigInt (Size = 0; Prec = 0; Scale = 0) [197]
-- @p2: Input BigInt (Size = 0; Prec = 0; Scale = 0) [24]
-- @p3: Input BigInt (Size = 0; Prec = 0; Scale = 0) [236]
-- @p4: Input BigInt (Size = 0; Prec = 0; Scale = 0) [0]
-- @p5: Input NVarChar (Size = 11; Prec = 0; Scale = 0) [层(div)的上下滚动]
-- @p6: Input NVarChar (Size = 4; Prec = 0; Scale = 0) [1488]
-- @p7: Input NVarChar (Size = 23197; Prec = 0; Scale = 0) [{$ad$}
<div id=demo style="OVERFLOW: hidden; HEIGHT: 235px">
<div id=demo1>
<table cellSpacing=1 cellPadding=0 width="100%" border=0>
<tbody>
<tr align=middle bgColor=#ffffff>
<td><a href="http://www.yide.com/featuredproducts/product_detail.asp?view=&product_id=7198&category_id=32&category_parentid=5" target=_blank><img height=80 src="http://www.yide.com/editor/z/20060317/1.jpg" width=80 border=0></a></td>
<td><a href="http://www.yide.com/featuredproducts/product_detail.asp?view=&product_id=7168&category_id=118&category_parentid=4" target=_blank><img height=80 src="http://www.yide.com/editor/x/2006/0317/1.jpg" width=80 border=0></a></td>
<td><a href="http://www.yide.com/featuredproducts/product_detail.asp?view=&product_id=7194&category_id=26&category_parentid=5" target=_blank><img height=80 src="http://www.yide.com/editor/z/20060317/2.jpg" width=80 border=0></a></td>
</tr>
<tr align=middle bgColor=#ffffff>
<td>
<table cellSpacing=1 cellPadding=0 width="100%" border=0>
<tbody>
<tr>
<td>圆头绑带女鞋</td>
</tr>
<tr>
<td>Christian Louboutin</td>
</tr>
<tr>
<td><font color=#ff0033>$ 295.00</font></td>
</tr>
<tr>
<td><font color=#ff0033>¥2404.25</font></td>
</tr>
</tbody>
</table>
</td>
<td>
<table cellSpacing=1 cellPadding=0 width="100%" border=0>
<tbody>
<tr>
<td><font color=#000000>DR-S100 迷你DV </font></td>
</tr>
<tr>
<td>Panasonic</td>
</tr>
<tr>
<td>
<p><font color=#ff0033>$ 849.00</font></p>
</td>
</tr>
<tr>
<td>
<p><font color=#ff0033>¥6,919.35</font></p>
</td>
</tr>
</tbody>
</table>
</td>
<td>
<table cellSpacing=1 cellPadding=0 width="100%" border=0>
<tbody>
<tr>
<td><font color=#000000>新娘无痕紧身胸衣</font></td>
</tr>
<tr>
<td>Victoria's Secret </td>
</tr>
<tr>
<td><font color=#ff0033>$ 48.00</font></td>
</tr>
<tr>
<td><font color=#ff0033>¥</font><span class=red><font color=#ff0033>391.20</font></span></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<table cellSpacing=1 cellPadding=0 width="100%" border=0>
<tbody>
<tr>
<td> </td>
</tr>
</tbody>
</table>
<table cellSpacing=1 cellPadding=0 width="100%" border=0>
<tbody>
<tr align=middle bgColor=#ffffff>
<td><a href="http://www.yide.com/featuredproducts/product_detail.asp?view=&product_id=7127&category_id=172&category_parentid=13" target=_blank><img height=80 src="http://www.yide.com/editor/p/2005.10.1/82.6.jpg" width=80 border=0></a></td>
<td><a href="http://www.yide.com/featuredproducts/product_detail.asp?view=&product_id=7087&category_id=202&category_parentid=15" target=_blank><img height=80 src="http://www.yide.com/editor/p/2005.10.1/82.8.jpg" width=80 border=0></a></td>
<td><a href="http://www.yide.com/featuredproducts/product_detail.asp?view=&product_id=7022&category_id=186&category_parentid=14" target=_blank><img height=80 src="http://www.yide.com/editor/x/2006/0317/2.jpg" width=80 border=0></a></td>
</tr>
<tr align=middle bgColor=#ffffff>
<td>
<table cellSpacing=1 cellPadding=0 width="100%" border=0>
<tbody>
<tr>
<td><font color=#000000>男表</font></td>
</tr>
<tr>
<td>名士</td>
</tr>
<tr>
<td><font color=#ff0033>$977.00</font></td>
</tr>
<tr>
<td height=12><font color=#ff0033>¥</font><span class=red><font color=#ff0000>7962.55</font></span></td>
</tr>
</tbody>
</table>
</td>
<td>
<table cellSpacing=1 cellPadding=0 width="100%" border=0>
<tbody>
<tr>
<td>足部磨砂护理</td>
<tr>
<td>碧欧泉</td>
</tr>
<tr>
<td><font color=#ff0033>$ 15.00</font></td>
</tr>
<tr>
<td><font color=#ff0033>¥122.25</font></td>
</tr>
</tbody>
</table>
</td>
<td>
<table cellSpacing=1 cellPadding=0 width="100%" border=0>
<tbody>
<tr>
<td>nike休闲女鞋</td>
</tr>
<tr>
<td>nike</td>
</tr>
<tr>
<td><font color=#ff0033>$ 39.99</font></td>
</tr>
<tr>
<td><font color=#ff0033>¥</font><span class=red><font color=#ff0000>325.92</font></span></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<table cellSpacing=1 cellPadding=0 width="100%" border=0>
<tbody>
<tr>
<td> </td>
</tr>
</tbody>
</table>
</div>
<div id=demo2></div>
</div>
<script>
var speed=30
demo2.innerHTML=demo1.innerHTML
function Marquee(){
if(demo2.offsetTop-demo.scrollTop<=0)
demo.scrollTop-=demo1.offsetHeight
else{
demo.scrollTop++
}
}
var MyMar=setInterval(Marquee,speed)
demo.onmouseover=function() {clearInterval(MyMar)}
demo.onmouseout=function() {MyMar=setInterval(Marquee,speed)}
</script>
]
-- @p8: Input DateTime (Size = 0; Prec = 0; Scale = 0) [2008-1-6 0:46:35]
-- @p9: Input NVarChar (Size = 9; Prec = 0; Scale = 0) [div,上下,滚动]
-- @p10: Input BigInt (Size = 0; Prec = 0; Scale = 0) [2473]
-- @p11: Input NVarChar (Size = 0; Prec = 0; Scale = 0) []
-- @p12: Input BigInt (Size = 0; Prec = 0; Scale = 0) [0]
-- @p13: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
-- @p14: Input BigInt (Size = 0; Prec = 0; Scale = 0) [0]
-- @p15: Input Int (Size = 0; Prec = 0; Scale = 0) [0]
-- @p16: Input BigInt (Size = 0; Prec = 0; Scale = 0) [0]
-- @p17: Input BigInt (Size = 0; Prec = 0; Scale = 0) [0]
-- @p18: Input Float (Size = 0; Prec = 0; Scale = 0) [0]
-- @p19: Input BigInt (Size = 0; Prec = 0; Scale = 0) [2474]
-- @p20: Input BigInt (Size = 0; Prec = 0; Scale = 0) [4501]
-- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.1
SELECT TOP (10) [t0].[a_id], [t0].[a_site], [t0].[a_model], [t0].[a_type], [t0].[a_special], [t0].[a_name], [t0].[a_from], [t0].[a_from_url], [t0].[a_author], [t0].[a_editor], [t0].[a_describe], [t0].[a_content], [t0].[a_create_date], [t0].[a_tag], [t0].[a_hits], [t0].[a_commend], [t0].[a_istop], [t0].[a_isimg], [t0].[a_cacheimg], [t0].[a_imgurls], [t0].[a_imgurl], [t0].[a_ismedia], [t0].[a_mediaurl], [t0].[a_iscomment], [t0].[a_isRecycle], [t0].[a_weight], [t0].[a_weights], [t0].[a_status], [t0].[a_url], [t0].[a_file_path], [t0].[a_contentfile], [t0].[a_comment], [t0].[a_ispass], [t0].[a_bury], [t0].[a_dig], [t0].[a_score], [t0].[a_rank], [t0].[a_diguser], [t0].[a_buryuser], [t0].[a_viewip], [t0].[a_lastviewdate], [t0].[a_neworimageorvideo], [t0].[class_id], [t0].[class_type], [t0].[class_name], [t0].[class_show_name], [t0].[class_parent_id], [t0].[class_id_path], [t0].[class_name_path], [t0].[class_show_name_path], [t0].[class_depth], [t0].[class_order], [t0].[class_content], [t0].[class_img], [t0].[a_model_name]
FROM [dbo].[mvc_content_view] AS [t0]
WHERE ([t0].[a_type] IN (@p0)) AND (NOT ([t0].[a_isRecycle] = 1))
ORDER BY [t0].[a_id] DESC
-- @p0: Input BigInt (Size = 0; Prec = 0; Scale = 0) [236]
-- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.1