ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
686792aa1a3a9: POST https://beta.jinchangxiao.com/vue/announcement/list at 2025-07-04 04:36:58 pm by 114.254.1.137

Database Queries

总计10条数据
TimeDurationTypeQuery
  
16:36:58.1297.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

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

[+] Explain
16:36:58.16833.3 msSELECTSELECT COUNT(*) FROM "a57be577deb434"."tbl_unread_comments" "uc" LEFT JOIN "a57be577deb434"."tbl_comments" "c" ON (c.id = uc.comment_id) AND (uc.remind_user_id = 1001) WHERE ("uc"."remind_user_id"=1001) AND ("uc"."is_read"=FALSE) AND ("c"."is_system"=FALSE)

[+] Explain
16:36:58.20428.3 msSELECTSELECT COUNT(*) FROM "a57be577deb434"."tbl_unread_comments" "uc" LEFT JOIN "a57be577deb434"."tbl_comments" "c" ON (c.id = uc.comment_id) AND (uc.remind_user_id = 1001) WHERE ("uc"."remind_user_id"=1001) AND ("uc"."is_read"=FALSE) AND ("c"."is_system"=TRUE)

[+] Explain
16:36:58.236254.5 msSELECTSELECT COUNT(*) FROM (SELECT c.*, uc.remind_user_id, CASE WHEN c.created_by = 1001 OR uc.is_read = true THEN true ElSE false END AS is_read FROM "a57be577deb434"."tbl_comments" "c" LEFT JOIN "a57be577deb434"."tbl_unread_comments" "uc" ON (c.id = uc.comment_id) AND (uc.remind_user_id = 1001) WHERE (("uc"."remind_user_id"=1001) OR ("c"."created_by"=1001)) AND ("c"."is_system"='1') ORDER BY "is_read", "c"."created_at" DESC) "c"

[+] Explain
16:36:58.491278.6 msSELECTSELECT c.*, uc.remind_user_id, CASE WHEN c.created_by = 1001 OR uc.is_read = true THEN true ElSE false END AS is_read FROM "a57be577deb434"."tbl_comments" "c" LEFT JOIN "a57be577deb434"."tbl_unread_comments" "uc" ON (c.id = uc.comment_id) AND (uc.remind_user_id = 1001) WHERE (("uc"."remind_user_id"=1001) OR ("c"."created_by"=1001)) AND ("c"."is_system"='1') ORDER BY "is_read", "c"."created_at" DESC LIMIT 20

[+] Explain
16:36:58.7765.1 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5250, 5064, 5300, 5016, 1001)

[+] Explain
16:36:58.7835.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5250, 5016, 5064, 5300, 1000))

[+] Explain
16:36:58.7892.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=310) AND ("object_id" IN (170266, 170101, 170088, 170062, 170060, 170049, 170048, 170047, 170045, 170031, 170030, 169791, 169789, 170238, 170232, 170231, 170229, 170227, 170226, 170205))

