Web开发的改良



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) AND (NOT ([t0].[a_isRecycle] = 1)) -- @p0: Input BigInt (Size = 0; Prec = 0; Scale = 0) [6364] -- @p1: Input BigInt (Size = 0; Prec = 0; Scale = 0) [218] -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.1 SELECT TOP (1) [t0].[a_id], [t0].[a_name] FROM [dbo].[mvc_content_view] AS [t0] WHERE ([t0].[a_type] = @p0) AND ([t0].[a_id] < @p1) AND (NOT ([t0].[a_isRecycle] = 1)) ORDER BY [t0].[a_id] DESC -- @p0: Input BigInt (Size = 0; Prec = 0; Scale = 0) [218] -- @p1: Input BigInt (Size = 0; Prec = 0; Scale = 0) [6364] -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.1 SELECT TOP (1) [t0].[a_id], [t0].[a_name] FROM [dbo].[mvc_content_view] AS [t0] WHERE ([t0].[a_type] = @p0) AND ([t0].[a_id] > @p1) AND (NOT ([t0].[a_isRecycle] = 1)) ORDER BY [t0].[a_id] -- @p0: Input BigInt (Size = 0; Prec = 0; Scale = 0) [218] -- @p1: Input BigInt (Size = 0; Prec = 0; Scale = 0) [6364] -- 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, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24)) AND (NOT ([t0].[a_isRecycle] = 1)) ORDER BY [t0].[a_id] DESC -- @p0: Input BigInt (Size = 0; Prec = 0; Scale = 0) [218] -- @p1: Input BigInt (Size = 0; Prec = 0; Scale = 0) [232] -- @p2: Input BigInt (Size = 0; Prec = 0; Scale = 0) [248] -- @p3: Input BigInt (Size = 0; Prec = 0; Scale = 0) [251] -- @p4: Input BigInt (Size = 0; Prec = 0; Scale = 0) [249] -- @p5: Input BigInt (Size = 0; Prec = 0; Scale = 0) [241] -- @p6: Input BigInt (Size = 0; Prec = 0; Scale = 0) [233] -- @p7: Input BigInt (Size = 0; Prec = 0; Scale = 0) [253] -- @p8: Input BigInt (Size = 0; Prec = 0; Scale = 0) [254] -- @p9: Input BigInt (Size = 0; Prec = 0; Scale = 0) [255] -- @p10: Input BigInt (Size = 0; Prec = 0; Scale = 0) [229] -- @p11: Input BigInt (Size = 0; Prec = 0; Scale = 0) [256] -- @p12: Input BigInt (Size = 0; Prec = 0; Scale = 0) [257] -- @p13: Input BigInt (Size = 0; Prec = 0; Scale = 0) [230] -- @p14: Input BigInt (Size = 0; Prec = 0; Scale = 0) [231] -- @p15: Input BigInt (Size = 0; Prec = 0; Scale = 0) [203] -- @p16: Input BigInt (Size = 0; Prec = 0; Scale = 0) [224] -- @p17: Input BigInt (Size = 0; Prec = 0; Scale = 0) [226] -- @p18: Input BigInt (Size = 0; Prec = 0; Scale = 0) [225] -- @p19: Input BigInt (Size = 0; Prec = 0; Scale = 0) [204] -- @p20: Input BigInt (Size = 0; Prec = 0; Scale = 0) [238] -- @p21: Input BigInt (Size = 0; Prec = 0; Scale = 0) [239] -- @p22: Input BigInt (Size = 0; Prec = 0; Scale = 0) [240] -- @p23: Input BigInt (Size = 0; Prec = 0; Scale = 0) [250] -- @p24: Input BigInt (Size = 0; Prec = 0; Scale = 0) [252] -- 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, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24)) AND (NOT ([t0].[a_isRecycle] = 1)) ORDER BY [t0].[a_id] DESC -- @p0: Input BigInt (Size = 0; Prec = 0; Scale = 0) [218] -- @p1: Input BigInt (Size = 0; Prec = 0; Scale = 0) [232] -- @p2: Input BigInt (Size = 0; Prec = 0; Scale = 0) [248] -- @p3: Input BigInt (Size = 0; Prec = 0; Scale = 0) [251] -- @p4: Input BigInt (Size = 0; Prec = 0; Scale = 0) [249] -- @p5: Input BigInt (Size = 0; Prec = 0; Scale = 0) [241] -- @p6: Input BigInt (Size = 0; Prec = 0; Scale = 0) [233] -- @p7: Input BigInt (Size = 0; Prec = 0; Scale = 0) [253] -- @p8: Input BigInt (Size = 0; Prec = 0; Scale = 0) [254] -- @p9: Input BigInt (Size = 0; Prec = 0; Scale = 0) [255] -- @p10: Input BigInt (Size = 0; Prec = 0; Scale = 0) [229] -- @p11: Input BigInt (Size = 0; Prec = 0; Scale = 0) [256] -- @p12: Input BigInt (Size = 0; Prec = 0; Scale = 0) [257] -- @p13: Input BigInt (Size = 0; Prec = 0; Scale = 0) [230] -- @p14: Input BigInt (Size = 0; Prec = 0; Scale = 0) [231] -- @p15: Input BigInt (Size = 0; Prec = 0; Scale = 0) [203] -- @p16: Input BigInt (Size = 0; Prec = 0; Scale = 0) [224] -- @p17: Input BigInt (Size = 0; Prec = 0; Scale = 0) [226] -- @p18: Input BigInt (Size = 0; Prec = 0; Scale = 0) [225] -- @p19: Input BigInt (Size = 0; Prec = 0; Scale = 0) [204] -- @p20: Input BigInt (Size = 0; Prec = 0; Scale = 0) [238] -- @p21: Input BigInt (Size = 0; Prec = 0; Scale = 0) [239] -- @p22: Input BigInt (Size = 0; Prec = 0; Scale = 0) [240] -- @p23: Input BigInt (Size = 0; Prec = 0; Scale = 0) [250] -- @p24: Input BigInt (Size = 0; Prec = 0; Scale = 0) [252] -- 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, @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14, @p15, @p16, @p17, @p18, @p19, @p20, @p21, @p22, @p23, @p24)) AND (NOT ([t0].[a_isRecycle] = 1)) ORDER BY [t0].[a_hits] DESC, [t0].[a_id] DESC -- @p0: Input BigInt (Size = 0; Prec = 0; Scale = 0) [218] -- @p1: Input BigInt (Size = 0; Prec = 0; Scale = 0) [232] -- @p2: Input BigInt (Size = 0; Prec = 0; Scale = 0) [248] -- @p3: Input BigInt (Size = 0; Prec = 0; Scale = 0) [251] -- @p4: Input BigInt (Size = 0; Prec = 0; Scale = 0) [249] -- @p5: Input BigInt (Size = 0; Prec = 0; Scale = 0) [241] -- @p6: Input BigInt (Size = 0; Prec = 0; Scale = 0) [233] -- @p7: Input BigInt (Size = 0; Prec = 0; Scale = 0) [253] -- @p8: Input BigInt (Size = 0; Prec = 0; Scale = 0) [254] -- @p9: Input BigInt (Size = 0; Prec = 0; Scale = 0) [255] -- @p10: Input BigInt (Size = 0; Prec = 0; Scale = 0) [229] -- @p11: Input BigInt (Size = 0; Prec = 0; Scale = 0) [256] -- @p12: Input BigInt (Size = 0; Prec = 0; Scale = 0) [257] -- @p13: Input BigInt (Size = 0; Prec = 0; Scale = 0) [230] -- @p14: Input BigInt (Size = 0; Prec = 0; Scale = 0) [231] -- @p15: Input BigInt (Size = 0; Prec = 0; Scale = 0) [203] -- @p16: Input BigInt (Size = 0; Prec = 0; Scale = 0) [224] -- @p17: Input BigInt (Size = 0; Prec = 0; Scale = 0) [226] -- @p18: Input BigInt (Size = 0; Prec = 0; Scale = 0) [225] -- @p19: Input BigInt (Size = 0; Prec = 0; Scale = 0) [204] -- @p20: Input BigInt (Size = 0; Prec = 0; Scale = 0) [238] -- @p21: Input BigInt (Size = 0; Prec = 0; Scale = 0) [239] -- @p22: Input BigInt (Size = 0; Prec = 0; Scale = 0) [240] -- @p23: Input BigInt (Size = 0; Prec = 0; Scale = 0) [250] -- @p24: Input BigInt (Size = 0; Prec = 0; Scale = 0) [252] -- Context: SqlProvider(Sql2008) Model: AttributedMetaModel Build: 3.5.30729.1