6a27de520d66f: POST https://beta.jinchangxiao.com/v2/task/save-edit-group at 2026-06-09 05:35:14 pm by 125.78.87.174
Performance Profiling
Total processing time: 28 ms; Peak memory: 3.643 MB. Show Profiling Timeline
总计35条数据
| Time | Duration | Category | Info |
|---|---|---|---|
| 17:35:14.064 | 1.2 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\TaskGroups', 207, 'a:0:{}', '', 1001, '125.78.87.174') |
| 17:35:14.068 | 1.0 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'taskGroupUsers', 207, 102, 1001, 'now()', '[["\u8463\u8363"]]', '[["\u66f9\u6c38\u751f","\u5218\u4eba\u8bda","\u8463\u8363"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u6210\u5458","d4":["\u66f9\u6c38\u751f;\u5218\u4eba\u8bda;\u8463\u8363; <b>\u53d8\u4e3a<\/b> \u8463\u8363;"]}') |
| 17:35:14.070 | 0.9 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_task_group_user_relationships" ("task_group_id", "user_id") VALUES (207, 5250) |
| 17:35:14.075 | 0.9 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_task_group_head_of_relationships" ("task_group_id", "user_id") VALUES (207, 5250) |
| 17:35:14.080 | 0.9 ms | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 0, 273, 'v2/task/save-edit-group', '{"access_token":"lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC","device_type":"0","TaskGroups":{"project_id":"","description":"","situation":"rrr","taskGroupHeads":["5250"],"taskGroupUsers":["5250"],"id":"207","start_at":"","title":"yyyyyyggg","target_completed_at":""},"version_code":"273","token":"51c468d8f1e9133953ec68e89570c306","posttime":"1780997714"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u9879\u76ee\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"ip":"125.78.87.174","ua":"jinchangxiao\/2.3.173 (XiaomiMi 10; Android 13)"}', FALSE, '2026-06-09 17:35:14', 25478144) RETURNING "id" |
| 17:35:14.062 | 0.8 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_task_groups" SET "target_completed_at"=NULL, "updated_at"='now()', "start_at"=NULL, "project_id"=NULL WHERE "id"=207 |
| 17:35:14.079 | 0.8 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\TaskGroups', 207, 'a:0:{}', '', 1001, '125.78.87.174') |
| 17:35:14.073 | 0.7 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'taskGroupHeads', 207, 102, 1001, 'now()', '[["\u8463\u8363"]]', '[["\u5218\u4eba\u8bda"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee\u7ecf\u7406","d4":["\u5218\u4eba\u8bda; <b>\u53d8\u4e3a<\/b> \u8463\u8363;"]}') |
| 17:35:14.078 | 0.7 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_task_groups" SET "weight"=NULL WHERE "id"=207 |
| 17:35:14.069 | 0.7 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_task_group_user_relationships" WHERE "task_group_id"=207 |
| 17:35:14.074 | 0.6 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE "task_group_id"=207 |
| 17:35:14.056 | 0.6 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC' |
| 17:35:14.076 | 0.4 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_tasks" SET "status"=2 WHERE ("task_group_id"=207) AND ("status"=0) AND ("head_of"<>'5250') |
| 17:35:14.058 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:35:14.076 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE (parent_id is null) AND ("task_group_id"=207) |
| 17:35:14.065 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5250, 1001) |
| 17:35:14.066 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5250' |
| 17:35:14.068 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:35:14.078 | 0.3 ms | yii\db\Command::query | SELECT "status", "progress" FROM "a57be577deb434"."tbl_tasks" WHERE ("task_group_id"=207) AND (parent_id is null) |
| 17:35:14.072 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5250' |
| 17:35:14.077 | 0.3 ms | yii\db\Command::query | SELECT SUM(weight) FROM "a57be577deb434"."tbl_tasks" WHERE ("task_group_id"=207) AND ("status"=1) |
| 17:35:14.067 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:35:14.071 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:35:14.072 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:35:14.061 | 0.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 17:35:14.073 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:35:14.067 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250 |
| 17:35:14.066 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 17:35:14.062 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 17:35:14.060 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE ("user_id"=1001) AND ("task_group_id"=207) |
| 17:35:14.077 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=207 |
| 17:35:14.059 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"='207' |
| 17:35:14.065 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_task_group_user_relationships" WHERE "task_group_id"=207 |
| 17:35:14.056 | 0.2 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 17:35:14.071 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE "task_group_id"=207 |