ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a1aa1c319cf9: POST https://beta.jinchangxiao.com/v2/user/get-index at 2026-05-30 04:37:23 pm by 139.159.170.86

Database Queries

总计22条数据
TimeDurationTypeQuery
  
16:37:23.1070.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='ONv_OQ6eSOxFL2I62K1e82WGipv8fS1S'

[+] Explain
16:37:23.1090.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
16:37:23.11018.8 msSELECTSELECT COUNT(*) FROM "a57be577deb434"."tbl_unread_comments" WHERE ("remind_user_id"=1000) AND ("is_read"=FALSE) AND ("object_type" <> 20030)

[+] Explain
16:37:23.12818.3 msSELECTSELECT count(*) as count, object_type FROM "a57be577deb434"."tbl_unread_comments" WHERE ("remind_user_id"=1000) AND (is_read = false) GROUP BY "object_type"

[+] Explain
16:37:23.1490.3 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"

[+] Explain
16:37:23.1500.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
16:37:23.1510.2 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"

[+] Explain
16:37:23.1510.2 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"

[+] Explain
16:37:23.1512.0 msSELECTSELECT DISTINCT date_trunc('day', generate_series( GREATEST(start_at::date, '2026-05-01'::date), LEAST(end_at::date, '2026-05-31'::date), '1 day' ))::date AS used_date FROM "a57be577deb434"."tbl_calendars" WHERE ("created_by"=1000) AND (NOT ("start_at" IS NULL)) AND (NOT ("end_at" IS NULL)) AND ("start_at" <= '2026-05-31') AND ("end_at" >= '2026-05-01')

[+] Explain
16:37:23.1540.6 msSELECTSELECT DISTINCT date_trunc('day', generate_series( GREATEST(s_at::date, '2026-05-01'::date), LEAST(e_at::date, '2026-05-31'::date), '1 day' ))::date AS used_date 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 ("created_by"=1000) AND ("s_at" <= '2026-05-31') AND ("e_at" >= '2026-05-01')

[+] Explain
16:37:23.1540.4 msSELECTSELECT DISTINCT date_trunc('day', generate_series( GREATEST(start_at::date, '2026-05-01'::date), LEAST(end_at::date, '2026-05-31'::date), '1 day' ))::date AS used_date FROM "a57be577deb434"."tbl_work_logs" WHERE ("created_by"=1000) AND (NOT ("start_at" IS NULL)) AND (NOT ("end_at" IS NULL)) AND ("is_draft"=FALSE) AND ("start_at" <= '2026-05-31') AND ("end_at" >= '2026-05-01')

[+] Explain
16:37:23.1551.7 msSELECTSELECT DISTINCT date_trunc('day', generate_series( GREATEST(start_at::date, '2026-05-01'::date), LEAST(end_at::date, '2026-05-31'::date), '1 day' ))::date AS alarm_date FROM "a57be577deb434"."tbl_calendars" WHERE ("created_by"=1000) AND (NOT ("start_at" IS NULL)) AND (NOT ("alarm_before" IS NULL)) AND ("start_at" <= '2026-05-31') AND ("end_at" >= '2026-05-01') AND (start_at - alarm_before > now())

[+] Explain
16:37:23.1570.8 msSELECTSELECT DISTINCT date_trunc('day', generate_series( GREATEST(s_at::date, '2026-05-01'::date), LEAST(e_at::date, '2026-05-31'::date), '1 day' ))::date AS alarm_date 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 ("created_by"=1000) AND (NOT ("alarm_before" IS NULL)) AND ("s_at" <= '2026-05-31') AND ("e_at" >= '2026-05-01') AND (s_at - alarm_before > now())

