Total processing time: 56 ms; Peak memory: 5.591 MB. Show Profiling Timeline
| Time | Duration | Category | Info |
|---|---|---|---|
| 20:05:28.842 | 16.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=3082) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 20:05:28.859 | 0.9 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (3082, 1013, 'now()', NULL) RETURNING "id" |
| 20:05:28.833 | 0.9 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_task_group_user_relationships" ("task_group_id", "user_id") VALUES (205, 5085), (205, 5250), (205, 5332), (205, 5016) |
| 20:05:28.825 | 0.9 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_task_groups" SET "client_id"=3082, "updated_at"='now()', "situation"='www' WHERE "id"=205 |
| 20:05:28.824 | 0.8 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, 'situation', 205, 102, 1001, 'now()', '["www"]', '["\u545c\u545c\u545c\u545c"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u60c5\u51b5\u8bf4\u660e","d4":["\u545c\u545c\u545c\u545c <b>\u53d8\u4e3a<\/b> www"]}') |
| 20:05:28.841 | 0.8 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=3082 |
| 20:05:28.826 | 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', 205, 'a:1:{s:9:"situation";s:3:"www";}', '', 1001, '125.78.86.146') |
| 20:05:28.867 | 0.8 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, 7, 176, 'v2/task/save-edit-group', '{"TaskGroups":{"id":"205","client_id":"3082","title":"\u5443\u5443\u5443\u5443\u5443","situation":"www","description":"","taskGroupUsers":["5085","5250","5332","5016"],"taskGroupHeads":["5016"]},"posttime":"1780920328","access_token":"lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC","device_type":"7","version_code":"176","token":"ab0aef88df089366f27e9786c80715bd"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u9879\u76ee\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"ip":"125.78.86.146","ua":"jinchangxiao\/1.0.40 (emulator emulator; HarmonyOS 6.1.0)"}', FALSE, '2026-06-08 20:05:28', 52805120) RETURNING "id" |
| 20:05:28.862 | 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', 3082, 10, 205, 102, 1001, '[205]', '[205]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee","d4":["\u5443\u5443\u5443\u5443\u5443"]}') RETURNING "id" |
| 20:05:28.831 | 0.8 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', 205, 102, 1001, 'now()', '[["\u970d\u4e1c\u9633","\u8463\u8363","\u970d\u536b\u8d85","\u9ad8\u90e1\u9633"]]', '[["\u66f9\u6c38\u751f","\u970d\u4e1c\u9633","\u8463\u8363","\u970d\u536b\u8d85"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u6210\u5458","d4":["\u66f9\u6c38\u751f;\u970d\u4e1c\u9633;\u8463\u8363;\u970d\u536b\u8d85; <b>\u53d8\u4e3a<\/b> \u970d\u4e1c\u9633;\u8463\u8363;\u970d\u536b\u8d85;\u9ad8\u90e1\u9633;"]}') |
| 20:05:28.837 | 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', 205, 102, 1001, 'now()', '[["\u9ad8\u90e1\u9633"]]', '[["\u66f9\u6c38\u751f","\u8463\u8363"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee\u7ecf\u7406","d4":["\u66f9\u6c38\u751f;\u8463\u8363; <b>\u53d8\u4e3a<\/b> \u9ad8\u90e1\u9633;"]}') |
| 20:05:28.838 | 0.7 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_task_group_head_of_relationships" ("task_group_id", "user_id") VALUES (205, 5016) |
| 20:05:28.860 | 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\ClientAmChangeLogs', 199949, 'a:5:{s:2:"id";i:199949;s:9:"client_id";i:3082;s:9:"sales_rep";i:1013;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '125.78.86.146') |
| 20:05:28.863 | 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', 641544, 'a:13:{s:2:"id";i:641544;s:9:"object_id";s:4:"3082";s:11:"object_type";i:10;s:9:"target_id";i:205;s:18:"target_object_type";i:102;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"[205]";s:9:"new_value";s:5:"[205]";s:11:"description";s:113:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee","d4":["\u5443\u5443\u5443\u5443\u5443"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '125.78.86.146') |
| 20:05:28.861 | 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', 3082, 'a:0:{}', '', 1001, '125.78.86.146') |
| 20:05:28.865 | 0.7 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_task_groups" SET "weight"=NULL WHERE "id"=205 |
| 20:05:28.866 | 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\TaskGroups', 205, 'a:0:{}', '', 1001, '125.78.86.146') |
| 20:05:28.832 | 0.7 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_task_group_user_relationships" WHERE "task_group_id"=205 |
| 20:05:28.837 | 0.6 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE "task_group_id"=205 |
| 20:05:28.816 | 0.6 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC' |
| 20:05:28.864 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE (parent_id is null) AND ("task_group_id"=205) |
| 20:05:28.839 | 0.4 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_tasks" SET "status"=2 WHERE ("task_group_id"=205) AND ("status"=0) AND ("head_of" NOT IN ('5085', '5250', '5332', '5016')) |
| 20:05:28.817 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 20:05:28.827 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5085, 5332, 1000, 5250) |
| 20:05:28.840 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3082' |
| 20:05:28.835 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5250) |
| 20:05:28.828 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5085' |
| 20:05:28.823 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 20:05:28.830 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5085 |
| 20:05:28.865 | 0.3 ms | yii\db\Command::query | SELECT "status", "progress" FROM "a57be577deb434"."tbl_tasks" WHERE ("task_group_id"=205) AND (parent_id is null) |
| 20:05:28.822 | 0.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3082') |
| 20:05:28.836 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250 |
| 20:05:28.862 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 20:05:28.835 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5016' |
| 20:05:28.865 | 0.3 ms | yii\db\Command::query | SELECT SUM(weight) FROM "a57be577deb434"."tbl_tasks" WHERE ("task_group_id"=205) AND ("status"=1) |
| 20:05:28.828 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5250' |
| 20:05:28.829 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5332' |
| 20:05:28.830 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250 |
| 20:05:28.829 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5016' |
| 20:05:28.831 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 20:05:28.831 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5332 |
| 20:05:28.836 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 20:05:28.835 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 20:05:28.829 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 20:05:28.818 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"='205' |
| 20:05:28.822 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 20:05:28.820 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE ("user_id"=1001) AND ("task_group_id"=205) |
| 20:05:28.827 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_task_group_user_relationships" WHERE "task_group_id"=205 |
| 20:05:28.823 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 20:05:28.816 | 0.2 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 20:05:28.864 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=205 |
| 20:05:28.834 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE "task_group_id"=205 |