6949fa07e3f3d: POST https://beta.jinchangxiao.com/vue/comment/list at 2025-12-23 10:10:15 am by 223.72.15.12
Database Queries
总计15条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 10:10:16.428 | 3.1 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 10:10:16.433 | 0.7 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 10:10:16.434 | 1.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 10:10:16.436 | 92.7 ms | SELECT | SELECT COUNT(*) FROM "a57be577deb434"."tbl_comments" WHERE object_type = '1' AND object_id = '2761' |
| 10:10:16.530 | 21.5 ms | SELECT | SELECT COUNT(*) FROM "a57be577deb434"."tbl_unread_comments" WHERE object_type = '1' AND object_id = '2761' AND remind_user_id = 1001 |
| 10:10:16.552 | 23.2 ms | UPDATE | UPDATE "a57be577deb434"."tbl_unread_comments" SET "is_read"=TRUE WHERE ("object_type"='1') AND ("object_id"='2761') AND ("remind_user_id"=1001) |
| 10:10:16.575 | 28.8 ms | SELECT | SELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_comments" WHERE ("parent" IS NULL) AND ("object_type"='1') AND ("object_id"='2761') ORDER BY "created_at" DESC) "c" |
| 10:10:16.604 | 36.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_comments" WHERE ("parent" IS NULL) AND ("object_type"='1') AND ("object_id"='2761') ORDER BY "created_at" DESC LIMIT 20 |
| 10:10:16.642 | 29.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_comments" WHERE "parent" IN (70090, 61558, 55818, 51764) ORDER BY "created_at" |
| 10:10:16.671 | 2.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=310) AND ("object_id" IN (70090, 61558, 55818, 51764)) |
| 10:10:16.674 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1014, 5015, 1004) |
| 10:10:16.675 | 0.5 ms | SELECT | SELECT "user_id", "meta_value" AS "avatar" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5015, 1014, 1004)) |
| 10:10:16.678 | 1.8 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/comment/list', '{"object_type":"1","object_id":"2761","page":"1","web_access_token":"yb8YvQDqCxvGUQWSJnYL2S9XtkD7pVRr"}', '{"code":2000,"result":{"list":[{"id":70090,"object_id":2761,"object_type":"1","parent":{},"description":"\u6b64\u5546\u673a\u5df2\u6536\u56de\u5168\u90e8\u6b3e\u9879","created_by":1014,"created_at":"2023-01-30 09:52:29","reply_to":"","is_system":true,"for_user":"","description2":"","comments":[],"attachmentRelationships":[],"createdBy":{"id":1014,"key":1014,"name":"\u6731\u65ed\u9896","sex":"F","userMetas":[{"user_id":1014,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/50f5aaf2-ae3d-3803-b5ab-0a2cb40e234a.png"}]},"can_delete":false},{"id":61558,"object_id":2761,"object_type":"1","parent":{},"description":"10\u670817\u65e5\u51fa\u5e934185050\uff0c\u51fa\u5e93\u5b8c\u6bd5","created_by":5015,"created_at":"2022-10-17 14:35:35","reply_to":"","is_system":false,"for_user":1004,"description2":"","comments":[],"attachmentRelationships":[],"createdBy":{"id":5015,"key":5015,"name":"\u5f20\u96ea\u677e","sex":"F","userMetas":[{"user_id":5015,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/7a105eb6-13c4-3990-9428-b163f97fe449.png"}]},"can_delete":false},{"id":55818,"object_id":2761,"object_type":"1","parent":{},"description":"7\u670827\u65e5\u51fa\u5e93netapp\u4ea7\u54c12572760","created_by":5015,"created_at":"2022-08-02 15:52:36","reply_to":"","is_system":false,"for_user":"","description2":"","comments":[],"attachmentRelationships":[],"createdBy":{"id":5015,"key":5015,"name":"\u5f20\u96ea\u677e","sex":"F","userMetas":[{"user_id":5015,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/7a105eb6-13c4-3990-9428-b163f97fe449.png"}]},"can_delete":false},{"id":51764,"object_id":2761,"object_type":"1","parent":{},"description":"\u4f0a\u5cfb\u8fb0\u66f4\u65b0\u4e86\u4e00\u6761\u5546\u673a\u72b6\u6001\u660e\u786e\u9700\u6c42\u53d8\u4e3a\u5546\u673a\u6210\u4ea4","created_by":1004,"created_at":"2022-06-13 16:43:37","reply_to":"","is_system":true,"for_user":"","description2":"\u601d\u79d1B200M5\u670d\u52a1\u5668*13\u53f0\uff0c5108\u7bb1*2\u5957\uff0cA220\u6269\u5c55\u67dc SSD\u6269\u6ee1+8200\u6269\u5c55\u67dc*3\u7b49\uff1b","comments":[],"attachmentRelationships":[],"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","userMetas":[{"user_id":1004,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}]},"can_delete":false}],"unread":0,"count":4,"pagenation":{"totalcount":4,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"223.72.15.12","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:146.0) Gecko\/20100101 Firefox\/146.0"}', FALSE, '2025-12-23 10:10:16') RETURNING "id" |
| 10:10:16.682 | 3.6 ms | SELECT | SELECT * FROM "global"."tbl_browser_ua_statistics" "b" WHERE "user_agent"='Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:146.0) Gecko/20100101 Firefox/146.0' |
| 10:10:16.686 | 0.3 ms | UPDATE | UPDATE "global"."tbl_browser_ua_statistics" SET "counter"=11600 WHERE "id"=206 |