select count(1) select u.*, ua1.identity as username ` ` from user u left join user_auth ua1 on u.id = ua1.user_id and ua1.type = 1 ` and ( u.nickname like concat('%', #{param.filter_text}, '%') or ua1.identity like concat('%', #{param.filter_text}, '%') ) ` ` and u.status = #{param.status} ` ` order by u.id desc ` ` limit ${page_no},${page_size} `