ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a2af5d2de614: 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: 223 ms; Peak memory: 5.138 MB. Show Profiling Timeline

总计27条数据
TimeDurationCategoryInfo
  
01:52:18.92759.6 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.98740.7 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 OFFSET 10
01:52:19.03332.6 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=9) AND ("object_id" IN (18351, 18350, 18344, 18342, 18337, 18336, 18330, 18326, 18325, 18323)) GROUP BY "object_id"
01:52:19.09232.0 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 (18351, 18350, 18344, 18342, 18337, 18336, 18330, 18326, 18325, 18323)) GROUP BY "object_id"
01:52:19.0884.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_descriptions" WHERE "schedule_id" IN (18351, 18350, 18344, 18342, 18337, 18336, 18330, 18326, 18325, 18323) ORDER BY "created_at" DESC
01:52:19.0733.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id" IN (18351, 18350, 18344, 18342, 18337, 18336, 18330, 18326, 18325, 18323))
01:52:19.0843.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=32) AND ("object_id" IN (18351, 18350, 18344, 18342, 18337, 18336, 18330, 18326, 18325, 18323))
01:52:19.0802.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_head_of_rels" WHERE "schedule_id" IN (18351, 18350, 18344, 18342, 18337, 18336, 18330, 18326, 18325, 18323)
01:52:19.1292.0 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":"2","token":"41ca59b70fe84e50d4e9198d92e916b6","posttime":"1781200339","pagesize":"10"}', '{"code":200,"data":{"list":[{"id":18351,"client_id":null,"schedule_title":"\u5929\u4ece\u6765\u4e0d\u89c9\u5f97\u77e5","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:36:37","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:36:37","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":18351,"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":18350,"client_id":null,"schedule_title":"\u4f60\u53bb\u4e8c\u4e09\u91cc","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:36:18","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:36:18","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":18350,"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":18344,"client_id":null,"schedule_title":"\u4f46\u662f\u65f6\u95f4\u5feb\u4e50\u4e0d\u5728\u592a\u8eab\u5bb6\u9a76\u662f\u65b0\u7684\u4e8b\u60c5\u80fd\u540c\u6b65\u4e86\u5427f\u7b49\u7b49\u8fd9","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 10:29:27","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 10:29:27","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":18344,"comment":3},"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":[{"id":21053,"schedule_id":18344,"description":"\u4e2d\u524d\u6d4b\u8bd5\u592a\u9633\u65f6\u4e09\u592a\u539f\u5e02\u4e0a\u5927\u7684\u6570\u5c0f\u662f\u5728\u662f\u6211\u5728\u6211\u90a3\u4f60\u8fd9\u4f60","created_at":"2026-04-17 10:30:26","created_at_display":"04-17 10:30"}],"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":18342,"client_id":null,"schedule_title":"\u65a4\u65a4\u8ba1\u8f83\u7684\u51cf\u80a5\u51cf\u80a5\u5462\u79ef\u6781\u91d1\u989d\u7edd\u671b\u7ecf\u6d4e\u57fa\u7840\u4f60\u65a4\u65a4\u8ba1\u8f83\u5c31\u5c06\u9519\u5c31\u9519\u5bb6\u5c31\u5f97\u52a0\u73ed\u4e0d\u4e39\u4e39\u54c8\u54c8\u54c8","description":null,"schedule_week":null,"start_at":"","complete_at":"","complete_description":null,"is_complete":false,"alarm_before":null,"created_by":1015,"created_at":"2026-04-15 10:09:35","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":1015,"project_id":null,"updated_at":"2026-04-15 10:09:35","set_top_at":null,"sort":1,"client":null,"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"},"createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"commentCount":{"object_id":18342,"comment":2},"attachmentRelationships":[],"scheduleCreator":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"}},"project":null,"headUsers":[{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.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":18337,"client_id":null,"schedule_title":"\u4ee3\u529e\u4e8b\u9879\u4ee3\u529e\u4e8b\u9879\u4ee3\u529e\u4e8b\u9879\uff0c\u5f00\u59cb\u65f6\u95f4\u3001\u622a\u6b62\u65f6\u95f4\u3001\u63d0\u9192\u65f6\u95f4\u3002ok.","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-13 14:30:33","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-13 14:30:33","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":18337,"comment":3},"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":18336,"client_id":2166,"schedule_title":"\u5ba2\u6237\u4e0b\u65b0\u9c9c\u8010\u4f34\u6d4b\u8bd5","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-13 13:47:29","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-13 13:47:29","set_top_at":null,"sort":1,"client":{"id":2166,"key":2166,"name":"\u6c5f\u539f\u521b\u82af\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\/\u6df1\u5733\u6c5f\u539f\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":5300,"logo":null,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},"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":18336,"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":18330,"client_id":null,"schedule_title":"\u8fd9\u4e2a\u4ed6\u53ea\u6709\u8fd9\u4e00\u7b14\u7684\u503e\u5411\uff0c\u6240\u4ee5\u5c31\u8fd9\u65f6\u5019\u4f60\u5c31\u3002","description":null,"schedule_week":null,"start_at":"","complete_at":"","complete_description":null,"is_complete":false,"alarm_before":null,"created_by":1015,"created_at":"2026-04-09 17:16:15","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":1015,"project_id":null,"updated_at":"2026-04-09 17:16:15","set_top_at":null,"sort":1,"client":null,"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"},"createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"},"department":{"id":2,"key":2,"name":"\u6280\u672f\u90e8"}},"commentCount":{"object_id":18330,"comment":2},"attachmentRelationships":[],"scheduleCreator":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"}},"project":null,"headUsers":[{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","department_id":2,"avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":21033,"schedule_id":18330,"description":"\u4eca\u5929\u53d1\u751f\u4e86\u4ec0\u4e48\uff1f\u603b\u7ed3\u4e00\u4e0b\u3002","created_at":"2026-04-10 09:45:00","created_at_display":"04-10 09:45"}],"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":18326,"client_id":3456,"schedule_title":"Cesss\u65b9\u5f0f\u65f6\u4ee3\u98ce\u5e06\u5927\u53a6","description":null,"schedule_week":null,"start_at":"","complete_at":"","complete_description":null,"is_complete":false,"alarm_before":null,"created_by":5064,"created_at":"2026-03-24 11:26:56","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":4148,"updated_at":"2026-05-09 09:47:38","set_top_at":null,"sort":1,"client":{"id":3456,"key":3456,"name":"\u5317\u4eac\u521b\u601d\u7acb\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":5295,"logo":null,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},"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":18326,"comment":3},"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":{"id":4148,"key":4148,"name":"\u65b0\u8d2d\u670d\u52a1\u5668","project_status":2,"budget":"30000","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":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":[{"id":21062,"schedule_id":18326,"description":"\u6d4b\u8bd5\u6d4b\u8bd5","created_at":"2026-05-09 09:47:08","created_at_display":"05-09 09:47"}],"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":18325,"client_id":2202,"schedule_title":"\u9500\u552e\u9636\u6bb5\uff1a\u786e\u8ba4\u65b9\u6848\n\u76ee\u6807\uff1a\u5b89\u6392\u6d4b\u8bd5\uff0c\u786e\u4fdd\u529f\u80fd\u548c\u6027\u80fd\u6ee1\u8db3\u5ba2\u6237\u9700\u6c42","description":null,"schedule_week":null,"start_at":"","complete_at":"","complete_description":null,"is_complete":false,"alarm_before":null,"created_by":5300,"created_at":"2026-03-23 13:52:04","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":5300,"project_id":4149,"updated_at":"2026-03-23 13:52:04","set_top_at":null,"sort":1,"client":{"id":2202,"key":2202,"name":"\u5317\u4eac\u5e02\u671d\u9633\u533a\u4e50\u6210\u5b66\u6821\uff08\u5317\u4eac\u5e02\u671d\u9633\u533a\u4e50\u6210\u5e7c\u513f\u56ed\uff09","sales_rep":5300,"logo":null,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":18325,"comment":2},"attachmentRelationships":[],"scheduleCreator":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"project":{"id":4149,"key":4149,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899\u65b0\u8d2d-2026","project_status":2,"budget":"20000","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":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":21027,"schedule_id":18325,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0\uff0c\u4e0a\u5468\u603b\u7ed3\uff1a\u6c9f\u901a\u6d4b\u8bd5\u5b89\u6392\u548c\u9886\u5bfc\u53cd\u9988\uff0c\u672c\u5468\u8ba1\u5212\uff1a\u7533\u8bf7\u6d4b\u8bd5\u8bbe\u5907","created_at":"2026-03-23 13:52:36","created_at_display":"03-23 13:52"}],"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":18323,"client_id":3372,"schedule_title":"\u9500\u552e\u9636\u6bb5\uff1a\u7b7e\u8ba2\u5408\u540c\n\u76ee\u6807\uff1a\u534f\u5546\u5408\u540c\u6761\u6b3e\uff0c\u63a8\u52a8\u5408\u540c\u7b7e\u8ba2","description":null,"schedule_week":null,"start_at":"","complete_at":"","complete_description":null,"is_complete":false,"alarm_before":null,"created_by":5300,"created_at":"2026-03-23 10:18:03","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":5300,"project_id":4141,"updated_at":"2026-03-23 10:18:03","set_top_at":null,"sort":1,"client":{"id":3372,"key":3372,"name":"\u6d77\u5357\u65f6\u4ee3\u5171\u8d62\u79c1\u52df\u57fa\u91d1\u7ba1\u7406\u5408\u4f19\u4f01\u4e1a\uff08\u6709\u9650\u5408\u4f19\uff09","sales_rep":5300,"logo":null,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":18323,"comment":2},"attachmentRelationships":[],"scheduleCreator":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"project":{"id":4141,"key":4141,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899+\u9510\u6377\u4ea4\u6362\u673a\u91c7\u8d2d\u9879\u76ee\u4e8c","project_status":2,"budget":"35000","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":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":20928,"schedule_id":18323,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0\uff0c\u4e0a\u5468\u603b\u7ed3\uff1a\u7ed9\u5ba2\u6237\u62a5\u4ef7\uff0c\u6c9f\u901a\u5408\u540c\u6761\u6b3e\u4fee\u6539\u5185\u5bb9\uff0c\u672c\u5468\u8ba1\u5212\uff1a\u786e\u8ba4\u5b9e\u65bd\u5730\u70b9\uff0c\u63a8\u52a8\u5408\u540c\u7b7e\u8ba2","created_at":"2026-03-23 10:19:20","created_at_display":"03-23 10:19"}],"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":2,"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:19', 216914944) RETURNING "id"
01:52:19.0780.7 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "project_status", "budget", "collected" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (4148, 4149, 4141)
01:52:18.9140.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC'
01:52:19.0290.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2166, 3456, 2202, 3372)
01:52:18.9250.6 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
01:52:18.9180.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
01:52:19.0300.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5064, 1015, 5300)
01:52:19.0770.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5064, 1015, 5300)
01:52:19.0780.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 (5064, 1015, 5300))
01:52:19.0870.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_carbon_copy_rels" WHERE "schedule_id" IN (18351, 18350, 18344, 18342, 18337, 18336, 18330, 18326, 18325, 18323)
01:52:19.0300.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5295)
01:52:19.0320.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 (5064, 1015, 5300))
01:52:18.9140.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
01:52:19.0820.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 5064, 1015)
01:52:19.0830.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 (5064, 1015, 5300))
01:52:19.0310.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5064, 1015, 5300)
01:52:19.0790.3 msyii\db\Command::querySELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=2
01:52:19.0310.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (10, 2, 1)
01:52:19.0320.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (10, 2, 1)