ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
688387966f63f: POST https://beta.jinchangxiao.com/v2/user/get-index at 2025-07-25 09:33:10 pm by 117.176.187.42

Database Queries

总计22条数据
TimeDurationTypeQuery
  
21:33:10.4943.8 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je'

[+] Explain
21:33:10.5011.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5300

[+] Explain
21:33:10.5030.5 msSELECTSELECT * FROM "global"."tbl_logins" WHERE "id"=5300

[+] Explain
21:33:10.5041.6 msSELECTSELECT COUNT(*) FROM (SELECT "a".* FROM "global"."tbl_announcements" "a" LEFT JOIN "global"."tbl_read_announcement" "r" ON a.id = r.announcement_id AND r.user_id = 5300 LEFT JOIN "global"."tbl_logins" "l" ON l.id = r.user_id WHERE (l.id IS NULL) AND ("a"."created_at" > '2021-06-28 09:26:03') ORDER BY "a"."created_at" DESC) "c"

[+] Explain
21:33:10.50618.0 msSELECTSELECT COUNT(*) FROM "a57be577deb434"."tbl_unread_comments" WHERE ("remind_user_id"=5300) AND ("is_read"=FALSE)

[+] Explain
21:33:10.52417.4 msSELECTSELECT count(*) as count, object_type FROM "a57be577deb434"."tbl_unread_comments" WHERE ("remind_user_id"=5300) AND (is_read = false) GROUP BY "object_type"

[+] Explain
21:33:10.5461.5 msSELECTSELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_calendars" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=5300) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name"

[+] Explain
21:33:10.5480.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5300

[+] Explain
21:33:10.5491.1 msSELECTSELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=5300) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name"

[+] Explain
21:33:10.5501.0 msSELECTSELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_work_logs" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=5300) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."id"

