java中的mysql查询

Question

我接口进行get请求时如果对象中没有参数原本的SQL语句

select file_id, store_file_name, store_type, file_type, file_level, store_id, parent_id, file_path, file_size, file_introduce, visit_pwd, binding, status, lock_by, lock_time, user_id,
         create_by, create_time, update_by, update_time, category_id, file_label, file_contributors, file_synopsis, file_upload_date, file_format, file_status,
        (select count(0) from files_oper_log where business_type = '0' and store_oper_id = file_id )as download,
        (select count(0) from files_oper_log where business_type = '3' and store_oper_id = file_id )as browse
         from store_files
        where
            file_type = '1' and  file_status = '2'

会变成
SELECT count(0) FROM store_files WHERE file_type = '1' AND file_status = '2'
这样
不知道怎么回事,而且也不是所有的都这样,有的接口没变

Answer 1

框架或者分页插件的功能，这个是为了前端分页的总条数。页面上的多少页，就是这个sql提供的页数