下面这个就是慢的sql语句 因为表store_product_cate 数据有一万多 然后商品总数 6000多 而且in走不了索引 导致查询速度很慢 建议优化下 对应接口是:getProductList
SELECT COUNT(*) AS think_count FROM `eb_store_product` WHERE `is_show` = 1 AND `is_del` = 0 AND `vip_product` = 0 AND `id` IN (SELECT `product_id` FROM `eb_store_product_cate` WHERE `cate_id` IN (SELECT `id` FROM `eb_store_category` WHERE `pid` = 4 OR `id` = 4))