ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
694273771431f: POST https://beta.jinchangxiao.com/v2/task/save-new-group at 2025-12-17 05:10:15 pm by 221.216.117.150

Database Queries

总计34条数据
TimeDurationTypeQuery
  
17:10:15.0862.9 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG'

[+] Explain
17:10:15.0901.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064

[+] Explain
17:10:15.0920.6 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='982')

[+] Explain
17:10:15.0930.5 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='1111')

[+] Explain
17:10:15.0940.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064)

[+] Explain
17:10:15.0940.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064)

[+] Explain
17:10:15.0951.6 msINSERTINSERT INTO "a57be577deb434"."tbl_task_groups" ("client_id", "description", "progress", "project_id", "situation", "start_at", "target_completed_at", "title", "created_by", "head_of") VALUES (982, '', 0, 1111, '测试', '2025-12-17', '2025-12-18', '测试', 5064, 5064) RETURNING "id"

[+] Explain
17:10:15.0971.0 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\TaskGroups', 204, 'a:17:{s:2:"id";i:204;s:5:"title";s:6:"测试";s:11:"description";s:0:"";s:9:"client_id";s:3:"982";s:7:"head_of";i:5064;s:6:"status";N;s:19:"target_completed_at";s:19:"2025-12-18 00:00:00";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:6:"测试";s:8:"start_at";s:19:"2025-12-17 00:00:00";s:10:"project_id";s:4:"1111";s:20:"complete_description";N;s:8:"progress";i:0;s:6:"weight";N;}', '', 5064, '221.216.117.150')

[+] Explain
17:10:15.0980.3 msDELETEDELETE FROM "a57be577deb434"."tbl_task_group_user_relationships" WHERE "task_group_id"=204

[+] Explain
17:10:15.0980.9 msINSERTINSERT INTO "a57be577deb434"."tbl_task_group_user_relationships" ("task_group_id", "user_id") VALUES (204, 5064)

[+] Explain
17:10:15.0990.2 msDELETEDELETE FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE "task_group_id"=204

[+] Explain
17:10:15.1001.5 msINSERTINSERT INTO "a57be577deb434"."tbl_task_group_head_of_relationships" ("task_group_id", "user_id") VALUES (204, 5064)

[+] Explain
17:10:15.1010.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=204

[+] Explain
17:10:15.1020.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064

[+] Explain
17:10:15.1031.0 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 204, 102, 5064, '2025-12-17 17:10:15', '{"id":204,"title":"\u6d4b\u8bd5","description":"","client_id":982,"head_of":5064,"status":0,"target_completed_at":"2025-12-18 00:00:00","completed_at":null,"created_by":5064,"created_at":"2025-12-17 17:10:15","updated_at":"2025-12-17 17:10:15","situation":"\u6d4b\u8bd5","start_at":"2025-12-17 00:00:00","project_id":1111,"complete_description":null,"progress":0,"weight":0}', '{"id":204,"title":"\u6d4b\u8bd5","description":"","client_id":982,"head_of":5064,"status":0,"target_completed_at":"2025-12-18 00:00:00","completed_at":null,"created_by":5064,"created_at":"2025-12-17 17:10:15","updated_at":"2025-12-17 17:10:15","situation":"\u6d4b\u8bd5","start_at":"2025-12-17 00:00:00","project_id":1111,"complete_description":null,"progress":0,"weight":0}', '{"d1":"\u59da\u96ea\u7eaf","d2":"\u521b\u5efa\u4e86","d3":"\u9879\u76ee","d4":[]}') RETURNING "id"

[+] Explain
17:10:15.1041.3 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 590749, 'a:13:{s:2:"id";i:590749;s:9:"object_id";i:204;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:374:"{"id":204,"title":"\u6d4b\u8bd5","description":"","client_id":982,"head_of":5064,"status":0,"target_completed_at":"2025-12-18 00:00:00","completed_at":null,"created_by":5064,"created_at":"2025-12-17 17:10:15","updated_at":"2025-12-17 17:10:15","situation":"\u6d4b\u8bd5","start_at":"2025-12-17 00:00:00","project_id":1111,"complete_description":null,"progress":0,"weight":0}";s:9:"new_value";s:374:"{"id":204,"title":"\u6d4b\u8bd5","description":"","client_id":982,"head_of":5064,"status":0,"target_completed_at":"2025-12-18 00:00:00","completed_at":null,"created_by":5064,"created_at":"2025-12-17 17:10:15","updated_at":"2025-12-17 17:10:15","situation":"\u6d4b\u8bd5","start_at":"2025-12-17 00:00:00","project_id":1111,"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:10:15";s:9:"is_delete";N;}', '', 5064, '221.216.117.150')

