【 TiDB 使用环境】生产环境
【 TiDB 版本】6.5.1
sql：
id task estRows operator info actRows execution info memory disk
Projection_8 root 500 mall_qianchuan.qc_material.id, mall_qianchuan.qc_material.name, mall_qianchuan.qc_material.url, mall_qianchuan.qc_material.cover_url, mall_qianchuan.qc_material.duration, mall_qianchuan.qc_material.height, mall_qianchuan.qc_material.width, mall_qianchuan.qc_material.image_mode, mall_qianchuan.qc_material.inefficient 1 time:7.87s, loops:2, Concurrency:OFF 159.9 KB N/A
└─Limit_14 root 500 offset:0, count:500 1 time:7.87s, loops:2 N/A N/A
└─IndexLookUp_35 root 500 1 time:7.87s, loops:2, index_task: {total_time: 4.89s, fetch_handle: 324ms, build: 84.6ms, wait: 4.49s}, table_task: {total_time: 32.6s, num: 24, concurrency: 5}, next: {wait_index: 34.7ms, wait_table_lookup_build: 1.45ms, wait_table_lookup_resp: 7.83s} 3.63 MB N/A
├─IndexRangeScan_32(Build) cop[tikv] 8093.04 table:qc_material, index:merchant_id(merchant_id, create_time), range:[1402519596895268865,1402519596895268865], keep order:true, desc 395797 time:294ms, loops:393, cop_task: {num: 16, max: 973.8ms, min: 5.63ms, avg: 178.8ms, p95: 973.8ms, max_proc_keys: 50144, p95_proc_keys: 50144, tot_proc: 2.71s, tot_wait: 45ms, rpc_num: 16, rpc_time: 2.86s, copr_cache_hit_ratio: 0.00, distsql_concurrency: 15}, tikv_task:{proc max:967ms, min:1ms, avg: 169.5ms, p80:272ms, p95:967ms, iters:450, tasks:16}, scan_detail: {total_process_keys: 395797, total_process_keys_size: 21768835, total_keys: 395813, get_snapshot_time: 409.8µs, rocksdb: {delete_skipped_count: 2, key_skipped_count: 395814, block: {cache_hit_count: 206, read_count: 313, read_byte: 7.76 MB, read_time: 175.3ms}}} N/A N/A
└─Selection_34(Probe) cop[tikv] 500 eq(mall_qianchuan.qc_material.del_flag, 0), eq(mall_qianchuan.qc_material.inefficient, 0), eq(mall_qianchuan.qc_material.material_type, "VIDEO"), like(mall_qianchuan.qc_material.name, "%李红宇8.15素1_衍生_1%", 92) 1 time:32.4s, loops:25, cop_task: {num: 307, max: 3.6s, min: 472µs, avg: 419.5ms, p95: 1.46s, max_proc_keys: 5204, p95_proc_keys: 3264, tot_proc: 1m56.9s, tot_wait: 10.2s, rpc_num: 307, rpc_time: 2m8.8s, copr_cache_hit_ratio: 0.00, distsql_concurrency: 15}, tikv_task:{proc max:3.59s, min:0s, avg: 381.2ms, p80:694ms, p95:1.39s, iters:1511, tasks:307}, scan_detail: {total_process_keys: 395797, total_process_keys_size: 258454850, total_keys: 395814, get_snapshot_time: 1.59s, rocksdb: {key_skipped_count: 41, block: {cache_hit_count: 4829056, read_count: 7475, read_byte: 95.0 MB, read_time: 1.04s}}} N/A N/A
└─TableRowIDScan_33 cop[tikv] 8093.04 table:qc_material, keep order:false 395797 tikv_task:{proc max:3.59s, min:0s, avg: 381.1ms, p80:693ms, p95:1.39s, iters:1511, tasks:307} N/A N/A
，索引格式变成tableid_columnid_分词：rowid。 
就是不知道哪位大佬能搞
