ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68d11ebae2531: POST https://beta.jinchangxiao.com/v2/schedule/list at 2025-09-22 06:02:34 pm by 120.235.117.239

Database Queries

总计28条数据
TimeDurationTypeQuery
  
18:02:34.9324.1 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='gnUsEwsg4g39ikUz7p-r_fvDxtXuWVx7'

[+] Explain
18:02:34.9372.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
18:02:34.9446.9 msSELECTSELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_schedules' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;

[+] Explain
18:02:34.9515.2 msSELECTselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_schedules' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum

[+] Explain
18:02:35.0050.7 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"

[+] Explain
18:02:35.0063.4 msSELECTSELECT 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, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449)) OR ("ccr"."user_id"=1001)) AND ("u"."department_id"='4') 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 s.is_complete = true then complete_at END desc, case when s.is_complete = false then end_at END asc, s.created_at DESC) "c"

[+] Explain
18:02:35.0092.5 msSELECTSELECT 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, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449)) OR ("ccr"."user_id"=1001)) AND ("u"."department_id"='4') 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 s.is_complete = true then complete_at END desc, case when s.is_complete = false then end_at END asc, s.created_at DESC LIMIT 10

[+] Explain
18:02:35.0140.9 msSELECTSELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2803

[+] Explain
18:02:35.0150.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
18:02:35.0150.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
18:02:35.0160.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4

[+] Explain
18:02:35.0160.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
18:02:35.0170.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)

[+] Explain
18:02:35.0170.1 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4

[+] Explain
18:02:35.01721.5 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=9) AND ("object_id" IN (17251, 16757, 16882, 16878, 16884, 16774, 16762, 16737, 16668, 16637)) GROUP BY "object_id"

[+] Explain
18:02:35.0392.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id" IN (17251, 16757, 16882, 16878, 16884, 16774, 16762, 16737, 16668, 16637))

[+] Explain
18:02:35.0420.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 1001, 1005)

[+] Explain
18:02:35.0420.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 1001, 1005))

[+] Explain
18:02:35.0424.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_schedule_head_of_rels" WHERE "schedule_id" IN (17251, 16757, 16882, 16878, 16884, 16774, 16762, 16737, 16668, 16637)

[+] Explain
18:02:35.0470.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1005, 1017)

[+] Explain
18:02:35.0470.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1005, 1017))

[+] Explain
18:02:35.0481.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=32) AND ("object_id" IN (17251, 16757, 16882, 16878, 16884, 16774, 16762, 16737, 16668, 16637))

[+] Explain
18:02:35.0500.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_schedule_carbon_copy_rels" WHERE "schedule_id" IN (17251, 16757, 16882, 16878, 16884, 16774, 16762, 16737, 16668, 16637)

[+] Explain
18:02:35.0507.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_schedule_descriptions" WHERE "schedule_id" IN (17251, 16757, 16882, 16878, 16884, 16774, 16762, 16737, 16668, 16637) ORDER BY "created_at" DESC

[+] Explain
18:02:35.05717.1 msSELECTSELECT "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 (17251, 16757, 16882, 16878, 16884, 16774, 16762, 16737, 16668, 16637)) GROUP BY "object_id"

[+] Explain
18:02:35.0760.3 msSELECTSELECT "id", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"='1001'

[+] Explain
18:02:35.0760.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)

