ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
685b5e49b98de: POST https://beta.jinchangxiao.com/v2/comment/list at 2025-06-25 10:26:17 am by 223.104.41.148

Database Queries

总计16条数据
TimeDurationTypeQuery
  
10:26:17.7642.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L'

[+] Explain
10:26:17.7671.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016

[+] Explain
10:26:17.76917.7 msSELECTSELECT COUNT(*) FROM "a57be577deb434"."tbl_unread_comments" WHERE object_type = '10' AND object_id = '141' AND remind_user_id = 5016

[+] Explain
10:26:17.78714.2 msUPDATEUPDATE "a57be577deb434"."tbl_unread_comments" SET "is_read"=TRUE WHERE ("object_type"='10') AND ("object_id"='141') AND ("remind_user_id"=5016)

[+] Explain
10:26:17.80118.6 msSELECTSELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_comments" WHERE ("parent" IS NULL) AND ("object_type"='10') AND ("object_id"='141') ORDER BY "created_at" DESC) "c"

[+] Explain
10:26:17.82017.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_comments" WHERE ("parent" IS NULL) AND ("object_type"='10') AND ("object_id"='141') ORDER BY "created_at" DESC LIMIT 20

[+] Explain
10:26:17.83816.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_comments" WHERE "parent" IN (169898, 169896, 169895, 135517, 131958, 126452, 32821, 3789, 1471, 893, 727, 499, 414, 341, 256) ORDER BY "created_at"

[+] Explain
10:26:17.8551.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=310) AND ("object_id" IN (169897, 169899))

[+] Explain
10:26:17.8560.4 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=24690

[+] Explain
10:26:17.8570.2 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
10:26:17.8570.3 msSELECTSELECT "user_id", "meta_value" AS "avatar" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)

[+] Explain
10:26:17.8581.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=310) AND ("object_id" IN (169898, 169896, 169895, 135517, 131958, 126452, 32821, 3789, 1471, 893, 727, 499, 414, 341, 256))

[+] Explain
10:26:17.8590.2 msSELECTSELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24688, 24689)

[+] Explain
10:26:17.8600.2 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5209, 1005, 1004)

[+] Explain
10:26:17.8600.2 msSELECTSELECT "user_id", "meta_value" AS "avatar" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1005, 5209, 1004, 1000))

