SHOW FULL COLUMNS FROM `games` [ RunTime:0.000925s ]
SELECT * FROM `games` WHERE `is_active` = 1 AND `project_type` = 'agency' ORDER BY `name` ASC [ RunTime:0.000703s ]
SHOW FULL COLUMNS FROM `player_records` [ RunTime:0.000703s ]
SELECT `game_id`,`player_count` FROM `player_records` WHERE `game_id` IN (31,28,53,8,18,41,24,29,25,63,55,15,14,46,40,17,44,56,43,11,49,26,52,34,36,61,39,35,54,16,30,10,12,13,21,42,9,62,66,27,65,64,33,32) AND ( recorded_at = (SELECT MAX(recorded_at) FROM player_records p2 WHERE p2.game_id = player_records.game_id) ) [ RunTime:0.000721s ]
