請在此詳細描述你所遇到的問題
Java多商戶V1.5版本:pc端商城打開報sql異常錯誤,求解決!??!
### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'DESC,sales DESC,ficti DESC,id DESC LIMIT 10' at line 5 ### The error may exist in com/zbkj/service/dao/ProductDao.java (best guess) ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: SELECT id,mer_id,image,name,unit_name,price,sales,ficti,category_id,brand_id FROM eb_product WHERE (is_del = ? AND is_recycle = ? AND is_show = ? AND audit_status IN (?,?)) ORDER BY rank DESC,sales DESC,ficti DESC,id DESC LIMIT ? ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'DESC,sales DESC,ficti DESC,id DESC LIMIT 10' at line 5 ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'DESC,sales DESC,ficti DESC,id DESC LIMIT 10' at line 5
【產品名稱】:JAVA版
【產品版本】:v1.5
【部署方式】:linux/mac寶塔面板
【部署環境】:線上環境
【php版本】:
【Mysql版本】5.7
【使用終端】:PC