C.id, title, sub_title, user_id, create_time, content_brief, content_type, content_type2, content_type3, url, thumb,thumb_min,video_url,video_time, status,isfirst,istop,iscreate, header_banner, up_count, comment_count, view_count select from cab_content C where content_type2 = #{0} limit #{1}, #{2} select count(*) from cab_content C where content_type3 = #{0} select from cab_content C where C.id = #{id,jdbcType=BIGINT} insert into cab_content id, title, sub_title, user_id, create_time, content_brief, content_type, content_type2, content_type3, url, thumb, thumb_min, video_url, video_time, isfirst, istop, iscreate, status, header_banner, up_count, comment_count, view_count, #{id,jdbcType=BIGINT}, #{title,jdbcType=VARCHAR}, #{subTitle,jdbcType=VARCHAR}, #{userId,jdbcType=BIGINT}, #{createTime,jdbcType=TIMESTAMP}, #{contentBrief,jdbcType=VARCHAR}, #{contentType,jdbcType=VARCHAR}, #{contentType2,jdbcType=VARCHAR}, #{contentType3,jdbcType=VARCHAR}, #{url,jdbcType=VARCHAR}, #{thumb,jdbcType=VARCHAR}, #{thumbMin,jdbcType=VARCHAR}, #{videoUrl,jdbcType=VARCHAR}, #{videoTime,jdbcType=VARCHAR}, #{isFirst,jdbcType=INTEGER}, #{isTop,jdbcType=INTEGER}, #{isCreate,jdbcType=INTEGER}, #{status,jdbcType=INTEGER}, #{headerBanner,jdbcType=VARCHAR}, #{upCount,jdbcType=BIGINT}, #{commentCount,jdbcType=BIGINT}, #{viewCount,jdbcType=BIGINT}, update cab_content set comment_count = comment_count + 1 where id = #{id,jdbcType=BIGINT} update cab_content set up_count = up_count + 1 where id = #{id,jdbcType=BIGINT} update cab_content set favorite_count = favorite_count + 1 where id = #{id,jdbcType=BIGINT} update cab_content set up_count = up_count - 1 where id = #{id,jdbcType=BIGINT} update cab_content set favorite_count = favorite_count - 1 where id = #{id,jdbcType=BIGINT} update cab_content title= #{title,jdbcType=VARCHAR}, sub_title =#{subTitle,jdbcType=VARCHAR}, user_id = #{userId,jdbcType=VARCHAR}, content_brief =#{contentBrief,jdbcType=VARCHAR}, content_type = #{contentType,jdbcType=VARCHAR}, content_type2 =#{contentType2,jdbcType=VARCHAR}, content_type3 =#{contentType3,jdbcType=VARCHAR}, url = #{url,jdbcType=VARCHAR}, thumb = #{thumb,jdbcType=VARCHAR}, thumb_min =#{thumbMin,jdbcType=VARCHAR}, video_url =#{videoUrl,jdbcType=VARCHAR}, video_time =#{videoTime,jdbcType=VARCHAR}, isfirst = #{isFirst,jdbcType=INTEGER}, istop =#{isTop,jdbcType=INTEGER}, iscreate =#{isCreate,jdbcType=INTEGER}, status =#{status,jdbcType=INTEGER}, header_banner = #{headerBanner,jdbcType=VARCHAR}, up_count = #{upCount,jdbcType=BIGINT}, comment_count = #{commentCount,jdbcType=BIGINT}, view_count = #{viewCount,jdbcType=BIGINT}, where id=#{id,jdbcType=INTEGER} select from cab_content C where istop = 1 order by create_time desc limit #{page},#{limit} select count(id) FROM cab_content where istop='1' select from cab_content C where content_type = #{paramsType,jdbcType=VARCHAR} and isfirst = 1 order by create_time desc select ,t1.name contentTypeName,t2.name contentTypeName2,t3.name contentTypeName3 from cab_content C left join cab_content_type t1 on C.content_type = t1.id left join cab_content_type t2 on C.content_type2 = t2.id left join cab_content_type t3 on C.content_type3 = t3.id where 1=1 and content_type2 = #{contentTypeParentId,jdbcType=VARCHAR} and content_type3 = #{contentTypeId,jdbcType=VARCHAR} and title like '%${title}%' order by create_time desc limit #{start,jdbcType=BIGINT}, #{count,jdbcType=BIGINT} select count(*) from cab_content C where 1=1 and content_type2 = #{contentTypeParentId,jdbcType=VARCHAR} and content_type3 = #{contentTypeId,jdbcType=VARCHAR} and title like '%${title}%' select C.*,t1.name contentTypeName,t2.name contentTypeName2,t3.name contentTypeName3 from cab_content C left join cab_content_type t1 on C.content_type = t1.id left join cab_content_type t2 on C.content_type2 = t2.id left join cab_content_type t3 on C.content_type3 = t3.id right join cab_cu_relation cr on C.id = cr.content_id where 1=1 and cr.cu_type=2 and cr.user_id = #{userId} and title like '%${title}%' order by cr.create_time desc limit #{start,jdbcType=BIGINT}, #{limit,jdbcType=BIGINT} select count(*) from cab_content C right join cab_cu_relation cr on C.id = cr.content_id where 1=1 and cr.cu_type=2 and cr.user_id = #{userId} and title like '%${title}%' select C.id, title, sub_title, user_id, create_time, content_brief, content_type, content_type2, content_type3, url, thumb,video_url, status,isfirst,istop, header_banner from cab_content C cv where C.id = #{id,jdbcType=BIGINT} select from cab_content C where 1=1 and content_type = #{contentType1,jdbcType=VARCHAR} and content_type2 = #{contentType2,jdbcType=VARCHAR} and content_type3 = #{contentType3,jdbcType=VARCHAR} and title like '%${title}%' and isfirst = 1 and isfirst = 0 and istop = 1 and istop = 0 and iscreate = 1 and iscreate = 0 order by create_time desc limit #{page,jdbcType=BIGINT}, #{limit,jdbcType=BIGINT} select count(*) from cab_content C where 1=1 and content_type = #{contentType1,jdbcType=VARCHAR} and content_type2 = #{contentType2,jdbcType=VARCHAR} and content_type3 = #{contentType3,jdbcType=VARCHAR} and title like '%${title}%' and isfirst = 1 and isfirst = 0 and istop = 1 and istop = 0 and iscreate = 1 and iscreate = 0 update cab_content set istop = #{isVal,jdbcType=BIGINT} where id = #{id,jdbcType=BIGINT} update cab_content set isfirst = #{isVal,jdbcType=BIGINT} where id = #{id,jdbcType=BIGINT} update cab_content set video_time = #{time,jdbcType=VARCHAR} where id = #{id,jdbcType=BIGINT} DELETE from cab_content where id= #{id,jdbcType=BIGINT}