[+] Explain
17:10:15.1054.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982

[+] Explain
17:10:15.1151.3 msUPDATEUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=982

[+] Explain
17:10:15.117774.5 msSELECTSELECT * 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

[+] Explain
17:10:15.8922.9 msINSERTINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (982, 1001, 'now()', NULL) RETURNING "id"

[+] Explain
17:10:15.8950.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 187288, 'a:5:{s:2:"id";i:187288;s:9:"client_id";i:982;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 5064, '221.216.117.150')

[+] Explain
17:10:15.8960.7 msINSERTINSERT 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:{}', '', 5064, '221.216.117.150')

[+] Explain
17:10:15.8970.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064

[+] Explain
17:10:15.8980.8 msINSERTINSERT 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', 982, 10, 204, 102, 5064, '[204]', '[204]', '{"d1":"\u59da\u96ea\u7eaf","d2":"\u521b\u5efa\u4e86","d3":"\u9879\u76ee","d4":["\u6d4b\u8bd5"]}') RETURNING "id"

[+] Explain
17:10:15.8980.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 590750, 'a:13:{s:2:"id";i:590750;s:9:"object_id";i:982;s:11:"object_type";i:10;s:9:"target_id";i:204;s:18:"target_object_type";i:102;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:5:"[204]";s:9:"new_value";s:5:"[204]";s:11:"description";s:95:"{"d1":"\u59da\u96ea\u7eaf","d2":"\u521b\u5efa\u4e86","d3":"\u9879\u76ee","d4":["\u6d4b\u8bd5"]}";s:10:"created_by";i:5064;s:10:"created_at";N;s:9:"is_delete";N;}', '', 5064, '221.216.117.150')

[+] Explain
17:10:15.9002.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=1111

[+] Explain
17:10:15.9031.0 msUPDATEUPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=1111

[+] Explain
17:10:15.9057.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=1111) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1

[+] Explain
17:10:15.9120.8 msINSERTINSERT 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";}', '', 5064, '221.216.117.150')

[+] Explain
17:10:15.9130.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982

[+] Explain
17:10:15.9140.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064

[+] Explain
17:10:15.9140.8 msINSERTINSERT 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', 1111, 1, 204, 102, 5064, '[204]', '[204]', '{"d1":"\u59da\u96ea\u7eaf","d2":"\u521b\u5efa\u4e86","d3":"\u9879\u76ee","d4":["\u6d4b\u8bd5"]}') RETURNING "id"

[+] Explain
17:10:15.9150.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 590751, 'a:13:{s:2:"id";i:590751;s:9:"object_id";i:1111;s:11:"object_type";i:1;s:9:"target_id";i:204;s:18:"target_object_type";i:102;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:5:"[204]";s:9:"new_value";s:5:"[204]";s:11:"description";s:95:"{"d1":"\u59da\u96ea\u7eaf","d2":"\u521b\u5efa\u4e86","d3":"\u9879\u76ee","d4":["\u6d4b\u8bd5"]}";s:10:"created_by";i:5064;s:10:"created_at";N;s:9:"is_delete";N;}', '', 5064, '221.216.117.150')

[+] Explain
17:10:15.9161.1 msINSERTINSERT 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":"982","description":"","progress":"","project_id":"1111","situation":"\u6d4b\u8bd5","start_at":"2025-12-17","target_completed_at":"2025-12-18","taskGroupHeads":["5064"],"taskGroupUsers":["5064"],"title":"\u6d4b\u8bd5"},"access_token":"-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG","device_type":"2","posttime":"1765962624","token":"b26eed79a9ebb423769e681ed6301c3f","version_code":"1153"}', '{"code":200,"data":{"id":204},"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:10:15') RETURNING "id"

[+] Explain