sql优化实例

优化前

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.7528sSELECT 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.0267sSELECT 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