sql优化实例

最新推荐文章于 2024-09-03 09:20:13 发布

qw_xingzhe

最新推荐文章于 2024-09-03 09:20:13 发布

阅读量571

点赞数

本文链接：https://blog.csdn.net/qw_xingzhe/article/details/75332734

版权

优化前

SELECT COUNT(*) AS tp_count FROM hb_gather_weibo_cache_record gwcr left JOIN hb_musician m ON m.id=gwcr.musician_id WHERE ( gwcr.gwc_id = '18' ) LIMIT 1 
10.7528s
SELECT gwcr.*,m.musician_name FROM hb_gather_weibo_cache_record gwcr left JOIN hb_musician m ON m.id=gwcr.musician_id WHERE ( gwcr.gwc_id = '18' ) ORDER BY follower_num_dvalue desc LIMIT 0,10 
0.3732s

优化后

SELECT COUNT(*) AS tp_count FROM hb_gather_weibo_cache_record gwcr left JOIN hb_musician m ON m.id=gwcr.musician_id WHERE ( gwcr.gwc_id = '18' ) AND ( m.id=gwcr.musician_id ) LIMIT 1 
5.0267s
SELECT gwcr.*,m.musician_name FROM hb_gather_weibo_cache_record gwcr left JOIN hb_musician m ON m.id=gwcr.musician_id WHERE ( gwcr.gwc_id = '18' ) AND ( m.id=gwcr.musician_id ) ORDER BY follower_num_dvalue desc LIMIT 0,10 
0.2507s