Database Queries

总计15条数据
TimeDurationTypeQuery
  
10:10:16.4283.1 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

10:10:16.4330.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

10:10:16.4341.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

10:10:16.43692.7 msSELECTSELECT COUNT(*) FROM "a57be577deb434"."tbl_comments" WHERE object_type = '1' AND object_id = '2761'

10:10:16.53021.5 msSELECTSELECT COUNT(*) FROM "a57be577deb434"."tbl_unread_comments" WHERE object_type = '1' AND object_id = '2761' AND remind_user_id = 1001

10:10:16.55223.2 msUPDATEUPDATE "a57be577deb434"."tbl_unread_comments" SET "is_read"=TRUE WHERE ("object_type"='1') AND ("object_id"='2761') AND ("remind_user_id"=1001)

10:10:16.57528.8 msSELECTSELECT 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.60436.7 msSELECTSELECT * 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.64229.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_comments" WHERE "parent" IN (70090, 61558, 55818, 51764) ORDER BY "created_at"

10:10:16.6712.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=310) AND ("object_id" IN (70090, 61558, 55818, 51764))

10:10:16.6740.4 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1014, 5015, 1004)

10:10:16.6750.5 msSELECTSELECT "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.6781.8 msINSERTINSERT 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.6823.6 msSELECTSELECT * 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.6860.3 msUPDATEUPDATE "global"."tbl_browser_ua_statistics" SET "counter"=11600 WHERE "id"=206