light-apiengine/sqlconfig/system_controller/system_find_data_permission_detail_page_select.tpl

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}}