+------------------------------------+----------+-----------+--------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id | estRows | task | access object | operator info |
+------------------------------------+----------+-----------+--------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Projection_8 | 500.00 | root | | 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 |
| └─TopN_10 | 500.00 | root | | mall_qianchuan.qc_material.create_time:desc, offset:0, count:500 |
| └─IndexLookUp_24 | 500.00 | root | | |
| ├─TopN_23(Build) | 500.00 | cop[tikv] | | mall_qianchuan.qc_material.create_time:desc, offset:0, count:500 |
| │ └─Selection_22 | 37914.80 | cop[tikv] | | like(mall_qianchuan.qc_material.name, "%oppoa93%", 92) |
| │ └─IndexRangeScan_20 | 47393.50 | cop[tikv] | table:qc_material, index:idx_mid_mtype_inff_del_name_crt(merchant_id, material_type, inefficient, del_flag, name, create_time) | range:[1714530771000516609 "VIDEO" 0 0,1714530771000516609 "VIDEO" 0 0], keep order:false |
| └─TableRowIDScan_21(Probe) | 500.00 | cop[tikv] | table:qc_material | keep order:false |
+------------------------------------+----------+-----------+--------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
7 rows in set (0.00 sec)