``` EXPLAIN SELECT bt.id, bt.type, bt.NAME, bt.code_type, IF ( bt.code_type = 1, bt.CODE, '' ) code_level, bt.start_time, bt.end_time, s.user_account, s.game_id, s.game_name, s.server_name, s.game_player_id AS role_id, s.game_player_name AS role_name, s.cost, s.pay_time time, s.user_id, s.small_id, s.promote_account, CONCAT( bt.id, '-', s.game_id, '-', s.game_player_id ) `key` FROM `tab_bt_send` `bt` INNER JOIN ( -- 把大表过滤之后再连表查询 SELECT `s`.`id`, `s`.`user_account`, `s`.`game_id`, `s`.`game_name`, `s`.`server_name`, `s`.`game_player_id`, `s`.`game_player_name`, `s`.`cost`, `s`.`pay_time`, `s`.`user_id`, `s`.`small_id`, `s`.`promote_account` FROM `tab_spend` `s` WHERE `s`.`promote_id` IN ( 8, 10, 11, 22, 23, 24, 25, 51, 56 ) AND ( `s`.`pay_time` >= 1676649600 AND `s`.`pay_time` <= 1676995199 ) AND `s`.`pay_status` = 1 GROUP BY s.user_id, s.game_id, s.game_player_id ) `s` ON `s`.`game_id` = bt.game_id AND s.cost >= bt.pay_price AND s.cost <= bt.pay_max_price AND s.pay_time >= bt.start_time AND s.pay_time <= IF ( bt.end_time = 0, 17436047243, bt.end_time ) WHERE `bt`.`type` = '1' AND `bt`.`platform_type` = 0 AND `bt`.`is_del` = 0 AND `bt`.`status` = 1 GROUP BY bt.id, s.user_id, s.game_id, s.game_player_id ORDER BY `s`.`id` DESC LIMIT 0, 16 ```