ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68737e0e5ca98: POST https://beta.jinchangxiao.com/v2/comment/clear-unread at 2025-07-13 05:36:14 pm by 120.244.156.33

Database Queries

总计15条数据
TimeDurationTypeQuery
  
17:36:14.3843.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc'

[+] Explain
17:36:14.3891.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004

[+] Explain
17:36:14.39119.6 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 = 1004) WHERE ("uc"."remind_user_id"=1004) AND ("uc"."is_read"=FALSE) AND ("c"."is_system"=0)

[+] Explain
17:36:14.4112.6 msUPDATEUPDATE "a57be577deb434"."tbl_unread_comments" SET "is_read"=TRUE WHERE "id" IN (228322, 228715, 228767, 228808, 228809, 228816, 228818, 228820, 228822, 228824, 228826, 229094, 229236, 229250, 229320)

[+] Explain
17:36:14.41420.9 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 = 1004) WHERE ("uc"."remind_user_id"=1004) AND ("uc"."is_read"=FALSE) AND ("c"."is_system"=FALSE)

[+] Explain
17:36:14.43520.5 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 = 1004) WHERE ("uc"."remind_user_id"=1004) AND ("uc"."is_read"=FALSE) AND ("c"."is_system"=TRUE)

[+] Explain
17:36:14.45762.0 msSELECTSELECT COUNT(*) FROM (SELECT c.*, uc.remind_user_id, CASE WHEN c.created_by = 1004 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 = 1004) WHERE (("uc"."remind_user_id"=1004) OR ("c"."created_by"=1004)) AND ("c"."is_system"=0) ORDER BY "is_read", "c"."created_at" DESC) "c"

[+] Explain
17:36:14.51991.4 msSELECTSELECT c.*, uc.remind_user_id, CASE WHEN c.created_by = 1004 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 = 1004) WHERE (("uc"."remind_user_id"=1004) OR ("c"."created_by"=1004)) AND ("c"."is_system"=0) ORDER BY "is_read", "c"."created_at" DESC LIMIT 20

[+] Explain
17:36:14.6112.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=310) AND ("object_id" IN (170479, 170421, 170417, 170367, 170172, 170171, 170170, 170169, 170168, 170167, 170159, 170158, 170122, 170089, 170011, 170010, 170009, 170008, 170007, 170006))

[+] Explain
17:36:14.6140.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004

[+] Explain
17:36:14.6140.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 1004)

[+] Explain
17:36:14.6150.5 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1004, 1000))

[+] Explain
17:36:14.6151.1 msSELECTSELECT "id", "parent", "created_by", "reply_to" FROM "a57be577deb434"."tbl_comments" WHERE "id"=170122

