ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68677e85912ee: POST https://beta.jinchangxiao.com/v2/comment/clear-unread at 2025-07-04 03:11:01 pm by 120.236.232.134

Database Queries

总计12条数据
TimeDurationTypeQuery
  
15:11:01.5982.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd'

[+] Explain
15:11:01.6011.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
15:11:01.60317.2 msSELECTSELECT "uc".* FROM "a57be577deb434"."tbl_unread_comments" "uc" LEFT JOIN "a57be577deb434"."tbl_comments" "c" ON (c.id = uc.comment_id) AND (uc.remind_user_id = 1000) WHERE ("uc"."remind_user_id"=1000) AND ("uc"."is_read"=FALSE) AND ("c"."is_system"='true')

[+] Explain
15:11:01.6213.4 msUPDATEUPDATE "a57be577deb434"."tbl_unread_comments" SET "is_read"=TRUE WHERE "id" IN (228795, 228906, 228911, 228796)

[+] Explain
15:11:01.62415.2 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 = 1000) WHERE ("uc"."remind_user_id"=1000) AND ("uc"."is_read"=FALSE) AND ("c"."is_system"=FALSE)

[+] Explain
15:11:01.63915.1 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 = 1000) WHERE ("uc"."remind_user_id"=1000) AND ("uc"."is_read"=FALSE) AND ("c"."is_system"=TRUE)

[+] Explain
15:11:01.65574.3 msSELECTSELECT COUNT(*) FROM (SELECT c.*, uc.remind_user_id, CASE WHEN c.created_by = 1000 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 = 1000) WHERE (("uc"."remind_user_id"=1000) OR ("c"."created_by"=1000)) AND ("c"."is_system"='true') ORDER BY "is_read", "c"."created_at" DESC) "c"

[+] Explain
15:11:01.72977.2 msSELECTSELECT c.*, uc.remind_user_id, CASE WHEN c.created_by = 1000 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 = 1000) WHERE (("uc"."remind_user_id"=1000) OR ("c"."created_by"=1000)) AND ("c"."is_system"='true') ORDER BY "is_read", "c"."created_at" DESC LIMIT 20

[+] Explain
15:11:01.8071.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=310) AND ("object_id" IN (170268, 170267, 170266, 170264, 170263, 170262, 170261, 170260, 170259, 170258, 170257, 170256, 170255, 170254, 170253, 170252, 170251, 170250, 170246, 170245))

[+] Explain
15:11:01.8090.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 1017)

[+] Explain
15:11:01.8090.4 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1017, 1000))

