select count(1) select r.* ` ` from route r ` and ( r.name like concat('%',#{param.filter_text},'%') or r.description like concat('%',#{param.filter_text},'%') or r.host like concat('%',#{param.filter_text},'%') or r.prefix like concat('%',#{param.filter_text},'%') or r.path like concat('%',#{param.filter_text},'%') ) ` ` and r.status = #{param.status} ` ` and r.service like concat('%',#{param.service},'%') ` ` order by r.id desc ` ` limit ${page_no},${page_size} `