[+] Explain
18:02:35.0781.8 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 0, 267, 'v2/schedule/list', '{"access_token":"gnUsEwsg4g39ikUz7p-r_fvDxtXuWVx7","device_type":"0","ScheduleSearch":{"keyword":"","created_by":"1001","department_id":"4","status":""},"version_code":"267","page":"1","token":"276b8ea6758127cae088f610791fc275","posttime":"1758535355","pagesize":"10"}', '{"code":200,"data":{"list":[{"id":17251,"client_id":2803,"schedule_title":"\u548c\u5f6d\u5ca9\u6c9f\u901a\u4e00\u4e0b\u62db\u8058\u4eba\u4e8b\u7684\u4e8b\u60c5\u3002","description":null,"schedule_week":null,"start_at":"","complete_at":"2024-07-19 11:42:59","complete_description":null,"is_complete":true,"alarm_before":null,"created_by":1001,"created_at":"2024-07-15 12:56:02","is_closed":true,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"2024-07-22 00:00:00","is_public":1,"system_calendar_id":null,"creator":1011,"project_id":null,"updated_at":"2024-07-15 12:56:02","set_top_at":null,"sort":3,"client":{"id":2803,"key":2803,"name":"\u62d3\u5b9e\u603b\u76d1\u4f1a","sales_rep":1001,"logo":null,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"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":17251,"comment":5},"attachmentRelationships":[],"scheduleCreator":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"project":null,"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":9152,"schedule_id":17251,"description":"HR\u62db\u8058\u5df2\u7ecf\u5f00\u59cb","created_at":"2024-07-19 11:42:59","created_at_display":"2024-07-19 11:42"}],"unreadComments":null,"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2024-07-19 11:42","complete_at_display2":"","end_at_display":"2024-07-22 00:00:00+08","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":null},{"id":16757,"client_id":2803,"schedule_title":"HPC\u7f51\u7ad9\u65b0\u589e\u6848\u4f8b","description":null,"schedule_week":null,"start_at":"","complete_at":"2024-05-29 09:55:27","complete_description":null,"is_complete":true,"alarm_before":null,"created_by":1001,"created_at":"2024-04-08 13:41:38","is_closed":true,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"2024-04-14 00:00:00","is_public":1,"system_calendar_id":null,"creator":1011,"project_id":null,"updated_at":"2024-04-08 13:41:38","set_top_at":null,"sort":3,"client":{"id":2803,"key":2803,"name":"\u62d3\u5b9e\u603b\u76d1\u4f1a","sales_rep":1001,"logo":null,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"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":16757,"comment":4},"attachmentRelationships":[],"scheduleCreator":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"project":null,"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":8723,"schedule_id":16757,"description":"\u91d1\u7545\u900d\u5f00\u53d1\u7684\u4efb\u52a1\u8f83\u591a\uff0c\u7f51\u7ad9\u6682\u65f6\u4e0d\u505a\u4f18\u5316\u3002","created_at":"2024-05-29 09:55:27","created_at_display":"2024-05-29 09:55"}],"unreadComments":null,"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2024-05-29 09:55","complete_at_display2":"","end_at_display":"2024-04-14 00:00:00+08","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":null},{"id":16882,"client_id":2803,"schedule_title":"\u7ea6\u89c1\u6d69\u8fb0\u5317\u533a\u603b\u7ecf\u7406\uff0c\u62d3\u5c55\u901f\u77f3\u5546\u673a","description":null,"schedule_week":null,"start_at":"","complete_at":"2024-05-29 09:54:22","complete_description":null,"is_complete":true,"alarm_before":null,"created_by":1001,"created_at":"2024-05-06 13:29:24","is_closed":true,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"2024-05-12 00:00:00","is_public":1,"system_calendar_id":null,"creator":1011,"project_id":null,"updated_at":"2024-05-06 13:29:24","set_top_at":null,"sort":3,"client":{"id":2803,"key":2803,"name":"\u62d3\u5b9e\u603b\u76d1\u4f1a","sales_rep":1001,"logo":null,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"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":16882,"comment":5},"attachmentRelationships":[],"scheduleCreator":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"project":null,"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":8722,"schedule_id":16882,"description":"\u7535\u8bdd\u6c9f\u901a\u4e86\u4e00\u4e0b\u4e1a\u52a1\u60c5\u51b5\uff0c\u5148\u505a\u4ee3\u7406\u3002","created_at":"2024-05-29 09:54:22","created_at_display":"2024-05-29 09:54"},{"id":8360,"schedule_id":16882,"description":"\u5b69\u5b50\u751f\u75c5\uff0c\u4e0b\u4e0b\u5468\u518d\u7ea6\u3002","created_at":"2024-05-10 06:45:27","created_at_display":"2024-05-10 06:45"}],"unreadComments":null,"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2024-05-29 09:54","complete_at_display2":"","end_at_display":"2024-05-12 00:00:00+08","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":null},{"id":16878,"client_id":null,"schedule_title":"\u8003\u9752\u4e91\uff0c\u6cfd\u6587\uff0c\u65b0\u4e66\u9605\u8bfb\u3002","description":null,"schedule_week":null,"start_at":"","complete_at":"2024-05-20 21:45:00","complete_description":null,"is_complete":true,"alarm_before":null,"created_by":1001,"created_at":"2024-05-06 11:00:01","is_closed":true,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"2024-05-13 18:00:00","is_public":1,"system_calendar_id":null,"creator":1001,"project_id":null,"updated_at":"2024-05-06 11:00:01","set_top_at":null,"sort":3,"client":null,"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":16878,"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":null,"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":8590,"schedule_id":16878,"description":"\u4e0b\u5468\u8003\u7b2c\u4e8c\u7bc7","created_at":"2024-05-20 21:45:00","created_at_display":"2024-05-20 21:45"},{"id":8470,"schedule_id":16878,"description":"\u4e0b\u5468\u8003\u7b2c\u4e00\u7bc7","created_at":"2024-05-14 05:57:20","created_at_display":"2024-05-14 05:57"}],"unreadComments":null,"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2024-05-20 21:45","complete_at_display2":"","end_at_display":"2024-05-13 18:00:00+08","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":null},{"id":16884,"client_id":null,"schedule_title":"\u4e0e\u6df1\u4fe1\u670d\u8c08MSS","description":null,"schedule_week":null,"start_at":"2024-05-08 14:00:00","complete_at":"2024-05-09 07:04:12","complete_description":null,"is_complete":true,"alarm_before":"02:00:00","created_by":1001,"created_at":"2024-05-06 13:33:53","is_closed":true,"is_remind":true,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"2024-05-08 16:00:00","is_public":1,"system_calendar_id":null,"creator":1001,"project_id":null,"updated_at":"2024-05-06 13:33:53","set_top_at":null,"sort":3,"client":null,"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":16884,"comment":3},"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":null,"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"}},{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","sex":"M","department_id":2,"avatar":{"id":8,"user_id":1017,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e538f0fe-48a7-33da-a512-b252266c9e91.jpg"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":8359,"schedule_id":16884,"description":"\u4ee5\u62d3\u5b9e\u540d\u5b57\uff0c\u4e7010\u4e2aMDR \u52a0500\u57fa\u7840\u3002","created_at":"2024-05-09 07:04:12","created_at_display":"2024-05-09 07:04"}],"unreadComments":null,"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2024-05-09 07:04","complete_at_display2":"","end_at_display":"2024-05-08 16:00:00+08","end_at_display2":"","is_self":true,"is_overdue":false,"alarm_before_display":"\u63d0\u524d2\u5c0f\u65f6","can_update":true,"can_delete":true,"can_report":false,"unread":0,"bgcolor":"#53cd02","can_create_project":true,"start_at_display":"2024-05-08 14:00:00+08"},{"id":16774,"client_id":null,"schedule_title":"\u5b89\u8fbe\u9f0e\u76db\u8bb2\u91d1\u7545\u900d","description":null,"schedule_week":null,"start_at":"2024-04-12 14:00:00","complete_at":"2024-04-13 19:09:12","complete_description":null,"is_complete":true,"alarm_before":null,"created_by":1001,"created_at":"2024-04-09 18:26:25","is_closed":true,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"2024-04-12 16:00:00","is_public":1,"system_calendar_id":null,"creator":1005,"project_id":null,"updated_at":"2024-04-09 18:26:25","set_top_at":null,"sort":3,"client":null,"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":16774,"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":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":null,"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2024-04-13 19:09","complete_at_display2":"","end_at_display":"2024-04-12 16:00:00+08","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":"2024-04-12 14:00:00+08"},{"id":16762,"client_id":null,"schedule_title":"\u6df1\u4fe1\u670d\u53f6\u8d8a\uff0c\u516c\u53f8\u6765\u8bbf","description":null,"schedule_week":null,"start_at":"2024-04-11 10:00:00","complete_at":"2024-04-13 19:09:08","complete_description":null,"is_complete":true,"alarm_before":null,"created_by":1001,"created_at":"2024-04-08 18:07:19","is_closed":true,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"2024-04-11 11:00:00","is_public":1,"system_calendar_id":null,"creator":1005,"project_id":null,"updated_at":"2024-04-08 18:07:19","set_top_at":null,"sort":3,"client":null,"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":16762,"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":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"}},{"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-13 19:09","complete_at_display2":"","end_at_display":"2024-04-11 11:00:00+08","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":"2024-04-11 10:00:00+08"},{"id":16737,"client_id":null,"schedule_title":"\u6da6\u7fd4\u8bb2\u91d1\u7545\u900d\u670d\u52a1\u3002","description":null,"schedule_week":null,"start_at":"2024-04-10 10:00:00","complete_at":"2024-04-13 19:09:02","complete_description":null,"is_complete":true,"alarm_before":null,"created_by":1001,"created_at":"2024-04-07 16:49:14","is_closed":true,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"2024-04-10 12:00:00","is_public":1,"system_calendar_id":null,"creator":1005,"project_id":null,"updated_at":"2024-04-07 16:49:14","set_top_at":null,"sort":3,"client":null,"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":16737,"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":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"}},{"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-13 19:09","complete_at_display2":"","end_at_display":"2024-04-10 12:00:00+08","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":"2024-04-10 10:00:00+08"},{"id":16668,"client_id":2803,"schedule_title":"1.\u4f18\u5316\u7f51\u7ad9\uff0c\u5c06CAE\u548cEDA\u6848\u4f8b\u5206\u5f00\u3002\n2.\u767e\u5ea6\u63a8\u5e7f\uff0c\u5728\u672c\u5468\u751f\u6548\u4ed8\u8d39\u63a8\u5e7f\u3002\n3.\u8ba8\u8bba\u9500\u552e\u4eba\u5458\u5b89\u6392\u4e8b\u5b9c\u3002\uff08\u5b66\u4e60\u8ba1\u5212\uff1a\u8003\u52e4\u4e00\u4e2a\u6708\uff0c\u4e00\u4e2a\u6708\u5c01\u95ed\u5b66\u4e60\uff09\u5929\u5929\u95ed\u73af\u3002\n4.\u8ba8\u8bba\u505c\u6b62ZSTACK\uff0c\u901f\u77f3\u66ff\u6362\u3002","description":null,"schedule_week":null,"start_at":"","complete_at":"2024-03-28 14:15:59","complete_description":null,"is_complete":true,"alarm_before":null,"created_by":1001,"created_at":"2024-03-23 18:45:41","is_closed":true,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"2024-03-31 18:00:00","is_public":1,"system_calendar_id":null,"creator":1001,"project_id":null,"updated_at":"2024-03-23 18:45:41","set_top_at":null,"sort":3,"client":{"id":2803,"key":2803,"name":"\u62d3\u5b9e\u603b\u76d1\u4f1a","sales_rep":1001,"logo":null,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"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":16668,"comment":5},"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":null,"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":7948,"schedule_id":16668,"description":"1.\u7f51\u7ad9\u4f18\u5316\u5b8c\u6210\n2\u3002\u767e\u5ea6\u63a8\u5e7f\u5df2\u7ecf\u4e0a\u7ebf\n3.1\u4e2a\u6708\u5c01\u95ed\u5b66\u4e60\n4.poc\u7ee7\u7eed","created_at":"2024-03-28 14:15:55","created_at_display":"2024-03-28 14:15"}],"unreadComments":null,"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2024-03-28 14:15","complete_at_display2":"","end_at_display":"2024-03-31 18:00:00+08","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":null},{"id":16637,"client_id":2803,"schedule_title":"1.\u521b\u5efa\u63a8\u5e7f\u5e7f\u544a\u8bed\n2.\u63a5\u5f85\u901f\u77f3\u5382\u5546\u6b66\u51ef\n3.\u90e8\u7f72\u676d\u5dde\u901f\u77f3\u5c55\u4f1a","description":null,"schedule_week":null,"start_at":"","complete_at":"2024-03-23 18:45:53","complete_description":null,"is_complete":true,"alarm_before":null,"created_by":1001,"created_at":"2024-03-16 17:48:35","is_closed":true,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"2024-03-24 18:00:00","is_public":1,"system_calendar_id":null,"creator":1001,"project_id":null,"updated_at":"2024-03-16 17:48:35","set_top_at":null,"sort":3,"client":{"id":2803,"key":2803,"name":"\u62d3\u5b9e\u603b\u76d1\u4f1a","sales_rep":1001,"logo":null,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"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":16637,"comment":9},"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":null,"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":7846,"schedule_id":16637,"description":"\u540e\u7eed\u8981\u8ddf\u8fdb\uff0cIC PARK \u817e\u8baf\u4e91\u5408\u4f5c\u4e8b\u5b9c","created_at":"2024-03-23 18:37:23","created_at_display":"2024-03-23 18:37"},{"id":7834,"schedule_id":16637,"description":"\u5468\u4e00\u4f1a\u8bae\uff0c\u5df2\u5411\u56e2\u961f\u8bf4\u660e\u5c55\u4f1a\u60c5\u51b5\uff0c\u4eba\u5458\u5b89\u6392\u5b8c\u6bd5\u3002\u5e76\u5206\u4eab\u4e86\u53c2\u52a0\u5c55\u4f1a\u7684\u5177\u4f53\u6280\u5de7\u3002","created_at":"2024-03-20 14:36:13","created_at_display":"2024-03-20 14:36"},{"id":7833,"schedule_id":16637,"description":"Fastone HPC\u9ad8\u6027\u80fd\u4eff\u771f\u5e73\u53f0\u6700\u9ad8\u63d0\u5347\u6548\u7387526\u500d\u3002CAE\/CFD\u4eff\u771f\u8bbe\u8ba1\u5168\u6d41\u7a0b\u8986\u76d6\u3002\u652f\u6301\u884c\u4e1aCAE\/CFD\u591a\u7ef4\u5ea6\u8ba1\u7b97\u5de5\u5177\u3002\u5e73\u53f0\u56ca\u62ec\u5b8c\u6210\u7684\u524d\u540e\u5904\u7406\u548c\u8ba1\u7b97\u6c42\u89e3\u7b49\u76f8\u5173\u6b65\u9aa4\u3002","created_at":"2024-03-20 14:34:46","created_at_display":"2024-03-20 14:34"}],"unreadComments":null,"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2024-03-23 18:45","complete_at_display2":"","end_at_display":"2024-03-24 18:00:00+08","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":null}],"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"}},"pagenation":{"totalcount":149,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-09-22 18:02:35') RETURNING "id"

[+] Explain