v7.5.7版本limit调整为100执行计划
SQL执行耗时：0.07秒
+------------------------------------+---------+---------+-----------+------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+------+
| id | estRows | actRows | task | access object | execution info | operator info | memory | disk |
+------------------------------------+---------+---------+-----------+------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+------+
| Projection_7 | 0.66 | 0 | root | | time:22.1ms, loops:1, RU:177.599821, 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 | 40.2 KB | N/A |
| └─TopN_9 | 0.66 | 0 | root | | time:22.1ms, loops:1 | dw_trade_order_seller_db.trade_order_seller.create_time_us:desc, offset:0, count:100 | 0 Bytes | N/A |
| └─IndexLookUp_24 | 0.66 | 0 | root | | time:22ms, loops:2, index_task: {total_time: 2.57ms, fetch_handle: 2.55ms, build: 2.18µs, wait: 12µs}, table_task: {total_time: 66.2ms, num: 4, concurrency: 5}, next: {wait_index: 1.08ms, wait_table_lookup_build: 1ms, wait_table_lookup_resp: 19.9ms} | | 20.8 KB | N/A |
| ├─IndexRangeScan_20(Build) | 62.79 | 892 | cop[tikv] | table:trade_order_seller, index:idx_selid_status_close_time(seller_id, sub_order_status, close_time) | time:2.5ms, loops:7, cop_task: {num: 3, max: 906.6µs, min: 646.5µs, avg: 819.9µs, p95: 906.6µs, max_proc_keys: 480, p95_proc_keys: 480, tot_proc: 954.9µs, tot_wait: 192.1µs, copr_cache_hit_ratio: 0.00, build_task_duration: 24.6µs, max_distsql_concurrency: 1}, rpc_info:{Cop:{num_rpc:3, total_time:2.42ms}}, tikv_task:{proc max:0s, min:0s, avg: 0s, p80:0s, p95:0s, iters:10, tasks:3}, scan_detail: {total_process_keys: 892, total_process_keys_size: 57088, total_keys: 898, get_snapshot_time: 63.6µs, rocksdb: {key_skipped_count: 895, block: {cache_hit_count: 30, read_count: 1, read_byte: 19.1 KB, read_time: 13.5µs}}} | range:(1572320533 8010 2025-08-18 21:03:25.687,1572320533 8010 +inf], keep order:false | N/A | N/A |
| └─TopN_23(Probe) | 0.66 | 0 | cop[tikv] | | time:62.2ms, loops:4, cop_task: {num: 838, max: 15.1ms, min: 0s, avg: 995.7µs, p95: 5.65ms, max_proc_keys: 3, p95_proc_keys: 2, tot_proc: 775.2ms, tot_wait: 964.7ms, copr_cache_hit_ratio: 0.00, build_task_duration: 3.32ms, max_distsql_concurrency: 1, max_extra_concurrency: 33, store_batch_num: 635}, rpc_info:{Cop:{num_rpc:203, total_time:832.3ms}}, tikv_task:{proc max:11ms, min:0s, avg: 949.9µs, p80:1ms, p95:3ms, iters:838, tasks:838}, scan_detail: {total_process_keys: 892, total_process_keys_size: 5986147, total_keys: 1756, get_snapshot_time: 765.2ms, rocksdb: {key_skipped_count: 864, block: {cache_hit_count: 12780, read_count: 122, read_byte: 1.42 MB, read_time: 1.49ms}}} | dw_trade_order_seller_db.trade_order_seller.create_time_us:desc, offset:0, count:100 | N/A | N/A |
| └─Selection_22 | 0.66 | 0 | cop[tikv] | | tikv_task:{proc max:7ms, min:0s, avg: 653.9µs, p80:1ms, p95:1ms, iters:838, tasks:838} | 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_21 | 62.79 | 892 | cop[tikv] | table:trade_order_seller | tikv_task:{proc max:7ms, min:0s, avg: 643.2µs, p80:1ms, p95:1ms, iters:838, tasks:838} | keep order:false | N/A | N/A |
+------------------------------------+---------+---------+-----------+--------------------------------------