ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6942773a4a693: POST https://beta.jinchangxiao.com/vue/task/save-edit-group at 2025-12-17 05:26:18 pm by 223.72.15.22

Performance Profiling

Total processing time: 984 ms; Peak memory: 6.959 MB. Show Profiling Timeline

总计54条数据
TimeDurationCategoryInfo
  
17:26:18.365884.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=982) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
17:26:19.2638.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=1111) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
17:26:18.3406.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='982'
17:26:19.2504.3 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (982, 1001, 'now()', NULL) RETURNING "id"
17:26:18.3303.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_task_group_user_relationships" ("task_group_id", "user_id") VALUES (204, 5064)
17:26:18.3353.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_task_group_head_of_relationships" ("task_group_id", "user_id") VALUES (204, 5064)
17:26:18.3082.2 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:26:18.3061.8 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:26:18.3191.8 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='982')
17:26:19.2591.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='1111'
17:26:19.2741.6 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 590762, 'a:13:{s:2:"id";i:590762;s:9:"object_id";s:4:"1111";s:11:"object_type";i:1;s:9:"target_id";i:204;s:18:"target_object_type";i:102;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"[204]";s:9:"new_value";s:5:"[204]";s:11:"description";s:95:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee","d4":["\u6d4b\u8bd5"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '223.72.15.22')
17:26:18.3121.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:26:19.2851.3 msyii\db\Command::queryINSERT 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":"204","client_id":"982","project_id":"1111","client_name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","title":"\u6d4b\u8bd5","situation":"\u6d4b\u8bd5","start_at":"2025-12-17 00:00:00","target_completed_at":"2026\/12\/31 00:00","taskGroupUsers":["5064"],"taskGroupHeads":["5064"],"description":""},"web_access_token":"AB5Bz4SIDiJAh3txwTX2DWB4Z_eGe1__"}', '{"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-17 17:26:19') RETURNING "id"
17:26:18.3231.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'target_completed_at', 204, 102, 1001, 'now()', '["2026-12-31 00:00:00"]', '["2025-12-18 00:00:00"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u622a\u6b62\u65e5\u671f","d4":["2025-12-18 00:00:00 <b>\u53d8\u4e3a<\/b> 2026-12-31 00:00:00"]}')
17:26:18.3631.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=982
17:26:18.3211.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='1111')
17:26:18.3271.1 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\TaskGroups', 204, 'a:1:{s:19:"target_completed_at";s:19:"2026-12-31 00:00:00";}', '', 1001, '223.72.15.22')
17:26:19.2621.0 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=1111
17:26:19.2810.9 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1605, 'a:0:{}', '', 1001, '223.72.15.22')
17:26:19.2710.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 1111, 'a:1:{s:6:"end_at";s:19:"2024-09-02 10:10:17";}', '', 1001, '223.72.15.22')
17:26:19.2830.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1606, 'a:3:{s:19:"target_completed_at";s:19:"2025-02-17 00:00:00";s:8:"start_at";s:19:"2025-12-17 00:00:00";s:6:"end_at";s:19:"2025-02-17 00:00:00";}', '', 1001, '223.72.15.22')
17:26:19.2570.8 msyii\db\Command::queryINSERT 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', 982, 10, 204, 102, 1001, '[204]', '[204]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee","d4":["\u6d4b\u8bd5"]}') RETURNING "id"
17:26:19.2550.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 982, 'a:0:{}', '', 1001, '223.72.15.22')
17:26:18.3250.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_task_groups" SET "client_id"=982, "target_completed_at"='2026/12/31 00:00', "updated_at"='now()', "project_id"=1111 WHERE "id"=204
17:26:18.3390.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_tasks" SET "status"=2 WHERE ("task_group_id"=204) AND ("status"=0) AND ("head_of"<>'5064')
17:26:19.2580.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 590761, 'a:13:{s:2:"id";i:590761;s:9:"object_id";s:3:"982";s:11:"object_type";i:10;s:9:"target_id";i:204;s:18:"target_object_type";i:102;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"[204]";s:9:"new_value";s:5:"[204]";s:11:"description";s:95:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee","d4":["\u6d4b\u8bd5"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '223.72.15.22')
17:26:19.2730.8 msyii\db\Command::queryINSERT 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', 1111, 1, 204, 102, 1001, '[204]', '[204]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee","d4":["\u6d4b\u8bd5"]}') RETURNING "id"
17:26:19.2550.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 187289, 'a:5:{s:2:"id";i:187289;s:9:"client_id";i:982;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '223.72.15.22')
17:26:19.2800.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1605, 'a:0:{}', '', 1001, '223.72.15.22')
17:26:18.3110.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:26:19.2840.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1606, 'a:3:{s:19:"target_completed_at";s:19:"2025-02-17 00:00:00";s:8:"start_at";s:19:"2025-12-17 00:00:00";s:6:"end_at";s:19:"2025-02-17 00:00:00";}', '', 1001, '223.72.15.22')
17:26:19.2760.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tasks" WHERE (parent_id is null) AND ("task_group_id"=204)
17:26:19.2770.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1604, 'a:3:{s:19:"target_completed_at";s:19:"2025-12-17 00:00:00";s:8:"start_at";s:19:"2025-12-17 00:00:00";s:6:"end_at";s:19:"2025-12-17 00:00:00";}', '', 1001, '223.72.15.22')
17:26:19.2790.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1604, 'a:3:{s:19:"target_completed_at";s:19:"2025-12-17 00:00:00";s:8:"start_at";s:19:"2025-12-17 00:00:00";s:6:"end_at";s:19:"2025-12-17 00:00:00";}', '', 1001, '223.72.15.22')
17:26:18.3290.7 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_task_group_user_relationships" WHERE "task_group_id"=204
17:26:18.3350.6 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE "task_group_id"=204
17:26:18.3150.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"='204'
17:26:19.2790.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1605
17:26:18.3160.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE ("user_id"=1001) AND ("task_group_id"=204)
17:26:19.2770.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1604
17:26:19.2820.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1606
17:26:18.3230.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:26:19.2720.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982
17:26:19.2560.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:26:18.3290.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064
17:26:19.2730.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:26:18.3340.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064
17:26:18.3280.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_task_group_user_relationships" WHERE "task_group_id"=204
17:26:18.3220.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064)
17:26:18.3220.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064)
17:26:19.2780.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=204
17:26:19.2840.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=204
17:26:19.2810.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=204
17:26:18.3340.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE "task_group_id"=204