ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a1fead52ce92: POST https://beta.jinchangxiao.com/vue/client/list-document at 2026-06-03 04:50:29 pm by 221.216.117.119

Database Queries

总计17条数据
TimeDurationTypeQuery
  
16:50:29.1860.9 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
16:50:29.1890.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
16:50:29.1930.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='149'

[+] Explain
16:50:29.2013.2 msSELECTSELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_client_documents' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;

[+] Explain
16:50:29.20522.5 msSELECTselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_client_documents' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum

[+] Explain
16:50:29.2292.8 msSELECTSELECT COUNT(*) FROM (SELECT cd.* FROM "a57be577deb434"."tbl_client_documents" "cd" WHERE "client_id"=149 GROUP BY "cd"."id" ORDER BY "created_at" DESC) "c"

[+] Explain
16:50:29.2320.8 msSELECTSELECT cd.* FROM "a57be577deb434"."tbl_client_documents" "cd" WHERE "client_id"=149 GROUP BY "cd"."id" ORDER BY "created_at" DESC LIMIT 20

[+] Explain
16:50:29.2340.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5085

[+] Explain
16:50:29.2340.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5085)

[+] Explain
16:50:29.2350.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=2

[+] Explain
16:50:29.23511.0 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (32197, 32198, 32196, 31828, 31827, 31826, 31226, 31225, 30261, 30260, 30259, 29538, 29537, 29536, 28921, 28922, 28920, 28919, 28917, 28918)

[+] Explain
16:50:29.24634.6 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=104) AND ("object_id" IN (1240, 1239, 1238, 1186, 1185, 1184, 1152, 1151, 1125, 1124, 1123, 1094, 1093, 1092, 1064, 1063, 1062, 1061, 1060, 1059)) GROUP BY "object_id"

[+] Explain
16:50:29.28127.7 msSELECTSELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=104) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (1240, 1239, 1238, 1186, 1185, 1184, 1152, 1151, 1125, 1124, 1123, 1094, 1093, 1092, 1064, 1063, 1062, 1061, 1060, 1059)) GROUP BY "object_id"

[+] Explain
16:50:29.3090.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=149

[+] Explain
16:50:29.3100.3 msSELECTSELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (4025, 3720, 3716)

[+] Explain
16:50:29.3100.9 msSELECTSELECT "id", "id" AS "key", "case_no" AS "name" FROM "a57be577deb434"."tbl_cases" WHERE "id" IN (9209, 9208, 9166, 9167, 9099, 9098, 9029, 9030, 8933, 8934, 8880, 8879)

