两边表结构一样吗?
tidb里全表扫描
TableFullScan_1907 | 26477481.00 | cop[tikv] | table:m
TableFullScan_1910 | 1147772.00 | cop[tikv] | table:w
MySQL里主键?
| 1 | PRIMARY | m | NULL | ref | idx_NumericalOrder,idx_NumericalOrder_PigID,idx_NumericalOrder_BatchID_PigID,idx_NumericalOrder_PigHouseUnitID_PigID,idx_NumericalOrderDetail_IsIn,idx_NumericalOrder_IsIn_Abstract | idx_NumericalOrderDetail_IsIn | 8 | zhongguo_qla_business.w.NumericalOrderDetail | 1 | 100.00 | Using index condition; Using where |
| 1 | PRIMARY | w | NULL | ref | wm_warehousestockpigextend_NumericalOrderDetail_index,idx_Guid | idx_Guid | 108 | zhongguo_qla_business.s.Guid | 1 | 100.00 | NULL |