[+] Explain
16:37:23.1582.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" >= '2026-05-30 00:00:00') AND ("w"."end_at" < '2026-05-30 23:59:59')) OR (("w"."start_at" <= '2026-05-30 00:00:00') AND ("w"."end_at" > '2026-05-30 00:00:00')) OR (("w"."start_at" <= '2026-05-30 23:59:59') AND ("w"."end_at" > '2026-05-30 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"=1000) 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, 5446, 5449, 5461, 5476))) 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" >= '2026-05-30 00:00:00') AND ("s"."e_at" < '2026-05-30 23:59:59')) OR (("s"."s_at" <= '2026-05-30 00:00:00') AND ("s"."e_at" > '2026-05-30 00:00:00')) OR (("s"."s_at" <= '2026-05-30 23:59:59') AND ("s"."e_at" > '2026-05-30 23:59:59'))) AND ("s"."created_by"=1000) 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, 5449, 5461, 5476))) 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" >= '2026-05-30 00:00:00') AND ("c"."end_at" < '2026-05-30 23:59:59')) OR (("c"."start_at" <= '2026-05-30 00:00:00') AND ("c"."end_at" > '2026-05-30 00:00:00')) OR (("c"."start_at" <= '2026-05-30 23:59:59') AND ("c"."end_at" > '2026-05-30 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, 5446, 5449, 5461, 5476)) AND ("c"."created_by"=1000) ) )) "w" ORDER BY "start_at") "c"

[+] Explain
16:37:23.1612.7 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" >= '2026-05-30 00:00:00') AND ("w"."end_at" < '2026-05-30 23:59:59')) OR (("w"."start_at" <= '2026-05-30 00:00:00') AND ("w"."end_at" > '2026-05-30 00:00:00')) OR (("w"."start_at" <= '2026-05-30 23:59:59') AND ("w"."end_at" > '2026-05-30 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"=1000) 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, 5446, 5449, 5461, 5476))) 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" >= '2026-05-30 00:00:00') AND ("s"."e_at" < '2026-05-30 23:59:59')) OR (("s"."s_at" <= '2026-05-30 00:00:00') AND ("s"."e_at" > '2026-05-30 00:00:00')) OR (("s"."s_at" <= '2026-05-30 23:59:59') AND ("s"."e_at" > '2026-05-30 23:59:59'))) AND ("s"."created_by"=1000) 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, 5449, 5461, 5476))) 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" >= '2026-05-30 00:00:00') AND ("c"."end_at" < '2026-05-30 23:59:59')) OR (("c"."start_at" <= '2026-05-30 00:00:00') AND ("c"."end_at" > '2026-05-30 00:00:00')) OR (("c"."start_at" <= '2026-05-30 23:59:59') AND ("c"."end_at" > '2026-05-30 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, 5446, 5449, 5461, 5476)) AND ("c"."created_by"=1000) ) )) "w" ORDER BY "start_at"

[+] Explain
16:37:23.1640.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
16:37:23.1650.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10

[+] Explain
16:37:23.1650.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)

[+] Explain
16:37:23.1652.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=26) AND ("object_id" IN (278125, 278064))

[+] Explain
16:37:23.1680.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND (0=1)

[+] Explain
16:37:23.1680.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND (0=1)

[+] Explain
16:37:23.1690.9 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 6, 176, 'v2/user/get-index', '{"posttime":"1780130242","access_token":"ONv_OQ6eSOxFL2I62K1e82WGipv8fS1S","device_type":"6","version_code":"176","token":"39cef3701b0f0152ba2ef7e11ded99da"}', '{"code":200,"data":{"announcementUnread":{"count":0},"unread":[],"calendar":{"list":[{"id":278125,"title":"1","client_id":null,"created_by":1000,"start_at":"2026-05-30 15:38:17","end_at":"2026-05-30 16:38:17","type":1,"is_alarm":false,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"}},"client":null,"start_at_display":"15:38","end_at_display":"16:38","can_update":true,"can_delete":true,"attachmentRelationships":[]},{"id":278064,"title":"1","client_id":null,"created_by":1000,"start_at":"2026-05-30 15:39:50","end_at":"2026-05-30 16:39:50","type":1,"is_alarm":false,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"}},"client":null,"start_at_display":"15:39","end_at_display":"16:39","can_update":true,"can_delete":true,"attachmentRelationships":[]}],"point":[{"edate":"2026-05-31","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-30","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-29","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-28","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-27","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-26","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-25","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-24","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-23","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-22","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-21","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-20","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-19","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-18","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-17","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-16","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-15","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-14","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-13","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-12","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-11","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-10","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-09","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-08","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-07","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-06","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-05","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-04","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-03","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-02","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-05-01","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false}],"free":[],"alarm":[{"edate":"2026-05-31","is_alarm":false},{"edate":"2026-05-30","is_alarm":false},{"edate":"2026-05-29","is_alarm":false},{"edate":"2026-05-28","is_alarm":false},{"edate":"2026-05-27","is_alarm":false},{"edate":"2026-05-26","is_alarm":false},{"edate":"2026-05-25","is_alarm":false},{"edate":"2026-05-24","is_alarm":false},{"edate":"2026-05-23","is_alarm":false},{"edate":"2026-05-22","is_alarm":false},{"edate":"2026-05-21","is_alarm":false},{"edate":"2026-05-20","is_alarm":false},{"edate":"2026-05-19","is_alarm":false},{"edate":"2026-05-18","is_alarm":false},{"edate":"2026-05-17","is_alarm":false},{"edate":"2026-05-16","is_alarm":false},{"edate":"2026-05-15","is_alarm":false},{"edate":"2026-05-14","is_alarm":false},{"edate":"2026-05-13","is_alarm":false},{"edate":"2026-05-12","is_alarm":false},{"edate":"2026-05-11","is_alarm":false},{"edate":"2026-05-10","is_alarm":false},{"edate":"2026-05-09","is_alarm":false},{"edate":"2026-05-08","is_alarm":false},{"edate":"2026-05-07","is_alarm":false},{"edate":"2026-05-06","is_alarm":false},{"edate":"2026-05-05","is_alarm":false},{"edate":"2026-05-04","is_alarm":false},{"edate":"2026-05-03","is_alarm":false},{"edate":"2026-05-02","is_alarm":false},{"edate":"2026-05-01","is_alarm":false}],"pagenation":{"totalcount":2,"thispage":1,"pagesize":-1}}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"139.159.170.86","ua":"jinchangxiao\/1.0.40 (HUAWEI Mate 80 Pro SGT-AL50; HarmonyOS 6.1.0)"}', FALSE, '2026-05-30 16:37:23', 63378176) RETURNING "id"

[+] Explain