select
    sys_data_permission_detail.*
from
    sys_data_permission_detail
where
    sys_data_permission_detail.del_flag = 0
    {{if ne .data_permission_id ""}}
        and sys_data_permission_detail.data_permission_id = '{{.data_permission_id}}'
    {{end}}
LIMIT {{.rows}} OFFSET {{.offset}}