AIRIOT智慧系统搭建平台经验交流

密码不一致。怎么办呢？

core日志：
{"time":"2024-11-04T14:33:35.7173747+08:00","level":"INFO","msg":"周期性更新授权缓存完成"}
{"time":"2024-11-04T14:33:36.2888943+08:00","level":"INFO","msg":"更新机器码缓存完成"}

2024/11/04 14:33:40 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[288.771ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒7车间'
{"time":"2024-11-04T14:34:05.717161+08:00","level":"INFO","msg":"周期性更新授权缓存完成"}
{"time":"2024-11-04T14:34:06.3127432+08:00","level":"INFO","msg":"更新机器码缓存完成"}
{"time":"2024-11-04T14:34:14.2339874+08:00","level":"INFO","msg":"查询项目[default]UsedLicense"}

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[214.570ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒5车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[206.549ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '蒸汽数据不一致班组'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[204.544ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒4车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[219.583ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒6车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[203.542ms] [rows:1] SELECT "showField","dataSource","permissions","id","title","schema","permission","function" FROM "default"."table" WHERE "id" = '制酒8车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[411.093ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒14车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[435.156ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒15车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[254.677ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒15车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[203.541ms] [rows:1] SELECT * FROM "default"."user" WHERE id='admin'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[235.626ms] [rows:1] SELECT count(*) FROM "default"."制酒15车间" WHERE "id" = '制酒15_105'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[228.608ms] [rows:1] SELECT * FROM "default"."制酒15车间" WHERE id='制酒15_110'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[207.552ms] [rows:1] SELECT * FROM "default"."制酒5车间" WHERE id='制酒5_42'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[456.212ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒9车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[450.196ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒5车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[253.675ms] [rows:1] SELECT count(*) FROM "default"."制酒8车间" WHERE "id" = '制酒8_90'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[279.744ms] [rows:1] SELECT count(*) FROM "default"."制酒9车间" WHERE "id" = '制酒9_79'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[205.547ms] [rows:1] SELECT count(*) FROM "default"."制酒10车间" WHERE "id" = '制酒10_97'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[249.665ms] [rows:1] SELECT "dataSource","permissions","id","title","schema","permission","function","showField" FROM "default"."table" WHERE "id" = '制酒15车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[456.212ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒7车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[248.661ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[203.541ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[259.691ms] [rows:1] SELECT "schema","permission","function","showField","dataSource","permissions","id","title" FROM "default"."table" WHERE "id" = '制酒15车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[228.608ms] [rows:1] SELECT count(*) FROM "default"."制酒8车间" WHERE "id" = '制酒8_88'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[209.557ms] [rows:1] SELECT * FROM "default"."user" WHERE id='admin'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[214.569ms] [rows:1] SELECT "tableData","formschema","device","computed","warning","table_params","id" FROM "default"."table_record" WHERE "tableData" = '制酒8_84' AND "tableInfo" = '制酒8车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[217.579ms] [rows:1] SELECT * FROM "default"."蒸汽数据不一致班组" WHERE id='制酒9_74'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[254.678ms] [rows:1] SELECT count(*) FROM "default"."制酒6车间" WHERE "id" = '制酒6_52'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[307.819ms] [rows:1] SELECT "schema","permission","function","showField","dataSource","permissions","id","title" FROM "default"."table" WHERE "id" = '制酒16车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[224.596ms] [rows:1] SELECT count(*) FROM "default"."制酒14车间" WHERE "id" = '制酒14_3'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[257.685ms] [rows:1] SELECT * FROM "default"."user" WHERE id='admin'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[320.853ms] [rows:1] SELECT "permission","function","showField","dataSource","permissions","id","title","schema" FROM "default"."table" WHERE "id" = '制酒8车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[264.704ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[219.583ms] [rows:1] SELECT * FROM "default"."user" WHERE id='admin'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[270.720ms] [rows:1] SELECT * FROM "default"."制酒5车间" WHERE id='制酒5_44'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[240.640ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[219.584ms] [rows:1] SELECT * FROM "default"."制酒5车间" WHERE id='制酒5_60'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[327.872ms] [rows:1] SELECT "showField","dataSource","permissions","id","title","schema","permission","function" FROM "default"."table" WHERE "id" = '制酒6车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[211.562ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[242.645ms] [rows:1] SELECT count(*) FROM "default"."制酒7车间" WHERE "id" = '制酒7_49'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[235.626ms] [rows:1] SELECT count(*) FROM "default"."制酒4车间" WHERE "id" = '制酒4_38'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[243.648ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[222.592ms] [rows:1] SELECT * FROM "default"."制酒5车间" WHERE id='制酒5_45'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[250.666ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[233.621ms] [rows:1] SELECT count(*) FROM "default"."制酒16车间" WHERE "id" = '制酒16_116'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[270.721ms] [rows:1] SELECT * FROM "default"."制酒10车间" WHERE id='制酒10_100'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[267.712ms] [rows:1] SELECT * FROM "default"."制酒4车间" WHERE id='制酒4_33'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[259.690ms] [rows:1] SELECT count(*) FROM "default"."制酒10车间" WHERE "id" = '制酒10_96'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[323.861ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[353.941ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[283.755ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[289.771ms] [rows:1] SELECT count(*) FROM "default"."制酒14车间" WHERE "id" = '制酒14_4'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[336.897ms] [rows:1] SELECT count(*) FROM "default"."制酒10车间" WHERE "id" = '制酒10_98'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[284.757ms] [rows:1] SELECT "title","schema","id" FROM "default"."table" WHERE "id" = '制酒10车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[312.832ms] [rows:1] SELECT * FROM "default"."制酒7车间" WHERE id='制酒7_48'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[305.813ms] [rows:1] SELECT "tableData","formschema","device","computed","warning","table_params","id" FROM "default"."table_record" WHERE "tableData" = '制酒8_92' AND "tableInfo" = '制酒8车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[352.939ms] [rows:1] SELECT count(*) FROM "default"."制酒6车间" WHERE "id" = '制酒6_57'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[318.848ms] [rows:1] SELECT * FROM "default"."table" WHERE "id" = '茅台和义兴'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[353.942ms] [rows:1] SELECT "id","title","schema","permission","function","showField","dataSource","permissions" FROM "default"."table" WHERE "id" = '制酒15车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[282.751ms] [rows:1] SELECT "schema","id","title" FROM "default"."table" WHERE "function" like '%dataAuth%'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[287.765ms] [rows:1] SELECT "id","title","schema" FROM "default"."table" WHERE "id" = '制酒10车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[200.533ms] [rows:1] SELECT * FROM "default"."table" WHERE "id" = '茅台和义兴'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[367.978ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[378.005ms] [rows:1] SELECT "permission","function","showField","dataSource","permissions","id","title","schema" FROM "default"."table" WHERE "id" = '制酒10车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[332.885ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[393.044ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒9车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[398.057ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒9车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[353.941ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[317.846ms] [rows:1] SELECT * FROM "default"."table" WHERE "id" = '茅台和义兴'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[362.965ms] [rows:1] SELECT count(*) FROM "default"."制酒9车间" WHERE "id" = '制酒9_71'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[394.048ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[600.596ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒15车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[337.898ms] [rows:1] SELECT * FROM "default"."table" WHERE "id" = '茅台和义兴'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[426.133ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒6车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[366.976ms] [rows:1] SELECT * FROM "default"."制酒6车间" WHERE id='制酒6_58'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[399.061ms] [rows:1] SELECT * FROM "default"."制酒16车间" WHERE id='制酒16_121'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[237.632ms] [rows:1] SELECT "schema","id","title" FROM "default"."table" WHERE "function" like '%dataAuth%'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[393.045ms] [rows:1] SELECT * FROM "default"."table" WHERE "id" = '茅台和义兴'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[464.234ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒6车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[417.110ms] [rows:1] SELECT * FROM "default"."user" WHERE id='admin'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[652.734ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒7车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[385.024ms] [rows:1] SELECT "title","schema","permission","function","showField","dataSource","permissions","id" FROM "default"."table" WHERE "id" = '制酒14车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[206.549ms] [rows:1] SELECT * FROM "default"."制酒9车间" WHERE id='制酒9_79'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[279.744ms] [rows:1] SELECT count(*) FROM "default"."制酒14车间" WHERE "id" = '制酒14_3'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[413.099ms] [rows:1] SELECT "warning","table_params","id","tableData","formschema","device","computed" FROM "default"."table_record" WHERE "tableData" = '制酒15_112' AND "tableInfo" = '制酒15车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[270.720ms] [rows:1] SELECT count(*) FROM "default"."制酒7车间" WHERE "id" = '制酒7_50'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[211.562ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[323.861ms] [rows:1] SELECT * FROM "default"."茅台和义兴" WHERE "id" in ('茅台和义兴','制酒16车间')

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[282.752ms] [rows:1] SELECT * FROM "default"."user" WHERE id='admin'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[425.130ms] [rows:1] SELECT "computed","warning","table_params","id","tableData","formschema","device" FROM "default"."table_record" WHERE "tableData" = '制酒8_93' AND "tableInfo" = '制酒8车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[261.695ms] [rows:1] SELECT * FROM "default"."table" WHERE "id" = '茅台和义兴'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[201.536ms] [rows:1] SELECT "title","schema","id" FROM "default"."table" WHERE "id" = '蒸汽数据不一致班组'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[669.780ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒14车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[240.640ms] [rows:1] SELECT * FROM "default"."制酒14车间" WHERE id='制酒14_2'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[408.085ms] [rows:1] SELECT * FROM "default"."table" WHERE "id" = '茅台和义兴'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[433.152ms] [rows:1] SELECT * FROM "default"."user" WHERE id='admin'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[459.222ms] [rows:1] SELECT * FROM "default"."制酒8车间" WHERE id='制酒8_89'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[219.584ms] [rows:1] SELECT * FROM "default"."制酒6车间" WHERE id='制酒6_55'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[202.539ms] [rows:1] SELECT "id","tableData","formschema","device","computed","warning","table_params" FROM "default"."table_record" WHERE "tableData" = '制酒6_54' AND "tableInfo" = '制酒6车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[250.666ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒15车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[210.560ms] [rows:1] SELECT * FROM "default"."制酒4车间" WHERE id='制酒4_38'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[241.643ms] [rows:1] SELECT count(*) FROM "default"."制酒8车间" WHERE "id" = '制酒8_90'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[239.637ms] [rows:1] SELECT * FROM "default"."user" WHERE id='admin'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[220.587ms] [rows:1] SELECT * FROM "default"."user" WHERE id='defaultApp'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:60 SLOW SQL >= 200ms
[432.149ms] [rows:1] SELECT * FROM "default"."user" WHERE id='admin'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[230.613ms] [rows:1] SELECT "schema","id","title" FROM "default"."table" WHERE "function" like '%dataAuth%'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:180 SLOW SQL >= 200ms
[242.645ms] [rows:1] SELECT * FROM "default"."茅台和义兴" WHERE "id" in ('制酒8车间')

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[742.975ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒9车间'

2024/11/04 14:34:20 /go/pkg/mod/git.airiot.tech/core/service.git/v4@v4.4.17/gormdb/gorm.go:99 SLOW SQL >= 200ms
[745.983ms] [rows:1] SELECT count(*) FROM "default"."table" WHERE "id" = '制酒9车间'
{"time":"2024-11-04T14:34:35.7171634+08:00","level":"INFO","msg":"周期性更新授权缓存完成"}
{"time":"2024-11-04T14:34:36.2064415+08:00","level":"INFO","msg":"更新机器码缓存完成"}

日志报这个错误：

2024/11/03 21:21:05 INFO 启动服务: 版本=v4.2.34
panic: 初始化消息队列错误: not Authorized

goroutine 1 [running]:
github.com/air-iot/sdk-go/v4/driver.NewApp()
/go/pkg/mod/github.com/air-iot/sdk-go/v4@v4.7.11/driver/app.go:136 +0x40e
main.main()
/builds/core/drivers/modbus-driver/cmd/modbus/main.go:15 +0x5f
{"time":"2024-11-03T21:21:05.180516+08:00","level":"INFO","msg":"启动配置={ServiceID:669493618a85cc2c6c09534d GroupID: Project:default Driver:{ID:modbus Name:Modbus-TCP} DriverGrpc:{Host:127.0.0.1 Port:9224 Health:{RequestTime:10s Retry:3} Stream:{Heartbeat:10s} WaitTime:5s Timeout:10m0s Limit:100} Log:{Level:4 Format:json Output:stdout OutputFile: MaxAge:0 RotationTime:0 RotationSize:0 RotationCount:0 Syslog:{ServiceName:default-669493618a85cc2c6c09534d-modbus ProjectId:default}} MQ:{Type:mqtt Timeout:1m0s MQTT:{Host:127.0.0.1 Port:1883 Username:admin Password:public KeepAlive:60 ConnectTimeout:20 ProtocolVersion:4} Rabbit:{Host:rabbit Port:5672 Username:admin Password:public VHost: Exchange: Queue:} Kafka:{Brokers:[kafka:9092] Version: GroupID: ClientID: MaxOpenRequests:0 Balancer: Partition:<nil> AutoCommit:<nil>}} Pprof:{Enable:false Host: Port:9002} EtcdConfig: Etcd:{Endpoints:[] DialTimeout:0 Username: Password: AutoSyncInterval:0s}}"}

驱动一直启动不了，停止然后重新启动了几次，都是显示等待重试，一直不能启动运行，请问好怎么才能启动起来？

@Zhang书书 modscan都能正确解析，看驱动日志收发也正常，

modbus-TCP通讯，设备端数据类型是：浮点数(IEEE754)地址顺序为2,1,4,3，数据接收都正常，就是解析格式始终不正确，FloatBE，FloatLE，FloatBE-，FloatLE-，四种格式都试了都不正常。

数据点怎么取绝对值？

@18903330657 兄弟，这三个一级是怎么做出来的？

有没有在可视化画面中做出报表预览这种效果的例子，比如查询按钮，选择时间，选择设备。

@18201618017 谢谢。

@18201618017 大哥，第一次使用，对你们软件不太熟悉，能不能详细点

大哥，第一次使用，对你们软件不太熟悉，能不能详细点

请问在可视化画面上想显示每个设备在在线状态和最后采集数据时间应该怎么弄？像图片这种效果