Performance Profiling

Total processing time: 158 ms; Peak memory: 4.887 MB. Show Profiling Timeline

总计34条数据
TimeDurationCategoryInfo
  
10:22:03.94731.3 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=9) AND ("object_id" IN (7957, 7946, 7932, 7907, 7868, 7825, 7805, 7780, 7778, 7776, 7735, 7736, 7619, 7613, 7129, 7115, 6891, 6881, 6883, 6882)) GROUP BY "object_id"
10:22:03.99830.4 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 (7957, 7946, 7932, 7907, 7868, 7825, 7805, 7780, 7778, 7776, 7735, 7736, 7619, 7613, 7129, 7115, 6891, 6881, 6883, 6882)) GROUP BY "object_id"
10:22:04.0466.9 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:22:03.9324.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"='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 is_complete = true then complete_at END desc, case when is_complete = false then end_at END asc, s.created_at DESC) "c"
10:22:03.9854.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_head_of_rels" WHERE "schedule_id" IN (7957, 7946, 7932, 7907, 7868, 7825, 7805, 7780, 7778, 7776, 7735, 7736, 7619, 7613, 7129, 7115, 6891, 6881, 6883, 6882)
10:22:03.9943.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_descriptions" WHERE "schedule_id" IN (7957, 7946, 7932, 7907, 7868, 7825, 7805, 7780, 7778, 7776, 7735, 7736, 7619, 7613, 7129, 7115, 6891, 6881, 6883, 6882) ORDER BY "created_at" DESC
10:22:04.0543.6 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":["1001"],"status":"","department_id":"4","period":""},"Filter":{"name":"default","sort":"DESC"},"page":"4","web_access_token":"IB4L4uAW8bjXvE6-5qxkaUjtqmmYbCm_"}', '{"code":2000,"result":{"list":[{"id":7957,"client_id":"","schedule_title":"\u7ea6\u89c1\uff1a\n\u6234\u54e5\nRobin\nFiona","description":"","schedule_week":1556467200,"start_at":"","complete_at":"2019-05-05 23:59:59","complete_description":"","is_complete":true,"alarm_before":"","created_by":1001,"created_at":"2019-04-26 14:45:38","is_closed":true,"is_remind":false,"time_type":1,"schedule_end":1557071999,"repeat_id":"","end_at":"2019-05-05 23:59:59","is_public":0,"system_calendar_id":"","creator":1001,"project_id":"","updated_at":"2019-04-26 14:45:38","set_top_at":"","sort":3,"client":{},"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\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"attachmentRelationships":[],"scheduleCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"project":"","headUsers":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2019-05-05 23:59","complete_at_display2":"","end_at_display":"2019-05-05 23:59","end_at_display2":"","is_self":true,"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":7946,"client_id":"","schedule_title":"\u5468\u4e00\u4f8b\u4f1a\u8bae\u9898\uff1a1.review \u5f85\u529e\u4e8b\u9879\u30022.\u73b0\u6709\u5ba2\u6237mapping\u4ea7\u54c1\u30023.review \u73b0\u6709\u660e\u786e\u9700\u6c42\u30024.review\u8425\u6536\u6b3e\u3002","description":"","schedule_week":1556467200,"start_at":"","complete_at":"2019-05-05 23:59:59","complete_description":"","is_complete":true,"alarm_before":"","created_by":1001,"created_at":"2019-04-23 09:05:03","is_closed":true,"is_remind":false,"time_type":1,"schedule_end":1557071999,"repeat_id":"","end_at":"2019-05-05 23:59:59","is_public":0,"system_calendar_id":"","creator":1001,"project_id":"","updated_at":"2019-04-23 09:05:03","set_top_at":"","sort":3,"client":{},"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\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"attachmentRelationships":[],"scheduleCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"project":"","headUsers":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2019-05-05 23:59","complete_at_display2":"","end_at_display":"2019-05-05 23:59","end_at_display2":"","is_self":true,"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":7932,"client_id":"","schedule_title":"Review \u5382\u5bb6\u63a5\u5355\u70b9\u6570\u3002","description":"","schedule_week":1555862400,"start_at":"","complete_at":"2019-04-28 23:59:59","complete_description":"3\u52a020","is_complete":true,"alarm_before":"","created_by":1001,"created_at":"2019-04-20 13:16:45","is_closed":true,"is_remind":false,"time_type":1,"schedule_end":1556467199,"repeat_id":"","end_at":"2019-04-28 23:59:59","is_public":0,"system_calendar_id":"","creator":1001,"project_id":"","updated_at":"2019-04-20 13:16:45","set_top_at":"","sort":3,"client":{},"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\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"attachmentRelationships":[],"scheduleCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"project":"","headUsers":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":1999,"schedule_id":7932,"description":"3\u52a020","created_at":"2019-04-28 23:59:59","created_at_display":"2019-04-28 23:59"}],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2019-04-28 23:59","complete_at_display2":"","end_at_display":"2019-04-28 23:59","end_at_display2":"","is_self":true,"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":7907,"client_id":"","schedule_title":"1.\u80fd\u529b\u9677\u9631\uff0c\u96c6\u4f53\u5206\u4eab\u3002\n2.\u516c\u53f8\u4ecb\u7ecd\u6f14\u7ec3\u3002","description":"","schedule_week":1555257600,"start_at":"","complete_at":"2019-04-21 23:59:59","complete_description":"","is_complete":true,"alarm_before":"","created_by":1001,"created_at":"2019-04-13 10:12:31","is_closed":true,"is_remind":false,"time_type":1,"schedule_end":1555862399,"repeat_id":"","end_at":"2019-04-21 23:59:59","is_public":0,"system_calendar_id":"","creator":1001,"project_id":"","updated_at":"2019-04-13 10:12:31","set_top_at":"","sort":3,"client":{},"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\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"attachmentRelationships":[],"scheduleCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"project":"","headUsers":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2019-04-21 23:59","complete_at_display2":"","end_at_display":"2019-04-21 23:59","end_at_display2":"","is_self":true,"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":7868,"client_id":"","schedule_title":"\u98de\u673a\u503c\u673a","description":"","schedule_week":1554652800,"start_at":"2019-04-10 06:00:00","complete_at":"2019-04-14 23:59:59","complete_description":"","is_complete":true,"alarm_before":"00:05:00","created_by":1001,"created_at":"2019-04-04 15:41:39","is_closed":true,"is_remind":true,"time_type":1,"schedule_end":1555257599,"repeat_id":"","end_at":"2019-04-14 23:59:59","is_public":0,"system_calendar_id":"","creator":1001,"project_id":"","updated_at":"2019-04-04 15:41:39","set_top_at":"","sort":3,"client":{},"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\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"attachmentRelationships":[],"scheduleCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"project":"","headUsers":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2019-04-14 23:59","complete_at_display2":"","end_at_display":"2019-04-14 23:59","end_at_display2":"","is_self":true,"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":7825,"client_id":"","schedule_title":"review:\r\n1.\u8d75\u6657\u7131\u7684\u57f9\u8bad\u8fdb\u5c55\u3002\r\n2.\u5cfb\u8fb0\u4e0eh3c\u592e\u4f01\u8001\u677f\u5bf9\u63a5\u8ba1\u5212\u3002\n3.\u8054\u60f3\u5b58\u50a8\u8c08\u6bd4\u5229","description":"","schedule_week":1554048000,"start_at":"","complete_at":"2019-04-07 23:59:59","complete_description":"1.\u57f9\u8bad\uff0c\u5468\u4e00\u4e0b\u5348\u4e24\u70b9\u3002\n2.\u8c08\u7684\u5f88\u597d\u3002\n3.20%\u53cd\u5229\uff0c\u79ef\u6781\u8ba4\u53ef\u3002","is_complete":true,"alarm_before":"","created_by":1001,"created_at":"2019-03-25 10:48:07","is_closed":true,"is_remind":false,"time_type":1,"schedule_end":1554652799,"repeat_id":"","end_at":"2019-04-07 23:59:59","is_public":0,"system_calendar_id":"","creator":1001,"project_id":"","updated_at":"2019-03-25 10:48:07","set_top_at":"","sort":3,"client":{},"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\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"attachmentRelationships":[],"scheduleCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"project":"","headUsers":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":2091,"schedule_id":7825,"description":"1.\u57f9\u8bad\uff0c\u5468\u4e00\u4e0b\u5348\u4e24\u70b9\u3002\n2.\u8c08\u7684\u5f88\u597d\u3002\n3.20%\u53cd\u5229\uff0c\u79ef\u6781\u8ba4\u53ef\u3002","created_at":"2019-04-07 23:59:59","created_at_display":"2019-04-07 23:59"}],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2019-04-07 23:59","complete_at_display2":"","end_at_display":"2019-04-07 23:59","end_at_display2":"","is_self":true,"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":7805,"client_id":"","schedule_title":"1.\u8d2d\u4e70\u4e91\u9f99\u901a\u96ea\u5361\u3002\r\n2.\u62a5\u540dH3c\u57f9\u8bad\u3002","description":"","schedule_week":1552838400,"start_at":"","complete_at":"2019-03-24 23:59:59","complete_description":"","is_complete":true,"alarm_before":"","created_by":1001,"created_at":"2019-03-20 10:42:24","is_closed":false,"is_remind":false,"time_type":1,"schedule_end":1553443199,"repeat_id":"","end_at":"2019-03-24 23:59:59","is_public":0,"system_calendar_id":"","creator":1001,"project_id":"","updated_at":"2019-03-20 10:42:24","set_top_at":"","sort":3,"client":{},"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\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"attachmentRelationships":[],"scheduleCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"project":"","headUsers":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2019-03-24 23:59","complete_at_display2":"","end_at_display":"2019-03-24 23:59","end_at_display2":"","is_self":true,"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":7780,"client_id":"","schedule_title":"\r\n1.\u91d1\u7545\u900d\u4ea7\u54c1\u8d28\u91cf\u4f1a\r\n2.\u65b0\u4eba\u5de5\u4f5c\u5212\u5206\r\n3.\u89c6\u9891\u6a21\u5757\u8fdb\u5ea6","description":"","schedule_week":1552838400,"start_at":"","complete_at":"2019-03-24 23:59:59","complete_description":"\r\n1.\u91d1\u7545\u900d\u4ea7\u54c1\u8d28\u91cf\u4f1a \u641e\u5b9a\r\n2.\u65b0\u4eba\u5de5\u4f5c\u5212\u5206 \u672a\u641e\u5b9a\r\n3.\u89c6\u9891\u6a21\u5757\u8fdb\u5ea6 \u641e\u5b9a","is_complete":true,"alarm_before":"","created_by":1001,"created_at":"2019-03-16 11:52:15","is_closed":true,"is_remind":false,"time_type":1,"schedule_end":1553443199,"repeat_id":"","end_at":"2019-03-24 23:59:59","is_public":0,"system_calendar_id":"","creator":1001,"project_id":"","updated_at":"2019-03-16 11:52:15","set_top_at":"","sort":3,"client":{},"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\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"attachmentRelationships":[],"scheduleCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"project":"","headUsers":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":1949,"schedule_id":7780,"description":"\r\n1.\u91d1\u7545\u900d\u4ea7\u54c1\u8d28\u91cf\u4f1a \u641e\u5b9a\r\n2.\u65b0\u4eba\u5de5\u4f5c\u5212\u5206 \u672a\u641e\u5b9a\r\n3.\u89c6\u9891\u6a21\u5757\u8fdb\u5ea6 \u641e\u5b9a","created_at":"2019-03-24 23:59:59","created_at_display":"2019-03-24 23:59"}],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2019-03-24 23:59","complete_at_display2":"","end_at_display":"2019-03-24 23:59","end_at_display2":"","is_self":true,"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":7778,"client_id":"","schedule_title":"\u5468\u4e00\u4f8b\u4f1a\u9700\u8981\u5206\u4eab\uff1a\n1.\u5415\u5174\u5143\u5982\u4f55\u505a\u597d\u7a0b\u6797\u7684\u758f\u5bfc\u5de5\u4f5c\u3002\n2.\u62d3\u5b9e\u79d1\u6280\u5f53\u524d\u7684\u4e1a\u52a1\u903b\u8f91\u3002","description":"","schedule_week":1552838400,"start_at":"","complete_at":"2019-03-24 23:59:59","complete_description":"","is_complete":true,"alarm_before":"","created_by":1001,"created_at":"2019-03-16 07:31:38","is_closed":true,"is_remind":false,"time_type":1,"schedule_end":1553443199,"repeat_id":"","end_at":"2019-03-24 23:59:59","is_public":0,"system_calendar_id":"","creator":1001,"project_id":"","updated_at":"2019-03-16 07:31:38","set_top_at":"","sort":3,"client":{},"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\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"attachmentRelationships":[],"scheduleCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"project":"","headUsers":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2019-03-24 23:59","complete_at_display2":"","end_at_display":"2019-03-24 23:59","end_at_display2":"","is_self":true,"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":7776,"client_id":"","schedule_title":"\n\u5382\u5546\uff1a\n1.\n2.\n3.\n\u5ba2\u6237\uff1a\n1.\n2.\n3.\n\u5176\u4ed6\uff1a\n1.\n2.\n3.","description":"","schedule_week":1552838400,"start_at":"","complete_at":"2019-03-24 23:59:59","complete_description":"\u5382\u5546\uff1a\n1. \u7b80\u5355\u8bf4\u660e\n2. \u7b80\u5355\u8bf4\u660e\n3. \u7b80\u5355\u8bf4\u660e\n\u5ba2\u6237\uff1a\n1. \u7b80\u5355\u8bf4\u660e\n2. \u7b80\u5355\u8bf4\u660e\n3. \u7b80\u5355\u8bf4\u660e\n\u5176\u4ed6\uff1a\n1. \u7b80\u5355\u8bf4\u660e\n2. \u7b80\u5355\u8bf4\u660e\n3. \u7b80\u5355\u8bf4\u660e","is_complete":true,"alarm_before":"","created_by":1001,"created_at":"2019-03-15 14:18:49","is_closed":true,"is_remind":false,"time_type":1,"schedule_end":1553443199,"repeat_id":"","end_at":"2019-03-24 23:59:59","is_public":1,"system_calendar_id":"","creator":1001,"project_id":"","updated_at":"2019-03-15 14:18:49","set_top_at":"","sort":3,"client":{},"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\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{"object_id":7776,"comment":4},"attachmentRelationships":[],"scheduleCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"project":"","headUsers":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":1934,"schedule_id":7776,"description":"\u5382\u5546\uff1a\n1. \u7b80\u5355\u8bf4\u660e\n2. \u7b80\u5355\u8bf4\u660e\n3. \u7b80\u5355\u8bf4\u660e\n\u5ba2\u6237\uff1a\n1. \u7b80\u5355\u8bf4\u660e\n2. \u7b80\u5355\u8bf4\u660e\n3. \u7b80\u5355\u8bf4\u660e\n\u5176\u4ed6\uff1a\n1. \u7b80\u5355\u8bf4\u660e\n2. \u7b80\u5355\u8bf4\u660e\n3. \u7b80\u5355\u8bf4\u660e","created_at":"2019-03-24 23:59:59","created_at_display":"2019-03-24 23:59"}],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2019-03-24 23:59","complete_at_display2":"","end_at_display":"2019-03-24 23:59","end_at_display2":"","is_self":true,"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":7735,"client_id":"","schedule_title":"\u7ea6\u8d75\u5ef6\u6e05\u8c08BMS\r\n\u7ea6\u8d3e\u603bBMS","description":"","schedule_week":1552233600,"start_at":"","complete_at":"2019-03-17 23:59:59","complete_description":"\u8d3e\u603b\u6c9f\u901a\u5b8c\u6210\uff0c\u7b49\u5f85\u7b54\u590d\u3002\u8d75\u603b\uff0c\u4e0b\u5468\u518d\u7ea6\u3002","is_complete":true,"alarm_before":"","created_by":1001,"created_at":"2019-03-07 09:35:21","is_closed":true,"is_remind":false,"time_type":1,"schedule_end":1552838399,"repeat_id":"","end_at":"2019-03-17 23:59:59","is_public":0,"system_calendar_id":"","creator":1001,"project_id":"","updated_at":"2019-03-07 09:35:21","set_top_at":"","sort":3,"client":{},"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\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"attachmentRelationships":[],"scheduleCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"project":"","headUsers":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":1986,"schedule_id":7735,"description":"\u8d3e\u603b\u6c9f\u901a\u5b8c\u6210\uff0c\u7b49\u5f85\u7b54\u590d\u3002\u8d75\u603b\uff0c\u4e0b\u5468\u518d\u7ea6\u3002","created_at":"2019-03-17 23:59:59","created_at_display":"2019-03-17 23:59"}],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2019-03-17 23:59","complete_at_display2":"","end_at_display":"2019-03-17 23:59","end_at_display2":"","is_self":true,"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":7736,"client_id":"","schedule_title":"review\u91d1\u7545\u900d\uff1a1.\u989c\u8272\u4e0e\u72b6\u6001\u5bf9\u5e94\u30022.\u6700\u65b0\u7248app\u53d1\u5e03\u30023.\u89c6\u9891\u76f4\u64ad","description":"","schedule_week":1551628800,"start_at":"","complete_at":"2019-03-10 23:59:59","complete_description":"\u641e\u5b9a","is_complete":true,"alarm_before":"","created_by":1001,"created_at":"2019-03-07 09:49:56","is_closed":true,"is_remind":false,"time_type":1,"schedule_end":1552233599,"repeat_id":"","end_at":"2019-03-10 23:59:59","is_public":0,"system_calendar_id":"","creator":1001,"project_id":"","updated_at":"2019-03-07 09:49:56","set_top_at":"","sort":3,"client":{},"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\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"attachmentRelationships":[],"scheduleCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"project":"","headUsers":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":1988,"schedule_id":7736,"description":"\u641e\u5b9a","created_at":"2019-03-10 23:59:59","created_at_display":"2019-03-10 23:59"}],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2019-03-10 23:59","complete_at_display2":"","end_at_display":"2019-03-10 23:59","end_at_display2":"","is_self":true,"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":7619,"client_id":426,"schedule_title":"\u6d4b\u8bd5","description":"","schedule_week":1548604800,"start_at":"","complete_at":"2019-02-03 23:59:59","complete_description":"","is_complete":true,"alarm_before":"","created_by":1001,"created_at":"2019-01-29 18:18:53","is_closed":false,"is_remind":false,"time_type":1,"schedule_end":1549209599,"repeat_id":"","end_at":"2019-02-03 23:59:59","is_public":0,"system_calendar_id":"","creator":1001,"project_id":"","updated_at":"2019-01-29 18:18:53","set_top_at":"","sort":3,"client":{"id":426,"key":426,"name":"\u5317\u4eac\u5600\u5600\u65e0\u9650\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","sales_rep":5311,"logo":"\/files\/cdn\/a57be577deb434\/logo\/4c905e50-0195-38cf-82c0-0025fcf3c1b6.png","salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587"}},"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\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"attachmentRelationships":[],"scheduleCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"project":"","headUsers":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2019-02-03 23:59","complete_at_display2":"","end_at_display":"2019-02-03 23:59","end_at_display2":"","is_self":true,"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":7613,"client_id":"","schedule_title":"\u5f00\u4f1a","description":"","schedule_week":1548604800,"start_at":"","complete_at":"2019-02-03 23:59:59","complete_description":"\u633a\u597d","is_complete":true,"alarm_before":"","created_by":1001,"created_at":"2019-01-29 05:46:10","is_closed":true,"is_remind":false,"time_type":1,"schedule_end":1549209599,"repeat_id":"","end_at":"2019-02-03 23:59:59","is_public":0,"system_calendar_id":"","creator":1001,"project_id":"","updated_at":"2019-01-29 05:46:10","set_top_at":"","sort":3,"client":{},"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\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"attachmentRelationships":[{"id":511,"object_type":9,"object_id":7613,"attachment_id":2414,"attachment":{"id":2414,"key":2414,"name":"ab9674ca-96b0-38c9-8348-a7b147a1a368","extension":"png","path":"\/vue\/attachment\/view\/ab9674ca-96b0-38c9-8348-a7b147a1a368\/20190129170339.png","orig_name":"20190129170339.png"}}],"scheduleCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"project":"","headUsers":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":1970,"schedule_id":7613,"description":"\u633a\u597d","created_at":"2019-02-03 23:59:59","created_at_display":"2019-02-03 23:59"}],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2019-02-03 23:59","complete_at_display2":"","end_at_display":"2019-02-03 23:59","end_at_display2":"","is_self":true,"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":7129,"client_id":"","schedule_title":"\u5468\u4e09\u5468\u56db\u7ea6\u6df1\u4fe1\u670d\u5c0f\u5f6d","description":"","schedule_week":1542556800,"start_at":"","complete_at":"2018-11-25 23:59:59","complete_description":"","is_complete":true,"alarm_before":"","created_by":1001,"created_at":"2018-11-15 11:59:19","is_closed":true,"is_remind":false,"time_type":1,"schedule_end":1543161599,"repeat_id":"","end_at":"2018-11-25 23:59:59","is_public":0,"system_calendar_id":"","creator":1001,"project_id":"","updated_at":"2018-11-15 11:59:19","set_top_at":"","sort":3,"client":{},"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\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"attachmentRelationships":[],"scheduleCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"project":"","headUsers":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2018-11-25 23:59","complete_at_display2":"","end_at_display":"2018-11-25 23:59","end_at_display2":"","is_self":true,"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":7115,"client_id":399,"schedule_title":"\u8ddf\u738b\u96f7\u8054\u7cfb\uff0c\u50ac\u6b3e\u4e8b\u5b9c\uff01","description":"","schedule_week":1541952000,"start_at":"","complete_at":"2018-11-18 23:59:59","complete_description":"\u9884\u8ba1\u672c\u5468\u4ed8\u6b3e\u3002","is_complete":true,"alarm_before":"","created_by":1001,"created_at":"2018-11-12 15:55:57","is_closed":true,"is_remind":false,"time_type":1,"schedule_end":1542556799,"repeat_id":"","end_at":"2018-11-18 23:59:59","is_public":0,"system_calendar_id":"","creator":1001,"project_id":"","updated_at":"2018-11-12 15:55:57","set_top_at":"","sort":3,"client":{"id":399,"key":399,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240\u4e2d\u76fe(\u8fc7\u5355\u516c\u53f8)","sales_rep":1005,"logo":"\/files\/cdn\/a57be577deb434\/logo\/6fc2ad20-226c-311c-9f64-96f95d6c6bdd.png","salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"}},"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\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"attachmentRelationships":[],"scheduleCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"project":"","headUsers":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":2306,"schedule_id":7115,"description":"\u9884\u8ba1\u672c\u5468\u4ed8\u6b3e\u3002","created_at":"2018-11-18 23:59:59","created_at_display":"2018-11-18 23:59"}],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2018-11-18 23:59","complete_at_display2":"","end_at_display":"2018-11-18 23:59","end_at_display2":"","is_self":true,"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":6891,"client_id":"","schedule_title":"\u4e0e\u91d1\u7545\u900d\u56e2\u961f\u8ba8\u8bba\uff1a\u65e5\u7a0b\u534f\u4f5c\u3001\u7edf\u8ba1\u5206\u6790\u8df3\u8f6c\u3002","description":"","schedule_week":1540137600,"start_at":"","complete_at":"2018-10-28 23:59:59","complete_description":"","is_complete":true,"alarm_before":"","created_by":1001,"created_at":"2018-10-19 10:20:32","is_closed":true,"is_remind":false,"time_type":1,"schedule_end":1540742399,"repeat_id":"","end_at":"2018-10-28 23:59:59","is_public":1,"system_calendar_id":"","creator":1001,"project_id":"","updated_at":"2018-10-19 10:20:32","set_top_at":"","sort":3,"client":{},"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\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{"object_id":6891,"comment":2},"attachmentRelationships":[],"scheduleCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"project":"","headUsers":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2018-10-28 23:59","complete_at_display2":"","end_at_display":"2018-10-28 23:59","end_at_display2":"","is_self":true,"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":6881,"client_id":"","schedule_title":"Review \u62db\u8058\u7ed3\u679c\u3002\u8f6f\u4ef6\u9500\u552e\uff0c\u524d\u7aef\u5de5\u7a0b\u5e08\u3002","description":"","schedule_week":1540137600,"start_at":"","complete_at":"2018-10-28 23:59:59","complete_description":"\u975e\u5e38\u7cdf\u7cd5","is_complete":true,"alarm_before":"","created_by":1001,"created_at":"2018-10-18 08:21:01","is_closed":true,"is_remind":false,"time_type":1,"schedule_end":1540742399,"repeat_id":"","end_at":"2018-10-28 23:59:59","is_public":0,"system_calendar_id":"","creator":1001,"project_id":"","updated_at":"2018-10-18 08:21:01","set_top_at":"","sort":3,"client":{},"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\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"attachmentRelationships":[],"scheduleCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"project":"","headUsers":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":2825,"schedule_id":6881,"description":"\u975e\u5e38\u7cdf\u7cd5","created_at":"2018-10-28 23:59:59","created_at_display":"2018-10-28 23:59"}],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2018-10-28 23:59","complete_at_display2":"","end_at_display":"2018-10-28 23:59","end_at_display2":"","is_self":true,"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":6883,"client_id":"","schedule_title":"Review \u67ef\u5357\u5fae\u8f6f\u4ea7\u54c1\u9009\u62e9\u3002","description":"","schedule_week":1539532800,"start_at":"","complete_at":"2018-10-21 23:59:59","complete_description":"\u8c03\u6574\u65b9\u5411\uff0c\u5411\u9ad8\u5927\u5c1a\uff0c\u70ab\u9177\u65b9\u9762\u505a\u3002","is_complete":true,"alarm_before":"","created_by":1001,"created_at":"2018-10-18 08:22:06","is_closed":true,"is_remind":false,"time_type":1,"schedule_end":1540137599,"repeat_id":"","end_at":"2018-10-21 23:59:59","is_public":0,"system_calendar_id":"","creator":1001,"project_id":"","updated_at":"2018-10-18 08:22:06","set_top_at":"","sort":3,"client":{},"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\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"attachmentRelationships":[],"scheduleCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"project":"","headUsers":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":2828,"schedule_id":6883,"description":"\u8c03\u6574\u65b9\u5411\uff0c\u5411\u9ad8\u5927\u5c1a\uff0c\u70ab\u9177\u65b9\u9762\u505a\u3002","created_at":"2018-10-21 23:59:59","created_at_display":"2018-10-21 23:59"}],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2018-10-21 23:59","complete_at_display2":"","end_at_display":"2018-10-21 23:59","end_at_display2":"","is_self":true,"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":6882,"client_id":"","schedule_title":"Review \u8f6f\u4ef6\u6f14\u793a\u89c6\u9891\u3002","description":"","schedule_week":1539532800,"start_at":"","complete_at":"2018-10-21 23:59:59","complete_description":"\u5468\u4e00\u770b\u6f14\u793a\u7ed3\u679c\u3002","is_complete":true,"alarm_before":"","created_by":1001,"created_at":"2018-10-18 08:21:37","is_closed":true,"is_remind":false,"time_type":1,"schedule_end":1540137599,"repeat_id":"","end_at":"2018-10-21 23:59:59","is_public":0,"system_calendar_id":"","creator":1001,"project_id":"","updated_at":"2018-10-18 08:21:37","set_top_at":"","sort":3,"client":{},"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\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{},"attachmentRelationships":[],"scheduleCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"project":"","headUsers":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":2826,"schedule_id":6882,"description":"\u5468\u4e00\u770b\u6f14\u793a\u7ed3\u679c\u3002","created_at":"2018-10-21 23:59:59","created_at_display":"2018-10-21 23:59"}],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2018-10-21 23:59","complete_at_display2":"","end_at_display":"2018-10-21 23:59","end_at_display2":"","is_self":true,"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":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"countStatus0":1,"countStatus1":149,"countStatus2":1,"countStatusTop":1,"can_create":true,"pagenation":{"totalcount":152,"thispage":4,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-24 10:22:04') RETURNING "id"
10:22:03.9373.4 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"='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 is_complete = true then complete_at END desc, case when is_complete = false then end_at END asc, s.created_at DESC LIMIT 20 OFFSET 60
10:22:03.9143.2 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:22:03.9792.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id" IN (7957, 7946, 7932, 7907, 7868, 7825, 7805, 7780, 7778, 7776, 7735, 7736, 7619, 7613, 7129, 7115, 6891, 6881, 6883, 6882))
10:22:03.9112.7 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:22:04.0332.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"='1001')) 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:22:03.9902.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=32) AND ("object_id" IN (7957, 7946, 7932, 7907, 7868, 7825, 7805, 7780, 7778, 7776, 7735, 7736, 7619, 7613, 7129, 7115, 6891, 6881, 6883, 6882))
10:22:03.9412.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (426, 399)
10:22:03.9822.0 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=2414
10:22:04.0361.9 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"='1001')) 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:22:04.0381.8 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"='1001')) 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:22:04.0401.7 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"='1001')) 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:22:03.9191.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:22:03.9301.4 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
10:22:04.0531.0 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=7, "last_visit_at"='now()' WHERE "id"=49855
10:22:03.9460.7 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
10:22:03.9440.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:22:03.9930.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_carbon_copy_rels" WHERE "schedule_id" IN (7957, 7946, 7932, 7907, 7868, 7825, 7805, 7780, 7778, 7776, 7735, 7736, 7619, 7613, 7129, 7115, 6891, 6881, 6883, 6882)
10:22:03.9450.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4
10:22:03.9440.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5311)
10:22:03.9450.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:22:03.9840.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:22:03.9850.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
10:22:03.9900.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:22:04.0420.3 msyii\db\Command::querySELECT "id", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"='1001'
10:22:03.9900.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
10:22:04.0430.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
10:22:03.9470.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4