赞
踩
本文主要介绍下逆过程中会用到的一些adb命令.
该命令可以查看指定包名的数据库存储信息
用法: adb shell dumpsys dbinfo [pkgname]
Applications Database Info: ** Database info for pid 29729 [com.sohu.inputmethod.sogou] ** Connection pool for /data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou: Open: true Max connections: 4 Total execution time: 121 Configuration: openFlags=805306368, isLegacyCompatibilityWalEnabled=false, journalMode=, syncMode= Available primary connection: Connection #1: isPrimaryConnection: true onlyAllowReadOnlyOperations: false Most recently executed operations: 0: [2024-03-19 20:24:02.508] executeForCursorWindow took 0ms - succeeded, sql="PRAGMA database_list;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 1: [2024-03-19 20:24:02.508] executeForLong took 0ms - succeeded, sql="PRAGMA page_size;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 2: [2024-03-19 20:24:02.507] executeForLong took 0ms - succeeded, sql="PRAGMA page_count;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 3: [2024-03-19 20:21:01.559] execute took 0ms - succeeded, sql="COMMIT;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 4: [2024-03-19 20:21:01.559] executeForLastInsertedRowId took 0ms - succeeded, sql="INSERT INTO t_r_e (_appKey,_time,_length,_data )VALUES(?,?,?,?)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 5: [2024-03-19 20:21:01.559] execute took 0ms - succeeded, sql="BEGIN IMMEDIATE;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 6: [2024-03-19 20:20:59.673] execute took 0ms - succeeded, sql="COMMIT;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 7: [2024-03-19 20:20:59.672] executeForLastInsertedRowId took 0ms - succeeded, sql="INSERT INTO t_r_e (_appKey,_time,_length,_data )VALUES(?,?,?,?)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 8: [2024-03-19 20:20:59.672] execute took 1ms - succeeded, sql="BEGIN IMMEDIATE;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 9: [2024-03-19 20:20:49.673] execute took 0ms - succeeded, sql="COMMIT;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 10: [2024-03-19 20:20:49.673] executeForLastInsertedRowId took 0ms - succeeded, sql="INSERT INTO t_r_e (_appKey,_time,_length,_data )VALUES(?,?,?,?)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 11: [2024-03-19 20:20:49.673] execute took 0ms - succeeded, sql="BEGIN IMMEDIATE;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 12: [2024-03-19 20:20:49.654] execute took 0ms - succeeded, sql="COMMIT;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 13: [2024-03-19 20:20:49.654] executeForLastInsertedRowId took 0ms - succeeded, sql="INSERT INTO t_n_e (_appKey,_time,_length,_data )VALUES(?,?,?,?)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 14: [2024-03-19 20:20:49.654] execute took 0ms - succeeded, sql="BEGIN IMMEDIATE;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 15: [2024-03-19 20:20:49.646] execute took 0ms - succeeded, sql="COMMIT;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 16: [2024-03-19 20:20:49.646] executeForLastInsertedRowId took 0ms - succeeded, sql="INSERT INTO t_n_e (_appKey,_time,_length,_data )VALUES(?,?,?,?)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 17: [2024-03-19 20:20:49.646] execute took 0ms - succeeded, sql="BEGIN IMMEDIATE;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 18: [2024-03-19 20:20:35.218] execute took 0ms - succeeded, sql="COMMIT;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 19: [2024-03-19 20:20:35.217] executeForLastInsertedRowId took 0ms - succeeded, sql="INSERT INTO t_r_e (_appKey,_time,_length,_data )VALUES(?,?,?,?)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou Available non-primary connections: Connection #2: isPrimaryConnection: false onlyAllowReadOnlyOperations: true Most recently executed operations: 0: [2024-03-19 20:25:27.665] prepare took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 1: [2024-03-19 20:25:26.665] prepare took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 2: [2024-03-19 20:25:25.665] prepare took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 3: [2024-03-19 20:25:24.665] prepare took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 4: [2024-03-19 20:25:23.665] prepare took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 5: [2024-03-19 20:25:22.665] prepare took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 6: [2024-03-19 20:25:21.665] prepare took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 7: [2024-03-19 20:25:20.665] prepare took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 8: [2024-03-19 20:25:19.665] prepare took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 9: [2024-03-19 20:25:18.665] prepare took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 10: [2024-03-19 20:25:17.665] prepare took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 11: [2024-03-19 20:25:16.665] prepare took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 12: [2024-03-19 20:25:15.665] prepare took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 13: [2024-03-19 20:25:14.665] prepare took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 14: [2024-03-19 20:25:13.665] prepare took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 15: [2024-03-19 20:25:12.665] prepare took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 16: [2024-03-19 20:25:11.665] prepare took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 17: [2024-03-19 20:25:10.665] prepare took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 18: [2024-03-19 20:25:09.665] prepare took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 19: [2024-03-19 20:25:08.665] prepare took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou Connection #3: isPrimaryConnection: false onlyAllowReadOnlyOperations: true Most recently executed operations: 0: [2024-03-19 20:25:27.665] executeForCursorWindow took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 1: [2024-03-19 20:25:26.665] executeForCursorWindow took 1ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 2: [2024-03-19 20:25:25.665] executeForCursorWindow took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 3: [2024-03-19 20:25:24.665] executeForCursorWindow took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 4: [2024-03-19 20:25:23.665] executeForCursorWindow took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 5: [2024-03-19 20:25:22.665] executeForCursorWindow took 1ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 6: [2024-03-19 20:25:21.665] executeForCursorWindow took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 7: [2024-03-19 20:25:20.665] executeForCursorWindow took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 8: [2024-03-19 20:25:19.665] executeForCursorWindow took 1ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 9: [2024-03-19 20:25:18.665] executeForCursorWindow took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 10: [2024-03-19 20:25:17.665] executeForCursorWindow took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 11: [2024-03-19 20:25:16.665] executeForCursorWindow took 1ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 12: [2024-03-19 20:25:15.665] executeForCursorWindow took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 13: [2024-03-19 20:25:14.665] executeForCursorWindow took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 14: [2024-03-19 20:25:13.665] executeForCursorWindow took 1ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 15: [2024-03-19 20:25:12.665] executeForCursorWindow took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 16: [2024-03-19 20:25:11.665] executeForCursorWindow took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 17: [2024-03-19 20:25:10.665] executeForCursorWindow took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 18: [2024-03-19 20:25:09.665] executeForCursorWindow took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 19: [2024-03-19 20:25:08.665] executeForCursorWindow took 0ms - succeeded, sql="SELECT * FROM t_r_e WHERE _id NOT IN () ORDER BY _time DESC LIMIT 48", path=/data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou Acquired connections: <none> Connection waiters: <none> Connection pool for /data/user/0/com.sohu.inputmethod.sogou/databases/atta.db: Open: true Max connections: 1 Total execution time: 22 Configuration: openFlags=268435456, isLegacyCompatibilityWalEnabled=false, journalMode=, syncMode= Available primary connection: Connection #0: isPrimaryConnection: true onlyAllowReadOnlyOperations: false Most recently executed operations: 0: [2024-03-19 20:24:02.508] executeForCursorWindow took 0ms - succeeded, sql="PRAGMA database_list;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/atta.db 1: [2024-03-19 20:24:02.508] executeForLong took 0ms - succeeded, sql="PRAGMA page_size;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/atta.db 2: [2024-03-19 20:24:02.508] executeForLong took 0ms - succeeded, sql="PRAGMA page_count;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/atta.db 3: [2024-03-19 20:19:52.697] executeForChangedRowCount took 9ms - succeeded, sql="DELETE FROM record WHERE _id=?", path=/data/user/0/com.sohu.inputmethod.sogou/databases/atta.db 4: [2024-03-19 20:19:52.697] prepare took 0ms - succeeded, sql="DELETE FROM record WHERE _id=?", path=/data/user/0/com.sohu.inputmethod.sogou/databases/atta.db 5: [2024-03-19 20:19:52.115] executeForCursorWindow took 0ms - succeeded, sql="SELECT _id, process, params FROM record WHERE process=?", path=/data/user/0/com.sohu.inputmethod.sogou/databases/atta.db 6: [2024-03-19 20:19:52.115] prepare took 0ms - succeeded, sql="SELECT _id, process, params FROM record WHERE process=?", path=/data/user/0/com.sohu.inputmethod.sogou/databases/atta.db 7: [2024-03-19 20:19:50.112] executeForLastInsertedRowId took 1ms - succeeded, sql="INSERT INTO record(params,process) VALUES (?,?)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/atta.db 8: [2024-03-19 20:19:50.112] prepare took 0ms - succeeded, sql="INSERT INTO record(params,process) VALUES (?,?)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/atta.db 9: [2024-03-19 20:19:50.112] executeForLong took 0ms - succeeded, sql="PRAGMA user_version;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/atta.db 10: [2024-03-19 20:19:50.112] prepare took 0ms - succeeded, sql="PRAGMA user_version;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/atta.db 11: [2024-03-19 20:19:50.112] executeForString took 0ms - succeeded, sql="SELECT locale FROM android_metadata UNION SELECT NULL ORDER BY locale DESC LIMIT 1", path=/data/user/0/com.sohu.inputmethod.sogou/databases/atta.db 12: [2024-03-19 20:19:50.111] execute took 0ms - succeeded, sql="CREATE TABLE IF NOT EXISTS android_metadata (locale TEXT)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/atta.db 13: [2024-03-19 20:19:50.111] executeForLong took 0ms - succeeded, sql="PRAGMA wal_autocheckpoint=100", path=/data/user/0/com.sohu.inputmethod.sogou/databases/atta.db 14: [2024-03-19 20:19:50.111] executeForLong took 1ms - succeeded, sql="PRAGMA wal_autocheckpoint", path=/data/user/0/com.sohu.inputmethod.sogou/databases/atta.db 15: [2024-03-19 20:19:50.111] executeForLong took 0ms - succeeded, sql="PRAGMA journal_size_limit=524288", path=/data/user/0/com.sohu.inputmethod.sogou/databases/atta.db 16: [2024-03-19 20:19:50.111] executeForLong took 0ms - succeeded, sql="PRAGMA journal_size_limit", path=/data/user/0/com.sohu.inputmethod.sogou/databases/atta.db 17: [2024-03-19 20:19:50.111] execute took 0ms - succeeded, sql="PRAGMA synchronous=NORMAL", path=/data/user/0/com.sohu.inputmethod.sogou/databases/atta.db 18: [2024-03-19 20:19:50.111] executeForString took 0ms - succeeded, sql="PRAGMA synchronous", path=/data/user/0/com.sohu.inputmethod.sogou/databases/atta.db 19: [2024-03-19 20:19:50.111] executeForString took 0ms - succeeded, sql="PRAGMA journal_mode=TRUNCATE", path=/data/user/0/com.sohu.inputmethod.sogou/databases/atta.db Available non-primary connections: <none> Acquired connections: <none> Connection waiters: <none> Connection pool for /data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db: Open: true Max connections: 1 Total execution time: 1 Configuration: openFlags=268435456, isLegacyCompatibilityWalEnabled=false, journalMode=, syncMode= Available primary connection: Connection #0: isPrimaryConnection: true onlyAllowReadOnlyOperations: true Most recently executed operations: 0: [2024-03-19 20:24:02.508] executeForCursorWindow took 0ms - succeeded, sql="PRAGMA database_list;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 1: [2024-03-19 20:24:02.508] executeForLong took 0ms - succeeded, sql="PRAGMA page_size;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 2: [2024-03-19 20:24:02.508] executeForLong took 0ms - succeeded, sql="PRAGMA page_count;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 3: [2024-03-19 20:20:49.714] executeForLong took 0ms - succeeded, sql="PRAGMA user_version;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 4: [2024-03-19 20:20:49.714] prepare took 0ms - succeeded, sql="PRAGMA user_version;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 5: [2024-03-19 20:20:49.713] executeForString took 0ms - succeeded, sql="SELECT locale FROM android_metadata UNION SELECT NULL ORDER BY locale DESC LIMIT 1", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 6: [2024-03-19 20:20:49.713] execute took 1ms - succeeded, sql="CREATE TABLE IF NOT EXISTS android_metadata (locale TEXT)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 7: [2024-03-19 20:20:49.713] executeForLong took 0ms - succeeded, sql="PRAGMA wal_autocheckpoint=100", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 8: [2024-03-19 20:20:49.713] executeForLong took 0ms - succeeded, sql="PRAGMA wal_autocheckpoint", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 9: [2024-03-19 20:20:49.713] executeForLong took 0ms - succeeded, sql="PRAGMA journal_size_limit=524288", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 10: [2024-03-19 20:20:49.713] executeForLong took 0ms - succeeded, sql="PRAGMA journal_size_limit", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 11: [2024-03-19 20:20:49.713] execute took 0ms - succeeded, sql="PRAGMA synchronous=NORMAL", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 12: [2024-03-19 20:20:49.713] executeForString took 0ms - succeeded, sql="PRAGMA synchronous", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 13: [2024-03-19 20:20:49.713] executeForString took 0ms - succeeded, sql="PRAGMA journal_mode=TRUNCATE", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 14: [2024-03-19 20:20:49.713] executeForString took 0ms - succeeded, sql="PRAGMA journal_mode", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 15: [2024-03-19 20:20:49.713] executeForLong took 0ms - succeeded, sql="PRAGMA foreign_keys", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 16: [2024-03-19 20:20:49.713] executeForLong took 0ms - succeeded, sql="PRAGMA page_size", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 17: [2024-03-19 20:20:49.712] open took 0ms - succeeded, path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db Available non-primary connections: <none> Acquired connections: <none> Connection waiters: <none> Connection pool for /data/user/0/com.sohu.inputmethod.sogou/databases/dict_shop_db: Open: true Max connections: 1 Total execution time: 9 Configuration: openFlags=268435456, isLegacyCompatibilityWalEnabled=false, journalMode=, syncMode= Available primary connection: Connection #0: isPrimaryConnection: true onlyAllowReadOnlyOperations: true Most recently executed operations: 0: [2024-03-19 20:24:02.509] executeForCursorWindow took 0ms - succeeded, sql="PRAGMA database_list;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/dict_shop_db 1: [2024-03-19 20:24:02.509] executeForLong took 0ms - succeeded, sql="PRAGMA page_size;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/dict_shop_db 2: [2024-03-19 20:24:02.509] executeForLong took 0ms - succeeded, sql="PRAGMA page_count;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/dict_shop_db 3: [2024-03-19 20:20:49.613] executeForCursorWindow took 0ms - succeeded, sql="SELECT T."DICT_ID",T."_id",T."LABEL_TYPE",T."DICT_TITLE",T."EXAMPLE_WORLD",T."AUTHOR_NAME",T."IS_AUTHOR_QUALITY",T."BRIEF",T."CATEGORY_NAME",T."CATEGORY_ID",T."DICT_NUM",T."USE_COUNT",T."DICT_BG_PATH",T."THUMB_NAIL",T."FILE_STATE",T."DOWNLOAD_STATE",T."IS_OWNER",T."TIME",T."FAILED_REASON",T."IS_PRIVATE",T."VERSION",T."MD5" FROM "DICT_ITEM" T WHERE T."DOWNLOAD_STATE"=? ORDER BY T.'TIME' DESC", path=/data/user/0/com.sohu.inputmethod.sogou/databases/dict_shop_db 4: [2024-03-19 20:20:49.612] prepare took 1ms - succeeded, sql="SELECT T."DICT_ID",T."_id",T."LABEL_TYPE",T."DICT_TITLE",T."EXAMPLE_WORLD",T."AUTHOR_NAME",T."IS_AUTHOR_QUALITY",T."BRIEF",T."CATEGORY_NAME",T."CATEGORY_ID",T."DICT_NUM",T."USE_COUNT",T."DICT_BG_PATH",T."THUMB_NAIL",T."FILE_STATE",T."DOWNLOAD_STATE",T."IS_OWNER",T."TIME",T."FAILED_REASON",T."IS_PRIVATE",T."VERSION",T."MD5" FROM "DICT_ITEM" T WHERE T."DOWNLOAD_STATE"=? ORDER BY T.'TIME' DESC", path=/data/user/0/com.sohu.inputmethod.sogou/databases/dict_shop_db 5: [2024-03-19 20:19:50.182] executeForCursorWindow took 1ms - succeeded, sql="SELECT DISTINCT _id FROM SHARE_LOCK_BEAN WHERE SHARE_LOCK==0", path=/data/user/0/com.sohu.inputmethod.sogou/databases/dict_shop_db 6: [2024-03-19 20:19:50.178] prepare took 3ms - succeeded, sql="SELECT DISTINCT _id FROM SHARE_LOCK_BEAN WHERE SHARE_LOCK==0", path=/data/user/0/com.sohu.inputmethod.sogou/databases/dict_shop_db 7: [2024-03-19 20:19:50.177] executeForCursorWindow took 0ms - succeeded, sql="SELECT DISTINCT DICT_ID FROM DICT_ITEM WHERE DOWNLOAD_STATE==2", path=/data/user/0/com.sohu.inputmethod.sogou/databases/dict_shop_db 8: [2024-03-19 20:19:50.177] prepare took 0ms - succeeded, sql="SELECT DISTINCT DICT_ID FROM DICT_ITEM WHERE DOWNLOAD_STATE==2", path=/data/user/0/com.sohu.inputmethod.sogou/databases/dict_shop_db 9: [2024-03-19 20:19:49.991] executeForCursorWindow took 2ms - succeeded, sql="SELECT DISTINCT DICT_ID FROM DICT_ITEM WHERE DOWNLOAD_STATE==2", path=/data/user/0/com.sohu.inputmethod.sogou/databases/dict_shop_db 10: [2024-03-19 20:19:49.991] prepare took 0ms - succeeded, sql="SELECT DISTINCT DICT_ID FROM DICT_ITEM WHERE DOWNLOAD_STATE==2", path=/data/user/0/com.sohu.inputmethod.sogou/databases/dict_shop_db 11: [2024-03-19 20:19:49.990] executeForLong took 0ms - succeeded, sql="PRAGMA user_version;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/dict_shop_db 12: [2024-03-19 20:19:49.990] prepare took 0ms - succeeded, sql="PRAGMA user_version;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/dict_shop_db 13: [2024-03-19 20:19:49.990] executeForString took 0ms - succeeded, sql="SELECT locale FROM android_metadata UNION SELECT NULL ORDER BY locale DESC LIMIT 1", path=/data/user/0/com.sohu.inputmethod.sogou/databases/dict_shop_db 14: [2024-03-19 20:19:49.989] execute took 0ms - succeeded, sql="CREATE TABLE IF NOT EXISTS android_metadata (locale TEXT)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/dict_shop_db 15: [2024-03-19 20:19:49.989] executeForLong took 0ms - succeeded, sql="PRAGMA wal_autocheckpoint=100", path=/data/user/0/com.sohu.inputmethod.sogou/databases/dict_shop_db 16: [2024-03-19 20:19:49.989] executeForLong took 0ms - succeeded, sql="PRAGMA wal_autocheckpoint", path=/data/user/0/com.sohu.inputmethod.sogou/databases/dict_shop_db 17: [2024-03-19 20:19:49.989] executeForLong took 0ms - succeeded, sql="PRAGMA journal_size_limit=524288", path=/data/user/0/com.sohu.inputmethod.sogou/databases/dict_shop_db 18: [2024-03-19 20:19:49.989] executeForLong took 0ms - succeeded, sql="PRAGMA journal_size_limit", path=/data/user/0/com.sohu.inputmethod.sogou/databases/dict_shop_db 19: [2024-03-19 20:19:49.989] execute took 0ms - succeeded, sql="PRAGMA synchronous=NORMAL", path=/data/user/0/com.sohu.inputmethod.sogou/databases/dict_shop_db Available non-primary connections: <none> Acquired connections: <none> Connection waiters: <none> Connection pool for /data/user/0/com.sohu.inputmethod.sogou/databases/myfont.db: Open: true Max connections: 1 Total execution time: 3 Configuration: openFlags=268435456, isLegacyCompatibilityWalEnabled=false, journalMode=, syncMode= Available primary connection: Connection #0: isPrimaryConnection: true onlyAllowReadOnlyOperations: true Most recently executed operations: 0: [2024-03-19 20:24:02.509] executeForCursorWindow took 0ms - succeeded, sql="PRAGMA database_list;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/myfont.db 1: [2024-03-19 20:24:02.509] executeForLong took 0ms - succeeded, sql="PRAGMA page_size;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/myfont.db 2: [2024-03-19 20:24:02.509] executeForLong took 0ms - succeeded, sql="PRAGMA page_count;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/myfont.db 3: [2024-03-19 20:20:49.967] executeForCursorWindow took 0ms - succeeded, sql="SELECT COUNT(*) FROM "USER_FONT_INFO" T WHERE T."USER_ID"=?", path=/data/user/0/com.sohu.inputmethod.sogou/databases/myfont.db 4: [2024-03-19 20:20:49.967] prepare took 0ms - succeeded, sql="SELECT COUNT(*) FROM "USER_FONT_INFO" T WHERE T."USER_ID"=?", path=/data/user/0/com.sohu.inputmethod.sogou/databases/myfont.db 5: [2024-03-19 20:20:49.720] executeForCursorWindow took 1ms - succeeded, sql="SELECT COUNT(*) FROM "USER_FONT_INFO" T WHERE T."USER_ID"=?", path=/data/user/0/com.sohu.inputmethod.sogou/databases/myfont.db 6: [2024-03-19 20:20:49.720] prepare took 0ms - succeeded, sql="SELECT COUNT(*) FROM "USER_FONT_INFO" T WHERE T."USER_ID"=?", path=/data/user/0/com.sohu.inputmethod.sogou/databases/myfont.db 7: [2024-03-19 20:20:49.719] executeForLong took 0ms - succeeded, sql="PRAGMA user_version;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/myfont.db 8: [2024-03-19 20:20:49.719] prepare took 0ms - succeeded, sql="PRAGMA user_version;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/myfont.db 9: [2024-03-19 20:20:49.719] executeForString took 0ms - succeeded, sql="SELECT locale FROM android_metadata UNION SELECT NULL ORDER BY locale DESC LIMIT 1", path=/data/user/0/com.sohu.inputmethod.sogou/databases/myfont.db 10: [2024-03-19 20:20:49.719] execute took 0ms - succeeded, sql="CREATE TABLE IF NOT EXISTS android_metadata (locale TEXT)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/myfont.db 11: [2024-03-19 20:20:49.718] executeForLong took 0ms - succeeded, sql="PRAGMA wal_autocheckpoint=100", path=/data/user/0/com.sohu.inputmethod.sogou/databases/myfont.db 12: [2024-03-19 20:20:49.718] executeForLong took 0ms - succeeded, sql="PRAGMA wal_autocheckpoint", path=/data/user/0/com.sohu.inputmethod.sogou/databases/myfont.db 13: [2024-03-19 20:20:49.718] executeForLong took 0ms - succeeded, sql="PRAGMA journal_size_limit=524288", path=/data/user/0/com.sohu.inputmethod.sogou/databases/myfont.db 14: [2024-03-19 20:20:49.718] executeForLong took 0ms - succeeded, sql="PRAGMA journal_size_limit", path=/data/user/0/com.sohu.inputmethod.sogou/databases/myfont.db 15: [2024-03-19 20:20:49.718] execute took 1ms - succeeded, sql="PRAGMA synchronous=NORMAL", path=/data/user/0/com.sohu.inputmethod.sogou/databases/myfont.db 16: [2024-03-19 20:20:49.718] executeForString took 0ms - succeeded, sql="PRAGMA synchronous", path=/data/user/0/com.sohu.inputmethod.sogou/databases/myfont.db 17: [2024-03-19 20:20:49.718] executeForString took 0ms - succeeded, sql="PRAGMA journal_mode=TRUNCATE", path=/data/user/0/com.sohu.inputmethod.sogou/databases/myfont.db 18: [2024-03-19 20:20:49.718] executeForString took 0ms - succeeded, sql="PRAGMA journal_mode", path=/data/user/0/com.sohu.inputmethod.sogou/databases/myfont.db 19: [2024-03-19 20:20:49.718] executeForLong took 0ms - succeeded, sql="PRAGMA foreign_keys", path=/data/user/0/com.sohu.inputmethod.sogou/databases/myfont.db Available non-primary connections: <none> Acquired connections: <none> Connection waiters: <none> Connection pool for /data/user/0/com.sohu.inputmethod.sogou/databases/game_center_db: Open: true Max connections: 1 Total execution time: 9 Configuration: openFlags=268435456, isLegacyCompatibilityWalEnabled=false, journalMode=, syncMode= Available primary connection: Connection #0: isPrimaryConnection: true onlyAllowReadOnlyOperations: true Most recently executed operations: 0: [2024-03-19 20:24:02.509] executeForCursorWindow took 0ms - succeeded, sql="PRAGMA database_list;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/game_center_db 1: [2024-03-19 20:24:02.509] executeForLong took 0ms - succeeded, sql="PRAGMA page_size;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/game_center_db 2: [2024-03-19 20:24:02.509] executeForLong took 0ms - succeeded, sql="PRAGMA page_count;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/game_center_db 3: [2024-03-19 20:19:45.036] executeForCursorWindow took 0ms - succeeded, sql="SELECT T."_id",T."NAME",T."PKG_NAME",T."RANK_NAME",T."RANK_ICON",T."DOWNLOAD_URL",T."GAME_DETAIL_PAGE_URL",T."ICON",T."DOWNLOAD_STATE",T."PERCENT",T."TOTAL_LENGTH",T."RECEIVED_LENGTH",T."SAVE_PATH",T."DOWNLOAD_TIMES",T."DOWNLOAD_TIMES_TEXT",T."INSERT_TIMES",T."IS_INSTALLED" FROM "GAME_INFO" T WHERE T."DOWNLOAD_STATE"=? ORDER BY T.'INSERT_TIMES' DESC", path=/data/user/0/com.sohu.inputmethod.sogou/databases/game_center_db 4: [2024-03-19 20:19:45.035] prepare took 0ms - succeeded, sql="SELECT T."_id",T."NAME",T."PKG_NAME",T."RANK_NAME",T."RANK_ICON",T."DOWNLOAD_URL",T."GAME_DETAIL_PAGE_URL",T."ICON",T."DOWNLOAD_STATE",T."PERCENT",T."TOTAL_LENGTH",T."RECEIVED_LENGTH",T."SAVE_PATH",T."DOWNLOAD_TIMES",T."DOWNLOAD_TIMES_TEXT",T."INSERT_TIMES",T."IS_INSTALLED" FROM "GAME_INFO" T WHERE T."DOWNLOAD_STATE"=? ORDER BY T.'INSERT_TIMES' DESC", path=/data/user/0/com.sohu.inputmethod.sogou/databases/game_center_db 5: [2024-03-19 20:19:45.034] executeForCursorWindow took 1ms - succeeded, sql="SELECT T."_id",T."NAME",T."PKG_NAME",T."RANK_NAME",T."RANK_ICON",T."DOWNLOAD_URL",T."GAME_DETAIL_PAGE_URL",T."ICON",T."DOWNLOAD_STATE",T."PERCENT",T."TOTAL_LENGTH",T."RECEIVED_LENGTH",T."SAVE_PATH",T."DOWNLOAD_TIMES",T."DOWNLOAD_TIMES_TEXT",T."INSERT_TIMES",T."IS_INSTALLED" FROM "GAME_INFO" T WHERE T."DOWNLOAD_STATE"=? ORDER BY T.'INSERT_TIMES' DESC", path=/data/user/0/com.sohu.inputmethod.sogou/databases/game_center_db 6: [2024-03-19 20:19:45.034] prepare took 0ms - succeeded, sql="SELECT T."_id",T."NAME",T."PKG_NAME",T."RANK_NAME",T."RANK_ICON",T."DOWNLOAD_URL",T."GAME_DETAIL_PAGE_URL",T."ICON",T."DOWNLOAD_STATE",T."PERCENT",T."TOTAL_LENGTH",T."RECEIVED_LENGTH",T."SAVE_PATH",T."DOWNLOAD_TIMES",T."DOWNLOAD_TIMES_TEXT",T."INSERT_TIMES",T."IS_INSTALLED" FROM "GAME_INFO" T WHERE T."DOWNLOAD_STATE"=? ORDER BY T.'INSERT_TIMES' DESC", path=/data/user/0/com.sohu.inputmethod.sogou/databases/game_center_db 7: [2024-03-19 20:19:45.032] executeForCursorWindow took 1ms - succeeded, sql="SELECT T."_id",T."NAME",T."PKG_NAME",T."RANK_NAME",T."RANK_ICON",T."DOWNLOAD_URL",T."GAME_DETAIL_PAGE_URL",T."ICON",T."DOWNLOAD_STATE",T."PERCENT",T."TOTAL_LENGTH",T."RECEIVED_LENGTH",T."SAVE_PATH",T."DOWNLOAD_TIMES",T."DOWNLOAD_TIMES_TEXT",T."INSERT_TIMES",T."IS_INSTALLED" FROM "GAME_INFO" T WHERE T."DOWNLOAD_STATE"=? ORDER BY T.'INSERT_TIMES' DESC", path=/data/user/0/com.sohu.inputmethod.sogou/databases/game_center_db 8: [2024-03-19 20:19:45.031] prepare took 0ms - succeeded, sql="SELECT T."_id",T."NAME",T."PKG_NAME",T."RANK_NAME",T."RANK_ICON",T."DOWNLOAD_URL",T."GAME_DETAIL_PAGE_URL",T."ICON",T."DOWNLOAD_STATE",T."PERCENT",T."TOTAL_LENGTH",T."RECEIVED_LENGTH",T."SAVE_PATH",T."DOWNLOAD_TIMES",T."DOWNLOAD_TIMES_TEXT",T."INSERT_TIMES",T."IS_INSTALLED" FROM "GAME_INFO" T WHERE T."DOWNLOAD_STATE"=? ORDER BY T.'INSERT_TIMES' DESC", path=/data/user/0/com.sohu.inputmethod.sogou/databases/game_center_db 9: [2024-03-19 20:19:45.029] executeForLong took 0ms - succeeded, sql="PRAGMA user_version;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/game_center_db 10: [2024-03-19 20:19:45.029] prepare took 0ms - succeeded, sql="PRAGMA user_version;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/game_center_db 11: [2024-03-19 20:19:45.029] executeForString took 0ms - succeeded, sql="SELECT locale FROM android_metadata UNION SELECT NULL ORDER BY locale DESC LIMIT 1", path=/data/user/0/com.sohu.inputmethod.sogou/databases/game_center_db 12: [2024-03-19 20:19:45.029] execute took 0ms - succeeded, sql="CREATE TABLE IF NOT EXISTS android_metadata (locale TEXT)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/game_center_db 13: [2024-03-19 20:19:45.029] executeForLong took 0ms - succeeded, sql="PRAGMA wal_autocheckpoint=100", path=/data/user/0/com.sohu.inputmethod.sogou/databases/game_center_db 14: [2024-03-19 20:19:45.029] executeForLong took 0ms - succeeded, sql="PRAGMA wal_autocheckpoint", path=/data/user/0/com.sohu.inputmethod.sogou/databases/game_center_db 15: [2024-03-19 20:19:45.029] executeForLong took 0ms - succeeded, sql="PRAGMA journal_size_limit=524288", path=/data/user/0/com.sohu.inputmethod.sogou/databases/game_center_db 16: [2024-03-19 20:19:45.029] executeForLong took 0ms - succeeded, sql="PRAGMA journal_size_limit", path=/data/user/0/com.sohu.inputmethod.sogou/databases/game_center_db 17: [2024-03-19 20:19:45.028] execute took 0ms - succeeded, sql="PRAGMA synchronous=NORMAL", path=/data/user/0/com.sohu.inputmethod.sogou/databases/game_center_db 18: [2024-03-19 20:19:45.028] executeForString took 0ms - succeeded, sql="PRAGMA synchronous", path=/data/user/0/com.sohu.inputmethod.sogou/databases/game_center_db 19: [2024-03-19 20:19:45.028] executeForString took 0ms - succeeded, sql="PRAGMA journal_mode=TRUNCATE", path=/data/user/0/com.sohu.inputmethod.sogou/databases/game_center_db Available non-primary connections: <none> Acquired connections: <none> Connection waiters: <none> Connection pool for /data/user/0/com.sohu.inputmethod.sogou/databases/S_TIMER_DB: Open: true Max connections: 1 Total execution time: 52 Configuration: openFlags=268435456, isLegacyCompatibilityWalEnabled=false, journalMode=, syncMode= Available primary connection: Connection #0: isPrimaryConnection: true onlyAllowReadOnlyOperations: true Most recently executed operations: 0: [2024-03-19 20:24:48.767] executeForCursorWindow took 0ms - succeeded, sql="SELECT T."_id",T."TIMER_TAG",T."SHARP_START_TIME",T."DELAY",T."PERIODIC",T."LAST_SCHEDULE_TIMER",T."IS_SHARP" FROM "TIMER_ROW" T WHERE T."_id"=?", path=/data/user/0/com.sohu.inputmethod.sogou/databases/S_TIMER_DB 1: [2024-03-19 20:24:48.767] prepare took 0ms - succeeded, sql="SELECT T."_id",T."TIMER_TAG",T."SHARP_START_TIME",T."DELAY",T."PERIODIC",T."LAST_SCHEDULE_TIMER",T."IS_SHARP" FROM "TIMER_ROW" T WHERE T."_id"=?", path=/data/user/0/com.sohu.inputmethod.sogou/databases/S_TIMER_DB 2: [2024-03-19 20:24:48.756] execute took 8ms - succeeded, sql="COMMIT;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/S_TIMER_DB 3: [2024-03-19 20:24:48.756] executeForLastInsertedRowId took 0ms - succeeded, sql="INSERT INTO "TARGET_ROW" ("_id","TIMER_ID","CLASS_NAME") VALUES (?,?,?)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/S_TIMER_DB 4: [2024-03-19 20:24:48.756] executeForChangedRowCount took 0ms - succeeded, sql="DELETE FROM "TARGET_ROW" WHERE "TARGET_ROW"."TIMER_ID"=?", path=/data/user/0/com.sohu.inputmethod.sogou/databases/S_TIMER_DB 5: [2024-03-19 20:24:48.756] prepare took 0ms - succeeded, sql="DELETE FROM "TARGET_ROW" WHERE "TARGET_ROW"."TIMER_ID"=?", path=/data/user/0/com.sohu.inputmethod.sogou/databases/S_TIMER_DB 6: [2024-03-19 20:24:48.755] executeForLastInsertedRowId took 0ms - succeeded, sql="INSERT OR REPLACE INTO "TIMER_ROW" ("_id","TIMER_TAG","SHARP_START_TIME","DELAY","PERIODIC","LAST_SCHEDULE_TIMER","IS_SHARP") VALUES (?,?,?,?,?,?,?)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/S_TIMER_DB 7: [2024-03-19 20:24:48.755] prepare took 1ms - succeeded, sql="INSERT OR REPLACE INTO "TIMER_ROW" ("_id","TIMER_TAG","SHARP_START_TIME","DELAY","PERIODIC","LAST_SCHEDULE_TIMER","IS_SHARP") VALUES (?,?,?,?,?,?,?)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/S_TIMER_DB 8: [2024-03-19 20:24:48.755] executeForCursorWindow took 0ms - succeeded, sql="SELECT T."_id",T."TIMER_TAG",T."SHARP_START_TIME",T."DELAY",T."PERIODIC",T."LAST_SCHEDULE_TIMER",T."IS_SHARP" FROM "TIMER_ROW" T WHERE T."TIMER_TAG"=?", path=/data/user/0/com.sohu.inputmethod.sogou/databases/S_TIMER_DB 9: [2024-03-19 20:24:48.755] prepare took 0ms - succeeded, sql="SELECT T."_id",T."TIMER_TAG",T."SHARP_START_TIME",T."DELAY",T."PERIODIC",T."LAST_SCHEDULE_TIMER",T."IS_SHARP" FROM "TIMER_ROW" T WHERE T."TIMER_TAG"=?", path=/data/user/0/com.sohu.inputmethod.sogou/databases/S_TIMER_DB 10: [2024-03-19 20:24:48.755] execute took 0ms - succeeded, sql="BEGIN EXCLUSIVE;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/S_TIMER_DB 11: [2024-03-19 20:24:02.509] executeForCursorWindow took 0ms - succeeded, sql="PRAGMA database_list;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/S_TIMER_DB 12: [2024-03-19 20:24:02.509] executeForLong took 0ms - succeeded, sql="PRAGMA page_size;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/S_TIMER_DB 13: [2024-03-19 20:24:02.509] executeForLong took 0ms - succeeded, sql="PRAGMA page_count;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/S_TIMER_DB 14: [2024-03-19 20:20:39.947] executeForCursorWindow took 0ms - succeeded, sql="SELECT T."_id",T."TIMER_ID",T."CLASS_NAME" FROM "TARGET_ROW" T WHERE T."TIMER_ID"=?", path=/data/user/0/com.sohu.inputmethod.sogou/databases/S_TIMER_DB 15: [2024-03-19 20:20:39.947] prepare took 0ms - succeeded, sql="SELECT T."_id",T."TIMER_ID",T."CLASS_NAME" FROM "TARGET_ROW" T WHERE T."TIMER_ID"=?", path=/data/user/0/com.sohu.inputmethod.sogou/databases/S_TIMER_DB 16: [2024-03-19 20:20:39.946] executeForCursorWindow took 0ms - succeeded, sql="SELECT T."_id",T."TIMER_TAG",T."SHARP_START_TIME",T."DELAY",T."PERIODIC",T."LAST_SCHEDULE_TIMER",T."IS_SHARP" FROM "TIMER_ROW" T WHERE T."TIMER_TAG"=?", path=/data/user/0/com.sohu.inputmethod.sogou/databases/S_TIMER_DB 17: [2024-03-19 20:20:39.946] prepare took 0ms - succeeded, sql="SELECT T."_id",T."TIMER_TAG",T."SHARP_START_TIME",T."DELAY",T."PERIODIC",T."LAST_SCHEDULE_TIMER",T."IS_SHARP" FROM "TIMER_ROW" T WHERE T."TIMER_TAG"=?", path=/data/user/0/com.sohu.inputmethod.sogou/databases/S_TIMER_DB 18: [2024-03-19 20:19:49.697] executeForCursorWindow took 0ms - succeeded, sql="SELECT T."_id",T."TIMER_TAG",T."SHARP_START_TIME",T."DELAY",T."PERIODIC",T."LAST_SCHEDULE_TIMER",T."IS_SHARP" FROM "TIMER_ROW" T WHERE T."_id"=?", path=/data/user/0/com.sohu.inputmethod.sogou/databases/S_TIMER_DB 19: [2024-03-19 20:19:49.696] prepare took 0ms - succeeded, sql="SELECT T."_id",T."TIMER_TAG",T."SHARP_START_TIME",T."DELAY",T."PERIODIC",T."LAST_SCHEDULE_TIMER",T."IS_SHARP" FROM "TIMER_ROW" T WHERE T."_id"=?", path=/data/user/0/com.sohu.inputmethod.sogou/databases/S_TIMER_DB Available non-primary connections: <none> Acquired connections: <none> Connection waiters: <none> Connection pool for /data/user/0/com.sohu.inputmethod.sogou/databases/apm.db: Open: true Max connections: 1 Total execution time: 3 Configuration: openFlags=268435456, isLegacyCompatibilityWalEnabled=false, journalMode=, syncMode= Available primary connection: Connection #0: isPrimaryConnection: true onlyAllowReadOnlyOperations: true Most recently executed operations: 0: [2024-03-19 20:24:02.509] executeForCursorWindow took 0ms - succeeded, sql="PRAGMA database_list;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/apm.db 1: [2024-03-19 20:24:02.509] executeForLong took 0ms - succeeded, sql="PRAGMA page_size;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/apm.db 2: [2024-03-19 20:24:02.509] executeForLong took 0ms - succeeded, sql="PRAGMA page_count;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/apm.db 3: [2024-03-19 20:19:49.703] executeForCursorWindow took 1ms - succeeded, sql="select * from trace order by id asc limit 1000 offset 0", path=/data/user/0/com.sohu.inputmethod.sogou/databases/apm.db 4: [2024-03-19 20:19:49.702] prepare took 0ms - succeeded, sql="select * from trace order by id asc limit 1000 offset 0", path=/data/user/0/com.sohu.inputmethod.sogou/databases/apm.db 5: [2024-03-19 20:19:49.702] executeForLong took 0ms - succeeded, sql="PRAGMA user_version;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/apm.db 6: [2024-03-19 20:19:49.702] prepare took 0ms - succeeded, sql="PRAGMA user_version;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/apm.db 7: [2024-03-19 20:19:49.702] executeForString took 0ms - succeeded, sql="SELECT locale FROM android_metadata UNION SELECT NULL ORDER BY locale DESC LIMIT 1", path=/data/user/0/com.sohu.inputmethod.sogou/databases/apm.db 8: [2024-03-19 20:19:49.702] execute took 0ms - succeeded, sql="CREATE TABLE IF NOT EXISTS android_metadata (locale TEXT)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/apm.db 9: [2024-03-19 20:19:49.701] executeForLong took 0ms - succeeded, sql="PRAGMA wal_autocheckpoint=100", path=/data/user/0/com.sohu.inputmethod.sogou/databases/apm.db 10: [2024-03-19 20:19:49.701] executeForLong took 0ms - succeeded, sql="PRAGMA wal_autocheckpoint", path=/data/user/0/com.sohu.inputmethod.sogou/databases/apm.db 11: [2024-03-19 20:19:49.701] executeForLong took 0ms - succeeded, sql="PRAGMA journal_size_limit=524288", path=/data/user/0/com.sohu.inputmethod.sogou/databases/apm.db 12: [2024-03-19 20:19:49.701] executeForLong took 0ms - succeeded, sql="PRAGMA journal_size_limit", path=/data/user/0/com.sohu.inputmethod.sogou/databases/apm.db 13: [2024-03-19 20:19:49.701] execute took 0ms - succeeded, sql="PRAGMA synchronous=NORMAL", path=/data/user/0/com.sohu.inputmethod.sogou/databases/apm.db 14: [2024-03-19 20:19:49.701] executeForString took 0ms - succeeded, sql="PRAGMA synchronous", path=/data/user/0/com.sohu.inputmethod.sogou/databases/apm.db 15: [2024-03-19 20:19:49.701] executeForString took 0ms - succeeded, sql="PRAGMA journal_mode=TRUNCATE", path=/data/user/0/com.sohu.inputmethod.sogou/databases/apm.db 16: [2024-03-19 20:19:49.701] executeForString took 0ms - succeeded, sql="PRAGMA journal_mode", path=/data/user/0/com.sohu.inputmethod.sogou/databases/apm.db 17: [2024-03-19 20:19:49.701] executeForLong took 0ms - succeeded, sql="PRAGMA foreign_keys", path=/data/user/0/com.sohu.inputmethod.sogou/databases/apm.db 18: [2024-03-19 20:19:49.700] executeForLong took 0ms - succeeded, sql="PRAGMA page_size", path=/data/user/0/com.sohu.inputmethod.sogou/databases/apm.db 19: [2024-03-19 20:19:49.699] open took 2ms - succeeded, path=/data/user/0/com.sohu.inputmethod.sogou/databases/apm.db Available non-primary connections: <none> Acquired connections: <none> Connection waiters: <none> Connection pool for /data/user/0/com.sohu.inputmethod.sogou/databases/rmonitor_db: Open: true Max connections: 1 Total execution time: 22 Configuration: openFlags=268435456, isLegacyCompatibilityWalEnabled=false, journalMode=, syncMode= Available primary connection: Connection #0: isPrimaryConnection: true onlyAllowReadOnlyOperations: false Most recently executed operations: 0: [2024-03-19 20:24:02.509] executeForCursorWindow took 0ms - succeeded, sql="PRAGMA database_list;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/rmonitor_db 1: [2024-03-19 20:24:02.509] executeForLong took 0ms - succeeded, sql="PRAGMA page_size;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/rmonitor_db 2: [2024-03-19 20:24:02.509] executeForLong took 1ms - succeeded, sql="PRAGMA page_count;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/rmonitor_db 3: [2024-03-19 20:19:45.367] executeForLastInsertedRowId took 4ms - succeeded, sql="INSERT OR REPLACE INTO atta_event(manufacturer,app_version,app_key,param_0,param_1,param_2,param_3,param_4,param_5,param_6,param_7,param_8,param_9,sdk_version,client_type,user_id,device_id,debug,model,os_version,app_bundle_id,event_code,event_cost,event_time,event_result,upload_time,app_name,param_10,param_11,param_12,param_13,full_os_version,error_code,product_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/rmonitor_db 4: [2024-03-19 20:19:45.364] prepare took 3ms - succeeded, sql="INSERT OR REPLACE INTO atta_event(manufacturer,app_version,app_key,param_0,param_1,param_2,param_3,param_4,param_5,param_6,param_7,param_8,param_9,sdk_version,client_type,user_id,device_id,debug,model,os_version,app_bundle_id,event_code,event_cost,event_time,event_result,upload_time,app_name,param_10,param_11,param_12,param_13,full_os_version,error_code,product_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/rmonitor_db 5: [2024-03-19 20:19:45.361] executeForCursorWindow took 1ms - succeeded, sql="SELECT * FROM atta_event LIMIT 30", path=/data/user/0/com.sohu.inputmethod.sogou/databases/rmonitor_db 6: [2024-03-19 20:19:45.360] prepare took 0ms - succeeded, sql="SELECT * FROM atta_event LIMIT 30", path=/data/user/0/com.sohu.inputmethod.sogou/databases/rmonitor_db 7: [2024-03-19 20:19:45.091] executeForLong took 0ms - succeeded, sql="PRAGMA user_version;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/rmonitor_db 8: [2024-03-19 20:19:45.091] prepare took 0ms - succeeded, sql="PRAGMA user_version;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/rmonitor_db 9: [2024-03-19 20:19:45.090] executeForString took 0ms - succeeded, sql="SELECT locale FROM android_metadata UNION SELECT NULL ORDER BY locale DESC LIMIT 1", path=/data/user/0/com.sohu.inputmethod.sogou/databases/rmonitor_db 10: [2024-03-19 20:19:45.090] execute took 1ms - succeeded, sql="CREATE TABLE IF NOT EXISTS android_metadata (locale TEXT)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/rmonitor_db 11: [2024-03-19 20:19:45.090] executeForLong took 0ms - succeeded, sql="PRAGMA wal_autocheckpoint=100", path=/data/user/0/com.sohu.inputmethod.sogou/databases/rmonitor_db 12: [2024-03-19 20:19:45.090] executeForLong took 0ms - succeeded, sql="PRAGMA wal_autocheckpoint", path=/data/user/0/com.sohu.inputmethod.sogou/databases/rmonitor_db 13: [2024-03-19 20:19:45.090] executeForLong took 0ms - succeeded, sql="PRAGMA journal_size_limit=524288", path=/data/user/0/com.sohu.inputmethod.sogou/databases/rmonitor_db 14: [2024-03-19 20:19:45.090] executeForLong took 0ms - succeeded, sql="PRAGMA journal_size_limit", path=/data/user/0/com.sohu.inputmethod.sogou/databases/rmonitor_db 15: [2024-03-19 20:19:45.090] execute took 0ms - succeeded, sql="PRAGMA synchronous=NORMAL", path=/data/user/0/com.sohu.inputmethod.sogou/databases/rmonitor_db 16: [2024-03-19 20:19:45.090] executeForString took 0ms - succeeded, sql="PRAGMA synchronous", path=/data/user/0/com.sohu.inputmethod.sogou/databases/rmonitor_db 17: [2024-03-19 20:19:45.090] executeForString took 0ms - succeeded, sql="PRAGMA journal_mode=TRUNCATE", path=/data/user/0/com.sohu.inputmethod.sogou/databases/rmonitor_db 18: [2024-03-19 20:19:45.087] executeForString took 3ms - succeeded, sql="PRAGMA journal_mode", path=/data/user/0/com.sohu.inputmethod.sogou/databases/rmonitor_db 19: [2024-03-19 20:19:45.087] executeForLong took 0ms - succeeded, sql="PRAGMA foreign_keys", path=/data/user/0/com.sohu.inputmethod.sogou/databases/rmonitor_db Available non-primary connections: <none> Acquired connections: <none> Connection waiters: <none> Connection pool for /data/user/0/com.sohu.inputmethod.sogou/databases/bugly_db_: Open: true Max connections: 1 Total execution time: 13 Configuration: openFlags=268435456, isLegacyCompatibilityWalEnabled=false, journalMode=, syncMode= Available primary connection: Connection #0: isPrimaryConnection: true onlyAllowReadOnlyOperations: false Most recently executed operations: 0: [2024-03-19 20:24:02.510] executeForCursorWindow took 0ms - succeeded, sql="PRAGMA database_list;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/bugly_db_ 1: [2024-03-19 20:24:02.510] executeForLong took 0ms - succeeded, sql="PRAGMA page_size;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/bugly_db_ 2: [2024-03-19 20:24:02.509] executeForLong took 0ms - succeeded, sql="PRAGMA page_count;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/bugly_db_ 3: [2024-03-19 20:19:45.242] executeForLastInsertedRowId took 1ms - succeeded, sql="INSERT OR REPLACE INTO t_ui(_dt,_id,_pc,_tm,_tp,_ut) VALUES (?,?,?,?,?,?)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/bugly_db_ 4: [2024-03-19 20:19:45.242] prepare took 0ms - succeeded, sql="INSERT OR REPLACE INTO t_ui(_dt,_id,_pc,_tm,_tp,_ut) VALUES (?,?,?,?,?,?)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/bugly_db_ 5: [2024-03-19 20:19:45.242] executeForLastInsertedRowId took 0ms - succeeded, sql="INSERT OR REPLACE INTO t_lr(_dt,_pc,_th,_tm,_tp) VALUES (?,?,?,?,?)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/bugly_db_ 6: [2024-03-19 20:19:45.242] prepare took 0ms - succeeded, sql="INSERT OR REPLACE INTO t_lr(_dt,_pc,_th,_tm,_tp) VALUES (?,?,?,?,?)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/bugly_db_ 7: [2024-03-19 20:19:45.242] executeForChangedRowCount took 0ms - succeeded, sql="DELETE FROM t_lr WHERE _tp = 3", path=/data/user/0/com.sohu.inputmethod.sogou/databases/bugly_db_ 8: [2024-03-19 20:19:45.241] prepare took 0ms - succeeded, sql="DELETE FROM t_lr WHERE _tp = 3", path=/data/user/0/com.sohu.inputmethod.sogou/databases/bugly_db_ 9: [2024-03-19 20:19:45.241] executeForChangedRowCount took 0ms - succeeded, sql="DELETE FROM t_lr WHERE _id = 3", path=/data/user/0/com.sohu.inputmethod.sogou/databases/bugly_db_ 10: [2024-03-19 20:19:45.240] prepare took 0ms - succeeded, sql="DELETE FROM t_lr WHERE _id = 3", path=/data/user/0/com.sohu.inputmethod.sogou/databases/bugly_db_ 11: [2024-03-19 20:19:45.240] executeForCursorWindow took 0ms - succeeded, sql="SELECT * FROM t_lr WHERE _tp = 3", path=/data/user/0/com.sohu.inputmethod.sogou/databases/bugly_db_ 12: [2024-03-19 20:19:45.238] prepare took 0ms - succeeded, sql="SELECT * FROM t_lr WHERE _tp = 3", path=/data/user/0/com.sohu.inputmethod.sogou/databases/bugly_db_ 13: [2024-03-19 20:19:45.021] executeForLastInsertedRowId took 1ms - succeeded, sql="INSERT OR REPLACE INTO t_lr(_dt,_pc,_th,_tm,_tp) VALUES (?,?,?,?,?)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/bugly_db_ 14: [2024-03-19 20:19:45.021] prepare took 0ms - succeeded, sql="INSERT OR REPLACE INTO t_lr(_dt,_pc,_th,_tm,_tp) VALUES (?,?,?,?,?)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/bugly_db_ 15: [2024-03-19 20:19:45.020] executeForChangedRowCount took 1ms - succeeded, sql="DELETE FROM t_lr WHERE _tp = 1001", path=/data/user/0/com.sohu.inputmethod.sogou/databases/bugly_db_ 16: [2024-03-19 20:19:45.020] prepare took 0ms - succeeded, sql="DELETE FROM t_lr WHERE _tp = 1001", path=/data/user/0/com.sohu.inputmethod.sogou/databases/bugly_db_ 17: [2024-03-19 20:19:44.976] executeForCursorWindow took 1ms - succeeded, sql="SELECT _id, _tm, _s1, _up, _me, _uc FROM t_cr", path=/data/user/0/com.sohu.inputmethod.sogou/databases/bugly_db_ 18: [2024-03-19 20:19:44.976] prepare took 0ms - succeeded, sql="SELECT _id, _tm, _s1, _up, _me, _uc FROM t_cr", path=/data/user/0/com.sohu.inputmethod.sogou/databases/bugly_db_ 19: [2024-03-19 20:19:44.971] executeForCursorWindow took 0ms - succeeded, sql="SELECT _id, _tm, _s1, _up, _me, _uc FROM t_cr", path=/data/user/0/com.sohu.inputmethod.sogou/databases/bugly_db_ Available non-primary connections: <none> Acquired connections: <none> Connection waiters: <none> Connection pool for /data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db: Open: true Max connections: 1 Total execution time: 2 Configuration: openFlags=268435456, isLegacyCompatibilityWalEnabled=false, journalMode=, syncMode= Available primary connection: Connection #0: isPrimaryConnection: true onlyAllowReadOnlyOperations: true Most recently executed operations: 0: [2024-03-19 20:24:02.510] executeForCursorWindow took 0ms - succeeded, sql="PRAGMA database_list;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 1: [2024-03-19 20:24:02.510] executeForLong took 0ms - succeeded, sql="PRAGMA page_size;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 2: [2024-03-19 20:24:02.510] executeForLong took 0ms - succeeded, sql="PRAGMA page_count;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 3: [2024-03-19 20:20:49.966] executeForCursorWindow took 0ms - succeeded, sql="SELECT T."_id",T."USER_ID",T."THEME_ID",T."UPDATE_TIME",T."DELETE_FLAG",T."SYNC_FLAG",T."LOCAL_FLAG",T."EXTRA_DATA" FROM "USER_THEME_INFO" T WHERE T."USER_ID"=? AND T."DELETE_FLAG"=?", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 4: [2024-03-19 20:20:49.966] prepare took 0ms - succeeded, sql="SELECT T."_id",T."USER_ID",T."THEME_ID",T."UPDATE_TIME",T."DELETE_FLAG",T."SYNC_FLAG",T."LOCAL_FLAG",T."EXTRA_DATA" FROM "USER_THEME_INFO" T WHERE T."USER_ID"=? AND T."DELETE_FLAG"=?", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 5: [2024-03-19 20:20:49.714] executeForCursorWindow took 1ms - succeeded, sql="SELECT T."_id",T."USER_ID",T."THEME_ID",T."UPDATE_TIME",T."DELETE_FLAG",T."SYNC_FLAG",T."LOCAL_FLAG",T."EXTRA_DATA" FROM "USER_THEME_INFO" T WHERE T."USER_ID"=? AND T."DELETE_FLAG"=?", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 6: [2024-03-19 20:20:49.714] prepare took 0ms - succeeded, sql="SELECT T."_id",T."USER_ID",T."THEME_ID",T."UPDATE_TIME",T."DELETE_FLAG",T."SYNC_FLAG",T."LOCAL_FLAG",T."EXTRA_DATA" FROM "USER_THEME_INFO" T WHERE T."USER_ID"=? AND T."DELETE_FLAG"=?", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 7: [2024-03-19 20:20:49.712] executeForLong took 0ms - succeeded, sql="PRAGMA user_version;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 8: [2024-03-19 20:20:49.712] prepare took 0ms - succeeded, sql="PRAGMA user_version;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 9: [2024-03-19 20:20:49.711] executeForString took 0ms - succeeded, sql="SELECT locale FROM android_metadata UNION SELECT NULL ORDER BY locale DESC LIMIT 1", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 10: [2024-03-19 20:20:49.711] execute took 0ms - succeeded, sql="CREATE TABLE IF NOT EXISTS android_metadata (locale TEXT)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 11: [2024-03-19 20:20:49.711] executeForLong took 0ms - succeeded, sql="PRAGMA wal_autocheckpoint=100", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 12: [2024-03-19 20:20:49.711] executeForLong took 0ms - succeeded, sql="PRAGMA wal_autocheckpoint", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 13: [2024-03-19 20:20:49.711] executeForLong took 0ms - succeeded, sql="PRAGMA journal_size_limit=524288", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 14: [2024-03-19 20:20:49.711] executeForLong took 0ms - succeeded, sql="PRAGMA journal_size_limit", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 15: [2024-03-19 20:20:49.711] execute took 0ms - succeeded, sql="PRAGMA synchronous=NORMAL", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 16: [2024-03-19 20:20:49.711] executeForString took 0ms - succeeded, sql="PRAGMA synchronous", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 17: [2024-03-19 20:20:49.711] executeForString took 0ms - succeeded, sql="PRAGMA journal_mode=TRUNCATE", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 18: [2024-03-19 20:20:49.711] executeForString took 0ms - succeeded, sql="PRAGMA journal_mode", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 19: [2024-03-19 20:20:49.711] executeForLong took 0ms - succeeded, sql="PRAGMA foreign_keys", path=/data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db Available non-primary connections: <none> Acquired connections: <none> Connection waiters: <none> Connection pool for /data/user/0/com.sohu.inputmethod.sogou/databases/performance.db: Open: true Max connections: 1 Total execution time: 9 Configuration: openFlags=268435456, isLegacyCompatibilityWalEnabled=false, journalMode=, syncMode= Available primary connection: Connection #0: isPrimaryConnection: true onlyAllowReadOnlyOperations: true Most recently executed operations: 0: [2024-03-19 20:24:02.510] executeForCursorWindow took 0ms - succeeded, sql="PRAGMA database_list;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/performance.db 1: [2024-03-19 20:24:02.510] executeForLong took 0ms - succeeded, sql="PRAGMA page_size;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/performance.db 2: [2024-03-19 20:24:02.510] executeForLong took 0ms - succeeded, sql="PRAGMA page_count;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/performance.db 3: [2024-03-19 20:20:59.664] executeForCursorWindow took 0ms - succeeded, sql="SELECT T."_id",T."time_stamp",T."tag",T."fd_sample",T."memory_sample",T."thread_sample",T."disk_sample" FROM "PERFORMANCE_SAMPLE_ENTITY" T WHERE time_stamp > 1710777600663 ORDER BY T.'time_stamp' ASC", path=/data/user/0/com.sohu.inputmethod.sogou/databases/performance.db 4: [2024-03-19 20:20:59.663] prepare took 0ms - succeeded, sql="SELECT T."_id",T."time_stamp",T."tag",T."fd_sample",T."memory_sample",T."thread_sample",T."disk_sample" FROM "PERFORMANCE_SAMPLE_ENTITY" T WHERE time_stamp > 1710777600663 ORDER BY T.'time_stamp' ASC", path=/data/user/0/com.sohu.inputmethod.sogou/databases/performance.db 5: [2024-03-19 20:20:59.655] execute took 0ms - succeeded, sql="COMMIT;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/performance.db 6: [2024-03-19 20:20:59.655] executeForChangedRowCount took 0ms - succeeded, sql="PRAGMA user_version = 2", path=/data/user/0/com.sohu.inputmethod.sogou/databases/performance.db 7: [2024-03-19 20:20:59.655] prepare took 0ms - succeeded, sql="PRAGMA user_version = 2", path=/data/user/0/com.sohu.inputmethod.sogou/databases/performance.db 8: [2024-03-19 20:20:59.653] executeForChangedRowCount took 2ms - succeeded, sql="CREATE TABLE "PERFORMANCE_SAMPLE_ENTITY" ("_id" INTEGER PRIMARY KEY AUTOINCREMENT ,"time_stamp" INTEGER NOT NULL ,"tag" TEXT NOT NULL ,"fd_sample" TEXT NOT NULL ,"memory_sample" TEXT NOT NULL ,"thread_sample" TEXT NOT NULL ,"disk_sample" TEXT NOT NULL );", path=/data/user/0/com.sohu.inputmethod.sogou/databases/performance.db 9: [2024-03-19 20:20:59.653] prepare took 0ms - succeeded, sql="CREATE TABLE "PERFORMANCE_SAMPLE_ENTITY" ("_id" INTEGER PRIMARY KEY AUTOINCREMENT ,"time_stamp" INTEGER NOT NULL ,"tag" TEXT NOT NULL ,"fd_sample" TEXT NOT NULL ,"memory_sample" TEXT NOT NULL ,"thread_sample" TEXT NOT NULL ,"disk_sample" TEXT NOT NULL );", path=/data/user/0/com.sohu.inputmethod.sogou/databases/performance.db 10: [2024-03-19 20:20:59.652] execute took 0ms - succeeded, sql="BEGIN EXCLUSIVE;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/performance.db 11: [2024-03-19 20:20:59.652] executeForLong took 0ms - succeeded, sql="PRAGMA user_version;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/performance.db 12: [2024-03-19 20:20:59.652] prepare took 0ms - succeeded, sql="PRAGMA user_version;", path=/data/user/0/com.sohu.inputmethod.sogou/databases/performance.db 13: [2024-03-19 20:20:59.651] execute took 1ms - succeeded, sql="COMMIT", path=/data/user/0/com.sohu.inputmethod.sogou/databases/performance.db 14: [2024-03-19 20:20:59.651] execute took 0ms - succeeded, sql="REINDEX LOCALIZED", path=/data/user/0/com.sohu.inputmethod.sogou/databases/performance.db 15: [2024-03-19 20:20:59.651] execute took 0ms - succeeded, sql="INSERT INTO android_metadata (locale) VALUES(?)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/performance.db 16: [2024-03-19 20:20:59.651] execute took 0ms - succeeded, sql="DELETE FROM android_metadata", path=/data/user/0/com.sohu.inputmethod.sogou/databases/performance.db 17: [2024-03-19 20:20:59.651] execute took 0ms - succeeded, sql="BEGIN", path=/data/user/0/com.sohu.inputmethod.sogou/databases/performance.db 18: [2024-03-19 20:20:59.651] executeForString took 0ms - succeeded, sql="SELECT locale FROM android_metadata UNION SELECT NULL ORDER BY locale DESC LIMIT 1", path=/data/user/0/com.sohu.inputmethod.sogou/databases/performance.db 19: [2024-03-19 20:20:59.645] execute took 6ms - succeeded, sql="CREATE TABLE IF NOT EXISTS android_metadata (locale TEXT)", path=/data/user/0/com.sohu.inputmethod.sogou/databases/performance.db Available non-primary connections: <none> Acquired connections: <none> Connection waiters: <none> Database files in /data/user/0/com.sohu.inputmethod.sogou/databases: Networking_monitor.db 24576b ctime=2024-03-19T12:20:59Z mtime=2024-03-19T12:20:59Z atime=2024-02-20T09:00:40Z Networking_monitor.db-journal 0b ctime=2024-02-20T09:00:40Z mtime=2024-02-20T09:00:40Z atime=2024-02-20T09:00:40Z S_TIMER_DB 28672b ctime=2024-03-19T12:24:48Z mtime=2024-03-19T12:24:48Z atime=2024-02-20T09:00:34Z S_TIMER_DB-journal 0b ctime=2024-02-20T09:00:34Z mtime=2024-02-20T09:00:34Z atime=2024-02-20T09:00:34Z apm.db 36864b ctime=2024-02-20T09:00:34Z mtime=2024-02-20T09:00:34Z atime=2024-02-20T09:00:34Z apm.db-journal 0b ctime=2024-02-20T09:00:34Z mtime=2024-02-20T09:00:34Z atime=2024-02-20T09:00:34Z atta.db 20480b ctime=2024-03-19T12:19:52Z mtime=2024-03-19T12:19:52Z atime=2024-02-20T09:00:30Z atta.db-journal 0b ctime=2024-02-20T09:00:30Z mtime=2024-02-20T09:00:30Z atime=2024-02-20T09:00:30Z beacon_db_0DOU0TYV0B4LZY9M 24576b ctime=2024-02-20T09:00:35Z mtime=2024-02-20T09:00:35Z atime=2024-02-20T09:00:35Z beacon_db_0DOU0TYV0B4LZY9M-journal 0b ctime=2024-02-20T09:00:35Z mtime=2024-02-20T09:00:35Z atime=2024-02-20T09:00:35Z beacon_db_com.sohu.inputmethod.sogou 24576b ctime=2024-03-19T12:19:45Z mtime=2024-03-19T12:19:45Z atime=2024-02-20T09:00:35Z beacon_db_com.sohu.inputmethod.sogou-journal 0b ctime=2024-02-20T09:00:35Z mtime=2024-02-20T09:00:35Z atime=2024-02-20T09:00:35Z beacon_db_com.sohu.inputmethod.sogou-shm 32768b ctime=2024-03-19T12:20:59Z mtime=2024-03-19T12:20:59Z atime=2024-03-19T12:19:45Z beacon_db_com.sohu.inputmethod.sogou-wal 185432b ctime=2024-03-19T12:21:01Z mtime=2024-03-19T12:21:01Z atime=2024-03-19T12:19:45Z beacon_db_com.sohu.inputmethod.sogou:home 32768b ctime=2024-03-19T12:25:28Z mtime=2024-03-19T12:25:28Z atime=2024-02-20T09:00:37Z beacon_db_com.sohu.inputmethod.sogou:home-journal 0b ctime=2024-02-20T09:00:37Z mtime=2024-02-20T09:00:37Z atime=2024-02-20T09:00:37Z beacon_db_com.sohu.inputmethod.sogou:home-shm 32768b ctime=2024-03-19T12:25:28Z mtime=2024-03-19T12:25:28Z atime=2024-03-19T12:19:49Z beacon_db_com.sohu.inputmethod.sogou:home-wal 416152b ctime=2024-03-19T12:25:28Z mtime=2024-03-19T12:25:28Z atime=2024-03-19T12:19:49Z bugly_db_ 61440b ctime=2024-03-19T12:19:49Z mtime=2024-03-19T12:19:49Z atime=2024-02-20T09:00:34Z bugly_db_-journal 0b ctime=2024-02-20T09:00:34Z mtime=2024-02-20T09:00:34Z atime=2024-02-20T09:00:34Z dict_shop_db 24576b ctime=2024-02-20T09:00:38Z mtime=2024-02-20T09:00:38Z atime=2024-02-20T09:00:38Z dict_shop_db-journal 0b ctime=2024-02-20T09:00:38Z mtime=2024-02-20T09:00:38Z atime=2024-02-20T09:00:38Z game_center_db 24576b ctime=2024-02-20T09:00:25Z mtime=2024-02-20T09:00:25Z atime=2024-02-20T09:00:25Z game_center_db-journal 0b ctime=2024-02-20T09:00:25Z mtime=2024-02-20T09:00:25Z atime=2024-02-20T09:00:25Z lbnetnotify.db 20480b ctime=2024-03-19T12:20:49Z mtime=2024-03-19T12:20:49Z atime=2024-03-19T12:20:49Z lbnetnotify.db-journal 0b ctime=2024-03-19T12:20:49Z mtime=2024-03-19T12:20:49Z atime=2024-03-19T12:20:49Z myfont.db 32768b ctime=2024-02-20T09:00:56Z mtime=2024-02-20T09:00:56Z atime=2024-02-20T09:00:56Z myfont.db-journal 0b ctime=2024-02-20T09:00:56Z mtime=2024-02-20T09:00:56Z atime=2024-02-20T09:00:56Z mytheme.db 32768b ctime=2024-02-20T09:00:56Z mtime=2024-02-20T09:00:56Z atime=2024-02-20T09:00:56Z mytheme.db-journal 0b ctime=2024-02-20T09:00:56Z mtime=2024-02-20T09:00:56Z atime=2024-02-20T09:00:56Z notifi_messages.db 28672b ctime=2024-02-20T09:02:34Z mtime=2024-02-20T09:02:34Z atime=2024-02-20T09:02:34Z notifi_messages.db-journal 0b ctime=2024-02-20T09:02:34Z mtime=2024-02-20T09:02:34Z atime=2024-02-20T09:02:34Z performance.db 20480b ctime=2024-03-19T12:20:59Z mtime=2024-03-19T12:20:59Z atime=2024-03-19T12:20:59Z performance.db-journal 0b ctime=2024-03-19T12:20:59Z mtime=2024-03-19T12:20:59Z atime=2024-03-19T12:20:59Z publickey.db 20480b ctime=2024-03-19T12:21:00Z mtime=2024-03-19T12:21:00Z atime=2024-03-19T12:21:00Z publickey.db-journal 0b ctime=2024-03-19T12:21:00Z mtime=2024-03-19T12:21:00Z atime=2024-03-19T12:21:00Z rmonitor_db 28672b ctime=2024-03-19T12:19:45Z mtime=2024-03-19T12:19:45Z atime=2024-02-20T09:00:37Z rmonitor_db-journal 0b ctime=2024-02-20T09:00:37Z mtime=2024-02-20T09:00:37Z atime=2024-02-20T09:00:37Z
该命令可以查看指定进程名或者进程id的内存信息
用法: adb shell dumpsys meminfo [pname/pid]
Applications Memory Usage (in Kilobytes): Uptime: 1282546315 Realtime: 2264675684 ** MEMINFO in pid 29729 [com.sohu.inputmethod.sogou] ** Pss Private Private SwapPss Rss Heap Heap Heap Total Dirty Clean Dirty Total Size Alloc Free ------ ------ ------ ------ ------ ------ ------ ------ Native Heap 45064 44976 12 28 46332 68096 51708 16387 Dalvik Heap 13996 13976 0 47 14536 15006 7503 7503 Dalvik Other 3782 3320 0 0 4720 Stack 1860 1860 0 0 1868 Ashmem 2 0 0 0 16 Gfx dev 5008 5008 0 0 5008 Other dev 77 0 76 0 412 .so mmap 13717 616 6796 7 59848 .jar mmap 1679 0 84 0 33088 .apk mmap 879 0 0 0 26252 .ttf mmap 7730 0 5588 0 17904 .dex mmap 21002 28 4328 0 37800 .oat mmap 378 0 0 0 16560 .art mmap 10484 9856 64 106 22524 Other mmap 11189 36 8608 0 15304 GL mtrack 384 384 0 0 384 Unknown 755 736 0 2 1196 TOTAL 138176 80796 25556 190 138176 83102 59211 23890 App Summary Pss(KB) Rss(KB) ------ ------ Java Heap: 23896 37060 Native Heap: 44976 46332 Code: 17440 192460 Stack: 1860 1868 Graphics: 5392 5392 Private Other: 12788 System: 31824 Unknown: 20640 TOTAL PSS: 138176 TOTAL RSS: 303752 TOTAL SWAP PSS: 190 Objects Views: 51 ViewRootImpl: 1 AppContexts: 6 Activities: 1 Assets: 37 AssetManagers: 0 Local Binders: 66 Proxy Binders: 49 Parcel memory: 21 Parcel count: 85 Death Recipients: 5 OpenSSL Sockets: 7 WebViews: 0 SQL MEMORY_USED: 2441 PAGECACHE_OVERFLOW: 404 MALLOC_SIZE: 117 DATABASES pgsz dbsz Lookaside(b) cache Dbname 4 48 47 19/50/8 /data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou 4 48 77 541/20/7 /data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou (2) 4 48 49 520/18/3 /data/user/0/com.sohu.inputmethod.sogou/databases/beacon_db_com.sohu.inputmethod.sogou (3) 4 20 36 3/19/4 /data/user/0/com.sohu.inputmethod.sogou/databases/atta.db 4 32 17 0/16/1 /data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 4 24 71 5/19/4 /data/user/0/com.sohu.inputmethod.sogou/databases/dict_shop_db 4 32 24 3/17/2 /data/user/0/com.sohu.inputmethod.sogou/databases/myfont.db 4 24 54 5/17/2 /data/user/0/com.sohu.inputmethod.sogou/databases/game_center_db 4 28 86 28/28/7 /data/user/0/com.sohu.inputmethod.sogou/databases/S_TIMER_DB 4 36 31 1/17/2 /data/user/0/com.sohu.inputmethod.sogou/databases/apm.db 4 28 57 2/18/3 /data/user/0/com.sohu.inputmethod.sogou/databases/rmonitor_db 4 60 108 17/29/14 /data/user/0/com.sohu.inputmethod.sogou/databases/bugly_db_ 4 32 40 3/17/2 /data/user/0/com.sohu.inputmethod.sogou/databases/mytheme.db 4 20 45 1/28/4 /data/user/0/com.sohu.inputmethod.sogou/databases/performance.db
该命令可以指定非root设备中查看指定debug模式的包名应用沙盒数据
zh@zh:~/workSpace$ adb shell
OP5263:/ $ run-as com.test.redpacket
OP5263:/data/user/0/com.test.redpacket $
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。