Performance Profiling

Total processing time: 182 ms; Peak memory: 5.393 MB. Show Profiling Timeline

总计32条数据
TimeDurationCategoryInfo
  
11:12:04.19933.9 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=9) AND ("object_id" IN (18268, 17677)) GROUP BY "object_id"
11:12:04.26827.9 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 (18268, 17677)) GROUP BY "object_id"
11:12:04.24016.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_head_of_rels" WHERE "schedule_id" IN (18268, 17677)
11:12:04.2584.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=32) AND ("object_id" IN (18268, 17677))
11:12:04.2344.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id" IN (18268, 17677))
11:12:04.2644.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_descriptions" WHERE "schedule_id" IN (18268, 17677) ORDER BY "created_at" DESC
11:12:04.2992.6 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT s.*, CASE WHEN is_complete = true then 3 WHEN is_complete = false and end_at <= NOW() then 2 else 1 END AS sort FROM "a57be577deb434"."tbl_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = s.client_id LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE (1=1) AND ("s"."project_id"=3796) AND ("s"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5446, 5461, 5476)) AND (set_top_at is null and is_complete = false and (end_at > now() or end_at is null)) 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"
11:12:04.1782.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:12:04.3072.0 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"."project_id"=3796) AND ("s"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5446, 5461, 5476)) AND (set_top_at is not null) 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"
11:12:04.1891.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"."project_id"=3796) AND ("s"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5446, 5461, 5476)) 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"
11:12:04.1921.7 msyii\db\Command::querySELECT s.*, CASE WHEN is_complete = true then 3 WHEN is_complete = false and end_at <= NOW() then 2 else 1 END AS sort FROM "a57be577deb434"."tbl_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = s.client_id LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE (1=1) AND ("s"."project_id"=3796) AND ("s"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5446, 5461, 5476)) 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
11:12:04.3051.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"."project_id"=3796) AND ("s"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5446, 5461, 5476)) AND (set_top_at is null and is_complete = false and end_at <= now()) 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"
11:12:04.3111.5 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/schedule/of-project', '{"id":"3796","web_access_token":"l4p3M_87vSdo8QF-blMLH4iPaepKw7vp"}', '{"code":2000,"result":{"list":[{"id":18268,"client_id":2125,"schedule_title":"\u9500\u552e\u9636\u6bb5\uff1a\u65b9\u6848\u8bbe\u8ba1\n\u76ee\u7684\uff1a\u786e\u5b9a\u65b9\u6848\n\u52a8\u4f5c\uff1a\u8054\u7cfb\u5e9e\u8001\u5e08","description":"","schedule_week":"","start_at":"","complete_at":"","complete_description":"","is_complete":false,"alarm_before":"","created_by":5087,"created_at":"2026-03-08 23:43:25","is_closed":false,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"2026-06-30 00:00:00","is_public":1,"system_calendar_id":"","creator":5087,"project_id":3796,"updated_at":"2026-03-22 19:40:46","set_top_at":"","sort":1,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8","sales_rep":5087,"logo":"","salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":18268,"comment":7},"attachmentRelationships":[],"scheduleCreator":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"project":{"id":3796,"key":3796,"name":"deepseek\u79c1\u6709\u5316\u90e8\u7f72","project_status":2,"budget":"790000","collected":"0","projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"project_status_display":"\u660e\u786e\u9700\u6c42","bgcolor":"#0064ec"},"headUsers":[{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":20854,"schedule_id":18268,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-22 19:40:30","created_at_display":"03-22 19:40"},{"id":20654,"schedule_id":18268,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-15 20:12:34","created_at_display":"03-15 20:12"},{"id":20500,"schedule_id":18268,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u8054\u7cfb\u5e9e\u8001\u5e08 \u4e0a\u5468\u603b\u7ed3\uff1a\u672a\u8054\u7cfb \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-08 23:43:39","created_at_display":"03-08 23:43"}],"unreadComments":{},"schedule_status":0,"schedule_status_display":"\u8fdb\u884c\u4e2d","complete_at_display":"","complete_at_display2":"","end_at_display":"06-30 00:00","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":17677,"client_id":2125,"schedule_title":"\u9500\u552e\u9636\u6bb5\uff1a\u65b9\u6848\u8bbe\u8ba1\n\u76ee\u7684\uff1a\u786e\u5b9a\u914d\u7f6e\u65b9\u6848\n\u52a8\u4f5c\uff1a\u8054\u7cfb\u5e9e\u8001\u5e08","description":"","schedule_week":"","start_at":"","complete_at":"2026-03-08 23:42:33","complete_description":"","is_complete":true,"alarm_before":"","created_by":5087,"created_at":"2025-03-10 08:58:11","is_closed":true,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"2025-10-31 00:00:00","is_public":1,"system_calendar_id":"","creator":5087,"project_id":3796,"updated_at":"2025-06-08 23:34:50","set_top_at":"","sort":3,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8","sales_rep":5087,"logo":"","salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":17677,"comment":54},"attachmentRelationships":[],"scheduleCreator":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"project":{"id":3796,"key":3796,"name":"deepseek\u79c1\u6709\u5316\u90e8\u7f72","project_status":2,"budget":"790000","collected":"0","projectStatus":{"id":2,"key":2,"name":"\u660e\u786e\u9700\u6c42","color":"#0064ec"},"project_status_display":"\u660e\u786e\u9700\u6c42","bgcolor":"#0064ec"},"headUsers":[{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":20499,"schedule_id":17677,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u8054\u7cfb\u5e9e\u8001\u5e08 \u4e0a\u5468\u603b\u7ed3\uff1a\u672a\u8054\u7cfb \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-03-08 23:41:49","created_at_display":"03-08 23:41"},{"id":20408,"schedule_id":17677,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u8054\u7cfb\u5e9e\u8001\u5e08","created_at":"2026-03-01 23:36:57","created_at_display":"03-01 23:36"},{"id":19878,"schedule_id":17677,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-01-25 22:01:48","created_at_display":"01-25 22:01"},{"id":19705,"schedule_id":17677,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-01-18 22:30:52","created_at_display":"01-18 22:30"},{"id":19513,"schedule_id":17677,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-01-11 20:24:13","created_at_display":"01-11 20:24"},{"id":19340,"schedule_id":17677,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2026-01-02 12:14:20","created_at_display":"01-02 12:14"},{"id":19159,"schedule_id":17677,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2025-12-28 12:45:08","created_at_display":"2025-12-28 12:45"},{"id":19041,"schedule_id":17677,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2025-12-22 00:09:32","created_at_display":"2025-12-22 00:09"},{"id":18768,"schedule_id":17677,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2025-12-14 15:20:30","created_at_display":"2025-12-14 15:20"},{"id":18626,"schedule_id":17677,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2025-12-07 22:31:31","created_at_display":"2025-12-07 22:31"},{"id":18348,"schedule_id":17677,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2025-11-30 09:10:33","created_at_display":"2025-11-30 09:10"},{"id":18175,"schedule_id":17677,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2025-11-23 20:27:26","created_at_display":"2025-11-23 20:27"},{"id":17971,"schedule_id":17677,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2025-11-16 23:35:37","created_at_display":"2025-11-16 23:35"},{"id":17797,"schedule_id":17677,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2025-11-09 23:40:46","created_at_display":"2025-11-09 23:40"},{"id":17517,"schedule_id":17677,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2025-11-02 23:16:24","created_at_display":"2025-11-02 23:16"},{"id":17318,"schedule_id":17677,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0 \u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2025-10-26 21:06:46","created_at_display":"2025-10-26 21:06"},{"id":17100,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2025-10-19 23:13:28","created_at_display":"2025-10-19 23:13"},{"id":16863,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2025-10-08 13:00:13","created_at_display":"2025-10-08 13:00"},{"id":16628,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2025-09-22 02:43:38","created_at_display":"2025-09-22 02:43"},{"id":16448,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \uff0c\u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2025-09-15 00:09:57","created_at_display":"2025-09-15 00:09"},{"id":16262,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u8054\u7cfb\u7528\u6237\u6c9f\u901a\u6d4b\u8bc4\u6807\u51c6\u95ee\u9898\uff0c\u672c\u5468\u8ba1\u5212 \uff1a\u65e0\u3002","created_at":"2025-09-07 21:16:01","created_at_display":"2025-09-07 21:16"},{"id":16098,"schedule_id":17677,"description":"\u4e0a\u5468 \u603b\u7ed3 \uff1a\u8d85\u7b97\u548c\u667a\u7b97\u6ca1\u6709\u5206\u4fdd\u6807\u51c6\uff0c\u95e8\u6237\u7cfb\u7edf\u548c\u524d\u540e\u5904\u7406\u6a21\u5757\u9700\u8981\u8fc7\u5206\u4fdd\uff0c\u672c\u5468\u8ba1\u5212\uff1a\u8054\u7cfb\u5e9e\u8001\u5e08","created_at":"2025-08-31 22:35:27","created_at_display":"2025-08-31 22:35"},{"id":15925,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0\uff0c\u672c\u5468\u8ba1\u5212\uff1a\u4e86\u89e3\u5927\u6a21\u578b\u5efa\u8bbe\u6d4b\u8bc4\u662f\u5426\u6709\u6807\u51c6\u3002","created_at":"2025-08-25 00:05:16","created_at_display":"2025-08-25 00:05"},{"id":15634,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u8054\u7cfb\u5e9e\u8001\u5e08\u4e86\u89e3\u8fdb\u5ea6\uff0c\u73b0\u5728\u95ee\u9898\u662f\u5927\u6a21\u578b\u5efa\u8bbe\u80fd\u4e0d\u80fd\u8fc7\u6d4b\u8bc4 \u672c\u5468\u8ba1\u5212\uff1a\u4e86\u89e3\u5927\u6a21\u578b\u5efa\u8bbe\u6d4b\u8bc4\u662f\u5426\u51fa\u6807\u51c6\u4e86\uff0c\u95ee\u5382\u5546\u6709\u6ca1\u6709\u8fc7\u6d4b\u7684\u6848\u4f8b","created_at":"2025-08-11 00:03:48","created_at_display":"2025-08-11 00:03"},{"id":15520,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2025-08-03 22:32:18","created_at_display":"2025-08-03 22:32"},{"id":15303,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0\u3002\u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2025-07-27 14:02:59","created_at_display":"2025-07-27 14:02"},{"id":15149,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0 \u672c\u5468\u8ba1\u5212\uff1a\u65e0\u3002","created_at":"2025-07-20 14:52:26","created_at_display":"2025-07-20 14:52"},{"id":14994,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0\uff0c\u672c\u5468\u8ba1\u5212\uff1a\u65e0","created_at":"2025-07-13 23:41:09","created_at_display":"2025-07-13 23:41"},{"id":14798,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0\uff0c\u672c\u5468\u8ba1\u5212\uff1a\u65e0\u3002","created_at":"2025-07-06 22:35:29","created_at_display":"2025-07-06 22:35"},{"id":14715,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0\u3002\u672c\u5468\u8ba1\u5212\uff1a\u65e0\u3002","created_at":"2025-06-30 05:35:56","created_at_display":"2025-06-30 05:35"},{"id":14555,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0\u3002\u672c\u5468\u8ba1\u5212\uff1a\u65e0\u3002","created_at":"2025-06-23 00:01:22","created_at_display":"2025-06-23 00:01"},{"id":14378,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u8054\u7cfb\u8303\u4e3b\u4efb\u9879\u76ee\u6ca1\u6709\u8fdb\u5c55\u3002\u672c\u5468\u8ba1\u5212 \uff1a\u65e0\u3002","created_at":"2025-06-15 23:29:18","created_at_display":"2025-06-15 23:29"},{"id":14276,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0\u3002\u672c\u5468\u8ba1\u5212 \uff1a\u8054\u7cfb\u8303\u4e3b\u4efb\u63a8\u8fdb\u9879\u76ee\u3002","created_at":"2025-06-08 23:32:18","created_at_display":"2025-06-08 23:32"},{"id":14033,"schedule_id":17677,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0\uff0c\u672c\u5468\u8ba1\u5212\uff1a\u65e0\u3002","created_at":"2025-06-02 19:01:59","created_at_display":"2025-06-02 19:01"},{"id":13861,"schedule_id":17677,"description":"\u4e0a\u5468\u9879\u76ee \u8ddf\u8fdb\uff0c\u672c\u5468\u65e0\u3002","created_at":"2025-05-25 16:28:22","created_at_display":"2025-05-25 16:28"},{"id":13723,"schedule_id":17677,"description":"\u4e0a\u5468\u8054\u7cfb\u5e9e\u8001\u5e08\uff0c\u672c\u5468\u8ddf\u8fdb\u9879\u76ee\u3002","created_at":"2025-05-18 23:08:37","created_at_display":"2025-05-18 23:08"},{"id":13565,"schedule_id":17677,"description":"\u4e0a\u5468\u65e0\uff0c\u672c\u5468\u65e0\u3002","created_at":"2025-05-12 00:30:55","created_at_display":"2025-05-12 00:30"},{"id":13377,"schedule_id":17677,"description":"\u4e0a\u5468\u65e0\uff0c\u672c\u5468\u65e0\u3002","created_at":"2025-05-05 23:07:15","created_at_display":"2025-05-05 23:07"},{"id":13211,"schedule_id":17677,"description":"\u4e0a\u5468\u65e0\uff0c\u672c\u5468\u65e0\u3002","created_at":"2025-04-27 23:26:57","created_at_display":"2025-04-27 23:26"},{"id":13039,"schedule_id":17677,"description":"\u4e0a\u5468\u65e0\uff0c\u672c\u5468\u65e0\u3002","created_at":"2025-04-20 22:15:24","created_at_display":"2025-04-20 22:15"},{"id":12834,"schedule_id":17677,"description":"\u4e0a\u5468\u8ddf\u8fdb\uff0c\u672c\u5468\u65e0 \u3002","created_at":"2025-04-13 08:15:55","created_at_display":"2025-04-13 08:15"},{"id":12681,"schedule_id":17677,"description":"\u4e0a\u5468\u65e0\uff0c\u672c\u5468\u8ddf\u8fdb\u3002","created_at":"2025-04-05 09:00:09","created_at_display":"2025-04-05 09:00"},{"id":12525,"schedule_id":17677,"description":"\u4e0a\u5468\u8054\u7cfb\u5e9e\u8001\u5e08\uff0c\u672c\u5468\u7ee7\u7eed\u8ddf\u8fdb\u3002","created_at":"2025-03-29 08:26:18","created_at_display":"2025-03-29 08:26"},{"id":12430,"schedule_id":17677,"description":"\u4e0a\u5468\u62a5\u4ef7\uff0c\u672c\u5468\u8ddf\u8fdb\u3002","created_at":"2025-03-23 23:33:23","created_at_display":"2025-03-23 23:33"},{"id":12282,"schedule_id":17677,"description":"\u4e0a\u5468\u8054\u7cfb\u5e9e\u8001\u5e08\uff0c\u672c\u5468\u7ed9\u51fa\u62a5\u4ef7\u3002","created_at":"2025-03-16 08:36:29","created_at_display":"2025-03-16 08:36"}],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"03-08 23:42","complete_at_display2":"","end_at_display":"2025-10-31 00:00","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":""}],"countStatus0":1,"countStatus1":1,"countStatus2":0,"countStatusTop":0,"can_create":true,"pagenation":{"totalcount":2,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-05 11:12:04', 176828928) RETURNING "id"
11:12:04.3031.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"."project_id"=3796) AND ("s"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5446, 5461, 5476)) AND (set_top_at is null and is_complete = true) 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"
11:12:04.1951.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2125
11:12:04.1970.9 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1
11:12:04.1730.9 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
11:12:04.1890.4 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
11:12:04.1830.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3796'
11:12:04.1970.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5087
11:12:04.2630.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_carbon_copy_rels" WHERE "schedule_id" IN (18268, 17677)
11:12:04.2390.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087
11:12:04.1990.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087)
11:12:04.2580.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087)
11:12:04.2390.3 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "project_status", "budget", "collected" FROM "a57be577deb434"."tbl_projects" WHERE "id"=3796
11:12:04.2570.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087
11:12:04.2390.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087)
11:12:04.1980.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087
11:12:04.2400.2 msyii\db\Command::querySELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=2
11:12:04.1960.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087
11:12:04.1990.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1
11:12:04.1730.1 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta