当前位置：Gxlcms > mysql > mysql查询优化，谁能帮我优化查询啊？我这个太慢了，慢死了
mysql查询优化，谁能帮我优化查询啊？我这个太慢了，慢死了
时间：2021-07-01 10:21:17帮助过：36人阅读
mysql优化sql
SELECT mobileuserid,caozuoleixing,caozuozhi,xiguanzhi FROM 表A WHERE xiguanzhi>2 GROUP BY mobileuserid,caozuoleixing,caozuozhi,xiguanzhi ORDER BY mobileuserid,caozuoleixing,xiguanzhi DESC LIMIT 3000
