light-apiengine-feature/sqlconfig/system_controller/system_find_user_page_select.tpl

select
    *
from
    sys_user
where
    del_flag = 0
{{if ne .name ""}}
    and name like '%{{.name}}%'
{{end}}
{{if ne .login_id ""}}
    and login_id like '%{{.login_id}}%'
{{end}}
LIMIT {{.rows}} OFFSET {{.offset}}