SHOW FULL COLUMNS FROM `games` [ RunTime:0.001059s ]
SELECT * FROM `games` WHERE `is_active` = 1 AND `project_type` = '发行' ORDER BY `name` ASC [ RunTime:0.000615s ]
SHOW FULL COLUMNS FROM `player_records` [ RunTime:0.000895s ]
SELECT `game_id`,`player_count` FROM `player_records` WHERE `game_id` IN (7,1,23,48,59,45,50,19,6,51,37,38,58,57,3,4,5,2,47,22,20,60) AND ( recorded_at = (SELECT MAX(recorded_at) FROM player_records p2 WHERE p2.game_id = player_records.game_id) ) [ RunTime:0.000505s ]