Performance Profiling

Total processing time: 932 ms; Peak memory: 2.376 MB. Show Profiling Timeline

总计15条数据

Time	Duration	Category	Info

17:24:44.937	77.3 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_comments" WHERE ("parent" IS NULL) AND ("object_type"='19') AND ("object_id"='35860') ORDER BY "created_at" DESC) "c"
17:24:45.090	72.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_comments" WHERE "parent" IN (153728, 153727) ORDER BY "created_at"
17:24:45.017	68.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_comments" WHERE ("parent" IS NULL) AND ("object_type"='19') AND ("object_id"='35860') ORDER BY "created_at" DESC LIMIT 20
17:24:44.866	67.0 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_unread_comments" SET "is_read"=TRUE WHERE ("object_type"='19') AND ("object_id"='35860') AND ("remind_user_id"=1001)
17:24:44.722	66.1 ms	yii\db\Command::query	SELECT COUNT(*) FROM "a57be577deb434"."tbl_comments" WHERE object_type = '19' AND object_id = '35860'
17:24:44.796	55.8 ms	yii\db\Command::query	SELECT COUNT(*) FROM "a57be577deb434"."tbl_unread_comments" WHERE object_type = '19' AND object_id = '35860' AND remind_user_id = 1001
17:24:45.190	29.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300
17:24:45.169	15.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=310) AND ("object_id" IN (153728, 153727))
17:24:45.248	13.1 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/comment/list', '{"object_type":"19","object_id":"35860","page":"1","web_access_token":"wDahkMIsEuHhAvKCnlYJe0vzWaI3UM9g"}', '{"code":2000,"result":{"list":[{"id":153728,"object_id":35860,"object_type":"19","parent":{},"description":"\u82cf\u6e05\u4e91\u6709\u4e00\u6761\u6316\u6398\u5546\u673a\u7684\u5de5\u4f5c\u65e5\u5fd7\u9700\u8981\u5ba1\u9605","created_by":5300,"created_at":"2024-10-14 21:01:29","reply_to":"","is_system":true,"for_user":"","description2":"\u76ee\u6807\uff1a\u5e2e\u52a9\u5ba2\u6237\u89e3\u51b3\u4e9a\u7ec8\u7aef\u5165\u7f51\u63a7\u5236\uff0c\u4fdd\u969c\u8bbf\u95ee\u5b89\u5168\u548c\u4e1a\u52a1\u7a33\u5b9a\u7684\u95ee\u9898\n\u52a8\u4f5c\uff1a\u817e\u8baf\u4f1a\u8bae\uff0c\u5b89\u6392\u5382\u5546\u6280\u672f\u548c\u5ba2\u6237\u5bf9\u63a5\u9700\u6c42\uff0c\u5e2e\u52a9\u63d0\u4f9b\u89e3\u51b3\u65b9\u6848\n\u7ed3\u679c\uff1a\u8fbe\u5230\u9884\u671f\uff0c\n\u5ba2\u6237\u73b0\u72b6\uff1a\u4f7f\u7528\u601d\u79d1ISE\uff0c\u901a\u8fc7Mac\u5730\u5740\u7ed1\u5b9a\u4e9a\u7ec8\u7aef\uff0c\u8bbe\u7f6evlan\u3002\u73b0\u5728\u7684\u95ee\u9898\uff1a1\u3001ISE\u670d\u52a1\u5668\u4e0d\u591f\uff0c\u5982\u5355\u673a\u6545\u969c\uff0c\u4f1a\u9020\u6210\u4e1a\u52a1\u4e2d\u65ad\u30022\u3001\u73b0\u5728\u5347\u7ea7\u540e\u53d8\u6210\u8ba2\u9605\u5f0f\uff08\u4e4b\u524d\u4e70\u7684\u662f\u5e76\u53d1\uff0c800-1000\u5e76\u53d1\uff09\u3002\u73b0\u5728\u6539\u6210\u8ba2\u9605\u6a21\u5f0f\u540e\uff0c\u6bcf\u5e74\u7684\u6210\u672c\u6bd4\u8f83\u9ad8\u3002\n\u5ba2\u6237\u9700\u6c42\uff1a\n1\u3001\u5458\u5de5\u3001\u4e9a\u7ec8\u7aef\u3001\u8bbf\u5ba2\u5165\u7f51\u8ba4\u8bc1\u3002\uff08\u6df1\u4fe1\u670d\uff1a\u53ea\u505a\u51c6\u5165\u65c1\u6302\u5373\u53ef\uff09\u3002\n1\uff09\u5929\u6d25\u5458\u5de5\uff1a600\u4e2aPC\u6216\u8005\u7b14\u8bb0\u672c\uff0c\u4e9a\u7ec8\u7aef2000-3000\uff0c\u4e9a\u7ec8\u7aef\u7c7b\u578b\uff1a\u65e0\u7ebf\u4fe1\u53f7\u91c7\u96c6\u76d2\u3001\u6761\u7801\u67aa\u7b49\uff0c\u7c7b\u578b\u975e\u5e38\u591a\uff0c\u6682\u65f6\u65e0\u6cd5\u51c6\u786e\u7edf\u8ba1\u3002\n2\uff09\u5e38\u5dde\uff1a3000\u4e2a\u4e9a\u7ec8\u7aef\n2\u3001\u5e0c\u671b\u5c3d\u91cf\u505a\u7eaf\u8f6f\u4ea4\u4ed8\u3002\n3\u3001\u652f\u6301HA\u67b6\u6784\uff0c\u907f\u514d\u7f51\u7edc\u4e2d\u65ad\uff0c\u5f71\u54cd\u4e1a\u52a1\u3002\u6709\u53ef\u80fd\u4e00\u4e2a\u5730\u65b9\u4e70\u4e24\u53f0\uff0c\u6216\u8005\u4e24\u4e2a\u5730\u70b9\u8fdb\u884c\u4e92\u5907\u3002\u770b\u89e3\u51b3\u65b9\u6848\u7684\u6210\u672c\u60c5\u51b5\u3002\uff08\u6df1\u4fe1\u670d\u505a\u5f02\u5730\u4e92\u5907\uff0c\u9700\u8981\u4e24\u8fb9\u7684\u7ec8\u7aef\u6570\u91cf\u76f8\u540c\u6216\u8005\u76f8\u8fd1\u4e14\u7f51\u7edc\u7a33\u5b9a\uff0c\u96be\u5ea6\u6bd4\u8f83\u5927\uff0c\u672c\u5730\u4e92\u5907\u6210\u672c\u9ad8\u4e8e\u601d\u79d1\uff0c\u6b63\u5728\u5546\u8ba8\u7eaf\u8f6f\u4ea4\u4ed8\u7684\u4ef7\u683c\uff09","comments":[],"attachmentRelationships":[],"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","userMetas":[{"user_id":5300,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}]},"can_delete":false},{"id":153727,"object_id":35860,"object_type":"19","parent":{},"description":"\u82cf\u6e05\u4e91\u65b0\u5efa\u4e86\u4e00\u6761\u6316\u6398\u5546\u673a\u7684\u5de5\u4f5c\u65e5\u5fd7","created_by":5300,"created_at":"2024-10-14 21:01:29","reply_to":"","is_system":true,"for_user":"","description2":"\u76ee\u6807\uff1a\u5e2e\u52a9\u5ba2\u6237\u89e3\u51b3\u4e9a\u7ec8\u7aef\u5165\u7f51\u63a7\u5236\uff0c\u4fdd\u969c\u8bbf\u95ee\u5b89\u5168\u548c\u4e1a\u52a1\u7a33\u5b9a\u7684\u95ee\u9898\n\u52a8\u4f5c\uff1a\u817e\u8baf\u4f1a\u8bae\uff0c\u5b89\u6392\u5382\u5546\u6280\u672f\u548c\u5ba2\u6237\u5bf9\u63a5\u9700\u6c42\uff0c\u5e2e\u52a9\u63d0\u4f9b\u89e3\u51b3\u65b9\u6848\n\u7ed3\u679c\uff1a\u8fbe\u5230\u9884\u671f\uff0c\n\u5ba2\u6237\u73b0\u72b6\uff1a\u4f7f\u7528\u601d\u79d1ISE\uff0c\u901a\u8fc7Mac\u5730\u5740\u7ed1\u5b9a\u4e9a\u7ec8\u7aef\uff0c\u8bbe\u7f6evlan\u3002\u73b0\u5728\u7684\u95ee\u9898\uff1a1\u3001ISE\u670d\u52a1\u5668\u4e0d\u591f\uff0c\u5982\u5355\u673a\u6545\u969c\uff0c\u4f1a\u9020\u6210\u4e1a\u52a1\u4e2d\u65ad\u30022\u3001\u73b0\u5728\u5347\u7ea7\u540e\u53d8\u6210\u8ba2\u9605\u5f0f\uff08\u4e4b\u524d\u4e70\u7684\u662f\u5e76\u53d1\uff0c800-1000\u5e76\u53d1\uff09\u3002\u73b0\u5728\u6539\u6210\u8ba2\u9605\u6a21\u5f0f\u540e\uff0c\u6bcf\u5e74\u7684\u6210\u672c\u6bd4\u8f83\u9ad8\u3002\n\u5ba2\u6237\u9700\u6c42\uff1a\n1\u3001\u5458\u5de5\u3001\u4e9a\u7ec8\u7aef\u3001\u8bbf\u5ba2\u5165\u7f51\u8ba4\u8bc1\u3002\uff08\u6df1\u4fe1\u670d\uff1a\u53ea\u505a\u51c6\u5165\u65c1\u6302\u5373\u53ef\uff09\u3002\n1\uff09\u5929\u6d25\u5458\u5de5\uff1a600\u4e2aPC\u6216\u8005\u7b14\u8bb0\u672c\uff0c\u4e9a\u7ec8\u7aef2000-3000\uff0c\u4e9a\u7ec8\u7aef\u7c7b\u578b\uff1a\u65e0\u7ebf\u4fe1\u53f7\u91c7\u96c6\u76d2\u3001\u6761\u7801\u67aa\u7b49\uff0c\u7c7b\u578b\u975e\u5e38\u591a\uff0c\u6682\u65f6\u65e0\u6cd5\u51c6\u786e\u7edf\u8ba1\u3002\n2\uff09\u5e38\u5dde\uff1a3000\u4e2a\u4e9a\u7ec8\u7aef\n2\u3001\u5e0c\u671b\u5c3d\u91cf\u505a\u7eaf\u8f6f\u4ea4\u4ed8\u3002\n3\u3001\u652f\u6301HA\u67b6\u6784\uff0c\u907f\u514d\u7f51\u7edc\u4e2d\u65ad\uff0c\u5f71\u54cd\u4e1a\u52a1\u3002\u6709\u53ef\u80fd\u4e00\u4e2a\u5730\u65b9\u4e70\u4e24\u53f0\uff0c\u6216\u8005\u4e24\u4e2a\u5730\u70b9\u8fdb\u884c\u4e92\u5907\u3002\u770b\u89e3\u51b3\u65b9\u6848\u7684\u6210\u672c\u60c5\u51b5\u3002\uff08\u6df1\u4fe1\u670d\u505a\u5f02\u5730\u4e92\u5907\uff0c\u9700\u8981\u4e24\u8fb9\u7684\u7ec8\u7aef\u6570\u91cf\u76f8\u540c\u6216\u8005\u76f8\u8fd1\u4e14\u7f51\u7edc\u7a33\u5b9a\uff0c\u96be\u5ea6\u6bd4\u8f83\u5927\uff0c\u672c\u5730\u4e92\u5907\u6210\u672c\u9ad8\u4e8e\u601d\u79d1\uff0c\u6b63\u5728\u5546\u8ba8\u7eaf\u8f6f\u4ea4\u4ed8\u7684\u4ef7\u683c\uff09","comments":[],"attachmentRelationships":[],"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","userMetas":[{"user_id":5300,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}]},"can_delete":false}],"unread":1,"count":2,"pagenation":{"totalcount":2,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"114.244.130.61","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-10 17:24:45', 859460096) RETURNING "id"
17:24:45.286	9.2 ms	yii\db\Command::query	SELECT * FROM "global"."tbl_browser_ua_statistics" "b" WHERE "user_agent"='Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko/20100101 Firefox/152.0'
17:24:45.221	7.4 ms	yii\db\Command::query	SELECT "user_id", "meta_value" AS "avatar" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300)
17:24:44.716	1.1 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:24:44.718	0.9 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:24:45.296	0.7 ms	yii\db\Command::execute	UPDATE "global"."tbl_browser_ua_statistics" SET "counter"=11900 WHERE "id"=298
17:24:44.721	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001