2021-10-22.log 4.3 KB

12345678910111213141516
  1. 2021-10-22 08:13:20.207 [DEBU] [1829 ms] [default] SELECT a.attname AS field, t.typname AS type,a.attnotnull as null, (case when d.contype is not null then 'pri' else '' end) as key ,ic.column_default as default_value,b.description as comment ,coalesce(character_maximum_length, numeric_precision, -1) as length ,numeric_scale as scale FROM pg_attribute a left join pg_class c on a.attrelid = c.oid left join pg_constraint d on d.conrelid = c.oid and a.attnum = d.conkey[1] left join pg_description b ON a.attrelid=b.objoid AND a.attnum = b.objsubid left join pg_type t ON a.atttypid = t.oid left join information_schema.columns ic on ic.column_name = a.attname and ic.table_name = c.relname WHERE c.relname = 'sys_job' and a.attnum > 0 ORDER BY a.attnum
  2. 2021-10-22 08:13:20.254 [DEBU] [ 45 ms] [default] SELECT "job_id","job_name","job_params","job_group","invoke_target","cron_expression","misfire_policy","concurrent","status","create_by","update_by","remark","created_at","updated_at","deleted_at" FROM "sys_job" WHERE ("status"=0) AND "deleted_at" IS NULL
  3. 2021-10-22 08:13:20.722 [DEBU] [467 ms] [default] UPDATE "sys_job" SET "status"=0 WHERE "job_id"=8
  4. 2021-10-22 08:13:20.751 [DEBU] [ 29 ms] [default] UPDATE "sys_job" SET "status"=0 WHERE "job_id"=2
  5. 2021-10-22 08:20:05.263 [DEBU] [ 85 ms] [default] SELECT a.attname AS field, t.typname AS type,a.attnotnull as null, (case when d.contype is not null then 'pri' else '' end) as key ,ic.column_default as default_value,b.description as comment ,coalesce(character_maximum_length, numeric_precision, -1) as length ,numeric_scale as scale FROM pg_attribute a left join pg_class c on a.attrelid = c.oid left join pg_constraint d on d.conrelid = c.oid and a.attnum = d.conkey[1] left join pg_description b ON a.attrelid=b.objoid AND a.attnum = b.objsubid left join pg_type t ON a.atttypid = t.oid left join information_schema.columns ic on ic.column_name = a.attname and ic.table_name = c.relname WHERE c.relname = 'sys_user_online' and a.attnum > 0 ORDER BY a.attnum
  6. 2021-10-22 08:20:05.336 [DEBU] [ 73 ms] [default] SELECT COUNT(1) FROM "sys_user_online"
  7. 2021-10-22 08:20:05.338 [DEBU] [ 1 ms] [default] SELECT "id","uuid","token","create_time","user_name","ip","explorer","os" FROM "sys_user_online" ORDER BY "create_time" DESC LIMIT 50 OFFSET 0
  8. 2021-10-22 08:20:05.355 [DEBU] [ 16 ms] [default] DELETE FROM "sys_user_online" WHERE "token"='oqvgpXlo+yd79rXmKL2otwfhEkHseCvwM5m6FA4zk6QJqJq2IWi6ZsRlgU3j9+ZrXU5HcYR3La2Lg4N4u0+lvyf8H8nx+yU3ysX2AH6nZLe5G+BP0dVYfhyfm6b5E2YAe6TiSUN8LtKxPJm+q4FR6g=='
  9. 2021-10-22 08:30:05.183 [DEBU] [ 6 ms] [default] SELECT COUNT(1) FROM "sys_user_online"
  10. 2021-10-22 08:30:05.184 [DEBU] [ 1 ms] [default] SELECT "id","uuid","token","create_time","user_name","ip","explorer","os" FROM "sys_user_online" ORDER BY "create_time" DESC LIMIT 50 OFFSET 0
  11. 2021-10-22 08:40:05.187 [DEBU] [ 9 ms] [default] SELECT COUNT(1) FROM "sys_user_online"
  12. 2021-10-22 08:40:05.189 [DEBU] [ 2 ms] [default] SELECT "id","uuid","token","create_time","user_name","ip","explorer","os" FROM "sys_user_online" ORDER BY "create_time" DESC LIMIT 50 OFFSET 0
  13. 2021-10-22 09:14:11.690 [DEBU] [ 23 ms] [default] SELECT a.attname AS field, t.typname AS type,a.attnotnull as null, (case when d.contype is not null then 'pri' else '' end) as key ,ic.column_default as default_value,b.description as comment ,coalesce(character_maximum_length, numeric_precision, -1) as length ,numeric_scale as scale FROM pg_attribute a left join pg_class c on a.attrelid = c.oid left join pg_constraint d on d.conrelid = c.oid and a.attnum = d.conkey[1] left join pg_description b ON a.attrelid=b.objoid AND a.attnum = b.objsubid left join pg_type t ON a.atttypid = t.oid left join information_schema.columns ic on ic.column_name = a.attname and ic.table_name = c.relname WHERE c.relname = 'sys_job' and a.attnum > 0 ORDER BY a.attnum
  14. 2021-10-22 09:14:11.690 [DEBU] [ 0 ms] [default] SELECT "job_id","job_name","job_params","job_group","invoke_target","cron_expression","misfire_policy","concurrent","status","create_by","update_by","remark","created_at","updated_at","deleted_at" FROM "sys_job" WHERE ("status"=0) AND "deleted_at" IS NULL
  15. 2021-10-22 09:14:11.712 [DEBU] [ 21 ms] [default] UPDATE "sys_job" SET "status"=0 WHERE "job_id"=8
  16. 2021-10-22 09:14:11.727 [DEBU] [ 15 ms] [default] UPDATE "sys_job" SET "status"=0 WHERE "job_id"=2