69427d02e325e: POST https://beta.jinchangxiao.com/v2/task/save-new-group at 2025-12-17 05:50:58 pm by 221.216.117.150
Database Queries
总计34条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 17:50:58.934 | 2.7 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG' |
| 17:50:58.937 | 1.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064 |
| 17:50:58.940 | 0.6 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='518') |
| 17:50:58.941 | 0.5 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3935') |
| 17:50:58.941 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064) |
| 17:50:58.942 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064) |
| 17:50:58.942 | 4.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_task_groups" ("client_id", "description", "progress", "project_id", "situation", "start_at", "target_completed_at", "title", "created_by", "head_of") VALUES (518, '', 0, 3935, '那你才能吃能行呢', NULL, NULL, '你的斑斑点点吧', 5064, 5064) RETURNING "id" |
| 17:50:58.948 | 8.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\TaskGroups', 205, 'a:17:{s:2:"id";i:205;s:5:"title";s:21:"你的斑斑点点吧";s:11:"description";s:0:"";s:9:"client_id";s:3:"518";s:7:"head_of";i:5064;s:6:"status";N;s:19:"target_completed_at";N;s:12:"completed_at";N;s:10:"created_by";i:5064;s:10:"created_at";N;s:10:"updated_at";N;s:9:"situation";s:24:"那你才能吃能行呢";s:8:"start_at";N;s:10:"project_id";s:4:"3935";s:20:"complete_description";N;s:8:"progress";i:0;s:6:"weight";N;}', '', 5064, '221.216.117.150') |
| 17:50:58.957 | 0.3 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_task_group_user_relationships" WHERE "task_group_id"=205 |
| 17:50:58.957 | 2.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_task_group_user_relationships" ("task_group_id", "user_id") VALUES (205, 5064) |
| 17:50:58.960 | 0.8 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE "task_group_id"=205 |
| 17:50:58.961 | 2.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_task_group_head_of_relationships" ("task_group_id", "user_id") VALUES (205, 5064) |
| 17:50:58.964 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=205 |
| 17:50:58.965 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064 |
| 17:50:58.966 | 9.5 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 (1, 'create', 205, 102, 5064, '2025-12-17 17:50:58', '{"id":205,"title":"\u4f60\u7684\u6591\u6591\u70b9\u70b9\u5427","description":"","client_id":518,"head_of":5064,"status":0,"target_completed_at":null,"completed_at":null,"created_by":5064,"created_at":"2025-12-17 17:50:58","updated_at":"2025-12-17 17:50:58","situation":"\u90a3\u4f60\u624d\u80fd\u5403\u80fd\u884c\u5462","start_at":null,"project_id":3935,"complete_description":null,"progress":0,"weight":0}', '{"id":205,"title":"\u4f60\u7684\u6591\u6591\u70b9\u70b9\u5427","description":"","client_id":518,"head_of":5064,"status":0,"target_completed_at":null,"completed_at":null,"created_by":5064,"created_at":"2025-12-17 17:50:58","updated_at":"2025-12-17 17:50:58","situation":"\u90a3\u4f60\u624d\u80fd\u5403\u80fd\u884c\u5462","start_at":null,"project_id":3935,"complete_description":null,"progress":0,"weight":0}', '{"d1":"\u59da\u96ea\u7eaf","d2":"\u521b\u5efa\u4e86","d3":"\u9879\u76ee","d4":[]}') RETURNING "id" |
| 17:50:58.975 | 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', 590809, 'a:13:{s:2:"id";i:590809;s:9:"object_id";i:205;s:11:"object_type";i:102;s:9:"target_id";N;s:18:"target_object_type";N;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:406:"{"id":205,"title":"\u4f60\u7684\u6591\u6591\u70b9\u70b9\u5427","description":"","client_id":518,"head_of":5064,"status":0,"target_completed_at":null,"completed_at":null,"created_by":5064,"created_at":"2025-12-17 17:50:58","updated_at":"2025-12-17 17:50:58","situation":"\u90a3\u4f60\u624d\u80fd\u5403\u80fd\u884c\u5462","start_at":null,"project_id":3935,"complete_description":null,"progress":0,"weight":0}";s:9:"new_value";s:406:"{"id":205,"title":"\u4f60\u7684\u6591\u6591\u70b9\u70b9\u5427","description":"","client_id":518,"head_of":5064,"status":0,"target_completed_at":null,"completed_at":null,"created_by":5064,"created_at":"2025-12-17 17:50:58","updated_at":"2025-12-17 17:50:58","situation":"\u90a3\u4f60\u624d\u80fd\u5403\u80fd\u884c\u5462","start_at":null,"project_id":3935,"complete_description":null,"progress":0,"weight":0}";s:11:"description";s:81:"{"d1":"\u59da\u96ea\u7eaf","d2":"\u521b\u5efa\u4e86","d3":"\u9879\u76ee","d4":[]}";s:10:"created_by";i:5064;s:10:"created_at";s:19:"2025-12-17 17:50:58";s:9:"is_delete";N;}', '', 5064, '221.216.117.150') |
| 17:50:58.976 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=518 |
| 17:50:59.000 | 2.0 ms | UPDATE | UPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=518 |
| 17:50:59.003 | 866.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=518) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:50:59.870 | 4.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (518, 5295, 'now()', NULL) RETURNING "id" |
| 17:50:59.874 | 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\ClientAmChangeLogs', 187292, 'a:5:{s:2:"id";i:187292;s:9:"client_id";i:518;s:9:"sales_rep";i:5295;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 5064, '221.216.117.150') |
| 17:50:59.875 | 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\Clients', 518, 'a:0:{}', '', 5064, '221.216.117.150') |
| 17:50:59.876 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064 |
| 17:50:59.876 | 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 (1, 'create', 518, 10, 205, 102, 5064, '[205]', '[205]', '{"d1":"\u59da\u96ea\u7eaf","d2":"\u521b\u5efa\u4e86","d3":"\u9879\u76ee","d4":["\u4f60\u7684\u6591\u6591\u70b9\u70b9\u5427"]}') RETURNING "id" |
| 17:50:59.877 | 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', 590810, 'a:13:{s:2:"id";i:590810;s:9:"object_id";i:518;s:11:"object_type";i:10;s:9:"target_id";i:205;s:18:"target_object_type";i:102;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:5:"[205]";s:9:"new_value";s:5:"[205]";s:11:"description";s:125:"{"d1":"\u59da\u96ea\u7eaf","d2":"\u521b\u5efa\u4e86","d3":"\u9879\u76ee","d4":["\u4f60\u7684\u6591\u6591\u70b9\u70b9\u5427"]}";s:10:"created_by";i:5064;s:10:"created_at";N;s:9:"is_delete";N;}', '', 5064, '221.216.117.150') |
| 17:50:59.878 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3935 |
| 17:50:59.880 | 4.1 ms | UPDATE | UPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=3935 |
| 17:50:59.884 | 4.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3935) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 17:50:59.889 | 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', 3935, 'a:1:{s:6:"end_at";s:19:"2025-09-08 17:10:51";}', '', 5064, '221.216.117.150') |
| 17:50:59.890 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=518 |
| 17:50:59.890 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064 |
| 17:50:59.891 | 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 (1, 'create', 3935, 1, 205, 102, 5064, '[205]', '[205]', '{"d1":"\u59da\u96ea\u7eaf","d2":"\u521b\u5efa\u4e86","d3":"\u9879\u76ee","d4":["\u4f60\u7684\u6591\u6591\u70b9\u70b9\u5427"]}') RETURNING "id" |
| 17:50:59.892 | 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', 590811, 'a:13:{s:2:"id";i:590811;s:9:"object_id";i:3935;s:11:"object_type";i:1;s:9:"target_id";i:205;s:18:"target_object_type";i:102;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:5:"[205]";s:9:"new_value";s:5:"[205]";s:11:"description";s:125:"{"d1":"\u59da\u96ea\u7eaf","d2":"\u521b\u5efa\u4e86","d3":"\u9879\u76ee","d4":["\u4f60\u7684\u6591\u6591\u70b9\u70b9\u5427"]}";s:10:"created_by";i:5064;s:10:"created_at";N;s:9:"is_delete";N;}', '', 5064, '221.216.117.150') |
| 17:50:59.893 | 1.7 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5064, 2, 1153, 'v2/task/save-new-group', '{"TaskGroups":{"client_id":"518","description":"","progress":"","project_id":"3935","situation":"\u90a3\u4f60\u624d\u80fd\u5403\u80fd\u884c\u5462","start_at":"","target_completed_at":"","taskGroupHeads":["5064"],"taskGroupUsers":["5064"],"title":"\u4f60\u7684\u6591\u6591\u70b9\u70b9\u5427"},"access_token":"-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG","device_type":"2","posttime":"1765965056","token":"d2b3e795cc3e435fa3a41e5c31e51406","version_code":"1153"}', '{"code":200,"data":{"id":205},"status":1,"msg":[{"name":"success","success":"\u65b0\u9879\u76ee\u5217\u8868\u5df2\u521b\u5efa\u6210\u529f","error":""}],"ip":"221.216.117.150","ua":"jinchangxiao\/2.3.151 (iPhone 12; iOS 18.6.2; Scale\/3.00)"}', FALSE, '2025-12-17 17:50:59') RETURNING "id" |