ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68819943172a5: POST https://beta.jinchangxiao.com/vue/schedule/list at 2025-07-24 10:24:03 am by 122.115.228.210

Performance Profiling

Total processing time: 94 ms; Peak memory: 4.969 MB. Show Profiling Timeline

总计39条数据
TimeDurationCategoryInfo
  
10:24:03.11919.3 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=9) AND ("object_id" IN (17688, 17550, 17381, 17380, 17379, 17347, 17344, 16630, 16773, 17703, 17706, 17691, 17700, 17692, 17698, 13277, 17346, 16633, 17343, 17345)) GROUP BY "object_id"
10:24:03.15315.3 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 (17688, 17550, 17381, 17380, 17379, 17347, 17344, 16630, 16773, 17703, 17706, 17691, 17700, 17692, 17698, 13277, 17346, 16633, 17343, 17345)) GROUP BY "object_id"
10:24:03.1075.3 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, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) OR ("ccr"."user_id"=1001)) AND (("s"."created_by"='1000') OR ("s"."created_by"='5250') OR ("s"."created_by"='5016') OR ("s"."created_by"='5064') OR ("s"."created_by"='5440')) 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 is_complete = true then complete_at END desc, case when is_complete = false then end_at END asc, s.created_at DESC) "c"
10:24:03.1803.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=9) AND ("visit_date"='2025-07-24')
10:24:03.1502.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_descriptions" WHERE "schedule_id" IN (17688, 17550, 17381, 17380, 17379, 17347, 17344, 16630, 16773, 17703, 17706, 17691, 17700, 17692, 17698, 13277, 17346, 16633, 17343, 17345) ORDER BY "created_at" DESC
10:24:03.0982.3 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:24:03.1422.2 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "project_status", "budget", "collected" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3814, 3822, 1111, 3805, 3804)
10:24:03.1122.0 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, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) OR ("ccr"."user_id"=1001)) AND (("s"."created_by"='1000') OR ("s"."created_by"='5250') OR ("s"."created_by"='5016') OR ("s"."created_by"='5064') OR ("s"."created_by"='5440')) 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 is_complete = true then complete_at END desc, case when is_complete = false then end_at END asc, s.created_at DESC LIMIT 20
10:24:03.1451.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_head_of_rels" WHERE "schedule_id" IN (17688, 17550, 17381, 17380, 17379, 17347, 17344, 16630, 16773, 17703, 17706, 17691, 17700, 17692, 17698, 13277, 17346, 16633, 17343, 17345)
10:24:03.0961.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:24:03.1841.8 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/schedule/list', '{"ScheduleSearch":{"created_by":["1000","5250","5016","5064","5440"],"status":"","department_id":"4","period":""},"Filter":{"name":"default","sort":"DESC"},"page":"1","web_access_token":"IB4L4uAW8bjXvE6-5qxkaUjtqmmYbCm_"}', '{"code":2000,"result":{"list":[{"id":17688,"client_id":"","schedule_title":"\u6d4b\u8bd5123","description":"","schedule_week":"","start_at":"","complete_at":"","complete_description":"","is_complete":false,"alarm_before":"","created_by":5250,"created_at":"2025-04-30 15:22:04","is_closed":false,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"","is_public":1,"system_calendar_id":"","creator":5250,"project_id":"","updated_at":"2025-05-08 09:42:20","set_top_at":"","sort":1,"client":{},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"createdBy":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","department_id":10,"avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":{"object_id":17688,"comment":2},"attachmentRelationships":[],"scheduleCreator":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}},"project":"","headUsers":[{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","department_id":10,"avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}}],"files":[{"id":33033,"object_type":32,"object_id":17688,"attachment_id":24679,"attachment":{"id":24679,"key":24679,"name":"f2b73bcc-78a2-3a58-90e8-72a918f28fc8","extension":"png","path":"\/vue\/attachment\/view\/f2b73bcc-78a2-3a58-90e8-72a918f28fc8\/\u5fae\u4fe1\u56fe\u7247_20250508002011_2.png","orig_name":"\u5fae\u4fe1\u56fe\u7247_20250508002011_2.png"}},{"id":33034,"object_type":32,"object_id":17688,"attachment_id":24680,"attachment":{"id":24680,"key":24680,"name":"85b01b8c-1193-3f95-858a-564610f90c4c","extension":"jpeg","path":"\/vue\/attachment\/view\/85b01b8c-1193-3f95-858a-564610f90c4c\/images.jpeg","orig_name":"images.jpeg"}}],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":{},"schedule_status":0,"schedule_status_display":"\u8fdb\u884c\u4e2d","complete_at_display":"","complete_at_display2":"","end_at_display":"","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":""},{"id":17550,"client_id":"","schedule_title":"\u4e00\u6240\u589e\u52a0 \u8003\u52e4\u65f6\u95f4\u9009\u62e9","description":"","schedule_week":"","start_at":"","complete_at":"","complete_description":"","is_complete":false,"alarm_before":"","created_by":5064,"created_at":"2024-12-09 17:46:49","is_closed":false,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"","is_public":1,"system_calendar_id":"","creator":5064,"project_id":"","updated_at":"2024-12-09 17:46:49","set_top_at":"","sort":1,"client":{},"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":17550,"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":"","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":{},"schedule_status":0,"schedule_status_display":"\u8fdb\u884c\u4e2d","complete_at_display":"","complete_at_display2":"","end_at_display":"","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":""},{"id":17381,"client_id":"","schedule_title":"\u4f18\u5316\u7528\u6237\u624b\u518c","description":"","schedule_week":"","start_at":"","complete_at":"","complete_description":"","is_complete":false,"alarm_before":"","created_by":5064,"created_at":"2024-10-14 13:42:58","is_closed":false,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"","is_public":1,"system_calendar_id":"","creator":5064,"project_id":"","updated_at":"2024-10-14 13:42:58","set_top_at":"","sort":1,"client":{},"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":17381,"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":"","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":{},"schedule_status":0,"schedule_status_display":"\u8fdb\u884c\u4e2d","complete_at_display":"","complete_at_display2":"","end_at_display":"","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":""},{"id":17380,"client_id":"","schedule_title":"\u8fdb\u9500\u5b58\u529f\u80fd\u8bf4\u660e\u6587\u6863","description":"","schedule_week":"","start_at":"","complete_at":"","complete_description":"","is_complete":false,"alarm_before":"","created_by":5064,"created_at":"2024-10-14 13:42:47","is_closed":false,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"","is_public":1,"system_calendar_id":"","creator":5064,"project_id":"","updated_at":"2024-10-14 13:42:47","set_top_at":"","sort":1,"client":{},"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":17380,"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":"","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":{},"schedule_status":0,"schedule_status_display":"\u8fdb\u884c\u4e2d","complete_at_display":"","complete_at_display2":"","end_at_display":"","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":""},{"id":17379,"client_id":"","schedule_title":"\u6d4b\u8bd5\uff1a\u5546\u673a\u7c7b\u578b\u5927\u6a21\u5757","description":"","schedule_week":"","start_at":"","complete_at":"","complete_description":"","is_complete":false,"alarm_before":"","created_by":5064,"created_at":"2024-10-14 13:42:25","is_closed":false,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"","is_public":1,"system_calendar_id":"","creator":5064,"project_id":"","updated_at":"2024-10-14 13:42:25","set_top_at":"","sort":1,"client":{},"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":17379,"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":"","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":{},"schedule_status":0,"schedule_status_display":"\u8fdb\u884c\u4e2d","complete_at_display":"","complete_at_display2":"","end_at_display":"","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":""},{"id":17347,"client_id":"","schedule_title":"\u4ea7\u54c1\u7ecf\u7406\u89c6\u9891\u8bfe\u7a0b\u5b66\u4e60\u8ba1\u5212","description":"","schedule_week":"","start_at":"","complete_at":"","complete_description":"","is_complete":false,"alarm_before":"","created_by":5064,"created_at":"2024-09-14 11:01:08","is_closed":false,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"","is_public":1,"system_calendar_id":"","creator":5064,"project_id":"","updated_at":"2024-09-14 11:01:08","set_top_at":"","sort":1,"client":{},"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":17347,"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":"","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":{},"schedule_status":0,"schedule_status_display":"\u8fdb\u884c\u4e2d","complete_at_display":"","complete_at_display2":"","end_at_display":"","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":""},{"id":17344,"client_id":"","schedule_title":"\u6574\u7406\u8fdb\u9500\u5b58\u76f8\u5173\u8be6\u60c5\u9875\u4fe1\u606f","description":"","schedule_week":"","start_at":"2024-09-12 09:30:00","complete_at":"","complete_description":"","is_complete":false,"alarm_before":"","created_by":5064,"created_at":"2024-09-11 18:07:17","is_closed":false,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"","is_public":1,"system_calendar_id":"","creator":5064,"project_id":"","updated_at":"2024-09-11 18:07:17","set_top_at":"","sort":1,"client":{},"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":17344,"comment":2},"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":"","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":9522,"schedule_id":17344,"description":"\u9636\u6bb5\u6027\u7684\u6574\u7406\u5b8c\u6210","created_at":"2024-09-14 10:27:28","created_at_display":"2024-09-14 10:27"}],"unreadComments":{},"schedule_status":0,"schedule_status_display":"\u8fdb\u884c\u4e2d","complete_at_display":"","complete_at_display2":"","end_at_display":"","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":""},{"id":16630,"client_id":"","schedule_title":"\u68b3\u7406\u7edf\u8ba1\u4f4d\u7f6e\u7684\u6570\u636e\u5c55\u73b0\u5f62\u5f0f\uff0c\u5b8c\u5584\u6570\u636e\u5c55\u793a\u4e0d\u591f\u76f4\u89c2\u7684\u95ee\u9898","description":"","schedule_week":"","start_at":"","complete_at":"","complete_description":"","is_complete":false,"alarm_before":"","created_by":5064,"created_at":"2024-03-14 10:33:51","is_closed":false,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"","is_public":1,"system_calendar_id":"","creator":5064,"project_id":"","updated_at":"2024-03-14 10:33:51","set_top_at":"","sort":1,"client":{},"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":16630,"comment":5},"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":"","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":{},"schedule_status":0,"schedule_status_display":"\u8fdb\u884c\u4e2d","complete_at_display":"","complete_at_display2":"","end_at_display":"","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":""},{"id":16773,"client_id":"","schedule_title":"\u6d4b\u8bd5","description":"","schedule_week":"","start_at":"","complete_at":"","complete_description":"","is_complete":false,"alarm_before":"","created_by":5016,"created_at":"2024-04-09 09:31:01","is_closed":false,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"2024-04-09 18:00:00","is_public":1,"system_calendar_id":"","creator":5016,"project_id":"","updated_at":"2024-04-09 09:31:01","set_top_at":"","sort":2,"client":{},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":{"object_id":16773,"comment":7},"attachmentRelationships":[],"scheduleCreator":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}},"project":"","headUsers":[{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":12411,"schedule_id":16773,"description":"\u563f","created_at":"2025-05-14 13:59:46","created_at_display":"05-14 13:59"},{"id":12410,"schedule_id":16773,"description":"\u554a","created_at":"2025-05-14 13:58:44","created_at_display":"05-14 13:58"},{"id":12409,"schedule_id":16773,"description":"\u963f\u62c9\u4f2f","created_at":"2025-05-14 13:54:49","created_at_display":"05-14 13:54"},{"id":12408,"schedule_id":16773,"description":"\u6d4b\u6d4b","created_at":"2025-05-14 13:53:22","created_at_display":"05-14 13:53"},{"id":12407,"schedule_id":16773,"description":"\u6d4b","created_at":"2025-05-14 13:50:39","created_at_display":"05-14 13:50"}],"unreadComments":{},"schedule_status":2,"schedule_status_display":"\u5df2\u903e\u671f","complete_at_display":"","complete_at_display2":"","end_at_display":"2024-04-09 18:00","end_at_display2":"","is_self":false,"is_overdue":true,"alarm_before_display":"\u65e0","can_update":true,"can_delete":true,"can_report":false,"unread":0,"bgcolor":"#e5000a","can_create_project":true,"start_at_display":""},{"id":17703,"client_id":2815,"schedule_title":"\u53d1\u53d1\u53d1","description":"","schedule_week":"","start_at":"2025-07-11 12:00:00","complete_at":"","complete_description":"","is_complete":false,"alarm_before":"00:30:00","created_by":1000,"created_at":"2025-07-11 12:00:36","is_closed":false,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"2025-07-11 18:00:00","is_public":1,"system_calendar_id":"","creator":1000,"project_id":3814,"updated_at":"2025-07-11 12:00:45","set_top_at":"","sort":2,"client":{"id":2815,"key":2815,"name":"\u4e2d\u56fd\u9ec4\u91d1","sales_rep":1004,"logo":"","salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"}},"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\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":{"object_id":17703,"comment":2},"attachmentRelationships":[],"scheduleCreator":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}},"project":{"id":3814,"key":3814,"name":"\u51e0\u8282\u8bfe","project_status":1,"budget":"0","collected":"0","projectStatus":{"id":1,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},"project_status_display":"\u9690\u6027\u9700\u6c42","bgcolor":"#ffc000"},"headUsers":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}}],"files":[],"scheduleCarbonCopyRels":[{"id":956,"schedule_id":17703,"user_id":1017,"user":{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","sex":"M","avatar":{"id":8,"user_id":1017,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e538f0fe-48a7-33da-a512-b252266c9e91.jpg"}}},{"id":957,"schedule_id":17703,"user_id":5250,"user":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}}}],"scheduleDescriptions":[],"unreadComments":{},"schedule_status":2,"schedule_status_display":"\u5df2\u903e\u671f","complete_at_display":"","complete_at_display2":"","end_at_display":"07-11 18:00","end_at_display2":"","is_self":false,"is_overdue":true,"alarm_before_display":"\u63d0\u524d30\u5206\u949f","can_update":true,"can_delete":true,"can_report":false,"unread":0,"bgcolor":"#e5000a","can_create_project":true,"start_at_display":""},{"id":17706,"client_id":2815,"schedule_title":"\u56de\u590d\u4f60\u5427","description":"","schedule_week":"","start_at":"2025-07-16 16:41:00","complete_at":"","complete_description":"","is_complete":false,"alarm_before":"00:05:00","created_by":1000,"created_at":"2025-07-16 16:42:13","is_closed":false,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"2025-07-16 18:00:00","is_public":1,"system_calendar_id":"","creator":1000,"project_id":3822,"updated_at":"2025-07-16 16:42:13","set_top_at":"","sort":2,"client":{"id":2815,"key":2815,"name":"\u4e2d\u56fd\u9ec4\u91d1","sales_rep":1004,"logo":"","salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"}},"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\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":{"object_id":17706,"comment":1},"attachmentRelationships":[{"id":33308,"object_type":9,"object_id":17706,"attachment_id":24897,"attachment":{"id":24897,"key":24897,"name":"05a15505-25a5-3659-a955-2ec1dfdd79e2","extension":"png","path":"\/vue\/attachment\/view\/05a15505-25a5-3659-a955-2ec1dfdd79e2\/20250716164211.png","orig_name":"20250716164211.png"}}],"scheduleCreator":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}},"project":{"id":3822,"key":3822,"name":"\u9ad8\u5fb7\u5eb7\u8f6f","project_status":2,"budget":"5215","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":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}}],"files":[],"scheduleCarbonCopyRels":[{"id":962,"schedule_id":17706,"user_id":1017,"user":{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","sex":"M","avatar":{"id":8,"user_id":1017,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e538f0fe-48a7-33da-a512-b252266c9e91.jpg"}}},{"id":963,"schedule_id":17706,"user_id":5250,"user":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}}}],"scheduleDescriptions":[],"unreadComments":{},"schedule_status":2,"schedule_status_display":"\u5df2\u903e\u671f","complete_at_display":"","complete_at_display2":"","end_at_display":"07-16 (\u4e0a\u5468\u4e09) 18:00","end_at_display2":"","is_self":false,"is_overdue":true,"alarm_before_display":"\u63d0\u524d5\u5206\u949f","can_update":true,"can_delete":true,"can_report":false,"unread":0,"bgcolor":"#e5000a","can_create_project":true,"start_at_display":""},{"id":17691,"client_id":982,"schedule_title":"bdnj","description":"","schedule_week":"","start_at":"2025-05-09 10:31:00","complete_at":"2025-07-10 10:13:02","complete_description":"","is_complete":true,"alarm_before":"00:05:00","created_by":1000,"created_at":"2025-05-09 10:32:20","is_closed":true,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"2025-05-09 18:00:00","is_public":1,"system_calendar_id":"","creator":1000,"project_id":1111,"updated_at":"2025-05-09 10:32:20","set_top_at":"","sort":3,"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","sales_rep":1001,"logo":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"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\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":{"object_id":17691,"comment":10},"attachmentRelationships":[{"id":33043,"object_type":9,"object_id":17691,"attachment_id":24687,"attachment":{"id":24687,"key":24687,"name":"0700a761-e6d3-3c62-bb1e-d8e041897228","extension":"jpg","path":"\/vue\/attachment\/view\/0700a761-e6d3-3c62-bb1e-d8e041897228\/Screenshot_20250508_100019_com.jinchangxiao.bms.jpg","orig_name":"Screenshot_20250508_100019_com.jinchangxiao.bms.jpg"}}],"scheduleCreator":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}},"project":{"id":1111,"key":1111,"name":"\u4ebf\u8054\u89c6\u9891\u4f1a\u8bae\u7edf\u4e00\u901a\u8baf","project_status":3,"budget":"2486850","collected":"2486850","projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210","bgcolor":"#6200fe"},"headUsers":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}}],"files":[],"scheduleCarbonCopyRels":[{"id":914,"schedule_id":17691,"user_id":1017,"user":{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","sex":"M","avatar":{"id":8,"user_id":1017,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e538f0fe-48a7-33da-a512-b252266c9e91.jpg"}}},{"id":915,"schedule_id":17691,"user_id":5250,"user":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}}}],"scheduleDescriptions":[{"id":12406,"schedule_id":17691,"description":"mmml","created_at":"2025-05-09 10:38:22","created_at_display":"05-09 10:38"},{"id":12405,"schedule_id":17691,"description":"hjjjj","created_at":"2025-05-09 10:36:31","created_at_display":"05-09 10:36"},{"id":12404,"schedule_id":17691,"description":"hjj","created_at":"2025-05-09 10:36:23","created_at_display":"05-09 10:36"},{"id":12403,"schedule_id":17691,"description":"hhj","created_at":"2025-05-09 10:35:53","created_at_display":"05-09 10:35"}],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"07-10 10:13","complete_at_display2":"","end_at_display":"05-09 18:00","end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u63d0\u524d5\u5206\u949f","can_update":true,"can_delete":true,"can_report":false,"unread":0,"bgcolor":"#53cd02","can_create_project":true,"start_at_display":""},{"id":17700,"client_id":2815,"schedule_title":"nfnfb","description":"","schedule_week":"","start_at":"","complete_at":"2025-07-04 14:15:42","complete_description":"","is_complete":true,"alarm_before":"","created_by":1000,"created_at":"2025-07-04 14:15:30","is_closed":true,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"","is_public":1,"system_calendar_id":"","creator":1000,"project_id":3805,"updated_at":"2025-07-04 14:15:30","set_top_at":"","sort":3,"client":{"id":2815,"key":2815,"name":"\u4e2d\u56fd\u9ec4\u91d1","sales_rep":1004,"logo":"","salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"}},"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\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":{"object_id":17700,"comment":6},"attachmentRelationships":[],"scheduleCreator":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}},"project":{"id":3805,"key":3805,"name":"\u54c8\u597d\u54c8\u7535\u8bdd","project_status":1,"budget":"9988","collected":"0","projectStatus":{"id":1,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},"project_status_display":"\u9690\u6027\u9700\u6c42","bgcolor":"#ffc000"},"headUsers":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}}],"files":[],"scheduleCarbonCopyRels":[{"id":944,"schedule_id":17700,"user_id":1017,"user":{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","sex":"M","avatar":{"id":8,"user_id":1017,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e538f0fe-48a7-33da-a512-b252266c9e91.jpg"}}},{"id":945,"schedule_id":17700,"user_id":5250,"user":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}}}],"scheduleDescriptions":[{"id":12428,"schedule_id":17700,"description":"hhjj","created_at":"2025-07-04 14:15:42","created_at_display":"07-04 14:15"},{"id":12427,"schedule_id":17700,"description":"hfhc","created_at":"2025-07-04 14:15:37","created_at_display":"07-04 14:15"}],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"07-04 14:15","complete_at_display2":"","end_at_display":"","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":"#53cd02","can_create_project":true,"start_at_display":""},{"id":17692,"client_id":3056,"schedule_title":"\u5065\u5065\u5eb7\u5eb7","description":"","schedule_week":"","start_at":"2025-05-12 10:07:00","complete_at":"2025-07-03 11:38:36","complete_description":"","is_complete":true,"alarm_before":"00:05:00","created_by":1000,"created_at":"2025-05-12 10:07:36","is_closed":true,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"2025-05-12 18:00:00","is_public":1,"system_calendar_id":"","creator":1000,"project_id":3804,"updated_at":"2025-05-12 10:07:36","set_top_at":"","sort":3,"client":{"id":3056,"key":3056,"name":"\u4e2d\u56fd\u822a\u5929","sales_rep":1013,"logo":"","salesRep":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210"}},"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\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":{"object_id":17692,"comment":4},"attachmentRelationships":[],"scheduleCreator":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}},"project":{"id":3804,"key":3804,"name":"\u54c8\u62c9\u54c8\u5566","project_status":3,"budget":"0","collected":"0","projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210","bgcolor":"#6200fe"},"headUsers":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}}],"files":[],"scheduleCarbonCopyRels":[{"id":916,"schedule_id":17692,"user_id":1017,"user":{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","sex":"M","avatar":{"id":8,"user_id":1017,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e538f0fe-48a7-33da-a512-b252266c9e91.jpg"}}},{"id":917,"schedule_id":17692,"user_id":5250,"user":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}}}],"scheduleDescriptions":[],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"07-03 11:38","complete_at_display2":"","end_at_display":"05-12 18:00","end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u63d0\u524d5\u5206\u949f","can_update":true,"can_delete":true,"can_report":false,"unread":0,"bgcolor":"#53cd02","can_create_project":true,"start_at_display":""},{"id":17698,"client_id":2815,"schedule_title":"\u624d\u80fd\u5065\u5eb7","description":"","schedule_week":"","start_at":"2025-06-21 19:32:00","complete_at":"2025-06-21 19:43:36","complete_description":"","is_complete":true,"alarm_before":"00:05:00","created_by":1000,"created_at":"2025-06-21 19:33:36","is_closed":true,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"2025-06-22 18:00:00","is_public":1,"system_calendar_id":"","creator":1000,"project_id":3805,"updated_at":"2025-06-25 10:24:51","set_top_at":"","sort":3,"client":{"id":2815,"key":2815,"name":"\u4e2d\u56fd\u9ec4\u91d1","sales_rep":1004,"logo":"","salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"}},"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\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":{"object_id":17698,"comment":16},"attachmentRelationships":[{"id":33148,"object_type":9,"object_id":17698,"attachment_id":24773,"attachment":{"id":24773,"key":24773,"name":"1d848199-a41a-39e3-8f86-04b6654e6158","extension":"png","path":"\/vue\/attachment\/view\/1d848199-a41a-39e3-8f86-04b6654e6158\/20250625102447.png","orig_name":"20250625102447.png"}}],"scheduleCreator":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}},"project":{"id":3805,"key":3805,"name":"\u54c8\u597d\u54c8\u7535\u8bdd","project_status":1,"budget":"9988","collected":"0","projectStatus":{"id":1,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},"project_status_display":"\u9690\u6027\u9700\u6c42","bgcolor":"#ffc000"},"headUsers":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/aebf8dd5-5fe2-3ead-a020-c095fe4101e4.png"}}],"files":[],"scheduleCarbonCopyRels":[{"id":936,"schedule_id":17698,"user_id":1017,"user":{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","sex":"M","avatar":{"id":8,"user_id":1017,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e538f0fe-48a7-33da-a512-b252266c9e91.jpg"}}},{"id":937,"schedule_id":17698,"user_id":5250,"user":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}}}],"scheduleDescriptions":[{"id":12421,"schedule_id":17698,"description":"\u5a1c\u5a1c\u5bb6","created_at":"2025-06-21 19:42:48","created_at_display":"06-21 19:42"},{"id":12420,"schedule_id":17698,"description":"\u4e0d\u53d8","created_at":"2025-06-21 19:42:34","created_at_display":"06-21 19:42"}],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"06-21 19:43","complete_at_display2":"","end_at_display":"06-22 18:00","end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u63d0\u524d5\u5206\u949f","can_update":true,"can_delete":true,"can_report":false,"unread":0,"bgcolor":"#53cd02","can_create_project":true,"start_at_display":""},{"id":13277,"client_id":"","schedule_title":"\u6d4b\u8bd5","description":"","schedule_week":"","start_at":"2022-07-28 12:15:00","complete_at":"2025-04-10 11:58:42","complete_description":"","is_complete":true,"alarm_before":"00:05:00","created_by":5016,"created_at":"2022-07-28 12:07:32","is_closed":true,"is_remind":true,"time_type":"","schedule_end":"","repeat_id":"","end_at":"","is_public":1,"system_calendar_id":"","creator":5016,"project_id":"","updated_at":"2022-07-28 12:07:32","set_top_at":"","sort":3,"client":{},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"createdBy":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":{"object_id":13277,"comment":14},"attachmentRelationships":[],"scheduleCreator":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}},"project":"","headUsers":[{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","department_id":10,"avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":9516,"schedule_id":13277,"description":"\u6d4b\u8bd5","created_at":"2024-09-09 14:48:15","created_at_display":"2024-09-09 14:48"}],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"04-10 11:58","complete_at_display2":"","end_at_display":"","end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u63d0\u524d5\u5206\u949f","can_update":true,"can_delete":true,"can_report":false,"unread":0,"bgcolor":"#53cd02","can_create_project":true,"start_at_display":""},{"id":17346,"client_id":"","schedule_title":"\u6d4b\u8bd5\uff1a\n\u516b\u3001\u5ba1\u6279\u7ba1\u7406>\u5ba1\u6279\u4eba\u6216\u8005\u6284\u9001\u4eba\u5176\u4e2d\u4e00\u9879\u6ca1\u6709\u9884\u8bbe\uff0c\u65b0\u5efa\/\u7f16\u8f91\u65f6\uff0c\u53ef\u4ee5\u81ea\u5b9a\u4e49\u4fee\u6539\uff0c\u8bb0\u4f4f\u4e0a\u4e00\u6b21\u9009\u62e9\uff08app\uff09\n\u4e5d\u3001\u6536\u4ed8\u6b3e\u7edf\u8ba1>\u5e94\u6536\u6b3e\u7edf\u8ba1>\u5ba2\u6237\u540d\u79f0\u3001\u5546\u673a\u540d\u79f0\u589e\u52a0\u8be6\u60c5\u9875\u67e5\u770b\u000b\u6536\u4ed8\u6b3e\u7edf\u8ba1>\u5df2\u6536\u6b3e\u7edf\u8ba1>\u5ba2\u6237\u540d\u79f0\u3001\u5546\u673a\u540d\u79f0\u589e\u52a0\u8be6\u60c5\u9875\u67e5\u770b\u000b\u6536\u4ed8\u6b3e\u7edf\u8ba1>\u5e94\u4ed8\u6b3e\u7edf\u8ba1>\u4f9b\u5e94\u5546\u3001\u91c7\u8d2d\u5408\u540c\u7f16\u53f7\u589e\u52a0\u8be6\u60c5\u9875\u67e5\u770b\u000b\u6536\u4ed8\u6b3e\u7edf\u8ba1>\u5e94\u4ed8\u6b3e\u7edf\u8ba1>\u4f9b\u5e94\u5546\u3001\u91c7\u8d2d\u5408\u540c\u7f16\u53f7\u589e\u52a0\u8be6\u60c5\u9875\u67e5\u770b\u000b\u91c7\u8d2d\u6570\u636e\u7edf\u8ba1>\u5e94\u4ed8\u6b3e\u7edf\u8ba1>\u4f9b\u5e94\u5546\u3001\u91c7\u8d2d\u5408\u540c\u7f16\u53f7\u589e\u52a0\u8be6\u60c5\u9875\u67e5\u770b\u000b\u91c7\u8d2d\u6570\u636e\u7edf\u8ba1>\u5e94\u4ed8\u6b3e\u7edf\u8ba1>\u4f9b\u5e94\u5546\u3001\u91c7\u8d2d\u5408\u540c\u7f16\u53f7\u589e\u52a0\u8be6\u60c5\u9875\u67e5\u770b\n\u5341\u3001\u9500\u552e\u6570\u636e\u7edf\u8ba1>\u5546\u673a\u6570\u636e\u5206\u6790>\u5546\u673a\u7efc\u5408\u5206\u6790 \u521b\u5efa\u65f6\u95f4\u9ed8\u8ba4\u9009\u4e2d\u5168\u90e8","description":"","schedule_week":"","start_at":"","complete_at":"2024-09-23 11:57:45","complete_description":"","is_complete":true,"alarm_before":"","created_by":5064,"created_at":"2024-09-14 10:59:39","is_closed":true,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"","is_public":1,"system_calendar_id":"","creator":5064,"project_id":"","updated_at":"2024-09-14 10:59:39","set_top_at":"","sort":3,"client":{},"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":17346,"comment":2},"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":"","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":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2024-09-23 11:57","complete_at_display2":"","end_at_display":"","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":"#53cd02","can_create_project":true,"start_at_display":""},{"id":16633,"client_id":"","schedule_title":"\u5ba1\u6279\u7ba1\u7406\u589e\u52a0\u91d1\u989d","description":"","schedule_week":"","start_at":"","complete_at":"2024-09-14 10:55:35","complete_description":"","is_complete":true,"alarm_before":"","created_by":5064,"created_at":"2024-03-15 09:04:37","is_closed":true,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"","is_public":1,"system_calendar_id":"","creator":5064,"project_id":"","updated_at":"2024-03-15 09:04:37","set_top_at":"","sort":3,"client":{},"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":16633,"comment":6},"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":"","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":9524,"schedule_id":16633,"description":"\u5df2\u5b8c\u6210","created_at":"2024-09-14 10:55:35","created_at_display":"2024-09-14 10:55"}],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2024-09-14 10:55","complete_at_display2":"","end_at_display":"","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":"#53cd02","can_create_project":true,"start_at_display":""},{"id":17343,"client_id":"","schedule_title":"\u548c\u4e0a\u6d77\u5ba2\u6237\u786e\u8ba4\u7edf\u8ba1\u95ee\u9898","description":"","schedule_week":"","start_at":"2024-09-12 09:30:00","complete_at":"2024-09-14 10:55:19","complete_description":"","is_complete":true,"alarm_before":"","created_by":5064,"created_at":"2024-09-11 18:06:32","is_closed":true,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"","is_public":1,"system_calendar_id":"","creator":5064,"project_id":"","updated_at":"2024-09-11 18:06:32","set_top_at":"","sort":3,"client":{},"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":17343,"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":"","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":9521,"schedule_id":17343,"description":"\u5df2\u786e\u8ba4 \u4e0a\u7ebf","created_at":"2024-09-14 10:27:10","created_at_display":"2024-09-14 10:27"}],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2024-09-14 10:55","complete_at_display2":"","end_at_display":"","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":"#53cd02","can_create_project":true,"start_at_display":""},{"id":17345,"client_id":"","schedule_title":"\u6d4b\u8bd5","description":"","schedule_week":"","start_at":"2024-09-12 10:00:00","complete_at":"2024-09-14 10:55:13","complete_description":"","is_complete":true,"alarm_before":"","created_by":5064,"created_at":"2024-09-11 18:07:47","is_closed":true,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"","is_public":1,"system_calendar_id":"","creator":5064,"project_id":"","updated_at":"2024-09-11 18:07:47","set_top_at":"","sort":3,"client":{},"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":17345,"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":"","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":9523,"schedule_id":17345,"description":"\u6d4b\u8bd5\u5b8c\u6210","created_at":"2024-09-14 10:27:38","created_at_display":"2024-09-14 10:27"}],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2024-09-14 10:55","complete_at_display2":"","end_at_display":"","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":"#53cd02","can_create_project":true,"start_at_display":""}],"thisUser":{"id":5440,"name":"\u5f20\u6210","sex":"M","avatar":{}},"countStatus0":8,"countStatus1":186,"countStatus2":3,"countStatusTop":0,"can_create":true,"pagenation":{"totalcount":197,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-24 10:24:03') RETURNING "id"
10:24:03.1401.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24687, 24773, 24897)
10:24:03.1711.5 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, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) OR ("ccr"."user_id"=1001)) AND (("s"."created_by"='1000') OR ("s"."created_by"='5250') OR ("s"."created_by"='5016') OR ("s"."created_by"='5064') OR ("s"."created_by"='5440')) AND ((("s"."is_public"=1) AND ("s"."created_by" != 1001)) OR ("s"."created_by"=1001) OR ("ccr"."user_id"=1001)) AND (set_top_at is null and is_complete = false and (end_at > now() or end_at is null)) GROUP BY "s"."id") "c"
10:24:03.1731.4 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, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) OR ("ccr"."user_id"=1001)) AND (("s"."created_by"='1000') OR ("s"."created_by"='5250') OR ("s"."created_by"='5016') OR ("s"."created_by"='5064') OR ("s"."created_by"='5440')) AND ((("s"."is_public"=1) AND ("s"."created_by" != 1001)) OR ("s"."created_by"=1001) OR ("ccr"."user_id"=1001)) AND (set_top_at is null and is_complete = true) GROUP BY "s"."id") "c"
10:24:03.1381.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id" IN (17688, 17550, 17381, 17380, 17379, 17347, 17344, 16630, 16773, 17703, 17706, 17691, 17700, 17692, 17698, 13277, 17346, 16633, 17343, 17345))
10:24:03.1751.3 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, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) OR ("ccr"."user_id"=1001)) AND (("s"."created_by"='1000') OR ("s"."created_by"='5250') OR ("s"."created_by"='5016') OR ("s"."created_by"='5064') OR ("s"."created_by"='5440')) AND ((("s"."is_public"=1) AND ("s"."created_by" != 1001)) OR ("s"."created_by"=1001) OR ("ccr"."user_id"=1001)) AND (set_top_at is null and is_complete = false and end_at <= now()) GROUP BY "s"."id") "c"
10:24:03.1011.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:24:03.1481.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=32) AND ("object_id" IN (17688, 17550, 17381, 17380, 17379, 17347, 17344, 16630, 16773, 17703, 17706, 17691, 17700, 17692, 17698, 13277, 17346, 16633, 17343, 17345))
10:24:03.1761.1 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, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) OR ("ccr"."user_id"=1001)) AND (("s"."created_by"='1000') OR ("s"."created_by"='5250') OR ("s"."created_by"='5016') OR ("s"."created_by"='5064') OR ("s"."created_by"='5440')) AND ((("s"."is_public"=1) AND ("s"."created_by" != 1001)) OR ("s"."created_by"=1001) OR ("ccr"."user_id"=1001)) AND (set_top_at is not null) GROUP BY "s"."id") "c"
10:24:03.1150.9 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2815, 982, 3056)
10:24:03.1060.8 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
10:24:03.1830.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=11, "last_visit_at"='now()' WHERE "id"=49855
10:24:03.1180.5 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5250, 5016, 5064, 1000))
10:24:03.1160.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5250, 5064, 5016, 1000)
10:24:03.1500.3 msyii\db\Command::querySELECT "id", "id" AS "key", CASE WHEN user_status = '-1' THEN name || '(已离职)' ELSE name END AS name, "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1017, 5250)
10:24:03.1440.3 msyii\db\Command::querySELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id" IN (3, 1, 2)
10:24:03.1170.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10
10:24:03.1490.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_carbon_copy_rels" WHERE "schedule_id" IN (17688, 17550, 17381, 17380, 17379, 17347, 17344, 16630, 16773, 17703, 17706, 17691, 17700, 17692, 17698, 13277, 17346, 16633, 17343, 17345)
10:24:03.1420.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5250, 5016, 5064, 1000))
10:24:03.1170.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5250, 5064, 5016, 1000)
10:24:03.1160.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1004, 1013, 1001)
10:24:03.1780.2 msyii\db\Command::querySELECT "id", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN ('1000', '5250', '5016', '5064', '5440')
10:24:03.1410.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5250, 5064, 5016, 1000)
10:24:03.1470.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5016, 5064, 5250, 1000)
10:24:03.1470.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5250, 5016, 5064, 1000))
10:24:03.1500.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5250, 1017))
10:24:03.1780.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5440)
10:24:03.1490.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24679, 24680)
10:24:03.1180.1 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10