6863838fc2231: POST https://beta.jinchangxiao.com/v2/schedule/get-filter at 2025-07-01 02:43:27 pm by 223.104.41.148
Database Queries
总计10条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 14:43:27.799 | 3.1 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b' |
| 14:43:27.803 | 1.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 |
| 14:43:27.807 | 1.0 ms | SELECT | SELECT distinct s.created_by FROM "a57be577deb434"."tbl_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE "ccr"."user_id"=5295 |
| 14:43:27.810 | 1.3 ms | SELECT | SELECT "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"=5295) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name" |
| 14:43:27.811 | 1.0 ms | SELECT | SELECT "d"."id" FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN "a57be577deb434"."tbl_departments" "d" ON u.department_id = d.id WHERE ("user_status"='1') AND (("u"."id" IN (5300, 5295, 5295)) OR ("u"."id"=5413)) GROUP BY "u"."id", "d"."id", "d"."order" ORDER BY "d"."order" |
| 14:43:27.812 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (1, 1) ORDER BY "order" |
| 14:43:27.813 | 0.7 ms | SELECT | SELECT "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"=5295) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name" |
| 14:43:27.814 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name", "department_id", "pinyin_shortcut" FROM "a57be577deb434"."tbl_users" WHERE ("user_status"='1') AND (("id" IN (5300, 5295, 5295)) OR ("id"=5413)) AND ("department_id"=1) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first |
| 14:43:27.814 | 0.4 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5300, 5295)) |
| 14:43:27.816 | 1.5 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5295, 2, 1141, 'v2/schedule/get-filter', '{"access_token":"aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b","device_type":"2","posttime":"1751352192","token":"e7a2a09547dddf3f47e675b00e6b7626","version_code":"1141"}', '{"code":200,"data":[{"key":"ScheduleSearch[status]","name":"\u72b6\u6001","value":[{"key":"completed","name":"\u5df2\u5b8c\u6210"},{"key":"ongoing","name":"\u8fdb\u884c\u4e2d"},{"key":"overdue","name":"\u5df2\u903e\u671f"}],"default":""},{"key":"ScheduleSearch[department_id]","name":"\u90e8\u95e8\/\u8d1f\u8d23\u4eba","value":[{"id":1,"key":1,"name":"\u9500\u552e\u90e8","child":[{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","department_id":1,"pinyin_shortcut":"sqy","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","department_id":1,"pinyin_shortcut":"wzw","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}]}],"default":5295,"itemKey":"ScheduleSearch[created_by]"}],"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-01 14:43:27') RETURNING "id" |