下面這個(gè)就是慢的sql語句 因?yàn)楸韘tore_product_cate 數(shù)據(jù)有一萬多 然后商品總數(shù) 6000多 而且in走不了索引 導(dǎo)致查詢速度很慢 建議優(yōu)化下 對(duì)應(yīng)接口是: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))