ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68cb648ce6cc7: POST https://beta.jinchangxiao.com/vue/operation/list at 2025-09-18 09:46:52 am by 114.244.128.96

Database Queries

总计21条数据
TimeDurationTypeQuery
  
09:46:52.9503.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
09:46:52.9572.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
09:46:52.9631.0 msSELECTSELECT "head_of" FROM "a57be577deb434"."tbl_operation_tasks" "s" GROUP BY "s"."id" ORDER BY "head_of"

[+] Explain
09:46:52.9640.7 msSELECTSELECT COUNT(*) FROM (SELECT s.* FROM "a57be577deb434"."tbl_operation_tasks" "s" WHERE "s"."head_of"='1001' GROUP BY "s"."id" ORDER BY "s"."created_at" DESC) "c"

[+] Explain
09:46:52.9650.4 msSELECTSELECT s.* FROM "a57be577deb434"."tbl_operation_tasks" "s" WHERE "s"."head_of"='1001' GROUP BY "s"."id" ORDER BY "s"."created_at" DESC LIMIT 20

[+] Explain
09:46:52.9660.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
09:46:52.9670.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4

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

[+] Explain
09:46:52.9681.0 msSELECTSELECT "operation_task_id", count(*) AS count FROM "a57be577deb434"."tbl_operation_task_contacts" WHERE ("has_follow"=TRUE) AND ("operation_task_id" IN (129, 126, 120, 119)) GROUP BY "operation_task_id"

[+] Explain
09:46:52.9690.8 msSELECTSELECT "operation_task_id", count(*) AS count FROM "a57be577deb434"."tbl_operation_task_contacts" WHERE (("is_complete"=FALSE) OR (is_complete IS NULL)) AND ("operation_task_id" IN (129, 126, 120, 119)) GROUP BY "operation_task_id"

[+] Explain
09:46:52.9700.8 msSELECTSELECT "operation_task_id", count(*) AS count FROM "a57be577deb434"."tbl_operation_task_contacts" WHERE ("is_achieve"=FALSE) AND ("operation_task_id" IN (129, 126, 120, 119)) GROUP BY "operation_task_id"

[+] Explain
09:46:52.9710.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
09:46:52.9720.2 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4

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

[+] Explain
09:46:52.9720.8 msSELECTSELECT "operation_task_id", count(*) AS count FROM "a57be577deb434"."tbl_operation_task_contacts" WHERE "operation_task_id" IN (129, 126, 120, 119) GROUP BY "operation_task_id"

[+] Explain
09:46:52.97321.3 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=22) AND ("object_id" IN (129, 126, 120, 119)) GROUP BY "object_id"

[+] Explain
09:46:52.99517.4 msSELECTSELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=22) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (129, 126, 120, 119)) GROUP BY "object_id"

[+] Explain
09:46:53.0121.0 msSELECTSELECT "id", "user_id", "user_id" AS "key", "operation_task_id" FROM "a57be577deb434"."tbl_operation_task_remind_receivers" WHERE "operation_task_id" IN (129, 126, 120, 119)

[+] Explain
09:46:53.0163.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=22) AND ("visit_date"='2025-09-18')

[+] Explain
09:46:53.0201.2 msINSERTINSERT INTO "a57be577deb434"."tbl_visit_module_histories" ("user_id", "object_type", "visit_date", "num", "last_visit_at") VALUES (1001, 22, '2025-09-18', 1, 'now()') RETURNING "id"

[+] Explain
09:46:53.0211.2 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/operation/list', '{"OperationTaskSearch":{"head_of":"1001","is_complete":""},"Filter":{"name":"created_at","sort":"DESC"},"page":"1","web_access_token":"Hlt1ZmLXNhK2kSIyrIUGksUdIH0iseH7"}', '{"code":2000,"result":{"list":[{"id":129,"title":"\u9001\u793c","target":"\u7ea6\u89c1\u62dc\u8bbf","action":"\u7535\u8bdd","result":"","script":"","is_complete":false,"description":"","complete_at":"","head_of":1001,"created_by":1001,"created_at":"2023-09-13 17:59:22","updated_at":"","remind_day":"","remind_time":"","remind_date":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"},"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"hasfollowContact":{"operation_task_id":129,"count":1},"unCompleteContact":{"operation_task_id":129,"count":97},"unachieveContact":"","headOf":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"},"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"operationTaskContactCount":{"operation_task_id":129,"count":99},"commentCount":{},"unreadComments":{},"operationTaskRemindReceivers":[],"can_complete":false,"can_update":true,"can_delete":true,"bgcolor":"#4993d0"},{"id":126,"title":"\u5411\u5ba2\u6237\u63a8\u8350MSS","target":"\u8bdd\u672f","action":"\u7535\u8bdd","result":"","script":"\u8bdd\u672f","is_complete":false,"description":"","complete_at":"","head_of":1001,"created_by":1001,"created_at":"2023-05-23 11:48:44","updated_at":"2023-05-23 11:53:33","remind_day":"","remind_time":"","remind_date":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"},"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"hasfollowContact":{},"unCompleteContact":{"operation_task_id":126,"count":46},"unachieveContact":"","headOf":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"},"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"operationTaskContactCount":{"operation_task_id":126,"count":48},"commentCount":{},"unreadComments":{},"operationTaskRemindReceivers":[],"can_complete":true,"can_update":true,"can_delete":true,"bgcolor":"#4993d0"},{"id":120,"title":"\u62dc\u8bbf\u5ba2\u6237","target":"\u9001\u793c\u7269","action":"\u6253\u7535\u8bdd","result":"","script":"\u54c8\u54c8","is_complete":true,"description":"","complete_at":"2022-05-26 21:20:57","head_of":1001,"created_by":1001,"created_at":"2022-05-26 21:20:13","updated_at":"2022-05-26 21:20:57","remind_day":"","remind_time":"","remind_date":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"},"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"hasfollowContact":{},"unCompleteContact":{"operation_task_id":120,"count":47},"unachieveContact":"","headOf":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"},"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"operationTaskContactCount":{"operation_task_id":120,"count":50},"commentCount":{},"unreadComments":{},"operationTaskRemindReceivers":[],"can_complete":false,"can_update":true,"can_delete":true,"bgcolor":"#89c541"},{"id":119,"title":"\u516c\u53f8\u4ecb\u7ecd","target":"\u6253\u901a\u7535\u8bdd","action":"\u6253\u901a\u7535\u8bdd","result":"","script":"","is_complete":true,"description":"","complete_at":"2022-05-25 18:41:54","head_of":1001,"created_by":1001,"created_at":"2022-05-25 18:33:49","updated_at":"2022-05-25 18:41:54","remind_day":"","remind_time":"","remind_date":"","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"},"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"hasfollowContact":{},"unCompleteContact":{"operation_task_id":119,"count":21},"unachieveContact":"","headOf":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"},"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"operationTaskContactCount":{"operation_task_id":119,"count":25},"commentCount":{},"unreadComments":{},"operationTaskRemindReceivers":[],"can_complete":false,"can_update":true,"can_delete":true,"bgcolor":"#89c541"}],"can_create":true,"pagenation":{"totalcount":4,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-18 09:46:53') RETURNING "id"

[+] Explain