SELECT timeline_id, COUNT(*) AS total FROM feed_like_2017 WHERE timeline_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND is_deleted = ? GROUP BY timeline_id ORDER BY total DESC
这种写法是不是很 low. 有没办法优化
本人小白
 |
1
哪个大神帮我看看，谢谢
|
 |
jy02201949Jun 13, 2017
2
这么简单的语句还要怎么优化啊。。。
|
|
3
但是他需要 2s 查询
|
 |
twmJun 13, 2017 via iPhone
4
就不能在业务环节最好统计吗？非要这么计算
|
 |
GlobalNPCJun 13, 2017
6
IN 里面的 ID 哪里来的？
如果是查出来的，那能 join 么？ |
|
7
谢谢大家
|
Select Language