ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a22993fda570: POST https://beta.jinchangxiao.com/vue/schedule/of-project at 2026-06-05 05:39:11 pm by 221.216.117.119

Performance Profiling

Total processing time: 134 ms; Peak memory: 5.159 MB. Show Profiling Timeline

总计31条数据
TimeDurationCategoryInfo
  
17:39:11.92035.8 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=9) AND ("object_id" IN (18363, 18033)) GROUP BY "object_id"
17:39:11.97734.3 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=9) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (18363, 18033)) GROUP BY "object_id"
17:39:11.9676.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=32) AND ("object_id" IN (18363, 18033))
17:39:11.9565.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id" IN (18363, 18033))
17:39:11.8963.3 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:39:12.0223.3 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":"4024","web_access_token":"l4p3M_87vSdo8QF-blMLH4iPaepKw7vp"}', '{"code":2000,"result":{"list":[{"id":18363,"client_id":3415,"schedule_title":"\u9500\u552e\u9636\u6bb5\uff1a\u786e\u8ba4\u95ee\u9898","description":"","schedule_week":"","start_at":"2026-06-05 00:00:00","complete_at":"","complete_description":"","is_complete":false,"alarm_before":"","created_by":1001,"created_at":"2026-06-05 17:39:06","is_closed":false,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"2026-06-06 00:00:00","is_public":1,"system_calendar_id":"","creator":1001,"project_id":4024,"updated_at":"2026-06-05 17:39:06","set_top_at":"","sort":1,"client":{"id":3415,"key":3415,"name":"\u5317\u4eac\u4e2d\u91d1\u4fdd\u9669\u7ecf\u7eaa\u6709\u9650\u516c\u53f8","sales_rep":"","logo":"","salesRep":""},"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\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"commentCount":{"object_id":18363,"comment":1},"attachmentRelationships":[],"scheduleCreator":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"project":{"id":4024,"key":4024,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899","project_status":5,"budget":"100000","collected":"0","projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"project_status_display":"\u5546\u673a\u6401\u7f6e","bgcolor":"#222222"},"headUsers":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":{},"schedule_status":0,"schedule_status_display":"\u8fdb\u884c\u4e2d","complete_at_display":"","complete_at_display2":"","end_at_display":"06-06 (\u660e\u5929) 00:00","end_at_display2":"","is_self":true,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":true,"can_delete":true,"can_report":true,"unread":0,"bgcolor":"#4e6ef2","can_create_project":true,"start_at_display":""},{"id":18033,"client_id":3415,"schedule_title":"\u9500\u552e\u9636\u6bb5\uff1a\u786e\u8ba4\u95ee\u9898","description":"","schedule_week":"","start_at":"","complete_at":"","complete_description":"","is_complete":true,"alarm_before":"","created_by":1005,"created_at":"2025-11-03 09:46:09","is_closed":true,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"2026-03-08 22:33:52","is_public":1,"system_calendar_id":"","creator":1005,"project_id":4024,"updated_at":"2025-11-03 09:46:09","set_top_at":"","sort":3,"client":{"id":3415,"key":3415,"name":"\u5317\u4eac\u4e2d\u91d1\u4fdd\u9669\u7ecf\u7eaa\u6709\u9650\u516c\u53f8","sales_rep":"","logo":"","salesRep":""},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","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":18033,"comment":9},"attachmentRelationships":[],"scheduleCreator":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"project":{"id":4024,"key":4024,"name":"\u6df1\u4fe1\u670d\u9632\u706b\u5899","project_status":5,"budget":"100000","collected":"0","projectStatus":{"id":5,"key":5,"name":"\u5546\u673a\u6401\u7f6e","color":"#222222"},"project_status_display":"\u5546\u673a\u6401\u7f6e","bgcolor":"#222222"},"headUsers":[{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","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":18849,"schedule_id":18033,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0\u3002\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0\u3002\u672c\u5468\u8ba1\u5212\uff1a\u65e0\u3002","created_at":"2025-12-14 22:08:12","created_at_display":"2025-12-14 22:08"},{"id":18606,"schedule_id":18033,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u7ee7\u7eed\u8054\u7cfb\u3002\u4e0a\u5468\u603b\u7ed3\uff1a\u6ca1\u63a5\u7535\u8bdd\u3002\u672c\u5468\u8ba1\u5212\uff1a\u7ee7\u7eed\u8054\u7cfb\u3002","created_at":"2025-12-07 21:27:48","created_at_display":"2025-12-07 21:27"},{"id":18409,"schedule_id":18033,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u8054\u7cfb\u5ba2\u6237\u3002\u4e0a\u5468\u603b\u7ed3\uff1a\u5ba2\u6237\u4e0d\u63a5\u7535\u8bdd\u3002\u672c\u5468\u8ba1\u5212\uff1a\u7ee7\u7eed\u8054\u7cfb\u3002","created_at":"2025-11-30 21:51:28","created_at_display":"2025-11-30 21:51"},{"id":18134,"schedule_id":18033,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u7535\u8bdd\u5ba2\u6237\uff0c\u4e0a\u5468\u603b\u7ed3\uff1a\u5ba2\u6237\u672a\u63a5\u7535\u8bdd\uff0c\u672c\u5468\u8ba1\u5212\uff1a\u7ee7\u7eed\u8054\u7cfb\u5ba2\u6237\u3002","created_at":"2025-11-23 18:23:38","created_at_display":"2025-11-23 18:23"},{"id":17949,"schedule_id":18033,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u65e0\uff0c\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0\uff0c\u672c\u5468\u8ba1\u5212\uff1a\u548c\u5ba2\u6237\u8054\u7cfb\u4e00\u4e0b\uff0c\u770b\u662f\u5426\u56de\u4eac\u3002","created_at":"2025-11-16 20:07:54","created_at_display":"2025-11-16 20:07"},{"id":17758,"schedule_id":18033,"description":"\u4e0a\u5468\u8ba1\u5212\uff1a\u6301\u7eed\u8054\u7cfb\uff0c\u4e0a\u5468\u603b\u7ed3\uff1a\u65e0\uff0c\u672c\u5468\u8ba1\u5212\uff1a\u65e0\uff0c11\u6708\u5e95\u7b49\u5ba2\u6237\u51fa\u5dee\u56de\u6765\u8054\u7cfb\u3002","created_at":"2025-11-09 18:18:14","created_at_display":"2025-11-09 18:18"},{"id":17580,"schedule_id":18033,"description":"\u4e0a\u5468\u603b\u7ed3\uff1a\u548c\u5ba2\u6237\u6c9f\u901a\uff0c\u662f\u660e\u5e742\u5b63\u5ea6\u7684\u9879\u76ee\uff0c\u62db\u6807\uff0c\u5728\u5916\u5730\u51fa\u5dee\u505a\u9879\u76ee\uff0c\u9884\u8ba112\u6708\u4efd\u56de\u6765\uff0c\u5fae\u4fe1\u672a\u901a\u8fc7\u3002\u672c\u5468\u8ba1\u5212\uff1a\u6301\u7eed\u8054\u7cfb\uff0c\u52a0\u5fae\u4fe1\uff0c\u7ea6\u89c1\u9762\u3002","created_at":"2025-11-03 09:47:24","created_at_display":"2025-11-03 09:47"}],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"","complete_at_display2":"","end_at_display":"03-08 22:33","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 17:39:12', 126757120) RETURNING "id"
17:39:11.9743.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_descriptions" WHERE "schedule_id" IN (18363, 18033) ORDER BY "created_at" DESC
17:39:11.9632.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_head_of_rels" WHERE "schedule_id" IN (18363, 18033)
17:39:12.0131.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"."project_id"=4024) 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"
17:39:11.9121.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"."project_id"=4024) 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"
17:39:11.9151.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"=4024) 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
17:39:12.0151.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"=4024) 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"
17:39:12.0171.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"=4024) 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"
17:39:12.0191.4 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT s.*, CASE WHEN is_complete = true then 3 WHEN is_complete = false and end_at <= NOW() then 2 else 1 END AS sort FROM "a57be577deb434"."tbl_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = s.client_id LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE (1=1) AND ("s"."project_id"=4024) 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"
17:39:11.9010.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:39:11.9170.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1005)
17:39:11.9040.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='4024'
17:39:11.9120.5 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
17:39:11.9610.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1005)
17:39:11.9190.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1005))
17:39:11.9170.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id"=3415
17:39:11.9730.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_carbon_copy_rels" WHERE "schedule_id" IN (18363, 18033)
17:39:11.9660.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 1001)
17:39:11.9620.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1005))
17:39:11.9620.3 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "project_status", "budget", "collected" FROM "a57be577deb434"."tbl_projects" WHERE "id"=4024
17:39:11.9180.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1005)
17:39:11.9670.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1005))
17:39:11.9630.2 msyii\db\Command::querySELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=5
17:39:11.8960.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:39:11.9180.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1)
17:39:11.9190.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1)