SELECT R1.* FROM ( ) R1 LIMIT #{pgtl.startNo}, #{pgtl.listPerPage} select count(id) as count from t_user where 1=1 and id = #{id} and roleCode = #{roleCode} and statusCode = #{statusCode} select * from t_user where 1=1 and id = #{id} and roleCode = #{roleCode} and statusCode = #{statusCode} order by createDatetime desc select * from t_user where id = #{id} and statusCode = '01' select m.*, p.name as plantName from t_user_plant_mapping m, t_plant p where m.plantSeq = p.seq and p.plantStatus = '01' and m.userId=#{id} select p.seq as plantSeq, p.name as plantName from t_plant p, t_pms m where p.seq = m.plantSeq and p.plantStatus = '01' and m.pmsStatus = '01' order by p.seq desc update t_user set name = #{name}, password = #{password}, statusCode = #{statusCode}, roleCode = #{roleCode}, updateDatetime = now() where id = #{id} insert into t_user ( id, name, password, statusCode, roleCode, createDateTime, updateDatetime ) values ( #{id}, #{name}, #{password}, #{statusCode}, #{roleCode}, now(), now() )