javascript - Express/MySQL 未返回 MySQL Workbench 返回的相同值

Question

当我在 MySQL Workbench 上运行它时，我有一个完美运行的查询，但是当我在 Express 上运行它时，它会返回我数据库中的所有数据。请帮忙修复？
PS。以前发过这个，但没有解决。

- 客户

$.ajax({
   url: '/filter',
   type: 'get',
   contentType: 'application',
   data: { categoryIDs : checkedCategory,
           materialIDs : checkedMaterial,
           designIDs   : checkedDesign},
   success: function(response) {
      console.log(response.products);
   }
});

--服务器代码

getFilteredTable: function(req, res, next) {
   var filter="SELECT COUNT(A.id) \
               FROM tbl_product A JOIN tbl_product_details B ON A.id = B.prod_id  \
               JOIN tbl_category C ON A.id = C.prod_id \
               JOIN tbl_material D ON A.id = D.prod_id \
               JOIN tbl_design E ON A.id = E.prod_id \
               WHERE C.category_id IN (?) \
               AND (D.material_id IN (?) \
               OR E.design_id IN (?))";
   mysqlConnection.query(filter, [req.query.categoryIDs, req.query.materialIDs, req.query.designIDs], function(err, rows, fields) {
      if(!err)
      res.send({products : rows});
      else
      console.log(err);
   });
},

这是我的查询：

SELECT COUNT(A.id)
FROM tbl_product A 
JOIN tbl_product_details B ON A.id = B.prod_id
JOIN tbl_category C ON A.id = C.prod_id
JOIN tbl_material D ON A.id = D.prod_id
JOIN tbl_design E ON A.id = E.prod_id
WHERE C.category_id IN (6) AND (D.material_id IN (15) OR E.design_id IN (39));

我希望输出是（工作台结果）：
COUNT(A.id): 42

相反，它给了我：
COUNT(A.id): 1582

标签： javascriptmysqlnode.jsexpressmysql-workbench