为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
- 【TiDB 版本】：3.0.9
- 【问题描述】：select 查询比mysql 慢
若提问为性能优化、故障排查类问题，请下载脚本运行。终端输出打印结果，请务必全选并复制粘贴上传。
mysql> trace format=‘row’ SELECT id,sku_id,station_no,current_qty,order_qty,lock_qty,create_time,create_pin,update_time,update_pin,yn,ts,org_code,usable_qty,source_Id,vendibility_id,transfer_qty FROM stock_center_25 WHERE 1 = 1 AND sku_id = 2025409610 AND station_no = ‘11872925’ ORDER BY ID DESC LIMIT 0,1;
±--------------------------±----------------±-------------+
| operation | startTS | duration |
±--------------------------±----------------±-------------+
| session.getTxnFuture | 16:13:50.958857 | 5.411µs |
| ├─session.Execute | 16:13:50.958854 | 2.555421ms |
| ├─session.ParseSQL | 16:13:50.958933 | 66.784µs |
| ├─executor.Compile | 16:13:50.959014 | 405.176µs |
| ├─session.runStmt | 16:13:50.959432 | 1.932051ms |
| ├─session.CommitTxn | 16:13:50.961348 | 2.972µs |
| ├─recordSet.Next | 16:13:50.961426 | 3.000694051s |
| ├─limit.Next | 16:13:50.961428 | 3.000685054s |
| ├─tableReader.Next | 16:13:50.961430 | 3.000660876s |
| ├─recordSet.Next | 16:13:53.962138 | 11.654µs |
| └─limit.Next | 16:13:53.962141 | 669ns |
±--------------------------±----------------±-------------+
11 rows in set (3.95 sec)
mysql> explain analyze SELECT id,sku_id,station_no,current_qty,order_qty,lock_qty,create_time,create_pin,update_time,update_pin,yn,ts,org_code,usable_qty,source_Id,vendibility_id,transfer_qty FROM stock_center_25 WHERE 1 = 1 AND sku_id = 2025409610 AND station_no = ‘11872925’ ORDER BY ID DESC LIMIT 0,1;
±-------------------------±--------±-----±-------------------------------------------------------------------------------------------------------------±-----------------------------------------------------------------------------------------±------------+
| id | count | task | operator info | execution info | memory |
±-------------------------±--------±-----±-------------------------------------------------------------------------------------------------------------±-----------------------------------------------------------------------------------------±------------+
| Limit_11 | 1.00 | root | offset:0, count:1 | time:3.12358161s, loops:2, rows:1 | N/A |
| └─TableReader_31 | 1.00 | root | data:Limit_30 | time:3.123579734s, loops:1, rows:1 | 2.984375 KB |
| └─Limit_30 | 1.00 | cop | offset:0, count:1 | proc max:1.163s, min:392ms, p80:1.026s, p95:1.127s, rows:1, iters:20804, tasks:43 | N/A |
| └─Selection_29 | 1.00 | cop | eq(stock_center.stock_center_25.sku_id, 2025409610), eq(stock_center.stock_center_25.station_no, “11872925”) | proc max:1.163s, min:392ms, p80:1.026s, p95:1.127s, rows:1, iters:20804, tasks:43 | N/A |
| └─TableScan_28 | 4891.39 | cop | table:stock_center_25, range:[-inf,+inf], keep order:true, desc | proc max:1.145s, min:387ms, p80:1.014s, p95:1.106s, rows:21100919, iters:20804, tasks:43 | N/A |
±-------------------------±--------±-----±-------------------------------------------------------------------------------------------------------------±-----------------------------------------------------------------------------------------±------------+
5 rows in set (4.13 sec)