[+] Explain
17:36:14.6170.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
17:36:14.6184.2 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1004, 2, 1141, 'v2/comment/clear-unread', '{"access_token":"NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc","device_type":"2","is_system":"0","posttime":"1752399360","token":"fc51dcfe677ae58e495f8d5ac5a8198c","version_code":"1141"}', '{"code":200,"data":{"announcementCount":47,"unreadCommentCount":0,"list":[{"id":170479,"object_id":3338,"object_type":"10","parent":null,"description":"\u5b9d\u8d1d\u8d73\u8d73","created_by":1000,"created_at":"2025-07-11 16:26:20","reply_to":null,"is_system":false,"for_user":1004,"description2":"","remind_user_id":1004,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}},"can_delete":false,"title":"\u66f9\u6c38\u751f\u7ed9\u4f60\u7684\u7559\u8a00"},{"id":170421,"object_id":3811,"object_type":"1","parent":null,"description":"\u8d1d\u8d1d\u8840\u5b9d","created_by":1000,"created_at":"2025-07-11 14:31:42","reply_to":null,"is_system":false,"for_user":1004,"description2":"","remind_user_id":1004,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}},"can_delete":false,"title":"\u66f9\u6c38\u751f\u7ed9\u4f60\u7684\u7559\u8a00"},{"id":170417,"object_id":8279,"object_type":"18","parent":null,"description":"\u6253\u8f66","created_by":1000,"created_at":"2025-07-11 14:23:13","reply_to":null,"is_system":false,"for_user":null,"description2":"","remind_user_id":1004,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}},"can_delete":false,"title":"\u66f9\u6c38\u751f\u7ed9\u4f60\u7684\u7559\u8a00"},{"id":170367,"object_id":3338,"object_type":"10","parent":null,"description":"\u54c8\u54c8\u559c\u6b22\u559c\u5267","created_by":1000,"created_at":"2025-07-10 16:32:53","reply_to":null,"is_system":false,"for_user":1004,"description2":"","remind_user_id":1004,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}},"can_delete":false,"title":"\u66f9\u6c38\u751f\u7ed9\u4f60\u7684\u7559\u8a00"},{"id":170172,"object_id":8264,"object_type":"18","parent":null,"description":"\u54af\u54af\u54af\u54af\u54af","created_by":1000,"created_at":"2025-07-01 18:24:49","reply_to":null,"is_system":false,"for_user":null,"description2":"","remind_user_id":1004,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}},"can_delete":false,"title":"\u66f9\u6c38\u751f\u7ed9\u4f60\u7684\u7559\u8a00"},{"id":170171,"object_id":8264,"object_type":"18","parent":null,"description":"\u90bb\u5c45","created_by":1000,"created_at":"2025-07-01 18:24:34","reply_to":null,"is_system":false,"for_user":null,"description2":"","remind_user_id":1004,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}},"can_delete":false,"title":"\u66f9\u6c38\u751f\u7ed9\u4f60\u7684\u7559\u8a00"},{"id":170170,"object_id":8264,"object_type":"18","parent":null,"description":"\u63a5\u5230\u7535\u8bdd","created_by":1000,"created_at":"2025-07-01 18:24:03","reply_to":null,"is_system":false,"for_user":null,"description2":"","remind_user_id":1004,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}},"can_delete":false,"title":"\u66f9\u6c38\u751f\u7ed9\u4f60\u7684\u7559\u8a00"},{"id":170169,"object_id":8264,"object_type":"18","parent":null,"description":"\u4f60\u5403\u4f60\u5403","created_by":1000,"created_at":"2025-07-01 18:18:26","reply_to":null,"is_system":false,"for_user":null,"description2":"","remind_user_id":1004,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}},"can_delete":false,"title":"\u66f9\u6c38\u751f\u7ed9\u4f60\u7684\u7559\u8a00"},{"id":170168,"object_id":8264,"object_type":"18","parent":null,"description":"vvv","created_by":1000,"created_at":"2025-07-01 18:18:06","reply_to":null,"is_system":false,"for_user":null,"description2":"","remind_user_id":1004,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}},"can_delete":false,"title":"\u66f9\u6c38\u751f\u7ed9\u4f60\u7684\u7559\u8a00"},{"id":170167,"object_id":8264,"object_type":"18","parent":null,"description":"hxhcb","created_by":1000,"created_at":"2025-07-01 18:18:00","reply_to":null,"is_system":false,"for_user":null,"description2":"","remind_user_id":1004,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}},"can_delete":false,"title":"\u66f9\u6c38\u751f\u7ed9\u4f60\u7684\u7559\u8a00"},{"id":170159,"object_id":3805,"object_type":"1","parent":{"id":170122,"parent":null,"created_by":1000,"reply_to":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f"}},"description":"\u7ed9","created_by":1000,"created_at":"2025-06-28 17:50:58","reply_to":null,"is_system":false,"for_user":null,"description2":"","remind_user_id":1004,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}},"can_delete":false,"title":"\u66f9\u6c38\u751f\u56de\u590d\u4e86\u66f9\u6c38\u751f"},{"id":170158,"object_id":3805,"object_type":"1","parent":null,"description":"\u4f60\u6df1\u601d\u719f\u8651","created_by":1000,"created_at":"2025-06-28 17:50:34","reply_to":null,"is_system":false,"for_user":1004,"description2":"","remind_user_id":1004,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}},"can_delete":false,"title":"\u66f9\u6c38\u751f\u7ed9\u4f60\u7684\u7559\u8a00"},{"id":170122,"object_id":3805,"object_type":"1","parent":null,"description":"\u4e0d\u5bf9\u52b2","created_by":1000,"created_at":"2025-06-21 21:27:46","reply_to":null,"is_system":false,"for_user":1004,"description2":"","remind_user_id":1004,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}},"can_delete":false,"title":"\u66f9\u6c38\u751f\u7ed9\u4f60\u7684\u7559\u8a00"},{"id":170089,"object_id":215,"object_type":"38","parent":null,"description":"\u597d","created_by":1000,"created_at":"2025-06-10 14:07:40","reply_to":null,"is_system":false,"for_user":null,"description2":"","remind_user_id":1004,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}},"can_delete":false,"title":"\u66f9\u6c38\u751f\u7ed9\u4f60\u7684\u7559\u8a00"},{"id":170011,"object_id":215,"object_type":"38","parent":null,"description":"<mention data-id=\"1000\">@\u66f9\u6c38\u751f<\/mention>\u200b\u79bb\u5f00\u5bb6","created_by":1004,"created_at":"2025-05-15 11:58:25","reply_to":null,"is_system":false,"for_user":null,"description2":"","remind_user_id":null,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"can_delete":true,"title":"\u4f60\u7684\u7559\u8a00"},{"id":170010,"object_id":1660,"object_type":"37","parent":null,"description":"<mention data-id=\"1000\">@\u66f9\u6c38\u751f<\/mention>\u200b\u8303\u5fb7\u8428","created_by":1004,"created_at":"2025-05-15 11:57:46","reply_to":null,"is_system":false,"for_user":null,"description2":"","remind_user_id":null,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"can_delete":true,"title":"\u4f60\u7684\u7559\u8a00"},{"id":170009,"object_id":7358,"object_type":"20","parent":null,"description":"<mention data-id=\"1000\">@\u66f9\u6c38\u751f<\/mention>\u200b\u8303\u5fb7\u8428","created_by":1004,"created_at":"2025-05-15 11:57:17","reply_to":null,"is_system":false,"for_user":null,"description2":"","remind_user_id":null,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"can_delete":true,"title":"\u4f60\u7684\u7559\u8a00"},{"id":170008,"object_id":697,"object_type":"11","parent":null,"description":"<mention data-id=\"1000\">@\u66f9\u6c38\u751f<\/mention>\u597d\u597d\u200b","created_by":1004,"created_at":"2025-05-15 11:56:42","reply_to":null,"is_system":false,"for_user":null,"description2":"","remind_user_id":null,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"can_delete":true,"title":"\u4f60\u7684\u7559\u8a00"},{"id":170007,"object_id":3821,"object_type":"13","parent":null,"description":"<mention data-id=\"1000\">@\u66f9\u6c38\u751f<\/mention>\u200b\u8303\u5fb7\u8428\u8303\u5fb7\u8428","created_by":1004,"created_at":"2025-05-15 11:54:47","reply_to":null,"is_system":false,"for_user":null,"description2":"","remind_user_id":null,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"can_delete":true,"title":"\u4f60\u7684\u7559\u8a00"},{"id":170006,"object_id":685,"object_type":"12","parent":null,"description":"<mention data-id=\"1000\">@\u66f9\u6c38\u751f<\/mention>\u200b\u975e\u5b98\u65b9\u7684","created_by":1004,"created_at":"2025-05-15 11:54:30","reply_to":null,"is_system":false,"for_user":null,"description2":"","remind_user_id":null,"is_read":true,"replyTo":null,"attachmentRelationships":[],"forUser":null,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"can_delete":true,"title":"\u4f60\u7684\u7559\u8a00"}],"pagenation":{"totalcount":4199,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-13 17:36:14') RETURNING "id"

[+] Explain