老用户购买和原来的数据库在同一个内网吗?
标题:腾讯云云产品新购特惠,五折上云!
地址:https://cloud.tencent.com/act/first_purchase?utm_source=portal&utm_medium=rightbanner&utm_campaign=firstpurchase&utm_term=0115
浏览器信息
Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Saf
SELECT p.id_product
FROM popularity p, products pr
WHERE p.id_product = pr.id_product
AND p.date >= (DATE_SUB(CURDATE(), INTERVAL 30 DAY))
GROUP BY p.id_product order by count(p.id_product) desc LIMIT 0, 6
我想知道如何尽可能地优化我的查询。我试图减少脂肪,特别是这个查询给我带