6948e396d6e61: POST https://beta.jinchangxiao.com/vue/task/save-edit-group at 2025-12-22 02:22:14 pm by 223.72.15.22
Performance Profiling
Total processing time: 152 ms; Peak memory: 4.282 MB. Show Profiling Timeline
总计62条数据
| Time | Duration | Category | Info |
|---|---|---|---|
| 14:22:14.959 | 28.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=3364) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 14:22:14.909 | 14.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, 'start_at', 214, 102, 1001, 'now()', '["2025-12-15 00:00:00"]', '["2025-12-22 00:00:00"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5f00\u59cb\u65f6\u95f4","d4":["2025-12-22 00:00:00 <b>\u53d8\u4e3a<\/b> 2025-12-15 00:00:00"]}') |
| 14:22:14.938 | 9.7 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_task_group_head_of_relationships" ("task_group_id", "user_id") VALUES (214, 1001), (214, 5250), (214, 5016), (214, 5064), (214, 1000) |
| 14:22:14.899 | 7.7 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3857') |
| 14:22:15.001 | 6.9 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3857) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 14:22:14.988 | 5.3 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (3364, 1001, 'now()', NULL) RETURNING "id" |
| 14:22:14.950 | 5.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3364' |
| 14:22:14.885 | 3.2 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 14:22:14.924 | 3.0 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_task_groups" SET "client_id"=3364, "updated_at"='now()', "start_at"='2025/12/15 00:00', "project_id"=3857 WHERE "id"=214 |
| 14:22:14.882 | 2.9 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 14:22:14.890 | 2.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:22:14.933 | 2.2 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_task_group_user_relationships" ("task_group_id", "user_id") VALUES (214, 1001), (214, 1000), (214, 5250), (214, 5016), (214, 5064) |
| 14:22:14.957 | 1.7 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=3364 |
| 14:22:14.928 | 1.4 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', 214, 'a:1:{s:8:"start_at";s:19:"2025-12-15 00:00:00";}', '', 1001, '223.72.15.22') |
| 14:22:14.948 | 1.2 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_tasks" SET "status"=2 WHERE ("task_group_id"=214) AND ("status"=0) AND ("head_of" NOT IN ('1001', '1000', '5250', '5016', '5064')) |
| 14:22:14.932 | 1.1 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_task_group_user_relationships" WHERE "task_group_id"=214 |
| 14:22:15.028 | 1.1 ms | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/task/save-edit-group', '{"TaskGroups":{"id":"214","client_id":"3364","project_id":"3857","client_name":"\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","title":"\u6d4b\u8bd5\u7518\u7279\u56fe\u663e\u793a\u95ee\u9898","situation":"\u6d4b\u8bd5","start_at":"2025\/12\/15 00:00","target_completed_at":"2026-01-31 00:00:00","taskGroupUsers":["1001","1000","5250","5016","5064"],"taskGroupHeads":["1001","5250","5016","5064","1000"],"description":"\u6d4b\u8bd5"}}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u9879\u76ee\u5217\u8868\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0,"ip":"223.72.15.22","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:146.0) Gecko\/20100101 Firefox\/146.0"}', FALSE, '2025-12-22 14:22:15') RETURNING "id" |
| 14:22:14.999 | 1.0 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=3857 |
| 14:22:15.011 | 1.0 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 ('INSERT', 'app\models\ObjectChangeLogs', 591658, 'a:13:{s:2:"id";i:591658;s:9:"object_id";s:4:"3857";s:11:"object_type";i:1;s:9:"target_id";i:214;s:18:"target_object_type";i:102;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"[214]";s:9:"new_value";s:5:"[214]";s:11:"description";s:137:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee","d4":["\u6d4b\u8bd5\u7518\u7279\u56fe\u663e\u793a\u95ee\u9898"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '223.72.15.22') |
| 14:22:14.895 | 0.9 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"='214' |
| 14:22:15.026 | 0.9 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_tasks" SET "is_start_out"=FALSE, "start_out_value"=NULL WHERE "id"=1618 |
| 14:22:15.015 | 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\Tasks', 1615, 'a:2:{s:8:"start_at";s:19:"2025-12-22 00:00:00";s:6:"end_at";s:19:"2025-12-27 00:00:00";}', '', 1001, '223.72.15.22') |
| 14:22:15.016 | 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\Tasks', 1616, 'a:2:{s:8:"start_at";s:19:"2025-12-21 00:00:00";s:6:"end_at";s:19:"2025-12-24 00:00:00";}', '', 1001, '223.72.15.22') |
| 14:22:14.898 | 0.8 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3364') |
| 14:22:14.993 | 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 ('INSERT', 'app\models\ClientAmChangeLogs', 187475, 'a:5:{s:2:"id";i:187475;s:9:"client_id";i:3364;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '223.72.15.22') |
| 14:22:15.020 | 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\Tasks', 1617, 'a:2:{s:8:"start_at";s:19:"2025-12-31 00:00:00";s:6:"end_at";s:19:"2026-01-01 00:00:00";}', '', 1001, '223.72.15.22') |
| 14:22:14.996 | 0.8 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 3364, 10, 214, 102, 1001, '[214]', '[214]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee","d4":["\u6d4b\u8bd5\u7518\u7279\u56fe\u663e\u793a\u95ee\u9898"]}') RETURNING "id" |
| 14:22:14.937 | 0.8 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE "task_group_id"=214 |
| 14:22:15.010 | 0.8 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 3857, 1, 214, 102, 1001, '[214]', '[214]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee","d4":["\u6d4b\u8bd5\u7518\u7279\u56fe\u663e\u793a\u95ee\u9898"]}') RETURNING "id" |
| 14:22:15.008 | 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\Projects', 3857, 'a:1:{s:6:"end_at";s:19:"2025-06-17 10:13:55";}', '', 1001, '223.72.15.22') |
| 14:22:15.018 | 0.8 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_tasks" SET "is_start_out"=FALSE, "start_out_value"=NULL WHERE "id"=1616 |
| 14:22:14.931 | 0.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1000, 5250, 5016, 5064) |
| 14:22:15.023 | 0.7 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_tasks" SET "end_out_value"=663, "start_out_value"=384 WHERE "id"=1619 |
| 14:22:14.994 | 0.7 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\Clients', 3364, 'a:0:{}', '', 1001, '223.72.15.22') |
| 14:22:14.997 | 0.7 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 ('INSERT', 'app\models\ObjectChangeLogs', 591657, 'a:13:{s:2:"id";i:591657;s:9:"object_id";s:4:"3364";s:11:"object_type";i:10;s:9:"target_id";i:214;s:18:"target_object_type";i:102;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"[214]";s:9:"new_value";s:5:"[214]";s:11:"description";s:137:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee","d4":["\u6d4b\u8bd5\u7518\u7279\u56fe\u663e\u793a\u95ee\u9898"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '223.72.15.22') |
| 14:22:15.025 | 0.7 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\Tasks', 1618, 'a:2:{s:8:"start_at";s:19:"2025-12-20 00:00:00";s:6:"end_at";s:19:"2025-12-28 00:00:00";}', '', 1001, '223.72.15.22') |
| 14:22:15.012 | 0.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE (parent_id is null) AND ("task_group_id"=214) |
| 14:22:15.024 | 0.7 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_tasks" SET "progress"=40 WHERE "id"=1618 |
| 14:22:15.023 | 0.7 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\Tasks', 1619, 'a:2:{s:8:"start_at";s:19:"2024-12-01 00:00:00";s:6:"end_at";s:19:"2027-10-22 00:00:00";}', '', 1001, '223.72.15.22') |
| 14:22:15.021 | 0.7 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\Tasks', 1617, 'a:2:{s:8:"start_at";s:19:"2025-12-31 00:00:00";s:6:"end_at";s:19:"2026-01-01 00:00:00";}', '', 1001, '223.72.15.22') |
| 14:22:15.013 | 0.7 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\Tasks', 1615, 'a:2:{s:8:"start_at";s:19:"2025-12-22 00:00:00";s:6:"end_at";s:19:"2025-12-27 00:00:00";}', '', 1001, '223.72.15.22') |
| 14:22:15.018 | 0.7 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\Tasks', 1616, 'a:4:{s:8:"start_at";s:19:"2025-12-21 00:00:00";s:6:"end_at";s:19:"2025-12-24 00:00:00";s:12:"is_start_out";b:1;s:15:"start_out_value";i:1;}', '', 1001, '223.72.15.22') |
| 14:22:15.027 | 0.7 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\Tasks', 1618, 'a:3:{s:8:"start_at";s:19:"2025-12-20 00:00:00";s:6:"end_at";s:19:"2025-12-28 00:00:00";s:15:"start_out_value";i:2;}', '', 1001, '223.72.15.22') |
| 14:22:14.936 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5250, 5016, 5064, 1000) |
| 14:22:14.908 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:22:14.930 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_task_group_user_relationships" WHERE "task_group_id"=214 |
| 14:22:14.998 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3857' |
| 14:22:14.896 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE ("user_id"=1001) AND ("task_group_id"=214) |
| 14:22:15.013 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1615 |
| 14:22:15.016 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1616 |
| 14:22:15.009 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:22:14.907 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 14:22:15.022 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1618 |
| 14:22:15.019 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1617 |
| 14:22:15.009 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3364 |
| 14:22:14.995 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:22:14.907 | 0.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 14:22:14.936 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE "task_group_id"=214 |
| 14:22:15.026 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=214 |
| 14:22:15.021 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=214 |
| 14:22:15.014 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=214 |
| 14:22:15.017 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=214 |