ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
694277bdcc13a: POST https://beta.jinchangxiao.com/v2/task/save-edit-group at 2025-12-17 05:28:29 pm by 221.216.117.150

Performance Profiling

Total processing time: 121 ms; Peak memory: 3.931 MB. Show Profiling Timeline

总计42条数据
TimeDurationCategoryInfo
  
17:28:29.87760.2 msyii\db\Command::querySELECT * 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
17:28:29.8647.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_task_group_head_of_relationships" ("task_group_id", "user_id") VALUES (202, 5064)
17:28:29.8575.5 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_task_group_user_relationships" ("task_group_id", "user_id") VALUES (202, 5064)
17:28:29.8392.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG'
17:28:29.8502.1 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_task_groups" SET "client_id"=982, "target_completed_at"='2025-12-18', "updated_at"='now()', "start_at"='2025-12-17', "project_id"=1111 WHERE "id"=202
17:28:29.8372.0 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:28:29.9461.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=1111) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
17:28:29.8751.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=982
17:28:29.9531.6 msyii\db\Command::queryINSERT 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-edit-group', '{"TaskGroups":{"client_id":"982","description":"","id":"202","progress":"","project_id":"1111","situation":"\u5c06\u9519\u5c31\u9519\u4e9f\u5f85\u89e3\u51b3\u7684","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":"1765963648","token":"2e8065e0abd3cb1cc0d007e45625bc38","version_code":"1153"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u9879\u76ee\u5217\u8868\u5df2\u88ab\u6210\u529f\u4fee\u6539","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:28:29') RETURNING "id"
17:28:29.8431.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064
17:28:29.9381.3 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (982, 1001, 'now()', NULL) RETURNING "id"
17:28:29.8531.1 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\TaskGroups', 202, 'a:0:{}', '', 5064, '221.216.117.150')
17:28:29.8561.0 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'taskGroupUsers', 202, 102, 5064, 'now()', '[["\u59da\u96ea\u7eaf"]]', '[[]]', '{"d1":"\u59da\u96ea\u7eaf","d2":"\u66f4\u65b0\u4e86","d3":"\u6210\u5458","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> \u59da\u96ea\u7eaf;"]}')
17:28:29.9451.0 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=1111
17:28:29.9480.9 msyii\db\Command::executeINSERT 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')
17:28:29.9510.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 590770, 'a:13:{s:2:"id";i:590770;s:9:"object_id";s:4:"1111";s:11:"object_type";i:1;s:9:"target_id";i:202;s:18:"target_object_type";i:102;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"[202]";s:9:"new_value";s:5:"[202]";s:11:"description";s:95:"{"d1":"\u59da\u96ea\u7eaf","d2":"\u66f4\u65b0\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')
17:28:29.8720.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_tasks" SET "status"=2 WHERE ("task_group_id"=202) AND ("status"=0) AND ("head_of"<>'5064')
17:28:29.9410.8 msyii\db\Command::queryINSERT 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', 982, 10, 202, 102, 5064, '[202]', '[202]', '{"d1":"\u59da\u96ea\u7eaf","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee","d4":["\u6d4b\u8bd5"]}') RETURNING "id"
17:28:29.9390.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 187291, 'a:5:{s:2:"id";i:187291;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')
17:28:29.9500.8 msyii\db\Command::queryINSERT 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', 1111, 1, 202, 102, 5064, '[202]', '[202]', '{"d1":"\u59da\u96ea\u7eaf","d2":"\u66f4\u65b0\u4e86","d3":"\u9879\u76ee","d4":["\u6d4b\u8bd5"]}') RETURNING "id"
17:28:29.8730.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='982'
17:28:29.9400.7 msyii\db\Command::executeINSERT 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')
17:28:29.9420.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 590769, 'a:13:{s:2:"id";i:590769;s:9:"object_id";s:3:"982";s:11:"object_type";i:10;s:9:"target_id";i:202;s:18:"target_object_type";i:102;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"[202]";s:9:"new_value";s:5:"[202]";s:11:"description";s:95:"{"d1":"\u59da\u96ea\u7eaf","d2":"\u66f4\u65b0\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')
17:28:29.8640.6 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE "task_group_id"=202
17:28:29.8480.6 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='982')
17:28:29.8490.6 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='1111')
17:28:29.9440.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='1111'
17:28:29.8450.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"='202'
17:28:29.9520.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tasks" WHERE (parent_id is null) AND ("task_group_id"=202)
17:28:29.8540.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_task_group_user_relationships" WHERE "task_group_id"=202
17:28:29.8470.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE ("user_id"=5064) AND ("task_group_id"=202)
17:28:29.9490.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982
17:28:29.9410.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064
17:28:29.8550.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5064'
17:28:29.9500.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064
17:28:29.8630.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064
17:28:29.8550.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064
17:28:29.8550.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE 0=1
17:28:29.8490.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064)
17:28:29.8500.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064)
17:28:29.8630.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_task_group_head_of_relationships" WHERE "task_group_id"=202
17:28:29.8570.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_task_group_user_relationships" WHERE "task_group_id"=202