ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68737ab3badda: POST https://beta.jinchangxiao.com/v2/schedule/of-client at 2025-07-13 05:21:55 pm by 120.244.156.33

Performance Profiling

Total processing time: 263 ms; Peak memory: 5.164 MB. Show Profiling Timeline

总计27条数据
TimeDurationCategoryInfo
  
17:21:55.94723.3 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=9) AND ("object_id" IN (17486, 17664, 17456, 17441, 16464, 16581, 15731, 15629, 15374, 15373)) GROUP BY "object_id"
17:21:55.99222.8 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=9) AND (remind_user_id = 1004 AND is_read = false) AND ("object_id" IN (17486, 17664, 17456, 17441, 16464, 16581, 15731, 15629, 15374, 15373)) GROUP BY "object_id"
17:21:55.9865.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_descriptions" WHERE "schedule_id" IN (17486, 17664, 17456, 17441, 16464, 16581, 15731, 15629, 15374, 15373) ORDER BY "created_at" DESC
17:21:55.9765.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_head_of_rels" WHERE "schedule_id" IN (17486, 17664, 17456, 17441, 16464, 16581, 15731, 15629, 15374, 15373)
17:21:55.9354.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"."client_id"=2094) AND ((("s"."is_public"=1) AND ("s"."created_by" != 1004)) OR ("s"."created_by"=1004) OR ("ccr"."user_id"=1004)) GROUP BY "s"."id" ORDER BY s.is_complete ASC, s.end_at DESC, s.created_at DESC) "c"
17:21:55.9233.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc'
17:21:55.9203.4 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:21:56.0223.0 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1004, 2, 1141, 'v2/schedule/of-client', '{"access_token":"NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc","device_type":"2","id":"2094","posttime":"1752398464","token":"5da57ee721c5820e57e3a2fa3aa67bf7","version_code":"1141"}', '{"code":200,"data":{"list":[{"id":17486,"client_id":2094,"schedule_title":"\u589e\u8fdb\u5ba2\u60c5\u5173\u7cfb\u3002","description":null,"schedule_week":null,"start_at":"","complete_at":"","complete_description":null,"is_complete":false,"alarm_before":null,"created_by":1005,"created_at":"2024-11-11 11:00:44","is_closed":false,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"","is_public":1,"system_calendar_id":null,"creator":1005,"project_id":null,"updated_at":"2024-11-11 11:00:44","set_top_at":null,"sort":1,"client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","sales_rep":1005,"logo":null,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"}},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":17486,"comment":12},"attachmentRelationships":[],"scheduleCreator":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"project":null,"headUsers":[{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":12172,"schedule_id":17486,"description":"\u4e0a\u5468\u65e0\uff0c\u672c\u5468\u65e0\u3002","created_at":"2025-03-09 21:30:29","created_at_display":"03-09 21:30"},{"id":11870,"schedule_id":17486,"description":"\u4e0a\u5468\u65e0\uff0c\u672c\u5468\u65e0\u3002","created_at":"2025-02-23 20:24:56","created_at_display":"02-23 20:24"},{"id":11717,"schedule_id":17486,"description":"\u4e0a\u5468\u8282\u540e\u95ee\u5019\uff0c\u672c\u5468\u6682\u65e0\u3002","created_at":"2025-02-16 20:37:31","created_at_display":"02-16 20:37"},{"id":11256,"schedule_id":17486,"description":"\u4e0a\u5468\u65e0\uff0c\u672c\u5468\u65e0\u3002\n","created_at":"2025-01-05 20:55:23","created_at_display":"01-05 20:55"},{"id":11098,"schedule_id":17486,"description":"\u4e0a\u5468\u65e0\uff0c\u672c\u5468\u65e0\u3002","created_at":"2024-12-29 19:42:14","created_at_display":"2024-12-29 19:42"},{"id":10945,"schedule_id":17486,"description":"\u4e0a\u5468\u5b89\u6392\u79ef\u5206\uff0c\u672c\u5468\u65e0","created_at":"2024-12-22 22:21:52","created_at_display":"2024-12-22 22:21"},{"id":10817,"schedule_id":17486,"description":"\u4e0a\u5468\u65e0\uff0c\u672c\u5468\u5b89\u6392\u79ef\u5206\u3002","created_at":"2024-12-15 22:04:35","created_at_display":"2024-12-15 22:04"},{"id":10687,"schedule_id":17486,"description":"\u4e0a\u5468\u65e0\uff0c\u672c\u5468\u65e0\u3002","created_at":"2024-12-08 20:54:02","created_at_display":"2024-12-08 20:54"},{"id":10539,"schedule_id":17486,"description":"\u4e0a\u5468\u65e0\uff0c\u672c\u5468\u65e0\u3002","created_at":"2024-12-01 22:38:33","created_at_display":"2024-12-01 22:38"},{"id":10361,"schedule_id":17486,"description":"\u4e0a\u5468\u6c9f\u901a\u5230\u6b3e\u60c5\u51b5\uff0c\u672c\u5468\u6c9f\u901a\u4e00\u4e0b\u540e\u7eed\u3002","created_at":"2024-11-24 20:15:55","created_at_display":"2024-11-24 20:15"},{"id":10260,"schedule_id":17486,"description":"\u4e0a\u5468\u548c\u5ba2\u6237\u6c9f\u901a\u9879\u76ee\uff0c\u672c\u5468\u770b\u5230\u6b3e\u60c5\u51b5\uff0c\u548c\u5ba2\u6237\u6c9f\u901a\u3002","created_at":"2024-11-17 21:25:35","created_at_display":"2024-11-17 21:25"}],"unreadComments":null,"schedule_status":0,"schedule_status_display":"\u8fdb\u884c\u4e2d","complete_at_display":"","complete_at_display2":"","end_at_display":null,"end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":false,"can_delete":false,"can_report":false,"unread":0,"bgcolor":"#4e6ef2","can_create_project":true,"start_at_display":null},{"id":17664,"client_id":2094,"schedule_title":"\u4e0a\u5468\u65e0\uff0c\u672c\u5468\u65e0\u3002","description":null,"schedule_week":null,"start_at":"","complete_at":"2025-03-09 21:30:15","complete_description":null,"is_complete":true,"alarm_before":null,"created_by":1005,"created_at":"2025-03-02 23:13:11","is_closed":true,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"","is_public":1,"system_calendar_id":null,"creator":1005,"project_id":null,"updated_at":"2025-03-02 23:13:11","set_top_at":null,"sort":3,"client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","sales_rep":1005,"logo":null,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"}},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":17664,"comment":2},"attachmentRelationships":[],"scheduleCreator":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"project":null,"headUsers":[{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":null,"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"03-09 21:30","complete_at_display2":"","end_at_display":null,"end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":false,"can_delete":false,"can_report":false,"unread":0,"bgcolor":"#53cd02","can_create_project":true,"start_at_display":null},{"id":17456,"client_id":2094,"schedule_title":"\u9500\u552e\u9636\u6bb5\uff1a\u7b7e\u8ba2\u5408\u540c","description":null,"schedule_week":null,"start_at":"","complete_at":"2024-11-20 14:22:40","complete_description":null,"is_complete":true,"alarm_before":null,"created_by":1005,"created_at":"2024-11-03 22:05:53","is_closed":true,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"","is_public":1,"system_calendar_id":null,"creator":1005,"project_id":3704,"updated_at":"2024-11-03 22:05:53","set_top_at":null,"sort":3,"client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","sales_rep":1005,"logo":null,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"}},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":17456,"comment":3},"attachmentRelationships":[],"scheduleCreator":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"project":{"id":3704,"key":3704,"name":"\u5ba2\u6237\u81ea\u7528-\u6df1\u4fe1\u670d\u9632\u706b\u5899\uff0c\u8d1f\u8f7d\uff0c\u4ea4\u6362\u673a","project_status":3,"budget":"217500","collected":"217500","projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210","bgcolor":"#6200fe"},"headUsers":[{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":10065,"schedule_id":17456,"description":"\u4e0a\u5468\u63d0\u4f9b 3 \u5bb6\u62a5\u4ef7\uff0c\u672c\u5468\u548c\u5ba2\u6237\u6c9f\u901a\u5229\u76ca\u5206\u914d\u95ee\u9898\uff0c\u5e76\u5236\u4f5c\u5408\u540c\u6a21\u677f","created_at":"2024-11-03 22:06:26","created_at_display":"2024-11-03 22:06"}],"unreadComments":null,"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2024-11-20 14:22","complete_at_display2":"","end_at_display":null,"end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":false,"can_delete":false,"can_report":false,"unread":0,"bgcolor":"#53cd02","can_create_project":true,"start_at_display":null},{"id":17441,"client_id":2094,"schedule_title":"\u9500\u552e\u9636\u6bb5\uff1a\u7b7e\u8ba2\u5408\u540c\n\u76ee\u7684\uff1a\u7b7e\u8ba2\u5408\u540c","description":null,"schedule_week":null,"start_at":"","complete_at":"2024-11-03 22:18:58","complete_description":null,"is_complete":true,"alarm_before":null,"created_by":1005,"created_at":"2024-10-27 21:17:34","is_closed":true,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"","is_public":1,"system_calendar_id":null,"creator":1005,"project_id":3701,"updated_at":"2024-10-27 21:17:34","set_top_at":null,"sort":3,"client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","sales_rep":1005,"logo":null,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"}},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":17441,"comment":3},"attachmentRelationships":[],"scheduleCreator":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"project":{"id":3701,"key":3701,"name":"\u5ba2\u6237\u81ea\u7528-\u534e\u4e3a\u7f51\u7edc\u8bbe\u5907-2024 \u5e74","project_status":3,"budget":"19350","collected":"19350","projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210","bgcolor":"#6200fe"},"headUsers":[{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":9891,"schedule_id":17441,"description":"\u4e0a\u5468\u548c\u5ba2\u6237\u6c9f\u901a\u4e86\u4ef7\u683c\uff0c\u672c\u5468\u51fa 3 \u5bb6\u62a5\u4ef7\uff0c\u8d70\u5408\u540c\u6d41\u7a0b\u3002","created_at":"2024-10-27 21:18:09","created_at_display":"2024-10-27 21:18"}],"unreadComments":null,"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2024-11-03 22:18","complete_at_display2":"","end_at_display":null,"end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":false,"can_delete":false,"can_report":false,"unread":0,"bgcolor":"#53cd02","can_create_project":true,"start_at_display":null},{"id":16464,"client_id":2094,"schedule_title":"\u76ee\u7684\uff1a\u63a8\u8350\u9632\u52d2\u7d22\u89e3\u51b3\u65b9\u6848","description":null,"schedule_week":null,"start_at":"","complete_at":"2024-03-18 12:16:11","complete_description":null,"is_complete":true,"alarm_before":null,"created_by":1005,"created_at":"2024-03-05 09:09:58","is_closed":true,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"","is_public":1,"system_calendar_id":null,"creator":1005,"project_id":null,"updated_at":"2024-03-05 09:09:58","set_top_at":null,"sort":3,"client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","sales_rep":1005,"logo":null,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"}},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":16464,"comment":3},"attachmentRelationships":[],"scheduleCreator":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"project":null,"headUsers":[{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":7602,"schedule_id":16464,"description":"\u5185\u7f51\u73af\u5883\uff0c\u4e0d\u9700\u8981","created_at":"2024-03-10 18:16:15","created_at_display":"2024-03-10 18:16"}],"unreadComments":null,"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2024-03-18 12:16","complete_at_display2":"","end_at_display":null,"end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":false,"can_delete":false,"can_report":false,"unread":0,"bgcolor":"#53cd02","can_create_project":true,"start_at_display":null},{"id":16581,"client_id":2094,"schedule_title":"4\u670830\u65e5\u524d\u653630%\uff0c5\u670831\u65e5\u524d\u5168\u6b3e","description":null,"schedule_week":null,"start_at":"","complete_at":"2024-04-22 17:48:47","complete_description":null,"is_complete":true,"alarm_before":null,"created_by":1005,"created_at":"2024-03-10 18:55:52","is_closed":true,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"2024-05-31 00:00:00","is_public":1,"system_calendar_id":null,"creator":1005,"project_id":3468,"updated_at":"2024-03-10 18:55:52","set_top_at":null,"sort":3,"client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","sales_rep":1005,"logo":null,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"}},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":16581,"comment":2},"attachmentRelationships":[],"scheduleCreator":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"project":{"id":3468,"key":3468,"name":"\u786c\u4ef6\u52a0\u5de5\u96c6\u6210\uff0c\u4ea7\u54c1\u6837\u673a\u6574\u4f53\u8054\u8c03\u670d\u52a1","project_status":3,"budget":"176660","collected":"176660","projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210","bgcolor":"#6200fe"},"headUsers":[{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":null,"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2024-04-22 17:48","complete_at_display2":"","end_at_display":"2024-05-31 00:00:00+08","end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":false,"can_delete":false,"can_report":false,"unread":0,"bgcolor":"#53cd02","can_create_project":true,"start_at_display":null},{"id":15731,"client_id":2094,"schedule_title":"\u76ee\u7684\uff1a\u8ba4\u8bc6\u97e9\u4e2d\u534e\uff0c\u8ba9\u5ba2\u6237\u6765\u5e74\u7684\u9879\u76ee\u53ef\u4ee5\u987a\u5229\u6267\u884c\n\u52a8\u4f5c\uff1a\u8ba9\u738b\u660e\u4eae\u7ea6\u97e9\u4e2d\u534e\u65f6\u95f4","description":null,"schedule_week":null,"start_at":"","complete_at":"2024-04-12 13:44:04","complete_description":null,"is_complete":true,"alarm_before":null,"created_by":1005,"created_at":"2023-09-18 17:14:14","is_closed":true,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"2023-09-29 00:00:00","is_public":1,"system_calendar_id":null,"creator":1005,"project_id":null,"updated_at":"2023-09-18 17:14:14","set_top_at":null,"sort":3,"client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","sales_rep":1005,"logo":null,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"}},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":15731,"comment":9},"attachmentRelationships":[],"scheduleCreator":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"project":null,"headUsers":[{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":7473,"schedule_id":15731,"description":"\u5ba1\u6279\u901a\u8fc7\u4e86\uff0c\u73b0\u5728\u5f00\u59cb\u8d70\u5408\u540c\u3002","created_at":"2024-03-04 11:43:22","created_at_display":"2024-03-04 11:43"},{"id":7268,"schedule_id":15731,"description":"\u76ee\u524d\u5728\u8fc7\u5ba1\u8ba1","created_at":"2024-01-22 17:09:12","created_at_display":"2024-01-22 17:09"},{"id":6901,"schedule_id":15731,"description":"\u91c7\u8d2d\u9879\u76ee\u88ab\u62d2\u4e86\uff0c\u73b0\u5728\u8981\u62c6\u62103\u4e2a\u9879\u76ee\uff0c\u518d\u6b21\u63d0\u4ea4","created_at":"2023-12-04 15:53:00","created_at_display":"2023-12-04 15:53"},{"id":6689,"schedule_id":15731,"description":"\u9884\u7b97\u5728\u5ba1\u8ba1\uff0c\u5ba1\u8ba1\u7ed3\u679c\u51fa\u6765\u540e\u518d\u7ea6","created_at":"2023-11-13 14:17:08","created_at_display":"2023-11-13 14:17"},{"id":6549,"schedule_id":15731,"description":"\u53d1\u7968\u5185\u5bb9\u8fd8\u6ca1\u5546\u91cf\u4e00\u81f4\u3002\u672c\u5468\u8ddf\u8fdb\u4e00\u4e0b","created_at":"2023-10-30 15:33:04","created_at_display":"2023-10-30 15:33"},{"id":6340,"schedule_id":15731,"description":"\u5408\u540c\u6b63\u5728\u8d70\u5ba1\u6279\uff0c\u7b49\u5408\u540c\u4e0b\u6765\u540e\u5b89\u6392\u89c1\u9762","created_at":"2023-10-15 20:53:39","created_at_display":"2023-10-15 20:53"},{"id":6192,"schedule_id":15731,"description":"\u660e\u4eae\u5fd9\u7740\u90a3\u4e2a\u5927\u9879\u76ee\uff0c\u6ca1\u65f6\u95f4\u7ea6\uff0c\u5f97\u7b49\u5341\u4e00\u4e4b\u540e\u4e86","created_at":"2023-09-24 21:40:51","created_at_display":"2023-09-24 21:40"}],"unreadComments":null,"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2024-04-12 13:44","complete_at_display2":"","end_at_display":"2023-09-29 00:00:00+08","end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":false,"can_delete":false,"can_report":false,"unread":0,"bgcolor":"#53cd02","can_create_project":true,"start_at_display":null},{"id":15629,"client_id":2094,"schedule_title":"\u76ee\u7684\uff1a\u505a\u5ba2\u6237\u957f\u671f\u4f9b\u5e94\u5546\uff0c\u5e2e\u52a9\u5ba2\u6237\u6709\u7a33\u5b9a\u7684\u4f9b\u5e94\u5546\n\u52a8\u4f5c\uff1a\u8981\u5230\u5177\u4f53\u4ea7\u54c1\uff0c\u8ba1\u7b97\u5177\u4f53\u70b9\u6570\uff0c\u548c\u5ba2\u6237\u786e\u5b9a","description":null,"schedule_week":null,"start_at":"","complete_at":"2023-09-13 11:47:40","complete_description":null,"is_complete":true,"alarm_before":null,"created_by":1005,"created_at":"2023-08-27 20:43:06","is_closed":true,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"2023-09-16 00:00:00","is_public":1,"system_calendar_id":null,"creator":1005,"project_id":null,"updated_at":"2023-08-27 20:43:06","set_top_at":null,"sort":3,"client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","sales_rep":1005,"logo":null,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"}},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":15629,"comment":3},"attachmentRelationships":[],"scheduleCreator":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"project":null,"headUsers":[{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":6137,"schedule_id":15629,"description":"\u7b97\u597d\u4e86\u70b9\u6570\uff0c\u7b49\u5f85\u5ba2\u6237\u8d70\u5408\u540c\u6d41\u7a0b\n\u7b49\u6d41\u7a0b\u8d70\u8d77\u6765\uff0c\u5382\u5546\u5e26\u6211\u53bb\u89c1\u97e9\u4e2d\u534e","created_at":"2023-09-13 11:47:40","created_at_display":"2023-09-13 11:47"}],"unreadComments":null,"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2023-09-13 11:47","complete_at_display2":"","end_at_display":"2023-09-16 00:00:00+08","end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":false,"can_delete":false,"can_report":false,"unread":0,"bgcolor":"#53cd02","can_create_project":true,"start_at_display":null},{"id":15374,"client_id":2094,"schedule_title":"\u76ee\u7684\uff1a\u6536\u6b3e\n\u52a8\u4f5c\uff1a9\u670815\u65e5\u524d\u6536\u6b3e","description":null,"schedule_week":null,"start_at":"","complete_at":"2023-07-30 23:16:24","complete_description":null,"is_complete":true,"alarm_before":null,"created_by":1005,"created_at":"2023-07-10 17:20:26","is_closed":true,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"2023-09-15 00:00:00","is_public":1,"system_calendar_id":null,"creator":1005,"project_id":3241,"updated_at":"2023-07-10 17:20:26","set_top_at":null,"sort":3,"client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","sales_rep":1005,"logo":null,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"}},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":15374,"comment":2},"attachmentRelationships":[],"scheduleCreator":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"project":{"id":3241,"key":3241,"name":"\u6df1\u4fe1\u670d\u8d1f\u8f7d\u5747\u8861\u9879\u76ee","project_status":3,"budget":"87000","collected":"87000","projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210","bgcolor":"#6200fe"},"headUsers":[{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":null,"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2023-07-30 23:16","complete_at_display2":"","end_at_display":"2023-09-15 00:00:00+08","end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":false,"can_delete":false,"can_report":false,"unread":0,"bgcolor":"#53cd02","can_create_project":true,"start_at_display":null},{"id":15373,"client_id":2094,"schedule_title":"\u76ee\u7684\uff1a\u6536\u6b3e\n\u52a8\u4f5c\uff1a9\u670815\u65e5\u524d\u6536\u6b3e","description":null,"schedule_week":null,"start_at":"","complete_at":"2023-08-13 16:46:38","complete_description":null,"is_complete":true,"alarm_before":null,"created_by":1005,"created_at":"2023-07-10 17:20:08","is_closed":true,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"2023-09-15 00:00:00","is_public":1,"system_calendar_id":null,"creator":1005,"project_id":3242,"updated_at":"2023-07-10 17:20:08","set_top_at":null,"sort":3,"client":{"id":2094,"key":2094,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u5317\u4eac\u4e2d\u5929\u950b\u5b89\u5168\u9632\u62a4\u6280\u672f\u6709\u9650\u516c\u53f8)","sales_rep":1005,"logo":null,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131"}},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":15373,"comment":2},"attachmentRelationships":[],"scheduleCreator":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"project":{"id":3242,"key":3242,"name":"\u6df1\u4fe1\u670d\u4e91\u955c","project_status":3,"budget":"89000","collected":"89000","projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210","bgcolor":"#6200fe"},"headUsers":[{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":null,"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2023-08-13 16:46","complete_at_display2":"","end_at_display":"2023-09-15 00:00:00+08","end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":false,"can_delete":false,"can_report":false,"unread":0,"bgcolor":"#53cd02","can_create_project":true,"start_at_display":null}],"pagenation":{"totalcount":35,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-13 17:21:56') RETURNING "id"
17:21:55.9832.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=32) AND ("object_id" IN (17486, 17664, 17456, 17441, 16464, 16581, 15731, 15629, 15374, 15373))
17:21:55.9391.8 msyii\db\Command::querySELECT s.*, CASE WHEN is_complete = true then 3 WHEN is_complete = false and end_at <= NOW() then 2 else 1 END AS sort FROM "a57be577deb434"."tbl_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = s.client_id LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE (1=1) AND ("s"."client_id"=2094) AND ((("s"."is_public"=1) AND ("s"."created_by" != 1004)) OR ("s"."created_by"=1004) OR ("ccr"."user_id"=1004)) GROUP BY "s"."id" ORDER BY s.is_complete ASC, s.end_at DESC, s.created_at DESC LIMIT 10
17:21:55.9701.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id" IN (17486, 17664, 17456, 17441, 16464, 16581, 15731, 15629, 15374, 15373))
17:21:55.9281.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004
17:21:55.9321.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='2094') AND ("deleted"=FALSE)
17:21:55.9750.7 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "project_status", "budget", "collected" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3704, 3701, 3468, 3241, 3242)
17:21:55.9440.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1005
17:21:55.9460.4 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005)
17:21:55.9760.4 msyii\db\Command::querySELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3
17:21:55.9450.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1
17:21:55.9860.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_carbon_copy_rels" WHERE "schedule_id" IN (17486, 17664, 17456, 17441, 16464, 16581, 15731, 15629, 15374, 15373)
17:21:55.9430.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2094
17:21:55.9440.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005
17:21:55.9740.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005
17:21:55.9450.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005
17:21:55.9820.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005
17:21:55.9740.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005)
17:21:55.9830.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005)
17:21:55.9460.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1