[+] Explain
16:50:29.3162.4 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/client/list-document', '{"page":"1","client_id":"149","web_access_token":"3sqoTbqwkHhRmqiLIelKWucsK6N07HRT"}', '{"code":2000,"result":{"list":[{"id":1240,"attachment_id":32197,"client_id":149,"title":"\u5de1\u68c0\u62a5\u544a\u5c01\u9762 2\u6708- -\u6c38\u5c45\u8bc1.pdf","description":"","created_by":5085,"created_at":"2026-03-05 20:18:32","updated_at":"2026-03-05 20:18:32","project_id":4025,"case_id":9209,"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"attachment":{"id":32197,"key":32197,"name":"7709230f-216b-35cf-b28e-72b4e0faa752","extension":"pdf","path":"\/vue\/attachment\/preview\/7709230f-216b-35cf-b28e-72b4e0faa752\/\u5de1\u68c0\u62a5\u544a\u5c01\u9762 2\u6708- -\u6c38\u5c45\u8bc1.pdf","orig_name":"\u5de1\u68c0\u62a5\u544a\u5c01\u9762 2\u6708- -\u6c38\u5c45\u8bc1.pdf"},"commentCount":{},"unreadComments":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"project":{"id":4025,"key":4025,"name":"\u7eff\u536125-26\u5e74\u5de1\u68c0"},"case":{"id":9209,"key":9209,"name":"IM260305005"},"unread":0,"can_update":true,"can_delete":true},{"id":1239,"attachment_id":32198,"client_id":149,"title":"GABYS-YJ\u73b0\u573a\u5de1\u68c0\u8868.pdf","description":"","created_by":5085,"created_at":"2026-03-05 20:18:32","updated_at":"2026-03-05 20:18:32","project_id":4025,"case_id":9209,"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"attachment":{"id":32198,"key":32198,"name":"8534f215-37b2-31a8-86ea-27c72d41f8a7","extension":"pdf","path":"\/vue\/attachment\/preview\/8534f215-37b2-31a8-86ea-27c72d41f8a7\/GABYS-YJ\u73b0\u573a\u5de1\u68c0\u8868.pdf","orig_name":"GABYS-YJ\u73b0\u573a\u5de1\u68c0\u8868.pdf"},"commentCount":{},"unreadComments":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"project":{"id":4025,"key":4025,"name":"\u7eff\u536125-26\u5e74\u5de1\u68c0"},"case":{"id":9209,"key":9209,"name":"IM260305005"},"unread":0,"can_update":true,"can_delete":true},{"id":1238,"attachment_id":32196,"client_id":149,"title":"GABYS\u73b0\u573a\u5de1\u68c0\u8868\uff082026\u5e742\u6708\uff09.pdf","description":"","created_by":5085,"created_at":"2026-03-05 20:16:53","updated_at":"2026-03-05 20:16:53","project_id":3720,"case_id":9208,"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"attachment":{"id":32196,"key":32196,"name":"2ebdce3e-bcf5-3f5f-b740-a64f4d330fca","extension":"pdf","path":"\/vue\/attachment\/preview\/2ebdce3e-bcf5-3f5f-b740-a64f4d330fca\/GABYS\u73b0\u573a\u5de1\u68c0\u8868\uff082026\u5e742\u6708\uff09.pdf","orig_name":"GABYS\u73b0\u573a\u5de1\u68c0\u8868\uff082026\u5e742\u6708\uff09.pdf"},"commentCount":{},"unreadComments":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"project":{"id":3720,"key":3720,"name":"\u81ea\u52a8\u5316\u8bbe\u5907\u4e09\u671f"},"case":{"id":9208,"key":9208,"name":"IM260305004"},"unread":0,"can_update":true,"can_delete":true},{"id":1186,"attachment_id":31828,"client_id":149,"title":"GABYS\u73b0\u573a\u5de1\u68c0\u8868\uff082026\u5e741\u6708\uff09.docx","description":"","created_by":5085,"created_at":"2026-02-06 08:11:37","updated_at":"2026-02-06 08:11:37","project_id":3720,"case_id":9166,"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"attachment":{"id":31828,"key":31828,"name":"23d7cc33-6cb5-3a6c-8c97-e969d72a07b0","extension":"docx","path":"\/vue\/attachment\/preview\/23d7cc33-6cb5-3a6c-8c97-e969d72a07b0\/GABYS\u73b0\u573a\u5de1\u68c0\u8868\uff082026\u5e741\u6708\uff09.docx","orig_name":"GABYS\u73b0\u573a\u5de1\u68c0\u8868\uff082026\u5e741\u6708\uff09.docx"},"commentCount":{},"unreadComments":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"project":{"id":3720,"key":3720,"name":"\u81ea\u52a8\u5316\u8bbe\u5907\u4e09\u671f"},"case":{"id":9166,"key":9166,"name":"IM260205002"},"unread":0,"can_update":true,"can_delete":true},{"id":1185,"attachment_id":31827,"client_id":149,"title":"\u5de1\u68c0\u62a5\u544a\u5c01\u9762 1\u6708- -\u6c38\u5c45\u8bc1.doc","description":"","created_by":5085,"created_at":"2026-02-06 08:10:28","updated_at":"2026-02-06 08:10:28","project_id":4025,"case_id":9167,"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"attachment":{"id":31827,"key":31827,"name":"3fb1179c-d7e3-3453-b5d9-fd0264fcaa45","extension":"doc","path":"\/vue\/attachment\/preview\/3fb1179c-d7e3-3453-b5d9-fd0264fcaa45\/\u5de1\u68c0\u62a5\u544a\u5c01\u9762 1\u6708- -\u6c38\u5c45\u8bc1.doc","orig_name":"\u5de1\u68c0\u62a5\u544a\u5c01\u9762 1\u6708- -\u6c38\u5c45\u8bc1.doc"},"commentCount":{},"unreadComments":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"project":{"id":4025,"key":4025,"name":"\u7eff\u536125-26\u5e74\u5de1\u68c0"},"case":{"id":9167,"key":9167,"name":"IM260205003"},"unread":0,"can_update":true,"can_delete":true},{"id":1184,"attachment_id":31826,"client_id":149,"title":"GABYS-YJ\u73b0\u573a\u5de1\u68c0\u8868.docx","description":"","created_by":5085,"created_at":"2026-02-06 08:10:28","updated_at":"2026-02-06 08:10:28","project_id":4025,"case_id":9167,"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"attachment":{"id":31826,"key":31826,"name":"bdd1a934-b320-3919-b422-3567426d46c2","extension":"docx","path":"\/vue\/attachment\/preview\/bdd1a934-b320-3919-b422-3567426d46c2\/GABYS-YJ\u73b0\u573a\u5de1\u68c0\u8868.docx","orig_name":"GABYS-YJ\u73b0\u573a\u5de1\u68c0\u8868.docx"},"commentCount":{},"unreadComments":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"project":{"id":4025,"key":4025,"name":"\u7eff\u536125-26\u5e74\u5de1\u68c0"},"case":{"id":9167,"key":9167,"name":"IM260205003"},"unread":0,"can_update":true,"can_delete":true},{"id":1152,"attachment_id":31226,"client_id":149,"title":"GABYS-YJ\u6708\u5ea625\u5e7412\u6708\u5de1\u68c0\u8868.pdf","description":"","created_by":5085,"created_at":"2026-01-07 10:17:44","updated_at":"2026-01-07 10:17:44","project_id":3716,"case_id":9099,"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"attachment":{"id":31226,"key":31226,"name":"f698e384-bf5c-3888-ada4-040b40c520cf","extension":"pdf","path":"\/vue\/attachment\/preview\/f698e384-bf5c-3888-ada4-040b40c520cf\/GABYS-YJ\u6708\u5ea625\u5e7412\u6708\u5de1\u68c0\u8868.pdf","orig_name":"GABYS-YJ\u6708\u5ea625\u5e7412\u6708\u5de1\u68c0\u8868.pdf"},"commentCount":{},"unreadComments":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"project":{"id":3716,"key":3716,"name":"\u7eff\u536124-25\u5e74\u5ea6\u6280\u672f\u670d\u52a1"},"case":{"id":9099,"key":9099,"name":"IM260106003"},"unread":0,"can_update":true,"can_delete":true},{"id":1151,"attachment_id":31225,"client_id":149,"title":"GABYS\u73b0\u573a\u5de1\u68c0\u8868\uff082025\u5e7412\u6708\uff09.pdf","description":"","created_by":5085,"created_at":"2026-01-07 10:17:05","updated_at":"2026-01-07 10:17:05","project_id":3720,"case_id":9098,"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"attachment":{"id":31225,"key":31225,"name":"1bcc56dc-6d2f-34e1-bf9a-0af9bc0dc300","extension":"pdf","path":"\/vue\/attachment\/preview\/1bcc56dc-6d2f-34e1-bf9a-0af9bc0dc300\/GABYS\u73b0\u573a\u5de1\u68c0\u8868\uff082025\u5e7412\u6708\uff09.pdf","orig_name":"GABYS\u73b0\u573a\u5de1\u68c0\u8868\uff082025\u5e7412\u6708\uff09.pdf"},"commentCount":{},"unreadComments":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"project":{"id":3720,"key":3720,"name":"\u81ea\u52a8\u5316\u8bbe\u5907\u4e09\u671f"},"case":{"id":9098,"key":9098,"name":"IM260106002"},"unread":0,"can_update":true,"can_delete":true},{"id":1125,"attachment_id":30261,"client_id":149,"title":"\u516c\u5b89\u90e8\u4e00\u6240\u73b0\u573a\u5de1\u68c0\u8868\uff082025\u5e7411\u6708\uff09.docx","description":"","created_by":5085,"created_at":"2025-12-09 09:47:09","updated_at":"2025-12-09 09:47:09","project_id":3720,"case_id":9029,"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"attachment":{"id":30261,"key":30261,"name":"36031e4f-ee58-3e8c-8f33-8fbf820989e8","extension":"docx","path":"\/vue\/attachment\/preview\/36031e4f-ee58-3e8c-8f33-8fbf820989e8\/\u516c\u5b89\u90e8\u4e00\u6240\u73b0\u573a\u5de1\u68c0\u8868\uff082025\u5e7411\u6708\uff09.docx","orig_name":"\u516c\u5b89\u90e8\u4e00\u6240\u73b0\u573a\u5de1\u68c0\u8868\uff082025\u5e7411\u6708\uff09.docx"},"commentCount":{},"unreadComments":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"project":{"id":3720,"key":3720,"name":"\u81ea\u52a8\u5316\u8bbe\u5907\u4e09\u671f"},"case":{"id":9029,"key":9029,"name":"IM251208001"},"unread":0,"can_update":true,"can_delete":true},{"id":1124,"attachment_id":30260,"client_id":149,"title":"\u5de1\u68c0\u62a5\u544a\u5c01\u9762 11\u6708- -\u6c38\u5c45\u8bc1.doc","description":"","created_by":5085,"created_at":"2025-12-09 09:46:21","updated_at":"2025-12-09 09:46:21","project_id":3716,"case_id":9030,"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"attachment":{"id":30260,"key":30260,"name":"ad6cff50-01e7-387b-a8b5-8b9d7ebf6293","extension":"doc","path":"\/vue\/attachment\/preview\/ad6cff50-01e7-387b-a8b5-8b9d7ebf6293\/\u5de1\u68c0\u62a5\u544a\u5c01\u9762 11\u6708- -\u6c38\u5c45\u8bc1.doc","orig_name":"\u5de1\u68c0\u62a5\u544a\u5c01\u9762 11\u6708- -\u6c38\u5c45\u8bc1.doc"},"commentCount":{},"unreadComments":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"project":{"id":3716,"key":3716,"name":"\u7eff\u536124-25\u5e74\u5ea6\u6280\u672f\u670d\u52a1"},"case":{"id":9030,"key":9030,"name":"IM251208002"},"unread":0,"can_update":true,"can_delete":true},{"id":1123,"attachment_id":30259,"client_id":149,"title":"\u516c\u5b89\u90e8\u4e00\u6240\u6c38\u5c45\u8bc1\u6708\u5ea625\u5e7411\u6708\u5de1\u68c0\u8868.docx","description":"","created_by":5085,"created_at":"2025-12-09 09:46:21","updated_at":"2025-12-09 09:46:21","project_id":3716,"case_id":9030,"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"attachment":{"id":30259,"key":30259,"name":"767478b0-7064-35bc-b635-64c1a6cd6923","extension":"docx","path":"\/vue\/attachment\/preview\/767478b0-7064-35bc-b635-64c1a6cd6923\/\u516c\u5b89\u90e8\u4e00\u6240\u6c38\u5c45\u8bc1\u6708\u5ea625\u5e7411\u6708\u5de1\u68c0\u8868.docx","orig_name":"\u516c\u5b89\u90e8\u4e00\u6240\u6c38\u5c45\u8bc1\u6708\u5ea625\u5e7411\u6708\u5de1\u68c0\u8868.docx"},"commentCount":{},"unreadComments":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"project":{"id":3716,"key":3716,"name":"\u7eff\u536124-25\u5e74\u5ea6\u6280\u672f\u670d\u52a1"},"case":{"id":9030,"key":9030,"name":"IM251208002"},"unread":0,"can_update":true,"can_delete":true},{"id":1094,"attachment_id":29538,"client_id":149,"title":"\u516c\u5b89\u90e8\u4e00\u6240\u73b0\u573a\u5de1\u68c0\u8868\uff082025\u5e7410\u6708\uff09.docx","description":"","created_by":5085,"created_at":"2025-11-04 19:15:34","updated_at":"2025-11-04 19:15:34","project_id":3716,"case_id":8933,"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"attachment":{"id":29538,"key":29538,"name":"8c21f780-85d5-38df-b45f-e42a9b8c44c8","extension":"docx","path":"\/vue\/attachment\/preview\/8c21f780-85d5-38df-b45f-e42a9b8c44c8\/\u516c\u5b89\u90e8\u4e00\u6240\u73b0\u573a\u5de1\u68c0\u8868\uff082025\u5e7410\u6708\uff09.docx","orig_name":"\u516c\u5b89\u90e8\u4e00\u6240\u73b0\u573a\u5de1\u68c0\u8868\uff082025\u5e7410\u6708\uff09.docx"},"commentCount":{},"unreadComments":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"project":{"id":3716,"key":3716,"name":"\u7eff\u536124-25\u5e74\u5ea6\u6280\u672f\u670d\u52a1"},"case":{"id":8933,"key":8933,"name":"IM251103003"},"unread":0,"can_update":true,"can_delete":true},{"id":1093,"attachment_id":29537,"client_id":149,"title":"\u5de1\u68c0\u62a5\u544a\u5c01\u9762 10\u6708- -\u6c38\u5c45\u8bc1.doc","description":"","created_by":5085,"created_at":"2025-11-04 19:14:30","updated_at":"2025-11-04 19:14:30","project_id":3720,"case_id":8934,"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"attachment":{"id":29537,"key":29537,"name":"01824f61-1bba-3543-8197-69ebb439d3a7","extension":"doc","path":"\/vue\/attachment\/preview\/01824f61-1bba-3543-8197-69ebb439d3a7\/\u5de1\u68c0\u62a5\u544a\u5c01\u9762 10\u6708- -\u6c38\u5c45\u8bc1.doc","orig_name":"\u5de1\u68c0\u62a5\u544a\u5c01\u9762 10\u6708- -\u6c38\u5c45\u8bc1.doc"},"commentCount":{},"unreadComments":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"project":{"id":3720,"key":3720,"name":"\u81ea\u52a8\u5316\u8bbe\u5907\u4e09\u671f"},"case":{"id":8934,"key":8934,"name":"IM251103004"},"unread":0,"can_update":true,"can_delete":true},{"id":1092,"attachment_id":29536,"client_id":149,"title":"\u516c\u5b89\u90e8\u4e00\u6240\u6c38\u5c45\u8bc1\u6708\u5ea625\u5e7410\u6708\u5de1\u68c0\u8868.docx","description":"","created_by":5085,"created_at":"2025-11-04 19:14:30","updated_at":"2025-11-04 19:14:30","project_id":3720,"case_id":8934,"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"attachment":{"id":29536,"key":29536,"name":"cc4b8c81-e70c-3b57-b6de-a40b15fc0df1","extension":"docx","path":"\/vue\/attachment\/preview\/cc4b8c81-e70c-3b57-b6de-a40b15fc0df1\/\u516c\u5b89\u90e8\u4e00\u6240\u6c38\u5c45\u8bc1\u6708\u5ea625\u5e7410\u6708\u5de1\u68c0\u8868.docx","orig_name":"\u516c\u5b89\u90e8\u4e00\u6240\u6c38\u5c45\u8bc1\u6708\u5ea625\u5e7410\u6708\u5de1\u68c0\u8868.docx"},"commentCount":{},"unreadComments":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"project":{"id":3720,"key":3720,"name":"\u81ea\u52a8\u5316\u8bbe\u5907\u4e09\u671f"},"case":{"id":8934,"key":8934,"name":"IM251103004"},"unread":0,"can_update":true,"can_delete":true},{"id":1064,"attachment_id":28921,"client_id":149,"title":"\u5de1\u68c0\u62a5\u544a\u5c01\u9762 9\u6708- -\u6c38\u5c45\u8bc1.pdf","description":"","created_by":5085,"created_at":"2025-10-15 21:51:55","updated_at":"2025-10-15 21:51:55","project_id":3720,"case_id":8880,"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"attachment":{"id":28921,"key":28921,"name":"cc9f35c7-554a-3594-b657-ad6bdbd73e3c","extension":"pdf","path":"\/vue\/attachment\/preview\/cc9f35c7-554a-3594-b657-ad6bdbd73e3c\/\u5de1\u68c0\u62a5\u544a\u5c01\u9762 9\u6708- -\u6c38\u5c45\u8bc1.pdf","orig_name":"\u5de1\u68c0\u62a5\u544a\u5c01\u9762 9\u6708- -\u6c38\u5c45\u8bc1.pdf"},"commentCount":{},"unreadComments":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"project":{"id":3720,"key":3720,"name":"\u81ea\u52a8\u5316\u8bbe\u5907\u4e09\u671f"},"case":{"id":8880,"key":8880,"name":"IM251015005"},"unread":0,"can_update":true,"can_delete":true},{"id":1063,"attachment_id":28922,"client_id":149,"title":"\u5de1\u68c0\u62a5\u544a\u5c01\u9762 9\u6708- -\u6c38\u5c45\u8bc1.doc","description":"","created_by":5085,"created_at":"2025-10-15 21:51:55","updated_at":"2025-10-15 21:51:55","project_id":3720,"case_id":8880,"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"attachment":{"id":28922,"key":28922,"name":"75c69f1a-a20d-3946-852f-d346c3f595ea","extension":"doc","path":"\/vue\/attachment\/preview\/75c69f1a-a20d-3946-852f-d346c3f595ea\/\u5de1\u68c0\u62a5\u544a\u5c01\u9762 9\u6708- -\u6c38\u5c45\u8bc1.doc","orig_name":"\u5de1\u68c0\u62a5\u544a\u5c01\u9762 9\u6708- -\u6c38\u5c45\u8bc1.doc"},"commentCount":{},"unreadComments":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"project":{"id":3720,"key":3720,"name":"\u81ea\u52a8\u5316\u8bbe\u5907\u4e09\u671f"},"case":{"id":8880,"key":8880,"name":"IM251015005"},"unread":0,"can_update":true,"can_delete":true},{"id":1062,"attachment_id":28920,"client_id":149,"title":"\u516c\u5b89\u90e8\u4e00\u6240\u6c38\u5c45\u8bc1\u6708\u5ea625\u5e749\u6708\u5de1\u68c0\u8868.pdf","description":"","created_by":5085,"created_at":"2025-10-15 21:51:55","updated_at":"2025-10-15 21:51:55","project_id":3720,"case_id":8880,"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"attachment":{"id":28920,"key":28920,"name":"2fb82f89-352e-3afd-8503-edc776c706a7","extension":"pdf","path":"\/vue\/attachment\/preview\/2fb82f89-352e-3afd-8503-edc776c706a7\/\u516c\u5b89\u90e8\u4e00\u6240\u6c38\u5c45\u8bc1\u6708\u5ea625\u5e749\u6708\u5de1\u68c0\u8868.pdf","orig_name":"\u516c\u5b89\u90e8\u4e00\u6240\u6c38\u5c45\u8bc1\u6708\u5ea625\u5e749\u6708\u5de1\u68c0\u8868.pdf"},"commentCount":{},"unreadComments":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"project":{"id":3720,"key":3720,"name":"\u81ea\u52a8\u5316\u8bbe\u5907\u4e09\u671f"},"case":{"id":8880,"key":8880,"name":"IM251015005"},"unread":0,"can_update":true,"can_delete":true},{"id":1061,"attachment_id":28919,"client_id":149,"title":"\u516c\u5b89\u90e8\u4e00\u6240\u6c38\u5c45\u8bc1\u6708\u5ea625\u5e749\u6708\u5de1\u68c0\u8868.docx","description":"","created_by":5085,"created_at":"2025-10-15 21:51:55","updated_at":"2025-10-15 21:51:55","project_id":3720,"case_id":8880,"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"attachment":{"id":28919,"key":28919,"name":"d7b9507f-7ef8-30d5-b665-b5e9cdf19ac4","extension":"docx","path":"\/vue\/attachment\/preview\/d7b9507f-7ef8-30d5-b665-b5e9cdf19ac4\/\u516c\u5b89\u90e8\u4e00\u6240\u6c38\u5c45\u8bc1\u6708\u5ea625\u5e749\u6708\u5de1\u68c0\u8868.docx","orig_name":"\u516c\u5b89\u90e8\u4e00\u6240\u6c38\u5c45\u8bc1\u6708\u5ea625\u5e749\u6708\u5de1\u68c0\u8868.docx"},"commentCount":{},"unreadComments":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"project":{"id":3720,"key":3720,"name":"\u81ea\u52a8\u5316\u8bbe\u5907\u4e09\u671f"},"case":{"id":8880,"key":8880,"name":"IM251015005"},"unread":0,"can_update":true,"can_delete":true},{"id":1060,"attachment_id":28917,"client_id":149,"title":"\u516c\u5b89\u90e8\u4e00\u6240\u73b0\u573a\u5de1\u68c0\u8868\uff082025\u5e749\u6708\uff09.pdf","description":"","created_by":5085,"created_at":"2025-10-15 21:51:06","updated_at":"2025-10-15 21:51:06","project_id":3716,"case_id":8879,"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"attachment":{"id":28917,"key":28917,"name":"86fc9b85-fe8d-3e4e-91ec-197baa1cfbcc","extension":"pdf","path":"\/vue\/attachment\/preview\/86fc9b85-fe8d-3e4e-91ec-197baa1cfbcc\/\u516c\u5b89\u90e8\u4e00\u6240\u73b0\u573a\u5de1\u68c0\u8868\uff082025\u5e749\u6708\uff09.pdf","orig_name":"\u516c\u5b89\u90e8\u4e00\u6240\u73b0\u573a\u5de1\u68c0\u8868\uff082025\u5e749\u6708\uff09.pdf"},"commentCount":{},"unreadComments":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"project":{"id":3716,"key":3716,"name":"\u7eff\u536124-25\u5e74\u5ea6\u6280\u672f\u670d\u52a1"},"case":{"id":8879,"key":8879,"name":"IM251015004"},"unread":0,"can_update":true,"can_delete":true},{"id":1059,"attachment_id":28918,"client_id":149,"title":"\u516c\u5b89\u90e8\u4e00\u6240\u73b0\u573a\u5de1\u68c0\u8868\uff082025\u5e749\u6708\uff09.docx","description":"","created_by":5085,"created_at":"2025-10-15 21:51:06","updated_at":"2025-10-15 21:51:06","project_id":3716,"case_id":8879,"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","department_id":2,"avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"attachment":{"id":28918,"key":28918,"name":"2b821231-08cf-3bf0-807b-33b0f24558bd","extension":"docx","path":"\/vue\/attachment\/preview\/2b821231-08cf-3bf0-807b-33b0f24558bd\/\u516c\u5b89\u90e8\u4e00\u6240\u73b0\u573a\u5de1\u68c0\u8868\uff082025\u5e749\u6708\uff09.docx","orig_name":"\u516c\u5b89\u90e8\u4e00\u6240\u73b0\u573a\u5de1\u68c0\u8868\uff082025\u5e749\u6708\uff09.docx"},"commentCount":{},"unreadComments":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)"},"project":{"id":3716,"key":3716,"name":"\u7eff\u536124-25\u5e74\u5ea6\u6280\u672f\u670d\u52a1"},"case":{"id":8879,"key":8879,"name":"IM251015004"},"unread":0,"can_update":true,"can_delete":true}],"can_create":true,"pagenation":{"totalcount":151,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/148.0.0.0 Safari\/537.36"}', FALSE, '2026-06-03 16:50:29', 131827968) RETURNING "id"

[+] Explain