id_, code_, name_, parent_id_, full_id_, full_code_, full_name_, has_children_, level_code_, longitude_, latitude_, is_dele_, sn_ select * from portal_sys_areas where is_dele_='0' and code_ = #{code} and name_ like CONCAT('%',#{name},'%') and parent_id_ = #{parentId} and level_code_ = #{levelCode} and full_code_ like CONCAT(#{fullCode},'%') and full_id_ like CONCAT(#{fullId},'%') order by code_,sn_