[+] Explain
16:36:58.7979.9 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/announcement/list', '{"page":"1","is_system":"1","web_access_token":"tld3jO0KyGCnBfJLTA8332fg4dJPv04V"}', '{"code":2000,"result":{"list":[{"id":170266,"object_id":8267,"object_type":"18","parent":"","description":"\u66f9\u6c38\u751f\u5206\u914d\u4e86\u4e00\u4e2aCase\u7ed9\u8f66\u660e\u98de","created_by":1000,"created_at":"2025-07-04 14:19:12","reply_to":"","is_system":true,"for_user":"","description2":"","remind_user_id":1001,"is_read":false,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"replyTo":"","attachmentRelationships":[],"forUser":"","parentComment":{},"title":"\u66f9\u6c38\u751f\u7ed9\u4f60\u7684\u7559\u8a00","object_type_display":"Case","object_type_icon":"icon-gongdanguanli","bgcolor":"#89c541"},{"id":170101,"object_id":37019,"object_type":"19","parent":"","description":"\u66f9\u6c38\u751f\u66f4\u65b0\u4e86\u4e00\u6761\u552e\u540e\u670d\u52a1\u7684\u5de5\u4f5c\u65e5\u5fd7","created_by":1000,"created_at":"2025-06-12 20:21:42","reply_to":"","is_system":true,"for_user":"","description2":"\u54c8\u54c8\u54c8\u54c8","remind_user_id":1001,"is_read":false,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"replyTo":"","attachmentRelationships":[],"forUser":"","parentComment":{},"title":"\u66f9\u6c38\u751f\u7ed9\u4f60\u7684\u7559\u8a00","object_type_display":"\u5de5\u4f5c\u65e5\u5fd7","object_type_icon":"icon-gongzuorizhi","bgcolor":"#89c541"},{"id":170088,"object_id":3807,"object_type":"1","parent":"","description":"\u6b64\u5546\u673a\u5df2\u6536\u56de\u5168\u90e8\u6b3e\u9879","created_by":5250,"created_at":"2025-06-09 18:05:34","reply_to":"","is_system":true,"for_user":"","description2":"\u5546\u673a\uff1a\u6d4b\u8bd5 \u4f3c\u61c2\u975e\u61c2\u8212\u670d\u8303\u5fb7\u8428\u4e0a\uff1b\u5ba2\u6237\uff1a\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","remind_user_id":1001,"is_read":false,"createdBy":{"id":5250,"key":5250,"name":"\u8463\u8363","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}},"replyTo":"","attachmentRelationships":[],"forUser":"","parentComment":{},"title":"\u8463\u8363\u7ed9\u4f60\u7684\u7559\u8a00","object_type_display":"\u5546\u673a","object_type_icon":"icon-shangjixinxi","bgcolor":"#89c541"},{"id":170062,"object_id":8267,"object_type":"18","parent":"","description":"\u59da\u96ea\u7eaf\u521b\u5efa\u4e861\u4e2aCASE","created_by":5064,"created_at":"2025-05-26 17:17:18","reply_to":"","is_system":true,"for_user":"","description2":"","remind_user_id":1001,"is_read":false,"createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}},"replyTo":"","attachmentRelationships":[],"forUser":"","parentComment":{},"title":"\u59da\u96ea\u7eaf\u7ed9\u4f60\u7684\u7559\u8a00","object_type_display":"Case","object_type_icon":"icon-gongdanguanli","bgcolor":"#89c541"},{"id":170060,"object_id":8266,"object_type":"18","parent":"","description":"\u59da\u96ea\u7eaf\u521b\u5efa\u4e861\u4e2aCASE","created_by":5064,"created_at":"2025-05-26 17:01:54","reply_to":"","is_system":true,"for_user":"","description2":"","remind_user_id":1001,"is_read":false,"createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}},"replyTo":"","attachmentRelationships":[],"forUser":"","parentComment":{},"title":"\u59da\u96ea\u7eaf\u7ed9\u4f60\u7684\u7559\u8a00","object_type_display":"Case","object_type_icon":"icon-gongdanguanli","bgcolor":"#89c541"},{"id":170049,"object_id":37011,"object_type":"19","parent":"","description":"\u82cf\u6e05\u4e91\u66f4\u65b0\u4e86\u4e00\u6761\u552e\u540e\u670d\u52a1\u7684\u5de5\u4f5c\u65e5\u5fd7","created_by":5300,"created_at":"2025-05-20 00:36:42","reply_to":"","is_system":true,"for_user":"","description2":"\u76ee\u6807\uff1a\u5e2e\u52a9\u5ba2\u6237\u63d0\u4f9bPA XDR\u8d44\u6599\u8bf4\u660eXDR\u548c\u666e\u901a\u7ec8\u7aef\u9632\u62a4\u7684\u533a\u522b\u52a8\u4f5c\uff1a\u7535\u8bdd\u5ba2\u6237\uff0c\u5e2e\u52a9\u5ba2\u6237\u5b89\u6392\u6280\u672f\u63d0\u4f9b\u6587\u5b57\u63cf\u8ff0\uff0c\u8bf4\u660e\u672c\u5730\u7aef\u4fa7\u9632\u62a4\u548cXDR\u9632\u62a4\u7684\u533a\u522b\uff0c\u534f\u52a9\u5ba2\u6237\u5b8c\u6210\u660e\u5929\u4e0a\u5348\u548c\u9886\u5bfc\u7684\u6c47\u62a5\u7ed3\u679c\uff1a\u8fbe\u5230\u9884\u671f\u3002\u5df2\u63d0\u4f9b\u76f8\u5173\u8d44\u6599\uff0c\u5e2e\u52a9\u5ba2\u6237\u63d0\u4f9b\u8f85\u52a9\u603b\u7ed3\u8d44\u6599\uff0c\u534f\u52a9\u6c47\u62a5","remind_user_id":1001,"is_read":false,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"replyTo":"","attachmentRelationships":[],"forUser":"","parentComment":{},"title":"\u82cf\u6e05\u4e91\u7ed9\u4f60\u7684\u7559\u8a00","object_type_display":"\u5de5\u4f5c\u65e5\u5fd7","object_type_icon":"icon-gongzuorizhi","bgcolor":"#89c541"},{"id":170048,"object_id":37020,"object_type":"19","parent":"","description":"\u82cf\u6e05\u4e91\u66f4\u65b0\u4e86\u4e00\u6761\u6316\u6398\u5546\u673a\u7684\u5de5\u4f5c\u65e5\u5fd7","created_by":5300,"created_at":"2025-05-20 00:36:28","reply_to":"","is_system":true,"for_user":"","description2":"\u5251\u5357\u6625\u4f60\u5462","remind_user_id":1001,"is_read":false,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"replyTo":"","attachmentRelationships":[],"forUser":"","parentComment":{},"title":"\u82cf\u6e05\u4e91\u7ed9\u4f60\u7684\u7559\u8a00","object_type_display":"\u5de5\u4f5c\u65e5\u5fd7","object_type_icon":"icon-gongzuorizhi","bgcolor":"#89c541"},{"id":170047,"object_id":37020,"object_type":"19","parent":"","description":"\u82cf\u6e05\u4e91\u6709\u4e00\u6761\u6316\u6398\u5546\u673a\u7684\u5de5\u4f5c\u65e5\u5fd7\u9700\u8981\u5ba1\u9605","created_by":5300,"created_at":"2025-05-20 00:36:09","reply_to":"","is_system":true,"for_user":"","description2":"\u5251\u5357\u6625\u4f60\u5462","remind_user_id":1001,"is_read":false,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"replyTo":"","attachmentRelationships":[],"forUser":"","parentComment":{},"title":"\u82cf\u6e05\u4e91\u7ed9\u4f60\u7684\u7559\u8a00","object_type_display":"\u5de5\u4f5c\u65e5\u5fd7","object_type_icon":"icon-gongzuorizhi","bgcolor":"#89c541"},{"id":170045,"object_id":36978,"object_type":"19","parent":"","description":"\u82cf\u6e05\u4e91\u6709\u4e00\u6761\u6316\u6398\u5546\u673a\u7684\u5de5\u4f5c\u65e5\u5fd7\u9700\u8981\u5ba1\u9605","created_by":5300,"created_at":"2025-05-20 00:35:22","reply_to":"","is_system":true,"for_user":"","description2":"","remind_user_id":1001,"is_read":false,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"replyTo":"","attachmentRelationships":[],"forUser":"","parentComment":{},"title":"\u82cf\u6e05\u4e91\u7ed9\u4f60\u7684\u7559\u8a00","object_type_display":"\u5de5\u4f5c\u65e5\u5fd7","object_type_icon":"icon-gongzuorizhi","bgcolor":"#89c541"},{"id":170031,"object_id":37019,"object_type":"19","parent":"","description":"\u82cf\u6e05\u4e91\u66f4\u65b0\u4e86\u4e00\u6761\u552e\u540e\u670d\u52a1\u7684\u5de5\u4f5c\u65e5\u5fd7","created_by":5300,"created_at":"2025-05-16 16:31:07","reply_to":"","is_system":true,"for_user":"","description2":"\u54c8\u54c8\u54c8\u54c8","remind_user_id":1001,"is_read":false,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"replyTo":"","attachmentRelationships":[],"forUser":"","parentComment":{},"title":"\u82cf\u6e05\u4e91\u7ed9\u4f60\u7684\u7559\u8a00","object_type_display":"\u5de5\u4f5c\u65e5\u5fd7","object_type_icon":"icon-gongzuorizhi","bgcolor":"#89c541"},{"id":170030,"object_id":37019,"object_type":"19","parent":"","description":"\u82cf\u6e05\u4e91\u6709\u4e00\u6761\u6316\u6398\u5546\u673a\u7684\u5de5\u4f5c\u65e5\u5fd7\u9700\u8981\u5ba1\u9605","created_by":5300,"created_at":"2025-05-16 16:30:11","reply_to":"","is_system":true,"for_user":"","description2":"\u54c8\u54c8\u54c8\u54c8","remind_user_id":1001,"is_read":false,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"replyTo":"","attachmentRelationships":[],"forUser":"","parentComment":{},"title":"\u82cf\u6e05\u4e91\u7ed9\u4f60\u7684\u7559\u8a00","object_type_display":"\u5de5\u4f5c\u65e5\u5fd7","object_type_icon":"icon-gongzuorizhi","bgcolor":"#89c541"},{"id":169791,"object_id":3795,"object_type":"1","parent":"","description":"\u9ad8\u90e1\u9633\u66f4\u65b0\u4e86\u4e00\u6761\u5546\u673a\u72b6\u6001\u660e\u786e\u9700\u6c42\u53d8\u4e3a\u5546\u673a\u6210\u4ea4","created_by":5016,"created_at":"2025-04-14 14:24:56","reply_to":"","is_system":true,"for_user":"","description2":"","remind_user_id":1001,"is_read":false,"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}},"replyTo":"","attachmentRelationships":[],"forUser":"","parentComment":{},"title":"\u9ad8\u90e1\u9633\u7ed9\u4f60\u7684\u7559\u8a00","object_type_display":"\u5546\u673a","object_type_icon":"icon-shangjixinxi","bgcolor":"#89c541"},{"id":169789,"object_id":3796,"object_type":"1","parent":"","description":"\u8463\u8363\u66f4\u65b0\u4e86\u4e00\u6761\u5546\u673a\u72b6\u6001\u660e\u786e\u9700\u6c42\u53d8\u4e3a\u5546\u673a\u6210\u4ea4","created_by":5250,"created_at":"2025-04-14 13:27:44","reply_to":"","is_system":true,"for_user":"","description2":"","remind_user_id":1001,"is_read":false,"createdBy":{"id":5250,"key":5250,"name":"\u8463\u8363","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}},"replyTo":"","attachmentRelationships":[],"forUser":"","parentComment":{},"title":"\u8463\u8363\u7ed9\u4f60\u7684\u7559\u8a00","object_type_display":"\u5546\u673a","object_type_icon":"icon-shangjixinxi","bgcolor":"#89c541"},{"id":170238,"object_id":3852,"object_type":"13","parent":"","description":"\u5218\u4eba\u8bda\u521b\u5efa\u4e86\u4e00\u6761\u8d39\u7528\u5408\u540c","created_by":1001,"created_at":"2025-07-04 11:00:14","reply_to":"","is_system":true,"for_user":"","description2":"\u91c7\u8d2d\u5408\u540c\uff1a","remind_user_id":"","is_read":true,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"replyTo":"","attachmentRelationships":[],"forUser":"","parentComment":{},"title":"\u4f60\u7684\u7559\u8a00","object_type_display":"\u91c7\u8d2d\/\u8d39\u7528\u5408\u540c","object_type_icon":"icon-caigouhetong","bgcolor":"#89c541"},{"id":170232,"object_id":3850,"object_type":"13","parent":"","description":"\u5218\u4eba\u8bda\u63d0\u4ea4\u4e86\u4ed8\u6b3e\u8bb0\u5f55\uff1a\u8d39\u7528\u5408\u540c\u7f16\u53f7\u4ed8\u6b3e\u91d1\u989d1\u5143","created_by":1001,"created_at":"2025-07-04 10:20:11","reply_to":"","is_system":true,"for_user":"","description2":"\u91c7\u8d2d\u5408\u540c\uff1a\u8d39\u7528\u5408\u540c\u7f16\u53f7","remind_user_id":"","is_read":true,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"replyTo":"","attachmentRelationships":[],"forUser":"","parentComment":{},"title":"\u4f60\u7684\u7559\u8a00","object_type_display":"\u91c7\u8d2d\/\u8d39\u7528\u5408\u540c","object_type_icon":"icon-caigouhetong","bgcolor":"#89c541"},{"id":170231,"object_id":1735,"object_type":"37","parent":"","description":"\u5218\u4eba\u8bda \u901a\u8fc7\u4e86\u8fd9\u4e2a\u5ba1\u6279","created_by":1001,"created_at":"2025-07-04 10:16:16","reply_to":"","is_system":true,"for_user":"","description2":"\u6d4b\u8bd5\u8d39\u7528\u5408\u540c","remind_user_id":"","is_read":true,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"replyTo":"","attachmentRelationships":[],"forUser":"","parentComment":{},"title":"\u4f60\u7684\u7559\u8a00","object_type_display":"\u5ba1\u6279\u7ba1\u7406","object_type_icon":"icon-shenpi","bgcolor":"#89c541"},{"id":170229,"object_id":3850,"object_type":"13","parent":"","description":"\u5218\u4eba\u8bda\u63d0\u4ea4\u4e86\u4ed8\u6b3e\u8bb0\u5f55\uff1a\u8d39\u7528\u5408\u540c\u7f16\u53f7\u4ed8\u6b3e\u91d1\u989d1\u5143","created_by":1001,"created_at":"2025-07-04 09:24:23","reply_to":"","is_system":true,"for_user":"","description2":"\u91c7\u8d2d\u5408\u540c\uff1a\u8d39\u7528\u5408\u540c\u7f16\u53f7","remind_user_id":"","is_read":true,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"replyTo":"","attachmentRelationships":[],"forUser":"","parentComment":{},"title":"\u4f60\u7684\u7559\u8a00","object_type_display":"\u91c7\u8d2d\/\u8d39\u7528\u5408\u540c","object_type_icon":"icon-caigouhetong","bgcolor":"#89c541"},{"id":170227,"object_id":3850,"object_type":"13","parent":"","description":"\u5218\u4eba\u8bda\u63d0\u4ea4\u4e86\u4ed8\u6b3e\u8bb0\u5f55\uff1a\u8d39\u7528\u5408\u540c\u7f16\u53f7\u4ed8\u6b3e\u91d1\u989d1\u5143","created_by":1001,"created_at":"2025-07-04 09:19:15","reply_to":"","is_system":true,"for_user":"","description2":"\u91c7\u8d2d\u5408\u540c\uff1a\u8d39\u7528\u5408\u540c\u7f16\u53f7","remind_user_id":"","is_read":true,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"replyTo":"","attachmentRelationships":[],"forUser":"","parentComment":{},"title":"\u4f60\u7684\u7559\u8a00","object_type_display":"\u91c7\u8d2d\/\u8d39\u7528\u5408\u540c","object_type_icon":"icon-caigouhetong","bgcolor":"#89c541"},{"id":170226,"object_id":3850,"object_type":"13","parent":"","description":"\u5218\u4eba\u8bda\u521b\u5efa\u4e86\u4e00\u6761\u8d39\u7528\u5408\u540c\uff1a\u6d4b\u8bd5","created_by":1001,"created_at":"2025-07-04 09:18:18","reply_to":"","is_system":true,"for_user":"","description2":"\u91c7\u8d2d\u5408\u540c\uff1a\u8d39\u7528\u5408\u540c\u7f16\u53f7","remind_user_id":"","is_read":true,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"replyTo":"","attachmentRelationships":[],"forUser":"","parentComment":{},"title":"\u4f60\u7684\u7559\u8a00","object_type_display":"\u91c7\u8d2d\/\u8d39\u7528\u5408\u540c","object_type_icon":"icon-caigouhetong","bgcolor":"#89c541"},{"id":170205,"object_id":3848,"object_type":"13","parent":"","description":"\u5218\u4eba\u8bda\u63d0\u4ea4\u4e86\u4ed8\u6b3e\u8bb0\u5f55\uff1a\u8d39\u7528\u5408\u540c\u4ed8\u6b3e\u91d1\u989d1\u5143","created_by":1001,"created_at":"2025-07-03 14:49:53","reply_to":"","is_system":true,"for_user":"","description2":"\u91c7\u8d2d\u5408\u540c\uff1a\u8d39\u7528\u5408\u540c","remind_user_id":"","is_read":true,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"replyTo":"","attachmentRelationships":[],"forUser":"","parentComment":{},"title":"\u4f60\u7684\u7559\u8a00","object_type_display":"\u91c7\u8d2d\/\u8d39\u7528\u5408\u540c","object_type_icon":"icon-caigouhetong","bgcolor":"#89c541"}],"can_create":true,"pagenation":{"totalcount":33819,"thispage":1,"pagesize":20},"unreadCommentCount":"","announcementCount":13},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-04 16:36:58') RETURNING "id"

[+] Explain