SHOW FULL COLUMNS FROM `games` [ RunTime:0.000969s ]
SELECT * FROM `games` WHERE `is_active` = 1 ORDER BY `name` ASC [ RunTime:0.000662s ]
SHOW FULL COLUMNS FROM `player_records` [ RunTime:0.000772s ]
SELECT `game_id`,`player_count` FROM `player_records` WHERE `game_id` IN (7,31,1,23,28,48,53,8,18,59,41,24,29,25,63,55,45,15,14,46,50,19,40,17,6,44,51,56,43,11,49,37,38,26,52,34,36,58,57,3,61,39,35,4,5,54,16,2,30,47,10,12,13,21,42,9,62,66,22,20,27,65,64,33,60,32) AND ( recorded_at = (SELECT MAX(recorded_at) FROM player_records p2 WHERE p2.game_id = player_records.game_id) ) [ RunTime:0.000702s ]
