【TiDB 使用环境】生产环境
【TiDB 版本】v7.5.7
【遇到的问题：问题现象及影响】
同一SQL，v7.5.7版本执行计划与v5.3.3版本差异较大，且v7.5.7版本选择了错误的索引。
如果将limit10000改成limit 200以内，v7.5.7版本可以选择正确的索引。
备注：重新收集统计信息也没有效果。
表结构
PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */,
UNIQUE KEY `idx_sub_order_no` (`sub_order_no`),
KEY `idx_order_no` (`order_no`),
KEY `modify_time` (`modify_time`),
KEY `idx_seller_id_modifytime_create_time` (`seller_id`,`modify_time`,`create_time`),
KEY `idx_delivery_no` (`delivery_no`),
KEY `idx_seller_id_create_time_us` (`seller_id`,`create_time_us`),
KEY `seller_id` (`seller_id`,`sub_order_status`,`delivery_deadline`),
KEY `idx_selid_status_type_mtime` (`seller_id`,`sub_order_status`,`biz_type`,`modify_time`),
KEY `idx_selid_status_type_ctimes` (`seller_id`,`sub_order_status`,`biz_type`,`create_time_us`),
KEY `idx_selid_status_close_time` (`seller_id`,`sub_order_status`,`close_time`),
KEY `idx_sku_id_seller_id_create_time_us` (`sku_id`,`seller_id`,`create_time_us`),
KEY `idx_selid_confirmed_type_status_ctimes` (`seller_id`,`receive_address_confirmed`,`biz_type`,`sub_order_status`,`create_time_us`)
SQL语句
/*DW: primary=true :DW*/
SELECT
id,
order_no,
sub_order_no,
biz_type,
biz_channel,
biz_code,
biz_id,
abs(sub_order_status) AS sub_order_status,
buyer_id,
buyer_name,
seller_id,
seller_name,
pay_amount,
discount_amount,
inventory_id,
spu_id,
sku_id,
sku_title,
sku_price,
sku_count,
buyer_note,
deposit_amount,
poundage_amount,
poundage_info,
item_info,
close_type,
close_time,
feature,
is_del,
create_time,
modify_time,
product_amount,
freight_amount,
sku_logo,
seller_note,
seller_address_info,
seller_address_back,
merchant_info,
repository_address,
delivery_deadline,
tab_tag,
flag,
relation_info,
create_time_us,
seller_feature,
seller_type,
delivery_start_time,
delivery_no,
warehouse_code,
warehouse_address_id,
down_payment_time,
balance_payment_time,
merchant_accept,
delivery_mode,
sub_is_del,
order_status,
order_deliver_status,
order_product_amount,
order_freight_amount,
order_pay_amount,
order_discount_amount,
buyer_address_info,
order_platform,
order_source_name,
order_feature,
order_flag,
order_relation_info,
order_is_del,
oversea_tax,
platform_received_time,
trade_close_reason_id,
seller_bidding_no,
sub_order_modify_time,
main_order_modify_time,
logistics_delivery_deadline,
virtual_delivery_type,
sale_type,
seller_earliest_logistic_delivery_time,
seller_earliest_logistic_collect_time,
seller_earliest_logistic_no,
seller_earliest_logistic_modify_time,
seller_earliest_logistic_express_no,
seller_earliest_logistic_express_status,
receive_address_confirmed
FROM
trade_order_seller
WHERE
seller_id = 1572320533
AND sub_order_status = 8010
AND close_time > '2025-08-18 21:03:25.687'
AND close_type IN (13, 14)
AND create_time_us < '2025-08-11 17:40:06.581'
ORDER BY
create_time_us DESC
LIMIT
10000;
v5.3.3版本执行计划
SQL执行耗时：0.01秒
+------------------------------------+---------+---------+-----------+------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+------+
| id | estRows | actRows | task | access object | execution info | operator info | memory | disk |
+------------------------------------+---------+---------+-----------+------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+------+
| Projection_7 | 0.50 | 0 | root | | time:72.4ms, loops:1, Concurrency:OFF | dw_trade_order_seller_db.trade_order_seller.id, dw_trade_order_seller_db.trade_order_seller.order_no, dw_trade_order_seller_db.trade_order_seller.sub_order_no, dw_trade_order_seller_db.trade_order_seller.biz_type, dw_trade_order_seller_db.trade_order_seller.biz_channel, dw_trade_order_seller_db.trade_order_seller.biz_code, dw_trade_order_seller_db.trade_order_seller.biz_id, abs(dw_trade_order_seller_db.trade_order_seller.sub_order_status)->Column#85, dw_trade_order_seller_db.trade_order_seller.buyer_id, dw_trade_order_seller_db.trade_order_seller.buyer_name, dw_trade_order_seller_db.trade_order_seller.seller_id, dw_trade_order_seller_db.trade_order_seller.seller_name, dw_trade_order_seller_db.trade_order_seller.pay_amount, dw_trade_order_seller_db.trade_order_seller.discount_amount, dw_trade_order_seller_db.trade_order_seller.inventory_id, dw_trade_order_seller_db.trade_order_seller.spu_id, dw_trade_order_seller_db.trade_order_seller.sku_id, dw_trade_order_seller_db.trade_order_seller.sku_title, dw_trade_order_seller_db.trade_order_seller.sku_price, dw_trade_order_seller_db.trade_order_seller.sku_count, dw_trade_order_seller_db.trade_order_seller.buyer_note, dw_trade_order_seller_db.trade_order_seller.deposit_amount, dw_trade_order_seller_db.trade_order_seller.poundage_amount, dw_trade_order_seller_db.trade_order_seller.poundage_info, dw_trade_order_seller_db.trade_order_seller.item_info, dw_trade_order_seller_db.trade_order_seller.close_type, dw_trade_order_seller_db.trade_order_seller.close_time, dw_trade_order_seller_db.trade_order_seller.feature, dw_trade_order_seller_db.trade_order_seller.is_del, dw_trade_order_seller_db.trade_order_seller.create_time, dw_trade_order_seller_db.trade_order_seller.modify_time, dw_trade_order_seller_db.trade_order_seller.product_amount, dw_trade_order_seller_db.trade_order_seller.freight_amount, dw_trade_order_seller_db.trade_order_seller.sku_logo, dw_trade_order_seller_db.trade_order_seller.seller_note, dw_trade_order_seller_db.trade_order_seller.seller_address_info, dw_trade_order_seller_db.trade_order_seller.seller_address_back, dw_trade_order_seller_db.trade_order_seller.merchant_info, dw_trade_order_seller_db.trade_order_seller.repository_address, dw_trade_order_seller_db.trade_order_seller.delivery_deadline, dw_trade_order_seller_db.trade_order_seller.tab_tag, dw_trade_order_seller_db.trade_order_seller.flag, dw_trade_order_seller_db.trade_order_seller.relation_info, dw_trade_order_seller_db.trade_order_seller.create_time_us, dw_trade_order_seller_db.trade_order_seller.seller_feature, dw_trade_order_seller_db.trade_order_seller.seller_type, dw_trade_order_seller_db.trade_order_seller.delivery_start_time, dw_trade_order_seller_db.trade_order_seller.delivery_no, dw_trade_order_seller_db.trade_order_seller.warehouse_code, dw_trade_order_seller_db.trade_order_seller.warehouse_address_id, dw_trade_order_seller_db.trade_order_seller.down_payment_time, dw_trade_order_seller_db.trade_order_seller.balance_payment_time, dw_trade_order_seller_db.trade_order_seller.merchant_accept, dw_trade_order_seller_db.trade_order_seller.delivery_mode, dw_trade_order_seller_db.trade_order_seller.sub_is_del, dw_trade_order_seller_db.trade_order_seller.order_status, dw_trade_order_seller_db.trade_order_seller.order_deliver_status, dw_trade_order_seller_db.trade_order_seller.order_product_amount, dw_trade_order_seller_db.trade_order_seller.order_freight_amount, dw_trade_order_seller_db.trade_order_seller.order_pay_amount, dw_trade_order_seller_db.trade_order_seller.order_discount_amount, dw_trade_order_seller_db.trade_order_seller.buyer_address_info, dw_trade_order_seller_db.trade_order_seller.order_platform, dw_trade_order_seller_db.trade_order_seller.order_source_name, dw_trade_order_seller_db.trade_order_seller.order_feature, dw_trade_order_seller_db.trade_order_seller.order_flag, dw_trade_order_seller_db.trade_order_seller.order_relation_info, dw_trade_order_seller_db.trade_order_seller.order_is_del, dw_trade_order_seller_db.trade_order_seller.oversea_tax, dw_trade_order_seller_db.trade_order_seller.platform_received_time, dw_trade_order_seller_db.trade_order_seller.trade_close_reason_id, dw_trade_order_seller_db.trade_order_seller.seller_bidding_no, dw_trade_order_seller_db.trade_order_seller.sub_order_modify_time, dw_trade_order_seller_db.trade_order_seller.main_order_modify_time, dw_trade_order_seller_db.trade_order_seller.logistics_delivery_deadline, dw_trade_order_seller_db.trade_order_seller.virtual_delivery_type, dw_trade_order_seller_db.trade_order_seller.sale_type, dw_trade_order_seller_db.trade_order_seller.seller_earliest_logistic_delivery_time, dw_trade_order_seller_db.trade_order_seller.seller_earliest_logistic_collect_time, dw_trade_order_seller_db.trade_order_seller.seller_earliest_logistic_no, dw_trade_order_seller_db.trade_order_seller.seller_earliest_logistic_modify_time, dw_trade_order_seller_db.trade_order_seller.seller_earliest_logistic_express_no, dw_trade_order_seller_db.trade_order_seller.seller_earliest_logistic_express_status, dw_trade_order_seller_db.trade_order_seller.receive_address_confirmed | 39.5 KB | N/A |
| └─TopN_10 | 0.50 | 0 | root | | time:72.4ms, loops:1 | dw_trade_order_seller_db.trade_order_seller.create_time_us:desc, offset:0, count:10000 | 0 Bytes | N/A |
| └─IndexLookUp_48 | 0.50 | 0 | root | | time:72.3ms, loops:2, index_task: {total_time: 1.18ms, fetch_handle: 1.17ms, build: 1.08µs, wait: 4.97µs}, table_task: {total_time: 71.1ms, num: 1, concurrency: 5} | | 22.0 KB | N/A |
| ├─IndexRangeScan_45(Build) | 49.79 | 893 | cop[tikv] | table:trade_order_seller, index:idx_selid_status_close_time(seller_id, sub_order_status, close_time) | time:1.11ms, loops:3, cop_task: {num: 1, max: 1.06ms, proc_keys: 893, tot_proc: 1ms, rpc_num: 1, rpc_time: 1.05ms, copr_cache_hit_ratio: 0.00}, tikv_task:{time:1ms, loops:5}, scan_detail: {total_process_keys: 893, total_process_keys_size: 57152, total_keys: 894, rocksdb: {delete_skipped_count: 1, key_skipped_count: 894, block: {cache_hit_count: 10, read_count: 0, read_byte: 0 Bytes}}} | range:(1572320533 8010 2025-08-18 21:03:25.687,1572320533 8010 +inf], keep order:false | N/A | N/A |
| └─Selection_47(Probe) | 0.50 | 0 | cop[tikv] | | time:48.2ms, loops:1, cop_task: {num: 861, max: 5.17ms, min: 417.4µs, avg: 803.3µs, p95: 1.39ms, max_proc_keys: 3, p95_proc_keys: 1, tot_proc: 207ms, tot_wait: 149ms, rpc_num: 861, rpc_time: 684.2ms, copr_cache_hit_ratio: 0.00}, tikv_task:{proc max:1ms, min:0s, p80:1ms, p95:1ms, iters:861, tasks:861}, scan_detail: {total_process_keys: 892, total_process_keys_size: 5986380, total_keys: 892, rocksdb: {delete_skipped_count: 0, key_skipped_count: 0, block: {cache_hit_count: 13892, read_count: 16, read_byte: 159.4 KB}}} | in(dw_trade_order_seller_db.trade_order_seller.close_type, 13, 14), lt(dw_trade_order_seller_db.trade_order_seller.create_time_us, 2025-08-11 17:40:06.581000) | N/A | N/A |
| └─TableRowIDScan_46 | 49.79 | 893 | cop[tikv] | table:trade_order_seller | tikv_task:{proc max:1ms, min:0s, p80:0s, p95:1ms, iters:861, tasks:861} | keep order:false | N/A | N/A |
+------------------------------------+---------+---------+-----------+------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+------+
6 rows in set (0.08 sec)
v7.5.7版本执行计划
SQL执行耗时：4.4秒
+------------------------------------+---------+---------+-----------+-----------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+------+
| id | estRows | actRows | task | access object | execution info | operator info | memory | disk |
+------------------------------------+---------+---------+-----------+-----------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+------+
| Projection_7 | 0.66 | 0 | root | | time:681.8ms, loops:1, RU:30164.179480, Concurrency:OFF | dw_trade_order_seller_db.trade_order_seller.id, dw_trade_order_seller_db.trade_order_seller.order_no, dw_trade_order_seller_db.trade_order_seller.sub_order_no, dw_trade_order_seller_db.trade_order_seller.biz_type, dw_trade_order_seller_db.trade_order_seller.biz_channel, dw_trade_order_seller_db.trade_order_seller.biz_code, dw_trade_order_seller_db.trade_order_seller.biz_id, abs(dw_trade_order_seller_db.trade_order_seller.sub_order_status)->Column#85, dw_trade_order_seller_db.trade_order_seller.buyer_id, dw_trade_order_seller_db.trade_order_seller.buyer_name, dw_trade_order_seller_db.trade_order_seller.seller_id, dw_trade_order_seller_db.trade_order_seller.seller_name, dw_trade_order_seller_db.trade_order_seller.pay_amount, dw_trade_order_seller_db.trade_order_seller.discount_amount, dw_trade_order_seller_db.trade_order_seller.inventory_id, dw_trade_order_seller_db.trade_order_seller.spu_id, dw_trade_order_seller_db.trade_order_seller.sku_id, dw_trade_order_seller_db.trade_order_seller.sku_title, dw_trade_order_seller_db.trade_order_seller.sku_price, dw_trade_order_seller_db.trade_order_seller.sku_count, dw_trade_order_seller_db.trade_order_seller.buyer_note, dw_trade_order_seller_db.trade_order_seller.deposit_amount, dw_trade_order_seller_db.trade_order_seller.poundage_amount, dw_trade_order_seller_db.trade_order_seller.poundage_info, dw_trade_order_seller_db.trade_order_seller.item_info, dw_trade_order_seller_db.trade_order_seller.close_type, dw_trade_order_seller_db.trade_order_seller.close_time, dw_trade_order_seller_db.trade_order_seller.feature, dw_trade_order_seller_db.trade_order_seller.is_del, dw_trade_order_seller_db.trade_order_seller.create_time, dw_trade_order_seller_db.trade_order_seller.modify_time, dw_trade_order_seller_db.trade_order_seller.product_amount, dw_trade_order_seller_db.trade_order_seller.freight_amount, dw_trade_order_seller_db.trade_order_seller.sku_logo, dw_trade_order_seller_db.trade_order_seller.seller_note, dw_trade_order_seller_db.trade_order_seller.seller_address_info, dw_trade_order_seller_db.trade_order_seller.seller_address_back, dw_trade_order_seller_db.trade_order_seller.merchant_info, dw_trade_order_seller_db.trade_order_seller.repository_address, dw_trade_order_seller_db.trade_order_seller.delivery_deadline, dw_trade_order_seller_db.trade_order_seller.tab_tag, dw_trade_order_seller_db.trade_order_seller.flag, dw_trade_order_seller_db.trade_order_seller.relation_info, dw_trade_order_seller_db.trade_order_seller.create_time_us, dw_trade_order_seller_db.trade_order_seller.seller_feature, dw_trade_order_seller_db.trade_order_seller.seller_type, dw_trade_order_seller_db.trade_order_seller.delivery_start_time, dw_trade_order_seller_db.trade_order_seller.delivery_no, dw_trade_order_seller_db.trade_order_seller.warehouse_code, dw_trade_order_seller_db.trade_order_seller.warehouse_address_id, dw_trade_order_seller_db.trade_order_seller.down_payment_time, dw_trade_order_seller_db.trade_order_seller.balance_payment_time, dw_trade_order_seller_db.trade_order_seller.merchant_accept, dw_trade_order_seller_db.trade_order_seller.delivery_mode, dw_trade_order_seller_db.trade_order_seller.sub_is_del, dw_trade_order_seller_db.trade_order_seller.order_status, dw_trade_order_seller_db.trade_order_seller.order_deliver_status, dw_trade_order_seller_db.trade_order_seller.order_product_amount, dw_trade_order_seller_db.trade_order_seller.order_freight_amount, dw_trade_order_seller_db.trade_order_seller.order_pay_amount, dw_trade_order_seller_db.trade_order_seller.order_discount_amount, dw_trade_order_seller_db.trade_order_seller.buyer_address_info, dw_trade_order_seller_db.trade_order_seller.order_platform, dw_trade_order_seller_db.trade_order_seller.order_source_name, dw_trade_order_seller_db.trade_order_seller.order_feature, dw_trade_order_seller_db.trade_order_seller.order_flag, dw_trade_order_seller_db.trade_order_seller.order_relation_info, dw_trade_order_seller_db.trade_order_seller.order_is_del, dw_trade_order_seller_db.trade_order_seller.oversea_tax, dw_trade_order_seller_db.trade_order_seller.platform_received_time, dw_trade_order_seller_db.trade_order_seller.trade_close_reason_id, dw_trade_order_seller_db.trade_order_seller.seller_bidding_no, dw_trade_order_seller_db.trade_order_seller.sub_order_modify_time, dw_trade_order_seller_db.trade_order_seller.main_order_modify_time, dw_trade_order_seller_db.trade_order_seller.logistics_delivery_deadline, dw_trade_order_seller_db.trade_order_seller.virtual_delivery_type, dw_trade_order_seller_db.trade_order_seller.sale_type, dw_trade_order_seller_db.trade_order_seller.seller_earliest_logistic_delivery_time, dw_trade_order_seller_db.trade_order_seller.seller_earliest_logistic_collect_time, dw_trade_order_seller_db.trade_order_seller.seller_earliest_logistic_no, dw_trade_order_seller_db.trade_order_seller.seller_earliest_logistic_modify_time, dw_trade_order_seller_db.trade_order_seller.seller_earliest_logistic_express_no, dw_trade_order_seller_db.trade_order_seller.seller_earliest_logistic_express_status, dw_trade_order_seller_db.trade_order_seller.receive_address_confirmed | 3.80 MB | N/A |
| └─Limit_13 | 0.66 | 0 | root | | time:681.8ms, loops:1 | offset:0, count:10000 | N/A | N/A |
| └─IndexLookUp_43 | 0.66 | 0 | root | | time:681.8ms, loops:1, index_task: {total_time: 389.6ms, fetch_handle: 159.6ms, build: 25.9ms, wait: 204.1ms}, table_task: {total_time: 3s, num: 13, concurrency: 5}, next: {wait_index: 11.5ms, wait_table_lookup_build: 30ms, wait_table_lookup_resp: 640.3ms} | | 2.15 MB | N/A |
| ├─IndexRangeScan_40(Build) | 428.36 | 214866 | cop[tikv] | table:trade_order_seller, index:idx_seller_id_create_time_us(seller_id, create_time_us) | time:149.2ms, loops:56, cop_task: {num: 12, max: 51.8ms, min: 1.05ms, avg: 17.9ms, p95: 51.8ms, max_proc_keys: 50144, p95_proc_keys: 50144, tot_proc: 185ms, tot_wait: 1.24ms, copr_cache_hit_ratio: 0.00, build_task_duration: 28.9µs, max_distsql_concurrency: 1}, rpc_info:{Cop:{num_rpc:12, total_time:214.5ms}}, tikv_task:{proc max:50ms, min:0s, avg: 16.3ms, p80:34ms, p95:50ms, iters:257, tasks:12}, scan_detail: {total_process_keys: 214866, total_process_keys_size: 11817630, total_keys: 214884, get_snapshot_time: 796.7µs, rocksdb: {key_skipped_count: 214883, block: {cache_hit_count: 476, read_count: 1, read_byte: 21.8 KB, read_time: 20µs}}} | range:[1572320533 -inf,1572320533 2025-08-11 17:40:06.581000), keep order:true, desc | N/A | N/A |
| └─Selection_42(Probe) | 0.66 | 0 | cop[tikv] | | time:2.54s, loops:13, cop_task: {num: 96386, max: 171.8ms, min: 0s, avg: 3.68ms, p95: 10.5ms, max_proc_keys: 35, p95_proc_keys: 5, tot_proc: 47.9s, tot_wait: 8m19.6s, copr_cache_hit_ratio: 0.00, build_task_duration: 378.9ms, max_distsql_concurrency: 15, max_extra_concurrency: 320, store_batch_num: 68977}, rpc_info:{Cop:{num_rpc:27434, total_time:5m54.2s}, rpc_errors:{server_is_busy:25}}, tikv_task:{proc max:0s, min:0s, avg: 1.42ms, p80:1ms, p95:2ms, iters:96564, tasks:96386}, scan_detail: {total_process_keys: 214804, total_process_keys_size: 1266370733, total_keys: 374076, get_snapshot_time: 5m44.9s, rocksdb: {delete_skipped_count: 112808, key_skipped_count: 160914, block: {cache_hit_count: 2567006, read_count: 80981, read_byte: 791.0 MB, read_time: 12.1s}}} | eq(dw_trade_order_seller_db.trade_order_seller.sub_order_status, 8010), gt(dw_trade_order_seller_db.trade_order_seller.close_time, 2025-08-18 21:03:25.687000), in(dw_trade_order_seller_db.trade_order_seller.close_type, 13, 14) | N/A | N/A |
| └─TableRowIDScan_41 | 428.36 | 214866 | cop[tikv] | table:trade_order_seller | tikv_task:{proc max:0s, min:0s, avg: 1.42ms, p80:1ms, p95:3ms, iters:96564, tasks:96386} | keep order:false | N/A | N/A |
+------------------------------------+---------+---------+-----------+-----------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+------+
6 rows in set (0.69 sec)
如果ananlyze了还这样，是不是索引数据有问题，admin check index 试试，