1 of 1
CDR ID State Changes
12549 user_defined => {"icon": "steam/games/icon_tf2", "icon2": "steam/games/icon_tf2", "order": "1", "state": "eStateUnAvailable", "gamedir": "tf_beta", "homepage": "http: //www.half-life2.com", "NoServers": "0", "developer": "Valve", "sourcegame": "1", "primarycache": "522", "primarycache_linux": "527", "vacmodulecache": "202", "vacmacmodulecache": "160", "GameManualURL": "http: //store.steampowered.com/manual/440/", "serverbrowsername": "Team Fortress 2 Beta", "vacmodulefilename": "sourceinit.dat", "RequiresSSE": "1", "LoadAllBeforeLaunch": "1", "ValidOSList": "windows, macos, linux"}
10986 sub_count => 59
10582 sub_count => 58
9095 sub_count => 54
8887 sub_count => 53
8767 sub_count => 52
8750 launch_options => [{"description": "Default", "commandLine": "hl2 -game tf_beta -steam", "iconIndex": 0, "noDesktopShortcut": false, "noStartMenuShortcut": false, "longRunningUnattended": false, "platform": "windows"}, {"description": "default", "commandLine": "hl2_osx -game tf_beta -steam", "iconIndex": 0, "noDesktopShortcut": false, "noStartMenuShortcut": false, "longRunningUnattended": false, "platform": "macos"}, {"description": "Default", "commandLine": "hl2.sh -game tf_beta -steam", "iconIndex": 0, "noDesktopShortcut": false, "noStartMenuShortcut": false, "longRunningUnattended": false, "platform": "linux"}], user_defined => {"icon": "steam/games/icon_tf2", "icon2": "steam/games/icon_tf2", "order": "1", "state": "eStateAvailable", "gamedir": "tf_beta", "homepage": "http: //www.half-life2.com", "NoServers": "0", "developer": "Valve", "sourcegame": "1", "primarycache": "522", "primarycache_linux": "527", "vacmodulecache": "202", "vacmacmodulecache": "160", "GameManualURL": "http: //store.steampowered.com/manual/440/", "serverbrowsername": "Team Fortress 2 Beta", "vacmodulefilename": "sourceinit.dat", "RequiresSSE": "1", "LoadAllBeforeLaunch": "1", "ValidOSList": "windows, macos, linux"}
6548 sub_count => 51
5179 sub_count => 49
3075 sub_count => 47
1 Created
1 of 1

(default) 6 queries took 4 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `app_state_capture`21211
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';111
3SELECT `Application`.`app_id`, `Application`.`name`, `Application`.`install_dir`, `Application`.`min_cache_size`, `Application`.`max_cache_size`, `Application`.`launch_options`, `Application`.`on_first_launch`, `Application`.`is_bandwidth_greedy`, `Application`.`current_version_id`, `Application`.`trickle_version_id`, `Application`.`user_defined`, `Application`.`beta_version_password`, `Application`.`beta_version_id`, `Application`.`legacy_install_dir`, `Application`.`skip_mfp_overwrite`, `Application`.`use_filesystem_dvr`, `Application`.`manifest_only`, `Application`.`app_of_manifest_only`, `Application`.`sub_count`, `Application`.`date_updated` FROM `app` AS `Application` WHERE `Application`.`app_id` = 520 LIMIT 1110
4SELECT COUNT(*) AS `count` FROM `app_state_capture` AS `AppStateCapture` WHERE `app_id` = 520 110
5SELECT `AppStateCapture`.`cdr_id`, `AppStateCapture`.`created`, `AppStateCapture`.`app_id`, `AppStateCapture`.`name`, `AppStateCapture`.`install_dir`, `AppStateCapture`.`min_cache_size`, `AppStateCapture`.`max_cache_size`, `AppStateCapture`.`launch_options`, `AppStateCapture`.`on_first_launch`, `AppStateCapture`.`is_bandwidth_greedy`, `AppStateCapture`.`current_version_id`, `AppStateCapture`.`trickle_version_id`, `AppStateCapture`.`user_defined`, `AppStateCapture`.`beta_version_password`, `AppStateCapture`.`beta_version_id`, `AppStateCapture`.`legacy_install_dir`, `AppStateCapture`.`skip_mfp_overwrite`, `AppStateCapture`.`use_filesystem_dvr`, `AppStateCapture`.`manifest_only`, `AppStateCapture`.`app_of_manifest_only`, `AppStateCapture`.`sub_count` FROM `app_state_capture` AS `AppStateCapture` WHERE `app_id` = 520 ORDER BY `AppStateCapture`.`cdr_id` desc LIMIT 10011111
6SHOW FULL COLUMNS FROM `cdr`771