6a39ed8a934c0: POST https://beta.jinchangxiao.com/v2/task/save-edit at 2026-06-23 10:20:58 am by 223.104.40.22
Database Queries
总计26条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 10:20:58.618 | 10.2 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC' |
| 10:20:58.654 | 10.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 10:20:58.679 | 10.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "id"='1767' |
| 10:20:58.698 | 0.7 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "id"='1596') |
| 10:20:58.699 | 0.4 ms | SELECT | SELECT "id", "parent_id" FROM "a57be577deb434"."tbl_tasks" WHERE "id"='1596' |
| 10:20:58.700 | 0.4 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106) |
| 10:20:58.700 | 0.4 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1000') |
| 10:20:58.701 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000) |
| 10:20:58.702 | 1.6 ms | UPDATE | UPDATE "a57be577deb434"."tbl_tasks" SET "head_of"=1000, "updated_at"='now()', "is_important"=0, "start_at"=NULL, "parent_id"=1596 WHERE "id"=1767 |
| 10:20:58.704 | 1.9 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', 1767, 'a:0:{}', '', 1000, '223.104.40.22') |
| 10:20:58.706 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "id"='1596' |
| 10:20:58.707 | 1.3 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', 1767, 'a:0:{}', '', 1000, '223.104.40.22') |
| 10:20:58.708 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1767 |
| 10:20:58.709 | 1.2 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', 1767, 'a:0:{}', '', 1000, '223.104.40.22') |
| 10:20:58.711 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "id"='1596' |
| 10:20:58.711 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1596 |
| 10:20:58.712 | 1.5 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', 1713, 'a:0:{}', '', 1000, '223.104.40.22') |
| 10:20:58.714 | 0.9 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', 1767, 'a:0:{}', '', 1000, '223.104.40.22') |
| 10:20:58.715 | 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\Tasks', 1596, 'a:3:{s:19:"target_completed_at";s:19:"2026-05-30 00:00:00";s:8:"start_at";s:19:"2026-05-14 00:00:00";s:6:"end_at";s:19:"2026-05-30 00:00:00";}', '', 1000, '223.104.40.22') |
| 10:20:58.717 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 10:20:58.718 | 1.1 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', 1596, 'a:3:{s:19:"target_completed_at";s:19:"2026-05-30 00:00:00";s:8:"start_at";s:19:"2026-05-14 00:00:00";s:6:"end_at";s:19:"2026-05-30 00:00:00";}', '', 1000, '223.104.40.22') |
| 10:20:58.719 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 10:20:58.719 | 0.5 ms | SELECT | SELECT SUM(weight) FROM "a57be577deb434"."tbl_tasks" WHERE ("task_group_id"=106) AND ("status"=1) |
| 10:20:58.720 | 0.5 ms | SELECT | SELECT "status", "progress" FROM "a57be577deb434"."tbl_tasks" WHERE ("task_group_id"=106) AND (parent_id is null) |
| 10:20:58.721 | 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', 106, 'a:0:{}', '', 1000, '223.104.40.22') |
| 10:20:58.723 | 2.6 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 2, 1160, 'v2/task/save-edit', '{"Tasks":{"head_of":"1000","id":"1767","is_important":"0","parent_id":"1596","start_at":"","target_completed_at":"","title":"1"},"access_token":"R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC","device_type":"2","posttime":"1782181248","token":"962bcbd624b4de855f27060dbd11abd5","version_code":"1160"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u9879\u76ee\u4efb\u52a1\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"ip":"223.104.40.22","ua":"jinchangxiao\/2.3.157 (iPhone 12; iOS 26.5; Scale\/3.00)"}', FALSE, '2026-06-23 10:20:58', 110334720) RETURNING "id" |