[+] Explain
21:33:10.5511944.1 msSELECTSELECT DISTINCT date(dt) AS edate, CASE WHEN count(cl.id) !=0 THEN true ELSE false END AS is_used, CASE WHEN count(cl.id) !=0 THEN true ELSE false END AS is_calendar_used, CASE WHEN count(sh.id) !=0 THEN true ELSE false END AS is_schedule_used, CASE WHEN count(wl.id) !=0 THEN true ELSE false END AS is_work_log_used FROM generate_series(date_trunc('day', to_date('20250701', 'yyyymmdd')), date_trunc('day', to_date('20250731', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_calendars" "c" WHERE (c.start_at IS NOT NULL) AND (c.end_at IS NOT NULL) AND ("c"."created_by"=5300)) "cl" ON ( ( (date(dt) || ' 00:00:00')::timestamp without time zone >= cl.start_at AND (date(dt) || ' 23:59:59')::timestamp without time zone <= cl.end_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= cl.start_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= cl.start_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= cl.end_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= cl.end_at ) ) LEFT JOIN (SELECT *, CASE WHEN end_at IS NULL THEN ( CASE WHEN start_at > now() THEN start_at ELSE ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) END ) ELSE ( CASE WHEN start_at IS NULL AND end_at < now() THEN ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) ELSE end_at END ) END AS e_at, CASE WHEN start_at IS NULL THEN ( CASE WHEN end_at < now() THEN ( CASE WHEN is_complete = true THEN created_at ELSE end_at END ) ELSE ( CASE WHEN is_complete = true THEN created_at ELSE now() END ) END ) ELSE start_at END AS s_at FROM "a57be577deb434"."tbl_schedules" WHERE (start_at is not null) OR (end_at is not null)) "sh" ON ( ( (date(dt) || ' 00:00:00')::timestamp without time zone >= sh.s_at AND (date(dt) || ' 23:59:59')::timestamp without time zone <= sh.e_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= sh.s_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= sh.s_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= sh.e_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= sh.e_at ) ) AND sh.created_by = 5300 LEFT JOIN (SELECT w.id, wlso.name as title, w.client_id, w.created_by, start_at, end_at, 3 as type, false AS is_alarm FROM "a57be577deb434"."tbl_work_logs" "w" LEFT JOIN "a57be577deb434"."tbl_work_log_scenario_options" "wlso" ON wlso.id = w.scenario_option_id WHERE (w.start_at IS NOT NULL) AND (w.end_at IS NOT NULL) AND ("w"."is_draft"=FALSE) AND ("w"."created_by"=5300)) "wl" ON ( ( (date(dt) || ' 00:00:00')::timestamp without time zone >= wl.start_at AND (date(dt) || ' 23:59:59')::timestamp without time zone <= wl.end_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= wl.start_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= wl.start_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= wl.end_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= wl.end_at ) ) GROUP BY "tt"."dt" ORDER BY "edate" DESC

[+] Explain
21:33:12.496114.9 msSELECTSELECT DISTINCT date(dt) AS edate,CASE WHEN count(cl.alarm_before) !=0 or count(sh.alarm_before) !=0 THEN true ELSE false END AS is_alarm FROM generate_series(date_trunc('day', to_date('20250701', 'yyyymmdd')), date_trunc('day', to_date('20250731', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_calendars" "cl" ON ( ( (date(dt) || ' 00:00:00')::timestamp without time zone >= cl.start_at AND (date(dt) || ' 23:59:59')::timestamp without time zone <= cl.end_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= cl.start_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= cl.start_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= cl.end_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= cl.end_at ) ) AND cl.created_by = 5300 LEFT JOIN "a57be577deb434"."tbl_schedules" "sh" ON ( ( (date(dt) || ' 00:00:00')::timestamp without time zone >= sh.start_at AND (date(dt) || ' 23:59:59')::timestamp without time zone <= sh.end_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= sh.start_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= sh.start_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= sh.end_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= sh.end_at ) ) AND sh.created_by = 5300 WHERE (cl.start_at - cl.alarm_before > '2025-07-25 09:33:12') OR (sh.start_at - sh.alarm_before > '2025-07-25 09:33:12') GROUP BY "tt"."dt", "cl"."id" ORDER BY "edate" DESC

[+] Explain
21:33:12.6126.8 msSELECTSELECT COUNT(*) FROM (SELECT * FROM ((SELECT w.id, wlso.name as title, w.client_id, w.created_by, start_at, end_at, 3 as type, false AS is_alarm FROM "a57be577deb434"."tbl_work_logs" "w" LEFT JOIN "a57be577deb434"."tbl_work_log_scenario_options" "wlso" ON wlso.id = w.scenario_option_id WHERE ((("w"."start_at" >= '2025-07-25 00:00:00') AND ("w"."end_at" < '2025-07-25 23:59:59')) OR (("w"."start_at" <= '2025-07-25 00:00:00') AND ("w"."end_at" > '2025-07-25 00:00:00')) OR (("w"."start_at" <= '2025-07-25 23:59:59') AND ("w"."end_at" > '2025-07-25 23:59:59'))) AND (w.start_at IS NOT NULL) AND (w.end_at IS NOT NULL) AND ("w"."is_draft"=FALSE) AND ("w"."created_by"=5300) AND ("w"."created_by" IN (5300, 5311))) UNION ALL ( (SELECT s.id, schedule_title as title, s.client_id, created_by, s_at as start_at, e_at as end_at, 2 as type, CASE WHEN alarm_before IS NOT NULL THEN true ELSE false END AS is_alarm FROM (SELECT *, CASE WHEN end_at IS NULL THEN ( CASE WHEN start_at > now() THEN start_at ELSE ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) END ) ELSE ( CASE WHEN start_at IS NULL AND end_at < now() THEN ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) ELSE end_at END ) END AS e_at, CASE WHEN start_at IS NULL THEN ( CASE WHEN end_at < now() THEN ( CASE WHEN is_complete = true THEN created_at ELSE end_at END ) ELSE ( CASE WHEN is_complete = true THEN created_at ELSE now() END ) END ) ELSE start_at END AS s_at FROM "a57be577deb434"."tbl_schedules" WHERE (start_at is not null) OR (end_at is not null)) "s" WHERE ((("s"."s_at" >= '2025-07-25 00:00:00') AND ("s"."e_at" < '2025-07-25 23:59:59')) OR (("s"."s_at" <= '2025-07-25 00:00:00') AND ("s"."e_at" > '2025-07-25 00:00:00')) OR (("s"."s_at" <= '2025-07-25 23:59:59') AND ("s"."e_at" > '2025-07-25 23:59:59'))) AND ("s"."created_by"=5300) AND ("s"."created_by" IN (5311, 5300, 5300))) UNION ALL ( SELECT c.id, title, c.client_id, created_by, start_at, end_at, 1 as type, CASE WHEN alarm_before IS NOT NULL THEN true ELSE false END AS is_alarm FROM "a57be577deb434"."tbl_calendars" "c" WHERE ((("c"."start_at" >= '2025-07-25 00:00:00') AND ("c"."end_at" < '2025-07-25 23:59:59')) OR (("c"."start_at" <= '2025-07-25 00:00:00') AND ("c"."end_at" > '2025-07-25 00:00:00')) OR (("c"."start_at" <= '2025-07-25 23:59:59') AND ("c"."end_at" > '2025-07-25 23:59:59'))) AND (c.start_at IS NOT NULL) AND (c.end_at IS NOT NULL) AND ("c"."created_by" IN (5311, 5300)) AND ("c"."created_by"=5300) ) )) "w" ORDER BY "start_at") "c"

[+] Explain
21:33:12.6196.1 msSELECTSELECT * FROM ((SELECT w.id, wlso.name as title, w.client_id, w.created_by, start_at, end_at, 3 as type, false AS is_alarm FROM "a57be577deb434"."tbl_work_logs" "w" LEFT JOIN "a57be577deb434"."tbl_work_log_scenario_options" "wlso" ON wlso.id = w.scenario_option_id WHERE ((("w"."start_at" >= '2025-07-25 00:00:00') AND ("w"."end_at" < '2025-07-25 23:59:59')) OR (("w"."start_at" <= '2025-07-25 00:00:00') AND ("w"."end_at" > '2025-07-25 00:00:00')) OR (("w"."start_at" <= '2025-07-25 23:59:59') AND ("w"."end_at" > '2025-07-25 23:59:59'))) AND (w.start_at IS NOT NULL) AND (w.end_at IS NOT NULL) AND ("w"."is_draft"=FALSE) AND ("w"."created_by"=5300) AND ("w"."created_by" IN (5300, 5311))) UNION ALL ( (SELECT s.id, schedule_title as title, s.client_id, created_by, s_at as start_at, e_at as end_at, 2 as type, CASE WHEN alarm_before IS NOT NULL THEN true ELSE false END AS is_alarm FROM (SELECT *, CASE WHEN end_at IS NULL THEN ( CASE WHEN start_at > now() THEN start_at ELSE ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) END ) ELSE ( CASE WHEN start_at IS NULL AND end_at < now() THEN ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) ELSE end_at END ) END AS e_at, CASE WHEN start_at IS NULL THEN ( CASE WHEN end_at < now() THEN ( CASE WHEN is_complete = true THEN created_at ELSE end_at END ) ELSE ( CASE WHEN is_complete = true THEN created_at ELSE now() END ) END ) ELSE start_at END AS s_at FROM "a57be577deb434"."tbl_schedules" WHERE (start_at is not null) OR (end_at is not null)) "s" WHERE ((("s"."s_at" >= '2025-07-25 00:00:00') AND ("s"."e_at" < '2025-07-25 23:59:59')) OR (("s"."s_at" <= '2025-07-25 00:00:00') AND ("s"."e_at" > '2025-07-25 00:00:00')) OR (("s"."s_at" <= '2025-07-25 23:59:59') AND ("s"."e_at" > '2025-07-25 23:59:59'))) AND ("s"."created_by"=5300) AND ("s"."created_by" IN (5311, 5300, 5300))) UNION ALL ( SELECT c.id, title, c.client_id, created_by, start_at, end_at, 1 as type, CASE WHEN alarm_before IS NOT NULL THEN true ELSE false END AS is_alarm FROM "a57be577deb434"."tbl_calendars" "c" WHERE ((("c"."start_at" >= '2025-07-25 00:00:00') AND ("c"."end_at" < '2025-07-25 23:59:59')) OR (("c"."start_at" <= '2025-07-25 00:00:00') AND ("c"."end_at" > '2025-07-25 00:00:00')) OR (("c"."start_at" <= '2025-07-25 23:59:59') AND ("c"."end_at" > '2025-07-25 23:59:59'))) AND (c.start_at IS NOT NULL) AND (c.end_at IS NOT NULL) AND ("c"."created_by" IN (5311, 5300)) AND ("c"."created_by"=5300) ) )) "w" ORDER BY "start_at"

[+] Explain
21:33:12.6250.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300

[+] Explain
21:33:12.6260.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1

[+] Explain
21:33:12.6270.4 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300)

[+] Explain
21:33:12.6270.5 msSELECTSELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (3175, 3178, 3174, 3284, 497)

[+] Explain
21:33:12.6280.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=26) AND (0=1)