[+] Explain
15:11:01.8111.4 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 6, 166, 'v2/comment/clear-unread', '{"is_system":"true","posttime":"1751613061","access_token":"Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd","device_type":"6","version_code":"166","token":"921d042c8ccf164997d6b73ad3be5bb6"}', '{"code":200,"data":{"announcementCount":0,"unreadCommentCount":0,"list":[{"id":170268,"object_id":17699,"object_type":"9","parent":null,"description":"\u66f9\u6c38\u751f\u66f4\u65b0\u4e86\u4e00\u6761\u5f85\u529e\u4e8b\u9879","created_by":1000,"created_at":"2025-07-04 14:37:30","reply_to":null,"is_system":true,"for_user":null,"description2":"\u5973\u5973\u5973","remind_user_id":null,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"can_delete":true,"title":"\u4f60\u7684\u7559\u8a00"},{"id":170267,"object_id":17699,"object_type":"9","parent":null,"description":"\u66f9\u6c38\u751f\u66f4\u65b0\u4e86\u4e00\u6761\u5f85\u529e\u4e8b\u9879","created_by":1000,"created_at":"2025-07-04 14:37:29","reply_to":null,"is_system":true,"for_user":null,"description2":"\u5973\u5973\u5973","remind_user_id":null,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"can_delete":true,"title":"\u4f60\u7684\u7559\u8a00"},{"id":170266,"object_id":8267,"object_type":"18","parent":null,"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":null,"is_system":true,"for_user":null,"description2":"","remind_user_id":null,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"can_delete":true,"title":"\u4f60\u7684\u7559\u8a00"},{"id":170264,"object_id":1738,"object_type":"37","parent":null,"description":"\u66f9\u6c38\u751f \u6709\u4e00\u4e2a\u5ba1\u6279\u9700\u8981\u5ba1\u6279","created_by":1000,"created_at":"2025-07-04 14:17:49","reply_to":null,"is_system":true,"for_user":null,"description2":"jfnnfn","remind_user_id":null,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"can_delete":true,"title":"\u4f60\u7684\u7559\u8a00"},{"id":170263,"object_id":37028,"object_type":"19","parent":null,"description":"\u66f9\u6c38\u751f\u66f4\u65b0\u4e86\u4e00\u6761\u5ba2\u60c5\u589e\u8fdb\u7684\u5de5\u4f5c\u65e5\u5fd7","created_by":1000,"created_at":"2025-07-04 14:17:04","reply_to":null,"is_system":true,"for_user":null,"description2":"hcnnc","remind_user_id":null,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"can_delete":true,"title":"\u4f60\u7684\u7559\u8a00"},{"id":170262,"object_id":37028,"object_type":"19","parent":null,"description":"\u66f9\u6c38\u751f\u65b0\u5efa\u4e86\u4e00\u6761\u5ba2\u60c5\u589e\u8fdb\u7684\u5de5\u4f5c\u65e5\u5fd7","created_by":1000,"created_at":"2025-07-04 14:16:35","reply_to":null,"is_system":true,"for_user":null,"description2":"hcnnc","remind_user_id":null,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"can_delete":true,"title":"\u4f60\u7684\u7559\u8a00"},{"id":170261,"object_id":17698,"object_type":"9","parent":null,"description":"\u66f9\u6c38\u751f\u66f4\u65b0\u4e86\u4e00\u6761\u5f85\u529e\u4e8b\u9879","created_by":1000,"created_at":"2025-07-04 14:15:52","reply_to":null,"is_system":true,"for_user":null,"description2":"\u624d\u80fd\u5065\u5eb7","remind_user_id":null,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"can_delete":true,"title":"\u4f60\u7684\u7559\u8a00"},{"id":170260,"object_id":17700,"object_type":"9","parent":null,"description":"\u66f9\u6c38\u751f\u66f4\u65b0\u4e86\u4e00\u6761\u5f85\u529e\u4e8b\u9879","created_by":1000,"created_at":"2025-07-04 14:15:49","reply_to":null,"is_system":true,"for_user":null,"description2":"nfnfb","remind_user_id":null,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"can_delete":true,"title":"\u4f60\u7684\u7559\u8a00"},{"id":170259,"object_id":17700,"object_type":"9","parent":null,"description":"\u66f9\u6c38\u751f\u66f4\u65b0\u4e86\u4e00\u6761\u5f85\u529e\u4e8b\u9879","created_by":1000,"created_at":"2025-07-04 14:15:44","reply_to":null,"is_system":true,"for_user":null,"description2":"nfnfb","remind_user_id":null,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"can_delete":true,"title":"\u4f60\u7684\u7559\u8a00"},{"id":170258,"object_id":17700,"object_type":"9","parent":null,"description":"\u66f9\u6c38\u751f\u5b8c\u6210\u4e86\u4e00\u6761\u5f85\u529e\u4e8b\u9879","created_by":1000,"created_at":"2025-07-04 14:15:42","reply_to":null,"is_system":true,"for_user":null,"description2":"nfnfb","remind_user_id":null,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"can_delete":true,"title":"\u4f60\u7684\u7559\u8a00"},{"id":170257,"object_id":17700,"object_type":"9","parent":null,"description":"\u66f9\u6c38\u751f\u66f4\u65b0\u4e86\u4e00\u6761\u5f85\u529e\u4e8b\u9879","created_by":1000,"created_at":"2025-07-04 14:15:42","reply_to":null,"is_system":true,"for_user":null,"description2":"nfnfb","remind_user_id":null,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"can_delete":true,"title":"\u4f60\u7684\u7559\u8a00"},{"id":170256,"object_id":17700,"object_type":"9","parent":null,"description":"\u66f9\u6c38\u751f\u66f4\u65b0\u4e86\u4e00\u6761\u5f85\u529e\u4e8b\u9879","created_by":1000,"created_at":"2025-07-04 14:15:37","reply_to":null,"is_system":true,"for_user":null,"description2":"nfnfb","remind_user_id":null,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"can_delete":true,"title":"\u4f60\u7684\u7559\u8a00"},{"id":170255,"object_id":17700,"object_type":"9","parent":null,"description":"\u66f9\u6c38\u751f\u65b0\u5efa\u4e86\u4e00\u6761\u5f85\u529e\u4e8b\u9879","created_by":1000,"created_at":"2025-07-04 14:15:30","reply_to":null,"is_system":true,"for_user":null,"description2":"nfnfb","remind_user_id":null,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"can_delete":true,"title":"\u4f60\u7684\u7559\u8a00"},{"id":170254,"object_id":7445,"object_type":"20","parent":null,"description":"\u66f9\u6c38\u751f \u901a\u8fc7\u4e86\u8fd9\u4e2a\u62a5\u9500","created_by":1000,"created_at":"2025-07-04 14:15:05","reply_to":null,"is_system":true,"for_user":null,"description2":"","remind_user_id":null,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"can_delete":true,"title":"\u4f60\u7684\u7559\u8a00"},{"id":170253,"object_id":8264,"object_type":"18","parent":null,"description":"\u8f66\u660e\u98de\u63a5\u53d7\u4e86\u4e00\u4e2aCase","created_by":1017,"created_at":"2025-07-04 12:05:11","reply_to":null,"is_system":true,"for_user":null,"description2":"\u89c1\u89c1\u4f60\u5462","remind_user_id":1000,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","sex":"M","avatar":{"id":8,"user_id":1017,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e538f0fe-48a7-33da-a512-b252266c9e91.jpg"}},"can_delete":false,"title":"\u8f66\u660e\u98de\u7ed9\u4f60\u7684\u7559\u8a00"},{"id":170252,"object_id":8264,"object_type":"18","parent":null,"description":"\u66f9\u6c38\u751f\u5206\u914d\u4e86\u4e00\u4e2aCase\u7ed9\u8f66\u660e\u98de","created_by":1000,"created_at":"2025-07-04 12:05:02","reply_to":null,"is_system":true,"for_user":null,"description2":"\u89c1\u89c1\u4f60\u5462","remind_user_id":null,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"can_delete":true,"title":"\u4f60\u7684\u7559\u8a00"},{"id":170251,"object_id":8268,"object_type":"18","parent":null,"description":"\u8f66\u660e\u98de\u63a5\u53d7\u4e86\u4e00\u4e2aCase","created_by":1017,"created_at":"2025-07-04 12:02:09","reply_to":null,"is_system":true,"for_user":null,"description2":"\u4fca\u4fca","remind_user_id":1000,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","sex":"M","avatar":{"id":8,"user_id":1017,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e538f0fe-48a7-33da-a512-b252266c9e91.jpg"}},"can_delete":false,"title":"\u8f66\u660e\u98de\u7ed9\u4f60\u7684\u7559\u8a00"},{"id":170250,"object_id":1737,"object_type":"37","parent":null,"description":"\u66f9\u6c38\u751f \u6709\u4e00\u4e2a\u5ba1\u6279\u9700\u8981\u5ba1\u6279","created_by":1000,"created_at":"2025-07-04 11:25:54","reply_to":null,"is_system":true,"for_user":null,"description2":"\u5feb\u653e\u5047\u6210\u7ee9","remind_user_id":null,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"can_delete":true,"title":"\u4f60\u7684\u7559\u8a00"},{"id":170246,"object_id":8268,"object_type":"18","parent":null,"description":"\u66f9\u6c38\u751f\u5206\u914d\u4e86\u4e00\u4e2aCase\u7ed9\u8f66\u660e\u98de","created_by":1000,"created_at":"2025-07-04 11:05:50","reply_to":null,"is_system":true,"for_user":null,"description2":"\u4fca\u4fca","remind_user_id":null,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"can_delete":true,"title":"\u4f60\u7684\u7559\u8a00"},{"id":170245,"object_id":8268,"object_type":"18","parent":null,"description":"\u60a8\u67091\u4e2aCase\u5f85\u5206\u914d","created_by":1000,"created_at":"2025-07-04 11:03:12","reply_to":null,"is_system":true,"for_user":null,"description2":"\u4fca\u4fca","remind_user_id":null,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"F","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"can_delete":true,"title":"\u4f60\u7684\u7559\u8a00"}],"pagenation":{"totalcount":1218,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-04 15:11:01') RETURNING "id"

[+] Explain