6948e38305836: POST https://beta.jinchangxiao.com/vue/task/save-edit-group at 2025-12-22 02:21:55 pm by 223.72.15.22
Database Queries
总计62条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 14:21:55.026 | 2.2 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 14:21:55.029 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:21:55.032 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"='214' |
| 14:21:55.033 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE ("user_id"=1001) AND ("task_group_id"=214) |
| 14:21:55.034 | 0.6 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3364') |
| 14:21:55.035 | 0.5 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3857') |
| 14:21:55.035 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 14:21:55.036 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 14:21:55.036 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:21:55.037 | 1.3 ms | INSERT | INSERT 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', 214, 102, 1001, 'now()', '["2026-01-31 00:00:00"]', '["2025-12-31 00:00:00"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u622a\u6b62\u65e5\u671f","d4":["2025-12-31 00:00:00 <b>\u53d8\u4e3a<\/b> 2026-01-31 00:00:00"]}') |
| 14:21:55.038 | 0.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_task_groups" SET "client_id"=3364, "target_completed_at"='2026/01/31 00:00', "updated_at"='now()', "project_id"=3857 WHERE "id"=214 |
| 14:21:55.040 | 1.0 ms | INSERT | 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:19:"target_completed_at";s:19:"2026-01-31 00:00:00";}', '', 1001, '223.72.15.22') |
| 14:21:55.041 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_group_user_relationships" WHERE "task_group_id"=214 |
| 14:21:55.041 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1000, 5250, 5016, 5064) |
| 14:21:55.042 | 0.7 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_task_group_user_relationships" WHERE "task_group_id"=214 |
| 14:21:55.043 | 2.0 ms | INSERT | 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:21:55.045 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE "task_group_id"=214 |
| 14:21:55.045 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5250, 5016, 5064, 1001) |
| 14:21:55.046 | 0.7 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE "task_group_id"=214 |
| 14:21:55.047 | 2.6 ms | INSERT | 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:21:55.050 | 0.8 ms | UPDATE | 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:21:55.051 | 0.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3364' |
| 14:21:55.060 | 1.2 ms | UPDATE | UPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=3364 |
| 14:21:55.062 | 19.7 ms | SELECT | 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:21:55.083 | 5.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (3364, 1001, 'now()', NULL) RETURNING "id" |
| 14:21:55.088 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 187474, 'a:5:{s:2:"id";i:187474;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:21:55.089 | 0.7 ms | INSERT | 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:21:55.090 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:21:55.090 | 0.8 ms | INSERT | 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:21:55.091 | 0.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 591654, 'a:13:{s:2:"id";i:591654;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:21:55.092 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3857' |
| 14:21:55.094 | 1.1 ms | UPDATE | UPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=3857 |
| 14:21:55.096 | 7.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3857) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 14:21:55.103 | 0.8 ms | INSERT | 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:21:55.104 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3364 |
| 14:21:55.104 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:21:55.105 | 0.8 ms | INSERT | 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:21:55.106 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 591655, 'a:13:{s:2:"id";i:591655;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:21:55.107 | 0.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE (parent_id is null) AND ("task_group_id"=214) |
| 14:21:55.108 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1615 |
| 14:21:55.108 | 0.7 ms | INSERT | 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:21:55.109 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=214 |
| 14:21:55.110 | 0.7 ms | INSERT | 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:21:55.111 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1616 |
| 14:21:55.111 | 0.7 ms | INSERT | 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:21:55.112 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=214 |
| 14:21:55.112 | 0.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_tasks" SET "start_out_value"=1 WHERE "id"=1616 |
| 14:21:55.113 | 0.7 ms | INSERT | 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:21:55.114 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1617 |
| 14:21:55.115 | 0.7 ms | INSERT | 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:21:55.115 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=214 |
| 14:21:55.116 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_tasks" SET "is_end_out"=FALSE, "end_out_value"=NULL WHERE "id"=1617 |
| 14:21:55.117 | 0.7 ms | INSERT | 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:21:55.117 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1618 |
| 14:21:55.118 | 0.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_tasks" SET "end_out_value"=663, "start_out_value"=384 WHERE "id"=1619 |
| 14:21:55.119 | 0.7 ms | INSERT | 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:21:55.120 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_tasks" SET "progress"=40 WHERE "id"=1618 |
| 14:21:55.121 | 0.7 ms | INSERT | 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:21:55.121 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=214 |
| 14:21:55.122 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_tasks" SET "start_out_value"=2 WHERE "id"=1618 |
| 14:21:55.123 | 0.7 ms | INSERT | 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:21:55.124 | 1.1 ms | INSERT | 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-22 00:00:00","target_completed_at":"2026\/01\/31 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:21:55') RETURNING "id" |