[+] Explain
21:33:12.6281.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id" IN (16982, 16983, 16984, 17239, 16179))

[+] Explain
21:33:12.6300.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND (0=1)

[+] Explain
21:33:12.6311.9 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5300, 2, 1144, 'v2/user/get-index', '{"access_token":"GWtUzjYcC0dtywXjcMjkzgu5CXqDQ6je","device_type":"2","posttime":"1753450368","token":"9a4dff725a7507fb0e2165617118edc0","version_code":"1144"}', '{"code":200,"data":{"announcementUnread":{"count":41},"unread":[{"key":"1","value":3},{"key":"10","value":4},{"key":"18","value":11},{"key":"19","value":19},{"key":"5","value":3},{"key":"7","value":1}],"calendar":{"list":[{"id":16982,"title":"\u76ee\u6807\uff1a\u7ea6\u901f\u77f3\u5e73\u53f0\u4ecb\u7ecd\uff0c\u4e86\u89e3\u5ba2\u6237\u662f\u5426\u6709\u52a0\u901f\u4eff\u771f\u9a8c\u8bc1\u6548\u7387\u7684\u95ee\u9898","client_id":3175,"created_by":5300,"start_at":"2024-05-26 00:00:00","end_at":"2025-07-25 21:33:12","type":2,"is_alarm":false,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"client":{"id":3175,"key":3175,"name":"\u4e09\u4e00\u91cd\u5de5\/\u4e09\u4e00\u91cd\u5de5\u80a1\u4efd\u6709\u9650\u516c\u53f8-EDA","sales_rep":5311,"logo":null},"start_at_display":"","end_at_display":"21:33","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":16983,"title":"\u76ee\u6807\uff1a\u7ea6\u901f\u77f3\u5e73\u53f0\u4ecb\u7ecd\uff0c\u4e86\u89e3\u5ba2\u6237\u662f\u5426\u6709\u52a0\u901f\u4eff\u771f\u9a8c\u8bc1\u6548\u7387\u7684\u95ee\u9898","client_id":3178,"created_by":5300,"start_at":"2024-05-26 00:00:00","end_at":"2025-07-25 21:33:12","type":2,"is_alarm":false,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"client":{"id":3178,"key":3178,"name":"\u4e09\u672a\u4fe1\u5b89\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA\/CAE)","sales_rep":5311,"logo":null},"start_at_display":"","end_at_display":"21:33","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":16984,"title":"\u76ee\u6807\uff1a\u7ea6\u901f\u77f3\u5e73\u53f0\u4ecb\u7ecd\uff0c\u4e86\u89e3\u5ba2\u6237\u662f\u5426\u6709\u52a0\u901f\u4eff\u771f\u9a8c\u8bc1\u6548\u7387\u7684\u95ee\u9898","client_id":3174,"created_by":5300,"start_at":"2024-05-26 00:00:00","end_at":"2025-07-25 21:33:12","type":2,"is_alarm":false,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"client":{"id":3174,"key":3174,"name":"\u4e2d\u51b6\u8d5b\u8fea\u7535\u6c14\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5311,"logo":null},"start_at_display":"","end_at_display":"21:33","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":17239,"title":"\u5546\u673a\u9636\u6bb5\uff1a\u65b9\u6848\u8bbe\u8ba1\n\u76ee\u6807\uff1a\u7ed9\u5ba2\u6237\u51fa\u5177\u4e91\u684c\u9762\u89e3\u51b3\u65b9\u6848\uff0c\u5e2e\u52a9\u5ba2\u6237\u505a\u4ea7\u54c1\u8c03\u7814\uff0c\u5b8c\u6210\u534e\u4e09\u7684\u89e3\u51b3\u65b9\u6848\u6d4b\u8bd5","client_id":3284,"created_by":5300,"start_at":"2024-07-28 00:00:00","end_at":"2025-07-25 21:33:12","type":2,"is_alarm":false,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"client":{"id":3284,"key":3284,"name":"\u5149\u660e\u7f51\u4f20\u5a92\u6709\u9650\u516c\u53f8","sales_rep":5300,"logo":null},"start_at_display":"","end_at_display":"21:33","can_update":false,"can_delete":false,"attachmentRelationships":[]},{"id":16179,"title":"\u76ee\u6807\uff1a1\u670831\u65e5\u524d\u6536\u6b3e36w\uff0c4\u670831\u65e5\u524d\u6536\u6b3e72w\uff0c2025\u5e741\u670831\u65e5\u94b1\u6536\u6b3e12w","client_id":497,"created_by":5300,"start_at":"2025-01-31 00:00:00","end_at":"2025-07-25 21:33:12","type":2,"is_alarm":false,"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},"client":{"id":497,"key":497,"name":"\u5317\u4eac\u7ea2\u661f\u80a1\u4efd\u6709\u9650\u516c\u53f8","sales_rep":5300,"logo":null},"start_at_display":"","end_at_display":"21:33","can_update":false,"can_delete":false,"attachmentRelationships":[]}],"point":[{"edate":"2025-07-31","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-30","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-29","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-28","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-27","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-26","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-25","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-24","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-23","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-22","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-21","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-20","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-19","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-18","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-17","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-16","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-15","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-14","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-13","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-12","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-11","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-10","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-09","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-08","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-07","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-06","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-05","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-04","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-03","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-02","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-07-01","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false}],"free":[],"alarm":[],"pagenation":{"totalcount":5,"thispage":1,"pagesize":-1}}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-25 21:33:12') RETURNING "id"

[+] Explain