68c3ce2788e94: POST https://beta.jinchangxiao.com/vue/analysis/approve-data-list at 2025-09-12 03:39:19 pm by 114.246.237.213
Database Queries
总计31条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 15:39:19.575 | 3.3 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 15:39:19.580 | 3.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 15:39:19.587 | 0.8 ms | SELECT | SELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id" |
| 15:39:19.588 | 2.8 ms | SELECT | SELECT COUNT(*) FROM (SELECT "r".* FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = r.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON project.id = r.project_id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 WHERE (r.status != 0) AND ("r"."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 (("r"."status"='1')) ORDER BY "r"."created_at" DESC) "c" |
| 15:39:19.591 | 1.5 ms | SELECT | SELECT "r".* FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = r.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON project.id = r.project_id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 WHERE (r.status != 0) AND ("r"."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 (("r"."status"='1')) ORDER BY "r"."created_at" DESC LIMIT 20 |
| 15:39:19.593 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446 |
| 15:39:19.593 | 0.4 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5446) |
| 15:39:19.594 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=8 |
| 15:39:19.594 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=2236 |
| 15:39:19.595 | 0.3 ms | SELECT | SELECT "id", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=17) AND ("id" IN (5, 1, 2, 229, 153, 184, 189, 316, 349)) |
| 15:39:19.595 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_approve_carbon_copy_rels" WHERE "approve_id"=2236 |
| 15:39:19.596 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 5388) |
| 15:39:19.596 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5388, 1013)) |
| 15:39:19.596 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE "approve_id"=2236 ORDER BY "id" |
| 15:39:19.597 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 15:39:19.597 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001) |
| 15:39:19.598 | 2.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=30) AND ("object_id"=2930) |
| 15:39:19.600 | 1.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=31) AND ("object_id"=2930) |
| 15:39:19.602 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status"=0) AND ("approve_id"=2236) ORDER BY "id" |
| 15:39:19.602 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 15:39:19.602 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001) |
| 15:39:19.603 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status" != 0) AND ("approve_id"=2236) ORDER BY "id" |
| 15:39:19.603 | 1.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=28) AND ("object_id"=2236) |
| 15:39:19.605 | 1.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=29) AND ("object_id"=2236) |
| 15:39:19.607 | 20.1 ms | SELECT | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=37) AND ("object_id"=2236) GROUP BY "object_id" |
| 15:39:19.627 | 16.4 ms | SELECT | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=37) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id"=2236) GROUP BY "object_id" |
| 15:39:19.643 | 19.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=37) AND ("object_id"=2236) |
| 15:39:19.663 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5446 |
| 15:39:19.664 | 3.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-09-12') |
| 15:39:19.668 | 0.9 ms | UPDATE | UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=147, "last_visit_at"='now()' WHERE "id"=56539 |
| 15:39:19.669 | 1.4 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/approve-data-list', '{"status":["1"],"keyword":"","timeType":"year","page":"1","to":"","from":"","web_access_token":"2BZqbE639wqIoHhgH0VfUgn-meZYtkbz"}', '{"code":2000,"result":{"list":[{"id":2236,"client_id":"","project_id":"","title":"\u5b9d\u8d1d\u5b9d\u8d1d","status":1,"next_verify_user":1001,"verify_at":"","description":"\u82b1\u955c\u5a1c\u5a1c","refuse_description":"","is_resubmited":false,"created_by":5446,"created_at":"2025-09-12 14:01:11","updated_at":"2025-09-12 14:01:32","supplier_id":"","purchase_contract_id":"","amount":"","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":"","createdBy":{"id":5446,"key":5446,"name":"\u5218\u5a1f","sex":"F","department_id":8,"avatar":{"id":164,"user_id":5446,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5631bbfb-fa6e-308e-b87c-b159e8042209.jpg"},"department":{"id":8,"key":8,"name":"\u4eba\u529b\u8d44\u6e90"}},"client":{},"project":{},"supplier":"","purchaseContract":"","type":{"id":316,"name":"\u63d0\u6b3e\u7533\u8bf7"},"approveCarbonCopyRels":[{"id":7915,"approve_id":2236,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}},{"id":7916,"approve_id":2236,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}}],"approveVerifyRels":[{"id":2930,"approve_id":2236,"user_id":1001,"status":0,"description":"","verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{"id":2930,"approve_id":2236,"user_id":1001,"status":0,"description":"","verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"haveApproveVerifyRel":"","attachmentRelationships":[],"files":[],"commentCount":{"object_id":2236,"comment":2},"unreadComments":{"object_id":2236,"unread":1},"comments":[{"id":191273,"object_id":2236,"object_type":"37","parent":"","description":"\u5218\u5a1f \u6709\u4e00\u4e2a\u5ba1\u6279\u9700\u8981\u5ba1\u6279","created_by":5446,"created_at":"2025-09-12 14:01:11","reply_to":"","is_system":true,"for_user":"","description2":"\u5b9d\u8d1d\u5b9d\u8d1d","createdBy":{"id":5446,"email":"liujuan@toast.com.cn","name":"\u5218\u5a1f","user_status":"1","pinyin_shortcut":"lj","sex":"F","birth_date":"1987-10-04","entry_date":"2025-03-03","department_id":8,"department_position_id":61,"mobile":"15699735973","telephone":"88864628","created_at":"2025-03-03 10:55:13","updated_at":"2025-03-03 10:55:13","id_number":"413026198710047225","native_place":"\u7518\u8083\u7701\u5609\u5cea\u5173\u5e02","graduate_school":"\u5317\u4eac\u4e1c\u65b9\u5927\u5b66","specialty":"\u5de5\u5546\u4f01\u4e1a\u7ba1\u7406","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"","leave_date":"","pinyin1":"liu","pinyin2":"juan","pinyin3":"","pinyin4":"","namecut1":"\u5218","namecut2":"\u5a1f","namecut3":"","namecut4":"","budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":false,"client_remind_alarm_before":"","work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true}},{"id":191274,"object_id":2236,"object_type":"37","parent":"","description":"\u5218\u5a1f \u6709\u4e00\u4e2a\u5ba1\u6279\u9700\u8981\u5ba1\u6279","created_by":5446,"created_at":"2025-09-12 14:01:32","reply_to":"","is_system":true,"for_user":"","description2":"\u5b9d\u8d1d\u5b9d\u8d1d","createdBy":{"id":5446,"email":"liujuan@toast.com.cn","name":"\u5218\u5a1f","user_status":"1","pinyin_shortcut":"lj","sex":"F","birth_date":"1987-10-04","entry_date":"2025-03-03","department_id":8,"department_position_id":61,"mobile":"15699735973","telephone":"88864628","created_at":"2025-03-03 10:55:13","updated_at":"2025-03-03 10:55:13","id_number":"413026198710047225","native_place":"\u7518\u8083\u7701\u5609\u5cea\u5173\u5e02","graduate_school":"\u5317\u4eac\u4e1c\u65b9\u5927\u5b66","specialty":"\u5de5\u5546\u4f01\u4e1a\u7ba1\u7406","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"","leave_date":"","pinyin1":"liu","pinyin2":"juan","pinyin3":"","pinyin4":"","namecut1":"\u5218","namecut2":"\u5a1f","namecut3":"","namecut4":"","budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":false,"client_remind_alarm_before":"","work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true}}],"bgcolor":"#00B7EE","status_display":"\u5ba1\u6279\u4e2d"}],"pagenation":{"totalcount":1,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-12 15:39:19') RETURNING "id" |