服务器未知运行时异常: 
### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') TOTAL' at line 26
### The error may exist in URL [jar:file:/home/admin/app/wangpeng/metering-jenkins/casic-metering-api-2.0.0/lib/casic-metering-dao-2.0.0.jar!/mapper/business/BusinessCertificateReportMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT(*) FROM (SELECT             bcr.*,             csi.sample_no AS sampleNo,             csi.sample_name AS sampleName,             csi.sample_model AS sampleModel,             csi.manufacturing_no AS manufacturingNo,             bo.order_code AS orderCode,             su.name AS measurePersonName,             csi.measure_category AS measureCategory         FROM business_certificate_report bcr             LEFT JOIN business_order bo             ON bcr.order_id=bo.id             LEFT JOIN customer_sample_info csi             ON bcr.sample_id=csi.id             LEFT JOIN sys_user su             ON bcr.measure_person_id=su.id         WHERE bcr.is_del = 0                                                                                                                        and bcr.id in) TOTAL
### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') TOTAL' at line 26
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') TOTAL' at line 26