ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a2af5d255700: POST https://beta.jinchangxiao.com/v2/schedule/list at 2026-06-12 01:52:18 am by 125.78.87.174

Performance Profiling

Total processing time: 200 ms; Peak memory: 5.152 MB. Show Profiling Timeline

总计27条数据
TimeDurationCategoryInfo
  
01:52:18.36555.2 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT s.*, CASE WHEN is_complete = true then 3 WHEN is_complete = false and end_at <= NOW() then 2 else 1 END AS sort FROM "a57be577deb434"."tbl_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = s.client_id LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE (1=1) AND (("s"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5446, 5461, 5476)) OR ("ccr"."user_id"=1001)) AND ((("s"."is_public"=1) AND ("s"."created_by" != 1001)) OR ("s"."created_by"=1001) OR ("ccr"."user_id"=1001)) GROUP BY "s"."id" ORDER BY set_top_at DESC nulls last, sort ASC, case when s.is_complete = true then complete_at END DESC, case when s.is_complete = false then end_at END ASC, s.created_at DESC) "c"
01:52:18.42032.8 msyii\db\Command::querySELECT s.*, CASE WHEN is_complete = true then 3 WHEN is_complete = false and end_at <= NOW() then 2 else 1 END AS sort FROM "a57be577deb434"."tbl_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = s.client_id LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE (1=1) AND (("s"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5446, 5461, 5476)) OR ("ccr"."user_id"=1001)) AND ((("s"."is_public"=1) AND ("s"."created_by" != 1001)) OR ("s"."created_by"=1001) OR ("ccr"."user_id"=1001)) GROUP BY "s"."id" ORDER BY set_top_at DESC nulls last, sort ASC, case when s.is_complete = true then complete_at END DESC, case when s.is_complete = false then end_at END ASC, s.created_at DESC LIMIT 10
01:52:18.45929.3 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=9) AND ("object_id" IN (18347, 18268, 18169, 18062, 18269, 18360, 18359, 18354, 18353, 18352)) GROUP BY "object_id"
01:52:18.50728.6 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=9) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (18347, 18268, 18169, 18062, 18269, 18360, 18359, 18354, 18353, 18352)) GROUP BY "object_id"
01:52:18.5033.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_descriptions" WHERE "schedule_id" IN (18347, 18268, 18169, 18062, 18269, 18360, 18359, 18354, 18353, 18352) ORDER BY "created_at" DESC
01:52:18.4893.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id" IN (18347, 18268, 18169, 18062, 18269, 18360, 18359, 18354, 18353, 18352))
01:52:18.5433.4 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 0, 273, 'v2/schedule/list', '{"access_token":"lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC","device_type":"0","ScheduleSearch":{"keyword":"","created_by":"","department_id":"","status":""},"version_code":"273","page":"1","token":"2a79a5b3d546c7dda166d44b7d32b068","posttime":"1781200339","pagesize":"10"}', '{"code":200,"data":{"list":[{"id":18347,"client_id":null,"schedule_title":"\u4e8b\u9879\u5185\u5bb9\u6765\u529e\u4e8b\u9879\u5185\u5bb9\u5f00\u59cb\u65f6\u95f4\u622a\u6b62\uff0c\u65f6\u95f4\u63d0\u9192\u65f6\u95f4\u8d1f\u8d23\u4eba\u3002","description":null,"schedule_week":null,"start_at":"","complete_at":"","complete_description":null,"is_complete":false,"alarm_before":null,"created_by":1000,"created_at":"2026-04-17 12:07:05","is_closed":false,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"","is_public":1,"system_calendar_id":null,"creator":1000,"project_id":null,"updated_at":"2026-04-17 12:07:05","set_top_at":"2026-04-30 11:33:30.961846","sort":1,"client":null,"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":{"object_id":18347,"comment":5},"attachmentRelationships":[],"scheduleCreator":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"}},"project":null,"headUsers":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":null,"schedule_status":0,"schedule_status_display":"\u8fdb\u884c\u4e2d","complete_at_display":"","complete_at_display2":"","end_at_display":null,"end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":true,"can_delete":true,"can_report":false,"unread":0,"bgcolor":"#4e6ef2","can_create_project":true,"start_at_display":null},{"id":18268,"client_id":2125,"schedule_title":"\u9500\u552e\u9636\u6bb5\uff1a\u65b9\u6848\u8bbe\u8ba1\n\u76ee\u7684\uff1a\u786e\u5b9a\u65b9\u6848\n\u52a8\u4f5c\uff1a\u8054\u7cfb\u5e9e\u8001\u5e08","description":null,"schedule_week":null,"start_at":"","complete_at":"","complete_description":null,"is_complete":false,"alarm_before":null,"created_by":5087,"created_at":"2026-03-08 23:43:25","is_closed":false,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"2026-06-30 00:00:00","is_public":1,"system_calendar_id":null,"creator":5087,"project_id":3796,"updated_at":"2026-03-22 19:40:46","set_top_at":null,"sort":1,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8","sales_rep":5087,"logo":null,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":18268,"comment":7},"attachmentRelationships":[],"scheduleCreator":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"project":{"id":3796,"key":3796,"name":"deepseek\u79c1\u6709\u5316\u90e8\u7f72","project_status":3,"budget":"790000","collected":"0","projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"project_status_display":"\u5546\u673a\u6210\u4ea4","bgcolor":"#53cd02"},"headUsers":[{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":20854,"schedule_id":18268,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-22 19:40:30","created_at_display":"03-22 19:40"},{"id":20654,"schedule_id":18268,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-15 20:12:34","created_at_display":"03-15 20:12"},{"id":20500,"schedule_id":18268,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u8054\u7cfb\u5e9e\u8001\u5e08 \u4e0a\u5468\u603b\u7ed3\uff1a\u672a\u8054\u7cfb \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-08 23:43:39","created_at_display":"03-08 23:43"}],"unreadComments":null,"schedule_status":0,"schedule_status_display":"\u8fdb\u884c\u4e2d","complete_at_display":"","complete_at_display2":"","end_at_display":"2026-06-30 00:00:00+08","end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":true,"can_delete":true,"can_report":false,"unread":0,"bgcolor":"#4e6ef2","can_create_project":true,"start_at_display":null},{"id":18169,"client_id":2128,"schedule_title":"\u9500\u552e\u9636\u6bb5\uff1a\u786e\u8ba4\u95ee\u9898\n\u76ee\u7684\uff1a\u786e\u8ba4\u95ee\u9898\n\u52a8\u4f5c\uff1a\u8054\u7cfb\u738b\u6d77\u6d9b\u8001\u5e08","description":null,"schedule_week":null,"start_at":"","complete_at":"","complete_description":null,"is_complete":false,"alarm_before":null,"created_by":5087,"created_at":"2026-01-18 22:40:33","is_closed":false,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"2026-07-30 00:00:00","is_public":1,"system_calendar_id":null,"creator":5087,"project_id":4109,"updated_at":"2026-03-22 19:37:00","set_top_at":null,"sort":1,"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":5087,"logo":null,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":18169,"comment":8},"attachmentRelationships":[],"scheduleCreator":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"project":{"id":4109,"key":4109,"name":"\u865a\u62df\u684c\u9762\u5efa\u8bbe-K","project_status":2,"budget":"516000","collected":"0","projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"project_status_display":"\u660e\u786e\u9700\u6c42","bgcolor":"#0064ec"},"headUsers":[{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":20849,"schedule_id":18169,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-22 19:36:40","created_at_display":"03-22 19:36"},{"id":20652,"schedule_id":18169,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-15 20:06:04","created_at_display":"03-15 20:06"},{"id":20508,"schedule_id":18169,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-09 00:07:23","created_at_display":"03-09 00:07"},{"id":20417,"schedule_id":18169,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u786e\u8ba4\u670d\u52a1\u5668\u914d\u7f6e \u4e0a\u5468\u603b\u7ed3\uff1a\u670d\u52a1\u5668\u5df2\u62a5\u4ef7 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-01 23:49:13","created_at_display":"03-01 23:49"},{"id":19889,"schedule_id":18169,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u62dc\u8bbf\u738b\u8001\u5e08\uff0c\u6d4b\u8bd5\u524d\u9700\u8981\u91c7\u8d2d\u786c\u4ef6 12\u53f0\u56fd\u4ea7\u670d\u52a1\u5668 \u672c\u5468\u8ba1\u5212\uff1a\u786e\u8ba4\u670d\u52a1\u5668\u914d\u7f6e","created_at":"2026-01-25 22:12:59","created_at_display":"01-25 22:12"}],"unreadComments":null,"schedule_status":0,"schedule_status_display":"\u8fdb\u884c\u4e2d","complete_at_display":"","complete_at_display2":"","end_at_display":"2026-07-30 00:00:00+08","end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":true,"can_delete":true,"can_report":false,"unread":0,"bgcolor":"#4e6ef2","can_create_project":true,"start_at_display":null},{"id":18062,"client_id":2526,"schedule_title":"\u9500\u552e\u9636\u6bb5\uff1a\u7b7e\u8ba2\u5408\u540c\n\u76ee\u7684\uff1a\u7b7e\u5408\u540c\n\u52a8\u4f5c\uff1a\u8054\u7cfb\u8881\u73b2\u73b2","description":null,"schedule_week":null,"start_at":"","complete_at":"","complete_description":null,"is_complete":false,"alarm_before":null,"created_by":5087,"created_at":"2025-11-16 23:31:08","is_closed":false,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"2026-07-30 00:00:00","is_public":1,"system_calendar_id":null,"creator":5087,"project_id":4047,"updated_at":"2026-03-09 00:27:13","set_top_at":null,"sort":1,"client":{"id":2526,"key":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5087,"logo":null,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":18062,"comment":19},"attachmentRelationships":[],"scheduleCreator":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"project":{"id":4047,"key":4047,"name":"KVM\u91c7\u8d2d","project_status":3,"budget":"6000","collected":"0","projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"project_status_display":"\u5546\u673a\u6210\u4ea4","bgcolor":"#53cd02"},"headUsers":[{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":20876,"schedule_id":18062,"description":"\u4e0a\u5468\u8ba1\u5212:\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-22 19:54:48","created_at_display":"03-22 19:54"},{"id":20660,"schedule_id":18062,"description":"\u4e0a\u5468\u8ba1\u5212:\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-15 20:22:11","created_at_display":"03-15 20:22"},{"id":20516,"schedule_id":18062,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-09 00:26:55","created_at_display":"03-09 00:26"},{"id":20422,"schedule_id":18062,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u5d14\u5408\u540c \u4e0a\u5468\u603b\u7ed3\uff1a\u5728\u6d41\u7a0b\u4e2d \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-02 00:06:15","created_at_display":"03-02 00:06"},{"id":20041,"schedule_id":18062,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u5d14\u5408\u540c","created_at":"2026-02-01 19:19:50","created_at_display":"02-01 19:19"},{"id":19893,"schedule_id":18062,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-01-25 22:19:07","created_at_display":"01-25 22:19"},{"id":19726,"schedule_id":18062,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u5d14\u5408\u540c \u4e0a\u5468\u603b\u7ed3\uff1a\u7528\u6237\u5df2\u4e0a\u6d41\u7a0b\u7b49\u9886\u5bfc\u7b7e\u5b57\u76d6\u7ae0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-01-18 22:54:48","created_at_display":"01-18 22:54"},{"id":19542,"schedule_id":18062,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u5d14\u5408\u540c","created_at":"2026-01-11 20:48:35","created_at_display":"01-11 20:48"},{"id":19350,"schedule_id":18062,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u5d14\u5408\u540c \u4e0a\u5468\u603b\u7ed3\uff1a\u6761\u6b3e\u6838\u5bf9\u6e05\u695a\uff0c\u62d3\u5b9e\u5df2\u76d6\u7ae0\u53d1\u7ed9\u7528\u6237\u8d70\u6d41\u7a0b \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-01-02 12:37:56","created_at_display":"01-02 12:37"},{"id":19170,"schedule_id":18062,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u5d14\u5408\u540c","created_at":"2025-12-28 15:28:10","created_at_display":"2025-12-28 15:28"},{"id":18775,"schedule_id":18062,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u6d4b\u63a7\u5408\u540c\u5df2\u5728\u6d41\u7a0b\u5185\uff0c\u7ee7\u7eed\u8ddf\u8fdb\u3002\u4e0a\u5468\u603b\u7ed3\uff1a\u5b89\u88c5\u5b9e\u65bd\u5df2\u5b8c\u6210 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2025-12-14 15:55:59","created_at_display":"2025-12-14 15:55"},{"id":18632,"schedule_id":18062,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u5173\u6ce8\u5230\u8d27\u65f6\u95f4 \u4e0a\u5468\u603b\u7ed3\uff1a\u5b8c\u6210\u5b89\u88c5 \u672c\u5468\u8ba1\u5212\uff1a\u6d4b\u63a7\u5408\u540c\u5df2\u5728\u6d41\u7a0b\u5185\uff0c\u7ee7\u7eed\u8ddf\u8fdb\u3002","created_at":"2025-12-07 22:53:53","created_at_display":"2025-12-07 22:53"},{"id":18344,"schedule_id":18062,"description":"\u4e0a\u5468 \u8ba1\u5212\uff1a\u8ddf\u8fdbKVM\u5382\u5546\u7b7e\u5408\u540c\uff0c\u4e0a\u5468\u603b\u7ed3\uff1a\u5df2\u8054\u7cfb\u5382\u5546 \u672c\u5468\u8ba1\u5212\uff1a\u5173\u6ce8\u5230\u8d27\u65f6\u95f4","created_at":"2025-11-30 08:57:36","created_at_display":"2025-11-30 08:57"},{"id":18171,"schedule_id":18062,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u63a8\u8fdb\u5408\u540c \u4e0a\u5468\u603b\u7ed3\uff1a\u8d77\u8349\u5408\u540c\uff0c\u672c\u5468\u8ba1\u5212\uff1a\u8ddfKVM\u5382\u5546\u7b7e\u5408\u540c\u3002","created_at":"2025-11-23 20:24:23","created_at_display":"2025-11-23 20:24"},{"id":17969,"schedule_id":18062,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u5e73\u53f0\u4e2d\u6807\uff0c\u672c\u5468\u8ba1\u5212\uff1a\u63a8\u8fdb\u5408\u540c","created_at":"2025-11-16 23:32:04","created_at_display":"2025-11-16 23:32"}],"unreadComments":null,"schedule_status":0,"schedule_status_display":"\u8fdb\u884c\u4e2d","complete_at_display":"","complete_at_display2":"","end_at_display":"2026-07-30 00:00:00+08","end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":true,"can_delete":true,"can_report":false,"unread":0,"bgcolor":"#4e6ef2","can_create_project":true,"start_at_display":null},{"id":18269,"client_id":2128,"schedule_title":"\u9500\u552e\u9636\u6bb5\uff1a\u5546\u52a1\u62a5\u4ef7\n\u76ee\u7684\uff1a\u63a8\u52a8\u9879\u76ee\n\u52a8\u4f5c\uff1a\u8054\u7cfb\u4efb\u8001\u5e08\u3002","description":null,"schedule_week":null,"start_at":"","complete_at":"","complete_description":null,"is_complete":false,"alarm_before":null,"created_by":5087,"created_at":"2026-03-08 23:50:30","is_closed":false,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"2026-12-31 00:00:00","is_public":1,"system_calendar_id":null,"creator":5087,"project_id":3854,"updated_at":"2026-03-08 23:50:30","set_top_at":null,"sort":1,"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":5087,"logo":null,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":18269,"comment":4},"attachmentRelationships":[],"scheduleCreator":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"project":{"id":3854,"key":3854,"name":"\u5907\u4efd\u9879\u76ee\u4e8c\u671f","project_status":3,"budget":"44540520","collected":"0","projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"project_status_display":"\u5546\u673a\u6210\u4ea4","bgcolor":"#53cd02"},"headUsers":[{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":20858,"schedule_id":18269,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-22 19:45:03","created_at_display":"03-22 19:45"},{"id":20655,"schedule_id":18269,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-15 20:13:03","created_at_display":"03-15 20:13"},{"id":20501,"schedule_id":18269,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-08 23:51:01","created_at_display":"03-08 23:51"}],"unreadComments":null,"schedule_status":0,"schedule_status_display":"\u8fdb\u884c\u4e2d","complete_at_display":"","complete_at_display2":"","end_at_display":"2026-12-31 00:00:00+08","end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":true,"can_delete":true,"can_report":false,"unread":0,"bgcolor":"#4e6ef2","can_create_project":true,"start_at_display":null},{"id":18360,"client_id":2128,"schedule_title":"\u9500\u552e\u9636\u6bb5\uff1a\u786e\u8ba4\u95ee\u9898","description":null,"schedule_week":null,"start_at":"","complete_at":"","complete_description":null,"is_complete":false,"alarm_before":null,"created_by":1001,"created_at":"2026-06-04 12:36:36","is_closed":false,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"","is_public":1,"system_calendar_id":null,"creator":1001,"project_id":3854,"updated_at":"2026-06-04 12:36:36","set_top_at":null,"sort":1,"client":{"id":2128,"key":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":5087,"logo":null,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{"object_id":18360,"comment":1},"attachmentRelationships":[],"scheduleCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"project":{"id":3854,"key":3854,"name":"\u5907\u4efd\u9879\u76ee\u4e8c\u671f","project_status":3,"budget":"44540520","collected":"0","projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"project_status_display":"\u5546\u673a\u6210\u4ea4","bgcolor":"#53cd02"},"headUsers":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":null,"schedule_status":0,"schedule_status_display":"\u8fdb\u884c\u4e2d","complete_at_display":"","complete_at_display2":"","end_at_display":null,"end_at_display2":"","is_self":true,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":true,"can_delete":true,"can_report":true,"unread":0,"bgcolor":"#4e6ef2","can_create_project":true,"start_at_display":null},{"id":18359,"client_id":1933,"schedule_title":"\u6d4b\u8bd5","description":null,"schedule_week":null,"start_at":"","complete_at":"","complete_description":null,"is_complete":false,"alarm_before":null,"created_by":1001,"created_at":"2026-05-18 14:33:52","is_closed":false,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"","is_public":1,"system_calendar_id":null,"creator":1001,"project_id":null,"updated_at":"2026-05-18 14:33:52","set_top_at":null,"sort":1,"client":{"id":1933,"key":1933,"name":"SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8(\u91cd\u590d\u5ba2\u6237)","sales_rep":1001,"logo":null,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{"object_id":18359,"comment":1},"attachmentRelationships":[],"scheduleCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"project":null,"headUsers":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":null,"schedule_status":0,"schedule_status_display":"\u8fdb\u884c\u4e2d","complete_at_display":"","complete_at_display2":"","end_at_display":null,"end_at_display2":"","is_self":true,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":true,"can_delete":true,"can_report":true,"unread":0,"bgcolor":"#4e6ef2","can_create_project":true,"start_at_display":null},{"id":18354,"client_id":null,"schedule_title":"\u8fd9\u672c\u8eab\u5c31\u5728\u73ed\u7761\u89c9\u53ef\u4ee5\u5148\u63a5\u53d7\u65f6\u95f4","description":null,"schedule_week":null,"start_at":"","complete_at":"","complete_description":null,"is_complete":false,"alarm_before":null,"created_by":5064,"created_at":"2026-04-18 06:43:10","is_closed":false,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"","is_public":1,"system_calendar_id":null,"creator":5064,"project_id":null,"updated_at":"2026-04-18 06:43:10","set_top_at":null,"sort":1,"client":null,"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":{"object_id":18354,"comment":1},"attachmentRelationships":[],"scheduleCreator":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}},"project":null,"headUsers":[{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":null,"schedule_status":0,"schedule_status_display":"\u8fdb\u884c\u4e2d","complete_at_display":"","complete_at_display2":"","end_at_display":null,"end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":true,"can_delete":true,"can_report":false,"unread":0,"bgcolor":"#4e6ef2","can_create_project":true,"start_at_display":null},{"id":18353,"client_id":null,"schedule_title":"\u65b0\u7586\u4f60\u5988\u7684\u4ee3","description":null,"schedule_week":null,"start_at":"","complete_at":"","complete_description":null,"is_complete":false,"alarm_before":null,"created_by":5064,"created_at":"2026-04-17 22:40:53","is_closed":false,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"","is_public":1,"system_calendar_id":null,"creator":5064,"project_id":null,"updated_at":"2026-04-17 22:40:53","set_top_at":null,"sort":1,"client":null,"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":{"object_id":18353,"comment":1},"attachmentRelationships":[],"scheduleCreator":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}},"project":null,"headUsers":[{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":null,"schedule_status":0,"schedule_status_display":"\u8fdb\u884c\u4e2d","complete_at_display":"","complete_at_display2":"","end_at_display":null,"end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":true,"can_delete":true,"can_report":false,"unread":0,"bgcolor":"#4e6ef2","can_create_project":true,"start_at_display":null},{"id":18352,"client_id":null,"schedule_title":"\u4e00\u4e8c\u4e09\u56db\u4e94\u516d","description":null,"schedule_week":null,"start_at":"","complete_at":"","complete_description":null,"is_complete":false,"alarm_before":null,"created_by":5064,"created_at":"2026-04-17 22:37:55","is_closed":false,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"","is_public":1,"system_calendar_id":null,"creator":5064,"project_id":null,"updated_at":"2026-04-17 22:37:55","set_top_at":null,"sort":1,"client":null,"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":{"object_id":18352,"comment":1},"attachmentRelationships":[],"scheduleCreator":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}},"project":null,"headUsers":[{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":null,"schedule_status":0,"schedule_status_display":"\u8fdb\u884c\u4e2d","complete_at_display":"","complete_at_display2":"","end_at_display":null,"end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":true,"can_delete":true,"can_report":false,"unread":0,"bgcolor":"#4e6ef2","can_create_project":true,"start_at_display":null}],"thisUser":null,"pagenation":{"totalcount":8216,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"125.78.87.174","ua":"jinchangxiao\/2.3.173 (XiaomiMi 10; Android 13)"}', FALSE, '2026-06-12 01:52:18', 191959040) RETURNING "id"
01:52:18.4993.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=32) AND ("object_id" IN (18347, 18268, 18169, 18062, 18269, 18360, 18359, 18354, 18353, 18352))
01:52:18.4952.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_head_of_rels" WHERE "schedule_id" IN (18347, 18268, 18169, 18062, 18269, 18360, 18359, 18354, 18353, 18352)
01:52:18.4980.9 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5064, 1000, 5087))
01:52:18.3540.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC'
01:52:18.3560.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
01:52:18.4550.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2125, 2128, 2526, 1933)
01:52:18.3640.6 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
01:52:18.4560.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5087, 1001, 5064)
01:52:18.4970.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5087, 1000, 5064, 1001)
01:52:18.3530.4 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
01:52:18.4560.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5087, 1001)
01:52:18.4920.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5087, 1001, 5064)
01:52:18.4940.4 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "project_status", "budget", "collected" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3796, 4109, 4047, 3854)
01:52:18.5030.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_carbon_copy_rels" WHERE "schedule_id" IN (18347, 18268, 18169, 18062, 18269, 18360, 18359, 18354, 18353, 18352)
01:52:18.4930.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5064, 1000, 5087))
01:52:18.4570.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5087, 1001, 5064)
01:52:18.4580.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5064, 1000, 5087))
01:52:18.4570.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 10, 1)
01:52:18.4940.3 msyii\db\Command::querySELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id" IN (3, 2)
01:52:18.4580.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 10, 1)