CF.id, from_id, to_id, follow_time, comment_id, content select , U1.nickname as name_from, U1.avatar as avatar_from, U2.nickname as name_to, U2.avatar as avatar_to from cab_content_follows CF inner join cab_sys_user U1 on CF.from_id = U1.id left join cab_sys_user U2 on CF.to_id = U2.id where CF.id IN #{item} select , U1.nickname as name_from, U1.avatar as avatar_from, U2.nickname as name_to, U2.avatar as avatar_to from cab_content_follows CF inner join cab_sys_user U1 on CF.from_id = U1.id left join cab_sys_user U2 on CF.to_id = U2.id where comment_id = #{0} order by follow_time desc select count(id) from cab_content_follows where comment_id=#{0} select count(id) from cab_content_follows where comment_id = #{0} select GROUP_CONCAT(CAST(id AS char)) from (select * from cab_content_follows ORDER BY follow_time DESC) AS TEMP GROUP BY comment_id HAVING comment_id IN #{item} insert into cab_content_follows id, from_id, to_id, follow_time, comment_id, content, #{id,jdbcType=BIGINT}, #{fromId,jdbcType=BIGINT}, #{toId,jdbcType=BIGINT}, #{followTime,jdbcType=TIMESTAMP}, #{commentId,jdbcType=BIGINT}, #{content,jdbcType=VARCHAR},