[+] Explain
10:26:17.8631.5 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5016, 2, 1141, 'v2/comment/list', '{"access_token":"J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L","device_type":"2","object_id":"141","object_type":"10","page":"1","posttime":"1750818432","token":"c68fdc722316d99dd6603a3d51860f30","version_code":"1141"}', '{"code":200,"data":{"list":[{"id":169898,"object_id":141,"object_type":"10","parent":null,"description":"bxb<mention data-id=\"1017\">@\u8f66\u660e\u98de <\/mention>","created_by":1000,"created_at":"2025-05-09 11:05:50","reply_to":null,"is_system":false,"for_user":null,"description2":"","comments":[],"attachmentRelationships":[{"id":33045,"object_type":310,"object_id":169898,"attachment_id":24689,"attachment":{"id":24689,"key":24689,"name":"17f0f830-515e-310b-bd31-6694da6991ca","extension":"jpg","path":"\/v2\/attachment\/view\/J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L\/17f0f830-515e-310b-bd31-6694da6991ca\/Screenshot_20250508_100213_com.jinchangxiao.bms.jpg","orig_name":"Screenshot_20250508_100213_com.jinchangxiao.bms.jpg"}}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","userMetas":[{"user_id":1000,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}]},"can_delete":false},{"id":169896,"object_id":141,"object_type":"10","parent":null,"description":"<mention data-id=\"5250\">@\u8463\u8363 <\/mention>kk","created_by":1000,"created_at":"2025-05-09 11:03:28","reply_to":null,"is_system":false,"for_user":null,"description2":"","comments":[],"attachmentRelationships":[{"id":33044,"object_type":310,"object_id":169896,"attachment_id":24688,"attachment":{"id":24688,"key":24688,"name":"063e39bf-d265-39e9-b81a-e3db187e9dad","extension":"jpg","path":"\/v2\/attachment\/view\/J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L\/063e39bf-d265-39e9-b81a-e3db187e9dad\/Screenshot_20250508_100213_com.jinchangxiao.bms.jpg","orig_name":"Screenshot_20250508_100213_com.jinchangxiao.bms.jpg"}}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","userMetas":[{"user_id":1000,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}]},"can_delete":false},{"id":169895,"object_id":141,"object_type":"10","parent":null,"description":"kkk","created_by":1000,"created_at":"2025-05-09 11:02:56","reply_to":null,"is_system":false,"for_user":5300,"description2":"","comments":[],"attachmentRelationships":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","userMetas":[{"user_id":1000,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}]},"can_delete":false},{"id":135517,"object_id":141,"object_type":"10","parent":null,"description":"\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8\u8fd8\u67091\u5929\u903e\u671f\u3002","created_by":null,"created_at":"2024-05-06 17:00:02","reply_to":null,"is_system":true,"for_user":null,"description2":null,"comments":[],"attachmentRelationships":[],"createdBy":{"id":null,"key":null,"name":"\u7cfb\u7edf","sex":"M","userMetas":[{"user_id":null,"avatar":"\/files\/cdn\/a57be577deb434\/2021\/01\/51931101-63c0-36db-8e97-e68282eef06c.png"}]},"can_delete":false},{"id":131958,"object_id":141,"object_type":"10","parent":null,"description":"\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8\u8fd8\u67091\u5929\u903e\u671f\u3002","created_by":null,"created_at":"2024-04-05 13:00:01","reply_to":null,"is_system":true,"for_user":null,"description2":null,"comments":[],"attachmentRelationships":[],"createdBy":{"id":null,"key":null,"name":"\u7cfb\u7edf","sex":"M","userMetas":[{"user_id":null,"avatar":"\/files\/cdn\/a57be577deb434\/2021\/01\/51931101-63c0-36db-8e97-e68282eef06c.png"}]},"can_delete":false},{"id":126452,"object_id":141,"object_type":"10","parent":null,"description":"\u5929\u6d25\u878d\u5b9d\u652f\u4ed8\u7f51\u7edc\u6709\u9650\u516c\u53f8\u8fd8\u67091\u5929\u903e\u671f\u3002","created_by":null,"created_at":"2024-02-28 15:00:02","reply_to":null,"is_system":true,"for_user":null,"description2":null,"comments":[],"attachmentRelationships":[],"createdBy":{"id":null,"key":null,"name":"\u7cfb\u7edf","sex":"M","userMetas":[{"user_id":null,"avatar":"\/files\/cdn\/a57be577deb434\/2021\/01\/51931101-63c0-36db-8e97-e68282eef06c.png"}]},"can_delete":false},{"id":32821,"object_id":141,"object_type":"10","parent":null,"description":"\u4e0d\u9700\u8981","created_by":5209,"created_at":"2020-12-23 15:29:17","reply_to":null,"is_system":false,"for_user":null,"description2":null,"comments":[{"id":169897,"object_id":141,"object_type":"10","parent":32821,"description":"hhcnn","created_by":1000,"created_at":"2025-05-09 11:04:40","reply_to":null,"is_system":false,"for_user":null,"description2":"","replyTo":null,"attachmentRelationships":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","userMetas":[{"user_id":1000,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}]}},{"id":169899,"object_id":141,"object_type":"10","parent":32821,"description":"","created_by":1000,"created_at":"2025-05-09 11:06:03","reply_to":null,"is_system":false,"for_user":null,"description2":"","replyTo":null,"attachmentRelationships":[{"id":33046,"object_type":310,"object_id":169899,"attachment_id":24690,"attachment":{"id":24690,"key":24690,"name":"67c766af-b222-3bf5-95a5-84906ed0eb71","extension":"jpg","path":"\/v2\/attachment\/view\/J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L\/67c766af-b222-3bf5-95a5-84906ed0eb71\/Screenshot_20250508_100213_com.jinchangxiao.bms.jpg","orig_name":"Screenshot_20250508_100213_com.jinchangxiao.bms.jpg"}}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","userMetas":[{"user_id":1000,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}]}}],"attachmentRelationships":[],"createdBy":{"id":5209,"key":5209,"name":"\u5d14\u5efa\u8def","sex":"M","userMetas":[{"user_id":5209,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/6c5d6a16-2d9e-3ca1-99ec-e704387ea298.jpg"}]},"can_delete":false},{"id":3789,"object_id":141,"object_type":"10","parent":null,"description":"\u95ee\u590f\u957f\u9f99\u600e\u4e48\u641e\u5b9a\u5b8b\u5f3a","created_by":1005,"created_at":"2018-08-06 10:16:08","reply_to":null,"is_system":false,"for_user":null,"description2":null,"comments":[],"attachmentRelationships":[],"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","userMetas":[{"user_id":1005,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}]},"can_delete":false},{"id":1471,"object_id":141,"object_type":"10","parent":null,"description":"\u7ed9\u5173\u952e\u4eba\u9001\u793c","created_by":1004,"created_at":"2018-02-05 19:59:31","reply_to":null,"is_system":false,"for_user":null,"description2":null,"comments":[],"attachmentRelationships":[],"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","userMetas":[{"user_id":1004,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}]},"can_delete":false},{"id":893,"object_id":141,"object_type":"10","parent":null,"description":"\u786e\u8ba4\u8ddf\u6211\u4eec\u5408\u4f5c\u7684\u9879\u76ee\u91d1\u989d\u3002","created_by":1004,"created_at":"2018-01-08 17:01:24","reply_to":null,"is_system":false,"for_user":null,"description2":null,"comments":[],"attachmentRelationships":[],"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","userMetas":[{"user_id":1004,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}]},"can_delete":false},{"id":727,"object_id":141,"object_type":"10","parent":null,"description":"\u786e\u5b9a\u6768\u662f\u5185\u7ebf","created_by":1004,"created_at":"2017-12-18 17:53:04","reply_to":null,"is_system":false,"for_user":null,"description2":null,"comments":[],"attachmentRelationships":[],"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","userMetas":[{"user_id":1004,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}]},"can_delete":false},{"id":499,"object_id":141,"object_type":"10","parent":null,"description":"\u660e\u5e74\u7684\u51c6\u786e\u9884\u7b97\uff0c\u8ddf\u590f\u957f\u9f99\u644a\u724c\u3002","created_by":1004,"created_at":"2017-12-11 15:19:20","reply_to":null,"is_system":false,"for_user":null,"description2":null,"comments":[],"attachmentRelationships":[],"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","userMetas":[{"user_id":1004,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}]},"can_delete":false},{"id":414,"object_id":141,"object_type":"10","parent":null,"description":"\u672c\u5468\u7ed9\u5185\u7ebf\u5c0f\u6069\u60e0","created_by":1004,"created_at":"2017-12-04 20:23:16","reply_to":null,"is_system":false,"for_user":null,"description2":null,"comments":[],"attachmentRelationships":[],"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","userMetas":[{"user_id":1004,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}]},"can_delete":false},{"id":341,"object_id":141,"object_type":"10","parent":null,"description":"\u786e\u8ba4\u660e\u5e74it\u9884\u7b97","created_by":1004,"created_at":"2017-11-27 21:44:05","reply_to":null,"is_system":false,"for_user":null,"description2":null,"comments":[],"attachmentRelationships":[],"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","userMetas":[{"user_id":1004,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}]},"can_delete":false},{"id":256,"object_id":141,"object_type":"10","parent":null,"description":"\u4e0b\u5468\u786e\u8ba4\u9700\u6c42\uff01","created_by":1004,"created_at":"2017-10-30 22:01:56","reply_to":null,"is_system":false,"for_user":null,"description2":null,"comments":[],"attachmentRelationships":[],"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","userMetas":[{"user_id":1004,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}]},"can_delete":false}],"unread":0,"pagenation":{"totalcount":15,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-06-25 10:26:17') RETURNING "id"

[+] Explain