ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a31458c8e911: POST https://beta.jinchangxiao.com/v2/comment/list at 2026-06-16 08:46:04 pm by 117.133.84.85

Performance Profiling

Total processing time: 221 ms; Peak memory: 2.348 MB. Show Profiling Timeline

总计17条数据
TimeDurationCategoryInfo
  
20:46:04.73154.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_comments" WHERE "parent" IN (5997, 5996, 5995, 5773, 5610, 5547, 5511, 5386, 5303) ORDER BY "created_at"
20:46:04.69436.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_comments" WHERE ("parent" IS NULL) AND ("object_type"='102') AND ("object_id"='59') ORDER BY "created_at" DESC LIMIT 20
20:46:04.66429.6 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_comments" WHERE ("parent" IS NULL) AND ("object_type"='102') AND ("object_id"='59') ORDER BY "created_at" DESC) "c"
20:46:04.63726.6 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_unread_comments" SET "is_read"=TRUE WHERE ("object_type"='102') AND ("object_id"='59') AND ("remind_user_id"=1000)
20:46:04.59125.5 msyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_comments" WHERE object_type = '102' AND object_id = '59'
20:46:04.61719.8 msyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_unread_comments" WHERE object_type = '102' AND object_id = '59' AND remind_user_id = 1000
20:46:04.7924.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=310) AND ("object_id" IN (5997, 5996, 5995, 5773, 5610, 5547, 5511, 5386, 5303))
20:46:04.7873.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=310) AND ("object_id" IN (5551, 5553, 5554, 5558, 5612, 5718, 5719))
20:46:04.8002.3 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 2, 1159, 'v2/comment/list', '{"access_token":"R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC","device_type":"2","object_id":"59","object_type":"102","page":"1","posttime":"1781613952","token":"753380b237986a59313040d9024cce43","version_code":"1159"}', '{"code":200,"data":{"list":[{"id":5997,"object_id":59,"object_type":"102","parent":null,"description":"\u9879\u76ee\u5df2\u5b8c\u6210","created_by":5063,"created_at":"2018-11-15 15:29:49","reply_to":null,"is_system":false,"for_user":null,"description2":null,"comments":[],"attachmentRelationships":[],"createdBy":{"id":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","userMetas":[{"user_id":5063,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/ff7e564f-1cd9-37f4-bde5-8b15b18d36da.jpeg"}]},"can_delete":false},{"id":5996,"object_id":59,"object_type":"102","parent":null,"description":"\u6ca1\u6709\u5de5\u7a0b\u5e08\u6709\u65f6\u95f4\u53c2\u52a0\u672c\u6b21\u57f9\u8bad\u3002","created_by":5063,"created_at":"2018-11-15 15:29:40","reply_to":null,"is_system":false,"for_user":null,"description2":null,"comments":[],"attachmentRelationships":[],"createdBy":{"id":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","userMetas":[{"user_id":5063,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/ff7e564f-1cd9-37f4-bde5-8b15b18d36da.jpeg"}]},"can_delete":false},{"id":5995,"object_id":59,"object_type":"102","parent":null,"description":"\u8fd9\u4e2a\u9879\u76ee\u4e5f\u7ed3\u675f\u4e86\uff0c\u5173\u4e86\u5427","created_by":1006,"created_at":"2018-11-15 15:27:59","reply_to":null,"is_system":false,"for_user":null,"description2":null,"comments":[],"attachmentRelationships":[],"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","userMetas":[{"user_id":1006,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"}]},"can_delete":false},{"id":5773,"object_id":59,"object_type":"102","parent":null,"description":"\u4e0b\u5468\u5b89\u6392\uff1a1.\u6570\u636e\u5e93\u5ba1\u8ba1\u6388\u6743\uff1b2.\u5821\u5792\u673a\u8c03\u8bd5\uff08\u7ec6\u8282\uff09\uff1b3.\u8bbe\u5907\u4f7f\u7528\u57f9\u8bad\uff0c\u5e94\u6025\u5904\u7406\u9884\u6848\u3002\u5382\u5546\u4e3b\u5bfc","created_by":5063,"created_at":"2018-11-09 11:32:56","reply_to":null,"is_system":false,"for_user":null,"description2":null,"comments":[],"attachmentRelationships":[],"createdBy":{"id":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","userMetas":[{"user_id":5063,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/ff7e564f-1cd9-37f4-bde5-8b15b18d36da.jpeg"}]},"can_delete":false},{"id":5610,"object_id":59,"object_type":"102","parent":null,"description":"\u5df2\u7ea6\u597d\uff0c\u4eca\u5929\u4e0b\u5348\u5382\u5546\u7684\u4eba\u53bb\u5c71\u4e1c\u4e0a\u67b6\uff0c\u660e\u5929\u90e8\u7f72\u548c\u57f9\u8bad","created_by":5063,"created_at":"2018-11-06 09:16:47","reply_to":null,"is_system":false,"for_user":null,"description2":null,"comments":[{"id":5612,"object_id":59,"object_type":"102","parent":5610,"description":"\u597d\u7684\uff0c\u8f9b\u82e6","created_by":1011,"created_at":"2018-11-06 09:17:48","reply_to":null,"is_system":false,"for_user":null,"description2":null,"replyTo":null,"attachmentRelationships":[],"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","userMetas":[{"user_id":1011,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}]}},{"id":5718,"object_id":59,"object_type":"102","parent":5610,"description":"\u8fd9\u4e2a\u7ed3\u675f\u4e86\u5417\uff1f","created_by":1011,"created_at":"2018-11-08 15:22:14","reply_to":null,"is_system":false,"for_user":null,"description2":null,"replyTo":null,"attachmentRelationships":[],"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","userMetas":[{"user_id":1011,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}]}},{"id":5719,"object_id":59,"object_type":"102","parent":5610,"description":"\u8fd8\u6709\u57f9\u8bad\u6ca1\u505a\uff0c\u4e0b\u5468\u505a\u57f9\u8bad","created_by":5063,"created_at":"2018-11-08 15:23:25","reply_to":1011,"is_system":false,"for_user":null,"description2":null,"replyTo":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"},"attachmentRelationships":[],"createdBy":{"id":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","userMetas":[{"user_id":5063,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/ff7e564f-1cd9-37f4-bde5-8b15b18d36da.jpeg"}]}}],"attachmentRelationships":[],"createdBy":{"id":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","userMetas":[{"user_id":5063,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/ff7e564f-1cd9-37f4-bde5-8b15b18d36da.jpeg"}]},"can_delete":false},{"id":5547,"object_id":59,"object_type":"102","parent":null,"description":"\u539f\u5382\u5b9e\u65bd\uff0c\u539f\u5382\u8054\u7cfb\uff0c\u8d44\u6599\u4ea4\u4ed8\u7ed9\u6211\u4eec\uff0c\u552e\u540e\u5ba2\u6237\u5148\u8054\u7cfb\u6211\u4eec\uff0c\u7531\u6211\u4eec\u8054\u7cfb\u5382\u5546","created_by":5063,"created_at":"2018-11-05 09:56:51","reply_to":null,"is_system":false,"for_user":null,"description2":null,"comments":[{"id":5551,"object_id":59,"object_type":"102","parent":5547,"description":"\u4ec0\u4e48\u65f6\u95f4\u5b9e\u65bd\uff1f","created_by":1011,"created_at":"2018-11-05 10:43:40","reply_to":null,"is_system":false,"for_user":null,"description2":null,"replyTo":null,"attachmentRelationships":[],"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","userMetas":[{"user_id":1011,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}]}},{"id":5553,"object_id":59,"object_type":"102","parent":5547,"description":"\u5382\u5546\u81ea\u5df1\u8054\u7cfb\uff0c\u53bb\u65f6\u53cd\u9988\u6211\u3002","created_by":5063,"created_at":"2018-11-05 10:44:25","reply_to":1011,"is_system":false,"for_user":null,"description2":null,"replyTo":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"},"attachmentRelationships":[],"createdBy":{"id":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","userMetas":[{"user_id":5063,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/ff7e564f-1cd9-37f4-bde5-8b15b18d36da.jpeg"}]}},{"id":5554,"object_id":59,"object_type":"102","parent":5547,"description":"\u6ee1\u8db3\u5ba2\u6237\u671f\u671b\u7684\u5b9e\u65bd\u65f6\u95f4\u5417\uff1f","created_by":1011,"created_at":"2018-11-05 10:45:11","reply_to":5063,"is_system":false,"for_user":null,"description2":null,"replyTo":{"id":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F"},"attachmentRelationships":[],"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","userMetas":[{"user_id":1011,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}]}},{"id":5558,"object_id":59,"object_type":"102","parent":5547,"description":"\u6ee1\u8db3","created_by":5063,"created_at":"2018-11-05 11:02:03","reply_to":1011,"is_system":false,"for_user":null,"description2":null,"replyTo":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"},"attachmentRelationships":[],"createdBy":{"id":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","userMetas":[{"user_id":5063,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/ff7e564f-1cd9-37f4-bde5-8b15b18d36da.jpeg"}]}}],"attachmentRelationships":[],"createdBy":{"id":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","userMetas":[{"user_id":5063,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/ff7e564f-1cd9-37f4-bde5-8b15b18d36da.jpeg"}]},"can_delete":false},{"id":5511,"object_id":59,"object_type":"102","parent":null,"description":"\u9f50\u6cbb\u5821\u5792\u673a\u539f\u5382\u5b9e\u65bd\u5de5\u7a0b\u5e08-\u5f20\u5efa\u9e4f\uff1a15201303209","created_by":5063,"created_at":"2018-11-02 14:56:40","reply_to":null,"is_system":false,"for_user":null,"description2":null,"comments":[],"attachmentRelationships":[],"createdBy":{"id":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","userMetas":[{"user_id":5063,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/ff7e564f-1cd9-37f4-bde5-8b15b18d36da.jpeg"}]},"can_delete":false},{"id":5386,"object_id":59,"object_type":"102","parent":null,"description":"\u8bbe\u5907\u672a\u5230\u8d27\uff0c\u9884\u8ba1\u6700\u5feb11\u670810\u53f7\u5de6\u53f3\u5b8c\u6210\u5b9e\u65bd\uff0c\u9879\u76ee\u5ef6\u671f\uff0c\u4fdd\u6301\u4e0e\u5ba2\u6237\u6c9f\u901a\uff0c\u5382\u5546\u5de5\u7a0b\u5e08\u5b9e\u65bd\uff0c\u5b9e\u65bd\u4eba\u5458\u6682\u672a\u5bf9\u63a5\u3002\u9700\u8981\u5ba2\u6237\u51c6\u5907\u5821\u5792\u673a\u7684IP\u5730\u5740\u3001\u4ee5\u53ca\u9700\u8981\u5821\u5792\u673a\u7ba1\u7406\u7684\u8bbe\u5907\u6e05\u5355\uff1a\u5305\u62ecIP\u5730\u5740\u3001\u7528\u6237\u540d\u3001\u5bc6\u7801\uff0c\u5ba2\u6237\u5df2\u5907\u597d\u3002","created_by":5063,"created_at":"2018-10-31 14:01:43","reply_to":null,"is_system":false,"for_user":null,"description2":null,"comments":[],"attachmentRelationships":[],"createdBy":{"id":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","userMetas":[{"user_id":5063,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/ff7e564f-1cd9-37f4-bde5-8b15b18d36da.jpeg"}]},"can_delete":false},{"id":5303,"object_id":59,"object_type":"102","parent":null,"description":"\u9879\u76ee\u53d8\u66f4\uff1a\u539f\u7531\u5f90\u7855\u8d1f\u8d23\u9879\u76ee\u6267\u884c\u60c5\u51b5\u5bf9\u63a5\u53ca\u6280\u672f\u5b66\u4e60\uff0c\u73b0\u7531\u674e\u73ca\u73ca\u5bf9\u63a5\u3002","created_by":5063,"created_at":"2018-10-29 17:27:12","reply_to":null,"is_system":false,"for_user":null,"description2":null,"comments":[],"attachmentRelationships":[],"createdBy":{"id":5063,"key":5063,"name":"\u674e\u73ca\u73ca","sex":"F","userMetas":[{"user_id":5063,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/ff7e564f-1cd9-37f4-bde5-8b15b18d36da.jpeg"}]},"can_delete":false}],"unread":0,"count":16,"pagenation":{"totalcount":9,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"117.133.84.85","ua":"jinchangxiao\/2.3.156 (iPhone 12; iOS 26.5; Scale\/3.00)"}', FALSE, '2026-06-16 20:46:04', 214850048) RETURNING "id"
20:46:04.5870.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC'
20:46:04.5900.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
20:46:04.7860.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5063)
20:46:04.7910.4 msyii\db\Command::querySELECT "user_id", "meta_value" AS "avatar" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5063, 1011))
20:46:04.7910.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5063)
20:46:04.7970.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5063, 1006)
20:46:04.5870.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
20:46:04.7970.3 msyii\db\Command::querySELECT "user_id", "meta_value" AS "avatar" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5063, 1006))