CC.id, content, last_updated, create_time, user_id, content_id, follow_count select , U.avatar, U.name from cab_content_comment CC inner join cab_users U on CC.user_id = U.id where content_id = #{contentId,jdbcType=BIGINT} order by create_time desc limit #{start},#{limit} select count(id) FROM cab_content_comment where content_id=#{contentId,jdbcType=BIGINT} insert into cab_content_comment id, content, last_updated, deleted, create_time, user_id, content_id, #{id,jdbcType=BIGINT}, #{content,jdbcType=VARCHAR}, #{lastUpdated,jdbcType=TIMESTAMP}, #{deleted,jdbcType=TIMESTAMP}, #{createTime,jdbcType=TIMESTAMP}, #{userId,jdbcType=BIGINT}, #{contentId,jdbcType=BIGINT}, update cab_content_comment set follow_count = follow_count + 1 where id = #{id,jdbcType=BIGINT}