ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
69427343e8541: POST https://beta.jinchangxiao.com/v2/user/get-index at 2025-12-17 05:09:23 pm by 221.216.117.150

Database Queries

总计19条数据
TimeDurationTypeQuery
  
17:09:23.9562.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG'

[+] Explain
17:09:23.9591.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064

[+] Explain
17:09:23.96118.8 msSELECTSELECT COUNT(*) FROM "a57be577deb434"."tbl_unread_comments" WHERE ("remind_user_id"=5064) AND ("is_read"=FALSE)

[+] Explain
17:09:23.98017.9 msSELECTSELECT count(*) as count, object_type FROM "a57be577deb434"."tbl_unread_comments" WHERE ("remind_user_id"=5064) AND (is_read = false) GROUP BY "object_type"

[+] Explain
17:09:24.0010.6 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"

[+] Explain
17:09:24.0020.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064

[+] Explain
17:09:24.0020.2 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"

[+] Explain
17:09:24.0030.3 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"

[+] Explain
17:09:24.00313.2 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('20251201', 'yyyymmdd')), date_trunc('day', to_date('20251231', '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"=5064)) "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 = 5064 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"=5064)) "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
17:09:24.01715.7 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('20251201', 'yyyymmdd')), date_trunc('day', to_date('20251231', '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 = 5064 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 = 5064 WHERE (cl.start_at - cl.alarm_before > '2025-12-17 05:09:24') OR (sh.start_at - sh.alarm_before > '2025-12-17 05:09:24') GROUP BY "tt"."dt", "cl"."id" ORDER BY "edate" DESC

[+] Explain
17:09:24.0333.3 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-12-17 00:00:00') AND ("w"."end_at" < '2025-12-17 23:59:59')) OR (("w"."start_at" <= '2025-12-17 00:00:00') AND ("w"."end_at" > '2025-12-17 00:00:00')) OR (("w"."start_at" <= '2025-12-17 23:59:59') AND ("w"."end_at" > '2025-12-17 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"=5064) AND ("w"."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))) 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-12-17 00:00:00') AND ("s"."e_at" < '2025-12-17 23:59:59')) OR (("s"."s_at" <= '2025-12-17 00:00:00') AND ("s"."e_at" > '2025-12-17 00:00:00')) OR (("s"."s_at" <= '2025-12-17 23:59:59') AND ("s"."e_at" > '2025-12-17 23:59:59'))) AND ("s"."created_by"=5064) 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))) 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-12-17 00:00:00') AND ("c"."end_at" < '2025-12-17 23:59:59')) OR (("c"."start_at" <= '2025-12-17 00:00:00') AND ("c"."end_at" > '2025-12-17 00:00:00')) OR (("c"."start_at" <= '2025-12-17 23:59:59') AND ("c"."end_at" > '2025-12-17 23:59:59'))) AND (c.start_at IS NOT NULL) AND (c.end_at IS NOT NULL) AND ("c"."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)) AND ("c"."created_by"=5064) ) )) "w" ORDER BY "start_at") "c"

[+] Explain
17:09:24.0372.8 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-12-17 00:00:00') AND ("w"."end_at" < '2025-12-17 23:59:59')) OR (("w"."start_at" <= '2025-12-17 00:00:00') AND ("w"."end_at" > '2025-12-17 00:00:00')) OR (("w"."start_at" <= '2025-12-17 23:59:59') AND ("w"."end_at" > '2025-12-17 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"=5064) AND ("w"."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))) 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-12-17 00:00:00') AND ("s"."e_at" < '2025-12-17 23:59:59')) OR (("s"."s_at" <= '2025-12-17 00:00:00') AND ("s"."e_at" > '2025-12-17 00:00:00')) OR (("s"."s_at" <= '2025-12-17 23:59:59') AND ("s"."e_at" > '2025-12-17 23:59:59'))) AND ("s"."created_by"=5064) 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))) 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-12-17 00:00:00') AND ("c"."end_at" < '2025-12-17 23:59:59')) OR (("c"."start_at" <= '2025-12-17 00:00:00') AND ("c"."end_at" > '2025-12-17 00:00:00')) OR (("c"."start_at" <= '2025-12-17 23:59:59') AND ("c"."end_at" > '2025-12-17 23:59:59'))) AND (c.start_at IS NOT NULL) AND (c.end_at IS NOT NULL) AND ("c"."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)) AND ("c"."created_by"=5064) ) )) "w" ORDER BY "start_at"

[+] Explain
17:09:24.0400.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5064

[+] Explain
17:09:24.0410.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10

[+] Explain
17:09:24.0410.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5064)

[+] Explain
17:09:24.0420.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=26) AND (0=1)

[+] Explain
17:09:24.0422.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id"=17948)

[+] Explain
17:09:24.0440.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND (0=1)

[+] Explain
17:09:24.0451.4 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5064, 2, 1153, 'v2/user/get-index', '{"access_token":"-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG","device_type":"2","posttime":"1765962624","token":"5e7c9a3c6c7d9a5ba9ac6158e80584de","version_code":"1153"}', '{"code":200,"data":{"announcementUnread":{"count":34},"unread":[{"key":"19","value":3},{"key":"37","value":1},{"key":999,"value":16},{"key":20000,"value":14}],"calendar":{"list":[{"id":17948,"title":"\u6c47\u62a5\uff1a\u5ba1\u6279\u7ba1\u7406 \u4ed8\u6b3e\u7533\u8bf7\uff0c\u662f\u5426\u9700\u8981\u53d6\u6d88\u4ed8\u6b3e\u7684\u529f\u80fd\n\u786e\u8ba4\u5176\u4ed6\u5e94\u6536\u5355\u3001\u5176\u4ed6\u5e94\u4ed8\u5230\u662f\u5426\u9700\u8981\u5173\u8054\u8be5\u8054\u7cfb\u4eba\u96b6\u5c5e\u4e8e\u5ba2\u6237\u6216\u8005\u4f9b\u5e94\u5546\u4e0b\u7684\u5408\u540c","client_id":null,"created_by":5064,"start_at":"2025-09-12 09:30:00","end_at":"2025-12-17 17:09:24","type":2,"is_alarm":false,"createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}},"client":null,"start_at_display":"","end_at_display":"17:09","can_update":false,"can_delete":false,"attachmentRelationships":[]}],"point":[{"edate":"2025-12-31","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-30","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-29","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-28","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-27","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-26","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-25","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-24","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-23","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-22","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-21","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-20","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-19","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-18","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-12-17","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-12-16","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-12-15","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":true},{"edate":"2025-12-14","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-12-13","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-12-12","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-12-11","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-12-10","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-12-09","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-12-08","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-12-07","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-12-06","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-12-05","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-12-04","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-12-03","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":true},{"edate":"2025-12-02","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-12-01","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false}],"free":[],"alarm":[],"pagenation":{"totalcount":1,"thispage":1,"pagesize":-1}}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"221.216.117.150","ua":"jinchangxiao\/2.3.151 (iPhone 12; iOS 18.6.2; Scale\/3.00)"}', FALSE, '2025-12-17 17:09:24') RETURNING "id"

[+] Explain