6867444781951: POST https://beta.jinchangxiao.com/v2/schedule/save-edit at 2025-07-04 11:02:31 am by 223.104.41.148
Database Queries
总计18条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 11:02:31.534 | 2.7 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd' |
| 11:02:31.537 | 1.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 11:02:31.540 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"='17699' |
| 11:02:31.541 | 0.5 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3337') |
| 11:02:31.542 | 0.4 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3815') |
| 11:02:31.542 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000) |
| 11:02:31.543 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000) |
| 11:02:31.543 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 11:02:31.544 | 0.9 ms | UPDATE | UPDATE "a57be577deb434"."tbl_schedules" SET "client_id"=3337, "start_at"='2025-07-04 11:02', "end_at"='2025-07-04 18:00', "is_public"=1, "project_id"=3815, "updated_at"='now()' WHERE "id"=17699 |
| 11:02:31.545 | 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\Schedules', 17699, 'a:2:{s:8:"start_at";s:19:"2025-07-04 11:02:00";s:6:"end_at";s:19:"2025-07-04 18:00:00";}', '', 1000, '223.104.41.148') |
| 11:02:31.546 | 1.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id"=17699) |
| 11:02:31.548 | 1.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id"=17699) |
| 11:02:31.549 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_schedule_carbon_copy_rels" WHERE "schedule_id"=17699 |
| 11:02:31.549 | 0.7 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_schedule_carbon_copy_rels" WHERE "schedule_id"=17699 |
| 11:02:31.550 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_schedule_carbon_copy_rels" ("schedule_id", "user_id") VALUES (17699, 1017), (17699, 5250) |
| 11:02:31.551 | 1.0 ms | SELECT | SELECT "id" FROM "a57be577deb434"."tbl_schedule_descriptions" WHERE "schedule_id"=17699 |
| 11:02:31.553 | 0.8 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_schedule_descriptions" WHERE ("schedule_id"=17699) |
| 11:02:31.554 | 1.1 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', 1000, 2, 1141, 'v2/schedule/save-edit', '{"Schedules":{"alarm_before":"","client_id":"3337","end_at":"2025-07-04 18:00","form_scheduleCarbonCopyRels":["1017","5250"],"headUsers":"","id":"17699","is_public":"1","project_id":"3815","schedule_title":"\u5973\u5973\u5973","start_at":"2025-07-04 11:02"},"access_token":"Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd","device_type":"2","posttime":"1751598208","token":"90b399c316a654610a814af48950f208","version_code":"1141"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u5f85\u529e\u4e8b\u9879\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}]}', FALSE, '2025-07-04 11:02:31') RETURNING "id" |