TIDB 的 执行计划是:
mysql> EXPLAIN SELECT
-> id, flow_order_no, winning_losing, currency_type, bet_money,
-> order_status, created_at, game_code, game_name, member_id,
-> member_account, merchant_id, merchant_code, merchant_name, bet_at
-> FROM
-> anchor_bet_record
-> FORCE INDEX (idx_optimized_query)
-> WHERE
-> merchant_code = '5273'
-> AND member_account = 'xk139880305'
-> AND game_code = 'bjl'
-> AND created_at > '2025-09-28 09:32:32.953'
-> AND is_deleted = 0
-> ORDER BY
-> created_at ASC
-> LIMIT 10;
+------------------------------------+-----------+-----------+------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id | estRows | task | access object | operator info |
+------------------------------------+-----------+-----------+------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Projection_7 | 10.00 | root | | anchor_game.anchor_bet_record.id, anchor_game.anchor_bet_record.flow_order_no, anchor_game.anchor_bet_record.winning_losing, anchor_game.anchor_bet_record.currency_type, anchor_game.anchor_bet_record.bet_money, anchor_game.anchor_bet_record.order_status, anchor_game.anchor_bet_record.created_at, anchor_game.anchor_bet_record.game_code, anchor_game.anchor_bet_record.game_name, anchor_game.anchor_bet_record.member_id, anchor_game.anchor_bet_record.member_account, anchor_game.anchor_bet_record.merchant_id, anchor_game.anchor_bet_record.merchant_code, anchor_game.anchor_bet_record.merchant_name, anchor_game.anchor_bet_record.bet_at |
| └─TopN_9 | 10.00 | root | | anchor_game.anchor_bet_record.created_at, offset:0, count:10 |
| └─IndexLookUp_20 | 10.00 | root | | |
| ├─IndexRangeScan_13(Build) | 473110.00 | cop[tikv] | table:anchor_bet_record, index:idx_merchant_bet(merchant_code, bet_at) | range:["5273","5273"], keep order:false |
| └─TopN_19(Probe) | 10.00 | cop[tikv] | | anchor_game.anchor_bet_record.created_at, offset:0, count:10 |
| └─Selection_15 | 910.05 | cop[tikv] | | eq(anchor_game.anchor_bet_record.game_code, "bjl"), eq(anchor_game.anchor_bet_record.is_deleted, 0), eq(anchor_game.anchor_bet_record.member_account, "xk139880305"), gt(anchor_game.anchor_bet_record.created_at, 2025-09-28 09:32:32.953000) |
| └─TableRowIDScan_14 | 473110.00 | cop[tikv] | table:anchor_bet_record | keep order:false |
+------------------------------------+-----------+-----------+------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
7 rows in set (0.01 sec)
mysql>
mysql>
mysql> //////////////////////////////////////////// ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 1 near "////////////////////////////////////////////"
mysql>
mysql> EXPLAIN SELECT
-> id, flow_order_no, winning_losing, currency_type, bet_money,
-> order_status, created_at, game_code, game_name, member_id,
-> member_account, merchant_id, merchant_code, merchant_name, bet_at
-> FROM
-> anchor_bet_record
->
-> WHERE
-> merchant_code = '5273'
-> AND member_account = 'xk139880305'
-> AND game_code = 'bjl'
-> AND created_at > '2025-09-28 09:32:32.953'
-> AND is_deleted = 0
-> ORDER BY
-> created_at ASC
-> LIMIT 10;
+------------------------------------+-----------+-----------+------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id | estRows | task | access object | operator info |
+------------------------------------+-----------+-----------+------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Projection_7 | 10.00 | root | | anchor_game.anchor_bet_record.id, anchor_game.anchor_bet_record.flow_order_no, anchor_game.anchor_bet_record.winning_losing, anchor_game.anchor_bet_record.currency_type, anchor_game.anchor_bet_record.bet_money, anchor_game.anchor_bet_record.order_status, anchor_game.anchor_bet_record.created_at, anchor_game.anchor_bet_record.game_code, anchor_game.anchor_bet_record.game_name, anchor_game.anchor_bet_record.member_id, anchor_game.anchor_bet_record.member_account, anchor_game.anchor_bet_record.merchant_id, anchor_game.anchor_bet_record.merchant_code, anchor_game.anchor_bet_record.merchant_name, anchor_game.anchor_bet_record.bet_at |
| └─TopN_9 | 10.00 | root | | anchor_game.anchor_bet_record.created_at, offset:0, count:10 |
| └─IndexLookUp_20 | 10.00 | root | | |
| ├─IndexRangeScan_13(Build) | 473110.00 | cop[tikv] | table:anchor_bet_record, index:idx_merchant_bet(merchant_code, bet_at) | range:["5273","5273"], keep order:false |
| └─TopN_19(Probe) | 10.00 | cop[tikv] | | anchor_game.anchor_bet_record.created_at, offset:0, count:10 |
| └─Selection_15 | 910.05 | cop[tikv] | | eq(anchor_game.anchor_bet_record.game_code, "bjl"), eq(anchor_game.anchor_bet_record.is_deleted, 0), eq(anchor_game.anchor_bet_record.member_account, "xk139880305"), gt(anchor_game.anchor_bet_record.created_at, 2025-09-28 09:32:32.953000) |
| └─TableRowIDScan_14 | 473110.00 | cop[tikv] | table:anchor_bet_record | keep order:false |
+------------------------------------+-----------+-----------+------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
7 rows in set (0.00 sec)
mysql> 如何优化为最优的执行计划输出